{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","Data Entry","Summary","Data Table","Monthly Expenses","Yearly and Infrequent Expenses","FX Rates","Reference","Temp"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":45,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"ICSC Electronic Diary: Instructions"]
[]
[null,null,"Welcome to the ICSC Electronic Diary!\nThe electronic diary is an optional tool to help you track your montly household expenditures.\nWhile the primary purpose of this tool is to assist you in completing the ICSC Cost-of-Living Household Expenditure Survey, there are additional features which give you an overview of your expenditure patterns. Note that this is not the ICSC survey itself.\n\nNote: In the current version, foreign exchange conversions are done based on rates provided by the UN Treasury Office as of 15 September 2021 (https://treasury.un.org/operationalrates/OperationalRates.php)\n\nHOW TO USE:\nMacros MUST be enabled.\n\n1. To enter a new expense, either go to the \"Data Entry\" tab or click on \"Add New Expenditure\".\n2. On the \"Data Entry\" worksheet, fill in all required fields and click on \"Add New Expenditure\".\n3. To review or edit an expenditure record, click \"Review Expenditures\".\n4. To see values to be entered in the ICSC Cost-of-Living Survey, click on \"Monthly Expenses\" and \"Year and Infrequent Expenses\"."]
[]
[null,null,"Data Entry"]
[null,null,"You may record your expenses for the various items of the ICSC basket of goods and services. These expenditures can be entered by selecting the appropriate item category and subcategory, and specifying whether the purchases were made locally or outside the country of the duty station. The tool allows you to navigate to other dates for data entry. Note that all data entry fields are highlighted in yellow."]
[]
[null,null,"Summary"]
[null,null,"The home page serves as a visual summary of the expenses entered. All values displayed on the home page are in US Dollar (USD).\nYou can navigate to other features of this diary from the buttons on the lower left of the screen."]
[]
[null,null,"Data Table"]
[null,null,"You may refer to the Data Table to review and/or edit expenses recorded. Note, that the \"Clear Data Table\" button will clear all entries. To delete a single entry, you may select the row, right-click, and delete. You are encouraged to periodically save a copy of your expenditure history."]
[]
[null,null,"Monthly Expenses"]
[null,null,"The summary of monthly expenses presented in this table takes on the same format as the ICSC Cost-of-Living Survey. You have the option to display the expense amounts either as pro-rated values to reflect a monthly estimate of your expenditure habits, or a total of your entries. Toggle between \"Pro-rated for Monthly\" and \"Total\" to select your preferred setting.\n\nIf you select \"Pro-rated for Monthly\", the reported expenses are pro-rated to an average monthly expenditure. For example, if data has been recorded to show that 100 USD was spent over a span of 20 days (this span is based on the range of dates represented in the Data Table worksheet), the \"Pro-rated for Monthly\" option converts the values entered to a monthly equivalent by multiplying by a factor of 365/(12*20) to obtain an estimate of 152.08 USD for a typical month.  Similarly, if data has been recorded to show that 200 EUR was spent over a span of 45 days, this value would be multiplied by a factor of 365/(12*45) for an estimate of 135.19 EUR for a typical month.\n\nGiven that the pro-rated values express expenditures over the course of a month, the accuracy of the estimates increases as the timespan of the recorded data approaches the length of a month. If your data record covers only a few days and you have \"Pro-rated for Month\" selected, the values in this section will be less accurate compared to expenditure records over more dates.\n\nIn keeping with the layout of the ICSC Cost-of-Living Survey, monthly totals for in-area and out-of-area expenditures are recorded."]
[]
[null,null,"Yearly and Infrequent Expenses"]
[null,null,"The summary of yearly and infrequent expenses are simply the sums of the expenses associated with items purchased less frequently (e.g. furniture, automobiles, etc.). Unlike the values presented in the \"For Survey\" section, these have NOT been pro-rated to reflect a monthly estimate.\n\nWhen completing the ICSC Cost-of-Living survey, you may review these values for historical reference to estimate the appropriate expense."]

{"sheet":"Data Entry","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ICSC Electronic Diary: Data Entry"]
[]
[null,"COUNTRY OF DUTY STATION ","Afghanistan"]
[null,null,"Expenditure Date"]
[null,null,{"$f":"TODAY()","v":"2021-10-11"}]
[]
[null,"Item Category ",null,{"$f":"IF(OR(ISBLANK(NewExpenseCategory),ISERROR(MATCH(NewExpenseCategory,GroupList,0))),\"mandatory: select from dropdown list\",\"\")","v":"mandatory: select from dropdown list"}]
[null,"Item Subcategory ",null,{"$f":"IF(OR(ISBLANK(NewExpenseSubcategory),ISERROR(MATCH(NewExpenseSubcategory,INDIRECT(CONCATENATE(LEFT(NewExpenseCategory,3),\"List\")),0))),\"mandatory: select from dropdown list\",\"\")","v":"mandatory: select from dropdown list"}]
[null,"Description (optional) "," "]
[null,"Purchased Inside/Outside Duty Station? ","Inside"]
[null,"Amount ",null,"Use 1,234.56 number format"]
[null,"Currency ",{"$f":"IF(NewExpenseInsideOutside=\"Inside\", VLOOKUP(DSCountry, CurrencyTable, 3, FALSE), \"USD\")","v":"AFN"},{"$f":"IF(ISBLANK(NewExpenseCurrency),\"mandatory: select from dropdown list\",\"\")","v":""}]
[null,null,"Note: Foreign exchange conversions are based on rates published by the UN Treasury as of 15 September 2021."]

{"sheet":"Summary","index":2,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[[4,2,4,4],[14,2,15,4]]}
[]
[null,"ICSC Electronic Diary: Home Page"]
[null,"COUNTRY OF DUTY STATION","Date"]
[null,{"$f":"DSCountry","v":"Afghanistan"},{"$f":"TODAY()","v":"2021-10-11"}]
[null,null,"The table and pie chart are based on all expenditures entered in this diary.\nForeign exchange conversions are based on rates published by the UN Treasury as of 15 September 2021."]
[null,"Today's Expenditures (USD)"]
[null,{"$f":"SUMIF('Data Table'!B:B,TODAY(),'Data Table'!J:J)","v":0},null,null," "]
[]
[null,{"$f":"CONCATENATE(\"Current Expenditures (USD) for \",VLOOKUP(MONTH(TODAY()),MonthNumberTable,2,FALSE), \" \", YEAR(TODAY()))","v":"Current Expenditures (USD) for October 2021"}]
[null,{"$f":"SUMIF('Data Table'!B:B,\">\"&(TODAY()-DAY(TODAY())),'Data Table'!J:J)","v":0},null,null," "]
[]
[null,"Daily Average (USD)"]
[null,{"$f":"SUM('Data Table'!J:J)/RecordSpan","v":0},null,null," "]
[]
[null,null,"EXPENDITURES IN US DOLLAR"]
[]
[null,null,"Category","Total Expense","As Percentage"]
[null,null,"Alcoholic Beverages and Tobacco",{"$f":"SUMIF('Data Table'!C:C,$C18,'Data Table'!J:J)","v":0},{"$f":"IF($D18=0,0,$D18/$D$32)","v":0}]
[null,null,"Clothing and Footwear",{"$f":"SUMIF('Data Table'!C:C,$C19,'Data Table'!J:J)","v":0},{"$f":"IF($D19=0,0,$D19/$D$32)","v":0}]
[null,null,"Communication",{"$f":"SUMIF('Data Table'!C:C,$C20,'Data Table'!J:J)","v":0},0]
[null,null,"Education",{"$f":"SUMIF('Data Table'!C:C,$C21,'Data Table'!J:J)","v":0},0]
[null,null,"Food and Non-Alcoholic Beverages",{"$f":"SUMIF('Data Table'!C:C,$C22,'Data Table'!J:J)","v":0},0]
[null,null,"Furniture, Household Equipment and Home Maintenance",{"$f":"SUMIF('Data Table'!C:C,$C23,'Data Table'!J:J)","v":0},0]
[null,null,"Health",{"$f":"SUMIF('Data Table'!C:C,$C24,'Data Table'!J:J)","v":0},0]
[null,null,"Housing Expenditures",{"$f":"SUMIF('Data Table'!C:C,$C25,'Data Table'!J:J)","v":0},0]
[null,null,"Miscellaneous Goods and Services",{"$f":"SUMIF('Data Table'!C:C,$C26,'Data Table'!J:J)","v":0},0]
[null,null,"Other",{"$f":"SUMIF('Data Table'!C:C,$C27,'Data Table'!J:J)","v":0},0]
[null,null,"Recreation and Culture",{"$f":"SUMIF('Data Table'!C:C,$C28,'Data Table'!J:J)","v":0},0]
[null,null,"Restaurants and Hotels",{"$f":"SUMIF('Data Table'!C:C,$C29,'Data Table'!J:J)","v":0},0]
[null,null,"Transport Purchases",{"$f":"SUMIF('Data Table'!C:C,$C30,'Data Table'!J:J)","v":0},0]
[null,null,"Vehicles",{"$f":"SUMIF('Data Table'!C:C,$C31,'Data Table'!J:J)","v":0},0]
[null,null,"TOTAL",{"$f":"SUM(D18:D31)","v":0},{"$f":"SUM(E18:E31)","v":0}]

{"sheet":"Data Table","index":3,"n_rows":106,"n_cols":27,"rows_kept":106,"cut":false,"hidden":false,"merged":[[1,6,1,9],[1,1,1,5]]}
[]
[null,"ICSC Electronic Diary: Itemized List of All Expenditures",null,null,null,null,"Foreign exchange conversions are based on rates\npublished by the UN Treasury as of 30 June 2018."]
[null,"DATE","ITEM CATEGORY","ITEM SUBCATEGORY","ITEM DESCRIPTION","Inside/Outside\nDuty Station","AMOUNT","CURRENCY","TIME\nSPAN","AMOUNT\nin USD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PieChart1Group"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,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(ISBLANK($D63),\"\",VLOOKUP($D63,PieChart1Grouping,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,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(ISBLANK($D70),\"\",VLOOKUP($D70,PieChart1Grouping,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,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(ISBLANK($D77),\"\",VLOOKUP($D77,PieChart1Grouping,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Monthly Expenses","index":4,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,1,0,8],[1,3,2,3],[3,1,41,1]]}
[null,{"$f":"IF(ProRateOrSum=1, \"NOTE: The accuracy of pro-rated estimates depends upon the time span covered by the recorded expenditures. See \"\"Instructions\"\" for more details.\",\"\")","v":""}]
[null,null,null,"ICSC Electronic Diary for\nMonthly Expenditures","INSIDE COUNTRY\nOF DUTY STATION",null,null,"OUTSIDE COUNTRY\nOF DUTY STATION"]
[null,null,null,null,"Amount\nin Local Currency","Amount Spent in Other Currency\n(Expressed in USD)",null,"Amount Spent\n(Expressed in USD)"]
[null,"MONTHLY","Food and Non-Alcoholic Beverages"]
[null,null,1,"Food purchased in supermarkets, stores, markets",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D5,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D5,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D5,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]
[null,null,2,"Non-alcoholic beverages",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D6,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D6,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D6,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]
[null,null,"Alcohol and Tobacco"]
[null,null,3,"Alcoholic beverages",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D8,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D8,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D8,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]
[null,null,4,"Tobacco and tobacco products",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D9,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D9,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D9,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]
[null,null,"Clothing and Footwear"]
[null,null,5,"Repair and cleaning of clothing",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D11,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D11,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D11,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]
[null,null,6,"Repair of footwear",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D12,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D12,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D12,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]
[null,null,"Furniture, Household Equipment and Home Maintenance"]
[null,null,7,"Disposable household goods",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D14,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D14,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D14,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]
[null,null,"Health"]
[null,null,8,"Prescription drugs",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D16,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D16,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D16,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]
[null,null,9,"Non-prescription drugs and vitamins"]
[null,null,10,"Supplemental health insurance",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D18,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D18,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D18,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]
[null,null,"Transport Purchases"]
[null,null,11,"Fuels and lubricants for personal transport",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D20,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D20,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D20,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]
[null,null,12,"Car insurance",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D21,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D21,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D21,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]
[null,null,13,"Taxi",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D22,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D22,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D22,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]
[null,null,14,"Local transport services",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D23,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D23,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D23,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]
[null,null,"Communication"]
[null,null,15,"Postal Services",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D25,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D25,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D25,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]
[null,null,16,"Telecommunication services",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D26,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D26,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D26,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]
[null,null,"Recreation and Culture"]
[null,null,17,"Pets and related products and services",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D28,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D28,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D28,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]
[null,null,18,"Cinemas, theaters, concerts and other related activities",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D29,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D29,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D29,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]
[null,null,19,"Sporting events and related activities",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D30,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D30,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D30,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]
[null,null,20,"Film developing and print processing",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D31,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D31,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D31,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]
[null,null,21,"Books, newspapers and periodicals",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D32,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D32,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D32,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]
[null,null,22,"Stationery and drawing materials",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D33,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D33,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D33,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]
[null,null,"Restaurants and Hotels"]
[null,null,23,"Meals and beverages purchased in staff restaurants, cafeteria",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D35,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D35,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D35,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]
[null,null,24,"Meals and beverages purchased in commercial restaurants and cafes",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D36,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D36,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D36,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]
[null,null,"Miscellaneous Goods and Services"]
[null,null,25,"Hairdressing salons and personal grooming establishments",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D38,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D38,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D38,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]
[null,null,26,"Cosmetics and other goods for personal care",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D39,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D39,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D39,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]
[null,null,"Other Expenditures"]
[null,null,27,"Remittances except medical and educational expenses",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D41,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D41,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D41,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]
[null,null,28,"Other expenditures (Monthly)",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Monthly Expenses'!$D42,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D42,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Monthly Expenses'!$D42,'Data Table'!F:F,\"Outside\")*(IF(ProRateOrSum=1,MonthlyMultiplier,1))","v":0},"USD"]

{"sheet":"Yearly and Infrequent Expenses","index":5,"n_rows":56,"n_cols":9,"rows_kept":56,"cut":false,"hidden":false,"merged":[[1,3,2,3],[3,1,52,1]]}
[]
[null,null,null,"ICSC Electronic Diary for\nYearly Expenditures","INSIDE COUNTRY\nOF DUTY STATION",null,null,"OUTSIDE COUNTRY\nOF DUTY STATION"]
[null,null,null,null,"Amount\nin Local Currency","Amount Spent in Other Currency\n(Expressed in USD)",null,"Amount Spent\n(Expressed in USD)"]
[null,"YEARLY","Clothing and Footwear"]
[null,null,29,"Men's clothing",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D5,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D5,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D5,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,30,"Women's clothing",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D6,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D6,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D6,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,31,"Boys and girls clothing",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D7,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D7,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D7,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,32,"Clothing accessories and materials",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D8,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D8,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D8,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,33,"Footwear",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D9,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D9,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D9,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,"Furniture, Household Equipment, Maintenance"]
[null,null,34,"Furniture, furnishings, carpets and floor coverings",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D11,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D11,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D11,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,35,"Households textiles, including repair",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D12,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D12,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D12,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,36,"Small electric household appliances",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D13,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D13,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D13,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,37,"Glassware, tableware and household utensils",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D14,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D14,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D14,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,38,"Tools, equipment and other non-durable household goods",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D15,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D15,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D15,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,"Health"]
[null,null,39,"Therapeutic appliances and equipment, other medical supplies",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D17,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D17,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D17,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,40,"Medical, dental and paramedical services",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D18,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D18,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D18,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,"Transport Purchases"]
[null,null,41,"Spare parts and accessories for personal transport",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D20,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D20,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D20,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,42,"Maintenance and repair of personal transport",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D21,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D21,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D21,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,43,"Other services in respect of personal and public transport",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D22,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D22,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D22,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,44,"Long distance transport",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D23,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D23,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D23,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,45,"Airlines",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D24,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D24,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D24,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,"Communication"]
[null,null,46,"Telecommunication equipment",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D26,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D26,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D26,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,"Recreation and Culture"]
[null,null,47,"Audio-visual equipment including repairs",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D28,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D28,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D28,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,48,"Photographic equipment and optical instruments including repairs",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D29,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D29,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D29,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,49,"Information processing equipment including repairs",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D30,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D30,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D30,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,50,"Recording media: CDs, cassettes, films",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D31,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D31,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D31,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,"51a","Small equipment for sports, camping and open air recreation",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D32,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D32,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D32,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,"51b","Durable goods for indoor and outdoor recreation",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D33,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D33,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D33,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,"51c","Maintenance and repair for major durables for recreation, including musical instruments",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D34,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D34,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D34,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,52,"Games, toys and hobbies",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D35,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D35,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D35,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,53,"Gardens, plants and flowers",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D36,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D36,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D36,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,"Education"]
[null,null,"54a","Tuition and enrolment fees excluding capital assessment/surcharges",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D38,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D38,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D38,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,"54b","Board, lodgning and school meals",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D39,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D39,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D39,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,"54c","Books and supplies",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D40,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D40,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D40,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,"54d","Transportation",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D41,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D41,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D41,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,"54e","Nursery/kindegarten costs",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D42,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D42,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D42,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,"54f","Fees for extra-curricular activities, music and language (not mother tongue) classes",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D43,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D43,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D43,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,"Restaurants and Hotels"]
[null,null,55,"Hotels, motels and camping",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D45,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D45,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D45,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,"Miscellaneous Goods and Services"]
[null,null,56,"Electric appliances for personal care including repairs",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D47,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D47,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D47,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,"57a","Small jewellery, clocks and watches",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D48,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D48,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D48,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,"57b","Travel goods (suitcases, bags, etc.)",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D49,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D49,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D49,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,"57c","Other personal effects",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D50,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D50,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D50,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,58,"Financial and other services",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D51,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D51,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D51,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,"Other"]
[null,null,59,"Other expenditures (Yearly)",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D53,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D53,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D53,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,"Vehicles"]
[null,null,60,"Car (Net of Purchase/Sale)",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D55,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D55,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D55,'Data Table'!F:F,\"Outside\")","v":0},"USD"]
[null,null,61,"Other vehicles (Net of Purchase/Sale): motorcycles, bicycles, etc",{"$f":"SUMIFS('Data Table'!G:G,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D56,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,LocalCurrencyCode)","v":0},{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D56,'Data Table'!F:F,\"Inside\",'Data Table'!H:H,\"<>\"&LocalCurrencyCode)","v":0},"USD",{"$f":"SUMIFS('Data Table'!J:J,'Data Table'!D:D,'Yearly and Infrequent Expenses'!$D56,'Data Table'!F:F,\"Outside\")","v":0},"USD"]

{"sheet":"FX Rates","index":6,"n_rows":153,"n_cols":5,"rows_kept":153,"cut":false,"hidden":true,"merged":[]}
["ISO Code","15-Sep-2021 Data",null,"Duty Station",{"$f":"DSCountry","v":"Afghanistan"}]
["AFN",86.045000000000002,null,"Local Currency",{"$f":"VLOOKUP(DSCountry,CurrencyTable,3,FALSE)","v":"AFN"}]
["AED",3.673,null,"USDtoLocalMult",{"$f":"1/VLOOKUP($E$2,CurrentFXRates,2,FALSE)","v":1.1621825788831424E-2}]
["ALL",101.39]
["AMD",490.5]
["ANG",1.7669999999999999]
["AOA",643.12099999999998]
["ARS",97.710999999999999]
["AUD",1.357]
["AWG",1.79]
["AZN",1.6950000000000001]
["BAM",1.657]
["BBD",2]
["BDT",84.844999999999999]
["BGN",1.657]
["BHD",0.377]
["BIF",1968.932]
["BMD",1]
["BND",1.3420000000000001]
["BOB",6.8460000000000001]
["BRL",5.21]
["BSD",1]
["BTN",73.27]
["BWP",11.061999999999999]
["BYN",2.5070000000000001]
["BZD",2]
["CAD",1.2649999999999999]
["CDF",1968.345]
["CHF",0.92100000000000004]
["CLP",780]
["CNY",6.468]
["COP",3809]
["CRC",618.51]
["CUP",24]
["CVE",93.444999999999993]
["CZK",21.48]
["DJF",177]
["DKK",6.3019999999999996]
["DOP",56.777999999999999]
["DZD",134.77000000000001]
["EGP",15.651999999999999]
["ERN",15]
["ETB",45.332000000000001]
["EUR",0.84699999999999998]
["FJD",2.1]
["GBP",0.72299999999999998]
["GEL",3.1190000000000002]
["GHS",5.976]
["GMD",51.46]
["GNF",9719.9500000000007]
["GTQ",7.7249999999999996]
["GYD",208.2]
["HKD",7.7869999999999999]
["HNL",23.712]
["HRK",6.3520000000000003]
["HTG",95.546000000000006]
["HUF",296.2]
["IDR",14368]
["ILS",3.218]
["INR",73.27]
["IQD",1450]
["IRR",267982]
["ISK",126.99]
["JMD",150.75399999999999]
["JOD",0.70799999999999996]
["JPY",109.95]
["KES",109.72]
["KGS",84.4]
["KHR",4115]
["KMF",416.92200000000003]
["KPW",110]
["KRW",1166.3900000000001]
["KWD",0.30099999999999999]
["KYD",0.82]
["KZT",426.57]
["LAK",9590]
["LBP",1507.5]
["LKR",199.35]
["LRD",170.98099999999999]
["LSL",14.137]
["LYD",4.5359999999999996]
["MAD",8.8840000000000003]
["MDL",17.71]
["MGA",3842.05]
["MKD",51.941000000000003]
["MMK",1652]
["MNT",2835.42]
["MOP",8.0050000000000008]
["MRU",36.04]
["MUR",42.17]
["MVR",15]
["MWK",815]
["MXN",20.190000000000001]
["MYR",4.1529999999999996]
["MZN",63.1]
["NAD",14.137]
["NGN",411.33]
["NIO",34.984999999999999]
["NOK",8.6440000000000001]
["NPR",117.2189]
["NZD",1.4059999999999999]
["OMR",0.38400000000000001]
["PAB",1]
["PEN",4.08]
["PGK",3.5089999999999999]
["PHP",49.82]
["PKR",165.27]
["PLN",3.8740000000000001]
["PYG",6912]
["QAR",3.694]
["RON",4.1859999999999999]
["RSD",99.646000000000001]
["RUB",73.613]
["RWF",998.53]
["SAR",3.7509999999999999]
["SBD",7.9180000000000001]
["SCR",13.081]
["SDG",445]
["SEK",8.6229999999999993]
["SGD",1.3420000000000001]
["SHP",0.72299999999999998]
["SLL",10330]
["SOS",24300]
["SRD",21.1]
["SSP",411.79899999999998]
["STN",20.87]
["SYP",2500]
["SZL",14.137]
["THB",32.46]
["TJS",11.273]
["TMT",3.5]
["TND",2.782]
["TOP",2.1920000000000002]
["TRY",8.3770000000000007]
["TTD",6.7569999999999997]
["TZS",2310.5]
["UAH",26.75]
["UGX",3540.06]
["USD",1]
["UYU",42.371000000000002]
["UZS",10620]
["VES",4147300.52]
["VND",22755]
["VUV",108.91]
["WST",2.5529999999999999]
["XAF",555.89599999999996]
["XCD",2.7]
["XOF",555.89599999999996]
["XPF",101.129]
["YER",581.03]
["ZAR",14.137]
["ZMW",15.87]
["ZWL",83.8]

{"sheet":"Reference","index":7,"n_rows":180,"n_cols":47,"rows_kept":180,"cut":false,"hidden":true,"merged":[]}
[1,"January",null,"Afghanistan",null,"Afghanistan","Afghanistan Afghani","AFN","AFN: Afghanistan Afghani",null,"Inside",null,1,"Alcoholic Beverages and Tobacco","Alcoholic Beverages and Tobacco",null,1,"Alcohol and Tobacco","Clothing and Footwear","Communication","Education","Food and Non-Alcoholic Beverages","Furniture, Household Equipment and Home Maintenance","Health","Housing Expenditures","Miscellaneous Goods and Services","Other","Recreation and Culture","Restaurants and Hotels","Transport Purchases","Vehicles",null,1,"AFN",1,null,"Airlines","Transport Purchases","Y",null,"DATE","ITEM CATEGORY","ITEM SUBCATEGORY","ITEM DESCRIPTION","Inside/Outside\nDuty Station","AMOUNT","CURRENCY"]
[2,"February",null,"Albania",null,"Albania","Albania Lek","ALL","ALL: Albania Lek",null,"Outside",null,2,"Clothing and Footwear","Clothing and Footwear",null,2,"Alcoholic beverages","Boys and girls clothing","Postal services","Board, lodging and school meals","Food purchased in supermarkets, stores, markets","Disposable household goods","Medical, dental and paramedical services","Housing expenditures","Cosmetics and other goods for personal care","Other expenditures (Monthly)","Audio-visual equipment including repairs","Hotels, motels and camping","Airlines","Car (Net of Purchase/Sale)",null,2,"AED",2,null,"Alcoholic beverages","Alcohol and Tobacco","M"]
[3,"March",null,"Algeria",null,"Algeria","Algerian Dinar","DZD","DZD: Algerian Dinar",null,null,null,3,"Communication","Communication",null,3,"Tobacco and tobacco products","Clothing accessories and materials","Telecommunication equipment","Books and supplies","Non-alcoholic beverages","Furniture, furnishings, carpets and floor coverings","Non-prescription drugs and vitamins",null,"Electric appliances for personal care including repairs","Other expenditures (Yearly)","Books, newspapers and periodicals","Meals and beverages purchased in staff restaurants, cafeteria","Car insurance","Other vehicles (Net of Purchase/Sale): motorcycles, bicycles, etc",null,3,"ALL",3,null,"Audio-visual equipment including repairs","Recreation and Culture","Y"]
[4,"April",null,"Angola",null,"Angola","Angolan Kwanza","AOA","AOA: Angolan Kwanza",null,null,null,4,"Education","Education",null,4,null,"Footwear","Telecommunication services","Fees for extra-curricular activities, music and language (not mother tongue) classes",null,"Glassware, tableware and household utensils","Prescription drugs",null,"Financial and other services","Remittances except medical and educational expenses","Cinemas, theaters, concerts and other related activities","Meals and beverages purchased in commercial restaurants and cafes","Fuels and lubricants for personal transport",null,null,4,"AMD",4,null,"Board, lodging and school meals","Education","Y"]
[5,"May",null,"Argentina",null,"Argentina","Argentine Peso","ARS","ARS: Argentine Peso",null,null,null,5,"Food and Non-Alcoholic Beverages","Food and Non-Alcoholic Beverages",null,5,null,"Men's clothing",null,"Nursery/kindegarten costs",null,"Households textiles, including repair","Supplemental health insurance",null,"Hairdressing salons and personal grooming establishments",null,"Durable goods for indoor and outdoor recreation",null,"Local transport services",null,null,5,"ANG",5,null,"Books and supplies","Education","Y"]
[6,"June",null,"Armenia",null,"Armenia","Armenian Dram","AMD","AMD: Armenian Dram",null,null,null,6,"Furniture, Household Equipment and Home Maintenance","Furniture, Household Equipment and Routine Maintenance of the House",null,6,null,"Repair and cleaning of clothing",null,"Transportation",null,"Small electric household appliances","Therapeutic appliances and equipment, other medical supplies",null,"Other personal effects",null,"Film developing and print processing",null,"Long distance transport",null,null,6,"AOA",6,null,"Books, newspapers and periodicals","Recreation and Culture","M"]
[7,"July",null,"Australia",null,"Australia","Australian Dollar","AUD","AUD: Australian Dollar",null,null,null,7,"Health","Health",null,7,null,"Repair of footwear",null,"Tuition and enrolment fees excluding capital assessment/surcharges",null,"Tools, equipment and other non-durable household goods",null,null,"Small jewellery, clocks and watches",null,"Games, toys and hobbies",null,"Maintenance and repair of personal transport",null,null,7,"ARS",7,null,"Boys and girls clothing","Clothing and Footwear","Y"]
[8,"August",null,"Austria",null,"Austria","Euro","EUR","EUR: Euro",null,null,null,8,"Housing Expenditures","Housing Expenditures",null,8,null,"Women's clothing",null,null,null,null,null,null,"Travel goods (suitcases, bags, etc.)",null,"Gardens, plants and flowers",null,"Other services in respect of personal and public transport",null,null,8,"AUD",8,null,"Car (Net of Purchase/Sale)","Vehicles","5Y"]
[9,"September",null,"Azerbaijan",null,"Azerbaijan","Azerbaijan Manat","AZN","AZN: Azerbaijan Manat",null,null,null,9,"Miscellaneous Goods and Services","Miscellaneous Goods and Services",null,9,null,null,null,null,null,null,null,null,null,null,"Information processing equipment including repairs",null,"Spare parts and accessories for personal transport",null,null,9,"AWG",9,null,"Car insurance","Transport Purchases","M"]
[10,"October",null,"Bahamas",null,"Bahamas","Bahamian Dollar","BSD","BSD: Bahamian Dollar",null,null,null,10,"Other","Other",null,10,null,null,null,null,null,null,null,null,null,null,"Maintenance and repair for major durables for recreation, including musical instruments",null,"Taxi",null,null,10,"AZN",10,null,"Cinemas, theaters, concerts and other related activities","Recreation and Culture","M"]
[11,"November",null,"Bahrain",null,"Bahrain","Bahraini Dinar","BHD","BHD: Bahraini Dinar",null,null,null,11,"Recreation and Culture","Recreation and Culture",null,11,null,null,null,null,null,null,null,null,null,null,"Pets and related products and services",null,null,null,null,11,"BAM",11,null,"Clothing accessories and materials","Clothing and Footwear","Y"]
[12,"December",null,"Bangladesh",null,"Bangladesh","Bangladesh Taka","BDT","BDT: Bangladesh Taka",null,null,null,12,"Restaurants and Hotels","Restaurants and Hotels",null,12,null,null,null,null,null,null,null,null,null,null,"Photographic equipment and optical instruments including repairs",null,null,null,null,12,"BBD",12,null,"Cosmetics and other goods for personal care","Miscellaneous Goods and Services","M"]
[null,null,null,"Barbados",null,"Barbados","Barbados Dollar","BBD","BBD: Barbados Dollar",null,null,null,13,"Transport Purchases","Transport Purchases",null,13,null,null,null,null,null,null,null,null,null,null,"Recording media: CDs, cassettes, films",null,null,null,null,13,"BDT",13,null,"Disposable household goods","Furniture, Household Equipment and Home Maintenance","M"]
[null,null,null,"Belarus",null,"Belarus","New Belarusian Ruble","BYN","BYN: New Belarusian Ruble",null,null,null,14,"Vehicles","Personal Transport Purchases",null,14,null,null,null,null,null,null,null,null,null,null,"Small equipment for sports, camping and open air recreation",null,null,null,null,14,"BGN",14,null,"Durable goods for indoor and outdoor recreation","Recreation and Culture","Y"]
[null,null,null,"Belgium",null,"Belgium","Euro","EUR","EUR: Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sporting events and related activities",null,null,null,null,15,"BHD",15,null,"Electric appliances for personal care including repairs","Miscellaneous Goods and Services","Y"]
[null,null,null,"Belize",null,"Belize","Belize Dollar","BZD","BZD: Belize Dollar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stationery and drawing materials",null,null,null,null,16,"BIF",16,null,"Fees for extra-curricular activities, music and language (not mother tongue) classes","Education","Y"]
[null,null,null,"Benin",null,"Benin","CFA Franc","XOF","XOF: CFA Franc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"BMD",17,null,"Film developing and print processing","Recreation and Culture","M"]
[null,null,null,"Bhutan",null,"Bhutan","Bhutan Ngultrum","BTN","BTN: Bhutan Ngultrum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"BND",18,null,"Financial and other services","Miscellaneous Goods and Services","Y"]
[null,null,null,"Bolivia",null,"Bolivia","Bolivia Boliviano","BOB","BOB: Bolivia Boliviano",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"BOB",19,null,"Food purchased in supermarkets, stores, markets","Food and Non-Alcoholic Beverages","M"]
[null,null,null,"Bosnia and Herzegovina",null,"Bosnia and Herzegovina","Convertible Mark","BAM","BAM: Convertible Mark",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"BRL",20,null,"Footwear","Clothing and Footwear","Y"]
[null,null,null,"Botswana",null,"Botswana","Botswana Pula","BWP","BWP: Botswana Pula",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"BSD",21,null,"Fuels and lubricants for personal transport","Transport Purchases","M"]
[null,null,null,"Brazil",null,"Brazil","Brazilian Real","BRL","BRL: Brazilian Real",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,"BTN",22,null,"Furniture, furnishings, carpets and floor coverings","Furniture, Household Equipment and Home Maintenance","Y"]
[null,null,null,"Bulgaria",null,"Bulgaria","Bulgarian Lev","BGN","BGN: Bulgarian Lev",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"BWP",23,null,"Games, toys and hobbies","Recreation and Culture","Y"]
[null,null,null,"Burkina Faso",null,"Burkina Faso","CFA Franc","XOF","XOF: CFA Franc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,"BYN",24,null,"Gardens, plants and flowers","Recreation and Culture","Y"]
[null,null,null,"Burundi",null,"Burundi","Burundi Franc","BIF","BIF: Burundi Franc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,"BZD",25,null,"Glassware, tableware and household utensils","Furniture, Household Equipment and Home Maintenance","Y"]
[null,null,null,"Cambodia",null,"Cambodia","Cambodian Riel","KHR","KHR: Cambodian Riel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,"CAD",26,null,"Hairdressing salons and personal grooming establishments","Miscellaneous Goods and Services","M"]
[null,null,null,"Cameroon",null,"Cameroon","CFA Franc","XAF","XAF: CFA Franc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,"CDF",27,null,"Hotels, motels and camping","Restaurants and Hotels","Y"]
[null,null,null,"Canada",null,"Canada","Canadian Dollar","CAD","CAD: Canadian Dollar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,"CHF",28,null,"Households textiles, including repair","Furniture, Household Equipment and Home Maintenance","Y"]
[null,null,null,"Cape Verde",null,"Cape Verde","Cape Verde Escudo","CVE","CVE: Cape Verde Escudo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,"CLP",29,null,"Housing expenditures","Housing Expenditures","M"]
[null,null,null,"Central African Republic",null,"Central African Republic","CFA Franc","XAF","XAF: CFA Franc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,"CNY",30,null,"Information processing equipment including repairs","Recreation and Culture","Y"]
[null,null,null,"Chad",null,"Chad","CFA Franc","XAF","XAF: CFA Franc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,"COP",31,null,"Local transport services","Transport Purchases","M"]
[null,null,null,"Chile",null,"Chile","Chilean Peso","CLP","CLP: Chilean Peso",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,"CRC",32,null,"Long distance transport","Transport Purchases","Y"]
[null,null,null,"China, Beijing",null,"China, Beijing","Chinese Renminbi","CNY","CNY: Chinese Renminbi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,"CUP",33,null,"Maintenance and repair for major durables for recreation, including musical instruments","Recreation and Culture","Y"]
[null,null,null,"China, Hong Kong",null,"China, Hong Kong","Hong Kong Dollar","HKD","HKD: Hong Kong Dollar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,"CVE",34,null,"Maintenance and repair of personal transport","Transport Purchases","Y"]
[null,null,null,"China, Macau",null,"China, Macau","Macao Pataca","MOP","MOP: Macao Pataca",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,"CZK",35,null,"Meals and beverages purchased in commercial restaurants and cafes","Restaurants and Hotels","M"]
[null,null,null,"Colombia",null,"Colombia","Colombian Peso","COP","COP: Colombian Peso",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,"DJF",36,null,"Meals and beverages purchased in staff restaurants, cafeteria","Restaurants and Hotels","M"]
[null,null,null,"Comoros",null,"Comoros","Comorian Franc","KMF","KMF: Comorian Franc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,"DKK",37,null,"Medical, dental and paramedical services","Health","Y"]
[null,null,null,"Congo",null,"Congo","CFA Franc","XAF","XAF: CFA Franc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,"DOP",38,null,"Men's clothing","Clothing and Footwear","Y"]
[null,null,null,"Congo, Dem. Rep.",null,"Congo, Dem. Rep.","Congo Franc, Dem. Rep. of","CDF","CDF: Congo Franc, Dem. Rep. of",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,"DZD",39,null,"Non-alcoholic beverages","Food and Non-Alcoholic Beverages","M"]
[null,null,null,"Costa Rica",null,"Costa Rica","Costa Rican Colón","CRC","CRC: Costa Rican Colón",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,"EGP",40,null,"Non-prescription drugs and vitamins","Health","M"]
[null,null,null,"Cote d'Ivoire",null,"Cote d'Ivoire","CFA Franc","XOF","XOF: CFA Franc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,"ERN",41,null,"Nursery/kindegarten costs","Education","Y"]
[null,null,null,"Croatia",null,"Croatia","Croatia Kuna","HRK","HRK: Croatia Kuna",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,"ETB",42,null,"Other expenditures (Monthly)","Other","M"]
[null,null,null,"Cuba",null,"Cuba","Cuban Peso","CUP","CUP: Cuban Peso",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,"EUR",43,null,"Other expenditures (Yearly)","Other","Y"]
[null,null,null,"Cyprus",null,"Cyprus","Euro","EUR","EUR: Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,"FJD",44,null,"Other personal effects","Miscellaneous Goods and Services","Y"]
[null,null,null,"Czech Republic",null,"Czech Republic","Czech Koruna","CZK","CZK: Czech Koruna",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,"GBP",45,null,"Other services in respect of personal and public transport","Transport Purchases","Y"]
[null,null,null,"Denmark",null,"Denmark","Danish Krone","DKK","DKK: Danish Krone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,"GEL",46,null,"Other vehicles (Net of Purchase/Sale): motorcycles, bicycles, etc","Vehicles","5Y"]
[null,null,null,"Djibouti",null,"Djibouti","Djibouti Francs","DJF","DJF: Djibouti Francs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,"GHS",47,null,"Pets and related products and services","Recreation and Culture","M"]
[null,null,null,"Dominican Republic",null,"Dominican Republic","Dominican Peso","DOP","DOP: Dominican Peso",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,"GMD",48,null,"Photographic equipment and optical instruments including repairs","Recreation and Culture","Y"]
[null,null,null,"Ecuador",null,"Ecuador","US Dollar","USD","USD: US Dollar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,"GNF",49,null,"Postal services","Communication","M"]
[null,null,null,"Egypt",null,"Egypt","Egyptian Pound","EGP","EGP: Egyptian Pound",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,"GTQ",50,null,"Prescription drugs","Health","M"]
[null,null,null,"El Salvador",null,"El Salvador","US Dollar","USD","USD: US Dollar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,"GYD",51,null,"Recording media: CDs, cassettes, films","Recreation and Culture","Y"]
[null,null,null,"Equatorial Guinea",null,"Equatorial Guinea","CFA Franc","XAF","XAF: CFA Franc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,"HKD",52,null,"Remittances except medical and educational expenses","Other","M"]
[null,null,null,"Eritrea",null,"Eritrea","Eritrea Nakfa","ERN","ERN: Eritrea Nakfa",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,"HNL",53,null,"Repair and cleaning of clothing","Clothing and Footwear","M"]
[null,null,null,"Estonia",null,"Estonia","Euro","EUR","EUR: Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,"HRK",54,null,"Repair of footwear","Clothing and Footwear","M"]
[null,null,null,"Eswatini, Kingdom of",null,"Eswatini, Kingdom of","Swazi Lilangeni","SZL","SZL: Swazi Lilangeni",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,"HTG",55,null,"Small electric household appliances","Furniture, Household Equipment and Home Maintenance","Y"]
[null,null,null,"Ethiopia",null,"Ethiopia","Ethiopian Birr","ETB","ETB: Ethiopian Birr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,"HUF",56,null,"Small equipment for sports, camping and open air recreation","Recreation and Culture","Y"]
[null,null,null,"Fiji",null,"Fiji","Fiji Dollar","FJD","FJD: Fiji Dollar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,"IDR",57,null,"Small jewellery, clocks and watches","Miscellaneous Goods and Services","Y"]
[null,null,null,"Finland",null,"Finland","Euro","EUR","EUR: Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,"ILS",58,null,"Spare parts and accessories for personal transport","Transport Purchases","Y"]
[null,null,null,"France",null,"France","Euro","EUR","EUR: Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,"INR",59,null,"Sporting events and related activities","Recreation and Culture","M"]
[null,null,null,"Gabon",null,"Gabon","CFA Franc","XAF","XAF: CFA Franc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,"IQD",60,null,"Stationery and drawing materials","Recreation and Culture","M"]
[null,null,null,"Gambia",null,"Gambia","Gambian Dalasi","GMD","GMD: Gambian Dalasi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,"IRR",61,null,"Supplemental health insurance","Health","M"]
[null,null,null,"Georgia",null,"Georgia","Georgian Lari","GEL","GEL: Georgian Lari",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,"ISK",62,null,"Taxi","Transport Purchases","M"]
[null,null,null,"Germany",null,"Germany","Euro","EUR","EUR: Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,"JMD",63,null,"Telecommunication equipment","Communication","Y"]
[null,null,null,"Ghana",null,"Ghana","Ghana Cedi","GHS","GHS: Ghana Cedi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64,"JOD",64,null,"Telecommunication services","Communication","M"]
[null,null,null,"Greece",null,"Greece","Euro","EUR","EUR: Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,"JPY",65,null,"Therapeutic appliances and equipment, other medical supplies","Health","Y"]
[null,null,null,"Guatemala",null,"Guatemala","Guatemala Quetzal","GTQ","GTQ: Guatemala Quetzal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,"KES",66,null,"Tobacco and tobacco products","Alcohol and Tobacco","M"]
[null,null,null,"Guinea",null,"Guinea","Guinean Franc","GNF","GNF: Guinean Franc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,"KGS",67,null,"Tools, equipment and other non-durable household goods","Furniture, Household Equipment and Home Maintenance","Y"]
[null,null,null,"Guinea Bissau",null,"Guinea Bissau","CFA Franc","XOF","XOF: CFA Franc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68,"KHR",68,null,"Transportation","Education","Y"]
[null,null,null,"Guyana",null,"Guyana","Guyana Dollar","GYD","GYD: Guyana Dollar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,"KMF",69,null,"Travel goods (suitcases, bags, etc.)","Miscellaneous Goods and Services","Y"]
[null,null,null,"Haiti",null,"Haiti","Haiti Gourde","HTG","HTG: Haiti Gourde",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,"KPW",70,null,"Tuition and enrolment fees excluding capital assessment/surcharges","Education","Y"]
[null,null,null,"Honduras",null,"Honduras","Honduras Lempira","HNL","HNL: Honduras Lempira",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,71,"KRW",71,null,"Women's clothing","Clothing and Footwear","Y"]
[null,null,null,"Hungary",null,"Hungary","Hungary Forint","HUF","HUF: Hungary Forint",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72,"KWD",72]
[null,null,null,"India",null,"India","Indian Rupee","INR","INR: Indian Rupee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73,"KYD",73]
[null,null,null,"Indonesia",null,"Indonesia","Indonesia Rupiah","IDR","IDR: Indonesia Rupiah",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74,"KZT",74]
[null,null,null,"Iran",null,"Iran","Iranian Rial","IRR","IRR: Iranian Rial",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,"LAK",75]
[null,null,null,"Iraq",null,"Iraq","Iraqi Dinar","IQD","IQD: Iraqi Dinar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,76,"LBP",76]
[null,null,null,"Ireland",null,"Ireland","Euro","EUR","EUR: Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77,"LKR",77]
[null,null,null,"Italy",null,"Italy","Euro","EUR","EUR: Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78,"LRD",78]
[null,null,null,"Jamaica",null,"Jamaica","Jamaican Dollar","JMD","JMD: Jamaican Dollar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79,"LSL",79]
[null,null,null,"Japan",null,"Japan","Japanese Yen","JPY","JPY: Japanese Yen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,"LYD",80]
[null,null,null,"Jerusalem",null,"Jerusalem","Israeli Shekel","ILS","ILS: Israeli Shekel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81,"MAD",81]
[null,null,null,"Jordan",null,"Jordan","Jordanian Dinar","JOD","JOD: Jordanian Dinar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82,"MDL",82]
[null,null,null,"Kazakhstan",null,"Kazakhstan","Kazakhstan Tenge","KZT","KZT: Kazakhstan Tenge",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83,"MGA",83]
[null,null,null,"Kenya",null,"Kenya","Kenyan Shilling","KES","KES: Kenyan Shilling",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84,"MKD",84]
[null,null,null,"Kiribati",null,"Kiribati","Australian Dollar","AUD","AUD: Australian Dollar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85,"MMK",85]
[null,null,null,"Korea, Dem. Peo. of",null,"Korea, Dem. Peo. of","D.P.R of Korea Won","KPW","KPW: D.P.R of Korea Won",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,86,"MNT",86]
[null,null,null,"Korea, Republic of",null,"Korea, Republic of","Rep. of Korea Won","KRW","KRW: Rep. of Korea Won",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,87,"MOP",87]
[null,null,null,"Kuwait",null,"Kuwait","Kuwaiti Dinar","KWD","KWD: Kuwaiti Dinar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,88,"MRU",88]
[null,null,null,"Kyrgyzstan",null,"Kyrgyzstan","Kyrgyzstan Som","KGS","KGS: Kyrgyzstan Som",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89,"MUR",89]
[null,null,null,"Lao Peo. Dem. Rep.",null,"Lao Peo. Dem. Rep.","Laos Kip","LAK","LAK: Laos Kip",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,"MVR",90]
[null,null,null,"Latvia",null,"Latvia","Euro","EUR","EUR: Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,91,"MWK",91]
[null,null,null,"Lebanon",null,"Lebanon","Lebanese Pound","LBP","LBP: Lebanese Pound",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,92,"MXN",92]
[null,null,null,"Lesotho",null,"Lesotho","Lesotho Loti","LSL","LSL: Lesotho Loti",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93,"MYR",93]
[null,null,null,"Liberia",null,"Liberia","Liberian Dollar","LRD","LRD: Liberian Dollar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94,"MZN",94]
[null,null,null,"Libyan Arab Jamahiriya",null,"Libyan Arab Jamahiriya","Libyan Dinar","LYD","LYD: Libyan Dinar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95,"NAD",95]
[null,null,null,"Lithuania",null,"Lithuania","Euro","EUR","EUR: Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,96,"NGN",96]
[null,null,null,"Madagascar",null,"Madagascar","Malagasy Ariary","MGA","MGA: Malagasy Ariary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97,"NIO",97]
[null,null,null,"Malawi",null,"Malawi","Malawi Kwacha","MWK","MWK: Malawi Kwacha",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98,"NOK",98]
[null,null,null,"Malaysia",null,"Malaysia","Malaysia Ringgit","MYR","MYR: Malaysia Ringgit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99,"NPR",99]
[null,null,null,"Maldives",null,"Maldives","Maldives Rufiyaa","MVR","MVR: Maldives Rufiyaa",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,"NZD",100]
[null,null,null,"Mali",null,"Mali","CFA Franc","XOF","XOF: CFA Franc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,101,"OMR",101]
[null,null,null,"Malta",null,"Malta","Euro","EUR","EUR: Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,102,"PAB",102]
[null,null,null,"Mauritania",null,"Mauritania","Mauritania Ouguiya","MRU","MRU: Mauritania Ouguiya",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,103,"PEN",103]
[null,null,null,"Mauritius",null,"Mauritius","Mauritius Rupee","MUR","MUR: Mauritius Rupee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,104,"PGK",104]
[null,null,null,"Mexico",null,"Mexico","Mexican Peso","MXN","MXN: Mexican Peso",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,105,"PHP",105]
[null,null,null,"Moldova",null,"Moldova","Moldovan Leu","MDL","MDL: Moldovan Leu",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,106,"PKR",106]
[null,null,null,"Mongolia",null,"Mongolia","Mongolia Tugrik","MNT","MNT: Mongolia Tugrik",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,107,"PLN",107]
[null,null,null,"Montenegro",null,"Montenegro","Euro","EUR","EUR: Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,108,"PYG",108]
[null,null,null,"Morocco",null,"Morocco","Moroccan Dirham","MAD","MAD: Moroccan Dirham",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,"QAR",109]
[null,null,null,"Mozambique",null,"Mozambique","Mozambique Metical","MZN","MZN: Mozambique Metical",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110,"RON",110]
[null,null,null,"Myanmar",null,"Myanmar","Myanmar Kyat","MMK","MMK: Myanmar Kyat",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,111,"RSD",111]
[null,null,null,"Namibia",null,"Namibia","Namibian Dollar","NAD","NAD: Namibian Dollar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,112,"RUB",112]
[null,null,null,"Nepal",null,"Nepal","Nepalese Rupee","NPR","NPR: Nepalese Rupee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,113,"RWF",113]
[null,null,null,"Netherlands",null,"Netherlands","Euro","EUR","EUR: Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,114,"SAR",114]
[null,null,null,"New Caledonia",null,"New Caledonia","CFA Franc","XPF","XPF: CFA Franc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,115,"SBD",115]
[null,null,null,"New Zealand",null,"New Zealand","New Zealand Dollar","NZD","NZD: New Zealand Dollar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,116,"SCR",116]
[null,null,null,"Nicaragua",null,"Nicaragua","Nicaragua Cordoba Oro","NIO","NIO: Nicaragua Cordoba Oro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,117,"SDG",117]
[null,null,null,"Niger",null,"Niger","CFA Franc","XOF","XOF: CFA Franc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,118,"SEK",118]
[null,null,null,"Nigeria",null,"Nigeria","Nigeria Naira","NGN","NGN: Nigeria Naira",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,119,"SGD",119]
[null,null,null,"North Macedonia, Rep. of",null,"North Macedonia, Rep. of","North Madeonia Denar","MKD","MKD: North Madeonia Denar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,"SHP",120]
[null,null,null,"Norway",null,"Norway","Norwegian Krone","NOK","NOK: Norwegian Krone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,121,"SLL",121]
[null,null,null,"Oman",null,"Oman","Oman Rial","OMR","OMR: Oman Rial",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,122,"SOS",122]
[null,null,null,"Other",null,"Other","US dollar","USD","USD: US dollar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,123,"SRD",123]
[null,null,null,"Pakistan",null,"Pakistan","Pakistani Rupee","PKR","PKR: Pakistani Rupee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,124,"SSP",124]
[null,null,null,"Panama",null,"Panama","Panama Balboa","PAB","PAB: Panama Balboa",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,125,"STN",125]
[null,null,null,"Papua New Guinea",null,"Papua New Guinea","Papua New Guinea Kina","PGK","PGK: Papua New Guinea Kina",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,126,"SYP",126]
[null,null,null,"Paraguay",null,"Paraguay","Paraguay Guarani","PYG","PYG: Paraguay Guarani",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,127,"SZL",127]
[null,null,null,"Peru",null,"Peru","Peru Nuevo Sol","PEN","PEN: Peru Nuevo Sol",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128,"THB",128]
[null,null,null,"Philippines",null,"Philippines","Philippine Peso","PHP","PHP: Philippine Peso",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129,"TJS",129]
[null,null,null,"Poland",null,"Poland","Poland Zloty","PLN","PLN: Poland Zloty",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,"TMT",130]
[null,null,null,"Portugal",null,"Portugal","Euro","EUR","EUR: Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,131,"TND",131]
[null,null,null,"Qatar",null,"Qatar","Qatari Rial","QAR","QAR: Qatari Rial",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,"TOP",132]
[null,null,null,"Romania",null,"Romania","Romanian Leu","RON","RON: Romanian Leu",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,133,"TRY",133]
[null,null,null,"Russian Federation",null,"Russian Federation","Russian Rouble","RUB","RUB: Russian Rouble",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,134,"TTD",134]
[null,null,null,"Rwanda",null,"Rwanda","Rwanda Franc","RWF","RWF: Rwanda Franc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,135,"TZS",135]
[null,null,null,"Saint Lucia",null,"Saint Lucia","E.C. Dollar","XCD","XCD: E.C. Dollar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,136,"UAH",136]
[null,null,null,"Samoa",null,"Samoa","Samoa Tala","WST","WST: Samoa Tala",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,137,"UGX",137]
[null,null,null,"Sao Tome and Principe",null,"Sao Tome and Principe","Sao Tome and Principe Dobra","STN","STN: Sao Tome and Principe Dobra",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,138,"USD",138]
[null,null,null,"Saudi Arabia",null,"Saudi Arabia","Saudi Riyal","SAR","SAR: Saudi Riyal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,139,"UYU",139]
[null,null,null,"Senegal",null,"Senegal","CFA Franc","XOF","XOF: CFA Franc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,140,"UZS",140]
[null,null,null,"Serbia",null,"Serbia","Serbian Dinar","RSD","RSD: Serbian Dinar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,141,"VES",141]
[null,null,null,"Seychelles",null,"Seychelles","Seychelles Rupee","SCR","SCR: Seychelles Rupee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,142,"VND",142]
[null,null,null,"Sierra Leone",null,"Sierra Leone","Sierra Leone Leone","SLL","SLL: Sierra Leone Leone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,143,"VUV",143]
[null,null,null,"Singapore",null,"Singapore","Singapore Dollar","SGD","SGD: Singapore Dollar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,144,"WST",144]
[null,null,null,"Slovakia",null,"Slovakia","Euro","EUR","EUR: Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,145,"XAF",145]
[null,null,null,"Slovenia",null,"Slovenia","Euro","EUR","EUR: Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,146,"XCD",146]
[null,null,null,"Solomon Islands",null,"Solomon Islands","Solomon Islands Dollar","SBD","SBD: Solomon Islands Dollar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,147,"XOF",147]
[null,null,null,"Somalia",null,"Somalia","Somali Shilling","SOS","SOS: Somali Shilling",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,148,"XPF",148]
[null,null,null,"South Africa",null,"South Africa","South Africa Rand","ZAR","ZAR: South Africa Rand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,149,"YER",149]
[null,null,null,"South Sudan",null,"South Sudan","South Sudanese Pound","SSP","SSP: South Sudanese Pound",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,"ZAR",150]
[null,null,null,"Spain",null,"Spain","Euro","EUR","EUR: Euro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,151,"ZMW",151]
[null,null,null,"Sri Lanka",null,"Sri Lanka","Sri Lanka Rupee","LKR","LKR: Sri Lanka Rupee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152,"ZWR",152]
[null,null,null,"Sudan",null,"Sudan","Sudanese Pound","SDG","SDG: Sudanese Pound"]
[null,null,null,"Suriname",null,"Suriname","Surinamese Dollar","SRD","SRD: Surinamese Dollar"]
[null,null,null,"Sweden",null,"Sweden","Swedish Krona","SEK","SEK: Swedish Krona"]
[null,null,null,"Switzerland",null,"Switzerland","Swiss Franc","CHF","CHF: Swiss Franc"]
[null,null,null,"Syrian Arab Republic",null,"Syrian Arab Republic","Syrian Pound","SYP","SYP: Syrian Pound"]
[null,null,null,"Tajikistan",null,"Tajikistan","Tajikistan Somoni","TJS","TJS: Tajikistan Somoni"]
[null,null,null,"Tanzania, United Rep. of",null,"Tanzania, United Rep. of","Tanzanian Shilling","TZS","TZS: Tanzanian Shilling"]
[null,null,null,"Thailand",null,"Thailand","Thai Baht","THB","THB: Thai Baht"]
[null,null,null,"Timor-Leste",null,"Timor-Leste","US Dollar","USD","USD: US Dollar"]
[null,null,null,"Togo",null,"Togo","CFA Franc","XOF","XOF: CFA Franc"]
[null,null,null,"Tonga",null,"Tonga","Tonga Pa'anga","TOP","TOP: Tonga Pa'anga"]
[null,null,null,"Trinidad and Tobago",null,"Trinidad and Tobago","Trinidad and Tobago Dollar","TTD","TTD: Trinidad and Tobago Dollar"]
[null,null,null,"Tunisia",null,"Tunisia","Tunisian Dinar","TND","TND: Tunisian Dinar"]
[null,null,null,"Turkey",null,"Turkey","Turkish Lira","TRY","TRY: Turkish Lira"]
[null,null,null,"Turkmenistan",null,"Turkmenistan","Turkmen Manat","TMT","TMT: Turkmen Manat"]
[null,null,null,"Uganda",null,"Uganda","Uganda Shilling","UGX","UGX: Uganda Shilling"]
[null,null,null,"Ukraine",null,"Ukraine","Ukraine Hryvnia","UAH","UAH: Ukraine Hryvnia"]
[null,null,null,"United Arab Emirates",null,"United Arab Emirates","United Arab Emirates Dirham","AED","AED: United Arab Emirates Dirham"]
[null,null,null,"United Kingdom",null,"United Kingdom","United Kingdom Pound","GBP","GBP: United Kingdom Pound"]
[null,null,null,"Uruguay",null,"Uruguay","Uruguay Peso","UYU","UYU: Uruguay Peso"]
[null,null,null,"USA",null,"USA","US dollar","USD","USD: US dollar"]
[null,null,null,"Uzbekistan",null,"Uzbekistan","Uzbekistan Sum","UZS","UZS: Uzbekistan Sum"]
[null,null,null,"Vanuatu",null,"Vanuatu","Vanuatu Vatu","VUV","VUV: Vanuatu Vatu"]
[null,null,null,"Venezuela",null,"Venezuela","Venezuela Bolivar Sobérano","VES","VES: Venezuela Bolivar Sobérano"]
[null,null,null,"Vietnam",null,"Vietnam","Viet Nam Dong","VND","VND: Viet Nam Dong"]
[null,null,null,"Yemen, Republic of",null,"Yemen, Republic of","Yemini Rial","YER","YER: Yemini Rial"]
[null,null,null,"Zambia",null,"Zambia","Zambia Kwacha","ZMW","ZMW: Zambia Kwacha"]
[null,null,null,"Zimbabwe",null,"Zimbabwe","Zimbabwe Dollar","ZWL","ZWL: Zimbabwe Dollar"]

{"sheet":"Temp","index":8,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["First Day of Record",{"$f":"MIN('Data Table'!B:B)","v":"00:00:00"}]
["Last Day of Record",{"$f":"MAX('Data Table'!B:B)","v":"00:00:00"}]
["Record Span in Days",{"$f":"RecordEnd+1-RecordStart","v":1}]
["Monthly Multiplier",{"$f":"365.25/(12*RecordSpan)","v":30.4375}]
["Yearly Multiplier",{"$f":"365.25/RecordSpan","v":365.25}]
["1: Pro-rate; 2: Sum",2]