{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Authorization","automation","development-notes"],"not_rendered":{"macros":1,"external_links":2,"defined_names":36},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Authorization","index":0,"n_rows":34,"n_cols":13,"rows_kept":34,"merged":[[25,2,25,5],[30,3,30,5],[33,3,33,5]],"flags":["formulas_cached_only"]}
[]
[null,"YUBA COUNTY SCHOOLS - BUSINESS SERVICES"]
[null,"Vendor Claim Request Transmittal"]
[]
[null,null,"TO:","Fiscal Tech (fiscal.tech@yubacoe.k12.ca.us)"]
[]
[null,null,"Organization: ",null,"Date:",{"$nulls":6},"BBD437","  <=Add this text to your file name for uniqueness (only once for each new file)"]
[null,null,""]
[]
[]
[null,null,"Batch","Submit Date",null,"Warrant\nTotal"]
{"$rows_empty":11}
[{"$nulls":4},"Grand Total: ",{"v":0,"d":"0.00"}]
[]
[]
[null,null,"It is hereby certified that the invoices and orders being paid are proper charges against the above school district and fund; that all goods and services have been received in the quantities as being paid; and that no prior claims have been presented for any portion thereof.  You are hereby authorized to prepare warrants not to exceed the total net sum of:  $0.00"]
[]
[null,null,"Authorized By: "]
[null,null,"Title: "]
[]
[null,null,"Comments: "]
[]
[]
[null,null,"Notes: ","Warrants are usually dated Friday of the payment processing week.  \nThis Vendor Claim Request must be received by YCOE Business Services NLT 3:00 PM on the scheduled date unless otherwise approved or scheduled."]

{"sheet":"automation","index":1,"n_rows":79,"n_cols":15,"rows_kept":79,"hidden":true,"flags":["formulas_cached_only"]}
[]
["\"  \"","\" \"",{"$nulls":3},"Named Regions","Sheet & Address","Purpose",null,"UseTaxFlag Values"]
[10,"Yuba County Office of Education",{"$nulls":3},"AccessCode","=Authorization!$F$26"]
[20,"Plumas",{"$nulls":3},"Authorizer","=Authorization!$C$26",null,null," "]
[30,"Wheatland Union High School",{"$nulls":3},"AuthorizerTitle","=Authorization!$C$27",null,null,"X"]
[40,"Camptonville Union",{"$nulls":3},"BatchTotal","=Authorization!$D$12:$D$19"]
[50,"Camptonville Academy",{"$nulls":3},"bid","=Authorization!$B$12:$B$19"]
["CMP","California Montessori Project",{"$nulls":3},"CertifyStatement","=Authorization!$B$24"]
["WSD","Wheatland Elementary",{"$nulls":3},"cGrandTotal","=Authorization!$D$21"]
[{"$nulls":5},"cUseTaxTotal","=Authorization!$E$21"]
[{"$nulls":5},"cWarrantGrandTotal","=Authorization!$F$21",null,"UniquenessGenerator",null,"Generates a random PLUS time based key to add to file name for uniqueness"]
[{"$nulls":5},"DistributeDate","=Authorization!$C$12:$C$19"]
[{"$nulls":5},"fFormDate","=Authorization!$F$7",null,68,"D"]
[{"$nulls":5},"LedgerCode","=Authorization!$C$7",null,65,"A",66,"B"]
[{"$nulls":5},"LedgerList","=automation!$A$2:$B$9",null,65,"A"]
[{"$nulls":5},"LineTotal","=Authorization!$D$12:$D$19",null,67,"C",66,"B"]
[{"$nulls":5},"UseTaxAmounts","=Authorization!$E$12:$E$19",null,68,"D"]
[{"$nulls":5},"UseTaxFlag","=Authorization!$E$12:$E$19",null,68,"D",68,"D"]
[{"$nulls":5},"WarrantTotal","=Authorization!$F$12:$F$19",null,69,"E"]
[]
[]
[{"$nulls":8},"2014-08-04T15:10:21.900",2014,20140,28180]
[null,"Form Access Code",{"$nulls":3},"Form Timestamp",{"$nulls":3},8,8000]
[null,"",{"$nulls":3},"2009-03-18T03:14:00",{"$nulls":3},4,40]
[{"$nulls":9},15,15000,16220]
[null,"Form Approver Name",{"$nulls":3},"Ledger Stub",{"$nulls":3},10,1000]
[null,"",{"$nulls":7},22,220]
[{"$nulls":11},44400,173.4375]
[null,"Proposed File Name",{"$nulls":3},"File Name Stub (1)"]
[null,"AP-Authorization--20090318-82AE0B55",{"$nulls":4},"NOP",{"$nulls":5},173,null,"437"]
[]
[null,"Ledger Code",{"$nulls":3},"File Name Stub (2)",null,null,"Unique Key: ","BBD437"]
[{"$nulls":6},"NOP"]
[]
[null,"Form Email Target Account",{"$nulls":3},"File Save Status"]
[null,"fiscal.tech@yubacoe.k12.ca.us"]
[]
[null,"Form Emailed - TimeStamp"]
[null,"2009-03-18T15:00:28","NOP",{"$nulls":5},"AccessCode","=Authorization!$F$26"]
[{"$nulls":8},"Authorizer","=Authorization!$C$26"]
[{"$nulls":8},"AuthorizerTitle","=Authorization!$C$27"]
[null,"fiscal.tech@yubacoe.k12.ca.us",{"$nulls":6},"BatchTotal","=Authorization!$D$12:$D$19"]
[null,"mike.waldorff@yubacoe.k12.ca.us",{"$nulls":6},"bid","=Authorization!$B$12:$B$19"]
[{"$nulls":8},"CertifyStatement","=Authorization!$B$24"]
[{"$nulls":8},"cGrandTotal","=Authorization!$D$21"]
[{"$nulls":8},"cUseTaxTotal","=Authorization!$E$21"]
[{"$nulls":8},"cWarrantGrandTotal","=Authorization!$F$21"]
[{"$nulls":8},"DistributeDate","=Authorization!$C$12:$C$19"]
[{"$nulls":8},"fFormDate","=Authorization!$F$7"]
[{"$nulls":8},"LedgerCode","=Authorization!$C$7"]
[{"$nulls":8},"LedgerList","=automation!$A$2:$B$11"]
[{"$nulls":8},"LineTotal","=Authorization!$D$12:$D$19"]
[{"$nulls":8},"pEmailTarget","=automation!$B$36"]
[{"$nulls":8},"pEmailTimeStamp","=automation!$B$39"]
[{"$nulls":8},"pFileNameStub1","=automation!$F$30"]
[{"$nulls":8},"pFileNameStub2","=automation!$F$33"]
[{"$nulls":8},"pFileSaveStatus","=automation!$F$36"]
[{"$nulls":8},"pFormAccessCode","=automation!$B$24"]
[null,"APPROVAL CERTIFICATION STATEMENT",{"$nulls":6},"pFormApproverName","=automation!$B$27"]
[null,"It is hereby certified that the invoices and orders being paid are proper charges against the above school district and fund; that all goods and services have been received in the quantities as being paid; and that no prior claims have been presented for any portion thereof.  You are hereby authorized to prepare warrants not to exceed the total net sum of:  $0.00",{"$nulls":6},"pFormTimeStamp","=automation!$F$24"]
[null,0,{"$nulls":6},"pLedgerCode","=automation!$B$33"]
[null,"It is hereby certified that the invoices and orders being paid are proper charges against the above school district and fund; that all goods and services have been received in the quantities as being paid; and that no prior claims have been presented for any portion thereof.  You are hereby authorized to prepare warrants not to exceed the total net sum of:  ",{"$nulls":6},"pLedgerStub","=automation!$F$27"]
[{"$nulls":8},"pProposedFIleName","=automation!$B$30"]
[{"$nulls":8},"UseTaxAmounts","=Authorization!$E$12:$E$19"]
[{"$nulls":8},"UseTaxFlag","=Authorization!$E$12:$E$19"]
[{"$nulls":8},"WarrantTotal","=Authorization!$F$12:$F$19"]
[]
[null,"It is hereby certified that the invoices and orders being paid are proper charges against the above school district and fund; that all goods and services have been received in the quantities as being paid; and that no prior claims have been presented for any portion thereof.  You are hereby authorized to prepare warrants not to exceed the total net sum of:  $22.00"]
[]
[1,"GENERAL"]
[2,"The AP Authorization Form - Control Panel is used to manage information placed on the main form, \ninitiate a file save operation that presets file names to standardized structure,\nand also to initiate emailing of the form."]
[3,"FORM ACTIVATION"]
[4,"Enter a name for the Approver of this form, and a Access Code that will be used to verify the Approver.  \nThese values must be entered every time the form is opened."]
[5,"AUTHORIZATION FORM MANAGEMENT"]
[6,"more here"]
[7,"CONTROL PANEL MANAGEMENT"]
[8,"and more here"]
[9,"etcetera"]
[10,"etcetera"]

{"sheet":"development-notes","index":2,"n_rows":41,"n_cols":3,"rows_kept":41,"hidden":true,"flags":["formulas_cached_only"]}
[]
["2007-12-11","consider integrating a localized data store / list for ledgers and funds.  This will have distribution and update costs but these can be mitigated by using a web-based tempalte and alerting users when changes have been made.  This is aloso contemplated for all relevant forms and will help guide users into the habit of checking and using latest form."]
["2007-12-12","need to determine which ledgers use Use Tax in what way.  Appears that some create that item while others accumulate until later (quarterly?) IF Use Tax wil be paid in a batch - how is it accumulated?  Is each batch including a payment to the Use Tax 'vendor' for that ledger or what ...?"]
[]
["[  ]  YES","assuming that each batch ID will have single fund association"]
[null,"- therefore, possible to use trailing line to enter UT if separate batch"]
[]
[]
["2008-02-06","ready for prime-time testing."]
{"$rows_empty":8}
[null,0]
[]
[null,"QUICK NOTES"]
[null,{"v":0,"d":"0.000"},"User enters LedgerCode - or opening of file checks value if reused"]
[null,{"v":0.01,"d":"0.010"},"check CASE of value - UPPERCASE as needed"]
[null,{"v":0.02,"d":"0.020"},"User entered Ledger Code automatically populates District Name field to right"]
[]
[null,{"v":1,"d":"1.000"},"User enters BATCH ID"]
[null,{"v":1.1,"d":"1.100"},"Batch ID - first 2 char validated against Ledger Code"]
[]
[null,{"v":2,"d":"2.000"},"User enters Computer Fund"]
[]
[null,{"v":3,"d":"3.000"},"Auditor Fund and Fund Name are automatically updated to reflect correct data for Ledger and Computer Fund."]
[null,{"v":3.1,"d":"3.100"},"Build a function that combines the LedgerCode value with a filtered lookup of Computer Fund value to locate Auditor Fund Number (which also triggers the Fund Name lookup)"]
[null,3.105,"Maybe build a quick array when the LedgerCode value changes that is restricted to the LedgerCode's available values ???"]
[null,{"v":3.2,"d":"3.200"}]
[]
[null,{"v":4,"d":"4.000"},"Use Tax - can this info be porvided - is a CDD report needed"]
[null,{"v":4.1,"d":"4.100"},"\"P  or \"D\" code indicates whether or not the Use Tax amount is being Paid in this check run or Deferred for quarterly payment"]
[null,4.105,"Only those lines with a \"P\" for paid are summed into the total at the bottom of the Use Tax Amount column"]
[]
[null,{"v":9.9,"d":"9.900"},"need method to verify/validate identity of submitter"]
[null,{"v":9.9,"d":"9.900"},"need ledger & computer fund lookup code"]
[null,{"v":9.9,"d":"9.900"},"Can we get totals by fund - do we need a CDD report to provide that information?"]