{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["QS Estimate Skills Assessment","REPORTING AND COSTING","Sheet4"],"read":"whole","date_system":"1900"}

{"sheet":"QS Estimate Skills Assessment","index":0,"n_rows":31,"n_cols":10,"rows_kept":31,"merged":[[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,6,3,6],[2,7,3,7],[2,8,3,8],[2,9,3,9],[36,3,38,9]]}
[]
[]
[null,null,"ITEM","DESCRIPTION","UNIT","NO. OF PERSONS","HRS/MONTH","MONTHS","ESTIMATED RATES/HR /PER","PRICE"]
[{"$nulls":5},"PERSONNEL"]
[null,null,"A-100","Preliminaries and Generals"]
[{"$nulls":3},"Safety File (cover work and employees)","Once off",{"$nulls":4},{"$f":"+I6","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"Medicals","Once off",11,1,1,null,{"$f":"F7*G7*H7*I7","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"Sub total 100"]
[]
[null,null,"B-200","Resources"]
[{"$nulls":3},"Lead Analyst(SME)","monthly",1,80,4,null,{"$f":"F11*G11*H11*I11","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"Analyst assistant","monthly",1,80,4,null,{"$f":"F12*G12*H12*I12","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"Project Manager","monthly",1,120,4,null,{"$f":"F13*G13*H13*I13","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"Project assistant and Administrator officer","monthly",2,120,4,null,{"v":0,"d":"R0.00"}]
[{"$nulls":3},"Information /document manager","monthly",2,120,4,null,{"v":0,"d":"R0.00"}]
[{"$nulls":3},"Lead Researcher","monthly",1,120,4,null,{"v":0,"d":"R0.00"}]
[{"$nulls":3},"Researcher assistants","monthly",2,120,4,null,{"v":0,"d":"R0.00"}]
[{"$nulls":3},"Stakeholder Manager","monthly",1,80,4,null,{"$f":"F18*G18*H18*I18","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"Sub total 200"]
[]
[null,null,"C-300","Disbursements"]
[]
[{"$nulls":3},"Travel - Km","Km",{"$f":"+U37","v":0},{"$nulls":3},{"$f":"+F23*I23","v":{"v":0,"d":"R0.00"}}]
[]
[{"$nulls":3},"Accommodation","No.",11,{"$f":"4*4*2","v":32},null,null,{"$f":"+F25*I25*G25","v":{"v":0,"d":"R0.00"}}]
[]
[{"$nulls":3},"Communication Allowance (Airtime, Data, Laptop Hire etc. )","No.",11,null,4,null,{"$f":"+F27*H27*I27","v":{"v":0,"d":"R0.00"}}]
[]
[{"$nulls":3},"ESTIMATED PRICE",{"$nulls":5},{"$f":"SUM(J6:J28)","v":{"v":0,"d":"R0.00"}}]
[]
[{"$nulls":3},"Total Estimated",{"$nulls":5},{"$f":"J29+J30","v":{"v":0,"d":"R0.00"}}]

{"sheet":"REPORTING AND COSTING","index":1,"n_rows":46,"n_cols":6,"rows_kept":46,"hidden":true,"merged":[[1,4,1,5],[10,3,13,5]]}
["R"]
[{"$nulls":4},"Suggestion"]
[null,"Deliverable","Due Date","Scope Section","Cost/report","Penalty"]
[1,"Initial project schedule and plan for resources","3 weeks after contract signature","N/A","2.5% of total project cost","0.05% of project cost per every day missed (for that report)"]
[2,"Draft report with gaps and inputs required for finalization","8 weeks after contract signature","4A","25% of total project cost","0.05% of project cost per every day missed (for that report)"]
[3,"Final report","16 weeks after contract signature","4A+4B","70% of total project cost","0.05% of project cost per every day missed (for that report)"]
[null,"Final report  review period","2 weeks after final report"]
[]
[]
[]
[null,"Assumption if project comes at R2 017 200 (inc. T&S), 2.5% of that is",{"$f":"2017200*2.5/100","v":{"v":50430,"d":"R50,430.00"}},"The plan  invoice will come within a month and will be before november, in this case total payment for invoice 1 will be R50430+R50430*2.5%=R51690.75"]
[null,"Majority of work will be done in the draft  report, 25% of that is",{"$f":"2017200*25/100","v":{"v":504300,"d":"R504,300.00"}}]
[null,"Final Integration report, the  balance cost",{"$f":"2017200-C12-C11","v":{"v":1462470,"d":"R1,462,470.00"}}]
[null,"T&S, at 2.5% of R2 017 200",{"$f":"2017200*2.5/100","v":{"v":50430,"d":"R50,430.00"}}]
[]
[null,"Invoice 1",{"$f":"C11*2.5%","v":{"v":1260.75,"d":"R1,260.75"}},{"$f":"C11+C16","v":{"v":51690.75,"d":"R51,690.75"}}]
[null,"Invoice 2",{"$f":"C11*25%","v":{"v":12607.5,"d":"R12,607.50"}},{"$f":"C12+C17","v":{"v":516907.5,"d":"R516,907.50"}}]
[null,"Invoice 3",{"$f":"C11*70%","v":{"v":35301,"d":"R35,301.00"}},{"$f":"C13+C18","v":{"v":1497771,"d":"R1,497,771.00"}}]
{"$rows_empty":22}
[{"$nulls":4},"Costing/Invoicing"]
[null,"Deliverable","Due Date","Scope Section","Cost/report","Penalty"]
[1,"Initial project schedule and plan for resources","3 weeks after contract signature","N/A","2.5% of total project cost","0.05% of project cost per every day missed (for that report)"]
[2,"Draft report with gaps and inputs required for finalization","8 weeks after contract signature","4A","25% of total project cost","0.05% of project cost per every day missed (for that report)"]
[3,"Final report","16 weeks after contract signature","4A+4B","70% of total project cost","0.05% of project cost per every day missed (for that report)"]
[null,"T&S","Per reports invoice"]

{"sheet":"Sheet4","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"merged":[[1,4,1,5]]}