tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 63500d1264432406-booking-planner-testbookings2010
Sheet: Planning

 | Aprt |  | 2010-04-29 00:00:00 | 2010-04-30 00:00:00 | 2010-05-01 00:00:00 | 2010-05-02 00:00:00 | 2010-05-03 00:00:00 | 2010-05-04 00:00:00 | 2010-05-05 00:00:00 | 2010-05-06 00:00:00 | 2010-05-07 00:00:00 | 2010-05-08 00:00:00 | 2010-05-09 00:00:00 | 2010-05-10 00:00:00 | 2010-05-11 00:00:00 | 2010-05-12 00:00:00 | 2010-05-13 00:00:00 | 2010-05-14 00:00:00 | 2010-05-15 00:00:00 | 2010-05-16 00:00:00 | 2010-05-17 00:00:00 | 2010-05-18 00:00:00 | 2010-05-19 00:00:00 | 2010-05-20 00:00:00 | 2010-05-21 00:00:00 | 2010-05-22 00:00:00 | 2010-05-23 00:00:00 | 2010-05-24 00:00:00 | 2010-05-25 00:00:00 | 2010-05-26 00:00:00 | 2010-05-27 00:00:00 | 2010-05-28 00:00:00 | 2010-05-29 00:00:00 | 2010-05-30 00:00:00 | 2010-05-31 00:00:00 | 2010-06-01 00:00:00 | 2010-06-02 00:00:00
 | C1A |  | x | x | x | x | x | x | x | x | x | x | x | x |  |  |  |  | x | x | x | x |  |  | x | x | x | x | x | x | x | x
 | C1B
 | C1C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x |  |  | x | x | x | x
 | C1D |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
 | C1E |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x
 | C1F
 | C1G |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
Spreadsheet: 70717d1271422339-conditional-count-sum-for-month-v2-copy-of-calm-workbook1
Sheet: Sheet1

Call Started | calm assigned zone | CLI | Number Unique | Gender | Age Range
2013-04-06 19:34:33 | Merseyside |  | 0
2013-04-07 17:07:37 | Merseyside |  | 0 | Male | 26 to 35
2013-04-08 17:02:28 | Merseyside |  | 0 | Female | 46 to 55
2013-04-08 19:36:06 | Merseyside |  | 0 | Male | 26 to 35
2013-04-12 19:27:48 | Merseyside |  | 1 | Male | 36 to 45
2013-04-12 21:43:31 | Merseyside |  | 0 | Male
2013-04-13 17:37:30 | Merseyside |  | 0 | Male | 26 to 35
2013-04-13 18:39:56 | Merseyside |  | 0 | Male | 26 to 35 | Count of Gender | Gender
2013-04-13 18:54:27 | Merseyside |  | 0 | Male | 26 to 35 | Call Started | Female | Male | Undisclosed | (blank) | Grand Total
2013-04-14 20:30:53 | Merseyside |  | 0 | Male | 19 to 25 | Apr | 1 | 22 | 2 |  | 25
2013-04-14 22:28:06 | Merseyside |  | 1 | Male | 36 to 45 | May | 1 | 11 |  |  | 12
2013-04-15 17:10:01 | Merseyside |  | 0 | Male | 26 to 35 | Grand Total | 2 | 33 | 2 |  | 37
2013-04-15 17:37:02 | Merseyside |  | 0 | Male | 19 to 25
2013-04-19 23:24:23 | Merseyside |  | 0 | Undisclosed
2013-04-19 23:28:29 | Merseyside |  | 0 | Undisclosed
2013-04-20 17:30:11 | Merseyside |  | 1 | Male | 36 to 45
2013-04-20 20:42:36 | Merseyside |  | 1 | Male
2013-04-20 22:01:09 | Merseyside |  | 0 | Male | 46 to 55
2013-04-21 17:26:36 | Merseyside |  | 0 | Male | 26 to 35
2013-04-22 17:54:11 | Merseyside |  | 0 | Male | 36 to 45
2013-04-26 20:22:31 | Merseyside |  | 0 | Male | 26 to 35
2013-04-26 21:17:10 | Merseyside |  | 0 | Male | 26 to 35
2013-04-27 17:08:14 | Merseyside |  | 0 | Male | 36 to 45
2013-04-27 19:38:59 | Merseyside |  | 0 | Male | 36 to 45
2013-04-28 17:08:31 | Merseyside |  | 0 | Male | 26 to 35
2013-04-28 22:04:00 | Merseyside |  | 0 | Male | 36 to 45
2013-05-03 20:14:05 | Merseyside |  | 0 | Female | 36 to 45
2013-05-03 21:41:05 | Merseyside |  | 0 | Male | 26 to 35
2013-05-03 21:51:47 | Merseyside |  | 0 | Male
2013-05-05 17:04:55 | Merseyside |  | 0 | Male | 36 to 45
2013-05-05 17:38:30 | Merseyside |  | 0 | Male
2013-05-05 19:06:49 | Merseyside |  | 0 | Male | 19 to 25
2013-05-05 20:02:29 | Merseyside |  | 0 | Male | 26 to 35
2013-05-05 21:02:27 | Merseyside |  | 1 | Male | 15 to 18
2013-05-06 21:58:30 | Merseyside |  | 0 | Male | 26 to 35
2013-05-10 20:40:47 | Merseyside |  | 0 | Male | 36 to 45
2013-05-10 21:58:20 | Merseyside |  | 0 | Male | 19 to 25
2013-05-10 22:09:58 | Merseyside |  | 1 | Male | 26 to 35
 | Month | Male callers | Female Callers | Undisclosed or blank
 | 2013-04-02 00:00:00
 | 2013-05-02 00:00:00
 | 2013-06-02 00:00:00
 | 2013-07-02 00:00:00
 | 2013-08-02 00:00:00
 | 2013-09-02 00:00:00
 | 2013-10-02 00:00:00
 | 2013-11-02 00:00:00
 | 2013-12-02 00:00:00
 | 2014-01-02 00:00:00
 | 2014-02-02 00:00:00
 | 2014-03-02 00:00:00
Spreadsheet: 66640d1267270296-linking-data-to-different-tabs-in-excel-staff-5
Sheet: employee 3

employee 3
task | date
Spreadsheet: 750597d1633538925-count-non-blank-with-a-year-sample-count-copy
Sheet: Sheet1

Date | [NAME] | Sue | Marvin | [NAME]
2021-11-24 00:00:00 | x
2021-12-01 00:00:00 |  | h
2021-12-08 00:00:00 |  |  |  | x
2021-12-15 00:00:00 | x
2021-12-22 00:00:00 |  | x
2021-12-29 00:00:00
2022-01-05 00:00:00
2022-01-12 00:00:00 | x |  | x | x
2022-01-19 00:00:00 | x | x
2022-01-26 00:00:00 | h
2022-02-02 00:00:00 |  |  | x
2022-02-09 00:00:00 |  |  | x
End Result
Name | 2021 | 2022
[NAME] | 2 | 3
Sue | 2 | 1
Marvin | 0 | 3
[NAME] | 1 | 1
Spreadsheet: 744899d1629543417-carrying-data-from-one-sheet-to-another-index-compare-squadre_jt
Sheet: Foglio2

ID | R | NOME |  |  |  |  |  |  |  |  |  | ACQUISTATO DA | PAGATO
 | P | AUDERO
 | P | HANDANOVIC |  |  |  |  |  |  |  |  |  | SQUADRA 2 | 111
 | P | SCEZNI
 | D | AUGELLO
 | D | BONUCCI
 | D | SINGO
 | D | MARCHIZZA |  |  |  |  |  |  |  |  |  | SQUADRA 3 | 222
 | D | SABELLI
 | C | CHIESA |  |  |  |  |  |  |  |  |  | SQUADRA 5 | 333
 | A | BONAZZOLI
 | C | TAMEZE
 | A | RONALDO
 | A | COLLEY
 | C | BARAK |  |  |  |  |  |  |  |  |  |  | 444
Spreadsheet: chris_germany__1678__Behind City Gate Purchases
Sheet: Sheet1

ENRON NA "Behind City Gate" Purchases for CES Retail
Producer | Pipeline | Daily Volume | Price | Contract Expiration | Comments
Power Gas Marketing | CPA Class 90 | 500 | Fixed | 2000-10-31 00:00:00 | CES noms
[NAME] | CPA Class 90 | 1400 | Fixed | 2000-10-31 00:00:00 | One meter in CES's CPA pool
StatOil | CPA Class 90 | 333 | NX1 + .56/Mcf | 2000-10-31 00:00:00 | CES noms
StatOil | CPA Class 90 | 1500 | NX1 + .54/Mcf | 2000-10-31 00:00:00 | CES noms
Power Gas Marketing | EOG | 333 | Fixed | 2000-10-31 00:00:00 | CES noms
Belden & Blake | NFGD PA | 250 | Fixed | 2000-06-30 00:00:00 | Producer matches noms CES noms
Belden & Blake | NYSEG | 300 | Fixed | 2000-10-31 00:00:00 | Producer matches noms CES noms
Phillips Production | PNG | 300 | Fixed | 2000-06-30 00:00:00 | [NAME]'s Meters in CES's Pool; CES noms production monthly
Phillips Production | PNG | 500 | Fixed | 2000-11-30 00:00:00 | [NAME]'s Meters in CES's Pool; CES noms production monthly
Power Gas Marketing | PNG | 250 | Fixed | 2000-10-31 00:00:00 | CES noms
 | TOTALS
ENA NOMS:
Power Gas Marketing | Equitrans | 250 | Fixed | 2000-10-31 00:00:00 | Pool
[NAME] | Equitrans Prod | 50 | TCo Index + $.03 | Monthly | Metered Production
Braxton Oil | Equitrans Prod | 65 | TCo Index + $.01 | Monthly | Metered Production
CBE, Inc | Equitrans Prod | 800 | Fixed & TCo Index + $.01 | 2000-10-31 00:00:00 | Metered Production
Envirogas | Equitrans Prod | 150 | TCo Index | Monthly | Metered Production
[NAME], [NAME] | Equitrans Prod | 200 | CNG Index | Monthly | Metered Production
T & F Exploration | Penn Fuel | 400 | Fixed | 2000-10-31 00:00:00 | Sold to Penn Fuel for May
Spreadsheet: 59751d1260312797-excel-2007-how-to-sort-data-validation-menu-while-typing-characters-in-the-cell-for-the-menu-master_requirement_gathering_template_-final-
Sheet: Service Plan

 |  |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Eligibility Determination
Activity Name | Service Plan
Activity Description / Purpose | Agreement between the customer and worker to comply with certain eligibility requirements.
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Interview client for needs
Create custom service plan
Review plan with client/customer
Spreadsheet: de8816f6-4e59-426e-8ba9-0a20fe5a2c14
Sheet: Sheet1

Release: Harmonized Indices of Consumer Prices (HICP) | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=251
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-12-22 12:35 AM CST
 | Real-Time | Period
Name: | Start | End
Harmonized Indices of Consumer Prices (HICP) | 2012-06-15 00:00:00 | Current
Link:
http://epp.eurostat.ec.europa.eu/portal/page/portal/hicp/data/main_tables | 2012-06-15 00:00:00 | Current
Source:
Statistical Office of the European Communities | 2012-06-15 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2012-06-15 00:00:00
2012-07-15 00:00:00
2012-08-16 00:00:00
2012-09-14 00:00:00
2012-10-16 00:00:00
2012-11-15 00:00:00
2012-12-14 00:00:00
2013-01-16 00:00:00
2013-02-28 00:00:00
2013-03-15 00:00:00
2013-04-16 00:00:00
2013-05-16 00:00:00
2013-06-14 00:00:00
2013-07-16 00:00:00
2013-08-16 00:00:00
2013-09-16 00:00:00
2013-10-16 00:00:00
2013-11-15 00:00:00
2013-12-20 00:00:00
2014-01-21 00:00:00
2014-02-24 00:00:00
2014-03-17 00:00:00
2014-04-21 00:00:00
2014-05-16 00:00:00
2014-06-16 00:00:00
2014-07-17 00:00:00
2014-08-14 00:00:00
2014-09-17 00:00:00
2014-10-21 00:00:00
2014-11-24 00:00:00
2014-12-17 00:00:00
Spreadsheet: 799921d1665400971-lookup-schedule-according-to-the-day-of-the-week-sample
Sheet: Sheet1

 |  | Employee |  |  |  |  |  |  |  |  |  | Schedule
 |  | Employee 1
 |  | Employee 2
 |  | Employee 3
 |  | Employee 4
 |  | Employee 5
 |  | Employee 6
 |  | Employee 7
 |  | Employee 8
 |  | Employee 9
 |  | Employee 10
 |  | Employee 11
 |  | Employee 12
 |  | Employee 13
 |  | Employee 14
 |  | Employee 15
 |  | Employee 16
 |  | Employee 17
 |  | Employee 18
 |  | Employee 19
 |  | Employee 20
 |  | Employee 21
 |  | Employee 22
 |  | Employee 23
 |  | Employee 24
Spreadsheet: 813225d1673620277-how-insert-rows-copy-row-and-transpose-to-column-how-to-transpose
Sheet: Sheet1

Raw data |  |  |  |  |  | Desired output
20221431 | QTEN | TS-EN Stage | 152 |  |  | 20221431 | QTEN | TS-EN Stage | 152 | 70002 | BIN_REQ_DATA | 106 | QSTS | OS-TS Stage | 183 | 50004 | Open/Short - Open (Neg) | 822 | QScratchSF | OB-Scratches(SF) | 298 | QGTkG | GT - Mod Thickness Out | 194
 | 70002 | BIN_REQ_DATA | 106
 | QSTS | OS-TS Stage | 183
 | 50004 | Open/Short - Open (Neg) | 822
 | QScratchSF | OB-Scratches(SF) | 298
 | QGTkG | GT - Mod Thickness Out | 194
Spreadsheet: 857809d1706708986-cell-minus-another-cell-unless-value-in-3rd-celll-book1-etaf
Sheet: Sheet1

 | 23-24 Programme Budget | 23-24 CControl Budget | Spent so far | Remaining
 | 116304.53 |  | 83712.91
 | 30000 | 50000 | 34006.85
 | 245000 | 245000 | 216971.1
 | 300000 |  | 323999.51
 | in Cell E3 I would like the sum B3-D3 as cell [NAME] is blank, however, if there was a value in Cell C3 i would want E3 to return [NAME].
 | So for example, the sum for E3 would need to be B3-D3 resulting in £32,591.62 but on the next line the return i need in E4 is C4-D4 because there is a value in C4 which should result in £15,993.15
Spreadsheet: 2d8e772d-fb3c-43c3-a661-688c45234f61
Sheet: In days

Enter full year entitlement in days
(if part-time, use calculator 1 on leave calculator if not known) |  |  | Working days |  |  | INSTRUCTIONS FOR USE
 |  |  | Monday |  |  | 1.  Calculate entitlement (pro-rated if part-time)
Enter date of start of contract e.g. 1 September  2013 | 2013-09-01 00:00:00 |  | Tuesday |  |  | 2. Put your working days in the table to the left (as a reminder).
(or  start date for annual leave year) |  |  | Wednesday |  |  | 3. Complete the table for Bank and University Holidays, putting in the proportion of  a day you would normally work on that day. Put in 1 for a full day.  If you do not normally work that day, enter zero.
Enter end date of holiday year  i.e. 31 August 2014 | 2014-08-31 00:00:00 |  | Thursday |  |  | 4. Put zero for any days that occurred before you started work at the University.
 |  |  | Friday |  |  | 5. Add on the further days of bookable annual leave as they are taken, or when they are planned.
Number of days between the these two dates |  |  | Total
Entitlement in days
HOLIDAY RECORD
 | Proportion of day normally hours worked on that day(s) | Running total of leave taken | Running total of leave remaining |  |  | Note: The values used are fractions of a day  e.g. 1 day = 1.0, ½ day = 0.5 days
Bank and University Holidays
Wednesday 25th December
Thursday 26th December
Friday 27th December
Monday 30th December
Tuesday 31st December
Wednesday 1st January 2014
Friday 18th April
Monday 21st April
Tuesday 22nd April
Monday 5th May
Monday 26th May
Monday 25th August
Tuesday 26th August
Bookable Leave
Spreadsheet: 255d1d53-7ccd-4a35-bf07-699b18e73cc7
Sheet: 12c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Cross-Currency TOTAL | 5004 | 8592 | 10005 | 8358 | 12295 | 7439 | 3766 | 436 | 55895
Spreadsheet: 183919d1349095144-how-to-shade-a-area-above-a-scattered-line-864591
Sheet: 35 bar

 |  |  |  |  |  |  |  |  |  | 100 | -56
 |  |  |  |  |  |  |  |  |  | 90 |  | -73.9
 | PRES | MOLEFRAC | TOTAL |  |  |  |  |  |  | 86 |  | -75
 |  | CH4 | TEMP |  |  |  |  |  |  | 80 |  | -77
 |  |  |  |  |  |  |  |  |  | 76.5 |  | -79.5
 | bar |  | C |  |  |  |  |  |  | 70 |  | -81
 | 35 | 0 | 0.4171888 |  |  |  |  |  |  | 60 |  | -83.5
 | 35 | 0.025 | -6.61947 |  |  |  |  |  |  | 54.3 |  | -86
 | 35 | 0.05 | -14.22548 |  |  |  |  |  |  | 50 |  | -86.5
 | 35 | 0.075 | -22.35054 |  |  |  |  |  |  | 42.6 |  | -88.5
 | 35 | 0.1 | -30.82767 |  |  |  |  |  |  | 20.5 |  | -97.4
 | 35 | 0.125 | -39.33909 |  |  |  |  |  |  | 15.39 |  | -105.2
 | 35 | 0.15 | -47.44346 |  |  |  |  |  |  | 10.08 |  | -119
 | 35 | 0.175 | -54.67883 |  |  |  |  |  |  | 5.85 |  | -131.8
 | 35 | 0.2 | -60.75721 |  |  |  |  |  |  | 2.94 |  | -153.9
 | 35 | 0.225 | -65.62267 |  |  |  |  |  |  | 1.83 |  | -168
 | 35 | 0.25 | -69.39141 |  |  |  |  |  |  | 0.93 |  | -189
 | 35 | 0.275 | -72.2628 |  |  |  |  |  |  | 0.58 |  | -199.5
 | 35 | 0.3 | -74.39682 |  |  |  |  |  |  | 0.37 |  | -208.7
 | 35 | 0.325 | -75.98871 |  |  |  |  |  |  | 0.25 |  | -216.3
 | 35 | 0.35 | -77.17115 |  |  |  |  |  |  | 0.16 |  | -226.3
 | 35 | 0.375 | -78.04425
 | 35 | 0.4 | -78.68918
 | 35 | 0.425 | -79.16895
 | 35 | 0.45 | -79.52059
 | 35 | 0.475 | -79.80416
 | 35 | 0.5 | -80.03889
 | 35 | 0.525 | -80.2479
 | 35 | 0.55 | -80.44952
 | 35 | 0.575 | -80.65839
 | 35 | 0.6 | -80.88628
 | 35 | 0.625 | -81.14272
 | 35 | 0.65 | -81.43549
 | 35 | 0.675 | -81.77097
 | 35 | 0.7 | -82.15441
 | 35 | 0.725 | -82.59017
 | 35 | 0.75 | -83.08184
 | 35 | 0.775 | -83.63235
 | 35 | 0.8 | -84.25181
 | 35 | 0.825 | -84.92742
 | 35 | 0.85 | -85.65235
 | 35 | 0.875 | -86.45941
 | 35 | 0.9 | -87.3309
 | 35 | 0.925 | -88.26317
 | 35 | 0.95 | -89.27089
 | 35 | 0.975 | -90.34897
 | 35 | 1 | -91.48973
Spreadsheet: 158608d1338317768-sumifs-book1
Sheet: Sheet1

40 | PR1CA11 | JC4524 | PA | ******9259 | ******6045 | [NAME] | 1000 | 2012-05-26 03:05:48
40 | PR1CA11 | JC4524 | PA | ******9259 | ******6045 | [NAME] | 1000 | 2012-05-26 03:42:55 |  |  | 2000
40 | PR1CA11 | 6487 | PA | ******2064 | ******8646 | AARON FIIGS | 80 | 2012-05-25 15:07:12
50 | PR1CA12 | 6665 | PA | ******0880 | ******1464 | [NAME] | 300 | 2012-05-26 01:20:13
50 | PR1CA12 | 6665 | PA | ******0880 | ******1464 | [NAME] | 400 | 2012-05-26 02:09:06 |  |  | 700
20 | PR1CA09 | 6381 | PA | ******0693 | ******2908 | [NAME] | 100 | 2012-05-25 17:50:44
50 | PR1CA12 | 3520 | PA | ******7345 | ******4261 | [NAME] | 50 | 2012-05-25 18:42:30
40 | PR1CA11 | JC4524 | PA | ******6867 | ******2644 | [NAME] | 400 | 2012-05-25 22:39:51
40 | PR1CA11 | 6487 | PA | ******6042 | ******0085 | BERNIE MADOFF | 300 | 2012-05-25 20:22:22
40 | PR1CA11 | 3592 | PA | ******9577 | ******9097 | [NAME] | 200 | 2012-05-25 09:12:28
20 | PR1CA09 | 6381 | PA | ******3134 | ******9890 | ERIC CUNNINGHAM | 400 | 2012-05-25 18:24:06
30 | PR1CA10 | 1016 | PA | ******3134 | ******9890 | ERIC CUNNINGHAM | 400 | 2012-05-25 20:28:28
20 | PR1CA09 | 6381 | PA | ******3134 | ******9890 | ERIC CUNNINGHAM | 400 | 2012-05-25 22:05:12 |  |  | 1200
20 | PR1CA09 | 6381 | PA | ******7887 | ******3331 | TERESA GOLDEN | 300 | 2012-05-26 00:01:51
40 | PR1CA11 | JC4524 | PA | ******7887 | ******3331 | TERESA GOLDEN | 300 | 2012-05-26 01:08:13 |  |  | 600
50 | PR1CA12 | 3520 | PA | ******4314 | ******5733 | MARY FAIRY | 100 | 2012-05-25 12:49:34
 |  |  |  |  |  |  |  |  |  |  | This is how I want it to look
 |  |  |  |  |  |  |  | Using SUMIFS
Spreadsheet: 708198d1607669798-formula-to-pull-through-specific-data-from-one-table-tab-to-another-formula-query
Sheet: Out of Scope List

Property | Property Code | Survey Status | Comments
Spreadsheet: 221008d1363348015-inventory-problem-inventory2
Sheet: Blad1

 |  |  |  | sales
 |  |  |  | 2013-03-31 00:00:00 | 2013-04-30 00:00:00 | 2013-05-31 00:00:00 | 2013-06-30 00:00:00 | 2013-07-31 00:00:00 | 2013-08-31 00:00:00 | 2013-09-30 00:00:00 | 2013-10-31 00:00:00 | 2013-11-30 00:00:00 | 2013-12-31 00:00:00
 |  | 2013-02-28 00:00:00 | days to delivery | march | april | may | june | july | august | september | october | november | december | minimum order | date order
 | product 1 | 800 | 30 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400
 | product 2
 | Product 3
Spreadsheet: 721897d1614937935-solution-to-referefence-data-from-multiple-tabs-master-reevoo-reviews-workbook_eh-1-
Sheet: Pictures only (2)

Category | Who is the brand? | What is the product? | URL | Text | Points | Who | Got it |  |  |  |  |  | Sheet Name
 |  |  |  |  |  |  |  |  |  |  |  |  | August 2020
 |  |  |  |  |  |  |  |  |  |  |  |  | September 2020
Spreadsheet: 731588d1620429207-multi-criteria-vlookup-daily-in-out-audit
Sheet: EElist

 | Daily Time Card Totals
 | 2021-05-03 00:00:00
EE# © | in | Out | in | Out | in | Out | in | Out | in | Out | in | Out | in | Out
1894
1865
1792
1910
1804
1815
Spreadsheet: 05b65bd7-2f35-42d6-9207-3c9e88753c6c
Sheet: Sheet1

SAISD FOOTBALL INVENTORY | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | NEW | USED | TO BE REPAIRED | TOTAL ITEMS
1.  [NAME]
2.  BALLS
3.  BELTS
4.  COATS - SIDELINE
5.  DUMMIES
A.  STAND-UP
B. HAND SHIELDS
C.  OTHER
6.  HELMETS
7.  SOCKS, GAME
SOCKS,  PRACTICE
8.  PRACTICE JERSEYS
9.  PRACTICE PANTS
10.T-SHIRT
11. MOUTHGUARDS
12. PADS
A.  HIP
B.  KNEE
C. THIGH
D. SHOULDER
E.  SLED, BLOCKING
F.  SLED, TACKLING
13. SHOES
A.  GAME, TURF
B.  GAME, CLEATED
C.  PRACTICE
14. [NAME]
15. GIRDLES
16. SUPPORTERS
17. JERSEYS | VARSITY | JV | FRESHMAN | OLDER
A.  GAME (COLORED)
B.  GAME (WHITE)
18. GAME PANTS WHITE
19. GAME PANTS COLORED
DO NOT DISCARD OR DESTROY ANYTHING; UNUSABLES WILL BE CHECKED BY THE
ATHLETIC  OFFICE
COACH: ________________________________ |  | DATE:__________ | SCHOOL: ______________________________
 |  |  | .
PAD:/FORMS/HIGH SCHOOL FOOTBALL INVENTORY
Spreadsheet: 81432d1281614721-reference-cell-fill-book1demo
Sheet: Sheet1

 | ccccc 1 |  |  | ccccc 1 | <<drag these 2 down together
 | kkkkk 1 |  |  | kkkkk 1
 | ccccc 2 |  |  | ccccc 2
 | kkkkk 2 |  |  | kkkkk 2
 | ccccc 3 |  |  | ccccc 3
 | kkkkk 3 |  |  | kkkkk 3
 |  |  |  |  |  | ccccc 1
 |  |  |  |  |  | kkkkk 1
 |  |  |  |  |  | ccccc 2
 |  |  |  |  |  | kkkkk 2
 |  |  |  |  |  | ccccc 3
 |  |  |  |  |  | kkkkk 3
 |  |  |  |  |  | ccccc 4
 |  |  |  |  |  | kkkkk 4
 |  |  |  |  |  | ccccc 5
 |  |  |  |  |  | kkkkk 5
Spreadsheet: 720029d1613986890-shift-diff-timecard-untitled-spreadsheet
Sheet: DATA ENTRY

TIME CARD ENTRY
 |  | Holiday | Weekend | Validation Errors
Calculated Fields |  | Data Entry fields |  |  | Calculated Fields. Do Not Edit. Hide if necessary--->
 |  | HH:MM | HH:MM | HH:MM
DATE | Weekday | TIME IN | TIME OUT | BREAK TIME | REGULAR | OVERTIME | DOUBLE OVERTIME | DAY HOURS | WEEK HOURS | REGULAR PAY | OVERTIME PAY | DOUBLE OVERTIME PAY | TOTAL PAY | Time Check
 |  | 08:00:00 | 17:00:00 | 01:00:00
 |  | 08:00:00 | 22:00:00 | 01:00:00
 |  | 07:00:00 | 16:30:00 | 00:30:00
 |  | 08:00:00 | 15:00:00 | 00:00:00
 |  | 05:00:00 | 18:00:00
 |  | 08:00:00 | 21:00:00
 |  | 05:00:00 | 19:00:00
 |  | 08:00:00 | 22:00:00
 |  | 08:00:00 | 16:30:00
 |  | 05:00:00 | 18:00:00
 |  | 08:00:00 | 22:00:00
 |  | 08:00:00 | 16:30:00
 |  | 05:00:00 | 18:00:00
 |  | 08:00:00 | 16:30:00 | 01:00:00
 |  | 05:00:00 | 18:00:00 | 02:00:00
 |  | 08:00:00 | 22:00:00
 |  | 08:00:00 | 16:30:00
 |  | 05:00:00 | 18:00:00
 |  | 09:05:00 | 18:00:00 | 00:15:00
 |  | 09:05:00 | 17:45:00 | 00:30:00
Spreadsheet: 795398d1662656284-amalgamating-and-deleting-rows-gk-special-assistance-final-example
Sheet: Result

Passenger Assist List |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-07-04 00:00:00
 |  |  |  |  |  |  |  |  | [NAME] |  |  |  | Departure
Job | Assigned To | Name | HIP | VIP | W/C | BR W/C | Mob Imp | [NAME] | Time | Head Code | From | [NAME] | Time | Head Code | Destination | [NAME] | Additional Comments
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
Spreadsheet: 99914d1298451894-excel-2007-problem-if-and-countifs-formula-example
Sheet: Example

Name | Count | Date | Month
[NAME], [NAME] |  | 2011-02-14 00:00:00
[NAME], [NAME] |  | 2011-03-14 00:00:00
[NAME],Beckham |  | 2011-02-10 00:00:00
[NAME],Beckham |  | 2011-03-10 00:00:00
Jermaine,Defoe |  | 2011-02-17 00:00:00
Jermaine,Defoe |  | 2011-03-02 00:00:00
Jermaine,Defoe |  | 2011-03-17 00:00:00
Jermaine,Defoe |  | 2011-03-31 00:00:00
Ashley,Cole |  | 2011-02-17 00:00:00
Ashley,Cole |  | 2011-03-02 00:00:00
Steven,Gerrard |  | 2011-02-24 00:00:00
Steven,Gerrard |  | 2011-03-09 00:00:00
Steven,Gerrard |  | 2011-03-24 00:00:00
[NAME],[NAME] |  | 2011-01-11 00:00:00
[NAME],[NAME] |  | 2011-01-14 00:00:00
[NAME],[NAME] |  | 2011-01-18 00:00:00
[NAME],[NAME] |  | 2011-01-26 00:00:00
[NAME],[NAME] |  | 2011-01-27 00:00:00
[NAME],[NAME] |  | 2011-02-11 00:00:00
[NAME],[NAME] |  | 2011-02-14 00:00:00
[NAME],[NAME] |  | 2011-02-24 00:00:00
[NAME],[NAME] |  | 2011-03-01 00:00:00
[NAME],[NAME] |  | 2011-03-11 00:00:00
[NAME],[NAME] |  | 2011-03-14 00:00:00
[NAME],[NAME] |  | 2011-03-23 00:00:00
[NAME],[NAME] |  | 2011-03-24 00:00:00
Wayne,[NAME] |  | 2011-01-19 00:00:00
Wayne,[NAME] |  | 2011-01-26 00:00:00
Wayne,[NAME] |  | 2011-02-09 00:00:00
Wayne,[NAME] |  | 2011-02-24 00:00:00
Wayne,[NAME] |  | 2011-02-25 00:00:00
Wayne,[NAME] |  | 2011-03-02 00:00:00
Wayne,[NAME] |  | 2011-03-09 00:00:00
Wayne,[NAME] |  | 2011-03-25 00:00:00
Frank,Lampard |  | 2011-01-05 00:00:00
Frank,Lampard |  | 2011-01-07 00:00:00
Frank,Lampard |  | 2011-01-24 00:00:00
Frank,Lampard |  | 2011-01-27 00:00:00
Frank,Lampard |  | 2011-03-07 00:00:00
Frank,Lampard |  | 2011-03-11 00:00:00
Frank,Lampard |  | 2011-03-21 00:00:00
Frank,Lampard |  | 2011-03-25 00:00:00
[NAME],Cole |  | 2011-01-18 00:00:00
[NAME],Cole |  | 2011-01-20 00:00:00
[NAME],Cole |  | 2011-02-11 00:00:00
[NAME],Cole |  | 2011-02-18 00:00:00
[NAME],Cole |  | 2011-02-24 00:00:00
[NAME],Cole |  | 2011-03-23 00:00:00
[NAME],Cole |  | 2011-03-25 00:00:00