tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 80978d1281246919-separation-of-data-in-a-thread-sample-2-
Sheet: CHK_006

 | Original Data | A | B | C | D | E | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | Cleaned Data | Length | [NAME] | A | B | C | D | E | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z
2010-08-06 00:00:00 | ATM WITHDRAWAL 4695510100135649    00837 Citibank Lakeside      Singapore   SG SG AUG 06,10 155238 CATEX1008062064427 SGD -40.00
2010-08-06 00:00:00 | ATM WITHDRAWAL 4695510100135649    00807 Citibank Bugis         Singapore   SG SG AUG 06,10 165634 CATEX1008062065595 SGD -40.00
2010-08-06 00:00:00 | ATM WITHDRAWAL 4695510100135649    00807 Citibank Bugis         Singapore   SG SG AUG 06,10 165654 CATEX1008062065598 [NAME]
Spreadsheet: scott_neal__37838__STOR9786
Sheet: STOR951

ENRON CAPITAL & TRADE RESOURCES |  |  |  |  |  |  |  |  |  |  |  |  |  | Confidential - For Internal Use Only
STORAGE UPDATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | File: STOR9786
Below is a summary of the estimated storage working gas levels
for the week ending: |  |  | 2000-06-30 00:00:00
 |  | Gas In Stg | Gas in | Quantity | Percent | Percent |  |  |  |  | Last Year | Three | Five | Quantity | Quantity | Quantity
 |  | Prev Week | Storage | Change | Change | of Full |  |  |  |  | Same | Year | Year | Change From | Change From | Change From
U.S. Region |  | (Bcf) | (Bcf) | from last week | from last week | Capacity |  |  |  |  | Week | Average | Average | last year | 3 year avg. | 5 year avg.
Production Area |  | 421 | 432
(TX, LA, OK, KS, MS)
Market Area - East |  | 806 | 856
Market Area - West |  | 340 | 348
TOTAL U.S.
MONTH TO DATE
Enron Gas Services |  |  | 36.2 | 0 | 0 | 0.924 |  |  |  |  | ECTR is refilling [NAME] as third parties
(as of 1/20/95) |  |  |  |  |  |  |  |  |  |  |  |  |  | are withdrawing, this keeping our
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total position flat for the week.
AGA FULL CAPACITY |  |  | 3294 |  |  |  |  |  |  |  |  |  |  | 3294 | 3294 | 3294
Maximum Gas In Stg Level (Bcf) |  |  | 3127 |  |  |  |  |  |  |  |  |  |  | 3127 | 2832 | 2915
Minimum Gas In Stg Level (Bcf) |  |  | 1335 |  |  |  |  |  |  |  |  |  |  | 1006 | 794 | 871
Spreadsheet: tracy_geaccone__40535__TWOrgPLFormatCORP02
Sheet: AssetSale

DETAILS OF PROCEEDS FROM SALE OF ASSETS
Non-Merchant Activities
(Millions of Dollars)
 | PROCEEDS FROM SALE OF ASSETS
 | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  | Total
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Miscellaneous
Total (line 125)
 | Date |  | Gross |  | (F. Flow) |  | Net |  | Book |  | Gain /
 | of Sale |  | Proceeds |  | Cur. Tax |  | Proceeds |  | Basis |  | Loss
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
Spreadsheet: 813003d1673494720-how-to-count-the-highest-possible-occurrence-in-multiple-tables-julians96-how-to-countif-highest-possible-occurrence-in-an-array-of-data
Sheet: Sheet1

 | Probable | Critical |  |  |  | Catastrophic |  | Critical |  | Marginal |  | Negligible
Highest | Probable | Catastrophic |  |  | Frequent | A |  | A |  | A |  | B
 | Probable | Critical |  |  | Probable | A |  | A |  | B |  | C
 | Probable | Negligible |  |  | Occasional | A |  | B |  | C |  | D
 | Probable | Negligible |  |  | Remote | B |  | C |  | D |  | D
 | Probable | Critical |  |  | Improbable | C |  | D |  | D |  | D
Highest | Probable | Catastrophic |  |  | Incredible | D |  | D |  | D |  | D
 | Incredible | Critical
Highest | Incredible | Catastrophic |  |  |  | Catastrophic |  | Critical |  | Marginal |  | Negligible
Highest | Incredible | Critical |  |  | Frequent | A |  | A |  | A |  | B
 | Incredible | Negligible |  |  | Probable | A |  | A | 0 | B |  | C | 0
Highest | Improbable | Critical |  |  | Occasional | A |  | B |  | C |  | D
Highest | Improbable | Critical |  |  | Remote | B |  | C |  | D |  | D
 | Improbable | Negligible |  |  | Improbable | C |  | D |  | D |  | D | 0
 | Improbable | Negligible |  |  | Incredible | D |  | D | 1 | D |  | D | 0
Highest | Improbable | Marginal
Highest | Improbable | Marginal |  |  | In the coloured tables, find the highest possible occurrence [NAME] being highest, Then Critical, then [NAME] then negligble.
 |  |  |  |  | Then count how may of the highest possible occurrence matching column B were found and input it into Risk classification table.
 |  |  |  |  | The Table in Purple is the desired result
 | Catastrophic | Frequent
 | Critical | Probable
 | Marginal | Occasional
 | Negligible | Remote
 |  | Improbable
 |  | Incredible
Spreadsheet: 114020d1309886765-converting-multiple-rows-to-single-row-based-on-a-key-book1_p51-mustang
Sheet: Sheet1

a | 1 |  | a|1
a | 2 |  | a|1|2
a | 3 |  | a|1|2|3 | a|1|2|3
b | 1 |  | b|1
b | 3 |  | b|1|3 | b|1|3
c | 2 |  | c|2 |  |  | a | 1 | 2 | 3
c | 4 |  | c|2|4 |  |  | b | 1 | 3
c | 6 |  | c|2|4|6 | c|2|4|6 |  | c | 2 | 4 | 6
Spreadsheet: 109244d1306168179-indirect-help-example-1-
Sheet: March

March
Account Number | Account Name | Country | Total Market Value | Cash Value | % Cash
111 | Murphy | UK | 550 | 70 | 0.1272727272727273
5555 | Jones | AUS | 600 | 250 | 0.4166666666666667
333 | Smith | SCO | 750 | 200 | 0.2666666666666667
Spreadsheet: 92010d1291684603-conditional-formatting-a-dynamic-range-formatalternaterows
Sheet: Sheet1

"Dynamic List"
A1
A2
A3
A4
A5
A6
A7
A8
A9
A10
A11
A12
A13
A14
A15
A16
A17
A18
A19
A20
A21
A22
A23
A24
A25
A26
A27
A28
A29
Spreadsheet: 53640d1253573086-get-non-repeated-info-from-another-sheet-that-has-repetitions-lat-and-long-test
Sheet: Sheet1

Name | Code | Year | Latitude | Longitude
Big Farm | A-1 | 2008 | N 0º 1" 1" | W 90º 3" 3"
Big Farm | A-1 | 2009 | N 0º 1" 2" | W 90º 3" 4"
Little Farm | A-2 | 2008 | 80.32564 | 7.3215
Medium Farm | A-3 | 2009 | 3.2654 | 4.5464
Tiny Farm | B-4 | 2008 | 5.265654 | 1.1
Tiny Farm | B-4 | 2007 | 5.265654 | 1.1
Tiny Farm | B-4 | 2009 | 5.265654 | 1.1
Spreadsheet: 886367d1736406748-populating-a-cell-based-on-multiple-possibilities-employee-training-plan-template
Sheet: 30 Day Training Plan (Training)

Employee Training Plan
Employee Name |  | Team |  | Hire Date
Training Topic/Task | Training Type | Training Hours | Expected Completion Date | Start Date | Actual Completion Date | Status | What this should say | Notes
[NAME] | CBT | 4 | 2025-01-15 00:00:00 | 2024-12-22 00:00:00 | 2024-12-30 00:00:00 |  | Completed |  |  |  |  |  | Completed
[NAME] | Hybrid | 12 | 2025-01-15 00:00:00 | 2024-12-24 00:00:00 |  |  | In Progress |  |  |  |  |  | In Progress
Org History | CBT | 1 | 2025-01-15 00:00:00 |  |  |  | Not Started |  |  |  |  |  | Not Started
PowerPoint for Beginners | CBT | 4 | 2024-11-30 00:00:00 |  |  |  | Not Started-Past Due |  |  |  |  |  | Not Started - PAST DUE
Benefits Overview | In Person | 1 | 2024-11-30 00:00:00 | 2024-12-10 00:00:00 |  |  | In Progress-past due |  |  |  |  |  | In Progress - PAST DUE
Payroll Training | In Person | 1 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00 | 2024-12-31 00:00:00 |  | Completed-past due |  |  |  |  |  | Completed - PAST DUE
Spreadsheet: 104583d1302125776-consolidate-duplicate-rows-into-one-cell-test1
Sheet: FINAL

number | first | price 1 | price 2 | price 3 | price 4 | TOTAL
100001 | [NAME] | $25.00 | $50.00 | $45.00 |  | $120.00
100002 | [NAME] | $50.00 |  |  |  | $50.00
100003 | morgan dames | $25.00 |  |  |  | $25.00
100004 | [NAME] | $75.00 |  |  |  | $75.00
100005 | carol reeves | $25.00 |  |  |  | $25.00
100006 | [NAME] | $50.00 |  |  |  | $50.00
100007 | [NAME] | $15.00 | $25.00 | $150.00 |  | $190.00
100008 | [NAME] | $100.00 | $100.00 | $100.00 | $100.00 | $400.00
Spreadsheet: 02c211e8-4e6d-4dc4-a9d1-840de410f48a
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
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 10. LEASE FINANCE COMMITMENTS, For Motor Vehicles: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Motor cars and station wagons - New ; |  |  | Original | A2413502X | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Motor cars and station wagons - Used ; |  |  | Original | A2413503A | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Light trucks - New ; |  |  | Original | A2413504C | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Light trucks - Used ; |  |  | Original | A2413505F | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Heavy trucks - New ; |  |  | Original | A2413506J | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Heavy trucks - Used ; |  |  | Original | A2413507K | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Other motor vehicles ; |  |  | Original | A2413508L | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Original | A2413509R | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 114987d1310641335-formula-for-auto-fill-test
Sheet: Sheet1

POST CODE |  | Manager
AB54 7SA |  | This cell should display manager's name according to the post code in A3
AB33 8QY |  | This cell should display manager's name according to the post code in A4
AB31 6DB
AB53 4EE
AB31 6NH
AB31 6NH
AB24 4YN
[NAME]
AB56 4DD
AB43 7AL
AB12 3NZ
AB31 4LL
AB42 4NG
AB53 8ES
AB53 4EE
AB45 2JT
16
CA11 8TD
CA11 8TD
CA11 8TD
CA11 8TD
CA11 8TD
CA21 2YY
CA13 9DN
CA7 3DB
CA17 4HL
CA13 9PL
CA10 3BT
CA15 6SP
12
DD5 3DQ
DD5 3QN
DD2 5QT
DD8 1BQ
DD9 7QY
DD10 9JB
6
DG5 4JZ
DG11 3AT
DG2 0JT
3
EH49 7TF
EH47 8AT
EH10 6PX
EH26 0RB
EH36 5PL
EH35 5LN
EH18 1HJ
7
FK10 3GB
1
G84 0JR
G41 3SP
2
IV12 5LE
IV63 7YJ
IV36 2RU
IV25 3SD
IV55 8GH
IV55 8GD
IV55 8GD
IV27 4DH
IV15 9ST
IV27 4ED
IV36 2RL
IV19 1JU
IV27 4AU
IV27 4AU
IV30 5QL
IV2 6XG
IV26 2TX
17
KA1 1TY
KA26 0RF
KA13 7DL
3
KY5 9HS
[NAME]
[NAME]
[NAME]
KY16 0BQ
KY3 0YR
6
KW14 7PF
[NAME]
KW14 8PS
KW14 [NAME]
KW14 7DT
KW14 8SX
6
ML5 5AL
ML4 2NR
ML11 8HA
ML12 6PH
ML5 5FL
ML3 7TX
6
NE3 2RP
1
PA34 4XQ
PA23 7BD
PA75 6PX
PA67 6DL
4
PH1
PH6 2NJ
PH32 4BN
PH17 2QH
PH6 2HL
PH8 0AZ
PH10 7CP
PH32 4BY
PH32 4BW
PH17 2QW
10
TD4 6DR
TD7 5EY
TD8 6XA
3
Spreadsheet: 27e2b5e0-d3c9-443d-9ae6-1ef0749206de
Sheet: Sheet1

FINLAND | Unnamed: 1
AREA CODE DECODER
Last update: October 3, 2002
Area Code | Area Code Name
2 | Turku and [NAME]
3 | Hame
5 | Kymi
6 | Vaasa
8 | Oulu
9 | Capital Region (Helsinki)
13 | Northern Karelia
14 | Central Finland
15 | Mikkeli
16 | Lapland
17 | [NAME]
18 | Aland Islands
19 | Uusimaa
Spreadsheet: 866274d1713228989-help-for-creating-major-league-table-24-soeyaza-
Sheet: Initial Setup

Number of Clubs | 29 |  | No | Club Name
 |  |  | 1 | Memphis | ç | Club Name entried here won't be processed
 |  |  |  | [NAME] | ç | Club Name entried here won't be processed
 |  |  |  | Charleston | ç | Club Name entried here won't be processed
 |  |  |  | Colorado S. | ç | Club Name entried here won't be processed
 |  |  |  | Detroit City | ç | Club Name entried here won't be processed
 |  |  |  | El Paso | ç | Club Name entried here won't be processed
 |  |  |  | FC Tulsa | ç | Club Name entried here won't be processed
 |  |  |  | [NAME] | ç | Club Name entried here won't be processed
 |  |  |  | Indy Eleven | ç | Club Name entried here won't be processed
 |  |  |  | Las Vegas L. | ç | Club Name entried here won't be processed
 |  |  |  | [NAME] | ç | Club Name entried here won't be processed
 |  |  |  | Louisville City | ç | Club Name entried here won't be processed
 |  |  |  | Miami FC | ç | Club Name entried here won't be processed
 |  |  |  | [NAME] | ç | Club Name entried here won't be processed
 |  |  |  | New Mexico | ç | Club Name entried here won't be processed
 |  |  |  | Oakland Roots | ç | Club Name entried here won't be processed
 |  |  |  | Orange County | ç | Club Name entried here won't be processed
 |  |  |  | Phoenix Rising | ç | Club Name entried here won't be processed
 |  |  |  | Pittsburgh | ç | Club Name entried here won't be processed
 |  |  |  | Rio Grande | ç | Club Name entried here won't be processed
 |  |  |  | Sacramento R. | ç | Club Name entried here won't be processed
 |  |  |  | San Antonio | ç | Club Name entried here won't be processed
 |  |  |  | San Diego Loyal | ç | Club Name entried here won't be processed
 |  |  |  | Tampa Bay | ç | Club Name entried here won't be processed
Spreadsheet: cara_semperger__1445__ENA_PGE_DEC01_2001
Sheet: SYS-JD OR GRIZZ BR

From: | EPMI
To: | PGE System Transactions
Date:
HE
ENDING |  |  |  | SINK | SINK | SINK | SINK | SINK
Pacific Prevailing
Time | SYS/SYS OUT AT GRIZZLY | SYS | PGE LOSSES | EPMI COB S/N | PGE LOSSES | TO GRIZZLY | TO SYS | TO [NAME] | BUY/RESALE
(PPT) |  |  |  | LOSS RETURN |  |  |  |  | [NAME]
0100 |  |  | 0 |  | 0
0200 |  |  | 0 |  | 0
0300 |  |  | 0 |  | 0
0400 |  |  | 0 |  | 0
0500 |  |  | 0 |  | 0
0600 |  |  | 0 |  | 0
0700 |  |  | 1 |  | -1
0800 |  |  | 1 |  | -1
0900 |  |  | 1 |  | -1
1000 |  |  | 1 |  | -1
1100 |  |  | 1 |  | -1
1200 |  |  | 1 |  | -1
1300 |  |  | 1 |  | -1
1400 |  |  | 1 |  | -1
1500 |  |  | 1 |  | -1
1600 |  |  | 1 |  | -1
1700 |  |  | 1 |  | -1
1800 |  |  | 1 |  | -1
1900 |  |  | 1 |  | -1
2000 |  |  | 1 |  | -1
2100 |  |  | 1 |  | -1
2200 |  |  | 1 |  | -1
2300 |  |  | 0 |  | -1
2400 |  |  | 0 |  | 0
 |  |  | BPA(G)SYS |  |  |  |  |  | SHOULD BE ZERO
 |  |  | CLSK(PSE) | EPMI COB S/N | PGE LOSSES | TO COB' | TO COB' | TO COB'
 |  |  | BPA(T)BPAP/PGE | LOSS RETURN |  | SEE COB SHEET | SEE COB SHEET | SEE COB SHEET
 |  |  | CLSK(PSE)
 |  |  | EPMI(PSE)
 | PGE(L,R)SYS/SYS OUT AT GRIZZLY | PGE(L,R)SYS   SYSTEM SALE | PGE@SYS   LOSSES
 |  | NOT A BUY/RESALE
Spreadsheet: 826475d1682028951-pull-data-from-one-sheet-to-another-from-last-data-entered-in-a-column-and-the-12-24-above-ak-sample3-2-
Sheet: COVER-24

 | AK |  |  |  |  |  | unlock 1111 |  |  |  |  |  |  | combo | Cover
Well No. | 12H | 13H | 14H | 15H | Total |  |  |  |  |  |  |  |  | combo
Start Date: |  |  |  |  |  |  |  |  |  |  |  |  |  | combo
Online/Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  | combo
Choke |  |  |  |  |  |  |  |  |  |  |  |  |  | lt f
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | lt p
Casing PSI |  |  |  |  |  |  | Copy and paste table into email body |  |  |  |  |  |  | fork
Surface Csg |  |  |  |  |  |  |  |  |  |  |  |  |  | lift
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | trash
Water / Day |  |  |  |  |  | Clear | enter water totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | ft
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | ft
Oil / Day |  |  |  |  |  |  | enter oil totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | plug C
[NAME] to sales |  |  |  |  |  |  |  |  |  |  |  |  |  | plug C
Gas / Day |  |  |  |  |  |  | enter gas totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | plug C
Inj / Day | off | off | off |  |  |  |  |  |  |  |  |  |  | st
 |  |  |  |  |  |  |  |  |  |  |  |  |  | st
Yesterday Lact |  |  |  |  |  |  |  |  |  |  |  |  |  | st
Notes: | Hello how are you? Oh Im doing ok. XXXX OPEN WELL XX/128  S/I XXXX psi. Going to the store, I'll be back soon. see you soon. |  |  |  |  |  | gfhghcghghgvhvgvgvhgvhvghvgvgh
 | PM
 | 12H | 13H | 14H | 15H
GAS
WATER
OIL
 | AM |  |  |  |  |  | lact total
 | 12H | 13H | 14H | 15H |  |  | 0430 | 24 b4 |  |  |  |  | IF(g28-h28<0,0,g28-h28)
GAS |  |  |  |  |  | 750 |  | 118029
WATER |  |  |  |  |  | 760
OIL |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | 0
Spreadsheet: 80777d1280970238-formula-that-automatically-uses-the-last-cell-in-a-row-golfpressespaymentexample
Sheet: Sheet1

Downs
Score | Hole 1 | Hole 2 | Hole 3 | Hole 4 | Hole 5 | Hole 6 | Hole 7 | Hole 8 | Hole 9
Player1 | 4 | 4 | 5 | 3 | 4 | 4 | 5 | 4 | 3
Player2 | 3 | 4 | 3 | 4 | 3 | 4 | 3 | 4 | 3
$5 2-Downs | -5 | -5 | -5 | 0 | -5 | -5 | -10 | -10 | -10 |  | I think on hole 5 plaryer 1 lost $10 not $5.
Player 1 | -1 | -1 | -2 | -1 | -2 | -2 | -3 | -3 | -3 | <- Running Tot
 |  |  | 0 | 1 | 0 | 0 | -1 | -1 | -1 |  | 2-Down Rules:?
 |  |  |  |  |  |  |  |  |  |  | If a player goes down by 2 then the next holes doubles in value
[NAME] |  |  |  |  |  |  |  |  |  |  | It doubles again if a player goes down by 4 holes are 4 times the value
Running Totals
Abs of Run Tot
Hole $ [NAME]
Running Tot $
$5 1-Downs | -5 | -5 | -10 | 0 | -20 | -20 | -25 | -25 | -25
Player 1 | -1 | -1 | -2 | -1 | -2 | -2 | -3 | -3 | -3 |  | 1-Down Rules:?
 | 0 | 0 | -1 | 0 | -1 | -1 | -2 | -2 | -2 |  | If a player goes down a hole then the next holes double in value
 |  |  | 0 | 1 | -1 | -1 | -2 | -2 | -2 |  | If a player goes down by 2 holes then it doubles again
 |  |  |  | 0 | -1 | -1 | -2 | -2 | -2
 |  |  |  |  | 0 | 0 | -1 | -1 | -1
 |  |  |  |  |  |  | 0 | 0 | 0
[NAME]
[NAME]
Hole $ Value
[NAME]
Hints: - Only calculate player 1 and player 2 will be the opposite value.
1. Treat each hole as halved (0), Won (1) or Lost by Player 1 using =If(B3=[NAME]<B4,1,-1)
2. You need a running total of holes ahead or down by player 1 to determine the value of next hole.
3. You need an absolute value of this total in 2 for the choose function next
4. The value of each hole is determined by a choose function using 3 above - Choose(Max (of Abs of Run Tots),5,10,10,20,20,40) for 2-down and …,5,10,30,40,50,60) for 1-down.
I'm not sure how to roll this up into a single equation.  I think my answer is correct using separate rows for each breakdown of the problem.
Spreadsheet: 694653d1599737109-excel-lookup-and-countif-issue-example-100920
Sheet: Trading

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  | Bought | Sold | Balance | Cost | Realised | Fees | Dividend | Current share price link | Current Share Price | Currency | Current rate | Current Share Value (£) | Total Profit / Loss (£)
 |  |  |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  | 25
Spreadsheet: 836907d1689707987-vlookup-help-traning
Sheet: Sheet1

Name | Start Date | Shift | Title | Supervisor
Abarca, Efs | 2016-01-25 00:00:00 | 2nd shift (E) | Production LEAD – East
Sds, [NAME] | 2021-01-20 00:00:00 | 1st Shift | Paint Operator
Bes, [NAME] | 2017-04-26 00:00:00 | 1st shift | Multi-Skilled Operator
Jones, [NAME] | 2013-01-28 00:00:00 | 1st Shift | [NAME]
Epp, Damon | 2018-09-06 00:00:00 | 1st Shift | Line 1 (A) [NAME] STATION ?
Mon, [NAME] | 2020-10-12 00:00:00 | 1st shift | [NAME]
[NAME], [NAME] | 2021-11-01 00:00:00 | 1st shift | General Factory Trainee
[NAME], [NAME] | 2021-07-07 00:00:00 | 2nd shift | Brake Press Set-Up Trainee
[NAME], [NAME] | 2022-01-03 00:00:00 | 2nd shift | General Factory Trainee
Spreadsheet: 56238d1256320029-unique-codes-sample-code-data-2-
Sheet: Sheet1

ID | Day | AA | AB | AC | AD | AE | AF | AG | AI | AM | score per day
10002 | 1 |  |  |  |  |  | 2 |  |  | 1 | 2 |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1
10002 | 2 |  |  |  | 1 |  | 2 |  |  |  | 1 |  |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
10002 | 3 |  |  |  | 1 |  | 2 |  |  | 1 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10002 | 4 |  |  |  |  |  | 2 |  |  | 2 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10002 Total |  |  |  |  | 2 |  | 8 |  |  | 4 | 3 |  |  | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1
10005 | 1 |  |  |  |  |  | 2 |  | 1 | 1 | 3 |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1
10005 | 2 |  |  |  |  |  | 1 | 1 |  |  | 1 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
10005 | 3 |  |  |  |  |  | 1 | 1 |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10005 | 4 |  |  |  |  |  |  | 1 | 1 | 1 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10005 Total |  |  |  |  |  |  | 4 | 3 | 2 | 2 | 4 |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1
10009 | 1 |  |  |  |  |  | 1 | 1 | 1 |  | 3 |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0
10009 | 2 |  |  |  |  |  | 1 |  | 1 | 1 | 1 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
10009 | 3 |  |  |  | 1 |  | 2 |  | 1 |  | 1 |  |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
10009 | 4 |  |  |  |  |  | 2 |  | 1 | 2 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10009 Total |  |  |  |  | 1 |  | 6 | 1 | 4 | 3 | 5 |  |  | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 1
Spreadsheet: af52ef8c-63ca-4876-bf03-a968d6bda53c
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40329406 | 2014-03-03 05:06:54 | ALLIES | 1 | 5 | 1 | 1074409 | ATTappman | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
40329670 | 2014-03-03 05:31:33 | AXIS | 1 | 5 | 3 | 1074409 | ATTappman | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
40345848 | 2014-03-04 04:52:41 | ALLIES | 1 | 5 | 1 | 386133 | jskimming | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
40346553 | 2014-03-04 05:26:20 | AXIS | 1 | 5 | 3 | 386133 | jskimming | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
40439517 | 2014-03-09 23:32:26 | ALLIES | 0 | 2 | 6 | 243582 | Vercingetorix1302 | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
40439758 | 2014-03-09 23:50:39 | AXIS | 0 | 5 | 6 | 243582 | Vercingetorix1302 | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
40457966 | 2014-03-11 03:39:46 | ALLIES | 1 | 6 | 5 | 24638 | cem0007 | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
40458174 | 2014-03-11 04:01:11 | AXIS | 0 | 4 | 6 | 24638 | cem0007 | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
Spreadsheet: 97440d1296607989-sum-with-criteria-need_help
Sheet: Dec

 | Part Number |  |  |  |  |  |  | Category | Sub-Category |  |  | Delivery Location |  |  |  | Delivered Price
 | 1 |  |  |  |  |  |  | Fittings | Code 62 |  |  | Fort Payne, AL |  |  |  | 10000
 | 2 |  |  |  |  |  |  | Fittings | Code 62 |  |  | Fort Payne, AL |  |  |  | 5000
 | 3 |  |  |  |  |  |  | Fittings | 37° Flare J533b |  |  | Fort Payne, AL |  |  |  | 7000
Spreadsheet: 677337d1589309718-help-fix-almost-perfect-formula-that-extracts-unique-list-from-two-columns-uniquelistfromtwocolumns
Sheet: Mapping

 |  |  |  |  |  |  |  |  |  |  |  |  | Cost Centers | In Timesheet | In Rec Assist | List
 |  |  |  |  |  |  |  |  |  |  |  |  | 7404 |  | 7912
 |  |  |  |  |  |  |  |  |  |  |  |  | 2145 |  | 7913
 |  |  |  |  |  |  |  |  |  |  |  |  | 3202 | 3202 | 7503
 |  |  |  |  |  |  |  |  |  |  |  |  | 7002 |  | 7102
 |  |  |  |  |  |  |  |  |  |  |  |  | 7004 |  | 7104
 |  |  |  |  |  |  |  |  |  |  |  |  | 7005 |  | 7503
 |  |  |  |  |  |  |  |  |  |  |  |  | 7006
 |  |  |  |  |  |  |  |  |  |  |  |  | 7007
 |  |  |  |  |  |  |  |  |  |  |  |  | 7102 | 7102
 |  |  |  |  |  |  |  |  |  |  |  |  | 7103
 |  |  |  |  |  |  |  |  |  |  |  |  | 7104 | 7104
 |  |  |  |  |  |  |  |  |  |  |  |  | 7204
 |  |  |  |  |  |  |  |  |  |  |  |  | 7302 | 7302
 |  |  |  |  |  |  |  |  |  |  |  |  | 7403
 |  |  |  |  |  |  |  |  |  |  |  |  | 7502
 |  |  |  |  |  |  |  |  |  |  |  |  | 7503
 |  |  |  |  |  |  |  |  |  |  |  |  | 7602
 |  |  |  |  |  |  |  |  |  |  |  |  | 7905
 |  |  |  |  |  |  |  |  |  |  |  |  | 7912
 |  |  |  |  |  |  |  |  |  |  |  |  | 7913
 |  |  |  |  |  |  |  |  |  |  |  |  | 7943