tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 84ca94e5-3614-4056-9b0e-a3ae0e1d7d19
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  | Participant Payment Advance Request
 |  | Financial and Administrative Services
 | Employee Name: |  |  |  | Delivery Method                         (select from menu): |  |  |  | Date Required:          (dd/mm/yy)
 | Department:
 | Address: |  |  |  | Dept:
 |  |  |  |  | Call: |  |  | Ext:
 | Postal Code: |  |  |  | Please note all advance requests will be made in Canadian dollars only. |  |  |  | Advance Request Forms must be filled out electronically
 |  |  |  |  |  |  |  |  | Expected Completion
 | Advance Amount Required (111-006-018): |  |  |  |  | Date of Research
 | Advances requests for amounts less than $5,000 only |  |  |  |  |  |  |  |  | (dd/mm/yy)
 | Purpose of Advance (including nature and estimate of expenditures to be incurred)
 | Expenses will be ultimately charged to: | Account (xxx-xxx-xxx) | Department (if different than above)
 | ACKNOWLEDGEMENT
 | I acknowledge that this approved advance does not imply approval of actual expenses which must be submitted on a Employee Expense Reimbursement Form within 90 days of the date of completion of research.
 | I certify that the funds received in this advance will be used for expenses related to university business.
 | All advances for travel prior to April 30th must be cleared by the first Friday of May to be included in the correct fiscal year.
 | PAYMENT REQUESTOR (if different from payee)
 | Name |  |  | Date (dd/mm/yy)
 | PAYEE
 | Name |  |  | Title
 | Signature |  |  | Date (dd/mm/yy)
 | AUTHORIZED [NAME]
 | Name |  |  | Title
 | Signature |  |  | Date (dd/mm/yy)
 | CONTROLLER AND MANAGER OF FINANCE APPROVAL
 | Signature |  |  | Date (dd/mm/yy)
 | Finance Use Only | Verified by: |  |  |  | Date:
 | Version - Aug 2012
 | Mail to Department
 | Mail to Address Shown
 | Pick Up in Finance
 | Wire Payment
Spreadsheet: 747387d1631461879-formula-help-to-help-build-a-stock-inventory-excel-help-om
Sheet: Requirements

Candle 1
Oil | OM005
 | 10 |  | ml
Wick | [NAME]
 | 1 |  | piece
Wax | OM015
 | 165 |  | g
Vessel | OM017
 | 1 |  | piece
Label | OM022
 | 1 |  | piece
[NAME] | OM032
 | 1 |  | piece
Candle Guard | OM041
 | 1 |  | piece
[NAME] | OM042
 | 1 |  | piece
Spreadsheet: 697944d1601635739-ranking-based-on-criteria-test
Sheet: Test

 |  |  |  |  |  |  | 2020-04-15 00:00:00
Item | Price | Category | Date | Rank | Desired Rank
CTR_01 | 3.5 | Urgent | 2020-04-15 00:00:00 |  | 1
[NAME] | 3.2 | Not Urgent | 2020-04-05 00:00:00 |  |  |  |  |  | * Ranking is needed for only urgent item based on there price and date
CTR_03 | 3.44 | Not Urgent | 2020-04-06 00:00:00
CTR_08 | 3.5 | Urgent | 2020-05-11 00:00:00 |  | 1 |  |  |  | * Ranking is to be decreasing order of price
CTR_18 | 3.44 | Urgent | 2020-04-21 00:00:00 |  | 2
CTR_06 | 3.41 | Urgent | 2020-04-21 00:00:00 |  | 3
CTR_07 | 3.2 | Urgent | 2020-04-06 00:00:00
CTR_17 | 3.2 | Urgent | 2020-04-20 00:00:00 |  | 4
CTR_09 | 3 | Not Urgent | 2020-04-12 00:00:00
CTR_10 | 2.1 | Not Urgent | 2020-04-06 00:00:00
CTR_11 | 3.4 | Not Urgent | 2020-05-14 00:00:00
CTR_12 | 3.2 | Not Urgent | 2020-04-15 00:00:00
CTR_13 | 3.44 | Not Urgent | 2020-04-16 00:00:00
CTR_14 | 3 | Not Urgent | 2020-04-17 00:00:00
CTR_15 | 2.1 | Not Urgent | 2020-04-18 00:00:00
CTR_16 | 3.4 | Not Urgent | 2020-04-19 00:00:00
CTR_04 | 3 | Urgent | 2020-04-06 00:00:00
CTR_19 | 3 | Urgent | 2020-04-06 00:00:00
CTR_05 | 2.1 | Urgent | 2020-04-23 00:00:00 |  | 5
CTR_20 | 2.1 | Urgent | 2020-04-23 00:00:00 |  | 5
Spreadsheet: 814844d1674632934-rank-and-vlookup-book1
Sheet: Data

 |  | TABLE A |  |  |  |  |  |  |  |  |  |  |  |  |  | TABLE B
 |  |  | SCORE |  |  |  |  |  |  |  |  |  |  | STYLE |  | AUDITORI | AUDITORI | KINESTATIK | VISUAL | AUDITORI | VISUAL | AUDITORI | KINESTATIK | KINESTATIK | AUDITORI
 | NO | NAME | VLBM | VLBI | LM | VR | MU | NAT | INTRA | INTER | KINES | EKSIS |  | SCORE |  | VLBM | VLBI | LM | VR | MU | NAT | INTRA | INTER | KINES | EKSIS | RANK | VLOOKUP
 | 1 | STUDENT 1 | 75 | 45 | 55 | 20 | 85 | 45 | 70 | 95 | 65 | 95 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | KINESTETIK
 | 2 | STUDENT 2 | 55 | 30 | 25 | 40 | 30 | 25 | 30 | 45 | 0 | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | AUDITORI
 | 3 | STUDENT 3 | 90 | 45 | 50 | 45 | 25 | 35 | 15 | 65 | 15 | 65
 | 4 | STUDENT 4 | 75 | 85 | 90 | 80 | 25 | 35 | 15 | 65 | 15 | 65
 | 5 | STUDENT 5 | 75 | 55 | 60 | 75 | 40 | 40 | 80 | 75 | 55 | 65
 | 6 | STUDENT 6 | 75 | 30 | 40 | 40 | 15 | 25 | 50 | 50 | 10 | 70 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]? |  | [NAME]?
 | 7 | STUDENT 7 | 55 | 25 | 35 | 40 | 45 | 75 | 75 | 85 | 65 | 70
 | 8 | STUDENT 8 | 80 | 75 | 40 | 70 | 45 | 75 | 75 | 85 | 65 | 70
 | 9 | STUDENT 9 | 80 | 70 | 40 | 40 | 40 | 65 | 65 | 90 | 50 | 85
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank and vlookup Hi,  How to choose the highest ranking on table B. The choice of the highest score is from left to right.  Table A is the score obtained by students. While table B is the calculation of the highest ranking score obtained by students.  Then the highest rank needs to match the style
Spreadsheet: 35132d1232644530-copying-hyperlinks-december-2008-excel-forum
Sheet: Week 1(a)

Income |  |  |  |  |  |  | Week 1(a)
1st - 31st of December 2008
Name of Company | Money X | Money Y | Total
[NAME] | 10000 | 0 | 10000 |  |  | [NAME] | A5 | C11 | D11 | E11
Вагриус книги | 20000 | 0 | 20000 |  |  | Вагриус книги | A20 | C27 | D27 | E27
Вагриус правда | 30000 | 0 | 30000 |  |  | Вагриус правда | A36 | C43 | D43 | E43
Вагриус минус | 40000 | 0 | 40000 |  |  | Вагриус минус | A52 | C59 | D59 | E59
Плюс-минус | 50000 | 0 | 50000 |  |  | Плюс-минус | A68 | C75 | D75 | E75
Издательство Вагриус | 60000 | 0 | 60000 |  |  | Издательство Вагриус | A84 | C91 | D91 | E91
Вагриус плюс-минус | 70000 | 0 | 70000 |  |  | Вагриус плюс-минус | A100 | C107 | D107 | E107
Grand Total | 280000 | 0 | 280000 |  |  |  |  | C109 | D109 | E109
 |  |  |  |  |  | [NAME] | A122 | C129 | D129 | E129
 |  |  |  |  |  | Вагриус книги | A138 | C145 | D145 | E145
 |  |  |  |  |  | Вагриус правда | A154 | C161 | D161 | E161
Expenditure |  |  |  |  |  | Вагриус минус | A170 | C177 | D177 | E177
1st - 31st of December 2008 |  |  |  |  |  | Плюс-минус | A186 | C193 | D193 | E193
Name of Company | Money X | Money Y | Total |  |  | Издательство Вагриус | A202 | C209 | D209 | E209
[NAME] | 5000 | 0 | 5000 |  |  | Вагриус плюс-минус | A218 | C225 | D225 | E225
Вагриус книги | 6000 | 0 | 6000 |  |  |  |  | C227 | D227 | E227
Вагриус правда | 7000 | 0 | 7000
Вагриус минус | 100 | 0 | 100
Плюс-минус | 300 | 0 | 300
Издательство Вагриус | 4500 | 0 | 4500
Вагриус плюс-минус | 9999 | 0 | 9999
Grand Total | 32899 | 0 | 32899
Spreadsheet: 862900d1710474869-dynamic-lookup-that-omits-blank-rows-in-the-results-geddbconundrum
Sheet: Data2

 | [NAME] | [NAME] | Fred | Barney | Wilma | Betty | [NAME]
11(a) | Y |  | Y |  | Y
11(b) |  |  | Y |  | Y
11(c)
12 | Y |  |  |  | Y
13(a) | Y
13(b) |  | Y
13(c)
14(a) |  | Y | Y | Y | Y
14(b)
14(c) |  |  | Y | Y | Y |  | Y
14(d) |  |  | Y | Y
Spreadsheet: 832228d1686194289-how-to-get-the-name-of-each-course-from-the-bottom-of-the-students-name-in-col-a-to-b-i-s666-pq-how-to-get-the-name-of-each-course-from-the-bottom-of-the-students-name
Sheet: Sheet1

student name |  |  |  |  |  |  |  |  | Value |  | students | List.1 | List.2 | List.3 | List.4 | List.5 | List.6 | List.7 | List.8
[NAME] | biology |  |  |  |  |  |  |  | biology |  | [NAME] | biology | physics | physics
biology |  |  |  |  |  |  |  |  | physics |  | West Aerospace | language | language | Chemical
West Aerospace | physics | language |  |  |  |  |  |  | language |  | West American Camp
physics |  |  |  |  |  |  |  |  | Chemical |  | [NAME] | Chemical | physics | information Technology | English
language |  |  |  |  |  |  |  |  | information Technology |  | Sidney | history | math | physics | information Technology | English | language | biology
West American Camp | language | Chemical | physics |  |  |  |  |  | English |  | [NAME] | English | language | physics | math | history
language |  |  |  |  |  |  |  |  | history |  | [NAME] | math | English
Chemical |  |  |  |  |  |  |  |  | math |  | Xizhang | biology | physics | language | Chemical | history | math | information Technology | English
physics
[NAME] | Chemical | physics | information Technology | English
Chemical
physics
information Technology
English
Sidney | history | math | physics | information Technology | English | language | biology
history
math
physics
information Technology
English
language
biology
[NAME] | English | language | physics | math | history
English
language
physics
math
history
[NAME] | math | English
math
English
Xizhang | biology | physics | language | Chemical | history | math | information Technology | English
biology
physics
language
Chemical
history
math
information Technology
English
Spreadsheet: 82363d1282371018-look-up-the-part-code-having-end-with-desired-character-1234
Sheet: CND

 |  |  | 12301-GB6-9000C
 |  |  | 12391-GW8-6810C
 |  |  | 12394-GW8-6810C
Part Code | Part name |  | 90461-357-0000C
1100661 | OIL ENGINE 10 W 30 - SJ GRADE
12301-GB6-9000C | COVER CYLINDER HEAD
12331-GB0-9100 | COVER R CYLINDER HEAD SIDE
12341-GB6-9100 | COVER L CYLINDER HEAD SIDE
[PHONE] | HOLE CAP TAPPET ADJUSTING
12391-GW8-6810C | GASKET CYL HEAD COVER
12394-GW8-6810C | GASKET CYLINDER HD L SIDE COVER
12395-GW8-6810 | GASKET CYLINDER HD R SIDE COVER
98056-57718-01 | SPARK PLUG
90201-GF6-0000 | NUT CAP 7MM
90442-GF6-0000 | WASHER SEALING 7 MM
90443-GF6-0000 | WASHER A SEALING 7 MM
90461-357-0000C | WASHER SEALING 12 MM
91302-KEV-9000 | O-RING 30.8X3
95701-06110-00 | BOLT FLANGE 6X110
96001-06020-00 | BOLT FLANGE SH.6X20
12191-KRS-C100 | GASKET CYLINDER
Spreadsheet: f3703712-1433-4375-b038-db805f51a3dd
Sheet: 10a

Product |  | Cleared** | Uncleared | TOTAL
Swap* | Basis
 | FRA
 | Exotic
 | Inflation
 | IRS- [NAME]
 | OIS
 | VNS
 | Zero Coupon
With Optionality | Callable Swap
 | Cap/Floor
 | Debt Option
 | Exotic Option
 | Swaption
Cross-Currency | Exotic
 | Swap
TOTAL |  | N/A*** | N/A | N/A
Estimated net notional amount outstanding, August 9 weekly snapshot, by product type and tenor (millions of USD), all participant types and currencies.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 59260d1259760331-match-formula-copy-of-pick4matchformula09
Sheet: Sheet2

 |  |  | 8411
6413 | 1913 | 1463 | 1408
6414 | 1914 | 1464 | 1409
6415 | 1915 | 1465 | 1410
6415 | 1915 | 1465 | 1410
6416 | 1916 | 1466 | 1411
6417 | 1917 | 1467 | 1412
8213 | 3713 | 3263 | 3208
8214 | 3714 | 3264 | 3209
8215 | 3715 | 3265 | 3210
8215 | 3715 | 3265 | 3210
8216 | 3716 | 3266 | 3211
8217 | 3717 | 3267 | 3212
8411 | 3911 | 3443 | 3416
8412 | 3912 | 3444 | 3417
8413 | 3913 | 3445 | 3418
8413 | 3913 | 3445 | 3418
8414 | 3914 | 3446 | 3419
8415 | 3915 | 3447 | 3420
8493 | 3993 | 3461 | 3488
8494 | 3994 | 3462 | 3489
8495 | 3995 | 3463 | 3490
8495 | 3995 | 3463 | 3490
8496 | 3996 | 3464 | 3491
8497 | 3997 | 3465 | 3492
Spreadsheet: 41262d1239748792-identify-list-and-sum-2-columns-test-time-sheet
Sheet: Apr 6-11

 | NAME:
 |  |  |  |  | TOTAL HRS
DATE | TIME IN | TIME OUT | TOTAL HRS | JOB NO. | FOR DAY | JOB [NAME]
2009-04-06 00:00:00 | 06:30:00 | 02:00:00 | 7 | OFFICE |  | PROJECT MANAGE
 | 02:00:00 | 03:00:00 | 1 | OFFICE | 8 | QUOTE
2009-04-07 00:00:00 | 06:30:00 | 10:30:00 | 4 | 28099 |  | PROGRAM
 | 10:30:00 | 03:00:00 | 4 | 29001 | 8 | PROGRAM
2009-04-08 00:00:00 | 06:30:00 | 09:00:00 | 2.5 | SHOP
 | 09:00:00 | 12:00:00 | 3 | 27004 |  | RUN
 | 12:00:00 | 03:00:00 | 2.5 | OFFICE | 8 | PROJECT MANAGE
2009-04-09 00:00:00 | - | - | 8 | VAC | 8 | VACATION
2009-04-10 00:00:00 | - | - | 8 | HOL | 8 | HOLIDAY
 |  |  |  |  |  |  |  |  | VACATION
 |  |  |  |  |  |  |  |  | 46hrs REMAINING
 |  | OFFICE | 10.5
 |  | 28099 | 4
 |  | 29001 | 4
 |  | SHOP | 2.5
 |  | 27004 | 3
 |  | VAC | 8
 |  | HOL | 8
 |  | TOTAL | 40 | TOTAL | 40
Spreadsheet: chris_germany__2576__VNG Pipeline Setup-Oct-00
Sheet: 10-1,2

2000-10-01 00:00:00 |  |  | VNG Daily Setup |  |  |  |  | 2000-09-28 08:51:29.300000
 |  |  |  | DTH
 |  |  | 2000-10-01 00:00:00 |  | 2000-10-02 00:00:00 |  | 2000-10-03 00:00:00 |  | 2000-10-04 00:00:00
 |  |  | Sunday |  | Monday |  | Tuesday |  | Wednesday
Heating Degree Days
Forecasted Demand |  |  | 45000 |  | 50000 |  | 50000 |  | 50000
INTERRUPTIBLE STATUS |  |  | ON / ON |  | ON / ON |  | ON / ON |  | ON / ON
SUPPLY: | AVAILABLE
TRANSCO
FS  Swing | 15930 |  | 15930 |  | 15930 |  | 15930 |  | 15930
FT | 14400 |  | 20556 |  | 20556 |  | 20556 |  | 20556
WSS - W/D  (3,386) | 5600 |  | -3300 |  | -3300 |  | -3300 |  | -3300
GSS-INJ (575) | 2070 |  | -484 |  | -484 |  | -484 |  | -484
WSS  W/D Capacity | 0
TOTAL Emporia | 38000 |  | 32146 |  | 32146 |  | 32146 |  | 32146
TOTAL City Gate | 37620 |  | 31825 |  | 31825 |  | 31825 |  | 31825
FT-WSS-INJ (3,386)
COLUMBIA
+  SST - Spot | 0 |  | 0 |  | 0 |  | 0 |  | 0
+  FTS - System Supply | 57970 |  | 10698 |  | 15698 |  | 15698 |  | 15698
=  Subtotal FT Sys. Supply | 57970 |  |  | * |  | * |  | * |  | *
SST - FSS         (9837) | 31827.5 |  | -4576 |  | -4576 |  | -4576 |  | -4576
EndUser |  |  | 2000 |  | 2000 |  | 2000 |  | 2000
Cove Point LNG |  |  | 0 |  | 0 |  | 0 |  | 0
LNG (3,244) | 52090 |  | -6081 |  | -6081 |  | -6081 |  | -6081
TOTAL | 141887.5
 |  |  | * LNG Chesapeake injection nominated directly to the facility, citygate deliveries are net the injection quantity.
CNGT
FTNN | 46075 |  | 16558 |  | 16558 |  | 16558 |  | 16558
GSS            (16,599) | 37554 |  |  |  | -16599 |  | -16599 |  | -16599
Subtotal Cannot exceed 46,075 Apr - Oct
EndUser |  |  | 11175 |  | 11175 |  | 11175 |  | 11175
[NAME] | 9975
TOTAL Quantico | 93604
TOTAL City Gate | 93369.99
VNG
PROPANE
NORTHERN | 17275 |  | 0 |  | 0 |  | 0 |  | 0
SOUTHERN | 34450 |  | 0 |  | 0 |  | 0 |  | 0
TOTAL | 324602.49
 | Projected  Storage  Summary
 |  |  | [NAME]. |  | [NAME]
 | FSS |  | 9837 |  | 31827.5
 | GSS |  | 484 |  | 2049
 | WSS |  | 3386 |  | 5600
 | CNG GSS |  | 16599 |  | 37554
 | LNG |  | 3244 |  | 52090
 | Propane |  | 12,000 gal/day |  | 51825
High Burn Contingenies |  |  |  |  |  |  |  | Low Burn Contingenies
1) Reduce Columbia FSS Injection to 0 |  |  |  |  |  |  | 1) Increase Columbia FSS injection to 9,837
2) Reduce CNG GSS Injection to 0 |  |  |  |  |  |  | 2) Notify ENA  contact for instructions if there is excess supply
3) Notify ENA  contact for instructions if additional supply is needed
Spreadsheet: 197883d1354595736-assigning-a-value-to-items-in-a-list-box-drawer-order-form-calc
Sheet: Sheet1

 |  | DRAWER ORDER FORM
Material:
o | Maple
o | Birch Plywood
o | Other_______________
Assembly:
o | Assembled
o | Unassembled
Notch:
o | None
o | Back and [NAME]
o | Front, Back and [NAME]
Finish:
o | Unfinished
o | Clear Laquer
Item | QTY | [NAME] | Height | Depth | S Sqft /pc | B Sqft /pc |  |  |  | Scoop
1 |  | 24 | 4 | 20
2 |  | 23.9375 | 3 | 18
3
4
5
6
7
8
9
10
11
12
13
14
 |  |  |  |  |  |  | Signature:____________________________
Spreadsheet: b29aa0d7-5e0e-4d51-a5cd-6f07bc299bef
Sheet: Sheet1

Judgeship Number 5 (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 5/25/2013 2:50:30 AM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
Precinct | [NAME] | [NAME] | TOTALS
Precinct 0201 | 370 | 83 | 453
Precinct 0202 | 189 | 65 | 254
Precinct 0203 | 123 | 36 | 159
Precinct 0204 | 113 | 17 | 130
TOTAL | 795 | 201 | 996
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 777835d1650635770-copy-data-from-one-page-to-another-when-name-selected-from-drop-down-sample-copy-data-from-one-page-to-another-when-name-selected-from-drop-down
Sheet: First page

The customer need to fill the table below (I have filled it for the example).
Everytime the customer select Automated attendant in the action column, I want the phone number to be copied in the cell, in the table, in the next page as this second page will be reserved to describe how the  customer wants his automated attendant. We don't want the phone number to be copied in the next page if the customer selects any other action than Automated attendant.
Additional note: the customer can select the action via a dropdown selection.
Confirm phone numbers | Action
[PHONE] | Call grouped extension
[PHONE] | Call an extension
[PHONE] | Automated attendant
[PHONE] | Transfer call on a phone number
[PHONE] | Transfer call on a phone number
[PHONE] | Other
[PHONE] | Automated attendant
[PHONE] | Call a call queue
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Call grouped extension
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Call an extension
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Call a voicemail
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Automated attendant
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Call a call queue
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Transfer call on a phone number
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other
Spreadsheet: 714496d1611245945-adding-a-text-superscript-to-the-end-of-a-formula-text-superscript-after-formula
Sheet: Sheet1

Service Rank1 | Service Volume2 | Service %3 | Academic Service |  |  |  | ⁰¹²³⁴⁵⁶⁷⁸⁹ | ⁰
1 | 26 | 0.3376623376623377 | Bone Marrow Transplant Service |  |  |  |  | ¹
2 | 24 | 0.3116883116883117 | Thoracic Surgical Service |  |  |  |  | ²
3 | 22 | 0.2857142857142857 | Pulmonary Service |  |  |  |  | ³
TOTALS: |  |  |  |  |  |  |  | ⁴
12 days4 |  |  |  |  |  |  |  | ⁵
 |  |  |  |  |  |  |  | ⁶
 |  |  |  |  |  |  |  | ⁷
Legend: |  |  |  |  |  |  |  | ⁸
1 | Rank based upon volume compared to all services |  |  |  |  |  |  | ⁹
2 | Number of referrals from this service
3 | Percentage of total volume from this service
4 | Number of days in reporting period
5 | Patients per technologist per day
Spreadsheet: 88471d1288278585-excel-2007-row-functions-example-1
Sheet: Sheet1

Development Cost
Kickoff Year | 2011
Kickoff  Quarter | 1
Q's till Product Release | 4
Sample/Product Release Date
Year
Quarter
Spreadsheet: 847964d1698791225-cannot-get-closest-match-to-work-within-reverse-lookup-with-a-2-dimensional-array-testdata-revlookup-closestmatch-2darray
Sheet: Sheet2

GOAL - To be able to do a Reverse Lookup for a Closest Match result
 | Currently am able to perform a Reverse lookup with an [NAME]for multiple categories, and a Reverse Lookup with [NAME] for a single category.
 | Example:  If I am in category 1003 and I sell 3,100 units, I am closest the 3rd percentile, but the formula yield 2nd percentile.
 | GIVEN #1:  CATEGORY | 1003
 | GIVEN #2: UNITS | 2900 |  | Example:  If I am in category 1003 and I sell 3,100 units, I am at the 3rd percentile
 | ANSWER WANTED: WHICH PERCENTILE? | 0.02
 | Exact Match Formula Description
F1: | Exact Match Formula for This Scenario
 | Exact Match Test | 0.02 | If I am in category 1003 and I sell 3,000 units, I am at the 3rd %tile.  However, if I sell 2,900 units my closest match should be 3%tile
F2: | Closest Match Formula for just one category row | {=INDEX(B1:G1,MATCH(MIN(ABS(B4:G4-J4)),ABS(B4:G4-J4),0))}      Note: brackets are from Ctrl+Shift+Enter
 | Result using Category 1003 and Units 3100 | 0.03 | If I am in category 1003 and I sell 3,100 units, I am at the 3rd percentile
 | Attempts to incorporate both | =INDEX(B1:G1,,MATCH((MIN(ABS(B4:[NAME]:G6,MATCH(J4,A2:[NAME])))
 | Question - Need to nest another INDEX function and/or how to incorporate the MIN & ABS functions?
Spreadsheet: 857991d1706806468-embedding-max-min-in-sumproduct-formula-sjpeters75-opportunity-calculator
Sheet: Sheet1

Opportunities |  |  |  |  |  |  | Holidays
Contract | $/hr | Start | End |  |  |  | 2024-01-01 00:00:00
Contract 1 | 1 | 2024-01-01 00:00:00 | 2024-07-06 00:00:00 |  |  |  | 2024-01-15 00:00:00
Contract 1 | 2 | 2024-05-01 00:00:00 | 2024-12-09 00:00:00 |  |  |  | 2024-02-19 00:00:00
Contract 2 | 1 | 2024-09-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  | 2024-05-27 00:00:00
Contract 3 | 1 | 2024-02-04 00:00:00 | 2024-02-08 00:00:00 |  |  |  | 2024-06-19 00:00:00
 |  |  |  |  |  |  | 2024-07-04 00:00:00
 |  |  |  |  |  |  | 2024-09-02 00:00:00
 |  |  |  |  |  |  | 2024-10-14 00:00:00
 |  |  |  |  |  |  | 2024-11-11 00:00:00
 |  |  |  |  |  |  | 2024-11-28 00:00:00
 |  |  |  |  |  |  | 2024-12-25 00:00:00
 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00
 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Contract 1
Contract 2
Contract 3
 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00
 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Contract 1 | 168 | 160 | 168 | 176 | 880 | 760 | 736 | 704 | 640 | 704 | 608 | 192
Contract 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 160 | 176 | 152 | 168
Contract 3 | 0 | 32 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 840407d1692714339-cant-get-xlookup-to-work-example
Sheet: Taul1

 |  |  | [NAME]? | Scania Manuaali
18FEF721 |  |  | Kyllä
18FEF521 |  |  | Kyllä
18FE4F0B |  |  | Kyllä
18FEC017 |  |  | Kyllä
18FE7003 |  |  | Kyllä
18FDE22F |  |  | Kyllä
18FEEF21 |  |  | Kyllä
18FE582F |  |  | Kyllä
18FE700B |  |  | Kyllä
18FF4072 |  |  | Kyllä
 |  |  |  |  |  |  | X
Spreadsheet: 95152d1294831417-create-a-unique-list-from-a-list-of-duplicated-dynamically-book1_tommy1005
Sheet: Sheet1

Data List | Unique Values | Listed
Blue |  | Blue
Blue |  | Red
Red |  | Green
Blue | Blue | Yellow
Green
Red | Red
Green
Green | Green
Yellow
Yellow | Yellow
Spreadsheet: 162548d1339960959-excel-2008-extracting-data-from-a-table-and-then-sorting-it-with-conditional-formatting-sample-election-sheet
Sheet: Sheet1

Ward | Constituency | Pop | Cum pop | Con | Lab | [NAME] | % share of vote | % share of vote | % share of vote | Ward winner |  | Ward majority | Ward % majority
Exchange | Central | 4814 |  | 1213 |  | 837 |  |  |  |  | win
East Side |  | 6523 |  | 1004 |  | 590 |  |  |  |  | win
Bailey |  | 6629 |  | 1247 |  | 694 |  |  |  |  | win
Castle |  | 4883 |  | 3859 |  | 392 |  |  |  |  | win
[NAME] |  | 6020 |  | 1955 |  | 843 |  |  |  |  | win
Grimsdale |  | 4904 |  | 885 |  | 501 |  |  |  |  | win
Burley |  | 5287 |  | 1114 |  | 976 |  |  |  |  | win
Granville |  | 6347 |  | 1578 |  | 1008 |  |  |  |  | win