{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["PipelinesTable","CSV data"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"PipelinesTable","index":0,"n_rows":55,"n_cols":79,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,"Note: You may have to click and drag symbols around to suit your design.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please feel free to manipulate the SS as required."]
[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,null,null,null,null,null,"Table for manipulating Pit numbers and locations ",null,null,null,null,null,null,null,null,null,null,null,"Table for manipulating Pit numbers and locations "]
[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,null,null,null,null,null,"in chart 1. Examples below",null,null,null,null,null,"mim IL",{"$f":"MIN(AA10:AA29)","v":13.65},null,null,null,null,"in chart 2. Examples below",null,null,null,null,null,"min IL",{"$f":"MIN(AJ10:AJ29)","v":13.65},null,null,null,"Table to set the bounds ",null,null,null,null,null,null,"Table to set the bounds "]
[null,"Pipeid","us","ds","flow","grade","num","dia","capacity","vel","recth","rectw","SL","cover","length","usil","dsil","ponding","grate","pit","depth","funnel",null,{"$f":"CONCATENATE(\"LINE\",\" \",X8)","v":"LINE 1"},null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"LINE\",\" \",AG8)","v":"LINE 2"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"LINE\",\" \",$AU$8)","v":"LINE 1"},{"$f":"CONCATENATE(\"LINE\",\" \",$AU$8)","v":"LINE 1"},"cum","increment for","Pit Ht position","Dia","Grade","mid ","dia Ht position","Gde Ht position","Length ht",null,{"$f":"CONCATENATE(\"LINE\",\" \",$BG$8)","v":"LINE 2"},{"$f":"CONCATENATE(\"LINE\",\" \",$BG$8)","v":"LINE 2"},"Cum","increment for","PitHt position","Dia","Grade","mid ","Dia Ht position","Gde Ht ","Length",null,"of the chart 1",null,null,null,null,null,null,"of the chart 2"]
[null,"ID","Pt","Pt","(L/s)","1:?","Pipes","Dia(mm)","L/s","Vel(m/s)","Ht(mm)","Width(mm)","u/s(m)","U/S (mm)","(m)","IL","IL","Depth(mm)","side(mm)","size(mm)","to u/s IL(mm)","Length(mm)",null,"Points","length","sum lgths","IL","SL","grade","Dia",null,null,"Points","length","sum lgths","IL","SL","grade","Dia",null,null,null,null,null,null,"length","Points","length","these formulas"," on chart(m)",null,null,"distance"," on chart(m)"," on chart(m)","on chart1",null,"length","Points","length","these formulas"," on chart(m)",null,null,null," on chart(m)"," on chart","Height",null,"AXIS","Y","X",null,null,null,null,"AXIS","Y","X"]
[null,"Pipeid1",1,"GP1",8.5,10,1,100,27.9,1.1000000000000001,null,null,22,300,20,21.6,19.600000000000001,null,null,null,0.4,160,null,1,0,0,{"$f":"IF(X8=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X8,$C$8:$Q$53,14,FALSE),AA7))","v":21.6},{"$f":"IF(X8=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X8,$C$8:$Q$46,11,FALSE), \"\"))","v":22},{"$f":"_xlfn.IFNA(VLOOKUP($X8,$C$8:$Q$46,4,FALSE), #N/A)","v":10},{"$f":"_xlfn.IFNA(VLOOKUP($X8,$C$8:$Q$46,6,FALSE), #N/A)","v":100},null,null,2,0,0,{"$f":"IF(AG8=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG8,$C$8:$Q$53,14,FALSE),AJ7))","v":20.61},{"$f":"IF(AG8=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG8,$C$8:$Q$46,11,FALSE), \"\"))","v":21},{"$f":"_xlfn.IFNA(VLOOKUP($AG8,$C$8:$Q$46,4,FALSE),#N/A)","v":25},{"$f":"_xlfn.IFNA(VLOOKUP($AG8,$C$8:$Q$46,6,FALSE), #N/A)","v":90},null,null,null,null,null,null,{"$f":"CONCATENATE(\"Length=\",AV9-AV8,\"m\")","v":"Length=20m"},{"$f":"IF(OFFSET($X$8,AW8,0) = \"\",#N/A,OFFSET($X$8,AW8,0))","v":1},{"$f":"IF(AU8 = AU7,#N/A,OFFSET($Z$8,AW8,0))","v":0},0,{"$f":"BS9","v":12.5},{"$f":"IF($AV8<>\"\",CONCATENATE(\"Dia\",\"\",OFFSET($AD$8,$AW8,0)),#N/A)","v":"Dia100"},{"$f":"IF($AY8<>\"#N/A\",CONCATENATE(\"1:\",OFFSET($AC$8,$AW8,0)),\"#N/A\")","v":"1:10"},{"$f":"(AV9-AV8)/2 + AV8","v":10},{"$f":"BB5-0.2","v":13.450000000000001},{"$f":"BB8-0.3","v":13.15},{"$f":"BC8-0.3","v":12.85},null,{"$f":"CONCATENATE(\"Length=\",BH9-BH8,\"m\")","v":"Length=25m"},{"$f":"IF(OFFSET($AG$8,BI8,0) = \"\",#N/A,OFFSET($AG$8,BI8,0))","v":2},{"$f":"IF(OFFSET($AG$8,BI8,0) = \"\",#N/A,OFFSET(AI$8,BI8,0))","v":0},0,{"$f":"BZ9","v":12.5},{"$f":"IF($BH8<>\"\",CONCATENATE(\"Dia\",\" \",OFFSET($AM$8,$BI8,0)),\"#N/A\")","v":"Dia 90"},{"$f":"IF($BK8<>\"\",CONCATENATE(\"1:\",OFFSET($AL$8,$BI8,0)),\"\")","v":"1:25"},{"$f":"(BH9-BH8)/2 + BH8","v":12.5},{"$f":"BN5-0.2","v":13.450000000000001},{"$f":"BN8-0.3","v":13.15},{"$f":"BO8-0.3","v":12.85},null,"Max",{"$f":"ROUNDUP(MAX(AB8:AB29),0)+0.5","v":22.5},{"$f":"MAX(IF(ISNUMBER($Z$8:$Z$29),($Z$8:$Z$29)))+5","v":150},null,null,null,null,"Max",{"$f":"ROUNDUP(MAX(AK8:AK29),0)+0.5","v":21.5},{"$f":"MAX(IF(ISNUMBER($BH$8:$BH$29),($BH$8:$BH$29)))+5","v":155}]
[null,"Pipeid2",2,"GP1",3.26,25,1,90,12.92,0.5,null,null,21,300,25,20.61,19.61,null,null,null,0.39,36,null,{"$f":"IF(ISNA(VLOOKUP(X8,$C$8:$V$53,2,FALSE)),\"#N/A\",VLOOKUP(X8,$C$8:$V$53,2,FALSE))","v":"GP1"},{"$f":"IF(ISNA(VLOOKUP(X8,$C$8:$V$53,13,FALSE)),\"\",VLOOKUP(X8,$C$8:$V$53,13,FALSE))","v":20},{"$f":"IF(AND(ISNUMBER(Y9)),Y9,0)","v":20},{"$f":"IF(ISNA(VLOOKUP(X8,$C$8:$Q$53,15,FALSE)), AA8, VLOOKUP(X8,$C$8:$Q$53,15,FALSE))","v":19.600000000000001},{"$f":"IF(X9=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X9,$C$8:$Q$46,11,FALSE), $G$47))","v":20},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(AG8,$C$8:$V$53,2,FALSE)),\"#N/A\",VLOOKUP(AG8,$C$8:$V$53,2,FALSE))","v":"GP1"},{"$f":"IF(ISNA(VLOOKUP(AG8,$C$8:$V$53,13,FALSE)),\"\",VLOOKUP(AG8,$C$8:$V$53,13,FALSE))","v":25},{"$f":"IF(AND(ISNUMBER(AH9)),AH9,0)","v":25},{"$f":"IF(ISNA(VLOOKUP(AG8,$C$8:$Q$53,15,FALSE)), AJ8, VLOOKUP(AG8,$C$8:$Q$53,15,FALSE))","v":19.61},{"$f":"IF(AG9=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG9,$C$8:$Q$46,11,FALSE), $G$47))","v":20},null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Length=\",AV10-AV9,\"m\")","v":"Length=30m"},{"$f":"IF(OFFSET($X$8,AW9,0) = \"\",#N/A,OFFSET($X$8,AW9,0))","v":"GP1"},{"$f":"IF(AU9 = AU8,#N/A,OFFSET($Z$8,AW9,0))","v":20},1,{"$f":"AX8","v":12.5},{"$f":"IF($AV9<>\"\",CONCATENATE(\"Dia\",\"\",OFFSET($AD$8,$AW9+1,0)),#N/A)","v":"Dia100"},{"$f":"IF($AY9<>\"#N/A\",CONCATENATE(\"1:\",OFFSET($AC$8,$AW9+1,0)),\"#N/A\")","v":"1:10"},{"$f":"(AV10-AV9)/2 + AV9","v":35},{"$f":"BB8","v":13.450000000000001},{"$f":"BC8","v":13.15},{"$f":"BD8","v":12.85},null,{"$f":"CONCATENATE(\"Length=\",BH10-BH9,\"m\")","v":"Length=30m"},{"$f":"IF(OFFSET($AG$8,BI9,0) = \"\",#N/A,OFFSET($AG$8,BI9,0))","v":"GP1"},{"$f":"IF(OFFSET($AG$8,BI9,0) = \"\",#N/A,OFFSET(AI$8,BI9,0))","v":25},1,{"$f":"BJ8","v":12.5},{"$f":"IF($BH9<>\"\",CONCATENATE(\"Dia\",\" \",OFFSET($AM$8,$BI9+1,0)),#N/A)","v":"Dia 100"},{"$f":"IF($BK9<>\"\",CONCATENATE(\"1:\",OFFSET($AL$8,$BI9+1,0)),\"\")","v":"1:10"},{"$f":"(BH10-BH9)/2 + BH9","v":40},{"$f":"BN8","v":13.450000000000001},{"$f":"BO8","v":13.15},{"$f":"BP8","v":12.85},null,"Min",{"$f":"FLOOR(MIN(AA8:AA29),0.5)-1","v":12.5},0,null,null,null,null,"Min",{"$f":"FLOOR(MIN(AJ10:AJ29),0.5)-1","v":12.5},0]
[null,"Pipeid3","GP1","GP2",11.76,10,1,100,27.9,1.5,null,null,20,300,30,19.579999999999998,16.579999999999998,null,null,null,0.42,null,null,{"$f":"IF($X9=$G$55,\"#N/A\",X9)","v":"GP1"},0,{"$f":"IF(X10=\"#N/A\",#N/A,Z9)","v":20},{"$f":"IF(X10=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X10,$C$8:$Q$53,14,FALSE),AA9))","v":19.579999999999998},{"$f":"IF(X10=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X10,$C$8:$Q$46,11,FALSE), \"\"))","v":20},{"$f":"_xlfn.IFNA(VLOOKUP($X10,$C$8:$Q$46,4,FALSE), #N/A)","v":10},{"$f":"_xlfn.IFNA(VLOOKUP($X10,$C$8:$Q$46,6,FALSE), #N/A)","v":100},null,null,{"$f":"IF($AG9=$G$55,\"#N/A\",AG9)","v":"GP1"},0,{"$f":"IF(AG10=\"#N/A\",#N/A,AI9)","v":25},{"$f":"IF(AG10=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG10,$C$8:$Q$53,14,FALSE),AJ9))","v":19.579999999999998},{"$f":"IF(AG10=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG10,$C$8:$Q$46,11,FALSE), \"\"))","v":20},{"$f":"_xlfn.IFNA(VLOOKUP($AG10,$C$8:$Q$46,4,FALSE),#N/A)","v":10},{"$f":"_xlfn.IFNA(VLOOKUP($AG10,$C$8:$Q$46,6,FALSE), #N/A)","v":100},null,null,null,null,null,null,"Length=45m","GP2",50,{"$f":"AW9+2","v":3},{"$f":"AX9","v":12.5},{"$f":"IF($AV10<>\"\",CONCATENATE(\"Dia\",\"\",OFFSET($AD$8,$AW10+1,0)),#N/A)","v":"Dia150"},{"$f":"IF($AY10<>\"#N/A\",CONCATENATE(\"1:\",OFFSET($AC$8,$AW10+1,0)),\"#N/A\")","v":"1:45.92"},72.5,{"$f":"BB9","v":13.450000000000001},13.15,{"$f":"BD9","v":12.85},null,{"$f":"CONCATENATE(\"Length=\",BH11-BH10,\"m\")","v":"Length=45m"},"GP2",{"$f":"IF(OFFSET($AG$8,BI10,0) = \"\",#N/A,OFFSET(AI$8,BI10,0))","v":55},{"$f":"BI9+2","v":3},{"$f":"BJ9","v":12.5},{"$f":"IF($BH10<>\"\",CONCATENATE(\"Dia\",\" \",OFFSET($AM$8,$BI10+1,0)),#N/A)","v":"Dia 150"},{"$f":"IF($BK10<>\"\",CONCATENATE(\"1:\",OFFSET($AL$8,$BI10+1,0)),\"\")","v":"1:45.92"},77.5,{"$f":"BN9","v":13.450000000000001},13.15,12.85,null,"tick",0.5,10,null,null,null,null,"tick",0.5,10]
[null,"Pipeid4",3,"GP3",10.25,null,null,"NoPipe",null,null,null,null,null,null,null,null,null,300,"119_A",null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(X10,$C$8:$V$53,2,FALSE)),\"#N/A\",VLOOKUP(X10,$C$8:$V$53,2,FALSE))","v":"GP2"},{"$f":"IF(ISNA(VLOOKUP(X10,$C$8:$V$53,13,FALSE)),\"\",VLOOKUP(X10,$C$8:$V$53,13,FALSE))","v":30},{"$f":"IF(AND(ISNUMBER(Z9),ISNUMBER(Y11)),Z9+Y11,Z10)","v":50},{"$f":"IF(ISNA(VLOOKUP(X10,$C$8:$Q$53,15,FALSE)), AA10, VLOOKUP(X10,$C$8:$Q$53,15,FALSE))","v":16.579999999999998},{"$f":"IF(X11=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X11,$C$8:$Q$46,11,FALSE), $G$47))","v":17},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(AG10,$C$8:$V$53,2,FALSE)),\"#N/A\",VLOOKUP(AG10,$C$8:$V$53,2,FALSE))","v":"GP2"},{"$f":"IF(ISNA(VLOOKUP(AG10,$C$8:$V$53,13,FALSE)),\"\",VLOOKUP(AG10,$C$8:$V$53,13,FALSE))","v":30},{"$f":"IF(AND(ISNUMBER(AI9),ISNUMBER(AH11)),AI9+AH11,AI10)","v":55},{"$f":"IF(ISNA(VLOOKUP(AG10,$C$8:$Q$53,15,FALSE)), AJ10, VLOOKUP(AG10,$C$8:$Q$53,15,FALSE))","v":16.579999999999998},{"$f":"IF(AG11=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG11,$C$8:$Q$46,11,FALSE), $G$47))","v":17},null,null,null,null,null,null,null,null,"Length=50m","C",95,{"$f":"AW10+2","v":5},12.5,{"$f":"IF($AV11<>\"\",CONCATENATE(\"Dia\",\"\",OFFSET($AD$8,$AW11+1,0)),#N/A)","v":"Dia300"},"1:250",120,13.450000000000001,13.15,{"$f":"BD10","v":12.85},null,"Length=50m",{"$f":"IF(OFFSET($AG$8,BI11,0) = \"\",#N/A,OFFSET($AG$8,BI11,0))","v":"C"},100,{"$f":"BI10+2","v":5},12.5,"Dia 300","1:250",125,{"$f":"BN10","v":13.450000000000001},13.15,12.85]
[null,"Pipeid5","GP3","GP2",10.25,17.5,1,100,20.69,1.3,null,null,19,300,35,18.600000000000001,16.600000000000001,null,null,"350x350",0.4,null,null,{"$f":"IF($X11=$G$55,\"#N/A\",X11)","v":"GP2"},0,{"$f":"IF(X12=\"#N/A\",#N/A,Z11)","v":50},{"$f":"IF(X12=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X12,$C$8:$Q$53,14,FALSE),AA11))","v":16.53},{"$f":"IF(X12=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X12,$C$8:$Q$46,11,FALSE), \"\"))","v":17},{"$f":"_xlfn.IFNA(VLOOKUP($X12,$C$8:$Q$46,4,FALSE), #N/A)","v":45.92},{"$f":"_xlfn.IFNA(VLOOKUP($X12,$C$8:$Q$46,6,FALSE), #N/A)","v":150},null,null,{"$f":"IF($AG11=$G$55,\"#N/A\",AG11)","v":"GP2"},0,{"$f":"IF(AG12=\"#N/A\",#N/A,AI11)","v":55},{"$f":"IF(AG12=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG12,$C$8:$Q$53,14,FALSE),AJ11))","v":16.53},{"$f":"IF(AG12=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG12,$C$8:$Q$46,11,FALSE), \"\"))","v":17},{"$f":"_xlfn.IFNA(VLOOKUP($AG12,$C$8:$Q$46,4,FALSE),#N/A)","v":45.92},{"$f":"_xlfn.IFNA(VLOOKUP($AG12,$C$8:$Q$46,6,FALSE), #N/A)","v":150},null,null,null,null,null,null,{"$error":"#N/A"},"D",145,7,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},13.450000000000001,13.15,{"$f":"BD11","v":12.85},null,{"$error":"#N/A"},{"$f":"IF(OFFSET($AG$8,BI12,0) = \"\",#N/A,OFFSET($AG$8,BI12,0))","v":"D"},150,7,12.5,{"$f":"IF($BH12<>\"\",CONCATENATE(\"Dia\",\" \",OFFSET($AM$8,$BI12+1,0)),#N/A)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BN11","v":13.450000000000001},13.15,12.85]
[null,"Pipeid6",4,"GP4",11.39,null,null,"NoPipe",null,null,null,null,null,null,null,null,null,300,"126_A",null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(X12,$C$8:$V$53,2,FALSE)),\"#N/A\",VLOOKUP(X12,$C$8:$V$53,2,FALSE))","v":"C"},{"$f":"IF(ISNA(VLOOKUP(X12,$C$8:$V$53,13,FALSE)),\"\",VLOOKUP(X12,$C$8:$V$53,13,FALSE))","v":45},{"$f":"IF(AND(ISNUMBER(Z11),ISNUMBER(Y13)),Z11+Y13,Z12)","v":95},{"$f":"IF(ISNA(VLOOKUP(X12,$C$8:$Q$53,15,FALSE)), AA12, VLOOKUP(X12,$C$8:$Q$53,15,FALSE))","v":15.55},{"$f":"IF(X13=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X13,$C$8:$Q$46,11,FALSE), $G$47))","v":16},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(AG12,$C$8:$V$53,2,FALSE)),\"#N/A\",VLOOKUP(AG12,$C$8:$V$53,2,FALSE))","v":"C"},{"$f":"IF(ISNA(VLOOKUP(AG12,$C$8:$V$53,13,FALSE)),\"\",VLOOKUP(AG12,$C$8:$V$53,13,FALSE))","v":45},{"$f":"IF(AND(ISNUMBER(AI11),ISNUMBER(AH13)),AI11+AH13,AI12)","v":100},{"$f":"IF(ISNA(VLOOKUP(AG12,$C$8:$Q$53,15,FALSE)), AJ12, VLOOKUP(AG12,$C$8:$Q$53,15,FALSE))","v":15.55},{"$f":"IF(AG13=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG13,$C$8:$Q$46,11,FALSE), $G$47))","v":16},null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$f":"IF(OFFSET($X$8,AW13,0) = \"\",#N/A,OFFSET($X$8,AW13,0))","v":"#N/A"},{"$error":"#N/A"},9,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},13.450000000000001,13.15,{"$f":"BD12","v":12.85},null,{"$error":"#N/A"},{"$f":"IF(OFFSET($AG$8,BI13,0) = \"\",#N/A,OFFSET($AG$8,BI13,0))","v":"#N/A"},{"$error":"#N/A"},9,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BN12","v":13.450000000000001},13.15,12.85]
[null,"Pipeid7",5,"C",50,20,1,225,163.52000000000001,1.3,null,null,18,300,40,17.475000000000001,15.475,null,null,null,0.52500000000000002,null,null,{"$f":"IF($X13=$G$55,\"#N/A\",X13)","v":"C"},0,{"$f":"IF(X14=\"#N/A\",#N/A,Z13)","v":95},{"$f":"IF(X14=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X14,$C$8:$Q$53,14,FALSE),AA13))","v":13.85},{"$f":"IF(X14=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X14,$C$8:$Q$46,11,FALSE), \"\"))","v":16},{"$f":"_xlfn.IFNA(VLOOKUP($X14,$C$8:$Q$46,4,FALSE), #N/A)","v":250},{"$f":"_xlfn.IFNA(VLOOKUP($X14,$C$8:$Q$46,6,FALSE), #N/A)","v":300},null,null,{"$f":"IF($AG13=$G$55,\"#N/A\",AG13)","v":"C"},0,{"$f":"IF(AG14=\"#N/A\",#N/A,AI13)","v":100},{"$f":"IF(AG14=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG14,$C$8:$Q$53,14,FALSE),AJ13))","v":13.85},{"$f":"IF(AG14=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG14,$C$8:$Q$46,11,FALSE), \"\"))","v":16},{"$f":"_xlfn.IFNA(VLOOKUP($AG14,$C$8:$Q$46,4,FALSE),#N/A)","v":250},{"$f":"_xlfn.IFNA(VLOOKUP($AG14,$C$8:$Q$46,6,FALSE), #N/A)","v":300},null,null,null,null,null,null,{"$error":"#N/A"},"#N/A",{"$f":"IF(AU14 = AU13,#N/A,OFFSET($Z$8,AW14,0))","v":{"$error":"#N/A"}},11,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},13.450000000000001,13.15,{"$f":"BD13","v":12.85},null,{"$error":"#N/A"},{"$f":"IF(OFFSET($AG$8,BI14,0) = \"\",#N/A,OFFSET($AG$8,BI14,0))","v":"#N/A"},{"$error":"#N/A"},11,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BN13","v":13.450000000000001},13.15,12.85]
[null,"Pipeid8","GP2","C",22.01,45.92,1,150,36.04,1.2,null,null,17,300,45,16.53,15.55,null,null,null,0.47,null,null,{"$f":"IF(ISNA(VLOOKUP(X14,$C$8:$V$53,2,FALSE)),\"#N/A\",VLOOKUP(X14,$C$8:$V$53,2,FALSE))","v":"D"},{"$f":"IF(ISNA(VLOOKUP(X14,$C$8:$V$53,13,FALSE)),\"\",VLOOKUP(X14,$C$8:$V$53,13,FALSE))","v":50},{"$f":"IF(AND(ISNUMBER(Z13),ISNUMBER(Y15)),Z13+Y15,Z14)","v":145},{"$f":"IF(ISNA(VLOOKUP(X14,$C$8:$Q$53,15,FALSE)), AA14, VLOOKUP(X14,$C$8:$Q$53,15,FALSE))","v":13.65},{"$f":"IF(X15=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X15,$C$8:$Q$46,11,FALSE), $G$47))","v":14},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(AG14,$C$8:$V$53,2,FALSE)),\"#N/A\",VLOOKUP(AG14,$C$8:$V$53,2,FALSE))","v":"D"},{"$f":"IF(ISNA(VLOOKUP(AG14,$C$8:$V$53,13,FALSE)),\"\",VLOOKUP(AG14,$C$8:$V$53,13,FALSE))","v":50},{"$f":"IF(AND(ISNUMBER(AI13),ISNUMBER(AH15)),AI13+AH15,AI14)","v":150},{"$f":"IF(ISNA(VLOOKUP(AG14,$C$8:$Q$53,15,FALSE)), AJ14, VLOOKUP(AG14,$C$8:$Q$53,15,FALSE))","v":13.65},{"$f":"IF(AG15=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG15,$C$8:$Q$46,11,FALSE), $G$47))","v":14},null,null,null,null,null,null,null,null,{"$error":"#N/A"},"#N/A",{"$f":"IF(AU15 = AU14,#N/A,OFFSET($Z$8,AW15,0))","v":{"$error":"#N/A"}},13,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},13.450000000000001,13.15,{"$f":"BD14","v":12.85},null,{"$error":"#N/A"},"#N/A",{"$error":"#N/A"},13,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BN14","v":13.450000000000001},13.15,12.85]
[null,"Pipeid9","C","D",83.4,250,1,300,90.32,1.2,null,null,16,300,50,13.85,13.65,null,null,null,2.15,null,null,{"$f":"IF($X15=$G$55,\"#N/A\",X15)","v":"#N/A"},0,{"$f":"IF(X16=\"#N/A\",#N/A,Z15)","v":{"$error":"#N/A"}},{"$f":"IF(X16=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X16,$C$8:$Q$53,14,FALSE),AA15))","v":""},{"$f":"IF(X16=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X16,$C$8:$Q$46,11,FALSE), \"\"))","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($X16,$C$8:$Q$46,4,FALSE), #N/A)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFNA(VLOOKUP($X16,$C$8:$Q$46,6,FALSE), #N/A)","v":{"$error":"#N/A"}},null,null,{"$f":"IF($AG15=$G$55,\"#N/A\",AG15)","v":"#N/A"},0,{"$f":"IF(AG16=\"#N/A\",#N/A,AI15)","v":{"$error":"#N/A"}},{"$f":"IF(AG16=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG16,$C$8:$Q$53,14,FALSE),AJ15))","v":""},{"$f":"IF(AG16=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG16,$C$8:$Q$46,11,FALSE), \"\"))","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($AG16,$C$8:$Q$46,4,FALSE),#N/A)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFNA(VLOOKUP($AG16,$C$8:$Q$46,6,FALSE), #N/A)","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$error":"#N/A"},"#N/A",{"$error":"#N/A"},15,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},13.450000000000001,13.15,{"$f":"BD15","v":12.85},null,{"$error":"#N/A"},"#N/A",{"$error":"#N/A"},15,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BN15","v":13.450000000000001},13.15,12.85]
[null,"Pipeid10","GP4","C",11.39,100,1,150,23.65,0.6,null,null,15,300,55,14.55,14,null,null,"350x350",0.45,null,null,{"$f":"IF(ISNA(VLOOKUP(X16,$C$8:$V$53,2,FALSE)),\"#N/A\",VLOOKUP(X16,$C$8:$V$53,2,FALSE))","v":"#N/A"},{"$f":"IF(ISNA(VLOOKUP(X16,$C$8:$V$53,13,FALSE)),\"\",VLOOKUP(X16,$C$8:$V$53,13,FALSE))","v":""},{"$f":"IF(AND(ISNUMBER(Z15),ISNUMBER(Y17)),Z15+Y17,Z16)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(X16,$C$8:$Q$53,15,FALSE)), AA16, VLOOKUP(X16,$C$8:$Q$53,15,FALSE))","v":""},{"$f":"IF(X17=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X17,$C$8:$Q$46,11,FALSE), $G$47))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(AG16,$C$8:$V$53,2,FALSE)),\"#N/A\",VLOOKUP(AG16,$C$8:$V$53,2,FALSE))","v":"#N/A"},{"$f":"IF(ISNA(VLOOKUP(AG16,$C$8:$V$53,13,FALSE)),\"\",VLOOKUP(AG16,$C$8:$V$53,13,FALSE))","v":""},{"$f":"IF(AND(ISNUMBER(AI15),ISNUMBER(AH17)),AI15+AH17,AI16)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(AG16,$C$8:$Q$53,15,FALSE)), AJ16, VLOOKUP(AG16,$C$8:$Q$53,15,FALSE))","v":""},{"$f":"IF(AG17=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG17,$C$8:$Q$46,11,FALSE), $G$47))","v":""},null,null,null,null,null,null,null,null,{"$error":"#N/A"},"#N/A",{"$error":"#N/A"},17,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},13.450000000000001,13.15,{"$f":"BD16","v":12.85},null,{"$error":"#N/A"},"#N/A",{"$error":"#N/A"},17,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BN16","v":13.450000000000001},13.15,12.85]
[null,"Pipeid11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($X17=$G$55,\"#N/A\",X17)","v":"#N/A"},0,{"$f":"IF(X18=\"#N/A\",#N/A,Z17)","v":{"$error":"#N/A"}},{"$f":"IF(X18=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X18,$C$8:$Q$53,14,FALSE),AA17))","v":""},{"$f":"IF(X18=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X18,$C$8:$Q$46,11,FALSE), \"\"))","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($X18,$C$8:$Q$46,4,FALSE), #N/A)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFNA(VLOOKUP($X18,$C$8:$Q$46,6,FALSE), #N/A)","v":{"$error":"#N/A"}},null,null,{"$f":"IF($AG17=$G$55,\"#N/A\",AG17)","v":"#N/A"},0,{"$f":"IF(AG18=\"#N/A\",#N/A,AI17)","v":{"$error":"#N/A"}},{"$f":"IF(AG18=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG18,$C$8:$Q$53,14,FALSE),AJ17))","v":""},{"$f":"IF(AG18=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG18,$C$8:$Q$46,11,FALSE), \"\"))","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($AG18,$C$8:$Q$46,4,FALSE),#N/A)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFNA(VLOOKUP($AG18,$C$8:$Q$46,6,FALSE), #N/A)","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$error":"#N/A"},"#N/A",{"$error":"#N/A"},19,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},13.450000000000001,13.15,{"$f":"BD17","v":12.85},null,{"$error":"#N/A"},"#N/A",{"$error":"#N/A"},19,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BN17","v":13.450000000000001},13.15,12.85]
[null,"Pipeid12",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(X18,$C$8:$V$53,2,FALSE)),\"#N/A\",VLOOKUP(X18,$C$8:$V$53,2,FALSE))","v":"#N/A"},{"$f":"IF(ISNA(VLOOKUP(X18,$C$8:$V$53,13,FALSE)),\"\",VLOOKUP(X18,$C$8:$V$53,13,FALSE))","v":""},{"$f":"IF(AND(ISNUMBER(Z17),ISNUMBER(Y19)),Z17+Y19,Z18)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(X18,$C$8:$Q$53,15,FALSE)), AA18, VLOOKUP(X18,$C$8:$Q$53,15,FALSE))","v":""},{"$f":"IF(X19=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X19,$C$8:$Q$46,11,FALSE), $G$47))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(AG18,$C$8:$V$53,2,FALSE)),\"#N/A\",VLOOKUP(AG18,$C$8:$V$53,2,FALSE))","v":"#N/A"},{"$f":"IF(ISNA(VLOOKUP(AG18,$C$8:$V$53,13,FALSE)),\"\",VLOOKUP(AG18,$C$8:$V$53,13,FALSE))","v":""},{"$f":"IF(AND(ISNUMBER(AI17),ISNUMBER(AH19)),AI17+AH19,AI18)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(AG18,$C$8:$Q$53,15,FALSE)), AJ18, VLOOKUP(AG18,$C$8:$Q$53,15,FALSE))","v":""},{"$f":"IF(AG19=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG19,$C$8:$Q$46,11,FALSE), $G$47))","v":""},null,null,null,null,null,null,null,null,{"$error":"#N/A"},"#N/A",{"$error":"#N/A"},21,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},13.450000000000001,13.15,{"$f":"BD18","v":12.85},null,{"$error":"#N/A"},"#N/A",{"$error":"#N/A"},21,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BN18","v":13.450000000000001},13.15,12.85]
[null,"Pipeid13",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($X19=$G$55,\"#N/A\",X19)","v":"#N/A"},0,{"$f":"IF(X20=\"#N/A\",#N/A,Z19)","v":{"$error":"#N/A"}},{"$f":"IF(X20=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X20,$C$8:$Q$53,14,FALSE),AA19))","v":""},{"$f":"IF(X20=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X20,$C$8:$Q$46,11,FALSE), \"\"))","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($X20,$C$8:$Q$46,4,FALSE), #N/A)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFNA(VLOOKUP($X20,$C$8:$Q$46,6,FALSE), #N/A)","v":{"$error":"#N/A"}},null,null,{"$f":"IF($AG19=$G$55,\"#N/A\",AG19)","v":"#N/A"},0,{"$f":"IF(AG20=\"#N/A\",#N/A,AI19)","v":{"$error":"#N/A"}},{"$f":"IF(AG20=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG20,$C$8:$Q$53,14,FALSE),AJ19))","v":""},{"$f":"IF(AG20=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG20,$C$8:$Q$46,11,FALSE), \"\"))","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($AG20,$C$8:$Q$46,4,FALSE),#N/A)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFNA(VLOOKUP($AG20,$C$8:$Q$46,6,FALSE), #N/A)","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},23,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},13.450000000000001,13.15,{"$f":"BD19","v":12.85},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},23,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BN19","v":13.450000000000001},13.15,12.85]
[null,"Pipeid14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(X20,$C$8:$V$53,2,FALSE)),\"#N/A\",VLOOKUP(X20,$C$8:$V$53,2,FALSE))","v":"#N/A"},{"$f":"IF(ISNA(VLOOKUP(X20,$C$8:$V$53,13,FALSE)),\"\",VLOOKUP(X20,$C$8:$V$53,13,FALSE))","v":""},{"$f":"IF(AND(ISNUMBER(Z19),ISNUMBER(Y21)),Z19+Y21,Z20)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(X20,$C$8:$Q$53,15,FALSE)), AA20, VLOOKUP(X20,$C$8:$Q$53,15,FALSE))","v":""},{"$f":"IF(X21=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X21,$C$8:$Q$46,11,FALSE), $G$47))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(AG20,$C$8:$V$53,2,FALSE)),\"#N/A\",VLOOKUP(AG20,$C$8:$V$53,2,FALSE))","v":"#N/A"},{"$f":"IF(ISNA(VLOOKUP(AG20,$C$8:$V$53,13,FALSE)),\"\",VLOOKUP(AG20,$C$8:$V$53,13,FALSE))","v":""},{"$f":"IF(AND(ISNUMBER(AI19),ISNUMBER(AH21)),AI19+AH21,AI20)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(AG20,$C$8:$Q$53,15,FALSE)), AJ20, VLOOKUP(AG20,$C$8:$Q$53,15,FALSE))","v":""},{"$f":"IF(AG21=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG21,$C$8:$Q$46,11,FALSE), $G$47))","v":""},null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},25,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},13.450000000000001,13.15,{"$f":"BD20","v":12.85},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},25,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BN20","v":13.450000000000001},13.15,12.85]
[null,"Pipeid15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($X21=$G$55,\"#N/A\",X21)","v":"#N/A"},0,{"$f":"IF(X22=\"#N/A\",#N/A,Z21)","v":{"$error":"#N/A"}},{"$f":"IF(X22=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X22,$C$8:$Q$53,14,FALSE),AA21))","v":""},{"$f":"IF(X22=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X22,$C$8:$Q$46,11,FALSE), \"\"))","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($X22,$C$8:$Q$46,4,FALSE), #N/A)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFNA(VLOOKUP($X22,$C$8:$Q$46,6,FALSE), #N/A)","v":{"$error":"#N/A"}},null,null,{"$f":"IF($AG21=$G$55,\"#N/A\",AG21)","v":"#N/A"},0,{"$f":"IF(AG22=\"#N/A\",#N/A,AI21)","v":{"$error":"#N/A"}},{"$f":"IF(AG22=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG22,$C$8:$Q$53,14,FALSE),AJ21))","v":""},{"$f":"IF(AG22=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG22,$C$8:$Q$46,11,FALSE), \"\"))","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($AG22,$C$8:$Q$46,4,FALSE),#N/A)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFNA(VLOOKUP($AG22,$C$8:$Q$46,6,FALSE), #N/A)","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},27,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},13.450000000000001,13.15,{"$f":"BD21","v":12.85},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},27,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BN21","v":13.450000000000001},13.15,12.85]
[null,"Pipeid16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(X22,$C$8:$V$53,2,FALSE)),\"#N/A\",VLOOKUP(X22,$C$8:$V$53,2,FALSE))","v":"#N/A"},{"$f":"IF(ISNA(VLOOKUP(X22,$C$8:$V$53,13,FALSE)),\"\",VLOOKUP(X22,$C$8:$V$53,13,FALSE))","v":""},{"$f":"IF(AND(ISNUMBER(Z21),ISNUMBER(Y23)),Z21+Y23,Z22)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(X22,$C$8:$Q$53,15,FALSE)), AA22, VLOOKUP(X22,$C$8:$Q$53,15,FALSE))","v":""},{"$f":"IF(X23=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X23,$C$8:$Q$46,11,FALSE), $G$47))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(AG22,$C$8:$V$53,2,FALSE)),\"#N/A\",VLOOKUP(AG22,$C$8:$V$53,2,FALSE))","v":"#N/A"},{"$f":"IF(ISNA(VLOOKUP(AG22,$C$8:$V$53,13,FALSE)),\"\",VLOOKUP(AG22,$C$8:$V$53,13,FALSE))","v":""},{"$f":"IF(AND(ISNUMBER(AI21),ISNUMBER(AH23)),AI21+AH23,AI22)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(AG22,$C$8:$Q$53,15,FALSE)), AJ22, VLOOKUP(AG22,$C$8:$Q$53,15,FALSE))","v":""},{"$f":"IF(AG23=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG23,$C$8:$Q$46,11,FALSE), $G$47))","v":""},null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},29,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},13.450000000000001,13.15,{"$f":"BD22","v":12.85},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},29,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BN22","v":13.450000000000001},13.15,12.85]
[null,"Pipeid17",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($X23=$G$55,\"#N/A\",X23)","v":"#N/A"},0,{"$f":"IF(X24=\"#N/A\",#N/A,Z23)","v":{"$error":"#N/A"}},{"$f":"IF(X24=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X24,$C$8:$Q$53,14,FALSE),AA23))","v":""},{"$f":"IF(X24=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X24,$C$8:$Q$46,11,FALSE), \"\"))","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($X24,$C$8:$Q$46,4,FALSE), #N/A)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFNA(VLOOKUP($X24,$C$8:$Q$46,6,FALSE), #N/A)","v":{"$error":"#N/A"}},null,null,{"$f":"IF($AG23=$G$55,\"#N/A\",AG23)","v":"#N/A"},0,{"$f":"IF(AG24=\"#N/A\",#N/A,AI23)","v":{"$error":"#N/A"}},{"$f":"IF(AG24=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG24,$C$8:$Q$53,14,FALSE),AJ23))","v":""},{"$f":"IF(AG24=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG24,$C$8:$Q$46,11,FALSE), \"\"))","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($AG24,$C$8:$Q$46,4,FALSE),#N/A)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFNA(VLOOKUP($AG24,$C$8:$Q$46,6,FALSE), #N/A)","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},31,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},13.450000000000001,13.15,{"$f":"BD23","v":12.85},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},31,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BN23","v":13.450000000000001},13.15,12.85]
[null,"Pipeid18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(X24,$C$8:$V$53,2,FALSE)),\"#N/A\",VLOOKUP(X24,$C$8:$V$53,2,FALSE))","v":"#N/A"},{"$f":"IF(ISNA(VLOOKUP(X24,$C$8:$V$53,13,FALSE)),\"\",VLOOKUP(X24,$C$8:$V$53,13,FALSE))","v":""},{"$f":"IF(AND(ISNUMBER(Z23),ISNUMBER(Y25)),Z23+Y25,Z24)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(X24,$C$8:$Q$53,15,FALSE)), AA24, VLOOKUP(X24,$C$8:$Q$53,15,FALSE))","v":""},{"$f":"IF(X25=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X25,$C$8:$Q$46,11,FALSE), $G$47))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(AG24,$C$8:$V$53,2,FALSE)),\"#N/A\",VLOOKUP(AG24,$C$8:$V$53,2,FALSE))","v":"#N/A"},{"$f":"IF(ISNA(VLOOKUP(AG24,$C$8:$V$53,13,FALSE)),\"\",VLOOKUP(AG24,$C$8:$V$53,13,FALSE))","v":""},{"$f":"IF(AND(ISNUMBER(AI23),ISNUMBER(AH25)),AI23+AH25,AI24)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(AG24,$C$8:$Q$53,15,FALSE)), AJ24, VLOOKUP(AG24,$C$8:$Q$53,15,FALSE))","v":""},{"$f":"IF(AG25=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG25,$C$8:$Q$46,11,FALSE), $G$47))","v":""},null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},33,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},13.450000000000001,13.15,{"$f":"BD24","v":12.85},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},33,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BN24","v":13.450000000000001},13.15,12.85]
[null,"Pipeid19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($X25=$G$55,\"#N/A\",X25)","v":"#N/A"},0,{"$f":"IF(X26=\"#N/A\",#N/A,Z25)","v":{"$error":"#N/A"}},{"$f":"IF(X26=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X26,$C$8:$Q$53,14,FALSE),AA25))","v":""},{"$f":"IF(X26=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X26,$C$8:$Q$46,11,FALSE), \"\"))","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($X26,$C$8:$Q$46,4,FALSE), #N/A)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFNA(VLOOKUP($X26,$C$8:$Q$46,6,FALSE), #N/A)","v":{"$error":"#N/A"}},null,null,{"$f":"IF($AG25=$G$55,\"#N/A\",AG25)","v":"#N/A"},0,{"$f":"IF(AG26=\"#N/A\",#N/A,AI25)","v":{"$error":"#N/A"}},{"$f":"IF(AG26=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG26,$C$8:$Q$53,14,FALSE),AJ25))","v":""},{"$f":"IF(AG26=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG26,$C$8:$Q$46,11,FALSE), \"\"))","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($AG26,$C$8:$Q$46,4,FALSE),#N/A)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFNA(VLOOKUP($AG26,$C$8:$Q$46,6,FALSE), #N/A)","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},35,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},13.450000000000001,13.15,{"$f":"BD25","v":12.85},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},35,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BN25","v":13.450000000000001},13.15,12.85]
[null,"Pipeid20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(X26,$C$8:$V$53,2,FALSE)),\"#N/A\",VLOOKUP(X26,$C$8:$V$53,2,FALSE))","v":"#N/A"},{"$f":"IF(ISNA(VLOOKUP(X26,$C$8:$V$53,13,FALSE)),\"\",VLOOKUP(X26,$C$8:$V$53,13,FALSE))","v":""},{"$f":"IF(AND(ISNUMBER(Z25),ISNUMBER(Y27)),Z25+Y27,Z26)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(X26,$C$8:$Q$53,15,FALSE)), AA26, VLOOKUP(X26,$C$8:$Q$53,15,FALSE))","v":""},{"$f":"IF(X27=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X27,$C$8:$Q$46,11,FALSE), $G$47))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(AG26,$C$8:$V$53,2,FALSE)),\"#N/A\",VLOOKUP(AG26,$C$8:$V$53,2,FALSE))","v":"#N/A"},{"$f":"IF(ISNA(VLOOKUP(AG26,$C$8:$V$53,13,FALSE)),\"\",VLOOKUP(AG26,$C$8:$V$53,13,FALSE))","v":""},{"$f":"IF(AND(ISNUMBER(AI25),ISNUMBER(AH27)),AI25+AH27,AI26)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(AG26,$C$8:$Q$53,15,FALSE)), AJ26, VLOOKUP(AG26,$C$8:$Q$53,15,FALSE))","v":""},{"$f":"IF(AG27=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG27,$C$8:$Q$46,11,FALSE), $G$47))","v":""},null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},37,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},13.450000000000001,13.15,{"$f":"BD26","v":12.85},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},37,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BN26","v":13.450000000000001},13.15,12.85]
[null,"Pipeid21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($X27=$G$55,\"#N/A\",X27)","v":"#N/A"},0,{"$f":"IF(X28=\"#N/A\",#N/A,Z27)","v":{"$error":"#N/A"}},{"$f":"IF(X28=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X28,$C$8:$Q$53,14,FALSE),AA27))","v":""},{"$f":"IF(X28=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X28,$C$8:$Q$46,11,FALSE), \"\"))","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($X28,$C$8:$Q$46,4,FALSE), #N/A)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFNA(VLOOKUP($X28,$C$8:$Q$46,6,FALSE), #N/A)","v":{"$error":"#N/A"}},null,null,{"$f":"IF($AG27=$G$55,\"#N/A\",AG27)","v":"#N/A"},0,{"$f":"IF(AG28=\"#N/A\",#N/A,AI27)","v":{"$error":"#N/A"}},{"$f":"IF(AG28=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG28,$C$8:$Q$53,14,FALSE),AJ27))","v":""},{"$f":"IF(AG28=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG28,$C$8:$Q$46,11,FALSE), \"\"))","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($AG28,$C$8:$Q$46,4,FALSE),#N/A)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFNA(VLOOKUP($AG28,$C$8:$Q$46,6,FALSE), #N/A)","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},39,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},13.450000000000001,13.15,{"$f":"BD27","v":12.85},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},39,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BN27","v":13.450000000000001},13.15,12.85]
[null,"Pipeid22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(X28,$C$8:$V$53,2,FALSE)),\"#N/A\",VLOOKUP(X28,$C$8:$V$53,2,FALSE))","v":"#N/A"},{"$f":"IF(ISNA(VLOOKUP(X28,$C$8:$V$53,13,FALSE)),\"\",VLOOKUP(X28,$C$8:$V$53,13,FALSE))","v":""},{"$f":"IF(AND(ISNUMBER(Z27),ISNUMBER(Y29)),Z27+Y29,Z28)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(X28,$C$8:$Q$53,15,FALSE)), AA28, VLOOKUP(X28,$C$8:$Q$53,15,FALSE))","v":""},{"$f":"IF(X29=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(X29,$C$8:$Q$46,11,FALSE), $G$47))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(AG28,$C$8:$V$53,2,FALSE)),\"#N/A\",VLOOKUP(AG28,$C$8:$V$53,2,FALSE))","v":"#N/A"},{"$f":"IF(ISNA(VLOOKUP(AG28,$C$8:$V$53,13,FALSE)),\"\",VLOOKUP(AG28,$C$8:$V$53,13,FALSE))","v":""},{"$f":"IF(AND(ISNUMBER(AI27),ISNUMBER(AH29)),AI27+AH29,AI28)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(VLOOKUP(AG28,$C$8:$Q$53,15,FALSE)), AJ28, VLOOKUP(AG28,$C$8:$Q$53,15,FALSE))","v":""},{"$f":"IF(AG29=\"#N/A\",\"\",_xlfn.IFNA(VLOOKUP(AG29,$C$8:$Q$46,11,FALSE), $G$47))","v":""},null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},41,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},13.450000000000001,13.15,{"$f":"BD28","v":12.85},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},41,12.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"BN28","v":13.450000000000001},13.15,12.85]
[null,"Pipeid23"]
[null,"Pipeid24"]
[null,"Pipeid25"]
[null,"Pipeid26"]
[null,"Pipeid27"]
[null,"Pipeid28"]
[null,"Pipeid29"]
[null,"Pipeid30"]
[null,"Pipeid31"]
[null,"Pipeid32"]
[null,"Pipeid33"]
[null,"Pipeid34"]
[null,"Pipeid35"]
[null,"Pipeid36"]
[null,"Pipeid37"]
[null,"Pipeid38"]
[null,"Pipeid39"]
[null,null,null,null,null,"OutletSL",14]
[null,null,null,null,null,"OutletIL",13]
[null,null,null,null,null,"ponding",300]
[null,null,null,null,null,"DefaultCover",300]
[null,null,null,null,null,"sumflow",83.4]
[null,null,null,null,null,"maxflow",83.4]
[null,null,null,null,null,"endID",9]
[null,null,null,null,null,"endIDpipr",{"$f":"CONCATENATE(\"Pipeid\",G53)","v":"Pipeid9"}]
[null,null,null,null,null,"endIDpt",{"$f":"VLOOKUP(G54,B8:D46,3,FALSE)","v":"D"}]

{"sheet":"CSV data","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}