tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 40279d1238586784-nested-if-or-formula-or-vba-code-instead-tops-formulas-from-home
Sheet: Sheet1

start date | 1st tops | TAP formula, works out if 1st tops is +/- 14 days of start, if so returns start date, if not returns 1st tops | 1 | 2 | 3 | 4 | 5 | if 1st review is within 5-14 weeks then it returns within window | 2 | if 2nd review is within 15-26 weeks then it returns within window | 3 | if 3rd review is within 27-38 weeks then it returns within window | 4 | 39-50 | 5 | 51-62 | 6 | 63-74
2004-01-01 00:00:00 | 2008-08-03 00:00:00 | 2008-08-03 00:00:00 | 2008-10-10 00:00:00 | 2008-10-30 00:00:00 | 2009-02-26 00:00:00 |  |  | Within Window 0 | 2008-10-30 00:00:00 | 0 | 2009-02-26 00:00:00 | 0 |  | 0 |  | 0 |  | 0
2004-01-01 00:00:00 | 2008-12-12 00:00:00 |  | 2009-05-01 00:00:00 |  |  |  |  | Outside Window | 2009-06-05 00:00:00 | Outside Window | 2009-09-03 00:00:00 | Outside Window |  | Outside Window |  | Outside Window |  | Outside Window
2009-03-15 00:00:00 | 2009-03-15 00:00:00 |  | 2009-04-30 00:00:00 |  |  |  |  | Outside Window | 2009-06-04 00:00:00 | Outside Window | 2009-09-02 00:00:00 | Outside Window |  | Outside Window |  | Outside Window |  | Outside Window
2009-03-15 00:00:00 | 2009-03-03 00:00:00 |  | 2009-05-09 00:00:00 |  |  |  |  | Outside Window | 2009-06-13 00:00:00 | Outside Window | 2009-09-11 00:00:00 | Outside Window |  | Outside Window |  | Outside Window |  | Outside Window
2009-03-15 00:00:00 | 2009-03-23 00:00:00 |  | 2009-05-13 00:00:00 |  |  |  |  | Outside Window | 2009-06-17 00:00:00 | Outside Window | 2009-09-15 00:00:00 | Outside Window |  | Outside Window |  | Outside Window |  | Outside Window
2009-03-15 00:00:00 | 2009-04-04 00:00:00 |  | 2009-05-20 00:00:00 |  |  |  |  | Outside Window | 2009-06-24 00:00:00 | Outside Window | 2009-09-22 00:00:00 | Outside Window |  | Outside Window |  | Outside Window |  | Outside Window
2009-03-15 00:00:00 | 2009-01-01 00:00:00 |  | 2009-05-08 00:00:00 |  |  |  |  | Outside Window | 2009-06-12 00:00:00 | Outside Window | 2009-09-10 00:00:00 | Outside Window |  | Outside Window |  | Outside Window |  | Outside Window
2009-03-15 00:00:00 | 2009-03-02 00:00:00 |  | 2009-05-09 00:00:00 |  |  |  |  | Outside Window | 2009-06-13 00:00:00 | Outside Window | 2009-09-11 00:00:00 | Outside Window |  | Outside Window |  | Outside Window |  | Outside Window
Spreadsheet: 837140d1689876186-indirect-a1-a5-and-a1-to-spill-a1-from-other-sheets-doesnt-work-how-could-i-do-it-example-2
Sheet: PMarcP

D | CP | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
False | 75000 | 58.63892226098556 | 117.2778445219711 | 175.9167667829567 | 234.5556890439422 | 293.1946113049278 | 351.8335335659133 | 410.4724558268989 | 469.1113780878845 | 527.75030034887 | 586.3892226098556 | 645.0281448708412 | 703.6670671318267 | 762.3059893928123 | 820.9449116537978 | 879.5838339147834 | 938.222756175769
False | 13000 | 5.865533205742201 | 11.7310664114844 | 17.5965996172266 | 23.4621328229688 | 29.32766602871101 | 35.1931992344532 | 41.05873244019541 | 46.92426564593761 | 52.78979885167981 | 58.65533205742202 | 64.52086526316421 | 70.3863984689064 | 76.25193167464862 | 82.11746488039081 | 87.98299808613302 | 93.84853129187522
False | 77000 | 3.713967748336755 | 7.42793549667351 | 11.14190324501027 | 14.85587099334702 | 18.56983874168377 | 22.28380649002053 | 25.99777423835728 | 29.71174198669404 | 33.42570973503079 | 37.13967748336755 | 40.85364523170431 | 44.56761298004106 | 48.28158072837782 | 51.99554847671457 | 55.70951622505132 | 59.42348397338808
False | 50000 | 7.555403039032259 | 15.11080607806452 | 22.66620911709678 | 30.22161215612904 | 37.7770151951613 | 45.33241823419355 | 52.88782127322582 | 60.44322431225807 | 67.99862735129034 | 75.5540303903226 | 83.10943342935485 | 90.66483646838711 | 98.22023950741936 | 105.7756425464516 | 113.3310455854839 | 120.8864486245161
False | 79000 | 7.433830215812069 | 14.86766043162414 | 22.30149064743621 | 29.73532086324828 | 37.16915107906034 | 44.60298129487241 | 52.03681151068449 | 59.47064172649655 | 66.90447194230862 | 74.33830215812068 | 81.77213237393276 | 89.20596258974483 | 96.6397928055569 | 104.073623021369 | 111.507453237181 | 118.9412834529931
False | 80000 | 1.392008788706265 | 2.78401757741253 | 4.176026366118794 | 5.56803515482506 | 6.960043943531325 | 8.352052732237588 | 9.744061520943854 | 11.13607030965012 | 12.52807909835638 | 13.92008788706265 | 15.31209667576891 | 16.70410546447518 | 18.09611425318144 | 19.48812304188771 | 20.88013183059397 | 22.27214061930024
False | 81000 | 9.61619127781983 | 19.23238255563966 | 28.84857383345949 | 38.46476511127932 | 48.08095638909915 | 57.69714766691898 | 67.3133389447388 | 76.92953022255864 | 86.54572150037848 | 96.1619127781983 | 105.7781040560181 | 115.394295333838 | 125.0104866116578 | 134.6266778894776 | 144.2428691672974 | 153.8590604451173
Spreadsheet: 125424d1319027227-problem-using-conditional-formatting-to-flag-cells-by-color-and-count-them-copy-of-example4
Sheet: Nelson

PT. # | LAST NAME | FIRST NAME | REQUIRED | IN DATE | COM DATE | NOTES |  |  | VISIT DATE
8964 |  |  | SSS Sig | 2011-09-01 00:00:00 | 2011-10-11 00:00:00 | DELIQUENT | Total # Yellow: | 0 | GOOD
80303 |  |  | DO Sig | 2011-09-13 00:00:00 | 2011-10-11 00:00:00 | GOOD | Total # Orange: | 1 | GOOD
57659 |  |  |  | 2011-10-11 00:00:00 |  | GOOD | Total # Red: | 1 | need this to be 1
64748 |  |  | HP Sig | 2011-10-11 00:00:00 | 2011-10-11 00:00:00 | GOOD | Complient: | 5 | need this to be 5
22801 |  |  | D/C Sig | 2011-09-20 00:00:00 |  | GOOD | All Total: | 6 | this would be 6
19183 |  |  | PN | 2011-10-17 00:00:00 | 2011-10-17 00:00:00 | GOOD
73942
79968
19183
Spreadsheet: 888124d1738555155-tenor-need-to-increase-base-on-balance-installment-tenor-test
Sheet: Loan_ID

Loan ID | Name | Loan Date | Interest  % | Loan Amount | Tenor |  | Helper
L001 | Nutan Vishal Bhagare | 2024-12-01 00:00:00 | 2 | 20000 | 4
L002 | Suvarna N Gaikwad | 2025-02-21 00:00:00 | 2 | 40000 | 6
L003 | Rajjaka A Waghmode | 2025-03-26 00:00:00 | 2 | 30000 | 2
L004 | Surkekha A Kirgat | 2025-04-27 00:00:00 | 2 | 50000 | 8
L005 | Kamble | 2024-12-31 00:00:00 | 2 | 10000 | 5
L006 | [NAME] | 2025-01-21 00:00:00 | 2 | 15000 | 8
L007 | [NAME] | 2025-01-26 00:00:00 | 2 | 25400 | 6
L008 | Sunita R Madne | 2025-01-27 00:00:00 | 2 | 36582 | 4
L009 | [NAME] | 2024-12-01 00:00:00 | 2 | 18000 | 7
L010 | [NAME] | 2025-01-21 00:00:00 | 2 | 365480 | 3
Spreadsheet: 707655d1607409035-vlookup-or-formula-to-return-a-number-related-to-a-word-that-is-typed-into-a-cell-tennispq17-1-
Sheet: Tennis Data

Carpet |  | Name | Age | Wins | Matches | Lost | Surface Win % | Best Surface | Best Surface Win % | Prize Money
[NAME] |  | [NAME]
Novak Djokovic |  | Novak Djokovic | 33 | 1072 | 1297 | 225 | 0.6563 | Hard | 0.8589 | 139144944
[NAME]
[NAME]
Spreadsheet: 96245d1295638204-countif-separately-based-on-backround-color-nfltest1
Sheet: Sheet1

 |  |  | AFC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NFC
 |  |  | West |  |  |  | North |  |  |  | South |  |  |  | East |  |  |  | West |  |  |  | North |  |  |  | South |  |  |  | East
 |  | 2011 | Broncos | Chargers | Chiefs | Raiders | Bengals | [NAME] | Ravens | Steelers | Colts | [NAME] | Texans | Titans | Bills | [NAME] | Jets | Patriots | 49ers | Cardinals | [NAME] | Seahawks | Bears | Lions | Packers | Vikings | Bucs | Falcons | Panthers | Saints | Cowboys | Eagles | Giants | Redskins |  |  |  | Wins | Losses
AFC | West | Broncos
 |  | Chargers
 |  | Chiefs
 |  | Raiders
 | North | Bengals
 |  | [NAME]
 |  | Ravens
 |  | Steelers
 | South | Colts
 |  | [NAME]
 |  | Texans
 |  | Titans
 | East | Bills
 |  | [NAME]
 |  | Jets
 |  | Patriots
NFC | West | 49ers
 |  | Cardinals
 |  | [NAME]
 |  | Seahawks
 | North | Bears
 |  | Lions
 |  | Packers
 |  | Vikings
 | South | Bucs
 |  | Falcons
 |  | Panthers
 |  | Saints
 | East | Cowboys
 |  | Eagles
 |  | Giants
 |  | Redskins
Spreadsheet: 217228d1362006030-inventory-from-drop-down-lists-ammo-data-tracker1
Sheet: Inventory Sheet

Brass | Item ID | Amount of Parts | Production Amt | Actual Count | Deviation
Federal 308 Primed | F308P |  |  | 1500
Federal 308 Unprimed | F308U
[NAME] | L308U
Prvi 223 Unprimed | P223U
Federal 243 Primed | F243P
Federal 243 UnPrimed | F243U
Federal 30.06 Primed | F30.06P
Federal 30.06 Unprimed | F30.06U
Prvi 30.06 Unprimed | P30.06U
Remington 30.06 Unprimed | R30.06U
Federal 270 Primed | F270P
Federal 270 Unprimed | F270U
Remington 22-250 U | R22-250U
Federal 7mm-08 Primed | F7mm08P
Federal 7mm-08 Unprimed | F7mm08U
Bullets |  | Amount of Parts |  | Actual Count | Deviation
Hornady 30 cal 180 GR RN | H30C180RN
Hornady 6MM 243 100 GR BTSP | H6mm200BTSP
Hornady 308 220 GR LN | H308220LN
Sierra 22 Cal 55 GR HPBT | S22C55HPBT
Sierra 30 Cal 175 GR HPBT | S30C175HPBT
Sierra 150 GR 270 Cal SBT | S270C150SBT
Sierra 140 Gr 7mm SPBT | S7mm140SPBT
Powder |  | Amount in LBS |  | Actual Count | Deviation
IMR 4227 | IMR4227
IMR 4759 | IMR4759
IMR 4198 | IMR4198
IMR 3031 | IMR3031
Hodgens Varget | HVAR
IMR Trail Boss | IMRTB
Spreadsheet: 46579d1245423937-sumif-multiple-worksheets-add-all-cells-adjacent-to-cell-w-value-matching-query-kor-cart-quotas
Sheet: MIS - CS-SPD BULK #1

K-BRO LINEN SYSTEMS - EDMONTON  PLANT
CS/SPD BULK #1
FACILITY: | MISERICORDIA
Date:
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | STATS
DELIVERY DAYS: | X | X | X | X | X | X
 | *NO STAT HOLIDAYS
** If more/less linen required please fax in this order by 7:30 a.m. (FAX # (780) 451-5125)
[NAME] |  |  |  | PACK # |  | QUOTA | SHELF | REC | +/-/HOLD
100-HUCK TOWEL |  |  |  | BP0010 |  | 3
20-WRAPPER 24" |  |  |  | BP0003 |  | 5
20-WRAPPER 30" |  |  |  | BP0004 |  | 4
20-WRAPPER 36" |  |  |  | BP0005 |  | 7
20-WRAPPER 45" |  |  |  | BP0006 |  | 10
20-MICRO WRAPS 45" |  |  |  | BP0008 |  | 5
5-SM FEN DRAPES |  |  |  | BP0012 |  | 2
10-SPINAL DRAPES |  |  |  | BP0016 |  | 2
5-LG-SPLIT-DG |  |  |  | BP0029 |  | 1
10-TRAY-PILLOW COVERS |  |  |  | AP0014 |  | 4
10-MED FEN DRAPE |  |  |  | BP0025 |  | 2
UPDATED:
June 17th 2009
Spreadsheet: 274265d1383061923-or-function-template-test
Sheet: Sheet1

EU |  |  |  | US |  |  |  | UK |  |  |  | AUS |  |  |  | CN/JP/KR |  |  |  | RU/IL |  |  |  | CA |  |  |  |  | Prices
Phase In | Phase Out | ROO | web shop | Phase In | Phase Out | ROO | web shop | Phase In | Phase Out | ROO | web shop | Phase In | Phase Out | ROO | web shop | Phase In | Phase Out | ROO | web shop | Phase In | Phase Out | ROO | web shop | Phase In | Phase Out | ROO | web shop |  | EUR | USA | GBP | AUD | KRW | [NAME] | CNY | RUB | NZ | CAN
x
 |  |  |  | x |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  | x
Spreadsheet: 546014d1509803402-final-salary-to-show-in-a-different-cell-final-payout-to-be-placed-in-a-different-sheet-2-
Sheet: Tab2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I5
 | RL | Minutes_ worked | Soma de total minutes worked
 | George | 64 | 60.05
 | 2017-10-23 00:00:00 | 8 | 7.95
 | 2017-10-24 00:00:00 | 8 | 7.616666666666666
 | 2017-10-25 00:00:00 | 8 | 7.283333333333333
 | 2017-10-26 00:00:00 | 8 | 7.466666666666667
 | 2017-10-27 00:00:00 | 8 | 6.916666666666667
 | 2017-10-28 00:00:00 | 8 | 7.033333333333333
 | 2017-10-30 00:00:00 | 8 | 7.866666666666666
 | 2017-10-31 00:00:00 | 8 | 7.916666666666667
 | [NAME] | 59 | 60.46666666666667
 | 2017-10-16 00:00:00 | 8 | 7
 | 2017-10-17 00:00:00 | 6 | 7.066666666666666
 | 2017-10-24 00:00:00 | 8 | 7.283333333333333
 | 2017-10-26 00:00:00 | 8 | 7.466666666666667
 | 2017-10-27 00:00:00 | 5 | 7.85
 | 2017-10-28 00:00:00 | 8 | 7.9
 | 2017-10-30 00:00:00 | 8 | 8
 | 2017-10-31 00:00:00 | 8 | 7.9
 | [NAME] | 64 | 61.26666666666667
 | 2017-10-23 00:00:00 | 8 | 7.633333333333334
 | 2017-10-24 00:00:00 | 8 | 7.95
 | 2017-10-25 00:00:00 | 8 | 7.283333333333333
 | 2017-10-26 00:00:00 | 8 | 7.616666666666666
 | 2017-10-27 00:00:00 | 8 | 7.883333333333334
 | 2017-10-28 00:00:00 | 8 | 7.883333333333334
 | 2017-10-30 00:00:00 | 8 | 7.083333333333333
 | 2017-10-31 00:00:00 | 8 | 7.933333333333334
 | [NAME] | 64 | 60.11666666666667
 | 2017-10-23 00:00:00 | 8 | 7.466666666666667
 | 2017-10-24 00:00:00 | 8 | 7.266666666666667
 | 2017-10-25 00:00:00 | 8 | 7.1
 | 2017-10-26 00:00:00 | 8 | 7.366666666666667
 | 2017-10-27 00:00:00 | 8 | 7.916666666666667
 | 2017-10-28 00:00:00 | 8 | 8
 | 2017-10-30 00:00:00 | 8 | 7.9
 | 2017-10-31 00:00:00 | 8 | 7.1
 | Ringo | 64 | 55.93333333333333
 | 2017-10-23 00:00:00 | 8 | 7.433333333333334
 | 2017-10-24 00:00:00 | 8 | 3.6
 | 2017-10-25 00:00:00 | 8 | 6.916666666666667
 | 2017-10-26 00:00:00 | 8 | 7.283333333333333
 | 2017-10-27 00:00:00 | 8 | 7.866666666666666
 | 2017-10-28 00:00:00 | 8 | 7.916666666666667
 | 2017-10-30 00:00:00 | 8 | 8
 | 2017-10-31 00:00:00 | 8 | 6.916666666666667
 | Stuart | 64 | 59.95
 | 2017-10-23 00:00:00 | 8 | 7.8
 | 2017-10-24 00:00:00 | 8 | 7.466666666666667
 | 2017-10-25 00:00:00 | 8 | 7.1
 | 2017-10-26 00:00:00 | 8 | 7.066666666666666
 | 2017-10-27 00:00:00 | 8 | 6.7
 | 2017-10-28 00:00:00 | 8 | 8
 | 2017-10-30 00:00:00 | 8 | 7.9
 | 2017-10-31 00:00:00 | 8 | 7.916666666666667
 | [NAME] | 64 | 60.9
 | 2017-10-23 00:00:00 | 8 | 7.95
 | 2017-10-24 00:00:00 | 8 | 7.433333333333334
 | 2017-10-25 00:00:00 | 8 | 7.116666666666667
 | 2017-10-26 00:00:00 | 8 | 8
 | 2017-10-27 00:00:00 | 8 | 7.25
 | 2017-10-28 00:00:00 | 8 | 8
 | 2017-10-30 00:00:00 | 8 | 7.916666666666667
 | 2017-10-31 00:00:00 | 8 | 7.233333333333333
 | Total Geral | 443 | 418.6833333333335
Spreadsheet: phillip_m_love__30521__SITHE_May2401
Sheet: Summary

MTM FOR SITHE RELATED DEALS IN ENRON CANADA'S BOOKS
Note:  MTM Value is for  May 2001 forward as at May 24, 2001  (does not include May and June IM MTM)
 | USD$
With ENA |  |  | PostID's: | 1150581 | Price
Transport |  |  |  | 1150601 | Index
Sithe Fee
Total |  |  | Check
The following deals in TAGG would need to be unwound:
ENA/Transport | NH1353 | VC1474 | Legs 3 thru 12
ENA | E30623 | VC1490 | [NAME] | (note only Nov 04 forward to be unwound; E34612.1 financially offsets the first few years)
ENA | E34612 | VC1494 | [NAME]
Index | E30623.4 | VC1490 | [NAME] | (note that with this unwind E34612.4 would need to be increased for the total Engage vol)
Index | E34612 | VC1494 | Leg 3
Sithe Index | E32934 | VC1495 | Leg 9
Sithe Index | EA2386 | VC1496 | Leg 1
Transport Rebook | NH1353 | VC1474 | Legs 13 thru 14
Transport Rebook | QA1354 | VC1497 | ALL | Represents the assignment of transport to ENA
Spreadsheet: 120984d1315721893-expense-sheet-help-pteasypeasy
Sheet: Sheet1

Desc | Amount | [NAME]
Item 1 | 10 | [NAME] |  |  | Row Labels | Sum of Amount
Item 2 | 12 | [NAME] |  |  | [NAME] | 27
Item 3 | 19 | [NAME] |  |  | [NAME] | 19
Item 4 | 17 | [NAME] |  |  | [NAME] | 30
Item 5 | 18 | [NAME] |  |  | Grand Total | 76
Total
[NAME] | 27
[NAME] | 30
[NAME] | 19
Spreadsheet: 718865d1613398019-solved-sort-and-rearrange-if-1-number-is-higher-in-certain-rows-excel-forum1
Sheet: Sheet1

My data
259 | 170 | 8
169 | 257 | 6
258 | 169 | 7
169 | 260 | 7
259 | 169 | 8
259 | 170 | 6
259 | 169 | 6
247 | 170 | 8
258 | 170 | 7
258 | 169 | 7
257 | 169 | 8
258 | 168 | 8
258 | 167 | 7
257 | 170 | 7
259 | 166 | 7
170 | 260 | 7
259 | 169 | 6
Spreadsheet: 6e37e95c-6077-4256-8bd1-b303be820c8e
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
 |  | U.S. Census Bureau
 |  | Source: Manufacturing and Trade Inventories and Sales
 |  | Total Business: U.S. Total
 |  | Not Seasonally Adjusted Sales - Monthly [Millions of Dollars]
 |  | Period: 1992 to 2012
 |  | Data Extracted on: August 22, 2014 (3:58 pm)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1992 | 478951 | 496844 | 542833 | 533768 | 537400 | 565572 | 526186 | 539854 | 560404 | 566566 | 545761 | 588252
1993 | 501102 | 519670 | 577660 | 562473 | 568082 | 592054 | 541465 | 571966 | 587293 | 587643 | 582479 | 614453
1994 | 523199 | 548442 | 622218 | 589743 | 606190 | 634299 | 570383 | 637290 | 638551 | 637472 | 636597 | 673862
1995 | 583576 | 602657 | 671889 | 629789 | 665344 | 688374 | 610456 | 678051 | 677370 | 678823 | 671241 | 698703
1996 | 608890 | 640408 | 687749 | 676459 | 705129 | 701473 | 661061 | 704489 | 703818 | 724199 | 700035 | 729370
1997 | 648926 | 670542 | 733003 | 714436 | 728181 | 746888 | 699834 | 728842 | 755266 | 760523 | 718354 | 776516
1998 | 665199 | 691649 | 766470 | 739466 | 743025 | 776742 | 710372 | 738979 | 765522 | 769652 | 740557 | 801062
1999 | 674466 | 713828 | 808436 | 767844 | 782025 | 823830 | 752260 | 807053 | 819724 | 808320 | 808880 | 867470
2000 | 736418 | 788463 | 877235 | 805781 | 857443 | 885803 | 785590 | 859519 | 857579 | 850389 | 832885 | 869309
2001 | 770103 | 774655 | 861022 | 802271 | 859275 | 847654 | 778235 | 849939 | 794712 | 840889 | 806617 | 832547
2002 | 744714 | 745322 | 829077 | 820170 | 854250 | 837917 | 809149 | 860708 | 829841 | 859538 | 823211 | 864906
2003 | 782574 | 774886 | 868741 | 836279 | 860568 | 870703 | 843589 | 868118 | 878282 | 900523 | 841761 | 928587
2004 | 806675 | 828911 | 960448 | 911869 | 921533 | 956337 | 899720 | 950974 | 949870 | 951486 | 948022 | 1021813
2005 | 876711 | 892665 | 1030752 | 984111 | 1008088 | 1046136 | 968672 | 1059815 | 1043371 | 1036777 | 1023729 | 1090735
2006 | 964680 | 959077 | 1114050 | 1030220 | 1117564 | 1129615 | 1037708 | 1137569 | 1068149 | 1078947 | 1059869 | 1118693
2007 | 1003001 | 991049 | 1146293 | 1095302 | 1178782 | 1166926 | 1103560 | 1188044 | 1117306 | 1186951 | 1160944 | 1182344
2008 | 1099693 | 1099075 | 1187476 | 1196483 | 1244397 | 1257879 | 1225574 | 1212894 | 1170820 | 1143117 | 990954 | 1045887
2009 | 898187 | 883064 | 976519 | 952457 | 966748 | 1015212 | 983245 | 1003868 | 1000403 | 1020594 | 992100 | 1083535
2010 | 941736 | 938975 | 1110200 | 1079665 | 1075956 | 1109727 | 1065605 | 1107045 | 1098504 | 1104597 | 1107047 | 1189297
2011 | 1053102 | 1048581 | 1249777 | 1188072 | 1215664 | 1243325 | 1167741 | 1256088 | 1216399 | 1211197 | 1202411 | 1268714
2012 | 1135568 | 1171817 | 1304566 | 1242195 | 1302938 | 1259747 | 1211721 | 1298285 | 1230301 | 1293178 | 1260553 | 1293144
Spreadsheet: jeff_dasovich__14060__Enron PX Credits as of 4-20-01
Sheet: SUMMARY

ESP | # of Accounts | PX Credits           As of 1/4/01 | PX Credit Activity        1/5/01 - 1/18/01 | PX Credit Activity   1/19/01 - 04/20/01 | Rebill Procured Energy Credit      1/19/01 - 04/20/01 | Credit Balances As of 4/20/01
Enron Energy Marketing |  |  |  |  | 33537661.47
Enron Energy Service, Inc. |  |  |  |  | 35286618.65
TOTALS
Spreadsheet: 869329d1715912123-excel-countif-with-an-array-alec-file
Sheet: Test Sheet

Multiply the number of times a value in column "B" appears in row "8" by its coresponding value in column "C". Then add those products for all values in column "G" .   See '2024' cell [NAME] for full equation
 | A | 1
 | B | 2
 | C | 3
 | D | 4
 | E | 5
Day 1 | A | C | A | A B | D
Day 2 | E | D | C | A B | E D
Day 3 | C | B | A | B | A E
This is just a sample.  The codes are more complicated then A,B,C, D, but this is how I tested it
Also notivce that a cell can contain more than 1 code
Spreadsheet: daren_farmer__5675__HPLN0112
Sheet: Sheet1

HPLN0112.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - Januar 12, 2001
 |  |  |  |  |  | **Friday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-01-12 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: ce00821e-0641-4643-92a4-d5819d16ad4d
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
 |  | U.S. Census Bureau
 |  | Source: Monthly Retail Trade and Food Services
 |  | 44X72: Retail Trade and Food Services: U.S. Total
 |  | Not Seasonally Adjusted Sales - Monthly [Millions of Dollars]
 |  | Period: 1992 to 2012
 |  | Data Extracted on: October 25, 2014 (6:59 pm)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1992 | 146376 | 147079 | 159336 | 163669 | 170068 | 168663 | 169890 | 170364 | 164617 | 173655 | 171547 | 208838
1993 | 153221 | 150087 | 170439 | 176456 | 182231 | 181535 | 183682 | 183318 | 177406 | 182737 | 187443 | 224540
1994 | 161349 | 162841 | 192319 | 189569 | 194927 | 197946 | 193355 | 202388 | 193954 | 197956 | 202520 | 241111
1995 | 175344 | 172138 | 201279 | 196039 | 210478 | 211844 | 203411 | 214248 | 202122 | 204044 | 212190 | 247491
1996 | 185019 | 192380 | 212110 | 211718 | 226936 | 217511 | 218111 | 226062 | 209250 | 222663 | 223953 | 258081
1997 | 200389 | 197556 | 225133 | 220329 | 234190 | 227365 | 231521 | 235252 | 222807 | 232251 | 228284 | 271054
1998 | 207853 | 203863 | 230313 | 234503 | 245027 | 244067 | 241431 | 240462 | 231243 | 244234 | 240991 | 288969
1999 | 218126 | 220650 | 253550 | 250783 | 262113 | 260918 | 262051 | 265089 | 253905 | 258040 | 264106 | 317659
2000 | 236422 | 250580 | 279515 | 264417 | 283706 | 281288 | 271146 | 283944 | 269155 | 270899 | 276507 | 319958
2001 | 250746 | 247772 | 280449 | 274925 | 296013 | 287881 | 279098 | 294763 | 261924 | 291596 | 287537 | 326202
2002 | 255598 | 253086 | 285261 | 284747 | 300402 | 288854 | 295433 | 307256 | 273189 | 287540 | 290705 | 337006
2003 | 268335 | 259060 | 293703 | 294262 | 312404 | 301014 | 309942 | 317079 | 293912 | 304060 | 301299 | 357634
2004 | 281493 | 282478 | 319111 | 315223 | 328445 | 321081 | 328040 | 326362 | 313566 | 319768 | 324315 | 387243
2005 | 293308 | 295109 | 339190 | 335678 | 345401 | 351002 | 351889 | 355773 | 333363 | 336214 | 343910 | 405788
2006 | 318682 | 314189 | 362141 | 351811 | 373727 | 366795 | 362393 | 376006 | 346423 | 349007 | 357224 | 418473
2007 | 329169 | 323456 | 374439 | 358806 | 391816 | 376944 | 372665 | 388357 | 354241 | 368982 | 378233 | 426699
2008 | 343241 | 344577 | 373623 | 369688 | 398816 | 379387 | 384666 | 383879 | 351578 | 350920 | 336629 | 385504
2009 | 311345 | 300589 | 329806 | 331186 | 349193 | 345933 | 349588 | 354942 | 326138 | 340151 | 340992 | 402229
2010 | 316127 | 312513 | 362497 | 358296 | 367552 | 360583 | 363815 | 364503 | 347868 | 357197 | 367894 | 429102
2011 | 337571 | 339381 | 389491 | 383171 | 394615 | 391289 | 386986 | 397086 | 377354 | 382136 | 393873 | 454856
2012 | 357635 | 375273 | 417525 | 396432 | 422382 | 404510 | 399372 | 421468 | 389061 | 403332 | 415135 | 466907
Spreadsheet: 485473d1476895731-icon-trend-trends
Sheet: Folha1

 |  | Last Week | Current Week | Trend
 |  | 0.9 | 1
 |  | 0.96 | 0.97
 |  | 0.89 | 0.89
 |  | 0.9 | 0.9
 |  | 0.91 | 0.91
 |  | 0.92 | 0.92
 |  | 0.93 | 0.93
 |  | 0.94 | 0.94
 |  | 0.95 | 0.95
 |  | 0.96 | 0.96
 |  | 0.97 | 0.97
 |  | 0.98 | 0.98
 |  | 0.99 | 1
 |  | 1 | 0.78