tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 851580d1701790596-predict-the-score-game-predict-the-score
Sheet: Week 5

2023-12-21 00:00:00
 |  |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | Jordan |  | [NAME] |  | [NAME] |  | [NAME]
 | Palace
 | Brighton
 | A Villa
 | Sheff utd
 | Man City
 | Brentford
 | West Ham
 | Man Utd
 | Tottenham
 | Everton
 | Nott Forest
 | Bournemouth
 | Fulham
 | Burnley
 | Luton
 | Newcastle
 | Liverpool
 | Arsenal
 | Wolves
 | Chelsea
 |  |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | Jordan |  | [NAME] |  | [NAME] |  | [NAME]
Spreadsheet: jim_schwieger__14390__Weather_Central
Sheet: Sheet2

 |  |  |  | 1999-10-22 00:00:00 |  | 1999-10-23 00:00:00 |  | 1999-10-24 00:00:00 |  | 1999-10-25 00:00:00 |  | 1999-10-26 00:00:00 |  | 1999-10-27 00:00:00 |  | 1999-10-28 00:00:00
 |  |  |  | HDD | CDD | HDD | CDD | HDD | CDD | HDD | CDD | HDD | CDD | HDD | CDD | HDD | CDD
Spreadsheet: 169847d1343074137-format-for-canadian-postal-codes-rmcc-sample-data
Sheet: Sheet1

First Name | Middle Name | Last Name | Address | City | Prov | PC | Phone #
[NAME] |  | palmer | 257 [NAME] | toronto | ON | m4m2e3 | [PHONE]
panayiotis | renos | nicolaou |  | ottawa | ON
bill | [NAME] | wagner |  | pickering | ON |  | 2345678909
[NAME] | [NAME] | [NAME] |  | [NAME] | ON |  | 2343454567
eve |  | [NAME] | 234 st hubert st | montreal | QC
[NAME] |  | Picanco | 38 Thorncliffe Pk |  |  | M4H 1J9 | [PHONE]
[NAME] |  | Huber | 81 [NAME] |  |  | M5B 2N1 | [PHONE]
[NAME] |  | St. Louis | 484 [NAME] 415 |  |  | M4Y 2C7 | [PHONE]
Hi icestationzbra,
Thank you very much for your help. I really appreciate this. I use to use Excel a lot but haven't in about 10 years so some things I remember but…
Here are some sample data.
I am formatting each cell so that when the data is add to the cell Excel will authomatically format the added information to the correct format.
Example:
In cell A2 to cell C2, Excel should automatically convert  the information,when it is added, to PROPER
In cell [NAME], Excel should convert all word to PROPER, and the same with cell E2
In cell G2, when the data is added as shown Excel will convert the information as in cell G7 and G8.
Cell H is formatted correctly. When the numbers are added Excel add the dots in the correct spots.
Thanks again for all your help.
ON
QC
NS
NB
MB
BC
PE
SK
AB
NL
NT
YT
NU
Spreadsheet: 264491d1378901365-lining-up-duplicate-items-in-a-row-claimlookups
Sheet: Completed

CR Claims | CR CC |  | 1st Claims | 1st CC |  | 2nd Claim | 2nd CC |  | 3rd Claim | 3rd CC |  | 4th Claim | 4th CC |  | 5th Claim | 5th CC |  | 6th Claim | 6th CC |  | 7th Claim | 7th CC |  | 8th Claim | 8th CC |  | 9th Claim | 9th CC
75W000224 | 4304 |  | 75W000224 | 4304 |  |  |  |  |  |  |  | 75W000244 | 4304
75W000226 | 4304 |  | 75W000226 | 4304 |  |  |  |  |  |  |  | 75W000257 | 4304
75W000227 | 4304 |  | 75W000227 | 4304 |  |  |  |  |  |  |  | 75W000277 | 4304
75W000235 | 4304 |  | 75W000235 | 4304 |  |  |  |  |  |  |  | 75W000288 | 4304
75W000236 | 4304 |  | 75W000236 | 4304
75W000239 | 4304 |  | 75W000239 | 4304
75W000241 | 4304 |  | 75W000241 | 4304
75W000244 | 4304 |  | 75W000244 | 4304 |  | 75W000244 | 4304 |  | 75W000244 | 4304 |  | 75W000244 | 4304
75W000245 | 4304 |  | 75W000245 | 4304 |  | 75W000245 | 4304
75W000247 | 8818 |  | 75W000247 | 8818
75W000256 | 4304 |  | 75W000256 | 4304
75W000257 | 4304 |  | 75W000257 | 4304 |  |  |  |  |  |  |  | 75W000257 | 4304
75W000259 | 4304 |  | 75W000259 | 4304
75W000260 | 4304 |  | 75W000260 | 4304
75W000261 | 4304 |  | 75W000261 | 4304
75W000262 | 4304 |  | 75W000262 | 4304 |  |  |  |  | 75W000262 | 4304
75W000268 | 4304 |  | 75W000268 | 4304 |  | 75W000268 | 4304
75W000276 | 4304 |  | 75W000276 | 4304 |  |  |  |  | 75W000276 | 4304
75W000277 | 4304 |  | 75W000277 | 4304 |  | 75W000277 | 4304 |  | 75W000277 | 4304 |  | 75W000277 | 4304
75W000283 | 4304 |  | 75W000283 | 4304
75W000284 | 8818 |  | 75W000284 | 8818 |  | 75W000284 | 8818 |  | 75W000284 | 8818
75W000285 | 4304 |  | 75W000285 | 4304 |  | 75W000285 | 4304
75W000286 | 4304 |  | 75W000286 | 4304
75W000288 | 4304 |  | 75W000288 | 4304 |  | 75W000288 | 4304 |  |  |  |  | 75W000288 | 4304
 |  |  |  |  |  |  |  |  |  |  |  | New Data Added this year
Spreadsheet: 90798d1290532011-how-to-count-number-of-unique-occurrances-starting-with-a-text-string-office_rank_v2
Sheet: Ranking

Rank | office number | # of agents |  |  |  | Rank
3 | 11004 | 2 |  |  |  | 1 | 5116 | 11
1 | 5116 | 11 |  |  |  | 2 | 5141 | 5
2 | 5141 | 5 |  |  |  | 3 | 11004 | 2
 |  |  |  |  |  | 4 | #N/A | #N/A
copy formula down | continue with full list of office numbers | copy formula down
Spreadsheet: 174972d1345270194-substitution-of-values-new-microsoft-office-excel-worksheet
Sheet: Sheet1

RMG-26 | ADV LDS
WT-6 | CARGO
RMG-60 | MOV
 |  |  |  |  | RMG-1 | ADV LDS
 |  |  |  |  | RMG-26 | MOV
 |  |  |  |  | WT-6 | CARGO
 |  |  |  |  | RMG-48 | MOB
 |  |  |  |  | RMG-60 | DEMOB
 |  |  |  |  | RMG-94
 |  |  |  |  | RMG-98
 |  |  | RMG-1 | 1 |  | ADV LDS | A
 |  |  | RMG-26 | 2 |  | MOV | B
 |  |  | WT-6 | 3 |  | CARGO | C
 |  |  | RMG-48 | 4 |  | MOB | D
 |  |  | RMG-60 | 5 |  | DEMOB | E
 |  |  | RMG-94 | 6
 |  |  | RMG-98 | 7
Spreadsheet: 675863d1588527036-sumproduct-based-on-date-range-sheet-qry-column-c-based-on-qry-column-e-0-test-rhism-
Sheet: Info

[NAME] |  | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | TOTAL
Hours Billed
Hours Worked
Paid Time Off
% Hours Billed vs. Worked
[NAME]
Hours Billed
Hours Worked
Paid Time Off
% Hours Billed vs. Worked
Sum of Billing_Time | Service_Date
Name | Apr
[NAME] | 70.75
[NAME] | 82
Spreadsheet: lisa_gang__22320__ENA_PGE_JUNE_14_15_2002
Sheet: LOSSES

From: | EPMI
To: | PGE System Transactions
Date: | 6/14-15/2002
HE
ENDING | TOTAL |  | TOTAL
Pacific
Prevailing
Time
(PPT)
0100 | 0
0200 | 0
0300 | 0
0400 | 0
0500 | 0
0600 | 0
0700 | 3
0800 | 3
0900 | 3
1000 | 3
1100 | 3
1200 | 3
1300 | 3
1400 | 3
1500 | 3
1600 | 3
1700 | 3
1800 | 3
1900 | 3
2000 | 3
2100 | 3
2200 | 3
2300 | 0
2400 | 0
 | AVISTA(G)CHELAN | PGE | PGE
 | BPA(T)CHELAN/PGE SYS | PGE LOSSES | [NAME] [NAME]
 | AVISTA | PGE | PGE
 | EPMI
 | PGE(L)SYS
 | NEW COLUMN
Spreadsheet: 272956d1382555177-auto-populate-a-cell-best-light-images
Sheet: PURCHASES

BRING INTO STOCK |  |  |  |  |  | PURCHASES
DATE | CATEGORY | STOCK ID | [NAME] | QUANTITY |  | DATE | CATEGORY | [NAME] | QUANTITY | PURCHASE PRICE | TOTAL PRICE | SUPPLIER
Spreadsheet: 265990be-f8b4-4330-a506-71fe413f276f
Sheet: Sheet1

Your Name Here database instructions
For the 5200 Your Name Here Appointment Calendar:
For the 5210 Your Name Here Desk Calendar:
1.) Save this database with your own naming convention to a location that is convenient for you.
2.) Choose the tab labeled [NAME] if you want your order packed bulk.
Choose the tab labeled Individual Mail if you want your order individually mailed (extra charges apply)
3.) You will need to supply the following information for all names:
* First Name
* Last name
* The Full Name field is automatically populated
* For select images (see below for listing), the following special criteria will be applied:
If the first name is less than 10 characters, the image will utilize the first name
If the first name is longer than 10 characters, the image will utilize the last name
If the first  and last name (including the space between them) is less than 10 characters, the image will  utilize both the first and last name
If both the first name is longer than 10 characters and the last names is longer than 10 characters, the image will utilize the first and last initials only - example: [NAME]
4.) If you are requesting your calendars to be individually mailed, you will also need to supply:
* Company Name (if applicable)
* Address
* City
* State
* Zip
* Country (if other than USA)
5.) Your ad copy and any artwork that is to be printed in the imprint area must be supplied.
6.) Send us your database, order and ad copy/artwork.
Additional Information
Double-check all submitted names. [NAME] is not responsible for errors in names or addresses supplied and will not make changes to the submitted database. We do not recommend copying from an existing spreadsheet as the character limit notice will not alert you if there is an issue.
Type First & Last Names in upper/lower case so the software works correctly
Do not include any special characters (example: &, #, @) in the First and Last Names
- comma, apostrophe, quotes, period or hyphen are OK
Type the Company Name exactly as you want it to appear - either upper/lower or all CAPS.
- We suggest no more that 20 characters to ensure the company name is readable.
Select Images referenced above: If the theme you have chosen includes one or more of the images below, the criteria above will apply.
YNH03 - Americana theme - MAR image
YNH11 - Americana theme - NOV image
[NAME] theme - DEC image
YNH19 - City theme - JUL image
YNH29 - Everyday theme - MAY image
YNH33 - Everyday theme - SEP image
YNH36 - Everyday theme - DEC image
YNH42 - Indulge theme - JUN image
YNH47 - Indulge theme - NOV image
YNH60 - Office theme - DEC image
YNH77 - Holiday theme - Cover and MAY image
YNH88 - Sports theme - APR image
YNH90 - Sports theme - JUN image
YNH96 - Sports theme - Cover and DEC image
YNH97 - Buildings theme - JAN image
YNH107 - Buildings theme - NOV image
YNH108 - Buildings theme - DEC image
Spreadsheet: 215414d1361374417-look-for-the-first-space-from-the-right-side-of-a-cell-new-microsoft-excel-worksheetsol2
Sheet: Sheet1

Carracas 28 B 2
Carracas 28 B 5
Carracas 28 B 10
Carracas 28 B 13
Carracas 29 B 8
Carracas 29 B 9
Carracas 30 B 6H
Carracas 30 B 8
Carracas 30 B 13
Carracas 30 B 13R
Carracas 30 B 16
Spreadsheet: 96732d1296049119-stuck-lookup-help-tcc-new-final-left
Sheet: wk26

Tuesday
06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Name | Night
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points |  | 1
1 |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  | 4
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
5 |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  | 8
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
9 |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  | 12
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
13 |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  | 16
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
17 |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  | 20
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
21 |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  | 24
Wednesday
06:00:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
25 |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  | 28
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
29 |  |  |  |  |  |  | 30
31 |  |  |  |  |  |  | 32
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
33 |  |  |  |  |  |  | 34
35 |  |  |  |  |  |  | 36
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
37 |  |  |  |  |  |  | 38
39 |  |  |  |  |  |  | 40
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
41 |  |  |  |  |  |  | 42
43 |  |  |  |  |  |  | 44
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
45 |  |  |  |  |  |  | 46
47 |  |  |  |  |  |  | 48
Thursday
06:00:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
49 |  |  |  |  |  |  | 50
51 |  |  |  |  |  |  | 52
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
53 |  |  |  |  |  |  | 54
55 |  |  |  |  |  |  | 56
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
57 |  |  |  |  |  |  | 58
59 |  |  |  |  |  |  | 60
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
61 |  |  |  |  |  |  | 62
63 |  |  |  |  |  |  | 64
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
65 |  |  |  |  |  |  | 66
67 |  |  |  |  |  |  | 68
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
69 |  |  |  |  |  |  | 70
71 |  |  |  |  |  |  | 72
Spreadsheet: 119782d1314737724-transpose-a-reference-moviemodelprogress
Sheet: end times

 | Senna | Aquinas | Duel | Sugarland Express | Suntrust
Spreadsheet: 135824d1326259299-extracting-data-using-vlookup-and-using-sum-on-the-result-dummy-e-learning
Sheet: E-Learning

E-Learning Scorecard - 2011
JAN.01 ~ JAN.31,2011
Course | Name | Employee No. | Result | Score | Hours
Analyzing the Market | a | 3800035 | pass | 95.5 | 2
Working with and Managing Difficult People Simulation | b | 3800030 | pass | 100 | 2
Giving Successful Presentations Simulation | c | 3800023 | pass | 96.4 | 2
Giving Successful Presentations Simulation | d | 3800002 | pass | 100 | 2
E-mail as a Marketing Tool | e | 3800025 | pass | 92 | 2
Effective Thinking and Creative Problem Solving Simulation | f | 3800034 | pass | 100 | 2
Pursuing Successful Lifelong Learning | g | 3800031 | pass | 100 | 2
FEB.01 ~ FEB.29,2011
Course | Name | Employee No. | Pass/Fail | Score | Hours
Creating and Analyzing an Operating Budget | a | 3800035 | Pass | 79.2 | 2
Difficult People in the Workplace Environment | b | 3800030 | Pass | 100 | 2
Working with and Managing Difficult People Simulation | c | 3800023 | Pass | 100 | 2
Mastering Negotiation | d | 3800002 | Pass | 100 | 2
Writing to Reach the Audience | e | 3800025 | Pass | 91.07 | 2
Business Ethics for Managers | f | 3800034 | Pass | 96 | 2
Business Ethics Simulation | g | 3800031 | Pass | 100 | 2
Group Problem Solving and Decision Making | h | 3800005 | Pass | 100 | 2
Goals and Setting Goals | i | 3800008 | Pass | 97.47 | 2
Spreadsheet: 9b5d2977-2a7c-4155-a38f-f6869eb04dfb
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FSALG | Test | FSALG | [NAME] | [NAME] | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | <2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.    Test Performed by: Viracor-IBT Laboratories                              1001 NW Technology Dr.                              Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FSALG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FSALG | Result | FSALG | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 0f3430e4-15d9-4a34-82b9-7bf26f6bf26e
Sheet: Sheet1

#20292  Valve Boxes and Bonnets 7-12-04 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
rev 7/12/04 ecb
Vendor | Ferguson | Hughes Supply | National Waterworks | Mountain States Pipe
Responding | [NAME] | [NAME] | [NAME] | [NAME]
PN | 0512-0614 | 0512-0614 | 0512-0614 | 0512-0614
Item | [NAME]  #4 | [NAME]  #4 | [NAME]  #4 | [NAME]  #4
Qty | 5 | 5 | 5 | 5
Each | 25.85 | 21 | 23.74 | 24.6
Ext | 129.25 | 105 | 118.7 | 123
Mfr | Tyler #145653 | East Jordan #85605004 | Tyler #4 Base | Tyler #145653
Leadtime | 3-5 working days | 1-2 weeks | 2 weeks | 2 weeks ARO
F.O.B. | [NAME] | [NAME] | [NAME] | [NAME]
Met all specs? | Yes | Yes | Yes | Yes
PN | 0512-0616 | 0512-0616 | 0512-0616 | 0512-0616
Item | [NAME]  #6 | [NAME]  #6 | [NAME]  #6 | [NAME]  #6
Qty | 50 | 50 | 50 | 50
Each | 29.77 | 25 | 28.93 | 29.96
Ext | 1488.5 | 1250 | 1446.5 | 1498
Mfr | Tyler #145660 | East Jordan #85605006 | Tyler #6 Base | Tyler #145660
Leadtime | 3-5 working days | 1-2 weeks | (Did not state lead time) | 2 weeks ARO
F.O.B. | [NAME] | [NAME] | [NAME] | [NAME]
Met all specs? | Yes | Yes | Yes | Yes
PN | 0512-1363 | 0512-1363 | 0512-1363 | 0512-1363
Item | [NAME] 16" | [NAME] 16" | [NAME] 16" | [NAME] 16"
Qty | 90 | 90 | 90 | 90
Each | 20.64 | 17.5 | 20.06 | 20.77
Ext | 1857.6 | 1575 | 1805.4 | 1869.3
Mfr | Tyler #144946 | East Jordan #85507016 | Tyler #16T | Tyler #144946
Leadtime | 3-5 working days | 1-2 weeks | 2 weeks | 2 weeks ARO
F.O.B. | [NAME] | [NAME] | [NAME] | [NAME]
Met all specs? | Yes | Yes | Yes | Yes
PN | 0512-1371 | 0512-1371 | 0512-1371 | 0512-1371
Item | [NAME] Bottom 30" | [NAME] Bottom 30" | [NAME] Bottom 30" | [NAME] Bottom 30"
Qty | 30 | 30 | 30 | 30
Each | 29.99 | 24 | 26.18 | 29.19
Ext | 899.6999999999999 | 720 | 785.4 | 875.7
Mfr | Tyler #145165 | East Jordan #85506030 | Tyler #30B | Tyler #145165
Leadtime | 3-5 working days | 1-2 weeks | 2 weeks | 2 weeks ARO
F.O.B. | [NAME] | [NAME] | [NAME] | [NAME]
Met all specs? | Yes | Yes | Yes | Yes
TOTAL | 4375.05 | 3650 | 4156 | 4366
Spreadsheet: 271035d1381790021-solved-countifs-problem-between-two-dates-month-10
Sheet: Monthly Summary

 |  | current date | 2013-10-14 00:00:00
 |  | current week | 42
 |  |  | NUMBER OF RECEIPTS
 |  | Buzzard | 90
 |  | Scott | 84
 |  | A mizu | 62
 |  | Misc | 84
 |  | TOTAL Reciepts | 271
 |  | No certification | 24
 |  | No MM's on paperwork | 35
 |  | Stock | 8
 |  | Hold | 10
Spreadsheet: 856327d1705597428-transpose-with-conditions-example-1
Sheet: Sheet1

ID | Prio | Code | String |  |  | ID | Code4 | Code1 | Code1 | Code1 | Code1 | Code2 | Code3 | Code3 | Code5 | Code5 | Code5
1000 | 2 | Code1 | String0 |  |  | 1000 | String3 | String0 | String1 | String2
1000 | 3 | Code2 | String1 |  |  | 1001 |  | String4 | String5 |  |  | String6
1000 | 4 | Code3 | String2 |  |  | 1002 |  | String7 | String8 | String9 | String10
1000 | 1 | Code4 | String3 |  |  | 1003 |  | String11 |  |  |  |  | String12 | String13
1001 | 2 | Code1 | String4 |  |  | 1004 | String15 | String14 |  |  |  |  |  |  | String16 | String17 | String18
1001 | 2 | Code1 | String5
1001 | 3 | Code2 | String6
1002 | 2 | Code1 | String7 |  |  | Result
1002 | 2 | Code1 | String8
1002 | 2 | Code1 | String9
1002 | 2 | Code1 | String10
1003 | 2 | Code1 | String11
1003 | 4 | Code3 | String12
1003 | 4 | Code3 | String13
1004 | 2 | Code1 | String14
1004 | 1 | Code4 | String15
1004 | 5 | Code5 | String16
1004 | 5 | Code5 | String17
1004 | 5 | Code5 | String18
Spreadsheet: 868030d1714735575-array-formula-not-doing-what-i-expect-it-to-tool-change-log-aligw
Sheet: Sheet1

Tool Change Log
Operator | Machine | Part Count | Tool Changed | Reason
[NAME] | 1 | 5 | 1
[NAME] | 2 | 4 | 2 |  |  | 4
[NAME] | 3 | 5 | 3 |  |  | false
[NAME] | 4 | 4 | 4 |  |  | false
[NAME] | 5 | 5 | 5 |  |  | false
[NAME] | 6 | 4 | 6 |  |  | false
[NAME] | 7 | 5 | 7 |  |  | false
[NAME] | 8 | 4 | 8 |  |  | false
[NAME] | 2 | 5 |  |  |  | 5
[NAME] | 5 | 4 |  |  |  | false
[NAME] | 2 | 5 |  |  |  | 5
[NAME] | 4 | 4 |  |  |  | false
[NAME] | 3 | 5 |  |  |  | false
[NAME] | 6 | 4 |  |  |  | false
Spreadsheet: 16be9fd2-17d5-424e-86b0-5cd844f7fd80
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5640 | 40235 | Ales | Dedek | CZE | 117 | 00:10:31 | [NAME] | 00:54:11 | 00:00:36 | 00:14:03 | 1 | 01:20:05
5640 | 29800 | [NAME] | [NAME] | SVK | 116 | 00:09:39 | 00:00:48 | 00:59:59 | [NAME] | 00:14:24 | 2 | 01:25:45
5640 | 29700 | Stanislav | [NAME] | CZE | 118 | 00:11:13 | 00:00:59 | 00:59:18 | 00:00:36 | 00:17:29 | 3 | 01:29:40
5640 | 41342 | [NAME] | Mcgreal*** | GBR | 120 | [NAME] | 00:01:01 | 01:06:57 | 00:00:44 | 00:16:57 | 4 | 01:36:54
5640 | 41341 | [NAME] | [NAME] | GBR | 121 | 00:11:06 | 00:01:01 | 01:10:10 | 00:00:31 | 00:15:34 | 5 | 01:38:27
Spreadsheet: 729750d1619302200-sum-amount-of-hours-and-minutes-to-total-time-exa
Sheet: גיליון1

Task | Completed In | Date/Time Updated
1 | 03:33:00 | 2021-04-23 10:04:34 UTC | 3 | 33
1 | 03:08:00 | 2021-04-23 10:07:42 UTC | 3 | 8
1 | 02:43:00 | 2021-04-23 10:10:26 UTC | 2 | 43
1 | 02:55:00 | 2021-04-23 10:13:22 UTC | 2 | 55
1 | 03:00:00 | 2021-04-23 10:41:59 UTC | 3 | 0
1 | 05:11:00 | 2021-04-23 10:47:10 UTC | 5 | 11
1 | 02:49:00 | 2021-04-23 10:50:00 UTC | 2 | 49
Spreadsheet: 72715d1273440963-referencing-adjacent-cell-to-return-highest-figure-hilow-forum
Sheet: Sheet1

2.7 | 14.6
0
0
0
0
0
0
1.7 | 4
-4.3 | 6
0
-6.6 | 9.5
0
0
-9.6 | 3.9
0
0
0
-0.5 | 0.5
-0.4 | 4.1
7.5 | 17.8
-6.8 | 1.9
13.4 | 13.8
12.5 | 18.8
17 | 37.7
0
0
-1.7 | 1
0
0
0
7 | 8.1
-1.3 | 4.1
0
0
0
16.1 | 16.5
0
-0.4 | 12.6
0
-7 | 0.4
0
0
-13.1 | 3.3
0
3.2 | 10.2
Spreadsheet: 75870d1276500133-calculating-1st-position-without-additional-cumulative-calculations-book1
Sheet: Sheet1

 |  |  | r1 | r2 | r3 | r4 | r5 |  | [NAME] | cum r3 | cum r4 | cum r5
 | 1 |  | 8.550579502738254 | 8.87338111352513 | 1.046343244142149 | 3.033115799948183 | 4.256758182336267 |  | 17.42396061626339 | 18.47030386040554
 | 2 |  | 5.754010862354166 | 7.54758548676898 | 4.589477534992474 | 1.565700032836657 | 2.27944227432308 |  | 13.30159634912315 | 17.89107388411562
 | 3 |  | 1.865992084162582 | 3.417373036833906 | 1.505846187766855 | 4.925120623868762 | 6.789988631758328 |  | 5.283365120996488 | 6.789211308763344
 | 4 |  | 3.821921188445865 | 4.043582953890685 | 0.06872514884309844 | 8.677340545184169 | 3.669175281154979 |  | 7.86550414233655 | 7.934229291179649
 | 5 |  | 6.320034471970786 | 5.689350029426223 | 6.827299460620173 | 8.080767916198665 | 4.463698012411708 |  | 12.00938450139701 | 18.83668396201718
 | 6 |  | 9.843066699935745 | 3.961057961652463 | 5.535464401729127 | 1.604233044543455 | 0.02612452018072364 |  | 13.80412466158821 | 19.33958906331733
 | 7 |  | 1.525468730874966 | 3.227496220460486 | 7.319397515373431 | 9.797795816921626 | 0.5791550228701525 |  | 4.752964951335452 | 12.07236246670888
 | 8 |  | 8.874639133384692 | 5.34845223029309 | 3.148449788080956 | 5.337884380909221 | 5.132243539299903 |  | 14.22309136367778 | 17.37154115175874
 | 9 |  | 9.472825621630998 | 7.538231737088728 | 9.016323165937463 | 1.156781039898509 | 8.07155708382696 |  | 17.01105735871973 | 26.02738052465719
 | 10 |  | 3.976370576401518 | 6.848210111578146 | 8.734242609659033 | 7.908317690505271 | 3.1702719561041 |  | 10.82458068797966 | 19.5588232976387
 |  |  |  |  |  |  |  |  | 17.42396061626339 | 26.02738052465719
 |  |  | r1 | 6
 |  |  | r2 | 1
 |  |  | r3 | 9
 |  |  | r4
 |  |  | r5