{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Office Furniture BoQ ","Establishment Comparison (2)","Sheet3"],"not_rendered":{"external_links":1,"defined_names":16},"read":"whole","date_system":"1900"}

{"sheet":"Office Furniture BoQ ","index":0,"n_rows":50,"n_cols":8,"rows_kept":50}
[{"$nulls":7},"2024-09-19"]
[null,"PROJECT: SUPPLY AND DELIVERY OF OFFICE FURNITURE FOR A PERIOD OF TWO (2) YEARS AT KUSILE POWER STATION , ECAS ON AN AS AND WHEN REQUIRED BASIS REV 1"]
[]
[null,"ITEM NO","DESCRIPTION","UNIT","NO.OFF","QTY","RATE","AMOUNT"]
[]
[null,null,"ITEM 1"]
[null,1,"OFFICE FURNITURE"]
[]
[null,"1.1","Office Chair (Figure 5) (300 Off Per Year)","Per/Year ",2,300]
[null,"1.2","Visitor Chair ( Figure 6) (50 Off Per Year)","Per/Year ",2,50]
[null,"1.3","L-Shaped - Padenza on Left ( Figure 1) (25 Off Once-Off)","Once-Off",1,25]
[null,"1.4","L-Shaped - Padenza on Right Figure 1) (25 Off Once-Off)","Once-Off",1,25]
[null,"1.5","Small Meeting Room Table ( Figure 4) (20 Off Once-Off)","Once-Off",1,20]
[null,"1.6","Filing Cabinets - Option 1 ( Figure 3) (5 Off Once-Off)","Once-Off",1,5]
[null,"1.7","Filing Cabinets - Option 2 ( Figure 2) (38 Off Per Year)","Per/Year ",2,38]
[null,"1.8","Coat and Hat stand (20 Off Per Year)","Per/Year ",2,20]
[null,"1.9","Dustbins - Desk Side ( Figure 16) (50 Off Once-Off)","Once-Off",1,50]
[null,"1.10","Boardroom Chair - Option 1 ( Figure 7) (25 Off Per Year)","Per/Year ",2,25]
[null,"1.11","Boardroom Chair - Option 2 ( Figure 8) (25 Off Per Year)","Per/Year ",2,25]
[null,"1.12","Boardroom Table 1 - Large ( Figure 11) (2 Off Once-Off)","Once-Off",1,2]
[null,"1.13","Boardroom Table 2 - Small ( Figure 12) (4 Off Once-Off)","Once-Off",1,4]
[null,"1.14","Classroom Chair ( Figure 32) (150 Off Per Year)","Per/Year ",2,150]
[null,"1.15","Classroom Table  (100 Off Once-Off)","Once-Off",1,100]
[null,"1.16","Couch - L-shape Corner Unit  (5 Off Per Year)","Per/Year ",2,5]
[null,"1.17","Couch - 2 Seater ( Figure 21) (15 Off Per Year)","Per/Year ",2,15]
[null,"1.18","Couch - 1 Seater ( Figure 20) (15 Off Once-Off)","Once-Off",1,15]
[null,"1.19","Lounge Chair - 1 seater ( Figure 22) (20 Off Per Year)","Per/Year ",2,20]
[null,"1.20","Pamphlet Shelf/ Library Catalogue Shelves ( Figure 25) (2 Off Per Year)","Per/Year ",2,2]
[null,"1.21","Tea Room Chair ( Figure 14) (50 Off Per Year)","Per/Year ",2,50]
[null,"1.22","Tea Room Table ( Figure 15) (20 Off Once-Off)","Once-Off",1,20]
[null,"1.23","Kitchen/ Domestic Dustbins  (10 Off Once-Off)","Once-Off",1,10]
[null,"1.24","Executive Office Chair ( Figure 19) (30 Off Per Year)","Per/Year ",2,30]
[null,"1.25","Executive Desk - Padenza on Left ( Figure 29) (5 Off Once-Off)","Once-Off",1,5]
[null,"1.26","Executive Desk - Padenza on Right ( Figure 29) (5 Off Once-Off)","Once-Off",1,5]
[null,"1.27","Executive Small Round Meeting Table ( Figure 31) (5 Off Once-Off)","Once-Off",1,5]
[null,"1.28","Executive Server Unit ( Figure 30) (4 Off Once-Off)","Once-Off",1,4]
[null,"1.29","Small Boardroom Table - Maple Venner Finish ( Figure 12) (2 Off Once-Off)","Once-Off",1,2]
[null,"1.30","Executive Couch - 1 seater ( Figure 23) (10 Off Once-Off)","Once-Off",1,10]
[null,"1.31","Library Workstation ( Figure 26) (4 Off Per Year)","Per/Year ",2,4]
[null,"1.32","Library Shelves ( Figure 27) (4 Off Per Year)","Per/Year ",2,4]
[null,"1.33","Delivery Charge/ Fee","Monthly",2,12]
[]
[null,null,"Sub-total Item 1 (Office Furniture) carried to Summary"]
[]
[]
[null,null,"SUMMARY"]
[]
[null,"ITEM 1",{"$f":"C7","v":"OFFICE FURNITURE"}]
[]
[null,null,"Final Summary Total"]

{"sheet":"Establishment Comparison (2)","index":1,"n_rows":26,"n_cols":6,"rows_kept":26,"hidden":true}
[]
[null,"ONCE-OFF ESTALISHMENT FOR ALL UNITS/ ESTABLISHMENT PER UNIT"]
[]
[null,"OPTION A - ESTABLISH AND DE-ESTABLISH AS PER OUTAGE PERIOD"]
[]
[null,"ITEM","UNIT","QUANTITY","RATE PER MONTH","TOTAL"]
[]
[null,"Establishment","No",3,{"$f":"'Office Furniture BoQ '!#REF!","v":{"$error":"#REF!"}},{"$f":"D8*E8","v":{"$error":"#REF!"}}]
[null,"De-establishment","No",3,{"$f":"'Office Furniture BoQ '!#REF!","v":{"$error":"#REF!"}},{"$f":"D9*E9","v":{"$error":"#REF!"}}]
[null,"Parkhome","Months",9,{"$f":"'Office Furniture BoQ '!#REF!","v":{"$error":"#REF!"}},{"$f":"D10*E10","v":{"$error":"#REF!"}}]
[null,"Storage","Months",9,{"$f":"'Office Furniture BoQ '!#REF!","v":{"$error":"#REF!"}},{"$f":"D11*E11","v":{"$error":"#REF!"}}]
[{"$nulls":4},"TOTAL (A)",{"$f":"SUM(F8:F11)","v":{"$error":"#REF!"}}]
[]
[]
[]
[null,"OPTION B - ONCE OFF ESTABLISHMENT TRHOUGHOUT THE OUTAGE PERIOD"]
[]
[null,"ITEM","UNIT","QUANTITY","RATE PER MONTH","TOTAL"]
[]
[null,"Establishment","No",1,{"$f":"E8","v":{"$error":"#REF!"}},{"$f":"D20*E20","v":{"$error":"#REF!"}}]
[null,"De-establishment","No",1,{"$f":"E9","v":{"$error":"#REF!"}},{"$f":"D21*E21","v":{"$error":"#REF!"}}]
[null,"Parkhome","Months",15,{"$error":"#REF!"},{"$f":"D22*E22","v":{"$error":"#REF!"}}]
[null,"Storage","Months",15,{"$error":"#REF!"},{"$f":"D23*E23","v":{"$error":"#REF!"}}]
[{"$nulls":4},"TOTAL (B)",{"$f":"SUM(F20:F23)","v":{"$error":"#REF!"}}]
[]
[{"$nulls":4},"VARIANCE",{"$f":"F24-F12","v":{"$error":"#REF!"}}]

{"sheet":"Sheet3","index":2,"n_rows":7,"n_cols":8,"rows_kept":7,"hidden":true}
[]
[null,null,{"v":480,"d":"480.00"},{"v":310,"d":"310.00"},{"$f":"C2*D2","v":{"v":148800,"d":"148,800.00"}}]
[null,null,{"v":480,"d":"480.00"},{"v":620,"d":"620.00"},{"$f":"C3*D3","v":{"v":297600,"d":"297,600.00"}}]
[null,null,{"v":480,"d":"480.00"},{"v":690,"d":"690.00"},{"v":331200,"d":"331,200.00"}]
[null,null,{"v":480,"d":"480.00"},{"v":390,"d":"390.00"},{"v":187200,"d":"187,200.00"}]
[]
[{"$nulls":4},{"$f":"SUM(E2:E6)","v":{"v":964800,"d":"964,800.00"}},null,{"$f":"(1026720+1142640+645840+513360)/1.15","v":{"v":2894400,"d":"2,894,400.00"}},{"$f":"G7-E7","v":{"v":1929600,"d":"1,929,600.00"}}]