{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Pipe Load","DATA","Refernces"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":2,"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":"Pipe Load","index":0,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[31,1,31,4],[32,1,32,4],[9,0,9,7],[20,0,20,7],[0,0,0,7],[3,0,3,7],[1,0,2,7],[4,0,4,7],[30,1,30,4]]}
[]
[]
[]
[]
["GENERAL DATA"]
["Area Tag","WAREHOUSE"]
["Select Pipe Material ","Steel Sch.40",null,"Select Liquid","Water"]
["Material Density (kg/m3)",{"$f":"INDEX(DATA!E15:F16,MATCH(B7,DATA!E15:E16,0),2)","v":8050},null,"Liquid Density (kg/m3)",{"$f":"INDEX(DATA!A15:B17,MATCH(E7,DATA!A15:A17,0),2)","v":1000}]
[]
["Inputs"]
["Nominal Diameter (in)","Nominal Diameter (mm)","Inside Diameter (mm)","Outside Diameter (mm)","Length (m)","Empty Pipe Weight (kg)","Liquid Weight (kg)","Filled Pipe Weight (kg)"]
[1,"25mm",{"$f":"IF(B7=\"Steel Sch.40\",INDEX(DATA!A3:C12,MATCH(A12,DATA!A3:A12,0),2),INDEX(DATA!E3:G12,MATCH(A12,DATA!E3:E12,0),2))","v":26.6},{"$f":"IF(B7=\"Steel Sch.40\",INDEX(DATA!A3:C12,MATCH(A12,DATA!A3:A12,0),3),INDEX(DATA!E3:G12,MATCH(A12,DATA!E3:E12,0),3))","v":33.4},null,{"$f":"3.14*E12*(((D12/1000)^2)-((C12/1000)^2))*$B$8/4","v":0},{"$f":"3.14*E12*((C12/1000)^2)*$E$8/4","v":0},{"$f":"F12+G12","v":0}]
[1.25,"32mm",{"$f":"IF(B7=\"Steel Sch.40\",INDEX(DATA!A3:C12,MATCH(A13,DATA!A3:A12,0),2),INDEX(DATA!E3:G12,MATCH(A13,DATA!E3:E12,0),2))","v":35.1},{"$f":"IF(B7=\"Steel Sch.40\",INDEX(DATA!A3:C12,MATCH(A13,DATA!A3:A12,0),3),INDEX(DATA!E3:G12,MATCH(A13,DATA!E3:E12,0),3))","v":42.2},null,{"$f":"3.14*E13*(((D13/1000)^2)-((C13/1000)^2))*$B$8/4","v":0},{"$f":"3.14*E13*((C13/1000)^2)*$E$8/4","v":0},{"$f":"F13+G13","v":0}]
[1.5,"40mm",{"$f":"IF(B7=\"Steel Sch.40\",INDEX(DATA!A3:C12,MATCH(A14,DATA!A3:A12,0),2),INDEX(DATA!E3:G12,MATCH(A14,DATA!E3:E12,0),2))","v":40.9},{"$f":"IF(B7=\"Steel Sch.40\",INDEX(DATA!A3:C12,MATCH(A14,DATA!A3:A12,0),3),INDEX(DATA!E3:G12,MATCH(A14,DATA!E3:E12,0),3))","v":48.3},null,{"$f":"3.14*E14*(((D14/1000)^2)-((C14/1000)^2))*$B$8/4","v":0},0,0]
[2,"50mm",{"$f":"IF(B7=\"Steel Sch.40\",INDEX(DATA!A3:C12,MATCH(A15,DATA!A3:A12,0),2),INDEX(DATA!E3:G12,MATCH(A15,DATA!E3:E12,0),2))","v":52.5},{"$f":"IF(B7=\"Steel Sch.40\",INDEX(DATA!A3:C12,MATCH(A15,DATA!A3:A12,0),3),INDEX(DATA!E3:G12,MATCH(A15,DATA!E3:E12,0),3))","v":60.3},null,0,0,0]
[2.5,"65mm",{"$f":"IF(B7=\"Steel Sch.40\",INDEX(DATA!A3:C12,MATCH(A16,DATA!A3:A12,0),2),INDEX(DATA!E3:G12,MATCH(A16,DATA!E3:E12,0),2))","v":62.7},{"$f":"IF(B7=\"Steel Sch.40\",INDEX(DATA!A3:C12,MATCH(A16,DATA!A3:A12,0),3),INDEX(DATA!E3:G12,MATCH(A16,DATA!E3:E12,0),3))","v":73},null,0,0,0]
[3,"80mm",{"$f":"IF(B7=\"Steel Sch.40\",INDEX(DATA!A3:C12,MATCH(A17,DATA!A3:A12,0),2),INDEX(DATA!E3:G12,MATCH(A17,DATA!E3:E12,0),2))","v":77.900000000000006},{"$f":"IF(B7=\"Steel Sch.40\",INDEX(DATA!A3:C12,MATCH(A17,DATA!A3:A12,0),3),INDEX(DATA!E3:G12,MATCH(A17,DATA!E3:E12,0),3))","v":88.9},null,0,0,0]
[4,"100mm",{"$f":"IF(B7=\"Steel Sch.40\",INDEX(DATA!A3:C12,MATCH(A18,DATA!A3:A12,0),2),INDEX(DATA!E3:G12,MATCH(A18,DATA!E3:E12,0),2))","v":102.3},{"$f":"IF(B7=\"Steel Sch.40\",INDEX(DATA!A3:C12,MATCH(A18,DATA!A3:A12,0),3),INDEX(DATA!E3:G12,MATCH(A18,DATA!E3:E12,0),3))","v":114.3},null,0,0,0]
[6,"150mm",{"$f":"IF(B7=\"Steel Sch.40\",INDEX(DATA!A3:C12,MATCH(A19,DATA!A3:A12,0),2),INDEX(DATA!E3:G12,MATCH(A19,DATA!E3:E12,0),2))","v":154.1},{"$f":"IF(B7=\"Steel Sch.40\",INDEX(DATA!A3:C12,MATCH(A19,DATA!A3:A12,0),3),INDEX(DATA!E3:G12,MATCH(A19,DATA!E3:E12,0),3))","v":168.3},240,6943.2076896000081,4473.8990039999999,11417.106693600008]
[8,"200mm",{"$f":"IF(B7=\"Steel Sch.40\",INDEX(DATA!A3:C12,MATCH(A20,DATA!A3:A12,0),2),INDEX(DATA!E3:G12,MATCH(A20,DATA!E3:E12,0),2))","v":202.7},{"$f":"IF(B7=\"Steel Sch.40\",INDEX(DATA!A3:C12,MATCH(A20,DATA!A3:A12,0),3),INDEX(DATA!E3:G12,MATCH(A20,DATA!E3:E12,0),3))","v":219.1},null,0,0,0]
["Results"]
["Filled Pipe Weight (kg)",{"$f":"SUM(H12:H20)","v":11417.106693600008}]
["No. Of Supports",22]
["One Support Load (kg)",{"$f":"B22*5/B23+115","v":2709.7969758181835}]
["Prepared By Eng. Ali hassan"]

{"sheet":"DATA","index":1,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":true,"merged":[[0,0,0,2],[0,4,0,6]]}
["Steel Schedule 40",null,null,null,"copper type-k"]
["D.N","I.D","O.D",null,"D.N","I.D","O.D"]
[1,26.6,33.4,null,1,25.3,28.6]
[1.25,35.1,42.2,null,1.25,31.6,34.9]
[1.5,40.9,48.3,null,1.5,37.6,41.3]
[2,52.5,60.3,null,2,49.8,54]
[2.5,62.7,73,null,2.5,61.8,66.7]
[3,77.900000000000006,88.9,null,3,73.8,79.400000000000006]
[4,102.3,114.3,null,4,98,104.8]
[6,154.1,168.3,null,6,145.80000000000001,155.6]
[8,202.7,219.1,null,8,192.6,206.4]
[10,254,273.10000000000002,null,10,240,257.3]
[]
["liquid","density (kg/m3)",null,null,"material","density (kg/m3)"]
["Water",1000,null,null,"Steel Sch.40",8050]
["Diesel",830,null,null,"Copper (Type-K)",8960]
["Alcohol",790]

{"sheet":"Refernces","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}