tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7871__sharris1001wk3
Sheet: Current Est Vs. Forecast

Transwestern Pipeline Company
($[NAME])
Current Estimate vs. Forecast
 |  | 3rd Current | Weekly
 |  | Estimate | Forecast | [NAME] |  | Comments
West Demand Revenues |  |  |  |  |  | USGT $11K,  Astra $3K Negotiated Rate
 |  |  |  |  |  | New Contracts:  PPL EnergyPlus, [NAME]
West Commodity Revenues |  |  |  |  |  | West IT deals $92K
East Demand Revenues |  |  |  |  |  | Assumed [NAME] turn back in October
East Commodity Revenues |  |  |  |  |  | Higher IT Rates
[NAME] |  |  |  |  |  | New Contract: Burlington; Reliant $2K
[NAME] Revenues |  |  |  |  |  | Lower IT Volumes
PNR Revenues |  | 0
Revenue Variance
Fuel Price [NAME] |  |  |  |  |  | MTD index price of $1.84 vs. 3nd CE index price of $2.28
Fuel Volume Variance-Unhedged |  |  |  |  |  | Lower retained volumes
Sales Margin Variance on Unhedged |  |  |  |  |  | Over-retained fuel sales
Hedging Adjustment
Other Adjustment |  | 0 | 0
Fuel Variance (Excludes UAF)
Current Month Margin Variance
Expenses |  | -0.944 | -0.944
Non-Recurring |  | 0 | 0
Other |  | -0.004 | -0.004
Total Current Month Variance
Spreadsheet: 464256d1464955013-help-match-and-retrieve-on-criteria-test
Sheet: Before

Date | Name | Ref | Company Name | Product | Subscripton | New Bus / Renewal | Revenue |  | Date Start | Date Finish
2016-06-01 00:00:00 | [NAME] | 1 | ABC Ltd | Type 1 | 1 | 1 | 296
2016-06-02 00:00:00 | [NAME] | 2 | Test Company | Type 2 |  | 1 | 2
2016-06-03 00:00:00 | [NAME] | 5 | XYZ | Type 2 |  | 1 | 9
2016-06-04 00:00:00 | [NAME] | 4 | 123 LTD | Type 3 |  | 1 | 10
2016-06-05 00:00:00 | [NAME] | 6 | XYZ | Type 1 | 2 | 1 | 62
2016-06-06 00:00:00 | [NAME] | 6 | Peter & Co | Type 4 | 20 | 1 | 659
2016-06-07 00:00:00 | [NAME] | 8 | 125 LTD | Type 1 | 2 | 1 | 5
2016-06-08 00:00:00 | [NAME] | 2 | ABC Ltd | Type 1 | 2 | 2 | 6
2016-06-09 00:00:00 | [NAME] | 1 | 126 LTD | Type 4 | 50 | 1 | 63
2016-06-10 00:00:00 | [NAME] | 2 | 124 LTD | Type 1 | 5 | 2 | 6
2016-06-11 00:00:00 | [NAME] | 4 | XYZ | Type 2 |  | 2 | 56
2016-06-12 00:00:00 | [NAME] | 2 | Test Company | Type 2 |  | 2 | 56
2016-06-13 00:00:00 | [NAME] | 4 | ABC Ltd | Type 1 | 3 | 2 | 262
2016-06-14 00:00:00 | [NAME] | 8 | XYZ | Type 2 |  | 2 | 64
2016-06-15 00:00:00 | [NAME] | 6 | ABC Ltd | Type 3 |  | 1 | 9
2016-06-16 00:00:00 | [NAME] | 2 | Test Company | Type 1 | 5 | 1 | 26
2016-06-17 00:00:00 | [NAME] | 2 | ABC Ltd | Type 3 |  | 2 | 262
2016-06-18 00:00:00 | [NAME] | 1 | Test Company | Type 2 |  | 2 | 26
2016-06-19 00:00:00 | [NAME] | 45 | XYZ | Type 4 | 10 | 1 | 32
2016-06-20 00:00:00 | [NAME] | 5 | Peter & Co | Type 2 |  | 1 | 26
2016-06-21 00:00:00 | [NAME] | 4 | Peter & Co | Type 2 |  | 2 | 62
2016-06-22 00:00:00 | [NAME] | 2 | Peter & Co | Type 3 |  | 1 | 9
2016-06-23 00:00:00 | [NAME] | 2 | Peter & Co | Type 1 | 4 | 1 | 32
2016-06-24 00:00:00 | [NAME] | 4 | ABC Ltd | Type 4 | 20 | 1 | 9
2016-06-25 00:00:00 | [NAME] | 5 | Peter & Co | Type 2 |  | 2 | 56
2016-06-26 00:00:00 | [NAME] | 4 | 124 LTD | Type 3 |  | 2 | 20
2016-06-27 00:00:00 | [NAME] | 23 | Test Company | Type 3 |  | 1 | 62
2016-06-28 00:00:00 | [NAME] | 22 | XYZ | Type 4 | 30 | 2 | 3
2016-06-29 00:00:00 | [NAME] | 4 | 125 LTD | Type 1 | 4 | 2 | 7
2016-06-30 00:00:00 | [NAME] | 5 | Test Company | Type 1 | 3 | 2 | 59
Spreadsheet: 203242d1356990074-automatically-populate-data-to-multiple-sheets-populate-data-solution
Sheet: Entertainment

 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 | Date | Day | Time | Content Pillar | Platform | Program | Status Update | Approval Date | Social Comments | Product Team Comments
Entertainment1
Entertainment2
Entertainment3
Entertainment4
Entertainment5
Entertainment6
Entertainment7
Entertainment8
Spreadsheet: 00b1ceb6-866d-43a5-9f36-4fbf8b127fe4
Sheet: 14b

 |  | TOTAL
Product |  | HY** | IG | Other
Index Tranche* | Asia |  | <100 | 530
 | Europe |  |  | 183520
 | North America | 23424 | 166645 | 2882
Index | Asia | 726 | 9330 | 16458
 | Europe |  |  | 398146
 | North America | 108466 | 409801 | 60194
TOTAL |  | 132617 | 585776 | 661730
Estimated net notional amount outstanding, December 7 weekly snapshot, by product type and grade (millions of USD), all participant types, tenors and currencies, cleared and uncleared. This table will be expanded to reflect participant type  as more complete data becomes available.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Data Dictionary for product grade descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 837241d1689953481-increase-average-formula-to-track-columns-sterile-services-red-trolley-deliveries
Sheet: STOCK

Item | Total Trolleys | 2023-01-30 00:00:00 | 2023-02-06 00:00:00 | 2023-02-13 00:00:00 | 2023-02-20 00:00:00 | 2023-02-27 00:00:00 | 2023-03-06 00:00:00 | 2023-03-13 00:00:00 | 2023-03-20 00:00:00 | 2023-03-27 00:00:00 | 2023-04-03 00:00:00 | 2023-04-10 00:00:00 | 2023-04-17 00:00:00 | 2023-04-24 00:00:00 | 2023-05-01 00:00:00 | 2023-05-08 00:00:00 | 2023-05-15 00:00:00 | 2023-05-22 00:00:00 | 2023-05-29 00:00:00 | 2023-06-05 00:00:00 | 2023-06-12 00:00:00 | 2023-06-19 00:00:00 | 2023-06-26 00:00:00 | 2023-07-03 00:00:00 | 2023-07-10 00:00:00 | 2023-07-17 00:00:00 | 2023-07-24 00:00:00 | 2023-07-31 00:00:00 | 2023-08-07 00:00:00 | 2023-08-14 00:00:00 | 2023-08-21 00:00:00 | 2023-08-28 00:00:00 | 2023-09-04 00:00:00 | 2023-09-11 00:00:00 | 2023-09-18 00:00:00 | 2023-09-25 00:00:00 | 2023-10-02 00:00:00 | 2023-10-09 00:00:00 | 2023-10-16 00:00:00 | 2023-10-23 00:00:00 | 2023-10-30 00:00:00 | 2023-11-06 00:00:00 | 2023-11-13 00:00:00 | 2023-11-20 00:00:00 | 2023-11-27 00:00:00 | 2023-12-04 00:00:00 | 2023-12-11 00:00:00 | 2023-12-18 00:00:00 | 2023-12-25 00:00:00 | 2024-01-01 00:00:00 | 2024-01-08 00:00:00 | 2024-01-15 00:00:00 | 2024-01-22 00:00:00
Monday |  | 6 | 6 | 7 | 8 | 8 | 8 | 4 | 8 | 9 | 4 | 0 | 6 | 9 | 0 | 0 | 6 | 10 | 0 | 9 | 9 | 5 | 9 | 9 | 8
Tuesday |  | 9 | 5 | 7 | 9 | 10 | 8 | 6 | 10 | 9 | 5 | 6 | 9 | 6 | 8 | 7 | 8 | 10 | 7 | 10 | 9 | 9 | 9 | 9 | 10
Wednesday |  | 8 | 7 | 7 | 8 | 8 | 7 | 5 | 8 | 10 | 7 | 2 | 8 | 7 | 9 | 8 | 9 | 9 | 8 | 9 | 7 | 10 | 7 | 9 | 8
Thursday |  | 9 | 9 | 8 | 8 | 8 | 8 | 9 | 9 | 8 | 7 | 3 | 8 | 8 | 7 | 9 | 9 | 8 | 9 | 8 | 6 | 10 | 7 | 9 | 5
Friday |  | 10 | 10 | 9 | 9 | 8 | 9 | 10 | 11 | 9 | 0 | 3 | 9 | 7 | 8 | 7 | 10 | 9 | 9 | 7 | 4 | 9 | 8 | 9 | 6
Total
Average
Comments |  |  |  |  |  |  |  | Strike | 3 Cadaver - Mon  - Fri |  |  | [NAME] |  |  |  | Cadaver - Friday |  | Extra 2 Monday |  |  | [NAME] | Extra 2 Wednesday | Cadaver - Wednesday |  | Extra 2 Tuesday
Holidays |  |  |  |  |  |  |  |  |  |  | B/H Friday | B/H Monday |  |  | B/H Monday | B/H Monday |  |  | B/H Monday
Spreadsheet: 830308d1684851451-return-the-next-row-value-based-on-criteria-return-the-next-row-value-based-on-criteria
Sheet: Sheet1

 | DATA |  |  |  |  |  | EXPECTED RESULTS
 |  |  |  |  |  |  |  | 240 |  | 242
 |  |  |  |  |  |  |  | E-01 (275) |  | E-02 (277)
 | M-01-141 | M-02-143 |  | M-03-145 | M-04-147
 | M-01-152 | M-02-154 |  | M-03-156 | M-04-158
 | M-01-185 | M-02-187 |  | M-03-189 | M-04-191
 | M-01-196 | M-02-198 |  | M-03-200 | M-04-202
 | M-01-229 | M-02-231 |  | M-03-233 | M-04-235
 | M-01-240 | M-02-242 |  | M-03-244 | M-04-246
 | E-01-275 | E-02-277 | E-03-279 | E-04-281 | E-05-283
 | E-01-286 | E-02-288 | E-03-290 | E-04-292 | E-05-294
 | E-01-325 | E-02-327 | E-03-329 | E-04-331 | E-05-333
 | E-01-336 | E-02-338 | E-03-340 | E-04-342 | E-05-344
 | E-01-375 | E-02-377 | E-03-379 | E-04-381 | E-05-383
 | E-01-386 | E-02-388 | E-03-390 | E-04-392 | E-05-394
 | E-01-425 | E-02-427 | E-03-429 | E-04-431 | E-05-433
 | N-01-436 | N-02-438 | N-03-440 | N-04-442 | N-05-444
 | N-01-469 | N-02-471 | N-03-473 | N-04-475 | N-05-477
 | N-01-470 | N-02-DTABA | N-03-472 | N-04-474 | N-05-ABA TR7
 | N-01-DTSLM |  | N-03-DTSLM | N-04-DTSLM
Spreadsheet: 170851d1343430199-how-to-create-a-data-validation-that-diminishes-diminishing-validation
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  | martin 1 |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 3 | martin 5
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 4 | martin 7
 |  |  |  |  |  |  |  |  |  |  | martin 5 | 5 | martin 9
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | martin 7 | 7 | 0
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 0
 |  |  |  |  | pick here |  |  |  |  |  | martin 9 | 9 | 0
 |  |  |  |  | martin 1 |  |  |  |  |  | [NAME] | 10 | 0
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | named range
 |  |  |  |  |  |  |  |  | myvalidation2
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
Spreadsheet: 857680d1706631052-help-with-calculating-x-when-y-0-plotting-x-when-price-0
Sheet: Sheet1

I want a formula to plot X when the price is 0,0
X when Price = 0 | ?
No. Shares | 16547574
Strike Price | 1.22
Enterprise value | X
Enterprise value X EXAMPLE | 83288040
Debt | -7400000
Preference A | -6500000
Preference B | -49200000
Price per share
Spreadsheet: 877951d1724883156-how-to-merge-two-files-into-one-mad-king-sample-tms
Sheet: Sheet1

id | price
10001 | 18.99 USD |  |  | 6 in | 6 in | 6 in | 2 lb
10003 | 18.99 USD |  |  | 6 in | 6 in | 6 in | 2 lb
10004 | 11.99 USD |  |  | 6 in | 6 in | 6 in | 2 lb
10005 | 11.99 USD |  |  | 6 in | 6 in | 6 in | 2 lb
10006 | 18.99 USD |  |  | 6 in | 6 in | 6 in | 2 lb
10008 | 18.99 USD |  |  | 6 in | 6 in | 6 in | 2 lb
10010 | 12.99 USD |  |  | 14 in | 12 in | 9 in | 6 lb
10018 | 18.99 USD |  |  | 6 in | 6 in | 6 in | 2 lb
10021s40 | 42.99 USD |  |  | 6 in | 6 in | 6 in | 2 lb
10023 | 18.99 USD |  |  | 6 in | 6 in | 6 in | 2 lb
10024 | 18.99 USD
10025 | 18.99 USD |  |  | 7 in | 6 in | 6 in | 2 lb
10026 | 18.99 USD |  |  | 6 in | 6 in | 6 in | 2 lb
10031 | 18.99 USD |  |  | 6 in | 6 in | 6 in | 2 lb
10038 | 18.99 USD |  |  | 6 in | 6 in | 6 in | 2 lb
10039 | 18.99 USD |  |  | 14 in | 12 in | 10 in | 9 lb
10041 | 18.99 USD |  |  | 6 in | 6 in | 6 in | 2 lb
10043 | 18.99 USD |  |  | 6 in | 6 in | 6 in | 2 lb
10048 | 18.99 USD |  |  | 6 in | 6 in | 6 in | 2 lb
10061 | 28.99 USD
10071 | 36.99 USD
10078 | 12.99 USD
10082 | 11.99 USD
10094 | 6.99 USD
10099 | 6.99 USD
10100 | 6.99 USD
10102 | 1.99 USD
10103 | 7.99 USD
10104 | 7.99 USD
10105 | 6.99 USD
10106 | 6.99 USD
10107 | 6.99 USD
10108 | 6.99 USD
10109 | 6.99 USD
10111 | 6.99 USD
10112 | 6.99 USD
10113 | 12.99 USD
10114 | 12.99 USD
Spreadsheet: 99245d1297950933-using-matching-criteria-from-a-array-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 |  |  | 5 | 14 | 20 | 32 | 39 | 42
 |  |  | 1 | 2 | 10 | 15 | 32 | 34 |  | 1 |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 1
 |  |  | 2 | 13 | 24 | 29 | 32 | 42 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  | 6 | 9 | 18 | 24 | 30 | 41
 |  |  | 4 | 13 | 16 | 19 | 30 | 45
 |  |  | 11 | 21 | 22 | 24 | 34 | 41
 |  |  | 2 | 15 | 18 | 35 | 38 | 40
 |  |  | 2 | 8 | 18 | 23 | 37 | 38
 |  |  | 3 | 4 | 13 | 29 | 34 | 36
 |  |  | 3 | 10 | 11 | 22 | 36 | 42
 |  |  | 7 | 8 | 24 | 30 | 36 | 44
 |  |  | 23 | 25 | 26 | 27 | 30 | 32
 |  |  | 4 | 15 | 17 | 22 | 27 | 41
 |  |  | 10 | 15 | 17 | 21 | 40 | 44
 |  |  | 10 | 22 | 23 | 34 | 36 | 37
 |  |  | 2 | 10 | 16 | 18 | 36 | 41
 |  |  | 2 | 3 | 7 | 9 | 21 | 27
 |  |  | 7 | 13 | 15 | 36 | 37 | 39
 |  |  | 2 | 9 | 10 | 22 | 32 | 34
 |  |  | 9 | 18 | 22 | 26 | 27 | 39
 |  |  | 1 | 19 | 24 | 27 | 35 | 39
 |  |  | 1 | 24 | 26 | 27 | 32 | 33
 |  |  | 13 | 20 | 24 | 28 | 34 | 41
 |  |  | 2 | 8 | 11 | 29 | 36 | 41
Spreadsheet: 88910d1288720975-conditional-formatting-with-multiple-and-or-criteria-air_surface
Sheet: Sheet1

Sample Type | Location | Area | Date Sampled | Sample Name | Technician In Hood (If applicable) | CFU/FT3 | [NAME]? | If Yes, qty | Alert/ Action
Surface | CR1 | Floors | 2010-07-23 00:00:00 | 1SCF2 | N/A | 7 | No | 0
Surface | CR1 | Floors | 2010-08-05 00:00:00 | 1SCF2 | N/A | 6 | No | 0
Surface | CR1 | Floors | 2010-08-31 00:00:00 | 1SCF2 |  | 5 | No | 0
Surface | CR1 | Floors | 2010-09-10 00:00:00 | 1SCF2 |  | 6 | No | 0
Surface | CR1 | Floors | 2010-09-13 00:00:00 | 1SCF2 |  | 6 | Yes | 1
Air | CR1 | Room | 2010-07-16 00:00:00 | 1AC6 | N/A | 0.03 | Yes | 1
Air | PR1 | Room | 2010-07-19 00:00:00 | 1AP1 | N/A | 0.09 | No | 0
Air | MR1 | Room | 2010-07-19 00:00:00 | 1AM1 | N/A | 0.09 | Yes | 2
Air | CR1 | Hood | 2010-07-23 00:00:00 | 1AH9 | Not In Use | 0.03 | No | 0
Air | CR1 | Hood | 2010-07-26 00:00:00 | 1AH9 | Not In Use | 0.09 | No | 0
Surface | CR1 | Hood | 2010-09-23 00:00:00 | 1SCH8 | Empty | 3 | No | 0
Surface | MR1 | Floors | 2010-07-26 00:00:00 | 1SMF1 | N/A | 3 | No | 0
Surface | CR1 | Floors | 2010-07-26 00:00:00 | 1SCF1 | N/A | 3 | No | 0
Surface | PR1 | Floors | 2010-07-19 00:00:00 | 1SPF3 | N/A | 1 | Yes | 1
Surface | PR1 | Door | 2010-08-02 00:00:00 | 1SPD1 | N/A | 2 | No | 0
Surface | CR1 | Bins | 2010-09-08 00:00:00 | 1SCB1 | N/A | 0 | No | 0
Surface | CR1 | Pass-Thrus | 2010-07-22 00:00:00 | 1SCP2 | N/A | 1 | No | 0
Surface | CR1 | Tables | 2010-07-23 00:00:00 | 1SCT2 | N/A | 11 | Yes | 11
Surface | MR1 | Vault | 2010-08-17 00:00:00 | 1SMV1 | N/A | 0 | No | 0
Surface | CR1 | Walls | 2010-07-22 00:00:00 | 1SCW2 | N/A | 6 | Yes | 1
Spreadsheet: darrell_schoolcraft__7310__imball0201
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 106165 | 117417
2 | 117972 | 117437
3 | 124002 | 124207
4 | 101418 | 100788
5 | 104942 | 104207
6 | 104211 | 104207
7 | 84424 | 83518
8 | 77456 | 77234
9 | 89763 | 89032
10 | 93179 | 92822
11 | 100949 | 100822
12 | 93077 | 92822
13 | 93019 | 92822
14 | 92998 | 92822
15 | 93044 | 92822
16 | 85485 | 85001
17 | 94982 | 93956
18 | 83049 | 82542
19 | 84312 | 82822
20 | 85022 | 82822
21 | 82993 | 82822
22 | 82989 | 82822
23 | 87826 | 87822
24 | 91683 | 98507
25 | 88263 | 87822
26 | 85898 | 87822
27 | 87999 | 87822
28 | 87998 | 87822
29
30
31
2001-12-31 00:00:00 |  |  | 12821
2002-01-28 00:00:00
CBS Volume
 |  |  | -49782
Spreadsheet: 705840d1606326767-formula-to-search-across-three-values-to-populate-a-result-test-data
Sheet: Table 2

ACCTID | ACCTNAME | BILLINGCYCLE | TERMINALS | TOTALCHARGES
500352537 | Client B | 2020-Nov | 161 | 1826.94
500361737 | Client D | 2020-Nov | 719 | 3206.44
500362837 | Client Q | 2020-Nov | 320 | 2880.45
Spreadsheet: 42324d1240921350-algebra-to-identify-a-quadratic-relation-equations-values
Sheet: Sheet1

gives values for y | y= | 3x + 4 | test equations |  | used for calculation can be hidden or put on new sheet
from -10 to+10 |  | enter  equation  in C1 | 2x^2-5x+3 |  | *b4 | b4 | -26 |  | -26
 | x | y | 3x + 4 |  | *b5 | [NAME] | -23 |  | -23
 | -10 | -26 | x^2 |  | *b6 | b6 | -20 |  | -20
 | -9 | -23 | 2x^2+x+1 |  | *b7 | b7 | -17 |  | -17
 | -8 | -20 | x^2+x+1 |  | *b8 | b8 | -14 |  | -14
 | -7 | -17 |  |  | *b9 | b9 | -11 |  | -11
 | -6 | -14 |  |  | *b10 | b10 | -8 |  | -8
 | -5 | -11 |  |  | *b11 | b11 | -5 |  | -5
 | -4 | -8 |  |  | *b12 | b12 | -2 |  | -2
 | -3 | -5 |  |  | *b13 | b13 | 1 |  | 1
 | -2 | -2 |  |  | *b14 | b14 | 4 |  | 4
 | -1 | 1 |  |  | *b15 | b15 | 7 |  | 7
 | 0 | 4 |  |  | *b16 | b16 | 10 |  | 10
 | 1 | 7 |  |  | *b17 | b17 | 13 |  | 13
 | 2 | 10 |  |  | *b18 | b18 | 16 |  | 16
 | 3 | 13 |  |  | *b19 | b19 | 19 |  | 19
 | 4 | 16 |  |  | *b20 | b20 | 22 |  | 22
 | 5 | 19 |  |  | *b21 | b21 | 25 |  | 25
 | 6 | 22 |  |  | *b22 | b22 | 28 |  | 28
 | 7 | 25 |  |  | *b23 | b23 | 31 |  | 31
 | 8 | 28 |  |  | *b24 | b24 | 34 |  | 34
 | 9 | 31
 | 10 | 34
Spreadsheet: 718724d1613313054-extract-values-into-column-a-to-column-k-of-sheet-named-here_1-ignoring-blanks-extract-values-ignoring-blanks
Sheet: Here_1

Name_1 | Name_2 | Middle | Area | Area Time | Local Time | GPS | Letter | District Name | Distance | Status
 |  |  | YMCA | 17:00:00 | 23:00:00 | None | C | Oki, Dimension | 80 | On
 |  |  | YMCA | 17:00:00 | 23:00:00 | None | C | Oki, Dimension | 81 | On
 |  |  | YMCA | 17:00:00 | 23:00:00 | None | C | Oki, Dimension | 82 | On
 |  |  | YMCA | 17:00:00 | 23:00:00 | None | C | Oki, Dimension | 83 | On
 |  |  | YMCA | 17:00:00 | 23:00:00 | None | C | Oki, Dimension | 84 | On
 |  |  | YMCA | 17:00:00 | 23:00:00 | None | C | Oki, Dimension | 85 | On
 |  |  | YMCA | 17:00:00 | 23:00:00 | None | C | Oki, Dimension | 86 | On
 |  |  | YMCA | 17:00:00 | 23:00:00 | None | C | Oki, Dimension | 87 | On
 |  |  | YMCA | 17:00:00 | 23:00:00 | None | C | Oki, Dimension | 88 | On
 |  |  | YMCA | 17:00:00 | 23:00:00 | None | C | Oki, Dimension | 89 | On
 |  |  | YMCA | 17:00:00 | 23:00:00 | None | C | Oki, Dimension | 90 | On
 |  |  | YMCA | 17:00:00 | 23:00:00 | None | C | Oki, Dimension | 91 | On
 |  |  | YMCA | 17:00:00 | 23:00:00 | None | C | Oki, Dimension | 92 | On
 |  |  | YMCA | 17:00:00 | 23:00:00 | None | C | Oki, Dimension | 93 | On
 |  |  | YMCA | 17:00:00 | 23:00:00 | None | C | Oki, Dimension | 94 | On
Spreadsheet: 727258d1617805439-reference-data-from-another-tab-and-return-values-mom-stats_v2_eh
Sheet: Auto vetting stats

Period | All work | Total cost | Cost PP
2019
November
December
2020
January
February
March
April | 64531 | 4475 | 6.9
May | 93503 | £6,384.72 | 6.8
June | 63753 | 5329.080086888001 | 8.4
July | 89709 | 5558.54 | 6.2
August | 118560 | 6885.579207920002 | 5.8
September | 142281 | 8676.68 | 6.1
October | 104517 | 6788.83 | 6.5
November | 84051 | 5490.32 | 6.5
December | 87980 | 5906.28 | 6.7
2021
January | 114830 | 6494.67 | 5.7
February | 93834 | 5301.48 | 5.6
March | 110566 | 5571.70708584 | 5
Spreadsheet: 702499d1604389486-extract-the-list-of-unique-values-from-a-table-sample-data
Sheet: Sheet1

Concatenate | Month | Agent | Column1
 | 2020 JUL | [NAME] |  | 2020 JUL |  |  |  | I need the list of unique names from the "Agent" column in Table1:
 | 2020 JUL | [NAME] |  |  |  |  |  | * if the "Month" column starts with E2
 | 2020 JUL | [NAME] |  |  |  |  |  | * minus the hardcoded word "TOTAL"
 | 2020 JUL | Unique1
 | 2020 JUL | [NAME]
 | 2020 JUL | Clementine
 | 2020 JUL | Brett |  |  |  |  |  | The result I need (alphabetical preferred, but not required)
 | 2020 JUL | Chase
 | 2020 JUL | Sean
 | 2020 JUL | Olive
 | 2020 JUL | [NAME]
 | 2020 JUL | [NAME]
 | 2020 JUL | TOTAL
 | 2020 AUG | [NAME]
 | 2020 AUG | [NAME]
 | 2020 AUG | [NAME]
 | 2020 AUG | Reeve
 | 2020 AUG | [NAME]
 | 2020 AUG | Clementine
 | 2020 AUG | Brett
 | 2020 AUG | Chase
 | 2020 AUG | Sean
 | 2020 AUG | Olive
 | 2020 AUG | [NAME]
 | 2020 AUG | Unique2
 | 2020 AUG | TOTAL
 | 2020 SEP | [NAME]
 | 2020 SEP | [NAME]
 | 2020 SEP | [NAME]
 | 2020 SEP | Reeve
 | 2020 SEP | [NAME]
 | 2020 SEP | Clementine
 | 2020 SEP | Brett
 | 2020 SEP | Unique3
 | 2020 SEP | Sean
 | 2020 SEP | Olive
 | 2020 SEP | [NAME]
 | 2020 SEP | [NAME]
 | 2020 SEP | TOTAL
Spreadsheet: lisa_gang__22344__EPE_MARCH_2002
Sheet: MARCH(12)

To: El Paso Marketing   -  fax # [PHONE]
El Paso Generation   -  fax # [PHONE]
 | 2002-03-12 00:00:00
HR ENDING | HR ENDING | FOUR CORNERS
Pacific | Mountain | SALE
Standard | Standard | EPMI
Time | Time | 22.25
 |  | CARRY OVER FROM 3/11
 |  | 3/1/02-3/31/02
 |  |  |  |  | TOTAL NET | NET PALO VERDE | NET FOUR CORNERS | NET EDDY
PST | MST | DIRECT BILL
2400 | 0100 | 25
0100 | 0200 | 0
0200 | 0300 | 0
0300 | 0400 | 0
0400 | 0500 | 0
0500 | 0600 | 0
0600 | 0700 | 0
0700 | 0800 | 0
0800 | 0900 | 0
0900 | 1000 | 0
1000 | 1100 | 0
1100 | 1200 | 0
1200 | 1300 | 0
1300 | 1400 | 0
1400 | 1500 | 0
1500 | 1600 | 0
1600 | 1700 | 0
1700 | 1800 | 0
1800 | 1900 | 0
1900 | 2000 | 0
2000 | 2100 | 0
2100 | 2200 | 0
2200 | 2300 | 0
2300 | 2400 | 0
2400 | 0100 | 0
 | MST Total |  |  |  |  |  |  |  | Today's Scheduled MWh
 |  |  | TOTAL SALES | TOTAL PURCHASES
 | PST TOTAL
 |  | EPE(G)4C
 |  | EPMI
 |  | AZPS(T)FC3/PPD2
 |  | WALC(T)PPD2/COOLIDGE
 |  | CRSP(L)COOLIDGE
Spreadsheet: 133097d1324171545-create-drop-down-menus-linking-from-other-sheets-vlookup
Sheet: Sheet1

Ham |  |  |  |  |  | Hidden Column
Description | Calories | Fat | Sodium
Spreadsheet: 725558d1616746305-staff-attendance-data-attendance
Sheet: Report_20210315T112801

Raw data |  |  |  | Raw data
Date |  |  |  | User |  |  |  |  |  |  |  |  |  |  |  | Staff | Date | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
2021-03-01 11:01:13 |  |  |  | X05024(Maria) |  |  |  |  |  |  |  |  |  |  |  | X05024(Maria) | 2021-03-01 00:00:00
2021-03-01 12:12:05 |  |  |  | X05024(Maria) |  |  |  |  |  |  |  |  |  |  |  | X05024(Maria) | 2021-03-02 00:00:00
2021-03-01 15:02:08 |  |  |  | X05024(Maria) |  |  |  |  |  |  |  |  |  |  |  | R09999(Peter) | 2021-03-01 00:00:00
2021-03-01 17:42:24 |  |  |  | X05024(Maria) |  |  |  |  |  |  |  |  |  |  |  | R09999(Peter) | 2021-03-02 00:00:00
2021-03-01 19:06:32 |  |  |  | X05024(Maria)
2021-03-02 10:22:25 |  |  |  | X05024(Maria) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | time highlighted in green wrongly capture next day data
2021-03-02 10:23:02 |  |  |  | X05024(Maria)
2021-03-02 10:33:56 |  |  |  | X05024(Maria)
2021-03-02 10:46:16 |  |  |  | X05024(Maria)
2021-03-02 15:24:37 |  |  |  | X05024(Maria)
2021-03-02 15:31:59 |  |  |  | X05024(Maria)
2021-03-02 17:52:44 |  |  |  | X05024(Maria)
2021-03-02 18:36:15 |  |  |  | X05024(Maria)
2021-03-01 08:30:56 |  |  |  | R09999(Peter)
2021-03-01 08:32:58 |  |  |  | R09999(Peter)
2021-03-01 09:18:06 |  |  |  | R09999(Peter)
2021-03-01 13:49:43 |  |  |  | R09999(Peter)
2021-03-01 16:57:45 |  |  |  | R09999(Peter)
2021-03-01 17:47:28 |  |  |  | R09999(Peter)
2021-03-01 17:48:15 |  |  |  | R09999(Peter)
2021-03-01 18:08:42 |  |  |  | R09999(Peter)
2021-03-02 08:31:02 |  |  |  | R09999(Peter)
2021-03-02 08:33:08 |  |  |  | R09999(Peter)
2021-03-02 08:49:53 |  |  |  | R09999(Peter)
2021-03-02 09:23:00 |  |  |  | R09999(Peter)
2021-03-02 09:26:43 |  |  |  | R09999(Peter)
2021-03-02 09:57:08 |  |  |  | R09999(Peter)
2021-03-02 09:57:56 |  |  |  | R09999(Peter)
2021-03-02 10:06:15 |  |  |  | R09999(Peter)
2021-03-02 10:12:43 |  |  |  | R09999(Peter)
2021-03-02 14:27:29 |  |  |  | R09999(Peter)
2021-03-02 18:09:59 |  |  |  | R09999(Peter)
Spreadsheet: 218906d1362603300-how-to-create-master-list-even-when-dependant-variable-moves-test-for-master
Sheet: CODES

 | Black | 10 |  | ?
 | White | 5
 | Blue | 0
 | ? | 0.1
 | 1 | 10
 | 2 | 5 |  | 1
 | 3 | 0
 | ? | 0.1
 | 1 | 0 |  | 1
 | 2 | 10
 | 3 | 5
 | ? | 0.1
Spreadsheet: 87429d1287300050-please-help-i-need-to-lookup-through-multiple-columns-and-return-one-value-phone-bill-sheet-example
Sheet: Contact sheet

BusinessPhone | BusinessPhone2 | HomePhone | [NAME] | MobilePhone | OtherPhone | Contact Name | Contact Type
4167880000 |  |  |  | 9051234500 |  | Mr. [NAME] | Personal
6195671111 |  | 4163336666 |  | 4168882222 |  | Mr. [NAME] | Business
9050006666 |  |  |  | 9057773333 | 4164445555 | Mr. [NAME] | Business
9056667777 | 4169990000 |  | 9054445555 | 4165559999 |  | Mr. [NAME] | Personal
the date range is A2 to G5
I need to match the phone number in the phone bill sheet with the name from this sheet
Spreadsheet: 586861d1534692183-how-to-get-specific-rows-in-a-worksheet-copied-from-another-coloured-backgrounds
Sheet: Income No Gaps

Date | Title | Money
Spreadsheet: 24594cc2-9ba1-467e-9f16-f271da023022
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Financial resources relevant to climate change (million €)
Official Development Aid | 2001 | 2002 | 2003
Economic infrastructure and services
Transport | 200.16 | 318.72 | 884.74
Energy generation and supply | 134.12 | 104.9 | 233.19
Agriculture, forestry and fishing
Forestry | not available | 29.54 | 5.06
General Environmental Protection | 132.57 | 85.13 | 115.58
Water supply and sanitation | 224.27 | 100.9 | 332.28
Total* | 691.12 | 639.19 | 1570.85
* This represents the total in these budget headings and is not directed only to climate change