tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 33849d1230694430-conditional-format-help-match-matches
Sheet: Sheet1

 | [NAME] |  | NYG | √ | GB | √ | DAL | √ | SD | √ | BUF | X | CHI | X | NO | X | NE | X
 | [NAME] |  | CIN | X | ARZ | √ | ATL | √ | PHI | X | DEN | P | SEA | X | MIA | X | NYJ | X
 | [NAME] |  | PHI | √ | NE | √ | WAS | √ | CLE | √ | IND | √ | CIN | X | SD | X | BAL | √
 | Gayle |  | JAC | X | ATL | X | NE | X | BUF | √ | IND | √ | NO | √ | NYJ | X | PHI | √
 | [NAME]
 | [NAME] |  | JAC | X | NYG | √ | TEN | √ | PHI | X | CHI | √ | CAR | X | NYJ | X | BUF | X
 | [NAME]
 | [NAME] |  | KC | √ | DEN | √ | ATL | √ | BUF | √ | CIN | √ | CAR | X | NYJ | X | JAC | X
 | [NAME] |  | JAC | X | NO | X | PHI | √ | WAS | √ | SEA | X | TB | √ | DET | √ | NYJ | X
 | [NAME] |  | PHI | √ | SEA | X | CLE | X | NO | √ | NE | √ | HOU | X | TB | X | BAL | √
 | Nathan
 | NewPort
 | [NAME] |  | NYJ | √ | NO | X | ATL | √ | TEN | √ | IND | √ | PHI | √ | CHI | √ | BUF | X
 | Pam |  | ATL | √ | SD | X | CLE | X | GB | X | BUF | X
Spreadsheet: 872677d1719042269-conditional-formatting-for-numbers-and-in-the-same-coloumn-samyraj-sample-report-cf-aligw
Sheet: Sheet1

 |  |  | Actual | budget | [NAME]
 |  |  | 50 | 75 |  | manually Formatted
 |  |  | 100 | 80 |  | manually Formatted
 |  |  | 0.25 | 0.5 |  | manually Formatted
 |  |  | 11 | 22 |  | manually Formatted
 |  |  | 0.5 | 0.725 |  | manually Formatted
 |  |  | Actual | budget | [NAME]
 |  |  | 100 | 75
 |  |  | 60 | 80
 |  |  | 0.75 | 0.5 |  |  | Expecting this value to show in Black Font , when the variance becomes positive
 |  |  | 11 | 22
 |  |  | 1 | 0.725 |  |  | Expecting this value to show in Black Font , when the variance becomes positive
Spreadsheet: 07e8ab7d-c398-4d62-91b2-a154190d042f
Sheet: AP3-Replacement L2

MR | Major Replacement Costs |  |  |  |  |  |  |  |  |  |  |  | Years |  | 60
REF |  | Description | Qty | Unit | Rate | Year | Cost TODAY | f | Factored Cost | Annual Cost Equiv. | Life Cycle Cost (ne) | (e) | Escalated LLC | (i) | Present Value
2.0 | Maintenance (Replacement) Costs
2.1 | Major Replacement
22 | Internal Walls, Partitions
22 |  | Stud Partitions | 1 | LS | 14170 | 30 |  | 1.2 |  |  |  | 0.03 |  | 0.05
 |  | [NAME] Costs
 |  | Total Major Replacement Costs
Spreadsheet: darrell_schoolcraft__7809__imbalsumm0108
Sheet: summary

TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES |  |  |  |  |  | index
 |  |  |  |  |  | SJ
Positive=due [NAME] |  | Negative = due operator |  |  |  | AVG
 |  |  |  |  |  | NTXPH
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
[NAME] |  |  |  | Volumetric | [NAME]
Conoco |  |  |  | Dollar Valued | [NAME] | [NAME] and Maljamar
SoCal |  |  |  | Volumetric | [NAME]
EPFS / PG&E TX |  |  |  | Dollar Valued | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME]
CIG |  |  |  | Dollar Valued | [NAME]
Mojave Pipeline |  |  |  | Volumetric | [NAME]
Amoco Abo |  |  |  | Dollar Valued | [NAME]
NGPL |  |  |  | Volumetric | [NAME]
NNG |  |  |  | Dollar Valued | [NAME]
Red Cedar |  |  |  | Volumetric | [NAME]
Mewborne |  |  |  | Dollar Valued | [NAME]
Duke/GPM |  |  |  | Dollar Valued | [NAME] | Crawford, Pecos Diamond, [NAME], Linam Ranch, Artesia
Amoco |  |  |  | Volumetric | [NAME]
Northwest |  |  |  | Volumetric | [NAME]
Lonestar |  |  |  | Volumetric | [NAME]
Panhandle Eastern |  |  |  | Volumetric | [NAME] | Hansford
PNM |  |  |  | Dollar Valued | [NAME]
Oasis |  |  |  | Volumetric | [NAME]
PG&E Topock |  |  |  | Volumetric | [NAME]
Calpine |  |  |  | Dollar Valued | [NAME]
EOG |  |  |  | Dollar Valued | [NAME]
TransColorado |  |  |  | Dollar Valued | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME] | cashed out monthly
El Paso |  |  |  | Volumetric | [NAME] | Blanco and Window Rock
Burlington |  |  |  | Dollar Valued | [NAME] | balance is cashed out monthly
Receivable imbalances
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
Citizens Communications |  |  |  | Dollar Valued | [NAME]
North Star Steel |  |  |  | Dollar Valued | [NAME]
Citizens-Griffith |  |  |  | Dollar Valued | [NAME]
Agave |  |  |  | Dollar Valued | [NAME]
El Paso Field Services |  |  |  | Dollar Valued | [NAME]
Continental |  |  |  | Dollar Valued | [NAME]
Payable imbalances
Net imbals
Note -  This report does not represent the total population of imbalances on Transwestern.
Spreadsheet: 012e8d62-4303-4276-9b65-bedcb781e84c
Sheet: FY11 expense

FSYR | 2011
FUND | (Multiple Items)
DEPT CODE | (Multiple Items)
ORGN CODE | (Multiple Items)
Row Labels | Sum of TOTAL EXPENSE
Accounting, Economics, and Finance | 1233545.04
Aerospace Studies | 50559.72
Agriculture | 599585.4299999999
Art and Music | 1225927.7
Biology | 1165519.64
Chemistry and Biochemistry | 595096.85
Communication, Mass Media & Theatre | 1256290.92
Computer Science | 513564.52
Curriculum and Instruction | 927480.14
English and Modern Languages | 1561489.33
Kinesiology | 835180.02
Management and Marketing | 1356228.3
Mathematics | 1127139.17
Mathematics and Computer Science | 34069.77
Modern Languages | 564915.46
Nursing and Rehabilitation Sciences | 2186809.77
Physical Therapy | 1025417.89
Physics | 699416.54
Political Science | 813960.9400000001
Psychology, Sociology, Social Work | 1228952.76
Teacher Education | 869748.1600000001
History | 747361.1499999999
Grand Total | 20618259.22
Spreadsheet: 63078d1264034888-insert-data-by-looking-up-and-comparing-data-to-other-sheets-example-products-brands
Sheet: Sheet1

Product | Brand | Product Type | Department
[NAME] | 0
Adidas Blank Womens Trainers
Nike Blue Womens Hoody
Nike Purple [NAME]
Product | Brand | Product Type | Department
[NAME] | Adidas | [NAME] | [NAME]
Adidas Blank Womens Trainers | Adidas | Womens Trainers | Womens [NAME]
Nike Blue Womens Hoody | Nike | Womens Hoody | Womens Clothing
Nike Purple [NAME] | Nike | [NAME] | [NAME]
Spreadsheet: 724904d1616437470-formula-needed-to-create-a-list-based-on-specific-count-test-doc
Sheet: Sheet5

 | Item | Corresponding count |  |  | Result List
 | Cat | 1 |  |  | Cat
 | Cat | 1 |  |  | Dog
 | Cat | 1 |  |  | Horse
 | Dog | 1 |  |  | Horse
 | Dog | 1 |  |  | Horse
 | Dog | 1 |  |  | Horse
 | Horse | 4 |  |  | Elephant
 | Horse | 4 |  |  | [NAME]
 | Horse | 4 |  |  | [NAME]
 | Horse | 4 |  |  | [NAME]
 | Horse | 4
 | Horse | 4
 | Horse | 4
 | Elephant | 1
 | [NAME] | 3
 | [NAME] | 3
 | [NAME] | 3
 | [NAME] | 3
 | [NAME] | 3
 | [NAME] | 3
Spreadsheet: 781126d1653004051-index-match-ignoring-blanks-index-match-ignoring-blanks
Sheet: Sheet1

 | DATASET |  |  |  |  |  |  | REPORT
 | iD | Scope 1 | Scope 2 | Scope 3 | Scope 4 | Scope 5 |  | ID | Scope | [NAME] |  | KEY
 | Asset 1 | 875000 |  |  |  |  |  | Asset 2 | Scope 2 | 700000 |  | = Expected Result
 | Asset 2 |  | 700000 |  |  |  |  | Asset 3
 | Asset 3 |  |  |  |  |  |  | Asset 4 | Scope 3 | 500000
 | Asset 4 |  |  | 500000 |  |  |  | Asset 1 | Scope 1 | 875000
 | Asset 5 |  |  |  |  |  |  | Asset 9 | Scope 3 | 900000
 | Asset 6 |  |  |  |  |  |  | Asset 10
 | Asset 7 | 800000 |  |  |  |  |  | Asset 7 | Scope 1 | 800000
 | Asset 8 |  |  |  |  |  |  | Asset 6
 | Asset 9 |  |  | 900000 |  |  |  | Asset 8
 | Asset 10 |  |  |  |  |  |  | Asset 5
Spreadsheet: 881244d1729234383-formula-indirect-address-row-is-not-working-on-other-cells-t-1-rev1
Sheet: TOTAL

 | 1 | FLP |  |  |  |  |  |  |  |  | Data: |  | 2016-01-31 00:00:00
 |  |  |  |  |  | bv
 |  |  |  |  |  | bvcb |  | ID# | 2
 |  |  |  |  |  |  | Sektori:
 |  |  |  |  |  | cbv | Nr. Personal:
 |  |  |  |  |  |  | Adresa:
 |  |  |  |  |  |  | Pagesa në bankën:
 |  |  |  |  |  |  | [NAME]:
 | 1 | 2 | 3 | 4 | 5 |  | 6 | 7 |  | 8 | 9 | 10 | 11
 | Nr. | Totali  Termineve | [NAME] Termineve | [NAME] Termineve | Totali  Kontratave |  | Çmimi Kontates | Vlera  Kontratave |  | Paga  Fikse Provizionit | Bonus | Ndalesa ose Ndëshkim | TOTALI (4+7+8+9-10=11)
 | 1
 | Informacione shtes për orët:
 | [NAME] shtes:
 | Orë & ditë  paguhen |  | Orë & ditë rreg-ullta |  |  | Pushim Sepecial |  | Pushim  Mjekësor |  |  | Fest Zyrtare |  | Pushim pa pages ose Orë & ditë humbura
 | Orë | Ditë | Orë | Ditë |  | Orë | Ditë | Orë |  | Ditë | Orë | Ditë | Orë | Ditë
 | Gjatë kesaj periudhe [NAME] realizuar keto termine
 | Nr | Nr.B | Items | Seria | No.[NAME] | Date D | Date P | Satusi | No.P
 | 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
TOTAL |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  | 1
Spreadsheet: 779129d1651595646-what-affect-has-question-1-on-question-2-is-there-a-formula-survey-analysis
Sheet: Blad1

Question 1 | Question 2 | Concat | Unique | COUNT
3 | No
5 | No | 5No | 5No
2 | No | 2No | 2No
1 | No | 1No | 1No
2 | No | 2No | 4No
3 | No | 3No | 5Yes
4 | No | 4No
2 | No | 2No
2 | No | 2No
5 | Yes | 5Yes
2 | No | 2No
3 | No | 3No
5 | No | 5No
3 | No | 3No
1 | No | 1No
2 | No | 2No
3 | No | 3No
5 | Yes | 5Yes
4 | No | 4No
Spreadsheet: 587341d1534966766-find-text-in-cell-from-list-and-return-text-from-adjacent-cell-book2
Sheet: Sheet1

Year | Month | Date | Place | Cost | Category |  |  |  |  |  | Word | category
 |  | 43242 | HARRIS TEETER #305 | -6.51 |  |  |  |  |  |  | Beach | Vacation
 |  | 43321 | HARRIS TEETER 0061 | -7.46 |  |  |  |  |  |  | Savings | Savings
 |  | 43308 | HARRIS TEETER 305 | -9.64 |  |  |  |  |  |  | Payroll | Income
 |  | 43306 | harris Teeter 323 | -10 |  |  |  |  |  |  | [NAME] | Groceries
 |  |  | Payroll From Work
Spreadsheet: 63829d1264698272-calculating-a-total-score-from-several-rows-containing-the-same-id-desmond
Sheet: Sheet1

ID | Score |  | Row Labels | Sum of Score
1234 | 5 |  | 1234 | 25
1235 | 10 |  | 1235 | 10
1236 | 15 |  | 1236 | 20
1234 | 10 |  | Grand Total | 55
1234 | 10
1236 | 5
Spreadsheet: 743451d1628515441-adjustment-of-if-formula-for-depreciation-to-accomodate-disposal-and-nondepreciating-asset-sun
Sheet: Sheet1

I'm trying to make to automate depreciation to reduce errors. Assets like land and building are not depreciated and therefore no depreciation method is selected,
Howevr when this is done, the formula on B/F Depreciation Colunm results in  FALSE and Depreciation column show FALSE.
When the Life of the asset is smaller than Period the depreciation is zero. However the B/F depreciation and Acc depreciation should be calculated.
When the asset is Disposed no depreciation is calcultaed. However B/F depreciation should be calculated so that Profit or Loss on disposal will be calculated.
 |  |  |  |  |  |  |  | depreciation column
 | Asset | Price | Year | Salvage | Life | Period | Method | 2021 | B/F Depreciation | Acc Depreciation | Disposal |  |  | SLN
 | Vehicles | 10000 | 2014 | 1000 | 6 |  | SLN |  |  |  | 0 |  |  | SYD
 | Land | 10000 | 2014 | 1000 | 10 |  |  |  |  |  | 0 |  |  | DB
 | Vehicles | 10000 | 2014 | 1000 | 10 |  | DB |  |  |  | 0 |  |  | DDB
 | Vehicles | 10000 | 2014 | 1000 | 10 |  | DDB |  |  |  | 30000 |  |  | VDB
 | Vehicles | 10000 | 2014 | 1000 | 10 |  | VDB |  |  |  | 0
 | Desired solution
 | Asset | Price | Year | Salvage | Life | Period | Method | 2021 | B/F Depreciation | Acc Depreciation | Disposal
 | Vehicles | 10000 | 2014 | 1000 | 5 |  | VDB | 0 | 7902.848 | 8322.2784 | 0
 | Land | 10000 | 2014 | 1000 | 10 |  |  | 0 | 0 |  | 0
 | Vehicles | 10000 | 2014 | 1000 | 10 |  | DB |  |  |  | 0
 | Vehicles | 10000 | 2014 | 1000 | 10 |  | DDB | 0 |  | 0 | 30000
 | Vehicles | 10000 | 2014 | 1000 | 10 |  | VDB |  |  |  | 0
Spreadsheet: daren_farmer__5525__HPLN1014
Sheet: Sheet1

HPLN1014.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - October 14, 2000
 |  |  |  |  |  | ** Sat./Sun. | ** Monday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 10/14-15/2000 | 2000-10-16 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs. | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 0  0900hrs | 0 to 0  0900hrs | 0 to 0  0900hrs
 |  |  |  |  | 0  to 0 2100hrs | 0  to 0 2100hrs | 0  to 0 2100hrs
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 810322d1671687691-week-number-week-
Sheet: Sheet1

Date | Week#
2022-11-26 00:00:00
2022-11-27 00:00:00
2022-11-28 00:00:00
2022-11-29 00:00:00
2022-11-30 00:00:00
2022-12-01 00:00:00
2022-12-02 00:00:00
2022-12-03 00:00:00
2022-12-04 00:00:00
2022-12-05 00:00:00
2022-12-06 00:00:00
2022-12-07 00:00:00
2022-12-08 00:00:00
2022-12-09 00:00:00
2022-12-10 00:00:00
2022-12-11 00:00:00
2022-12-12 00:00:00
2022-12-13 00:00:00
2022-12-14 00:00:00
2022-12-15 00:00:00
2022-12-16 00:00:00
2022-12-17 00:00:00
2022-12-18 00:00:00
2022-12-19 00:00:00
2022-12-20 00:00:00
2022-12-21 00:00:00
2022-12-22 00:00:00
2022-12-23 00:00:00
2022-12-24 00:00:00
2022-12-25 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
2022-12-31 00:00:00
2023-01-01 00:00:00
2023-01-02 00:00:00
2023-01-03 00:00:00
2023-01-04 00:00:00
2023-01-05 00:00:00
2023-01-06 00:00:00
2023-01-07 00:00:00
2023-01-08 00:00:00
2023-01-09 00:00:00
2023-01-10 00:00:00
2023-01-11 00:00:00
2023-01-12 00:00:00
2023-01-13 00:00:00
2023-01-14 00:00:00
2023-01-15 00:00:00
2023-01-16 00:00:00
2023-01-17 00:00:00
2023-01-18 00:00:00
2023-01-19 00:00:00
2023-01-20 00:00:00
2023-01-21 00:00:00
2023-01-22 00:00:00
2023-01-23 00:00:00
2023-01-24 00:00:00
2023-01-25 00:00:00
2023-01-26 00:00:00
2023-01-27 00:00:00
2023-01-28 00:00:00
2023-01-29 00:00:00
2023-01-30 00:00:00
2023-01-31 00:00:00
2023-02-01 00:00:00
2023-02-02 00:00:00
2023-02-03 00:00:00
2023-02-04 00:00:00
2023-02-05 00:00:00
2023-02-06 00:00:00
2023-02-07 00:00:00
2023-02-08 00:00:00
2023-02-09 00:00:00
2023-02-10 00:00:00
2023-02-11 00:00:00
2023-02-12 00:00:00
2023-02-13 00:00:00
2023-02-14 00:00:00
2023-02-15 00:00:00
2023-02-16 00:00:00
2023-02-17 00:00:00
2023-02-18 00:00:00
2023-02-19 00:00:00
2023-02-20 00:00:00
2023-02-21 00:00:00
2023-02-22 00:00:00
2023-02-23 00:00:00
2023-02-24 00:00:00
2023-02-25 00:00:00
2023-02-26 00:00:00
2023-02-27 00:00:00
2023-02-28 00:00:00
2023-03-01 00:00:00
2023-03-02 00:00:00
2023-03-03 00:00:00
2023-03-04 00:00:00
2023-03-05 00:00:00
2023-03-06 00:00:00
2023-03-07 00:00:00
2023-03-08 00:00:00
Spreadsheet: darron_c_giron__8010__EMW0831a
Sheet: OA Flash

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
REGION: MIDWEST
PRODUCTION MONTH:  0600
 |  |  | Original Flash
 |  |  | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash In
15 |  | Cash Out
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Demand Reimbursements
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
 |  |  | Midwest
 |  |  | [NAME]
Spreadsheet: 267373d1380056786-need-a-function-s-to-search-data-with-two-criteria-data-example
Sheet: Sheet1

[NAME] | Pipe Length
1 | 2
1 | 4 |  |  |  | A Known Pipe Size |  | Length must be the next one larger than this |  |  |  |  | Length Necessary:
1 | 6 |  |  |  | 1 |  | 4.3
1 | 8 |  |  |  | 2 |  | 2.3
1 | 10 |  |  |  | 2 |  | 3.7
2 | 1 |  |  |  | 3 |  | 4.9
2 | 3 |  |  |  | 3 |  | 7.2
2 | 4 |  |  |  | 3 |  | 7.2
2 | 5 |  |  |  | 3 |  | 8.8
3 | 7 |  |  |  | 4 |  | 0.34
3 | 8 |  |  |  | 4 |  | 0.53
3 | 9 |  |  |  | 4 |  | 1.7
3 | 10
4 | 0.5
4 | 1
4 | 1.5
4 | 2
4 | 5
5 | etc
5 | etc
5 | etc
5 | etc |  |  |  | Column A is a standard list of pipe sizes, with Column B reflecting an available length said pipe is availble in.
6 | etc
6 | etc
6 | etc |  |  |  | For a Known Pipe Size, (Column F), and a Minimum Length (Column H), I need to determine the shortest available length for the given pipe size.
6 | etc
6 | etc
Spreadsheet: 4458d17a-95da-43bc-87e2-3d24a1d21654
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (3 Entries):
 | 9 Start-up Forum 9.2 Innovation consulting
No. | Company | Country | City | [NAME] | Hall/Booth
1 | Bayern Innovativ GmbH EU-Kooperationsbüro Partner im Enterprise Europe Network | Germany | Nürnberg | 90403 | A3.251/350
2 | [NAME] | Germany | München | 80539 | A3.251/350
3 | medways [NAME] | Germany | Jena | 07745 | A3.341
Spreadsheet: 41133d1239652240-excel-worksheet-tabs-addsheets
Sheet: daylist

[NAME]
jan_2
jan_3
jan_4
jan_5
jan_6
[NAME]
jan_8
jan_9
jan_10
jan_11
[NAME]
[NAME]
jan_14
jan_15
[NAME]
jan_17
jan_18
[NAME]
jan_20
[NAME]
jan_22
jan_23
jan_24
jan_25
jan_26
[NAME]
jan_28
jan_29
jan_30
jan_31
Spreadsheet: 163744d1340439338-help-matching-data-in-sheet1-based-on-data-on-sheet2-excel-pphg-oeldere-
Sheet: Sheet2

Hotel Code | Hotel Name
ANBKK1 | Hotel A
00AN | Hotel A
ANAUH1 | Hotel A
ANMLE1 | Hotel A
00DC | Hotel B
DC | Hotel B
LONDON | Hotel B
WDC | Hotel B
00FH | Hotel C
DKAALAAL | Hotel C
NOSTAALS | Hotel C
SESTOAMA | Hotel C
[NAME] | Hotel C
AX1ABPLAT | Hotel C
AX1ACPLAT | Hotel C
AX1ADPLAT | Hotel C
Spreadsheet: d1557ad9-baaf-43fe-9c1f-0dc70353b581
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
8215 | 57071 | [NAME] | [NAME] | NED | 102 | 0:47:04 | 0:01:44 | 5:16:44 | 0:02:27 | 2:55:47 | 1 | 9:03:48
8215 | 64268 | Lindsey | [NAME] | USA | 101 | 0:45:53 | 0:01:48 | 6:12:24 | 0:02:56 | 3:29:32 | 2 | [NAME]
Spreadsheet: 49967d1249392383-count-and-total-the-unknown-matching-data-occurences-across-multi-worksheets-dummy
Sheet: Stat

 | total names occurences |  |  |  |  |  |  |  |  |  |  |  |  |  | total number occurences
 | jan | feb | [NAME] | apr | may | jun | jul | aug | sep | oct | nov | dec |  |  | jan | feb | [NAME] | apr | may | jun | jul | aug | sep | oct | nov | dec
cat |  |  |  |  |  |  |  |  |  |  |  |  |  | 101
dog |  |  |  |  |  |  |  |  |  |  |  |  |  | 102
etc |  |  |  |  |  |  |  |  |  |  |  |  |  | etc
etc |  |  |  |  |  |  |  |  |  |  |  |  |  | etc
etc |  |  |  |  |  |  |  |  |  |  |  |  |  | etc
etc |  |  |  |  |  |  |  |  |  |  |  |  |  | etc
etc |  |  |  |  |  |  |  |  |  |  |  |  |  | etc
Spreadsheet: 763103d1641995553-consecutive-dates-to-from-and-to-sickness-report
Sheet: Sheet1

RAW DATA |  |  |  |  |  | Expected Data
Name | Shift | Date |  |  |  | Name | From | To
AAB | Sick | 2021-12-09 00:00:00 |  | 1 |  | AAB | 2021-12-09 00:00:00 | 2021-12-12 00:00:00
AAB | OffDay | 2021-12-10 00:00:00 |  |  |  | AAB | 2021-12-16 00:00:00 | 2021-12-21 00:00:00
AAB | OffDay | 2021-12-11 00:00:00 |  |  |  | AP | 2021-12-29 00:00:00 | 2021-12-29 00:00:00
AAB | Sick | 2021-12-12 00:00:00 |  |  |  | AP | 2021-12-15 00:00:00 | 2021-12-15 00:00:00
AAB | Sick | 2021-12-16 00:00:00 |  |  |  | AR | 2021-12-16 00:00:00 | 2021-12-18 00:00:00
AAB | Sick | 2021-12-17 00:00:00 |  |  |  | AR | 2021-12-20 00:00:00 | 2021-12-21 00:00:00
AAB | Sick | 2021-12-18 00:00:00 |  |  |  | AR | 2021-12-23 00:00:00 | 2021-12-23 00:00:00
AAB | Sick | 2021-12-19 00:00:00 |  |  |  | AR | 2021-12-25 00:00:00 | 2021-12-25 00:00:00
AAB | Sick | 2021-12-20 00:00:00 |  |  |  | AF | 2021-12-18 00:00:00 | 2021-12-24 00:00:00
AAB | Sick | 2021-12-21 00:00:00 |  |  |  | AS | 2021-12-08 00:00:00 | 2021-12-11 00:00:00
AP | Sick | 2021-12-29 00:00:00 |  |  |  | AS | 2021-12-26 00:00:00 | 2021-12-26 00:00:00
AP | Sick | 2021-12-15 00:00:00 |  |  |  | AS | 2021-12-28 00:00:00 | 2021-12-28 00:00:00
AR | Sick | 2021-12-16 00:00:00 |  |  |  | AS | 2021-12-12 00:00:00 | 2021-12-12 00:00:00
AR | OffDay | 2021-12-17 00:00:00
AR | Sick | 2021-12-18 00:00:00
AR | Sick | 2021-12-20 00:00:00
AR | Sick | 2021-12-21 00:00:00
AR | Sick | 2021-12-23 00:00:00
AR | Sick | 2021-12-25 00:00:00
AF | Sick | 2021-12-18 00:00:00
AF | Sick | 2021-12-19 00:00:00
AF | Sick | 2021-12-20 00:00:00
AF | Sick | 2021-12-21 00:00:00
AF | Sick | 2021-12-22 00:00:00
AF | Sick | 2021-12-23 00:00:00
AF | Sick | 2021-12-24 00:00:00
AS | Sick | 2021-12-08 00:00:00
AS | Sick | 2021-12-09 00:00:00
AS | OffDay | 2021-12-10 00:00:00
AS | Sick | 2021-12-11 00:00:00
AS | Sick | 2021-12-26 00:00:00
AS | Sick | 2021-12-28 00:00:00
AS | Sick | 2021-12-12 00:00:00
Spreadsheet: 109541d1306368767-index-match-newassist-ss-sample-w-dsum
Sheet: Summary

 |  |  |  |  | OI CY BLC |  |  |  |  |  | [NAME]
 |  |  |  |  | BSS |  | CT |  | BP |  | BSS |  | CT |  | BP
 |  |  | Orange | Assist | CY | PY | CY | PY | CY | PY | CY | PY | CY | PY | CY | PY
 |  | North America |  | Total
 |  |  |  | Win
 |  |  |  | Loss
 |  |  |  | CA
 |  |  |  | Qual
 |  |  | NA-US | Total
 |  |  | NA-US | Win
 |  |  | NA-US | Loss
 |  |  | NA-US | CA
 |  |  | NA-US | Qual
 |  |  | NA-CA | Total
 |  |  | NA-CA | Win
 |  |  | NA-CA | Loss
 |  |  | NA-CA | CA
 |  |  | NA-CA | Qual
 |  |  | NE-ALP | Total
 |  |  | NE-ALP | Win
 |  |  | NE-ALP | Loss
 |  |  | NE-ALP | CA
 |  |  | NE-ALP | Qual
 |  |  | NE-GER | Total
 |  |  | NE-GER | Win
 |  |  | NE-GER | Loss
 |  |  | NE-GER | CA
 |  |  | NE-GER | Qual
 |  |  | NE-NOR | Total
 |  |  | NE-NOR | Win
 |  |  | NE-NOR | Loss
 |  |  | NE-NOR | CA
 |  |  | NE-NOR | Qual
 |  |  | SW-ITL | Total
 |  |  | SW-ITL | Win
 |  |  | SW-ITL | Loss
 |  |  | SW-ITL | CA
 |  |  | SW-ITL | Qual
 |  |  | SW-FRA | Total
 |  |  | SW-FRA | Win
 |  |  | SW-FRA | Loss
 |  |  | SW-FRA | CA
 |  |  | SW-FRA | Qual
 |  |  | GMU-GCG | Total
 |  |  | GMU-GCG | Win
 |  |  | GMU-GCG | Loss
 |  |  | GMU-GCG | CA
 |  |  | GMU-GCG | Qual
 |  |  | GMU-A/NZ | Total
 |  |  | GMU-A/NZ | Win
 |  |  | GMU-A/NZ | Loss
 |  |  | GMU-A/NZ | CA
 |  |  | GMU-A/NZ | Qual
 |  |  | GMU-CEE
 |  |  | GMU-ASE