tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 742917d1628113301-finding-column-header-and-value-of-first-column-based-on-maximum-value-of-range-sample
Sheet: Sheet1

Sample Data
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2010 | 34980 | 34438 | 48834 | 42360 | 42487 | 47140 | 50118 | 44497 | 41675 | 43533 | 40703 | 40748
2011 | 37290 | 33354 | 48180 | 40090 | 39388 | 48511 | 49247 | 45395 | 43631 | 46196 | 41274 | 41017
2012 | 37103 | 39990 | 53618 | 48377 | 49510 | 53515 | 54073 | 52341 | 47026 | 51845 | 47623 | 45509
2013 | 42673 | 43054 | 56145 | 46709 | 52099 | 54222 | 54142 | 52011 | 46830 | 49629 | 46413 | 48174
2014 | 43015 | 42673 | 59021 | 55683 | 56620 | 59373 | 57256 | 55856 | 51820 | 54580 | 50790 | 52783
2015 | 46944 | 43802 | 60750 | 53241 | 55014 | 59939 | 61156 | 55397 | 50176 | 53840 | 50849 | 51092
2016 | 44639 | 45806 | 58736 | 49896 | 52581 | 58746 | 56485 | 49098 | 50119 | 53373 | 52769 | 50886
2017 | 48847 | 47385 | 61199 | 49156 | 52898 | 59879 | 57238 | 49726 | 46264 | 56290 | 55146 | 51138
2018 | 48544 | 47192 | 62645 | 54880 | 60261 | 64784 | 62750 | 56015 | 50639 | 58282 | 55363 | 51239
2019 | 46079 | 49094 | 64649 | 59321 | 61848 | 65919 | 68447 | 56639 | 50282 | 56810 | 54000 | 56328
2020 | 51436 | 52825 | 36343 | 2928 | 11716 | 21344 | 26577 | 22698 | 22494 | 27836 | 24904 | 25760
2021 | 20781 | 22606 | 37215 | 32386 | 36523 | 52863 | 0 | 0 | 0 | 0 | 0 | 0
Desired Output
 | Best Month/Year: | Jul 2019
Spreadsheet: mary_fischer__25717__Consolidated of 890 20Q 20R 1572
Sheet: August

Enron Energy Services
MTM Summary
Companies 1572, 890, 20Q, 20R
September, 2001
Balance Sheet Look
 |  |  |  | Beginning |  |  |  | Ending
COMPANY |  | Account MSA/SAP |  | Balance |  | Change |  | Balance
1572 |  | 20004000- N/R |  | 0 |  |  |  | 28789243
1572 |  | 20029200- A/R Third Parties |  | 0 |  |  |  | 6327530
1572 |  | 25100000- PRM Assets- NonCurrent |  | 0 |  |  |  | 237313254
1572 |  | 25100300- Prudency Reserve |  | 0 |  |  |  | -16338160
890 |  | 21060000- PRM Asset- Current |  | 50493145 |  |  |  | 247916983
890 |  | 25100000- PRM Asset- NonCurrent |  | 587035369 |  |  |  | 920137744
890 |  | 25100100- Credit Reserve |  | -55096987 |  |  |  | -128666876
890 |  | 25100200- Prudency Reserve |  | 831595 |  |  |  | -45328159
890 |  | 25100300- Prudency Reserve |  | 0 |  |  |  | 16338160
890 |  | 30300000- PRM Liability- Current |  | -448393114 |  |  |  | -95774047
890 |  | 33100000- PRM Liability- NonCurrent |  | -115116482 |  |  |  | -763809632
20Q |  | 21060000- PRM Asset- Current |  | 1277047002 |  |  |  | 338960789
20Q |  | 25100000- PRM Asset- NonCurrent |  | 196011309 |  |  |  | 256890841
20Q |  | 25100100- Credit Reserve |  | 0 |  |  |  | 5077116
20Q |  | 25100200- Prudency Reserve |  | 12033165 |  |  |  | -2259285
20Q |  | 25100300- Prudency Reserve |  | 0 |  |  |  | -35321108
20Q |  | 30300000- PRM Liability- Current |  | -1247510983 |  |  |  | -295061786
20Q |  | 33100000- PRM Liability- NonCurrent |  | -155003635 |  |  |  | -165768597
20R |  | 21060000- PRM Asset- Current |  | 31910438 |  |  |  | 0
 |  |  |  |  |  | Ending
 |  | Account |  |  |  | Balance
1572 |  | No MTM Income Accounts
890 |  | 42000000- Unrealized MTM Revenue |  |  |  | -309214619
20Q |  | 42000000- Unrealized MTM Revenue |  |  |  | -28614176
20R |  | 42000000- Unrealized MTM Revenue |  |  |  | -39862556
 |  | Difference
 |  | The $20 million difference is due to error made at EOY last year.  Separate entry has been made to address this
 |  | error.
Spreadsheet: 889677d1740582057-calculating-pick-errors-with-yes-no-test-pick-data
Sheet: Main

 | January |  |  |  |  |  |  | Febuary |  |  |  |  |  |  | March |  |  |  |  | April |  |  |  |  | May |  |  |  |  | June |  |  |  |  | July |  |  |  |  | August |  |  |  |  | September |  |  |  |  |  |  | October |  |  |  |  | Novemeber |  |  |  |  | December
NAME | Completed | Pick Units | Pick Cases | Pick Errors | P'K Accuracy | Units Errors | Unit [NAME] | Completed | Pick Units | Pick Cases | Pick Errors | P'K Accuracy | Units Errors | [NAME] | Completed | Pick Units | Pick Cases | Units Errors | [NAME] | Completed | Pick Units | Pick Cases | Units Errors | [NAME] | Completed | Pick Units | Pick Cases | Units Errors | [NAME] | Completed | Pick Units | Pick Cases | Units Errors | [NAME] | Completed | Pick Units | Pick Cases | Units Errors | [NAME] | Completed | Pick Units | Pick Cases | Units Errors | [NAME] | Completed | Pick Units | Pick Cases | Pick Errors | P'k Accuracy | Units Errors | [NAME] | Completed | Pick Units | Pick Cases | Units Errors | [NAME] | Completed | Pick Units | Pick Cases | Units Errors | [NAME] | Completed | Pick Units | Pick Cases | Units Errors | [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Ava Sinclair |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME]
[NAME]
[NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: errol_mclaughlin_jr__10123__Curveload_Mercado
Sheet: Gas Swap Model

 | Gas Swap Model |  |  |  |  |  | MMBtu/day 1 | Basis | Index | Cost of Funds | INPUT
Start Date | Stop Date | [NAME] | Curve Date | Term | Phy1 Fin2 | Buy1 Sell2 | MMBtu/month 2 | Delivery Pt. | Delivery Pt. | Adjustment (bp) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Origination Value |  |  |  |  | Desk Value
2000-07-01 00:00:00 | 2015-12-01 00:00:00 |  |  |  | 2 | 2 | 1 | IF-HPL/SHPCHAN | IF-HPL/SHPCHAN | 0
 |  |  | TOTAL | Real | PV | NG-P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Accum | LIBOR-AA |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NYMEX | BASIS | INDEX | TOTAL |  | NYMEX | Basis | INDEX | TOTAL
Delivery |  |  |  | Monthly | Monthly | Nymex | Nymex | Nymex | Basis | Basis | Basis | Index | Index | Index |  | Total | Total | Total |  | Calendar | Discount | Discount | Libor | Discount | Active | Active |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | TOTAL
Month | MMBtu |  | MMBtu | MMbtu | MMbtu | Mid |  | Contract | Mid |  | Contract | Mid |  | Contract |  | Mid |  | Contract |  | Days | Date | Days | AA | Factor | Months | Days |  |  |  |  |  |  |  |  |  |  |  | Value | Value | Value | Value |  | Value | Value | Value | Value |  | VALUE |  | Contract
SWAP PRICE
 | 15000
Spreadsheet: 102461d1300388829-how-to-make-pivot-table-from-data-with-multiple-layers-test-book-pivot
Sheet: Sheet1

 |  | Feb | Jan | Dec | Nov
 | Produce | 100 | 200 | 150 | 180
 | Fruits & Veg | 80 | 120 | 70 | 110
 | Fruits | 40 | 80 | 35 | 90
 | Apples | 20 | 42 | 25 | 55
 | Veg | 40 | 40 | 25 | 20
 | Cucumbers | 30 | 25 | 15 | 10
Spreadsheet: 274418d1383112443-can-i-filter-this-differently-filter-excel-fourm
Sheet: Sheet1

 |  |  |  | 2 | 2
 |  |  |  | 2 | 2 | I want to able to filter say rows 18,19,20 column E
 |  |  |  | 2 | 2 | or rows 5,6,7,8.  Is this possible?
 |  |  |  | 2
 |  |  |  | 8
 |  |  |  | 2
 |  |  |  |  | 6
 |  |  |  | 4
 |  |  |  | 2 | 2
 |  |  |  | 4
 |  |  |  | 2 | 2
 |  |  |  | 2 | 10
 |  |  |  | 4 |  |  | say I wanted to search for the |  |  | 4
 |  |  |  | 4 |  |  | following.  Is that possible? |  |  | 8 | 2
 |  |  |  |  | 2 |  |  |  |  | 4
 |  |  |  | 8
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 16 | 4
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 24 | 24
 |  |  |  | 2
 |  |  |  | 6
 |  |  |  | 2 | 4
 |  |  |  | 6
Spreadsheet: eric_saibi__9986__112601R
Sheet: Big Brown 02

Owner Name |  | TXU Electric
Station Name |  | Big Brown Power Station
Unit Name |  | Big Brown 02
NERC Region |  | ERCOT
State |  | TX
Fuel Type |  | Coal
Capacity |  | 593 MW
Start Date |  | 2001-10-22 00:00:00
End Date |  | 2001-11-29 00:00:00
Prv. Start Date |  | 2001-10-22 00:00:00
Prv. End Date |  | 2001-11-18 00:00:00
Comments |  | [NAME] have some additional problems
SIC |  | 4911
Plant ID |  | 1013314
Unit ID |  | 1008519
Outage ID |  | 9160
Spreadsheet: 767750d1644604663-need-help-making-a-formula-for-chance-of-all-combinations-of-set-1-set-2-k-over-under-calculation-n0043-
Sheet: Sheet1

K: | 200 | GS/UJ | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 113 | 114 | 115 | 116 | 117 | 118 | 119 | 120 | 121 | 122 | 123 | 124 | 125 | 126
% X>K |  | 79
 |  | 80
 |  | 81
 |  | 82
 |  | 83
 |  | 84
 |  | 85
 |  | 86
 |  | 87
 |  | 88
 |  | 89
 |  | 90
 |  | 91
 |  | 92
 |  | 93
 |  | 94
 |  | 95
 |  | 96
 |  | 97
 |  | 98
 |  | 99
 |  | 100
 |  | 101
 |  | 102
 |  | 103
 |  | 104
 |  | 105
 |  | 106
 |  | 107
 |  | 108
 |  | 109
 |  | 110
 |  | 111
 |  | 112
 |  | 113
 |  | 114
 |  | 115
 |  | 116
 |  | 117
 |  | 118
 |  | 119
 |  | 120
 |  | 121
 |  | 122
 |  | 123
 |  | 124
 |  | 125
 |  | 126
 |  | 127
 |  | 128
 |  | 129
 |  | 130
 |  | 131
 |  | 132
Spreadsheet: 81944d1282052952-set-up-ongoing-copying-from-one-sheet-to-another-sheet-in-same-workbook-example-1111111111-
Sheet: Sheet3

list |  | 114
4041300001
4041300002
4041300003
4041300004
4041300005
4041300006
4040700001
4041300007
4041300008
4041300009
4041300010
4040700002
4041300011
4041300012
4041300013
4041300014
4040700003
4041300015
4041300016
4040700004
4040700005
4042100001
4041600001
4040800001
4040800002
4040700006
4040700007
4040700008
4040700009
4042000001
4042100002
4041600002
4040800003
4040800004
4040700010
4040700011
4040900001
4040900002
4040900003
4040900004
4040900005
4040900006
4040900007
4040900008
4040900009
4040900010
4040900011
4040900012
4040900013
4040900014
4040900015
4040900016
4040900017
4040900018
4040900019
4041700001
4041700002
4041700003
4041300017
4041300018
4040900020
4040900021
4041300019
4041300020
4041300021
4041300022
4040900022
4040900023
4041300023
4041300024
4041300025
4041300026
4040900024
4040900025
4041300027
4041300028
4040700012
4040700013
4040700014
4040700015
4040700016
4041500001
4041500002
4040700017
4040700018
4040700019
4040700020
4040900026
4040900027
4041700004
4040900028
4041700005
4040900029
4040900030
4042100003
4042100004
4042100005
4042100006
4042100007
4042100008
4042100009
4042100010
4042100011
4042100012
4042100013
4042100014
4042100015
4042100016
4042100017
4042100018
4042100019
4042100020
4042100021
4042100022
Spreadsheet: 275102d1383327076-n-a-error-lean-to-installs
Sheet: Sheet1

LEAN TO |  |  |  | width | 4.5 | depth | 3.6 |  | YES
WIDTH | 2.5 | 3 | 3.5 | 4 | 4.5 | 5 | 5.5 | 6 | 6.5 | 7
DEPTH
2.5 | 672 | 672 | 804 | 936 | 936 | 1068 | 1068 | 1200 | 1200 | 1332
3 | 672 | 804 | 870 | 1002 | 1002 | 1134 | 1134 | 1272 | 1272 | 1404
3.5 | 804 | 870 | 936 | 1068 | 1134 | 1200 | 1200 | 1200 | 1320 | 1464
4 | 939 | 1002 | 1068 | 1134 | 1200 | 1272 | 1272 | 1320 | 1320 | 1464
Spreadsheet: 2fdf3abe-4092-4ea7-9097-eef2a72769f5
Sheet: EQUIP_MASTER

Assessment  Date | Building Portfolio | Building Site | Building ID | Building Abbr | Building Name | Floor | Room | Keyword | Equipment Group/Keyword | EQ_Type | Equipment Type | Status | Condition  (at assessment) | Field Notes | Area Serviced (Bldg/Floor/Wing/Room) | Criticality | EQ_Group | Nomenclature | len | EQ_ID |  | State_ID | Parent [NAME] | Old EQ_ID (If Existing) | Existing In-Field Equipment Reference Name | MFR | Manufacturer | [NAME] No | Mfr Serial No | Mfr Part No/Date | Acquisition Date | Acquisition Vendor | Acquisition Comments | Warranty Vendor | Warranty Expiration Date | Warranty Usage Expiration | Warranty Comments | Replacement Cost | Replacement Cost Date | Spec (FILTER) | Spec (BELTs) | Spec (MOTOR) | Spec (MECH COUPLINGS  & SEALS) | Spec (REFRIGERANT) | Spec (HP) | Spec (RPM) | Spec (CFM) | Spec (TONS) | Spec (BTU/Hr) | Spec  (STATIC PRESSURE) | [NAME](HEAD-FEET or TOTAL [NAME] HEAD (TDH) | Spec (PHASE) | Spec (GPM) | Spec (MBH) | Spec (PSI) | Spec  (AIR TEMP IN/OUT) | Spec  (WATER TEMP IN/OUT) | Spec (GALLONS) | Spec (KVA) | Spec (VOLTS) + (WIRE) | Spec (AMPS) + (MAIN LUG or BREAKER) (OPEN or CLOSED) | Spec  (MAX FUSE) | Spec (CIRCUITS) | Spec (POLES) | Spec (HERTZ) | Spec (WATTS) | Spec (MCA) | Spec (OTHER) | Service Guide | Expected Life | Account | Rental Type | Rental | Mileage Rate | Overall rating
2013-01-01 00:00:00 |  |  |  |  | UNIVERSITY HALL | 0 | 001 |  | AIR HANDLING UNIT |  | AIR HANDLER, HVAC > 30K CFM | ACTIVE | VERYGOOD | UNIT INCLUDES COMBINED HRU | 1st & 2nd floor |  |  |  |  |  | 001 |  |  |  | AHU-1 |  | HAW'S PRODUCTS | [NAME] | 472010C08248-04 | MFR DATE: 11/15/2010 | 2012-01-10 00:00:00 | RI AHU SUPPLY |  |  | 2015-01-10 00:00:00 |  | 3 YEARS PARTS & LABOR |  | 2012 | PRE FILTER (6) 24X24X4 30/30 FINAL FILTER (6) 24X24X12 DURAFIL ESB |  |  |  |  |  |  | 7500 RETURN CFM 7500 SUPPLY CFM
2013-01-01 00:00:00 |  |  |  |  | UNIVERSITY HALL | 0 | 001 |  | FAN |  | FAN, SUPPLY, BELT | ACTIVE | VERYGOOD | GREASE FITTING ON MOTOR | 1st floor commons |  |  |  |  |  |  |  | 182AHUHVLG-001 |  | SF-1 |  | GREENHECK | 22-QEP-4-60-11 | [PHONE] |  |  |  |  |  |  |  |  |  |  |  | BELT 4L490 (A47) | MOTOR SERIAL# M09P011X717G1 MOTOR CAT# M29J102118889-003 FRAME 254T | A33 |  | 15 HP MOTOR |  | 7500 [NAME]
Spreadsheet: 764867d1643043750-need-to-have-formula-use-its-own-result-in-same-formula-cell-x-times-returns_example
Sheet: Sheet1

 |  |  | Bonus Return
Base Return | 0.01 |  | > 3 Days | > 7 Days | > 15 Days
 |  |  | 1.05 | 1.2 | 1.4
Start | 25000
Days Estimate | 16
 | Daily Return | Accumulated Amount
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15 |  |  | Final Est:
16
Spreadsheet: 96612d1295976977-conditional-formatting-help-strikethrough
Sheet: Sheet1

A | B | C | D | E | F | G | H | I | J | K | L | M
Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script
Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script |  | Test Script | Test Script | Test Script | Test Script
Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Example | Test Script | Test Script | Test Script | Test Script
Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script
Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script
Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | 45 | Test Script | Test Script | Test Script | Test Script
Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script
Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script |  | Test Script | Test Script | Test Script | Test Script
Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script |  | Test Script | Test Script | Test Script | Test Script
Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script
Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script
Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | 1258 | Test Script | Test Script | Test Script | Test Script
Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script
Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script | Test Script
Spreadsheet: 713095d1610553694-data-transfer-from-one-worksheet-to-others-golf-group-composite-spreadsheet2
Sheet: Jan 27th Tourn

 |  | SUNDAY |  | DATE: | 2021-01-27 00:00:00
 | X | WEDNESDAY
 |  | Team #1 |  | [NAME] | Strokes |  | GAME |  |  | To make record permanent
 | 1 | [NAME] |  | 104 | 15 |  |  | Regular Stroke Play |  |  | Click on intersection between row and column headers
 | 2 | [NAME] |  | 100 | 9 |  | X | Match Play
 | 3 | Al |  | 99.33333333333333 | 8 |  |  | Stableford
 | 4 | [NAME] |  | 95.66666666666667 | 6 |  |  | 2-Man Scramble
 | 5 | [NAME] |  | 95.5 | 6 |  |  | 3-Man Scramble
 |  |  |  |  |  |  |  | 4-Man Scramble
 |  | Team #2 |  | [NAME] | Strokes |  | SCORING
 | 1 | [NAME] |  | 94 | 0 |  |  | 1 Low Score |  |  | Copy
 | 2 | [NAME] |  | 93 | 0 |  | X | 2 Low Scores |  |  | Paste Special Values
 | 3 | [NAME] |  | 93 | 0 |  |  | 3 Low Scores
 | 4 | Gene |  | 89.66666666666667 | 0 |  | TODAY'S LOCAL RULES
 | 5 | [NAME] |  | 89 | 0 |  |  | Play ball down (as it lies)
 |  |  |  |  |  |  |  | Lift, clean & place within 1 club length no closer to hole
 |  | Team #3 |  | [NAME] | Strokes |  |  | (only where carts can drive)
 | 1 | [NAME] |  | 89 | 0 |  |  | Lift, clean & place within 1 club length, no closer to hole
 | 2 | [NAME] |  | 88.5 | 0 |  |  | (anywhere on course)
 | 3 | Byron |  | 88.5 | 0 |  |  | Hole-out all scoring balls
 | 4 | Gene |  | 88 | 0 |  |  | Gimmies length of "your own" foot
 | 5 | [NAME] |  | 86.66666666666667 | 0 |  | BUNKER PLAY
 |  |  |  |  |  |  | X | Play bunkers as the ball lies
 |  | Team #4 |  | [NAME] | Strokes |  |  | Lift, clean and place within 1 club length, no closer to hole
 | 1 | JV |  | 85 | 0 |  |  | Remove ball from bunker, no closer to hole
 | 2 | [NAME] |  | 84.5 |  |  |  | Rake and place within 12 inches of original position
 | 3 | [NAME] |  | 82.66666666666667 |  |  | WILDCARD PLAYER
 | 4 | [NAME] |  | 81 |  |  |  | Charlie for Team #1; [NAME] for Team #2
 | 5 | [NAME] |  | 80 |  |  | OTHER
 |  | Team #5 |  | [NAME] | Get /Give Strokes
 | 1 | [NAME] |  | 79.66666666666667 | 0
 | 2 | [NAME] |  | 79.66666666666667 | 0
 | 3 | [NAME] |  | 78.5 | 0
 | 4 | Mitch |  | 75.33333333333333 | 0
 | 5 |  |  | 0
Spreadsheet: 810171d1671584153-convert-horizontal-table-to-vertical-table-form-conversion
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Result
A | Bangkok | 0.05 | Phuket | 0.06 | Nakhon Sawan | 0.07 |  |  |  |  | A | Bangkok | 0.05
B | [NAME] | 0.07 | Ayutthaya | 0.04 |  |  |  |  |  |  | A | Phuket | 0.06
C | Pattaya | 0.03 | [NAME] | 0.1 | [NAME] | 0.09 | Pattani | 0.07 |  |  | A | Nakhon Sawan | 0.07
D | Rayong | 0.02 |  |  |  |  |  |  |  |  | B | [NAME] | 0.07
 |  |  |  |  |  |  |  |  |  |  | B | Ayutthaya | 0.04
 |  |  |  |  |  |  |  |  |  |  | C | Pattaya | 0.03
 |  |  |  |  |  |  |  |  |  |  | C | [NAME] | 0.1
 |  |  |  |  |  |  |  |  |  |  | C | [NAME] | 0.09
 |  |  |  |  |  |  |  |  |  |  | C | Pattani | 0.07
 |  |  |  |  |  |  |  |  |  |  | D | Rayong | 0.02
Spreadsheet: 793367d1661432275-consecutive-numbers-by-id-sample-data-set-4-
Sheet: Sample Data Set

ID | threshold | formula result | [NAME]
1 | 45 |  | 1
1 | 55 |  | 2
1 | 67 |  | 3
2 | 89 |  | 0
2 | 90 |  | 0
2 | 65 |  | 1
2 | 45 |  | 2
3 | 0 |  | 0
3 | 12 |  | 1
3 | 1 |  | 2
4 | 55 |  | 1
Spreadsheet: 873338d1719848889-extracting-loops-from-a-tree-network-test-whole-network-
Sheet: Sheet1

Node | Node
1 | 2
2 | 3
3 | 4
4 | 5
5 | 6
6 | 8
2 | 8
3 | 5
6 | 7
Spreadsheet: 860158d1708363831-customer-ranking-by-cost-in-pivot-tables-ascending-order-pivot-table
Sheet: Pivot Table

Month | April
[NAME] | Count of Cost |  | Rank
[NAME] | 9 |  | 4
Lucas | 10 |  | 2
Olivia | 21 |  | 3
Emma | 25 |  | 4
[NAME] | 25 |  | 1
Total Geral | 90
Spreadsheet: 266620d1379679185-if-then-countif-formula-vilam21
Sheet: Sheet1

Date | Values
2013-09-12 00:00:00 | 14
2013-09-17 00:00:00 | 30 |  |  | From | To | Total
2013-09-24 00:00:00 | 21 |  |  | 2013-09-12 00:00:00 | 2013-09-18 00:00:00
2013-09-17 00:00:00 | 9
2013-09-21 00:00:00 | 24
2013-09-20 00:00:00 | 1
2013-09-17 00:00:00 | 7
2013-09-19 00:00:00 | 11
2013-09-15 00:00:00 | 15
2013-09-17 00:00:00 | 16
2013-09-12 00:00:00 | 19
2013-09-16 00:00:00 | 24
2013-09-22 00:00:00 | 14
2013-09-15 00:00:00 | 6
2013-09-19 00:00:00 | 18
2013-09-14 00:00:00 | 5
2013-09-20 00:00:00 | 4
2013-09-19 00:00:00 | 1
2013-09-14 00:00:00 | 25
2013-09-14 00:00:00 | 27
2013-09-15 00:00:00 | 9
2013-09-24 00:00:00 | 28
2013-09-19 00:00:00 | 29
2013-09-23 00:00:00 | 30
2013-09-13 00:00:00 | 25
2013-09-16 00:00:00 | 10
2013-09-23 00:00:00 | 2
2013-09-20 00:00:00 | 9
2013-09-18 00:00:00 | 20
2013-09-15 00:00:00 | 15
Spreadsheet: andy_zipper__469__11_26_01OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO Z1 | 52 | 180 | 280 | 82.8 | 128.9 | 3.46 | 2001-11-26 10:45:00
 | HO F2 | 53 | 670 | 770 | 55.5 | 63.8 | 1.99 | 2001-11-26 10:45:00
 | HO G2 | 54 | 970 | 1070 | 54.7 | 60.3 | 1.95 | 2001-11-26 10:45:00
 | [NAME] | 54 | 1150 | 1250 | 54.1 | 58.9 | 1.92 | 2001-11-26 10:45:00
 | HO J2 | 53 | 1250 | 1400 | 52.6 | 59 | 1.86 | 2001-11-26 10:45:00
 | HO K2 | 53 | 1310 | 1450 | 49.3 | 54.7 | 1.73 | 2001-11-26 10:45:00
 | HO M2 | 53 | 1350 | 1500 | 46.3 | 51.5 | 1.63 | 2001-11-26 10:45:00
 | HO N2 | 53 | 1360 | 1500 | 43.5 | 48.1 | 1.53 | 2001-11-26 10:45:00
 | HO Q2 | 54 | 1370 | 1550 | 40.3 | 45.7 | 1.46 | 2001-11-26 10:45:00
 | HO U2 | 55 | 1370 | 1550 | 37.4 | 42.4 | 1.38 | 2001-11-26 10:45:00
 | [NAME] |  |  |  | 38.4 | 42.2 | 1.42 | 2001-11-15 14:53:00
 | HO X2 |  |  |  | 37.9 | 40.3 | 1.38 | 2001-11-15 14:53:00
 | [NAME] |  |  |  | 33.3 | 36.6 | 1.32 | 2001-11-07 14:56:00
 | HO F3
 | [NAME] |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | HO H3
Spreadsheet: richard_ring__31655__Sample Invoice (10-15-01)
Sheet: Network Transmission

 | Enron Energy Services Operations, Inc.
 | BGE Index Product Network Transmission Costs - Example Calculations
Maryland Customer
Attn:
 |  | From: | To:
Baltimore, MD |  | 2003-01-01 00:00:00 | 2003-01-31 00:00:00
 |  |  |  |  | (OATT Attachment H-2)
 |  |  |  |  | 13020 | /MW-Year
SITE | Description
 | (A) | (B) | (C) | (D) | (E) | (E) | (F)
 |  |  |  | Customer Contribution to BGE Zonal Peak | Network Trans. Cost | Network Trans. Cost | Network Trans. Cost
Site 1 | Hour | kWh | Day
 |  |  |  | (kW) | ($/Year) | ($/Month) | ($/kWh)
 | 1 |  | 1 | 800
 |  |  |  | (adjusted for losses)