Spreadsheet: 216542d1361805050-multiple-sumifs-with-named-table-ranges-budget-ss
Sheet: sample

 | Sample
 | Summary by Account Code |  |  | Transaction [NAME] |  |  |  |  |  |  |  | Reconciled |  |  |  |  | Summary by Program Code
 | Account Code | Total |  | [NAME] | Date | Description | Program Code | Account Code | Expense Actual/Enc | Budget | [NAME] | Cleared Budget | Cleared Actual | Dropped Encumbrance | Encumbranced |  | Program Code | Expense Total | Budget | Period 01 | Period 02 | Period 03 | Period 04 | Period 05 | Period 06 | Period 07 | Period 08 | Period 09 | Period 10 | Period 11 | Period 12 | Remaining Budget
 | 49201 Gifts-Alumni |  |  | Original Budget | 2012-09-01 00:00:00 | FY13 Original Operating Exp Allocation |  | A6300 Operating Expense Budget |  | 300000 |  | Period 01 |  |  |  |  | Comet Card |  | 100
 | 62000 Travel |  |  | Budget Adj. | 2012-09-18 00:00:00 | Budget Adjustment - Journal 430160 |  | A6300 Operating Expense Budget |  | 75810.98 |  | Period 01 |  |  |  |  | [NAME] |  | 10000
 | 62303 Student Travel |  |  | Encumbered | 2012-09-06 00:00:00 | Ricoh - S025115 - Rental - Sept | Rentals - Copier/Faxes | 67004 Rental/Office Equip | 57 |  |  |  | Period 01 | Period 01 | Period 01 |  | Dept of Homeland Security |  | 5000
 | 63001 Consumables |  |  | Encumbered | 2012-11-16 00:00:00 | Ricoh - S025115 - Rental - Oct | Rentals - Copier/Faxes | 67004 Rental/Office Equip | 57 |  |  |  | Period 03 | Period 03 | Period 01 |  | Equipment |  | 100000
 | 63002 General Office Supplies |  |  | Encumbered | 2012-11-16 00:00:00 | Ricoh - S025115 - Rental - Nov | Rentals - Copier/Faxes | 67004 Rental/Office Equip | 57 |  |  |  | Period 03 | Period 03 | Period 01 |  | FM - Building Maintenance |  | 20000
 | 63003 Merchandise-Resale |  |  | Encumbered | 2013-01-23 00:00:00 | Ricoh - S025115 - Rental - Dec | Rentals - Copier/Faxes | 67004 Rental/Office Equip | 57 |  |  |  | Period 05 | Period 05 | Period 01 |  | FM - Key Requests |  | 300
 | 63004 Subscription Svc |  |  | Facilities Management | 2012-09-26 00:00:00 | Key Pad Parts- WO#127138-13 | FM - Building Maintenance | 63012 Agri/Hdwr Suppl/Matl | 2508 |  |  |  | Period 01 |  | Period 01 |  | FM - Name Plates |  | 250
 | 63005 Ctl St Office Supply |  |  | Facilities Management | 2012-09-26 00:00:00 | Key Pad Labor - WO#127138-13 | FM - Building Maintenance | 63012 Agri/Hdwr Suppl/Matl | 35 |  |  |  | Period 01 |  | Period 01 |  | FM - Surplus (Furniture) |  | 500
 | 63006 Central Store Other |  |  | Telecom | 2012-09-19 00:00:00 | Overages | Telecom - Overages | 65010 Commucication-Tolls | 72.57 |  |  |  | Period 01 |  |  |  | Memberships |  | 8000
 | 63010 Food-Other |  |  | Telecom | 2012-09-30 00:00:00 | Cells Monthly Charge | Telecom - Monthly | 65011 Telecom-Other | 270.93 |  |  |  | Period 01 |  |  |  | Miscellaneous Charges |  | 116350
 | 63012 Agri/Hdwr Suppl/Matl |  |  | Facilities Management | 2012-09-26 00:00:00 | Paint and Carpet Suite 4.42A - Material Costs - WO#126921-13 | FM - Building Maintenance | 66003 Main/Repr Bldgs | 43.36 |  |  |  | Period 01 |  |  |  | Office Supplies - General |  | 12000
 | 63013 Parts-Furn & Equip |  |  | Comet Card | 2012-10-25 00:00:00 | Julia Evans - Comet Card | Comet Card | 69022 Comet IDCard Charges | 10 |  |  |  | Period 02 |  |  |  | Office Supplies - Toner |  | 5000
 | 63016 Furn/Eqt N/Cap-Inv |  |  | Postal Services | 2012-10-24 00:00:00 | [NAME] | Postal Services | 69027 Freight/Del Svc | 2.25 |  |  |  | Period 02 |  |  |  | Postal Services |  | 6000
 | 63017 Compu Pts N/Cap-Inv |  |  | Postal Services | 2012-10-31 00:00:00 | Postal Charges - Period 2 | Postal Services | 69028 Postal Services | 244.98 |  |  |  | Period 02 |  |  |  | Print Shop |  | 1500
 | 63021 Pur Comp Sftwr N/Inv |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rentals - Copier/Faxes |  | 11000
 | 63022 Comp Sftw Lic Renewl |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Revenue - Gifts |  | -500
 | 63023 Book/Prerec Ref Mat |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Telecom - Monthly |  | 2500
 | 63026 CE-Fax Machines |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Telecom - Overages |  | 2000
 | 63027 CE-Audio Visuals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Empty
 | 63029 CE-Computers |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Empty
 | 63303 Medical Supplies |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Empty
 | 64005 Water Treatment |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Empty
 | 65001 Telecom-Long Dist |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Empty
 | 65003 Telecom-Line & Equip |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Empty
 | 65004 Telecom-Maint/Repair |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Empty
 | 65005 Telecom-Oth Serv Chg
 | 65009 Communication-Equip
 | 65010 Commucication-Tolls
 | 65011 Telecom-Other
 | 65012 Communication-Tex An
 | 66001 Main/ReprFurn/Equip
 | 66002 Main/Rep Compu Sftwr
 | 66003 Main/Repr Bldgs
 | 66004 Main/Rep Compu Eqpt
 | 67004 Rental/Office Equip
 | 68001 Repro/Printing Svc
 | 69001 Membership Dues
 | 69002 Tuition-Emp Traing
 | 69003 Fees Reg Sem Conf
 | 69006 Fees & Other Charges
 | 69010 UTD-Publications
 | 69022 Comet IDCard Charges
 | 69024 Advertising Services
 | 69025 Business Cards
 | 69027 Freight/Del Svc
 | 69028 Postal Services
 | 69029 Pur/Contract Svc
 | 69038 Meals & Conferences
 | 69041 Meet Conf Seminars
 | 69042 UTD Media Services
 | 69043 Field Trip Expenses
 | 69044 Relocation Services
 | 82010 Equipment
 | A6300 Operating Expense Budget
 |  |  |  | Totals