tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 760373d1640185371-list-missing-number-in-a-sequence-to-another-row-horizontaly-book5-2-ans
Sheet: Sheet1 (2)

 |  |  |  |  |  |  |  |  |  | Record | Record2 | Record3 | Record4 | Record5 | Record6 | Record7 | Record8 | Record9 | Record10 | Record11 | Record12 | Record13 | Record14 | Record15 | Record16 | Record17 | Record18 | Record19 | Record20 | Record21 | Record22 | Record23 | Record24 | Record25 | Record26 | Record27 | Record28 | Record29 | Record30 | Record31 | Record32 | Record33 | Record34 | Record35 | Record36 | Record37 | [NAME] | Record39 | Record40 | Record41 | Record42 | Record43 | Record44 | Record45 | Record46 | Record47 | Record48 | Record49 | Record50 | Missing | Missing2 | Missing3 | Missing4 | Missing5 | Missing6 | Missing7 | Missing8 | Missing9 | Missing10 | Missing11 | Missing12 | Missing13 | Missing14 | Missing15 | Missing16 | Missing17 | Missing18 | Missing19 | Missing20 | Missing21 | Missing22 | Missing23 | Missing24 | Missing25 | Missing26 | Missing27 | Missing28 | Missing29 | Missing30 | Missing31 | Missing32 | Missing33 | Missing34 | Missing35 | Missing36 | Missing37 | Missing38 | Missing39 | Missing40 | Missing41 | Missing42 | Missing43 | Missing44 | Missing45 | Missing46 | Missing47 | Missing48 | [NAME] | Missing50
 |  |  |  |  |  |  |  |  |  | 1003 | 1004 | 1004 | 1006 | 1007 | 1008 | 1009 | 1010 | 1011 | 1012 | 1013 | 1014 | 1015 | 1016 | 1017 | 1018 | 1019 | 1020 | 1021 | 1022 | 1023 | 1024 | 1025 | 1026 | 1027 | 1028 | 1029 | 1030 | 1031 | 1032 | 1033 | 1034 | 1035 | 1036 | 1037 | 1038 | 1039 | 1040 | 1041 | 1042 | 1043 | 1044 | 1045 | 1046 | 1047 | 1048 | 1049 | 1050
 |  |  |  |  |  |  |  |  |  | 55 | 55 | 51 | 56 | 52 | 58
Spreadsheet: 824420d1680572896-comparing-two-lists-with-multiple-columns-s666-pq-ists-difference
Sheet: INDEX MATCH 2

Table 1 |  |  |  | Cet exercise est pour transférer les colones de ceux qui ont voté
Covo | [NAME] | V |  | 13 | 17
Eastwood | [NAME] | v | 695-3297 | 13 |  | 21
Arcand | [NAME] | A | 695-2532 | 13
Beaulieu | Michel |  |  | 13 | 17 | 21
Legault | [NAME] |  |  |  | 17 | 21
Rozon | Gilles |  | 695-7565 |  |  | 21
Cross | [NAME] | X | 694-4865 | 13 |  | 21
Kelso | [NAME] |  |  |  | 17 | 21
Du Preez | [NAME] |  |  |  |  | 21
Arsenault | Stéphane | V | 697-7813 | 13
Legault | [NAME] |  |  | 13 | 17 | 21
Table 2
Eastwood | [NAME]
Arsenault | Stéphane
Kelso | [NAME]
Legault | [NAME]
Mitchell | [NAME]
Arcand | [NAME]
Beaulieu | Michel
Rozon | Gilles
Cross | [NAME]
Du Preez | [NAME]
Covo | [NAME]
Chartrain | [NAME]
Legault | [NAME]
Spreadsheet: 27483d1220705830-iserror-sumproduct-question-discipline-log-08-09-9-05-8
Sheet: Bus

 |  |  |  |  |  | Bus Referrals
Student# | GR | HR | ESE | Last, First | Ethnic | Bus # | Date | AM/PM | Code | Step | Days/Susp. | C | Home #
 | 4 | 157 |  | [NAME], Kierston | B | 225 | 2008-08-28 00:00:00 | PM | 2.01 | 1 | - | C
0 |  |  |  |  |  |  |  |  |  | Total = | 0
 | Y07-08 |  | Y06-07 |  |  | Present Student, information incomplete |  |  |  | P | Parent Conference
Total         = | 113 |  | 117 |  |  |  |  |  |  | C | Copy sent home
May           = |  | 113 | 5 | 117 |  | Information complete |  |  |  | M | Message on machine
April          = | 13 | 113 | 10 | 112 |  | ESE Student |  |  |  | * | Called parent
March        = | 5 | 100 | 1 | 102 |  |  |  |  |  | o | No number or answer
February   = | 10 | 95 | 8 | 101 |  |  |  |  |  | AP | Action Pending
January     = | 4 | 85 | 7 | 93
December = | 8 | 81 | 0 | 86
November = | 9 | 73 | 15 | 86
October     = | 13 | 64 | 26 | 71
September = | 38 | 51 | 34 | 45
August       = | 13 | 13 | 11 | 11
Spreadsheet: 760680d1640382344-help-with-sales-price-calculation-test
Sheet: Sheet1

 |  | Min. Margin | 25 | Euro
 |  | Extra Margin | 0.08 | On Selling Price
 |  | Market Fee | 0.1 | On Selling Price
 |  | Bank Fee | 0.015 | On Selling Price
 |  | Government Fee | 0.23 | On Selling Price Less Product Cost
 | Euro | Euro | Euro
Product Name | Product Cost | Selling Price | Total Costs
Example 1 | 65 | 130.5217391304348
 |  |  |  |  | CHECK | CHECK | CHECK | CHECK
Spreadsheet: 836261d1689218957-bonus-distribution-to-workers-need-to-add-reductions-back-into-total-distribution-sample-distribution-2-
Sheet: Sample distribution

Worker | Work Units | Total distribution | Part time% | Workunits reeduced for part time | 25% distibution | 75% based on work units
Worker 1 | 2800 |  | 1
Worker 2 | 2800 |  | 0.5
Worker 3 | 2436 |  | 1
Worker 4 | 4450 |  | 0.5 |  |  |  |  |  | Total Distribution | 50000
Worker 5 | 2275 |  | 1
Worker 6 | 1600 |  | 1
Worker 7 | 4600 |  | 0.5 |  |  |  |  |  | Amount of Distribution
Worker 8 | 3433 |  | 1 |  |  |  |  |  | 0.25
Worker 9 | 3824 |  | 1 |  |  |  |  |  | 0.75
Worker 10 | 4616 |  | 1
Worker 11 | 3503 |  | 1
Worker 12 | 3800 |  | 0.5
Worker 13 | 2120 |  | 1
Worker 14 | 2753 |  | 1
Worker 15 | 4272 |  | 1 |  |  |  |  |  | # of people in pool
Worker 16 | 4167 |  | 1
Worker 17 | 3362 |  | 1
Worker 18 | 3518 |  | 1
18
 |  |  |  | I should skip this one.
Spreadsheet: dec26850-eee9-4d00-935a-1d19ab9a5550
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6523 | 39387 | Károly | Gombos | HUN | 60 | 00:20:01 | 00:01:00 | 01:11:07 | 00:00:46 | 00:34:58 | 1 | 02:07:55
6523 | 25044 | Marcel | Miko | SVK | 66 | 00:20:11 | 00:00:40 | 01:10:21 | 00:00:56 | 00:43:46 | 2 | 02:15:58
6523 | 16967 | Adam | [NAME] | HUN | 59 | 00:14:43 | 00:00:56 | 01:21:17 | 00:00:54 | 00:40:34 | 3 | 02:18:27
6523 | 50364 | Dénes | Száraz | HUN | 64 | 00:19:30 | 00:01:51 | 01:19:21 | 00:00:57 | 00:45:15 | 4 | 02:26:58
6523 | 50350 | Gergő | Herbák | HUN | 61 | 00:23:33 | 00:01:58 | 01:19:46 | 00:01:09 | 00:41:35 | 5 | 02:28:04
6523 | 50353 | Balázs | Viktorik | HUN | 65 | 00:22:53 | 00:01:58 | 01:23:13 | 00:00:58 | 00:42:47 | 6 | 02:31:55
Spreadsheet: 156564d1337347430-table-lookup-based-on-values-in-5-cells-test-data
Sheet: Lookup

Entry 1 | Entry 2 | Entry 3 | Entry 4 | Entry 5 | More info 1 | More info 2 | Comment | Comment 2 |  | Inclusion
Test 1 | Data 1 | About 1 | More on this 1 | Option 1 | Unknown | Unknown | Comment 1 | 1
Test 1 | Data 1 | About 1 | More on this 2 | Option 1 | Unknown | No cap | Comment 2 | 1
Test 1 | Data 1 | About 2 | More on this 3 | Option 2 | Unknown | No cap | Comment 3 | Unlimited
Test 2 | Data 2 | About 2 | More on this 4 | Option 1 | Unknown | Unknown | Comment 4 | 1
Test 2 | Data 2 | About 3 | More on this 5 | Option 2 | Unknown | No cap | Comment 5 | 1
Test 2 | Data 2 | About 1 | More on this 6 | Option 1 | 10 per annum | No cap | Comment 6 | Unlimited
Test 3 | Data 2 | About 3 | More on this 7 | Option 2 | No cap | No cap | Comment 7 | 1
Test 3 | Data 1 | About 1 | More on this 8 | Option 1 | No cap | No cap | Comment 8 | 1
Test 3 | Data 1 | About 2 | More on this 9 | Option 1 | Unknown | Unknown | Comment 9 | 1
Test 3 | Data 2 | About 3 | More on this 10 | Option 2 | Unknown | Unknown | Comment 10 | 1
Test 4 | Data 1 | About 1 | More on this 11 | Option 1 | Unknown | Unknown | Comment 11 | 1
Test 1 | Data 2 | About 3 | More on this 12 | Option 1 | Unknown | Unknown | Comment 12 | 1
Test 2 | Data 1 | About 1 | More on this 13 | Option 2 | Unknown | Unknown | Comment 13 | Unknown
Spreadsheet: 44530d1243296883-excel-2007-strange-iferror-and-offset-behaviour-testcase
Sheet: Sheet1

Main Table |  |  |  | Counter | Offset
Us1 | Item1 |  | Us1
Us1 | Item1 |  | Us2
Us1 | Item2 |  | Us3
Us1 | Item3 |  | Us4
Us2 | Item1
Us2 | Item3
Us3 | Item5 |  | What I want: |  | Us1 |  | Item1 | Item1 | Item2 | Item3
Us4 | Item2 |  |  |  | Us2 |  | Item1 | Item3
Us4 | Item2 |  |  |  | Us3 |  | Item5
Us4 | Item5 |  |  |  | Us4 |  | Item2 | Item2 | Item5
Spreadsheet: 5aa917ac-93e1-4cec-a475-b5ca61f4b13b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Not Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2013
 |  | Data Extracted on: November 27, 2014 (2:32 pm)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
2003 | X | X | X | 237399
2004 | 223675 | 233241 | 232983 | 246201
2005 | 236033 | 244136 | 244711 | 255856
2006 | 245182 | 254735 | 255745 | 271401
2007 | 257973 | 265739 | 267325 | 281304
2008 | 270223 | 277650 | 277603 | 282873
2009 | 261921 | 266862 | 265511 | 280665
2010 | 267597 | 274785 | 276049 | 291794
2011 | 277416 | 289110 | 288779 | 305253
2012 | 291952 | 300081 | 298950 | 322308
2013 | 306040 | 313234 | 314646 | 340055
Spreadsheet: 1b09c658-948a-4184-a432-a3c62bd9d0a4
Sheet: 14a

Product1 | Cleared2 | Uncleared | TOTAL
Index Tranche | 0 | 7 | 7
Europe/North America | 0 | 7 | 7
Index | 11399.5 | 112 | 11511.5
Europe/Other | 4454.5 | 73 | 4527.5
North America/Asia | 6945 | 39 | 6984
Other | 9 | 23 | 32
TOTAL | 11408.5 | 142 | 11550.5
Spreadsheet: 142357d1329790918-n-a-in-the-cell-does-not-allow-to-calculate-total-bid-fee-tabulation
Sheet: Contract Numbers

Discipline | Company | Phase I                                         Survey, Landlord App'l Package |  | Phase II                                         CD's | Phase III                                         CA | Reimbursables | TOTAL
Architectural
 | Architect | 300 | 1000 | 5000 | 2000 | 800 | 8300
 | Estimated Reimbursables |  | 100 | 500 | 200
Mechanical, Electrical & Plumbing
 | Eng. C | 1100 | 1400 | 6300 | 500 | 330 | 9300
 | Estimated Reimbursables | 70 |  | 110 | 150
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Structural
 | Struct A. | 500 | 400 | 4000 | 900 | 0 | 5800
 | Estimated Reimbursables | 0 |  | 0 | 0
Fire Protection
 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | Estimated Reimbursables | #N/A |  | #N/A | #N/A
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Civil
 | Civil A | 150 | 0 | 7200 | 1000 | 400 | 8350
 | Estimated Reimbursables | 50 |  | 200 | 150
Bldg. Dept. Plan Review Fees
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Geotechnical
 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | Estimated Reimbursables | #N/A |  | #N/A | #N/A
Skylight Energy Modeling
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Expediter & Third Party Reviewer
 |  |  |  | 1500 |  | 0 | 1500
 | Estimated Reimbursables
Landscape
 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | Estimated Reimbursables | #N/A |  | #N/A | #N/A
 | Reimbursable Sub-total Per Phase | #N/A | 100 | #N/A | #N/A
 | SUB-TOTALS PER PHASE | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | Additional Services NOT INCLUDED in Base Contract
SUB TOTAL | #N/A
REIMBURSABLS | #N/A
GRAND TOTAL | #N/A
Spreadsheet: 599914d1543357044-change-cell-colour-based-on-the-value-of-one-cell-2019-cohort-qla
Sheet: Higher Writing

 | Question | 1.1&1.2 | 2.1&2.2 | 3
 | Out of | 16 | 32 | 12
 | Topic | Town and region OR Festivals | Holidays and Festivals OR School and Free Time | Translation EN>SP
 | OP1
 | OP3 | 13 | 22 | 11
 | OP1
 | OP3
 | OP2
 | OP1
 | OP3
 | OP3
 | OP1
 | OP2
 | OP3 | 9 | 11 | 5
 | OP3
 | OP2
 | OP1
 | OP2
 | OP3
 | OP1
 | OP2
 | OP1
 | OP3 | 10 | 12 | 5
 | OP2
 | OP2
 | OP1
 | OP2
 | OP1
 | OP2
 | OP3
 | OP1
 | OP1
 | OP3 | 10 | 25 | 9
 | OP2
 | OP1
 | OP2
 | OP2
 | OP2
 | OP2
 | OP2
 | OP2
 | OP3
 | OP2
 | OP2
 | OP3
 | OP2
 | OP3 | 4 | 7 | 5
 | OP2
 | OP3
 | OP3 | 3 | 11 | 5
 | OP2
 | OP3 | 6 | 8 | 4
 | OP3 | 0 | 8 | 2
 | OP1
 | OP1
 | OP2
 | OP2
 | OP2
 | OP1
 | OP2
 | OP1
 | OP2
 | OP3
 | OP3
 | OP1
 | OP2
 | OP1
 | OP1
 | OP1
Spreadsheet: 0af5bbbd-3f99-45d6-91e8-509b5a4b431e
Sheet: FACULTY INFORMATION FORM

Please use capital letters & no punctuation | EXAMPLE | class 1 info | class 2 info | class 3 info | class 4 info | class 5 info | class 6 info
Last Name | LOGAN
First Name | SARAH
MI | M
Printed Course Prefix (e.g. USTD) and Number | PSY3303
Printed Date/Time (e.g. MW 08:00 AM, TR 12:30 PM or MWF 18:00 PM) | TR 18:00 PM
Bubbled in Meeting Days (MTWRFSN) NO [NAME] or Spaces | TR
In the Classroom Survey = Face  OR  Online Survey = Online | Face
Eight Week Course = Y (yes) or N (no).    If YES… 1 for first eight weeks or 2 for second eight weeks | Y-2
For On-line courses ONLY - Print course title. In addition, please provide a class roster with [NAME] "username@angelo .edu" with your FIF.  Dropped students can be withdrawn later. | Learning  and Cognition
Objectives:  (Scale - M = Minor or No Importance,  I = Important,                              E = Essential) | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E
1.  Gaining factual knowledge (terminology, classifications, methods,       trends) | E
2.  Learning fundamental principles, generalizations, or theories | E
3.  Learning to apply course material (to improve thinking, problem       solving,  and decisions) | E
4.  Developing specific skills, competencies, and points of view needed       by professionals in the field most closely related to this course | I
5.  Acquiring skills in working with others as a member of a team | I
6.  Developing creative capacities (writing, inventing, designing,       performing in art, music, drama, etc.) | M
7.  Gaining a broader understanding and appreciation of       intellectual/cultural activity (music, science, literature, etc.) | M
8.  Developing skill in expressing oneself orally or in writing | M
9.  Learning how to find and use resources for answering questions or       solving problems | M
10.  Developing a clearer understanding of, and commitment to, personal         values | M
11.  Learning to analyze and critically evaluate ideas, arguments,         and points of view | M
12.  Acquiring an interest in learning more by asking questions and         seeking answers | M
[NAME] (e.g. USTD) | PSY | USTD | USTD | USTD | USTD | USTD | USTD
Discipline codes:  USTD = 9900                                    (4 digits) | 4200 | 9900 | 9900 | 9900 | 9900 | 9900 | 9900
[NAME] (e.g. 800, 1230, or 1800) | 800
Bubbled Course Number                                                 (4 digits) | 3303
Enrollment | 23
Local Code for USTD 2323 = 0200    Local Code for USTD = 1115 Local Code for USTD (Up & Coming Scholars) = 1125 Local Code for USTD (Students Majoring in Math or Science) = 1150 Local Code for USTD (Career Dev.) = 1190                           (4 digits)
Long (L)  Forms | L
Number of Additional Questions to be answered on the Survey  ([NAME]. number of Additional questions that can be asked for Long form = 19 & Short form = 10) | 12
Is this class [NAME]?   Y or N | N
Spreadsheet: 858420d1707129054-automaticaly-updating-formulas-when-a-new-sheet-is-created-incoming-visual-inspection-register-test
Sheet: Repair Report 1 (2)

 |  | Repair Report |  |  |  |  |  | Doc. No.: | PRO-QC-012
 |  |  |  |  |  |  |  | Rev. No.: | 001
CUSTOMER: |  |  |  | SERIAL NUMBER: |  |  | DATE
PROJECT NUMBER: |  |  |  | WEIGHT |  |  | COLOUR
DRBM ID |  |  |  | [NAME] |  | lbs | DEPTH
OEM: | Matrix |  |  | 0 |  |  | SIZE ([NAME]) | 0
 |  | Repair Report |  |  |  |  |  | Doc. No.: | PRO-QC-012
 |  |  |  |  |  |  |  | Rev. No.: | 001
SUMMARY OF REPAIRS REQUIRED
BONDING |  | 0 |  | REBUILD |  | 0 | MEDIUM REPAIR
TRANSVERSE FRACTURE (TF) |  | 1 |  | PAINT & MARKING |  | 1 | MAJOR REPAIR
LONGTITUDINAL FRACTURE (LF) |  | 0 |  | SMALL REPAIR |  |  | ADDITIONAL REPAIR
INSPECTED BY: Garth Tooth |  |  | APPROVED BY: |  |  |  | CLIENT APPROVAL: (if applicable)
SIGNATURE: |  |  | SIGNATURE: |  |  |  | SIGNATURE:
DATE: |  |  | DATE: |  |  |  | DATE:
Spreadsheet: 726278d1617139335-cannot-extract-powerquery-data-into-designated-cell-from-website-6player-tennispq17with-ranking
Sheet: Tennis Data

Hard |  | Name | Age | Wins | Matches | Lost | Surface Win % | Best Surface | Best Surface Win % | Prize Money | ATP/WTA ranking
victoria-azarenka |  | victoria-azarenka | 31 | 568 | 792 | 224 | 0.7429 | Hard | 0.7429 | 32347288
angelique-kerber |  | angelique-kerber | 33 | 627 | 977 | 350 | 0.666 | Grass | 0.7115 | 29853978
Hard |  | Name | Age | Wins | Matches | Lost | Surface Win % | Best Surface | Best Surface Win % | Prize Money | ATP/WTA ranking
anastasija-sevastova |  | anastasija-sevastova | 30 | 423 | 670 | 247 | 0.5978 | Clay | 0.6856 | 7535114
simona-halep |  | simona-halep | 29 | 540 | 769 | 229 | 0.6848 | Clay | 0.7617 | 37045910
Hard |  | Name | Age | Wins | Matches | Lost | Surface Win % | Best Surface | Best Surface Win % | Prize Money | ATP/WTA ranking
petra-kvitova |  | petra-kvitova | 31 | 562 | 812 | 250 | 0.6675 | Carpet | 0.875 | 32572604
johanna-konta |  | johanna-konta | 29 | 386 | 628 | 242 | 0.6393 | Hard | 0.6393 | 9727685
I. Hard |  | Name | Age | Wins | Matches | Lost | Surface Win % | Best Surface | Best Surface Win % | Prize Money | ATP/WTA ranking
gregoire-barrere |  | gregoire-barrere | 27 | 342 | 587 | 245 | 0.6175 | Grass | 0.6316 | 1196940
maxime-janvier |  | maxime-janvier | 24 | 277 | 500 | 223 | 0.4865 | Clay | 0.5814 | 482917
Clay |  | Name | Age | Wins | Matches | Lost | Surface Win % | Best Surface | Best Surface Win % | Prize Money | ATP/WTA ranking
miljan-zekic |  | miljan-zekic | 32 | 532 | 839 | 307 | 0.6494 | Clay | 0.6494 | 271555
[NAME]-madaras |  | [NAME]-madaras | 23 | 150 | 245 | 95 | 0.6215 | Hard | 0.6875 | 36732
Hard |  | Name | Age | Wins | Matches | Lost | Surface Win % | Best Surface | Best Surface Win % | Prize Money | ATP/WTA ranking
lucas-catarina |  | lucas-catarina | 24 | 264 | 427 | 163 | 0.6642 | Hard | 0.6642 | 122566
[NAME] |  | [NAME] | 26 | 126 | 207 | 81 | 0.5794 | Clay | 0.6593 | 33245
Spreadsheet: 755980d1637217947-formula-to-return-header-for-2-highest-values-in-a-row-into-the-same-cell-combo-sorter
Sheet: INPUT

 |  | GIFT SETS
 |  |  |  |  |  |  |  |  |  |  | BY | MG | CI | SP | WG | ST | WH | GN | Tried 1st |  | Tried 2nd |  |  | Desired Effect
STAPLE 1 |  | STAPLE 1 | XXXXX |  | CONSTANT |  |  |  |  | STAPLE 1 |  | -125 | -117 | -120 |  |  |  |  |  |  |  |  |  | CI, SP
STAPLE 2 |  | STAPLE 2 | XXXXX |  | CONSTANT |  |  |  |  | STAPLE 2 |  | 15 | 18 | 21 |  |  |  |  |  |  |  |  |  | SP, CI
PICK 3 |  |  | XXXXX |  | ONLY FOR LARGER SETS |  |  |  |  | PICK 3
PICK 4 |  | 4TH | 4TH SUB | +1.5 | PL-/PL+ |  |  |  |  | PICK 4 |  | 160 | 150 | 160 |  |  |  |  |  |  |  |  |  | MG, SP
PICK 5 |  | 5TH | 5TH SUB | +1.5 | PL-/PL+ OR SU FAV & DOG |  |  |  |  | PICK 4 sub |  | -190 | -185 | -170 |  |  |  |  |  |  |  |  |  | SP, CI
PICK 6 |  | 6TH | 6TH SUB | +1.5 |  |  |  |  |  | PICK 5
PICK 7 |  | 7th | 7th SUB | +1.5 |  |  |  |  |  | PICK 5 sub
PICK 8 |  | LRG | XXXXX |  | LARGE |  |  |  |  | PICK 6
PICK 9 |  | XL |  |  | XL SET |  |  |  |  | PICK 6 sub
PICK 10 |  | JUM |  |  | JUMBO SET |  |  |  |  | PICK 7
 |  |  |  |  |  |  |  |  |  | PICK 7 sub
 |  |  |  |  |  |  |  |  |  | PICK 8
 |  |  |  |  |  |  |  |  |  | PICK 9
1 |  | 2 |  | 3 |  | 4 |  |  |  | PICK 10
5 |  | 6 |  | 7 |  | 8
9 | 10 | 11 | 12
13 | 14 | 15 | 16
Spreadsheet: 268873d1380871843-lookup-multiple-criteria-to-return-a-value-nitaa
Sheet: Sheet1

Division | Value1 | Value2 | Value3 | Value4 | Value5 | Value6 | Value7 | Value8 | Value9 | Value10 | Value11 | Value12
AB sales | 1000 | 1200 | 1300 | 2200 | 2300 | 2310 | 5300 | 5301 | 5302 | 1601
BC sales | 5000
CD sales | 3100 | 3200
Aftersales-S | 1400 | 1700 | 2400 | 2700 | 3400 | 4400 | 6000 | 6100 | 6300 | 6900 | 8400 | 8700
Aftersales-P | 6200
Cost Centres | Division
Spreadsheet: 684850d1593581984-lookup-values-matching-date-range-plus-criteria-daterangewithcriteria
Sheet: Sheet1

Account | Start Date Lv | Value | Expected outcome |  |  |  | Account | Value | Effective From | Effective To
2736 | 2014-10-17 00:00:00 |  | 42 |  |  |  | 2736 | 51 | 2015-04-28 00:00:00 | 31/12/2999
2736 | 2015-03-06 00:00:00 |  | 42 |  |  |  | 2736 | 42 | 2014-02-01 00:00:00 | 2015-04-28 00:00:00
2736 | 2015-12-14 00:00:00 |  | 51 |  |  |  | 3404 | 63 | 2017-04-28 00:00:00 | 31/12/2999
2736 | 2016-08-01 00:00:00 |  | 51 |  |  |  | 5098 | 38 | 2016-02-10 00:00:00 | 31/12/2999
2736 | 2017-05-07 00:00:00 |  | 51 |  |  |  | 11794 | F9 | 2019-02-11 00:00:00 | 31/12/2999
23648 | 2017-05-15 00:00:00 |  | 51 |  |  |  | 11794 | F9 | 2019-02-01 00:00:00 | 2019-02-11 00:00:00
5098 | 2017-05-15 00:00:00 |  | 38 |  |  |  | 11794 | F9 | 2017-04-28 00:00:00 | 2019-02-01 00:00:00
11794 | 2017-07-17 00:00:00 |  | F9 |  |  |  | 14261 | 51 | 2017-04-28 00:00:00 | 31/12/2999
20666 | 2017-08-07 00:00:00 |  | 51 |  |  |  | 20666 | 51 | 2017-04-28 00:00:00 | 31/12/2999
3404 | 2017-10-17 00:00:00 |  | 63 |  |  |  | 22501 | M2 | 2018-04-09 00:00:00 | 31/12/2999
2736 | 2017-11-20 00:00:00 |  | 51 |  |  |  | 22501 | 51 | 2017-04-28 00:00:00 | 2018-04-09 00:00:00
23450 | 2018-01-08 00:00:00 |  | 51 |  |  |  | 23450 | 51 | 2017-04-28 00:00:00 | 31/12/2999
9184 | 2018-01-15 00:00:00 |  | N/A | (not in list) |  |  | 23565 | 51 | 2018-06-04 00:00:00 | 31/12/2999
22501 | 2018-02-19 00:00:00 |  | M2 |  |  |  | 23565 | 38 | 2018-06-04 00:00:00 | 2018-06-04 00:00:00
20666 | 2018-02-20 00:00:00 |  | 51 |  |  |  | 23565 | 42 | 2017-04-28 00:00:00 | 2018-06-04 00:00:00
22501 | 2019-02-26 00:00:00 |  | M2 |  |  |  | 23648 | 51 | 2017-04-28 00:00:00 | 31/12/2999
22501 | 2018-03-05 00:00:00 |  | 51 |  |  |  | 25794 | 51 | 2017-04-28 00:00:00 | 31/12/2999
22501 | 2017-07-12 00:00:00 |  | 51 |  |  |  | 26589 | 51 | 2017-05-16 00:00:00 | 31/12/2999
22501 | 2016-03-19 00:00:00 |  | N/A | (not in any range)
26589 | 2018-04-04 00:00:00
22501 | 2018-04-09 00:00:00 |  | M2 | (9/4/18 shows as end date [K12] & start date [J11]. Start date to count)
23565 | 2018-04-14 00:00:00 |  | 42
9184 | 2018-04-16 00:00:00 |  | N/A | (not in list)
14261 | 2018-04-30 00:00:00 |  | 51
23648 | 2018-05-15 00:00:00 |  | 51
22501 | 2018-05-20 00:00:00 |  | M2
22501 | 2018-05-28 00:00:00 |  | M2
25794 | 2018-05-28 00:00:00 |  | 51
Spreadsheet: 96813d1296093036-estimate-the-sales-tax-book5
Sheet: Sheet1

Price of Item | Total Price Paid | Helper column | Tax rate %
9.99 | 10.49
2.5 | 2.85
Spreadsheet: 112606d1308681287-how-to-copy-specific-rows-to-another-sheet-copy-specific-rows-to-another-sheet
Sheet: Filter

 | Enter a Name ► |  | A |  | Total Records
Matching Row # | Field 1 | Field 2 | Names | Field 4 | Field 5 | Field 6 | Field 7 | Field 8
Spreadsheet: 97910d1297017090-filter-within-a-filter-within-a-filter-excel
Sheet: Sheet1

Date | Area | Normal Tix | Sale Tix | Advertised
2011-01-01 00:00:00 | BL | Day | Day | News
2011-01-06 00:00:00 | E | Month | 3Month | TS
2011-01-06 00:00:00 | MH | Month | Year | High
2011-02-02 00:00:00 | BL | Day | 10J | High
Spreadsheet: 48706d1247957045-linking-a-row-to-a-cell-that-gets-sorted-by-autofilter-south-test1
Sheet: MAIN

 | END STATE 1 | END STATE 2 | END STATE 3 | INTM OBJ 1.1 | INTM OBJ 2.1 | INTM OBJ 3.1 | AGGREGATE
COL | 1 | 1 | 1 | 1 | 1 | 1 | 6
PER | 1 | 1 | 1 | 0 | 0 | 0 | 3
PAN | 1 | 1 | 0 | 1 | 1 | 1 | 5
MEX | 1 | 1 | 0 | 0 | 1 | 1 | 4
SUR | 0 | 0 | 1 | 0 | 1 | 1 | 3
ECU | 0 | 0 | 0 | 1 | 0 | 1 | 2
HAITI | 0 | 1 | 0 | 0 | 0 | 1 | 2
GUY | 0 | 1 | 0 | 1 | 0 | 0 | 2
T&T | 0 | 0 | 0 | 1 | 0 | 0 | 1
Spreadsheet: 632002e1-12e1-4d69-8303-6c173078130e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
261342 | 63925 | Marcelo | Collet | BRA | 14 | 00:10:22 | 00:00:46 | 00:33:45 | 00:01:30 | 00:22:24 | 1 | 01:08:47
261342 | 53761 | [NAME] | Johnston | USA | 12 | 00:14:34 | [NAME] | 00:32:04 | 00:01:29 | 00:20:42 | 2 | [NAME]
261342 | 57738 | Toshio | Furuhata | JPN | 8 | 00:14:07 | 00:01:37 | 00:31:50 | 00:01:31 | 00:21:57 | 3 | 01:11:02
261342 | 66278 | [NAME] | [NAME] | JPN | 9 | 00:14:26 | 00:01:39 | 00:34:26 | 00:02:46 | 00:23:54 | 4 | 01:17:11
261342 | 70662 | Nobuyki | [NAME] | JPN | 10 | 00:32:09 | 00:03:32 | 00:42:29 | 00:04:23 | 00:32:34 | 5 | 01:55:07
261342 | 70664 | Naoya | Maruyama | JPN | 11 | 00:21:09 | 00:03:52 | [NAME] | 00:03:51 | 00:47:00 | 6 | 01:57:11