{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Timetable","Budget","Example","ExchRate","data","model","ERdata"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":11,"comments":1,"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":"Timetable","index":0,"n_rows":20,"n_cols":38,"rows_kept":20,"cut":false,"hidden":false,"merged":[[3,0,3,1],[4,2,4,13],[4,14,4,25],[4,26,4,37]]}
[null,"State:","BELARUS"]
[null,"File number:"]
[null,"Title:","Spring rire of 'Yurauski Karahod'"]
["Go to budget"]
[null,null,"Year 1: ",null,null,null,null,null,null,null,null,null,null,null,"Year 2: ",null,null,null,null,null,null,null,null,null,null,null,"Year 3: "]
["#","Activities",1,2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12]
[]
[{"$f":"IF(B8=\"\",\"\",COUNTA(B$8:B20)-(COUNTA(B8:B20)-1))","v":1},"Management and coordination system "]
[{"$f":"IF(B9=\"\",\"\",COUNTA(B$8:B21)-(COUNTA(B9:B21)-1))","v":2},"Start-up and final meetings"]
[{"$f":"IF(B10=\"\",\"\",COUNTA(B$8:B22)-(COUNTA(B10:B22)-1))","v":3},"Mapping  and inventorying of ICH in Turau area"]
[{"$f":"IF(B11=\"\",\"\",COUNTA(B$8:B23)-(COUNTA(B11:B23)-1))","v":4},"Elaboration and publication of ICH Anthology of Turau area"]
[{"$f":"IF(B12=\"\",\"\",COUNTA(B$8:B24)-(COUNTA(B12:B24)-1))","v":5},"Developing a safeguarding and revitalizatiion strategy of the Jurauski Karahod element"]
[{"$f":"IF(B13=\"\",\"\",COUNTA(B$8:B25)-(COUNTA(B13:B25)-1))","v":6},"Running the ICH festival in Pahost villahe"]
[{"$f":"IF(B14=\"\",\"\",COUNTA(B$8:B26)-(COUNTA(B14:B26)-1))","v":7},"The dissemination of information by media and social networks"]
[{"$f":"IF(B15=\"\",\"\",COUNTA(B$8:B27)-(COUNTA(B15:B27)-1))","v":8},"Student's Folklore Summer School"]
[{"$f":"IF(B16=\"\",\"\",COUNTA(B$8:B28)-(COUNTA(B16:B28)-1))","v":9},"Setting-up a Local Centre of Traditions in Pahost "]
[{"$f":"IF(B17=\"\",\"\",COUNTA(B$8:B29)-(COUNTA(B17:B29)-1))","v":10},"Creating traditional costumes"]
[{"$f":"IF(B18=\"\",\"\",COUNTA(B$8:B30)-(COUNTA(B18:B30)-1))","v":11},"Capacity building for local communities (4 workshops)"]
[{"$f":"IF(B19=\"\",\"\",COUNTA(B$8:B31)-(COUNTA(B19:B31)-1))","v":12},"Summing-up and reporting"]
[{"$f":"IF(B20=\"\",\"\",COUNTA(B$8:B32)-(COUNTA(B20:B32)-1))","v":""}]

{"sheet":"Budget","index":1,"n_rows":61,"n_cols":7,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Go to timetable",null,null,null,null,"Exchange Rate","Example"]
[null,"TOTAL AMOUNT (in US$):",{"$f":"SUMIF($B:$B,\"Sub-total:\",C:C)","v":87760.5},{"$f":"SUMIF($B:$B,\"Sub-total:\",D:D)","v":4009},{"$f":"SUMIF($B:$B,\"Sub-total:\",E:E)","v":9780},{"$f":"SUMIF($B:$B,\"Sub-total:\",F:F)","v":101549.5}]
[null,"Percentage of the total amount:",{"$f":"IFERROR($C$2/$F$2,\"\")","v":0.86421400400789761},{"$f":"IFERROR($D$2/$F$2,\"\")","v":3.9478283989581434E-2},{"$f":"IFERROR($E$2/$F$2,\"\")","v":9.6307712002520932E-2},{"$f":"IFERROR($F$2/$F$2,\"\")","v":1}]
["Activity: (indicate the activity and the type of expenditure)","Description: (give full details of calculations)","ICH Fund (in US$)","State Party (in US$)","Others (in US$)","Total (in US$)","Additional comments"]
["Management and coordination system ","Sub-total:",{"$f":"SUBTOTAL(9,C6:C6)","v":0},{"$f":"SUBTOTAL(9,D6:D6)","v":0},{"$f":"SUBTOTAL(9,E6:E6)","v":0},{"$f":"SUBTOTAL(9,F6:F6)","v":0}]
["It is provided by the project team, including specialists and consultants (51-56 lines of the budget) and through the use of local experts and volunteers",null,0,0,0,{"$f":"SUM(C6:E6)","v":0}]
["Start-up and final meetings","Sub-total:",{"$f":"SUBTOTAL(9,C8:C10)","v":980},{"$f":"SUBTOTAL(9,D8:D10)","v":0},{"$f":"SUBTOTAL(9,E8:E10)","v":120},{"$f":"SUBTOTAL(9,F8:F10)","v":1100}]
["Rent a room / Rental venue","Rent of venue for 50 paricipants. 2 meetings x 4 hours x 15 $ a hour ",0,0,120,{"$f":"SUM(C8:E8)","v":120},"Provided by local authority"]
["Hospitality","Coffee -breaks (2) for 50 participants x 5$",500,0,0,{"$f":"SUM(C9:E9)","v":500},"Estimation: 5$ for a person"]
["Travel expenses for experts","Per diem for 4 experts (Minsk-Pahost-Turau-Minsk x 2 days x 60 $ (including transportations",480,0,0,{"$f":"SUM(C10:E10)","v":480}]
["Mapping and inventorying  of ICH in Turau area","Sub-total:",{"$f":"SUBTOTAL(9,C12:C12)","v":3840},{"$f":"SUBTOTAL(9,D12:D12)","v":0},{"$f":"SUBTOTAL(9,E12:E12)","v":0},{"$f":"SUBTOTAL(9,F12:F12)","v":3840}]
["Travel expenses (around Turau area, 300 km), expedition","Rent of bus for 12 participants, 8 days (100$ per day (8 hours) = 800$; Accomodation (8 persons x 7 days x 20$)= 1120$; Per diem (12 persons x 8 days x 20%)=1920$",3840,0,0,{"$f":"SUM(C12:E12)","v":3840},"8 participants -experts + 4 local representatives"]
["Elaboration and publication of ICH Anthology of Turau area","Sub-total:",{"$f":"SUBTOTAL(9,C14:C15)","v":7100},{"$f":"SUBTOTAL(9,D14:D15)","v":0},{"$f":"SUBTOTAL(9,E14:E15)","v":0},{"$f":"SUBTOTAL(9,F14:F15)","v":7100}]
["Processing of material, including mapping, compilation and editing of text, design and layout of the publication","Fees for proceccing materials and text compilation and editing (500 $), mapping (300$), design and layout - 1200$",2000,0,0,{"$f":"SUM(C14:E14)","v":2000},"Survey price"]
["Printing the edition","Printing service, 100 pages, 300 copies x 17$",5100,0,0,{"$f":"SUM(C15:E15)","v":5100},"12 $ for one copy of the edition"]
["Running the ICH festival in Pahost villahe","Sub-total:",{"$f":"SUBTOTAL(9,C17:C21)","v":20000},{"$f":"SUBTOTAL(9,D17:D21)","v":2000},{"$f":"SUBTOTAL(9,E17:E21)","v":4000},{"$f":"SUBTOTAL(9,F17:F21)","v":26000}]
["Meals for participants, 300 persons (musicians, creftsmen, students)","300 persons x 25 $ x 2 days ",15000,0,0,{"$f":"SUM(C17:E17)","v":15000}]
["Awards for ICH bearers","10 awards x  50$ in average",500,0,0,{"$f":"SUM(C18:E18)","v":500}]
["Leaflet of the festival","500 copies x 3$",1500,0,0,{"$f":"SUM(C19:E19)","v":1500},"Promotional leaflet with the festival programme"]
["Accommodation of paricipants","300 persons x 20 $ x 1 day",3000,2000,1000,{"$f":"SUM(C20:E20)","v":6000},"Partly provided by the Ministry of culture and local authority and sponsors"]
["Organizational expenses ","Organization of place, equipment, decoration, human recourses",0,0,3000,{"$f":"SUM(C21:E21)","v":3000},"Provided by local authority and sponsors"]
["The dissemination of information by media and social networks","Sub-total:",{"$f":"SUBTOTAL(9,C23:C25)","v":1900},{"$f":"SUBTOTAL(9,D23:D25)","v":2000},{"$f":"SUBTOTAL(9,E23:E25)","v":0},{"$f":"SUBTOTAL(9,F23:F25)","v":3900}]
["Articles in national, regional and local press","4 articles x 100$ for article",400,0,0,{"$f":"SUM(C23:E23)","v":400}]
["TV programmes ","2 TV programmes created x 1000$",0,2000,0,{"$f":"SUM(C24:E24)","v":2000},"Provided by Ministry of Culture"]
["Moderation of Turau Local Histort Museum' website and creation of a page about Pahost village ICH","Elaboration of the design and soft (price for service - 1000 $, context of the mentioned page -- 500$)",1500,0,0,{"$f":"SUM(C25:E25)","v":1500},"In cooperation with local experts and local youth."]
["Student's Folklore Summer School","Sub-total:",{"$f":"SUBTOTAL(9,C27:C32)","v":9303},{"$f":"SUBTOTAL(9,D27:D32)","v":0},{"$f":"SUBTOTAL(9,E27:E32)","v":0},{"$f":"SUBTOTAL(9,F27:F32)","v":9303}]
["Rent of bus (Minsk-Pahost-Minsk)","Rent of bus for 20 students and 2 teachers (Minsk-Pahost-Minsk), 650 km x 0,46 cent = 299 $",299,0,0,{"$f":"SUM(C27:E27)","v":299}]
["Rent of bus for travel in area (2 days), local transport","2 days across area, 200 km x 0.46 cent = 92$",184,0,0,184,"one-off trips with a fact-finding mission to neighboring towns and villages"]
["Meals ","22 persons x 7 days x 25$ (a day)",3840,0,0,3840]
["Accommodation for paricipants","22 persons x 6 nights x 20$",2640,0,0,2640]
["Lectures for students and local people (4)","Fees for lectors (4 x 150$)+travel expenses for lectors (4 x 60$x 1 day)",840,0,0,840]
["Publication as a result of Student Summer School","Preparing, layout and printing, 60 pages, 100 copies, 1 copy is 15$",1500,0,0,1500]
["Setting-up a Local Centre of Traditions in Pahost ","Sub-total:",{"$f":"SUBTOTAL(9,C34:C41)","v":6130},{"$f":"SUBTOTAL(9,D34:D41)","v":9},{"$f":"SUBTOTAL(9,E34:E41)","v":5300},{"$f":"SUBTOTAL(9,F34:F41)","v":11439}]
["Repair of premises for the opening of the center","Service price: painting walls, including the cost of paint - $ 800; laminate flooring, including the cost of the material (100 sq. m. x 35 $ per 1 sq. m = 3500 $);\npainting the ceiling (100 sq. m. x 10 $ for 1 sq. m = 1000 $)",0,0,5300,{"$f":"SUM(C34:E34)","v":5300},"Provided for local authority resources and sponsorship"]
["Purchase of equipment: Photo camera Canon EQS 5D Body","Average Price for Belarus",1200,0,0,1200,"This item is needed for organization of survey and for documenting"]
["Video-projector Epson MG 850HD, LCD, WXGA (1280x800)","Average Price for Belarus",880,0,0,880,"This item is needed for organization of workshops"]
["Computer block","Average Price for Belarus",880,0,0,880,"This item is needed for organization of workshops and for documenting"]
["Notebook HP ProBook 450G5 2RS03EA","Average Price for Belarus",730,0,0,730,"This item is needed for organization of workshops and for documenting"]
["Screen CACTUS triscreen CS-PST-124x221","Average Price for Belarus",150,0,0,150,"This item is needed for organization of workshops"]
["Flip chart","Average Price for Belarus",130,0,0,130,"This item is needed for organization of workshops"]
["Purchase of furniture for the center","1 big table for 30 places (450 $)  2 office desks (2 x  55 $), 30 chairs (30 x 45$) , 2 office chairs (2 x 45$) , 2 cabinets (2 x 80$)",2160,9,0,2169,"Needed for community metings and workshops"]
["Creating traditional costumes","Sub-total:",{"$f":"SUBTOTAL(9,C43:C45)","v":6937.5},{"$f":"SUBTOTAL(9,D43:D45)","v":0},{"$f":"SUBTOTAL(9,E43:E45)","v":0},{"$f":"SUBTOTAL(9,F43:F45)","v":6937.5}]
["Materials for costumes (textile, strings, etc.)","for 15 costumes, 3,5 m for 1 costume x 15$ (for 1 m)",787.5,0,0,{"$f":"SUM(C43:E43)","v":787.5}]
["Footwear","15 pairs of 60 dollars each",900,0,0,{"$f":"SUM(C44:E44)","v":900}]
["Production of costumes","15 costumes x 350 $",5250,0,0,{"$f":"SUM(C45:E45)","v":5250},"Price for craft work"]
["Capacity building for local community members (4 workshops)","Sub-total:",{"$f":"SUBTOTAL(9,C47:C50)","v":4600},{"$f":"SUBTOTAL(9,D47:D50)","v":0},{"$f":"SUBTOTAL(9,E47:E50)","v":360},{"$f":"SUBTOTAL(9,F47:F50)","v":4960}]
["Rent of venue","Rent of venue for 30 paricipants. 4 workshops x 6 hours x 15 $ a hour ",0,0,360,{"$f":"SUM(C47:E47)","v":360},"Provided by lical authority"]
["Per diem for 8 experts","8 experts x 4 days x 60$, including transportation",1920,0,0,{"$f":"SUM(C48:E48)","v":1920}]
["Office supply ","4 workshops x 70$",280,0,0,{"$f":"SUM(C49:E49)","v":280}]
["Meals for participants","30 persons x 20$ (coffee breaks and lunches) x 4 workshops",2400,0,0,{"$f":"SUM(C50:E50)","v":2400}]
["Human resources for the implementation of the project. This team will be used for the elaboration of the Safeguading and Revitalisation Strategy for the Pahost village and providing monitoring mission","Sub-total:",{"$f":"SUBTOTAL(9,C52:C57)","v":25320},{"$f":"SUBTOTAL(9,D52:D57)","v":0},{"$f":"SUBTOTAL(9,E52:E57)","v":0},{"$f":"SUBTOTAL(9,F52:F57)","v":25320}]
["Project manager, 60% ","Fee:14 months x 600$ ",8400,0,0,{"$f":"SUM(C52:E52)","v":8400},"Monthly rate for the project coordinator based on the average salary for this position. Employed part-time (50%)"]
["Specialist on community involvement, 40%","Fee:9,6 months x 400$ ",3840,0,0,3840,"Monthly rate for this position r based on the average salary for this position. Employed part-time- 40%)"]
["Specialist in ICH, 40%","Fee: 9,6 months x  400$",3840,0,0,3840,"Monthly rate for this position r based on the average salary for this position. Employed part-time- 40%)"]
["Specialist in local culture and crafts, 20%","Fee: 4.8 months x  400$",1920,0,0,1920,"Monthly rate for this position r based on the average salary for this position. Employed part-time- 20%)"]
["Specialist in local culture and crafts, 20%","Fee: 4.8 months x  400$",1920,0,0,1920]
["Financial manager, 50%","Fee: 12 months x 450$",5400,0,0,5400,"Monthly rate for this position r based on the average salary for this position. Employed part-time- 50%)"]
["Monitorying of the project","Sub-total:",{"$f":"SUBTOTAL(9,C59:C59)","v":1350},{"$f":"SUBTOTAL(9,D59:D59)","v":0},{"$f":"SUBTOTAL(9,E59:E59)","v":0},{"$f":"SUBTOTAL(9,F59:F59)","v":1350}]
["Travel expenses for the Project manager with monitorying mission","Travel to and from the project site, use the technique at the field, 650 km (to and back), 10 km = 10$, 15 times x 65$ = 975$; per diem (15 days x 25 $ = 375 $)",1350,0,0,{"$f":"SUM(C59:E59)","v":1350}]
["Administrative cost ","Sub-total:",{"$f":"SUBTOTAL(9,C61:C61)","v":300},{"$f":"SUBTOTAL(9,D61:D61)","v":0},{"$f":"SUBTOTAL(9,E61:E61)","v":0},{"$f":"SUBTOTAL(9,F61:F61)","v":300}]
["Administrative expenses","Bank expenses, payment for internet and mailing",300,0,0,{"$f":"SUM(C61:E61)","v":300}]

{"sheet":"Example","index":2,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Go to timetable","TOTAL AMOUNT (in US$):",{"$f":"SUMIF($B:$B,\"Sub-total:\",C:C)","v":1000},{"$f":"SUMIF($B:$B,\"Sub-total:\",D:D)","v":200},{"$f":"SUMIF($B:$B,\"Sub-total:\",E:E)","v":900},{"$f":"SUMIF($B:$B,\"Sub-total:\",F:F)","v":2100},"Go to budget"]
[null,"Percentage of the total amount:",{"$f":"IFERROR($C$1/$F$1,\"\")","v":0.47619047619047616},{"$f":"IFERROR($D$1/$F$1,\"\")","v":9.5238095238095233E-2},{"$f":"IFERROR($E$1/$F$1,\"\")","v":0.42857142857142855},{"$f":"IFERROR($F$1/$F$1,\"\")","v":1}]
["Activity: (click on the blue cells below to indicate your activities, then click on the white cells to select the appropriate expenditure from the list)","Description: (give full details of calculations)","ICH Fund (in US$)","State Party (in US$)","Others (in US$)","Total (in US$)","Additional comments"]
["Ex: Training Workshop on inventories","Sub-total:",{"$f":"SUBTOTAL(9,C5:C8)","v":1000},{"$f":"SUBTOTAL(9,D5:D8)","v":200},{"$f":"SUBTOTAL(9,E5:E8)","v":900},{"$f":"SUBTOTAL(9,F5:F8)","v":2100}]
["Rent a room / Rental venue",{"$f":"IF(ISNA(VLOOKUP(A5,data!A:B,2,FALSE)),\"\",(VLOOKUP(A5,data!A:B,2,FALSE)))","v":"Rental of a meeting room (capacity 50 persons) for the workshop participants during three days"},{"$f":"IF(ISNA(VLOOKUP(A5,data!A:C,3,FALSE)),\"\",(VLOOKUP(A5,data!A:C,3,FALSE)))","v":0},{"$f":"IF(ISNA(VLOOKUP(A5,data!A:D,4,FALSE)),\"\",(VLOOKUP(A5,data!A:D,4,FALSE)))","v":0},{"$f":"IF(ISNA(VLOOKUP(A5,data!A:E,5,FALSE)),\"\",(VLOOKUP(A5,data!A:E,5,FALSE)))","v":700},{"$f":"SUM(C5:E5)","v":700},{"$f":"IF(ISNA(VLOOKUP(A5,data!A:G,6,FALSE)),\"\",(VLOOKUP(A5,data!A:G,6,FALSE)))","v":"US$350 provided by ABC Foundation and US$350 provided by DEF Association"}]
["Hospitality",{"$f":"IF(ISNA(VLOOKUP(A6,data!A:B,2,FALSE)),\"\",(VLOOKUP(A6,data!A:B,2,FALSE)))","v":"1 coffee break for each workshop 1000, $ 500 * 2 = $ 1000"},{"$f":"IF(ISNA(VLOOKUP(A6,data!A:C,3,FALSE)),\"\",(VLOOKUP(A6,data!A:C,3,FALSE)))","v":1000},{"$f":"IF(ISNA(VLOOKUP(A6,data!A:D,4,FALSE)),\"\",(VLOOKUP(A6,data!A:D,4,FALSE)))","v":0},{"$f":"IF(ISNA(VLOOKUP(A6,data!A:E,5,FALSE)),\"\",(VLOOKUP(A6,data!A:E,5,FALSE)))","v":0},{"$f":"SUM(C6:E6)","v":1000},{"$f":"IF(ISNA(VLOOKUP(A6,data!A:G,6,FALSE)),\"\",(VLOOKUP(A6,data!A:G,6,FALSE)))","v":"Estimation $ 5 / person"}]
["Interpretation",{"$f":"IF(ISNA(VLOOKUP(A7,data!A:B,2,FALSE)),\"\",(VLOOKUP(A7,data!A:B,2,FALSE)))","v":"Fees and per diem for two interpretors, US$100 per hour, 2 hours each"},{"$f":"IF(ISNA(VLOOKUP(A7,data!A:C,3,FALSE)),\"\",(VLOOKUP(A7,data!A:C,3,FALSE)))","v":0},{"$f":"IF(ISNA(VLOOKUP(A7,data!A:D,4,FALSE)),\"\",(VLOOKUP(A7,data!A:D,4,FALSE)))","v":200},{"$f":"IF(ISNA(VLOOKUP(A7,data!A:E,5,FALSE)),\"\",(VLOOKUP(A7,data!A:E,5,FALSE)))","v":200},{"$f":"SUM(C7:E7)","v":400},{"$f":"IF(ISNA(VLOOKUP(A7,data!A:G,6,FALSE)),\"\",(VLOOKUP(A7,data!A:G,6,FALSE)))","v":"the meeting is expected to take two hours maximum time"}]
[null,"Sub-total:",{"$f":"SUBTOTAL(9,C9:C12)","v":0},{"$f":"SUBTOTAL(9,D9:D12)","v":0},{"$f":"SUBTOTAL(9,E9:E12)","v":0},{"$f":"SUBTOTAL(9,F9:F12)","v":0}]
[null,null,null,null,null,{"$f":"SUM(C9:E9)","v":0}]
[null,null,null,null,null,{"$f":"SUM(C10:E10)","v":0}]
[null,null,null,null,null,{"$f":"SUM(C11:E11)","v":0}]
[null,"Sub-total:",{"$f":"SUBTOTAL(9,C13:C16)","v":0},{"$f":"SUBTOTAL(9,D13:D16)","v":0},{"$f":"SUBTOTAL(9,E13:E16)","v":0},{"$f":"SUBTOTAL(9,F13:F16)","v":0}]
[null,null,null,null,null,{"$f":"SUM(C13:E13)","v":0}]
[null,null,null,null,null,{"$f":"SUM(C14:E14)","v":0}]
[null,null,null,null,null,{"$f":"SUM(C15:E15)","v":0}]

{"sheet":"ExchRate","index":3,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,0,1,5],[0,0,0,5]]}
["OPERATIONAL RATES OF EXCHANGE FOR UNITED NATIONS PROGRAMMES  -  2017",null,null,null,null,null,"Go to budget"]
["(EQUIVALENT IN UNIT PER US DOLLAR)"]
[]
["Chose Country from the list:"]
["Local currency:",{"$f":"IF(ISNA(VLOOKUP(B4,ERdata!A:C,3,FALSE)),\"-\",(VLOOKUP(B4,ERdata!A:C,3,FALSE)))","v":"-"}]
["UN Monthly Rate for 1 US DOLLAR:",{"$f":"IF(ISNA(VLOOKUP(B4,ERdata!A:D,4,FALSE)),\"-\",(VLOOKUP(B4,ERdata!A:D,4,FALSE)))","v":"-"},{"$f":"ERdata!D4","v":"2017-09-01"}]
[]
["Amount in Local Currency:"]
["Equivalent in US DOLLAR:",{"$f":"IFERROR(B8/B6,\"-\")","v":"-"}]
[]
["*Please note that the conversion rate is that of the month at the time the file is downloaded and will be valid for that month only."]

{"sheet":"data","index":4,"n_rows":55,"n_cols":6,"rows_kept":55,"cut":false,"hidden":true,"merged":[]}
[null,null,"Amount requested to the ICH Fund (in USD)","State Party Funds (in USD)","Other sources (in USD)","Comments"]
["1. Workshop, seminars and meetings","select an item, if applicable"]
["Audio-Visual Equipment","2 recorders at US$100 / unit",100,100,0,"Sony recorder XYZ"]
["Hospitality","1 coffee break for each workshop 1000, $ 500 * 2 = $ 1000",1000,0,0,"Estimation $ 5 / person"]
["Interpretation","Fees and per diem for two interpretors, US$100 per hour, 2 hours each",0,200,200,"the meeting is expected to take two hours maximum time"]
["Rent a room / Rental venue","Rental of a meeting room (capacity 50 persons) for the workshop participants during three days",0,0,700,"US$350 provided by ABC Foundation and US$350 provided by DEF Association"]
["Stationery","Paper and pens for the workshop",500,0,0," "]
["Translation, editing and printing","Translation of training materials: $ 30 / page, 200 pages",0,6000,0," "]
["Other training costs (specify)"]
[]
["2. Staff / Advisory services (fees)","select an item, if applicable"]
["Administrative Assistance","$ 500 / month for 6 months",2000,1000,null,"secretary"]
["Auditor / Evaluator","Fees for two evaluators for 15 days each",1500,0,0," "]
["Consultant","$ __ / week for__ week(s)",null,null,null,"Expert, interpreter, computer assistant, driver"]
["Coordinator","3 people at $ 30 per day for 10 days to complete the program",450,0,450,"Coordination costs financed by the EFG Institute"]
["International / national personnel","$ __ / week for__ week(s)"]
["Facilitator"]
["Researcher"]
["Trainers"]
["Other personnel costs (specify)","Costs for demonstration and performance",0,500]
[]
["3. Travel costs","select an item, if applicable"]
["Accommodation","for one project coordinator x $ 40 per day x 5 days",200,0,0," "]
["Domestic travel","Roundtrip to Village C (3 people) $ 400 / ticket",0,0,1200,"Air tickets financed by the Organization HIJ"]
["Fuel"]
["International travel","$ 1,500 / ticket for 2 people",3000,0,0," "]
["Meals","for one project coordinator x $ 20 per day x 5 days",100,0,0," "]
["Per diem (lodging, meals and incidentals)","For the coordination team, 3 people x $ 60 per day x 10 days",1800,0,0," "]
["Visa fees","$ 90 for 3 participants",270,0,0," "]
["Other travel costs (specify)","Transportation for members of the survey team, 14 people x $ 20 per day x 10 days",2300,500,0]
[]
["4. Equipment / Material","select an item, if applicable"]
["Audiovisual material","2 digital cameras at $ 400 / unit",800,0,0,"Purchase of two digital cameras for field investigation"]
["Banners & Graphic material"]
["Laptop computer","Laptop samsung XYZ",null,null,null,"Computer Purchase for field investigation"]
["Printer","Laser printer KLM"]
["Project vehicles"]
["Recorder"]
["Rental service","Renting a projector",300,null,null," "]
["Repair and maintenance services"]
["Sound & multimedia equipment"]
["Other equipment (specify)","Fuel for the coordination team from C to D, 200 liters per team x 3 teams $ 1.4 X1L",840,0,0," "]
[]
["5. Contractual services","select an item, if applicable"]
["Contract for meetings"]
["Document production contract","Contract for the production of supporting documents for training",800,200,null,"cofinancing"]
["Research contract",null,2000,2000,0," "]
["Other service contracts (specify)","Production of film"]
[]
["6. Miscellaneous","select an item, if applicable"]
["Communication costs","phone, fax, internet costs",500,500,0," "]
["Financial/Bank charges"]
["Postal services","500 brochures x $3 distribution costs (XYZ)",0,1500,0," "]
["Provision for currency fluctuations","3% of the total requested",500,0,0," "]
["Other (specify)"]

{"sheet":"model","index":5,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Sub-total:",null,null,null,0]
[null,null,null,null,null,{"$f":"SUM(C4:E4)","v":0}]

{"sheet":"ERdata","index":6,"n_rows":213,"n_cols":4,"rows_kept":213,"cut":false,"hidden":true,"merged":[]}
["7OPERATIONAL RATES OF EXCHANGE FOR UNITED NATIONS PROGRAMMES  -  2017"]
["(EQUIVALENT IN UNIT PER US DOLLAR)"]
[]
["COUNTRY","CURRENCY",null,{"$f":"LOOKUP(9^9,[1]Exch2017!$A$4:$AB$4)","v":"2017-09-01"}]
["Afghanistan","Afghani","AFN",{"$f":"LOOKUP(9^9,[1]Exch2017!A5:IV5)","v":68.34}]
["Albania","Lek","ALL",{"$f":"LOOKUP(9^9,[1]Exch2017!A6:IV6)","v":111.45}]
["Algeria","Dinar","DZD",{"$f":"LOOKUP(9^9,[1]Exch2017!A7:IV7)","v":110.05970000000001}]
["Andorra","Euro","EUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A8:IV8)","v":0.83199999999999996}]
["Angola","Kwanza Reaj.","AOA",{"$f":"LOOKUP(9^9,[1]Exch2017!A9:IV9)","v":165.1}]
["Antigua and Barbuda","EC Dollar","XCD",{"$f":"LOOKUP(9^9,[1]Exch2017!A10:IV10)","v":2.7}]
["Argentina","Peso","ARS",{"$f":"LOOKUP(9^9,[1]Exch2017!A11:IV11)","v":17.263000000000002}]
["Armenia","Drum","AMD",{"$f":"LOOKUP(9^9,[1]Exch2017!A12:IV12)","v":479.5}]
["Aruba","Aruba Guilder","AWG",{"$f":"LOOKUP(9^9,[1]Exch2017!A13:IV13)","v":1.79}]
["Australia","Australian Dollar","AUD",{"$f":"LOOKUP(9^9,[1]Exch2017!A14:IV14)","v":1.2549999999999999}]
["Austria","Euro","EUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A15:IV15)","v":0.83199999999999996}]
["Azerbaijan","New Azerbaijan Manat","AZN",{"$f":"LOOKUP(9^9,[1]Exch2017!A16:IV16)","v":1.6919999999999999}]
["Bahamas","Bahamian Dollar","BSD",{"$f":"LOOKUP(9^9,[1]Exch2017!A17:IV17)","v":1}]
["Bahrain","Dinar","BHD",{"$f":"LOOKUP(9^9,[1]Exch2017!A18:IV18)","v":0.37708000000000003}]
["Bangladesh","Taka","BDT",{"$f":"LOOKUP(9^9,[1]Exch2017!A19:IV19)","v":81.224999999999994}]
["Barbados","Barbados Dollar","BBD",{"$f":"LOOKUP(9^9,[1]Exch2017!A20:IV20)","v":2}]
["Belarus","New Belarusian Ruble","BYN",{"$f":"LOOKUP(9^9,[1]Exch2017!A21:IV21)","v":1.9258}]
["Belgium","Euro","EUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A22:IV22)","v":0.83199999999999996}]
["Belize","Belize Dollar","BZD",{"$f":"LOOKUP(9^9,[1]Exch2017!A23:IV23)","v":1.9986999999999999}]
["Benin","CFA Franc","XOF",{"$f":"LOOKUP(9^9,[1]Exch2017!A24:IV24)","v":545.67600000000004}]
["Bermuda","Bermuda Dollar","BMD",{"$f":"LOOKUP(9^9,[1]Exch2017!A25:IV25)","v":1}]
["Bhutan","Ngultrum","BTN",{"$f":"LOOKUP(9^9,[1]Exch2017!A26:IV26)","v":64.02}]
["Bolivia","Boliviano","BOB",{"$f":"LOOKUP(9^9,[1]Exch2017!A27:IV27)","v":6.91}]
["Bosnia and Herzegovina","Conv. Mark","BAM",{"$f":"LOOKUP(9^9,[1]Exch2017!A28:IV28)","v":1.627}]
["Botswana","Pula","BWP",{"$f":"LOOKUP(9^9,[1]Exch2017!A29:IV29)","v":10.0806}]
["Brazil","Real","BRL",{"$f":"LOOKUP(9^9,[1]Exch2017!A30:IV30)","v":3.1709999999999998}]
["Brunei Darussalam","Brunei Dollar","BND",{"$f":"LOOKUP(9^9,[1]Exch2017!A31:IV31)","v":1.3520000000000001}]
["Bulgaria","New Leva","BGN",{"$f":"LOOKUP(9^9,[1]Exch2017!A32:IV32)","v":1.627}]
["Burkina Faso","CFA Franc","XOF",{"$f":"LOOKUP(9^9,[1]Exch2017!A33:IV33)","v":545.67600000000004}]
["Burundi","Burundi Franc","BIF",{"$f":"LOOKUP(9^9,[1]Exch2017!A34:IV34)","v":1728.0640000000001}]
["Cambodia","Riel","KHR",{"$f":"LOOKUP(9^9,[1]Exch2017!A35:IV35)","v":4080}]
["Cameroon","CFA Franc","XAF",{"$f":"LOOKUP(9^9,[1]Exch2017!A36:IV36)","v":545.67600000000004}]
["Canada","Canadian Dollar","CAD",{"$f":"LOOKUP(9^9,[1]Exch2017!A37:IV37)","v":1.25}]
["Cape Verde","Escudo","CVE",{"$f":"LOOKUP(9^9,[1]Exch2017!A38:IV38)","v":91.727000000000004}]
["Cayman Islands","Cayman Dollar","KYD",{"$f":"LOOKUP(9^9,[1]Exch2017!A39:IV39)","v":0.82}]
["Central African Republic","CFA Franc","XAF",{"$f":"LOOKUP(9^9,[1]Exch2017!A40:IV40)","v":545.67600000000004}]
["Chad","CFA Franc","XAF",{"$f":"LOOKUP(9^9,[1]Exch2017!A41:IV41)","v":545.67600000000004}]
["Chile","Peso","CLP",{"$f":"LOOKUP(9^9,[1]Exch2017!A42:IV42)","v":629}]
["China","Yuan Renminbi","CNY",{"$f":"LOOKUP(9^9,[1]Exch2017!A43:IV43)","v":6.5970000000000004}]
["Colombia","Peso","COP",{"$f":"LOOKUP(9^9,[1]Exch2017!A44:IV44)","v":2943}]
["Comoros","Com. Franc","KMF",{"$f":"LOOKUP(9^9,[1]Exch2017!A45:IV45)","v":409.25700000000001}]
["Congo","CFA Franc","XAF",{"$f":"LOOKUP(9^9,[1]Exch2017!A46:IV46)","v":545.67600000000004}]
["Congo DR (ex Zaire)","Franc Congolais","CDF",{"$f":"LOOKUP(9^9,[1]Exch2017!A47:IV47)","v":1600.75}]
["Cook Islands","NZ Dollar","NZD",{"$f":"LOOKUP(9^9,[1]Exch2017!A48:IV48)","v":1.375}]
["Costa Rica","Colones","CRC",{"$f":"LOOKUP(9^9,[1]Exch2017!A49:IV49)","v":574.29}]
["Cote d'Ivoire","CFA Franc","XOF",{"$f":"LOOKUP(9^9,[1]Exch2017!A50:IV50)","v":545.67600000000004}]
["Croatia","Kuna","HRK",{"$f":"LOOKUP(9^9,[1]Exch2017!A51:IV51)","v":6.1680000000000001}]
["Cuba","Pesos","CUP",{"$f":"LOOKUP(9^9,[1]Exch2017!A52:IV52)","v":1}]
["Cuba (convertible)","Pesos (convertible)","CUC",{"$f":"LOOKUP(9^9,[1]Exch2017!A53:IV53)","v":0.99}]
["Cyprus","Euro","EUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A54:IV54)","v":0.83199999999999996}]
["Czech Republic","Koruna","CZK",{"$f":"LOOKUP(9^9,[1]Exch2017!A55:IV55)","v":21.75}]
["Denmark","Krone","DKK",{"$f":"LOOKUP(9^9,[1]Exch2017!A56:IV56)","v":6.1890000000000001}]
["Djibouti","Djib. Franc","DJF",{"$f":"LOOKUP(9^9,[1]Exch2017!A57:IV57)","v":177}]
["Dominica","EC Dollar","XCD",{"$f":"LOOKUP(9^9,[1]Exch2017!A58:IV58)","v":2.7}]
["Dominican Republic","Peso","DOP",{"$f":"LOOKUP(9^9,[1]Exch2017!A59:IV59)","v":47.295000000000002}]
["Ecuador","U.S. Dollar","USD",{"$f":"LOOKUP(9^9,[1]Exch2017!A60:IV60)","v":1}]
["Egypt","Pound","EGP",{"$f":"LOOKUP(9^9,[1]Exch2017!A61:IV61)","v":17.658000000000001}]
["El Salvador","U.S. Dollar","USD",{"$f":"LOOKUP(9^9,[1]Exch2017!A62:IV62)","v":1}]
["Equatorial Guinea","CFA Franc","XAF",{"$f":"LOOKUP(9^9,[1]Exch2017!A63:IV63)","v":545.67600000000004}]
["Eritrea","Nafka","ERN",{"$f":"LOOKUP(9^9,[1]Exch2017!A64:IV64)","v":15}]
["Estonia","Euro","EUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A65:IV65)","v":0.83199999999999996}]
["Ethiopia","Birr","ETB",{"$f":"LOOKUP(9^9,[1]Exch2017!A66:IV66)","v":23.5}]
["European Union","Euro","EUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A67:IV67)","v":0.83199999999999996}]
["Fiji","Fiji Dollar","FJD",{"$f":"LOOKUP(9^9,[1]Exch2017!A68:IV68)","v":1.99}]
["Finland","Euro","EUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A69:IV69)","v":0.83199999999999996}]
["France","Euro","EUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A70:IV70)","v":0.83199999999999996}]
["French Guiana","Euro","EUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A71:IV71)","v":0.83199999999999996}]
["Gabon","CFA Franc","XAF",{"$f":"LOOKUP(9^9,[1]Exch2017!A72:IV72)","v":545.67600000000004}]
["Gambia","Dalasis","GMD",{"$f":"LOOKUP(9^9,[1]Exch2017!A73:IV73)","v":47.11}]
["Georgia","Lari","GEL",{"$f":"LOOKUP(9^9,[1]Exch2017!A74:IV74)","v":2.395}]
["Germany","Euro","EUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A75:IV75)","v":0.83199999999999996}]
["Ghana","New Cedi","GHS",{"$f":"LOOKUP(9^9,[1]Exch2017!A76:IV76)","v":4.4249999999999998}]
["Greece","Euro","EUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A77:IV77)","v":0.83199999999999996}]
["Grenada","EC Dollar","XCD",{"$f":"LOOKUP(9^9,[1]Exch2017!A78:IV78)","v":2.7}]
["Guadeloupe","Euro","EUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A79:IV79)","v":0.83199999999999996}]
["Guatemala","Quetzale","GTQ",{"$f":"LOOKUP(9^9,[1]Exch2017!A80:IV80)","v":7.2858000000000001}]
["Guinea","Franc Guinéen","GNF",{"$f":"LOOKUP(9^9,[1]Exch2017!A81:IV81)","v":8970}]
["Guinea-Bissau","CFA Franc","XOF",{"$f":"LOOKUP(9^9,[1]Exch2017!A82:IV82)","v":545.67600000000004}]
["Guyana","Guyana Dollar","GYD",{"$f":"LOOKUP(9^9,[1]Exch2017!A83:IV83)","v":207.2}]
["Haiti","Gourde","HTG",{"$f":"LOOKUP(9^9,[1]Exch2017!A84:IV84)","v":63.209299999999999}]
["Honduras","Lempira","HNL",{"$f":"LOOKUP(9^9,[1]Exch2017!A85:IV85)","v":23.377800000000001}]
["Hong Kong","H. K. Dollar","HKD",{"$f":"LOOKUP(9^9,[1]Exch2017!A86:IV86)","v":7.8239999999999998}]
["Hungary","Forint","HUF",{"$f":"LOOKUP(9^9,[1]Exch2017!A87:IV87)","v":254.12}]
["Iceland","Krona","ISK",{"$f":"LOOKUP(9^9,[1]Exch2017!A88:IV88)","v":104.58}]
["India","Rupee","INR",{"$f":"LOOKUP(9^9,[1]Exch2017!A89:IV89)","v":64.02}]
["Indonesia","Rupiah","IDR",{"$f":"LOOKUP(9^9,[1]Exch2017!A90:IV90)","v":13340}]
["Iran","Rial","IRR",{"$f":"LOOKUP(9^9,[1]Exch2017!A91:IV91)","v":37268}]
["Iraq","Dinar","IQD",{"$f":"LOOKUP(9^9,[1]Exch2017!A92:IV92)","v":1170}]
["Ireland","Euro","EUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A93:IV93)","v":0.83199999999999996}]
["Israel","New Shekel","ILS",{"$f":"LOOKUP(9^9,[1]Exch2017!A94:IV94)","v":3.5779999999999998}]
["Italy","Euro","EUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A95:IV95)","v":0.83199999999999996}]
["Jamaica","Jamaican Dollar","JMD",{"$f":"LOOKUP(9^9,[1]Exch2017!A96:IV96)","v":127.9521}]
["Japan","Yen","JPY",{"$f":"LOOKUP(9^9,[1]Exch2017!A97:IV97)","v":108.67}]
["Jordan","Dinar","JOD",{"$f":"LOOKUP(9^9,[1]Exch2017!A98:IV98)","v":0.70799999999999996}]
["Kazakhstan","Tenge","KZT",{"$f":"LOOKUP(9^9,[1]Exch2017!A99:IV99)","v":335.37}]
["Kenya","Shilling","KES",{"$f":"LOOKUP(9^9,[1]Exch2017!A100:IV100)","v":103.21}]
["Kiribati","Australian Dollar","AUD",{"$f":"LOOKUP(9^9,[1]Exch2017!A101:IV101)","v":1.2549999999999999}]
["Korea, Dem. People's Republic","Won","KPW",{"$f":"LOOKUP(9^9,[1]Exch2017!A102:IV102)","v":105.29}]
["Korea, Rep. Of","Won","KRW",{"$f":"LOOKUP(9^9,[1]Exch2017!A103:IV103)","v":1126.1500000000001}]
["Kuwait","Dinar","KWD",{"$f":"LOOKUP(9^9,[1]Exch2017!A104:IV104)","v":0.30099999999999999}]
["Kyrgyzstan","Som","KGS",{"$f":"LOOKUP(9^9,[1]Exch2017!A105:IV105)","v":68.349999999999994}]
["Lao P.D.R.","Kip","LAK",{"$f":"LOOKUP(9^9,[1]Exch2017!A106:IV106)","v":8297.5}]
["Latvia","Latvian Lat","EUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A107:IV107)","v":0.83199999999999996}]
["Lebanon","Pound","LBP",{"$f":"LOOKUP(9^9,[1]Exch2017!A108:IV108)","v":1507.5}]
["Lesotho","Maloti","LSL",{"$f":"LOOKUP(9^9,[1]Exch2017!A109:IV109)","v":12.99}]
["Liberia","Liberian Dollar","LRD",{"$f":"LOOKUP(9^9,[1]Exch2017!A110:IV110)","v":114.67}]
["Libyan Arab Jamahiriya","Dinar","LYD",{"$f":"LOOKUP(9^9,[1]Exch2017!A111:IV111)","v":1.3680000000000001}]
["Liechtenstein","Swiss Franc","CHF",{"$f":"LOOKUP(9^9,[1]Exch2017!A112:IV112)","v":0.94599999999999995}]
["Lithuania","Lita","EUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A113:IV113)","v":0.83199999999999996}]
["Luxembourg","Euro","EUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A114:IV114)","v":0.83199999999999996}]
["Macao","Pataca","MOP",{"$f":"LOOKUP(9^9,[1]Exch2017!A115:IV115)","v":8.0589999999999993}]
["Macedonia, the former Republic of Yugoslavia","Dinar","MKD",{"$f":"LOOKUP(9^9,[1]Exch2017!A116:IV116)","v":51.512599999999999}]
["Madagascar","Malagasy Ariary","MGA",{"$f":"LOOKUP(9^9,[1]Exch2017!A117:IV117)","v":2951.76}]
["Malawi","Kwacha","MWK",{"$f":"LOOKUP(9^9,[1]Exch2017!A118:IV118)","v":727}]
["Malaysia","Ringgit","MYR",{"$f":"LOOKUP(9^9,[1]Exch2017!A119:IV119)","v":4.2676999999999996}]
["Maldives, Rep. of","Rufiyaa","MVR",{"$f":"LOOKUP(9^9,[1]Exch2017!A120:IV120)","v":15}]
["Mali","CFA Franc","XOF",{"$f":"LOOKUP(9^9,[1]Exch2017!A121:IV121)","v":545.67600000000004}]
["Malta","Euro","EUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A122:IV122)","v":0.83199999999999996}]
["Marshall Islands","US Dollar","USD",{"$f":"LOOKUP(9^9,[1]Exch2017!A123:IV123)","v":1}]
["Martinique","Euro","EUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A124:IV124)","v":0.83199999999999996}]
["Mauritania","Ouguiya","MRO",{"$f":"LOOKUP(9^9,[1]Exch2017!A125:IV125)","v":356.28}]
["Mauritius","Rupee","MUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A126:IV126)","v":32.609499999999997}]
["Mexico","Peso","MXN",{"$f":"LOOKUP(9^9,[1]Exch2017!A127:IV127)","v":17.87}]
["Moldova,Republic of","Moldovan Lei","MDL",{"$f":"LOOKUP(9^9,[1]Exch2017!A128:IV128)","v":17.77}]
["Monaco","Euro","EUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A129:IV129)","v":0.83199999999999996}]
["Mongolia","Tughrik","MNT",{"$f":"LOOKUP(9^9,[1]Exch2017!A130:IV130)","v":2439}]
["Morocco","Dirham","MAD",{"$f":"LOOKUP(9^9,[1]Exch2017!A131:IV131)","v":9.3066999999999993}]
["Mozambique","New Metical","MZN",{"$f":"LOOKUP(9^9,[1]Exch2017!A132:IV132)","v":61.4}]
["Myanmar","Kyat","MMK",{"$f":"LOOKUP(9^9,[1]Exch2017!A133:IV133)","v":1360}]
["Namibia","Namibian Dollar","NAD",{"$f":"LOOKUP(9^9,[1]Exch2017!A134:IV134)","v":12.99}]
["Nauru","Australian Dollar","AUD",{"$f":"LOOKUP(9^9,[1]Exch2017!A135:IV135)","v":1.2549999999999999}]
["Nepal","Rupee","NPR",{"$f":"LOOKUP(9^9,[1]Exch2017!A136:IV136)","v":102.432}]
["Netherlands","Euro","EUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A137:IV137)","v":0.83199999999999996}]
["Netherlands Antilles","Guilder","ANG",{"$f":"LOOKUP(9^9,[1]Exch2017!A138:IV138)","v":1.79}]
["New Caledonia","CFP Franc","XPF",{"$f":"LOOKUP(9^9,[1]Exch2017!A139:IV139)","v":99.27}]
["New Zealand","NZ Dollar","NZD",{"$f":"LOOKUP(9^9,[1]Exch2017!A140:IV140)","v":1.375}]
["Nicaragua","Cordoba Oro","NIO",{"$f":"LOOKUP(9^9,[1]Exch2017!A141:IV141)","v":30.284800000000001}]
["Niger","CFA Franc","XOF",{"$f":"LOOKUP(9^9,[1]Exch2017!A142:IV142)","v":545.67600000000004}]
["Nigeria","Naira","NGN",{"$f":"LOOKUP(9^9,[1]Exch2017!A143:IV143)","v":355.99}]
["Niue","NZ Dollar","NZD",{"$f":"LOOKUP(9^9,[1]Exch2017!A144:IV144)","v":1.375}]
["Norway","Krone","NOK",{"$f":"LOOKUP(9^9,[1]Exch2017!A145:IV145)","v":7.734}]
["Oman","Oman Riyal","OMR",{"$f":"LOOKUP(9^9,[1]Exch2017!A146:IV146)","v":0.38500000000000001}]
["Pakistan","Rupee","PKR",{"$f":"LOOKUP(9^9,[1]Exch2017!A147:IV147)","v":105.4}]
["Panama","Balboa","PAB",{"$f":"LOOKUP(9^9,[1]Exch2017!A148:IV148)","v":1}]
["Papua New Guinea","Kina","PGK",{"$f":"LOOKUP(9^9,[1]Exch2017!A149:IV149)","v":3.18}]
["Paraguay","Guaranie","PYG",{"$f":"LOOKUP(9^9,[1]Exch2017!A150:IV150)","v":5646}]
["Peru","Nuevo Sol","PEN",{"$f":"LOOKUP(9^9,[1]Exch2017!A151:IV151)","v":3.238}]
["Philippines","Peso","PHP",{"$f":"LOOKUP(9^9,[1]Exch2017!A152:IV152)","v":50.999000000000002}]
["Poland","Zloty","PLN",{"$f":"LOOKUP(9^9,[1]Exch2017!A153:IV153)","v":3.5516999999999999}]
["Portugal","Euro","EUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A154:IV154)","v":0.83199999999999996}]
["Qatar","Qatar Riyal","QAR",{"$f":"LOOKUP(9^9,[1]Exch2017!A155:IV155)","v":3.68}]
["Romania","New Leu","RON",{"$f":"LOOKUP(9^9,[1]Exch2017!A156:IV156)","v":3.8250000000000002}]
["Russian Federation","Rouble","RUB",{"$f":"LOOKUP(9^9,[1]Exch2017!A157:IV157)","v":58.87}]
["Rwanda","Rwanda Franc","RWF",{"$f":"LOOKUP(9^9,[1]Exch2017!A158:IV158)","v":834.55899999999997}]
["Saint Helena","St.Helena Pound","SHP",{"$f":"LOOKUP(9^9,[1]Exch2017!A159:IV159)","v":0.77300000000000002}]
["Saint Kitt and Nevis","EC Dollar","XCD",{"$f":"LOOKUP(9^9,[1]Exch2017!A160:IV160)","v":2.7}]
["Saint Lucia","EC Dollar","XCD",{"$f":"LOOKUP(9^9,[1]Exch2017!A161:IV161)","v":2.7}]
["SaintVincent&Grenadines","EC Dollar","XCD",{"$f":"LOOKUP(9^9,[1]Exch2017!A162:IV162)","v":2.7}]
["Samoa","Tala","WST",{"$f":"LOOKUP(9^9,[1]Exch2017!A163:IV163)","v":2.4239999999999999}]
["San Marino","Euro","EUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A164:IV164)","v":0.83199999999999996}]
["Sao Tome Principe","Dobra","STD",{"$f":"LOOKUP(9^9,[1]Exch2017!A165:IV165)","v":20832.367999999999}]
["Saudi Arabia","Riyals","SAR",{"$f":"LOOKUP(9^9,[1]Exch2017!A166:IV166)","v":3.75}]
["Senegal","CFA Franc","XOF",{"$f":"LOOKUP(9^9,[1]Exch2017!A167:IV167)","v":545.67600000000004}]
["Serbia ","Dinar","RSD",{"$f":"LOOKUP(9^9,[1]Exch2017!A168:IV168)","v":101.343}]
["Seychelles","Rupee","SCR",{"$f":"LOOKUP(9^9,[1]Exch2017!A169:IV169)","v":13.532}]
["Sierra Leone","Leone","SLL",{"$f":"LOOKUP(9^9,[1]Exch2017!A170:IV170)","v":7250}]
["Singapore","Singapore Dollar","SGD",{"$f":"LOOKUP(9^9,[1]Exch2017!A171:IV171)","v":1.3520000000000001}]
["Slovak Republic","Sl. Koruna","EUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A172:IV172)","v":0.83199999999999996}]
["Slovenia","Euro","EUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A173:IV173)","v":0.83199999999999996}]
["Solomon Islands","S. Is. Dollar","SBD",{"$f":"LOOKUP(9^9,[1]Exch2017!A174:IV174)","v":7.8186}]
["Somalia","Shilling","SOS",{"$f":"LOOKUP(9^9,[1]Exch2017!A175:IV175)","v":24300}]
["South Africa","Rand","ZAR",{"$f":"LOOKUP(9^9,[1]Exch2017!A176:IV176)","v":12.99}]
["South Sudan","South Sudan Pound","SSP",{"$f":"LOOKUP(9^9,[1]Exch2017!A177:IV177)","v":117.44799999999999}]
["Spain","Euro","EUR",{"$f":"LOOKUP(9^9,[1]Exch2017!A178:IV178)","v":0.83199999999999996}]
["Sri Lanka","Rupee","LKR",{"$f":"LOOKUP(9^9,[1]Exch2017!A179:IV179)","v":152.85}]
["Sudan","New Sudanese Pound","SDG",{"$f":"LOOKUP(9^9,[1]Exch2017!A180:IV180)","v":17.984999999999999}]
["Suriname","Suriname Dollar","SRD",{"$f":"LOOKUP(9^9,[1]Exch2017!A181:IV181)","v":7.37}]
["Swaziland","Emalangeni","SZL",{"$f":"LOOKUP(9^9,[1]Exch2017!A182:IV182)","v":12.99}]
["Sweden","Kronor","SEK",{"$f":"LOOKUP(9^9,[1]Exch2017!A183:IV183)","v":7.9279999999999999}]
["Switzerland","Swiss Franc","CHF",{"$f":"LOOKUP(9^9,[1]Exch2017!A184:IV184)","v":0.94599999999999995}]
["Syrian Arab Republic","Pound","SYP",{"$f":"LOOKUP(9^9,[1]Exch2017!A185:IV185)","v":514.85}]
["Tajikistan","Tajik Somoni","TJS",{"$f":"LOOKUP(9^9,[1]Exch2017!A186:IV186)","v":8.8063000000000002}]
["Tanzania, United Rep.","Shilling","TZS",{"$f":"LOOKUP(9^9,[1]Exch2017!A187:IV187)","v":2239.9499999999998}]
["Thailand","Baht","THB",{"$f":"LOOKUP(9^9,[1]Exch2017!A188:IV188)","v":33.17}]
["Togo","CFA Franc","XOF",{"$f":"LOOKUP(9^9,[1]Exch2017!A189:IV189)","v":545.67600000000004}]
["Tonga","Pa'anga","TOP",{"$f":"LOOKUP(9^9,[1]Exch2017!A190:IV190)","v":2.1408999999999998}]
["Trinidad and Tobago","T.& T. Dollar","TTD",{"$f":"LOOKUP(9^9,[1]Exch2017!A191:IV191)","v":6.7496999999999998}]
["Tunisia","Dinar","TND",{"$f":"LOOKUP(9^9,[1]Exch2017!A192:IV192)","v":2.4432}]
["Turkey","(New) Turkish Lira","TRY",{"$f":"LOOKUP(9^9,[1]Exch2017!A193:IV193)","v":3.4430999999999998}]
["Turkmenistan","T. Manat","TMT",{"$f":"LOOKUP(9^9,[1]Exch2017!A194:IV194)","v":3.5}]
["Tuvalu","Australian Dollar","AUD",{"$f":"LOOKUP(9^9,[1]Exch2017!A195:IV195)","v":1.2549999999999999}]
["Uganda","Shilling","UGX",{"$f":"LOOKUP(9^9,[1]Exch2017!A196:IV196)","v":3601.21}]
["Ukraine","Hryvna","UAH",{"$f":"LOOKUP(9^9,[1]Exch2017!A197:IV197)","v":25.55}]
["United Arab Emirates","Dirham","AED",{"$f":"LOOKUP(9^9,[1]Exch2017!A198:IV198)","v":3.673}]
["United Kingdom","Pound","GBP",{"$f":"LOOKUP(9^9,[1]Exch2017!A199:IV199)","v":0.77300000000000002}]
["U.S.A.","Dollar","USD",{"$f":"LOOKUP(9^9,[1]Exch2017!A200:IV200)","v":1}]
["Uruguay","Peso","UYU",{"$f":"LOOKUP(9^9,[1]Exch2017!A201:IV201)","v":28.785}]
["Uzbekistan","Som","UZS",{"$f":"LOOKUP(9^9,[1]Exch2017!A202:IV202)","v":4210.3500000000004}]
["Vanuatu","Vatu","VUV",{"$f":"LOOKUP(9^9,[1]Exch2017!A203:IV203)","v":103.33}]
["Venezuela","Bolivares","VEF",{"$f":"LOOKUP(9^9,[1]Exch2017!A204:IV204)","v":2955.1689999999999}]
["Viet Nam","Dong","VND",{"$f":"LOOKUP(9^9,[1]Exch2017!A205:IV205)","v":22732}]
["Windward Is.","EC Dollar","XCD",{"$f":"LOOKUP(9^9,[1]Exch2017!A206:IV206)","v":2.7}]
["Yemen, Rep. of","Rial","YER",{"$f":"LOOKUP(9^9,[1]Exch2017!A207:IV207)","v":359.59}]
["Zambia","Zambia Kwacha (new) ","ZMW",{"$f":"LOOKUP(9^9,[1]Exch2017!A208:IV208)","v":9.0500000000000007}]
["Zimbabwe","Zimbabwe Dollar","ZWL",{"$f":"LOOKUP(9^9,[1]Exch2017!A209:IV209)","v":15000}]
[]
[]
[]
["http://bfm.hq.int.unesco.org/BFM%20Resources/02.%20Treasury%20(TRS)/U.N.%20Exchange%20Rates/Exch2017.xlsx"]