{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["Intro","Cover","Expense_Entry","Reim_Summary","Reim_Detail","ExpenseDB","NonReim_Summary","NonReim_Detail","Rules","ChangeLog"],"not_rendered":{"defined_names":40,"comments":2,"pivot_tables":4},"read":"whole","date_system":"1900"}

{"sheet":"Intro","index":0,"n_rows":20,"n_cols":2,"rows_kept":20}
["Expenses"]
["Multicurrency Expense Form With Automatic Categorisation Summary"]
["Description:","This expense tracking form is to allow you to capture expenses incurred while performing work for a client; expenses to be reimbursed by the client in that client's home currency, and expenses that will not be reimbursed.  The non-reimbursable expenses reconcile themselves differently since the workbook assumes you will be paying for them in your home currency (which may differ from the client's currency)."]
["Version:",14.2]
["Date:","2011-08-13"]
["Eval:","Take a look at the sample data on the \"Reim_Detail\" worksheets and the way it is presented in the and \"Reim_Summary\" and \"ExpenseDB\" worksheets.  Once you are comfortable with how things look, delete the sample data."]
["Install:","1. Go to the Rules tab and enter your home (that is, reimbursement) currency into the \"Actual\n     Home Currency\" cell."]
[null,"2. Put the template in your MS Office templates folder."]
["Usage:","1. Go to the \"Cover\" worksheet and enter covering detail for the expense report."]
[null,"2. Go to the \"Reim_Detail\" worksheet and enter your client's currency."]
[null,"3. Go to the \"Expense_Entry\" worksheet and enter your expense data; including the actual\n     amount that you were charged by the credit card companies or as a result of currency\n     conversion."]
[null,"          Note 1: green shaded cells are for data entry."]
[null,"          Note 2: the \"Expense_Entry\" worksheet is populated with sample data to demonstrate\n                          how this workbook is used; however, it's setup so that when you navigate there is\n                          you press the [Delete] key then all of the sample data will be erased with a single\n                          key press."]
[null,"4. If you need to insert additional \"Expense_Entry\" rows, you will need to also insert additional\n     rows into the \"Reim_Detail\" and \"ExpenseDB\" worksheet and adjust their formulas."]
[null,"5. Go to the \"Reim_Summary\" and \"ExpenseDB\" worksheets and refresh the crosstabs."]
[null,"6. The \"Reim_Summary\" and \"Reim_Detail\" tabs can be printed together to form a client-facing\n     expense report."]
[null,"7. The \"ExpenseDB\" worksheet should provide you with all the information you might need to\n     enter expense report details into your employer's expense reporting system."]
["Author:","Christopher Rath <christopher@rath.ca>"]
["Copyright:","© 2004–2011 Christopher Rath.  Permission is granted for any use of this template by others as long as this copyright statement is retained and other due and proper credit is provided to the author (that is, don't claim you wrote this template)."]
["Warranty:","This package is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE."]

{"sheet":"Cover","index":1,"n_rows":17,"n_cols":4,"rows_kept":17}
[null,{"$f":"CONCATENATE(\"Expense Report—\",Employee,\" [ Week \",IF(10>WEEKNUM(Trip_Start,1),\"0\",\"\"),WEEKNUM(Trip_Start,1),\" ]\")","v":"Expense Report—Employee Name [ Week 14 ]"}]
[]
[null,"Employee:","Employee Name"]
[null,"Trip Start: ","2004-03-29"]
[null,"Trip End: "]
[null,"Client: ","Client Name"]
[null,"Destination: ","Politsania"]
[null,"Purpose: ","Demo data"]
[null,"Mileage Rate: ",{"v":55.5,"d":"55.5 ¢/mi."}]
[null,"Reimbursement Currency: ","CAD",{"$f":"IF(VLOOKUP(C10,FX_Rate_Tbl,2,FALSE())=1,\"\",\"ERROR: Your reimbursement currency must have an FX Rate of '1' in the table below.\")","v":""}]
[]
[null,null,"Currency","FX Rate"]
[null,null,"CAD",{"v":1,"d":"1.0000"}]
[null,null,"USD",{"v":0.9370314842578711,"d":"0.9370"}]
[null,null,"SGD",{"v":1.2484342379958246,"d":"1.2484"}]
[null,null,"HKG",{"v":7.807807807807808,"d":"7.8078"}]
[null,null,"Other 1"]

{"sheet":"Expense_Entry","index":2,"n_rows":71,"n_cols":11,"rows_kept":71}
[{"$f":"Cover!B1","v":"Expense Report—Employee Name [ Week 14 ]"}]
[]
[{"$f":"Cover!B4","v":"Trip Start: "},{"$f":"Trip_Start","v":"2004-03-29"},null,"Total Amount: ",{"$f":"Total_Est_Reim_Amt","v":{"v":14285.800000000008,"d":"$14,285.80"}},null,"Currency","FX Rate"]
[{"$f":"Cover!B5","v":"Trip End: "},{"$f":"Trip_End","v":"00:00:00"},null,{"$f":"Cover!B10","v":"Reimbursement Currency: "},{"$f":"Reimbursement_Currency","v":"CAD"},{"$f":"IF(H4=1,\"Home→\",\"\")","v":"Home→"},{"$f":"INDEX(Cover!FX_Names,ROW(G4)-3,1)","v":"CAD"},{"$f":"VLOOKUP(G4,Cover!FX_Rate_Tbl,2,FALSE)","v":{"v":1,"d":"1.0000"}}]
[{"$f":"Cover!B6","v":"Client: "},{"$f":"Client","v":"Client Name"},{"$nulls":3},{"$f":"IF(H5=1,\"Home→\",\"\")","v":""},{"$f":"INDEX(Cover!FX_Names,ROW(G5)-3,1)","v":"USD"},{"$f":"VLOOKUP(G5,Cover!FX_Rate_Tbl,2,FALSE)","v":{"v":0.9370314842578711,"d":"0.9370"}}]
[{"$f":"Cover!B7","v":"Destination: "},{"$f":"Destination","v":"Politsania"},{"$nulls":3},"",{"$f":"INDEX(Cover!FX_Names,ROW(G6)-3,1)","v":"SGD"},{"$f":"VLOOKUP(G6,Cover!FX_Rate_Tbl,2,FALSE)","v":{"v":1.2484342379958246,"d":"1.2484"}}]
[{"$f":"Cover!B8","v":"Purpose: "},{"$f":"Purpose","v":"Demo data"},{"$nulls":3},"",{"$f":"INDEX(Cover!FX_Names,ROW(G7)-3,1)","v":"HKG"},{"$f":"VLOOKUP(G7,Cover!FX_Rate_Tbl,2,FALSE)","v":{"v":7.807807807807808,"d":"7.8078"}}]
[{"$nulls":5},"",{"$f":"INDEX(Cover!FX_Names,ROW(G8)-3,1)","v":"Other 1"},{"$f":"VLOOKUP(G8,Cover!FX_Rate_Tbl,2,FALSE)","v":0},null,"In Reimbursement $"]
[{"$nulls":7},"Estimated",null,"Actual"]
["Date","Establishment","Description","Type","Method","Currency","Exp. Amt.","Home Amt.","-","Levied Amt.","Difference"]
["2011-03-11","Mileage","Drive to/from YOW (38 miles)","Mileage","Mileage","USD",{"$f":"38*MileageRate/100","v":{"v":21.09,"d":"$21.09"}},{"$f":"IF(OR(ISBLANK(F11),ISBLANK(G11)),\"\",ROUND(G11/VLOOKUP(F11,FX_Rate_Tbl,2,FALSE),2))","v":{"v":22.51,"d":"$22.51"}},null,{"$f":"VLOOKUP(F11,Cover!FX_Rate_Tbl,2,FALSE)/VLOOKUP(Reimbursement_Currency,Cover!FX_Rate_Tbl,2,FALSE)*G11","v":{"v":19.761994002998502,"d":"$19.76"}},{"$f":"IF(Reimbursement_Currency=F11,0,IF(ISBLANK(J11),STR_TBD,ROUND(J11-H11,2)))","v":{"v":-2.75,"d":"$(2.75)"}}]
["2011-03-11","Ottawa Airport","Parking","Parking","AMEX","CAD",{"v":6,"d":"$6.00"},{"v":6,"d":"$6.00"},null,null,0]
["2011-03-11","Cold Storage","Dinner","Meals","AMEX","SGD",{"v":8.6,"d":"$8.60"},{"v":6.89,"d":"$6.89"},null,{"v":6.82,"d":"$6.82"},{"v":-0.07,"d":"$(0.07)"}]
["2011-03-11","Starbucks","Coffee","Meals","AMEX","SGD",{"v":7.9,"d":"$7.90"},{"v":6.33,"d":"$6.33"},null,{"v":6.27,"d":"$6.27"},{"v":-0.06,"d":"$(0.06)"}]
["2011-03-12","Starbucks","Coffee","Meals","AMEX","CAD",{"v":4.71,"d":"$4.71"},{"v":4.71,"d":"$4.71"},null,null,0]
["2011-03-12","Airport Taxi","Taxi to hotel","Taxi","Cash","CAD",{"v":20,"d":"$20.00"},{"v":20,"d":"$20.00"},null,null,0]
["2011-03-12","YYZ Marriott","Dinner","Meals","AMEX","CAD",{"v":43.42,"d":"$43.42"},{"v":43.42,"d":"$43.42"},null,null,0]
["2011-03-12","YYZ Marriott","Hotel","Hotel","AMEX","CAD",{"$f":"119+15.47","v":{"v":134.47,"d":"$134.47"}},{"v":134.47,"d":"$134.47"},null,null,0]
["2011-03-12","United Airlines","Fly to SIN","Airfare","AMEX","CAD",{"v":11000.81,"d":"$11,000.81"},{"v":11000.81,"d":"$11,000.81"},null,null,0]
["2011-03-13","YYZ Marriott","Tip maid","Hotel","Cash","CAD",{"v":5,"d":"$5.00"},{"v":5,"d":"$5.00"},null,null,0]
["2011-03-13","YYZ Marriott","Laundry","Misc.","Cash","CAD",{"v":2.5,"d":"$2.50"},{"v":2.5,"d":"$2.50"},null,null,0]
["2011-03-13","YYZ Marriott","Tip bellman","Meals","Cash","USD",{"v":1,"d":"$1.00"},{"v":1.07,"d":"$1.07"},null,{"$f":"H22","v":{"v":1.07,"d":"$1.07"}},0]
["2011-03-13","Starbucks","Coffee","Meals","AMEX","CAD",{"v":4.18,"d":"$4.18"},{"v":4.18,"d":"$4.18"},null,null,0]
["2011-03-14","Concorde Hotel","Hotel","Hotel","AMEX","SGD",{"$f":"285+28.5+21.95","v":{"v":335.45,"d":"$335.45"}},{"v":268.7,"d":"$268.70"},null,{"$f":"(1987.73+2160.36)*(G24/5218.37)","v":{"v":266.64969913976967,"d":"$266.65"}},{"v":-2.05,"d":"$(2.05)"}]
["2011-03-15","Starbucks","Coffee","Meals","AMEX","SGD",{"v":7.1,"d":"$7.10"},{"v":5.69,"d":"$5.69"},null,{"$f":"(1987.73+2160.36)*(G25/5218.37)","v":{"v":5.643800458763943,"d":"$5.64"}},{"v":-0.05,"d":"$(0.05)"}]
["2011-03-15","Camera Comp","Laptop power cable","Misc.","AMEX","SGD",{"v":25,"d":"$25.00"},{"v":20.03,"d":"$20.03"},null,{"v":19.872536826633606,"d":"$19.87"},{"v":-0.16,"d":"$(0.16)"}]
["2011-03-15","SingTel","Data SIM","Phone","AMEX","SGD",{"v":18,"d":"$18.00"},{"v":14.42,"d":"$14.42"},null,{"v":14.308226515176196,"d":"$14.31"},{"v":-0.11,"d":"$(0.11)"}]
["2011-03-15","Citycab","Taxi to hotel","Taxi","AMEX","SGD",{"v":30.55,"d":"$30.55"},{"v":24.47,"d":"$24.47"},null,{"v":24.284240002146266,"d":"$24.28"},{"v":-0.19,"d":"$(0.19)"}]
["2011-03-15","Concorde Hotel","Hotel","Hotel","AMEX","SGD",{"$f":"285+28.5+21.95","v":{"v":335.45,"d":"$335.45"}},{"v":268.7,"d":"$268.70"},null,{"v":266.64969913976967,"d":"$266.65"},{"v":-2.05,"d":"$(2.05)"}]
["2011-03-15","SingTel","Lunch","Meals","Cash","SGD",{"v":2.8,"d":"$2.80"},{"v":2.24,"d":"$2.24"},null,{"v":2.2257241245829635,"d":"$2.23"},{"v":-0.01,"d":"$(0.01)"}]
["2011-03-16","Starbucks","Coffee","Meals","AMEX","SGD",{"v":7.1,"d":"$7.10"},{"v":5.69,"d":"$5.69"},null,{"v":5.643800458763943,"d":"$5.64"},{"v":-0.05,"d":"$(0.05)"}]
["2011-03-16","McDonald's","Dinner","Meals","Cash","SGD",{"v":2.3,"d":"$2.30"},{"v":1.84,"d":"$1.84"},null,{"v":1.8282733880502915,"d":"$1.83"},{"v":-0.01,"d":"$(0.01)"}]
["2011-03-16","Cold Storage","Dinner","Meals","AMEX","SGD",{"v":13.8,"d":"$13.80"},{"v":11.05,"d":"$11.05"},null,{"v":10.96964032830175,"d":"$10.97"},{"v":-0.08,"d":"$(0.08)"}]
["2011-03-16","Concorde Hotel","Hotel","Hotel","AMEX","SGD",{"$f":"285+28.5+21.95","v":{"v":335.45,"d":"$335.45"}},{"v":268.7,"d":"$268.70"},null,{"v":266.64969913976967,"d":"$266.65"},{"v":-2.05,"d":"$(2.05)"}]
["2011-03-16","SingTel","Lunch","Meals","Cash","SGD",{"v":30,"d":"$30.00"},{"v":24.03,"d":"$24.03"},null,{"v":23.847044191960325,"d":"$23.85"},{"v":-0.18,"d":"$(0.18)"}]
["2011-03-17","Starbucks","Coffee","Meals","AMEX","SGD",{"v":7.1,"d":"$7.10"},{"v":5.69,"d":"$5.69"},null,{"v":5.643800458763943,"d":"$5.64"},{"v":-0.05,"d":"$(0.05)"}]
["2011-03-17","Cold Storage","Dinner","Meals","AMEX","SGD",{"v":8.1,"d":"$8.10"},{"v":6.49,"d":"$6.49"},null,{"v":6.4387019318292875,"d":"$6.44"},{"v":-0.05,"d":"$(0.05)"}]
["2011-03-17","Concorde Hotel","Hotel","Hotel","AMEX","SGD",{"$f":"285+28.5+21.95","v":{"v":335.45,"d":"$335.45"}},{"v":268.7,"d":"$268.70"},null,{"v":266.64969913976967,"d":"$266.65"},{"v":-2.05,"d":"$(2.05)"}]
["2011-03-17","Concorde Hotel","Laundry","Misc.","AMEX","SGD",{"$f":"27.6+2.76+2.13","v":{"v":32.49,"d":"$32.49"}},{"v":26.02,"d":"$26.02"},null,{"v":25.826348859893034,"d":"$25.83"},{"v":-0.19,"d":"$(0.19)"}]
["2011-03-17","Concorde Hotel","Telephone","Phone","AMEX","SGD",{"v":0.43,"d":"$0.43"},{"v":0.34,"d":"$0.34"},null,{"v":0.341807633418098,"d":"$0.34"},0]
["2011-03-17","Concorde Hotel","Dinner","Meals","AMEX","SGD",{"$f":"13+10+2.3+1.77","v":{"v":27.07,"d":"$27.07"}},{"v":21.68,"d":"$21.68"},null,{"v":21.517982875878868,"d":"$21.52"},{"v":-0.16,"d":"$(0.16)"}]
["2011-03-17","SingTel","Lunch","Meals","Cash","SGD",{"v":2,"d":"$2.00"},{"v":1.6,"d":"$1.60"},null,{"v":1.5898029461306884,"d":"$1.59"},{"v":-0.01,"d":"$(0.01)"}]
["2011-03-18","Youniqe Bistro","Coffee","Meals","Cash","SGD",{"v":3.2,"d":"$3.20"},{"$f":"IF(OR(ISBLANK(F43),ISBLANK(G43)),\"\",ROUND(G43/VLOOKUP(F43,FX_Rate_Tbl,2,FALSE),2))","v":{"v":2.56,"d":"$2.56"}},null,{"v":2.543684713809102,"d":"$2.54"},{"$f":"IF(Reimbursement_Currency=F43,0,IF(ISBLANK(J43),STR_TBD,ROUND(J43-H43,2)))","v":{"v":-0.02,"d":"$(0.02)"}}]
["2011-03-18","Starbucks","Coffee","Meals","AMEX","SGD",{"v":7.1,"d":"$7.10"},{"v":5.69,"d":"$5.69"},null,{"v":5.643800458763943,"d":"$5.64"},{"v":-0.05,"d":"$(0.05)"}]
["2011-03-18","CS Centrepoint","Dinner","Meals","Cash","SGD",{"v":3.4,"d":"$3.40"},{"v":2.72,"d":"$2.72"},null,{"v":2.70266500842217,"d":"$2.70"},{"v":-0.02,"d":"$(0.02)"}]
["2011-03-18","SingTel","Data SIM","Phone","VISA","SGD",{"v":18,"d":"$18.00"},{"v":14.42,"d":"$14.42"},null,{"v":14.308226515176196,"d":"$14.31"},{"v":-0.11,"d":"$(0.11)"}]
["2011-03-18","Cold Storage","Dinner","Meals","AMEX","SGD",{"v":19.9,"d":"$19.90"},{"v":15.94,"d":"$15.94"},null,{"v":15.818539314000349,"d":"$15.82"},{"v":-0.12,"d":"$(0.12)"}]
["2011-03-18","Concorde Hotel","Hotel","Hotel","AMEX","SGD",{"$f":"285+28.5+21.95","v":{"v":335.45,"d":"$335.45"}},{"v":268.7,"d":"$268.70"},null,{"v":266.64969913976967,"d":"$266.65"},{"v":-2.05,"d":"$(2.05)"}]
["2011-03-18","SingTel","Lunch","Meals","Cash","SGD",{"v":10,"d":"$10.00"},{"v":8.01,"d":"$8.01"},null,{"v":7.949014730653443,"d":"$7.95"},{"v":-0.06,"d":"$(0.06)"}]
["2011-03-19","Concorde Hotel","Hotel","Hotel","AMEX","SGD",{"$f":"285+28.5+21.95","v":{"v":335.45,"d":"$335.45"}},{"v":268.7,"d":"$268.70"},null,{"v":266.64969913976967,"d":"$266.65"},{"v":-2.05,"d":"$(2.05)"}]
["2011-03-19","Starbucks","Coffee","Meals","AMEX","SGD",{"v":5.5,"d":"$5.50"},{"v":4.41,"d":"$4.41"},null,{"v":4.371958101859393,"d":"$4.37"},{"v":-0.04,"d":"$(0.04)"}]
["2011-03-19","Cold Storage","Snack","Meals","Cash","SGD",{"v":6.6,"d":"$6.60"},{"v":5.29,"d":"$5.29"},null,{"v":5.246349722231272,"d":"$5.25"},{"v":-0.04,"d":"$(0.04)"}]
["2011-03-20","Concorde Hotel","Hotel","Hotel","AMEX","SGD",{"$f":"285+28.5+21.95","v":{"v":335.45,"d":"$335.45"}},{"v":268.7,"d":"$268.70"},null,{"v":266.64969913976967,"d":"$266.65"},{"v":-2.05,"d":"$(2.05)"}]
["2011-03-20","Starbucks","Coffee","Meals","AMEX","SGD",{"v":8.7,"d":"$8.70"},{"v":6.97,"d":"$6.97"},null,{"v":6.915642815668494,"d":"$6.92"},{"v":-0.05,"d":"$(0.05)"}]
["2011-03-20","Starbucks","Coffee","Meals","AMEX","SGD",{"v":5.8,"d":"$5.80"},{"v":4.65,"d":"$4.65"},null,{"v":4.610428543778997,"d":"$4.61"},{"v":-0.04,"d":"$(0.04)"}]
["2011-03-20","Starbucks","Tip","Meals","Cash","SGD",{"v":2.2,"d":"$2.20"},{"v":1.76,"d":"$1.76"},null,{"v":1.7487832407437574,"d":"$1.75"},{"v":-0.01,"d":"$(0.01)"}]
["2011-03-21","Concorde Hotel","Hotel","Hotel","AMEX","SGD",{"$f":"285+28.5+21.95","v":{"v":335.45,"d":"$335.45"}},{"v":268.7,"d":"$268.70"},null,{"v":266.64969913976967,"d":"$266.65"},{"v":-2.05,"d":"$(2.05)"}]
["2011-03-21","Concorde Hotel","Laundry","Misc.","AMEX","SGD",{"$f":"27.6+2.76+2.13","v":{"v":32.49,"d":"$32.49"}},{"v":26.02,"d":"$26.02"},null,{"v":25.826348859893034,"d":"$25.83"},{"v":-0.19,"d":"$(0.19)"}]
["2011-03-21","SingTel","BoM","Phone","AMEX","SGD",{"v":18,"d":"$18.00"},{"v":14.42,"d":"$14.42"},null,{"v":14.308226515176196,"d":"$14.31"},{"v":-0.11,"d":"$(0.11)"}]
["2011-03-21","Starbucks","Coffee","Meals","AMEX","SGD",{"v":7.1,"d":"$7.10"},{"v":5.69,"d":"$5.69"},null,{"v":5.643800458763943,"d":"$5.64"},{"v":-0.05,"d":"$(0.05)"}]
["2011-03-21","Cold Storage","Water","Meals","Cash","SGD",{"v":2.15,"d":"$2.15"},{"v":1.72,"d":"$1.72"},null,{"v":1.70903816709049,"d":"$1.71"},{"v":-0.01,"d":"$(0.01)"}]
["2011-03-21","SingTel","Lunch","Meals","Cash","SGD",{"v":2.8,"d":"$2.80"},{"v":2.24,"d":"$2.24"},null,{"v":2.2257241245829635,"d":"$2.23"},{"v":-0.01,"d":"$(0.01)"}]
["2011-03-22","Concorde Hotel","Hotel","Hotel","AMEX","SGD",{"$f":"285+28.5+21.95","v":{"v":335.45,"d":"$335.45"}},{"v":268.7,"d":"$268.70"},null,{"v":266.64969913976967,"d":"$266.65"},{"v":-2.05,"d":"$(2.05)"}]
["2011-03-22","Starbucks","Coffee","Meals","AMEX","SGD",{"v":7.1,"d":"$7.10"},{"v":5.69,"d":"$5.69"},null,{"v":5.643800458763943,"d":"$5.64"},{"v":-0.05,"d":"$(0.05)"}]
["2011-03-22","Cold Storage","Dinner","Meals","AMEX","SGD",{"v":26.5,"d":"$26.50"},{"v":21.23,"d":"$21.23"},null,{"v":21.06488903623162,"d":"$21.06"},{"v":-0.17,"d":"$(0.17)"}]
["2011-03-22","SingTel","Lunch","Meals","Cash","SGD",{"v":5.5,"d":"$5.50"},{"v":4.41,"d":"$4.41"},null,{"v":4.371958101859393,"d":"$4.37"},{"v":-0.04,"d":"$(0.04)"}]
["2011-03-23","Concorde Hotel","Hotel","Hotel","AMEX","SGD",{"$f":"285+28.5+21.95","v":{"v":335.45,"d":"$335.45"}},{"v":268.7,"d":"$268.70"},null,{"v":266.64969913976967,"d":"$266.65"},{"v":-2.05,"d":"$(2.05)"}]
["2011-03-23","Starbucks","Coffee","Meals","AMEX","SGD",{"v":7.9,"d":"$7.90"},{"v":6.33,"d":"$6.33"},null,{"v":6.27972163721622,"d":"$6.28"},{"v":-0.05,"d":"$(0.05)"}]
["2011-03-23","Burger King","Lunch","Meals","Cash","SGD",{"v":7.65,"d":"$7.65"},{"v":6.13,"d":"$6.13"},null,{"v":6.0809962689498835,"d":"$6.08"},{"v":-0.05,"d":"$(0.05)"}]
["2011-03-23","Starbucks","Coffee","Meals","AMEX","HKG",{"v":26,"d":"$26.00"},{"v":3.33,"d":"$3.33"},null,{"v":3.33,"d":"$3.33"},0]
[{"$nulls":6},"Total: ",{"$f":"SUM(H11:H70)","v":{"v":14285.800000000008,"d":"$14,285.80"}},null,"B/W: ",{"$f":"SUM(K11:K70)","v":{"v":-25.970000000000006,"d":"$(25.97)"}}]

{"sheet":"Reim_Summary","index":3,"n_rows":24,"n_cols":11,"rows_kept":24}
[null,{"$f":"Reim_Detail!A1","v":"Expense Report—Employee Name [ Week 14 ]"}]
[]
[null,{"$f":"Cover!B4","v":"Trip Start: "},{"$f":"Trip_Start","v":"2004-03-29"},{"$nulls":3},{"$f":"Reim_Detail!D3","v":"Total Amount: "},{"$f":"Total_Est_Client_Amt","v":{"v":17834.82000000001,"d":"$17,834.82"}}]
[null,{"$f":"Cover!B5","v":"Trip End: "},{"$f":"Trip_End","v":"00:00:00"},{"$nulls":3},{"$f":"Reim_Detail!D4","v":"Client Currency: "},{"$f":"Client_Currency","v":"SGD"}]
[null,{"$f":"Cover!B6","v":"Client: "},{"$f":"Client","v":"Client Name"}]
[null,{"$f":"Cover!B7","v":"Destination: "},{"$f":"Destination","v":"Politsania"}]
[null,{"$f":"Cover!B8","v":"Purpose: "},{"$f":"Purpose","v":"Demo data"}]
[]
[null,"Sum of Client Amt.","Type"]
[null,"Date","Airfare","Hotel","Meals","Mileage","Misc.","Parking","Phone","Taxi","Grand Total"]
[null,"2011-03-11",null,null,{"v":16.5,"d":"$16.50"},{"v":25.82,"d":"$25.82"},null,{"v":7.49,"d":"$7.49"},null,null,{"v":49.81,"d":"$49.81"}]
[null,"2011-03-12",{"v":13733.79,"d":"$13,733.79"},{"v":167.88,"d":"$167.88"},{"v":60.09,"d":"$60.09"},{"$nulls":4},{"v":24.97,"d":"$24.97"},{"v":13986.73,"d":"$13,986.73"}]
[null,"2011-03-13",null,{"v":6.24,"d":"$6.24"},{"v":6.55,"d":"$6.55"},null,{"v":3.12,"d":"$3.12"},{"$nulls":3},{"v":15.91,"d":"$15.91"}]
[null,"2011-03-14",null,{"v":335.45,"d":"$335.45"},{"$nulls":6},{"v":335.45,"d":"$335.45"}]
[null,"2011-03-15",null,{"v":335.45,"d":"$335.45"},{"v":9.899999999999999,"d":"$9.90"},null,{"v":25,"d":"$25.00"},null,{"v":18,"d":"$18.00"},{"v":30.55,"d":"$30.55"},{"v":418.9,"d":"$418.90"}]
[null,"2011-03-16",null,{"v":335.45,"d":"$335.45"},{"v":53.2,"d":"$53.20"},{"$nulls":5},{"v":388.65,"d":"$388.65"}]
[null,"2011-03-17",null,{"v":335.45,"d":"$335.45"},{"v":44.269999999999996,"d":"$44.27"},null,{"v":32.49,"d":"$32.49"},null,{"v":0.43,"d":"$0.43"},null,{"v":412.64,"d":"$412.64"}]
[null,"2011-03-18",null,{"v":335.45,"d":"$335.45"},{"v":43.6,"d":"$43.60"},{"$nulls":3},{"v":18,"d":"$18.00"},null,{"v":397.05,"d":"$397.05"}]
[null,"2011-03-19",null,{"v":335.45,"d":"$335.45"},{"v":12.1,"d":"$12.10"},{"$nulls":5},{"v":347.55,"d":"$347.55"}]
[null,"2011-03-20",null,{"v":335.45,"d":"$335.45"},{"v":16.7,"d":"$16.70"},{"$nulls":5},{"v":352.15,"d":"$352.15"}]
[null,"2011-03-21",null,{"v":335.45,"d":"$335.45"},{"v":12.05,"d":"$12.05"},null,{"v":32.49,"d":"$32.49"},null,{"v":18,"d":"$18.00"},null,{"v":397.99,"d":"$397.99"}]
[null,"2011-03-22",null,{"v":335.45,"d":"$335.45"},{"v":39.1,"d":"$39.10"},{"$nulls":5},{"v":374.55,"d":"$374.55"}]
[null,"2011-03-23",null,{"v":335.45,"d":"$335.45"},{"v":19.71,"d":"$19.71"},{"$nulls":5},{"v":355.15999999999997,"d":"$355.16"}]
[null,"Grand Total",{"v":13733.79,"d":"$13,733.79"},{"v":3528.6199999999994,"d":"$3,528.62"},{"v":333.77,"d":"$333.77"},{"v":25.82,"d":"$25.82"},{"v":93.1,"d":"$93.10"},{"v":7.49,"d":"$7.49"},{"v":54.43,"d":"$54.43"},{"v":55.519999999999996,"d":"$55.52"},{"v":17832.539999999997,"d":"$17,832.54"}]

{"sheet":"Reim_Detail","index":4,"n_rows":71,"n_cols":8,"rows_kept":71}
[{"$f":"Cover!B1","v":"Expense Report—Employee Name [ Week 14 ]"}]
[]
[{"$f":"Cover!B4","v":"Trip Start: "},{"$f":"Trip_Start","v":"2004-03-29"},null,"Total Amount: ",{"$f":"Total_Est_Client_Amt","v":{"v":17834.82000000001,"d":"$17,834.82"}},null,"Currency","FX Rate"]
[{"$f":"Cover!B5","v":"Trip End: "},{"$f":"Trip_End","v":"00:00:00"},null,"Client Currency: ","SGD",{"$f":"IF(H4=1,\"Client→\",\"\")","v":""},{"$f":"INDEX(Cover!FX_Names,ROW(G4)-3,1)","v":"CAD"},{"$f":"VLOOKUP(G4,Cover!FX_Rate_Tbl,2,FALSE)/VLOOKUP(Client_Currency,Cover!FX_Rate_Tbl,2,FALSE)","v":{"v":0.8010033444816054,"d":"0.8010"}}]
[{"$f":"Cover!B6","v":"Client: "},{"$f":"Client","v":"Client Name"},{"$nulls":3},{"$f":"IF(H5=1,\"Client→\",\"\")","v":""},{"$f":"INDEX(Cover!FX_Names,ROW(G5)-3,1)","v":"USD"},{"$f":"VLOOKUP(G5,Cover!FX_Rate_Tbl,2,FALSE)/VLOOKUP(Client_Currency,Cover!FX_Rate_Tbl,2,FALSE)","v":{"v":0.7505653527751175,"d":"0.7506"}}]
[{"$f":"Cover!B7","v":"Destination: "},{"$f":"Destination","v":"Politsania"},{"$nulls":3},"Client→",{"$f":"INDEX(Cover!FX_Names,ROW(G6)-3,1)","v":"SGD"},{"$f":"VLOOKUP(G6,Cover!FX_Rate_Tbl,2,FALSE)/VLOOKUP(Client_Currency,Cover!FX_Rate_Tbl,2,FALSE)","v":{"v":1,"d":"1.0000"}}]
[{"$f":"Cover!B8","v":"Purpose: "},{"$f":"Purpose","v":"Demo data"},{"$nulls":3},"",{"$f":"INDEX(Cover!FX_Names,ROW(G7)-3,1)","v":"HKG"},{"$f":"VLOOKUP(G7,Cover!FX_Rate_Tbl,2,FALSE)/VLOOKUP(Client_Currency,Cover!FX_Rate_Tbl,2,FALSE)","v":{"v":6.254080167123646,"d":"6.2541"}}]
[{"$nulls":5},"",{"$f":"INDEX(Cover!FX_Names,ROW(G8)-3,1)","v":"Other 1"},{"$f":"VLOOKUP(G8,Cover!FX_Rate_Tbl,2,FALSE)/VLOOKUP(Client_Currency,Cover!FX_Rate_Tbl,2,FALSE)","v":0}]
[{"$nulls":7},"Calculated"]
["Date","Establishment","Description","Type","Method","Currency","Exp. Amt.","Client Amt."]
[{"$f":"IF(ISBLANK(Expense_Entry!A11),\"\",Expense_Entry!A11)","v":"2011-03-11"},{"$f":"IF(ISBLANK(Expense_Entry!B11),\"\",Expense_Entry!B11)","v":"Mileage"},{"$f":"IF(ISBLANK(Expense_Entry!C11),\"\",Expense_Entry!C11)","v":"Drive to/from YOW (38 miles)"},{"$f":"IF(ISBLANK(Expense_Entry!D11),\"\",Expense_Entry!D11)","v":"Mileage"},{"$f":"IF(ISBLANK(Expense_Entry!E11),\"\",Expense_Entry!E11)","v":"Mileage"},{"$f":"IF(ISBLANK(Expense_Entry!F11),\"\",Expense_Entry!F11)","v":"USD"},{"$f":"IF(ISBLANK(Expense_Entry!G11),\"\",Expense_Entry!G11)","v":{"v":21.09,"d":"$21.09"}},{"$f":"IF(OR(F11=\"\",G11=\"\"),\"\",ROUND(G11/VLOOKUP(F11,FX_Rate_Tbl,2,FALSE),2))","v":{"v":28.1,"d":"$28.10"}}]
[{"$f":"IF(ISBLANK(Expense_Entry!A12),\"\",Expense_Entry!A12)","v":"2011-03-11"},{"$f":"IF(ISBLANK(Expense_Entry!B12),\"\",Expense_Entry!B12)","v":"Ottawa Airport"},{"$f":"IF(ISBLANK(Expense_Entry!C12),\"\",Expense_Entry!C12)","v":"Parking"},{"$f":"IF(ISBLANK(Expense_Entry!D12),\"\",Expense_Entry!D12)","v":"Parking"},{"$f":"IF(ISBLANK(Expense_Entry!E12),\"\",Expense_Entry!E12)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F12),\"\",Expense_Entry!F12)","v":"CAD"},{"$f":"IF(ISBLANK(Expense_Entry!G12),\"\",Expense_Entry!G12)","v":{"v":6,"d":"$6.00"}},{"v":7.49,"d":"$7.49"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A13),\"\",Expense_Entry!A13)","v":"2011-03-11"},{"$f":"IF(ISBLANK(Expense_Entry!B13),\"\",Expense_Entry!B13)","v":"Cold Storage"},{"$f":"IF(ISBLANK(Expense_Entry!C13),\"\",Expense_Entry!C13)","v":"Dinner"},{"$f":"IF(ISBLANK(Expense_Entry!D13),\"\",Expense_Entry!D13)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E13),\"\",Expense_Entry!E13)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F13),\"\",Expense_Entry!F13)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G13),\"\",Expense_Entry!G13)","v":{"v":8.6,"d":"$8.60"}},{"v":8.6,"d":"$8.60"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A14),\"\",Expense_Entry!A14)","v":"2011-03-11"},{"$f":"IF(ISBLANK(Expense_Entry!B14),\"\",Expense_Entry!B14)","v":"Starbucks"},{"$f":"IF(ISBLANK(Expense_Entry!C14),\"\",Expense_Entry!C14)","v":"Coffee"},{"$f":"IF(ISBLANK(Expense_Entry!D14),\"\",Expense_Entry!D14)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E14),\"\",Expense_Entry!E14)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F14),\"\",Expense_Entry!F14)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G14),\"\",Expense_Entry!G14)","v":{"v":7.9,"d":"$7.90"}},{"v":7.9,"d":"$7.90"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A15),\"\",Expense_Entry!A15)","v":"2011-03-12"},{"$f":"IF(ISBLANK(Expense_Entry!B15),\"\",Expense_Entry!B15)","v":"Starbucks"},{"$f":"IF(ISBLANK(Expense_Entry!C15),\"\",Expense_Entry!C15)","v":"Coffee"},{"$f":"IF(ISBLANK(Expense_Entry!D15),\"\",Expense_Entry!D15)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E15),\"\",Expense_Entry!E15)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F15),\"\",Expense_Entry!F15)","v":"CAD"},{"$f":"IF(ISBLANK(Expense_Entry!G15),\"\",Expense_Entry!G15)","v":{"v":4.71,"d":"$4.71"}},{"v":5.88,"d":"$5.88"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A16),\"\",Expense_Entry!A16)","v":"2011-03-12"},{"$f":"IF(ISBLANK(Expense_Entry!B16),\"\",Expense_Entry!B16)","v":"Airport Taxi"},{"$f":"IF(ISBLANK(Expense_Entry!C16),\"\",Expense_Entry!C16)","v":"Taxi to hotel"},{"$f":"IF(ISBLANK(Expense_Entry!D16),\"\",Expense_Entry!D16)","v":"Taxi"},{"$f":"IF(ISBLANK(Expense_Entry!E16),\"\",Expense_Entry!E16)","v":"Cash"},{"$f":"IF(ISBLANK(Expense_Entry!F16),\"\",Expense_Entry!F16)","v":"CAD"},{"$f":"IF(ISBLANK(Expense_Entry!G16),\"\",Expense_Entry!G16)","v":{"v":20,"d":"$20.00"}},{"v":24.97,"d":"$24.97"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A17),\"\",Expense_Entry!A17)","v":"2011-03-12"},{"$f":"IF(ISBLANK(Expense_Entry!B17),\"\",Expense_Entry!B17)","v":"YYZ Marriott"},{"$f":"IF(ISBLANK(Expense_Entry!C17),\"\",Expense_Entry!C17)","v":"Dinner"},{"$f":"IF(ISBLANK(Expense_Entry!D17),\"\",Expense_Entry!D17)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E17),\"\",Expense_Entry!E17)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F17),\"\",Expense_Entry!F17)","v":"CAD"},{"$f":"IF(ISBLANK(Expense_Entry!G17),\"\",Expense_Entry!G17)","v":{"v":43.42,"d":"$43.42"}},{"v":54.21,"d":"$54.21"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A18),\"\",Expense_Entry!A18)","v":"2011-03-12"},{"$f":"IF(ISBLANK(Expense_Entry!B18),\"\",Expense_Entry!B18)","v":"YYZ Marriott"},{"$f":"IF(ISBLANK(Expense_Entry!C18),\"\",Expense_Entry!C18)","v":"Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!D18),\"\",Expense_Entry!D18)","v":"Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!E18),\"\",Expense_Entry!E18)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F18),\"\",Expense_Entry!F18)","v":"CAD"},{"$f":"IF(ISBLANK(Expense_Entry!G18),\"\",Expense_Entry!G18)","v":{"v":134.47,"d":"$134.47"}},{"v":167.88,"d":"$167.88"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A19),\"\",Expense_Entry!A19)","v":"2011-03-12"},{"$f":"IF(ISBLANK(Expense_Entry!B19),\"\",Expense_Entry!B19)","v":"United Airlines"},{"$f":"IF(ISBLANK(Expense_Entry!C19),\"\",Expense_Entry!C19)","v":"Fly to SIN"},{"$f":"IF(ISBLANK(Expense_Entry!D19),\"\",Expense_Entry!D19)","v":"Airfare"},{"$f":"IF(ISBLANK(Expense_Entry!E19),\"\",Expense_Entry!E19)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F19),\"\",Expense_Entry!F19)","v":"CAD"},{"$f":"IF(ISBLANK(Expense_Entry!G19),\"\",Expense_Entry!G19)","v":{"v":11000.81,"d":"$11,000.81"}},{"v":13733.79,"d":"$13,733.79"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A20),\"\",Expense_Entry!A20)","v":"2011-03-13"},{"$f":"IF(ISBLANK(Expense_Entry!B20),\"\",Expense_Entry!B20)","v":"YYZ Marriott"},{"$f":"IF(ISBLANK(Expense_Entry!C20),\"\",Expense_Entry!C20)","v":"Tip maid"},{"$f":"IF(ISBLANK(Expense_Entry!D20),\"\",Expense_Entry!D20)","v":"Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!E20),\"\",Expense_Entry!E20)","v":"Cash"},{"$f":"IF(ISBLANK(Expense_Entry!F20),\"\",Expense_Entry!F20)","v":"CAD"},{"$f":"IF(ISBLANK(Expense_Entry!G20),\"\",Expense_Entry!G20)","v":{"v":5,"d":"$5.00"}},{"v":6.24,"d":"$6.24"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A21),\"\",Expense_Entry!A21)","v":"2011-03-13"},{"$f":"IF(ISBLANK(Expense_Entry!B21),\"\",Expense_Entry!B21)","v":"YYZ Marriott"},{"$f":"IF(ISBLANK(Expense_Entry!C21),\"\",Expense_Entry!C21)","v":"Laundry"},{"$f":"IF(ISBLANK(Expense_Entry!D21),\"\",Expense_Entry!D21)","v":"Misc."},{"$f":"IF(ISBLANK(Expense_Entry!E21),\"\",Expense_Entry!E21)","v":"Cash"},{"$f":"IF(ISBLANK(Expense_Entry!F21),\"\",Expense_Entry!F21)","v":"CAD"},{"$f":"IF(ISBLANK(Expense_Entry!G21),\"\",Expense_Entry!G21)","v":{"v":2.5,"d":"$2.50"}},{"v":3.12,"d":"$3.12"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A22),\"\",Expense_Entry!A22)","v":"2011-03-13"},{"$f":"IF(ISBLANK(Expense_Entry!B22),\"\",Expense_Entry!B22)","v":"YYZ Marriott"},{"$f":"IF(ISBLANK(Expense_Entry!C22),\"\",Expense_Entry!C22)","v":"Tip bellman"},{"$f":"IF(ISBLANK(Expense_Entry!D22),\"\",Expense_Entry!D22)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E22),\"\",Expense_Entry!E22)","v":"Cash"},{"$f":"IF(ISBLANK(Expense_Entry!F22),\"\",Expense_Entry!F22)","v":"USD"},{"$f":"IF(ISBLANK(Expense_Entry!G22),\"\",Expense_Entry!G22)","v":{"v":1,"d":"$1.00"}},{"v":1.33,"d":"$1.33"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A23),\"\",Expense_Entry!A23)","v":"2011-03-13"},{"$f":"IF(ISBLANK(Expense_Entry!B23),\"\",Expense_Entry!B23)","v":"Starbucks"},{"$f":"IF(ISBLANK(Expense_Entry!C23),\"\",Expense_Entry!C23)","v":"Coffee"},{"$f":"IF(ISBLANK(Expense_Entry!D23),\"\",Expense_Entry!D23)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E23),\"\",Expense_Entry!E23)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F23),\"\",Expense_Entry!F23)","v":"CAD"},{"$f":"IF(ISBLANK(Expense_Entry!G23),\"\",Expense_Entry!G23)","v":{"v":4.18,"d":"$4.18"}},{"v":5.22,"d":"$5.22"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A24),\"\",Expense_Entry!A24)","v":"2011-03-14"},{"$f":"IF(ISBLANK(Expense_Entry!B24),\"\",Expense_Entry!B24)","v":"Concorde Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!C24),\"\",Expense_Entry!C24)","v":"Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!D24),\"\",Expense_Entry!D24)","v":"Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!E24),\"\",Expense_Entry!E24)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F24),\"\",Expense_Entry!F24)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G24),\"\",Expense_Entry!G24)","v":{"v":335.45,"d":"$335.45"}},{"v":335.45,"d":"$335.45"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A25),\"\",Expense_Entry!A25)","v":"2011-03-15"},{"$f":"IF(ISBLANK(Expense_Entry!B25),\"\",Expense_Entry!B25)","v":"Starbucks"},{"$f":"IF(ISBLANK(Expense_Entry!C25),\"\",Expense_Entry!C25)","v":"Coffee"},{"$f":"IF(ISBLANK(Expense_Entry!D25),\"\",Expense_Entry!D25)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E25),\"\",Expense_Entry!E25)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F25),\"\",Expense_Entry!F25)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G25),\"\",Expense_Entry!G25)","v":{"v":7.1,"d":"$7.10"}},{"v":7.1,"d":"$7.10"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A26),\"\",Expense_Entry!A26)","v":"2011-03-15"},{"$f":"IF(ISBLANK(Expense_Entry!B26),\"\",Expense_Entry!B26)","v":"Camera Comp"},{"$f":"IF(ISBLANK(Expense_Entry!C26),\"\",Expense_Entry!C26)","v":"Laptop power cable"},{"$f":"IF(ISBLANK(Expense_Entry!D26),\"\",Expense_Entry!D26)","v":"Misc."},{"$f":"IF(ISBLANK(Expense_Entry!E26),\"\",Expense_Entry!E26)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F26),\"\",Expense_Entry!F26)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G26),\"\",Expense_Entry!G26)","v":{"v":25,"d":"$25.00"}},{"v":25,"d":"$25.00"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A27),\"\",Expense_Entry!A27)","v":"2011-03-15"},{"$f":"IF(ISBLANK(Expense_Entry!B27),\"\",Expense_Entry!B27)","v":"SingTel"},{"$f":"IF(ISBLANK(Expense_Entry!C27),\"\",Expense_Entry!C27)","v":"Data SIM"},{"$f":"IF(ISBLANK(Expense_Entry!D27),\"\",Expense_Entry!D27)","v":"Phone"},{"$f":"IF(ISBLANK(Expense_Entry!E27),\"\",Expense_Entry!E27)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F27),\"\",Expense_Entry!F27)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G27),\"\",Expense_Entry!G27)","v":{"v":18,"d":"$18.00"}},{"v":18,"d":"$18.00"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A28),\"\",Expense_Entry!A28)","v":"2011-03-15"},{"$f":"IF(ISBLANK(Expense_Entry!B28),\"\",Expense_Entry!B28)","v":"Citycab"},{"$f":"IF(ISBLANK(Expense_Entry!C28),\"\",Expense_Entry!C28)","v":"Taxi to hotel"},{"$f":"IF(ISBLANK(Expense_Entry!D28),\"\",Expense_Entry!D28)","v":"Taxi"},{"$f":"IF(ISBLANK(Expense_Entry!E28),\"\",Expense_Entry!E28)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F28),\"\",Expense_Entry!F28)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G28),\"\",Expense_Entry!G28)","v":{"v":30.55,"d":"$30.55"}},{"v":30.55,"d":"$30.55"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A29),\"\",Expense_Entry!A29)","v":"2011-03-15"},{"$f":"IF(ISBLANK(Expense_Entry!B29),\"\",Expense_Entry!B29)","v":"Concorde Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!C29),\"\",Expense_Entry!C29)","v":"Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!D29),\"\",Expense_Entry!D29)","v":"Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!E29),\"\",Expense_Entry!E29)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F29),\"\",Expense_Entry!F29)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G29),\"\",Expense_Entry!G29)","v":{"v":335.45,"d":"$335.45"}},{"v":335.45,"d":"$335.45"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A30),\"\",Expense_Entry!A30)","v":"2011-03-15"},{"$f":"IF(ISBLANK(Expense_Entry!B30),\"\",Expense_Entry!B30)","v":"SingTel"},{"$f":"IF(ISBLANK(Expense_Entry!C30),\"\",Expense_Entry!C30)","v":"Lunch"},{"$f":"IF(ISBLANK(Expense_Entry!D30),\"\",Expense_Entry!D30)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E30),\"\",Expense_Entry!E30)","v":"Cash"},{"$f":"IF(ISBLANK(Expense_Entry!F30),\"\",Expense_Entry!F30)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G30),\"\",Expense_Entry!G30)","v":{"v":2.8,"d":"$2.80"}},{"v":2.8,"d":"$2.80"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A31),\"\",Expense_Entry!A31)","v":"2011-03-16"},{"$f":"IF(ISBLANK(Expense_Entry!B31),\"\",Expense_Entry!B31)","v":"Starbucks"},{"$f":"IF(ISBLANK(Expense_Entry!C31),\"\",Expense_Entry!C31)","v":"Coffee"},{"$f":"IF(ISBLANK(Expense_Entry!D31),\"\",Expense_Entry!D31)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E31),\"\",Expense_Entry!E31)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F31),\"\",Expense_Entry!F31)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G31),\"\",Expense_Entry!G31)","v":{"v":7.1,"d":"$7.10"}},{"v":7.1,"d":"$7.10"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A32),\"\",Expense_Entry!A32)","v":"2011-03-16"},{"$f":"IF(ISBLANK(Expense_Entry!B32),\"\",Expense_Entry!B32)","v":"McDonald's"},{"$f":"IF(ISBLANK(Expense_Entry!C32),\"\",Expense_Entry!C32)","v":"Dinner"},{"$f":"IF(ISBLANK(Expense_Entry!D32),\"\",Expense_Entry!D32)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E32),\"\",Expense_Entry!E32)","v":"Cash"},{"$f":"IF(ISBLANK(Expense_Entry!F32),\"\",Expense_Entry!F32)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G32),\"\",Expense_Entry!G32)","v":{"v":2.3,"d":"$2.30"}},{"v":2.3,"d":"$2.30"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A33),\"\",Expense_Entry!A33)","v":"2011-03-16"},{"$f":"IF(ISBLANK(Expense_Entry!B33),\"\",Expense_Entry!B33)","v":"Cold Storage"},{"$f":"IF(ISBLANK(Expense_Entry!C33),\"\",Expense_Entry!C33)","v":"Dinner"},{"$f":"IF(ISBLANK(Expense_Entry!D33),\"\",Expense_Entry!D33)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E33),\"\",Expense_Entry!E33)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F33),\"\",Expense_Entry!F33)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G33),\"\",Expense_Entry!G33)","v":{"v":13.8,"d":"$13.80"}},{"v":13.8,"d":"$13.80"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A34),\"\",Expense_Entry!A34)","v":"2011-03-16"},{"$f":"IF(ISBLANK(Expense_Entry!B34),\"\",Expense_Entry!B34)","v":"Concorde Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!C34),\"\",Expense_Entry!C34)","v":"Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!D34),\"\",Expense_Entry!D34)","v":"Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!E34),\"\",Expense_Entry!E34)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F34),\"\",Expense_Entry!F34)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G34),\"\",Expense_Entry!G34)","v":{"v":335.45,"d":"$335.45"}},{"v":335.45,"d":"$335.45"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A35),\"\",Expense_Entry!A35)","v":"2011-03-16"},{"$f":"IF(ISBLANK(Expense_Entry!B35),\"\",Expense_Entry!B35)","v":"SingTel"},{"$f":"IF(ISBLANK(Expense_Entry!C35),\"\",Expense_Entry!C35)","v":"Lunch"},{"$f":"IF(ISBLANK(Expense_Entry!D35),\"\",Expense_Entry!D35)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E35),\"\",Expense_Entry!E35)","v":"Cash"},{"$f":"IF(ISBLANK(Expense_Entry!F35),\"\",Expense_Entry!F35)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G35),\"\",Expense_Entry!G35)","v":{"v":30,"d":"$30.00"}},{"v":30,"d":"$30.00"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A36),\"\",Expense_Entry!A36)","v":"2011-03-17"},{"$f":"IF(ISBLANK(Expense_Entry!B36),\"\",Expense_Entry!B36)","v":"Starbucks"},{"$f":"IF(ISBLANK(Expense_Entry!C36),\"\",Expense_Entry!C36)","v":"Coffee"},{"$f":"IF(ISBLANK(Expense_Entry!D36),\"\",Expense_Entry!D36)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E36),\"\",Expense_Entry!E36)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F36),\"\",Expense_Entry!F36)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G36),\"\",Expense_Entry!G36)","v":{"v":7.1,"d":"$7.10"}},{"v":7.1,"d":"$7.10"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A37),\"\",Expense_Entry!A37)","v":"2011-03-17"},{"$f":"IF(ISBLANK(Expense_Entry!B37),\"\",Expense_Entry!B37)","v":"Cold Storage"},{"$f":"IF(ISBLANK(Expense_Entry!C37),\"\",Expense_Entry!C37)","v":"Dinner"},{"$f":"IF(ISBLANK(Expense_Entry!D37),\"\",Expense_Entry!D37)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E37),\"\",Expense_Entry!E37)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F37),\"\",Expense_Entry!F37)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G37),\"\",Expense_Entry!G37)","v":{"v":8.1,"d":"$8.10"}},{"v":8.1,"d":"$8.10"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A38),\"\",Expense_Entry!A38)","v":"2011-03-17"},{"$f":"IF(ISBLANK(Expense_Entry!B38),\"\",Expense_Entry!B38)","v":"Concorde Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!C38),\"\",Expense_Entry!C38)","v":"Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!D38),\"\",Expense_Entry!D38)","v":"Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!E38),\"\",Expense_Entry!E38)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F38),\"\",Expense_Entry!F38)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G38),\"\",Expense_Entry!G38)","v":{"v":335.45,"d":"$335.45"}},{"v":335.45,"d":"$335.45"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A39),\"\",Expense_Entry!A39)","v":"2011-03-17"},{"$f":"IF(ISBLANK(Expense_Entry!B39),\"\",Expense_Entry!B39)","v":"Concorde Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!C39),\"\",Expense_Entry!C39)","v":"Laundry"},{"$f":"IF(ISBLANK(Expense_Entry!D39),\"\",Expense_Entry!D39)","v":"Misc."},{"$f":"IF(ISBLANK(Expense_Entry!E39),\"\",Expense_Entry!E39)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F39),\"\",Expense_Entry!F39)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G39),\"\",Expense_Entry!G39)","v":{"v":32.49,"d":"$32.49"}},{"v":32.49,"d":"$32.49"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A40),\"\",Expense_Entry!A40)","v":"2011-03-17"},{"$f":"IF(ISBLANK(Expense_Entry!B40),\"\",Expense_Entry!B40)","v":"Concorde Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!C40),\"\",Expense_Entry!C40)","v":"Telephone"},{"$f":"IF(ISBLANK(Expense_Entry!D40),\"\",Expense_Entry!D40)","v":"Phone"},{"$f":"IF(ISBLANK(Expense_Entry!E40),\"\",Expense_Entry!E40)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F40),\"\",Expense_Entry!F40)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G40),\"\",Expense_Entry!G40)","v":{"v":0.43,"d":"$0.43"}},{"v":0.43,"d":"$0.43"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A41),\"\",Expense_Entry!A41)","v":"2011-03-17"},{"$f":"IF(ISBLANK(Expense_Entry!B41),\"\",Expense_Entry!B41)","v":"Concorde Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!C41),\"\",Expense_Entry!C41)","v":"Dinner"},{"$f":"IF(ISBLANK(Expense_Entry!D41),\"\",Expense_Entry!D41)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E41),\"\",Expense_Entry!E41)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F41),\"\",Expense_Entry!F41)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G41),\"\",Expense_Entry!G41)","v":{"v":27.07,"d":"$27.07"}},{"v":27.07,"d":"$27.07"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A42),\"\",Expense_Entry!A42)","v":"2011-03-17"},{"$f":"IF(ISBLANK(Expense_Entry!B42),\"\",Expense_Entry!B42)","v":"SingTel"},{"$f":"IF(ISBLANK(Expense_Entry!C42),\"\",Expense_Entry!C42)","v":"Lunch"},{"$f":"IF(ISBLANK(Expense_Entry!D42),\"\",Expense_Entry!D42)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E42),\"\",Expense_Entry!E42)","v":"Cash"},{"$f":"IF(ISBLANK(Expense_Entry!F42),\"\",Expense_Entry!F42)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G42),\"\",Expense_Entry!G42)","v":{"v":2,"d":"$2.00"}},{"v":2,"d":"$2.00"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A43),\"\",Expense_Entry!A43)","v":"2011-03-18"},{"$f":"IF(ISBLANK(Expense_Entry!B43),\"\",Expense_Entry!B43)","v":"Youniqe Bistro"},{"$f":"IF(ISBLANK(Expense_Entry!C43),\"\",Expense_Entry!C43)","v":"Coffee"},{"$f":"IF(ISBLANK(Expense_Entry!D43),\"\",Expense_Entry!D43)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E43),\"\",Expense_Entry!E43)","v":"Cash"},{"$f":"IF(ISBLANK(Expense_Entry!F43),\"\",Expense_Entry!F43)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G43),\"\",Expense_Entry!G43)","v":{"v":3.2,"d":"$3.20"}},{"$f":"IF(OR(F43=\"\",G43=\"\"),\"\",ROUND(G43/VLOOKUP(F43,FX_Rate_Tbl,2,FALSE),2))","v":{"v":3.2,"d":"$3.20"}}]
[{"$f":"IF(ISBLANK(Expense_Entry!A44),\"\",Expense_Entry!A44)","v":"2011-03-18"},{"$f":"IF(ISBLANK(Expense_Entry!B44),\"\",Expense_Entry!B44)","v":"Starbucks"},{"$f":"IF(ISBLANK(Expense_Entry!C44),\"\",Expense_Entry!C44)","v":"Coffee"},{"$f":"IF(ISBLANK(Expense_Entry!D44),\"\",Expense_Entry!D44)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E44),\"\",Expense_Entry!E44)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F44),\"\",Expense_Entry!F44)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G44),\"\",Expense_Entry!G44)","v":{"v":7.1,"d":"$7.10"}},{"v":7.1,"d":"$7.10"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A45),\"\",Expense_Entry!A45)","v":"2011-03-18"},{"$f":"IF(ISBLANK(Expense_Entry!B45),\"\",Expense_Entry!B45)","v":"CS Centrepoint"},{"$f":"IF(ISBLANK(Expense_Entry!C45),\"\",Expense_Entry!C45)","v":"Dinner"},{"$f":"IF(ISBLANK(Expense_Entry!D45),\"\",Expense_Entry!D45)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E45),\"\",Expense_Entry!E45)","v":"Cash"},{"$f":"IF(ISBLANK(Expense_Entry!F45),\"\",Expense_Entry!F45)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G45),\"\",Expense_Entry!G45)","v":{"v":3.4,"d":"$3.40"}},{"v":3.4,"d":"$3.40"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A46),\"\",Expense_Entry!A46)","v":"2011-03-18"},{"$f":"IF(ISBLANK(Expense_Entry!B46),\"\",Expense_Entry!B46)","v":"SingTel"},{"$f":"IF(ISBLANK(Expense_Entry!C46),\"\",Expense_Entry!C46)","v":"Data SIM"},{"$f":"IF(ISBLANK(Expense_Entry!D46),\"\",Expense_Entry!D46)","v":"Phone"},{"$f":"IF(ISBLANK(Expense_Entry!E46),\"\",Expense_Entry!E46)","v":"VISA"},{"$f":"IF(ISBLANK(Expense_Entry!F46),\"\",Expense_Entry!F46)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G46),\"\",Expense_Entry!G46)","v":{"v":18,"d":"$18.00"}},{"v":18,"d":"$18.00"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A47),\"\",Expense_Entry!A47)","v":"2011-03-18"},{"$f":"IF(ISBLANK(Expense_Entry!B47),\"\",Expense_Entry!B47)","v":"Cold Storage"},{"$f":"IF(ISBLANK(Expense_Entry!C47),\"\",Expense_Entry!C47)","v":"Dinner"},{"$f":"IF(ISBLANK(Expense_Entry!D47),\"\",Expense_Entry!D47)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E47),\"\",Expense_Entry!E47)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F47),\"\",Expense_Entry!F47)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G47),\"\",Expense_Entry!G47)","v":{"v":19.9,"d":"$19.90"}},{"v":19.9,"d":"$19.90"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A48),\"\",Expense_Entry!A48)","v":"2011-03-18"},{"$f":"IF(ISBLANK(Expense_Entry!B48),\"\",Expense_Entry!B48)","v":"Concorde Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!C48),\"\",Expense_Entry!C48)","v":"Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!D48),\"\",Expense_Entry!D48)","v":"Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!E48),\"\",Expense_Entry!E48)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F48),\"\",Expense_Entry!F48)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G48),\"\",Expense_Entry!G48)","v":{"v":335.45,"d":"$335.45"}},{"v":335.45,"d":"$335.45"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A49),\"\",Expense_Entry!A49)","v":"2011-03-18"},{"$f":"IF(ISBLANK(Expense_Entry!B49),\"\",Expense_Entry!B49)","v":"SingTel"},{"$f":"IF(ISBLANK(Expense_Entry!C49),\"\",Expense_Entry!C49)","v":"Lunch"},{"$f":"IF(ISBLANK(Expense_Entry!D49),\"\",Expense_Entry!D49)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E49),\"\",Expense_Entry!E49)","v":"Cash"},{"$f":"IF(ISBLANK(Expense_Entry!F49),\"\",Expense_Entry!F49)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G49),\"\",Expense_Entry!G49)","v":{"v":10,"d":"$10.00"}},{"v":10,"d":"$10.00"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A50),\"\",Expense_Entry!A50)","v":"2011-03-19"},{"$f":"IF(ISBLANK(Expense_Entry!B50),\"\",Expense_Entry!B50)","v":"Concorde Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!C50),\"\",Expense_Entry!C50)","v":"Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!D50),\"\",Expense_Entry!D50)","v":"Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!E50),\"\",Expense_Entry!E50)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F50),\"\",Expense_Entry!F50)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G50),\"\",Expense_Entry!G50)","v":{"v":335.45,"d":"$335.45"}},{"v":335.45,"d":"$335.45"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A51),\"\",Expense_Entry!A51)","v":"2011-03-19"},{"$f":"IF(ISBLANK(Expense_Entry!B51),\"\",Expense_Entry!B51)","v":"Starbucks"},{"$f":"IF(ISBLANK(Expense_Entry!C51),\"\",Expense_Entry!C51)","v":"Coffee"},{"$f":"IF(ISBLANK(Expense_Entry!D51),\"\",Expense_Entry!D51)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E51),\"\",Expense_Entry!E51)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F51),\"\",Expense_Entry!F51)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G51),\"\",Expense_Entry!G51)","v":{"v":5.5,"d":"$5.50"}},{"v":5.5,"d":"$5.50"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A52),\"\",Expense_Entry!A52)","v":"2011-03-19"},{"$f":"IF(ISBLANK(Expense_Entry!B52),\"\",Expense_Entry!B52)","v":"Cold Storage"},{"$f":"IF(ISBLANK(Expense_Entry!C52),\"\",Expense_Entry!C52)","v":"Snack"},{"$f":"IF(ISBLANK(Expense_Entry!D52),\"\",Expense_Entry!D52)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E52),\"\",Expense_Entry!E52)","v":"Cash"},{"$f":"IF(ISBLANK(Expense_Entry!F52),\"\",Expense_Entry!F52)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G52),\"\",Expense_Entry!G52)","v":{"v":6.6,"d":"$6.60"}},{"v":6.6,"d":"$6.60"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A53),\"\",Expense_Entry!A53)","v":"2011-03-20"},{"$f":"IF(ISBLANK(Expense_Entry!B53),\"\",Expense_Entry!B53)","v":"Concorde Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!C53),\"\",Expense_Entry!C53)","v":"Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!D53),\"\",Expense_Entry!D53)","v":"Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!E53),\"\",Expense_Entry!E53)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F53),\"\",Expense_Entry!F53)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G53),\"\",Expense_Entry!G53)","v":{"v":335.45,"d":"$335.45"}},{"v":335.45,"d":"$335.45"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A54),\"\",Expense_Entry!A54)","v":"2011-03-20"},{"$f":"IF(ISBLANK(Expense_Entry!B54),\"\",Expense_Entry!B54)","v":"Starbucks"},{"$f":"IF(ISBLANK(Expense_Entry!C54),\"\",Expense_Entry!C54)","v":"Coffee"},{"$f":"IF(ISBLANK(Expense_Entry!D54),\"\",Expense_Entry!D54)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E54),\"\",Expense_Entry!E54)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F54),\"\",Expense_Entry!F54)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G54),\"\",Expense_Entry!G54)","v":{"v":8.7,"d":"$8.70"}},{"v":8.7,"d":"$8.70"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A55),\"\",Expense_Entry!A55)","v":"2011-03-20"},{"$f":"IF(ISBLANK(Expense_Entry!B55),\"\",Expense_Entry!B55)","v":"Starbucks"},{"$f":"IF(ISBLANK(Expense_Entry!C55),\"\",Expense_Entry!C55)","v":"Coffee"},{"$f":"IF(ISBLANK(Expense_Entry!D55),\"\",Expense_Entry!D55)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E55),\"\",Expense_Entry!E55)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F55),\"\",Expense_Entry!F55)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G55),\"\",Expense_Entry!G55)","v":{"v":5.8,"d":"$5.80"}},{"v":5.8,"d":"$5.80"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A56),\"\",Expense_Entry!A56)","v":"2011-03-20"},{"$f":"IF(ISBLANK(Expense_Entry!B56),\"\",Expense_Entry!B56)","v":"Starbucks"},{"$f":"IF(ISBLANK(Expense_Entry!C56),\"\",Expense_Entry!C56)","v":"Tip"},{"$f":"IF(ISBLANK(Expense_Entry!D56),\"\",Expense_Entry!D56)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E56),\"\",Expense_Entry!E56)","v":"Cash"},{"$f":"IF(ISBLANK(Expense_Entry!F56),\"\",Expense_Entry!F56)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G56),\"\",Expense_Entry!G56)","v":{"v":2.2,"d":"$2.20"}},{"v":2.2,"d":"$2.20"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A57),\"\",Expense_Entry!A57)","v":"2011-03-21"},{"$f":"IF(ISBLANK(Expense_Entry!B57),\"\",Expense_Entry!B57)","v":"Concorde Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!C57),\"\",Expense_Entry!C57)","v":"Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!D57),\"\",Expense_Entry!D57)","v":"Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!E57),\"\",Expense_Entry!E57)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F57),\"\",Expense_Entry!F57)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G57),\"\",Expense_Entry!G57)","v":{"v":335.45,"d":"$335.45"}},{"v":335.45,"d":"$335.45"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A58),\"\",Expense_Entry!A58)","v":"2011-03-21"},{"$f":"IF(ISBLANK(Expense_Entry!B58),\"\",Expense_Entry!B58)","v":"Concorde Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!C58),\"\",Expense_Entry!C58)","v":"Laundry"},{"$f":"IF(ISBLANK(Expense_Entry!D58),\"\",Expense_Entry!D58)","v":"Misc."},{"$f":"IF(ISBLANK(Expense_Entry!E58),\"\",Expense_Entry!E58)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F58),\"\",Expense_Entry!F58)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G58),\"\",Expense_Entry!G58)","v":{"v":32.49,"d":"$32.49"}},{"v":32.49,"d":"$32.49"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A59),\"\",Expense_Entry!A59)","v":"2011-03-21"},{"$f":"IF(ISBLANK(Expense_Entry!B59),\"\",Expense_Entry!B59)","v":"SingTel"},{"$f":"IF(ISBLANK(Expense_Entry!C59),\"\",Expense_Entry!C59)","v":"BoM"},{"$f":"IF(ISBLANK(Expense_Entry!D59),\"\",Expense_Entry!D59)","v":"Phone"},{"$f":"IF(ISBLANK(Expense_Entry!E59),\"\",Expense_Entry!E59)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F59),\"\",Expense_Entry!F59)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G59),\"\",Expense_Entry!G59)","v":{"v":18,"d":"$18.00"}},{"v":18,"d":"$18.00"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A60),\"\",Expense_Entry!A60)","v":"2011-03-21"},{"$f":"IF(ISBLANK(Expense_Entry!B60),\"\",Expense_Entry!B60)","v":"Starbucks"},{"$f":"IF(ISBLANK(Expense_Entry!C60),\"\",Expense_Entry!C60)","v":"Coffee"},{"$f":"IF(ISBLANK(Expense_Entry!D60),\"\",Expense_Entry!D60)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E60),\"\",Expense_Entry!E60)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F60),\"\",Expense_Entry!F60)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G60),\"\",Expense_Entry!G60)","v":{"v":7.1,"d":"$7.10"}},{"v":7.1,"d":"$7.10"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A61),\"\",Expense_Entry!A61)","v":"2011-03-21"},{"$f":"IF(ISBLANK(Expense_Entry!B61),\"\",Expense_Entry!B61)","v":"Cold Storage"},{"$f":"IF(ISBLANK(Expense_Entry!C61),\"\",Expense_Entry!C61)","v":"Water"},{"$f":"IF(ISBLANK(Expense_Entry!D61),\"\",Expense_Entry!D61)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E61),\"\",Expense_Entry!E61)","v":"Cash"},{"$f":"IF(ISBLANK(Expense_Entry!F61),\"\",Expense_Entry!F61)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G61),\"\",Expense_Entry!G61)","v":{"v":2.15,"d":"$2.15"}},{"v":2.15,"d":"$2.15"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A62),\"\",Expense_Entry!A62)","v":"2011-03-21"},{"$f":"IF(ISBLANK(Expense_Entry!B62),\"\",Expense_Entry!B62)","v":"SingTel"},{"$f":"IF(ISBLANK(Expense_Entry!C62),\"\",Expense_Entry!C62)","v":"Lunch"},{"$f":"IF(ISBLANK(Expense_Entry!D62),\"\",Expense_Entry!D62)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E62),\"\",Expense_Entry!E62)","v":"Cash"},{"$f":"IF(ISBLANK(Expense_Entry!F62),\"\",Expense_Entry!F62)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G62),\"\",Expense_Entry!G62)","v":{"v":2.8,"d":"$2.80"}},{"v":2.8,"d":"$2.80"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A63),\"\",Expense_Entry!A63)","v":"2011-03-22"},{"$f":"IF(ISBLANK(Expense_Entry!B63),\"\",Expense_Entry!B63)","v":"Concorde Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!C63),\"\",Expense_Entry!C63)","v":"Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!D63),\"\",Expense_Entry!D63)","v":"Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!E63),\"\",Expense_Entry!E63)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F63),\"\",Expense_Entry!F63)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G63),\"\",Expense_Entry!G63)","v":{"v":335.45,"d":"$335.45"}},{"v":335.45,"d":"$335.45"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A64),\"\",Expense_Entry!A64)","v":"2011-03-22"},{"$f":"IF(ISBLANK(Expense_Entry!B64),\"\",Expense_Entry!B64)","v":"Starbucks"},{"$f":"IF(ISBLANK(Expense_Entry!C64),\"\",Expense_Entry!C64)","v":"Coffee"},{"$f":"IF(ISBLANK(Expense_Entry!D64),\"\",Expense_Entry!D64)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E64),\"\",Expense_Entry!E64)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F64),\"\",Expense_Entry!F64)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G64),\"\",Expense_Entry!G64)","v":{"v":7.1,"d":"$7.10"}},{"v":7.1,"d":"$7.10"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A65),\"\",Expense_Entry!A65)","v":"2011-03-22"},{"$f":"IF(ISBLANK(Expense_Entry!B65),\"\",Expense_Entry!B65)","v":"Cold Storage"},{"$f":"IF(ISBLANK(Expense_Entry!C65),\"\",Expense_Entry!C65)","v":"Dinner"},{"$f":"IF(ISBLANK(Expense_Entry!D65),\"\",Expense_Entry!D65)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E65),\"\",Expense_Entry!E65)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F65),\"\",Expense_Entry!F65)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G65),\"\",Expense_Entry!G65)","v":{"v":26.5,"d":"$26.50"}},{"v":26.5,"d":"$26.50"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A66),\"\",Expense_Entry!A66)","v":"2011-03-22"},{"$f":"IF(ISBLANK(Expense_Entry!B66),\"\",Expense_Entry!B66)","v":"SingTel"},{"$f":"IF(ISBLANK(Expense_Entry!C66),\"\",Expense_Entry!C66)","v":"Lunch"},{"$f":"IF(ISBLANK(Expense_Entry!D66),\"\",Expense_Entry!D66)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E66),\"\",Expense_Entry!E66)","v":"Cash"},{"$f":"IF(ISBLANK(Expense_Entry!F66),\"\",Expense_Entry!F66)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G66),\"\",Expense_Entry!G66)","v":{"v":5.5,"d":"$5.50"}},{"v":5.5,"d":"$5.50"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A67),\"\",Expense_Entry!A67)","v":"2011-03-23"},{"$f":"IF(ISBLANK(Expense_Entry!B67),\"\",Expense_Entry!B67)","v":"Concorde Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!C67),\"\",Expense_Entry!C67)","v":"Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!D67),\"\",Expense_Entry!D67)","v":"Hotel"},{"$f":"IF(ISBLANK(Expense_Entry!E67),\"\",Expense_Entry!E67)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F67),\"\",Expense_Entry!F67)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G67),\"\",Expense_Entry!G67)","v":{"v":335.45,"d":"$335.45"}},{"v":335.45,"d":"$335.45"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A68),\"\",Expense_Entry!A68)","v":"2011-03-23"},{"$f":"IF(ISBLANK(Expense_Entry!B68),\"\",Expense_Entry!B68)","v":"Starbucks"},{"$f":"IF(ISBLANK(Expense_Entry!C68),\"\",Expense_Entry!C68)","v":"Coffee"},{"$f":"IF(ISBLANK(Expense_Entry!D68),\"\",Expense_Entry!D68)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E68),\"\",Expense_Entry!E68)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F68),\"\",Expense_Entry!F68)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G68),\"\",Expense_Entry!G68)","v":{"v":7.9,"d":"$7.90"}},{"v":7.9,"d":"$7.90"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A69),\"\",Expense_Entry!A69)","v":"2011-03-23"},{"$f":"IF(ISBLANK(Expense_Entry!B69),\"\",Expense_Entry!B69)","v":"Burger King"},{"$f":"IF(ISBLANK(Expense_Entry!C69),\"\",Expense_Entry!C69)","v":"Lunch"},{"$f":"IF(ISBLANK(Expense_Entry!D69),\"\",Expense_Entry!D69)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E69),\"\",Expense_Entry!E69)","v":"Cash"},{"$f":"IF(ISBLANK(Expense_Entry!F69),\"\",Expense_Entry!F69)","v":"SGD"},{"$f":"IF(ISBLANK(Expense_Entry!G69),\"\",Expense_Entry!G69)","v":{"v":7.65,"d":"$7.65"}},{"v":7.65,"d":"$7.65"}]
[{"$f":"IF(ISBLANK(Expense_Entry!A70),\"\",Expense_Entry!A70)","v":"2011-03-23"},{"$f":"IF(ISBLANK(Expense_Entry!B70),\"\",Expense_Entry!B70)","v":"Starbucks"},{"$f":"IF(ISBLANK(Expense_Entry!C70),\"\",Expense_Entry!C70)","v":"Coffee"},{"$f":"IF(ISBLANK(Expense_Entry!D70),\"\",Expense_Entry!D70)","v":"Meals"},{"$f":"IF(ISBLANK(Expense_Entry!E70),\"\",Expense_Entry!E70)","v":"AMEX"},{"$f":"IF(ISBLANK(Expense_Entry!F70),\"\",Expense_Entry!F70)","v":"HKG"},{"$f":"IF(ISBLANK(Expense_Entry!G70),\"\",Expense_Entry!G70)","v":{"v":26,"d":"$26.00"}},{"v":4.16,"d":"$4.16"}]
[{"$nulls":6},"Total: ",{"$f":"SUM(H11:H70)","v":{"v":17834.82000000001,"d":"$17,834.82"}}]

{"sheet":"ExpenseDB","index":5,"n_rows":98,"n_cols":15,"rows_kept":98}
["Expense Database"]
[]
[null,"The purpose of this worksheet is to perform calculations on the entries in the Expense_Entry worksheet to produce all the possible values possibly needed to satisfy"]
[null,"   a corporate expense voucher submission."]
[]
[null,"Employee: ",{"$f":"Employee","v":"Employee Name"},{"$nulls":4},"Reimbursement Owed ",{"$f":"GETPIVOTDATA(\"Reim Amt.\",$A$73)","v":{"v":14259.83,"d":"$14,259.83"}},null,null,"Expense Gain/Loss: ",{"$f":"Actual_Reimbursed_Amt-Reimbursement_Owed","v":{"v":-59.82999999999993,"d":"$(59.83)"}}]
[null,"Reimbursement Currency: ",{"$f":"Reimbursement_Currency","v":"CAD"},{"$nulls":4},"Actual Reimbursed Amount: ",{"v":14200,"d":"$14,200.00"},null,{"$f":"IFERROR(IF(Expense_Gain_Loss<0,\"WARNING: unrecovered amount!\",\"\"),\"\")","v":"WARNING: unrecovered amount!"}]
[{"$nulls":9}," "]
[{"$nulls":7},"Reimbursement Data",{"$nulls":3},"Invoice Data"]
["Date","Establishment","Description","Type","Method","Currency","Exp. Amt.","R-Fx Rate Conv.","R-Fx Rate","Reim Amt.","a","I-Fx Rate Conv.","I-Fx Rate","Inv. Amt."]
[{"$f":"Expense_Entry!A11","v":"2011-03-11"},{"$f":"Expense_Entry!B11","v":"Mileage"},{"$f":"Expense_Entry!C11","v":"Drive to/from YOW (38 miles)"},{"$f":"Expense_Entry!D11","v":"Mileage"},{"$f":"Expense_Entry!E11","v":"Mileage"},{"$f":"Expense_Entry!F11","v":"USD"},{"$f":"Expense_Entry!G11","v":{"v":21.09,"d":"$21.09"}},{"$f":"IF(AND(F11<>\"\",Reimbursement_Currency<>\"\"),IF(F11=Reimbursement_Currency,STR_N_A,CONCATENATE(F11,STR_TO,Reimbursement_Currency)),\"\")","v":"USD to CAD"},{"$f":"IF(F11=Reimbursement_Currency,1,IF(G11=\"\",\"\",G11/Expense_Entry!$J11))","v":1.0672},{"$f":"IF(F11<>\"\",IF(Reimbursement_Currency=F11,G11,ROUND(G11/I11,2)),\"\")","v":{"v":19.76,"d":"$19.76"}},null,{"$f":"IF(AND(Client_Currency<>\"\",F11<>\"\"),IF(Client_Currency=F11,STR_N_A,CONCATENATE(F11,STR_TO,Client_Currency)),\"\")","v":"USD to SGD"},{"$f":"IF(G11=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F11,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1.3323290187891441,"d":"1.3323"}},{"$f":"IF(AND(Client_Currency<>\"\",F11<>\"\"),IF(Client_Currency=G11,G11,ROUND(G11*M11,2)),\"\")","v":{"v":28.1,"d":"$28.10"}}]
[{"$f":"Expense_Entry!A12","v":"2011-03-11"},{"$f":"Expense_Entry!B12","v":"Ottawa Airport"},{"$f":"Expense_Entry!C12","v":"Parking"},{"$f":"Expense_Entry!D12","v":"Parking"},{"$f":"Expense_Entry!E12","v":"AMEX"},{"$f":"Expense_Entry!F12","v":"CAD"},{"$f":"Expense_Entry!G12","v":{"v":6,"d":"$6.00"}},"N/A",{"$f":"IF(F12=Reimbursement_Currency,1,IF(G12=\"\",\"\",G12/Expense_Entry!$J12))","v":{"v":1,"d":"1.0000"}},{"v":6,"d":"$6.00"},null,"CAD to SGD",{"$f":"IF(G12=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F12,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1.2484342379958246,"d":"1.2484"}},{"v":7.49,"d":"$7.49"}]
[{"$f":"Expense_Entry!A13","v":"2011-03-11"},{"$f":"Expense_Entry!B13","v":"Cold Storage"},{"$f":"Expense_Entry!C13","v":"Dinner"},{"$f":"Expense_Entry!D13","v":"Meals"},{"$f":"Expense_Entry!E13","v":"AMEX"},{"$f":"Expense_Entry!F13","v":"SGD"},{"$f":"Expense_Entry!G13","v":{"v":8.6,"d":"$8.60"}},"SGD to CAD",{"$f":"IF(F13=Reimbursement_Currency,1,IF(G13=\"\",\"\",G13/Expense_Entry!$J13))","v":{"v":1.2609970674486803,"d":"1.2610"}},{"v":6.82,"d":"$6.82"},null,"N/A",{"$f":"IF(G13=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F13,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":8.6,"d":"$8.60"}]
[{"$f":"Expense_Entry!A14","v":"2011-03-11"},{"$f":"Expense_Entry!B14","v":"Starbucks"},{"$f":"Expense_Entry!C14","v":"Coffee"},{"$f":"Expense_Entry!D14","v":"Meals"},{"$f":"Expense_Entry!E14","v":"AMEX"},{"$f":"Expense_Entry!F14","v":"SGD"},{"$f":"Expense_Entry!G14","v":{"v":7.9,"d":"$7.90"}},"SGD to CAD",{"$f":"IF(F14=Reimbursement_Currency,1,IF(G14=\"\",\"\",G14/Expense_Entry!$J14))","v":{"v":1.2599681020733653,"d":"1.2600"}},{"v":6.27,"d":"$6.27"},null,"N/A",{"$f":"IF(G14=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F14,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":7.9,"d":"$7.90"}]
[{"$f":"Expense_Entry!A15","v":"2011-03-12"},{"$f":"Expense_Entry!B15","v":"Starbucks"},{"$f":"Expense_Entry!C15","v":"Coffee"},{"$f":"Expense_Entry!D15","v":"Meals"},{"$f":"Expense_Entry!E15","v":"AMEX"},{"$f":"Expense_Entry!F15","v":"CAD"},{"$f":"Expense_Entry!G15","v":{"v":4.71,"d":"$4.71"}},"N/A",{"$f":"IF(F15=Reimbursement_Currency,1,IF(G15=\"\",\"\",G15/Expense_Entry!$J15))","v":{"v":1,"d":"1.0000"}},{"v":4.71,"d":"$4.71"},null,"CAD to SGD",{"$f":"IF(G15=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F15,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1.2484342379958246,"d":"1.2484"}},{"v":5.88,"d":"$5.88"}]
[{"$f":"Expense_Entry!A16","v":"2011-03-12"},{"$f":"Expense_Entry!B16","v":"Airport Taxi"},{"$f":"Expense_Entry!C16","v":"Taxi to hotel"},{"$f":"Expense_Entry!D16","v":"Taxi"},{"$f":"Expense_Entry!E16","v":"Cash"},{"$f":"Expense_Entry!F16","v":"CAD"},{"$f":"Expense_Entry!G16","v":{"v":20,"d":"$20.00"}},"N/A",{"$f":"IF(F16=Reimbursement_Currency,1,IF(G16=\"\",\"\",G16/Expense_Entry!$J16))","v":{"v":1,"d":"1.0000"}},{"v":20,"d":"$20.00"},null,"CAD to SGD",{"$f":"IF(G16=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F16,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1.2484342379958246,"d":"1.2484"}},{"v":24.97,"d":"$24.97"}]
[{"$f":"Expense_Entry!A17","v":"2011-03-12"},{"$f":"Expense_Entry!B17","v":"YYZ Marriott"},{"$f":"Expense_Entry!C17","v":"Dinner"},{"$f":"Expense_Entry!D17","v":"Meals"},{"$f":"Expense_Entry!E17","v":"AMEX"},{"$f":"Expense_Entry!F17","v":"CAD"},{"$f":"Expense_Entry!G17","v":{"v":43.42,"d":"$43.42"}},"N/A",{"$f":"IF(F17=Reimbursement_Currency,1,IF(G17=\"\",\"\",G17/Expense_Entry!$J17))","v":{"v":1,"d":"1.0000"}},{"v":43.42,"d":"$43.42"},null,"CAD to SGD",{"$f":"IF(G17=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F17,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1.2484342379958246,"d":"1.2484"}},{"v":54.21,"d":"$54.21"}]
[{"$f":"Expense_Entry!A18","v":"2011-03-12"},{"$f":"Expense_Entry!B18","v":"YYZ Marriott"},{"$f":"Expense_Entry!C18","v":"Hotel"},{"$f":"Expense_Entry!D18","v":"Hotel"},{"$f":"Expense_Entry!E18","v":"AMEX"},{"$f":"Expense_Entry!F18","v":"CAD"},{"$f":"Expense_Entry!G18","v":{"v":134.47,"d":"$134.47"}},"N/A",{"$f":"IF(F18=Reimbursement_Currency,1,IF(G18=\"\",\"\",G18/Expense_Entry!$J18))","v":{"v":1,"d":"1.0000"}},{"v":134.47,"d":"$134.47"},null,"CAD to SGD",{"$f":"IF(G18=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F18,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1.2484342379958246,"d":"1.2484"}},{"v":167.88,"d":"$167.88"}]
[{"$f":"Expense_Entry!A19","v":"2011-03-12"},{"$f":"Expense_Entry!B19","v":"United Airlines"},{"$f":"Expense_Entry!C19","v":"Fly to SIN"},{"$f":"Expense_Entry!D19","v":"Airfare"},{"$f":"Expense_Entry!E19","v":"AMEX"},{"$f":"Expense_Entry!F19","v":"CAD"},{"$f":"Expense_Entry!G19","v":{"v":11000.81,"d":"$11,000.81"}},"N/A",{"$f":"IF(F19=Reimbursement_Currency,1,IF(G19=\"\",\"\",G19/Expense_Entry!$J19))","v":{"v":1,"d":"1.0000"}},{"v":11000.81,"d":"$11,000.81"},null,"CAD to SGD",{"$f":"IF(G19=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F19,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1.2484342379958246,"d":"1.2484"}},{"v":13733.79,"d":"$13,733.79"}]
[{"$f":"Expense_Entry!A20","v":"2011-03-13"},{"$f":"Expense_Entry!B20","v":"YYZ Marriott"},{"$f":"Expense_Entry!C20","v":"Tip maid"},{"$f":"Expense_Entry!D20","v":"Hotel"},{"$f":"Expense_Entry!E20","v":"Cash"},{"$f":"Expense_Entry!F20","v":"CAD"},{"$f":"Expense_Entry!G20","v":{"v":5,"d":"$5.00"}},"N/A",{"$f":"IF(F20=Reimbursement_Currency,1,IF(G20=\"\",\"\",G20/Expense_Entry!$J20))","v":{"v":1,"d":"1.0000"}},{"v":5,"d":"$5.00"},null,"CAD to SGD",{"$f":"IF(G20=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F20,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1.2484342379958246,"d":"1.2484"}},{"v":6.24,"d":"$6.24"}]
[{"$f":"Expense_Entry!A21","v":"2011-03-13"},{"$f":"Expense_Entry!B21","v":"YYZ Marriott"},{"$f":"Expense_Entry!C21","v":"Laundry"},{"$f":"Expense_Entry!D21","v":"Misc."},{"$f":"Expense_Entry!E21","v":"Cash"},{"$f":"Expense_Entry!F21","v":"CAD"},{"$f":"Expense_Entry!G21","v":{"v":2.5,"d":"$2.50"}},"N/A",{"$f":"IF(F21=Reimbursement_Currency,1,IF(G21=\"\",\"\",G21/Expense_Entry!$J21))","v":{"v":1,"d":"1.0000"}},{"v":2.5,"d":"$2.50"},null,"CAD to SGD",{"$f":"IF(G21=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F21,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1.2484342379958246,"d":"1.2484"}},{"v":3.12,"d":"$3.12"}]
[{"$f":"Expense_Entry!A22","v":"2011-03-13"},{"$f":"Expense_Entry!B22","v":"YYZ Marriott"},{"$f":"Expense_Entry!C22","v":"Tip bellman"},{"$f":"Expense_Entry!D22","v":"Meals"},{"$f":"Expense_Entry!E22","v":"Cash"},{"$f":"Expense_Entry!F22","v":"USD"},{"$f":"Expense_Entry!G22","v":{"v":1,"d":"$1.00"}},"USD to CAD",{"$f":"IF(F22=Reimbursement_Currency,1,IF(G22=\"\",\"\",G22/Expense_Entry!$J22))","v":{"v":0.9345794392523364,"d":"0.9346"}},{"v":1.07,"d":"$1.07"},null,"USD to SGD",{"$f":"IF(G22=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F22,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1.3323290187891441,"d":"1.3323"}},{"v":1.33,"d":"$1.33"}]
[{"$f":"Expense_Entry!A23","v":"2011-03-13"},{"$f":"Expense_Entry!B23","v":"Starbucks"},{"$f":"Expense_Entry!C23","v":"Coffee"},{"$f":"Expense_Entry!D23","v":"Meals"},{"$f":"Expense_Entry!E23","v":"AMEX"},{"$f":"Expense_Entry!F23","v":"CAD"},{"$f":"Expense_Entry!G23","v":{"v":4.18,"d":"$4.18"}},"N/A",{"$f":"IF(F23=Reimbursement_Currency,1,IF(G23=\"\",\"\",G23/Expense_Entry!$J23))","v":{"v":1,"d":"1.0000"}},{"v":4.18,"d":"$4.18"},null,"CAD to SGD",{"$f":"IF(G23=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F23,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1.2484342379958246,"d":"1.2484"}},{"v":5.22,"d":"$5.22"}]
[{"$f":"Expense_Entry!A24","v":"2011-03-14"},{"$f":"Expense_Entry!B24","v":"Concorde Hotel"},{"$f":"Expense_Entry!C24","v":"Hotel"},{"$f":"Expense_Entry!D24","v":"Hotel"},{"$f":"Expense_Entry!E24","v":"AMEX"},{"$f":"Expense_Entry!F24","v":"SGD"},{"$f":"Expense_Entry!G24","v":{"v":335.45,"d":"$335.45"}},"SGD to CAD",{"$f":"IF(F24=Reimbursement_Currency,1,IF(G24=\"\",\"\",G24/Expense_Entry!$J24))","v":{"v":1.2580175454245208,"d":"1.2580"}},{"v":266.65,"d":"$266.65"},null,"N/A",{"$f":"IF(G24=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F24,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":335.45,"d":"$335.45"}]
[{"$f":"Expense_Entry!A25","v":"2011-03-15"},{"$f":"Expense_Entry!B25","v":"Starbucks"},{"$f":"Expense_Entry!C25","v":"Coffee"},{"$f":"Expense_Entry!D25","v":"Meals"},{"$f":"Expense_Entry!E25","v":"AMEX"},{"$f":"Expense_Entry!F25","v":"SGD"},{"$f":"Expense_Entry!G25","v":{"v":7.1,"d":"$7.10"}},"SGD to CAD",{"$f":"IF(F25=Reimbursement_Currency,1,IF(G25=\"\",\"\",G25/Expense_Entry!$J25))","v":{"v":1.2580175454245208,"d":"1.2580"}},{"v":5.64,"d":"$5.64"},null,"N/A",{"$f":"IF(G25=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F25,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":7.1,"d":"$7.10"}]
[{"$f":"Expense_Entry!A26","v":"2011-03-15"},{"$f":"Expense_Entry!B26","v":"Camera Comp"},{"$f":"Expense_Entry!C26","v":"Laptop power cable"},{"$f":"Expense_Entry!D26","v":"Misc."},{"$f":"Expense_Entry!E26","v":"AMEX"},{"$f":"Expense_Entry!F26","v":"SGD"},{"$f":"Expense_Entry!G26","v":{"v":25,"d":"$25.00"}},"SGD to CAD",{"$f":"IF(F26=Reimbursement_Currency,1,IF(G26=\"\",\"\",G26/Expense_Entry!$J26))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":19.87,"d":"$19.87"},null,"N/A",{"$f":"IF(G26=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F26,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":25,"d":"$25.00"}]
[{"$f":"Expense_Entry!A27","v":"2011-03-15"},{"$f":"Expense_Entry!B27","v":"SingTel"},{"$f":"Expense_Entry!C27","v":"Data SIM"},{"$f":"Expense_Entry!D27","v":"Phone"},{"$f":"Expense_Entry!E27","v":"AMEX"},{"$f":"Expense_Entry!F27","v":"SGD"},{"$f":"Expense_Entry!G27","v":{"v":18,"d":"$18.00"}},"SGD to CAD",{"$f":"IF(F27=Reimbursement_Currency,1,IF(G27=\"\",\"\",G27/Expense_Entry!$J27))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":14.31,"d":"$14.31"},null,"N/A",{"$f":"IF(G27=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F27,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":18,"d":"$18.00"}]
[{"$f":"Expense_Entry!A28","v":"2011-03-15"},{"$f":"Expense_Entry!B28","v":"Citycab"},{"$f":"Expense_Entry!C28","v":"Taxi to hotel"},{"$f":"Expense_Entry!D28","v":"Taxi"},{"$f":"Expense_Entry!E28","v":"AMEX"},{"$f":"Expense_Entry!F28","v":"SGD"},{"$f":"Expense_Entry!G28","v":{"v":30.55,"d":"$30.55"}},"SGD to CAD",{"$f":"IF(F28=Reimbursement_Currency,1,IF(G28=\"\",\"\",G28/Expense_Entry!$J28))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":24.28,"d":"$24.28"},null,"N/A",{"$f":"IF(G28=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F28,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":30.55,"d":"$30.55"}]
[{"$f":"Expense_Entry!A29","v":"2011-03-15"},{"$f":"Expense_Entry!B29","v":"Concorde Hotel"},{"$f":"Expense_Entry!C29","v":"Hotel"},{"$f":"Expense_Entry!D29","v":"Hotel"},{"$f":"Expense_Entry!E29","v":"AMEX"},{"$f":"Expense_Entry!F29","v":"SGD"},{"$f":"Expense_Entry!G29","v":{"v":335.45,"d":"$335.45"}},"SGD to CAD",{"$f":"IF(F29=Reimbursement_Currency,1,IF(G29=\"\",\"\",G29/Expense_Entry!$J29))","v":{"v":1.2580175454245208,"d":"1.2580"}},{"v":266.65,"d":"$266.65"},null,"N/A",{"$f":"IF(G29=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F29,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":335.45,"d":"$335.45"}]
[{"$f":"Expense_Entry!A30","v":"2011-03-15"},{"$f":"Expense_Entry!B30","v":"SingTel"},{"$f":"Expense_Entry!C30","v":"Lunch"},{"$f":"Expense_Entry!D30","v":"Meals"},{"$f":"Expense_Entry!E30","v":"Cash"},{"$f":"Expense_Entry!F30","v":"SGD"},{"$f":"Expense_Entry!G30","v":{"v":2.8,"d":"$2.80"}},"SGD to CAD",{"$f":"IF(F30=Reimbursement_Currency,1,IF(G30=\"\",\"\",G30/Expense_Entry!$J30))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":2.23,"d":"$2.23"},null,"N/A",{"$f":"IF(G30=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F30,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":2.8,"d":"$2.80"}]
[{"$f":"Expense_Entry!A31","v":"2011-03-16"},{"$f":"Expense_Entry!B31","v":"Starbucks"},{"$f":"Expense_Entry!C31","v":"Coffee"},{"$f":"Expense_Entry!D31","v":"Meals"},{"$f":"Expense_Entry!E31","v":"AMEX"},{"$f":"Expense_Entry!F31","v":"SGD"},{"$f":"Expense_Entry!G31","v":{"v":7.1,"d":"$7.10"}},"SGD to CAD",{"$f":"IF(F31=Reimbursement_Currency,1,IF(G31=\"\",\"\",G31/Expense_Entry!$J31))","v":{"v":1.2580175454245208,"d":"1.2580"}},{"v":5.64,"d":"$5.64"},null,"N/A",{"$f":"IF(G31=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F31,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":7.1,"d":"$7.10"}]
[{"$f":"Expense_Entry!A32","v":"2011-03-16"},{"$f":"Expense_Entry!B32","v":"McDonald's"},{"$f":"Expense_Entry!C32","v":"Dinner"},{"$f":"Expense_Entry!D32","v":"Meals"},{"$f":"Expense_Entry!E32","v":"Cash"},{"$f":"Expense_Entry!F32","v":"SGD"},{"$f":"Expense_Entry!G32","v":{"v":2.3,"d":"$2.30"}},"SGD to CAD",{"$f":"IF(F32=Reimbursement_Currency,1,IF(G32=\"\",\"\",G32/Expense_Entry!$J32))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":1.83,"d":"$1.83"},null,"N/A",{"$f":"IF(G32=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F32,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":2.3,"d":"$2.30"}]
[{"$f":"Expense_Entry!A33","v":"2011-03-16"},{"$f":"Expense_Entry!B33","v":"Cold Storage"},{"$f":"Expense_Entry!C33","v":"Dinner"},{"$f":"Expense_Entry!D33","v":"Meals"},{"$f":"Expense_Entry!E33","v":"AMEX"},{"$f":"Expense_Entry!F33","v":"SGD"},{"$f":"Expense_Entry!G33","v":{"v":13.8,"d":"$13.80"}},"SGD to CAD",{"$f":"IF(F33=Reimbursement_Currency,1,IF(G33=\"\",\"\",G33/Expense_Entry!$J33))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":10.97,"d":"$10.97"},null,"N/A",{"$f":"IF(G33=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F33,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":13.8,"d":"$13.80"}]
[{"$f":"Expense_Entry!A34","v":"2011-03-16"},{"$f":"Expense_Entry!B34","v":"Concorde Hotel"},{"$f":"Expense_Entry!C34","v":"Hotel"},{"$f":"Expense_Entry!D34","v":"Hotel"},{"$f":"Expense_Entry!E34","v":"AMEX"},{"$f":"Expense_Entry!F34","v":"SGD"},{"$f":"Expense_Entry!G34","v":{"v":335.45,"d":"$335.45"}},"SGD to CAD",{"$f":"IF(F34=Reimbursement_Currency,1,IF(G34=\"\",\"\",G34/Expense_Entry!$J34))","v":{"v":1.2580175454245208,"d":"1.2580"}},{"v":266.65,"d":"$266.65"},null,"N/A",{"$f":"IF(G34=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F34,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":335.45,"d":"$335.45"}]
[{"$f":"Expense_Entry!A35","v":"2011-03-16"},{"$f":"Expense_Entry!B35","v":"SingTel"},{"$f":"Expense_Entry!C35","v":"Lunch"},{"$f":"Expense_Entry!D35","v":"Meals"},{"$f":"Expense_Entry!E35","v":"Cash"},{"$f":"Expense_Entry!F35","v":"SGD"},{"$f":"Expense_Entry!G35","v":{"v":30,"d":"$30.00"}},"SGD to CAD",{"$f":"IF(F35=Reimbursement_Currency,1,IF(G35=\"\",\"\",G35/Expense_Entry!$J35))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":23.85,"d":"$23.85"},null,"N/A",{"$f":"IF(G35=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F35,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":30,"d":"$30.00"}]
[{"$f":"Expense_Entry!A36","v":"2011-03-17"},{"$f":"Expense_Entry!B36","v":"Starbucks"},{"$f":"Expense_Entry!C36","v":"Coffee"},{"$f":"Expense_Entry!D36","v":"Meals"},{"$f":"Expense_Entry!E36","v":"AMEX"},{"$f":"Expense_Entry!F36","v":"SGD"},{"$f":"Expense_Entry!G36","v":{"v":7.1,"d":"$7.10"}},"SGD to CAD",{"$f":"IF(F36=Reimbursement_Currency,1,IF(G36=\"\",\"\",G36/Expense_Entry!$J36))","v":{"v":1.2580175454245208,"d":"1.2580"}},{"v":5.64,"d":"$5.64"},null,"N/A",{"$f":"IF(G36=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F36,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":7.1,"d":"$7.10"}]
[{"$f":"Expense_Entry!A37","v":"2011-03-17"},{"$f":"Expense_Entry!B37","v":"Cold Storage"},{"$f":"Expense_Entry!C37","v":"Dinner"},{"$f":"Expense_Entry!D37","v":"Meals"},{"$f":"Expense_Entry!E37","v":"AMEX"},{"$f":"Expense_Entry!F37","v":"SGD"},{"$f":"Expense_Entry!G37","v":{"v":8.1,"d":"$8.10"}},"SGD to CAD",{"$f":"IF(F37=Reimbursement_Currency,1,IF(G37=\"\",\"\",G37/Expense_Entry!$J37))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":6.44,"d":"$6.44"},null,"N/A",{"$f":"IF(G37=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F37,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":8.1,"d":"$8.10"}]
[{"$f":"Expense_Entry!A38","v":"2011-03-17"},{"$f":"Expense_Entry!B38","v":"Concorde Hotel"},{"$f":"Expense_Entry!C38","v":"Hotel"},{"$f":"Expense_Entry!D38","v":"Hotel"},{"$f":"Expense_Entry!E38","v":"AMEX"},{"$f":"Expense_Entry!F38","v":"SGD"},{"$f":"Expense_Entry!G38","v":{"v":335.45,"d":"$335.45"}},"SGD to CAD",{"$f":"IF(F38=Reimbursement_Currency,1,IF(G38=\"\",\"\",G38/Expense_Entry!$J38))","v":{"v":1.2580175454245208,"d":"1.2580"}},{"v":266.65,"d":"$266.65"},null,"N/A",{"$f":"IF(G38=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F38,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":335.45,"d":"$335.45"}]
[{"$f":"Expense_Entry!A39","v":"2011-03-17"},{"$f":"Expense_Entry!B39","v":"Concorde Hotel"},{"$f":"Expense_Entry!C39","v":"Laundry"},{"$f":"Expense_Entry!D39","v":"Misc."},{"$f":"Expense_Entry!E39","v":"AMEX"},{"$f":"Expense_Entry!F39","v":"SGD"},{"$f":"Expense_Entry!G39","v":{"v":32.49,"d":"$32.49"}},"SGD to CAD",{"$f":"IF(F39=Reimbursement_Currency,1,IF(G39=\"\",\"\",G39/Expense_Entry!$J39))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":25.83,"d":"$25.83"},null,"N/A",{"$f":"IF(G39=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F39,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":32.49,"d":"$32.49"}]
[{"$f":"Expense_Entry!A40","v":"2011-03-17"},{"$f":"Expense_Entry!B40","v":"Concorde Hotel"},{"$f":"Expense_Entry!C40","v":"Telephone"},{"$f":"Expense_Entry!D40","v":"Phone"},{"$f":"Expense_Entry!E40","v":"AMEX"},{"$f":"Expense_Entry!F40","v":"SGD"},{"$f":"Expense_Entry!G40","v":{"v":0.43,"d":"$0.43"}},"SGD to CAD",{"$f":"IF(F40=Reimbursement_Currency,1,IF(G40=\"\",\"\",G40/Expense_Entry!$J40))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":0.34,"d":"$0.34"},null,"N/A",{"$f":"IF(G40=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F40,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":0.43,"d":"$0.43"}]
[{"$f":"Expense_Entry!A41","v":"2011-03-17"},{"$f":"Expense_Entry!B41","v":"Concorde Hotel"},{"$f":"Expense_Entry!C41","v":"Dinner"},{"$f":"Expense_Entry!D41","v":"Meals"},{"$f":"Expense_Entry!E41","v":"AMEX"},{"$f":"Expense_Entry!F41","v":"SGD"},{"$f":"Expense_Entry!G41","v":{"v":27.07,"d":"$27.07"}},"SGD to CAD",{"$f":"IF(F41=Reimbursement_Currency,1,IF(G41=\"\",\"\",G41/Expense_Entry!$J41))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":21.52,"d":"$21.52"},null,"N/A",{"$f":"IF(G41=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F41,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":27.07,"d":"$27.07"}]
[{"$f":"Expense_Entry!A42","v":"2011-03-17"},{"$f":"Expense_Entry!B42","v":"SingTel"},{"$f":"Expense_Entry!C42","v":"Lunch"},{"$f":"Expense_Entry!D42","v":"Meals"},{"$f":"Expense_Entry!E42","v":"Cash"},{"$f":"Expense_Entry!F42","v":"SGD"},{"$f":"Expense_Entry!G42","v":{"v":2,"d":"$2.00"}},"SGD to CAD",{"$f":"IF(F42=Reimbursement_Currency,1,IF(G42=\"\",\"\",G42/Expense_Entry!$J42))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":1.59,"d":"$1.59"},null,"N/A",{"$f":"IF(G42=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F42,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":2,"d":"$2.00"}]
[{"$f":"Expense_Entry!A43","v":"2011-03-18"},{"$f":"Expense_Entry!B43","v":"Youniqe Bistro"},{"$f":"Expense_Entry!C43","v":"Coffee"},{"$f":"Expense_Entry!D43","v":"Meals"},{"$f":"Expense_Entry!E43","v":"Cash"},{"$f":"Expense_Entry!F43","v":"SGD"},{"$f":"Expense_Entry!G43","v":{"v":3.2,"d":"$3.20"}},{"$f":"IF(AND(F43<>\"\",Reimbursement_Currency<>\"\"),IF(F43=Reimbursement_Currency,STR_N_A,CONCATENATE(F43,STR_TO,Reimbursement_Currency)),\"\")","v":"SGD to CAD"},{"$f":"IF(F43=Reimbursement_Currency,1,IF(G43=\"\",\"\",G43/Expense_Entry!$J43))","v":{"v":1.2580175454245204,"d":"1.2580"}},{"$f":"IF(F43<>\"\",IF(Reimbursement_Currency=F43,G43,ROUND(G43/I43,2)),\"\")","v":{"v":2.54,"d":"$2.54"}},null,{"$f":"IF(AND(Client_Currency<>\"\",F43<>\"\"),IF(Client_Currency=F43,STR_N_A,CONCATENATE(F43,STR_TO,Client_Currency)),\"\")","v":"N/A"},{"$f":"IF(G43=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F43,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"$f":"IF(AND(Client_Currency<>\"\",F43<>\"\"),IF(Client_Currency=G43,G43,ROUND(G43*M43,2)),\"\")","v":{"v":3.2,"d":"$3.20"}}]
[{"$f":"Expense_Entry!A44","v":"2011-03-18"},{"$f":"Expense_Entry!B44","v":"Starbucks"},{"$f":"Expense_Entry!C44","v":"Coffee"},{"$f":"Expense_Entry!D44","v":"Meals"},{"$f":"Expense_Entry!E44","v":"AMEX"},{"$f":"Expense_Entry!F44","v":"SGD"},{"$f":"Expense_Entry!G44","v":{"v":7.1,"d":"$7.10"}},"SGD to CAD",{"$f":"IF(F44=Reimbursement_Currency,1,IF(G44=\"\",\"\",G44/Expense_Entry!$J44))","v":{"v":1.2580175454245208,"d":"1.2580"}},{"v":5.64,"d":"$5.64"},null,"N/A",{"$f":"IF(G44=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F44,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":7.1,"d":"$7.10"}]
[{"$f":"Expense_Entry!A45","v":"2011-03-18"},{"$f":"Expense_Entry!B45","v":"CS Centrepoint"},{"$f":"Expense_Entry!C45","v":"Dinner"},{"$f":"Expense_Entry!D45","v":"Meals"},{"$f":"Expense_Entry!E45","v":"Cash"},{"$f":"Expense_Entry!F45","v":"SGD"},{"$f":"Expense_Entry!G45","v":{"v":3.4,"d":"$3.40"}},"SGD to CAD",{"$f":"IF(F45=Reimbursement_Currency,1,IF(G45=\"\",\"\",G45/Expense_Entry!$J45))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":2.7,"d":"$2.70"},null,"N/A",{"$f":"IF(G45=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F45,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":3.4,"d":"$3.40"}]
[{"$f":"Expense_Entry!A46","v":"2011-03-18"},{"$f":"Expense_Entry!B46","v":"SingTel"},{"$f":"Expense_Entry!C46","v":"Data SIM"},{"$f":"Expense_Entry!D46","v":"Phone"},{"$f":"Expense_Entry!E46","v":"VISA"},{"$f":"Expense_Entry!F46","v":"SGD"},{"$f":"Expense_Entry!G46","v":{"v":18,"d":"$18.00"}},"SGD to CAD",{"$f":"IF(F46=Reimbursement_Currency,1,IF(G46=\"\",\"\",G46/Expense_Entry!$J46))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":14.31,"d":"$14.31"},null,"N/A",{"$f":"IF(G46=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F46,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":18,"d":"$18.00"}]
[{"$f":"Expense_Entry!A47","v":"2011-03-18"},{"$f":"Expense_Entry!B47","v":"Cold Storage"},{"$f":"Expense_Entry!C47","v":"Dinner"},{"$f":"Expense_Entry!D47","v":"Meals"},{"$f":"Expense_Entry!E47","v":"AMEX"},{"$f":"Expense_Entry!F47","v":"SGD"},{"$f":"Expense_Entry!G47","v":{"v":19.9,"d":"$19.90"}},"SGD to CAD",{"$f":"IF(F47=Reimbursement_Currency,1,IF(G47=\"\",\"\",G47/Expense_Entry!$J47))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":15.82,"d":"$15.82"},null,"N/A",{"$f":"IF(G47=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F47,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":19.9,"d":"$19.90"}]
[{"$f":"Expense_Entry!A48","v":"2011-03-18"},{"$f":"Expense_Entry!B48","v":"Concorde Hotel"},{"$f":"Expense_Entry!C48","v":"Hotel"},{"$f":"Expense_Entry!D48","v":"Hotel"},{"$f":"Expense_Entry!E48","v":"AMEX"},{"$f":"Expense_Entry!F48","v":"SGD"},{"$f":"Expense_Entry!G48","v":{"v":335.45,"d":"$335.45"}},"SGD to CAD",{"$f":"IF(F48=Reimbursement_Currency,1,IF(G48=\"\",\"\",G48/Expense_Entry!$J48))","v":{"v":1.2580175454245208,"d":"1.2580"}},{"v":266.65,"d":"$266.65"},null,"N/A",{"$f":"IF(G48=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F48,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":335.45,"d":"$335.45"}]
[{"$f":"Expense_Entry!A49","v":"2011-03-18"},{"$f":"Expense_Entry!B49","v":"SingTel"},{"$f":"Expense_Entry!C49","v":"Lunch"},{"$f":"Expense_Entry!D49","v":"Meals"},{"$f":"Expense_Entry!E49","v":"Cash"},{"$f":"Expense_Entry!F49","v":"SGD"},{"$f":"Expense_Entry!G49","v":{"v":10,"d":"$10.00"}},"SGD to CAD",{"$f":"IF(F49=Reimbursement_Currency,1,IF(G49=\"\",\"\",G49/Expense_Entry!$J49))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":7.95,"d":"$7.95"},null,"N/A",{"$f":"IF(G49=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F49,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":10,"d":"$10.00"}]
[{"$f":"Expense_Entry!A50","v":"2011-03-19"},{"$f":"Expense_Entry!B50","v":"Concorde Hotel"},{"$f":"Expense_Entry!C50","v":"Hotel"},{"$f":"Expense_Entry!D50","v":"Hotel"},{"$f":"Expense_Entry!E50","v":"AMEX"},{"$f":"Expense_Entry!F50","v":"SGD"},{"$f":"Expense_Entry!G50","v":{"v":335.45,"d":"$335.45"}},"SGD to CAD",{"$f":"IF(F50=Reimbursement_Currency,1,IF(G50=\"\",\"\",G50/Expense_Entry!$J50))","v":{"v":1.2580175454245208,"d":"1.2580"}},{"v":266.65,"d":"$266.65"},null,"N/A",{"$f":"IF(G50=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F50,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":335.45,"d":"$335.45"}]
[{"$f":"Expense_Entry!A51","v":"2011-03-19"},{"$f":"Expense_Entry!B51","v":"Starbucks"},{"$f":"Expense_Entry!C51","v":"Coffee"},{"$f":"Expense_Entry!D51","v":"Meals"},{"$f":"Expense_Entry!E51","v":"AMEX"},{"$f":"Expense_Entry!F51","v":"SGD"},{"$f":"Expense_Entry!G51","v":{"v":5.5,"d":"$5.50"}},"SGD to CAD",{"$f":"IF(F51=Reimbursement_Currency,1,IF(G51=\"\",\"\",G51/Expense_Entry!$J51))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":4.37,"d":"$4.37"},null,"N/A",{"$f":"IF(G51=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F51,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":5.5,"d":"$5.50"}]
[{"$f":"Expense_Entry!A52","v":"2011-03-19"},{"$f":"Expense_Entry!B52","v":"Cold Storage"},{"$f":"Expense_Entry!C52","v":"Snack"},{"$f":"Expense_Entry!D52","v":"Meals"},{"$f":"Expense_Entry!E52","v":"Cash"},{"$f":"Expense_Entry!F52","v":"SGD"},{"$f":"Expense_Entry!G52","v":{"v":6.6,"d":"$6.60"}},"SGD to CAD",{"$f":"IF(F52=Reimbursement_Currency,1,IF(G52=\"\",\"\",G52/Expense_Entry!$J52))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":5.25,"d":"$5.25"},null,"N/A",{"$f":"IF(G52=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F52,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":6.6,"d":"$6.60"}]
[{"$f":"Expense_Entry!A53","v":"2011-03-20"},{"$f":"Expense_Entry!B53","v":"Concorde Hotel"},{"$f":"Expense_Entry!C53","v":"Hotel"},{"$f":"Expense_Entry!D53","v":"Hotel"},{"$f":"Expense_Entry!E53","v":"AMEX"},{"$f":"Expense_Entry!F53","v":"SGD"},{"$f":"Expense_Entry!G53","v":{"v":335.45,"d":"$335.45"}},"SGD to CAD",{"$f":"IF(F53=Reimbursement_Currency,1,IF(G53=\"\",\"\",G53/Expense_Entry!$J53))","v":{"v":1.2580175454245208,"d":"1.2580"}},{"v":266.65,"d":"$266.65"},null,"N/A",{"$f":"IF(G53=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F53,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":335.45,"d":"$335.45"}]
[{"$f":"Expense_Entry!A54","v":"2011-03-20"},{"$f":"Expense_Entry!B54","v":"Starbucks"},{"$f":"Expense_Entry!C54","v":"Coffee"},{"$f":"Expense_Entry!D54","v":"Meals"},{"$f":"Expense_Entry!E54","v":"AMEX"},{"$f":"Expense_Entry!F54","v":"SGD"},{"$f":"Expense_Entry!G54","v":{"v":8.7,"d":"$8.70"}},"SGD to CAD",{"$f":"IF(F54=Reimbursement_Currency,1,IF(G54=\"\",\"\",G54/Expense_Entry!$J54))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":6.92,"d":"$6.92"},null,"N/A",{"$f":"IF(G54=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F54,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":8.7,"d":"$8.70"}]
[{"$f":"Expense_Entry!A55","v":"2011-03-20"},{"$f":"Expense_Entry!B55","v":"Starbucks"},{"$f":"Expense_Entry!C55","v":"Coffee"},{"$f":"Expense_Entry!D55","v":"Meals"},{"$f":"Expense_Entry!E55","v":"AMEX"},{"$f":"Expense_Entry!F55","v":"SGD"},{"$f":"Expense_Entry!G55","v":{"v":5.8,"d":"$5.80"}},"SGD to CAD",{"$f":"IF(F55=Reimbursement_Currency,1,IF(G55=\"\",\"\",G55/Expense_Entry!$J55))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":4.61,"d":"$4.61"},null,"N/A",{"$f":"IF(G55=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F55,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":5.8,"d":"$5.80"}]
[{"$f":"Expense_Entry!A56","v":"2011-03-20"},{"$f":"Expense_Entry!B56","v":"Starbucks"},{"$f":"Expense_Entry!C56","v":"Tip"},{"$f":"Expense_Entry!D56","v":"Meals"},{"$f":"Expense_Entry!E56","v":"Cash"},{"$f":"Expense_Entry!F56","v":"SGD"},{"$f":"Expense_Entry!G56","v":{"v":2.2,"d":"$2.20"}},"SGD to CAD",{"$f":"IF(F56=Reimbursement_Currency,1,IF(G56=\"\",\"\",G56/Expense_Entry!$J56))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":1.75,"d":"$1.75"},null,"N/A",{"$f":"IF(G56=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F56,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":2.2,"d":"$2.20"}]
[{"$f":"Expense_Entry!A57","v":"2011-03-21"},{"$f":"Expense_Entry!B57","v":"Concorde Hotel"},{"$f":"Expense_Entry!C57","v":"Hotel"},{"$f":"Expense_Entry!D57","v":"Hotel"},{"$f":"Expense_Entry!E57","v":"AMEX"},{"$f":"Expense_Entry!F57","v":"SGD"},{"$f":"Expense_Entry!G57","v":{"v":335.45,"d":"$335.45"}},"SGD to CAD",{"$f":"IF(F57=Reimbursement_Currency,1,IF(G57=\"\",\"\",G57/Expense_Entry!$J57))","v":{"v":1.2580175454245208,"d":"1.2580"}},{"v":266.65,"d":"$266.65"},null,"N/A",{"$f":"IF(G57=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F57,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":335.45,"d":"$335.45"}]
[{"$f":"Expense_Entry!A58","v":"2011-03-21"},{"$f":"Expense_Entry!B58","v":"Concorde Hotel"},{"$f":"Expense_Entry!C58","v":"Laundry"},{"$f":"Expense_Entry!D58","v":"Misc."},{"$f":"Expense_Entry!E58","v":"AMEX"},{"$f":"Expense_Entry!F58","v":"SGD"},{"$f":"Expense_Entry!G58","v":{"v":32.49,"d":"$32.49"}},"SGD to CAD",{"$f":"IF(F58=Reimbursement_Currency,1,IF(G58=\"\",\"\",G58/Expense_Entry!$J58))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":25.83,"d":"$25.83"},null,"N/A",{"$f":"IF(G58=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F58,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":32.49,"d":"$32.49"}]
[{"$f":"Expense_Entry!A59","v":"2011-03-21"},{"$f":"Expense_Entry!B59","v":"SingTel"},{"$f":"Expense_Entry!C59","v":"BoM"},{"$f":"Expense_Entry!D59","v":"Phone"},{"$f":"Expense_Entry!E59","v":"AMEX"},{"$f":"Expense_Entry!F59","v":"SGD"},{"$f":"Expense_Entry!G59","v":{"v":18,"d":"$18.00"}},"SGD to CAD",{"$f":"IF(F59=Reimbursement_Currency,1,IF(G59=\"\",\"\",G59/Expense_Entry!$J59))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":14.31,"d":"$14.31"},null,"N/A",{"$f":"IF(G59=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F59,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":18,"d":"$18.00"}]
[{"$f":"Expense_Entry!A60","v":"2011-03-21"},{"$f":"Expense_Entry!B60","v":"Starbucks"},{"$f":"Expense_Entry!C60","v":"Coffee"},{"$f":"Expense_Entry!D60","v":"Meals"},{"$f":"Expense_Entry!E60","v":"AMEX"},{"$f":"Expense_Entry!F60","v":"SGD"},{"$f":"Expense_Entry!G60","v":{"v":7.1,"d":"$7.10"}},"SGD to CAD",{"$f":"IF(F60=Reimbursement_Currency,1,IF(G60=\"\",\"\",G60/Expense_Entry!$J60))","v":{"v":1.2580175454245208,"d":"1.2580"}},{"v":5.64,"d":"$5.64"},null,"N/A",{"$f":"IF(G60=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F60,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":7.1,"d":"$7.10"}]
[{"$f":"Expense_Entry!A61","v":"2011-03-21"},{"$f":"Expense_Entry!B61","v":"Cold Storage"},{"$f":"Expense_Entry!C61","v":"Water"},{"$f":"Expense_Entry!D61","v":"Meals"},{"$f":"Expense_Entry!E61","v":"Cash"},{"$f":"Expense_Entry!F61","v":"SGD"},{"$f":"Expense_Entry!G61","v":{"v":2.15,"d":"$2.15"}},"SGD to CAD",{"$f":"IF(F61=Reimbursement_Currency,1,IF(G61=\"\",\"\",G61/Expense_Entry!$J61))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":1.71,"d":"$1.71"},null,"N/A",{"$f":"IF(G61=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F61,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":2.15,"d":"$2.15"}]
[{"$f":"Expense_Entry!A62","v":"2011-03-21"},{"$f":"Expense_Entry!B62","v":"SingTel"},{"$f":"Expense_Entry!C62","v":"Lunch"},{"$f":"Expense_Entry!D62","v":"Meals"},{"$f":"Expense_Entry!E62","v":"Cash"},{"$f":"Expense_Entry!F62","v":"SGD"},{"$f":"Expense_Entry!G62","v":{"v":2.8,"d":"$2.80"}},"SGD to CAD",{"$f":"IF(F62=Reimbursement_Currency,1,IF(G62=\"\",\"\",G62/Expense_Entry!$J62))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":2.23,"d":"$2.23"},null,"N/A",{"$f":"IF(G62=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F62,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":2.8,"d":"$2.80"}]
[{"$f":"Expense_Entry!A63","v":"2011-03-22"},{"$f":"Expense_Entry!B63","v":"Concorde Hotel"},{"$f":"Expense_Entry!C63","v":"Hotel"},{"$f":"Expense_Entry!D63","v":"Hotel"},{"$f":"Expense_Entry!E63","v":"AMEX"},{"$f":"Expense_Entry!F63","v":"SGD"},{"$f":"Expense_Entry!G63","v":{"v":335.45,"d":"$335.45"}},"SGD to CAD",{"$f":"IF(F63=Reimbursement_Currency,1,IF(G63=\"\",\"\",G63/Expense_Entry!$J63))","v":{"v":1.2580175454245208,"d":"1.2580"}},{"v":266.65,"d":"$266.65"},null,"N/A",{"$f":"IF(G63=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F63,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":335.45,"d":"$335.45"}]
[{"$f":"Expense_Entry!A64","v":"2011-03-22"},{"$f":"Expense_Entry!B64","v":"Starbucks"},{"$f":"Expense_Entry!C64","v":"Coffee"},{"$f":"Expense_Entry!D64","v":"Meals"},{"$f":"Expense_Entry!E64","v":"AMEX"},{"$f":"Expense_Entry!F64","v":"SGD"},{"$f":"Expense_Entry!G64","v":{"v":7.1,"d":"$7.10"}},"SGD to CAD",{"$f":"IF(F64=Reimbursement_Currency,1,IF(G64=\"\",\"\",G64/Expense_Entry!$J64))","v":{"v":1.2580175454245208,"d":"1.2580"}},{"v":5.64,"d":"$5.64"},null,"N/A",{"$f":"IF(G64=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F64,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":7.1,"d":"$7.10"}]
[{"$f":"Expense_Entry!A65","v":"2011-03-22"},{"$f":"Expense_Entry!B65","v":"Cold Storage"},{"$f":"Expense_Entry!C65","v":"Dinner"},{"$f":"Expense_Entry!D65","v":"Meals"},{"$f":"Expense_Entry!E65","v":"AMEX"},{"$f":"Expense_Entry!F65","v":"SGD"},{"$f":"Expense_Entry!G65","v":{"v":26.5,"d":"$26.50"}},"SGD to CAD",{"$f":"IF(F65=Reimbursement_Currency,1,IF(G65=\"\",\"\",G65/Expense_Entry!$J65))","v":{"v":1.2580175454245208,"d":"1.2580"}},{"v":21.06,"d":"$21.06"},null,"N/A",{"$f":"IF(G65=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F65,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":26.5,"d":"$26.50"}]
[{"$f":"Expense_Entry!A66","v":"2011-03-22"},{"$f":"Expense_Entry!B66","v":"SingTel"},{"$f":"Expense_Entry!C66","v":"Lunch"},{"$f":"Expense_Entry!D66","v":"Meals"},{"$f":"Expense_Entry!E66","v":"Cash"},{"$f":"Expense_Entry!F66","v":"SGD"},{"$f":"Expense_Entry!G66","v":{"v":5.5,"d":"$5.50"}},"SGD to CAD",{"$f":"IF(F66=Reimbursement_Currency,1,IF(G66=\"\",\"\",G66/Expense_Entry!$J66))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":4.37,"d":"$4.37"},null,"N/A",{"$f":"IF(G66=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F66,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":5.5,"d":"$5.50"}]
[{"$f":"Expense_Entry!A67","v":"2011-03-23"},{"$f":"Expense_Entry!B67","v":"Concorde Hotel"},{"$f":"Expense_Entry!C67","v":"Hotel"},{"$f":"Expense_Entry!D67","v":"Hotel"},{"$f":"Expense_Entry!E67","v":"AMEX"},{"$f":"Expense_Entry!F67","v":"SGD"},{"$f":"Expense_Entry!G67","v":{"v":335.45,"d":"$335.45"}},"SGD to CAD",{"$f":"IF(F67=Reimbursement_Currency,1,IF(G67=\"\",\"\",G67/Expense_Entry!$J67))","v":{"v":1.2580175454245208,"d":"1.2580"}},{"v":266.65,"d":"$266.65"},null,"N/A",{"$f":"IF(G67=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F67,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":335.45,"d":"$335.45"}]
[{"$f":"Expense_Entry!A68","v":"2011-03-23"},{"$f":"Expense_Entry!B68","v":"Starbucks"},{"$f":"Expense_Entry!C68","v":"Coffee"},{"$f":"Expense_Entry!D68","v":"Meals"},{"$f":"Expense_Entry!E68","v":"AMEX"},{"$f":"Expense_Entry!F68","v":"SGD"},{"$f":"Expense_Entry!G68","v":{"v":7.9,"d":"$7.90"}},"SGD to CAD",{"$f":"IF(F68=Reimbursement_Currency,1,IF(G68=\"\",\"\",G68/Expense_Entry!$J68))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":6.28,"d":"$6.28"},null,"N/A",{"$f":"IF(G68=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F68,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":7.9,"d":"$7.90"}]
[{"$f":"Expense_Entry!A69","v":"2011-03-23"},{"$f":"Expense_Entry!B69","v":"Burger King"},{"$f":"Expense_Entry!C69","v":"Lunch"},{"$f":"Expense_Entry!D69","v":"Meals"},{"$f":"Expense_Entry!E69","v":"Cash"},{"$f":"Expense_Entry!F69","v":"SGD"},{"$f":"Expense_Entry!G69","v":{"v":7.65,"d":"$7.65"}},"SGD to CAD",{"$f":"IF(F69=Reimbursement_Currency,1,IF(G69=\"\",\"\",G69/Expense_Entry!$J69))","v":{"v":1.2580175454245206,"d":"1.2580"}},{"v":6.08,"d":"$6.08"},null,"N/A",{"$f":"IF(G69=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F69,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":1,"d":"1.0000"}},{"v":7.65,"d":"$7.65"}]
[{"$f":"Expense_Entry!A70","v":"2011-03-23"},{"$f":"Expense_Entry!B70","v":"Starbucks"},{"$f":"Expense_Entry!C70","v":"Coffee"},{"$f":"Expense_Entry!D70","v":"Meals"},{"$f":"Expense_Entry!E70","v":"AMEX"},{"$f":"Expense_Entry!F70","v":"HKG"},{"$f":"Expense_Entry!G70","v":{"v":26,"d":"$26.00"}},"HKG to CAD",{"$f":"IF(F70=Reimbursement_Currency,1,IF(G70=\"\",\"\",G70/Expense_Entry!$J70))","v":{"v":7.807807807807808,"d":"7.8078"}},{"v":3.33,"d":"$3.33"},null,"HKG to SGD",{"$f":"IF(G70=\"\",\"\",VLOOKUP(Client_Currency,Expense_Entry!FX_Rate_Tbl,2,FALSE())/VLOOKUP(F70,Expense_Entry!FX_Rate_Tbl,2,FALSE()))","v":{"v":0.1598956158663883,"d":"0.1599"}},{"v":4.16,"d":"$4.16"}]
[]
[{"$f":"\"   Reimbursement Totals (Advisor Currency) -- \" & Reimbursement_Currency","v":"   Reimbursement Totals (Advisor Currency) -- CAD"}]
["Sum of Reim Amt.","Column Labels"]
["Row Labels","2011-03-11","2011-03-12","2011-03-13","2011-03-14","2011-03-15","2011-03-16","2011-03-17","2011-03-18","2011-03-19","2011-03-20","2011-03-21","2011-03-22","2011-03-23","Grand Total"]
["Airfare",null,{"v":11000.81,"d":"$11,000.81"},{"$nulls":11},{"v":11000.81,"d":"$11,000.81"}]
["Hotel",null,{"v":134.47,"d":"$134.47"},{"v":5,"d":"$5.00"},{"v":266.65,"d":"$266.65"},{"v":266.65,"d":"$266.65"},{"v":266.65,"d":"$266.65"},{"v":266.65,"d":"$266.65"},{"v":266.65,"d":"$266.65"},{"v":266.65,"d":"$266.65"},{"v":266.65,"d":"$266.65"},{"v":266.65,"d":"$266.65"},{"v":266.65,"d":"$266.65"},{"v":266.65,"d":"$266.65"},{"v":2805.9700000000003,"d":"$2,805.97"}]
["Meals",{"v":13.09,"d":"$13.09"},{"v":48.13,"d":"$48.13"},{"v":5.25,"d":"$5.25"},null,{"v":7.869999999999999,"d":"$7.87"},{"v":42.290000000000006,"d":"$42.29"},{"v":35.190000000000005,"d":"$35.19"},{"v":34.65,"d":"$34.65"},{"v":9.620000000000001,"d":"$9.62"},{"v":13.280000000000001,"d":"$13.28"},{"v":9.58,"d":"$9.58"},{"v":31.07,"d":"$31.07"},{"v":15.69,"d":"$15.69"},{"v":265.71000000000004,"d":"$265.71"}]
["Mileage",{"v":19.76,"d":"$19.76"},{"$nulls":12},{"v":19.76,"d":"$19.76"}]
["Misc.",null,null,{"v":2.5,"d":"$2.50"},null,{"v":19.87,"d":"$19.87"},null,{"v":25.83,"d":"$25.83"},{"$nulls":3},{"v":25.83,"d":"$25.83"},null,null,{"v":74.03,"d":"$74.03"}]
["Parking",{"v":6,"d":"$6.00"},{"$nulls":12},{"v":6,"d":"$6.00"}]
["Phone",{"$nulls":4},{"v":14.31,"d":"$14.31"},null,{"v":0.34,"d":"$0.34"},{"v":14.31,"d":"$14.31"},null,null,{"v":14.31,"d":"$14.31"},null,null,{"v":43.27,"d":"$43.27"}]
["Taxi",null,{"v":20,"d":"$20.00"},null,null,{"v":24.28,"d":"$24.28"},{"$nulls":8},{"v":44.28,"d":"$44.28"}]
["Grand Total",{"v":38.85,"d":"$38.85"},{"v":11203.409999999998,"d":"$11,203.41"},{"v":12.75,"d":"$12.75"},{"v":266.65,"d":"$266.65"},{"v":332.98,"d":"$332.98"},{"v":308.94,"d":"$308.94"},{"v":328.00999999999993,"d":"$328.01"},{"v":315.60999999999996,"d":"$315.61"},{"v":276.27,"d":"$276.27"},{"v":279.92999999999995,"d":"$279.93"},{"v":316.36999999999995,"d":"$316.37"},{"v":297.71999999999997,"d":"$297.72"},{"v":282.34,"d":"$282.34"},{"v":14259.83,"d":"$14,259.83"}]
[]
[]
[]
[{"$f":"\"   Invoice Totals (Client Currency) -- \" & Client_Currency","v":"   Invoice Totals (Client Currency) -- SGD"}]
["Sum of Inv. Amt.","Column Labels"]
["Row Labels","2011-03-11","2011-03-12","2011-03-13","2011-03-14","2011-03-15","2011-03-16","2011-03-17","2011-03-18","2011-03-19","2011-03-20","2011-03-21","2011-03-22","2011-03-23","Grand Total"]
["Airfare",null,{"v":13733.79,"d":"$13,733.79"},{"$nulls":11},{"v":13733.79,"d":"$13,733.79"}]
["Hotel",null,{"v":167.88,"d":"$167.88"},{"v":6.24,"d":"$6.24"},{"v":335.45,"d":"$335.45"},{"v":335.45,"d":"$335.45"},{"v":335.45,"d":"$335.45"},{"v":335.45,"d":"$335.45"},{"v":335.45,"d":"$335.45"},{"v":335.45,"d":"$335.45"},{"v":335.45,"d":"$335.45"},{"v":335.45,"d":"$335.45"},{"v":335.45,"d":"$335.45"},{"v":335.45,"d":"$335.45"},{"v":3528.6199999999994,"d":"$3,528.62"}]
["Meals",{"v":16.5,"d":"$16.50"},{"v":60.09,"d":"$60.09"},{"v":6.55,"d":"$6.55"},null,{"v":9.899999999999999,"d":"$9.90"},{"v":53.2,"d":"$53.20"},{"v":44.269999999999996,"d":"$44.27"},{"v":43.6,"d":"$43.60"},{"v":12.1,"d":"$12.10"},{"v":16.7,"d":"$16.70"},{"v":12.05,"d":"$12.05"},{"v":39.1,"d":"$39.10"},{"v":19.71,"d":"$19.71"},{"v":333.77,"d":"$333.77"}]
["Mileage",{"v":28.1,"d":"$28.10"},{"$nulls":12},{"v":28.1,"d":"$28.10"}]
["Misc.",null,null,{"v":3.12,"d":"$3.12"},null,{"v":25,"d":"$25.00"},null,{"v":32.49,"d":"$32.49"},{"$nulls":3},{"v":32.49,"d":"$32.49"},null,null,{"v":93.1,"d":"$93.10"}]
["Parking",{"v":7.49,"d":"$7.49"},{"$nulls":12},{"v":7.49,"d":"$7.49"}]
["Phone",{"$nulls":4},{"v":18,"d":"$18.00"},null,{"v":0.43,"d":"$0.43"},{"v":18,"d":"$18.00"},null,null,{"v":18,"d":"$18.00"},null,null,{"v":54.43,"d":"$54.43"}]
["Taxi",null,{"v":24.97,"d":"$24.97"},null,null,{"v":30.55,"d":"$30.55"},{"$nulls":8},{"v":55.519999999999996,"d":"$55.52"}]
["Grand Total",{"v":52.09,"d":"$52.09"},{"v":13986.73,"d":"$13,986.73"},{"v":15.91,"d":"$15.91"},{"v":335.45,"d":"$335.45"},{"v":418.9,"d":"$418.90"},{"v":388.65,"d":"$388.65"},{"v":412.64,"d":"$412.64"},{"v":397.05,"d":"$397.05"},{"v":347.55,"d":"$347.55"},{"v":352.15,"d":"$352.15"},{"v":397.99,"d":"$397.99"},{"v":374.55,"d":"$374.55"},{"v":355.15999999999997,"d":"$355.16"},{"v":17834.82,"d":"$17,834.82"}]

{"sheet":"NonReim_Summary","index":6,"n_rows":12,"n_cols":8,"rows_kept":12}
[null,{"$f":"Reim_Detail!A1","v":"Expense Report—Employee Name [ Week 14 ]"}]
[]
[null,{"$f":"Cover!B4","v":"Trip Start: "},{"$f":"Trip_Start","v":"2004-03-29"},{"$nulls":3},{"$f":"Reim_Detail!D3","v":"Total Amount: "},{"$f":"Total_Est_NonReim_Amt","v":0}]
[null,{"$f":"Cover!B5","v":"Trip End: "},{"$f":"Trip_End","v":"00:00:00"},{"$nulls":3},{"$f":"Reim_Detail!D4","v":"Client Currency: "},{"$f":"Reimbursement_Currency","v":"CAD"}]
[null,{"$f":"Cover!B6","v":"Client: "},{"$f":"Client","v":"Client Name"},{"$nulls":3},"Total Final Amount: ",{"$f":"Total_Est_NonReim_Amt+NonReim_Difference","v":0}]
[null,{"$f":"Cover!B7","v":"Destination: "},{"$f":"Destination","v":"Politsania"}]
[null,{"$f":"Cover!B8","v":"Purpose: "},{"$f":"Purpose","v":"Demo data"}]
[]
[null,"Sum of Home Amt.","Type"]
[null,"Date","(blank)","Grand Total"]
[null,"(blank)",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,"Grand Total",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]

{"sheet":"NonReim_Detail","index":7,"n_rows":31,"n_cols":11,"rows_kept":31}
[{"$f":"Cover!B1","v":"Expense Report—Employee Name [ Week 14 ]"}]
[]
[{"$f":"Cover!B4","v":"Trip Start: "},{"$f":"Trip_Start","v":"2004-03-29"},null,"Total Amount: ",{"$f":"Total_Est_NonReim_Amt","v":0},null,"Currency","FX Rate"]
[{"$f":"Cover!B5","v":"Trip End: "},{"$f":"Trip_End","v":"00:00:00"},{"$nulls":3},{"$f":"IF(H4=1,\"Home→\",\"\")","v":"Home→"},{"$f":"INDEX(Cover!FX_Names,ROW(G4)-3,1)","v":"CAD"},{"$f":"VLOOKUP(G4,Cover!FX_Rate_Tbl,2,FALSE)/VLOOKUP(Reimbursement_Currency,Cover!FX_Rate_Tbl,2,FALSE)","v":{"v":1,"d":"1.0000"}}]
[{"$f":"Cover!B6","v":"Client: "},{"$f":"Client","v":"Client Name"},{"$nulls":3},{"$f":"IF(H5=1,\"Home→\",\"\")","v":""},{"$f":"INDEX(Cover!FX_Names,ROW(G5)-3,1)","v":"USD"},{"$f":"VLOOKUP(G5,Cover!FX_Rate_Tbl,2,FALSE)/VLOOKUP(Reimbursement_Currency,Cover!FX_Rate_Tbl,2,FALSE)","v":{"v":0.9370314842578711,"d":"0.9370"}}]
[{"$f":"Cover!B7","v":"Destination: "},{"$f":"Destination","v":"Politsania"},{"$nulls":3},"",{"$f":"INDEX(Cover!FX_Names,ROW(G6)-3,1)","v":"SGD"},{"$f":"VLOOKUP(G6,Cover!FX_Rate_Tbl,2,FALSE)/VLOOKUP(Reimbursement_Currency,Cover!FX_Rate_Tbl,2,FALSE)","v":{"v":1.2484342379958246,"d":"1.2484"}}]
[{"$f":"Cover!B8","v":"Purpose: "},{"$f":"Purpose","v":"Demo data"},{"$nulls":3},"",{"$f":"INDEX(Cover!FX_Names,ROW(G7)-3,1)","v":"HKG"},{"$f":"VLOOKUP(G7,Cover!FX_Rate_Tbl,2,FALSE)/VLOOKUP(Reimbursement_Currency,Cover!FX_Rate_Tbl,2,FALSE)","v":{"v":7.807807807807808,"d":"7.8078"}},null,"Calculate Foreign"]
[{"$nulls":5},"",{"$f":"INDEX(Cover!FX_Names,ROW(G8)-3,1)","v":"Other 1"},{"$f":"VLOOKUP(G8,Cover!FX_Rate_Tbl,2,FALSE)/VLOOKUP(Reimbursement_Currency,Cover!FX_Rate_Tbl,2,FALSE)","v":0},null,"Currency Adjustment"]
[{"$nulls":7},"Estimated",null,"Actual"]
["Date","Establishment","Description","Type","Method","Currency","Exp. Amt.","Home Amt.","-","Levied Amt.","Difference"]
[{"$nulls":7},{"$f":"IF(OR(ISBLANK(F11),ISBLANK(G11)),\"\",ROUND(G11/VLOOKUP(F11,FX_Rate_Tbl,2,FALSE),2))","v":""},null,null,{"$f":"IF(Reimbursement_Currency=F11,0,IF(ISBLANK(J11),STR_TBD,ROUND(J11-(H11/VLOOKUP(Reimbursement_Currency,FX_Rate_Tbl,2)),2)))","v":"    TBD"}]
[{"$nulls":7},"",null,null,"    TBD"]
[{"$nulls":7},"",null,null,"    TBD"]
[{"$nulls":7},"",null,null,"    TBD"]
[{"$nulls":7},"",null,null,"    TBD"]
[{"$nulls":7},"",null,null,"    TBD"]
[{"$nulls":7},"",null,null,"    TBD"]
[{"$nulls":7},"",null,null,"    TBD"]
[{"$nulls":7},"",null,null,"    TBD"]
[{"$nulls":7},"",null,null,"    TBD"]
[{"$nulls":7},"",null,null,"    TBD"]
[{"$nulls":7},"",null,null,"    TBD"]
[{"$nulls":7},"",null,null,"    TBD"]
[{"$nulls":7},"",null,null,"    TBD"]
[{"$nulls":7},"",null,null,"    TBD"]
[{"$nulls":7},"",null,null,"    TBD"]
[{"$nulls":7},"",null,null,"    TBD"]
[{"$nulls":7},"",null,null,"    TBD"]
[{"$nulls":7},"",null,null,"    TBD"]
[{"$nulls":7},"",null,null,"    TBD"]
[{"$nulls":6},"Total: ",{"$f":"SUM(H11:H30)","v":0},null,"B/W: ",{"$f":"SUM(K11:K30)","v":0}]

{"sheet":"Rules","index":8,"n_rows":37,"n_cols":2,"rows_kept":37}
[]
[null,"Methods"]
[null,"Account"]
[null,"AMEX"]
[null,"Cash"]
[null,"Mileage"]
[null,"SBX"]
[null,"VISA"]
[]
[null,"Types"]
[null,"Airfare"]
[null,"Car Rental"]
[null,"Hotel"]
[null,"Meals"]
[null,"Mileage"]
[null,"Misc."]
[null,"Parking"]
[null,"Phone"]
[null,"Taxi"]
[null,"Train"]
[]
[null,"Personal"]
[null,"Types"]
[null,"Airfare"]
[null,"Car Rental"]
[null,"Hotel"]
[null,"Meals"]
[null,"Misc."]
[null,"Office"]
[null,"Parking"]
[null,"Phone"]
[null,"Taxi"]
[]
[null,"Constants"]
[null,"N/A"]
[null,"    TBD"]
[null," to "]

{"sheet":"ChangeLog","index":9,"n_rows":12,"n_cols":3,"rows_kept":12}
["Date","Vers.","Notes"]
["2004-08-10",10.1,"First public release."]
["2005-05-26",10.3,"Added extra rows to input sheet."]
["2005-06-04",{"v":11,"d":"11.0"},"Added extra ExpenseConversion sheet to meet head office data submision requirements."]
["2006-01-06",11.1,"Turned on protection for each sheet (no password)."]
["2006-07-04",{"v":12,"d":"12.0"},"Corrected currency conversion formulae."]
["2006-10-06",12.1,"Turned off protection & inserted new \"Mileage\" type."]
["2006-11-10",12.2,"Added Mileage & Account as Methods."]
["2007-01-06",12.3,"Added Mileage Rate field to cover page."]
["2008-07-12",12.8,"Added SBX Exepense Method & pivot tables to US Exchange worksheet."]
["2011-03-31",{"v":13,"d":"13.0"},"Attempted to fix some problems with formulae on the Reim_Detail tab.  There are still problems and the template requires a complete re-work."]
["2011-05-08",{"v":14,"d":"14.0"},"Rebuilt the template from scratch in Excel 2010.  No attempt was made to retain backward compatibility with old version of Excel."]