tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 43844d1242457982-problem-with-formula-that-is-supposed-to-lookup-and-return-multiple-values-683918_ptg
Sheet: Sheet1

 |  |  |  |  | Key | Project Number | Employee | Pay Period
 |  |  |  |  | 0 | 0001 | [NAME] | 1
 | Project Number: |  | 0002 | 6 | 0 | 0001 | [NAME] | 2
 |  |  |  |  | 0 | 0001 | [NAME] | 1
 |  | Employee |  |  | 0 | 0001 | [NAME] | 2
 |  |  |  |  | 0 | 0001 | Mark | 1
 |  | [NAME] |  |  | 1 | 0002 | [NAME] | 1 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 2
 |  | [NAME] |  |  | 1 | 0002 | [NAME] | 2
 |  | [NAME] |  |  | 2 | 0002 | [NAME] | 1
 |  | [NAME] |  |  | 2 | 0002 | [NAME] | 2
 |  | [NAME] |  |  | 3 | 0002 | [NAME] | 1
 |  | [NAME] |  |  | 3 | 0002 | [NAME] | 2
 |  |  |  |  | 4 | 0002 | [NAME] | 1
 |  |  | ? |  | 4 | 0002 | [NAME] | 2
 |  |  | ? |  | 5 | 0002 | [NAME] | 1
 |  |  | ? |  | 5 | 0002 | [NAME] | 2
 |  |  | ? |  | 6 | 0002 | [NAME] | 1
 |  |  |  |  | 0 | 0003 | Fred | 1
 |  |  |  |  | 0 | 0003 | Fred | 2
 |  |  |  |  | 0 | 0003 | Sara | 1
 |  |  |  |  | 0 | 0003 | Jan | 1
 |  | 1.  Where's [NAME] and [NAME]? |  |  | 0 | 0004 | [NAME] | 1
 |  | 2.  I don't want the duplicate names |  |  | 0 | 0004 | [NAME] | 2
 |  |  |  |  | 0 | 0004 | [NAME] | 1
 |  |  |  |  | 0 | 0004 | [NAME] | 2
 |  |  |  |  | 0 | 0005 | [NAME] | 1
 |  |  |  |  | 0 | 0005 | [NAME] | 2
 |  |  |  |  | 0 | 0005 | [NAME] | 1
 |  |  |  |  | 0 | 0005 | [NAME] | 2
 |  |  |  |  | 0 | 0005 | [NAME] | 1
 |  |  |  |  | 0 | 0005 | [NAME] | 2
 |  |  |  |  | 0 | 0005 | [NAME] | 1
 |  |  |  |  | 0 | 0005 | [NAME] | 1
 |  |  |  |  | 0 | 0005 | [NAME] | 2
 |  |  |  |  | 0 | 0005 | Cathy | 1
 |  |  |  |  | 0 | 0005 | [NAME] | 1
 |  |  |  |  | 0 | 0005 | [NAME] | 2
 |  |  |  |  | 0 | 0006 | [NAME] | 1
 |  |  |  |  | 0 | 0006 | [NAME] | 2
 |  |  |  |  | 0 | 0006 | [NAME] | 1
 |  |  |  |  | 0 | 0006 | [NAME] | 2
 |  |  |  |  | 0 | 0007 | [NAME] | 1
 |  |  |  |  | 0 | 0007 | [NAME] | 2
 |  |  |  |  | 0 | 0007 | [NAME] | 1
 |  |  |  |  | 0 | 0007 | [NAME] | 2
 |  |  |  |  | 0 | 0007 | [NAME] | 2
 |  |  |  |  | 0 | 0007 | [NAME] | 2
 |  |  |  |  | 0 | 0007 | [NAME] | 2
Spreadsheet: 855267d1704898277-how-to-change-date-format-how-to-change-date-format
Sheet: Sheet1

ID | Date | Time | Type
 | 2023-01-11 00:00:00 | 08:41:32 | -
 | 2023-01-11 00:00:00 | 18:07:26 | -
 | 2023-02-11 00:00:00 | 12:00:00 | Proxy
 | 2023-02-11 00:00:00 | 16:00:00 | Proxy
 | 2023-03-11 00:00:00 | 08:35:09 | -
 | 2023-03-11 00:00:00 | 17:19:07 | -
 | 2023-04-11 00:00:00 | 12:38:17 | -
 | 2023-04-11 00:00:00 | 15:35:24 | -
Spreadsheet: kate_symes__18650__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-02-15 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160
 | 2001-02-14 00:00:00 |  | 327.05 | 15664 | 314.82 | 3928 | 479.05 | 452 | 472.12 | 165
 | 2001-02-13 00:00:00 |  | 335.68 | 13424 | 322.6 | 4728 | 386.38 | 1053 | 330 | 0
 | 2001-02-12 00:00:00 |  | 302.64 | 12624 | 279.2 | 4528 | 271.84 | 1346 | 324.32 | 544
 | 2001-02-11 00:00:00 |  | 285 | 0 | 270 | 0 | 312.37 | 316 | 326.04 | 96 |  | 278.81 | 12600
 | 2001-02-10 00:00:00 |  | 276.16 | 15824 | 238.78 | 3328 | 322.06 | 790 | 309.3 | 328
 | 2001-02-09 00:00:00 |  | 276.16 | 15824 | 238.78 | 3328 | 341.87 | 3340 | 307.19 | 1050
 | 2001-02-08 00:00:00 |  | 381.43 | 15120 | 316.79 | 3376 | 341.12 | 2521 | 320.97 | 373
 | 2001-02-07 00:00:00 |  | 274.49 | 8688 | 253.14 | 4024 | 294.97 | 2143 | 251.02 | 216
 | 2001-02-06 00:00:00 |  | 213.71 | 10784 | 195.79 | 4096 | 259.92 | 63 | 196.16 | 307
 | 2001-02-05 00:00:00 |  | 200.43 | 11824 | 196.63 | 3968 | 204.52 | 1904 | 179.61 | 727
 | 2001-02-04 00:00:00 |  | 200 | 0 | 185 | 0 | 181.95 | 1513 | 175.11 | 1100 |  | 196.25 | 10704
 | 2001-02-03 00:00:00 |  | 222.8 | 15824 | 195.9 | 7648 | 185 | 35 | 199.94 | 233
 | 2001-02-02 00:00:00 |  | 222.8 | 15824 | 195.9 | 7648 | 203.95 | 380 | 200 | 48
 | 2001-02-01 00:00:00 |  | 355.71 | 7984 | 306.05 | 3728 | 255.73 | 1202 | 198.09 | 315
 | 2001-01-31 00:00:00 |  | 409.15 | 12656 | 342.56 | 3280 | 313.68 | 3766 | 275 | 70
 | 2001-01-30 00:00:00 |  | 468.99 | 11456 | 403.48 | 2872 | 383.47 | 304 | 351 | 25
 | 2001-01-29 00:00:00 |  | 420.48 | 19824 | 407.62 | 3832 | 383.33 | 4070 | 304.86 | 1442
 | 2001-01-28 00:00:00 |  | 450 | 800 | 350 | 0 | 488.38 | 355 | 460.46 | 416 |  | 408.68 | 12240
 | 2001-01-27 00:00:00 |  | 294.85 | 19024 | 254.41 | 4032 | 456.54 | 845 | 457.01 | 236
 | 2001-01-26 00:00:00 |  | 295.64 | 17424 | 254.65 | 3832 | 369.4 | 402 | 350 | 75
 | 2001-01-25 00:00:00 |  | 319.38 | 15024 | 295.88 | 1272 | 296.66 | 437 | 234.61 | 965
 | 2001-01-24 00:00:00 |  | 307.59 | 18224 | 261.91 | 2872 | 290.03 | 291 | 291.18 | 807
 | 2001-01-23 00:00:00 |  | 329.11 | 18624 | 254.24 | 4712 | 309.54 | 1107 | 305 | 200
 | 2001-01-22 00:00:00 |  | 393.64 | 26784 | 333.06 | 3312 | 351.61 | 465 | 314.65 | 1500
 | 2001-01-21 00:00:00 |  | 300 | 800 | 337.5 | 0 | 367 | 625 | 318.16 | 435 |  | 335.88 | 8736
 | 2001-01-20 00:00:00 |  | 559.4 | 25088 | 411.6 | 8344 | 362.89 | 291 | 286.58 | 300
 | 2001-01-19 00:00:00 |  | 559.4 | 25088 | 411.6 | 8344 | 376.11 | 836 | 283.47 | 546
 | 2001-01-18 00:00:00 |  | 481.44 | 21424 | 392.14 | 5112 | 454.07 | 393 | 294.21 | 380
 | 2001-01-17 00:00:00 |  | 272.66 | 29824 | 248.16 | 6312 | 428.17 | 196 | 285.3 | 495
 | 2001-01-16 00:00:00 |  | 179.29 | 23760 | 158.21 | 3800 | 422.32 | 6337 | 190 | 50
 |  |  |  |  |  | ..
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: 2Replace Costs-Results 6-10

Table 5.2.14.  Replacement Costs (Years 6 to 10)
 |  |  |  | EPA Discount Rate:
 |  |  |  | Present Value of Replacement Costs in Year:
Component | Unit Cost | Unit | Quantity | 6 | 7 | 8 | 9 | 10
 |  |  | Total Present Value of Replacement Costs (Years 6 to 10):
Spreadsheet: 703442d1605005407-vlookup-across-multiple-sheets-kupac-grupa-u-izradi_etaf
Sheet: jan

Skladište : 001            Naziv : VELEPRODAJNO SKLADIŠTE
code | group | Naziv |  |  | Artikli
4 |  | x |  |  | 27124.06
a | b | TECEdrainline |  |  | 130.43
4 | 607 | TECEdrainpoint S |  |  | 1241.29
4 | 770 | TECEfloor |  |  | 11795.56
4 | 904 | TECEaktivacijske tipke |  |  | 7822.83
4 | 905 | TECEprofil-ispirna tehnika |  |  | 20.65
4 | 910 | TECEbase |  |  | 6113.3
8 |  | z |  |  | 31121.24
8 | 600 | TECEdrainline |  |  | 6373.79
8 | 607 | TECEdrainpoint S |  |  | 1261.94
8 | 700 | TECEflex |  |  | 8608.65
8 | 770 | TECEfloor |  |  | 4452
8 | 820 | TECElogo |  |  | 545.06
8 | 900 | TECEprofil |  |  | 2916.98
8 | 904 | TECEaktivacijske tipke |  |  | 2088.54
8 | 905 | TECEprofil-ispirna tehnika |  |  | 2284.28
8 | 910 | TECEbase |  |  | 2590
4 | 100 |  |  |  | wayne
Spreadsheet: 127675d1320463123-lookup-a-value-leave-table
Sheet: Table

 |  |  |  | Name | Type | Date from | Date to | 2011-05-11 00:00:00 | 2011-05-12 00:00:00 | 2011-05-13 00:00:00 | 2011-05-14 00:00:00 | 2011-05-15 00:00:00 | 2011-05-16 00:00:00 | 2011-05-17 00:00:00
 |  |  |  | [NAME] | LL | 2011-05-15 00:00:00 | 2011-05-17 00:00:00 |  |  |  |  | LL | LL | LL
 |  |  |  | [NAME] | DD | 2011-05-11 00:00:00 | 2011-05-12 00:00:00 | DD | DD
 |  |  |  | [NAME] | LL | 2011-05-12 00:00:00 | 2011-05-14 00:00:00 |  | LL | LL | LL
 |  |  |  | pat | AA | 2011-05-13 00:00:00 | 2011-05-17 00:00:00 |  |  | AA | AA | AA | AA | AA
 |  |  |  | mary | LL | 2011-05-10 00:00:00 | 2011-05-16 00:00:00 | LL | LL | LL | LL | LL | LL
 |  |  |  | [NAME] | LL | 2011-06-12 00:00:00 | 2011-06-15 00:00:00
 |  |  |  | [NAME] | DD | 2011-06-14 00:00:00 | 2011-06-17 00:00:00
 |  |  |  | [NAME] | DD | 2011-07-21 00:00:00 | 2011-07-25 00:00:00
 |  |  |  | [NAME] | AA | 2011-05-14 00:00:00 | 2011-06-19 00:00:00 |  |  |  | AA | AA | AA | AA
 |  |  |  | pat | LL | 2011-05-22 00:00:00 | 2011-05-25 00:00:00
 |  |  |  | mary | DD | 2011-09-14 00:00:00 | 2011-09-17 00:00:00
 |  |  |  | [NAME] | AA | 2011-03-21 00:00:00 | 2011-03-25 00:00:00
 |  |  |  | [NAME] | AA | 2011-04-04 00:00:00 | 2011-04-07 00:00:00
 |  |  |  | pat | LL | 2011-05-05 00:00:00 | 2011-05-08 00:00:00
 |  |  |  | [NAME] | DD | 2011-01-07 00:00:00 | 2011-01-10 00:00:00
Spreadsheet: 695870d1600435446-getting-last-row-value-with-index-match-match-offset_value
Sheet: Sheet1

 | Identifier1 |  | Identifier2 |  | Identifier3 |  | Identifier4 |  | Identifier5
 |  | Attribute1 |  | Attribute2 |  | Attribute3 |  | Attribute4 |  | Attribute5
Source1 |  | 1 |  | 4 |  | 7 |  | 10 |  | 13
Source2 |  | 2 |  | 5 |  | 8 |  | 11 |  | 14
Source3 |  | 3 |  | 6 |  | 9 |  | 12 |  | 15
This is a little tricky to explain but.. [NAME] columns are not always the same, and the identifiers are not always on the same row. Need to scan for example Identifier3's position (currently row 1, column F), add +1 column and get value on lowest row (9). This format is stupid but I cannot change it and have to work with it.
Solution: |  |  |  |  |  |  |  |  |  |  |  | Search term:
Spreadsheet: 238589d1369638238-pulling-data-from-one-spread-sheet-into-another-retrieve-last-20-dates-of-data2
Sheet: Sheet2

Date | Data
2013-08-13 00:00:00 | 80 |  |  |  |  | http://www.excelforum.com/excel-general/926247-pulling-data-from-one-spread-sheet-into-another.html
2013-08-12 00:00:00 | 11
2013-08-11 00:00:00 | 66
2013-08-10 00:00:00 | 37
2013-08-09 00:00:00 | 52
2013-08-08 00:00:00 | 21
2013-08-07 00:00:00 | 40
2013-08-06 00:00:00 | 14
2013-08-05 00:00:00 | 9
2013-08-04 00:00:00 | 86
2013-08-03 00:00:00 | 3
2013-08-02 00:00:00 | 99
2013-08-01 00:00:00 | 62
2013-07-31 00:00:00 | 79
2013-07-30 00:00:00 | 89
2013-07-29 00:00:00 | 88
2013-07-28 00:00:00 | 16
2013-07-27 00:00:00 | 55
2013-07-26 00:00:00 | 38
2013-07-25 00:00:00 | 40
2013-07-24 00:00:00 | 18
2013-07-23 00:00:00 | 86
2013-07-22 00:00:00 | 23
2013-07-21 00:00:00 | 93
2013-07-20 00:00:00 | 24
2013-07-19 00:00:00 | 12
2013-07-18 00:00:00 | 29
2013-07-17 00:00:00 | 32
2013-07-16 00:00:00 | 2
2013-07-15 00:00:00 | 66
2013-07-14 00:00:00 | 1
2013-07-13 00:00:00 | 55
2013-07-12 00:00:00 | 60
2013-07-11 00:00:00 | 65
2013-07-10 00:00:00 | 94
2013-07-09 00:00:00 | 86
2013-07-08 00:00:00 | 59
2013-07-07 00:00:00 | 6
2013-07-06 00:00:00 | 6
2013-07-05 00:00:00 | 19
2013-07-04 00:00:00 | 90
2013-07-03 00:00:00 | 4
2013-07-02 00:00:00 | 91
2013-07-01 00:00:00 | 59
2013-06-30 00:00:00 | 37
2013-06-29 00:00:00 | 49
2013-06-28 00:00:00 | 29
2013-06-27 00:00:00 | 89
2013-06-26 00:00:00 | 56
2013-06-25 00:00:00 | 100
2013-06-24 00:00:00 | 75
2013-06-23 00:00:00 | 50
2013-06-22 00:00:00 | 87
2013-06-21 00:00:00 | 43
2013-06-20 00:00:00 | 80
2013-06-19 00:00:00 | 34
2013-06-18 00:00:00 | 94
2013-06-17 00:00:00 | 33
2013-06-16 00:00:00 | 8
2013-06-15 00:00:00 | 51
2013-06-14 00:00:00 | 35
2013-06-13 00:00:00 | 32
2013-06-12 00:00:00 | 54
2013-06-11 00:00:00 | 68
2013-06-10 00:00:00 | 86
2013-06-09 00:00:00 | 54
2013-06-08 00:00:00 | 47
2013-06-07 00:00:00 | 97
2013-06-06 00:00:00 | 4
2013-06-05 00:00:00 | 99
2013-06-04 00:00:00 | 18
2013-06-03 00:00:00 | 51
2013-06-02 00:00:00 | 64
2013-06-01 00:00:00 | 71
2013-05-31 00:00:00 | 3
2013-05-30 00:00:00 | 58
2013-05-29 00:00:00 | 80
2013-05-28 00:00:00 | 97
2013-05-27 00:00:00 | 72
Spreadsheet: 679485d1590443718-creating-a-dynamic-list-example-list-2-w-adj
Sheet: Sheet5

Supplier | Count |  |  |  |  | Count | Supplier
[NAME] | 7 |  |  |  |  |  | [NAME]
Fred | 2 |  |  |  |  |  | [NAME]
[NAME] | 4 |  |  |  |  |  | [NAME]
[NAME] | 1 |  |  |  |  |  | [NAME]
[NAME] | 3 |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Fred
 |  |  |  |  |  |  | Fred
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
Spreadsheet: louise_kitchen__22705__ubsplan
Sheet: Summary 2002

Enron North America
2002 Expenses
 |  |  |  |  |  | 2002 Plan |  |  |  | 2002 Plan
 |  |  |  | VAR Limit |  | Gross Margin | Direct Expenses |  |  | Headcount
 | U.S. Gas Trading (Houston) |  |  | 0 |  | 275 |  |  |  | 28
 | U.S. Gas Origination (Houston) |  |  |  |  | 40 |  |  |  | 9
 | U.S. East Power Trading (Houston) |  |  |  |  | 150 |  |  |  | 26
 | U.S. East Power Origination (Houston) |  |  |  |  | 25 |  |  |  | 7
 | U.S. West Power Trading (Portland) |  |  | 0 |  | 100 |  |  |  | 17
 | U.S. West Power Origination (Portland) |  |  |  |  | 20 |  |  |  | 5
 | Canada Gas/Power Trading (Calgary) |  |  |  |  | 30 |  |  |  | 6
 | Canada Gas/Power Origination (Calgary/Toronto) |  |  |  |  | 10 |  |  |  | 5
 | Leadership |  |  | 0 |  |  | 1.4 |  |  | 2
 | Subtotal - Commercial
 | Analyst and Associates directly supporting commercial |  |  |  |  |  | 4 |  |  | 35
 | Admins for Commercial Teams |  |  |  |  |  | 0.6 |  |  | 10
 | Accounting, Transaction Support |  |  |  |  |  |  |  |  | 40
 | Cash Operations and Tax |  |  |  |  |  |  |  |  | 7
 | Regulatory Affairs |  |  |  |  |  |  |  |  | 5
 | Credit |  |  |  |  |  |  |  |  | 10
 | Research |  |  |  |  |  | 0.5 |  |  | 2
 | Market Risk |  |  |  |  |  | 0.8 |  |  | 4
 | Energy Ops - Houston and Portland
 |  | Gas Logistics |  |  |  |  |  |  |  | 30 | 5 | 0.5
 |  | Gas Book Running |  |  |  |  |  |  |  | 37 | 4 | 0.5
 |  | Gas Settlements |  |  |  |  |  |  |  | 21 | 4 | 0.5
 |  | Gas Volume Mgmt |  |  |  |  |  |  |  | 10 | 4 | 0.5
 |  | Power Logistics |  |  |  |  |  |  |  | 10 | 4 | 0.5
 |  | Power Book Running |  |  |  |  |  |  |  | 13 | 4 | 0.5
 |  | Power Settlements |  |  |  |  |  |  |  | 11 | 5 | 0.5
 |  | Power Volume Mgmt |  |  |  |  |  |  |  | 11 | 6 | 0.05
 | All Canada Support including Energy Ops |  |  |  |  |  |  |  |  | 25
 | HR |  |  |  |  |  |  |  |  | 7
 | IT- Development * |  |  |  |  |  |  |  |  | 60
 | IT- Infrastructure** |  |  |  |  |  |  |  |  | 60
 | IT- EOL |  |  |  |  |  |  |  |  | 20
 | EOL Support |  |  |  |  |  |  |  |  | 20
 | Legal |  |  |  |  |  | 10.5 |  |  | 20
 | Houston Fundamentals/Structuring, and [NAME] |  |  |  |  |  |  |  |  | 35
 | ENE Service Level Agreements (this is a moving target) |  |  |  |  |  |  |  |  |  | Moved $2.4 of SAP costs here, and decreased HC by 12
 | Rent
 |  | Houston & Other |  |  |  |  | 5
 |  | Portland |  |  |  |  | 1
 |  | Canada |  |  |  |  | 1
 |  | Mexico |  |  |  |  | 0.6
 | Subtotal - Non Commercial
 | Other Corporate Charges |  |  |  |  |  | 0
 | Other
 | Total Expenses/People
 | EBIT
 | *IT Development includes systems maintenance and enhancements of ERMS, TAGG,
 | EnPower, Sitara, Unify, etc. and license fees for [NAME] and Tibco
 | **IT Infrastructure includes desk top support, communications, market data feeds, licenses,
 | servers, tie lines, remote office support, WAN, and LAN.
Spreadsheet: 120904d1315621573-formula-assistance-test-case
Sheet: Sheet1

Computer Name | Office Version
Andromeda | 2003
Andromeda | 2010
Andromeda | 2007
Debbie | 2010
Debbie | 2007
[NAME] | 2003
[NAME] | 2010
[NAME] | 2007
[NAME] | 2003
[NAME] | 2007
Celeste | 2003
Celeste | 2007
[NAME] | 2007
[NAME] | 2010
Erin | 2007
Erin | 2010
Spreadsheet: 92676f68-e620-4160-babb-a65ef3744a68
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
6911 | 6001 | Sarka | [NAME] | CZE | 32 | 00:27:33 | 00:00:28 | 00:33:41 | 00:00:48 | 00:32:41 | 1 | 01:35:14
6911 | 15499 | Monika | Kadlecova | SVK | 31 | 00:32:10 | 00:00:29 | [NAME] | 00:00:41 | 00:39:01 | 2 | 01:45:16
6911 | 30335 | Tereza | Durdiakova | ITU | 34 | 00:28:49 | [NAME] | 00:41:38 | 00:01:26 | 00:36:43 | 3 | 01:49:21
6911 | 6010 | Kristina | Lapinova | SVK | 35 | 00:28:47 | 00:00:41 | [NAME] | 00:01:14 | 00:45:42 | 4 | 01:52:20
6911 | 28356 | [NAME] | Liparova | SVK | 36 | 00:33:10 | 00:00:38 | 00:37:47 | 00:01:55 | 00:50:08 | 5 | 02:03:42
6911 | 46293 | [NAME] | Kovacova | SVK | 0 | 00:32:09 | [NAME] | [NAME] | 00:01:22 | 00:49:58 | 6 | [NAME]
Spreadsheet: 59673d1260261860-excel-2007-retrieve-top-10-records-from-data-through-formula-709991_madan
Sheet: PT

>=40 | TRUE
Region | (All)
 | (All)
 |  |  |  |  |  | Values
Unique id | Customer | probability | close date | [NAME] | flag | Sum of Product 1 | Sum of Product 2 | Sum of Product 3 | Sum of Product 4 | Sum of Product 5 | Sum of TOTAL
Unique id 22 | Company 22 | 40 | 2010-04-18 00:00:00 | Approval 22 | N | 290 | 19 | 25 | 59 | 63 | 456
Unique id 14 | Company 14 | 40 | 2009-11-30 00:00:00 | Approval 14 | N | 296 | 14 | 20 | 54 | 68 | 452
Unique id 30 | Company 30 | 40 | 2010-02-01 00:00:00 | Approval 30 | Y | 284 | 18 | 22 | 46 | 62 | 432
Unique id 32 | Company 32 | 40 | 2010-03-16 00:00:00 | Approval 32 | N | 269 | 16 | 28 | 49 | 67 | 429
Unique id 6 | Company 6 | 40 | 2009-11-30 00:00:00 | Approval 6 | N | 261 | 16 | 28 | 47 | 66 | 418
Unique id 19 | Company 19 | 80 | 2009-11-30 00:00:00 | Approval 19 | Y | 249 | 19 | 20 | 46 | 64 | 398
Unique id 17 | Company 17 | 40 | 2010-05-31 00:00:00 | Approval 17 | N | 255 | 18 | 23 | 33 | 67 | 396
Unique id 25 | Company 25 | 60 | 2009-11-30 00:00:00 | Approval 25 | Y | 251 | 15 | 25 | 42 | 62 | 395
Unique id 40 | Company 40 | 100 | 2009-11-15 00:00:00 | Approval 40 | Y | 230 | 15 | 28 | 38 | 68 | 379
Unique id 11 | Company 11 | 40 | 2009-12-25 00:00:00 | Approval 11 | Y | 221 | 19 | 24 | 45 | 68 | 377
Unique id 5 | Company 5 | 100 | 2009-07-06 00:00:00 | Approval 5 | Y | 244 | 14 | 22 | 31 | 64 | 375
Unique id 35 | Company 35 | 40 | 2009-12-15 00:00:00 | Approval 35 | N | 241 | 15 | 20 | 39 | 60 | 375
Unique id 24 | Company 24 | 60 | 2009-11-30 00:00:00 | Approval 24 | Y | 223 | 14 | 29 | 34 | 67 | 367
Unique id 23 | Company 23 | 60 | 2009-11-30 00:00:00 | Approval 23 | Y | 183 | 18 | 27 | 32 | 62 | 322
Unique id 1 | Company 1 | 100 | 2009-11-06 00:00:00 | Approval 1 | Y | 145 | 11 | 29 | 55 | 67 | 307
Grand Total |  |  |  |  |  | 3642 | 241 | 370 | 650 | 975 | 5878
Spreadsheet: 864017d1711376885-using-filter-to-exclude-data-from-calculations-excelforum
Sheet: Table

 | Answer 1 | Answer 2 | Answer 3 | Answer 4 | Answer 5 | Answer 6 | Answer 7 | Answer 8 | Answer 9 | Answer 10 | Answer 11 | Answer 12 | Answer 13 | Answer 14 | TOTAL | Answer 1 | Answer 2 | Answer 3 | Answer 4 | Answer 5 | Answer 6 | Answer 7 | Answer 8 | Answer 9 | Answer 10 | Answer 11 | Answer 12 | Answer 13 | Answer 14
Reason 1
Reason 2
Reason 3
Reason 4
Reason 5
Reason 6
Reason 7
Reason 8
Reason 9
Reason 10
Reason 11
Spreadsheet: 786261d1657075004-formula-to-identify-high-attendance-name_attendance-count
Sheet: Sheet1

Name | Attendance
[NAME] | Monday
[NAME] | Tuesday
[NAME] | Wednesday
[NAME] | Thursday
[NAME] | Friday
[NAME] | Tuesday
[NAME] | Monday
[NAME] | Tuesday
[NAME] | Wednesday
Spreadsheet: 700599d1603263888-need-a-formula-to-copy-end-of-day-totals-in-another-column-excel-forum-sample
Sheet: Original

DATE | In | Total | Daily Total |  | DATE | Daily Total
2020-09-01 00:00:00 | 10 | 10 |  |  | 2020-09-01 08:22:00 | 15
2020-09-01 00:00:00 | -10 | 0 |  |  | 2020-09-02 09:55:00 | 20
2020-09-01 00:00:00 | 15 | 15 | 15 |  | 2020-09-03 09:50:00 | 20
2020-09-02 00:00:00 | 5 | 10 |  |  | 2020-09-04 09:15:00 | -30
2020-09-02 00:00:00 | 10 | 20 |  |  | 2020-09-05 12:25:00 | 10
2020-09-02 00:00:00 | 15 | 35 | 20 |  | 2020-09-06 09:55:00 | 20
2020-09-03 00:00:00 | 10 | 45 |  |  | 2020-09-07 08:25:00 | 5
2020-09-03 00:00:00 | 20 | 65
2020-09-03 00:00:00 | -10 | 55 | 20
2020-09-04 00:00:00 | -10 | 45
2020-09-04 00:00:00 | -10 | 35
2020-09-04 00:00:00 | -10 | 25 | -30
2020-09-05 00:00:00 | 5 | 30
2020-09-05 00:00:00 | -10 | 20
2020-09-05 00:00:00 | 15 | 35 | 10
2020-09-06 00:00:00 | 10 | 45
2020-09-06 00:00:00 | 20 | 65
2020-09-06 00:00:00 | -10 | 55 | 20
2020-09-07 00:00:00 | -5 | 50
2020-09-07 00:00:00 | 15 | 65
2020-09-07 00:00:00 | -5 | 60 | 5
Spreadsheet: phillip_allen__29908__Supply_Demand
Sheet: By Unit

 | Non-student Housing
 | Pop. Growth | [NAME] | S.M. | People |  | Renters | Apt. Renters
Year | [NAME] | share | pop growth | Per H.H. | H.H.'s | @ 50% | @ 75%
2002 | 35000 | 0.04 |  | 2.5
2003 | 36000 | 0.04 |  | 2.5
2004 | 37000 | 0.04 |  | 2.5
2005 | 38000 | 0.04 |  | 2.5
 | Student Housing
 | New |  | Off Campus | Beds/ | Student
Year | Students | Dorm | Beds Req'd | Unit | Units
2002 | 500 | 280 |  | 2
2003 | 500 |  |  | 2
2004 | 500 |  |  | 2
2005 | 500 |  |  | 2
 | Demand |  |  |  | Supply
 | Student | Non-student | Total |  | Palazzo | Randall | Bishop's | [NAME] |  | Total | Net
Year | Units | Units | Units |  | Phase II | Morris | Corner | Carringtion | Other* | Supply
2002 |  |  |  |  | 148 | 200 | 134 | 186
2003
2004 |  |  |  |  |  |  |  |  | 270
2005
*2003- Melrose 202, Bonner-186
2004-Capstone 270
2005- Aquerina 146, [NAME] 180
Spreadsheet: 45643d1244461370-lookup-values-columnwise-book3
Sheet: Sheet1

Name | Qty
 | Rack 1 | Rack 2 | Rack 3
Book 1 | 10 | 25 | 35
Book 2 | 32 | 75 | 95
Book 3 | 106 | 100 | 45
Book 4 | 50 | 64 | 86
Book 5 | 65 | 75 | 29
Spreadsheet: 771410d1646660660-counting-cells-less-than-x-with-cells-containing-numbers-and-letters-sample-weights
Sheet: Audit sheet_Monitoring

 | SITE AUDIT : MONITORING | 1000 | rows to look at
 | Date | 2021-12-11 00:00:00
 | Practice | Site 1 | Site 2 | Site 3
 | No of Clients
 | Target = 100%
 | % clients with a weight recorded in the last 15 months
 | No of clients < 50kg
Spreadsheet: darrell_schoolcraft__7827__imbalsumm0110
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 160749 | 160590 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 147094 | 166627 |  | -13300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 | 141605 | 158060 |  | -9154 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 | 108446 | 151998 |  | -43753 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 | 152809 | 152223 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 | 142248 | 147763 |  | -6187 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 | 135677 | 147763 |  | -12839 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-09-30 00:00:00 |  |  |  | 51206
 | 2001-10-07 00:00:00
 | CBS Dollars
 |  |  |  | -347016