tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 146465d1332190280-combine-comments-from-four-tabs-into-one-column-inspection_tests
Sheet: NW

E | EQUIP_NO | DSTRCT_CODE | EQUIP_GRP_ID | Defect Priority | Comment | Assessment
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Change
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Maintenance
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | No Defect
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Revisit
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Section 81
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Change
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Change
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Change
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Change
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Maintenance
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Maintenance
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Maintenance
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Maintenance
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
Spreadsheet: 131839d1323355321-select-data-from-excel-to-carry-to-a-word-document-alarm-letter
Sheet: Letter

This space is blank so it won't print over Dept. Letterhead
Record # to print | 1
 |  | We have responded to 3 false alarms at your address with the following dates and times:
 |  | Date | Time
 |  | It is the policy of the department to issue a warning letter after three false alarms.  If any more
 |  | occur, the we will bill you for $125.00 for each false alarm.  In order to avoid being charged
 |  | please contact your alarm company and have them adjust your system appropriately.
 |  | Please contact us if you have any further questions or concerns.
 |  | [PHONE]
 |  | Thank you for taking care of this promptly.
 |  | Regards
 |  | Appropriate name and address.
Spreadsheet: 53589d1253545756-start-day-building-out-365-days-reading
Sheet: Sheet2

Enter your start day
 | List 1 | List 2 | List 3 | List 4 | List 5 | List 6 | List 7 | List 8 | List 9 | List 10
Day 1
Day 2
Day 3
Day 4
Day 5
Day 6
Day 7
Day 8
Day 9
Day 10
Day 11
Day 12
Day 13
Day 14
Day 15
Day 16
Day 17
Day 18
Day 19
Day 20
Day 21
Day 22
Day 23
Day 24
Day 25
Day 26
Day 27
Day 28
Day 29
Day 30
Day 31
Day 32
Day 33
Day 34
Day 35
Day 36
Day 37
Day 38
Day 39
Day 40
Day 41
Day 42
Day 43
Day 44
Day 45
Day 46
Day 47
Day 48
Day 49
Day 50
Day 51
Day 52
Day 53
Day 54
Day 55
Day 56
Day 57
Day 58
Day 59
Day 60
Day 61
Day 62
Day 63
Day 64
Day 65
Day 66
Day 67
Day 68
Day 69
Day 70
Day 71
Day 72
Day 73
Day 74
Day 75
Day 76
Day 77
Day 78
Day 79
Day 80
Day 81
Day 82
Day 83
Day 84
Day 85
Day 86
Day 87
Day 88
Day 89
Day 90
Day 91
Day 92
Day 93
Day 94
Day 95
Day 96
Day 97
Day 98
Day 99
Day 100
Day 101
Day 102
Day 103
Day 104
Day 105
Day 106
Day 107
Day 108
Day 109
Day 110
Day 111
Day 112
Day 113
Day 114
Day 115
Day 116
Day 117
Day 118
Day 119
Day 120
Day 121
Day 122
Day 123
Day 124
Day 125
Day 126
Day 127
Day 128
Day 129
Day 130
Day 131
Day 132
Day 133
Day 134
Day 135
Day 136
Day 137
Day 138
Day 139
Day 140
Day 141
Day 142
Day 143
Day 144
Day 145
Day 146
Day 147
Day 148
Day 149
Day 150
Day 151
Day 152
Day 153
Day 154
Day 155
Day 156
Day 157
Day 158
Day 159
Day 160
Day 161
Day 162
Day 163
Day 164
Day 165
Day 166
Day 167
Day 168
Day 169
Day 170
Day 171
Day 172
Day 173
Day 174
Day 175
Day 176
Day 177
Day 178
Day 179
Day 180
Day 181
Day 182
Day 183
Day 184
Day 185
Day 186
Day 187
Day 188
Day 189
Day 190
Day 191
Day 192
Day 193
Day 194
Day 195
Day 196
Day 197
Day 198
Day 199
Day 200
Day 201
Day 202
Day 203
Day 204
Day 205
Day 206
Day 207
Day 208
Day 209
Day 210
Day 211
Day 212
Day 213
Day 214
Day 215
Day 216
Day 217
Day 218
Day 219
Day 220
Day 221
Day 222
Day 223
Day 224
Day 225
Day 226
Day 227
Day 228
Day 229
Day 230
Day 231
Day 232
Day 233
Day 234
Day 235
Day 236
Day 237
Day 238
Day 239
Day 240
Day 241
Day 242
Day 243
Day 244
Day 245
Day 246
Day 247
Day 248
Day 249
Day 250
Day 251
Day 252
Day 253
Day 254
Day 255
Day 256
Day 257
Day 258
Day 259
Day 260
Day 261
Day 262
Day 263
Day 264
Day 265
Day 266
Day 267
Day 268
Day 269
Day 270
Day 271
Day 272
Day 273
Day 274
Day 275
Day 276
Day 277
Day 278
Day 279
Day 280
Day 281
Day 282
Day 283
Day 284
Day 285
Day 286
Day 287
Day 288
Day 289
Day 290
Day 291
Day 292
Day 293
Day 294
Day 295
Day 296
Day 297
Day 298
Day 299
Day 300
Day 301
Day 302
Day 303
Day 304
Day 305
Day 306
Day 307
Day 308
Day 309
Day 310
Day 311
Day 312
Day 313
Day 314
Day 315
Day 316
Day 317
Day 318
Day 319
Day 320
Day 321
Day 322
Day 323
Day 324
Day 325
Day 326
Day 327
Day 328
Day 329
Day 330
Day 331
Day 332
Day 333
Day 334
Day 335
Day 336
Day 337
Day 338
Day 339
Day 340
Day 341
Day 342
Day 343
Day 344
Day 345
Day 346
Day 347
Day 348
Day 349
Day 350
Day 351
Day 352
Day 353
Day 354
Day 355
Day 356
Day 357
Day 358
Day 359
Day 360
Day 361
Day 362
Day 363
Day 364
Day 365
Spreadsheet: 55374d1255504004-vmarkup-help-book1
Sheet: Sheet1

Student Name | Course Code | Course Name | Date Course Commences | Date Paid | Course Fee | DaysPaidInAdvance
[NAME] | 40748 | Bookkeeping | 2009-09-09 00:00:00 | 2009-09-01 00:00:00 | 395 | 8
[NAME] | 43255 | Time Management | 2009-09-12 00:00:00 | 2009-09-11 00:00:00 | 250 | 1
[NAME] | 40847 | Office/Reception Skills | 2009-09-15 00:00:00 | 2009-08-31 00:00:00 | 300 | 15
[NAME] | 40288 | Workplace Assessment | 2009-09-01 00:00:00 | 2009-08-05 00:00:00 | 690 | 27
[NAME] | 40748 | Bookkeeping | 2009-09-09 00:00:00 | 2009-08-31 00:00:00 | 395 | 9
[NAME] | 40847 | Office/Reception Skills | 2009-09-15 00:00:00 | 2009-08-20 00:00:00 | 300 | 25
Spreadsheet: 1e06dc08-476e-47bc-a6d1-312c2a510b41
Sheet: Summary budget

ModId |  | Allocation | P1 | Above | P2 | Total / Full | P3
 |  |  |  |  |  |  |  |  | Row Labels | Alloc | Alloc % | Abv | Abv % | Full req | Full %
 |  |  |  |  |  |  |  |  | Grand Total
 |  |  |  |  |  |  |  |  | Row Labels | Yr 1 | Yr 2 | Yr 3 | Yr 4 | Yr 5 | Tot
 |  |  |  |  |  |  |  |  | Allocation | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Above | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Grand Total | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Row Labels | Alloc | Allocation % | Above alloc | Above % | Full request | Full %
 |  |  |  |  |  |  |  |  | Grand Total
 | Principal Recipient | Allocation | P1 | Above | P2 | Total / Full | P3
 | Allocation or above | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Total
Spreadsheet: 101366d1299516439-merging-two-excel-sheet-with-a-common-variable-consolidatedscores2
Sheet: Sheet1

Test# | ID | Score
Test1 | 312000 | 3
Test1 | 33098 | 2 |  | Sum of Score | Column Labels
Test1 | 33456 | 2 |  | Row Labels | Test1 | Test2 | Test3 | Grand Total
Test2 | 31201 | 4 |  | 31201 |  | 4 | 4 | 8
Test2 | 33098 | 2 |  | 33098 | 2 | 2 | 2 | 6
Test2 | 33456 | 2 |  | 33456 | 2 | 2 |  | 4
Test3 | 312000 | 3 |  | 312000 | 3 |  | 3 | 6
Test3 | 31201 | 4 |  | Grand Total | 7 | 8 | 9 | 24
Test3 | 33098 | 2
Spreadsheet: 40670d1239063961-excel-2007-plotting-date-ranges-on-same-graph-excell_trying_to_do
Sheet: Sheet1

Position | Name | [NAME] | Departure | Extend?
CEO | [NAME] | 2009-01-01 00:00:00 | 2010-12-30 00:00:00
Admin # 1 | [NAME] | 2009-01-01 00:00:00 | 2009-07-30 00:00:00 | 2009-09-30 00:00:00
Admin # 1 Replacement | [NAME] | 2009-09-04 00:00:00 | 2010-12-30 00:00:00
Admin # 2 | [NAME] | 2009-02-04 00:00:00 | 2010-12-30 00:00:00
Sales Rep # 1 | [NAME] | 2009-01-01 00:00:00 | 2009-09-30 00:00:00
Sales Rep # 1 Replacement | [NAME] | 2009-09-15 00:00:00 | 2010-12-30 00:00:00
Sales Rep # 2 | [NAME] | 2009-01-01 00:00:00 | 2010-02-28 00:00:00 | 2010-03-30 00:00:00
Sales Rep # 2 Replacement | [NAME] | 2010-04-01 00:00:00 | 2010-12-30 00:00:00
I'm trying to take data like the above, and make it into a chart like the below.
If I can't get the overlap, I think he'll settle for the line by line version:
Spreadsheet: 760531d1640272447-vlookup-error-with-duplications-email-database-list
Sheet: Base Pay

Last Name | First Name | Reason | Hours | Approved Hours | Amount | Approved Amount | Pay Period | Notes
Spreadsheet: 126654d1319808915-countifs-with-table-references-not-working-vactest
Sheet: Sheet1

Column1 | 10/31 | 11/1 | 11/2 | 11/3 | 11/4 | 11/5 | 11/6 | 11/7 | 11/8 | 11/9 | 11/10 | 11/11 | 11/12 | 11/13 | 11/14 | 11/15 | 11/16 | 11/17 | 11/18 | 11/19 | 11/20 | 11/21 | 11/22 | 11/23 | 11/24 | 11/25 | 11/26 | 11/27 | 11/28 | 11/29 | 11/30 | 12/1 | 12/2 | 12/3 | 12/4 | 12/5 | 12/6 | 12/7 | 12/8 | 12/9 | 12/10 | 12/11 | 12/12 | 12/13 | 12/14 | 12/15 | 12/16 | 12/17 | 12/18 | 12/19 | 12/20 | 12/21 | 12/22 | 12/23 | 12/24 | 12/25 | 12/26 | 12/27 | 12/28 | 12/29 | 12/30 | 12/31 | 1/1 | 1/2 | Count
Person1 |  |  |  |  | x |  |  |  |  |  |  | x |  |  |  |  |  |  | x |  |  | x | x | x |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  | x |  |  |  |  |  |  | x |  |  | x |  |  |  | x |  |  |  | x | x | x | x
Person2 |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  | x | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x | x |  |  |  | x | x | x | p
Person3
Person4
Person5
Person6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x | x
Person7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x | x |  |  |  |  |  |  | x
Person8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x |  |  | x
Person9
Full day | x
Morning off | a
Afternoon off | p
Spreadsheet: 268780d1380822540-offset-lookup-example-worksheet-1-
Sheet: Sheet1

Zone 1 | Zone 2 | Zone 3 | Zone 4 | Final Zone
12 | 7 | 0 | 0
7 | 7 | 0 | 0
6 | 12 | 0 | 0
6 | 12 | 0 | 0
15 | 6 | 0 | 0
15 | 6 | 0 | 0
7 | 7 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
8 | 7 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
6 | 1 | 1 | 0
6 | 1 | 0 | 0
6 | 1 | 0 | 0
8 | 7 | 0 | 0
6 | 1 | 0 | 0
6 | 1 | 0 | 0
12 | 7 | 0 | 0
2 | 6 | 0 | 0
2 | 12 | 0 | 0
2 | 11 | 0 | 0
2 | 6 | 0 | 0
2 | 12 | 0 | 0
2 | 12 | 0 | 0
2 | 2 | 6 | 0
2 | 6 | 0 | 0
2 | 6 | 0 | 0
12 | 7 | 0 | 0
8 | 8 | 0 | 0
8 | 8 | 0 | 0
8 | 8 | 0 | 0
8 | 8 | 0 | 0
1 | 6 | 0 | 0
8 | 8 | 0 | 0
8 | 8 | 0 | 0
1 | 13 | 0 | 6
1 | 13 | 6 | 0
1 | 13 | 0 | 0
8 | 8 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
13 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 13 | 6 | 0
1 | 13 | 0 | 6
1 | 13 | 6 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
2 | 6 | 0 | 0
2 | 14 | 0 | 0
2 | 8 | 0 | 0
Spreadsheet: 471042d1468849898-i-need-an-excel-formula-that-will-show-negative-in-the-variance-line-if-actual-is-zero-copy-of-excel-formula
Sheet: Sheet1

 |  |  | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00
 |  | plan | 25 | 30 | 35 | 40 | 45 | 50 | 60 | 70 | 80 | 105 | 120 | 130
 |  | actual
 |  | variance
Spreadsheet: sally_beck__33987__MgmtSum-Q201-Global-0412
Sheet: YTD Mgmt Summary

ENRON GLOBAL MARKETS
2001 EARNINGS ESTIMATE
2nd QUARTER YTD
 |  | Plan |  |  |  | Components of Earnings Before Tax |  |  |  |  |  |  |  |  |  | Variances from Plan
 |  |  |  |  |  | Actual | Deals | Forecast | Total | Operating | Capital | Direct | Allocated |  |  | Total | Operating | Capital | Direct | Allocated
Business Team |  | Margin | Expenses(1) | EBT |  | Margin | Identified | Margin | Margin | Expenses | Charge | Expenses | Expenses | Total |  | Margin | Expenses | Charge | Expenses | Expenses | Total
Crude & Products
Coal
Vessel Trading
Emissions
Weather
Global Risk Markets
Financial Trading
Freight Markets
LNG
Middle East (1Q01 only)
Puerto Rico
Finance and Structuring
Office of the Chairman
Total Commercial
Group Support Cost
Support Cost Allocated to Teams
Other Interest Related Charges
Capital Charge Offset
Global Markets EBIT
 |  |  |  |  |  | Other Expenses:
Interest Expense/(Income)
Global Markets Pre-tax Income
 |  |  |  | MPR Change:
(1) Includes capital charge, direct, and allocated expenses
Spreadsheet: 880264d1727887026-rolling-count-of-all-the-overlapping-days-for-multiple-date-ranges-new-example
Sheet: Sheet1

Record | Start Date | End Date | Duration (Days) | Expected | Wind | Let
1 | 2023-01-03 00:00:00 | 2023-01-11 00:00:00 |  | 13 |  |  |  | Column F
2 | 2023-01-06 00:00:00 | 2023-01-20 00:00:00 |  | 22 | 22
3 | 2023-01-21 00:00:00 | 2023-01-21 00:00:00 |  | 23 | 22 |  |  | Column G
4 | 2023-01-22 00:00:00 | 2023-01-22 00:00:00 |  | 24 | 22
5 | 2023-02-10 00:00:00 | 2023-02-10 00:00:00 |  | 12 | 9
6 | 2023-02-25 00:00:00 | 2023-03-03 00:00:00 |  | 7 | 8
7 | 2023-03-01 00:00:00 | 2023-03-11 00:00:00 |  | 17 | 17
8 | 2023-03-04 00:00:00 | 2023-03-05 00:00:00 |  | 12 | 11
9 | 2023-03-20 00:00:00 | 2023-03-20 00:00:00 |  | 18 | 17
10 | 2023-04-01 00:00:00 | 2023-04-05 00:00:00 |  | 10 | 9
Spreadsheet: 757929d1638538671-conditional-formatting-for-difference-greater-or-less-than-5-samplecf
Sheet: Sheet1

 |  |  |  | Manual Example
Overall Performance |  |  |  | Overall Performance |  |  | Overall Performance |  |  | Overall Performance
Actual | Target |  |  | Actual | Target |  | Actual | Target |  | Actual | Target
0.89 | 0.95 |  |  | 0.9 | 0.95 |  | 0.95 | 0.95 |  | 1 | 0.95
Spreadsheet: 714408d1611220803-sort-out-the-trades-in-sequence-test50
Sheet: Sheet2

Trade Number | Date Iniated | Date Terminated | Buy Price | Sell Price | Profit/loss | Period Held in days
Number of Trades Won |  | 2
Number of Trades Lost |  | 1
Spreadsheet: 861537d1709407164-mark-up-percentage-reducing-as-price-increases-book1
Sheet: Sheet1

 |  | 0.01 | 0.0001
 |  | Net Cost | Mark Up | Net Sell
 |  | 120 |  | 420 |  | 250% is the [NAME] markup. What Im trying to do is when I type the net cost in, it automatically reduces the mark up.
 |  | 121
 |  | 122
 |  | 123
 |  | 124
 |  | 125
 |  | 126
 |  | 127
 |  | 128
 |  | 129
 |  | 130
 |  | 131
 |  | 132
 |  | 133
 |  | 134
 |  | 135
 |  | 136
 |  | 137
 |  | 138
 |  | 139
 |  | 140
 |  | 141
 |  | 142
 |  | 143
 |  | 144
 |  | 145
 |  | 146
 |  | 147
 |  | 148
 |  | 149
 |  | 150
 |  | 151
 |  | 152
 |  | 153
 |  | 154
 |  | 155
 |  | 156
 |  | 157
 |  | 158
 |  | 159
 |  | 160
 |  | 161
 |  | 162
 |  | 163
 |  | 164
 |  | 165
 |  | 166
 |  | 167
 |  | 168
 |  | 169
 |  | 170
 |  | 171
 |  | 172
 |  | 173
 |  | 174
 |  | 175
 |  | 176
 |  | 177
 |  | 178
 |  | 179
 |  | 180
 |  | 181
 |  | 182
 |  | 183
 |  | 184
 |  | 185
 |  | 186
 |  | 187
 |  | 188
 |  | 189
 |  | 190
 |  | 191
 |  | 192
 |  | 193
 |  | 194
 |  | 195
 |  | 196
 |  | 197
 |  | 198
 |  | 199
 |  | 200
 |  | 201
 |  | 202
 |  | 203
 |  | 204
 |  | 205
 |  | 206
 |  | 207
 |  | 208
 |  | 209
 |  | 210
 |  | 211
 |  | 212
 |  | 213
 |  | 214
 |  | 215
 |  | 216
 |  | 217
 |  | 218
 |  | 219
 |  | 220
Spreadsheet: 65554d1266280831-need-function-to-display-details-of-id-number-name-price-etc-task1
Sheet: Task1 (P2)

 | Code | [NAME] | Supplier | Type | Wholesale Price | Sale Price | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  |  | Data Types | Fireplace Type
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stone
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Marble
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Limestone
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yorkstone
Spreadsheet: 819151d1677247392-auto-calculation-formula-help-excel-forum-sample-ot
Sheet: Sheet1

DATA |  |  |  |  | This information will be hidden, as the President does not want anyone seeing this top level of info showing individual salary.  Is there a way to take the information in this first set of data to automatically populate down below by using a drop box solution?  More information below
Name | Salary | OT Hourly Rate | Effective
[NAME] |  |  | 2023-01-01 00:00:00
[NAME] | 50000 |  | 2023-01-01 00:00:00
[NAME] | 75000 |  | 2023-01-01 00:00:00
[NAME] | 87000 |  | 2023-01-01 00:00:00
[NAME] | 82000 |  | 2023-01-01 00:00:00
STANDARD | OVERNIGHT | 25 | 2023-01-01 00:00:00
DATA
Week Beginning | Name | OT Hours | OT Payment | # [NAME] | ON Amount | Total | Payout Date | Comments
2023-02-13 00:00:00 | [NAME] | 5 |  | 5 |  |  | [NAME] | [NAME]
2023-02-13 00:00:00 | [NAME]
2023-02-13 00:00:00 | [NAME]
Spreadsheet: 772809d1647469091-combining-vlookup-and-counta-functions-in-a-single-formula-excel-formulas-bvj-
Sheet: ClosingStockPrices

F:\My Documents\.. Investments\[Excel Formulas.xlsx]ClosingStockPrices |  | 2
[NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Stocks                                                     (Yellow = Own) | Symbol | 2022-02-01 00:00:00 | 2022-02-02 00:00:00 | 2022-02-03 00:00:00 | 2022-02-04 00:00:00 | 2022-02-07 00:00:00 | 2022-02-08 00:00:00 | 2022-02-09 00:00:00 | 2022-02-10 00:00:00 | 2022-02-11 00:00:00 | 2022-02-14 00:00:00 | 2022-02-15 00:00:00 | 2022-02-16 00:00:00 | 2022-02-17 00:00:00 | 2022-02-18 00:00:00 | 2022-02-22 00:00:00 | 2022-02-23 00:00:00 | 2022-02-24 00:00:00 | 2022-02-25 00:00:00 | 2022-02-28 00:00:00 | 2022-03-01 00:00:00 | 2022-03-02 00:00:00 | 2022-03-03 00:00:00 | 2022-03-04 00:00:00 | 2022-03-07 00:00:00 | 2022-03-08 00:00:00 | 2022-03-09 00:00:00 | 2022-03-10 00:00:00 | 2022-03-11 00:00:00 | 2022-03-12 00:00:00 | 2022-03-13 00:00:00 | 2022-03-14 00:00:00 | 2022-03-15 00:00:00 | 2022-03-16 00:00:00
Allegheny Technologies Inc (0) | ATI | 18.809999 | 22.02 | 22.459999 | 22.709999 | 22.940001 | 23.540001 | 23.860001 | 23.57 | 23.99 | 23.89 | 23.93 | 24.2 | 24.7 | 23.97 | 23.88 | 23.68 | 23.77 | 25.46 | 25.74 | 25.46 | 26.49 | 26.16 | 26.05 | 26.48 | 26 | 25.67 | 26.98 | 26.77 | 26.7053333333333 | 26.8008484848485 | 26.8963636363636 | 26.9918787878788 | 27.0873939393939
Chevron Corporation Common Stock (4) | CVX | 134.789993 | 135.410004 | 134.199997 | 135.880005 | 139.05 | 136.43 | 137.79 | 136.02 | 139.48 | 136.9 | 134.35 | 134.36 | 133.65 | 133.28 | 132.39 | 135.59 | 134.69 | 139.9 | 143.9 | 149.75 | 154.14 | 156.27 | 158.65 | 161.45 | 165.85 | 166.26 | 170.8 | 169.94 | 163.129285888889 | 164.425960780241 | 165.722635671593 | 167.019310562945 | 168.315985454297
Spreadsheet: 1b573a12-19f9-4388-97db-2c4cd7ae7f60
Sheet: Sheet1

City Officials Statements | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
For Quarter Ending 12/31/2009
(As of 2/11/2010)
Name | Title | Personal Benefits Reported | City Benefits Reported
Adams, Sam | Mayor | 1615
Ames, [NAME] | At-will staff for Mayor [NAME]
Birge, [NAME] | At-will staff for Mayor [NAME] |  | 100
Callahan, Shannon | At-will staff for Commissioner Saltzman | 50
[NAME], [NAME] | At-will staff for Mayor [NAME]
Todd, [NAME] | At-will staff for Mayor [NAME]
Fish, [NAME] | Commissioner | 121.2 | 224.95
Fritz, Amanda | Commissioner
Gonzales, Cevero | At-will staff for Mayor [NAME]
Griffin-Valade | City Auditor
Hanson, [NAME] | Portland Planning Commission Member
Jimenez, [NAME] | At-will staff for Mayor [NAME]
[NAME], [NAME] | At-will staff for Mayor [NAME]
[NAME], [NAME] | Director of Bureau of Fire, Rescue and Emergency Services
Lauer, [NAME] | At-will staff for Mayor [NAME]
Leonard, [NAME] | Commissioner
[NAME], [NAME] | At-will staff for Mayor [NAME]
Lord II, Reese | At-will staff for Mayor [NAME]
Marriott, [NAME] | Director of Bureau of Environmental Services
[NAME], [NAME] | At-will staff for Mayor [NAME] | 1545
Neal, Clay | At-will staff for Mayor [NAME]
[NAME], Skip | At-will staff for Mayor [NAME]
Oppenheim, [NAME] | At-will staff for Mayor [NAME]
[NAME], [NAME] | At-will staff for Mayor [NAME]
Ponder, [NAME] | At-will staff for Mayor [NAME]
[NAME], [NAME] | At-will staff for Mayor [NAME]
Ruiz, [NAME] | At-will staff for Mayor [NAME]
Saltzman, [NAME] | Commissioner | 270
[NAME], [NAME] | Director of Bureau of Development Services
Schneider, Kimberly | At-will staff for Mayor [NAME]
[NAME], [NAME] | At-will staff for Mayor [NAME] | 50 | Yes, No Values Provided
[NAME], [NAME] | Director of Bureau of Police | 140
[NAME], [NAME] | At-will staff for Mayor [NAME]
Stringfield, Sierra | At-will staff for Mayor [NAME]
Uwagbae, Grace | At-will staff for Mayor [NAME]
Yocom, [NAME] | At-will staff for Mayor [NAME]
Spreadsheet: 708521d1607904155-converting-numbers-to-dd-hh-mm-hunter-tactics-cheat-sheet
Sheet: Hunter Tactics

15000000 | HF 1-7 | HF 8-10 | HF 11-14 | HF 15-21 | HF 22-28 | HF 29-34 | HF 35-45
Points for HF | 3000 | 4500 | 6000 | 9000 | 12000 | 15000 | 18000
Stam Cost
Total # Needed to Do
Total # Each Member has to do/join
Members in Alliance | 65
Stam Reduction
 | 20 | 25 | 25 | 30 | 35 | 40 | 40
Spreadsheet: frank_ermis__11206__HS_WESTminusPA1115
Sheet: Run Query

Daily Hedge Strip
User ID:
Password:
Included Deals | ALL
Today
Days in Month | 30
Day of Month |  | 2001-11-15 00:00:00 | Update this cell daily
PromptMonth | 2001-12-01 00:00:00 | 2001-12-31 00:00:00
StartRange | D4
Enter EASTMEX Date:
[NAME] | NXB2 | NX1
2001-11-26 00:00:00 | 2001-11-27 00:00:00 | 2001-11-28 00:00:00
Please Note:  Once the 'RUN ' button has been pressed, please do not disturb Excel.  Doing so will make you a bad person.
Book Type | Book
Type
D | ENA-FT-WC-CAL-BAS
D | ENA-FT-WT-CAL-BAS
D | ENA-FT-WC-ROX-BAS
D | MGMT-WEST-BAS
D | FT-PGE-BAS
D | ENA-FT-WT-SJ-BAS
D | ENA-FT-WC-SJ-BAS
D | ENA-FT-WT-ROX-BAS
D | FT-DENVER-BAS
D | FT-REGS-BAS
D | ENA-FT-WT-SOCAL-BAS
D | FT-WEST-OPT-BAS
D | ENA-FT-WC-SOCAL-BAS
D | ENA-FT-WC-NOCAL-BAS
DO | FT-NW-XL-OPT-BAS
DO | FT-WE-XL-OPT-BAS
DO | MGMT-WE-XL-OPT-BAS
DO | GD-NEW-XL-OPT-BAS
DO | FT-XL-WC-ROX-BAS
D | TRANS-WEST-BAS
D | LT-TRANS-WE-BAS
M | ENA-FT-WC-CAL-GDL
M | ENA-FT-WT-CAL-GDL
M | ENA-FT-WC-ROX-GDL
M | MGMT-WEST-GDL
M | FT-PGE-GDL
M | ENA-FT-WT-SJ-GDL
M | ENA-FT-WC-SJ-GDL
M | ENA-FT-WT-ROX-GDL
M | FT-DENVER-GDL
M | FT-REGS-GDL
M | ENA-FT-WT-SOCAL-GDL
M | ENA-FT-WT-SCAN-GDL
M | ENA-FT-WC-SOCAL-GDL
M | ENA-FT-WC-NOCAL-GDL
PHY | ENA-IM-WC-CAL-PHY
PHY | ENA-IM-WT-CAL-PHY
PHY | ENA-IM-WC-ROX-PHY
PHY | MGMT-WEST-PHY
PHY | ENA-IM-WT-SJ-PHY
PHY | ENA-IM-WC-SJ-PHY
PHY | ENA-IM-WT-ROX-PHY
PHY | INTRA-DENVER-PHY
PHY | ENA-FT-WT-SOCAL-PHY
PHY | ENA-FT-WC-SOCAL-PHY
PHY | ENA-FT-WC-NOCAL-PHY
I | ENA-FT-WC-CAL-IDX
I | ENA-FT-WT-CAL-IDX
I | ENA-FT-WC-ROX-IDX
I | MGMT-WEST-IDX
I | FT-PGE-IDX
I | ENA-FT-WT-SJ-IDX
I | ENA-FT-WC-SJ-IDX
I | ENA-FT-WT-ROX-IDX
I | FT-DENVER-IDX
I | FT-REGS-IDX
I | ENA-FT-WT-SOCAL-IDX
I | ENA-FT-WC-SOCAL-IDX
I | ENA-FT-WC-NOCAL-IDX
Y | ENA-FT-WC-CAL-GDI
Y | ENA-FT-WT-CAL-GDI
Y | ENA-FT-WC-ROX-GDI
Y | MGMT-WEST-GDI
Y | FT-PGE-GDI
Y | ENA-FT-WT-SJ-GDI
Y | ENA-FT-WC-SJ-GDI
Y | ENA-FT-WT-ROX-GDI
Y | FT-DENVER-GDI
Y | FT-REGS-GDI
Y | ENA-FT-WT-SOCAL-GDI
Y | ENA-FT-WC-SOCAL-GDI
Y | ENA-FT-WC-NOCAL-GDI