{"text_format":"1","workbook":"xls","n_sheets":9,"sheets":["AutoOpen Stub Data","Customize Your Statement","Expense Statement","Macros","ATW","Lock","Select Employee","Intl Data Table","TemplateInformation"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":2,"defined_names":229,"comments":22,"pivot_tables":0},"unopened":[{"sheet":"AutoOpen Stub Data","index":0,"reason":"not_a_worksheet"},{"sheet":"Macros","index":3,"reason":"not_a_worksheet"}],"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","formulas":"cached_only"}

{"sheet":"Customize Your Statement","index":1,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[[31,3,31,5],[9,3,9,5],[18,3,18,5],[3,3,3,6],[28,6,28,7]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,null,null,"CUSTOMIZE YOUR EXPENSE STATEMENT"]
[]
[]
[null,null,null,null,null,null,null,"Hover your Pointer"]
[null,null,null,null,null,null,null," HERE for a Useful Tip!"]
[]
[null,null,null,"Type Company Information Here..."]
[]
[null,null,null,null,"Company Name  ","COMPANY NAME","Phone Number  ","Phone Number"]
[null,null,null,null,"Address  ","Company Address","Fax Number  ","Fax Number"]
[null,null,null,null,"City  ","City"]
[null,null,null,null,"State  ","State"]
[null,null,null,null,"ZIP Code  ","ZIP Code"]
[]
[]
[null,null,null,"Specify Default Expense Statement Information Here..."]
[]
[null,null,null,null,"Travel Reimbursement  ",0.21,false,"Expenses categorized as 'Entertain'"]
[null,null,null,null,"(per mile/km)  ",null,null,"or 'Other' are non-reimbursable."]
[]
[null,null,null,null,false,"Share expense statement numbers","Counter Location  "]
[null,null,null,null,null,"on network."]
[]
[null,null,null,null,true,"Enable Select Employee function.","Common Database  "]
[]
[null,null,null,null,null,"Template Wizard Database  ","expdb.xls"]
[]
[]
[null,null,null,"Formatted Information"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,1]
[null,null,null,null,null,0]
[null,null,null,null,null,true]
[]
[null,null,null,null,null,"Expense Statement"]

{"sheet":"Expense Statement","index":2,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,8,46,13],[45,3,46,7],[37,3,40,4],[38,5,40,7],[12,4,12,5],[13,4,13,5],[14,4,14,5],[37,5,37,7],[12,7,12,9],[13,7,13,9],[14,7,14,9]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Statement No.  ",""]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Name","",null,"Emp #  ","",null,null,null,null,"From  ",""]
[null,null,null,"SSN",null,null,"Position  "]
[null,null,null,"Department",null,null,"Manager  ",null,null,null,null,null,"To  ",""]
[]
[null,null,null,"Date","Account","Description","Accom","Transport","Fuel","Meals","Phone","Entertain","Other","TOTAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sub Total  ",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"Subtract Advances  "]
[null,null,null,null,null,"    Current mileage reimbursement rate is $.21",null,null,null,"Reimbursement",null,null,"TOTAL  ",""]
[null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,"Payment Needed"]
[]
[]
[]
[]
[]
[null,null,null,"Office Use Only",null,null,null,null,"Insert Fine Print Here"]

{"sheet":"ATW","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Lock","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Select Employee","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Intl Data Table","index":7,"n_rows":8,"n_cols":33,"rows_kept":8,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,null,null,"US","UK","Canada","Australia","New Zealand","Ireland","Arabic Countries","Austria","Belgium","Brazil","China","Denmark","France","Germany","Hungary","Israel","Italy","Japan","Korea","Luxembourg","Netherlands","Norway","Portugal","South Africa","Spain","Sweden","Switzerland","Taiwan","Turkey","Venezuela"]
["Sheet Name","Cell Address","Action Code",-999,44,2,61,64,353,785,43,32,55,86,45,33,49,36,972,39,81,82,352,31,47,351,27,34,46,41,886,90,58]
["Customize Your Statement","F21",2,"$#,##0.00_);(\"$\"#,##0.00)","£#,##0.00_);(\"£\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","IR£#,##0.00_);(\"IR£\"#,##0.00)","#,##0.00_);(#,##0.00)","ÖS #.##0,00_);(\"ÖS \"#.##0,00)","BF #.##0,00_);(\"BF \"#.##0,00)","R$ #.##0,00_);(\"R$ \"#.##0,00)","#,##0.00_);(#,##0.00)","kr #.##0,00_);(\"kr \"#.##0,00)","#.##0,00 \"F\"_);(#.##0,00 \"F\")","#.##0,00 \"DM\"_);(#.##0,00 \"DM\")","#.##0,00 \"Ft\"_);(#.##0,00 \"Ft\")","#,##0.00_D_M_);(#,##0.00_D_M)","L. #.##0,00_);(\"L. \"#.##0,00)","¥#,##0.00_);(\"¥\"#,##0.00)","#,##0.00_D_M_);(#,##0.00_D_M)","#.##0,00 \"F\"_);(#.##0,00 \"F\")","F #.##0,00_);(\"F \"#.##0,00)","kr # ##0,00_);(\"kr \"# ##0,00)","#.##0,00 \"PTE\"_);(#.##0,00 \"PTE\")","R #,##0.00_);(\"R \"#,##0.00)","#.##0,00 \"Pts\"_);(#.##0,00 \"Pts\")","# ##0,00 \"kr\"_);(# ##0,00 \"kr\")","SFr. #'##0.00_);(\"SFr. \"#'##0.00)","#,##0.00_D_M_);(#,##0.00_D_M)","#.##0,00 \"TL\"_);(#.##0,00 \"TL\")","Bs #.##0,00_);(\"Bs \"#.##0,00)"]
["Expense Statement","G18:N35",2,"$#,##0.00_);(\"$\"#,##0.00)","£#,##0.00_);(\"£\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","IR£#,##0.00_);(\"IR£\"#,##0.00)","#,##0.00_);(#,##0.00)","ÖS #.##0,00_);(\"ÖS \"#.##0,00)","BF #.##0,00_);(\"BF \"#.##0,00)","R$ #.##0,00_);(\"R$ \"#.##0,00)","#,##0.00_);(#,##0.00)","kr #.##0,00_);(\"kr \"#.##0,00)","#.##0,00 \"F\"_);(#.##0,00 \"F\")","#.##0,00 \"DM\"_);(#.##0,00 \"DM\")","#.##0,00 \"Ft\"_);(#.##0,00 \"Ft\")","#,##0.00_D_M_);(#,##0.00_D_M)","L. #.##0,00_);(\"L. \"#.##0,00)","¥#,##0.00_);(\"¥\"#,##0.00)","#,##0.00_D_M_);(#,##0.00_D_M)","#.##0,00 \"F\"_);(#.##0,00 \"F\")","F #.##0,00_);(\"F \"#.##0,00)","kr # ##0,00_);(\"kr \"# ##0,00)","#.##0,00 \"PTE\"_);(#.##0,00 \"PTE\")","R #,##0.00_);(\"R \"#,##0.00)","#.##0,00 \"Pts\"_);(#.##0,00 \"Pts\")","# ##0,00 \"kr\"_);(# ##0,00 \"kr\")","SFr. #'##0.00_);(\"SFr. \"#'##0.00)","#,##0.00_D_M_);(#,##0.00_D_M)","#.##0,00 \"TL\"_);(#.##0,00 \"TL\")","Bs #.##0,00_);(\"Bs \"#.##0,00)"]
["Expense Statement","N36:N38",2,"$#,##0.00_);(\"$\"#,##0.00)","£#,##0.00_);(\"£\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","IR£#,##0.00_);(\"IR£\"#,##0.00)","#,##0.00_);(#,##0.00)","ÖS #.##0,00_);(\"ÖS \"#.##0,00)","BF #.##0,00_);(\"BF \"#.##0,00)","R$ #.##0,00_);(\"R$ \"#.##0,00)","#,##0.00_);(#,##0.00)","kr #.##0,00_);(\"kr \"#.##0,00)","#.##0,00 \"F\"_);(#.##0,00 \"F\")","#.##0,00 \"DM\"_);(#.##0,00 \"DM\")","#.##0,00 \"Ft\"_);(#.##0,00 \"Ft\")","#,##0.00_D_M_);(#,##0.00_D_M)","L. #.##0,00_);(\"L. \"#.##0,00)","¥#,##0.00_);(\"¥\"#,##0.00)","#,##0.00_D_M_);(#,##0.00_D_M)","#.##0,00 \"F\"_);(#.##0,00 \"F\")","F #.##0,00_);(\"F \"#.##0,00)","kr # ##0,00_);(\"kr \"# ##0,00)","#.##0,00 \"PTE\"_);(#.##0,00 \"PTE\")","R #,##0.00_);(\"R \"#,##0.00)","#.##0,00 \"Pts\"_);(#.##0,00 \"Pts\")","# ##0,00 \"kr\"_);(# ##0,00 \"kr\")","SFr. #'##0.00_);(\"SFr. \"#'##0.00)","#,##0.00_D_M_);(#,##0.00_D_M)","#.##0,00 \"TL\"_);(#.##0,00 \"TL\")","Bs #.##0,00_);(\"Bs \"#.##0,00)"]
["Expense Statement","F38",3,"IF(dflt1<>\"\",\"    Current mileage reimbursement rate is \"&TEXT(dflt1,\"$.00\"),\"\")","IF(dflt1<>\"\",\"    Current mileage reimbursement rate is \"&TEXT(dflt1,\"£.00\"),\"\")","IF(dflt1<>\"\",\"    Current kilometer reimbursement rate is \"&TEXT(dflt1,\"$.00\"),\"\")","IF(dflt1<>\"\",\"    Current mileage reimbursement rate is \"&TEXT(dflt1,\"$.00\"),\"\")","IF(dflt1<>\"\",\"    Current mileage reimbursement rate is \"&TEXT(dflt1,\"$.00\"),\"\")","IF(dflt1<>\"\",\"    Current mileage reimbursement rate is \"&TEXT(dflt1,\"IR£.00\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"$.00\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"ÖS,00\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"BF,00\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"R,00\"),\"\")","IF(dflt1<>\"\",\"    Current mileage reimbursement rate is \"&TEXT(dflt1,\"#.00\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"kr,00\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"#,00 F\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"#,00 DM\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"#,00 Ft\"),\"\")","IF(dflt1<>\"\",\"    Current mileage reimbursement rate is \"&TEXT(dflt1,\"#.00\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"L. ###\"),\"\")","IF(dflt1<>\"\",\"    Current mileage reimbursement rate is \"&TEXT(dflt1,\"¥.00\"),\"\")","IF(dflt1<>\"\",\"    Current mileage reimbursement rate is \"&TEXT(dflt1,\"#.00\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"#,00 F\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"F,00\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"kr,00\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"#,00 PTE\"),\"\")","IF(dflt1<>\"\",\"    Current mileage reimbursement rate is \"&TEXT(dflt1,\"R.00\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"#,00 Pts\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"#,00 kr\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"SFr. .00\"),\"\")","IF(dflt1<>\"\",\"    Current mileage reimbursement rate is \"&TEXT(dflt1,\"#.00\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"#,00 TL\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"Bs.00\"),\"\")"]
["Expense Statement","A1",4,1,9,1,9,9,9,9,9,9,1,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9]

{"sheet":"TemplateInformation","index":8,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
["AutoTemplateWizardDONTMESSWITHIT"]
["Database Type:","Excel 5.0"]
["Database Location:","Expdb.xls"]
["Reserved"]
["Number of Tables:",1]
[1,"Table Name:","Table1","Number of Fields:",12]
["Field Name:","Statement Number","Employee Name","Employee Number","SSN","Position","Department","Manager","Start Date","End Date","Total Expenses","Advances","Payment / Reimbursement"]
["Refers To:","","","",0,0,0,0,"","","",0,""]
["Reserved"]