tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 871280d1717670018-create-table-for-each-status-type-then-sort-by-date-help-tables-aligw
Sheet: Sheet2

RAW | Status | Details | Type | Due Date |  | OUTPUT | Three tables  - done, doing and planned
 | Done | Red | Bug | 2024-10-01 00:00:00 |  |  | Details below each, sorted by old to new due date
 | Doing | Blue | New Feature | 2024-10-01 00:00:00 |  | Done |  |  |  | Doing |  |  |  | Planned
 | planned | Black | Bug
 | Done | Orange | New Feature |  |  | Details | Type | Due Date |  | Details | Type | Due Date |  | Details | Type | Due Date
 | Done | Red | Bug |  |  | Red | Bug | 2024-10-01 00:00:00 |  | Doing | Blue | New Feature |  | planned | Black | Bug
 | Doing | Yellow | New Feature |  |  | Orange | New Feature |  |  | Doing | Yellow | New Feature |  | planned | Purple | Bug
 | planned | Purple | Bug |  |  | Red | Bug |  |  | Doing | Red | Bug |  | planned | Orange | New Feature
 | planned | Orange | New Feature |  |  | Blue | New Feature | 2024-06-03 00:00:00 |  | Doing | Red | Bug |  | planned | Magnto | New Feature
 | Doing | Red | Bug |  |  | Gold | Bug |  |  | Doing | Red | Bug |  | planned | Lilac | New Feature | 2024-06-17 00:00:00
 | Done | Blue | New Feature | 2024-06-03 00:00:00 |  | Silver | New Feature |  |  | Doing | Orange | New Feature |  | planned | Black | Bug
 | Done | Gold | Bug |  |  | Pink | Bug
 | Done | Silver | New Feature |  |  | Orange | New Feature
 | Doing | Red | Bug |  |  | Red | Bug
 | planned | Magnto | New Feature |  |  | Blue | New Feature
 | Done | Pink | Bug
 | Done | Orange | New Feature |  |  |  | Bug | 2024-10-01 00:00:00 |  |  | New Feature | 2024-10-01 00:00:00 |  |  | Bug
 | Doing | Red | Bug |  |  | Orange | New Feature |  |  | Yellow | New Feature |  |  | Purple | Bug
 | planned | Lilac | New Feature | 2024-06-17 00:00:00 |  | Red | Bug |  |  | Red | Bug |  |  | Orange | New Feature
 | planned | Black | Bug |  |  | Blue | New Feature | 2024-06-03 00:00:00 |  | Red | Bug |  |  | Magnto | New Feature
 | Doing | Orange | New Feature |  |  | Gold | Bug |  |  | Red | Bug |  |  | Lilac | New Feature | 2024-06-17 00:00:00
 | Done | Red | Bug |  |  | Silver | New Feature |  |  | Orange | New Feature |  |  | Black | Bug
 | Done | Blue | New Feature |  |  | Pink | Bug
 |  |  |  |  |  | Orange | New Feature
 |  |  |  |  |  | Red | Bug
 |  |  |  |  |  | Blue | New Feature
Spreadsheet: 800546d1665735536-formulate-unorganised-data-into-organised-one-portal-data1-1-
Sheet: Formulate here

 |  |  | Team Names |  | Team Score |  | Team Odds
Date | Time | Playoff - Y/N | Team 1 | Team 2 | Team 1 | Team 2 | Team 1 | Team 2
 |  |  |  | [NAME] |  | 92
 |  |  |  | Adelaide Strikers |  | 167
 |  |  |  | [NAME] |  | 166
 |  |  |  | [NAME] |  | 167
 |  |  |  | Melbourne Renegades |  | 169
 |  |  |  | [NAME] |  | 178
 |  |  |  | Melbourne Renegades |  | 176
 |  |  |  | [NAME] |  | 156
 |  |  |  | [NAME] |  | 161
 |  |  |  | [NAME] |  | 149
 |  |  |  | [NAME] |  | 137
 |  |  |  | [NAME] |  | 132
 |  |  |  | [NAME] |  | 127
 |  |  |  | [NAME] |  | 123
 |  |  |  | [NAME] |  | 177
 |  |  |  | Adelaide Strikers |  | 161
 |  |  |  | [NAME] |  | 150
 |  |  |  | [NAME] |  | 149
 |  |  |  | Adelaide Strikers |  | 139
 |  |  |  | [NAME] |  | 140
 |  |  |  | [NAME] |  | 152
 |  |  |  | [NAME] |  | 145
 |  |  |  | [NAME] |  | 209
 |  |  |  | [NAME] |  | 137
 |  |  |  | [NAME] |  | 128
 |  |  |  | [NAME] |  | 126
 |  |  |  | [NAME] |  | 133
 |  |  |  | [NAME] |  | 129
 |  |  |  | Adelaide Strikers |  | 144
 |  |  |  | [NAME] |  | 180
 |  |  |  | Melbourne Renegades
 |  |  |  | [NAME] |  | 150
 |  |  |  | [NAME] |  | 187
 |  |  |  | [NAME] |  | 206
 |  |  |  | [NAME] |  | 105
 |  |  |  | [NAME] |  | 166
 |  |  |  | [NAME] |  | 207
 |  |  |  | Adelaide Strikers |  | 175
 |  |  |  | Melbourne Renegades |  | 151
 |  |  |  | [NAME] |  | 168
 |  |  |  | [NAME] |  | 156
 |  |  |  | [NAME] |  | 208
Spreadsheet: 224437d1364572008-completely-lost-dependent-drop-down-or-nested-if-or-maybe-something-totally-different-studiolist
Sheet: Sheet1

Employee | Renter | Studio | CC | Payment |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | A | B |  | Index | Dimensions | Type | Index
Adriane | Commercial | 1 | MasterCard | Guarantee CC |  |  | Commercial | 35 | 45 | 45 | 55 | 40 | 35 | 30 | 50 | 35 |  | 1 | Commerical | 1 | 1
Arden | Non-Profit/Alumni | 2 | Visa | AMEX |  |  | Non-Profit/Alumni | 25 | 30 | 30 | 45 | 25 | 25 | 25 | 35 | 25 |  | 2 | Non-Profit/Alumni | 2 | 2
[NAME] | Student/Staff | 3 | AMEX | MasterCard |  |  | Student/Staff | 20 | 20 | 25 | 35 | 20 | 20 | 20 | 30 | 20 |  | 3 | Student/Staff | 3 | 3
[NAME] |  | 4 |  | Visa |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 4
Erich |  | 5 |  | Cash |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5
Esme |  | 6 |  | Check |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 6
Jolenta |  | 7 |  | Comp |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 7
Jon |  | A |  | Cancelled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | 8
[NAME] |  | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | 9
Rebecca
Spreadsheet: 847473d1698391190-anonymising-data-dummydata
Sheet: Sheet1

Dummy "Before" Data | Citizen | House | Street Name | Suburb |  | Desired "After" | Citizen | House | Name | Suburb
 | [NAME] | 1 | [NAME] | [NAME] |  |  | [NAME] | House 1 | Street 1 | Suburb 1
 | [NAME] | 1 | [NAME] | [NAME] |  |  | [NAME] | House 1 | Street 1 | Suburb 1
 | [NAME] | 1 | [NAME] | [NAME] |  |  | [NAME] | House 1 | Street 1 | Suburb 1
 | [NAME] | 2 | [NAME] | [NAME] |  |  | [NAME] | House 2 | Street 1 | Suburb 1
 | [NAME] | 4 | [NAME] | [NAME] |  |  | [NAME] | House 3 | Street 1 | Suburb 1
 | [NAME] | 7 | [NAME] | [NAME] |  |  | [NAME] | House 4 | Street 1 | Suburb 1
 | [NAME] | 10 | [NAME] | [NAME] |  |  | [NAME] | House 5 | Street 1 | Suburb 1
 | [NAME] | 10 | [NAME] | [NAME] |  |  | [NAME] | House 5 | Street 1 | Suburb 1
 | [NAME] | 1 | [NAME] | [NAME] |  |  | [NAME] | House 1 | Street 2 | Suburb 1
 | [NAME] | 2 | [NAME] | [NAME] |  |  | [NAME] | House 2 | Street 2 | Suburb 1
 | [NAME] | 2 | [NAME] | [NAME] |  |  | [NAME] | House 2 | Street 2 | Suburb 1
 | [NAME] | 4 | [NAME] | [NAME] |  |  | [NAME] | House 3 | Street 2 | Suburb 1
 | [NAME] | 6 | [NAME] | [NAME] |  |  | [NAME] | House 4 | Street 2 | Suburb 1
 | Mark | 6 | [NAME] | [NAME] |  |  | Mark | House 4 | Street 2 | Suburb 1
 | [NAME] | 12 | [NAME] | [NAME] |  |  | [NAME] | House 5 | Street 2 | Suburb 1
 | [NAME] | 1 | [NAME] | [NAME] |  |  | [NAME] | House 1 | Street 3 | Suburb 1
 | [NAME] | 5 | [NAME] | [NAME] |  |  | [NAME] | House 2 | Street 3 | Suburb 1
 | [NAME] | 11 | [NAME] | [NAME] |  |  | [NAME] | House 3 | Street 3 | Suburb 1
 | [NAME] | 11 | [NAME] | [NAME] |  |  | [NAME] | House 3 | Street 3 | Suburb 1
 | [NAME] | 16 | [NAME] | [NAME] |  |  | [NAME] | House 4 | Street 3 | Suburb 1
 | [NAME] | 23 | [NAME] | [NAME] |  |  | [NAME] | House 5 | Street 3 | Suburb 1
 | [NAME] | 6 | [NAME] | Jacksonville |  |  | [NAME] | House 1 | Street 1 | Suburb 2
 | George | 6 | [NAME] | Jacksonville |  |  | George | House 1 | Street 1 | Suburb 2
 | Timothy | 7 | [NAME] | Jacksonville |  |  | Timothy | House 2 | Street 1 | Suburb 2
 | [NAME] | 9 | [NAME] | Jacksonville |  |  | [NAME] | House 3 | Street 1 | Suburb 2
 | [NAME] | 10 | [NAME] | Jacksonville |  |  | [NAME] | House 4 | Street 1 | Suburb 2
 | [NAME] | 12 | [NAME] | Jacksonville |  |  | [NAME] | House 5 | Street 1 | Suburb 2
 | [NAME] | 4 | Beach Rd | Jacksonville |  |  | [NAME] | House 1 | Street 2 | Suburb 2
 | [NAME] | 7 | Beach Rd | Jacksonville |  |  | [NAME] | House 2 | Street 2 | Suburb 2
 | [NAME] | 19 | Beach Rd | Jacksonville |  |  | [NAME] | House 3 | Street 2 | Suburb 2
 | [NAME] | 22 | Beach Rd | Jacksonville |  |  | [NAME] | House 4 | Street 2 | Suburb 2
 | [NAME] | 22 | Beach Rd | Jacksonville |  |  | [NAME] | House 4 | Street 2 | Suburb 2
 | [NAME] | 26 | Beach Rd | Jacksonville |  |  | [NAME] | House 5 | Street 2 | Suburb 2
Spreadsheet: 202053d1356299147-incrementally-save-new-data-transport-log
Sheet: Sheet1

DATE | REQUEST TIME | PATIENT NAME | TRANSPORTER | LEAVE DEPT | ARRIVE PT LOC | LEAVE PT LOC | ARRIVE DEPT | WC | STRCHR | O2 | ASSIST | CONTACT |  | COMMENTS
2012-12-23 00:00:00 | 15:30:03 | Jones, Mary | [NAME] | 15:30:17 | 15:30:19 | 15:30:21 | 15:34:26 |  |  | X |  | X |  | Wear mask, gloves and gown
2012-12-23 00:00:00 | 15:45:44 | Smith, [NAME] | KK | 15:45:55 | 15:45:56 | 15:45:57 | 15:45:59 |  | X |  | X |  |  | Fall precautions
Spreadsheet: 807903d1670159237-counting-the-number-of-people-on-leave-per-month-book1-5-
Sheet: LEAVE PER MONTH

 |  |  |  |  | ASSISTANT MANAGER
 | LEAVE START | LEAVE END | DESIGNATION |  | MONTH | NUMBER OF LEAVE PER MONTH |  | MANAGER
 | 2022-05-17 00:00:00 | 2022-06-15 00:00:00 | MANAGER |  | JANUARY |  |  | ASSISTANT MANAGER
 | 2022-10-18 00:00:00 | 2022-10-23 00:00:00 | ASSISTANT MANAGER |  | FEBRUARY |  |  | SUPERVISOR
 | 2022-07-27 00:00:00 | 2022-08-20 00:00:00 | SUPERVISOR |  | [NAME] |  |  | SENIOR SALES EXECUTIVE
 | 2022-05-16 00:00:00 | 2022-06-19 00:00:00 | SENIOR SALES EXECUTIVE |  | APRIL |  |  | SALES EXECUTIVE
 | 2022-11-01 00:00:00 | 2022-12-05 00:00:00 | SALES EXECUTIVE |  | MAY |  |  | VISUAL MERCHANDISER
 | 2022-02-16 00:00:00 | 2022-03-17 00:00:00 | SALES EXECUTIVE |  | [NAME] |  |  | ASSISTANT
 | 2022-07-21 00:00:00 | 2022-08-23 00:00:00 | SUPERVISOR |  | JULY
 | NA | NA | SENIOR SALES EXECUTIVE |  | AUGUST
 | 2022-03-10 00:00:00 | 2022-04-13 00:00:00 | SALES EXECUTIVE |  | SEPTEMBER
 | 2022-09-01 00:00:00 | 2022-09-14 00:00:00 | SALES EXECUTIVE |  | OCTOBER
 | NA | NA | SALES EXECUTIVE |  | NOVEMBER
 | NA | NA | SALES EXECUTIVE |  | DECEMBER
 | NA | NA | SALES EXECUTIVE
 | NA | NA | SALES EXECUTIVE
 | NA | NA | SALES EXECUTIVE
 | 2022-10-01 00:00:00 | 2022-11-29 00:00:00 | ASSISTANT
 | NA | NA | ASSISTANT
 | 2022-05-24 00:00:00 | 2022-07-07 00:00:00 | ASSISTANT
 | NA | NA | ASSISTANT
 | NA | NA | ASSISTANT
 | NA | NA | VISUAL MERCHANDISER
 | NA | NA | VISUAL MERCHANDISER
 | NA | NA | VISUAL MERCHANDISER
Spreadsheet: 793826d1661763877-simple-spreadsheet-auto-sort-by-dates-when-i-add-new-data-sample-data
Sheet: MATT

 |  |  |  |  |  | HOW I WANT IT TO BE BUT TO CHANGE AUTOMATICALLY WHEN UPDATED
 | Username | Password | Connections | [NAME] |  |  | [NAME]
 | Test 1 | 123456 | 1st | 2023-01-01 00:00:00 |  |  | 2022-09-01 00:00:00
 | Test 2 | 123456 | 2nd | 2022-10-02 00:00:00 |  |  | 2022-09-05 00:00:00
 | Test 3 | 123456 | 1st | 2023-10-03 00:00:00 |  |  | 2022-09-11 00:00:00
 | Test 4 | 123456 | 2nd | 2022-09-01 00:00:00 |  |  | 2022-10-02 00:00:00
 | Test 5 | 123456 | 2nd | 2023-02-15 00:00:00 |  |  | 2022-12-10 00:00:00
 | Test 6 | 123456 | 1st | 2022-09-05 00:00:00 |  |  | 2023-01-01 00:00:00
 | Test 7 | 123456 | 1st | 2023-01-04 00:00:00 |  |  | 2023-01-04 00:00:00
 | Test 8 | 123456 | 2nd | 2023-02-02 00:00:00 |  |  | 2023-02-02 00:00:00
 | Test 9 | 123456 | 3rd | 2022-12-10 00:00:00 |  |  | 2023-02-15 00:00:00
 | Test 10 | 123456 | 2nd | 2023-04-04 00:00:00 |  |  | 2023-04-04 00:00:00
 | Test 11 | 123456 | 3rd | 2022-09-11 00:00:00 |  |  | 2023-10-03 00:00:00
Spreadsheet: 116529d1311881717-counting-weekends-off-master
Sheet: Monthly

 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 28 | 29 | 30 | 31 | 1 | 2 | 3 |  | Sundays Off | Saturdays Off
[NAME] | OFF | 9:00 - 10:00 | 9:00 - 10:00 | 9:00 - 10:00 | 8:30 - 4:30 | 8:30 - 5:30 | OFF
[NAME] | OFF
Darrell
[NAME]
Stacy
[NAME]
Heather M.
[NAME]
Will
Kenny
[NAME]
[NAME]
Mark
Justin
[NAME]
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 4 | 5 | 6 | 7 | 8 | 9 | 10
[NAME] | OFF
[NAME]
Darrell
[NAME]
Stacy
[NAME]
Heather M.
[NAME]
Will
Kenny
[NAME]
[NAME]
Mark
Justin
[NAME]
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 11 | 12 | 13 | 14 | 15 | 16 | 17
[NAME] | OFF
[NAME]
Darrell
[NAME]
Stacy
[NAME]
Heather M.
[NAME]
Will
Kenny
[NAME]
[NAME]
Mark
Justin
[NAME]
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 18 | 19 | 20 | 21 | 22 | 23 | 24
[NAME] | OFF
[NAME]
Darrell
[NAME]
Stacy
[NAME]
Heather M.
[NAME]
Will
Kenny
[NAME]
[NAME]
Mark
Justin
[NAME]
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 25 | 26 | 27 | 28 | 29 | 30 | 1
[NAME] | OFF
[NAME]
Darrell
[NAME]
Stacy
[NAME]
Heather M.
[NAME]
Will
Kenny
[NAME]
[NAME]
Mark
Justin
[NAME]
Spreadsheet: 587535d1535074417-sorting-my-data-by-year-sample-5
Sheet: Sheet1

2010 | 0 | 0 |  | 2010 | 0 | 0 | 2011 | 6 | 1.5 | 2012 | 12 | 3.32 | 2013 | 16 | 4.78
2010 |  | 0.2 |  | 2010 | 1 | 0.2 | 2011 | 7 | 2 | 2012 | 13 | 4 | 2013 | 17 | 5.65
2010 |  | 0.5 |  | 2010 | 2 | 0.5 | 2011 | 8 | 3.33 | 2012 | 14 | 5.2 | 2013 | 18 | 5.7
2010 |  | 1 |  | 2010 | 3 | 1 | 2011 | 9 | 2.11 | 2012 | 15 | 4.77 | 2013 | 19 | 7.2
2010 |  | 1.2 |  | 2010 | 4 | 1.2 | 2011 | 10 | 1.8 |  |  |  | 2013 | 20 | 6.55
2010 |  | 0.8 |  | 2010 | 5 | 0.8 | 2011 | 11 | 2.5
2011 |  | 1.5
2011 |  | 2
2011 |  | 3.33
2011 |  | 2.11
2011 |  | 1.8
2011 |  | 2.5
2012 |  | 3.32
2012 |  | 4
2012 |  | 5.2
2012 |  | 4.77
2013 |  | 4.78
2013 |  | 5.65
2013 |  | 5.7
2013 |  | 7.2
2013 |  | 6.55
Spreadsheet: 69135d1269625863-look-up-and-write-the-top-3-values-with-header-averages-of-cities
Sheet: Cities

 | Vancouver | Calgary | Edmonton | Saskatoon | Winnipeg | Toronto | Ottawa | Montreal | Quebec City
 | 37 | 16 | 36 | 38 | 17 | 19 | 8 | 34 | 10
 | 19 | 21 | 14 | 25 | 37 | 32 | 5 | 35 | 15
 | 31 | 7 | 23 | 26 | 14 | 19 | 40 | 20 | 27
 | 36 | 11 | 23 | 26 | 19 | 8 | 21 | 40 | 7
 | 29 | 18 | 10 | 11 | 11 | 32 | 14 | 31 | 25
 | 23 | 38 | 27 | 33 | 30 | 18 | 29 | 34 | 32
 | 22 | 23 | 22 | 28 | 34 | 12 | 12 | 39 | 13
 | 16 | 24 | 27 | 20 | 33 | 10 | 8 | 34 | 20
 | 9 | 5 | 34 | 31 | 17 | 15 | 31 | 35 | 17
 | 17 | 23 | 29 | 27 | 5 | 37 | 37 | 9 | 38
 | 5 | 25 | 33 | 33 | 22 | 7 | 35 | 31 | 15
 | 34 | 35 | 5 | 11 | 12 | 27 | 39 | 28 | 25
 | 20 | 13 | 6 | 9 | 25 | 24 | 28 | 27 | 34
 | 16 | 13 | 24 | 17 | 30 | 39 | 18 | 27 | 40
 | 36 | 37 | 11 | 8 | 13 | 8 | 13 | 6 | 23
 | 27 | 24 | 19 | 25 | 6 | 7 | 10 | 27 | 31
Average of the Top 4
Spreadsheet: 733089d1621383592-self-referencing-loop-sampleworkbook
Sheet: Sheet1

2020 |  |  |  |  |  |  |  |  | 40 |  | SAMPLE DATA
2020-01-05 00:00:00 | ESI SELF | 12 |  | ESI SELF | 2.15 |  |  |  |  |  | 2020-01-05 00:00:00 | ESI SELF | 12 |  | ESI SELF | 2.15
 |  |  |  | PTO SELF ILL | 9.85 |  |  |  |  |  |  |  |  |  | PTO SELF ILL | 9.85
2020-02-03 00:00:00 | ESI FAMILY | 12 |  | ESI FAMILY | 4.3 |  |  |  |  |  | 2020-02-03 00:00:00 | ESI FAMILY | 12 |  | ESI FAMILY | 4.3
 |  |  |  | PTO FAM ILL | 7.7 |  |  |  |  |  |  |  |  |  | PTO FAM ILL | 7.7
2020-03-01 00:00:00 | ESI FAMILY | 8 |  | ESI FAMILY | 4.3 |  |  |  |  |  | 2020-03-01 00:00:00 | ESI FAMILY | 8 |  | ESI FAMILY | 4.3
 |  |  |  | PTO FAM ILL | 3.7 |  |  |  |  |  |  |  |  |  | PTO FAM ILL | 3.7
2020-03-28 00:00:00 | ESI FAMILY | 12 |  | ESI FAMILY | 4.3 |  |  |  |  |  | 2020-03-28 00:00:00 | ESI FAMILY | 12 |  | ESI FAMILY | 4.3
 |  |  |  | PTO FAM ILL | 7.7 |  |  |  |  |  |  |  |  |  | PTO FAM ILL | 7.7
2020-06-19 00:00:00 | ESI FAMILY | 12 |  | ESI FAMILY | 12 |  |  |  |  |  | 2020-06-19 00:00:00 | ESI FAMILY | 12 |  | ESI FAMILY | 12
2020-08-16 00:00:00 | ESI SELF | 12 |  | ESI SELF | 9.5 |  |  |  |  |  | 2020-08-16 00:00:00 | ESI SELF | 12 |  | ESI SELF | 9.5
 |  |  |  | PTO SELF ILL | 2.5 |  |  |  |  |  |  |  |  |  | PTO SELF ILL | 2.5
2020-09-02 00:00:00 | ESI FAMILY | 12 |  | ESI FAMILY | 2.15 |  |  |  |  |  | 2020-09-02 00:00:00 | ESI FAMILY | 12 |  | ESI FAMILY | 2.15
 |  |  |  | PTO FAM ILL | 9.85 |  |  |  |  |  |  |  |  |  | PTO FAM ILL | 9.85
2020-10-05 00:00:00 | ESI FAMILY | 12 |  | ESI FAMILY | 6.45 |  |  |  |  |  | 2020-10-05 00:00:00 | ESI FAMILY | 12 |  | ESI FAMILY | 6.45
 |  |  |  | PTO FAM ILL | 5.55 |  |  |  |  |  |  |  |  |  | PTO FAM ILL | 5.55
2020-11-16 00:00:00 | ESI FAMILY | 6.5 |  | ESI FAMILY | 6.45 |  |  |  |  |  | 2020-11-16 00:00:00 | ESI FAMILY | 6.5 |  | ESI FAMILY | 6.45
 |  |  |  | PTO FAM ILL | 0.05 |  |  |  |  |  |  |  |  |  | PTO FAM ILL | 0.05
2020-12-14 00:00:00 | ESI FAMILY | 0.05 |  | ESI FAMILY | 0.05 |  |  |  |  |  | 2020-12-14 00:00:00 | ESI FAMILY | 0.05 |  | ESI FAMILY | 0.05
 |  |  |  |  |  |  | Available CA Sick Time Protection
Spreadsheet: 158468d1338274227-how-to-combine-if-and-offset-match-countif-together-excel-data-validation-techniques
Sheet: Data Validation - Change Lists

 | Advanced Data Validation - Changing Lists Based on Previous Selection
 | Created by Pointy Haired Dilbert - http://chandoo.org/wp | feel free to share, copy and extend
 | Select Area |  | Select Project |  |  |  |  | Many thanks to [NAME] for asking this question
 |  |  |  |  |  |  |  | Learn How this works?
 |  |  |  |  |  |  |  | » [NAME] the cell D6
 | Area | Project |  |  |  |  |  | » Go to menu > data > validation
 | Marketing | Horizon2010 |  |  |  |  |  | » See how the validation formula is used (shown below)
 | Marketing | Bingo19x
 | Marketing | Cosmos
 | Marketing | Spring2009
 | Ops | Kayak
 | Ops | KarmicOn
 | Ops | Chain2Customer
 | Sales | CallTag
 | Sales | HuntDown
 | Sales | DarkNight
 | IT | Burrow
 | IT | sITcom
 | IT | excelLENT
Spreadsheet: 874130d1720699857-creating-a-table-of-information-from-a-data-set-based-on-certain-criteria-excel-help
Sheet: Weekly 

 | Outstanding Paperwork
 | Week Commencing |  |  | 2523
 | Week No | Registration | Inspection required | Update / Notes?
 | 2024-01-01 00:00:00 | 123 | PMI - Paperwork Outstanding
 | 2024-01-01 00:00:00 | 456 | MOT - Paperwork Outstanding
 | 2024-01-01 00:00:00 | 987 | Tacho Calibration - Paperwork Outstanding
 | 2024-01-15 00:00:00 | 123 | MOT - Paperwork Outstanding
 | 2024-01-29 00:00:00 | DEF | [NAME]
 | 2024-02-05 00:00:00 | HIJ | Tacho Calibration - Paperwork Outstanding
Spreadsheet: 466064d1465998775-formula-to-stop-count-hours-once-it-reaches-maximum-paid-time-off-work-sheet
Sheet: Sheet1

Hire Date | Years of Service | Annual Accrual Days | Annual Accrual Hours | Accrual Per Hour | Maximum Accrual | Accrual Per Bi-Weekly PP | Hours Accrual | Hours Used | Available Hours |  |  |  |  |  |  |  |  |  | Years of Service | annual Accrual Days | annual Accrual Hours | Accrual Per Hour | Maximum Accrual | accrual Per  Bi-Weekly PP
2008-02-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 10 | 80 |  | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 12 | 96 |  | 96 |  |  | PTO-A
 |  |  |  | CODE |  | COUNT |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 15 | 120 |  | 120 |  |  | PTO-E
 |  |  |  | PTO-A | =Accrual |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 20 | 160 |  | 160 |  |  | PTO-U
 |  |  |  | PTO-E | =Early Out |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 25 | 200 |  | 200
 |  |  |  | PTO-U | =Used
Date | Hours | Accrual | Early Out | Used | Code | Balance | Notes
 | Beginning Balance |  |  |  |  | 113.24
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 |  |  | 2 |  | PTO-E
 |  |  | 2 |  | PTO-E
 |  |  | 1 |  | PTO-E
 |  |  |  | 40 | PTO-U
 |  |  |  | 40 | PTO-U
 |  |  |  | 8 | PTO-U
 |  |  |  | 8 | PTO-U
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 |  |  |  | 40 | PTO-U
 |  |  |  | 40 | PTO-U
Spreadsheet: louise_kitchen__24091__NEWCO HEADCOUNT NAMES
Sheet: Gas Logistics

Gas Logistics | ok
[NAME] | Logistics (Central Desk) | Analyst |  | 9
[NAME] | Logistics (Texas Desk) | Analyst | 2 | 21
[NAME] | Logistics (Central Desk) | Associate |  | 7
[NAME] | Logistics (Central Desk) | Associate |  | 6
[NAME] | Logistics (West Desk) | Associate |  | 22
[NAME] | Logistics (East Desk) | Associate | 4 | 18
[NAME] | Logistics (East Desk) | Director | 1 | 10
[NAME] | Logistics (Central Desk) | Manager |  | 5
[NAME] | Logistics (Texas Desk) | Manager |  | 20
[NAME] | Logistics (West Desk) | Manager |  | 28
[NAME] | Support | Manager |  | 29
[NAME] | Logistics (Central Desk) | Manager |  | 1
[NAME] | Logistics (East Desk) | Manager |  | 15
[NAME] | Logistics (West Desk) | Manager |  | 23
[NAME] | Support | Manager |  | 31
[NAME] | Logistics (East Desk) | Manager | 9 | 11
[NAME] | Logistics (East Desk) | Spec |  | 19
Shannon  Groenewold | Logistics (West Desk) | Spec |  | 24
[NAME] | Logistics (West Desk) | Spec | 3 | 25
[NAME] | Logistics (Central Desk) | Sr. Spec |  | 8
[NAME] | Logistics (East Desk) | Sr. Spec |  | 16
[NAME] | Logistics (East Desk) | Sr. Spec |  | 12
[NAME] | Logistics (Central Desk) | Sr. Spec |  | 2
[NAME] | Logistics (West Desk) | Sr. Spec |  | 27
[NAME] | Logistics (Central Desk) | Sr. Spec |  | 4
[NAME] | Logistics (Central Desk) | Sr. Spec |  | 3
Meredith Homco | Logistics (East Desk) | Sr. Spec |  | 14
[NAME] | Support | Sr. Spec |  | 30
[NAME] | Support | Sr. Spec |  | 32
[NAME] | Logistics (East Desk) | Sr. Spec |  | 13
[NAME] | Logistics (East Desk) | Sr. Spec |  | 17
[NAME] | Logistics (West Desk) | Sr. Spec | 13 | 26
 |  | TOTAL
Spreadsheet: 820716d1678265598-find-and-replace-in-new-line-excel-sample
Sheet: Sheet1

ToCapture | Notes | Count
 | Janice;#10009;#MarieJane;#10010 | 10
 | John;#19999 | 2
Expected Result:
ToCapture | Notes | Count
Janice | Janice;#10009;#MarieJane;#10010 | 10
MarieJane |  | 5
 | John;#19999 | 2
Spreadsheet: 833319d1686902745-formula-to-create-a-automating-a-template-from-a-data-set-in-a-second-sheet-sample-book-2
Sheet: Upload

 |  |  |  | Date | Nominal Code | Amount
 |  |  |  | 2023-05-17 00:00:00 | 7500 | 7.98
 |  |  |  | 2023-05-17 00:00:00 | 2300 | 1.6
 |  |  |  | 2023-05-17 00:00:00 | 7502 | 40
 |  |  |  | 2023-05-17 00:00:00 | 2300 | 8
 |  |  |  | 2023-05-18 00:00:00 | 6900 | 8.33
 |  |  |  | 2023-05-18 00:00:00 | 2300 | 1.67
 |  |  |  | 2023-05-18 00:00:00 | 7500 | 69.4
 |  |  |  | 2023-05-18 00:00:00 | 7300 | -100
 |  |  |  | 2023-05-18 00:00:00 | 2300 | -20
 |  |  |  | 2023-05-18 00:00:00 | 7200 | 100
 |  |  |  | 2023-05-18 00:00:00 | 7403 | 49.67
 |  |  |  | 2023-05-18 00:00:00 | 2300 | 9.93
` |  |  |  | 2023-05-18 00:00:00 | 7200 | 100
 |  |  |  | 2023-05-18 00:00:00 | 7405 | 49.67
 |  |  |  | 2023-05-18 00:00:00 | 2300 | 9.93
 |  |  |  | 2023-05-18 00:00:00 | 7200 | 100
 |  |  |  | 2023-05-18 00:00:00 | 7405 | 41.67
 |  |  |  | 2023-05-18 00:00:00 | 2300 | 8.33