tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0106454e-a4fb-4227-acd0-a51126af46fe
Sheet: Publishers (Fiction)

Publisher (Fiction) | Titles | Percentage
[NAME] | 41
AmazonCrossing | 28
Europa Editions | 16
Seagull Books | 14
Penguin | 13
[NAME] | 9
Houghton [NAME] | 8
Lontar | 8
Open Letter | 8
Other Press | 8
Archipelago | 7
[NAME] | 7
Yale University Press | 7
FSG | 6
[NAME] | 6
Hispabooks Publishing | 6
New Directions | 6
Frisch & Co. | 5
[NAME] | 5
Knopf | 5
Melville House | 5
Minotaur | 5
Pegasus | 5
American University at Cairo | 4
Atria | 4
Bitter Lemon | 4
Glagoslav Publications | 4
Glas | 4
Overlook | 4
Portobello | 4
Soho Press | 4
And Other Stories | 3
Black Cat | 3
Grove | 3
House of Anansi | 3
K A Nitz | 3
Simon & Schuster | 3
Stockholm Text | 3
Tagus Press | 3
Two Lines Press | 3
7Vientos | 2
[NAME] | 2
Barcelona Books | 2
Biblioasis | 2
Cheeky Frawg | 2
Crown | 2
DISQUIET | 2
[NAME] | 2
[NAME] | 2
Feminist Press | 2
HarperCollins | 2
Indiana University Press | 2
Le French | 2
Library of Arabic Literature | 2
New Vessel Press | 2
New York Review Books | 2
Pantheon | 2
Quercus | 2
Random House | 2
St. Martin's | 2
[NAME] | 2
Syracuse University Press | 2
Talonbooks | 2
Tor | 2
University of Minnesota Press | 2
University of Nebraska | 2
University of Texas | 2
Viking | 2
Vintage | 2
[NAME] | 2
Aqueduct Press | 1
Arcade | 1
Arsenal Pulp Press | 1
Bellevue Literary Press | 1
Black Balloon | 1
Black Scat | 1
Bloomsbury | 1
Candle and Fog Publishing | 1
Canongate | 1
Cinco Puntos Press | 1
CN Times Books | 1
Coach House Books | 1
Columbia University Press | 1
Comma Press | 1
Contra Mundum Press | 1
Counterpath Press | 1
[NAME] | 1
Eerdmans Books | 1
Exile Editions | 1
[NAME] and [NAME] | 1
Gefen Publishing | 1
Gomidas Institute | 1
[NAME] | 1
Grand Central | 1
Graywolf | 1
Groundwood | 1
Haikasoru | 1
Hanging Loose Press | 1
[NAME] | 1
Hersilia Press | 1
Interlink | 1
[NAME] | 1
[NAME] | 1
Last Gasp | 1
Latin American Literary Review Press | 1
Liberties | 1
Locked Room International | 1
Loose Leaves Publishing | 1
[NAME] | 1
McGill-Queen's University Press | 1
[NAME]'s Books | 1
Mulholland Books | 1
[NAME] | 1
New Europe | 1
Northwestern University Press | 1
Norvik Press | 1
Orbit | 1
Persea | 1
[NAME] | 1
Pfefferkorn Publishing | 1
Phoneme Books | 1
Picador | 1
Pleasure Boat Studio | 1
Process | 1
Riverhead | 1
Rizzoli | 1
Route | 1
Russian Information Services | 1
Santa Fe Writers Project | 1
[NAME] | 1
[NAME] | 1
Serenity International | 1
Serpent's Tail | 1
Seven Stories Press | 1
Small Beer | 1
[NAME] | 1
Spout Hill Press | 1
Strategic Book Publishing | 1
Talisman House | 1
[NAME] | 1
Tartarus | 1
Telegram | 1
[NAME] | 1
Tin House | 1
Ugly Duckling | 1
University of Chicago | 1
University of Oklahoma Press | 1
Verso | 1
Vertical | 1
W.W. Norton | 1
Wakefield Press | 1
[NAME] | 1
Spreadsheet: 768364d1644937593-trying-to-look-up-and-filter-data-example
Sheet: REDK050

REDK050
Product | Component name | Result text
Spreadsheet: 775079d1648810997-sumproduct-not-returning-value-should-work-ok-test-file-2
Sheet: Sheet3

EmployeeId | Forename | Surname | StartDate | EndDate | DurationDays | CostCode | Date | Value
6619 | Operator 1 | Operator 1 | 2021-01-03 00:00:00 | 2021-01-08 00:00:00 | 3 | 181 | 2022-04-01 00:00:00 | 1
5939 | Operator 2 | Operator 2 | 2021-01-04 00:00:00 | 2021-01-08 00:00:00 | 5 | 182 | 2022-04-01 00:00:00 | 1
5866 | Operator 3 | Operator 3 | 2021-01-04 00:00:00 | 2021-01-04 00:00:00 | 1 | 182 | 2022-04-01 00:00:00 | 1
5689 | Operator 4 | Operator 4 | 2021-01-04 00:00:00 | 2021-01-04 00:00:00 | 1 | 181 | 2022-04-01 00:00:00 | 1
6319 | Operator 5 | Operator 5 | 2021-01-04 00:00:00 | 2021-01-08 00:00:00 | 5 | 182 | 2022-04-01 00:00:00 | 1
5959 | Operator 6 | Operator 6 | 2021-01-04 00:00:00 | 2021-01-15 00:00:00 | 10 | 181 | 2022-04-01 00:00:00 | 1
5689 | Operator 7 | Operator 7 | 2021-01-05 00:00:00 | 2021-01-05 00:00:00 | 1 | 181 | 2022-04-01 00:00:00 | 1
5994 | Operator 8 | Operator 8 | 2021-01-07 00:00:00 | 2021-01-07 00:00:00 | 1 | 181 | 2022-04-01 00:00:00 | 1
6647 | Operator 9 | Operator 9 | 2021-01-08 00:00:00 | 2021-01-08 00:00:00 | 1 | 182 | 2022-04-01 00:00:00 | 1
6027 | Operator 10 | Operator 10 | 2021-01-08 00:00:00 | 2021-01-08 00:00:00 | 1 | 182 | 2022-04-01 00:00:00 | 1
5994 | Operator 11 | Operator 11 | 2021-01-08 00:00:00 | 2021-01-08 00:00:00 | 1 | 181 | 2022-04-01 00:00:00 | 1
6647 | Operator 12 | Operator 12 | 2021-01-11 00:00:00 | 2021-01-11 00:00:00 | 1 | 182 | 2022-04-01 00:00:00 | 1
6104 | Operator 13 | Operator 13 | 2021-01-11 00:00:00 | 2021-01-11 00:00:00 | 1 | 182 | 2022-04-01 00:00:00 | 1
6319 | Operator 14 | Operator 14 | 2021-01-11 00:00:00 | 2021-01-19 00:00:00 | 7 | 182 | 2022-04-01 00:00:00 | 1
5957 | Operator 15 | Operator 15 | 2021-01-12 00:00:00 | 2021-01-12 00:00:00 | 1 | 182 | 2022-04-01 00:00:00 | 1
6889 | Operator 16 | Operator 16 | 2021-01-12 00:00:00 | 2021-01-12 00:00:00 | 1 | 181 | 2022-04-01 00:00:00 | 1
5957 | Operator 17 | Operator 17 | 2021-01-13 00:00:00 | 2021-01-13 00:00:00 | 1 | 182 | 2022-04-01 00:00:00 | 1
6620 | Operator 18 | Operator 18 | 2021-01-15 00:00:00 | 2021-01-15 00:00:00 | 1 | 182 | 2022-04-01 00:00:00 | 1
6883 | Operator 19 | Operator 19 | 2021-01-15 00:00:00 | 2021-01-15 00:00:00 | 1 | 182 | 2022-04-01 00:00:00 | 1
5965 | Operator 20 | Operator 20 | 2021-01-15 00:00:00 | 2021-01-15 00:00:00 | 1 | 181 | 2022-04-01 00:00:00 | 1
Spreadsheet: 04f9f7ef-b1c9-401e-be14-91874da8939d
Sheet: Sheet1

Unnamed: 0 | 61st Cherokee National Holiday Co-Ed Softball Tournament | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | August 23 - 25, 2013
 | Sequoyah Softball Fields
 | Tahlequah, Oklahoma
 |  |  |  |  |  |  | CO-ED
 | WINNERS |  |  |  |  |  | 20 TEAMS
 |  | [NAME]
 |  | 11 PM Friday F2 (5
 |  | [NAME]
 | Nations |  | 5 PM Sat. F3      (21
 | 7 PM Friday F2      (1
 | Jugz-N-Nutz | 10 AM Sat. F3  (9
 |  | ATS
 |  |  |  | 9 PM Sat. F2         (29
 |  | CNI 1
 | [NAME] | 11 AM Sat. F2    (10
 | 8 PM Friday F2            (2
 | OK Highrollers |  | 6 PM Sat. F2     (22
 |  | The Crew
 |  | 9 AM Sat. F2     (6
 |  | Southside Indians
 |  |  |  |  | 10 AM Sunday F2   (35
 |  | Native Outlaws
 |  | 9 AM Sat. F3    (7
 |  | [NAME]
 | [NAME] |  | 6 PM Sat. F3     (23
 | 9 PM Friday F2   (3
 | DC Extreme | 11 AM Sat. F3   (11
 |  | CNI 4
 |  |  |  | 10 PM Sat. F2     (30
 |  | CNI Dawgs
 |  |  |  |  |  |  |  | 1 PM Sunday F2    (38
 | Bad Intentions | 12 PM Sat. F2    (12 |  |  |  |  |  |  | Winner
 | 10 PM Friday F2  (4
 | [NAME] |  | 7 PM Sat. F2     (24
 |  | The Goonies
 |  | 10 AM Sat. F2      (8
 |  | Legendz Sports
 |  |  |  |  |  |  |  |  | 2 PM Sunday F2   (39
 | LOSERS |  |  |  |  |  |  |  | If necessary | Winner
 |  |  |  |  |  |  | Loser 35
 |  | Loser 9 |  |  | Loser 29
 |  | 2 PM Sat. F3    (17
 | Loser 3
 | 12 PM Sat. F3   (13 |  | 9 PM Sat. F3     (28
 |  |  |  |  | 11 PM Sat. F3     (33
 | Loser 7 |  | Loser 24 |  |  |  | 12 PM Sunday F2   (37
 |  |  |  | 10 PM Sat. F3     (31
 |  | Loser 10
 |  | 3 PM Sat. F2   (18 |  |  |  |  |  |  | Loser of 38 if 1st loss
 | Loser 4
 | 1 PM Sat. F2     (14 |  | 8 PM Sat. F2    (27
 |  |  |  |  |  | 11 AM Sunday F2   (36
 | Loser 8 |  | Loser 23
 |  | Loser 11 |  |  | Loser 30
 |  | 4 PM Sat. F2    (19
 | Loser 1
 | 1 PM Sat. F3   (15 |  | 8 PM Sat. F3    (26
 |  |  |  |  | 10 AM Sunday F1    (34
 | Loser 5 |  | Loser 22
 |  |  |  | 11 PM Sat. F2    (32
 |  | Loser 12
 |  | 5 PM Sat. F2     (20
 | Loser 2
 | 2 PM Sat. F2   (16 |  | 7 PM Sat. F3     (25
 | Loser 6 |  | Loser 21
Spreadsheet: benjamin_rogers__1073__Reconstructed Consolidated 2000 Peaker 8-15-00
Sheet: Assumptions

ASSUMPTIONS
TECHNICAL ASSUMPTIONS: |  | 2000 PROJECTS
 |  | [NAME] | Wheatland | [NAME] |  | Total
Number of Turbines |  | 3 | 4 | 8
Summer Capacity (MW) |  | 530 | 480 | 608
[NAME] (HHV, Btu/kWh) |  | 10800 | 11500 | 11900
Numbers of Starts |  | 75 | 75 | 75
PRICING ASSUMPTIONS:
Energy Charge ($/MWh)
Start Charge ($/Start/Turbine)
Annual Generation (MWh) |  | 532991.6197855896 | 461312.7218562186 | 2002000
OPERATING COSTS ASSUMPTIONS:
Variable O&M ($/MWh) |  | 1.5 | 3 | 2
Major [NAME] ($/Start/Turbine) |  | 3000 | 1500 | 1000
Annual Escalator |  | 0.03
Annual Cost (000$ in Year 2000)
Fixed O&M |  | 1242.481714285714 | 1515.790285714286 | 1448.540571428571
Variable O&M
Major [NAME]
Owner's Expense |  | 322.2511428571429 | 306.2677142857142 | 400.6471428571429
Property Tax Liability
TAX ASSUMPTIONS:
Federal Income Tax Rate |  | 0.35 | 0.35 | 0.35 |  | 0.35
State Income Tax Rate |  | 0.06 | 0.045 | 0.0718
Adjusted Gross Income Tax |  | N/A | 0.034 | N/A
Gross Receipts Tax Rate |  | N/A | 0.012 | N/A
Franchise Tax Rate (Year 1) |  | 0.0025 | N/A | 0.0015
Franchise Tax Rate (Year 2-20) |  | 0.0025 | N/A | 0.001
Spreadsheet: 875318d1721909261-need-help-with-search-function-example
Sheet: Folha1

 | # | Reference |  |  |  |  |  |  |  |  |  |  | # | Reference
 | 1 | 7975-008 |  |  | In this cells I don't want to fill with anything |  |  |  |  |  |  |  | 1 | 7975-008
 | 2 | 7975-009 |  |  | In this cell I want to fill with "Total" |  |  |  |  |  |  |  | 2 | 7975-009
 | 3 | 7975-010 |  |  | In this cell I want to fill with "Discount" |  |  |  |  |  |  |  | 3 | 7975-010
 | 4 | 7975-013 |  |  | In this cell I want to fill with "Air" |  |  |  |  |  |  |  | 4 | 7975-013
 | 5 | 7975-014 |  |  | In this cell I want to fill with "Truck" |  |  |  |  |  |  |  | 5 | 7975-014
 | 6 | 7975-015 |  |  | In this cell I want to fill with "Rail" |  |  |  |  |  |  |  | 6 | 7975-015
 |  | TOTAL |  |  | In this cell I want to fill with "Sea" |  |  |  |  |  |  | TOTAL |  | TOTAL
 |  | TOTAL（Discount of 10%) |  |  |  |  |  |  |  |  |  | Discount |  | TOTAL（Discount of 10%)
 |  | DAP COST( Air) |  |  |  |  |  |  |  |  |  | AIR |  | DAP COST( Air)
 |  | DAP COST(Truck) |  |  |  |  |  |  |  |  |  | TRUCK |  | DAP COST(Truck)
 |  | DAP COST(Rail) |  |  |  |  |  |  |  |  |  | RAIL |  | DAP COST(Rail)
 |  | DAP COST( Sea) |  |  |  |  |  |  |  |  |  | SEA |  | DAP COST( Sea)
Spreadsheet: 275257d1383421675-how-can-i-sum-up-values-corresponding-to-a-specific-serial-number-inksured-2nd-attempt
Sheet: Transaction Details

Date | Roll No. | Name | No. of Prints | Paper | Color/ B&W | Rate | Due | Paid | Balance
 | 2013048 |  | 5 | Regular | Colour |  |  | 15
 | 2013052 |  | 15 | Bond | B&W |  |  | 50
 | 2013021 |  | 10 | [NAME] | Colour |  |  | 400
 | 2013047 |  | 5 | Glossy A4 | B&W |  |  | 110
 | 2013048 |  | 5 | Regular | B&W |  |  | 10
 | 2013007 |  | 10 | Regular | B&W |  |  | 15
 | 2013052 |  | 10 | Bond | Colour |  |  | 70
 | 2013092 |  | 40 | Regular | B&W |  |  | 80
 | 2013048 |  | 30 | Glossy A4 | Colour |  |  | 1000
 | 2013002 |  | 10 | Regular | Colour
 | 2013007 |  | 5 | Regular | B&W |  |  | 10
 | 2013002 |  | 10 | Regular | Colour
 | 2013002 |  | 10 | Bond | Colour |  |  | 30
 | 2013002 |  | 10 | Glossy A4 | B&W |  |  | 150
 | 2013048 |  | 5 | [NAME] | Colour |  |  | 200
Spreadsheet: 20082d9d-7053-4320-b5ec-12567655cf4f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6514 | 41262 | [NAME] | Hertl (1948) | SVK | 117 | 00:22:58 | 00:01:22 | 01:28:16 | 00:01:22 | 00:55:19 | 1 | 02:49:20
Spreadsheet: 747380d1631449934-pls-help-me-find-the-right-formula-for-this-complicated-worksheet-book2
Sheet: Sheet1

LOOKUP TABLE 1 |  |  |  |  | RESULT TABLE
ID | RANK | REPORT TO: |  |  | ID | AMT | 1ST | 2ND | 3RD
A00007 | AA | A00011 |  |  | A00007 | 10000
A00011 | BB | A00009 |  |  | A00009 | 15000
A00009 | CC | A00004 |  |  | A00004 | 25000
A00004 | DD |  |  |  | A00011 | 50000
LOOKUP TABLE 2
BB | 0.1
CC | 0.15
DD | 0.2
Spreadsheet: 687868d1595457844-lookup-a-range-returning-highest-amount-excelforumtest
Sheet: data

Heading 1 | Heading 2 | Heading 3
ABC123 | QWET | 2.06
ABC123 | RTEP | 0.85
ABC123 | TYGB | 1.45
ABC123 | RUNX | 1.15
ABC123 | VMYW | 0.55
ABC123 | PTKL | 6.45
DEF456 | QWET | 1.45
DEF456 | RTEP | 2.85
DEF456 | TYGB | 6.9
DEF456 | RUNX | 0.95
DEF456 | VMYW | 1.25
DEF456 | PTKL | 0.45
GHj789 | QWET | 3.45
GHj789 | RTEP | 4.9
GHj789 | TYGB | 1.15
GHj789 | RUNX | 0.7
GHj789 | VMYW | 7.9
GHj789 | PTKL | 1.65
Spreadsheet: 834864d1688125945-require-help-in-multiple-vlookup-tasl-pan-india-dispatch-report-working-sunilsagar-
Sheet: Dashboard

 | Plan Vs Dispatch 2023-2024 |  |  |  |  |  |  |  | Store Supply Performance
 | Customer | Planned Volume | Indent YTD | Dis. YTD | GRN YTD | Indent Pending | Dis. Pending |  | State | Stores | Dis.Qty | AVG TPOD | Solid | GRN Qty | GRN%
 | ITC FBD |  |  |  |  |  |  |  | WB | MMMCCL
 | Haldiram Noida |  |  |  |  |  |  |  | WB | SGS
 | [NAME] |  |  |  |  |  |  |  | WB | NB
 | [NAME] |  |  |  |  |  |  |  | Total
 | Tulsi Speciality Guwahati
 | Terrestrial Foods GK
 | Total |  |  |  |  |  |  |  | Store Supply Performance
 |  |  |  |  |  |  |  |  | State | Stores | Dis.Qty | AVG TPOD | Solid | GRN Qty | GRN%
 | Today`s Indent |  |  |  |  |  |  |  | GJ | WC
 | Customer | Indent |  |  |  |  |  |  | GJ | SA
 | ITC FBD Coimbatore |  |  |  |  |  |  |  | GJ | MCS
 | ITC FBD Guwahati |  |  |  |  |  |  |  | GJ | KP
 | ITC FBD Haridwar |  |  |  |  |  |  |  | GJ | JG
 | ITC FBD Medak |  |  |  |  |  |  |  | GJ | GC
 | ITC FBD Mysore |  |  |  |  |  |  |  | GJ | SM
 | ITC FBD Panchla |  |  |  |  |  |  |  | GJ | GP
 | ITC FBD Pune |  |  |  |  |  |  |  | Total
 | ITC [NAME]
 | ITC FBD Vijayawada
 | Haldiram Noida
 | [NAME]
 | [NAME]
 | Tulsi Speciality Guwahati
 | Terrestrial Foods GK
 | Total
 | Plant [NAME]
 | Plant |  | TC1 | TC3 | TC10 | 5147 | 5158 | 5177 | 6026 | Hermes | Taurus | Taurus(F) | Winner | LR | Trial
 | ITC FBD Coimbatore
 | ITC FBD Guwahati
 | ITC FBD Haridwar
 | ITC FBD Medak
 | ITC FBD Mysore
 | ITC FBD Panchla
 | ITC FBD Pune
 | ITC [NAME]
 | ITC FBD Vijayawada
 | Haldiram Noida
 | [NAME]
 | [NAME]
 | Tulsi Speciality Guwahati
 | Terrestrial Foods GK
Spreadsheet: 724818d1616404339-getting-column-header-based-on-search-search-to-get-header
Sheet: Sheet1

Paris | London | Tokyo | Prague | New York |  |  |  |  | LEM | New York
ABC | PQR | AAA | EDC | WWW |  |  |  |  | BB5 | Tokyo
DEF | MNO | BB5 | 345 | RMN |  |  |  |  | JKL | London
GHI | JKL | CCC | MMM | KLS |  |  |  |  | MNO | London
OOO | STU | DDD |  | LOL |  |  |  |  | 345 | Prague
LEL |  | EEE |  | ROL |  |  |  |  | OOO | Paris
 |  |  |  | LEM
Spreadsheet: 05808771-0549-4ed8-ab18-cd32a579cf3c
Sheet: Sheet1

World and international scheduled services | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
History and Forecasts
 |  | Revenue Passenger [NAME] |  | Departures | Passengers carried
 | Year | World* (billions) | International (billions) | World (millions) | World (billions) | International (billions)
 | 2000 | 3 038 | 1 790 | 21 | 1.7 | 0.5
Annual Growth Rate (2000-2011) |  | +4.8% | +5.3% | +3.3% | +4.6% | +6.5%
 | 2011 | 5 062 | 3 148 | 30 | 2.7 | 1.1
Annual Growth Rate (2011-2020) |  | [NAME] | +5.0% | +3.8% | +4.3% | +5.2%
 | 2020 | 7 631 | 4 884 | 42 | 4 | 1.7
Annual Growth Rate (2020-2030) |  | +4.5% | +4.6% | +3.5% | +4.6% | +5.1%
 | 2030 | 1 1805 | 7 672 | 59 | 6.3 | 2.8
Annual Growth Rate (2011-2030) |  | +4.6% | +4.8% | +3.6% | +4.5% | +5.1%
 |  |  |  |  |  | * international and domestic
Source: International Civil Aviation Organization |  |  |  |  |  | data as of December 2012
Spreadsheet: 58303d1258573022-returning-value-based-on-ranges-overdue-sample
Sheet: Answer

Due Date | Weeks Overdue |  |  | 2009-11-17 00:00:00 |  | Weeks Overdue | Days Overdue
2009-01-01 00:00:00 | 26-52 |  |  |  |  | <2 | <14
2009-03-05 00:00:00 | 26-52 |  |  |  |  | 2-4 | 14-28
2009-06-08 00:00:00 | 12-26 |  |  |  |  | 5-12 | 29-84
2008-06-08 00:00:00 | 52+ |  |  |  |  | 13-26 | 85-182
2009-11-01 00:00:00 | 2-4 |  |  |  |  | 27-52 | 183-364
2009-10-01 00:00:00 | 4-12 |  |  |  |  | >52 | 365+
2009-09-26 00:00:00 | 4-12
Spreadsheet: 1025f918-2487-420b-8dd1-e452d17e40e5
Sheet: 3. Chart

 | Great charts, recommended for you |  |  |  |  |  |  |  | Learn More
 | Excel recommends charts based on the data you enter.
 | Company | Q1 Sales | Q2 Sales
 | A. Datum Corporation | 195449 | 746907
 | Adventure Works | 123721 | 733396
 | Blue Yonder Airlines | 934763 | 246554
 | City Power & Light | 299293 | 674295
 | Coho Vineyard | 228783 | 659385
 | Contoso, Ltd | 239219 | 287989
 | Contoso Pharmaceuticals | 371570 | 644368
 | [NAME] | 579825 | 448399
 | Fabrikam, Inc. | 639630 | 635474
 | Fourth Coffee | 876740 | 567216
 | Graphic Design Institute | 788390 | 540282
 | Humongous Insurance | 682545 | 577599
 | Litware, Inc. | 902264 | 206331
 | Lucerne Publishing | 905906 | 443552
 | Margie's Travel | 289570 | 843834
Spreadsheet: 106825d1304001583-excel-2007-problem-paste-special-transpose-results_must_look_like
Sheet: Sheet1

1 | Company Policies and Procedures (Employee Handbook) Part1 | PIET POMPIES | Q1 | a | 1
2 | Company Policies and Procedures (Employee Handbook) Part1 | PIET POMPIES | Q2 | a | 1
3 | Company Policies and Procedures (Employee Handbook) Part1 | PIET POMPIES | Q3 | b | 0
4 | Company Policies and Procedures (Employee Handbook) Part1 | MIKE TESTING | Q1 | a | 1
5 | Company Policies and Procedures (Employee Handbook) Part1 | MIKE TESTING | Q2 | a | 1
6 | Company Policies and Procedures (Employee Handbook) Part1 | MIKE TESTING | Q3 | b | 0
Spreadsheet: 186420d1350036886-search-beers
Sheet: E

Brewery |  | Beer
Eastwood & Sanders |  | Born to be Mild
 |  | WYBC First Light
Edinburgh Brewing Co |  | EPA
Eldridge pope |  | [NAME] Bitter
 |  | [NAME]
Empire |  | Strikes Back
Enville |  | Ale
 |  | Simpkiss
 |  | Czechmate
 |  | Chain Maker
Ennerdale |  | Liquidator
Elgood’s |  | Golden Newt
Everards |  | Beacon Bitter
 |  | Tiger Best Bitter
 |  | Mild
 |  | Terra Firma Organic Ale
 |  | Sun Chaser
Exe Valley |  | [NAME]
 |  | Exeter Old Bitter
Exmoor |  | Exmoor Ale
 |  | Exmoor Gold
 |  | Exmoor Stag
 |  | Exmoor Beast
 |  | Exmoor Fox
Spreadsheet: 741066d1626792206-data-validation-choose-one-equipment-checkout-ans
Sheet: Equipment

[NAME]'s | Splicer's Used Count | Splicer's Available | Locator's | Locator's Used | Locator's Available | Rodder's | Rodder's Used | Rodder's Available
Spokane Splicer #1 |  |  | Spokane Locator #1 |  |  | Spokane Rodder #1 (300')
Spokane Splicer #2 |  |  | Spokane Locator #2 |  |  | Spokane Rodder #2 (300')
Spokane Splicer #3 |  |  | Spokane Locator #3 |  |  | Spokane Rodder #3 (500')
Spokane Splicer #4 (Repair) |  |  | Spokane Locator #4
Spokane Splicer #5
 | [NAME] | Splicer's Available | Locator List |  |  | Rodder List
[NAME] Tester | Battery Tester Used | Battery Tester Available | Spokane Optical Power Meter | Power Meter Used | Power Meter Available Available
[NAME] Tester #1 |  |  | Spokane Optical Power Meter #1
 | Battery Tester List |  |  | Power [NAME]
Spokane OTDR | Spokane OTDR Used | Spokane OTDR Availble
Spokane OTDR #1
Spokane OTDR #2
 | OTDR List
Spreadsheet: 149306d1333825526-average-of-data-with-dynamic-multiple-criteria-sample2
Sheet: Sheet1

Month | Week | Transaction |  | Start Month | January | End Month | January | April | Week 4
March | Week 4 | 63 |  | Start Week | Week 1 | End Week | Week 5 | May | Week 5
March | Week 4 | 15 |  |  |  |  |  | June
February | Week 4 | 26 |  | Average Result |  |  |  | July
January | Week 5 | 570 |  |  |  |  |  | August
March | Week 4 | 30 |  | This array formula |  |  |  | September
January | Week 1 | 54 |  | AVERAGE(IF(A2:A26=F4,IF(INT(RIGHT(B2:B26,1))>=INT(RIGHT(F5,1)),C2:C26)),IF(A2:A26=H4,IF(INT(RIGHT(B2:B26,1))<=INT(RIGHT(H5,1)),C2:C26))) |  |  |  | October
January | Week 1 | 46 |  | averages the transactions the range I set thru the dropdowns above. |  |  |  | November
June | Week 1 | 46 |  | Example 1 |  |  |  | December |  |  | Example 2
February | Week 4 | 49 |  | If I set it to |  |  |  |  |  |  | If I set it to
March | Week 1 | 49 |  | Start Month | January | End Month | January |  |  |  | Start Month | January | End Month | March
March | Week 4 | 54 |  | Start Week | Week 1 | End Week | Week 5 |  |  |  | Start Week | Week 3 | End Week | Week 2
February | Week 2 | 108 |  | it averages the transaction from |  |  |  |  |  |  | it averages the transactions from
February | Week 3 | 235 |  | January | Week 1 |  |  |  |  |  | January | Week 3
February | Week 3 | 46 |  | January | Week 2 |  |  |  |  |  | January | Week 4
March | Week 4 | 570 |  | January | Week 3 |  |  |  |  |  | January | Week 5
April | Week 2 | 57 |  | January | Week 4 |  |  |  |  |  | March | Week 1
May | Week 3 | 31 |  | January | Week 5 |  |  |  |  |  | March | Week 2
June | Week 1 | 798
April | Week 2 | 131
August | Week 2 | 14 |  | What I'm hoping is this
September | Week 2 | 34 |  | Example 1 of what I want. |  |  |  |  |  |  | Example 2 of what I want
October | Week 4 | 321 |  | If I set it to |  |  |  |  |  |  | If I set it to
October | Week 5 | 87 |  | Start Month | January | End Month | March |  |  |  | Start Month | Februay | End Month | April
June | Week 3 | 97 |  | Start Week | Week 3 | End Week | Week 2 |  |  |  | Start Week | Week 2 | End Week | Week 1
July | Week 2 | 71 |  | it averages the transactions from |  |  |  |  |  |  | it averages the transactions from
 |  |  |  | January | Week 3 |  |  |  |  |  | February | Week 2
 |  |  |  | January | Week 4 |  |  |  |  |  | February | Week 3
 |  |  |  | January | Week 5 |  |  |  |  |  | February | Week 4
 |  |  |  | February | Week 1 |  |  |  |  |  | February | Week 5
 |  |  |  | February | Week 2 |  |  |  |  |  | March | Week 1
 |  |  |  | February | Week 3 |  |  |  |  |  | March | Week 2
 |  |  |  | February | Week 4 |  |  |  |  |  | March | Week 3
 |  |  |  | February | Week 5 |  |  |  |  |  | March | Week 4
 |  |  |  | March | Week 1 |  |  |  |  |  | March | Week 5
 |  |  |  | March | Week 2 |  |  |  |  |  | April | Week 1
Spreadsheet: 295046d1391578613-combine-two-lists-while-matching-column-values-index-match-2-sheets
Sheet: Result

2001 | 2002 | 2003 | 2004 | 2005 | Description
1234 | 1234 |  | 1234 | 1234 | Wagon
 | 1111 | 1111 | 1111 |  | Wheel
 |  |  |  | 3333 | Nail
 |  |  |  | 1101 | Board
 |  |  | 2222 | 2222 | Shovel
1221 | 1221 | 1221 | 1221 | 1221 | Post
8888 |  |  | 8888 | 8888 | Battery
Spreadsheet: 137854d1327410594-calculating-week-and-highlighting-cells-vacation_planner_final_2
Sheet: Data

 | Working Time | Vacation Days Awarded | Employee Name | Day of Joining | Day of Change | Previous Working % | New Working % | Prior Days Off | New Days Off | Total Days Off | Full Vacation Entitlement
 | 0.2 |  |  |  | 2012-04-06 00:00:00 | 0.8 | 0.5
 | 0.4
 | 0.5 |  |  |  | 2012-08-01 00:00:00 | 0.6 | 0
 | 0.6
 | 0.8
 | 1 | 25
 |  |  |  |  | 2012-05-01 00:00:00 | 0.4 | 0.8
 |  |  |  | 2012-01-01 00:00:00 | 2012-07-01 00:00:00 | 1 | 0.5
 |  |  |  |  | 2012-07-01 00:00:00 | 1 | 0.5
 |  |  |  |  | 2012-07-01 00:00:00 | 1 | 0.5
Spreadsheet: 127876d1320667584-autosorting-league-table-by-order-of-importance-league-table
Sheet: Sheet1

 |  | The Do The Bouncy Quiz League
 | Position | Name | P | W | F | A | Points
 | 1st | [NAME] | 1 | 1 | 40 | 0 | 10
 | 2nd | Dr [NAME] | 1 | 0 | 37 | 3 | 8
 | 3rd | Cheeko | 1 | 0 | 37 | 3 | 6
 | 4th | Blue C | 1 | 0 | 34 | 6 | 4
 | 5th | Geomac | 1 | 0 | 32 | 8 | 2
 | 6th | [NAME] | 1 | 0 | 31 | 9 | 1
 | 7th | Billyboys | 1 | 0 | 20 | 20 | 0
 | 8th | [NAME] | 1 | 0 | 20 | 20 | 0
 | 9th
 | 10th
 | 11th
 | 12th
 | 13th
 | 14th
Spreadsheet: 840266d1692616764-populate-data-into-field-based-on-numbers-all-times-required-example-sheet-2-1-
Sheet: Sheet1

[NAME] | Duration | Time of Call
7469193999 | 0 | 19:11:00
7469193999 | 0 | 19:01:00
7469193999 | 0 | 19:00:00
7469193999 | 0 | 17:00:00
7470082888 | 1518 | 19:11:00
7512672111 | 0 | 19:29:00
7512672111 | 0 | 19:30:00
7512672111 | 0 | 20:30:00
7512672111 | 0 | 21:09:00
7776755222 | 272 | 17:00:00
Spreadsheet: 683104d1592489424-combining-3-array-formulas-to-one-collating-from-multiple-sheets-based-on-conditions5
Sheet: Collections

Name | Phone | Date order Received | [NAME] | Disc £ ea | Balance | Paid | Product | Notes/ Special Reqs | Status | Collection Date | Time | Include |  | Rank