tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 463904d1464793649-cross-reference-check-with-a-help-of-single-formula-with-vlookup-in-excel-sample-file
Sheet: Sheet1

[NAME] | Mark | Franc | [NAME] | [NAME] In Mark | [NAME] in Franc | [NAME] in [NAME] | [NAME] not in Mark ,[NAME],Franc | [NAME] in Mark Not in Franc | [NAME] user [NAME] in Mark, [NAME] not in Franc | [NAME] user Avt in [NAME],Franc not in [NAME] | [NAME] user [NAME] in Franc not in [NAME] | [NAME] users av in Franc not in [NAME] | [NAME] users av in Franc ,[NAME] not in [NAME] | [NAME] user [NAME] in [NAME] not in [NAME] | [NAME] user [NAME] in [NAME] not in Franc
ESLABBI | AABHISH | PRAKASK | a143_s_addwks
ANPAVAN | AACHUTH | SHPRAKA | a575dmu1
SRIDUMA | AADARSH | KAPRAKA | AABHISH
[NAME] | [NAME] | HDAKSHI | aadarsh
ANAKUMA | AAKAPUR | RHANUMA | aadc_a_cocappadmin
RRASTOG | AAKEDIA | VESUNIL | AADC_s_PID0BEB
PGONUGU | AAKOLKA | MOSUNIL | AANKSEN
PRGHOSH | AAMANDE | JOHNSPE | [NAME]
SKALUGO | AANANTA | STALINS | abairis
PPRASAD | AANGADI | HSOMASH | aballeb
PRSAHOO | AANKITA | RAUMESH | [NAME]
DRAJAGO | AANURAG | SDHARAN | ABCHAVA
HKUNDAL | AANUSHR | HKUNDAL | ABHERLE
VPONUGU | AAPOORV | BPRAMOD | [NAME]
SLAKSHM | AARRALA | RASENTH | abhikum
CHAWLAD | AASAGAR | SHIVKUC | [NAME]
SBOYAPA | AASALEX | KPRAVEE | achitra
Spreadsheet: 768906d1645196725-giving-my-cell-a-color-cel-kleuren-neele-
Sheet: Qry H8

WERKDAG | WERKORDER | MERK | POSTNUMMER | Kolom2 | PRODUKTIEMIDDEL | HAL | STATUS | Werk + Merk | Week | [NAME] | Kolom1 | OMSCHRIJVING | PostOmschrijving | DATUM | Uniek ID | Uniek ID2 | datum productie | [NAME]
2022-05-12 | 3659 | K109 | 11 |  | H4-T08 | Hal 04 | Nog te prod |  |  |  |  | 67 app | Balkons
2022-05-10 | 3659 | K114 | 11 |  | H5-T15 | Hal 05 | Nog te prod |  |  |  |  | 67 app | Balkons
Spreadsheet: 745251d1629820498-formula-that-uses-3-columns-to-show-yes-no-and-n-a-fake_data
Sheet: raw_data

firstname | Did they pass the test? | video_duration | video_completed_at | Did they complete watching the video?
person1 | Failed | 42s | 2021-08-18 13:59:40
person2 | Failed
person3 | Failed | 6s
person4 | Failed | 1 min 28s | 2021-08-12 14:30:37
person5 | Failed | 7 min 30s | 2021-08-11 11:18:23
person6 | Failed | 4 min 42s | 2021-08-12 03:22:09
person7 | Failed | 1 min 58s | 2021-08-09 14:43:07
person8 | Failed | 0s
person9 | Failed
person10 | Failed | 5 min 59s | 2021-08-11 12:08:29
person11 | Failed | 23s | 2021-08-12 16:18:58
person12 | Failed | 0s
[NAME] | Failed | 1 min 36s | 2021-08-09 08:55:48
person14 | Passed
person15 | Passed
person16 | Passed
person17 | Passed
Spreadsheet: 119641d1314633022-match-dates-excel-date-match-query
Sheet: Sheet1

 | Date 1 | Amount 1 | Date 2 | Amount 2 |  |  | Date | Amount 1 | Amount 2
 | 2011-10-28 00:00:00 | 24231.77777777777 | 2011-09-28 00:00:00 | 52542.22222222223 |  |  | 2011-08-22 00:00:00 | 0 | 0
 | 2012-01-28 00:00:00 | 27914.33333333334 | 2011-12-28 00:00:00 | 72395.55555555555 |  |  | 2011-09-22 00:00:00 | 0 | 0
 | 2012-04-28 00:00:00 | 28639.72222222222 | 2012-03-28 00:00:00 | 77552.2222222222 |  |  | 2011-10-22 00:00:00 | 0
 | 2012-07-28 00:00:00 | 29390.47222222222 | 2012-06-28 00:00:00 | 81675.55555555556 |  |  | 2011-11-22 00:00:00
 | 2012-10-28 00:00:00 | 31581.59644444445 | 2012-09-28 00:00:00 | 84844.44444444444 |  |  | 2011-12-22 00:00:00 | 0
 | 2013-01-28 00:00:00 | 35399.36644444444 | 2012-12-28 00:00:00 | 99654.2011111111 |  |  | 2012-01-22 00:00:00 | 0
 | 2013-04-28 00:00:00 | 35380.015 | 2013-03-28 00:00:00 | 101948 |  |  | 2012-02-22 00:00:00
 | 2013-07-28 00:00:00 | 38725.49236111111 | 2013-06-28 00:00:00 | 112648.1733333333 |  |  | 2012-03-22 00:00:00
 |  |  |  |  |  |  | 2012-04-22 00:00:00
Spreadsheet: 772032d1646980323-extract-specific-text-if-it-match-the-criteria-extract
Sheet: extract

Address | Result Here | Province Name
Opeyapui Village, [NAME] LLG, Tambuil Nebilyer, Mt. Hagen,  Western Highlands  PAPUA NEW GUINEA | Western Highlands | Bougainville
Kimbe Mosa LLG [NAME]West New Britain  PAPUA NEW GUINEA |  | Central
Monokam Village  [NAME]  Enga  PAPUA NEW GUINEA |  | East Sepik
[NAME] LLG [NAME]  PAPUA NEW GUINEA |  | Sandaun
[NAME] |  | Simbu
Namatanai Village Tanir Namatanai Namatanai  New Ireland  PAPUA NEW GUINEA |  | Southern Highlands
[NAME], PO Box 1653  Lae,  Morobe  PAPUA NEW GUINEA |  | Western Highlands
Pobuma   Manus  Manus  PAPUA NEW GUINEA |  | Morobe
[NAME]  East Sepik Province  PAPUA NEW GUINEA |  | Madang
PO Box 83,  [NAME]  PAPUA NEW GUINEA |  | Hela
Okapa West Okapa Rural Oakapa Okapa  Eastern Highlands  PAPUA NEW GUINEA |  | West New Britain
C/ - [NAME] heart High School, Private Mail Bag, Lae  Morobe  PAPUA NEW GUINEA |  | [NAME]
Eriku boundary road Dysox street Lae Lae  Morobe 411 PAPUA NEW GUINEA |  | Enga
Spreadsheet: 696984d1601059701-if-vlookup-with-clusters-if-vlookup_updated-1-
Sheet: Sheet1

Alphabet id | Alphabet | Desired Output | Helper1 | Helper2
445592 | TEST_102559 | Y
445593 | TEST_102559 | Y | 3 | 2
278544 | TEST_104994 | Y | 4 | 4
278472 | TEST_104994 | Y | 5 | 4
258939 | TEST_108069 | Y | 6 | 6
258941 | TEST_108069 | Y | 7 | 6
444942 | TEST_11417 | Y | 8 | 8
444950 | TEST_11417 | Y | 9 | 8
513548 | TEST_11679 | X | 10 | 10
513548 | TEST_11679 | X | 10 | 10
513548 | TEST_11679 | X | 10 | 10
513548 | TEST_11679 | X | 10 | 10
513548 | TEST_11679 | X | 10 | 10
513548 | TEST_11679 | X | 10 | 10
513548 | TEST_11679 | X | 10 | 10
513548 | TEST_11679 | X | 10 | 10
449558 | TEST_11779 | Y | 18 | 18
449449 | TEST_11779 | Y | 19 | 18
283163 | TEST_118461 | Y | 20 | 20
281913 | TEST_118860 | Y | 21 | 21
281866 | TEST_118860 | Y | 22 | 21
290367 | TEST_123155 | Y | 23 | 23
513545 | TEST_125471 | Y | 24 | 24
513559 | TEST_125471 | Y | 25 | 24
513626 | TEST_125471 | Y | 26 | 24
100 | TEST_125472 | Y | 27 | 27
101 | TEST_125472 | Y | 28 | 27
100 | TEST_125472 | Y | 27 | 27
100 | TEST_125472 | Y | 27 | 27
887 | TEST_125479
8888 | TEST_125479
Spreadsheet: 327803d1403692214-indexing-and-summing-table-results-even-when-rows-get-deleted-scoring-tool
Sheet: Sheet1

 | Challenge | Answer | [NAME] | Score Cat
Category 1 | Standard | 5 | 5
Category 1 | Standard | 2 | 5 |  |  | Logic to identify all Category 1 and count, in this case there are 7 Category 1
Category 1 | Standard | 4 | 5 |  |  | Then sum the answers for category 1, in this case 23
Category 1 | Standard | 3 | 5 |  |  | [NAME] needs to count in such a way that when Category 2 is found, it restarts and excludes Category 1
Category 1 | Standard | 2 | 5 |  |  | perhaps by matching the category to an indexed table of categories.
Category 1 | Standard | 2 | 5 |  |  | The reason for this is so if a row is deleted, the math still calculates
Category 1 | Standard | 5 | 5 |  |  | Math is to take score answer per category and find percentage of [NAME] score in a dynamic sheet
Category 2 | Standard | 4 | 5
Category 2 | Standard | 4 | 5
Category 2 | Standard | 3 | 5
Category 2 | Standard | 1 | 5
Category 2 | Standard | 5 | 5
Category 2 | Standard | 5 | 5
Category 2 | Standard | 1 | 5
Category 2 | Standard | 4 | 5
Category 3 | Standard | 2 | 5
Category 3 | Standard | 4 | 5
Category 3 | Standard | 2 | 5
Category 3 | Standard | 2 | 5
Category 3 | Standard | 1 | 5
Category 3 | Standard | 5 | 5
Category 3 | Standard | 4 | 5
Category 3 | Standard | 2 | 5
Spreadsheet: 10e096c5-f7b4-4849-85d6-43297d87fd61
Sheet: Winter 2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Graduate School of Liberal Studies
Winter 2016
Subject | Course and Title | Subtitle/Alternate Title | Section | [NAME] | Dates | Days | Times | Credits | Instructor(s) | Instructor ID | FT or Adj | Contract Code | Percentage | Registration Approval | [NAME] | Blackboard Y/N | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list?   SUBJ CRSE SEC | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 695808d1600415487-convert-unstructured-column-base-data-into-single-row-excelforum
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Desired Result |  | From Year | To Year | Sl No | [NAME] | Index | Interval
Name | Years |  |  |  |  |  |  |  |  |  | Year | Name
[NAME] | 2013-2015 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Barb | 2015 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
[NAME] | 2000-2004 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
[NAME] | 2001-2006 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
[NAME] | 2012-2015 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
[NAME] | 2016-2017 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
[NAME] | 2005 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
Hank | 2002-2005 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
Ike | 2010 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
Jared | 2014-2018 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
Kelly | 2002-2006 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
[NAME] | 2001-2006 |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
[NAME] | 2006-2011 |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
Nan | 2009 |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
Otto | 2002 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
[NAME] | 2015-2019 |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
Quenten | 2010-2011 |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
Raul | 2013-2016 |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
[NAME] | 2013-2016 |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
Spreadsheet: 794466d1662057105-calculating-attendance-times-from-shift-books-on-product-basis-2022-09-01-oeldere2-lena_mesta-excel-forum-attendances
Sheet: Analysis

Information: | one employee works 7.5hrs per day
 | CW 34
Number of employees
Attendance times
weeknumber | 34
Som van Time / day | Kolomlabels
Rijlabels | 1 | 2 | 3 | Eindtotaal
13012 |  |  | 15 | 15
13219 | 15 | 30 |  | 45
13319 |  |  | 15 | 15
13918 |  | 15 | 22.5 | 37.5
171610 |  |  | 15 | 15
173512 |  | 15 | 22.5 | 37.5
173600 |  |  | 15 | 15
175200 |  | 15 | 22.5 | 37.5
175212 |  | 15 |  | 15
175310 | 15 | 30 |  | 45
175710 |  |  | 15 | 15
176211 |  | 15 | 22.5 | 37.5
176500 |  |  | 7.5 | 7.5
176700 |  | 15 | 22.5 | 37.5
178410 |  |  | 15 | 15
178811 | 22.5 |  | 7.5 | 30
183900 | 15 | 30 |  | 45
184311 | 30 |  | 7.5 | 37.5
184312 | 22.5 |  |  | 22.5
293200 |  | 7.5 |  | 7.5
293372 | 30 |  | 7.5 | 37.5
293373 | 15 | 30 |  | 45
293382 | 30 |  | 7.5 | 37.5
293383 |  | 15 | 22.5 | 37.5
(leeg) | 0 | 0 | 0 | 0
Eindtotaal | 195 | 232.5 | 262.5 | 690
Spreadsheet: 374bbd9c-77e0-433b-b0ae-2a8f9a7c44e1
Sheet: 11b

Product1 | EUR3 | USD | GBP | [NAME] | AUD | CAD | OTHER | TOTAL
Cross-Currency Basis | 12 | 42 | 5 | 9 | - | 3 | 2 | 73
Cross-Currency Fixed-Fixed | 1 | 1 | - | 1 | - | - | 7 | 10
Cross-Currency Fixed-Float | - | 9 | - | - | - | - | 23 | 32
TOTAL | 13 | 52 | 5 | 10 | - | 3 | 32 | 115
Spreadsheet: 843066d1695038300-values-rank-occurrence-based-summarised-by-rank-rank-summary-b
Sheet: Foglio1

 | Given a list of  valus and their rank based on their occurrences |  |  |  |  |  |  |  |  |  |  | The INDEX function used in col J repeats the rank so many times as occurrences of each given pair
 | show a summary of ranks and corresponding values |  |  |  |  |  |  |  |  |  |  | Any suggestion to better it?
 |  |  |  |  |  |  |  |  |  |  |  | I'm using the italian version of the 2019 excel.
 | Values | [NAME] |  |  | Rank |  | Multiple (unwanted)  correspondents |  | Desired single corresp. Rank | Desired single corresp. Pair |  | (*) No ranking shown … | (*) no summary made | Have I perhaps mis-digited your instructions?
 | 1417 |  |  |  |  |  |  |  | 4 | 1215
 | 1215 |  |  |  |  |  |  |  | 2 | 1417
 | 1523 |  |  |  |  |  |  |  | 1 | 1523
 | 1215 |  |  |  |  |  |  |  | 1 | 3144
 | 3144 |  |  |  |  |  |  |  | 1 | 7788
 | 1417 |  |  |  |  |  |  |  | 1 | 3355
 | 1215
 | 7788
 | 3355
 | 1215
Spreadsheet: 291985d1390463868-scenario-testing-and-stepped-table-excel
Sheet: Sheet1

 |  |  |  |  |  |  | 1 |  | Scenario 1
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 1
 | Scenario 1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.3 | 0.1
 | Scenario 2 | 0.4 | 0.5 | 0.6 | 0.7 | 0.4 | 0.4
Spreadsheet: 873772d1720341191-how-to-find-total-of-working-hours-from-a-single-cell-kvemperor-working-hours-shop-aligw
Sheet: ΩΡΑΡΙΑ

[NAME] | 31 |  |  | ΡΕΠΟ
ΞΕΚΙΝΑΕΙ | 2024-07-01 00:00:00
ΒΗΜΑ | 1
 | ΙΟΥΛΙΟΣ |  | [NAME] ΡΑΦΑΕΛΑ | KROSHKINA MARIA | ΒΛΑΧΟΥ ΠΑΝΑΓΙΩΤΑ | ΚΑΛΛΟΥ ΓΕΩΡΓΙΑ | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ | ΟΙΚΟΝΟΜΟΥ ΒΑΡΒΑΡΑ | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ | ΚΟΝΙΣΣΗ ΙΟΥΛΙΑΝΗ |  |  | [NAME] ΡΑΦΑΕΛΑ | KROSHKINA MARIA | ΒΛΑΧΟΥ ΠΑΝΑΓΙΩΤΑ | ΚΑΛΛΟΥ ΓΕΩΡΓΙΑ | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ | ΟΙΚΟΝΟΜΟΥ ΒΑΡΒΑΡΑ | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ | ΚΟΝΙΣΣΗ ΙΟΥΛΙΑΝΗ
 |  | 11.00-22.00 |  | 09.00-17.00 | 11.00-17.00 | 16.00-22.00 | 09.00-22.00 | 17.00-22.00 | 09.00-22.00 | 15-00-21.00
 | 2024-07-02 00:00:00 | 09.30-22.00 |  | 09.00-17.00 | 11.00-17.00 | 16.00-22.00 | 09.00-22.00 | 17.00-22.00 | 09.00-13.00  &  17.00-22.00 | 16-00-21.00
 | 2024-07-03 00:00:00 | 09.30-22.00 |  | 09.00-17.00 | 11.00-17.00 | 16.00-22.00 | 09.00-22.00 | 17.00-22.00 | 09.00-13.00  &  17.00-22.00 | 16-00-21.00
 | 2024-07-04 00:00:00 | ΟΡΘΟΠΑΙΔΙΚΟΣ |  | 09.00-17.00 | 11.00-17.00 | 16.00-22.00 | 09.00-22.00 | 17.00-22.00 | 09.00-13.00  &  17.00-22.00 | 16-00-21.00
 | 2024-07-05 00:00:00 | ΔΕΝ ΗΡΘΕ |  | 09.00-17.00 | 11.00-17.00 | 16.00-22.01 | 09.00-22.00 | 17.00-22.00 | 09.00-13.00  &  17.00-22.00 | 16-00-21.00
 | 2024-07-06 00:00:00 | ΔΕΝ ΗΡΘΕ |  | 09.00-17.00 | 11.00-17.00 | ΡΕΠΟ | 09.00-22.00 | 17.00-22.00 | 09.00-22.00 | 16-00-21.00
 | 2024-07-07 00:00:00 | ΔΕΝ ΗΡΘΕ |  | ΡΕΠΟ | ΡΕΠΟ | 10.00-18.00 | 10.00-18.00 | ΡΕΠΟ | 10.00-18.00 | ΡΕΠΟ
 | 2024-07-08 00:00:00
 | 2024-07-09 00:00:00
 | 2024-07-10 00:00:00
 | 2024-07-11 00:00:00
 | 2024-07-12 00:00:00
 | 2024-07-13 00:00:00
 | 2024-07-14 00:00:00
 | 2024-07-15 00:00:00
 | 2024-07-16 00:00:00
 | 2024-07-17 00:00:00
 | 2024-07-18 00:00:00
 | 2024-07-19 00:00:00
 | 2024-07-20 00:00:00
 | 2024-07-21 00:00:00
 | 2024-07-22 00:00:00
 | 2024-07-23 00:00:00
 | 2024-07-24 00:00:00
 | 2024-07-25 00:00:00
 | 2024-07-26 00:00:00
 | 2024-07-27 00:00:00
 | 2024-07-28 00:00:00
 | 2024-07-29 00:00:00
 | 2024-07-30 00:00:00
 | 2024-07-31 00:00:00
Spreadsheet: 126833d1319989016-number-in-a-range-sol-1
Sheet: Sheet1

103.6809 | 1
125.3855 | 1
146.654 | 1
135.6578 | 1
146.8365 | 1
134.2396 | 1
98.007 | 1
46.511 | 1
136.905 | 1
167.7231 | 1
131.4672 | 1
95.449 | 1
179.207959 | 1
67.458 | 1
128.0432 | 1
88.7454 | 1
152.9375 | 1
132.1276 | 1
49.812 | 1
87.3532 | 1
136.472 | 1
89.1676 | 1
67.607 | 1
165.8708 | 1
94.6578 | 1
67.156 | 1
103.7492 | 1
98.1941 | 1
123.6853 | 1
176.62867 | 1
120.8584 | 1
169.9319 | 1
 | 7
Spreadsheet: 111523d1307904998-record-the-total-possible-attendance-against-actual-attendance-attendance-1-
Sheet: Sheet1

name | course | date | location |  |  | Course | Capacity | Attendance | [NAME]
[NAME] | hrm | 2011-05-12 00:00:00 | here |  |  | hrm | 6 | 3 | 0.5
[NAME] | hrm | 2011-05-12 00:00:00 | here |  |  | mgt | 4 | 2 | 0.5
[NAME] | hrm | 2011-05-12 00:00:00 | here |  |  | training | 4 | 2 | 0.5
anne | mgt | 2011-04-10 00:00:00 | everywhere
[NAME] | mgt | 2011-04-10 00:00:00 | everywhere
[NAME] | training | 2011-04-15 00:00:00 | there
[NAME] | training | 2011-04-15 00:00:00 | there
Spreadsheet: 440230d1452703184-vacation-tracking-from-an-anniversary-date-from-year-to-year-vacation-tracking-2015
Sheet: September

Employee Absence Schedule
September | Dates of Absence
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 |  | Total Hours
A |  |  |  |  |  |  | H
B |  |  |  |  |  |  | H
C |  |  |  |  |  |  | H
D |  |  |  |  |  |  | H
E |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  | O
F |  |  |  |  |  |  | H
G |  |  |  |  |  |  | H
H |  |  |  |  |  |  | H
I |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  | O
J |  |  |  |  |  |  | H
K |  |  | O |  |  |  | H | LE | O |  |  |  |  | O |  | O
L |  |  |  |  |  |  | H
M |  |  |  |  |  |  | H
N |  |  |  |  |  |  | H
O |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  | 8
Spreadsheet: 833816d1687266648-need-to-move-a-number-of-characters-from-one-column-to-another-can-anyone-help-hidden-column-aligw
Sheet: Sheet1

10 Cloverfield Lane 2016
12 Angry Men 1957
Spreadsheet: 92286d1291903798-delivering-data-based-on-a-table-disk-2010
Sheet: Values

XBH | Sevens | Value
1 | 1 | 1
1 | 1.5 | 1
2 | 1 | 5
2 | 1.5 | 5
2 | 2 | 10
2 | 2.5 | 10
2 | 3 | 20
2 | 3.5 | 20
2 | 4 | 30
2 | 4.5 | 30
2 | 5 | 40
2 | 5.5 | 40
2 | 6 | 50
2 | 6.5 | 50
2 | 7 | 60
2 | 7.5 | 60
2 | 0 | 5
2 | 0.5 | 5
3 | 0 | 10
3 | 0.5 | 10
3 | 1 | 15
3 | 1.5 | 15
3 | 2 | 25
3 | 2.5 | 25
3 | 3 | 35
3 | 3.5 | 35
3 | 4 | 45
3 | 4.5 | 45
3 | 5 | 55
3 | 5.5 | 55
3 | 6 | 65
3 | 6.5 | 65
4 | 0 | 20
4 | 0.5 | 20
4 | 1 | 30
4 | 1.5 | 30
4 | 2 | 40
4 | 2.5 | 40
4 | 3 | 50
4 | 3.5 | 50
4 | 4 | 60
4 | 4.5 | 60
4 | 5 | 70
4 | 5.5 | 70
5 | 0 | 35
5 | 0.5 | 35
5 | 1 | 45
5 | 1.5 | 45
5 | 2 | 55
5 | 2.5 | 55
5 | 3 | 65
5 | 3.5 | 65
5 | 4 | 75
5 | 4.5 | 75
Spreadsheet: 133717d1324564403-excel-2007-conditional-formatting-for-shortest-time-example
Sheet: Sheet1

 | Wall Clock Time | Processing Time | Indexing Time | Post-Processing Time | Total Time
 | 03:46:12 | 00:59:04 | 03:46:14 | 00:18:41
 | Wall Clock Time | Processing Time | Indexing Time | Post-Processing Time | Total Time
 | 02:59:11 | 00:59:01 | 02:59:11 | 00:05:46
 | Wall Clock Time | Processing Time | Indexing Time | Post-Processing Time | Total Time
 | 02:59:02 | 01:00:31 | 02:59:02 | 00:08:31
Spreadsheet: 853437d1703283850-is-there-a-way-to-loop-through-an-index-match-formula-sample-inventory
Sheet: Inventory

Line # | Product Name | Brand | Style | Gender | Size | Color | Qty | Qty Left | SKU #
1 | [NAME] | Gildan | Heavy Blend | Kid's | S | Black | 15 |  | TT-1011-Gil-He-Ki-S-Bla
2 | CT-Shirts | Cricut | Heavy Cotton | Men's | M | Blue | 20 |  | TT-1021-Cri-He-Me-M-Blu
3 | Sweat Shirt | Gildan | Soft Style | Women's | L | Green | 10 |  | TT-1031-Gil-So-Wo-L-Gre
4 | Sweat Shirt w/o | Gildan | Heavy Cotton | Women's | XL | Pink | 30 |  | TT-1041-Gil-He-Wo-XL-Pin
5 | Sweat Shirt | Gildan | Heavy Cotton | Women's | XL | Pink | 10 |  | TT-1031-Gil-He-Wo-XL-Pin
Spreadsheet: 69904d1270575570-hyperlinking-book2
Sheet: TWO

a | 1
b | 2
c | 3
d | 4
e | 5
f | 6
g | 7
h | 8
i | 9
j | 10
k | 11
l | 12
m | 13
n | 14
o | 15
p | 16
q | 17
r | 18
s | 19
t | 20
u | 21
v | 22
w | 23
x | 24
y | 25
z | 26
aa | 27
bb | 28
cc | 29
dd | 30
ee | 31
ff | 32
gg | 33
hh | 34
ii | 35
jj | 36
kk | 37
ll | 38
[NAME] | 39
nn | 40
oo | 41
pp | 42
qq | 43
rr | 44
ss | 45
tt | 46
uu | 47
vv | 48
ww | 49
xx | 50
yy | 51
zz | 52
Spreadsheet: 118759d1313994753-if-statement-to-compare-times-copy-of-variation
Sheet: Variation Calc

3 Shifts
Start of Week | Test Time | Time Diffs | Total Week | Shifts | % Done | % To Go | [NAME]
 |  |  | 5
2 shifts
Start of Week | Test Time | Time Diffs | Total Week | Shifts | % Done | % To Go | [NAME] |  | 22:00:00
 |  |  | 5 |  |  |  |  |  | 06:00:00
Shifts | 3 | 3 | 3 | 2 |  | 2 | 3 | 3 | 2
Line | 109-1 | 109-2 | 109-3 | 109-4 |  | 110-1 | 110-2 | 110-3 | 110-4
2 Week Avg.
[NAME]
 | 13695 | 12652 | 8108 | 10340 |  | 11446 | 16635 | 15206 | 13315
Friday 10PM - Unmet
After 1 OT Shift
After 2 OT Shifts
After 3 OT Shifts
Spreadsheet: 871604d1718037680-formula-to-get-actual-numbers-upon-meeting-conditions-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | [NAME] to get actual numbers upon meeting conditions (excelforum.com)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expected Result
Finance Employee List |  |  |  |  |  |  |  |  | Report for Completed KPI |  |  |  |  |  |  |  | KPI Weekly Team Report
Department | Team | Emp Name | Emp ID | Role | Delagate if on Annual Leave |  |  |  | Emp Name | Emp ID | Activity | Completion Date | Week | Delegated | Assigned |  | Role | Team | Activity | Target | Actual | Week # | Actual by [NAME]
Finance | Payroll | Emp 1 | ID001 | Manager | ID002 |  |  |  | Emp 2 | ID002 | KPI 1 | 2024-01-01 00:00:00 |  |  |  |  | Manager | Payroll | KPI 1 | 1 | 1 | 1
Finance | Payroll | Emp 2 | ID002 | Supervisor | ID003 |  |  |  | Emp 2 | ID002 | KPI 1 | 2024-01-01 00:00:00 |  |  |  |  | Supervisor | Payroll | KPI 1 | 2 | 8 | 1
Finance | Payroll | Emp 3 | ID003 | Assistant | N/A |  |  |  | Emp 2 | ID002 | KPI 1 | 2024-01-02 00:00:00 |  |  |  |  | Manager | Payroll | KPI 1 | 1 | 3 | 2
 |  |  |  |  |  |  |  |  | Emp 2 | ID002 | KPI 1 | 2024-01-02 00:00:00 |  |  |  |  | Supervisor | Payroll | KPI 1 | 2 | 6 | 2
 |  |  |  |  |  |  |  |  | Emp 2 | ID002 | KPI 1 | 2024-01-03 00:00:00
Weekly KPI Target per Role |  |  |  |  |  |  |  |  | Emp 2 | ID002 | KPI 1 | 2024-01-03 00:00:00
Role | Activity | Target |  |  |  |  |  |  | Emp 2 | ID002 | KPI 1 | 2024-01-04 00:00:00
Manager | KPI 1 | 1 |  |  |  |  |  |  | Emp 2 | ID002 | KPI 1 | 2024-01-04 00:00:00
Supervisor | KPI 1 | 2 |  |  |  |  |  |  | Emp 2 | ID002 | KPI 1 | 2024-01-05 00:00:00
Supervisor | KPI 2 | 1 |  |  |  |  |  |  | Emp 1 | ID001 | KPI 1 | 2024-01-07 00:00:00
Manager | KPI 3 | 1 |  |  |  |  |  |  | Emp 1 | ID001 | KPI 1 | 2024-01-08 00:00:00
Supervisor | KPI 3 | 1 |  |  |  |  |  |  | Emp 1 | ID001 | KPI 1 | 2024-01-10 00:00:00
 |  |  |  |  |  |  |  |  | Emp 3 | ID003 | KPI 1 | 2024-01-07 00:00:00
 |  |  |  |  |  |  |  |  | Emp 3 | ID003 | KPI 1 | 2024-01-08 00:00:00
Finance Leave Schedule |  |  |  |  |  |  |  |  | Emp 3 | ID003 | KPI 1 | 2024-01-09 00:00:00
Emp Name | Emp ID | Start Date | End Date | Start Week | End Week | Assign to: |  |  | Emp 3 | ID003 | KPI 1 | 2024-01-09 00:00:00
Emp 1 | ID001 | 2024-01-01 00:00:00 | 2024-01-05 00:00:00 |  |  |  |  |  | Emp 3 | ID003 | KPI 1 | 2024-01-10 00:00:00
Emp 2 | ID002 | 2024-01-08 00:00:00 | 2024-01-10 00:00:00 |  |  |  |  |  | Emp 3 | ID003 | KPI 1 | 2024-01-10 00:00:00
Spreadsheet: 874871d1721378518-use-formulas-logic-of-one-field-as-if-statement-for-another-field-very-complex-countif-samplefile_improved
Sheet: VIS_07-24

NUP_VERFAHREN | [NAME] | ADRESSE | FIRMA1 | Status Vertrag | Anfangsdatum Vertrag | Endedatum Vertrag | ARTIKEL | NAMEINTERN | Status Position | Anfangsdatum Position | Endedatum Position
 |  |  | [NAME] | 2 |  |  |  | [NAME] zu DMS - monatlich | 2
 |  |  | Smith | 2 |  |  |  | [NAME] zu DMS - monatlich | 2
 |  |  | [NAME] | 2 |  |  |  | [NAME] (LK) - monatlich | 2
 |  |  | Walter | 2 |  |  |  | [NAME] (LK) - monatlich | 2
 |  |  | Kent | 2 |  |  |  | [NAME] | 2
 |  |  | Note | 2 |  |  |  | [NAME] | 3
 |  |  | [NAME] | 2 |  |  |  | [NAME] | 2
 |  |  | Hagen | 2 |  |  |  | [NAME] | 3
 |  |  | Forest | 2 |  |  |  | [NAME] | 2
 |  |  | Clock | 2 |  |  |  | [NAME] | 2
 |  |  | Berris | 2 |  |  |  | [NAME] | 2
 |  |  | Docs | 2 |  |  |  | [NAME] | 2
 |  |  | Obs | 2 |  |  |  | [NAME] | 2
 |  |  | Full | 2 |  |  |  | VIS Arbeitsplatz - jährlich | 2
 |  |  | Smith | 2 |  |  |  | VIS Arbeitsplatz - jährlich | 2
 |  |  | Stern | 2 |  |  |  | VIS Arbeitsplatz - jährlich | 3
 |  |  | Beauford | 2 |  |  |  | VIS Arbeitsplatz - jährlich | 2
 |  |  | [NAME] | 2 |  |  |  | VIS Arbeitsplatz - jährlich | 2
 |  |  | [NAME] | 2 |  |  |  | VIS Arbeitsplatz - jährlich | 2
 |  |  | Hank | 2 |  |  |  | VIS Arbeitsplatz - jährlich ([NAME]) | 2
 |  |  | Hoffs | 3 |  |  |  | VIS Arbeitsplatz - jährlich ([NAME]) | 2
 |  |  | [NAME] | 3 |  |  |  | VIS Arbeitsplatz - jährlich ([NAME]) | 2
 |  |  | Jenkins | 2 |  |  |  | VIS Arbeitsplatz - jährlich ([NAME]) | 2
 |  |  | Bell | 2 |  |  |  | VIS Arbeitsplatz [NAME] Rechenzentrum - jährlich | 2
 |  |  | [NAME] | 3 |  |  |  | VIS Arbeitsplatz [NAME] Rechenzentrum - jährlich | 3
 |  |  | Munch | 2 |  |  |  | VIS Arbeitsplatz [NAME] Rechenzentrum - jährlich | 2
 |  |  | Rio | 2 |  |  |  | VIS Arbeitsplatz [NAME] Rechenzentrum - jährlich | 2
 |  |  | [NAME] | 2 |  |  |  | VIS Arbeitsplatz [NAME] Rechenzentrum - jährlich | 2
 |  |  | Port | 1 |  |  |  | VIS Arbeitsplatz [NAME] Rechenzentrum - jährlich | 1
 |  |  | Good | 2 |  |  |  | VIS [NAME] | 2
 |  |  | Tree | 2 |  |  |  | VIS [NAME] | 2
 |  |  | Alfred | 2 |  |  |  | VIS [NAME] | 2
 |  |  | Wills | 2 |  |  |  | VIS [NAME] | 2
 |  |  | Ink | 2 |  |  |  | VIS [NAME] | 2
 |  |  | Melody | 2 |  |  |  | VIS [NAME] | 2
 |  |  | [NAME] | 2 |  |  |  | VIS [NAME] | 2
 |  |  | Green | 2 |  |  |  | VIS [NAME] | 2
 |  |  | Woods | 2 |  |  |  | VIS [NAME] | 2