tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 866180d1713158850-finding-partial-match-in-databse-with-filter-and-xloopup-testsheet-database-v3
Sheet: Sheet1 (2)

 | Explanation
 | In Range B7:B9 you can select a filter (list) you want to use as filter. In this case either Hobbies or Interests.
 | In range C7:C9 you can choose from a list which hobby or interest you are looking for.
 | Filter (list) | Criteria (list) |  | Name | Hobby_1 | Hobby_2 | Hobby_List | Interest_List |  | Hobby_List | Interest_List
 | Hobby_List | Bowling n/a |  | [NAME] | Tennis | Hockey |  | Reading |  | Tennis | Reading
 | Interest_List | Walking |  | [NAME] | Bowling | n/a |  | Walking |  | Bowling | Bowling
 |  |  |  | [NAME] | n/a | n/a |  | Traveling |  | Baseball | Traveling
 |  |  |  | Rachel | Baseball | Bowling |  | Walking |  | Hockey | Walking
 |  |  |  |  |  |  |  |  |  | Darts
 | STATUS: | In the table below the people that meet all the requirements in range B6:C9 you are filtering for to have an EXACT match will pop up. |  |  |  |  |  |  |  | n/a
 | ISSUE: | [NAME] shows up due to the exact match of 'Bowling n/a' in Hobby_List, but not if you only fill in 'Bowling' in C6. |  |  |  |  |  |  |  | Bowling n/a
 |  | [NAME] should also show up with the PARTIAL match of 'Bowling' without the 'n/a'.
 | Matches
 | Name | Hobby_1 | Hobby_2 | Hobby_List | Interest_List
 |  | Bowling | n/a | Bowling n/a | Walking | 0
Spreadsheet: 854842d1704603536-lookup-and-find-the-in-between-days-and-return-number-of-days-20240105-h2-1-
Sheet: Sheet2

ID Number | Date From | Date To | Num Of Days
26827 | 2020-06-10 00:00:00 | 2020-06-15 00:00:00 | 6
26827 | 2020-07-04 00:00:00 | 2020-07-12 00:00:00 | 9
26827 | 2020-08-18 00:00:00 | 2020-08-31 00:00:00 | 14
26827 | 2020-09-01 00:00:00 | 2020-09-23 00:00:00 | 23
26827 | 2020-10-01 00:00:00 | 2020-10-07 00:00:00 | 7
26827 | 2020-10-09 00:00:00 | 2020-10-09 00:00:00 | 1
26827 | 2021-02-01 00:00:00 | 2021-02-28 00:00:00 | 28
26827 | 2021-03-01 00:00:00 | 2021-03-31 00:00:00 | 31
26827 | 2021-04-01 00:00:00 | 2021-04-30 00:00:00 | 30
26827 | 2021-05-01 00:00:00 | 2021-05-31 00:00:00 | 31
26827 | 2021-06-01 00:00:00 | 2021-06-14 00:00:00 | 14
26827 | 2021-08-02 00:00:00 | 2021-08-08 00:00:00 | 7
26827 | 2022-05-14 00:00:00 | 2022-05-18 00:00:00 | 5
26827 | 2022-06-01 00:00:00 | 2022-06-09 00:00:00 | 9
26827 | 2022-08-07 00:00:00 | 2022-08-31 00:00:00 | 25
26827 | 2022-09-01 00:00:00 | 2022-09-04 00:00:00 | 4
26827 | 2022-10-26 00:00:00 | 2022-10-31 00:00:00 | 6
26827 | 2022-11-10 00:00:00 | 2022-11-12 00:00:00 | 3
26827 | 2023-02-01 00:00:00 | 2023-02-06 00:00:00 | 6
26827 | 2023-03-01 00:00:00 | 2023-03-18 00:00:00 | 18
26827 | 2023-05-16 00:00:00 | 2023-05-19 00:00:00 | 4
26827 | 2023-06-01 00:00:00 | 2023-06-05 00:00:00 | 5
26827 | 2023-06-12 00:00:00 | 2023-06-13 00:00:00 | 2
26827 | 2023-11-10 00:00:00 | 2023-11-23 00:00:00 | 14
30617 | 2021-10-06 00:00:00 | 2021-10-20 00:00:00 | 15
30617 | 2021-10-21 00:00:00 | 2021-10-31 00:00:00 | 11
30617 | 2021-11-01 00:00:00 | 2021-11-15 00:00:00 | 15
30617 | 2021-11-16 00:00:00 | 2021-11-30 00:00:00 | 15
30617 | 2021-12-01 00:00:00 | 2021-12-15 00:00:00 | 15
30617 | 2021-12-16 00:00:00 | 2021-12-31 00:00:00 | 16
30617 | 2022-01-17 00:00:00 | 2022-01-31 00:00:00 | 15
30617 | 2022-02-01 00:00:00 | 2022-02-13 00:00:00 | 13
30617 | 2022-02-14 00:00:00 | 2022-02-28 00:00:00 | 15
30617 | 2022-03-01 00:00:00 | 2022-03-10 00:00:00 | 10
30617 | 2022-04-04 00:00:00 | 2022-04-30 00:00:00 | 27
30617 | 2022-05-01 00:00:00 | 2022-05-04 00:00:00 | 4
30617 | 2022-05-05 00:00:00 | 2022-05-15 00:00:00 | 11
30617 | 2022-05-16 00:00:00 | 2022-05-22 00:00:00 | 7
30617 | 2022-12-29 00:00:00 | 2022-12-31 00:00:00 | 3
30617 | 2023-03-13 00:00:00 | 2023-03-15 00:00:00 | 3
30706 | 2021-10-04 00:00:00 | 2021-10-31 00:00:00 | 28
30706 | 2021-11-01 00:00:00 | 2021-11-30 00:00:00 | 30
30706 | 2021-12-01 00:00:00 | 2021-12-31 00:00:00 | 31
30706 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 31
30706 | 2022-02-01 00:00:00 | 2022-02-28 00:00:00 | 28
30706 | 2022-03-01 00:00:00 | 2022-03-31 00:00:00 | 31
30706 | 2022-04-01 00:00:00 | 2022-04-30 00:00:00 | 30
30706 | 2022-05-01 00:00:00 | 2022-05-31 00:00:00 | 31
30706 | 2022-06-01 00:00:00 | 2022-06-13 00:00:00 | 13
Spreadsheet: 120062d1314962577-forumula-for-excel-bell-curve-and-histogram-histogram-w-bell-curve
Sheet: Data

Entertainment Claim
Original Data
Cost | Frequency | [NAME] |  | Mean | 41.57142857142857
0-30 | 98 | 5 |  | [NAME] | 35.16559465754913
30-40 | 54 | 5
40-50 | 76 | 10
50-60 | 28 | 50
60-70 | 16 | 15
70-80 | 9 | 0
>80 | 10 | 0
Spreadsheet: 75655d1276193632-need-help-in-splitting-excel-spreadsheet-and-export-data-to-word-document-trial
Sheet: Sheet1

FirstName | LastName | Title | [NAME] | Identifier
[NAME] | Jobs | Owner | [EMAIL] | T
[NAME] | Smith | President | [EMAIL] | F
York | [NAME] | Prime Minister | [EMAIL] | F
Mo | Sizlac | President | [EMAIL] | T
[NAME] | Forest | Customer | [EMAIL] | F
Tarzan | Jungle | VP | [EMAIL] | T
Fred | Finders | Owner | [EMAIL] | F
Wilma | Flinstone | President | [EMAIL] | F
Barney | Dinosaur | Controller | [EMAIL] | T
Spreadsheet: 35783d1233436788-advanced-subtraction-problem-debt-payment-calculator
Sheet: Sheet1

 | 2009 | 32 | 30 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 | Days in Billing Cycle
 |  | Jan | Feb | March | April | May | June | July | Aug | Sept | Oct | Nov | Dec
 | Extra Payments |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | School Loan | 21785.57
 | School Loan | 21785.57 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Car Loan | 14188.43
 | Car Loan | 14188.43 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CC Total
 | CC Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2099 | 1794.79
 | 0.2099 | 1794.79 |  |  |  |  |  |  |  |  |  |  |  |  |  | Credit Card |  |  | 0.0799 | 9083.5
 | 0.0799 | 9083.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | Interest: | Balance * (APR /365) * Days in Cycle |  | 0.0199 | 4775.72
 | 0.0199 | 4775.72 |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly Min: | 1% + Interest
 | Total Debt
 | Total Interest |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Interest Rates
 | School |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Car | 0.0775
 | Car |  |  |  |  |  |  |  |  |  |  |  |  |  |  | School | 0.06875
 | CC Total Int. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Visa | Variable (20.99%, 7.99%, 1.99%)
 | CC 20.99%
 | CC 07.99%
 | CC 01.99%
 | CC Monthly Min
 | 2010 | 32 | 30 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 | Days in Billing Cycle
 |  | Jan | Feb | March | April | May | June | July | Aug | Sept | Oct | Nov | Dec
 | Extra Payments
 | School Loan
 | Car Loan
 | CC Total
 | 0.2099
 | 0.0799
 | 0.0199
 | Total Debt
 | Total Interest
 | School
 | Car
 | CC Total Int.
 | CC 20.99%
 | CC 07.99%
 | CC 01.99%
 | CC Monthly Min
 | 2011 | 32 | 30 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 | Days in Billing Cycle
 |  | Jan | Feb | March | April | May | June | July | Aug | Sept | Oct | Nov | Dec
 | Extra Payments
 | School Loan
 | Car Loan
 | CC Total
 | 0.2099
 | 0.0799
 | 0.0199
 | Total Debt
 | Total Interest
 | School
 | Car
 | CC Total Int.
 | CC 20.99%
 | CC 07.99%
 | CC 01.99%
 | CC Monthly Min
 | 2012 | 32 | 30 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 | Days in Billing Cycle
 |  | Jan | Feb | March | April | May | June | July | Aug | Sept | Oct | Nov | Dec
 | Extra Payments
 | School Loan
 | Car Loan
 | CC Total
 | 0.2099
 | 0.0799
 | 0.0199
 | Total Debt
 | Total Interest
 | School
 | Car
 | CC Total Int.
 | CC 20.99%
 | CC 07.99%
 | CC 01.99%
 | CC Monthly Min
 | 2013 | 32 | 30 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 | Days in Billing Cycle
 |  | Jan | Feb | March | April | May | June | July | Aug | Sept | Oct | Nov | Dec
 | Extra Payments
 | School Loan
 | Car Loan
 | CC Total
 | 0.2099
 | 0.0799
 | 0.0199
 | Total Debt
 | Total Interest
 | School
 | Car
 | CC Total Int.
 | CC 20.99%
 | CC 07.99%
 | CC 01.99%
 | CC Monthly Min
Spreadsheet: 215402d1361370499-min-max-with-multiple-criteria-upload
Sheet: Sheet1

A | Red | 2
A | Yellow | 3
B | Red | 1
A | yellow | 2
A | Red | 5
B | Red | 6
 |  |  |  |  |  | a
 |  |  |  |  |  | yellow
Spreadsheet: 478585d1472882330-comparing-information-finding-duplicates-on-two-spreadsheets-solution
Sheet: All

Sno | Emp_ID | Helper Column
 | 50 |  | #N/A --> Means not available in Active list which  means no longer working
 | 51
 | 52
 | 55
 | 60
 | 40
 | 55
 | 47
 | 14
 | 74
Spreadsheet: 697978d1601651739-extract-duplicate-data-from-one-column-only-if-respecive-row-in-another-column-is-blank-duplicate-sample
Sheet: Sample Duplicate Locator

If cells in Column C are blank, evaluate colum A in corresponding rows for duplicates.
My attempts are located in columns U and V
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Should only contain bb and cc
Data |  | Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | My tries
aa |  | 2020-10-02 00:00:00
bb
aa |  | 2020-10-02 00:00:00
aa
bb
bb |  | 2020-10-02 00:00:00
cc
cc
Spreadsheet: thomas_martin__39796__Org Leads for ENA
Sheet: West Desk Support

Enron North America - West Desk  Government Affairs Support
 |  | GA Contact
 | Functional Area | Lead | Others
Wholesale Power | Policy Coordination/Development/Preparation | Steffes | GA Team
 | [NAME] (including final Sign Off on filings) | Comnes
 | FERC Case Management | [NAME] | Novosel
 | Transmission Service Requests (non CA-ISO) | Scott | Nicolay, [NAME]
 | Interconnection Requests (non CA-ISO) | Scott | Nicolay, [NAME]
 | Interconnection Requests (CA-ISO) | Mara | Alvarez, Comnes
 | CA-ISO | Mara | Comnes, [NAME]
 | RTO West | [NAME] | Perrino, Comnes
 | DSTAR | Perrino | Walton, Comnes
 | WECC/WIO | [NAME] | Walton, [NAME], Ingersoll
 | BPA | [NAME] | Kaufman
 | Siting | Kaufman | [NAME], [NAME]
 | Qualifying Facilities | Comnes | Kaufman, [NAME]
 | EWG Issues | Scott | Nicolay
 | Industrial Sales Issues | Scott | Nicolay, [NAME]
Wholesale Gas | Policy Coordination/Development/Preparation | Steffes | GA Team
 | [NAME] (including final Sign Off on filings) | Cantrell
 | FERC Case Management | Fulton | [NAME]
 | Transportation Issues (FERC) | Lawner | Cantrell, Scott
 | Storage Issues (FERC) | Lawner | Cantrell, [NAME]
 | Transportation Issues (CPUC) | [NAME] | Lawner, Cantrell
 | Storage Issues (CPUC) | [NAME] | Lawner, Cantrell
 | LDC Relationships | [NAME] | Lawner, Kaufman
Western State -- PUC | California | [NAME] | Mara, Lawner
 | Non-California | Kaufman
Western State -- Legislative | California | [NAME] | Dasovich, Kaufman, Mara
 | Non-California | Kaufman | [NAME]
Other Federal Matters | Legislative | [NAME] | Shelk
 | DOE | [NAME] | [NAME]
 | EPA | [NAME] | Schoen
 | NERC | Yeung | Ingersoll, [NAME]
Litigation Coordination |  | Steffes | [NAME], Dasovich, Comnes
Spreadsheet: 144816d1331149473-excel-2007-drop-down-list-with-non-contiguous-cells-help-generic_ex
Sheet: Sheet1

OPTIONS
SP Option 1
 | JBL
Speakers | Community | drop down here B5:B7
 | Owi
 |  |  |  | SPEAKER FINAL | drop down here C6 & C 12
SP Option 2
 | JBL
Speakers | Community | drop down here B11:B13
 | Owi
AMP Option 1
 | Crown
Amps | QSC | drop down here B18:[NAME]
 | Peavey
AMP Option 2 |  |  |  | AMP FINAL | drop down here C19 & C25
 | Crown
Amps | QSC | drop down here B24:B26
 | Peavey
Spreadsheet: 83239d1283264014-conditional-formatting-conditional-formatting
Sheet: Statement Summary

Full Name | 2010-01-03 00:00:00 | 2010-02-03 00:00:00 | 2010-03-03 00:00:00 | 2010-04-03 00:00:00 | 2010-05-03 00:00:00 | 2010-06-03 00:00:00 | 2010-07-03 00:00:00 | 2010-08-03 00:00:00 | 2010-09-03 00:00:00 | 2010-10-03 00:00:00 | 2010-11-03 00:00:00 | 2010-12-03 00:00:00
Ray |  |  |  |  |  |  | 0 | 1313.52
[NAME] |  |  |  |  |  |  | 7318.03 | 3641.81
[NAME] |  |  |  |  |  |  | 276.1 | 1763.78
[NAME] |  |  |  |  |  |  | 200 | 3072.92
Sandra |  |  |  |  |  |  | 36886.24 | 33964.27
[NAME] |  |  |  |  |  |  | 677.54 | 0
[NAME] |  |  |  |  |  |  | 3332.43 | 2415.11
[NAME] |  |  |  |  |  |  | 265.82 | 1754.28
[NAME] |  |  |  |  |  |  | 3415.84 | 1746.64
Ian |  |  |  |  |  |  | 6362.13 | 6631.23
[NAME] |  |  |  |  |  |  | 121 | 0
[NAME] |  |  |  |  |  |  | 0 | 233.34
[NAME] |  |  |  |  |  |  | 7694.95 | 6157.93
[NAME] |  |  |  |  |  |  | 200 | 1641.36
[NAME] |  |  |  |  |  |  | 0 | 781.35
[NAME] |  |  |  |  |  |  | 2690.4 | 817.9
[NAME] |  |  |  |  |  |  | 1998.28 | 1234.89
[NAME] |  |  |  |  |  |  | 200 | 100
[NAME] |  |  |  |  |  |  | 3176.6 | 3014.77
[NAME] |  |  |  |  |  |  | 3541.1 | 100
[NAME] |  |  |  |  |  |  | 3371.4 | 4759.84
Stuart |  |  |  |  |  |  | 2536.21 | 2398.17
[NAME] |  |  |  |  |  |  | 255.09 | 0
[NAME] |  |  |  |  |  |  | 84.14 | 18.67
Total
Spreadsheet: 705465d1606142822-amend-index-aggregate-formula-calendar
Sheet: Calender

2020
 | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri
Carlotta Hermeling
[NAME]
[NAME]
Spreadsheet: e6f84322-3436-4219-a052-2e253c118db5
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  |  |  |  |  |  | WORKFORCE
 |  |  |  |  |  |  | BRANCH: FREMANTLE
 |  |  |  |  |  |  | PAYROLL queries: Ph 1300 853 100
 |  |  |  |  |  |  | PAYROLL queries email to: [EMAIL]
 |  |  |  |  |  |  | FAX to: 1300 301 994 before 10am Wednesday
Time Sheet
Week ending day & date |  |  |  |  | Client Name
Employee Name |  |  |  |  | Client Address
Employee Position
Client Cost Centre |  |  |  |  | Supervisor's Name
[NAME] |  |  |  |  | Supervisor's Title
Employee's Signature |  |  |  |  | [NAME]'s Signature
By signing this, you are verifying the hours worked, that you are satisfied with the work completed and that you accept the Chandler Macleod Terms of Business. If you have not been provided with the Chandler Macleod Terms of Business, please contact your Consultant.
Day | Date | Time Start use AM/PM or use 24hr clock | Time Finish use AM/PM or use 24hr clock | Less Lunch | Hours Worked |  |  |  |  |  |  | Allowances
 |  |  |  |  | Ordinary | Shift | T 1/2 | T 2 | T 2 1/2 | Public Holiday | Total Hours or Days | Meal | Travel | Other:
Wednesday
Thursday
Friday
Saturday
Sunday
Monday
Tuesday
 |  |  | Total Hours or Days
Chandler Macleod Payroll, 200 Greenhill Road, EASTWOOD SA 5063
August 2010
Spreadsheet: 732554d1621010480-text-join-substitute-formula-assistance-textjoin-sub
Sheet: Sheet1

 |  | (Always 3 digits) | Sometimes given as a string like this where Prog and [NAME] are already combined | (Always 4 digits) | (Always 2 digits, could start with 0, but would need to display as 2 digits (EXAMPLE: 2 = 02))
 | Acct-Prog-Loc | ACCT | [NAME] | Prog | [NAME]
 | 123-1011-35|123-1011-90|123-1025-90..123-1045-90|123-1047-90..123-1076-90|123-1082-90..123-1085-90|123-1300-90..123-1301-90|123-4100-90 | 123 | 1011-35|1011-90|1025-90..1045-90|1047-90..1076-90|1082-90..1085-90|1300-90..1301-90|4100-90
 | 123-4014-90..125-4014-90 | 123..125 |  | 4014 | 90
 | 123-4010-90|123-4012-90|123-4013-90|123-4015-90..123-4018-90|123-4950-90 | 123 |  | 4010|4012|4013|4015..4018|4950 | 90
 | 123-1079-90..123-1081-90|155-1079-90..155-1081-90 | 123|155 |  | 1079..1081 | 90
Spreadsheet: vkaminski__40932__Raptor 3b
Sheet: 50 NP

50MM Note Payable |  |  |  | Today |  |  |  | Principle
Face | 50000000 |  |  | Last Pymt Date |  |  |  | Accrued Interest
Interest |  |  |  | Interest Days
Tenor |  |  |  | Next Interest |  |  |  | Cum. Int. Exp.
Payment
Date | Beg. Bal | Payment | Interest | Principle | End Bal |  | [NAME]
2000-09-22 00:00:00 |  |  |  |  |  | 60
2001-03-22 00:00:00 |  |  |  |  |  | 59
2001-09-22 00:00:00 |  |  |  |  |  | 58
2002-03-22 00:00:00 |  |  |  |  |  | 57
2002-09-22 00:00:00 |  |  |  |  |  | 56
2003-03-22 00:00:00 |  |  |  |  |  | 55
2003-09-22 00:00:00 |  |  |  |  |  | 54
2004-03-22 00:00:00 |  |  |  |  |  | 53
2004-09-22 00:00:00 |  |  |  |  |  | 52
2005-03-22 00:00:00 |  |  |  |  |  | 51
2005-09-22 00:00:00 |  |  |  |  |  | 50
 |  |  |  |  |  | 49
 |  |  |  |  |  | 48
 |  |  |  |  |  | 47
 |  |  |  |  |  | 46
 |  |  |  |  |  | 45
 |  |  |  |  |  | 44
 |  |  |  |  |  | 43
 |  |  |  |  |  | 42
 |  |  |  |  |  | 41
 |  |  |  |  |  | 40
 |  |  |  |  |  | 39
 |  |  |  |  |  | 38
 |  |  |  |  |  | 37
 |  |  |  |  |  | 36
 |  |  |  |  |  | 35
 |  |  |  |  |  | 34
 |  |  |  |  |  | 33
 |  |  |  |  |  | 32
 |  |  |  |  |  | 31
 |  |  |  |  |  | 30
 |  |  |  |  |  | 29
 |  |  |  |  |  | 28
 |  |  |  |  |  | 27
 |  |  |  |  |  | 26
 |  |  |  |  |  | 25
 |  |  |  |  |  | 24
 |  |  |  |  |  | 23
 |  |  |  |  |  | 22
 |  |  |  |  |  | 21
 |  |  |  |  |  | 20
 |  |  |  |  |  | 19
 |  |  |  |  |  | 18
 |  |  |  |  |  | 17
 |  |  |  |  |  | 16
 |  |  |  |  |  | 15
 |  |  |  |  |  | 14
 |  |  |  |  |  | 13
 |  |  |  |  |  | 12
 |  |  |  |  |  | 11
 |  |  |  |  |  | 10
 |  |  |  |  |  | 9
 |  |  |  |  |  | 8
 |  |  |  |  |  | 7
 |  |  |  |  |  | 6
 |  |  |  |  |  | 5
 |  |  |  |  |  | 4
 |  |  |  |  |  | 3
 |  |  |  |  |  | 2
 |  |  |  |  |  | 1
 |  |  |  |  |  | 0
Spreadsheet: 878449d1725530802-night-shift-allowance-hours-worked-calculation-test
Sheet: Sheet1

DAY | PIN CODE | DATE | T&A IN | T&A OUT
Thu | 58 | 2024-08-01 | 13:55:00 | [NAME]
Fri | 58 | 2024-08-02 | 13:45:00 | 18:06:31
Sat | 58 | 2024-08-03
Sun | 58 | 2024-08-04
Mon | 58 | 2024-08-05 | 05:25:50 | 14:01:21
Tue | 58 | 2024-08-06 | 05:29:25 | 14:00:22
Wed | 58 | 2024-08-07 | [NAME] | 14:03:15
Thu | 58 | 2024-08-08 | 05:29:25 | 14:03:30
Fri | 58 | 2024-08-09 | 05:33:07 | 14:02:14
Sat | 58 | 2024-08-10 | [NAME] | 14:02:23
Sun | 58 | 2024-08-11 | 05:35:45 | [NAME]
Mon | 58 | 2024-08-12 | 13:45:00 | 19:44:19
Tue | 58 | 2024-08-13 | 13:45:00 | 20:04:01
Wed | 58 | 2024-08-14 | 13:45:00 | 19:33:30
Thu | 58 | 2024-08-15 | 13:45:00 | 19:23:26
Fri | 58 | 2024-08-16
Sat | 58 | 2024-08-17
Sun | 58 | 2024-08-18
Mon | 58 | 2024-08-19 | 05:30:19 | 14:00:47
Tue | 58 | 2024-08-20 | 05:26:08 | 14:01:49
Wed | 58 | 2024-08-21 | [NAME] | 14:05:09
Thu | 58 | 2024-08-22 | [NAME] | 14:05:00
Fri | 58 | 2024-08-23 | 05:21:30 | 14:05:30
Sat | 58 | 2024-08-24 | [NAME] | [NAME]
Sun | 58 | 2024-08-25 | 05:27:31 | 16:48:05
Mon | 58 | 2024-08-26 | 13:45:00 | [NAME]
Tue | 58 | 2024-08-27 | 14:13:05 | 04:55:08
Wed | 58 | 2024-08-28 | 13:56:03 | 22:00:04
Thu | 58 | 2024-08-29 | 13:45:00 | 23:57:03
Fri | 58 | 2024-08-30 | 13:51:58 | 20:35:50
Sat | 58 | 2024-08-31
Spreadsheet: 688837d1595976381-determining-total-count-within-intervals-of-30mins-excel-forum-test-30min-interval-counts
Sheet: Pivot

Count of Time | Column Labels
Row Labels | 1 AM | 2 AM | 3 AM | 4 AM | 5 AM | 6 AM | 7 AM | 8 AM | 9 AM | 10 AM | 11 AM | 12 PM | Grand Total
2020-07-20 00:00:00 | 29 | 19 | 3 | 3 |  | 12 | 15 | 38 | 31 | 22 | 28 | 21 | 221
2020-07-21 00:00:00 | 32 | 23 | 20 | 7 | 3 | 6 | 24 | 18 | 15 | 25 | 29 | 29 | 231
2020-07-22 00:00:00 | 10 | 13 | 24 | 4 | 1 | 16 | 5 | 18 | 22 | 36 | 24 | 18 | 191
2020-07-23 00:00:00 | 14 | 8 | 8 | 17 | 4 | 7 | 13 | 41 | 23 | 19 | 15 | 23 | 192
2020-07-24 00:00:00 | 29 | 18 | 12 | 6 | 2 | 15 | 16 | 27 | 24 | 7 | 17 | 19 | 192
Grand Total | 114 | 81 | 67 | 37 | 10 | 56 | 73 | 142 | 115 | 109 | 113 | 110 | 1027
Spreadsheet: 836167d1689150544-need-a-formula-that-adds-previous-balance-for-certain-employee-sample38
Sheet: Sheet1

 |  |  |  |  |  | Employee Name | Job Date | Pay | Balance
 |  |  |  |  |  | [NAME] | 2023-07-03 00:00:00 | 278.33 | 278.33
 |  |  |  |  |  | [NAME] | 2023-07-05 00:00:00 | 356.45 | 356.45
 |  |  |  |  |  | [NAME] | 2023-07-06 00:00:00 | 125.86 | 125.86
 |  |  |  |  |  | [NAME] | 2023-07-06 00:00:00 | 350.2 | 350.2
 |  |  |  |  |  | [NAME] | 2023-07-08 00:00:00 | 105.45 | 105.45
 |  |  |  |  |  | [NAME] | 2023-07-09 00:00:00 | 287.52 | 287.52
 |  |  |  |  |  | [NAME] | 2023-07-10 00:00:00 | 780.15 | 1058.48
 |  |  |  |  |  | [NAME] | 2023-07-11 00:00:00 | 269.5 | 374.95
 |  |  |  |  |  | [NAME] | 2023-07-11 00:00:00 | 482.05 | 760.38
 |  |  |  |  |  | [NAME] | 2023-07-12 00:00:00 | 90.63 | 216.49
 |  |  |  |  |  | [NAME] | 2023-07-13 00:00:00 | 109.78
 |  |  |  |  |  | [NAME] | 2023-07-15 00:00:00 | 190.45
 |  |  |  |  |  | [NAME] | 2023-07-16 00:00:00 | 230.45
 |  |  |  |  |  | [NAME] | 2023-07-17 00:00:00 | 48.2
 |  |  |  |  |  | [NAME] | 2023-07-18 00:00:00 | 85.15
 |  |  |  |  |  | [NAME] | 2023-07-19 00:00:00 | 49
 |  |  |  |  |  | [NAME] | 2023-07-19 00:00:00 | 107.55
Spreadsheet: 767327d1644413555-vba-compare-copy-and-delete-compare
Sheet: Total

Company A | Street | PO | City | Country | Phone | Mail | www | Text
Company B | Street | PO | City | Country | Phone | Mail | www | Text
Company C | Street | PO | City | Country | Phone | Mail | www | Text
Company D | Street | PO | City | Country | Phone | Mail | www | Text
Company E | Street | PO | City | Country | Phone | Mail | www | Text
Company F | Street | PO | City | Country | Phone | Mail | www | Text
Company G | Street | PO | City | Country | Phone | Mail | www | Text
Company H | Street | PO | City | Country | Phone | Mail | www | Text
Company I | Street | PO | City | Country | Phone | Mail | www | Text
Company J | Street | PO | City | Country | Phone | Mail | www | Text
Company P | Street | PO | City | Country | Phone | Mail | www | Text
Company Q | Street | PO | City | Country | Phone | Mail | www | Text
Company R | Street | PO | City | Country | Phone | Mail | www | Text
Company S | Street | PO | City | Country | Phone | Mail | www | Text
Company T | Street | PO | City | Country | Phone | Mail | www | Text
Spreadsheet: 444807d1454637601-help-with-limiting-names-from-crowded-table-to-organized-table-b1
Sheet: Sheet1

 | [NAME] | Macy | Carrie | Meg | Gwen | Gladys | Jeremy | [NAME] | [NAME] | [NAME] |  |  |  | Waiter 1 | Waiter 2 | Waiter 3
2016-01-01 00:00:00 |  | Macy |  | Meg |  |  | Jeremy |  |  |  |  |  | 2016-01-01 00:00:00
2016-01-02 00:00:00 |  |  | Carrie |  |  |  |  |  | [NAME] | [NAME] |  |  | 2016-01-02 00:00:00
2016-01-03 00:00:00 | [NAME] |  |  |  | Gwen |  |  |  |  | [NAME] |  |  | 2016-01-03 00:00:00
2016-01-04 00:00:00 |  | Macy |  | Meg |  |  |  | [NAME] |  |  |  |  | 2016-01-04 00:00:00
2016-01-05 00:00:00 | [NAME] |  |  |  | Gwen |  |  |  |  | [NAME] |  |  | 2016-01-05 00:00:00
2016-01-06 00:00:00 |  |  | Carrie |  |  | Gladys |  |  |  | [NAME] |  |  | 2016-01-06 00:00:00
2016-01-07 00:00:00 |  | Macy |  |  | Gwen |  |  | [NAME] |  |  |  |  | 2016-01-07 00:00:00
2016-01-08 00:00:00 | [NAME] | Macy |  |  |  |  |  | [NAME] |  |  |  |  | 2016-01-08 00:00:00
2016-01-09 00:00:00 |  |  |  | Meg |  | Gladys |  |  | [NAME] |  |  |  | 2016-01-09 00:00:00
2016-01-10 00:00:00 | [NAME] |  | Carrie | Meg |  |  |  |  |  |  |  |  | 2016-01-10 00:00:00
2016-01-11 00:00:00 |  | Macy |  |  |  |  | Jeremy |  |  | [NAME] |  |  | 2016-01-11 00:00:00
2016-01-12 00:00:00 |  |  |  | Meg | Gwen |  | Jeremy |  |  |  |  |  | 2016-01-12 00:00:00
2016-01-13 00:00:00 |  | Macy |  |  |  |  |  |  | [NAME] | [NAME] |  |  | 2016-01-13 00:00:00
2016-01-14 00:00:00 | [NAME] |  |  | Meg |  | Gladys |  |  |  |  |  |  | 2016-01-14 00:00:00
 |  |  |  | Table 1 |  |  |  |  |  |  |  |  |  |  | Table 2