{"text_format":"3","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":{"images":3,"macros":1,"defined_names":224,"comments":30},"unopened":[{"sheet":"AutoOpen Stub Data","index":0,"reason":"not_a_worksheet"},{"sheet":"Macros","index":3,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900","formulas":"cached_only"}

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

{"sheet":"Expense Statement","index":2,"n_rows":46,"n_cols":14,"rows_kept":46,"flags":["formulas_cached_only"]}
[]
[]
[]
[{"$nulls":12},"Statement No.  ",""]
{"$rows_empty":8}
[{"$nulls":3},"Name","",null,"Emp #  ","",{"$nulls":4},"From  ",""]
[{"$nulls":3},"SSN",null,null,"Position  "]
[{"$nulls":3},"Department",null,null,"Manager  ",{"$nulls":5},"To  ",""]
[]
[{"$nulls":3},"Date","Account","Description","Accom","Transport","Fuel","Meals","Phone","Entertain","Other","TOTAL"]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":6},"","","","","","",""]
[{"$nulls":12},"Sub Total  ",""]
[{"$nulls":12},"Subtract Advances  "]
[{"$nulls":9},"Reimbursement",null,null,"TOTAL  ",""]
[{"$nulls":10},1]
[{"$nulls":5},"    Current mileage reimbursement rate is $.21",{"$nulls":3},"Payment Needed"]
[]
[]
[]
[]
[]
[{"$nulls":3},"Office Use Only"]

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

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

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

{"sheet":"Intl Data Table","index":7,"n_rows":8,"n_cols":28,"rows_kept":8,"hidden":true,"flags":["formulas_cached_only"]}
[]
[{"$nulls":3},"US","UK","Canada","Australia","New Zealand","Ireland","Arabic Countries","Austria","China","Denmark","France","Germany","Israel","Italy","Japan","Korea","Luxembourg","Netherlands","Norway","South Africa","Spain","Sweden","Switzerland","Taiwan","Venezuela"]
["Sheet Name","Cell Address","Action Code",-999,44,2,61,64,353,785,43,86,45,33,49,972,39,81,82,352,31,47,27,34,46,41,886,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)","#,##0.00_);(#,##0.00)","kr #.##0,00_);(\"kr \"#.##0,00)","#.##0,00 \"F\"_);(#.##0,00 \"F\")","#.##0,00 \"DM\"_);(#.##0,00 \"DM\")","#,##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)","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)","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)","#,##0.00_);(#,##0.00)","kr #.##0,00_);(\"kr \"#.##0,00)","#.##0,00 \"F\"_);(#.##0,00 \"F\")","#.##0,00 \"DM\"_);(#.##0,00 \"DM\")","#,##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)","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)","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)","#,##0.00_);(#,##0.00)","kr #.##0,00_);(\"kr \"#.##0,00)","#.##0,00 \"F\"_);(#.##0,00 \"F\")","#.##0,00 \"DM\"_);(#.##0,00 \"DM\")","#,##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)","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)","Bs #.##0,00_);(\"Bs \"#.##0,00)"]
["Expense Statement","F40",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 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 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 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,\"Bs.00\"),\"\")"]
["Expense Statement","A1",4,1,9,1,9,9,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,"hidden":true,"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,"","","",{"v":0,"d":"$0.00"},""]
["Reserved"]