tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: c677423d-ce54-45a4-a1e9-197dfbb065a4
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
[NAME] | Test | [NAME] | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
[NAME] | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
[NAME] | Result | [NAME] | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6188-7 | [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 0b2c4dd4-7afd-435f-8458-fa7b5b183f8c
Sheet: 3

 | Nov 30 | Dec 7 | Dec 14 | Dec 21 | Dec 28
Total Interest Rates* | N/A*** | N/A | N/A | N/A | N/A
Cleared** | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A*** | N/A | N/A | N/A | N/A
Cleared** | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equities | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Credit | 2544943 | 2535376 | 2559859 | 2319826 | 2325576
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Commodities | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, net notional amount outstanding by asset class and cleared status (millions of USD), all products, tenors, and participant types.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: b07f0f82-9d10-4d03-a334-e4dfe71f2091
Sheet: Fields 1-4

Permit No.: |  |  | WQ0003405 |  |  |  | Facility Name: |  | Elm City WWTP |  |  |  |  |  | County: | Wilson |  | Month: |  |  | Year:
Did irrigation occur at this facility? |  |  |  |  |  |  | Field Name: |  | 1 |  | Field Name: |  | 2 |  | Field Name: |  | 3 |  | Field Name: |  | 4
 |  |  |  |  |  |  | Area (acres): |  | 5 |  | Area (acres): |  | 4.77 |  | Area (acres): |  | 4.96 |  | Area (acres): |  | 4.27
 |  |  |  |  |  |  | Cover Crop: |  | Fescue |  | Cover Crop: |  | Fescue |  | Cover Crop: |  | Fescue |  | Cover Crop: |  | Fescue
 |  |  |  |  |  |  | [NAME] (in): |  | 0.5 |  | [NAME] (in): |  | 0.5 |  | [NAME] (in): |  | 0.5 |  | [NAME] (in): |  | 0.5
 |  |  |  |  |  |  | Annual Rate (in): |  | 126.88 |  | Annual Rate (in): |  | 102.96 |  | Annual Rate (in): |  | 102.96 |  | Annual Rate (in): |  | 126.88
Day | Weather |  |  | Freeboard |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Primary Lagoon | 301 Lagoon | Secondary Lagoon | Volume Applied | Time   Irrigated | Daily   Loading | [NAME] Loading | Volume Applied | Time    Irrigated | Daily   Loading | [NAME] Loading | Volume Applied | Time   Irrigated | Daily   Loading | [NAME] Loading | Volume Applied | Time   Irrigated | Daily   Loading | [NAME] Loading
 |  | ºF | in | ft | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 163975d1340583660-listing-certain-cells-if-condition-is-meet-forum-question
Sheet: MEET & GREET

 |  |  |  | MEET AND GREET
Date | Passenger | Flight | From | Rate | Addit. | Total | Month Acc. | Reference | Notes
2012-06-01 00:00:00 | Jones | WN 79 |  | 5.25
2012-06-01 00:00:00 | Lima | AA 1400 |  | 5.25
2012-06-02 00:00:00 | [NAME] | DL 45 |  | 5.25
2012-06-02 00:00:00 | [NAME] | DL 99 |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
 |  |  |  | 5.25
Spreadsheet: 188828d1351002883-sorting-rows-on-different-tabs-by-date-task-20list-20-help-1-
Sheet: C

Due Date: | Client Name | Person Responsible | Task
2012-10-27 00:00:00 | C | person 1 | Task M
2012-10-28 00:00:00 | C | person 2 | Task N
2012-11-02 00:00:00 | C | person 3 | Task O
2012-11-05 00:00:00 | C | person 4 | Task P
2012-11-15 00:00:00 | C | person 5 | Task Q
2012-11-20 00:00:00 | C | person 6 | Task R
Spreadsheet: 811111d1672291640-formating-of-specific-cells-based-adjacent-cell-entry-book101-hd-test
Sheet: Sheet1

The row  below shows my current pattern of alphabets, and it continues with similar pattern
S | S | M | M | R | R | R | R | S | S | M | M | Continues |  |  | S | S | M | M | R | R | R | R | S | S | M | M | R | R | R | R | S | S | M | M | R | R | R | R | S | S | M | M | R | R | R | R
Here If I replace alphabet "S" with "L",as shown in below row |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | S | M | L | R | R | R | R | S | S | M | M | L | R | R | R | S | S | M | M | R | R | R | R | S | S | M | M | R | R | R | R
S | S | M | M | R | R | R | R | L | S | M | M |  |  |  | S | S | M | M | R | R | R | R | S | S | M | L | R | R | R | R | S | S | M | M | R | R | R | R | S | L | M | M | R | R | R | R
I wish the immediate left side cells with alphabet "R" to turn Blue |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | S | M | M | R | R | R | R | S | S | L | M | R | R | R | R | S | S | M | M | R | R | R | R | S | S | M | M | R | R | R | R
S | S | M | M | R | R | R | R | L | S | M | M |  |  |  | S | S | L | M | R | R | R | R | L | S | M | M | R | R | R | R | L | S | M | M | R | R | R | R | L | S | M | M | R | R | R | R
Again , If I replace alphabet "M" with "L",as shown in below row |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | S | M | M | R | R | R | R | L | S | M | M | R | R | R | R | S | L | M | M | R | R | R | R | S | S | M | M | R | R | R | R
S | S | M | L | R | R | R | R | S | S | M | M |  |  |  | S | S | M | M | R | R | R | R | S | L | M | M | R | R | R | R | S | S | L | M | R | R | R | R | S | S | M | M | R | R | R | R
I wish the immediate right side cells with alphabet "R" to turn Blue |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | S | M | M | R | R | R | R | S | S | M | M | R | R | R | R | S | S | M | L | R | R | R | R | S | L | M | M | R | R | R | R
S | S | M | L | R | R | R | R | S | S | M | M |  |  |  | S | S | M | M | R | R | R | R | S | S | M | M | R | R | R | R | S | S | M | M | R | R | R | R | S | S | M | M | R | R | R | R
But, I don’t wish the R cells to be turned blue when I replace  "S" or "M" with "L" as shown below. Means "R" cells has to be very next or prior to cells "S" or "M" |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | S | M | M | R | R | R | R | S | S | M | M | R | R | R | R | S | S | M | M | R | R | R | R | S | S | M | M | R | R | R | R
S | L | M | M | R | R | R | R | S | S | M | M |  |  |  | S | S | M | M | R | R | R | R | S | S | M | M | R | R | R | R | S | S | M | M | R | R | R | R | S | S | M | M | R | R | R | R
S | S | L | M | R | R | R | R | S | S | M | M |  |  |  | S | S | M | M | R | R | R | R | S | S | M | M | R | R | R | R | S | S | M | M | R | R | R | R | S | S | M | M | R | R | R | R
S | S | M | M | R | R | R | R | S | L | M | M |  |  |  | S | S | M | M | R | R | R | R | S | S | M | M | R | R | R | R | S | S | M | M | R | R | R | R | S | S | M | M | R | R | R | R
S | S | M | M | R | R | R | R | S | S | L | M |  |  |  | S | S | M | M | R | R | R | R | S | S | M | M | R | R | R | R | S | S | M | M | R | R | R | R | S | S | M | M | R | R | R | R
Spreadsheet: 682488d1592143894-automating-a-task-automating-task-1-
Sheet: Sheet1

Client | Week | Type | Receipts | Inventory | Inventory+ | Receipts | Inventory |  | Type (Helper)
A | 2020-05-29 00:00:00 | EU | 4 | 5 | 4 | 45 | 4
A | 2020-05-29 00:00:00 | US | 8 | 1 | 35 | 456 | 67
B | 2020-05-29 00:00:00 | EU | 7 | 1 | 4356 | 456 | 457
B | 2020-05-29 00:00:00 | USA | 5 | 6 | 346 | 6 | 4576
B | 2020-05-29 00:00:00 | USA | 4 | 56 | 346 | 45 | 4576
C | 2020-05-29 00:00:00 | EU | 3 | 4 | 35 | 456 | 457
C | 2020-05-29 00:00:00 | US | 12 | 4 | 635 | 456 | 456
C | 2020-05-29 00:00:00 | USA | 4 | 6 | 6 | 6 | 454
D | 2020-05-29 00:00:00 | EU | 6 | 6 | 536 | 645 | 45
D | 2020-05-29 00:00:00 | US | 7 | 7 | 56 | 45 | 456
E | 2020-05-29 00:00:00 | EU | 6 | 6 | 45 | 456 | 456
E | 2020-05-29 00:00:00 | US | 4 | 5 | 645 | 6 | 456
E | 2020-05-29 00:00:00 | USA | 3 | 4 | 645 | 645 | 4
E | 2020-05-29 00:00:00 | not assigned | 5 | 3 | 6 | 645 | 645
F | 2020-05-29 00:00:00 | EU | 7 | 3 | 456 | 45 | 6
F | 2020-05-29 00:00:00 | US | 98 | 5 | 45 | 456 | 456
F | 2020-05-29 00:00:00 | USA | 9 | 6 | 645 | 456 | 45645
G | 2020-05-29 00:00:00 | EU | 7 | 2 | 6 | 6 | 645
G | 2020-05-29 00:00:00 | ASIA | 6 | 76 | 456 | 645 | 6
G | 2020-05-29 00:00:00 | not assigned | 5 | 5 | 45 | 45 | 456
H | 2020-05-29 00:00:00 | EU | 6 | 3 | 645 | 456 | 456
I | 2020-05-29 00:00:00 | US | 3 | 3 | 645 | 456 | 45
I | 2020-05-29 00:00:00 | US | 4 | 4 | 6 | 456 | 645
I | 2020-05-29 00:00:00 | USA | 2 | 5 | 456 | 6 | 54
J | 2020-05-29 00:00:00 | EU | 65 | 7 | 45 | 645 | 6
K | 2020-05-29 00:00:00 | EU | 5 | 8 | 645 | 645 | 456
K | 2020-05-29 00:00:00 | US | 34 | 6 | 6 | 45 | 456
K | 2020-05-29 00:00:00 | USA | 3 | 4 | 456 | 456 | 456
This is the weekly data sheet I get. As you can see it's split by client in A and 'region' in C - Sometimes USA is used instead of US - this will need manual changing, not assigned goes to EU by defualt
Columns E and F need to be added
Spreadsheet: 702181d1604140195-index-match-formula-does-not-pick-the-correct-records-across-lookup-table-index-match
Sheet: Formula

2 | Data
Lookup Value
1 | Group A #1
2 | Group A #2
3 | Group A #3
1 | Group B #1
2 | Group B #2
3 | Group B #3
1 | Group B #1
2 | Group B #2
3 | Group B #3
Spreadsheet: 710640d1609166034-find-and-return-values-based-off-of-multiple-conditions-test-2-
Sheet: REQUEST

PRODUCT | QTY REQ
39573004420 | 420
39573004420 | 125
40887501820 | 290
40887501820 | 345
40887501820 | 200
43341404020 | 40
Spreadsheet: 6f7a876e-9689-473d-86e1-1a038d9e1c1f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22
 | A singles |  |  |  | Wallach Invitational                               Bates College
1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | 3
 |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  | Mattelson - Vassar |  |  |  |  |  |  |  |  |  |  |  | White - Brandeis
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6-4, 6-2
 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  | bye |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  | Mattelson - Vassar |  |  |  |  |  |  |  |  | White - Brandeis
 |  |  |  |  |  | 6-3, 6-3 |  |  |  |  |  |  |  | 6-3, 6-4
 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
 |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  | Berger - Bates |  |  |  |  |  |  |  |  |  |  |  | Reiss - Bates
 |  |  |  |  | 6-1, 6-2 |  |  |  |  |  |  |  |  |  |  |  | 6-3, 6-4
 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
 |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  | Mattelson - Vassar |  |  | White - Brandeis
 | 9 |  |  |  |  |  |  |  | 6-3, 7-6 (2) |  |  | 6-2, 6-2 |  |  |  |  |  |  |  |  | 25
 |  |  |  | Will Rives - Amherst |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  | McConnell - Trinity |  |  |  |  |  | Mattelson - Vassar |  |  |  |  |  | London - Amherst
 |  |  |  |  | 6-1, 6-4 |  |  |  |  |  | 7-5, 6-2
 | 11 |  |  |  |  |  |  |  |  |  | Champion |  |  |  |  |  |  |  |  |  | 27
 |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  | Bettles - Bates |  |  |  |  |  |  |  | Rupasinghe - Bates
 |  |  |  |  |  | 6-2, 6-1 |  |  |  |  |  |  |  | 6-1, 6-2
 | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
 |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  | Bettles - Bates |  |  |  |  |  |  |  |  |  |  |  | Rupasinghe - Bates
 |  |  |  |  | 6-4, 6-2 |  |  |  |  |  |  |  |  |  |  |  | 6-3, 6-1
 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
 |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | Amrit Rupasinghe - Bates
4 | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | 2
Spreadsheet: 648586d1573120067-dropdown-list-dependent-on-2-criterias-excel_dropdown-example_answer
Sheet: Data

Helper | Region | Productcode | Category | Permittance | Comments | Color
 | USA | 123 | Clothes | Yes | Restriction | Orange
 | EU | 234 | Food | Yes | Permitted | Green
 | ASIA | 567 | IT | Yes | Not Permitted | Red
 | USA | 123 | IT | No | Permitted | Green
 | EU | 234 | IT | Yes | Restriction | Orange
 | ASIA | 456 | Food | Yes | Permitted | Green
 | USA | 123 | Boots | Yes | Restriction | Orange
 | ASIA | 566 | IT | No | Not Permitted | Red
 | EU | 789 | Clothes | No | Not Permitted | Red
 | USA | 123 | Clothes | Yes | Restriction | Orange
[NAME] på 3 kriyterier
filtrerer og standadiser application
filtrer efter a-z
Spreadsheet: 767485d1644496876-also-validate-if-file-available-or-not-in-my-located-folder-with-out-vba-please-dg-help
Sheet: Sheet1

DATA WITH ME |  | I NEED DATA ONLY |  |  | ALSO VALIDATE IF FILE AVAILABLE OR NOT IN MY LOCATED FOLDER WITH OUT VBA PLEASE
 |  |  |  |  | THIS IS HYUPERLINK IF FILE AVAIABLE IN THE FOLDER THEN APPEAR AS GD, IF NOT AVAILABLE THEN -
SPEF-SB-16307-10-02-2022 |  | 16307
SPEF-SB-16305-10-02-2022 |  | 16305
SPEF-SB-926304-10-02-2022 |  | 926304
LPAE-SB-840-09-02-2022 |  | 840
LPAE-SB-79839-09-02-2022 |  | 79839
IPAE-SB-23-08-02-2022 |  | 23
SPEF-SB-16123-08-02-2022 |  | 16123
SPEF-SB-16121201-08-02-2022 |  | 16121201
SPEF-SB-16122-08-02-2022 |  | 16122
SPEF-SB-16044957-05-02-2022 |  | 16044957
 | I DON’T NEED
 | DPEF-SB- |  | LAST 11 WORDS EG -10-02-2022 OR 09-02-2022
 | IPAE-SB-
 | LPAE-SB-
 | SPEF-SB-
Spreadsheet: eric_saibi__9783__020102R
Sheet: Four Corners 05

Owner Name |  | Arizona Public Services
Station Name |  | Four Corners Power Station
Unit Name |  | Four Corners 05
NERC Region |  | WSCC
State |  | NM
Fuel Type |  | Coal
Capacity |  | 818 MW
Start Date |  | 2002-01-06 00:00:00
End Date |  | 2002-03-09 00:00:00
Prv. Start Date |  | 2002-01-06 00:00:00
Prv. End Date |  | 2002-03-05 00:00:00
Comments |  | Major O/H
SIC |  | 4911
Plant ID |  | 1523368
Unit ID |  | 1007556
Outage ID |  | 8174
Spreadsheet: 0ae7e2ec-5471-4c51-9dfb-54ed026903a6
Sheet: SCENARIO 1 Final

Estimates made in Nov. 2009 by [NAME]
SCENARIO 1: Full Implementation of Governor's Initiative and CSP by 2012:
-- 4% increase in electricity and heating in 2011 (increase for New Acadmic Building - decrease for Elmwood Commons)
-- immediate (2010) use of 15% biomass for heating; increase to 30 % in 2011
-- 100% biomass for heating starts 2012
-- 100% renewable electricity purchasing starts 2012 (23% to 2010, 33% in 2011 when state goes to 20%)
-- 5% reduction per year in efficiency for heat & electric (14% by 2012)
-- 5% reduction per year in commuting (20% by 2014)
-- C-neutral by 2020 (continue 5% reduction/yr in commuting + RECs' commuting RECs 2013 are 11%, add 11% per year)
-- assume that any heating efficiencies or savings will be used to reduce coal before natural gas
-- dry anaerobic biodigester averts 1000 MT CO2e of electricity and 600 MT CO2e of coal starting 2011
 | MT CO2e | MT CO2e | MT CO2e |  |  |  |  | MT CO2e | MT CO2e
year | Electricity | Heating | Commuting |  |  |  |  | RECs-electricity | RECs-commuting
 |  |  |  | TOTAL | TOTAL-REC | Electric-REC | Commute-Offset
2003 | 20198 | 15550 | 6447 |  |  |  |  | -606
2004 | 19807 | 17983 | 6260 |  |  |  |  | -792
2005 | 19603 | 15930 | 6234 |  |  |  |  | -784
2006 | 19176 | 15164 | 6216 |  |  |  |  | -2109
2007 | 18969 | 17261 | 6248 |  |  |  |  | -2466
2008 | 18872 | 18261 | 6271 |  |  |  |  | -3963
2009 |  | 18261
2010 |  | 14739
2011 |  | 10761
2012 |  | 0
2013
2014
2015
2016
2017
2018
2019
2020 |  |  |  |  | 0
Spreadsheet: chris_germany__1974__ENA-Reliant Prepay
Sheet: Feb 2002

ENA Purchases from Reliant - February 2002
For deliveries on FGT Zone 2 & 3
[NAME] |  | [NAME][PHONE]     [EMAIL]
Backup ENA Trader |  | [NAME]  [PHONE]  [EMAIL]
[NAME] |  | [NAME]  [EMAIL]
[NAME] |  | [NAME][PHONE]  [EMAIL]
[NAME] |  | [NAME]  [PHONE]  [EMAIL]
Reliant Contracts |  | [NAME]  [PHONE]  [EMAIL]
 | Date | Volume | Price [NAME] | GD Post | Price | Total |  | Prepayments | Balance
Wed | 2002-02-06 00:00:00 | 0 |  | 0 | 0 |  |  | 22500
Thu |  | 2000 | [NAME] | 2.155 |  |  |  | 0
Fri |  | 2000 | [NAME] | 2.17 |  |  |  | 20000
Sat |  | 0 | [NAME] | 2.215 |  |  |  | 0
Sun |  | 0 | [NAME] | 2.215 |  |  |  | 0
Mon |  | 2000 | [NAME] | 2.215 |  |  |  | 0
Tue |  | 2000 | [NAME] | 2.23 |  |  |  | 0
Wed |  | 2000 | [NAME] | 2.4 |  |  |  | 0
Thu |  | 2000 | [NAME] | 2.365 |  |  |  | 26000
Fri |  | 2000 | [NAME] | 2.265 |  |  |  | 0
Sat |  | 0 | No activity | 2.175 |  |  |  | 0
Sun |  | 0 | No activity | 2.175 |  |  |  | 0
Mon |  | 0 | No activity | 2.175 |  |  |  | 0
Tue |  | 0 | No activity | 2.175 |  |  |  | 0
Wed |  | 2000 | [NAME] | 2.305 |  |  |  | 0
Thu |  | 2000 | [NAME] | 2.43 |  |  |  | 10000
Fri |  | 2000 | [NAME] | 2.38 |  |  |  | 0
Sat |  | 0 | No activity | 0 |  |  |  | 0
Sun |  | 0 | No activity | 0 |  |  |  | 0
Mon |  | 0 | No activity | 0 |  |  |  | 0
Tue |  | 2000 | [NAME] | 2.415 |  |  |  | 0
Wed |  | 2000 | [NAME] | 2.515 |  |  |  | 0
Thu |  | 2000 | [NAME] | 2.525 |  |  |  | 19000
 | Sum |  | Sitara Deal #1196673
Spreadsheet: 869352d1715927691-countif-is-not-counting-correctly-countif
Sheet: Sheet1

Date | DUTY IN | DUTY OUT | Shift
2024-04-01 00:00:00 | 07:00:00 | 15:00:00 | 08:00:00
2024-04-02 00:00:00 | 07:00:00 | 15:00:00 | 08:00:00
2024-04-03 00:00:00 | 11:00:00 | 19:00:00 | 08:00:00
2024-04-04 00:00:00 | 07:00:00 | 15:00:00 | 08:00:00
2024-04-13 00:00:00 | 11:00:00 | 19:00:00 | 08:00:00
2024-04-14 00:00:00 | 11:00:00 | 19:00:00 | 08:00:00
2024-04-15 00:00:00 | 07:00:00 | 15:00:00 | 08:00:00
2024-04-17 00:00:00 | 07:00:00 | 15:00:00 | 08:00:00
2024-04-18 00:00:00 | 07:00:00 | 15:00:00 | 0.333333333333333
2024-04-19 00:00:00 | 07:00:00 | 15:00:00 | 08:00:00
2024-04-20 00:00:00 | 07:00:00 | 15:00:00 | 08:00:00
2024-04-22 00:00:00 | 11:00:00 | 19:00:00 | 08:00:00
2024-04-24 00:00:00 | 07:00:00 | 15:00:00 | 08:00:00
2024-04-26 00:00:00 | 11:00:00 | 19:00:00 | 0.3333333333333336
 |  |  |  | supposed to be 14
 |  |  |  | the highlighted is getting excluded
Spreadsheet: daren_farmer__5428__3rd Party Transport Expense Production & Overview
Sheet: 99 Acct Month vs. 99 Prod Month

 | Jan Exp | Feb Exp | [NAME] | Apr Exp | May Exp | June Exp | July Exp | Aug Exp | Sept Exp | Oct Exp | Nov Exp | Dec Exp | 1999 Totals
Production Month View, 3rd Party Expense,1999 | 587478.93 | 1142067.41 | 1376038.91 | 1351833.31 | 1378367.11 | 1333176.93 | 1373270.81 | 1387994.14 | 1360780.33 | 1419559.77 | 1387783.32 | 1444496.97
HPL Compression (Schneider) | 412678.13 | 412678.13 | 412678.13 | 412678.13 | 412678.13 | 412678.13 | 412678.13 | 412678.13 | 412678.13 | 412678.13 | 412678.13 | 412678.13
MidTexas Capacity (Schneider) |  | 569835 | 630888.75 | 610537.5 | 630888.75 | 607500 | 630888.75 | 633926.25 | 610537.5 | 630888.75 | 610537.5 | 630888.75
PG&E Transmission (Schneider) |  |  | 155000 | 150000 | 155000 | 150000 | 155000 | 155000 | 150000 | 155000 | 150000 | 155000
Monthly Totals (Minus Scheider)
 | Jan Exp | Feb Exp | [NAME] | Apr Exp | May Exp | June Exp | July Exp | Aug Exp | Sept Exp | Oct Exp | Nov Exp | Dec Exp
Accounting Month View, 3rd Party Expense, 1999 | 0 | 946946.82 | 990221.71 | 1039456.54 | 944532.81 | 922234.51 | 846458.76 | 3382147.19 | 2593384.44 | 1783028.64 | 125895.57 | 1230397.93
HPL Compression (Schneider) |  |  |  |  |  |  |  | 2476068.75 | 1646606.29 | 821250 | -817143.74 | 412678.13
MidTexas Capacity (Schneider) |  | 569835 | 630888.75 | 610537.5 | 630888.75 | 607500 | 630888.75 | 633926.25 | 610537.5 | 630888.75 | 610537.5 | 630888.75
PG&E Transmission (Schneider) |  | 155000 | 150000 | 155000 | 150000 | 155000 | 155000 | 150000 | 155000 | 150000 | 155000
Monthly Totals (Minus Schneider)
Acct. Month vs. Production Month Differential
Monthly Totals represent combined 3rd Party Expense for Ed Gottlob, [NAME], and [NAME].
[NAME] Expense, although shown here, has been backed out of the monthly totals.
Spreadsheet: 716066d1612006601-help-with-searching-2-columns-for-specifc-text-and-returning-a-value-in-3rd-column-book2
Sheet: Sheet1

Column A | Column B | Column C
123Apple | 123Apple
123Orange | 123Orange
123Grape | 123Grape
123Apple | 123Apple
Blank | 123Grape
123Orange | 123Apple