tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 854966d1704721485-find-any-dot-in-string-that-has-numbers-in-front-and-back-and-replace-it-with-comma-sample-sheet-jac
Sheet: Sheet1

 |  |  |  |  |  |  | Outcome
 | English Phrase |  |  |  |  |  | English
 | I can't believe it! We won the lottery of 345.23!  It's a mystery. Who committed the crime?  The movie was so suspenseful! I couldn't stop watching if for 2.3 hours. |  |  |  |  |  | I can't believe it! We won the lottery of 345.23!  It's a mystery. Who committed the crime?  The movie was so suspenseful! I couldn't stop watching if for 2,3 hours.
 |  |  |  |  |  |  | [NAME] returns only the initial number and I need to replace it in all iterations of dots between numbers
 | I
 | c
 | a
 | n
 | '
 | t
 | b
 | e
 | l
 | i
 | e
 | v
 | e
 | i
 | t
 | !
 | W
 | e
 | w
 | o
 | n
 | t
 | h
 | e
 | l
 | o
 | t
 | t
 | e
 | r
 | y
 | o
 | f
 | 3
 | 4
 | 5
 | .
 | 2
 | 3
 | !
 | I
 | t
 | '
 | s
 | a
 | m
 | y
 | s
 | t
 | e
 | r
 | y
 | .
 | W
 | h
 | o
 | c
 | o
 | m
 | m
 | i
 | t
 | t
 | e
 | d
 | t
 | h
 | e
 | c
 | r
 | i
 | m
 | e
 | ?
 | T
 | h
 | e
 | m
 | o
 | v
 | i
 | e
 | w
 | a
 | s
 | s
 | o
 | s
 | u
 | s
 | p
 | e
 | n
 | s
 | e
 | f
 | u
 | l
 | !
 | I
 | c
 | o
 | u
 | l
 | d
 | n
 | '
 | t
 | s
 | t
 | o
 | p
 | w
 | a
 | t
 | c
 | h
 | i
 | n
 | g
 | i
 | f
 | f
 | o
 | r
 | 2
 | .
 | 3
 | h
 | o
 | u
 | r
 | s
 | .
Spreadsheet: 819868d1677739937-excel-formula-for-sorting-a-result-excel-data-1
Sheet: Sheet1

DATA 1 |  |  |  |  |  | DATA 2 |  |  |  | EXPECTED RESULT IN DATA 2
Date | Material Code | Status |  |  |  | MATERIAL CODE | STATUS |  |  | MATERIAL CODE | STATUS
2022-02-16 00:00:00 | N07.0002004.00082 | TECO |  |  |  | N07.0002004.00082 |  |  |  | N07.0002004.00082 | PR PO
2022-02-16 00:00:00 | N07.0002004.00143 | TECO |  |  |  | N07.0002004.00143 |  |  |  | N07.0002004.00143 | MO
2022-03-01 00:00:00 | N07.0002004.00196 | CANCEL |  |  |  | N07.0002004.00196 |  |  |  | N07.0002004.00196 | PR
2022-03-03 00:00:00 | N07.0002004.00202 | TECO |  |  |  | N07.0002004.00202 |  |  |  | N07.0002004.00202
2022-04-05 00:00:00 | N12.0007001.00003 | PO |  |  |  | N12.0007001.00003 |  |  |  | N12.0007001.00003 | PO
2022-05-05 00:00:00 | N15.0006001.00006 | SIV |  |  |  | N15.0006001.00006 |  |  |  | N15.0006001.00006 | SIV
2022-05-06 00:00:00 | N15.0006001.00008 | TECO |  |  |  | N15.0006001.00024 |  |  |  | N15.0006001.00024
2022-07-07 00:00:00 | N15.0006001.00025 | PR
2022-08-06 00:00:00 | N07.0002004.00082 | PR
2023-01-01 00:00:00 | N07.0002004.00143 | MO
2023-02-03 00:00:00 | N07.0002004.00196 | PR
2023-02-05 00:00:00 | N07.0002004.00082 | PO
Spreadsheet: 96326d1295726085-averaging-calculation-for-excel-2003-can-i-combine-sick-days-to-worksheet-2011-tech-attendance
Sheet: Nov thru Jan

Last Name | First Name | Tech ID | Unpaid | Vacation | Personal | Bereavement | Sick | 2011-11-01 00:00:00 | 2011-11-02 00:00:00 | 2011-11-03 00:00:00 | 2011-11-04 00:00:00 | 2011-11-05 00:00:00 | 2011-11-06 00:00:00 | 2011-11-07 00:00:00 | 2011-11-08 00:00:00 | 2011-11-09 00:00:00 | 2011-11-10 00:00:00 | 2011-11-11 00:00:00 | 2011-11-12 00:00:00 | 2011-11-13 00:00:00 | 2011-11-14 00:00:00 | 2011-11-15 00:00:00 | 2011-11-16 00:00:00 | 2011-11-17 00:00:00 | 2011-11-18 00:00:00 | 2011-11-19 00:00:00 | 2011-11-20 00:00:00 | 2011-11-21 00:00:00 | 2011-11-22 00:00:00 | 2011-11-23 00:00:00 | 2011-11-24 00:00:00 | 2011-11-25 00:00:00 | 2011-11-26 00:00:00 | 2011-11-27 00:00:00 | 2011-11-28 00:00:00 | 2011-11-29 00:00:00 | 2011-11-30 00:00:00 | 2011-12-01 00:00:00 | 2011-12-02 00:00:00 | 2011-12-03 00:00:00 | 2011-12-04 00:00:00 | 2011-12-05 00:00:00 | 2011-12-06 00:00:00 | 2011-12-07 00:00:00 | 2011-12-08 00:00:00 | 2011-12-09 00:00:00 | 2011-12-10 00:00:00 | 2011-12-11 00:00:00 | 2011-12-12 00:00:00 | 2011-12-13 00:00:00 | 2011-12-14 00:00:00 | 2011-12-15 00:00:00 | 2011-12-16 00:00:00 | 2011-12-17 00:00:00 | 2011-12-18 00:00:00 | 2011-12-19 00:00:00 | 2011-12-20 00:00:00 | 2011-12-21 00:00:00 | 2011-12-22 00:00:00 | 2011-12-23 00:00:00 | 2011-12-24 00:00:00 | 2011-12-25 00:00:00 | 2011-12-26 00:00:00 | 2011-12-27 00:00:00 | 2011-12-28 00:00:00 | 2011-12-29 00:00:00 | 2011-12-30 00:00:00 | 2011-12-31 00:00:00 | 2012-01-01 00:00:00 | 2012-01-02 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00 | 2012-01-07 00:00:00 | 2012-01-08 00:00:00 | 2012-01-09 00:00:00 | 2012-01-10 00:00:00 | 2012-01-11 00:00:00 | 2012-01-12 00:00:00 | 2012-01-13 00:00:00 | 2012-01-14 00:00:00 | 2012-01-15 00:00:00 | 2012-01-16 00:00:00 | 2012-01-17 00:00:00 | 2012-01-18 00:00:00 | 2012-01-19 00:00:00 | 2012-01-20 00:00:00 | 2012-01-21 00:00:00 | 2012-01-22 00:00:00 | 2012-01-23 00:00:00 | 2012-01-24 00:00:00 | 2012-01-25 00:00:00 | 2012-01-26 00:00:00 | 2012-01-27 00:00:00 | 2012-01-28 00:00:00 | 2012-01-29 00:00:00 | 2012-01-30 00:00:00 | 2012-01-31 00:00:00
Ashcraft | [NAME]
Badreddine | Yabi | 897884
Berrospe | [NAME] | 717553
[NAME] | [NAME] | 670844
Ciran | [NAME] | 897124
Cory | [NAME] | 574517
Ditore | [NAME] | 823088
Fiaccato | [NAME]
Flores | Miguel
Garvey | [NAME] | 3897
Guzman | Saul | 918615
Heineman | Russ | 737502
Holland | Scott | 801597
Knight | [NAME]
[NAME] | Greg | 39883
Lopez | Javier | 498139
Mendez | Hector | 10538
Pula | Elvis | 684779
[NAME] | [NAME]
[NAME] | [NAME] | 449397
Simmons | Gene
Valle | [NAME] | 706481
[NAME] | [NAME] | 506097
Waitekus | [NAME] | 613091
Spreadsheet: e59a3319-678d-4ca2-83c6-21fbde056103
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0011360 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | Tarheel Trailer Sanitation Facility | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Bladen | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 01 |  | Field Name: |  | 02 |  | Field Name: |  | 03 |  | Field Name: |  | 04
 |  |  |  |  |  | Area (acres): |  | 7.8 |  | Area (acres): |  | 7.48 |  | Area (acres): |  | 9.43 |  | Area (acres): |  | 5.79
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3
 |  |  |  |  |  | Annual Rate (in): |  | 22 |  | Annual Rate (in): |  | 22 |  | Annual Rate (in): |  | 22 |  | Annual Rate (in): |  | 22
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 00b1ceb6-866d-43a5-9f36-4fbf8b127fe4
Sheet: 4

 | Nov 16 |  | Nov 23 |  | Nov 30 |  | Dec 7
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rates* | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs** | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Commodities | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, estimated net notional amount outstanding by asset class and participant type (millions of USD), all products, origins, currencies, tenors, cleared and uncleared.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 51823d1251416887-exclude-weekends-and-holidays-from-a-formula-sample
Sheet: September 2008

Month | 2008-09-01 00:00:00
 |  | Reg 1 | Reg 2 | Reg 3 | Reg 4 | Reg 5 | Reg 6 | Reg 7 | Reg 8
Monday | 2008-09-01 00:00:00 | [NAME] |  | Colclough |  | LUMSDEN |  | WARD | HARDING
Tuesday | 2008-09-02 00:00:00 | [NAME] |  |  |  | LUMSDEN |  | WARD | HARDING
Wednesday | 2008-09-03 00:00:00 | [NAME] | PATTIN |  | [NAME]* | LUMSDEN | [NAME]* | WARD | HARDING
Thursday | 2008-09-04 00:00:00 | [NAME] | PATTIN |  | [NAME]* | LUMSDEN | [NAME]* | WARD | HARDING
Friday | 2008-09-05 00:00:00 | [NAME] | PATTIN |  |  | LUMSDEN |  | WARD | HARDING
Saturday | 2008-09-06 00:00:00 | [NAME] | PATTIN |  |  | LUMSDEN |  | WARD
Sunday | 2008-09-07 00:00:00 | [NAME] | PATTIN |  |  | LUMSDEN
Monday | 2008-09-08 00:00:00 | [NAME] |  |  |  | LUMSDEN |  | BLOOR
Tuesday | 2008-09-09 00:00:00 | [NAME] |  |  |  | LUMSDEN
Wednesday | 2008-09-10 00:00:00 |  |  | PHILIPS ap * |  | LUMSDEN
Thursday | 2008-09-11 00:00:00 | Not in use |  | AMY /singh |  | LUMSDEN
Friday | 2008-09-12 00:00:00 | Not in use | flanaga |  |  | LUMSDEN |  | EFTHYMIOU
Saturday | 2008-09-13 00:00:00 | Not in use | flanaga |  |  |  |  | EFTHYMIOU | PattyRegM
Sunday | 2008-09-14 00:00:00 | Not in use | flanaga |  |  |  |  | EFTHYMIOU | PattyRegM
Monday | 2008-09-15 00:00:00 | Not in use | flanaga | BAXTER | [NAME] | CROWTHER | [NAME] | EFTHYMIOU | PATTY
Tuesday | 2008-09-16 00:00:00 | Not in use | flanaga | BAXTER | DOWKER | CROWTHER | DOWKER | COX | PATTY
Wednesday | 2008-09-17 00:00:00 | Not in use | flanaga | BAXTER | DOWKER | CROWTHER | DOWKER | COX | PATTY
Thursday | 2008-09-18 00:00:00 |  | BOWN | BAXTER | DOWKER | CROWTHER | DOWKER | COX | PATTY
Friday | 2008-09-19 00:00:00 |  | BOWN | ADE | DOWKER | CROWTHER | DOWKER | COX
Saturday | 2008-09-20 00:00:00 |  | BOWN | ADE | DOWKER | CROWTHER | DOWKER | COX | DEAN
Sunday | 2008-09-21 00:00:00 |  |  | ADE | DOWKER |  | DOWKER | COX | DEAN
Monday | 2008-09-22 00:00:00 | ANDY MINI |  |  | DOWKER |  | DOWKER | COX | SARAH
Tuesday | 2008-09-23 00:00:00 |  |  |  | DOWKER |  | DOWKER |  | [NAME]
Wednesday | 2008-09-24 00:00:00 |  | COCKLE |  |  | HASSET*** |  |  | [NAME]
Thursday | 2008-09-25 00:00:00 |  | COCKLE |  | CHRIS sales | HASSET*** | CHRIS sales |  | SERVICE
Friday | 2008-09-26 00:00:00 |  | COCKLE |  |  | HASSET*** |  | IB
Saturday | 2008-09-27 00:00:00 |  | COCKLE | Ange | [NAME] | HASSET*** | [NAME] | IB | BEAN**
Sunday | 2008-09-28 00:00:00 |  | COCKLE | Ange | [NAME] | [NAME] | [NAME] | IB | BEAN**
Monday | 2008-09-29 00:00:00 |  | COCKLE | BAXTER | DEARSLEY | LANG | DEARSLEY |  | BEAN**
Tuesday | 2008-09-30 00:00:00 |  | COCKLE | BAXTER | DEARSLEY | LANG | DEARSLEY |  | BEAN**
 | 30 | 17 | 21 | 14 | 16 | 25 | 16 | 21 | 21
 | Out of Service | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Utilisation | 0.4347826086956522 | 0.7 | 0.4666666666666667 | 0.5333333333333333 | 0.8333333333333334 | 0.5333333333333333 | 0.7 | 0.7
 | Workdays | 22
 | Monthly Utilisation | 0.6126811594202899
Spreadsheet: 105486d1302813805-hlookup-example-2-
Sheet: Sheet2

Name Here
 | 2011-04-14 00:00:00
Course - 6C62890
 | 2011-04-10 00:00:00
Course - TR009046
 | 2011-04-14 00:00:00
Course - 75402RC
 | 2011-04-19 00:00:00
Course - 6C62890
Spreadsheet: lynn_blair__24484__NNGWKednotes_2001
Sheet: September 8 & 9, 2001

NNG WEEKEND NOTES
For cc Mail distribution:  [NAME], [NAME], [NAME], S. January, [NAME], [NAME], [NAME], TMS OnCall
SATURDAY |  |  | 2001-09-08 00:00:00
Mail distribution send to the above listing on Sunday evening.
H:\DATA\Process Guidelines\[NNGWKednotes Template.xls]Dec 25 & 26
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SAT |  |  | No difficulties with this process
 | 7:00 A.M. Non-grid:
 | Gas Day: | FRI |  |  | No difficulties with this process
 | 8:00 AM Final Storage
 | Gas Day: | SAT |  |  | No difficulties with this process
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SAT |  |  | No difficulties with this process
 | 5:00 P.M. Intraday 2:
 | Gas Day: | SUN |  |  | No difficulties with this process
 | 11:30 A.M. Timely
 | Gas Day: | SUN |  |  | No difficulties with this process
 | 6:00 P.M. Evening
 | Other Comments:
 |  |  |  |  | Lights went off about 2:30 pm until 10:00 pm, and air went off but never came back on.
 | On Call Reps. |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
SUNDAY
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SUN |  |  | No difficulties with this process
 | 7:00 A.M. Non-grid:
 | Gas Day: | SAT |  |  | IT had an image problem were I couldno0t access the 8:00am cycle.
 | 8:00 AM Final Storage |  |  |  | I was able to run the prelin 8:00am cycle at 7:00am. [NAME] repaired the
 |  |  |  |  | problem. I was down about one hour and a half……[NAME]
 | Gas Day: | SUN |  |  | No difficulties with this process
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SUN |  |  | No difficulties with this process
 | 5:00 P.M. Intraday 2:
 | Gas Day: | MON |  |  | No difficulties with this process
 | 11:30 A.M. Timely
 | Gas Day: | MON |  |  | No difficulties with this process
 | 6:00 P.M. Evening
 | Other Comments:  Received several calls from customers regarding not being able to get
 | into Hottap.  Some of them were working from home and did not download
 | new files in order to get into TMS.  Calls were referred to [NAME].
 | Did not have to extend any timelines.   [NAME]
 |  |  | The lights and air went off at 8:00am and didn’t come
 |  |  | on until 9:45am.  [NAME]
 | On Call Reps: |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
Spreadsheet: 741765d1627319571-using-letters-to-calculate-in-a-cell-mwr-log-1-
Sheet: JULY

Date | Where | Start | End | Time | V | Milage | MPG | GALS | Reason | Expense | [NAME] CODE | To - From | Milage | Address | Vehicle | code | number
2021-07-02 00:00:00 | C-T-N-K-C | 10 | 1 | 3 | C | 74.8 | 21 |  | TAKE INJURED HAWK TO VAL-INSTALL LISA MARIE CAGE LOCK-TAKE RUFOUS TO DEB |  | A | Home - ARK | 18 | 7001 [NAME] | C
2021-07-06 00:00:00 | 660 WOODSMOKE DR | 10 | 12 | 2 | J | 9.3 | 16 |  | CAPTURE HAWK FAIL |  | B | Home - MWR | 27.7 | 3901-3913 Arkabutla Dam Rd | J
2021-07-12 00:00:00 | B-M-D | 8 | 3 | 7 | T | 50.7 | 13 |  | MEET VALERY TO MEASURE MAYAS CAGE - BUILD PERCH AND ADD GRASS TO MAYAS CAGE |  | C | Home - Debbie | 5.4 | 9180 Bethal Rd | T
2021-07-15 00:00:00 | 1390 Craft | 9 | 10 | 1 | J | 8 | 16 |  | Rescue RT Hawk |  | D | Home - Stephanie | 11 | 3997 [NAME]
2021-07-16 00:00:00 | B | 9 | 12 | 3 | J | 55.4 | 16 |  | MISTERS - KANE |  | E | Home - Valery | 17 | 9865 Green River Rd.
2021-07-20 00:00:00 | A-J-E | 12 | 5 | 6 | C | 40.3 | 21 |  | CLEAN ARK - MEASURE VALERY CAGES |  | F | Home - HD | 3.6 | 7740 Craft - Goodman Rd
2021-07-21 00:00:00 | E | 10 | 3 | 5 | T | 34 | 13 |  | REPAIR SMALL CAGE ROOF |  | G | ARK - MWR | 10
2021-07-22 00:00:00 | E | 10 | 4 | 6 | T | 34 | 13 |  | REPAIR SPIRIT'S CAGE ROOF |  | H | ARK - Debbie | 20
2021-07-23 00:00:00 | B | 10 | 1 | 3 | C | 55.4 | 21 |  | REPAIR MISTER |  | I | ARK - Stephanie | 12
 |  |  |  |  | T | 10 | 13 |  |  |  | J | ARK - Valery | 5.3
 |  |  |  |  |  |  |  |  |  |  | K | MWR - Debbie | 31
 |  |  |  |  |  |  |  |  |  |  | M | MWR - Stephanie | 12
 |  |  |  |  |  |  |  |  |  |  | N | MWR - Valery | 11
 |  |  |  |  |  |  |  |  |  |  | O | HD - Debbie | 6.9
 |  |  |  |  |  |  |  |  |  |  | P | HD - Stephanie | 23
 |  |  |  |  |  |  |  |  |  |  | Q | HD - ARK | 26
 |  |  |  |  |  |  |  |  |  |  | R | HD - MWR | 36
 |  |  |  |  |  |  |  |  |  |  | S | Debbie - Stephanie | 13
 |  |  |  |  |  |  |  |  |  |  | T | Debbie - Valery | 22
 |  |  |  |  |  |  |  |  |  |  | U | Stephanie - Valery | 18
Spreadsheet: 121474d1316090793-how-to-use-multiple-autofilters-nhl94-player-ratings
Sheet: Calgary

Flames
Pos. | Name | Hand | # | Wgt | [NAME] | Spd | Off | Def | [NAME] | Chk | [NAME] | Shot Acc | Endr | Stick Lt | [NAME] | Glove Lt
G | [NAME] | L | 30 | 172 | 55 | 65 | 65 | 65 | 65 | 25 | 25 | 25 | 65 | 65 | 55 | 55
G | [NAME] | L | 35 | 172 | 45 | 55 | 65 | 65 | 45 | 25 | 25 | 25 | 45 | 45 | 55 | 55
Pos. | Name | Hand | # | Wgt | [NAME] | Spd | Off | Def | [NAME] | Chk | [NAME] | Shot Acc | Endr | ??? | Pass | Aggr
C | [NAME] | L | 25 | 204 | 65 | 65 | 65 | 55 | 65 | 55 | 65 | 65 | 65 | 55 | 45 | 45
C | [NAME] | L | 26 | 188 | 65 | 65 | 65 | 55 | 65 | 45 | 65 | 65 | 55 | 45 | 65 | 45
C | [NAME] | R | 29 | 228 | 65 | 55 | 55 | 85 | 45 | 85 | 55 | 65 | 65 | 35 | 45 | 65
C | [NAME] | L | 11 | 196 | 55 | 65 | 45 | 55 | 45 | 45 | 55 | 55 | 45 | 55 | 45 | 35
LW | [NAME] | L | 10 | 196 | 65 | 65 | 85 | 65 | 65 | 65 | 65 | 85 | 85 | 35 | 55 | 65
LW | [NAME] | R | 28 | 204 | 65 | 65 | 55 | 65 | 55 | 35 | 65 | 55 | 55 | 65 | 55 | 35
LW | [NAME] | L | 15 | 220 | 55 | 55 | 55 | 65 | 55 | 65 | 55 | 45 | 65 | 65 | 55 | 55
LW | [NAME] | L | 16 | 212 | 45 | 55 | 35 | 35 | 45 | 45 | 35 | 35 | 35 | 65 | 35 | 65
RW | Theoren Fleury | R | 14 | 164 | 85 | 85 | 65 | 85 | 65 | 65 | 65 | 55 | 100 | 35 | 55 | 55
RW | [NAME] | L | 42 | 188 | 85 | 65 | 65 | 45 | 45 | 35 | 85 | 65 | 55 | 25 | 85 | 45
RW | [NAME] | R | 23 | 196 | 45 | 45 | 55 | 35 | 55 | 45 | 55 | 65 | 45 | 45 | 45 | 25
RW | [NAME] | R | 22 | 204 | 45 | 45 | 45 | 35 | 45 | 55 | 45 | 55 | 35 | 55 | 45 | 65
Pos. | Name | Hand | # | Wgt | [NAME] | Spd | Off | Def | [NAME] | Chk | [NAME] | Shot Acc | Endr | ??? | Pass | Aggr
D | [NAME] | L | 20 | 196 | 85 | 65 | 65 | 85 | 65 | 65 | 65 | 45 | 85 | 45 | 65 | 55
D | [NAME] | L | 5 | 204 | 55 | 55 | 35 | 65 | 55 | 55 | 55 | 35 | 55 | 85 | 45 | 55
D | Trent Yawney | L | 18 | 196 | 55 | 45 | 45 | 65 | 45 | 55 | 55 | 25 | 55 | 35 | 55 | 55
D | [NAME] | L | 3 | 212 | 65 | 65 | 45 | 55 | 45 | 55 | 45 | 35 | 55 | 85 | 45 | 55
D | [NAME] | L | 34 | 196 | 65 | 55 | 45 | 45 | 45 | 55 | 55 | 35 | 45 | 55 | 55 | 45
D | [NAME] | R | 4 | 196 | 45 | 55 | 45 | 65 | 45 | 55 | 55 | 35 | 55 | 35 | 55 | 45
D | [NAME] | R | 2 | 204 | 65 | 65 | 65 | 55 | 100 | 55 | 65 | 35 | 85 | 45 | 65 | 55
D | [NAME] | R | 7 | 212 | 55 | 55 | 45 | 55 | 65 | 55 | 65 | 35 | 55 | 55 | 55 | 55
D | [NAME] | R | 6 | 220 | 25 | 25 | 35 | 25 | 25 | 35 | 25 | 35 | 35 | 65 | 25 | 65
Spreadsheet: 478240d1472695412-attendance-sheet-how-to-best-summarise-data-attendance-sheet-how-to-best-summarise-data
Sheet: Sheet4

Row Labels | Max of Time
[NAME]
2016-08-29 00:00:00
In | 08:00:00
Out | 09:00:00
8/29/2016 Total | 09:00:00
2016-08-30 00:00:00
In | 08:00:00
Out | 09:00:00
8/30/2016 Total | 09:00:00
2016-08-31 00:00:00
In | 12:00:00
Out | 14:00:00
8/31/2016 Total | 14:00:00
2016-09-01 00:00:00
In | 06:30:00
Out | 15:30:00
9/1/2016 Total | 15:30:00
Clinton Total | 15:30:00
[NAME]
2016-08-28 00:00:00
In | 11:00:00
Out | 12:00:00
8/28/2016 Total | 12:00:00
2016-08-29 00:00:00
In | 10:00:00
Out | 11:00:00
8/29/2016 Total | 11:00:00
2016-08-30 00:00:00
In | 10:00:00
Out | 11:00:00
8/30/2016 Total | 11:00:00
2016-08-31 00:00:00
In | 11:00:00
Out | 12:00:00
8/31/2016 Total | 12:00:00
2016-09-01 00:00:00
In | 07:00:00
Out | 14:00:00
9/1/2016 Total | 14:00:00
[NAME] | 14:00:00
[NAME] | 21:00:00
Spreadsheet: 787157d1657646350-cannot-return-header-based-on-specific-value-due-to-duplicate-value-copy
Sheet: E2

 |  |  | E2 | 2022-07-01 00:00:00 | 2022-07-02 00:00:00 | 2022-07-03 00:00:00 | 2022-07-04 00:00:00 | 2022-07-05 00:00:00 | 2022-07-06 00:00:00 | 2022-07-07 00:00:00 | 2022-07-08 00:00:00 | 2022-07-09 00:00:00 | 2022-07-10 00:00:00 | 2022-07-11 00:00:00
 |  |  | A1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | A2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | A3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | A4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | A5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | A6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | A7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | A8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | A9 | 6 | 0 | 4 | 36 | 0 | 0 | 0 | 8 | 5 | 0 | 0
 |  |  | A10 | 11 | 167 | 3 | 0 | 8 | 3 | 4 | 6 | 0 | 0 | 7
 |  |  | A11 | 0 | 4 | 2 | 0 | 0 | 9 | 8 | 5 | 0 | 0 | 6
 |  |  | A12 | 6 | 0 | 2 | 0 | 0 | 0 | 2 | 0 | 0 | 4 | 0
 |  |  | A13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | A14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | A15 | 12 | 7 | 19 | 0 | 8 | 0 | 13 | 0 | 3 | 6 | 16
 |  |  | A16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | A17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | A18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | A19 | 0 | 0 | 13 | 32 | 0 | 2 | 0 | 0 | 0 | 2 | 3
 |  |  | A20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | A21 | 0 | 0 | 2 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0
 |  |  | A22 | 34 | 28 | 10 | 23 | 12 | 11 | 15 | 0 | 4 | 45 | 10
 |  |  | A23 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | A24 | 10 | 46 | 8 | 4 | 0 | 9 | 7 | 137 | 11 | 3 | 11
 |  |  | A25 | 4 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 0 | 0 | 22
 |  |  | A26 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 6
 |  |  | A27 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | A28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | A29 | 0 | 0 | 0 | 0 | 7 | 2 | 2 | 0 | 0 | 0 | 0
 |  |  | A30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | A31 | 4 | 3 | 2 | 0 | 4 | 4 | 0 | 0 | 0 | 0 | 4
 |  |  | A32 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | A33 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | A34 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | [NAME] | 125 | 20 | 325 | 69 | 47 | 181 | 303 | 99 | 193 | 137 | 151
 |  |  | A36 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 836228d1689182962-how-to-sum-comparing-two-lists-and-return-differences-compare-data
Sheet: Sheet1

 | Data 1 |  |  |  |  |  | Data 2
 | Package | Product Code | Unit | Compare Total Units |  |  | Package | Product Code | Unit
 | 1 | Pen01 | 1 | Not Match |  |  | 3 | BW0021 | 1
 | 1 | Pen01 | 1 | Not Match |  |  | 3 | MK002 | 1
 | 1 | AP001 | 1 | Not Match |  |  | 3 | [NAME] | 1
 | 2 | MK002 | 1 | Match |  |  | 3 | [NAME] | 1
 | 2 | MK002 | 1 | Match |  |  | 3 | AKW001 | 1
 | 2 | MK002 | 1 | Match |  |  | 3 | AKW001 | 1
 | 2 | AP001 | 1 | Match |  |  | 3 | BW0021 | 1
 | 3 | BW0021 | 1 | Match |  |  | 5 | AP001 | 1
 | 3 | BW0021 | 1 | Match |  |  | 5 | PD0012 | 1
 | 3 | MK002 | 1 | Match |  |  | 5 | Pen01 | 1
 | 3 | [NAME] | 1 | Match |  |  | 5 | [NAME] | 1
 | 3 | [NAME] | 1 | Match |  |  | 5 | [NAME] | 1
 | 3 | AKW001 | 1 | Match |  |  | 5 | AKW001 | 1
 | 3 | AKW001 | 1 | Match |  |  | 5 | MK002 | 1
 | 4 | CK0201 | 1 | Not Match |  |  | 5 | MK002 | 1
 | 4 | AP001 | 1 | Not Match |  |  | 5 | AP001 | 1
 | 4 | JK0021 | 1 | Not Match |  |  | 1 | Pen01 | 1
 | 4 | JK0021 | 1 | Not Match |  |  | 1 | Pen01 | 1
 | 5 | AP001 | 1 | Not Match |  |  | 1 | AP001 | 1
 | 5 | PD0012 | 1 | Not Match |  |  | 1 | AP001 | 1
 | 5 | Pen01 | 1 | Not Match |  |  | 4 | QB0012 | 1
 | 5 | [NAME] | 1 | Not Match |  |  | 4 | CK0201 | 1
 | 5 | AKW001 | 1 | Not Match |  |  | 4 | AP001 | 1
 | 5 | MK002 | 1 | Not Match |  |  | 4 | JK0021 | 1
 | 5 | MK002 | 1 | Not Match |  |  | 4 | JK0021 | 1
 |  |  |  |  |  |  | 2 | MK002 | 1
 |  |  |  |  |  |  | 2 | MK002 | 1
 |  |  |  |  |  |  | 2 | MK002 | 1
 |  |  |  |  |  |  | 2 | AP001 | 1