tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 08ce55c1-fee3-421c-9de0-6ef5886b2344
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5368.0 International Trade in Goods and Services, Australia
 | TABLE 15a. MERCHANDISE EXPORTS, State and Australia, FOB Value
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
New South Wales ; |  |  | Original | A1829245L | 1988-01-01 00:00:00 | 2012-07-01 00:00:00 | 295 | $ Millions | FLOW | Month | 1
Victoria ; |  |  | Original | A1829246R | 1988-01-01 00:00:00 | 2012-07-01 00:00:00 | 295 | $ Millions | FLOW | Month | 1
Queensland ; |  |  | Original | A1829247T | 1988-01-01 00:00:00 | 2012-07-01 00:00:00 | 295 | $ Millions | FLOW | Month | 1
South Australia ; |  |  | Original | A1829248V | 1988-01-01 00:00:00 | 2012-07-01 00:00:00 | 295 | $ Millions | FLOW | Month | 1
Western Australia ; |  |  | Original | A1829249W | 1988-01-01 00:00:00 | 2012-07-01 00:00:00 | 295 | $ Millions | FLOW | Month | 1
Tasmania ; |  |  | Original | A1829250F | 1988-01-01 00:00:00 | 2012-07-01 00:00:00 | 295 | $ Millions | FLOW | Month | 1
Northern Territory ; |  |  | Original | A1829251J | 1988-01-01 00:00:00 | 2012-07-01 00:00:00 | 295 | $ Millions | FLOW | Month | 1
Australian Capital Territory ; |  |  | Original | A1829252K | 1988-01-01 00:00:00 | 2012-07-01 00:00:00 | 295 | $ Millions | FLOW | Month | 1
State not available for publication ; |  |  | Original | A1829253L | 1988-01-01 00:00:00 | 2012-07-01 00:00:00 | 295 | $ Millions | FLOW | Month | 1
Re-exports ; |  |  | Original | A1829254R | 1988-01-01 00:00:00 | 2012-07-01 00:00:00 | 295 | $ Millions | FLOW | Month | 1
Total (State of origin) ; |  |  | Original | A1829255T | 1988-01-01 00:00:00 | 2012-07-01 00:00:00 | 295 | $ Millions | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 95400d1294991845-sumproduct-and-sumif-help123
Sheet: Exclude

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HFT Hoses
 | Exclude sheet should be based on the [NAME] and Decode sheets
 | Part Level |  |  |  |  |  |  |  |  |  |  |  |  |  | Supplier Level |  | 55/60
 | GC_Part Number | OPCO | Business Unit | Category | Sub-Category | Description | EAQ | Total Spend | Total Bids | [NAME] | Min Savings | Exclude (Y) |  | Unique | [NAME] | Savings | 37° Flare J533b | Exclude | Straight Thread w/ O-Ring | Exclude | O-Ring Face Seal | Exclude | O-Ring Code 62 | Exclude | NPT | Exclude | Flat Face O-Ring | Exclude | O-Ring Code 61 | Exclude | 37° JIC | Exclude | Pipe | Exclude | 24° Cone | Exclude | Code 61 | Exclude | #20 o-ring male x #24 MJIC male | Exclude | Straight Thread w/ O=Ring | Exclude | Tube - Compression | Exclude | JIC | Exclude | Push-In | Exclude | Straight Thread to 37° Flare | Exclude | 3/8" to 1/4" | Exclude | 37° Flare | Exclude | 37° | Exclude | Flat Face | Exclude | Quick Disconnect | Exlcude | O-Ring | Exclude | Quick Disconnect (Connect Under Pressure) | Exclude | Double Pump | Exclude | Single | Exclude | Variable Displacement | Exclude | PTO | Exclude | Axial | Exclude | Commercial P330 Series | Exclude | [NAME] | Exclude | Hand pump | Exclude
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N | 40 / 60 | N |  | N |  | N |  | N |  | N |  | N |  | N |  | N |  | N |  | N |  | N |  | N |  | N |  | N |  | N |  | N |  | N |  | N |  | N |  | N |  | N |  | N |  | N |  | N |  | N |  | N |  | N |  | N |  | N |  | N |  | N
Spreadsheet: chris_germany__1840__DPLcapacitybymonth
Sheet: 1-00

DAYTON CAPACITY : |  |  | 2000-01-01 00:00:00 |  | NYMEX | 2.4
 |  |  |  |  |  | [NAME] | TOTAL | Receipt | Delivered | RISK WORKS
PIPE | RECEIPT | DELIVERED | DELIVERY POINT | FUEL | COMMODITY | DEL CHARGE | VARIABLE | Basis | Basis | Transfer
ANR |  | 0 | Pool to Farmersville (DPL) gate | 0.0451 | 0.0147 | 0 |  | -0.05 |  | 0.105
PEPL |  | 0 | Pool to DPL gate or other point (milage) | 0.0486 | 0.0523 | 0 |  | -0.0775 |  | 0.125
TXG |  | 6174 | zn SL or zn 1 to DPL gate in zn 4 | 0.0337 | 0.0429 | 0 |  | -0.0175 |  | 0.13
TCO |  | 1598 | Leach / Lebanon FT to DPL gate | 0.0223 | 0.0246 | 0
TRUNK |  | 12283 | ELA or WLA to TETCO or [NAME] | 0.0279 | 0.0174 | 0 |  | -0.05 |  | 0.055
TETCO |  | 11881 | Receipt from Trunkline to Market | 0.039 | 0.0723 | 0 |  |  |  | 0.25
GULF |  | 47158 | Receipt from Mainline to Tco | 0.02988 | 0.0192 | 0 |  | 0.03 |  | 0.145
Trunk |  | 6304 | Bourbon / Tuscola | 0.0279 | 0.0174 | 0
Pepl |  | 6247 | Gas City / Tetco / Lebanon | 0.009 | 0.0075 | 0
Tetco |  | 6220 | Farmersville / Lebanon | 0.0043 | 0.0871 | 0
 |  |  |  | OR
Trunk |  | 6304 | Bourbon / Tuscola | 0.0279 | 0.0174 | 0
Pepl |  | 6219 | [NAME] or Tco Maumee | 0.018 | 0.01 | 0
 |  |  | 282 Miles | OR
Trunk |  | 6304 | Bourbon / Tuscola | 0.0279 | 0.0174 | 0
Pepl |  | 6191 | MichCon / Consumers / Union | 0.018 | 0.0125 | 0
 |  |  | 347 - 350 Miles
 |  |  |  | 31 | Days | Jan'99
 |  |  | APPROMIMATE SST AVAILABLE FOR CES USE Daily:
 |  |  |  | 240000 | Daily SST |  | Monthly SST
 |  |  |  | 98700 | Daily DPL |  | Monthly DPL
Spreadsheet: 834121d1687457386-how-do-i-autofill-sequential-numbers-in-a-growing-table-spreadsheet-travel-kopi
Sheet: Finances

# |  | Income | Transport | Food | Snacks | Party | Attractions | [NAME]. | Total
2 |  |  | 39.5 | 10.95 | 14.91 |  |  | 2.16
3 |  |  | 1215.74 | 9.34
4 |  |  | 69.02 | 24.2
5 |  |  | 160.93 | 18.98
6 |  |  |  | 18.56
7 | Total from NZ to DK
8
Spreadsheet: 726216d1617110525-how-to-copy-value-against-similar-description-test
Sheet: Sheet1

 |  | Values
STYLE NAME/NUMBER | COLOR | Sum of S | Sum of M | Sum of L | Sum of XL | Sum of XXL
121-0743MN001-1 | NAVY BLUE | 204 | 306 | 204 | 204 | 102
121-0743MN002-1 | MINT | 204 | 306 | 204 | 204 | 102
121-0743MN003-1 | WHITE | 176 | 258 | 179 | 173 | 88
121-0743MN004-1 | NAVY BLUE | 202 | 303 | 202 | 202 | 101
121-0743MN005-1 | MUSTARD | 204 | 306 | 204 | 204 | 102
121-0743MN006-1 | BLACK | 204 | 306 | 204 | 204 | 102
Grand Total |  | 1194 | 1785 | 1197 | 1191 | 597
Spreadsheet: 106829d1304003044-help-please-timesheet-formula-completed-template-timesheet-fn11-night-allowance-of-1230-to-0800
Sheet: Roster

Fortnight Security Roster
Location
Fn
Week Commencing
Emp No | Name | Monday |  | Hrs | Night A | Tuesday |  | Hrs | Night A | Wednesday |  | Hrs | Night A | Thursday |  | Hrs | Night A | Friday |  | Hrs | Night A | Saturday |  | Hrs | Night A | Sunday |  | Hrs | Night A | Totals | Sun Pre | Nights | BH Double T | BH Allow | Hols
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:00:00 | 08:00:00 |  |  | 23:00:00 | 08:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:00:00 | 18:00:00 |  |  | 08:00:00 | 17:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:00:00 | 08:00:00 |  |  | 20:00:00 | 08:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:00:00 | 07:00:00 |  |  | 13:00:00 | 18:00:00
Totals
Week Commencing
Emp No | Name | Monday |  | Hrs | Night A | Tuesday |  | Hrs | Night A | Wednesday |  | Hrs | Night A | Thursday |  | Hrs | Night A | Friday |  | Hrs | Night A | Saturday |  | Hrs | Night A | Sunday |  | Hrs | Night A | Totals | Sun Pre | Nights | BH Double T | BH Allow | Training
Totals
Where employees work in excess of contract hours please go to timesheet and manually over-right the hours splitting between Contract and Non-Contract |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GRAND TOTAL
Spreadsheet: 1e6f4c11-7872-4495-9dd8-90a3f868bef3
Sheet: Sheet1

ISTITUTO COMPRENSIVO DI EDOLO | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
CORSA CAMPESTRE  29.10.2009
1^ media FEMMINILE
 |  | 1 | BELCASTRO | GIULIA | malonno | 03:52:00
 |  | 2 | MARIOTTI | NOEMI | malonno | [NAME]
 |  | 3 | FIOLETTI | MARIALUISA | edolo | [NAME]
 |  | 4 | PIETROBONI | MARIKA | edolo | 04:12:00
 |  | 5 | BUSCA | VANESSA | edolo | 04:14:00
 |  | 6 | TOLOTTI | NOEMI | malonno | [NAME]
 |  | 7 | TOVIL | AMAL | edolo | 04:23:00
 |  | 8 | LORENZI | CORINNE | malonno | 04:26:00
 |  | 9 | PEDRAZZI | CHIARA | corteno | 04:34:00
 |  | 10 | BRACCAIOLI | ELISA | edolo | 04:37:00
 |  | 11 | GERMANI | ILARIA | edolo | 04:54:00
 |  | 12 | TONINI | CRISTINA | corteno | 04:55:00
 |  | 13 | BOLDINI | PAOLA | malonno | 04:56:00
 |  | 14 | BOLDINI | ELISA | malonno | 04:56:00
 |  | 15 | SAVARDI | CHIARA | corteno | 05:10:00
 |  | 16 | PIETROBONI | [NAME] | edolo | [NAME]
 |  | 17 | DI NAPOLI | ELISA | edolo | [NAME]
 |  | 18 | MORANDA | VERONICA | corteno | 05:19:00
 |  | 19 | SALVADORI | GIULIA | corteno | 05:21:00
 |  | 20 | ALBERTI | LAURA | malonno | 05:22:00
 |  | 21 | CALUFETTI | SARA | malonno
 |  | 22 | TADDEI | [NAME] | edolo
 |  | 23 | PICEN | GIULIA | malonno
 |  | 24 | GIACOMINI | AMANDA | corteno
 |  | 25 | BIANCHI | CHIARA | edolo
 |  | 26 | BIANCHI | SONIA | edolo
 |  | 27 | BRICHETTI | SERENA | edolo
 |  | 28 | RAMUS | LAURA | edolo
 |  | 29 | GHENSI | SABRINA | edolo
 |  | 30 | BRANGI | MANUELA | corteno
 |  | 31 | DELLA VALLE | MARTINA | corteno
 |  | 32 | ROCCA | ASIA | malonno
 |  | 33 | D'ADAMO | TECLA | malonno
 |  | 34 | ZENONI | VALENTINA | edolo
 |  | 35 | FRAULO | ILENIA | edolo
 |  | 36 | GUIZZARDI | [NAME] | edolo
 |  | 37 | FEBBRARI | ALESSIA | edolo
Spreadsheet: 783063d1654548900-formula-should-work-regardless-on-no-of-columns-myexcel
Sheet: SHEET1

questions | task1 | [NAME] | task3 | task4 | task5 | task6 | [NAME] | task8 | task9 | Average
Q1 | y | y | y | y | y | y | y | y | y
Q2 | n | y | na | y | y | y | y | y | y
Q3 | y | y | y | y | p | y | n | y | y
Q4 | y | na | n | y | y | y | y | y | y
Q5 | y | y | y | n | y | y | y | y | y
Spreadsheet: 135577d1326129840-sum-data-by-month-sumbymonth
Sheet: Sheet1

Date | Amount | Month |  |  |  |  | Month | Amount
2012-01-05 00:00:00 | 54 | 1 |  |  |  |  | 1 | 125
2012-01-18 00:00:00 | 5 | 1 |  |  |  |  | 2 | 99
2012-01-31 00:00:00 | 66 | 1 |  |  |  |  | 3 | 0
2012-02-10 00:00:00 | 5 | 2 |  |  |  |  | 4 | 0
2012-02-15 00:00:00 | 50 | 2 |  |  |  |  | 5 | 0
2012-02-28 00:00:00 | 44 | 2 |  |  |  |  | 6 | 0
 |  |  |  |  |  |  | 7 | 0
 |  |  |  |  |  |  | 8 | 0
 |  |  |  |  |  |  | 9 | 0
 |  |  |  |  |  |  | 10 | 0
 |  |  |  |  |  |  | 11 | 0
 |  |  |  |  |  |  | 12 | 0
Spreadsheet: 995e6936-412e-4292-85ba-44588c45d8ad
Sheet: titlurile de calatorie

Perioada |  | [NAME] I |  |  |  |  |  |  |  |  | Simestru II
 |  | [NAME] I |  |  |  | TrimestruII |  |  |  |  | Trimestru III |  |  |  | Trimestru IV
 |  | Lunile |  |  |  | Lunile |  |  |  |  | Lunile |  |  |  | Lunile |  |  |  |  | titluri eliberate in perioada 01.01-30.09.2011
Statul |  | 1 | 2 | 3 |  | 4 | 5 | 6 |  |  | 7 | 8 | 9 |  | 10 | 11 | 12
1 | Ankara |  |  |  |  |  |  |  |  |  | 44 | 18 | 17 |  |  |  |  |  |  | 211
2 | [NAME] |  |  |  |  |  |  |  |  |  | 87 | 53 | 25 |  |  |  |  |  |  | 394
3 | Baku |  |  |  |  |  |  |  |  |  | 13 | 3 | 9 |  |  |  |  |  |  | 94
4 | Beijing |  |  |  |  |  |  |  |  |  | 1 | 10 | 5 |  |  |  |  |  |  | 23
5 | Berlin |  |  |  |  |  |  |  |  |  | 7 | 10 | 14 |  |  |  |  |  |  | 85
6 | [NAME] |  |  |  |  |  |  |  |  |  | 547 | 268 | 219 |  |  |  |  |  |  | 2294
7 | [NAME] |  |  |  |  |  |  |  |  |  | 33 | 23 | 13 |  |  |  |  |  |  | 190
8 | Bucureşti |  |  |  |  |  |  |  |  |  | 18 | 27 | 18 |  |  |  |  |  |  | 177
9 | Budapesta |  |  |  |  |  |  |  |  |  | 23 | 24 | 13 |  |  |  |  |  |  | 97
10 | Frankfurt |  |  |  |  |  |  |  |  |  | 12 | 8 | 7 |  |  |  |  |  |  | 101
11 | Geneva |  |  |  |  |  |  |  |  |  | 17 | 8 | 8 |  |  |  |  |  |  | 86
12 | Istanbul |  |  |  |  |  |  |  |  |  | 105 | 106 | 53 |  |  |  |  |  |  | 738
13 | Kiev |  |  |  |  |  |  |  |  |  | 37 | 31 | 24 |  |  |  |  |  |  | 306
14 | Lisabona |  |  |  |  |  |  |  |  |  | 70 | 34 | 21 |  |  |  |  |  |  | 262
15 | Londra |  |  |  |  |  |  |  |  |  | 44 | 51 | 54 |  |  |  |  |  |  | 536
16 | Minsk |  |  |  |  |  |  |  |  |  | 0 | 57 | 53
17 | [NAME] |  |  |  |  |  |  |  |  |  | 948 | 985 | 859 |  |  |  |  |  |  | 6565
18 | Odesa |  |  |  |  |  |  |  |  |  | 68 | 89 | 65 |  |  |  |  |  |  | 483
19 | Paris |  |  |  |  |  |  |  |  |  | 244
20 | Praga |  |  |  |  |  |  |  |  |  | 14 | 11 | 24 |  |  |  |  |  |  | 105
21 | Riga |  |  |  |  |  |  |  |  |  | 2 | 2 | 0 |  |  |  |  |  |  | 6
22 | Roma |  |  |  |  |  |  |  |  |  | 253 | 138 | 116 |  |  |  |  |  |  | 1175
23 | Sofia |  |  |  |  |  |  |  |  |  | 5 | 2 | 1 |  |  |  |  |  |  | 16
24 | Stockholm |  |  |  |  |  |  |  |  |  | 4 | 3 | 1 |  |  |  |  |  |  | 17
25 | Tallinn |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 0
26 | Tel.Aviv |  |  |  |  |  |  |  |  |  |  | 17 | 8 |  |  |  |  |  |  | 92
27 | Varşovia |  |  |  |  |  |  |  |  |  | 1 | 0 | 2 |  |  |  |  |  |  | 17
28 | Viena |  |  |  |  |  |  |  |  |  | 25 | 18 | 24 |  |  |  |  |  |  | 198
29 | Vilnius |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 |  |  |  |  |  |  | 2
30 | Washington DC |  |  |  |  |  |  |  |  |  | 33 | 24 | 31 |  |  |  |  |  |  | 271
31 | Iaşi |  |  |  |  |  |  |  |  |  | 10 | 0 | 11 |  |  |  |  |  |  | 68
32 | Madrid |  |  |  |  |  |  |  |  |  | 29 | 31 | 17 |  |  |  |  |  |  | 168
 | TOTAL
Spreadsheet: 173980d1344876765-how-to-move-rounddown-amount-to-a-new-cell-book2
Sheet: Sheet1

Balance | Daily % | Earnings | I Want the Change to round off to a new cell to add up | Change
10000 | 0.0095 |  | 0.00----------------------------------------------------------------> | 0
 | 0.0095 |  | When it reaches a whole number it puts it into the Balance | 0.9
 | 0.0095 |  | 0.81---------------------------->  <--------------------------- 1.00 | 1.71 | 0.71 change left to biuld
 | 0.0195 |  | 0.61---------------------------->  <---------------------------1.00 | 1.32 | 0.32 change left to biuld
 | 0.0195 |  | 0.52---------------------------------------------------------------> | 0.84
 | 0.0195 |  | 0.51--------------------------->   <---------------------------1.00 | 1.35 | 0.35 change left to biuld
 | 0.0195
 | 0.0095 |  | I need the Balabce to always be whole numbers
 | 0.0095
 | 0.0095
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0095
 | 0.0095
 | 0.0095
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0095
 | 0.0095
 | 0.0095
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0095
 | 0.0095
 | 0.0095
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0095
 | 0.0095
 | 0.0095
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0095
 | 0.0095
 | 0.0095
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0095
 | 0.0095
 | 0.0095
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0095
 | 0.0095
 | 0.0095
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0095
 | 0.0095
 | 0.0095
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0095
 | 0.0095
 | 0.0095
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0095
 | 0.0095
 | 0.0095
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0095
 | 0.0095
 | 0.0095
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0095
 | 0.0095
 | 0.0095
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0095
 | 0.0095
Spreadsheet: 767935d1644750035-what-if-analysis-to-calculate-the-effect-of-new-pricing-example-calculation
Sheet: Sheet2

Organization | Min Order | [NAME] | Product 1 | Product 2 | Product 3 | Product 4
Facility/Reseller | 10 | 49 | 28.95 | 28.95 | 49.95 | 49.95
Facility/Reseller | 50 | 119 | 27.5025 | 27.5025 | 39.95001 | 39.95001
Facility/Reseller | 120 |  | 26.95245 | 26.95245 | 31.948022997 | 31.948022997
Facility/Reseller |  | no limit | 24.94718772 | 24.94718772 | 23.4 | 23.4
Distributor | 1200 | 11880 | 20 | 20 | 24 | 24
Distributor | 12000 | 35880 | 19.7 | 19.7 | 23.65 | 23.65
Distributor | 36000 | 119880 | 19.5 | 19.5 | 23.4 | 23.4
Distributor | 120000 | no limit | 19.2 | 19.2 | 23.05 | 23.05
Spreadsheet: 735241d1622788645-how-to-automatically-allocate-stock-to-pallet-with-a-limit-space-packing-list-template
Sheet: Sheet 1

 | Pallet type | [NAME] ctn | ctn size ([NAME]) | Note
 | Steel rack 1 | 60 | 580*380*125
 | Steel rack 2 | 35 | 580*380*200
 | Steel rack 3 | 30 | 580*380*250
 | Steel rack 4 | 5 | 580*380*125
 |  | 35 | 580*380*200
 | Steel rack 5 | 20 | 580*380*125
 |  | 20 | 580*380*250
 | Plastic pallet |  |  | the leftover qty
 | Stock list
STT | Item | Carton type | Total Qty |  |  |  |  | Steel rack 1 |  |  |  | Steel rack 2 |  |  |  | Steel rack 2a |  |  |  | Steel rack 2b |  |  |  | Steel rack 3 |  |  |  | Steel rack 4 |  |  |  | Steel rack 5 |  |  |  | Plastic pallet
1 | SKU #9 | 580*380*200 | 24 |  |  |  |  | SKU #7 |  | 14 |  | SKU #8 |  | 20 |  | SKU #9 |  | 24 |  | SKU #4 |  | 6 |  | SKU #23 | 580*380*250 | 10 |  | SKU #12 |  | 8 |  | SKU #10 |  | 3 |  | SKU #27 |  | 20
2 | SKU #8 | 580*380*200 | 20 |  |  |  |  | SKU #6 |  | 10 |  | SKU #3 |  | 9 |  | SKU #4 |  | 11 |  | SKU #2 |  | 8 |  | SKU #26 | 580*380*250 | 20 |  | SKU #11 |  | 3 |  | SKU #19 |  | 17
3 | SKU #7 | 580*380*125 | 14 |  |  |  |  | SKU #5 |  | 32 |  | SKU #16 |  | 6 |  |  |  |  |  | SKU #15 |  | 4 |  |  |  |  |  | SKU #1 |  | 24 |  | SKU #23 |  | 20
4 | SKU #6 | 580*380*125 | 10 |  |  |  |  | SKU #18 |  | 1 |  |  |  |  |  |  |  |  |  | SKU #14 |  | 13 |  |  |  |  |  | SKU #10 |  | 5
5 | SKU #5 | 580*380*125 | 32 |  |  |  |  | SKU #10 |  | 2 |  |  |  |  |  |  |  |  |  | SKU #13 |  | 4
6 | SKU #4 | 580*380*200 | 17 |  |  |  |  | SKU #17 |  | 1
7 | SKU #3 | 580*380*200 | 9
8 | SKU #2 | 580*380*200 | 8
9 | SKU #18 | 580*380*125 | 1
10 | SKU #17 | 580*380*125 | 1
11 | SKU #16 | 580*380*200 | 6
12 | SKU #15 | 580*380*200 | 4
13 | SKU #14 | 580*380*200 | 13
14 | SKU #13 | 580*380*200 | 4
15 | SKU #12 | 580*380*200 | 8
16 | SKU #11 | 580*380*200 | 3
17 | SKU #10 | 580*380*125 | 10
18 | SKU #1 | 580*380*200 | 24
19 | SKU #18 | 580*380*200 | 14
20 | SKU #19 | 580*380*125 | 17
21 | SKU #23 | 580*380*250 | 30
22 | SKU #26 | 580*380*250 | 20
23 | SKU #27 | 580*380*250 | 20
Spreadsheet: 217397d1362060746-golf-spreadsheet-mystery-game-2013-golf-trip-debug
Sheet: Afternoon 2

Hole | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Total
Par |  |  |  |  |  |  |  |  |  | 0 |  |  | Front | Score | Prize | Rank |  | Name | Score | Rank | Prize | Closest | Payout | TP
[NAME] |  |  |  |  |  |  |  |  |  | 0.0001 |  | 1 | [NAME] | 0.0001 | 0 | 0 | 1 | [NAME] | 0 | 1 | 0 | 0 | 80 | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | RYAN | 0 | 1 | 0 | 0 | 60 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | [NAME] | 0 | 1 | 0 | 0 | 40 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | JOE | 0 | 1 | 0 | 0 | 0 | 0
SCOTT FRED UNCLE [NAME] |  |  |  |  |  |  |  |  |  | 0.0005 |  | 1 | SCOTT FRED UNCLE [NAME] | 0.0005 | 0 | 0 | 1 | HATCH | 0 | 1 | 0 | 0 | 0 | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | DICK | 0 | 1 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SHAWN | 0 | 1 | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BOB | 0 | 1 | 0 | 0 |  | 0
[NAME] |  |  |  |  |  |  |  |  |  | 0.0009 |  | 1 | [NAME] | 0.0009 | 0 |  |  | SCOTT | 0 | 1 | 0 | 0 |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KIP | 0 | 1 | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GREG | 0 | 1 | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0 | 1 | 0 | 0 |  | 0
HATCH   [NAME]     JOE |  |  |  |  |  |  |  |  |  | 0.0013 |  | 1 | HATCH   [NAME]     JOE | 0.0013 | 0 |  |  | [NAME] | 0 | 1 | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KEITH | 0 | 1 | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0 | 1 | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAVE | 0 | 1 | 0 | 0 |  | 0
[NAME] |  |  |  |  |  |  |  |  |  | 0.0017 |  | 1 | [NAME] | 0.0017 | 0 |  |  | UNCLE ROB | 0 | 1 | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0 | 1 | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GEOFF | 0 | 1 | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0 | 1 | 0 | 0 |  | 0
[NAME] |  |  |  |  |  |  |  |  |  | 0.0021 |  | 1 | [NAME] | 0.0021 | 0 |  |  | [NAME] | 0 | 1 | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FRED | 0 | 1 | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0 | 1 | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0 | 1 | 0 | 0 |  | 0
Closest to the Pin |  |  | Hole |  | Prize
 |  |  |  |  | 20
 |  |  |  |  | 20
 |  |  |  |  | 20
Spreadsheet: 736107d1623352207-subtotal-count-all-fields-including-blanks-in-a-filtered-range-subtotalsample111
Sheet: Sheet1

 | My filter includes values (1, 2, "") | ColA | ColB
 | + | 1 | A
 | + | 2
 | + |  | s
 |  | 5
 | +
 | + |  | d
 | + | 2 | x
 |  | 4 | d
 | + | 2 | f
 | +
 | + | 1
 | Subtotal shows --> | 5
 | should be --> | 9
Spreadsheet: 702392d1604329219-solver-with-pivot-tables-or-slicer-sampledata-pivot
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Example Filters | Test type
 |  |  |  |  |  |  |  |  | Years Experience | <5000
 |  |  |  |  |  |  |  |  | Previous Clients | 1-5
 |  |  |  |  |  |  |  |  | Years Experience | (All) | <- Ideally would hope to use "by changing variable cells" with these two filters and list out filter name, A/E value, Row Label for all rows which exceed hard value of "2" when it finds highest "Average of A/E" (which I realise is dynamic)
SALES BY MONTH |  |  |  |  |  |  |  |  | Previous Clients | (All)
 |  |  | TABLE
ID | MONTH | Agent | Years Experience | Previous Clients | Sales | Expected Sales | A/E |  | Row Labels | Sum of Expected Sales | Sum of Sales | Average of A/E
32 | APR | [NAME] | 3 | 3 | 1575 | 8012 |  |  | [NAME] | 34822 | 84254 | 2.443819769948981
31 | APR | [NAME] | 4 | 3 | 9533 | 9335 |  |  | [NAME] | 31740 | 36780 | 1.171653986249821
30 | APR | [NAME] | 7 | 4 | 19601 | 8681 |  |  | Christian | 32342 | 28356 | 0.8883525883756821
29 | APR | [NAME] | 5 | 4 | 8585 | 7215 |  |  | [NAME] | 34084 | 27991 | 0.8471068908581033
28 | APR | Christian | 3 | 5 | 8453 | 8453 |  |  | [NAME] | 35619 | 27666 | 0.7658299273976388
27 | APR | Kirsty | 3 | 5 | 3205 | 8577 |  |  | Kirsty | 31774 | 22160 | 0.7331550862679996
26 | APR | Nick | 2 | 5 | 1778 | 7325 |  |  | Nick | 34734 | 14834 | 0.4052024239175973
25 | APR | [NAME] | 1 | 4 | 9384 | 8884 |  |  | [NAME] | 32859 | 2956 | 0.09318177487933046
24 | MAR | [NAME] |  |  | 1111 | 7865
23 | MAR | [NAME] |  |  | 9971 | 7199
22 | MAR | [NAME] |  |  | 17554 | 9576
21 | MAR | [NAME] |  |  | 9000 | 8183
20 | MAR | Christian |  |  | 9039 | 8223
19 | MAR | Kirsty |  |  | 7914 | 7261
18 | MAR | Nick |  |  | 1691 | 8364
17 | MAR | [NAME] |  |  | 9419 | 9684
16 | FEB | [NAME] |  |  | 270 | 7739
15 | FEB | [NAME] |  |  | 8711 | 7181
14 | FEB | [NAME] |  |  | 22584 | 8139
13 | FEB | [NAME] |  |  | 9402 | 9503
12 | FEB | Christian |  |  | 7899 | 7139
11 | FEB | Kirsty |  |  | 3301 | 8883
10 | FEB | Nick |  |  | 9444 | 9742
9 | FEB | [NAME] |  |  | 8188 | 8576
8 | JAN | [NAME] |  |  | 0 | 9243
7 | JAN | [NAME] |  |  | 8565 | 8025
6 | JAN | [NAME] |  |  | 24515 | 8426
5 | JAN | [NAME] |  |  | 1004 | 9183
4 | JAN | Christian |  |  | 2965 | 8527
3 | JAN | Kirsty |  |  | 7740 | 7053
2 | JAN | Nick |  |  | 1921 | 9303
1 | JAN | [NAME] |  |  | 675 | 8475
Spreadsheet: 73668d1274288267-vlookup-error-on-letter-a-vlookuperror
Sheet: Sheet1

 |  | <<,error if word begins with a
 |  | <<no error if it doesn’t
LOOKUP TABLE |  |  |  |  |  |  | SOURCE
 | a |  |  |  |  |  | Furniture and cabinet makers
 | b |  |  |  |  |  | Decorators & Painters
 | c |  |  |  |  |  | Lighting suppliers and installers
 | d |  |  |  |  |  | Tile installers
 | e |  |  |  |  |  | Custom iron forgers
 | f |  |  |  |  |  | area rugs
 | g |  |  |  |  |  | Stained glass designers
 | h |  |  |  |  |  | Floor & masonry refinishing
 | i |  |  |  |  |  | Flooring contractors
 | j |  |  |  |  |  | Electricians