{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Instructions","JODI_Oil","MOS_Table_1","MOS_Table_2","MOS_Table_5","Definitions - short","Product Definitions Long","Flows Definitions Long","Param","Formulas"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":112,"comments":5,"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":"Instructions","index":0,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Joint Organisations Data Initiative"]
[null,"JODI OIL QUESTIONNAIRE"]
[]
[null,"INSTRUCTIONS"]
[]
[]
[null,"Deadline for submission : 25th of each month ",null,null,null,null,null,null,null,"version 2021.1"]
[]
[null,"The excel form includes one worksheet for JODI Oil and three worksheets for MOS tables"]
[null,"1. Please do not change the format of the excel forms"]
[null,"2. Please make sure that you indicate the correct data month in the cell for Month"]
[null,"3. Do not enter decimal numbers, but only include rounded numbers"]
[]
[null,"Please either fill out worksheet JODI_Oil, or MOS Tables 1, 2 and 5 in this file."]
[null,"If you choose to use the MOS Tables 1, 2 and 5 format, check this box:"]
[null,"and fill out the three worksheets \"MOS_Tables\"."]
[]
[null,"When completed, please export the CSV file and upload it to E-VO",null,null,null,null,null,null,null,"https://evo.iea.org"]
[null,"If you have other questions or wish more information, please contact"]
[null,"Stève Gervais at Tel : 33 1 4057 6525 or the MOS Team at Tel : 33 1 4057 6795 (mos@iea.org)"]

{"sheet":"JODI_Oil","index":1,"n_rows":130,"n_cols":74,"rows_kept":130,"cut":false,"hidden":false,"merged":[[6,3,6,4],[4,3,4,5]]}
[2010.3]
[null,null,"Joint Organisations Data Initiative - Oil"]
[null,null,"Monthly Questionnaire"]
[]
[null,null,"Country ","(select country)"]
[]
[null,null,"Month","January",null,2021,null,{"$f":"IF(DataFromMOS=TRUE,\"Data is calculated from MOS tables\",\"Data is filled out in Maxi-JODI format\")","v":"Data is calculated from MOS tables"},null,null,null,null,null,null,null,null,null,{"$f":"IF(CountryUser=\"United States (Barrels)\",\"Unit: Thousand barrels\",\"Unit: Thousand metric tons\")","v":"Unit: Thousand metric tons"}]
[]
[null,null,null,null,null,null,null,null,null,"Petroleum Products",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Petroleum Products",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Petroleum Products"]
[null,null,null,"Crude oil","NGL","Other","Total\n(1)+(2)+(3)",null,null,"LPG","Naphtha","Gasoline","Total kerosene","Of which: Jet\nkerosene","Gas/ diesel oil","Fuel oil","Other\nproducts","Total products (5)+(6) +(7) +(8) +(10) +(11) +(12)",null,"Checks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crude Oil","NGL","Other","Total\n(1)+(2)+(3)",null,null,"LPG","Naphtha","Gasoline","Total Kerosene","Of which: Jet\nKerosene","Gas/ Diesel Oil","Fuel Oil","Other\nProducts","Total Products (5)+(6) +(7) +(8) +(10) +(11) +(12)",null,null,null,null,"Crude Oil","NGL","Other","Total\n(1)+(2)+(3)",null,null,"LPG","Naphtha","Gasoline","Total Kerosene","Of which: Jet\nKerosene","Gas/ Diesel Oil","Fuel Oil","Other\nProducts","Total Products (5)+(6) +(7) +(8) +(10) +(11) +(12)"]
[null,null,null,"(1)","(2)","(3)","(4)",null,null,"(5)","(6)","(7)","(8)","(9)","(10)","(11)","(12)","(13)",null,"(14)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(1)","(2)","(3)","(4)",null,null,"(5)","(6)","(7)","(8)","(9)","(10)","(11)","(12)","(13)",null,null,null,null,"(1)","(2)","(3)","(4)",null,null,"(5)","(6)","(7)","(8)","(9)","(10)","(11)","(12)","(13)"]
[null,"+","Production",{"$f":"ROUND(MOS_Table_1!$D$14,0)","v":0},{"$f":"ROUND(MOS_Table_1!$E$14,0)","v":0},{"$f":"ROUND(MOS_Table_1!$G$14+MOS_Table_1!$I$14,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$14,0)","v":0},"+","Refinery output",{"$f":"ROUND(MOS_Table_2!$H$9,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$9,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$9+MOS_Table_2!$M$9+MOS_Table_2!$N$9,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$9+MOS_Table_2!$R$9,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$9,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$9,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$9,0)","v":0},{"$f":"ROUND(MOS_Table_2!$F$9+MOS_Table_2!$G$9+MOS_Table_2!$AA$9+MOS_Table_2!$AB$9,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$9,0)","v":0},null,{"$f":"IF(R12<>J12+K12+L12+M12+O12+P12+Q12,\"Total is not sum of the elements\",\"\")","v":""},null,null,"INDPROD","REFGROUT",null,null,null,null,null,null,null,null,null,null,"INDPROD/REFGROUT",null,null,null,"+","Production",{"$f":"ROUND(MOS_Table_1!$D$14,0)","v":0},{"$f":"ROUND(MOS_Table_1!$E$14,0)","v":0},{"$f":"ROUND(MOS_Table_1!$G$14+MOS_Table_1!$I$14,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$14,0)","v":0},"+","Refinery Output",{"$f":"ROUND(MOS_Table_2!$H$9,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$9,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$9+MOS_Table_2!$M$9+MOS_Table_2!$N$9,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$9+MOS_Table_2!$R$9,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$9,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$9,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$9,0)","v":0},{"$f":"ROUND(MOS_Table_2!$F$9+MOS_Table_2!$G$9+MOS_Table_2!$AA$9+MOS_Table_2!$AB$9,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$9,0)","v":0},null,null,"+","Production",{"$f":"IF(DataFromMOS=FALSE,0,IF(D12<>AO12,1,0))","v":0},{"$f":"IF(DataFromMOS=FALSE,0,IF(E12<>AP12,1,0))","v":0},{"$f":"IF(DataFromMOS=FALSE,0,IF(F12<>AQ12,1,0))","v":0},{"$f":"IF(DataFromMOS=FALSE,0,IF(G12<>AR12,1,0))","v":0},"+","Refinery Output",{"$f":"IF(DataFromMOS=FALSE,0,IF(J12<>AU12,1,0))","v":0},{"$f":"IF(DataFromMOS=FALSE,0,IF(K12<>AV12,1,0))","v":0},{"$f":"IF(DataFromMOS=FALSE,0,IF(L12<>AW12,1,0))","v":0},{"$f":"IF(DataFromMOS=FALSE,0,IF(M12<>AX12,1,0))","v":0},{"$f":"IF(DataFromMOS=FALSE,0,IF(N12<>AY12,1,0))","v":0},{"$f":"IF(DataFromMOS=FALSE,0,IF(O12<>AZ12,1,0))","v":0},{"$f":"IF(DataFromMOS=FALSE,0,IF(P12<>BA12,1,0))","v":0},{"$f":"IF(DataFromMOS=FALSE,0,IF(Q12<>BB12,1,0))","v":0},{"$f":"IF(DataFromMOS=FALSE,0,IF(R12<>BC12,1,0))","v":0}]
[null,"+","From other sources",null,null,{"$f":"ROUND(MOS_Table_1!$G$15+MOS_Table_1!$I$15,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$15,0)","v":0},"+","Receipts",{"$f":"ROUND(MOS_Table_2!$H$8+MOS_Table_2!$H$10,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$8+MOS_Table_2!$I$10,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$8+MOS_Table_2!$J$10+MOS_Table_2!$M$8+MOS_Table_2!$M$10+MOS_Table_2!$N$8+MOS_Table_2!$N$10,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$8+MOS_Table_2!$O$10+MOS_Table_2!$R$8+MOS_Table_2!$R$10,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$8+MOS_Table_2!$O$10,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$8+MOS_Table_2!$U$10,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$8+MOS_Table_2!$X$10,0)","v":0},{"$f":"ROUND(MOS_Table_2!$D$8+MOS_Table_2!$E$8+MOS_Table_2!$F$8+MOS_Table_2!$G$8+MOS_Table_2!$AA$8+MOS_Table_2!$AB$8+MOS_Table_2!$F$10+MOS_Table_2!$G$10+MOS_Table_2!$AA$10+MOS_Table_2!$AB$10,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$8+MOS_Table_2!$AC$10,0)","v":0},null,{"$f":"IF(R13<>J13+K13+L13+M13+O13+P13+Q13,\"Total is not sum of the elements\",\"\")","v":""},null,null,"OSOURCES","RECEIPTS",null,null,null,null,null,null,null,null,null,null,"OSOURCES/RECEIPTS",null,null,null,"+","From Other sources",null,null,{"$f":"ROUND(MOS_Table_1!$G$15+MOS_Table_1!$I$15,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$15,0)","v":0},"+","Receipts",{"$f":"ROUND(MOS_Table_2!$H$8+MOS_Table_2!$H$10,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$8+MOS_Table_2!$I$10,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$8+MOS_Table_2!$J$10+MOS_Table_2!$M$8+MOS_Table_2!$M$10+MOS_Table_2!$N$8+MOS_Table_2!$N$10,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$8+MOS_Table_2!$O$10+MOS_Table_2!$R$8+MOS_Table_2!$R$10,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$8+MOS_Table_2!$O$10,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$8+MOS_Table_2!$U$10,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$8+MOS_Table_2!$X$10,0)","v":0},{"$f":"ROUND(MOS_Table_2!$D$8+MOS_Table_2!$E$8+MOS_Table_2!$F$8+MOS_Table_2!$G$8+MOS_Table_2!$AA$8+MOS_Table_2!$AB$8+MOS_Table_2!$F$10+MOS_Table_2!$G$10+MOS_Table_2!$AA$10+MOS_Table_2!$AB$10,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$8+MOS_Table_2!$AC$10,0)","v":0},null,null,"+","From Other sources",0,0,0,0,"+","Receipts",0,0,0,0,0,0,0,0,0]
[null,"+","Imports",{"$f":"ROUND(MOS_Table_1!$D$18,0)","v":0},{"$f":"ROUND(MOS_Table_1!$E$18,0)","v":0},{"$f":"ROUND(MOS_Table_1!$F$18+MOS_Table_1!$G$18+MOS_Table_1!$I$18,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$18,0)","v":0},"+","Imports",{"$f":"ROUND(MOS_Table_2!$H$12,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$12,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$12+MOS_Table_2!$M$12+MOS_Table_2!$N$12,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$12+MOS_Table_2!$R$12,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$12,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$12,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$12,0)","v":0},{"$f":"ROUND(MOS_Table_2!$G$12+MOS_Table_2!$AA$12+MOS_Table_2!$AB$12,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$12,0)","v":0},null,{"$f":"IF(R14<>J14+K14+L14+M14+O14+P14+Q14,\"Total is not sum of the elements\",\"\")","v":""},null,null,"TOTIMPSB","TOTIMPSB",null,null,null,null,null,null,null,null,null,null,"TOTIMPSB/TOTIMPSB",null,null,null,"+","Imports",{"$f":"ROUND(MOS_Table_1!$D$18,0)","v":0},{"$f":"ROUND(MOS_Table_1!$E$18,0)","v":0},{"$f":"ROUND(MOS_Table_1!$F$18+MOS_Table_1!$G$18+MOS_Table_1!$I$18,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$18,0)","v":0},"+","Imports",{"$f":"ROUND(MOS_Table_2!$H$12,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$12,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$12+MOS_Table_2!$M$12+MOS_Table_2!$N$12,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$12+MOS_Table_2!$R$12,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$12,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$12,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$12,0)","v":0},{"$f":"ROUND(MOS_Table_2!$G$12+MOS_Table_2!$AA$12+MOS_Table_2!$AB$12,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$12,0)","v":0},null,null,"+","Imports",0,0,0,0,"+","Imports",0,0,0,0,0,0,0,0,0]
[null,"-","Exports",{"$f":"ROUND(MOS_Table_1!$D$19,0)","v":0},{"$f":"ROUND(MOS_Table_1!$E$19,0)","v":0},{"$f":"ROUND(MOS_Table_1!$F$19+MOS_Table_1!$G$19+MOS_Table_1!$I$19,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$19,0)","v":0},"-","Exports",{"$f":"ROUND(MOS_Table_2!$H$13,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$13,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$13+MOS_Table_2!$M$13+MOS_Table_2!$N$13,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$13+MOS_Table_2!$R$13,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$13,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$13,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$13,0)","v":0},{"$f":"ROUND(MOS_Table_2!$G$13+MOS_Table_2!$AA$13+MOS_Table_2!$AB$13,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$13,0)","v":0},null,{"$f":"IF(R15<>J15+K15+L15+M15+O15+P15+Q15,\"Total is not sum of the elements\",\"\")","v":""},null,null,"TOTEXPSB","TOTEXPSB",null,null,null,null,null,null,null,null,null,null,"TOTEXPSB/TOTEXPSB",null,null,null,"-","Exports",{"$f":"ROUND(MOS_Table_1!$D$19,0)","v":0},{"$f":"ROUND(MOS_Table_1!$E$19,0)","v":0},{"$f":"ROUND(MOS_Table_1!$F$19+MOS_Table_1!$G$19+MOS_Table_1!$I$19,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$19,0)","v":0},"-","Exports",{"$f":"ROUND(MOS_Table_2!$H$13,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$13,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$13+MOS_Table_2!$M$13+MOS_Table_2!$N$13,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$13+MOS_Table_2!$R$13,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$13,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$13,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$13,0)","v":0},{"$f":"ROUND(MOS_Table_2!$G$13+MOS_Table_2!$AA$13+MOS_Table_2!$AB$13,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$13,0)","v":0},null,null,"-","Exports",0,0,0,0,"-","Exports",0,0,{"$f":"IF(DataFromMOS=FALSE,0,IF(L15<>AW15,1,0))","v":0},0,0,0,0,0,0]
[null,"+","Products transferred /Backflows",null,null,{"$f":"ROUND(MOS_Table_1!$F$17+MOS_Table_1!$F$16,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$16+MOS_Table_1!$J$17,0)","v":0},"-","Products transferred",{"$f":"ROUND(MOS_Table_2!$H$16,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$16,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$16+MOS_Table_2!$M$16+MOS_Table_2!$N$16,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$16+MOS_Table_2!$R$16,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$16,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$16,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$16,0)","v":0},{"$f":"ROUND(MOS_Table_2!$F$16+MOS_Table_2!$G$16+MOS_Table_2!$AA$16+MOS_Table_2!$AB$16,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$16,0)","v":0},null,{"$f":"IF(R16<>J16+K16+L16+M16+O16+P16+Q16,\"Total is not sum of the elements\",\"\")","v":""},null,null,"TRANSBAK","PTRANSF",null,null,null,null,null,null,null,null,null,null,"TRANSBAK/PTRANSF",null,null,null,"+","Products Transferred /Backflows",null,null,{"$f":"ROUND(MOS_Table_1!$F$17+MOS_Table_1!$F$16,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$16+MOS_Table_1!$J$17,0)","v":0},"-","Products Transferred",{"$f":"ROUND(MOS_Table_2!$H$16,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$16,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$16+MOS_Table_2!$M$16+MOS_Table_2!$N$16,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$16+MOS_Table_2!$R$16,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$16,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$16,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$16,0)","v":0},{"$f":"ROUND(MOS_Table_2!$F$16+MOS_Table_2!$G$16+MOS_Table_2!$AA$16+MOS_Table_2!$AB$16,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$16,0)","v":0},null,null,"+","Products Transferred /Backflows",0,0,0,0,"-","Products Transferred",0,0,0,0,0,0,0,0,0]
[null,"-","Direct use",{"$f":"ROUND(MOS_Table_1!$D$20,0)","v":0},{"$f":"ROUND(MOS_Table_1!$E$20,0)","v":0},{"$f":"ROUND(MOS_Table_1!$F$20+MOS_Table_1!$G$20+MOS_Table_1!$I$20,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$20,0)","v":0},"+","Interproduct transfers",{"$f":"ROUND(MOS_Table_2!$H$15,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$15,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$15+MOS_Table_2!$M$15+MOS_Table_2!$N$15,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$15+MOS_Table_2!$R$15,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$15,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$15,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$15,0)","v":0},{"$f":"ROUND(MOS_Table_2!$D$15+MOS_Table_2!$E$15+MOS_Table_2!$F$15+MOS_Table_2!$G$15+MOS_Table_2!$AA$15+MOS_Table_2!$AB$15,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$15,0)","v":0},null,{"$f":"IF(R17<>0,\"Total should be zero\",IF(R17<>J17+K17+L17+M17+O17+P17+Q17,\"Total is not sum of the elements\",\"\"))","v":""},null,null,"DIRECUSE","IPTRANSF",null,null,null,null,null,null,null,null,null,null,"DIRECUSE/IPTRANSF",null,null,null,"-","Direct Use",{"$f":"ROUND(MOS_Table_1!$D$20,0)","v":0},{"$f":"ROUND(MOS_Table_1!$E$20,0)","v":0},{"$f":"ROUND(MOS_Table_1!$F$20+MOS_Table_1!$G$20+MOS_Table_1!$I$20,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$20,0)","v":0},"+","Interproduct Transfers",{"$f":"ROUND(MOS_Table_2!$H$15,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$15,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$15+MOS_Table_2!$M$15+MOS_Table_2!$N$15,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$15+MOS_Table_2!$R$15,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$15,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$15,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$15,0)","v":0},{"$f":"ROUND(MOS_Table_2!$D$15+MOS_Table_2!$E$15+MOS_Table_2!$F$15+MOS_Table_2!$G$15+MOS_Table_2!$AA$15+MOS_Table_2!$AB$15,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$15,0)","v":0},null,null,"-","Direct Use",0,0,0,0,"+","Interproduct Transfers",0,0,0,0,0,0,0,0,0]
[null,"-","Stock change",{"$f":"ROUND(MOS_Table_1!$D$21,0)","v":0},{"$f":"ROUND(MOS_Table_1!$E$21,0)","v":0},{"$f":"ROUND(MOS_Table_1!$F$21+MOS_Table_1!$G$21+MOS_Table_1!$I$21,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$21,0)","v":0},"-","Stock change",{"$f":"ROUND(MOS_Table_2!$H$17,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$17,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$17+MOS_Table_2!$M$17+MOS_Table_2!$N$17,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$17+MOS_Table_2!$R$17,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$17,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$17,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$17,0)","v":0},{"$f":"ROUND(MOS_Table_2!$F$17+MOS_Table_2!$G$17+MOS_Table_2!$AA$17+MOS_Table_2!$AB$17,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$17,0)","v":0},null,{"$f":"IF(R18<>J18+K18+L18+M18+O18+P18+Q18,\"Total is not sum of the elements\",\"\")","v":""},null,null,"STCHANAT","STCHANAT",null,null,null,null,null,null,null,null,null,null,"STCHANAT/STCHANAT",null,null,null,"-","Stock Change",{"$f":"ROUND(MOS_Table_1!$D$21,0)","v":0},{"$f":"ROUND(MOS_Table_1!$E$21,0)","v":0},{"$f":"ROUND(MOS_Table_1!$F$21+MOS_Table_1!$G$21+MOS_Table_1!$I$21,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$21,0)","v":0},"-","Stock Change",{"$f":"ROUND(MOS_Table_2!$H$17,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$17,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$17+MOS_Table_2!$M$17+MOS_Table_2!$N$17,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$17+MOS_Table_2!$R$17,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$17,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$17,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$17,0)","v":0},{"$f":"ROUND(MOS_Table_2!$F$17+MOS_Table_2!$G$17+MOS_Table_2!$AA$17+MOS_Table_2!$AB$17,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$17,0)","v":0},null,null,"-","Stock Change",0,0,0,0,"-","Stock Change",0,0,0,0,0,0,0,0,0]
[null,"-","Statistical difference",{"$f":"ROUND(MOS_Table_1!$D$23,0)","v":0},{"$f":"ROUND(MOS_Table_1!$E$23,0)","v":0},{"$f":"ROUND(MOS_Table_1!$F$23+MOS_Table_1!$G$23+MOS_Table_1!$I$23,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$23,0)","v":0},"-","Statistical difference",{"$f":"ROUND(MOS_Table_2!$H$19,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$19,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$19+MOS_Table_2!$M$19+MOS_Table_2!$N$19,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$19+MOS_Table_2!$R$19,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$19,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$19,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$19,0)","v":0},{"$f":"ROUND(MOS_Table_2!$D$19+MOS_Table_2!$E$19+MOS_Table_2!$F$19+MOS_Table_2!$G$19+MOS_Table_2!$AA$19+MOS_Table_2!$AB$19,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$19,0)","v":0},null,{"$f":"IF(R19<>J19+K19+L19+M19+O19+P19+Q19,\"Total is not sum of the elements\",\"\")","v":""},null,null,"STATDIFF","STATDIFF",null,null,null,null,null,null,null,null,null,null,"STATDIFF/STATDIFF",null,null,null,"-","Statistical Difference",{"$f":"ROUND(MOS_Table_1!$D$23,0)","v":0},{"$f":"ROUND(MOS_Table_1!$E$23,0)","v":0},{"$f":"ROUND(MOS_Table_1!$F$23+MOS_Table_1!$G$23+MOS_Table_1!$I$23,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$23,0)","v":0},"-","Statistical Difference",{"$f":"ROUND(MOS_Table_2!$H$19,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$19,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$19+MOS_Table_2!$M$19+MOS_Table_2!$N$19,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$19+MOS_Table_2!$R$19,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$19,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$19,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$19,0)","v":0},{"$f":"ROUND(MOS_Table_2!$D$19+MOS_Table_2!$E$19+MOS_Table_2!$F$19+MOS_Table_2!$G$19+MOS_Table_2!$AA$19+MOS_Table_2!$AB$19,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$19,0)","v":0},null,null,"-","Statistical Difference",0,0,0,0,"-","Statistical Difference",0,0,0,0,0,0,0,0,0]
[null,"=","Refinery intake",{"$f":"ROUND(MOS_Table_1!$D$24,0)","v":0},{"$f":"ROUND(MOS_Table_1!$E$24,0)","v":0},{"$f":"ROUND(MOS_Table_1!$F$24+MOS_Table_1!$G$24+MOS_Table_1!$I$24,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$24,0)","v":0},"="," Demand",{"$f":"ROUND(MOS_Table_2!$H$11+MOS_Table_2!$H$14+MOS_Table_2!$H$20,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$11+MOS_Table_2!$I$14+MOS_Table_2!$I$20,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$11+MOS_Table_2!$J$14+MOS_Table_2!$J$20+MOS_Table_2!$M$11+MOS_Table_2!$M$14+MOS_Table_2!$M$20+MOS_Table_2!$N$11+MOS_Table_2!$N$14+MOS_Table_2!$N$20,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$11+MOS_Table_2!$O$14+MOS_Table_2!$O$20+MOS_Table_2!$R$11+MOS_Table_2!$R$14+MOS_Table_2!$R$20,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$11+MOS_Table_2!$O$14+MOS_Table_2!$O$20,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$11+MOS_Table_2!$U$14+MOS_Table_2!$U$20,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$11+MOS_Table_2!$X$14+MOS_Table_2!$X$20,0)","v":0},{"$f":"ROUND(MOS_Table_2!$D$20+MOS_Table_2!$E$20+MOS_Table_2!$F$11+MOS_Table_2!$F$14+MOS_Table_2!$F$20+MOS_Table_2!$G$11+MOS_Table_2!$G$14+MOS_Table_2!$G$20+MOS_Table_2!$AA$11+MOS_Table_2!$AA$14+MOS_Table_2!$AA$20+MOS_Table_2!$AB$11+MOS_Table_2!$AB$14+MOS_Table_2!$AB$20,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$11+MOS_Table_2!$AC$14+MOS_Table_2!$AC$20,0)","v":0},null,{"$f":"IF(R20<>J20+K20+L20+M20+O20+P20+Q20,\"Total is not sum of the elements\",\"\")","v":""},null,null,"REFINOBS","DEMAND",null,null,null,null,null,null,null,null,null,null,"REFINOBS/DEMAND",null,null,null,"=","Refinery Intake",{"$f":"ROUND(MOS_Table_1!$D$24,0)","v":0},{"$f":"ROUND(MOS_Table_1!$E$24,0)","v":0},{"$f":"ROUND(MOS_Table_1!$F$24+MOS_Table_1!$G$24+MOS_Table_1!$I$24,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$24,0)","v":0},"="," Demand",{"$f":"ROUND(MOS_Table_2!$H$11+MOS_Table_2!$H$14+MOS_Table_2!$H$20,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$11+MOS_Table_2!$I$14+MOS_Table_2!$I$20,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$11+MOS_Table_2!$J$14+MOS_Table_2!$J$20+MOS_Table_2!$M$11+MOS_Table_2!$M$14+MOS_Table_2!$M$20+MOS_Table_2!$N$11+MOS_Table_2!$N$14+MOS_Table_2!$N$20,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$11+MOS_Table_2!$O$14+MOS_Table_2!$O$20+MOS_Table_2!$R$11+MOS_Table_2!$R$14+MOS_Table_2!$R$20,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$11+MOS_Table_2!$O$14+MOS_Table_2!$O$20,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$11+MOS_Table_2!$U$14+MOS_Table_2!$U$20,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$11+MOS_Table_2!$X$14+MOS_Table_2!$X$20,0)","v":0},{"$f":"ROUND(MOS_Table_2!$D$20+MOS_Table_2!$E$20+MOS_Table_2!$F$11+MOS_Table_2!$F$14+MOS_Table_2!$F$20+MOS_Table_2!$G$11+MOS_Table_2!$G$14+MOS_Table_2!$G$20+MOS_Table_2!$AA$11+MOS_Table_2!$AA$14+MOS_Table_2!$AA$20+MOS_Table_2!$AB$11+MOS_Table_2!$AB$14+MOS_Table_2!$AB$20,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$11+MOS_Table_2!$AC$14+MOS_Table_2!$AC$20,0)","v":0},null,null,"=","Refinery Intake",0,0,0,0,"="," Demand",0,0,0,0,0,0,0,0,0]
[null,null,"Closing stocks",{"$f":"ROUND(MOS_Table_5!$D$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$E$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$F$9+MOS_Table_5!$G$9+MOS_Table_5!$I$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$J$9,0)","v":0},null,"Closing stocks",{"$f":"ROUND(MOS_Table_5!$L$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$M$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$N$9+MOS_Table_5!$Q$9+MOS_Table_5!$R$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$S$9+MOS_Table_5!$V$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$S$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$Y$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$AB$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$K$9+MOS_Table_5!$AE$9+MOS_Table_5!$AF$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$AG$9,0)","v":0},null,{"$f":"IF(R21<>J21+K21+L21+M21+O21+P21+Q21,\"Total is not sum of the elements\",\"\")","v":""},null,null,"CSNATTER","CSNATTER",null,null,null,null,null,null,null,null,null,null,"CSNATTER/CSNATTER",null,null,null,null,"Closing stocks",{"$f":"ROUND(MOS_Table_5!$D$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$E$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$F$9+MOS_Table_5!$G$9+MOS_Table_5!$I$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$J$9,0)","v":0},null,"Closing stocks",{"$f":"ROUND(MOS_Table_5!$L$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$M$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$N$9+MOS_Table_5!$Q$9+MOS_Table_5!$R$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$S$9+MOS_Table_5!$V$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$S$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$Y$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$AB$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$K$9+MOS_Table_5!$AE$9+MOS_Table_5!$AF$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$AG$9,0)","v":0},null,null,null,"Closing stocks",0,0,0,0,null,"Closing stocks",0,0,0,0,0,0,0,0,0]
[]
[null,"Automatic Checks",null,null,null,null,null,null,null,null,null,"Automatic Checks Petroleum Products",null,null,null,null,null,null,null,null,null,null,"Item1 é","Item1 é",null,null,null,null,null,null,null,null,null,null,"Item1 for EU é",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NbInconsist : ",{"$f":"IF(DataFromMOS=FALSE,0,SUM(BH12:BK21)+SUM(BN12:BV21))","v":0}]
[null,null,"Total sum",null,{"$f":"IF(OR(G12<>SUM(D12:F12),G13<>SUM(F13),G14<>SUM(D14:F14),G15<>SUM(D15:F15),G16<>SUM(D16:F16),G17<>SUM(D17:F17),G18<>SUM(D18:F18),G19<>SUM(D19:F19),G20<>SUM(D20:F20),G21<>SUM(D21:F21)),\"Total not equal to the sum of the elements\",\"OK\")","v":"OK"},null,null,null,null,null,null,"Total products sum ",null,null,{"$f":"IF(OR(R12<>J12+K12+L12+M12+O12+P12+Q12,R13<>J13+K13+L13+M13+O13+P13+Q13,R14<>J14+K14+L14+M14+O14+P14+Q14,R15<>J15+K15+L15+M15+O15+P15+Q15,R16<>J16+K16+L16+M16+O16+P16+Q16,R17<>J17+K17+L17+M17+O17+P17+Q17,R18<>J18+K18+L18+M18+O18+P18+Q18,R20<>J20+K20+L20+M20+O20+P20+Q20,R19<>J19+K19+L19+M19+O19+P19+Q19,R21<>J21+K21+L21+M21+O21+P21+Q21),\"Total Products column is not the sum of the elements\",\"OK\")","v":"OK"}]
[null,null,"Statistical difference",null,{"$f":"IF(OR(D19<>(D12+D14-D15-D17-D18-D20),E19<>(E12+E14-E15-E17-E18-E20),F19<>(F12+F13+F14-F15+F16-F17-F18-F20),G19<>(G12+G13+G14-G15+G16-G17-G18-G20)),\"Statistical Difference not calculated correctly\",\"OK\")","v":"OK"},null,null,null,null,null,null,"Statistical difference",null,null,{"$f":"IF(OR(J19<>(J12+J13+J14-J15-J16+J17-J18-J20),K19<>(K12+K13+K14-K15-K16+K17-K18-K20),L19<>(L12+L13+L14-L15-L16+L17-L18-L20),M19<>(M12+M13+M14-M15-M16+M17-M18-M20),N19<>(N12+N13+N14-N15-N16+N17-N18-N20),O19<>(O12+O13+O14-O15-O16+O17-O18-O20),P19<>(P12+P13+P14-P15-P16+P17-P18-P20),Q19<>(Q12+Q13+Q14-Q15-Q16+Q17-Q18-Q20),R19<>(R12+R13+R14-R15-R16+R17-R18-R20)),\"Statistical Difference not calculated correctly\",\"OK\")","v":"OK"}]
[null,null,"Stat. diff./Refinery intake",null,{"$f":"IF(OR(ABS(D19)>0.1*D20,ABS(E19)>0.1*E20,ABS(F19)>0.1*F20,ABS(G19)>0.1*G20),\"Statistical Difference above 10% of Refinery Intake, please investigate\",\"OK\")","v":"OK"},null,null,null,null,null,null,"Stat. diff. /Demand",null,null,{"$f":"IF(OR(ABS(J19)>0.1*J20,ABS(K19)>0.1*K20,ABS(L19)>0.1*L20,ABS(M19)>0.1*M20,ABS(N19)>0.1*N20,ABS(O19)>0.1*O20,ABS(P19)>0.1*P20,ABS(Q19)>0.1*Q20,ABS(R19)>0.1*R20),\"Statistical Difference above 10% of Demand, please investigate\",\"OK\")","v":"OK"}]
[null,null,"Products transferred",null,{"$f":"IF(G16<R16,\"'Products Transferred/Backflows' for Total should be larger than 'Products Transferred' for Total Products\",\"OK\")","v":"OK"},null,null,null,null,null,null,"Negative Products transferred",null,null,{"$f":"IF(OR(J16<0,K16<0,L16<0,M16<0,N16<0,O16<0,P16<0,Q16<0,R16<0),\"Products Transferred should be positive\",\"OK\")","v":"OK"}]
[null,null,"Negative products transferred",null,{"$f":"IF(OR(F16<0,G16<0),\"Products transferred/backflows should be positive\",\"OK\")","v":"OK"},null,null,null,null,null,null,"Interproduct transfers",null,null,{"$f":"IF(R17<>0,\"Total Products Interproduct Transfers should be zero\",\"OK\")","v":"OK"}]
[null,null,"Blocked out cells",null,{"$f":"IF(OR(D13<>0,E13<>0,D16<>0,E16<>0),\"No data should be reported in blocked out cells\",\"OK\")","v":"OK"},null,null,null,null,null,null,"Jet kerosene",null,null,{"$f":"IF(OR(N12>M12,N13>M13,N14>M14,N15>M15,N16>M16,N20>M20,N21>M21),\"Jet Kerosene should be smaller than Total Kerosene\",\"OK\")","v":"OK"}]
[null,null,"Negative stock values",null,{"$f":"IF(OR(D21<0,E21<0,F21<0,G21<0),\"Negative stock value\",\"OK\")","v":"OK"},null,null,null,null,null,null,"Negative stock values",null,null,{"$f":"IF(OR(J21<0,K21<0,L21<0,M21<0,N21<0,O21<0,P21<0,Q21<0,R21<0),\"Negative stock value\",\"OK\")","v":"OK"}]
[null,null,"Refinery losses",{"$f":"G20-R12","v":0},{"$f":"IF(D31<0,\"Reported figures imply a refinery gain. Losses should not be negative\",\"OK\")","v":"OK"}]
[null,null,"Consistency with MOS tables",null,{"$f":"IF(NbInconsist=0,\"OK\",IF(NbInconsist=1,\"There is an inconsistency with MOS in this file : see orange cell\",\"There are \"&NbInconsist&\" inconsistencies with MOS in this file : see orange cells\"))","v":"OK"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Datatype ê","EU column"]
[null,null,"EU row in 130","CRUDEOIL","NGL","OTHTONE","CRNGFEED","ç Products è",null,"LPG","NAPHTHA","GASOLINE","KEROSENE","JETKERO","GASDIES","RESFUEL","OTHTTWO","TOTPRODS",null,null,null,null,"BALANCE","in AI"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"Datatype for EU ê"]
[null,null,null,"CRUDEOIL","NGL","OTHTONE","CRNGFEED","ç Products for EU è",null,"LPG","NAPHTHA","GASOLINE","KEROSENE","JETKERO","GASDIES","RESFUEL","OTHTTWO","TOTPRODS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BALANCE"]

{"sheet":"MOS_Table_1","index":2,"n_rows":130,"n_cols":35,"rows_kept":130,"cut":false,"hidden":false,"merged":[[10,11,11,11],[10,9,11,9],[1,3,1,4],[10,3,11,3],[10,4,11,4],[10,5,11,5],[10,6,11,6],[10,8,11,8]]}
["MONTHLY OIL QUESTIONNAIRE",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,"Final"]
[2010,"Country",null,{"$f":"CountryUser","v":"(select country)"},null,null,null,null,null,null,null,null,"Provisional"]
[null,"Month of data",null,{"$f":"FirstMonth & \" \" & QuestYear","v":"January 2021"},null,null,null,"ALL DATA SHOULD BE ENTERED"]
[null,"Status of data (final/provisional)",null,null,null,null,null,"IN THOUSAND METRIC TONS"]
[null,"Prepared by",null,null,null,null,null,"WITH NO DECIMAL PLACE"]
[null,"Date of transmisssion"]
[]
["Table 1: SUPPLY OF CRUDE OIL, NGL, REFINERY FEEDSTOCKS, ADDITIVES AND OTHER HYDROCARBONS"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(CountryUser=\"United States (Barrels)\",\"Unit: Thousand barrels\",\"Unit: Thousand metric tons\")","v":"Unit: Thousand metric tons"}]
[null,null,null,"Crude oil","Natural gas\nliquids","Refinery\nfeedstocks","Additives /\noxygenates",null,"Other\nhydrocarbons","Total\n(A to F, excl. E)",null,"Checks"]
[null,null,null,null,null,null,null,"Of which\nBiofuels"]
[null,null,null,"A","B","C","D","E","F","G",null,"H",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item1 ê"]
["+","Indigenous production",1,null,null,null,null,null,null,{"$f":"SUM(D14:G14,I14)","v":0},null,{"$f":"IF(J14-SUM(G14,I14,D14:E14)=0,\"\",\"Total is not equal to the sum of each product\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INDPROD"]
["+","Receipts from other sources",2,null,null,null,null,null,null,0,null,{"$f":"IF(J15-SUM(G15,I15)=0,\"\",\"Total is not equal to the sum of each product\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OSOURCES"]
["+","Backflows1",3,null,null,null,null,null,null,0,null,{"$f":"IF(J16-SUM(F16)=0,\"\",\"Total is not equal to the sum of each product\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BACKFLOW"]
["+","Products transferred2",4,null,null,null,null,null,null,0,null,{"$f":"IF(J17-SUM(F17)=0,\"\",\"Total is not equal to the sum of each product\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PTRANSF"]
["+","Imports (Balance)",5,null,null,null,null,null,null,0,null,{"$f":"IF(J18-SUM(D18:G18,I18)=0,\"\",\"Total is not equal to the sum of each product\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTIMPSB"]
["-","Exports (Balance)",6,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTEXPSB"]
["-","Direct use3",7,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIRECUSE"]
["-","Stock changes4",8,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STCHANAT"]
["=","Refinery intake (Calculated)",9,{"$f":"D14+D15+D16+D17+D18-D19-D20-D21","v":0},0,0,0,0,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,"REFINCAL"]
["-","Statistical difference",10,{"$f":"D22-D24","v":0},0,0,0,0,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,"STATDIFF"]
["=","Refinery intake (Observed)",11,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REFINOBS"]
[null,"Memo Item:       Refinery losses",12,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REFLOSS"]
[null,null,null,{"$f":"IF(MIN(D14,D18:D20,D24)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(E14,E18:E20,E24)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(F16:F20,F24)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(G14:G15,G18:G20,G24:G24)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(H14:H15,H18:H20,H24:H24)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(I14:I15,I18:I20,I24)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(J14:J20,J24)<0,\"Negative number\",\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR(H14>G14,H15>G15,H18>G18,H19>G19,H20>G20,H24>G24,H25>G25),\"Error: Of which Biofuels greater than Additives / Oxygenates\",\"\")","v":""}]
[1,"Total of Backflows (reference G3) should correspond to Total products of Backflows to refineries in Table 2 (reference Z19).",null,null,null,null,null,{"$f":"J16-MOS_Table_2!AC26","v":0},{"$f":"IF(H28=0,\"OK\",\"Total Backflows not equal to Total Backflows on table 2\")","v":"OK"}]
[2,"Total of Products transferred (reference G4) should correspond to Total products of Products transferred in Table 2 (reference Z9).",null,null,null,null,null,{"$f":"J17-MOS_Table_2!AC16","v":0},{"$f":"IF(H29=0,\"OK\",\"Total of Product transferred not equal to total of Product transferred on table 2\")","v":"OK"}]
[3,"Direct use should be carried over to Primary product receipts in Table 2 (line 1).",null,null,null,null,null,{"$f":"J20-MOS_Table_2!AC8","v":0},{"$f":"IF(H30=0,\"OK\",\"Total Direct Use figure does not equal total of Primary Product Receipts on table 2\")","v":"OK"}]
[4,"Stock changes should correspond to Closing level minus Opening level of Stocks on national territory, Table 5 (line 2 minus line 1).",null,null,null,null,null,{"$f":"J21-(MOS_Table_5!J9-MOS_Table_5!J8)","v":0},{"$f":"IF(H31=0,\"OK\",\"Stock change not equal to Closing minus Opening levels on National Territory, table 5\")","v":"OK"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"Datatype"]
[null,"Products è",null,"CRUDEOIL","NGL","REFFEEDS","ADDITIVE","BIOFUELS","NONCRUDE","CRNGFEED",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BALANCE"]

{"sheet":"MOS_Table_2","index":3,"n_rows":130,"n_cols":45,"rows_kept":130,"cut":false,"hidden":false,"merged":[[4,23,5,23],[4,26,5,26],[4,27,5,27],[4,28,5,28],[4,30,5,30],[4,20,5,20],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,9,5,9],[4,12,5,12],[4,13,5,13],[4,14,5,14],[4,17,5,17]]}
["MONTHLY OIL QUESTIONNAIRE"]
[null,{"$f":"IF(MOS_Table_1!D2=0,\"\",MOS_Table_1!D2)","v":"(select country)"}]
[null,{"$f":"IF(MOS_Table_1!D3=0,\"\",MOS_Table_1!D3)","v":"January 2021"}]
["Table 2: SUPPLY OF FINISHED PRODUCTS",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,{"$f":"IF(CountryUser=\"United States (Barrels)\",\"Unit: Thousand barrels\",\"Unit: Thousand metric tons\")","v":"Unit: Thousand metric tons"}]
[null,null,null,"Crude\noil","Natural\ngas\nliquids","Refinery\ngas","Ethane","LPG","Naphtha","Total motor\ngasoline",null,null,"Aviation\ngasoline","Gasoline\ntype\njet fuel","Total\nkerosene\ntype\njet fuel",null,null,"Other\nkerosene",null,null,"Total\ngas/diesel\noil",null,null,"Total \nfuel oil",null,null,"Petroleum coke","Other products","Total products",null,"Probate"]
[null,null,null,null,null,null,null,null,null,null,"Biogasoline","Non-biogasoline",null,null,null,"Bio jet\nkerosene","Non-bio jet\nkerosene",null,"Road diesel","Heating and\nother gas oil",null,"Biodiesels","Non-bio\ngas/diesel\noil",null,"Fuel oil-\nlow sulphur \n(<1%)","Fuel oil-\nhigh sulphur\n (>=1%)"]
[null,null,null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z",null,"AA",null,null,null,null,null,null,null,null,null,null,null,null,null,"Item1 ê"]
["+","Primary product receipts1",1,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,{"$f":"SUM(D8:J8,M8:O8,R8,U8,X8,AA8:AB8)","v":0},null,{"$f":"IF(AC8-SUM(D8:J8,M8:O8,R8,U8,X8,AA8:AB8)=0,\"\",\"Total products is not equal to the sum of products\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"PPRECPTS"]
["+","Refinery gross output",2,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,{"$f":"SUM(F9:J9,M9:O9,R9,U9,X9,AA9:AB9)","v":0},null,{"$f":"IF(AC9-SUM(F9:J9,M9:O9,R9,U9,X9,AA9:AB9)=0,\"\",\"Total products is not equal to the sum of products\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"REFGROUT"]
["+","Recycled products",3,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,{"$f":"SUM(F10:J10,M10:O10,R10,U10,X10,AA10:AB10)","v":0},null,{"$f":"IF(AC10-SUM(F10:J10,M10:O10,R10,U10,X10,AA10:AB10)=0,\"\",\"Total products is not equal to the sum of products\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"RECYCLED"]
["-","Refinery fuel",4,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,{"$f":"SUM(F11:J11,M11:O11,R11,U11,X11,AA11:AB11)","v":0},null,{"$f":"IF(AC11-SUM(F11:J11,M11:O11,R11,U11,X11,AA11:AB11)=0,\"\",\"Total products is not equal to the sum of products\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"REFFUEL"]
["+","Imports (Balance)2",5,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,{"$f":"SUM(G12:J12,M12:O12,R12,U12,X12,AA12:AB12)","v":0},null,{"$f":"IF(AC12-SUM(G12:J12,M12:O12,R12,U12,X12,AA12:AB12)=0,\"\",\"Total products is not equal to the sum of products\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTIMPSB"]
["-","Exports (Balance)3",6,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,{"$f":"SUM(G13:J13,M13:O13,R13,U13,X13,AA13:AB13)","v":0},null,{"$f":"IF(AC13-SUM(G13:J13,M13:O13,R13,U13,X13,AA13:AB13)=0,\"\",\"Total products is not equal to the sum of products\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTEXPSB"]
["-","International marine bunkers",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,{"$f":"SUM(F14:J14,M14:O14,R14,U14,X14,AA14:AB14)","v":0},null,{"$f":"IF(AC14-SUM(F14:J14,M14:O14,R14,U14,X14,AA14:AB14)=0,\"\",\"Total products is not equal to the sum of products\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"BUNKERS"]
["+","Interproduct transfers4",8,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,{"$f":"SUM(D15:J15,M15:O15,R15,U15,X15,AA15:AB15)","v":0},null,{"$f":"IF(AC15-SUM(D15:J15,M15:O15,R15,U15,X15,AA15:AB15)=0,\"\",\"Total products is not equal to the sum of products\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"IPTRANSF"]
["-","Products transferred5",9,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,{"$f":"SUM(F16:J16,M16:O16,R16,U16,X16,AA16:AB16)","v":0},null,{"$f":"IF(AC16-SUM(F16:J16,M16:O16,R16,U16,X16,AA16:AB16)=0,\"\",\"Total products is not equal to the sum of products\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"PTRANSF"]
["-","Stock changes6",10,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,{"$f":"SUM(G17:J17,M17:O17,R17,U17,X17,AA17:AB17)","v":0},null,{"$f":"IF(AC17-SUM(G17:J17,M17:O17,R17,U17,X17,AA17:AB17)=0,\"\",\"Total products is not equal to the sum of products\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"STCHANAT"]
["=","Gross inland deliveries (Calculated)",11,{"$f":"D8+D15","v":0},{"$f":"E8+E15","v":0},{"$f":"F8+F9+F10-F11-F14+F15-F16","v":0},{"$f":"G8+G9+G10-G11+G12-G13-G14+G15-G16-G17","v":0},0,0,0,0,0,0,0,0,{"$f":"P8+P9+P10-P11+P12-P13-P14+P15-P16-P17","v":0},{"$f":"Q8+Q9+Q10-Q11+Q12-Q13-Q14+Q15-Q16-Q17","v":0},0,{"$f":"S8+S9+S10-S11+S12-S13-S14+S15-S16-S17","v":0},{"$f":"T8+T9+T10-T11+T12-T13-T14+T15-T16-T17","v":0},{"$f":"U8+U9+U10-U11+U12-U13-U14+U15-U16-U17","v":0},{"$f":"V8+V9+V10-V11+V12-V13-V14+V15-V16-V17","v":0},0,0,0,0,{"$f":"AA8+AA9+AA10-AA11+AA12-AA13-AA14+AA15-AA16-AA17","v":0},{"$f":"AB8+AB9+AB10-AB11+AB12-AB13-AB14+AB15-AB16-AB17","v":0},{"$f":"SUM(D18:J18,M18:O18,R18,U18,X18,AA18:AB18)","v":0},null,{"$f":"IF(AC18-SUM(D18:J18,M18:O18,R18,U18,X18,AA18:AB18)=0,\"\",\"Total products is not equal to the sum of products\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"GDINCTRC"]
["-","Statistical difference",12,{"$f":"D18-D20","v":0},{"$f":"E18-E20","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"P18-P20","v":0},{"$f":"Q18-Q20","v":0},0,{"$f":"S18-S20","v":0},{"$f":"T18-T20","v":0},{"$f":"U18-U20","v":0},{"$f":"V18-V20","v":0},0,0,0,0,{"$f":"AA18-AA20","v":0},{"$f":"AB18-AB20","v":0},{"$f":"SUM(D19:J19,M19:O19,R19,U19,X19,AA19:AB19)","v":0},null,{"$f":"IF(AC19-SUM(D19:J19,M19:O19,R19,U19,X19,AA19:AB19)=0,\"\",\"Total products is not equal to the sum of products\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"STATDIFF"]
["=","Gross inland deliveries (Observed)",13,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,{"$f":"SUM(D20:J20,M20:O20,R20,U20,X20,AA20:AB20)","v":0},null,{"$f":"IF(AC20-SUM(D20:J20,M20:O20,R20,U20,X20,AA20:AB20)=0,\"\",\"Total products is not equal to the sum of products\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"GDINCTRO"]
[null,"Memo Items:7                    Deliveries to international aviation",14,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,{"$f":"SUM(M21:O21)","v":0},null,{"$f":"IF(AC21-SUM(M21:O21)=0,\"\",\"There is an error in this line\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"INTLCIAV"]
[null,"Deliveries to main activity producer power plants",15,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,{"$f":"SUM(D22:J22,M22:O22,R22,U22,X22,AA22:AB22)","v":0},null,{"$f":"IF(AC22-SUM(D22:J22,M22:O22,R22,U22,X22,AA22:AB22)=0,\"\",\"Total products is not equal to the sum of products\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"PUBELEC"]
[null,"Deliveries of automotive LPG",16,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,{"$f":"H23","v":0},null,{"$f":"IF(AC23-H23=0,\"\",\"Total products is not equal to deliveries of Automotive LPG reported\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"AUDILPG"]
[null,"Deliveries of rail and marine diesel",17,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,{"$f":"U24","v":0},null,{"$f":"IF(AC24-U24=0,\"\",\"Total products is not equal to Deliveries of rail and marine diesel of Total gas/diesel oil\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"ERAILMAR"]
[null,"Gross deliveries to the petrochemical industry8",18,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,{"$f":"SUM(D25:J25,M25:O25,R25,U25,X25,AA25:AB25)","v":0},null,{"$f":"IF(AC25-SUM(D25:J25,M25:O25,R25,U25,X25,AA25:AB25)=0,\"\",\"Total products is not equal to the sum of products\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"GDPETCH"]
[null,"Backflows to refineries9",19,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,{"$f":"SUM(F26:J26,M26:O26,R26,U26,X26,AA26:AB26)","v":0},null,{"$f":"IF(AC26-SUM(F26:J26,M26:O26,R26,U26,X26,AA26:AB26)=0,\"\",\"Total products is not equal to the sum of products\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"BACKFLOW"]
[null,"Net deliveries of Total products",20,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,{"$f":"AC20-AC26","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NETDELIC"]
[null,null,null,{"$f":"IF(MIN(D8,D18,D20,D22,D25)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(E8,E18,E20,E22,E25)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(F8:F11,F14,F16,F18,F20,F22,F25,F26)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(G8:G14,G16,G18,G20,G22,G25,G26)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(H8:H14,H16,H18,H20,H22,H23,H25,H26)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(I8:I14,I16,I18,I20,I22,I25,I26)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(J8:J14,J16,J18,J20,J22,J25,J26)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(K8:K14,K16,K18,K20,K22,K25,K26)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(L8:L14,L16,L18,L20,L22,L25,L26)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(M8:M14,M16,M18,M20,M21,M22,M25,M26)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(N8:N14,N16,N18,N20,N21,N22,N25,N26)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(O8:O14,O16,O18,O20,O21,O22,O25,O26)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(P8:P14,P16,P18,P20,P21,P22,P25,P26)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(Q8:Q14,Q16,Q18,Q20,Q21,Q22,Q25,Q26)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(R8:R14,R16,R18,R20,R22,R25,R26)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(S8:S14,S16,S18,S20,S22,S25,S26)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(T8:T14,T16,T18,T20,T22,T25,T26)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(U8:U14,U16,U18,U20,U22,U24,U25,U26)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(V8:V14,V16,V18,V20,V22,V24,V25,V26)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(W8:W14,W16,W18,W20,W22,W24,W25,W26)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(X8:X14,X16,X18,X20,X22,X25,X26)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(Y8:Y14,Y16,Y18,Y20,Y22,Y25,Y26)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(Z8:Z14,Z16,Z18,Z20,Z22,Z25,Z26)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(AA8:AA14,AA16,AA18,AA20,AA22,AA25,AA26)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(AB8:AB14,AB16,AB18,AB20,AB22,AB25,AB26)<0,\"Negative number\",\"\")","v":""},{"$f":"IF(MIN(AC8:AC14,AC16,AC18,AC20,AC21:AC27)<0,\"Negative number\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(L8>J8,L9>J9,L10>J10,L11>J11,L12>J12,L13>J13,L14>J14,L16>J16,L18>J18,L20>J20,L22>J22,L25>J25,L26>J26),\"Error: Non-biogasoline\nis greater than Total.\",\"\")","v":""},null,null,null,null,{"$f":"IF(OR(Q8>O8,Q9>O9,Q10>O10,Q11>O11,Q12>O12,Q13>O13,Q14>O14,Q16>O16,Q18>O18,Q20>O20,Q22>O22,Q25>O25,Q26>O26),\"Error: Non-biogasoline\nis greater than Total.\",\"\")","v":""},null,null,null,{"$f":"IF(OR(U8<>S8+T8,U9<>S9+T9,U10<>S10+T10,U11<>S11+T11,U12<>S12+T12,U13<>S13+T13,U14<>S14+T14,U16<>S16+T16,U18<>S18+T18,U20<>S20+T20,U22<>S22+T22,T24<>U24,U25<>S25+T25,U26<>S26+T26),\"Error: Sum not equal Total.\",\"\")","v":""},null,null,{"$f":"IF(OR(X8<>Y8+Z8,X9<>Y9+Z9,X10<>Y10+Z10,X11<>Y11+Z11,X12<>Y12+Z12,X13<>Y13+Z13,X14<>Y14+Z14,X16<>Y16+Z16,X18<>Y18+Z18,X20<>Y20+Z20,X22<>Y22+Z22,X25<>Y25+Z25,X26<>Y26+Z26),\"Error: Sum not equal Total.\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(K8>J8,K9>J9,K10>J10,K11>J11,K12>J12,K13>J13,K14>J14,K16>J16,K18>J18,K20>J20,K22>J22,K25>J25,K26>J26),\"Error: Biogasoline\nis greater than Total.\",\"\")","v":""},null,null,null,null,{"$f":"IF(OR(P8>O8,P9>O9,P10>O10,P11>O11,P12>O12,P13>O13,P14>O14,P16>O16,P18>O18,P20>O20,P21>O21,P22>O22,P25>O25,P26>O26),\"Error: Bjo jet kerosene\nis greater than Total.\",\"\")","v":""},null,null,null,{"$f":"IF(OR(T8>$U8,T9>$U9,T10>$U10,T11>$U11,T12>$U12,T13>$U13,T14>$U14,T16>$U16,T18>$U18,T20>$U20,T22>$U22,T24>$U24,T25>$U25,T26>$U26),\"Error: Heating and othergas oil\nis greater than Total gas/diesel oil.\",\"\")","v":""},null,{"$f":"IF(OR(V8>U8,V9>U9,V10>U10,V11>U11,V12>U12,V13>U13,V14>U14,V16>U16,V18>U18,V20>U20,V22>U22,V24>U24,V25>U25,V26>U26),\"Error: Biodiesels is greater than Total.\",\"\")","v":""},null,null,{"$f":"IF(OR(Y8>X8,Y9>X9,Y10>X10,Y11>X11,Y12>X12,Y13>X13,Y14>X14,Y16>X16,Y18>X18,Y20>X20,Y22>X22,Y25>X25,Y26>X26),\"Error: Fuel oil-low sulphur (<1%)\nis greater than Total.\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(J8<>K8+L8,J9<>K9+L9,J10<>K10+L10,J11<>K11+L11,J12<>K12+L12,J13<>K13+L13,J14<>K14+L14,J15<>K15+L15,J16<>K16+L16,J17<>K17+L17,J18<>K18+L18,J19<>K19+L19,J20<>K20+L20,J22<>K22+L22,J25<>K25+L25,J26<>K26+L26),\"Error: Sum not equal Total.\",\"\")","v":""},null,null,null,null,{"$f":"IF(OR(O8<>P8+Q8,O9<>P9+Q9,O10<>P10+Q10,O11<>P11+Q11,O12<>P12+Q12,O13<>P13+Q13,O14<>P14+Q14,O16<>P16+Q16,O18<>P18+Q18,O20<>P20+Q20,O21<>P21+Q21,O22<>P22+Q22,O25<>P25+Q25,O26<>P26+Q26),\"Error: Sum not equal Total.\",\"\")","v":""},null,null,null,{"$f":"IF(OR(S8>$U8,S9>$U9,S10>$U10,S11>$U11,S12>$U12,S13>$U13,S14>$U14,S16>$U16,S18>$U18,S20>$U20,S22>$U22,S25>$U25,S26>$U26),\"Error: Road diesel is greater\nthan Total gas/diesel oil.\",\"\")","v":""},null,null,null,{"$f":"IF(OR(W8>U8,W9>U9,W10>U10,W11>U11,W12>U12,W13>U13,W14>U14,W16>U16,W18>U18,W20>U20,W22>U22,W24>U24,W25>U25,W26>U26),\"Error: Non-bio gas/diesel oil is greater than Total.\",\"\")","v":""},null,null,{"$f":"IF(OR(Z8>X8,Z9>X9,Z10>X10,Z11>X11,Z12>X12,Z13>X13,Z14>X14,Z16>X16,Z18>X18,Z20>X20,Z22>X22,Z25>X25,Z26>X26),\"Error: Fuel oil-high sulphur (>=1%) is greater than Total.\",\"\")","v":""}]
[1,"Total of Primary product receipts (reference Z1) should correspond to Total of Direct use in MOS_Table_1 (reference G7).",null,null,null,null,null,{"$f":"AC8-MOS_Table_1!J20","v":0},{"$f":"IF(H32=0,\"OK\",\"Total of 'Primary product receipts' not equal to total of 'Direct use' in MOS_Table_1.\")","v":"OK"}]
[2,"Total of Interproduct transfers (reference Z8) should add to 0.",null,null,null,null,null,{"$f":"AC15","v":0},{"$f":"IF(H33=0,\"OK\",\"Interproduct transfers of Total products is not equal to 0.\")","v":"OK"}]
[3,"Total products of Products transferred (reference Z9) should correspond to Total of Products transferred in MOS_Table_1 (reference G4).",null,null,null,null,null,null,{"$f":"IF(G35=0,\"OK\",\"Products transferred of Total products is not equal to Products transferred of Total in MOS_Table_1.\")","v":"OK"}]
[4,"Stock changes is Closing level minus Opening level of Stocks on national territory, MOS_Table_5 (line 2 minus line 1).",null,null,null,null,{"$f":"AC16-MOS_Table_1!J17","v":0},{"$f":"AC17-(MOS_Table_5!AG9-MOS_Table_5!AG8)","v":0},{"$f":"IF(H35=0,\"OK\",\"Stock change for Total products is not equal to Closing stock level minus the Opening stock level on National territory in MOS_Table_5 for Total products.\")","v":"OK"}]
[5,"Memo item shouldn't be greater than the Gross inland deliveries (Observed):",null,null,null,null,null,null,{"$f":"IF(OR(H22+H23>H20,M21+M22>M20,N21+N22>N20,O22+O21>O20,P21+P22>P20,Q22+Q21>Q20,T22+T24>T20,U22+U24>U20,V22+V24>V20,W22+W24>W20),\"Sum of Memo Items shoud not exceed Gross inland deliveries (Observed).\",\"\")","v":""}]
[null,"         - Deliveries to international aviation.",null,null,null,null,null,{"$f":"IF(I39=\"OK\",0,1)","v":0},{"$f":"IF(OR(M21>M20,N21>N20,O21>O20,P21>P20,Q21>Q20),\"Deliveries to international aviation shoud not exceed Gross inland deliveries (Observed).\",\"OK\")","v":"OK"}]
[null,"         - Deliveries to main activity producer power plants.",null,null,null,null,null,{"$f":"IF(I40=\"OK\",0,1)","v":0},{"$f":"IF(OR(D22>D20,E22>E20,F22>F20,G22>G20,H22>H20,I22>I20,J22>J20,K22>K20,L22>L20,M22>M20,N22>N20,O22>O20,P22>P20,Q22>Q20,R22>R20,S22>S20,T22>T20,U22>U20,V22>V20,W22>W20,X22>X20,Y22>Y20,Z22>Z20,AA22>AA20,AB22>AB20),\"Deliveries to Main activity producer power plants should not exceed Gross inland deliveries (Observed).\",\"OK\")","v":"OK"}]
[null,"         - Deliveries of automotive LPG.",null,null,null,null,null,{"$f":"IF(I41=\"OK\",0,1)","v":0},{"$f":"IF((H23>H20),\"Deliveries of automotive LPG should not exceed Gross inland deliveries (Observed) of LPG.\",\"OK\")","v":"OK"}]
[null,"         - Deliveries of rail and marine diesel.",null,null,null,null,null,null,{"$f":"IF(OR(T24>T20,U24>U20,V24>V20,W24>W20),\"Deliveries of rail and marine diesel should not exceed Gross inland deliveries (Observed).\",\"OK\")","v":"OK"}]
[6,"Gross deliveries to the petrochemical industry should not be greater than the Gross inland deliveries (Observed).",null,null,null,null,null,{"$f":"IF(I43=\"OK\",0,1)","v":1},{"$f":"IF(OR(D25>D20,E25>E20,F25>F20,G25>G20,H25>H20,I25>I20,J25>J20,K25>K20,L25>L20,M25>M20,N25>N20,O25>O20,P25>P20,Q25>Q20,R25>R20,S25>S20,T25>T20,,U25>U20,V25>V20,W25>W20,X25>X20,Y25>Y20,Z25>Z20,AA25>AA20,AB25>AB20),\"Deliveries to the Petrochemical sector should not exceed Gross inland deliveries (Observed).\",\"OK\")","v":"OK"}]
[7,"Total of Backflows to refineries (reference Z19) should correspond to Total of Backflows in MOS_Table_1 (reference G3).",null,null,null,null,null,{"$f":"AC26-MOS_Table_1!J16","v":0},{"$f":"IF(H42=0,\"OK\",\"Backflows to refineries of Total products is not equal to Total of Backflows in MOS_Table_1.\")","v":"OK"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"Datatype"]
[null,"Products è",null,"CRUDEOIL","NGL","REFINGAS","ETHANE","LPG","NAPHTHA","MOTORGAS","BIOGASOL","NONBIOGASO","AVGAS","JETGAS","JETKERO","BIOJETKERO","NONBIOJETK","OTHKERO","DIESEL","HEATOIL","GASDIES","BIODIESEL","NONBIODIES","RESFUEL","LOWSULF","HIGHSULF","PETCOKE","OPRODS","TOTPRODS",null,null,null,null,null,"BALANCE"]

{"sheet":"MOS_Table_5","index":4,"n_rows":130,"n_cols":45,"rows_kept":130,"cut":false,"hidden":false,"merged":[[4,32,5,32],[4,33,5,33],[4,35,5,35],[4,18,5,18],[4,21,5,21],[4,24,5,24],[4,27,5,27],[4,30,5,30],[4,31,5,31],[4,17,5,17],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,8,5,8],[4,9,5,9],[4,10,5,10],[4,11,5,11],[4,12,5,12],[4,13,5,13],[4,16,5,16]]}
["MONTHLY OIL QUESTIONNAIRE"]
[{"$f":"IF(MOS_Table_1!D2=0,\"\",MOS_Table_1!D2)","v":"(select country)"}]
[{"$f":"IF(MOS_Table_1!D3=0,\"\",MOS_Table_1!D3)","v":"January 2021"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Datatype"]
["Table 5: STOCK LEVELS",null,null,null,"All opening stock levels should be equal to closing stock levels of the previous month",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,{"$f":"IF(CountryUser=\"United States (Barrels)\",\"Unit: Thousand barrels\",\"Unit: Thousand metric tons\")","v":"Unit: Thousand metric tons"},null,null,null,null,null,null,null,null,null,null,"BALANCE"]
[null,null,null,"Crude\noil","Natural\ngas\nliquids","Refinery\nfeedstocks","Additives /\noxygenates",null,"Other\nhydro-carbons","Total\n(A to F, excl. E)","Ethane","LPG","Naphtha","Total motor\ngasoline",null,null,"Aviation\ngasoline","Gasoline\ntype\njet fuel","Total\nkerosene\ntype\njet fuel",null,null,"Other\nkerosene",null,null,"Total\ngas/diesel\noil",null,null,"Total \nfuel oil",null,null,"Petroleum coke","Other products","Total products","Total\noil",null,"Probate"]
[null,null,null,null,null,null,null,"Of which\nBiofuels",null,null,null,null,null,null,"Biogasoline","Non-biogasoline",null,null,null,"Bio jet\nkerosene","Non-bio jet\nkerosene",null,"Road diesel","Heating and\nother gas oil",null,"Biodiesels","Non-bio\ngas/diesel\noil",null,"Fuel oil-\nlow sulphur \n(<1%)","Fuel oil-\nhigh sulphur\n (>=1%)"]
[null,null,null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","AA","AB","AC","AD","AE",null,"AF",null,null,null,null,null,null,null,null,"Item1 ê"]
["(a) All stocks on","Opening",1,{"$f":"D10+D12+D14+D16+D18+D20+D22+D24","v":0},{"$f":"E10+E12+E14+E16+E18+E20+E22+E24","v":0},0,{"$f":"G10+G12+G14+G16+G18+G20+G22+G24","v":0},{"$f":"H10+H12+H14+H16+H18+H20+H22+H24","v":0},0,{"$f":"J10+J12+J14+J16+J18+J20+J22+J24","v":0},0,{"$f":"L10+L12+L14+L16+L18+L20+L22+L24","v":0},{"$f":"M10+M12+M14+M16+M18+M20+M22+M24","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(K8:N8,Q8:S8,V8,Y8,AB8,AE8:AF8)","v":0},{"$f":"SUM(J8,AG8)","v":0},0," ",null,null,null,null,null,null,null,null,"OSNATTER"]
["national territory (b+c+d+e+f+g+h+i) 1","Closing",2,{"$f":"D11+D13+D15+D17+D19+D21+D23+D25","v":0},0,0,{"$f":"G11+G13+G15+G17+G19+G21+G23+G25","v":0},{"$f":"H11+H13+H15+H17+H19+H21+H23+H25","v":0},0,0,0,{"$f":"L11+L13+L15+L17+L19+L21+L23+L25","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(K9:N9,Q9:S9,V9,Y9,AB9,AE9:AF9)","v":0},{"$f":"SUM(J9,AG9)","v":0},0," ",null,null,null,null,null,null,null,null,"CSNATTER"]
["(b) Stocks held for other countries","Opening",3,null,null,null,null,null,null,{"$f":"SUM(D10:G10,I10)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"OSOTHBIL"]
["under official agreement","Closing 2",4,null,null,null,null,null,null,{"$f":"SUM(D11:G11,I11)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"CSOTHBIL"]
["(c) Stocks with known","Opening",5,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"OSOTHFOR"]
["foreign destination","Closing 3",6,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"CSOTHFOR"]
["(d) Stocks held in bonded areas","Opening",7,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"OSBONDED"]
["and not included in (b) or (c)","Closing",8,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"CSBONDED"]
["(e) Stocks held by major consumers,","Opening",9,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"OSMAJCON"]
["obligated by law","Closing",10,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"CSMAJCON"]
["(f) Stocks held on board incoming","Opening",11,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"OSVESSEL"]
["ocean vessels in port or at mooring","Closing",12,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"CSVESSEL"]
["(g) Stocks held by government","Opening",13,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"OSGOVT"]
[" on national territory","Closing",14,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"CSGOVT"]
["(h) Stocks held by stock holding ","Opening",15,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K22:N22,Q22:S22,V22,Y22,AB22,AE22:AF22)","v":0},0,0," ",null,null,null,null,null,null,null,null,"OSHOLD"]
["organisation on national territory","Closing",16,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"CSHOLD"]
["(i) All other stocks held on ","Opening",17,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"OSALLOTH"]
["national territory","Closing",18,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"CSALLOTH"]
["(j) Stocks held abroad under ","Opening",19,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"OSABRBIL"]
["official agreement (o+p+q)*","Closing 4",20,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K27:N27,Q27:S27,V27,Y27,AB27,AE27:AF27)","v":0},0,0," ",null,null,null,null,null,null,null,null,"CSABRBIL"]
["(k) Stocks held abroad designated definitely","Opening",21,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K28:N28,Q28:S28,V28,Y28,AB28,AE28:AF28)","v":0},0,0," ",null,null,null,null,null,null,null,null,"OSABRFOR"]
["for import into your country","Closing 5",22,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"CSABRFOR"]
["(l) Total","Opening",23,{"$f":"D8-D10-D12+D26+D28","v":0},0,0,{"$f":"G8-G10-G12+G26+G28","v":0},{"$f":"H8-H10-H12+H26+H28","v":0},0,0,0,{"$f":"L8-L10-L12+L26+L28","v":0},{"$f":"M8-M10-M12+M26+M28","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0," ",null,null,null,null,null,null,null,null,"OSTOTAL"]
["stocks (a-b-c+j+k)","Closing",24,{"$f":"D9-D11-D13+D27+D29","v":0},0,0,{"$f":"G9-G11-G13+G27+G29","v":0},{"$f":"H9-H11-H13+H27+H29","v":0},0,0,0,{"$f":"L9-L11-L13+L27+L29","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0," ",null,null,null,null,null,null,null,null,"CSTOTAL"]
["(m) Other stocks in","Opening",25,null,null,null,null,null,null,{"$f":"SUM(D32:G32,I32)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"OSOTHBON"]
["bonded areas","Closing",26,null,null,null,null,null,null,{"$f":"SUM(D33:G33,I33)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"CSOTHBON"]
["(n) Pipeline","Opening",27,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"OSPIPE"]
["fill","Closing",28,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"CSPIPE"]
["(o) Government stocks held abroad","Opening",29,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"OSABILGV"]
["under official agreement*","Closing",30,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"CSABILGV"]
["(p) Holding organisation's stocks held abroad","Opening",31,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"OSABILHD"]
["under official agreement*","Closing",32,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"CSABILHD"]
["(q) Other stocks held abroad","Opening",33,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"OSABILOT"]
["under official agreement*","Closing",34,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0," ",null,null,null,null,null,null,null,null,"CSABILOT"]
[]
[]
[]
[]
["1. For All stocks on national territory the Closing minus Opening (line 2 minus line 1) should correspond to Stock changes in Table 1 (line 8) ",null,null,null,null,null,null,null,{"$f":"(J9-J8)-MOS_Table_1!J21","v":0},{"$f":"IF(I46=0,\"OK\",\"Closing stock minus Opening stock levels on National territory does not equal Stock changes in Table 1 for Total.\")","v":"OK"}]
["    and in Table 2 (line 10).",null,null,null,null,null,null,null,{"$f":"(AG9-AG8)-MOS_Table_2!AC17","v":0},{"$f":"IF(I47=0,\"OK\",\"Closing stock minus Opening stock levels on National territory does not equal Stock changes in Table 2 for Total Products.\")","v":"OK"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Products è",null,"CRUDEOIL","NGL","REFFEEDS","ADDITIVE","BIOFUELS","NONCRUDE","CRNGFEED","ETHANE","LPG","NAPHTHA","MOTORGAS","BIOGASOL","NONBIOGASO","AVGAS","JETGAS","JETKERO","BIOJETKERO","NONBIOJETK","OTHKERO","DIESEL","HEATOIL","GASDIES","BIODIESEL","NONBIODIES","RESFUEL","LOWSULF","HIGHSULF","PETCOKE","OPRODS","TOTPRODS","TOTALOIL"]

{"sheet":"Definitions - short","index":5,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"JODI_Oil!C2&\" - Definitions\"","v":"Joint Organisations Data Initiative - Oil - Definitions"}]
[]
[null,"PRODUCTS"]
[null," 1. Crude oil ",": Including lease condensate  – excluding  NGL.\n"]
[null," 2. NGL",": Liquid or liquefied hydrocarbons recovered from gas separation plants and gas processing facilities."]
[null," 3. Other",": Refinery feedstocks +  Additives/oxygenates + Other hydrocarbons.\n"]
[null," 4. Total",": Sum of categories (1) to (3).\n  Total = Crude Oil + NGL + Other\n"]
[null," 5. LPG",": Comprises propane and butane .\n"]
[null," 6. Naphtha",": Comprises Naphtha used as feedstocks for producing high octane gasoline and also as feedstock for the chemical/petrochemical industries."]
[null," 7. Gasoline ",": Comprises Motor gasoline, Aviation gasoline and Gasoline type jet fuel. Motorgasoline includes\n  Biogasoline, e.g.ethanol blends.\n"]
[null," 8. Total kerosene",": Comprises Jet kerosene and Other kerosene.\n"]
[null," 9. Of which: Jet kerosene",": Aviation fuel used for aviation turbine power units.\n  This amount is a subset of the amount reported under Total kerosene.\n"]
[null,"10. Gas/diesel oil",": For automotive and other purposes. Biodiesel is included.\n"]
[null,"11. Heavy fuel oil ",": Heavy residual oil / boiler oil, including bunker oil.\n"]
[null,"12. Other products",": Refinery gas, Ethane, Petroleum coke, Lubricants, White spirit & SPB, Bitumen, Paraffin waxes and Other petroleum products."]
[null,"13. Total products ",": Sum of categories (5) to (12)\n  Demand for Total products includes direct consumption of Crude oil, NGL and Other hydrocarbons."]
[]
[null,"FLOWS"]
[null,"Production ",": Marketed production, after removal of impurities but including quantities consumed by the producer in the production process."]
[null,"From other sources",": Inputs of  Additives, Biofuels and Other hydrocarbons that are produced from non-oil sources such as: Coal, Natural gas or Renewables."]
[null,"Imports/Exports ",": Goods having physically crossed the national boundaries, excluding transit trade, iternational marine and aviation bunkers."]
[null,"Products transferred/ Backflows",": Sum of Products transferred and Backflows from the Petrochemical industry."]
[null,"Direct use",": Refers to crude oil, NGL and Other hydrocarbons which are used directly, without being processed in \n  oil refineries, for example: crude oil burned for electricity generation"]
[null,"Stocks changes",": Closing minus opening level. A positive number corresponds to stock build, negative number corresponds to stock draw. "]
[null,"Statistical difference",": Differences between observed supply flows and Refinery Intake or Demand.\n"]
[null,"Refinery intake",": Observed refinery throughputs.\n"]
[null,"Closing stocks",": Represents the primary stocks level at the end of the month within national territories; includes stocks held by importers, refiners, stock holding organisations and governments.\n"]
[null,"Refinery output",": Gross output (including refinery fuel)."]
[null,"Receipts",": Primary product receipts (quantities of oil used directly without processing in a refinery) + Recycled products\n receipts for Other products include Direct use of Crude oil and NGL."]
[null,"Products transferred",": Imported petroleum products which are reclassified as feedstocks for further processing in the refinery, without delivery to final consumers."]
[null,"Interproduct transfers",": Reclassification of products, because their specification has changed, or because they are blended into another product: a negative indicates a product that will be reclassified, a positive shows a  reclassified product\n  Interproduct transfers for Other products includes Interproduct transfers of Crude oil and NGL."]
[null,"Demand",": Deliveries or sales to the inland market (domestic consumption) plus Refinery fuel plus International marine and Aviation bunkers.\n  Demand for Other products includes direct consumption of Crude oil, NGL, and Other hydrocarbons."]

{"sheet":"Product Definitions Long","index":6,"n_rows":72,"n_cols":3,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"DEFINITION OF PRODUCTS"]
[]
[null,null,"REFINERY INPUTS"]
[null,"1.","CRUDE OIL"]
[null,null,"Crude oil is a mineral oil of natural origin comprising a mixture of hydrocarbons and associated impurities, such as sulphur. It exists in the liquid phase under normal surface temperature and pressure and its physical characteristics (density, viscosity, etc.) are highly variable.  This category includes field or lease condensate recovered from associated and non-associated gas where it is commingled with the commercial crude oil stream."]
[null,"2.","NATURAL GAS LIQUIDS (NGL)"]
[null,null,"NGL are liquid or liquefied hydrocarbons recovered from natural gas in separation facilities or gas processing plants.  Natural gas liquids include ethane, propane, butane (normal and iso-), (iso) pentane and pentanes plus (sometimes referred to as natural gasoline or plant condensate)."]
[null,"3.","OTHERS"]
[null,null,"a.  Refinery Feedstocks"]
[null,null,"A refinery feedstock is a processed oil destined for further processing (e.g. straight run fuel oil or vacuum gas oil) excluding blending.  With further processing, it will be transformed into one or more components and/or finished products.  This definition also covers returns from the petrochemical industry to the refining industry (e.g. pyrolysis gasoline, C4 fractions, gas oil and fuel oil fractions)."]
[null,null,"b.1  Additives/Oxygenates"]
[null,null,"Additives are non-hydrocarbon compounds added to or blended with a product to modify fuel properties (octane, cetane, cold properties, etc.):"]
[null,null,"i.  oxygenates, such as alcohols (methanol, ethanol), ethers (such as MTBE (methyl tertiary butyl ether), ETBE (ethyl tertiary butyl ether), TAME (tertiary amyl methyl ether));"]
[null,null,"ii.  esters (e.g. rapeseed or dimethylester, etc.);"]
[null,null,"iii.  chemical compounds (such as TML, TEL and detergents)."]
[null,null,"b.2  Biofuels"]
[null,null,"Biofuels such as biogasoline and biodiesel that are blended into gasoline and diesel at oil refineries."]
[null,null,"i.  Biogasoline: a gasoline quality liquid fuel produced from biomass or used cooking oils consists of bioethanol, biomethanol, BioETBE and bioMTBE"]
[null,null,"ii.  Biodiesel: a diesel quality liquid fuel produced from biomass or used cooking oils,  consists of Biodiesel, bio-dimethylether, Fischer-Tropsh and cold pressed biooil."]
[null,null,"iii.  Bioethanol:  ethanol produced from biomass and/or biodegradable fraction of waste;"]
[null,null,"iv.  Biomethanol:  methanol produced from biomass and/or the biodegradable fraction of waste;"]
[null,null,"v.  Biodimethylether:  a diesel quality fuel produced from biomass and/or the biodegradable fraction of waste;"]
[null,null,"vi.  Biooil: a pyrolysis oil fuel produced from biomass."]
[null,null,"c.  Other Hydrocarbons"]
[null,null,"This category includes synthetic crude oil from tar sands, shale oil, etc., liquids from coal liquefaction, output of liquids from natural gas conversion into gasoline, hydrogen and emulsified oils (e.g. Orimulsion)."]
[]
[null,null,"PETROLEUM PRODUCTS"]
[null,"1.","LIQUEFIED PETROLEUM GASES (LPG)"]
[null,null,"LPG are light paraffinic hydrocarbons derived from the refinery processes, crude oil stabilisation and natural gas processing plants.  They consist mainly of propane (C3H8) and butane (C4Hl0) or a combination of the two.  They could also include propylene, butylene, isobutene and isobutylene.  \nLPG are normally liquefied under pressure for transportation and storage. "]
[null,"2.","NAPHTHA"]
[null,null,"Naphtha is a feedstock destined for either the petrochemical industry (e.g. ethylene manufacture or aromatics production).  Naphtha comprises material in the 30oC and 2l0oC distillation range or part of this range. Naphtha imported for blending is reported as an import of naphtha, then shown on the interproduct transfer row, as a negative entry for Naphtha, and a positive entry for the corresponding finished product."]
[null,"3.","GASOLINE"]
[null,null,"Gasoline includes motor gasoline, aviation gasoline and gasoline type jet fuel as defined below:"]
[null,null,"a. Motor Gasoline"]
[null,null,"Motor gasoline consists of a mixture of light hydrocarbons distilling between 35oC and 215oC.  It is used as a fuel for land based spark ignition engines.  Motor gasoline may include additives, oxygenates and octane enhancers, including lead compounds such as TEL (Tetraethyl lead) and TML (tetramethyl lead)."]
[null,null,"b. Aviation Gasoline"]
[null,null,"This is motor spirit prepared especially for aviation piston engines, with an octane number suited to the engine, a freezing point of -60oC and a distillation range usually within the limits of 30oC and 180oC."]
[null,null,"c. Gasoline Type Jet Fuel (Naphtha type Jet Fuel or JP4)"]
[null,null,"This includes all light hydrocarbon oils for use in aviation turbine power units, distilling between 100oC and 250oC.  They are obtained by blending kerosenes and gasoline or naphtha in such a way that the aromatic content does not exceed 25% in volume, and the vapour pressure is between 13.7kPa and 20.6kPa."]
[null,"4.","TOTAL KEROSENE"]
[null,null,"This category includes kerosene type Jet Fuel and Other Kerosene as defined below:"]
[null,null,"a. Kerosene Type Jet Fuel"]
[null,null,"This is a distillate used for aviation turbine power units.  It has the same distillation characteristics between 150oC and 300oC (generally not above 250oC) and flash point as kerosene.  In addition, it has particular specifications (such as freezing point) which are established by the International Air Transport Association (IATA). This category includes kerosene blending components"]
[null,null,"b. Other Kerosene"]
[null,null,"Kerosene comprises refined petroleum distillate and is used in sectors other than aircraft transport. It distils between 150oC and 300oC."]
[null,"5.","GAS/DIESEL OIL (DISTILLATE FUEL OIL)"]
[null,null,"Gas/diesel oil is primarily a medium distillate distilling between 180oC and 380oC, and mainly used for diesel compression ignition (cars, trucks, etc.), usually of low sulphur content."]
[null,"6.","FUEL OIL"]
[null,null,"This covers all residual (heavy) fuel oils (including those obtained by blending).  Kinematic viscosity is above 10 cSt at 80oC.  The flash point is always above 50oC and density is always more than 0.90 kg/l."]
[null,"7.","OTHER PRODUCTS"]
[null,null,"Other Products is the sum of Refinery Gas (not liquefied), Ethane, Petroleum Coke, Lubricants, White Spirit & SBP, Bitumen, Paraffin Waxes and Other products as defined below:"]
[null,null,"a. Refinery Gas (not liquefied)"]
[null,null,"Refinery gas includes a mixture of non-condensible gases mainly consisting of hydrogen, methane, ethane and olefins obtained during distillation of crude oil or treatment of oil products (e.g. cracking) in refineries.  This also includes gases which are returned from the petrochemical industry."]
[null,null,"b. Ethane"]
[null,null,"A naturally gaseous straight-chain hydrocarbon, (C2H6) extracted from natural gas and refinery gas streams."]
[null,null,"c. Petroleum Coke"]
[null,null,"Petroleum coke is a black solid by-product, obtained mainly by cracking and carbonising petroleum derived feedstock, vacuum bottoms, tar and pitches in processes such as delayed coking or fluid coking.  It consists mainly of carbon (90 to 95%) and has a low ash content.  It is used as a feedstock in coke ovens for the steel industry, for heating purposes, for electrode manufacture and for production of chemicals.  The two most important qualities are \"green coke\" and \"calcinated coke\".  This category also includes \"catalyst coke\" deposited on the catalyst during refining processes; this coke is not recoverable and is usually burned as refinery fuel.  \n"]
[null,null,"d. Lubricants"]
[null,null,"Lubricants are hydrocarbons produced from distillate by product; they are mainly used to reduce friction between bearing surfaces.  This category includes all finished grades of lubricating oil, from spindle oil to cylinder oil, and those used in greases, including motor oils and all grades of lubricating oil base stocks."]
[null,null,"e. White Spirit and SBP"]
[null,null,"White Spirit and SBP are defined as refined distillate intermediates with a distillation in the naphtha/kerosene range. They are sub-divided as:"]
[null,null,"i.  Industrial Spirit (SBP): Light oils distilling between 30o and 200oC.  There are 7 or 8 grades of industrial spirit, depending on the position of the cut in the distillation range.  The grades are defined according to the temperature difference between the 5% volume and 90% volume distillation points (which is not more than 60oC)."]
[null,null,"ii.  White Spirit: Industrial spirit with a flash point above 30oC.  The distillation range of white spirit is 135o to 200oC."]
[null,null,"f. Bitumen"]
[null,null,"Bitumen is a solid, semi-solid or viscous hydrocarbon with a colloidal structure, being brown to black in colour, obtained as a residue in the distillation of crude oil, by vacuum distillation of oil residues from atmospheric distillation.  Bitumen is often referred to as asphalt and is primarily used for construction of roads and for roofing material.  This category includes fluidized and cut back bitumen."]
[null,null,"g. Paraffin Waxes"]
[null,null,"These are saturated aliphatic hydrocarbons.  These waxes are residues extracted when dewaxing lubricant oils.  They have a crystalline structure which is more-or-less fine according to the grade.  Their main characteristics are as follows: they are colourless, odourless and translucent, with a melting point above 45oC. "]
[null,null,"h. Other Products"]
[null,null,"All products not specifically mentioned above, for example: tar and sulphur.  This category also includes aromatics (e.g. BTX or benzene, toluene and xylene) and olefins (e.g. propylene) produced within refineries. This should not be confused with \"7.  OTHER PRODUCTS\" above."]
[null,"8.","TOTAL PRODUCTS"]
[null,null,"Total Products is the total output of the refinery which is the sum of all petroleum products mentioned above."]

{"sheet":"Flows Definitions Long","index":7,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"DEFINITION OF FLOWS"]
[]
[null,"1.","PRODUCTION"]
[null,null,"Refers to Indigenous Production of Crude Oil, NGL and other Hydrocarbons: Report all production within national boundaries including off-shore production.  Production should only include marketable production, excluding volumes returned to formation.  Such production should include all crude oil, NGL, condensates and oil from shale and tar sands, etc.  It should also include the receipts of additives/oxygenates by refineries and blending plants from outside the refinery sector."]
[null,"2.","FROM OTHER SOURCES"]
[null,null,"These refer to supplies of Additives, Biofuels and Other Hydrocarbons that are produced from non-oil sources such as: coal, natural gas and renewable energy such as biofuels."]
[null,"3.","IMPORTS AND EXPORTS"]
[null,null,"Imports and Exports data should reflect amounts having crossed the national territorial boundaries, whether customs clearance has taken place or not.  Quantities of crude oil and products imported or exported under processing agreements (i.e. refining on account) should be included. "]
[null,null,"Note 1: Re-exports of oil imported for processing within bonded areas should be included as an export of product from the processing country to the final destination."]
[null,null,"Note 2: Imports or exports of ethanol (reported in the Additives/Oxygenate column) should relate to the quantities destined for fuel use. "]
[null,"4.","PRODUCTS TRANSFERS/BACKFLOWS (Sum of Products Transfers and Backflows from Petrochemical Industry)"]
[null,null,"Products Transferred are imported petroleum products which are reclassified as feedstocks for further processing in the refinery, without delivery to final consumers.  For example, naphtha imported for upgrading would be first reported as imports of naphtha, and then appears also as products transferred of naphtha. "]
[null,null,"Backflows from Petrochemical Industry are finished or semi-finished products which are returned from final consumers to refineries for processing, blending or sale.  They are usually by-products of petrochemical manufacturing.  For integrated petrochemical industries this flow should be estimated.  Transfers from one refinery to another within the country should be excluded."]
[null,"5.","DIRECT USE"]
[null,null,"Direct Use refers to Crude oil, NGL and other hydrocarbons which are used directly without being processed in oil refineries are reported as Direct use.  This includes, for example, crude oil burned for electricity generation."]
[null,"6.","STOCK CLOSING"]
[null,null,"This refers to total stocks on national territory including stocks held by governments, by major consumers or by stockholding organisations, stocks held on board incoming ocean vessels, stocks held in bonded areas and stocks held for others, whether under bilateral government agreement or not. In JODI, this refers to stock closing in the end of the month."]
[null,"7.","STOCK CHANGES"]
[null,null,"Stock changes should reflect the difference between opening stock level and closing stock level for stocks held on national territory. A stock build is shown as a negative number, and a stock draw as a positive number."]
[null,"8.","STATISTICAL DIFFERENCES"]
[null,null,"These are calculated as (Production + Imports - Exports + Product Transfers/Backflows - Direct Use ± Stock Change) - Refinery Intake. "]
[null,"9.","REFINERY INTAKE"]
[null,null,"This refers to the total amount of crude oil, NGL, other hydrocarbons and additives that are observed to have entered the refinery process."]
[null,"10.","REFINERY OUTPUT"]
[null,null,"This is production of finished products at a refinery or blending plant. This category excludes Refinery Losses, but includes Refinery Fuel."]
[null,"11.","RECEIPTS (Includes primary product receipts and recycled products)"]
[null,null,"Primary Product Receipts: Quantities of indigenous or imported crude oil (including condensate) and indigenous NGL which are used directly without being processed in an oil refinery.  For example, crude oil used to generate electricity should be placed in primary product receipts of crude oil. Quantities of indigenous NGL which are not included in refinery intake should be reported in primary product receipts of NGL, then transferred through the Interproduct transfers line to the allocated product type.  Please note that this flow includes the amounts of backflows from the petrochemical industry which, although not primary fuel, are used directly. "]
[null,null,"Recycled Products: These are finished products which pass a second time through the marketing network, after having been once delivered to final consumers (e.g. used lubricants which are reprocessed). These quantities should be distinguished from petrochemical Backflows.  "]
[null,"12.","INTERPRODUCT TRANSFERS"]
[null,null,"Interproduct Transfers Result from reclassification of products either because their specification has changed, or because they are blended into another product. For example, quantities of kerosene may be reclassified as gasoil after blending with the latter in order to meet its winter diesel specification.  A negative entry for one product must be compensated by a positive entry (or several entries) for one or several products and vice versa.  The total net effect should be zero."]
[null,"13.","DEMAND"]
[null,null,"The total demand of oil in a country includes the volume of oil required, on the one hand to supply all final consumers, energy transformation units (including refineries), energy producers within the country and on the other hand to provide all the national and foreign customers with fuels which they will use in international navigation and aviation (e.g. international aviation, marine bunkers, fishing etc.). "]
[null,null,"Total oil demand also includes volumes of crude oil, NGL and other hydrocarbons which are used directly without being processed in petroleum refineries (direct use). It concerns mainly oil which can be used unprocessed by power plants to generate electricity and heat."]

{"sheet":"Param","index":8,"n_rows":112,"n_cols":11,"rows_kept":112,"cut":false,"hidden":true,"merged":[]}
[]
[null,"SETTINGS"]
[]
[]
[]
[]
[null,null,"ParamCountry / CountryList"]
[null,null,"(select country)","SELECT","00"]
[null,null,"Albania","ALBANIA","AL"]
[null,null,"Armenia","ARMENIA","AM"]
[null,null,"Australia","AUSTRALI","AU"]
[null,null,"Austria","AUSTRIA","AT"]
[null,null,"Belarus","BELARUS","BY"]
[null,null,"Belgium","BELGIUM","BE"]
[null,null,"Bosnia and Herzegovina","BOSNIAHERZ","BA"]
[null,null,"Bulgaria","BULGARIA","BG"]
[null,null,"Canada","CANADA","CA"]
[null,null,"Chile","CHILE","CL"]
[null,null,"Colombia","COLOMBIA","CO"]
[null,null,"Costa Rica","COSTARICA","CR"]
[null,null,"Croatia","CROATIA","HR"]
[null,null,"Cyprus","CYPRUS","CY"]
[null,null,"Czech Republic","CZECH","CZ"]
[null,null,"Denmark","DENMARK","DK"]
[null,null,"Estonia","ESTONIA","EE"]
[null,null,"Finland","FINLAND","FI"]
[null,null,"France","FRANCE","FR"]
[null,null,"Georgia","GEORGIA","GE"]
[null,null,"Germany","GERMANY","DE"]
[null,null,"Greece","GREECE","GR"]
[null,null,"Hungary","HUNGARY","HU"]
[null,null,"Iceland","ICELAND","IS"]
[null,null,"Ireland","IRELAND","IE"]
[null,null,"Israel","ISRAEL","IL"]
[null,null,"Italy","ITALY","IT"]
[null,null,"Japan","JAPAN","JP"]
[null,null,"Korea","KOREA","KR"]
[null,null,"Kosovo* (under UNSCR 1244/99)","KOSOVO","XK"]
[null,null,"Latvia","LATVIA","LV"]
[null,null,"Liechtenstein","LIECHTEN","LI"]
[null,null,"Lithuania","LITHUANIA","LT"]
[null,null,"Luxembourg","LUXEMBOU","LU"]
[null,null,"Malta","MALTA","MT"]
[null,null,"Mexico","MEXICO","MX"]
[null,null,"Moldova","MOLDOVA","MD"]
[null,null,"Montenegro","MONTENEGRO","ME"]
[null,null,"Netherlands","NETHLAND","NL"]
[null,null,"New Zealand","NZ","NZ"]
[null,null,"North Macedonia","NORTHMACED","MK"]
[null,null,"Norway","NORWAY","NO"]
[null,null,"Poland","POLAND","PL"]
[null,null,"Portugal","PORTUGAL","PT"]
[null,null,"Romania","ROMANIA","RO"]
[null,null,"Russia","RUSSIA","RU"]
[null,null,"Serbia","SERBIA","RS"]
[null,null,"Slovak Republic","SLOVAKIA","SK"]
[null,null,"Slovenia","SLOVENIA","SI"]
[null,null,"Spain","SPAIN","ES"]
[null,null,"Sweden","SWEDEN","SE"]
[null,null,"Switzerland","SWITLAND","CH"]
[null,null,"Turkey","TURKEY","TR"]
[null,null,"Ukraine","UKRAINE","UA"]
[null,null,"United Kingdom","UK","GB"]
[null,null,"United States","USA","US"]
[null,null,"United States (Barrels)","USABBL","T4"]
[]
[]
[]
[]
[]
[null,null,"ParamMonth / MonthList / MonthCodes"]
[null,null,"January","JAN"]
[null,null,"February","FEB"]
[null,null,"March","MAR"]
[null,null,"April","APR"]
[null,null,"May","MAY"]
[null,null,"June","JUN"]
[null,null,"July","JUL"]
[null,null,"August","AUG"]
[null,"CALCULATIONS","September","SEP",null,"ê","DO NOT TOUCH!",null,null,null,"ê"]
[null,null,"October","OCT"]
[null,null,"November","NOV"]
[null,null,"December","DEC"]
[]
[]
[null,null,"MsgAfterRounding: ",true]
[]
[null,null,"DataFromMOS: ",true]
[]
[]
[]
[]
[]
[null,null,"MonthIndex: ",{"$f":"MATCH(FirstMonth,MonthList,0)","v":1}]
[]
[null,null,"QuestMonth: ",{"$f":"INDEX(ParamMonth,MonthIndex,2)","v":"JAN"}]
[]
[null,null,"CountryIndex: ",{"$f":"IF(CountryUser=0,1,MATCH(CountryUser,CountryList,0))","v":1}]
[]
[null,null,"QuestCountry: ",{"$f":"INDEX(ParamCountry,D98,3)","v":"00"}]
[null,null,"CountryCode: ",{"$f":"INDEX(ParamCountry,D98,2)","v":"SELECT"}]
[]
[null,null,"CsvMonth1: ","JUN","Paste by VBA"]
[null,null,"CsvYear1: ",2017,"Paste by VBA"]
[null,null,"PosiMonth1: ",{"$f":"IF(ISERROR(MATCH(D103,MonthCodes,0)),100,MATCH(D103,MonthCodes,0))","v":6}]
[]
[null,null,"CsvCountry:","JAPAN","Paste by VBA"]
[null,null,null,{"$f":"IF(ISERROR(MATCH(CsvCountry,CountryIeaList,0))=FALSE,MATCH(CsvCountry,CountryIeaList,0),IF(ISERROR(MATCH(CsvCountry,CountryIsoList,0))=FALSE,MATCH(CsvCountry,CountryIsoList,0),0))","v":29}]
[null,null,"CsvCountryName:",{"$f":"IF(ISERROR(INDEX(ParamCountry,D108,1)),\"UNKNOWN\",INDEX(ParamCountry,D108,1))","v":"Japan"},"Read by VBA"]
[null,null,"CsvMonthName:",{"$f":"INDEX(MonthList,PosiMonth1,1)","v":"June"},"Read by VBA"]
[]
[null,null,"MosOnly : ",{"$f":"SUM(MosOnlyT1,MosOnlyT2,MosOnlyT5)","v":0},"Read by VBA"]

{"sheet":"Formulas","index":9,"n_rows":79,"n_cols":94,"rows_kept":79,"cut":false,"hidden":true,"merged":[[42,90,43,90],[42,91,43,91],[42,92,43,92],[42,93,43,93],[42,60,44,62],[42,76,43,76],[42,77,43,77],[42,78,43,78],[42,81,43,81],[42,84,43,84],[42,87,43,87],[42,68,43,68],[42,69,43,69],[42,70,43,70],[42,71,43,71],[42,72,43,72],[42,73,43,73],[42,58,43,58],[42,30,44,32],[42,63,43,63],[42,64,43,64],[42,65,43,65],[42,66,43,66],[42,44,43,44],[42,47,43,47],[42,50,43,50],[42,53,43,53],[42,56,43,56],[42,57,43,57],[42,36,43,36],[42,37,43,37],[42,38,43,38],[42,39,43,39],[42,42,43,42],[42,43,43,43],[42,27,43,27],[42,28,43,28],[42,19,44,21],[42,33,43,33],[42,34,43,34],[42,35,43,35],[42,22,43,22],[42,23,43,23],[42,24,43,24],[42,25,43,25],[8,6,9,6],[8,3,9,3],[8,4,9,4],[8,5,9,5],[27,3,28,3],[27,4,28,4],[27,5,28,5],[27,6,28,6]]}
[2007.1]
[null,null,"Formulas backup for forms"]
[]
[null,null,"Caution:"]
[null,null,"The cells addresses must be exactly the same between the sheet of the Maxi-JODI form and this one (for example, cell D12 must be "]
[null,null,"\"Crude oil production\" in both sheets) because the program do a copy/paste of the formulas of this table on the other one."]
[null,null,"It has been done in order to facilitate the maintenance of the formulas: you must do it in this current sheet."]
[]
[null,null,null,"Crude Oil","NGL","Other","Total\n(1)+(2)+(3)",null,null,"Petroleum Products"]
[null,null,null,null,null,null,null,null,null,"LPG","Naphtha","Gasoline","Total Kerosene","Of which: Jet\nKerosene","Gas/ Diesel Oil","Fuel Oil","Other\nProducts","Total Products (5)+(6) +(7) +(8) +(10) +(11) +(12)"]
[null,null,null,"(1)","(2)","(3)","(4)",null,null,"(5)","(6)","(7)","(8)","(9)","(10)","(11)","(12)","(13)"]
[null,"+","Production",{"$f":"ROUND(MOS_Table_1!$D$14,0)","v":0},{"$f":"ROUND(MOS_Table_1!$E$14,0)","v":0},{"$f":"ROUND(MOS_Table_1!$G$14+MOS_Table_1!$I$14,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$14,0)","v":0},"+","Refinery Output",{"$f":"ROUND(MOS_Table_2!$H$9,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$9,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$9+MOS_Table_2!$M$9+MOS_Table_2!$N$9,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$9+MOS_Table_2!$R$9,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$9,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$9,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$9,0)","v":0},{"$f":"ROUND(MOS_Table_2!$F$9+MOS_Table_2!$G$9+MOS_Table_2!$AA$9+MOS_Table_2!$AB$9,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$9,0)","v":0}]
[null,"+","From Other sources",null,null,{"$f":"ROUND(MOS_Table_1!$G$15+MOS_Table_1!$I$15,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$15,0)","v":0},"+","Receipts",{"$f":"ROUND(MOS_Table_2!$H$8+MOS_Table_2!$H$10,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$8+MOS_Table_2!$I$10,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$8+MOS_Table_2!$J$10+MOS_Table_2!$M$8+MOS_Table_2!$M$10+MOS_Table_2!$N$8+MOS_Table_2!$N$10,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$8+MOS_Table_2!$O$10+MOS_Table_2!$R$8+MOS_Table_2!$R$10,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$8+MOS_Table_2!$O$10,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$8+MOS_Table_2!$U$10,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$8+MOS_Table_2!$X$10,0)","v":0},{"$f":"ROUND(MOS_Table_2!$D$8+MOS_Table_2!$E$8+MOS_Table_2!$F$8+MOS_Table_2!$G$8+MOS_Table_2!$AA$8+MOS_Table_2!$AB$8+MOS_Table_2!$F$10+MOS_Table_2!$G$10+MOS_Table_2!$AA$10+MOS_Table_2!$AB$10,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$8+MOS_Table_2!$AC$10,0)","v":0}]
[null,"+","Imports",{"$f":"ROUND(MOS_Table_1!$D$18,0)","v":0},{"$f":"ROUND(MOS_Table_1!$E$18,0)","v":0},{"$f":"ROUND(MOS_Table_1!$F$18+MOS_Table_1!$G$18+MOS_Table_1!$I$18,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$18,0)","v":0},"+","Imports",{"$f":"ROUND(MOS_Table_2!$H$12,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$12,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$12+MOS_Table_2!$M$12+MOS_Table_2!$N$12,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$12+MOS_Table_2!$R$12,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$12,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$12,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$12,0)","v":0},{"$f":"ROUND(MOS_Table_2!$G$12+MOS_Table_2!$AA$12+MOS_Table_2!$AB$12,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$12,0)","v":0}]
[null,"-","Exports",{"$f":"ROUND(MOS_Table_1!$D$19,0)","v":0},{"$f":"ROUND(MOS_Table_1!$E$19,0)","v":0},{"$f":"ROUND(MOS_Table_1!$F$19+MOS_Table_1!$G$19+MOS_Table_1!$I$19,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$19,0)","v":0},"-","Exports",{"$f":"ROUND(MOS_Table_2!$H$13,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$13,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$13+MOS_Table_2!$M$13+MOS_Table_2!$N$13,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$13+MOS_Table_2!$R$13,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$13,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$13,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$13,0)","v":0},{"$f":"ROUND(MOS_Table_2!$G$13+MOS_Table_2!$AA$13+MOS_Table_2!$AB$13,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$13,0)","v":0}]
[null,"+","Products Transferred /Backflows",null,null,{"$f":"ROUND(MOS_Table_1!$F$17+MOS_Table_1!$F$16,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$16+MOS_Table_1!$J$17,0)","v":0},"-","Products Transferred",{"$f":"ROUND(MOS_Table_2!$H$16,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$16,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$16+MOS_Table_2!$M$16+MOS_Table_2!$N$16,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$16+MOS_Table_2!$R$16,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$16,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$16,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$16,0)","v":0},{"$f":"ROUND(MOS_Table_2!$F$16+MOS_Table_2!$G$16+MOS_Table_2!$AA$16+MOS_Table_2!$AB$16,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$16,0)","v":0}]
[null,"-","Direct Use",{"$f":"ROUND(MOS_Table_1!$D$20,0)","v":0},{"$f":"ROUND(MOS_Table_1!$E$20,0)","v":0},{"$f":"ROUND(MOS_Table_1!$F$20+MOS_Table_1!$G$20+MOS_Table_1!$I$20,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$20,0)","v":0},"+","Interproduct Transfers",{"$f":"ROUND(MOS_Table_2!$H$15,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$15,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$15+MOS_Table_2!$M$15+MOS_Table_2!$N$15,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$15+MOS_Table_2!$R$15,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$15,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$15,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$15,0)","v":0},{"$f":"ROUND(MOS_Table_2!$D$15+MOS_Table_2!$E$15+MOS_Table_2!$F$15+MOS_Table_2!$G$15+MOS_Table_2!$AA$15+MOS_Table_2!$AB$15,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$15,0)","v":0}]
[null,"-","Stock Change",{"$f":"ROUND(MOS_Table_1!$D$21,0)","v":0},{"$f":"ROUND(MOS_Table_1!$E$21,0)","v":0},{"$f":"ROUND(MOS_Table_1!$F$21+MOS_Table_1!$G$21+MOS_Table_1!$I$21,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$21,0)","v":0},"-","Stock Change",{"$f":"ROUND(MOS_Table_2!$H$17,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$17,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$17+MOS_Table_2!$M$17+MOS_Table_2!$N$17,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$17+MOS_Table_2!$R$17,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$17,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$17,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$17,0)","v":0},{"$f":"ROUND(MOS_Table_2!$F$17+MOS_Table_2!$G$17+MOS_Table_2!$AA$17+MOS_Table_2!$AB$17,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$17,0)","v":0}]
[null,"-","Statistical Difference",{"$f":"ROUND(MOS_Table_1!$D$23,0)","v":0},{"$f":"ROUND(MOS_Table_1!$E$23,0)","v":0},{"$f":"ROUND(MOS_Table_1!$F$23+MOS_Table_1!$G$23+MOS_Table_1!$I$23,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$23,0)","v":0},"-","Statistical Difference",{"$f":"ROUND(MOS_Table_2!$H$19,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$19,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$19+MOS_Table_2!$M$19+MOS_Table_2!$N$19,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$19+MOS_Table_2!$R$19,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$19,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$19,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$19,0)","v":0},{"$f":"ROUND(MOS_Table_2!$D$19+MOS_Table_2!$E$19+MOS_Table_2!$F$19+MOS_Table_2!$G$19+MOS_Table_2!$AA$19+MOS_Table_2!$AB$19,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$19,0)","v":0}]
[null,"=","Refinery Intake",{"$f":"ROUND(MOS_Table_1!$D$24,0)","v":0},{"$f":"ROUND(MOS_Table_1!$E$24,0)","v":0},{"$f":"ROUND(MOS_Table_1!$F$24+MOS_Table_1!$G$24+MOS_Table_1!$I$24,0)","v":0},{"$f":"ROUND(MOS_Table_1!$J$24,0)","v":0},"="," Demand",{"$f":"ROUND(MOS_Table_2!$H$11+MOS_Table_2!$H$14+MOS_Table_2!$H$20,0)","v":0},{"$f":"ROUND(MOS_Table_2!$I$11+MOS_Table_2!$I$14+MOS_Table_2!$I$20,0)","v":0},{"$f":"ROUND(MOS_Table_2!$J$11+MOS_Table_2!$J$14+MOS_Table_2!$J$20+MOS_Table_2!$M$11+MOS_Table_2!$M$14+MOS_Table_2!$M$20+MOS_Table_2!$N$11+MOS_Table_2!$N$14+MOS_Table_2!$N$20,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$11+MOS_Table_2!$O$14+MOS_Table_2!$O$20+MOS_Table_2!$R$11+MOS_Table_2!$R$14+MOS_Table_2!$R$20,0)","v":0},{"$f":"ROUND(MOS_Table_2!$O$11+MOS_Table_2!$O$14+MOS_Table_2!$O$20,0)","v":0},{"$f":"ROUND(MOS_Table_2!$U$11+MOS_Table_2!$U$14+MOS_Table_2!$U$20,0)","v":0},{"$f":"ROUND(MOS_Table_2!$X$11+MOS_Table_2!$X$14+MOS_Table_2!$X$20,0)","v":0},{"$f":"ROUND(MOS_Table_2!$D$20+MOS_Table_2!$E$20+MOS_Table_2!$F$11+MOS_Table_2!$F$14+MOS_Table_2!$F$20+MOS_Table_2!$G$11+MOS_Table_2!$G$14+MOS_Table_2!$G$20+MOS_Table_2!$AA$11+MOS_Table_2!$AA$14+MOS_Table_2!$AA$20+MOS_Table_2!$AB$11+MOS_Table_2!$AB$14+MOS_Table_2!$AB$20,0)","v":0},{"$f":"ROUND(MOS_Table_2!$AC$11+MOS_Table_2!$AC$14+MOS_Table_2!$AC$20,0)","v":0}]
[null,null,"Closing stocks",{"$f":"ROUND(MOS_Table_5!$D$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$E$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$F$9+MOS_Table_5!$G$9+MOS_Table_5!$I$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$J$9,0)","v":0},null,"Closing stocks",{"$f":"ROUND(MOS_Table_5!$L$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$M$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$N$9+MOS_Table_5!$Q$9+MOS_Table_5!$R$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$S$9+MOS_Table_5!$V$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$S$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$Y$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$AB$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$K$9+MOS_Table_5!$AE$9+MOS_Table_5!$AF$9,0)","v":0},{"$f":"ROUND(MOS_Table_5!$AG$9,0)","v":0}]
[]
[]
[]
[null,null,"For the following form, the cells addresses do not need to be identical because the formulas are local ones and relatives."]
[null,null,"This form is used to paste the \"Totals\" and \"StatDiff\" formulas."]
[]
[null,null,null,"Crude Oil","NGL","Other","Total\n(1)+(2)+(3)",null,null,"Petroleum Products"]
[null,null,null,null,null,null,null,null,null,"LPG","Naphtha","Gasoline","Total Kerosene","Of which: Jet\nKerosene","Gas/ Diesel Oil","Fuel Oil","Other\nProducts","Total Products (5)+(6) +(7) +(8) +(10) +(11) +(12)"]
[null,null,null,"(1)","(2)","(3)","(4)",null,null,"(5)","(6)","(7)","(8)","(9)","(10)","(11)","(12)","(13)"]
[null,"+","Production",null,null,null,{"$f":"SUM(D31:F31)","v":0},"+","Refinery Output",null,null,null,null,null,null,null,null,{"$f":"SUM(J31:M31,O31:Q31)","v":0}]
[null,"+","From Other sources",null,null,null,0,"+","Receipts",null,null,null,null,null,null,null,null,0]
[null,"+","Imports",null,null,null,0,"+","Imports",null,null,null,null,null,null,null,null,0]
[null,"-","Exports",null,null,null,0,"-","Exports",null,null,null,null,null,null,null,null,0]
[null,"+","Products Transferred /Backflows",null,null,null,0,"-","Products Transferred",null,null,null,null,null,null,null,null,0]
[null,"-","Direct Use",null,null,null,0,"+","Interproduct Transfers",null,null,null,null,null,null,null,null,0]
[null,"-","Stock Change",null,null,null,0,"-","Stock Change",null,null,null,null,null,null,null,null,0]
[null,"-","Statistical Difference",{"$f":"D31+D33-D34-D36-D37-D39","v":0},{"$f":"E31+E33-E34-E36-E37-E39","v":0},{"$f":"F31+F32+F33-F34+F35-F36-F37-F39","v":0},{"$f":"G31+G32+G33-G34+G35-G36-G37-G39","v":0},"-","Statistical Difference",{"$f":"J31+J32+J33-J34-J35+J36-J37-J39","v":0},0,0,0,0,0,0,0,0]
[null,"=","Refinery Intake",null,null,null,{"$f":"SUM(D39:F39)","v":0},"="," Demand",null,null,null,null,null,null,null,null,{"$f":"SUM(J39:M39,O39:Q39)","v":0}]
[null,null,"Closing stocks",null,null,null,{"$f":"SUM(D40:F40)","v":0},null,"Closing stocks",null,null,null,null,null,null,null,null,{"$f":"SUM(J40:M40,O40:Q40)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,"MOS Tables 1, 2, and 5",null,"è",null,null,null,null,null,null,null,null,"Table 1",null,null,"Crude oil","Natural gas\nliquids","Refinery\nfeedstocks","Additives /\noxygenates",null,"Other\nhydrocarbons","Total\n(A to F, excl. E)",null,"Table 2",null,null,"Crude\noil","Natural\ngas\nliquids","Refinery\ngas","Ethane","LPG","Naphtha","Total motor\ngasoline",null,null,"Aviation\ngasoline","Gasoline\ntype\njet fuel","Total\nkerosene\ntype\njet fuel",null,null,"Other\nkerosene",null,null,"Total\ngas/diesel\noil",null,null,"Total \nfuel oil",null,null,"Petroleum coke","Other products","Total products",null,"Table 2",null,null,"Crude\noil","Natural\ngas\nliquids","Refinery\nfeedstocks","Additives /\noxygenates",null,"Other\nhydro-carbons","Total\n(A to F, excl. E)","Ethane","LPG","Naphtha","Total motor\ngasoline",null,null,"Aviation\ngasoline","Gasoline\ntype\njet fuel","Total\nkerosene\ntype\njet fuel",null,null,"Other\nkerosene",null,null,"Total\ngas/diesel\noil",null,null,"Total \nfuel oil",null,null,"Petroleum coke","Other products","Total products","Total\noil"]
[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,"Of which\nBiofuels",null,null,null,null,null,null,null,null,null,null,null,null,null,"Biogasoline","Non-biogasoline",null,null,null,"Bio jet\nkerosene","Non-bio jet\nkerosene",null,"Road diesel","Heating and\nother gas oil",null,"Biodiesels","Non-bio\ngas/diesel\noil",null,"Fuel oil-\nlow sulphur \n(<1%)","Fuel oil-\nhigh sulphur\n (>=1%)",null,null,null,null,null,null,null,null,null,null,null,"Of which\nBiofuels",null,null,null,null,null,null,"Biogasoline","Non-biogasoline",null,null,null,"Bio jet\nkerosene","Non-bio jet\nkerosene",null,"Road diesel","Heating and\nother gas oil",null,"Biodiesels","Non-bio\ngas/diesel\noil",null,"Fuel oil-\nlow sulphur \n(<1%)","Fuel oil-\nhigh sulphur\n (>=1%)"]
[null,null,null,null,"also here for formulas purpose",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","B","C","D","E","F","G",null,null,null,null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z",null,null,null,null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","AA","AB","AC","AD","AE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+","Indigenous production",1,null,null,null,null,null,null,{"$f":"SUM(W46:Z46,AB46)","v":0},null,"+","Primary product receipts1",1,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,{"$f":"SUM(AH46:AN46,AQ46:AS46,AV46,AY46,BB46,BE46:BF46)","v":0},null,"(a) All stocks on","Opening",1,{"$f":"BL48+BL50+BL52+BL54+BL56+BL58+BL60+BL62","v":0},{"$f":"BM48+BM50+BM52+BM54+BM56+BM58+BM60+BM62","v":0},0,{"$f":"BO48+BO50+BO52+BO54+BO56+BO58+BO60+BO62","v":0},{"$f":"BP48+BP50+BP52+BP54+BP56+BP58+BP60+BP62","v":0},0,{"$f":"BR48+BR50+BR52+BR54+BR56+BR58+BR60+BR62","v":0},0,{"$f":"BT48+BT50+BT52+BT54+BT56+BT58+BT60+BT62","v":0},{"$f":"BU48+BU50+BU52+BU54+BU56+BU58+BU60+BU62","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BS46:BV46,BY46:CA46,CD46,CG46,CJ46,CM46:CN46)","v":0},{"$f":"SUM(BR46,CO46)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+","Receipts from other sources",2,null,null,null,null,null,null,0,null,"+","Refinery gross output",2,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,{"$f":"SUM(AJ47:AN47,AQ47:AS47,AV47,AY47,BB47,BE47:BF47)","v":0},null,"national territory (b+c+d+e+f+g+h+i) 1","Closing",2,{"$f":"BL49+BL51+BL53+BL55+BL57+BL59+BL61+BL63","v":0},0,0,{"$f":"BO49+BO51+BO53+BO55+BO57+BO59+BO61+BO63","v":0},{"$f":"BP49+BP51+BP53+BP55+BP57+BP59+BP61+BP63","v":0},0,0,0,{"$f":"BT49+BT51+BT53+BT55+BT57+BT59+BT61+BT63","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BS47:BV47,BY47:CA47,CD47,CG47,CJ47,CM47:CN47)","v":0},{"$f":"SUM(BR47,CO47)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+","Backflows1",3,null,null,null,null,null,null,0,null,"+","Recycled products",3,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,{"$f":"SUM(AJ48:AN48,AQ48:AS48,AV48,AY48,BB48,BE48:BF48)","v":0},null,"(b) Stocks held for other countries","Opening",3,null,null,null,null,null,null,{"$f":"SUM(BL48:BO48,BQ48)","v":0},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,"+","Products transferred2",4,null,null,null,null,null,null,0,null,"-","Refinery fuel",4,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,{"$f":"SUM(AJ49:AN49,AQ49:AS49,AV49,AY49,BB49,BE49:BF49)","v":0},null,"under official agreement","Closing 2",4,null,null,null,null,null,null,{"$f":"SUM(BL49:BO49,BQ49)","v":0},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,"+","Imports (Balance)3",5,null,null,null,null,null,null,0,null,"+","Imports (Balance)2",5,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,{"$f":"SUM(AK50:AN50,AQ50:AS50,AV50,AY50,BB50,BE50:BF50)","v":0},null,"(c) Stocks with known","Opening",5,null,null,null,null,null,null,0,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,"-","Exports (Balance)4",6,null,null,null,null,null,null,0,null,"-","Exports (Balance)3",6,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,{"$f":"SUM(AK51:AN51,AQ51:AS51,AV51,AY51,BB51,BE51:BF51)","v":0},null,"foreign destination","Closing 3",6,null,null,null,null,null,null,0,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,"-","Direct use5",7,null,null,null,null,null,null,0,null,"-","International marine bunkers",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,{"$f":"SUM(AJ52:AN52,AQ52:AS52,AV52,AY52,BB52,BE52:BF52)","v":0},null,"(d) Stocks held in bonded areas","Opening",7,null,null,null,null,null,null,0,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,"-","Stock changes6",8,null,null,null,null,null,null,0,null,"+","Interproduct transfers4",8,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,{"$f":"SUM(AH53:AN53,AQ53:AS53,AV53,AY53,BB53,BE53:BF53)","v":0},null,"and not included in (b) or (c)","Closing",8,null,null,null,null,null,null,0,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,"=","Refinery intake (Calculated)",9,{"$f":"W46+W47+W48+W49+W50-W51-W52-W53","v":0},0,0,0,0,0,0,null,"-","Products transferred5",9,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,{"$f":"SUM(AJ54:AN54,AQ54:AS54,AV54,AY54,BB54,BE54:BF54)","v":0},null,"(e) Stocks held by major consumers,","Opening",9,null,null,null,null,null,null,0,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,"-","Statistical difference",10,{"$f":"W54-W56","v":0},0,0,0,0,0,0,null,"-","Stock changes6",10,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,{"$f":"SUM(AK55:AN55,AQ55:AS55,AV55,AY55,BB55,BE55:BF55)","v":0},null,"obligated by law","Closing",10,null,null,null,null,null,null,0,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,"=","Refinery intake (Observed)",11,null,null,null,null,null,null,0,null,"=","Gross inland deliveries (Calculated)",11,{"$f":"AH46+AH53","v":0},{"$f":"AI46+AI53","v":0},{"$f":"AJ46+AJ47+AJ48-AJ49-AJ52+AJ53-AJ54","v":0},{"$f":"AK46+AK47+AK48-AK49+AK50-AK51-AK52+AK53-AK54-AK55","v":0},0,0,0,0,0,0,0,0,{"$f":"AT46+AT47+AT48-AT49+AT50-AT51-AT52+AT53-AT54-AT55","v":0},{"$f":"AU46+AU47+AU48-AU49+AU50-AU51-AU52+AU53-AU54-AU55","v":0},0,{"$f":"AW46+AW47+AW48-AW49+AW50-AW51-AW52+AW53-AW54-AW55","v":0},{"$f":"AX46+AX47+AX48-AX49+AX50-AX51-AX52+AX53-AX54-AX55","v":0},{"$f":"AY46+AY47+AY48-AY49+AY50-AY51-AY52+AY53-AY54-AY55","v":0},{"$f":"AZ46+AZ47+AZ48-AZ49+AZ50-AZ51-AZ52+AZ53-AZ54-AZ55","v":0},0,0,0,0,{"$f":"BE46+BE47+BE48-BE49+BE50-BE51-BE52+BE53-BE54-BE55","v":0},{"$f":"BF46+BF47+BF48-BF49+BF50-BF51-BF52+BF53-BF54-BF55","v":0},{"$f":"SUM(AH56:AN56,AQ56:AS56,AV56,AY56,BB56,BE56:BF56)","v":0},null,"(f) Stocks held on board incoming","Opening",11,null,null,null,null,null,null,0,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,"Memo Item:       Refinery losses",12,null,null,null,null,null,null,0,null,"-","Statistical difference",12,{"$f":"AH56-AH58","v":0},{"$f":"AI56-AI58","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"AT56-AT58","v":0},{"$f":"AU56-AU58","v":0},0,{"$f":"AW56-AW58","v":0},{"$f":"AX56-AX58","v":0},{"$f":"AY56-AY58","v":0},{"$f":"AZ56-AZ58","v":0},0,0,0,0,{"$f":"BE56-BE58","v":0},{"$f":"BF56-BF58","v":0},{"$f":"SUM(AH57:AN57,AQ57:AS57,AV57,AY57,BB57,BE57:BF57)","v":0},null,"ocean vessels in port or at mooring","Closing",12,null,null,null,null,null,null,0,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,null,null,null,null,null,null,null,"=","Gross inland deliveries (Observed)",13,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,{"$f":"SUM(AH58:AN58,AQ58:AS58,AV58,AY58,BB58,BE58:BF58)","v":0},null,"(g) Stocks held by government","Opening",13,null,null,null,null,null,null,0,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,null,null,null,null,null,null,null,null,"Memo Items:7                    Deliveries to international aviation",14,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,{"$f":"SUM(AQ59:AS59)","v":0},null," on national territory","Closing",14,null,null,null,null,null,null,0,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,null,null,null,null,null,null,null,null,"Deliveries to main activity producer power plants",15,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,{"$f":"SUM(AH60:AN60,AQ60:AS60,AV60,AY60,BB60,BE60:BF60)","v":0},null,"(h) Stocks held by stock holding ","Opening",15,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BS60:BV60,BY60:CA60,CD60,CG60,CJ60,CM60:CN60)","v":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,null,null,null,null,null,null,null,null,"Deliveries of automotive LPG",16,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,{"$f":"AL61","v":0},null,"organisation on national territory","Closing",16,null,null,null,null,null,null,0,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,null,null,null,null,null,null,null,null,"Deliveries of rail and marine diesel",17,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,{"$f":"AY62","v":0},null,"(i) All other stocks held on ","Opening",17,null,null,null,null,null,null,0,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,null,null,null,null,null,null,null,null,"Gross deliveries to the petrochemical industry8",18,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,{"$f":"SUM(AH63:AN63,AQ63:AS63,AV63,AY63,BB63,BE63:BF63)","v":0},null,"national territory","Closing",18,null,null,null,null,null,null,0,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,null,null,null,null,null,null,null,null,"Backflows to refineries9",19,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,{"$f":"SUM(AJ64:AN64,AQ64:AS64,AV64,AY64,BB64,BE64:BF64)","v":0},null,"(j) Stocks held abroad under ","Opening",19,null,null,null,null,null,null,0,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,null,null,null,null,null,null,null,null,"Net deliveries of Total products",20,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,{"$f":"BG58-BG64","v":0},null,"official agreement (o+p+q)*","Closing 4",20,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BS65:BV65,BY65:CA65,CD65,CG65,CJ65,CM65:CN65)","v":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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(k) Stocks held abroad designated definitely","Opening",21,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BS66:BV66,BY66:CA66,CD66,CG66,CJ66,CM66:CN66)","v":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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"for import into your country","Closing 5",22,null,null,null,null,null,null,0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(l) Total","Opening",23,{"$f":"BL46-BL48-BL50+BL64+BL66","v":0},0,0,{"$f":"BO46-BO48-BO50+BO64+BO66","v":0},{"$f":"BP46-BP48-BP50+BP64+BP66","v":0},0,0,0,{"$f":"BT46-BT48-BT50+BT64+BT66","v":0},{"$f":"BU46-BU48-BU50+BU64+BU66","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"stocks (a-b-c+j+k)","Closing",24,{"$f":"BL47-BL49-BL51+BL65+BL67","v":0},0,0,{"$f":"BO47-BO49-BO51+BO65+BO67","v":0},{"$f":"BP47-BP49-BP51+BP65+BP67","v":0},0,0,0,{"$f":"BT47-BT49-BT51+BT65+BT67","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(m) Other stocks in","Opening",25,null,null,null,null,null,null,{"$f":"SUM(BL70:BO70,BQ70)","v":0},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bonded areas","Closing",26,null,null,null,null,null,null,{"$f":"SUM(BL71:BO71,BQ71)","v":0},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(n) Pipeline","Opening",27,null,null,null,null,null,null,0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fill","Closing",28,null,null,null,null,null,null,0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(o) Government stocks held abroad","Opening",29,null,null,null,null,null,null,0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"under official agreement*","Closing",30,null,null,null,null,null,null,0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(p) Holding organisation's stocks held abroad","Opening",31,null,null,null,null,null,null,0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"under official agreement*","Closing",32,null,null,null,null,null,null,0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(q) Other stocks held abroad","Opening",33,null,null,null,null,null,null,0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"under official agreement*","Closing",34,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]