tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 163882d1340527176-3-criteria-of-certain-dates-book1
Sheet: Sheet1

Date | Month
2012-04-01 00:00:00 | 4
2012-04-02 00:00:00 | 4
2012-04-03 00:00:00 | 4
2012-04-04 00:00:00 | 4 | 5 | 5
2012-04-05 00:00:00 | 4 | 5
2012-04-06 00:00:00 | 4 | 5
2012-04-07 00:00:00 | 4 | 5
2012-04-15 00:00:00 | 4 | 5
2012-04-21 00:00:00 | 4 | 5
2012-04-26 00:00:00 | 4 | 5
2012-05-01 00:00:00 | 5
2012-05-05 00:00:00 | 5 | 5 | 5
2012-05-11 00:00:00 | 5 | 5
2012-05-19 00:00:00 | 5 | 5
2012-05-25 00:00:00 | 5 | 5
2012-06-02 00:00:00 | 6
2012-06-04 00:00:00 | 6 | 5 | 5
2012-06-04 00:00:00 | 6
2012-06-04 00:00:00 | 6
2012-06-05 00:00:00 | 6 | 5
Spreadsheet: 221375d1363527384-vlookup-and-return-the-nth-value-sample3
Sheet: Sayfa1

 |  | 5 | 3 | 4 | 5 | 2 | 6 | 7
 |  | 1 | 2 | 4 | 8 | 4
 |  | 3 | 4 | 5 | 7 | 2 | 6
Spreadsheet: 293179d1390914693-how-to-apply-filter-on-multiple-excel-columns-challange-1-
Sheet: Sheet1

alt nm |  | data
Name 1 | Name 2 | marks |  | Name 1 | Name 2 | marks |  | Name 1 | Name 2 | marks
Ram | Mack | 21 |  | Ram | Mack | 21 |  | Atul | Atish | 112
[NAME] | Ram | 12 |  | [NAME] | Ram | 12 |  | Atish | Centi | 22
Sumit | [NAME] | 1 |  | Ram | Ram | 25 |  | Atish | [NAME] | 58
Atul | Atish | 112 |  | Ram | Centi | 87
Atish | Centi | 14
Ram | Ram | 25
Atish | Centi | 22
Ram | Centi | 87 |  | Table 2 (if we select [NAME] in column A using filter) |  |  |  | Table 3 (if we select Atish in column A using filter)
Atish | [NAME] | 58
Table 1
Spreadsheet: 65794d1266450189-macro-for-monthly-rolling-data-book1
Sheet: Actual

 | Jan | Feb | Mar | Apr | May
Income | 10 | 20 | 30 | 40 | 50
[NAME] | 100 | 200 | 300 | 400 | 500
Wages | 1000 | 2000 | 3000 | 4000 | 5000
[NAME] | 10000 | 20000 | 30000 | 40000 | 50000
Profit | 100000 | 200000 | 300000 | 400000 | 500000
Spreadsheet: 789359d1659054663-calculating-premium-hours-formula-example
Sheet: Blad1

Huidige datum |  |  | Contract uur | 40
[NAME] |  |  | Uurloon | 16.62
Maand |  |  |  |  |  |  |  |  |  | 0.25 | 0.3 | 0.5 | 1.5 | 1.3 | 1.5 | 1.5 | 3
Dag |  |  |  |  |  |  |  |  |  | 20:00:00 | 1900-01-01 00:00:00 | `00:00 | `00:00 | 1900-01-01 06:00:00 | 22:00:00 | `00:00 | `00:00
Weeknum |  |  |  |  |  |  |  |  |  | 1 day, 0:00:00 | 1900-01-01 06:00:00 | 1 day, 0:00:00 | 1 day, 0:00:00 | 22:00:00 | 1900-01-02 06:00:00 | 1 day, 0:00:00 | 1 day, 0:00:00
 |  |  |  |  |  |  |  |  |  | PRE | PRE | PRE | PRE | OT | OT | OT | OT
 | Weekday | Datum | Start | End |  |  | [NAME] | Hours worked | OT
 | Ma |  | 15:30:00 | 1900-01-01 00:30:00
 | Di |  | 03:00:00 | 11:00:00
 | Wo |  | 15:30:00 | 1900-01-01 00:00:00
 | Do |  | 15:30:00 | 1900-01-01 00:00:00
 | Vrij |  | 15:30:00 | 1900-01-01 00:00:00
 | Za |  | 10:00:00 | 19:00:00
 | Zo |  | 08:00:00 | 12:00:00
 | Totaal:
Spreadsheet: 838525d1691091856-is-there-a-way-to-add-rows-automatically-given-a-number-of-values-another-sheet-has-journal-entry-lines-missing-projects_practice
Sheet: Sheet 2

Invoice | Billable Project | Current Extended Amt | Extended Amt as of 12 am Prompt Date | Company | Customer
Invoice 1 | Project 1 | 12994.37 | 12994.37 | X | Happy Customer
Invoice 1 | Project 2 | 12994.37 | 12994.37 | X | Happy Customer
Invoice 1 | Project 3 | 6390.68 | 6390.68 | X | Happy Customer
Invoice 1 | Project 4 | 7668.81 | 7668.81 | X | Happy Customer
Invoice 1 | Project 5 | 15976.68 | 15976.68 | X | Happy Customer
Invoice 1 | Project 6 | 10225.08 | 10225.08 | X | Happy Customer
Invoice 2 | Project 10 | 34750 | 34750 | X | Great Customer
Invoice 2 | Project 11 | 5000 | 5000 | X | Great Customer
Spreadsheet: 160426d1339083050-count-of-style-in-a-range-of-sale-contribution-book3-test
Sheet: Contribution

Total Sales
3147815
% | 0.2 | 0.25 | 0.5 | 0.75 | 0.9 | 1
Row Position | 12 | 17 | 54 | 131 | 243 | 630
 | SALES | 0% - 20% | 0% - 25% | 0% - 50% | 0% - 75% | 0% - 90% | 0% - 100%
CUMULATIVE | Styles | 12 | 17 | 54 | 131 | 243 | 630
 | Sales $ | 609570 | 764872 | 1563204 | 2357857 | 2832351 | 3147815
 | Sales $ / style | 50797.5 | 44992.47058823529 | 28948.22222222222 | 17998.90839694656 | 11655.76543209877 | 4996.531746031746
SALES | 0%-20% | 21%-25% | 26%-50% | 51%-75% | 76%-90% | 91%-100% | TOTAL
Styles | 12 | 5 | 37 | 77 | 112 | 387 | 630
Sales $ | 609570 | 155302 | 798332 | 794653 | 474494 | 315464 | 3147815
Sales $ / style | 50797.5 | 31060.4 | 21576.54054054054 | 10320.16883116883 | 4236.553571428572 | 815.1524547803617 | 4996.531746031746
Sales Units | 32003 | 7555 | 32748 | 29810 | 21628 | 24520 | 148264
EOH Units | 269446 | 56306 | 269651 | 270516 | 233512 | 376593 | 1476024
AVG WOS | 8.419398181420492 | 7.452812706816678 | 8.234121167704899 | 9.074672928547468 | 10.79674496023673 | 15.35860522022839 | 9.9553768952679
Styles under AVG WOS | 189 | 141 | 178 | 208 | 291 | 432 | 1439
Styles over AVG WOS | 441 | 489 | 452 | 422 | 339 | 198 | 2341
 | The average WOS is 8.4 (Cell B19,C19,E19...), how many styles that I have under AVG WOS, how many over AVG WOS
 | The total of these 2 rows must be 631 each
Spreadsheet: 5e5be423-293a-4474-9dbd-f6d1dc336d16
Sheet: CPI-based on Jun13

 |  |  |  |  |  |  |  |  |  |  |  | Revised Referendum Cap Inflation Estimates
 |  |  |  |  |  |  |  |  |  |  |  | FY 2005 - FY 2023
CPI - Urban Consumers
August 2013 Update
Source of CPI Data: DOF- [NAME]
Date: August 16, 2013
 |  |  | CALENDAR | CALENDAR | CALENDAR | CALENDAR | FISCAL | RATE OF | CUMMULATIVE
 |  |  | QUARTER | QUARTER | QUARTER | QUARTER | YEAR | INCREASE | RATE OF
 |  |  | 1 | 2 | 3 | 4 | AVERAGE |  | INCREASE
 |  |  |  |  |  |  |  |  |  |  | A | B | C | D | E | F | G
 |  |  |  |  |  |  | (PYQ3+PYQ4+CYQ1+CYQ2)/4 |  |  |  |  | Projected |  | Projected |  | [NAME]. [NAME] | Projected
 |  |  |  |  |  |  |  | (CY AVG/PY AVG)-1 |  |  | Annual | Inflation | [NAME] | Inflation | Projected | Increase | Inflation
Fiscal |  | Calendar | 1st | 2nd | 3rd | 4th |  |  | (CY % / BASE YR %) |  | Projected | Ratio | Allow Based | Based | [NAME]. [NAME] | over | Ratio
Year |  | Year |  |  |  |  |  |  |  |  | Inflation | [NAME]. [NAME] | [NAME]. [NAME] | [NAME]. [NAME] | Gtr of C or D | FY 2004 or | Alt. [NAME]*
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FY 2015
2003 |  | 2003
 |  | 2004
 |  | 2005 |  |  |  |  |  |  |  |  | 0.0301 | 1.0301
 |  | 2006 |  |  |  |  |  |  |  |  | 0.0381 | 1.0693
 |  | 2007 |  |  |  |  |  |  |  |  | 0.0261 | 1.0973
 |  | 2008 |  |  |  |  |  |  |  |  | 0.0367 | 1.1376
 |  |  |  |  |  |  |  |  |  |  | 0.0142 | 1.1537
 |  |  |  |  |  |  |  |  |  |  | 0.0093 | 1.1644
 |  |  |  |  |  |  |  |  |  |  | 0.0203 | 1.1881
 |  |  |  |  |  |  |  |  |  |  | 0.0294 | 1.223
 | e
2014 | e | 2014
New Law Formula for FY 2015 and Out
2015 | e | 2015 |  |  |  |  |  |  |  |  |  |  | na |  |  |  | 1
2016 | e | 2016 |  |  |  |  |  |  |  |  |  |  | na
2017 | e | 2017 |  |  |  |  |  |  |  |  |  |  | na
2018 | e | 2018 |  |  |  |  |  |  |  |  |  |  | na
2019 | e | 2019 |  |  |  |  |  |  |  |  |  |  | na
2020 | e | 2020 |  |  |  |  |  |  |  |  |  |  | na
2021 | e | 2021 |  |  |  |  |  |  |  |  |  |  | na
2022 | e | 2022 |  |  |  |  |  |  |  |  |  |  | na
2023 | e | 2023 |  |  |  |  |  |  |  |  |  |  | na
Old Law Formula Calculation for FY 2015
2015 | e | 2015
Notes:
1.  FY 2014 formula allowance uses new law value of $5,302.
2.  FY015 Old Law Calculation reverts back to the FY 2013 formula allowance of $5,224.
3.  Finalized calculation through FY 2012 based on actual Bureau of Labor Statistics data.
Spreadsheet: 490094d1479668386-way-to-do-data-validation-on-cells-depending-on-adjacent-cells-excel-adjacent-cell-vaildation-example
Sheet: Jan

1
Date
Day of Week
Holiday?
Employee | Date of | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
Name | Hire
[NAME] | 1994-01-01 00:00:00 | S | H |  |  |  |  |  |  |  |  |  |  |  |  | B | B | B
[NAME] | 1996-02-02 00:00:00 |  | H
[NAME] | 1997-03-03 00:00:00 |  | H
Legend: | COMMENTS:
 | [NAME] results that would alert when rules are broken here?
Spreadsheet: 007e6dc3-20a3-4464-a8f3-43a87661538d
Sheet: Sheet1

APN: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Address: | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | A.  Residential Project Statistics
EXISTING
Bldg. Floor | [NAME]) |  | Structure Type |  | Zoning           Net | Building & Safety Floor Area      (B&S Gross) | Alteration/     Remodel          B&S Gross
 | existing
 | existing |  |  | +
 | existing |  |  | +
 |  |  | Existing Main Building Area SUBTOTALS: |  | 0 | 0 | 0
 | Garage/Carport
 | existing | attached or detached | Garage | +
 | existing |  | Carport | +
 | [NAME]
 | existing | attached or detached |  | +
 | existing |  |  | +
 | Basement or Cellar
 | existing | attached or detached
 |  |  | Existing Area TOTALS: |  | 0 | 0 | 0
PROPOSED NEW CONSTRUCTION, INCLUDING  ANY "AS BUILT" PROPOSALS
Bldg. Floor | Main Building(s) |  | Structure Type |  | Net | B&S Gross
 | addition or new structure |  |  |  |  |  | square feet
 |  |  |  | + |  |  | square feet
 |  |  |  | + |  |  | square feet
 |  |  | Proposed Area SUBTOTALS: |  | 0 | 0 | square feet
 | Garage/Carport
 | addition or new structure |  |  | + |  |  | square feet
 | [NAME] |  |  |  |  | 0
 | addition or new structure |  |  | + |  |  | square feet
 |  |  |  | + |  |  | square feet
Non-Habitable Accessory Total: |  |  | 0 |  | n.a. | n.a. | square feet
 | Basement or Cellar
 | addition or new structure |  |  |  |  |  | square feet
 |  |  | Proposed Area TOTALS: |  | 0 | 0 | square feet
RESIDENTIAL TOTAL (EXISTING + NEW) = |  |  |  |  | 0 | 0 | square feet*
 | *B&S Gross res. sq. ft. includes useable roof deck sq. ft. from "General Sheet".
 |  |  | SCHOOL FEE SQ. FT. ESTIMATE  = |  | 0 |  | (CA Gov. Code §63080)
Note: Any square footage for enclosed attic, cellar or basement areas < 5' in floor to ceiling height is not included. |  |  |  |  |  |  | rev.1/18/07
PROPOSED RESULTING PROJECT SUMMARY |  |  |  |  |  | (SBMC § 28.87.300)
 |  |  |  |  | Net | Gross
 |  |  | PROPOSED RESIDENTIAL (EXISTING + NEW) = |  | 0 | 0
 |  |  | PROPOSED GARAGE/CARPORT (EXISTING + NEW)= |  | 0 | 0
 |  |  | TOTAL: |  | 0 | 0
Spreadsheet: 470818d1468679294-ref-error-when-inserting-row-into-table-precious-metals-template-5-prc
Sheet: Gold (Inventory)

 |  | TOTAL P/L |  |  |  | TOTALS
 | Year | Description | Mint | Purchase Date | Units | Weight (oz) | Total Weight | Purchase Price | Spot Value | Premium | P/L ($) | P/L (%)
 | Total
Spreadsheet: 843838d1695665180-how-can-i-ignore-empty-cells-ignoring-blanks-cells-in-data-list
Sheet: Sheet1

 |  | 1 | 2 | 3 | 4 | 5 | 6 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 |  |  |  |  | Y | H | D |  |  |  |  | B | Y | H | D
 | INGORE BLANK | Y | H | D |  |  |  |  | INGORE BLANK (REVERSE) | D | H | Y | B
Spreadsheet: 61013d1261589927-how-to-copy-cells-based-upon-criteria-smallworksheet
Sheet: Sheet1

 | [P] | iVillage.com: The Womens Network | 0
 | [M] | 1BABY.COM | 1
 | [M] | 1STBABY.COM | 2
 | [M] | 800BABYGIFTS.COM | 3
 | [M] | 888BABYGIFT.COM | 4
 | [M] | 888BABYGIFTS.COM | 5
 | [M] | ADVANCESINNEUROLOGY.COM | 6
 | [M] | ADVANCESINONCOLOGY.COM | 7
 | [M] | ALLWOMENSHEALTH.COM | 8
 | [M] | ALZHEIMERS.COM | 9
 | [C] | *.ALZHEIMERS.COM | 9
 | [S] | *.ALZHEIMERS.COM | 9
 | [M] | ALZHEIMERSNOW.COM | 10
 | [M] | [NAME] | 11
 | [C] | AMAZINGPREGNANCY.COM | 11
Spreadsheet: 744397d1629217160-count-unique-within-table-book1
Sheet: Sheet1

Location | User |  |  |  | Summary Table
Place A | User1
Place A | User1 |  |  |  | Location | Total Entries | [NAME] | What I want it to say
Place A | User1 |  |  |  | Place A |  |  | 2
Place A | User2 |  |  |  | Place B |  |  | 1
Place A | User2 |  |  |  | Place C |  |  | 2
Place B | User3
Place B | User3
Place B | User3
Place B | User3
Place C | User4
Place C | User4
Place C | [NAME]
Spreadsheet: 732134d1620791207-sort-the-values-in-column-a-in-ascending-order-and-extract-corresponding-values-non-array-to-sort-values
Sheet: Sheet2

Employee Name | Employee ID | Req. | Req. Date | Helper |  | Employee Name | Employee ID | Req. | Req. Date |  | Employee Name | Employee ID | Req. | Req. Date |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Ah, [NAME] | EH1022 | GIO | 2021-02-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Ah, [NAME] | EH1022 | TOTO | 2021-02-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Bow, [NAME] | EH1029 | TOTO | 2021-02-03 00:00:00
 |  |  |  |  |  |  |  |  |  |  | [NAME], Ebese | EH1023 | RTY | 2021-02-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  | [NAME], Head | EH1011 | BLISS | 2021-02-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Christine, Venus | EH1018 | FMA | 2021-02-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Elastic, Method | EH1013 | EL | 2021-02-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Erico, Bell | EH1007 | EL | 2021-02-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Erico, Bell | EH1007 | CL | 2021-02-02 00:00:00
Spreadsheet: 02e4b555-05a6-40f8-a00e-8401a50136eb
Sheet: 8

 | Jan 18 |  | Jan 25 |  | Feb 1 |  | Feb 8
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rate* | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs** | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly total, estimated swap dollar volumes by asset class and participant type (value of all trades in milliions of USD), all products and tenors, cleared and uncleared.
Estimates of weekly event volumes are derived from data published in the 2012 ISDA Operations Benchmarking Survey which defines an "event" as a new trade, confirmable amendment, partial or full termination, increase, decrease, or novation.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 153710d1336022173-how-do-i-sumif-a-date-range-using-rows-not-columns-cashflow-statement
Sheet: Weekly

 |  | Opening Balance |  |  |  |  |  |  |  |  |  |  |  |  |  | Closing Balance
 | Cash on Hand
 | CASH RECEIPTS
 | Cash Sales
 | EFTPOS Sales
 | TOTAL CASH RECEIPTS
 | CASH PAID OUT
 | Tonkin
 | Decosti
 | Discount Packaging
 | Coca Cola Amatil
 | Juice
 | Chicken
 | Fresh Vegetables
 | Other (Specify)
 | Other (Specify)
 | Other (Specify)
 | Wages
 | Rent
 | Repairs & maintenance
 | Advertising
 | Telephone
 | Utilities (Electricity)
 | Utilities (Gas)
 | Utilities (Water/Waste)
 | Miscellaneous (Specify)
 | Miscellaneous (Specify)
 | SUBTOTAL
 | [NAME]'s Withdrawal
 | TOTAL CASH PAID OUT
 | CASH POSITION (End of Week)
Spreadsheet: 478638d1472927017-how-to-automate-date-in-subsequent-tabs-general-daily-cashflow_sept_vik-rev-02
Sheet: 090916

XXXX INC.
DAILY CASH FLOW POSITION AS ON |  |  |  | 2016-09-09 00:00:00
 | .
INCOMING (XXXX) |  |  |  |  |  | INCOMING (YYYY)
Driver | ROUTE | MONEY COLLECTED |  |  |  | Driver | ROUTE | MONEY COLLECTED
 |  | CASH | Money Order | CHECKS |  |  |  | CASH | Money Order | CHECKS
CLAUDIO 8/8 | 152
[NAME] | 8 |  |  |  |  | LUIS C | 31
HARVEY | 12 |  |  |  |  | AUGY | 32
ROJO | 13 |  |  |  |  | BUD | 33
EFREN | 16
BRENT | 25 |  |  |  |  |  | Total Routes
LUIS G | 50
[NAME] | 150 |  |  |  |  |  | SHORT
[NAME] | 550 |  |  |  |  |  | HOLDS
WILSON | 76 |  |  |  |  |  | RECEIPTS
[NAME] | 550 |  |  |  |  |  | Total Outgo
BRENT 8/8 | 25
 | Collection |  |  |  |  |  | DEPOIST TO ROCKVIEW
 | Total Routes
 | Other Cashflow
 | Previous Day not accounted
 | Checks reced in Mail |  |  |  |  | XXXX- MISC.
 | Checks redeposited NSF
 | Checks on HOLD |  |  |  |  | NAME |  | SHORTAGE
 |  |  |  |  |  | [NAME] |  | 0
 | Total Incoming (XXXX) |  |  |  |  | HARVEY |  | 0
 |  |  |  |  |  | ROJO |  | 0
 |  |  |  |  |  | EFREN |  | 0
OUTGOING (XXXX) |  |  |  |  |  | BRENT |  | 0
 | [NAME] |  |  |  |  | LUIS G |  | 0
 | Petty cash (Receipts) |  |  |  |  | [NAME] |  | 0
 | Mechanics |  |  |  |  | [NAME] |  | 0
 | Payroll |  |  |  |  | WILSON |  | 0
 | [NAME] |  |  |  |  | CLAUDIO RT |  | 0
 | [NAME]
 | Rockview |  |  |  |  | TOTAL SHORTAGE
 | [NAME]
 | Checks Bounced |  |  |  |  | [NAME]
 |  |  |  |  |  | DATE |  | CREDIT
 | Total Outgoing (XXXX)
RECONCILIATION (XXXX)
 | Total Incoming (XXXX)
 | Total Outgoing (XXXX)
 | [NAME]
 | BANK DEPOSITS
 | CASH HANDED OVER
 | SHORTAGE
Spreadsheet: richard_shapiro__32601__Accomplishment-june5th2001-Masteredit
Sheet: EGM

Accomplishment for the Period November 2000 to April 2001
No. | Accomplishments | Customer | Value | Area |  |  |  |  | Methodology
 | (description) | (B. Unit) | ($) | Deal Support | Origination | Risk Management | [NAME] | Other
[NAME]
1 | Developing an “early warning system” for trade actions (antidumping, countervailing) to minimize Enron’s financial exposure | Steel / Forest Products |  |  |  |  |  |  | Under general
2 | Developed Enron’s opposition strategy to a Section 201 proceeding on steel imports | Steel / Forest Products |  |  |  |  |  |  | Under general
3 | Developing strong relationships with other like-minded companies, such as Caterpillar | Steel / Forest Products |  |  |  |  |  |  | Under general
4 | Developed roll-out strategy for Enron’s entry into the agriculture business. | Agricultural Trading |  |  |  |  |  |  | Under general
5 | Designing a risk management program that would hedge USDA’s exposure to declines in farm values. | Agricultural Trading |  |  |  |  |  |  | Under general
6 | Conducted meetings with farm commodity groups to relax regulatory oversight requirements for agricultural commodities | Agricultural Trading |  |  |  |  |  |  | Under general
7 | Worked with commercial group to develop Enron’s model for tradeable rail capacity market. | Freight Markets |  |  |  |  |  |  | Under general
8 | Advocated Enron’s model for tradeable rail capacity, adopted in part by Burlington Northern railroad for coal movements | Freight Markets |  |  |  |  |  |  | Under general
9 | Succeeded in attracting railroad carriers  to join a coalition to advocate increased competition | Freight Markets |  |  |  |  |  |  | Under general
10 | Initiated interest from one railroad in doing a joint venture with Enron’s new freight business | Freight Markets |  |  |  |  |  |  | Under general
11 | Provide ongoing regulatory input and advice on pleadings in Elba Island case before FERC | LNG |  |  |  |  |  |  | Under general
12 | Intervene, monitor and participate in LNG-related proceedings before FERC | LNG
Spreadsheet: sally_beck__33950__Weekly Operating Report 2-8
Sheet: Data

New Deals |  |  |  | Contracts
Physical Gas | 6500 |  |  |  | Gas On-System | Gas Off-System | Power
Financial Gas | 7500 |  |  | Buy | 2 | 6 | 3
Physical Power | 4000 |  |  | Sell | 3 | 10 | 2
Financial Power | 55 |  |  | Transport | 4 | 2 | 0
Physical Lumber | 3 |  |  | Storage | 0 | 0 | 0
Financial Lumber | 5
Physical Newsprint | 10
Financial Newsprint | 20
 |  |  |  | New Deals
Financial Liquids | 50 |  |  |  | 12/29 - 1/4 | 1/5 - 1/11 | 1/12 - 1/18 | 1/19 - 1/25 | 1/26 - 2/1 | 2/2 - 2/8
IR/FX | 175 |  |  | Gas |  |  |  |  |  |  |  | MMBTU
Weather | 2 |  |  | Power |  |  |  |  |  |  |  | MHtz
Physical Pulp | 20 |  |  |  | 12/29 - 1/4 | 1/5 - 1/11 | 1/12 - 1/18 | 1/19 - 1/25 | 1/26 - 2/1
Financial Pulp | 30 |  |  | IR/FX |  |  |  |  |  |  |  | BBL
Physical Steel | 1 |  |  | Liquids |  |  |  |  |  |  |  | TONNE
Financial Steel | 3 |  |  | Coal |  |  |  |  |  |  |  | HDD/CDD
Coal | 2 |  |  | Weather |  |  |  |  |  |  |  | USD
Physical Liquids | 65 |  |  | Emissions |  |  |  |  |  |  |  | CONTRACTS
Emissions | 10 |  |  |  | 12/29 - 1/4 | 1/5 - 1/11 | 1/12 - 1/18 | 1/19 - 1/25 | 1/26 - 2/1
 |  |  |  | Newsprint |  |  |  |  |  |  |  | TONNE
M&A | 0 |  |  | Pulp |  |  |  |  |  |  |  | TONNE
Legal | 0 |  |  | Lumber |  |  |  |  |  |  |  | TONNE
Lease | 0 |  |  | Steel |  | 0 | 0 | 0 |  |  |  | TONNE
Auction | 1
Gas | 1300 |  |  | [NAME]
Power | 250 |  |  |  | 12/29 - 1/4 | 1/5 - 1/11 | 1/12 - 1/18 | 1/19 - 1/25 | 1/26 - 2/1
Others | 50 |  |  | MMBTU
Lumber | 0 |  |  | MHtz
Power | 250 |  |  |  | 12/29 - 1/4 | 1/5 - 1/11 | 1/12 - 1/18 | 1/19 - 1/25 | 1/26 - 2/1
 |  |  |  | Total EIM
Newsprint | 0 |  |  | Newsprint
Pulp | 5 |  |  | Pulp
Steel | 0 |  |  | Lumber
 |  |  |  | Steel
Power | 250 |  |  |  | 12/29 - 1/4 | 1/5 - 1/11 | 1/12 - 1/18 | 1/19 - 1/25 | 1/26 - 2/1
 |  |  |  | Liquids
EGM |  |  |  | Coal
Liquids | 45 | 40 | 55 | Emissions | 5 | 5
IR/FX | 150 | 120 | 125 | Weather | 49250 | 45350 | 120900 | 115500
 |  |  |  | IR/FX | 6275000 | 6398750 | 3718000 | 6618000
Weather | 2 | 5 | 2
Emissions | 2 | 1 | 10
ENA
Gas | 11000 | 12500 | 12000
Power | 5500 | 5000 | 4055
EIM
Newsprint | 25 | 52 | 30
Pulp | 10 | 42 | 50
Lumber | 8 | 8 | 8
Steel | 3 | 1 | 4
Date | Unit Type | Commodity | Units | New Deals
Wk 1 | MMBTU | Gas | 1350
Wk 1 | MHtz | Power | 180 | 5500
Wk 1 | Loads | Lumber | 8 | 8
Wk 1 | Bails | Newsprint | 15 | 25
Wk 1 | Bars | Steel | 5 | 3
Wk 1 | Buckets | Pulp | 10 | 10
Wk 1 | [NAME] | Liquid | 45 | 45
Wk 1 | Lumps | Coal | 2 | 2
Wk 2 | MMBTU | Gas | 1505
Wk 2 | MHtz | Power | 175 | 5000
Wk 2 | Loads | Lumber | 10 | 8
Wk 2 | Bails | Newsprint | 25 | 52
Wk 2 | Bars | Steel | 7 | 1
Wk 2 | Buckets | Pulp | 30 | 42
Wk 2 | [NAME] | Liquid | 32 | 40
Wk 2 | Lumps | Coal | 2 | 1
Wk 3 | MMBTU | Gas | 1600
Wk 3 | MHtz | Power | 190 | 4055
Wk 3 | Loads | Lumber | 10 | 8
Wk 3 | Bails | Newsprint | 25 | 30
Wk 3 | Bars | Steel | 8 | 4
Wk 3 | Buckets | Pulp | 40 | 50
Wk 3 | [NAME] | Liquid | 37 | 55
Wk 3 | Lumps | Coal | 2 | 2
Spreadsheet: 845642d1697060035-bring-over-data-from-one-file-to-another-file-in-table-format-roll-up-final-table
Sheet: Sheet1

Sample File A | Green = Ahead LOB; behind prior YTD
Location | [NAME] = Ahead of LOB and Prior YTD
Date | Red = Behind LOB ahead Prior YTD
Date2 | Red Bold = Behind both
Same | TestNumber | Size | Last |  | Prior |  | Sample
EFG - Sample 1 | 145 | 4522 | 9595 |  | 963 |  | 9874
Same 1 | TestNumber | Size | Last |  | Prior |  | Sample
ABDC - Sample Test File | 123 | 4567 | 8981 |  | 980000 |  | 365
Spreadsheet: 883826d1732552282-looking-for-function-to-find-how-many-times-an-instance-in-a-list-is-chosen-test2
Sheet: Hou-Blue

Selection s  day 3
28B
29
36
38 t
40
45
47b
49t
49b
53
63
65
72
87
89
99
107
128
132
142
146
148
155
159
162
168
171
217
218
239
282
323b
268
273
276
277
283
293
300
336
348
365
393
422b
427
444t
447t
449
451b
463
484b
489
492
497
498
500
505
508
511
518
522
540
541
543b
553b
559
563
571
572
587