{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Read ME","Estimation Sheet"],"not_rendered":{"images":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Read ME","index":0,"n_rows":19,"n_cols":2,"rows_kept":19,"merged":[[0,0,4,11],[6,0,6,11],[8,1,8,12],[10,1,10,12],[12,1,12,12],[14,1,14,12],[16,1,16,12],[17,1,17,12],[18,1,18,12]]}
["Please Read"]
[]
[]
[]
[]
[]
["Dear User, thank you for using my template."]
[]
["1)","Please remove sample entries from the Estimation sheet."]
[]
["2)","Make your entries on the sheet \"Estimation Sheet\". Cells containing formulas or functions are protected, the password is blank should you wish to modify anything."]
[]
["3)","The table works in such a way that you\n- Mark any cell in the last line above the total row\n- Press the \"TAB\" key repeatedly until a new line is added."]
[]
["4)","Please do not forget that if you add a machine or equipment or the like to include fuel, lubricant, maintenance in the same rate or otherwise as extra line item if you wish to do so."]
[]
["5)","You downloaded this sheet free of charge from "]
[null,"http: project-management.magt.biz"]
[null,"You may use this sheet for your personal use and projects. However, selling the sheet is strictly prohibited."]

{"sheet":"Estimation Sheet","index":1,"n_rows":15,"n_cols":16,"rows_kept":15,"merged":[[0,0,0,1],[0,2,0,6],[0,7,0,8],[0,12,0,15],[1,0,1,1],[1,2,1,6],[1,7,1,8],[1,12,1,15],[2,0,2,1],[2,2,2,6],[2,7,2,8],[3,0,3,1],[3,2,3,6],[3,12,3,15],[4,0,4,1],[4,2,4,6]]}
["Project Name",null,"[Project Name]",{"$nulls":4},"Currency",null,"EUR",null,"Prepared on date","[date]"]
["Project Phase",null,"[Project Phase]",{"$nulls":4},"Durations",null,"days",null,"Prepared by","[Name]"]
["Deliverable",null,"[Deliverable]",{"$nulls":4},"Contingency",null,{"v":0.1,"d":"10%"}]
["WBS ID",null,"[WBS ID]",{"$nulls":8},{"$f":"\"Total Activity Estimate (\"&J1&\")\"","v":"Total Activity Estimate (EUR)"},{"$f":"(Table1[[#Totals],[Material Line Total]]+Table1[[#Totals],[Manpower Line Total]]+Table1[[#Totals],[Equipm. Line total]])*(1+J3)","v":{"v":113993.00000000001,"d":"113,993.00"}}]
["Activity",null,"[Activity Name]"]
[]
[{"$nulls":4},{"$f":"J1","v":"EUR"},{"$f":"J1","v":"EUR"},null,null,{"$f":"J2","v":"days"},{"$f":"J1","v":"EUR"},{"$f":"J1","v":"EUR"},{"$nulls":3},{"$f":"J1","v":"EUR"},{"$f":"J1","v":"EUR"}]
["#","Material","Material UOM","Material QTY","Material Rate","Material Line Total","Labour","No.","Duration","Manpower Rate","Manpower Line Total","Tool/Equipment","Equipm. No.","Equipm Number","Equipm. Rate","Equipm. Line total"]
[{"$f":"ROW()-8","v":{"v":1,"d":"001"}},"Cement","ton",{"v":3820,"d":"3,820"},10,{"$f":"D9*E9","v":{"v":38200,"d":"38,200"}},"Skilled Worker",3,10,40,{"$f":"Table1[[#This Row],[No.]]*Table1[[#This Row],[Duration]]*Table1[[#This Row],[Manpower Rate]]","v":{"v":1200,"d":"1,200"}},"Mixer","LS",1,{"v":15000,"d":"15,000"},{"$f":"N9*O9","v":{"v":15000,"d":"15,000"}}]
[{"v":2,"d":"002"},"Ballast (7-14mm)","ton",{"v":6330,"d":"6,330"},3,{"$f":"D10*E10","v":{"v":18990,"d":"18,990"}},"Helper",2,10,28,{"$f":"Table1[[#This Row],[No.]]*Table1[[#This Row],[Duration]]*Table1[[#This Row],[Manpower Rate]]","v":560},{"$nulls":4},{"$f":"N10*O10","v":0}]
[{"v":3,"d":"003"},"Ballast (15-28mm)","ton",{"v":4220,"d":"4,220"},3,{"$f":"D11*E11","v":{"v":12660,"d":"12,660"}},"Operator",1,10,34,{"$f":"Table1[[#This Row],[No.]]*Table1[[#This Row],[Duration]]*Table1[[#This Row],[Manpower Rate]]","v":340},{"$nulls":4},{"$f":"N11*O11","v":0}]
[{"v":4,"d":"004"},"Sand","ton",{"v":8340,"d":"8,340"},2,{"$f":"D12*E12","v":{"v":16680,"d":"16,680"}},{"$nulls":4},{"$f":"Table1[[#This Row],[No.]]*Table1[[#This Row],[Duration]]*Table1[[#This Row],[Manpower Rate]]","v":0},{"$nulls":4},{"$f":"N12*O12","v":0}]
[{"v":5,"d":"005"},"Water",{"$nulls":3},{"$f":"D13*E13","v":0},{"$nulls":4},{"$f":"Table1[[#This Row],[No.]]*Table1[[#This Row],[Duration]]*Table1[[#This Row],[Manpower Rate]]","v":0},{"$nulls":4},{"$f":"N13*O13","v":0}]
[{"$f":"ROW()-8","v":{"v":6,"d":"006"}},{"$nulls":4},{"$f":"D14*E14","v":0},{"$nulls":4},{"$f":"Table1[[#This Row],[No.]]*Table1[[#This Row],[Duration]]*Table1[[#This Row],[Manpower Rate]]","v":0},{"$nulls":4},{"$f":"N14*O14","v":0}]
[null,"Subtotal",null,null,{"$f":"J1","v":"EUR"},{"$f":"SUBTOTAL(109,Table1[Material Line Total])","v":{"v":86530,"d":"86,530"}},"Subtotal",null,null,{"$f":"J1","v":"EUR"},{"$f":"SUBTOTAL(109,Table1[Manpower Line Total])","v":{"v":2100,"d":"2,100"}},"Subtotal",null,null,{"$f":"J1","v":"EUR"},{"$f":"SUBTOTAL(109,Table1[Equipm. Line total])","v":{"v":15000,"d":"15,000"}}]