tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 02f40137-0d81-4f98-8b76-203b78ef2722
Sheet: Figure 1,2,4

Figure 1 |  |  |  |  |  |  |  |  |  | Figure 2
Ohio  (2006-07) | Statewide |  | Statewide Weighted for Charter Enrollment |  | Cleveland |  | Dayton |  |  |  | District | Charter | Difference
Per-Pupil Revenue |  |  |  |  |  |  |  |  |  | State
District |  |  | 10421 |  |  |  |  |  |  | Statewide Weighted
Charter |  |  | 8190
Difference |  |  | 2231
 |  |  | 0.214
Per-Pupil Revenue by Source | District | Charter | District | Charter | District | Charter | District | Charter
Federal |  |  | 1046
State |  |  | 4531
Local |  | 0 | 4843 |  |  | 0 |  | 0
Other | 0 |  | - |  | 0 |  | 0
Indeterminate | 0 | 0 | - |  | 0 | 0 | 0 | 0
Total
Enrollment
District | 1726715 |  | n/a |  | 54617 |  | 15887
 |  |  | n/a
Charter |  |  | n/a
 |  |  | n/a
Number of Charters | 303 |  | n/a |  | 41 |  | 29
Total Revenue
District |  |  | n/a
 |  |  | n/a
Charter |  |  | n/a
 |  |  | n/a
Total |  |  | n/a
Percentage of Revenue by Source | District | Charter | District | Charter | District | Charter | District | Charter |  | Figure 4
Federal |  |  |  |  |  |  |  |  |  |  | Federal | State | Local | Other | Indeterminate
State |  |  |  |  |  |  |  |  |  | Statewide District
Local |  |  |  |  |  |  |  |  |  | Statewide Charter
Other |  |  | 0 |  |  |  |  |  |  | Statewide Weighted
Change in district school funding if subjected to charter funding structure |  |  |  |  |  |  |  |  |  | Cleveland District
 | ($2.5 billion) |  |  |  | ($214.9 million) |  | ($64.3 million) |  |  | Cleveland Charter
 |  |  |  |  |  |  |  |  |  | Dayton District
Removed Promise Academy from the analysis - dollars but no pupils |  |  |  |  |  |  |  |  |  | Dayton Charter
Conversion charters included in analysis include state funds only
Spreadsheet: 161113d1339420207-random-results-based-on-percentages-baseball-simulator
Sheet: Simulator

 |  |  |  |  |  |  | Zone 13 Location Odds |  |  |  |  |  | Zone 13 Hit Rates |  |  |  |  |  | Zone 13 Slugging
 | 1 | 2 | 3 | 4 | 5
 | 6 | 7 | 8 | 9 | 10
 | 11 | 12 | x | 14 | 15
 | 16 | 17 | 18 | 19 | 20
 | 21 | 22 | 23 | 24 | 25
 |  | Name |  | L/R | Control | Lefty | Righty | FB- | CH- | SL- | [NAME] | SwStr+ | GB% | LD% | FB% | IFFB% | GB+ | LD+ | FB+ | IFFB+ | HR/FB
 | Pitcher: | [NAME]
 |  | Name |  | L/R | InSwing | OutSwing | Inside | Outside | Lefty | Righty | Contact | BA | GB% | LD% | FB% | IFFB% | GB+ | LD+ | FB+ | IFFB+ | HR/FB | ISO
 | Hitter: | [NAME]
 | In Zone:
 | Swing:
 | Hit:
 | Total Bases:
Spreadsheet: 704459d1605561212-possible-vlookup-testbadge-4-1
Sheet: Sheet1

Date/Time | Who | Credential Hotstamp | EMP ID
2020-11-05 17:50:54 | Green, [NAME] | 1001111 | TAB0100914
2020-11-05 18:31:32 | [NAME], [NAME] | 1001112 | TAB0100420
2020-11-05 08:56:40 | Doe, [NAME] | 1001113 | [NAME]
2020-11-05 09:56:40 | Black, [NAME] | 1001114 | TAB0100965
Spreadsheet: 107100d1304304928-array-by-state-customer-by-state
Sheet: Example

Employee 1 | Employee 2 |  |  |  |  | Desired end result
AK |  |  |  |  |  | Employee 1 |  |  | Employee 2
 | AL |  |  |  |  | Customer 1 | 12 |  | Customer 2 | 10
 | AR |  |  |  |  | Customer 2 | 5 |  | Customer 3 | 9
AZ |  |  |  |  |  | Customer 4 | 7 |  | Customer 5 | 10
 |  |  |  |  |  |  |  |  | Customer 6 | 6
 | AK | AL | AR | AZ
Customer 1 | 10 | 0 | 0 | 2
Customer 2 | 5 | 10 | 0 | 0
Customer 3 | 0 | 6 | 3 | 0
Customer 4 | 2 | 0 | 0 | 5
Customer 5 | 0 | 10 | 0 | 0
Customer 6 | 0 | 5 | 1 | 0
Spreadsheet: 887620d1737889999-lost-in-a-challenging-formula-challenge-costs-with-revenue-word-djclements
Sheet: Identifier

 |  |  | Identifier | contract type | Costs
 |  |  | SE.100 | open book | direct cost
 |  |  | SE.101 | lumpsum | indirect cost
 |  |  | SE.102 | open book | indirect cost
 |  |  | SE.103 | open book | indirect cost
 |  |  | SE.104 | lumpsum | indirect cost
 |  |  | SE.105 | lumpsum | direct cost
 |  |  | SE.106 | lumpsum | direct cost
 |  |  | SE.107 | open book | direct cost
 |  |  | [NAME] | open book | direct cost
Spreadsheet: 297339d1392361298-two-column-based-validation-without-names-sample-1-
Sheet: BRASSEURS

Brewer | Beer
À l'abri de la tempête | [NAME]
À l'abri de la tempête | Moussonneur
Brasseurs du Nord | Boréale blonde
Brasseurs du temps | Trois Portages
[NAME] ciel! | Corne du diable
[NAME] ciel! | [NAME]
[NAME] ciel! | [NAME]
Dunham | Leo's Early Breakfast IPA
Dunham | [NAME]
Farnham Ale & Lager | La 64
Golden Lion Brewery | Blonde des cantons
[NAME] | Gros Mollet Magnum
[NAME] | [NAME] tricotante chardonnay
Les Trois Mousquetaires | Maibock
Les Trois Mousquetaires | [NAME]
McAuslan | Griffon blonde
McAuslan | St-Ambroise Abricot
McAuslan | St-Ambroise Double IPA
Naufrageur | Malauze
RJ | Moosehead
[NAME] du diable | Buteuse
[NAME] du diable | L'Ours
[NAME] du diable | [NAME]
[NAME] du diable | [NAME]
Spreadsheet: 494469d1482408342-convert-unique-individual-with-several-rows-of-data-to-one-row-several-columns-sample
Sheet: Sheet2

ID | Code | value |  |  | ID | CODE | VALUE
12341 | 100 | 26836.5 |  |  | 12341
13532 | 100 | 22800 |  |  | 13532
14497 | 100 | 16221 |  |  | 14497
17057 | 100 | 16750 |  |  | 17057
01705 | 100 | 16350 |  |  | 1705
97937 | 100 | 10500 |  |  | 97937
14869 | 100 | 30684 |  |  | 14869
12806 | 100 | 17021.5 |  |  | 12806
17158 | 100 | 17975 |  |  | 17158
87489 | 100 | 23300 |  |  | 87489
88603 | 100 | 15051.5 |  |  | 88603
57178 | 100 | 32450 |  |  | 57178
68902 | 100 | 32652.5 |  |  | 68902
01239 | 100 | 38403.5 |  |  | 1239
97433 | 100 | 23000 |  |  | 97433
17422 | 100 | 26525 |  |  | 17422
14869 | 134 | 1000 |  |  | 16420
16420 | 100 | 14428.5 |  |  | 16197
16197 | 100 | 14233.5 |  |  | 10612
10612 | 100 | 13812 |  |  | 17205
17205 | 100 | 20440 |  |  | 14253
14253 | 100 | 29922.5 |  |  | 16911
16911 | 100 | 16755 |  |  | 17014
17014 | 125 | 360 |  |  | 15913
15913 | 100 | 14123.5 |  |  | 16221
16221 | 100 | 14385 |  |  | 16235
16235 | 100 | 14271.5 |  |  | 16422
16422 | 122 | 1956
16422 | 100 | 14428.5
17014 | 116 | 500
17014 | 115 | 245
17014 | 100 | 12305
Spreadsheet: 801668d1666288993-match-vertically-from-3-cells-led1
Sheet: Ark2

Sum af MÆNGDE | Kolonnemærkater
Rækkemærkater | 1 | 2 |  | Hovedtotal
2
24V | 2 |  |  | 2
(tom)
Hovedtotal | 2 |  |  | 2
 |  |  |  |  |  |  |  |  | 1 | 2 | 3
 |  |  |  |  |  |  |  | 2 | 1 | 2 | 3
Spreadsheet: e5b51e09-4190-4531-95b2-7c09f4e8ab03
Sheet: Daftar Instruktur

 | [NAME] | [NAME] |  |  |  | NIA
 | 0 | Panitia
 | 1 | Dr. [NAME] DS, MM |  |  |  | [PHONE]
 | 2 | Drs. [NAME]. Pradjarto, MPd. |  |  |  | [PHONE]
 | 3 | Dra. [NAME], MPd. |  |  |  | [PHONE]
 | 4 | Drs. Masfu'ad ES, MPd. |  |  |  | [PHONE]
 | 5 | [NAME], S.Pd., [NAME]. |  |  |  | [PHONE]
 | 6 | Dr. [NAME], SS, MPd. |  |  |  | [PHONE]
 | 7 | Drs. [NAME], [NAME] |  |  |  | 11199157006
 | 8 | Taufiqullah, SPd, [NAME]. |  |  |  | 11199157007
 | 9
Spreadsheet: 135708d1326199833-league-table-ranking-epl-table
Sheet: Sheet1

CLUB | P | W | D | L | GF | GA | [NAME] | PTS | Tie Breaker |  | POS | CLUB | P | W | D | L | GF | GA | [NAME] | PTS | Rank
Arsenal | 1 | 1 |  |  | 2 | 0 | 2 | 3 | 3.002002019999999 |  | 1 | Liverpool | 1 | 1 | 0 | 0 | 5 | 0 | 5 | 3 | 1
Bburn | 1 | 1 |  |  | 3 | 1 | 2 | 3 | 3.002003019 |  | 2 | Bburn | 1 | 1 | 0 | 0 | 3 | 1 | 2 | 3 | 2
Bol Wand | 0 |  |  |  |  |  | 0 | 0 | 1.8e-08 |  | 3 | Arsenal | 1 | 1 | 0 | 0 | 2 | 0 | 2 | 3 | 3
Chelsea | 1 |  | 1 |  | 1 | 1 | 0 | 1 | 1.000001017 |  | 4 | Wolves | 1 | 1 | 0 | 0 | 2 | 0 | 2 | 3 | 3
Everton | 0 |  |  |  |  |  | 0 | 0 | 1.6e-08 |  | 5 | Chelsea | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 5
Fulham | 0 |  |  |  |  |  | 0 | 0 | 1.5e-08 |  | 6 | Man City | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 5
Liverpool | 1 | 1 |  |  | 5 | 0 | 5 | 3 | 3.005005014 |  | 7 | Bol Wand | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7
Man City | 1 |  | 1 |  | 1 | 1 | 0 | 1 | 1.000001013 |  | 8 | Everton | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7
Man Utd | 0 |  |  |  |  |  | 0 | 0 | 1.2e-08 |  | 9 | Fulham | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7
New Utd | 0 |  |  |  |  |  | 0 | 0 | 1.1e-08 |  | 10 | Man Utd | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7
Norw City | 0 |  |  |  |  |  | 0 | 0 | 1e-08 |  | 11 | New Utd | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7
QPR | 0 |  |  |  |  |  | 0 | 0 | 9e-09 |  | 12 | Norw City | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7
Spurs | 0 |  |  |  |  |  | 0 | 0 | 8e-09 |  | 13 | QPR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7
Sto City | 0 |  |  |  |  |  | 0 | 0 | 7e-09 |  | 14 | Spurs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7
Sunderland | 0 |  |  |  |  |  | 0 | 0 | 6e-09 |  | 15 | Sto City | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7
Swa City | 0 |  |  |  |  |  | 0 | 0 | 5e-09 |  | 16 | Sunderland | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7
Villa | 0 |  |  |  |  |  | 0 | 0 | 4e-09 |  | 17 | Swa City | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7
WBA | 0 |  |  |  |  |  | 0 | 0 | 3e-09 |  | 18 | Villa | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7
[NAME] | 0 |  |  |  |  |  | 0 | 0 | 2e-09 |  | 19 | WBA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7
Wolves | 1 | 1 |  |  | 2 | 0 | 2 | 3 | 3.002002001 |  | 20 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7
Spreadsheet: 853510d1703355158-avg-times-per-day-in-pivot-admissions_data-deidentified-new-e_dylan_s-
Sheet: TOD Distribution

 |  | [NAME] | Count of Arrival Time |  |  |  | hour | Count of Date | Count of Ax Time Completed | Average per Date
 |  | (blank) |  |  |  |  | (blank) | 1
 |  | 8 AM | 17 |  |  |  | 8 | 15 | 17 | 1.133333333333333
 |  | 9 AM | 2 |  |  |  | 9 | 2 | 2 | 1
 |  | 10 AM | 2 |  |  |  | 10 | 2 | 2 | 1
 |  | 12 PM | 1 |  |  |  | 12 | 1 | 1 | 1
 |  | 1 PM | 2 |  |  |  | 13 | 2 | 2 | 1
 |  | 2 PM | 3 |  |  |  | 14 | 3 | 3 | 1
 |  | 3 PM | 2 |  |  |  | 15 | 2 | 2 | 1
 |  | 4 PM | 2 |  |  |  | 16 | 2 | 2 | 1
 |  | 5 PM | 1 |  |  |  | 17 | 1 | 1 | 1
 |  | 6 PM | 1 |  |  |  | 18 | 1 | 1 | 1
 |  | 7 PM | 11 |  |  |  | 19 | 11 | 11 | 1
 |  | 8 PM | 8 |  |  |  | 20 | 8 | 8 | 1
 |  | 9 PM | 1 |  |  |  | 21 | 1 | 1 | 1
 |  | Grand Total | 53 |  |  |  | Grand Total | 38 | 53 | 1.394736842105263
Spreadsheet: 76548d1277111172-dates-format-in-excel-file-shanipk82-test
Sheet: Sheet1

Deal Assumption |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | List
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Department
Department | Order type | Key | Cycle time to revenue | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Push Pro | Small
Push Pro | Small |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | StoreFront | Medium
Push Pro | Medium |  | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AirMail | Large
Push Pro | Large |  | 90
StoreFront | Small |  | 30
StoreFront | Medium |  | 90
StoreFront | Large |  | 120
AirMail | Small |  | 30
AirMail | Medium |  | 90
AirMail | Large |  | 120
 |  |  | # Prospects Closed |  |  | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00
 |  |  | Media | Department | Order Type
 |  |  | X-Small Customer | Push Pro | Small | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 |  |  | S -Medium Customer | Push Pro | Medium | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
 |  |  | StoreFront-Sm | StoreFront | Small | 2 | 2 | 2 | 6 | 8 | 6 | 8 | 6
 |  |  | StoreFront-Med | StoreFront | Medium | 1 | 1 | 1 | 3 | 3 | 3 | 3 | 3
 |  |  | StoreFront-Large | StoreFront | Large | 1 | 1 | 1 | 2 | 2 | 2 | 1 | 2
 |  |  | Z-Small | AirMail | Small | 0 | 3 | 3 | 10 | 10 | 10 | 10 | 10
 |  |  | Z-Medium | AirMail | Medium | 0 | 2 | 2 | 6 | 8 | 6 | 8 | 6
 |  |  | Z-Large | AirMail | Large | 0 | 0 | 1 | 1 | 1 | 2 | 2 | 2
 |  |  | Prospects Become Revenue |  |  | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | Cycle
 |  |  | Media | Department | Order Type
 |  |  | X-Small Customer | Push Pro | Small
 |  |  | S -Medium Customer | Push Pro | Medium
 |  |  | StoreFront-Sm | StoreFront | Small
 |  |  | StoreFront-Med | StoreFront | Medium
 |  |  | StoreFront-Large | StoreFront | Large
 |  |  | Z-Small | AirMail | Small
 |  |  | Z-Medium | AirMail | Medium
 |  |  | Z-Large | AirMail | Large
Spreadsheet: louise_kitchen__22705__ubsplan
Sheet: SAP

 | SAP
 | 2002 Plan
 |  | 2001-09-01 00:00:00 |  | 2001 |  | 2002 |  |  |  | Per HC | New HC | Adj Comp |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  |  |  |  |  | Compensation | 0
 | Analysts & Associates | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  | Other |  | 12
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services |  |  |  |  |  |  |  | Total
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  | 0
ENACONTR | Charitable Contributions |  |  |  |  | 0 |  |  | [NAME] | 49200 | 0
ENARENT | Rent |  |  |  |  | 0 |  |  | [NAME] | 57600 | 0
ENATECH | Technology |  |  |  |  |  |  |  | Staff | 60000 | 0
ENATRANS | Transportation |  |  |  |  | 0 |  |  | Specialist | 78000 | 2
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Sr. Specialist | 102000 | 2
ENATAXES | Taxes Other than Income |  |  |  |  | 0 |  |  | Analyst | 0 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | Associate | 0 | 0
 |  |  |  |  |  |  |  |  | Manager | 144000 | 3
 | Headcount |  |  | 111 |  | 12 |  |  | Director | 168000 | 2
 |  |  |  |  |  |  |  |  | Sr. Director | 216000 | 3
 | Analysts & Associate Headcount |  |  | 0 |  | 0 |  |  | VP | 222000 | 0
 |  |  |  |  |  |  |  |  | MD | 300000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance |  |  |  |  |  |  |  | Consultants | 160000 | 0
ENASYSDV | System Development |  |  | 0
ENACORIT | Controllable Infrastructure |  |  | 0
ENACORRN | Corporate Rent |  |  | 0
ENAOTHAL | Other Allocated Direct  Expenses |  |  | 0 |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization |  |  | 0
 |  |  |  |  |  |  |  | Based on information from ENW accounting.
Spreadsheet: 771556d1646727580-look-up-a-column-with-duplicates-and-return-from-multiple-specified-columns-book1-4-1-ans
Sheet: Sheet1

Product ID | Colour | Weight | # ID | % Value | Origin |  |  | Desired Results |  |  |  |  | Desired Results
111 | Green |  |  |  |  |  |  | Proudct ID | Colour | # ID | Origin |  | Proudct ID | Colour | # ID | Origin
222 | Blue |  |  |  |  |  |  |  |  |  |  |  | 111 | Green | #657 | China
333 | Red |  |  |  |  |  |  | 222 |  |  |  |  | 222 | Blue | #655 | UAE
444 | Yellow |  |  |  |  |  |  | 333
555 |  | 1mg | #6543 |  |  |  |  | 444
222 |  | 2mg | #655 |  |  |  |  | 555
333 |  | 3mg | #656
111 |  | 4mg | #657
444 |  | 5mg | #658
111 |  |  |  | 0.5 | China
333 |  |  |  | 0.3 | Australia
444 |  |  |  | 0.4 | USA
555 |  |  |  | 0.55 | UK
222 |  |  |  | 0.99 | UAE
Spreadsheet: 585422d1533755808-need-to-sumif-certain-criteria-is-met-on-same-day-of-week-example
Sheet: Sheet1

manual | manual | LINE | LINE | LINE | LINE | LINE | LINE | LINE | HOURS | HOURS | HOURS | HOURS | HOURS | HOURS | HOURS | Cake | Baked | Frozen | Spiral | formula | formula | formula
Week of: (mm/dd/yy) | Name | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | 1262M05 (Cake) Hrs | 1262M08 (Baked) Hrs | 1262M09 (Freezer) Hrs | 1262M10 (Spiral) Hrs | Total Hrs | Fiscal Week | Fiscal Month
2018-07-22 00:00:00 | Employee 1 | Baked | Cake | Frozen | Spiral | Spiral |  |  | 8 | 8 | 8 | 8 | 8
2018-07-22 00:00:00 | Employee 2 | Cake | Frozen | Spiral | Spiral | Baked |  |  | 8 | 8 | 8 | 8 | 8
2018-07-22 00:00:00 | Employee 3 |  | Frozen | Spiral | Spiral | Baked | Cake |  |  | 8 | 8 | 8 | 8 | 8
2018-07-22 00:00:00 | Employee 4 |  | Spiral | Spiral | Baked | Cake | Frozen |  |  | 8 | 8 | 8 | 8 | 8
2018-07-22 00:00:00 | Employee 5 |  |  | Spiral | Baked | Cake | Frozen | Spiral |  |  | 8 | 8 | 8 | 8 | 8
2018-07-29 00:00:00 | Employee 1 | Baked | Cake | Frozen | Spiral | Spiral |  |  | 8 | 8 | 8 | 8 | 8
2018-07-29 00:00:00 | Employee 2 | Cake | Frozen | Spiral | Spiral | Baked |  |  | 8 | 8 | 8 | 8 | 8
2018-07-29 00:00:00 | Employee 3 |  | Frozen | Spiral | Spiral | Baked | Cake |  |  | 8 | 8 | 8 | 8 | 8
2018-07-29 00:00:00 | Employee 4 |  | Spiral | Spiral | Baked | Cake | Frozen |  |  | 8 | 8 | 8 | 8 | 8
2018-07-29 00:00:00 | Employee 5 |  |  | Spiral | Baked | Cake | Frozen | Spiral |  |  | 8 | 8 | 8 | 8 | 8
2018-08-05 00:00:00 | Employee 1 | Baked | Cake | Frozen | Spiral | Spiral |  |  | 8 | 8 | 8 | 8 | 8
2018-08-05 00:00:00 | Employee 2 | Cake | Frozen | Spiral | Spiral | Baked |  |  | 8 | 8 | 8 | 8 | 8
2018-08-05 00:00:00 | Employee 3 |  | Frozen | Spiral | Spiral | Baked | Cake |  |  | 8 | 8 | 8 | 8 | 8
2018-08-05 00:00:00 | Employee 4 |  | Spiral | Spiral | Baked | Cake | Frozen |  |  | 8 | 8 | 8 | 8 | 8
2018-08-05 00:00:00 | Employee 5 |  |  | Spiral | Baked | Cake | Frozen | Spiral |  |  | 8 | 8 | 8 | 8 | 8
Spreadsheet: 782991d1654511265-special-transposing-phonebook-to-sim-format-book2
Sheet: Sheet2

[NAME] (LMF) | NUMBER | [NAME] (FML) |  | 3 | 1 | 1 | 1 | Column
SMITHJ/P | +[PHONE] | JSMITH/P |  | (+1)[PHONE] | 2 | 3 | 1 | 4 | J/P |  | 4
SMITHJ | [PHONE] | JSMITH |  | [PHONE] | 2 | 3 | 2 | 8 | J |  | 8
SMITHJ/A | 28 | JSMITH/A |  | 28 | 2 | 3 | 3 | 23 | J/A |  | 23
MacGilleFhJP/W | [PHONE] | JPMacGilleFh/W |  | 6284567890 | 3 | 3 | 1 | 5 | JP/W |  | 5
MacGilleFhaoJP | 12 | JPMacGilleFhao |  | 12 | 3 | 3 | 2 | 8 | JP |  | 8
MacGilleFJP/Xz | +[PHONE] | JPMacGilleF/Xz |  | +[PHONE] | 3 | 3 | 3 | 25 | JP/Xz |  | 25
[NAME] length 14 characters (Truncate last name)
 | Retain only "+", remove all other than numbers
Spreadsheet: 754196d1636015585-extract-only-specified-values-from-a-table-extraction-on-constr
Sheet: Sheet1

Construction | Item | Quantity |  | Quantity of constructions |  |  | Constructions | 301 |  |  | 301
301 | Pak.1 Kensal MR Sideboard | 4800 |  | 110 |  |  |  | 301 | Pak.1 Kensal MR Sideboard
301 | [NAME] | 9800 |  | 201 |  |  |  | 301 | [NAME]
409 | Furn.pak. Kensal MR Sideboard | 7800 |  | 301 |  |  |  | 301 | Pak. NewEst Desk with Drawers
301 | Pak. NewEst Desk with Drawers | 9200 |  | 409 |  |  |  | 301 | Pak. NewEst Shoe Shoe Cabinet 3D
301 | Pak. NewEst Shoe Shoe Cabinet 3D | 18600 |  | 410 |  |  |  | 301 | Pak. Northgate Settle  Bench (KD)
409 | Furn.pak. NewEst Shoe Cabinet 3D | 2600 |  |  |  |  |  | 301 | Pak. Farsta Wall mounted [NAME] (RA)
301 | Pak. Northgate Settle  Bench (KD) | 1800 |  |  |  |  |  | 301 | Pak. [NAME]  (KD)
410 | Furn. Pak. [NAME] (KD) | 3000 |  |  |  |  |  | 301 | Pak.1  Stripe Sideboard KD
301 | Pak. Farsta Wall mounted [NAME] (RA) | 19400 |  |  |  |  |  | 301 | Pak.2 Rayburn [NAME]
110 | Lp-vaheleht | 16000 |  |  |  |  |  | 301 | Pak.1 [NAME]
301 | Pak. [NAME]  (KD) | 9800 |  |  |  |  |  | 301 | Pak.1 Avon MR [NAME]
409 | Furn. Pak. [NAME]  (KD) | 13000 |  |  |  |  |  | 301 | Pak.2 Avon Sideboard Set  (KD)
301 | Pak.1  Stripe Sideboard KD | 8200
201 | Pak.2 Stipe [NAME] | 2200
201 | [NAME] Sideboard KD | 4000
409 | Furn.pak. Stripe Sideboard KD | 12400
301 | Pak.2 Rayburn [NAME] | 1200
301 | Pak.1 [NAME] | 18000
301 | Pak.1 Avon MR [NAME] | 15200
301 | Pak.2 Avon Sideboard Set  (KD) | 16000
409 | Furn.pak. Avon MR Sideboard  KD | 10800
Spreadsheet: 101116d1299257621-adding-several-cells-based-on-content-pvtreadtimeingwithcounts
Sheet: Sheet1

Name | Page | Time
[NAME] | 1 |  |  | Sum of times spent on each page |  |  | Time spent with Who as col sort too.
[NAME] | 2 |  |  | Row Labels | Sum of Time |  |  | Column Labels
[NAME] | 3 |  |  | 1 | 7 |  |  | [NAME] |  | [NAME] |  | Total Sum of Time | Total Count of Time2
[NAME] | 4 |  |  | 2 | 3 |  | Row Labels | Sum of Time | Count of Time2 | Sum of Time | Count of Time2
[NAME] | 1 |  |  | 3 | 6 |  | 1 | 1 | 1 | 3 | 1 | 4 | 2
[NAME] | 2 |  |  | 4 | 7 |  | 2 | 3 | 1 | 5 | 1 | 8 | 2
[NAME] | 3 |  |  | 5 | 3 |  | 3 | 3 | 1 | 2 | 1 | 5 | 2
[NAME] | 4 |  |  | Grand Total | 26 |  | 4 | 3 | 1 | 2 | 1 | 5 | 2
[NAME] | 5 |  |  |  |  |  | 5 |  |  | 1 | 1 | 1 | 1
 |  |  |  |  |  |  | Grand Total | 10 | 4 | 13 | 5 | 23 | 9
Spreadsheet: 837018d1689787445-index-small-failed-to-replicate-example-example
Sheet: Sheet2

 | Movie | [NAME] | Actor | Release
 | Prisoners | Thriller | [NAME] | 2013 |  | [NAME] | Action
 | The [NAME] | Mystery | Christian Bale | 2006 |  | Actor | [NAME]
 | Logan | Action | [NAME] | 2017 |  | Movie
 | The Dark Knight | Action | Christian Bale | 2008
 | Inception | Action | [NAME] | 2010
 | Public Enemies | Action | [NAME] | 2009
 | The Machinist | Thriller | Christian Bale | 2004
 | The Tourist | Action | [NAME] | 2010
 | Catch Me If You Can | Thriller | [NAME] | 2002
 | The Wolverine | Action | [NAME] | 2013
 | Shutter Island | Thriller | [NAME] | 2010
 | Secret Window | Thriller | [NAME] | 2004
 | Real Steel | Action | [NAME] | 2011
 | The Dark Knight Rises | Thriller | Christian Bale | 2012
 | The Ninth Gate | Thriller | [NAME] | 1999
 | The Departed | Thriller | [NAME] | 2006
 | Website: | https://www.exceldemy.com/excel-extract-data-from-table-based-on-multiple-criteria/#I_Using_INDEX-MATCH_Array_Formula
Spreadsheet: darrell_schoolcraft__7797__imbalsumm0107
Sheet: SidR

 | [NAME]
 | POI 1190 - Keystone Plant Outlet
Day | Measured | Scheduled
1 | 60371 | 70065
2 | 72797 | 71930
3 | 61156 | 61980
4 | 52301 | 52595
5 | 62144 | 62969
6 | 71897 | 71381
7 | 64002 | 66382
8 | 63666 | 68875
9 | 60222 | 64425
10 | 59649 | 58407
11 | 61338 | 62345
12 | 60051 | 57779
13 | 58436 | 66558
14 | 64611 | 63994
15 | 57921 | 57393
16 | 62766 | 59860
17 | 52798 | 49523
18 | 56765 | 55683
19 | 48699 | 53072
20 | 49865 | 56783
21 | 50524 | 62267
22 | 50508 | 55320
23 | 50659 | 50176
24 | 48519 | 32684
25 | 54136 | 51992
26 | 61612 | 56568
27 | 51210 | 52443
28 | 54934 | 75976
29
30
31
2001-06-30 00:00:00 |  |  | 0
2001-07-28 00:00:00
Spreadsheet: 672748d1586982415-look-up-rows-and-distribute-across-columns-pallet-pick
Sheet: Pallet Card

 |  |  |  |  |  |  |  |  | AVO
 | Production Date: |  |  | Depot Date: |  |  |  | Depot:
 |  |  |  |  | Pallets Needed
 | Prod Code |  | Layers | Remaining | 1 | 2 | 3 | 4
 | 0007223 |  |  |  | 1 | 0 | 0 | I need to look up the layers column
 | 5200589 |  |  |  | 1 | 0 | 0
 | 0007225 |  |  |  | 1 | 0 | 0 | then have this automaticaly fill the pallets needed
 | 5216848 |  |  |  | 1 | 0 | 0 | Each pallet can only have maximum 9
 | 5201843 |  |  |  | 5 | 8 | 0 | once 9 has been reached id like it to move to the next column, and do the same, then so on and so on
 | 5205162 |  |  |  | 0 | 0 | 0
 | 0009694 |  |  |  | 0 | 1 | 2
 | 5216843 |  |  |  | 0 | 0 | 1
 | 5210413 |  |  |  | 0 | 0 | 1
 | 5216837 |  |  |  | 0 | 0 | 0
 | 5209761 |  |  |  | 0 | 0 | 0
 | 5214026 |  |  |  | 0 | 0 | 0
 | 5214996 |  |  |  | 0 | 0 | 0
 | 5210292 |  |  |  | 0 | 0 | 3
 | 5202529 |  |  |  | 0 | 0 | 0
 | 5213881 |  |  |  | 0 | 0 | 2
 | 5214025 |  |  |  | 0 | 0 | 0
 | 5209314 |  |  |  | 0 | 0 | 0
 | 5212974 |  |  |  | 0 | 0 | 0
 | 5210354 |  |  |  | 0 | 0 | 0
 | 5202524 |  |  |  | 0 | 0 | 0
 |  |  |  | Maximum