{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Non-Tree Costs","Tree Costs","Other Services","Labor Costs"],"read":"whole","date_system":"1900"}

{"sheet":"Non-Tree Costs","index":0,"n_rows":64,"n_cols":7,"rows_kept":64,"merged":[[0,0,0,6],[1,0,1,6],[2,0,2,6],[55,0,55,5],[57,0,57,4],[57,5,57,6],[58,0,58,4],[58,5,58,6],[59,0,59,4],[59,5,59,6],[62,0,62,6]]}
["TREE PLANTING SERVICES"]
["EXHIBIT B - PRICING SHEET"]
["23-DPR-ITBLW-444"]
["ITEM","Description","Size","Production \nMethod","UNIT\nPRICE","EST. \nQTY.","EXTENDED\nTOTAL"]
[1,"Deciduous shrub - type 0","12 inches height","Per ANSI",null,15,{"$f":"E5*F5","v":{"v":0,"d":"$0.00"}}]
[2,"Deciduous shrub - type 0","15 inches height","Per ANSI",null,15,{"$f":"E6*F6","v":{"v":0,"d":"$0.00"}}]
[3,"Deciduous shrub - type 0","18 inches height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[4,"Deciduous shrub - type 0","24 inches height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[5,"Deciduous shrub - type 1","12 inches height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[6,"Deciduous shrub - type 1","15 inches height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[7,"Deciduous shrub - type 1","18 inches height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[8,"Deciduous shrub - type 1","24 inches height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[9,"Deciduous shrub - type 2","12 inches height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[10,"Deciduous shrub - type 2","18 inches height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[11,"Deciduous shrub - type 2","2 ft height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[12,"Deciduous shrub - type 2","3 ft height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[13,"Deciduous shrub - type 3","2 ft height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[14,"Deciduous shrub - type 3","3 ft height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[15,"Deciduous shrub - type 3","4 ft height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[16,"Deciduous shrub - type 3","5 ft height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[17,"Evergreen shrub - type 1 coniferous evergreen","12 inches height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[18,"Evergreen shrub - type 1 coniferous evergreen","24 inches height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[19,"Evergreen shrub - type 3 coniferous evergreen","12 inches height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[20,"Evergreen shrub - type 3 coniferous evergreen","24 inches height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[21,"Evergreen shrub - type 3 coniferous evergreen","36 inches height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[22,"Broadleaf evergreen shrubs, type 1","12 inches height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[23,"Broadleaf evergreen shrubs, type 1","24 inches height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[24,"Broadleaf evergreen shrubs, type 2","12 inches height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[25,"Broadleaf evergreen shrubs, type 2","24 inches height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[26,"Broadleaf evergreen shrubs, type 3","12 inches height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[27,"Broadleaf evergreen shrubs, type 3","24 inches height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[28,"Broadleaf evergreen shrubs, type 4","24 inches height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[29,"Broadleaf evergreen shrubs, type 4","3 ft height","Per ANSI",null,15,{"v":0,"d":"$0.00"}]
[30,"Herbaceous Perennials","4 inch Pot","Per ANSI",null,100,{"v":0,"d":"$0.00"}]
[31,"Herbaceous Perennials","1 Gallon","Per ANSI",null,100,{"v":0,"d":"$0.00"}]
[32,"Herbaceous Perennials","2 Gallon","Per ANSI",null,50,{"v":0,"d":"$0.00"}]
[33,"Herbaceous Perennials","3 Gallon","Per ANSI",null,50,{"v":0,"d":"$0.00"}]
[34,"Herbaceous Perennials","Landscape Plug","Per ANSI",null,300,{"v":0,"d":"$0.00"}]
[35,"Ornamental Grasses","4 inch Pot","Per ANSI",null,100,{"v":0,"d":"$0.00"}]
[36,"Ornamental Grasses","1 Gallon","Per ANSI",null,100,{"v":0,"d":"$0.00"}]
[37,"Ornamental Grasses","2 Gallon","Per ANSI",null,50,{"v":0,"d":"$0.00"}]
[38,"Ornamental Grasses","3 Gallon","Per ANSI",null,50,{"v":0,"d":"$0.00"}]
[39,"Ornamental Grasses","Landscape Plug","Per ANSI",null,300,{"v":0,"d":"$0.00"}]
[40,"Groundcovers","4 inch Pot","Per ANSI",null,500,{"v":0,"d":"$0.00"}]
[41,"Groundcovers","1 Gallon","Per ANSI",null,100,{"v":0,"d":"$0.00"}]
[42,"Groundcovers","2 Gallon","Per ANSI",null,100,{"v":0,"d":"$0.00"}]
[43,"Groundcovers","3 Gallon","Per ANSI",null,100,{"v":0,"d":"$0.00"}]
[44,"Groundcovers","Landscape Plug","Per ANSI",null,1000,{"v":0,"d":"$0.00"}]
[45,"Vines","4 inch Pot","Per ANSI",null,100,{"v":0,"d":"$0.00"}]
[46,"Vines","1 Gallon","Per ANSI",null,100,{"v":0,"d":"$0.00"}]
[47,"Vines","2 Gallon","Per ANSI",null,50,{"v":0,"d":"$0.00"}]
[48,"Vines","3 Gallon","Per ANSI",null,50,{"v":0,"d":"$0.00"}]
[49,"Vines","Landscape Plug","Per ANSI",null,50,{"v":0,"d":"$0.00"}]
[50,"Bulbs","Top size","Per ANSI",null,300,{"v":0,"d":"$0.00"}]
[]
["GRAND TOTAL",{"$nulls":5},{"$f":"SUM(G5:G54)","v":{"v":0,"d":"$0.00"}}]
[]
["Additional markups",{"$nulls":4},"Markup % per plant"]
["Additional percentage markup for planting the stricter provenance of originating from a location within 150 miles of Arlington County"]
["Additional percentage markup for plants requiring a second year guaranteed"]
[]
["NOTES: "]
["OTHER THAN THE LABOR COSTS, ALL PRICES IN ATTACHMENT B, PRICING SHEET FOR: TREE COSTS, NON-TREE COSTS, AND OTHER SERVICES SHALL INCLUDE COST OF LABOR, EQUIPMENT, AND MATERIAL."]
["NO PARTIAL BIDS WILL BE ACCEPTED."]

{"sheet":"Tree Costs","index":1,"n_rows":31,"n_cols":7,"rows_kept":31,"merged":[[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,6],[22,0,22,4],[24,0,24,4],[24,5,24,6],[25,0,25,4],[25,5,25,6],[26,0,26,4],[26,5,26,6],[29,0,29,6]]}
["TREE PLANTING SERVICES"]
["EXHIBIT B - PRICING SHEET"]
["23-DPR-ITBLW-444"]
["All trees shall be single-stem, unless otherwise specified by the Project Officer."]
["ITEM","Description","Size Minimum","Production method","UNIT PRICE","EST.\nQTY.","EXTENDED \nTOTAL"]
[1,"Shade tree","7' height","B&B or approved substitute",null,200,{"$f":"E6*F6","v":{"v":0,"d":"$0.00"}}]
[2,"Shade tree","1.5\" caliper","B&B or approved substitute",null,700,{"$f":"E7*F7","v":{"v":0,"d":"$0.00"}}]
[3,"Shade tree","2\" caliper","B&B",null,100,{"v":0,"d":"$0.00"}]
[4,"Shade tree","3\" caliper","B&B ",null,100,{"v":0,"d":"$0.00"}]
[5,"Shade tree","4\" caliper","B&B ",null,25,{"v":0,"d":"$0.00"}]
[6,"Small Upright/Spreading tree","6' height","B&B or approved substitute",null,100,{"v":0,"d":"$0.00"}]
[7,"Small Upright/Spreading tree","7' height","B&B or approved substitute",null,100,{"v":0,"d":"$0.00"}]
[8,"Small Upright/Spreading tree","8' height","B&B",null,100,{"v":0,"d":"$0.00"}]
[9,"Small Upright/Spreading tree","10' height","B&B",null,100,{"v":0,"d":"$0.00"}]
[10,"Evergreen Deciduous/Coniferous tree Type 3 and greater","6' height","B&B or approved substitute",null,100,{"v":0,"d":"$0.00"}]
[11,"Evergreen Deciduous/Coniferous tree Type 3 and greater","6' height","Rootbag",null,100,{"v":0,"d":"$0.00"}]
[12,"Evergreen Deciduous/Coniferous tree Type 3 and greater","7' height","B&B",null,100,{"v":0,"d":"$0.00"}]
[13,"Evergreen Deciduous/Coniferous tree Type 3 and greater","8' height","B&B",null,100,{"v":0,"d":"$0.00"}]
[14,"Tree Seedling/tubeling","12 inches height","Bare root",null,500,{"v":0,"d":"$0.00"}]
[15,"Tree Seedling/tubeling","12 inches height","#1 container",null,500,{"v":0,"d":"$0.00"}]
[16,"Tree Seedling/tubeling","12 inches height","#2 container",null,500,{"v":0,"d":"$0.00"}]
[17,"Tree Seedling/tubeling","12 inches height","#3 container",null,500,{"v":0,"d":"$0.00"}]
["GRAND TOTAL",{"$nulls":5},{"$f":"SUM(G6:G22)","v":{"v":0,"d":"$0.00"}}]
[]
["Additional markups",{"$nulls":4},"Markup % per plant"]
["Additional percentage markup for planting the stricter provenance originating from a location within 150 miles of Arlington County"]
["Additional percentage markup for plants requiring a second year guaranteed"]
[]
["NOTES: "]
["OTHER THAN THE LABOR COSTS, ALL PRICES IN ATTACHMENT B, PRICING SHEET FOR: TREE COSTS, NON-TREE COSTS, AND OTHER SERVICES SHALL INCLUDE COST OF LABOR, EQUIPMENT, AND MATERIAL."]
["NO PARTIAL BIDS WILL BE ACCEPTED."]

{"sheet":"Other Services","index":2,"n_rows":59,"n_cols":6,"rows_kept":59,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5],[54,0,54,4],[57,0,57,5],[58,0,58,5]]}
["TREE PLANTING SERVICES"]
["EXHIBIT B - PRICING SHEET"]
["23-DPR-ITBLW-444"]
["All items shall include material provision and installation"]
["ITEM","SERVICE REQUESTED","UNIT PRICE","UNIT OF \nMEASUREMENT","EST. QTY.","TOTAL"]
[1,"Prepare area for tree planting, excavate & backfill per Arlington County Design Standards and Landscape Plan",null,"Cubic yard",10,{"$f":"C6*E6","v":{"v":0,"d":"$0.00"}}]
[2,"Excavation",null,"Cubic yard",20,{"$f":"C7*E7","v":{"v":0,"d":"$0.00"}}]
[3,"Topsoil",null,"Cubic yard",150,{"v":0,"d":"$0.00"}]
[4,"Wood chip",null,"Square ft",1000,{"v":0,"d":"$0.00"}]
[5,"Pressure treated No. 1 Wood Timber 6\" x 6\", secured with metal rebar",null,"Linear Foot",100,{"v":0,"d":"$0.00"}]
[6,"Pressure treated Marine grade Wood Timber 6\" x 6\", secured with metal rebar",null,"Linear Foot",100,{"v":0,"d":"$0.00"}]
[7,"Weed barrier fabric",null,"Square ft",5000,{"v":0,"d":"$0.00"}]
[8,"Biodegradable Erosion control fabric, with biodegradable stakes",null,"Square ft",5000,{"v":0,"d":"$0.00"}]
[9,"12 inch diameter Biodegradable Coir logs, secured with wood stakes",null,"Linear foot",100,{"v":0,"d":"$0.00"}]
[10,"Planting bed preparation for annuals, perennials, and shrubs",null,"Square ft",10000,{"v":0,"d":"$0.00"}]
[11,"Install 20 gallon watering bag",null,"Per bag",1200,{"v":0,"d":"$0.00"}]
[12,"Remove watering bag",null,"Per bag",1200,{"v":0,"d":"$0.00"}]
[13,"One year watering of trees",null,"Per tree",1200,{"v":0,"d":"$0.00"}]
[14,"One year watering shrubs, perennials, grasses, groundcovers, bulbs, and vines",null,"Square ft",1000,{"v":0,"d":"$0.00"}]
[15,"One year watering seed or sod",null,"Square ft",1000,{"v":0,"d":"$0.00"}]
[16,"One time individual watering tree",null,"Per tree",500,{"v":0,"d":"$0.00"}]
[17,"One time watering for shrubs, perennials, grasses, groundcovers, bulbs, and vines",null,"Square ft",300,{"v":0,"d":"$0.00"}]
[18,"One year weekly watering and weeding for establishment of trees, including watering bag",null,"Per tree",1200,{"v":0,"d":"$0.00"}]
[19,"One year biweekly (once every 14 days) watering and weeding for establishment of trees, including watering bag",null,"Per tree",1200,{"v":0,"d":"$0.00"}]
[20,"One year watering and weeding for establishment of shrubs, perennials, grasses, groundcovers, bulbs, and vines",null,"Square ft",300,{"v":0,"d":"$0.00"}]
[21,"Stump removal under 6 inches diameter",null,"Per stump",150,{"v":0,"d":"$0.00"}]
[22,"Sod, cool season",null,"Square ft",1000,{"v":0,"d":"$0.00"}]
[23,"Sod, warm season",null,"Square ft",1000,{"v":0,"d":"$0.00"}]
[24,"Turf aeration",null,"Square ft",1000,{"v":0,"d":"$0.00"}]
[25,"Grass seed",null,"Square ft",1000,{"v":0,"d":"$0.00"}]
[26,"Plant establishment fence - plastic",null,"Linear feet",2000,{"v":0,"d":"$0.00"}]
[27,"Plant establishment fence - galvanized metal",null,"Linear feet",2000,{"v":0,"d":"$0.00"}]
[28,"Orange or Yellow Safety fence",null,"Linear feet",2000,{"v":0,"d":"$0.00"}]
[29,"Staking and guying of trees with 3/4 inch wide flat, woven polypropylene material, 900 Lb break strength",null,"Per tree",1200,{"v":0,"d":"$0.00"}]
[30,"Removal of staking and guying of trees",null,"Per tree",1200,{"v":0,"d":"$0.00"}]
[31,"9 inch Plastic tree trunk protector",null,"Per tree",500,{"v":0,"d":"$0.00"}]
[32,"Plastic Deer protection sleeve wrap for tree trunks",null,"Per tree",500,{"v":0,"d":"$0.00"}]
[33,"4 ft Deer protection welded wire 2\" x 4\" mesh fence, 2 ft radius around tree, installed with T posts",null,"Per tree",500,{"v":0,"d":"$0.00"}]
[34,"6 ft Deer protection welded wire 2\" x 4\" mesh fence, 2 ft radius around tree, installed with T posts",null,"Per tree",500,{"v":0,"d":"$0.00"}]
[35,"Beaver barrier",null,"Per tree",25,{"v":0,"d":"$0.00"}]
[36,"Gravel, No 57",null,"Ton",20,{"v":0,"d":"$0.00"}]
[37,"5-8 inch River jack",null,"Ton",20,{"v":0,"d":"$0.00"}]
[38,"Western Maryland or Pennsylvania Boulder",null,"Ton",20,{"v":0,"d":"$0.00"}]
[39,"Wood mulch",null,"Cubic yard",500,{"v":0,"d":"$0.00"}]
[40,"Pine bark mulch",null,"Cubic yard",500,{"v":0,"d":"$0.00"}]
[41,"Composted Leaf mulch",null,"Cubic yard",500,{"v":0,"d":"$0.00"}]
[42,"Compost",null,"Cubic yard",500,{"v":0,"d":"$0.00"}]
[43,"Bioretention filter media",null,"Cubic yard",250,{"v":0,"d":"$0.00"}]
[44,"Specialty seed for bioretention areas, Wetland Seed Mix – Ernst Seed #120 or similar",null,"Square ft",250,{"v":0,"d":"$0.00"}]
[45,"Specialty seed for bioretention areas, Wetland Seed Mix – Ernst Seed #131 or similar",null,"Square ft",250,{"v":0,"d":"$0.00"}]
[46,"Native plant seed for reforestation - Ernst Seed #105 or similar",null,"Square ft",250,{"v":0,"d":"$0.00"}]
[50,"Soil profile rebuilding",null,"Square ft",500,{"v":0,"d":"$0.00"}]
[51,"Transplanting of trees below 5 inches caliper, per ANSI standards",null,"Per inch caliper of tree",50,{"v":0,"d":"$0.00"}]
[]
["GRAND TOTAL",{"$nulls":4},{"$f":"SUM(F6:F53)","v":{"v":0,"d":"$0.00"}}]
[]
["NOTES: "]
["OTHER THAN THE LABOR COSTS, ALL PRICES IN ATTACHMENT B, PRICING SHEET FOR: TREE COSTS, NON-TREE COSTS, AND OTHER SERVICES SHALL INCLUDE COST OF LABOR, EQUIPMENT, AND MATERIAL."]
["NO PARTIAL BIDS WILL BE ACCEPTED."]

{"sheet":"Labor Costs","index":3,"n_rows":17,"n_cols":4,"rows_kept":17,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[7,0,7,1]]}
["TREE PLANTING SERVICES"]
["EXHIBIT B - PRICING SHEET"]
["23-DPR-ITBLW-444"]
["ITEM","SERVICE REQUESTED","LABOR CATEGORY","HOURLY RATE"]
[1,"Installation of county-provided plants","Horticulturalist"]
[2,"Installation of county-provided plants","Supervisor"]
[3,"Installation of county-provided plants","Equipment Operator"]
["LABOR COSTS ONLY - TOTAL",null,null,{"$f":"SUM(D5:D7)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[null,"TOTAL:  NON-TREE COSTS",{"$f":"'Non-Tree Costs'!G56:G56","v":{"v":0,"d":"$0.00"}}]
[null,"TOTAL:  TREE COSTS",{"$f":"'Tree Costs'!G23","v":{"v":0,"d":"$0.00"}}]
[null,"TOTAL:  OTHER SERVICES",{"$f":"'Other Services'!F55:F55","v":{"v":0,"d":"$0.00"}}]
[null,"TOTAL:  LABOR COSTS",{"$f":"D8","v":{"v":0,"d":"$0.00"}}]
[null,"GRAND TOTAL:  ALL COSTS",{"$f":"SUM(C11:C14)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"*Totals should auto populate, please ensure they carry forward correctly."]