tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 787305d1657722094-add-then-deduct-add-then-deduct-13-jul-
Sheet: Add Then Deduct (13-Jul)

 | NOTES |  |  | Employee Totals
 | Preload gray cells with needed information |  |  | Vacation |  | Personal Time |  | Bonus Time |  | Time Off Totals
 |  |  |  | Totals Available: |  | Totals Available: |  | Totals Available: |  | Totals Available:
 |  |  |  | Totals Spent: |  | Totals Spent: |  | Totals Spent: |  | Totals Spent:
 |  |  |  | Totals Left: |  | Totals Left: |  | Totals Left: |  | Totals Left:
 | Employee | Department | Renewal Talk | Vacation |  | Personal Time |  | Bonus Time |  | Time Off Totals
 | Last, First | Bakery |  | Available: | 60 | Available: | 32 | Available: | 8 | Available:
 | 2022-09-18 00:00:00 | Vacation Input→ | 4 | Spent: | 8 | Spent: | 31.99 | Spent: | 2 | Spent:
 |  | Personal Time Input→ |  | Left: |  | Left: |  | Left: |  | Left:
 | Last, First | Boxes |  | Available: | 40 | Available: | 16 | Available: | 8 | Available:
 | 2023-07-02 00:00:00 | Vacation Input→ |  | Spent: |  | Spent: |  | Spent: | 4 | Spent:
 |  | Personal Time Input→ |  | Left: |  | Left: |  | Left: |  | Left:
 | Last, First | Boxes |  | Available: | 80 | Available: |  | Available: | 8 | Available:
 | 09-15-2022 | Vacation Input→ |  | Spent: |  | Spent: |  | Spent: | 3 | Spent:
 |  | Personal Time Input→ |  | Left: |  | Left: |  | Left: |  | Left:
Spreadsheet: 99457d1298064074-using-today-date-to-return-ytd-budget-example
Sheet: Sheet1

 |  |  | GP Achieved | 2700400
 |  |  | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | June
 |  |  | 0.06494858095448118 | 0.06764850654858928 | 0.09990215076767496 | 0.0762409270377578 | 0.06830073414061133 | 0.122354091311209 | 0.05873594873462452 | 0.06942063315179292 | 0.08975729126877374 | 0.07164654023122491 | 0.08757237891998008 | 0.1234722169332804
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 3650000
 |  | YTD Budget
 |  |  |  | July to Feb equals 2290563, this is the figre I want to be retrieved not simply 253,385
Spreadsheet: mary_fischer__25622__87P
Sheet: E2.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 087P
COMPANY NAME  EFS Water Treatment Services
ANALYSIS OF OTHER CURRENT ASSETS
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:[NAME]
EXTENSION:[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-2
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
Due from Timberline (Texas State Construction) |  | 0 |  | 380
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Total Current Assets | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 195
Asset/Expense Accts:  DR/(CR)
Spreadsheet: 04f446bd-a27c-4001-8a98-83a1e4992948
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
08/31/2013 | Women's Cross Country | Lehigh Invitational | 12:00 AM | 4th place
[NAME] | Women's Cross Country | PSU Spiked Shoe Invitational | 12:00 AM | 8th place
10/05/2013 | Women's Cross Country | [NAME] | 12:00 AM | 8th Place
10/18/2013 | Women's Cross Country | PSU National | 12:00 AM | 1st Place
11/02/2013 | Women's Cross Country | Big 12 Championships* | 12:00 AM | 2nd Place
11/15/2013 | Women's Cross Country | NCAA Mid-Atlantic Regional | 12:00 AM | 4th Place
11/23/2013 | Women's Cross Country | NCAA Cross Country Championship | 12:00 AM | 24th Place
Spreadsheet: 773758d1648036785-duplicate-and-look-up-workbook
Sheet: Sheet3

this is the  table that needs to be automatically produced based on the source data above (sheet 3)
Site | Project | Project | Project | Project | Project
A | P1 Project 1 | P1 Project 5 | P9 Project 9 | P6 Project 6
C | P3 Project 3 | P4 [NAME] | P7 Project 7 | P6 Project 6 | P10 Project 10
D | P8 Project 8 | P6 Project 6
Spreadsheet: 593582d1539224223-extremely-complicated-searching-copy-of-sheet-1-geode7-
Sheet: Sheet1

AAA | aAA.bs
AAA | aAA-T.bs
AAA | be.px
aAA.bsa | bf.px
aAA-T.bsa | c0.px
 |  | Total
If I for example, I asked to count how many .pex files there are in AAA, aAA.bs and aAA-T.bs, my statement would be, "For all cells in Column B where in Column A there are cells that contain AAA, where there are .bs, display the result(s).                                                                        Ie: If A2=B2:B6, display all results from Column B with .bs in them (Lets call the results DB1 & DB2). Then do IF DB1 & DB2 = A2:A6, COUNTIF(B2:B6, ".px")
Spreadsheet: 053f016b-2c44-40ec-9502-06942c5a3a2a
Sheet: Sheet1

 |  |  |  | IMPERIAL VALLEY COLLEGE
 |  |  |  | WOMEN'S BASKETBALL
 |  |  |  | 2013-2014
 | DATE |  | DAY | OPPONENT |  |  | PLACE | TIME | DEPARTURE TIME
 | OCT 29 |  | TUES | RED/WHITE SCRIMMAGE & BBQ SOCIAL |  |  | IVC | 18:00:00
 | NOV 22-24 |  | FRI- SUN | BARSTOW COLLEGE TOURNAMENT |  |  | B.C | TBA | 07:00:00
 | NOV 29-Dec 1 |  | FRI. - SUN | VENTURA COLLEGE TOURNAMENT |  |  | V.C | TBA | 07:00:00
 | DEC 5-7 |  | THURS-SAT | IRVINE VALLEY COLLEGE TOURNAMENT |  |  | IRVINE | TBA
 | DEC 13-15 |  | FRI - SUN | SAN DIEGO CITY TOURNAMENT |  |  | SDC | TBA | 07:00:00
 | DEC 19 |  | THUR | COLLEGE OF THE DESERT |  |  | COD | 17:00:00
 | JAN 3 |  | FRI | [NAME] |  |  | G.C. | 17:00:00
 | JAN 8 |  | WED | #*MT. SAN JACINTO |  |  | I.V.C | 17:00:00 | 1:00PM
 | JAN 10 |  | FRI | *MIRACOSTA |  |  | M.C. | 17:00:00
 | JAN 15 |  | WED | *PALOMAR COLLEGE |  |  | IVC | 17:00:00
 | JAN  17 |  | FRI | *SAN DIEGO MESA COLLEGE |  |  | SDMC | 17:00:00
 | JAN  22 |  | WED | *SAN DIEGO CITY COLLEGE |  |  | IVC | 17:00:00 | 1:00PM
 | JAN  24 |  | FRI | #*SOUTHWESTERN COLLEGE |  |  | SW | 17:00:00
 | JAN  29 |  | WED | *GROSSMONT COLLEGE |  |  | IVC | 17:00:00 | 1:00PM
 | JAN 31 |  | FRI | #*MT. SAN JACINTO COLLEGE |  |  | MSJC | 17:00:00
 | FEB 5 |  | WED | #*MIRA COSTA COLLEGE |  |  | IVC | 19:00:00
 | FEB 7 |  | FRI | *PALOMAR COLLEGE |  |  | PC | 17:00:00 | 13:00:00
 | FEB 12 |  | WED | *SAN DIEGO MESA COLLEGE |  |  | IVC | 17:00:00 | 15:00:00
 | FEB 14 |  | FRI | *SAN DIEGO CITY COLLEGE |  |  | SDCC | 19:00:00 | 13:00:00
 | FEB 19 |  | WED | #SOUTHWESTERN COLLEGE |  |  | IVC | 19:00:00
 | FEB 21 |  | FRI | *GROSSMONT COLLEGE |  |  | GC | 19:00:00 | 1:00PM
* Denotes Conference Games
# Denotes doubleheaders
 | [NAME] |  | Head Coach | (760) 355 - 6165
 | TBA |  | Asst .Head Coach | (760) 355 - 6325
 | [NAME] |  | Athletic Director | (760) 355 - 6341
 | [NAME] |  | Secretary | (760) 355 - 6325
 | [NAME] Mays |  | Athletic Trainer | (760) 355 - 6329
 |  |  | Athletic Fax | (760) 355 - 6514 |  |  |  | 2013-10-14 00:00:00
 |  |  |  | Athletic Department 380 East Aten Rd. Imperial, CA 92251
Spreadsheet: 140355d1328716209-excel-2007-looking-for-help-with-if-statement-to-add-multiple-cells-copy-of-weekly-template-for-business-1
Sheet: self service

 |  | QUARTER PULL
DAY | DATE | AIR |  | VACUMES |  | AIR FRESH |  | SHAMPOO |  | VENDING |  | TOTAL PULL
 |  | # | $$ | # | $$ | # | $$ | # | $$ | # | $$ | # | $$
Sun
Mon
[NAME]
Wed
Thurs
Fri |  | 4150
Sat |  | 5000
TOTAL
 |  | [NAME] |  |  |  |  | RIGHT CHANGER |  |  |  |  |  | DEPOSIT
DAY | DATE | previous | DIFF | $$ OUT | QUART-IN | NET | previous | DIFF | $$ OUT | QUART-IN | NET
Sun
Mon
[NAME]
Wed
Thurs
Fri
Sat
TOTAL
Spreadsheet: 605761d1547251528-populate-name-vacation-date-information-into-calendar-format-in-separate-tab-leave-planner-template-v2
Sheet: Enter Employees

Employee Name | Annual Vacation Entitlement | Unused Days in Lieu Carried over | Total Vacation Entitlement | Date Vacation Calculations Start | Original Start Date | Date Terminated
(LAST Name, FIRST Name) | (Total # of days) | (Total # of days) | (Total # of days) | (yyyy/mm/dd) | (yyyy/mm/dd) | (yyyy/mm/dd)
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
Spreadsheet: 139681d1328379030-if-function-with-cells-containing-formulas-050
Sheet: DATA 1

 |  | ROOF PITCH
 |  | 10 - 25˚
 |  | 26 - 35˚
 |  | 36 - 45˚
 |  | 46 - 55˚
 |  | RAINFALL INTENSITY
 |  | 50
 |  | 70
 |  | 80
 |  | 90
 |  | 100
 |  | 110
 |  | 120
 |  | 130
 |  | 140
 |  | 150
 |  | 160
 |  | 170
 |  | 180
 |  | 190
 |  | 200
 |  | GUTTER TYPES
 |  | [NAME] | 5100 | 1
 |  | [NAME] | 6700 | 2
 |  | Marley FL2 | 4800 | 3
 |  | Marley Typhoon | 6100 | 4
 |  | MarleyOvation | 13834 | 5
 |  | [NAME] | 13200 | 6
 |  | Metalcraft Box 125 | 8435 | 7
 |  | Metalcraft Box 175 | 19250 | 8
 |  | Metalcraft Box 300 | 27000 | 9
 |  | Metalcraft Squareline | 6090 | 10
 |  | Metalcraft Hiline | 7550 | 11
 |  | Mcraft Metaline Quad | 5550 | 12
 |  | Mcraft Quarter Round | 4880 | 13
 |  | Mcraft Half Round | 5650 | 14
 |  | [NAME] | 7550 | 15
 |  | [NAME]
Spreadsheet: 847367d1698327617-articlenumbers-that-appear-on-the-same-ordernumber-book1
Sheet: Sheet1

[NAME] | Art
1 | X |  | Arts | Count
1 | Y |  | x
1 | Z |  | Y
2 | X
2 | Y
3 | X
4 | A
4 | X
4 | Z
4 | Y
Spreadsheet: 88095d1288020676-format-not-staying-same-test-for-pricing
Sheet: Sub-Contractors

 |  | Site
Client |  |  |  | Date
Item No | Item Description | Price to NRC | Plus % | % Total | Total
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 |  |  | Total
Spreadsheet: 328996d1404155594-incident-resolution-sla-calculations-sla-details-_1
Sheet: Sheet1

Incident Start | Incident End | Priority | This column can be hidden | Pass/Fail SLA | Over SLA |  | Priority | Resolution Time (hrs) | Core Hours (Mon-Fri)
2014-03-05 13:32:00 | 2014-03-08 18:52:00 | P1 |  |  |  |  | P1 | 2 | 08:00-18:00
2014-03-08 23:36:00 | 2014-03-09 00:41:00 | P2 |  |  |  |  | P2 | 4 | 08:00-18:00
2014-03-09 01:08:00 | 2014-03-09 03:07:00 | P3 |  |  |  |  | P3 | 24 | 08:00-18:00
2014-03-09 18:37:00 | 2014-03-10 01:43:00 | P4 |  |  |  |  | P4 | 48 | 08:00-18:00
2014-03-08 20:50:00 | 2014-03-10 04:39:00 | P2
2014-03-07 10:48:00 | 2014-03-10 04:43:00 | P3
2014-03-10 12:17:00 | 2014-03-10 14:06:00 | P3
2014-03-10 13:03:00 | 2014-03-11 14:28:00 | P3
2014-03-10 15:55:00 | 2014-03-12 16:54:00 | P1
2014-03-11 08:13:00 | 2014-03-11 08:14:00 | P3
2014-03-09 12:42:00 | 2014-03-11 09:23:00 | P1
2014-03-11 10:42:00 | 2014-03-11 12:44:00 | P3
2014-03-11 06:11:00 | 2014-03-11 15:30:00 | P3
2014-03-08 12:06:00 | 2014-03-08 20:04:00 | P1
2014-03-09 18:13:00 | 2014-03-15 20:17:00 | P4
2014-03-10 16:26:00 | 2014-03-10 16:27:00 | P2
2014-03-11 08:56:00 | 2014-03-11 10:31:00 | P3
Spreadsheet: darrell_schoolcraft__7304__imball0201
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 440668 | 433831
78311 | 172881 | 148750 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 | 364091 | 388323 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 | 433412 | 354117
500293 | 258156 | 276810
500302 |  | 3864
500303 |  | 135277
500305 | 713273 | 675850
500307 | 39101 | 14896
500313 |  | 707
500314
500655 | 108346
500657 | 78950 | 97988
INDEX
2001-12-31 00:00:00 |  |  | 40609.26
2002-01-14 00:00:00
CBS Volume
 |  |  | 31706
Spreadsheet: 819959d1677781164-need-help-creating-a-desk-booking-system-desk-booking
Sheet: Requests

Desk Number | Employee | Start date | Start Time slot | End date | End Time slot | 3 Desk double booked - a column with conditional formatting which will highlight in red if a desk is double booked based on the same desk number, start date, start time slot, end date and end time slot.
Desk1 | [NAME] | 2023-03-01 00:00:00 | 00:00-12:00 | 2023-03-04 00:00:00 | 12:00-00:00 | Yes
[NAME] | [NAME] | 2023-03-01 00:00:00 | 00:00-12:00 | 2023-03-02 00:00:00 | 12:00-00:00
Desk3 | [NAME] | 2023-03-05 00:00:00 | All day | 2023-03-10 00:00:00 | 00:00-12:00 | Yes
Desk4 | [NAME] | 2023-03-01 00:00:00 | All day | 2023-03-04 00:00:00 | All day
Desk5 | [NAME] | 2023-03-03 00:00:00 | 00:00-12:00 | 2023-03-05 00:00:00 | 12:00-00:00
Desk6 | [NAME] | 2023-03-10 00:00:00 | 00:00-12:00 | 2023-03-10 00:00:00 | 12:00-00:00
Desk7 | [NAME] | 2023-03-04 00:00:00 | All day | 2023-03-06 00:00:00 | All day | Yes
Desk8 | [NAME] | 2023-03-01 00:00:00 | 00:00-12:00 | 2023-03-04 00:00:00 | 12:00-00:00
[NAME] | [NAME] | 2023-03-05 00:00:00 | All day | 2023-03-07 00:00:00 | All day
[NAME] | [NAME] | 2023-03-07 00:00:00 | 00:00-12:00 | 2023-03-09 00:00:00 | 12:00-00:00
Desk11 | [NAME] | 2023-03-01 00:00:00 | 12:00-00:00 | 2023-03-07 00:00:00 | 12:00-00:00 | Yes
Desk12 | [NAME] | 2023-03-01 00:00:00 | All day | 2023-03-03 00:00:00 | All day
Desk1 | [NAME] | 2023-03-02 00:00:00 | 00:00-12:00 | 2023-03-04 00:00:00 | 00:00-12:00 | Yes
[NAME] | [NAME] | 2023-03-03 00:00:00 | All day | 2023-03-10 00:00:00 | All day
Desk3 | [NAME] | 2023-03-05 00:00:00 | 00:00-12:00 | 2023-03-10 00:00:00 | 00:00-12:00 | Yes
Desk4 | [NAME] | 2023-03-05 00:00:00 | All day | 2023-03-05 00:00:00 | All day
Desk5 | [NAME] | 2023-03-06 00:00:00 | 12:00-00:00 | 2023-03-10 00:00:00 | 00:00-12:00
Desk6 | [NAME] | 2023-03-02 00:00:00 | 00:00-12:00 | 2023-03-03 00:00:00 | 12:00-00:00
Desk7 | [NAME] | 2023-03-01 00:00:00 | All day | 2023-03-04 00:00:00 | All day | Yes
Desk8 | [NAME] | 2023-03-08 00:00:00 | 00:00-12:00 | 2023-03-10 00:00:00 | 12:00-00:00
[NAME] | [NAME] | 2023-03-05 00:00:00 | All day | 2023-03-06 00:00:00 | All day
[NAME] | [NAME] | 2023-03-04 00:00:00 | 12:00-00:00 | 2023-03-06 00:00:00 | 12:00-00:00
Desk11 | [NAME] | 2023-03-03 00:00:00 | All day | 2023-03-05 00:00:00 | All day | Yes
Desk12 | [NAME] | 2023-03-06 00:00:00 | 00:00-12:00 | 2023-03-07 00:00:00 | 12:00-00:00
Spreadsheet: 143751d1330547204-returning-a-row-of-data-based-on-cell-reference-and-date-fuel-workook_list
Sheet: Summary

Date | Name | Registration | Start Reading | Finish Reading | Amount Taken | Reading Taken | Milage |  | Registration | GD59 KMO
2012-02-12 00:00:00 | Lewis | GD59 KMO | 408269 | 408343 | 74 | 74 | 30654 |  | Start Date: | 2012-02-01 00:00:00
 |  |  |  |  |  |  |  |  | End Date: | 2012-02-15 00:00:00
 |  |  |  |  |  |  |  |  | ^ Data validation Reg & Dates
 |  |  | ^ [NAME]:I30
 |  |  | * If using Excel 2007 or later, can be abbreviated with IFERROR function.
 |  |  | * These formulas currently return up to 29 records, if there might be more you'll have to expand them down the sheet.
Spreadsheet: chris_germany__3150__BBC Feb2000 NYSEG
Sheet: Sheet1

Belden & Blake Corporation
February 2000 NYSEG Production Gas
Purchase Calculation
 | Allocated |  | PURCHASE PRICES
 | [NAME] |  | 2.8 | 2.91
AZON CORP | 12925
[NAME] | 695
[NAME] | 769
HADCO | 13186
INDUSTRIAL PAINT | 992
JOHNSTON MEMORIAL UM HOMES | 704
LOCKHEED | 1161
SCHAPIRO | 1175
BATES TROY | 2408 |  | 2176
CANDOR ELEMENTARY | 880
CANDOR HIGH SCHOOL | 880
NORBORD | 13341
SHELTERED | 1107
SPENCER VAN ETTEN | 880
 | 0
Allocated Volumes
Price Tiers
Invoice Amount
Spreadsheet: 694204d1599434703-formula-to-create-a-total-based-on-an-if-condition-sample-data-subset-excel-formula
Sheet: Sheet1

Product | Type of template | July | Aug | Sep
Knowledge of Quality improvement | Nurse | 14.99
Emergency Nurse resume template | Nurse | 19.99
Ed Assistant Health and Wellbeing | Other | 14.99
[NAME] Assistant Cover Letter | Other | 14.99
Primary Teacher AITSL | Teacher | 39.99
[NAME] resume | Nurse | 19.99
Electrician Resume | Mining | 19.99
Electrician Resume | Mining | 19.99
Graduate Teacher AITSL | Teacher | 39.99
Mission and Values of SJOG | Nurse | 14.99
[NAME] resume | Nurse | 19.99
Graduate teacher resume template | Teacher | 19.99
Primary Techer AITSL cover letter | Teacher | 39.99
Equal Opp knowledge and registered nurse | Nurse | 19.98
Graduate Teacher AITSL | Teacher | 39.99
Secondary Teacher AITSL | Teacher | 39.99
Knowledge of Quality improvement | Nurse |  | 19.99
Emergency Nurse resume template | Nurse |  | 19.99
[NAME] Assistant Cover Letter | Other |  | 14.99
Primary Teacher AITSL | Teacher |  | 39.99
Graduate Teacher AITSL | Teacher |  | 39.99
Mission and Values of SJOG | Nurse |  | 14.99
[NAME] resume | Nurse |  | 19.99
Graduate teacher resume template | Teacher |  | 19.99
Primary Techer AITSL cover letter | Teacher |  | 39.99
Equal Opp knowledge and registered nurse | Nurse |  | 19.98
Graduate Teacher AITSL | Teacher |  | 39.99
Secondary Teacher AITSL | Teacher |  | 39.99
Monthly total Nurses
Monthly Total Teachers
Monthly total other(s)
Monthly total mining
 | [NAME]
Spreadsheet: 539646d1506319978-auto-sort-golf-tournament-spreadsheet-seasac-golf-scoresheet
Sheet: Schools

Abbr. | School | Bangkok Cup
RIS | Ruamrudee International School
HIS | Harrow International School
BPS | Bangkok Patana School
NIST | New International School of Thailand
ISY | International School of Yangon
UWCE | United World School East
CDNIS | Candian School of Hong Kong
KLASS | [NAME]
GIS | Garden International School
UWCW | United World School West
TTS | Tanglin Trust School
MKIS | Mount Kiara International School
Spreadsheet: 871637d1718058577-formula-to-sum-figures-from-a-table-with-multiple-rows-and-columns-based-on-criteria-formula-help
Sheet: Leadsheet

 |  |  | SHARE CAPITAL |  |  |  | SHARE PREMIUM ACCOUNT |  |  |  | [NAME]
 | Company |  | FY24 |  | Testing |  | FY24 |  | Testing |  | FY24 |  | Testing
 | Company 1
 | Company 2
 | Company 3
 | Company 4
 | Company 5
 | Company 6
 | Company 7
 | Company 8
 | Company 9
 | Company 10
 | Company 11
 | Consolidated
Spreadsheet: louise_kitchen__22730__0202MarginRequirements
Sheet: 0201

FUTURES MARGIN REQUIREMENTS
2002-02-04 00:00:00
2002-02-01 00:00:00
 | US $$$ |  |  |  |  |  |  |  |  |  |  |  | CANADIAN $$$ |  | US $$$
Broker | TE | Credit Facility Covering TE | TE Less CreditCoverage | Net Option Value | Initial Margin | Line of Credit Covering Initial Margin (except EDF [NAME] see calc below) | Initial Margin Less Line of Credit Covering Initial Margin |  | Daily Facility Movement Inc/(Dec) Line |  | Wire Day Cash In/(Out) |  | TE | Initial Margin | OTE
ABN-Amro Inc | 148571.6360000279 |  | 148571.6360000279 | 0 | 0 |  | 0 |  |  |  | 148571.6360000279 |  |  |  | 0
ADM INVESTOR | 0.6990000053192489 |  | 0.6990000053192489 | 0 | 0 |  | 0 |  |  |  | 0.6990000053192489 |  |  |  | 0
BANK ONE | 0.2200000286102295 |  | 0.2200000286102295 | 0 | 0 |  | 0 |  |  |  | 0.2200000286102295 |  |  |  | 0
CARR FUTURES (NG) | 0 |  | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
CARR FUTURES INC. | 4402616.411521439 |  | 4402616.411521439 | 0 | 0 |  | 0 |  |  |  | 4402616.411521439 |  |  |  | 0
CREDIT SUISSE FIRST BOSTON | 29866.61000000313 |  | 29866.61000000313 | 0 | 0 |  | 0 |  |  |  | 29866.61000000313 |  |  |  | 0
EDF MAN | 8381917.775999765 |  | 8381917.775999765 | 0 | 0 |  | 0 |  |  |  | 8381917.775999765 |  |  |  | 0
FIMAT | 2275935.16 |  | 2275935.16 | 0 | 0 |  | 0 |  |  |  | 2275935.16 |  |  |  | 0
HSBC - US$ | -2123.732847999985 |  | -2123.732847999985 | 0 | 0 |  | 0 |  |  |  | -2123.732847999985 |  |  |  | 0
HSBC - Canadian | 0 |  | 0 | 0 |  |  | 0 |  |  |  | 0 |  | 64204.5 | 0 | 0
JP Morgan | 0 |  | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
[NAME] | 0 |  | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
PARIBAS | 80371717.16000006 |  | 80371717.16000006 | 0 | 0 |  | 0 |  |  |  | 80371717.16000006 |  |  |  | 0
PRUDENTIAL SI | 0.3928424186306074 |  | 0.3928424186306074 | 0 | 0 |  | 0 |  |  |  | 0.3928424186306074 |  |  |  | 0
REFCO, INC | 0.2590000069403686 |  | 0.2590000069403686 | 0 | 0 |  | 0 |  |  |  | 0.2590000069403686 |  |  |  | 0
R J O'BRIEN | 0.1799999999930151 |  | 0.1799999999930151 | 0 | 0 |  | 0 |  |  |  | 0.1799999999930151 |  |  |  | 0
SAUL STONE & COMPANY | 0.180000000000291 |  | 0.180000000000291 | 0 | 0 |  | 0 |  |  |  | 0.180000000000291 |  |  |  | 0
SMITH BARNEY, INC | 53592.45999999158 |  | 53592.45999999158 | 0 | 0 | 0 | 0 |  |  |  | 53592.45999999158 |  |  |  | 0
SMITH BARNEY, INC  (Financial) | 0 |  | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
TOTAL EXCLUDING MID-DAY CALLS |  |  |  |  |  |  |  |  |  |  |  |  | 64204.5 | 0 | 0
MID-DAY CALLS: (based solely on Market Movement)
EDF Mann | 0
TOTAL INCLUDING MID-DAY CALLS | 97203940.87151575
 |  |  |  |  |  |  |  |  |  |  |  |  | 97203940.87151575
 |  | Used Line
Credit Lines: | Line | OTE | Initial Margin | Total Line Used | Total Line Unused
Smith Barney | 50000000 | 0 | 0 | 0 | 50000000
1 Includes amounts withheld from payments due Enron.  Fimat's customer agreement states that excess margin including OTE due to Enron must first be used to pay down advances on the facility.
Spreadsheet: 803618d1667574312-display-duplicates-rows-from-two-arrays-table-display_duplicates_two_columns
Sheet: Feuil1

DUPLICATES | yellow a (2), blue b (3)
 | expected result
level | color
a | yellow
b | yellow
c | black
a | black
a | yellow
b | blue
b | blue
b | black
b | blue
Spreadsheet: 82503d1282579949-countif-data-between-2-dates-book1
Sheet: Sheet1

Date | Rep | Run | Result | Date Added | # of Days |  | 200
2010-07-26 00:00:00 | Clint | 2010-08-02 00:00:00 | Clean | 2010-07-26 00:00:00 | 0 |  | Date Added related to Date Set
2010-07-27 00:00:00 | Clint | 2010-08-03 00:00:00 | Clean | 2010-07-20 00:00:00 | 7 |  | Set within | Appoints. | % of total | Sold
2010-07-27 00:00:00 | Lynda | 2010-08-03 00:00:00 | CNW | 2010-05-01 00:00:00 | 87 |  | Same day - 3 days | 11 | 0.055 | 4
2010-07-27 00:00:00 | Clint | 2010-08-02 00:00:00 | CX | 2010-07-27 00:00:00 | 0 |  | 4 days - 7 days | 3 | 0.015 | 943
2010-07-27 00:00:00 | [NAME] | 2010-08-02 00:00:00 | No Sale | 2009-10-05 00:00:00 | 295 |  | 8 days - 14 days | 0 | 0
2010-07-28 00:00:00 | [NAME] | 2010-08-04 00:00:00 | Clean | 2010-07-27 00:00:00 | 1 |  | 15 days - 30 days | 4 | 0.02
2010-07-28 00:00:00 | [NAME] | 2010-08-05 00:00:00 | Clean | 2010-07-07 00:00:00 | 21 |  | 31 days - 60 days | 2 | 0.01
2010-07-28 00:00:00 | [NAME] | 2010-08-02 00:00:00 | CNW | 2010-07-28 00:00:00 | 0 |  | 61 days - 90 days | 2 | 0.01
2010-07-28 00:00:00 | [NAME] | 2010-08-04 00:00:00 | CNW | 2010-07-21 00:00:00 | 7 |  | 91days - 6 months | 0 | 0
2010-07-28 00:00:00 | Lynda | 2010-08-04 00:00:00 | CNW | 2010-07-28 00:00:00 | 0 |  | 6 months - 12 months | 2 | 0.01
2010-07-28 00:00:00 | AJ | 2010-08-02 00:00:00 | No Sale | 2010-06-02 00:00:00 | 56
2010-07-28 00:00:00 | Clint | 2010-08-03 00:00:00 | No Sale | 2010-07-22 00:00:00 | 6
2010-07-28 00:00:00 | [NAME] | 2010-08-03 00:00:00 | No Sale | 2010-06-09 00:00:00 | 49
2010-07-28 00:00:00 | [NAME] | 2010-08-11 00:00:00 | No Sale | 2010-05-26 00:00:00 | 63
2010-07-28 00:00:00 | [NAME] | 2010-08-03 00:00:00 | Short | 2010-07-25 00:00:00 | 3
2010-07-29 00:00:00 | [NAME] | 2010-08-02 00:00:00 | Short | 2010-07-28 00:00:00 | 1
2010-07-29 00:00:00 | Lynda | 2010-08-02 00:00:00 | CNW | 2010-07-13 00:00:00 | 16
2010-07-29 00:00:00 | [NAME] | 2010-08-04 00:00:00 | CNW | 2010-07-11 00:00:00 | 18
2010-07-29 00:00:00 | Lynda | 2010-08-04 00:00:00 | CNW | 2010-07-29 00:00:00 | 0
2010-07-29 00:00:00 | Lynda | 2010-08-03 00:00:00 | CX | 2010-07-29 00:00:00 | 0
2010-07-29 00:00:00 | Lynda | 2010-08-04 00:00:00 | CX | 2010-07-28 00:00:00 | 1
2010-07-29 00:00:00 | [NAME] | 2010-08-02 00:00:00 | No Sale | 2010-07-28 00:00:00 | 1
2010-07-29 00:00:00 | [NAME] | 2010-08-02 00:00:00 | No Sale | 2010-07-07 00:00:00 | 22
2010-07-29 00:00:00 | AJ | 2010-08-03 00:00:00 | No Sale | 2009-10-19 00:00:00 | 283
Spreadsheet: 166044d1341437140-drop-down-menu-to-show-data-4-variables-by-weeks-drop-down-showing-data
Sheet: Comparison

 |  |  | Week | 1 | 2 | week +/-%
 |  |  | local damages | 2 | 4
 |  |  | mistakes | 8 | 2
 |  |  | lacks | 6 | 2
 |  |  | remote damages | 11 | 22
 |  |  |  | Difference between 2 following weeks up or down by xx%
Spreadsheet: daren_farmer__5947__SMI41reveff061000
Sheet: Sheet1

To:   [NAME]          (Enron)
From: [NAME] ([NAME])
Date:  6/09/00
Subject:  Revised Availabilities Effective 6/10/00
Effective Date | CTP NAME | Gross Vol. (MMBtu/d) | PVR % | PVR Volume | Avail. After PVR (MMBtu/d) | DBQ | Excess
2000-06-10 00:00:00 | SMI 41 | 1 | 0 |  |  | 0
1st of month DBQ = 0/d
The Sea Robin Plant will shut down Monday, June 12, 2000 at 9:00 a.m. for repairs and maintenance.
The plant should be back up on Thursday, June 15, 2000.
Spreadsheet: 123968d1317964359-merging-two-sets-of-data-book1111
Sheet: Sheet1

Name | Age | Sex | Height | BMI
[NAME] | 13 | M
[NAME] | 18 | F
[NAME] | 10 | M
Name | Height | BMI
[NAME] | 120cm | 25
[NAME] | 125cm | 30
[NAME] | 150cm | 25