tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 851280d1701504891-how-to-calculate-fibonacci-retracements-ratio-by-excel-formula-fibonacci-retracement-aligw
Sheet: Fibonacci Retracement 

High | Low | Close | Fibonacci Retracement %
116 | 73 | 116
116 | 73 |  | 0.5
116 | 73 | 99.6 | 0.618
116 | 73 | 83.1 | 0.214
116 | 73 | 73 | 0
116 | 73 | 93 | 0.382
116 | 73 | 80 | 0.146
Spreadsheet: 870347d1716884776-distribution-of-a-sum-to-multiple-cells-with-different-limits-example-sum-distribution-with-limits
Sheet: Sheet1

 | Fixed sum: | 300000
 | Object ID | Limit/Cap | Formular? | Goal |  | Comment
 | 1 | 2900 | ? |  |  | Reached cap
 | 2 | 3500 | ? |  |  | Reached cap
 | 3 | 7500 |  |  |  | Reached cap
 | 4 | 12250 |  |  |  | Reached cap
 | 5 | 17500 |  |  |  | Reached cap
 | 6 | 5500 |  |  |  | Reached cap
 | 7 | 6800 |  |  |  | Reached cap
 | 8 | 34500 |  |  |  | Reached cap
 | 9 | 3500 |  |  |  | Reached cap
 | 10 | 7500 |  |  |  | Reached cap
 | 11 | 12250 |  |  |  | Reached cap
 | 12 | 17500 |  |  |  | Reached cap
 | 13 | 5500 |  |  |  | Reached cap
 | 14 | 6800 |  |  |  | Reached cap
 | 15 | 25450 |  |  |  | Reached cap
 | 16 | 54250 |  |  |  | limit has not yet been reached, so the rest will continue to be distributed evenly until the cap is reached
 | 17 | 75000 |  |  |  | limit has not yet been reached, so the rest will continue to be distributed evenly until the cap is reached
 | 18 | 7400 |  |  |  | Reached cap
 | 19 | 12450 |  |  |  | Reached cap
 | 20 | 9850 |  |  |  | Reached cap
Spreadsheet: 833954d1687357980-how-do-i-calculate-a-cell-value-using-multiple-criteria-20230621-example-1
Sheet: Sheet1

Fiscal Year | Fiscal Period | Contract Number | Invoice Total | 18/19 | 19/20 | 20/21 |  | 18/19 | 19/20 | 20/21
18/19 | 18/19 AP01 | 1001 | 100 |  |  |  |  | 100 | 0 | 0
18/19 | 18/19 AP02 | 1002 | 1058 |  |  |  |  | 26169.79 | 0 | 0
18/19 | 18/19 AP03 | 1003 | 952 |  |  |  |  | 9144 | 0 | 0
18/19 | 18/19 AP04 | 1002 | 12035.25 |  |  |  |  | 26169.79 | 0 | 0
18/19 | 18/19 AP07 | 1002 | 9876.54 |  |  |  |  | 26169.79 | 0 | 0
18/19 | 18/19 AP09 | 1002 | 3200 |  |  |  |  | 26169.79 | 0 | 0
18/19 | 18/19 AP12 | 1003 | 8192 |  |  |  |  | 9144 | 0 | 0
19/20 | 19/20 AP01 | 1001 | 543 |  |  |  |  | 0 | 1221.83 | 0
19/20 | 19/20 AP05 | 1001 | 12.17 |  |  |  |  | 0 | 1221.83 | 0
19/20 | 19/20 AP06 | 1001 | 666.66 |  |  |  |  | 0 | 1221.83 | 0
19/20 | 19/20 AP10 | 1003 | 5634 |  |  |  |  | 0 | 6108.21 | 0
19/20 | 19/20 AP11 | 1003 | 474.21 |  |  |  |  | 0 | 6108.21 | 0
20/21 | 20/21 AP03 | 1002 | 45.98 |  |  |  |  | 0 | 0 | 4773.98
20/21 | 20/21 AP03 | 1003 | 38.12 |  |  |  |  | 0 | 0 | 17331.11
20/21 | 20/21 AP07 | 1001 | 17128.45 |  |  |  |  | 0 | 0 | 17228.45
20/21 | 20/21 AP08 | 1003 | 16676 |  |  |  |  | 0 | 0 | 17331.11
20/21 | 20/21 AP08 | 1002 | 1528 |  |  |  |  | 0 | 0 | 4773.98
20/21 | 20/21 AP10 | 1001 | 100 |  |  |  |  | 0 | 0 | 17228.45
20/21 | 20/21 AP11 | 1002 | 3200 |  |  |  |  | 0 | 0 | 4773.98
20/21 | 20/21 AP12 | 1003 | 616.99 |  |  |  |  | 0 | 0 | 17331.11
Spreadsheet: mary_fischer__25610__32D-2001
Sheet: E-scheduel 21

SAP Acct | SAP Co # | Name of Co. Rent is paid to | Site this rent exp. Applies to | Concorde Co # | Concorde Acct # | [NAME] | [NAME] | Is this a capital or Operating lease (Y/N) | Year to Date |  |  | FUTURE LEASE COMMITMENT ( net of sublease , if applicable)
53801000 | 032D |  |  | 18 | 79201 | RENT, PREMISES - ALLOC | 0 |  | Gross | Less: | Net Rental | 1 Year Ended |  |  |  |  | 5 Years Ended |  |  | Total Remaining | Total | Value
 |  |  |  |  |  |  |  |  | Gross Rentals | Less: Subrentals | Net Rental Expense | 12-31-2002 | 12-31-2003 | 12-31-2004 | 12-31-2005 | 12-31-2006 | 12-31-2011 | 12-31-2016 | 12-31-2021 | Total remaining after 12-31-2021 | Total Commitment | Residual Value Guarantee
53801000 | 032D | 4 NORTHSHORE CENTER | SAFETY | 18 | 79215 | RENT, PREMISES, - ALLOC | 2274.8
53801000 | 032D | 4 NORTHSHORE CENTER | HUMAN RESOURCES | 18 | 79216 | RENT, PREMISES, & ALLOC | 24390.2
53801000 | 032D | 4 NORTHSHORE CENTER | SALES | 18 | 79217 | RENT, PREMISES - ALLOC | 2863.74
53801000 | 032D | 4 NORTHSHORE CENTER | TECHNICAL SERVICES | 18 | 79218 | RENT, PREMISES - ALLOC | 31549.1
53801000 | 032D | CORNERSTONE | MID-WEST REGION | 18 | 79225 | RENT, PREMISES - ALLOC | -3150.98
53801000 | 032D | WILLIARD | EASTERN & MID ATLANTIC REGION IN JENKINGTOWN | 18 | 79227 | RENT, PREMISES, &7 ALLOC | 8541.97
53801000 | 032D | 4 NORTHSHORE CENTER | EXECUTIVE | 18 | 79228 | RENT, PREMISES - ALLOC | 57568.34
 | 032D Total
53801000 | 032E | 4 NORTHSHORE CENTER |  | 83 | 792 | RENT EXPENSE | 1488
 | 032E Total
 |  |  |  |  | NOT MAPPED?
 |  |  |  | 4450 | 79220 | BOSTON
 |  |  |  | 18715.66 | 792219 | SOUTHERN REGION
 |  |  |  | -19664.82 | 79203 | OVERACCR RENT-WESTERN-SAN RAMON
 |  | TEXAS COMMISSION |  | 15318.72 | 792239 | SOUTHWEST REGION -DALLAS
 |  |  |  | 266.4 | 792279
 |  |  |  | 12505.13 | 792259
Spreadsheet: 489999d1479554512-football-predictions-football-predictions
Sheet: Week 4

Fixtures | Week 4 |  |  | 10th September |  | Player Scores
Home Team | Score |  |  | Away Team |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Damian West | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] |  | - |  | Manchester City |  | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Arsenal |  | - |  | Southampton |  | 2 | 2 | 5 | 2 | 2 | 5 | 2 | 2 | 2 | 2 | 2 | 5 | 2 | 5 | 2 | 5 | 5 | 2 | 2 | 2
Bournemouth |  | - |  | West Brom |  | 2 | 0 | 2 | 5 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 5 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0
Burnley |  | - |  | Hull City |  | 5 | 0 | 0 | 0 | 5 | 2 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 2 | 0 | 0 | 5 | 0 | 0
Middlesbrough |  | - |  | Crystal Palace |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 2 | 0 | 0
Stoke City |  | - |  | Tottenham |  | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 0 | 2 | 2 | 2
West Ham |  | - |  | Watford |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Liverpool |  | - |  | Leicester City |  | 2 | 2 | 0 | 2 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 0 | 2 | 2 | 2 | 2
Swansea City |  | - |  | Chelsea |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sunderland |  | - |  | Everton |  | 2 | 0 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 5 | 2 | 0 | 2 | 2 | 2 | 2 | 2
Home Team | Score |  |  | Away Team | Weekly Total
[NAME] | 1 | - | 2 | Manchester City |  | 2-2 | 2-1 | 2-3 | 2-1 | 1-0 | 1-1 | 2-2 | 1-0 | 2-3 | 2-2 | 3-2 | 1-1 | 2-2 | 2-2 | 2-1 | 2-1 | 1-0 | 2-1 | 2-1 | 2-1
Arsenal | 2 | - | 1 | Southampton |  | 2-0 | 3-1 | 2-1 | 2-0 | 3-0 | 2-1 | 3-1 | 2-0 | 3-1 | 2-0 | 3-1 | 2-1 | 2-0 | 2-1 | 3-2 | 2-1 | 2-1 | 3-1 | 3-0 | 2-0
Bournemouth | 1 | - | 0 | West Brom |  | 2-1 | 1-1 | 2-0 | 1-0 | 2-1 | 1-1 | 2-1 | 1-1 | 2-0 | 1-1 | 2-1 | 1-0 | 1-2 | 1-0 | 1-1 | 1-1 | 2-2 | 1-2 | 1-1 | 1-1
Burnley | 1 | - | 1 | Hull City |  | 1-1 | 0-1 | 1-2 | 2-1 | 1-1 | 2-2 | 0-1 | 1-0 | 2-1 | 2-1 | 1-0 | 1-1 | 1-2 | 1-1 | 0-0 | 1-2 | 1-0 | 1-1 | 0-1 | 0-1
Middlesbrough | 1 | - | 2 | Crystal Palace |  | 2-1 | 1-1 | 1-1 | 2-2 | 2-1 | 1-0 | 2-0 | 1-1 | 1-1 | 1-0 | 0-2 | 1-1 | 1-3 | 2-0 | 0-1 | 2-0 | 1-1 | 0-1 | 1-0 | 1-1
Stoke City | 0 | - | 4 | Tottenham |  | 2-1 | 1-2 | 2-1 | 1-2 | 1-1 | 1-2 | 0-0 | 1-1 | 1-2 | 0-1 | 1-2 | 1-2 | 1-3 | 0-1 | 1-2 | 1-3 | 1-1 | 1-2 | 0-2 | 0-2
West Ham | 2 | - | 4 | Watford |  | 2-1 | 2-1 | 1-0 | 2-2 | 2-1 | 2-1 | 0-0 | 2-1 | 3-1 | 3-1 | 1-1 | 1-1 | 2-1 | 2-1 | 2-1 | 2-0 | 2-0 | 2-0 | 1-0 | 2-1
Liverpool | 4 | - | 1 | Leicester City |  | 2-0 | 3-2 | 2-2 | 1-0 | 2-2 | 2-2 | 1-2 | 2-1 | 2-2 | 1-1 | 2-2 | 2-1 | 1-3 | 3-2 | 1-1 | 2-2 | 2-1 | 2-1 | 2-1 | 2-1
Swansea City | 2 | - | 2 | Chelsea |  | 1-3 | 0-2 | 0-3 | 0-2 | 0-1 | 1-2 | 0-1 | 0-1 | 1-3 | 1-3 | 0-3 | 0-2 | 0-4 | 0-1 | 0-2 | 1-3 | 1-2 | 0-2 | 0-2 | 0-2
Sunderland | 0 | - | 3 | Everton |  | 1-2 | 2-1 | 1-2 | 1-2 | 1-2 | 1-1 | 1-1 | 1-1 | 1-1 | 2-1 | 1-2 | 1-2 | 0-3 | 1-2 | 2-2 | 0-1 | 1-2 | 0-2 | 0-1 | 1-2
Spreadsheet: 672238d1586801592-calculating-based-on-three-or-more-conditions-example1651
Sheet: Sheet1

SKU | OMH115P
Region | Central
QTY | 26 - 50x
Price |  | Calculates price based on three conditions: SKU, Region and QTY and apllies the specific multiplier on the list price (details on sheet "Tables")
Example
IF | SKU | OMH120P
AND | Region | East
AND | QTY | 5x
Multiplier | 1.1
Final Price | 1.1 * 3.86
Spreadsheet: 834965d1688200319-how-do-i-autofill-sequential-numbers-in-a-growing-table-spreadsheet-travel-kopi
Sheet: Finances

# |  | Income | Transport | Food | Snacks | Party | Attractions | [NAME]. | Total
 |  |  | 39.5 | 10.95 | 14.91 |  |  | 2.16
 |  |  | 1215.74 | 9.34
 |  |  | 69.02 | 24.2
 |  |  | 160.93 | 18.98
 |  |  |  | 18.56
 | Total from NZ to DK
 |  |  |  | 1
 |  |  |  | 2
 |  |  |  | 3
 |  |  |  | 5
Spreadsheet: 728386d1618422848-changeable-date-from-tab-one-auto-mark-on-a-calendar-in-tab-2-deal-list
Sheet: BLPMC

 |  | 2021
Ownership |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
BL | Freestone Apartments |  |  |  |  |  |  |  |  |  |  |  |  | Laramie
BL | Discovery Village |  |  |  |  |  |  |  |  |  |  | 36 |  | Rapid City SD - Dev team needs more apps here
SFA | Warren Church PSH |  |  |  |  |  |  |  |  |  |  | 49 |  | Denver - St. Francis
BL | Espero PSH |  |  |  |  |  |  |  |  | 40 |  |  |  | Durango CO
APIE | Red Hill Loft |  |  |  |  |  | 30 |  |  |  |  |  |  | Carbondale CO
BL | Platte River |  |  |  |  |  |  |  |  |  | 20 |  |  | [NAME] min from Casper
WHN | [NAME] |  |  |  |  |  |  |  |  | 56 |  |  |  | WHN - Cheyenne
RC | East Park |  |  |  |  |  |  |  |  |  |  | 38 |  | Helena, MT no lease up
RC | Fire Tower |  |  |  |  |  |  |  |  |  |  | 44 |  | Helena, MT in place lease up- rehab
 |  | 2022
 |  | Jan | Feb | March | April | May | June | July | Aug | Sept | Oct | Nov | Dec
BL | Big Horn Flats |  |  |  | 60 |  |  |  |  |  |  |  |  | Sheridan - BLD owned
BL | [NAME] |  |  |  | 60 |  |  |  |  |  |  |  |  | Casper - BLD owned senior
HA | Villagio PSH |  |  |  |  |  |  |  |  |  | 200 |  |  | [NAME] PM but will help with lease up
BL | Charity's House PSH |  |  |  |  |  |  | 36 |  |  |  |  |  | Denver
 | MT Rescue Mission |  |  |  |  |  |  |  |  |  |  | 29 |  | Billings- Full shelter, family center and 29 units
BL | [NAME] |  |  |  |  |  | 80 |  |  |  |  |  |  | Fargo ND - lease up only
 | Richmond Flats |  |  |  |  |  |  |  |  |  | 55 |  |  | CDC UTAH -
Spreadsheet: 275909d1383680697-vlookup-with-multiple-sheets-samplerev1
Sheet: Client 1

 |  |  | Customer Name |  |  |  | Contact:
Date |  |  | COMMENETS |  |  |  |  | FOLLOW UP DATE
2013-10-15 00:00:00 |  |  | Bag quote |  |  |  |  | 2013-10-31 00:00:00 |  | OK
 |  |  |  |  |  |  |  | 2013-11-01 00:00:00 |  | APS
 |  |  |  |  |  |  |  | 2013-11-02 00:00:00 |  | hello
 |  |  |  |  |  |  |  | 2013-11-03 00:00:00
 |  |  |  |  |  |  |  | 2013-11-04 00:00:00
 |  |  |  |  |  |  |  | 2013-11-05 00:00:00
 |  |  |  |  |  |  |  | 2013-11-06 00:00:00
 |  |  |  |  |  |  |  | 2013-11-07 00:00:00
 |  |  |  |  |  |  |  | 2013-11-08 00:00:00
 |  |  |  |  |  |  |  | 2013-11-09 00:00:00
Spreadsheet: 777479d1650410470-spill-overflow-to-next-cell-test
Sheet: Sheet1

Starting Week Number | Remaining Hrs | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15 | Week 16 | Week 17 | Week 18 | Week 19 | Week 20 | Week 21 | Week 22 | Week 23 | Week 24 | Week 25 | Week 26 | Week 27 | Week 28 | Week 29 | Week 30 | Week 31 | Week 32 | Week 33 | Week 34 | Week 35 | Week 36 | Week 37 | Week 38 | Week 39 | Week 40 | Week 41 | Week 42 | Week 43 | Week 44 | Week 45 | Week 46 | Week 47 | Week 48 | Week 49 | Week 50 | Week 51 | Week 52
3 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2 | 500
5 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 44936d1243684117-excel-2007-moving-data-into-different-cells-dependant-on-date-excel-forum-help-spreadsheet
Sheet: Totals

 | Guy's Cats 2009
 | Income |  |  |  |  | Expenditure |  |  |  |  | Profit / Loss
 | Jan |  |  | Quarter 1 |  | Jan |  |  | Quarter 1 |  | Quarter 1 |  | Total Annual Income
 | Feb |  |  |  |  | Feb
 | Mar |  |  |  |  | Mar |  |  |  |  |  |  | Total Annual Costs
 | April |  |  | Quarter 2 |  | April |  |  | Quarter 2 |  | Quarter 2 |  | Pre-Tax Profit
 | May |  |  |  |  | May
 | June |  |  |  |  | June |  |  |  |  |  |  | Tax Liability
 | July |  |  | Quarter 3 |  | July |  |  | Quarter 3 |  | Quarter 3 |  | NET PROFIT
 | August |  |  |  |  | August
 | September |  |  |  |  | September
 | October |  |  | Quarter 4 |  | October |  |  | Quarter 4 |  | Quarter 4
 | November |  |  |  |  | November
 | December |  |  |  |  | December
Spreadsheet: sally_beck__33697__Metrics 0609
Sheet: West

E N R O N   N O R T H   A M E R I C A - H O T  L I S T  M E T R I C S |  |  |  |  |  |  |  |  |  |  |  |  | Team: | West Midstream
Results based on Activity through June 9, 2000 |  |  |  |  |  |  |  |  |  |  |  |  | Week | 10
 |  | Weekly Summary - 2Q00 through 1Q01
 |  | # of Transactions
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13
 |  | 2000-04-07 00:00:00 | 2000-04-14 00:00:00 | 2000-04-21 00:00:00 | 2000-04-28 00:00:00 | 2000-05-05 00:00:00 | 2000-05-12 00:00:00 | 2000-05-19 00:00:00 | 2000-05-26 00:00:00 | 2000-06-02 00:00:00 | 2000-06-09 00:00:00 | 2000-06-16 00:00:00 | 2000-06-23 00:00:00 | 2000-06-30 00:00:00
Postings Rollforward:
Beginning |  | 0
+ Entrances |  | 1 | 17 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
- Exits |  | 0 | 0 | 2 | 0 | 1 | 1 | 0 | 0 | 0 | 0
- Executions |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ending
 | Dollar Value of Transactions
 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 |  | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Average
Postings Rollforward:
Beginning |  | 100.5
+ Entrances |  | 0 | 14.3 | 1
- Exits |  | 0 | 0 | 0
+/- [NAME] |  | 0 | 0 | -13
- Executions |  | 0 | 0 | 0
Ending
Average Deal Size
 |  |  |  |  |  |  |  | Forward Quarters
 | Actual |  |  | Current Quarter |  | Per |  |  |  |  |  |  |  | Total Year
 | 1Q00 |  |  | 2Q00 |  | Hot List |  | 3Q00 |  |  | 4Q00 |  |  | 2000 |  |  | 1Q01
 | # | $ |  | # | $ |  |  | # | $ |  | # | $ |  | # | $ |  | # | $
Executions | 1 | 2.9 |  | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  | 0 | 0
DPR/MPR |  | 5.5 |  |  | 0.506 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0
Postings | 0 | 0 |  | 3 | 15.9 |  |  | 4 | 16 |  | 7 | 66 |  |  |  |  | 1 | 5
Identified Margin
Budget |  | 13.2 |  |  | 13.2 |  |  |  | 17.2 |  |  | 43.2 |  |  |  |  |  | 17.9
$ Coverage
$ millions
Spreadsheet: 125429d1319028434-excel-2007-moving-values-between-sheets-by-using-number-commands-copy-of-afhendingase-lar-and-loadinfo-1
Sheet: ULD7&8

Name of airline |  |  |  | Aircraft Position |  |  | Name of Airline |  |  |  | Aircraft Position
Built up by: | Hjortur |  | Origin | ULD Ident |  |  | Built up by: | Hjortur |  | Origin | ULD Ident
Total Pages: |  |  |  |  |  |  | Total Pages:
AWB | DEST | PCS | WEIGHT |  | Flight Number |  | AWB | DEST | PCS | WEIGHT |  | Flight Number
 |  |  |  |  | Offload Point |  |  |  |  |  |  | Offload Point
 |  |  |  |  | Final Dest |  |  |  |  |  |  | Final Dest
ULD Tare Weight: |  |  |  |  |  |  |  | ULD Tare Weight:
RMK | Total |  |  |  |  |  | RMK | Total
Spreadsheet: andy_zipper__238__DYNEGY-ICE VOL May31
Sheet: DD-Lookup

Dynegy DIrect
User Lookup
ENA |  |  | EPM |  |  | EGL |  |  | Count of Transaction ID
User Name | Real Name |  | User Name | Real Name |  | User Name | Real Name |  | Units | Total | DELIVERY | CONV
AFAIRLEY | [NAME] |  | CDEANEPM | [NAME] |  | AGROSSPHY | [NAME] |  | Barrel | 12 | Monthly
AGOSALIA | [NAME] |  | DBAUGHMANPHY | [NAME] |  | EGLSTHOM | [NAME] |  | Barrel per day | 6
AGROSS | [NAME] |  | EMETOYEREPM | [NAME] |  | LJACKSONPHY | [NAME] |  | Barrel per month | 349 | Monthly
AZIPPER | [NAME] |  | ENAPDADAM | [NAME] |  | WWHICKSPHY | Wade Hicks |  | [NAME] | 2
BGUILMINO | [NAME] |  | ENAPJLAVO | [NAME] |  | 0 | No Activity |  | [NAME] | 11 | Monthly | 42
BHENDRY | Brent Hendry |  | ENAPRHERN | [NAME] |  |  |  |  | GJ | 211
CDEANENA | [NAME] |  | ENAPSHAN | [NAME] |  |  |  |  | IPE mt | 2
CPENNIX | [NAME] |  | ENPSTHOM | [NAME] |  |  |  |  | LME Registered 20 mt LOT | 4
[NAME] | [NAME] |  | ESAIBIEPM | [NAME] |  |  |  |  | LME Registered 25 mt Lot | 441
DBAUGHMAN_PHY | [NAME] |  | GGUPTA_PHY | [NAME] |  |  |  |  | LME Registered 5 mt LOT | 3
DHYVL1 | [NAME] |  | JKINGEPM | [NAME] |  |  |  |  | LME Registered 6 mt Lot | 54
DSAMUELS | [NAME] |  | JSTEPENO_PHY | [NAME] |  |  |  |  | MMBtu | 3667
EMETOYER | [NAME] |  | KTHOMPSONEPM | [NAME] |  |  |  |  | MMBtu/Lots (Options) | 39 |  | 10000
ENECGERMANY | [NAME] |  | MCARSONEPM | [NAME] |  |  |  |  | mt | 1
ENECUILLA | [NAME] |  | NMISRA_PHY | Narsimha Misra |  |  |  |  | MWh | 995
ENEDADAM | [NAME] |  | PMAKKAIEPM | [NAME] |  |  |  |  | MWh (Canada) | 2
[NAME] | [NAME] |  | RSTALFORD_PHY | [NAME] |  |  |  |  | Short Tons (+/- 5%) | 1
ENEHENDR | [NAME] |  | SPIWETZEPM | [NAME] |  |  |  |  | therm | 72
ENEJARNO | [NAME] |  | TMAY_PHY | [NAME] |  |  |  |  | (blank)
ENEJMCKA | [NAME] |  | 0 | No Activity |  |  |  |  | European Alum 25 mt Lot | 2 | Monthly
ENEJOLAV | [NAME] |  |  |  |  |  |  |  | [NAME]/month | 2 | Monthly
ENEJSHAN | [NAME] |  |  |  |  |  |  |  | IPE Barrels | 12
ENEJTOWNSEND | [NAME] |  |  |  |  |  |  |  | Emission allowance | 1
ENEJUNEK | [NAME] |  |  |  |  |  |  |  | COMEX Physical Copper Lots | 1
ENEMCKAY | [NAME] |  |  |  |  |  |  |  | Grand Total | 5890
ENEPEREI | [NAME]
ENERHERN | [NAME]
ENERING | [NAME]
ENESANDRA | [NAME]
ENESTHOM | [NAME]
ENETHUR | Patrice Mims-Thurston
ENEVVERS | [NAME]
ENEkelli | [NAME]
ESAIBIENA | [NAME]
GGUPTA_FIN | [NAME]
GWHALLEY | [NAME]
JARNOLD | [NAME]
[NAME] | [NAME]
JBELL1 | [NAME]
JKING1 | [NAME]
JLAVORATO | [NAME]
JMASSEY | [NAME]
JMASSEY1 | [NAME]
JSHANKMAN | [NAME]
JSTEPENO_FIN | [NAME]
JTHOME | [NAME]
KMCGOWAN | [NAME]
KTHOMPSON | [NAME]
LHANSEN | [NAME]
LJACKSON | [NAME]
LKITCHEN | [NAME]
MBRIDGES | [NAME]
MCARSONENA | [NAME]
MNETTEL | [NAME]
NMISRA_FIN | Narsimha Misra
PMAKKAIENA | [NAME]
PTHOMASENA | [NAME]
RHERNDON | [NAME]
RJAFRY | [NAME]
RSTALFORD_FIN | [NAME]
RTOMASKI | [NAME]
SPIWETZ | [NAME]
SSEVER | [NAME]
SSHACKLE | [NAME]
TJONES | [NAME]
TKUYKENDALL | Tori Kuykendall
TMAY_FIN | [NAME]
WGRESHAM | [NAME]
WWHICKSFIN | Wade Hicks
ENESTOREY | [NAME]
0 | No Activity
Spreadsheet: 27ed571e-260c-45aa-859a-f384662fa267
Sheet: Asztalos et al 2010

Agilent ID | Symbol
A_23_P54100 | ESR2
A_23_P309739 | ESR1
A_24_P325215 | ESR1
A_24_P284420 | ERBB2
A_23_P112470 | CCL21
A_23_P143178 | LBP
A_24_P335092 | SAA1
A_23_P87238 | SAA2::SAA4
A_23_P306203 | SAA2
A_23_P98622 | SAA2
A_23_P159163 | HLA-C::IGKC
A_23_P216023 | ANGPT1
A_24_P179400 | VEGF
A_23_P70398 | VEGF
A_23_P81805 | VEGF
A_24_P12401 | VEGF
A_23_P206359 | CDH1
A_23_P107401 | TIMP2
A_23_P207520 | COL1A1
A_23_P88404 | TGFB3
A_24_P373096 | TGFB3
A_23_P138938 | PGR
A_23_P37441 | B2M
A_24_P740662 | B2M
Spreadsheet: 96846d1296121878-too-many-nested-if-statements-fix-example
Sheet: Sheet1

 | STOCK CODE | [NAME] | USED ON JOB NO'S | RE-ORDER FLAG | NEW ORDER DETAILS (QTTY /DEL DATE / NEW CODE / EXISTING STOCK SCRAPPEGE INFO ETC) | TOTAL STOCK REMAINING | FLOOR VOLUME 08/10/10 | W/HOUSE VOLUME 08/10/10 | TOTAL VOLUME 08/10/10 | FLOOR VOLUME 14/10/10 | W/HOUSE VOLUME 14/10/10 | TOTAL VOLUME 14/10/10 | FLOOR VOLUME 21/10/10 | W/HOUSE VOLUME 21/10/10 | TOTAL VOLUME 21/10/10 | FLOOR VOLUME 28/10/10 | W/HOUSE VOLUME 28/10/10 | TOTAL VOLUME 28/10/10 | FLOOR VOLUME 03/11/10 | W/HOUSE VOLUME 03/11/10 | TOTAL VOLUME 03/11/10 | FLOOR VOLUME 15/11/10 | W/HOUSE VOLUME 15/11/10 | TOTAL VOLUME 15/11/10 | FLOOR VOLUME 18/11/10 | W/HOUSE VOLUME 18/11/10 | TOTAL VOLUME 18/11/10 | FLOOR VOLUME 25/11/10 | W/HOUSE VOLUME 25/11/10 | TOTAL VOLUME 25/11/10 | FLOOR VOLUME 02/12/10 | W/HOUSE VOLUME 02/12/10 | TOTAL VOLUME 02/12/10 | [NAME] | W/HOUSE VOLUME 09/12/10 | TOTAL VOLUME 09/12/10 | FLOOR VOLUME 16/12/10 | W/HOUSE VOLUME 16/12/10 | TOTAL VOLUME 16/12/10 | FLOOR VOLUME 30/12/10 | W/HOUSE VOLUME 30/12/10 | TOTAL VOLUME 30/12/10 | [NAME]07/01/11 | W/HOUSE VOLUME 07/01/11 | TOTAL VOLUME 07/01/11 | [NAME]14/01/11 | W/HOUSE VOLUME 14/01/11 | TOTAL VOLUME 14/01/11 | [NAME]19/01/10 | W/HOUSE VOLUME 19/01/10 | TOTAL VOLUME 19/01/10 | FLOOR VOLUME XX/XX/10 | W/HOUSE VOLUME XX/XX/10 | TOTAL VOLUME XX/XX/10 | FLOOR VOLUME XX/XX/10 | W/HOUSE VOLUME XX/XX/10 | TOTAL VOLUME XX/XX/10 | FLOOR VOLUME XX/XX/10 | W/HOUSE VOLUME XX/XX/10 | TOTAL VOLUME XX/XX/10 | FLOOR VOLUME XX/XX/10 | W/HOUSE VOLUME XX/XX/10 | TOTAL VOLUME XX/XX/10 | FLOOR VOLUME XX/XX/10 | W/HOUSE VOLUME XX/XX/10 | TOTAL VOLUME XX/XX/10
 | TFP/SFREM/1010 | REM 2, 3&4 L/HEAD | 8617R | 25000 | NA | 20000 | 8000 | 30000 | 38000 | 0 | 50000 | 50000 | 26000 | 22000 | 48000 | 20000 | 22000 | 42000 | 20000 | 22000 | 42000 | 7000 | 22000 | 29000 | 7000 | 22000 | 29000 | 1000 | 22000 | 23000 | 23000 | 0 | 23000 | 23000 | 0 | 23000 | 0 | 0 | 20000 | 20000 | 0 | 20000 | 20000 | 0 | 20000 | 20000 | 0 | 20000 | 20000 | 0 | 20000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TFP/OSREM/1010 | OVS REM L/HEAD | 8618R | 2000 | NA | 3000 | 4250 | 6600 | 10850 | 0 | 5400 | 5400 | 1900 | 3400 | 5300 | 1900 | 3400 | 5300 | 1900 | 3400 | 5300 | 5300 | 0 | 5300 | 5000 | 0 | 5000 | 5000 | 0 | 5000 | 5000 | 0 | 5000 | 5000 | 0 | 5000 | 0 | 0 | 3000 | 3000 | 0 | 3000 | 3000 | 0 | 3000 | 3000 | 0 | 3000 | 3000 | 0 | 3000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: kate_symes__18242__Deal Correction 3-28
Sheet: 3-21

Date of Inquiry | Adjustment date | Date of applied calc | Deal Date | Desk Involved | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
 | 2001-03-21 00:00:00 | 2001-03-21 00:00:00 | 2001-03-20 00:00:00 | STCA | JR | Houston | APB | Switched incorrect prices on two deals |  | 554905/554912 | SP-15 | 2001-03-21 00:00:00 | On [NAME] | 25 | 350/325 | Allegheny/Duke
 | 2001-03-21 00:00:00 | 2001-03-21 00:00:00 | 2001-03-20 00:00:00 | LTCA | BB | EES | N/A | CTPY: from EES to LTNW |  | 555432 | SP-15 | Q2-01 | On [NAME] | 25 | 145 | LTNW
 | 2001-03-21 00:00:00 | 2001-03-21 00:00:00 | 2001-03-16 00:00:00 | STCA | KS | EES | N/A | Change in volumes of EES load coverage |  | 552990/986 | SP-15 | 2001-03-19 00:00:00 | RTC | Shaped | 195 | EES/Cal Imbalance
 |  |  |  | Grand Count
Spreadsheet: 356099d1414979862-if-statement-help-discount-ndm-v2
Sheet: Sheet1

Distribution Costs |  |  |  |  |  |  | Discounted Distribution Costs
 |  | Spruce | [NAME] | Duchesne |  |  |  | Spruce | [NAME] | Duchesne
 | Seattle |  | 46.68 | 52.8 |  |  | Seattle
 | Chicago | 89.77 | 128.82 | 97.17 |  |  | Chicago
 | Dallas | 162.24 | 204.13 | 210.42 |  |  | Dallas
 | New Orleans | 166.18 | 195.08 | 200.62 |  |  | New Orleans
 | Denver | 151.77 | 162.83 | 142.82 |  |  | Denver
 | LA |  | 147.46 | 150.14 |  |  | LA
 | SF | 151.11 | 115.49 | 124.83 |  |  | SF
 | Vancouver |  | 72.42 | 42.17 |  |  | Vancouver
 | Calgary |  | 77.5 | 87.94 |  |  | Calgary
 |  | Spruce | [NAME] | Duchesne
 | Seattle | 0 | 40727 | 0
 | Chicago | 0 | 0 | 55608
 | Dallas | 0 | 92680 | 0
 | New Orleans | 0 | 38922.28571428571 | 53757.71428571429
 | Denver | 0 | 0 | 23832
 | LA | 150410.8571428572 | 0 | 61430.14285714284
 | SF | 0 | 52960 | 0
 | Vancouver | 0 | 0 | 32581
 | Calgary | 0 | 8145 | 0
 | Distribution Cost