{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["INSTALLATION","CONVERSION","KW COST","Langue","GLOBAL DATA","CONVERSION _DATA"],"not_rendered":{"charts":1,"images":72,"macros":1,"external_links":0,"defined_names":140,"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":"INSTALLATION","index":0,"n_rows":58,"n_cols":30,"rows_kept":58,"cut":false,"hidden":false,"merged":[[2,6,4,18],[7,13,7,16],[10,8,10,11],[12,8,12,11],[12,13,12,16],[12,18,12,21],[12,23,12,25],[16,13,16,14],[16,18,16,19],[17,13,17,14],[17,18,17,19],[18,13,18,14],[18,18,18,19],[21,8,21,9],[33,18,33,20],[34,24,35,24],[34,25,35,25],[36,8,36,10],[36,13,36,15],[36,18,36,20],[21,13,21,14],[21,18,21,19],[24,13,24,14],[24,18,24,19],[26,3,27,6],[33,8,33,10],[33,13,33,15]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"   Power :   1kW = \",KW_COST,\" \",CUR_CURRENCY)","v":"   Power :   1kW = 3.504 EURO"}]
[]
[null,null,null,"Hours",null,null,null,null,null,null,null,18.0,null,"WORKING PRESSURE"]
[null,null,null,"Days",null,null,null,null,null,null,null,7.0,null,null,61.0]
[null,null,null,"Weeks",null,null,null,null,null,null,null,42.0]
[null,null,null,"Annual running Hours ",null,null,null,null,{"$f":"+L10*L9*L8","v":5292},null,null,null,null,null,{"$f":"O9/10","v":6.1},"  Bar"]
[]
[null,null,null,"DISTRIBUTION",null,null,null,null,{"$f":"IF(INSTALL_MAIN_TYPE=\"RING\",\"MAIN RING\",\"MAIN PIPE\")","v":"MAIN PIPE"},null,null,null,null,{"$f":"IF(INSTALL_DIST1_TYPE=\"RING\",\"DISTRIBUTION RING 1\",\"DISTRIBUTION PIPE 1\")","v":"DISTRIBUTION RING 1"},null,null,null,null,{"$f":"IF(INSTALL_DIST2_TYPE=\"RING\",\"DISTRIBUTION RING 2\",\"DISTRIBUTION PIPE 2\")","v":"DISTRIBUTION RING 2"},null,null,null,null,"Key to Icons"]
[null,null,null,"Type",null,null,null,null,null,true,null,false,null,null,true,null,false,null,null,true,null,false,null,"Seat valve"]
[null,null,null,null,null,null,null,null,null,3506.0,null,null,null,null,3806.0,null,null,null,null,2672.0,null,null,null,null,0.044,"Bar*"]
[null,null,null,"Volume Flow Rate"]
[null,null,null,null,null,null,null,null,null,{"$f":"J15","v":3506},"m3/h",null,null,{"$f":"O15","v":3806},null,"m3/h",null,null,{"$f":"T15","v":2672},null,"m3/h",null,null,"Diaphragm valve"]
[null,null,null,null,null,null,null,null,null,{"$f":"J17*CONV_M3H_CFM","v":2063.281},"Cfm",null,null,{"$f":"N17*CONV_M3H_CFM","v":2239.831},null,"Cfm",null,null,{"$f":"S17*CONV_M3H_CFM","v":1572.472},null,"Cfm",null,null,null,0.012,"Bar"]
[null,null,null,null,null,null,null,null,null,{"$f":"J17*CONV_M3H_LS","v":973.8888889},"l/s",null,null,{"$f":"N17*CONV_M3H_LS","v":1057.222222},null,"l/s",null,null,{"$f":"S17*CONV_M3H_LS","v":742.2222222},null,"l/s"]
[null,null,null,"Pipe Length",null,null,null,null,null,2898.0,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gate valve"]
[null,null,null,"(furthest point)",null,null,null,null,null,null,null,null,null,null,null,2286.0,null,null,null,null,2636.0,null,null,null,0.003,"Bar"]
[null,null,null,null,null,null,null,null,{"$f":"J20","v":2898},null,"m",null,null,{"$f":"P21","v":2286},null,"m",null,null,{"$f":"U21","v":2636},null,"m"]
[null,null,null,"Pipe Inner Diameter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elbow"]
[null,null,null,null,null,null,null,null,null,null," 2 \"",null,null,null,null," 1\"",null,null,null,null," 1 \" 1/2",null,null,null,0.015,"Bar"]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(K24,PIPE_DIAMETERS,2,FALSE)","v":" 50 - 60"},"mm",null,null,{"$f":"VLOOKUP(P24,PIPE_DIAMETERS,2,FALSE)","v":" 26 - 34"},null,"mm",null,null,{"$f":"VLOOKUP(U24,PIPE_DIAMETERS,2,FALSE)","v":" 40 - 49"},null,"mm"]
[null,null,null,"Valves, bends, …",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bends R = d"]
[null,null,null,"(click on the icons to add components to the system)",null,null,null,null,1.0,10.0,0.0,0.0,null,0.0,0.0,0.0,0.0,null,0.0,0.0,0.0,0.0,null,null,0.003,"Bar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bends R = 2d"]
[null,null,null,null,null,null,null,null,0.0,0.0,5.0,0.0,null,0.0,0.0,0.0,0.0,null,0.0,0.0,0.0,0.0,null,null,0.015,"Bar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tpieces, hoses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0,null,0.019,"Bar"]
[]
[null,null,null,"Pressure drop",null,null,null,null,{"$f":"IF(INSTALL_MAIN_TYPE=\"RING\",(160000000*((J17/2/3600)^1.85*(I22+AA57))/(AB48^5*(O11+1))),(160000000*((J17/3600)^1.85*(I22+AA57))/(AB48^5*(INST_WORK_PRESS+1))))","v":198.9996918},null,null,"Bar",null,{"$f":"IF(INSTALL_DIST1_TYPE=\"RING\",(160000000*((N17/2/3600)^1.85*(N22+AB57))/(AC48^5*(O11+1))),(160000000*((N17/3600)^1.85*(N22+AB57))/(AC48^5*(INST_WORK_PRESS+1))))","v":1621.959286},null,null,"Bar",null,{"$f":"IF(INSTALL_DIST2_TYPE=\"ring\",(160000000*((S17/2/3600)^1.85*(S22+AC57))/(AD48^5*(O11+1))),(160000000*((S17/3600)^1.85*(S22+AC57))/(AD48^5*(INST_WORK_PRESS+1))))","v":92.70206413},null,null,"Bar",0.0,"Reducers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.005,"Bar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0]
[null,null,null,"Annual Cost",null,null,null,null,{"$f":"I34*(AA58*0.07)*INST_ANN_HOURS*KW_COST","v":121877754.2},null,null,{"$f":"CUR_CURRENCY","v":"EURO"},null,{"$f":"N34*(AB58*0.07)*INST_ANN_HOURS*KW_COST","v":1170619810},null,null,{"$f":"CUR_CURRENCY","v":"EURO"},null,{"$f":"S34*(AC58*0.07)*INST_ANN_HOURS*KW_COST","v":35426396.95},null,null,{"$f":"CUR_CURRENCY","v":"EURO"}]
[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,"* exemple of pressure drop through a 25 mm pipe for a 200 m3/h (118 cfm) compressor"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"R3","R2","R1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R1","R2","R3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,10.0,15.0,20.0,25.0,32.0,40.0,50.0,65.0,80.0,90.0,100.0,125.0,150.0,null,{"$f":"CP_INST_1","v":50},{"$f":"CP_INST_2","v":25},{"$f":"CP_INST_3","v":40}]
[null,null,null,null,null,null,null,null,0.0,0.0,0.0,null,"A",2.0,3.0,4.0,4.5,6.0,7.5,12.5,15.0,17.5,20.0,22.5,35.0,42.5,null,{"$f":"HLOOKUP($AB$48,$N$48:$Z$56,2,FALSE)","v":12.5},{"$f":"HLOOKUP($AC$48,$N$48:$Z$56,2,FALSE)","v":4.5},{"$f":"HLOOKUP($AD$48,$N$48:$Z$56,2,FALSE)","v":7.5}]
[null,null,null,null,null,null,null,null,0.0,0.0,0.0,null,"B",0.55,0.7,0.95,1.2,1.7,2.0,3.0,3.7,4.5,5.25,6.0,8.0,10.0,null,{"$f":"HLOOKUP($AB$48,$N$48:$Z$56,3,FALSE)","v":3},{"$f":"HLOOKUP($AC$48,$N$48:$Z$56,3,FALSE)","v":1.2},{"$f":"HLOOKUP($AD$48,$N$48:$Z$56,3,FALSE)","v":2}]
[null,null,null,null,null,null,null,null,0.0,0.0,0.0,null,"C",0.15,0.18,0.22,0.3,0.4,0.5,0.7,0.85,1.0,1.25,1.5,2.0,2.5,null,{"$f":"HLOOKUP($AB$48,$N$48:$Z$56,4,FALSE)","v":0.7},{"$f":"HLOOKUP($AC$48,$N$48:$Z$56,4,FALSE)","v":0.3},{"$f":"HLOOKUP($AD$48,$N$48:$Z$56,4,FALSE)","v":0.5}]
[null,null,null,null,null,null,null,null,0.0,0.0,0.0,null,"D",0.06,0.08,1.0,1.5,2.0,2.5,3.5,4.25,5.0,6.0,7.0,10.0,15.0,null,{"$f":"HLOOKUP($AB$48,$N$48:$Z$56,5,FALSE)","v":3.5},{"$f":"HLOOKUP($AC$48,$N$48:$Z$56,5,FALSE)","v":1.5},{"$f":"HLOOKUP($AD$48,$N$48:$Z$56,5,FALSE)","v":2.5}]
[null,null,null,null,null,null,null,null,0.0,0.0,0.0,null,"E",0.15,0.18,0.22,0.3,0.4,0.5,0.6,0.8,1.0,1.25,1.5,2.0,2.5,null,{"$f":"HLOOKUP($AB$48,$N$48:$Z$56,6,FALSE)","v":0.6},{"$f":"HLOOKUP($AC$48,$N$48:$Z$56,6,FALSE)","v":0.3},{"$f":"HLOOKUP($AD$48,$N$48:$Z$56,6,FALSE)","v":0.5}]
[null,null,null,null,null,null,null,null,0.0,0.0,0.0,null,"F",0.08,0.1,0.12,0.15,0.2,0.25,0.3,0.4,0.5,0.65,0.8,1.0,1.5,null,{"$f":"HLOOKUP($AB$48,$N$48:$Z$56,7,FALSE)","v":0.3},{"$f":"HLOOKUP($AC$48,$N$48:$Z$56,7,FALSE)","v":0.15},{"$f":"HLOOKUP($AD$48,$N$48:$Z$56,7,FALSE)","v":0.25}]
[null,null,null,null,null,null,null,null,0.0,0.0,0.0,null,"G",0.8,1.15,1.5,2.0,2.5,3.0,4.0,5.5,7.0,8.5,10.0,15.0,20.0,null,{"$f":"HLOOKUP($AB$48,$N$48:$Z$56,8,FALSE)","v":4},{"$f":"HLOOKUP($AC$48,$N$48:$Z$56,8,FALSE)","v":2},{"$f":"HLOOKUP($AD$48,$N$48:$Z$56,8,FALSE)","v":3}]
[null,null,null,null,null,null,null,null,0.0,0.0,0.0,null,"H",0.2,0.3,0.4,0.5,0.6,0.7,1.0,1.5,2.0,2.25,2.5,3.5,4.0,null,{"$f":"HLOOKUP($AB$48,$N$48:$Z$56,9,FALSE)","v":1},{"$f":"HLOOKUP($AC$48,$N$48:$Z$56,9,FALSE)","v":0.5},{"$f":"HLOOKUP($AD$48,$N$48:$Z$56,9,FALSE)","v":0.7}]
[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,"TOTAL",{"$f":"SUMPRODUCT(K49:K56,AB49:AB56)","v":0},{"$f":"SUMPRODUCT(J49:J56,AC49:AC56)","v":0},{"$f":"SUMPRODUCT(I49:I56,AD49:AD56)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POWER",null,null,null,null,{"$f":"0.000000008*J15^3-0.00002*J15^2+0.1059*J15+1.6232","v":471.8349057},{"$f":"0.000000008*O15^3-0.00002*O15^2+0.1059*O15+1.6232","v":556.0245249},{"$f":"0.000000008*T15^3-0.00002*T15^2+0.1059*T15+1.6232","v":294.4120676}]

{"sheet":"CONVERSION","index":1,"n_rows":110,"n_cols":13,"rows_kept":110,"cut":false,"hidden":false,"merged":[[22,1,22,5],[28,1,28,5],[29,7,30,7],[29,8,30,8],[29,11,30,11],[4,1,4,5],[4,7,4,11],[10,1,10,5],[10,7,10,11],[16,1,16,5],[16,7,16,11],[22,7,22,11]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"   Power :   1kW = \",KW_COST,\" \",CUR_CURRENCY)","v":"   Power :   1kW = 3.504 EURO"}]
[]
[null,"FLOW RATE conversion ",null,null,null,null,null,"TEMPERATURE conversion "]
[]
[null,"100","m3/h","=",{"$f":"ROUND(CONV_FLOW_RATE_IN*'CONVERSION _DATA'!AH10,3)","v":27.778},"Litre/sec",null,"100","°C","=",{"$f":"ROUND(CONV_TEMPERATURE_IN*'CONVERSION _DATA'!AZ5+'CONVERSION _DATA'!BA5,3)","v":132},"°F"]
[]
[]
[]
[null,"PRESSURE conversion ",null,null,null,null,null,"OIL CONTENT conversion "]
[]
[null,"100","PSI","=",{"$f":"ROUND(CONV_PRESSURE_IN*'CONVERSION _DATA'!R28,3)","v":6.895},"Bar",null,"100","mg/m3","=",{"$f":"ROUND(CONV_OIL_IN*'CONVERSION _DATA'!AD26,3)","v":83.333},"ppm"]
[]
[]
[]
[null,"ENERGY conversion ",null,null,null,null,null,"VOLUME conversion "]
[]
[null,"100","kW/h","=",{"$f":"IF('CONVERSION _DATA'!V45=\"-\",\"No conversion\",ROUND(CONV_ENERGY_IN*'CONVERSION _DATA'!V45,3))","v":360077.489},"Joule",null,"100","m3","=",{"$f":"ROUND(CONV_VOLUME_IN*'CONVERSION _DATA'!AH21,3)","v":3531.47},"Ft3"]
[]
[]
[]
[null,"POWER conversion ",null,null,null,null,null,"F.A.D.@ 7 bar / ALTITUDE CORRECTION "]
[]
[null,"100","Watt","=",{"$f":"ROUND(CONV_POWER_IN*'CONVERSION _DATA'!Z54,3)","v":74570},"HP"]
[null,null,null,null,null,null,null,"100",null,"=",{"$f":"CONV_ALTITUDE_IN*'CONVERSION _DATA'!AK20","v":89.005},{"$f":"IF(M27=\"Pint\",M27&\"s\",IF(M27=\"Gallon\",M27&\"s\",IF(M27=\"Litre\",M27&\"s\",M27)))","v":"cm3"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"cm3"]
[]
[null,"LENGTH conversion "]
[null,null,null,null,null,null,null,"Height","=",null,null,{"$f":"K31&\" m\"","v":"2313 m"}]
[null,"100","Metre","=",{"$f":"ROUND(CONV_LENGTH_IN*'CONVERSION _DATA'!Z37,3)","v":109.361},"Yard",null,null,null,null,2313.0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"J/sec"]
[]
[]
[]
[]
[]
[null,null,null,null,null,"J/sec"]
[]
[]
[]
[]
[]
[null,null,null,null,null,"°F"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"J/sec"]
[]
[]
[null,null,null,null,null,"°F"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"J/sec"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"°F"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"°F"]

{"sheet":"KW COST","index":2,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[6,6,6,8],[12,2,12,4],[12,6,13,8],[14,6,15,8]]}
[]
[]
[]
[]
[]
[]
[null,null,"Use the scrollbar to the right to",null,null,null,"Power Cost per kW"]
[null,null,"adjust the cost of the power."]
[null,null,null,null,null,null,null,3504.0]
[null,null,"Use the drop down box below"]
[null,null,"to select your country/currency."]
[]
[null,null,"Country Selection",null,null,null,"Cost in local currency:"]
[]
[null,null,null,"Belgium",null,null,{"$f":"\"1 kW = \"&H9/1000&\" \"&CUR_CURRENCY","v":"1 kW = 3.504 EURO"}]

{"sheet":"Langue","index":3,"n_rows":40,"n_cols":4,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
[]
["English","English","Français","Votre langue / Your language"]
[]
["Air demand","Air demand","Consommation"]
["Pressure","Pressure","Pression"]
["Air delivery","Air delivery","Débit délivré"]
["Energy Savings - ROLLAIR® V","Energy Savings","Economie d'énergie - ROLLAIR® V"]
["Project Ref.","Project Ref.","Réf. Projet"]
["Company","Company","Société"]
["Contact name","Contact name","Nom contact"]
["Annual Hours","Annual Hours","Heures par an"]
["Hours per day","Hours per day","Heures par jour"]
["Days per week","Days per week","Jours par semaine"]
["Weeks per year","Weeks per year","Semaines par an"]
["Hours","Hours","Heures"]
["Min","Min","Min"]
["Days","Days","Jours"]
["Weeks","Weeks","Semaines"]
["Cost of","Cost of","Coût d'"]
["Cost of","Cost of","Coût d'"]
["Country","Country","Pays"]
["Screw compressor","Screw compressor","Compresseur à vis ROLLAIR®"]
["Variable screw compressor","Variable screw compressor","Compresseur à vis à vitesse variable ROLLAIR® V"]
["Pressure (bar)","Pressure (bar)","Pression (bar)"]
["Energy cost","Energy cost","Coût de l'energie"]
["kWh","kWh","kWh"]
["m3 cost","m3 cost","Coût du m3"]
["Set Pressure","Set Pressure","Pression consigne"]
["Air demand","Air demand","Consommation d'air"]
["Extra Investment","Extra Investment","Investissement supplémentaire"]
["ENERGY SAVINGS FOR THE PERIOD","ENERGY SAVINGS FOR THE PERIOD","ECONOMIE D'ENERGIE SUR LA PERIODE"]
["Pay Back","Pay Back","Retour sur investissement"]
["Month(s)","Month(s)","Mois(s)"]
["Year(s)","Year(s)","An(s)"]
["Operating hours","Operating hours","Heures de fonctionnement"]
["Remaining time","Remaining time","Temps restant"]
["From","From","De"]
["to","to","à"]
["ANNUAL ENERGY SAVINGS","ANNUAL ENERGY SAVINGS","ECONOMIE D'ENERGIE ANNUELLE"]
["Compressors","Compressors","Compresseurs"]

{"sheet":"GLOBAL DATA","index":4,"n_rows":352,"n_cols":8,"rows_kept":352,"cut":false,"hidden":true,"merged":[[102,1,106,1]]}
[null,"ALL DATA MOVED AND DEFINED BY INTUITVE MEDIA IS IN THIS SHEET (APART FROM ROLLAIR V STUFF)"]
[]
[null,"CURRENCY AND KW DATA"]
[]
[null,"Currency Lookup List",null,null,"Country"]
[null,"Austria","ATS",null,"Belgium"]
[null,"Belgium","EURO"]
[null,"Brasil","USD",null,"Current Currency"]
[null,"China","UKD",null,{"$f":"VLOOKUP(CUR_COUNTRY,CURRENCIES,2)","v":"EURO"}]
[null,"Czech Republic","CZK"]
[null,"Denmark","DKK",null,"Cost per KW"]
[null,"Egypt","EGP",null,3.504]
[null,"Finland","FIM"]
[null,"France","EURO",null,"String for Graphs"]
[null,"Germany","EURO",null,{"$f":"CONCATENATE(CUR_CURRENCY,GRAPH_UNITS)","v":"EURO /l/s"}]
[null,"Greece","EURO"]
[null,"Hungary","HUF",null,"Units for graphs"]
[null,"India","INR",null," /l/s"]
[null,"Indonesia","IDR"]
[null,"Ireland","EURO"]
[null,"Italy","EURO"]
[null,"Japan","JPY"]
[null,"Mexico","USD"]
[null,"Morroco","MAD"]
[null,"Netherlands","EURO"]
[null,"Norway","NOK"]
[null,"Poland","PLZ"]
[null,"Portugal","PTE"]
[null,"Russia","RUR"]
[null,"South Africa","ZAR"]
[null,"Spain","EURO"]
[null,"Sweden","SEK"]
[null,"Switzerland","CHF"]
[null,"Turkey","TRL"]
[null,"U.K.","GBP"]
[null,"USA","USD"]
[null,"Yugoslavia","YUN"]
[]
[]
[]
[null,"AIR USAGE DATA"]
[]
[null,"Volume m3/h",1067.0]
[null,"Volume CFM",{"$f":"ROUND(AU_VOL_M3*CONV_M3H_CFM,3)","v":627.93}]
[null,"Volume L/s",{"$f":"ROUND(AU_VOL_M3*CONV_M3H_LS,3)","v":296.389}]
[null,"Motor Power","250"]
[]
[]
[null,"AIR LEAKAGE DATA"]
[]
[null,"Air Leakage Power",195.0]
[null,"Air Leakage Receiver Cap",4673.0]
[null,"Total Net Cap Length",2920.0]
[null,"Total Net Cap Dia"," 2 \""]
[null,"Total Net Capacity m3",{"$f":"(((CP_AIR_LEAKAGE/2/1000)^2)*PI()*AL_NET_CAP_LEN)+(AL_REC_CAP/1000)","v":"#REF!"}]
[]
[null,"PIPE_DIAMETERS (LOOKUP)"]
[null," 1/8 \""," 5 -10","NOT USED"]
[null," 1/4 \""," 8 -13","NOT USED"]
[null," 3/8 \""," 12 - 17"]
[null," 1/2 \""," 15 - 21"]
[null," 3/4 \""," 20 - 27"]
[null," 1\""," 26 - 34"]
[null," 1 \" 1/4"," 33 - 42"]
[null," 1 \" 1/2"," 40 - 49"]
[null," 2 \""," 50 - 60"]
[null," 2 \" 1/2"," 66 - 76"]
[null," 3 \""," 80 - 90"]
[null," 3 \" 1/2"," 90 -102"]
[null," 4\""," 102 - 114"]
[null," 5\"","126 - 141"]
[null," 6\"","152 - 170"]
[]
[]
[null,"LOAD DUTY DATA"]
[]
[null,"Compressor Capacity",1324.0]
[null,"Air Demand",584.0,null,null,"Graph Data"]
[null,"Minimum Pressure",58.0,null,null,{"$f":"NRG_SINGLE","v":"Rollair 4000 A - PCI06 IP23"},{"$f":"#REF!","v":"#REF!"},"#REF!"]
[null,"Compressor 1 Diff",7.0,null,null,{"$f":"NRG_BASE&\" - \"&NRG_TOP","v":"Rollair 2000 A IP23 - Rollair 2000 A IP23"},{"$f":"#REF!","v":"#REF!"},"#REF!"]
[null,"Compressor 2 Diff",18.0]
[null,"Piping Diamater"," 2 \""]
[null,"Receiver Capacity",20000.0]
[null,"Network Length",5000.0]
[]
[]
[null,"TOTAL Netwok Capacity Data (LOAD_DUTY_DATA LOOKUP)"]
[null," 5 -10",6.0]
[null," 8 -13",8.0]
[null," 12 - 17",10.0]
[null," 15 - 21",15.0]
[null," 20 - 27",20.0]
[null," 26 - 34",25.0]
[null," 33 - 42",32.0]
[null," 40 - 49",40.0]
[null," 50 - 60",50.0]
[null," 66 - 76",65.0]
[null," 80 - 90",80.0]
[null," 90 -102",90.0]
[null," 102 - 114",100.0]
[null,"126 - 141",125.0]
[null,"152 - 170",150.0]
[null,"These values look up the values in the table above but only the first value is actually used in the interface!",{"$f":"VLOOKUP(#REF!,LOAD_DUTY_DATA,2,FALSE)","v":"#REF!"},"LOAD_DUTY"]
[null,null,{"$f":"VLOOKUP(#REF!,LOAD_DUTY_DATA,2,FALSE)","v":"#REF!"},"AIR_LEAKAGE"]
[null,null,{"$f":"VLOOKUP(INSTALLATION!J25,LOAD_DUTY_DATA,2,FALSE)","v":50},"INSTALLATION"]
[null,null,{"$f":"VLOOKUP(INSTALLATION!N25,LOAD_DUTY_DATA,2,FALSE)","v":25},"INSTALLATION"]
[null,null,{"$f":"VLOOKUP(INSTALLATION!S25,LOAD_DUTY_DATA,2,FALSE)","v":40},"INSTALLATION"]
[]
[]
[]
[]
[]
[]
[]
[null,"ENERGY DATA (COMPRESSOR COMPARISON)"]
[]
[null,"Single Unit","Rollair 4000 A - PCI06 IP23"]
[null,"Base Load","Rollair 2000 A IP23"]
[null,"Top Up","Rollair 2000 A IP23"]
[]
[]
[null,null,null,null,null,{"$f":"(VLOOKUP(\"Rollair 4000 A - PCI06 IP23\",COMPRESSOR_DATA,11))","v":"#REF!"}]
[]
[]
[null,"Base + Top Cap",{"$f":"SUM(NRG_BASE_CAP,nrg_top_cap)","v":"#REF!"}]
[null,"Air Usage Max",{"$f":"MIN(NRG_SINGLE_CAP,NRG_BASE_TOP_CAP)","v":"#REF!"}]
[null,"Yearly running Hrs",5872.0]
[null,"Air Usage",52.0]
[]
[null,"Base Fan Cost",{"$f":"IF(NRG_FAN_POWER=\"\",\"\",NRG_BASE_MOTOR_FAN*NRG_HRS_YR/(NRG_BASE_MOTOR_EFF/100)*KW_COST)","v":"#REF!"}]
[null,"Top Up Fan Cost",{"$f":"IF(NRG_FAN_POWER=\"\",\"\",NRG_TOP_MOTOR_FAN*NRG_HRS_YR/(NRG_TOP_MOTOR_EFF/100)*KW_COST)","v":"#REF!"}]
[]
[]
[]
[]
[]
[]
[null,"INSTALLATION DATA"]
[]
[null,"Main distribution Type","PIPE"]
[null,"Distribution 1 Type","RING"]
[null,"Distribution 2 Type","RING"]
[]
[]
[null,"DUCTWORK DATA"]
[]
[null,"DUCT_FD_DATA"]
[null,"Dh","Fd"]
[null,60.0,0.67]
[null,70.0,0.52]
[null,80.0,0.38]
[null,90.0,0.32]
[null,100.0,0.29]
[null,110.0,0.26]
[null,120.0,0.23]
[null,130.0,0.2]
[null,140.0,0.18]
[null,150.0,0.17]
[null,160.0,0.16]
[null,170.0,0.15]
[null,180.0,0.14]
[null,190.0,0.13]
[null,200.0,0.12]
[null,210.0,0.11]
[null,220.0,0.1]
[null,230.0,0.099]
[null,240.0,0.095]
[null,250.0,0.091]
[null,260.0,0.088]
[null,270.0,0.084]
[null,280.0,0.08]
[null,290.0,0.076]
[null,300.0,0.073]
[null,310.0,0.071]
[null,320.0,0.069]
[null,330.0,0.067]
[null,340.0,0.065]
[null,350.0,0.062]
[null,360.0,0.06]
[null,370.0,0.058]
[null,380.0,0.056]
[null,390.0,0.055]
[null,400.0,0.055]
[null,410.0,0.052]
[null,420.0,0.049]
[null,430.0,0.048]
[null,440.0,0.046]
[null,450.0,0.045]
[null,460.0,0.044]
[null,470.0,0.043]
[null,480.0,0.042]
[null,490.0,0.04]
[null,500.0,0.039]
[null,510.0,0.039]
[null,520.0,0.038]
[null,530.0,0.037]
[null,540.0,0.036]
[null,550.0,0.035]
[null,560.0,0.033]
[null,570.0,0.033]
[null,580.0,0.032]
[null,590.0,0.031]
[null,600.0,0.03]
[null,610.0,0.03]
[null,620.0,0.03]
[null,630.0,0.029]
[null,640.0,0.029]
[null,650.0,0.028]
[null,660.0,0.028]
[null,670.0,0.027]
[null,680.0,0.027]
[null,690.0,0.026]
[null,700.0,0.026]
[null,710.0,0.026]
[null,720.0,0.025]
[null,730.0,0.025]
[null,740.0,0.024]
[null,750.0,0.024]
[null,760.0,0.024]
[null,770.0,0.023]
[null,780.0,0.023]
[null,790.0,0.023]
[null,800.0,0.023]
[null,810.0,0.022]
[null,820.0,0.022]
[null,830.0,0.021]
[null,840.0,0.021]
[null,850.0,0.02]
[null,860.0,0.02]
[null,870.0,0.02]
[null,880.0,0.02]
[null,890.0,0.019]
[null,900.0,0.019]
[null,910.0,0.019]
[null,920.0,0.019]
[null,930.0,0.018]
[null,940.0,0.018]
[null,950.0,0.018]
[null,960.0,0.018]
[null,970.0,0.018]
[null,980.0,0.017]
[null,990.0,0.017]
[null,1000.0,0.017]
[null,1010.0,0.017]
[null,1020.0,0.016]
[null,1030.0,0.016]
[null,1040.0,0.016]
[null,1050.0,0.016]
[null,1060.0,0.016]
[null,1070.0,0.015]
[null,1080.0,0.015]
[null,1090.0,0.015]
[null,1100.0,0.015]
[null,1110.0,0.015]
[null,1120.0,0.015]
[null,1130.0,0.015]
[null,1140.0,0.015]
[null,1150.0,0.015]
[null,1160.0,0.015]
[null,1170.0,0.014]
[null,1180.0,0.014]
[null,1190.0,0.014]
[null,1200.0,0.014]
[null,1210.0,0.014]
[null,1220.0,0.013]
[null,1230.0,0.013]
[null,1240.0,0.013]
[null,1250.0,0.013]
[null,1260.0,0.013]
[null,1270.0,0.013]
[null,1280.0,0.013]
[null,1290.0,0.013]
[null,1300.0,0.013]
[null,1310.0,0.012]
[null,1320.0,0.012]
[null,1330.0,0.012]
[null,1340.0,0.012]
[null,1350.0,0.012]
[null,1360.0,0.012]
[null,1370.0,0.012]
[null,1380.0,0.012]
[null,1390.0,0.012]
[null,1400.0,0.012]
[null,1410.0,0.011]
[null,1420.0,0.011]
[null,1430.0,0.011]
[null,1440.0,0.011]
[null,1450.0,0.011]
[null,1460.0,0.011]
[null,1470.0,0.01]
[null,1480.0,0.01]
[null,1490.0,0.01]
[null,1500.0,0.01]
[null,1510.0,0.01]
[null,1520.0,0.01]
[null,1530.0,0.01]
[null,1540.0,0.0099]
[null,1550.0,0.0099]
[null,1560.0,0.0099]
[null,1570.0,0.0098]
[null,1580.0,0.0097]
[null,1590.0,0.0097]
[null,1600.0,0.0096]
[null,1610.0,0.0095]
[null,1620.0,0.0095]
[null,1630.0,0.0094]
[null,1640.0,0.0093]
[null,1650.0,0.0092]
[null,1660.0,0.0091]
[null,1670.0,0.009]
[null,1680.0,0.009]
[null,1690.0,0.0089]
[null,1700.0,0.0088]
[null,1710.0,0.0088]
[null,1720.0,0.0087]
[null,1730.0,0.0086]
[null,1740.0,0.0086]
[null,1750.0,0.0085]
[null,1760.0,0.0085]
[null,1770.0,0.0084]
[null,1780.0,0.0084]
[null,1790.0,0.0083]
[null,1800.0,0.0082]
[null,1810.0,0.0082]
[null,1820.0,0.0082]
[null,1830.0,0.0081]
[null,1840.0,0.0081]
[null,1850.0,0.008]
[null,1860.0,0.008]
[null,1870.0,0.0079]
[null,1880.0,0.0078]
[null,1890.0,0.0078]
[null,1900.0,0.0078]
[null,1910.0,0.0078]
[null,1920.0,0.0077]
[null,1930.0,0.0076]
[null,1940.0,0.0075]
[null,1950.0,0.0075]
[null,1960.0,0.0075]
[null,1970.0,0.0074]
[null,1980.0,0.0074]
[null,1990.0,0.0073]
[null,2000.0,0.0073]
[null,2010.0,0.0073]
[null,2020.0,0.0072]
[null,2030.0,0.0072]
[null,2040.0,0.0072]
[null,2050.0,0.0072]
[null,2060.0,0.0071]
[null,2070.0,0.0071]
[null,2080.0,0.0071]
[null,2090.0,0.0071]

{"sheet":"CONVERSION _DATA","index":5,"n_rows":61,"n_cols":53,"rows_kept":61,"cut":false,"hidden":true,"merged":[]}
["PRESSURE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEMPERATURE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","+"]
["Cfm",1.0,"Cfm",null,"Cfm",{"$f":"1/B3","v":0.4720098178},"Litre/sec",null,"Cfm",{"$f":"1/B4","v":28.32058907},"Litre/min",null,"Cfm",{"$f":"1/B5","v":1699.235344},"Litre/h",null,"Cfm",{"$f":"1/B6","v":0.02832058907},"m3/min",null,"Cfm",{"$f":"1/B7","v":1.699235344},"m3/h",null,"Cfm",{"$f":"1/B8","v":0.0004720098178},"m3/s",null,"Cfm",1.8248,"Nm3/h",null,{"$f":"C2","v":"Cfm"},{"$f":"B10","v":0.5885},null,"°C",1.0,"°C",0.0,null,"°C",{"$f":"5/9","v":0.5555555556},"°F",{"$f":"-160/9","v":-17.77777778},null,"°C",1.0,"°K",-273.0,null,"°C",{"$f":"+AK5","v":1},{"$f":"+AM5","v":32}]
["Litre/sec",2.1186,"Cfm",null,"Litre/sec",1.0,"Litre/sec",null,"Litre/sec",60.0,"Litre/min",null,"Litre/sec",3600.0,"Litre/h",null,"Litre/sec",0.06,"m3/min",null,"Litre/sec",3.6,"m3/h",null,"Litre/sec",0.001,"m3/s",null,"Litre/sec",{"$f":"AD7*V3","v":3.354266212},"Nm3/h",null,{"$f":"G2","v":"Litre/sec"},{"$f":"F10","v":0.2777777778},null,"°F",{"$f":"9/5","v":1.8},"°C",32.0,null,"°F",1.0,"°F",0.0,null,"°F",{"$f":"9/5","v":1.8},"°K",{"$f":"-2297/5","v":-459.4},null,"°F",{"$f":"+AP5","v":0.5555555556},{"$f":"+AR5","v":0}]
["Litre/min",{"$f":"B3*F4","v":0.03531},"Cfm",null,"Litre/min",{"$f":"1/60","v":0.01666666667},"Litre/sec",null,"Litre/min",1.0,"Litre/min",null,"Litre/min",60.0,"Litre/h",null,"Litre/min",0.001,"m3/min",null,"Litre/min",0.06,"m3/h",null,"Litre/min",{"$f":"1/60000","v":0.00001666666667},"m3/s",null,"Litre/min",{"$f":"AD7*V4","v":0.05590443686},"Nm3/h",null,{"$f":"K2","v":"Litre/min"},{"$f":"J10","v":16.66666667},null,"°K",1.0,"°C",273.0,null,"°K",{"$f":"5/9","v":0.5555555556},"°F",{"$f":"2297/9","v":255.2222222},null,"°K",1.0,"°K",0.0,null,"°K",{"$f":"+AU5","v":1},{"$f":"+AW5","v":-459.4}]
["Litre/h",{"$f":"F5*B3","v":0.0005885},"Cfm",null,"Litre/h",{"$f":"1/3600","v":0.0002777777778},"Litre/sec",null,"Litre/h",{"$f":"1/60","v":0.01666666667},"Litre/min",null,"Litre/h",1.0,"Litre/h",null,"Litre/h",{"$f":"1/60000","v":0.00001666666667},"m3/min",null,"Litre/h",0.001,"m3/h",null,"Litre/h",{"$f":"1/3600000","v":0.0000002777777778},"m3/s",null,"Litre/h",{"$f":"AD7*V5","v":0.0009317406143},"Nm3/h",null,{"$f":"O2","v":"Litre/h"},{"$f":"N10","v":1000},null,null,{"$f":"VLOOKUP(CONVERSION!$I$7,AJ2:AM4,2,FALSE)","v":1},null,{"$f":"VLOOKUP(CONVERSION!$L$7,AJ2:AM4,4,FALSE)","v":32},null,null,{"$f":"VLOOKUP(CONVERSION!$I$7,AO2:AR4,2,FALSE)","v":0.5555555556},null,{"$f":"VLOOKUP(CONVERSION!$L$7,AO2:AR4,4,FALSE)","v":0},null,null,{"$f":"VLOOKUP(CONVERSION!$I$7,AT2:AW4,2,FALSE)","v":1},null,{"$f":"VLOOKUP(CONVERSION!$L$7,AT2:AW4,4,FALSE)","v":-459.4},null,null,{"$f":"VLOOKUP(CONVERSION!$I$7,AY2:BA4,2,FALSE)","v":1},{"$f":"VLOOKUP(CONVERSION!$I$7,AY2:BA4,3,FALSE)","v":32}]
["m3/min",{"$f":"+F6*B3","v":35.31},"Cfm",null,"m3/min",{"$f":"1000/60","v":16.66666667},"Litre/sec",null,"m3/min",1000.0,"Litre/min",null,"m3/min",60000.0,"Litre/h",null,"m3/min",1.0,"m3/min",null,"m3/min",60.0,"m3/h",null,"m3/min",{"$f":"1/60","v":0.01666666667},"m3/s",null,"m3/min",{"$f":"+AD7*V6","v":55.90443686},"Nm3/h",null,{"$f":"S2","v":"m3/min"},{"$f":"R10","v":0.01666666667}]
["m3/h",{"$f":"+F7*B3","v":0.5885},"Cfm",null,"m3/h",{"$f":"1000/3600","v":0.2777777778},"Litre/sec",null,"m3/h",{"$f":"1000/60","v":16.66666667},"Litre/min",null,"m3/h",1000.0,"Litre/h",null,"m3/h",{"$f":"1/60","v":0.01666666667},"m3/min",null,"m3/h",1.0,"m3/h",null,"m3/h",{"$f":"1/3600","v":0.0002777777778},"m3/s",null,"m3/h",{"$f":"273/293","v":0.9317406143},"Nm3/h",null,{"$f":"W2","v":"m3/h"},{"$f":"V10","v":1}]
["m3/s",{"$f":"+F8*B3","v":2118.6},"Cfm",null,"m3/s",1000.0,"Litre/sec",null,"m3/s",60000.0,"Litre/min",null,"m3/s",3600000.0,"Litre/h",null,"m3/s",60.0,"m3/min",null,"m3/s",3600.0,"m3/h",null,"m3/s",1.0,"m3/s",null,"m3/s",{"$f":"AD7*V8","v":3354.266212},"Nm3/h",null,{"$f":"AA2","v":"m3/s"},{"$f":"Z10","v":0.0002777777778},null,500.0,0.98]
["Nm3/h",0.548,"Cfm",null,"Nm3/h",{"$f":"1/AD3","v":0.2981277981},"Litre/sec",null,"Nm3/h",{"$f":"1/AD4","v":17.88766789},"Litre/min",null,"Nm3/h",{"$f":"1/AD5","v":1073.260073},"Litre/h",null,"Nm3/h",{"$f":"1/AD6","v":0.01788766789},"m3/min",null,"Nm3/h",{"$f":"1/AD7","v":1.073260073},"m3/h",null,"Nm3/h",{"$f":"1/AD8","v":0.0002981277981},"m3/s",null,"Nm3/h",1.0,"Nm3/h",null,{"$f":"AE2","v":"Nm3/h"},{"$f":"AD10","v":0.9317406143},null,1000.0,0.96]
[null,{"$f":"VLOOKUP(CONVERSION!$C$7,'CONVERSION _DATA'!A2:B9,2,FALSE)","v":0.5885},null,null,null,{"$f":"VLOOKUP(CONVERSION!$C$7,'CONVERSION _DATA'!E2:F9,2,FALSE)","v":0.2777777778},null,null,null,{"$f":"VLOOKUP(CONVERSION!$C$7,'CONVERSION _DATA'!I2:J9,2,FALSE)","v":16.66666667},null,null,null,{"$f":"VLOOKUP(CONVERSION!$C$7,'CONVERSION _DATA'!M2:N9,2,FALSE)","v":1000},null,null,null,{"$f":"VLOOKUP(CONVERSION!$C$7,'CONVERSION _DATA'!Q2:R9,2,FALSE)","v":0.01666666667},null,null,null,{"$f":"VLOOKUP(CONVERSION!$C$7,'CONVERSION _DATA'!U2:V9,2,FALSE)","v":1},null,null,null,{"$f":"VLOOKUP(CONVERSION!$C$7,'CONVERSION _DATA'!Y2:Z9,2,FALSE)","v":0.0002777777778},null,null,null,{"$f":"VLOOKUP(CONVERSION!$C$7,'CONVERSION _DATA'!AC2:AD9,2,FALSE)","v":0.9317406143},null,null,null,{"$f":"VLOOKUP(CONVERSION!$F$7,'CONVERSION _DATA'!AG2:AH9,2,FALSE)","v":0.2777777778},null,1500.0,0.935]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2000.0,0.91]
["VOLUME",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2500.0,0.89]
["cm3",1.0,"cm3",null,"cm3",1.0E-6,"m3",null,"cm3",0.001,"Litre",null,"cm3",0.061024,"Inch3",null,"cm3",3.53E-5,"Ft3",null,"cm3","-","Yd3",null,"cm3",2.2E-4,"Gallon",null,"cm3",0.00176,"Pint",null,"cm3",{"$f":"B21","v":1000000},null,3000.0,0.865]
["m3",1000000.0,"cm3",null,"m3",1.0,"m3",null,"m3",1000.0,"Litre",null,"m3",61023.7,"Inch3",null,"m3",35.3147,"Ft3",null,"m3",1.30795,"Yd3",null,"m3",219.969,"Gallon",null,"m3",1759.75,"Pint",null,"m3",{"$f":"F21","v":1},null,3500.0,0.84]
["Litre",1000.0,"cm3",null,"Litre",0.001,"m3",null,"Litre",1.0,"Litre",null,"Litre",61.0237,"Inch3",null,"Litre",0.035315,"Ft3",null,"Litre",0.001308,"Yd3",null,"Litre",0.219969,"Gallon",null,"Litre",1.759,"Pint",null,"Litre",{"$f":"J21","v":1000},null,4000.0,0.815]
["In3",16.3871,"cm3",null,"In3",1.64E-5,"m3",null,"In3",0.016387,"Litre",null,"In3",1.0,"Inch3",null,"In3",5.787E-4,"Ft3",null,"In3",2.14E-5,"Yd3",null,"In3",0.003605,"Gallon",null,"In3",0.028837,"Pint",null,"In3",{"$f":"N21","v":61023.7}]
["Ft3",28316.8,"cm3",null,"Ft3",0.028317,"m3",null,"Ft3",28.3168,"Litre",null,"Ft3",1728.0,"Inch3",null,"Ft3",1.0,"Ft3",null,"Ft3",0.037037,"Yd3",null,"Ft3",6.22883,"Gallon",null,"Ft3",49.8307,"Pint",null,"Ft3",{"$f":"R21","v":35.3147}]
["Yd3",764555.0,"cm3",null,"Yd3",0.764555,"m3",null,"Yd3",764.555,"Litre",null,"Yd3",46656.0,"Inch3",null,"Yd3",27.0,"Ft3",null,"Yd3",1.0,"Yd3",null,"Yd3",168.1784,"Gallon",null,"Yd3",1345.429,"Pint",null,"Yd3",{"$f":"V21","v":1.30795}]
["Gallon",4546.09,"cm3",null,"Gallon",0.0045461,"m3",null,"Gallon",4.54609,"Litre",null,"Gallon",277.42,"Inch3",null,"Gallon",0.160544,"Ft3",null,"Gallon",0.005946,"Yd3",null,"Gallon",1.0,"Gallon",null,"Gallon",8.0,"Pint",null,"Gallon",{"$f":"Z21","v":219.969}]
["Pint",568.261,"cm3",null,"Pint",5.683E-4,"m3",null,"Pint",0.568261,"Litre",null,"Pint",34.6774,"Inch3",null,"Pint",0.020068,"Ft3",null,"Pint",7.43E-4,"Yd3",null,"Pint",0.125,"Gallon",null,"Pint",1.0,"Pint",null,"Pint",{"$f":"AD21","v":1759.75},null,null,{"$f":"-0.00005*CONVERSION!K31+1.0057","v":0.89005}]
[null,{"$f":"VLOOKUP(CONVERSION!$I$19,'CONVERSION _DATA'!A13:B20,2,FALSE)","v":1000000},null,null,null,{"$f":"VLOOKUP(CONVERSION!$I$19,'CONVERSION _DATA'!E13:F20,2,FALSE)","v":1},null,null,null,{"$f":"VLOOKUP(CONVERSION!$I$19,'CONVERSION _DATA'!I13:J20,2,FALSE)","v":1000},null,null,null,{"$f":"VLOOKUP(CONVERSION!$I$19,'CONVERSION _DATA'!M13:N20,2,FALSE)","v":61023.7},null,null,null,{"$f":"VLOOKUP(CONVERSION!$I$19,'CONVERSION _DATA'!Q13:R20,2,FALSE)","v":35.3147},null,null,null,{"$f":"VLOOKUP(CONVERSION!$I$19,'CONVERSION _DATA'!U13:V20,2,FALSE)","v":1.30795},null,null,null,{"$f":"VLOOKUP(CONVERSION!$I$19,'CONVERSION _DATA'!Y13:Z20,2,FALSE)","v":219.969},null,null,null,{"$f":"VLOOKUP(CONVERSION!$I$19,'CONVERSION _DATA'!AC13:AD20,2,FALSE)","v":1759.75},null,null,null,{"$f":"VLOOKUP(CONVERSION!$L$19,'CONVERSION _DATA'!AG13:AH20,2,FALSE)","v":35.3147}]
[]
["PRESSURE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OIL CONTENT"]
["Bar",1.0,"Bar",null,"Bar",14.504,"PSI",null,"Bar",750.062,"mmHg",null,"Bar",0.9869,"Atmos.",null,"Bar",{"$f":"+B28","v":0.06895},null,null,"ppm",1.0,"ppm",null,"ppm",1.2,"mg/m3",null,"ppm",{"$f":"V26","v":0.8333333333}]
["PSI",0.06895,"Bar",null,"PSI",1.0,"PSI",null,"PSI",51.715,"mmHg",null,"PSI",0.068046,"Atmos.",null,"PSI",{"$f":"+F28","v":1},null,null,"mg/m3",{"$f":"1/Z24","v":0.8333333333},"ppm",null,"mg/m3",1.0,"mg/m3",null,"mg/m3",{"$f":"Z26","v":1}]
["mmHg",0.001333,"Bar",null,"mmHg",0.019337,"PSI",null,"mmHg",1.0,"mmHg",null,"mmHg",0.001316,"Atmos.",null,"mmHg",{"$f":"+J28","v":51.715},null,null,null,{"$f":"VLOOKUP(CONVERSION!$I$13,'CONVERSION _DATA'!U24:V25,2,FALSE)","v":0.8333333333},null,null,null,{"$f":"VLOOKUP(CONVERSION!$I$13,'CONVERSION _DATA'!Y24:Z25,2,FALSE)","v":1},null,null,null,{"$f":"VLOOKUP(CONVERSION!$L$13,'CONVERSION _DATA'!AC24:AD25,2,FALSE)","v":0.8333333333}]
["Atmos.",1.01325,"Bar",null,"Atmos.",14.6959,"PSI",null,"Atmos.",760.0,"mmHg",null,"Atmos.",1.0,"Atmos.",null,"Atmos.",{"$f":"+N28","v":0.068046}]
[null,{"$f":"VLOOKUP(CONVERSION!$C$13,'CONVERSION _DATA'!A24:B27,2,FALSE)","v":0.06895},null,null,null,{"$f":"VLOOKUP(CONVERSION!$C$13,'CONVERSION _DATA'!E24:F27,2,FALSE)","v":1},null,null,null,{"$f":"VLOOKUP(CONVERSION!$C$13,'CONVERSION _DATA'!I24:J27,2,FALSE)","v":51.715},null,null,null,{"$f":"VLOOKUP(CONVERSION!$C$13,'CONVERSION _DATA'!M24:N27,2,FALSE)","v":0.068046},null,null,null,{"$f":"VLOOKUP(CONVERSION!$F$13,'CONVERSION _DATA'!Q24:R27,2,FALSE)","v":0.06895}]
[]
["LENGTH"]
["mm",1.0,"mm",null,"mm",0.1,"cm",null,"mm",0.03937,"Inch",null,"mm",0.003281,"Foot",null,"mm",0.001094,"Yard",null,"mm",0.001,"Metre",null,"mm",{"$f":"+B37","v":1000}]
["cm",10.0,"mm",null,"cm",1.0,"cm",null,"cm",0.393701,"Inch",null,"cm",0.032808,"Foot",null,"cm",0.010936,"Yard",null,"cm",0.01,"Metre",null,"cm",{"$f":"+F37","v":100}]
["Inch",25.4,"mm",null,"Inch",2.54,"cm",null,"Inch",1.0,"Inch",null,"Inch",0.08333,"Foot",null,"Inch",0.027778,"Yard",null,"Inch",0.0254,"Metre",null,"Inch",{"$f":"+J37","v":39.3701}]
["Foot",304.8,"mm",null,"Foot",30.48,"cm",null,"Foot",12.0,"Inch",null,"Foot",1.0,"Foot",null,"Foot",0.333333,"Yard",null,"Foot",0.3048,"Metre",null,"Foot",{"$f":"N37","v":3.28084}]
["Yard",914.4,"mm",null,"Yard",91.44,"cm",null,"Yard",36.0,"Inch",null,"Yard",3.0,"Foot",null,"Yard",1.0,"Yard",null,"Yard",0.9144,"Metre",null,"Yard",{"$f":"+R37","v":1.09361}]
["Metre",1000.0,"mm",null,"Metre",100.0,"cm",null,"Metre",39.3701,"Inch",null,"Metre",3.28084,"Foot",null,"Metre",1.09361,"Yard",null,"Metre",1.0,"Metre",null,"Metre",{"$f":"+V37","v":1}]
[null,{"$f":"VLOOKUP(CONVERSION!$C$31,'CONVERSION _DATA'!A31:B36,2,FALSE)","v":1000},null,null,null,{"$f":"VLOOKUP(CONVERSION!$C$31,'CONVERSION _DATA'!E31:F36,2,FALSE)","v":100},null,null,null,{"$f":"VLOOKUP(CONVERSION!$C$31,'CONVERSION _DATA'!I31:J36,2,FALSE)","v":39.3701},null,null,null,{"$f":"VLOOKUP(CONVERSION!$C$31,'CONVERSION _DATA'!M31:N36,2,FALSE)","v":3.28084},null,null,null,{"$f":"VLOOKUP(CONVERSION!$C$31,'CONVERSION _DATA'!Q31:R36,2,FALSE)","v":1.09361},null,null,null,{"$f":"VLOOKUP(CONVERSION!$C$31,'CONVERSION _DATA'!U31:V36,2,FALSE)","v":1},null,null,null,{"$f":"VLOOKUP(CONVERSION!$F$31,'CONVERSION _DATA'!Y31:Z36,2,FALSE)","v":1.09361}]
[]
["ENERGY"]
["kW/h",1.0,"kW/h",null,"kW/h",1.3412,"HP/h",null,"kW/h",{"$f":"1/B42","v":3600.774887},"Joule",null,"kW/h",860.563,"Calorie",null,"kW/h",3412.8,"Btu",null,"kW/h",{"$f":"B45","v":1}]
["HP/h",0.7456,"kW/h",null,"HP/h",1.0,"HP/h",null,"HP/h",{"$f":"1/F42","v":2685.558677},"Joule",null,"HP/h",641.617,"Calorie",null,"HP/h",2544.5,"Btu",null,"HP/h",{"$f":"F45","v":1.3412}]
["Joule",{"$f":"N42*B43","v":0.000277718},"kW/h",null,"Joule",{"$f":"+N42*F43","v":0.000372362},"HP/h",null,"Joule",1.0,"Joule",null,"Joule",0.239,"Calorie",null,"Joule",9.48E-4,"Btu",null,"Joule",{"$f":"J45","v":3600.774887}]
["Calorie",0.001162,"kW/h",null,"Calorie",0.001558,"HP/h",null,"Calorie",4.1833,"Joule",null,"Calorie",1.0,"Calorie",null,"Calorie",0.003966,"Btu",null,"Calorie",{"$f":"N45","v":860.563}]
["Btu",2.93E-4,"kW/h",null,"Btu",3.93E-4,"HP/h",null,"Btu",1054.9,"Joule",null,"Btu",252.16,"Calorie",null,"Btu",1.0,"Btu",null,"Btu",{"$f":"R45","v":3412.8}]
[null,{"$f":"VLOOKUP(CONVERSION!$C$19,'CONVERSION _DATA'!A40:B44,2,FALSE)","v":1},null,null,null,{"$f":"VLOOKUP(CONVERSION!$C$19,'CONVERSION _DATA'!E40:F44,2,FALSE)","v":1.3412},null,null,null,{"$f":"VLOOKUP(CONVERSION!$C$19,'CONVERSION _DATA'!I40:J44,2,FALSE)","v":3600.774887},null,null,null,{"$f":"VLOOKUP(CONVERSION!$C$19,'CONVERSION _DATA'!M40:N44,2,FALSE)","v":860.563},null,null,null,{"$f":"VLOOKUP(CONVERSION!$C$19,'CONVERSION _DATA'!Q40:R44,2,FALSE)","v":3412.8},null,null,null,{"$f":"VLOOKUP(CONVERSION!$F$19,'CONVERSION _DATA'!U40:V44,2,FALSE)","v":3600.774887}]
[]
["POWER"]
["HP",1.0,"HP",null,"HP",745.7,"Watt",null,"HP",0.7475,"kW",null,"HP",42.41,"Btu/min",null,"HP",{"$f":"1/B52","v":745.6066946},"J/sec",null,"HP",178.2,"Cal/sec",null,"HP",{"$f":"+B54","v":1}]
["Watt",{"$f":"1/F48","v":0.001341021859},"HP",null,"Watt",1.0,"Watt",null,"Watt",0.001,"kW",null,"Watt",0.0569,"Btu/min",null,"Watt",{"$f":"1/F52","v":1},"J/sec",null,"Watt",0.239,"Cal/sec",null,"Watt",{"$f":"+F54","v":745.7}]
["kW",1.341,"HP",null,"kW",1000.0,"Watt",null,"kW",1.0,"kW",null,"kW",56.88,"Btu/min",null,"kW",{"$f":"1/J52","v":1000},"J/sec",null,"kW",239.0,"Cal/sec",null,"kW",{"$f":"+J54","v":0.7475}]
["Btu/min",{"$f":"1/N48","v":0.02357934449},"HP",null,"Btu/min",{"$f":"1/N49","v":17.57469244},"Watt",null,"Btu/min",{"$f":"1/N50","v":0.01758087201},"kW",null,"Btu/min",1.0,"Btu/min",null,"Btu/min",{"$f":"1/N52","v":17.58577406},"J/sec",null,"Btu/min",4.203,"Cal/sec",null,"Btu/min",{"$f":"+N54","v":42.41}]
["J/sec",{"$f":"+V52*B53","v":0.001341189675},"HP",null,"J/sec",{"$f":"+V52*F53","v":1},"Watt",null,"J/sec",{"$f":"+V52*J53","v":0.001},"kW",null,"J/sec",{"$f":"+V52*N53","v":0.05686414466},"Btu/min",null,"J/sec",1.0,"J/sec",null,"J/sec",0.239,"Cal/sec",null,"J/sec",{"$f":"+R54","v":745.6066946}]
["Cal/sec",{"$f":"1/V48","v":0.005611672278},"HP",null,"Cal/sec",{"$f":"1/V49","v":4.184100418},"Watt",null,"Cal/sec",{"$f":"1/V50","v":0.004184100418},"kW",null,"Cal/sec",{"$f":"1/V51","v":0.2379252915},"Btu/min",null,"Cal/sec",{"$f":"1/V52","v":4.184100418},"J/sec",null,"Cal/sec",1.0,"Cal/sec",null,"Cal/sec",{"$f":"+V54","v":178.2}]
[null,{"$f":"VLOOKUP(CONVERSION!$F$25,'CONVERSION _DATA'!A48:B53,2,FALSE)","v":1},null,null,null,{"$f":"VLOOKUP(CONVERSION!$F$25,'CONVERSION _DATA'!E48:F53,2,FALSE)","v":745.7},null,null,null,{"$f":"VLOOKUP(CONVERSION!$F$25,'CONVERSION _DATA'!I48:J53,2,FALSE)","v":0.7475},null,null,null,{"$f":"VLOOKUP(CONVERSION!$F$25,'CONVERSION _DATA'!M48:N53,2,FALSE)","v":42.41},null,null,null,{"$f":"VLOOKUP(CONVERSION!$F$25,'CONVERSION _DATA'!Q48:R53,2,FALSE)","v":745.6066946},null,null,null,{"$f":"VLOOKUP(CONVERSION!$F$25,'CONVERSION _DATA'!U48:V53,2,FALSE)","v":178.2},null,null,null,{"$f":"VLOOKUP(CONVERSION!$C$25,'CONVERSION _DATA'!Y48:Z53,2,FALSE)","v":745.7}]
["AREA","Source = http://www.processassociates.com/process/convert/cf_are.htm"]
["Metre^2",1.0,"Metre^2",null,"Metre^2",10.763910417,"Foot^2",null,"Metre^2",1550.003100006,"Inch^2"]
["cm^2",1.0E-4,"Metre^2",null,"cm^2",0.00107639104,"Foot^2",null,"cm^2",0.15500031,"Inch^2"]
["mm^2",1.0E-6,"Metre^2",null,"mm^2",1.07639104E-5,"Foot^2",null,"mm^2",0.0015500031,"Inch^2"]
["Yard^2",0.83612736,"Metre^2",null,"Yard^2",9.0,"Foot^2",null,"Yard^2",1296.0,"Inch^2"]
["Foot^2",0.09290304,"Metre^2",null,"Foot^2",1.0,"Foot^2",null,"Foot^2",144.0,"Inch^2"]
["Inch^2",6.4516E-4,"Metre^2",null,"Inch^2",0.00694444444,"Foot^2",null,"Inch^2",1.0,"Inch^2"]