tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 664924d1582827787-need-help-with-a-homewwork-assignment-using-index-match-and-indirect-functions-kelso_excel_ch05_ps1_resourcecenter
Sheet: ClientRegistration

Client Registrations
Board Member Discounts
Discount | EventType
0.05 | Annual Conference
0.05 | [NAME]
0.07 | Plant Tour
0.1 | Survey/Study
ContactID | Firstname | Lastname | BoardMember | Company Name | DateRegistered | EventID | Guests | Registration Fees | BoardMember Discount | Event Discount | Friends Discount | Amount Due
1 | Charity | [NAME] | Yes | SEA-LECT Plastics Corporation | 2019-01-11 00:00:00 | EVNT-0037 | 3
3 | Justin | [NAME] |  | SMT LLC | 2018-12-17 00:00:00 | EVNT-0037 | 1
4 | Sydnee | Washington |  | Southern Indiana Plastics | 2018-02-16 00:00:00 | EVNT-0012 | 2
5 | Blake | [NAME] | Yes | Southwest Mold Inc. | 2019-02-09 00:00:00 | EVNT-0037 | 1
6 | Christine | Tyson | Yes | SPI Industries Inc. | 2019-04-07 00:00:00 | EVNT-0042 | 2
7 | Cassidy | [NAME] |  | Steinwall Inc. | 2018-03-30 00:00:00 | EVNT-0022 | 1
8 | Sloane | Shaffer |  | Stihl Incorporated | 2019-07-23 00:00:00 | EVNT-0022 | 5
10 | Wing | Oneil | Yes | Tasus Corporation - Alabama | 2018-02-17 00:00:00 | EVNT-0042 | 1
11 | Avram | Conrad |  | [NAME] | 2018-05-05 00:00:00 | EVNT-0017 | 1
12 | Adena | [NAME] |  | Team 1 Plastics | 2018-08-22 00:00:00 | EVNT-0022 | 3
13 | [NAME] | Gonzales | Yes | Technical Industries Inc. | 2018-04-01 00:00:00 | EVNT-0012 | 2
14 | Angelica | Marquez |  | Thogus Products Company | 2018-11-01 00:00:00 | EVNT-0037 | 1
15 | Christine | Hughes |  | Trademark Plastics Inc. | 2019-06-14 00:00:00 | EVNT-0037 | 1
16 | Kevyn | Lara |  | Treemen Industries Inc | 2018-03-10 00:00:00 | EVNT-0032 | 3
20 | [NAME] | Estes | Yes | Vantec Inc. | 2018-07-21 00:00:00 | EVNT-0017 | 1
22 | Rebecca | Greene |  | Venture Plastics | 2019-11-28 00:00:00 | EVNT-0022 | 1
23 | [NAME] | [NAME] |  | Wabash Plastics Inc. | 2018-05-24 00:00:00 | EVNT-0032 | 1
25 | [NAME] | Oneil | Yes | GTM Plastics Inc. | 2018-07-01 00:00:00 | EVNT-0012 | 3
26 | Jeremy | [NAME] |  | GTR Enterprises | 2018-02-04 00:00:00 | EVNT-0032 | 2
27 | [NAME] | Delacruz |  | Hansen Plastics Corporation | 2018-06-22 00:00:00 | EVNT-0022 | 1
Spreadsheet: 7abecdfd-d4aa-4d19-91e7-3a5b45e812bf
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
7986 | 45993 | Nadia | [NAME] | ITA | 113 | 00:27:15 | 00:00:00 | 00:40:50 | 00:00:00 | 00:42:10 | 1 | 01:50:16
Spreadsheet: 75810d1276385557-return-of-cell-reference-coordinates-4
Sheet: Sheet5

 | 1 | 2 | 3 | 4 | 5 | 6 | y | x | text to find | cell ref
1 | a | b | c | d | e | f | 1 | 5 | e | $F$2
2 | g | h | i | j | k | l
3 | m | n | o | p | q | r
4 | s | t | u | v | w | x
5 | y | z | aa | ab | ac | ad
Spreadsheet: 190866d1351815061-is-there-a-way-to-use-offset-or-other-function-to-copy-cells-down-data-sample
Sheet: Sheet1

12 | 2 | 4
5 | 0 | 2
4 | 2 | 3 |  |  |  | Start here
12 | 2 | 5
5 | 0 | 6
4 | 2 | 4
2 | 2 | 6
1 | 3 | 7
Spreadsheet: 868277d1715009160-sorting-the-latitude-and-longitude-data-and-calculating-distance-how-to-sort-and-calculate-dis
Sheet: Sheet1

Outlets Name | Latitude | Longitude
[NAME] vijaya medicals | 16.5746642975 | 80.3591360617
K p r medicals | 16.5769611485 | 80.3585196566
Mn medicals and fancy stores | 16.5769875 | 80.3587863
[NAME] naga malleswra medicals | 16.5769070014 | 80.3581790999
Sarasawathi medicals and fancy stores | 16.5363133606 | 80.4744778387
Rupa medicals | 16.569651207 | 80.3586844448
Sai nandhini medicals | 16.5593251633 | 80.458073616
Lakshmi medicals | 16.5747780818 | 80.3580490965
Sai santhosh medical stores | 16.575149945 | 80.3587913141
Sai medicals | 16.5305940947 | 80.4665545095
Pariyi Medicals | 16.5695254365 | 80.3585428745
Sri Venkata Subramneyeswra Medicals And Fancy Stores | 16.5706573706 | 80.358059993
Venkateswra Medicals And [NAME] | 16.5773200197 | 80.3587067407
New Apollo Medicals | 16.5769965202 | 80.358682014
[NAME] | 16.5768873459 | 80.3587028012
K P R Medicals And Genral Stores | 16.5767189115 | 80.3589377459
A S Medicals And Fancy Stores | 16.5744115831 | 80.3593834117
Naga medicals | 16.576961 | 80.3587774
[NAME] Medical Agencies | 16.48446429 | 80.57624321
Vinaya ganapathi medicals | 16.5750273 | 80.3583828
Sudha medicals | 16.5693773702 | 80.3587075789
Ar pharmacy | 16.5730681736 | 80.3589579463
[NAME] And Fancy Hall | 16.574735418 | 80.3587862849
[NAME] And Fancy Hall | 16.5752398409 | 80.3590482194
S B N Medicals And Fancy Stors | 16.5763349365 | 80.3585871309
Satiesh medicals | 16.5342395 | 80.453904
Spreadsheet: 38012d96-5282-4d8c-bcc8-656de26d36b2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | 1 | 2 | 3 | 4 | 5
 |  |  |  |  |  |  | Devastated quake-hit prefectures(Iwate, Miyagi and [NAME]) are not included in the figures.
 |  |  |  |  |  |  |  |  | Table 31  Relative household by age of the head and spouse
 |  |  |  |  |  |  | May 2011 |  |  |  |  |  | (Ten thousand households)
 |  |  |  |  |  |  |  | Sex of the head, | Age of the head
 |  |  |  |  |  |  |  | age of the head, | Total | Male |  | Female
 |  |  |  |  |  |  |  |  |  | 15 to 64 years old | 65 years old or more | 15 to 59 years old | 60 years old or more
 |  |  |  |  |  |  | Sex of the spouse of the head,
 |  |  |  |  |  |  | age of the spouse of the head,
 |  |  |  |  |  |  | family type oh household |  | 1 | 2 | 3 | 4 | 5
3100 | 86050 |  | 1 |  |  |  | Total (incl. without a spouse) | 1 | 3289 | 2018 | 905 | 205 | 161
3100 | 86050 |  | 1 |  |  |  | Female | 2 | 2759 | 1905 | 854 | - | -
3100 | 86050 |  | 1 |  |  |  | 15 to 59 years old | 3 | 1721 | 1694 | 27 | - | -
3100 | 86050 |  | 1 |  |  |  | 60 years old or more | 4 | 1038 | 211 | 827 | - | -
3100 | 86050 |  | 1 |  |  |  | Of which household only of a        married couple | 5 | 635 | 104 | 531 | - | -
3100 | 86050 |  | 1 |  |  |  | Male | 6 | 20 | - | - | 15 | 4
3100 | 86050 |  | 1 |  |  |  | 15 to 64 years old | 7 | 16 | - | - | 14 | 1
3100 | 86050 |  | 1 |  |  |  | 65 years old or more | 8 | 4 | - | - | 1 | 3
3100 | 86050 |  | 1 |  |  |  | Of which household only of a        married couple | 9 | 3 | - | - | 1 | 2
 |  |  |  |  |  |  | (regrouped)
3100 | 86050 |  | 1 |  |  |  | Household with an aged person | 10 | 996 | 271 | 682 | 23 | 20
3100 | 86050 |  | 1 |  |  |  | Household without an aged person | 11 | 2294 | 1747 | 223 | 182 | 142
Spreadsheet: 672319d1586828234-vlookup-and-transpose-between-different-sheets-files-based-on-two-values-from-two-columns-book16
Sheet: Sheet1

Column1 | Column2 | Column3
1 | A | AN01 |  | Column1 | Column2.1 | 0 | 1 | 2 | 3 | 4 | 5
1 | A | AN02 |  | 1 | A | AN01 | AN02 | AN03
1 | A | AN03 |  | 1 | B | AN04 | AN05 | AN06
1 | B | AN04 |  | 2 | C | AN01 | AN02 | AN03 | AN04 | AN05 | AN06
1 | B | AN05 |  | 3 | D | AN01 | AN02 | AN03
1 | B | AN06 |  | 3 | E | AN04 | AN05 | AN06
2 | C | AN01
2 | C | AN02
2 | C | AN03
2 | C | AN04
2 | C | AN05
2 | C | AN06
3 | D | AN01
3 | D | AN02
3 | D | AN03
3 | E | AN04
3 | E | AN05
3 | E | AN06
Spreadsheet: 766414d1643890379-trying-to-count-a-range-of-multiple-words-in-a-spreadsheet-sample-excel-index-word-selecting
Sheet: Sheet1

Full Code | Description |  |  | Columns A & B show sample data
11001X | Metal Car
21001X | Plastic Car |  |  | What I am hoping to do is find a way to identify common words found in the full data list (around 10,000 lines)
51001 | Large Fire House |  |  | and list them in order of most times they are mentioned - this will help me to create a product index
11002X | Metal Bike
21002X | Plastic Bike |  |  | So for example using the data in column B I would want the formula to somehow show me the solutions as below:
51002 | Large Hospital
51003 | Large School |  |  | Word | Qty Mentioned
11007E | Metal Bus (Med) |  |  | Metal | 4
11007K | Metal Bus (Large) |  |  | Large | 4
21007E | Plastic Bus (Med) |  |  | Plastic | 3
 |  |  |  | Bus | 3
 |  |  |  | Car | 2
 |  |  |  | Bike | 2
 |  |  |  | Med | 2
 |  |  |  | Fire | 1
 |  |  |  | House | 1
 |  |  |  | Hospital | 1
 |  |  |  | School | 1
 |  |  |  | The look up would need to be exact word matches so "Bus" would not be counted if found in another word such as "Business"
Spreadsheet: 725607d1616764550-staff-attendance-data-copy-of-attendance-ans-2
Sheet: Report_20210315T112801

Raw data |  |  |  | Raw data |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Date |  |  |  | User |  |  |  | id | date | id+date | time | date |  |  |  | Staff | Date | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
2021-03-01 11:01:13 |  |  |  | X05024(Maria)
2021-03-01 12:12:05 |  |  |  | X05024(Maria)
2021-03-01 15:02:08 |  |  |  | X05024(Maria)
2021-03-01 17:42:24 |  |  |  | X05024(Maria)
2021-03-01 19:06:32 |  |  |  | X05024(Maria)
2021-03-02 10:22:25 |  |  |  | X05024(Maria) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | time highlighted in green wrongly capture next day data
2021-03-02 10:23:02 |  |  |  | X05024(Maria)
2021-03-02 10:33:56 |  |  |  | X05024(Maria)
2021-03-02 10:46:16 |  |  |  | X05024(Maria)
2021-03-02 15:24:37 |  |  |  | X05024(Maria)
2021-03-02 15:31:59 |  |  |  | X05024(Maria)
2021-03-02 17:52:44 |  |  |  | X05024(Maria)
2021-03-02 18:36:15 |  |  |  | X05024(Maria)
2021-03-01 08:30:56 |  |  |  | R09999(Peter)
2021-03-01 08:32:58 |  |  |  | R09999(Peter)
2021-03-01 09:18:06 |  |  |  | R09999(Peter)
2021-03-01 13:49:43 |  |  |  | R09999(Peter)
2021-03-01 16:57:45 |  |  |  | R09999(Peter)
2021-03-01 17:47:28 |  |  |  | R09999(Peter)
2021-03-01 17:48:15 |  |  |  | R09999(Peter)
2021-03-01 18:08:42 |  |  |  | R09999(Peter)
2021-03-02 08:31:02 |  |  |  | R09999(Peter)
2021-03-02 08:33:08 |  |  |  | R09999(Peter)
2021-03-02 08:49:53 |  |  |  | R09999(Peter)
2021-03-02 09:23:00 |  |  |  | R09999(Peter)
2021-03-02 09:26:43 |  |  |  | R09999(Peter)
2021-03-02 09:57:08 |  |  |  | R09999(Peter)
2021-03-02 09:57:56 |  |  |  | R09999(Peter)
2021-03-02 10:06:15 |  |  |  | R09999(Peter)
2021-03-02 10:12:43 |  |  |  | R09999(Peter)
2021-03-02 14:27:29 |  |  |  | R09999(Peter)
2021-03-02 18:09:59 |  |  |  | R09999(Peter)
Spreadsheet: 768381d1644943187-trying-to-look-up-and-filter-data-example
Sheet: RED K

RED
Id numeric | Product | Component name | Result text
Spreadsheet: 551888d1513203831-if-statement-with-multiple-arguments-if-statement-multiple-scenario
Sheet: Sheet1

Dec Number | Memo | PO Number | Need Formula and this result | project
1001856798 | Iowa, University | PO605 | PO605 | 0
1001856798 | Invoice - Iowa, University | PO605 | PO605 | 0
17-13 | West Virginia University | 0 | 17-13 | 0
19-11 | Oklahoma, University of | 0 | 19-11 | 19-11
[NAME] | Navy | 0 | [NAME] | 0
Spreadsheet: 882028d1730298158-assigning-students-to-courses-based-on-two-first-choices-and-two-reserve-choices-mre813225-assign-by-preference
Sheet: MrE820998

 | Mentor \ Mentee | DoNotUse | [NAME] | Leah | [NAME] | Nina | Opal | Peri | Quer | Rene | Sara | [NAME]
 | [NAME] |  | 4 | 6 | 1 | 2 | 5 | 5 | 8 | 6 | 10 | 6
 | Barb |  | 5 | 4 | 10 | 7 | 10 | 3 | 3 | 7 | 6 | 9
 | Cain |  | 2 | 1 | 3 | 4 | 4 | 7 | 2 | 8 | 3 | 5
 | [NAME] |  | 10 | 10 | 9 | 3 | 2 | 6 | 4 | 3 | 2 | 3
 | [NAME] |  | 8 | 3 | 7 | 1 | 7 | 2 | 10 | 4 | 8 | 10
 | Fran |  | 7 | 9 | 8 | 8 | 1 | 4 | 6 | 1 | 7 | 8
 | [NAME] |  | 3 | 7 | 5 | 5 | 3 | 8 | 1 | 9 | 4 | 7
 | Hana |  | 1 | 5 | 2 | 10 | 9 | 1 | 5 | 2 | 1 | 4
 | [NAME] |  | 6 | 8 | 4 | 6 | 6 | 9 | 7 | 10 | 9 | 2
 | [NAME] |  | 9 | 2 | 6 | 9 | 8 | 10 | 9 | 5 | 5 | 1
 | Mentor |  |  |  |  |  |  |  |  |  |  |  | Avg
 | Choice
Spreadsheet: 860179d1708377460-formula-to-split-up-index-result-into-several-columns-name-split-up
Sheet: Look up

Data |  |  |  |  |  |  |  |  |  | Desired Results
# | Name |  |  | Reference | Column 1 Current Formula | Column 2 Current Formula | Column 3 Current Formula | Column 4 Current Formula |  | Column 1 | Column 2 | Column 3 | Column 4
1 | 123-ACTIVE |  |  | 1 |  |  |  |  |  | 123 | Active
2 | 456-Equity-AP |  |  | 2 |  |  |  |  |  | 456 | Equity | AP
3 | 978-Fixed Assets |  |  | 3 |  |  |  |  |  | 978 | Fixed Assets
4 | 12345-Accounts Payable-GL-Mar |  |  | 4 |  |  |  |  |  | 12345 | Accounts Payable | GL | Mar
Spreadsheet: 753346d1635377386-override-rank-formula-rank-override-example-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Actual |  |  | Override
 | Project | Priority Score | Ranking | Rank Override | Helper Column | Ranking w/ Override but with ties | Ranking w/ Override without ties |  | Rank | Project |  | Rank | Project
 | A | 10 |  |  |  |  |  |  | 1 |  |  | 1 | B
 | B | 6.4 |  | 1 |  |  |  |  | 2 |  |  | 2 | A
 | C | 7 |  |  |  |  |  |  | 3 |  |  | 3 | F
 | D | 5.3 |  |  |  |  |  |  | 4 |  |  | 4 | C
 | E | 11 |  |  |  |  |  |  | 5 |  |  | 5 | D
 | F | 8 |  | 2 |  |  |  |  | 6 |  |  | 6 | E
 | G | 3.2 |  |  |  |  |  |  | 7 |  |  | 7 | G
Spreadsheet: 62786d1263787899-cant-download-from-web-stawell
Sheet: Sheet1

 | Racing And Sports   Stawell Raceguide - 18 January 2010    Track: DEAD   Wind easing. ([NAME]: 22)
 | 1 |  | X X X X Gold Boat Regatta Mdn $12,000 | 2000m
 |  |  | 3yo+ Maiden API:0.48 | 1:05 pm
 | TAB | HORSE BP | WT |  | DLW | Car | RLW
 | 1 | [NAME] 2 | 58.0 |  | 0 | 0 | 0 | 7 | 7 | #N/A
 | 2 | Giant Victory 8 | 58.0 |  | 0 | 0 | 0.56 | 9 | 9
 | 3 | [NAME] 9 | 58.0 |  | 0 | 0 | 0.2 | 5 | 5
 | 4 | Orpenetto 5 | 58.0 |  | 843 | 0.04 | 0.14 | 28 | 7 |  | #N/A
 | 5 | Peace An Quiet 7 | 58.0 |  | 0 | 0 | 0.16 | 19 | 19
 | 6 | Rockinconi 10 | 58.0 |  | 0 | 0 | 0.13 | 8 | 8
 | 7 | Wyndam Fashion 3 | 58.0 |  | 0 | 0 | 0.13 | 31 | 31
 | 8 | Abysm 6 | 56.0 |  | 0 | 0 | 0.3 | 10 | 10
 | 9 | Mars Attacks 1 | 56.0 |  | 0 | 0 | 0.15 | 13 | 13
 | 10 | Wenita Joy 4 | 56.0 |  | 0 | 0 | 0 | 2 | 2
Stawell Raceguide - 18 January 2010
Track: DEAD   Wind easing. ([NAME]: 22)
1 |  | X X X X Gold Boat Regatta Mdn $12,000 | 2000m
 |  | 3yo+ Maiden API:0.48 | 13:05:00
TAB | HORSE | WT |  | DLW | RLW | Car
1 | [NAME] | 58.0 |  | 0 | 7 | 0%-0%-7
2 | Giant Victory | 58.0 |  | 0 | 9 | 0%-56%-9
3 | [NAME] | 58.0 |  | 0 | 5 | 0%-20%-5
4 | Orpenetto | 58.0 |  | 843 | 7 | 4%-14%-28
5 | Peace An Quiet | 58.0 |  | 0 | 19 | 0%-16%-19
6 | Rockinconi | 58.0 |  | 0 | 8 | 0%-13%-8
7 | Wyndam Fashion | 58.0 |  | 0 | 31 | 0%-13%-31
8 | Abysm | 56.0 |  | 0 | 10 | 0%-30%-10
9 | Mars Attacks | 56.0 |  | 0 | 13 | 0%-15%-13
10 | Wenita Joy | 56.0 |  | 0 | 2 | 0%-0%-2
Spreadsheet: 723176d1615552379-data-extraction-from-another-sheet-based-on-date-data-extract
Sheet: Summary

 | Enter Date Here | 2021-03-12 00:00:00
 | 2021-03-12 00:00:00 | gggg | hhhh | iiii | jjjj | kkkk | llll |  | <-------  Expected Result in Here
 | 2021-03-12 00:00:00 | mmmm | nnnn | oooo | pppp | qqqq | rrrr
 | 2021-03-12 00:00:00 | yyyy | zzzz | aabb | ccdd | eeff | gghh
Spreadsheet: 850822d1701172774-data-filtering-with-formulas-bbt-lln_v2
Sheet: Example data

Id numeric | Product | Brew number | Sampling point | ABV_DUTY | MES_ABV | MES_ABVout | MES_AE | MES_AEout | MES_AENOM | MES_CO2 | MES_CO2out | MES_COL | MES_COLNOM | MES_HAZE11 | MES_HAZE90 | MES_O2 | MES_O2out | oe_calc1 |  | MES_ABV | MES_ABVout | MES_AE | MES_AEout | MES_CO2 | MES_CO2out | MES_COL | MES_HAZE11 | MES_HAZE90 | MES_O2 | MES_O2out |  | ABV | AE | AE_NOM | COL | COL_NOM | HAZE_25DEG | HAZE_90DEG | VISUAL
https://www.excelforum.com/excel-general/1415744-data-filtering-with-formulas.html
 |  |  | For Excel 2016 : | =IFERROR(INDEX(Table1[[Result text]:[Result text]],AGGREGATE(15,6,ROW(Table1)/(Table1[[Id numeric]:[Id numeric]]=$A2)/(Table1[[Component name]:[Component name]]=E$1),COUNTIF($E$1:E$1,E$1))-ROW(Table1[#Headers])),"")
 |  |  | For later versions : | =IFERROR(INDEX(FILTER(Table1[[Result text]:[Result text]],(Table1[[Id numeric]:[Id numeric]]=$A2)*(Table1[[Component name]:[Component name]]=E$1)),COUNTIF($E$1:E$1,E$1)),"")
Spreadsheet: 778913d1651435106-array-formula-help-across-tabs-quote-template-and-equipment-list
Sheet: Standard Quote

 | Company Address |  |  | Date
 | Street Address, City, State ZIP Code |  |  | Quotation # | 1234
 | Phone: Enter Phone number here   Fax: Enter Fax number here |  |  | Customer ID | ABC123
 | Quotation For
 | Customer Name |  |  | Quotation valid until:
 | Company Name |  |  | Prepared by: | Name
 | Street Address, City, State/Province, ZIP Code
 | Phone, Fax Number
 | Comments or Special Instructions
 | None
 | Salesperson | P.O. Number | Ship Date | F.O.B. Point | Terms
 |  |  |  |  | Due on receipt
 |  |  |  | Subtotal
 | If you have any questions concerning this quotation, please contact: |  |  | Other
 | Enter your contact details |  |  | TOTAL
 | Thank you for your business!
Spreadsheet: 776087d1649493869-count-based-on-month-and-condition-test-11-
Sheet: Sheet2

MONTH | APPLE | APPLE | CABLE | CABLE
2022-01-01 00:00:00
Spreadsheet: 06ce50ce-a945-43d3-958c-74aa737b01da
Sheet: Sheet1

IMPERIAL VALLEY COLLEGE | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
INVOICE APPROVAL FORM
REQUESTOR/DEPT:
DEPARTMENT: |  |  |  |  | I DOC #
 |  |  |  | TRANSACTION DATE:
VENDOR INFORMATION:
NAME:
ID  NUMBER:
 | You can list multiple invoices for the same vendor on this form
INVOICE DATE:
INVOICE NUMBER: |  |  |  |  |  | Invoice Totals
INVOICE AMOUNT: |  |  |  |  |  | 0
NAME  OF  ACCOUNT |  | FUND | ORG | ACCT | PROG | AMOUNT
 |  |  |  | Total |  | 0
AUTHORIZED SIGNATURES:
Print Name - Requestor |  |  |  |  | Signature |  | Date
Print Name - Department Head |  |  |  |  | Signature |  | Date
Print Name - VP/Dean/Associate Dean - If needed |  |  |  |  | Signature |  | Date
This form must be attached to all Direct Payment Invoices and submit to Business Office for payment.
Spreadsheet: 05f80a87-1d8f-4476-bc2c-2abf5e8ef7f6
Sheet: Bedford-Huntingdon

 |  |  | 2014  Bedford-Huntingdon   Hopewell, [NAME], Immaculate + Huntingdon F.E.
 | January |  |  |  |  |  |  |  | February |  |  |  |  |  |  |  | March
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15
 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22
 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 23 | 24 | 25 | 26 | 27 | 28 |  |  | 23 | 24 | 25 | 26 | 27 | 28 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 31
 | April |  |  |  |  |  |  |  | May |  |  |  |  |  |  |  | June
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  | 1 | 2 | 3 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | 8 | 9 | 10 | 11 | 12 | 13 | 14
 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  | 11 | 12 | 13 | 14 | 15 | 16 | 17 |  | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | 22 | 23 | 24 | 25 | 26 | 27 | 28
 | 27 | 28 | 29 | 30 |  |  |  |  | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | 29 | 30
 | July |  |  |  |  |  |  |  | August |  |  |  |  |  |  |  | September
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  |  | 1 | 2 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  | 10 | 11 | 12 | 13 | 14 | 15 | 16 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  | 17 | 18 | 19 | 20 | 21 | 22 | 23 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 27 | 28 | 29 | 30 | 31 |  |  |  | 24 | 25 | 26 | 27 | 28 | 29 | 30 |  | 28 | 29 | 30
 |  |  |  |  |  |  |  |  | 31
 | October |  |  |  |  |  |  |  | November |  |  |  |  |  |  |  | December
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  | 1 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 23 | 24 | 25 | 26 | 27 | 28 | 29 |  | 28 | 29 | 30 | 31
 |  |  |  |  |  |  |  |  | 30
 |  | The Thursday before the 3rd Friday + Huntingdon Fresh Express.  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  | Holidays, Food Bank is Closed |  |  |  |  |  |  |  | Delivery dates to your area |  |  |  |  |  |  |  | [NAME]In Center Fresh Express
Spreadsheet: 812307d1673050001-sum-per-week-week-tms
Sheet: Planilha1

Week | Date | Value |  |  |  |  | SUMIF | SUMPRODUCT
 | 2023-01-02 00:00:00 | 15.25 |  | 1ª week | 97.25
 | 2023-01-03 00:00:00 | 17.35 |  | 2ª week | 149.75
 | 2023-01-04 00:00:00 | 19.45 |  | 3ª week | 202.25
 | 2023-01-05 00:00:00 | 21.55 |  | 4ª week | 199.6
 | 2023-01-06 00:00:00 | 23.65 |  | 5ª week | 116.6
 | 2023-01-09 00:00:00 | 25.75
 | 2023-01-10 00:00:00 | 27.85
 | 2023-01-11 00:00:00 | 29.95
 | 2023-01-12 00:00:00 | 32.05
 | 2023-01-13 00:00:00 | 34.15 |  |  |  |  |  |  | 2023-01-03 00:00:00 | 2023-01-03 00:00:00 | 17.35
 | 2023-01-16 00:00:00 | 36.25 |  |  |  |  |  |  | 2023-01-04 00:00:00 | 2023-01-04 00:00:00 | 19.45
 | 2023-01-17 00:00:00 | 38.35 |  |  |  |  |  |  | 2023-01-05 00:00:00 | 2023-01-05 00:00:00 | 21.55
 | 2023-01-18 00:00:00 | 40.45 |  |  |  |  |  |  | 2023-01-06 00:00:00 | 2023-01-06 00:00:00 | 23.65
 | 2023-01-19 00:00:00 | 42.55 |  |  |  |  |  |  | 2023-01-09 00:00:00 | 2023-01-09 00:00:00 | 25.75
 | 2023-01-20 00:00:00 | 44.65 |  |  |  |  |  |  | 2023-01-10 00:00:00 | 2023-01-10 00:00:00 | 27.85
 | 2023-01-23 00:00:00 | 46.75 |  |  |  |  |  |  | 2023-01-11 00:00:00 | 2023-01-11 00:00:00 | 29.95
 | 2023-01-24 00:00:00 | 48.85 |  |  |  |  |  |  | 2023-01-12 00:00:00 | 2023-01-12 00:00:00 | 32.05
 | 2023-01-25 00:00:00 | 50.95 |  |  |  |  |  |  | 2023-01-13 00:00:00 | 2023-01-13 00:00:00 | 34.15
 | 2023-01-26 00:00:00 | 53.05 |  |  |  |  |  |  | 2023-01-16 00:00:00 | 2023-01-16 00:00:00 | 36.25
 | 2023-01-27 00:00:00 | 55.15 |  |  |  |  |  |  | 2023-01-17 00:00:00 | 2023-01-17 00:00:00 | 38.35
 | 2023-01-30 00:00:00 | 57.25 |  |  |  |  |  |  | 2023-01-18 00:00:00 | 2023-01-18 00:00:00 | 40.45
 | 2023-01-31 00:00:00 | 59.35 |  |  |  |  |  |  | 2023-01-19 00:00:00 | 2023-01-19 00:00:00 | 42.55
 |  |  |  |  |  |  |  |  | 2023-01-20 00:00:00 | 2023-01-20 00:00:00 | 44.65
 |  |  |  |  |  |  |  |  | 2023-01-23 00:00:00 | 2023-01-23 00:00:00 | 46.75
 |  |  |  |  |  |  |  |  | 2023-01-24 00:00:00 | 2023-01-24 00:00:00 | 48.85
 |  |  |  |  |  |  |  |  | 2023-01-25 00:00:00 | 2023-01-25 00:00:00 | 50.95
 |  |  |  |  |  |  |  |  | 2023-01-26 00:00:00 | 2023-01-26 00:00:00 | 53.05
 |  |  |  |  |  |  |  |  | 2023-01-27 00:00:00 | 2023-01-27 00:00:00 | 55.15
 |  |  |  |  |  |  |  |  | 2023-01-30 00:00:00 | 2023-01-30 00:00:00 | 57.25
 |  |  |  |  |  |  |  |  | 2023-01-31 00:00:00 | 2023-01-31 00:00:00 | 59.35
Spreadsheet: 31054d1226768205-word-to-excel-excel-example
Sheet: Sheet1

Turn Number | Act | Location | Dep Time | Location | Arr Time | Days
LTP   DY   2114 | Taxi | Derby | 8.49 | Neville Hill T&R.S.M.D | 10.19 | Su
LTP   DY   2115 | Taxi | Derby | 12.48 | Neville Hill T&R.S.M.D | 14.18 | Su