tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 769702d1645642922-return-a-match-when-a-tyre-size-is-inputed-tyre-sizes-book
Sheet: Sheet1

15 Inch | 16 Inch | 17 Inch | 18 Inch | 19 Inch | 20 Inch
205/70/15 | 165/70/16 | 145/70/17 | 175/50/18 | 165/55/19 | 205/35/20 |  | 192/70/15
195/70/15 | 175/70/16 | 155/70/17 | 185/50/18 | 165/50/19 | 215/35/20
185/70/15 | 175/65/16 | 165/70/17 | 195/50/18 | 175/50/19 | 225/35/20
215/65/15 | 185/65/16 | 155/65/17 | 205/50/17 | 185/50/19 | 205/30/20
205/65/15 | 195/65/16 | 165/65/17 | 195/45/18 | 205/45/19 | 215/30/20
195/65/15 | 185/60/16 | 175/65/17 | 205/45/18 | 185/40/19 | 225/30/20
235/60/15 | 195/60/16 | 165/60/17 | 215/45/18 | 195/40/19 | 235/30/20
225/60/15 | 205/60/16 | 175/60/17 | 225/45/18 | 205/40/19 | 245/30/20
215/60/15 | 215/60/16 | 185/60/17 | 235/45/18 | 215/40/19 | 255/30/20
205/60/15 | 205/55/16 | 195/60/17 | 215/40/18 | 225/40/19 | 265/30/20
 | 215/55/16 | 185/55/17 | 225/40/18 | 215/35/19
 | 225/55/16 | 195/55/17 | 235/40/18 | 225/35/19
 | 235/55/16 | 205/55/17 | 245/40/18 | 235/35/19
 | 225/50/16 | 215/55/17 | 255/40/18 | 245/35/19
 | 235/50/16 | 195/50/17 | 265/40/18 | 225/35/19
 | 245/50/16 | 205/50/17 | 245/35/18 | 265/35/19
 | 245/45/16 | 215/50/17 | 255/35/18 | 245/30/19
 | 255/45/16 | 225/50/17 | 265/35/18 | 255/30/19
 | 265/45/16 | 235/50/17 | 275/35/18 | 265/30/19
 | 275/40/16 | 225/45/17 | 285/35/18 | 275/30/19
 |  | 235/45/17 | 295/35/18 | 285/30/19
 |  | 245/45/17 | 285/30/18 | 295/30/19
 |  | 255/45/17 | 295/30/18 | 305/30/19
 |  | 245/40/17
 |  | 255/40/17
 |  | 265/40/17
 |  | 275/40/17
 |  | 285/40/17
 |  | 295/40/17
 |  | 285/35/17
 |  | 295/35/17
 |  | 305/35/17
Spreadsheet: 50448d1249910203-countifs-help-testdata
Sheet: summary

Brand_ID_(IBSRP2)_(UDC) | Target
xs123 | 224.23
[NAME] | 478.25
[NAME] | 778.25
gt300 | 505.23 |  |  | b8 should count from  a2 to a11 |  |  | that the range of that brand
ftr17 | 466.35 |  |  | and only could if its higher that b2
789 ttp | 653.32
DDX1 | 454.58
spo17 | 599.86
spop5 | 466.85
121hgh | 655.12
ffp474 | 555.96
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Des McCluskey | [NAME] | [NAME]
xs123 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME]
[NAME]
gt300
ftr17
789 ttp
DDX1
spo17
spop5
121hgh
ffp474
Spreadsheet: 294641d1391456892-would-like-to-reveal-rows-depending-on-input-example-3-
Sheet: Data

Item | Quantity | Request
Cheese
Ham
Mushrooms | 2 | X
Tomatoe
[NAME]
Meat
Bread
Onion | 2 | X
Apple
[NAME]
Spreadsheet: 00188318-a763-4616-80c3-dd45176b43b3
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
2441 | 12520 | [NAME] | Carroll | USA | 200 | 00:53:28 | 00:00:00 | [NAME] | 00:00:00 | 00:30:28 | 1 | 02:46:56
2441 | 12239 | Hannelore | [NAME] | AUS | 199 | 01:03:03 | 00:00:00 | 01:49:54 | 00:00:00 | 00:35:10 | 2 | 03:28:07
Spreadsheet: lisa_gang__22232__ENA_PGE_MARCH_26_2002
Sheet: SYS-JD OR GRIZZ BR

From: | EPMI
To: | PGE System Transactions
Date: | 2002-03-26 00:00:00
HE
ENDING |  |  |  |  | SINK | SINK | SINK | SINK | SINK
Pacific Prevailing
Time | SYS/SYS OUT AT GRIZZLY | SYS | PGE LOSSES | PGE LOSSES | EPMI COB S/N | PGE LOSSES | TO GRIZZLY | TO SYS | TO [NAME] | BUY/RESALE
(PPT) |  |  |  |  | LOSS RETURN |  |  |  |  | [NAME]
0100 |  |  | 2 |  |  | -2
0200 |  |  | 2 |  |  | -2
0300 |  |  | 2 |  |  | -2
0400 |  |  | 2 |  |  | -2
0500 |  |  | 2 |  |  | -2
0600 |  |  | 2 |  |  | -2
0700 |  |  |  | 2 |  | -2
0800 |  |  |  | 2 |  | -2
0900 |  |  |  | 2 |  | -2
1000 |  |  |  | 2 |  | -2
1100 |  |  |  | 2 |  | -2
1200 |  |  |  | 2 |  | -2
1300 |  |  |  | 2 |  | -2
1400 |  |  |  | 2 |  | -2
1500 |  |  |  | 2 |  | -2
1600 |  |  |  | 2 |  | -2
1700 |  |  |  | 2 |  | -2
1800 |  |  |  | 2 |  | -2
1900 |  |  |  | 2 |  | -2
2000 |  |  |  | 2 |  | -2
2100 |  |  |  | 2 |  | -2
2200 |  |  |  | 2 |  | -2
2300 |  |  | 2 |  |  | -2
2400 |  |  | 2 |  |  | -2
 |  |  | BPA(G) | AVISTA(G) CHELAN |  |  |  |  |  | SHOULD BE ZERO
 |  |  | AVISTA(PSE) | EPMI(PSE) | EPMI COB S/N | PGE LOSSES | TO COB' | TO COB' | TO COB'
 |  |  | EPMI(PSE) | SNPD(T) MIDC/PGE SYS | LOSS RETURN |  | SEE COB SHEET | SEE COB SHEET | SEE COB SHEET
 |  |  | SNPD(T) BPAP/PGE SYS | EPMI(PSE)
 |  |  | EPMI(PSE) | PGE@SYS   LOSSES
 | PGE(L,R)SYS/SYS OUT AT GRIZZLY | PGE(L,R)SYS   SYSTEM SALE | PGE@SYS   LOSSES
 |  | NOT A BUY/RESALE
Spreadsheet: 767309d1644405088-need-help-to-get-the-count-based-on-criteria-sample-1
Sheet: Status

 |  | Position | [NAME]
 | Position | Count of Candidate | Count of Online Test | Count of Round 1 | Count of Round 2 | Count of Round 3
 | [NAME] |  | 2 | 2 | 0 | 0
 | Position | Count of Candidate | Count of Online Test | Count of Round 1 | Count of Round 2 | Count of Round 3
 | [NAME] | 17 | 7 | 3 | 0 | 0
Spreadsheet: 718249d1613059087-identify-current-format-and-convert-to-single-currency-illustration
Sheet: Sheet1

Item | Cost | Cost in € | Explanatory note
AAAA | 100 |  | B2 formatted as $ English (United States)
BBBB | 25 |  | B3 formatted as £ English (United Kingdom)
CCCC | 45 |  | B4 formatted as kr Norwegian (Nynorsk)
DDDD | 63 |  | [NAME] formatted as kr Swedish (Sweden)
Required: A conditional formula in column C that identifies the currency type from the format of its adjacent cell in Colum B and then uses the appropriate exchange rate from the sample table below for conversion into [NAME]
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
Spreadsheet: 768967d1645218936-formula-to-factor-in-start-and-end-dates-for-bonus-accrual-jan-2022-bonus-test
Sheet: Jan 2022 Bonus

 |  |  |  |  |  | 1
Start Date | End date | Annual compensation | Bonus % at Target | Bonus at Target |  | 2022-01-31 00:00:00
2022-01-01 00:00:00 | 2022-02-11 00:00:00 | 180000 | 0.1 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2022-01-01 00:00:00 | 2022-01-14 00:00:00 | 250000 | 0.2 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2022-01-15 00:00:00 |  | 200000 | 0.15 |  |  | 0
2022-01-01 00:00:00 |  | 160000 | 0.08
Spreadsheet: 153ec7b8-f479-4a7a-b919-1c50cc87c117
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | WEST ROSEVILLE | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  | Property Crime Summary
 |  |  |  |  | January 2009
[NAME] |  |  | INCIDENT |  | TARGET |  |  | DATE/TIME
3000 Blk Jenna Ct. |  |  | 487 PC |  | Theft from unlocked vehicle |  |  | 2009-01-08 00:00:00 | 2009-01-09 00:00:00
 |  |  |  |  | parked in driveway |  |  | 18:00:00 | 08:45:00
9000 Blk Duckweed Ct. |  |  | 488 PC |  | Theft from unlocked vehicle |  |  | 2009-01-08 00:00:00 | 2009-01-09 00:00:00
 |  |  |  |  | parked in driveway |  |  | 17:00:00 | 07:15:00
8000 Blk Indianwood Ln. |  |  | 459 PC |  | Unk S manipulated lock |  |  | 2009-01-12 00:00:00 | 2009-01-12 00:00:00
 |  |  |  |  | mechanism on sliding glass door |  |  | 07:40:00 | 09:15:00
 |  |  |  |  | of res. Alarm activated - no
 |  |  |  |  | entry made.
4000 Blk Farrier Wy. |  |  | 459 PC |  | Unk S(s) entered res. via unsecured |  |  | 2009-01-14 00:00:00 | 2009-01-14 00:00:00
 |  |  |  |  | garage door. Theft occurred. |  |  | 07:30:00 | [NAME]
664/459 PC = Attempt Burglary
459 PC = Burglary
487 PC = Grand Theft
488 PC = Petty Theft
As a reminder, please remove any valuables from your vehicle(s) and secure them. If you have an alarm system for your car
or home, please utilize it.
Thank You
Spreadsheet: 119977d1314897511-is-there-a-way-to-merge-information-automatically-from-dissimilar-tabs-sample
Sheet: Master

Serial# | Item Name
159263 | Desk, Small
134570 | Desk, Small
321146 | Keyboard, Wireless
449321 | Keyboard
157943 | Monitor
321648 | Monitor, 15
166624 | Monitor, 17
13476 | Monitor, 19
445568 | Monitor, 20
156461 | Monitor, 22
321648 | [NAME]
Spreadsheet: chris_germany__2696__May00_FOM_Req2
Sheet: FOM May Storage

 |  | First-of-the Month Baseload Storage Injections/(Withdrawals)
 |  |  | Monthly | Daily
 |  |  | Inj/(WD) | Inj/(WD)
LDC |  | Pipe/Service | Dth# | Dth#
Atlanta Gas Light
 | IBSS
 |  | Transco / AGL City Gate## |  | 2286
 |  | Sonat / ANR Shadyside |  | 4006
 | DAS | [NAME] WSS | 65503
 |  | Transco ESS | 1209
 |  | Tennessee FS-MA | -17190
 |  | Tennessee FS-PA | -43230
 |  | CNG | 0
 |  | SONAT | 144491
Columbia Gas of Ohio
 |  | TCO FSS | 1089109
##IBSS injections on [NAME] at AGL citygate are not included in Transco citygate requirements in "Total Reqs" worksheet.
Spreadsheet: 273203d1382635210-formula-for-subtotaling-subtotal-items_alkey
Sheet: Sheet1

Id | Points | Status | Count |  |  | Id | Points | Status | Count
t1 | 1 |  |  |  |  | t1 | 1
t1 | 3 |  |  |  |  | t1 | 3
t1 | 2 |  |  |  |  | t1 | 2
t1 | 1 |  |  |  |  | t1 | 1
t1 Total |  |  |  |  |  | t1 Total |  |  | 4
[NAME] | 6 |  |  |  |  | [NAME] | 6
[NAME] | 7 |  |  |  |  | [NAME] | 7
[NAME] | 6 |  |  |  |  | [NAME] | 6
[NAME] | 7 |  |  |  |  | [NAME] | 7
[NAME] | 6 |  |  |  |  | [NAME] | 6
[NAME] | 7 |  |  |  |  | [NAME] | 7
t4 Total |  |  |  |  |  | t4 Total |  |  | 6
t5 | 25 |  |  |  |  | t5 | 25
t5 | 2 |  |  |  |  | t5 | 2
t5 | 40 |  |  |  |  | t5 | 40
t5 | 6 |  |  |  |  | t5 | 6
t5 | 4 |  |  |  |  | t5 | 4
t5 Total |  |  |  |  |  | t5 Total |  |  | 5
t24 | 1 |  |  |  |  | t24 | 1
t24 | 1 |  |  |  |  | t24 | 1
t24 | 1 |  |  |  |  | t24 | 1
t24 | 1 |  |  |  |  | t24 | 1
t24 | 1 |  |  |  |  | t24 | 1
t24 Total |  |  |  |  |  | t24 Total |  |  | 5
t54 | 2 |  |  |  |  | t54 | 2
t54 | 2 |  |  |  |  | t54 | 2
t54 | 2 |  |  |  |  | t54 | 2
t54 | 2 |  |  |  |  | t54 | 2
t54 | 2 |  |  |  |  | t54 | 2
t54 | 18 |  |  |  |  | t54 | 18
t54 Total |  |  |  |  |  | t54 Total |  |  | 6 |  | `
Grand Total |  |  |  |  |  | Grand Total
 |  |  |  |  |  | What column D should look like
Spreadsheet: darrell_schoolcraft__7303__imball0201
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 43413 | 45338
2 | 45284 | 45338
3 | 34397 | 34338
4 | 64090 | 66519 |  |  |  |  |  | Winkler/Eddy OBA |  |  |  |  |  |  | Gray  OBA
5 | 66505 | 66519 | -21381 | -20000
6 | 62713 | 66519 | -21442 | -20000 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount |  | Month | Measured | Scheduled | Imbalance | Index | Amount
7
8 |  |  |  |  |  |  |  | 2001-05-01 00:00:00 | 1103057 | 1120793 |  | 4.01 |  |  | 2001-05-01 00:00:00 | -202726 | -185000 |  | 4.01 |  |  | 2001-05-01 00:00:00 | 4.01
9 |  |  |  |  |  |  |  | 2001-06-01 00:00:00 |  | 1681871 |  | 3.51 |  |  | 2001-06-01 00:00:00 | -153623 | -88473 |  | 3.51 |  |  | 2001-06-01 00:00:00 | 3.51
10 |  |  |  |  |  |  |  | 2001-07-01 00:00:00 |  | 1270571 |  | 2.94 |  |  | 2001-08-01 00:00:00 | -34269 | -27046 |  | 2.85 |  |  | 2001-07-01 00:00:00 | 2.94
11 |  |  |  |  |  |  |  | 2001-08-01 00:00:00 |  | 1418897 |  | 2.85 |  |  | 2001-09-01 00:00:00 | -1191628 | -1210937 |  | 1.96 |  |  | 2001-08-01 00:00:00 | 2.85
12 |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 1109912 | 1111335 |  | 1.96 |  |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 1.96
13
14 |  |  |  |  |  |  |  | 5/01 - 9/01  balance |  |  |  |  |  |  | 5/01 - 9/01  balance
15
16 |  |  |  |  |  |  |  | Volume balance @ 4/30/01 |  |  | 19880 |  |  |  | Volume balance @ 4/30/01 |  |  | 37185
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  | 116110
2002-01-06 00:00:00
CBS Dollars
 |  |  | 296376
Spreadsheet: 540691d1506885507-having-trouble-with-if-statement-conditions-quartermaster_matrix-v2
Sheet: QuarterMaster_Matrix

[NAME] | 250
Food Input | 10
Tip Input | 10
Person | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8 | Day 9 | Day 10 | Lodging - Total | Food - Total | Incidentals | Total
[NAME] | 1 | 1 | 1 | 1 | 1
[NAME] | 1 | 1 | 1 | 1
Mark | 1 | 1 | 1 | 1 | 1
[NAME]
[NAME] |  |  | 1 | 1 | 1
[NAME] | 1 | 1 | 1 | 1
Buddy | 1 | 1 | 1 | 1 | 1
Lodging - Per Day
Food - Per Day
TOTAL
Spreadsheet: 720905d1614355499-conditional-formatting-a-row-or-rows-based-on-state-of-row-s-above-it-taskganttworking
Sheet: Sheet3

 | Named
 | 1 | AA
 | 2 | BB |  |  |  |  | #[NAME]!
 | C | CC |  |  |  | #REF! | #[NAME]!
 | D | DD |  |  |  | #[NAME]! | #[NAME]!
 | E | EE |  |  |  | #[NAME]! | #[NAME]!
 | F | FF |  |  |  | #[NAME]! | #[NAME]!
 | G | GG |  |  |  | #[NAME]! | #[NAME]!
 | H | HH |  |  |  | #[NAME]! | #[NAME]!
 | I | II |  |  |  | #[NAME]! | #[NAME]!
 | J | JJ |  |  |  | #[NAME]! | #[NAME]!
 |  |  |  |  |  | #[NAME]! | #[NAME]!
Spreadsheet: 025acb2f-e83c-4c56-a5d2-11a5048d1ef7
Sheet: TermTypes

Term Types Codes for All MCCC Data Collections K-12
Term Type Code | Term Type Description | [NAME] allowed/year/term type
Q | Quarter | 4
S | Semester | 2
T | Trimester | 3
Y | Full Year | 1
QM | Quinmester | 5
OT | Other Term | 48
H | [NAME] | 6
SU | Summer | 10
Spreadsheet: 834822d1688111937-textsplit-on-multiple-columns-to-array-s666-pq-textsplit-multiple-colums
Sheet: Feuil1

ignore |  |  |  |  |  |  |  | EXPECTED RESULT, SPILLING ARRAY
list1 | list2 | list3 |  |  | list2 | list3 |  | list1 | list2 | list3 |  | list1 | list2 | list3 |  | list1 | list2 | list3
a,b,c | j,z | w,x,c,v |  | a,b,c | j,z | w,x,c,v |  | a | j | w |  | a,b,c | j,z | w,x,c,v |  | a | j | w
 |  |  |  |  |  |  |  | b | z | x |  |  |  |  |  | b | z | x
 |  |  |  |  |  |  |  | c |  | c |  |  |  |  |  | c |  | c
 |  |  |  |  |  |  |  |  |  | v |  |  |  |  |  |  |  | v
Spreadsheet: 9b6cfa4c-e357-469f-a6ee-1cebe4ae69bd
Sheet: Table 6.4

Monthly Statistical Bulletin
6.4 Exchange rates
Month | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
United States dollar (a) – cents
July | 82.80999999999999 | 89.86 | 109.54 | 105.26 | 90.36999999999999
August | 83.93 | 89.18 | 106.91 | 103.1 | 89.47
September | 88.01 | 96.67 | 97.81 | 104.64 | 93.08999999999999
October | 91.61 | 97.61 | 105.09 | 103.78 | 94.89999999999999
November | 91.78 | 96.17999999999999 | 100.21 | 104.31 | 90.86999999999999
December | 89.69 | 101.63 | 101.56 | 103.84
January | 89.09 | 99.24 | 106.37 | 103.94
February | 88.99000000000001 | 101.63 | 108.16 | 102.75
March | 91.59 | 103.34 | 104.02 | 104.26
April | 93 | 109 | 104.53 | 103.68
May | 84.89999999999999 | 107.09 | 97.27 | 96.49
June | 85.22999999999999 | 107.39 | 101.91 | 92.75
Trade weighted index (b) – index
July | 65.7 | 69.4 | 78.4 | 78.9 | 69.4
August | 66.3 | 69 | 76.5 | 77 | 69.2
September | 68.2 | 72.9 | 72.4 | 76.9 | 71.2
October | 70.7 | 72.7 | 76.9 | 76.5 | 72.1
November | 69.9 | 73 | 74.6 | 77.2 | 69.8
December | 69.7 | 75.8 | 75.8 | 77.1
January | 69.2 | 74 | 77.9 | 77.7
February | 69.5 | 75.5 | 79.2 | 77.4
March | 71.7 | 76.3 | 76.9 | 79.1
April | 72.5 | 78.9 | 77 | 78.4
May | 67.5 | 77.8 | 73.6 | 74
June | 67.3 | 77.8 | 76.5 | 71.4
(a) US cents per A$. Rate at end of month.
(b) At end of month. Base: May 1970 = 100.0.
Source: RBA, Daily statistical release
http://www.rba.gov.au/Statistics/statistics_by_frequency.html | http://www.rba.gov.au/Statistics/statistics_by_frequency.html | http://www.rba.gov.au/Statistics/statistics_by_frequency.html
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2014-01-02 00:00:00
Spreadsheet: 766912d1644164527-problem-regarding-building-a-portfolio-sheet-1portfolio-tracker
Sheet: Crypto transactions

 | Transactions
 | Date | Action | If Deposit | Fee $ | Type of Fee | From | To | Coin | Coin | Sell amount | Sell Category | Price | Buy amount | Buy Category | Price | Realized win | Realized win | Comment |  |  | Place | Action | If Deposit | Type of fee
 | 2022-01-28 00:00:00 | Buy |  |  |  | Bitfinex | Binance | BTC | ETH | 0.2 | Bitcoin | 50000 | 4.5 | Ethereum |  |  |  |  |  |  | Argent | Buy | Airdrop | Bridge
 | 2022-01-29 00:00:00 | Transfer |  | 50 |  | Metamask 1 | Metamask 2 | ETH | ETH |  | Ethereum |  |  | Ethereum |  |  |  |  |  |  | Bitmex | Sell | Defi | Withdrawl
 | 2022-01-29 00:00:00 | Deposit | Fiat deposit |  |  |  |  |  | DAI |  |  |  | 1000 | Stablecoin | 1000 |  |  |  |  |  | Bitfinex | Deposit | Fiat deposit | Trade
 | 2022-01-29 00:00:00 | Trade |  |  |  |  |  | DAI | USDC | 2000 | Stablecoin | 2000 | 2000 | Stablecoin | 2000 |  |  |  |  |  | Bittrex | Withdrawl | Mining | Transfer
 | 2022-01-30 00:00:00 | Withdrawl |  |  |  |  |  | DAI |  | 1000 |  | 1000 |  | Stablecoin |  |  |  |  |  |  | Binance | Transfer | Minting
 | 2022-01-31 00:00:00 | Trade |  |  |  |  |  | ETH | DAI | 2 | Ethereum | 3000 | 6000 | Stablecoin | 6000 |  |  |  |  |  | Crypto.com | Trade | Staking Reward
 | 2022-01-31 00:00:00 | Deposit | Airdrop |  |  |  |  |  | YFI |  |  | 100 | 3 | DeFi |  |  |  |  |  |  | FTX | Initial | Other
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kucoin
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lykke
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Trezor 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ledger 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Metamask 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Metamask 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Metamask 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Trustwallet 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
Spreadsheet: 144014d1330679308-index-match-index-formula-work-slow-index_match_index
Sheet: Sheet1

CODE | [NAME] | DIST | ESN | COUNT | OIL | OIL FILTER | FUEL FILTER | OIL+FUELFILTER | AIR FILTER | LAST OIL CHANGED DATE | LAST OIL FILTER CHANGED DATE | LAST FUEL FILTER CHANGED DATE | [NAME] | LAST AIR FILTER CHANGED DATE | NOS. OF DAY FROM LAST CAHNGED K-OIL | NOS. OF DAY FROM LAST CAHNGED AIR FILTER
 |  |  |  |  | OI | OF | FF | OFF | AF | OI | OF | FF | OFF | AF
Z005 | ZILA SATRA NYALAYA |  | D3.1605/0800659
A002 | A AND E REGIMENT |  | 04.1153/0100005
L047 | A C LONDHE |  | 4H.2295/1033966
A002 | A.A. ENGINEERS |  | 48.1502/9800607
A022 | A.E.C. ENNG. VAHIRA |  | 4H.2190/0800108
C030 | [NAME] MARATHA VIDYA PRASARAK SAMAJ(CHATRAPATI ENGG COLLAGE) |  | 03.2121/0920320
A011 | ABASAHEB KAKDE MAHAVIDYALAYA |  | [NAME]
A017 | ABHAYKUMAR MACHINERY CO. |  | D8.4711/0500006
A018 | ABHIKALP INFRASTRATURE |  | 03.1166/0900006
A023 | ADARSH DAIRY PRODUCTS PVT LTD. |  | D4.5801/0700072
Spreadsheet: 39251d1237426207-how-to-count-unique-non-0-values-in-one-range-based-on-categories-of-another-range-counting-awards
Sheet: Sheet2

 | Recipient | Department | Amount | Award Date
 | Name01 | Dept.A | 25 | 2009-01-01 00:00:00 |  | Dept.A
 | Name02 | Dept.A | 25 | 2009-01-01 00:00:00
 | Name03 | Dept.A | 50 | 2009-01-01 00:00:00 |  | Total number of employees
 | Name04 | Dept.A | 50 | 2009-01-01 00:00:00 |  | Number of employees who received awards
 | [NAME] | Dept.A | 50 | 2009-01-01 00:00:00 |  | Total Award Amount
 | Name06 | Dept.B | 35 | 2009-01-15 00:00:00
 | Name07 | Dept.B | 35 | 2009-01-15 00:00:00
 | Name08 | Dept.B | 35 | 2009-01-15 00:00:00 |  | Dept.B
 | Name09 | Dept.B | 50 | 2009-01-15 00:00:00
 | Name10 | Dept.B | 75 | 2009-01-15 00:00:00 |  | Total number of employees
 | Name11 | Dept.C | 75 | 2009-01-30 00:00:00 |  | Number of employees who received awards
 | Name12 | Dept.C | 75 | 2009-01-30 00:00:00 |  | Total Award Amount
 | Name13 | Dept.C | 50 | 2009-01-30 00:00:00
 | Name14 | Dept.D | 50 | 2009-02-05 00:00:00
 | Name15 | Dept.D | 50 | 2009-02-05 00:00:00 |  | Dept.C
 | [NAME] | Dept.D | 50 | 2009-02-05 00:00:00
 | Name17 | Dept.D | 50 | 2009-02-05 00:00:00 |  | Total number of employees
 | Name18 | Dept.D | 20 | 2009-02-05 00:00:00 |  | Number of employees who received awards
 | Name19 | Dept.D | 20 | 2009-02-05 00:00:00 |  | Total Award Amount
 | [NAME] | Dept.D | 20 | 2009-02-05 00:00:00
 | Name02 | Dept.A | 10 | 2009-02-10 00:00:00
 | Name06 | Dept.B | 10 | 2009-02-10 00:00:00 |  | Dept.D
 | Name13 | Dept.C | 10 | 2009-02-10 00:00:00
 | Name10 | Dept.B | 10 | 2009-02-15 00:00:00 |  | Total number of employees
 | Name14 | Dept.D | 10 | 2009-02-15 00:00:00 |  | Number of employees who received awards
 | Name06 | Dept.B | 10 | 2009-02-25 00:00:00 |  | Total Award Amount
 | Name13 | Dept.C | 10 | 2009-02-25 00:00:00
 | Name17 | Dept.D | 10 | 2009-02-25 00:00:00
 | Name18 | Dept.D | 50 | 2009-02-25 00:00:00
 | Name19 | Dept.D | 50 | 2009-02-25 00:00:00
Spreadsheet: 35545d1233151123-getting-value-from-next-highest-header-row-worksheetsample
Sheet: Sheet1

Key | Flag | Other Info 1 | Other Info 2 | Other Info 3
ITEM_KEY_1 | HEADER | 143 | 3823 | 92834
 |  | 234 | 824 | 234
 |  | 483 | 3 | 593
 |  | 34 | 283 | 498
 |  | 439 | 8766 | 234
ITEM_KEY_2 | HEADER
 |  | 8438 | 872 | 677
 |  | 123 | 322 | 876
 |  | 76431 | 24 | 987
 |  | 34 | 876 | 434
ITEM_KEY_3 | HEADER
 |  | 987 | 887 | 999
 |  | 243 | 123 | 123
 |  | 76 | 834 | 8743
I would like a formula for the yellow cells to populate them with the column A value from the next highest HEADER row
Note: Some rows will be blank
Spreadsheet: 777076d1650123502-pull-data-from-multiple-sheets-floor-stock-sheets-template
Sheet: JT Outpatient 1153405

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Service Units
Item | Price | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu
Lemon Lime- Soda | 0.25
Diet Lemon Lime- Soda | 0.25
Cola- Soda | 0.25
Diet Cola- Soda | 0.25
Hydrolyte Honey Water | 0.32
Hydrolyte Honey tea | 0.37
Hydrolyte Nectar Water | 0.32
Hydrolyte Nectar Tea | 0.35
Crackers, [NAME] | 0.08
[NAME] ea | 0.05
SF Crackers | 0.05
[NAME] | 0.28
[NAME] | 1.13
Pudding-Vanilla | 0.27
Diet Vanilla Pudding | 0.28
Applesauce Ind. | 0.32
Juice Orange | 0.23
Juice Cranberry | 0.23
Juice Apple | 0.23
Honey | 0.07
Jam/Jelly ea | 0.06
[NAME] | 0.02
Mayo | 0.06
Mustard | 0.02
[NAME] | 0.16
Salt/Pepper | 0.02
[NAME] | 0.11
[NAME] | 0.11
Milk- Skim | 0.25
2% Milk | 0.25
Coffee Decaf instant- Prepack cs. | 37.84
Coffee, [NAME]. cs. | 95.11
Tea Bags | 0.03
[NAME] | 1.47
Creamer, non dairy box | 0.03
Sugar | 0.02
Sweetner-Equal | 26.73
Sweetner-Sweet N Low | 17.58
Sweetner-Splenda | 30.44
Plastic Ware (fork,spoon knife) | 0.03
Glucerna | 0.4
Jevity | 0.35
Nepro | 1.03
[NAME] | 15.6
Osmolite | 0.25
Perative | 1.39
Promote | 0.23
Pulmocare | 0.44
Refrigerator Thermometer (reg.)
Broth, [NAME] pkt. | 0.1
[NAME]-pkts. | 2.4
[NAME] | 1.75
Cereal-Cheerios | 0.39
Ice Cream-Vanilla | 0.41
Ice Cream- Diet-Vanilla | 0.43
Diet Popsicles | 0.25
Popcicles | 0.2
Monthly Total
Spreadsheet: 5ed85825-0d3d-4628-aa45-720aff6a4533
Sheet: Travel Expense Report Form

AULTMAN HOSPITAL
TRAVEL, EDUCATION & OTHER EVENT EXPENSE REPORT
Name: |  |  |  |  |  |  | Unit:
Dates | [NAME] | Registration | Lodging | Meal | Other | Define Other | TOTAL | Detailed description
Totals: | X |  |  |  |  |  |  | (A) = Total Down and Across
Total Miles: |  | Milage Rate= |  | 0.555 | (B)= Total Rate Miles |  | Payment for Milage:
ALL RECEIPTS MUST BE ATTACHED
I certify that these were necessary business expenses incured by me.
 |  |  |  | Account: |  |  | Cost Center:
Employee Signature |  |  |  | Date |  | Approved By, VP (AVP if less than $500)
 | Expense Reconcilliation
 | TOTAL EXPENSES |  |  | Sum of Sections A + B
 | Less: Expenses Paid Direct |  |  | Registration, Air, Other
 | Less: Cash Advance |  |  | Amounts Paid to You
 | Total Expense less Payments: Balance Due to Employee(+)/Aultman(-)
Form 239  R: 01/11
Spreadsheet: 806212d1669163942-if-formula-for-two-different-values-based-on-criteria-book2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | WEEK 8 | WEEK 9 | WEEK 10 | WEEK 11 | WEEK 12 | WEEK 13 | WEEK 14 | WEEK 15 | WEEK 16 | WEEK 17
 |  | 6 |  | WEEK 10
Spreadsheet: 103537d1301315361-if-function-if-calc
Sheet: Sheet1

Total | Jan | Status | Feb | Status | Mar | Status | Apr | Status | May | Status | Jun | Status | Jul | Status | Aug | Status | Sep | Status | Oct | Status | Nov | Status | Dec | Status | Balance
10000 | 1000 | C | 1000 | C | 1000 | C | 1000 | C | 1000 | C | 1000 | C | 1000 | C | 1000 | C | 1000 | C | 1000 | C | 1000 | P | 800 | P | What formula can be used here ?
Status | C = | Collected
 | P = | Pending