{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["1","2","3","4","5"],"not_rendered":{"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"1","index":0,"n_rows":40,"n_cols":5,"rows_kept":40,"merged":[[0,1,0,4],[1,1,1,4],[2,1,2,4],[3,1,3,4],[4,2,4,4],[5,1,5,4],[13,1,13,4],[21,1,21,4],[29,1,29,4],[37,2,37,4],[38,2,38,4],[39,2,39,4]]}
[null,"PRICE PROPOSAL - PAGE 1 of 5"]
[null,"PROPOSER'S NAME:  "]
[null,"Residential Collection Service and Residential Recyclables Collection Service\n(Single Family and Multi-Family Units Designated for Receiving Above Services)"]
[null,"Please note the following:\n1. Proposer must fill in all proposed pricing (yellow highlighted cells) to be considered responsive.  All other cells are locked.\n2. Monthly Service Rate shall be provided per unit for four (4) different service options under the Solid Waste Franchise Area (level of services in brown font) and Recycling Franchise Area (level of services in dark blue font).  \n3. Both Franchise Areas shall be awarded to one Proposer.  \n4. No pricing shall include disposal. \n5. Billing under Service Options #1 and #3 (subscription based) shall be the responsibility of Proposer managed directly with Customer.  All services except recyclables collection shall include Franchise Fee of 6 percent integrated into the monthly service rate.   \n6. Billing under Service Options #2 and #4 (universal based) shall be between SWDD and Proposer. All services except recyclables collection shall include 6 percent Franchise Fee integrated into the monthly service rate.  \n7. All unit prices must be rounded to the nearest cent.  \n8. Unit numbers provided are estimated and for evaluation purposes only. SWDD makes no guarantee on the number of units to be serviced.  \n9. Proposers are encouraged to thoroughly read the option and level of service as provided in RFP Section 1, Scope of Services and Attachment B Sample Agreement."]
[]
[null,"Residential Collection Service \nService Option #1 (1-1-1-1) \nSubscription Service / Non-carted Yard Trash"]
[null,"Line","Type of Service","Monthly Service Rate / Unit SW Franchise Area \nand \nRecycling Franchise Area\n(a)","Estimated Units\n(b)"]
[null,1,"Solid Waste:  1x per week automated carted collection in Franchisee provided carts1 and 2",null,{"$f":"48152+1725","v":{"v":49877,"d":"49,877"}}]
[null,{"$f":"B8+1","v":2},"Single Family Recyclables:  1x per week single stream collection in Franchisee provided carts1 and 3",null,{"v":70450,"d":"70,450"}]
[null,{"$f":"B9+1","v":3},"Yard Trash:  1x per week 4 CY maximum containerized, bundled, or stacked at curb2",null,{"$f":"48152+1725","v":{"v":49877,"d":"49,877"}}]
[null,{"$f":"B10+1","v":4},"Bulk Trash: 1x per week collection2",null,{"v":49877,"d":"49,877"}]
[null,{"$f":"B11+1","v":5},"Total Monthly Fee per Unit",{"$f":"SUM(D8:D11)","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"B12+1","v":6},"Estimated Annualized Cost for SO#1  \n[((Line 1a*1b)+(Line 2a*2b)+(Line 3a*3b)+(Line 4a*4b)) *12 months]",{"$f":"SUM((D8*E8)+(D9*E9)+(D10*E10)+(D11*E11))*12","v":{"v":0,"d":"$0.00"}}]
[null,"Residential Collection Service \nService Option #2 (1-1-1-1) \nUniversal Service / Non-carted Yard Trash"]
[null,"Line","Type of Service","SW Franchise Area \nand \nRecycling Franchise Area\n(a)","Estimated Units\n(b)"]
[null,{"$f":"B13+1","v":7},"Solid Waste:  1x per week automated carted collection in Franchisee provided carts1 and 2",null,{"$f":"48152+1725","v":{"v":49877,"d":"49,877"}}]
[null,{"$f":"B16+1","v":8},"Single Family Recyclables:  1x per week single stream collection in Franchisee provided carts1 and 3",null,{"v":70450,"d":"70,450"}]
[null,{"$f":"B17+1","v":9},"Yard Trash:  1x per week 4 CY maximum containerized, bundled, or stacked at curb2",null,{"$f":"48152+1725","v":{"v":49877,"d":"49,877"}}]
[null,{"$f":"B18+1","v":10},"Bulk Trash: 1x per week collection2",null,{"v":49877,"d":"49,877"}]
[null,{"$f":"B19+1","v":11},"Total Monthly Fee per Unit",{"$f":"SUM(D16:D19)","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"B20+1","v":12},"Estimated Annualized Cost for SO#2 \n[((Line 7a*7b)+(Line 8a*8b)+(Line 9a*9b)+(Line 10a*10b)) *12 months]",{"$f":"SUM((D16*E16)+(D17*E17)+(D18*E18)+(D19*E19))*12","v":{"v":0,"d":"$0.00"}}]
[null,"Residential Collection Service \nService Option #3 (1-1-1-1) \nSubscription Service / Carted Yard Trash"]
[null,"Line","Type of Service","SW Franchise Area \nand \nRecycling Franchise Area\n(a)","Estimated Units\n(b)"]
[null,{"$f":"B21+1","v":13},"Solid Waste:  1x per week automated carted collection in Franchisee provided carts1 and 2",null,{"$f":"48152+1725","v":{"v":49877,"d":"49,877"}}]
[null,{"$f":"B24+1","v":14},"Single Family Recyclables:  1x per week single stream collection in Franchisee provided carts1 and 3",null,{"v":70450,"d":"70,450"}]
[null,{"$f":"B25+1","v":15},"Yard Trash:  1x per week automated carted collection in Franchisee provided carts1 and 2",null,{"$f":"48152+1725","v":{"v":49877,"d":"49,877"}}]
[null,{"$f":"B26+1","v":16},"Bulk Trash: 1x per week collection2",null,{"v":49877,"d":"49,877"}]
[null,{"$f":"B27+1","v":17},"Total Monthly Fee per Unit",{"$f":"SUM(D24:D27)","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"B28+1","v":18},"Estimated Annualized Cost for SO#3\n[((Line 13a*13b)+(Line 14a*14b)+(Line 15a*15b)+(Line 16a*16b)) *12 months]",{"$f":"SUM((D24*E24)+(D25*E25)+(D26*E26)+(D27*E27))*12","v":{"v":0,"d":"$0.00"}}]
[null,"Residential Collection Service \nService Option #4 (1-1-1-1) \nUniversal Service / Carted Yard Trash"]
[null,"Line","Type of Service","SW Franchise Area \nand \nRecycling Franchise Area\n(a)","Estimated Units\n(b)"]
[null,{"$f":"B29+1","v":19},"Solid Waste:  1x per week automated carted collection in Franchisee provided carts1 and 2",null,{"$f":"48152+1725","v":{"v":49877,"d":"49,877"}}]
[null,{"$f":"B32+1","v":20},"Single Family Recyclables:  1x per week single stream collection in Franchisee provided carts1 and 3",null,{"v":70450,"d":"70,450"}]
[null,21,"Yard Trash:  1x per week automated carted collection in Franchisee provided carts1 and 2",null,{"$f":"48152+1725","v":{"v":49877,"d":"49,877"}}]
[null,22,"Bulk Trash: 1x per week collection2",null,{"v":49877,"d":"49,877"}]
[null,23,"Total Monthly Fee per Unit",{"$f":"SUM(D32:D35)","v":{"v":0,"d":"$0.00"}}]
[null,24,"Estimated Annualized Cost for SO#4\n[((Line 19a*19b)+(Line 20a*20b)+(Line 21a*21b)+(Line 22a*22b)) *12 months]",{"$f":"SUM((D32*E32)+(D33*E33)+(D34*E34)+(D35*E35))*12","v":{"v":0,"d":"$0.00"}}]
[null,25,"1Franchisee responsible for cart maintenance and replacement or new carts."]
[null,26,"2Assumes 100% participation of residents."]
[null,27,"3Materials exempt from Franchise Fee.  No Franchise Fee should be included in the proposed rate."]

{"sheet":"2","index":1,"n_rows":19,"n_cols":8,"rows_kept":19,"merged":[[0,1,0,3],[1,1,1,3],[2,1,2,3],[2,5,2,7],[3,1,3,3],[3,5,3,7],[4,2,4,3],[11,5,11,6],[17,2,17,3],[18,2,18,3]]}
[null,"PRICE PROPOSAL - PAGE 2 of 5"]
[null,"PROPOSER'S NAME:  "]
[null,"Residential Supplemental Collection Services and Multi-Family Recycling",{"$nulls":3},"Government Buildings and Facilities Recycling"]
[null,"Please note the following:\n1. Proposer must fill in all proposed pricing (yellow highlighted cells) to be considered responsive.  All other cells are locked.  \n2. Franchisee shall provide Residential Supplemental Collection Service as arranged between the Residential Customer and Franchisee as defined in RFP Section 1, Scope of Services and Attachment B Sample Agreement.  \n3. All unit prices must be rounded to the nearest cent.  \n4. Due to the unknown variable of estimated units served per month, each type of service has a general multiplier of one (1) utilized to calculate the estimated annualized cost. \n5. Total Multi-Family units in Recycling Franchise Area not currently known.  Any information obtained during the solicitation period will be provided via an addendum.",{"$nulls":3},"The Franchisee shall provide a unit price per the various types of containers to be paid on a monthly basis. The franchisee shall be responsible for new carts, cart replacement, and cart maintenance. Please note, some locations have carts equipped with gravity locks. The franchisee will be responsible for purchase and installation of future gravity locks as designated by SWDD Contract Manager or designee. "]
[null,"Line ","Type of Service",null,null,"SIZE OF CONTAINER(S)","# OF CONTAINERS/ Specialty Service","Monthly Service Rate / Unit"]
[null,null,"Residential Supplemental Collection Services and Multi-Family Recycling","Monthly Service Rate / Unit",null,"64-gallon",300]
[null,{"$f":"'1'!B40+1","v":28},"MF Recyclables:  1x per week single stream collection in Franchisee provided carts (price per unit)1 and 3\nNote: Number of carts per complex determined in coordination with customer. ",null,null,"2 cu yd",2]
[null,{"$f":"B7+1","v":29},"MF Recyclables: Roll out container(s) and returning to original location",null,null,"4cu yd",1]
[null,{"$f":"B8+1","v":30},"Each additional Roll Cart",null,null,"6 cu yd",1]
[null,31,"Collection of additional Roll Cart",null,null,"8 cu yd",6]
[null,32,"Cart cleaning services",null,null,"Specialty Service",15]
[{"$nulls":3},"Service Rate / Cubic Yard",null,"Total Annualized Cost =",null,{"$f":"(G6*H6+G7*H7+G8*H8+G9*H9+G10*H10+G11*H11)*12","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"B11+1","v":33},"Improperly prepared Solid Waste"]
[null,34,"Improperly prepared Yard Trash"]
[null,35,"Excessive Yard Waste"]
[null,36,"Excessive Bulk Waste"]
[null,37,"Estimated Annualized Cost for Residential Supplemental Collection Services  [((Line 28 x 1)+(Line 29 x 1)+(Line 30 x 1)+(Line 31 x 1)+(Line 32 x 1)+(Line 33 x 1)+(Line 34 x 1)+(Line 35 x 1)+(Line 36 x 1)) x 12 months]",{"$f":"SUM(D7:D11,D13:D16)*12","v":{"v":0,"d":"$0.00"}}]
[null,null,"1Franchisee responsible for cart maintenance and replacement or new carts."]
[null,null,"3Materials exempt from Franchise Fee.  No Franchise Fee should be included in the proposed rate."]

{"sheet":"3","index":2,"n_rows":41,"n_cols":22,"rows_kept":41,"merged":[[0,1,0,21],[1,1,1,21],[2,1,2,21],[3,1,3,21],[4,1,4,21],[5,1,7,1],[5,2,7,2],[5,3,5,4],[5,5,5,6],[5,7,5,8],[5,9,5,10],[5,11,5,12],[5,13,5,14],[5,15,5,16],[5,17,5,18],[5,19,5,20],[5,21,6,21],[21,2,21,20],[23,1,23,21],[24,1,26,1],[24,2,26,2],[24,3,24,4],[24,5,24,6],[24,7,24,8],[24,9,24,10],[24,11,24,12],[24,13,24,14],[24,15,24,16],[24,17,24,18],[24,19,24,20],[24,21,25,21],[40,2,40,20]]}
[null,"PRICE FORM - PAGE 3 of 5"]
[null,"PROPOSER'S NAME:  "]
[null,"Commercial Collection Services and Multi-Family Units Receiving Commercial Collection Service (Solid Waste Franchise Area)"]
[null,"Please note the following:\n1. Proposer must fill in all proposed pricing (yellow highlighted cells) to be considered responsive.  All other cells are locked.  \n2. Prices are for collection service only except for those containers that include disposal.\n3. Franchisee shall provide Commercial Collection Service as arranged between the Commercial Customer and Franchisee as defined in RFP Section 1, Scope of Services and Attachment B Sample Agreement.  \n4. All unit prices must be rounded to the nearest cent.  \n5. Unit numbers provided are for evaluation purposes only and are based upon recent commercial billing reports. SWDD makes no guarantee as to the number of units to be serviced.  \n6. For proposal evaluations, all services have a minimum of one unit listed, even those not currently in use. \n7. Disposal tip fees shall be a component to the Commercial Base Rate to all containers that include disposal.  "]
[null,"Solid Waste Franchise Area NON-COMPACTION CONTAINERS\n(Commercial and Multi-Family Serviced as Commercial)"]
[null,"Line","Franchisee-Owned Containers","1x/week",null,"2x/week",null,"3x/week",null,"4x/week",null,"5x/week",null,"6x/week",null,"Extra Scheduled Pickup",null,"On-Call Service \nMonthly Charge",null,"On-Call Service \nPickup Charge",null,"=((axb)+(cxd)+(exf)+(gxh)+(ixj)+(kxl)+(mxn)+(oxp)+(qxr))x12"]
[{"$nulls":3},"(a)","(b)","(c)","(d)","(e) ","(f)","(g)","(h)","(i)","(j)","(k)","(l)","(m)","(n)","(o)","(p)","(q)","(r)"]
[{"$nulls":3},"Monthly Rate","Est. Billing Units/ Month","Monthly Rate","Est. Billing Units/ Month","Monthly Rate","Est. Billing Units/ Month","Monthly Rate","Est. Billing Units/ Month","Monthly Rate","Est. Billing Units/ Month","Monthly Rate","Est. Billing Units/ Month","Rate per Pickup","Est. Pickups/ Month","Monthly Rate","Est. Billing Units/ Month","Monthly Rate","Est. Pickups/ Month","Annual Price Proposal"]
[null,{"$f":"'2'!B17+1","v":38},"1 cubic yard",null,5,null,3,null,1,null,1,null,1,null,1,null,1,null,1,null,1,{"$f":"((D9*E9)+(F9*G9)+(H9*I9)+(J9*K9)+(L9*M9)+(N9*O9)+(P9*Q9)+(R9*S9)+(T9*U9))*12","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"B9+1","v":39},"2 cubic yard",null,{"$f":"354+67","v":421},null,84,null,24,null,7,null,2,null,3,null,1,null,1,null,1,{"$f":"((D10*E10)+(F10*G10)+(H10*I10)+(J10*K10)+(L10*M10)+(N10*O10)+(P10*Q10)+(R10*S10)+(T10*U10))*12","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"B10+1","v":40},"3 cubic yard",null,41,null,16,null,3,null,3,null,1,null,1,null,1,null,1,null,1,{"v":0,"d":"$0.00"}]
[null,41,"4 cubic yard",null,282,null,105,null,42,null,10,null,8,null,4,null,1,null,1,null,1,{"v":0,"d":"$0.00"}]
[null,42,"6 cubic yard",null,102,null,54,null,14,null,9,null,2,null,1,null,1,null,1,null,1,{"v":0,"d":"$0.00"}]
[null,43,"8 cubic yard",null,89,null,80,null,65,null,17,null,8,null,10,null,1,null,1,null,1,{"v":0,"d":"$0.00"}]
[null,null,"Customer-Owned Containers"]
[null,{"$f":"B14+1","v":44},"1 cubic yard",null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,{"v":0,"d":"$0.00"}]
[null,{"$f":"B16+1","v":45},"2 cubic yard",null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,{"v":0,"d":"$0.00"}]
[null,{"$f":"B17+1","v":46},"3 cubic yard",null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,{"v":0,"d":"$0.00"}]
[null,47,"4 cubic yard",null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,{"v":0,"d":"$0.00"}]
[null,48,"6 cubic yard",null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,{"v":0,"d":"$0.00"}]
[null,49,"8 cubic yard",null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,{"v":0,"d":"$0.00"}]
[null,50,"Estimated Annualized Cost for Commercial Collection in Non-Compaction Containers [Sum of Lines 39-50]",{"$nulls":18},{"$f":"SUM(V9:V21)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"Solid Waste Franchise Area COMPACTION CONTAINERS\n(Commercial and Multi-Family Serviced as Commercial)"]
[null,"Line","Franchisee-Owned Containers","1x/week",null,"2x/week",null,"3x/week",null,"4x/week",null,"5x/week",null,"6x/week",null,"Extra Scheduled Pickup",null,"On-Call Service \nMonthly Charge",null,"On-Call Service \nPickup Charge",null,"=((axb)+(cxd)+(exf)+(gxh)+(ixj)+(kxl)+(mxn)+(oxp)+(qxr))x12"]
[{"$nulls":3},"(a)","(b)","(c)","(d)","(e) ","(f)","(g)","(h)","(i)","(j)","(k)","(l)","(m)","(n)","(o)","(p)","(q)","(r)"]
[{"$nulls":3},"Monthly Rate","Est. Billing Units/ Month","Monthly Rate","Est. Billing Units/ Month","Monthly Rate","Est. Billing Units/ Month","Monthly Rate","Est. Billing Units/ Month","Monthly Rate","Est. Billing Units/ Month","Monthly Rate","Est. Billing Units/ Month","Rate per Pickup","Est. Pickups/ Month","Monthly Rate","Est. Billing Units/ Month","Monthly Rate","Est. Pickups/ Month","Annual Price Proposal"]
[null,{"$f":"B22+1","v":51},"1 cubic yard",null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,{"$f":"((D28*E28)+(F28*G28)+(H28*I28)+(J28*K28)+(L28*M28)+(N28*O28)+(P28*Q28)+(R28*S28)+(T28*U28))*12","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"B28+1","v":52},"2 cubic yard",null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,{"$f":"((D29*E29)+(F29*G29)+(H29*I29)+(J29*K29)+(L29*M29)+(N29*O29)+(P29*Q29)+(R29*S29)+(T29*U29))*12","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"B29+1","v":53},"3 cubic yard",null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,{"v":0,"d":"$0.00"}]
[null,54,"4 cubic yard",null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,{"v":0,"d":"$0.00"}]
[null,55,"6 cubic yard",null,1,null,1,null,2,null,1,null,1,null,1,null,1,null,1,null,1,{"v":0,"d":"$0.00"}]
[null,56,"8 cubic yard",null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,{"v":0,"d":"$0.00"}]
[null,null,"Customer-Owned Containers"]
[null,{"$f":"B33+1","v":57},"1 cubic yard",null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,{"$f":"((D35*E35)+(F35*G35)+(H35*I35)+(J35*K35)+(L35*M35)+(N35*O35)+(P35*Q35)+(R35*S35)+(T35*U35))*12","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"B35+1","v":58},"2 cubic yard",null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,{"v":0,"d":"$0.00"}]
[null,{"$f":"B36+1","v":59},"3 cubic yard",null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,{"v":0,"d":"$0.00"}]
[null,60,"4 cubic yard",null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,{"v":0,"d":"$0.00"}]
[null,61,"6 cubic yard",null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,{"v":0,"d":"$0.00"}]
[null,62,"8 cubic yard",null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,{"v":0,"d":"$0.00"}]
[null,63,"Estimated Annualized Cost for Commercial Collection in Compaction Containers [Sum of Lines 52-63]",{"$nulls":18},{"$f":"SUM(V28:V40)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"4","index":3,"n_rows":34,"n_cols":8,"rows_kept":34,"merged":[[0,1,0,7],[1,1,1,7],[2,1,2,7],[3,1,3,7],[4,1,4,7],[5,1,6,1],[5,2,6,2],[21,2,21,6],[23,1,23,7],[24,1,24,7],[25,1,26,1],[25,2,26,6],[27,2,27,6],[28,2,28,6],[29,2,29,6],[30,2,30,6],[31,2,31,6],[32,2,32,6],[33,2,33,6]]}
[null,"PRICE FORM - PAGE 4 of 5"]
[null,"PROPOSER'S NAME:  "]
[null,"Commercial Collection Service - Roll-Offs"]
[null,"Please note the following:\n1. Proposer must fill in all proposed pricing (yellow highlighted cells) to be considered responsive.  All other cells are locked.  \n2. Franchisee shall provide Commercial Collection Service for roll-offs as arranged between the Commercial Customer and Franchisee as defined in RFP Section 1, Scope of Services and Attachment B Sample Agreement.  \n3. All unit prices must be rounded to the nearest cent.  \n4. Unit numbers provided are for evaluation purposes only. The County makes no guarantee as to the number of units to be serviced.  \n5. For proposal evaluations, all services have a minimum of one unit listed, even those not currently in use. \n6. Prices are for collection service only.   Disposal rates or Drop-off Charges to Commercial Customers for roll-off containers shall be based upon scale tickets and shall not be a component to the Commercial Base Rate provided for roll-off containers.   "]
[null,"Solid Waste Franchise Area ROLL-OFFS\n(Commercial and Multi-Family Serviced as Commercial)"]
[null,"Line","Container Size","(a)","(b)","(c)","(d)","= ((axb) + (cxd)) x \n12 months"]
[{"$nulls":3},"Monthly Container & Maintenance Fee","Est. Billing Units/Month","Fee per Pull","Est. Pulls/ Month","Annual Price Proposal"]
[null,{"$f":"'3'!B41+1","v":64},"Non-Compaction: 15 cy",null,1,null,1,{"$f":"((D8*E8)+(F8*G8))*12","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"B8+1","v":65},"Non-Compaction: 20 cy",null,1,null,1,{"$f":"((D9*E9)+(F9*G9))*12","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"B9+1","v":66},"Non-Compaction: 25 cy",null,1,null,1,{"v":0,"d":"$0.00"}]
[null,67,"Non-Compaction: 30 cy",null,1,null,1,{"v":0,"d":"$0.00"}]
[null,68,"Non-Compaction: 34 cy",null,1,null,1,{"v":0,"d":"$0.00"}]
[null,69,"Non-Compaction: 35 cy",null,1,null,1,{"v":0,"d":"$0.00"}]
[null,70,"Non-Compaction: 40 cy",null,1,null,1,{"v":0,"d":"$0.00"}]
[null,71,"Compaction: 15 cy",null,2,null,1,{"v":0,"d":"$0.00"}]
[null,72,"Compaction: 20 cy",null,1,null,1,{"v":0,"d":"$0.00"}]
[null,73,"Compaction: 25 cy",null,1,null,1,{"v":0,"d":"$0.00"}]
[null,74,"Compaction: 30 cy",null,16,null,1,{"$f":"((D18*E18)+(F18*G18))*12","v":{"v":0,"d":"$0.00"}}]
[null,75,"Compaction: 34 cy",null,10,null,1,{"$f":"((D19*E19)+(F19*G19))*12","v":{"v":0,"d":"$0.00"}}]
[null,76,"Compaction: 35 cy",null,3,null,1,{"$f":"((D20*E20)+(F20*G20))*12","v":{"v":0,"d":"$0.00"}}]
[null,77,"Compaction: 40 cy",null,7,null,1,{"$f":"((D21*E21)+(F21*G21))*12","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"B21+1","v":78},"Estimated Annualized Cost for Commercial Collection in Roll-Offs (Sum of Lines 65-78)",{"$nulls":4},{"$f":"SUM(H8:H21)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"Commercial Supplemental Collection Services"]
[null,"Please note the following:\n1. Proposer must fill in all proposed pricing (yellow highlighted cells) to be considered responsive.  All other cells are locked.  \n2. Franchisee shall provide Commercial Collection Service as arranged between the Commercial Customer and Franchisee as defined in RFP Section 1, Scope of Services and Attachment B Sample Agreement.  \n3. All unit prices must be rounded to the nearest cent.  \n4. Due to the unknown variable of estimated units served per month, each type of service has a general multiplier of one (1) utilized to calculate the estimated annualized cost. "]
[null,"Line ","Type of Service",{"$nulls":4},"Solid Waste Franchise Area"]
[{"$nulls":7},"Service Rate / Occurrence"]
[null,{"$f":"B22+1","v":79},"Rolling out container(s) and returning to original location"]
[null,{"$f":"B28+1","v":80},"Unlocking and locking containers"]
[null,{"$f":"B29+1","v":81},"Moving customer-owned container location per Customer request"]
[null,{"$f":"B30+1","v":82},"Opening and closing doors or gates"]
[{"$nulls":7},"One-time fee"]
[null,{"$f":"B31+1","v":83},"Locks for containers"]
[null,{"$f":"B33+1","v":84},"Estimated Annualized Cost for Commercial Supplemental Collection Services  \n(((Line 80 x 1)+(Line 81 x 1)+(Line 82 x 1)+(Line 83 x 1)+(Line 84 x 1)) x 12 months)",{"$nulls":4},{"$f":"(H28+H29+H30+H31+H33)*12","v":{"v":0,"d":"$0.00"}}]

{"sheet":"5","index":4,"n_rows":16,"n_cols":7,"rows_kept":16,"merged":[[0,2,0,6],[1,1,1,6],[2,1,2,6],[3,2,3,6],[6,2,6,6],[8,2,8,6],[10,2,10,6]]}
[null,null,"PRICE FORM - PAGE 5 of 5"]
[null,"PROPOSER'S NAME:  "]
[null,"Total Proposed Annual Contract Value (ACV)"]
[null,null,"Please note annualized summations have been provided by level of service option and a total of all services bid."]
[{"$nulls":3},"SERVICE OPTION #1","SERVICE OPTION #2","SERVICE OPTION #3","SERVICE OPTION #4"]
[null,"Line","Service","Est. Annualized\nCost\n(a)","Est. Annualized\nCost\n(b)","Est. Annualized\nCost\n(c)","Est. Annualized\nCost\n(d)"]
[null,null,"Residential Collection Service + Residential Recycling Collection Service"]
[null,1,"All Residential Curbside Types and Services",{"$f":"'1'!D13","v":{"v":0,"d":"$0.00"}},{"$f":"'1'!D21","v":{"v":0,"d":"$0.00"}},{"$f":"'1'!D29","v":{"v":0,"d":"$0.00"}},{"$f":"'1'!D37","v":{"v":0,"d":"$0.00"}}]
[null,null,"Commercial Collection Service"]
[null,2,"All Container Types and Services",{"$f":"'3'!V22+'3'!V41+'4'!H22","v":{"v":0,"d":"$0.00"}},{"$f":"'3'!V22+'3'!V41+'4'!H22","v":{"v":0,"d":"$0.00"}},{"$f":"'3'!V22+'3'!V41+'4'!H22","v":{"v":0,"d":"$0.00"}},{"$f":"'3'!V22+'3'!V41+'4'!H22","v":{"v":0,"d":"$0.00"}}]
[null,null,"Supplemental Collection Services"]
[null,3,"Residential Supplemental Collection Services and Multi-Family Recycling",{"$f":"'2'!H12","v":{"v":0,"d":"$0.00"}},{"$f":"'2'!$D$17","v":{"v":0,"d":"$0.00"}},{"$f":"'2'!$D$17","v":{"v":0,"d":"$0.00"}},{"$f":"'2'!$D$17","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"B12+1","v":4},"Government Buildings and Facilities Recycling",{"$f":"'2'!H12","v":{"v":0,"d":"$0.00"}},{"$f":"'2'!H12","v":{"v":0,"d":"$0.00"}},{"$f":"'2'!H12","v":{"v":0,"d":"$0.00"}},{"$f":"'2'!H12","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"B13+1","v":5},"Commercial Supplemental Collection Services",{"$f":"'4'!$H$34","v":{"v":0,"d":"$0.00"}},{"$f":"'4'!$H$34","v":{"v":0,"d":"$0.00"}},{"$f":"'4'!$H$34","v":{"v":0,"d":"$0.00"}},{"$f":"'4'!$H$34","v":{"v":0,"d":"$0.00"}}]
[null,null,"Total Proposed Annual Contract Value (By Option)\n[Sum of Lines 1-4]",{"$f":"D8+D10+D12+D13+D14","v":{"v":0,"d":"$0.00"}},{"$f":"E8+E10+E12+E13+E14","v":{"v":0,"d":"$0.00"}},{"$f":"F8+F10+F12+F13+F14","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[null,null,"Total Proposed RFP Package\n[(Line 1a + Line 1b + Line 1c + Line1d)+Line 2a + Line 3a + Line 4a)]",{"$f":"SUM(D8:G8)+D10++D12+D13+D14","v":{"v":0,"d":"$0.00"}}]