{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Information","Sheet","Calculations","Variables"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":38,"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":"Information","index":0,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[12,0,14,1],[11,3,11,4],[5,1,5,4],[1,1,1,4],[3,1,3,4],[4,1,4,4],[7,1,7,4],[2,1,2,4],[8,3,8,4],[9,3,10,4]]}
[null,"Information"]
[{"$f":"OFFSET(A2,-1,0)+1","v":1},"Add project/sheet information below.  Use the \"Reload Data\" button to select the correct CSV file.    Fill in the constants below."]
[{"$f":"OFFSET(A3,-1,0)+1","v":2},"Make modifications to the Sheet tab before adding additional sheets.  \n - The column widths for the description and remarks may be resized and the content will reformat to match the width of the columns on the first sheet (F9 to recalculate).  Ensure that the content fits on the sheet.\n - Only resize columns F to Y.  Keep columns D and AA outside the sheet border.\n - Notes may be added to the bottom right half of the sheet.  ",null,null,null,{"$f":"IFERROR(IF(OR(trunDesc,trunRemarks),\"Content truncated from:\"&IF(trunDesc,CHAR(10)&\" - Description\",\"\")&IF(trunRemarks,CHAR(10)&\" - Remarks\",\"\")&CHAR(10)&\"Check and adjust columns to fit entire text.\",\"\"),\"The Description and/or Remarks columns are too short to see content.  Resize.\")","v":""}]
[{"$f":"OFFSET(A4,-1,0)+1","v":3},"The Summary of Quantity sheets are located on the Sheet, Sheet (2), etc. tabs.  To copy a sheet, hold the left mouse button on the worksheet's tab (below) while pressing the <CTRL> key.  A mini sheet with a plus sign should appear.  Drag this and drop it to the desired location.  "]
[{"$f":"OFFSET(A5,-1,0)+1","v":4},"Until the file is saved, the filename block will be blank.  Sheet numbers may not update until having exited and reentered the file."]
[]
[null,"Constants"]
[null,"Insert the following values (they will appear on every sheet):"]
[null,"Project: ","AZ FTNP GRCA 13(1)\nMT OMAD 18(38)","Note:  If there is more than one project number, use <ALT><ENTER> to insert page break for additional lines."]
[null,"NPS PMIS No. ","NPS PMIS No. ","Note: NPS fields do not appear on the sheet unless additional text is added."]
[null,"NPS Drwg No. ","NPS Drwg No. "]
[null,"First sheet num: ","B.1",{"$f":"MIN(Sheets.needed,Sheets.available)&\" of \"&Sheets.needed&\" Needed sheets available\"","v":"1 of 4 Needed sheets available"}]
[{"$f":"\"(\"&IF(ISNUMBER(FIND(\".\",Sheet)),\"WFL\",\"CFL or EFL\")&\" format shown.  \"&IF(ISNUMBER(FIND(\".\",Sheet)),\"CFL or EFL\",\"WFL\")&\" format \"&IF(ISNUMBER(FIND(\".\",Sheet)),\"does not contain\",\"contains\")&\" a \"\"period\"\" separator)\"","v":"(WFL format shown.  CFL or EFL format does not contain a \"period\" separator)"}]
[null,null,null,{"$f":"IF(ISNA(Metric),\"Error in Units\",IF(Metric,\"Metric\",\"US Customary\")&\" units used\")","v":"Metric units used"}]
[null,null,null,"Revised:","2022-11-03"]

{"sheet":"Sheet","index":1,"n_rows":50,"n_cols":26,"rows_kept":50,"cut":false,"hidden":false,"merged":[[49,6,49,9],[0,0,1,2],[6,5,8,5],[6,6,8,6],[6,7,8,7],[2,0,2,1],[3,0,3,1],[5,0,5,1],[5,5,5,24],[44,3,49,3],[6,24,8,24],[6,8,8,8],[6,9,8,9],[6,23,7,23],[6,0,6,1],[5,3,42,3]]}
["Sheet Information",null,null,null,null,null,null,null,null,null,{"$f":"OFFSET(EEBACS,2,K2,1,1)","v":"C: Typical Section"},"D: Plan, Roadway","E: Layout, Parking Area","F: Drainage","G: Walls","M: Temp. Erosion Control","P: Perm. Traffic Control","***: Column 8","B.66-B.85`: Column 9","-: Column 10","Plan: Allow- ance","C12: Column 12","C13: Column 13"]
[null,null,null,null,null,{"$f":"MATCH(F7&\"*\",OFFSET(EEBACS,2,0,1,EEBACS.cols),0)-1","v":0},{"$f":"MATCH(G7&\"*\",OFFSET(EEBACS,2,0,1,EEBACS.cols),0)-1","v":1},{"$f":"MATCH(H7&\"*\",OFFSET(EEBACS,2,0,1,EEBACS.cols),0)-1","v":2},{"$f":"MATCH(I7,OFFSET(Calcs,0,0,1,COLUMNS(Calcs)),0)","v":4},{"$f":"MATCH(J7&\"*\",OFFSET(EEBACS,2,0,1,EEBACS.cols),0)-1","v":4},{"$f":"IF(OFFSET(K2,0,-1)+1<$X2,OFFSET(K2,0,-1)+1,$X2+2)","v":5},6,7,8,9,10,11,12,13,14,15,16,17,{"$f":"MATCH(X7&\"*\",OFFSET(EEBACS,2,0,1,EEBACS.cols),0)-1","v":18},{"$f":"MATCH(Y7,OFFSET(Calcs,0,0,1,COLUMNS(Calcs)),0)","v":46}]
["Sheet num:",null,{"$f":"INDEX(SheetNames[Sheet],MATCH(C4,SheetNames[Worksheet],0))","v":"B.1"}]
["Sheet name:",null,{"$f":"RIGHT(Filename,LEN(Filename)-FIND(\"]\",Filename))","v":"Sheet"}]
[null,null,null,null,"left",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN(SUBSTITUTE(SUBSTITUTE(NPS.PMIS,\".\",\"\"),\" \",\"\"))>9,NPS.PMIS,\"\")&IF(LEN(SUBSTITUTE(SUBSTITUTE(NPS.Drwg,\".\",\"\"),\" \",\"\"))>9,REPT(\" \",3)&NPS.Drwg,\"\")","v":""},"right"]
["Show \"Schedule / Option\" text in sheet title?",null,null,{"$f":"CELL(\"filename\",Filename)","v":"C:\\pw-work\\d0561506\\[summary.xlsm]Sheet"},null,{"$f":"\"SUMMARY OF QUANTITIES\"&IF(LEFT(Type,1)=\"<\",\"\",\" - \"&Type&\" \"&LEFT(VLOOKUP(OFFSET(Begin,1,2),Calcs,col_Schedule,0),1))","v":"SUMMARY OF QUANTITIES - Schedule A"}]
["Schedule",null,null,null,null,"AMEND","Line Item No.","Pay Item Number","Pay Item Description","Unit","Sheet and Description",null,null,null,null,null,null,null,null,null,null,null,null,"Estimated Quantities","Remarks and/or Determination of Estimated Quantity"]
[null,{"$f":"MATCH(B9,OFFSET(EEBACS,2,0,1,EEBACS.cols),0)-1","v":20},null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(FIND(\":\",K1)),LEFT(K1,FIND(\":\",K1)-1),\"\")","v":"C"},"D","E","F","G","M","P","***","B.66-B.85`","-","Plan","C12","C13"]
[{"$f":"INDEX(SheetNames[Begins],MATCH(Sheet.number,SheetNames[Sheet],0))","v":0},"Deleted",null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(FIND(\":\",K1)),TRIM(SUBSTITUTE(K1,K8&\":\",\"\")),\"\")","v":"Typical Section"},"Plan, Roadway","Layout, Parking Area","Drainage","Walls","Temp. Erosion Control","Perm. Traffic Control","Column 8","Column 9","Column 10","Allow- ance","Column 12","Column 13","Bid Schedule"]
[{"$f":"OFFSET(A10,-1,0)+1","v":1},{"$f":"IF($A10>End,\"\",OFFSET(EEBACS,MATCH($C10,OFFSET(Calcs,0,0,ROWS(Calcs),1),0),B$8,1,1)=1)","v":false},{"$f":"IFERROR(VLOOKUP(A10,Calcs,1,0),OFFSET(C10,1,0))","v":1},null,null,{"$f":"IF(OR($C10=OFFSET($C10,-1,0),$A10>End),\"\",OFFSET(EEBACS,MATCH($C10,OFFSET(Calcs,0,0,ROWS(Calcs),1),0),F$2,1,1))","v":0},"A0010","15101-0000",{"$f":"IF(OR($A10>End,COUNTIF($C$9:$C10,$C10)>lines_D),\"\",IF(COUNTIF($C$9:$C10,$C10)=1,LEFT(VLOOKUP($C10,Calcs,col_Description,0),VLOOKUP($C10,Calcs,col_D,0)),MID(VLOOKUP($C10,Calcs,col_Description,0),VLOOKUP($C10,Calcs,col_D+COUNTIF($C$9:$C10,$C10)-2,0)+1,VLOOKUP($C10,Calcs,col_D+COUNTIF($C$9:$C10,$C10)-1,0)-VLOOKUP($C10,Calcs,col_D+COUNTIF($C$9:$C10,$C10)-2,0))))","v":"Mobilization"},{"$f":"IF(OR($C10=OFFSET($C10,1,0),$A10>End),\"\",OFFSET(EEBACS,MATCH($C10,OFFSET(Calcs,0,0,ROWS(Calcs),1),0),J$2,1,1))","v":"LPSM"},{"$f":"IF(OR($C10=OFFSET($C10,1,0),$A10>End),\"\",SUBSTITUTE(SUBSTITUTE(OFFSET(EEBACS,MATCH($C10,OFFSET(Calcs,0,0,ROWS(Calcs),1),0),K$2,1,1),\"All|\",\"\",1),\"||\",\"\"))","v":""},"","","","","","","","","","","","","ALL",{"$f":"IF(OR($A10>End,COUNTIF($C$9:$C10,$C10)>lines_R),\"\",IF(COUNTIF($C$9:$C10,$C10)=1,LEFT(VLOOKUP($C10,Calcs,col_Remarks,0),VLOOKUP($C10,Calcs,col_R,0)),MID(VLOOKUP($C10,Calcs,col_Remarks,0),VLOOKUP($C10,Calcs,col_R+COUNTIF($C$9:$C10,$C10)-2,0)+1,VLOOKUP($C10,Calcs,col_R+COUNTIF($C$9:$C10,$C10)-1,0)-VLOOKUP($C10,Calcs,col_R+COUNTIF($C$9:$C10,$C10)-2,0))))","v":""}]
[2,false,2,null,null,0,"A0020","15201-0000",{"$f":"IF(OR($A11>End,COUNTIF($C$9:$C11,$C11)>lines_D),\"\",IF(COUNTIF($C$9:$C11,$C11)=1,LEFT(VLOOKUP($C11,Calcs,col_Description,0),VLOOKUP($C11,Calcs,col_D,0)),MID(VLOOKUP($C11,Calcs,col_Description,0),VLOOKUP($C11,Calcs,col_D+COUNTIF($C$9:$C11,$C11)-2,0)+1,VLOOKUP($C11,Calcs,col_D+COUNTIF($C$9:$C11,$C11)-1,0)-VLOOKUP($C11,Calcs,col_D+COUNTIF($C$9:$C11,$C11)-2,0))))","v":"Construction survey and staking"},"LPSM","","All","","","","","","","","","","","","ALL",{"$f":"IF(OR($A11>End,COUNTIF($C$9:$C11,$C11)>lines_R),\"\",IF(COUNTIF($C$9:$C11,$C11)=1,LEFT(VLOOKUP($C11,Calcs,col_Remarks,0),VLOOKUP($C11,Calcs,col_R,0)),MID(VLOOKUP($C11,Calcs,col_Remarks,0),VLOOKUP($C11,Calcs,col_R+COUNTIF($C$9:$C11,$C11)-2,0)+1,VLOOKUP($C11,Calcs,col_R+COUNTIF($C$9:$C11,$C11)-1,0)-VLOOKUP($C11,Calcs,col_R+COUNTIF($C$9:$C11,$C11)-2,0))))","v":""}]
[3,false,4,null,null,0,"A0030","15301-0010",{"$f":"IF(OR($A12>End,COUNTIF($C$9:$C12,$C12)>lines_D),\"\",IF(COUNTIF($C$9:$C12,$C12)=1,LEFT(VLOOKUP($C12,Calcs,col_Description,0),VLOOKUP($C12,Calcs,col_D,0)),MID(VLOOKUP($C12,Calcs,col_Description,0),VLOOKUP($C12,Calcs,col_D+COUNTIF($C$9:$C12,$C12)-2,0)+1,VLOOKUP($C12,Calcs,col_D+COUNTIF($C$9:$C12,$C12)-1,0)-VLOOKUP($C12,Calcs,col_D+COUNTIF($C$9:$C12,$C12)-2,0))))","v":"Contractor quality control and "},"","","","","","","","","","","","","","","",{"$f":"IF(OR($A12>End,COUNTIF($C$9:$C12,$C12)>lines_R),\"\",IF(COUNTIF($C$9:$C12,$C12)=1,LEFT(VLOOKUP($C12,Calcs,col_Remarks,0),VLOOKUP($C12,Calcs,col_R,0)),MID(VLOOKUP($C12,Calcs,col_Remarks,0),VLOOKUP($C12,Calcs,col_R+COUNTIF($C$9:$C12,$C12)-2,0)+1,VLOOKUP($C12,Calcs,col_R+COUNTIF($C$9:$C12,$C12)-1,0)-VLOOKUP($C12,Calcs,col_R+COUNTIF($C$9:$C12,$C12)-2,0))))","v":""}]
[4,false,4,null,null,"","","",{"$f":"IF(OR($A13>End,COUNTIF($C$9:$C13,$C13)>lines_D),\"\",IF(COUNTIF($C$9:$C13,$C13)=1,LEFT(VLOOKUP($C13,Calcs,col_Description,0),VLOOKUP($C13,Calcs,col_D,0)),MID(VLOOKUP($C13,Calcs,col_Description,0),VLOOKUP($C13,Calcs,col_D+COUNTIF($C$9:$C13,$C13)-2,0)+1,VLOOKUP($C13,Calcs,col_D+COUNTIF($C$9:$C13,$C13)-1,0)-VLOOKUP($C13,Calcs,col_D+COUNTIF($C$9:$C13,$C13)-2,0))))","v":"assurance"},"LPSM","","","","","","","","","","","","","","ALL",{"$f":"IF(OR($A13>End,COUNTIF($C$9:$C13,$C13)>lines_R),\"\",IF(COUNTIF($C$9:$C13,$C13)=1,LEFT(VLOOKUP($C13,Calcs,col_Remarks,0),VLOOKUP($C13,Calcs,col_R,0)),MID(VLOOKUP($C13,Calcs,col_Remarks,0),VLOOKUP($C13,Calcs,col_R+COUNTIF($C$9:$C13,$C13)-2,0)+1,VLOOKUP($C13,Calcs,col_R+COUNTIF($C$9:$C13,$C13)-1,0)-VLOOKUP($C13,Calcs,col_R+COUNTIF($C$9:$C13,$C13)-2,0))))","v":""}]
[5,false,5,null,null,0,"A0040","15401-0000",{"$f":"IF(OR($A14>End,COUNTIF($C$9:$C14,$C14)>lines_D),\"\",IF(COUNTIF($C$9:$C14,$C14)=1,LEFT(VLOOKUP($C14,Calcs,col_Description,0),VLOOKUP($C14,Calcs,col_D,0)),MID(VLOOKUP($C14,Calcs,col_Description,0),VLOOKUP($C14,Calcs,col_D+COUNTIF($C$9:$C14,$C14)-2,0)+1,VLOOKUP($C14,Calcs,col_D+COUNTIF($C$9:$C14,$C14)-1,0)-VLOOKUP($C14,Calcs,col_D+COUNTIF($C$9:$C14,$C14)-2,0))))","v":"Contractor testing"},"LPSM","","","","","","","","","","","","","","ALL",{"$f":"IF(OR($A14>End,COUNTIF($C$9:$C14,$C14)>lines_R),\"\",IF(COUNTIF($C$9:$C14,$C14)=1,LEFT(VLOOKUP($C14,Calcs,col_Remarks,0),VLOOKUP($C14,Calcs,col_R,0)),MID(VLOOKUP($C14,Calcs,col_Remarks,0),VLOOKUP($C14,Calcs,col_R+COUNTIF($C$9:$C14,$C14)-2,0)+1,VLOOKUP($C14,Calcs,col_R+COUNTIF($C$9:$C14,$C14)-1,0)-VLOOKUP($C14,Calcs,col_R+COUNTIF($C$9:$C14,$C14)-2,0))))","v":""}]
[6,false,6,null,null,0,"A0050","15501-0000",{"$f":"IF(OR($A15>End,COUNTIF($C$9:$C15,$C15)>lines_D),\"\",IF(COUNTIF($C$9:$C15,$C15)=1,LEFT(VLOOKUP($C15,Calcs,col_Description,0),VLOOKUP($C15,Calcs,col_D,0)),MID(VLOOKUP($C15,Calcs,col_Description,0),VLOOKUP($C15,Calcs,col_D+COUNTIF($C$9:$C15,$C15)-2,0)+1,VLOOKUP($C15,Calcs,col_D+COUNTIF($C$9:$C15,$C15)-1,0)-VLOOKUP($C15,Calcs,col_D+COUNTIF($C$9:$C15,$C15)-2,0))))","v":"Construction schedule"},"LPSM","","","","","","","","","","","","","","ALL",{"$f":"IF(OR($A15>End,COUNTIF($C$9:$C15,$C15)>lines_R),\"\",IF(COUNTIF($C$9:$C15,$C15)=1,LEFT(VLOOKUP($C15,Calcs,col_Remarks,0),VLOOKUP($C15,Calcs,col_R,0)),MID(VLOOKUP($C15,Calcs,col_Remarks,0),VLOOKUP($C15,Calcs,col_R+COUNTIF($C$9:$C15,$C15)-2,0)+1,VLOOKUP($C15,Calcs,col_R+COUNTIF($C$9:$C15,$C15)-1,0)-VLOOKUP($C15,Calcs,col_R+COUNTIF($C$9:$C15,$C15)-2,0))))","v":""}]
[7,false,8,null,null,0,"A0060","15704-1000",{"$f":"IF(OR($A16>End,COUNTIF($C$9:$C16,$C16)>lines_D),\"\",IF(COUNTIF($C$9:$C16,$C16)=1,LEFT(VLOOKUP($C16,Calcs,col_Description,0),VLOOKUP($C16,Calcs,col_D,0)),MID(VLOOKUP($C16,Calcs,col_Description,0),VLOOKUP($C16,Calcs,col_D+COUNTIF($C$9:$C16,$C16)-2,0)+1,VLOOKUP($C16,Calcs,col_D+COUNTIF($C$9:$C16,$C16)-1,0)-VLOOKUP($C16,Calcs,col_D+COUNTIF($C$9:$C16,$C16)-2,0))))","v":"Soil erosion control, plastic "},"","","","","","","","","","","","","","","",{"$f":"IF(OR($A16>End,COUNTIF($C$9:$C16,$C16)>lines_R),\"\",IF(COUNTIF($C$9:$C16,$C16)=1,LEFT(VLOOKUP($C16,Calcs,col_Remarks,0),VLOOKUP($C16,Calcs,col_R,0)),MID(VLOOKUP($C16,Calcs,col_Remarks,0),VLOOKUP($C16,Calcs,col_R+COUNTIF($C$9:$C16,$C16)-2,0)+1,VLOOKUP($C16,Calcs,col_R+COUNTIF($C$9:$C16,$C16)-1,0)-VLOOKUP($C16,Calcs,col_R+COUNTIF($C$9:$C16,$C16)-2,0))))","v":""}]
[8,false,8,null,null,"","","",{"$f":"IF(OR($A17>End,COUNTIF($C$9:$C17,$C17)>lines_D),\"\",IF(COUNTIF($C$9:$C17,$C17)=1,LEFT(VLOOKUP($C17,Calcs,col_Description,0),VLOOKUP($C17,Calcs,col_D,0)),MID(VLOOKUP($C17,Calcs,col_Description,0),VLOOKUP($C17,Calcs,col_D+COUNTIF($C$9:$C17,$C17)-2,0)+1,VLOOKUP($C17,Calcs,col_D+COUNTIF($C$9:$C17,$C17)-1,0)-VLOOKUP($C17,Calcs,col_D+COUNTIF($C$9:$C17,$C17)-2,0))))","v":"lining"},"m2","","","","","","165","","","","","","","","165",{"$f":"IF(OR($A17>End,COUNTIF($C$9:$C17,$C17)>lines_R),\"\",IF(COUNTIF($C$9:$C17,$C17)=1,LEFT(VLOOKUP($C17,Calcs,col_Remarks,0),VLOOKUP($C17,Calcs,col_R,0)),MID(VLOOKUP($C17,Calcs,col_Remarks,0),VLOOKUP($C17,Calcs,col_R+COUNTIF($C$9:$C17,$C17)-2,0)+1,VLOOKUP($C17,Calcs,col_R+COUNTIF($C$9:$C17,$C17)-1,0)-VLOOKUP($C17,Calcs,col_R+COUNTIF($C$9:$C17,$C17)-2,0))))","v":""}]
[9,false,9,null,null,0,"A0070","15705-0100",{"$f":"IF(OR($A18>End,COUNTIF($C$9:$C18,$C18)>lines_D),\"\",IF(COUNTIF($C$9:$C18,$C18)=1,LEFT(VLOOKUP($C18,Calcs,col_Description,0),VLOOKUP($C18,Calcs,col_D,0)),MID(VLOOKUP($C18,Calcs,col_Description,0),VLOOKUP($C18,Calcs,col_D+COUNTIF($C$9:$C18,$C18)-2,0)+1,VLOOKUP($C18,Calcs,col_D+COUNTIF($C$9:$C18,$C18)-1,0)-VLOOKUP($C18,Calcs,col_D+COUNTIF($C$9:$C18,$C18)-2,0))))","v":"Soil erosion control, silt fence"},"m","","","","","","1,630","","","","","","","","1,630",{"$f":"IF(OR($A18>End,COUNTIF($C$9:$C18,$C18)>lines_R),\"\",IF(COUNTIF($C$9:$C18,$C18)=1,LEFT(VLOOKUP($C18,Calcs,col_Remarks,0),VLOOKUP($C18,Calcs,col_R,0)),MID(VLOOKUP($C18,Calcs,col_Remarks,0),VLOOKUP($C18,Calcs,col_R+COUNTIF($C$9:$C18,$C18)-2,0)+1,VLOOKUP($C18,Calcs,col_R+COUNTIF($C$9:$C18,$C18)-1,0)-VLOOKUP($C18,Calcs,col_R+COUNTIF($C$9:$C18,$C18)-2,0))))","v":""}]
[10,false,11,null,null,0,"A0080","15705-0600",{"$f":"IF(OR($A19>End,COUNTIF($C$9:$C19,$C19)>lines_D),\"\",IF(COUNTIF($C$9:$C19,$C19)=1,LEFT(VLOOKUP($C19,Calcs,col_Description,0),VLOOKUP($C19,Calcs,col_D,0)),MID(VLOOKUP($C19,Calcs,col_Description,0),VLOOKUP($C19,Calcs,col_D+COUNTIF($C$9:$C19,$C19)-2,0)+1,VLOOKUP($C19,Calcs,col_D+COUNTIF($C$9:$C19,$C19)-1,0)-VLOOKUP($C19,Calcs,col_D+COUNTIF($C$9:$C19,$C19)-2,0))))","v":"Soil erosion control, temporary "},"","","","","","","","","","","","","","","",{"$f":"IF(OR($A19>End,COUNTIF($C$9:$C19,$C19)>lines_R),\"\",IF(COUNTIF($C$9:$C19,$C19)=1,LEFT(VLOOKUP($C19,Calcs,col_Remarks,0),VLOOKUP($C19,Calcs,col_R,0)),MID(VLOOKUP($C19,Calcs,col_Remarks,0),VLOOKUP($C19,Calcs,col_R+COUNTIF($C$9:$C19,$C19)-2,0)+1,VLOOKUP($C19,Calcs,col_R+COUNTIF($C$9:$C19,$C19)-1,0)-VLOOKUP($C19,Calcs,col_R+COUNTIF($C$9:$C19,$C19)-2,0))))","v":""}]
[11,false,11,null,null,"","","",{"$f":"IF(OR($A20>End,COUNTIF($C$9:$C20,$C20)>lines_D),\"\",IF(COUNTIF($C$9:$C20,$C20)=1,LEFT(VLOOKUP($C20,Calcs,col_Description,0),VLOOKUP($C20,Calcs,col_D,0)),MID(VLOOKUP($C20,Calcs,col_Description,0),VLOOKUP($C20,Calcs,col_D+COUNTIF($C$9:$C20,$C20)-2,0)+1,VLOOKUP($C20,Calcs,col_D+COUNTIF($C$9:$C20,$C20)-1,0)-VLOOKUP($C20,Calcs,col_D+COUNTIF($C$9:$C20,$C20)-2,0))))","v":"600mm culvert pipe"},"m",{"$f":"IF(OR($C20=OFFSET($C20,1,0),$A20>End),\"\",SUBSTITUTE(SUBSTITUTE(OFFSET(EEBACS,MATCH($C20,OFFSET(Calcs,0,0,ROWS(Calcs),1),0),K$2,1,1),\"All|\",\"\",1),\"||\",\"\"))","v":""},"","","","","16","","","","","4","","","20",{"$f":"IF(OR($A20>End,COUNTIF($C$9:$C20,$C20)>lines_R),\"\",IF(COUNTIF($C$9:$C20,$C20)=1,LEFT(VLOOKUP($C20,Calcs,col_Remarks,0),VLOOKUP($C20,Calcs,col_R,0)),MID(VLOOKUP($C20,Calcs,col_Remarks,0),VLOOKUP($C20,Calcs,col_R+COUNTIF($C$9:$C20,$C20)-2,0)+1,VLOOKUP($C20,Calcs,col_R+COUNTIF($C$9:$C20,$C20)-1,0)-VLOOKUP($C20,Calcs,col_R+COUNTIF($C$9:$C20,$C20)-2,0))))","v":""}]
[12,false,13,null,null,0,"A0090","15705-1300",{"$f":"IF(OR($A21>End,COUNTIF($C$9:$C21,$C21)>lines_D),\"\",IF(COUNTIF($C$9:$C21,$C21)=1,LEFT(VLOOKUP($C21,Calcs,col_Description,0),VLOOKUP($C21,Calcs,col_D,0)),MID(VLOOKUP($C21,Calcs,col_Description,0),VLOOKUP($C21,Calcs,col_D+COUNTIF($C$9:$C21,$C21)-2,0)+1,VLOOKUP($C21,Calcs,col_D+COUNTIF($C$9:$C21,$C21)-1,0)-VLOOKUP($C21,Calcs,col_D+COUNTIF($C$9:$C21,$C21)-2,0))))","v":"Soil erosion control, temporary "},"","","","","","","","","","","","","","","",{"$f":"IF(OR($A21>End,COUNTIF($C$9:$C21,$C21)>lines_R),\"\",IF(COUNTIF($C$9:$C21,$C21)=1,LEFT(VLOOKUP($C21,Calcs,col_Remarks,0),VLOOKUP($C21,Calcs,col_R,0)),MID(VLOOKUP($C21,Calcs,col_Remarks,0),VLOOKUP($C21,Calcs,col_R+COUNTIF($C$9:$C21,$C21)-2,0)+1,VLOOKUP($C21,Calcs,col_R+COUNTIF($C$9:$C21,$C21)-1,0)-VLOOKUP($C21,Calcs,col_R+COUNTIF($C$9:$C21,$C21)-2,0))))","v":""}]
[13,false,13,null,null,"","","",{"$f":"IF(OR($A22>End,COUNTIF($C$9:$C22,$C22)>lines_D),\"\",IF(COUNTIF($C$9:$C22,$C22)=1,LEFT(VLOOKUP($C22,Calcs,col_Description,0),VLOOKUP($C22,Calcs,col_D,0)),MID(VLOOKUP($C22,Calcs,col_Description,0),VLOOKUP($C22,Calcs,col_D+COUNTIF($C$9:$C22,$C22)-2,0)+1,VLOOKUP($C22,Calcs,col_D+COUNTIF($C$9:$C22,$C22)-1,0)-VLOOKUP($C22,Calcs,col_D+COUNTIF($C$9:$C22,$C22)-2,0))))","v":"diversion channel"},"m","","","","","","33","","","","","2","","","35",{"$f":"IF(OR($A22>End,COUNTIF($C$9:$C22,$C22)>lines_R),\"\",IF(COUNTIF($C$9:$C22,$C22)=1,LEFT(VLOOKUP($C22,Calcs,col_Remarks,0),VLOOKUP($C22,Calcs,col_R,0)),MID(VLOOKUP($C22,Calcs,col_Remarks,0),VLOOKUP($C22,Calcs,col_R+COUNTIF($C$9:$C22,$C22)-2,0)+1,VLOOKUP($C22,Calcs,col_R+COUNTIF($C$9:$C22,$C22)-1,0)-VLOOKUP($C22,Calcs,col_R+COUNTIF($C$9:$C22,$C22)-2,0))))","v":""}]
[14,false,14,null,null,0,"A0100","15705-1400",{"$f":"IF(OR($A23>End,COUNTIF($C$9:$C23,$C23)>lines_D),\"\",IF(COUNTIF($C$9:$C23,$C23)=1,LEFT(VLOOKUP($C23,Calcs,col_Description,0),VLOOKUP($C23,Calcs,col_D,0)),MID(VLOOKUP($C23,Calcs,col_Description,0),VLOOKUP($C23,Calcs,col_D+COUNTIF($C$9:$C23,$C23)-2,0)+1,VLOOKUP($C23,Calcs,col_D+COUNTIF($C$9:$C23,$C23)-1,0)-VLOOKUP($C23,Calcs,col_D+COUNTIF($C$9:$C23,$C23)-2,0))))","v":"Soil erosion control, sediment log"},"m","","","","","","36","","","","","4","","","40",{"$f":"IF(OR($A23>End,COUNTIF($C$9:$C23,$C23)>lines_R),\"\",IF(COUNTIF($C$9:$C23,$C23)=1,LEFT(VLOOKUP($C23,Calcs,col_Remarks,0),VLOOKUP($C23,Calcs,col_R,0)),MID(VLOOKUP($C23,Calcs,col_Remarks,0),VLOOKUP($C23,Calcs,col_R+COUNTIF($C$9:$C23,$C23)-2,0)+1,VLOOKUP($C23,Calcs,col_R+COUNTIF($C$9:$C23,$C23)-1,0)-VLOOKUP($C23,Calcs,col_R+COUNTIF($C$9:$C23,$C23)-2,0))))","v":""}]
[15,false,15,null,null,0,"A0110","15706-0300",{"$f":"IF(OR($A24>End,COUNTIF($C$9:$C24,$C24)>lines_D),\"\",IF(COUNTIF($C$9:$C24,$C24)=1,LEFT(VLOOKUP($C24,Calcs,col_Description,0),VLOOKUP($C24,Calcs,col_D,0)),MID(VLOOKUP($C24,Calcs,col_Description,0),VLOOKUP($C24,Calcs,col_D+COUNTIF($C$9:$C24,$C24)-2,0)+1,VLOOKUP($C24,Calcs,col_D+COUNTIF($C$9:$C24,$C24)-1,0)-VLOOKUP($C24,Calcs,col_D+COUNTIF($C$9:$C24,$C24)-2,0))))","v":"Soil erosion control, sandbag"},"Each","","","","","","200","","","","","10","","","210",{"$f":"IF(OR($A24>End,COUNTIF($C$9:$C24,$C24)>lines_R),\"\",IF(COUNTIF($C$9:$C24,$C24)=1,LEFT(VLOOKUP($C24,Calcs,col_Remarks,0),VLOOKUP($C24,Calcs,col_R,0)),MID(VLOOKUP($C24,Calcs,col_Remarks,0),VLOOKUP($C24,Calcs,col_R+COUNTIF($C$9:$C24,$C24)-2,0)+1,VLOOKUP($C24,Calcs,col_R+COUNTIF($C$9:$C24,$C24)-1,0)-VLOOKUP($C24,Calcs,col_R+COUNTIF($C$9:$C24,$C24)-2,0))))","v":""}]
[16,false,16,null,null,0,"A0120","20101-0000",{"$f":"IF(OR($A25>End,COUNTIF($C$9:$C25,$C25)>lines_D),\"\",IF(COUNTIF($C$9:$C25,$C25)=1,LEFT(VLOOKUP($C25,Calcs,col_Description,0),VLOOKUP($C25,Calcs,col_D,0)),MID(VLOOKUP($C25,Calcs,col_Description,0),VLOOKUP($C25,Calcs,col_D+COUNTIF($C$9:$C25,$C25)-2,0)+1,VLOOKUP($C25,Calcs,col_D+COUNTIF($C$9:$C25,$C25)-1,0)-VLOOKUP($C25,Calcs,col_D+COUNTIF($C$9:$C25,$C25)-2,0))))","v":"Clearing and grubbing"},"ha","","0.11","0.45","","","","","","","","0.02","","","0.58",{"$f":"IF(OR($A25>End,COUNTIF($C$9:$C25,$C25)>lines_R),\"\",IF(COUNTIF($C$9:$C25,$C25)=1,LEFT(VLOOKUP($C25,Calcs,col_Remarks,0),VLOOKUP($C25,Calcs,col_R,0)),MID(VLOOKUP($C25,Calcs,col_Remarks,0),VLOOKUP($C25,Calcs,col_R+COUNTIF($C$9:$C25,$C25)-2,0)+1,VLOOKUP($C25,Calcs,col_R+COUNTIF($C$9:$C25,$C25)-1,0)-VLOOKUP($C25,Calcs,col_R+COUNTIF($C$9:$C25,$C25)-2,0))))","v":""}]
[17,false,17,null,null,0,"A0130","20103-0000",{"$f":"IF(OR($A26>End,COUNTIF($C$9:$C26,$C26)>lines_D),\"\",IF(COUNTIF($C$9:$C26,$C26)=1,LEFT(VLOOKUP($C26,Calcs,col_Description,0),VLOOKUP($C26,Calcs,col_D,0)),MID(VLOOKUP($C26,Calcs,col_Description,0),VLOOKUP($C26,Calcs,col_D+COUNTIF($C$9:$C26,$C26)-2,0)+1,VLOOKUP($C26,Calcs,col_D+COUNTIF($C$9:$C26,$C26)-1,0)-VLOOKUP($C26,Calcs,col_D+COUNTIF($C$9:$C26,$C26)-2,0))))","v":"Clearing and grubbing"},"m2","","","","","675","","","","","","25","","","700",{"$f":"IF(OR($A26>End,COUNTIF($C$9:$C26,$C26)>lines_R),\"\",IF(COUNTIF($C$9:$C26,$C26)=1,LEFT(VLOOKUP($C26,Calcs,col_Remarks,0),VLOOKUP($C26,Calcs,col_R,0)),MID(VLOOKUP($C26,Calcs,col_Remarks,0),VLOOKUP($C26,Calcs,col_R+COUNTIF($C$9:$C26,$C26)-2,0)+1,VLOOKUP($C26,Calcs,col_R+COUNTIF($C$9:$C26,$C26)-1,0)-VLOOKUP($C26,Calcs,col_R+COUNTIF($C$9:$C26,$C26)-2,0))))","v":""}]
[18,false,18,null,null,0,"A0140","20212-0000",{"$f":"IF(OR($A27>End,COUNTIF($C$9:$C27,$C27)>lines_D),\"\",IF(COUNTIF($C$9:$C27,$C27)=1,LEFT(VLOOKUP($C27,Calcs,col_Description,0),VLOOKUP($C27,Calcs,col_D,0)),MID(VLOOKUP($C27,Calcs,col_Description,0),VLOOKUP($C27,Calcs,col_D+COUNTIF($C$9:$C27,$C27)-2,0)+1,VLOOKUP($C27,Calcs,col_D+COUNTIF($C$9:$C27,$C27)-1,0)-VLOOKUP($C27,Calcs,col_D+COUNTIF($C$9:$C27,$C27)-2,0))))","v":"Special clearing"},"m2","","1,672","","","","","","","","","78","","","1,750",{"$f":"IF(OR($A27>End,COUNTIF($C$9:$C27,$C27)>lines_R),\"\",IF(COUNTIF($C$9:$C27,$C27)=1,LEFT(VLOOKUP($C27,Calcs,col_Remarks,0),VLOOKUP($C27,Calcs,col_R,0)),MID(VLOOKUP($C27,Calcs,col_Remarks,0),VLOOKUP($C27,Calcs,col_R+COUNTIF($C$9:$C27,$C27)-2,0)+1,VLOOKUP($C27,Calcs,col_R+COUNTIF($C$9:$C27,$C27)-1,0)-VLOOKUP($C27,Calcs,col_R+COUNTIF($C$9:$C27,$C27)-2,0))))","v":""}]
[19,false,19,null,null,0,"A0150","20301-0080",{"$f":"IF(OR($A28>End,COUNTIF($C$9:$C28,$C28)>lines_D),\"\",IF(COUNTIF($C$9:$C28,$C28)=1,LEFT(VLOOKUP($C28,Calcs,col_Description,0),VLOOKUP($C28,Calcs,col_D,0)),MID(VLOOKUP($C28,Calcs,col_Description,0),VLOOKUP($C28,Calcs,col_D+COUNTIF($C$9:$C28,$C28)-2,0)+1,VLOOKUP($C28,Calcs,col_D+COUNTIF($C$9:$C28,$C28)-1,0)-VLOOKUP($C28,Calcs,col_D+COUNTIF($C$9:$C28,$C28)-2,0))))","v":"Removal of bench"},"Each","","","6","","","","","","","","","","","6",{"$f":"IF(OR($A28>End,COUNTIF($C$9:$C28,$C28)>lines_R),\"\",IF(COUNTIF($C$9:$C28,$C28)=1,LEFT(VLOOKUP($C28,Calcs,col_Remarks,0),VLOOKUP($C28,Calcs,col_R,0)),MID(VLOOKUP($C28,Calcs,col_Remarks,0),VLOOKUP($C28,Calcs,col_R+COUNTIF($C$9:$C28,$C28)-2,0)+1,VLOOKUP($C28,Calcs,col_R+COUNTIF($C$9:$C28,$C28)-1,0)-VLOOKUP($C28,Calcs,col_R+COUNTIF($C$9:$C28,$C28)-2,0))))","v":""}]
[20,false,20,null,null,0,"A0160","20301-0500",{"$f":"IF(OR($A29>End,COUNTIF($C$9:$C29,$C29)>lines_D),\"\",IF(COUNTIF($C$9:$C29,$C29)=1,LEFT(VLOOKUP($C29,Calcs,col_Description,0),VLOOKUP($C29,Calcs,col_D,0)),MID(VLOOKUP($C29,Calcs,col_Description,0),VLOOKUP($C29,Calcs,col_D+COUNTIF($C$9:$C29,$C29)-2,0)+1,VLOOKUP($C29,Calcs,col_D+COUNTIF($C$9:$C29,$C29)-1,0)-VLOOKUP($C29,Calcs,col_D+COUNTIF($C$9:$C29,$C29)-2,0))))","v":"Removal of catch basin"},"Each","","","","2","","","","","","","","","","2",{"$f":"IF(OR($A29>End,COUNTIF($C$9:$C29,$C29)>lines_R),\"\",IF(COUNTIF($C$9:$C29,$C29)=1,LEFT(VLOOKUP($C29,Calcs,col_Remarks,0),VLOOKUP($C29,Calcs,col_R,0)),MID(VLOOKUP($C29,Calcs,col_Remarks,0),VLOOKUP($C29,Calcs,col_R+COUNTIF($C$9:$C29,$C29)-2,0)+1,VLOOKUP($C29,Calcs,col_R+COUNTIF($C$9:$C29,$C29)-1,0)-VLOOKUP($C29,Calcs,col_R+COUNTIF($C$9:$C29,$C29)-2,0))))","v":""}]
[21,false,21,null,null,{"$f":"IF(OR($C30=OFFSET($C30,-1,0),$A30>End),\"\",OFFSET(EEBACS,MATCH($C30,OFFSET(Calcs,0,0,ROWS(Calcs),1),0),F$2,1,1))","v":0},"A0170","20301-1200",{"$f":"IF(OR($A30>End,COUNTIF($C$9:$C30,$C30)>lines_D),\"\",IF(COUNTIF($C$9:$C30,$C30)=1,LEFT(VLOOKUP($C30,Calcs,col_Description,0),VLOOKUP($C30,Calcs,col_D,0)),MID(VLOOKUP($C30,Calcs,col_Description,0),VLOOKUP($C30,Calcs,col_D+COUNTIF($C$9:$C30,$C30)-2,0)+1,VLOOKUP($C30,Calcs,col_D+COUNTIF($C$9:$C30,$C30)-1,0)-VLOOKUP($C30,Calcs,col_D+COUNTIF($C$9:$C30,$C30)-2,0))))","v":"Removal of headwall"},"Each",{"$f":"IF(OR($C30=OFFSET($C30,1,0),$A30>End),\"\",SUBSTITUTE(SUBSTITUTE(OFFSET(EEBACS,MATCH($C30,OFFSET(Calcs,0,0,ROWS(Calcs),1),0),K$2,1,1),\"All|\",\"\",1),\"||\",\"\"))","v":""},"","","1","","","","","","","","","","1",{"$f":"IF(OR($A30>End,COUNTIF($C$9:$C30,$C30)>lines_R),\"\",IF(COUNTIF($C$9:$C30,$C30)=1,LEFT(VLOOKUP($C30,Calcs,col_Remarks,0),VLOOKUP($C30,Calcs,col_R,0)),MID(VLOOKUP($C30,Calcs,col_Remarks,0),VLOOKUP($C30,Calcs,col_R+COUNTIF($C$9:$C30,$C30)-2,0)+1,VLOOKUP($C30,Calcs,col_R+COUNTIF($C$9:$C30,$C30)-1,0)-VLOOKUP($C30,Calcs,col_R+COUNTIF($C$9:$C30,$C30)-2,0))))","v":""}]
[22,false,22,null,null,0,"A0180","20301-1400",{"$f":"IF(OR($A31>End,COUNTIF($C$9:$C31,$C31)>lines_D),\"\",IF(COUNTIF($C$9:$C31,$C31)=1,LEFT(VLOOKUP($C31,Calcs,col_Description,0),VLOOKUP($C31,Calcs,col_D,0)),MID(VLOOKUP($C31,Calcs,col_Description,0),VLOOKUP($C31,Calcs,col_D+COUNTIF($C$9:$C31,$C31)-2,0)+1,VLOOKUP($C31,Calcs,col_D+COUNTIF($C$9:$C31,$C31)-1,0)-VLOOKUP($C31,Calcs,col_D+COUNTIF($C$9:$C31,$C31)-2,0))))","v":"Removal of inlet"},"Each","","","","7","","","","","","","","","","7",{"$f":"IF(OR($A31>End,COUNTIF($C$9:$C31,$C31)>lines_R),\"\",IF(COUNTIF($C$9:$C31,$C31)=1,LEFT(VLOOKUP($C31,Calcs,col_Remarks,0),VLOOKUP($C31,Calcs,col_R,0)),MID(VLOOKUP($C31,Calcs,col_Remarks,0),VLOOKUP($C31,Calcs,col_R+COUNTIF($C$9:$C31,$C31)-2,0)+1,VLOOKUP($C31,Calcs,col_R+COUNTIF($C$9:$C31,$C31)-1,0)-VLOOKUP($C31,Calcs,col_R+COUNTIF($C$9:$C31,$C31)-2,0))))","v":""}]
[23,false,23,null,null,0,"A0190","20301-2400",{"$f":"IF(OR($A32>End,COUNTIF($C$9:$C32,$C32)>lines_D),\"\",IF(COUNTIF($C$9:$C32,$C32)=1,LEFT(VLOOKUP($C32,Calcs,col_Description,0),VLOOKUP($C32,Calcs,col_D,0)),MID(VLOOKUP($C32,Calcs,col_Description,0),VLOOKUP($C32,Calcs,col_D+COUNTIF($C$9:$C32,$C32)-2,0)+1,VLOOKUP($C32,Calcs,col_D+COUNTIF($C$9:$C32,$C32)-1,0)-VLOOKUP($C32,Calcs,col_D+COUNTIF($C$9:$C32,$C32)-2,0))))","v":"Removal of signs"},"Each","","","","","","","33","","","","1","","","34",{"$f":"IF(OR($A32>End,COUNTIF($C$9:$C32,$C32)>lines_R),\"\",IF(COUNTIF($C$9:$C32,$C32)=1,LEFT(VLOOKUP($C32,Calcs,col_Remarks,0),VLOOKUP($C32,Calcs,col_R,0)),MID(VLOOKUP($C32,Calcs,col_Remarks,0),VLOOKUP($C32,Calcs,col_R+COUNTIF($C$9:$C32,$C32)-2,0)+1,VLOOKUP($C32,Calcs,col_R+COUNTIF($C$9:$C32,$C32)-1,0)-VLOOKUP($C32,Calcs,col_R+COUNTIF($C$9:$C32,$C32)-2,0))))","v":""}]
[24,false,25,null,null,0,"A0200","20301-2700",{"$f":"IF(OR($A33>End,COUNTIF($C$9:$C33,$C33)>lines_D),\"\",IF(COUNTIF($C$9:$C33,$C33)=1,LEFT(VLOOKUP($C33,Calcs,col_Description,0),VLOOKUP($C33,Calcs,col_D,0)),MID(VLOOKUP($C33,Calcs,col_Description,0),VLOOKUP($C33,Calcs,col_D+COUNTIF($C$9:$C33,$C33)-2,0)+1,VLOOKUP($C33,Calcs,col_D+COUNTIF($C$9:$C33,$C33)-1,0)-VLOOKUP($C33,Calcs,col_D+COUNTIF($C$9:$C33,$C33)-2,0))))","v":"Removal of structure, timber "},"","","","","","","","","","","","","","","",{"$f":"IF(OR($A33>End,COUNTIF($C$9:$C33,$C33)>lines_R),\"\",IF(COUNTIF($C$9:$C33,$C33)=1,LEFT(VLOOKUP($C33,Calcs,col_Remarks,0),VLOOKUP($C33,Calcs,col_R,0)),MID(VLOOKUP($C33,Calcs,col_Remarks,0),VLOOKUP($C33,Calcs,col_R+COUNTIF($C$9:$C33,$C33)-2,0)+1,VLOOKUP($C33,Calcs,col_R+COUNTIF($C$9:$C33,$C33)-1,0)-VLOOKUP($C33,Calcs,col_R+COUNTIF($C$9:$C33,$C33)-2,0))))","v":""}]
[25,false,25,null,null,"","","",{"$f":"IF(OR($A34>End,COUNTIF($C$9:$C34,$C34)>lines_D),\"\",IF(COUNTIF($C$9:$C34,$C34)=1,LEFT(VLOOKUP($C34,Calcs,col_Description,0),VLOOKUP($C34,Calcs,col_D,0)),MID(VLOOKUP($C34,Calcs,col_Description,0),VLOOKUP($C34,Calcs,col_D+COUNTIF($C$9:$C34,$C34)-2,0)+1,VLOOKUP($C34,Calcs,col_D+COUNTIF($C$9:$C34,$C34)-1,0)-VLOOKUP($C34,Calcs,col_D+COUNTIF($C$9:$C34,$C34)-2,0))))","v":"sidewalk"},"Each","","","1","","","","","","","","","","","1",{"$f":"IF(OR($A34>End,COUNTIF($C$9:$C34,$C34)>lines_R),\"\",IF(COUNTIF($C$9:$C34,$C34)=1,LEFT(VLOOKUP($C34,Calcs,col_Remarks,0),VLOOKUP($C34,Calcs,col_R,0)),MID(VLOOKUP($C34,Calcs,col_Remarks,0),VLOOKUP($C34,Calcs,col_R+COUNTIF($C$9:$C34,$C34)-2,0)+1,VLOOKUP($C34,Calcs,col_R+COUNTIF($C$9:$C34,$C34)-1,0)-VLOOKUP($C34,Calcs,col_R+COUNTIF($C$9:$C34,$C34)-2,0))))","v":""}]
[26,false,27,null,null,0,"A0210","20301-2700",{"$f":"IF(OR($A35>End,COUNTIF($C$9:$C35,$C35)>lines_D),\"\",IF(COUNTIF($C$9:$C35,$C35)=1,LEFT(VLOOKUP($C35,Calcs,col_Description,0),VLOOKUP($C35,Calcs,col_D,0)),MID(VLOOKUP($C35,Calcs,col_Description,0),VLOOKUP($C35,Calcs,col_D+COUNTIF($C$9:$C35,$C35)-2,0)+1,VLOOKUP($C35,Calcs,col_D+COUNTIF($C$9:$C35,$C35)-1,0)-VLOOKUP($C35,Calcs,col_D+COUNTIF($C$9:$C35,$C35)-2,0))))","v":"Removal of structure, information "},"","","","","","","","","","","","","","","",{"$f":"IF(OR($A35>End,COUNTIF($C$9:$C35,$C35)>lines_R),\"\",IF(COUNTIF($C$9:$C35,$C35)=1,LEFT(VLOOKUP($C35,Calcs,col_Remarks,0),VLOOKUP($C35,Calcs,col_R,0)),MID(VLOOKUP($C35,Calcs,col_Remarks,0),VLOOKUP($C35,Calcs,col_R+COUNTIF($C$9:$C35,$C35)-2,0)+1,VLOOKUP($C35,Calcs,col_R+COUNTIF($C$9:$C35,$C35)-1,0)-VLOOKUP($C35,Calcs,col_R+COUNTIF($C$9:$C35,$C35)-2,0))))","v":""}]
[27,false,27,null,null,"","","",{"$f":"IF(OR($A36>End,COUNTIF($C$9:$C36,$C36)>lines_D),\"\",IF(COUNTIF($C$9:$C36,$C36)=1,LEFT(VLOOKUP($C36,Calcs,col_Description,0),VLOOKUP($C36,Calcs,col_D,0)),MID(VLOOKUP($C36,Calcs,col_Description,0),VLOOKUP($C36,Calcs,col_D+COUNTIF($C$9:$C36,$C36)-2,0)+1,VLOOKUP($C36,Calcs,col_D+COUNTIF($C$9:$C36,$C36)-1,0)-VLOOKUP($C36,Calcs,col_D+COUNTIF($C$9:$C36,$C36)-2,0))))","v":"box"},"Each","","","","","","","3","","","","","","","3",{"$f":"IF(OR($A36>End,COUNTIF($C$9:$C36,$C36)>lines_R),\"\",IF(COUNTIF($C$9:$C36,$C36)=1,LEFT(VLOOKUP($C36,Calcs,col_Remarks,0),VLOOKUP($C36,Calcs,col_R,0)),MID(VLOOKUP($C36,Calcs,col_Remarks,0),VLOOKUP($C36,Calcs,col_R+COUNTIF($C$9:$C36,$C36)-2,0)+1,VLOOKUP($C36,Calcs,col_R+COUNTIF($C$9:$C36,$C36)-1,0)-VLOOKUP($C36,Calcs,col_R+COUNTIF($C$9:$C36,$C36)-2,0))))","v":""}]
[28,false,28,null,null,0,"A0220","20301-3000",{"$f":"IF(OR($A37>End,COUNTIF($C$9:$C37,$C37)>lines_D),\"\",IF(COUNTIF($C$9:$C37,$C37)=1,LEFT(VLOOKUP($C37,Calcs,col_Description,0),VLOOKUP($C37,Calcs,col_D,0)),MID(VLOOKUP($C37,Calcs,col_Description,0),VLOOKUP($C37,Calcs,col_D+COUNTIF($C$9:$C37,$C37)-2,0)+1,VLOOKUP($C37,Calcs,col_D+COUNTIF($C$9:$C37,$C37)-1,0)-VLOOKUP($C37,Calcs,col_D+COUNTIF($C$9:$C37,$C37)-2,0))))","v":"Removal of trash receptacle"},"Each","","","7","","","","","","","","","","","7",{"$f":"IF(OR($A37>End,COUNTIF($C$9:$C37,$C37)>lines_R),\"\",IF(COUNTIF($C$9:$C37,$C37)=1,LEFT(VLOOKUP($C37,Calcs,col_Remarks,0),VLOOKUP($C37,Calcs,col_R,0)),MID(VLOOKUP($C37,Calcs,col_Remarks,0),VLOOKUP($C37,Calcs,col_R+COUNTIF($C$9:$C37,$C37)-2,0)+1,VLOOKUP($C37,Calcs,col_R+COUNTIF($C$9:$C37,$C37)-1,0)-VLOOKUP($C37,Calcs,col_R+COUNTIF($C$9:$C37,$C37)-2,0))))","v":""}]
[29,false,30,null,null,0,"A0230","20302-0300",{"$f":"IF(OR($A38>End,COUNTIF($C$9:$C38,$C38)>lines_D),\"\",IF(COUNTIF($C$9:$C38,$C38)=1,LEFT(VLOOKUP($C38,Calcs,col_Description,0),VLOOKUP($C38,Calcs,col_D,0)),MID(VLOOKUP($C38,Calcs,col_Description,0),VLOOKUP($C38,Calcs,col_D+COUNTIF($C$9:$C38,$C38)-2,0)+1,VLOOKUP($C38,Calcs,col_D+COUNTIF($C$9:$C38,$C38)-1,0)-VLOOKUP($C38,Calcs,col_D+COUNTIF($C$9:$C38,$C38)-2,0))))","v":"Removal of curb and gutter, "},"","","","","","","","","","","","","","","",{"$f":"IF(OR($A38>End,COUNTIF($C$9:$C38,$C38)>lines_R),\"\",IF(COUNTIF($C$9:$C38,$C38)=1,LEFT(VLOOKUP($C38,Calcs,col_Remarks,0),VLOOKUP($C38,Calcs,col_R,0)),MID(VLOOKUP($C38,Calcs,col_Remarks,0),VLOOKUP($C38,Calcs,col_R+COUNTIF($C$9:$C38,$C38)-2,0)+1,VLOOKUP($C38,Calcs,col_R+COUNTIF($C$9:$C38,$C38)-1,0)-VLOOKUP($C38,Calcs,col_R+COUNTIF($C$9:$C38,$C38)-2,0))))","v":""}]
[30,false,30,null,null,"","","",{"$f":"IF(OR($A39>End,COUNTIF($C$9:$C39,$C39)>lines_D),\"\",IF(COUNTIF($C$9:$C39,$C39)=1,LEFT(VLOOKUP($C39,Calcs,col_Description,0),VLOOKUP($C39,Calcs,col_D,0)),MID(VLOOKUP($C39,Calcs,col_Description,0),VLOOKUP($C39,Calcs,col_D+COUNTIF($C$9:$C39,$C39)-2,0)+1,VLOOKUP($C39,Calcs,col_D+COUNTIF($C$9:$C39,$C39)-1,0)-VLOOKUP($C39,Calcs,col_D+COUNTIF($C$9:$C39,$C39)-2,0))))","v":"concrete"},"m","","","756","","","","","","","","44","","","800",{"$f":"IF(OR($A39>End,COUNTIF($C$9:$C39,$C39)>lines_R),\"\",IF(COUNTIF($C$9:$C39,$C39)=1,LEFT(VLOOKUP($C39,Calcs,col_Remarks,0),VLOOKUP($C39,Calcs,col_R,0)),MID(VLOOKUP($C39,Calcs,col_Remarks,0),VLOOKUP($C39,Calcs,col_R+COUNTIF($C$9:$C39,$C39)-2,0)+1,VLOOKUP($C39,Calcs,col_R+COUNTIF($C$9:$C39,$C39)-1,0)-VLOOKUP($C39,Calcs,col_R+COUNTIF($C$9:$C39,$C39)-2,0))))","v":""}]
[31,false,31,null,null,0,"A0240","20302-0400",{"$f":"IF(OR($A40>End,COUNTIF($C$9:$C40,$C40)>lines_D),\"\",IF(COUNTIF($C$9:$C40,$C40)=1,LEFT(VLOOKUP($C40,Calcs,col_Description,0),VLOOKUP($C40,Calcs,col_D,0)),MID(VLOOKUP($C40,Calcs,col_Description,0),VLOOKUP($C40,Calcs,col_D+COUNTIF($C$9:$C40,$C40)-2,0)+1,VLOOKUP($C40,Calcs,col_D+COUNTIF($C$9:$C40,$C40)-1,0)-VLOOKUP($C40,Calcs,col_D+COUNTIF($C$9:$C40,$C40)-2,0))))","v":"Removal of curb, asphalt"},"m",{"$f":"IF(OR($C40=OFFSET($C40,1,0),$A40>End),\"\",SUBSTITUTE(SUBSTITUTE(OFFSET(EEBACS,MATCH($C40,OFFSET(Calcs,0,0,ROWS(Calcs),1),0),K$2,1,1),\"All|\",\"\",1),\"||\",\"\"))","v":""},"104","727","","","","","","","","34","","","865",{"$f":"IF(OR($A40>End,COUNTIF($C$9:$C40,$C40)>lines_R),\"\",IF(COUNTIF($C$9:$C40,$C40)=1,LEFT(VLOOKUP($C40,Calcs,col_Remarks,0),VLOOKUP($C40,Calcs,col_R,0)),MID(VLOOKUP($C40,Calcs,col_Remarks,0),VLOOKUP($C40,Calcs,col_R+COUNTIF($C$9:$C40,$C40)-2,0)+1,VLOOKUP($C40,Calcs,col_R+COUNTIF($C$9:$C40,$C40)-1,0)-VLOOKUP($C40,Calcs,col_R+COUNTIF($C$9:$C40,$C40)-2,0))))","v":""}]
[32,false,32,null,null,0,"A0250","20302-0500",{"$f":"IF(OR($A41>End,COUNTIF($C$9:$C41,$C41)>lines_D),\"\",IF(COUNTIF($C$9:$C41,$C41)=1,LEFT(VLOOKUP($C41,Calcs,col_Description,0),VLOOKUP($C41,Calcs,col_D,0)),MID(VLOOKUP($C41,Calcs,col_Description,0),VLOOKUP($C41,Calcs,col_D+COUNTIF($C$9:$C41,$C41)-2,0)+1,VLOOKUP($C41,Calcs,col_D+COUNTIF($C$9:$C41,$C41)-1,0)-VLOOKUP($C41,Calcs,col_D+COUNTIF($C$9:$C41,$C41)-2,0))))","v":"Removal of curb, concrete"},"m","","","161","","","","","","","","9","","","170",{"$f":"IF(OR($A41>End,COUNTIF($C$9:$C41,$C41)>lines_R),\"\",IF(COUNTIF($C$9:$C41,$C41)=1,LEFT(VLOOKUP($C41,Calcs,col_Remarks,0),VLOOKUP($C41,Calcs,col_R,0)),MID(VLOOKUP($C41,Calcs,col_Remarks,0),VLOOKUP($C41,Calcs,col_R+COUNTIF($C$9:$C41,$C41)-2,0)+1,VLOOKUP($C41,Calcs,col_R+COUNTIF($C$9:$C41,$C41)-1,0)-VLOOKUP($C41,Calcs,col_R+COUNTIF($C$9:$C41,$C41)-2,0))))","v":""}]
[33,false,33,null,null,0,"A0260","20302-0625",{"$f":"IF(OR($A42>End,COUNTIF($C$9:$C42,$C42)>lines_D),\"\",IF(COUNTIF($C$9:$C42,$C42)=1,LEFT(VLOOKUP($C42,Calcs,col_Description,0),VLOOKUP($C42,Calcs,col_D,0)),MID(VLOOKUP($C42,Calcs,col_Description,0),VLOOKUP($C42,Calcs,col_D+COUNTIF($C$9:$C42,$C42)-2,0)+1,VLOOKUP($C42,Calcs,col_D+COUNTIF($C$9:$C42,$C42)-1,0)-VLOOKUP($C42,Calcs,col_D+COUNTIF($C$9:$C42,$C42)-2,0))))","v":"Removal of curb, log"},"m","","","38","","","","","","","","2","","","40",{"$f":"IF(OR($A42>End,COUNTIF($C$9:$C42,$C42)>lines_R),\"\",IF(COUNTIF($C$9:$C42,$C42)=1,LEFT(VLOOKUP($C42,Calcs,col_Remarks,0),VLOOKUP($C42,Calcs,col_R,0)),MID(VLOOKUP($C42,Calcs,col_Remarks,0),VLOOKUP($C42,Calcs,col_R+COUNTIF($C$9:$C42,$C42)-2,0)+1,VLOOKUP($C42,Calcs,col_R+COUNTIF($C$9:$C42,$C42)-1,0)-VLOOKUP($C42,Calcs,col_R+COUNTIF($C$9:$C42,$C42)-2,0))))","v":""}]
[34,false,35,null,null,0,"A0270","20302-0700",{"$f":"IF(OR($A43>End,COUNTIF($C$9:$C43,$C43)>lines_D),\"\",IF(COUNTIF($C$9:$C43,$C43)=1,LEFT(VLOOKUP($C43,Calcs,col_Description,0),VLOOKUP($C43,Calcs,col_D,0)),MID(VLOOKUP($C43,Calcs,col_Description,0),VLOOKUP($C43,Calcs,col_D+COUNTIF($C$9:$C43,$C43)-2,0)+1,VLOOKUP($C43,Calcs,col_D+COUNTIF($C$9:$C43,$C43)-1,0)-VLOOKUP($C43,Calcs,col_D+COUNTIF($C$9:$C43,$C43)-2,0))))","v":"Removal of fence, pedestrian "},"","","","","","","","","","","","","","","",{"$f":"IF(OR($A43>End,COUNTIF($C$9:$C43,$C43)>lines_R),\"\",IF(COUNTIF($C$9:$C43,$C43)=1,LEFT(VLOOKUP($C43,Calcs,col_Remarks,0),VLOOKUP($C43,Calcs,col_R,0)),MID(VLOOKUP($C43,Calcs,col_Remarks,0),VLOOKUP($C43,Calcs,col_R+COUNTIF($C$9:$C43,$C43)-2,0)+1,VLOOKUP($C43,Calcs,col_R+COUNTIF($C$9:$C43,$C43)-1,0)-VLOOKUP($C43,Calcs,col_R+COUNTIF($C$9:$C43,$C43)-2,0))))","v":""}]
[35,false,35,null,null,"","","",{"$f":"IF(OR($A44>End,COUNTIF($C$9:$C44,$C44)>lines_D),\"\",IF(COUNTIF($C$9:$C44,$C44)=1,LEFT(VLOOKUP($C44,Calcs,col_Description,0),VLOOKUP($C44,Calcs,col_D,0)),MID(VLOOKUP($C44,Calcs,col_Description,0),VLOOKUP($C44,Calcs,col_D+COUNTIF($C$9:$C44,$C44)-2,0)+1,VLOOKUP($C44,Calcs,col_D+COUNTIF($C$9:$C44,$C44)-1,0)-VLOOKUP($C44,Calcs,col_D+COUNTIF($C$9:$C44,$C44)-2,0))))","v":"railing"},"m","","","160","","","","","","","","10","","","170",{"$f":"IF(OR($A44>End,COUNTIF($C$9:$C44,$C44)>lines_R),\"\",IF(COUNTIF($C$9:$C44,$C44)=1,LEFT(VLOOKUP($C44,Calcs,col_Remarks,0),VLOOKUP($C44,Calcs,col_R,0)),MID(VLOOKUP($C44,Calcs,col_Remarks,0),VLOOKUP($C44,Calcs,col_R+COUNTIF($C$9:$C44,$C44)-2,0)+1,VLOOKUP($C44,Calcs,col_R+COUNTIF($C$9:$C44,$C44)-1,0)-VLOOKUP($C44,Calcs,col_R+COUNTIF($C$9:$C44,$C44)-2,0))))","v":""}]
[36,false,36,{"$f":"TEXT(NOW(),\"d-mmm-yyyy h:mm AM/PM\")","v":"3-Nov-2022 2:43 PM"},null,0,"A0280","20302-0700",{"$f":"IF(OR($A45>End,COUNTIF($C$9:$C45,$C45)>lines_D),\"\",IF(COUNTIF($C$9:$C45,$C45)=1,LEFT(VLOOKUP($C45,Calcs,col_Description,0),VLOOKUP($C45,Calcs,col_D,0)),MID(VLOOKUP($C45,Calcs,col_Description,0),VLOOKUP($C45,Calcs,col_D+COUNTIF($C$9:$C45,$C45)-2,0)+1,VLOOKUP($C45,Calcs,col_D+COUNTIF($C$9:$C45,$C45)-1,0)-VLOOKUP($C45,Calcs,col_D+COUNTIF($C$9:$C45,$C45)-2,0))))","v":"Removal of fence, log barrier"},"m","","","4","","","","","","","","1","","","5",{"$f":"IF(OR($A45>End,COUNTIF($C$9:$C45,$C45)>lines_R),\"\",IF(COUNTIF($C$9:$C45,$C45)=1,LEFT(VLOOKUP($C45,Calcs,col_Remarks,0),VLOOKUP($C45,Calcs,col_R,0)),MID(VLOOKUP($C45,Calcs,col_Remarks,0),VLOOKUP($C45,Calcs,col_R+COUNTIF($C$9:$C45,$C45)-2,0)+1,VLOOKUP($C45,Calcs,col_R+COUNTIF($C$9:$C45,$C45)-1,0)-VLOOKUP($C45,Calcs,col_R+COUNTIF($C$9:$C45,$C45)-2,0))))","v":""}]
[37,false,37,null,null,0,"A0290","20302-2100",{"$f":"IF(OR($A46>End,COUNTIF($C$9:$C46,$C46)>lines_D),\"\",IF(COUNTIF($C$9:$C46,$C46)=1,LEFT(VLOOKUP($C46,Calcs,col_Description,0),VLOOKUP($C46,Calcs,col_D,0)),MID(VLOOKUP($C46,Calcs,col_Description,0),VLOOKUP($C46,Calcs,col_D+COUNTIF($C$9:$C46,$C46)-2,0)+1,VLOOKUP($C46,Calcs,col_D+COUNTIF($C$9:$C46,$C46)-1,0)-VLOOKUP($C46,Calcs,col_D+COUNTIF($C$9:$C46,$C46)-2,0))))","v":"Removal of pipe culvert"},"m","","","","19","","","","","","","1","","","20",{"$f":"IF(OR($A46>End,COUNTIF($C$9:$C46,$C46)>lines_R),\"\",IF(COUNTIF($C$9:$C46,$C46)=1,LEFT(VLOOKUP($C46,Calcs,col_Remarks,0),VLOOKUP($C46,Calcs,col_R,0)),MID(VLOOKUP($C46,Calcs,col_Remarks,0),VLOOKUP($C46,Calcs,col_R+COUNTIF($C$9:$C46,$C46)-2,0)+1,VLOOKUP($C46,Calcs,col_R+COUNTIF($C$9:$C46,$C46)-1,0)-VLOOKUP($C46,Calcs,col_R+COUNTIF($C$9:$C46,$C46)-2,0))))","v":""}]
[38,false,38,null,null,0,"A0300","20302-2500",{"$f":"IF(OR($A47>End,COUNTIF($C$9:$C47,$C47)>lines_D),\"\",IF(COUNTIF($C$9:$C47,$C47)=1,LEFT(VLOOKUP($C47,Calcs,col_Description,0),VLOOKUP($C47,Calcs,col_D,0)),MID(VLOOKUP($C47,Calcs,col_Description,0),VLOOKUP($C47,Calcs,col_D+COUNTIF($C$9:$C47,$C47)-2,0)+1,VLOOKUP($C47,Calcs,col_D+COUNTIF($C$9:$C47,$C47)-1,0)-VLOOKUP($C47,Calcs,col_D+COUNTIF($C$9:$C47,$C47)-2,0))))","v":"Removal of handrail"},"m","","","58","","","","","","","","2","","","60",{"$f":"IF(OR($A47>End,COUNTIF($C$9:$C47,$C47)>lines_R),\"\",IF(COUNTIF($C$9:$C47,$C47)=1,LEFT(VLOOKUP($C47,Calcs,col_Remarks,0),VLOOKUP($C47,Calcs,col_R,0)),MID(VLOOKUP($C47,Calcs,col_Remarks,0),VLOOKUP($C47,Calcs,col_R+COUNTIF($C$9:$C47,$C47)-2,0)+1,VLOOKUP($C47,Calcs,col_R+COUNTIF($C$9:$C47,$C47)-1,0)-VLOOKUP($C47,Calcs,col_R+COUNTIF($C$9:$C47,$C47)-2,0))))","v":""}]
[39,"",40,null,null,"","","",{"$f":"IF(OR($A48>End,COUNTIF($C$9:$C48,$C48)>lines_D),\"\",IF(COUNTIF($C$9:$C48,$C48)=1,LEFT(VLOOKUP($C48,Calcs,col_Description,0),VLOOKUP($C48,Calcs,col_D,0)),MID(VLOOKUP($C48,Calcs,col_Description,0),VLOOKUP($C48,Calcs,col_D+COUNTIF($C$9:$C48,$C48)-2,0)+1,VLOOKUP($C48,Calcs,col_D+COUNTIF($C$9:$C48,$C48)-1,0)-VLOOKUP($C48,Calcs,col_D+COUNTIF($C$9:$C48,$C48)-2,0))))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(OR($A48>End,COUNTIF($C$9:$C48,$C48)>lines_R),\"\",IF(COUNTIF($C$9:$C48,$C48)=1,LEFT(VLOOKUP($C48,Calcs,col_Remarks,0),VLOOKUP($C48,Calcs,col_R,0)),MID(VLOOKUP($C48,Calcs,col_Remarks,0),VLOOKUP($C48,Calcs,col_R+COUNTIF($C$9:$C48,$C48)-2,0)+1,VLOOKUP($C48,Calcs,col_R+COUNTIF($C$9:$C48,$C48)-1,0)-VLOOKUP($C48,Calcs,col_R+COUNTIF($C$9:$C48,$C48)-2,0))))","v":""}]
[40,"",40,null,null,"","","",{"$f":"IF(OR($A49>End,COUNTIF($C$9:$C49,$C49)>lines_D),\"\",IF(COUNTIF($C$9:$C49,$C49)=1,LEFT(VLOOKUP($C49,Calcs,col_Description,0),VLOOKUP($C49,Calcs,col_D,0)),MID(VLOOKUP($C49,Calcs,col_Description,0),VLOOKUP($C49,Calcs,col_D+COUNTIF($C$9:$C49,$C49)-2,0)+1,VLOOKUP($C49,Calcs,col_D+COUNTIF($C$9:$C49,$C49)-1,0)-VLOOKUP($C49,Calcs,col_D+COUNTIF($C$9:$C49,$C49)-2,0))))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(OR($A49>End,COUNTIF($C$9:$C49,$C49)>lines_R),\"\",IF(COUNTIF($C$9:$C49,$C49)=1,LEFT(VLOOKUP($C49,Calcs,col_Remarks,0),VLOOKUP($C49,Calcs,col_R,0)),MID(VLOOKUP($C49,Calcs,col_Remarks,0),VLOOKUP($C49,Calcs,col_R+COUNTIF($C$9:$C49,$C49)-2,0)+1,VLOOKUP($C49,Calcs,col_R+COUNTIF($C$9:$C49,$C49)-1,0)-VLOOKUP($C49,Calcs,col_R+COUNTIF($C$9:$C49,$C49)-2,0))))","v":""}]
[{"$f":"IFERROR(INDEX(SheetNames[Begins],MATCH(Sheet.number,SheetNames[Sheet],0)+1),MAX(SheetNames[Begins]))","v":38},null,null,null,null,null,{"$f":"SUBSTITUTE(SUBSTITUTE(OFFSET(EEBACS,1,0),\" Date: \",\" Date: \"),\", \",CHAR(10))","v":"MileStone: PIH\nDate Completed: In Progress\nReport Date: 12/15/10"}]

{"sheet":"Calculations","index":2,"n_rows":92,"n_cols":110,"rows_kept":92,"cut":false,"hidden":false,"merged":[[1,26,1,57],[1,58,1,65],[1,68,1,99],[1,100,1,107]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(W:W)","v":120},null,null,null,{"$f":"CELL(\"width\",INDIRECT(CELL(\"address\",OFFSET(INDIRECT(OFFSET(SheetNames[[#Headers],[Worksheet]],1,0)&\"!Header\"),0,MATCH(Z4,INDIRECT(OFFSET(SheetNames[[#Headers],[Worksheet]],1,0)&\"!Header\"),0)-1,1,1))))+IF(Metric,4,0)","v":34},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CELL(\"width\",INDIRECT(CELL(\"address\",OFFSET(INDIRECT(OFFSET(SheetNames[[#Headers],[Worksheet]],1,0)&\"!Header\"),0,MATCH(BP4,INDIRECT(OFFSET(SheetNames[[#Headers],[Worksheet]],1,0)&\"!Header\"),0)-1,1,1))))","v":22}]
[null,{"$f":"ROWS(Data.13)","v":89},{"$f":"COLUMNS(Data.13)","v":21},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MATCH(Y4,OFFSET(EEBACS,2,0,1,EEBACS.cols),0)","v":2},{"$f":"MATCH(Z4,OFFSET(EEBACS,2,0,1,EEBACS.cols),0)","v":4},{"$f":"\"Maximum \"&COLUMNS(AA2:BF2)&\" words in Pay Item Description.\"","v":"Maximum 32 words in Pay Item Description."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COLUMNS(BG2:BN2)","v":8},null,null,null,null,null,null,null,null,{"$f":"MATCH(BP4,OFFSET(EEBACS,2,0,1,EEBACS.cols),0)","v":20},{"$f":"\"Maximum \"&COLUMNS(BQ2:CV2)&\" words in Remarks.\"","v":"Maximum 32 words in Remarks."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COLUMNS(CW2:DD2)","v":8}]
["Data from EEBACS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sched.","Calcs",null,{"$f":"COLUMN(Y3)-COLUMN(Calcs)+1","v":3},{"$f":"COLUMN(Z4)-COLUMN(Calcs)+1","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COLUMN(BG4)-COLUMN(Calcs)+1","v":37},null,null,null,null,null,null,null,null,{"$f":"COLUMN(BP4)-COLUMN(Calcs)+1","v":46},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COLUMN(CW4)-COLUMN(Calcs)+1","v":79},null,null,null,null,null,null,null,null,{"$f":"MATCH(DF4,OFFSET(EEBACS,2,0,1,EEBACS.cols),0)","v":5}]
["MileStone: PIH, Date Completed: In Progress, Report Date: 12/15/10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"Counter",{"$f":"OFFSET(X4,1,0)","v":0},"Line Item No.","Pay Item Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D",null,null,null,null,null,null,null,null,"Remarks and/or Determination of Estimated Quantity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R",null,null,null,null,null,null,null,null,"Unit"]
["Amendment No.","Line Item No.","Pay Item Number","Pay Item Description","Unit","C: Typical Section","D: Plan, Roadway","E: Layout, Parking Area","F: Drainage","G: Walls","M: Temp. Erosion Control","P: Perm. Traffic Control","***: Column 8","B.66-B.85`: Column 9","-: Column 10","Plan: Allow- ance","C12: Column 12","C13: Column 13","Estimated Quantities\\Bid Schedule","Remarks and/or Determination of Estimated Quantity","Deleted",{"$f":"OFFSET(V5,-1,0)+IF(X5=OFFSET(X5,1,0),0,1)","v":1},{"$f":"IF(OFFSET(W5,0,col_Unit-COLUMN(W5))=\"Unit\",0,OFFSET(W5,-1,0)+IF(Y5=Y$4,0,MAX(1,BO5,DE5)))","v":0},{"$f":"IF(OR(Y5=Y$4,OFFSET(Y5,-1,0)=Y$4,LEFT(Y5,1)<>LEFT(OFFSET(Y5,-1,0),1)),W5,OFFSET(X5,-1,0))","v":0},{"$f":"OFFSET(Y5,0,-COLUMN(Y$2)+Y$2)","v":"Line Item No."},{"$f":"SUBSTITUTE(TRIM(OFFSET(Z5,0,-COLUMN(Z$2)+Z$2)),\" , \",\", \")","v":"Pay Item Description"},{"$f":"IFERROR(FIND(\" \",$Z5,IFERROR(OFFSET(AA5,0,-1)+1,1)),LEN($Z5))","v":4},9,20,20,20,20,20,20,20,20,{"$f":"IFERROR(FIND(\" \",$Z5,IFERROR(OFFSET(AK5,0,-1)+1,1)),LEN($Z5))","v":20},20,20,20,20,20,20,20,20,20,{"$f":"IFERROR(FIND(\" \",$Z5,IFERROR(OFFSET(AU5,0,-1)+1,1)),LEN($Z5))","v":20},20,20,20,20,20,20,20,20,20,20,20,{"$f":"HLOOKUP(IF(COLUMN(BG5)-COLUMN($BG$4)=0,0,OFFSET(BG5,0,-1))+width_Pay.item,$AA5:$BF5,1)","v":20},20,20,20,20,20,20,20,{"$f":"IF(LEN(DF5)>0,COUNTIF(BG5:BN5,\"<\"&MAX(BG5:BN5))+1,0)","v":0},{"$f":"TRIM(OFFSET(BP5,0,-COLUMN(BP$2)+BP$2))","v":"Remarks and/or Determination of Estimated Quantity"},{"$f":"IFERROR(FIND(\" \",$BP5,IFERROR(OFFSET(BQ5,0,-1)+1,1)),LEN($BP5))","v":8},15,29,32,42,50,50,50,50,50,{"$f":"IFERROR(FIND(\" \",$BP5,IFERROR(OFFSET(CA5,0,-1)+1,1)),LEN($BP5))","v":50},50,50,50,50,50,50,50,50,50,{"$f":"IFERROR(FIND(\" \",$BP5,IFERROR(OFFSET(CK5,0,-1)+1,1)),LEN($BP5))","v":50},50,50,50,50,50,50,50,50,50,50,50,{"$f":"HLOOKUP(IF(COLUMN(CW5)-COLUMN($CW$4)=0,0,OFFSET(CW5,0,-1))+width_Remarks,$BQ5:$CV5,1)","v":15},32,50,50,50,50,50,50,{"$f":"IF(LEN(DF5)>0,COUNTIF(CW5:DD5,\"<\"&MAX(CW5:DD5))+1,0)","v":0},{"$f":"IFERROR(VLOOKUP(OFFSET(DF5,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":""}]
[null,"A0010","15101-0000","Mobilization   ","LPSM","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|ALL||",null,null,{"$f":"OFFSET(V6,-1,0)+IF(X6=OFFSET(X6,1,0),0,1)","v":1},{"$f":"IF(OFFSET(W6,0,col_Unit-COLUMN(W6))=\"Unit\",0,OFFSET(W6,-1,0)+IF(Y6=Y$4,0,MAX(1,BO6,DE6)))","v":1},{"$f":"IF(OR(Y6=Y$4,OFFSET(Y6,-1,0)=Y$4,LEFT(Y6,1)<>LEFT(OFFSET(Y6,-1,0),1)),W6,OFFSET(X6,-1,0))","v":1},"A0010","Mobilization",12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,{"$f":"IF(LEN(DF6)>0,COUNTIF(BG6:BN6,\"<\"&MAX(BG6:BN6))+1,0)","v":1},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(LEN(DF6)>0,COUNTIF(CW6:DD6,\"<\"&MAX(CW6:DD6))+1,0)","v":1},{"$f":"IFERROR(VLOOKUP(OFFSET(DF6,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0020","15201-0000","Construction survey and staking   ","LPSM","All|||","All|All||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|ALL||",null,null,1,2,1,"A0020","Construction survey and staking",13,20,24,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF7,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0030","15301-0010","Contractor quality control and assurance   ","LPSM","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|ALL||",null,null,1,4,1,"A0030","Contractor quality control and assurance",11,19,27,31,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,31,40,40,40,40,40,40,40,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF8,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0040","15401-0000","Contractor testing   ","LPSM","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|ALL||",null,null,1,5,1,"A0040","Contractor testing",11,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF9,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0050","15501-0000","Construction schedule   ","LPSM","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|ALL||",null,null,1,6,1,"A0050","Construction schedule",13,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF10,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0060","15704-1000","Soil erosion control, plastic lining   ","m2","All|||","All|||","All|||","All|||","All|||","All|165||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|165||",null,null,1,8,1,"A0060","Soil erosion control, plastic lining",5,13,22,30,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,30,36,36,36,36,36,36,36,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF11,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0070","15705-0100","Soil erosion control, silt fence   ","m","All|||","All|||","All|||","All|||","All|||","All|1,630||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|1,630||",null,null,1,9,1,"A0070","Soil erosion control, silt fence",5,13,22,27,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF12,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0080","15705-0600","Soil erosion control, temporary 600mm culvert pipe   ","m","All|||","All|||","All|||","All|||","All|||","All|16||","All|||","All|||","All|||","All|||","All|4||","All|||","All|||","All|20||",null,null,1,11,1,"A0080","Soil erosion control, temporary 600mm culvert pipe",5,13,22,32,38,46,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,32,50,50,50,50,50,50,50,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF13,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0090","15705-1300","Soil erosion control, temporary diversion channel   ","m","All|||","All|||","All|||","All|||","All|||","All|33||","All|||","All|||","All|||","All|||","All|2||","All|||","All|||","All|35||",null,null,1,13,1,"A0090","Soil erosion control, temporary diversion channel",5,13,22,32,42,49,49,49,49,49,49,49,49,49,49,49,49,49,49,49,49,49,49,49,49,49,49,49,49,49,49,49,32,49,49,49,49,49,49,49,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF14,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0100","15705-1400","Soil erosion control, sediment log   ","m","All|||","All|||","All|||","All|||","All|||","All|36||","All|||","All|||","All|||","All|||","All|4||","All|||","All|||","All|40||",null,null,1,14,1,"A0100","Soil erosion control, sediment log",5,13,22,31,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF15,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0110","15706-0300","Soil erosion control, sandbag   ","Each","All|||","All|||","All|||","All|||","All|||","All|200||","All|||","All|||","All|||","All|||","All|10||","All|||","All|||","All|210||",null,null,1,15,1,"A0110","Soil erosion control, sandbag",5,13,22,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF16,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0120","20101-0000","Clearing and grubbing   ","ha","All|||","All|0.11||","All|0.45||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|0.02||","All|||","All|||","All|0.58||",null,null,1,16,1,"A0120","Clearing and grubbing",9,13,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF17,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0130","20103-0000","Clearing and grubbing   ","m2","All|||","All|||","All|||","All|||","All|675||","All|||","All|||","All|||","All|||","All|||","All|25||","All|||","All|||","All|700||",null,null,1,17,1,"A0130","Clearing and grubbing",9,13,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF18,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0140","20212-0000","Special clearing   ","m2","All|||","All|1,672||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|78||","All|||","All|||","All|1,750||",null,null,1,18,1,"A0140","Special clearing",8,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF19,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0150","20301-0080","Removal of bench   ","Each","All|||","All|||","All|6||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|6||",null,null,1,19,1,"A0150","Removal of bench",8,11,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF20,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0160","20301-0500","Removal of catch basin   ","Each","All|||","All|||","All|||","All|2||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|2||",null,null,1,20,1,"A0160","Removal of catch basin",8,11,17,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF21,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0170","20301-1200","Removal of headwall   ","Each","All|||","All|||","All|||","All|1||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|1||",null,null,1,21,1,"A0170","Removal of headwall",8,11,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF22,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0180","20301-1400","Removal of inlet   ","Each","All|||","All|||","All|||","All|7||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|7||",null,null,1,22,1,"A0180","Removal of inlet",8,11,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF23,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0190","20301-2400","Removal of signs   ","Each","All|||","All|||","All|||","All|||","All|||","All|||","All|33||","All|||","All|||","All|||","All|1||","All|||","All|||","All|34||",null,null,1,23,1,"A0190","Removal of signs",8,11,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF24,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0200","20301-2700","Removal of structure   , timber sidewalk","Each","All|||","All|||","All|1||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|1||",null,null,1,25,1,"A0200","Removal of structure, timber sidewalk",8,11,22,29,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,{"$f":"IFERROR(FIND(\" \",$Z25,IFERROR(OFFSET(AX25,0,-1)+1,1)),LEN($Z25))","v":37},37,37,37,37,37,37,37,37,29,37,37,37,37,37,37,37,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(FIND(\" \",$BP25,IFERROR(OFFSET(CN25,0,-1)+1,1)),LEN($BP25))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF25,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0210","20301-2700","Removal of structure   , information box","Each","All|||","All|||","All|||","All|||","All|||","All|||","All|3||","All|||","All|||","All|||","All|||","All|||","All|||","All|3||",null,null,1,27,1,"A0210","Removal of structure, information box",8,11,22,34,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,34,37,37,37,37,37,37,37,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF26,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0220","20301-3000","Removal of trash receptacle   ","Each","All|||","All|||","All|7||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|7||",null,null,1,28,1,"A0220","Removal of trash receptacle",8,11,17,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF27,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0230","20302-0300","Removal of curb and gutter, concrete   ","m","All|||","All|||","All|756||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|44||","All|||","All|||","All|800||",null,null,1,30,1,"A0230","Removal of curb and gutter, concrete",8,11,16,20,28,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,28,36,36,36,36,36,36,36,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF28,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0240","20302-0400","Removal of curb, asphalt   ","m","All|||","All|104||","All|727||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|34||","All|||","All|||","All|865||",null,null,1,31,1,"A0240","Removal of curb, asphalt",8,11,17,24,24,{"$f":"IFERROR(FIND(\" \",$Z29,IFERROR(OFFSET(AF29,0,-1)+1,1)),LEN($Z29))","v":24},24,24,24,24,24,24,24,24,24,{"$f":"IFERROR(FIND(\" \",$Z29,IFERROR(OFFSET(AP29,0,-1)+1,1)),LEN($Z29))","v":24},24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,1,"",0,0,0,0,0,{"$f":"IFERROR(FIND(\" \",$BP29,IFERROR(OFFSET(BV29,0,-1)+1,1)),LEN($BP29))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(FIND(\" \",$BP29,IFERROR(OFFSET(CF29,0,-1)+1,1)),LEN($BP29))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF29,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0250","20302-0500","Removal of curb, concrete   ","m","All|||","All|||","All|161||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|9||","All|||","All|||","All|170||",null,null,1,32,1,"A0250","Removal of curb, concrete",8,11,17,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF30,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0260","20302-0625","Removal of curb, log   ","m","All|||","All|||","All|38||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|2||","All|||","All|||","All|40||",null,null,1,33,1,"A0260","Removal of curb, log",8,11,17,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF31,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0270","20302-0700","Removal of fence   , pedestrian railing","m","All|||","All|||","All|160||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|10||","All|||","All|||","All|170||",null,null,1,35,1,"A0270","Removal of fence, pedestrian railing",8,11,18,29,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,29,36,36,36,36,36,36,36,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF32,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0280","20302-0700","Removal of fence   , log barrier","m","All|||","All|||","All|4||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|1||","All|||","All|||","All|5||",null,null,1,36,1,"A0280","Removal of fence, log barrier",8,11,18,22,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF33,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0290","20302-2100","Removal of pipe culvert   ","m","All|||","All|||","All|||","All|19||","All|||","All|||","All|||","All|||","All|||","All|||","All|1||","All|||","All|||","All|20||",null,null,1,37,1,"A0290","Removal of pipe culvert",8,11,16,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF34,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0300","20302-2500","Removal of handrail   ","m","All|||","All|||","All|58||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|2||","All|||","All|||","All|60||",null,null,1,38,1,"A0300","Removal of handrail",8,11,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,{"$f":"HLOOKUP(IF(COLUMN(BN35)-COLUMN($BG$4)=0,0,OFFSET(BN35,0,-1))+width_Pay.item,$AA35:$BF35,1)","v":19},1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"HLOOKUP(IF(COLUMN(DD35)-COLUMN($CW$4)=0,0,OFFSET(DD35,0,-1))+width_Remarks,$BQ35:$CV35,1)","v":0},1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF35,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0310","20303-0300","Removal of concrete   , pads and stairs","m2","All|||","All|||","All|18||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|2||","All|||","All|||","All|20||",null,null,1,40,1,"A0310","Removal of concrete, pads and stairs",8,11,21,26,30,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,30,36,36,36,36,36,36,36,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF36,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0320","20303-1200","Removal of paved waterway, asphalt   ","m2","All|||","All|||","All|||","All|||","All|13||","All|||","All|||","All|||","All|||","All|||","All|2||","All|||","All|||","All|15||",null,null,1,41,1,"A0320","Removal of paved waterway, asphalt",8,11,17,27,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF37,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0330","20303-3000","Removal of sidewalk, asphalt   ","m2","All|||","All|||","All|3,628||","All|||","All|138||","All|||","All|||","All|||","All|||","All|||","All|104||","All|||","All|||","All|3,870||",null,null,1,42,1,"A0330","Removal of sidewalk, asphalt",8,11,21,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF38,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0340","20303-3600","Removal of wall   , timber crib","m2","All|||","All|||","All|50||","All|||","All|170||","All|||","All|||","All|||","All|||","All|||","All|10||","All|||","All|||","All|230||",null,null,1,43,1,"A0340","Removal of wall, timber crib",8,11,17,24,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF39,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0350","20401-0000","Roadway excavation  ","m3","All|||","All|63||","All|1,561||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|76||","All|||","All|||","All|1,700||",null,null,1,44,1,"A0350","Roadway excavation",8,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF40,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0360","20402-0000","Subexcavation   ","m3","All|8,719||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|431||","All|||","All|||","All|9,150||",null,null,1,45,1,"A0360","Subexcavation",13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF41,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0370","20402-0000","Subexcavation   , drywell","m3","All|||","All|||","All|||","All|8,595||","All|||","All|||","All|||","All|||","All|||","All|||","All|205||","All|||","All|||","All|8,800||",null,null,1,46,1,"A0370","Subexcavation, drywell",15,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF42,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0380","20411-0000","Select borrow   ","t","All|17,100||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|850||","All|||","All|||","All|17,950||",null,null,1,47,1,"A0380","Select borrow",7,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF43,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0390","20411-0000","Select borrow   , permeable","t","All|||","All|||","All|||","All|6,600||","All|||","All|||","All|||","All|||","All|||","All|||","All|200||","All|||","All|||","All|6,800||",null,null,1,48,1,"A0390","Select borrow, permeable",7,15,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF44,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0400","20701-1100","Earthwork geotextile, type III-B   ","m2","All|13,460||","All|||","All|||","All|||","All|140||","All|||","All|||","All|||","All|||","All|||","All|600||","All|||","All|||","All|14,200||",null,null,1,49,1,"A0400","Earthwork geotextile, type III-B",10,22,27,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF45,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0410","20701-1200","Earthwork geotextile, type IV-A   ","m2","All|||","All|||","All|||","All|2,447||","All|||","All|||","All|||","All|||","All|||","All|||","All|103||","All|||","All|||","All|2,550||",null,null,1,50,1,"A0410","Earthwork geotextile, type IV-A",10,22,27,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,{"$f":"IFERROR(FIND(\" \",$Z46,IFERROR(OFFSET(BA46,0,-1)+1,1)),LEN($Z46))","v":31},31,31,31,31,31,31,31,31,31,31,31,31,31,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(FIND(\" \",$BP46,IFERROR(OFFSET(CQ46,0,-1)+1,1)),LEN($BP46))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF46,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0420","20701-1300","Earthwork geotextile, type IV-B   ","m2","All|||","All|||","All|||","All|2,350||","All|||","All|||","All|||","All|||","All|||","All|||","All|100||","All|||","All|||","All|2,450||",null,null,1,51,1,"A0420","Earthwork geotextile, type IV-B",10,22,27,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF47,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0430","21301-1000","Subgrade stabilization with lime, 150mm depth   ","m2","All|7,096||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|354||","All|||","All|||","All|7,450||",null,null,1,53,1,"A0430","Subgrade stabilization with lime, 150mm depth",9,23,28,34,40,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,34,45,45,45,45,45,45,45,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF48,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0440","21302-0000","Lime   ","t","All|||","All|||","All|||","All|64||","All|||","All|||","All|||","All|||","All|||","All|||","All|6||","All|||","All|||","All|70||",null,null,1,54,1,"A0440","Lime",4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF49,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0450","25101-1000","Placed riprap, class 1   , slope protection","m3","All|||","All|||","All|20||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|5||","All|||","All|||","All|25||",null,null,1,56,1,"A0450","Placed riprap, class 1, slope protection",7,15,21,24,30,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,30,40,40,40,40,40,40,40,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF50,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0460","25101-2000","Placed riprap, class 2   , energy dissipator","m3","All|||","All|||","All|||","All|18.0||","All|0.8||","All|||","All|||","All|||","All|||","All|||","All|2.2||","All|||","All|||","All|21.0||",null,null,1,58,1,"A0460","Placed riprap, class 2, energy dissipator",7,15,21,24,31,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,31,41,41,41,41,41,41,41,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF51,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0470","25101-3000","Placed riprap, class 3   , headwall","m3","All|||","All|||","All|||","All|21||","All|||","All|||","All|||","All|||","All|||","All|||","All|1||","All|||","All|||","All|22||",null,null,1,59,1,"A0470","Placed riprap, class 3, headwall",7,15,21,24,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF52,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0480","25101-3000","Placed riprap, class 3   , energy dissipator","m3","All|||","All|||","All|||","All|16||","All|||","All|||","All|||","All|||","All|||","All|||","All|1||","All|||","All|||","All|17||",null,null,1,61,1,"A0480","Placed riprap, class 3, energy dissipator",7,15,21,24,31,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,31,41,41,41,41,41,41,41,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF53,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0490","25120-1000","Riprap ditch, class 1   ","m","All|||","All|||","All|182||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|8||","All|||","All|||","All|190||",null,null,1,62,1,"A0490","Riprap ditch, class 1",7,14,20,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF54,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0500","25125-0000","Boulder   , landscape, type 1","Each","All|||","All|||","All|25||","All|||","All|25||","All|||","All|||","All|||","All|||","All|||","All|5||","All|||","All|||","All|55||",null,null,1,63,1,"A0500","Boulder, landscape, type 1",{"$f":"IFERROR(FIND(\" \",$Z55,IFERROR(OFFSET(AA55,0,-1)+1,1)),LEN($Z55))","v":9},20,25,26,26,26,26,26,26,26,26,26,26,26,26,26,{"$f":"IFERROR(FIND(\" \",$Z55,IFERROR(OFFSET(AQ55,0,-1)+1,1)),LEN($Z55))","v":26},26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,1,"",{"$f":"IFERROR(FIND(\" \",$BP55,IFERROR(OFFSET(BQ55,0,-1)+1,1)),LEN($BP55))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(FIND(\" \",$BP55,IFERROR(OFFSET(CG55,0,-1)+1,1)),LEN($BP55))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF55,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0510","25125-0000","Boulder   , landscape, type 2","Each","All|||","All|||","All|40||","All|||","All|15||","All|||","All|||","All|||","All|||","All|||","All|5||","All|||","All|||","All|60||",null,null,1,64,1,"A0510","Boulder, landscape, type 2",9,20,25,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF56,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0520","25125-0000","Boulder   , landscape, type 3","Each","All|||","All|||","All|42||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|3||","All|||","All|||","All|45||",null,null,1,65,1,"A0520","Boulder, landscape, type 3",9,20,25,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF57,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0530","25125-0000","Boulder   , barrier, type 1","Each","All|||","All|||","All|34||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|1||","All|||","All|||","All|35||",null,null,1,66,1,"A0530","Boulder, barrier, type 1",9,18,23,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF58,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0540","25125-0000","Boulder   , barrier, type 2","Each","All|||","All|||","All|329||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|6||","All|||","All|||","All|335||",null,null,1,67,1,"A0540","Boulder, barrier, type 2",9,18,23,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF59,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0550","25126-0000","Remove and reset boulder   ","Each","All|||","All|||","All|208||","All|||","All|1||","All|||","All|||","All|||","All|||","All|||","All|6||","All|||","All|||","All|215||",null,null,1,68,1,"A0550","Remove and reset boulder",7,11,17,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF60,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0560","25210-0000","Rockery   , type 1","m2","All|||","All|||","All|||","All|||","All|212||","All|||","All|||","All|||","All|||","All|||","All|8||","All|||","All|||","All|220||",null,null,1,69,1,"A0560","Rockery, type 1",9,14,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF61,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0570","25210-0000","Rockery   , type 2","m2","All|||","All|||","All|||","All|||","All|130||","All|||","All|||","All|||","All|||","All|||","All|10||","All|||","All|||","All|140||",null,null,1,70,1,"A0570","Rockery, type 2",9,14,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF62,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0580","25210-0000","Rockery   , type 3","m2","All|||","All|||","All|||","All|||","All|102||","All|||","All|||","All|||","All|||","All|||","All|8||","All|||","All|||","All|110||",null,null,1,71,1,"A0580","Rockery, type 3",9,14,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF63,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0590","25410-0000","Treated timber crib retaining wall   ","m2","All|||","All|||","All|||","All|||","All|175||","All|||","All|||","All|||","All|||","All|||","All|10||","All|||","All|||","All|185||",null,null,1,72,1,"A0590","Treated timber crib retaining wall",8,15,20,30,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF64,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0600","25410-0000","Treated timber crib retaining wall   , facing","m2","All|||","All|||","All|||","All|||","All|39||","All|||","All|||","All|||","All|||","All|||","All|1||","All|||","All|||","All|40||",null,null,1,74,1,"A0600","Treated timber crib retaining wall, facing",8,15,20,30,36,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,30,42,42,42,42,42,42,42,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF65,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0610","25501-1000","Mechanically stabilized earth wall, welded wire face    with dry-laid stone facing","m2","All|||","All|||","All|||","All|||","All|38||","All|||","All|||","All|||","All|||","All|||","All|2||","All|||","All|||","All|40||",null,null,1,77,1,"A0610","Mechanically stabilized earth wall, welded wire face with dry-laid stone facing",13,24,30,36,43,48,53,58,67,73,79,79,79,79,79,79,79,79,79,79,79,79,79,79,79,79,79,79,79,79,79,79,30,58,79,79,79,79,79,79,3,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF66,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0620","27201-1000","Reinforced soil slope, geogrid   ","m2","All|||","All|||","All|||","All|||","All|35||","All|||","All|||","All|||","All|||","All|||","All|5||","All|||","All|||","All|40||",null,null,1,78,1,"A0620","Reinforced soil slope, geogrid",11,16,23,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,{"$f":"IFERROR(FIND(\" \",$Z67,IFERROR(OFFSET(BD67,0,-1)+1,1)),LEN($Z67))","v":30},30,30,30,30,30,30,30,30,{"$f":"HLOOKUP(IF(COLUMN(BM67)-COLUMN($BG$4)=0,0,OFFSET(BM67,0,-1))+width_Pay.item,$AA67:$BF67,1)","v":30},30,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(FIND(\" \",$BP67,IFERROR(OFFSET(CT67,0,-1)+1,1)),LEN($BP67))","v":0},0,0,0,0,0,0,0,0,{"$f":"HLOOKUP(IF(COLUMN(DC67)-COLUMN($CW$4)=0,0,OFFSET(DC67,0,-1))+width_Remarks,$BQ67:$CV67,1)","v":0},0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF67,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0630","30302-1000","Ditch reconditioning   ","m","All|||","All|2,684||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|126||","All|||","All|||","All|2,810||",null,null,1,79,1,"A0630","Ditch reconditioning",6,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF68,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0640","31001-0000","Recycled aggregate base   , type 1, 200 mm depth","m2","All|2,251||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|59||","All|||","All|||","All|2,310||",null,null,1,81,1,"A0640","Recycled aggregate base, type 1, 200 mm depth",9,19,25,30,33,37,40,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,33,45,45,45,45,45,45,45,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF69,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0650","31001-0000","Recycled aggregate base   , type 2, 125 mm depth","m2","All|36,242||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|908||","All|||","All|||","All|37,150||",null,null,{"$f":"OFFSET(V70,-1,0)+IF(X70=OFFSET(X70,1,0),0,1)","v":1},{"$f":"IF(OFFSET(W70,0,col_Unit-COLUMN(W70))=\"Unit\",0,OFFSET(W70,-1,0)+IF(Y70=Y$4,0,MAX(1,BO70,DE70)))","v":83},{"$f":"IF(OR(Y70=Y$4,OFFSET(Y70,-1,0)=Y$4,LEFT(Y70,1)<>LEFT(OFFSET(Y70,-1,0),1)),W70,OFFSET(X70,-1,0))","v":1},"A0650","Recycled aggregate base, type 2, 125 mm depth",9,19,25,30,33,37,40,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,33,45,45,45,45,45,45,45,{"$f":"IF(LEN(DF70)>0,COUNTIF(BG70:BN70,\"<\"&MAX(BG70:BN70))+1,0)","v":2},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(LEN(DF70)>0,COUNTIF(CW70:DD70,\"<\"&MAX(CW70:DD70))+1,0)","v":1},{"$f":"IFERROR(VLOOKUP(OFFSET(DF70,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0660","31001-0000","Recycled aggregate base   , type 3, 150 mm depth","m2","All|17,223||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|277||","All|||","All|||","All|17,500||",null,null,1,85,1,"A0660","Recycled aggregate base, type 3, 150 mm depth",9,19,25,30,33,37,40,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,33,45,45,45,45,45,45,45,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF71,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0670","31101-0000","Stockpiled aggregate   , Government-furnished","t","All|1,669||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|81||","All|||","All|||","All|1,750||",null,null,1,87,1,"A0670","Stockpiled aggregate, Government-furnished",11,22,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,22,42,42,42,42,42,42,42,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF72,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0680","40301-0000","Hot asphalt concrete pavement   ","t","All|7,714.8||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|196.2||","All|||","All|||","All|7,911.0||",null,null,1,88,1,"A0680","Hot asphalt concrete pavement",4,12,21,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF73,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0690","40305-3000","Antistrip additive, type 3   ","t","All|77.15||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|3.75||","All|||","All|||","All|80.90||",null,null,1,89,1,"A0690","Antistrip additive, type 3",10,20,25,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF74,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0700","41201-1000","Tack coat grade CSS-1, CSS-1h, SS-1, or SS-1h   ","t","All|10.21||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|0.49||","All|||","All|||","All|10.70||",null,null,1,91,1,"A0700","Tack coat grade CSS-1, CSS-1h, SS-1, or SS-1h",5,10,16,23,31,37,40,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,31,45,45,45,45,45,45,45,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF75,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0710","50101-0900","Reinforced rigid pavement, 200mm depth, type C smoothness   ","m2","All|||","All|||","All|9||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|1||","All|||","All|||","All|10||",null,null,1,93,1,"A0710","Reinforced rigid pavement, 200mm depth, type C smoothness",11,17,27,33,40,45,47,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,33,57,57,57,57,57,57,57,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF76,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0730","55505-0000","Structural steel soldier piles   , HP 310 x 125","m","All|||","All|||","All|||","All|||","All|91.2||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|91.2||",null,null,1,95,1,"A0730","Structural steel soldier piles, HP 310 x 125",11,17,25,32,35,39,41,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,32,44,44,44,44,44,44,44,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF77,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0740","55701-2000","Structural timber and lumber, treated   ","m3","All|||","All|||","All|||","All|||","All|3.7||","All|||","All|||","All|||","All|||","All|||","All|0.3||","All|||","All|||","All|4.0||",null,null,1,97,1,"A0740","Structural timber and lumber, treated",11,18,22,30,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,30,37,37,37,37,37,37,37,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF78,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0750","56302-1000","Painting, concrete structure   ","m2","All|||","All|||","All|||","All|875||","All|||","All|||","All|||","All|||","All|||","All|||","All|40||","All|||","All|||","All|915||",null,null,1,98,1,"A0750","Painting, concrete structure",10,19,28,28,28,28,28,28,28,{"$f":"IFERROR(FIND(\" \",$Z79,IFERROR(OFFSET(AJ79,0,-1)+1,1)),LEN($Z79))","v":28},28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,1,"",0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(FIND(\" \",$BP79,IFERROR(OFFSET(BZ79,0,-1)+1,1)),LEN($BP79))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF79,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0760","56501-0000","Drilled shafts   , 610 mm diameter","m","All|||","All|||","All|||","All|||","All|81||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|81||",null,null,1,99,1,"A0760","Drilled shafts, 610 mm diameter",8,16,20,23,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF80,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0770","60101-0000","Concrete   ","m3","All|||","All|||","All|||","All|||","All|19.6||","All|||","All|||","All|||","All|||","All|||","All|1.0||","All|||","All|||","All|20.6||",null,null,1,100,1,"A0770","Concrete",8,8,8,8,8,8,8,8,8,8,8,{"$f":"IFERROR(FIND(\" \",$Z81,IFERROR(OFFSET(AL81,0,-1)+1,1)),LEN($Z81))","v":8},8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,1,"",0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(FIND(\" \",$BP81,IFERROR(OFFSET(CB81,0,-1)+1,1)),LEN($BP81))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF81,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0780","60101-0000","Concrete   , anchor system","m3","All|||","All|||","All|1.5||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|0.1||","All|||","All|||","All|1.6||",null,null,1,101,1,"A0780","Concrete, anchor system",10,17,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF82,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0790","60102-0000","Concrete   , pad","m2","All|||","All|||","All|43||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|2||","All|||","All|||","All|45||",null,null,1,102,1,"A0790","Concrete, pad",10,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF83,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0800","60704-0000","Cleaning culvert in place   ","Each","All|||","All|||","All|||","All|19||","All|||","All|||","All|||","All|||","All|||","All|||","All|1||","All|||","All|||","All|20||",null,null,1,103,1,"A0800","Cleaning culvert in place",9,17,20,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF84,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0810","60706-0000","Cleaning drainage structure   , inlet","Each","All|||","All|||","All|||","All|5||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|5||",null,null,1,104,1,"A0810","Cleaning drainage structure, inlet",9,18,29,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF85,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0820","60707-0300","Lining 450mm pipe culvert   ","m","All|||","All|||","All|||","All|31||","All|||","All|||","All|||","All|||","All|||","All|||","All|2||","All|||","All|||","All|33||",null,null,1,105,1,"A0820","Lining 450mm pipe culvert",7,13,18,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF86,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0830","60709-0000","Cleaning drainage structures in place   , concrete gutter","m","All|||","All|||","All|||","All|223||","All|||","All|||","All|||","All|||","All|||","All|||","All|12||","All|||","All|||","All|235||",null,null,1,107,1,"A0830","Cleaning drainage structures in place, concrete gutter",9,18,29,32,39,48,54,54,54,54,54,54,54,54,54,54,54,54,54,54,54,54,54,54,54,54,54,54,54,54,54,54,32,54,54,54,54,54,54,54,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF87,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0840","62201-0600","Backhoe loader, 240 liter minimum rated capacity bucket, 750mm width   ","Hour","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|100||",null,null,1,109,1,"A0840","Backhoe loader, 240 liter minimum rated capacity bucket, 750mm width",8,16,20,26,34,40,49,57,63,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,34,68,68,68,68,68,68,68,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF88,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0850","62201-2600","Crane, truck mounted or self-propelled, 90 metric tons minimum capacity, 55m min. boom, with dragline bucket, wrecking ball, 6m dozer track   ","Hour","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||",null,null,1,114,1,"A0850","Crane, truck mounted or self-propelled, 90 metric tons minimum capacity, 55m min. boom, with dragline bucket, wrecking ball, 6m dozer track",7,13,21,24,40,43,50,55,63,73,77,82,88,93,102,110,119,125,128,134,139,139,139,139,139,139,{"$f":"IFERROR(FIND(\" \",$Z89,IFERROR(OFFSET(BA89,0,-1)+1,1)),LEN($Z89))","v":139},139,139,139,139,139,24,55,88,119,139,139,139,139,5,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(FIND(\" \",$BP89,IFERROR(OFFSET(CQ89,0,-1)+1,1)),LEN($BP89))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF89,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0860","62201-3400","Hydraulic excavator, 1.1 cubic meter minimum capacity with thumb attachment     ","Hour","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|40||",null,null,1,117,1,"A0860","Hydraulic excavator, 1.1 cubic meter minimum capacity with thumb attachment",10,21,25,31,37,45,54,59,65,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,31,65,75,75,75,75,75,75,3,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF90,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0870","63502-0700","Temporary traffic control, cone   ","Each","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|20||","All|||","All|||","All|||","All|||","All|20||",null,null,1,118,1,"A0870","Temporary traffic control, cone",10,18,27,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF91,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0880","64601-1000","Building, restroom facility   , tank installation, government-furnished","Each","All|||","All|||","All|2||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|2||",null,null,2,120,1,"A0880","Building, restroom facility, tank installation, government-furnished",10,19,29,34,48,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,34,68,68,68,68,68,68,68,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DF92,0,col_Unit-COLUMN(DF$3)),Units[],2,0),\"\")","v":"Dual"}]

{"sheet":"Variables","index":3,"n_rows":58,"n_cols":11,"rows_kept":58,"cut":false,"hidden":false,"merged":[[41,9,45,10]]}
["Variables"]
[null,"Base sheet name:","Sheet",null,null,"Prefix:",{"$f":"LEFT(Sheet,MIN(FIND({0,1,2,3,4,5,6,7,8,9},Sheet&\"0123456789\"))-1)","v":"B."}]
[null,"Min. rows/sheet:",5,null,null,"Sheets needed:",{"$f":"MATCH(MAX(SheetNames[Begins]),SheetNames[Begins],0)-1","v":4}]
[null,"Max. row/sheet:",40,null,null,"Current sheets:",{"$f":"COUNTIF(SheetNames[Sheet num],\">0\")","v":1}]
[null,"Metric?",{"$f":"ISNUMBER(MATCH(\"Metric\",Units.check,0))","v":true},null,null,"Description truncated?",{"$f":"MAX(OFFSET(Calcs,0,col_D-1+lines_D,ROWS(Calcs),1))=lines_D","v":false}]
[null,null,null,null,null,"Remarks truncated?",{"$f":"MAX(OFFSET(Calcs,0,col_R-1+lines_R,ROWS(Calcs),1))=lines_R","v":false}]
["SheetNames",null,null,null,null,null,null,null,null,"Units"]
["Sheet num","Worksheet","Sheet","Begins","Draft","Lines","Adjust","Sect",null,"Symbol","Unit"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":1},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"B.1"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":0},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":0},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":40},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":2},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":1},null,"ACRE","US Customary"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-2},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (2)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":38},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":40},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":39},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":2},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":1},null,"CTSM","Dual"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-3},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (3)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":74},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":79},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":39},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":2},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":1},null,"CUFT","US Customary"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-4},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (4)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":109},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":118},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":2},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":2},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":1},null,"CUYD","US Customary"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-5},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (5)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"DAY","Dual"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-6},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (6)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"EACH","Dual"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-7},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (7)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"FXHR","Dual"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-8},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (8)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"GAL","US Customary"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-9},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (9)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"ha","Metric"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-10},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (10)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"HOUR","Dual"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-11},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (11)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"kg","Metric"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-12},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (12)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"km","Metric"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-13},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (13)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"l","Metric"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-14},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (14)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"LB","US Customary"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-15},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (15)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"LNFT","US Customary"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-16},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (16)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"LPSM","Dual"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-17},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (17)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"m","Metric"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-18},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (18)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"m2","Metric"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-19},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (19)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"m3","Metric"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-20},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (20)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"MFBM","US Customary"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-21},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (21)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"MGAL","US Customary"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-22},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (22)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"MILE","US Customary"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-23},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (23)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"MO","Dual"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-24},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (24)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"SLRY","Dual"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-25},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (25)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"SQFT","US Customary"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-26},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (26)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"SQYD","US Customary"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-27},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (27)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"STA","US Customary"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-28},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (28)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"t","Metric"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-29},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (29)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"TON","US Customary"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-30},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (30)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"WEEK","Dual"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-31},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (31)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-32},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (32)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-33},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (33)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-34},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (34)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"Note:  To resolve sheets with less than desired minimum rows, assume that slightly less than half of the other sheets could give up a row."]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-35},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (35)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-36},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (36)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-37},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (37)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-38},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (38)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-39},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (39)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-40},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (40)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-41},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (41)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-42},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (42)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-43},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (43)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-44},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (44)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-45},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (45)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-46},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (46)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-47},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (47)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-48},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (48)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-49},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (49)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-50},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (50)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":120},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]