{"text_format":"3","workbook":"xls","n_sheets":8,"sheets":["AutoOpen Stub Data","Customize Your Purchase Order","Purchase Order","Macros","ATW","Lock","Intl Data Table","TemplateInformation"],"not_rendered":{"images":2,"macros":1,"defined_names":149,"comments":25},"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 Purchase Order","index":1,"n_rows":53,"n_cols":8,"rows_kept":53,"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 Purchase Order Information Here..."]
[]
[{"$nulls":4},false,"  Click here if company information is same as \"Ship To\" information"]
[]
[{"$nulls":4},"1st Tax Name  ","State","Credit Cards  ","Credit Card #1"]
[{"$nulls":4},"Rate  ",{"v":0.05,"d":"5.00%"},null,"Credit Card #2"]
[{"$nulls":4},true,"Apply tax on local purchases only.",null,"Credit Card #3"]
[]
[{"$nulls":4},"2nd Tax Name  "]
[{"$nulls":4},"Rate  "]
[{"$nulls":4},false,"Apply tax on local purchases only."]
[]
[{"$nulls":4},false,"Share PO numbers on network.","Network Location  "]
[]
[{"$nulls":5},"Template Wizard Database  ","podb.xls"]
[]
[]
[{"$nulls":3},"Formatted Information"]
{"$rows_empty":12}
[{"$nulls":5},1]
[{"$nulls":5},0]
[{"$nulls":5},true]
[]
[{"$nulls":5},"Purchase Order"]

{"sheet":"Purchase Order","index":2,"n_rows":55,"n_cols":17,"rows_kept":55,"flags":["formulas_cached_only"]}
[]
[]
[]
[{"$nulls":15},"Purchase Order No.",""]
{"$rows_empty":7}
[{"$nulls":3},"Name","",{"$nulls":6},"Name"]
[{"$nulls":3},"Address",{"$nulls":7},"Address"]
[{"$nulls":3},"City",null,null,"St",null,"ZIP",null,null,"City",null,"St",null,"ZIP"]
[{"$nulls":3},"Phone",{"$nulls":7},"Phone"]
[]
[{"$nulls":3},"Qty","Units","Description",{"$nulls":7},"Unit Price",null,null,"TOTAL"]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":15},"SubTotal    ",""]
[{"$nulls":15},"Shipping & Handling    "]
[{"$nulls":5},"Check"]
[{"$nulls":5},"Cash",{"$nulls":6},"Taxes  ","State",null,null,""]
[{"$nulls":4},4,"Account",null,"No.",{"$nulls":5},"",null,null,""]
[{"$nulls":4},1,"Credit Card",{"$nulls":6}," ",null,null,"TOTAL    ",""]
[{"$nulls":4},"Name",{"$nulls":7}," "]
[{"$nulls":4},"CC #"]
[{"$nulls":8},"Exp Date"]
{"$rows_empty":8}
[{"$nulls":12},"Date"]
[{"$nulls":12},"Order No"]
[{"$nulls":12},"Sales Rep"]
[{"$nulls":12},"Ship Via"]

{"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":"Intl Data Table","index":6,"n_rows":10,"n_cols":28,"rows_kept":10,"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 Purchase Order","F23",1,"State","VAT","GST","WST","GST","VAT",null,"MwSt.","VAT","Moms","TVA","MwSt.","VAT","IVA","VAT","VAT","MwSt.","BTW","Mva.","VAT","I.V.A.","Moms","MwSt.","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.17,0.25,0.186,0.15,0.17,0.19,0.03,0.1,0.15,0.175,0.23,0.14,0.28,0.25,0.065,0.05,0.12]
["Customize Your Purchase Order","F27",1,null,null,"PST",{"$nulls":4},"MwSt.",null,null,"TVA","MwSt.",null,"IVA",null,null,"MwSt.","BTW",null,null,"I.V.A.",null,"MwSt."]
["Customize Your Purchase Order","F28",1,null,null,0.07,{"$nulls":4},0.1,null,null,0.055,0.07,null,0.16,null,null,0.06,0.06,null,null,0.16,null,0.02]
["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)","#,##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)"]
["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)","#,##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)"]
["Purchase Order","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":7,"n_rows":9,"n_cols":10,"rows_kept":9,"hidden":true,"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]
["Field Name:","PO Number","PO Date","Vendor Name","Vendor Address","Vendor City","Vendor State","Vendor Zip","Vendor Phone","Total PO"]
["Refers To:","","00:00:00","",0,0,0,0,0,""]
["Reserved"]