{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Summary","Data"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":6,"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":"Instructions","index":0,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Instructions"]
[null,1,"On the Summary Tab, click the \"Browse for Pay Item\" button, hit the \"Browse for Pay Item File\" in the dialog box and browse to N:\\CFL-DPIT\\Excel\\PayItems14.csv and select \"Open\" or if you downloaded the file off the network browse to the location to where it was saved."]
[null,null,"Click the \"Return to Excel\" button."]
[]
[null,2,"On the Summary Tab, click the \"Add/Remove Pay Items\" button."]
[null,null,"Pay items are broken out by pay item categories.  Choose the desired pay item category."]
[null,null,"Select the desired pay item and select \"Add Item\".  Repeat for all required pay items."]
[null,null,"To remove pay items click the \"Delete a pay item already placed in sheet\" button and select the desired pay item and click the \"delete item\" button.  Click the \"Close\" button to close the dialog box."]
[null,null,"When all desired pay items have been added click the \"Close\" button."]
[]
[null,3,"Add station ranges and quantities.  Add and remove schedules to tables using the buttons at the top of the Summary tab.  Hide and unhide rows to tables using the buttons at the top of the Summary tab.  Merge and center title over the entire table width."]
[]
[null,4,"Using the Engineer's Estimate Manual (http://www.cflhd.gov/resources/design/eeprog/documents/EE_Guidance_Manual.pdf    ), determine the correct rounding % and round up values for each item."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"The Bid schedule and allowance quantities will be automatically calculated at the bottom but should not be included in tabulation sheets."]
[null,5,"DO NOT MANUALLY ADD ANY COLUMNS TO THE SPREADSHEET."]

{"sheet":"Summary","index":1,"n_rows":118,"n_cols":12,"rows_kept":118,"cut":false,"hidden":false,"merged":[[4,3,4,6],[102,11,102,14],[80,3,80,4],[99,3,99,4],[98,3,98,4],[97,3,97,4],[96,3,96,4],[95,3,95,4],[94,3,94,4],[93,3,93,4],[92,3,92,4],[91,3,91,4],[90,3,90,4],[89,3,89,4],[88,3,88,4],[87,3,87,4],[86,3,86,4],[85,3,85,4],[84,3,84,4],[83,3,83,4],[82,3,82,4],[81,3,81,4],[70,3,70,4],[79,3,79,4],[78,3,78,4],[77,3,77,4],[76,3,76,4],[75,3,75,4],[36,3,36,4],[35,3,35,4],[46,3,46,4],[45,3,45,4],[44,3,44,4],[43,3,43,4],[42,3,42,4],[41,3,41,4],[40,3,40,4],[39,3,39,4],[74,3,74,4],[73,3,73,4],[72,3,72,4],[71,3,71,4],[34,3,34,4],[55,3,55,4],[54,3,54,4],[53,3,53,4],[68,3,68,4],[67,3,67,4],[66,3,66,4],[60,3,60,4],[59,3,59,4],[58,3,58,4],[57,3,57,4],[56,3,56,4],[65,3,65,4],[64,3,64,4],[63,3,63,4],[62,3,62,4],[61,3,61,4],[37,3,37,4],[52,3,52,4],[51,3,51,4],[50,3,50,4],[49,3,49,4],[48,3,48,4],[47,3,47,4],[33,3,33,4],[32,3,32,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[25,3,25,4],[24,3,24,4],[23,3,23,4],[26,3,26,4],[31,3,31,4],[30,3,30,4],[29,3,29,4],[28,3,28,4],[27,3,27,4],[1,11,1,14],[2,11,2,14],[5,2,5,6],[6,3,7,4],[6,5,7,5],[38,2,38,6],[114,0,114,2],[6,2,7,2],[6,6,7,6],[109,0,109,2],[69,2,69,6],[100,2,100,6],[104,0,104,2],[8,3,8,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4]]}
[null,null,null,null,null,"Pay Item File:","N:\\CFL-DPIT\\Excel\\Payitems14.csv"]
[null,null,null,null,null,null,null,"Leave this column HIDDEN!!! Do not delete"]
["Check Column - do not delete",null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(H2,Data!$A:$C,2,FALSE)),\"\",VLOOKUP(H2,Data!$A:$C,2,FALSE))","v":""},null,null,null,"Do not manually add columns to the spreadsheet.  The macro will become inoperable if columns are added to the left of the remarks column."]
[]
[null,null,"DRAINAGE SUMMARY","DRAINAGE SUMMARY",null,null,null,null,null,null,null,"*Remember to Merge and Center the Title over the entire table"]
[null,null,"Item Number",null,null,null,null,{"$f":"H2","v":"Leave this column HIDDEN!!! Do not delete"}]
[null,null,"Schedule","Station",null,"Side","Skew (deg)",{"$f":"IF(ISBLANK(H2),\"\",LOOKUP(H2,'[1]FP14 Pay Items'!$A$1:$A$65536,'[1]FP14 Pay Items'!$D$1:$D$65536))","v":"FUNDING RECLASSIFICATION"},"Remarks"]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H2),\"\",LOOKUP(H2,'[1]FP14 Pay Items'!$A$1:$A$65536,'[1]FP14 Pay Items'!$E$1:$E$65536))","v":"LPSM"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(Data!$D$2=1,IF(Data!$G$2=1,\"TOTAL\",IF(Data!$G$2=2,\"SCHEDULE A TOTAL\",IF(Data!$G$2=3,\"SCHEDULE A TOTAL\",\"SCHEDULE A TOTAL\"))),IF(Data!$G$2=2,\"SCHEDULE A TOTALS\",IF(Data!$G$2=3,\"SCHEDULE A TOTALS\",\"TOTALS\")))","v":"TOTALS"},null,null,null,null,{"$f":"IF(H$8=\"LPSM\",\"ALL\",SUM(H$9:H$38))","v":"ALL"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(Data!$D$2=1,IF($N$1=1,\"TOTAL\",IF(N32=2,\"SCHEDULE B TOTAL\",IF($N$1=3,\"SCHEDULE B TOTAL\",\"SCHEDULE B TOTAL\"))),IF($N$1=1,\"TOTALS\",IF($N$1=2,\"SCHEDULE B TOTALS\",IF($N$1=3,\"SCHEDULE B TOTALS\",\"SCHEDULE B TOTALS\"))))","v":"SCHEDULE B TOTALS"},null,null,null,null,{"$f":"IF(H$8=\"LPSM\",\"ALL\",SUM(H$40:H$69)+H$39)","v":"ALL"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(Data!$D$2=1,IF($N$1=1,\"TOTAL\",IF($N$1=2,\"SCHEDULE C TOTAL\",IF($N$1=3,\"SCHEDULE C TOTAL\",\"SCHEDULE C TOTAL\"))),IF($N$1=1,\"TOTALS\",IF($N$1=2,\"SCHEDULE C TOTALS\",IF($N$1=3,\"SCHEDULE C TOTALS\",\"SCHEDULE C TOTALS\"))))","v":"SCHEDULE C TOTALS"},null,null,null,null,{"$f":"IF(H$8=\"LPSM\",\"ALL\",SUM(H$71:H$100)+H$70)","v":"ALL"}]
[]
[null,null,null,"Note:  \n1.  The quantities, locations, and skews shown here on are approximate and are subject to field adjustment.  Do not order culvert pipe or appurtenances until the actual quantities are approved in the field.\n2.  For riprap installation use geotextile filter, class ##, type #, woven/non-woven.  See subsection 714.01(a).",null,null,null,null,null,null,null,"Confirm class and type of geotextile with Geotech and Hydraulics CFT members.  "]
[]
[{"$f":"IF(Data!$G$2=1,\" \",IF(Data!$G$2=2,\"Schedule A\",IF(Data!$G$2=3,\"Schedule A\")))","v":" "},null,null,"Rounding %"]
[null,null,null,"Round up"]
[null,null,null,"Bid Schedule",null,null,null,{"$f":"IF(H$8=\"each\",H$39,IF(H$8=\"LPSM\",\"LPSM\",IF(H$106=0,ROUND((H$39*(1+H$105)),0),CEILING(H$39*(1+H$105),H$106))))","v":"LPSM"}]
[null,null,null,"Allowance",null,null,null,{"$f":"IF(H$8=\"LPSM\",\"--\",H$107-H$39)","v":"--"}]
[]
[{"$f":"IF(Data!$G$2=1,\" \",IF(Data!$G$2=2,\"Schedule B\",IF(Data!$G$2=3,\"Schedule B\")))","v":" "},null,null,{"$f":"IF(Data!$G$2=1, \"\", \"Rounding %\")","v":""}]
[null,null,null,{"$f":"IF(Data!$G$2=1, \" \", \"Round up\")","v":" "}]
[null,null,null,{"$f":"IF(Data!$G$2=1, \" \", \"Bid Schedule\")","v":" "},null,null,null,{"$f":"IF(Data!G2=1,\"\",IF(H$8=\"each\",H$70,IF(H$8=\"LPSM\",\"LPSM\",IF(H$111=0,ROUND((H$70*(1+H$110)),0),CEILING(H$70*(1+H$110),H$111)))))","v":""}]
[null,null,null,{"$f":"IF(Data!$G$2=1, \" \", \"Allowance\")","v":" "},null,null,null,{"$f":"IF(Data!G2=1,\"\",IF(H$8=\"LPSM\",\"--\",H$112-H$70))","v":""}]
[]
[{"$f":"IF(Data!$G$2=1,\" \",IF(Data!$G$2=2,\" \",IF(Data!$G$2=3,\"Schedule C\")))","v":" "},null,null,{"$f":"IF(Data!$G$2=1, \"\", IF(Data!$G$2=2, \"\", \"Rounding %\"))","v":""}]
[null,null,null,{"$f":"IF(Data!$G$2=1, \" \", IF(Data!$G$2=2, \"\", \"Round up\"))","v":" "}]
[null,null,null,{"$f":"IF(Data!$G$2=1, \" \", IF(Data!$G$2=2, \"\", \"Bid Schedule\"))","v":" "},null,null,null,{"$f":"IF(Data!G2=1,\"\",IF(H$8=\"each\",H$101,IF(H$8=\"LPSM\",\"LPSM\",IF(H$116=0,ROUND((H$101*(1+H$115)),0),CEILING(H$101*(1+H$115),H$116)))))","v":""}]
[null,null,null,{"$f":"IF(Data!$G$2=1, \" \", IF(Data!$G$2=2, \"\", \"Allowance\"))","v":" "},null,null,null,{"$f":"IF(Data!G2=1,\"\",IF(H$8=\"LPSM\",\"--\",H$117-H$101))","v":""}]

{"sheet":"Data","index":2,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Pay Item Number","Description","Unit","Num Items",null,"Sides","Schedules"]
[null,null,null,{"$f":"COUNTA(A:A)-1","v":0},null,"LT",1]
[null,null,null,null,null,"RT"]
[null,null,null,null,null,"LT/RT"]