{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["DATA","PRINT","PROCEDURES","MILEAGE GUIDE","POLICY","PROTECTED SHEET"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"DATA","index":0,"n_rows":94,"n_cols":17,"rows_kept":94,"cut":false,"hidden":false,"merged":[]}
[null,"BERKSHIRE COMMUNITY COLLEGE"]
[]
[null,"EXPENSE VOUCHER"]
[null,null,"FOR TRAVEL AFTER 07/01/2023"]
[]
[null,"NAME:",null,null,null,null,"Vendor #",null,"     - Enter Vendor Number if Known"]
[null,"Address:"]
[null,"Address:"]
[null,"City, State, Zip"]
[null,null,null,null,null,"EXAMPLE:"]
[null,"DATE:","DAY (DD) (MONDAY):",null,10,12,"- Enter the Monday date for the week of Travel or Expenditure(s)"]
[]
[null,null,"MONTH (MM):",null,7,6,"-  Enter the month of Travel or Expenditure(s) (January = 1, February = 2, etc.)"]
[]
[null,null,"YEAR (YYYY):",null,2023,2023,"-  Enter the year of Travel or Expenditures(s)"]
[]
[null,"PURPOSE OF EXPENSE:"]
[]
[]
[]
[null,"IF CHECK REQUEST:",null,null,null,"- \"Click\" for non travel related expenses"]
[]
[]
[]
[null,"TRAVEL REIMBURSEMENT:"]
[]
[null,"CLASSIFICATION:"]
[null,null,null,"NON UNIT",null,"- If Non Unit member, Enter an \"X\""]
[null,null,null,"MCCC",null,"- If MCCC member, Enter an \"X\""]
[null,null,null,"AFSCME",null,"- If AFSCME member, Enter an \"X\""]
[null,null,null,"OTHER",null,"- If None of the above, Enter an \"X\""]
[]
[null,null,null,null,null,"- \"Click\" for travel related expenses"]
[]
[]
[]
[]
[null,"BERKSHIRE COMMUNITY COLLEGE",null,null,null,null,null,"NAME:",{"$f":"+D6","v":0}]
[]
[null,"PURPOSE OF EXPENSE:",null,null,{"$f":"+E17","v":0}]
[]
[null,null,null,null,"MON","TUE","WED","THU","FRI","SAT","SUN","TOTALS"]
[null,"DATE",null,null,{"$f":"DATE(E15,E13,E11)","v":"2023-07-10"},{"$f":"+E43+1","v":"2023-07-11"},"2023-07-12","2023-07-13","2023-07-14","2023-07-15","2023-07-16"]
[null,"CITY"]
[null,"COMPANY CONTACTED"]
[]
[null,"EXPENSES","  AIRFARE",null,null,null,null,null,null,null,null,{"$f":"+IF(SUM(E47:K47)=0,\" \",SUM(E47:K47))","v":" "},null,"This section for expenses"]
[null,"BILLED"," LODGING",null,null,null,null,null,null,null,null,{"$f":"+IF(SUM(E48:K48)=0,\" \",SUM(E48:K48))","v":" "},null,"directly billed to BCC."]
[null,"TO ","  ENTERTAINMENT",null,null,null,null,null,null,null,null,{"$f":"+IF(SUM(E49:K49)=0,\" \",SUM(E49:K49))","v":" "}]
[null,"BCC","  MISC.",null,null,null,null,null,null,null,null,{"$f":"+IF(SUM(E50:K50)=0,\" \",SUM(E50:K50))","v":" "}]
[null,null,"Expense Area - Enter expenses to be reimbursed below  - DO  NOT  CUT OR COPY  AND  PASTE  DATA"]
[null,"ENTER MILES DRIVEN HERE ---->",null,null,null,null,null,null,null,null,null,{"$f":"+IF(SUM(E52:K52)=0,\" \",SUM(E52:K52))","v":" "},null,"PER DIEM GUIDE"]
[null,"PERS. AUTO ALLOW ($0.655/mile)",null,null,{"$f":"IF(E52=0,\" \",+E52*0.655)","v":" "}," "," "," "," "," "," ",{"$f":"+IF(SUM(E53:K53)=0,\" \",SUM(E53:K53))","v":" "},null,{"$f":"IF(E28=\"x\",D28,\" \")","v":" "},{"$f":"IF(E29=\"x\",D29,\" \")","v":" "},{"$f":"IF(E30=\"x\",D30,\" \")","v":" "},{"$f":"IF(E31=\"x\",D31,\" \")","v":" "}]
[null,"BREAKFAST",null,null,null,null,null,null,null,null,null,{"$f":"+IF(SUM(E54:K54)=0,\" \",SUM(E54:K54))","v":" "},null,{"$f":"IF(E28=\"x\",7.5,\" \")","v":" "},{"$f":"IF(E29=\"x\",7.5,\" \")","v":" "},{"$f":"IF(E30=\"x\",8,\" \")","v":" "},{"$f":"IF(E31=\"x\",7.5,\" \")","v":" "}]
[null,"LUNCH ",null,null,null,null,null,null,null,null,null,{"$f":"+IF(SUM(E55:K55)=0,\" \",SUM(E55:K55))","v":" "},null,{"$f":"IF(E28=\"x\",12.5,\" \")","v":" "},{"$f":"+IF(E29=\"x\",12.5,\" \")","v":" "},{"$f":"+IF(E30=\"x\",12.5,\" \")","v":" "},{"$f":"IF(E31=\"x\",12.5,\" \")","v":" "}]
[null,"DINNER",null,null,null,null,null,null,null,null,null," ",null,{"$f":"IF(E28=\"x\",20,\" \")","v":" "},{"$f":"IF(E29=\"x\",20,\" \")","v":" "},{"$f":"IF(E30=\"x\",20,\" \")","v":" "},{"$f":"IF(E31=\"x\",20,\" \")","v":" "}]
[null,"ENTERTAINMENT (explain below)",null,null,null,null,null,null,null,null,null," "]
[null,"LODGING",null,null,null,null,null,null,null,null,null," "]
[null,"AUTO RENTAL",null,null,null,null,null,null,null,null,null," ",null,"TOLL CALCULATOR:"]
[null,"PARKING / TOLLS / GAS",null,null,null,null,null,null,null,null,null," ",null,"https://www.ezdrivema/TollCalculator"]
[null,"TAXI",null,null,null,null,null,null,null,null,null," "]
[null,"TELEPHONE / FAX",null,null,null,null,null,null,null,null,null," "]
[null,"MISC. / CK REQUEST ( explain below)",null,null,null,null,null,null,null,null,null," ",null,"Enter amount and explain in Misc. section below."]
[null,"TOTAL EXPENSES",null,null,{"$f":"+IF(SUM(E53:E63)=0,\" \",SUM(E53:E63))","v":" "},{"$f":"+IF(SUM(F53:F63)=0,\" \",SUM(F53:F63))","v":" "}," "," "," "," "," "," ",null,"An amount should be shown here for check requests and reimbursed expenses"]
[]
[null,"EXPLANATION OF BUSINESS ENTERTAINMENT (ATTACH SEPARATE SHEET IF MORE SPACE IS REQUIRED)"]
[null,"DATE","PLACE","TYPE","BUSINESS PURPOSE",null,null,"NAMES, TITLES, & CO. AFFILIATION",null,null,null,"AMOUNT"]
[]
[]
[]
[]
[]
[null,"EXPLANATION OF MISC. / CK REQUEST EXPENDITURES"]
[null,"DATE","EXPLANATION",null,null,"AMOUNT",null,"Note: Amount must be entered in above \"Expense Area\""]
[null,null,null,null,null,null,null,"Provide explanation / special instructions for misc. entries above."]
[]
[]
[]
[]
[null,"EXPENSE DISTRIBUTION"]
[null,"SOURCE #","DEPT. #","CODE","\" L \"  #","AMOUNT"]
[null,null,null,null,null,null,null,"Enter Source # - 5 digit number"]
[null,null,null,null,null,null,null,"Enter Dept. # - 4 digit number"]
[null,null,null,null,null,null,null,"Code - Accounting Use Only"]
[null,null,null,null,null,null,null,"Enter \" L \" # - Grant only expenditures"]
[]
[]
[null,"CASH SUMMARY"]
[]
[null,"CASH ADVANCED",null,null,null,null,null,"Enter any Cash Advances received."]
[null,"CASH EXPENSE",null,null,{"$f":"+L64","v":" "},null,null,"Total Expenses."]
[null,"BALANCE",null,null,{"$f":"SUM(-E90,E91)","v":0},null,null,"Total Expenses to be reimbursed."]
[]
[null,null,null,null,{"$f":"IF(SUM(L47:L64)=0,\"         ERROR - PLEASE ENTER EXPENSES IN EXPENSE AREA ABOVE\",\"  \")","v":"         ERROR - PLEASE ENTER EXPENSES IN EXPENSE AREA ABOVE"}]

{"sheet":"PRINT","index":1,"n_rows":53,"n_cols":12,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,8,1,9]]}
[]
[null,"BERKSHIRE COMMUNITY COLLEGE",null,null,null,null,null,"NAME:",{"$f":"+DATA!I38","v":0},null,"Vendor #:",{"$f":"IF(DATA!H6=0,\" \",DATA!H6)","v":" "}]
[]
[null,"Address:",{"$f":"IF(DATA!D7=0,\" \",DATA!D7)","v":" "},null,null,"Address:",{"$f":"IF(DATA!D8=0,\" \",DATA!D8)","v":" "},null,"C / S / Z:",{"$f":"IF(DATA!D9=0,\" \",DATA!D9)","v":" "}]
[]
[null,"PURPOSE OF EXPENSE:",null,null,{"$f":"+DATA!E40","v":0}]
[]
[null,null,null,null,"MON","TUE","WED","THU","FRI","SAT","SUN","TOTALS"]
[null,"DATE",null,null,{"$f":"+DATA!E43","v":"2023-07-10"},{"$f":"+E9+1","v":"2023-07-11"},"2023-07-12","2023-07-13","2023-07-14","2023-07-15","2023-07-16"]
[null,"CITY",null,null,{"$f":"+DATA!E44","v":0},{"$f":"+DATA!F44","v":0},{"$f":"+DATA!G44","v":0},{"$f":"+DATA!H44","v":0},{"$f":"+DATA!I44","v":0},{"$f":"+DATA!J44","v":0},{"$f":"+DATA!K44","v":0}]
[null,"COMPANY CONTACTED",null,null,{"$f":"+DATA!E45","v":0},{"$f":"+DATA!F45","v":0},{"$f":"+DATA!G45","v":0},{"$f":"+DATA!H45","v":0},{"$f":"+DATA!I45","v":0},{"$f":"+DATA!J45","v":0},{"$f":"+DATA!K45","v":0}]
[]
[null,"EXPENSES","  AIRFARE",null,{"$f":"IF(DATA!E47=0, \" \",DATA!E47)","v":" "},{"$f":"IF(DATA!F47=0, \" \",DATA!F47)","v":" "},{"$f":"IF(DATA!G47=0, \" \",DATA!G47)","v":" "},{"$f":"IF(DATA!H47=0, \" \",DATA!H47)","v":" "},{"$f":"IF(DATA!I47=0, \" \",DATA!I47)","v":" "},{"$f":"IF(DATA!J47=0, \" \",DATA!J47)","v":" "},{"$f":"IF(DATA!K47=0, \" \",DATA!K47)","v":" "},{"$f":"+IF(SUM(E13:K13)=0,\" \",SUM(E13:K13))","v":" "}]
[null,"BILLED"," LODGING",null,{"$f":"IF(DATA!E48=0, \" \",DATA!E48)","v":" "},{"$f":"IF(DATA!F48=0, \" \",DATA!F48)","v":" "},{"$f":"IF(DATA!G48=0, \" \",DATA!G48)","v":" "},{"$f":"IF(DATA!H48=0, \" \",DATA!H48)","v":" "},{"$f":"IF(DATA!I48=0, \" \",DATA!I48)","v":" "},{"$f":"IF(DATA!J48=0, \" \",DATA!J48)","v":" "},{"$f":"IF(DATA!K48=0, \" \",DATA!K48)","v":" "},{"$f":"+IF(SUM(E14:K14)=0,\" \",SUM(E14:K14))","v":" "}]
[null,"TO ","  ENTERTAINMENT",null,{"$f":"IF(DATA!E49=0, \" \",DATA!E49)","v":" "},{"$f":"IF(DATA!F49=0, \" \",DATA!F49)","v":" "},{"$f":"IF(DATA!G49=0, \" \",DATA!G49)","v":" "},{"$f":"IF(DATA!H49=0, \" \",DATA!H49)","v":" "},{"$f":"IF(DATA!I49=0, \" \",DATA!I49)","v":" "},{"$f":"IF(DATA!J49=0, \" \",DATA!J49)","v":" "},{"$f":"IF(DATA!K49=0, \" \",DATA!K49)","v":" "},{"$f":"+IF(SUM(E15:K15)=0,\" \",SUM(E15:K15))","v":" "}]
[null,"BCC","  MISC.",null,{"$f":"IF(DATA!E50=0, \" \",DATA!E50)","v":" "},{"$f":"IF(DATA!F50=0, \" \",DATA!F50)","v":" "},{"$f":"IF(DATA!G50=0, \" \",DATA!G50)","v":" "},{"$f":"IF(DATA!H50=0, \" \",DATA!H50)","v":" "},{"$f":"IF(DATA!I50=0, \" \",DATA!I50)","v":" "},{"$f":"IF(DATA!J50=0, \" \",DATA!J50)","v":" "},{"$f":"IF(DATA!K50=0, \" \",DATA!K50)","v":" "},{"$f":"+IF(SUM(E16:K16)=0,\" \",SUM(E16:K16))","v":" "}]
[]
[null,"MILES DRIVEN",null,null,{"$f":"IF(DATA!E52=0,\" \",DATA!E52)","v":" "},{"$f":"IF(DATA!F52=0,\" \",DATA!F52)","v":" "},{"$f":"IF(DATA!G52=0,\" \",DATA!G52)","v":" "},{"$f":"IF(DATA!H52=0,\" \",DATA!H52)","v":" "},{"$f":"IF(DATA!I52=0,\" \",DATA!I52)","v":" "},{"$f":"IF(DATA!J52=0,\" \",DATA!J52)","v":" "},{"$f":"IF(DATA!K52=0,\" \",DATA!K52)","v":" "},{"$f":"+IF(SUM(E18:K18)=0,\" \",SUM(E18:K18))","v":" "}]
[null,"PERS. AUTO ALLOW ($0.655/mile)",null,null,{"$f":"IF(DATA!E53=0,\" \",DATA!E53)","v":" "},{"$f":"IF(DATA!F53=0,\" \",DATA!F53)","v":" "},{"$f":"IF(DATA!G53=0,\" \",DATA!G53)","v":" "},{"$f":"IF(DATA!H53=0,\" \",DATA!H53)","v":" "},{"$f":"IF(DATA!I53=0,\" \",DATA!I53)","v":" "},{"$f":"IF(DATA!J53=0,\" \",DATA!J53)","v":" "},{"$f":"IF(DATA!K53=0,\" \",DATA!K53)","v":" "},{"$f":"+IF(SUM(E19:K19)=0,\" \",SUM(E19:K19))","v":" "}]
[null,"BREAKFAST",null,null,{"$f":"IF(DATA!E54=0,\" \",DATA!E54)","v":" "},{"$f":"IF(DATA!F54=0,\" \",DATA!F54)","v":" "},{"$f":"IF(DATA!G54=0,\" \",DATA!G54)","v":" "},{"$f":"IF(DATA!H54=0,\" \",DATA!H54)","v":" "},{"$f":"IF(DATA!I54=0,\" \",DATA!I54)","v":" "},{"$f":"IF(DATA!J54=0,\" \",DATA!J54)","v":" "},{"$f":"IF(DATA!K54=0,\" \",DATA!K54)","v":" "}," "]
[null,"LUNCH ",null,null,{"$f":"IF(DATA!E55=0,\" \",DATA!E55)","v":" "},{"$f":"IF(DATA!F55=0,\" \",DATA!F55)","v":" "},{"$f":"IF(DATA!G55=0,\" \",DATA!G55)","v":" "},{"$f":"IF(DATA!H55=0,\" \",DATA!H55)","v":" "},{"$f":"IF(DATA!I55=0,\" \",DATA!I55)","v":" "},{"$f":"IF(DATA!J55=0,\" \",DATA!J55)","v":" "},{"$f":"IF(DATA!K55=0,\" \",DATA!K55)","v":" "}," "]
[null,"DINNER",null,null,{"$f":"IF(DATA!E56=0,\" \",DATA!E56)","v":" "},{"$f":"IF(DATA!F56=0,\" \",DATA!F56)","v":" "},{"$f":"IF(DATA!G56=0,\" \",DATA!G56)","v":" "},{"$f":"IF(DATA!H56=0,\" \",DATA!H56)","v":" "},{"$f":"IF(DATA!I56=0,\" \",DATA!I56)","v":" "},{"$f":"IF(DATA!J56=0,\" \",DATA!J56)","v":" "},{"$f":"IF(DATA!K56=0,\" \",DATA!K56)","v":" "}," "]
[null,"ENTERTAINMENT (explain below)",null,null,{"$f":"IF(DATA!E57=0,\" \",DATA!E57)","v":" "},{"$f":"IF(DATA!F57=0,\" \",DATA!F57)","v":" "},{"$f":"IF(DATA!G57=0,\" \",DATA!G57)","v":" "},{"$f":"IF(DATA!H57=0,\" \",DATA!H57)","v":" "},{"$f":"IF(DATA!I57=0,\" \",DATA!I57)","v":" "},{"$f":"IF(DATA!J57=0,\" \",DATA!J57)","v":" "},{"$f":"IF(DATA!K57=0,\" \",DATA!K57)","v":" "}," "]
[null,"LODGING",null,null,{"$f":"IF(DATA!E58=0,\" \",DATA!E58)","v":" "},{"$f":"IF(DATA!F58=0,\" \",DATA!F58)","v":" "},{"$f":"IF(DATA!G58=0,\" \",DATA!G58)","v":" "},{"$f":"IF(DATA!H58=0,\" \",DATA!H58)","v":" "},{"$f":"IF(DATA!I58=0,\" \",DATA!I58)","v":" "},{"$f":"IF(DATA!J58=0,\" \",DATA!J58)","v":" "},{"$f":"IF(DATA!K58=0,\" \",DATA!K58)","v":" "}," "]
[null,"AUTO RENTAL",null,null,{"$f":"IF(DATA!E59=0,\" \",DATA!E59)","v":" "},{"$f":"IF(DATA!F59=0,\" \",DATA!F59)","v":" "},{"$f":"IF(DATA!G59=0,\" \",DATA!G59)","v":" "},{"$f":"IF(DATA!H59=0,\" \",DATA!H59)","v":" "},{"$f":"IF(DATA!I59=0,\" \",DATA!I59)","v":" "},{"$f":"IF(DATA!J59=0,\" \",DATA!J59)","v":" "},{"$f":"IF(DATA!K59=0,\" \",DATA!K59)","v":" "}," "]
[null,"PARKING / TOLLS / GAS",null,null,{"$f":"IF(DATA!E60=0,\" \",DATA!E60)","v":" "},{"$f":"IF(DATA!F60=0,\" \",DATA!F60)","v":" "},{"$f":"IF(DATA!G60=0,\" \",DATA!G60)","v":" "},{"$f":"IF(DATA!H60=0,\" \",DATA!H60)","v":" "},{"$f":"IF(DATA!I60=0,\" \",DATA!I60)","v":" "},{"$f":"IF(DATA!J60=0,\" \",DATA!J60)","v":" "},{"$f":"IF(DATA!K60=0,\" \",DATA!K60)","v":" "}," "]
[null,"TAXI",null,null,{"$f":"IF(DATA!E61=0,\" \",DATA!E61)","v":" "},{"$f":"IF(DATA!F61=0,\" \",DATA!F61)","v":" "},{"$f":"IF(DATA!G61=0,\" \",DATA!G61)","v":" "},{"$f":"IF(DATA!H61=0,\" \",DATA!H61)","v":" "},{"$f":"IF(DATA!I61=0,\" \",DATA!I61)","v":" "},{"$f":"IF(DATA!J61=0,\" \",DATA!J61)","v":" "},{"$f":"IF(DATA!K61=0,\" \",DATA!K61)","v":" "}," "]
[null,"TELEPHONE / FAX",null,null,{"$f":"IF(DATA!E62=0,\" \",DATA!E62)","v":" "},{"$f":"IF(DATA!F62=0,\" \",DATA!F62)","v":" "},{"$f":"IF(DATA!G62=0,\" \",DATA!G62)","v":" "},{"$f":"IF(DATA!H62=0,\" \",DATA!H62)","v":" "},{"$f":"IF(DATA!I62=0,\" \",DATA!I62)","v":" "},{"$f":"IF(DATA!J62=0,\" \",DATA!J62)","v":" "},{"$f":"IF(DATA!K62=0,\" \",DATA!K62)","v":" "}," "]
[null,"MISC. / CK REQUEST ( explain below)",null,null,{"$f":"IF(DATA!E63=0,\" \",DATA!E63)","v":" "},{"$f":"IF(DATA!F63=0,\" \",DATA!F63)","v":" "},{"$f":"IF(DATA!G63=0,\" \",DATA!G63)","v":" "},{"$f":"IF(DATA!H63=0,\" \",DATA!H63)","v":" "},{"$f":"IF(DATA!I63=0,\" \",DATA!I63)","v":" "},{"$f":"IF(DATA!J63=0,\" \",DATA!J63)","v":" "},{"$f":"IF(DATA!K63=0,\" \",DATA!K63)","v":" "}," "]
[null,"TOTAL EXPENSES",null,null,{"$f":"+IF(SUM(E19:E29)=0,\" \",SUM(E19:E29))","v":" "},{"$f":"+IF(SUM(F19:F29)=0,\" \",SUM(F19:F29))","v":" "}," "," "," "," "," "," "]
[]
[null,"EXPLANATION OF BUSINESS ENTERTAINMENT (ATTACH SEPARATE SHEET IF MORE SPACE IS REQUIRED)"]
[null,"DATE","PLACE","TYPE","BUSINESS PURPOSE",null,null,"NAMES, TITLES, & CO. AFFILIATION",null,null,null,"AMOUNT"]
[null,{"$f":"IF(DATA!B68=0,\" \",DATA!B68)","v":" "},{"$f":"+DATA!C68","v":0},{"$f":"+DATA!D68","v":0},{"$f":"+DATA!E68","v":0},null,null,{"$f":"+DATA!H68","v":0},null,null,null,{"$f":"IF(DATA!L68=0,\" \",DATA!L68)","v":" "}]
[null,{"$f":"IF(DATA!B69=0,\" \",DATA!B69)","v":" "},{"$f":"+DATA!C69","v":0},{"$f":"+DATA!D69","v":0},{"$f":"+DATA!E69","v":0},null,null,{"$f":"+DATA!H69","v":0},null,null,null,{"$f":"IF(DATA!L69=0,\" \",DATA!L69)","v":" "}]
[null,{"$f":"IF(DATA!B70=0,\" \",DATA!B70)","v":" "},{"$f":"+DATA!C70","v":0},{"$f":"+DATA!D70","v":0},{"$f":"+DATA!E70","v":0},null,null,{"$f":"+DATA!H70","v":0},null,null,null,{"$f":"IF(DATA!L70=0,\" \",DATA!L70)","v":" "}]
[null,{"$f":"IF(DATA!B71=0,\" \",DATA!B71)","v":" "},{"$f":"+DATA!C71","v":0},{"$f":"+DATA!D71","v":0},{"$f":"+DATA!E71","v":0},null,null,{"$f":"+DATA!H71","v":0},null,null,null,{"$f":"IF(DATA!L71=0,\" \",DATA!L71)","v":" "}]
[]
[null,"EXPLANATION OF MISC. / CK REQUEST EXPENDITURES",null,null,null,null,null,"EXPENSE DISTRIBUTION"]
[null,"DATE","EXPLANATION",null,null,"AMOUNT",null,"SOURCE #","DEPT. #","CODE","\" L \"  #","AMOUNT"]
[null,{"$f":"IF(DATA!B75=0,\" \",DATA!B75)","v":" "},{"$f":"IF(DATA!C75=0,\" \",DATA!C75)","v":" "},null,null,{"$f":"IF(DATA!F75=0,\" \",DATA!F75)","v":" "},null,{"$f":"IF(DATA!B82=0,\" \",DATA!B82)","v":" "},{"$f":"IF(DATA!C82=0,\" \",DATA!C82)","v":" "},{"$f":"IF(DATA!D82=0,\" \",DATA!D82)","v":" "},{"$f":"IF(DATA!E82=0,\" \",DATA!E82)","v":" "},{"$f":"IF(DATA!F82=0,\" \",DATA!F82)","v":" "}]
[null,{"$f":"IF(DATA!B76=0,\" \",DATA!B76)","v":" "},{"$f":"IF(DATA!C76=0,\" \",DATA!C76)","v":" "},null,null,{"$f":"IF(DATA!F76=0,\" \",DATA!F76)","v":" "},null,{"$f":"IF(DATA!B83=0,\" \",DATA!B83)","v":" "},{"$f":"IF(DATA!C83=0,\" \",DATA!C83)","v":" "},{"$f":"IF(DATA!D83=0,\" \",DATA!D83)","v":" "},{"$f":"IF(DATA!E83=0,\" \",DATA!E83)","v":" "},{"$f":"IF(DATA!F83=0,\" \",DATA!F83)","v":" "}]
[null,{"$f":"IF(DATA!B77=0,\" \",DATA!B77)","v":" "},{"$f":"IF(DATA!C77=0,\" \",DATA!C77)","v":" "},null,null,{"$f":"IF(DATA!F77=0,\" \",DATA!F77)","v":" "},null,{"$f":"IF(DATA!B84=0,\" \",DATA!B84)","v":" "},{"$f":"IF(DATA!C84=0,\" \",DATA!C84)","v":" "},{"$f":"IF(DATA!D84=0,\" \",DATA!D84)","v":" "},{"$f":"IF(DATA!E84=0,\" \",DATA!E84)","v":" "},{"$f":"IF(DATA!F84=0,\" \",DATA!F84)","v":" "}]
[null,{"$f":"IF(DATA!B78=0,\" \",DATA!B78)","v":" "},{"$f":"IF(DATA!C78=0,\" \",DATA!C78)","v":" "},null,null,{"$f":"IF(DATA!F78=0,\" \",DATA!F78)","v":" "},null,{"$f":"IF(DATA!B85=0,\" \",DATA!B85)","v":" "},{"$f":"IF(DATA!C85=0,\" \",DATA!C85)","v":" "},{"$f":"IF(DATA!D85=0,\" \",DATA!D85)","v":" "},{"$f":"IF(DATA!E85=0,\" \",DATA!E85)","v":" "},{"$f":"IF(DATA!F85=0,\" \",DATA!F85)","v":" "}]
[]
[null,"CASH SUMMARY"]
[null,null,null,null,null,null,null,"CLASSIFICATION:",null,{"$f":"IF(DATA!E28=\"X\",DATA!D28,IF(DATA!E29=\"X\",DATA!D29,IF(DATA!E30=\"X\",DATA!D30,IF(DATA!E31=\"X\",DATA!D31,\" \"))))","v":" "}]
[null,"CASH ADVANCED",null,null,{"$f":"IF(DATA!E90=0,\" \",DATA!E90)","v":" "}]
[null,"CASH EXPENSE",null,null,{"$f":"+L30","v":" "},null,null,"SIGNATURE:",null,{"$f":"IF(SUM(L13:L30)=0,\"ERROR - EXPENSE AREA NOT FILLED IN\",\" \")","v":"ERROR - EXPENSE AREA NOT FILLED IN"}]
[null,"BALANCE",null,null,{"$f":"+DATA!E92","v":0}]
[null,null,null,null,null,null,null,"APPROVED BY:"]
[]
[null,"AUDITED BY:",null,null,null,null,null,"APPROVED BY:"]

{"sheet":"PROCEDURES","index":2,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["BERKSHIRE COMMUNITY COLLEGE - "]
[]
["Travel Reimbursement - "]
[null,"Complete Expense Voucher/Ck Request Form."]
[null,null,"Include Source of Funds (SOF) & Department to be charged."]
[null,null,"Signature of traveler, required."]
[null,null,"Signature of Div/Dept Head, required."]
[null,"Attach original receipts."]
[]
["Check Request -"]
[null,"To reimburse an employee:"]
[null,null,"Complete Expense Voucher/Ck Request Form."]
[null,null,null,"Include Source of Funds (SOF) & Department to be charged."]
[null,null,null,"Signature of person being reimbursed, required."]
[null,null,null,"Signature of Div/Dept Head, required."]
[null,null,"Attach original receipts."]
[]
[null,"To pay a vendor for goods:"]
[null,null,null,"Complete Expense Voucher/Ck Request Form after goods have been received."]
[null,null,null,null,"Include Source of Funds (SOF) & Department to be charged."]
[null,null,null,null,"Signature of Div/Dept Head, required."]
[null,null,null,"Attach original receipts/invoice."]
[]
[null,"To pay an individual or a vendor for services rendered:"]
[null,null,"Before any service is provided, complete Commonwealth of Massachusetts Standard Contract Form (Shared Drive/Forms Folder/Contract-T&C-W9)."]
[null,null,null,"Complete an Expense Voucher/Ck Request Form after services are complete."]
[null,null,null,null,"Signature of Div/Dept Head, required."]
[null,null,null,"Attach approved invoice and send to the business office."]

{"sheet":"MILEAGE GUIDE","index":3,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,"NOTE:","BELOW MILEAGE IS FOR ROUND TRIP TRAVEL"]
[]
[null,"STANDARD MILEAGE FROM PITTSFIELD COMMUNITY AND STATE COLLEGES"]
[]
[null,"BRISTOL",null,null,null,null,"NORTHERN ESSEX"]
[null,null,"Fall River ",". . . . . . . . . . . . . . . . . . . . . . . . . . .",null,328,null,"Haverhill  . . . . . . . . . . . . . . . . . . . . . . . .",null,316]
[null,null,"New Bedford . . . . . . . . . . . . . . . . . . . . ",null,null,342,null,"Lawrence . . . . . . . . . . . . . . . . . . ",null,302]
[null,"BUNKER HILL ",null,null,null,null,"WORCESTER"]
[null,null,"Boston . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,285,null,"Quinsigamond  . . . . . . . . . . . . .",null,215]
[null,"CAPE COD",null,null,null,null,"ROXBURY . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,274]
[null,null,"West Barnstable. . . . . . . . . . . . . . . . . . . . ",null,null,400]
[null,"RHODE ISLAND",null,null,null,null,"SPRINGFIELD"]
[null,null,"Rhode Island  . . . . . . . . . . . . . . . . . . . . . . ",null,null,285,null,"Springfield Technical . . . . . . . . ",null,117]
[null,"GREENFIELD",null,null,null,null,"UMASS"]
[null,null,"Greenfield Community College. . . . . . . . . . . . . . . . . . . . . ",null,null,114,null,"Amherst . . . . . . . . . . . . . . . . . . .",null,105]
[null,"HOLYOKE"]
[null,null,"Holyoke Community College. . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,107,"AIRPORTS"]
[null,"MASSACHUSETTS BAY",null,null,null,null,null,"Albany Airport . . . . . . . . . . . . . .",null,101]
[null,null,"Wellesley Hills . . . . . . . . . . . . . . . . . . . . . . .",null,null,250,null,"Bradley Airport . . . . . . . . . . . . . ",null,146]
[null,null,"Framingham . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,236,null,"JFK Airport . . . . . . . . . . . . . . . . .",null,322]
[null,"MASSACHUSETTS COLLEGE OF LIBERAL ARTS",null,null,null,null,null,"LaGuardia Airport . . . . . . . . . . .",null,314]
[null,null,"North Adams . . . . . . . . . . . . . . . . . . . . . . . .",null,null,52,null,"Logan Airport . . . . . . . . . . . . . . .",null,290]
[null,"MASSAOIT",null,null,null,null,"HOSPITALS"]
[null,null,"Brockton . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,306,null,"Berkshire Medical  . . . . . . . . .",null,9]
[null,null,"Canton  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,296,null,"Fairview Hospital  . . . . . . . . . . . ",null,42]
[null,"MIDDLESEX",null,null,null,null,null,"Hillcrest Hospital. . . . . . . . . . . .",null,4]
[null,null,"Bedford  . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,280,null,"North Adams Regional . . . . . . .",null,44]
[null,null,"Lowell . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,280]
[null,"MOUNT WACHUSETT"]
[null,null,"Gardner  . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,200]
[null,"NORTH SHORE"]
[null,null,"Beverly . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,330]
[null,null,"Danvers  . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,320]
[]
[]
[]
[null,"Other mileage information may be obtained from Yahoo.maps.com or Mapquest.com"]

{"sheet":"POLICY","index":4,"n_rows":244,"n_cols":7,"rows_kept":244,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,9],[2,0,2,9],[3,0,3,9],[4,0,4,9],[5,0,5,9],[12,0,12,9],[13,0,13,9],[14,0,14,9],[15,0,15,9],[16,0,16,9],[17,0,17,9],[6,0,6,9],[7,0,7,9],[8,0,8,9],[9,0,9,9],[10,0,10,9],[11,0,11,9],[25,0,25,9],[26,0,26,9],[27,0,27,9],[28,1,28,9],[29,1,29,9],[30,0,30,9],[18,0,18,9],[19,0,19,9],[20,0,20,9],[21,0,21,9],[22,0,22,9],[24,0,24,8],[37,7,37,9],[38,7,38,9],[39,7,39,9],[40,0,40,9],[41,7,41,9],[42,7,42,9],[31,0,31,9],[32,1,32,9],[33,1,33,9],[34,1,34,9],[35,0,35,9],[36,0,36,3],[36,7,36,9],[49,0,49,9],[50,0,50,9],[51,0,51,9],[52,0,52,9],[53,0,53,9],[54,0,54,9],[43,7,43,9],[44,7,44,9],[45,0,45,9],[46,0,46,9],[47,0,47,16383],[48,0,48,9],[61,0,61,9],[62,0,62,9],[63,0,63,9],[64,0,64,9],[65,0,65,9],[66,0,66,9],[55,0,55,9],[56,0,56,9],[57,0,57,9],[58,0,58,9],[59,0,59,9],[60,0,60,9],[74,0,74,9],[75,0,75,9],[76,0,76,9],[77,0,77,9],[78,1,78,9],[79,1,79,9],[68,0,68,16383],[69,1,69,9],[70,1,70,9],[71,1,71,9],[72,1,72,9],[73,0,73,9],[86,1,86,9],[87,0,87,9],[88,0,88,9],[89,0,89,9],[90,0,90,9],[91,0,91,9],[80,1,80,9],[81,1,81,9],[82,1,82,9],[83,1,83,9],[84,1,84,9],[85,1,85,9],[98,0,98,9],[99,0,99,9],[100,0,100,9],[101,0,101,9],[102,0,102,9],[103,0,103,9],[92,0,92,9],[93,0,93,9],[94,0,94,9],[95,0,95,9],[96,0,96,9],[97,0,97,9],[110,0,110,9],[112,0,112,9],[113,0,113,9],[114,0,114,9],[115,0,115,9],[116,0,116,9],[104,0,104,9],[105,0,105,9],[106,0,106,9],[107,0,107,9],[108,0,108,9],[109,0,109,9],[126,0,126,9],[127,0,127,9],[129,0,129,9],[130,0,130,9],[131,0,131,9],[132,0,132,9],[118,0,118,9],[119,0,119,9],[120,0,120,9],[122,0,122,9],[124,0,124,9],[125,0,125,9],[140,0,140,9],[141,0,141,9],[142,0,142,9],[143,0,143,9],[144,0,144,9],[145,0,145,9],[133,0,133,8],[134,0,134,9],[136,0,136,9],[137,0,137,9],[138,0,138,9],[139,0,139,9],[157,0,157,16383],[158,0,158,16383],[159,0,159,16383],[161,0,161,16383],[162,0,162,16383],[163,0,163,16383],[146,0,146,9],[147,0,147,9],[148,0,148,9],[149,0,149,9],[150,0,150,9],[151,0,151,9],[171,0,171,9],[177,1,177,9],[178,0,178,9],[179,0,179,9],[180,1,180,9],[181,0,181,9],[164,0,164,16383],[165,0,165,16383],[166,0,166,16383],[167,0,167,16383],[169,0,169,9],[170,0,170,9],[189,0,189,9],[190,0,190,9],[191,0,191,9],[192,0,192,9],[193,0,193,9],[194,0,194,9],[182,0,182,9],[183,0,183,9],[185,0,185,9],[186,0,186,9],[187,0,187,9],[188,0,188,9],[202,0,202,9],[203,0,203,9],[204,0,204,9],[205,0,205,9],[206,0,206,9],[207,0,207,9],[195,0,195,9],[196,0,196,9],[197,0,197,9],[198,0,198,9],[200,0,200,9],[201,0,201,9],[215,0,215,9],[216,0,216,9],[217,0,217,9],[218,0,218,9],[219,0,219,9],[220,0,220,9],[208,0,208,9],[209,0,209,9],[210,0,210,9],[211,0,211,9],[212,0,212,9],[213,0,213,9],[227,0,227,9],[228,0,228,9],[229,0,229,9],[230,1,230,9],[231,1,231,9],[232,0,232,9],[221,0,221,9],[222,0,222,9],[223,0,223,9],[224,0,224,9],[225,0,225,9],[226,0,226,9],[239,0,239,9],[240,0,240,9],[241,0,241,9],[242,0,242,9],[243,0,243,9],[233,1,233,9],[234,1,234,9],[235,0,235,9],[236,0,236,9],[237,0,237,9],[238,0,238,9]]}
[]
["TABLE OF CONTENTS"]
[]
["Travel-at-a-Glance"]
["One Way Mileage from Pittsfield"]
["Massachusetts Turnpike Schedule"]
["Travel Request"]
["Prepayments v. Reimbursements"]
["Blanket Travel"]
["Travel Voucher"]
["Mileage Reimbursement"]
["Toll Reimbursement"]
["Parking Reimbursement"]
["Meal Reimbursement"]
["Meal Schedules"]
["Conference Meals"]
["Hotels"]
["Conference/Registration Fees"]
["Business Reimbursements"]
["Advances"]
["Summary"]
["South County Reimbursement"]
[]
[]
[]
["TRAVEL-AT-A-GLANCE"]
[]
["REIMBURSEMENT PROCEDURE:   There are 2 forms used for reimbursement.  "]
[1,"Travel Request Form"]
[2,"FY21 On-Line Expense Voucher_Check Request Form "]
[]
["IMPORTANT:"]
[1,"Submit a SIGNED and DATED Travel Request PRIOR to your trip"]
[2,"Submit a SIGNED AND DATED Travel Form  when you return (located in the forms directory on the shared drive)."]
[3,"Attach all ORIGINAL RECEIPTS for requested reimbursement."]
[]
["REIMBURSEMENT SCHEDULE:",null,null,null,"MILEAGE","PARKING","TOLLS"]
["MCCC Unit Employees",null,null,null,0.65500000000000003,"Yes","Yes"]
["AFSCME Unit Employees",null,null,null,0.65500000000000003,"Yes","Yes"]
["Non-Unit Professionals",null,null,null,0.65500000000000003,"Yes","Yes"]
[]
[null,null,null,null,"BREAKFAST","LUNCH","DINNER"]
["MCCC Unit Employees",null,null,null,7.5,12.5,20]
["AFSCME Unit Employees",null,null,null,8,12.5,20]
["Non-Unit Professionals",null,null,null,7.5,12.5,20]
[]
["LACK OF DATES AND SIGNATURES BY THE TRAVELER, THE SUPERVISOR AND/OR "]
["THE COST CENTER HEAD (IF REQUIRED) COULD DELAY REIMBURSEMENT."]
[]
["TRAVEL POLICIES AND PROCEDURES"]
["The following travel procedures have been written to assist you when you travel on college business.  These    "]
["procedures have been designed to comply with state travel regulations that have been recommended or required"]
["by the Department of Personnel Administration, the Office of the State Comptroller, and the Office of the State"]
["Auditor.  We have deliberately attempted to keep the procedures as simple and consistent as possible in"]
["order to relieve you of unnecessary or duplicate paperwork or documentation.  Deviations from individual"]
["procedures exist in reimbursement mainly because of contractual differences."]
[]
["TRAVEL REQUEST"]
["Before leaving on your trip, you must submit a completed travel request to the Business Office even if there"]
["are no travel expenses related to this trip.  Failure to submit this form may hinder potential insurance claims."]
["A single travel request form may be used for each trip regardless of the number of travelers; however, all"]
["travelers must be listed on the travel request form.  (Attach an additional sheet if necessary).  "]
["The traveler's supervisor or department chair must sign the travel request.  If travel expenses are involved, "]
["the cost center head whose budget will pay the travel expenses must also sign the travel request.  The person "]
["to whom reimbursement will be made should be listed first on the travel request form.  The President must   "]
["approve all International travel."]
[]
[]
["PREPAYMENTS vs. REIMBURSEMENTS"]
[null,"You may elect to prepay the following travel expenses using a Check Request Form (On-line):"]
["·","Conference/Registration Fees"]
["·","Airfare"]
["·","Hotel"]
["The on-line Check Request form must be accompanied by an invoice or registration form and must be payable to "]
["the vendor(s).  Prepayment is an option and not a requirement.  For more information regarding a particular expense,"]
["please refer to the appropriate subheading listed under \"Travel Related Expenses.\""]
[]
["The following travel expenses are reimbursed using the On-line Travel or Multi-Travel Voucher form:"]
["·","Mileage"]
["·","Tolls"]
["·","Parking"]
["·","Meals"]
["·","Lodging"]
["·","Auto Rental"]
["·","Taxi"]
["·","Train"]
["·","Other"]
["The travel voucher should be submitted to the Business Office (with appropriate documentation"]
["attached).  For more information regarding a particular expense, please refer to the appropriate"]
["subheading listed under \"Travel Related Expenses\"."]
[]
["BLANKET TRAVEL REQUEST"]
["If you travel regularly for a singular purpose (e.g. local high schools for recruitment, monthly meetings with  "]
["colleagues etc.), you may submit a Blanket Travel Request form to the Business Office to cover"]
["all trips for a fiscal year.  Under \"Dates of Travel\", indicate July 1, 20_ through June 30, 20_.  A travel "]
["expense voucher must be submitted for each trip or each week.  A new Blanket travel request must be submitted  for each fiscal year.  "]
["A \"Blanket Travel Request\" may not be submitted for Out-of-State travel."]
[]
["TRAVEL VOUCHER"]
["Once the travel voucher has been signed and dated by the traveler and approved by the cost center head from whose budget  "]
["the reimbursement will be paid, submit it to the Business Office.  "]
[]
["TRAVEL RELATED EXPENSES"]
["Mileage"]
["Mileage is reimbursed at the rate of $.655 per mile (effective 07/01/2022).  Mileage is reimbursed from campus to destination and back, "]
["or from point of origin (i.e., home) to destination and back, whichever is shorter.  Round-trip standard"]
["mileage rates (SMR) have been established to certain destinations from Pittsfield.  Actual mileage reimbursement"]
["is based on the state mileage guide.  A variance of 10 miles to the destination and 10 miles on the return trip"]
["(a total of 20 miles) is acceptable except to designated destinations listed on the reverse side of the travel request"]
["and travel voucher.  A condensed mileage guide for travel from Pittsfield to other cities and towns within  "]
["Massachusetts can be found on the online Expense Voucher_Check Request File under the mileage guide tab."]
[]
["Tolls"]
["Non-unit professional and MCCC unit employees are eligible for reimbursement of tolls.  Please refer to the toll  "]
["calculator for toll charges on the Massachusetts Turnpike.   Receipts are not required for toll expenses incurred "]
["on the Massachusetts Turnpike, however, receipts or other proof of payment must accompany reimbursement "]
["for other toll roads."]
[]
["Parking"]
["Non-UNIT PROFESSIONAL, MCCC, and AFSCME employees are eligible for reimbursement of parking.   "]
["Receipts for parking must be attached to the Travel Voucher."]
[]
["Meals"]
[]
["ONE DAY TRAVEL FOR AFSCME"]
["If you travel for less than 24 hours commencing two or more hours before compensated time, you are entitled to the"]
["breakfast allowance listed below.  If you travel for less than 24 hours and complete travel two or more hours after"]
["compensated time, you shall be entitled to the dinner allowance."]
[]
["MULTI DAY TRAVEL"]
["On the first day of travel in excess of 24 hours, breakfast will not be reimbursed if travel commences after 6:00 a.m.  "]
["Lunch will not be reimbursed if travel commences after noon, and dinner will not be reimbursed if travel commences"]
["after 10:00 p.m.  On the last day of travel that has exceeded 24 hours, breakfast will not be reimbursed if travel"]
["ends before 6:00 a.m., lunch will not be reimbursed if travel ends before noon; and dinner will not be reimbursed"]
["if travel ends before 6:00 p.m."]
[]
["AFSCME SCHEDULES"]
["Section 1.  Mileage"]
["A.    When an employee is authorized to use his/her personal automobile for travel related to his or her employment  "]
["        he/she shall be reimbursed at the Internal Revenue Service rate as such rate is designated from time to time.  "]
["        Employees will be reimbursed for reasonably costs of tolls and parking."]
["B.    An employee who travels from his/her home to a temporary assignment rather than to his/her regularly assigned "]
["        office shall be allowed transportation expenses for the distance between his/her home and his/her temporary "]
["        assignment whichever is less."]
["C.    Employees shall not be reimbursed for commuting between their home and office or other regular work location.  "]
["        With  approval of the Personnel Administrator an employee's home may be designated as his/her regular office "]
["        by his/her CEO for the purpose of allowed transportation expenses in cases where the employee has no regular "]
["        office or other regular work location."]
["Section 2.  Travel"]
["A.    An employee who is assigned to duty that  requires him/her to be absent from his/her home for more than "]
["        twenty-four (24) hours shall be reimbursed for reasonable charges for lodging including reasonable tips and for "]
["        the following amounts:"]
[null," Meals",null,null,"       Maximum Allowance",null,"Applicable"]
[null,"Breakfast",null,null,8,null,"3:01 am to 9:01 am"]
[null,"Lunch",null,null,12.5,null,"9:01 am to 3:01 pm"]
[null,"Dinner",null,null,20,null,"3:01 pm to 9:01 pm"]
[]
["B.    On the first day of assignment to duty in excess of twenty-four (24) hours, employees shall not be compensated for"]
["       breakfast if such assignment commences after six (6:00) a.m., for lunch if such assignment commences after noon "]
["        or for dinner if such assignment commences after ten (10:00) p.m."]
[]
["C.    On the last day of assignment to duty in excess of twenty-four (24) hours employees shall not be reimbursed for "]
["        breakfast if such assignment ends before six (6:00) a.m., for lunch if such assignment ends before noon or for "]
["       dinner if such assignment ends before six (6:00) p.m."]
["D.   For travel of less than twenty-four (24) hours commencing two (2) hours or more before compensated time, "]
["       employees shall be entitled to the above breakfast allowance.  For travel less than twenty-four (24) hours ending  "]
["       two (2) hours or more after compensated time employees shall be entitled to the above dinner allowance.  "]
["       Employees are not entitled to the above lunch allowance for travel of less than twenty-four (24) hours."]
[]
["MCCC UNIT MEMBERS/NON-UNIT MEMBERS"]
["The actual schedule for meal reimbursement not to exceed the following for MCCC unit employees and NON-UNIT  "]
["professionals within applicable times is:"]
[null," Meals",null,null,"       Maximum Allowance",null,"Applicable"]
[null,"Breakfast",null,null,7.5,null,"3:01 am to 9:01 am"]
[null,"Lunch",null,null,12.5,null,"9:01 am to 3:01 pm"]
[null,"Dinner",null,null,20,null,"3:01 pm to 9:01 pm"]
[]
[3,"Hourly Employees"]
["Employees not covered under a collective bargaining agreement will be reimbursed at the rate for their respective "]
["classification. "]
[4,"Students"]
["Students will be reimbursed for meals at the discretion of the cost center head from whose budget the "]
["reimbursement(s) will be paid.  Meal reimbursements shall not exceed the schedule for AFSCME/MCCC unit "]
["employees.  Please refer to the appropriate contract for further clarification."]
[]
[]
["CONFERENCE MEALS"]
["If a meal that is within the official function of the conference is not included in  your registration fee (recognition "]
["dinner, luncheon with speaker, etc.); you will be reimbursed for the cost of the meal.  A receipt must be attached  "]
[" to the Travel Voucher in order for a reimbursement to be issued."]
[]
["HOTELS"]
["Receipts for hotels must be attached to the Travel Voucher.  Reimbursement for personal expenses such as "]
["(e.g. room service) is not permitted.  Telephone calls for business-related purposes will be reimbursed upon "]
["receipt of an itemized bill documenting the date, telephone number, and purpose of call.  Hotels may be prepaid "]
["by submitting an Online Check Request Form to the Business Office.  Please indicate on the Online Check "]
["Request Form the date by which the payment needs to be sent.  If you plan to personally deliver the check to"]
["the hotel, you must give the Business Office the receipts for pre-payment when you pick up the check from the"]
["Business Office.  The Business Office must also be informed of the date the check needs to be ready for. "]
[]
[]
["CONFERENCE/REGISTRATION FEE"]
["Conference or Registration fees may be submitted by attaching a receipt to the Travel Voucher.  Conference "]
["or registration fees may be prepaid by submitting an Online Check Request Form with the registration form "]
["to the Business Office.  Please follow up by submitting original receipts when you receive them.  Also,   "]
["please indicate on the Online Check Request Form the date by which the payment needs to be sent."]
[]
["BUSINESS REIMBURSEMENTS"]
["Reimbursements for business-related purposes over and above the reimbursements described above must be "]
["approved in advance by the Vice President of Administration and Finance. Reimbursements must be documented "]
["with original receipts, a list of the names covered by the reimbursements and the purpose of the meeting, and be"]
["itemized under \"explanation\" on the Online Travel Voucher.  An example of this type of reimbursement would be "]
["taking a guest to lunch.  Reimbursement for tipping and other gratuities shall be limited to not more than 15% "]
["of the bill."]
[]
["ADVANCES"]
["The purpose of an advance is to assist in paying expenses, excepting prepayments associated with a trip."]
["Request for travel advances may be made at the time the Travel Request is submitted to the Business Office"]
["by attaching a completed Check Request Form.    In order to be eligible for an advance, travel expenses "]
["must exceed $100.  Advances will be calculated at 76% of the estimated expenses.  The advance will be "]
["payable to the traveler who will be required to sign for the advance at the Business Office.  Upon return, "]
["receipts documenting expenditure of the advance must be attached to the Travel Voucher and submitted"]
["to the Business Office.  If the actual expenses are less than the advance, a check made payable to Berkshire"]
["Community College for the unspent balance must also be attached to the Travel Voucher.  The"]
["traveler is responsible for repayment of any part of the advance not fully documented.  If two or more people"]
["participate in the same trip, and each person requests an advance, the advances will be issued individually"]
["and each individual will assume the responsibilities stated above."]
[]
["SUMMARY"]
["To prepay a travel expense: "]
[null,"*Travel Request and"]
[null,"*Check Request Form, with an invoice or registration form must be submitted to the Business Office."]
["To receive a reimbursement for travel expenses:"]
[null,"*Travel Request "]
[null,"*Travel Voucher (with receipts)"]
["Once your paperwork is in order, a reimbursement check will be issued to you on the next check warrant.  "]
["Checks are generally run each week on Thursday.  Travel expenses must be submitted for reimbursement within"]
["the fiscal year that the travel has occurred."]
[]
["SOUTH COUNTY CENTER"]
["Mileage reimbursements for employees traveling to and from South County Center may be made on a monthly"]
["or semester basis, depending on your preference.  The Director of South County Center is responsible for "]
["initiating all mileage reimbursements made from the South County budget, including reimbursements for full-time "]
["faculty who teach day classes at both campuses on the same day."]

{"sheet":"PROTECTED SHEET","index":5,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
["The workbook has been protected to avoid accidental overwriting of formulas & to protect cells that should not be altered\nHowever, you can easily unprotect any sheet by going File > Info > Unprotect\nThe password is \"BCC\" (Case Sensitive)"]
[]
["Please note, for general use of the workbook, unprotecting sheets should never be necessary. Removing protection should be reserved to those tasked with updating the workbook\ni.e. the business office."]