{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["v4.0","v4.1","CHANGES","VOUCHER"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"v4.0","index":0,"n_rows":84,"n_cols":14,"rows_kept":84,"cut":false,"hidden":true,"merged":[[0,2,0,5],[69,0,69,6],[71,0,83,0],[54,2,54,4],[62,2,62,4],[68,1,68,3],[68,4,68,6],[43,4,43,5]]}
[null,null,"Additional Space:"]
[]
[]
[null,"Start Date:",null,"End Date:"]
[null,"AirFare 1:",null,null,"COM. CARR.-I:",{"$f":"C5+C6+C7+C8+C9+C10+C11+C12+J5+J6+J7+J8+J9+J10+J11+J12","v":0},null,null,"AirFare 5:"]
[null,"CTO Fee 1:",null,null,null,null,null,null,"CTO Fee 5:"]
[null,"Airfare 2:",null,null,null,null,null,null,"Airfare 6:"]
[null,"CTO Fee 2:",null,null,null,null,null,null,"CTO Fee 6:"]
[null,"Airfare 3:",null,null,null,null,null,null,"Airfare 7:"]
[null,"CTO Fee 3:",null,null,null,null,null,null,"CTO Fee 7:"]
[null,"Airfare 4:",null,null,null,null,null,null,"Airfare 8:"]
[null,"CTO Fee 4:",null,null,null,null,null,null,"CTO Fee 8:"]
[null,null,null,null,"Total LODGING:",{"$f":"D15+D20+D25+D30+K15+K20+K25+K30","v":0}]
[null,"Number of nights:",{"$f":"G17","v":0},null,null,null,null,null,"Number of nights:",{"$f":"N17","v":0}]
[null,"Hotel Room 1:",null,{"$f":"C14*C15","v":0},"Total Room:",{"$f":"D15","v":0},null,null,"Hotel Room 5:",null,{"$f":"J14*J15","v":0},"Total Room:",{"$f":"K15","v":0}]
[null,"Room Tax 1:",null,{"$f":"C16*C14","v":0},"Total Taxes:",{"$f":"D16+D17+D18","v":0},null,null,"Room Tax 1:",null,{"$f":"J16*J14","v":0},"Total Taxes:",{"$f":"K16+K17+K18","v":0}]
[null,"Room Tax 2:",null,{"$f":"C17*C14","v":0},"Total Bill:",{"$f":"F15+F16","v":0},{"$f":"G16-G15","v":0},null,"Room Tax 2:",null,{"$f":"J17*J14","v":0},"Total Bill:",{"$f":"M15+M16","v":0},{"$f":"N16-N15","v":0}]
[null,"Room Tax 3:",null,{"$f":"C18*C14","v":0},null,null,null,null,"Room Tax 3:",null,{"$f":"J18*J14","v":0}]
[null,"Number of nights:",{"$f":"G22","v":0},null,null,null,"Date Calc:",null,"Number of nights:",{"$f":"N22","v":0},null,null,null,"Date Calc:"]
[null,"Hotel Room 2:",null,{"$f":"C20*C19","v":0},"Total Room:",{"$f":"D20","v":0},null,null,"Hotel Room 6:",null,{"$f":"J20*J19","v":0},"Total Room:",{"$f":"K20","v":0}]
[null,"Room Tax 1:",null,{"$f":"C21*C19","v":0},"Total Taxes:",{"$f":"D21+D22+D23","v":0},null,null,"Room Tax 1:",null,{"$f":"J21*J19","v":0},"Total Taxes:",{"$f":"K21+K22+K23","v":0}]
[null,"Room Tax 2:",null,{"$f":"C22*C19","v":0},"Total Bill:",{"$f":"F20+F21","v":0},{"$f":"G21-G20","v":0},null,"Room Tax 2:",null,{"$f":"J22*J19","v":0},"Total Bill:",{"$f":"M20+M21","v":0},{"$f":"N21-N20","v":0}]
[null,"Room Tax 3:",null,{"$f":"C23*C19","v":0},null,null,null,null,"Room Tax 3:",null,{"$f":"J23*J19","v":0}]
[null,"Number of nights:",{"$f":"G27","v":0},null,null,null,"Date Calc:",null,"Number of nights:",{"$f":"N27","v":0},null,null,null,"Date Calc:"]
[null,"Hotel Room 3:",null,{"$f":"C25*C24","v":0},"Total Room:",{"$f":"D25","v":0},null,null,"Hotel Room 7:",null,{"$f":"J25*J24","v":0},"Total Room:",{"$f":"K25","v":0}]
[null,"Room Tax 1:",null,{"$f":"C26*C24","v":0},"Total Taxes:",{"$f":"D26+D27+D28","v":0},null,null,"Room Tax 1:",null,{"$f":"J26*J24","v":0},"Total Taxes:",{"$f":"K26+K27+K28","v":0}]
[null,"Room Tax 2:",null,{"$f":"C27*C24","v":0},"Total Bill:",{"$f":"F25+F26","v":0},{"$f":"G26-G25","v":0},null,"Room Tax 2:",null,{"$f":"J27*J24","v":0},"Total Bill:",{"$f":"M25+M26","v":0},{"$f":"N26-N25","v":0}]
[null,"Room Tax 3:",null,{"$f":"C28*C24","v":0},null,null,null,null,"Room Tax 3:",null,{"$f":"J28*J24","v":0}]
[null,"Number of nights:",{"$f":"G32","v":0},null,null,null,"Date Calc:",null,"Number of nights:",{"$f":"N32","v":0},null,null,null,"Date Calc:"]
[null,"Hotel Room 4:",null,{"$f":"C30*C29","v":0},"Total Room:",{"$f":"D30","v":0},null,null,"Hotel Room 8:",null,{"$f":"J30*J29","v":0},"Total Room:",{"$f":"K30","v":0}]
[null,"Room Tax 1:",null,{"$f":"C31*C29","v":0},"Total Taxes:",{"$f":"D31+D32+D33","v":0},null,null,"Room Tax 1:",null,{"$f":"J31*J29","v":0},"Total Taxes:",{"$f":"K31+K32+K33","v":0}]
[null,"Room Tax 2:",null,{"$f":"C32*C29","v":0},"Total Bill:",{"$f":"F30+F31","v":0},{"$f":"G31-G30","v":0},null,"Room Tax 2:",null,{"$f":"J32*J29","v":0},"Total Bill:",{"$f":"M30+M31","v":0},{"$f":"N31-N30","v":0}]
[null,"Room Tax 3:",null,{"$f":"C33*C29","v":0},null,null,null,null,"Room Tax 3:",null,{"$f":"J33*J29","v":0}]
[null,"Rental Car 1:",null,null,"RENTAL CAR:",{"$f":"C34+C35+C36+J34+J35+J36","v":0},null,null,"Rental Car 4:"]
[null,"Rental Car 2:",null,null,null,null,null,null,"Rental Car 5:"]
[null,"Rental Car 3:",null,null,null,null,null,null,"Rental Car 6:"]
[null,"Gas 1:",null,null,"TRANSPORT:",{"$f":"C37+C38+C39+C40+C41+C42+J37+J38+J39+J40+J41+J42","v":0},null,null,"Gas 7:"]
[null,"Gas 2:",null,null,null,null,null,null,"Gas 8:"]
[null,"Gas 3:",null,null,null,null,null,null,"Gas 9:"]
[null,"Gas 4:",null,null,null,null,null,null,"Gas 10:"]
[null,"Gas 5:",null,null,null,null,null,null,"Gas 11:"]
[null,"Gas 6:",null,null,null,null,null,null,"Gas 12:"]
[null,"Hotel Room Taxes:",{"$f":"F16+F21+F26+F31+M16+M21+M26+M31","v":0},null,"OTHER:",{"$f":"C43+C44+C45+C46+C47+C48+C49+C50+C51+C52+C53+J43+J44+J45+J46+J47+J48+J49+J50+J51+J52+J53","v":0},"Add em up",null,"Misc 1:",null,null,null,null,"Add em up"]
[null,"Parking Term:",null,null,"Taxi Fare Finder",null,null,null,"Misc 2:"]
[null,"Parking TDY:",null,null,null,null,null,null,"Misc 3:"]
[null,"FCC Fees:",null,null,null,null,null,null,"Misc 4:"]
[null,"Public Trans:",null,null,null,null,null,null,"Misc 5:"]
[null,"Tolls 1:",null,null,null,null,null,null,"Misc 6:"]
[null,"Tolls 2:",null,null,null,null,null,null,"Misc 7:"]
[null,"Taxi 1:",null,null,null,null,null,null,"Misc 8:"]
[null,"Taxi 2:",null,null,null,null,null,null,"Misc 9:"]
[null,"Baggage 1:",null,null,null,null,null,null,"Misc 10:"]
[null,"Baggage 2:",null,null,null,null,{"$f":"SUM(G44:G52)","v":0},null,"Misc 11:",null,null,null,null,{"$f":"SUM(N44:N52)","v":0}]
[]
[null,null,"Tax Pro-Rater",null,null,"#of Nights:"]
[null,"Charged Rate:",null,"-",null,":Allowable Rate"]
[null,"Tax 1:",null,{"$f":"C57/C56","v":{"$error":"#DIV/0!"}},{"$f":"E56*D57","v":{"$error":"#DIV/0!"}},{"$f":"E57*G55","v":{"$error":"#DIV/0!"}}]
[null,"Tax 2:",null,{"$f":"C58/C56","v":{"$error":"#DIV/0!"}},{"$f":"E56*D58","v":{"$error":"#DIV/0!"}},{"$f":"E58*G55","v":{"$error":"#DIV/0!"}}]
[null,"Tax 3:",null,{"$f":"C59/C56","v":{"$error":"#DIV/0!"}},{"$f":"E56*D59","v":{"$error":"#DIV/0!"}},{"$f":"E59*G55","v":{"$error":"#DIV/0!"}}]
[null,"Tax 4:",null,"Flat",{"$f":"C60","v":0},{"$f":"E60*G55","v":0}]
[null,null,null,null,"Total Allowable Taxes:",{"$f":"F57+F58+F59+F60","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Taxi Tip Pro-Rater",null,null,"Allowed:"]
[null,"Taxi Fare 1:",null,{"$f":"C64*20%","v":0},": Max Tip",{"$f":"C64+D64","v":0}]
[null,"Taxi Fare 2:",null,{"$f":"C65*20%","v":0},": Max Tip",{"$f":"C65+D65","v":0}]
[null,"Taxi Fare 3:",null,{"$f":"C66*20%","v":0},": Max Tip",{"$f":"C66+D66","v":0}]
[null,"Taxi Fare 4:",null,{"$f":"C67*20%","v":0},": Max Tip",{"$f":"C67+D67","v":0}]
[]
[null,"XE Currency Converter",null,null,"OANDA"]
["DO NOT CHANGE ANY YELLOW BOX  -  ONLY MODIFY THE GREEN OR WHITE BOXES"]
[]
["EURO",null,400,500,"E Rate:",{"$f":"D72/C72","v":1.25}]
[null,null,null,null,null,"# of nights"]
[null,null,null,null,"Per Night",4]
[null,"Room Charge",50,{"$f":"C75*F72","v":62.5}]
[null,"Govt Levy",2.5,{"$f":"C76*F72","v":3.125},{"$f":"SUM(D75:D76)","v":65.625},{"$f":"E76*F74","v":262.5}]
[null,"Service Charge Fee",1.5,{"$f":"C77*F72","v":1.875},null,null,"Total"]
[null,"Service Charge Fee",3,{"$f":"C78*F72","v":3.75},{"$f":"D77+D78","v":5.625},{"$f":"E78*F74","v":22.5},"Stay"]
[null,"Donation Fee",1,{"$f":"C79*F72","v":1.25},null,null,{"$f":"F76+F78+D79","v":286.25}]
[null,"Additional Expenses:"]
[null,null,100,{"$f":"C81*$F$72","v":125},null,null,{"$f":"F81*$F$72","v":0}]
[null,null,125,{"$f":"C82*$F$72","v":156.25},null,0,{"$f":"F82*$F$72","v":0}]
[null,null,150,{"$f":"C83*$F$72","v":187.5},null,0,{"$f":"F83*$F$72","v":0}]
[null,null,200,{"$f":"C84*$F$72","v":250},null,0,{"$f":"F84*$F$72","v":0}]

{"sheet":"v4.1","index":1,"n_rows":98,"n_cols":14,"rows_kept":98,"cut":false,"hidden":true,"merged":[[83,0,83,6],[85,0,97,0],[0,2,0,5],[38,4,38,5],[68,2,68,4],[76,2,76,4],[82,1,82,3],[82,4,82,6],[58,1,65,3]]}
[null,null,"Additional Space:"]
[]
[]
[null,"Start Date:",null,"End Date:"]
[null,"AirFare 1:",null,null,"COM. CARR.-I:",{"$f":"C5+C6+C7+C8+C9+C10+C11+C12+J5+J6+J7+J8+J9+J10+J11+J12","v":0},null,null,"AirFare 5:"]
[null,"CTO Fee 1:",null,null,null,null,null,null,"CTO Fee 5:"]
[null,"Airfare 2:",null,null,null,null,null,null,"Airfare 6:"]
[null,"CTO Fee 2:",null,null,null,null,null,null,"CTO Fee 6:"]
[null,"Airfare 3:",null,null,null,null,null,null,"Airfare 7:"]
[null,"CTO Fee 3:",null,null,null,null,null,null,"CTO Fee 7:"]
[null,"Airfare 4:",null,null,null,null,null,null,"Airfare 8:"]
[null,"CTO Fee 4:",null,null,null,null,null,null,"CTO Fee 8:"]
[null,null,null,null,"Total LODGING:",{"$f":"D15+D20+D25+D30+K15+K20+K25+K30","v":0}]
[null,"Number of nights:",{"$f":"G17","v":0},null,null,null,"Date Calc:",null,"Number of nights:",{"$f":"N17","v":0},null,null,null,"Date Calc:"]
[null,"Hotel Room 1:",null,{"$f":"C14*C15","v":0},"Total Room:",{"$f":"D15","v":0},null,null,"Hotel Room 5:",null,{"$f":"J14*J15","v":0},"Total Room:",{"$f":"K15","v":0}]
[null,"Room Tax 1:",null,{"$f":"C16*C14","v":0},"Total Taxes:",{"$f":"D16+D17+D18","v":0},null,null,"Room Tax 1:",null,{"$f":"J16*J14","v":0},"Total Taxes:",{"$f":"K16+K17+K18","v":0}]
[null,"Room Tax 2:",null,{"$f":"C17*C14","v":0},"Total Bill:",{"$f":"F15+F16","v":0},{"$f":"G16-G15","v":0},null,"Room Tax 2:",null,{"$f":"J17*J14","v":0},"Total Bill:",{"$f":"M15+M16","v":0},{"$f":"N16-N15","v":0}]
[null,"Room Tax 3:",null,{"$f":"C18*C14","v":0},null,null,null,null,"Room Tax 3:",null,{"$f":"J18*J14","v":0}]
[null,"Number of nights:",{"$f":"G22","v":0},null,null,null,"Date Calc:",null,"Number of nights:",{"$f":"N22","v":0},null,null,null,"Date Calc:"]
[null,"Hotel Room 2:",null,{"$f":"C20*C19","v":0},"Total Room:",{"$f":"D20","v":0},null,null,"Hotel Room 6:",null,{"$f":"J20*J19","v":0},"Total Room:",{"$f":"K20","v":0}]
[null,"Room Tax 1:",null,{"$f":"C21*C19","v":0},"Total Taxes:",{"$f":"D21+D22+D23","v":0},null,null,"Room Tax 1:",null,{"$f":"J21*J19","v":0},"Total Taxes:",{"$f":"K21+K22+K23","v":0}]
[null,"Room Tax 2:",null,{"$f":"C22*C19","v":0},"Total Bill:",{"$f":"F20+F21","v":0},{"$f":"G21-G20","v":0},null,"Room Tax 2:",null,{"$f":"J22*J19","v":0},"Total Bill:",{"$f":"M20+M21","v":0},{"$f":"N21-N20","v":0}]
[null,"Room Tax 3:",null,{"$f":"C23*C19","v":0},null,null,null,null,"Room Tax 3:",null,{"$f":"J23*J19","v":0}]
[null,"Number of nights:",{"$f":"G27","v":0},null,null,null,"Date Calc:",null,"Number of nights:",{"$f":"N27","v":0},null,null,null,"Date Calc:"]
[null,"Hotel Room 3:",null,{"$f":"C25*C24","v":0},"Total Room:",{"$f":"D25","v":0},null,null,"Hotel Room 7:",null,{"$f":"J25*J24","v":0},"Total Room:",{"$f":"K25","v":0}]
[null,"Room Tax 1:",null,{"$f":"C26*C24","v":0},"Total Taxes:",{"$f":"D26+D27+D28","v":0},null,null,"Room Tax 1:",null,{"$f":"J26*J24","v":0},"Total Taxes:",{"$f":"K26+K27+K28","v":0}]
[null,"Room Tax 2:",null,{"$f":"C27*C24","v":0},"Total Bill:",{"$f":"F25+F26","v":0},{"$f":"G26-G25","v":0},null,"Room Tax 2:",null,{"$f":"J27*J24","v":0},"Total Bill:",{"$f":"M25+M26","v":0},{"$f":"N26-N25","v":0}]
[null,"Room Tax 3:",null,{"$f":"C28*C24","v":0},null,null,null,null,"Room Tax 3:",null,{"$f":"J28*J24","v":0}]
[null,"Number of nights:",{"$f":"G32","v":0},null,null,null,"Date Calc:",null,"Number of nights:",{"$f":"N32","v":0},null,null,null,"Date Calc:"]
[null,"Hotel Room 4:",null,{"$f":"C30*C29","v":0},"Total Room:",{"$f":"D30","v":0},null,null,"Hotel Room 8:",null,{"$f":"J30*J29","v":0},"Total Room:",{"$f":"K30","v":0}]
[null,"Room Tax 1:",null,{"$f":"C31*C29","v":0},"Total Taxes:",{"$f":"D31+D32+D33","v":0},null,null,"Room Tax 1:",null,{"$f":"J31*J29","v":0},"Total Taxes:",{"$f":"K31+K32+K33","v":0}]
[null,"Room Tax 2:",null,{"$f":"C32*C29","v":0},"Total Bill:",{"$f":"F30+F31","v":0},{"$f":"G31-G30","v":0},null,"Room Tax 2:",null,{"$f":"J32*J29","v":0},"Total Bill:",{"$f":"M30+M31","v":0},{"$f":"N31-N30","v":0}]
[null,"Room Tax 3:",null,{"$f":"C33*C29","v":0},null,null,null,null,"Room Tax 3:",null,{"$f":"J33*J29","v":0}]
[null,"From Per Diem Page:",null,null,"Total M&IE:",{"$f":"C34","v":0}]
[null,"Mileage to:",null,null,"Total MILEAGE:",{"$f":"C35+C36+C37","v":0}]
[null,"Mileage From:"]
[null,"In and Around:"]
[null,"Hotel Room Taxes:",{"$f":"F16+F21+F26+F31+M16+M21+M26+M31","v":0},null,"OTHER:",{"$f":"C38+C39+C40+C41+C42+C43+C44+C45+C46+C47+C48+J38+J39+J40+J41+J42+J43+J44+J45+J46+J47+J48","v":0},null,null,"Misc 1:",null,null,null,null,"Add em up"]
[null,"Parking Term:",null,null,"Taxi Fare Finder",null,null,null,"Misc 2:"]
[null,"Parking TDY:",null,null,null,null,null,null,"Misc 3:"]
[null,"FCC Fees:",null,null,null,null,null,null,"Misc 4:"]
[null,"Public Trans:",null,null,null,null,null,null,"Misc 5:"]
[null,"Tolls 1:",null,null,null,null,null,null,"Misc 6:"]
[null,"Tolls 2:",null,null,null,null,null,null,"Misc 7:"]
[null,"Taxi 1:",null,null,null,null,null,null,"Misc 8:"]
[null,"Taxi 2:",null,null,null,null,null,null,"Misc 9:"]
[null,"Baggage 1:",null,null,null,null,null,null,"Misc 10:"]
[null,"Baggage 2:",null,null,null,null,{"$f":"SUM(G39:G47)","v":0},null,"Misc 11:",null,null,null,null,{"$f":"SUM(N39:N47)","v":0}]
[null,"Rental Car 1:",null,null,"RENTAL CAR:",{"$f":"C49+C50+C51+J49+J50+J51","v":0},null,null,"Rental Car 4:"]
[null,"Rental Car 2:",null,null,null,null,null,null,"Rental Car 5:"]
[null,"Rental Car 3:",null,null,null,null,null,null,"Rental Car 6:"]
[null,"Gas 1:",null,null,"TRANSPORT:",{"$f":"C52+C53+C54+C55+C56+C57+J52+J53+J54+J55+J56+J57","v":0},null,null,"Gas 7:"]
[null,"Gas 2:",null,null,null,null,null,null,"Gas 8:"]
[null,"Gas 3:",null,null,null,null,null,null,"Gas 9:"]
[null,"Gas 4:",null,null,null,null,null,null,"Gas 10:"]
[null,"Gas 5:",null,null,null,null,null,null,"Gas 11:"]
[null,"Gas 6:",null,null,null,null,null,null,"Gas 12:"]
[]
[null,"ACTUAL TRIP COST",null,null,"COM. CARR.-I:",{"$f":"F5","v":0}]
[null,null,null,null,"LODGING:",{"$f":"F13","v":0}]
[null,null,null,null,"M&IE:",{"$f":"F34","v":0}]
[null,null,null,null,"MILEAGE:",{"$f":"F35","v":0}]
[null,null,null,null,"OTHER:",{"$f":"F38","v":0}]
[null,null,null,null,"RENTAL CAR:",{"$f":"F49","v":0}]
[null,null,null,null,"TRANSPORT:",{"$f":"F52","v":0}]
[null,null,null,null,"TOTAL:",{"$f":"SUM(F59:F65)","v":0}]
[]
[]
[null,null,"Tax Pro-Rater",null,null,"#of Nights:"]
[null,"Charged Rate:",null,"-",null,":Allowable Rate"]
[null,"Tax 1:",null,{"$f":"C71/C70","v":{"$error":"#DIV/0!"}},{"$f":"E70*D71","v":{"$error":"#DIV/0!"}},{"$f":"E71*G69","v":{"$error":"#DIV/0!"}}]
[null,"Tax 2:",null,{"$f":"C72/C70","v":{"$error":"#DIV/0!"}},{"$f":"E70*D72","v":{"$error":"#DIV/0!"}},{"$f":"E72*G69","v":{"$error":"#DIV/0!"}}]
[null,"Tax 3:",null,{"$f":"C73/C70","v":{"$error":"#DIV/0!"}},{"$f":"E70*D73","v":{"$error":"#DIV/0!"}},{"$f":"E73*G69","v":{"$error":"#DIV/0!"}}]
[null,"Tax 4:",null,"Flat",{"$f":"C74","v":0},{"$f":"E74*G69","v":0}]
[null,null,null,null,"Total Allowable Taxes:",{"$f":"F71+F72+F73+F74","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Taxi Tip Pro-Rater",null,null,"Allowed:"]
[null,"Taxi Fare 1:",null,{"$f":"C78*20%","v":0},": Max Tip",{"$f":"C78+D78","v":0}]
[null,"Taxi Fare 2:",null,{"$f":"C79*20%","v":0},": Max Tip",{"$f":"C79+D79","v":0}]
[null,"Taxi Fare 3:",null,{"$f":"C80*20%","v":0},": Max Tip",{"$f":"C80+D80","v":0}]
[null,"Taxi Fare 4:",null,{"$f":"C81*20%","v":0},": Max Tip",{"$f":"C81+D81","v":0}]
[]
[null,"XE Currency Converter",null,null,"OANDA"]
["DO NOT CHANGE ANY YELLOW BOX  -  ONLY MODIFY THE GREEN OR WHITE BOXES"]
[]
["EURO",null,767,857.42,"E Rate:",{"$f":"D86/C86","v":1.1178878748370273}]
[null,null,null,null,null,"# of nights"]
[null,null,null,null,"Per Night",6]
[null,"Room Charge",127.83,{"$f":"C89*F86","v":142.89960704041721}]
[null,"Govt Levy",0,{"$f":"C90*F86","v":0},{"$f":"SUM(D89:D90)","v":142.89960704041721},{"$f":"E90*F88","v":857.39764224250325}]
[null,"Service Charge Fee",0,{"$f":"C91*F86","v":0},null,null,"Total"]
[null,"Service Charge Fee",0,{"$f":"C92*F86","v":0},{"$f":"D91+D92","v":0},{"$f":"E92*F88","v":0},"Stay"]
[null,"Donation Fee",0,{"$f":"C93*F86","v":0},null,null,{"$f":"F90+F92+D93","v":857.39764224250325}]
[null,"Additional Expenses:"]
[null,"Parking weekend",28,{"$f":"C95*$F$86","v":31.300860495436766},null,null,{"$f":"F95*$F$86","v":0}]
[null,"Parking",76,{"$f":"C96*$F$86","v":84.959478487614078},null,0,{"$f":"F96*$F$86","v":0}]
[null,null,null,{"$f":"C97*$F$86","v":0},null,0,{"$f":"F97*$F$86","v":0}]
[null,null,null,{"$f":"C98*$F$86","v":0},null,0,{"$f":"F98*$F$86","v":0}]

{"sheet":"CHANGES","index":2,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Version","Changes"]
[null,"v4.0","Published 1 Oct 2019"]
[null,null,"Added M&IE Line"]
[null,null,"Added Mileage Lines"]
[null,null,"Added totals section"]
[null,"v4.1","Published 28 Oct 2019"]

{"sheet":"VOUCHER","index":3,"n_rows":98,"n_cols":14,"rows_kept":98,"cut":false,"hidden":false,"merged":[[83,0,83,6],[85,0,97,0],[0,2,0,5],[38,4,38,5],[58,1,65,3],[68,2,68,4],[76,2,76,4],[82,1,82,3],[82,4,82,6]]}
[null,null,"Additional Space:"]
[]
[]
[null,"Start Date:",null,"End Date:"]
[null,"AirFare 1:",null,null,"COM. CARR.-I:",{"$f":"C5+C6+C7+C8+C9+C10+C11+C12+J5+J6+J7+J8+J9+J10+J11+J12","v":0},null,null,"AirFare 5:"]
[null,"CTO Fee 1:",null,null,null,null,null,null,"CTO Fee 5:"]
[null,"Airfare 2:",null,null,null,null,null,null,"Airfare 6:"]
[null,"CTO Fee 2:",null,null,null,null,null,null,"CTO Fee 6:"]
[null,"Airfare 3:",null,null,null,null,null,null,"Airfare 7:"]
[null,"CTO Fee 3:",null,null,null,null,null,null,"CTO Fee 7:"]
[null,"Airfare 4:",null,null,null,null,null,null,"Airfare 8:"]
[null,"CTO Fee 4:",null,null,null,null,null,null,"CTO Fee 8:"]
[null,null,null,null,"Total LODGING:",{"$f":"D15+D20+D25+D30+K15+K20+K25+K30","v":0}]
[null,"Number of nights:",null,null,null,null,"Date Calc:",null,"Number of nights:",{"$f":"N17","v":0},null,null,null,"Date Calc:"]
[null,"Hotel Room 1:",null,{"$f":"C14*C15","v":0},"Total Room:",{"$f":"D15","v":0},null,null,"Hotel Room 5:",null,{"$f":"J14*J15","v":0},"Total Room:",{"$f":"K15","v":0}]
[null,"Room Tax 1:",null,{"$f":"C16*C14","v":0},"Total Taxes:",{"$f":"D16+D17+D18","v":0},null,null,"Room Tax 1:",null,{"$f":"J16*J14","v":0},"Total Taxes:",{"$f":"K16+K17+K18","v":0}]
[null,"Room Tax 2:",null,{"$f":"C17*C14","v":0},"Total Bill:",{"$f":"F15+F16","v":0},{"$f":"G16-G15","v":0},null,"Room Tax 2:",null,{"$f":"J17*J14","v":0},"Total Bill:",{"$f":"M15+M16","v":0},{"$f":"N16-N15","v":0}]
[null,"Room Tax 3:",null,{"$f":"C18*C14","v":0},null,null,null,null,"Room Tax 3:",null,{"$f":"J18*J14","v":0}]
[null,"Number of nights:",{"$f":"G22","v":0},null,null,null,"Date Calc:",null,"Number of nights:",{"$f":"N22","v":0},null,null,null,"Date Calc:"]
[null,"Hotel Room 2:",null,{"$f":"C20*C19","v":0},"Total Room:",{"$f":"D20","v":0},null,null,"Hotel Room 6:",null,{"$f":"J20*J19","v":0},"Total Room:",{"$f":"K20","v":0}]
[null,"Room Tax 1:",null,{"$f":"C21*C19","v":0},"Total Taxes:",{"$f":"D21+D22+D23","v":0},null,null,"Room Tax 1:",null,{"$f":"J21*J19","v":0},"Total Taxes:",{"$f":"K21+K22+K23","v":0}]
[null,"Room Tax 2:",null,{"$f":"C22*C19","v":0},"Total Bill:",{"$f":"F20+F21","v":0},{"$f":"G21-G20","v":0},null,"Room Tax 2:",null,{"$f":"J22*J19","v":0},"Total Bill:",{"$f":"M20+M21","v":0},{"$f":"N21-N20","v":0}]
[null,"Room Tax 3:",null,{"$f":"C23*C19","v":0},null,null,null,null,"Room Tax 3:",null,{"$f":"J23*J19","v":0}]
[null,"Number of nights:",{"$f":"G27","v":0},null,null,null,"Date Calc:",null,"Number of nights:",{"$f":"N27","v":0},null,null,null,"Date Calc:"]
[null,"Hotel Room 3:",null,{"$f":"C25*C24","v":0},"Total Room:",{"$f":"D25","v":0},null,null,"Hotel Room 7:",null,{"$f":"J25*J24","v":0},"Total Room:",{"$f":"K25","v":0}]
[null,"Room Tax 1:",null,{"$f":"C26*C24","v":0},"Total Taxes:",{"$f":"D26+D27+D28","v":0},null,null,"Room Tax 1:",null,{"$f":"J26*J24","v":0},"Total Taxes:",{"$f":"K26+K27+K28","v":0}]
[null,"Room Tax 2:",null,{"$f":"C27*C24","v":0},"Total Bill:",{"$f":"F25+F26","v":0},{"$f":"G26-G25","v":0},null,"Room Tax 2:",null,{"$f":"J27*J24","v":0},"Total Bill:",{"$f":"M25+M26","v":0},{"$f":"N26-N25","v":0}]
[null,"Room Tax 3:",null,{"$f":"C28*C24","v":0},null,null,null,null,"Room Tax 3:",null,{"$f":"J28*J24","v":0}]
[null,"Number of nights:",{"$f":"G32","v":0},null,null,null,"Date Calc:",null,"Number of nights:",{"$f":"N32","v":0},null,null,null,"Date Calc:"]
[null,"Hotel Room 4:",null,{"$f":"C30*C29","v":0},"Total Room:",{"$f":"D30","v":0},null,null,"Hotel Room 8:",null,{"$f":"J30*J29","v":0},"Total Room:",{"$f":"K30","v":0}]
[null,"Room Tax 1:",null,{"$f":"C31*C29","v":0},"Total Taxes:",{"$f":"D31+D32+D33","v":0},null,null,"Room Tax 1:",null,{"$f":"J31*J29","v":0},"Total Taxes:",{"$f":"K31+K32+K33","v":0}]
[null,"Room Tax 2:",null,{"$f":"C32*C29","v":0},"Total Bill:",{"$f":"F30+F31","v":0},{"$f":"G31-G30","v":0},null,"Room Tax 2:",null,{"$f":"J32*J29","v":0},"Total Bill:",{"$f":"M30+M31","v":0},{"$f":"N31-N30","v":0}]
[null,"Room Tax 3:",null,{"$f":"C33*C29","v":0},null,null,null,null,"Room Tax 3:",null,{"$f":"J33*J29","v":0}]
[null,"ME&E",null,null,"Total M&IE:",{"$f":"C34","v":0}]
[null,"Mileage to:",null,null,"Total MILEAGE:",{"$f":"C35+C36+C37","v":0}]
[null,"Mileage From:"]
[null,"In and Around:"]
[null,"Hotel Room Taxes:",{"$f":"F16+F21+F26+F31+M16+M21+M26+M31","v":0},null,"OTHER:",{"$f":"C38+C39+C40+C41+C42+C43+C44+C45+C46+C47+C48+J38+J39+J40+J41+J42+J43+J44+J45+J46+J47+J48","v":0},null,null,"Misc 1:",null,null,null,null,"Add em up"]
[null,"Parking Term:",null,null,"Taxi Fare Finder",null,null,null,"Misc 2:"]
[null,"Parking TDY:",null,null,null,null,null,null,"Misc 3:"]
[null,"FCC Fees:",null,null,null,null,null,null,"Misc 4:"]
[null,"Public Trans:",null,null,null,null,null,null,"Misc 5:"]
[null,"Tolls 1:",null,null,null,null,null,null,"Misc 6:"]
[null,"Tolls 2:",null,null,null,null,null,null,"Misc 7:"]
[null,"Taxi 1:",null,null,null,null,null,null,"Misc 8:"]
[null,"Taxi 2:",null,null,null,null,null,null,"Misc 9:"]
[null,"Baggage 1:",null,null,null,null,null,null,"Misc 10:"]
[null,"Baggage 2:",null,null,null,null,{"$f":"SUM(G39:G47)","v":0},null,"Misc 11:",null,null,null,null,{"$f":"SUM(N39:N47)","v":0}]
[null,"Rental Car 1:",null,null,"RENTAL CAR:",{"$f":"C49+C50+C51+J49+J50+J51","v":0},null,null,"Rental Car 4:"]
[null,"Rental Car 2:",null,null,null,null,null,null,"Rental Car 5:"]
[null,"Rental Car 3:",null,null,null,null,null,null,"Rental Car 6:"]
[null,"Gas 1:",null,null,"TRANSPORT:",{"$f":"C52+C53+C54+C55+C56+C57+J52+J53+J54+J55+J56+J57","v":0},null,null,"Gas 7:"]
[null,"Gas 2:",null,null,null,null,null,null,"Gas 8:"]
[null,"Gas 3:",null,null,null,null,null,null,"Gas 9:"]
[null,"Gas 4:",null,null,null,null,null,null,"Gas 10:"]
[null,"Gas 5:",null,null,null,null,null,null,"Gas 11:"]
[null,"Gas 6:",null,null,null,null,null,null,"Gas 12:"]
[]
[null,"ACTUAL TRIP COST",null,null,"COM. CARR.-I:",{"$f":"F5","v":0}]
[null,null,null,null,"LODGING:",{"$f":"F13","v":0}]
[null,null,null,null,"M&IE:",{"$f":"F34","v":0}]
[null,null,null,null,"MILEAGE:",{"$f":"F35","v":0}]
[null,null,null,null,"OTHER:",{"$f":"F38","v":0}]
[null,null,null,null,"RENTAL CAR:",{"$f":"F49","v":0}]
[null,null,null,null,"TRANSPORT:",{"$f":"F52","v":0}]
[null,null,null,null,"TOTAL:",{"$f":"SUM(F59:F65)","v":0}]
[]
[]
[null,null,"Tax Pro-Rater",null,null,"#of Nights:"]
[null,"Charged Rate:",null,"-",null,":Allowable Rate"]
[null,"Tax 1:",null,{"$f":"C71/C70","v":{"$error":"#DIV/0!"}},{"$f":"E70*D71","v":{"$error":"#DIV/0!"}},{"$f":"E71*G69","v":{"$error":"#DIV/0!"}}]
[null,"Tax 2:",null,{"$f":"C72/C70","v":{"$error":"#DIV/0!"}},{"$f":"E70*D72","v":{"$error":"#DIV/0!"}},{"$f":"E72*G69","v":{"$error":"#DIV/0!"}}]
[null,"Tax 3:",null,{"$f":"C73/C70","v":{"$error":"#DIV/0!"}},{"$f":"E70*D73","v":{"$error":"#DIV/0!"}},{"$f":"E73*G69","v":{"$error":"#DIV/0!"}}]
[null,"Tax 4:",null,"Flat",{"$f":"C74","v":0},{"$f":"E74*G69","v":0}]
[null,null,null,null,"Total Allowable Taxes:",{"$f":"F71+F72+F73+F74","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Taxi Tip Pro-Rater",null,null,"Allowed:"]
[null,"Taxi Fare 1:",null,{"$f":"C78*20%","v":0},": Max Tip",{"$f":"C78+D78","v":0}]
[null,"Taxi Fare 2:",null,{"$f":"C79*20%","v":0},": Max Tip",{"$f":"C79+D79","v":0}]
[null,"Taxi Fare 3:",null,{"$f":"C80*20%","v":0},": Max Tip",{"$f":"C80+D80","v":0}]
[null,"Taxi Fare 4:",null,{"$f":"C81*20%","v":0},": Max Tip",{"$f":"C81+D81","v":0}]
[]
[null,"XE Currency Converter",null,null,"OANDA"]
["DO NOT CHANGE ANY YELLOW BOX  -  ONLY MODIFY THE GREEN OR WHITE BOXES"]
[]
["EURO",null,222,444,"E Rate:",{"$f":"D86/C86","v":2}]
[null,null,null,null,null,"# of nights"]
[null,null,null,null,"Per Night",6]
[null,"Room Charge",127.83,{"$f":"C89*F86","v":255.66}]
[null,"Govt Levy",0,{"$f":"C90*F86","v":0},{"$f":"SUM(D89:D90)","v":255.66},{"$f":"E90*F88","v":1533.96}]
[null,"Service Charge Fee",0,{"$f":"C91*F86","v":0},null,null,"Total"]
[null,"Service Charge Fee",0,{"$f":"C92*F86","v":0},{"$f":"D91+D92","v":0},{"$f":"E92*F88","v":0},"Stay"]
[null,"Donation Fee",0,{"$f":"C93*F86","v":0},null,null,{"$f":"F90+F92+D93","v":1533.96}]
[null,"Additional Expenses:"]
[null,"Parking weekend",28,{"$f":"C95*$F$86","v":56},null,null,{"$f":"F95*$F$86","v":0}]
[null,"Parking",76,{"$f":"C96*$F$86","v":152},null,0,{"$f":"F96*$F$86","v":0}]
[null,null,null,{"$f":"C97*$F$86","v":0},null,0,{"$f":"F97*$F$86","v":0}]
[null,null,null,{"$f":"C98*$F$86","v":0},null,0,{"$f":"F98*$F$86","v":0}]