{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Policy","Instructions","MASTOR CONTROLS"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":38,"comments":0,"pivot_tables":0},"unopened":[],"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"}

{"sheet":"Jan","index":0,"n_rows":72,"n_cols":22,"rows_kept":72,"cut":false,"hidden":false,"merged":[[75,8,75,10],[47,8,47,9],[38,8,38,9],[39,8,39,9],[43,8,43,9],[46,8,46,9],[70,6,70,8],[72,10,72,11],[59,8,59,9],[40,8,40,9],[44,8,44,9],[42,8,42,9],[45,8,45,9],[48,8,48,9],[68,6,68,8],[55,11,55,15],[70,14,70,15],[68,14,68,15],[69,14,69,15],[61,9,61,10],[57,8,57,9],[69,9,69,10],[68,9,68,10],[67,12,67,13],[28,6,28,7],[27,6,27,7],[50,0,50,5],[55,0,55,1],[35,1,35,5],[28,1,28,5],[29,1,29,5],[32,1,32,5],[42,1,42,5],[43,1,43,5],[48,1,48,5],[49,1,49,5],[44,1,44,5],[46,1,46,5],[41,1,41,5],[29,6,29,7],[44,6,44,7],[43,6,43,7],[42,6,42,7],[41,6,41,7],[40,6,40,7],[39,6,39,7],[38,6,38,7],[37,6,37,7],[21,1,21,5],[22,1,22,5],[23,1,23,5],[27,8,27,9],[24,8,24,9],[26,8,26,9],[24,1,24,5],[26,1,26,5],[26,6,26,7],[25,6,25,7],[24,6,24,7],[23,6,23,7],[22,6,22,7],[27,1,27,5],[25,1,25,5],[21,6,21,7],[1,0,1,15],[4,13,4,15],[6,13,6,15],[8,13,10,15],[10,0,10,9],[10,10,10,12],[3,1,3,9],[9,5,9,10],[4,1,4,9],[0,0,0,15],[39,1,39,5],[40,1,40,5],[11,1,11,5],[12,1,12,5],[19,1,19,5],[11,14,12,15],[11,6,11,7],[38,1,38,5],[37,1,37,5],[21,8,21,9],[31,8,31,9],[23,8,23,9],[33,8,33,9],[34,8,34,9],[22,8,22,9],[29,8,29,9],[25,8,25,9],[28,8,28,9],[36,1,36,5],[35,8,35,9],[32,8,32,9],[33,1,33,5],[34,1,34,5],[72,3,72,4],[66,0,66,15],[69,12,69,13],[68,12,68,13],[71,6,71,7],[72,14,72,15],[72,5,72,9],[70,12,70,13],[70,0,70,1],[67,3,67,4],[69,6,69,8],[67,0,67,2],[67,6,67,8],[67,9,67,10],[70,3,70,4],[72,12,72,13],[72,0,72,2],[67,14,67,15],[71,9,71,10],[68,0,68,2],[68,3,68,4],[69,0,69,2],[69,3,69,4],[70,9,70,10],[3,16,3,19],[4,16,8,19],[9,16,9,19],[8,0,8,9],[9,1,9,3],[11,11,11,12],[11,8,12,9],[19,8,19,9],[20,1,20,5],[20,8,20,9],[6,0,7,12],[11,10,12,10],[11,0,12,0],[20,6,20,7],[19,6,19,7],[12,6,12,7],[33,6,33,7],[32,6,32,7],[31,6,31,7],[31,1,31,5],[56,0,56,5],[47,1,47,5],[30,6,30,7],[49,6,49,7],[48,6,48,7],[47,6,47,7],[46,6,46,7],[45,6,45,7],[30,8,30,9],[36,6,36,7],[30,1,30,5],[36,8,36,9],[41,8,41,9],[61,0,61,2],[37,8,37,9],[62,0,63,1],[61,13,61,14],[50,8,50,9],[49,8,49,9],[45,1,45,5],[62,2,63,15],[61,11,61,12],[58,0,58,6],[61,6,61,8],[59,0,59,6],[55,8,56,9],[58,8,58,9],[57,0,57,6],[53,0,53,12],[52,0,52,2],[35,6,35,7],[34,6,34,7]]}
[{"$f":"\"Northern California Conference Expense Report\" & IF($U$65=TRUE,\" (REVISED)\",\"\")","v":"Northern California Conference Expense Report"}]
["Email to: payroll@nccsda.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Per Diem Note:"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'MASTOR CONTROLS'!G4","v":"2026-01-01"},null,null,"1) If you are away from home and have an overnight stay on either side of a day you qualify for per diem, choose an option with NT."]
[]
[{"$f":"IF(COUNTBLANK(A20:A50)=0,\" \",\"Your report is incomplete! Please select a short description from the drop-down list for every day of the month. \"&COUNTBLANK(A20:A50)&\" days in the first column are blank.\")","v":"Your report is incomplete! Please select a short description from the drop-down list for every day of the month. 31 days in the first column are blank."},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" IF(N5<>'MASTOR CONTROLS'!G3,\"Due \" & TEXT(DATE(1,MONTH(I20)+1,1),\"mmmm\") & \" 3rd.\",\"\")","v":"Due February 3rd."}]
[]
["Best way to contact:",null,null,null,null,null,null,null,null,null,null,null,null,"*Reimbursements are made for completed reports including original receipts with travel approval from ADCO or assigned job duties. Lodging must be documented with a folio."]
["Phone:",null,null,null,"Email:","enter email address here",null,null,null,null,null,null,null,null,null,null,"2) Spousal per diems are always taxable."]
["*Mileage cannot be reimbursed without both the location and reason for travel.",null,null,null,null,null,null,null,null,null,"** ADCO must approve Special Mileage."]
["Short Description","Mileage Activity and Location*",null,null,null,null,null,null,"Date",null,"Special Mileage**","Per Diem",null,null,"Air/Car/Gas/Transit    Other",null,null,"PD Tx","PD NTx","Per Diem","Ans: Per"]
[null,"Eg. \"Sacramento visit,\" \"Redding school board,\" etc.",null,null,null,null,"Budgeted Mileage",null,null,null,null,"Taxable","Non-Tax","Lodging*",null,null,null,{"$f":"$L$51","v":0},{"$f":"$M$51","v":0},"Totals","Diem"]
[]
["Worked"]
["Day Off"]
["Vacation"]
["Sick Day"]
["Holiday"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,N5,\"\")","v":"2026-01-01"},null,null,{"$f":"IF($U20>1,VLOOKUP($U20,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U20>1,VLOOKUP($U20,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,{"$f":"TEXT(I20,\"ddd\")","v":"Thu"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I20+1,\"\")","v":"2026-01-02"},null,null,{"$f":"IF($U21>1,VLOOKUP($U21,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U21>1,VLOOKUP($U21,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I21+1,\"\")","v":"2026-01-03"},null,null,{"$f":"IF($U22>1,VLOOKUP($U22,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U22>1,VLOOKUP($U22,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I22+1,\"\")","v":"2026-01-04"},null,null,{"$f":"IF($U23>1,VLOOKUP($U23,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U23>1,VLOOKUP($U23,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I23+1,\"\")","v":"2026-01-05"},null,null,{"$f":"IF($U24>1,VLOOKUP($U24,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U24>1,VLOOKUP($U24,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I24+1,\"\")","v":"2026-01-06"},null,null,{"$f":"IF($U25>1,VLOOKUP($U25,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U25>1,VLOOKUP($U25,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I25+1,\"\")","v":"2026-01-07"},null,null,{"$f":"IF($U26>1,VLOOKUP($U26,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U26>1,VLOOKUP($U26,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I26+1,\"\")","v":"2026-01-08"},null,null,{"$f":"IF($U27>1,VLOOKUP($U27,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U27>1,VLOOKUP($U27,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I27+1,\"\")","v":"2026-01-09"},null,null,{"$f":"IF($U28>1,VLOOKUP($U28,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U28>1,VLOOKUP($U28,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I28+1,\"\")","v":"2026-01-10"},null,null,{"$f":"IF($U29>1,VLOOKUP($U29,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U29>1,VLOOKUP($U29,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I29+1,\"\")","v":"2026-01-11"},null,null,{"$f":"IF($U30>1,VLOOKUP($U30,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U30>1,VLOOKUP($U30,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I30+1,\"\")","v":"2026-01-12"},null,null,{"$f":"IF($U31>1,VLOOKUP($U31,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U31>1,VLOOKUP($U31,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I31+1,\"\")","v":"2026-01-13"},null,null,{"$f":"IF($U32>1,VLOOKUP($U32,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U32>1,VLOOKUP($U32,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I32+1,\"\")","v":"2026-01-14"},null,null,{"$f":"IF($U33>1,VLOOKUP($U33,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U33>1,VLOOKUP($U33,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I33+1,\"\")","v":"2026-01-15"},null,null,{"$f":"IF($U34>1,VLOOKUP($U34,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U34>1,VLOOKUP($U34,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I34+1,\"\")","v":"2026-01-16"},null,null,{"$f":"IF($U35>1,VLOOKUP($U35,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U35>1,VLOOKUP($U35,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I35+1,\"\")","v":"2026-01-17"},null,null,{"$f":"IF($U36>1,VLOOKUP($U36,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U36>1,VLOOKUP($U36,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I36+1,\"\")","v":"2026-01-18"},null,null,{"$f":"IF($U37>1,VLOOKUP($U37,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U37>1,VLOOKUP($U37,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I37+1,\"\")","v":"2026-01-19"},null,null,{"$f":"IF($U38>1,VLOOKUP($U38,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U38>1,VLOOKUP($U38,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I38+1,\"\")","v":"2026-01-20"},null,null,{"$f":"IF($U39>1,VLOOKUP($U39,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U39>1,VLOOKUP($U39,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I39+1,\"\")","v":"2026-01-21"},null,null,{"$f":"IF($U40>1,VLOOKUP($U40,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U40>1,VLOOKUP($U40,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I40+1,\"\")","v":"2026-01-22"},null,null,{"$f":"IF($U41>1,VLOOKUP($U41,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U41>1,VLOOKUP($U41,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I41+1,\"\")","v":"2026-01-23"},null,null,{"$f":"IF($U42>1,VLOOKUP($U42,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U42>1,VLOOKUP($U42,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I42+1,\"\")","v":"2026-01-24"},null,null,{"$f":"IF($U43>1,VLOOKUP($U43,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U43>1,VLOOKUP($U43,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I43+1,\"\")","v":"2026-01-25"},null,null,{"$f":"IF($U44>1,VLOOKUP($U44,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U44>1,VLOOKUP($U44,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I44+1,\"\")","v":"2026-01-26"},null,null,{"$f":"IF($U45>1,VLOOKUP($U45,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U45>1,VLOOKUP($U45,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I45+1,\"\")","v":"2026-01-27"},null,null,{"$f":"IF($U46>1,VLOOKUP($U46,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U46>1,VLOOKUP($U46,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I46+1,\"\")","v":"2026-01-28"},null,null,{"$f":"IF($U47>1,VLOOKUP($U47,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U47>1,VLOOKUP($U47,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(N$5<>'MASTOR CONTROLS'!$G$3,I47<VLOOKUP(N$5,'MASTOR CONTROLS'!$G$3:$I$19,3)),I47+1,\"\")","v":"2026-01-29"},null,null,{"$f":"IF($U48>1,VLOOKUP($U48,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U48>1,VLOOKUP($U48,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(N$5<>'MASTOR CONTROLS'!$G$3,I48<VLOOKUP(N$5,'MASTOR CONTROLS'!$G$3:$I$19,3)),I48+1,\"\")","v":"2026-01-30"},null,null,{"$f":"IF($U49>1,VLOOKUP($U49,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U49>1,VLOOKUP($U49,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(N$5<>'MASTOR CONTROLS'!$G$3,I49<VLOOKUP(N$5,'MASTOR CONTROLS'!$G$3:$I$19,3)),I49+1,\"\")","v":"2026-01-31"},null,null,{"$f":"IF($U50>1,VLOOKUP($U50,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U50>1,VLOOKUP($U50,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
["TOTALS",null,null,null,null,null,{"$f":"SUM(G20:G50)","v":0},{"$f":"SUM(H20:H50)","v":0},null,null,{"$f":"SUM(K20:K50)","v":0},0,0,0,0,0]
[]
["Office Staff Section",null,null,null,null,null,null,null,null,null,null,null,null,"Phone","Internet","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N54:O54)","v":0}]
[]
["Pastor's Section",null,null,null,null,null,null,null,"Professions of Faith",null,null,"Worship Service Attendance"]
["Church Name (Or Designated Pastor's Name)",null,null,null,null,null,null,"Baptisms",null,null,"Transfers","Week 1","Week 2","Week 3","Week 4","Week 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(V20:V50,\"Sat\")","v":5},{"$f":"COUNT(G58:P58)","v":0}]
[]
[]
[]
[]
["Comments & Notes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["OFFICE USE ONLY"]
["RTB) Travel Budget",null,null,null,null,null,"RTP) Per Diem Tx",null,null,null,null,null,"REM) Trav. Misc"]
["RGM) Non-Tax Miles",null,null,null,null,null,"RTN) Per Diem NTx",null,null,null,null,null,"RFR) Conv./Mtgs"]
["RTT) Special Miles",null,null,null,null,null,"RLN) Lodging"]
["RST) Spouse Trvl",null,null,null,null,null,"RTC )Car Rental"]
[null,null,null,null,null,null,"REA) Airfare Travel"]

{"sheet":"Feb","index":1,"n_rows":69,"n_cols":22,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,0,0,15],[1,0,1,15],[3,1,3,9],[3,16,3,19],[4,1,4,9],[4,13,4,15],[4,16,8,19],[6,0,7,12],[6,13,6,15],[8,0,8,9],[11,11,11,12],[11,14,12,15],[12,1,12,5],[12,6,12,7],[8,13,10,15],[9,1,9,3],[9,5,9,10],[9,16,9,19],[10,0,10,9],[10,10,10,12],[19,1,19,5],[19,6,19,7],[19,8,19,9],[20,1,20,5],[20,6,20,7],[20,8,20,9],[11,1,11,5],[11,6,11,7],[11,8,12,9],[23,1,23,5],[23,6,23,7],[23,8,23,9],[24,1,24,5],[24,6,24,7],[24,8,24,9],[21,1,21,5],[21,6,21,7],[21,8,21,9],[22,1,22,5],[22,6,22,7],[22,8,22,9],[27,1,27,5],[27,6,27,7],[27,8,27,9],[28,1,28,5],[28,6,28,7],[28,8,28,9],[25,1,25,5],[25,6,25,7],[25,8,25,9],[26,1,26,5],[26,6,26,7],[26,8,26,9],[31,1,31,5],[31,6,31,7],[31,8,31,9],[32,1,32,5],[32,6,32,7],[32,8,32,9],[29,1,29,5],[29,6,29,7],[29,8,29,9],[30,1,30,5],[30,6,30,7],[30,8,30,9],[35,1,35,5],[35,6,35,7],[35,8,35,9],[36,1,36,5],[36,6,36,7],[36,8,36,9],[33,1,33,5],[33,6,33,7],[33,8,33,9],[34,1,34,5],[34,6,34,7],[34,8,34,9],[39,1,39,5],[39,6,39,7],[39,8,39,9],[40,1,40,5],[40,6,40,7],[40,8,40,9],[37,1,37,5],[37,6,37,7],[37,8,37,9],[38,1,38,5],[38,6,38,7],[38,8,38,9],[43,1,43,5],[43,6,43,7],[43,8,43,9],[44,1,44,5],[44,6,44,7],[44,8,44,9],[41,1,41,5],[41,6,41,7],[41,8,41,9],[42,1,42,5],[42,6,42,7],[42,8,42,9],[47,0,47,5],[47,8,47,9],[49,0,49,2],[45,1,45,5],[45,6,45,7],[45,8,45,9],[46,1,46,5],[46,6,46,7],[46,8,46,9],[55,0,55,6],[55,8,55,9],[56,0,56,6],[56,8,56,9],[58,0,58,2],[58,6,58,8],[58,9,58,10],[50,0,50,12],[52,0,52,1],[52,8,53,9],[52,11,52,15],[53,0,53,5],[54,0,54,6],[54,8,54,9],[65,0,65,2],[65,3,65,4],[65,6,65,8],[65,9,65,10],[65,12,65,13],[65,14,65,15],[58,11,58,12],[58,13,58,14],[59,0,60,1],[59,2,60,15],[63,0,63,15],[64,0,64,2],[64,3,64,4],[64,6,64,8],[64,9,64,10],[64,12,64,13],[69,12,69,13],[69,14,69,15],[72,8,72,10],[11,10,12,10],[11,0,12,0],[68,6,68,7],[68,9,68,10],[69,0,69,2],[69,3,69,4],[69,5,69,9],[69,10,69,11],[67,0,67,1],[67,3,67,4],[67,6,67,8],[67,9,67,10],[67,12,67,13],[67,14,67,15],[66,0,66,2],[66,3,66,4],[66,6,66,8],[66,9,66,10],[66,12,66,13],[66,14,66,15],[64,14,64,15]]}
[{"$f":"\"Northern California Conference Expense Report\" & IF($U$62=TRUE,\" (REVISED)\",\"\")","v":"Northern California Conference Expense Report"}]
["Email to: payroll@nccsda.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Per Diem Note:"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,"2026-02-01",null,null,"1) If you are away from home and have an overnight stay on either side of a day you qualify for per diem, choose an option with NT."]
[]
[{"$f":"IF(COUNTBLANK(A20:A47)=0,\" \",\"Your report is incomplete! Please select a short description from the drop-down list for every day of the month. \"&COUNTBLANK(A20:A47)&\" days in the first column are blank.\")","v":"Your report is incomplete! Please select a short description from the drop-down list for every day of the month. 28 days in the first column are blank."},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" IF(N5<>'MASTOR CONTROLS'!G3,\"Due \" & TEXT(DATE(1,MONTH(I20)+1,1),\"mmmm\") & \" 3rd.\",\"\")","v":"Due March 3rd."}]
[]
["Best way to contact:",null,null,null,null,null,null,null,null,null,null,null,null,"*Reimbursements are made for completed reports including original receipts with travel approval from ADCO or assigned job duties. Lodging must be documented with a folio."]
["Phone:",null,null,null,"Email:","enter email address here",null,null,null,null,null,null,null,null,null,null,"2) Spousal per diems are always taxable."]
["*Mileage cannot be reimbursed without both the location and reason for travel.",null,null,null,null,null,null,null,null,null,"** ADCO must approve Special Mileage."]
["Short Description","Mileage Activity and Location*",null,null,null,null,null,null,"Date",null,"Special Mileage**","Per Diem",null,null,"Air/Car/Gas/Transit    Other",null,null,"PD Tx","PD NTx","Per Diem","Ans: Per"]
[null,"Eg. \"Sacramento visit,\" \"Redding school board,\" etc.",null,null,null,null,"Budgeted Mileage",null,null,null,null,"Taxable","Non-Tax","Lodging*",null,null,null,{"$f":"$L$48","v":0},{"$f":"$M$48","v":0},"Totals","Diem"]
[]
["Worked"]
["Day Off"]
["Vacation"]
["Sick Day"]
["Holiday"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,N5,\"\")","v":"2026-02-01"},null,null,{"$f":"IF($U20>1,VLOOKUP($U20,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U20>1,VLOOKUP($U20,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,{"$f":"TEXT(I20,\"ddd\")","v":"Sun"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I20+1,\"\")","v":"2026-02-02"},null,null,{"$f":"IF($U21>1,VLOOKUP($U21,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U21>1,VLOOKUP($U21,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I21+1,\"\")","v":"2026-02-03"},null,null,{"$f":"IF($U22>1,VLOOKUP($U22,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U22>1,VLOOKUP($U22,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I22+1,\"\")","v":"2026-02-04"},null,null,{"$f":"IF($U23>1,VLOOKUP($U23,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U23>1,VLOOKUP($U23,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I23+1,\"\")","v":"2026-02-05"},null,null,{"$f":"IF($U24>1,VLOOKUP($U24,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U24>1,VLOOKUP($U24,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I24+1,\"\")","v":"2026-02-06"},null,null,{"$f":"IF($U25>1,VLOOKUP($U25,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U25>1,VLOOKUP($U25,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I25+1,\"\")","v":"2026-02-07"},null,null,{"$f":"IF($U26>1,VLOOKUP($U26,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U26>1,VLOOKUP($U26,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I26+1,\"\")","v":"2026-02-08"},null,null,{"$f":"IF($U27>1,VLOOKUP($U27,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U27>1,VLOOKUP($U27,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I27+1,\"\")","v":"2026-02-09"},null,null,{"$f":"IF($U28>1,VLOOKUP($U28,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U28>1,VLOOKUP($U28,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I28+1,\"\")","v":"2026-02-10"},null,null,{"$f":"IF($U29>1,VLOOKUP($U29,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U29>1,VLOOKUP($U29,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I29+1,\"\")","v":"2026-02-11"},null,null,{"$f":"IF($U30>1,VLOOKUP($U30,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U30>1,VLOOKUP($U30,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I30+1,\"\")","v":"2026-02-12"},null,null,{"$f":"IF($U31>1,VLOOKUP($U31,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U31>1,VLOOKUP($U31,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I31+1,\"\")","v":"2026-02-13"},null,null,{"$f":"IF($U32>1,VLOOKUP($U32,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U32>1,VLOOKUP($U32,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I32+1,\"\")","v":"2026-02-14"},null,null,{"$f":"IF($U33>1,VLOOKUP($U33,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U33>1,VLOOKUP($U33,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I33+1,\"\")","v":"2026-02-15"},null,null,{"$f":"IF($U34>1,VLOOKUP($U34,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U34>1,VLOOKUP($U34,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I34+1,\"\")","v":"2026-02-16"},null,null,{"$f":"IF($U35>1,VLOOKUP($U35,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U35>1,VLOOKUP($U35,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I35+1,\"\")","v":"2026-02-17"},null,null,{"$f":"IF($U36>1,VLOOKUP($U36,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U36>1,VLOOKUP($U36,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I36+1,\"\")","v":"2026-02-18"},null,null,{"$f":"IF($U37>1,VLOOKUP($U37,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U37>1,VLOOKUP($U37,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I37+1,\"\")","v":"2026-02-19"},null,null,{"$f":"IF($U38>1,VLOOKUP($U38,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U38>1,VLOOKUP($U38,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I38+1,\"\")","v":"2026-02-20"},null,null,{"$f":"IF($U39>1,VLOOKUP($U39,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U39>1,VLOOKUP($U39,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I39+1,\"\")","v":"2026-02-21"},null,null,{"$f":"IF($U40>1,VLOOKUP($U40,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U40>1,VLOOKUP($U40,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I40+1,\"\")","v":"2026-02-22"},null,null,{"$f":"IF($U41>1,VLOOKUP($U41,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U41>1,VLOOKUP($U41,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I41+1,\"\")","v":"2026-02-23"},null,null,{"$f":"IF($U42>1,VLOOKUP($U42,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U42>1,VLOOKUP($U42,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I42+1,\"\")","v":"2026-02-24"},null,null,{"$f":"IF($U43>1,VLOOKUP($U43,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U43>1,VLOOKUP($U43,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I43+1,\"\")","v":"2026-02-25"},null,null,{"$f":"IF($U44>1,VLOOKUP($U44,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U44>1,VLOOKUP($U44,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I44+1,\"\")","v":"2026-02-26"},null,null,{"$f":"IF($U45>1,VLOOKUP($U45,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U45>1,VLOOKUP($U45,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I45+1,\"\")","v":"2026-02-27"},null,null,{"$f":"IF($U46>1,VLOOKUP($U46,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U46>1,VLOOKUP($U46,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I46+1,\"\")","v":"2026-02-28"},null,null,{"$f":"IF($U47>1,VLOOKUP($U47,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U47>1,VLOOKUP($U47,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
["TOTALS",null,null,null,null,null,{"$f":"SUM(G20:G47)","v":0},{"$f":"SUM(H20:H47)","v":0},null,null,{"$f":"SUM(K20:K47)","v":0},0,0,0,0,0]
[]
["Office Staff Section",null,null,null,null,null,null,null,null,null,null,null,null,"Phone","Internet","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N51:O51)","v":0}]
[]
["Pastor's Section",null,null,null,null,null,null,null,"Professions of Faith",null,null,"Worship Service Attendance"]
["Church Name (Or Designated Pastor's Name)",null,null,null,null,null,null,"Baptisms",null,null,"Transfers","Week 1","Week 2","Week 3","Week 4","Week 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(V20:V47,\"Sat\")","v":4},{"$f":"COUNT(G55:P55)","v":0}]
[]
[]
[]
[]
["Comments & Notes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["OFFICE USE ONLY"]
["RTB) Travel Budget",null,null,null,null,null,"RTP) Per Diem Tx",null,null,null,null,null,"REM) Trav. Misc"]
["RGM) Non-Tax Miles",null,null,null,null,null,"RTN) Per Diem NTx",null,null,null,null,null,"RTN) Conv./Mtgs"]
["RTT) Special Miles",null,null,null,null,null,"RLN) Lodging"]
["RST) Spouse Trvl",null,null,null,null,null,"RTC )Car Rental"]
[null,null,null,null,null,null,"REA) Airfare Travel"]

{"sheet":"Mar","index":2,"n_rows":72,"n_cols":22,"rows_kept":72,"cut":false,"hidden":false,"merged":[[9,16,9,19],[10,0,10,9],[10,10,10,12],[0,0,0,15],[1,0,1,15],[3,1,3,9],[3,16,3,19],[4,1,4,9],[4,13,4,15],[4,16,8,19],[6,0,7,12],[6,13,6,15],[8,0,8,9],[11,1,11,5],[11,6,11,7],[11,8,12,9],[11,10,12,10],[11,11,11,12],[11,14,12,15],[12,1,12,5],[12,6,12,7],[8,13,10,15],[9,1,9,3],[9,5,9,10],[21,1,21,5],[21,6,21,7],[21,8,21,9],[22,1,22,5],[22,6,22,7],[22,8,22,9],[19,1,19,5],[19,6,19,7],[19,8,19,9],[20,1,20,5],[20,6,20,7],[20,8,20,9],[25,1,25,5],[25,6,25,7],[25,8,25,9],[26,1,26,5],[26,6,26,7],[26,8,26,9],[23,1,23,5],[23,6,23,7],[23,8,23,9],[24,1,24,5],[24,6,24,7],[24,8,24,9],[29,1,29,5],[29,6,29,7],[29,8,29,9],[30,1,30,5],[30,6,30,7],[30,8,30,9],[27,1,27,5],[27,6,27,7],[27,8,27,9],[28,1,28,5],[28,6,28,7],[28,8,28,9],[33,1,33,5],[33,6,33,7],[33,8,33,9],[34,1,34,5],[34,6,34,7],[34,8,34,9],[31,1,31,5],[31,6,31,7],[31,8,31,9],[32,1,32,5],[32,6,32,7],[32,8,32,9],[37,1,37,5],[37,6,37,7],[37,8,37,9],[38,1,38,5],[38,6,38,7],[38,8,38,9],[35,1,35,5],[35,6,35,7],[35,8,35,9],[36,1,36,5],[36,6,36,7],[36,8,36,9],[41,1,41,5],[41,6,41,7],[41,8,41,9],[42,1,42,5],[42,6,42,7],[42,8,42,9],[39,1,39,5],[39,6,39,7],[39,8,39,9],[40,1,40,5],[40,6,40,7],[40,8,40,9],[45,1,45,5],[45,6,45,7],[45,8,45,9],[46,1,46,5],[46,6,46,7],[46,8,46,9],[43,1,43,5],[43,6,43,7],[43,8,43,9],[44,1,44,5],[44,6,44,7],[44,8,44,9],[49,1,49,5],[49,6,49,7],[49,8,49,9],[50,0,50,5],[50,8,50,9],[52,0,52,2],[47,1,47,5],[47,6,47,7],[47,8,47,9],[48,1,48,5],[48,6,48,7],[48,8,48,9],[58,0,58,6],[58,8,58,9],[59,0,59,6],[59,8,59,9],[61,0,61,2],[61,6,61,8],[61,9,61,10],[53,0,53,12],[55,0,55,1],[55,8,56,9],[55,11,55,15],[56,0,56,5],[57,0,57,6],[57,8,57,9],[68,3,68,4],[68,6,68,8],[68,9,68,10],[68,12,68,13],[68,14,68,15],[61,11,61,12],[61,13,61,14],[62,0,63,1],[62,2,63,15],[66,0,66,15],[67,0,67,2],[67,3,67,4],[67,6,67,8],[67,9,67,10],[67,12,67,13],[72,12,72,13],[72,14,72,15],[75,8,75,10],[11,0,12,0],[71,6,71,7],[71,9,71,10],[72,0,72,2],[72,3,72,4],[72,5,72,9],[72,10,72,11],[70,0,70,1],[70,3,70,4],[70,6,70,8],[70,9,70,10],[70,12,70,13],[70,14,70,15],[69,0,69,2],[69,3,69,4],[69,6,69,8],[69,9,69,10],[69,12,69,13],[69,14,69,15],[67,14,67,15],[68,0,68,2]]}
[{"$f":"\"Northern California Conference Expense Report\" & IF($U$65=TRUE,\" (REVISED)\",\"\")","v":"Northern California Conference Expense Report"}]
["Email to: payroll@nccsda.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Per Diem Note:"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,"2026-03-01",null,null,"1) If you are away from home and have an overnight stay on either side of a day you qualify for per diem, choose an option with NT."]
[]
[{"$f":"IF(COUNTBLANK(A20:A50)=0,\" \",\"Your report is incomplete! Please select a short description from the drop-down list for every day of the month. \"&COUNTBLANK(A20:A50)&\" days in the first column are blank.\")","v":"Your report is incomplete! Please select a short description from the drop-down list for every day of the month. 31 days in the first column are blank."},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" IF(N5<>'MASTOR CONTROLS'!G3,\"Due \" & TEXT(DATE(1,MONTH(I20)+1,1),\"mmmm\") & \" 3rd.\",\"\")","v":"Due April 3rd."}]
[]
["Best way to contact:",null,null,null,null,null,null,null,null,null,null,null,null,"*Reimbursements are made for completed reports including original receipts with travel approval from ADCO or assigned job duties. Lodging must be documented with a folio."]
["Phone:",null,null,null,"Email:","enter email address here",null,null,null,null,null,null,null,null,null,null,"2) Spousal per diems are always taxable."]
["*Mileage cannot be reimbursed without both the location and reason for travel.",null,null,null,null,null,null,null,null,null,"** ADCO must approve Special Mileage."]
["Short Description","Mileage Activity and Location*",null,null,null,null,null,null,"Date",null,"Special Mileage**","Per Diem",null,null,"Air/Car/Gas/Transit    Other",null,null,"PD Tx","PD NTx","Per Diem","Ans: Per"]
[null,"Eg. \"Sacramento visit,\" \"Redding school board,\" etc.",null,null,null,null,"Budgeted Mileage",null,null,null,null,"Taxable","Non-Tax","Lodging*",null,null,null,{"$f":"$L$51","v":0},{"$f":"$M$51","v":0},"Totals","Diem"]
[]
["Worked"]
["Day Off"]
["Vacation"]
["Sick Day"]
["Holiday"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,N5,\"\")","v":"2026-03-01"},null,null,{"$f":"IF($U20>1,VLOOKUP($U20,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U20>1,VLOOKUP($U20,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,{"$f":"TEXT(I20,\"ddd\")","v":"Sun"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I20+1,\"\")","v":"2026-03-02"},null,null,{"$f":"IF($U21>1,VLOOKUP($U21,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U21>1,VLOOKUP($U21,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I21+1,\"\")","v":"2026-03-03"},null,null,{"$f":"IF($U22>1,VLOOKUP($U22,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U22>1,VLOOKUP($U22,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I22+1,\"\")","v":"2026-03-04"},null,null,{"$f":"IF($U23>1,VLOOKUP($U23,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U23>1,VLOOKUP($U23,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I23+1,\"\")","v":"2026-03-05"},null,null,{"$f":"IF($U24>1,VLOOKUP($U24,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U24>1,VLOOKUP($U24,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I24+1,\"\")","v":"2026-03-06"},null,null,{"$f":"IF($U25>1,VLOOKUP($U25,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U25>1,VLOOKUP($U25,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I25+1,\"\")","v":"2026-03-07"},null,null,{"$f":"IF($U26>1,VLOOKUP($U26,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U26>1,VLOOKUP($U26,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I26+1,\"\")","v":"2026-03-08"},null,null,{"$f":"IF($U27>1,VLOOKUP($U27,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U27>1,VLOOKUP($U27,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I27+1,\"\")","v":"2026-03-09"},null,null,{"$f":"IF($U28>1,VLOOKUP($U28,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U28>1,VLOOKUP($U28,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I28+1,\"\")","v":"2026-03-10"},null,null,{"$f":"IF($U29>1,VLOOKUP($U29,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U29>1,VLOOKUP($U29,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I29+1,\"\")","v":"2026-03-11"},null,null,{"$f":"IF($U30>1,VLOOKUP($U30,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U30>1,VLOOKUP($U30,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I30+1,\"\")","v":"2026-03-12"},null,null,{"$f":"IF($U31>1,VLOOKUP($U31,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U31>1,VLOOKUP($U31,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I31+1,\"\")","v":"2026-03-13"},null,null,{"$f":"IF($U32>1,VLOOKUP($U32,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U32>1,VLOOKUP($U32,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I32+1,\"\")","v":"2026-03-14"},null,null,{"$f":"IF($U33>1,VLOOKUP($U33,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U33>1,VLOOKUP($U33,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I33+1,\"\")","v":"2026-03-15"},null,null,{"$f":"IF($U34>1,VLOOKUP($U34,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U34>1,VLOOKUP($U34,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I34+1,\"\")","v":"2026-03-16"},null,null,{"$f":"IF($U35>1,VLOOKUP($U35,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U35>1,VLOOKUP($U35,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I35+1,\"\")","v":"2026-03-17"},null,null,{"$f":"IF($U36>1,VLOOKUP($U36,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U36>1,VLOOKUP($U36,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I36+1,\"\")","v":"2026-03-18"},null,null,{"$f":"IF($U37>1,VLOOKUP($U37,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U37>1,VLOOKUP($U37,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I37+1,\"\")","v":"2026-03-19"},null,null,{"$f":"IF($U38>1,VLOOKUP($U38,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U38>1,VLOOKUP($U38,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I38+1,\"\")","v":"2026-03-20"},null,null,{"$f":"IF($U39>1,VLOOKUP($U39,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U39>1,VLOOKUP($U39,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I39+1,\"\")","v":"2026-03-21"},null,null,{"$f":"IF($U40>1,VLOOKUP($U40,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U40>1,VLOOKUP($U40,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I40+1,\"\")","v":"2026-03-22"},null,null,{"$f":"IF($U41>1,VLOOKUP($U41,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U41>1,VLOOKUP($U41,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I41+1,\"\")","v":"2026-03-23"},null,null,{"$f":"IF($U42>1,VLOOKUP($U42,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U42>1,VLOOKUP($U42,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I42+1,\"\")","v":"2026-03-24"},null,null,{"$f":"IF($U43>1,VLOOKUP($U43,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U43>1,VLOOKUP($U43,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I43+1,\"\")","v":"2026-03-25"},null,null,{"$f":"IF($U44>1,VLOOKUP($U44,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U44>1,VLOOKUP($U44,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I44+1,\"\")","v":"2026-03-26"},null,null,{"$f":"IF($U45>1,VLOOKUP($U45,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U45>1,VLOOKUP($U45,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I45+1,\"\")","v":"2026-03-27"},null,null,{"$f":"IF($U46>1,VLOOKUP($U46,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U46>1,VLOOKUP($U46,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I46+1,\"\")","v":"2026-03-28"},null,null,{"$f":"IF($U47>1,VLOOKUP($U47,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U47>1,VLOOKUP($U47,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N6<>'MASTOR CONTROLS'!G4,I47+1,\"\")","v":"2026-03-29"},null,null,{"$f":"IF($U48>1,VLOOKUP($U48,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U48>1,VLOOKUP($U48,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N7<>'MASTOR CONTROLS'!G5,I48+1,\"\")","v":"2026-03-30"},null,null,{"$f":"IF($U49>1,VLOOKUP($U49,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U49>1,VLOOKUP($U49,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N8<>'MASTOR CONTROLS'!G6,I49+1,\"\")","v":"2026-03-31"},null,null,{"$f":"IF($U50>1,VLOOKUP($U50,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U50>1,VLOOKUP($U50,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
["TOTALS",null,null,null,null,null,{"$f":"SUM(G20:G50)","v":0},{"$f":"SUM(H20:H50)","v":0},null,null,{"$f":"SUM(K20:K50)","v":0},0,0,0,0,0]
[]
["Office Staff Section",null,null,null,null,null,null,null,null,null,null,null,null,"Phone","Internet","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N54:O54)","v":0}]
[]
["Pastor's Section",null,null,null,null,null,null,null,"Professions of Faith",null,null,"Worship Service Attendance"]
["Church Name (Or Designated Pastor's Name)",null,null,null,null,null,null,"Baptisms",null,null,"Transfers","Week 1","Week 2","Week 3","Week 4","Week 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(V20:V50,\"Sat\")","v":4},{"$f":"COUNT(G58:P58)","v":0}]
[]
[]
[]
[]
["Comments & Notes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["OFFICE USE ONLY"]
["RTB) Travel Budget",null,null,null,null,null,"RTP) Per Diem Tx",null,null,null,null,null,"REM) Trav. Misc"]
["RGM) Non-Tax Miles",null,null,null,null,null,"RTN) Per Diem NTx",null,null,null,null,null,"RFR) Conv./Mtgs"]
["RTT) Special Miles",null,null,null,null,null,"RLN Lodging"]
["RST) Spouse Trvl",null,null,null,null,null,"RTC )Car Rental"]
[null,null,null,null,null,null,"REA) Airfare Travel"]

{"sheet":"Apr","index":3,"n_rows":71,"n_cols":22,"rows_kept":71,"cut":false,"hidden":false,"merged":[[9,16,9,19],[10,0,10,9],[10,10,10,12],[0,0,0,15],[1,0,1,15],[3,1,3,9],[3,16,3,19],[4,1,4,9],[4,13,4,15],[4,16,8,19],[6,0,7,12],[6,13,6,15],[8,0,8,9],[11,1,11,5],[11,6,11,7],[11,8,12,9],[11,10,12,10],[11,11,11,12],[11,14,12,15],[12,1,12,5],[12,6,12,7],[8,13,10,15],[9,1,9,3],[9,5,9,10],[21,1,21,5],[21,6,21,7],[21,8,21,9],[22,1,22,5],[22,6,22,7],[22,8,22,9],[19,1,19,5],[19,6,19,7],[19,8,19,9],[20,1,20,5],[20,6,20,7],[20,8,20,9],[25,1,25,5],[25,6,25,7],[25,8,25,9],[26,1,26,5],[26,6,26,7],[26,8,26,9],[23,1,23,5],[23,6,23,7],[23,8,23,9],[24,1,24,5],[24,6,24,7],[24,8,24,9],[29,1,29,5],[29,6,29,7],[29,8,29,9],[30,1,30,5],[30,6,30,7],[30,8,30,9],[27,1,27,5],[27,6,27,7],[27,8,27,9],[28,1,28,5],[28,6,28,7],[28,8,28,9],[33,1,33,5],[33,6,33,7],[33,8,33,9],[34,1,34,5],[34,6,34,7],[34,8,34,9],[31,1,31,5],[31,6,31,7],[31,8,31,9],[32,1,32,5],[32,6,32,7],[32,8,32,9],[37,1,37,5],[37,6,37,7],[37,8,37,9],[38,1,38,5],[38,6,38,7],[38,8,38,9],[35,1,35,5],[35,6,35,7],[35,8,35,9],[36,1,36,5],[36,6,36,7],[36,8,36,9],[41,1,41,5],[41,6,41,7],[41,8,41,9],[42,1,42,5],[42,6,42,7],[42,8,42,9],[39,1,39,5],[39,6,39,7],[39,8,39,9],[40,1,40,5],[40,6,40,7],[40,8,40,9],[45,1,45,5],[45,6,45,7],[45,8,45,9],[46,1,46,5],[46,6,46,7],[46,8,46,9],[43,1,43,5],[43,6,43,7],[43,8,43,9],[44,1,44,5],[44,6,44,7],[44,8,44,9],[49,0,49,5],[49,8,49,9],[51,0,51,2],[47,1,47,5],[47,6,47,7],[47,8,47,9],[48,1,48,5],[48,6,48,7],[48,8,48,9],[57,0,57,6],[57,8,57,9],[58,0,58,6],[58,8,58,9],[60,0,60,2],[60,6,60,8],[60,9,60,10],[52,0,52,12],[54,0,54,1],[54,8,55,9],[54,11,54,15],[55,0,55,5],[56,0,56,6],[56,8,56,9],[67,3,67,4],[67,6,67,8],[67,9,67,10],[67,12,67,13],[67,14,67,15],[60,11,60,12],[60,13,60,14],[61,0,62,1],[61,2,62,15],[65,0,65,15],[66,0,66,2],[66,3,66,4],[66,6,66,8],[66,9,66,10],[66,12,66,13],[71,12,71,13],[71,14,71,15],[74,8,74,10],[11,0,12,0],[70,6,70,7],[70,9,70,10],[71,0,71,2],[71,3,71,4],[71,5,71,9],[71,10,71,11],[69,0,69,1],[69,3,69,4],[69,6,69,8],[69,9,69,10],[69,12,69,13],[69,14,69,15],[68,0,68,2],[68,3,68,4],[68,6,68,8],[68,9,68,10],[68,12,68,13],[68,14,68,15],[66,14,66,15],[67,0,67,2]]}
[{"$f":"\"Northern California Conference Expense Report\" & IF($U$64=TRUE,\" (REVISED)\",\"\")","v":"Northern California Conference Expense Report"}]
["Email to: payroll@nccsda.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Per Diem Note:"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,"2026-04-01",null,null,"1) If you are away from home and have an overnight stay on either side of a day you qualify for per diem, choose an option with NT."]
[]
[{"$f":"IF(COUNTBLANK(A20:A49)=0,\" \",\"Your report is incomplete! Please select a short description from the drop-down list for every day of the month. \"&COUNTBLANK(A20:A49)&\" days in the first column are blank.\")","v":"Your report is incomplete! Please select a short description from the drop-down list for every day of the month. 30 days in the first column are blank."},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" IF(N5<>'MASTOR CONTROLS'!G3,\"Due \" & TEXT(DATE(1,MONTH(I20)+1,1),\"mmmm\") & \" 3rd.\",\"\")","v":"Due May 3rd."}]
[]
["Best way to contact:",null,null,null,null,null,null,null,null,null,null,null,null,"*Reimbursements are made for completed reports including original receipts with travel approval from ADCO or assigned job duties. Lodging must be documented with a folio."]
["Phone:",null,null,null,"Email:","enter email address here",null,null,null,null,null,null,null,null,null,null,"2) Spousal per diems are always taxable."]
["*Mileage cannot be reimbursed without both the location and reason for travel.",null,null,null,null,null,null,null,null,null,"** ADCO must approve Special Mileage."]
["Short Description","Mileage Activity and Location*",null,null,null,null,null,null,"Date",null,"Special Mileage**","Per Diem",null,null,"Air/Car/Gas/Transit    Other",null,null,"PD Tx","PD NTx","Per Diem","Ans: Per"]
[null,"Eg. \"Sacramento visit,\" \"Redding school board,\" etc.",null,null,null,null,"Budgeted Mileage",null,null,null,null,"Taxable","Non-Tax","Lodging*",null,null,null,{"$f":"$L$50","v":0},{"$f":"$M$50","v":0},"Totals","Diem"]
[]
["Worked"]
["Day Off"]
["Vacation"]
["Sick Day"]
["Holiday"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,N5,\"\")","v":"2026-04-01"},null,null,{"$f":"IF($U20>1,VLOOKUP($U20,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U20>1,VLOOKUP($U20,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,{"$f":"TEXT(I20,\"ddd\")","v":"Wed"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I20+1,\"\")","v":"2026-04-02"},null,null,{"$f":"IF($U21>1,VLOOKUP($U21,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U21>1,VLOOKUP($U21,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I21+1,\"\")","v":"2026-04-03"},null,null,{"$f":"IF($U22>1,VLOOKUP($U22,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U22>1,VLOOKUP($U22,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I22+1,\"\")","v":"2026-04-04"},null,null,{"$f":"IF($U23>1,VLOOKUP($U23,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U23>1,VLOOKUP($U23,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I23+1,\"\")","v":"2026-04-05"},null,null,{"$f":"IF($U24>1,VLOOKUP($U24,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U24>1,VLOOKUP($U24,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I24+1,\"\")","v":"2026-04-06"},null,null,{"$f":"IF($U25>1,VLOOKUP($U25,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U25>1,VLOOKUP($U25,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I25+1,\"\")","v":"2026-04-07"},null,null,{"$f":"IF($U26>1,VLOOKUP($U26,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U26>1,VLOOKUP($U26,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I26+1,\"\")","v":"2026-04-08"},null,null,{"$f":"IF($U27>1,VLOOKUP($U27,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U27>1,VLOOKUP($U27,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I27+1,\"\")","v":"2026-04-09"},null,null,{"$f":"IF($U28>1,VLOOKUP($U28,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U28>1,VLOOKUP($U28,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I28+1,\"\")","v":"2026-04-10"},null,null,{"$f":"IF($U29>1,VLOOKUP($U29,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U29>1,VLOOKUP($U29,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I29+1,\"\")","v":"2026-04-11"},null,null,{"$f":"IF($U30>1,VLOOKUP($U30,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U30>1,VLOOKUP($U30,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I30+1,\"\")","v":"2026-04-12"},null,null,{"$f":"IF($U31>1,VLOOKUP($U31,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U31>1,VLOOKUP($U31,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I31+1,\"\")","v":"2026-04-13"},null,null,{"$f":"IF($U32>1,VLOOKUP($U32,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U32>1,VLOOKUP($U32,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I32+1,\"\")","v":"2026-04-14"},null,null,{"$f":"IF($U33>1,VLOOKUP($U33,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U33>1,VLOOKUP($U33,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I33+1,\"\")","v":"2026-04-15"},null,null,{"$f":"IF($U34>1,VLOOKUP($U34,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U34>1,VLOOKUP($U34,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I34+1,\"\")","v":"2026-04-16"},null,null,{"$f":"IF($U35>1,VLOOKUP($U35,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U35>1,VLOOKUP($U35,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I35+1,\"\")","v":"2026-04-17"},null,null,{"$f":"IF($U36>1,VLOOKUP($U36,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U36>1,VLOOKUP($U36,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I36+1,\"\")","v":"2026-04-18"},null,null,{"$f":"IF($U37>1,VLOOKUP($U37,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U37>1,VLOOKUP($U37,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I37+1,\"\")","v":"2026-04-19"},null,null,{"$f":"IF($U38>1,VLOOKUP($U38,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U38>1,VLOOKUP($U38,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I38+1,\"\")","v":"2026-04-20"},null,null,{"$f":"IF($U39>1,VLOOKUP($U39,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U39>1,VLOOKUP($U39,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I39+1,\"\")","v":"2026-04-21"},null,null,{"$f":"IF($U40>1,VLOOKUP($U40,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U40>1,VLOOKUP($U40,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I40+1,\"\")","v":"2026-04-22"},null,null,{"$f":"IF($U41>1,VLOOKUP($U41,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U41>1,VLOOKUP($U41,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I41+1,\"\")","v":"2026-04-23"},null,null,{"$f":"IF($U42>1,VLOOKUP($U42,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U42>1,VLOOKUP($U42,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I42+1,\"\")","v":"2026-04-24"},null,null,{"$f":"IF($U43>1,VLOOKUP($U43,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U43>1,VLOOKUP($U43,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I43+1,\"\")","v":"2026-04-25"},null,null,{"$f":"IF($U44>1,VLOOKUP($U44,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U44>1,VLOOKUP($U44,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I44+1,\"\")","v":"2026-04-26"},null,null,{"$f":"IF($U45>1,VLOOKUP($U45,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U45>1,VLOOKUP($U45,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I45+1,\"\")","v":"2026-04-27"},null,null,{"$f":"IF($U46>1,VLOOKUP($U46,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U46>1,VLOOKUP($U46,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I46+1,\"\")","v":"2026-04-28"},null,null,{"$f":"IF($U47>1,VLOOKUP($U47,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U47>1,VLOOKUP($U47,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N6<>'MASTOR CONTROLS'!G4,I47+1,\"\")","v":"2026-04-29"},null,null,{"$f":"IF($U48>1,VLOOKUP($U48,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U48>1,VLOOKUP($U48,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N7<>'MASTOR CONTROLS'!G5,I48+1,\"\")","v":"2026-04-30"},null,null,{"$f":"IF($U49>1,VLOOKUP($U49,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U49>1,VLOOKUP($U49,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
["TOTALS",null,null,null,null,null,{"$f":"SUM(G20:G49)","v":0},{"$f":"SUM(H20:H49)","v":0},null,null,{"$f":"SUM(K20:K49)","v":0},0,0,0,0,0]
[]
["Office Staff Section",null,null,null,null,null,null,null,null,null,null,null,null,"Phone","Internet","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N53:O53)","v":0}]
[]
["Pastor's Section",null,null,null,null,null,null,null,"Professions of Faith",null,null,"Worship Service Attendance"]
["Church Name (Or Designated Pastor's Name)",null,null,null,null,null,null,"Baptisms",null,null,"Transfers","Week 1","Week 2","Week 3","Week 4","Week 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(V20:V49,\"Sat\")","v":4},{"$f":"COUNT(G57:P57)","v":0}]
[]
[]
[]
[]
["Comments & Notes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["OFFICE USE ONLY"]
["RTB) Travel Budget",null,null,null,null,null,"RTP) Per Diem Tx",null,null,null,null,null,"REM) Trav. Misc"]
["RGM) Non-Tax Miles",null,null,null,null,null,"RTN) Per Diem NTx",null,null,null,null,null,"RFR) Conv./Mtgs"]
["RTT) Special Miles",null,null,null,null,null,"RLN) Lodging"]
["RST) Spouse Trvl",null,null,null,null,null,"RTC)Car Rental"]
[null,null,null,null,null,null,"REA) Airfare Travel"]

{"sheet":"May","index":4,"n_rows":72,"n_cols":22,"rows_kept":72,"cut":false,"hidden":false,"merged":[[9,16,9,19],[10,0,10,9],[10,10,10,12],[0,0,0,15],[1,0,1,15],[3,1,3,9],[3,16,3,19],[4,1,4,9],[4,13,4,15],[4,16,8,19],[6,0,7,12],[6,13,6,15],[8,0,8,9],[11,1,11,5],[11,6,11,7],[11,8,12,9],[11,10,12,10],[11,11,11,12],[11,14,12,15],[12,1,12,5],[12,6,12,7],[8,13,10,15],[9,1,9,3],[9,5,9,10],[21,1,21,5],[21,6,21,7],[21,8,21,9],[22,1,22,5],[22,6,22,7],[22,8,22,9],[19,1,19,5],[19,6,19,7],[19,8,19,9],[20,1,20,5],[20,6,20,7],[20,8,20,9],[25,1,25,5],[25,6,25,7],[25,8,25,9],[26,1,26,5],[26,6,26,7],[26,8,26,9],[23,1,23,5],[23,6,23,7],[23,8,23,9],[24,1,24,5],[24,6,24,7],[24,8,24,9],[29,1,29,5],[29,6,29,7],[29,8,29,9],[30,1,30,5],[30,6,30,7],[30,8,30,9],[27,1,27,5],[27,6,27,7],[27,8,27,9],[28,1,28,5],[28,6,28,7],[28,8,28,9],[33,1,33,5],[33,6,33,7],[33,8,33,9],[34,1,34,5],[34,6,34,7],[34,8,34,9],[31,1,31,5],[31,6,31,7],[31,8,31,9],[32,1,32,5],[32,6,32,7],[32,8,32,9],[37,1,37,5],[37,6,37,7],[37,8,37,9],[38,1,38,5],[38,6,38,7],[38,8,38,9],[35,1,35,5],[35,6,35,7],[35,8,35,9],[36,1,36,5],[36,6,36,7],[36,8,36,9],[41,1,41,5],[41,6,41,7],[41,8,41,9],[42,1,42,5],[42,6,42,7],[42,8,42,9],[39,1,39,5],[39,6,39,7],[39,8,39,9],[40,1,40,5],[40,6,40,7],[40,8,40,9],[45,1,45,5],[45,6,45,7],[45,8,45,9],[46,1,46,5],[46,6,46,7],[46,8,46,9],[43,1,43,5],[43,6,43,7],[43,8,43,9],[44,1,44,5],[44,6,44,7],[44,8,44,9],[49,1,49,5],[49,6,49,7],[49,8,49,9],[50,0,50,5],[50,8,50,9],[52,0,52,2],[47,1,47,5],[47,6,47,7],[47,8,47,9],[48,1,48,5],[48,6,48,7],[48,8,48,9],[58,0,58,6],[58,8,58,9],[59,0,59,6],[59,8,59,9],[61,0,61,2],[61,6,61,8],[61,9,61,10],[53,0,53,12],[55,0,55,1],[55,8,56,9],[55,11,55,15],[56,0,56,5],[57,0,57,6],[57,8,57,9],[68,3,68,4],[68,6,68,8],[68,9,68,10],[68,12,68,13],[68,14,68,15],[61,11,61,12],[61,13,61,14],[62,0,63,1],[62,2,63,15],[66,0,66,15],[67,0,67,2],[67,3,67,4],[67,6,67,8],[67,9,67,10],[67,12,67,13],[72,12,72,13],[72,14,72,15],[75,8,75,10],[11,0,12,0],[71,6,71,7],[71,9,71,10],[72,0,72,2],[72,3,72,4],[72,5,72,9],[72,10,72,11],[70,0,70,1],[70,3,70,4],[70,6,70,8],[70,9,70,10],[70,12,70,13],[70,14,70,15],[69,0,69,2],[69,3,69,4],[69,6,69,8],[69,9,69,10],[69,12,69,13],[69,14,69,15],[67,14,67,15],[68,0,68,2]]}
[{"$f":"\"Northern California Conference Expense Report\" & IF($U$65=TRUE,\" (REVISED)\",\"\")","v":"Northern California Conference Expense Report"}]
["Email to: payroll@nccsda.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Per Diem Note:"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,"2026-05-01",null,null,"1) If you are away from home and have an overnight stay on either side of a day you qualify for per diem, choose an option with NT."]
[]
[{"$f":"IF(COUNTBLANK(A20:A50)=0,\" \",\"Your report is incomplete! Please select a short description from the drop-down list for every day of the month. \"&COUNTBLANK(A20:A50)&\" days in the first column are blank.\")","v":"Your report is incomplete! Please select a short description from the drop-down list for every day of the month. 31 days in the first column are blank."},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" IF(N5<>'MASTOR CONTROLS'!G3,\"Due \" & TEXT(DATE(1,MONTH(I20)+1,1),\"mmmm\") & \" 3rd.\",\"\")","v":"Due June 3rd."}]
[]
["Best way to contact:",null,null,null,null,null,null,null,null,null,null,null,null,"*Reimbursements are made for completed reports including original receipts with travel approval from ADCO or assigned job duties. Lodging must be documented with a folio."]
["Phone:",null,null,null,"Email:","enter email address here",null,null,null,null,null,null,null,null,null,null,"2) Spousal per diems are always taxable."]
["*Mileage cannot be reimbursed without both the location and reason for travel.",null,null,null,null,null,null,null,null,null,"** ADCO must approve Special Mileage."]
["Short Description","Mileage Activity and Location*",null,null,null,null,null,null,"Date",null,"Special Mileage**","Per Diem",null,null,"Air/Car/Gas/Transit    Other",null,null,"PD Tx","PD NTx","Per Diem","Ans: Per"]
[null,"Eg. \"Sacramento visit,\" \"Redding school board,\" etc.",null,null,null,null,"Budgeted Mileage",null,null,null,null,"Taxable","Non-Tax","Lodging*",null,null,null,{"$f":"$L$51","v":0},{"$f":"$M$51","v":0},"Totals","Diem"]
[]
["Worked"]
["Day Off"]
["Vacation"]
["Sick Day"]
["Holiday"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,N5,\"\")","v":"2026-05-01"},null,null,{"$f":"IF($U20>1,VLOOKUP($U20,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U20>1,VLOOKUP($U20,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,{"$f":"TEXT(I20,\"ddd\")","v":"Fri"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I20+1,\"\")","v":"2026-05-02"},null,null,{"$f":"IF($U21>1,VLOOKUP($U21,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U21>1,VLOOKUP($U21,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I21+1,\"\")","v":"2026-05-03"},null,null,{"$f":"IF($U22>1,VLOOKUP($U22,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U22>1,VLOOKUP($U22,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I22+1,\"\")","v":"2026-05-04"},null,null,{"$f":"IF($U23>1,VLOOKUP($U23,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U23>1,VLOOKUP($U23,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I23+1,\"\")","v":"2026-05-05"},null,null,{"$f":"IF($U24>1,VLOOKUP($U24,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U24>1,VLOOKUP($U24,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I24+1,\"\")","v":"2026-05-06"},null,null,{"$f":"IF($U25>1,VLOOKUP($U25,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U25>1,VLOOKUP($U25,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I25+1,\"\")","v":"2026-05-07"},null,null,{"$f":"IF($U26>1,VLOOKUP($U26,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U26>1,VLOOKUP($U26,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I26+1,\"\")","v":"2026-05-08"},null,null,{"$f":"IF($U27>1,VLOOKUP($U27,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U27>1,VLOOKUP($U27,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I27+1,\"\")","v":"2026-05-09"},null,null,{"$f":"IF($U28>1,VLOOKUP($U28,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U28>1,VLOOKUP($U28,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I28+1,\"\")","v":"2026-05-10"},null,null,{"$f":"IF($U29>1,VLOOKUP($U29,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U29>1,VLOOKUP($U29,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I29+1,\"\")","v":"2026-05-11"},null,null,{"$f":"IF($U30>1,VLOOKUP($U30,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U30>1,VLOOKUP($U30,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I30+1,\"\")","v":"2026-05-12"},null,null,{"$f":"IF($U31>1,VLOOKUP($U31,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U31>1,VLOOKUP($U31,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I31+1,\"\")","v":"2026-05-13"},null,null,{"$f":"IF($U32>1,VLOOKUP($U32,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U32>1,VLOOKUP($U32,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I32+1,\"\")","v":"2026-05-14"},null,null,{"$f":"IF($U33>1,VLOOKUP($U33,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U33>1,VLOOKUP($U33,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I33+1,\"\")","v":"2026-05-15"},null,null,{"$f":"IF($U34>1,VLOOKUP($U34,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U34>1,VLOOKUP($U34,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I34+1,\"\")","v":"2026-05-16"},null,null,{"$f":"IF($U35>1,VLOOKUP($U35,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U35>1,VLOOKUP($U35,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I35+1,\"\")","v":"2026-05-17"},null,null,{"$f":"IF($U36>1,VLOOKUP($U36,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U36>1,VLOOKUP($U36,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I36+1,\"\")","v":"2026-05-18"},null,null,{"$f":"IF($U37>1,VLOOKUP($U37,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U37>1,VLOOKUP($U37,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I37+1,\"\")","v":"2026-05-19"},null,null,{"$f":"IF($U38>1,VLOOKUP($U38,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U38>1,VLOOKUP($U38,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I38+1,\"\")","v":"2026-05-20"},null,null,{"$f":"IF($U39>1,VLOOKUP($U39,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U39>1,VLOOKUP($U39,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I39+1,\"\")","v":"2026-05-21"},null,null,{"$f":"IF($U40>1,VLOOKUP($U40,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U40>1,VLOOKUP($U40,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I40+1,\"\")","v":"2026-05-22"},null,null,{"$f":"IF($U41>1,VLOOKUP($U41,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U41>1,VLOOKUP($U41,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I41+1,\"\")","v":"2026-05-23"},null,null,{"$f":"IF($U42>1,VLOOKUP($U42,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U42>1,VLOOKUP($U42,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I42+1,\"\")","v":"2026-05-24"},null,null,{"$f":"IF($U43>1,VLOOKUP($U43,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U43>1,VLOOKUP($U43,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I43+1,\"\")","v":"2026-05-25"},null,null,{"$f":"IF($U44>1,VLOOKUP($U44,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U44>1,VLOOKUP($U44,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I44+1,\"\")","v":"2026-05-26"},null,null,{"$f":"IF($U45>1,VLOOKUP($U45,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U45>1,VLOOKUP($U45,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I45+1,\"\")","v":"2026-05-27"},null,null,{"$f":"IF($U46>1,VLOOKUP($U46,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U46>1,VLOOKUP($U46,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I46+1,\"\")","v":"2026-05-28"},null,null,{"$f":"IF($U47>1,VLOOKUP($U47,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U47>1,VLOOKUP($U47,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N6<>'MASTOR CONTROLS'!G4,I47+1,\"\")","v":"2026-05-29"},null,null,{"$f":"IF($U48>1,VLOOKUP($U48,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U48>1,VLOOKUP($U48,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N7<>'MASTOR CONTROLS'!G5,I48+1,\"\")","v":"2026-05-30"},null,null,{"$f":"IF($U49>1,VLOOKUP($U49,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U49>1,VLOOKUP($U49,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N8<>'MASTOR CONTROLS'!G6,I49+1,\"\")","v":"2026-05-31"},null,null,{"$f":"IF($U50>1,VLOOKUP($U50,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U50>1,VLOOKUP($U50,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
["TOTALS",null,null,null,null,null,{"$f":"SUM(G20:G50)","v":0},{"$f":"SUM(H20:H50)","v":0},null,null,{"$f":"SUM(K20:K50)","v":0},0,0,0,0,0]
[]
["Office Staff Section",null,null,null,null,null,null,null,null,null,null,null,null,"Phone","Internet","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N54:O54)","v":0}]
[]
["Pastor's Section",null,null,null,null,null,null,null,"Professions of Faith",null,null,"Worship Service Attendance"]
["Church Name (Or Designated Pastor's Name)",null,null,null,null,null,null,"Baptisms",null,null,"Transfers","Week 1","Week 2","Week 3","Week 4","Week 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(V20:V50,\"Sat\")","v":5},{"$f":"COUNT(G58:P58)","v":0}]
[]
[]
[]
[]
["Comments & Notes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["OFFICE USE ONLY"]
["RTB) Travel Budget",null,null,null,null,null,"RTP) Per Diem Tx",null,null,null,null,null,"REM) Trav. Misc"]
["RGM) Non-Tax Miles",null,null,null,null,null,"RTN) Per Diem NTx",null,null,null,null,null,"RFR) Conv./Mtgs"]
["RTT) Special Miles",null,null,null,null,null,"RLN) Lodging"]
["RST) Spouse Trvl",null,null,null,null,null,"RTC )Car Rental"]
[null,null,null,null,null,null,"REA) Airfare Travel"]

{"sheet":"Jun","index":5,"n_rows":71,"n_cols":22,"rows_kept":71,"cut":false,"hidden":false,"merged":[[9,16,9,19],[10,0,10,9],[10,10,10,12],[0,0,0,15],[1,0,1,15],[3,1,3,9],[3,16,3,19],[4,1,4,9],[4,13,4,15],[4,16,8,19],[6,0,7,12],[6,13,6,15],[8,0,8,9],[11,1,11,5],[11,6,11,7],[11,8,12,9],[11,10,12,10],[11,11,11,12],[11,14,12,15],[12,1,12,5],[12,6,12,7],[8,13,10,15],[9,1,9,3],[9,5,9,10],[21,1,21,5],[21,6,21,7],[21,8,21,9],[22,1,22,5],[22,6,22,7],[22,8,22,9],[19,1,19,5],[19,6,19,7],[19,8,19,9],[20,1,20,5],[20,6,20,7],[20,8,20,9],[25,1,25,5],[25,6,25,7],[25,8,25,9],[26,1,26,5],[26,6,26,7],[26,8,26,9],[23,1,23,5],[23,6,23,7],[23,8,23,9],[24,1,24,5],[24,6,24,7],[24,8,24,9],[29,1,29,5],[29,6,29,7],[29,8,29,9],[30,1,30,5],[30,6,30,7],[30,8,30,9],[27,1,27,5],[27,6,27,7],[27,8,27,9],[28,1,28,5],[28,6,28,7],[28,8,28,9],[33,1,33,5],[33,6,33,7],[33,8,33,9],[34,1,34,5],[34,6,34,7],[34,8,34,9],[31,1,31,5],[31,6,31,7],[31,8,31,9],[32,1,32,5],[32,6,32,7],[32,8,32,9],[37,1,37,5],[37,6,37,7],[37,8,37,9],[38,1,38,5],[38,6,38,7],[38,8,38,9],[35,1,35,5],[35,6,35,7],[35,8,35,9],[36,1,36,5],[36,6,36,7],[36,8,36,9],[41,1,41,5],[41,6,41,7],[41,8,41,9],[42,1,42,5],[42,6,42,7],[42,8,42,9],[39,1,39,5],[39,6,39,7],[39,8,39,9],[40,1,40,5],[40,6,40,7],[40,8,40,9],[45,1,45,5],[45,6,45,7],[45,8,45,9],[46,1,46,5],[46,6,46,7],[46,8,46,9],[43,1,43,5],[43,6,43,7],[43,8,43,9],[44,1,44,5],[44,6,44,7],[44,8,44,9],[49,0,49,5],[49,8,49,9],[51,0,51,2],[47,1,47,5],[47,6,47,7],[47,8,47,9],[48,1,48,5],[48,6,48,7],[48,8,48,9],[57,0,57,6],[57,8,57,9],[58,0,58,6],[58,8,58,9],[60,0,60,2],[60,6,60,8],[60,9,60,10],[52,0,52,12],[54,0,54,1],[54,8,55,9],[54,11,54,15],[55,0,55,5],[56,0,56,6],[56,8,56,9],[67,3,67,4],[67,6,67,8],[67,9,67,10],[67,12,67,13],[67,14,67,15],[60,11,60,12],[60,13,60,14],[61,0,62,1],[61,2,62,15],[65,0,65,15],[66,0,66,2],[66,3,66,4],[66,6,66,8],[66,9,66,10],[66,12,66,13],[71,12,71,13],[71,14,71,15],[74,8,74,10],[11,0,12,0],[70,6,70,7],[70,9,70,10],[71,0,71,2],[71,3,71,4],[71,5,71,9],[71,10,71,11],[69,0,69,1],[69,3,69,4],[69,6,69,8],[69,9,69,10],[69,12,69,13],[69,14,69,15],[68,0,68,2],[68,3,68,4],[68,6,68,8],[68,9,68,10],[68,12,68,13],[68,14,68,15],[66,14,66,15],[67,0,67,2]]}
[{"$f":"\"Northern California Conference Expense Report\" & IF($U$64=TRUE,\" (REVISED)\",\"\")","v":"Northern California Conference Expense Report"}]
["Email to: payroll@nccsda.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Per Diem Note:"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,"2026-06-01",null,null,"1) If you are away from home and have an overnight stay on either side of a day you qualify for per diem, choose an option with NT."]
[]
[{"$f":"IF(COUNTBLANK(A20:A49)=0,\" \",\"Your report is incomplete! Please select a short description from the drop-down list for every day of the month. \"&COUNTBLANK(A20:A49)&\" days in the first column are blank.\")","v":"Your report is incomplete! Please select a short description from the drop-down list for every day of the month. 30 days in the first column are blank."},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" IF(N5<>'MASTOR CONTROLS'!G3,\"Due \" & TEXT(DATE(1,MONTH(I20)+1,1),\"mmmm\") & \" 3rd.\",\"\")","v":"Due July 3rd."}]
[]
["Best way to contact:",null,null,null,null,null,null,null,null,null,null,null,null,"*Reimbursements are made for completed reports including original receipts with travel approval from ADCO or assigned job duties. Lodging must be documented with a folio."]
["Phone:",null,null,null,"Email:","enter email address here",null,null,null,null,null,null,null,null,null,null,"2) Spousal per diems are always taxable."]
["*Mileage cannot be reimbursed without both the location and reason for travel.",null,null,null,null,null,null,null,null,null,"** ADCO must approve Special Mileage."]
["Short Description","Mileage Activity and Location*",null,null,null,null,null,null,"Date",null,"Special Mileage**","Per Diem",null,null,"Air/Car/Gas/Transit    Other",null,null,"PD Tx","PD NTx","Per Diem","Ans: Per"]
[null,"Eg. \"Sacramento visit,\" \"Redding school board,\" etc.",null,null,null,null,"Budgeted Mileage",null,null,null,null,"Taxable","Non-Tax","Lodging*",null,null,null,{"$f":"$L$50","v":0},{"$f":"$M$50","v":0},"Totals","Diem"]
[]
["Worked"]
["Day Off"]
["Vacation"]
["Sick Day"]
["Holiday"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,N5,\"\")","v":"2026-06-01"},null,null,{"$f":"IF($U20>1,VLOOKUP($U20,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U20>1,VLOOKUP($U20,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,{"$f":"TEXT(I20,\"ddd\")","v":"Mon"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I20+1,\"\")","v":"2026-06-02"},null,null,{"$f":"IF($U21>1,VLOOKUP($U21,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U21>1,VLOOKUP($U21,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I21+1,\"\")","v":"2026-06-03"},null,null,{"$f":"IF($U22>1,VLOOKUP($U22,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U22>1,VLOOKUP($U22,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I22+1,\"\")","v":"2026-06-04"},null,null,{"$f":"IF($U23>1,VLOOKUP($U23,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U23>1,VLOOKUP($U23,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I23+1,\"\")","v":"2026-06-05"},null,null,{"$f":"IF($U24>1,VLOOKUP($U24,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U24>1,VLOOKUP($U24,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I24+1,\"\")","v":"2026-06-06"},null,null,{"$f":"IF($U25>1,VLOOKUP($U25,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U25>1,VLOOKUP($U25,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I25+1,\"\")","v":"2026-06-07"},null,null,{"$f":"IF($U26>1,VLOOKUP($U26,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U26>1,VLOOKUP($U26,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I26+1,\"\")","v":"2026-06-08"},null,null,{"$f":"IF($U27>1,VLOOKUP($U27,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U27>1,VLOOKUP($U27,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I27+1,\"\")","v":"2026-06-09"},null,null,{"$f":"IF($U28>1,VLOOKUP($U28,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U28>1,VLOOKUP($U28,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I28+1,\"\")","v":"2026-06-10"},null,null,{"$f":"IF($U29>1,VLOOKUP($U29,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U29>1,VLOOKUP($U29,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I29+1,\"\")","v":"2026-06-11"},null,null,{"$f":"IF($U30>1,VLOOKUP($U30,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U30>1,VLOOKUP($U30,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I30+1,\"\")","v":"2026-06-12"},null,null,{"$f":"IF($U31>1,VLOOKUP($U31,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U31>1,VLOOKUP($U31,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I31+1,\"\")","v":"2026-06-13"},null,null,{"$f":"IF($U32>1,VLOOKUP($U32,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U32>1,VLOOKUP($U32,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I32+1,\"\")","v":"2026-06-14"},null,null,{"$f":"IF($U33>1,VLOOKUP($U33,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U33>1,VLOOKUP($U33,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I33+1,\"\")","v":"2026-06-15"},null,null,{"$f":"IF($U34>1,VLOOKUP($U34,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U34>1,VLOOKUP($U34,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I34+1,\"\")","v":"2026-06-16"},null,null,{"$f":"IF($U35>1,VLOOKUP($U35,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U35>1,VLOOKUP($U35,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I35+1,\"\")","v":"2026-06-17"},null,null,{"$f":"IF($U36>1,VLOOKUP($U36,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U36>1,VLOOKUP($U36,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I36+1,\"\")","v":"2026-06-18"},null,null,{"$f":"IF($U37>1,VLOOKUP($U37,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U37>1,VLOOKUP($U37,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I37+1,\"\")","v":"2026-06-19"},null,null,{"$f":"IF($U38>1,VLOOKUP($U38,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U38>1,VLOOKUP($U38,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I38+1,\"\")","v":"2026-06-20"},null,null,{"$f":"IF($U39>1,VLOOKUP($U39,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U39>1,VLOOKUP($U39,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I39+1,\"\")","v":"2026-06-21"},null,null,{"$f":"IF($U40>1,VLOOKUP($U40,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U40>1,VLOOKUP($U40,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I40+1,\"\")","v":"2026-06-22"},null,null,{"$f":"IF($U41>1,VLOOKUP($U41,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U41>1,VLOOKUP($U41,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I41+1,\"\")","v":"2026-06-23"},null,null,{"$f":"IF($U42>1,VLOOKUP($U42,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U42>1,VLOOKUP($U42,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I42+1,\"\")","v":"2026-06-24"},null,null,{"$f":"IF($U43>1,VLOOKUP($U43,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U43>1,VLOOKUP($U43,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I43+1,\"\")","v":"2026-06-25"},null,null,{"$f":"IF($U44>1,VLOOKUP($U44,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U44>1,VLOOKUP($U44,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I44+1,\"\")","v":"2026-06-26"},null,null,{"$f":"IF($U45>1,VLOOKUP($U45,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U45>1,VLOOKUP($U45,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I45+1,\"\")","v":"2026-06-27"},null,null,{"$f":"IF($U46>1,VLOOKUP($U46,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U46>1,VLOOKUP($U46,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I46+1,\"\")","v":"2026-06-28"},null,null,{"$f":"IF($U47>1,VLOOKUP($U47,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U47>1,VLOOKUP($U47,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N6<>'MASTOR CONTROLS'!G4,I47+1,\"\")","v":"2026-06-29"},null,null,{"$f":"IF($U48>1,VLOOKUP($U48,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U48>1,VLOOKUP($U48,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N7<>'MASTOR CONTROLS'!G5,I48+1,\"\")","v":"2026-06-30"},null,null,{"$f":"IF($U49>1,VLOOKUP($U49,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U49>1,VLOOKUP($U49,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
["TOTALS",null,null,null,null,null,{"$f":"SUM(G20:G49)","v":0},{"$f":"SUM(H20:H49)","v":0},null,null,{"$f":"SUM(K20:K49)","v":0},0,0,0,0,0]
[]
["Office Staff Section",null,null,null,null,null,null,null,null,null,null,null,null,"Phone","Internet","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N53:O53)","v":0}]
[]
["Pastor's Section",null,null,null,null,null,null,null,"Professions of Faith",null,null,"Worship Service Attendance"]
["Church Name (Or Designated Pastor's Name)",null,null,null,null,null,null,"Baptisms",null,null,"Transfers","Week 1","Week 2","Week 3","Week 4","Week 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(V20:V49,\"Sat\")","v":4},{"$f":"COUNT(G57:P57)","v":0}]
[]
[]
[]
[]
["Comments & Notes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["OFFICE USE ONLY"]
["RTB) Travel Budget",null,null,null,null,null,"RTN) Per Diem Tx",null,null,null,null,null,"REM Trav. Misc"]
["RGM) Non-Tax Miles",null,null,null,null,null,"RTP) Per Diem NTx",null,null,null,null,null,"RFR) Conv./Mtgs"]
["RTT) Special Miles",null,null,null,null,null,"RLN) Lodging"]
["RST) Spouse Trvl",null,null,null,null,null,"RTC )Car Rental"]
[null,null,null,null,null,null,"REA) Airfare Travel"]

{"sheet":"Jul","index":6,"n_rows":72,"n_cols":22,"rows_kept":72,"cut":false,"hidden":false,"merged":[[8,13,10,15],[9,1,9,3],[9,5,9,10],[9,16,9,19],[10,0,10,9],[10,10,10,12],[0,0,0,15],[1,0,1,15],[3,1,3,9],[3,16,3,19],[4,1,4,9],[4,13,4,15],[4,16,8,19],[6,0,7,12],[6,13,6,15],[8,0,8,9],[11,14,12,15],[12,1,12,5],[12,6,12,7],[19,1,19,5],[19,6,19,7],[19,8,19,9],[11,0,12,0],[11,1,11,5],[11,6,11,7],[11,8,12,9],[11,10,12,10],[11,11,11,12],[22,1,22,5],[22,6,22,7],[22,8,22,9],[23,1,23,5],[23,6,23,7],[23,8,23,9],[20,1,20,5],[20,6,20,7],[20,8,20,9],[21,1,21,5],[21,6,21,7],[21,8,21,9],[26,1,26,5],[26,6,26,7],[26,8,26,9],[27,1,27,5],[27,6,27,7],[27,8,27,9],[24,1,24,5],[24,6,24,7],[24,8,24,9],[25,1,25,5],[25,6,25,7],[25,8,25,9],[30,1,30,5],[30,6,30,7],[30,8,30,9],[31,1,31,5],[31,6,31,7],[31,8,31,9],[28,1,28,5],[28,6,28,7],[28,8,28,9],[29,1,29,5],[29,6,29,7],[29,8,29,9],[34,1,34,5],[34,6,34,7],[34,8,34,9],[35,1,35,5],[35,6,35,7],[35,8,35,9],[32,1,32,5],[32,6,32,7],[32,8,32,9],[33,1,33,5],[33,6,33,7],[33,8,33,9],[38,1,38,5],[38,6,38,7],[38,8,38,9],[39,1,39,5],[39,6,39,7],[39,8,39,9],[36,1,36,5],[36,6,36,7],[36,8,36,9],[37,1,37,5],[37,6,37,7],[37,8,37,9],[42,1,42,5],[42,6,42,7],[42,8,42,9],[43,1,43,5],[43,6,43,7],[43,8,43,9],[40,1,40,5],[40,6,40,7],[40,8,40,9],[41,1,41,5],[41,6,41,7],[41,8,41,9],[46,1,46,5],[46,6,46,7],[46,8,46,9],[47,1,47,5],[47,6,47,7],[47,8,47,9],[44,1,44,5],[44,6,44,7],[44,8,44,9],[45,1,45,5],[45,6,45,7],[45,8,45,9],[50,0,50,5],[50,8,50,9],[52,0,52,2],[53,0,53,12],[55,0,55,1],[55,8,56,9],[55,11,55,15],[56,0,56,5],[48,1,48,5],[48,6,48,7],[48,8,48,9],[49,1,49,5],[49,6,49,7],[49,8,49,9],[61,0,61,2],[61,6,61,8],[61,9,61,10],[61,11,61,12],[61,13,61,14],[62,0,63,1],[62,2,63,15],[57,0,57,6],[57,8,57,9],[58,0,58,6],[58,8,58,9],[59,0,59,6],[59,8,59,9],[68,0,68,2],[68,3,68,4],[68,6,68,8],[68,9,68,10],[68,12,68,13],[68,14,68,15],[66,0,66,15],[67,0,67,2],[67,3,67,4],[67,6,67,8],[67,9,67,10],[67,12,67,13],[67,14,67,15],[70,0,70,1],[70,3,70,4],[70,6,70,8],[70,9,70,10],[70,12,70,13],[70,14,70,15],[69,0,69,2],[69,3,69,4],[69,6,69,8],[69,9,69,10],[69,12,69,13],[69,14,69,15],[72,12,72,13],[72,14,72,15],[75,8,75,10],[71,6,71,7],[71,9,71,10],[72,0,72,2],[72,3,72,4],[72,5,72,9],[72,10,72,11]]}
[{"$f":"\"Northern California Conference Expense Report\" & IF($U$65=TRUE,\" (REVISED)\",\"\")","v":"Northern California Conference Expense Report"}]
["Email to: payroll@nccsda.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Per Diem Note:"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,"2026-07-01",null,null,"1) If you are away from home and have an overnight stay on either side of a day you qualify for per diem, choose an option with NT."]
[]
[{"$f":"IF(COUNTBLANK(A20:A50)=0,\" \",\"Your report is incomplete! Please select a short description from the drop-down list for every day of the month. \"&COUNTBLANK(A20:A50)&\" days in the first column are blank.\")","v":"Your report is incomplete! Please select a short description from the drop-down list for every day of the month. 31 days in the first column are blank."},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" IF(N5<>'MASTOR CONTROLS'!G3,\"Due \" & TEXT(DATE(1,MONTH(I20)+1,1),\"mmmm\") & \" 3rd.\",\"\")","v":"Due August 3rd."}]
[]
["Best way to contact:",null,null,null,null,null,null,null,null,null,null,null,null,"*Reimbursements are made for completed reports including original receipts with travel approval from ADCO or assigned job duties. Lodging must be documented with a folio."]
["Phone:",null,null,null,"Email:","enter email address here",null,null,null,null,null,null,null,null,null,null,"2) Spousal per diems are always taxable."]
["*Mileage cannot be reimbursed without both the location and reason for travel.",null,null,null,null,null,null,null,null,null,"** ADCO must approve Special Mileage."]
["Short Description","Mileage Activity and Location*",null,null,null,null,null,null,"Date",null,"Special Mileage**","Per Diem",null,null,"Air/Car/Gas/Transit    Other",null,null,"PD Tx","PD NTx","Per Diem","Ans: Per"]
[null,"Eg. \"Sacramento visit,\" \"Redding school board,\" etc.",null,null,null,null,"Budgeted Mileage",null,null,null,null,"Taxable","Non-Tax","Lodging*",null,null,null,{"$f":"$L$51","v":0},{"$f":"$M$51","v":0},"Totals","Diem"]
[]
["Worked"]
["Day Off"]
["Vacation"]
["Sick Day"]
["Holiday"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,N5,\"\")","v":"2026-07-01"},null,null,{"$f":"IF($U20>1,VLOOKUP($U20,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U20>1,VLOOKUP($U20,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,{"$f":"TEXT(I20,\"ddd\")","v":"Wed"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I20+1,\"\")","v":"2026-07-02"},null,null,{"$f":"IF($U21>1,VLOOKUP($U21,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U21>1,VLOOKUP($U21,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I21+1,\"\")","v":"2026-07-03"},null,null,{"$f":"IF($U22>1,VLOOKUP($U22,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U22>1,VLOOKUP($U22,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I22+1,\"\")","v":"2026-07-04"},null,null,{"$f":"IF($U23>1,VLOOKUP($U23,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U23>1,VLOOKUP($U23,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I23+1,\"\")","v":"2026-07-05"},null,null,{"$f":"IF($U24>1,VLOOKUP($U24,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U24>1,VLOOKUP($U24,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I24+1,\"\")","v":"2026-07-06"},null,null,{"$f":"IF($U25>1,VLOOKUP($U25,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U25>1,VLOOKUP($U25,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I25+1,\"\")","v":"2026-07-07"},null,null,{"$f":"IF($U26>1,VLOOKUP($U26,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U26>1,VLOOKUP($U26,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I26+1,\"\")","v":"2026-07-08"},null,null,{"$f":"IF($U27>1,VLOOKUP($U27,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U27>1,VLOOKUP($U27,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I27+1,\"\")","v":"2026-07-09"},null,null,{"$f":"IF($U28>1,VLOOKUP($U28,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U28>1,VLOOKUP($U28,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I28+1,\"\")","v":"2026-07-10"},null,null,{"$f":"IF($U29>1,VLOOKUP($U29,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U29>1,VLOOKUP($U29,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I29+1,\"\")","v":"2026-07-11"},null,null,{"$f":"IF($U30>1,VLOOKUP($U30,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U30>1,VLOOKUP($U30,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I30+1,\"\")","v":"2026-07-12"},null,null,{"$f":"IF($U31>1,VLOOKUP($U31,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U31>1,VLOOKUP($U31,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I31+1,\"\")","v":"2026-07-13"},null,null,{"$f":"IF($U32>1,VLOOKUP($U32,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U32>1,VLOOKUP($U32,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I32+1,\"\")","v":"2026-07-14"},null,null,{"$f":"IF($U33>1,VLOOKUP($U33,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U33>1,VLOOKUP($U33,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I33+1,\"\")","v":"2026-07-15"},null,null,{"$f":"IF($U34>1,VLOOKUP($U34,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U34>1,VLOOKUP($U34,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I34+1,\"\")","v":"2026-07-16"},null,null,{"$f":"IF($U35>1,VLOOKUP($U35,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U35>1,VLOOKUP($U35,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I35+1,\"\")","v":"2026-07-17"},null,null,{"$f":"IF($U36>1,VLOOKUP($U36,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U36>1,VLOOKUP($U36,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I36+1,\"\")","v":"2026-07-18"},null,null,{"$f":"IF($U37>1,VLOOKUP($U37,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U37>1,VLOOKUP($U37,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I37+1,\"\")","v":"2026-07-19"},null,null,{"$f":"IF($U38>1,VLOOKUP($U38,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U38>1,VLOOKUP($U38,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I38+1,\"\")","v":"2026-07-20"},null,null,{"$f":"IF($U39>1,VLOOKUP($U39,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U39>1,VLOOKUP($U39,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I39+1,\"\")","v":"2026-07-21"},null,null,{"$f":"IF($U40>1,VLOOKUP($U40,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U40>1,VLOOKUP($U40,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I40+1,\"\")","v":"2026-07-22"},null,null,{"$f":"IF($U41>1,VLOOKUP($U41,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U41>1,VLOOKUP($U41,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I41+1,\"\")","v":"2026-07-23"},null,null,{"$f":"IF($U42>1,VLOOKUP($U42,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U42>1,VLOOKUP($U42,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I42+1,\"\")","v":"2026-07-24"},null,null,{"$f":"IF($U43>1,VLOOKUP($U43,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U43>1,VLOOKUP($U43,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I43+1,\"\")","v":"2026-07-25"},null,null,{"$f":"IF($U44>1,VLOOKUP($U44,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U44>1,VLOOKUP($U44,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I44+1,\"\")","v":"2026-07-26"},null,null,{"$f":"IF($U45>1,VLOOKUP($U45,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U45>1,VLOOKUP($U45,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I45+1,\"\")","v":"2026-07-27"},null,null,{"$f":"IF($U46>1,VLOOKUP($U46,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U46>1,VLOOKUP($U46,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I46+1,\"\")","v":"2026-07-28"},null,null,{"$f":"IF($U47>1,VLOOKUP($U47,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U47>1,VLOOKUP($U47,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N6<>'MASTOR CONTROLS'!G4,I47+1,\"\")","v":"2026-07-29"},null,null,{"$f":"IF($U48>1,VLOOKUP($U48,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U48>1,VLOOKUP($U48,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N7<>'MASTOR CONTROLS'!G5,I48+1,\"\")","v":"2026-07-30"},null,null,{"$f":"IF($U49>1,VLOOKUP($U49,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U49>1,VLOOKUP($U49,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N8<>'MASTOR CONTROLS'!G6,I49+1,\"\")","v":"2026-07-31"},null,null,{"$f":"IF($U50>1,VLOOKUP($U50,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U50>1,VLOOKUP($U50,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
["TOTALS",null,null,null,null,null,{"$f":"SUM(G20:G50)","v":0},{"$f":"SUM(H20:H50)","v":0},null,null,{"$f":"SUM(K20:K50)","v":0},0,0,0,0,0]
[]
["Office Staff Section",null,null,null,null,null,null,null,null,null,null,null,null,"Phone","Internet","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N54:O54)","v":0}]
[]
["Pastor's Section",null,null,null,null,null,null,null,"Professions of Faith",null,null,"Worship Service Attendance"]
["Church Name (Or Designated Pastor's Name)",null,null,null,null,null,null,"Baptisms",null,null,"Transfers","Week 1","Week 2","Week 3","Week 4","Week 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(V20:V50,\"Sat\")","v":4},{"$f":"COUNT(G58:P58)","v":0}]
[]
[]
[]
[]
["Comments & Notes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["OFFICE USE ONLY"]
["RTB) Travel Budget",null,null,null,null,null,"RTN) Per Diem Tx",null,null,null,null,null,"REM Trav. Misc"]
["RGM) Non-Tax Miles",null,null,null,null,null,"RTP) Per Diem NTx",null,null,null,null,null,"RFR) Conv./Mtgs"]
["RTT) Special Miles",null,null,null,null,null,"RLN) Lodging"]
["RST) Spouse Trvl",null,null,null,null,null,"RTC )Car Rental"]
[null,null,null,null,null,null,"REA) Airfare Travel"]

{"sheet":"Aug","index":7,"n_rows":72,"n_cols":22,"rows_kept":72,"cut":false,"hidden":false,"merged":[[8,13,10,15],[9,1,9,3],[9,5,9,10],[9,16,9,19],[10,0,10,9],[10,10,10,12],[0,0,0,15],[1,0,1,15],[3,1,3,9],[3,16,3,19],[4,1,4,9],[4,13,4,15],[4,16,8,19],[6,0,7,12],[6,13,6,15],[8,0,8,9],[11,14,12,15],[12,1,12,5],[12,6,12,7],[19,1,19,5],[19,6,19,7],[19,8,19,9],[11,0,12,0],[11,1,11,5],[11,6,11,7],[11,8,12,9],[11,10,12,10],[11,11,11,12],[22,1,22,5],[22,6,22,7],[22,8,22,9],[23,1,23,5],[23,6,23,7],[23,8,23,9],[20,1,20,5],[20,6,20,7],[20,8,20,9],[21,1,21,5],[21,6,21,7],[21,8,21,9],[26,1,26,5],[26,6,26,7],[26,8,26,9],[27,1,27,5],[27,6,27,7],[27,8,27,9],[24,1,24,5],[24,6,24,7],[24,8,24,9],[25,1,25,5],[25,6,25,7],[25,8,25,9],[30,1,30,5],[30,6,30,7],[30,8,30,9],[31,1,31,5],[31,6,31,7],[31,8,31,9],[28,1,28,5],[28,6,28,7],[28,8,28,9],[29,1,29,5],[29,6,29,7],[29,8,29,9],[34,1,34,5],[34,6,34,7],[34,8,34,9],[35,1,35,5],[35,6,35,7],[35,8,35,9],[32,1,32,5],[32,6,32,7],[32,8,32,9],[33,1,33,5],[33,6,33,7],[33,8,33,9],[38,1,38,5],[38,6,38,7],[38,8,38,9],[39,1,39,5],[39,6,39,7],[39,8,39,9],[36,1,36,5],[36,6,36,7],[36,8,36,9],[37,1,37,5],[37,6,37,7],[37,8,37,9],[42,1,42,5],[42,6,42,7],[42,8,42,9],[43,1,43,5],[43,6,43,7],[43,8,43,9],[40,1,40,5],[40,6,40,7],[40,8,40,9],[41,1,41,5],[41,6,41,7],[41,8,41,9],[46,1,46,5],[46,6,46,7],[46,8,46,9],[47,1,47,5],[47,6,47,7],[47,8,47,9],[44,1,44,5],[44,6,44,7],[44,8,44,9],[45,1,45,5],[45,6,45,7],[45,8,45,9],[50,0,50,5],[50,8,50,9],[52,0,52,2],[53,0,53,12],[55,0,55,1],[55,8,56,9],[55,11,55,15],[56,0,56,5],[48,1,48,5],[48,6,48,7],[48,8,48,9],[49,1,49,5],[49,6,49,7],[49,8,49,9],[61,0,61,2],[61,6,61,8],[61,9,61,10],[61,11,61,12],[61,13,61,14],[62,0,63,1],[62,2,63,15],[57,0,57,6],[57,8,57,9],[58,0,58,6],[58,8,58,9],[59,0,59,6],[59,8,59,9],[68,0,68,2],[68,3,68,4],[68,6,68,8],[68,9,68,10],[68,12,68,13],[68,14,68,15],[66,0,66,15],[67,0,67,2],[67,3,67,4],[67,6,67,8],[67,9,67,10],[67,12,67,13],[67,14,67,15],[70,0,70,1],[70,3,70,4],[70,6,70,8],[70,9,70,10],[70,12,70,13],[70,14,70,15],[69,0,69,2],[69,3,69,4],[69,6,69,8],[69,9,69,10],[69,12,69,13],[69,14,69,15],[72,12,72,13],[72,14,72,15],[75,8,75,10],[71,6,71,7],[71,9,71,10],[72,0,72,2],[72,3,72,4],[72,5,72,9],[72,10,72,11]]}
[{"$f":"\"Northern California Conference Expense Report\" & IF($U$65=TRUE,\" (REVISED)\",\"\")","v":"Northern California Conference Expense Report"}]
["Email to: payroll@nccsda.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Per Diem Note:"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,"2026-08-01",null,null,"1) If you are away from home and have an overnight stay on either side of a day you qualify for per diem, choose an option with NT."]
[]
[{"$f":"IF(COUNTBLANK(A20:A50)=0,\" \",\"Your report is incomplete! Please select a short description from the drop-down list for every day of the month. \"&COUNTBLANK(A20:A50)&\" days in the first column are blank.\")","v":"Your report is incomplete! Please select a short description from the drop-down list for every day of the month. 31 days in the first column are blank."},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" IF(N5<>'MASTOR CONTROLS'!G3,\"Due \" & TEXT(DATE(1,MONTH(I20)+1,1),\"mmmm\") & \" 3rd.\",\"\")","v":"Due September 3rd."}]
[]
["Best way to contact:",null,null,null,null,null,null,null,null,null,null,null,null,"*Reimbursements are made for completed reports including original receipts with travel approval from ADCO or assigned job duties. Lodging must be documented with a folio."]
["Phone:",null,null,null,"Email:","enter email address here",null,null,null,null,null,null,null,null,null,null,"2) Spousal per diems are always taxable."]
["*Mileage cannot be reimbursed without both the location and reason for travel.",null,null,null,null,null,null,null,null,null,"** ADCO must approve Special Mileage."]
["Short Description","Mileage Activity and Location*",null,null,null,null,null,null,"Date",null,"Special Mileage**","Per Diem",null,null,"Air/Car/Gas/Transit    Other",null,null,"PD Tx","PD NTx","Per Diem","Ans: Per"]
[null,"Eg. \"Sacramento visit,\" \"Redding school board,\" etc.",null,null,null,null,"Budgeted Mileage",null,null,null,null,"Taxable","Non-Tax","Lodging*",null,null,null,{"$f":"$L$51","v":0},{"$f":"$M$51","v":0},"Totals","Diem"]
[]
["Worked"]
["Day Off"]
["Vacation"]
["Sick Day"]
["Holiday"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,N5,\"\")","v":"2026-08-01"},null,null,{"$f":"IF($U20>1,VLOOKUP($U20,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U20>1,VLOOKUP($U20,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,{"$f":"TEXT(I20,\"ddd\")","v":"Sat"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I20+1,\"\")","v":"2026-08-02"},null,null,{"$f":"IF($U21>1,VLOOKUP($U21,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U21>1,VLOOKUP($U21,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I21+1,\"\")","v":"2026-08-03"},null,null,{"$f":"IF($U22>1,VLOOKUP($U22,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U22>1,VLOOKUP($U22,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I22+1,\"\")","v":"2026-08-04"},null,null,{"$f":"IF($U23>1,VLOOKUP($U23,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U23>1,VLOOKUP($U23,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I23+1,\"\")","v":"2026-08-05"},null,null,{"$f":"IF($U24>1,VLOOKUP($U24,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U24>1,VLOOKUP($U24,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I24+1,\"\")","v":"2026-08-06"},null,null,{"$f":"IF($U25>1,VLOOKUP($U25,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U25>1,VLOOKUP($U25,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I25+1,\"\")","v":"2026-08-07"},null,null,{"$f":"IF($U26>1,VLOOKUP($U26,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U26>1,VLOOKUP($U26,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I26+1,\"\")","v":"2026-08-08"},null,null,{"$f":"IF($U27>1,VLOOKUP($U27,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U27>1,VLOOKUP($U27,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I27+1,\"\")","v":"2026-08-09"},null,null,{"$f":"IF($U28>1,VLOOKUP($U28,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U28>1,VLOOKUP($U28,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I28+1,\"\")","v":"2026-08-10"},null,null,{"$f":"IF($U29>1,VLOOKUP($U29,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U29>1,VLOOKUP($U29,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I29+1,\"\")","v":"2026-08-11"},null,null,{"$f":"IF($U30>1,VLOOKUP($U30,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U30>1,VLOOKUP($U30,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I30+1,\"\")","v":"2026-08-12"},null,null,{"$f":"IF($U31>1,VLOOKUP($U31,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U31>1,VLOOKUP($U31,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I31+1,\"\")","v":"2026-08-13"},null,null,{"$f":"IF($U32>1,VLOOKUP($U32,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U32>1,VLOOKUP($U32,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I32+1,\"\")","v":"2026-08-14"},null,null,{"$f":"IF($U33>1,VLOOKUP($U33,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U33>1,VLOOKUP($U33,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I33+1,\"\")","v":"2026-08-15"},null,null,{"$f":"IF($U34>1,VLOOKUP($U34,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U34>1,VLOOKUP($U34,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I34+1,\"\")","v":"2026-08-16"},null,null,{"$f":"IF($U35>1,VLOOKUP($U35,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U35>1,VLOOKUP($U35,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I35+1,\"\")","v":"2026-08-17"},null,null,{"$f":"IF($U36>1,VLOOKUP($U36,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U36>1,VLOOKUP($U36,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I36+1,\"\")","v":"2026-08-18"},null,null,{"$f":"IF($U37>1,VLOOKUP($U37,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U37>1,VLOOKUP($U37,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I37+1,\"\")","v":"2026-08-19"},null,null,{"$f":"IF($U38>1,VLOOKUP($U38,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U38>1,VLOOKUP($U38,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I38+1,\"\")","v":"2026-08-20"},null,null,{"$f":"IF($U39>1,VLOOKUP($U39,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U39>1,VLOOKUP($U39,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I39+1,\"\")","v":"2026-08-21"},null,null,{"$f":"IF($U40>1,VLOOKUP($U40,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U40>1,VLOOKUP($U40,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I40+1,\"\")","v":"2026-08-22"},null,null,{"$f":"IF($U41>1,VLOOKUP($U41,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U41>1,VLOOKUP($U41,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I41+1,\"\")","v":"2026-08-23"},null,null,{"$f":"IF($U42>1,VLOOKUP($U42,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U42>1,VLOOKUP($U42,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I42+1,\"\")","v":"2026-08-24"},null,null,{"$f":"IF($U43>1,VLOOKUP($U43,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U43>1,VLOOKUP($U43,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I43+1,\"\")","v":"2026-08-25"},null,null,{"$f":"IF($U44>1,VLOOKUP($U44,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U44>1,VLOOKUP($U44,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I44+1,\"\")","v":"2026-08-26"},null,null,{"$f":"IF($U45>1,VLOOKUP($U45,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U45>1,VLOOKUP($U45,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I45+1,\"\")","v":"2026-08-27"},null,null,{"$f":"IF($U46>1,VLOOKUP($U46,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U46>1,VLOOKUP($U46,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I46+1,\"\")","v":"2026-08-28"},null,null,{"$f":"IF($U47>1,VLOOKUP($U47,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U47>1,VLOOKUP($U47,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N6<>'MASTOR CONTROLS'!G4,I47+1,\"\")","v":"2026-08-29"},null,null,{"$f":"IF($U48>1,VLOOKUP($U48,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U48>1,VLOOKUP($U48,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N7<>'MASTOR CONTROLS'!G5,I48+1,\"\")","v":"2026-08-30"},null,null,{"$f":"IF($U49>1,VLOOKUP($U49,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U49>1,VLOOKUP($U49,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N8<>'MASTOR CONTROLS'!G6,I49+1,\"\")","v":"2026-08-31"},null,null,{"$f":"IF($U50>1,VLOOKUP($U50,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U50>1,VLOOKUP($U50,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
["TOTALS",null,null,null,null,null,{"$f":"SUM(G20:G50)","v":0},{"$f":"SUM(H20:H50)","v":0},null,null,{"$f":"SUM(K20:K50)","v":0},0,0,0,0,0]
[]
["Office Staff Section",null,null,null,null,null,null,null,null,null,null,null,null,"Phone","Internet","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N54:O54)","v":0}]
[]
["Pastor's Section",null,null,null,null,null,null,null,"Professions of Faith",null,null,"Worship Service Attendance"]
["Church Name (Or Designated Pastor's Name)",null,null,null,null,null,null,"Baptisms",null,null,"Transfers","Week 1","Week 2","Week 3","Week 4","Week 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(V20:V50,\"Sat\")","v":5},{"$f":"COUNT(G58:P58)","v":0}]
[]
[]
[]
[]
["Comments & Notes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["OFFICE USE ONLY"]
["RTB) Travel Budget",null,null,null,null,null,"RTN) Per Diem Tx",null,null,null,null,null,"REM Trav. Misc"]
["RGM) Non-Tax Miles",null,null,null,null,null,"RTP) Per Diem NTx",null,null,null,null,null,"RFR) Conv./Mtgs"]
["RTT) Special Miles",null,null,null,null,null,"RLN) Lodging"]
["RST) Spouse Trvl",null,null,null,null,null,"RTC )Car Rental"]
[null,null,null,null,null,null,"REA) Airfare Travel"]

{"sheet":"Sep","index":8,"n_rows":71,"n_cols":22,"rows_kept":71,"cut":false,"hidden":false,"merged":[[8,13,10,15],[9,1,9,3],[9,5,9,10],[9,16,9,19],[10,0,10,9],[10,10,10,12],[0,0,0,15],[1,0,1,15],[3,1,3,9],[3,16,3,19],[4,1,4,9],[4,13,4,15],[4,16,8,19],[6,0,7,12],[6,13,6,15],[8,0,8,9],[11,14,12,15],[12,1,12,5],[12,6,12,7],[19,1,19,5],[19,6,19,7],[19,8,19,9],[11,0,12,0],[11,1,11,5],[11,6,11,7],[11,8,12,9],[11,10,12,10],[11,11,11,12],[22,1,22,5],[22,6,22,7],[22,8,22,9],[23,1,23,5],[23,6,23,7],[23,8,23,9],[20,1,20,5],[20,6,20,7],[20,8,20,9],[21,1,21,5],[21,6,21,7],[21,8,21,9],[26,1,26,5],[26,6,26,7],[26,8,26,9],[27,1,27,5],[27,6,27,7],[27,8,27,9],[24,1,24,5],[24,6,24,7],[24,8,24,9],[25,1,25,5],[25,6,25,7],[25,8,25,9],[30,1,30,5],[30,6,30,7],[30,8,30,9],[31,1,31,5],[31,6,31,7],[31,8,31,9],[28,1,28,5],[28,6,28,7],[28,8,28,9],[29,1,29,5],[29,6,29,7],[29,8,29,9],[34,1,34,5],[34,6,34,7],[34,8,34,9],[35,1,35,5],[35,6,35,7],[35,8,35,9],[32,1,32,5],[32,6,32,7],[32,8,32,9],[33,1,33,5],[33,6,33,7],[33,8,33,9],[38,1,38,5],[38,6,38,7],[38,8,38,9],[39,1,39,5],[39,6,39,7],[39,8,39,9],[36,1,36,5],[36,6,36,7],[36,8,36,9],[37,1,37,5],[37,6,37,7],[37,8,37,9],[42,1,42,5],[42,6,42,7],[42,8,42,9],[43,1,43,5],[43,6,43,7],[43,8,43,9],[40,1,40,5],[40,6,40,7],[40,8,40,9],[41,1,41,5],[41,6,41,7],[41,8,41,9],[46,1,46,5],[46,6,46,7],[46,8,46,9],[47,1,47,5],[47,6,47,7],[47,8,47,9],[44,1,44,5],[44,6,44,7],[44,8,44,9],[45,1,45,5],[45,6,45,7],[45,8,45,9],[49,0,49,5],[49,8,49,9],[51,0,51,2],[52,0,52,12],[54,0,54,1],[54,8,55,9],[54,11,54,15],[55,0,55,5],[48,1,48,5],[48,6,48,7],[48,8,48,9],[60,0,60,2],[60,6,60,8],[60,9,60,10],[60,11,60,12],[60,13,60,14],[61,0,62,1],[61,2,62,15],[56,0,56,6],[56,8,56,9],[57,0,57,6],[57,8,57,9],[58,0,58,6],[58,8,58,9],[67,0,67,2],[67,3,67,4],[67,6,67,8],[67,9,67,10],[67,12,67,13],[67,14,67,15],[65,0,65,15],[66,0,66,2],[66,3,66,4],[66,6,66,8],[66,9,66,10],[66,12,66,13],[66,14,66,15],[69,0,69,1],[69,3,69,4],[69,6,69,8],[69,9,69,10],[69,12,69,13],[69,14,69,15],[68,0,68,2],[68,3,68,4],[68,6,68,8],[68,9,68,10],[68,12,68,13],[68,14,68,15],[71,12,71,13],[71,14,71,15],[74,8,74,10],[70,6,70,7],[70,9,70,10],[71,0,71,2],[71,3,71,4],[71,5,71,9],[71,10,71,11]]}
[{"$f":"\"Northern California Conference Expense Report\" & IF($U$64=TRUE,\" (REVISED)\",\"\")","v":"Northern California Conference Expense Report"}]
["Email to: payroll@nccsda.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Per Diem Note:"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,"2026-09-01",null,null,"1) If you are away from home and have an overnight stay on either side of a day you qualify for per diem, choose an option with NT."]
[]
[{"$f":"IF(COUNTBLANK(A20:A49)=0,\" \",\"Your report is incomplete! Please select a short description from the drop-down list for every day of the month. \"&COUNTBLANK(A20:A49)&\" days in the first column are blank.\")","v":"Your report is incomplete! Please select a short description from the drop-down list for every day of the month. 30 days in the first column are blank."},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" IF(N5<>'MASTOR CONTROLS'!G3,\"Due \" & TEXT(DATE(1,MONTH(I20)+1,1),\"mmmm\") & \" 3rd.\",\"\")","v":"Due October 3rd."}]
[]
["Best way to contact:",null,null,null,null,null,null,null,null,null,null,null,null,"*Reimbursements are made for completed reports including original receipts with travel approval from ADCO or assigned job duties. Lodging must be documented with a folio."]
["Phone:",null,null,null,"Email:","enter email address here",null,null,null,null,null,null,null,null,null,null,"2) Spousal per diems are always taxable."]
["*Mileage cannot be reimbursed without both the location and reason for travel.",null,null,null,null,null,null,null,null,null,"** ADCO must approve Special Mileage."]
["Short Description","Mileage Activity and Location*",null,null,null,null,null,null,"Date",null,"Special Mileage**","Per Diem",null,null,"Air/Car/Gas/Transit    Other",null,null,"PD Tx","PD NTx","Per Diem","Ans: Per"]
[null,"Eg. \"Sacramento visit,\" \"Redding school board,\" etc.",null,null,null,null,"Budgeted Mileage",null,null,null,null,"Taxable","Non-Tax","Lodging*",null,null,null,{"$f":"$L$50","v":0},{"$f":"$M$50","v":0},"Totals","Diem"]
[]
["Worked"]
["Day Off"]
["Vacation"]
["Sick Day"]
["Holiday"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,N5,\"\")","v":"2026-09-01"},null,null,{"$f":"IF($U20>1,VLOOKUP($U20,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U20>1,VLOOKUP($U20,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,{"$f":"TEXT(I20,\"ddd\")","v":"Tue"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I20+1,\"\")","v":"2026-09-02"},null,null,{"$f":"IF($U21>1,VLOOKUP($U21,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U21>1,VLOOKUP($U21,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I21+1,\"\")","v":"2026-09-03"},null,null,{"$f":"IF($U22>1,VLOOKUP($U22,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U22>1,VLOOKUP($U22,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I22+1,\"\")","v":"2026-09-04"},null,null,{"$f":"IF($U23>1,VLOOKUP($U23,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U23>1,VLOOKUP($U23,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I23+1,\"\")","v":"2026-09-05"},null,null,{"$f":"IF($U24>1,VLOOKUP($U24,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U24>1,VLOOKUP($U24,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I24+1,\"\")","v":"2026-09-06"},null,null,{"$f":"IF($U25>1,VLOOKUP($U25,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U25>1,VLOOKUP($U25,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I25+1,\"\")","v":"2026-09-07"},null,null,{"$f":"IF($U26>1,VLOOKUP($U26,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U26>1,VLOOKUP($U26,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I26+1,\"\")","v":"2026-09-08"},null,null,{"$f":"IF($U27>1,VLOOKUP($U27,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U27>1,VLOOKUP($U27,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I27+1,\"\")","v":"2026-09-09"},null,null,{"$f":"IF($U28>1,VLOOKUP($U28,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U28>1,VLOOKUP($U28,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I28+1,\"\")","v":"2026-09-10"},null,null,{"$f":"IF($U29>1,VLOOKUP($U29,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U29>1,VLOOKUP($U29,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I29+1,\"\")","v":"2026-09-11"},null,null,{"$f":"IF($U30>1,VLOOKUP($U30,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U30>1,VLOOKUP($U30,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I30+1,\"\")","v":"2026-09-12"},null,null,{"$f":"IF($U31>1,VLOOKUP($U31,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U31>1,VLOOKUP($U31,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I31+1,\"\")","v":"2026-09-13"},null,null,{"$f":"IF($U32>1,VLOOKUP($U32,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U32>1,VLOOKUP($U32,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I32+1,\"\")","v":"2026-09-14"},null,null,{"$f":"IF($U33>1,VLOOKUP($U33,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U33>1,VLOOKUP($U33,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I33+1,\"\")","v":"2026-09-15"},null,null,{"$f":"IF($U34>1,VLOOKUP($U34,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U34>1,VLOOKUP($U34,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I34+1,\"\")","v":"2026-09-16"},null,null,{"$f":"IF($U35>1,VLOOKUP($U35,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U35>1,VLOOKUP($U35,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I35+1,\"\")","v":"2026-09-17"},null,null,{"$f":"IF($U36>1,VLOOKUP($U36,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U36>1,VLOOKUP($U36,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I36+1,\"\")","v":"2026-09-18"},null,null,{"$f":"IF($U37>1,VLOOKUP($U37,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U37>1,VLOOKUP($U37,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I37+1,\"\")","v":"2026-09-19"},null,null,{"$f":"IF($U38>1,VLOOKUP($U38,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U38>1,VLOOKUP($U38,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I38+1,\"\")","v":"2026-09-20"},null,null,{"$f":"IF($U39>1,VLOOKUP($U39,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U39>1,VLOOKUP($U39,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I39+1,\"\")","v":"2026-09-21"},null,null,{"$f":"IF($U40>1,VLOOKUP($U40,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U40>1,VLOOKUP($U40,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I40+1,\"\")","v":"2026-09-22"},null,null,{"$f":"IF($U41>1,VLOOKUP($U41,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U41>1,VLOOKUP($U41,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I41+1,\"\")","v":"2026-09-23"},null,null,{"$f":"IF($U42>1,VLOOKUP($U42,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U42>1,VLOOKUP($U42,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I42+1,\"\")","v":"2026-09-24"},null,null,{"$f":"IF($U43>1,VLOOKUP($U43,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U43>1,VLOOKUP($U43,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I43+1,\"\")","v":"2026-09-25"},null,null,{"$f":"IF($U44>1,VLOOKUP($U44,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U44>1,VLOOKUP($U44,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I44+1,\"\")","v":"2026-09-26"},null,null,{"$f":"IF($U45>1,VLOOKUP($U45,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U45>1,VLOOKUP($U45,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I45+1,\"\")","v":"2026-09-27"},null,null,{"$f":"IF($U46>1,VLOOKUP($U46,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U46>1,VLOOKUP($U46,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I46+1,\"\")","v":"2026-09-28"},null,null,{"$f":"IF($U47>1,VLOOKUP($U47,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U47>1,VLOOKUP($U47,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N6<>'MASTOR CONTROLS'!G4,I47+1,\"\")","v":"2026-09-29"},null,null,{"$f":"IF($U48>1,VLOOKUP($U48,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U48>1,VLOOKUP($U48,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N7<>'MASTOR CONTROLS'!G5,I48+1,\"\")","v":"2026-09-30"},null,null,{"$f":"IF($U49>1,VLOOKUP($U49,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U49>1,VLOOKUP($U49,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
["TOTALS",null,null,null,null,null,{"$f":"SUM(G20:G49)","v":0},{"$f":"SUM(H20:H49)","v":0},null,null,{"$f":"SUM(K20:K49)","v":0},0,0,0,0,0]
[]
["Office Staff Section",null,null,null,null,null,null,null,null,null,null,null,null,"Phone","Internet","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N53:O53)","v":0}]
[]
["Pastor's Section",null,null,null,null,null,null,null,"Professions of Faith",null,null,"Worship Service Attendance"]
["Church Name (Or Designated Pastor's Name)",null,null,null,null,null,null,"Baptisms",null,null,"Transfers","Week 1","Week 2","Week 3","Week 4","Week 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(V20:V49,\"Sat\")","v":4},{"$f":"COUNT(G57:P57)","v":0}]
[]
[]
[]
[]
["Comments & Notes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["OFFICE USE ONLY"]
["RTB) Travel Budget",null,null,null,null,null,"RTN) Per Diem Tx",null,null,null,null,null,"REM Trav. Misc"]
["RGM) Non-Tax Miles",null,null,null,null,null,"RTP) Per Diem NTx",null,null,null,null,null,"RFR) Conv./Mtgs"]
["RTT) Special Miles",null,null,null,null,null,"RLN) Lodging"]
["RST) Spouse Trvl",null,null,null,null,null,"RTC )Car Rental"]
[null,null,null,null,null,null,"REA) Airfare Travel"]

{"sheet":"Oct","index":9,"n_rows":72,"n_cols":22,"rows_kept":72,"cut":false,"hidden":false,"merged":[[8,13,10,15],[9,1,9,3],[9,5,9,10],[9,16,9,19],[10,0,10,9],[10,10,10,12],[0,0,0,15],[1,0,1,15],[3,1,3,9],[3,16,3,19],[4,1,4,9],[4,13,4,15],[4,16,8,19],[6,0,7,12],[6,13,6,15],[8,0,8,9],[11,14,12,15],[12,1,12,5],[12,6,12,7],[19,1,19,5],[19,6,19,7],[19,8,19,9],[11,0,12,0],[11,1,11,5],[11,6,11,7],[11,8,12,9],[11,10,12,10],[11,11,11,12],[22,1,22,5],[22,6,22,7],[22,8,22,9],[23,1,23,5],[23,6,23,7],[23,8,23,9],[20,1,20,5],[20,6,20,7],[20,8,20,9],[21,1,21,5],[21,6,21,7],[21,8,21,9],[26,1,26,5],[26,6,26,7],[26,8,26,9],[27,1,27,5],[27,6,27,7],[27,8,27,9],[24,1,24,5],[24,6,24,7],[24,8,24,9],[25,1,25,5],[25,6,25,7],[25,8,25,9],[30,1,30,5],[30,6,30,7],[30,8,30,9],[31,1,31,5],[31,6,31,7],[31,8,31,9],[28,1,28,5],[28,6,28,7],[28,8,28,9],[29,1,29,5],[29,6,29,7],[29,8,29,9],[34,1,34,5],[34,6,34,7],[34,8,34,9],[35,1,35,5],[35,6,35,7],[35,8,35,9],[32,1,32,5],[32,6,32,7],[32,8,32,9],[33,1,33,5],[33,6,33,7],[33,8,33,9],[38,1,38,5],[38,6,38,7],[38,8,38,9],[39,1,39,5],[39,6,39,7],[39,8,39,9],[36,1,36,5],[36,6,36,7],[36,8,36,9],[37,1,37,5],[37,6,37,7],[37,8,37,9],[42,1,42,5],[42,6,42,7],[42,8,42,9],[43,1,43,5],[43,6,43,7],[43,8,43,9],[40,1,40,5],[40,6,40,7],[40,8,40,9],[41,1,41,5],[41,6,41,7],[41,8,41,9],[46,1,46,5],[46,6,46,7],[46,8,46,9],[47,1,47,5],[47,6,47,7],[47,8,47,9],[44,1,44,5],[44,6,44,7],[44,8,44,9],[45,1,45,5],[45,6,45,7],[45,8,45,9],[50,0,50,5],[50,8,50,9],[52,0,52,2],[53,0,53,12],[55,0,55,1],[55,8,56,9],[55,11,55,15],[56,0,56,5],[48,1,48,5],[48,6,48,7],[48,8,48,9],[49,1,49,5],[49,6,49,7],[49,8,49,9],[61,0,61,2],[61,6,61,8],[61,9,61,10],[61,11,61,12],[61,13,61,14],[62,0,63,1],[62,2,63,15],[57,0,57,6],[57,8,57,9],[58,0,58,6],[58,8,58,9],[59,0,59,6],[59,8,59,9],[68,0,68,2],[68,3,68,4],[68,6,68,8],[68,9,68,10],[68,12,68,13],[68,14,68,15],[66,0,66,15],[67,0,67,2],[67,3,67,4],[67,6,67,8],[67,9,67,10],[67,12,67,13],[67,14,67,15],[70,0,70,1],[70,3,70,4],[70,6,70,8],[70,9,70,10],[70,12,70,13],[70,14,70,15],[69,0,69,2],[69,3,69,4],[69,6,69,8],[69,9,69,10],[69,12,69,13],[69,14,69,15],[72,12,72,13],[72,14,72,15],[75,8,75,10],[71,6,71,7],[71,9,71,10],[72,0,72,2],[72,3,72,4],[72,5,72,9],[72,10,72,11]]}
[{"$f":"\"Northern California Conference Expense Report\" & IF($U$65=TRUE,\" (REVISED)\",\"\")","v":"Northern California Conference Expense Report"}]
["Email to: payroll@nccsda.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Per Diem Note:"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,"2026-10-01",null,null,"1) If you are away from home and have an overnight stay on either side of a day you qualify for per diem, choose an option with NT."]
[]
[{"$f":"IF(COUNTBLANK(A20:A50)=0,\" \",\"Your report is incomplete! Please select a short description from the drop-down list for every day of the month. \"&COUNTBLANK(A20:A50)&\" days in the first column are blank.\")","v":"Your report is incomplete! Please select a short description from the drop-down list for every day of the month. 31 days in the first column are blank."},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" IF(N5<>'MASTOR CONTROLS'!G3,\"Due \" & TEXT(DATE(1,MONTH(I20)+1,1),\"mmmm\") & \" 3rd.\",\"\")","v":"Due November 3rd."}]
[]
["Best way to contact:",null,null,null,null,null,null,null,null,null,null,null,null,"*Reimbursements are made for completed reports including original receipts with travel approval from ADCO or assigned job duties. Lodging must be documented with a folio."]
["Phone:",null,null,null,"Email:","enter email address here",null,null,null,null,null,null,null,null,null,null,"2) Spousal per diems are always taxable."]
["*Mileage cannot be reimbursed without both the location and reason for travel.",null,null,null,null,null,null,null,null,null,"** ADCO must approve Special Mileage."]
["Short Description","Mileage Activity and Location*",null,null,null,null,null,null,"Date",null,"Special Mileage**","Per Diem",null,null,"Air/Car/Gas/Transit    Other",null,null,"PD Tx","PD NTx","Per Diem","Ans: Per"]
[null,"Eg. \"Sacramento visit,\" \"Redding school board,\" etc.",null,null,null,null,"Budgeted Mileage",null,null,null,null,"Taxable","Non-Tax","Lodging*",null,null,null,{"$f":"$L$51","v":0},{"$f":"$M$51","v":0},"Totals","Diem"]
[]
["Worked"]
["Day Off"]
["Vacation"]
["Sick Day"]
["Holiday"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,N5,\"\")","v":"2026-10-01"},null,null,{"$f":"IF($U20>1,VLOOKUP($U20,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U20>1,VLOOKUP($U20,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,{"$f":"TEXT(I20,\"ddd\")","v":"Thu"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I20+1,\"\")","v":"2026-10-02"},null,null,{"$f":"IF($U21>1,VLOOKUP($U21,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U21>1,VLOOKUP($U21,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I21+1,\"\")","v":"2026-10-03"},null,null,{"$f":"IF($U22>1,VLOOKUP($U22,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U22>1,VLOOKUP($U22,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I22+1,\"\")","v":"2026-10-04"},null,null,{"$f":"IF($U23>1,VLOOKUP($U23,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U23>1,VLOOKUP($U23,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I23+1,\"\")","v":"2026-10-05"},null,null,{"$f":"IF($U24>1,VLOOKUP($U24,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U24>1,VLOOKUP($U24,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I24+1,\"\")","v":"2026-10-06"},null,null,{"$f":"IF($U25>1,VLOOKUP($U25,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U25>1,VLOOKUP($U25,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I25+1,\"\")","v":"2026-10-07"},null,null,{"$f":"IF($U26>1,VLOOKUP($U26,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U26>1,VLOOKUP($U26,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I26+1,\"\")","v":"2026-10-08"},null,null,{"$f":"IF($U27>1,VLOOKUP($U27,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U27>1,VLOOKUP($U27,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I27+1,\"\")","v":"2026-10-09"},null,null,{"$f":"IF($U28>1,VLOOKUP($U28,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U28>1,VLOOKUP($U28,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I28+1,\"\")","v":"2026-10-10"},null,null,{"$f":"IF($U29>1,VLOOKUP($U29,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U29>1,VLOOKUP($U29,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I29+1,\"\")","v":"2026-10-11"},null,null,{"$f":"IF($U30>1,VLOOKUP($U30,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U30>1,VLOOKUP($U30,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I30+1,\"\")","v":"2026-10-12"},null,null,{"$f":"IF($U31>1,VLOOKUP($U31,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U31>1,VLOOKUP($U31,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I31+1,\"\")","v":"2026-10-13"},null,null,{"$f":"IF($U32>1,VLOOKUP($U32,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U32>1,VLOOKUP($U32,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I32+1,\"\")","v":"2026-10-14"},null,null,{"$f":"IF($U33>1,VLOOKUP($U33,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U33>1,VLOOKUP($U33,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I33+1,\"\")","v":"2026-10-15"},null,null,{"$f":"IF($U34>1,VLOOKUP($U34,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U34>1,VLOOKUP($U34,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I34+1,\"\")","v":"2026-10-16"},null,null,{"$f":"IF($U35>1,VLOOKUP($U35,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U35>1,VLOOKUP($U35,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I35+1,\"\")","v":"2026-10-17"},null,null,{"$f":"IF($U36>1,VLOOKUP($U36,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U36>1,VLOOKUP($U36,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I36+1,\"\")","v":"2026-10-18"},null,null,{"$f":"IF($U37>1,VLOOKUP($U37,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U37>1,VLOOKUP($U37,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I37+1,\"\")","v":"2026-10-19"},null,null,{"$f":"IF($U38>1,VLOOKUP($U38,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U38>1,VLOOKUP($U38,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I38+1,\"\")","v":"2026-10-20"},null,null,{"$f":"IF($U39>1,VLOOKUP($U39,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U39>1,VLOOKUP($U39,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I39+1,\"\")","v":"2026-10-21"},null,null,{"$f":"IF($U40>1,VLOOKUP($U40,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U40>1,VLOOKUP($U40,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I40+1,\"\")","v":"2026-10-22"},null,null,{"$f":"IF($U41>1,VLOOKUP($U41,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U41>1,VLOOKUP($U41,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I41+1,\"\")","v":"2026-10-23"},null,null,{"$f":"IF($U42>1,VLOOKUP($U42,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U42>1,VLOOKUP($U42,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I42+1,\"\")","v":"2026-10-24"},null,null,{"$f":"IF($U43>1,VLOOKUP($U43,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U43>1,VLOOKUP($U43,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I43+1,\"\")","v":"2026-10-25"},null,null,{"$f":"IF($U44>1,VLOOKUP($U44,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U44>1,VLOOKUP($U44,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I44+1,\"\")","v":"2026-10-26"},null,null,{"$f":"IF($U45>1,VLOOKUP($U45,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U45>1,VLOOKUP($U45,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I45+1,\"\")","v":"2026-10-27"},null,null,{"$f":"IF($U46>1,VLOOKUP($U46,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U46>1,VLOOKUP($U46,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I46+1,\"\")","v":"2026-10-28"},null,null,{"$f":"IF($U47>1,VLOOKUP($U47,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U47>1,VLOOKUP($U47,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N6<>'MASTOR CONTROLS'!G4,I47+1,\"\")","v":"2026-10-29"},null,null,{"$f":"IF($U48>1,VLOOKUP($U48,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U48>1,VLOOKUP($U48,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N7<>'MASTOR CONTROLS'!G5,I48+1,\"\")","v":"2026-10-30"},null,null,{"$f":"IF($U49>1,VLOOKUP($U49,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U49>1,VLOOKUP($U49,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N8<>'MASTOR CONTROLS'!G6,I49+1,\"\")","v":"2026-10-31"},null,null,{"$f":"IF($U50>1,VLOOKUP($U50,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U50>1,VLOOKUP($U50,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
["TOTALS",null,null,null,null,null,{"$f":"SUM(G20:G50)","v":0},{"$f":"SUM(H20:H50)","v":0},null,null,{"$f":"SUM(K20:K50)","v":0},0,0,0,0,0]
[]
["Office Staff Section",null,null,null,null,null,null,null,null,null,null,null,null,"Phone","Internet","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N54:O54)","v":0}]
[]
["Pastor's Section",null,null,null,null,null,null,null,"Professions of Faith",null,null,"Worship Service Attendance"]
["Church Name (Or Designated Pastor's Name)",null,null,null,null,null,null,"Baptisms",null,null,"Transfers","Week 1","Week 2","Week 3","Week 4","Week 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(V20:V50,\"Sat\")","v":5},{"$f":"COUNT(G58:P58)","v":0}]
[]
[]
[]
[]
["Comments & Notes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["OFFICE USE ONLY"]
["RTB) Travel Budget",null,null,null,null,null,"RTN) Per Diem Tx",null,null,null,null,null,"REM Trav. Misc"]
["RGM) Non-Tax Miles",null,null,null,null,null,"RTP) Per Diem NTx",null,null,null,null,null,"RFR) Conv./Mtgs"]
["RTT) Special Miles",null,null,null,null,null,"RLN) Lodging"]
["RST) Spouse Trvl",null,null,null,null,null,"RTC )Car Rental"]
[null,null,null,null,null,null,"REA) Airfare Travel"]

{"sheet":"Nov","index":10,"n_rows":71,"n_cols":22,"rows_kept":71,"cut":false,"hidden":false,"merged":[[8,13,10,15],[9,1,9,3],[9,5,9,10],[9,16,9,19],[10,0,10,9],[10,10,10,12],[0,0,0,15],[1,0,1,15],[3,1,3,9],[3,16,3,19],[4,1,4,9],[4,13,4,15],[4,16,8,19],[6,0,7,12],[6,13,6,15],[8,0,8,9],[11,14,12,15],[12,1,12,5],[12,6,12,7],[19,1,19,5],[19,6,19,7],[19,8,19,9],[11,0,12,0],[11,1,11,5],[11,6,11,7],[11,8,12,9],[11,10,12,10],[11,11,11,12],[22,1,22,5],[22,6,22,7],[22,8,22,9],[23,1,23,5],[23,6,23,7],[23,8,23,9],[20,1,20,5],[20,6,20,7],[20,8,20,9],[21,1,21,5],[21,6,21,7],[21,8,21,9],[26,1,26,5],[26,6,26,7],[26,8,26,9],[27,1,27,5],[27,6,27,7],[27,8,27,9],[24,1,24,5],[24,6,24,7],[24,8,24,9],[25,1,25,5],[25,6,25,7],[25,8,25,9],[30,1,30,5],[30,6,30,7],[30,8,30,9],[31,1,31,5],[31,6,31,7],[31,8,31,9],[28,1,28,5],[28,6,28,7],[28,8,28,9],[29,1,29,5],[29,6,29,7],[29,8,29,9],[34,1,34,5],[34,6,34,7],[34,8,34,9],[35,1,35,5],[35,6,35,7],[35,8,35,9],[32,1,32,5],[32,6,32,7],[32,8,32,9],[33,1,33,5],[33,6,33,7],[33,8,33,9],[38,1,38,5],[38,6,38,7],[38,8,38,9],[39,1,39,5],[39,6,39,7],[39,8,39,9],[36,1,36,5],[36,6,36,7],[36,8,36,9],[37,1,37,5],[37,6,37,7],[37,8,37,9],[42,1,42,5],[42,6,42,7],[42,8,42,9],[43,1,43,5],[43,6,43,7],[43,8,43,9],[40,1,40,5],[40,6,40,7],[40,8,40,9],[41,1,41,5],[41,6,41,7],[41,8,41,9],[46,1,46,5],[46,6,46,7],[46,8,46,9],[47,1,47,5],[47,6,47,7],[47,8,47,9],[44,1,44,5],[44,6,44,7],[44,8,44,9],[45,1,45,5],[45,6,45,7],[45,8,45,9],[49,0,49,5],[49,8,49,9],[51,0,51,2],[52,0,52,12],[54,0,54,1],[54,8,55,9],[54,11,54,15],[55,0,55,5],[48,1,48,5],[48,6,48,7],[48,8,48,9],[60,0,60,2],[60,6,60,8],[60,9,60,10],[60,11,60,12],[60,13,60,14],[61,0,62,1],[61,2,62,15],[56,0,56,6],[56,8,56,9],[57,0,57,6],[57,8,57,9],[58,0,58,6],[58,8,58,9],[67,0,67,2],[67,3,67,4],[67,6,67,8],[67,9,67,10],[67,12,67,13],[67,14,67,15],[65,0,65,15],[66,0,66,2],[66,3,66,4],[66,6,66,8],[66,9,66,10],[66,12,66,13],[66,14,66,15],[69,0,69,1],[69,3,69,4],[69,6,69,8],[69,9,69,10],[69,12,69,13],[69,14,69,15],[68,0,68,2],[68,3,68,4],[68,6,68,8],[68,9,68,10],[68,12,68,13],[68,14,68,15],[71,12,71,13],[71,14,71,15],[74,8,74,10],[70,6,70,7],[70,9,70,10],[71,0,71,2],[71,3,71,4],[71,5,71,9],[71,10,71,11]]}
[{"$f":"\"Northern California Conference Expense Report\" & IF($U$64=TRUE,\" (REVISED)\",\"\")","v":"Northern California Conference Expense Report"}]
["Email to: payroll@nccsda.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Per Diem Note:"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,"2026-11-01",null,null,"1) If you are away from home and have an overnight stay on either side of a day you qualify for per diem, choose an option with NT."]
[]
[{"$f":"IF(COUNTBLANK(A20:A49)=0,\" \",\"Your report is incomplete! Please select a short description from the drop-down list for every day of the month. \"&COUNTBLANK(A20:A49)&\" days in the first column are blank.\")","v":"Your report is incomplete! Please select a short description from the drop-down list for every day of the month. 30 days in the first column are blank."},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" IF(N5<>'MASTOR CONTROLS'!G3,\"Due \" & TEXT(DATE(1,MONTH(I20)+1,1),\"mmmm\") & \" 3rd.\",\"\")","v":"Due December 3rd."}]
[]
["Best way to contact:",null,null,null,null,null,null,null,null,null,null,null,null,"*Reimbursements are made for completed reports including original receipts with travel approval from ADCO or assigned job duties. Lodging must be documented with a folio."]
["Phone:",null,null,null,"Email:","enter email address here",null,null,null,null,null,null,null,null,null,null,"2) Spousal per diems are always taxable."]
["*Mileage cannot be reimbursed without both the location and reason for travel.",null,null,null,null,null,null,null,null,null,"** ADCO must approve Special Mileage."]
["Short Description","Mileage Activity and Location*",null,null,null,null,null,null,"Date",null,"Special Mileage**","Per Diem",null,null,"Air/Car/Gas/Transit    Other",null,null,"PD Tx","PD NTx","Per Diem","Ans: Per"]
[null,"Eg. \"Sacramento visit,\" \"Redding school board,\" etc.",null,null,null,null,"Budgeted Mileage",null,null,null,null,"Taxable","Non-Tax","Lodging*",null,null,null,{"$f":"$L$50","v":0},{"$f":"$M$50","v":0},"Totals","Diem"]
[]
["Worked"]
["Day Off"]
["Vacation"]
["Sick Day"]
["Holiday"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,N5,\"\")","v":"2026-11-01"},null,null,{"$f":"IF($U20>1,VLOOKUP($U20,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U20>1,VLOOKUP($U20,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,{"$f":"TEXT(I20,\"ddd\")","v":"Sun"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I20+1,\"\")","v":"2026-11-02"},null,null,{"$f":"IF($U21>1,VLOOKUP($U21,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U21>1,VLOOKUP($U21,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I21+1,\"\")","v":"2026-11-03"},null,null,{"$f":"IF($U22>1,VLOOKUP($U22,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U22>1,VLOOKUP($U22,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I22+1,\"\")","v":"2026-11-04"},null,null,{"$f":"IF($U23>1,VLOOKUP($U23,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U23>1,VLOOKUP($U23,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I23+1,\"\")","v":"2026-11-05"},null,null,{"$f":"IF($U24>1,VLOOKUP($U24,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U24>1,VLOOKUP($U24,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I24+1,\"\")","v":"2026-11-06"},null,null,{"$f":"IF($U25>1,VLOOKUP($U25,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U25>1,VLOOKUP($U25,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I25+1,\"\")","v":"2026-11-07"},null,null,{"$f":"IF($U26>1,VLOOKUP($U26,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U26>1,VLOOKUP($U26,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I26+1,\"\")","v":"2026-11-08"},null,null,{"$f":"IF($U27>1,VLOOKUP($U27,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U27>1,VLOOKUP($U27,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I27+1,\"\")","v":"2026-11-09"},null,null,{"$f":"IF($U28>1,VLOOKUP($U28,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U28>1,VLOOKUP($U28,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I28+1,\"\")","v":"2026-11-10"},null,null,{"$f":"IF($U29>1,VLOOKUP($U29,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U29>1,VLOOKUP($U29,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I29+1,\"\")","v":"2026-11-11"},null,null,{"$f":"IF($U30>1,VLOOKUP($U30,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U30>1,VLOOKUP($U30,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I30+1,\"\")","v":"2026-11-12"},null,null,{"$f":"IF($U31>1,VLOOKUP($U31,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U31>1,VLOOKUP($U31,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I31+1,\"\")","v":"2026-11-13"},null,null,{"$f":"IF($U32>1,VLOOKUP($U32,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U32>1,VLOOKUP($U32,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I32+1,\"\")","v":"2026-11-14"},null,null,{"$f":"IF($U33>1,VLOOKUP($U33,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U33>1,VLOOKUP($U33,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I33+1,\"\")","v":"2026-11-15"},null,null,{"$f":"IF($U34>1,VLOOKUP($U34,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U34>1,VLOOKUP($U34,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I34+1,\"\")","v":"2026-11-16"},null,null,{"$f":"IF($U35>1,VLOOKUP($U35,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U35>1,VLOOKUP($U35,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I35+1,\"\")","v":"2026-11-17"},null,null,{"$f":"IF($U36>1,VLOOKUP($U36,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U36>1,VLOOKUP($U36,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I36+1,\"\")","v":"2026-11-18"},null,null,{"$f":"IF($U37>1,VLOOKUP($U37,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U37>1,VLOOKUP($U37,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I37+1,\"\")","v":"2026-11-19"},null,null,{"$f":"IF($U38>1,VLOOKUP($U38,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U38>1,VLOOKUP($U38,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I38+1,\"\")","v":"2026-11-20"},null,null,{"$f":"IF($U39>1,VLOOKUP($U39,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U39>1,VLOOKUP($U39,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I39+1,\"\")","v":"2026-11-21"},null,null,{"$f":"IF($U40>1,VLOOKUP($U40,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U40>1,VLOOKUP($U40,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I40+1,\"\")","v":"2026-11-22"},null,null,{"$f":"IF($U41>1,VLOOKUP($U41,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U41>1,VLOOKUP($U41,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I41+1,\"\")","v":"2026-11-23"},null,null,{"$f":"IF($U42>1,VLOOKUP($U42,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U42>1,VLOOKUP($U42,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I42+1,\"\")","v":"2026-11-24"},null,null,{"$f":"IF($U43>1,VLOOKUP($U43,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U43>1,VLOOKUP($U43,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I43+1,\"\")","v":"2026-11-25"},null,null,{"$f":"IF($U44>1,VLOOKUP($U44,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U44>1,VLOOKUP($U44,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I44+1,\"\")","v":"2026-11-26"},null,null,{"$f":"IF($U45>1,VLOOKUP($U45,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U45>1,VLOOKUP($U45,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I45+1,\"\")","v":"2026-11-27"},null,null,{"$f":"IF($U46>1,VLOOKUP($U46,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U46>1,VLOOKUP($U46,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I46+1,\"\")","v":"2026-11-28"},null,null,{"$f":"IF($U47>1,VLOOKUP($U47,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U47>1,VLOOKUP($U47,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N6<>'MASTOR CONTROLS'!G4,I47+1,\"\")","v":"2026-11-29"},null,null,{"$f":"IF($U48>1,VLOOKUP($U48,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U48>1,VLOOKUP($U48,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N7<>'MASTOR CONTROLS'!G5,I48+1,\"\")","v":"2026-11-30"},null,null,{"$f":"IF($U49>1,VLOOKUP($U49,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U49>1,VLOOKUP($U49,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
["TOTALS",null,null,null,null,null,{"$f":"SUM(G20:G49)","v":0},{"$f":"SUM(H20:H49)","v":0},null,null,{"$f":"SUM(K20:K49)","v":0},0,0,0,0,0]
[]
["Office Staff Section",null,null,null,null,null,null,null,null,null,null,null,null,"Phone","Internet","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N53:O53)","v":0}]
[]
["Pastor's Section",null,null,null,null,null,null,null,"Professions of Faith",null,null,"Worship Service Attendance"]
["Church Name (Or Designated Pastor's Name)",null,null,null,null,null,null,"Baptisms",null,null,"Transfers","Week 1","Week 2","Week 3","Week 4","Week 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(V20:V49,\"Sat\")","v":4},{"$f":"COUNT(G57:P57)","v":0}]
[]
[]
[]
[]
["Comments & Notes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["OFFICE USE ONLY"]
["RTB) Travel Budget",null,null,null,null,null,"RTN) Per Diem Tx",null,null,null,null,null,"REM Trav. Misc"]
["RGM) Non-Tax Miles",null,null,null,null,null,"RTP) Per Diem NTx",null,null,null,null,null,"RFR) Conv./Mtgs"]
["RTT) Special Miles",null,null,null,null,null,"RLN) Lodging"]
["RST) Spouse Trvl",null,null,null,null,null,"RTC )Car Rental"]
[null,null,null,null,null,null,"REA) Airfare Travel"]

{"sheet":"Dec","index":11,"n_rows":72,"n_cols":22,"rows_kept":72,"cut":false,"hidden":false,"merged":[[8,13,10,15],[9,1,9,3],[9,5,9,10],[9,16,9,19],[10,0,10,9],[10,10,10,12],[0,0,0,15],[1,0,1,15],[3,1,3,9],[3,16,3,19],[4,1,4,9],[4,13,4,15],[4,16,8,19],[6,0,7,12],[6,13,6,15],[8,0,8,9],[11,14,12,15],[12,1,12,5],[12,6,12,7],[19,1,19,5],[19,6,19,7],[19,8,19,9],[11,0,12,0],[11,1,11,5],[11,6,11,7],[11,8,12,9],[11,10,12,10],[11,11,11,12],[22,1,22,5],[22,6,22,7],[22,8,22,9],[23,1,23,5],[23,6,23,7],[23,8,23,9],[20,1,20,5],[20,6,20,7],[20,8,20,9],[21,1,21,5],[21,6,21,7],[21,8,21,9],[26,1,26,5],[26,6,26,7],[26,8,26,9],[27,1,27,5],[27,6,27,7],[27,8,27,9],[24,1,24,5],[24,6,24,7],[24,8,24,9],[25,1,25,5],[25,6,25,7],[25,8,25,9],[30,1,30,5],[30,6,30,7],[30,8,30,9],[31,1,31,5],[31,6,31,7],[31,8,31,9],[28,1,28,5],[28,6,28,7],[28,8,28,9],[29,1,29,5],[29,6,29,7],[29,8,29,9],[34,1,34,5],[34,6,34,7],[34,8,34,9],[35,1,35,5],[35,6,35,7],[35,8,35,9],[32,1,32,5],[32,6,32,7],[32,8,32,9],[33,1,33,5],[33,6,33,7],[33,8,33,9],[38,1,38,5],[38,6,38,7],[38,8,38,9],[39,1,39,5],[39,6,39,7],[39,8,39,9],[36,1,36,5],[36,6,36,7],[36,8,36,9],[37,1,37,5],[37,6,37,7],[37,8,37,9],[42,1,42,5],[42,6,42,7],[42,8,42,9],[43,1,43,5],[43,6,43,7],[43,8,43,9],[40,1,40,5],[40,6,40,7],[40,8,40,9],[41,1,41,5],[41,6,41,7],[41,8,41,9],[46,1,46,5],[46,6,46,7],[46,8,46,9],[47,1,47,5],[47,6,47,7],[47,8,47,9],[44,1,44,5],[44,6,44,7],[44,8,44,9],[45,1,45,5],[45,6,45,7],[45,8,45,9],[50,0,50,5],[50,8,50,9],[52,0,52,2],[53,0,53,12],[55,0,55,1],[55,8,56,9],[55,11,55,15],[56,0,56,5],[48,1,48,5],[48,6,48,7],[48,8,48,9],[49,1,49,5],[49,6,49,7],[49,8,49,9],[61,0,61,2],[61,6,61,8],[61,9,61,10],[61,11,61,12],[61,13,61,14],[62,0,63,1],[62,2,63,15],[57,0,57,6],[57,8,57,9],[58,0,58,6],[58,8,58,9],[59,0,59,6],[59,8,59,9],[68,0,68,2],[68,3,68,4],[68,6,68,8],[68,9,68,10],[68,12,68,13],[68,14,68,15],[66,0,66,15],[67,0,67,2],[67,3,67,4],[67,6,67,8],[67,9,67,10],[67,12,67,13],[67,14,67,15],[70,0,70,1],[70,3,70,4],[70,6,70,8],[70,9,70,10],[70,12,70,13],[70,14,70,15],[69,0,69,2],[69,3,69,4],[69,6,69,8],[69,9,69,10],[69,12,69,13],[69,14,69,15],[72,12,72,13],[72,14,72,15],[75,8,75,10],[71,6,71,7],[71,9,71,10],[72,0,72,2],[72,3,72,4],[72,5,72,9],[72,10,72,11]]}
[{"$f":"\"Northern California Conference Expense Report\" & IF($U$65=TRUE,\" (REVISED)\",\"\")","v":"Northern California Conference Expense Report"}]
["Email to: payroll@nccsda.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Per Diem Note:"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,"2026-12-01",null,null,"1) If you are away from home and have an overnight stay on either side of a day you qualify for per diem, choose an option with NT."]
[]
[{"$f":"IF(COUNTBLANK(A20:A50)=0,\" \",\"Your report is incomplete! Please select a short description from the drop-down list for every day of the month. \"&COUNTBLANK(A20:A50)&\" days in the first column are blank.\")","v":"Your report is incomplete! Please select a short description from the drop-down list for every day of the month. 31 days in the first column are blank."},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" IF(N5<>'MASTOR CONTROLS'!G3,\"Due \" & TEXT(DATE(1,MONTH(I20)+1,1),\"mmmm\") & \" 3rd.\",\"\")","v":"Due January 3rd."}]
[]
["Best way to contact:",null,null,null,null,null,null,null,null,null,null,null,null,"*Reimbursements are made for completed reports including original receipts with travel approval from ADCO or assigned job duties. Lodging must be documented with a folio."]
["Phone:",null,null,null,"Email:","enter email address here",null,null,null,null,null,null,null,null,null,null,"2) Spousal per diems are always taxable."]
["*Mileage cannot be reimbursed without both the location and reason for travel.",null,null,null,null,null,null,null,null,null,"** ADCO must approve Special Mileage."]
["Short Description","Mileage Activity and Location*",null,null,null,null,null,null,"Date",null,"Special Mileage**","Per Diem",null,null,"Air/Car/Gas/Transit    Other",null,null,"PD Tx","PD NTx","Per Diem","Ans: Per"]
[null,"Eg. \"Sacramento visit,\" \"Redding school board,\" etc.",null,null,null,null,"Budgeted Mileage",null,null,null,null,"Taxable","Non-Tax","Lodging*",null,null,null,{"$f":"$L$51","v":0},{"$f":"$M$51","v":0},"Totals","Diem"]
[]
["Worked"]
["Day Off"]
["Vacation"]
["Sick Day"]
["Holiday"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,N5,\"\")","v":"2026-12-01"},null,null,{"$f":"IF($U20>1,VLOOKUP($U20,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U20>1,VLOOKUP($U20,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,{"$f":"TEXT(I20,\"ddd\")","v":"Tue"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I20+1,\"\")","v":"2026-12-02"},null,null,{"$f":"IF($U21>1,VLOOKUP($U21,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U21>1,VLOOKUP($U21,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I21+1,\"\")","v":"2026-12-03"},null,null,{"$f":"IF($U22>1,VLOOKUP($U22,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U22>1,VLOOKUP($U22,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I22+1,\"\")","v":"2026-12-04"},null,null,{"$f":"IF($U23>1,VLOOKUP($U23,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U23>1,VLOOKUP($U23,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I23+1,\"\")","v":"2026-12-05"},null,null,{"$f":"IF($U24>1,VLOOKUP($U24,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U24>1,VLOOKUP($U24,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I24+1,\"\")","v":"2026-12-06"},null,null,{"$f":"IF($U25>1,VLOOKUP($U25,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U25>1,VLOOKUP($U25,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I25+1,\"\")","v":"2026-12-07"},null,null,{"$f":"IF($U26>1,VLOOKUP($U26,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U26>1,VLOOKUP($U26,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I26+1,\"\")","v":"2026-12-08"},null,null,{"$f":"IF($U27>1,VLOOKUP($U27,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U27>1,VLOOKUP($U27,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I27+1,\"\")","v":"2026-12-09"},null,null,{"$f":"IF($U28>1,VLOOKUP($U28,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U28>1,VLOOKUP($U28,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I28+1,\"\")","v":"2026-12-10"},null,null,{"$f":"IF($U29>1,VLOOKUP($U29,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U29>1,VLOOKUP($U29,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I29+1,\"\")","v":"2026-12-11"},null,null,{"$f":"IF($U30>1,VLOOKUP($U30,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U30>1,VLOOKUP($U30,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I30+1,\"\")","v":"2026-12-12"},null,null,{"$f":"IF($U31>1,VLOOKUP($U31,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U31>1,VLOOKUP($U31,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I31+1,\"\")","v":"2026-12-13"},null,null,{"$f":"IF($U32>1,VLOOKUP($U32,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U32>1,VLOOKUP($U32,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I32+1,\"\")","v":"2026-12-14"},null,null,{"$f":"IF($U33>1,VLOOKUP($U33,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U33>1,VLOOKUP($U33,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I33+1,\"\")","v":"2026-12-15"},null,null,{"$f":"IF($U34>1,VLOOKUP($U34,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U34>1,VLOOKUP($U34,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I34+1,\"\")","v":"2026-12-16"},null,null,{"$f":"IF($U35>1,VLOOKUP($U35,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U35>1,VLOOKUP($U35,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I35+1,\"\")","v":"2026-12-17"},null,null,{"$f":"IF($U36>1,VLOOKUP($U36,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U36>1,VLOOKUP($U36,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I36+1,\"\")","v":"2026-12-18"},null,null,{"$f":"IF($U37>1,VLOOKUP($U37,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U37>1,VLOOKUP($U37,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I37+1,\"\")","v":"2026-12-19"},null,null,{"$f":"IF($U38>1,VLOOKUP($U38,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U38>1,VLOOKUP($U38,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I38+1,\"\")","v":"2026-12-20"},null,null,{"$f":"IF($U39>1,VLOOKUP($U39,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U39>1,VLOOKUP($U39,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I39+1,\"\")","v":"2026-12-21"},null,null,{"$f":"IF($U40>1,VLOOKUP($U40,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U40>1,VLOOKUP($U40,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I40+1,\"\")","v":"2026-12-22"},null,null,{"$f":"IF($U41>1,VLOOKUP($U41,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U41>1,VLOOKUP($U41,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I41+1,\"\")","v":"2026-12-23"},null,null,{"$f":"IF($U42>1,VLOOKUP($U42,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U42>1,VLOOKUP($U42,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I42+1,\"\")","v":"2026-12-24"},null,null,{"$f":"IF($U43>1,VLOOKUP($U43,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U43>1,VLOOKUP($U43,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I43+1,\"\")","v":"2026-12-25"},null,null,{"$f":"IF($U44>1,VLOOKUP($U44,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U44>1,VLOOKUP($U44,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Fri"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I44+1,\"\")","v":"2026-12-26"},null,null,{"$f":"IF($U45>1,VLOOKUP($U45,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U45>1,VLOOKUP($U45,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sat"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I45+1,\"\")","v":"2026-12-27"},null,null,{"$f":"IF($U46>1,VLOOKUP($U46,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U46>1,VLOOKUP($U46,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Sun"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N5<>'MASTOR CONTROLS'!G3,I46+1,\"\")","v":"2026-12-28"},null,null,{"$f":"IF($U47>1,VLOOKUP($U47,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U47>1,VLOOKUP($U47,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Mon"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N6<>'MASTOR CONTROLS'!G4,I47+1,\"\")","v":"2026-12-29"},null,null,{"$f":"IF($U48>1,VLOOKUP($U48,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U48>1,VLOOKUP($U48,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Tue"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N7<>'MASTOR CONTROLS'!G5,I48+1,\"\")","v":"2026-12-30"},null,null,{"$f":"IF($U49>1,VLOOKUP($U49,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U49>1,VLOOKUP($U49,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Wed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(N8<>'MASTOR CONTROLS'!G6,I49+1,\"\")","v":"2026-12-31"},null,null,{"$f":"IF($U50>1,VLOOKUP($U50,'MASTOR CONTROLS'!$A$3:$D$13,3,FALSE),\"\")","v":""},{"$f":"IF($U50>1,VLOOKUP($U50,'MASTOR CONTROLS'!$A$3:$D$13,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1,"Thu"]
["TOTALS",null,null,null,null,null,{"$f":"SUM(G20:G50)","v":0},{"$f":"SUM(H20:H50)","v":0},null,null,{"$f":"SUM(K20:K50)","v":0},0,0,0,0,0]
[]
["Office Staff Section",null,null,null,null,null,null,null,null,null,null,null,null,"Phone","Internet","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N54:O54)","v":0}]
[]
["Pastor's Section",null,null,null,null,null,null,null,"Professions of Faith",null,null,"Worship Service Attendance"]
["Church Name (Or Designated Pastor's Name)",null,null,null,null,null,null,"Baptisms",null,null,"Transfers","Week 1","Week 2","Week 3","Week 4","Week 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(V20:V50,\"Sat\")","v":4},{"$f":"COUNT(G58:P58)","v":0}]
[]
[]
[]
[]
["Comments & Notes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["OFFICE USE ONLY"]
["RTB) Travel Budget",null,null,null,null,null,"RTN) Per Diem Tx",null,null,null,null,null,"REM Trav. Misc"]
["RGM) Non-Tax Miles",null,null,null,null,null,"RTP) Per Diem NTx",null,null,null,null,null,"RFR) Conv./Mtgs"]
["RTT) Special Miles",null,null,null,null,null,"RLN) Lodging"]
["RST) Spouse Trvl",null,null,null,null,null,"RTC )Car Rental"]
[null,null,null,null,null,null,"REA) Airfare Travel"]

{"sheet":"Policy","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Instructions","index":13,"n_rows":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Instructions"]
[]
["Name, Address, Phone, and Email: Enter your Name, Address, Phone number, and email. If you have a change to your personal information please log in to APS Employee online and update it there. If we receive your report without a name, we cannot process it."]
[]
["Short Description: All employees must select a description for each and every day of every month, even days that were not worked. We use this column to update your vacation/sick balance. Select \"Worked\" on days that you worked. Select \"Day Off\" on days that you did not work and would not usually work (for example, an office employee who typically works Monday through Thursday would select \"Day Off\" for most Fridays, Sabbaths, or Sundays). Select \"Holiday\" if you did not work on a holiday that the conference considers a paid holiday (this list of holidays can be found on the payroll schedule at nccsda.com). Select \"Sick\" to use your sick leave, and select \"Vacation\" when you use your vacation leave. You can contact the payroll department at payroll@nccsda.com to check your vacation balance."]
[]
["Daily Activity Description: When reporting mileage, please enter a summary description of the type of work you did and the location. Examples would be \"Roseville visitation\" or \"Oakland funeral\". Do your best to be brief, since longer descriptions may not print correctly.  Do not include mileage for activities at your home church (e.g. Sabbath services). Only include activities that you are reporting for mileage - if you have a zoom meeting, for example, you do not need to list that in your activites."]
[]
["Per Diem: The note to the right of the lodging column describes what is non taxable (NT) and what isn't.  Select from the list provided and it will fill in the correct rates in the per diem columns. Per diem is taxable when your special activity/event does not include an overnight stay. Your spouse's per diem is always taxable. "]
["Choose \"Fully Entertained\" when you have been provided three meals (breakfast, lunch, and dinner)."]
[]
["Pastor's Section: All churches are required to submit the information requested in the Pastor's Section. "]
[]
["Comments: If you have any notes or comments that don't fit anywhere else just put them in this box. Please do not use abbreviations in your descriptions. We often do not know what your abbreviations mean, and this may delay processing your report. "]
[]
["Due Dates: Reports are due on the 3rd day of each month to be processed on the second payroll of the month. Late reports will be processed on the second payroll of the following month. For example, January reports are due on February 3rd, and will be paid on the second payroll of February; if we receive a January report too late to include it on the payroll, it will be added to the second payroll of March."]

{"sheet":"MASTOR CONTROLS","index":14,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":true,"merged":[[0,0,0,3],[0,5,0,8],[17,0,26,3]]}
["Per Diem Rates",null,null,null,null,"Date Controls"]
[null,null,null,null,null,null,null,null,{"$f":"IF(G2>1,VLOOKUP(G2,F3:I19,2),\"\")","v":""},{"$f":"IF(G2>1,VLOOKUP(G2,F3:I19,4),\"\")","v":""}]
[1,"Choose From…","TX","Non-TX",null,1,"Select Month"]
[2,"NT - 1 Meal",null,{"$f":"D5/2","v":30},null,2,"2026-01-01",null,{"$f":"G5-1","v":"2026-01-31"}]
[3,"NT - 2/3 Meals",null,60,null,3,{"$f":"DATE(YEAR(G4),MONTH(G4)+1,1)","v":"2026-02-01"},null,{"$f":"G6-1","v":"2026-02-28"}]
[4,"1 Meal ",{"$f":"ROUND(D4,0)","v":30},null,null,4,"2026-03-01",null,"2026-03-31"]
[5,"2/3 Meals",{"$f":"D5","v":60},null,null,5,"2026-04-01",null,"2026-04-30"]
[6,"U & Spouse 1 Meal",{"$f":"C9*0.5","v":45},null,null,6,"2026-05-01",null,"2026-05-31"]
[7,"U & Spouse 2/3 Meals",{"$f":"D4*3","v":90},null,null,7,"2026-06-01",null,"2026-06-30"]
[8,"NT - U & Spouse 1 Meal",{"$f":"ROUND(C8-D10,0)","v":15},{"$f":"ROUND(D4,0)","v":30},null,8,"2026-07-01",null,{"$f":"G14-1","v":"2026-07-31"}]
[9,"NT - U & Spouse 2/3 Meals",{"$f":"C9-D11","v":30},{"$f":"D5","v":60}]
[10,"Fully Entertained",{"$f":"D13","v":20}]
[11,"NT - Fully Entertained",null,20]
[null,null,null,null,null,9,{"$f":"DATE(YEAR(G10),MONTH(G10)+1,1)","v":"2026-08-01"},null,{"$f":"G16-1","v":"2026-08-31"}]
[]
[null,null,null,null,null,10,{"$f":"DATE(YEAR(G14),MONTH(G14)+1,1)","v":"2026-09-01"},null,"2026-09-30"]
[null,null,null,null,null,11,"2026-10-01",null,"2026-10-31"]
["INSTRUCTIONS:  Enter the correct value in the blue cell and the rest of that section will automatically adjust based on the value you have entered. The Date Controls value should be set to the first day of the year (ie \"1/1/2008\" for the year 2008). Fully Entertained - enter amount.",null,null,null,null,12,"2026-11-01",null,"2026-11-30"]
[null,null,null,null,null,13,"2026-12-01",null,"2026-12-31"]
[null,null,null,null,null,null,"2027-01-01"]