tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 190550d1351693274-link-the-background-color-to-background-color-of-another-cell-holidaysheet_template
Sheet: Q2

Apr
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
Alton
Dries
[NAME]
Stijn
Sven
[NAME]
May
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
Alton
Dries
[NAME]
Stijn
Sven
[NAME]
Jun
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
Alton
Dries
[NAME]
Stijn
Sven
[NAME]
Spreadsheet: john_griffith__15762__10_17_01OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 62 | 300 | 400 | 38.6 | 51.5 | 1.76 | 2001-10-17 14:57:00
 | HO Z1 | 63 | 780 | 860 | 46.5 | 51.3 | 1.94 | 2001-10-17 14:57:00
 | HO F2 | 64 | 1075 | 1175 | 48.5 | 53 | 2.04 | 2001-10-17 14:57:00
 | HO G2 | 63 | 1310 | 1335 | 49.7 | 50.7 | 1.99 | 2001-10-17 14:57:00
 | [NAME] | 63 | 1270 | 1370 | 42.9 | 46.3 | 1.77 | 2001-10-17 14:57:00
 | HO J2 | 62 | 1250 | 1350 | 39.1 | 42.2 | 1.58 | 2001-10-17 14:57:00
 | HO K2 | 61 | 1225 | 1350 | 35.8 | 39.4 | 1.44 | 2001-10-17 14:57:00
 | HO M2 | 61 | 1200 | 1350 | 32.4 | 36.5 | 1.32 | 2001-10-17 14:57:00
 | HO N2 | 61 | 1250 | 1400 | 31.9 | 35.8 | 1.3 | 2001-10-17 14:57:00
 | HO Q2 | 62 | 1250 | 1450 | 29.8 | 34.6 | 1.26 | 2001-10-17 14:57:00
 | HO U2 |  | \ |  | 28.8 | 34.4 | 1.25 | 2001-10-12 14:53:00
 | [NAME] |  |  |  | 24.3 | 26.8 | 1.08 | 2001-08-20 15:41:00
 | HO X2
 | [NAME]
 | HO F3 |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | [NAME]
Spreadsheet: 741600d1627192472-how-to-search-a-table-and-produce-results-from-left-and-right-cells-book1
Sheet: Sheet1

 |  |  | AFC Bournemouth | West Bromwich Albion
 |  |  |  |  |  |  |  |  | AFC Bournemouth
 |  |  |  |  |  |  |  |  | Barnsley
 |  | Date | Home Team | Away Team | Result |  |  |  | Birmingham City
 |  | 2021-08-11 00:00:00 | AFC Bournemouth | West Bromwich Albion | 3 | 2 |  |  | [NAME]
 |  | 2021-08-12 00:00:00 | [NAME] | Swansea City | 1 | 0 |  |  | Blackpool
 |  | 2021-09-03 00:00:00 | Bristol City | Blackpool | 1 | 2 |  |  | Bristol City
 |  | 2021-09-03 00:00:00 | Cardiff City | Barnsley | 1 | 1 |  |  | Cardiff City
 |  | 2021-09-10 00:00:00 | Derby County | Huddersfield Town | 2 | 0 |  |  | Coventry City
 |  | 2021-10-12 00:00:00 | [NAME] | Peterborough United | 0 | 1 |  |  | Derby County
 |  | 2021-10-12 00:00:00 | [NAME] | Hull City | 3 | 1 |  |  | Fulham
 |  | 2021-10-17 00:00:00 | Queens Park Rangers | Millwall | 1 | 2 |  |  | Huddersfield Town
 |  | 2021-10-18 00:00:00 | Sheffield United | Birmingham City | 2 | 0 |  |  | Hull City
 |  | 2021-11-02 00:00:00 | Stoke City | Reading | 1 | 1 |  |  | [NAME]
 |  | 2021-11-03 00:00:00 | Coventry City | [NAME] | 1 | 1 |  |  | Middlesbrough
 |  | 2021-11-03 00:00:00 | Fulham | Middlesbrough | 0 | 2 |  |  | Millwall
 |  | 2021-11-04 00:00:00 | Barnsley | Coventry City | 1 | 0 |  |  | [NAME]
 |  | 2021-11-11 00:00:00 | Birmingham City | Stoke City | 2 | 1 |  |  | Peterborough United
 |  | 2021-11-12 00:00:00 | Blackpool | Cardiff City | 1 | 1 |  |  | [NAME]
 |  | 2021-11-19 00:00:00 | Huddersfield Town | Fulham | 0 | 2 |  |  | Queens Park Rangers
 |  | 2021-11-20 00:00:00 | Hull City | Queens Park Rangers | 1 | 2 |  |  | Reading
 |  | 2021-11-27 00:00:00 | Middlesbrough | Bristol City | 2 | 1 |  |  | Sheffield United
 |  | 2021-11-28 00:00:00 | Millwall | [NAME] | 1 | 0 |  |  | Stoke City
 |  | 2021-11-28 00:00:00 | [NAME] | AFC Bournemouth | 2 | 0 |  |  | Swansea City
 |  |  |  |  |  |  |  |  | West Bromwich Albion
Spreadsheet: 329853d1404421550-help-with-looking-up-the-value-sample-data
Sheet: Sheet6

 |  |  |  | June
 |  |  |  |  | Stats
 |  |  |  |  | Fouls | Points | Free Throw | Best Stat | What is it?
 |  |  | Name | [NAME] | 2 | 30 | 10 |  | ??
 |  |  |  | [NAME] | 4 | 23 | 4 |  | ??
 |  |  |  | [NAME] | 3 | 14 | 14 |  | ??
 |  |  |  | Corrie | 0 | 50 | 4 |  | ??
Spreadsheet: 91003d1290685242-vlookup-with-multiple-values-tooling
Sheet: Tooling

 | Area | Machine | Description | Equipment | Location | Notes
AM054F | PATT SHOP | [NAME] | CORESETTER | AM054.02 | Z3
AM054F | PATT SHOP | [NAME] | RAM PLATE | AM054.02 | A3
AM054F | PATT SHOP | [NAME] | SWING PLATE | AM054.02 | A3
AM054F | CORE SHOP | HANSBERG | UCB VANE INSERT | AM054B
AM054F | CORE SHOP | HANSBERG | LCB VANE INSERT | AM054B
AM054F | CORE SHOP | HANSBERG | BLOW TUBE | 3GB1
AM054F | PATT SHOP | [NAME] | SWING PL. INSERT | AM054B |  | NO INSERTS FOUND
AM054F | PATT SHOP | [NAME] | ADAPTOR SET  R/S | T305
AM054F | PATT SHOP | [NAME] | ADAPTOR CSETTER | T295
AM054F | FETT SHOP | AUTO FETT | AUTOFETT JIG | JIG 1
AM054F | FETT SHOP | AUTO FETT | AUTOFETT CLAMP | CLAMP 4
AM054F | FETT SHOP | AUTO FETT | AUTOFETT LOADER | LOADER 150
AM054F | FETT SHOP | AUTO FETT | AUTOFETT GAUGE | GAUGE 4
AM054F | CORE SHOP | HANSBERG 7 | BLOW TUBE | BT03
AM054F | CORE SHOP | HANSBERG | LCB CENT. INSERT | AM054B
Spreadsheet: 31070d1226808185-average-of-a-coloumn-of-values-based-on-a-critera-for-each-value-on-that-values-row-war-game-example
Sheet: Attacks

 |  |  |  | [NAME] |  |  |  |  |  |  | Attacker Losses
 |  |  |  | Cash | Tanks | Troops | Jets | Turrets | Ships |  | Tanks | Troops | Jets | Ships | Land Conquered | Troops Stationed | Successful | Unsuccessful |  |  | Condition Caches
 | Totals: |  |  | 481485 | 213 | 1167 | 1123 | 836 | 679 |  | 3836 | 7858 | 3936 | 1195 | 287 | 1813 | 4 | 1 |  |  | >0
 | Most Per Individual Attack: |  |  | 180249 | 113 | 543 | 356 | 748 | 344 |  | 1961 | 2427 | 1232 | 326 | 114 | 709
 | Average Per Attack Attempt: |  |  | 96297 | 42.6 | 233.4 | 224.6 | 209 | 135.8 |  | 767.2 | 1571.6 | 787.2 | 239 | 57.4 | 362.6
 | Average Per Successful Attack:
 |  |  |  | [NAME] |  |  |  |  |  |  | Attacker Losses
 | Attack # | ID # | [NAME] | Cash | Tanks | Troops | Jets | Turrets | Ships |  | Tanks | Troops | Jets | Ships | Land Conquered | Troops Stationed | Successful | Unsuccessful
 | 1 | 1 | Nation 1 | 12345 | 98 | 99 | 89 | 88 | 36 |  | 242 | 1483 | 684 | 221 | 114 | 709 | 1 | 0
 | 2 | 2 | Nation 2 | 54321 | 2 | 4 | 1 | 0 | 0 |  | 0 | 0 | 6 | 6 | 62 | 401 | 1 | 0
 | 3 | 3 | Nation 3 | 96297 | 0 | 406 | 356 | 0 | 107 |  | 1429 | 1926 | 994 | 324 | 0 | 0 | 0 | 1
 | 4 | 4 | Nation 4 | 138273 | 0 | 115 | 349 |  | 344 |  | 204 | 2022 | 1020 | 318 | 52 | 330 | 1 | 0
 | 5 | 5 | Nation 5 | 180249 | 113 | 543 | 328 | 748 | 192 |  | 1961 | 2427 | 1232 | 326 | 59 | 373 | 1 | 0
Spreadsheet: 68062d1268628350-index-match-with-and-morse
Sheet: Sheet1

alpha | .- |  |  | 0 | -----
[NAME] | -… |  |  | 1 | .----
[NAME] | -.-. |  |  | 2 | ..---
delta | -.. |  |  | 3 | …--
echo | . |  |  | 4 | ….-
foxtrot | ..-. |  |  | 5 | …..
golf | --. |  |  | 6 | -….
hotel | …. |  |  | 7 | --…
india | .. |  |  | 8 | ---..
[NAME] | .--- |  |  | 9 | ----.
kilo | -.- |  |  | , | --..--
lima | .-.. |  |  | . | .-.-.-
[NAME] | -- |  |  | / | -..-.
november | -. |  |  | ? | ..--..
oscar | --- |  |  | @ | .--.-.
papa | .--.
quebec | --.-
romeo | .-.
sierra | …
[NAME] | -
uniform | ..-
victor | …-
whiskey | .--
xray | -..-
yankee | -.--
zulu | --..
Spreadsheet: 695346d1600167258-sorting-data-that-only-has-value-greater-than-1-times-etaf-1-
Sheet: People

Must remain BLANK
Tesco | 0
Aldi | 1(00:07:55)
Lidl | 2(00:01:55)
Morrisons | 3(00:05:55)
Sainsburys | 0
Pc World | 0
[NAME] | 0
The Range | 0
Sofa World | 2(00:07:03)
T K Maxx | 0
Burger King | 3(00:09:40)
Mc Donalds | 0
Tasty Land | 0
Currys | 0
Carphone Warehouse | 0
[NAME] | 0
[NAME] | 0
Maplins | 0
[NAME] | 0
This column shows the store | This colum shows how many customers are currently delayed and the longest waiting
Spreadsheet: 5176801d-66fc-4651-9819-43a8ab4e0698
Sheet: Sheet1

2010 official [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
State of North Dakota Results
Precincts Reporting: 505/505 - Total Ballots Cast: 102066
Downloaded at 6/18/2013 10:49:38 PM
 | Sonja  Clapp  - NON | write-in  - NON
Judge of the District Court No. 1 - NON | 6469 | 18
TOTAL | 6469 | 18
Write-In | Votes
[NAME] | 0
Sara  Cannon | 1
TOTAL | 1
 | [NAME] A [NAME]  - NON | write-in  - NON
Judge of the District Court No. 1 - NON | 12198 | 41
TOTAL | 12198 | 41
Write-In | Votes
Cal  Cluchie | 1
TOTAL | 1
 | [NAME] | [NAME] | write-in  - NON
Judge of the District Court No. 1 - NON | 4610 | 4018 | 18
TOTAL | 4610 | 4018 | 18
 | [NAME] | write-in  - NON
Judge of the District Court No. 2 - NON | 13434 | 35
TOTAL | 13434 | 35
 | [NAME] | write-in  - NON
Judge of the District Court No. 2 - NON | 18831 | 86
TOTAL | 18831 | 86
Write-In | Votes
DAN  HERBEL | 1
[NAME] | 2
TOTAL | 3
 | [NAME] T ([NAME]) Paulson  - NON | [NAME] | write-in  - NON
Judge of the District Court No. 2 - NON | 9466 | 3725 | 15
TOTAL | 9466 | 3725 | 15
 | [NAME]  - NON | write-in  - NON
Judge of the District Court No. 3 - NON | 13479 | 26
TOTAL | 13479 | 26
 | Joel D Medd  - NON | write-in  - NON
Judge of the District Court No. 3 - NON | 6448 | 17
TOTAL | 6448 | 17
Write-In | Votes
[NAME] | 1
[NAME] | 1
[NAME] | 1
TOTAL | 3
 | [NAME] | write-in  - NON
Judge of the District Court No. 4 - NON | 13520 | 31
TOTAL | 13520 | 31
 | [NAME] | write-in  - NON
Judge of the District Court No. 4 - NON | 8647 | 42
TOTAL | 8647 | 42
 | [NAME] | write-in  - NON
Judge of the District Court No. 4 - NON | 10435 | 149
TOTAL | 10435 | 149
Write-In | Votes
[NAME] | 1
[NAME] | 2
M  Greenwood | 2
[NAME] | 3
[NAME] | 2
TOTAL | 10
 | [NAME] | write-in  - NON
Judge of the District Court No. 4 - NON | 7854 | 23
TOTAL | 7854 | 23
 | [NAME] | write-in  - NON
Judge of the District Court No. 5 - NON | 11690 | 41
TOTAL | 11690 | 41
Write-In | Votes
[NAME] | 1
[NAME] | 1
[NAME] | 1
Lyn  [NAME] | 1
[NAME] | 3
[NAME] | 3
Stuart  Askew | 2
TOTAL | 12
 | [NAME] | Parrell  [NAME] | Todd A Schwarz  - NON | [NAME]  [NAME]  - NON | write-in  - NON
Judge of the District Court No. 5 - NON | 9312 | 5271 | 3331 | 3292 | 27
TOTAL | 9312 | 5271 | 3331 | 3292 | 27
Write-In | Votes
JIM   VUKELIC | 2
[NAME] | 1
TOTAL | 3
 | [NAME] | write-in  - NON
Judge of the District Court No. 5 - NON | 11999 | 50
TOTAL | 11999 | 50
 | [NAME] | [NAME] | write-in  - NON
Judge of the District Court No. 6 - NON | 7021 | 5113 | 9
TOTAL | 7021 | 5113 | 9
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 834374d1687775406-horse-racing-bookie-account-balances-horse-racing-balances
Sheet: Balances

Bookie | Opening Balance | Current Balance
Ladbrokes | 500 | Sum of the opening balance plus the win amount OR loss amount in the tab named 'Bets' for the bookie named Ladbrokes | Total in column c should be 480
Tote | 100 | Sum of the opening balance plus the win amount OR loss amount in the tab named 'Bets' for the bookie named Tote | 320
SkyBet | 200 | Sum of the opening balance plus the win amount OR loss amount in the tab named 'Bets' | 320
Paddy Power | 100 | Sum of the opening balance plus the win amount OR loss amount in the tab named 'Bets' | 80
[NAME] | 100 | Sum of the opening balance plus the win amount OR loss amount in the tab named 'Bets'
Bet 365 | 100 | Sum of the opening balance plus the win amount OR loss amount in the tab named 'Bets'
BetFred | 100 | Sum of the opening balance plus the win amount OR loss amount in the tab named 'Bets'
Bet UK | 100 | Sum of the opening balance plus the win amount OR loss amount in the tab named 'Bets'
BetFair | 100 | Sum of the opening balance plus the win amount OR loss amount in the tab named 'Bets'
Bank | 500 | Sum of the opening balance plus the win amount OR loss amount in the tab named 'Bets'
Spreadsheet: 466801d1466448770-report-formula-query-profitability-may-2016
Sheet: February 2016

 | February 2016 Projects Profitability
 | Project | Value based on Cost Values | Value Based on Chargeability Values | Invoiced | Profitability % | Overservicing %
1
 | Project | Value based on Cost Values | Value Based on Chargeability Values | Invoiced | Profitability % CH | Overservicing %
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
Spreadsheet: 02f20174-5b4f-42e3-a7ae-e2d04b749e2c
Sheet: Sheet1

Area | 09:00:00 | 10:00:00 | 11:00:00 | 02:00:00 | 03:00:00 | 04:00:00
Waterfront | Canoeing |  | Inst. Swim | Acvtivity
 | Inst. Swim | Lifesaving
 | Inst. Swim | Small Boat Sailing
 | Swimming |  | Inst. Swim
COPE/Climbing | Cope I |  |  | Cope II
 | Climbing I |  |  |  | Climbing II
Field Sports | Cycling (Mountain Bike Option) |  |  | Excursions
 | Personal Fitness | Athletics | Fishing | Activity
Handicraft | Painting | Leatherwork | Sculpture
 | Woodwork | Woodcarving | Woodwork
Nature | Environmental Science |  | Forestry
 | Bird Study | Weather | Plant Science
Scoutcraft | Geocaching | Wilderness Survival | Wilderness Survival
 | Camping | Camping | Orienteering
 | Pioneering |  | Cooking (Over Lunch)
Shooting Sports | Rifle | Rifle | Shotgun
 | Archery | Archery | Archery
Blackcap | Full Day Program (Offering Nature or Indian Lore merit badge)
Ranger | Welding
 | Home Repairs
Chaplain |  |  | God and Life | God and Life Monday only
Health Officer | First Aid
Spreadsheet: 869351d1715927158-countif-is-not-counting-correctly-countif
Sheet: Sheet1

Date | DUTY IN | DUTY OUT | Shift
2024-04-01 00:00:00 | 07:00:00 | 15:00:00 | 08:00:00
2024-04-02 00:00:00 | 07:00:00 | 15:00:00 | 08:00:00
2024-04-03 00:00:00 | 11:00:00 | 19:00:00 | 08:00:00
2024-04-04 00:00:00 | 07:00:00 | 15:00:00 | 08:00:00
2024-04-13 00:00:00 | 11:00:00 | 19:00:00 | 08:00:00
2024-04-14 00:00:00 | 11:00:00 | 19:00:00 | 08:00:00
2024-04-15 00:00:00 | 07:00:00 | 15:00:00 | 08:00:00
2024-04-17 00:00:00 | 07:00:00 | 15:00:00 | 08:00:00
2024-04-18 00:00:00 | 07:00:00 | 15:00:00 | 08:00:00
2024-04-19 00:00:00 | 07:00:00 | 15:00:00 | 08:00:00
2024-04-20 00:00:00 | 07:00:00 | 15:00:00 | 08:00:00
2024-04-22 00:00:00 | 11:00:00 | 19:00:00 | 08:00:00
2024-04-24 00:00:00 | 07:00:00 | 15:00:00 | 08:00:00
2024-04-26 00:00:00 | 11:00:00 | 19:00:00 | 08:00:00
 |  |  |  | supposed to be 14
 |  |  |  | the highlighted is getting excluded
Spreadsheet: 852398d1702462343-start-end-date-need-to-automaticcly-colour-in-project-planning-hulpvraag-blad
Sheet: Planning.1

 |  |  |  |  |  |  |  | 2024-01-01 00:00:00
Werkzaamheden | Werknemers | Werknummer | Start Date |  | End Date |  |  | m | d | w | d | v | z | z | m | d | w | d | v | z | z | m | d | w | d | v | z | z | m | d | w | d | v | z | z | m | d | w | d | v | z | z | m | d | w | d | v | z | z | m | d | w | d | v | z | z | m | d | w | d | v | z | z | m | d | w | d | v | z | z | m | d | w | d | v | z | z | m | d | w | d | v | z | z | m | d | w | d | v | z | z | m | d | w | d | v | z | z | m | d | w | d | v | z | z | m | d | w | d | v | z | z | m | d | w | d | v | z | z | m | d | w | d | v | z | z | m | d | w | d | v | z | z | m | d | w | d | v | z | z | m | d | w | d | v | z | z | m | d | w | d | v | z | z | m | d | w | d | v | z | z | m | d | w | d | v | z | z | m | d | w | d | v | z | z | m | d | w | d | v | z | z
 |  |  | 2024-01-01 00:00:00 |  | 2024-01-08 00:00:00
Spreadsheet: 567476ad-d8a8-43d6-ab4e-3b4d837cfc87
Sheet: Sheet1

 | SEALY CORPORATE SUPPLY CHAIN
[NAME] | Vice President of Sourcing & Supply | [PHONE] | [EMAIL]
 | STRATEGIC SOURCING TEAM
[NAME] | Corporate Sourcing Manager | [PHONE] | [EMAIL]
[NAME] | Strategic Sourcing Specialist-Foams and [NAME] Products | [PHONE] | [EMAIL]
[NAME] | Strategic Sourcing Specialist-Textiles and Printing | [PHONE] | [EMAIL]
Emily Averill | Strategic Sourcing Specialist-Metals and Components | [PHONE] | [EMAIL]
[NAME] | Strategic Sourcing Specialist-Fiber Based Products and Lumber | [PHONE] | [EMAIL]
[NAME] | Supplier Development Engineer | [PHONE] | [EMAIL]
 | NEW PRODUCT AND MATERIALS PLANNING TEAM
[NAME] | Director of Supply Chain | [PHONE] | [EMAIL]
[NAME] | Supply Chain Planning Manager | [PHONE] | [EMAIL]
[NAME] | Planning and Logistics Manager-Components Division | [PHONE] | [EMAIL]
[NAME] | Project Sourcing Specialist | [PHONE] | [EMAIL]
[NAME] | Project Sourcing Specialist | [PHONE] | [EMAIL]
[NAME] | Supply Chain Coordinator | [PHONE] | [EMAIL]
 | TRANSPORTATION AND [NAME]
[NAME] | Director of Corporate Logistics | [PHONE] | [EMAIL]
[NAME] | Corporate Logistics Manager | [PHONE] | [EMAIL]
[NAME] | Regional Logistics  Manager-East Region | [PHONE] | [EMAIL]
[NAME] | Regional Logistics Manager-West Region | [PHONE] | [EMAIL]
[NAME] | Regional Backhaul Coordinator-East Region Support | [PHONE] | [EMAIL]
[NAME] | Regional Backhaul Coordinator-West Region Support | [PHONE] | [EMAIL]
Spreadsheet: 453819d1459453590-take-oldest-date-based-on-name-yrs-and-months
Sheet: Sheet1

 |  | Results
[NAME], [NAME] | 2016-03-01 00:00:00
[NAME], [NAME] | 2016-02-01 00:00:00
[NAME], [NAME] | 2015-12-01 00:00:00
[NAME], [NAME] | 2015-01-01 00:00:00
Doe, [NAME] | 2015-04-01 00:00:00
Doe, [NAME] | 2014-09-01 00:00:00
[NAME], [NAME] | 2014-09-01 00:00:00
[NAME], [NAME] | 2014-06-01 00:00:00
Bunyon, [NAME] | 2014-05-01 00:00:00
Bunyon, [NAME] | 2013-02-01 00:00:00
Spreadsheet: 752592d1634841379-circular-reference-issue-copy-of-excel-employee-vacation-sheet-2021-prototype
Sheet: Jan 2022

Formation /Training
Congés / Leaves | V
Congés fériés / GC holidays
Fin de semaine / Weekend
T:  Tentative A; Approved
Compressed Day Off
Assignment / Left
Half Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
January | Dates of leave |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022
01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Vacation
Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | Replaced by:
January Total
Spreadsheet: 274398d1383105494-need-help-conditional-formatting-border-line-with-skip-blank-data-conditional-formatting-problem
Sheet: Sheet1

 | SAMPLE RAW DATA
1 | Afriadi | 9853870 | 9853870 | SPBBS | - | HGB Nomor 1147 a/n. ALAMSYAH.
2 | Akhmad Isnanto | 9054490 | 9054490 | SPBBS | 1. | SHGB No. 5253 tgl. 06-09-1999 an. [NAME]
 |  |  |  |  | 2. | IMB No. 94 tgl. 30-10-1996
 |  |  |  |  | 3. | AJB No. 501/SH/1998 tgl. 08-09-1998 an. [NAME]
 |  |  |  |  | 4. | SKMHT No. 8
3 | [NAME] | 49680759 | 49680759 | SPPBS | - | HGB Nomor 1147 a/n. ALAMSYAH.
4 | [NAME] | 7953810 | 7953810 | Lelang | 1. | SHGB No. 5083 tgl. 19-03-1999 an. [NAME]
 |  |  |  |  | 2. | IMB No. 94 tgl. 30-10-1996
 |  |  |  |  | 3. | AJB No. 41 tgl. 12-01-1998
 |  |  |  |  | 4. | SKMHT No. 37 tgl. 12-02-1998
5 | [NAME] | 15836750 | 14927659 | [NAME] | - | -
 | AFTER FORMULA
1 | Afriadi | 9853870 | 9853870 | SPBBS | - | HGB Nomor 1147 a/n. ALAMSYAH.
2 | Akhmad Isnanto | 9054490 | 9054490 | SPBBS | 1. | SHGB No. 5253 tgl. 06-09-1999 an. [NAME]
 |  |  |  |  | 2. | IMB No. 94 tgl. 30-10-1996
 |  |  |  |  | 3. | AJB No. 501/SH/1998 tgl. 08-09-1998 an. [NAME]
 |  |  |  |  | 4. | SKMHT No. 8
3 | [NAME] | 49680759 | 49680759 | SPPBS | - | HGB Nomor 1147 a/n. ALAMSYAH.
4 | [NAME] | 7953810 | 7953810 | Lelang | 1. | SHGB No. 5083 tgl. 19-03-1999 an. [NAME]
 |  |  |  |  | 2. | IMB No. 94 tgl. 30-10-1996
 |  |  |  |  | 3. | AJB No. 41 tgl. 12-01-1998
 |  |  |  |  | 4. | SKMHT No. 37 tgl. 12-02-1998
5 | [NAME] | 15836750 | 14927659 | [NAME] | - | -
Spreadsheet: 736530d1623699634-multi-column-lookup-for-output-of-cell-value-lookup-example
Sheet: sample

 | OD | thickness | OUTPUTS
 | 0 | 0
 | 1 | 0 |  |  | input OD | input thickness | OUTPUT
 | 1 | 0.1 |  |  | 0.75 | 0.42 | 0.00x.400
 | 1 | 0.2 |  |  | 1 | 0.01 | 1.00x.000
 | 1 | 0.3 |  |  | 2.5 | 0.25 | 2.00X.200
 | 1.25 | 0 |  |  | 3.95 | 0.125 | 2.00x.100
 | 1.25 | 0.1 |  |  | 3.45 | 0.245 | 2.00x.200
 | 1.25 | 0.2 |  |  | 5 | 0.32 | 4.00x.300
 | 1.25 | 0.3 |  |  | 6.13 | 0.42 | 6.00x.400
 | 1.5 | 0 |  |  | 9 | 0.265 | 6.00x.200
 | 1.5 | 0.1 |  |  | 9 | 0.42 | 6.00x.400
 | 1.5 | 0.2
 | 1.5 | 0.3 |  |  | output is always format 0.00 x .000
 | 1.75 | 0 |  |  | no preceeding 0
 | 1.75 | 0.1
 | 1.75 | 0.2
 | 1.75 | 0.3
 | 2 | 0
 | 2 | 0.1
 | 2 | 0.2
 | 2 | 0.3
 | 2 | 0.4
 | 4 | 0
 | 4 | 0.1
 | 4 | 0.2
 | 4 | 0.3
 | 4 | 0.4
 | 6 | 0
 | 6 | 0.1
 | 6 | 0.2
 | 6 | 0.3
 | 6 | 0.4
Spreadsheet: 879723d1727274245-need-help-returning-data-when-cell-matches-column-headers-newtonus_prime-notes-ks-365-aligw
Sheet: SEPT 2024

ACCT | Due to Pre-Press | Due to Prod | Ship Date | Due In-Store | Promo | Notes
G G P M | 0-Jan | 0-Jan | 0-Jan | 0-Jan | 0-Jan
S U N O   C A L S | 0-Jan | 0-Jan | 0-Jan | 0-Jan | 0-Jan
T O F A | 2024-07-29 00:00:00 | 2024-09-04 00:00:00 | 2024-09-18 00:00:00 | 2024-09-25 00:00:00 | 2024-10-01 00:00:00
R A C T | 0-Jan | 0-Jan | 0-Jan | 0-Jan | 0-Jan
BASS | 0-Jan | 0-Jan | 0-Jan | 0-Jan | 0-Jan
HHGJ [NAME] | 0-Jan | 0-Jan | 0-Jan | 0-Jan | 0-Jan
HHGJ TMOB | 0-Jan | 0-Jan | 0-Jan | 0-Jan | 0-Jan
KNST | 0-Jan | 0-Jan | 0-Jan | 0-Jan | 0-Jan
Spreadsheet: 108177d1305232288-worksheet-text-consolidation-invitee-list-sample-day92
Sheet: Full List

Last Name | First Name | Title (VP,SVP, DIR, MGR) | Functional Area | Location City | Location State
[NAME] |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  | [NAME]
Nicholson |  |  |  |  |  |  |  | [NAME]
Stanton
McDaniel
Manning
[NAME]
Cardin
Lincoln
[NAME]
Estabrook
[NAME]
Suerth
[NAME]
Bates
Heberlein
Reese
Nice
Szczech
Branz
Sicinski
Dale
Enloe
Sirisky
[NAME]
Tran
Schmiedel
Yaniro
Tsalyuk
Nikiforova
Terrell
[NAME]
Chavis
[NAME]
Walker
Spreadsheet: 298089d1392705031-ranking-based-on-criteria-category-20scores-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | count
 |  | Category Scores |  |  |  |  |  |  | Scale
 | Name | A | B | C | D | TOTAL | rank |  | 3 | Best | 0
 | [NAME] | 10 | 12 | 9 | 11 |  |  |  | 2 | Average
 | Mark | 12 | 14 | 4 | 13 |  |  |  | 1 | Worst
 | [NAME] | 13 | 18 | 5 | 15
 | [NAME] | 15 | 15 | 12 | 6
 | [NAME] | 14 | 16 | 15 | 1
 | [NAME] | 9 | 18 | 8 | 5
 | [NAME] | 7 | 19 | 10 | 15
 | [NAME] | 12 | 20 | 16 | 12
 | [NAME] | 15 | 22 | 14 | 13
 | Tyler | 18 | 11 | 13 | 16
 | [NAME] | 21 | 10 | 12 | 22
 | [NAME] | 16 | 14 | 15 | 20