{"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,1,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,"Addendum 9 - PRICE PROPOSAL - PAGE 1 of 5\nNote:  Addendum 9 builds upon previous Price Form Addenda and adds Multi-family Universal Service pricing to Page 2, separates Multi-family Subscription Service and Commercial Compaction Containers on Page 3, and adds Cart Service Pricing on Page 4.  "]
[null,"PROPOSER'S NAME:  "]
[null,"Residential Collection Service and Residential Recyclables Collection Service\n(Services for Residential Units defined as Single Family and any other residential building with less than five residential living units.)"]
[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.\n10. Where applicable, cubic yard has been abbreviated to cu yd."]
[]
[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 cu yd 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 (Sum of Lines 1-4)",{"$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 cu yd 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 (Sum of Lines 7-10)",{"$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 (Sum of Lines 13-16)",{"$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 (Sum of Lines 19-22)",{"$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":27,"n_cols":8,"rows_kept":27,"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,14,6],[16,2,16,3],[17,1,17,3],[25,2,25,3],[26,2,26,3]]}
[null,"Addendum 9 - PRICE PROPOSAL - PAGE 2 of 5\nNote:  Addendum 9 builds upon previous Price Form Addenda and adds Multi-family Universal Service pricing to Page 2, separates Multi-family Subscription Service and Commercial Compaction Containers on Page 3, and adds Cart Service Pricing on Page 4.  "]
[null,"PROPOSER'S NAME:  "]
[null,"Residential Supplemental Collection Services (All Options)",{"$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 serviced 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.\n6. Where applicable, cubic yard has been abbreviated to cu yd.\n7. Pricing shall not include disposal or processing fees.  Franchise Fees shall be included for all pricing, except where noted.",{"$nulls":3},"The Franchisee shall provide a monthly rate per unit for each size of containers identified below. 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. \n\nSpecialty Service shall include the emptying of containers at multiple locations at one single facility or building (See Sample Agreement Article 7.3.5.i).  Specialty Service shall be a monthly rate added on to the corresponding container size monthly service rate per unit.  "]
[null,"Line ","Type of Service",null,null,"Size of Container(s)","# of Containers/ Specialty Service\n(a)","Monthly Service Rate / Unit\n(b)"]
[null,null,"Residential Supplemental Collection Services and Multi-Family Recycling","Monthly Service Rate / Unit\n(a)",null,"64-gallon",300]
[null,{"$f":"'1'!B40+1","v":28},"MF Recyclables: Roll out container(s) and returning to original location - Fee per event",null,null,"2 cu yd",2]
[null,{"$f":"B7+1","v":29},"Each additional Roll Cart - Fee per cart and distribution",null,null,"4 cu yd",1]
[null,30,"Collection of additional Roll Cart - Fee per event",null,null,"6 cu yd",1]
[null,31,"Cart cleaning services - Fee per event",null,null,"8 cu yd",6]
[{"$nulls":5},"Specialty Service",15]
[null,{"$f":"B10+1","v":32},"Improperly prepared Solid Waste - Fee per cu yd",null,null,"Estimated Annualized Cost for Government Building Recycling \n[(Summation of (a)*(b) for all items)*12]",null,{"$f":"((G6*H6)+(G7*H7)+(G8*H8)+(G9*H9)+(G10*H10)+(G11*H11))*12","v":{"v":0,"d":"$0.00"}}]
[null,33,"Improperly prepared Yard Trash - Fee per cu yd"]
[null,34,"Excessive Yard Waste - Fee per cu yd"]
[null,35,"Excessive Bulk Waste - Fee per cu yd"]
[null,36,"Estimated Annualized Cost for Residential Supplemental Collection Services  [((Line 28a x 1)+(Line 29a x 1)+(Line 30a x 1)+(Line 31a x 1)+(Line 32a x 1)+(Line 33a x 1)+(Line 34a x 1)+(Line 35a x 1)) x 12 months]",{"$f":"SUM(D7:D10,D12:D15)*12","v":{"v":0,"d":"$0.00"}}]
[]
[null," Multi-Family Universal Service (Options #2 and #4)"]
[null,"Line","Type of Service","Monthly Service Rate / Unit\n(a)"]
[null,{"$f":"B16+1","v":37},"Solid Waste: 1x per week collection in Franchisee or Customer provided containers"]
[null,{"$f":"B20+1","v":38},"MF Recyclables:  1x per week single stream collection in Franchisee provided carts (price per unit)1 and 2\nNote: Number of carts per complex determined in coordination with customer. "]
[null,{"$f":"B21+1","v":39},"Monthly Rental and Maintenance Fee for Franchisee provided container (Sizes 2 - 8 cu yd) "]
[null,40,"Bulk Trash:  1x per week collection up to 4 items per residential unit"]
[null,41,"Total monthly fee per unit (Line 37a + Line 38a + Line 39a + Line 40a)",{"$f":"SUM(D20:D23)","v":{"v":0,"d":"$0.00"}}]
[null,42,"Estimated Annualized Cost for Multi-Family Universal Service  [(Line 37a x 1)+(Line 38a x 1)+(Line 39a x 1)+(40a x 1)) x 12 months]",{"$f":"D24*12","v":{"v":0,"d":"$0.00"}}]
[null,null,"1Franchisee responsible for cart maintenance and replacement or new carts."]
[null,null,"2 Materials exempt from Franchise Fee.  No Franchise Fee should be included in the proposed rate."]

{"sheet":"3","index":2,"n_rows":62,"n_cols":22,"rows_kept":62,"merged":[[0,1,0,21],[1,1,1,21],[2,1,2,21],[3,1,3,21],[4,1,4,21],[5,1,5,21],[6,1,8,1],[6,2,8,2],[6,3,6,4],[6,5,6,6],[6,7,6,8],[6,9,6,10],[6,11,6,12],[6,13,6,14],[6,15,6,16],[6,17,6,18],[6,19,6,20],[6,21,7,21],[22,2,22,20],[24,1,24,21],[25,1,25,21],[26,1,28,1],[26,2,28,2],[26,3,26,4],[26,5,26,6],[26,7,26,8],[26,9,26,10],[26,11,26,12],[26,13,26,14],[26,15,26,16],[26,17,26,18],[26,19,26,20],[26,21,27,21],[42,2,42,20],[44,1,44,21],[45,1,47,1],[45,2,47,2],[45,3,45,4],[45,5,45,6],[45,7,45,8],[45,9,45,10],[45,11,45,12],[45,13,45,14],[45,15,45,16],[45,17,45,18],[45,19,45,20],[45,21,46,21],[61,2,61,20]]}
[null,"Addendum 9 - PRICE FORM - PAGE 3 of 5\nNote:  Addendum 9 builds upon previous Price Form Addenda and adds Multi-family Universal Service pricing to Page 2, separates Multi-family Subscription Service and Commercial Compaction Containers on Page 3, and adds Cart Service Pricing on Page 4.  "]
[null,"PROPOSER'S NAME:  "]
[null,"Multi-Family Subscription Service and Commercial  Collection Service (Non-Compaction and Compaction Containers)"]
[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. No pricing shall include disposal.\n3. Franchisee shall provide Multi-family and Commercial Collection Service as arranged between the Customer and Franchisee as defined in RFP Section 1, Scope of Services and Attachment B Sample Agreement.  \n4. Multi-family Subscription Service rates shall include Solid Waste and Bulk Trash Collection that meets specifications of the RFP Attachment B, Sample Agreement Article 6.2.  To reduce Proposer confusion on unit counts, Multi-family Subscription Service estimated billing units shall use a placeholder of 1 for purposes of price proposal evaluation.  \n5. All unit prices must be rounded to the nearest cent.  \n6. 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.  \n7. For proposal evaluations, all services have a minimum of one unit listed, even those not currently in use. \n8. Pricing shall include Franchise Fees.  However, pricing shall not include disposal fees.  "]
[null,"Multi-Family Subscription Service  (Solid Waste Franchise Area) Service Options #1 and #3 "]
[null,"Solid Waste Franchise Area NON-COMPACTION CONTAINERS\n(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'!B25+1","v":43},"1 cubic yard",null,1,null,1,null,1,null,1,null,1,null,1,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":44},"2 cubic yard",null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,{"$f":"((D11*E11)+(F11*G11)+(H11*I11)+(J11*K11)+(L11*M11)+(N11*O11)+(P11*Q11)+(R11*S11)+(T11*U11))*12","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"B11+1","v":45},"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,46,"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,47,"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,48,"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":"B15+1","v":49},"1 cubic yard",null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,{"$f":"((D17*E17)+(F17*G17)+(H17*I17)+(J17*K17)+(L17*M17)+(N17*O17)+(P17*Q17)+(R17*S17)+(T17*U17))*12","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"B17+1","v":50},"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":"B18+1","v":51},"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,52,"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,53,"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,54,"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,55,"Estimated Annualized Cost for Commercial Collection in Non-Compaction Containers [Sum of Lines 43-54]",{"$nulls":18},{"$f":"SUM(V10:V22)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"Commercial Collection Services (Solid Waste Franchise Area)"]
[null,"Solid Waste Franchise Area NON-COMPACTION CONTAINERS"]
[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":"B23+1","v":56},"1 cubic yard",null,5,null,3,null,1,null,1,null,1,null,1,null,1,null,1,null,1,{"$f":"((D30*E30)+(F30*G30)+(H30*I30)+(J30*K30)+(L30*M30)+(N30*O30)+(P30*Q30)+(R30*S30)+(T30*U30))*12","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"B30+1","v":57},"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":"((D31*E31)+(F31*G31)+(H31*I31)+(J31*K31)+(L31*M31)+(N31*O31)+(P31*Q31)+(R31*S31)+(T31*U31))*12","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"B31+1","v":58},"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,59,"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,60,"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,61,"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":"B35+1","v":62},"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":"B37+1","v":63},"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":"B38+1","v":64},"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,65,"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,66,"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,67,"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,68,"Estimated Annualized Cost for Commercial Collection in Non-Compaction Containers [Sum of Lines 56-67]",{"$nulls":18},{"$f":"SUM(V30:V42)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"Solid Waste Franchise Area COMPACTION CONTAINERS"]
[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":"B43+1","v":69},"1 cubic yard",null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,{"$f":"((D49*E49)+(F49*G49)+(H49*I49)+(J49*K49)+(L49*M49)+(N49*O49)+(P49*Q49)+(R49*S49)+(T49*U49))*12","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"B49+1","v":70},"2 cubic yard",null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,{"$f":"((D50*E50)+(F50*G50)+(H50*I50)+(J50*K50)+(L50*M50)+(N50*O50)+(P50*Q50)+(R50*S50)+(T50*U50))*12","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"B50+1","v":71},"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,72,"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,73,"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,74,"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":"B54+1","v":75},"1 cubic yard",null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,{"$f":"((D56*E56)+(F56*G56)+(H56*I56)+(J56*K56)+(L56*M56)+(N56*O56)+(P56*Q56)+(R56*S56)+(T56*U56))*12","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"B56+1","v":76},"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":"B57+1","v":77},"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,78,"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,79,"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,80,"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,81,"Estimated Annualized Cost for Commercial Collection in Compaction Containers [Sum of Lines 69-80]",{"$nulls":18},{"$f":"SUM(V49:V61)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"4","index":3,"n_rows":40,"n_cols":8,"rows_kept":40,"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],[35,1,35,7],[36,1,36,7],[37,2,37,5],[38,2,38,5],[39,2,39,6]]}
[null,"Addenda 9 - PRICE FORM - PAGE 4 of 5\nNote:  Addendum 9 builds upon previous Price Form Addenda and adds Multi-family Universal Service pricing to Page 2, separates Multi-family Subscription Service and Commercial Compaction Containers on Page 3, and adds Cart Service Pricing on Page 4.  "]
[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. SWDD 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.                                      7. Where applicable, cubic yard has been abbreviated to cu yd.  "]
[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'!B62+1","v":82},"Non-Compaction: 15 cu yd",null,1,null,1,{"$f":"((D8*E8)+(F8*G8))*12","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"B8+1","v":83},"Non-Compaction: 20 cu yd",null,1,null,1,{"$f":"((D9*E9)+(F9*G9))*12","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"B9+1","v":84},"Non-Compaction: 25 cu yd",null,1,null,1,{"v":0,"d":"$0.00"}]
[null,85,"Non-Compaction: 30 cu yd",null,1,null,1,{"v":0,"d":"$0.00"}]
[null,86,"Non-Compaction: 34 cu yd",null,1,null,1,{"v":0,"d":"$0.00"}]
[null,87,"Non-Compaction: 35 cu yd",null,1,null,1,{"v":0,"d":"$0.00"}]
[null,88,"Non-Compaction: 40 cu yd",null,1,null,1,{"v":0,"d":"$0.00"}]
[null,89,"Compaction: 15 cu yd",null,2,null,1,{"v":0,"d":"$0.00"}]
[null,90,"Compaction: 20 cu yd",null,1,null,1,{"v":0,"d":"$0.00"}]
[null,91,"Compaction: 25 cu yd",null,1,null,1,{"v":0,"d":"$0.00"}]
[null,92,"Compaction: 30 cu yd",null,16,null,1,{"$f":"((D18*E18)+(F18*G18))*12","v":{"v":0,"d":"$0.00"}}]
[null,93,"Compaction: 34 cu yd",null,10,null,1,{"$f":"((D19*E19)+(F19*G19))*12","v":{"v":0,"d":"$0.00"}}]
[null,94,"Compaction: 35 cu yd",null,3,null,1,{"$f":"((D20*E20)+(F20*G20))*12","v":{"v":0,"d":"$0.00"}}]
[null,95,"Compaction: 40 cu yd",null,7,null,1,{"$f":"((D21*E21)+(F21*G21))*12","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"B21+1","v":96},"Estimated Annualized Cost for Commercial Collection in Roll-Offs (Sum of Lines 82 - 95)",{"$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 Supplemental 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 serviced 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":97},"Rolling out container(s) and returning to original location - Fee per event"]
[null,{"$f":"B28+1","v":98},"Unlocking and locking containers - Fee per event"]
[null,{"$f":"B29+1","v":99},"Moving customer-owned container location per Customer request - Fee per event"]
[null,{"$f":"B30+1","v":100},"Opening and closing doors or gates - Fee per event"]
[{"$nulls":7},"One-time fee"]
[null,{"$f":"B31+1","v":101},"Locks for containers - One-time fee"]
[null,{"$f":"B33+1","v":102},"Estimated Annualized Cost for Commercial Supplemental Collection Services  \n(((Line 97 x 1)+(Line 98 x 1)+(Line 99 x 1)+(Line 100 x 1)+(Line 101 x 1)) x 12 months)",{"$nulls":4},{"$f":"(H28+H29+H30+H31+H33)*12","v":{"v":0,"d":"$0.00"}}]
[]
[null,"Commercial Cart Service"]
[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 Cart 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. Unit prices are provided for evaluation purposes only.  SWDD makes no guarantee as to the number of units to be serviced."]
[null,"Line","Type of Service",{"$nulls":3},"Est. Pickups/\nWeek\n(a)","Fee/Pickup\n(b)"]
[null,{"$f":"B34+1","v":103},"Commercial Cart Service in Franchisee provided 96 gal Roll Cart",{"$nulls":3},80]
[null,{"$f":"B39+1","v":104},"Estimated Annualized Cost for Commercial Cart Services \n((Line 103a x Line 103b) x 52.143 weeks/year)",{"$nulls":4},{"$f":"(H39*G39)*52.143","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,"Addendum 9 - PRICE FORM - PAGE 5 of 5\nNote:  Addendum 9 builds upon previous Price Form Addenda and adds Multi-family Universal Service pricing to Page 2, separates Multi-family Subscription Service and Commercial Compaction Containers on Page 3, and adds Cart Service Pricing on Page 4.  "]
[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 "]
[null,{"$f":"'4'!B40+1","v":105},"Residential Collection Service (All Options) + (Multi-family Subscription Service (Options #1 and #3 Only) or Multi-family Universal Service (Options #2 and #4 Only))",{"$f":"'1'!D13+'3'!V23","v":{"v":0,"d":"$0.00"}},{"$f":"'1'!D21+'2'!D25","v":{"v":0,"d":"$0.00"}},{"$f":"'1'!D29+'3'!V23","v":{"v":0,"d":"$0.00"}},{"$f":"'1'!D37+'2'!D25","v":{"v":0,"d":"$0.00"}}]
[null,null,"Commercial Collection Service"]
[null,{"$f":"B8+1","v":106},"All Container Types and Services",{"$f":"'3'!V43+'3'!V62+'4'!H22+'4'!H40","v":{"v":0,"d":"$0.00"}},{"$f":"'3'!V43+'3'!V62+'4'!H22+'4'!H40","v":{"v":0,"d":"$0.00"}},{"$f":"'3'!V43+'3'!V62+'4'!H22+'4'!H40","v":{"v":0,"d":"$0.00"}},{"$f":"'3'!V43+'3'!V62+'4'!H22+'4'!H40","v":{"v":0,"d":"$0.00"}}]
[null,null,"Supplemental Collection Services"]
[null,{"$f":"B10+1","v":107},"Residential Supplemental Collection Services ",{"$f":"'2'!D16","v":{"v":0,"d":"$0.00"}},{"$f":"'2'!$D$16","v":{"v":0,"d":"$0.00"}},{"$f":"'2'!$D$16","v":{"v":0,"d":"$0.00"}},{"$f":"'2'!$D$16","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"B12+1","v":108},"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":109},"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,{"$f":"B14+1","v":110},"Total Proposed Annual Contract Value (By Option)\n[Sum of Lines 105 - 109]",{"$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"}},{"$f":"G8+G10+G12+G13+G14","v":{"v":0,"d":"$0.00"}}]
[null,111,"Total Proposed RFP Package\n[Line 110a + Line 110b + Line 110c + Line 110d]",{"$f":"+D15+E15+F15+G15","v":{"v":0,"d":"$0.00"}}]