tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 22817d1211972738-div-0-error-using-average-with-if-function-problem
Sheet: Sheet1

NORTHERN IRELAND (LP)
Ref | Description | April
 | 1 | 0
 | 2 | 0
 | 3 | 0
 | 4 | 0
 | 5 | 0
 | 6 | 0
 | 7 | 0
 | 7 | 0
 | 8 | 0
 | 8 | 0
 | 6 | 0
 | 4 | 0
 | 35 | 0
 | 6 | 0
 | 35 | 0
 | 6 | 0
 | 346 | 0
 | 36 | 0
 | 36 | 0
 | 56
 | 56 | 0
 | 56 | 0
 | 3 | 0
 | AVERAGE | #N/A
1559 | 6 | 1
4602 | 35 | 0
4609 | 6 | 0
4610 | 346 | 0
4611 | 36 | 0
4612 | 36 | 0
4614 | 56 | 0
4616 | 56 | 0
4617 | 56 | 0
4618 | 6 | 0
4620 | 35 | 0
4632 | 6 | 0
4633 | 346 | 0
4635 | 36 | 0
4637 | 36 | 0
4638 | 56 | 0
4641 | 56 | 0
4644 | 56 | 0
4645 | 74.75 | 0
4646 | 75.6333333333334 | 0
4649 | 76.5166666666667 | 0
4650 | 77.4 | 0
4653 | 78.2833333333334 | 0
 | AVERAGE | 1
SUMMARY SHOWING NO OF RED/AMBER/GREEN SCORES BY AREA
 |  | RED
 |  | 0
 |  | 0
Average Score |  | #N/A
Spreadsheet: 474810d1470917238-lookup-value-copy-into-the-corresponding-column-in-date-order-extractofincidents-gk
Sheet: Sheet1

Month | SQLServer1 | SQLServer2 | SQLServer3 | SQLServer4 | SQLServer5
April
April
April
April
April
April
April
April
April
April
May
May
May
May
May
May
May
May
May
May
June
June
June
June
June
June
June
June
June
June
July
July
July
July
July
July
July
July
July
July
Spreadsheet: 52717d1252545980-reading-last-non-blank-cell-in-each-row-at-3-column-steps-4david55
Sheet: Sheet3

Donation list
name | amount | date | address1 | address2 | letter sent
Smith | 20 | 2009-09-08 00:00:00 | A street | Aberystwyth | y
Davies | 15 | 2009-09-08 00:00:00 | C street | Llandudno | y
Jones | 20 | 2009-09-01 00:00:00 | B street | Caerdydd | y
Jones | 55 | 2009-09-08 00:00:00 | B street | Caerdydd
Spreadsheet: 775999d1649432098-formula-if-rating
Sheet: Sheet1

 |  |  |  | Not Acceptable | >90
 |  |  |  | High Risk | 65.01 - 90.00 | 65.01 | 90 |  |  | 18.34 | Low
 |  |  |  | Medium Risk | 40.01 - 65.00 | 40.01 | 65 |  |  | 40.01 | Medium
 |  |  |  | Low Risk | 18.34 - 40.00 | 18.34 | 40 |  |  | 65.01 | High
 |  |  |  |  |  |  |  |  |  | 90.01 | Unacceptable
 |  |  |  | Score: | 65.01
 |  |  |  | Risk Rating
Spreadsheet: chris_dorland__1628__Deals
Sheet: FX Swaps to Transfer

Original Deal# | Transfer Tagg# | Deal Date | Amount  ($USD) | Fx Rate  ($CND/$US) | Settlement Date
243316 | N96705 | 2000-02-09 00:00:00 | -2500000 | 1.4423 | 2000-03-31 00:00:00
244156 | N97801 | 2000-02-10 00:00:00 | -2500000 | 1.4474 | 2000-03-31 00:00:00
244167 | [NAME] | 2000-02-11 00:00:00 | 2500000 | 1.44855 | 2000-03-31 00:00:00
245387 | ? | 2000-02-15 00:00:00 | 3000000 | 1.4552 | 2000-03-31 00:00:00 | The TAGG # of the annuity portion of this deal wasn't written in the FX book
245387 | ? | 2000-02-15 00:00:00 | 3000000 | 1.45763 | 2000-03-31 00:00:00 | The TAGG # of the annuity portion of this deal wasn't written in the FX book
245795 | NA1273 | 2000-02-15 00:00:00 | 2500000 | 1.45465 | 2000-03-31 00:00:00
245795 | NA1280 | 2000-02-16 00:00:00 | 2000000 | 1.451 | 2000-03-31 00:00:00
246200 | NA2095 | 2000-02-17 00:00:00 | -3000000 | 1.451952 | 2000-03-31 00:00:00
247040 | NA3963 | 2000-02-22 00:00:00 | 3000000 | 1.461325 | 2000-03-31 00:00:00
247907 | NA6537 | 2000-02-24 00:00:00 | 1000000 | 1.4571 | 2000-03-31 00:00:00
249306 | NB0600 | 2000-02-29 00:00:00 | -3000000 | 1.45078 | 2000-03-31 00:00:00
249306 | NB0604 | 2000-02-29 00:00:00 | -4000000 | 1.45148 | 2000-03-31 00:00:00
249306 | NB0607 | 2000-02-29 00:00:00 | -5000000 | 1.44813 | 2000-03-31 00:00:00
249719 | NB1762 | 2000-03-01 00:00:00 | 1000000 | 1.44475 | 2000-04-28 00:00:00
249742 | NB1825 | 2000-03-01 00:00:00 | 3000000 | 1.44818 | 2000-03-31 00:00:00
250596 | NB3849 | 2000-03-03 00:00:00 | 5000000 | 1.44995 | 2000-04-28 00:00:00
Spreadsheet: sally_beck__33984__SchedC0331
Sheet: Mar 30, 2001-EBS

 |  |  |  |  |  |  |  |  |  |  |  |  | CONFIDENTIAL
 |  |  |  |  |  |  |  |  |  |  |  |  | Schedule C Summary
 |  |  |  |  |  |  |  |  |  |  |  |  | As of February 28, 2001
 |  |  |  |  |  |  |  |  | Prior Month
 | Portfolio | Book(s) | Date | Counterparty | Description |  | Amount |  | 2001-02-28 00:00:00 |  | Change |  | Removal Date
 | Enron Broadband | Bandwidth | 2000-06-01 00:00:00 | - | Included to account for local loop costs that are not currently being tracked in the book.  The reserve is to safeguard against additional costs to move bandwidth from the "city gate" pooling point to the final customer. |  | -1128821 |  | -1128821
 | Enron Broadband | Bandwidth | 2000-09-01 00:00:00 | - | Bad Debt Reserve for Dark Fiber |  | -3600000 |  | -3600000
 | Enron Broadband | Bandwidth | 2000-10-31 00:00:00 | - | Bad Debt Reserve for Dark Fiber |  | -5000000 |  | -5000000
 | TOTAL
Spreadsheet: 847048d1698147759-sum-last-2-values-in-a-range-of-a-row-excel-sum-on-farthest-right-data-in-a-range
Sheet: Sheet1

ACCOUNT NAME | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | ANNUAL TOTAL | [NAME] CHECK
PETE | 35 | 70 | 88 | 120 | 40 | 52 | 65 | 73
ACCOUNT NAME | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | ANNUAL TOTAL | [NAME] CHECK
PETE | 35 | 70 | 88 | 120 | 40 | 52 | 65 | 73 | 99 | 80
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] NEEDS TO BE ON THE FARTHEST RIGHT VALUES IN THE RANGE B2 TO M2
 |  |  |  |  |  |  |  |  |  |  |  | SEE ABOVE EXAMPLES
 |  |  |  |  |  |  |  |  |  |  |  | FORMULA IN O2 / O6  NEEDS TO AUTOMATICALLY LOOK AT 2 MOST RECENT VALUES IN THE RANGE AND CALC % CHANGE
Spreadsheet: 695902d1600450147-getting-last-row-value-with-index-match-match-offset_value
Sheet: Sheet1

 | Identifier1 |  | Identifier2 |  | Identifier3 |  | Identifier4 |  | Identifier5
 |  | Attribute1 |  | Attribute2 |  | Attribute3 |  | Attribute4 |  | Attribute5
Source1 |  | 1 |  | 4 |  | 7 |  | 10 |  | 13
Source2 |  | 2 |  | 5 |  | 8 |  | 11 |  | 14
Source3 |  | 3 |  | 6 |  | 9 |  | 12 |  | 15
This is a little tricky to explain but.. [NAME] columns are not always the same, and the identifiers are not always on the same row. Need to scan for example Identifier3's position (currently row 1, column F), add +1 column and get value on lowest row (9). This format is stupid but I cannot change it and have to work with it.
Solution: |  |  |  |  |  |  |  |  |  |  |  | Search term:
Spreadsheet: 691037d1597421562-at-wits-end-help-with-nested-if-statements-if-statement-help-etaf
Sheet: Call Log

First Name | Last Name | Phone | [NAME] | Overdue | # times called | Contact 1 Date | Contact 1 method | Contact 1 Topic | Responded | Contact 2 Date | Contact 2 method | Contact 2 Topic | Responded | Contact 3 Date | Contact 3 method | Contact 3 Topic | Responded | Contact 4 Date | Contact 4 method | Contact 4 Topic | Responded | Contact 5 Date | Contact 5 method | Contact 5 Topic | Responded | Contact 6 Date | Contact 6 method | Contact 6 Topic | Responded | Contact 7 Date | Contact 7 method | Contact 7 Topic | Responded | Notes
 |  |  |  |  | 1
 |  |  | Date Test 14 days old
 |  |  | Count blank is 1
 |  |  | Combined
Spreadsheet: 489c82d7-ee00-4836-8dad-d1ce4cadff4f
Sheet: Dr. Begino-Mission Viejo

[NAME]
24481 Alicia Parkway #B-3
[NAME], CA  92691
Main Phone Line: (949) 381-1266
Main Fax: (949) 586-7659
Name and Title | Role | Contact Email | Contact Phone Number | Fax Number
Dr. [NAME], DDS | Provides general dentistry services | N/A | 9495869800 | 9495867659
[NAME] | Office | N/A | 9493811266 | 9495861659
Spreadsheet: 159688d1338817683-sum-if-based-on-multiple-criteria-sample
Sheet: Wk 3

Client Id | Signings
1186570 | 25000
1393442 | 1000000
1347070 | 10000000
1257066 | 4000000
1178898 | 10000500
1704531 | -1000
1244756 | -1000000
1060302 | -10000000
1063739 | -4000000
1490011 | -10000500
1234567 | 900000
2345678 | 25000
3456789 | 6000000
4567890 | 3500600
Spreadsheet: 163409d1340293471-ranking-list-with-duplicate-values-order-rank
Sheet: DeliverySchedule

Event Time | Delivery Date | Order Rank | Check Number | Correct?
2012-06-20 19:00:00
2012-06-20 19:00:00
2012-06-21 08:00:00
2012-06-28 12:00:00 |  |  | 1
2012-06-28 18:00:00 |  |  | 1
2012-06-28 19:00:00 |  |  | 1
2012-06-28 19:00:00 |  |  | 1
2012-06-29 08:00:00 |  |  | 1
2012-06-29 08:00:00 |  |  | 1
2012-06-29 11:45:00 |  |  | 1
2012-06-29 12:00:00 |  |  | 1
2012-06-29 13:30:00 |  |  | 1
2012-06-29 19:00:00 |  |  | 1
2012-06-29 19:00:00 |  |  | 1
2012-06-30 08:00:00 |  |  | 1
2012-06-30 08:00:00 |  |  | 1
2012-06-30 12:00:00 |  |  | 1
2012-06-30 19:00:00 |  |  | 2
2012-07-01 08:00:00 |  |  | 2
2012-07-01 09:00:00 |  |  | 2
2012-07-01 12:00:00 |  |  | 2
2012-07-01 12:00:00 |  |  | 2
2012-07-01 19:00:00 |  |  | 2
2012-07-01 19:00:00 |  |  | 2
2012-07-02 08:00:00 |  |  | 2
2012-07-02 08:00:00 |  |  | 2
2012-07-02 08:00:00 |  |  | 2
2012-07-02 12:00:00 |  |  | 2
2012-07-02 12:00:00 |  |  | 2
2012-07-02 19:00:00 |  |  | 2
2012-07-02 19:00:00 |  |  | 2
2012-07-02 19:00:00 |  |  | 2
2012-07-03 08:00:00 |  |  | 2
2012-07-03 08:00:00 |  |  | 2
2012-07-03 08:00:00 |  |  | 2
2012-07-03 12:00:00 |  |  | 2
2012-07-03 12:00:00 |  |  | 2
2012-07-03 12:00:00 |  |  | 2
2012-07-03 19:00:00 |  |  | 2
2012-07-04 08:00:00 |  |  | 2
2012-07-04 08:00:00 |  |  | 2
2012-07-04 12:00:00 |  |  | 2
2012-07-04 13:00:00 |  |  | 2
2012-07-04 19:00:00 |  |  | 3
2012-07-04 19:00:00 |  |  | 3
2012-07-05 08:00:00 |  |  | 3
2012-07-05 08:00:00 |  |  | 3
2012-07-05 12:00:00 |  |  | 3
2012-07-05 13:00:00 |  |  | 3
2012-07-05 19:00:00 |  |  | 3
2012-07-05 19:00:00 |  |  | 3
2012-07-06 08:00:00 |  |  | 3
2012-07-06 08:00:00 |  |  | 3
2012-07-06 12:00:00 |  |  | 3
2012-07-06 13:00:00 |  |  | 3
2012-07-06 19:00:00 |  |  | 3
2012-07-06 19:00:00 |  |  | 3
2012-07-06 19:00:00 |  |  | 3
2012-07-07 08:00:00 |  |  | 3
2012-07-07 08:00:00 |  |  | 3
2012-07-07 12:00:00 |  |  | 3
2012-07-07 19:00:00 |  |  | 4
2012-07-08 09:00:00 |  |  | 4
2012-07-08 12:00:00 |  |  | 4
2012-07-08 19:00:00 |  |  | 4
2012-07-09 08:00:00 |  |  | 4
2012-07-09 12:00:00 |  |  | 4
2012-07-09 19:00:00 |  |  | 4
2012-07-10 08:00:00 |  |  | 4
2012-07-10 12:00:00 |  |  | 4
2012-07-10 19:00:00 |  |  | 4
2012-07-11 08:00:00 |  |  | 4
2012-07-11 12:00:00 |  |  | 4
2012-07-11 19:00:00 |  |  | 5
2012-07-12 08:00:00 |  |  | 5
2012-07-12 12:00:00 |  |  | 5
2012-07-12 19:00:00 |  |  | 5
2012-07-13 08:00:00 |  |  | 5
2012-07-13 12:00:00 |  |  | 5
2012-07-13 19:00:00 |  |  | 5
2012-07-14 08:00:00 |  |  | 5
2012-07-14 12:00:00 |  |  | 5
2012-07-14 19:00:00 |  |  | 6
2012-07-15 08:00:00 |  |  | 6
2012-07-15 12:00:00 |  |  | 6
2012-07-15 19:00:00 |  |  | 6
Spreadsheet: 136072d1326394049-text-data-manipulation-from-different-dumps-text-data-manipulation
Sheet: Sheet1

[NAME] we receive data | Personnel Number
[NAME] | 333
[NAME] | 1234
[NAME] | 5678
All in One
[NAME] 0333
[NAME] 1234
[NAME] 5678
Forename | Middle | Surname | Personnel Number
[NAME] |  | Smith | 333
[NAME] |  | Umber-Green | 1234
[NAME] | R | Grey | 5678
Spreadsheet: 469477d1467932178-help-with-drop-down-template
Sheet: Course List

 |  | COURSE LIST
 |  | TITLE | INSTRUCTOR | [NAME] | HOURS
 |  | Employee Introduction | [NAME] | A basic course introduction to new employees.  Defines departmental objectives and expectations, as well as time frames and boundaries. | 2
 |  | Employee Operations | [NAME] | Basic employee operations, covering the employee handbook. | 1
 |  | Employee Operations | [NAME] | Basic accounting procedures and guidelines | 1.5
 |  | Intermediate Accounting | [NAME] | Intermediate accounting procedures and guidelines. | 2
 |  | Advanced Accounting | [NAME] | Advanced accounting procedures and guidelines. | 2
Spreadsheet: 37201d1235142227-combine-multiple-sheets-combine-multiple-sheets
Sheet: Sheet1

SHOP 1 | SHOP 2 | SHOP 3 | SHOP 4 | SHOP 5 | Combined
 |  |  | YES |  | YES
 |  |  | YES |  | YES
 |  |  | YES |  | YES
 |  |  | YES |  | YES
 |  |  | YES |  | YES
 |  |  | YES |  | YES
 |  |  | YES |  | YES
 |  |  | YES |  | YES
 |  |  | YES |  | YES
 |  |  | YES |  | YES
 |  |  | YES |  | YES
 |  |  | YES |  | YES
 |  |  | YES |  | YES
 |  |  | YES |  | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
 |  |  |  | YES | YES
YES |  |  |  |  | YES
YES |  |  |  |  | YES
YES |  |  |  |  | YES
 | YES |  |  |  | YES
 | YES |  |  |  | YES
 | YES |  |  |  | YES
 | YES |  |  |  | YES
 | YES |  |  |  | YES
 | YES |  |  |  | YES
 | YES |  |  |  | YES
 | YES |  |  |  | YES
 | YES |  |  |  | YES
 | YES |  |  |  | YES
 | YES |  |  |  | YES
 | YES |  |  |  | YES
 | YES |  |  |  | YES
 | YES |  |  |  | YES
 | YES |  |  |  | YES
 | YES |  |  |  | YES
 | YES |  |  |  | YES
 | YES |  |  |  | YES
 | YES |  |  |  | YES
 | YES |  |  |  | YES
 | YES |  |  |  | YES
 | YES |  |  |  | YES
 | YES |  |  |  | YES
 | YES |  |  |  | YES
 | YES |  |  |  | YES
 | YES |  |  |  | YES
 | YES | YES |  | YES | YES
 | YES | YES |  | YES | YES
 | YES | YES |  | YES | YES
 | YES | YES |  | YES | YES
Spreadsheet: 878140d1725134946-amortization-for-those-payday-loans-with-apr-300-samstam-sample-amortization
Sheet: PayPal Credit

Loan amortization schedule without term
Name | PayPal Credit
Loan Amount | 5329.47
APR | 0.2924
Monthly Payment | 177
Monthly Interest
Month | Beginning Balance | Payment | Interest | Principal | Ending Balance
2024-09-01 00:00:00 | 5329.47
2024-10-01 00:00:00
2024-11-01 00:00:00
2024-12-01 00:00:00
2025-01-01 00:00:00
2025-02-01 00:00:00
2025-03-01 00:00:00
2025-04-01 00:00:00
2025-05-01 00:00:00
2025-06-01 00:00:00
2025-07-01 00:00:00
2025-08-01 00:00:00
2025-09-01 00:00:00
2025-10-01 00:00:00
2025-11-01 00:00:00
2025-12-01 00:00:00
2026-01-01 00:00:00
2026-02-01 00:00:00
2026-03-01 00:00:00
2026-04-01 00:00:00
2026-05-01 00:00:00
2026-06-01 00:00:00
2026-07-01 00:00:00
2026-08-01 00:00:00
2026-09-01 00:00:00
2026-10-01 00:00:00
2026-11-01 00:00:00
2026-12-01 00:00:00
2027-01-01 00:00:00
2027-02-01 00:00:00
2027-03-01 00:00:00
2027-04-01 00:00:00
2027-05-01 00:00:00
2027-06-01 00:00:00
2027-07-01 00:00:00
2027-08-01 00:00:00
2027-09-01 00:00:00
2027-10-01 00:00:00
2027-11-01 00:00:00
2027-12-01 00:00:00
2028-01-01 00:00:00
2028-02-01 00:00:00
2028-03-01 00:00:00
2028-04-01 00:00:00
2028-05-01 00:00:00
2028-06-01 00:00:00
2028-07-01 00:00:00
2028-08-01 00:00:00
2028-09-01 00:00:00
2028-10-01 00:00:00
2028-11-01 00:00:00
2028-12-01 00:00:00
2029-01-01 00:00:00
2029-02-01 00:00:00
2029-03-01 00:00:00
Spreadsheet: 817194d1676045125-identical-excel-formula-work-on-one-sheet-but-not-another-excel-test
Sheet: Not Working

 |  | Test
 |  | 1 | NOTE C9 is a number (1) while c10 is forced text ( '1 )
 |  | 1 | FORMULA TEXT
 |  | #[NAME]!
 |  | excel 1
Spreadsheet: 805929d1669018863-apply-formula-based-on-the-equality-of-adjacent-cells-excelforum21
Sheet: Sheet1

Barcode 1 | [NAME] apply downwards
A
A
A
A
B
B
B
B
B
B
B
C
Spreadsheet: 775335d1649036437-calculate-pay-rate-depending-on-the-time-of-day-weekly-time-sheet-help
Sheet: Sheet1

 | Date | Start Time | End Time | Break | Start Time | End Time | Total Hours | Pay Rate | Total Pay
Sunday | 2022-03-27 00:00:00 | 11:58:00 | 16:02:00 | 00:30:00 | 16:43:00 | 20:06:00 |  | 13
Monday | 2022-03-28 00:00:00
Tuesday | 2022-03-29 00:00:00
Wednesday | 2022-03-30 00:00:00
Thursday | 2022-03-31 00:00:00
Friday | 2022-04-01 00:00:00
Saturday | 2022-04-02 00:00:00
Sunday | 2022-04-03 00:00:00
Monday | 2022-04-04 00:00:00
Tuesday | 2022-04-05 00:00:00
Wednesday | 2022-04-06 00:00:00
Spreadsheet: 226600d1365448904-excel-solver-problem-ive-never-used-it-solver_bulls_cows
Sheet: Solver_setup1

hi All - I have a problem and think I would like to experience using solver to help me solve this:
given 1000 acres of land, and that 75% of its is pasturable - I want to maximize the numbers of cows that can be on it.
There can be a max of 1 cow per 2 acres
And we need 1 bull per 3 acres
The ratio of bulls to cows is 1 bull per 30 cows
how many cows and how many bulls can we have in total for the 750 acres?
Thank you!
 |  | cows | bulls
 |  | 357 |  |  | number of bulls = cows/30
 | Acers/unit | 2 | 3
 | Acers used |  |  |  |  | 750
 | Object func |  | set to [NAME]
 | Only problem with this solution is .9  bulls a small bull perhaps or setting number formate to 0.
 | Number of cows set up as integers. As bulls is a ratio in this set up i.e. cows/30 bulls can not be set up as
 | integers. Only adjustable cells can be set up as integers.
 | For those who have problems with .9 bulls see solver_setup2 where numbers of bulls and cows are
 | set up as integers.
Spreadsheet: 478569d1472862097-how-do-i-find-duplicates-between-worksheets-how-do-i-find-duplicates-between-worksheets
Sheet: Sheet4

231 | 111 | 177 | 224 | 250
177 | 124 | 248 | 253 | 180
105 | 168 | 180 | 114 | 282
211 | 240 | 195 | 112 | 206
238 | 104 | 297 | 261 | 126
186 | 209 | 280 | 150 | 112
100 | 147 | 270 | 296 | 168
Spreadsheet: 474314d1470730577-combining-data-in-rows-book3
Sheet: Sheet1

 | 0 | A | 0 | 0
 | B | 0 | 0 | 0
 | 0 | C | 0 | 0
 | 0 | 0 | 0 | D
 | 0 | 0 | 0 | E
 | 0 | F | 0 | 0
 | 0 | G | 0 | 0
 | 0 | 0 | H | 0
Spreadsheet: phillip_m_love__30649__9907_OA
Sheet: STG_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ALL
REGION:  STORAGE
 |  |  | Total |  | Reclasses |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  | 0
2 |  | Liquidations |  |  |  |  |  |  |  |  |  |  |  | 0
3 |  | Interdesk |  |  |  |  |  |  |  |  |  |  |  | 1428267 |  |  |  |  |  | -14792 |  |  |  | -17413
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
23 | Fuel: |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | -43915 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate |  |  |  |  |  |  |  | 123262
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance |  |  |  |  |  | 0 |  | 0
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  | -213900 |  |  |  | -156221.76 |  | 16908
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges |  |  |  |  |  |  |  |  |  |  |  |  |  | -376583
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  | -225 |  | 0
 |  | TOTAL
Spreadsheet: tracy_geaccone__40534__NNGOrgPLFormatCORP02
Sheet: NetCashFlow vs. 3rd CE

DETAIL OF CHANGE IN NET CASH FLOW
(Millions of Dollars)
 |  |  |  |  | 2002
 |  |  |  |  | Plan |  | 3rd C.E. |  | [NAME]
Net Cash Flow Information
 | Net Income |  |  |  |  |  | 99.7
 | Other Non-Cash Items |  |  |  |  |  | 47.9
 | Net (Gain) / Loss from Sale of Assets |  |  |  |  |  | -2.9
 | Price Risk Management Activities |  |  |  |  |  | 0.8
 | Merchant Activities (Net) |  |  |  |  |  | 0
 | Equity Earnings |  |  |  |  |  | -4.8
 | Equity Distributions |  |  |  |  |  | 8.2
 | Working Capital Changes |  |  |  |  |  | -43.9
 | Proceeds from Sale of Assets |  |  |  |  |  | 5.6
 | Capital Expenditures |  |  |  |  |  | -74.3
 | Dividends to EPC |  |  |  |  |  | 0
 | Change in Third Party Debt |  |  |  |  |  | 0
 | Other Cash Changes
 |  | Net Cash Flow |  |  |  |  | 32.5
Net Cash Flow Variance Analysis
 | (Inc.) / Dec. in Net Cash Flow - 2001 Third Current Estimate
 |  | Net Income Change (Excluding Asset Sales Impact)
 |  | Higher Income Taxes |  |  |  |  | -10.7
 |  | Lower Trailblazer Distributions ($-2.2) & 2002 Expansion ($-4.5) |  |  |  |  | -6.7
 |  | Higher Capital Expenditures |  |  |  |  | -37.8
 |  | Partial Base Gas Buyback (8 Bcf of 15.0 Bcf Total) |  |  |  |  | -25
 |  | Sales, Net Imbalance & Storage Gas Purchases Change |  |  |  |  | 39
 |  | Others, Net
 | (Inc.) / Dec. in Net Cash Flow - 2002 Operating Plan
Spreadsheet: 374bbd9c-77e0-433b-b0ae-2a8f9a7c44e1
Sheet: 9b

Product1 | USD | EUR3 | GBP | [NAME] | AUD | CAD | OTHER | TOTAL
Fixed-Float | 176371 | 58568 | 16616 | 17549 | 1931 | 4153 | 13577 | 288765
OTHER* | 109212 | 15211 | 457 | 4215 | 9334 | 6285 | 603 | 145317
TOTAL | 285583 | 73779 | 17073 | 21764 | 11265 | 10438 | 14180 | 434082
*OTHER variable includes the following products: Swaption, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, Inflation, Basis, OIS, and FRA.
Spreadsheet: 853634d1703566124-excel-cross-tabulated-dynamic-arrays-in-one-cell-excel-cross-tabulated-dynamic-arrays-in-one-cell
Sheet: TabDin

Data | Ano | Mês | Mês/Ano | [NAME] | [NAME] | [NAME] sem | [NAME] | [NAME] | Maria | João | Paulo | [NAME]
2023-12-04 00:00:00 |  |  |  |  |  |  | 2 |  | 2 | 6 | 1 | 2 |  |  |  |  |  | Just one formula in cell S9
2023-12-05 00:00:00 |  |  |  |  |  |  | 4 |  | 4 | 3 | 2 | 3
2023-12-06 00:00:00 |  |  |  |  |  |  | 5 |  | 1 | 1 | 3 | 6
2023-12-07 00:00:00 |  |  |  |  |  |  | 7 |  | 1 | 4 | 1 |  |  |  |  |  | 50 | [NAME] | [NAME] | Maria | João | Paulo | [NAME]
2023-12-09 00:00:00 |  |  |  |  |  |  | 1 |  |  |  | 3
2023-12-10 00:00:00 |  |  |  |  |  |  |  | 1 |  | 5 | 2 | 2 |  |  |  |  | Seg | 4 | 3 | 0 | 3 | 4 | 4
2023-12-11 00:00:00 |  |  |  |  |  |  | 4 | 3 |  | 3 | 4 | 4 |  |  |  |  | Ter | 4 | 5 | 3 | 6 | 5 | 1
2023-12-12 00:00:00 |  |  |  |  |  |  | 4 | 5 | 3 | 6 | 5 | 1 |  |  |  |  | Qua | 4 | 4 | 2 | 8 | 6 | 9
2023-12-13 00:00:00 |  |  |  |  |  |  | 4 | 4 | 2 | 8 | 6 | 9 |  |  |  |  | Qui | 7 | 13 | 1 | 1 | 7 | 0
2023-12-14 00:00:00 |  |  |  |  |  |  | 7 | 13 | 1 | 1 | 7 |  |  |  |  |  | Sex | 2 | 3 | 0 | 3 | 1 | 7
2023-12-15 00:00:00 |  |  |  |  |  |  | 2 | 3 |  | 3 | 1 | 7 |  |  |  |  | Sáb | 2 | 1 | 1 | 0 | 8 | 0
2023-12-16 00:00:00 |  |  |  |  |  |  | 2 | 1 | 1 |  | 8
2023-12-18 00:00:00 |  |  |  |  |  |  | 4 | 1 | 3 |  | 2 | 3
2023-12-19 00:00:00 |  |  |  |  |  |  | 9 | 3 |  | 6 | 4 | 5
2023-12-20 00:00:00 |  |  |  |  |  |  | 4 | 2 | 1 |  | 6 | 2
2023-12-21 00:00:00 |  |  |  |  |  |  | 7 | 14 | 1 | 8
2023-12-26 00:00:00 |  |  |  |  |  |  |  | 1 |  | 9