{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Main","Storm Drains","Sewer","Water","Grading","Paving"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Main","index":0,"n_rows":68,"n_cols":5,"rows_kept":68,"cut":false,"hidden":false,"merged":[[15,0,15,4],[5,0,5,2]]}
["Estimator Toolkit"]
["CCE 170 - Brigham Young University"]
[]
["Path:","C:\\temp2\\estimator"]
[]
["DATA IMPORTER"]
["File #","File Name","Sheet Name"]
[1,"stormdrain.xlsx","Storm Drains"]
[2,"sewer.xlsx","Sewer"]
[3,"water.xlsx","Water"]
[4,"grading.xlsx","Grading"]
[5,"paving.xlsx","Paving"]
[]
[]
[]
["SUMMARY TABLE"]
["Category","Item","Count","Unit Cost","Cost"]
["Storm Drains","30\" Alternate Pipe Culvert; D-60, G-2-E",20,101,2020]
["Storm Drains","36\" Alternate Pipe Culvert; D,60, G-2-E",32,122,3904]
["Storm Drains","Type \"A,B or C\" Inlet, L=5'; D-1,2 & 3 ",4,3600,14400]
["Storm Drains","Type \"A,B or C\" Inlet, L=10'; D-1,2 & 3 ",12,4000,48000]
["Storm Drains","Type \"F\" Catch Basin; D-7",53,2800,148400]
["Storm Drains","Type \"G\" Catch Basin; D-8",62,2800,173600]
["Storm Drains","Curb Outlet - Type \"A\"; D-25",6,1550,9300]
["Sewer","Sewer Manhole; S-1-E",3,3750,11250]
["Sewer","Adjust Manhole rim to grade",3,535,1605]
["Sewer","8\" Stub and Plug",15,175,2625]
["Sewer","4\" or 6\" Sewer Lateral (30 feet long); S-2-E",20,1700,34000]
["Sewer","Sewer Cleanout; S-3",23,1060,24380]
["Sewer","8\" PVC Sewer Main; S-4, G-2-E",54,45.85,2475.9]
["Sewer","10\" PVC Sewer Main S-4, G-2-E",93,52.25,4859.25]
["Water","1\" Water Service; W-1-E",10,1400,14000]
["Water","2\" Water Service; W-2-E",5,1500,7500]
["Water","Relocate Water Meter; W-1-E & W-2-E",73,690,50370]
["Water","Adjust Water Meter Box to Grade",34,122,4148]
["Water","Fire Hydrant Assembly; W-3-E, W-11",23,3950,90850]
["Water","Relocate Fire Hydrant; W-3-E",9,2280,20520]
["Water","8\" Gate Valve; W-4-E",19,1040,19760]
["Water","12\" Gate Valve; W-4-E",16,1410,22560]
["Water","14\" Butterfly Valve",4,2120,8480]
["Grading","Slope landscaping and Irrigation",155700,1.25,194625]
["Grading","Siltation Fence (SC-1)",19540,2.4500000000000002,47873]
["Grading","Desilting Basin ( SC-2)",2,10000,20000]
["Grading","Check Dams (SC-4)",12,750,9000]
["Grading","Sediment Trap (SC-3)",7,2500,17500]
["Grading","Hydroseeding (SS-4)",155700,0.2,31140]
["Grading","Geotextiles, Plastic, Erosion Control Mats (SS-7)",215000,0.3,64500]
["Grading","Sand and gravel bags (SC-6& SC-8)",3250,5,16248]
["Grading","Fiber Rolls (SC-5)",25,7,175]
["Grading","Straw Bales (SC-9)",50,13,650]
["Grading","Storm Drain Inlet Protection ( SC-10)",77,200,15400]
["Grading","Stabilized Construction Entrance ( TC-1)",600,1.25,750]
["Paving","Asphalt Concrete Paving",200,48.4,9680]
["Paving","1 1/2\" AC Overlay",23000,0.5,11500]
["Paving","2\" AC Overlay",12087,0.65,7856.55]
["Paving","3\" AC over 6\" AB Transitional Paving",9211,1.52,14000.72]
["Paving","3\" AC paving over approved AB (8\" assumed)",2728,1.72,4692.16]
["Paving","4\" AC paving over approved AB (13\" assumed)",324960,2.54,825398.4]
["Paving","5\" AC paving over approved AB (15\" assumed)",4122,3.05,12572.1]
["Paving","Asphalt Seal Coat",324960,0.09,29246.400000000001]
["Paving","Chipseal",41345,0.33,13643.85]
["Paving","Asphalt Grinding",2131,0.45,958.95]
["Paving","Sawcut AC paving",2133,1.28,2730.24]
["Paving","Class 2 Aggregate Base",6463,33,213279]
["Paving","Pavement Reinforcing Fabric",5457,0.3,1637.1]
["Paving","Geotextile fabric",4574,0.3,1372.2]
[]
[null,null,null,"Total:",{"$f":"SUM(E$17:E66)","v":2285435.8200000003}]

{"sheet":"Storm Drains","index":1,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Item","Count","Unit Cost","Cost"]
["30\" Alternate Pipe Culvert; D-60, G-2-E",20,101,2020]
["36\" Alternate Pipe Culvert; D,60, G-2-E",32,122,3904]
["Type \"A,B or C\" Inlet, L=5'; D-1,2 & 3 ",4,3600,14400]
["Type \"A,B or C\" Inlet, L=10'; D-1,2 & 3 ",12,4000,48000]
["Type \"F\" Catch Basin; D-7",53,2800,148400]
["Type \"G\" Catch Basin; D-8",62,2800,173600]
["Curb Outlet - Type \"A\"; D-25",6,1550,9300]

{"sheet":"Sewer","index":2,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Item","Count","Unit Cost","Cost"]
["Sewer Manhole; S-1-E",3,3750,11250]
["Adjust Manhole rim to grade",3,535,1605]
["8\" Stub and Plug",15,175,2625]
["4\" or 6\" Sewer Lateral (30 feet long); S-2-E",20,1700,34000]
["Sewer Cleanout; S-3",23,1060,24380]
["8\" PVC Sewer Main; S-4, G-2-E",54,45.85,2475.9]
["10\" PVC Sewer Main S-4, G-2-E",93,52.25,4859.25]

{"sheet":"Water","index":3,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Item","Count","Unit Cost","Cost"]
["1\" Water Service; W-1-E",10,1400,14000]
["2\" Water Service; W-2-E",5,1500,7500]
["Relocate Water Meter; W-1-E & W-2-E",73,690,50370]
["Adjust Water Meter Box to Grade",34,122,4148]
["Fire Hydrant Assembly; W-3-E, W-11",23,3950,90850]
["Relocate Fire Hydrant; W-3-E",9,2280,20520]
["8\" Gate Valve; W-4-E",19,1040,19760]
["12\" Gate Valve; W-4-E",16,1410,22560]
["14\" Butterfly Valve",4,2120,8480]

{"sheet":"Grading","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Item","Count","Unit Cost","Cost"]
["Slope landscaping and Irrigation",155700,1.25,194625]
["Siltation Fence (SC-1)",19540,2.4500000000000002,47873]
["Desilting Basin ( SC-2)",2,10000,20000]
["Check Dams (SC-4)",12,750,9000]
["Sediment Trap (SC-3)",7,2500,17500]
["Hydroseeding (SS-4)",155700,0.2,31140]
["Geotextiles, Plastic, Erosion Control Mats (SS-7)",215000,0.3,64500]
["Sand and gravel bags (SC-6& SC-8)",3250,5,16248]
["Fiber Rolls (SC-5)",25,7,175]
["Straw Bales (SC-9)",50,13,650]
["Storm Drain Inlet Protection ( SC-10)",77,200,15400]
["Stabilized Construction Entrance ( TC-1)",600,1.25,750]

{"sheet":"Paving","index":5,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Item","Count","Unit Cost","Cost"]
["Asphalt Concrete Paving",200,48.4,9680]
["1 1/2\" AC Overlay",23000,0.5,11500]
["2\" AC Overlay",12087,0.65,7856.55]
["3\" AC over 6\" AB Transitional Paving",9211,1.52,14000.72]
["3\" AC paving over approved AB (8\" assumed)",2728,1.72,4692.16]
["4\" AC paving over approved AB (13\" assumed)",324960,2.54,825398.4]
["5\" AC paving over approved AB (15\" assumed)",4122,3.05,12572.1]
["Asphalt Seal Coat",324960,0.09,29246.400000000001]
["Chipseal",41345,0.33,13643.85]
["Asphalt Grinding",2131,0.45,958.95]
["Sawcut AC paving",2133,1.28,2730.24]
["Class 2 Aggregate Base",6463,33,213279]
["Pavement Reinforcing Fabric",5457,0.3,1637.1]
["Geotextile fabric",4574,0.3,1372.2]