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

{"sheet":"Read ME","index":0,"n_rows":26,"n_cols":1,"rows_kept":26,"merged":[[0,0,4,11],[8,0,8,11],[11,0,12,11],[15,0,16,11],[19,0,20,11],[23,0,23,11],[24,0,24,11],[25,0,25,11]]}
["Read Me"]
[]
[]
[]
[]
[]
[]
["1)"]
["Dear User, thank you for using my template. Please remove sample entries from the \"Estimation Sheet\"."]
[]
["2)"]
["To avoid typing mistakes resulting in incorrect filter results, some entries are restricted. To modify acceptable values change entries on the sheet \"Validation\"."]
[]
[]
["3)"]
["Please make your data entries on the sheet \"Estimation Sheet\" only. Cells containing formulas or functions are protected, the password is blank should you wish to modify anything."]
[]
[]
["4)"]
["Entries in the column \"length\" are restricted to 12 meter max. Should you wish to allow such entries greater than 12 meter, you have to modify the data validation for the column."]
[]
[]
["5)"]
["You downloaded this sheet free of charge from "]
["http: project-management.magt.biz"]
["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":32,"n_cols":47,"rows_kept":32,"merged":[[0,0,0,5],[0,6,0,25],[0,26,1,51],[1,0,1,5],[1,6,1,25],[2,0,2,5],[2,6,2,25],[2,26,2,31],[2,32,2,38],[2,39,2,44],[2,45,2,51],[3,0,3,5],[3,6,3,25],[3,26,3,31],[3,32,3,38],[3,39,3,44],[3,45,3,51],[4,0,4,5],[4,6,4,25],[4,26,5,31],[4,32,5,51],[5,0,5,5],[5,6,5,25],[6,0,7,5],[6,6,6,8],[6,9,6,11],[6,12,6,14],[6,15,6,17],[6,18,6,20],[6,21,6,23],[6,24,6,26],[6,27,6,29],[6,30,6,32],[6,33,6,35],[6,36,6,38],[6,39,6,41],[6,42,7,45],[6,46,7,51],[7,6,7,8],[7,9,7,11],[7,12,7,14],[7,15,7,17],[7,18,7,20],[7,21,7,23],[7,24,7,26],[7,27,7,29],[7,30,7,32],[7,33,7,35],[7,36,7,38],[7,39,7,41],[8,0,9,1],[8,2,9,18],[8,19,9,21],[8,22,9,24],[8,25,9,27],[8,28,9,30],[8,31,9,51],[10,0,10,1],[10,2,10,18],[10,19,10,21],[10,22,10,24],[10,25,10,27],[10,28,10,30],[10,31,10,51],[11,0,11,1],[11,2,11,18],[11,19,11,21],[11,22,11,24],[11,25,11,27],[11,28,11,30],[11,31,11,51],[12,0,12,1],[12,2,12,18],[12,19,12,21],[12,22,12,24],[12,25,12,27],[12,28,12,30],[12,31,12,51],[13,0,13,1],[13,2,13,18],[13,19,13,21],[13,22,13,24],[13,25,13,27],[13,28,13,30],[13,31,13,51],[14,0,14,1],[14,2,14,18],[14,19,14,21],[14,22,14,24],[14,25,14,27],[14,28,14,30],[14,31,14,51],[15,0,15,1],[15,2,15,18],[15,19,15,21],[15,22,15,24],[15,25,15,27],[15,28,15,30],[15,31,15,51],[16,0,16,1],[16,2,16,18],[16,19,16,21],[16,22,16,24],[16,25,16,27],[16,28,16,30],[16,31,16,51],[17,0,17,1],[17,2,17,18],[17,19,17,21],[17,22,17,24],[17,25,17,27],[17,28,17,30],[17,31,17,51],[18,0,18,1],[18,2,18,18],[18,19,18,21],[18,22,18,24],[18,25,18,27],[18,28,18,30],[18,31,18,51],[19,0,19,1],[19,2,19,18],[19,19,19,21],[19,22,19,24],[19,25,19,27],[19,28,19,30],[19,31,19,51],[20,0,20,1],[20,2,20,18],[20,19,20,21],[20,22,20,24],[20,25,20,27],[20,28,20,30],[20,31,20,51],[21,0,21,1],[21,2,21,18],[21,19,21,21],[21,22,21,24],[21,25,21,27],[21,28,21,30],[21,31,21,51],[22,0,22,1],[22,2,22,18],[22,19,22,21],[22,22,22,24],[22,25,22,27],[22,28,22,30],[22,31,22,51],[23,0,23,1],[23,2,23,18],[23,19,23,21],[23,22,23,24],[23,25,23,27],[23,28,23,30],[23,31,23,51],[24,0,24,1],[24,2,24,18],[24,19,24,21],[24,22,24,24],[24,25,24,27],[24,28,24,30],[24,31,24,51],[25,0,25,1],[25,2,25,18],[25,19,25,21],[25,22,25,24],[25,25,25,27],[25,28,25,30],[25,31,25,51],[26,0,26,1],[26,2,26,18],[26,19,26,21],[26,22,26,24],[26,25,26,27],[26,28,26,30],[26,31,26,51],[27,0,27,1],[27,2,27,18],[27,19,27,21],[27,22,27,24],[27,25,27,27],[27,28,27,30],[27,31,27,51],[28,0,28,1],[28,2,28,18],[28,19,28,21],[28,22,28,24],[28,25,28,27],[28,28,28,30],[28,31,28,51],[29,0,29,1],[29,2,29,18],[29,19,29,21],[29,22,29,24],[29,25,29,27],[29,28,29,30],[29,31,29,51],[30,0,30,1],[30,2,30,18],[30,19,30,21],[30,22,30,24],[30,25,30,27],[30,28,30,30],[30,31,30,51],[31,0,31,1],[31,2,31,18],[31,19,31,21],[31,22,31,24],[31,25,31,27],[31,28,31,30],[31,31,31,51]]}
["Project:",{"$nulls":5},"[Project Name]",{"$nulls":19},"Material Quantity Calculation (Reinforcement)"]
["Sub-Project or Phase:",{"$nulls":5},"[Sub-Project or Phase]"]
["Client:",{"$nulls":5},"[Client]",{"$nulls":19},"Project Mngr.:",{"$nulls":5},"[Proj. Mngr.]",{"$nulls":6},"Printed on:",{"$nulls":5},{"$f":"TODAY()","v":"2015-06-14"}]
["Client's Representative:",{"$nulls":5},"[Client's Representative]",{"$nulls":32},"Estimated by:",{"$nulls":5},"[Author]"]
["Contractor:",{"$nulls":5},"[Contractor]",{"$nulls":19},"Item Description:",{"$nulls":5},"[Item Description]"]
["Sub-Contractor:"]
["This Calculation Total",{"$nulls":5},"Dia 6mm",null,null,{"$f":"SUMIF($T$12:$T$32,G7,$AC$12:$AC$32)","v":{"v":22,"d":"22.0kg"}},null,null,"Dia 8mm",null,null,{"$f":"SUMIF($T$12:$T$32,M7,$AC$12:$AC$32)","v":{"v":0,"d":"0.0kg"}},null,null,"Dia 10mm",null,null,{"$f":"SUMIF($T$12:$T$32,S7,$AC$12:$AC$32)","v":{"v":0,"d":"0.0kg"}},null,null,"Dia 12mm",null,null,{"$f":"SUMIF($T$12:$T$32,Y7,$AC$12:$AC$32)","v":{"v":0,"d":"0.0kg"}},null,null,"Dia 14mm",null,null,{"$f":"SUMIF($T$12:$T$32,AE7,$AC$12:$AC$32)","v":{"v":0,"d":"0.0kg"}},null,null,"Dia 16mm",null,null,{"$f":"SUMIF($T$12:$T$32,AK7,$AC$12:$AC$32)","v":{"v":0,"d":"0.0kg"}},null,null,"Total",{"$nulls":3},{"$f":"SUM(AC12:AE32)","v":{"v":16030.5,"d":"16,030.5kg"}}]
[{"$nulls":6},"Dia 18mm",null,null,{"$f":"SUMIF($T$12:$T$32,G8,$AC$12:$AC$32)","v":{"v":0,"d":"0.0kg"}},null,null,"Dia 20mm",null,null,{"$f":"SUMIF($T$12:$T$32,M8,$AC$12:$AC$32)","v":{"v":864.5000000000001,"d":"864.5kg"}},null,null,"Dia 22mm",null,null,{"$f":"SUMIF($T$12:$T$32,S8,$AC$12:$AC$32)","v":{"v":0,"d":"0.0kg"}},null,null,"Dia 25mm",null,null,{"$f":"SUMIF($T$12:$T$32,Y8,$AC$12:$AC$32)","v":{"v":0,"d":"0.0kg"}},null,null,"Dia 28mm",null,null,{"$f":"SUMIF($T$12:$T$32,AE8,$AC$12:$AC$32)","v":{"v":0,"d":"0.0kg"}},null,null,"Dia 32mm",null,null,{"$f":"SUMIF($T$12:$T$32,AK8,$AC$12:$AC$32)","v":{"v":15144,"d":"15,144.0kg"}}]
[null,null,"BBS",{"$nulls":16},"Size",null,null,"QTY\n(nos.)",null,null,"Length\n(m)",null,null,"Weight\n(kg)",null,null,"Remarks"]
[]
["A",null,"B",{"$nulls":16},"C",null,null,"D",null,null,"E",null,null,"F",null,null,"G"]
[{"v":1,"d":"0001"},null,123,{"$nulls":16},"Dia 6mm",null,null,50,null,null,{"v":2,"d":"2.00"},null,null,{"$f":"IF(T12=0,\"\",VLOOKUP(T12,Validation!$A$1:$B$12,2,FALSE)*W12*Z12)","v":{"v":22,"d":"22.0"}}]
[{"$f":"IF(C12=0,\"\",A12+1)","v":{"v":2,"d":"0002"}},null,"xyz",{"$nulls":16},"Dia 20mm",null,null,100,null,null,{"v":3.5,"d":"3.50"},null,null,{"$f":"IF(T13=0,\"\",VLOOKUP(T13,Validation!$A$1:$B$12,2,FALSE)*W13*Z13)","v":{"v":864.5000000000001,"d":"864.5"}}]
[{"v":3,"d":"0003"},null,"ABC",{"$nulls":16},"Dia 32mm",null,null,200,null,null,{"v":12,"d":"12.00"},null,null,{"$f":"IF(T14=0,\"\",VLOOKUP(T14,Validation!$A$1:$B$12,2,FALSE)*W14*Z14)","v":{"v":15144,"d":"15,144.0"}}]
[{"v":4,"d":"0004"},{"$nulls":27},{"$f":"IF(T15=0,\"\",VLOOKUP(T15,Validation!$A$1:$B$12,2,FALSE)*W15*Z15)","v":""}]
["",{"$nulls":27},{"$f":"IF(T16=0,\"\",VLOOKUP(T16,Validation!$A$1:$B$12,2,FALSE)*W16*Z16)","v":""}]
["",{"$nulls":27},{"$f":"IF(T17=0,\"\",VLOOKUP(T17,Validation!$A$1:$B$12,2,FALSE)*W17*Z17)","v":""}]
["",{"$nulls":27},{"$f":"IF(T18=0,\"\",VLOOKUP(T18,Validation!$A$1:$B$12,2,FALSE)*W18*Z18)","v":""}]
["",{"$nulls":27},{"$f":"IF(T19=0,\"\",VLOOKUP(T19,Validation!$A$1:$B$12,2,FALSE)*W19*Z19)","v":""}]
["",{"$nulls":27},{"$f":"IF(T20=0,\"\",VLOOKUP(T20,Validation!$A$1:$B$12,2,FALSE)*W20*Z20)","v":""}]
[{"$f":"IF(C20=0,\"\",A20+1)","v":""},{"$nulls":27},{"$f":"IF(T21=0,\"\",VLOOKUP(T21,Validation!$A$1:$B$12,2,FALSE)*W21*Z21)","v":""}]
["",{"$nulls":27},{"$f":"IF(T22=0,\"\",VLOOKUP(T22,Validation!$A$1:$B$12,2,FALSE)*W22*Z22)","v":""}]
["",{"$nulls":27},{"$f":"IF(T23=0,\"\",VLOOKUP(T23,Validation!$A$1:$B$12,2,FALSE)*W23*Z23)","v":""}]
["",{"$nulls":27},{"$f":"IF(T24=0,\"\",VLOOKUP(T24,Validation!$A$1:$B$12,2,FALSE)*W24*Z24)","v":""}]
["",{"$nulls":27},{"$f":"IF(T25=0,\"\",VLOOKUP(T25,Validation!$A$1:$B$12,2,FALSE)*W25*Z25)","v":""}]
["",{"$nulls":27},{"$f":"IF(T26=0,\"\",VLOOKUP(T26,Validation!$A$1:$B$12,2,FALSE)*W26*Z26)","v":""}]
["",{"$nulls":27},{"$f":"IF(T27=0,\"\",VLOOKUP(T27,Validation!$A$1:$B$12,2,FALSE)*W27*Z27)","v":""}]
["",{"$nulls":27},{"$f":"IF(T28=0,\"\",VLOOKUP(T28,Validation!$A$1:$B$12,2,FALSE)*W28*Z28)","v":""}]
["",{"$nulls":27},{"$f":"IF(T29=0,\"\",VLOOKUP(T29,Validation!$A$1:$B$12,2,FALSE)*W29*Z29)","v":""}]
["",{"$nulls":27},{"$f":"IF(T30=0,\"\",VLOOKUP(T30,Validation!$A$1:$B$12,2,FALSE)*W30*Z30)","v":""}]
[{"$f":"IF(C30=0,\"\",A30+1)","v":""},{"$nulls":27},{"$f":"IF(T31=0,\"\",VLOOKUP(T31,Validation!$A$1:$B$12,2,FALSE)*W31*Z31)","v":""}]
[{"$f":"IF(C31=0,\"\",A31+1)","v":""},{"$nulls":27},{"$f":"IF(T32=0,\"\",VLOOKUP(T32,Validation!$A$1:$B$12,2,FALSE)*W32*Z32)","v":""}]

{"sheet":"Validation","index":2,"n_rows":12,"n_cols":3,"rows_kept":12}
["Dia 6mm",{"v":0.22,"d":"0.220"},"kg/m"]
["Dia 8mm",0.395,"kg/m"]
["Dia 10mm",0.617,"kg/m"]
["Dia 12mm",0.888,"kg/m"]
["Dia 14mm",{"v":1.21,"d":"1.210"},"kg/m"]
["Dia 16mm",{"v":1.58,"d":"1.580"},"kg/m"]
["Dia 18mm",{"v":2,"d":"2.000"},"kg/m"]
["Dia 20mm",{"v":2.47,"d":"2.470"},"kg/m"]
["Dia 22mm",{"v":2.98,"d":"2.980"},"kg/m"]
["Dia 25mm",{"v":3.85,"d":"3.850"},"kg/m"]
["Dia 28mm",{"v":4.83,"d":"4.830"},"kg/m"]
["Dia 32mm",{"v":6.31,"d":"6.310"},"kg/m"]