tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 86971d1286904237-count-uniques-countuniques_dependent
Sheet: Formula2

 | ID | State |  |  | Unique IDs | Count of Unique States
 | [PHONE]-[PHONE] | Alabama |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alabama |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arizona |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | American Samoa |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arizona |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arizona |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arizona |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | American Samoa |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arizona |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alaska |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alabama |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | American Samoa |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arizona |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alabama |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | American Samoa |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arizona |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alabama |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alabama |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arizona |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alabama |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alaska |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | American Samoa |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arizona |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alabama |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alaska |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arkansas |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | American Samoa |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alabama |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | American Samoa |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arizona |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alaska |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alaska |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | American Samoa |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | American Samoa |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alabama |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | American Samoa |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arkansas |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Alabama |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arizona |  |  | [PHONE]-[PHONE]
 | [PHONE]-[PHONE] | Arizona
 | [PHONE]-[PHONE] | Arkansas
 | [PHONE]-[PHONE] | American Samoa
 | [PHONE]-[PHONE] | Arizona
 | [PHONE]-[PHONE] | Alaska
 | [PHONE]-[PHONE] | Alaska
 | [PHONE]-[PHONE] | Alaska
 | [PHONE]-[PHONE] | American Samoa
 | [PHONE]-[PHONE] | Alaska
 | [PHONE]-[PHONE] | Arizona
 | [PHONE]-[PHONE] | Arkansas
 | [PHONE]-[PHONE] | Alabama
 | [PHONE]-[PHONE] | Alaska
 | [PHONE]-[PHONE] | Arkansas
 | [PHONE]-[PHONE] | Alaska
 | [PHONE]-[PHONE] | Alaska
 | [PHONE]-[PHONE] | Arizona
 | [PHONE]-[PHONE] | Arizona
 | [PHONE]-[PHONE] | Arkansas
 | [PHONE]-[PHONE] | Arkansas
Spreadsheet: 87230d1287073609-question-about-averaging-quiz-grades-help-skwiskwis
Sheet: Foglio1

Average for Top | 15
Spreadsheet: 804458d1668086560-dependent-validation-list-ctp-validation-list
Sheet: Sheet1

 | Player |  | CTP
1 | [NAME] |  | x
2 | [NAME]
3 | [NAME] |  | x
4 | [NAME]
5 | [NAME]
6 | [NAME]
7 | [NAME]
8 | [NAME] |  | x
9 | [NAME] |  | x
10 | [NAME]
11 | [NAME]
12 | [NAME]
13 | [NAME] |  | x
14 | [NAME]
15 | [NAME]
16 | [NAME]
17 | [NAME]
18 | [NAME] |  | x
19
20
21
22
23
24
 |  |  |  |  | Player Entered CTP
 |  |  |  |  |  |  | <-- dropdown in this box of ONLY players in CTP
Spreadsheet: 466696d1466405036-text-box-values-demo1
Sheet: Sheet1

60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Box number | Value
58 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 56
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 46
56 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 53
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 56
54 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 30
52
50
48
46
44
42
40
38
Spreadsheet: 716408d1612197650-sum-values-with-criteria-sample
Sheet: PAYDAY 29th June

Week: | Hours: | Pay: | Notes: |  |  | Break Down: |  |  |  |  |  |  | WEEKLY PAY: | DAILY PAY: | HOURLY:
BASIC: |  | 2000
ADDITION: |  | 270.05 |  |  |  | Natwest:
OTHER BONUS: |  |  |  |  |  | Rent:
 |  |  |  |  |  | Car:
[NAME]: |  | 50.96 |  |  |  | Loan:
 |  |  |  |  |  | Phone:
Est Tax: |  |  |  |  |  | Credit Improver:
Est NI: |  |  |  |  |  | ISA:
Total: |  |  |  |  |  | Total:
Total Est Pay Before Tax: |  |  |  |  |  | Monzo:
Total Est Pay After Tax: |  |  |  |  |  | Predicted: |  |  | Actual:
Actual Pay: |  |  |  |  |  | Amount L/O |  |  | Amount L/O
 |  |  |  |  |  | Days till next pay | 28 |  | Days till next pay | 28
Deductions: |  |  |  |  |  | Budget |  |  | Budget
Rent |  | 240
Fuel |  | 160
Car Insurance |  | 181.68
Phone |  | 15
Loan |  | 130.08
ISA |  | 200
Credit Improver |  | 12
Credit Card |  | 200
Other |  | 156.77
Budget: |  | 310 |  |  |  | NI Calculator:
Total: |  |  |  |  |  | PA: | 793.05
 |  |  |  |  |  | BT - PA:
Total Est Left On 29th June:
Total Acc Left On 29th June: |  |  |  |  |  | Total:
 |  |  |  |  |  | Tax Calculator:
 |  |  |  |  |  | PA: | 954.18
 |  |  |  |  |  | BT - PA:
 |  |  |  |  |  | Est Tax:
Spreadsheet: 121429d1316047621-changing-reference-cells-changing-refs
Sheet: Sheet1

 |  | 1
1 | A
 | B
 | C
 | D
 | E
 | F |  |  | OBVIOUSLY THE DATA IN COLUMN'S "A" and "B" Represent the Date in your Worksheet 1. The DATA From Column "C" to the right Represent your Worksheet 2. IT IS THE METHODOLOGY YOU NEED TO USE.
 | G
 | H
 | I
 | J
Spreadsheet: 865887d1712849435-advanced-filter-sample
Sheet: Filtered Data - Figured Out

 |  |  |  |  |  |  |  |  |  |  | Filter By
 |  |  |  |  |  |  |  |  |  |  | Zone | Status
Zone | Location | Name | Address | Status | Temp Address | Date |  |  |  |  | North | Previous
North | City | [NAME] | 123 Everywhere | Current | 987 There | 2024-01-13 00:00:00
North | Rural | Brittany | 123 Everywhere | Current | 987 There
Spreadsheet: 93900d1293661016-excel-2007-clearing-a-row-after-a-particular-word-selected-cat-working-file
Sheet: 900MK

900MK
LAST QUARTERLY | QUARTERLY DUE NLT | NEXT QUARTERLY START | UPDATED BY: | LAST MASO | MASO DUE NLT | NEXT MASO START | UPDATED BY: | JACKET REVIEW | IMT 68     DATE | IMT 68 REVIEW
2010-09-09 00:00:00 |  |  | MF | 2010-02-18 00:00:00 |  |  | mf | 2010-12-01 00:00:00 | 2009-08-19 00:00:00
JACKET REVIEW
NAME |  | DATE ACCOMPLISHED |  | COMMENTS / FINDINGS
Feeney |  | 2010-12-01 00:00:00
GENERAL ACCOUNT INFORMATION / NOTES
RETURN TO STATUS PAGE |  |  | INVENTORY STATUS PAGE
Spreadsheet: 155124d1336674957-concatenate-cell-with-min-value-and-a-cell-on-same-row-concatenate
Sheet: Sheet1

 |  |  | minimum | field name
 |  |  | 1 - Field G13
 |  |  |  |  |  | Field Name |  | Size
 |  |  |  |  |  | A1 |  | 14
 |  |  |  |  |  | A2 |  | 5
 |  |  |  |  |  | A3 |  | 7
 |  |  |  |  |  | A4 |  | 8
 |  |  |  |  |  | A5 |  | 41
 |  |  |  |  |  | A6 |  | 100
 |  |  |  |  |  | A7 |  | 55
 |  |  |  |  |  | A8 |  | 5
 |  |  |  |  |  | A9 |  | 12
 |  |  |  |  |  | A10 |  | 7
 |  |  |  |  |  | A11 |  | 7
 |  |  |  |  |  | A12 |  | 1
 |  |  |  |  |  | A13 |  | 44
 |  |  |  |  |  | A14 |  | 7
 |  |  |  |  |  | A15 |  | 8
 |  |  |  |  |  | A16 |  | 4
Spreadsheet: 713855d1610980098-match-function-looking-up-number-value-20210718_su2xl_kalk-update_xl-help
Sheet: CODE

CODE | CL | CB | CH
0100010 | [NAME] length 2 | Min length | [NAME] length
1010011 | [NAME] length | Min length | [NAME] length
0001010 | [NAME] length | [NAME] length | Min length
1000000 | [NAME] length | [NAME] length 2 | Min length
1010010 | [NAME] length | [NAME] length 2 | [NAME] length 2
0010000 | [NAME] length | Min length | [NAME] length 2
0011100 | [NAME] length | [NAME] length | [NAME] length
1010011 | [NAME] length | Min length | [NAME] length
0100001 | [NAME] length 2 | Min length | [NAME] length
0010001 | [NAME] length | Min length | [NAME] length 2
0100000 | [NAME] length 2 | Min length | [NAME] length
Spreadsheet: 593544d1539197872-correct-way-of-linking-data-to-master-workbook-test-sheet
Sheet: Day 1 - 4 Breakfast

Tomatokeftedes and Mizeria
 | Ingredients | QTY | Measurement | Macros calculated from Quantity
 |  |  |  | CAL | P | F | C
 | Oats | 1.8
 | whey protein powder | 0.5
 | almond milk | 3
 | chia seeds | 0.6
 | yoghurt | 0.8
 | Apple | 0.5
 |  | 0.05
 |  | 0.8
 |  | 1.2
 |  | 0.2
 |  | 0.05
 | Total - Entire Recipe
 | No. Of Servings | 4 |  | CAL | P | F | C
 | Per Serving
 | Check
 | Rounded
Spreadsheet: f4ac5330-d5f0-4fc1-ac50-652affddeb57
Sheet: Sheet1

Season Schedule | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Date | Game Number | Visiting Team | Visiting Score | Home Team | Home Score | Game Time/Status | Venue
2013-04-26 | 1 | Charlotte | 4 | Oklahoma City | 3 | Final OT | Cox Convention Center Oklahoma City, OK
2013-04-27 | 2 | Charlotte | 2 | Oklahoma City | 5 | Final | Cox Convention Center Oklahoma City, OK
2013-05-01 | 3 | Oklahoma City | 1 | Charlotte | 6 | Final | Time Warner Cable [NAME], NC
2013-05-03 | 4 | Oklahoma City | 8 | Charlotte | 1 | Final | Time Warner Cable [NAME], NC
2013-05-04 | 5 | Oklahoma City | 6 | Charlotte | 2 | Final | Time Warner Cable [NAME], NC
2013-05-09 | 1 | Oklahoma City | 2 | Texas | 1 | Final OT | Cedar Park Center Cedar Park, TX
2013-05-11 | 2 | Oklahoma City | 1 | Texas | 2 | Final | Cedar Park Center Cedar Park, TX
2013-05-13 | 3 | Texas | 0 | Oklahoma City | 4 | Final | Cox Convention Center Oklahoma City, OK
2013-05-15 | 4 | Texas | 3 | Oklahoma City | 7 | Final | Cox Convention Center Oklahoma City, OK
2013-05-16 | 5 | Texas | 1 | Oklahoma City | 5 | Final | Cox Convention Center Oklahoma City, OK
2013-05-24 | 1 | Oklahoma City | 1 | Grand Rapids | 2 | Final | [NAME] Arena Grand Rapids, MI
2013-05-25 | 2 | Oklahoma City | 4 | Grand Rapids | 2 | Final | [NAME] Arena Grand Rapids, MI
2013-05-29 | 3 | Grand Rapids | 1 | Oklahoma City | 4 | Final | Cox Convention Center Oklahoma City, OK
2013-06-01 | 4 | Grand Rapids | 4 | Oklahoma City | 0 | Final | Cox Convention Center Oklahoma City, OK
2013-06-02 | 5 | Grand Rapids | 3 | Oklahoma City | 0 | Final | Cox Convention Center Oklahoma City, OK
2013-06-04 | 6 | Oklahoma City | 4 | Grand Rapids | 3 | Final | [NAME] Arena Grand Rapids, MI
2013-06-05 | 7 | Oklahoma City | 4 | Grand Rapids | 5 | Final | [NAME] Arena Grand Rapids, MI
Spreadsheet: 329659d1404378732-collate-data-problem-solving-sample-work-book
Sheet: Tab 3

 |  |  |  |  |  |  |  | Price [NAME]
 | Labour | Grade | Cost | Personnel | Days | Hr/Day
 | Travel and Subsistence | Basis
 | Materials and Subcontract | Basis | Cost
 | Pricing
 | Total labour
 | Total T&S
 | Total materials
Spreadsheet: 188945d1351031265-is-there-a-way-to-apply-conditional-format-if-duplicate-but-only-for-a-certain-value-cf-demo
Sheet: MASTER

Inst/Train/Part | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday |  |  | Saturday
Instructor 1 | Trainee1 | Trainee2 | Trainee3 | Trainee1 | Trainee2 | Trainee3 | Trainee1 | Trainee2 | Trainee3 | Trainee1 | Trainee2 | Trainee3 | Trainee1 | Trainee2 | Trainee3 | Trainee1 | Trainee2 | Trainee3
 | NP | 10:00 | Lunch 1 | NP | 8:00 | Lunch 1 | NP | 10:00 | Lunch 1 | NP | 8:00 | Lunch 1 | NP | 9:00 | Lunch 1 | NP | 8:00 | Lunch 1
 | Special Event |  |  | Special Event |  |  | Special Event |  |  | Special Event |  |  | Special Event |  |  | Special Event
 | Notes |  |  | Notes |  |  | Notes |  |  | Notes |  |  | Notes |  |  | Notes
Spreadsheet: 698262d1601891412-return-sum-of-all-values-between-start-and-end-time-on-specific-day-appointment-impact-calculator-ans
Sheet: Sheet1

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
00:00:00 | 2 | 3 | 4 | 5 | 6 | 7 | 8
00:00:00 | 0 | 5 | 3 | 7 | 7 | 2 | 5
01:00:00 | 0 | 3 | 0 | 4 | 2 | 0 | 3 |  | Day of Week (Start) | Monday
02:00:00 | 0 | 1 | 3 | 3 | 1 | 3 | 0 |  | Start Time | 08:00:00
03:00:00 | 0 | 2 | 4 | 4 | 2 | 1 | 0 |  | Day of Week (End | Tuesday
04:00:00 | 0 | 4 | 4 | 2 | 3 | 2 | 0 |  | End Time | 12:00:00 | 0.5
05:00:00 | 0 | 3 | 2 | 4 | 3 | 0 | 0
06:00:00 | 13 | 44 | 21 | 20 | 10 | 19 | 8 |  | No. of Calls
07:00:00 | 38 | 45 | 40 | 42 | 13 | 33 | 31 |  | [NAME] result
08:00:00 | 160 | 155 | 118 | 157 | 181 | 144 | 117
09:00:00 | 303 | 288 | 247 | 260 | 330 | 214 | 147
10:00:00 | 326 | 295 | 326 | 349 | 381 | 193 | 158
11:00:00 | 310 | 325 | 286 | 313 | 361 | 163 | 93
12:00:00 | 218 | 233 | 260 | 283 | 301 | 128 | 82
13:00:00 | 184 | 174 | 168 | 246 | 220 | 113 | 90
14:00:00 | 205 | 215 | 198 | 246 | 277 | 158 | 98
15:00:00 | 195 | 192 | 159 | 212 | 243 | 140 | 104
16:00:00 | 183 | 221 | 167 | 194 | 208 | 127 | 90
17:00:00 | 150 | 156 | 131 | 142 | 158 | 76 | 90
18:00:00 | 125 | 161 | 121 | 118 | 120 | 55 | 147
19:00:00 | 145 | 175 | 117 | 132 | 83 | 74 | 157
20:00:00 | 178 | 223 | 168 | 172 | 86 | 63 | 157
21:00:00 | 146 | 178 | 140 | 194 | 92 | 71 | 104
22:00:00 | 94 | 102 | 106 | 128 | 68 | 58 | 31
23:00:00 | 61 | 73 | 54 | 75 | 53 | 50 | 22
Spreadsheet: 194060d1353024245-filtering-data-and-then-re-filtering-that-data-help-suggestions-please-membership-database-and-log-copy
Sheet: Drop Down Lists

memtype |  | paylength
Gym |  | 1 Day Boot Camp
Power House |  | 1 Week
By Session |  | 2 Weeks
 |  | 1 Month
[NAME] |  | 3 Months
Yes |  | 1 Year
No |  | Drop In
 |  | 10 Sessions
 |  | Other
 |  | paytype
 |  | Cash
 |  | Check
 |  | Credit Card
 |  | cctype
 |  | Visa
 |  | Master [NAME]
 |  | Discovery
 |  | American Express
Spreadsheet: 723221d1615563112-count-duplicate-values-in-the-same-cell-and-in-a-range-example-1-2-1-
Sheet: Sheet1

 | INVOICE DATE | SITE | INVOICE AMOUNT | CHARGABLE | PLOT(S)
 | 2021-02-26 00:00:00 | Gipping [NAME] | 20 | YES | 123, 124, 125, 126
 | 2021-03-04 00:00:00 | Gipping [NAME] | 20 | YES | 108, 110
 | 2021-03-05 00:00:00 | Gipping [NAME] | 20 | NO | 108, 987
 | 2021-03-02 00:00:00 | Gipping [NAME] | 20 | NO | 108
 | 2021-02-03 00:00:00 | Gipping [NAME] | 20 | YES | 109
 | 2021-02-01 00:00:00 | Gipping [NAME] | 20 | NO | 123, 124
 | 2021-02-26 00:00:00 | Gipping [NAME] | 20 | YES | 82, 83
 | 2021-02-25 00:00:00 | Colne Meadows | 20 | NO | 2
 | 2021-02-24 00:00:00 | Colne Meadows | 20 | NO | 1
 | 2021-02-20 00:00:00 | Colne Meadows | 20 | NO | 1, 2
 | 2021-02-19 00:00:00 | Colne Meadows | 20 | NO | 3
 | 2021-02-18 00:00:00 | Colne Meadows | 20 | NO | 3, 4
 | 2021-02-17 00:00:00 | Colne Meadows | 20 | NO | 4
 | 2021-02-15 00:00:00 | Colne Meadows | 20 | NO | 4
 | 2021-02-16 00:00:00 | Gipping [NAME] | 20 | YES | 127
Spreadsheet: 0a8791de-84e4-4eb4-bfac-22483612972b
Sheet: Office Systems Tech

OFFICE SYSTEMS TECHNOLOGY
Associate in Applied Science
Student Name:
ID #
Office Systems Technology | Semester | Grade
General Education
___ ENG 101 (3) Writing I
___ MAT 105 (3) Business Mathematics
OR ___ MAT 110 (3) Applied Mathematics
OR ___ Higher level Quantitative Reasoning course (3)
___ Heritage/Humanities (3)
___ Oral Communications Course (3)
___ Natural Science Course (3)
___ Social/Behavioral Sciences Course  (3)
Technical Core
___ OST 105 (3) Introduction to Information Systems
___ OST 215 (3) Office Procedures
___ OST 110 (3) Document Formatting and Word Processing
___ OST 160 (3) Records and Database Management
___ OST 210 (3) Advanced Word Processing and Applications
___ OST 240 (3) Software Integration
___ OST 235 (3) Business Communications Technology
___ OST 275 (3) Office Management
Administrative Track
___ ACT 101 (3) Fundamentals of Accounting I
OR ___ Higher level accounting course
___ OST 220 (3) Administrative Office Simulations
___ OST 225 (3) Introduction to Desktop Publishing
Choose 9 credit hours from the following list:
___ [NAME] (3) Introduction to Business
___ ENG 102 (3) Writing II
___ [NAME] (3) Personal Finance
___ OST 255 (3) Introduction to Business Graphics
___ [NAME] (3) Transcription and Office Technology
___ OST 108 (3) Editing Skills for the Office Professional
___ OST 272 (3) Presentations Graphics
___ OST 250 (3) Advanced Desktop Publishing
___ OST 295 (3) Office Systems Internship
OR ___ COE 199 (3) Cooperative Education
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 525681d1498834747-return-single-value-by-searching-multiple-criteria-in-multiple-column-ramesh
Sheet: PRODUCT LIST

S NO | BRAND NAME | PRODUCT NAME | [NAME] | SIZE | COLOUR | PAGES | Product code
1 | TNPL | A4 SHEET | GSM | 70 | NA | 500 | A0001
 | TNPL | A4 SHEET | GSM | 75 | NA | 500 | A0002
 | CLASSMATE | NOTE | SPIRAL | 12X14 | GREEN | 80 | A0003
 | CAMLIN | PEN | GH | NA | YH | NA | A0004
 | CASIO | CALC | MJ3 | NA | NA | NA | A0005
 | TNPL | A4 SHEET | GSM | 70 | NA | 500 | A0001
Spreadsheet: 841089d1693339970-sumif-s-countif-s-test-4-1-
Sheet: Sheet1

Pilot | Registered | Car |  | Registered | Y
A | Y | DK
A | Y | DK |  | Row Labels | Distinct Count of Pilot
B | N | F |  | CH | 1
B | Y | F |  | COL | 1
C | Y | USA |  | DK | 1
C | N | USA |  | E | 1
D | Y | R |  | F | 1
E | Y | I |  | FIN | 1
E | N | I |  | I | 1
E | N | I |  | P | 1
E | Y | I |  | R | 1
F | Y | COL |  | S | 1
F | Y | COL |  | USA | 1
F | Y | COL |  | Grand Total | 11
F | Y | COL
G | Y | E
G | Y | E
H | N | P
H | Y | P
J | Y | S
K | Y | FIN
K | N | FIN
L | Y | CH
L | N | CH
Spreadsheet: 151095d1334777805-ranks-a-list-of-numbers-however-ranking-whilst-ignoring-or-signs-results-copy
Sheet: Sheet1

Results
PP | Cond A | Cond B | d | Rank of D | Rank of + diff | Rank of - diff
1 | 9 | 5 | 4 | 10 | 4
2 | 8 | 3 | 5 | 13 | 5
3 | 10 | 6 | 4 | 10 | 4
4 | 5 | 8 | 3 | 5 | 3
5 | 7 | 4 | 3 | 5 | 3
6 | 9 | 6 | 3 | 5 | 3
7 | 9 | 5 | 4 | 10 | 4
8 | 8 | 4 | 4 | 10 | 4
9 | 8 | 5 | 3 | 5 | 3
10 | 8 | 4 | 4 | 10 | 4
11 | 7 | 6 | 1 | 1 | 1
12 | 7 | 4 | 3 | 5 | 3
13 | 8 | 6 | 2 | 2 | 2
Total | 103 | 66 |  |  | 43 | 0
Mean | 7 | 5
 | NEEDS TO BE MINUS (D6 = -3, E -5
Note:
G7  should be -5
G17 should be -5
Spreadsheet: 780433d1652452091-getting-an-error-code-when-trying-to-add-more-conditions-columns-to-an-if-statement-calendar-draft
Sheet: 3 Events Per Day Monthly View

2022 | <-- Manually type the year | Test A
June | <-- Select the month from the drop down menu
Spreadsheet: 48566d1247780594-indirect-mod-row-skipping-a-lot-of-rows-test-f-ms-annual-student-report-template-07-16-09-fs
Sheet: SAP

Date | Notes
Subtype
Reporter
Advocate
Spreadsheet: 75893d1276510932-merging-several-tabs-attendance-template
Sheet: Summary

Management Attendance Sheet
 |  |  | May
Name |  | Contracted hours | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 |  | 38 | W | R | W | R | T | T | W | W | W | W | R | W | W | W | W | W | W | R | W | W | W | W | W | T | W | W | R | W | W | R | W
 |  | 38 | W | W | W | W | W | W | R | R | W | R | W | W | W | W | W | W | W | W | R | W | R | W | W | W | W | R | W | R | W | W | W
 |  | 38 | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S
 |  | 38 | R | W | R | W | W | R | W | W | W | W | W | R | W | W | R | W | W | W | W | R | S | S | S | S | S | S | S | S | W | W | W
 |  | 38 | W | R | H | W | W | W | R | W | R | W | W | R | W | W | W | R | W | W | W | W | W | R | W | W | W | W | W | R | R | R | H
 |  | 38 | H | R | W | R | T | T | W | W | W | R | W | W | R | W | W | W | W | R | W | R | W | W | R | W | W | W | R | W | W | W | W
 |  | 38 | LEFT THE BUSINESS
 |  | 38 | R | R | W | W | W | W | W | R | R | W | W | W | W | W | R | R | L | W | W | W | W | R | R | W | W | W | W | W | R | R | H
 |  | 38 | W | W | W | W | W | W | R | R | R | W | W | R | W | W | W | R | H | H | R | H | H | H | W | W | W | W | W | R | R | W | W
 |  | 38 | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | W | W | W | R | W | R | W | W | R | W | W | R | W
 |  | 38 | LEFT THE BUSINESS
 |  | 38 | W | R | H | H | H | H | H | R | W | W | W | W | W | R | R | W | W | W | R | W | R | W | W | W | R | W | W | R | W | W | R
 |  | 38 | R | W | W | R | W | W | W | W | W | W | R | W | W | W | R | R | W | W | W | W | W | R | W | W | W | W | W | R | R | R | W
 |  | 38 | H | R | R | W | W | W | W | W | W | W | W | R | R | W | W | W | W | R | W | W | W | R | W | W | W | R | W | R | W | W | R
 |  | 38 | R | R | R | W | W | W | W | W | W | R | W | W | W | W | R | W | W | W | R | PRESTON
 |  | 38 | W | W | W | W | R | W | R | W | W | W | W | W | R | R | W | W | W | W | W | R | R | W | R | H | H | H | L | L | R | R | R
 |  | 38 | W | W | W | W | W | W | R | R | R | H | H | H | H | H | R | W | W | W | R | W | W | W | W | R | W | W | R | W | W | W | R
 |  |  | new starter |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R | W | W | W | W | W | R | R | W | W | W | R | W | W | W | W
Spreadsheet: 835952d1688996944-finding-the-price-from-newest-date-to-oldest-with-n-data-example
Sheet: Sheet1

SKU | Price | PO date |  |  | Result: |  | Price 1 | Price 2 | Price 3
A | 34.242424 | 2015-12-18 00:00:00 |  |  |  | A | 38.06666666666667 | 34.242424 | 37.86666666666667
A | 38.06666666666667 | 2017-07-18 00:00:00 |  |  |  | B | 38.84848486666667 | 39.51515153333334
A | 37.86666666666667 | 2015-09-30 00:00:00 |  |  |  | C | 34.84848466666667 | 34.84848484666666 | 35
A | 38.53333333333333 | 2015-04-14 00:00:00 |  |  |  | D | 35.75757575333333
A | 39.86666666666667 | 2015-01-15 00:00:00 |  |  |  | E | 37.87878787333334 | 37.87878854 | 38
B | 39.51515153333334 | 2016-03-31 00:00:00
B | 38.84848486666667 | 2016-04-16 00:00:00 |  |  | [NAME]:
C | 34.84848466666667 | 2016-02-11 00:00:00 |  |  |  |  | Price 1 | Price 2 | Price 3
C | 34.84848484666666 | 2016-01-20 00:00:00 |  |  |  | A
C | 35 | 2015-12-16 00:00:00 |  |  |  | B
D | 35.75757575333333 | 2015-11-14 00:00:00 |  |  |  | C
E | 38 | 2015-02-24 00:00:00 |  |  |  | D
E | 38 | 2015-04-07 00:00:00 |  |  |  | E
E | 38 | 2015-06-17 00:00:00
E | 38 | 2015-07-09 00:00:00
E | 38 | 2015-08-25 00:00:00 |  |  | Price 1 | Price with newest date
E | 37.87878854 | 2015-09-17 00:00:00 |  |  | Price 2 | Price with 2nd newest date
E | 37.87878787333334 | 2015-10-17 00:00:00 |  |  | Price 3 | Price with 3rd newest date
Spreadsheet: 141196d1329147810-chart-series-data-selection-automatic-axis-update-example
Sheet: example 1 data

 |  | C1 | C2 | [NAME] | C4 | C5 | C6 | C7 | C8 | C9 | C10 | C11 | C12 | C13 | C14 | C15 | C16 | C17 | C18 | C19 | C20 | C21 | C22 | C23 | C24 | C25 | C26 | C27 | C28 | C29 | C30 | C31 | C32 | C33 | C34 | C35 | C36 | C37 | C38 | C39 | C40 | C41 | C42 | C43 | C44 | C45 | C46 | C47 | C48 | C49 | C50
 |  | 19.05 | 12.192 | 11.938 | 13.97 | 9.143999999999998 | 12.192 | 12.446 | 9.143999999999998 | 9.143999999999998 | 12.192
L1 | 19.05 | 19.05 | 19.05 | 19.05 | 19.05 | 19.05 | 19.05 | 19.05 | 19.05 | 19.05 | 19.05
L2 | 12.192 | 19.05 | 12.192 | 13.208 | 14.478 | 14.224 | 14.732 | 15.24 | 13.97 | 14.224 | 14.732
L3 | 13.97 | 19.05 | 14.478 | 14.986 | 13.97 | 17.526 | 15.24 | 16.764 | 14.732 | 17.526 | 15.24
[NAME] | 9.143999999999998 | 19.05 | 15.494 | 11.938 | 14.732 | 9.143999999999998 | 14.732 | 16.256 | 9.143999999999998 | 9.143999999999998 | 14.732
L5 | 12.192 | 19.05 | 15.748 | 14.986 | 14.732 | 14.478 | 12.192 | 15.748 | 14.478 | 14.478 | 12.192
L6 | 12.446 | 19.05 | 14.478 | 14.986 | 15.494 | 14.478 | 14.224 | 12.446 | 19.05 | 14.478 | 14.224
L7 | 9.143999999999998 | 19.05 | 15.494 | 11.938 | 14.732 | 9.143999999999998 | 14.732 | 16.256 | 13.97 | 9.143999999999998 | 14.732
L8 | 12.192 | 19.05 | 15.748 | 14.986 | 14.732 | 14.478 | 12.192 | 15.748 | 14.732 | 14.478 | 12.192
L9 | 10 | 19.05 | 14.478 | 14.986 | 15.494 | 14.478 | 14.224 | 12.446 | 10 | 14.478 | 14.224
L10 | 19.05 | 19.05 | 19.05 | 19.05 | 19.05 | 19.05 | 19.05 | 19.05 | 19.05 | 19.05 | 19.05
L11
L12
[NAME]
[NAME]
L15
L16
L17
L18
L19
L20
[NAME]
L22
[NAME]
L24
[NAME]
L26
L27
L28
L29
L30
[NAME]
L32
[NAME]
L34
L35
[NAME]
L37
L38
L39
L40
[NAME]
L42
[NAME]
L44
L45
L46
L47
L48
L49
L50
Spreadsheet: 538748d1505817349-moving-from-verticle-to-horizonatal-but-still-matching-the-verticle-data-book1
Sheet: Sheet1

A/C | Ref No |  |  |  | Ref No
Q | 1
W | 2
E | 2
R | 3
T | 4
Y | 3