tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 810560d1671850387-combine-data-in-2-rows-into-1-single-row-s666-pq-combine-data-in-4-rows-into-1-single-row
Sheet: Output

 | Team Name |  | Result |  | PREPLAY_LAST_TRADED_PRICE |  | PREPLAY_MIN_PRICE |  | PREPLAY_MAX_PRICE |  | INPLAY_MIN_PRICE |  | INPLAY_MAX_PRICE
Date | T1 | T2 | T1 result | T2 result | P_LTP T1 | P_LTP T2 | P_MIN T1 | P_MIN T2 | P_MAX T1 | P_MAX T2 | I_MIN T1 | I_MIN T2 | I_MAX T1 | I_MAX T2
2018-03-03 00:00:00 | Hawthorn | Western Bulldogs | L | W | 2.12 | 1.89 | 2 | 1.67 | 2.46 | 1.89 | 1.64 | 1.05 | 4 | 1.34
SETT_DATE | SelectionName.1 | SelectionName.2 | Result.1 | Result.2 | LastMatchedPrice.1 | LastMatchedPrice.2 | MinPrice.1 | MinPrice.2 | MaxPrice.1 | MaxPrice.2 | InplayMinPrice.1 | InplayMinPrice.2 | InplayMaxPrice.1 | InplayMaxPrice.2
2018-03-03 00:00:00 | Hawthorn | Western Bulldogs | L | W | 2.12 | 1.89 | 2 | 1.67 | 2.46 | 1.89 | 1.64 | 1.05 | 4 | 1.34
2018-03-03 00:00:00 | Sydney Swans | Brisbane Lions | W | L | 1.3 | 3.8 | 1.27 | 3.4 | 1.4 | 4.4 | 1.27 | 1.01 | 1.76 | 1.22
2018-03-04 00:00:00 | Gold Coast Suns | Geelong Cats | W | L | 1.83 | 2.12 | 1.83 | 1.84 | 2.18 | 2.16 | 1.83 | 1.34 | 1.48 | 3.05
2018-03-07 00:00:00 | Richmond | North Melbourne | W | L | 1.24 | 5.2 | 1.18 | 4.3 | 1.29 | 5.3 | 1.18 | 1.01 | 1.47 | 110
2018-03-08 00:00:00 | [NAME] | Melbourne Demons | L | W | 2.88 | 1.48 | 2.84 | 1.46 | 3.1 | 1.55 | 1.46 | 1.01 | 8 | 2.26
2018-03-09 00:00:00 | GWS Giants | Sydney Swans | L | W | 2.06 | 1.94 | 2 | 1.9 | 2.1 | 2 | 1.3 | 1.01 | 50 | 3.15
Spreadsheet: 546650d1510148691-help-with-gauge-graph-please-gauge-graph-2
Sheet: Sheet2

Speedometer Data
Start | 0 | 0
Red | 10 | 10
Red | 10 | 20
Yellow | 10 | 30
Yellow | 15 | 45
Yellow | 15 | 60
Green | 15 | 75
Green | 15 | 90
Green | 10 | 100
Blank
Pointer Data
Value | 90
[NAME] | 2
End | 108
Spreadsheet: 196990d1354180674-min-max-axis-options-issue-songlengthsvsweekscharted
Sheet: 2003

Artist | [NAME] | [NAME] | Weeks Charted
Matchbox Twenty | Unwell | 03:58:00 | 41
Trapt | Headstrong | 04:46:00 | 36
Lil Jon & The East Side Boyz (feat. [NAME]) | Get Low | 05:34:00 | 35
Chingy | Right Thurr | 04:11:00 | 33
Nelly (feat. P. Diddy & [NAME]) | [NAME] | 04:54:00 | 27
Santana (feat. [NAME] or [NAME]) | Why Don't You & I | 03:52:00 | 23
Staind | So Far Away | 04:04:00 | 22
YoungBloodz (feat. [NAME]) | Damn! | 04:58:00 | 21
Beyoncé (feat. [NAME]) | [NAME] | 04:05:00 | 20
Keith Urban | Who Wouldn't Wanna Be Me | 04:16:00 | 20
Spreadsheet: 154330d1336386721-excel-2007-complex-dynamic-chart-829412
Sheet: Data

Region | Area | Number of Buildings | Total Floor Area Sq m | Number of Windows | Number of Doors
East Midlands | Derby City | 22 | 62394 | 14346 | 2854 |  |  | 3
East Midlands | Derbyshire County | 69 | 103122.2 | 75207 | 7945.4 |  |  |  |  |  |  |  |  |  |  |  | Number of Buildings
East Midlands | Leicester City | 18 | 25013.3 | 22327 | 767 |  |  | 1 |  |  |  |  |  |  |  |  | Total Floor Area Sq m
East Midlands | Leicestershire County | 26 | 51493 | 35842 | 1396 |  |  |  |  |  |  |  |  |  |  |  | Number of Windows
East Midlands | Lincolnshire | 65 | 48310 | 38767 | 871 |  |  |  |  |  |  |  |  |  |  |  | Number of Doors
East Midlands | [NAME] | 27 | 20217 | 19211 | 367
East Midlands | Northamptonshire | 36 | 52232 | 8722 | 200
East Midlands | Nottingham City | 33 | 35577 | 5623 | 567
East Midlands | Nottinghamshire County | 48 | 64867 | 45239 | 3127 |  |  |  |  |  |  |  |  |  |  |  | East Midlands
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | East of England
East of England | Bedfordshire | 38 | 32054 | 28761 | 3831.62 |  |  |  |  |  |  |  |  |  |  |  | London
East of England | Cambridgeshire | 55 | 41643 | 54834 | 6128
East of England | Great Yarmouth | 32 | 17473 | 16481 | 359
East of England | Hertfordshire | 58 | 53582 | 47836 | 1343
East of England | Luton | 20 | 14996 | 11629 | 746
East of England | Mid Essex | 31 | 15570 | 12456 | 983
East of England | Norfolk | 87 | 76027 | 71025 | 8058
East of England | North East Essex | 31 | 41330 | 38843 | 1455.579999999999
East of England | Peterborough | 28 | 24015 | 23690 | 829
East of England | South East Essex | 42 | 19472 | 16585 | 1158
East of England | South West Essex | 47 | 21353 | 19251 | 459
East of England | Suffolk | 36 | 57447 | 23932 | 229
East of England | West Essex | 41 | 20157 | 6612.099999999999 | 954
London | Barking and [NAME] | 16 | 27592 | 26087 | 4275
London | Barnet | 21 | 56883.98000000001 | 52077 | 3456
London | Bexley Care Trust | 18 | 8884 | 7739 | 7634
London | Brent Teaching | 8 | 27239.09 | 23166 | 3064
London | Bromley | 44 | 16939 | 17930 | 9345
London | Camden | 26 | 53599.55 | 50009.36 | 1354
London | City and Hackney | 27 | 35811.55 | 34056 | 2361
London | Croydon | 21 | 15437 | 4478 | 1635
London | Ealing | 24 | 24983.86 | 15118 | 5346
London | Enfield | 15 | 20155 | 3412 | 3217
London | Greenwich | 30 | 15880 | 14417 | 3657
London | Hammersmith and Fulham | 18 | 11907.9 | 3464 | 4356
London | Haringey | 17 | 24801 | 18259 | 3458
London | [NAME] | 16 | 11402 | 9233 | 1123
London | Havering | 16 | 37396 | 35627 | 4445
London | [NAME] | 22 | 16073 | 12697 | 3846
London | Hounslow | 11 | 18677.57 | 13636 | 5184
London | Islington | 19 | 22150.57 | 18905.78 | 7265
Spreadsheet: 99610d1298227035-find-value-associated-with-date-vlookuptoday
Sheet: Sheet1

Date | Loan Amt
2010-01-01 00:00:00 | 100000
2010-02-01 00:00:00
2010-03-01 00:00:00
2010-04-01 00:00:00
2010-05-01 00:00:00
2010-06-01 00:00:00
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
2011-03-01 00:00:00
2011-04-01 00:00:00
2011-05-01 00:00:00
2011-06-01 00:00:00
2011-07-01 00:00:00
2011-08-01 00:00:00
2011-09-01 00:00:00
2011-10-01 00:00:00
2011-11-01 00:00:00
2011-12-01 00:00:00
2012-01-01 00:00:00
2012-02-01 00:00:00
2012-03-01 00:00:00
2012-04-01 00:00:00
2012-05-01 00:00:00
2012-06-01 00:00:00
2012-07-01 00:00:00
2012-08-01 00:00:00
2012-09-01 00:00:00
2012-10-01 00:00:00
Spreadsheet: 139503d1328279044-excel-2007-countif-problem-2011-stats
Sheet: ESP

Pos | Driver | Team | Nation | Points | Laps | [NAME] | Grid | Gained | Classification | Race Distance | Qualifying Time
1 | [NAME] |  |  | 25 | 66 | 00:01:27.162000 | 2 |  | 1 |  | 00:01:21.181000
2 | [NAME] |  |  | 18 | 66 | 00:01:26.727000 | 3 |  | 2 |  | 00:01:21.961000
3 | [NAME] |  |  | 15 | 66 | 00:01:27.518000 | 5 |  | 3 |  | 00:01:21.996000
4 | [NAME] |  |  | 12 | 66 | 00:01:27.187000 | 1 |  | 4 |  | 00:01:20.981000
5 | [NAME] |  |  | 10 | 65 | 00:01:28.737000 | 4 |  | 5 |  | 00:01:21.964000
6 | [NAME] |  |  | 8 | 65 | 00:01:29.463000 | 10 |  | 6 |  | 00:01:22.671000
7 | [NAME] |  |  | 6 | 65 | 00:01:29.155000 | 7 |  | 7 |  | 00:01:22.599000
8 | [NAME] |  |  | 4 | 65 | 00:01:26.958000 | 24 |  | 8
9 | [NAME] |  |  | 2 | 65 | 00:01:27.247000 | 12 |  | 9 |  | 00:01:23.367000
10 | [NAME] |  |  | 1 | 65 | 00:01:27.615000 | 14 |  | 10 |  | 00:01:23.702000
11 | [NAME] |  |  | 0 | 65 | 00:01:29.592000 | 6 |  | 11 |  | 00:01:22.471000
12 | [NAME] |  |  | 0 | 65 | 00:01:29.469000 | 16 |  | 12 |  | 00:01:26.126000
13 | [NAME] |  |  | 0 | 65 | 00:01:28.791000 | 17 |  | 13 |  | 00:01:26.571000
14 | Sebastien Buemi |  |  | 0 | 65 | 00:01:30.049000 | 11 |  | 14 |  | 00:01:23.231000
15 | Pastor Maldonado |  |  | 0 | 65 | 00:01:29.391000 | 9 |  | 15 |  | 00:01:22.952000
16 | [NAME] |  |  | 0 | 64 | 00:01:29.132000 | 13 |  | 16 |  | 00:01:23.694000
17 | [NAME] |  |  | 0 | 64 | 00:01:26.891000 | 19 |  | 17 |  | 00:01:26.910000
18 | Jarno [NAME] |  |  | 0 | 64 | 00:01:30.783000 | 18 |  | 18 |  | 00:01:26.521000
19 | [NAME] |  |  | 0 | 63 | 00:01:31.635000 | 20 |  | 19 |  | 00:01:27.315000
20 | [NAME] |  |  | 0 | 62 | 00:01:32.549000 | 23 |  | 20 |  | 00:01:28.556000
21 | Narain Karthikeyan |  |  | 0 | 61 | 00:01:32.848000 | 22 |  | 21 |  | 00:01:27.908000
22 | [NAME] |  |  | - | 57 | 00:01:29.081000 | 8 |  | RET |  | 00:01:22.888000
23 | [NAME] |  |  | - | 47 | 00:01:30.618000 | 15 |  | RET |  | 00:01:25.403000
24 | [NAME] |  |  | - | 27 | 00:01:33.884000 | 21 |  | RET |  | 00:01:27.809000
Spreadsheet: 273680d1382843574-looking-up-and-returning-a-different-cell-kpicalculator
Sheet: Sheet1

 |  | NAME
 | Deven
Spreadsheet: 6118c686-6dd1-4d9b-a9f3-ee01b98cbf60
Sheet: Sheet1

CERES UNIFIED SCHOOL DISTRICT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
WAREHOUSE SUPPLY ORDER FORM
SITE: |  |  |  |  |  | DATE:
CODE: |  |  |  |  |  | NAME:
 |  | please include dashes ( "-") as part of the code
APPROVED BY:
CATEGORICAL SCHOOL PLAN REFERENCE:
ED. SERVICES APPROVAL: ___________________________________________
NOTE: Classification code MUST be complete or order will be returned.
CODE # | QTY | FILLED | UNIT | UNIT COST | TOTAL |  | [NAME]
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  | Page total | 0
Spreadsheet: 194415d1353161076-using-excel-to-do-solver-basketball-fantasy-sheet_final
Sheet: Solver_setup

Name | Position PF | Position C | Position SG | Position PG | Sum Position | Salary | Projections
Blake Griffin |  |  |  |  |  | 14250 | 38.7
[NAME] |  |  |  |  |  | 11549 | 31.48
Jared Jeffries |  |  |  |  |  | 4350 | 14.55 |  |  | = Range not included in cells to be change by solver.
[NAME] |  |  |  |  |  | 13850 | 27.8
[NAME] |  |  |  |  |  | 3000 | 1.78
[NAME] |  |  |  |  |  | 8850 | 22.3 |  | As [NAME] wanted a team with only PG, SG, SF and C players
LaMarcus Aldridge |  |  |  |  |  | 15450 | 36.95 |  | all players with only SF positions have been removed.
Ronny Turiaf |  |  |  |  |  | 4550 | 11.43
[NAME] |  |  |  |  |  | 10750 | 20.85 |  | Players who can both play SF and another position have been
[NAME] |  |  |  |  |  | 7150 | 4.45 |  | have been "stripped" of their SF position.
[NAME] |  |  |  |  |  | 7800 | 9.03
Jamal Crawford |  |  |  |  |  | 11100 | 29.15
[NAME] |  |  |  |  |  | 7550 | 15.65
Nate Robinson |  |  |  |  |  | 7950 | 3.58
[NAME] |  |  |  |  |  | 3400 | 11.85
[NAME] |  |  |  |  |  | 3000 | 0
[NAME] |  |  |  |  |  | 5550 | 1.43
[NAME] |  |  |  |  |  | 5000 | 4.65
[NAME] |  |  |  |  |  | 12000 | 23.3
Thabo Sefolosha |  |  |  |  |  | 6650 | 13.45
[NAME] |  |  |  |  |  | 11150 | 0.43
[NAME] |  |  |  |  |  | 3950 | 5.53
[NAME] |  |  |  |  |  | 3000 | 16.23
[NAME] |  |  |  |  |  | 3400 | 1.33
[NAME] |  |  |  |  |  | 6900 | 12.33
[NAME] |  |  |  |  |  | 3500 | 1.9
[NAME] |  |  |  |  |  | 3100 | 7.53
[NAME] |  |  |  |  |  | 3450 | 1
[NAME] |  |  |  |  |  | 4850 | 13.98
[NAME] |  |  |  |  |  | 9150 | 21.13
[NAME] |  |  |  |  |  | 4250 | 4.58
[NAME] |  |  |  |  |  | 6650 | 16.93
Meyers Leonard |  |  |  |  |  | 6650 | 3.13
Nazr Mohammed |  |  |  |  |  | 3550 | 3.58
[NAME] |  |  |  |  |  | 3000 | 35.08
[NAME] |  |  |  |  |  | 15500 | 34.33
Damian Lillard |  |  |  |  |  | 11750 | 20.58
[NAME] |  |  |  |  |  | 3000 | 3.48
[NAME] |  |  |  |  |  | 3000 | 11.98
[NAME] |  |  |  |  |  | 3000 | 16.2
[NAME] |  |  |  |  |  | 3000 | 23.3
[NAME] |  |  |  |  |  | 3100 | 10.38
[NAME] |  |  |  |  |  | 14550 | 11.43
[NAME] |  |  |  |  |  | 3000 | 1.6
[NAME] |  |  |  |  |  | 10600 | 21.58
[NAME] |  |  |  |  |  | 6400 | 16.2
[NAME] |  |  |  |  |  | 6750 | 2.23
[NAME] |  |  |  |  |  | 3450 | 7.53
[NAME] |  |  |  |  |  | 5500 | 7.53
[NAME] |  |  |  |  |  | 7900 | 20.85
[NAME] |  |  |  |  |  | 3050 | 0.43
Total
 | Position PF | Position C | Position SG | Position PG
Needed | 2 | 1 | 2 | 2
Total cost |  | Constraint | 90000
Object function |  | To be mazimized
Spreadsheet: andy_zipper__175__DYNEGY-ICE VOL Apr23
Sheet: Enron Activity - Dynegy Direct

DYNEGY DIRECT
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Note: Total Activity for Dynegy Direct is not available, therefore Enron's percentage can not be calculated
Enron North America - Dynegy Direct |  |  |  |  | Enron Power Marketing - Dynegy Direct |  |  |  |  | Enron Global Liquids - Dynegy Direct
 |  | Data |  |  |  |  | Data |  |  |  |  | Data
Major Commodity | Enron Trader | Transactions | Notional Volume |  | Major Commodity | Enron Trader | Transactions | Notional Volume |  | Major Commodity | Enron Trader | Transactions | Notional Volume
US Natural Gas | [NAME] | 3 | 15000 |  | Power | [NAME] | 1 | 800 |  | (blank) | No Activity | 1 | 0
 | [NAME] | 2 | 10000 |  | Power Total |  | 1 | 800 |  | (blank) Total |  | 1 | 0
 | [NAME] | 2 | 10000 |  | Grand Total |  | 1 | 800 |  | Grand Total |  | 1 | 0
US Natural Gas Total |  | 7 | 35000
Grand Total |  | 7 | 35000
Spreadsheet: 679859d1590660733-skipping-results-from-if-within-average-example2
Sheet: Sheet1

… other Data… | 6651.595
… other Data… | 98.02283346134152
… other Data… | 108.925
… other Data… | 6773.121163363504 |  |  | include only bold values and when there is no X underneath
 | 7028.483696107212
… other Data… | 4648.611999999999
… other Data… | 93.41273041474655
… other Data… | 85.075
… other Data… | 5171.449421137235
… other Data… | 6492.355179613591
 | X
… other Data… | 7284.486
… other Data… | 99.04825908858167
… other Data… | 97.13333333333333
… other Data… | 7344.495066421559
 | 7502.429018010949
 | X
… other Data… | 6651.595
… other Data… | 98.02283346134152
… other Data… | 86.66666666666664
… other Data… | 6773.121163363504
 | 7810.035195441871
… other Data… | 6471.229
… other Data… | 93.9272753456221
… other Data… | 95.56666666666668
… other Data… | 7040.274624217063
 | 7498.601995384142
AVERAGE without X = |  | ? |  | correct result should be 7445,7
Spreadsheet: 51052d1250623348-combo-box-totaling-combobox-2-
Sheet: Sheet1

2 |  |  |  |  |  | [NAME]
 | Total | 954
 | Apportion
 |  | 1 |  |  | 0.02
 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
Evenly | Office Supply
Percentage | Office Supply
Spreadsheet: 77956d1278430811-populate-data-based-on-drop-down-selection-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Account A
 |  |  |  |  |  |  |  | 2 | ITEM | FCST | SHIP |  |  |  |  |  |  | Account B
 | FCST | SHIP |  |  |  |  |  | Account A | Product A | 22 | 30 |  |  |  |  |  |  | Account C
Product A |  |  |  |  |  |  |  | Account B | Product B | 32 | 40
Product B |  |  |  |  |  |  |  | Account A | Product C | 44 | 44
Product C |  |  |  |  |  |  |  | Account C | Product D | 50 | 60
Product D |  |  |  |  |  |  |  | Account C | Product D | 45 | 50
Spreadsheet: 2b984b0d-d550-4039-96a8-2d2ef11c7e58
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
 | 8731.0 Building Approvals, Australia
 | TABLE 86. Value of Building Approved, Chain Volume Measures, Original - Australian Capital Territory
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total houses ;  New ; |  |  | Original | A590547W | 1985-09-01 00:00:00 | 2012-03-01 00:00:00 | 107 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total other residential building ;  New ; |  |  | Original | A590548X | 1985-09-01 00:00:00 | 2012-03-01 00:00:00 | 107 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total residential building ;  New ; |  |  | Original | A590549A | 1985-09-01 00:00:00 | 2012-03-01 00:00:00 | 107 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590550K | 1985-09-01 00:00:00 | 2012-03-01 00:00:00 | 107 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590551L | 1985-09-01 00:00:00 | 2012-03-01 00:00:00 | 107 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590552R | 1985-09-01 00:00:00 | 2012-03-01 00:00:00 | 107 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590553T | 1985-09-01 00:00:00 | 2012-03-01 00:00:00 | 107 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: 482976d1475400629-calculate-the-growth-book2-1-prc
Sheet: Sheet1

Member | Value | Growth | Growth Increase | Growth Decrease |  | %Age Growth +/-
G0857175P | 30
G0857175P | 50 | 20 | 1.66 |  |  |  | (30 + 67% of 30 = 50)
S8774172I | 30
S8774172I | 150 | 120 | 5 |  |  |  | (30 + 400% of 30 = 150)
S8734024D | 30
S2699705D | 55
S8026058Z | 25
S8026058Z | 20 | -5 |  | 0.2 |  |  | (25 -20% of 25 = 20)
Spreadsheet: 136202d1326470716-calculate-price-based-on-qty-and-discounted-at-different-levels-testpricing-model
Sheet: Sheet1

 | <<Upload | 1 | Download >>
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9 | 1-5 | 6-10 | 11-15 | 16-20 | 21-30 | 31-40 | 41-50
 |  | 10 | 3.5 | 7 | 22 | 29 | 35 | 41 | 55
 |  | 11
 |  | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
 |  | 19 | 1-5 | 6-10 | 11-15 | 16-20 | 21-25 | 26-30 | 31-35 | 36-40
 |  | 20 | 20 | 15 | 13.5 | 10 | 7.75 | 5.25 | 5 | 4.25
 |  | 21
 |  | 22
 |  | 23
 |  | 24
 |  | 25
 |  | 26
 |  | 27
 |  | 28
 |  | 29
 |  | 30
 |  | 31
 |  | 32
6 |  | 33
1 |  | 34
Fee | 14 | 35
Total: |  | 36
 |  | 37
 |  | 38
 |  | 39
 |  | 40
 |  | 41
 |  | 42
 |  | 43
 |  | 44
 |  | 45
 |  | 46
 |  | 47
 |  | 48
 |  | 49
 |  | 50
Spreadsheet: 3f190b49-f3c1-4ce6-a860-fed9c2e0a7bd
Sheet: 9a

Product1 | Cleared2 | Uncleared | TOTAL
Fixed-Float | 1083394 | 314319 | 1397713
FRA | 553290 | 61434 | 614724
OIS | 259160 | 233564 | 492724
OTHER* | 19141 | 376515 | 395656
TOTAL | 1914985 | 985832 | 2900817
*OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, Inflation, and Swaption.
Spreadsheet: 766702d1644004933-formula-require-to-match-name-and-description-to-return-total-formula-to-match-name-and-description
Sheet: Report

Sr.No. | ID |  |  |  | Name
 |  |  |  |  |  |  |  | Desc4 | Desc5
1 | 1 |  |  |  | Name1 |  |  | 50 | 60
2 | 2 |  |  |  | [NAME] |  |  | 66 | 50
3 | 3 |  |  |  | Name3 |  |  | 42 | 50
4 | 4 |  |  |  | Name4
5 | 5 |  |  |  | Name5
6 | 6 |  |  |  | Name6
7 | 7 |  |  |  | Name7
8 | 8 |  |  |  | Name8
9 | 9 |  |  |  | Name9
10 | 10 |  |  |  | Name10
11 | 11 |  |  |  | Name11
12 | 12 |  |  |  | Name12
13 | 13 |  |  |  | Name13
14 | 14 |  |  |  | Name14
15 | 15 |  |  |  | Name15
Data Capture boundaries:
Sig. Above |  |  |  | 87-100
Above |  |  |  | 77-86
Meeting |  |  |  | 67-76
Below |  |  |  | 45-66
Sig Below |  |  |  | 0-44
Spreadsheet: 789211d1658999084-removing-duplicates-and-counting-test-sheet
Sheet: Summary (Inv)

Summary
Invoice # | Sales person |  | Sales person | Invoice count
10001 | Adam |  | Adam | 2 |  |  | #REF!
10002 | [NAME] |  | [NAME] | 3
10003 | [NAME] |  | [NAME] | 3
10004 | [NAME] |  | [NAME] | 1
10005 | [NAME] |  | [NAME] | 1
10006 | Adam
10007 | [NAME]
10008 | [NAME]
10009 | [NAME]
10010 | [NAME]
Spreadsheet: 826997d1682425182-find-abreviated-month-in-a-string-and-return-adjant-number-sample-year-extraction
Sheet: Sheet1

 |  |  | SOLD -15 /MESU21:XCME 1/5 30 JUN 21 /EX4M21:XCME 4180 PUT @3.70 | 21
 |  |  | SOLD -20 /MESU21:XCME 1/5 9 JUL 21 /EX2N21:XCME 4200 PUT @5.25 | 21
 |  |  | SOLD -20 /MESU21:XCME 1/5 9 AUG 21 /EX2N21:XCME 4280 PUT @4.05 | 21
 |  |  | SOLD -20 1/5 9 SEPT 22 /EX2N21:XCME 4280 PUT @5.25 | 22
 |  |  | SOLD -10 16 JUL 21 /EX3N21:XCME 4315 PUT @7.00 | 21
 |  |  | SOLD -20 /MESU21:XCME 1/5 16 APR 21 /EX3N21:XCME 4310 PUT @4.65 | 21
 |  |  | REMOVAL  5.0 SHLX 100 16 JUL 21 15 PUT | 21
 |  |  | REMOVAL OF OPTION DUE TO ASSIGNMENT 1.0 PSX 100 16 JAN 21 40 PUT | 21
 |  |  | REMOVAL OF OPTION DUE TO ASSIGNMENT 1.0 PSX 100 16 JUL 23 42.5 PUT | 23
 |  |  | REMOVAL OF OPTION DUE TO EXPIRATION 1.0 ARI 100 16 Sept 24 15 PUT | 24
 |  |  | SOLD -10 /MESU21:XCME 1/5 23 JUL 20 /EX4N21:XCME 4250 PUT @18.00 | 20
 |  |  | SOLD -10 1/5 23 NOV 21 /EX4N21:XCME 4200 PUT @14.00 | 21
 |  |  | SOLD -10 /MESU21:XCME 1/5 23 DEC 22 4200 PUT @20.00 | 22
 |  |  | SOLD -2 SHLX 100 15 OCT 21 15 CALL @.25 | 21
 |  |  | SOLD -3 SHLX 100 15 NOV 21 15 CALL @.25 | 21
 |  |  | SOLD -1 FSK 100 15 OCT 21 22.5 CALL @.25 PHLX | 21
 |  |  | SOLD -3 IEP 100 20 AUG 23 60 CALL @.35 | 23
 |  |  | BOT +10 1/5 23 JUL 21 /EX4N21:XCME 4150 PUT @.05 | 21
 |  |  | BOT +30 /MESU21:XCME 1/5 23 FEB 21 /EX4N21:XCME 4200 PUT @.05 | 21
 |  |  | BOT +20 CIM 100 20 JAN 23 10 PUT @.65 | 23
 |  |  | SOLD -4 PSX 100 20 AUG 21 39 CALL @.50 NYSE | 21
 |  |  | SOLD -1 /ESU21:XCME 1/50 30 JUL 21 (EOM) E 4300 PUT @7.00 | 21
 |  |  | SOLD -1 /ESU21:XCME 1/50 30 AUG 22  PUT @8.25 | 22
 |  |  | SOLD -1 /ESU21:XCME 1/50 30 MAY 21 (EOM) /EWN21:XCME 4300 PUT @9.00 | 21
 |  |  | BOT +11 CIM 100 20 JAN 23 12 PUT @1.20 NYSE | 23
Spreadsheet: 842209d1694295801-transform-certain-columns-to-rows-based-on-the-values-sample_m-2-
Sheet: Table1

Column1 | Column2 | Column3 | Column4 | Column5 | Attribute | Value |  | Cat | Sub | Add | Add1 | Add2 | Attribute | Value
Acct | Asst | SPB | [NAME] | Rep | Column6 | 0 to 25% |  | Exp | [NAME] | LPB | [NAME] | InCo | Percentage? | 50 to 75%
Acct | Asst | SPB | [NAME] | Rep | Column7 | Planning |  | Acct | Asst | SPB | [NAME] | Rep | Percentage? | 0 to 25%
Exp | [NAME] | LPB | [NAME] | InCo | Column6 | 0 to 25% |  | Rev | CM | SPB | [NAME] | InCo | Percentage? | 50 to 75%
Rev | CM | SPB | [NAME] | InCo | Column6 | 50 to 75% |  | Exp | [NAME] | LPB | [NAME] | InCo | Percentage? | 0 to 25%
Rev | CM | SPB | [NAME] | InCo | Column7 | Planning |  | Acct | Asst | SPB | [NAME] | Rep | Time? | Planning
Rev | CM | SPB | [NAME] | InCo | Column8 | Analysis |  | Rev | CM | SPB | [NAME] | InCo | Time? | Planning
Exp | [NAME] | LPB | [NAME] | InCo | Column6 | 50 to 75% |  | Exp | [NAME] | LPB | [NAME] | InCo | Effort? | Review
Exp | [NAME] | LPB | [NAME] | InCo | Column8 | Review |  | Rev | CM | SPB | [NAME] | InCo | Effort? | Analysis