tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 803892d1667781316-true-false-formula-based-on-date-and-seq-number-sample
Sheet: STCM

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cond. [NAME] | ErrorCount | Show ErrorCount
 |  | Short Term Countermeasure Details |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Document Tracking # |  |  |  |  | MFG Date |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | Qty NG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Raw NG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Finis NG
 |  |  | Temporary Countermeasure Plan |  |  |  |  |  |  |  |  | MFG Date |  |  |  |  |  |  |  |  |  | Qty
 |  |  | 1. Green Days Ahead 2. Lets Go 3. Ready To get this to the next level and lets go to get this over to the next line for review |  |  |  |  |  |  |  |  | 2022-10-04 00:00:00 |  |  |  |  |  |  |  |  |  | Raw
 |  |  |  |  |  |  |  |  |  |  |  | Qty NG |  |  | Qty Insp |  |  |  |  |  |  | Finis
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 32 |  |  |  |  |  |  | Line
 |  |  |  |  |  |  |  |  |  |  |  | Raw Material NG |  |  | Raw Material Qty Insp |  |  |  |  |  |  | Buffer
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 32 |  |  |  |  |  |  | Stores
 |  |  |  |  |  |  |  |  |  |  |  | Finished Goods NG |  |  | Finished Goods Qty Insp |  |  |  |  |  |  | Supplier
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 32 |  |  |  |  |  |  | Implement.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | STCMParts
 |  |  |  |  |  |  |  |  |  |  |  | Line Side |  | Buffer |  | Stores |  | Supplier |  |  |  | Effective
 |  |  |  |  |  |  |  |  |  |  |  | Yes |  | No |  | No |  | Yes
 | Implemenation Date |  |  |  | ID for STCM Parts |  |  | Effective Arrival Date
 | 2022-05-20 00:00:00 |  |  |  | 20221212-123 |  |  | 2022-05-20 00:00:00
Spreadsheet: daren_farmer__6652__Gas Assets Ops 03-00 Prelim O&M
Sheet: 2940 - Global Facilities Tx Ops

2940 |  |  |  |  |  |  |  |  |  |  |  |  |  | ASSOCHC | TOTAL_HEADCOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ALYSTHC | 2000-01-01 00:00:00 |  | 2000-02-01 00:00:00 |  | 2000-03-01 00:00:00 |  | 2000-04-01 00:00:00 |  | 2000-05-01 00:00:00 |  | 2000-06-01 00:00:00 |  | 2000-07-01 00:00:00 |  | 2000-08-01 00:00:00 |  | 2000-09-01 00:00:00 |  | 2000-10-01 00:00:00 |  | 2000-11-01 00:00:00 |  | 2000-12-01 00:00:00
 |  | ACTUAL |  | PLAN2000 |  |  |  | ACTUAL |  | PLAN2000
 |  | M.PER |  | M.PER |  |  |  | M.YTD |  | M.YTD |  |  |  |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER
 |  |  |  |  |  | Monthly |  |  |  |  |  | YTD |  |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
 |  | Actual |  | Plan |  | [NAME] |  | Actual YTD |  | Plan YTD |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | Direct Expense:
TOT_COMP | Compensation |  |  |  |  |  |  |  |  |  |  |  |  | Headcount
[NAME] | Benefits and Payroll Taxes |  |  |  |  |  |  |  |  |  |  |  |  | Analysts and Associates
TOT_EMP_EXP | Employee Expenses
TOT_RECRUITING | Recruiting & Relocations
TOT_OSIDE_SERV | Outside Services |  |  |  |  |  |  |  |  |  |  |  |  | Direct Expense:
[NAME] | Supplies and Expense |  |  |  |  |  |  |  |  |  |  |  |  | Compensation
TOT_MKT | Marketing |  |  |  |  |  |  |  |  |  |  |  |  | Benefits and Payroll Taxes
TOT_CHAR_CONT | Charitable Contributions |  |  |  |  |  |  |  |  |  |  |  |  | Employee Expenses
TOT_RENT | Rent (3rd Party) |  |  |  |  |  |  |  |  |  |  |  |  | Recruiting & Relocations
TOT_TECH | Technology |  |  |  |  |  |  |  |  |  |  |  |  | Outside Services
TOT_TRANS | Transportation |  |  |  |  |  |  |  |  |  |  |  |  | Supplies and Expense
CORP_IT | Corporate IT |  |  |  |  |  |  |  |  |  |  |  |  | Marketing
CORP_RENT | Corporate Rent |  |  |  |  |  |  |  |  |  |  |  |  | Charitable Contributions
TOT_OTH_EXP | Other Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Rent (3rd Party)
[NAME] | Taxes Other Than Income |  |  |  |  |  |  |  |  |  |  |  |  | Technology
[PHONE] | Capital Allocation |  |  |  |  |  |  |  |  |  |  |  |  | Transportation
TOT_DEP_AMOR | Depreciation & Amortization |  |  |  |  |  |  |  |  |  |  |  |  | Corporate IT
 | Total Direct Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Corporate Rent
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Other Expenses
9230999860 | Allocated Intercompany Billings |  |  |  |  |  |  |  |  |  |  |  |  | Taxes Other Than Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Capital Allocation
 | Net Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Depreciation & Amortization
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Direct Expenses
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Allocated Intercompany Billings
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Net Expenses
Spreadsheet: 135509d1326106600-lookup-help-2012-staff-planner-test
Sheet: PLANNER 

ID | First name | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F
 |  | 2013-02-01 00:00:00 | 2013-02-02 00:00:00 | 2013-02-03 00:00:00 | 2013-02-04 00:00:00 | 2013-02-05 00:00:00 | 2013-02-06 00:00:00 | 2013-02-07 00:00:00 | 2013-02-08 00:00:00 | 2013-02-09 00:00:00 | 2013-02-10 00:00:00 | 2013-02-11 00:00:00 | 2013-02-12 00:00:00 | 2013-02-13 00:00:00 | 2013-02-14 00:00:00 | 2013-02-15 00:00:00
1 | sean |  |  |  |  |  |  |  |  |  | hh | hh | h
2 | [NAME] | h |  | h |  | h | h | h | h | h
3 | [NAME]
4 | wayne | h | h | h | h | h | h |  |  | h | h | h | h
5 | bob
6 | [NAME]
7 | Mark |  |  | hh |  |  | h |  |  |  | hh |  |  |  | hh
8 | [NAME]
9 | [NAME] |  |  |  | h | h |  | h |  |  | h | h
10 | [NAME]
11 | Stuart |  |  |  |  |  |  | h | h | h | h | hh | h
12 | [NAME] |  |  |  | h
13 | [NAME]
14 | [NAME] |  |  |  |  |  | h |  |  | hh |  |  | h
15 | Reece
16 | Stand
 | enter id no |  |  | total days holiday booked
 | 1 | 10-02-13 / 11-02-13 / 12-02-13
Spreadsheet: daren_farmer__5804__HoursSurvey_May_SenSp
Sheet: Hours

 | 1497
 | Senior Specialist
RC | Position | Activity Name | Last Month | Hours
1497 | Senior Specialist | Customer Service | 45.76 | 15
1497 | Senior Specialist | Daily Trader/Originator Support | 41.2 | 55
1497 | Senior Specialist | End of Month Cleanup | 16 | 10
1497 | Senior Specialist | Interface w/gas control | 10 | 25
1497 | Senior Specialist | [NAME] | 4 | 2
1497 | Senior Specialist | Manage Imbalances | 7.04 | 10
1497 | Senior Specialist | Monitor Sitara Bridge & feedback | 80 | 20
1497 | Senior Specialist | Noms | 50 | 25
1497 | Senior Specialist | Perform Pipeline Balancing | 10.56 | 5
1497 | Senior Specialist | Prepare Noms/Pathing | 50 | 25
1497 | Senior Specialist | Preventative OA | 7.04 | 3
1497 | Senior Specialist | Renom Activity | 24 | 15
1497 | Senior Specialist | System Downtime | 0 | 0
Spreadsheet: 2b885b8e-ff68-475c-9fec-1d841eeb8ecc
Sheet: Sheet1

ZONEID | [NAME] | KS0220001 | KS0220002 | KS0220003 | KS0220004 | KS0220005 | KS0220006 | KS0220007
00CNGS | ACOCKS GREEN | 1052 | 88 | 9 | 46 | 956 | 201 | 172
00CNGT | ASTON | 1428 | 111 | 12 | 18 | 1315 | 209 | 211
00CNGU | BARTLEY GREEN | 1472 | 102 | 3 | 48 | 1360 | 318 | 203
00CNGW | BILLESLEY | 1096 | 109 | 18 | 63 | 977 | 243 | 173
00CNGX | [NAME] | 1081 | 95 | 0 | 21 | 993 | 156 | 117
00CNGY | [NAME] | 851 | 81 | 6 | 69 | 760 | 175 | 241
00CNGZ | BRANDWOOD | 942 | 86 | 18 | 32 | 860 | 208 | 188
00CNHA | EDGBASTON | 373 | 30 | 0 | 3 | 339 | 77 | 67
00CNHB | ERDINGTON | 1032 | 112 | 0 | 57 | 919 | 188 | 226
00CNHC | HALL GREEN | 463 | 58 | 6 | 34 | 403 | 103 | 93
00CNHD | HANDSWORTH WOOD | 865 | 83 | 9 | 48 | 782 | 139 | 253
00CNHE | HARBORNE | 435 | 53 | 6 | 18 | 370 | 82 | 98
00CNHF | HODGE HILL | 916 | 89 | 9 | 30 | 838 | 201 | 158
00CNHG | KINGS NORTON | 1164 | 106 | 0 | 43 | 1048 | 212 | 167
00CNHH | KINGSTANDING | 1319 | 103 | 3 | 42 | 1221 | 275 | 179
00CNHJ | LADYWOOD | 867 | 66 | 6 | 9 | 796 | 145 | 155
00CNHK | LONGBRIDGE | 1274 | 117 | 9 | 77 | 1159 | 277 | 236
00CNHL | LOZELLS AND EAST HANDSWORTH | 1369 | 116 | 3 | 30 | 1252 | 152 | 255
00CNHM | MOSELEY AND KINGS HEATH | 654 | 94 | 3 | 28 | 556 | 109 | 181
00CNHN | NECHELLS | 1702 | 163 | 6 | 29 | 1547 | 237 | 251
00CNHP | NORTHFIELD | 957 | 98 | 3 | 78 | 848 | 197 | 191
00CNHQ | OSCOTT | 790 | 77 | 6 | 45 | 717 | 177 | 211
00CNHR | PERRY BARR | 696 | 68 | 6 | 45 | 615 | 160 | 211
00CNHS | QUINTON | 919 | 57 | 3 | 36 | 857 | 196 | 170
00CNHT | SELLY OAK | 413 | 42 | 6 | 41 | 351 | 107 | 91
00CNHU | SHARD END | 1523 | 102 | 9 | 42 | 1424 | 308 | 229
00CNHW | SHELDON | 656 | 45 | 6 | 21 | 598 | 123 | 117
00CNHX | SOHO | 1489 | 102 | 6 | 24 | 1402 | 291 | 288
00CNHY | SOUTH YARDLEY | 1026 | 89 | 6 | 49 | 934 | 199 | 206
[NAME] | SPARKBROOK | 1316 | 198 | 3 | 45 | 1130 | 145 | 140
00CNJA | SPRINGFIELD | 879 | 115 | 6 | 70 | 763 | 117 | 116
00CNJB | STECHFORD AND YARDLEY NORTH | 943 | 105 | 6 | 34 | 840 | 144 | 154
00CNJC | STOCKLAND GREEN | 808 | 94 | 3 | 46 | 728 | 142 | 215
00CNJD | SUTTON FOUR OAKS | 348 | 50 | 0 | 46 | 303 | 119 | 115
00CNJE | SUTTON NEW HALL | 360 | 45 | 0 | 9 | 315 | 83 | 104
00CNJF | SUTTON TRINITY | 571 | 43 | 0 | 24 | 535 | 149 | 142
00CNJG | SUTTON VESEY | 356 | 55 | 6 | 39 | 308 | 95 | 126
00CNJH | TYBURN | 1160 | 80 | 0 | 25 | 1085 | 258 | 203
00CNJJ | WASHWOOD HEATH | 922 | 87 | 0 | 21 | 841 | 102 | 72
00CNJK | WEOLEY | 1174 | 101 | 6 | 33 | 1080 | 248 | 207
Spreadsheet: 154489d1336462964-adding-time-from-calculated-cells-employee-timesheetevaluatefurthure
Sheet: Sheet1

 |  |  |  |  |  | FORTNIGHT ENDING: |  | 2012-05-07 00:00:00
Use | 1 day, 0:00:00 | hour clock
EMPLOYEE TIME SHEET
DAY | DATE | JOB No. | START TIME | FINISH TIME | MEAL BREAKS | NORMAL TIME | TIME & A HALF | DOUBLE TIME | MISC
Tuesday |  |  | 19:00:00 | 07:30:00
Wednesday |  |  | 13:00:00 | 19:30:00
Thursday |  |  | 14:00:00 | 19:30:00
Friday |  |  | 15:00:00 | 01:00:00
Saturday |  |  | 16:00:00 | 11:00:00
Sunday |  |  | 17:00:00 | 04:00:00
Monday |  |  | 18:00:00 | 06:00:00
Tuesday |  |  | 19:00:00 | 19:30:00
Wednesday |  |  | 20:00:00 | 19:30:00
Thursday |  |  | 21:00:00 | 19:30:00
Friday |  |  | 22:00:00 | 01:00:00
Saturday |  |  | 23:00:00 | 06:00:00
Sunday |  |  | 23:00:00 | 02:00:00
Monday
OFFICE USE ONLY |  |  | TOTAL:
Ordinary Time:
Spreadsheet: 675648d1588400965-populate-rows-with-cells-that-first-meet-two-conditions-criteria-systems32-example
Sheet: Sheet1

DAN | MONDAY | ADRESA | TELEFON | DEO GRADA | DAN | ZELJENO VREME DOSTAVE | PLANIRANO VREME DOSTAVE | BROJ TURE | REDOSLED DOSTAVLJANJA | [NAME] I OSTALE BELESKE
Br | IME NARUCIOCA
Spreadsheet: 876127d1722808398-unique-filter-formula-with-count-and-sum-dankerz-book1_rh-tms
Sheet: Sheet1

Data |  |  |  |  | Attempt 1 |  |  |  |  | Goal
Project | Status | Members | Contribution |  | Project | Status | Members (count) | Contribution (sum) |  | Project | Status | Members (count) | Contribution (sum)
Project 1 | Active | [NAME] | 100 |  |  | Active | [NAME] | 100 |  | Project 1 | Active | 2 | 300
Project 1 | Active | [NAME] | 200 |  | Project 1 | Active | [NAME] | 200 |  | Project 3 | Active | 3 | 400
Project 2 | Closed | Fred | 150 |  | Project 3 | Active | [NAME] | 200
Project 3 | Active | [NAME] | 200 |  | Project 3 | Active | [NAME] | 100
Project 3 | Active | [NAME] | 100 |  | Project 3 | Active | [NAME] | 100
Project 3 | Active | [NAME] | 100
Project 4 | Closed | Fred | 500 |  | Attempt 2 |  |  |  |  | TMS Formula
Project 4 | Closed | [NAME] | 300 |  | Project | Status | Members (count) | Contribution (sum) |  | Project | Status | Members (count) | Contribution (sum)
Project 4 | Closed | [NAME] | 50 |  |  | Active |  |  |  |  | Active | 2 | 300
 |  |  |  |  | Project 3 | Active |  |  |  | Project 3 | Active | 3 | 400
Spreadsheet: 694160d1599399805-auto-copy-of-certain-relevant-field-from-one-sheet-to-another-sheet-on-basis-of-condition-autocopycertainfieldstoanother2
Sheet: Age Grouping

 |  | DOB | NAME | AGE | PHYISCS | MATH | CHEMISTRY | SOCIAL SCIENCE | HISTORY | ARTS | GEOGRAPHY
 |  | 1999-11-23 00:00:00 | Viplaw Saran | 20 | 83 | 87 | 67 | 47 | 57 | 11 | 65
 |  | 2001-06-12 00:00:00 | [NAME] | 19 | 32 | 65 | 59 | 33 | 54 | 13 | 41
 |  | 2001-10-13 00:00:00 | [NAME] | 18 | 65 | 72 | 59 | 42 | 56 | 16 | 35
 |  | 2002-07-16 00:00:00 | [NAME] | 18 | 76 | 78 | 63 | 39 | 71 | 19 | 67
 |  | 2003-01-11 00:00:00 | [NAME] | 17 | 89 | 93 | 82 | 47 | 68 | 11 | 72
 |  | 2003-05-16 00:00:00 | [NAME] | 17 | 77 | 83 | 75 | 49 | 67 | 15 | 72
 |  | 2004-02-24 00:00:00 | [NAME] | 16 | 94 | 97 | 87 | 49 | 72 | 14 | 70
 |  | 2004-12-22 00:00:00 | [NAME] | 15 | 43 | 65 | 84 | 35 | 65 | 17 | 57
Spreadsheet: dutch_quigley__9191__Delta12-4
Sheet: Sheet1

Natural Gas
Month | Futures | Options | Total:
2002-01-01 00:00:00 | 87 | 0
2002-02-01 00:00:00 | -110 | 4
2002-03-01 00:00:00 | -27 | 6
2002-04-01 00:00:00 | 180 | 0
2002-05-01 00:00:00 | 403 | 34
2002-06-01 00:00:00 | -66 | 0
2002-07-01 00:00:00 | -31 | 0
2002-08-01 00:00:00 | -2775 | 0
2002-09-01 00:00:00 | -380 | 0
2002-10-01 00:00:00 | 19 | 0
2002-11-01 00:00:00 | 0 | -7
2002-12-01 00:00:00 | 50 | -30
2003-01-01 00:00:00 | 40 | 0
2003-02-01 00:00:00 | 153 | 0
2003-03-01 00:00:00 | 10 | 2
2003-04-01 00:00:00 | -177 | 0
2003-05-01 00:00:00 | 221 | 0
2003-06-01 00:00:00 | 257 | 0
2003-07-01 00:00:00 | 123 | 0
2003-08-01 00:00:00 | 144 | 0
2003-09-01 00:00:00 | 141 | 0
2003-10-01 00:00:00 | 270 | 0
2003-11-01 00:00:00 | 246 | 0
2003-12-01 00:00:00 | 274 | 0
2004-01-01 00:00:00 | 50 | 0
2004-02-01 00:00:00 | 138 | 0
2004-03-01 00:00:00 | 21 | 0
2004-04-01 00:00:00 | 35 | 0
2004-05-01 00:00:00 | 26 | 0
2004-06-01 00:00:00 | 35 | 0
2004-07-01 00:00:00 | 35 | 0
2004-08-01 00:00:00 | 576 | 0
2004-09-01 00:00:00 | -72 | 0
2004-10-01 00:00:00 | 35 | 0
2004-11-01 00:00:00 | 85 | 0
2004-12-01 00:00:00 | 50 | 0
Spreadsheet: 151469d1334933163-gathering-information-across-multiple-sheets-and-displaying-in-a-master-sheet-products
Sheet: Master

 | I would like the totals for each item from all the sheets displayed here.
 | No | Name | Total | 1 | 2 | 3 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
 | 20073 | Car | 20 | 2 |  |  | 2 | 2 | 4 | 2 |  | 4 |  |  | 4
 | 20074 | Truck | 48 |  |  |  |  |  | 4 | 2 |  | 38 |  |  | 4
 | 20075 | Van | 2 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | 20077 | Motorcycle | 16 | 5 |  |  | 3 |  | 2 |  | 4 |  |  |  | 2
 | 20084 | Boat | 36 |  | 2 |  | 8 |  | 8 | 3 |  | 4 |  |  | 10 | 1
 | 20076 | Plane | 5 | 1 | 1 | 2 |  |  |  |  |  | 1
 | 20078 | Trailer | 2 |  |  |  |  |  |  |  |  | 2
 | 20082 | Tractor | 2 |  | 1 | 1
Input No= | 20073 | I would like to be able to enter a product number and the information for that number from each sheet be displayed below.
 | No | Name | Total | 1 | 2 | 3 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
2012-04-04 00:00:00 | 20073 | Car | 9 |  |  |  | 1 | 1 | 2 | 1 |  | 2 |  |  | 2
2012-04-11 00:00:00 | 20073 | Car | 11 | 2 |  |  | 1 | 1 | 2 | 1 |  | 2 |  |  | 2
Spreadsheet: 214093d1360794872-need-help-cannot-keep-track-of-occurences-lottery-numbers-solution
Sheet: Sheet2

WINNING NUMBERS |  |  |  |  |  |  | NUMBER | Draw | occurrence
2 | 5 | 6 | 20 | 21 | 26 |  | 1
11 | 23 | 30 | 40 | 54 | 55 |  | 2
20 | 21 | 23 | 34 | 49 | 57 |  | 3
1 | 3 | 13 | 36 | 43 | 50 |  | 4
1 | 2 | 37 | 44 | 44 | 50 |  | 5
3 | 17 | 20 | 28 | 31 | 50 |  | 6
16 | 25 | 34 | 36 | 36 | 53 |  | 7
3 | 12 | 30 | 47 | 51 | 57 |  | 8
1 | 2 | 2 | 24 | 25 | 32 |  | 9
9 | 10 | 14 | 23 | 27 | 35 |  | 10
4 | 8 | 19 | 35 | 35 | 57 |  | 11
15 | 18 | 22 | 25 | 43 | 44 |  | 12
3 | 5 | 8 | 31 | 31 | 46 |  | 13
33 | 35 | 38 | 46 | 54 | 58 |  | 14
1 | 25 | 27 | 29 | 43 | 51 |  | 15
2 | 34 | 39 | 42 | 44 | 56 |  | 16
11 | 12 | 21 | 45 | 56 | 56 |  | 17
6 | 30 | 46 | 53 | 54 | 58 |  | 18
7 | 12 | 34 | 39 | 42 | 43 |  | 19
30 | 33 | 49 | 49 | 50 | 59 |  | 20
6 | 8 | 8 | 19 | 35 | 36 |  | 21
7 | 20 | 36 | 41 | 43 | 60 |  | 22
1 | 17 | 30 | 41 | 42 | 54 |  | 23
2 | 24 | 33 | 33 | 50 | 50 |  | 24
1 | 5 | 23 | 27 | 30 | 54 |  | 25 |  | 5
5 | 15 | 29 | 31 | 34 | 50 |  | 26 |  | 1
2 | 18 | 21 | 24 | 59 | 59 |  | 27 |  | 3
23 | 38 | 41 | 49 | 50 | 56 |  | 28 |  | 5
26 | 37 | 46 | 47 | 48 | 55 |  | 29 |  | 2
7 | 24 | 35 | 41 | 48 | 56 |  | 30 |  | 3
4 | 4 | 23 | 26 | 53 | 58 |  | 31 |  | 4
12 | 13 | 18 | 21 | 39 | 59 |  | 32 |  | 6
3 | 6 | 9 | 11 | 13 | 33 |  | 33 |  | 6
13 | 18 | 20 | 22 | 29 | 55 |  | 34 |  | 2
13 | 35 | 36 | 36 | 44 | 44 |  | 35 |  | 5
2 | 10 | 11 | 33 | 44 | 51 |  | 36
17 | 19 | 21 | 25 | 42 | 56 |  | 37 |  | 3
3 | 18 | 28 | 28 | 52 | 58 |  | 38 |  | 3
5 | 7 | 7 | 8 | 43 | 54 |  | 39 |  | 6
14 | 30 | 44 | 51 | 55 | 58 |  | 40 |  | 1
30 | 30 | 32 | 42 | 55 | 57 |  | 41 |  | 4
7 | 15 | 21 | 24 | 45 | 48 |  | 42 |  | 3
5 | 17 | 23 | 27 | 45 | 46 |  | 43 |  | 4
 |  |  |  |  |  |  | 44 |  | 1
 |  |  |  |  |  |  | 45 |  | 3
 |  |  |  |  |  |  | 46 |  | 4
 |  |  |  |  |  |  | 47 |  | 2
 |  |  |  |  |  |  | 48 |  | 5
Spreadsheet: 0632a03d-b2c5-4c96-ba3b-8b3060e88be1
Sheet: Sheet1

CMA FOUNDATION PAYMENT REQUEST FORM
FOUNDATION Use Only: Original Invoice or Receipts must be attached to this form
Date:
Requistioner
Amount: | $
Payable to:
Description:
Justification of request:
Submitted by: |  |  | Date:
Approval: |  |  | Date:
Fund:
Account:
Project:
Other information
Select one: | Mail Check £ |  | Pick-up Check  £
Note: Procurement and payment polices of the University apply to the Foundation
Spreadsheet: 867142d1714034065-wildcard-to-exclude-specific-word-from-list-when-using-sumifs-sample-272-aligw
Sheet: Sheet1

 | Sheet 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheet 2 |  |  |  |  |  | Calculation Sheet
 | Project Name | 2024-01 | 2024-02 | 2024-03 | 2024-04 | 2024-05 | 2024-06 | 2024-07 | 2024-08 | 2024-09 | 2024-10 | 2024-11 | 2024-12 |  | Cost Element | Project Name | H | Date |  |  | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00
 | Project A |  |  |  | 0.1 | 0.1 | 0.1 | 0.1 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 |  | Project A - Group Quality | Project A | 21 | 2024-01-01 00:00:00 | Exclude
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project A - Development | Project A | 98.8 | 2024-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project A - GPDM | Project A | 73 | 2024-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Group Quality - Project A | Project A | 38 | 2024-02-01 00:00:00 | Exclude
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project A - Development | Project A | 101.75 | 2024-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project A | Project A | 0.5 | 2024-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Group Quality | Project A | 52 | 2024-03-01 00:00:00 | Exclude
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project A - Development | Project A | 199 | 2024-03-01 00:00:00
Spreadsheet: 89480d1289270949-formula-is-valid-but-not-with-named-range-sample
Sheet: Lists

Service_Type | ACTIVITIES | Backpacking | Canoeing | Caving | Kayaking | Mountain_Biking | Rafting | Rock_Climbing | Ropes_Course |  | FOOD | Europe | Americas | UK | France | Wales | England | US | Washington | Canada | Ontario |  | WEEKDAY |  | MONTH
ACTIVITIES | Backpacking | Shenandoah |  | Glade_Cave | Bull_Run_River_during_High_Water | Burke_Lake_Park | [NAME] | Carder_Rock | ATC |  |  | UK | US | England | Brittany | Cardiff | London | California | Seattle | Ontario | Toronto |  | Sunday |  | January
FOOD | Canoeing |  |  | Indian's_Head_Cave | Bull_Run_River_during_Low_Water | Fountainhead_Regional_Park | New_River_Gorge_UPPER | Coopers_Rock | TDC |  |  | France | Canada | Wales | Calvados | Swansea | Birmingham | Washington | [NAME] | Quebec | [NAME] |  | Monday |  | February
LODGING | Caving |  | Shenandoah_River | Whiting's_Neck_Cave |  | Seneca_Creek_State_Park | Shenandoah_River | Elizabeth_Furnace | [NAME] |  |  |  | Mexico | Scotland | Charente | Newport | [NAME] | Florida | Tacoma | British Columbia | [NAME] |  | Tuesday |  | March
TRANSPORT | Kayaking |  |  |  |  |  | Youghiogheny_River | Hidden_Rocks |  |  |  |  | Brazil | Ireland | Cote-D'or | Bangor | Liverpool | Texas |  | Alberta |  |  | Wednesday |  | April
Facility_Rental | Mountain_Biking |  |  |  |  |  |  | New_River_Gorge |  |  |  |  | Argentina |  | Loire | Aberystwyth | Southampton |  |  | Manitoba |  |  | Thursday |  | May
 | Primitive_Teachings |  |  |  |  |  |  | Great_Falls |  |  |  |  | Chile |  | Normandy |  | Leeds |  |  |  |  |  | Friday |  | June
 | Rafting |  |  |  |  |  |  |  |  |  |  |  |  |  | Pas-de-Calais |  | Newcastle |  |  |  |  |  | Saturday |  | July
 | Rock_Climbing |  |  |  |  |  |  |  |  |  |  |  |  |  | Rhone |  |  |  |  |  |  |  |  |  | August
 | Ropes_Course |  |  |  |  |  |  |  |  |  |  |  |  |  | Sarthe |  |  |  |  |  |  |  |  |  | September
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Seine-Maritime |  |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December
 |  |  |  |  | =Lists!$A$2:INDEX(Lists!$A:$A,COUNTA(Lists!$A:$A))
 |  |  |  |  | ProgramModules!$C$5:$C$400
Spreadsheet: 695393d1600185775-if-and-or-criteria-for-headcount-report-sample-turnover-file
Sheet: Employee Census

Position ID | Hire Date | Termination Date | 1/1/2020 | 2/1/2020 | 3/1/2020 | 4/1/2020 | 5/1/2020 | 6/1/2020 | 7/1/2020 | 8/1/2020 | 9/1/2020 | 10/1/2020 | 11/1/2020 | 12/1/2020
1 | 2018-10-22 00:00:00 | 2020-01-02 00:00:00
2 | 2015-03-30 00:00:00 | 2020-01-03 00:00:00
3 | 2016-06-16 00:00:00 | 2020-01-03 00:00:00
4 | 2017-12-11 00:00:00 | 2020-01-03 00:00:00
5 | 2013-12-16 00:00:00 | 2020-01-06 00:00:00
6 | 2018-12-26 00:00:00 | 2020-01-06 00:00:00
7 | 2019-09-09 00:00:00 | 2020-01-06 00:00:00
8 | 2020-02-03 00:00:00 | 2020-08-21 00:00:00
9 | 2018-08-13 00:00:00
10 | 2018-10-01 00:00:00
11 | 2019-06-10 00:00:00
12 | 2019-12-30 00:00:00
13 | 2019-08-13 00:00:00
14 | 2020-03-02 00:00:00
 | If the hire date(Column B) is less than [NAME] AND the term date (Column C) is greater than Column D2 OR is Blank that it returns "Active".  If not that it returns "Inactive"