tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 54970d1255013184-automated-ref-number-generation-indexnumberupdate
Sheet: Sheet1

 | Index number |  |  | Index number
 | 0 |  |  | 0
yes |  |  | Yes | 4
yes |  |  | Yes | 50
yes
no | 13
Yes | 13
Yes | 13 |  | Yes | 54
Yes | 13 |  | Yes | 55
Yes | 13 |  | Yes | 56
yes
yes
 |  |  | No
Spreadsheet: 550432d1512330228-removing-duplicate-name-but-adding-sum-to-original-s666-annual-leave-code
Sheet: Sheet1

Pay Number | Name | annual leave |  |  | Pay Number | Name | Annual leave
123 | [NAME] | 00:01:00 |  |  | 123 | [NAME] | 00:02:00
234 | [NAME] | 00:01:00 |  |  | 234 | [NAME] | 00:01:00
134 | Billy | 00:01:00 |  |  | 134 | Billy | 00:02:00
543 | [NAME] | 00:01:00 |  |  | 543 | [NAME] | 00:01:00
123 | [NAME] | 00:01:00
134 | Billy | 00:01:00
Spreadsheet: 734491d1622202308-if-column-number-matches-row-number-pull-out-number-excel-attached-testdoc
Sheet: Sheet1

 |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  |  |  |  |  |  | Units | Units | Units | Units | Units | Units | Units
 |  |  |  |  |  |  | 0.4 | 0.1 | 0 | 0 | 0 | 0 | 0 | 7 | 0
 |  |  |  |  |  |  | 5.9 | 0 | 5.6 | 3.3 | 0 | 0 | 0 | 7 | 0
 |  |  |  |  |  |  | 6.2 | 3.3 | 4.4 | 1.5 | 0 | 10.8 | 0 | 6 | 10.8
 |  |  |  |  |  |  | 2.2 | 0 | 0 | 0.2 | 0.4 | 6.7 | 0 | 6 | 6.7
 |  |  |  |  |  |  | 8.5 | 15.7 | 6.9 | 0 | 3 | 0 | 0 | 6 | 0
 |  |  |  |  |  |  | 0.4 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0
 |  |  |  |  |  |  | 35.3 | 21.2 | 36.3 | 1.4 | 9.1 | 0 | 0 | 1 | 35.3
 |  |  |  |  |  |  | 5.2 | 17.1 | 0 | 0 | 0 | 0 | 0 | 1 | 5.2
 |  |  |  |  |  |  | 24.7 | 0.2 | 32.9 | 19.5 | 0 | 0.9 | 0 | 4 | 19.5
Spreadsheet: 270821d1381691197-a-formula-that-tells-me-if-an-account-is-active-based-on-data-in-a-table-active-account
Sheet: Sheet1

 |  | Account Status |  | Active
 |  |  |  |  |  |  |  |  |  |  | Hi there, I am looking for a formula that gets the Account status (cell E4) to say "Active" if any of the accounts in the table are active (i.e. cells I7 to I13 says yes.) If all the accounts in the table aernt active(i.e. cells I7 to I13 say no)  then I would like the account status (cell E4) to say "Not Active". Thanks :)
 |  | Accounts
 |  | No | Account No | Sub Account Name |  |  |  | Active?
 |  | 1 | 123456 | mike fairhurst ltd |  |  |  | Yes
 |  | 2 | 789101112 | mikefairhurst limited
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
Spreadsheet: 151699d1335064866-calculating-npv-of-cashflows-finance
Sheet: finance

 |  | Year | Annual Operating Cash Flow | Salvage Value |  | cost of capital |  | 0.1
 |  | 0 | -22500 | 22500
 |  | 1 | 6250 | 17500
 |  | 2 | 6250 | 14000
 |  | 3 | 6250 | 11000
 |  | 4 | 6250 | 5000
 |  | 5 | 6250 | 0
a. | NPV - year 0
 | NPV - year 1
 | NPV - year 2
 | NPV - year 3 |  | CF0 =-22500,  CF1=6250,  Nj=2,  CF3=17250, and I/YR=10 to solve for NPV3 = $1,307
 | NPV - year 4
 | NPV - year 5
Spreadsheet: 841983d1694092591-how-to-group-different-records-in-one-cel-seperated-by-a-comma-textjoin-etaf
Sheet: Sheet1

A | 1
A | 7 |  | B
A | 3 |  | C
B | 8
B | 9
C | 4
C | 5
C | 2
C | 1
Spreadsheet: 718259d1613060995-list-of-values-based-on-a-specific-criteria-porfolio
Sheet: In Progress

 | Project Name
Spreadsheet: 677262d1589271878-combine-identical-lines-to-1-with-sum-loc-tool
Sheet: Ark1

RAW DATA |  |  |  |  |  |  | FINAL DATA
SKU | QTY | [NAME] |  |  |  |  | SKU | QTY | [NAME]
92011 | 1 | 1.A.A.1 |  |  |  |  | 92011 | 6 | 1.A.A.1
92011 | 5 | 1.A.A.1 |  |  |  |  | 92011 | 10 | 2.A.A.1
92011 | 10 | 2.A.A.1 |  |  |  |  | 92011 | 7 | 5.A.A.1
92011 | 5 | 5.A.A.1
92011 | 2 | 5.A.A.1
Spreadsheet: 167048d1341880766-how-to-pick-up-the-numbers-from-the-data-but-not-duplicate-them-by-formula-123
Sheet: Sheet1

Data | how to use formula to get these numbers? | Count if
100 | 20
20 | 40
100 | 100
100 | 200
200 | 300
200 | 400
300 | 555
400 | 663
555
40
500
663
555
555
40
Spreadsheet: 131376d1322936465-counting-scheduled-hours-by-interval-ot-tracker
Sheet: OT Report

Interval | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
05:00:00
05:30:00
06:00:00
06:30:00
07:00:00
07:30:00
08:00:00
08:30:00
09:00:00
09:30:00
10:00:00
10:30:00
11:00:00
11:30:00
12:00:00
12:30:00
13:00:00
13:30:00
14:00:00
14:30:00
15:00:00
15:30:00
16:00:00
16:30:00
17:00:00
17:30:00
18:00:00
18:30:00
19:00:00
19:30:00
20:00:00
20:30:00
21:00:00
21:30:00
22:00:00
22:30:00
23:00:00
Total
Spreadsheet: 151085d1334775168-sum-column-b-if-column-a-is-within-multiple-specificed-ranges-excel
Sheet: VehInfo

MP | Count |  |  | Minus MP | Plus MP
0 | 12 |  |  | 0.02 | 0.02
0.01 | 28 |  | MP | Lower | Upper | Output | Example output answer
0.02 | 66 |  | 2.02 | 2 | 2.04
0.03 | 6 |  |  | 1.99 | 1.73
0.04 | 2 |  | 1.7 | 1.68 | 1.72
0.05 | 5 |  |  | 1.67 | 1.64
0.06 | 0 |  | 1.61 | 1.59 | 1.63
0.07 | 2 |  |  | 1.58 | 1.53
0.08 | 9 |  | 1.5 | 1.48 | 1.52
0.09 | 4 |  |  | 1.47 | 1.39
0.1 | 18 |  | 1.36 | 1.34 | 1.38
0.11 | 2 |  |  | 1.33 | 1.31
0.12 | 0 |  | 1.28 | 1.26 | 1.3
0.13 | 6 |  |  | 1.25 | 1.21
0.14 | 0 |  | 1.18 | 1.16 | 1.2
0.15 | 4 |  |  | 1.15 | 1.1
0.16 | 17 |  | 1.07 | 1.05 | 1.09
0.17 | 6 |  |  | 1.04 | 1.01
0.18 | 6 |  | 0.98 | 0.96 | 1
0.19 | 4 |  |  | 0.95 | 0.74
0.2 | 2 |  | 0.71 | 0.69 | 0.73
0.21 | 6 |  |  | 0.6799999999999999 | 0.65
0.22 | 44 |  | 0.62 | 0.6 | 0.64
0.23 | 6 |  |  | 0.59 | 0.33
0.24 | 0 |  | 0.3 | 0.28 | 0.32
0.25 | 4 |  |  | 0.27 | 0.25
0.26 | 22 |  | 0.22 | 0.2 | 0.24
0.27 | 2 |  |  | 0.19 | 0.13 |  | 43
0.28 | 6 |  | 0.1 | 0.08 | 0.12 |  | 33
0.29 | 4 |  |  | 0.07 | 0.03 |  | 15
0.3 | 32 |  | 0 | -0.02 | 0.02 |  | 106
0.31 | 4
0.32 | 0
0.33 | 0
0.34 | 5
0.35 | 3
0.36 | 8
0.37 | 4
0.38 | 0
0.39 | 2
0.4 | 2
0.41 | 0
0.42 | 2
0.43 | 2
0.44 | 6
0.45 | 0
0.46 | 0
0.47 | 0
0.48 | 0
0.49 | 6
0.5 | 0
0.51 | 0
0.52 | 6
0.53 | 2
0.54 | 40
0.55 | 2
0.56 | 3
0.57 | 0
0.58 | 5
0.59 | 4
0.6 | 4
0.61 | 12
0.62 | 35
0.63 | 15
0.64 | 6
0.65 | 14
0.66 | 2
0.67 | 13
0.68 | 2
0.69 | 0
0.7 | 2
0.71 | 24
0.72 | 4
0.73 | 2
0.74 | 6
0.75 | 10
0.76 | 0
0.77 | 8
0.78 | 0
0.79 | 8
0.8 | 5
0.81 | 4
0.82 | 6
0.83 | 0
0.84 | 6
0.85 | 0
0.86 | 4
0.87 | 0
0.88 | 6
0.89 | 0
0.9 | 2
0.91 | 4
0.92 | 0
0.93 | 0
0.94 | 8
0.95 | 2
0.96 | 0
0.97 | 2
0.98 | 12
0.99 | 10
1 | 0
1.01 | 0
1.02 | 2
1.03 | 0
1.04 | 4
1.05 | 0
1.06 | 2
1.07 | 0
1.08 | 0
1.09 | 0
1.1 | 0
1.11 | 0
1.12 | 1
1.13 | 2
1.14 | 2
1.15 | 6
1.16 | 4
1.17 | 2
1.18 | 27
1.19 | 0
1.2 | 8
1.21 | 4
1.22 | 0
1.23 | 5
1.24 | 0
1.25 | 0
1.26 | 2
1.27 | 0
1.28 | 4
1.29 | 0
1.3 | 0
1.31 | 0
1.32 | 0
1.33 | 0
1.34 | 0
1.35 | 0
1.36 | 0
1.37 | 0
1.38 | 2
1.39 | 0
1.4 | 0
1.41 | 0
1.42 | 2
1.43 | 0
1.44 | 0
1.45 | 0
1.46 | 0
1.47 | 2
1.48 | 0
1.49 | 0
1.5 | 8
1.51 | 0
1.52 | 0
1.53 | 0
1.54 | 0
1.55 | 0
1.56 | 0
1.57 | 0
1.58 | 2
1.59 | 0
1.6 | 2
1.61 | 10
1.62 | 2
1.63 | 0
1.64 | 4
1.65 | 2
1.66 | 0
1.67 | 0
1.68 | 0
1.69 | 0
1.7 | 6
1.71 | 3
1.72 | 0
1.73 | 0
1.74 | 2
1.75 | 0
1.76 | 4
1.77 | 0
1.78 | 4
1.79 | 0
1.8 | 0
1.81 | 2
1.82 | 10
1.83 | 0
1.84 | 2
1.85 | 0
1.86 | 0
1.87 | 0
1.88 | 0
1.89 | 0
1.9 | 0
1.91 | 2
1.92 | 0
1.93 | 5
1.94 | 0
1.95 | 4
1.96 | 2
1.97 | 2
1.98 | 2
1.99 | 2
2 | 8
Spreadsheet: 871381d1717758754-largest-and-average-gap-in-rows-formula-gaptestbook-1-
Sheet: Sheet1

ROUND | RESULT |  | Largest | Average
1 | 4.49
2 | 1
3 | 1.23
4 | 1.83
5 | 10.7
6 | 1.12
7 | 6.33
8 | 8.17
9 | 1.03
10 | 3.51
11 | 1.49
12 | 1.49
13 | 1.23
14 | 3.16
15 | 2.3
16 | 1.45
17 | 5.2
18 | 1.37
19 | 1.81
20 | 1.62
21 | 2.27
22 | 1.33
23 | 13.84
24 | 2.13
25 | 2.89
26 | 1.56
27 | 2.25
28 | 1.2
29 | 1.05
30 | 1.39
31 | 4.62
32 | 4.24
33 | 4.47
34 | 1.36
35 | 1.48
36 | 1.69
37 | 1.93
38 | 2.28
39 | 23.21
40 | 8.29
41 | 1.92
42 | 1.12
43 | 1.06
44 | 4.16
45 | 1.78
46 | 4.59
47 | 2.64
48 | 1.25
49 | 40.96
50 | 1.6
51 | 2.49
52 | 1.35
53 | 1.19
54 | 2.99
55 | 1.53
56 | 1.06
57 | 1.29
58 | 1.24
59 | 1.96
60 | 2.5
61 | 8.76
62 | 1.31
63 | 66.94
64 | 1.51
65 | 1.4
66 | 1.05
67 | 1.41
68 | 2.24
69 | 2.18
70 | 5.66
71 | 1.32
72 | 1
73 | 1.97
74 | 105.24
75 | 1.96
76 | 9
77 | 1.33
78 | 1.13
79 | 4.33
80 | 3.79
81 | 1.26
82 | 1.45
83 | 1.75
84 | 1.9
85 | 1.87
86 | 1.55
87 | 2
88 | 1.63
89 | 1.38
90 | 1.69
91 | 1.31
92 | 2.04
93 | 2.49
94 | 1.77
95 | 1.93
96 | 7.25
97 | 2.01
98 | 1.68
99 | 29.74
100 | 1.22
Spreadsheet: 870249d1716798144-sumproduct-formula-not-giving-any-results-excel-help-with-formulas-2-
Sheet: List

Contracts |  | Reason for Days Lost
 |  | Down time reasons
Contract B |  | X
Contract C |  | WEATHER
Contract D |  | TRUCK BREAK DOWN
Contract E |  | AGENCY CREW ISSUE
Contract F |  | CONTRACT
Contract G |  | WORKSHOP
Contract H |  | UNIT BREAKDOWN
Contract I |  | AVALIBLE FOR CONTRACT
Contract j |  | VELOCITY CREW ISSUE
Contract K |  | SPARE ON CONTRACT
Contract L |  | CREW TRAVEL
Contract M |  | MATERIAL ISSUE
Contract N
Contract O
Contract P
Contract Q
0
Spreadsheet: 116080d1311592458-selective-columns-handicapscoresoncards
Sheet: result

 | No | PLAYER | PAR 3 | TOTAL |  | s/index 1 | s/index 2 | s/index 3 | PLAYING
 | 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
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 63
 | 64
 | 65
 | 66
 | 67
 | 68
 | 69
 | 70
 | 71
 | 72
 | 73
 | 74
 | 75
 | 76
 | 77
 | 78
 | 79
 | 80
 | 81
 | 82
 | 83
 | 84
 | 85
 | 86
 | 87
 | 88
 | 89
 | 90
 | 91
 | 92
 | 93
 | 94
 | 95
 | 96
 | No | PLAYER | PAR 3 | TOTAL |  | s/index 1 | s/index 2 | s/index 3 | ATT
 | 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
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 63
 | 64
 | 65
 | 66
 | 67
 | 68
 | 69
 | 70
 | 71
 | 72
 | 73
 | 74
 | 75
 | 76
 | 77
 | 78
 | 79
 | 80
 | 81
 | 82
 | 83
 | 84
 | 85
 | 86
 | 87
 | 88
 | 89
 | 90
 | 91
 | 92
 | 93
 | 94
 | 95
 | 96
Spreadsheet: 855317d1704922079-timetable-mapping-appointments-calendar
Sheet: Sheet1

2024-01-02 00:00:00 | 08:30:00
[NAME] |  |  |  |  |  | BUSY | BUSY | BUSY | BUSY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BUSY | BUSY
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | BUSY | BUSY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BUSY | BUSY
[NAME] |  |  |  |  |  | BUSY | BUSY | BUSY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BUSY | BUSY | BUSY | BUSY
Eddie |  | BUSY | BUSY | BUSY | BUSY | BUSY | BUSY | BUSY | BUSY | BUSY | BUSY | BUSY | BUSY | BUSY | BUSY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BUSY | BUSY | BUSY | BUSY | BUSY | BUSY | BUSY | BUSY | BUSY | BUSY
[NAME] |  |  |  |  |  | BUSY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BUSY | BUSY | BUSY | BUSY | BUSY
Meeting | Start Date | Start Time | End Date | End Time | All Day? | Staff Member
Meeting 1 | 2024-01-02 00:00:00 | 09:30:00 | 2024-01-02 00:00:00 | 10:30:00 | False | BOB
Meeting 2 | 2024-01-02 00:00:00 | 15:00:00 | 2024-01-02 00:00:00 | 15:30:00 | False | BOB
Meeting 1 | 2024-01-02 00:00:00 | 16:00:00 | 2024-01-02 00:00:00 | 16:30:00 | False | CHRIS
Meeting 2 | 2024-01-02 00:00:00 | 11:30:00 | 2024-01-02 00:00:00 | 12:00:00 | False | CHRIS
Meeting 1 | 2024-01-02 00:00:00 | 09:30:00 | 2024-01-02 00:00:00 | 10:15:00 | False | DAVE
Meeting 2 | 2024-01-02 00:00:00 | 15:00:00 | 2024-01-02 00:00:00 | 16:30:00 | False | DAVE
Meeting 1 | 2024-01-02 00:00:00 | 08:30:00 | 2024-01-02 00:00:00 | 12:00:00 | False | EDDIE
Meeting 2 | 2024-01-02 00:00:00 | 16:30:00 | 2024-01-02 00:00:00 | 19:00:00 | False | EDDIE
Meeting 1 | 2024-01-02 00:00:00 | 09:30:00 | 2024-01-02 00:00:00 | 09:45:00 | False | FRANK
Meeting 2 | 2024-01-02 00:00:00 | 15:00:00 | 2024-01-02 00:00:00 | 16:15:00 | False | FRANK
Spreadsheet: 271806d1382054251-lookup-and-return-value-based-on-2-conditions-for-forum
Sheet: FLB

EVENT_ID | Favourite
100400379
100405273
100409664
100414808
100414893
100415007
100415008
100418732
100418733
100425771
100425773
100425775
100426169
100426171
100426173
100426175
100426177
100426179
100426181
100426183
100426185
100426187
100426189
100426191
100426193
100426195
100426197
100426199
100426201
100426203
100426205
100426207
100426209
100426211
100426213
100426215
100426217
100426219
100426221
100426223
100426225
100426227
100426229
100426231
100426233
100426235
100426237
100426239
100426241
100426243
100426245
100426247
100426259
100426261
100426263
100426265
100426267
100426269
100426271
100426273
100426275
100426293
100426295
100426297
100426299
100426301
100426303
100426305
100426307
100426309
100426311
100426313
100426315
100426317
100426319
100426321
100426343
100426345
100426347
100426349
100426351
100426353
100426355
100426357
100426359
100426361
100426363
100426365
100426367
100426369
100426371
100426373
100426375
100426377
100427745
100427747
100427749
100427751
100427753
Spreadsheet: 62403d1263354002-need-to-match-week-and-count-rows-with-yes-or-no-problem
Sheet: Data

Date | Name | Yes/No
2009-12-01 00:00:00 | [NAME] | Yes
2009-12-05 00:00:00 | [NAME] | No
2010-01-05 00:00:00 | Sophie | No
2010-01-05 00:00:00 | George | Yes
2010-01-07 00:00:00 | [NAME] | No
2010-01-10 00:00:00 | [NAME] | No
Spreadsheet: 47008d1245926352-moving-values-around-example
Sheet: Input

Date | Account code | Description | Money out | Money in | Cash? | Comment
2009-01-01 00:00:00 | 3100 | Sale, billetter |  | 50000
2009-01-04 00:00:00 | 7200 | Honorar, [NAME] | 20000
2009-01-07 00:00:00 | 7200 | Honorar, [NAME] | 50000
2009-01-12 00:00:00 | 3100 | Sale, billetter |  | 30000
2009-01-12 00:00:00 | 7220 | Rider, [NAME] | 10000
2009-01-14 00:00:00 | 7290 | Other costs | 500
2009-01-12 00:00:00 | 3100 | Sale, billetter | 250
Spreadsheet: 847913d1698758068-conditional-formatting-of-referenced-cells-conditional-formatting-example
Sheet: Item 3

 | Goal | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | YTD
Disposition |  | 12 | 18 | 99 | 100 | 100 | 100 | 88 | 99 | 100 |  |  |  | 79.55555555555556
Source Code |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expecting results from Source Code tab, line 4
Template |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expecting results from Template tab, line 4
Submittal |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expecting results from Submittal tab, line 4
Spreadsheet: 120450d1315311159-how-to-do-this-lookup-copy-of-stats-help
Sheet: Sheet1

Picker | Min Rate | Zone | Date
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 327934d1403725530-formula-for-different-options-to-return-a-value-based-upon-the-selections-example
Sheet: Reference Sheet

Size & Connection | OD | ID | HELPER COL | [NAME] |  |  |  |  |  | HELPER COL
API NC 23 | 3 | 1 |  | 2508 | 1st row |  | API NC 23 | 3 | 1
API NC 23 | 3 | 1.25 |  | 2508 | 1st row |  | 2 3/8" [NAME]. | 3.13 | 1.25
API NC 23 | 3 | 1.5 |  | 2508 | 1st row |  | 2 3/8" PAC | 3.25 | 1.5
API NC 23 | 3.13 | 1 |  | 3330 | 2nd row |  | 2 3/8" IF | 3.5 | 1.75
API NC 23 | 3.13 | 1.25 |  | 3330 | 2nd row |  | API NC 26 | 3.75
API NC 23 | 3.13 | 1.5 |  | 2647 | 2nd row |  | 2 7/8" SH | 3.88
API NC 23 | 3.25 | 1 |  | 4000 | 3rd row |  | 2 7/8" [NAME]. | 4.13
API NC 23 | 3.25 | 1.25 |  | 3387 | 3rd row |  | 2 7/8" XH
API NC 23 | 3.25 | 1.5 |  | 2647 | 3rd row
2 3/8" [NAME]. | 3 | 1.25 |  | 2241 | 1st row
2 3/8" [NAME]. | 3 | 1.5 |  | 2241 | 1st row
2 3/8" [NAME]. | 3 | 1.75 |  | 1749 | 1st row
2 3/8" [NAME]. | 3.13 | 1.25 |  | 3028 | 2nd row
2 3/8" [NAME]. | 3.13 | 1.5 |  | 2574 | 2nd row
2 3/8" [NAME]. | 3.13 | 1.75 |  | 1749 | 2nd row
2 3/8" [NAME]. | 3.25 | 1.25 |  | 3285 | 3rd row
2 3/8" [NAME]. | 3.25 | 1.5 |  | 2574 | 3rd row
2 3/8" [NAME]. | 3.25 | 1.75 |  | 1749 | 3rd row
2 3/8" PAC | 3 | 1.25 |  | 3797 | 1st row
2 3/8" PAC | 3 | 1.5 |  | 3797 | 1st row
2 3/8" PAC | 3 | 1.75 |  | 2926 | 1st row
2 3/8" PAC | 3.13 | 1.25 |  | 4966 | 2nd row
2 3/8" PAC | 3.13 | 1.5 |  | 4151 | 2nd row
2 3/8" PAC | 3.13 | 1.75 |  | 2926 | 2nd row
2 3/8" PAC | 3.25 | 1.25 |  | 5206 | 3rd row
2 3/8" PAC | 3.25 | 1.5 |  | 4151 | 3rd row
2 3/8" PAC | 3.25 | 1.75 |  | 2926 | 3rd row
2 3/8" IF | 3.5 | 1.25 |  | 4606
2 3/8" IF | 3.5 | 1.5 |  | 4606
2 3/8" IF | 3.5 | 1.75 |  | 3697
2 3/8" IF | 3.75 | 1.25 |  | 5501
2 3/8" IF | 3.75 | 1.5 |  | 4668
2 3/8" IF | 3.75 | 1.75 |  | 3697
API NC 26 | 3.5 | 1.25 |  | 4606
API NC 26 | 3.5 | 1.5 |  | 4606
API NC 26 | 3.5 | 1.75 |  | 3697
API NC 26 | 3.75 | 1.25 |  | 5501
API NC 26 | 3.75 | 1.5 |  | 4668
API NC 26 | 3.75 | 1.75 |  | 3697
2 7/8" SH | 3.5 | 1.25 |  | 4606
2 7/8" SH | 3.5 | 1.5 |  | 4606
2 7/8" SH | 3.5 | 1.75 |  | 3697
2 7/8" SH | 3.75 | 1.25 |  | 5501
2 7/8" SH | 3.75 | 1.5 |  | 4668
2 7/8" SH | 3.75 | 1.75 |  | 3697
2 7/8" [NAME]. | 3.5 | 1.25 |  | 3838 | 1st row
2 7/8" [NAME]. | 3.5 | 1.5 |  | 3838 | 1st row
2 7/8" [NAME]. | 3.5 | 1.75 |  | 3838 | 1st row
2 7/8" [NAME]. | 3.75 | 1.25 |  | 5766 | 2nd row
2 7/8" [NAME]. | 3.75 | 1.5 |  | 4951 | 2nd row
2 7/8" [NAME]. | 3.75 | 1.75 |  | 4002 | 2nd row
2 7/8" [NAME]. | 3.88 | 1.25 |  | 5766 | 3rd row
2 7/8" [NAME]. | 3.88 | 1.5 |  | 4951 | 3rd row
2 7/8" [NAME]. | 3.88 | 1.75 |  | 4002 | 3rd row
2 7/8" XH | 3.75 | 1.25 |  |  | 1st row
2 7/8" XH | 3.75 | 1.5 |  |  | 1st row
2 7/8" XH | 3.75 | 1.75 |  |  | 1st row
2 7/8" XH | 3.88 | 1.25 |  |  | 2nd row
2 7/8" XH | 3.88 | 1.5 |  |  | 2nd row
2 7/8" XH | 3.88 | 1.75 |  |  | 2nd row
2 7/8" XH | 4.13 | 1.25 |  |  | 3rd row
2 7/8" XH | 4.13 | 1.5 |  |  | 3rd row
2 7/8" XH | 4.13 | 1.75 |  |  | 3rd row
Spreadsheet: 840736d1692947363-formula-needed-for-different-price-when-brought-at-different-qty-jp16
Sheet: Sheet1

No of apple | Price | Average Price | Marginal Difference |  |  |  |  |  | Manual Trial & Error |  | [NAME] | Apple Left
0 | 6 |  | 6 | 1 |  |  |  | No of apple | Multiple | Amount
1 | 17 |  |  | 3 | No of Apples | 87 |  | 13 | 6
4 | 25 |  |  | 5 | Price |  |  |  | 1
9 | 55 |  |  | 12 |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 1
 | 1
 | 3 |  |  |  |  |  |  |  | Total Price
 | 5
 | 78
 |  |  |  |  |  |  |  | Is it possible to compute in a single formula?
Spreadsheet: 855438d1704992313-timesheet-database-sample-timesheet
Sheet: 19-Feb-24

Staff Name | Project | Project Number | Project Name | Mon | Tue | Wed | Thu | Fri
Employee 1 | 23001 - Project 1 |  |  |  |  |  |  | 7.5
Employee 1 | 23002 - Project 2
Employee 1 | 23003 - Project 3
Employee 1 | 23004 - Project 4 |  |  |  |  |  | 7.5
Employee 1 | 23005 - Project 5 |  |  | 7.5 | 7.5 | 7.5
Employee 1 | 23006 - Project 6
Employee 1 | 23007 - Project 7
Employee 1 | 23008 - Project 8
Employee 1 | 23009 - Project 9
Employee 1 | 23010 - Project 10
Spreadsheet: 807814d1670073802-sumifs-with-variable-number-of-dynamic-criteria-sumifs-example-1-2-
Sheet: Sheet1

Letter | Colour | Region | Date | Value |  | [NAME] | CriteriaRange1 | Operator1 | Criteria1 | CriteriaRange2 | Operator2 | Criteria2 | CriteriaRange3 | Operator3 | Criteria3 | [NAME] |  | Text | Numerical
A | Red | Europe | 2022-01-01 00:00:00 | 100 |  | Value | Letter | = | A | Colour | = | Red | Date | <> | 2022-04-01 00:00:00 |  |  | = | =
B | Blue | Americas | 2022-01-01 00:00:00 | 115 |  | Value | Letter | <> | A | Colour | = | Red | Date |  |  |  |  | <> | <>
C | Green | Asia | 2022-01-01 00:00:00 | 130 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >=
D | Yellow | Americas | 2022-01-01 00:00:00 | 145 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >
E | Red | Europe | 2022-01-01 00:00:00 | 160 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <=
A | Blue | Americas | 2022-01-01 00:00:00 | 175 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <
G | Green | Asia | 2022-01-01 00:00:00 | 190
H | Yellow | Europe | 2022-01-01 00:00:00 | 205
I | Red | Americas | 2022-01-01 00:00:00 | 220
A | Blue | Europe | 2022-01-01 00:00:00 | 235
A | Green | Americas | 2022-07-01 00:00:00 | 250
B | Yellow | Asia | 2022-07-01 00:00:00 | 265
A | Blue | Europe | 2022-07-01 00:00:00 | 280
R | Green | Americas | 2022-07-01 00:00:00 | 295
U | Yellow | Europe | 2022-07-01 00:00:00 | 310
H | Red | Americas | 2022-07-01 00:00:00 | 325
Q | Blue | Asia | 2022-07-01 00:00:00 | 340
W | Green | Europe | 2022-07-01 00:00:00 | 355
D | Yellow | Americas | 2022-07-01 00:00:00 | 370
A | Red | Europe | 2022-07-01 00:00:00 | 385
B | Red | Europe | 2022-07-01 00:00:00 | 400
Spreadsheet: f08cdaa6-3e3c-43ec-bee7-6157050a0d1e
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
ADNA | Test | ADNA | DNA Double-Stranded (dsDNA) Antibodies, IgG, Serum | DNA Double-Stranded Ab, IgG, S | Enzyme-Linked Immunosorbent Assay (ELISA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.35 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | <30.0 IU/mL (negative) 30.0-75.0 IU/mL (borderline) >75.0 IU/mL (positive) Negative is considered normal. Reference values apply to all ages. | Monday through Saturday; 4 p.m. | 1 day | 3 days | 1 | 86225 |  |  |  |  | Rochester
ADNA | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 21 days
ADNA | Result | ADNA | DNA Double-Stranded Ab, IgG, S | DNA Double-Stranded Ab, IgG, S | Numeric |  |  |  |  | IU/mL |  |  |  |  |  |  |  |  |  | 33800-4 | DNA double strand Ab.IgG:ACnc:Pt:Ser:Qn:
Spreadsheet: 680383d1591001578-generate-dates-using-formula-att_test
Sheet: May

2020 | 4
2020 | 5
 |  |  |  |  |  |  |  | P= Present, V= Vacation, O= Absent with out permission, [NAME] leave, A= Absent, U= Unpaid, MS= Military Service, M= Mission
NO | CODE | NAME
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P | V | O | S | A | U | MS | M | TOTAL
1 | 100 | 1 | P | P | P | V | P | V | V | V | V | P | A | A | P | A | V | V | U | U | U | V | V | M | P | A | V | A | V | M | V | P | P
 | 200 | 2
 | 300 | 3