{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Estimate","Rates"],"not_rendered":{"charts":0,"images":1,"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":"Estimate","index":0,"n_rows":84,"n_cols":17,"rows_kept":84,"cut":false,"hidden":false,"merged":[[25,10,25,11],[77,8,77,9],[78,8,78,9],[79,8,79,9],[80,8,80,9],[5,0,5,1],[15,0,15,1],[24,0,24,1],[81,8,81,9],[82,8,82,9],[25,4,25,9]]}
[]
[null,null,"SAMPLE - JOB QUOTE FOR HOUSE EXTENSION  ",null,null,null,null,null,null,null,null,"Ian Linnegan Mob 07973 330324",null,null,null,"website"]
[]
[]
[]
["PRELIMS",null,null,null,null,"TENDER SUMMARY:",null,null,"£"]
[null,null,null,null,null,1,"PRELIMS",null,{"$f":"C68","v":5919},null,"Notes "]
[1,"GENERAL",480,null,null,2,"SPECIFICATION",null,{"$f":"C20","v":610},null,1,"ONLY mark or update the items on the sheet shown in yellow"]
[2,"PROTECT",350,null,null,3,"WORK ITEMS",null,{"$f":"C70","v":37936.799999999996},null,2,"Adjust wage rates/markup links on the second worksheet - adjust as required"]
[3,"RUBBISH",1500,null,null,"CONTRACT SUM",null,null,{"$f":"SUM(I7:I9)","v":44465.799999999996},null,3,"Add other items in the work column as required "]
[4,"PLANT",1900,null,null,null,null,null,null,null,4,"Grey areas will be automatically filled as data is entered (do not enter figures here)"]
[5,"SCAFFOLD",1200,null,null,"PROFIT ESTIMATE (see analysis below) £",null,null,{"$f":"Q64","v":6322.7999999999975}]
[6,"OTHER",489]
["SUB TOTAL",null,{"$f":"SUM(C8:C13)","v":5919}]
[]
["SPECIFICATION"]
[1,"GENERAL",0]
[2,"DAYWORK",160]
[3,"PROV SUM (if any)",450]
["TOTAL",null,{"$f":"SUM(C17:C19)","v":610}]
[null,null,null,null,null,null,null,null,null,null,null,null,"ANALYSYS"]
["WORK ITEMS (see list below) ",null,{"$f":"C64","v":37936.799999999996}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"LAB + MAT"]
["WORK ITEMS",null,null,null,"CARPENTER","BRICKLAYER","PLASTERER","LABOURER","PAINTER","OTHER","MATERIALS","SUBC","LABOUR","& SUB","MARK UP","TENDER","PROFIT"]
[null,null,null,null,"Enter the number of days below",null,null,null,null,null,"Enter Totals"]
[{"$f":"A26+1","v":1},"Foundations",{"$f":"P27","v":3454.7999999999997},null,16,2,4,null,null,null,1569,200,{"$f":"(E27*Rates!C$8)+(F27*Rates!C$9)+(G27*Rates!C$10)+(H27*Rates!C$11)+(I27*Rates!C$12)+(J27*Rates!C$13)","v":1110},{"$f":"SUM(K27:M27)","v":2879},{"$f":"Rates!$C$4","v":20},{"$f":"(100+O27)%*N27","v":3454.7999999999997},{"$f":"P27-N27","v":575.79999999999973}]
[2,"Blockwork to DPC ",{"$f":"P28","v":2718},null,18,null,10,null,null,null,805,null,{"$f":"(E28*Rates!C$8)+(F28*Rates!C$9)+(G28*Rates!C$10)+(H28*Rates!C$11)+(I28*Rates!C$12)+(J28*Rates!C$13)","v":1460},{"$f":"SUM(K28:M28)","v":2265},{"$f":"Rates!$C$4","v":20},2718,453]
[3,"Drainage",4005.6,null,null,20,null,10,null,null,1388,null,{"$f":"(E29*Rates!C$8)+(F29*Rates!C$9)+(G29*Rates!C$10)+(H29*Rates!C$11)+(I29*Rates!C$12)+(J29*Rates!C$13)","v":1950},3338,{"$f":"Rates!$C$4","v":20},4005.6,667.59999999999991]
[4,"Oversite",2449.1999999999998,null,4,2,null,null,5,null,1456,null,{"$f":"(E30*Rates!C$8)+(F30*Rates!C$9)+(G30*Rates!C$10)+(H30*Rates!C$11)+(I30*Rates!C$12)+(J30*Rates!C$13)","v":585},2041,{"$f":"Rates!$C$4","v":20},2449.1999999999998,408.19999999999982]
[5,"External walls brickwork",7473.5999999999995,null,34,null,34,null,null,null,2488,null,{"$f":"(E31*Rates!C$8)+(F31*Rates!C$9)+(G31*Rates!C$10)+(H31*Rates!C$11)+(I31*Rates!C$12)+(J31*Rates!C$13)","v":3740},6228,{"$f":"Rates!$C$4","v":20},7473.5999999999995,1245.5999999999995]
[6,"Windows",3726,null,null,5,null,null,null,null,2780,null,{"$f":"(E32*Rates!C$8)+(F32*Rates!C$9)+(G32*Rates!C$10)+(H32*Rates!C$11)+(I32*Rates!C$12)+(J32*Rates!C$13)","v":325},3105,{"$f":"Rates!$C$4","v":20},3726,621]
[7,"Rendering",1651.2,null,4,null,null,4,null,null,936,null,{"$f":"(E33*Rates!C$8)+(F33*Rates!C$9)+(G33*Rates!C$10)+(H33*Rates!C$11)+(I33*Rates!C$12)+(J33*Rates!C$13)","v":440},1376,{"$f":"Rates!$C$4","v":20},1651.2,275.20000000000005]
[8,"Roof",4210.8,null,null,null,5,null,null,4,2884,null,{"$f":"(E34*Rates!C$8)+(F34*Rates!C$9)+(G34*Rates!C$10)+(H34*Rates!C$11)+(I34*Rates!C$12)+(J34*Rates!C$13)","v":625},3509,{"$f":"Rates!$C$4","v":20},4210.8,701.80000000000018]
[{"$f":"A34+1","v":9},"First Fix Electrical",748.8,null,null,null,null,6,null,null,234,null,{"$f":"(E35*Rates!C$8)+(F35*Rates!C$9)+(G35*Rates!C$10)+(H35*Rates!C$11)+(I35*Rates!C$12)+(J35*Rates!C$13)","v":390},624,{"$f":"Rates!$C$4","v":20},748.8,124.79999999999995]
[10,"Plastering",1609.2,null,4,5,null,null,null,null,836,null,{"$f":"(E36*Rates!C$8)+(F36*Rates!C$9)+(G36*Rates!C$10)+(H36*Rates!C$11)+(I36*Rates!C$12)+(J36*Rates!C$13)","v":505},1341,{"$f":"Rates!$C$4","v":20},1609.2,268.20000000000005]
[11,"Second fix electrical",895.19999999999993,null,null,null,null,null,null,4,446,null,{"$f":"(E37*Rates!C$8)+(F37*Rates!C$9)+(G37*Rates!C$10)+(H37*Rates!C$11)+(I37*Rates!C$12)+(J37*Rates!C$13)","v":300},746,{"$f":"Rates!$C$4","v":20},895.19999999999993,149.19999999999993]
[12,"First Fix Plumbing",1359.6,null,null,null,null,6,null,null,743,null,{"$f":"(E38*Rates!C$8)+(F38*Rates!C$9)+(G38*Rates!C$10)+(H38*Rates!C$11)+(I38*Rates!C$12)+(J38*Rates!C$13)","v":390},1133,{"$f":"Rates!$C$4","v":20},1359.6,226.59999999999991]
[13,"Second fix plumbing",2548.7999999999997,null,null,null,null,5,1,null,1744,null,{"$f":"(E39*Rates!C$8)+(F39*Rates!C$9)+(G39*Rates!C$10)+(H39*Rates!C$11)+(I39*Rates!C$12)+(J39*Rates!C$13)","v":380},2124,{"$f":"Rates!$C$4","v":20},2548.7999999999997,424.79999999999973]
[14,"Kitchen fit out",1086,null,2,6,null,3,null,null,230,null,{"$f":"(E40*Rates!C$8)+(F40*Rates!C$9)+(G40*Rates!C$10)+(H40*Rates!C$11)+(I40*Rates!C$12)+(J40*Rates!C$13)","v":675},905,{"$f":"Rates!$C$4","v":20},1086,181]
[15,"Gas Oven ",0,null,null,null,null,null,null,null,null,null,{"$f":"(E41*Rates!C$8)+(F41*Rates!C$9)+(G41*Rates!C$10)+(H41*Rates!C$11)+(I41*Rates!C$12)+(J41*Rates!C$13)","v":0},0,{"$f":"Rates!$C$4","v":20},0,0]
[16,null,0,null,null,null,null,null,null,null,null,null,{"$f":"(E42*Rates!C$8)+(F42*Rates!C$9)+(G42*Rates!C$10)+(H42*Rates!C$11)+(I42*Rates!C$12)+(J42*Rates!C$13)","v":0},0,{"$f":"Rates!$C$4","v":20},0,0]
[17,null,0,null,null,null,null,null,null,null,null,null,{"$f":"(E43*Rates!C$8)+(F43*Rates!C$9)+(G43*Rates!C$10)+(H43*Rates!C$11)+(I43*Rates!C$12)+(J43*Rates!C$13)","v":0},0,{"$f":"Rates!$C$4","v":20},0,0]
[{"$f":"A43+1","v":18},null,0,null,null,null,null,null,null,null,null,null,{"$f":"(E44*Rates!C$8)+(F44*Rates!C$9)+(G44*Rates!C$10)+(H44*Rates!C$11)+(I44*Rates!C$12)+(J44*Rates!C$13)","v":0},0,{"$f":"Rates!$C$4","v":20},0,0]
[{"$f":"A44+1","v":19},null,0,null,null,null,null,null,null,null,null,null,{"$f":"(E45*Rates!C$8)+(F45*Rates!C$9)+(G45*Rates!C$10)+(H45*Rates!C$11)+(I45*Rates!C$12)+(J45*Rates!C$13)","v":0},0,{"$f":"Rates!$C$4","v":20},0,0]
[{"$f":"A45+1","v":20},null,0,null,null,null,null,null,null,null,null,null,{"$f":"(E46*Rates!C$8)+(F46*Rates!C$9)+(G46*Rates!C$10)+(H46*Rates!C$11)+(I46*Rates!C$12)+(J46*Rates!C$13)","v":0},0,{"$f":"Rates!$C$4","v":20},0,0]
[{"$f":"A46+1","v":21},null,0,null,null,null,null,null,null,null,null,null,{"$f":"(E47*Rates!C$8)+(F47*Rates!C$9)+(G47*Rates!C$10)+(H47*Rates!C$11)+(I47*Rates!C$12)+(J47*Rates!C$13)","v":0},0,{"$f":"Rates!$C$4","v":20},0,0]
[22," ",0,null,null,null,null,null,null,null,null,null,{"$f":"(E48*Rates!C$8)+(F48*Rates!C$9)+(G48*Rates!C$10)+(H48*Rates!C$11)+(I48*Rates!C$12)+(J48*Rates!C$13)","v":0},0,{"$f":"Rates!$C$4","v":20},0,0]
[23,null,0,null,null,null,null,null,null,null,null,null,{"$f":"(E49*Rates!C$8)+(F49*Rates!C$9)+(G49*Rates!C$10)+(H49*Rates!C$11)+(I49*Rates!C$12)+(J49*Rates!C$13)","v":0},0,{"$f":"Rates!$C$4","v":20},0,0]
[24,null,0,null,null,null,null,null,null,null,null,null,{"$f":"(E50*Rates!C$8)+(F50*Rates!C$9)+(G50*Rates!C$10)+(H50*Rates!C$11)+(I50*Rates!C$12)+(J50*Rates!C$13)","v":0},0,{"$f":"Rates!$C$4","v":20},0,0]
[25,null,0,null,null,null,null,null,null,null,null,null,{"$f":"(E51*Rates!C$8)+(F51*Rates!C$9)+(G51*Rates!C$10)+(H51*Rates!C$11)+(I51*Rates!C$12)+(J51*Rates!C$13)","v":0},0,{"$f":"Rates!$C$4","v":20},0,0]
[26,null,{"$f":"P52","v":0},null,null,null,null,null,null,null,null,null,{"$f":"(E52*Rates!C$8)+(F52*Rates!C$9)+(G52*Rates!C$10)+(H52*Rates!C$11)+(I52*Rates!C$12)+(J52*Rates!C$13)","v":0},0,{"$f":"Rates!$C$4","v":20},0,0]
[27,null,0,null,null,null,null,null,null,null,null,null,{"$f":"(E53*Rates!C$8)+(F53*Rates!C$9)+(G53*Rates!C$10)+(H53*Rates!C$11)+(I53*Rates!C$12)+(J53*Rates!C$13)","v":0},0,{"$f":"Rates!$C$4","v":20},0,0]
[28,null,0,null,null,null,null,null,null,null,null,null,{"$f":"(E54*Rates!C$8)+(F54*Rates!C$9)+(G54*Rates!C$10)+(H54*Rates!C$11)+(I54*Rates!C$12)+(J54*Rates!C$13)","v":0},0,{"$f":"Rates!$C$4","v":20},0,0]
[29,null,{"$f":"P55","v":0},null,null,null,null,null,null,null,null,null,{"$f":"(E55*Rates!C$8)+(F55*Rates!C$9)+(G55*Rates!C$10)+(H55*Rates!C$11)+(I55*Rates!C$12)+(J55*Rates!C$13)","v":0},0,{"$f":"Rates!$C$4","v":20},{"$f":"(100+O55)%*N55","v":0},{"$f":"P55-N55","v":0}]
[30,null,0,null,null,null,null,null,null,null,null,null,{"$f":"(E56*Rates!C$8)+(F56*Rates!C$9)+(G56*Rates!C$10)+(H56*Rates!C$11)+(I56*Rates!C$12)+(J56*Rates!C$13)","v":0},0,{"$f":"Rates!$C$4","v":20},0,0]
[null,null,0,null,null,null,null,null,null,null,null,null,{"$f":"(E57*Rates!C$8)+(F57*Rates!C$9)+(G57*Rates!C$10)+(H57*Rates!C$11)+(I57*Rates!C$12)+(J57*Rates!C$13)","v":0},0,{"$f":"Rates!$C$4","v":20},0,0]
[null,null,0,null,null,null,null,null,null,null,null,null,{"$f":"(E58*Rates!C$8)+(F58*Rates!C$9)+(G58*Rates!C$10)+(H58*Rates!C$11)+(I58*Rates!C$12)+(J58*Rates!C$13)","v":0},0,{"$f":"Rates!$C$4","v":20},0,0]
[null,null,0,null,null,null,null,null,null,null,null,null,{"$f":"(E59*Rates!C$8)+(F59*Rates!C$9)+(G59*Rates!C$10)+(H59*Rates!C$11)+(I59*Rates!C$12)+(J59*Rates!C$13)","v":0},0,{"$f":"Rates!$C$4","v":20},0,0]
[null,null,0,null,null,null,null,null,null,null,null,null,{"$f":"(E60*Rates!C$8)+(F60*Rates!C$9)+(G60*Rates!C$10)+(H60*Rates!C$11)+(I60*Rates!C$12)+(J60*Rates!C$13)","v":0},0,{"$f":"Rates!$C$4","v":20},0,0]
[null,null,0,null,null,null,null,null,null,null,null,null,{"$f":"(E61*Rates!C$8)+(F61*Rates!C$9)+(G61*Rates!C$10)+(H61*Rates!C$11)+(I61*Rates!C$12)+(J61*Rates!C$13)","v":0},0,{"$f":"Rates!$C$4","v":20},0,0]
[null,null,0,null,null,null,null,null,null,null,null,null,{"$f":"(E62*Rates!C$8)+(F62*Rates!C$9)+(G62*Rates!C$10)+(H62*Rates!C$11)+(I62*Rates!C$12)+(J62*Rates!C$13)","v":0},0,{"$f":"Rates!$C$4","v":20},0,0]
[null,null,null,"Total hours",{"$f":"SUM(E26:E54)","v":82},40,53,34,6,8]
["TOTAL",null,{"$f":"SUM(C26:C54)","v":37936.799999999996},"Total £",{"$f":"K78","v":3690},{"$f":"K79","v":2600},{"$f":"K80","v":3445},{"$f":"K81","v":2210},{"$f":"K82","v":330},{"$f":"K83","v":600},18539,{"$f":"SUM(L27:L62)","v":200},{"$f":"SUM(M27:M63)","v":12875},{"$f":"SUM(N27:N63)","v":31614},null,{"$f":"SUM(P26:P54)","v":37936.799999999996},{"$f":"SUM(Q26:Q54)","v":6322.7999999999975}]
[]
[]
["TENDER SUMMARY:"]
[1,"PRELIMS",{"$f":"C14","v":5919}]
[2,"SPECIFICATION",{"$f":"C20","v":610}]
[3,"WORK ITEMS",{"$f":"SUM(P26:P54)","v":37936.799999999996}]
[]
["CONTRACT SUM",null,{"$f":"SUM(C68:C70)","v":44465.799999999996}]
[]
[]
["ANALYSIS SUMMARY",null,null,null,null,null,null,null,"LABOUR TOTAL COSTS"]
[null,null,null,null,null,null,null,null,"Total Hours ",null,{"$f":"SUM(E63:J63)","v":223}]
[null,"DAY RATE LABOUR",{"$f":"SUM(K78:K83)","v":12875}]
[null,"SUBCONTRACT",{"$f":"L64","v":200},null,null,null,null,null,"CARPENTER",null,{"$f":"E63*Rates!C8","v":3690}]
[null,"MATERIALS",{"$f":"K64","v":18539},null,null,null,null,null,"BRICKLAYER",null,{"$f":"F63*Rates!C9","v":2600}]
[null,"TOTAL PROFIT",{"$f":"Q64","v":6322.7999999999975},null,null,null,null,null,"PLASTERER",null,{"$f":"G63*Rates!C10","v":3445}]
[null,"PRELIMS",{"$f":"C14+C20","v":6529},null,null,null,null,null,"LABOURER",null,{"$f":"H63*Rates!C11","v":2210}]
[null,"SPEC",{"$f":"C20","v":610},null,null,null,null,null,"PAINTER",null,{"$f":"I63*Rates!C12","v":330}]
[null,null,null,null,null,null,null,null,"OTHER",null,{"$f":"J63*Rates!C13","v":600}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K78:K83)","v":12875}]

{"sheet":"Rates","index":1,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
["MARKUP"]
[]
[null,"%",20]
[]
["LABOUR RATES"]
[]
[null,"CARPENTER",45]
[null,"BRICKLAYER",65]
[null,"PLASTERER",65]
[null,"LABOURER",65]
[null,"PAINTER",55]
[null,"OTHER",75]
[]
[]
[null,"Tender ",{"$f":"Estimate!I10","v":44465.799999999996}]
[]
[null,"Profit ",{"$f":"Estimate!Q64","v":6322.7999999999975}]