{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["PY-Authorization","automation"],"not_rendered":{"defined_names":29},"read":"whole","date_system":"1900"}

{"sheet":"PY-Authorization","index":0,"n_rows":55,"n_cols":16,"rows_kept":55,"merged":[[4,4,4,8],[8,4,8,5],[9,4,9,5],[10,4,10,5],[11,4,11,5]]}
[]
[null,"Yuba County Office of Education\nPAYROLL PROCESSING AUTHORIZATION"]
[]
[]
[{"$nulls":3},"To: ","Fiscal Tech  (fiscal.tech@yubacoe.k12.ca.us)"]
[]
[{"$nulls":3},"Organization: ",null,{"$f":"IF(E7=\"\",\"\",VLOOKUP(fOrganization,org2name,2,FALSE))","v":""},{"$nulls":8},{"$f":"fUniqueKey","v":"DDD757"},"  <=Add this text to your file name for uniqueness (only once for each new file)"]
[]
[{"$nulls":3},"Pay Type: "]
[{"$nulls":3},"Pay Date: ",null,null,"Fiscal Year: "]
[{"$nulls":3},"Net Pay: "]
[{"$nulls":3},"Submit Date: "]
[]
[]
[]
[]
[]
[]
[null,null,"EMPLOYEE ID"]
[]
[]
[]
[]
[]
[null,null,"SELECTION CRITERIA"]
[null,null,"Employee Information"]
[{"$nulls":3},"EmpBargng Unit"]
[]
[]
[]
[]
[{"$nulls":6},"AUTHORIZATION"]
[]
[{"$nulls":6},"You are authorized to process this payroll"]
[]
[]
[{"$nulls":6},"Authorized By"]
[]
[{"$nulls":6},"Title"]
[]
[]
[{"$nulls":6},"Date"]
[]
[]
[]
[null,null,"INSTRUCTIONS:"]
[]
[null,null,"Complete all fields after payroll has been submitted in Payroll Status activity using data from the screen."]
[null,null,"Save authorization file with filename format PY-Authorization-XX-YYYYMMDD-UUUUUU.xls"]
[null,null,"Email the file to Fiscal Tech before the processing cutoff date & time"]
[null,null,"Use an email subject of PY-Authorization-XX-YYYYMMDD-UUUUUU"]
[null,null," XX-YYYYMMDD-UUUUUU ( XX =  Org Number (eg 10), YYYYMMDD = full year, Month, and Date of payroll, UUUUUU = unique identifier [see cell O7])"]
[null,null," Add either BM or BW directly after Org Number (no dash or space) to indicate Bi-Monthly (BM) or Bi-Weekly (BW) payroll authorizationscell O7])"]
[null,null,"Important: File name and email subject are used for automated processesing. "]
[null,null," Please be sure to use exact format/pattern indicated above for both items."]

{"sheet":"automation","index":1,"n_rows":28,"n_cols":14,"rows_kept":28,"hidden":true}
[]
[{"$nulls":9},2]
[]
[]
[]
["Org","Name"]
[" ","   ",{"$nulls":5},"UniquenessGenerator",null,"Generates a random PLUS time based key to add to file name for uniqueness"]
[10,"Yuba County Schools"]
[20,"Plumas Elementary",{"$nulls":5},{"$f":"RANDBETWEEN(65,70)","v":67},{"$f":"CHAR(H9)","v":"C"}]
[30,"Wheatland Union High School",{"$nulls":5},70,{"$f":"CHAR(H10)","v":"F"},{"$f":"INT(AVERAGE(H9:H11))","v":68},{"$f":"CHAR(J10)","v":"D"}]
[40,"Camptonville Union",{"$nulls":5},68,"D"]
[50,"Camptonville Academy",{"$nulls":5},69,"E",{"$f":"INT(AVERAGE(H11:H13))","v":68},{"$f":"CHAR(J12)","v":"D"}]
[{"$nulls":7},68,"D"]
[{"$nulls":7},69,"E",{"$f":"INT(AVERAGE(H13:H15))","v":68},{"$f":"CHAR(J14)","v":"D"}]
[{"$nulls":7},67,"C"]
[]
[]
[{"$nulls":7},{"$f":"NOW()","v":"2018-01-31T17:02:15.860"},{"$f":"YEAR($H$18)","v":2018},{"$f":"I18*10","v":20180},{"$f":"SUM(J18:J20)","v":21490}]
[{"$nulls":8},{"$f":"MONTH($H$18)","v":1},{"$f":"I19*1000","v":1000}]
[{"$nulls":8},{"$f":"DAY($H$18)","v":31},{"$f":"I20*10","v":310}]
[{"$nulls":8},{"$f":"HOUR($H$18)","v":17},{"$f":"I21*1000","v":17000},{"$f":"SUM(J21:J23)","v":17360}]
[{"$nulls":8},{"$f":"MINUTE($H$18)","v":2},{"$f":"I22*100","v":200}]
[{"$nulls":8},{"$f":"SECOND($H$18)","v":16},{"$f":"I23*10","v":160}]
[{"$nulls":10},{"$f":"K21+K18","v":38850},{"$f":"K24/256","v":151.7578125}]
[]
[{"$nulls":11},{"$f":"INT(L24)","v":151},null,{"$f":"LEFT(INT((L24-L26)*1000) & INT(RAND()*10) & INT(RAND()*10) & INT(RAND()*9),3)","v":"757"}]
[]
[{"$nulls":7},"Unique Key: ",{"$f":"K10&K12&K14&N26","v":"DDD757"}]