tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 33574d1230039379-vlookup-with-two-match-requirements-index-question
Sheet: Sheet1

ETD | Final Dest | Port | ETA
2008-12-17 00:00:00 | Lyndhurst | New York | 2009-01-09 00:00:00
2008-12-25 00:00:00 | Lyndhurst | New York | 2009-01-16 00:00:00
2008-12-31 00:00:00 | Lyndhurst | New York | 2009-01-23 00:00:00
2009-01-08 00:00:00 | Lyndhurst | New York | 2009-01-31 00:00:00
2009-01-14 00:00:00 | Lyndhurst | New York | 2009-02-06 00:00:00
2009-01-21 00:00:00 | Lyndhurst | New York | 2009-02-13 00:00:00
2009-01-28 00:00:00 | Lyndhurst | New York | 2009-02-20 00:00:00
2009-02-04 00:00:00 | Lyndhurst | New York | 2009-02-27 00:00:00
2009-02-11 00:00:00 | Lyndhurst | New York | 2009-03-06 00:00:00
2009-02-18 00:00:00 | Lyndhurst | New York | 2009-03-13 00:00:00
2009-02-25 00:00:00 | Lyndhurst | New York | 2009-03-20 00:00:00
2009-03-04 00:00:00 | Lyndhurst | New York | 2009-03-27 00:00:00
2009-03-11 00:00:00 | Lyndhurst | New York | 2009-04-03 00:00:00
2009-03-18 00:00:00 | Lyndhurst | New York | 2009-01-10 00:00:00
2009-03-25 00:00:00 | Lyndhurst | New York | 2009-04-17 00:00:00
2009-04-01 00:00:00 | Lyndhurst | New York | 2009-04-24 00:00:00
2009-04-08 00:00:00 | Lyndhurst | New York | 2009-05-01 00:00:00 |  | Column A |  | Column B |  | Result from Column D
2009-04-15 00:00:00 | Lyndhurst | New York | 2009-05-08 00:00:00 |  | 2008-12-25 00:00:00 |  | lyndhurst
2009-04-22 00:00:00 | Lyndhurst | New York | 2009-05-15 00:00:00
2008-12-25 00:00:00 | Port Coquitlam | Vancouver | 2009-01-04 00:00:00
2009-01-01 00:00:00 | Port Coquitlam | Vancouver | 2009-01-11 00:00:00
2009-01-08 00:00:00 | Port Coquitlam | Vancouver | 2009-01-18 00:00:00
2009-01-15 00:00:00 | Port Coquitlam | Vancouver | 2009-01-25 00:00:00
2009-01-22 00:00:00 | Port Coquitlam | Vancouver | 2009-02-01 00:00:00
2009-01-29 00:00:00 | Port Coquitlam | Vancouver | 2009-02-08 00:00:00
2009-02-05 00:00:00 | Port Coquitlam | Vancouver | 2009-02-15 00:00:00
2009-02-12 00:00:00 | Port Coquitlam | Vancouver | 2009-02-22 00:00:00
2005-02-19 00:00:00 | Port Coquitlam | Vancouver | 2009-03-01 00:00:00
2009-02-26 00:00:00 | Port Coquitlam | Vancouver | 2009-03-08 00:00:00
2009-03-05 00:00:00 | Port Coquitlam | Vancouver | 2009-03-15 00:00:00
2009-03-12 00:00:00 | Port Coquitlam | Vancouver | 2009-03-22 00:00:00
2008-12-30 00:00:00 | Lompoc | Los Angeles | 2009-01-13 00:00:00
2009-01-06 00:00:00 | Lompoc | Los Angeles | 2009-01-20 00:00:00
2009-01-13 00:00:00 | Lompoc | Los Angeles | 2009-01-27 00:00:00
2009-01-20 00:00:00 | Lompoc | Los Angeles | 2009-02-03 00:00:00
Spreadsheet: 296281d1392044037-copy-data-from-one-cell-to-another-cell-in-different-worksheet-depends-on-dates-and-names-template
Sheet: Schedule

 | 2014-01-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-01-26 00:00:00
Ayeli
[NAME]
Lior | Component 1 | component 2 | component 2 | component 4 | component 4
Amnon
Avi |  | coponent 3 | component 3 | component 4 | component 4
Other
Other
Upload Actual
Comments
Spreadsheet: 762682d1641732438-vlookup-help-to-get-a-value-when-3-item-match-3-on-another-sheet-example
Sheet: Ribbons

Ribbons |  |  |  | Buying | Selling Price |  | Selling Price
Products Code | Size | Grade | Winding | Cost | Price per roll | Rolls per box | Box price. | Lead Time | Stock
BSA40110AG3 | 110mm x 400m | Wax/Resin | O/W |  |  | 10 | £ | 7 - 10 days
BX760114AG2 | 114mm x 600m | Wax/Resin | O/W |  |  | 5 | £ | Next day | 15
T14981IO | 130mm x 600m | Wax/Resin | I/W |  | £ | 5 | £ | Next day
T42521IO | 50mm x 300m | Wax/Resin | I/W |  | £ | 25 | £ | Next day
UWAXR-50300 | 50mm x 300m | Wax/Resin | I/W |  | £ |  | £ | 5-7 days
T42501IO | 110mm x 91m | Wax/Resin | O/W |  | £ | 25 | £ | Next day
T47331IO | 110mm x 74m | Wax/Resin | O/W |  | £ | 25 | £ | Next day
B4527110AG3 | 110mm x 270m | Wax/Resin | O/W |  | £ | 10 | £ | 7 - 10 days | 9
BX760076AS1 | 76mm x 600m | [NAME] | O/W |  | £ | 5 | £ | Next day
T22385IO | 110mm x 300m | [NAME] | I/W |  | £ | 10 | £ | Next day | 7
BX760076AG2 | 76mm x 600m | Wax/Resin | O/W |  | £ | 5 | £ | Next day
BSA40060AS1 | 60mm x 400m | [NAME] | O/W |  | £ | 10 | £ | 7 - 10 days | 4
BSA40110AS1 | 110mm x 400m | [NAME] | O/W |  | £ | 10 | £ | Next day | 14
ECS27W-110300T | 110mm x 300m | [NAME] (white) | O/W |  | £ |  | £ | 5 - 7 days
ECS03R-110300T | 110mm x 300m | Wax/Resin (Red) | O/W |  | £ |  | £ | 5 - 7 days
T42833IO | 110mm x 300m | Wax/Resin | O/W |  | £ | 10 | £ | Next day
T15460IO | 112mm x 600m | Wax/Resin | O/W |  | £ | 5 | £ | Next day
T64222IO | 60mm x 300m | [NAME] | O/W |  | £ | 10 | £ | 3 - 4 days
T63353IO | 154mm x 450m | Wax/resin | O/W |  | £ | 5 | £ | Next day | 5
BSA40060AG3 | 60mm x 400m | Wax/resin | O/W |  | £ | 10 | £ | 7 - 10 days | 16
T49326IO | 100mm x 300m | [NAME] | I/W |  | £ | 10 | £ | 2 weeks
Spreadsheet: 884462d1733654271-replicate-rows-in-results-tools
Sheet: Sheet1

JOB | product | STORE | type | COST a | RESTOCK
51 | DULUX WHITE | WICKES | material | 25 | 2027-01-31 00:00:00 | material 1st job
51 | CROWN WHITE | WICKES | material | 25 | 2027-02-01 00:00:00 | material 1st job
51 | BRUSHES | WICKES | tool | 5 | 2026-05-01 00:00:00 | tool 1st job
51 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 | tool 1st job |  |  | tools appear in list once
51 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 | tool 1st job |  |  | 9 records
52 | JONSONS BLUE | WICKES | material | 25 | 2027-02-02 00:00:00 | material 2nd job
52 | DULUX CREAM | WICKES | material | 25 | 2027-02-03 00:00:00 | material 2nd job
52 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 | tool 2nd Job
52 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 | tool 2nd Job
RESULT
JOB | product | STORE | Type | COST a | RESTOCK
51 | DULUX WHITE | WICKES | Material | 25 | 2027-01-31 00:00:00 | material 1st job
51 | BRUSHES | WICKES | tool | 5 | 2026-05-01 00:00:00 | tool 1st job
51 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 | tool 1st job |  |  | Tool list are replicated for every job
51 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 | tool 1st job |  |  | 14 records
51 | CROWN WHITE | WICKES | Material | 25 | 2027-02-01 00:00:00 | material 1st job
51 | BRUSHES | WICKES | tool | 5 | 2026-05-01 00:00:00 | tool 1st job
51 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 | tool 1st job
51 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 | tool 1st job
52 | JONSONS BLUE | WICKES | Material | 25 | 2027-02-02 00:00:00 | material 2nd
52 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 | tools 2nd job
52 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 | tools 2nd job
52 | DULUX CREAM | WICKES | Material | 25 | 2027-02-03 00:00:00 | material 2nd
52 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 | tools 2nd job
52 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 | tools 2nd job
Spreadsheet: 062170f9-cc21-40af-8a59-5d23a91dda7f
Sheet: Sheet1

Universidad Alberto Hurtado | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Spanish Title | Loyola Equivalency | Loyola Credits | Comment: | Approved by:
[NAME] y Politica de America Latina II, | HS 300 2d. Core | 3 |  | Dr. [NAME]
Psicopatologia Infanto-Juvenil | PY 242 Adolescent Psychology | 3 |  | Dr. [NAME]
Problemas Psicosociales en Chile | PY*3 | 3 |  | Dr. [NAME]
Pobreza y Desarrollo | PS 300 level and 2d TH core | 3+3 |  | Dr. [NAME]/Dr. Fowl
[NAME] | PS 300 | 3 |  | Dr. [NAME]
Grandes Transformaciones Glob. | PS 353 Global Democratization | 3 |  | Dr. [NAME]
El Estado-Nacion y la glob. | PS 353 Global Democratization | 3 |  | Dr. [NAME]
Relaciones [NAME]. | PS 353 Global Democratization | 3 |  | Dr. [NAME]
[NAME] en el mundo | PS 353 Global Democratization | 3 |  | Dr. [NAME]
Integracion Regional | PS 353 Global Democratization | 3 |  | Dr. [NAME]
MERCOSUR y a integracion | PS 300 level | 3 |  | Dr. [NAME]
La Politica experior de Chile | PS 300 level | 3 |  | Dr. [NAME]
Pobreza y desarrollo | SC elective | 3 | not a seminar | Dr. [NAME]
Sociologia del Genero | SC 210 or SC elective | 3 | not a seminar | Dr. [NAME]
Politicas de desarrollo and America Latina | SN300 level, civ. / IB 470 or Area studies | 3 |  | Dr. [NAME]/Dr. [NAME]
Problemas Sichosociales en Chile | SN300 level, civ. | 3 |  | Dr. [NAME]
Globalizacion e integracion: Rel. Int. en Latin Am. | SN 300 level | 3 |  | Dr. [NAME]
Pobreza y desarrollo | SN 300 level | 3 | 3 credits only | Dr. [NAME]
Taller de Poesia Chilena | SN 300 level | 3 |  | Dr, Sorace
El Lenguage Dramatico y teatro | SN 300 level | 3 |  | Dr. [NAME]
Vanguardias y neo-vanguardias | SN 300 level | 3 |  | Dr. [NAME]
Intensive Spanish | SN 200 level and EH elective | 3+3 |  | Dr. [NAME]
[NAME] | SN 300 level | 3 |  | Dr. [NAME]
[NAME] politica de Am. Lat. II | SN 300 level + HS*3 core | 3 |  | Dr. [NAME]; Dr. [NAME]
Literatura latino Americana I | SN310-399 | 3 |  | Dr. [NAME]
[NAME] | SN 301-310 if 50% Chilean material included | 3 |  | Dr. [NAME]
Roman-Greek Literature | ML300 | 3 |  | Dr. [NAME]
Pobreza y desarollo | 2d TH core/PS 300 level or PL Ethics/SN 300 | 3+3 |  | Dr. [NAME]/Dr. [NAME]/Dr. [NAME]/Dr.[NAME]
Christology | TH 206 | 3 |  | Dr. [NAME]
Intro to scriptures | TH 337 | 3 |  | Dr. [NAME]
Fundamental Theology | TH 369 | 3 |  | Dr. [NAME]
Ecclesiology | TH 353 | 3 |  | Dr. [NAME]
Pobreza y desarollo | Ethics PL core and EH elective | 3+3 |  | Dr. [NAME]
[NAME] | PL202 2d PL core | 3 |  | Dr. [NAME]
[NAME] empresa y de los negocios | PL 310 | 3 |  | Dr. [NAME]
Spreadsheet: 141493d1329299852-index-formula-to-return-the-results-at-the-top-of-a-column-indexrow
Sheet: Sheet1

 |  |  |  | Week 2 | Week 3
2012-05-01 00:00:00 | 2012-05-01 00:00:00 | 1.1
2012-05-02 00:00:00 | 2012-05-02 00:00:00 | 1.11
2012-05-03 00:00:00 | 2012-05-03 00:00:00 | 1.12
2012-05-04 00:00:00 | 2012-05-04 00:00:00 | 1.13
2012-05-07 00:00:00 | 2012-05-07 00:00:00 | 2.14
2012-05-08 00:00:00 | 2012-05-08 00:00:00 | 2.15
2012-05-09 00:00:00 | 2012-05-09 00:00:00 | 2.16
2012-05-10 00:00:00 | 2012-05-10 00:00:00 | 2.17
2012-05-11 00:00:00 | 2012-05-11 00:00:00 | 2.18
2012-05-14 00:00:00 | 2012-05-14 00:00:00 | 3.19
2012-05-15 00:00:00 | 2012-05-15 00:00:00 | 3.2
2012-05-16 00:00:00 | 2012-05-16 00:00:00 | 3.21
2012-05-17 00:00:00 | 2012-05-17 00:00:00 | 3.22
2012-05-18 00:00:00 | 2012-05-18 00:00:00 | 3.23
2012-05-21 00:00:00 | 2012-05-21 00:00:00 | 4.24
2012-05-22 00:00:00 | 2012-05-22 00:00:00 | 4.25
2012-05-23 00:00:00 | 2012-05-23 00:00:00 | 4.26
2012-05-24 00:00:00 | 2012-05-24 00:00:00 | 4.27
2012-05-25 00:00:00 | 2012-05-25 00:00:00 | 4.28
2012-05-28 00:00:00 | 2012-05-28 00:00:00 | 5.29
2012-05-29 00:00:00 | 2012-05-29 00:00:00 | 5.3
2012-05-30 00:00:00 | 2012-05-30 00:00:00 | 5.31
2012-05-31 00:00:00 | 2012-05-31 00:00:00 | 5.32
Spreadsheet: 737399d1624395019-identify-unique-id-across-2-sheets-but-the-unique-id-is-a-formula-not-a-value-test-sheet-tms
Sheet: Sheet1

County | State | Color | Name | Flavor | Dog | Unique ID
Wayne | OH | Yellow | [NAME] | Vanilla | Spot |  |  |  | =COUNTIF('Sheet1 (2)'!$G:$G,$G2)
Greenville | SC | Blue | [NAME] | Chocolate | Rover
Abbington | GA | Red | [NAME] | [NAME] | [NAME]
Spreadsheet: 699721d1602737689-sorting-a-list-based-on-2-criteria-for-a-schedule-schedule-example
Sheet: THURS

Thurs 10/15 |  |  | FRED |  |  | TOTAL [NAME] - THIS TRUCK |  |  |  |  |  | CREW | ORDER | CUSTOMER | STORE | PHONE | NOTES | ADDRESS | JOB
08:30:00 | - |  |  |  |  |  |  |  |  |  |  | FRED | 1 | DOT, BLUE | SPRINGFIELD | 5557891023 |  | 123 MAIN STREET | WINDOW
 |  |  |  |  |  |  |  |  |  |  |  | GEORGE | 1 | SQUARE, GREEN | CHESTERFIELD | 5551234567 |  | 57 THIS ROAD | DOOR
 |  |  |  |  |  |  |  |  |  |  |  | FRED | 3 | CIRCLE, RED | DEERFIELD | 5558294837 |  | 2098 THAT STREET | WORK ORDER
 |  |  |  |  |  |  |  |  |  |  |  | FRED | 4 | TRIANGLE, ORANGE | DEERFIELD | 5552938503 |  | 385 PARK WAY | MEASURE
 |  |  |  |  |  |  |  |  |  |  |  | FRED | 2 | RECTANGLE, YELLOW | CHESTERFIELD | 5550928342 |  | 832 APPLE LANE | MEASURE
 | -
 | -
 | -
 |  |  |  |  |  | RETURN TO ACCOMODATIONS
 |  | RAY
 |  |  | GEORGE |  |  | TOTAL MILES - THAT TRUCK
10:00:00 | -
 |  |  |  |  |  | RETURN TO ACCOMODATIONS
Spreadsheet: 884955d1734357212-grading-matrix-sample_file_121424-2-
Sheet: Sample

 | Metric 1 | Metric 2 | Metric 3 | Metric 4 | Metric 5 | Score
2024-12-08 00:00:00 | 1 | 1.25 | 0.5 | 0 | 0
2024-12-09 00:00:00 | 1 | 1.25 | 0.5 | 1.25 | 0
2024-12-10 00:00:00 | 1 | 1.25 | 0.5 | 1.25 | -1
2024-12-11 00:00:00
2024-12-12 00:00:00
2024-12-13 00:00:00
2024-12-14 00:00:00
Weekly Score |  |  |  |  |  |  | Sum of all the scores, on a scale of 1-100
Input Area
Scoring | Calues | Description |  |  |  |  | Scoring | [NAME]
Metric 1 | 0, 1 | Yes or No |  |  |  |  | Metric 1 | 1
Metric 2 | 0, 1.25 | Yes or No, but weighted more than other metrics |  |  |  |  | Metric 2 | 1.25
Metric 3 | 0, .5 | Yes or No, but weighted less than other metrics |  |  |  |  | Metric 3 | 0.5
Metric 4 | 0, 1.25 | Yes or No, but weighted more than other metrics |  |  |  |  | Metric 4 | 1.25
Metric 5 | 0, -1 | Yes or No, only negative impact |  |  |  |  | Metric 5 | 0
Spreadsheet: 841664d1693839812-date-and-time-matching-between-2-sheets-match-date-and-time
Sheet: Sheet1

Date | Time | Value | Desired result
2023-08-02 00:00:00 | 20:15:00.000000 | 35412
2023-08-02 00:00:00 | 20:16:00.000000 | 35412
2023-08-02 00:00:00 | 20:17:00.000000 | 35410
2023-08-02 00:00:00 | 20:18:00.000000 | 35411
2023-08-02 00:00:00 | 20:19:00.000000 | 35411
2023-08-02 00:00:00 | 20:20:00.000000 | 35415
2023-08-02 00:00:00 | 20:21:00.000000 | 35417
2023-08-02 00:00:00 | 20:22:00.000000 | 35417
2023-08-02 00:00:00 | 20:23:00.000000 | 35417
2023-08-02 00:00:00 | 20:24:00.000000 | 35415
2023-08-02 00:00:00 | 20:25:00.000000 | 35417
2023-08-02 00:00:00 | 20:26:00.000000 | 35417
2023-08-02 00:00:00 | 20:27:00.000000 | 35417
2023-08-02 00:00:00 | 20:28:00.000000 | 35419
2023-08-02 00:00:00 | 20:29:00.000000 | 35420
2023-08-02 00:00:00 | 20:31:00.000000 | 35420
Spreadsheet: 140314d1328703121-excel-2007-pivot-table-headache-example
Sheet: Sheet4

Department | (All)
Row Labels | Count of ID | Sum of MALE | Sum of FEMALE
Group 1 | 5 | 3 | 2
Colossus | 1 | 1 | 0
Gambit | 1 | 0 | 1
Wolverine | 3 | 2 | 1
Group 2 | 5 | 2 | 3
Blink | 2 | 1 | 1
IceMan | 2 | 1 | 1
[NAME] | 1 | 0 | 1
Grand Total | 10 | 5 | 5
Spreadsheet: 837766d1690401615-task-list-and-recurring-tasks-task-list-recurring-tasks
Sheet: Sheet1

VLOOKUP | Months
Monthly | 1
Quarterly | 3
Bi-Annual | 6
Yearly | 12
2 Yr | 24
3 Yr | 36
4 Yr | 48
5 Yr | 60
10 Yr | 120
Spreadsheet: 67886d1268400046-help-in-counting-records-in-using-lookup-testalbert
Sheet: Sample lookup

 |  | Number of Academics |  |  |  |  | Number of Universities |  |  |  | Number of Departments
 | Name | No. of Records |  |  | No. of Departments verified | No. of Subjects taught | Name | with Address | with Telephone Number | with Website Address | with [NAME] | with Address | with Telephone
 |  | with [NAME] | with Title | with email address
 | [NAME] | 183 | 183 | 16
 | [NAME] | 0 | 0 | 0
 | [NAME] | 848 | 848 | 624
 | [NAME] | 0 | 0 | 0
 | [NAME] | 821 | 821 | 690
 | Total | 1852 | 1852 | 1330 | 113 | 6387 | 8 | 45 | 0 | 0 | 0 | 0 | 0
Spreadsheet: mary_fischer__25627__1292
Sheet: ELIST.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  1292 |  | (Please print)  PREPARED BY: | Sonya City
COMPANY NAME    Marlin Fair Value Co.
E-SCHEDULES CHECK LIST
For the period ending: 06/30/2001 |  | REVIEWED BY: | [NAME]
*  PRIORITY SCHEDULE
SCH | CONSOL ACCT | QUARTERLY SCHEDULES | COMPLETED or N/A
E-1 | 053, 060 | A/R - Other | COMPLETED
E-2 * | 195 | Other Current Assets | N/A
E-3 * | TOT_INVEST_SUBS | Investment in Unconsolidated
 | TOT_EQEARN_OTH | Affiliates, Partnerships & Joint Ventures | N/A
E-4 * | 269, 270, 280 | Merchant and Other Investments | N/A
E-5 | 344 | Goodwill | COMPLETED
E-6 * | TOT_PPE | Property, Plant & Equipment | COMPLETED
 | [NAME] | Depreciation, Depletion & Amortization
[NAME] * | 343, 360 | Other Deferred Charges | N/A
E-11* | 655 | Other Current Liabilities | COMPLETED
E-12 * | 450,  TOT_NP_OTHER | Short-Term and Long-Term Debt | N/A
 | 770,  705,  775,  765
E-14* | 860 | Other Deferred Credits | N/A
E-15 | 855 | Minority Interests | N/A
E-16* | 1676 | (Gain) Loss on Sales of Assets | N/A
E-20* | 1690, 1775 | Other Income and Other Deductions | N/A
E-21 |  | Lease Expense & Future Lease Commitments | N/A
E-31 |  | Equity/Invmt Sub | COMPLETED
E-36 | TOT_INVEST_SUBS | Investee's Summarized Information | N/A
 | TOT_EQEARN_OTH
 |  | ADDITIONAL SCHEDULES FOR YEAR END ONLY
E-18 | 65, 641, 815, 840 | Analysis of Reserve Items | N/A
Spreadsheet: holden_salisbury__12302__ElPaso Buy Resale Invoice
Sheet: manual invoiceB

SALES INVOICE
CUSTOMER INFORMATION |  |  | INVOICE INFORMATION |  |  |  |  | CONTRACT INFORMATION |  |  | PAYMENT INFORMATION
El Paso Electric Company |  |  | INVOICE NUMBER: |  | NTP010741 |  |  | CONTRACT NO: |  |  | WIRE TRANSFER:
[NAME] 982 |  |  | INVOICE DATE: |  | 2001-07-16 00:00:00 |  |  | BA ID: | 26698 |  | ENRON POWER MARKETING, INC.
El Paso , Texas 79960 |  |  | DUE DATE: |  | 2001-07-26 00:00:00 |  |  | CONTRACT DATE: | 01/16/97 |  | Bank of America, N.A.
 |  |  | TERMS: |  | WSPP |  |  |  |  |  | ACCOUNT NUMBER    [PHONE]
Attn:  [NAME] |  |  | CONTACT: |  | [NAME]
Fax:  (915) 521-4751 |  |  |  |  | PH #:    (713)  853-9378
 |  |  |  |  | FAX #: (713)  646-4061 |  |  |  |  |  | ABA # 111000012
TO INVOICE FOR ENERGY SALES FOR THE MONTH OF June 2001
 |  |  | DATES |  |  |  |  |  |  |  |  | TOTAL | TOTAL
[NAME] |  |  |  | START | END |  |  |  | Price |  |  | [NAME] | DOLLARS
Energy Sales to El Paso |  |  |  | 2001-06-01 00:00:00 | 2001-06-04 00:00:00 |  |  |  | see below for breakdown
Hub Trading |  |  |  |  |  |  |  |  |  |  |  | 10800
Energy Purchases from El Paso |  |  |  | 2001-06-01 00:00:00 | 2001-06-04 00:00:00 |  |  |  | see below for breakdown
TOTAL DUE ENRON
[NAME]:
Energy Sales to El Paso |  |  |  | 2001-06-01 00:00:00 | 2001-06-01 00:00:00 |  |  |  | 262.31 |  |  | 1568
Energy Purchases from El Paso |  |  |  | 2001-06-01 00:00:00 | 2001-06-01 00:00:00 |  |  |  | -248.25 |  |  | 1568
Energy Sales to El Paso |  |  |  | 2001-06-02 00:00:00 | 2001-06-02 00:00:00 |  |  |  | 181.06 |  |  | 384
Energy Purchases from El Paso |  |  |  | 2001-06-02 00:00:00 | 2001-06-02 00:00:00 |  |  |  | -170 |  |  | 384
Energy Sales to El Paso |  |  |  | 2001-06-04 00:00:00 | 2001-06-04 00:00:00 |  |  |  | 204 |  |  | 784
Energy Purchases from El Paso |  |  |  | 2001-06-04 00:00:00 | 2001-06-04 00:00:00 |  |  |  | -170 |  |  | 784
** This is the invoice for Buy/Resales not on model **
Spreadsheet: 264426d1378884070-isolating-information-from-specific-columns-in-an-excel-spreadsheet-example-database
Sheet: Sheet4

Funders/Strategic Partners | x
Count of Name
Name | Total
[NAME] | 1
Alice (Spaeda) | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
Bristol Music Foundation | 1
[NAME] | 1
[NAME] | 1
[NAME] davies | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
Clare(?) Modley | 1
Dartington | 1
[NAME] | 1
[NAME] | 1
Dominic Tambling | 1
[NAME] | 1
Fay LeCoq | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
Lavoro In Cors | 1
[NAME] | 1
[NAME] | 1
Marcus Davey | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
Saj Hemming | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
Spaeda | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
Youth Music | 1
[NAME] | 1
Grand Total | 61
Spreadsheet: 705235d1605954714-formula-for-every-1-000-will-added-1-number-in-range
Sheet: Sheet1

 |  |  |  |  | Expected Result
0 | 1000 | 1 |  | 300 | 1
 |  | 2 |  | 2000 | 2
 |  | 3 |  | 3000 | 3
 |  | 4 |  | 7200 | 8
 |  | 5 |  | 8500 | 9
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
Spreadsheet: 875753d1722356299-remove-leading-spaces-excel-example
Sheet: Sheet1

Units
-80.00000000
-0.32100000
-305.76000000
2
0.912
0
231.25
11.833
0
0
74.47
33.054
0
20.814
0
2.011
0
10.368
0
3.429
0
0.39
16.47
0
8.82
0
5.262
0
337
0.417
-0.58200000
-469.00000000
6.115
Spreadsheet: 497cf255-735a-4ab9-9018-b2bee4b012e1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-09-07 09:53:18.180000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.375 | 101.806 | 101.681 | 101.556 | 101.181
4.25 | 100.843 | 100.718 | 100.593 | 100.218 |  | Note: | Refer To Price [NAME]
4.125 | 100.249 | 100.124 | 99.999 | 99.624 |  |  | For all Price Adjs
4 | 99.746 | 99.621 | 99.496
3.875 | 99.123 | 98.998 | 98.873
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 101.715 | 101.59 | 101.465 | 101.09
3.625 | 101.181 | 101.056 | 100.931 | 100.556
3.5 | 100.845 | 100.72 | 100.595 | 100.22
3.375 | 100.465 | 100.34 | 100.215 | 99.84
3.25 | 99.907 | 99.782 | 99.657
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-09-21 09:53:18.180000
30 DAY | 2011-10-06 09:53:18.180000
45 DAY | 2011-10-21 09:53:18.180000
60 DAY | 2011-11-05 09:53:18.180000
90 DAY | 2011-12-05 09:53:18.180000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: c8bebb58-780f-4713-a074-4687242196be
Sheet: divisions

Voter | AFC East | AFC North | AFC South | AFC West | NFC East | NFC North | NFC South | NFC West | Average (should equal 16.5)
[NAME] | 18.5 | 15.75 | 22 | 16.75 | 13 | 12.5 | 16 | 17.5 | 16.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | 18.25 | 15.75 | 20.75 | 17.25 | 11.25 | 13.5 | 15.25 | 20 | 16.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | 18.25 | 16.5 | 22 | 17 | 9.25 | 12.75 | 18 | 18.25 | 16.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | 17.5 | 15.25 | 23.25 | 16.75 | 9.25 | 14 | 17.25 | 18.75 | 16.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | 17.5 | 17 | 21.5 | 15.5 | 12.25 | 13.75 | 16.75 | 17.75 | 16.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Average | 18 | 16.05 | 21.9 | 16.65 | 11 | 13.3 | 16.65 | 18.45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Rank | 6 | 3 | 8 | 4 | 1 | 2 | 4 | 7