{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["A_On-site Resource","AdHoc_Requirements","B_Rental Equipment","C_Consumables","D_Waste Removal","E_Management Fee","Summary","Checks"],"read":"whole","date_system":"1900"}

{"sheet":"A_On-site Resource","index":0,"n_rows":8,"n_cols":4,"rows_kept":8}
["Description","No. of Resources","Monthly fee for resources (VAT Excl.)","Total Annual Fee (Monthly x12) (VAT Excl.)"]
["On-site Waste Management resource.",1,null,{"$f":"C2*12","v":0}]
["Total Year 1 (VAT Excl.)",null,null,{"$f":"D2","v":0}]
["Total Year 2 (VAT Excl.)",null,null,{"$f":"D2","v":0}]
["Total Year 3 (VAT Excl.)",null,null,{"$f":"D2","v":0}]
["Sub Total (A) (VAT Excl)",null,null,{"$f":"SUM(D3:D5)","v":0}]
["VAT 15% (If applicable)",null,null,{"$f":"D6*0.15","v":0}]
["Total Price (A) (VAT Incl.)",null,null,{"$f":"D6+D7","v":0}]

{"sheet":"AdHoc_Requirements","index":1,"n_rows":2,"n_cols":4,"rows_kept":2}
["Description","Unit of measure","No of Resource","Rate per Hour"]
["Additional resource (as and when required)","Per hour",1]

{"sheet":"B_Rental Equipment","index":2,"n_rows":16,"n_cols":6,"rows_kept":16}
["#","Description","Qty","Rental Fee Per Unit (VAT Excl.)","Total Monthly Rental Fee (VAT Excl.)","Annual Rental Fee (monthly x12) (VAT Excl.)"]
[1,"6m3 Waste Skip",1,null,{"$f":"C2*D2","v":0},{"$f":"E2*12","v":0}]
[2,"Fluorescent and globes storage containers which can accommodate 1 200 mm fluorescent tubes",1,null,0,0]
[3,"50 Litre Nappy disposal container/ bin with lids",3,null,0,0]
[4,"142 Litre Nappy disposal container/ bin with lids",2,null,0,0]
[5,"Electrical Pressure Washer - Cold and Hot Water, 3 Phase, 250 Bar, mobile",1,null,0,0]
[6,"Waste Wool bags – XL (1 375 Litre)",6,null,0,0]
[7,"Waste Wool bags – Medium (500 Litre)",6,null,0,0]
[8,"6m3 Waste Skip ad hoc when needed",1,null,0,0]
[9,"240 Litre wheeled bins with lids",50,null,0,0]
[null,"Year 1 (VAT Excl.)",{"$nulls":3},{"$f":"SUM(F2:F10)","v":0}]
[null,"Year 2 (VAT Excl.)",{"$nulls":3},{"$f":"F11","v":0}]
[null,"Year 3 (VAT Excl.)",{"$nulls":3},{"$f":"F11","v":0}]
[null,"Sub-Total (B) (VAT Excl.)",{"$nulls":3},{"$f":"SUM(F11:F13)","v":0}]
[null,"VAT 15% (If applicable)",{"$nulls":3},{"$f":"F14*0.15","v":0}]
[null,"Total Price (B) (VAT Incl.)",{"$nulls":3},{"$f":"F14+F15","v":0}]

{"sheet":"C_Consumables","index":3,"n_rows":11,"n_cols":5,"rows_kept":11}
["Cost Element","Monthly Quantities","Unit Cost (VAT Excl.)","Monthly Cost (VAT Excl.)","Annual Cost (monthly x12) (VAT Excl.)"]
["50 Litre recycling bags",2800,null,{"$f":"B2*C2","v":0},{"$f":"D2*12","v":0}]
["80 Litre recycling bags",3520,null,{"$f":"B3*C3","v":0},{"$f":"D3*12","v":0}]
["240 Litre shredder bags",4480,null,{"$f":"B4*C4","v":0},{"$f":"D4*12","v":0}]
["15 Litre Durable clear plastic bags",1200,null,{"$f":"B5*C5","v":0},{"$f":"D5*12","v":0}]
["Total Year 1 (VAT Excl.)",{"$nulls":3},{"$f":"SUM(E2:E5)","v":0}]
["Total Year 2 (VAT Excl.)",{"$nulls":3},{"$f":"E6","v":0}]
["Total Year 3 (VAT Excl.)",{"$nulls":3},{"$f":"E6","v":0}]
["Sub-Total (C) (VAT Excl.)",{"$nulls":3},{"$f":"SUM(E6:E8)","v":0}]
["VAT 15% (If applicable)",{"$nulls":3},{"$f":"E9*0.15","v":0}]
["Total Price (C) (VAT Incl.)",{"$nulls":3},{"$f":"E9+E10","v":0}]

{"sheet":"D_Waste Removal","index":4,"n_rows":17,"n_cols":6,"rows_kept":17}
["Description","Average Qty/ Load per collection","Monthly Collection Frequency","Cost per collection (VAT Excl.)","Monthly Service Fee (VAT Excl.)","Annual Service Fee (VAT Excl.)"]
["General landfill waste removal","10 x 240 Litre Wheeled bins",8,null,{"$f":"C2*D2","v":0},{"$f":"E2*12","v":0}]
["Garden waste removal","1 x 6m3 Skip",8,null,0,0]
["Hazardous waste removal","1 x fluorescent container",2,null,0,0]
["Nappy waste removal","1 x 142 Litre Nappy container",8,null,0,0]
["Recyclable waste removal","10 x 550 Litre Wool Bags",8,null,0,0]
["Food waste","50 x 1 200 Litre Durable clear plastic bags",8,null,0,0]
["Used oil","2 x 20 Litre",1,null,0,0]
["Fat trap","1 x 210 Litre",2,null,0,0]
["Used batteries disposal","1 x 25 Litre bin",1,null,0,0]
["Ad hoc: 6m3 skip Contractor’s waste","1 x 6m3 Skip",1,null,0,0]
["Year 1 (VAT Excl.)",{"$nulls":4},{"$f":"SUM(F2:F11)","v":0}]
["Year 2 (VAT Excl.)",{"$nulls":4},{"$f":"F12","v":0}]
["Year 3 (VAT Excl.)",{"$nulls":4},{"$f":"F12","v":0}]
["Sub-Total (D) (VAT Excl.)",{"$nulls":4},{"$f":"SUM(F12:F14)","v":0}]
["VAT 15% (If applicable)",{"$nulls":4},{"$f":"F15*0.15","v":0}]
["Total Price (D) (VAT Incl.)",{"$nulls":4},{"$f":"F15+F16","v":0}]

{"sheet":"E_Management Fee","index":5,"n_rows":8,"n_cols":4,"rows_kept":8}
["Description","Year","Monthly Fee (VAT Excl.)","Annual Fee (VAT Excl.) (Monthly x12)"]
["Management Fee","Year 1",null,{"$f":"C2*12","v":0}]
["Management Fee","Year 2",null,{"$f":"C3*12","v":0}]
["Management Fee","Year 3",null,{"$f":"C4*12","v":0}]
["Sub-Total (E) (VAT Excl.)",null,null,{"$f":"SUM(D2:D4)","v":0}]
["VAT 15% (If applicable)",null,null,{"$f":"D5*0.15","v":0}]
["Sub-Total (VAT Incl.)",null,null,{"$f":"D5+D6","v":0}]
["Total Price (E) (VAT Incl.)",null,null,{"$f":"D7","v":0}]

{"sheet":"Summary","index":6,"n_rows":8,"n_cols":2,"rows_kept":8}
["Section","Total (VAT Incl.)"]
["Sub-Total (A) (VAT Incl.)",{"$f":"'A_On-site Resource'!D8","v":0}]
["Sub-Total (B) (VAT Incl.)",{"$f":"'B_Rental Equipment'!F16","v":0}]
["Sub-Total (C) (VAT Incl.)",{"$f":"C_Consumables!E11","v":0}]
["Sub-Total (D) (VAT Incl.)",{"$f":"'D_Waste Removal'!F17","v":0}]
["Sub-Total (E) (VAT Incl.)",{"$f":"'E_Management Fee'!D8","v":0}]
["Total Bid Price (VAT Incl.)",{"$f":"SUM(B2:B6)","v":0}]
["Input Completeness Status",{"$f":"Checks!D9","v":"❌ Missing inputs"}]

{"sheet":"Checks","index":7,"n_rows":9,"n_cols":4,"rows_kept":9,"merged":[[0,0,0,3]]}
["Input Completeness – Required Fields"]
["Section","Cells to check","Missing count","Status"]
["A_On-site Resource","A_On-site Resource!C2",{"$f":"COUNTBLANK('A_On-site Resource'!C2)","v":1},{"$f":"IF(C3=0,\"OK\",\"Missing\")","v":"Missing"}]
["AdHoc_Requirements","AdHoc_Requirements!D2:D200",{"$f":"COUNTBLANK(AdHoc_Requirements!D2:D200)","v":199},"Missing"]
["B_Rental Equipment","B_Rental Equipment!D2:D100",{"$f":"COUNTBLANK('B_Rental Equipment'!D2:D100)","v":99},"Missing"]
["C_Consumables","C_Consumables!C2:C100",{"$f":"COUNTBLANK(C_Consumables!C2:C100)","v":99},"Missing"]
["D_Waste Removal","D_Waste Removal!D2:D200",{"$f":"COUNTBLANK('D_Waste Removal'!D2:D200)","v":199},"Missing"]
["E_Management Fee","E_Management Fee!C2:C4",{"$f":"COUNTBLANK('E_Management Fee'!C2:C4)","v":3},"Missing"]
["TOTAL Missing Inputs",null,{"$f":"SUM(C3:C8)","v":600},{"$f":"IF(C9=0,\"✅ Complete\",\"❌ Missing inputs\")","v":"❌ Missing inputs"}]