{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Expense Claim","Validations","Mileage Table","Instructions","Example"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Expense Claim","index":0,"n_rows":132,"n_cols":19,"rows_kept":132,"cut":false,"hidden":false,"merged":[[1,2,1,3],[53,1,55,1],[83,1,85,1],[86,1,88,1],[89,1,91,1],[92,1,94,1],[95,1,97,1],[56,1,58,1],[59,1,61,1],[62,1,64,1],[65,1,67,1],[68,1,70,1],[71,1,73,1],[74,1,76,1],[77,1,79,1],[80,1,82,1],[5,1,7,1],[8,1,10,1],[11,1,13,1],[14,1,16,1],[17,1,19,1],[20,1,22,1],[23,1,25,1],[26,1,28,1],[65,13,67,13],[65,6,67,6],[23,13,25,13],[20,3,22,4],[20,5,22,5],[20,6,22,6],[29,13,31,13],[26,13,28,13],[29,1,31,1],[32,1,34,1],[35,1,37,1],[38,1,40,1],[41,1,43,1],[44,1,46,1],[47,1,49,1],[50,1,52,1],[65,3,67,4],[65,5,67,5],[50,3,52,4],[35,3,37,4],[35,5,37,5],[50,2,51,2],[53,2,54,2],[56,2,57,2],[68,2,69,2],[71,2,72,2],[105,8,107,13],[103,10,103,11],[100,2,101,7],[92,13,94,13],[89,3,91,4],[89,5,91,5],[89,6,91,6],[89,13,91,13],[92,3,94,4],[92,5,94,5],[92,6,94,6],[100,10,100,11],[101,10,101,11],[102,10,102,11],[95,13,97,13],[95,3,97,4],[95,5,97,5],[95,6,97,6],[92,2,93,2],[92,7,93,7],[92,8,94,8],[80,13,82,13],[59,2,60,2],[62,2,63,2],[65,2,66,2],[41,2,42,2],[44,2,45,2],[47,2,48,2],[53,3,55,4],[38,2,39,2],[17,13,19,13],[50,6,52,6],[44,5,46,5],[62,6,64,6],[44,6,46,6],[53,5,55,5],[53,6,55,6],[50,8,52,8],[53,7,54,7],[53,8,55,8],[17,2,18,2],[32,2,33,2],[35,2,36,2],[35,7,36,7],[35,8,37,8],[20,2,21,2],[3,5,3,8],[3,11,3,12],[4,9,4,10],[32,5,34,5],[32,6,34,6],[17,7,18,7],[17,8,19,8],[17,3,19,4],[17,5,19,5],[17,6,19,6],[29,7,30,7],[29,8,31,8],[32,7,33,7],[32,8,34,8],[20,7,21,7],[20,8,22,8],[29,6,31,6],[5,13,7,13],[5,6,7,6],[8,13,10,13],[11,3,13,4],[11,5,13,5],[11,6,13,6],[11,13,13,13],[8,3,10,4],[14,13,16,13],[14,3,16,4],[14,5,16,5],[14,6,16,6],[8,6,10,6],[86,13,88,13],[83,3,85,4],[83,5,85,5],[83,6,85,6],[5,7,6,7],[32,13,34,13],[62,13,64,13],[59,3,61,4],[59,13,61,13],[56,13,58,13],[44,13,46,13],[68,6,70,6],[47,6,49,6],[83,13,85,13],[41,7,42,7],[41,8,43,8],[44,7,45,7],[44,8,46,8],[47,7,48,7],[47,8,49,8],[50,7,51,7],[65,7,66,7],[65,8,67,8],[68,7,69,7],[77,13,79,13],[80,3,82,4],[80,5,82,5],[80,6,82,6],[35,13,37,13],[50,13,52,13],[56,7,57,7],[56,8,58,8],[59,7,60,7],[59,8,61,8],[62,7,63,7],[68,3,70,4],[68,5,70,5],[62,3,64,4],[47,13,49,13],[68,13,70,13],[35,6,37,6],[47,3,49,4],[62,5,64,5],[44,3,46,4],[38,7,39,7],[53,13,55,13],[38,13,40,13],[62,8,64,8],[0,7,0,8],[1,4,1,8],[74,13,76,13],[71,3,73,4],[71,5,73,5],[71,6,73,6],[71,13,73,13],[74,3,76,4],[74,5,76,5],[74,6,76,6],[32,3,34,4],[41,13,43,13],[38,3,40,4],[38,5,40,5],[0,3,0,5],[56,3,58,4],[56,5,58,5],[20,13,22,13],[5,5,7,5],[4,3,4,4],[41,3,43,4],[8,5,10,5],[5,3,7,4],[23,3,25,4],[5,2,6,2],[5,8,7,8],[8,2,9,2],[8,7,9,7],[8,8,10,8],[11,2,12,2],[11,7,12,7],[11,8,13,8],[14,2,15,2],[14,7,15,7],[14,8,16,8],[23,2,24,2],[23,7,24,7],[23,8,25,8],[26,2,27,2],[26,7,27,7],[26,8,28,8],[23,5,25,5],[26,3,28,4],[26,5,28,5],[23,6,25,6],[26,6,28,6],[38,8,40,8],[29,3,31,4],[29,2,30,2],[71,7,72,7],[71,8,73,8],[74,2,75,2],[74,7,75,7],[74,8,76,8],[77,2,78,2],[77,7,78,7],[77,8,79,8],[77,3,79,4],[77,5,79,5],[77,6,79,6],[68,8,70,8],[41,5,43,5],[41,6,43,6],[47,5,49,5],[38,6,40,6],[29,5,31,5],[59,5,61,5],[59,6,61,6],[56,6,58,6],[50,5,52,5],[80,2,81,2],[80,7,81,7],[80,8,82,8],[95,2,96,2],[95,7,96,7],[95,8,97,8],[83,2,84,2],[83,7,84,7],[83,8,85,8],[86,2,87,2],[86,7,87,7],[86,8,88,8],[89,2,90,2],[89,7,90,7],[89,8,91,8],[86,3,88,4],[86,5,88,5],[86,6,88,6]]}
[null,null,"Name",null,null,null,"Employee ID",null,null,null,null,null,"Fiscal Year","2024-2025"]
[null,null,"Mail check to",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N99=SUBTOTAL(109,N6:N98),\" \",\"Rows with data are hidden!\")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Form expired. Mileage rate not valid. Download new form.\",\" \")","v":" "}]
[null,null,"Date",null,null,"Personal vehicle used",null,null,null,null,null,"Other out-of-pocket"]
[null,null,"use format mm/dd/yy\n","Purpose for expense\n(reason or event)",null,"From ","To","Miles","Amount","Meals ",null,"Description","Amount","Line Total"]
[1,1,null,null,null,null,null,null,{"$f":"IF(H6=0,0,IF(ISBLANK(C6),0,IF(ISBLANK(D6),\"Enter Purpose\",IF(OR(ISBLANK(F6),ISBLANK(G6)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H6*MID(H8,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I6+K6+K7+K8+M6+M7+M8)=0,0,IF(OR(ISBLANK(C6),C6=0),\"Enter Date\",IF(ISBLANK(D6),\"Enter purpose\",IF(AND(M6>0,ISBLANK(L6)),\"Enter description\",IF(AND(M7>0,ISBLANK(L7)),\"Enter description\",IF(AND(M8>0,ISBLANK(L8)),\"Enter description\",+I6+K6+K7+K8+M6+M7+M8))))))","v":0}]
[1,null,null,null,null,null,null,null,null,"Lunch"]
[1,null,{"$f":"IF(AND(ISBLANK(C6),C6=0),\" \",TEXT(WEEKDAY(C6),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H6),H6=0),\" \",\"x \"&VLOOKUP($C6,$P$10:$R$14,3))","v":" "},null,"Dinner",null,null,null,null,null,"Mileage period",null,"(Rates updated)","2025-01-06"]
[1,2,null,null,null,null,null,null,{"$f":"IF(H9=0,0,IF(ISBLANK(C9),0,IF(ISBLANK(D9),\"Enter Purpose\",IF(OR(ISBLANK(F9),ISBLANK(G9)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H9*MID(H11,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I9+K9+K10+K11+M9+M10+M11)=0,0,IF(OR(ISBLANK(C9),C9=0),\"Enter Date\",IF(ISBLANK(D9),\"Enter purpose\",IF(AND(M9>0,ISBLANK(L9)),\"Enter description\",IF(AND(M10>0,ISBLANK(L10)),\"Enter description\",IF(AND(M11>0,ISBLANK(L11)),\"Enter description\",+I9+K9+K10+K11+M9+M10+M11))))))","v":0},null,"From","To","Rate","Miles "]
[1,null,null,null,null,null,null,null,null,"Lunch",null,null,null,null,null,{"$f":"DATE(LEFT($N$1,4)-1,7,1)","v":"2023-07-01"},{"$f":"DATE(LEFT($N$1,4)-1,12,31)","v":"2023-12-31"},{"$f":"VLOOKUP(P10,P116:R132,3,0)","v":0.65500000000000003},{"$f":"SUMIFS($H$6:$H$98,$C$6:$C$98,\">=\"&$P10,$C$6:$C$98,\"<=\"&$Q10)","v":0}]
[1,null,{"$f":"IF(AND(ISBLANK(C9),C9=0),\" \",TEXT(WEEKDAY(C9),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H9),H9=0),\" \",\"x \"&VLOOKUP($C9,$P$10:$R$14,3))","v":" "},null,"Dinner",null,null,null,null,null,{"$f":"DATE(LEFT($N$1,4),1,1)","v":"2024-01-01"},{"$f":"DATE(LEFT($N$1,4),6,30)","v":"2024-06-30"},{"$f":"VLOOKUP(P11,P117:R133,3,0)","v":0.67},{"$f":"SUMIFS($H$6:$H$98,$C$6:$C$98,\">=\"&$P11,$C$6:$C$98,\"<=\"&$Q11)","v":0}]
[1,3,null,null,null,null,null,null,{"$f":"IF(H12=0,0,IF(ISBLANK(C12),0,IF(ISBLANK(D12),\"Enter Purpose\",IF(OR(ISBLANK(F12),ISBLANK(G12)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H12*MID(H14,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I12+K12+K13+K14+M12+M13+M14)=0,0,IF(OR(ISBLANK(C12),C12=0),\"Enter Date\",IF(ISBLANK(D12),\"Enter purpose\",IF(AND(M12>0,ISBLANK(L12)),\"Enter description\",IF(AND(M13>0,ISBLANK(L13)),\"Enter description\",IF(AND(M14>0,ISBLANK(L14)),\"Enter description\",+I12+K12+K13+K14+M12+M13+M14))))))","v":0},null,{"$f":"DATE(LEFT($N$1,4),7,1)","v":"2024-07-01"},{"$f":"DATE(LEFT($N$1,4),12,31)","v":"2024-12-31"},{"$f":"VLOOKUP(P12,P118:R134,3,0)","v":0.67},0]
[1,null,null,null,null,null,null,null,null,"Lunch",null,null,null,null,null,{"$f":"DATE(RIGHT($N$1,4),1,1)","v":"2025-01-01"},{"$f":"DATE(RIGHT($N$1,4),6,30)","v":"2025-06-30"},0.7,0]
[1,null,{"$f":"IF(AND(ISBLANK(C12),C12=0),\" \",TEXT(WEEKDAY(C12),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H12),H12=0),\" \",\"x \"&VLOOKUP($C12,$P$10:$R$14,3))","v":" "},null,"Dinner",null,null,null,null,null,{"$f":"DATE(RIGHT($N$1,4),7,1)","v":"2025-07-01"},{"$f":"DATE(RIGHT($N$1,4),12,31)","v":"2025-12-31"},{"$f":"VLOOKUP(P14,P120:R136,3,0)","v":0},0]
[1,4,null,null,null,null,null,null,{"$f":"IF(H15=0,0,IF(ISBLANK(C15),0,IF(ISBLANK(D15),\"Enter Purpose\",IF(OR(ISBLANK(F15),ISBLANK(G15)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H15*MID(H17,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I15+K15+K16+K17+M15+M16+M17)=0,0,IF(OR(ISBLANK(C15),C15=0),\"Enter Date\",IF(ISBLANK(D15),\"Enter purpose\",IF(AND(M15>0,ISBLANK(L15)),\"Enter description\",IF(AND(M16>0,ISBLANK(L16)),\"Enter description\",IF(AND(M17>0,ISBLANK(L17)),\"Enter description\",+I15+K15+K16+K17+M15+M16+M17))))))","v":0}]
[1,null,null,null,null,null,null,null,null,"Lunch",null,null,null,null,null,"Meal Allowance effective 6/11/24"]
[1,null,{"$f":"IF(AND(ISBLANK(C15),C15=0),\" \",TEXT(WEEKDAY(C15),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H15),H15=0),\" \",\"x \"&VLOOKUP($C15,$P$10:$R$14,3))","v":" "},null,"Dinner",null,null,null,null,null,"Meals","with receipt","no receipt"]
[1,5,null,null,null,null,null,null,{"$f":"IF(H18=0,0,IF(ISBLANK(C18),0,IF(ISBLANK(D18),\"Enter Purpose\",IF(OR(ISBLANK(F18),ISBLANK(G18)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H18*MID(H20,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I18+K18+K19+K20+M18+M19+M20)=0,0,IF(OR(ISBLANK(C18),C18=0),\"Enter Date\",IF(ISBLANK(D18),\"Enter purpose\",IF(AND(M18>0,ISBLANK(L18)),\"Enter description\",IF(AND(M19>0,ISBLANK(L19)),\"Enter description\",IF(AND(M20>0,ISBLANK(L20)),\"Enter description\",+I18+K18+K19+K20+M18+M19+M20))))))","v":0},null,"Breakfast",17.5,10]
[1,null,null,null,null,null,null,null,null,"Lunch",null,null,null,null,null,"Lunch",25,17.5]
[1,null,{"$f":"IF(AND(ISBLANK(C18),C18=0),\" \",TEXT(WEEKDAY(C18),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H18),H18=0),\" \",\"x \"&VLOOKUP($C18,$P$10:$R$14,3))","v":" "},null,"Dinner",null,null,null,null,null,"Dinner",40,25]
[1,6,null,null,null,null,null,null,{"$f":"IF(H21=0,0,IF(ISBLANK(C21),0,IF(ISBLANK(D21),\"Enter Purpose\",IF(OR(ISBLANK(F21),ISBLANK(G21)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H21*MID(H23,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I21+K21+K22+K23+M21+M22+M23)=0,0,IF(OR(ISBLANK(C21),C21=0),\"Enter Date\",IF(ISBLANK(D21),\"Enter purpose\",IF(AND(M21>0,ISBLANK(L21)),\"Enter description\",IF(AND(M22>0,ISBLANK(L22)),\"Enter description\",IF(AND(M23>0,ISBLANK(L23)),\"Enter description\",+I21+K21+K22+K23+M21+M22+M23))))))","v":0}]
[1,null,null,null,null,null,null,null,null,"Lunch",null,null,null,null,null,"Meal Allowance thru 6/10/24"]
[1,null,{"$f":"IF(AND(ISBLANK(C21),C21=0),\" \",TEXT(WEEKDAY(C21),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H21),H21=0),\" \",\"x \"&VLOOKUP($C21,$P$10:$R$14,3))","v":" "},null,"Dinner",null,null,null,null,null,"Meals","with receipt","no receipt"]
[1,7,null,null,null,null,null,null,{"$f":"IF(H24=0,0,IF(ISBLANK(C24),0,IF(ISBLANK(D24),\"Enter Purpose\",IF(OR(ISBLANK(F24),ISBLANK(G24)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H24*MID(H26,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I24+K24+K25+K26+M24+M25+M26)=0,0,IF(OR(ISBLANK(C24),C24=0),\"Enter Date\",IF(ISBLANK(D24),\"Enter purpose\",IF(AND(M24>0,ISBLANK(L24)),\"Enter description\",IF(AND(M25>0,ISBLANK(L25)),\"Enter description\",IF(AND(M26>0,ISBLANK(L26)),\"Enter description\",+I24+K24+K25+K26+M24+M25+M26))))))","v":0},null,"Breakfast",10,7.5]
[1,null,null,null,null,null,null,null,null,"Lunch",null,null,null,null,null,"Lunch",17.5,12.5]
[1,null,{"$f":"IF(AND(ISBLANK(C24),C24=0),\" \",TEXT(WEEKDAY(C24),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H24),H24=0),\" \",\"x \"&VLOOKUP($C24,$P$10:$R$14,3))","v":" "},null,"Dinner",null,null,null,null,null,"Dinner",35,20]
[2,8,null,null,null,null,null,null,{"$f":"IF(H27=0,0,IF(ISBLANK(C27),0,IF(ISBLANK(D27),\"Enter Purpose\",IF(OR(ISBLANK(F27),ISBLANK(G27)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H27*MID(H29,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I27+K27+K28+K29+M27+M28+M29)=0,0,IF(OR(ISBLANK(C27),C27=0),\"Enter Date\",IF(ISBLANK(D27),\"Enter purpose\",IF(AND(M27>0,ISBLANK(L27)),\"Enter description\",IF(AND(M28>0,ISBLANK(L28)),\"Enter description\",IF(AND(M29>0,ISBLANK(L29)),\"Enter description\",+I27+K27+K28+K29+M27+M28+M29))))))","v":0}]
[2,null,null,null,null,null,null,null,null,"Lunch"]
[2,null,{"$f":"IF(AND(ISBLANK(C27),C27=0),\" \",TEXT(WEEKDAY(C27),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H27),H27=0),\" \",\"x \"&VLOOKUP($C27,$P$10:$R$14,3))","v":" "},null,"Dinner"]
[2,9,null,null,null,null,null,null,{"$f":"IF(H30=0,0,IF(ISBLANK(C30),0,IF(ISBLANK(D30),\"Enter Purpose\",IF(OR(ISBLANK(F30),ISBLANK(G30)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H30*MID(H32,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I30+K30+K31+K32+M30+M31+M32)=0,0,IF(OR(ISBLANK(C30),C30=0),\"Enter Date\",IF(ISBLANK(D30),\"Enter purpose\",IF(AND(M30>0,ISBLANK(L30)),\"Enter description\",IF(AND(M31>0,ISBLANK(L31)),\"Enter description\",IF(AND(M32>0,ISBLANK(L32)),\"Enter description\",+I30+K30+K31+K32+M30+M31+M32))))))","v":0}]
[2,null,null,null,null,null,null,null,null,"Lunch"]
[2,null,{"$f":"IF(AND(ISBLANK(C30),C30=0),\" \",TEXT(WEEKDAY(C30),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H30),H30=0),\" \",\"x \"&VLOOKUP($C30,$P$10:$R$14,3))","v":" "},null,"Dinner"]
[2,10,null,null,null,null,null,null,{"$f":"IF(H33=0,0,IF(ISBLANK(C33),0,IF(ISBLANK(D33),\"Enter Purpose\",IF(OR(ISBLANK(F33),ISBLANK(G33)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H33*MID(H35,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I33+K33+K34+K35+M33+M34+M35)=0,0,IF(OR(ISBLANK(C33),C33=0),\"Enter Date\",IF(ISBLANK(D33),\"Enter purpose\",IF(AND(M33>0,ISBLANK(L33)),\"Enter description\",IF(AND(M34>0,ISBLANK(L34)),\"Enter description\",IF(AND(M35>0,ISBLANK(L35)),\"Enter description\",+I33+K33+K34+K35+M33+M34+M35))))))","v":0}]
[2,null,null,null,null,null,null,null,null,"Lunch"]
[2,null,{"$f":"IF(AND(ISBLANK(C33),C33=0),\" \",TEXT(WEEKDAY(C33),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H33),H33=0),\" \",\"x \"&VLOOKUP($C33,$P$10:$R$14,3))","v":" "},null,"Dinner"]
[2,11,null,null,null,null,null,null,{"$f":"IF(H36=0,0,IF(ISBLANK(C36),0,IF(ISBLANK(D36),\"Enter Purpose\",IF(OR(ISBLANK(F36),ISBLANK(G36)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H36*MID(H38,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I36+K36+K37+K38+M36+M37+M38)=0,0,IF(OR(ISBLANK(C36),C36=0),\"Enter Date\",IF(ISBLANK(D36),\"Enter purpose\",IF(AND(M36>0,ISBLANK(L36)),\"Enter description\",IF(AND(M37>0,ISBLANK(L37)),\"Enter description\",IF(AND(M38>0,ISBLANK(L38)),\"Enter description\",+I36+K36+K37+K38+M36+M37+M38))))))","v":0}]
[2,null,null,null,null,null,null,null,null,"Lunch"]
[2,null,{"$f":"IF(AND(ISBLANK(C36),C36=0),\" \",TEXT(WEEKDAY(C36),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H36),H36=0),\" \",\"x \"&VLOOKUP($C36,$P$10:$R$14,3))","v":" "},null,"Dinner"]
[2,12,null,null,null,null,null,null,{"$f":"IF(H39=0,0,IF(ISBLANK(C39),0,IF(ISBLANK(D39),\"Enter Purpose\",IF(OR(ISBLANK(F39),ISBLANK(G39)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H39*MID(H41,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I39+K39+K40+K41+M39+M40+M41)=0,0,IF(OR(ISBLANK(C39),C39=0),\"Enter Date\",IF(ISBLANK(D39),\"Enter purpose\",IF(AND(M39>0,ISBLANK(L39)),\"Enter description\",IF(AND(M40>0,ISBLANK(L40)),\"Enter description\",IF(AND(M41>0,ISBLANK(L41)),\"Enter description\",+I39+K39+K40+K41+M39+M40+M41))))))","v":0}]
[2,null,null,null,null,null,null,null,null,"Lunch"]
[2,null,{"$f":"IF(AND(ISBLANK(C39),C39=0),\" \",TEXT(WEEKDAY(C39),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H39),H39=0),\" \",\"x \"&VLOOKUP($C39,$P$10:$R$14,3))","v":" "},null,"Dinner"]
[2,13,null,null,null,null,null,null,{"$f":"IF(H42=0,0,IF(ISBLANK(C42),0,IF(ISBLANK(D42),\"Enter Purpose\",IF(OR(ISBLANK(F42),ISBLANK(G42)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H42*MID(H44,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I42+K42+K43+K44+M42+M43+M44)=0,0,IF(OR(ISBLANK(C42),C42=0),\"Enter Date\",IF(ISBLANK(D42),\"Enter purpose\",IF(AND(M42>0,ISBLANK(L42)),\"Enter description\",IF(AND(M43>0,ISBLANK(L43)),\"Enter description\",IF(AND(M44>0,ISBLANK(L44)),\"Enter description\",+I42+K42+K43+K44+M42+M43+M44))))))","v":0}]
[2,null,null,null,null,null,null,null,null,"Lunch"]
[2,null,{"$f":"IF(AND(ISBLANK(C42),C42=0),\" \",TEXT(WEEKDAY(C42),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H42),H42=0),\" \",\"x \"&VLOOKUP($C42,$P$10:$R$14,3))","v":" "},null,"Dinner"]
[2,14,null,null,null,null,null,null,{"$f":"IF(H45=0,0,IF(ISBLANK(C45),0,IF(ISBLANK(D45),\"Enter Purpose\",IF(OR(ISBLANK(F45),ISBLANK(G45)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H45*MID(H47,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I45+K45+K46+K47+M45+M46+M47)=0,0,IF(OR(ISBLANK(C45),C45=0),\"Enter Date\",IF(ISBLANK(D45),\"Enter purpose\",IF(AND(M45>0,ISBLANK(L45)),\"Enter description\",IF(AND(M46>0,ISBLANK(L46)),\"Enter description\",IF(AND(M47>0,ISBLANK(L47)),\"Enter description\",+I45+K45+K46+K47+M45+M46+M47))))))","v":0}]
[2,null,null,null,null,null,null,null,null,"Lunch"]
[2,null,{"$f":"IF(AND(ISBLANK(C45),C45=0),\" \",TEXT(WEEKDAY(C45),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H45),H45=0),\" \",\"x \"&VLOOKUP($C45,$P$10:$R$14,3))","v":" "},null,"Dinner"]
[2,15,null,null,null,null,null,null,{"$f":"IF(H48=0,0,IF(ISBLANK(C48),0,IF(ISBLANK(D48),\"Enter Purpose\",IF(OR(ISBLANK(F48),ISBLANK(G48)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H48*MID(H50,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I48+K48+K49+K50+M48+M49+M50)=0,0,IF(OR(ISBLANK(C48),C48=0),\"Enter Date\",IF(ISBLANK(D48),\"Enter purpose\",IF(AND(M48>0,ISBLANK(L48)),\"Enter description\",IF(AND(M49>0,ISBLANK(L49)),\"Enter description\",IF(AND(M50>0,ISBLANK(L50)),\"Enter description\",+I48+K48+K49+K50+M48+M49+M50))))))","v":0}]
[2,null,null,null,null,null,null,null,null,"Lunch"]
[2,null,{"$f":"IF(AND(ISBLANK(C48),C48=0),\" \",TEXT(WEEKDAY(C48),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H48),H48=0),\" \",\"x \"&VLOOKUP($C48,$P$10:$R$14,3))","v":" "},null,"Dinner"]
[2,16,null,null,null,null,null,null,{"$f":"IF(H51=0,0,IF(ISBLANK(C51),0,IF(ISBLANK(D51),\"Enter Purpose\",IF(OR(ISBLANK(F51),ISBLANK(G51)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H51*MID(H53,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I51+K51+K52+K53+M51+M52+M53)=0,0,IF(OR(ISBLANK(C51),C51=0),\"Enter Date\",IF(ISBLANK(D51),\"Enter purpose\",IF(AND(M51>0,ISBLANK(L51)),\"Enter description\",IF(AND(M52>0,ISBLANK(L52)),\"Enter description\",IF(AND(M53>0,ISBLANK(L53)),\"Enter description\",+I51+K51+K52+K53+M51+M52+M53))))))","v":0}]
[2,null,null,null,null,null,null,null,null,"Lunch"]
[2,null,{"$f":"IF(AND(ISBLANK(C51),C51=0),\" \",TEXT(WEEKDAY(C51),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H51),H51=0),\" \",\"x \"&VLOOKUP($C51,$P$10:$R$14,3))","v":" "},null,"Dinner"]
[2,17,null,null,null,null,null,null,{"$f":"IF(H54=0,0,IF(ISBLANK(C54),0,IF(ISBLANK(D54),\"Enter Purpose\",IF(OR(ISBLANK(F54),ISBLANK(G54)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H54*MID(H56,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I54+K54+K55+K56+M54+M55+M56)=0,0,IF(OR(ISBLANK(C54),C54=0),\"Enter Date\",IF(ISBLANK(D54),\"Enter purpose\",IF(AND(M54>0,ISBLANK(L54)),\"Enter description\",IF(AND(M55>0,ISBLANK(L55)),\"Enter description\",IF(AND(M56>0,ISBLANK(L56)),\"Enter description\",+I54+K54+K55+K56+M54+M55+M56))))))","v":0}]
[2,null,null,null,null,null,null,null,null,"Lunch"]
[2,null,{"$f":"IF(AND(ISBLANK(C54),C54=0),\" \",TEXT(WEEKDAY(C54),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H54),H54=0),\" \",\"x \"&VLOOKUP($C54,$P$10:$R$14,3))","v":" "},null,"Dinner"]
[2,18,null,null,null,null,null,null,{"$f":"IF(H57=0,0,IF(ISBLANK(C57),0,IF(ISBLANK(D57),\"Enter Purpose\",IF(OR(ISBLANK(F57),ISBLANK(G57)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H57*MID(H59,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I57+K57+K58+K59+M57+M58+M59)=0,0,IF(OR(ISBLANK(C57),C57=0),\"Enter Date\",IF(ISBLANK(D57),\"Enter purpose\",IF(AND(M57>0,ISBLANK(L57)),\"Enter description\",IF(AND(M58>0,ISBLANK(L58)),\"Enter description\",IF(AND(M59>0,ISBLANK(L59)),\"Enter description\",+I57+K57+K58+K59+M57+M58+M59))))))","v":0}]
[2,null,null,null,null,null,null,null,null,"Lunch"]
[2,null,{"$f":"IF(AND(ISBLANK(C57),C57=0),\" \",TEXT(WEEKDAY(C57),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H57),H57=0),\" \",\"x \"&VLOOKUP($C57,$P$10:$R$14,3))","v":" "},null,"Dinner"]
[2,19,null,null,null,null,null,null,{"$f":"IF(H60=0,0,IF(ISBLANK(C60),0,IF(ISBLANK(D60),\"Enter Purpose\",IF(OR(ISBLANK(F60),ISBLANK(G60)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H60*MID(H62,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I60+K60+K61+K62+M60+M61+M62)=0,0,IF(OR(ISBLANK(C60),C60=0),\"Enter Date\",IF(ISBLANK(D60),\"Enter purpose\",IF(AND(M60>0,ISBLANK(L60)),\"Enter description\",IF(AND(M61>0,ISBLANK(L61)),\"Enter description\",IF(AND(M62>0,ISBLANK(L62)),\"Enter description\",+I60+K60+K61+K62+M60+M61+M62))))))","v":0}]
[2,null,null,null,null,null,null,null,null,"Lunch"]
[2,null,{"$f":"IF(AND(ISBLANK(C60),C60=0),\" \",TEXT(WEEKDAY(C60),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H60),H60=0),\" \",\"x \"&VLOOKUP($C60,$P$10:$R$14,3))","v":" "},null,"Dinner"]
[3,20,null,null,null,null,null,null,{"$f":"IF(H63=0,0,IF(ISBLANK(C63),0,IF(ISBLANK(D63),\"Enter Purpose\",IF(OR(ISBLANK(F63),ISBLANK(G63)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H63*MID(H65,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I63+K63+K64+K65+M63+M64+M65)=0,0,IF(OR(ISBLANK(C63),C63=0),\"Enter Date\",IF(ISBLANK(D63),\"Enter purpose\",IF(AND(M63>0,ISBLANK(L63)),\"Enter description\",IF(AND(M64>0,ISBLANK(L64)),\"Enter description\",IF(AND(M65>0,ISBLANK(L65)),\"Enter description\",+I63+K63+K64+K65+M63+M64+M65))))))","v":0}]
[3,null,null,null,null,null,null,null,null,"Lunch"]
[3,null,{"$f":"IF(AND(ISBLANK(C63),C63=0),\" \",TEXT(WEEKDAY(C63),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H63),H63=0),\" \",\"x \"&VLOOKUP($C63,$P$10:$R$14,3))","v":" "},null,"Dinner"]
[3,21,null,null,null,null,null,null,{"$f":"IF(H66=0,0,IF(ISBLANK(C66),0,IF(ISBLANK(D66),\"Enter Purpose\",IF(OR(ISBLANK(F66),ISBLANK(G66)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H66*MID(H68,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I66+K66+K67+K68+M66+M67+M68)=0,0,IF(OR(ISBLANK(C66),C66=0),\"Enter Date\",IF(ISBLANK(D66),\"Enter purpose\",IF(AND(M66>0,ISBLANK(L66)),\"Enter description\",IF(AND(M67>0,ISBLANK(L67)),\"Enter description\",IF(AND(M68>0,ISBLANK(L68)),\"Enter description\",+I66+K66+K67+K68+M66+M67+M68))))))","v":0}]
[3,null,null,null,null,null,null,null,null,"Lunch"]
[3,null,{"$f":"IF(AND(ISBLANK(C66),C66=0),\" \",TEXT(WEEKDAY(C66),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H66),H66=0),\" \",\"x \"&VLOOKUP($C66,$P$10:$R$14,3))","v":" "},null,"Dinner"]
[3,22,null,null,null,null,null,null,{"$f":"IF(H69=0,0,IF(ISBLANK(C69),0,IF(ISBLANK(D69),\"Enter Purpose\",IF(OR(ISBLANK(F69),ISBLANK(G69)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H69*MID(H71,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I69+K69+K70+K71+M69+M70+M71)=0,0,IF(OR(ISBLANK(C69),C69=0),\"Enter Date\",IF(ISBLANK(D69),\"Enter purpose\",IF(AND(M69>0,ISBLANK(L69)),\"Enter description\",IF(AND(M70>0,ISBLANK(L70)),\"Enter description\",IF(AND(M71>0,ISBLANK(L71)),\"Enter description\",+I69+K69+K70+K71+M69+M70+M71))))))","v":0}]
[3,null,null,null,null,null,null,null,null,"Lunch"]
[3,null,{"$f":"IF(AND(ISBLANK(C69),C69=0),\" \",TEXT(WEEKDAY(C69),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H69),H69=0),\" \",\"x \"&VLOOKUP($C69,$P$10:$R$14,3))","v":" "},null,"Dinner"]
[3,23,null,null,null,null,null,null,{"$f":"IF(H72=0,0,IF(ISBLANK(C72),0,IF(ISBLANK(D72),\"Enter Purpose\",IF(OR(ISBLANK(F72),ISBLANK(G72)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H72*MID(H74,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I72+K72+K73+K74+M72+M73+M74)=0,0,IF(OR(ISBLANK(C72),C72=0),\"Enter Date\",IF(ISBLANK(D72),\"Enter purpose\",IF(AND(M72>0,ISBLANK(L72)),\"Enter description\",IF(AND(M73>0,ISBLANK(L73)),\"Enter description\",IF(AND(M74>0,ISBLANK(L74)),\"Enter description\",+I72+K72+K73+K74+M72+M73+M74))))))","v":0}]
[3,null,null,null,null,null,null,null,null,"Lunch"]
[3,null,{"$f":"IF(AND(ISBLANK(C72),C72=0),\" \",TEXT(WEEKDAY(C72),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H72),H72=0),\" \",\"x \"&VLOOKUP($C72,$P$10:$R$14,3))","v":" "},null,"Dinner"]
[3,24,null,null,null,null,null,null,{"$f":"IF(H75=0,0,IF(ISBLANK(C75),0,IF(ISBLANK(D75),\"Enter Purpose\",IF(OR(ISBLANK(F75),ISBLANK(G75)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H75*MID(H77,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I75+K75+K76+K77+M75+M76+M77)=0,0,IF(OR(ISBLANK(C75),C75=0),\"Enter Date\",IF(ISBLANK(D75),\"Enter purpose\",IF(AND(M75>0,ISBLANK(L75)),\"Enter description\",IF(AND(M76>0,ISBLANK(L76)),\"Enter description\",IF(AND(M77>0,ISBLANK(L77)),\"Enter description\",+I75+K75+K76+K77+M75+M76+M77))))))","v":0}]
[3,null,null,null,null,null,null,null,null,"Lunch"]
[3,null,{"$f":"IF(AND(ISBLANK(C75),C75=0),\" \",TEXT(WEEKDAY(C75),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H75),H75=0),\" \",\"x \"&VLOOKUP($C75,$P$10:$R$14,3))","v":" "},null,"Dinner"]
[3,25,null,null,null,null,null,null,{"$f":"IF(H78=0,0,IF(ISBLANK(C78),0,IF(ISBLANK(D78),\"Enter Purpose\",IF(OR(ISBLANK(F78),ISBLANK(G78)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H78*MID(H80,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I78+K78+K79+K80+M78+M79+M80)=0,0,IF(OR(ISBLANK(C78),C78=0),\"Enter Date\",IF(ISBLANK(D78),\"Enter purpose\",IF(AND(M78>0,ISBLANK(L78)),\"Enter description\",IF(AND(M79>0,ISBLANK(L79)),\"Enter description\",IF(AND(M80>0,ISBLANK(L80)),\"Enter description\",+I78+K78+K79+K80+M78+M79+M80))))))","v":0}]
[3,null,null,null,null,null,null,null,null,"Lunch"]
[3,null,{"$f":"IF(AND(ISBLANK(C78),C78=0),\" \",TEXT(WEEKDAY(C78),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H78),H78=0),\" \",\"x \"&VLOOKUP($C78,$P$10:$R$14,3))","v":" "},null,"Dinner"]
[3,26,null,null,null,null,null,null,{"$f":"IF(H81=0,0,IF(ISBLANK(C81),0,IF(ISBLANK(D81),\"Enter Purpose\",IF(OR(ISBLANK(F81),ISBLANK(G81)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H81*MID(H83,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I81+K81+K82+K83+M81+M82+M83)=0,0,IF(OR(ISBLANK(C81),C81=0),\"Enter Date\",IF(ISBLANK(D81),\"Enter purpose\",IF(AND(M81>0,ISBLANK(L81)),\"Enter description\",IF(AND(M82>0,ISBLANK(L82)),\"Enter description\",IF(AND(M83>0,ISBLANK(L83)),\"Enter description\",+I81+K81+K82+K83+M81+M82+M83))))))","v":0}]
[3,null,null,null,null,null,null,null,null,"Lunch"]
[3,null,{"$f":"IF(AND(ISBLANK(C81),C81=0),\" \",TEXT(WEEKDAY(C81),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H81),H81=0),\" \",\"x \"&VLOOKUP($C81,$P$10:$R$14,3))","v":" "},null,"Dinner"]
[3,27,null,null,null,null,null,null,{"$f":"IF(H84=0,0,IF(ISBLANK(C84),0,IF(ISBLANK(D84),\"Enter Purpose\",IF(OR(ISBLANK(F84),ISBLANK(G84)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H84*MID(H86,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I84+K84+K85+K86+M84+M85+M86)=0,0,IF(OR(ISBLANK(C84),C84=0),\"Enter Date\",IF(ISBLANK(D84),\"Enter purpose\",IF(AND(M84>0,ISBLANK(L84)),\"Enter description\",IF(AND(M85>0,ISBLANK(L85)),\"Enter description\",IF(AND(M86>0,ISBLANK(L86)),\"Enter description\",+I84+K84+K85+K86+M84+M85+M86))))))","v":0}]
[3,null,null,null,null,null,null,null,null,"Lunch"]
[3,null,{"$f":"IF(AND(ISBLANK(C84),C84=0),\" \",TEXT(WEEKDAY(C84),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H84),H84=0),\" \",\"x \"&VLOOKUP($C84,$P$10:$R$14,3))","v":" "},null,"Dinner"]
[3,28,null,null,null,null,null,null,{"$f":"IF(H87=0,0,IF(ISBLANK(C87),0,IF(ISBLANK(D87),\"Enter Purpose\",IF(OR(ISBLANK(F87),ISBLANK(G87)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H87*MID(H89,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I87+K87+K88+K89+M87+M88+M89)=0,0,IF(OR(ISBLANK(C87),C87=0),\"Enter Date\",IF(ISBLANK(D87),\"Enter purpose\",IF(AND(M87>0,ISBLANK(L87)),\"Enter description\",IF(AND(M88>0,ISBLANK(L88)),\"Enter description\",IF(AND(M89>0,ISBLANK(L89)),\"Enter description\",+I87+K87+K88+K89+M87+M88+M89))))))","v":0}]
[3,null,null,null,null,null,null,null,null,"Lunch"]
[3,null,{"$f":"IF(AND(ISBLANK(C87),C87=0),\" \",TEXT(WEEKDAY(C87),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H87),H87=0),\" \",\"x \"&VLOOKUP($C87,$P$10:$R$14,3))","v":" "},null,"Dinner"]
[3,29,null,null,null,null,null,null,{"$f":"IF(H90=0,0,IF(ISBLANK(C90),0,IF(ISBLANK(D90),\"Enter Purpose\",IF(OR(ISBLANK(F90),ISBLANK(G90)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H90*MID(H92,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I90+K90+K91+K92+M90+M91+M92)=0,0,IF(OR(ISBLANK(C90),C90=0),\"Enter Date\",IF(ISBLANK(D90),\"Enter purpose\",IF(AND(M90>0,ISBLANK(L90)),\"Enter description\",IF(AND(M91>0,ISBLANK(L91)),\"Enter description\",IF(AND(M92>0,ISBLANK(L92)),\"Enter description\",+I90+K90+K91+K92+M90+M91+M92))))))","v":0}]
[3,null,null,null,null,null,null,null,null,"Lunch"]
[3,null,{"$f":"IF(AND(ISBLANK(C90),C90=0),\" \",TEXT(WEEKDAY(C90),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H90),H90=0),\" \",\"x \"&VLOOKUP($C90,$P$10:$R$14,3))","v":" "},null,"Dinner"]
[3,30,null,null,null,null,null,null,{"$f":"IF(H93=0,0,IF(ISBLANK(C93),0,IF(ISBLANK(D93),\"Enter Purpose\",IF(OR(ISBLANK(F93),ISBLANK(G93)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H93*MID(H95,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I93+K93+K94+K95+M93+M94+M95)=0,0,IF(OR(ISBLANK(C93),C93=0),\"Enter Date\",IF(ISBLANK(D93),\"Enter purpose\",IF(AND(M93>0,ISBLANK(L93)),\"Enter description\",IF(AND(M94>0,ISBLANK(L94)),\"Enter description\",IF(AND(M95>0,ISBLANK(L95)),\"Enter description\",+I93+K93+K94+K95+M93+M94+M95))))))","v":0}]
[3,null,null,null,null,null,null,null,null,"Lunch"]
[3,null,{"$f":"IF(AND(ISBLANK(C93),C93=0),\" \",TEXT(WEEKDAY(C93),\"DDD\"))","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(H93),H93=0),\" \",\"x \"&VLOOKUP($C93,$P$10:$R$14,3))","v":" "},null,"Dinner"]
[3,31,null,null,null,null,null,null,{"$f":"IF(H96=0,0,IF(ISBLANK(C96),0,IF(ISBLANK(D96),\"Enter Purpose\",IF(OR(ISBLANK(F96),ISBLANK(G96)),\"Enter From/to\",IF(AND(NOW()>$Q$12,$S$8<$P$13),\"Using old form\",ROUND(H96*MID(H98,3,6),2))))))","v":0},"Breakfast",null,null,null,{"$f":"IF((+I96+K96+K97+K98+M96+M97+M98)=0,0,IF(OR(ISBLANK(C96),C96=0),\"Enter Date\",IF(ISBLANK(D96),\"Enter purpose\",IF(AND(M96>0,ISBLANK(L96)),\"Enter description\",IF(AND(M97>0,ISBLANK(L97)),\"Enter description\",IF(AND(M98>0,ISBLANK(L98)),\"Enter description\",+I96+K96+K97+K98+M96+M97+M98))))))","v":0}]
[3,null,null,null,null,null,null,null,null,"Lunch"]
[3,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(H96),H96=0),\" \",\"x \"&VLOOKUP($C96,$P$10:$R$14,3))","v":" "},null,"Dinner"]
[0,null,null,null,null,null,"Total ",{"$f":"SUM(H6:H98)","v":0},{"$f":"SUM(I6:I98)","v":0},"Total ",{"$f":"SUM(K6:K98)","v":0},"Total Other",{"$f":"SUM(M6:M98)","v":0},{"$f":"SUM(N6:N98)","v":0}]
[0]
[0,null,"I hereby certify that the above items constitute a true statement of actual and necessary expenses incurred in the performance of authorized duties",null,null,null,null,null,null,"GL Account:",null,null,"Amount $",{"$f":"N99-N102-N103-N104","v":0},{"$f":"IF(OR(K101=\"00-00-000000-000000-00000\",ISBLANK(K101)),\"Enter GL Account\",IF(AND(N99>0,N101<0),\"Negative amount,check amounts below\",\" \"))","v":"Enter GL Account"}]
[0,null,null,null,null,null,null,null,null,"GL Account:",null,null,"Amount $",0,{"$f":"IF(N102<0,\"No negative amounts allowed\",IF(AND(N102>0,ISBLANK(K102)),\"Enter GL Account\",\" \"))","v":" "}]
[0,null,null,null,null,null,null,null,null,"GL Account:",null,null,"Amount $",0,{"$f":"IF(N103<0,\"No negative amounts allowed\",IF(AND(N103>0,ISBLANK(K103)),\"Enter GL Account\",\" \"))","v":" "}]
[0,null,"Signature:",null,null,"Date:",null,null,null,"GL Account:",null,null,"Amount $",0,{"$f":"IF(N104<0,\"No negative amounts allowed\",IF(AND(N104>0,ISBLANK(K104)),\"Enter GL Account\",\" \"))","v":" "}]
[0,null,"Reviewed by:",null,null,"Date:",null,null,"Comments:"]
[0,null,null,null,"Department or Division Head"]
[0,null,"Approved by:",null,null,"Date:"]
[0,null,null,null,"President or Designee"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"History"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mileage period"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"From","To","Rate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-07-01","2020-12-31",0.57499999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-01","2021-06-30",0.56000000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-01","2021-12-31",0.56000000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-01-01","2022-06-30",0.58499999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-07-01","2022-12-31",0.625]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-01","2023-06-30",0.65500000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-01","2023-12-31",0.65500000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-01-01","2024-06-30",0.67]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-07-01","2024-12-31",0.67]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-01-01","2025-06-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-07-01","2025-12-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-01-01","2026-06-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-07-01","2026-12-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2027-01-01","2027-06-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2027-07-01","2027-12-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2028-01-01","2028-06-30"]

{"sheet":"Validations","index":1,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Field","Validation"]
["Date","Tests if date is within fiscal year"]
["Mileage Amount"," \"Using old form\" message by testing if current date & date mileage rate was updated"]
["Breakfast","\"Amount exceeds limit\" message"]
["Lunch","\"Amount exceeds limit\" message"]
["Dinner","\"Amount exceeds limit\" message"]
["GL Account","Tests if the text length is 25"]

{"sheet":"Mileage Table","index":2,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
["Mileage Table, one way:"]
["FROM","TO"]
[null,"BWC","CCC","DVC","DO","LMC","SRC",null,"Address"]
["Brentwood Center (BWC)","-",45,28,31,17,39,null,"1351 Pioneer Square, Brentwood, CA 94513"]
["Contra Costa College (CCC)",45,"-",21,17,32,42,null,"2600 Mission Bell Drive, San Pablo, CA 94806"]
["Diablo Valley College (DVC)",28,21,"-",7,16,23,null,"321 Golf Club Road, Pleasant Hill, CA 94523"]
["District Office (DO)",31,17,7,"-",18,28,null,"500 Court Street, Martinez, CA 94553"]
["Los Medanos College LMC)",17,32,16,18,"-",36,null,"2700 East Leland Road, Pittsburg, CA 94565"]
["San Ramon Center (SRC)",39,42,23,28,36,"-",null,"1690 Watermill Road, San Ramon, CA 94582"]

{"sheet":"Instructions","index":3,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"INSTRUCTIONS"]
[]
["*","Save the form to your personal Drive/Folder."]
["*","Claim only expenses you have paid for. Do not include expenses you charged on a procurement card or paid by the District."]
["*","Attach receipts for all out-of-pocket expenses & meals (if more than the minimum meal allowance is claimed)."]
["*","Review the form and make sure you have completed the required fields and there are no error messages."]
["*","Sign and date the form."]
["*","Submit the form for approval."]
[]
["* ","Refer to Business Procedure 9.22- Employee Reimbursement for complete instructions.\n"]
[null,"http://www.4cd.edu/gb/policies-procedures/business/fin9_22.pdf"]

{"sheet":"Example","index":4,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[3,10,3,11],[4,1,4,3],[4,8,4,9],[6,0,7,0],[0,1,0,4],[0,6,0,7],[1,2,1,7],[3,4,3,7],[5,1,7,3],[5,4,7,4],[5,5,7,5],[5,7,7,7],[5,12,7,12],[11,12,13,12],[12,0,13,0],[8,1,10,3],[8,4,10,4],[8,5,10,5],[8,7,10,7],[8,12,10,12],[9,0,10,0],[11,7,13,7],[11,1,13,3],[11,4,13,4],[11,5,13,5],[14,1,16,3],[14,4,16,4],[14,5,16,5],[14,7,16,7],[24,0,25,0],[15,0,16,0],[21,0,22,0],[17,1,19,3],[17,4,19,4],[17,5,19,5],[17,7,19,7],[18,0,19,0],[20,1,22,3],[20,4,22,4],[20,5,22,5],[20,7,22,7],[14,12,16,12],[20,12,22,12],[17,12,19,12],[33,2,33,3],[33,7,35,12],[35,2,35,3],[23,1,25,3],[23,4,25,4],[23,5,25,5],[23,7,25,7],[23,12,25,12],[28,0,29,6],[28,9,28,10],[29,9,29,10],[30,9,30,10],[31,9,31,10]]}
["Name","John Doe",null,null,null,"Employee ID",1234567,null,null,null,null,"Fiscal Year","2018-2019"]
["Mail check to",null,"500 Court Street, Martinez, CA 94553"]
[]
[null,null,null,null,"Personal vehicle used",null,null,null,null,null,"Other out-of-pocket"]
["Date","Purpose\n(Reason for expense)",null,null,"From ","To","Miles","Mileage Reimb.","Meals ",null,"Description","Amount","Line Total"]
["2018-12-12","CCIA Conference in San Diego",null,null,"Home","Airport",14,7.63,"Breakfast",null,"Airfare",379,411.63]
["Wed",null,null,null,null,null,"x 0.545",null,"Lunch",null,"Uber to Hotel",15]
[null,null,null,null,null,null,null,null,"Dinner",null,"Uber to Conference",10]
["2018-12-12","CCIA Conference in San Diego",null,null,null,null,null,0,"Breakfast",null,"Uber to Social event",15,56]
["Wed",null,null,null,null,null," ",null,"Lunch",null,"Uber to Hotel",10]
[null,null,null,null,null,null,null,null,"Dinner",31]
["2018-12-14","CCIA Conference in San Diego",null,null,"Aiport","Home",14,7.63,"Breakfast",null,"Hotel",349.5,418.13]
["Fri",null,null,null,null,null,"x 0.545",null,"Lunch",null,"Uber to Airport",25]
[null,null,null,null,null,null,null,null,"Dinner",null,"Airport parking",36]
["2019-01-07","Accounting Meeting at LMC-roundtrip mileage",null,null,"DO","LMC",34,19.72,"Breakfast",null,"Food, drinks, supplies",20.55,40.269999999999996]
["Mon",null,null,null,null,null,"x 0.58",null,"Lunch",null,null,0]
[null,null,null,null,null,null,null,null,"Dinner",null,null,0]
["2019-01-16","Budget Workshop in Sacramento",null,null,null,null,null,0,"Breakfast",null,"Train ticket",40,60]
["Wed",null,null,null,null,null," ",null,"Lunch",null,"Uber to workshop",10]
[null,null,null,null,null,null,null,null,"Dinner",null,"Uber to Station",10]
[null,null,null,null,null,null,null,0,"Breakfast",null,null,0,0]
[" ",null,null,null,null,null," ",null,"Lunch",null,null,0]
[null,null,null,null,null,null,null,null,"Dinner",null,null,0]
[null,null,null,null,null,null,null,0,"Breakfast",null,null,0,0]
[" ",null,null,null,null,null," ",null,"Lunch",null,null,0]
[null,null,null,null,null,null,null,null,"Dinner",null,null,0]
[null,null,null,null,"28 miles at $0.545 + 34 miles x $0.58","Total ",62,34.979999999999997,"Total ",31,"Total Other",920.05,986.03]
[]
["I hereby certify that the above items constitute a true statement of actual and necessary expenses incurred in the performance of authorized duties",null,null,null,null,null,null,null,"GL Account:","11-01-101003-672000-55200",null,"Amount $",945.76]
[null,null,null,null,null,null,null,null,"GL Account:","11-01-101003-672000-54120",null,"Amount $",40.270000000000003]
[null,null,null,null,null,null,null,null,"GL Account:",null,null,"Amount $",0]
["Signature:",null,null,null,"Date:",null,null,null,"GL Account:",null,null,"Amount $",0]
["Reviewed by:",null,null,null,"Date:",null,null,"Comments:"]
[null,null,"Department or Division Head"]
["Approved by:",null,null,null,"Date:"]
[null,null,"President or Designee"]