tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 101935d1300000944-converting-two-columns-of-info-into-a-table-book2
Sheet: Sheet1

Game Week | Date | [NAME] | Home | Away | hgd | agd | total | h win % | draw % | a win % |  | home | best odds | draw | best odds | away | best odds | Home Score | Away Score | Home G/D | Away G/D
1 | 2010-09-04 00:00:00 | League 1 | Accrington | Barnsley | -6 | 7 |  |  |  |  |  |  | 13/5 |  | 12/5 |  | 6/5 | 1 | 0
1 | 2010-09-04 00:00:00 | League 1 | Aldershot | Birmingham | 7 | -2 |  |  |  |  |  |  | 15/13 |  | 12/5 |  | 5/2 | 0 | 0
1 | 2010-09-04 00:00:00 | League 1 | Arsenal | [NAME] | -1 | 1 |  |  |  |  |  |  | 7/5 |  | 5/2 |  | 2/1 | 2 | 0
1 | 2010-09-04 00:00:00 | League 1 | [NAME] | Blackpool | -2 | 4 |  |  |  |  |  |  | 19/10 |  | 12/5 |  | 7/5 | 1 | 0
1 | 2010-09-04 00:00:00 | League 1 | Barnet | [NAME] | 3 | 9 |  |  |  |  |  |  | 4/6 |  | 11/4 |  | 5/1 | 2 | 2
Spreadsheet: dutch_quigley__9382__AIG Deals
Sheet: Options

Counter Party | Settlement | Call / Put | Month | Exp Date | Notional Volume | delta in mmBtu | Strike | Float Price
AIGENETRA | PEN | C | 2001-12-01 00:00:00 | 2001-11-27 00:00:00 | 1000000 | 6.2997 | 6 | 2.676
AIGENETRA | PEN | C | 2001-12-01 00:00:00 | 2001-11-27 00:00:00 | -1000000 | -0.0526 | 7.5 | 2.676
AIGENETRA | PEN | C | 2001-12-01 00:00:00 | 2001-11-27 00:00:00 | 500000 | 7.1835 | 5.75 | 2.676
AIGENETRA | PEN | P | 2001-12-01 00:00:00 | 2001-11-27 00:00:00 | 500000 | -499613.7055 | 5.75 | 2.676
AIGENETRA | PEN | P | 2001-12-01 00:00:00 | 2001-11-27 00:00:00 | -500000 | 472234.8187 | 3.5 | 2.676
AIGENETRA | PEN | P | 2001-12-01 00:00:00 | 2001-11-27 00:00:00 | -1000000 | 944469.6373 | 3.5 | 2.676
AIGENETRA | PEN | C | 2001-12-01 00:00:00 | 2001-11-27 00:00:00 | 500000 | 20.1361 | 5.45 | 2.676
AIGENETRA | PEN | P | 2001-12-01 00:00:00 | 2001-11-27 00:00:00 | 500000 | -499600.7529 | 5.45 | 2.676
AIGENETRA | PEN | C | 2001-12-01 00:00:00 | 2001-11-27 00:00:00 | 250000 | 866.3538 | 4.25 | 2.676
AIGENETRA | PEN | P | 2001-12-01 00:00:00 | 2001-11-27 00:00:00 | 250000 | -248944.0907 | 4.25 | 2.676
AIGENETRA | PEN | C | 2001-12-01 00:00:00 | 2001-11-27 00:00:00 | -500000 | -20.1361 | 5.45 | 2.676
AIGENETRA | PEN | C | 2001-12-01 00:00:00 | 2001-11-27 00:00:00 | -1000000 | -203.8329 | 5 | 2.676
AIGENETRA | PEN | P | 2001-12-01 00:00:00 | 2001-11-27 00:00:00 | 1000000 | -944469.6373 | 3.5 | 2.676
AIGENETRA | PEN | C | 2001-12-01 00:00:00 | 2001-11-27 00:00:00 | 1000000 | 8941.1176 | 4 | 2.676
AIGENETRA | PEN | C | 2001-12-01 00:00:00 | 2001-11-27 00:00:00 | -1000000 | -33.8139 | 5.5 | 2.676
AIGENETRA | PEN | P | 2001-12-01 00:00:00 | 2001-11-27 00:00:00 | 1000000 | -300616.14 | 2.5 | 2.676
AIGENETRA | PEN | P | 2001-12-01 00:00:00 | 2001-11-27 00:00:00 | 1000000 | -112303.5537 | 2.25 | 2.676
AIGENETRA | PEN | P | 2001-12-01 00:00:00 | 2001-11-27 00:00:00 | 1000000 | -112303.5537 | 2.25 | 2.676
AIGENETRA | PEN | C | 2001-12-01 00:00:00 | 2001-11-27 00:00:00 | -1500000 | -252072.2367 | 3.15 | 2.676
AIGENETRA | PEN | P | 2001-12-01 00:00:00 | 2001-11-27 00:00:00 | -1500000 | 1246790.4304 | 3.15 | 2.676
AIGENETRA | PEN | P | 2001-12-01 00:00:00 | 2001-11-27 00:00:00 | -1000000 | 112303.5537 | 2.25 | 2.676
AIGENETRA | PEN | P | 2001-12-01 00:00:00 | 2001-11-27 00:00:00 | -1000000 | 112303.5537 | 2.25 | 2.676
AIGENETRA | PEN | P | 2001-12-01 00:00:00 | 2001-11-27 00:00:00 | 1000000 | -743802.0205 | 3 | 2.676
Spreadsheet: 859369d1707772677-add-inverted-commas-now
Sheet: Micky 3

id | Date | Category | Name | Code | Artist | Venue | Radio Show | Event | Series | Country | City
1 | 1999-12-07 00:00:00 | 2 Many DJs | 2 Many [NAME] @ 3voor12 - Betere 80s Zijn Er Niet Radio Show (07.12.1999) | 4913 | 2 Many DJs
2 | 2000-02-05 00:00:00 | 2 Many DJs | 2 Many [NAME] @ Einslive Partyservice (05.02.2000) | 4914 | 2 Many DJs
3 | 2001-12-25 00:00:00 | 2 Many DJs | 2 Many DJs Christmas Mix (25.12.2001) | 4915 | 2 Many DJs
4 | 2001-02-18 00:00:00 | 2 Many DJs | 2 Many DJs Superchunk Mix 2001 02 (18.02.2001) | 4916 | 2 Many DJs
5 | 2001-12-20 00:00:00 | 2 Many DJs | 2 Many DJs Superchunk Mix 2001 12 (20.12.2001) | 4917 | 2 Many DJs
6 | 2001-01-21 00:00:00 | 2 Many DJs | 2 Many DJs Live @ Sound of Space Festival (21.01.2001) | 4918 | 2 Many DJs
7 | 2002-02-01 00:00:00 | 2 Many DJs | 2 Many [NAME] (In The Mix) (01.02.2002) | 4919 | 2 Many DJs
8 | 2002-06-22 00:00:00 | 2 Many DJs | 2 Many [NAME] Boum De Luxe (22.06.2002) | 4920 | 2 Many DJs
Spreadsheet: 136101d1326404960-nested-if-function-if-x-and-if-y-then-z-itl-booking
Sheet: Desk Summary

DESK | STATUS TODAY
1
2
3
4
5
6
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
Spreadsheet: 737938d1624688611-finding-top-3-largest-values-from-list-and-returning-value-to-left-excel-formula-help
Sheet: Sheet1

 |  | RESULT 1 | 19 |  |  |  |  | RESULT 1 | 19
 |  | RESULT 2 | 12 |  |  |  |  | RESULT 2 | 8
 |  | RESULT 3 | 16 |  | If top 3 results have 2 identical matches |  |  | RESULT 3 | 16 |  | If 3rd highest result has more than 1 match
 |  | RESULT 4 | 8 |  |  |  |  | Kaper is 4th but included | 8
 |  | RESULT 5 | 16 |  | Desired Result |  |  | RESULT 5 | 8 |  | Desired Result
 | 1 | TOP 1 |  |  | RESULT 1 |  | 1 | TOP 1 |  |  | RESULT 1
 | 2 | TOP 2 |  |  | RESULT 3 |  | 2 | TOP 2 |  |  | RESULT 3
 | 3 | TOP 3 |  |  | RESULT 5 |  | 3 | TOP 3 |  |  | RESULT 2
 |  |  |  |  |  |  | 4 |  |  |  | RESULT 4
 |  |  |  |  |  |  | 5 |  |  |  | RESULT 5
Spreadsheet: 878757d1726044610-sort-columns-with-adjecent-cells-test-1
Sheet: Sheet1

Internet & Technology Law | 0.25 | Corporate Law | 15% | Finance Law | 15% | Intellectual Property Law | 15% | Labor & Employment Law | 15% | Tax Law | 15%
Litigation Support Services | 30% | Civil Rights Law | 20% | Labor & Employment Law | 20% | Real Estate Law | 20% | Corporate Law | 20%
Accounting | 10% | Corporate Law | 10% | Finance & Accounting Outsourcing (FAO) | 10% | HR Consulting | 10% | HR Outsourcing | 10% | Tax Law | 10% | Back Office Outsourcing | 5% | Bankruptcy Law | 5% | Compliance Consulting | 5% | Document Digitization & Management | 5% | Finance Law | 5% | Intellectual Property Law | 5% | Labor & Employment Law | 5% | Real Estate Law | 5%
 | 30% | Internet & Technology Law | 0.25 | Civil Rights Law | 20% | Labor & Employment Law | 20% | Real Estate Law | 20% | Corporate Law | 20%
Corporate Law | 15% | Finance Law | 15% | Intellectual Property Law | 15% | Labor & Employment Law | 15% | Tax Law | 15% | Accounting | 10%
Corporate Law | 10% | Finance & Accounting Outsourcing (FAO) | 10% | HR Consulting | 10% | HR Outsourcing | 10% | Tax Law | 10% | Back Office Outsourcing | 5%
Bankruptcy Law | 5% | Compliance Consulting | 5% | Document Digitization & Management | 5% | Finance Law | 5% | Intellectual Property Law | 5% | Labor & Employment Law | 5%
Real Estate Law | 5%
Spreadsheet: 861415d1709281843-index-match-help-race-2-aligw
Sheet: Race

BANK MAUR
Post. | Mar. | Venue | Class | Dist. | Con. | Wgt. | Bar. | Other Runners | Off. Race Time
21 days since last run
9-13 | 4.3 | CAUL | Group 2 | 1100 | Good | 59 | 1 | 1-Kallos | 0:01:02.900000
Spell - 106 days
7-7 | 11.2 | M V | Group 3 | 2040 | Good | 60 | 1 | 1-Ain'tnodeeldun | 0:02:05.220000
14-16 | 13 | FLEM | Group 1 | 2000 | Good | 56 | 3 | 1-Gold Trip | 0:02:01.620000
9-15 | 4.4 | CAUL | Group 1 | 1800 | Good | 58 | 1 | 1-Alligator Blood | 0:01:48.530000
8-14 | 2.9 | CAUL | Group 1 | 1400 | Good | 58.5 | 7 | 1-Mr Brightside | 0:01:23.220000
Spell - 161 days
13-16 | 7.4 | FLEM | Group 1 | 2000 | Good | 54.5 | 7 | 1-Cascadian | 0:02:01.430000
1-11 | 0.8 | M V | Group 2 | 2040 | Good | 57 | 1 | 2-Suizuro | 0:02:06.440000
4-15 | 1.3 | FLEM | Group 1 | 1600 | Good | 57 | 15 | 1-Legarto | 0:01:36.340000
7-14 | 1.5 | FLEM | Group 3 | 1400 | Good | 57 | 8 | 1-Elliptical | 0:01:21.960000
2-11 | 0.1 | SANH | Group 3 | 1300 | Good | 57 | 3 | 1-Jacquinot | 0:01:17.670000
Spreadsheet: 771982d1646941689-not-sure-if-formula-or-code-required-drawing-data-across-sheets-with-cell-value-dependency-example
Sheet: Sheet2

 | DATE | [NAME] | ORDER | [NAME] | POSITION | TYPE | START | FINISH | [NAME] | [NAME] |  |  | DATE | [NAME] | ORDER | [NAME] | POSITION | TYPE | START | FINISH | [NAME] | [NAME]
 |  |  | 1 |  |  |  |  |  |  |  |  |  | 2016-04-11 00:00:00 |  | 1 |  | POSITION A | X | 12:00:00 | 13:00:00
 |  |  | 2 |  |  |  |  |  |  |  |  |  | 2016-04-11 00:00:00 |  | 2 |  | POSITION B | X | 12:00:00 | 15:00:00
 |  |  | 3 |  |  |  |  |  |  |  |  |  | 2016-04-11 00:00:00 |  | 3 |  | POSITION B | X | 12:00:00 | 15:00:00
 |  |  | 4 |  |  |  |  |  |  |  |  |  | 2016-04-11 00:00:00 |  | 4 |  | POSITION B | X | 12:00:00 | 15:00:00
 |  |  | 5 |  |  |  |  |  |  |  |  |  | 2016-04-11 00:00:00 |  | 5 |  | POSITION A | Y | 13:00:00 | 16:00:00
 |  |  | 6 |  |  |  |  |  |  |  |  |  | 2016-04-11 00:00:00 |  | 6 |  | POSITION A | Y | 13:00:00 | 16:00:00
 |  |  | 7 |  |  |  |  |  |  |  |  |  | 2016-04-11 00:00:00 |  | 7 |  | POSITION C | Y | 14:00:00 | 19:00:00
 |  |  | 8 |  |  |  |  |  |  |  |  |  | 2016-04-11 00:00:00 |  | 8 |  | POSITION D | X | 11:00:00 | 14:00:00
 |  |  | 9 |  |  |  |  |  |  |  |  |  | 2016-04-11 00:00:00 |  | 9 |  | POSITION D | Z | 12:00:00 | 14:00:00
 |  |  | 10 |  |  |  |  |  |  |  |  |  | 2016-04-11 00:00:00 |  | 10 |  | POSITION D | Z | 12:00:00 | 14:00:00
 |  |  | 11 |  |  |  |  |  |  |  |  |  | 2016-04-11 00:00:00 |  | 11 |  | POSITION E | X | 12:30:00 | 16:00:00
 |  |  | 12 |  |  |  |  |  |  |  |  |  | 2016-04-12 00:00:00 |  | 12 |  | POSITION A | X | 12:00:00 | 13:00:00
 |  |  | 13 |  |  |  |  |  |  |  |  |  | 2016-04-12 00:00:00 |  | 13 |  | POSITION A | X | 12:00:00 | 13:00:00
 |  |  | 14 |  |  |  |  |  |  |  |  |  | 2016-04-12 00:00:00 |  | 14 |  | POSITION B | X | 12:00:00 | 15:00:00
 |  |  | 15 |  |  |  |  |  |  |  |  |  | 2016-04-12 00:00:00 |  | 15 |  | POSITION A | Y | 13:00:00 | 16:00:00
 |  |  | 16 |  |  |  |  |  |  |  |  |  | 2016-04-12 00:00:00 |  | 16 |  | POSITION C | Y | 14:00:00 | 19:00:00
 |  |  | 17 |  |  |  |  |  |  |  |  |  | 2016-04-12 00:00:00 |  | 17 |  | POSITION C | Y | 14:00:00 | 19:00:00
 |  |  | 18 |  |  |  |  |  |  |  |  |  | 2016-04-12 00:00:00 |  | 18 |  | POSITION C | Y | 14:00:00 | 19:00:00
 |  |  | 19 |  |  |  |  |  |  |  |  |  | 2016-04-12 00:00:00 |  | 19 |  | POSITION D | X | 11:00:00 | 14:00:00
 |  |  | 20 |  |  |  |  |  |  |  |  |  | 2016-04-12 00:00:00 |  | 20 |  | POSITION E | X | 12:30:00 | 16:00:00
 |  |  | 21 |  |  |  |  |  |  |  |  |  | 2016-04-12 00:00:00 |  | 21 |  | POSITION E | X | 12:30:00 | 16:00:00
 |  |  |  |  | THIS IS WHAT I AM TRYING TO FORUMLATE |  |  |  |  |  |  |  |  | THIS IS WHAT SHOULD OUTPUT
 |  |  |  |  | DATE, POSITION, TYPE, START, AND FINSH; DRAWN FROM SHEET 1
 |  |  |  |  | AMOUNT OF ROWS PER POSITION IS DEPENDANT UPON 'NUMBER REQUIRED' COLUMN ON SHEET 1
Spreadsheet: 683919d1593054669-index-match-repetitive-lookup-value-copy-of-vehicle-002-
Sheet: Sheet1

Type |  |  | Plate No. | Departure Time | [NAME] | Departure Time | [NAME]
Toyota Coaster |  |  |  | 1900-01-01 04:00:00 | 12:00:00
[NAME]
Toyota Grandia NAC 4179 |  |  |  | 09:00:00
Toyota Hi-ace (Commuter) VK6539
L300 FB  AVA 2454
L300 FB  AVA2455 |  |  |  | 09:00:00 | 12:00:00 | 09:00:00
Hyundai Starex KAA1951
Mitsubishi Strada KGN 873
Mitsubishi Strada AAR 971
[NAME]
Mitsubishi Montero UQT556
[NAME] B3U 158
 |  |  |  |  | =IF(INDEX(D2:M2,,MATCH(E1,D1:K1,0))="","","1")
Spreadsheet: 862358d1710117911-formula-for-cost-projection-sauna-room-cost-analysis-shared
Sheet: Sheet1

Date | Job | Invoice | [NAME] | Cost/CF | Labor Charge | Est. [NAME] | Est Cost/CF
2023-08-02 00:00:00 |  | 29519.79 | 210.16
2023-07-26 00:00:00 |  | 27468.29 | 255.21
2023-05-01 00:00:00 |  | 28037.76 | 258
2023-07-25 00:00:00 |  | 29507.06 | 262.41
2023-02-13 00:00:00 |  | 39398.8 | 347.11
2024-03-04 00:00:00 |  | 36025.2 | 384
2023-07-03 00:00:00 |  | 45995.26 | 488.2
2023-02-23 00:00:00 |  | 45199.38 | 504
2023-09-06 00:00:00 |  | 47966.41 | 515.38
2024-03-01 00:00:00 |  | 48159.44 | 519.34
2023-02-24 00:00:00 |  | 49713.13 | 595
2023-09-06 00:00:00 |  | 53378.45 | 651.9
2024-02-01 00:00:00 |  | 59984.39 | 780.17
2024-02-01 00:00:00 |  | 60081.37 | 785.33
2023-10-16 00:00:00 |  | 56362.89 | 864.78
2024-03-27 00:00:00 |  | 71191.23 | 922.37
2024-02-26 00:00:00 |  | 63151.85 | 1056.47
2023-06-13 00:00:00 |  | 57585.37 | 1115.28
2023-03-13 00:00:00 |  | 100679.25 | 1408 |  |  | 300
 |  |  |  |  |  | 500
 |  |  |  |  |  | 700
 |  |  |  |  |  | 900
 |  |  |  |  |  | 1100
 |  |  |  |  |  | 1300
 |  |  |  |  |  | 1500
 |  |  |  |  |  | 1700
 |  |  |  |  |  | 1900
 |  |  |  |  |  | 2100
 |  |  |  |  |  | 2300
Spreadsheet: 814831d1674627236-formula-to-list-birthday-per-month-book1
Sheet: Sheet1

Bitrh Date | Month | Day | Age | [NAME] |  |  | January
2022-01-03 00:00:00 |  |  |  | Name Surname 01 |  | Day | Name
2004-05-30 00:00:00 |  |  |  | Name Surname 02
2007-02-13 00:00:00 |  |  |  | Name Surname 03
1981-07-07 00:00:00 |  |  |  | Name Surname 04
1976-06-24 00:00:00 |  |  |  | Name Surname 05
2004-06-08 00:00:00 |  |  |  | Name Surname 06
2015-08-21 00:00:00 |  |  |  | Name Surname 07
1987-01-12 00:00:00 |  |  |  | Name Surname 08
1985-06-11 00:00:00 |  |  |  | Name Surname 09
2020-11-19 00:00:00 |  |  |  | Name Surname 10
2012-10-28 00:00:00 |  |  |  | Name Surname 11
2002-06-20 00:00:00 |  |  |  | Name Surname 12
2017-04-08 00:00:00 |  |  |  | Name Surname 13
1987-02-05 00:00:00 |  |  |  | Name Surname 14
2015-07-13 00:00:00 |  |  |  | Name Surname 15
1959-03-02 00:00:00 |  |  |  | Name Surname 16
1964-11-13 00:00:00 |  |  |  | Name Surname 17
1985-10-22 00:00:00 |  |  |  | Name Surname 18
1998-01-16 00:00:00 |  |  |  | Name Surname 19
1963-06-29 00:00:00 |  |  |  | Name Surname 20
1971-05-15 00:00:00 |  |  |  | Name Surname 21
1939-12-19 00:00:00 |  |  |  | Name Surname 22
2013-02-13 00:00:00 |  |  |  | Name Surname 23
1996-04-25 00:00:00 |  |  |  | Name Surname 24
2019-08-30 00:00:00 |  |  |  | Name Surname 25
1960-12-27 00:00:00 |  |  |  | Name Surname 26
1962-07-18 00:00:00 |  |  |  | Name Surname 27
2021-05-27 00:00:00 |  |  |  | Name Surname 28
1988-10-26 00:00:00 |  |  |  | Name Surname 29
1981-06-12 00:00:00 |  |  |  | Name Surname 30
2001-04-18 00:00:00 |  |  |  | Name Surname 31
2005-10-24 00:00:00 |  |  |  | Name Surname 32
2021-04-21 00:00:00 |  |  |  | Name Surname 33
2018-02-26 00:00:00 |  |  |  | Name Surname 34
1973-01-14 00:00:00 |  |  |  | Name Surname 35
1992-07-28 00:00:00 |  |  |  | Name Surname 36
1968-06-13 00:00:00 |  |  |  | Name Surname 37
2016-06-01 00:00:00 |  |  |  | Name Surname 38
2015-03-03 00:00:00 |  |  |  | Name Surname 39
1993-05-07 00:00:00 |  |  |  | Name Surname 40
1994-05-20 00:00:00 |  |  |  | Name Surname 41
1977-07-08 00:00:00 |  |  |  | Name Surname 42
1982-07-22 00:00:00 |  |  |  | Name Surname 43
1987-04-13 00:00:00 |  |  |  | Name Surname 44
1990-09-04 00:00:00 |  |  |  | Name Surname 45
1995-12-06 00:00:00 |  |  |  | Name Surname 46
1998-01-21 00:00:00 |  |  |  | Name Surname 47
1973-03-10 00:00:00 |  |  |  | Name Surname 48
1978-05-26 00:00:00 |  |  |  | Name Surname 49
Spreadsheet: 21be8dd4-3f28-47aa-ac37-91032d00f7b6
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 | Unnamed: 15
MATTEL, INC. AND SUBSIDIARIES
RECONCILIATION OF GAAP TO NON-GAAP FINANCIAL MEASURE
 |  |  |  |  | Three Months Ended September 30, |  |  |  |  |  | Nine Months Ended September 30,
(In millions, except percentage information) |  |  |  |  |  | 2008 |  |  | 2007 |  |  | 2008 |  |  | 2007
Gross Sales |  |  |  |  | $ | 2128.4 |  | $ | 2018.8 |  | $ | 4349.5 |  | $ | 4152.3
[NAME] |  |  |  |  |  | -182.1 |  |  | -180.2 |  |  | -371.5 |  |  | -370.8
Net Sales |  |  |  |  | $ | 1946.3 |  | $ | 1838.6 |  | $ | 3978 |  | $ | 3781.5
% Change |  |  |  |  |  | 0.06 |  |  | 0.02697871865050548 |  |  | 0.04570487415718769 |  |  | 0.067828198684099
Pos./(Neg.) Impact of Currency (in % pts) |  |  |  |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 3
The financial information included herein should be read in conjunction with Mattel's consolidated financial statements and related notes in its Annual Reports
on Form 10-K and/or Quarterly Reports on Form 10-Q, as applicable.
Spreadsheet: 882748d1731191701-how-to-highlight-days-and-calculate-working-days-based-on-certain-conditions-tracker
Sheet: November

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekend Shift | A |  |  |  |  | LEGEND
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  | P
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Night Shift |  |  |  |  |  | WFH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QUARTER |  | MONTH |  |  |  | YEAR |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ML
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q1 |  | NOVEMBER |  |  |  | 2024 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HL
EMPLOYEE ID | EMPLOYEE NAME | DATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTALS |  |  |  |  |  |  |  | PERCENTAGE
 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Working Days | P | LL | WFH | OT | PL | UL | HL | Total Leave | P % | LL % | WFH %
 | A | P |  |  | P | P | P | P | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 | B | PL |  |  | PL | PL | PL | PL | PL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 | C | WFH |  |  | WFH | WFH | WFH | WFH | WFH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
 |  | WFH |  |  | P | P | P | P | P
 |  | WFH |  |  | PL | LL | LL | UL | P
 |  | WFH |  |  | PL | PL | PL | PL | PL
 |  | PL |  |  | P | LL | P | P | P
 |  | WFH |  |  | P | P | P | P | P
 |  | WFH |  |  | ML | ML |  |  | P
NOTES
Spreadsheet: 472632d1469690316-vlookup-matching-example
Sheet: Sheet1

[NAME] | Contractor Price | [NAME] | Customer Price | How to match column A and B(price breakdown) match with Column C and D (total price )
ABCD 1234575 | $1000 | ABCD 1234567 | $100
ABCD 1234575 | $1000 | ABCD 1234568 | $200
ABCD 1234575 | $50 | ABCD 1234569 | $200
ABCD 1234572 | $200 | ABCD 1234570 | $100
ABCD 1234567 | $100 | ABCD 1234571 | $200
ABCD 1234568 | $200 | ABCD 1234572 | $200
ABCD 1234569 | $200 | ABCD 1234573 | $100
ABCD 1234570 | $100 | ABCD 1234574 | $200
ABCD 1234571 | $200 | ABCD 1234575 | $2050
ABCD 1234572 | $200 | ABCD 1234576 | $10
ABCD 1234573 | $100 | ABCD 1234577 | $33.50
ABCD 1234574 | $200 | ABCD 1234578 | $200
ABCD 1234578 | $200 | ABCD 1234579 | $100
ABCD 1234579 | $100 | ABCD 1234580 | $200
Spreadsheet: 51996d1251665733-subtracting-hours-in-a-work-schedule-laura-test-for-schedule-formula-working-with-new-col
Sheet: Store 3

STORE 3
DATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-10-01 00:00:00
EMPLOYEE | WEDNESDAY |  |  | THURSDAY |  |  | FRIDAY |  |  | SATURDAY |  |  | MONDAY |  |  | TUESDAY |  |  | TOTAL HOURS
DARCELL | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 08:15:00 | 16:00:00 | 7.249999999999999 | 09:00:00 | 16:15:00 | 6.750000000000001 | 09:00:00 | 16:00:00 | 6.499999999999999 | 40 |  |  | DARCELL |  | =SUMIF(D4,G4,J4,M4,P4,S4"DARCELL",D4,G4,J4,M4,P4,S4)
CLINTON | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 38.99999999999999 |  |  | CLINTON |  | 1900-01-01 00:00:00
LAURA | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 38.99999999999999 |  |  | LAURA |  | 1900-01-01 00:00:00
CATHERINE | 14:15:00 | 21:15:00 | 6.499999999999999 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 6.499999999999999 |  |  | CATHERINE |  | 1900-01-01 00:00:00
TERENCE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | TERENCE |  | 1900-01-01 00:00:00
NICK | 15:00:00 | 21:15:00 | 5.749999999999999 | 15:00:00 | 21:15:00 | 5.749999999999999 | 15:00:00 | 21:15:00 | 5.749999999999999 | 15:00:00 | 21:15:00 | 5.749999999999999 | 15:00:00 | 21:15:00 | 5.749999999999999 | 15:00:00 | 21:15:00 | 5.749999999999999 | 34.49999999999999 |  |  | NICK |  | 1900-01-01 00:00:00
Spreadsheet: 715457d1611716414-conditional-sum-2-columns-sum-with-conditions
Sheet: Sheet1

 | Original | Reduced
 | 12 | 0
 | 4 | 0
 | 8 | 0
 | 4 | 2
 | 5 | 0
 | 15 | 0
 | 12 | 0
 | 6 | 0
 | 35 | 18
 | 10 | 9
 | 25 | 20
 | 22 | 0
 | 25 | 21
 | 10 | 0
 | 13 | 0
 | SUM
Spreadsheet: 170539d1343311808-forcast-range-needs-to-be-changing-now-plus-6-weeks-book1
Sheet: Sheet1

 |  | DATE | 2012-07-23 00:00:00 | 2012-07-24 00:00:00 | 2012-07-25 00:00:00 | 2012-07-26 00:00:00 | 2012-07-27 00:00:00 | 2012-07-28 00:00:00 | 2012-07-30 00:00:00 | 2012-07-31 00:00:00 | 2012-08-01 00:00:00 | 2012-08-02 00:00:00 | 2012-08-03 00:00:00 | 2012-08-04 00:00:00 | 2012-08-06 00:00:00 | 2012-08-07 00:00:00 | 2012-08-08 00:00:00 | 2012-08-09 00:00:00 | 2012-08-10 00:00:00 | 2012-08-11 00:00:00 | 2012-08-13 00:00:00 | 2012-08-14 00:00:00 | 2012-08-15 00:00:00 | 2012-08-16 00:00:00 | 2012-08-17 00:00:00 | 2012-08-18 00:00:00 | 2012-08-20 00:00:00 | 2012-08-21 00:00:00 | 2012-08-22 00:00:00 | 2012-08-23 00:00:00 | 2012-08-24 00:00:00 | 2012-08-25 00:00:00 | 2012-08-27 00:00:00 | 2012-08-28 00:00:00 | 2012-08-29 00:00:00 | 2012-08-30 00:00:00 | 2012-08-31 00:00:00 | 2012-09-01 00:00:00 | 2012-09-03 00:00:00 | 2012-09-04 00:00:00 | 2012-09-05 00:00:00 | 2012-09-06 00:00:00 | 2012-09-07 00:00:00 | 2012-09-08 00:00:00 | 2012-09-10 00:00:00 | 2012-08-07 00:00:00 | 2012-08-08 00:00:00 | 2012-08-09 00:00:00 | 2012-08-10 00:00:00 | 2012-08-11 00:00:00
 |  |  | M | T | W | T | F | S | M | T | W | T | F | S | M | T | W | T | F | S | M | T | W | T | F | S | M | T | W | T | F | S | M | T | W | T | F | S | M | T | W | T | F | S | M | M | M | M | M | M
 |  | forcast count
 |  | 17 |  | f | f |  | g |  |  |  |  |  | f |  | f |  | h | g |  |  |  |  | g | h |  |  | h | g | h |  |  | h | h |  | h | h | h |  |  | g | h | g | g |  |  | g | g | g
 | 0
Spreadsheet: 65548d1266273456-find-a-value-across-multiple-sheets-in-another-workbook-sales-orders_2010
Sheet: SalesJul

Expected Sales Proceeds For JANUARY 2010
 |  |  |  |  |  |  | FX | 0.9135
 | INVOICE | INVOICE DATE | CUSTOMER | PRODUCT | Quantity | PRICE        USD / MT | AMOUNT (USD) | AMOUNT (AUD)
EXPORT
 | 100706 | 2010-01-12 00:00:00 | Customer1 | Product1 | 10000 | 2 | 20000 | 21893.81499726327
 | 100707 | 2010-01-12 00:00:00 | Customer2 | Product2 | 20000 | 2 | 40000 | 43787.62999452655
 | 100708 | 2010-01-12 00:00:00 | Customer3 | Product3 | 30000 | 2 | 60000 | 65681.44499178982
 | 100709 | 2010-01-12 00:00:00 | Customer4 | Product4 | 40000 | 2 | 80000 | 87575.2599890531
 | 100710 | 2010-01-12 00:00:00 | Customer5 | Product5 | 50000 | 2 | 100000 | 109469.0749863164
 | 100711 | 2010-01-12 00:00:00 | Customer6 | Product6 | 60000 | 2 | 120000 | 131362.8899835796
 | 100712 | 2010-01-12 00:00:00 | Customer7 | Product7 | 70000 | 2 | 140000 | 153256.7049808429
 | 100713 | 2010-01-12 00:00:00 | Customer8 | Product8 | 80000 | 2 | 160000 | 175150.5199781062
 | 100714 | 2010-01-12 00:00:00 | Customer9 | Product9 | 90000 | 2 | 180000 | 197044.3349753694
DOMESTIC