{"text_format":"1","workbook":"xls","n_sheets":8,"sheets":["AutoOpen Stub Data","Customize Your Purchase Order","Purchase Order","Macros","ATW","Lock","Intl Data Table","TemplateInformation"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":205,"comments":14,"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 Purchase Order","index":1,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":false,"merged":[[3,3,3,6],[9,3,9,5],[18,3,18,5],[35,3,35,5],[32,6,32,7]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,null,null,"CUSTOMIZE YOUR PURCHASE ORDER"]
[]
[]
[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 Purchase Order Information Here..."]
[]
[null,null,null,null,false,"  Click here if company information is same as \"Ship To\" information"]
[]
[null,null,null,null,"1st Tax Name  ","State","Credit Cards  ","Credit Card #1"]
[null,null,null,null,"Rate  ",0.05,null,"Credit Card #2"]
[null,null,null,null,true,"Apply tax on local purchases only.",null,"Credit Card #3"]
[]
[null,null,null,null,"2nd Tax Name  "]
[null,null,null,null,"Rate  "]
[null,null,null,null,false,"Apply tax on local purchases only."]
[]
[null,null,null,null,false,"Share PO numbers on network.","Network Location  "]
[]
[null,null,null,null,null,"Template Wizard Database  ","podb.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,"Purchase Order"]

{"sheet":"Purchase Order","index":2,"n_rows":55,"n_cols":17,"rows_kept":55,"cut":false,"hidden":false,"merged":[[11,4,11,9],[12,4,12,9],[13,4,13,5],[14,4,14,9],[45,4,45,10],[51,4,54,9],[57,4,59,15],[16,5,16,12],[17,5,17,12],[18,5,18,12],[19,5,19,12],[20,5,20,12],[21,5,21,12],[22,5,22,12],[23,5,23,12],[24,5,24,12],[25,5,25,12],[26,5,26,12],[27,5,27,12],[28,5,28,12],[29,5,29,12],[30,5,30,12],[31,5,31,12],[32,5,32,12],[33,5,33,12],[40,6,40,10],[41,6,41,10],[38,8,38,11],[42,9,42,10],[11,12,11,16],[12,12,12,16],[14,12,14,16],[16,13,16,15],[17,13,17,15],[18,13,18,15],[19,13,19,15],[20,13,20,15],[21,13,21,15],[22,13,22,15],[23,13,23,15],[24,13,24,15],[25,13,25,15],[26,13,26,15],[27,13,27,15],[28,13,28,15],[29,13,29,15],[30,13,30,15],[31,13,31,15],[32,13,32,15],[33,13,33,15],[37,13,37,15],[38,13,38,15],[51,13,51,15],[52,13,52,15],[53,13,53,15],[54,13,54,15]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Order No.",""]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Name","",null,null,null,null,null,null,"Name"]
[null,null,null,"Address",null,null,null,null,null,null,null,"Address"]
[null,null,null,"City",null,null,"St",null,"ZIP",null,null,"City",null,"St",null,"ZIP"]
[null,null,null,"Phone",null,null,null,null,null,null,null,"Phone"]
[]
[null,null,null,"Qty","Units","Description",null,null,null,null,null,null,null,"Unit Price",null,null,"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,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,"SubTotal    ",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shipping & Handling    "]
[null,null,null,null,null,"Check"]
[null,null,null,null,null,"Cash",null,null,null,null,null,null,"Taxes  ","State",null,null,""]
[null,null,null,null,4,"Account",null,"No.",null,null,null,null,null,"",null,null,""]
[null,null,null,null,1,"Credit Card",null,null,null,null,null,null,null,null,null,"TOTAL    ",""]
[null,null,null,null,"Name"]
[null,null,null,null,"CC #"]
[null,null,null,null,null,null,null,null,"Exp Date"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Date","1996-10-02T10:28:19"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Order No"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sales Rep"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ship Via"]

{"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":"Intl Data Table","index":6,"n_rows":10,"n_cols":33,"rows_kept":10,"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 Purchase Order","F23",1,"State","VAT","GST","WST","GST","VAT",null,"MwSt.","BTW","ICMS","VAT","Moms","T.V.A.","MwSt.","ÁFA","VAT","IVA","VAT","VAT","MwSt.","BTW","Mva.","IVA","VAT","I.V.A.","Moms","MwSt.","VAT","VAT","I.G."]
["Customize Your Purchase Order","F24",1,0.05,0.175,0.07,0.22,0.125,0.21,null,0.2,0.21,0.18,0.17,0.25,0.186,0.15,0.25,0.17,0.19,0.03,0.1,0.15,0.175,0.23,0.17,0.14,0.28,0.25,0.065,0.05,0.08,0.12]
["Customize Your Purchase Order","F27",1,null,null,"PST",null,null,null,null,"MwSt.","BTW","IPI",null,null,"T.V.A.","MwSt.","ÁFA",null,"IVA",null,null,"MwSt.","BTW",null,null,null,"I.V.A.","Moms","MwSt.",null,"VAT"]
["Customize Your Purchase Order","F28",1,null,null,0.07,null,null,null,null,0.1,0.06,0.15,null,null,0.055,0.07,0.12,null,0.16,null,null,0.06,0.06,null,null,null,0.16,0.21,0.02,null,0.15]
["Purchase Order","N18:N34",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\")","fl #.##0,00_);(\"fl \"#.##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)","NT$#,##0.00;(NT$#,##0.00)","#.##0,00 \"TL\"_);(#.##0,00 \"TL\")","Bs #.##0,00_);(\"Bs \"#.##0,00)"]
["Purchase Order","Q18:Q40",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\")","fl #.##0,00_);(\"fl \"#.##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)","NT$#,##0.00;(NT$#,##0.00)","#.##0,00 \"TL\"_);(#.##0,00 \"TL\")","Bs #.##0,00_);(\"Bs \"#.##0,00)"]
["Purchase Order","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":7,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
["AutoTemplateWizardDONTMESSWITHIT"]
["Database Type:","Excel 5.0"]
["Database Location:","Podb.xls"]
["Reserved"]
["Number of Tables:",1]
[1,"Table Name:","Table1","Number of Fields:",9,null,0]
["Field Name:","PO Number","PO Date","Vendor Name","Vendor Address","Vendor City","Vendor State","Vendor Zip","Vendor Phone","Total PO"]
["Refers To:","","1996-10-02T10:28:19","",0,0,0,0,0,""]
["Reserved"]