{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Data Entry","Correlations","KeyCorrelations","Regression Analysis","Results","Inputs","Products+Actvitiy"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

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

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

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

{"sheet":"Regression Analysis","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

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

{"sheet":"Inputs","index":5,"n_rows":30,"n_cols":20,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Activity ID (fn)",null,"Activity Name",null,"Units",null,"Production to SFC Correlation (rx)",null,"Linear Regression Coefficient (cn)"]
[{"$f":"Results!A2","v":0},null,{"$f":"CONCATENATE(IFERROR(VLOOKUP(LEFT(A2,FIND(\"_\",A2)-1),'Products+Actvitiy'!$E$1:$F$13,2,FALSE),\"\"),\" \",IFERROR(VLOOKUP(RIGHT(A2,LEN(A2)-FIND(\"_\",A2)),'Products+Actvitiy'!$A$1:$C$47,2,FALSE),\"\"))","v":" "},null,{"$f":"IFERROR(VLOOKUP(RIGHT(A2,LEN(A2)-FIND(\"_\",A2)),'Products+Actvitiy'!$A$1:$C$47,3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(A2,Correlations!$A:$B,2,FALSE),\"\")","v":""},null,{"$f":"Results!B2","v":0}]
[]
[{"$f":"Results!A3","v":0},null,{"$f":"CONCATENATE(IFERROR(VLOOKUP(LEFT(A4,FIND(\"_\",A4)-1),'Products+Actvitiy'!$E$1:$F$13,2,FALSE),\"\"),\" \",IFERROR(VLOOKUP(RIGHT(A4,LEN(A4)-FIND(\"_\",A4)),'Products+Actvitiy'!$A$1:$C$47,2,FALSE),\"\"))","v":" "},null,{"$f":"IFERROR(VLOOKUP(RIGHT(A4,LEN(A4)-FIND(\"_\",A4)),'Products+Actvitiy'!$A$1:$C$47,3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(A4,Correlations!$A:$B,2,FALSE),\"\")","v":""},null,{"$f":"Results!B3","v":0}]
[]
[{"$f":"Results!A4","v":0},null,{"$f":"CONCATENATE(IFERROR(VLOOKUP(LEFT(A6,FIND(\"_\",A6)-1),'Products+Actvitiy'!$E$1:$F$13,2,FALSE),\"\"),\" \",IFERROR(VLOOKUP(RIGHT(A6,LEN(A6)-FIND(\"_\",A6)),'Products+Actvitiy'!$A$1:$C$47,2,FALSE),\"\"))","v":" "},null,{"$f":"IFERROR(VLOOKUP(RIGHT(A6,LEN(A6)-FIND(\"_\",A6)),'Products+Actvitiy'!$A$1:$C$47,3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(A6,Correlations!$A:$B,2,FALSE),\"\")","v":""},null,{"$f":"Results!B4","v":0}]
[]
[{"$f":"Results!A5","v":0},null,{"$f":"CONCATENATE(IFERROR(VLOOKUP(LEFT(A8,FIND(\"_\",A8)-1),'Products+Actvitiy'!$E$1:$F$13,2,FALSE),\"\"),\" \",IFERROR(VLOOKUP(RIGHT(A8,LEN(A8)-FIND(\"_\",A8)),'Products+Actvitiy'!$A$1:$C$47,2,FALSE),\"\"))","v":" "},null,{"$f":"IFERROR(VLOOKUP(RIGHT(A8,LEN(A8)-FIND(\"_\",A8)),'Products+Actvitiy'!$A$1:$C$47,3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(A8,Correlations!$A:$B,2,FALSE),\"\")","v":""},null,{"$f":"Results!B5","v":0}]
[]
[{"$f":"Results!A6","v":0},null,{"$f":"CONCATENATE(IFERROR(VLOOKUP(LEFT(A10,FIND(\"_\",A10)-1),'Products+Actvitiy'!$E$1:$F$13,2,FALSE),\"\"),\" \",IFERROR(VLOOKUP(RIGHT(A10,LEN(A10)-FIND(\"_\",A10)),'Products+Actvitiy'!$A$1:$C$47,2,FALSE),\"\"))","v":" "},null,{"$f":"IFERROR(VLOOKUP(RIGHT(A10,LEN(A10)-FIND(\"_\",A10)),'Products+Actvitiy'!$A$1:$C$47,3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(A10,Correlations!$A:$B,2,FALSE),\"\")","v":""},null,{"$f":"Results!B6","v":0}]
[]
[{"$f":"Results!A7","v":0},null,{"$f":"CONCATENATE(IFERROR(VLOOKUP(LEFT(A12,FIND(\"_\",A12)-1),'Products+Actvitiy'!$E$1:$F$13,2,FALSE),\"\"),\" \",IFERROR(VLOOKUP(RIGHT(A12,LEN(A12)-FIND(\"_\",A12)),'Products+Actvitiy'!$A$1:$C$47,2,FALSE),\"\"))","v":" "},null,{"$f":"IFERROR(VLOOKUP(RIGHT(A12,LEN(A12)-FIND(\"_\",A12)),'Products+Actvitiy'!$A$1:$C$47,3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(A12,Correlations!$A:$B,2,FALSE),\"\")","v":""},null,{"$f":"Results!B7","v":0}]
[]
[{"$f":"Results!A8","v":0},null,{"$f":"CONCATENATE(IFERROR(VLOOKUP(LEFT(A14,FIND(\"_\",A14)-1),'Products+Actvitiy'!$E$1:$F$13,2,FALSE),\"\"),\" \",IFERROR(VLOOKUP(RIGHT(A14,LEN(A14)-FIND(\"_\",A14)),'Products+Actvitiy'!$A$1:$C$47,2,FALSE),\"\"))","v":" "},null,{"$f":"IFERROR(VLOOKUP(RIGHT(A14,LEN(A14)-FIND(\"_\",A14)),'Products+Actvitiy'!$A$1:$C$47,3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(A14,Correlations!$A:$B,2,FALSE),\"\")","v":""},null,{"$f":"Results!B8","v":0}]
[]
[{"$f":"Results!A9","v":0},null,{"$f":"CONCATENATE(IFERROR(VLOOKUP(LEFT(A16,FIND(\"_\",A16)-1),'Products+Actvitiy'!$E$1:$F$13,2,FALSE),\"\"),\" \",IFERROR(VLOOKUP(RIGHT(A16,LEN(A16)-FIND(\"_\",A16)),'Products+Actvitiy'!$A$1:$C$47,2,FALSE),\"\"))","v":" "},null,{"$f":"IFERROR(VLOOKUP(RIGHT(A16,LEN(A16)-FIND(\"_\",A16)),'Products+Actvitiy'!$A$1:$C$47,3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(A16,Correlations!$A:$B,2,FALSE),\"\")","v":""},null,{"$f":"Results!B9","v":0}]
[]
[{"$f":"Results!A10","v":0},null,{"$f":"CONCATENATE(IFERROR(VLOOKUP(LEFT(A18,FIND(\"_\",A18)-1),'Products+Actvitiy'!$E$1:$F$13,2,FALSE),\"\"),\" \",IFERROR(VLOOKUP(RIGHT(A18,LEN(A18)-FIND(\"_\",A18)),'Products+Actvitiy'!$A$1:$C$47,2,FALSE),\"\"))","v":" "},null,{"$f":"IFERROR(VLOOKUP(RIGHT(A18,LEN(A18)-FIND(\"_\",A18)),'Products+Actvitiy'!$A$1:$C$47,3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(A18,Correlations!$A:$B,2,FALSE),\"\")","v":""},null,{"$f":"Results!B10","v":0}]
[]
[{"$f":"Results!A11","v":0},null,{"$f":"CONCATENATE(IFERROR(VLOOKUP(LEFT(A20,FIND(\"_\",A20)-1),'Products+Actvitiy'!$E$1:$F$13,2,FALSE),\"\"),\" \",IFERROR(VLOOKUP(RIGHT(A20,LEN(A20)-FIND(\"_\",A20)),'Products+Actvitiy'!$A$1:$C$47,2,FALSE),\"\"))","v":" "},null,{"$f":"IFERROR(VLOOKUP(RIGHT(A20,LEN(A20)-FIND(\"_\",A20)),'Products+Actvitiy'!$A$1:$C$47,3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(A20,Correlations!$A:$B,2,FALSE),\"\")","v":""},null,{"$f":"Results!B11","v":0}]
[]
[{"$f":"Results!A12","v":0},null,{"$f":"CONCATENATE(IFERROR(VLOOKUP(LEFT(A22,FIND(\"_\",A22)-1),'Products+Actvitiy'!$E$1:$F$13,2,FALSE),\"\"),\" \",IFERROR(VLOOKUP(RIGHT(A22,LEN(A22)-FIND(\"_\",A22)),'Products+Actvitiy'!$A$1:$C$47,2,FALSE),\"\"))","v":" "},null,{"$f":"IFERROR(VLOOKUP(RIGHT(A22,LEN(A22)-FIND(\"_\",A22)),'Products+Actvitiy'!$A$1:$C$47,3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(A22,Correlations!$A:$B,2,FALSE),\"\")","v":""},null,{"$f":"Results!B12","v":0}]
[]
[{"$f":"Results!A13","v":0},null,{"$f":"CONCATENATE(IFERROR(VLOOKUP(LEFT(A24,FIND(\"_\",A24)-1),'Products+Actvitiy'!$E$1:$F$13,2,FALSE),\"\"),\" \",IFERROR(VLOOKUP(RIGHT(A24,LEN(A24)-FIND(\"_\",A24)),'Products+Actvitiy'!$A$1:$C$47,2,FALSE),\"\"))","v":" "},null,{"$f":"IFERROR(VLOOKUP(RIGHT(A24,LEN(A24)-FIND(\"_\",A24)),'Products+Actvitiy'!$A$1:$C$47,3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(A24,Correlations!$A:$B,2,FALSE),\"\")","v":""},null,{"$f":"Results!B13","v":0},null,null,null,null,null,null,null,null,null,null,false]
[]
[{"$f":"Results!A14","v":0},null,{"$f":"CONCATENATE(IFERROR(VLOOKUP(LEFT(A26,FIND(\"_\",A26)-1),'Products+Actvitiy'!$E$1:$F$13,2,FALSE),\"\"),\" \",IFERROR(VLOOKUP(RIGHT(A26,LEN(A26)-FIND(\"_\",A26)),'Products+Actvitiy'!$A$1:$C$47,2,FALSE),\"\"))","v":" "},null,{"$f":"IFERROR(VLOOKUP(RIGHT(A26,LEN(A26)-FIND(\"_\",A26)),'Products+Actvitiy'!$A$1:$C$47,3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(A26,Correlations!$A:$B,2,FALSE),\"\")","v":""},null,{"$f":"Results!B14","v":0}]
[]
[{"$f":"Results!A15","v":0},null,{"$f":"CONCATENATE(IFERROR(VLOOKUP(LEFT(A28,FIND(\"_\",A28)-1),'Products+Actvitiy'!$E$1:$F$13,2,FALSE),\"\"),\" \",IFERROR(VLOOKUP(RIGHT(A28,LEN(A28)-FIND(\"_\",A28)),'Products+Actvitiy'!$A$1:$C$47,2,FALSE),\"\"))","v":" "},null,{"$f":"IFERROR(VLOOKUP(RIGHT(A28,LEN(A28)-FIND(\"_\",A28)),'Products+Actvitiy'!$A$1:$C$47,3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(A28,Correlations!$A:$B,2,FALSE),\"\")","v":""},null,{"$f":"Results!B15","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]

{"sheet":"Products+Actvitiy","index":6,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
["Product ID","Product Name","Units",null,"Activity Code","Activity Name"]
["OIL","Crude Oil, Crude Bitumen","m3",null,"DISP","Disposition of"]
["COND","Condensate","m3",null,"FRAC","Fractionation yield of "]
["GAS","Gas","e3m3",null,"INJ","Well injection of"]
["WATER","Water","m3",null,"LDINJ","Load fluid injection of"]
["FSHWTR","Fresh Water","m3",null,"PLTUSE","Plant use of"]
["C2-SP","Ethane Spec","m3",null,"PROC","Plant process of"]
["C3-SP","Propane Spec","m3",null,"PROD","Well production of"]
["C4-SP","Butane Spec","m3",null,"PURREC","Purchase reciept of"]
["NC4-SP","Normal Butane Spec","m3",null,"PURDISP","Purchase disposition of"]
["IC4-SP","Iso-Butane Spec","m3",null,"REC","Reciept of"]
["C5-SP","Pentane Spec","m3",null,"RECYC","Recycle of"]
["NC5-SP","Normal Pentane Spec","m3",null,"UTIL","Utility of "]
["IC5-SP","Iso-Pentane Spec","m3"]
["C6-SP","Hexane Spec","m3"]
["C1-MX","Methane Mix","m3"]
["C2-MX","Ethane Mix","m3"]
["C3-MX","Propane Mix","m3"]
["C4-MX","Butane Mix","m3"]
["NC4-MX","Normal Butane Mix","m3"]
["IC4-MX","Iso-Butane Mix","m3"]
["C5-MX","Pentane Mix","m3"]
["NC5-MX","Normal Pentane Mix","m3"]
["IC5-MX","Iso-Pentane Mix","m3"]
["C6-MX","Hexane Mix","m3"]
["LITEMX","Lite Mix","m3"]
["SUL","Sulphur","Tonnes"]
["SPRILL","Sulphur – Prilled","Tonnes"]
["SMOLT","Sulphur – Molten","Tonnes"]
["SBASE","Sulphur – Basepad","Tonnes"]
["SBLOC","Sulphur – Block","Tonnes"]
["SFORM","Sulphur – Formed","Tonnes"]
["SLATE","Sulphur – Slate","Tonnes"]
["SYNCRD","Synthetic – Crude Oil","m3"]
["AIR","Air","e3m3"]
["DIESEL","Diesel Oil","m3"]
["O2","Oxygen","e3m3"]
["CO2","CarbonDioxide"," e3m3"]
["CO2-MX","Carbon Dioxide Mix","m3"]
["N2","Nitrogen","e3m3"]
["ACGAS","Acid Gas","e3m3"]
["SOLV","Solvent","e3m3"]
["ENTGAS","Entrained Gas","e3m3"]
["SAND","Sand","m3"]
["STEAM","Steam","m3"]
["BRKWTR","Brackish Water","m3"]
["WASTE","Waste","m3"]