tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 878613d1725771305-hours-without-overlapping-formula-test-time-ayazgreat-
Sheet: Sheet2

Date: 03SEPT
Job ID | Time Start | Time End | Total Hours wo/overlaping
28859 | 11:01:00 | 11:38:00
10703 | 11:01:00 | 11:31:00
44155 | 11:36:00 | 12:21:00
22818 | 11:53:00 | 12:12:00
77123 | 12:11:00 | 12:43:00
70619 | 12:27:00 | 13:22:00
74581 | 14:38:00 | 15:03:00
Date: 04SEPT
Job ID | Time Start | Time End | Total Hours wo/overlaping
38868 | 11:09:00 | 12:02:00
69746 | 11:09:00 | 12:08:00
34338 | 12:07:00 | 12:23:00
36149 | 12:33:00 | 13:26:00
12347 | 12:33:00 | 13:19:00
72441 | 13:40:00 | 14:01:00
81011 | 14:14:00 | 14:39:00
79832 | 14:55:00 | 15:24:00
10273 | 14:55:00 | 15:32:00
Date: 05SEPT
Job ID | Time Start | Time End | Total Hours wo/overlaping
91734 | 11:19:00 | 11:55:00
75432 | 11:19:00 | 11:47:00
80465 | 12:00:00 | 12:43:00
78019 | 12:00:00 | 12:45:00
87789 | 12:44:00 | 13:19:00
96836 | 12:55:00 | 13:28:00
93043 | 13:41:00 | 14:01:00
71934 | 13:45:00 | 14:13:00
81323 | 14:20:00 | 15:05:00
82305 | 14:22:00 | 15:05:00
Date: 05SEPT
Job ID | Time Start | Time End | Total Hours wo/overlaping
34444 | 11:00:00 | 11:23:00
42311 | 11:00:00 | 11:32:00
82507 | 11:37:00 | 12:15:00
88460 | 11:37:00 | 12:03:00
95221 | 12:16:00 | 12:35:00
64224 | 12:31:00 | 13:04:00
51764 | 12:30:00 | 12:52:00
93986 | 13:17:00 | 13:31:00
24336 | 13:38:00 | 14:14:00
59301 | 13:35:00 | 14:08:00
26702 | 14:24:00 | 14:48:00
47637 | 14:25:00 | 14:59:00
14787 | 15:09:00 | 15:32:00
45888 | 15:10:00 | 15:54:00
28572 | 15:55:00 | 16:52:00
11106 | 15:55:00 | 16:56:00
60323 | 16:30:00 | 16:44:00
Spreadsheet: 0383aed3-6e47-41dd-91c2-0c81f4ab3978
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
District Name: |  |  | School:
 | 1 = Completed required components |  |  | Interest
 | with or without accomidations. |  |  | Profiler |  |  | Course
Student | 2 = Completed alternate components | Student |  | Completed | Career | Basic | Plan | Reflection
Unique | according to IEP | Portfolio |  | 1 or 2 | Finder | Skill | Revision | Statement
Identifier | See instructions tab--lower left | Complete |  | Holland Codes | Completed | Survey | Completed | Completed
(10 digit #) | (1 or 2) | (Y) | (N) | by Letter | (Y or N) | (Y or N) | (Y or N) | (Y or N)
Spreadsheet: b02751ec-712b-4114-b07f-1bb41fb11dbc
Sheet: 6

Experiment name | Biological sample category | Biological sample name | MS/MS sample name | Protein group | Protein accession number | Protein name | Protein identification probability | Protein percentage of total spectra | Protein molecular weight (AMU) | Number of unique peptides | Number of unique spectra | Number of total spectra | Spectrum name | Peptide sequence | Previous amino acid | Next amino acid | Peptide identification probability | [NAME] score | Mascot Identity score | [NAME] score | Modifications identified by spectrum | Actual peptide mass (AMU) | Spectrum charge | Actual minus calculated peptide mass (AMU) | Actual minus calculated peptide mass (PPM) | Peptide start index | Peptide stop index
MS for Fig 1 110801_MSdata | Uncategorized Sample | [NAME] | AL_C_H (F018632) | Histone H1x | [NAME] | Histone H1x | 0.998 | 0.00023 | 22469.9 | 2 | 2 | 2 | Spectrum2363 scans: 4301, | ALVQNDTLLQVK | K | G | 0.95 | 49 | 37 | 0 |  | 1340.77 | 2 | 0.0052 | 3.9 | 95 | 106
MS for Fig 1 110801_MSdata | Uncategorized Sample | [NAME] | AL_C_H (F018632) | Histone H1x | [NAME] | Histone H1x | 0.998 | 0.00023 | 22469.9 | 2 | 2 | 2 | Spectrum1905 scans: 3532, | YSQLVVETIR | K | R | 0.95 | 49.2 | 37.7 | 0 |  | 1206.67 | 2 | 0.0044 | 3.7 | 48 | 57
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Tim Jerman

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
No response
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
No response
Health Care: Continuing System Reform
I'd like to explain my position
Explain your health care reform position, if you choose
I support the right of teachers to bargain for health benefits along with compensation and other benefits
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
No response
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
No response
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | 5 Sycamore Lane, [NAME]. | State rep. | Yes |  | Chittenden
Spreadsheet: 843023d1695001035-adding-data-to-table-daily-and-sum-totals-every-2-weeks-dro-template-payments-revised-northernwarrior-
Sheet: Pivot Table

SAP | Days (DATE) | Sum of Hours
2722 | 8/28/2023 - 9/10/2023 | 24
 | 9/11/2023 - 9/23/2023 | 7.83
114247 | 8/28/2023 - 9/10/2023 | 16
119731 | 8/28/2023 - 9/10/2023 | 16
120396 | 8/28/2023 - 9/10/2023 | 51.25
121564 | 8/28/2023 - 9/10/2023 | 8
124120 | 8/28/2023 - 9/10/2023 | 49.07
125179 | 8/28/2023 - 9/10/2023 | 40.07
125524 | 8/28/2023 - 9/10/2023 | 47.97
126132 | 8/28/2023 - 9/10/2023 | 8
126975 | 8/28/2023 - 9/10/2023 | 40.33
127876 | 8/28/2023 - 9/10/2023 | 8
129485 | 8/28/2023 - 9/10/2023 | 40
131202 | 8/28/2023 - 9/10/2023 | 8
133300 | 8/28/2023 - 9/10/2023 | 8
140375 | 8/28/2023 - 9/10/2023 | 8
140774 | 8/28/2023 - 9/10/2023 | 17.95
142781 | 8/28/2023 - 9/10/2023 | 16
142786 | 8/28/2023 - 9/10/2023 | 8
142959 | 8/28/2023 - 9/10/2023 | 8
143810 | 8/28/2023 - 9/10/2023 | 8
145122 | 8/28/2023 - 9/10/2023 | 38.83
145508 | 8/28/2023 - 9/10/2023 | 7.75
145510 | 8/28/2023 - 9/10/2023 | 15.7
146284 | 8/28/2023 - 9/10/2023 | 40
146288 | 8/28/2023 - 9/10/2023 | 8
147134 | 8/28/2023 - 9/10/2023 | 32
147146 | 8/28/2023 - 9/10/2023 | 7.92
149308 | 8/28/2023 - 9/10/2023 | 16.07
149313 | 8/28/2023 - 9/10/2023 | 48.05
149346 | 8/28/2023 - 9/10/2023 | 16.7
149586 | 8/28/2023 - 9/10/2023 | 16.27
149591 | 8/28/2023 - 9/10/2023 | 49.42
150059 | 8/28/2023 - 9/10/2023 | 39.35
150501 | 8/28/2023 - 9/10/2023 | 8
150812 | 8/28/2023 - 9/10/2023 | 49.43
150813 | 8/28/2023 - 9/10/2023 | 16.5
151238 | 8/28/2023 - 9/10/2023 | 40
151788 | 8/28/2023 - 9/10/2023 | 40.75
153216 | 8/28/2023 - 9/10/2023 | 40.15
153551 | 8/28/2023 - 9/10/2023 | 40
153585 | 8/28/2023 - 9/10/2023 | 33.5
156365 | 8/28/2023 - 9/10/2023 | 32
157108 | 8/28/2023 - 9/10/2023 | 40
157277 | 8/28/2023 - 9/10/2023 | 8
157490 | 8/28/2023 - 9/10/2023 | 40.47
157874 | 8/28/2023 - 9/10/2023 | 39.28
157887 | 8/28/2023 - 9/10/2023 | 42.07
158564 | 8/28/2023 - 9/10/2023 | 39.82
159397 | 8/28/2023 - 9/10/2023 | 39.8
159650 | 8/28/2023 - 9/10/2023 | 32
162355 | 8/28/2023 - 9/10/2023 | 39.95
162358 | 8/28/2023 - 9/10/2023 | 42.25
163314 | 8/28/2023 - 9/10/2023 | 42.12
164853 | 8/28/2023 - 9/10/2023 | 40.08
166030 | 8/28/2023 - 9/10/2023 | 41.07
Grand Total |  | 1561.77
Spreadsheet: 86207d1286234809-how-to-lookup-multiple-rows-of-data-by-value-group-data
Sheet: Group A

Group | Data 1 | Data 2 | Data 3 | Data 4 | Data 5
A | 1 | 2 | 3 | 4 | 5
A | 6 | 7 | 8 | 9 | 10
A | 11 | 12 | 13 | 14 | 15
A | 16 | 17 | 18 | 19 | 20
A | 21 | 22 | 23 | 24 | 25
A | 26 | 27 | 28 | 29 | 30
A | 31 | 32 | 33 | 34 | 35
Spreadsheet: 771922d1646919778-why-column-with-address-in-side-can-not-work-and-substitute-can-not-remove-the-quote-why-this-match-formula-does-not-work-inside-the-vlookup-but-works-fine-when-it-is-alone
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  | aa | bb | cc | dd | ee
 |  |  |  |  | 100 | test1 | test11 | test111 | test1111 | test11111
 |  |  |  |  | 200 | test2 | test22 | test222 | test2222 | test22222
 |  |  |  |  | 300 | test3 | test33 | test333 | test3333 | test33333
Spreadsheet: 781227d1653068267-toc-that-notifies-if-todays-date-occurs-in-any-other-wkbk-sheets-01-attorney-tracking-template-forum
Sheet: Sample Sheet

email | fp_id | first_name | middle_name | last_name | title | firm | location | phone | bar_admissions | practice_areas | specialties | law_school | graduation_year | undergraduate | advanced_degree | raw_education | languages | profile_url | sectors_primary | jobs_practice_primary | jobs_practice_secondary | degree | leadership_matches | Deposition/Notes
 |  |  |  | Resume Send | Resume Follow Up |  |  | [NAME] back and forth with firm until the date/time is scheduled. |  |  | Int. Follow Up Firm |  |  | Int. Sched-Prep 2 |  |  | Int. Follow Up Firm |  |  | Offer-Close
Firm-side |  |  |  | Resume Send | Resume Follow Up |  |  | Interview Schedule/Prep |  |  | Interview 1 Follow Up |  |  | Interview Schedule/Prep |  |  | Interview 2 Follow Up |  |  | Offer/Close - Firm
Notes | Law Firm | Name | Hiring Partner - Email | Initial Send | 1 | 2 | 3 | Interview 1 - Scheduled | Interviewers and details sent to Candidate. | Interview Date | 1 | 2 | 3 | Interview 2 - Scheduled | Interview Prep - Email/Scheduled | Interview Date | 1 | 2 | 3 | Offer/Close - Firm
 |  |  |  | 2022-05-20 00:00:00
Introduction |  |  |  |  |  |  |  | Int. Sched-Prep 1 |  |  | Interview 1 Follow Up |  |  |  |  |  | Interview 2 Follow Up |  |  | Int. Close
Candidate-side |  |  |  |  |  |  |  | Interview Schedule/Prep |  |  | Interview 1 Follow Up |  |  |  |  |  | Interview 2 Follow Up |  |  | Offer/Close - Candidate
Notes | Law Firm | Name | Candidate email | Sending Process (firm Name) | Keep Candidate Up To Date on Firm Feedback |  |  | Interview Prep - Email Sent | Interview scheduled | Interview Date | 1 | 2 | 3 |  |  | Interview Date | 1 | 2 | 3 | Offer/Close - Candidate
Spreadsheet: 752679d1634897260-deleting-certain-values-matrix-book2-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 6 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 7 |  |  | 7 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 9 |  |  | 9 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 |  | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 |  | 3 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 7 |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 2 | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 6 |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 8 |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 9
Spreadsheet: 60674d1261168753-solved-sumif-adambudget2009-dev
Sheet: PayCheck - DEC-09-B

Left Over | Date | Finger Print | Item Name | Categories | Tags | Tag Amount | Bank Amount | Comments
 | 2009-12-15 00:00:00 | 1 | PayCheck | Income | Income - Adam's PayCheck | 1284.23 | 1284.23
Filter
Blank
Finger Print Check | 2009-12-18 00:00:00 | 2 | Walmart | Food |  |  | -56
 | 2009-12-18 00:00:00 | 3 | DVD Store | Entertainment | Entertainment - DVDS |  | -15.07
Spreadsheet: ddab6c75-4657-43e9-b359-d76a0977c1f6
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43022097 | 2014-09-04 23:26:43 | AXIS | 1 | 6 | 2 | 1422784 | flarchi | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
43022327 | 2014-09-04 23:37:00 | ALLIES | 1 | 6 | 3 | 1422784 | flarchi | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
43133650 | 2014-09-13 00:46:49 | ALLIES | 0 | 3 | 6 | 1542223 | Barkhorn4 | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
43133894 | 2014-09-13 01:06:31 | AXIS | 1 | 6 | 3 | 1542223 | Barkhorn4 | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
43147120 | 2014-09-13 23:43:46 | ALLIES | 1 | 6 | 4 | 1546936 | KATANA PAPA | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
43147466 | 2014-09-14 00:00:39 | AXIS | 0 | 3 | 6 | 1546936 | KATANA PAPA | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
Spreadsheet: michelle_lokay__26792__imball0203
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 5107 | 4944 |  |  | 824 | 901 | 1351 | 1247
2 | 4736 | 4944 |  |  | 171 | 901 | 1282 | 1247
3 | 4732 | 4944 | 1 |  | 1065 | 901 | 1359 | 1247
4 | 5539 | 4944 | 1 |  | 1138 | 901 | 1382 | 1247
5 | 5536 | 6484 |  |  | 896 | 901 | 1409 | 1247
6 | 5611 | 5714 |  |  | 811 | 901 | 1387 | 1247
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  |  |  |  |  |  |  | 318091
2002-03-06 00:00:00
CBS Volume
 |  |  | 124430
Spreadsheet: 721481d1614723928-comparing-values-in-two-columns-sample-worksheet
Sheet: Sheet1

Cell A | Cell B | Incorrect Formula 1 | Incorrect Formula 1 | Incorrect Formula 2 | Incorrect Formula 2
10A | 2fh2h2f09h0999-000/10A
B10 | FI2OFIF92F7FBFUBF--2/00/B10
100 | FUBEIUFBFUBFFFF/1000
0100 | 43583F8H48FH0-100000/0100
10 | HD829HF8H82FH/10
100 | 123F/100
1000 | TEXTTEXTTEXT23123UIINF/10000
2000 | F2NB4UIFBUB/2000
10000 | F2HB2H/00/10000-REF
300 | G9990303/30-ORF
50 | R21IR9032HR9-2R22HF-0F29/50
Spreadsheet: 61262d1262101901-cell-range-displacement-rangedisplacement
Sheet: Sheet1

 |  |  |  |  |  |  | choose displacement  0 = month 1 | 0.3217391304347825 | month 4
 | 100 |  |  |  |  |  | 3
 | 108
 | 120 |  | FORMULA IN MONTH 1 |  |  | 0.6699999999999999
 | 115 |  | FORMULA IN MONTH 3 |  |  | 0.3217391304347825
 | 118 |  | FORMULA IN MONTH 7 |  |  | 0.1499999999999999
 | 120 |  | it seems to me the logic of your 3 examples is not consistent: or month 1 is correct, or month 2 and 3 are correct?
MONTH 1 | 125
 | 140
 | 120
 | 122 |  | MONTH 3
 | 131
 | 134
 | 167
 | 145
 | 150
 | 152
 | 157
 | 160
 | 155
 | 161
Spreadsheet: 841167d1693405276-total-each-poker-players-best-25-weeks-over-four-sheets-sample_player-sort
Sheet: 3rd Qtr

 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | [NAME]. | 1st Qtr. | 2nd Qtr. | [NAME]. | Yearly | Best 25 | Weeks
Rank | Player | 2023-07-09 00:00:00 | 2023-07-16 00:00:00 | 2023-07-23 00:00:00 | 2023-07-30 00:00:00 | 2023-08-06 00:00:00 | 2023-08-13 00:00:00 | 2023-08-20 00:00:00 | 2023-08-27 00:00:00 | 2023-09-03 00:00:00 | 2023-09-10 00:00:00 | 2023-09-17 00:00:00 | 2023-09-24 00:00:00 | Total | Total | Total | Total | Total | Total 1 | Played
1 | Amad | 19 | 42 | 50 | 4 | 7 | 28 | 42 | 1 | 0 | 0 | 0
2 | BamaT8er | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 | Bdshort14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 | Beakertwang | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | Billydice55 | 37 | 22 | 34 | 31 | 22 | 19 | 19 | 28 | 0 | 0 | 0
6 | BillyMadison | 43 | 47 | 25 | 25 | 37 | 16 | 28 | 13 | 0 | 0 | 0
7 | Burke | 0 | 19 | 45 | 19 | 0 | 25 | 0 | 0 | 0 | 0 | 0
8 | CallStation |  |  |  |  |  | 4 |  |  |  |  |  |  |  | 0 | 0
9 | DoubleEagle | 0 | 0 | 0 | 0 | 13 | 42 | 7 | 0 | 0 | 0 | 0
10 | eightyWon | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
11 | FCSD36 | 0 | 0 | 28 | 7 | 19 | 1 | 0 | 22 | 0 | 0 | 0
12 | Gator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 | Headhunter | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
16 | IaHawk | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
17 | [NAME] | 22 | 28 | 31 | 22 | 31 | 22 | 31 | 19 | 0 | 0 | 0
18 | JeffW | 7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
19 | JoeSensitive | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
20 | [NAME] | 34 | 37 | 16 | 0 | 10 | 37 | 13 | 4 | 0 | 0 | 0
21 | LaCroix238 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
22 | [NAME] | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
23 | moose | 48 | 4 | 7 | 41 | 16 | 13 | 47 | 38 | 0 | 0 | 0
24 | Pokerdoc13 | 10 | 31 | 19 | 1 | 25 | 31 | 1 | 0 | 0 | 0 | 0
25 | Rasty99 | 4 | 10 | 4 | 36
26 | RickNice | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
27 | Rocket19 | 31 | 16 | 0 | 0 | 0 | 0 | 16 | 0 | 0 | 0 | 0
28 | shorticus | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
29 | sicko | 13 | 0 | 40 | 0 | 28 | 0 | 37 | 0 | 0 | 0 | 0
30 | [NAME] | 28 | 13 | 13 | 16 | 47 | 47 | 22 | 16 | 0 | 0 | 0
31 | ThePiper | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
32 | Treebarkx | 0 | 0 | 1 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0
33 | TX_Tiger | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 33 | 0 | 0 | 0
34 | Wimp85 | 16 | 25 | 10 | 10 | 4 | 7 | 25 | 7 | 0 | 0 | 0
35 | win-winjd | 53 | 7 | 22 | 13 | 42 | 10 | 10 | 10 | 0 | 0 | 0
36 | Zscharps | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 847870d1698706202-combine-functions-to-return-the-right-values-from-a-matrix-excelforum_multi-filter
Sheet: Calendar 1

 | MATRIX |  |  |  |  |  |  |  |  |  |  | RETURN VALUES FROM THE MATRIX
 | ↓ |  |  | ↓ |  |  | ↓ |  |  | 2023-10-04 00:00:00
 | Unit | Position | Shift | Staff | 2023-10-01 00:00:00 | 2023-10-02 00:00:00 | 2023-10-03 00:00:00 | 2023-10-04 00:00:00 | 2023-10-31 00:00:00 | Oct |  | Day: | 2023-10-03 00:00:00
 | 2C | Position1 | M | Employee 01 | 2C |  | 2C | 2C |  |  |  | Shift: | M
 | 3P | Position1 | E | Employee 02 |  | 3P | 3P |  |  |  |  | Position: | Position3
 | 4C | Position3 | N | Employee 03 | 4C |  | 4C | 4C
 | 2C | Position2 | M | Employee 04 | 2C | 2C | 2C |  |  |  |  |  | 3P | 4C | FLO |  | VAC | HOL | Sick
 | 3P | Position3 | E | Employee 05 |  | 3P
 | 4C | Position1 | N | Employee 06 | 4C |  | 4C |  |  |  |  | Employee 04 | Employee 08 | Employee 06 | Employee 11 |  | Employee 18
 | FLO | Position3 | M | Employee 07 | FLO |  | FLO | FLO |  |  |  | Employee 15 | Employee 12 |  | Employee 16
 | 3P | Position2 | E | Employee 08 | HOL | HOL | 3P |  |  |  |  |  | Employee 14
 | 4C | Position3 | N | Employee 09 | VAC | VAC | VAC | VAC | VAC |  |  |  | Employee 20
 | 2C | Position1 | M | Employee 10 | 2C | SICK | SICK | SICK
 | FLO | Position3 | E | Employee 11 | FLO |  | FLO |  | FLO
 | 3P | Position2 | M | Employee 12 | 3P |  | 3P
 | 2C | Position3 | E | Employee 13 |  | 2C
 | 3P | Position1 | M | Employee 14 | 3P |  | 3P
 | 2C | Position3 | E | Employee 15 | 2C | 2C | 2C
 | FLO | Position1 | M | Employee 16 | FLO |  | FLO |  | FLO
 | 2C | Position3 | N | Employee 17 |  | 2C
 | 3P | Position1 | M | Employee 18 | VAC | VAC | VAC | VAC | VAC
 | 4C | Position2 | E | Employee 19 |  |  | HOL
 | 3P | Position1 | M | Employee 20 |  |  | 3P
Spreadsheet: 453340d1459273749-multiple-searches-with-multiple-results-match-index-engineer-calendar-example
Sheet: Sheet1

 | There will be lots of [NAME] so I cannot add this to the match index formula
 | Job Number | Engineer | Start | End | ETC. | ETC. |  | Start Index | End Index | ETC. | ETC.
 | 2849 | [NAME] | 2016-03-31 00:00:00 | 2016-04-14 00:00:00
 | 2850 | [NAME]
 | 2851 | [NAME] | 2016-05-02 00:00:00 | 2016-05-03 00:00:00
 | 2852 | [NAME] |  |  |  |  | This is where my values/index will be
 | 2853 | [NAME] | 2016-03-31 00:00:00 | 2016-04-14 00:00:00
 | 2854 | AJD | 2016-04-01 00:00:00 | 2016-04-15 00:00:00
 | 2855 | AJD | 2016-04-04 00:00:00 | 2016-04-16 00:00:00
 | 2856 | AJD | 2016-04-05 00:00:00 | 2016-04-17 00:00:00
 | 2857 | AJD
 |  | I need both jobs (highlighted yellow) entered in the same date, but my formula only picks the first true number
 |  | Please HELP!
Spreadsheet: 789152d1658930962-split-dollar-amount-into-different-amounts-based-on-percentage-copy-of-invoice-approval-splits-bg-sfy-2022
Sheet: Office Supplies--All

 |  |  |  | USPIRITUS INVOICE APPROVAL FORM
 |  | Person  Requesting |  |  |  | Date
 |  | Supervisor Approval
 | General [NAME]
 | GL | Fund | Department | Event | Location | Grant | Restriction | Amount
 | 8110 | 01 | 546 | N000 | 31 | 99 | 1
 | 8110 | 01 | 481 | N000 | 31 | 35 | 1
 | 8110 | 01 | 482 | N000 | 31 | 35 | 1
 | 8110 | 01 | 483 | N000 | 31 | 35 | 1
 |  | 01
 |  | 01
 |  | 01
 |  | 01
 |  | 01
 |  | 01
 |  |  |  |  |  |  | TOTAL | 9.8
 | NOTES:
Spreadsheet: 377803d1424174825-showing-changes-only-in-scrolling-list-desired-layout-job-change-example-for-tips
Sheet: Sheet1

Employ_ref | Forename | Surname | Leaver | Busarea | Costcentre | Description | Old grade | New Grade | Fromdate_1 | Untildate_1 | [NAME]
16842 | Marcus | Johes | False | ONLINT | 1500 | E | MT2 | [NAME] | 2014-09-01 00:00:00 |  | PROM
17227 | [NAME] | Smith | False | KWEAR | 1580 | K | MT4 | MT3 | 2014-08-18 00:00:00 |  | PROM
15116 | [NAME] | White | False | C13 | 4307 | O | CA1 | MT4 | 2015-02-08 00:00:00 |  | PROM
9709 | Estelle | [NAME] | False | C5 | 4238 | H | MT4 | MT3 | 2013-02-28 00:00:00 |  | PROM