tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: chris_germany__2125__JanCohCHOICE-ENA
Sheet: Jan 30

 | CES/NPC COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2001-01-30 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 829 |  | 529 |  | 67694 |  |  |  |  |  | 36 | 1 | 38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 | 2 | 40
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 311 |  | 0 |  | 67694 |  |  |  |  |  | 36 | 3 | 38
 |  |  |  |  |  |  |  |  | 6999 |  | 6999 |  | 68918 | 0 |  |  |  |  | 37 | 4 | 39
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38 | 5 | 40
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 613 |  | 486 |  | 67694 |  |  |  |  |  | 36 | 6 | 38
 |  |  |  |  |  |  |  |  | 2400 |  | 2400 |  | 68915 | 0 |  |  |  |  | 38 | 7 | 39
 |  |  |  |  |  |  |  |  | 500 |  | 500 |  | 69148 | 0 |  |  |  |  | 40 | 8 | 43
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 | 0 |  |  |  |  | 40 | 9 | 41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44 | 15 | 51
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 9730 |  | 8432 |  | 67694 |  |  |  |  |  | 41 | 35 | 42
 |  |  |  |  |  |  |  |  | 85 |  | 85 |  | 68917 | 0 |  |  |  |  | 37 | 39 | 39
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69149 | 0
 |  |  |  |  |  |  |  |  | 1600 |  | 1600 |  | 69693 | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 739 |  | 540 |  | 67694 |  |  |  |  |  | %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Storage
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 346 |  | 191 |  | 67694 |  |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  | 1915 |  | 1915 |  | 68916 | 0 |  |  |  |  | 1
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 9013 |  | 7775 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 2995 |  | 2782 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 2836 |  | 2495 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 3231 |  | 3088 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 619 |  | 541 |  | 67694
 |  |  |  |  |  |  |  |  | 200 |  | 200 |  | 69708 | 0
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 28 |  | 26 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 3 |  | 3 |  | 69708 | 0
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  | 27835 | Pull from ENA Pool to NPC Pool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 271745d1382032820-index-match-with-date-range-criteria-formula-test-10-16
Sheet: P List

 |  |  | ID1 | ID2 |  |  | Name | SI | Exec | Mgr | Status | iStatus | Budget | IN | iDate | R | AR |  | Short Name
 |  |  | 12345 | 18000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O
 |  |  | 16888 | 16888 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E
 |  |  | 16565 | 16565 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MS
Spreadsheet: a7249e02-85e8-4e4b-a9c8-13fb3a864bb3
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
43115849 | 2014-09-11 19:51:39 | AXIS | 0 | 4 | 6 | 832450 | [NAME] | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
43116207 | 2014-09-11 20:13:22 | ALLIES | 0 | 3 | 6 | 832450 | [NAME] | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
Spreadsheet: jonathan_mckay__16911__Telus Convention Centre3
Sheet: Deal Sheet

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | ECC |  |  |  | Deal Date: | 2001-07-19 00:00:00 |  |  |  |  |  |  | 3 | March
Originator: | Greg Frers |  |  |  | Deal ID #: |  |  |  |  |  |  |  | 4 | April
 | Telus Comvention Centre |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-10-01 00:00:00 |  |  |  | Unit of Measure: | GJ |  |  |  |  |  |  | 6 | June
Deal End Date: | 2002-09-30 00:00:00 |  |  |  | Volume (Monthly/Daily): | Monthly |  |  |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  | Price: | Buy |  |  |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  | Buy/Sell: |  |  |  |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Combined Volume | Fuel | Total
 | January | 0 | 7500
 | February | 0 | 6900
 | March | 0 | 6240
 | April | 0 | 5500
 | May | 0 | 3650
 | June | 0 | 3400
 | July | 0 | 2600
 | August | 0 | 2000
 | September | 0 | 3500
 | October | 0 | 5200
 | November | 0 | 6800
 | December | 0 | 7200
 | TOTAL:
Spreadsheet: 854551d1704382356-vlookup-with-two-criteria-example
Sheet: Sheet1

 |  | Status | Date | Project |  |  | Project | Status | Date
 |  | Delivered | 2023-11-01 00:00:00 | Project 1 |  |  | Project 1 | Delivered
 |  | Delivered | 2023-10-01 00:00:00 | Project 1 |  |  | Project 2 | Delivered
 |  | Not Delivered | 2023-09-01 00:00:00 | Project 1
 |  | Not Delivered | 2023-08-01 00:00:00 | Project 1
 |  | Not Delivered | 2023-07-01 00:00:00 | Project 1
 |  | Not Delivered | 2023-06-01 00:00:00 | Project 1
 |  | Not Delivered | 2023-05-01 00:00:00 | Project 1
 |  | Not Delivered | 2023-04-01 00:00:00 | Project 1
 |  | Delivered | 2023-11-01 00:00:00 | Project 2
 |  | Delivered | 2023-10-01 00:00:00 | Project 2
 |  | Delivered | 2023-09-01 00:00:00 | Project 2
 |  | Not Delivered | 2023-08-01 00:00:00 | Project 2
 |  | Not Delivered | 2023-07-01 00:00:00 | Project 2
 |  | Not Delivered | 2023-06-01 00:00:00 | Project 2
 |  | Not Delivered | 2023-05-01 00:00:00 | Project 2
 |  | Not Delivered | 2023-04-01 00:00:00 | Project 2
Spreadsheet: 06bcdc5e-c0c5-4fa4-ad33-c8d476752fc0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8501.0 Retail Trade, Australia
 | TABLE 14. Retail Turnover; Completely Enumerated (large) and Sample (small), By Industry Group
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Turnover ;  Total Sample Sector ;  Total (State) ;  Food retailing ; |  |  | Original | [NAME] | 1994-04-01 00:00:00 | 2012-03-01 00:00:00 | 216 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  Food retailing ; |  |  | Original | A3350086L | 1994-04-01 00:00:00 | 2012-03-01 00:00:00 | 216 | $ Millions | FLOW | Month | 1
Turnover ;  Total Sample Sector ;  Total (State) ;  Household goods retailing ; |  |  | Original | A3350186W | 1994-04-01 00:00:00 | 2012-03-01 00:00:00 | 216 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  Household goods retailing ; |  |  | Original | A3350102A | 1994-04-01 00:00:00 | 2012-03-01 00:00:00 | 216 | $ Millions | FLOW | Month | 1
Turnover ;  Total Sample Sector ;  Total (State) ;  [NAME], footwear and personal accessory retailing ; |  |  | Original | A3350182L | 1994-04-01 00:00:00 | 2012-03-01 00:00:00 | 216 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  [NAME], footwear and personal accessory retailing ; |  |  | Original | A3350190L | 1994-04-01 00:00:00 | 2012-03-01 00:00:00 | 216 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  Department stores ; |  |  | Original | A3350104F | 1994-04-01 00:00:00 | 2012-03-01 00:00:00 | 216 | $ Millions | FLOW | Month | 1
Turnover ;  Total Sample Sector ;  Total (State) ;  Other retailing ; |  |  | Original | A3350187X | 1994-04-01 00:00:00 | 2012-03-01 00:00:00 | 216 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  Other retailing ; |  |  | Original | A3350128X | 1994-04-01 00:00:00 | 2012-03-01 00:00:00 | 216 | $ Millions | FLOW | Month | 1
Turnover ;  Total Sample Sector ;  Total (State) ;  Cafes, restaurants and takeaway food services ; |  |  | Original | A3350074C | 1994-04-01 00:00:00 | 2012-03-01 00:00:00 | 216 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  Cafes, restaurants and takeaway food services ; |  |  | Original | A3350097V | 1994-04-01 00:00:00 | 2012-03-01 00:00:00 | 216 | $ Millions | FLOW | Month | 1
Turnover ;  Total Sample Sector ;  Total (State) ;  Total (Industry) ; |  |  | Original | A3350099X | 1994-04-01 00:00:00 | 2012-03-01 00:00:00 | 216 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  Total (Industry) ; |  |  | Original | A3350113J | 1994-04-01 00:00:00 | 2012-03-01 00:00:00 | 216 | $ Millions | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 859022d1707490498-looking-for-a-way-to-automate-scheduling-duos-into-different-squads-sample-scheduling-bsweet0us-
Sheet: Squad schedule 2

Squad 1 | 2024-01-12 00:00:00 |  | Squad 2 | 2024-01-13 00:00:00 |  | Squad 3 | 2024-01-14 00:00:00 |  | Squad 4 | 2024-01-15 00:00:00 |  | Squad 5 | 2024-01-16 00:00:00 |  | Squad 6 | 2024-01-17 00:00:00
 |  |  |  |  |  | Bobbi [NAME] | [NAME] |  |  |  |  | [NAME] | [NAME]
Squad 7 | 2024-01-18 00:00:00 |  | Squad 8 | 2024-01-19 00:00:00 |  | Squad 9 | 2024-01-20 00:00:00 |  | Squad 10 | 2024-01-21 00:00:00 |  | Squad 11 | 2024-01-22 00:00:00 |  | Squad 12 | 2024-01-23 00:00:00
Squad 13 | 2024-01-24 00:00:00 |  | Squad 14 | 2024-01-25 00:00:00 |  | Squad 15 | 2024-01-26 00:00:00 |  | Squad 16 | 2024-01-27 00:00:00 |  | Squad 17 | 2024-01-28 00:00:00 |  | Squad 18 | 2024-01-29 00:00:00
Squad 19 | 2024-01-30 00:00:00 |  | Squad 20 | 2024-01-31 00:00:00 |  | Squad 21 | 2024-02-01 00:00:00 |  | Squad 22 | 2024-02-02 00:00:00 |  | Squad 23 | 2024-02-03 00:00:00 |  | Squad 24 | 2024-02-04 00:00:00
Spreadsheet: 52269d1251981674-cant-unhide-cells-and-got-hidden-formulas-personal-account
Sheet: Pay Type

 | TRANSACTION TYPES
1 | [NAME]
2 | [NAME]
3 | Cash
4 | Cheque
5 | DD
6 | SO
7 | Transfer
8
9
10
11
12
13
14
15
Spreadsheet: 868919d1715620485-multi-layer-vlookup-return-a-blank-instead-of-0-workbook-1
Sheet: Patient List

Lookup | Patient Last | Patient First | [NAME] | Doctor [NAME] | Referral From | Copay/Coins/Payment Plan | Ins Group Name | Primary Ins Number | Primary Ins Group Number |  |  | East/ West | DOB | Sex | Address | City | State | Zip | Phone
 | A | D |  |  |  |  | Aetna Medicare Value Plan PPO
Spreadsheet: 765329d1643282745-how-to-use-vlookup-for-multiples-rows-test
Sheet: Sheet1

ID | ID No. | Employee Name |  |  | ID |  | ID No. | Employee Name
imti | 78 | Md.Imtiaz |  |  | [NAME]
imti | 72 | [NAME] |  |  |  |  | 100 | [NAME]
[NAME] | 96 | Md. Nasir |  |  |  |  | 17 | Anika
[NAME] | 100 | [NAME]
[NAME] | 17 | Anika |  |  | ID |  | ID No. | Employee Name
nabi | 47 | Masrur |  |  | nabi
nabi | 71 | Afroza |  |  |  |  | 71 | Afroza
nabi | 81 | Mafuz |  |  |  |  | 81 | Mafuz
nabi | 90 | Md. [NAME] |  |  |  |  | 90 | Md. [NAME]
Spreadsheet: 156206d1337223193-how-to-copy-data-from-master-list-sheet-to-another-sheet-based-on-category-ifjsss-round-2-data
Sheet: master list

 | Master List
No | RIDER | TEAM | CRAFT | CRAFT TYPE | CATEGORY
 |  |  |  |  | Pro Am Open | Pro Am Stock | Ladies Open | Vaterens
1 | [NAME] | Club [NAME] (CTM) | ML 20 | SeaDoo | Yes |  |  | Yes
2 | [NAME] | Waklan Racing Team | WL 2 | SeaDoo | Yes
3 | [NAME] | Fishbone Racing Team | 9 | SeaDoo
4 | [NAME] | X1 Racing Team | 314 | SeaDoo |  | Yes
5 | [NAME] | WL Racing Team | WL 1 | SeaDoo | Yes | Yes |  | Yes
6 | [NAME] | Fishbone Racing Team | 29 | SeaDoo |  | Yes
7 | [NAME] | [NAME] | 6 | SeaDoo |  | Yes
8 | [NAME] | Meganrata Racing Team | ML 3 | SeaDoo | Yes | Yes
9 | Elgernon [NAME] | [NAME] | 811 | SeaDoo | Yes | Yes |  | Yes
10 | [NAME] | Huat Motor Sports | 88 | SeaDoo | Yes
11 | [NAME] | Meganrata Racing Team | 5 | SeaDoo
12 | [NAME] | Yamaha Racing Team | 16 | Yamaha
13 | [NAME] | Team LT-Kawasaki | 89 | SeaDoo | Yes | Yes
14 | [NAME] | [NAME] | ML 61 | SeaDoo | Yes |  |  | Yes
15 | [NAME] | Club Racing Team (CTM) | 25 | SeaDoo |  | Yes
16 | [NAME] [NAME] | [NAME] | 318 | Kawasaki | Yes | Yes |  | Yes
17 | [NAME] | Team LT-Kawasaki | 17 | Kawasaki |  |  |  | Yes
18 | [NAME] | Huat Motor Sports | 8 | SeaDoo |  |  |  | Yes
19 | [NAME] | Meganrata Racing Team | 7 | SeaDoo | Yes | Yes |  | Yes
20 | [NAME] | X1 Racing Team | ML 7 | Kawasaki | Yes | Yes
21 | [NAME] | [NAME] | 29 | SeaDoo |  | Yes
22 | Ika [NAME] | Club [NAME] (CTM) | 373 | Yamaha |  |  | Yes
23 | [NAME] | Team LT-Kawasaki | 17 | Kawasaki |  |  | Yes
24 | [NAME] | Club [NAME] (CTM) | 37 | Yamaha |  |  | Yes
25 | [NAME] binti [NAME] | Team LT-Kawasaki | 89 | Kawasaki |  |  | Yes
Spreadsheet: f2c4dea8-de2d-474c-b580-a02ed79781df
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
43466154 | 2014-10-06 18:29:48 | ALLIES | 0 | 5 | 6 | 1620870 | diallo82 | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
43466329 | 2014-10-06 18:36:47 | AXIS | 0 | 3 | 6 | 1620870 | diallo82 | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
43466492 | 2014-10-06 18:57:35 | AXIS | 1 | 6 | 2 | 1537209 | bynumbill | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
43593660 | 2014-10-15 18:03:56 | ALLIES | 1 | 6 | 5 | 1654790 | [NAME] | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
Spreadsheet: 327782d1403687767-concatenate-variable-ranges-of-character-strings-tasasupd_0529upd-ans3
Sheet: Sheet6

[NAME] | K | I | PATTERN | COUNT
3308006 | 0 | 0
3308006 | 0 | 1 | 1
3315013 | 0 | 0
3315013 | 0 | 1 | 1
3442765 | 0 | 0
3442765 | 0 | 0
3442765 | 0 | 1
3442765 | 0 | 0 | 2
3504774 | 0 | 1
3504774 | 0 | 2
3504774 | 0 | 2 | 3
3505829 | 0 | 0
3505829 | 0 | 0
3505829 | 0 | 0 | 4
3515309 | 0 | 0
3515309 | 0 | 1
3515309 | 0 | 0 | 5
3540932 | 0 | 3
3540932 | 0 | 2 | 6
3548948 | 0 | 1
3548948 | 0 | 0
3548948 | 0 | 0 | 7
3333333 | 0 | 0
3333333 | 0 | 0
3333333 | 0 | 0 | 4
Spreadsheet: 6d4ea9ca-6f78-4a08-b3ba-89af5cb9026a
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
8037 | 47875 | [NAME] | Emmerson | GBR | 5480 | 00:00:00 | 00:00:00 | 00:04:49 | 00:01:08 | 00:18:59 | 1 | 00:24:57
8037 | 58157 | [NAME] | Molina | ESP | 5478 | 00:00:00 | 00:00:00 | 00:04:09 | [NAME] | 00:24:11 | 2 | 00:30:11
8037 | 49500 | Raul | [NAME] | ESP | 5479 | 00:00:00 | 00:00:00 | 00:06:17 | 00:01:40 | 00:24:20 | 3 | 00:32:18
Spreadsheet: 870699d1717164240-modifying-table-to-be-more-dynamic-book3
Sheet: Haldusaruanne

FinSummaHaldus |  |  |  |  |  |  |  |  | Kulukoht
Code |  |  | [NAME] |  | Client | Year |  |  | 5300 [NAME] otsused ja kohustused | 5340 Üür | 5312 [NAME] intressid | 5352 Kapiralirendi põhiosa maksed | 5353 Remondifondi laekumine
SEEMNE200 |  |  | 70000869 |  | Client1 | 2024 |  |  | 7657 |  |  |  | 5000
SEEMNE200 |  |  | 70000869 |  | Client1 | 2025 |  |  | 7657 |  |  |  | 5000
SEEMNE200 |  |  | 70000869 |  | Client1 | 2026 |  |  | 7657 |  |  |  | 5000
SEEMNE200 |  |  | 70000869 |  | Client1 | 2027 |  |  | 7657 |  |  |  | 5000
SEEMNE200 |  |  | 70000869 |  | Client1 | 2028 |  |  | 7657 |  |  |  | 5000
PURAVIKU4 |  |  | 70000869 |  | Client2 | 2024 |  |  | 10000 |  |  |  | 5000
PURAVIKU4 |  |  | 70000869 |  | Client2 | 2025 |  |  | 10000 |  |  |  | 5000
PURAVIKU4 |  |  | 70000869 |  | Client2 | 2026 |  |  | 10000 |  |  |  | 5000
PURAVIKU4 |  |  | 70000869 |  | Client2 | 2027 |  |  | 10000 |  |  |  | 5000
PURAVIKU4 |  |  | 70000869 |  | Client2 | 2028 |  |  | 10000 |  |  |  | 5000
Spreadsheet: 867118d1713997220-changing-template-data-employee-absence-report-copy-
Sheet: August

 | Employee Absence Report
 | August
 | Absence type key | V | Vacation (10) |  |  | P | Paid (2) |  |  | S | Unpaid (1) |  |  | U | Unauthorized |  |  | O | Other
 |  |  |  |  |  |  | Paid (2)
 |  | Dates of absence
 | Employee name | 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 | Total days
 | [NAME]. M  (PMO)
 | [NAME]. P  (PMO)
 | [NAME]. R  (GL)
 | [NAME]. M  (GL)
 | Teddy. M  (GL)
 | Krushna. J  (DLO)
 | [NAME]. W  (PFO)
 | Jaxon. B  (PMO)
 | Daman. S (PMO)
 | Alvin. C  (GL)
 | Baldomero. N  (GL)
 | Junner. B  (GL)
 | Heather. C  (PFO)
 | Jordan. B  (LO)
 | Santos. C  (GL)
 | Sunny. I  (GL)
 | Oliver. M  (PR)
 | [NAME]. C  (TL)
 | Justin. H  (YFO)
 | [NAME]. M  (YFO)
 | [NAME]. T  (YFO)
 | [NAME]. B  (SHC)
 | [NAME]. H  (IM)
 | [NAME]. A  (IM)
 | [NAME]. M  (IM)
 | Maryanne. B  (IMA)
 | Art. P  (MF)
 | Fabrice. M  (MF)
 | [NAME]. T (IE)
 | [NAME]. P  (IE)
 | Justin. N  (IEA)
 | Paige. B  (WMR)
 | Maryann. R  (PSC)
Spreadsheet: 168065d1342204489-excel-2007-help-pay-scale-calculation-sheet-help-hourly-timesheet-7-12-12
Sheet: Hourly Timesheet

 |  |  | DATE:
Employee Name:
 |  |  |  |  |  | Daily Timesheet
Date | Time | Hours | Job # | Class | Pay Rate | Total Pay
 | 07:00:00
 | 07:05:00 |  | 1254 | ELEC
 | 08:05:00 |  | 1255 | A/C M
 | 09:05:00 |  | 1252 | INSUL
 | 10:30:00 |  | 1255 | ELEC T
 | 13:30:00 |  | 1252 | A/C SRVC
 | 16:00:00 |  | 1252 | A/C SRVC H
 |  |  | 1252 | ELEC T
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
Current Jobs |  |  | Job Classes | CODE | [NAME]
 | 1252
 | 1254 |  |  | A/C M | A/C MECHANIC
 | 1255 |  |  | A/C M H | A/C MECHANIC HELPER
 | 1257 |  |  | A/C SRVC | A/C SERVICE MAN
 | 1279 |  |  | A/C SRVC H | A/C SERVICE MAN HELPER
 | 1280 |  |  | CRPT | CARPENTER
 |  |  |  | ELEC | ELECTRICIAN
 |  |  |  | ELEC T | ELECTRICIAN TECHNICIAN
 |  |  |  | INSUL | ASBESTOS / INSULATION WORKER
 |  |  |  | IRON WRKR | IRON WORKER
 |  |  |  | LAB | LABORER
 |  |  |  | LAB S | LABORER SKILLED
 |  |  |  | LAB UN-S | LABORER UN-SKILLED
 |  |  |  | PLMB-PFTR | PLUMBER-PIPEFITTER (INCL. HVAC)
 |  |  |  | PLMB-PFTR H | PLUMBER-PIPEFITTER HELPER (INCL. HVAC)
 |  |  |  | SMW | SHEET METAL WORKER
 |  |  |  | SMW DUCT | SHEET METAL WORKER (DUCT)
 |  |  |  | SMW DUCT H | SHEET METAL WORKER (DUCT) HELPER
 |  |  |  | SMW OTHER | SHEET METAL WORKER (OTHER)
 |  |  |  | SMW ROOF | SHEET METAL WORKER (ROOF)
 |  |  |  | SMW ROOF H | SHEET METAL WORKER (ROOF) HELPER
Spreadsheet: 731651d1620481030-formula-to-search-compare-data-from-multiple-sheets-search-for-terms-from-a-list-in-a-cell-macdoc-
Sheet: Register (2)

All_Fem_Catalog No. | Description | All_Tib_Catalog No. | Description | All_Inl_Catalog No. | Description | Firma
6307-00-020
Spreadsheet: 882472d1730862571-filter-vstack-multiple-tables-and-criteria-my-step-by-step-time-sheet-so-i-can-filter-_r2
Sheet: Oct 

Trainer Name | Student name: (first name, last name) | What action have you taken? | Session date: | How was the training conducted? | Travel time costs (if any) | Travel mileage (if any) | What was training subject 1? (select from drop down list) | Training subject 1 - how much time () did you train on this today? (select from drop down list) | What was training subject 2? (select from drop down list) | Training subject 2 (if appropriate) - how much time (hours) did you train on this today? | What was training subject 3? (select from drop down list) | Training subject 3 (if appropriate) - how much time (hours) did you train on this today? | Ad-hoc fee - If you completed approved training or a service that is not on the list or is ad-hoc briefly summarise here. Include as much detail as is needed. | Rate | Count | Value
[NAME] | [NAME] | I am notifying a non-attendance | 2022-10-03 00:00:00 | Remote training via Zoom video conferencing |  |  |  |  |  |  |  |  |  | 30 | 1 | 30
[NAME] | [NAME] | I am notifying a non-attendance | 2022-10-04 00:00:00 | Remote training via Zoom video conferencing |  |  |  |  |  |  |  |  |  | 30 | 1 | 30
[NAME] | [NAME] | I have completed today's training | 2022-10-06 00:00:00 | Remote training via Zoom video conferencing |  |  | Unit 121 - Admin Processes | 1.5 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2022-10-17 00:00:00 | Remote training via Zoom video conferencing |  |  | Unit 121 - Admin Processes | 1.5 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2022-10-18 00:00:00 | Remote training via Zoom video conferencing |  |  | Unit 121 - Admin Processes | 0.5 | Unit 327 - Business Transactions | 1 |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2022-10-19 00:00:00 | Remote training via Zoom video conferencing |  |  | Unit 327 - Business Transactions | 1.5 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2022-10-20 00:00:00 | Remote training via Zoom video conferencing |  |  | Unit 327 - Business Transactions | 1.5 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed a TNA | 2022-10-27 00:00:00 | Student to Trainer |  |  |  |  |  |  |  |  |  | 50 | 1 | 50
[NAME] | [NAME] | I have completed today's training | 2022-10-27 00:00:00 | Remote training via Zoom video conferencing |  |  | Unit 327 - Business Transactions | 1.5 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed a TNA | 2022-10-27 00:00:00 | Remote training via Zoom video conferencing |  |  |  |  |  |  |  |  |  | 60 | 1 | 60
[NAME] | [NAME] | I have completed today's training | 2022-10-31 00:00:00 | Remote training via Zoom video conferencing |  |  | Unit 327 - Business Transactions | 1.5 |  |  |  |  |  | 31.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: 731060d1620144247-sumif-specific-value-in-ayear-sumif
Sheet: Prisciptions Gov

Date | Ccode | dddd | Generic | seller | Quantity |  |  |  |  | Year | total |  |  | [NAME]
1996-10-13 00:00:00 | 232345 | fruit | apple | [NAME] | 30 |  |  |  |  | 1996
1996-10-28 00:00:00 | 232345 | fruit | banana | [NAME] | 40 |  |  |  |  | 1997
1997-03-04 00:00:00 | 232345 | fruit | orange | [NAME] | 15 |  |  |  |  | 1998
1997-03-04 00:00:00 | 232345 | fruit | banana | 15 | 20 |  |  |  |  | 1999
1997-03-07 00:00:00 | 232345 | fruit | orange | [NAME] | 30 |  |  |  |  | 2000
1997-03-19 00:00:00 | 232345 | fruit | apple | LAI | 30 |  |  |  |  | 2001
1997-10-08 00:00:00 | 232345 | fruit | cherry | WANKLIN | 30 |  |  |  |  | 2002
2001-02-21 00:00:00 | 232345 | fruit | apple | BYCZKO | 200 |  |  |  |  | 2003
2001-05-18 00:00:00 | 232345 | fruit | orange | BYCZKO | 20 |  |  |  |  | 2004
Spreadsheet: 765222d1643213167-replace-number-with-text-based-on-cell-value-sample-wb
Sheet: Sheet1

 | Numeric Value | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | USING TEXT FUNCTION, I WANT TO REPLACE THE VALUES ACROSS ROW 1 WITH a Diamond symbol s
 | Here is the result I want | ss | ss | ss | ss | ss | ss | ss | ss | sss | ss | ss | ss | ss | ss | ss | ss | ss | ss
 | NOTE:  If using a "symbol" like the "diamond symbol" is not possible, this symbol could be replaced with a simple "dot" or perhaps an "asterisk"