tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 58614d1258850724-dates-in-a-pivot-table-attendance
Sheet: Attendance

name | date from | date to | number |  |  |  |  |  | date to | date from | number
[NAME] | 2009-07-21 00:00:00 | 2009-07-28 00:00:00 | 7 |  |  |  |  |  | Apr | Apr | 10
anne | 2009-05-22 00:00:00 | 2009-05-30 00:00:00 | 8 |  |  |  |  |  | Apr Total |  | 10
[NAME] | 2009-06-12 00:00:00 | 2009-08-12 00:00:00 | 61
[NAME] | 2009-04-12 00:00:00 | 2009-05-02 00:00:00 | 20 |  |  |  |  |  | May | Apr | 20
mary | 2009-04-11 00:00:00 | 2009-04-21 00:00:00 | 10 |  |  |  |  |  |  | May | 8
[NAME] | 2009-07-26 00:00:00 | 2009-08-13 00:00:00 | 18 |  |  |  |  |  | May Total |  | 28
 |  |  |  |  |  |  |  |  | Jul | Jul | 7
 |  |  |  |  |  |  |  |  | Jul Total |  | 7
 |  |  |  |  |  |  |  |  | Aug | Jun | 61
 |  |  |  |  |  |  |  |  |  | Jul | 18
 |  |  |  |  |  |  |  |  | Aug Total |  | 79
 |  |  |  |  |  |  |  |  | Grand Total |  | 124
Spreadsheet: 882989d1731476338-need-formula-that-automatically-adjusts-to-rows-and-columns-fransha-spreadsheet-spill-365-aligw
Sheet: Scoring Formulas

 | 2024-10-08 00:00:00 |  |  |  |  |  |  |  |  |  | 2024-10-08 00:00:00 | Line |  | Line |  | Line |  | Line |  | Line |  | Line |  | Line |  | Line |  | Line |  | Line | 2024-10-08 00:00:00 |  |  |  |  |  |  |  |  |  | sum weighted scores | Weeks Played | Weeks Played/Total Weeks | Final Score
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | copy formula across/change cell reference
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 2 |  | 2 |  | 2 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 2 |  | 2 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 3 |  | 3 |  | 3 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 4 |  | 5 |  | 4 |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 3 |  | 3 |  | 3 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 5 |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 4 |  | 5 |  | 4 |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ACTUAL SCORE |  |  |  |  |  |  |  |  | L1 | L2 | L3 | [NAME] | L5 |  |  | WEIGHTED SCORE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.5 | 1.3 | 1.1 | 0.9 | 0.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.7
Spreadsheet: 694998d1599942836-auto-updating-months-and-remaining-amount-sample
Sheet: Data

BEFORE
ID# | NAME | PAYMENT CLEAR TILL | NEXT PAYMENT | CURRENT MONTH | TOTAL MONTHS | MONTHLY PAYMENT | REMAINS | TOTAL | LAST AMOUNT PAID | ON DATE
3001 | CUSTOMER 1 | 2020-01-01 00:00:00 |  |  |  | 1500 | 0 |  | 0 | 2000-01-01 00:00:00
3002 | CUSTOMER 2 | 2020-01-01 00:00:00 |  |  |  | 2000 | 0 |  | 0 | 2000-01-01 00:00:00
3003 | CUSTOMER 3 | 2020-01-01 00:00:00 |  |  |  | 4000 | 0 |  | 0 | 2000-01-01 00:00:00
3004 | CUSTOMER 4 | 2020-01-01 00:00:00 |  |  |  | 500 | 0 |  | 0 | 2000-01-01 00:00:00
AFTER UPDATE
ID# | NAME | PAYMENT CLEAR TILL | NEXT PAYMENT | CURRENT MONTH | TOTAL MONTHS | MONTHLY PAYMENT | REMAINS | TOTAL | LAST AMOUNT PAID | ON DATE
3001 | CUSTOMER 1 | 2020-05-01 00:00:00 |  |  |  | 1500 | 1000
3002 | CUSTOMER 2 | 2020-03-01 00:00:00 |  |  |  | 2000 | 1000
3003 | CUSTOMER 3 | 2020-03-01 00:00:00 |  |  |  | 4000 | 2000
3004 | CUSTOMER 4 | 2020-06-01 00:00:00 |  |  |  | 500 | 0
 |  | Months should be auto updated from Income table, customer 1 was having 8 months dues before, and he paid 5000. Means he paid 4 months payment (1500x4=6000) and 1000 is remaining. |  |  |  |  | For Example the customer 1 paid 5000 instead of 6000 for 4 months payments, it means he has 1000 remaining payment. So it should be automatically calculated.
Spreadsheet: 204700d1357612691-using-multiple-sheets-run-time-calculations
Sheet: Monday

profile knife grinding time / knife (min) | 30 |  |  |  | 7 | 8 | 9 | 10 | 11 | 1 | 2 | 02:30:00
Straight knife grinding time / knife (min) | 25 |  |  |  |  |  |  |  |  |  |  |  | Maximum throughput molder
 |  |  |  |  |  |  |  |  |  |  |  |  | Maximum throughput rip saw
 |  | linear ft/min |  |  | MONDAY
Molder (linear ft/hr) | 2100 |  |  |  | Pattern | 2 | 3 | 4 | 5 | 6 | 7 | 8 | Daily total ft
[NAME] saw (linear ft/hr) | 4200 |  |  |  | [NAME] saw length (ft) | 500 | 500 | 500 | 500 | 10000 | 10000 | 10000
Surfacer (linear ft/hr) | 9000 |  |  |  | Molder knife | straight | profile | straight | profile | profile | profile | profile
Sander (linear ft/hr) | 9000 |  |  |  | Pattern | 1 | 2 | 3 | 4 | 5 | 6 | 7
Set-up time molder (min) | 15 |  |  |  | Molder length (ft) | 500 | 1000 | 500 | 500 | 500 | 500 | 500
Break (min) | 15 |  |  |  | Pattern | 2 | 3 | 4 | 5 | 6 | 7 | 1
Swap heads (linear ft) | 6000 |  |  |  | [NAME] saw run time (min)
Cutter change time (min) | 15 |  |  |  | Pattern | 1 | 2 | 3 | 4 | 5 | 6 | 7
Cutter flip time (min) | 10 |  |  |  | Molder run time (min)
 |  |  |  |  | Grind time
 |  |  |  |  | Secondary process time
A & B | Pattern 1 |  |  | Pattern 2 |  | Pattern 3 |  | Pattern 4 |  | Pattern 5
Process | Molder start |  | Molder stop | Molder start | Molder stop | Molder start | Molder stop | Molder start | Molder stop | Molder start | Molder stop
C | Pattern
 | 2
Process | [NAME] saw start |  | [NAME] saw stop
 | 07:00:00
 | 2 |  |  | 2,3 | 3,4 | 3,4,5 | 4,5,6 | 4,5,6,7 | 5,6,7,8 | 6,7,8 | 6,7,8 | 6,7,8 | 7,8 | 7,8 | 8 | 8
Spreadsheet: 706423d1606692102-linking-if-statement-between-sheets-if-statement-problem
Sheet: Sheet1

a | a
a | fg
a | fg
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
0 | 0
[NAME] | [NAME]
[NAME] | [NAME]
0 | 0
Spreadsheet: 825575d1681400873-calculate-of-work-days-btwn-date-and-today-do-not-calculate-if-blank-or-if-not-required-calculate-no-of-day-excepts-etaf
Sheet: Lists

 | HOLIDAYS
 | 2022-01-03 00:00:00
 | 2022-02-21 00:00:00
 | 2022-04-15 00:00:00
 | 2022-04-18 00:00:00
 | 2022-05-23 00:00:00
 | 2022-07-01 00:00:00
 | 2022-08-01 00:00:00
 | 2022-09-05 00:00:00
 | 2022-10-10 00:00:00
 | 2022-11-11 00:00:00
 | 2022-12-26 00:00:00
 | 2022-12-27 00:00:00
 | 2022-12-28 00:00:00
 | 2022-12-29 00:00:00
 | 2022-12-30 00:00:00
 | 2023-01-01 00:00:00
 | 2023-02-20 00:00:00
 | 2023-04-07 00:00:00
 | 2023-04-10 00:00:00
 | 2023-05-22 00:00:00
 | 2023-07-01 00:00:00
 | 2023-09-04 00:00:00
 | 2023-10-09 00:00:00
 | 2023-11-11 00:00:00
 | 2023-12-25 00:00:00
 | 2024-01-01 00:00:00
 | 2024-02-19 00:00:00
 | 2024-03-29 00:00:00
 | 2024-05-20 00:00:00
 | 2023-07-24 00:00:00
 | 2023-09-24 00:00:00
 | 2024-10-14 00:00:00
 | 2024-11-11 00:00:00
 | 2024-12-25 00:00:00
Spreadsheet: 821324d1678625086-change-colour-based-on-date-excel
Sheet: Ark1

[NAME] | [NAME] | [NAME] | Municipality | Product | Order no | Price | [NAME] | [NAME] | Info 5 | Info 6 | Note | Invoice no. | Received | Assesment | Step 3 | Step 4 | Measurement | Order date | Step 7 | Step 8 | Step 9 | Testing | Step 10 | Step 11 | Billed
Customer 1 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-03-01 00:00:00
Customer 2 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-04 00:00:00
Customer 3 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-06 00:00:00
Customer 4 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-10 00:00:00
Customer 5 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-07 00:00:00
Customer 6 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-03-06 00:00:00
Customer 7 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-04 00:00:00 |  |  |  |  |  |  | 2023-03-01 00:00:00
Customer 8 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-21 00:00:00
Customer 9 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00
Customer 10 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-14 00:00:00
Customer 11 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-22 00:00:00 |  |  |  | 2023-02-06 00:00:00
Customer 12 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-23 00:00:00
Customer 13 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-26 00:00:00
Customer 14 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-03-02 00:00:00
Customer 15 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-29 00:00:00 |  |  |  |  |  |  |  |  | 2023-02-26 00:00:00
Spreadsheet: 43189d1241771898-help-to-make-moving-cell-formatting-research
Sheet: Sheet4

Availability
Resourece | jan | feb | mrz | apr | mai | jun
X | 5 | 5 | 5 | 5 | 5 | 4
Y | 5 | 7 | 5 | 5 | 5 | 6
Z | 5 | 5 | 5 | 5 | 5 | 3
Spreadsheet: 747716d1631658841-look-for-a-value-in-a-different-column-question-latd00-example
Sheet: Sheet1

 |  | Store 1 |  | Store 2 |  | Store 3
Sales | 1000 | 1 | 2500 | 2.5 | 2600 | 2.25
cost | 500 | 0.5 | 800 | 0.8 | 700 | 0.75
labor | 20 | 0.02 | 30 | 0.03 | 35 | 0.04
 | Sales | cost | labor
Store 2
Spreadsheet: 714861d1611409228-changing-cell-number-automatically-book1
Sheet: Sheet1

DATE | [NAME] | QTY | COST PER UNIT | TOTAL
2021-01-01 00:00:00 | [NAME] | 2 | 17000
2021-01-01 00:00:00 | WATER SMALL | 8 | 1000
2021-01-01 00:00:00 | ACUP | 5 | 10000
Spreadsheet: 762132d1641403835-excel-formula-to-find-first-and-last-occurrence-based-on-date-and-time-sample-firstlast
Sheet: Sheet2

Provider Code | Member Code | Claim Source | Creation Date | Treatment Month | Gross/Charged Amount | Apperance Status
6212000032 | 761102 | E SERVICES | 2021-12-14 14:12:37 | 10 | 81
6212000032 | 761102 | WASEEL | 2021-12-20 15:01:30 | 10 | 81
6212000032 | 1511256 | E SERVICES | 2021-12-14 14:12:31 | 10 | 24.7 | -
6212000032 | 1511256 | E SERVICES | 2021-12-14 14:12:19 | 10 | 30 | -
6212000032 | 1511256 | E SERVICES | 2021-12-14 14:12:29 | 10 | 30 | -
6212000032 | 1511256 | WASEEL | 2021-12-20 15:03:50 | 10 | 33.15 | -
6212000032 | 1511256 | WASEEL | 2021-12-20 15:02:57 | 10 | 62.45 | -
6212000032 | 1511256 | E SERVICES | 2021-12-14 14:12:32 | 10 | 100 | -
6212000032 | 1511256 | WASEEL | 2021-12-20 15:00:28 | 10 | 154.7 | -
6212000032 | 1511256 | WASEEL | 2021-12-20 15:01:24 | 10 | 198.15 | -
6212000032 | 1511256 | E SERVICES | 2021-12-14 14:12:21 | 10 | 206.1 | -
6212000032 | 1511256 | WASEEL | 2021-12-20 15:03:34 | 10 | 236.1 | -
6212000032 | 1533705 | E SERVICES | 2021-12-14 14:13:15 | 10 | 151.05 | First E SERVICES
6212000032 | 1533705 | WASEEL | 2021-12-20 15:04:13 | 10 | 151.05 | Second WASEEL
6212000032 | 1581525 | E SERVICES | 2021-12-14 14:12:24 | 10 | 68.15
6212000032 | 1581525 | E SERVICES | 2021-12-14 14:12:22 | 10 | 130
6212000032 | 1865302 | E SERVICES | 2021-12-14 14:10:57 | 10 | 84.15 | First E SERVICES
6212000032 | 1865302 | WASEEL | 2021-12-20 15:01:00 | 10 | 84.15 | Second WASEEL
6212000032 | 2284575 | E SERVICES | 2021-12-14 14:10:36 | 10 | 60
6212000032 | 2284575 | E SERVICES | 2021-12-14 14:10:34 | 10 | 112.4
6212000032 | 2284575 | E SERVICES | 2021-12-14 14:10:32 | 10 | 150
6212000032 | 1912266 | E SERVICES | 2021-12-20 15:02:46 | 10 | 105.2 | Second E SERVICES
6212000032 | 1912266 | WASEEL | 2021-12-14 14:10:57 | 10 | 105.2 | First WASEEL
Spreadsheet: 857851d1706720079-sum-hours-based-on-date-range-and-id-and-then-summarize-on-a-separate-tab-eot-sample-v2
Sheet: CALDERA

Name | ID |  |  |  |  | CHARGE MONTH: |  |  |  | PAYROLL WORKSHEET
CALDERA |  |  |  |  |  | 2023-11-01 00:00:00 |  |  |  | Schedule: | Weekly |  | Mo. [NAME]: |  |  | Hrly [NAME].: |  |  |  |  |  | Position: | [NAME]
 |  |  |  |  |  |  |  |  |  | Shift: | Day |  | Stipend/UA: |  |  | Wk Equiv.: |  |  |  |  |  | Union: | [NAME]
LEAVE USAGE
TYPE | V | S | SF | CTO | HCTO | IH | PH |  |  |  |  |  | Hours Worked
DATE |  |  |  |  |  |  |  |  |  | Period # | Start | End | Regular | Holiday | Overtime | CTO | Total | Swing | S Due | Grave | G Due | Total Comp | OT Rate
2023-11-06 00:00:00 |  |  |  | 0.5 |  |  |  |  |  | 1 | 2023-10-29 00:00:00 | 2023-11-04 00:00:00 |  | 0 | 0 | 0
2023-11-13 00:00:00 |  |  | 10 |  |  |  |  |  |  | 2 | 2023-11-05 00:00:00 | 2023-11-11 00:00:00 |  | 10 | 2 | 0
11/26-27/2023 |  | 20 |  |  |  |  |  |  |  | 3 | 2023-11-12 00:00:00 | 2023-11-18 00:00:00 |  | 0 | 2 | 3
 |  |  |  |  |  |  |  |  |  | 4 | 2023-11-19 00:00:00 | 2023-11-25 00:00:00 |  | 0 | 2 | 0
 |  |  |  |  |  |  |  |  |  | 5 | 2023-11-26 00:00:00 | 2023-12-02 00:00:00 |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | Total
TOTAL |  |  |  |  |  |  |  |  |  |  |  | Total All OT Worked:
 |  |  |  |  |  |  |  |  |  |  |  | OT Reported by Dept:
OVERTIME AUTHORIZED |  |  |  |  |  |  |  |  |  |  |  | Less Holiday RDO:
REASON | DATE | FROM | TO | HOURS | EARN ID | PAY CODE | SWING | GRAVE
SHIFT COVERAGE - VACANT | 2023-11-05 00:00:00 | 1600 | 1800 | 2 | OTPR | 213-425P | 1 |  |  |  |  |  | Difference:
VETERANS DAY - REG SHIFT | 2023-11-10 00:00:00 |  |  | 10 | HG6 | 213-425HP
SHIFT COVERAGE - VACANT | 2023-11-12 00:00:00 | 1600 | 1800 | 2 | OTPR | 213-425P | 1
DISPATCH TRAINER MEETING | 2023-11-16 00:00:00 | 1300 | 1400 | 3 | CTO | 213-425P
THANKSGIVING - RDO | 2023-11-23 00:00:00 |  |  | 10 | RDO HOL PD | 213-425OT5
SHIFT COVERAGE - VACANT | 2023-11-24 00:00:00 | 1600 | 1800 | 2 | OTPR | 213-425P | 1
Total
 |  |  |  | Regular Shift Differential Hours:
 |  |  |  | Total Shift Differential Hours to Pay:
Spreadsheet: 771396d1646654116-how-to-find-max-value-based-on-name-test-1-
Sheet: Sheet1

 |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1
 |  |  |  |  |  | 2021-11-15 00:00:00
Name | Project | Start Date | End Date | Duration | Probability % | 15-Nov | 16-Nov | 17-Nov | 18-Nov | 19-Nov | 20-Nov | 21-Nov | 22-Nov | 23-Nov | 24-Nov | 25-Nov | 26-Nov | 27-Nov | 28-Nov | 29-Nov | 30-Nov | 01-Dec | 02-Dec | 03-Dec | 04-Dec | 05-Dec | 06-Dec
[NAME] | 1Overview
[NAME] | gsdfs | 2021-11-01 00:00:00 |  | 39 | 100 | 150
[NAME] | sdfsdf | 2021-11-01 00:00:00 |  | 39 | 100 | 200
[NAME] | BJDK | 2021-11-01 00:00:00 |  | 39 | 100 | 300
[NAME] | sdfsdf | 2021-11-01 00:00:00 |  | 39 | 100
[NAME] | 1Overview
[NAME] | Food | 2022-03-01 00:00:00 |  | 35 | 80
Becker | 1Overview
Becker | Haribo | 2021-09-06 00:00:00 |  | 40 | 100
[NAME] | 1Overview
[NAME] | iPhone | 2021-11-01 00:00:00 |  | 10 | 100
Danish | 1Overview
Danish | DH2 | 2021-07-01 00:00:00 |  | 30 | 100
Danish | CALIBURN | 2021-04-05 00:00:00 |  | 34 | 100
[NAME] | 1Overview
[NAME] | [NAME] | 2021-12-01 00:00:00 |  | 34 | 100
Gamp | 1Overview
Gamp | Dairy Milk | 2021-04-05 00:00:00 |  | 35 | 100
Gamp | Dairy Milk | 2022-01-01 00:00:00 |  | 13 | 100
Gamp | Dairy Milk | 2021-04-05 00:00:00 |  | 51 | 100 | 100
Spreadsheet: 730092d1619542673-sum-row-with-different-criterias-sum-with-monthly
Sheet: Sheet1

 |  |  |  | WEST LONDON ALLIANCE
District | Week Ending | 2020-10-30 00:00:00 | 2020-11-06 00:00:00 | 2020-11-13 00:00:00 | 2020-11-20 00:00:00 | 2020-11-27 00:00:00 | 2020-12-04 00:00:00 | 2020-12-11 00:00:00 | 2020-12-18 00:00:00 | 2020-12-25 00:00:00 | 2021-01-01 00:00:00 | 2021-01-08 00:00:00 | 2021-01-15 00:00:00 | 2021-01-22 00:00:00 | 2021-01-29 00:00:00 | 2021-02-05 00:00:00 | 2021-02-12 00:00:00 | 2021-02-19 00:00:00
West | XCCFV B | 17 | 107 | 103 | 51 | 26 | 18 | 31 | 26 | 26 | 107 | 103 | 51 | 26 | 18 | 31 | 107 | 103
North | Barnet | 7 | 17 | 12 | 22 | 15 | 8 | 2 | 11 | 20 | 17 | 12 | 22 | 15 | 8 | 2 | 17 | 12
West | Ealing | 26 | 87 | 64 | 66 | 41 | 37 | 45 | 36 | 27 | 87 | 64 | 66 | 41 | 37 | 45 | 87 | 64
West | Fulham | 41 | 66 | 24 | 14 | 15 | 22 | 10 | 14 | 18 | 66 | 24 | 14 | 15 | 22 | 10 | 66 | 24
West | Harlesden | 8 | 50 | 37 | 37 | 64 | 51 | 4 | 15 | 26 | 50 | 37 | 37 | 64 | 51 | 4 | 50 | 37
West | [NAME] | 47 | 74 | 71 | 60 | 56 | 48 | 13 | 9 | 5 | 74 | 71 | 60 | 56 | 48 | 13 | 74 | 71
West | [NAME] | 35 | 48 | 91 | 71 | 51 | 43 | 9 | 10 | 11 | 48 | 91 | 71 | 51 | 43 | 9 | 48 | 91
North | Hendon | 18 | 20 | 36 | 42 | 43 | 28 | 23 | 13 | 3 | 20 | 36 | 42 | 43 | 28 | 23 | 20 | 36
West | Hounslow | 48 | 71 | 60 | 40 | 51 | 48 | 57 | 34 | 11 | 71 | 60 | 40 | 51 | 48 | 57 | 71 | 60
West | [NAME] | 3 | 48 | 105 | 57 | 40 | 41 | 5 | 13 | 21 | 48 | 105 | 57 | 40 | 41 | 5 | 48 | 105
West | Uxbridge | 45 | 37 | 65 | 62 | 35 | 24 | 14 | 7 | 0 | 37 | 65 | 62 | 35 | 24 | 14 | 37 | 65
West | Wembley | 44 | 90 | 86 | 112 | 90 | 91 | 56 | 70 | 84 | 90 | 86 | 112 | 90 | 91 | 56 | 90 | 86
 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00
Barnet
Spreadsheet: 474152d1470664192-count-unique-values-per-month-sample
Sheet: DATA

Order # | Date | Type |  |  |  |  |  | April | May | June
157438 | 2016-04-06 00:00:00 | ACC |  |  |  |  | Count Unique HNAs
157438 | 2016-04-06 00:00:00 | ACC |  |  |  |  | Count Unique ACCs
161851 | 2016-05-25 00:00:00 | ACC |  |  |  |  | Count Unique OoCs
161851 | 2016-05-25 00:00:00 | ACC
162419 | 2016-06-02 00:00:00 | ACC
161544 | 2016-05-31 00:00:00 | ACC
160050 | 2016-05-09 00:00:00 | HNA 9629
160050 | 2016-05-09 00:00:00 | HNA 9629
160050 | 2016-05-09 00:00:00 | HNA 9629
160050 | 2016-05-09 00:00:00 | HNA 9629
160050 | 2016-05-09 00:00:00 | HNA 9629
162629 | 2016-06-08 00:00:00 | OoC
163271 | 2016-06-13 00:00:00 | ACC
163886 | 2016-06-22 00:00:00 | HNA MNIT
163886 | 2016-06-22 00:00:00 | HNA MNIT
Spreadsheet: 50469d1249925740-excel-2007-dependant-lists-and-lookups-fnalgpicker
Sheet: FB

Name | Club | Price
G Clichy | ARS | 4.6
K Gibbs | ARS | 4.3
G Hoyte | ARS | 4.2
B [NAME] | ARS | 4.5
W Bouma | AV | 3.7
N Shorey | AV | 3.7
L Young | AV | 3.8
S Carr | BIR | 3.3
D Murphy | BIR | 3.4
S Parnaby | BIR | 3.3
F Queudrue | BIR | 3.3
B Emerton | BLA | 3.6
G Givet | BLA | 3.6
L Jacobsen | BLA | 3.5
M Olsson | BLA | 3.4
S Warnock | BLA | 3.7
N Hunt | BOL | 3.6
S Ricketts | BOL | 3.2
P Robinson | BOL | 3.6
J [NAME] | BOL | 3.6
G Steinsson | BOL | 3.8
M Duff | BUR | 3.2
B Easton | BUR | 3.2
R Eckersley | BUR | 3.2
S Jordan | BUR | 3.2
C Kalvenes | BUR | 3.2
T Mears | BUR | 3.3
J [NAME] | CHE | 4.9
J Bosingwa | CHE | 5.4
A Cole | CHE | 5.3
P Ferreira | CHE | 4.8
L Baines | EVE | 4.4
T [NAME] | EVE | 4
S Kelly | FUL | 3.7
P Konchesky | FUL | 3.8
J Pantsil | FUL | 3.7
A Dawson | HUL | 3.4
K Kilbane | HUL | 3.3
F Aurelio | LIV | 5
P Degen | LIV | 4.7
A Dossena | LIV | 4.7
E Insua | LIV | 4.8
G [NAME] | LIV | 5.2
W Bridge | MC | 4
J Garrido | MC | 3.8
M Richards | MC | 4.1
P Zabaleta | MC | 3.9
W Brown | MU | 5
P Evra | MU | 5.2
G Neville | MU | 4.8
J [NAME] | MU | 4.9
Rafael | MU | 4.9
N Belhadj | POR | 3.6
S Finnan | POR | 3.6
H Hreidarsson | POR | 3.6
A Griffin | STO | 3.3
[NAME] | STO | 3.4
A Wilkinson | STO | 3.3
P Bardsley | SUN | 3.4
D Collins | SUN | 3.4
G [NAME] | SUN | 3.5
N Nosworthy | SUN | 3.3
B Assou-Ekotto | TOT | 3.9
G Bale | TOT | 3.8
P Chimbonda | TOT | 3.7
[NAME] | TOT | 3.9
A Hutton | TOT | 3.8
K Naughton | TOT | 3.7
H Ilunga | WH | 3.8
J Spector | WH | 3.6
M Figueroa | WIG | 3.8
M Melchiot | WIG | 3.7
K Foley | WOL | 3.3
M Hill | WOL | 3.2
R Stearman | WOL | 3.4
S Ward | WOL | 3.2
Spreadsheet: 49664d1248995501-conditional-formating-to-make-a-negative-test
Sheet: Sheet1

AMOUNT | DEBIT/CREDIT
200 | debit
31.91 | debit
2000 | credit
15.43 | debit
59.74 | debit
26.95 | debit
43.98 | debit
188.99 | debit
98.47 | debit
20 | debit
43.48 | debit
23.9 | debit
345.76 | debit
2.54 | debit
0.23 | credit
2456.43 | credit
5.48 | debit
222.85 | debit
90.89 | credit
130.36 | debit
54 | debit
5.95 | debit
Spreadsheet: 883239d1731794355-most-found-criteria-sample-score-shhet
Sheet: Sheet3 Estevaoba

 | Winner | [NAME] |  | Winner | Most Likely to Lose
 | [NAME] | [NAME] |  | [NAME]
 | [NAME] | [NAME] |  | [NAME]
 | [NAME] | [NAME] |  | Cathy
 | [NAME] | [NAME] |  | [NAME]
 | [NAME] | [NAME] |  | [NAME]
 | [NAME] | [NAME] |  | [NAME]
 | [NAME] | [NAME] |  | Dwayne
 | [NAME] | Dwayne |  | Jasel
 | [NAME] | Jeremy |  | [NAME]
 | [NAME] | Nick |  | Jeremy
 | [NAME] | Nick |  | [NAME]
 | [NAME] | Nick |  | Julie
 | [NAME] | [NAME] |  | [NAME]
 | [NAME] | [NAME] |  | Magdelena
 | [NAME] | [NAME] |  | Nichelina
 | [NAME] | [NAME] |  | Nick
 | [NAME] | [NAME] |  | Pa
 | [NAME] | [NAME] |  | [NAME]
 | [NAME] | [NAME] |  | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | Jasel
 | [NAME] | Jasel
 | [NAME] | [NAME]
 | [NAME] | Jayleen
 | [NAME] | Julie
 | [NAME] | Julie
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | Cathy | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | Julie
 | [NAME] | Julie
 | [NAME] | [NAME]
 | [NAME] | Julie
 | [NAME] | [NAME]
 | Dwayne | [NAME]
 | Dwayne | [NAME]
 | Dwayne | Nick
 | Dwayne | [NAME]
 | Jasel | [NAME]
 | Jasel | [NAME]
 | Jasel | Julie
 | Jasel | Julie
 | Jasel | [NAME]
 | [NAME] | [NAME]
 | [NAME] | Dwayne
 | Jeremy | [NAME]
 | Jeremy | [NAME]
 | [NAME] | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | Dwayne
 | Julie | Gpa
 | Julie | Jasel
 | Julie | Jasel
 | Julie | Jeremy
 | Julie | Jeremy
 | Julie | Magdelena
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | [NAME] | [NAME]
 | Magdelena | [NAME]
 | Nichelina | [NAME]
 | Nichelina | [NAME]
 | Nichelina | [NAME]
 | Nichelina | [NAME]
 | Nichelina | Dwayne
 | Nichelina | [NAME]
 | Nick | [NAME]
 | Nick | Julie
 | Nick | Julie
 | Nick | Julie
 | Nick | [NAME]
 | Pa | [NAME]
 | [NAME] | Jasel
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | Nichelina
Spreadsheet: 687054d1594928941-heavy-file-for-calculation-and-save-dates
Sheet: R Test

Sr.
 | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date
 | 08-01) 28-08-2019 | pdf |  | 08-01) 28-08-2019 | pdf |  | 07-01) 30-07-2019 | pdf |  | 10-01) 09-10-2019 | pdf |  | 11-01) 11-11-2019 | pdf
 | 08-02) 28-08-2019 | pdf |  | 10-01) 09-10-2019 | pdf |  | 11-01) 21-11-2019 | pdf |  | 11-01) 11-11-2019 | pdf
 | 10-01) 09-10-2019 | pdf |  | 12-01) 01-12-2019 | pdf
 | 11-01) 24-11-2019 | pdf
 | 12-01) 01-12-2019 | pdf
 | 12-02) 19-12-2019 | pdf
 | 02-01) 18-02-2020 | pdf
Spreadsheet: 624744d1558048733-help-calendar-correction-employee-absence-schedule-current
Sheet: August

 | Absence Type Key | V | Vacation |  |  | P | Personal |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 | August | 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