tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 38334d1236456543-search-faciltity-and-h-vlookup-sampleworkbook
Sheet: Admin

Part Code | Description | Allergens | Supplier | Contact | Phone/Email
50000 | Apple |  | Smiths | [NAME] | [EMAIL]
50001 |  |  |  |  |  |  | Enter part code below:
50003
50004 |  |  |  |  |  |  | 50000
50006
50015 | [NAME] |  |  |  |  |  | Description | Allergens | Supplier | Contact | Phone/Email
50016 |  |  |  |  |  |  | Apple | 0 | Smiths | [NAME] | [EMAIL]
50016
50019 | Onion |  | Jones | [NAME] | 8765432100
50021 | Carrot
50023
50204 | Peas
50302 |  | [NAME]
50303 | Celery | [NAME]
50304
50307 | Fish | [NAME] | [NAME] | [NAME] | 7759676767
51001
51002
51003
51003
51017
51021
51021
51100
51105
51105
51113
51134
51129
51139
51140
51152
51512
51513
51514
51641
51643
51653
51658
51659
51661
51662
51662
51663
51673
51811
52000
52001
52002
52005
52006
52007
52009
52012
52012
52013
52013
52014
52015
52017
52026
52027
52031
52039
52040
52042
52044
52045
52046
52049
52054
52056
52057
52062
52063
52067
52068
52071
52073
52077
52089
52108
52112
52115
52116
52117
52123
52128
52138
52166
52167
52168
52196
53000
53004
53005
53007
53017
53018
53023
53024
53028
53029
53030
53040
54000
54001
54002
54006
54007
54009
54011
54016
54017
54023
54024
54025
54026
54030
54036
54039
54051
54053
54055
54056
54064
54070
54073
54083
55001
55002
55004
55005
55009
55012
55013
55016
55023
55024
55026
55029
55031
55036
55043
55048
55050
55051
55053
55063
55069
56004
56011
56022
56028
56030
56031
56032
56033
56034
56040
56042
56055
56056
56059
56065
56067
56069
56070
56071
56074
56075
56080
56086
56088
56090
56098
56114
56121
56129
56131
56135
56138
56144
56147
56148
56149
56151
56152
56153
56154
56155
56156
56159
56164
56165
56170
56176
56188
56191
56196
57000
57002
57006
57008
57009
57014
57017
57020
57021
57024
57025
57026
57029
57034
57035
57036
57037
57038
57039
57041
57042
57043
57044
57049
57050
57051
57052
57054
57055
57056
57058
57072
57073
57077
57083
57093
57100
57101
58005
58006
58012
58019
58020
58021
58022
58028
58029
58034
58035
59000
59001
59004
59013
Spreadsheet: 32508d1228732504-protect-call-example
Sheet: Sheet1

DOC | GP # | Serial # | Serial # | [NAME] | Model | Status | DATE | USER ID
1 | L380552 |  | 456998 | METER FLOW METER |  | RETURNED TO SITES | 2008-08-26 00:00:00
1 | L380557 |  | 456929 | METER FLOW METER |  | RETURNED TO SITES | 2008-04-01 00:00:00
1 | L380559 |  | 457004 | METER FLOW METER |  | RETURNED TO SITES | 2008-04-01 00:00:00
1 | [NAME] |  | 457625 | METER FLOW METER |  | RETURNED TO SITES | 2008-10-14 18:07:53
1 | [NAME] |  | 456835 | METER FLOW METER |  | RETURNED TO SITES | 2008-04-01 00:00:00
1 | L380643 |  | 456944 | METER FLOW METER |  | RETURNED TO SITES | 2008-08-26 00:00:00
1 | [NAME] |  | 457485 | METER FLOW METER |  | RETURNED TO SITES | 2008-12-03 15:26:24
1 | L474519 |  |  | METER FLOW METER |  | RETURNED TO SITES | 2008-10-14 18:12:06
1 | L620916 |  | 479446 | METER FLOW METER |  | RETURNED TO SITES | 2008-06-17 00:00:00
11 | L381239 |  | 457155 | METER FLOW METER |  | RETURNED TO SITES | 2008-08-17 00:00:00
1 | L397681 |  | 457627 | METER FLOW METER |  | RETURNED TO SITES | 2008-04-01 00:00:00
1 | L397680 |  | 457661 | METER FLOW METER |  | RETURNED TO SITES | 2008-08-26 00:00:00
1 | L397675 |  | 457628 | METER FLOW METER |  | RETURNED TO SITES | 2008-08-26 00:00:00
1 | L397673 |  | 457624 | METER FLOW METER |  | RETURNED TO SITES | 2008-12-08 00:00:00
Spreadsheet: 108884d1305825874-call-top3-based-on-duplicate-data-and-ranking-info-sophyex-v4
Sheet: Men

Value | Sex | Name | Country
8 | M | [NAME] | USA
6 | M | [NAME] | USA
1 | M | [NAME] | USA
3 | M | [NAME] | USA
9 | M | [NAME] | USA
17 | M | [NAME] | CAN
7 | M | [NAME] | CAN
5 | M | [NAME] | CAN
4 | M | [NAME] | CAN
10 | M | [NAME] | ITA
11 | M | [NAME] | FRA
12 | M | [NAME] | FRA
13 | M | [NAME] | FRA
14 | M | [NAME] | FRA
15 | M | [NAME] | FRA
16 | M | [NAME] | FRA
2 | M | [NAME] | JAP
18 | M | [NAME] | MEX
19 | M | [NAME] | MEX
20 | M | [NAME] | MEX
21 | M | [NAME] | MEX
22 | M | [NAME] | MEX
23 | M | [NAME] | SPA
24 | M | [NAME] | SPA
Spreadsheet: 741458d1627046954-return-the-value-of-date1-for-the-first-instance-of-date-difference-flag-return_specified_date1_value
Sheet: Sheet1

 | DATASET
 | ID | Date1 | Date2 | Flag
 | 111 | 2021-07-15 07:18:00 | 2021-07-08 00:00:00 | 0
 | 111 | 2021-07-14 15:53:00 | 2021-07-08 00:00:00 | 0
 | 111 | 2021-07-13 07:33:00 | 2021-07-08 00:00:00 | 0
 | 111 | 2021-07-01 07:51:00 | 2021-07-08 00:00:00 | 1
 | 111 | 2021-06-30 14:55:00 | 2021-07-08 00:00:00 | 1
 | 111 | 2021-06-30 07:23:00 | 2021-07-08 00:00:00 | 1
 | 222 | 2021-07-17 07:18:00 | 2021-07-10 00:00:00 | 0
 | 222 | 2021-07-14 15:53:00 | 2021-07-10 00:00:00 | 0
 | 222 | 2021-07-12 07:33:00 | 2021-07-10 00:00:00 | 0
 | 222 | 2021-07-07 07:51:00 | 2021-07-10 00:00:00 | 1
 | 222 | 2021-06-27 14:55:00 | 2021-07-10 00:00:00 | 1
 | 222 | 2021-06-22 07:23:00 | 2021-07-10 00:00:00 | 1
 | DESIRED OUTPUT: Would like to be able to join to the above data by ID to return the Date1 field for the first instance where Flag=1.
 | ID | [NAME]
 | 111 | 2021-07-01 07:51:00
 | 222 | 2021-07-07 07:51:00
Spreadsheet: 727925d1618218460-how-to-sum-data-using-2-criteria-working-sum
Sheet: Entities

 |  | Vessel | S/O Company | Bank balances as of 31.03.2021
98 | 1 | Tasman | Tasman Marine LLC
A6 | 2 | Dimitris Y | Hudson Marine LLC
A7 | 3 | [NAME] | Drake Marine LLC
T148 | 4 | MSC Qingdao | Global Ship Lease 52 LLC
T149 | 5 | GSL Matisse (Sold Vessel) | Global Ship Lease 37 LLC
T150 | 6 | GSL Ningbo | Global Ship Lease 43 LLC
T151 | 7 | CMA CGM Utrillo (Sold Vessel) | Global Ship Lease 39 LLC
T152 | 8 | CMA CGM Jamaica | Global Ship Lease 50 LLC
T153 | 9 | CMA CGM America | Global Ship Lease 51 LLC
T154 | 10 | CMA CGM Berlioz | Global Ship Lease 48 LLC
T155 | 11 | CMA CGM Alcazar | GSL Alcazar Inc.
T156 | 12 | CMA CGM Thalassa | Global Ship Lease 54 LLC
T157 | 13 | [NAME] | Global Ship Lease 44 LLC
T158 | 14 | CMA CGM Chateau d' If | Global Ship Lease 47 LLC
T159 | 15 | CMA CGM Sambhar | Global Ship Lease 49 LLC
T160 | 16 | [NAME] | Global Ship Lease 40 LLC
T161 | 17 | Kumasi | Global Ship Lease 45 LLC
T162 | 18 | [NAME] | Global Ship Lease 41 LLC
T163 | 19 | [NAME] | Global Ship Lease 38 LLC
T165 | 20 | MSC Tianjin | Global Ship Lease 53 LLC
T166 | 21 | GSL La Tour | Global Ship Lease 46 LLC
T184 | 22 | GSL Christen (ex NYK Lynx) | Global Ship Lease 36 LLC
T185 | 23 | GSL Nicoletta (ex NYK Libra) | Global Ship Lease 35 LLC
Spreadsheet: darrell_schoolcraft__7827__imbalsumm0110
Sheet: Mojave

56696
Day | Measured | Scheduled
1 | -19996 | -20000
2 | -20687 | -18459
3 | -20002 | -20000
4 | -20012 | -20000
5 | -11402 | -10084
6 | -14142 | -14130
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
2001-09-30 00:00:00 |  |  | 156452
2001-10-06 00:00:00
CBS Dollars
 |  |  | 134898
Spreadsheet: 251c0426-e4d4-4091-ae7b-385a4fddadc1
Sheet: Sheet1

[NAME] | 36
Alpha Gamma Rho | 66
[NAME] | 73
Beta [NAME] | 62
Delta Chi | 44
Delta [NAME] | 65
Delta Tau Delta | 74
Delta Upsilon | 73
FarmHouse | 41
Kappa Sigma | 53
[NAME] | 82
Phi Delta Theta | 72
Phi Gamma Delta | 63
Phi [NAME] | 67
Phi [NAME] | 63
[NAME] | 110
Pi Kappa Phi | 81
[NAME] Epsilon | 104
[NAME] | 29
[NAME] | 67
Sigma Phi Epsilon | 111
[NAME] | 60
[NAME] | 92
[NAME] | 104
[NAME] | 73
Average
Spreadsheet: 886022d1735970547-pull-number-from-column-with-other-text-wildecoyote1966-sats-1-tms
Sheet: Sheet1

1d ago
+ 2 sats |  |  |  |  | 2 |  |  |  | Sats
1d ago
+ 4 sats |  |  |  |  | 4
1d ago
+ 4 sats |  |  |  |  | 4
2d ago
- 385 sats' |  |  |  |  | -385
2d ago
+ 4 sats |  |  |  |  | 4
2d ago
+ 4 sats |  |  |  |  | 4
2d ago
+ 15 sats |  |  |  |  | 15
 |  |  | =IFERROR(--TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))),LEN(A1),LEN(A1))),"")
 |  |  |  | =IFERROR(SUBSTITUTE(SUBSTITUTE(A1," sats",""),"'","")+0,"")
 |  |  |  |  | =IFERROR(0+LEFT(A1:[NAME]:A14)-1),"")
Spreadsheet: darrell_schoolcraft__7807__imbalsumm0108
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 | -42230 | -24184
9238 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 | -2225733 | -2341738
58710 | -21848 | -880
60921 | 1940904 | 1927353
78026 |  | 48100
500084 | -16165 | -20000
500085
500097 | -11
INDEX
2001-07-31 00:00:00 |  |  | 296780.47
2001-08-20 00:00:00
CBS Volume
 |  |  | 67620
2001-08-11 00:00:00
Spreadsheet: 35448d1233055142-copying-hyperlinks-december-2008-excel-forum-daily-accts
Sheet: 4

 |  |  |  |  |  | 4 | 3
Фактические остактки [NAME] группы компаний "Вагриус"
на начало дня | 4 | декабря 2008 года
[NAME] компании | Без Нал. | Нал. | Сумма
[NAME] | 985.4199999999983 | 0 | 985.4199999999983 |  |  | B17 | B134 | B16 |  | C17 | C134 | C16
Вагриус книги | 61238.7 | 0 | 61238.7 |  |  | B18 | B150 | B32 |  | C18 | C150 | C32
Вагриус правда | 6124.930000000008 | 0 | 6124.930000000008 |  |  | B19 | B166 | B48 |  | C19 | C166 | C48
Вагриус минус | 628.08 | 0 | 628.08 |  |  | [NAME] | B182 | B64 |  | C20 | C182 | C64
Плюс-минус | 2982.36 | 0 | 2982.36 |  |  | B21 | B198 | B80 |  | C21 | C198 | C80
Издательство Вагриус | 444.69 | 0 | 444.69 |  |  | B22 | B114 | [NAME] |  | C22 | C114 | C96
Вагриус плюс-минус | 0 | 0 | 0 |  |  | B23 | B230 | B112 |  | C23 | C230 | C112
Общий итог: | 72404.18000000001 | 0 | 72404.18000000001
Spreadsheet: hunter_shively__12742__EnovateDPR0122
Sheet: 5 Day Roll

ENRON CAPITAL AND TRADE RESOURCES
 |  | DO NOT TOUCH!! | ONLY RUN BEFORE YOU LINK ANY NEW ROLLS!!
Commodity | 5 Day Rolling Total | Current Day | Current Day-1 | Current Day-2 | Current Day-3 | Current Day-4
ENA Gas Trading
Short Term Gas |  |  | -68.1974740399979 | 192.3244215099998 | -183.3784664399997 | 10.61723725999802
 |  | 13 | 12 | 11 | 10 | 7 | 6
 |  | 17 | 84 | 12 | -54 | 19 | -53
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: Replace Costs-Results 11-15

Table 5.2.5.  Replacement Costs (Years 11 to 15)
 |  |  |  | EPA Discount Rate:
 |  |  |  | Present Value of Replacement Costs in Year:
Component | Unit Cost | Unit | Quantity | 11 | 12 | 13 | 14 | 15
 |  |  | Total Present Value of Replacement Costs (Years 11 to 15):
Spreadsheet: 763292d1642095157-formula-not-returning-value-due-to-formatting-formula-formating-help
Sheet: Formula

 |  |  |  |  |  | formula in cell D6 only works if I manually write year and month in volume tab (F6:G29)
 |  | Year
 |  | Month |  |  |  | Do I have the best formula in row 5?
 |  | Volume |  |  |  | formula looks correct but because of formatting issue (Year & Month) it's not pulling correct number. Need HELP WITH FORMULA IN ROW 6 (need to pull volume ume tab matching Year, Month & type in column B
 | PAINT D | Dollar |  |  |  | Do I have the best formula in row 5? Or is there a better formula I can use like sumifs or index match (Note: I will be pulling this from a pivot table)
 |  | Volume
 |  | Dollar
Spreadsheet: 216596d1361819033-copying-data-between-columns-if-condition-met-upload-solved
Sheet: Sheet1

helper column |  |  |  |  |  | helper column
1A0B55-3 | 1A0B55 | 3 |  |  |  | 1A0B30-2 | 1A0B30 | 2 | 1488.145
1A0B50-2 | 1A0B50 | 2 |  |  |  | A0B58-1 | A0B58 | 1 | 1449.26
A0B64-1 | A0B64 | 1 |  |  |  | 1A0B55-3 | 1A0B55 | 3 | 1316.853333333333
1A0B48-1 | 1A0B48 | 1 |  |  |  | 1A0B50-2 | 1A0B50 | 2 | 1070.93
1A0TN1216-1 | 1A0TN1216 | 1 |  |  |  | A0B64-1 | A0B64 | 1 | 1088.52
1A1AM4-1 | 1A1AM4 | 1 |  |  |  | 1A0B48-1 | 1A0B48 | 1 | 1894.61
1A1AM220-1 | 1A1AM220 | 1 |  |  |  | 1A0TN1216-1 | 1A0TN1216 | 1 | 852.4
A1B8-1 | A1B8 | 1 |  |  |  | A1A48-1 | A1A48 | 1 | 6803.16
14A1B370-2 | 14A1B370 | 2 |  |  |  | 1A1AM4-1 | 1A1AM4 | 1 | 423.9
14A1B362-1 | 14A1B362 | 1 |  |  |  | 1A1AM220-1 | 1A1AM220 | 1 | 280.86
1A1B543-2 | 1A1B543 | 2 |  |  |  | A1B8-1 | A1B8 | 1 | 1461.88
1A1B693-1 | 1A1B693 | 1 |  |  |  | 14A1B370-1 | 14A1B370 | 1 | 497.78
1A1B390-1 | 1A1B390 | 1 |  |  |  | 14A1B362-2 | 14A1B362 | 2 | 679.53
1A1B384-2 | 1A1B384 | 2 |  |  |  | 1A1B543-1 | 1A1B543 | 1 | 1704.22
14A1B427-1 | 14A1B427 | 1 |  |  |  | 26A1B874-1 | 26A1B874 | 1 | 1605.23
26A1B638-1 | 26A1B638 | 1 |  |  |  | 1A1B1623-1 | 1A1B1623 | 1 | 1035
Spreadsheet: 1b0c4e3f-ae9c-4349-a87e-f9e06a8ff206
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 | 89.48
January | 89.09 | 99.24 | 106.37 | 103.94 | 87.63
February | 88.99000000000001 | 101.63 | 108.16 | 102.75 | 89.47
March | 91.59 | 103.34 | 104.02 | 104.26 | 92.21000000000001
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 | 68.9
January | 69.2 | 74 | 77.9 | 77.7 | 67.7
February | 69.5 | 75.5 | 79.2 | 77.4 | 68.9
March | 71.7 | 76.3 | 76.9 | 79.1 | 71
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
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2014-05-01 00:00:00
Spreadsheet: 195970d1353767386-how-to-align-the-text-and-number-in-the-same-row-attempt2
Sheet: Sheet1

name of the comp. | type of transaction | quantity |  |  | name of the comp. | type of transaction | quantity
barista | purchase |  |  |  | barista limited | purchase | 200
limited |  | 200 |  |  | barista limited | sale | 300
barista | sale |  |  |  | barista limited | purchase | 400
limited |  | 300 |  |  | freds shoes | purchase | 500
barista | purchase |  |  |  | barista limited | sale | 1000
limited |  | 400 |  |  | barista limited | purchase | 23
freds | purchase |  |  |  | barista limited | purchase | 50
shoes |  | 500 |  |  | [NAME] | sale | 6
barista | sale
limited |  | 1000
barista | purchase
limited |  | 23
barista | purchase
limited |  | 50
[NAME] | sale
[NAME] |  | 6
but I want the above the data as follows..
barista limited | purchase | 200
barista limited | sale | 200
barista limited | purchase | 200
barista limited | purchase | 200
barista limited | sale | 200
barista limited | purchase | 200 |  | etc…
Spreadsheet: 229515d1366414417-copying-values-in-filtered-cells-sample
Sheet: Sheet1

Student Data
Sr No. | Roll No. | Name | Maths | Science
1 | 1 | [NAME]
2 | 2 | [NAME]
3 | 3 | [NAME]
4 | 4 | Manjaly
5 | 5 | Sameer
6 | 6 | [NAME]
7 | 7 | Arup
8 | 8 | Naran
 |  |  |  |  |  | Grades
 |  |  |  |  |  | Name of the student | Maths Grade | Science Grade
 |  |  |  |  |  | [NAME] | AA
 |  |  |  |  |  | [NAME] | AB
 |  |  |  |  |  | [NAME] | BC | Register
 |  |  |  |  |  | Naran | DD
 |  |  |  |  |  | Manjaly
 |  |  |  |  |  | Sameer
 |  |  |  |  |  | Arup
Spreadsheet: 889675d1740579174-highlight-the-cells-where-text-isnt-found-in-a-list-planning-tool-master-12-monthly-recall-dates-option-
Sheet: Assessment Times

INDIVIDUAL ASSESSMENTS | Assessment | Timing | Justification | Notes |  |  | Previous Timings
 | Audio | 30 | Add 10mins (was 20) because auto audiometry often takes 15+ mins |  |  |  | Assessment Code | Time
 | Resp | 20 | Stay the same |  |  |  | AU- | 30
 | Skin | 15 | Stay the same |  |  |  | AU-BM-HV-RS-SK- | 60
 | [NAME] | 15 | Stay the same, with exceptions (see notes) | Perhaps 20 for FC/FLS/EA because they often have HAVS only appointments. |  |  | AU-DR2- | 45
 | HAVS T3 | 45 | Add 15mins due to 30 being tight and new HSE guidance merans T3's will be on more 'high risk' cases with significant history |  |  |  | AU-DR2-HV-RS-SK- | 60
 | Safety Critical/Driver/WAH | 30 | Stay the same |  |  |  | AU-FLT- | 45
 | [NAME] | 45 | Stay the same |  |  |  | AU-FLT-DR2-HV-RS-SK- | 60
 | Night worker | 15 | Stay the same |  |  |  | AU-FLT-HV-RS-SK- | 60
 | Rigger (CST) | 60 | Stay the same |  |  |  | AU-FLT-HV-RS-SK-WAH- | 60
 | Isocycanate | 15 | Stay the same |  |  |  | AU-FLT-RS- | 60
 | Wellbeing | 20 | Stay the same |  |  |  | AU-HV-RS- | 45
COMBINED ASSESSMENTS | Combinations | Timing | Justification | Notes |  |  | AU-HV-RS-SK- | 60
 | AU-RS-SK-HV2 | 60 | Stay the same |  |  |  | AU-HV-RS-SK-BM- | 60
 | AU-RS-SK-HV2-FFW (any) | 60 | Stay the same |  |  |  | AU-HV-RS-SK-FLT- | 45
 | AU-RS-SK-HV3-FFW (any) | 90 | Rare occurance in light of new HSE guidance |  |  |  | AU-HV-RS-SK-WAH- | 60
 | AU-RS-SK | 45 | [NAME] to 60mins once spiro resumes |  |  |  | AU-RS- | 45
 | AU-RS | 30 | [NAME] to 45mins once spiro resumes |  |  |  | AU-RS-FLT- | 60
 | AU-HV2 | 30 | Stay the same |  |  |  | AU-RS-SK- | 45
 | AU-SK | 30 |  |  |  |  | AU-RS-SK-HV- | 60
 | RS-SK-HV2 | 30 | [NAME] to 45mins once spiro resumes |  |  |  | AU-SK- | 30
 | 45 | 30 |  |  |  |  | BM-HV-RS-SK- | 45
 | RS-HV2 | 30 |  |  |  |  | DR2- | 30
 | SK-HV2 | 20 |  |  |  |  | FLT- | 30
 | HV3-AU-RS-SK | 75 |  |  |  |  | FLT-AU-HV-RS-SK- | 60
 | HV3-AU-RS | 75 |  |  |  |  | HV- | 15
 | HV3-AU | 60 |  |  |  |  | HV-RS-SK- | 45
 | HV3-SK | 45 |  |  |  |  | HV-RS-SK-AU- | 60
 | HV3-RS | 60 |  |  |  |  | HV-RS-SK-WAH- | 60
 | FFW-AU | 45 |  |  |  |  | SK- | 15
 | FFW-RS | 45 |  |  |  |  | WAH-AU-HV-RS-SK- | 60
 | FFW-SK | 30 |  |  |  |  | WAH-HV-RS-SK- | 60
 | FFW-HV2 | 45 |  |  |  |  | AU-HV-SK- | 45
 | FFW-HV3 | 60 | Rare occurance in light of new HSE guidance |  |  |  | AU-RS- | 45
 | FFW-HS (2 or more) | 60 |  |  |  |  | AU-RS-SK- | 45
 |  |  |  |  |  |  | RS-SK-WAH- | 60
 |  |  |  |  |  |  | AU-RS-SK-WAH- | 60
 |  |  |  |  |  |  | RS- | 20
 |  |  |  |  |  |  | RS-SK- | 30
Spreadsheet: 213722d1360622065-aging-concern-test
Sheet: Sheet1

Customer Name/ID | Invoice | Inv Date | Due Date | Total | CURRENT | Over 30 | Over 60 | Over 90 | Over 120
Apple | 652644 | 2013-01-07 00:00:00 | 2013-02-06 00:00:00 | 500.42 |  | 500.42
Orange | 623989 | 2012-05-09 00:00:00 | 2012-06-07 00:00:00 | 979.25 |  |  |  |  | 979.25
Orange | 647152 | 2012-11-06 00:00:00 | 2012-12-06 00:00:00 | 46.82 |  |  |  | 46.82
Orange | 650249 | 2012-12-05 00:00:00 | 2013-01-04 00:00:00 | 351 |  |  | 351
Orange | 654591 | 2013-01-23 00:00:00 | 2013-02-22 00:00:00 | 3042.73 | 3042.73
Orange | 654592 | 2013-01-22 00:00:00 | 2013-02-21 00:00:00 | 902.04 | 902.04
[NAME] | 655846 | 2013-02-04 00:00:00 | 2013-03-06 00:00:00 | 237.46 | 237.46
Pear | 656070 | 2013-02-06 00:00:00 | 2013-02-06 00:00:00 | 0.57 | 0.57
Spreadsheet: 831542d1685707076-formular-to-call-data-from-another-sheet-5-and-6-ask
Sheet: WAVULANA

MKOA WA MANYARA
HALMASHAURI Y WILAYA [NAME]
MATOKEO [NAME] WA MUHULA WA KWANZA MEI, 2023 DARASA LA VI WAVULANA
S/N | KATA | SHULE | JINA LA MTAHINIWA | JINSI    1. MV | MASOMO |  |  |  |  |  |  |  |  |  |  |  |  |  | JML | WASTANI | DARAJA | [NAME] | [NAME]
 |  |  |  |  | KISWAHILI |  | ENGLISH |  | HISABATI |  | SAYANSI NA TEKNOLOJIA |  | M/JAM |  | URAIA NA MAADILI |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
1 |  | SHEKINA | APIEL B MPACHILI | 1 | 44 | A | 29 | C | 39 | B | 34 | B | 44 | A | 36 | B | 41 | A | 267 | 38.14285714285715 | B | 5 | 5
2 | KALOLENI | SHEKINA | AUGUSTINO A MUNGA | 1 | 41 | A | 38 | B | 39 | B | 32 | B | 41 | A | 25 | C | 23 | C | 239 | 34.14285714285715 | B | 7 | 7
3 | KALOLENI | SHEKINA | [NAME] | 1 | 46 | A | 50 | A | 50 | A | 49 | A | 48 | A | 47 | A | 50 | A | 340 | 48.57142857142857 | A | 1 | 1
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
Spreadsheet: 214716d1361080435-need-help-with-populating-worksheet-with-rows-from-other-sheet-based-on-criteria-2013-pinto-schedule
Sheet: A's

Field | Date | Day | Start Time | Away | AC | HC | Home |  | Code | Team | Manager | # of Away | # of Home | Total | vs. A's | Cubs | Dodgers | Phillies | Pirates | Tigers | Yankess
 |  |  |  |  |  |  |  |  | 1 | A's | Hinds |  |  |  | X
 |  |  |  |  |  |  |  |  | 2 | Cubs | Okmin |  |  |  |  | X
 |  |  |  |  |  |  |  |  | 3 | Dodgers | Manheim |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  | 4 | Phillies | [NAME] |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  | 5 | Pirates | Myers |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  | 6 | Tigers | Grakal |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  | 7 | Yankees | Mitchell |  |  |  |  |  |  |  |  |  | X
Spreadsheet: eb5788d3-b278-4ac0-b94f-2b0736df942c
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Warner Bros Rec | 93624862529 | [NAME] | Marvelous Things Ep Cd | 2004-04-20 | EP version of CD | Alt | 5.99 | N | To Be Retired
Warner Bros Rec | 93624994848 | [NAME] | Combinations | 2007-08-14 | Compact Disc | Rock | 13.99 | Y | Available
Warner Bros Rec | 93624899020 | [NAME] | Room Noises | 2005-02-15 | Compact Disc | Rock | 9.99 | Y | Available
Spreadsheet: 882647d1731037874-sumifs-with-multiple-sum-range-and-criteria-in-different-sheets-sumifs-accross-mutiple-sheets
Sheet: Peter

Date | Name | Apple | Juice | Orange | Total
PRICE |  | 0.2 | 0.2 | 0.2
2024-11-01 00:00:00 | [NAME] | 2 | 4
2024-11-04 00:00:00 | [NAME] | 3 | 1
2024-11-08 00:00:00 | [NAME]
Spreadsheet: 330224d1404632604-multiple-conditions-bonus-salary-question-bonus
Sheet: Sheet1

SA | HIRE DATE | SALES | QUOTA | BONUS
BOB | 2014-01-01 00:00:00 | 375000 | 300000
MIKE | 2014-01-01 00:00:00 | 475000 | 350000
BILL | 2014-01-01 00:00:00 | 275000 | 150000
SUE | 2014-01-02 00:00:00 | 350000 | 225000
RODNEY | 2014-01-01 00:00:00 | 350000 | 225000
NICK | 2014-01-01 00:00:00 | 475000 | 400000
SARA | 2014-01-01 00:00:00 | 275000 | 200000
Spreadsheet: 767081d1644276083-need-help-on-spreadsheet-do-i-need-to-use-vlookup-hlookup-index-match-2022-law-dogs-standings
Sheet: Muckdogs

Muckdogs
Wk# | Opponent | W | L | PF | PA | MARGIN
1 | [NAME]
2 | Deadbirds
3 | Pics Hitmen
4 | Sharks
5 | Gator Dawgs
6 | Thundermutts
7 | Capo Crimini
8 | Cajun Coonasses
9 | King of Queens
10 | Mudcats
11 | Wet Farts
12 | Capo Crimini
13 | Thundermutts
14 | Wet Farts
15 | Mudcats
16 | Gator Dawgs
17 | Sharks
18 | King of Queens
19 | Cajun Coonasses
20 | Pics Hitmen
21 | Deadbirds
22 | [NAME]
Spreadsheet: 889933d1740972089-how-do-we-use-conditional-formatting-to-identify-named-cells-item-470
Sheet: 470.

 | [NAME] 109
 | HOT MIX ASPHALT BERM | TON
2 | IN - Thickness of top course
0 | FT - Length of 12-inch berm to install
 | IN - Thickness of top course
 | SF - Cross-sectional area of berm
0 | FT - Length of 24-inch berm to install
 | IN - Thickness of top course
 | SF - Cross-sectional area of berm
Spreadsheet: 158122d1337987517-how-make-a-self-updating-sales-target-using-if-function-sales-tool
Sheet: Sheet1

Day: | Wednesday
Week # | 20 | Monday |  |  | Tuesday |  |  |  |  | Wednesday |  |  |  |  | Thursday |  |  |  |  | Friday |  |  |  |  | Saturday |  |  |  |  | Sunday |  |  |  |  | Total
Sales Budget |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40000
Sales Target
Actual Sales |  | 3500 |  |  | 6000
$ to Goal
Transactions
ATV
Foot Traffic
Conversion %
Name |  | Shift | Zone |  | 8:00 |  | 9:00 |  | 10:00 |  | 11:00 |  | 12:00 |  | 1:00 |  | 2:00 |  | 3:00 |  | 4:00 |  | 5:00 |  | 6:00 |  | 7:00 |  | 8:00 |  | 9:00 |  | 10:00 |  | 11:00 |  | Initial
Today's | Hours | Hourly | [NAME]
Goal | Open | Goal | Cumulative Goal |  |  |  |  |  | 0
 |  |  | Actual Sales
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday