tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 793108d1661318905-lookup-with-matching-with-return-and-count-for-help-09
Sheet: Captains

TRAINING STAGE |  |  |  |  |  |  |  |  |  |  |  | COACHING STAGE |  |  | GOLD HAT STAGE
S/No. | Name | Nationality | Division | Role Category | Existing /  New Staff | SIC Date | Due Date to complete | Selected Class | Selected date | Actual Date completed | Status | Team | Assigned Coach | Date assigned | Nominated Gold Hat? | Selected Date | Start Date | Graduation Date | Remarks
1 | [NAME] | Indian | Active Fire Protection Systems Pte Ltd | [NAME] |  |  |  | [NAME] |  |  |  | Core | Bye
2 | Mamun | [NAME] | Active Fire Protection Systems Pte Ltd | Contractor Supervision |  |  |  | Bengali |  |  |  | Core | [NAME]
3 | [NAME] | Malaysian | Active Fire Protection Systems Pte Ltd | Contractor Management |  |  |  | English |  |  |  | Site Wide | [NAME]
4 | [NAME] | Indian | Active Fire Protection Systems Pte Ltd | Contractor Supervision |  |  |  | [NAME]
5 | Mani Kumar | Indian | Active Fire Protection Systems Pte Ltd | Contractor Supervision |  |  |  | [NAME]
6 | [NAME] | [NAME] | Active Fire Protection Systems Pte Ltd | Contractor Vehicle Plant Operators |  |  |  | Bengali
7 | [NAME] | Indian | Active Fire Protection Systems Pte Ltd | Contractor Supervision |  |  |  | [NAME]
8 | Islam Shafiqul | [NAME] | Active Fire Protection Systems Pte Ltd | Contractor Supervision |  |  |  | Bengali
9 | Doldol Jodoni Javier | Filipino | Active Fire Protection Systems Pte Ltd | Contractor Management |  |  |  | English
10 | Rajangam Ravichandran | Indian | Active Fire Protection Systems Pte Ltd | Contractor Supervision |  |  |  | [NAME]
11 | Mayakkannu Singaram | Indian | Active Fire Protection Systems Pte Ltd | Contractor Supervision |  |  |  | [NAME]
12 | [NAME] | Indian | Active Fire Protection Systems Pte Ltd | [NAME] |  |  |  | [NAME]
13 | Mukbul [NAME] | [NAME] | Active Fire Protection Systems Pte Ltd | Contractor Supervision |  |  |  | Bengali
14 | [NAME] | [NAME] | Active Fire Protection Systems Pte Ltd | Contractor Supervision |  |  |  | English
15 | [NAME] | Indian | Bestcoat Contract Services Pte Ltd | Contractor Supervision |  |  |  | [NAME]
16 | [NAME] | [NAME] | Bestcoat Contract Services Pte Ltd | Contractor Supervision |  |  |  | Bengali
17 | Sheikh [NAME] | Singaporean | Bestcoat Contract Services Pte Ltd | [NAME] |  |  |  | English
18 | [NAME] | Singaporean | Bestcoat Contract Services Pte Ltd | [NAME] |  |  |  | English
 |  |  |  |  |  | By default the drop down for Column-E, shall include mentors (team) from Site Wide.
 |  |  |  |  |  | If Site Wide team is select at Column-D, then Column-E shall include only site wide mentors.
Spreadsheet: 4f456190-2cd9-41a6-8133-9fa0098ca98f
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
Spreadsheet: 740707d1626482130-correction-needed-for-outbound-quantity-example_avg_cost-warehouse-approach-v5-
Sheet: Version11

Totals: |  |  |  | Purchase
 |  |  |  | Sale
 |  |  |  |  | TRANSACTION |  |  |  | OUTBOUND |  |  | OUTSTANDING |  |  | P/L
Trade Symbol | Transaction | Date | Sale Portion | [NAME] | Quantity Bought(+) / Sold(-) | Price | Fees | Amount | Quantity Sold | Price | Amount (Cost of Goods Sold) | Quantity Remaing | Price | Amount (Inventory Value) | Gain(+) / Loss(-) Running Balance | Gain(+) / Loss(-) per Sale Only
 | Purchase | 2021-02-22 00:00:00 |  |  | 3.514923 | 14.21 | 0
 | Purchase | 2021-02-22 00:00:00 |  |  | 1.95554 | 12.8 | 0
 | Purchase | 2021-02-23 00:00:00 |  |  | 2.121327 | 11.78 | 0
 | Purchase | 2021-03-24 00:00:00 |  |  | 374.242645 | 13.45 | 0
 | Sale | 2021-03-29 00:00:00 | All | Short | -381.834442 | 13.34 | 0
 | Purchase | 2021-04-17 00:00:00 |  |  | 13.380624 | 37.72 | 0
 | Purchase | 2021-04-17 00:00:00 |  |  | 12.706329 | 39.39 | 0
 | Purchase | 2021-04-27 00:00:00 |  |  | 28.600846 | 35.18 | 0
 | Purchase | 2021-05-04 00:00:00 |  |  | 74.626678 | 67.52 | 0
 | Purchase | 2021-05-04 00:00:00 |  |  | 270.208195 | 74.56 | 0
 | Sale | 2021-05-04 00:00:00 | All | Short | -399.522672 | 78.52 | 0
 | Purchase | 2021-05-04 00:00:00 |  |  | 179.734944 | 84.04 | 0
 | Purchase | 2021-05-05 00:00:00 |  |  | 49.622456 | 101.4 | 0
 | Purchase | 2021-05-05 00:00:00 |  |  | 246.20782 | 102.55 | 0
 | Purchase | 2021-05-05 00:00:00 |  |  | 165.37101 | 103.4 | 0
 | Sale | 2021-05-05 00:00:00 | All | Short | -640.93623 | 104.18 | 0
 | Purchase | 2021-05-05 00:00:00 |  |  | 30.301633 | 99.03 | 0
 | Purchase | 2021-05-06 00:00:00 |  |  | 276.819944 | 145.41 | 0
 | Sale | 2021-05-06 00:00:00 | All | Short | -307.121577 | 168.49 | 0
 | Purchase | 2021-05-06 00:00:00 |  |  | 277.1079 | 182.23 | 0
 | Purchase | 2021-05-06 00:00:00 |  |  | 138.149505 | 182.77 | 0
 | Sale | 2021-05-08 00:00:00 | Partial | Short | -107.381606 | 127.43 | 0
 | Sale | 2021-07-16 00:00:00 | Partial | Short | -160 | 100 | 0
 | Sale | 2021-07-16 00:00:00 | Partial | Short | -140 | 80 | 0
 | Sale | 2021-07-16 00:00:00 | Partial | Short | -7.875792 | 65 | 0
 | Purchase | 2021-07-18 00:00:00 |  |  | 55 | 55 | 0
Spreadsheet: 15f4cf60-dc02-4781-b636-bcc629cfd396
Sheet: Sheet1

Table 6--U.S. textile imports, by fiber | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Mar. | Apr. | May | May
Item | 2012 | 2012 | 2012 | 2011
 | 1,000 pounds 1/
[NAME], thread, and fabric: | 242921.086 | 257007.501 | 272708.182 | 262603.409
Cotton | 51989.653 | 57811.868 | 59216.204 | 62875.033
Linen | 21000.697 | 19569.314 | 19944.914 | 16909.036
Wool | 3389.626 | 4281.361 | 4113.695 | 3768.797
Silk | 542.11 | 617.086 | 686.551 | 767.078
Manmade | 165999 | 174727.872 | 188746.818 | 178283.465
Apparel: | 731395.024 | 766288.216 | 803464.7949999999 | 890373.3669999999
Cotton | 428684.612 | 430643.195 | 460801.546 | 529273.705
Linen | 9380.834 | 10937.316 | 9086.316 | 11959.718
Wool | 15136.753 | 17084.64 | 17851.186 | 17990.041
Silk | 8615.782 | 9899.293 | 8053.794 | 9548.056
Manmade | 269577.043 | 297723.772 | 307671.953 | 321601.847
Home furnishings: | 173995.144 | 197216.507 | 217663.186 | 207975.51
Cotton | 108380.899 | 111389.632 | 129404.436 | 122214.915
Linen | 630.188 | 772.843 | 783.08 | 839.923
Wool | 304.546 | 8447.64 | 322.693 | 201.672
Silk | 144.768 | 1491.392 | 180.304 | 226
Manmade | 64534.743 | 75115 | 86972.673 | 84493
Floor coverings: | 57505.64 | 46698.066 | 65888.97099999999 | 58228.322
Cotton | 7337.125 | 6025.162 | 8523.089 | 7273.92
Linen | 15256.777 | 14290.639 | 15717.533 | 14340.16
Wool | 9226.035 | 226.753 | 8682.127 | 8854.797
Silk | 1648.353 | 202.512 | 2037.993 | 1610.464
Manmade | 24037.35 | 25953 | 30928.229 | 26148.981
Total imports: 2/ | 1206201.169 | 1267631.108 | 1360094.097 | 1430390.282
Cotton | 596652.049 | 606140.921 | 658218.99 | 726141.357
Linen | 46268.496 | 45570.112 | 45531.843 | 44946.136
Wool | 28058.779 | 30049.913 | 30979.124 | 31204.998
Silk | 10951.013 | 12210.283 | 10958.642 | 12153.115
Manmade | 524270.832 | 573659.879 | 614405.498 | 615944.676
1/ Raw-fiber equivalent.  2/ Includes headgear.
Last update:  08/13/12.
Sources: USDA, Economic Research Service; and USDC,
U.S. Census Bureau.
Spreadsheet: eric_saibi__9726__010902R
Sheet: Scherer 02

Owner Name |  | Oglethorpe Power Company
Station Name |  | Scherer Power Station
Unit Name |  | Scherer 02
NERC Region |  | SERC
State |  | GA
Fuel Type |  | Coal
Capacity |  | 891 MW
Start Date |  | 2002-01-08 00:00:00
End Date |  | 2002-01-09 00:00:00
Prv. Start Date |  | 2002-01-08 00:00:00
Prv. End Date |  | 2002-01-10 00:00:00
Comments |  | Boiler Leak
SIC |  | 4911
Plant ID |  | 1014200
Unit ID |  | 1005653
Outage ID |  | 19402
Spreadsheet: 298655d1392856413-totals-items-per-unqiue-id-count
Sheet: Sheet1

11111 | Basketball |  | 11111 |  | Basketball
11111 | Basketball |  | 33333 |  | Baseball
11111 | Basketball |  | 22222 |  | Hockey
33333 | Baseball
33333 | Baseball
22222 | Hockey
Spreadsheet: 794713d1662239245-find-cell-address-in-single-row-for-last-non-blank-value-not-the-highest-value-sample-hd-1-
Sheet: Sheet1

Doors | Refinish | Last value in row | Last value in row | 2011
 | Door | HD |  | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 123 |  |  |  |  |  |  |  |  |  | 245
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 123 |  |  |  |  |  |  |  |  |  |  | 125 |  |  |  |  | 245
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 120 |  |  |  | 245 |  |  |  |  |  |  |  |  | 245
 |  |  |  | 245 |  |  |  |  |  |  |  |  |  |  |  |  |  | 106 | 245 |  |  |  |  |  |  |  |  | 245
 |  |  |  | 245 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 245 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 104
 |  |  |  |  |  |  | 245 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 172
Spreadsheet: 069f7f65-baa3-4566-a5d4-30679e57f34c
Sheet: 울산광역시

사회서비스 제공기관 등록 현황 파악 양식 (행복e음 통해 등록완료 후 전송된 데이터 기준)
* 2012.8.5~2012.11.4 기간 동안 등록제로 등록 전송한 제공기관 현황
시도 | 사업구분 | 제공기관명 | [NAME] | 연락처 | 대표자(제공기관장)
울산광역시 | 산모신생아 | (사)한국지역자활센터협회 울산지부 | 울산광역시 남구 신정동 1100번지 11호 외2필지 | [PHONE] | 허달호
울산광역시 | 산모신생아 | 울산여성인력개발센터 | 울산광역시 남구 신정동 526번지 3호 | [PHONE] | [NAME]
울산광역시 | 산모신생아 | 인구보건복지협회울산광역시지회 | 울산광역시 남구 봉월로 63 | [PHONE] | 이문희
울산광역시 | 산모신생아 | 참사랑어머니회 울산지점 | 울산광역시 남구 달동 876번지 6호 소전빌딩 201호 | [PHONE] | 박경원
Spreadsheet: 79892d1280154877-selection-with-non-following-lines-test
Sheet: Sheet1

Sum of Stock units sold
Date | Coupon | Descrip | Title | Total
2007-01-03 00:00:00 | 452 | Product A | The Lady Magazine | 72
2007-01-07 00:00:00 | 453 | Product A | Mail on Sunday (Scotland) | 167
2007-01-16 00:00:00 | 454 | Product A | Woman's Weekly | 559
2007-01-19 00:00:00 | 455 | Product A | Saga Magazine | 1072
2007-01-31 00:00:00 | 466 | Product A | Woman's Weekly | 379
2007-02-01 00:00:00 | 459 | Product A | People's Friend | 298
 | 460 | Product A | Countryside Magazine NFU | 55
2007-02-13 00:00:00 | 474 | Product B | Yours Magazine | 598
2007-02-24 00:00:00 | 473 | Product B | Guardian Magazine | 188
 | 476 | Product B | Saturday Express Magazine | 480
2007-03-01 00:00:00 | 462 | Product A | Osteoporosis News | 228
 | 475 | Product B | Countryside Magazine NFU | 54
2007-03-03 00:00:00 | 481 | Product B | People's Friend | 430
2007-03-10 00:00:00 | 495 | Product B | Guardian Magazine | 264
2007-03-13 00:00:00 | 494 | Product B | Yours Magazine | 334
2007-03-19 00:00:00 | 496 | Product B | Countryside Magazine NFU | 52
2007-03-21 00:00:00 | 480 | Product B | Stroke News | 80
2007-03-24 00:00:00 | 482 | Product B | Arthritis News | 1
2007-04-07 00:00:00 | 513 | Product B | Saturday Express Magazine | 409
2007-04-08 00:00:00 | 502 | Product A | Take it easy mag, (S.People) | 286
2007-04-10 00:00:00 | 515 | Product B | The Lady Magazine | 51
2007-04-11 00:00:00 | 497 | Product B | Arthritis Today | 271
2007-04-17 00:00:00 | 500 | Product B | Woman's Weekly | 588
2007-04-20 00:00:00 | 505 | Product B | Saga Magazine | 628
2007-04-21 00:00:00 | 499 | Product B | People's Friend | 422
2007-05-12 00:00:00 | 518 | Product B | People's Friend | 355
Spreadsheet: 868393d1715148149-combine-multiple-xlookups-with-multiple-if-statements-ifs-with-xlookup-query-b
Sheet: Sheet1

 | PO | WBS | CE | DT | Account
 | 3106050272 | N-0500100.24.03.06 | 422010
 |  | N-0500100.24.03.06 | 422000 | YD
 |  | [NAME] | 422005 |  |  |  | Lookup 1 |  |  | [NAME] |  |  | Lookup 3
 |  | N-0500100.24.03.08 | 422006
 | 3106050273 |  |  |  |  |  | 422010 | 24.23.03.06 |  | N-0500100.24.03.06 | 24.23.03.06 |  | 3106050273 | 24.23.03.06
 |  |  |  |  |  |  | 422005 | 24.23.03.07 |  | N-0500100.24.03.08 | 24.23.03.08
Spreadsheet: chris_dorland__1611__Forwards Detail-MIRANT_JAN17
Sheet: Pivot

Sum of Value
Deal Num | Total
(blank)
QP7039.1 | 1412245.7082
V64794.1 | -1916361.9974
V67831.1 | -1515354.3311
V70968.1 | -1215600.4028
V92532.1 | -176196.4359
V98653.1 | 2137850.3704
VB4050.1 | 5589347.220800001
VC5783.3 | 10275757.976
VD3558.1 | 8702900.906600002
VF2542.1 | -278549.013
[NAME] | -1659367.1261
VG9103.1 | 5599.810399999996
VH0021.1 | 1651948.7814
VQ9540.1 | -962042.7082
VT2543.1 | 370492.4573
VT5299.1 | 156503.7423
Y46805.1 | 10537900.8207
Y92833.1 | -495022.9119000001
YA7382.1 | -274862.2172
YA7382.2 | 203354.7106
YA7593.1 | -441921.3370999999
YA7593.2 | 378335.4583
YA8854.1 | -431323.7015999998
YA8854.2 | 378335.4583
YC1650.1 | -20302.4627
YE3026.1 | -673563.6668
YF5957.1 | -66856.562
YF5957.2 | 56150.8605
Y52420.1 | -2234.6381
Y52471.1 | -1675.8948
Y81297.1 | -4141.9802
Grand Total | 31721346.89490001
Spreadsheet: 848095d1698889176-how-to-create-multiple-similar-looking-pie-charts-for-variety-of-data-kpis
Sheet: Sheet1

 |  |  |  |  |  |  | KPI 1 | KPI 2 | KPI 3 | [NAME] | KPI 5 | KPI 5 | KPI 6 | KPI 7
 |  |  |  |  |  |  | 7 | 5 | 6 | 5 | 6 | 6 | 4 | 6
 |  |  |  |  |  |  | 6 | 6 | 5 | 5
 |  |  |  |  |  |  | 6 | 6 | 6 | 6 | 6 |  | 6 | 6
 |  |  |  |  |  |  | 2 | 5 | 5 | 4 | 6 | 6 | 4 | 6
 |  |  |  |  |  |  | 6 | 5 | 6 | 6 | 6 | 6 | 6 | 6
 |  |  |  |  |  |  | 7 | 6 | 6 | 6 | 7 | 7 | 4 | 6
 |  |  |  |  |  |  | 6 | 5 | 6 | 5 | 5 | 4 | 5 | 6
 |  |  |  |  |  |  | 7 | 5 | 6 | 7 | 4 |  |  | 6
 |  |  |  |  |  |  | 4 | 6 | 6 | 6 | 6 |  | 3 | 6
 |  |  |  |  |  |  | 7 | 6 | 6 | 6 | 6 | 6 | 6 | 6
 |  |  |  |  |  |  | 7 | 7 | 6 | 7 | 7 | 6 | 6 | 6
 |  |  |  |  |  |  | 7 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 |  |  |  |  |  |  | 7 | 7 | 7 | 7 | 6 | 6 | 7
 |  |  |  |  |  |  | 7 | 5 | 4 | 4 | 5 | 5 | 5 | 5
Spreadsheet: 63883d1264738403-map-data-from-multiple-columns-map-data-from-multiple-columns
Sheet: For Mapping

Contatc No. | My Formual | Expected Result
9810332270 |  | 9810332270
8022293746 |  | 8022293746
8022946914 |  | 8022946914
8023648189 |  | 8023648189
8025323519 |  | 8025323519
8026687004 |  | 8026687004
8041653108 |  | Not In the List
8050703529 |  | 8050703529
8050713804 |  | 8050713804
8050940281 |  | Not In the List
8055782954 |  | 8055782954
8088208554 |  | 8088208554
8088227204 |  | 8088227204
8093361841 |  | 8093361841
8099278016 |  | 8099278016
8105710007 |  | Not In the List
8123534516 |  | 8123534516
8125531112 |  | 8125531112
Spreadsheet: 154703d1336521300-need-to-show-rows-w-certain-data-on-2nd-sheet-with-no-gaps-inspection-master-to-share-
Sheet: Print Tag

True Home Energy Solutions |  |  |  |  |  |  |  |  |  |  |  | Job Status
Energy Inspection Form
Builder: |  |  |  |  |  |  |  | Date:
Address: |  |  |  |  |  |  |  | Inspector(s):
Subdivision: |  |  |  |  |  |  |  | Plan:
City: |  |  |  |  |  |  |  | Stage:
Trip: |  |  |  |  |  | Builder Contact: |  |  |  |  |  | Program:
Failure Notes
 | Code for failures |  |  |  |  |  |  |  |  |  |  |  |  | IECC 2009 | Energy Star V3.0
 | See my formula in these cells, if a line item fails, it & the code number show up
 | all the "99's" is just to show the "false" part of the IF function
Spreadsheet: 781783d1653549934-need-formula-to-count-table-range-depending-on-conditions-in-selected-table-columns-new-smaple
Sheet: Fighter1

Summary
Style | Won:Lost | Number Of Hits | Number Of Misses | Basic Defense
Aggressive |  | 16 | 1
Defensive
Accurate
Balanced
 |  |  |  | Hit points:
Date | Result | Style | Attack Defense | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
May 14, 2022 2:00am | Lost | Aggressive | Attack | 140 | 100 | 113 | 81 | 99 | 106 | MISS | 146
 |  |  | Defence | -144 | -180 | MISS | -116 | -185 | -151 | -181 | -147
May 13, 2022 10:30pm | Lost | Defensive | Attack | 177 | 85 | 141 | 137 | 138 | 47 | 182
 |  |  | Defence | -66 | -293 | -89 | -286 | MISS | MISS | -110
May 13, 2022 6:30pm | Lost | Accurate | Attack | 118 | 88 | MISS | 143 | 83 | 178 | 127 | MISS | 90 | 60 | 107
 |  |  | Defence | -124 | -99 | -142 | -58 | -110 | -106 | -85 | -11 | -187 | MISS | -107
May 13, 2022 6:30pm | Won | Aggressive | Attack | 121 | 144 | 198 | 85 | 114 | 107 | 31 | 182 | 98
 |  |  | Defence | -71 | MISS | -99 | -129 | -100 | -73 | MISS | -230
Spreadsheet: 493899d1481936410-filtering-combined-items-within-a-given-set-of-rows-in-pivot-table-copy-of-copy-of-sample-workbook-2
Sheet: Pivot Table (After)

EMP NAME | PAY PERIOD | DATE | DESCR | Sum of HOURS | Sum of AMT | Sum of All Breaks | Sum of ADJ HOURS | Sum of Average Pay | Sum of Paid
[NAME] | 07/01/12-07/07/12 | 2012-07-02 00:00:00 | Hourly | 8 | 64 | 0.33 | 7.67 | 8.34419817470665 | 2.64
[NAME] | 07/01/12-07/07/12 | 2012-07-03 00:00:00 | Hourly | 9 | 64 | 1.33 | 7.67 | 9.34419817470665 | 10.64
[NAME] | 07/01/12-07/07/12 | 2012-07-05 00:00:00 | Hourly | 2 | 10.08 | 0 | 2 | 0 | 0
[NAME] | 07/01/12-07/07/12 Total |  |  | 19 | 138.08 | 1.66 | 17.34 | 17.6883963494133 | 13.28
[NAME] 2 | 07/01/12-07/07/12 | 2012-07-02 00:00:00 | Hourly | 8 | 76.6 | 0.33 | 7.67 | 8.34419817470665 | 2.64
[NAME] 2 | 07/01/12-07/07/12 Total |  |  | 8 | 76.6 | 0.33 | 7.67 | 8.34419817470665 | 2.64
[NAME] | 07/01/12-07/07/12 | 2012-07-02 00:00:00 | Salary | 8 | 84.72 | 0.33 | 7.67 | 8.34419817470665 | 2.64
[NAME] | 07/01/12-07/07/12 | 2012-07-04 00:00:00 | Salary | 0 | 10.36 | 0 | 0 | 0 | 0
[NAME] | 07/01/12-07/07/12 Total |  |  | 8 | 95.08 | 0.33 | 7.67 | 8.34419817470665 | 2.64
[NAME] | 07/01/12-07/07/12 | 2012-07-02 00:00:00 | Piece Rate | 8 | 71.28 | 0.33 | 7.67 | 8.34419817470665 | 0
[NAME] | 07/01/12-07/07/12 Total |  |  | 8 | 71.28 | 0.33 | 7.67 | 8.34419817470665 | 0
[NAME] | 07/01/12-07/07/12 | 2012-07-02 00:00:00 | Hourly | 8 | 64 | 0.33 | 7.67 | 8.34419817470665 | 2.64
[NAME] | 07/01/12-07/07/12 | 2012-07-02 00:00:00 | Piece Rate | 0 | 12.6 | 0 | 0 | 0 | 0
[NAME] | 07/01/12-07/07/12 Total |  |  | 8 | 76.6 | 0.33 | 7.67 | 8.34419817470665 | 2.64
[NAME] | 07/01/12-07/07/12 | 2012-07-02 00:00:00 | Hourly | 8 | 64 | 0.33 | 7.67 | 8.34419817470665 | 2.64
[NAME] | 07/01/12-07/07/12 | 2012-07-02 00:00:00 | Piece Rate | 0 | 8.4 | 0 | 0 | 0 | 0
[NAME] | 07/01/12-07/07/12 Total |  |  | 8 | 72.4 | 0.33 | 7.67 | 8.34419817470665 | 2.64
[NAME] | 07/01/12-07/07/12 | 2012-07-02 00:00:00 | Hourly | 8 | 73.24 | 0.33 | 7.67 | 8.34419817470665 | 2.64
[NAME] | 07/01/12-07/07/12 Total |  |  | 8 | 73.24 | 0.33 | 7.67 | 8.34419817470665 | 2.64
[NAME] | 07/01/12-07/07/12 | 2012-07-02 00:00:00 | Piece Rate | 0 | 8.96 | 0 | 0 | 0 | 0
[NAME] | 07/01/12-07/07/12 | 2012-07-02 00:00:00 | Salary | 8 | 64 | 0.33 | 7.67 | 8.34419817470665 | 2.64
[NAME] | 07/01/12-07/07/12 Total |  |  | 8 | 72.96000000000001 | 0.33 | 7.67 | 8.34419817470665 | 2.64
Spreadsheet: 122750d1317130293-date-count-by-month-with-multiple-criteria-multiple-date-ranges
Sheet: Sheet1

 | Date | Status
 | 2011-01-01 00:00:00 | 50
 | 2011-01-02 00:00:00 | 60
 | 2011-04-01 00:00:00 | 50
 | 2011-01-01 00:00:00 | 300
 | 2011-04-01 00:00:00 | 300
 | 2011-01-01 00:00:00 | 60
 | 2011-01-01 00:00:00 | 50
 | 2011-01-01 00:00:00 | 300
 | 2011-06-01 00:00:00 | 300
 | 2011-01-01 00:00:00 | 60
 | 2011-06-01 00:00:00 | 50
2012-06-01 00:00:00 | 2011-06-01 00:00:00 | 60
 | 2011-01-01 00:00:00 | 300
 | 2011-01-01 00:00:00 | 300
 | 2011-04-01 00:00:00 | 300
Spreadsheet: geir_solberg__11279__Dispatch
Sheet: Dispatch

Brief Scenario Description:
Obligations:     HE (MST) | 1 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 5 |  |  | 6 |  |  | 7 |  |  | 8 |  |  | 9 |  |  | 10 |  |  | 11 |  |  | 12 |  |  | 13 |  |  | 14 |  |  | 15 |  |  | 16 |  |  | 17 |  |  | 18 |  |  | 19 |  |  | 20 |  |  | 21 |  |  | 22 |  |  | 23 |  |  | 24 |  |  | Total
Projected Native Load:
Other Control Area Load:
TNP:
IID:
PNM Contingent:
Other WSCC Load:
System Load
Preschedules:
Monthly Net PV Preschedule:
Monthly Net FC Preschedule:
Daily PV Preschedule:
Daily FC Preschedule:
[NAME]:
WSCC Purchase (-) / Sale (+):
Sales to Minimize Swing on Units:
Real-Time PV Cost Basis Sales:
Real-Time FC Cost Basis Sales:
Total Obligations
Remote Resources:
FC Unit 4:
FC Unit 5:
PV Unit 1:
PV Unit 2:
PV Unit 3:
Local Resources:
NM1
NM1 Spin
NM2
NM2 Spin
NM3
NM3 Spin
1GT
GT1 Spin
2GT
[NAME]
[NAME]
[NAME]
GT2ST
GT2ST Spin
NM4
NM4 Spin
RG6
[NAME]
RG7
RG7 Spin
RG8
[NAME]
Copper
Copper Spin
Total Local Generation
Real-Time Purchases:
EDDY TIE Purchase
PV Purchase
FC Purchase
Reserves:
Spinning Reserves:
Non-Spinning Reserves:
Contingent Reserves:
Required Spinning Res:
Required Contingent Res:
Reserves Required (+); Excess (-):
WSCC Reserv. Purch (+); SNMI Sale(-):
Eddy or SNM Reserv. Purch (+):
EPE SNM Imports:
Position
Real-Time PV Sales:
Real-Time FC Sales:
Newman Gas Burn (mmbtu):
Rio Grande Gas Burn (mmbtu):
Copper Gas Burn (mmbtu):
 |  |  |  |  |  |  |  |  |  | HE 1:00 - 7:00 |  |  |  |  |  | Newman |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HE 8:00- 24:00 |  |  |  |  |  | Newman
NOTES: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rio Grande |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rio Grande
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Copper |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Copper
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: 878317d1725386836-vba-filter-names-from-list-one-by-one-and-then-saved-filtered-data-vba-filter-names-from-list-one-by-one-and-then-save-filtered-data
Sheet: Sheet1

 |  | Date | Amount | Name
 |  | 9/28/2022 | 5 | A
 |  | 9/28/2022 | 5 | A
 |  |  | 10 | B
 |  | 9/29/2022 | 10 | B
 |  | 9/30/2022 | 15 | C
 |  | 9/30/2022 | 15 | C
 |  | 2022-01-10 00:00:00 | 20 | D
 |  | 2022-01-10 00:00:00 | 20 | D
 |  |  | 25 | E
 |  | 2022-02-10 00:00:00 | 25 | E
 |  |  |  | Total Quantity
 |  |  |  | Total Amount
 |  |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  |  | E