{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Attachment B"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":8,"n_cols":2,"rows_kept":8,"merged":[[3,1,3,11],[4,1,4,11],[5,1,5,11],[6,1,6,11],[7,1,7,11]]}
["IFB # 1920-55VS:  Composting/Organic Hauling Scenario Calculation Instructions"]
[]
[]
["1.","Go to the tab labled Attachment B.  Enter unit rates based on the tendering text in appropriate corresponding cells in the top table on Attachment B."]
["2.","Unit Rates from the top table in Attachment B will AUTOMATICALLY populate the appropriate cells (yellow) in the bottom table IF Attachment B was completed electronically.  "]
["3.","The totals on Attachment B will automatically populate the appropriate cells (green) based on the fixed calculations within the spreadsheet."]
["4.","Transfer the Grand Total amount shown on Attachment B (blue cell) to the Bid Schedule included in the Invitation for Bids document."]
["5.","Print out and sign Attachment B and the Bid Schedule.  Include these documents (and any other required documents listed in the Invitation for Bids) with your Bid Submission."]

{"sheet":"Attachment B","index":1,"n_rows":24,"n_cols":7,"rows_kept":24,"merged":[[0,0,0,1],[0,2,0,6],[1,0,1,2],[2,0,2,2],[4,0,4,6],[5,4,5,5],[6,4,6,5],[7,1,7,5],[8,1,8,5],[9,4,9,5],[10,1,10,5],[11,1,11,5],[12,4,12,5],[13,1,13,5],[14,1,14,5],[17,0,17,6],[18,0,18,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[22,0,22,2],[23,0,23,2],[23,3,23,5]]}
["Attachment B",null,"Unit Rates and Scenario for 1920-55VS"]
["Name of Offeror as identified on the cover page:"]
["Authorized Signature:"]
[]
["While the below unit rates will not be considered in determining the lowest bidder, Attachment B must be provided with your response to be considered and will be a part of the resulting contract.  These prices will AUTOMATICALLY be carried over to the Scenario (below) if they are input electronically."]
[null,"Item","Quantity","Unit of Measure","Unit Price"]
[null,1,1,"Month",{"v":0,"d":"$0.00"}]
[null,"Item Description:  Organic Waste Collection, Hauling & Disposal Services"]
[null,"Tendering Text:  Monthly collection, hauling, & disposal of organic waste of one (1) sixty-four (64) gallon container three (3) times per week.  Price is to include all costs for the containers, compostable liners (if required), the collection, packaging, weighing, transportation, and disposal at the organics receiver."]
[null,2,1,"Unit",{"v":0,"d":"$0.00"}]
[null,"Item Description:  Organic Waste Collection, Hauling & Disposal Services"]
[null,"Tendering Text:  One (1) hour of training/educational programs to each of the following audiences:  cafeteria staff, custodial/building services staff, school teachers & staff, and students; One (1) unit = Four (4) hours of training"]
[null,3,1,"Each",{"v":0,"d":"$0.00"}]
[null,"Item Description:  Organic Waste Collection, Hauling & Disposal Services"]
[null,"Tendering Text:  Sixty-four (64) gallon roll cart with lid, wheels, and handles (with compostable liners, if needed)"]
[]
[]
["Scenario:  Assume that Composting/Organic Waste Hauling Services will take place 3 days/week with 204 containers at the elementary schools, 50 containers at the middle schools, and 33 containers at the high schools for 10 months during the year.  Additionally, 5 units of training/educational programs will be required throughout the year."]
["Description",null,null,"Total Quantity of Carts","Length of Service (in months)","Rate","Total"]
["Monthly collection, hauling, & disposal of organic waste from the elementary schools 3 times/week.  Price is to include all costs for the containers, compostable liners (if required), the collection, packaging, weighing, transportation & disposal at the organics receiver.",null,null,204,10,{"$f":"E7","v":{"v":0,"d":"$0.00"}},{"$f":"D20*E20*F20","v":{"v":0,"d":"$0.00"}}]
["Monthly collection, hauling, & disposal of organic waste from each of the middle schools 3 times/week.  Price is to include all costs for the containers, compostable liners (if required), the collection, packaging, weighing, transportation & disposal at the organics receiver.",null,null,50,10,{"$f":"E7","v":{"v":0,"d":"$0.00"}},{"$f":"D21*E21*F21","v":{"v":0,"d":"$0.00"}}]
["Monthly collection, hauling, & disposal of organic waste from each of the high schools 3 times/week.  Price is to include all costs for the containers, compostable liners (if required), the collection, packaging, weighing, transportation & disposal at the organics receiver.",null,null,33,10,{"$f":"E7","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
["Training/educational programs to each of the following audiences:  cafeteria, custodial/building services; school teachers & staff, and students.  One (1) unit = Four (4) hours of training",null,null,5,"N/A",{"$f":"E10","v":{"v":0,"d":"$0.00"}},{"$f":"D23*F23","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Grand Total",null,null,{"$f":"SUM(G20:G23)","v":{"v":0,"d":"$0.00"}}]