{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Summary","WR","WR (2)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Summary"]
[null,null,null,"Total","I'd like the total value shown here from WR",9683.2999999999993]
[null,null,null,null,"And here for other tabs from WR (2)",14458.4]

{"sheet":"WR","index":1,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[[28,0,31,0],[28,1,31,2],[28,3,31,5],[33,0,39,5],[21,0,21,1],[23,3,23,5],[24,0,25,0],[24,1,25,2],[24,3,25,5],[26,0,27,0],[26,1,27,2],[26,3,27,5],[20,0,20,1],[0,3,0,5],[1,3,1,5],[2,3,2,5],[3,3,3,5],[5,0,6,1],[7,0,8,1],[9,0,11,1],[12,0,14,1],[15,0,19,1]]}
[]
[]
[]
[]
["Cost Breakdown"]
["Work Description",null,"Allocated","Time","Rate","Cost"]
[null,null,"Resource","(hours)","(p/hr)"]
["Barry",null,null,2,55,{"$f":"E8*D8","v":110}]
[null,null,null,8,66,{"$f":"E9*D9","v":528}]
["John",null,null,5,44]
[null,null,null,5,77,{"$f":"E11*D11","v":385}]
[null,null,null,{"$f":"SUMIF($C:$C,C12,$B:$B)","v":0},99,0]
["Peter",null,null,2,97.9,195.8]
[null,null,null,5,107.8,539]
[null,null,null,0,117.7,0]
["Dave",null,null,2,127.6,255.2]
[null,null,null,5,137.5,687.5]
[null,null,null,8,147.4,1179.2]
[null,null,null,8,157.30000000000001,1258.4000000000001]
[null,null,null,6,167.2,1003.1999999999999]
["Burt",null,null,20000,177.1,{"$f":"E21*D21/1000","v":3542}]
[null,null,null,"Ex VAT","TOTAL",{"$f":"SUM(F8:G21)","v":9683.2999999999993}]
["Roles and Responsibilities"]
["Team","Role and responsibilities",null,"Contact Info"]
["Programme Manager"]
[]
["Campaign Associate"]
[]
["Campaign Manager"]
[]
[]
[]
["Caveats"]
[]
[]
[]
[]
[]
[]
[]
["The above work/ cost has been approved:","Agreed by:"]
[null,"Date:"]
[]
[]
["The work has been requested to commence:","Date:"]
["Private and Confidential"]

{"sheet":"WR (2)","index":2,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[[5,0,6,1],[7,0,8,1],[23,3,23,5],[0,3,0,5],[1,3,1,5],[2,3,2,5],[3,3,3,5],[9,0,11,1],[12,0,14,1],[15,0,19,1],[20,0,20,1],[21,0,21,1],[28,0,31,0],[28,1,31,2],[28,3,31,5],[33,0,39,5],[24,0,25,0],[24,1,25,2],[24,3,25,5],[26,0,27,0],[26,1,27,2],[26,3,27,5]]}
[]
[]
[]
[]
["Cost Breakdown"]
["Work Description",null,"Allocated","Time","Rate","Cost"]
[null,null,"Resource","(hours)","(p/hr)"]
["Barry",null,null,5,147.4,{"$f":"E8*D8","v":737}]
[null,null,null,4,157.30000000000001,{"$f":"E9*D9","v":629.20000000000005}]
["John",null,null,2,167.2]
[null,null,null,6,177.1,{"$f":"E11*D11","v":1062.5999999999999}]
[null,null,null,8,99,792]
["Peter",null,null,2,147.4,294.8]
[null,null,null,4,157.30000000000001,629.20000000000005]
[null,null,null,6,167.2,1003.1999999999999]
["Dave",null,null,4,177.1,708.4]
[null,null,null,25,137.5,3437.5]
[null,null,null,{"$f":"SUMIF($C:$C,C18,$B:$B)","v":0},147.4,0]
[null,null,null,5,157.30000000000001,786.5]
[null,null,null,5,167.2,836]
["Burt",null,null,20000,177.1,{"$f":"E21*D21/1000","v":3542}]
[null,null,null,"Ex VAT","TOTAL",{"$f":"SUM(F8:G21)","v":14458.4}]
["Roles and Responsibilities"]
["Team","Role and responsibilities",null,"Contact Info"]
["Programme Manager"]
[]
["Campaign Associate"]
[]
["Campaign Manager"]
[]
[]
[]
["Caveats"]
[]
[]
[]
[]
[]
[]
[]
["The above work/ cost has been approved:","Agreed by:"]
[null,"Date:"]
[]
[]
["The work has been requested to commence:","Date:"]
["Private and Confidential"]