{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Order_Entry","Order_Sheet","Database","2.5_Angle","2.5_Straight","1.5_Angle","Flow_Charts"],"not_rendered":{"charts":13,"images":3,"macros":1,"external_links":0,"defined_names":19,"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":"Order_Entry","index":0,"n_rows":45,"n_cols":13,"rows_kept":45,"cut":false,"hidden":false,"merged":[[31,1,31,2],[31,3,31,4],[15,2,15,3],[16,2,16,3],[29,1,29,2],[30,1,30,2],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[27,1,27,2],[28,1,28,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Information"]
[]
[null,"Project:"]
[null,"Date:",{"$f":"TODAY()","v":"2015-09-28"}]
[]
[]
[null,"Valve Configuration"]
[]
[null,"Body Style","Inlet Connection","Outlet Connection","Valve Application","Monitoring Switch"]
[null,"Select...",null,null,"Select..."]
[]
[]
[null,"Operating Conditions"]
[]
[null,"Static Inlet Pressure:",null,null,null,"[psig]"]
[null,"Residual Inlet Pressure:",null,null,null,"[psig]"]
[null,"Flow Rate:",null,null,null,"[gpm]"]
[null,"Desired Residual Outlet Pressure:",null,null,null,"[psig]"]
[null,"Location Tag:"]
[]
[]
[null,"Valve Outputs"]
[]
[null,"Valve Type","Max. Inlet Rating [psig]","Max. Flow Rating [gpm]","Outlet Static Pressure [psig]","Outlet Residual Pressure [psig]","Difference to Desired Residual Out. [psig]","Status","Quantity",null,"Static Status","Res. Status","Flow Status"]
[null,{"$f":"IFERROR(INDEX(Database!C$10:C$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!C$10:C$31)-ROW(Database!C$10)+1),ROWS(Database!C$10:'Database'!C10))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!D$10:D$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!D$10:D$31)-ROW(Database!D$10)+1),ROWS(Database!D$10:'Database'!D10))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!E$10:E$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!E$10:E$31)-ROW(Database!E$10)+1),ROWS(Database!E$10:'Database'!E10))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!K$10:K$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!K$10:K$31)-ROW(Database!K$10)+1),ROWS(Database!K$10:'Database'!K10))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!L$10:L$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!L$10:L$31)-ROW(Database!L$10)+1),ROWS(Database!L$10:'Database'!L10))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!M$10:M$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!M$10:M$31)-ROW(Database!M$10)+1),ROWS(Database!M$10:'Database'!M10))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!N$10:N$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!N$10:N$31)-ROW(Database!N$10)+1),ROWS(Database!N$10:'Database'!N10))),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(Database!H$10:H$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!H$10:H$31)-ROW(Database!H$10)+1),ROWS(Database!H$10:'Database'!H10))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!I$10:I$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!I$10:I$31)-ROW(Database!I$10)+1),ROWS(Database!I$10:'Database'!I10))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!J$10:J$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!J$10:J$31)-ROW(Database!J$10)+1),ROWS(Database!J$10:'Database'!J10))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(Database!C$10:C$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!C$10:C$31)-ROW(Database!C$10)+1),ROWS(Database!C$10:'Database'!C11))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!D$10:D$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!D$10:D$31)-ROW(Database!D$10)+1),ROWS(Database!D$10:'Database'!D11))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!E$10:E$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!E$10:E$31)-ROW(Database!E$10)+1),ROWS(Database!E$10:'Database'!E11))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!K$10:K$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!K$10:K$31)-ROW(Database!K$10)+1),ROWS(Database!K$10:'Database'!K11))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!L$10:L$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!L$10:L$31)-ROW(Database!L$10)+1),ROWS(Database!L$10:'Database'!L11))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!M$10:M$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!M$10:M$31)-ROW(Database!M$10)+1),ROWS(Database!M$10:'Database'!M11))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!N$10:N$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!N$10:N$31)-ROW(Database!N$10)+1),ROWS(Database!N$10:'Database'!N11))),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(Database!H$10:H$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!H$10:H$31)-ROW(Database!H$10)+1),ROWS(Database!H$10:'Database'!H11))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!I$10:I$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!I$10:I$31)-ROW(Database!I$10)+1),ROWS(Database!I$10:'Database'!I11))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!J$10:J$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!J$10:J$31)-ROW(Database!J$10)+1),ROWS(Database!J$10:'Database'!J11))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(Database!C$10:C$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!C$10:C$31)-ROW(Database!C$10)+1),ROWS(Database!C$10:'Database'!C12))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!D$10:D$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!D$10:D$31)-ROW(Database!D$10)+1),ROWS(Database!D$10:'Database'!D12))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!E$10:E$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!E$10:E$31)-ROW(Database!E$10)+1),ROWS(Database!E$10:'Database'!E12))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!K$10:K$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!K$10:K$31)-ROW(Database!K$10)+1),ROWS(Database!K$10:'Database'!K12))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!L$10:L$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!L$10:L$31)-ROW(Database!L$10)+1),ROWS(Database!L$10:'Database'!L12))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!M$10:M$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!M$10:M$31)-ROW(Database!M$10)+1),ROWS(Database!M$10:'Database'!M12))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!N$10:N$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!N$10:N$31)-ROW(Database!N$10)+1),ROWS(Database!N$10:'Database'!N12))),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(Database!H$10:H$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!H$10:H$31)-ROW(Database!H$10)+1),ROWS(Database!H$10:'Database'!H12))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!I$10:I$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!I$10:I$31)-ROW(Database!I$10)+1),ROWS(Database!I$10:'Database'!I12))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!J$10:J$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!J$10:J$31)-ROW(Database!J$10)+1),ROWS(Database!J$10:'Database'!J12))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(Database!C$10:C$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!C$10:C$31)-ROW(Database!C$10)+1),ROWS(Database!C$10:'Database'!C13))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!D$10:D$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!D$10:D$31)-ROW(Database!D$10)+1),ROWS(Database!D$10:'Database'!D13))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!E$10:E$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!E$10:E$31)-ROW(Database!E$10)+1),ROWS(Database!E$10:'Database'!E13))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!K$10:K$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!K$10:K$31)-ROW(Database!K$10)+1),ROWS(Database!K$10:'Database'!K13))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!L$10:L$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!L$10:L$31)-ROW(Database!L$10)+1),ROWS(Database!L$10:'Database'!L13))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!M$10:M$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!M$10:M$31)-ROW(Database!M$10)+1),ROWS(Database!M$10:'Database'!M13))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!N$10:N$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!N$10:N$31)-ROW(Database!N$10)+1),ROWS(Database!N$10:'Database'!N13))),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(Database!H$10:H$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!H$10:H$31)-ROW(Database!H$10)+1),ROWS(Database!H$10:'Database'!H13))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!I$10:I$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!I$10:I$31)-ROW(Database!I$10)+1),ROWS(Database!I$10:'Database'!I13))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!J$10:J$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!J$10:J$31)-ROW(Database!J$10)+1),ROWS(Database!J$10:'Database'!J13))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(Database!C$10:C$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!C$10:C$31)-ROW(Database!C$10)+1),ROWS(Database!C$10:'Database'!C14))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!D$10:D$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!D$10:D$31)-ROW(Database!D$10)+1),ROWS(Database!D$10:'Database'!D14))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!E$10:E$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!E$10:E$31)-ROW(Database!E$10)+1),ROWS(Database!E$10:'Database'!E14))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!K$10:K$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!K$10:K$31)-ROW(Database!K$10)+1),ROWS(Database!K$10:'Database'!K14))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!L$10:L$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!L$10:L$31)-ROW(Database!L$10)+1),ROWS(Database!L$10:'Database'!L14))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!M$10:M$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!M$10:M$31)-ROW(Database!M$10)+1),ROWS(Database!M$10:'Database'!M14))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!N$10:N$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!N$10:N$31)-ROW(Database!N$10)+1),ROWS(Database!N$10:'Database'!N14))),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(Database!H$10:H$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!H$10:H$31)-ROW(Database!H$10)+1),ROWS(Database!H$10:'Database'!H15))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!I$10:I$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!I$10:I$31)-ROW(Database!I$10)+1),ROWS(Database!I$10:'Database'!I15))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!J$10:J$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!J$10:J$31)-ROW(Database!J$10)+1),ROWS(Database!J$10:'Database'!J15))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(Database!C$10:C$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!C$10:C$31)-ROW(Database!C$10)+1),ROWS(Database!C$10:'Database'!C15))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!D$10:D$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!D$10:D$31)-ROW(Database!D$10)+1),ROWS(Database!D$10:'Database'!D15))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!E$10:E$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!E$10:E$31)-ROW(Database!E$10)+1),ROWS(Database!E$10:'Database'!E15))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!K$10:K$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!K$10:K$31)-ROW(Database!K$10)+1),ROWS(Database!K$10:'Database'!K15))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!L$10:L$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!L$10:L$31)-ROW(Database!L$10)+1),ROWS(Database!L$10:'Database'!L15))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!M$10:M$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!M$10:M$31)-ROW(Database!M$10)+1),ROWS(Database!M$10:'Database'!M15))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!N$10:N$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!N$10:N$31)-ROW(Database!N$10)+1),ROWS(Database!N$10:'Database'!N15))),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(Database!H$10:H$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!H$10:H$31)-ROW(Database!H$10)+1),ROWS(Database!H$10:'Database'!H16))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!I$10:I$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!I$10:I$31)-ROW(Database!I$10)+1),ROWS(Database!I$10:'Database'!I16))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!J$10:J$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!J$10:J$31)-ROW(Database!J$10)+1),ROWS(Database!J$10:'Database'!J16))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(Database!C$10:C$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!C$10:C$31)-ROW(Database!C$10)+1),ROWS(Database!C$10:'Database'!C16))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!D$10:D$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!D$10:D$31)-ROW(Database!D$10)+1),ROWS(Database!D$10:'Database'!D16))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!E$10:E$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!E$10:E$31)-ROW(Database!E$10)+1),ROWS(Database!E$10:'Database'!E16))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!K$10:K$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!K$10:K$31)-ROW(Database!K$10)+1),ROWS(Database!K$10:'Database'!K16))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!L$10:L$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!L$10:L$31)-ROW(Database!L$10)+1),ROWS(Database!L$10:'Database'!L16))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!M$10:M$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!M$10:M$31)-ROW(Database!M$10)+1),ROWS(Database!M$10:'Database'!M16))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!N$10:N$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!N$10:N$31)-ROW(Database!N$10)+1),ROWS(Database!N$10:'Database'!N16))),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(Database!H$10:H$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!H$10:H$31)-ROW(Database!H$10)+1),ROWS(Database!H$10:'Database'!H17))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!I$10:I$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!I$10:I$31)-ROW(Database!I$10)+1),ROWS(Database!I$10:'Database'!I17))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!J$10:J$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!J$10:J$31)-ROW(Database!J$10)+1),ROWS(Database!J$10:'Database'!J17))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(Database!C$10:C$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!C$10:C$31)-ROW(Database!C$10)+1),ROWS(Database!C$10:'Database'!C17))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!D$10:D$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!D$10:D$31)-ROW(Database!D$10)+1),ROWS(Database!D$10:'Database'!D17))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!E$10:E$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!E$10:E$31)-ROW(Database!E$10)+1),ROWS(Database!E$10:'Database'!E17))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!K$10:K$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!K$10:K$31)-ROW(Database!K$10)+1),ROWS(Database!K$10:'Database'!K17))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!L$10:L$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!L$10:L$31)-ROW(Database!L$10)+1),ROWS(Database!L$10:'Database'!L17))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!M$10:M$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!M$10:M$31)-ROW(Database!M$10)+1),ROWS(Database!M$10:'Database'!M17))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!N$10:N$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!N$10:N$31)-ROW(Database!N$10)+1),ROWS(Database!N$10:'Database'!N17))),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(Database!H$10:H$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!H$10:H$31)-ROW(Database!H$10)+1),ROWS(Database!H$10:'Database'!H18))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!I$10:I$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!I$10:I$31)-ROW(Database!I$10)+1),ROWS(Database!I$10:'Database'!I18))),\"\")","v":""},{"$f":"IFERROR(INDEX(Database!J$10:J$31, SMALL(IF(Database!$B$10:$B$31=Order_Entry!$B$23,ROW(Database!J$10:J$31)-ROW(Database!J$10)+1),ROWS(Database!J$10:'Database'!J18))),\"\")","v":""}]

{"sheet":"Order_Sheet","index":1,"n_rows":2,"n_cols":15,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,11,0,13],[0,2,0,4]]}
["Project Name:",null,{"$f":" IF(Order_Entry!C16=\"\",\"\",Order_Entry!C16)","v":""},null,null,null,null,null,null,null,"Date:",{"$f":"Order_Entry!$C$17","v":"2015-09-28"}]
["Order Quantity","Body Style","Type","Inlet Connection","Outlet Connection","Monitoring Switch","Location Tag",null,"Static Inlet [PSI]","Residual Inlet [PSI]","Flow Rate [GPM]","Desired Outlet Residual [PSI]",null,"Static Outlet [PSI]","Residual Outlet [PSI]"]

{"sheet":"Database","index":2,"n_rows":55,"n_cols":14,"rows_kept":55,"cut":false,"hidden":true,"merged":[]}
["Variables"]
["Static Inlet Pressure [psig]:",{"$f":"Order_Entry!$D$28","v":0},null,"Minimum Flow Rate [GPM]:",{"$f":"VLOOKUP(Order_Entry!E23,D36:I37,6)","v":{"$error":"#N/A"}}]
["Residual Inlet Pressure [psig]:",{"$f":"Order_Entry!$D$29","v":0},null,"Maximum Flow Rate [GPM]:",{"$f":"VLOOKUP(Main,B36:H38,7)","v":500}]
["Flow Rate [GPM]:",{"$f":"Order_Entry!$D$30","v":0},null,"Minimum Inlet Pressure [psig]:",50]
["Desired Residual Outlet Pressure [psig]:",{"$f":"Order_Entry!$D$31","v":0}]
[]
[]
["Calculation Tables"]
[null,"Configuration","Valve Type","Max Inlet Rating","Max Flow Rating","Calculated Static Out.Pressure","Calculated Res. Out. Pressure","Static Out. Status","Res. Out Status","Flow Status","Static Out. Display","Res. Out. Display","Difference to Desired Residual Outlet Pressure","Status"]
[null,"1.5\" Angle","Type 1",{"$f":"'1.5_Angle'!$A$9","v":210},{"$f":"'1.5_Angle'!$AI$13","v":250},{"$f":"'1.5_Angle'!$AG$13","v":{"$error":"#NUM!"}},{"$f":"'1.5_Angle'!$AH$13","v":{"$error":"#NUM!"}},{"$f":"IF($B$2<$E$4,$B$51, IF($B$2>$D10, $B$50, $B$47))","v":"Err2"},{"$f":"IF($B$3<$E$4,$B$53,IF($B$3>$D10,$B$52,$B$48))","v":"Err4"},{"$f":"IF($B$4<$E$2,$B$55,IF($B$4>$E10,$B$54,$B$49))","v":{"$error":"#N/A"}},{"$f":"IF(AND($H10=\"SC\",$I10=\"RC\",$J10=\"FC\"), $F10, \"N/A\")","v":{"$error":"#N/A"}},{"$f":"IF(AND($H10=\"SC\",$I10=\"RC\",$J10=\"FC\"), $G10, \"N/A\")","v":{"$error":"#N/A"}},{"$f":"IF(AND(H10=\"SC\",I10=\"RC\",J10=\"FC\",$B$5>0),(ABS($B$5-$L10)),\"-\")","v":{"$error":"#N/A"}},{"$f":"IF(AND($H10=\"SC\",$I10=\"RC\",$J10=\"FC\"), \"Available\", \"Unavailable\")","v":{"$error":"#N/A"}}]
[null,"1.5\" Angle","Type 2",{"$f":"'1.5_Angle'!$A$17","v":250},{"$f":"'1.5_Angle'!$AI$14","v":250},{"$f":"'1.5_Angle'!$AG$14","v":{"$error":"#NUM!"}},{"$f":"'1.5_Angle'!$AH$14","v":{"$error":"#NUM!"}},{"$f":"IF($B$2<$E$4,$B$51, IF($B$2>$D11, $B$50, $B$47))","v":"Err2"},{"$f":"IF($B$3<$E$4,$B$53,IF($B$3>$D11,$B$52,$B$48))","v":"Err4"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"1.5\" Angle","Type 3",{"$f":"'1.5_Angle'!$A$26","v":260},{"$f":"'1.5_Angle'!$AI$15","v":250},{"$f":"'1.5_Angle'!$AG$15","v":{"$error":"#NUM!"}},{"$f":"'1.5_Angle'!$AH$15","v":{"$error":"#NUM!"}},{"$f":"IF($B$2<$E$4,$B$51, IF($B$2>$D12, $B$50, $B$47))","v":"Err2"},"Err4",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"1.5\" Angle","Type 4A",{"$f":"'1.5_Angle'!$A$44","v":260},{"$f":"'1.5_Angle'!$AI$17","v":250},{"$f":"'1.5_Angle'!$AG$17","v":{"$error":"#NUM!"}},{"$f":"'1.5_Angle'!$AH$17","v":{"$error":"#NUM!"}},{"$f":"IF($B$2<E7,$B$51, IF($B$2>Table3[[#This Row],[Max Inlet Rating]], $B$50, $B$47))","v":"SC"},"Err4",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"1.5\" Angle","Type 4B",{"$f":"'1.5_Angle'!$A$35","v":275},{"$f":"'1.5_Angle'!$AI$16","v":200},{"$f":"'1.5_Angle'!$AG$16","v":{"$error":"#NUM!"}},{"$f":"'1.5_Angle'!$AH$16","v":{"$error":"#NUM!"}},{"$f":"IF($B$2<$E$4,$B$51, IF($B$2>$D14, $B$50, $B$47))","v":"Err2"},"Err4",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"1.5\" Angle","Type 5",{"$f":"'1.5_Angle'!$A$54","v":300},{"$f":"'1.5_Angle'!$AI$18","v":250},{"$f":"'1.5_Angle'!$AG$18","v":{"$error":"#NUM!"}},{"$f":"'1.5_Angle'!$AH$18","v":{"$error":"#NUM!"}},"Err2","Err4",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"2.5\" Angle","Type 0",{"$f":"'2.5_Angle'!$A$9","v":210},{"$f":"'2.5_Angle'!$AK$29","v":500},{"$f":"'2.5_Angle'!$AI$29","v":{"$error":"#NUM!"}},{"$f":"'2.5_Angle'!$AJ$29","v":{"$error":"#NUM!"}},"Err2","Err4",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"2.5\" Angle","Type 1",{"$f":"'2.5_Angle'!$A$17","v":220},{"$f":"'2.5_Angle'!$AK$30","v":500},{"$f":"'2.5_Angle'!$AI$30","v":{"$error":"#NUM!"}},{"$f":"'2.5_Angle'!$AJ$30","v":{"$error":"#NUM!"}},"Err2","Err4",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"2.5\" Angle","Type 2",{"$f":"'2.5_Angle'!$A$25","v":230},{"$f":"'2.5_Angle'!$AK$31","v":500},{"$f":"'2.5_Angle'!$AI$31","v":{"$error":"#NUM!"}},{"$f":"'2.5_Angle'!$AJ$31","v":{"$error":"#NUM!"}},"Err2","Err4",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"2.5\" Angle","Type 3",{"$f":"'2.5_Angle'!$A$34","v":265},{"$f":"'2.5_Angle'!$AK$32","v":500},{"$f":"'2.5_Angle'!$AI$32","v":{"$error":"#NUM!"}},{"$f":"'2.5_Angle'!$AJ$32","v":{"$error":"#NUM!"}},"Err2","Err4",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"2.5\" Angle","Type 4",{"$f":"'2.5_Angle'!$A$43","v":300},{"$f":"'2.5_Angle'!$AK$33","v":500},{"$f":"'2.5_Angle'!$AI$33","v":{"$error":"#NUM!"}},{"$f":"'2.5_Angle'!$AJ$33","v":{"$error":"#NUM!"}},"Err2","Err4",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"2.5\" Angle","Type 5",{"$f":"'2.5_Angle'!$A$53","v":320},{"$f":"'2.5_Angle'!$AK$34","v":500},{"$f":"'2.5_Angle'!$AI$34","v":{"$error":"#NUM!"}},{"$f":"'2.5_Angle'!$AJ$34","v":{"$error":"#NUM!"}},"Err2","Err4",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"2.5\" Angle","Type 6",{"$f":"'2.5_Angle'!$A$64","v":360},{"$f":"'2.5_Angle'!$AK$35","v":500},{"$f":"'2.5_Angle'!$AI$35","v":{"$error":"#NUM!"}},{"$f":"'2.5_Angle'!$AJ$35","v":{"$error":"#NUM!"}},"Err2","Err4",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"2.5\" Angle","Type 7",{"$f":"'2.5_Angle'!$A$75","v":400},{"$f":"'2.5_Angle'!$AK$36","v":500},{"$f":"'2.5_Angle'!$AI$36","v":{"$error":"#NUM!"}},{"$f":"'2.5_Angle'!$AJ$36","v":{"$error":"#NUM!"}},"Err2","Err4",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"2.5\" Inline","Type 0",{"$f":"'2.5_Straight'!$A$9","v":210},{"$f":"'2.5_Straight'!$AK$29","v":500},{"$f":"'2.5_Straight'!$AI$29","v":{"$error":"#NUM!"}},{"$f":"'2.5_Straight'!$AJ$29","v":{"$error":"#NUM!"}},"Err2","Err4",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"2.5\" Inline","Type 1",{"$f":"'2.5_Straight'!$A$17","v":220},{"$f":"'2.5_Straight'!$AK$30","v":500},{"$f":"'2.5_Straight'!$AI$30","v":{"$error":"#NUM!"}},{"$f":"'2.5_Straight'!$AJ$30","v":{"$error":"#NUM!"}},"Err2","Err4",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"2.5\" Inline","Type 2",{"$f":"'2.5_Straight'!$A$25","v":230},{"$f":"'2.5_Straight'!$AK$31","v":500},{"$f":"'2.5_Straight'!$AI$31","v":{"$error":"#NUM!"}},{"$f":"'2.5_Straight'!$AJ$31","v":{"$error":"#NUM!"}},"Err2","Err4",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"2.5\" Inline","Type 3",{"$f":"'2.5_Straight'!$A$34","v":265},{"$f":"'2.5_Straight'!$AK$32","v":500},{"$f":"'2.5_Straight'!$AI$32","v":{"$error":"#NUM!"}},{"$f":"'2.5_Straight'!$AJ$32","v":{"$error":"#NUM!"}},"Err2","Err4",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"2.5\" Inline","Type 4",{"$f":"'2.5_Straight'!$A$43","v":300},{"$f":"'2.5_Straight'!$AK$33","v":500},{"$f":"'2.5_Straight'!$AI$33","v":{"$error":"#NUM!"}},{"$f":"'2.5_Straight'!$AJ$33","v":{"$error":"#NUM!"}},"Err2",{"$f":"IF($B$3<$E$4,$B$53,IF($B$3>$D28,$B$52,$B$48))","v":"Err4"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND($H28=\"SC\",$I28=\"RC\",$J28=\"FC\"), $G28, \"N/A\")","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"2.5\" Inline","Type 5",{"$f":"'2.5_Straight'!$A$53","v":320},{"$f":"'2.5_Straight'!$AK$34","v":500},{"$f":"'2.5_Straight'!$AI$34","v":{"$error":"#NUM!"}},{"$f":"'2.5_Straight'!$AJ$34","v":{"$error":"#NUM!"}},"Err2",{"$f":"IF($B$3<$E$4,$B$53,IF($B$3>$D29,$B$52,$B$48))","v":"Err4"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND($H29=\"SC\",$I29=\"RC\",$J29=\"FC\"), $G29, \"N/A\")","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"2.5\" Inline","Type 6",{"$f":"'2.5_Straight'!$A$64","v":360},{"$f":"'2.5_Straight'!$AK$35","v":500},{"$f":"'2.5_Straight'!$AI$35","v":{"$error":"#NUM!"}},{"$f":"'2.5_Straight'!$AJ$35","v":{"$error":"#NUM!"}},"Err2","Err4",{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND($H30=\"SC\",$I30=\"RC\",$J30=\"FC\"), $G30, \"N/A\")","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"2.5\" Inline","Type 7",{"$f":"'2.5_Straight'!$A$75","v":400},{"$f":"'2.5_Straight'!$AK$36","v":500},{"$f":"'2.5_Straight'!AI$36","v":{"$error":"#NUM!"}},{"$f":"'2.5_Straight'!$AJ$36","v":{"$error":"#NUM!"}},"Err2","Err4",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
["Drop-Down Options"]
[]
[null,"Configuration","Reference","Application","Reference","Sprinkler","Standpipe","Max. Flow Rate","Min. Flow Rate"]
[null,"1.5\" Angle","ValveA","Sprinkler System","Sprinkler","None","None",250,50]
[null,"2.5\" Angle","ValveB","Standpipe System","Standpipe","N.C. (Recom'd)","N.O. (Recom'd)",500,65]
[null,"2.5\" Inline","ValveC",null,null,"N.O.","N.C.",500]
[]
[null,"ValveA_Inlet","ValveA_Outlet","ValveB_Inlet","ValveB_Outlet","ValveC_Inlet","ValveC_Outlet"]
[null,"Female NPT","Female NPT","Female NPT","Female NPT","Female NPT","Female NPT"]
[null,"Grooved Pipe","Grooved Pipe","Grooved Pipe","Grooved Pipe","Grooved Pipe","Grooved Pipe"]
[null,null,"Male Hose",null,"Regional Hose"]
["Error Messages"]
[]
[null,"Code","Message"]
[null,"SC","Static Clear"]
[null,"RC","Res. Clear"]
[null,"FC","Flow Clear"]
[null,"Err1","Static inlet too high"]
[null,"Err2","Static inlet too low"]
[null,"Err3","Residual inlet too high"]
[null,"Err4","Residual inlet too low"]
[null,"Err5","Flow rate too high"]
[null,"Err6","Flow rate too low"]

{"sheet":"2.5_Angle","index":3,"n_rows":75,"n_cols":37,"rows_kept":75,"cut":false,"hidden":true,"merged":[[11,28,11,29],[54,1,54,12],[65,1,65,12],[2,1,2,12],[10,1,10,12],[18,1,18,12],[26,1,26,12],[35,1,35,12],[44,1,44,12],[2,15,2,20],[10,15,10,20],[18,15,18,20],[26,15,26,20],[35,15,35,20],[46,14,50,14],[56,14,60,14],[67,14,71,14],[44,15,44,20],[54,15,54,20],[65,15,65,20],[4,14,8,14],[12,14,16,14],[20,14,24,14],[28,14,32,14],[37,14,41,14],[66,28,66,29],[67,22,71,22],[3,33,3,35],[55,28,55,29],[56,22,60,22],[37,22,41,22],[45,28,45,29],[46,22,50,22],[27,28,27,29],[28,22,32,22],[36,28,36,29],[19,28,19,29],[20,22,24,22],[4,22,8,22],[12,22,16,22],[3,28,3,29]]}
["2.5\" Angle Body - Outlet Pressures @ Flow Rate"]
["Data compiled from Project No. 12CA5765 - EX5549. Published 13-Nov-2013. Values with blank data indicate pumps were unable to meet required specifications."]
["Type 0","Outlet Pressures: Inlet Pressure [psig] vs. Flow Rate [GPM]",null,null,null,null,null,null,null,null,null,null,null,null,"Type 0","Inlet vs. Outlet Pressure Over Flow Range",null,null,null,null,null,null,"Type 0"]
["Inlet Pressure (psig)",0,50,75,100,150,200,250,300,350,400,450,500,null,null,null,"Static","50-200 [GPM]","200-300 [GPM]","300-400 [GPM]","400-500 [GPM]",null,null,null,{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$8& \" GPM\")","v":"Outlet Residual @ 0 GPM"},{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$9& \" GPM\")","v":"Outlet Residual @ 0 GPM"},null,null,"Const. PRI Interpolated @ Var. Flow",null,null,null,null,"Variables:"]
[50,41,38,40,36,36,35,37,34,30,28,26,null,null,"Inlet Pressure (psig)",{"$f":"A5","v":50},{"$f":"B5","v":41},{"$f":"AVERAGE(C5:G5)","v":37},{"$f":"AVERAGE(G5:I5)","v":35.333333333333336},{"$f":"AVERAGE(I5:K5)","v":30.666666666666668},{"$f":"AVERAGE(K5:M5)","v":27},null,"Inlet Pressure (psig)",{"$f":"A5","v":50},{"$f":"HLOOKUP($AJ$8,$B$4:$M$9,2)","v":41},{"$f":"HLOOKUP($AJ$9,$B$4:$M$9,2)","v":41},"PRI1:",{"$f":"LARGE(A5:A9,COUNTIF(A5:A9,\">\" &AJ6)+1)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB5,X5:Z9,2)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB5,X5:Z9,3)","v":{"$error":"#NUM!"}},"PRO1:",{"$f":"IF(AJ8=AJ9, AC5, FORECAST(AJ7,$AC$5:$AD$5,$AJ$8:$AJ$9))","v":{"$error":"#NUM!"}},null,"Static Inlet Pressure ","PSI:",{"$f":"Database!$B$2","v":0}]
[100,80,79,78,78,77,76,75,74,72,68,65,64,null,null,{"$f":"A6","v":100},{"$f":"B6","v":80},{"$f":"AVERAGE(C6:G6)","v":77.599999999999994},{"$f":"AVERAGE(G6:I6)","v":75},{"$f":"AVERAGE(I6:K6)","v":71.333333333333329},{"$f":"AVERAGE(K6:M6)","v":65.666666666666671},null,null,{"$f":"A6","v":100},{"$f":"HLOOKUP($AJ$8,$B$4:$M$9,3)","v":80},{"$f":"HLOOKUP($AJ$9,$B$4:$M$9,3)","v":80},"PRI2:",{"$f":"SMALL(A5:A9,COUNTIF(A5:A9,\"<\"&AJ6)+1)","v":50},{"$f":"VLOOKUP(AB6,X5:Z9,2)","v":41},{"$f":"VLOOKUP(AB6,X5:Z9,3)","v":41},"PRO2:",{"$f":"IF(AJ8=AJ9, AC6, FORECAST($AJ$7,$AC$6:$AD$6,$AJ$8:$AJ$9))","v":41},null,"Residual Inlet Pressure ","PRI:",{"$f":"Database!$B$3","v":0}]
[150,121,118,117,117,116,117,116,114,112,109,106,103,null,null,{"$f":"A7","v":150},121,{"$f":"AVERAGE(C7:G7)","v":117},115.66666666666667,111.66666666666667,106,null,null,{"$f":"A7","v":150},{"$f":"HLOOKUP($AJ$8,$B$4:$M$9,4)","v":121},{"$f":"HLOOKUP($AJ$9,$B$4:$M$9,4)","v":121},"PSI1:",{"$f":"LARGE(A5:A9,COUNTIF(A5:A9,\">\" &AJ5)+1)","v":{"$error":"#NUM!"}},null,null,"PSO1:",{"$f":"VLOOKUP(AB7,A5:B9,2)","v":{"$error":"#NUM!"}},null,"Flow Rate ","Q0:",{"$f":"IF(Database!$B$4=500, 499.99, Database!$B$4)","v":0}]
[200,162,160,158,158,156,156,155,153,152,151,151,144,null,null,{"$f":"A8","v":200},162,157.6,154.66666666666666,152,148.66666666666666,null,null,{"$f":"A8","v":200},{"$f":"HLOOKUP($AJ$8,$B$4:$M$9,5)","v":162},{"$f":"HLOOKUP($AJ$9,$B$4:$M$9,5)","v":162},"PSI2:",{"$f":"SMALL(A5:A9,COUNTIF(A5:A9,\"<\"&AJ5)+1)","v":50},null,null,"PSO2:",{"$f":"VLOOKUP(AB8,A5:B9,2)","v":41},null,"Nearest Known Flow Rate, 1","Q1:",{"$f":"LARGE(B4:M4,COUNTIF(B4:M4,\">\" &AJ7)+1)","v":0}]
[210,172,168,167,166,164,163,163,161,161,158,155,152,null,null,{"$f":"A9","v":210},172,165.6,162.33333333333334,160,155,null,null,{"$f":"A9","v":210},{"$f":"HLOOKUP($AJ$8,$B$4:$M$9,6)","v":172},{"$f":"HLOOKUP($AJ$9,$B$4:$M$9,6)","v":172},null,null,null,null,null,null,null,"Nearest Known Flow Rate, 2","Q2:",{"$f":"SMALL(B4:M4,COUNTIF(B4:M4,\"<\"&AJ7)+1)","v":0}]
[]
["Type 1","Outlet Pressures: Inlet Pressure [psig] vs. Flow Rate [GPM]",null,null,null,null,null,null,null,null,null,null,null,null,"Type 1","Inlet vs. Outlet Pressure Over Flow Range",null,null,null,null,null,null,"Type 1"]
["Inlet Pressure (psig)",0,50,75,100,150,200,250,300,350,400,450,500,null,null,null,"Static","50-200 [GPM]","200-300 [GPM]","300-400 [GPM]","400-500 [GPM]",null,null,null,{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$8& \" GPM\")","v":"Outlet Residual @ 0 GPM"},{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$9& \" GPM\")","v":"Outlet Residual @ 0 GPM"},null,null,"Const. PRI Interpolated @ Var. Flow"]
[50,36,35,35,34,34,34,32,29,null,null,null,null,null,"Inlet Pressure (psig)",{"$f":"A13","v":50},{"$f":"B13","v":36},{"$f":"AVERAGE(C13:G13)","v":34.4},{"$f":"AVERAGE(G13:I13)","v":31.666666666666668},{"$f":"AVERAGE(I13:K13)","v":29},null,null,"Inlet Pressure (psig)",{"$f":"A13","v":50},{"$f":"HLOOKUP($AJ$8,$B$12:$M$17,2)","v":36},{"$f":"HLOOKUP($AJ$9,$B$12:$M$17,2)","v":36},"PRI1:",{"$f":"LARGE(A13:A17,COUNTIF(A13:A17,\">\" &$AJ$6)+1)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB13,X13:Z17,2)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB13,X13:Z17,3)","v":{"$error":"#NUM!"}},"PRO1:",{"$f":"IF(AC13=AD13,AC13, FORECAST($AJ$7,AC13:AD13,$AJ$8:$AJ$9))","v":{"$error":"#NUM!"}}]
[100,75,69,70,71,71,66,67,66,63,60,57,53,null,null,{"$f":"A14","v":100},{"$f":"B14","v":75},{"$f":"AVERAGE(C14:G14)","v":69.400000000000006},{"$f":"AVERAGE(G14:I14)","v":66.333333333333329},{"$f":"AVERAGE(I14:K14)","v":63},{"$f":"AVERAGE(K14:M14)","v":56.666666666666664},null,null,{"$f":"A14","v":100},{"$f":"HLOOKUP($AJ$8,$B$12:$M$17,3)","v":75},{"$f":"HLOOKUP($AJ$9,$B$12:$M$17,3)","v":75},"PRI2:",{"$f":"SMALL(A13:A17,COUNTIF(A13:A17,\"<\"&$AJ$6)+1)","v":50},{"$f":"VLOOKUP(AB14,X13:Z17,2)","v":36},{"$f":"VLOOKUP(AB14,X13:Z17,3)","v":36},"PRO2:",{"$f":"IF(AC14=AD14, AC14, FORECAST($AJ$7,AC14:AD14,$AJ$8:$AJ$9))","v":36}]
[150,114,105,105,106,106,105,105,102,100,98,94,90,null,null,{"$f":"A15","v":150},114,{"$f":"AVERAGE(C15:G15)","v":105.4},104,100,94,null,null,{"$f":"A15","v":150},{"$f":"HLOOKUP($AJ$8,$B$12:$M$17,4)","v":114},{"$f":"HLOOKUP($AJ$9,$B$12:$M$17,4)","v":114},"PSI1:",{"$f":"LARGE(A13:A17,COUNTIF(A13:A17,\">\" &$AJ$5)+1)","v":{"$error":"#NUM!"}},null,null,"PSO1:",{"$f":"VLOOKUP(AB15,A13:B17,2)","v":{"$error":"#NUM!"}}]
[200,153,141,140,139,142,141,142,139,137,134,130,127,null,null,{"$f":"A16","v":200},153,140.6,140.66666666666666,136.66666666666666,130.33333333333334,null,null,{"$f":"A16","v":200},{"$f":"HLOOKUP($AJ$8,$B$12:$M$17,5)","v":153},{"$f":"HLOOKUP($AJ$9,$B$12:$M$17,5)","v":153},"PSI2:",{"$f":"SMALL(A13:A17,COUNTIF(A13:A17,\"<\"&$AJ$5)+1)","v":50},null,null,"PSO2:",{"$f":"VLOOKUP(AB16,A13:B17,2)","v":36}]
[220,171,156,155,154,155,155,154,155,150,149,146,143,null,null,{"$f":"A17","v":220},171,155,154.66666666666666,151.33333333333334,146,null,null,{"$f":"A17","v":220},{"$f":"HLOOKUP($AJ$8,$B$12:$M$17,6)","v":171},{"$f":"HLOOKUP($AJ$9,$B$12:$M$17,6)","v":171}]
[]
["Type 2","Outlet Pressures: Inlet Pressure [psig] vs. Flow Rate [GPM]",null,null,null,null,null,null,null,null,null,null,null,null,"Type 2","Inlet vs. Outlet Pressure Over Flow Range",null,null,null,null,null,null,"Type 2"]
["Inlet Pressure (psig)",0,50,75,100,150,200,250,300,350,400,450,500,null,null,null,"Static","50-200 [GPM]","200-300 [GPM]","300-400 [GPM]","400-500 [GPM]",null,null,null,{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$8& \" GPM\")","v":"Outlet Residual @ 0 GPM"},{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$9& \" GPM\")","v":"Outlet Residual @ 0 GPM"},null,null,"Const. PRI Interpolated @ Var. Flow"]
[50,36,31,31,36,32,31,28,26,null,null,null,null,null,"Inlet Pressure (psig)",{"$f":"A21","v":50},{"$f":"B21","v":36},{"$f":"AVERAGE(C21:G21)","v":32.200000000000003},{"$f":"AVERAGE(G21:I21)","v":28.333333333333332},{"$f":"AVERAGE(I21:K21)","v":26},null,null,"Inlet Pressure (psig)",{"$f":"A21","v":50},{"$f":"HLOOKUP($AJ$8,$B$20:$M$25,2)","v":36},{"$f":"HLOOKUP($AJ$9,$B$20:$M$25,2)","v":36},"PRI1:",{"$f":"LARGE(A21:A25,COUNTIF(A21:A25,\">\" &$AJ$6)+1)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB21,X21:Z25,2)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB21,X21:Z25,3)","v":{"$error":"#NUM!"}},"PRO1:",{"$f":"IF(AC21=AD21,AC21, FORECAST($AJ$7,AC21:AD21,$AJ$8:$AJ$9))","v":{"$error":"#NUM!"}}]
[100,73,66,67,68,68,70,64,61,58,57,56,51,null,null,{"$f":"A22","v":100},{"$f":"B22","v":73},{"$f":"AVERAGE(C22:G22)","v":67.8},{"$f":"AVERAGE(G22:I22)","v":65},{"$f":"AVERAGE(I22:K22)","v":58.666666666666664},{"$f":"AVERAGE(K22:M22)","v":54.666666666666664},null,null,{"$f":"A22","v":100},{"$f":"HLOOKUP($AJ$8,$B$20:$M$25,3)","v":73},{"$f":"HLOOKUP($AJ$9,$B$20:$M$25,3)","v":73},"PRI2:",{"$f":"SMALL(A21:A25,COUNTIF(A21:A25,\"<\"&$AJ$6)+1)","v":50},{"$f":"VLOOKUP(AB22,X21:Z25,2)","v":36},{"$f":"VLOOKUP(AB22,X21:Z25,3)","v":36},"PRO2:",{"$f":"IF(AC22=AD22, AC22, FORECAST($AJ$7,AC22:AD22,$AJ$8:$AJ$9))","v":36}]
[150,110,102,100,102,104,104,102,99,96,93,90,86,null,null,{"$f":"A23","v":150},110,{"$f":"AVERAGE(C23:G23)","v":102.4},101.66666666666667,96,89.666666666666671,null,null,{"$f":"A23","v":150},{"$f":"HLOOKUP($AJ$8,$B$20:$M$25,4)","v":110},{"$f":"HLOOKUP($AJ$9,$B$20:$M$25,4)","v":110},"PSI1:",{"$f":"LARGE(A21:A25,COUNTIF(A21:A25,\">\" &$AJ$5)+1)","v":{"$error":"#NUM!"}},null,null,"PSO1:",{"$f":"VLOOKUP(AB23,A21:B25,2)","v":{"$error":"#NUM!"}}]
[200,150,135,133,134,137,138,136,134,132,129,127,124,null,null,{"$f":"A24","v":200},150,135.4,136,131.66666666666666,126.66666666666667,null,null,{"$f":"A24","v":200},{"$f":"HLOOKUP($AJ$8,$B$20:$M$25,5)","v":150},{"$f":"HLOOKUP($AJ$9,$B$20:$M$25,5)","v":150},"PSI2:",{"$f":"SMALL(A21:A25,COUNTIF(A21:A25,\"<\"&$AJ$5)+1)","v":50},null,null,"PSO2:",{"$f":"VLOOKUP(AB24,A21:B25,2)","v":36}]
[230,172,156,153,153,157,158,157,156,153,152,145,144,null,null,{"$f":"A25","v":230},172,155.4,157,153.66666666666666,147,null,null,{"$f":"A25","v":230},{"$f":"HLOOKUP($AJ$8,$B$20:$M$25,6)","v":172},{"$f":"HLOOKUP($AJ$9,$B$20:$M$25,6)","v":172}]
[]
["Type 3","Outlet Pressures: Inlet Pressure [psig] vs. Flow Rate [GPM]",null,null,null,null,null,null,null,null,null,null,null,null,"Type 3","Inlet vs. Outlet Pressure Over Flow Range",null,null,null,null,null,null,"Type 3"]
["Inlet Pressure (psig)",0,50,75,100,150,200,250,300,350,400,450,500,null,null,null,"Static","50-200 [GPM]","200-300 [GPM]","300-400 [GPM]","400-500 [GPM]",null,null,null,{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$8& \" GPM\")","v":"Outlet Residual @ 0 GPM"},{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$9& \" GPM\")","v":"Outlet Residual @ 0 GPM"},null,null,"Const. PRI Interpolated @ Var. Flow",null,null,null,null,"2.5\" Angle","Calculated Static Outlet Pressure","Calculated Residual Outlet Pressure","Max. Flow Rate"]
[50,49,26,28,29,29,27,25,23,null,null,null,null,null,"Inlet Pressure (psig)",{"$f":"A29","v":50},{"$f":"B29","v":49},{"$f":"AVERAGE(C29:G29)","v":27.8},{"$f":"AVERAGE(G29:I29)","v":25},{"$f":"AVERAGE(I29:K29)","v":23},null,null,"Inlet Pressure (psig)",{"$f":"A29","v":50},{"$f":"HLOOKUP($AJ$8,$B$28:$M$34,2)","v":49},{"$f":"HLOOKUP($AJ$9,$B$28:$M$34,2)","v":49},"PRI1:",{"$f":"LARGE(A29:A34,COUNTIF(A29:A34,\">\" &$AJ$6)+1)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB29,X29:Z34,2)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB29,X29:Z34,3)","v":{"$error":"#NUM!"}},"PRO1:",{"$f":"IF(AC29=AD29,AC29, FORECAST($AJ$7,AC29:AD29,$AJ$8:$AJ$9))","v":{"$error":"#NUM!"}},null,"Type 0",{"$f":"IF(AF7=AF8,AF7,FORECAST($AJ$5,AF7:AF8,AB7:AB8))","v":{"$error":"#NUM!"}},{"$f":"IF(AF5=AF6,AF5,FORECAST($AJ$6,AF5:AF6,AB5:AB6))","v":{"$error":"#NUM!"}},500]
[100,61,57,58,59,57,57,56,55,52,49,47,43,null,null,{"$f":"A30","v":100},{"$f":"B30","v":61},{"$f":"AVERAGE(C30:G30)","v":57.6},{"$f":"AVERAGE(G30:I30)","v":56},{"$f":"AVERAGE(I30:K30)","v":52},{"$f":"AVERAGE(K30:M30)","v":46.333333333333336},null,null,100,{"$f":"HLOOKUP($AJ$8,$B$28:$M$34,3)","v":61},{"$f":"HLOOKUP($AJ$9,$B$28:$M$34,3)","v":61},"PRI2:",{"$f":"SMALL(A29:A34,COUNTIF(A29:A34,\"<\"&$AJ$6)+1)","v":50},{"$f":"VLOOKUP(AB30,X29:Z34,2)","v":49},{"$f":"VLOOKUP(AB30,X29:Z34,3)","v":49},"PRO2:",{"$f":"IF(AC30=AD30, AC30, FORECAST($AJ$7,AC30:AD30,$AJ$8:$AJ$9))","v":49},null,"Type 1",{"$f":"IF(AF15=AF16,AF15,FORECAST($AJ$5,AF15:AF16,AB15:AB16))","v":{"$error":"#NUM!"}},{"$f":"IF(AB13=AB14,AF13,FORECAST($AJ$6,AF13:AF14,AB13:AB14))","v":{"$error":"#NUM!"}},500]
[150,98,89,87,85,85,86,86,84,83,82,78,74,null,null,{"$f":"A31","v":150},{"$f":"B31","v":98},{"$f":"AVERAGE(C31:G31)","v":86.4},85.333333333333329,83,78,null,null,150,{"$f":"HLOOKUP($AJ$8,$B$28:$M$34,4)","v":98},{"$f":"HLOOKUP($AJ$9,$B$28:$M$34,4)","v":98},"PSI1:",{"$f":"LARGE(A29:A34,COUNTIF(A29:A34,\">\" &$AJ$5)+1)","v":{"$error":"#NUM!"}},null,null,"PSO1:",{"$f":"VLOOKUP(AB31,A29:B33,2)","v":{"$error":"#NUM!"}},null,"Type 2",{"$f":"IF(AF23=AF24,AF23,FORECAST($AJ$5,AF23:AF24,AB23:AB24))","v":{"$error":"#NUM!"}},{"$f":"IF(AB21=AB22,AF21,FORECAST($AJ$6,AF21:AF22,AB21:AB22))","v":{"$error":"#NUM!"}},500]
[200,131,121,120,117,114,117,115,114,113,110,108,107,null,null,{"$f":"A32","v":200},131,117.8,115.33333333333333,112.33333333333333,108.33333333333333,null,null,200,{"$f":"HLOOKUP($AJ$8,$B$28:$M$34,5)","v":131},{"$f":"HLOOKUP($AJ$9,$B$28:$M$34,5)","v":131},"PSI2:",{"$f":"SMALL(A29:A34,COUNTIF(A29:A34,\"<\"&$AJ$5)+1)","v":50},null,null,"PSO2:",{"$f":"VLOOKUP(AB32,A29:B33,2)","v":49},null,"Type 3",{"$f":"IF(AF31=AF32,AF31,FORECAST($AJ$5,AF31:AF32,AB31:AB32))","v":{"$error":"#NUM!"}},{"$f":"IF(AB29=AB30,AF29,FORECAST($AJ$6,AF29:AF30,AB29:AB30))","v":{"$error":"#NUM!"}},500]
[250,161,152,151,148,144,143,141,146,143,141,138,136,null,null,{"$f":"A33","v":250},161,147.6,143.33333333333334,143.33333333333334,138.33333333333334,null,null,250,{"$f":"HLOOKUP($AJ$8,$B$28:$M$34,6)","v":161},{"$f":"HLOOKUP($AJ$9,$B$28:$M$34,6)","v":161},null,null,null,null,null,null,null,"Type 4",{"$f":"IF(AF40=AF41,AF40,FORECAST($AJ$5,AF40:AF41,AB40:AB41))","v":{"$error":"#NUM!"}},{"$f":"IF(AB38=AB39,AF38,FORECAST($AJ$6,AF38:AF39,AB38:AB39))","v":{"$error":"#NUM!"}},500]
[265,171,162,160,158,154,151,151,152,151,150,147,144,null,null,{"$f":"A34","v":265},171,{"$f":"AVERAGE(C34:G34)","v":157},{"$f":"AVERAGE(G34:I34)","v":151.33333333333334},{"$f":"AVERAGE(I34:K34)","v":151},{"$f":"AVERAGE(K34:M34)","v":147},null,null,265,{"$f":"HLOOKUP($AJ$8,$B$28:$M$34,7)","v":171},{"$f":"HLOOKUP($AJ$9,$B$28:$M$34,7)","v":171},null,null,null,null,null,null,null,"Type 5",{"$f":"IF(AF49=AF50,AF49,FORECAST($AJ$5,AF49:AF50,AB49:AB50))","v":{"$error":"#NUM!"}},{"$f":"IF(AB47=AB48,AF47,FORECAST($AJ$6,AF47:AF48,AB47:AB48))","v":{"$error":"#NUM!"}},500]
[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,"Type 6",{"$f":"IF(AF59=AF60,AF59,FORECAST($AJ$5,AF59:AF60,AB59:AB60))","v":{"$error":"#NUM!"}},{"$f":"IF(AB57=AB58,AF57,FORECAST($AJ$6,AF57:AF58,AB57:AB58))","v":{"$error":"#NUM!"}},500]
["Type 4","Outlet Pressures: Inlet Pressure [psig] vs. Flow Rate [GPM]",null,null,null,null,null,null,null,null,null,null,null,null,"Type 4","Inlet vs. Outlet Pressure Over Flow Range",null,null,null,null,null,null,"Type 4",null,null,null,null,null,null,null,null,null,null,"Type 7",{"$f":"IF(AF70=AF71,AF70,FORECAST($AJ$5,AF70:AF71,AB70:AB71))","v":{"$error":"#NUM!"}},{"$f":"IF(AB68=AB69,AF68,FORECAST($AJ$6,AF68:AF69,AB68:AB69))","v":{"$error":"#NUM!"}},500]
["Inlet Pressure (psig)",0,50,75,100,150,200,250,300,350,400,450,500,null,null,null,"Static","50-200 [GPM]","200-300 [GPM]","300-400 [GPM]","400-500 [GPM]",null,null,null,{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$8& \" GPM\")","v":"Outlet Residual @ 0 GPM"},{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$9& \" GPM\")","v":"Outlet Residual @ 0 GPM"},null,null,"Const. PRI Interpolated @ Var. Flow"]
[50,27,23,24,23,24,22,20,19,null,null,null,null,null,"Inlet Pressure (psig)",{"$f":"A38","v":50},{"$f":"B38","v":27},{"$f":"AVERAGE(C38:G38)","v":23.2},{"$f":"AVERAGE(G38:I38)","v":20.333333333333332},{"$f":"AVERAGE(I38:K38)","v":19},null,null,"Inlet Pressure (psig)",{"$f":"A38","v":50},{"$f":"HLOOKUP($AJ$8,$B$37:$M$43,2)","v":27},{"$f":"HLOOKUP($AJ$9,$B$37:$M$43,2)","v":27},"PRI1:",{"$f":"LARGE(A38:A43,COUNTIF(A38:A43,\">\" &$AJ$6)+1)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB38,X38:Z43,2)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB38,X38:Z43,3)","v":{"$error":"#NUM!"}},"PRO1:",{"$f":"IF(AC38=AD38,AC38, FORECAST($AJ$7,AC38:AD38,$AJ$8:$AJ$9))","v":{"$error":"#NUM!"}}]
[100,57,50,50,48,49,48,47,46,44,42,38,37,null,null,{"$f":"A39","v":100},{"$f":"B39","v":57},{"$f":"AVERAGE(C39:G39)","v":49},{"$f":"AVERAGE(G39:I39)","v":47},{"$f":"AVERAGE(I39:K39)","v":44},{"$f":"AVERAGE(K39:M39)","v":39},null,null,100,{"$f":"HLOOKUP($AJ$8,$B$37:$M$43,3)","v":57},{"$f":"HLOOKUP($AJ$9,$B$37:$M$43,3)","v":57},"PRI2:",{"$f":"SMALL(A38:A43,COUNTIF(A38:A43,\"<\"&$AJ$6)+1)","v":50},{"$f":"VLOOKUP(AB39,X38:Z43,2)","v":27},{"$f":"VLOOKUP(AB39,X38:Z43,3)","v":27},"PRO2:",{"$f":"IF(AC39=AD39, AC39, FORECAST($AJ$7,AC39:AD39,$AJ$8:$AJ$9))","v":27}]
[150,87,77,76,74,72,74,73,68,71,67,65,62,null,null,{"$f":"A40","v":150},87,{"$f":"AVERAGE(C40:G40)","v":74.599999999999994},71.666666666666671,68.666666666666671,64.666666666666671,null,null,150,{"$f":"HLOOKUP($AJ$8,$B$37:$M$43,4)","v":87},{"$f":"HLOOKUP($AJ$9,$B$37:$M$43,4)","v":87},"PSI1:",{"$f":"LARGE(A38:A43,COUNTIF(A38:A43,\">\" &$AJ$5)+1)","v":{"$error":"#NUM!"}},null,null,"PSO1:",{"$f":"VLOOKUP(AB40,A38:B43,2)","v":{"$error":"#NUM!"}}]
[200,118,105,104,102,100,96,101,98,98,96,93,91,null,null,{"$f":"A41","v":200},118,101.4,98.333333333333329,97.333333333333329,93.333333333333329,null,null,200,{"$f":"HLOOKUP($AJ$8,$B$37:$M$43,5)","v":118},{"$f":"HLOOKUP($AJ$9,$B$37:$M$43,5)","v":118},"PSI2:",{"$f":"SMALL(A38:A43,COUNTIF(A38:A43,\"<\"&$AJ$5)+1)","v":50},null,null,"PSO2:",{"$f":"VLOOKUP(AB41,A38:B43,2)","v":27}]
[250,146,134,132,130,127,122,120,124,126,122,119,117,null,null,{"$f":"A42","v":250},146,129,122,124,119.33333333333333,null,null,250,{"$f":"HLOOKUP($AJ$8,$B$37:$M$43,6)","v":146},{"$f":"HLOOKUP($AJ$9,$B$37:$M$43,6)","v":146}]
[300,175,165,160,160,154,149,146,142,148,147,146,143,null,null,{"$f":"A43","v":300},175,{"$f":"AVERAGE(C43:G43)","v":157.6},{"$f":"AVERAGE(G43:I43)","v":145.66666666666666},{"$f":"AVERAGE(I43:K43)","v":145.66666666666666},{"$f":"AVERAGE(K43:M43)","v":145.33333333333334},null,null,300,{"$f":"HLOOKUP($AJ$8,$B$37:$M$43,7)","v":175},{"$f":"HLOOKUP($AJ$9,$B$37:$M$43,7)","v":175}]
[]
["Type 5","Outlet Pressures: Inlet Pressure [psig] vs. Flow Rate [GPM]",null,null,null,null,null,null,null,null,null,null,null,null,"Type 5","Inlet vs. Outlet Pressure Over Flow Range",null,null,null,null,null,null,"Type 5"]
["Inlet Pressure (psig)",0,50,75,100,150,200,250,300,350,400,450,500,null,null,null,"Static","50-200 [GPM]","200-300 [GPM]","300-400 [GPM]","400-500 [GPM]",null,null,null,{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$8& \" GPM\")","v":"Outlet Residual @ 0 GPM"},{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$9& \" GPM\")","v":"Outlet Residual @ 0 GPM"},null,null,"Const. PRI Interpolated @ Var. Flow"]
[50,30,22,22,23,21,20,20,null,null,null,null,null,null,"Inlet Pressure (psig)",{"$f":"A47","v":50},{"$f":"B47","v":30},{"$f":"AVERAGE(C47:G47)","v":21.6},{"$f":"AVERAGE(G47:I47)","v":20},null,null,null,"Inlet Pressure (psig)",{"$f":"A47","v":50},{"$f":"HLOOKUP($AJ$8,$B$46:$M$53,2)","v":30},{"$f":"HLOOKUP($AJ$9,$B$46:$M$53,2)","v":30},"PRI1:",{"$f":"LARGE(A47:A53,COUNTIF(A47:A53,\">\" &$AJ$6)+1)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB47,X47:Z52,2)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB47,X47:Z52,3)","v":{"$error":"#NUM!"}},"PRO1:",{"$f":"IF(AC47=AD47,AC47, FORECAST($AJ$7,AC47:AD47,$AJ$8:$AJ$9))","v":{"$error":"#NUM!"}}]
[100,53,46,46,45,44,44,44,42,40,37,35,34,null,null,{"$f":"A48","v":100},{"$f":"B48","v":53},{"$f":"AVERAGE(C48:G48)","v":45},{"$f":"AVERAGE(G48:I48)","v":43.333333333333336},{"$f":"AVERAGE(I48:K48)","v":39.666666666666664},{"$f":"AVERAGE(K48:M48)","v":35.333333333333336},null,null,100,{"$f":"HLOOKUP($AJ$8,$B$46:$M$53,3)","v":53},{"$f":"HLOOKUP($AJ$9,$B$46:$M$53,3)","v":53},"PRI2:",{"$f":"SMALL(A47:A53,COUNTIF(A47:A53,\"<\"&$AJ$6)+1)","v":50},{"$f":"VLOOKUP(AB48,X47:Z52,2)","v":30},{"$f":"VLOOKUP(AB48,X47:Z52,3)","v":30},"PRO2:",{"$f":"IF(AC48=AD48, AC48, FORECAST($AJ$7,AC48:AD48,$AJ$8:$AJ$9))","v":30}]
[150,80,71,70,69,66,66,68,67,64,62,59,57,null,null,150,80,{"$f":"AVERAGE(C49:G49)","v":68.400000000000006},67,64.333333333333329,59.333333333333336,null,null,150,{"$f":"HLOOKUP($AJ$8,$B$46:$M$53,4)","v":80},{"$f":"HLOOKUP($AJ$9,$B$46:$M$53,4)","v":80},"PSI1:",{"$f":"LARGE(A47:A53,COUNTIF(A47:A53,\">\" &$AJ$5)+1)","v":{"$error":"#NUM!"}},null,null,"PSO1:",{"$f":"VLOOKUP(AB49,A47:B53,2)","v":{"$error":"#NUM!"}}]
[200,108,97,96,93,91,87,88,91,89,86,84,80,null,null,200,108,92.8,88.666666666666671,88.666666666666671,83.333333333333329,null,null,200,{"$f":"HLOOKUP($AJ$8,$B$46:$M$53,5)","v":108},{"$f":"HLOOKUP($AJ$9,$B$46:$M$53,5)","v":108},"PSI2:",{"$f":"SMALL(A47:A53,COUNTIF(A47:A53,\"<\"&$AJ$5)+1)","v":50},null,null,"PSO2:",{"$f":"VLOOKUP(AB50,A47:B53,2)","v":30}]
[250,136,124,121,119,118,115,108,107,112,110,108,105,null,null,250,136,119.4,110,109.66666666666667,107.66666666666667,null,null,250,{"$f":"HLOOKUP($AJ$8,$B$46:$M$53,6)","v":136},{"$f":"HLOOKUP($AJ$9,$B$46:$M$53,6)","v":136}]
[300,163,153,150,146,141,136,133,129,124,133,131,126,null,null,300,163,145.19999999999999,132.66666666666666,128.66666666666666,130,null,null,300,{"$f":"HLOOKUP($AJ$8,$B$46:$M$53,7)","v":163},{"$f":"HLOOKUP($AJ$9,$B$46:$M$53,7)","v":163}]
[320,172,163,162,158,152,148,145,140,136,135,139,138,null,null,320,{"$f":"B53","v":172},{"$f":"AVERAGE(C53:G53)","v":156.6},{"$f":"AVERAGE(G53:I53)","v":144.33333333333334},{"$f":"AVERAGE(I53:K53)","v":137},{"$f":"AVERAGE(K53:M53)","v":137.33333333333334},null,null,320,{"$f":"HLOOKUP($AJ$8,$B$46:$M$53,8)","v":172},{"$f":"HLOOKUP($AJ$9,$B$46:$M$53,8)","v":172}]
[]
["Type 6","Outlet Pressures: Inlet Pressure [psig] vs. Flow Rate [GPM]",null,null,null,null,null,null,null,null,null,null,null,null,"Type 6","Inlet vs. Outlet Pressure Over Flow Range",null,null,null,null,null,null,"Type 6"]
["Inlet Pressure (psig)",0,50,75,100,150,200,250,300,350,400,450,500,null,null,null,"Static","50-200 [GPM]","200-300 [GPM]","300-400 [GPM]","400-500 [GPM]",null,null,null,{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$8& \" GPM\")","v":"Outlet Residual @ 0 GPM"},{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$9& \" GPM\")","v":"Outlet Residual @ 0 GPM"},null,null,"Const. PRI Interpolated @ Var. Flow"]
[50,24,17,16,14,17,16,15,null,null,null,null,null,null,"Inlet Pressure (psig)",{"$f":"A57","v":50},{"$f":"B57","v":24},{"$f":"AVERAGE(C57:G57)","v":16},{"$f":"AVERAGE(G57:I57)","v":15.5},null,null,null,"Inlet Pressure (psig)",{"$f":"A57","v":50},{"$f":"HLOOKUP($AJ$8,$B$56:$M$64,2)","v":24},{"$f":"HLOOKUP($AJ$9,$B$56:$M$64,2)","v":24},"PRI1:",{"$f":"LARGE(A57:A64,COUNTIF(A57:A64,\">\" &$AJ$6)+1)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB57,X57:Z62,2)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB57,X57:Z62,3)","v":{"$error":"#NUM!"}},"PRO1:",{"$f":"IF(AC57=AD57,AC57, FORECAST($AJ$7,AC57:AD57,$AJ$8:$AJ$9))","v":{"$error":"#NUM!"}}]
[100,46,38,37,36,34,34,35,34,32,29,28,null,null,null,{"$f":"A58","v":100},{"$f":"B58","v":46},{"$f":"AVERAGE(C58:G58)","v":35.799999999999997},{"$f":"AVERAGE(G58:I58)","v":34.333333333333336},{"$f":"AVERAGE(I58:K58)","v":31.666666666666668},{"$f":"AVERAGE(K58:M58)","v":28.5},null,null,100,{"$f":"HLOOKUP($AJ$8,$B$56:$M$64,3)","v":46},{"$f":"HLOOKUP($AJ$9,$B$56:$M$64,3)","v":46},"PRI2:",{"$f":"SMALL(A57:A64,COUNTIF(A57:A64,\"<\"&$AJ$6)+1)","v":50},{"$f":"VLOOKUP(AB58,X57:Z62,2)","v":24},{"$f":"VLOOKUP(AB58,X57:Z62,3)","v":24},"PRO2:",{"$f":"IF(AC58=AD58, AC58, FORECAST($AJ$7,AC58:AD58,$AJ$8:$AJ$9))","v":24}]
[150,70,60,60,58,52,51,52,52,52,50,47,43,null,null,{"$f":"A59","v":150},70,{"$f":"AVERAGE(C59:G59)","v":56.2},51.666666666666664,51.333333333333336,46.666666666666664,null,null,150,{"$f":"HLOOKUP($AJ$8,$B$56:$M$64,4)","v":70},{"$f":"HLOOKUP($AJ$9,$B$56:$M$64,4)","v":70},"PSI1:",{"$f":"LARGE(A57:A64,COUNTIF(A57:A64,\">\" &$AJ$5)+1)","v":{"$error":"#NUM!"}},null,null,"PSO1:",{"$f":"VLOOKUP(AB59,A57:B64,2)","v":{"$error":"#NUM!"}}]
[200,93,84,82,80,76,72,70,69,70,69,68,65,null,null,{"$f":"A60","v":200},93,78.8,70.333333333333329,69.333333333333329,67.333333333333329,null,null,200,{"$f":"HLOOKUP($AJ$8,$B$56:$M$64,5)","v":93},{"$f":"HLOOKUP($AJ$9,$B$56:$M$64,5)","v":93},"PSI2:",{"$f":"SMALL(A57:A64,COUNTIF(A57:A64,\"<\"&$AJ$5)+1)","v":50},null,null,"PSO2:",{"$f":"VLOOKUP(AB60,A57:B64,2)","v":24}]
[250,118,106,103,102,98,97,91,88,86,85,86,87,null,null,{"$f":"A61","v":250},118,101.2,92,86.333333333333329,86,null,null,250,{"$f":"HLOOKUP($AJ$8,$B$56:$M$64,6)","v":118},{"$f":"HLOOKUP($AJ$9,$B$56:$M$64,6)","v":118}]
[300,140,127,128,128,123,119,115,110,106,104,104,104,null,null,{"$f":"A62","v":300},140,125,114.66666666666667,106.66666666666667,104,null,null,300,{"$f":"HLOOKUP($AJ$8,$B$56:$M$64,7)","v":140},{"$f":"HLOOKUP($AJ$9,$B$56:$M$64,7)","v":140}]
[350,166,157,154,153,146,144,138,137,138,126,121,123,null,null,{"$f":"A63","v":350},{"$f":"B63","v":166},{"$f":"AVERAGE(C63:G63)","v":150.80000000000001},{"$f":"AVERAGE(G63:I63)","v":139.66666666666666},{"$f":"AVERAGE(I63:K63)","v":133.66666666666666},{"$f":"AVERAGE(K63:M63)","v":123.33333333333333},null,null,350,{"$f":"HLOOKUP($AJ$8,$B$56:$M$64,8)","v":166},{"$f":"HLOOKUP($AJ$9,$B$56:$M$64,8)","v":166}]
[360,171,163,161,158,156,151,148,143,140,134,131,128,null,null,360,171,157.80000000000001,147.33333333333334,139,131,null,null,360,{"$f":"HLOOKUP($AJ$8,$B$56:$M$64,9)","v":171},{"$f":"HLOOKUP($AJ$9,$B$56:$M$64,9)","v":171}]
[]
["Type 7","Outlet Pressures: Inlet Pressure [psig] vs. Flow Rate [GPM]",null,null,null,null,null,null,null,null,null,null,null,null,"Type 7","Inlet vs. Outlet Pressure Over Flow Range",null,null,null,null,null,null,"Type 7"]
["Inlet Pressure (psig)",0,50,75,100,150,200,250,300,350,400,450,500,null,null,null,"Static","50-200 [GPM]","200-300 [GPM]","300-400 [GPM]","400-500 [GPM]",null,null,null,{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$8& \" GPM\")","v":"Outlet Residual @ 0 GPM"},{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$9& \" GPM\")","v":"Outlet Residual @ 0 GPM"},null,null,"Const. PRI Interpolated @ Var. Flow"]
[50,19,14,14,14,14,13,null,null,null,null,null,null,null,"Inlet Pressure (psig)",{"$f":"A68","v":50},{"$f":"B68","v":19},{"$f":"AVERAGE(C68:G68)","v":13.8},{"$f":"AVERAGE(G68:I68)","v":13},null,null,null,"Inlet Pressure (psig)",{"$f":"A68","v":50},{"$f":"HLOOKUP($AJ$8,$B$67:$M$75,2)","v":19},{"$f":"HLOOKUP($AJ$9,$B$67:$M$75,2)","v":19},"PRI1:",{"$f":"LARGE(A68:A75,COUNTIF(A68:A75,\">\" &$AJ$6)+1)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB68,X68:Z73,2)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB68,X68:Z73,3)","v":{"$error":"#NUM!"}},"PRO1:",{"$f":"IF(AC68=AD68,AC68, FORECAST($AJ$7,AC68:AD68,$AJ$8:$AJ$9))","v":{"$error":"#NUM!"}}]
[100,40,30,29,29,29,29,28,27,25,23,null,null,null,null,{"$f":"A69","v":100},{"$f":"B69","v":40},{"$f":"AVERAGE(C69:G69)","v":29.2},{"$f":"AVERAGE(G69:I69)","v":28},{"$f":"AVERAGE(I69:K69)","v":25},{"$f":"AVERAGE(K69:M69)","v":23},null,null,100,{"$f":"HLOOKUP($AJ$8,$B$67:$M$75,3)","v":40},{"$f":"HLOOKUP($AJ$9,$B$67:$M$75,3)","v":40},"PRI2:",{"$f":"SMALL(A68:A75,COUNTIF(A68:A75,\"<\"&$AJ$6)+1)","v":50},{"$f":"VLOOKUP(AB69,X68:Z73,2)","v":19},{"$f":"VLOOKUP(AB69,X68:Z73,3)","v":19},"PRO2:",{"$f":"IF(AC69=AD69, AC69, FORECAST($AJ$7,AC69:AD69,$AJ$8:$AJ$9))","v":19}]
[150,64,51,47,46,44,42,45,44,43,40,37,36,null,null,{"$f":"A70","v":150},64,{"$f":"AVERAGE(C70:G70)","v":46},43.666666666666664,42.333333333333336,37.666666666666664,null,null,150,{"$f":"HLOOKUP($AJ$8,$B$67:$M$75,4)","v":64},{"$f":"HLOOKUP($AJ$9,$B$67:$M$75,4)","v":64},"PSI1:",{"$f":"LARGE(A68:A75,COUNTIF(A68:A75,\">\" &$AJ$5)+1)","v":{"$error":"#NUM!"}},null,null,"PSO1:",{"$f":"VLOOKUP(AB70,A68:B75,2)","v":{"$error":"#NUM!"}}]
[200,85,73,71,66,60,58,59,58,59,57,55,51,null,null,{"$f":"A71","v":200},85,65.599999999999994,58.333333333333336,58,54.333333333333336,null,null,200,{"$f":"HLOOKUP($AJ$8,$B$67:$M$75,5)","v":85},{"$f":"HLOOKUP($AJ$9,$B$67:$M$75,5)","v":85},"PSI2:",{"$f":"SMALL(A68:A75,COUNTIF(A68:A75,\"<\"&$AJ$5)+1)","v":50},null,null,"PSO2:",{"$f":"VLOOKUP(AB71,A68:B75,2)","v":19}]
[250,107,95,94,91,85,77,75,74,73,73,72,70,null,null,{"$f":"A72","v":250},107,88.4,75.333333333333329,73.333333333333329,71.666666666666671,null,null,250,{"$f":"HLOOKUP($AJ$8,$B$67:$M$75,6)","v":107},{"$f":"HLOOKUP($AJ$9,$B$67:$M$75,6)","v":107}]
[300,127,120,117,115,111,103,97,94,90,91,92,92,null,null,{"$f":"A73","v":300},127,113.2,98,91.666666666666671,91.666666666666671,null,null,300,{"$f":"HLOOKUP($AJ$8,$B$67:$M$75,7)","v":127},{"$f":"HLOOKUP($AJ$9,$B$67:$M$75,7)","v":127}]
[350,148,142,138,139,135,130,121,115,112,109,109,110,null,null,{"$f":"A74","v":350},{"$f":"B74","v":148},{"$f":"AVERAGE(C74:G74)","v":136.80000000000001},{"$f":"AVERAGE(G74:I74)","v":122},{"$f":"AVERAGE(I74:K74)","v":112},{"$f":"AVERAGE(K74:M74)","v":109.33333333333333},null,null,350,{"$f":"HLOOKUP($AJ$8,$B$67:$M$75,8)","v":148},{"$f":"HLOOKUP($AJ$9,$B$67:$M$75,8)","v":148}]
[400,171,164,163,159,156,149,146,135,132,131,127,127,null,null,400,171,158.19999999999999,143.33333333333334,132.66666666666666,128.33333333333334,null,null,400,{"$f":"HLOOKUP($AJ$8,$B$67:$M$75,9)","v":171},{"$f":"HLOOKUP($AJ$9,$B$67:$M$75,9)","v":171}]

{"sheet":"2.5_Straight","index":4,"n_rows":75,"n_cols":37,"rows_kept":75,"cut":false,"hidden":true,"merged":[[2,15,2,20],[54,1,54,12],[65,1,65,12],[2,1,2,12],[10,1,10,12],[18,1,18,12],[26,1,26,12],[35,1,35,12],[44,1,44,12],[12,14,16,14],[20,14,24,14],[10,15,10,20],[18,15,18,20],[4,14,8,14],[28,14,32,14],[37,14,41,14],[67,14,71,14],[54,15,54,20],[65,15,65,20],[26,15,26,20],[35,15,35,20],[44,15,44,20],[46,14,50,14],[56,14,60,14],[3,28,3,29],[3,33,3,35],[4,22,8,22],[11,28,11,29],[12,22,16,22],[19,28,19,29],[20,22,24,22],[27,28,27,29],[28,22,32,22],[36,28,36,29],[66,28,66,29],[67,22,71,22],[37,22,41,22],[45,28,45,29],[46,22,50,22],[55,28,55,29],[56,22,60,22]]}
["2.5\" Straight Body - Outlet Pressures @ Flow Rate"]
["Data compiled from Project No. 12CA5765 - EX5549. Published 13-Nov-2013. Values with blank data indicate pumps were unable to meet required specifications."]
["Type 0","Outlet Pressures @ Flow Rate, GPM",null,null,null,null,null,null,null,null,null,null,null,null,"Type 0","Inlet vs. Outlet Pressure Over Flow Range",null,null,null,null,null,null,"Type 0"]
["Inlet Pressure (psig)",0,50,100,150,175,200,250,300,350,400,450,500,null,null,null,"Static","50-200 [GPM]","200-300 [GPM]","300-400 [GPM]","400-500 [GPM]",null,null,null,{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$8& \" GPM\")","v":"Outlet Residual @ 0 GPM"},{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$9& \" GPM\")","v":"Outlet Residual @ 0 GPM"},null,null,"Const. PRI Interpolated @ Var. Flow",null,null,null,null,"Variables:"]
[50,41,35,36,29,26,23,16,null,null,null,null,null,null,"Inlet Pressure (psig)",{"$f":"A5","v":50},{"$f":"B5","v":41},{"$f":"AVERAGE(C5:G5)","v":29.8},{"$f":"AVERAGE(G5:I5)","v":19.5},null,null,null,"Inlet Pressure (psig)",{"$f":"A5","v":50},{"$f":"HLOOKUP($AJ$8,$B$4:$M$9,2)","v":41},{"$f":"HLOOKUP($AJ$9,$B$4:$M$9,2)","v":41},"PRI1:",{"$f":"LARGE(A5:A9,COUNTIF(A5:A9,\">\" &$AJ$6)+1)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB5,X5:Z9,2)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB5,X5:Z9,3)","v":{"$error":"#NUM!"}},"PRO1:",{"$f":"IF(AJ8=AJ9, AC5, FORECAST(AJ7,$AC$5:$AD$5,$AJ$8:$AJ$9))","v":{"$error":"#NUM!"}},null,"Static Inlet Pressure","PSI:",{"$f":"Database!$B$2","v":0}]
[100,83,74,69,68,68,63,55,46,36,22,null,null,null,null,{"$f":"A6","v":100},{"$f":"B6","v":83},{"$f":"AVERAGE(C6:G6)","v":68.400000000000006},{"$f":"AVERAGE(G6:I6)","v":54.666666666666664},{"$f":"AVERAGE(I6:K6)","v":34.666666666666664},{"$f":"AVERAGE(K6:M6)","v":22},null,null,{"$f":"A6","v":100},{"$f":"HLOOKUP($AJ$8,$B$4:$M$9,3)","v":83},{"$f":"HLOOKUP($AJ$9,$B$4:$M$9,3)","v":83},"PRI2:",{"$f":"SMALL(A5:A9,COUNTIF(A5:A9,\"<\"&$AJ$6)+1)","v":50},{"$f":"VLOOKUP(AB6,X5:Z9,2)","v":41},{"$f":"VLOOKUP(AB6,X5:Z9,3)","v":41},"PRO2:",{"$f":"IF(AJ8=AJ9, AC6, FORECAST($AJ$7,$AC$6:$AD$6,$AJ$8:$AJ$9))","v":41},null,"Residual Inlet Pressure ","PRI:",{"$f":"Database!$B$3","v":0}]
[150,122,114,106,105,105,105,99,86,74,64,45,null,null,null,{"$f":"A7","v":150},122,{"$f":"AVERAGE(C7:G7)","v":107},96.666666666666671,74.666666666666671,{"$f":"AVERAGE(K7:M7)","v":54.5},null,null,{"$f":"A7","v":150},{"$f":"HLOOKUP($AJ$8,$B$4:$M$9,4)","v":122},{"$f":"HLOOKUP($AJ$9,$B$4:$M$9,4)","v":122},"PSI1:",{"$f":"LARGE(A5:A9,COUNTIF(A5:A9,\">\" &$AJ$5)+1)","v":{"$error":"#NUM!"}},null,null,"PSO1:",{"$f":"VLOOKUP(AB7,A5:B9,2)","v":{"$error":"#NUM!"}},null,"Flow Rate","Q0:",{"$f":"IF(Database!$B$4=500, 499.99, Database!$B$4)","v":0}]
[200,164,149,143,139,138,140,132,123,113,98,88,76,null,null,{"$f":"A8","v":200},164,141.80000000000001,131.66666666666666,111.33333333333333,{"$f":"AVERAGE(K8:M8)","v":87.333333333333329},null,null,{"$f":"A8","v":200},{"$f":"HLOOKUP($AJ$8,$B$4:$M$9,5)","v":164},{"$f":"HLOOKUP($AJ$9,$B$4:$M$9,5)","v":164},"PSI2:",{"$f":"SMALL(A5:A9,COUNTIF(A5:A9,\"<\"&$AJ$5)+1)","v":50},null,null,"PSO2:",{"$f":"VLOOKUP(AB8,A5:B9,2)","v":41},null,"Nearest Known Flow Rate, 1","Q1:",{"$f":"LARGE(B4:M4,COUNTIF(B4:M4,\">\" &AJ7)+1)","v":0}]
[210,171,157,150,147,148,150,142,131,120,107,94,80,null,null,{"$f":"A9","v":210},171,150.4,141,119.33333333333333,{"$f":"AVERAGE(K9:M9)","v":93.666666666666671},null,null,{"$f":"A9","v":210},{"$f":"HLOOKUP($AJ$8,$B$4:$M$9,6)","v":171},{"$f":"HLOOKUP($AJ$9,$B$4:$M$9,6)","v":171},null,null,null,null,null,null,null,"Nearest Known Flow Rate, 2","Q2:",{"$f":"SMALL(B4:M4,COUNTIF(B4:M4,\"<\"&AJ7)+1)","v":0}]
[]
["Type 1","Outlet Pressures @ Flow Rate, GPM",null,null,null,null,null,null,null,null,null,null,null,null,"Type 1","Inlet vs. Outlet Pressure Over Flow Range",null,null,null,null,null,null,"Type 1"]
["Inlet Pressure (psig)",0,50,100,150,175,200,250,300,350,400,450,500,null,null,null,"Static","50-200 [GPM]","200-300 [GPM]","300-400 [GPM]","400-500 [GPM]",null,null,null,{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$8& \" GPM\")","v":"Outlet Residual @ 0 GPM"},{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$9& \" GPM\")","v":"Outlet Residual @ 0 GPM"},null,null,"Const. PRI Interpolated @ Var. Flow"]
[50,38,32,31,27,23,21,12,null,null,null,null,null,null,"Inlet Pressure (psig)",{"$f":"A13","v":50},{"$f":"B13","v":38},{"$f":"AVERAGE(C13:G13)","v":26.8},{"$f":"AVERAGE(G13:I13)","v":16.5},null,null,null,"Inlet Pressure (psig)",{"$f":"A13","v":50},{"$f":"HLOOKUP($AJ$8,$B$12:$M$17,2)","v":38},{"$f":"HLOOKUP($AJ$9,$B$12:$M$17,2)","v":38},"PRI1:",{"$f":"LARGE(A13:A17,COUNTIF(A13:A17,\">\" &$AJ$6)+1)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB13,X13:Z17,2)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB13,X13:Z17,3)","v":{"$error":"#NUM!"}},"PRO1:",{"$f":"IF(AC13=AD13,AC13, FORECAST($AJ$7,AC13:AD13,$AJ$8:$AJ$9))","v":{"$error":"#NUM!"}}]
[100,72,66,65,62,60,56,48,36,24,null,null,null,null,null,{"$f":"A14","v":100},{"$f":"B14","v":72},{"$f":"AVERAGE(C14:G14)","v":61.8},{"$f":"AVERAGE(G14:I14)","v":46.666666666666664},{"$f":"AVERAGE(I14:K14)","v":30},null,null,null,{"$f":"A14","v":100},{"$f":"HLOOKUP($AJ$8,$B$12:$M$17,3)","v":72},{"$f":"HLOOKUP($AJ$9,$B$12:$M$17,3)","v":72},"PRI2:",{"$f":"SMALL(A13:A17,COUNTIF(A13:A17,\"<\"&$AJ$6)+1)","v":50},{"$f":"VLOOKUP(AB14,X13:Z17,2)","v":38},{"$f":"VLOOKUP(AB14,X13:Z17,3)","v":38},"PRO2:",{"$f":"IF(AC14=AD14, AC14, FORECAST($AJ$7,AC14:AD14,$AJ$8:$AJ$9))","v":38}]
[150,112,103,97,99,95,93,83,73,62,46,null,null,null,null,{"$f":"A15","v":150},112,{"$f":"AVERAGE(C15:G15)","v":97.4},83,60.333333333333336,{"$f":"AVERAGE(K15:M15)","v":46},null,null,{"$f":"A15","v":150},{"$f":"HLOOKUP($AJ$8,$B$12:$M$17,4)","v":112},{"$f":"HLOOKUP($AJ$9,$B$12:$M$17,4)","v":112},"PSI1:",{"$f":"LARGE(A13:A17,COUNTIF(A13:A17,\">\" &$AJ$5)+1)","v":{"$error":"#NUM!"}},null,null,"PSO1:",{"$f":"VLOOKUP(AB15,A13:B17,2)","v":{"$error":"#NUM!"}}]
[200,150,136,132,131,131,128,120,110,98,85,65,36,null,null,{"$f":"A16","v":200},150,131.6,119.33333333333333,97.666666666666671,62,null,null,{"$f":"A16","v":200},{"$f":"HLOOKUP($AJ$8,$B$12:$M$17,5)","v":150},{"$f":"HLOOKUP($AJ$9,$B$12:$M$17,5)","v":150},"PSI2:",{"$f":"SMALL(A13:A17,COUNTIF(A13:A17,\"<\"&$AJ$5)+1)","v":50},null,null,"PSO2:",{"$f":"VLOOKUP(AB16,A13:B17,2)","v":38}]
[220,165,151,147,145,144,144,135,125,114,100,83,60,null,null,{"$f":"A17","v":220},165,146.19999999999999,{"$f":"AVERAGE(G17:I17)","v":134.66666666666666},113,81,null,null,{"$f":"A17","v":220},{"$f":"HLOOKUP($AJ$8,$B$12:$M$17,6)","v":165},{"$f":"HLOOKUP($AJ$9,$B$12:$M$17,6)","v":165}]
[]
["Type 2","Outlet Pressures @ Flow Rate, GPM",null,null,null,null,null,null,null,null,null,null,null,null,"Type 2","Inlet vs. Outlet Pressure Over Flow Range",null,null,null,null,null,null,"Type 2"]
["Inlet Pressure (psig)",0,50,100,150,175,200,250,300,350,400,450,500,null,null,null,"Static","50-200 [GPM]","200-300 [GPM]","300-400 [GPM]","400-500 [GPM]",null,null,null,{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$8& \" GPM\")","v":"Outlet Residual @ 0 GPM"},{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$9& \" GPM\")","v":"Outlet Residual @ 0 GPM"},null,null,"Const. PRI Interpolated @ Var. Flow"]
[50,39,22,22,21,19,17,null,null,null,null,null,null,null,"Inlet Pressure (psig)",{"$f":"A21","v":50},{"$f":"B21","v":39},{"$f":"AVERAGE(C21:G21)","v":20.2},{"$f":"AVERAGE(G21:I21)","v":17},null,null,null,"Inlet Pressure (psig)",{"$f":"A21","v":50},{"$f":"HLOOKUP($AJ$8,$B$20:$M$25,2)","v":39},{"$f":"HLOOKUP($AJ$9,$B$20:$M$25,2)","v":39},"PRI1:",{"$f":"LARGE(A21:A25,COUNTIF(A21:A25,\">\" &$AJ$6)+1)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB21,X21:Z25,2)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB21,X21:Z25,3)","v":{"$error":"#NUM!"}},"PRO1:",{"$f":"IF(AC21=AD21,AC21, FORECAST($AJ$7,AC21:AD21,$AJ$8:$AJ$9))","v":{"$error":"#NUM!"}}]
[100,65,61,60,57,55,51,45,35,18,null,null,null,null,null,{"$f":"A22","v":100},{"$f":"B22","v":65},{"$f":"AVERAGE(C22:G22)","v":56.8},{"$f":"AVERAGE(G22:I22)","v":43.666666666666664},{"$f":"AVERAGE(I22:K22)","v":26.5},null,null,null,{"$f":"A22","v":100},{"$f":"HLOOKUP($AJ$8,$B$20:$M$25,3)","v":65},{"$f":"HLOOKUP($AJ$9,$B$20:$M$25,3)","v":65},"PRI2:",{"$f":"SMALL(A21:A25,COUNTIF(A21:A25,\"<\"&$AJ$6)+1)","v":50},{"$f":"VLOOKUP(AB22,X21:Z25,2)","v":39},{"$f":"VLOOKUP(AB22,X21:Z25,3)","v":39},"PRO2:",{"$f":"IF(AC22=AD22, AC22, FORECAST($AJ$7,AC22:AD22,$AJ$8:$AJ$9))","v":39}]
[150,106,91,91,92,92,89,84,70,61,43,null,null,null,null,{"$f":"A23","v":150},106,{"$f":"AVERAGE(C23:G23)","v":91},81,{"$f":"AVERAGE(I23:K23)","v":58},{"$f":"AVERAGE(K23:M23)","v":43},null,null,{"$f":"A23","v":150},{"$f":"HLOOKUP($AJ$8,$B$20:$M$25,4)","v":106},{"$f":"HLOOKUP($AJ$9,$B$20:$M$25,4)","v":106},"PSI1:",{"$f":"LARGE(A21:A25,COUNTIF(A21:A25,\">\" &$AJ$5)+1)","v":{"$error":"#NUM!"}},null,null,"PSO1:",{"$f":"VLOOKUP(AB23,A21:B25,2)","v":{"$error":"#NUM!"}}]
[200,142,132,123,127,126,123,116,106,95,81,63,0,null,null,{"$f":"A24","v":200},142,126.2,115,94,48,null,null,{"$f":"A24","v":200},{"$f":"HLOOKUP($AJ$8,$B$20:$M$25,5)","v":142},{"$f":"HLOOKUP($AJ$9,$B$20:$M$25,5)","v":142},"PSI2:",{"$f":"SMALL(A21:A25,COUNTIF(A21:A25,\"<\"&$AJ$5)+1)","v":50},null,null,"PSO2:",{"$f":"VLOOKUP(AB24,A21:B25,2)","v":39}]
[230,166,149,143,146,147,147,137,128,117,105,86,55,null,null,{"$f":"A25","v":230},166,146.4,137.33333333333334,{"$f":"AVERAGE(I25:K25)","v":116.66666666666667},82,null,null,{"$f":"A25","v":230},{"$f":"HLOOKUP($AJ$8,$B$20:$M$25,6)","v":166},{"$f":"HLOOKUP($AJ$9,$B$20:$M$25,6)","v":166}]
[]
["Type 3","Outlet Pressures @ Flow Rate, GPM",null,null,null,null,null,null,null,null,null,null,null,null,"Type 3","Inlet vs. Outlet Pressure Over Flow Range",null,null,null,null,null,null,"Type 3"]
["Inlet Pressure (psig)",0,50,100,150,175,200,250,300,350,400,450,500,null,null,null,"Static","50-200 [GPM]","200-300 [GPM]","300-400 [GPM]","400-500 [GPM]",null,null,null,{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$8& \" GPM\")","v":"Outlet Residual @ 0 GPM"},{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$9& \" GPM\")","v":"Outlet Residual @ 0 GPM"},null,null,"Const. PRI Interpolated @ Var. Flow",null,null,null,null,"2.5\" Inline","Calculated Static Outlet Pressure","Calculated Residual Outlet Pressure","Max Flow Rate"]
[50,33,27,27,21,19,16,null,null,null,null,null,null,null,"Inlet Pressure (psig)",{"$f":"A29","v":50},{"$f":"B29","v":33},{"$f":"AVERAGE(C29:G29)","v":22},{"$f":"AVERAGE(G29:I29)","v":16},null,null,null,"Inlet Pressure (psig)",{"$f":"A29","v":50},{"$f":"HLOOKUP($AJ$8,$B$28:$M$34,2)","v":33},{"$f":"HLOOKUP($AJ$9,$B$28:$M$34,2)","v":33},"PRI1:",{"$f":"LARGE(A29:A34,COUNTIF(A29:A34,\">\" &$AJ$6)+1)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB29,X29:Z34,2)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB29,X29:Z34,3)","v":{"$error":"#NUM!"}},"PRO1:",{"$f":"IF(AC29=AD29,AC29, FORECAST($AJ$7,AC29:AD29,$AJ$8:$AJ$9))","v":{"$error":"#NUM!"}},null,"Type 0",{"$f":"IF(AF7=AF8,AF7,FORECAST($AJ$5,AF7:AF8,AB7:AB8))","v":{"$error":"#NUM!"}},{"$f":"IF(AF5=AF6,AF5,FORECAST($AJ$6,AF5:AF6,AB5:AB6))","v":{"$error":"#NUM!"}},500]
[100,66,54,54,51,49,46,39,28,null,null,null,null,null,null,{"$f":"A30","v":100},{"$f":"B30","v":66},{"$f":"AVERAGE(C30:G30)","v":50.8},{"$f":"AVERAGE(G30:I30)","v":37.666666666666664},{"$f":"AVERAGE(I30:K30)","v":28},null,null,null,100,{"$f":"HLOOKUP($AJ$8,$B$28:$M$34,3)","v":66},{"$f":"HLOOKUP($AJ$9,$B$28:$M$34,3)","v":66},"PRI2:",{"$f":"SMALL(A29:A34,COUNTIF(A29:A34,\"<\"&$AJ$6)+1)","v":50},{"$f":"VLOOKUP(AB30,X29:Z34,2)","v":33},{"$f":"VLOOKUP(AB30,X29:Z34,3)","v":33},"PRO2:",{"$f":"IF(AC30=AD30, AC30, FORECAST($AJ$7,AC30:AD30,$AJ$8:$AJ$9))","v":33},null,"Type 1",{"$f":"IF(AF15=AF16,AF15,FORECAST($AJ$5,AF15:AF16,AB15:AB16))","v":{"$error":"#NUM!"}},{"$f":"IF(AB13=AB14,AF13,FORECAST($AJ$6,AF13:AF14,AB13:AB14))","v":{"$error":"#NUM!"}},500]
[150,98,80,81,82,80,77,69,61,48,32,null,null,null,null,{"$f":"A31","v":150},98,{"$f":"AVERAGE(C31:G31)","v":80},69,47,{"$f":"AVERAGE(K31:M31)","v":32},null,null,150,{"$f":"HLOOKUP($AJ$8,$B$28:$M$34,4)","v":98},{"$f":"HLOOKUP($AJ$9,$B$28:$M$34,4)","v":98},"PSI1:",{"$f":"LARGE(A29:A34,COUNTIF(A29:A34,\">\" &$AJ$5)+1)","v":{"$error":"#NUM!"}},null,null,"PSO1:",{"$f":"VLOOKUP(AB31,A29:B33,2)","v":{"$error":"#NUM!"}},null,"Type 2",{"$f":"IF(AF23=AF24,AF23,FORECAST($AJ$5,AF23:AF24,AB23:AB24))","v":{"$error":"#NUM!"}},{"$f":"IF(AB21=AB22,AF21,FORECAST($AJ$6,AF21:AF22,AB21:AB22))","v":{"$error":"#NUM!"}},500]
[200,130,110,106,108,109,107,100,91,81,66,43,null,null,null,{"$f":"A32","v":200},130,108,99.333333333333329,79.333333333333329,54.5,null,null,200,{"$f":"HLOOKUP($AJ$8,$B$28:$M$34,5)","v":130},{"$f":"HLOOKUP($AJ$9,$B$28:$M$34,5)","v":130},"PSI2:",{"$f":"SMALL(A29:A34,COUNTIF(A29:A34,\"<\"&$AJ$5)+1)","v":50},null,null,"PSO2:",{"$f":"VLOOKUP(AB32,A29:B33,2)","v":33},null,"Type 3",{"$f":"IF(AF31=AF32,AF31,FORECAST($AJ$5,AF31:AF32,AB31:AB32))","v":{"$error":"#NUM!"}},{"$f":"IF(AB29=AB30,AF29,FORECAST($AJ$6,AF29:AF30,AB29:AB30))","v":{"$error":"#NUM!"}},500]
[250,161,141,134,131,134,134,139,122,111,98,82,55,null,null,{"$f":"A33","v":250},161,134.80000000000001,131.66666666666666,110.33333333333333,78.333333333333329,null,null,250,{"$f":"HLOOKUP($AJ$8,$B$28:$M$34,6)","v":161},{"$f":"HLOOKUP($AJ$9,$B$28:$M$34,6)","v":161},null,null,null,null,null,null,null,"Type 4",{"$f":"IF(AF40=AF41,AF40,FORECAST($AJ$5,AF40:AF41,AB40:AB41))","v":{"$error":"#NUM!"}},{"$f":"IF(AB38=AB39,AF38,FORECAST($AJ$6,AF38:AF39,AB38:AB39))","v":{"$error":"#NUM!"}},500]
[265,173,153,143,140,139,143,138,130,120,106,93,70,null,null,{"$f":"A34","v":265},{"$f":"B34","v":173},{"$f":"AVERAGE(C34:G34)","v":143.6},{"$f":"AVERAGE(G34:I34)","v":137},{"$f":"AVERAGE(I34:K34)","v":118.66666666666667},{"$f":"AVERAGE(K34:M34)","v":89.666666666666671},null,null,265,{"$f":"HLOOKUP($AJ$8,$B$28:$M$34,7)","v":173},{"$f":"HLOOKUP($AJ$9,$B$28:$M$34,7)","v":173},null,null,null,null,null,null,null,"Type 5",{"$f":"IF(AF49=AF50,AF49,FORECAST($AJ$5,AF49:AF50,AB49:AB50))","v":{"$error":"#NUM!"}},{"$f":"IF(AB47=AB48,AF47,FORECAST($AJ$6,AF47:AF48,AB47:AB48))","v":{"$error":"#NUM!"}},500]
[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,"Type 6",{"$f":"IF(AF59=AF60,AF59,FORECAST($AJ$5,AF59:AF60,AB59:AB60))","v":{"$error":"#NUM!"}},{"$f":"IF(AB57=AB58,AF57,FORECAST($AJ$6,AF57:AF58,AB57:AB58))","v":{"$error":"#NUM!"}},500]
["Type 4","Outlet Pressures @ Flow Rate, GPM",null,null,null,null,null,null,null,null,null,null,null,null,"Type 4","Inlet vs. Outlet Pressure Over Flow Range",null,null,null,null,null,null,"Type 4",null,null,null,null,null,null,null,null,null,null,"Type 7",{"$f":"IF(AF70=AF71,AF70,FORECAST($AJ$5,AF70:AF71,AB70:AB71))","v":{"$error":"#NUM!"}},{"$f":"IF(AB68=AB69,AF68,FORECAST($AJ$6,AF68:AF69,AB68:AB69))","v":{"$error":"#NUM!"}},500]
["Inlet Pressure (psig)",0,50,100,150,175,200,250,300,350,400,450,500,null,null,null,"Static","50-200 [GPM]","200-300 [GPM]","300-400 [GPM]","400-500 [GPM]",null,null,null,{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$8& \" GPM\")","v":"Outlet Residual @ 0 GPM"},{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$9& \" GPM\")","v":"Outlet Residual @ 0 GPM"},null,null,"Const. PRI Interpolated @ Var. Flow"]
[50,26,21,21,17,16,12,null,null,null,null,null,null,null,"Inlet Pressure (psig)",{"$f":"A38","v":50},{"$f":"B38","v":26},{"$f":"AVERAGE(C38:G38)","v":17.399999999999999},{"$f":"AVERAGE(G38:I38)","v":12},null,null,null,"Inlet Pressure (psig)",{"$f":"A38","v":50},{"$f":"HLOOKUP($AJ$8,$B$37:$M$43,2)","v":26},{"$f":"HLOOKUP($AJ$9,$B$37:$M$43,2)","v":26},"PRI1:",{"$f":"LARGE(A38:A43,COUNTIF(A38:A43,\">\" &$AJ$6)+1)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB38,X38:Z43,2)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB38,X38:Z43,3)","v":{"$error":"#NUM!"}},"PRO1:",{"$f":"IF(AC38=AD38,AC38, FORECAST($AJ$7,AC38:AD38,$AJ$8:$AJ$9))","v":{"$error":"#NUM!"}}]
[100,54,44,45,44,41,38,31,18,null,null,null,null,null,null,{"$f":"A39","v":100},{"$f":"B39","v":54},{"$f":"AVERAGE(C39:G39)","v":42.4},{"$f":"AVERAGE(G39:I39)","v":29},{"$f":"AVERAGE(I39:K39)","v":18},null,null,null,100,{"$f":"HLOOKUP($AJ$8,$B$37:$M$43,3)","v":54},{"$f":"HLOOKUP($AJ$9,$B$37:$M$43,3)","v":54},"PRI2:",{"$f":"SMALL(A38:A43,COUNTIF(A38:A43,\"<\"&$AJ$6)+1)","v":50},{"$f":"VLOOKUP(AB39,X38:Z43,2)","v":26},{"$f":"VLOOKUP(AB39,X38:Z43,3)","v":26},"PRO2:",{"$f":"IF(AC39=AD39, AC39, FORECAST($AJ$7,AC39:AD39,$AJ$8:$AJ$9))","v":26}]
[150,83,66,65,69,67,65,57,48,33,null,null,null,null,null,{"$f":"A40","v":150},83,{"$f":"AVERAGE(C40:G40)","v":66.400000000000006},56.666666666666664,40.5,null,null,null,150,{"$f":"HLOOKUP($AJ$8,$B$37:$M$43,4)","v":83},{"$f":"HLOOKUP($AJ$9,$B$37:$M$43,4)","v":83},"PSI1:",{"$f":"LARGE(A38:A43,COUNTIF(A38:A43,\">\" &$AJ$5)+1)","v":{"$error":"#NUM!"}},null,null,"PSO1:",{"$f":"VLOOKUP(AB40,A38:B43,2)","v":{"$error":"#NUM!"}}]
[200,111,96,88,89,90,89,83,74,63,48,null,null,null,null,{"$f":"A41","v":200},111,90.4,82,{"$f":"AVERAGE(I41:K41)","v":61.666666666666664},{"$f":"AVERAGE(K41:M41)","v":48},null,null,200,{"$f":"HLOOKUP($AJ$8,$B$37:$M$43,5)","v":111},{"$f":"HLOOKUP($AJ$9,$B$37:$M$43,5)","v":111},"PSI2:",{"$f":"SMALL(A38:A43,COUNTIF(A38:A43,\"<\"&$AJ$5)+1)","v":50},null,null,"PSO2:",{"$f":"VLOOKUP(AB41,A38:B43,2)","v":26}]
[250,142,125,113,108,109,111,107,101,90,76,59,null,null,null,{"$f":"A42","v":250},142,113.2,106.33333333333333,89,{"$f":"AVERAGE(K42:M42)","v":67.5},null,null,250,{"$f":"HLOOKUP($AJ$8,$B$37:$M$43,6)","v":142},{"$f":"HLOOKUP($AJ$9,$B$37:$M$43,6)","v":142}]
[300,169,152,143,135,130,127,131,125,114,103,86,65,null,null,{"$f":"A43","v":300},{"$f":"B43","v":169},{"$f":"AVERAGE(C43:G43)","v":137.4},{"$f":"AVERAGE(G43:I43)","v":127.66666666666667},{"$f":"AVERAGE(I43:K43)","v":114},{"$f":"AVERAGE(K43:M43)","v":84.666666666666671},null,null,300,{"$f":"HLOOKUP($AJ$8,$B$37:$M$43,7)","v":169},{"$f":"HLOOKUP($AJ$9,$B$37:$M$43,7)","v":169}]
[]
["Type 5","Outlet Pressures @ Flow Rate, GPM",null,null,null,null,null,null,null,null,null,null,null,null,"Type 5","Inlet vs. Outlet Pressure Over Flow Range",null,null,null,null,null,null,"Type 5"]
["Inlet Pressure (psig)",0,50,100,150,175,200,250,300,350,400,450,500,null,null,null,"Static","50-200 [GPM]","200-300 [GPM]","300-400 [GPM]","400-500 [GPM]",null,null,null,{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$8& \" GPM\")","v":"Outlet Residual @ 0 GPM"},{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$9& \" GPM\")","v":"Outlet Residual @ 0 GPM"},null,null,"Const. PRI Interpolated @ Var. Flow"]
[50,32,19,18,16,13,11,null,null,null,null,null,null,null,"Inlet Pressure (psig)",{"$f":"A47","v":50},{"$f":"B47","v":32},{"$f":"AVERAGE(C47:G47)","v":15.4},{"$f":"AVERAGE(G47:I47)","v":11},null,null,null,"Inlet Pressure (psig)",{"$f":"A47","v":50},{"$f":"HLOOKUP($AJ$8,$B$46:$M$53,2)","v":32},{"$f":"HLOOKUP($AJ$9,$B$46:$M$53,2)","v":32},"PRI1:",{"$f":"LARGE(A47:A53,COUNTIF(A47:A53,\">\" &$AJ$6)+1)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB47,X47:Z52,2)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB47,X47:Z52,3)","v":{"$error":"#NUM!"}},"PRO1:",{"$f":"IF(AC47=AD47,AC47, FORECAST($AJ$7,AC47:AD47,$AJ$8:$AJ$9))","v":{"$error":"#NUM!"}}]
[100,52,40,41,40,38,36,28,17,null,null,null,null,null,null,{"$f":"A48","v":100},{"$f":"B48","v":52},{"$f":"AVERAGE(C48:G48)","v":39},{"$f":"AVERAGE(G48:I48)","v":27},{"$f":"AVERAGE(I48:K48)","v":17},null,null,null,100,{"$f":"HLOOKUP($AJ$8,$B$46:$M$53,3)","v":52},{"$f":"HLOOKUP($AJ$9,$B$46:$M$53,3)","v":52},"PRI2:",{"$f":"SMALL(A47:A53,COUNTIF(A47:A53,\"<\"&$AJ$6)+1)","v":50},{"$f":"VLOOKUP(AB48,X47:Z52,2)","v":32},{"$f":"VLOOKUP(AB48,X47:Z52,3)","v":32},"PRO2:",{"$f":"IF(AC48=AD48, AC48, FORECAST($AJ$7,AC48:AD48,$AJ$8:$AJ$9))","v":32}]
[150,77,62,60,61,60,58,53,43,29,null,null,null,null,null,{"$f":"A49","v":150},77,{"$f":"AVERAGE(C49:G49)","v":60.2},51.333333333333336,36,null,null,null,150,{"$f":"HLOOKUP($AJ$8,$B$46:$M$53,4)","v":77},{"$f":"HLOOKUP($AJ$9,$B$46:$M$53,4)","v":77},"PSI1:",{"$f":"LARGE(A47:A53,COUNTIF(A47:A53,\">\" &$AJ$5)+1)","v":{"$error":"#NUM!"}},null,null,"PSO1:",{"$f":"VLOOKUP(AB49,A47:B53,2)","v":{"$error":"#NUM!"}}]
[200,103,89,80,81,82,80,76,68,55,42,null,null,null,null,{"$f":"A50","v":200},103,82.4,74.666666666666671,55,{"$f":"AVERAGE(K50:M50)","v":42},null,null,200,{"$f":"HLOOKUP($AJ$8,$B$46:$M$53,5)","v":103},{"$f":"HLOOKUP($AJ$9,$B$46:$M$53,5)","v":103},"PSI2:",{"$f":"SMALL(A47:A53,COUNTIF(A47:A53,\"<\"&$AJ$5)+1)","v":50},null,null,"PSO2:",{"$f":"VLOOKUP(AB50,A47:B53,2)","v":32}]
[250,132,114,104,100,98,100,98,91,83,65,44,null,null,null,{"$f":"A51","v":250},132,103.2,96.333333333333329,79.666666666666671,54.5,null,null,250,{"$f":"HLOOKUP($AJ$8,$B$46:$M$53,6)","v":132},{"$f":"HLOOKUP($AJ$9,$B$46:$M$53,6)","v":132}]
[300,156,142,134,124,122,119,115,113,105,92,77,37,null,null,{"$f":"A52","v":300},{"$f":"B52","v":156},{"$f":"AVERAGE(C52:G52)","v":128.19999999999999},{"$f":"AVERAGE(G52:I52)","v":115.66666666666667},{"$f":"AVERAGE(I52:K52)","v":103.33333333333333},{"$f":"AVERAGE(K52:M52)","v":68.666666666666671},null,null,300,{"$f":"HLOOKUP($AJ$8,$B$46:$M$53,7)","v":156},{"$f":"HLOOKUP($AJ$9,$B$46:$M$53,7)","v":156}]
[320,164,155,146,137,132,126,119,120,113,102,85,62,null,null,320,164,139.19999999999999,121.66666666666667,111.66666666666667,83,null,null,320,{"$f":"HLOOKUP($AJ$8,$B$46:$M$53,8)","v":164},{"$f":"HLOOKUP($AJ$9,$B$46:$M$53,8)","v":164}]
[]
["Type 6","Outlet Pressures @ Flow Rate, GPM",null,null,null,null,null,null,null,null,null,null,null,null,"Type 6","Inlet vs. Outlet Pressure Over Flow Range",null,null,null,null,null,null,"Type 6"]
["Inlet Pressure (psig)",0,50,100,150,175,200,250,300,350,400,450,500,null,null,null,"Static","50-200 [GPM]","200-300 [GPM]","300-400 [GPM]","400-500 [GPM]",null,null,null,{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$8& \" GPM\")","v":"Outlet Residual @ 0 GPM"},{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$9& \" GPM\")","v":"Outlet Residual @ 0 GPM"},null,null,"Const. PRI Interpolated @ Var. Flow"]
[50,23,20,17,15,14,12,null,null,null,null,null,null,null,"Inlet Pressure (psig)",{"$f":"A57","v":50},{"$f":"B57","v":23},{"$f":"AVERAGE(C57:G57)","v":15.6},{"$f":"AVERAGE(G57:I57)","v":12},null,null,null,"Inlet Pressure (psig)",{"$f":"A57","v":50},{"$f":"HLOOKUP($AJ$8,$B$56:$M$64,2)","v":23},{"$f":"HLOOKUP($AJ$9,$B$56:$M$64,2)","v":23},"PRI1:",{"$f":"LARGE(A57:A64,COUNTIF(A57:A64,\">\" &$AJ$6)+1)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB57,X57:Z62,2)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB57,X57:Z62,3)","v":{"$error":"#NUM!"}},"PRO1:",{"$f":"IF(AC57=AD57,AC57, FORECAST($AJ$7,AC57:AD57,$AJ$8:$AJ$9))","v":{"$error":"#NUM!"}}]
[100,45,40,39,35,33,32,30,23,null,null,null,null,null,null,{"$f":"A58","v":100},{"$f":"B58","v":45},{"$f":"AVERAGE(C58:G58)","v":35.799999999999997},{"$f":"AVERAGE(G58:I58)","v":28.333333333333332},{"$f":"AVERAGE(I58:K58)","v":23},null,null,null,100,{"$f":"HLOOKUP($AJ$8,$B$56:$M$64,3)","v":45},{"$f":"HLOOKUP($AJ$9,$B$56:$M$64,3)","v":45},"PRI2:",{"$f":"SMALL(A57:A64,COUNTIF(A57:A64,\"<\"&$AJ$6)+1)","v":50},{"$f":"VLOOKUP(AB58,X57:Z62,2)","v":23},{"$f":"VLOOKUP(AB58,X57:Z62,3)","v":23},"PRO2:",{"$f":"IF(AC58=AD58, AC58, FORECAST($AJ$7,AC58:AD58,$AJ$8:$AJ$9))","v":23}]
[150,68,61,59,56,56,52,49,46,37,28,null,null,null,null,{"$f":"A59","v":150},68,{"$f":"AVERAGE(C59:G59)","v":56.8},49,37,{"$f":"AVERAGE(K59:M59)","v":28},null,null,150,{"$f":"HLOOKUP($AJ$8,$B$56:$M$64,4)","v":68},{"$f":"HLOOKUP($AJ$9,$B$56:$M$64,4)","v":68},"PSI1:",{"$f":"LARGE(A57:A64,COUNTIF(A57:A64,\">\" &$AJ$5)+1)","v":{"$error":"#NUM!"}},null,null,"PSO1:",{"$f":"VLOOKUP(AB59,A57:B64,2)","v":{"$error":"#NUM!"}}]
[200,91,85,80,78,74,73,67,64,62,49,38,null,null,null,{"$f":"A60","v":200},91,78,68,58.333333333333336,43.5,null,null,200,{"$f":"HLOOKUP($AJ$8,$B$56:$M$64,5)","v":91},{"$f":"HLOOKUP($AJ$9,$B$56:$M$64,5)","v":91},"PSI2:",{"$f":"SMALL(A57:A64,COUNTIF(A57:A64,\"<\"&$AJ$5)+1)","v":50},null,null,"PSO2:",{"$f":"VLOOKUP(AB60,A57:B64,2)","v":23}]
[250,117,105,101,98,96,94,86,82,80,74,61,48,null,null,{"$f":"A61","v":250},117,98.8,87.333333333333329,78.666666666666671,61,null,null,250,{"$f":"HLOOKUP($AJ$8,$B$56:$M$64,6)","v":117},{"$f":"HLOOKUP($AJ$9,$B$56:$M$64,6)","v":117}]
[300,140,131,125,120,116,118,110,102,95,91,85,69,null,null,{"$f":"A62","v":300},{"$f":"B62","v":140},{"$f":"AVERAGE(C62:G62)","v":122},{"$f":"AVERAGE(G62:I62)","v":110},{"$f":"AVERAGE(I62:K62)","v":96},{"$f":"AVERAGE(K62:M62)","v":81.666666666666671},null,null,300,{"$f":"HLOOKUP($AJ$8,$B$56:$M$64,7)","v":140},{"$f":"HLOOKUP($AJ$9,$B$56:$M$64,7)","v":140}]
[350,161,154,148,142,140,138,132,125,115,110,103,94,null,null,350,161,144.4,131.66666666666666,116.66666666666667,102.33333333333333,null,null,350,{"$f":"HLOOKUP($AJ$8,$B$56:$M$64,8)","v":161},{"$f":"HLOOKUP($AJ$9,$B$56:$M$64,8)","v":161}]
[360,168,160,155,149,146,144,136,131,123,115,108,95,null,null,360,168,150.80000000000001,137,123,106,null,null,360,{"$f":"HLOOKUP($AJ$8,$B$56:$M$64,9)","v":168},{"$f":"HLOOKUP($AJ$9,$B$56:$M$64,9)","v":168}]
[]
["Type 7","Outlet Pressures @ Flow Rate, GPM",null,null,null,null,null,null,null,null,null,null,null,null,"Type 7","Inlet vs. Outlet Pressure Over Flow Range",null,null,null,null,null,null,"Type 7"]
["Inlet Pressure (psig)",0,50,100,150,175,200,250,300,350,400,450,500,null,null,null,"Static","50-200 [GPM]","200-300 [GPM]","300-400 [GPM]","400-500 [GPM]",null,null,null,{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$8& \" GPM\")","v":"Outlet Residual @ 0 GPM"},{"$f":"CONCATENATE(\"Outlet Residual @ \" &AJ$9& \" GPM\")","v":"Outlet Residual @ 0 GPM"},null,null,"Const. PRI Interpolated @ Var. Flow"]
[50,22,18,16,14,13,11,null,null,null,null,null,null,null,"Inlet Pressure (psig)",{"$f":"A68","v":50},{"$f":"B68","v":22},{"$f":"AVERAGE(C68:G68)","v":14.4},{"$f":"AVERAGE(G68:I68)","v":11},null,null,null,"Inlet Pressure (psig)",{"$f":"A68","v":50},{"$f":"HLOOKUP($AJ$8,$B$67:$M$75,2)","v":22},{"$f":"HLOOKUP($AJ$9,$B$67:$M$75,2)","v":22},"PRI1:",{"$f":"LARGE(A68:A75,COUNTIF(A68:A75,\">\" &$AJ$6)+1)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB68,X68:Z73,2)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(AB68,X68:Z73,3)","v":{"$error":"#NUM!"}},"PRO1:",{"$f":"IF(AC68=AD68,AC68, FORECAST($AJ$7,AC68:AD68,$AJ$8:$AJ$9))","v":{"$error":"#NUM!"}}]
[100,43,38,36,32,30,28,25,18,null,null,null,null,null,null,{"$f":"A69","v":100},{"$f":"B69","v":43},{"$f":"AVERAGE(C69:G69)","v":32.799999999999997},{"$f":"AVERAGE(G69:I69)","v":23.666666666666668},{"$f":"AVERAGE(I69:K69)","v":18},null,null,null,100,{"$f":"HLOOKUP($AJ$8,$B$67:$M$75,3)","v":43},{"$f":"HLOOKUP($AJ$9,$B$67:$M$75,3)","v":43},"PRI2:",{"$f":"SMALL(A68:A75,COUNTIF(A68:A75,\"<\"&$AJ$6)+1)","v":50},{"$f":"VLOOKUP(AB69,X68:Z73,2)","v":22},{"$f":"VLOOKUP(AB69,X68:Z73,3)","v":22},"PRO2:",{"$f":"IF(AC69=AD69, AC69, FORECAST($AJ$7,AC69:AD69,$AJ$8:$AJ$9))","v":22}]
[150,64,56,54,50,47,46,42,38,29,null,null,null,null,null,{"$f":"A70","v":150},64,{"$f":"AVERAGE(C70:G70)","v":50.6},42,33.5,null,null,null,150,{"$f":"HLOOKUP($AJ$8,$B$67:$M$75,4)","v":64},{"$f":"HLOOKUP($AJ$9,$B$67:$M$75,4)","v":64},"PSI1:",{"$f":"LARGE(A68:A75,COUNTIF(A68:A75,\">\" &$AJ$5)+1)","v":{"$error":"#NUM!"}},null,null,"PSO1:",{"$f":"VLOOKUP(AB70,A68:B75,2)","v":{"$error":"#NUM!"}}]
[200,85,77,72,69,67,65,60,54,50,42,null,null,null,null,{"$f":"A71","v":200},85,70,59.666666666666664,48.666666666666664,{"$f":"AVERAGE(K71:M71)","v":42},null,null,200,{"$f":"HLOOKUP($AJ$8,$B$67:$M$75,5)","v":85},{"$f":"HLOOKUP($AJ$9,$B$67:$M$75,5)","v":85},"PSI2:",{"$f":"SMALL(A68:A75,COUNTIF(A68:A75,\"<\"&$AJ$5)+1)","v":50},null,null,"PSO2:",{"$f":"VLOOKUP(AB71,A68:B75,2)","v":22}]
[250,103,98,96,89,86,85,80,72,66,58,49,38,null,null,{"$f":"A72","v":250},103,90.8,79,65.333333333333329,48.333333333333336,null,null,250,{"$f":"HLOOKUP($AJ$8,$B$67:$M$75,6)","v":103},{"$f":"HLOOKUP($AJ$9,$B$67:$M$75,6)","v":103}]
[300,126,118,113,109,105,105,98,92,85,77,71,64,null,null,{"$f":"A73","v":300},{"$f":"B73","v":126},{"$f":"AVERAGE(C73:G73)","v":110},{"$f":"AVERAGE(G73:I73)","v":98.333333333333329},{"$f":"AVERAGE(I73:K73)","v":84.666666666666671},{"$f":"AVERAGE(K73:M73)","v":70.666666666666671},null,null,300,{"$f":"HLOOKUP($AJ$8,$B$67:$M$75,7)","v":126},{"$f":"HLOOKUP($AJ$9,$B$67:$M$75,7)","v":126}]
[350,148,138,134,128,127,124,119,111,104,96,85,77,null,null,350,148,130.19999999999999,118,103.66666666666667,86,null,null,350,{"$f":"HLOOKUP($AJ$8,$B$67:$M$75,8)","v":148},{"$f":"HLOOKUP($AJ$9,$B$67:$M$75,8)","v":148}]
[400,166,160,154,152,149,147,138,130,125,119,106,96,null,null,400,166,152.4,138.33333333333334,124.66666666666667,{"$f":"AVERAGE(K75:M75)","v":107},null,null,400,{"$f":"HLOOKUP($AJ$8,$B$67:$M$75,9)","v":166},{"$f":"HLOOKUP($AJ$9,$B$67:$M$75,9)","v":166}]

{"sheet":"1.5_Angle","index":5,"n_rows":54,"n_cols":35,"rows_kept":54,"cut":false,"hidden":true,"merged":[[10,1,10,12],[18,1,18,12],[27,1,27,12],[46,1,46,12],[2,1,2,12],[36,1,36,12],[12,14,16,14],[20,14,24,14],[29,14,33,14],[48,14,52,14],[2,15,2,18],[10,15,10,18],[18,15,18,18],[27,15,27,18],[46,15,46,18],[4,14,8,14],[36,15,36,18],[38,14,42,14],[3,26,3,27],[3,31,3,33],[4,20,8,20],[11,26,11,27],[12,20,16,20],[28,26,28,27],[47,26,47,27],[48,20,52,20],[19,26,19,27],[20,20,24,20],[29,20,33,20],[37,26,37,27],[38,20,42,20]]}
["1.5\" Angle Body - Outlet Pressures @ Flow Rate"]
[]
["Type 1","Outlet Pressures @ Flow Rate, GPM",null,null,null,null,null,null,null,null,null,null,null,null,"Type 1","Inlet vs. Outlet Pressure Over Flow Range",null,null,null,null,"Type 1"]
["Inlet Pressure (psig)",0,50,100,150,175,200,250,300,350,400,450,500,null,null,null,"Static","50-200 [GPM]","200-250 [GPM]",null,null,null,{"$f":"CONCATENATE(\"Outlet Residual @ \" &AH$8& \" GPM\")","v":"Outlet Residual @ 0 GPM"},{"$f":"CONCATENATE(\"Outlet Residual @ \" &AH$9& \" GPM\")","v":"Outlet Residual @ 0 GPM"},null,null,"Const. PRI Interpolated @ Var. Flow",null,null,null,null,"Variables:"]
[50,45,36,34,23,22,12,null,null,null,null,null,null,null,"Inlet Pressure (psig)",{"$f":"A5","v":50},{"$f":"B5","v":45},{"$f":"AVERAGE(C5:G5)","v":25.4},{"$f":"AVERAGE(G5:H5)","v":12},null,"Inlet Pressure (psig)",{"$f":"A5","v":50},{"$f":"HLOOKUP($AH$8,$B$4:$M$9,2)","v":45},{"$f":"HLOOKUP($AH$9,$B$4:$M$9,2)","v":45},"PRI1:",{"$f":"LARGE(A5:A9,COUNTIF(A5:A9,\">\" &$AH$6)+1)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(Z5,V5:X9,2)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(Z5,V5:X9,3)","v":{"$error":"#NUM!"}},"PRO1:",{"$f":"IF(AA5=AB5, AA5, FORECAST($AH$7,AA5:AB5,$AH$8:$AH$9))","v":{"$error":"#NUM!"}},null,"Static Inlet Pressure ","PSI:",{"$f":"Database!$B$2","v":0}]
[100,82,73,67,63,62,53,42,20,null,null,null,null,null,null,{"$f":"A6","v":100},{"$f":"B6","v":82},{"$f":"AVERAGE(C6:G6)","v":63.6},{"$f":"AVERAGE(G6:H6)","v":47.5},null,null,{"$f":"A6","v":100},{"$f":"HLOOKUP($AH$8,$B$4:$M$9,3)","v":82},{"$f":"HLOOKUP($AH$9,$B$4:$M$9,3)","v":82},"PRI2:",{"$f":"SMALL(A5:A9,COUNTIF(A5:A9,\"<\"&$AH$6)+1)","v":50},{"$f":"VLOOKUP(Z6,V5:X9,2)","v":45},{"$f":"VLOOKUP(Z6,V5:X9,3)","v":45},"PRO2:",{"$f":"IF(AA6=AB6, AA6, FORECAST($AH$7,AA6:AB6,$AH$8:$AH$9))","v":45},null,"Residual Inlet Pressure ","PRI:",{"$f":"Database!$B$3","v":0}]
[150,123,104,103,100,97,95,80,65,42,null,null,null,null,null,{"$f":"A7","v":150},123,99.8,87.5,null,null,150,{"$f":"HLOOKUP($AH$8,$B$4:$M$9,4)","v":123},{"$f":"HLOOKUP($AH$9,$B$4:$M$9,4)","v":123},"PSI1:",{"$f":"LARGE(A5:A9,COUNTIF(A5:A9,\">\" &$AH$5)+1)","v":{"$error":"#NUM!"}},null,null,"PSO1:",{"$f":"VLOOKUP(Z7,A5:B9,2)","v":{"$error":"#NUM!"}},null,"Flow Rate ","Q0:",{"$f":"Database!$B$4","v":0}]
[200,164,140,135,142,141,130,127,108,90,60,null,null,null,null,{"$f":"A8","v":200},164,137.6,128.5,null,null,200,{"$f":"HLOOKUP($AH$8,$B$4:$M$9,5)","v":164},{"$f":"HLOOKUP($AH$9,$B$4:$M$9,5)","v":164},"PSI2:",{"$f":"SMALL(A5:A9,COUNTIF(A5:A9,\"<\"&$AH$5)+1)","v":50},null,null,"PSO2:",{"$f":"VLOOKUP(Z8,A5:B9,2)","v":45},null,"Nearest Flow Rate, 1","Q1:",{"$f":"LARGE(B4:H4,COUNTIF(B4:H4,\">\" &$AH$7)+1)","v":0}]
[210,171,147,144,150,148,139,137,114,96,67,null,null,null,null,{"$f":"A9","v":210},171,145.6,138,null,null,210,{"$f":"HLOOKUP($AH$8,$B$4:$M$9,6)","v":171},{"$f":"HLOOKUP($AH$9,$B$4:$M$9,6)","v":171},null,null,null,null,null,null,null,"Nearest Known Flow Rate, 2","Q2:",{"$f":"SMALL(B4:H4,COUNTIF(B4:H4,\"<\"&$AH$7)+1)","v":0}]
[]
["Type 2","Outlet Pressures @ Flow Rate, GPM",null,null,null,null,null,null,null,null,null,null,null,null,"Type 2","Inlet vs. Outlet Pressure Over Flow Range",null,null,null,null,"Type 2"]
["Inlet Pressure (psig)",0,50,100,150,175,200,250,300,350,400,450,500,null,null,null,"Static","50-200 [GPM]","200-250 [GPM]",null,null,null,{"$f":"CONCATENATE(\"Outlet Residual @ \" &AH$8& \" GPM\")","v":"Outlet Residual @ 0 GPM"},{"$f":"CONCATENATE(\"Outlet Residual @ \" &AH$9& \" GPM\")","v":"Outlet Residual @ 0 GPM"},null,null,"Const. PRI Interpolated @ Var. Flow",null,null,null,null,"1.5\" Angle","Calculated Static Outlet Pressure","Calculated Residual Outlet Pressure","Max Flow Rate"]
[50,40,30,26,22,15,10,null,null,null,null,null,null,null,"Inlet Pressure (psig)",{"$f":"A13","v":50},{"$f":"B13","v":40},{"$f":"AVERAGE(C13:G13)","v":20.6},{"$f":"AVERAGE(G13:H13)","v":10},null,"Inlet Pressure (psig)",{"$f":"A13","v":50},{"$f":"HLOOKUP($AH$8,$B$12:$H$17,2)","v":40},{"$f":"HLOOKUP($AH$9,$B$12:$H$17,2)","v":40},"PRI1:",{"$f":"LARGE(A13:A17,COUNTIF(A13:A17,\">\" &$AH$6)+1)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(Z13,V13:X17,2)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(Z13,V13:X17,3)","v":{"$error":"#NUM!"}},"PRO1:",{"$f":"IF(AA13=AB13, AA13, FORECAST($AH$7,AA13:AB13,$AH$8:$AH$9))","v":{"$error":"#NUM!"}},null,"Type 1",{"$f":"IF(AD7=AD8,AD7,FORECAST(AH5,AD7:AD8,Z7:Z8))","v":{"$error":"#NUM!"}},{"$f":"IF(AD5=AD6,AD5,FORECAST($AH$6,AD5:AD6,Z5:Z6))","v":{"$error":"#NUM!"}},250]
[100,74,57,58,52,48,47,33,19,null,null,null,null,null,null,{"$f":"A14","v":100},{"$f":"B14","v":74},{"$f":"AVERAGE(C14:G14)","v":52.4},{"$f":"AVERAGE(G14:H14)","v":40},null,null,{"$f":"A14","v":100},{"$f":"HLOOKUP($AH$8,$B$12:$H$17,3)","v":74},{"$f":"HLOOKUP($AH$9,$B$12:$H$17,3)","v":74},"PRI2:",{"$f":"SMALL(A13:A17,COUNTIF(A13:A17,\"<\"&$AH$6)+1)","v":50},{"$f":"VLOOKUP(Z14,V13:X17,2)","v":40},{"$f":"VLOOKUP(Z14,V13:X17,3)","v":40},"PRO2:",{"$f":"IF(AA14=AB14, AA14, FORECAST($AH$7,AA14:AB14,$AH$8:$AH$9))","v":40},null,"Type 2",{"$f":"IF(AD15=AD16,AD15,FORECAST($AH$5,AD15:AD16,Z15:Z16))","v":{"$error":"#NUM!"}},{"$f":"IF(Z13=Z14,AD13,FORECAST($AH$6,AD13:AD14,Z13:Z14))","v":{"$error":"#NUM!"}},250]
[150,107,87,84,80,78,77,69,55,37,null,null,null,null,null,{"$f":"A15","v":150},107,81.2,73,null,null,150,{"$f":"HLOOKUP($AH$8,$B$12:$H$17,4)","v":107},{"$f":"HLOOKUP($AH$9,$B$12:$H$17,4)","v":107},"PSI1:",{"$f":"LARGE(A13:A17,COUNTIF(A13:A17,\">\" &$AH$5)+1)","v":{"$error":"#NUM!"}},null,null,"PSO1:",{"$f":"VLOOKUP(Z15,A13:B17,2)","v":{"$error":"#NUM!"}},null,"Type 3",{"$f":"IF(AD23=AD24,AD23,FORECAST($AH$5,AD23:AD24,Z23:Z24))","v":{"$error":"#NUM!"}},{"$f":"IF(Z21=Z22,AD21,FORECAST($AH$6,AD21:AD22,Z21:Z22))","v":{"$error":"#NUM!"}},250]
[200,141,121,117,113,111,107,97,91,77,51,null,null,null,null,{"$f":"A16","v":200},141,113.8,102,null,null,200,{"$f":"HLOOKUP($AH$8,$B$12:$H$17,5)","v":141},{"$f":"HLOOKUP($AH$9,$B$12:$H$17,5)","v":141},"PSI2:",{"$f":"SMALL(A13:A17,COUNTIF(A13:A17,\"<\"&$AH$5)+1)","v":50},null,null,"PSO2:",{"$f":"VLOOKUP(Z16,A13:B17,2)","v":40},null,"Type 4B",{"$f":"IF(AD32=AD33,AD32,FORECAST($AH$5,AD32:AD33,Z32:Z33))","v":{"$error":"#NUM!"}},{"$f":"IF(Z30=Z31,AD30,FORECAST($AH$6,AD30:AD31,Z30:Z31))","v":{"$error":"#NUM!"}},200]
[250,174,153,146,145,140,139,136,113,107,87,68,null,null,null,{"$f":"A17","v":250},174,144.6,137.5,null,null,250,{"$f":"HLOOKUP($AH$8,$B$12:$H$17,6)","v":174},{"$f":"HLOOKUP($AH$9,$B$12:$H$17,6)","v":174},null,null,null,null,null,null,null,"Type 4A",{"$f":"IF(AD41=AD42,AD42,FORECAST($AH$5,AD41:AD42,Z41:Z42))","v":{"$error":"#NUM!"}},{"$f":"IF(Z39=Z40,AD39,FORECAST($AH$6,AD39:AD40,Z39:Z40))","v":{"$error":"#NUM!"}},250]
[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,"Type 5",{"$f":"IF(AD51=AD52,AD51,FORECAST($AH$5,AD51:AD52,Z51:Z52))","v":{"$error":"#NUM!"}},{"$f":"IF(Z49=Z50,AD49,FORECAST($AH$6,AD49:AD50,Z49:Z50))","v":{"$error":"#NUM!"}},250]
["Type 3","Outlet Pressures @ Flow Rate, GPM",null,null,null,null,null,null,null,null,null,null,null,null,"Type 3","Inlet vs. Outlet Pressure Over Flow Range",null,null,null,null,"Type 3"]
["Inlet Pressure (psig)",0,50,100,150,175,200,250,300,350,400,450,500,null,null,null,"Static","50-200 [GPM]","200-250 [GPM]",null,null,null,{"$f":"CONCATENATE(\"Outlet Residual @ \" &AH$8& \" GPM\")","v":"Outlet Residual @ 0 GPM"},{"$f":"CONCATENATE(\"Outlet Residual @ \" &AH$9& \" GPM\")","v":"Outlet Residual @ 0 GPM"},null,null,"Const. PRI Interpolated @ Var. Flow"]
[50,33,26,24,18,12,10,null,null,null,null,null,null,null,"Inlet Pressure (psig)",{"$f":"A21","v":50},{"$f":"B21","v":33},{"$f":"AVERAGE(C21:G21)","v":18},{"$f":"AVERAGE(G21:H21)","v":10},null,"Inlet Pressure (psig)",{"$f":"A21","v":50},{"$f":"HLOOKUP($AH$8,$B$20:$H$26,2)","v":33},{"$f":"HLOOKUP($AH$9,$B$20:$H$26,2)","v":33},"PRI1:",{"$f":"LARGE(A21:A26,COUNTIF(A21:A26,\">\" &$AH$6)+1)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(Z21,V21:X26,2)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(Z21,V21:X26,3)","v":{"$error":"#NUM!"}},"PRO1:",{"$f":"IF(AA21=AB21, AA21, FORECAST($AH$7,AA21:AB21,$AH$8:$AH$9))","v":{"$error":"#NUM!"}}]
[100,64,50,50,46,45,38,27,17,null,null,null,null,null,null,{"$f":"A22","v":100},{"$f":"B22","v":64},{"$f":"AVERAGE(C22:G22)","v":45.8},{"$f":"AVERAGE(G22:H22)","v":32.5},null,null,{"$f":"A22","v":100},{"$f":"HLOOKUP($AH$8,$B$20:$H$26,3)","v":64},{"$f":"HLOOKUP($AH$9,$B$20:$H$26,3)","v":64},"PRI2:",{"$f":"SMALL(A21:A26,COUNTIF(A21:A26,\"<\"&$AH$6)+1)","v":50},{"$f":"VLOOKUP(Z22,V21:X26,2)","v":33},{"$f":"VLOOKUP(Z22,V21:X26,3)","v":33},"PRO2:",{"$f":"IF(AA22=AB22, AA22, FORECAST($AH$7,AA22:AB22,$AH$8:$AH$9))","v":33}]
[150,94,85,75,72,70,68,59,46,32,null,null,null,null,null,{"$f":"A23","v":150},94,74,63.5,null,null,150,{"$f":"HLOOKUP($AH$8,$B$20:$H$26,4)","v":94},{"$f":"HLOOKUP($AH$9,$B$20:$H$26,4)","v":94},"PSI1:",{"$f":"LARGE(A21:A26,COUNTIF(A21:A26,\">\" &$AH$5)+1)","v":{"$error":"#NUM!"}},null,null,"PSO1:",{"$f":"VLOOKUP(Z23,A21:B26,2)","v":{"$error":"#NUM!"}}]
[200,126,103,95,99,97,93,88,76,61,45,null,null,null,null,{"$f":"A24","v":200},126,97.4,90.5,null,null,200,{"$f":"HLOOKUP($AH$8,$B$20:$H$26,5)","v":126},{"$f":"HLOOKUP($AH$9,$B$20:$H$26,5)","v":126},"PSI2:",{"$f":"SMALL(A21:A26,COUNTIF(A21:A26,\"<\"&$AH$5)+1)","v":50},null,null,"PSO2:",{"$f":"VLOOKUP(Z24,A21:B26,2)","v":33}]
[250,160,132,118,121,124,120,114,108,98,76,55,null,null,null,{"$f":"A25","v":250},160,123,117,null,null,250,{"$f":"HLOOKUP($AH$8,$B$20:$H$26,6)","v":160},{"$f":"HLOOKUP($AH$9,$B$20:$H$26,6)","v":160}]
[260,174,139,130,122,124,123,125,null,null,null,null,null,null,null,{"$f":"A26","v":260},{"$f":"B26","v":174},{"$f":"AVERAGE(C26:G26)","v":127.6},{"$f":"AVERAGE(G26:H26)","v":124},null,null,{"$f":"A26","v":260},{"$f":"HLOOKUP($AH$8,$B$20:$H$26,7)","v":174},{"$f":"HLOOKUP($AH$9,$B$20:$H$26,7)","v":174}]
[]
["Type 4B","Outlet Pressures @ Flow Rate, GPM",null,null,null,null,null,null,null,null,null,null,null,null,"Type 4B","Inlet vs. Outlet Pressure Over Flow Range",null,null,null,null,"Type 4A"]
["Inlet Pressure (psig)",0,50,100,150,175,200,250,300,350,400,450,500,null,null,null,"Static","50-200 [GPM]",null,null,null,null,{"$f":"CONCATENATE(\"Outlet Residual @ \" &$AG$30& \" GPM\")","v":"Outlet Residual @ 0 GPM"},{"$f":"CONCATENATE(\"Outlet Residual @ \" &$AG$31& \" GPM\")","v":"Outlet Residual @ 0 GPM"},null,null,"Const. PRI Interpolated @ Var. Flow",null,null,null,null,"Type 4B (200 GPM Max.)","Flow Rate"]
[50,28,18,22,12,null,null,null,null,null,null,null,null,null,"Inlet Pressure (psig)",{"$f":"A30","v":50},{"$f":"B30","v":28},{"$f":"AVERAGE(C30:G30)","v":17.333333333333332},null,null,"Inlet Pressure (psig)",{"$f":"A30","v":50},{"$f":"HLOOKUP($AG$30,$B$29:$H$36,2)","v":28},{"$f":"HLOOKUP($AG$31,$B$29:$H$36,2)","v":28},"PRI1:",{"$f":"LARGE(A30:A35,COUNTIF(A30:A35,\">\" &$AH$6)+1)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(Z30,V30:X35,2)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(Z30,V30:X35,3)","v":{"$error":"#NUM!"}},"PRO1:",{"$f":"IF(AA30=AB30, AA30, FORECAST($AH$7,AA30:AB30,$AG$30:$AG$31))","v":{"$error":"#NUM!"}},null,"Mod Rate, 1",{"$f":"LARGE(B29:G29,COUNTIF(B29:G29,\">\" &$AH$7)+1)","v":0}]
[100,60,39,39,37,33,33,21,null,null,null,null,null,null,null,{"$f":"A31","v":100},{"$f":"B31","v":60},{"$f":"AVERAGE(C31:G31)","v":36.200000000000003},null,null,null,{"$f":"A31","v":100},{"$f":"HLOOKUP($AG$30,$B$29:$H$36,3)","v":60},{"$f":"HLOOKUP($AG$31,$B$29:$H$36,3)","v":60},"PRI2:",{"$f":"SMALL(A30:A35,COUNTIF(A30:A35,\"<\"&$AH$6)+1)","v":50},{"$f":"VLOOKUP(Z31,V30:X35,2)","v":28},{"$f":"VLOOKUP(Z31,V30:X35,3)","v":28},"PRO2:",{"$f":"IF(AA31=AB31, AA31, FORECAST($AH$7,AA31:AB31,$AG$30:$AG$31))","v":28},null,"Mod Rate, 2",{"$f":"SMALL(B29:G29,COUNTIF(B29:G29,\"<\"&$AH$7)+1)","v":0}]
[150,88,62,60,59,58,59,47,36,24,null,null,null,null,null,{"$f":"A32","v":150},88,59.6,null,null,null,150,{"$f":"HLOOKUP($AG$30,$B$29:$H$36,4)","v":88},{"$f":"HLOOKUP($AG$31,$B$29:$H$36,4)","v":88},"PSI1:",{"$f":"LARGE(A30:A35,COUNTIF(A30:A35,\">\" &$AH$5)+1)","v":{"$error":"#NUM!"}},null,null,"PSO1:",{"$f":"VLOOKUP(Z32,A30:B35,2)","v":{"$error":"#NUM!"}}]
[200,116,86,84,84,88,80,71,61,48,33,10,null,null,null,{"$f":"A33","v":200},116,84.4,null,null,null,200,{"$f":"HLOOKUP($AG$30,$B$29:$H$36,5)","v":116},{"$f":"HLOOKUP($AG$31,$B$29:$H$36,5)","v":116},"PSI2:",{"$f":"SMALL(A30:A35,COUNTIF(A30:A35,\"<\"&$AH$5)+1)","v":50},null,null,"PSO2:",{"$f":"VLOOKUP(Z33,A30:B35,2)","v":28}]
[250,145,112,111,106,109,106,98,88,73,60,60,null,null,null,{"$f":"A34","v":250},145,108.8,null,null,null,250,{"$f":"HLOOKUP($AG$30,$B$29:$H$36,6)","v":145},{"$f":"HLOOKUP($AG$31,$B$29:$H$36,6)","v":145}]
[275,172,142,120,111,118,124,120,null,null,null,null,null,null,null,{"$f":"A35","v":275},{"$f":"B35","v":172},{"$f":"AVERAGE(C35:G35)","v":123},null,null,null,275,{"$f":"HLOOKUP($AG$30,$B$29:$H$36,7)","v":172},{"$f":"HLOOKUP($AG$31,$B$29:$H$36,7)","v":172}]
[]
["Type 4A","Outlet Pressures @ Flow Rate, GPM",null,null,null,null,null,null,null,null,null,null,null,null,"Type 4A","Inlet vs. Outlet Pressure Over Flow Range",null,null,null,null,"Type 4B"]
["Inlet Pressure (psig)",0,50,100,150,175,200,250,300,350,400,450,500,null,null,null,"Static","50-200 [GPM]","200-250 [GPM]",null,null,null,{"$f":"CONCATENATE(\"Outlet Residual @ \" &$AH$8& \" GPM\")","v":"Outlet Residual @ 0 GPM"},{"$f":"CONCATENATE(\"Outlet Residual @ \" &$AH$9& \" GPM\")","v":"Outlet Residual @ 0 GPM"},null,null,"Const. PRI Interpolated @ Var. Flow"]
[50,28,18,22,12,null,null,null,null,null,null,null,null,null,"Inlet Pressure (psig)",{"$f":"A39","v":50},{"$f":"B39","v":28},{"$f":"AVERAGE(C39:G39)","v":17.333333333333332},{"$f":"AVERAGE(F39:G39)","v":{"$error":"#DIV/0!"}},null,"Inlet Pressure (psig)",{"$f":"A39","v":50},{"$f":"HLOOKUP($AH$8,$B$38:$H$44,2)","v":28},{"$f":"HLOOKUP($AH$9,$B$38:$H$44,2)","v":28},"PRI1:",{"$f":"LARGE(A39:A45,COUNTIF(A39:A45,\">\" &$AH$6)+1)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(Z39,V39:X45,2)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(Z39,V39:X45,3)","v":{"$error":"#NUM!"}},"PRO1:",{"$f":"IF(AA39=AB39, AA39, FORECAST($AH$7,AA39:AB39,$AH$8:$AH$9))","v":{"$error":"#NUM!"}}]
[100,60,39,39,37,33,33,21,null,null,null,null,null,null,null,{"$f":"A40","v":100},{"$f":"B40","v":60},{"$f":"AVERAGE(C40:G40)","v":36.200000000000003},{"$f":"AVERAGE(F40:G40)","v":33},null,null,{"$f":"A40","v":100},{"$f":"HLOOKUP($AH$8,$B$38:$H$44,3)","v":60},{"$f":"HLOOKUP($AH$9,$B$38:$H$44,3)","v":60},"PRI2:",{"$f":"SMALL(A39:A45,COUNTIF(A39:A45,\"<\"&$AH$6)+1)","v":50},{"$f":"VLOOKUP(Z40,V39:X45,2)","v":28},{"$f":"VLOOKUP(Z40,V39:X45,3)","v":28},"PRO2:",{"$f":"IF(AA40=AB40, AA40, FORECAST($AH$7,AA40:AB40,$AH$8:$AH$9))","v":28}]
[150,88,62,60,59,58,59,47,36,24,null,null,null,null,null,{"$f":"A41","v":150},88,59.6,58.5,null,null,150,{"$f":"HLOOKUP($AH$8,$B$38:$H$44,4)","v":88},{"$f":"HLOOKUP($AH$9,$B$38:$H$44,4)","v":88},"PSI1:",{"$f":"LARGE(A39:A45,COUNTIF(A39:A45,\">\" &$AH$5)+1)","v":{"$error":"#NUM!"}},null,null,"PSO1:",{"$f":"VLOOKUP(Z41,A39:B45,2)","v":{"$error":"#NUM!"}}]
[200,116,86,84,84,88,80,71,61,48,33,10,null,null,null,{"$f":"A42","v":200},116,84.4,84,null,null,200,{"$f":"HLOOKUP($AH$8,$B$38:$H$44,5)","v":116},{"$f":"HLOOKUP($AH$9,$B$38:$H$44,5)","v":116},"PSI2:",{"$f":"SMALL(A39:A45,COUNTIF(A39:A45,\"<\"&$AH$5)+1)","v":50},null,null,"PSO2:",{"$f":"VLOOKUP(Z42,A39:B45,2)","v":28}]
[250,145,112,111,106,109,106,98,88,73,60,60,null,null,null,{"$f":"A43","v":250},145,108.8,107.5,null,null,250,{"$f":"HLOOKUP($AH$8,$B$38:$H$44,6)","v":145},{"$f":"HLOOKUP($AH$9,$B$38:$H$44,6)","v":145}]
[260,{"$f":"B$43+(B$45-B$43)*(($A$44-$A$43)/($A$45-$A$43))","v":155.80000000000001},{"$f":"C$43+(C$45-C$43)*(($A$44-$A$43)/($A$45-$A$43))","v":124},{"$f":"D$43+(D$45-D$43)*(($A$44-$A$43)/($A$45-$A$43))","v":114.6},108,112.6,113.2,106.8,52.8,43.8,36,36,null,null,null,{"$f":"A44","v":260},155.80000000000001,114.48000000000002,112.9,null,null,260,{"$f":"HLOOKUP($AH$8,$B$38:$H$44,7)","v":155.80000000000001},{"$f":"HLOOKUP($AH$9,$B$38:$H$44,7)","v":155.80000000000001}]
[275,172,142,120,111,118,124,120,null,null,null,null,null,null,null,{"$f":"A45","v":275},172,123,121]
[]
["Type 5","Outlet Pressures @ Flow Rate, GPM",null,null,null,null,null,null,null,null,null,null,null,null,"Type 5","Inlet vs. Outlet Pressure Over Flow Range",null,null,null,null,"Type 5"]
["Inlet Pressure (psig)",0,50,100,150,175,200,250,300,350,400,450,500,null,null,null,"Static","50-200 [GPM]","200-250 [GPM]",null,null,null,{"$f":"CONCATENATE(\"Outlet Residual @ \" &AH$8& \" GPM\")","v":"Outlet Residual @ 0 GPM"},{"$f":"CONCATENATE(\"Outlet Residual @ \" &AH$9& \" GPM\")","v":"Outlet Residual @ 0 GPM"},null,null,"Const. PRI Interpolated @ Var. Flow"]
[50,24,18,15,1,null,null,null,null,null,null,null,null,null,"Inlet Pressure (psig)",{"$f":"A49","v":50},{"$f":"B49","v":24},{"$f":"AVERAGE(C49:G49)","v":11.333333333333334},{"$f":"AVERAGE(G49:H49)","v":{"$error":"#DIV/0!"}},null,"Inlet Pressure (psig)",{"$f":"A49","v":50},{"$f":"HLOOKUP($AH$8,$B$48:$H$56,2)","v":24},{"$f":"HLOOKUP($AH$9,$B$48:$H$56,2)","v":24},"PRI1:",{"$f":"LARGE(A49:A54,COUNTIF(A49:A54,\">\" &$AH$6)+1)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(Z49,V49:X54,2)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(Z49,V49:X54,3)","v":{"$error":"#NUM!"}},"PRO1:",{"$f":"IF(AA49=AB49, AA49, FORECAST($AH$7,AA49:AB49,$AH$8:$AH$9))","v":{"$error":"#NUM!"}}]
[100,47,38,30,27,10,null,null,null,null,null,null,null,null,null,{"$f":"A50","v":100},{"$f":"B50","v":47},{"$f":"AVERAGE(C50:G50)","v":26.25},{"$f":"AVERAGE(G50:H50)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"A50","v":100},{"$f":"HLOOKUP($AH$8,$B$48:$H$56,3)","v":47},{"$f":"HLOOKUP($AH$9,$B$48:$H$56,3)","v":47},"PRI2:",{"$f":"SMALL(A49:A54,COUNTIF(A49:A54,\"<\"&$AH$6)+1)","v":50},{"$f":"VLOOKUP(Z50,V49:X54,2)","v":24},{"$f":"VLOOKUP(Z50,V49:X54,3)","v":24},"PRO2:",{"$f":"IF(AA50=AB50, AA50, FORECAST($AH$7,AA50:AB50,$AH$8:$AH$9))","v":24}]
[150,74,59,42,46,44,40,null,null,null,null,null,null,null,null,{"$f":"A51","v":150},74,46.2,40,null,null,150,{"$f":"HLOOKUP($AH$8,$B$48:$H$56,4)","v":74},{"$f":"HLOOKUP($AH$9,$B$48:$H$56,4)","v":74},"PSI1:",{"$f":"LARGE(A49:A54,COUNTIF(A49:A54,\">\" &$AH$5)+1)","v":{"$error":"#NUM!"}},null,null,"PSO1:",{"$f":"VLOOKUP(Z51,A49:B54,2)","v":{"$error":"#NUM!"}}]
[200,92,79,63,56,64,62,50,null,null,null,null,null,null,null,{"$f":"A52","v":200},92,64.8,56,null,null,200,{"$f":"HLOOKUP($AH$8,$B$48:$H$56,5)","v":92},{"$f":"HLOOKUP($AH$9,$B$48:$H$56,5)","v":92},"PSI2:",{"$f":"SMALL(A49:A54,COUNTIF(A49:A54,\"<\"&$AH$5)+1)","v":50},null,null,"PSO2:",{"$f":"VLOOKUP(Z52,A49:B54,2)","v":24}]
[250,120,103,84,76,74,80,74,63,null,null,null,null,null,null,{"$f":"A53","v":250},120,83.4,77,null,null,250,{"$f":"HLOOKUP($AH$8,$B$48:$H$56,6)","v":120},{"$f":"HLOOKUP($AH$9,$B$48:$H$56,6)","v":120}]
[300,140,125,109,93,93,95,96,96,85,null,null,null,null,null,{"$f":"A54","v":300},{"$f":"B54","v":140},{"$f":"AVERAGE(C54:G54)","v":103},{"$f":"AVERAGE(G54:H54)","v":95.5},null,null,300,{"$f":"HLOOKUP($AH$8,$B$48:$H$56,7)","v":140},{"$f":"HLOOKUP($AH$9,$B$48:$H$56,7)","v":140}]

{"sheet":"Flow_Charts","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}