tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 826026d1681742512-sum-of-a-row-individual-letters-converted-into-a-specific-number-excell-forum
Sheet: SAMPLE

 |  |  | 15th May |  |  |  |  |  |  |  |  | E | 7.5
 |  |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Hours scheduled to work on week commencing: |  | L | 7.5
 |  |  | 15 | 16 | 17 | 18 | 19 | 20 | 21 |  |  | N | 9.2
 |  |  |  |  |  |  |  |  |  | 15/5/20223
Sisters
 |  |  | E | E | L | L | L | OFF | OFF
 |  |  |  |  | E | E |  | E | L
 |  |  | L | L |  |  | E | L
MND Nurse
 |  |  | DAYS |  | DAYS |  | DAYS
Senior Staff Nurse
 |  |  |  | E | E |  | N
 |  |  | OFF | E |  | E | L
 |  |  |  |  |  |  |  | N | N
 |  |  | A/L | A/L | A/L | A/L | A/L | A/L | A/L
 |  |  | A/L | A/L | A/L | A/L | A/L | A/L | A/L
 |  |  | L |  | L | L |  | L
 |  |  |  | OFF | N |  |  |  | N
 |  |  | L |  |  | D/O | E |  | E
 |  |  |  |  |  | L | L | L | L
 |  |  | E | L |  |  | E
 |  |  |  |  | E | E |  | E | E
 |  |  | N | N |  |  |  |  | E
 |  |  | N |  |  | N | N | N
Staff Nurse
 |  | 30 | OFF | N | N | N |  | OFF
 |  | 22.5 | E |  | L |  |  | E
 |  | 22.5 | OFF | OFF | OFF | OFF | OFF | OFF | OFF
Total Early
Total Late
Total Night
 |  |  | 15th May
 |  |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Hours worked as of:
 |  |  | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 15th May 2023
Care Assistants
 |  | 22.5 |  |  | E |  | L | N
 |  | 30 | A/L | A/L | N |  |  |  | E
 |  | 37.5 | E | L | N | D/O | D/O | L | N
 |  | 30 |  | E |  | L |  | E | E
 |  | 22.5 |  | D/O | L | L | N
 |  | 22.5 | E | L | OFF | E
 |  | 22.5 | A/L | A/L | A/L | A/L | A/L | A/L | A/L
 |  | 30 | L |  | L | L |  |  | L
 |  | 22.5 | N |  |  |  |  | L | E
 |  | 30 | E | E |  |  | L | L
 |  | 30 | E | E | E |  | E
 |  | 22.5 |  |  |  | E |  | E | L
 |  | 22.5 | L |  | E | D/O | E | D/O | D/O
 |  | 30 |  | N |  | E | E |  | L
Total Early
Total Late
Total Night
TOTAL ON SHIFT | EARLY
TOTAL ON SHIFT | LATE
TOTAL ON SHIFT | NIGHT
Spreadsheet: 8443bdde-05c3-4158-9f3b-c8416e2144c7
Sheet: Sheet1

Name | Add1 | CSZ | phone | fax | e-mail | [NAME]
[NAME], Inc. | 162 North Main Street | [NAME], MA 01949 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
[NAME], Inc. | 162 North Main Street | [NAME], MA 01949 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Ferguson Enterprises | 400 Lynnway | [NAME], MA 01905 | [PHONE] |  | [EMAIL] | [NAME]
[NAME] | 2 Whitman Road | Canton, MA 02021 | [PHONE] | [PHONE] | [EMAIL] | Allen Penney
HD [NAME] | 125 Sturgis Way | Dedham, MA 02026 |  |  | [EMAIL] | [NAME]
J&S Valve, Inc. | 2323 1st Street | Huffman, TX 77336 | [PHONE] |  | [EMAIL] | [NAME]
Metalloy Industries, Inc. | PO Box 1150 | Alachua, FL 32616 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Metalloy Industries, Inc. | PO Box 1150 | Alachua, FL 32616 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Public Works Supply | 27 Garden Street | Danvers, MA 01923 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Stiles Co., Inc. | 922 Pleasant St | Norwood, MA 02062 | [PHONE] | [PHONE] | [EMAIL] | Sandy
TI Sales Inc. | 36 Hudson Rd | Sudbury, MA 01776 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Spreadsheet: 872033d1718380287-sorting-from-3-lists-sorting
Sheet: Summary

Scope | Responsibility | Bid Package
Brokered / Self Perform Concrete | [NAME] 1 | [NAME]
Building & Foundation Concrete | [NAME] 1 | [NAME]
Final Cleaning | [NAME] 1 | [NAME]
Masonry / Stone | [NAME] 2 | [NAME]
Precast Concrete | [NAME] 3 | [NAME]
Selective Demolition | [NAME] 4 | [NAME]
Site and Structure Demolition | [NAME] 4 | [NAME]
Structural Steel | [NAME] 3 | [NAME]
Surveying | [NAME] 1 | [NAME]
[NAME] | [NAME] 1 | [NAME]
Rough Carpentry | [NAME] 2 | [NAME]
Millwork and Finish Carpentry | [NAME] 2 | [NAME]
Dampproofing and Waterproofing | [NAME] 3 | Bid Package 7
EIFS | [NAME] 3 | [NAME]
Expansion Joints | [NAME] 4 | [NAME]
Metal Roofing & Wall Panels | [NAME] 4 | [NAME]
Building Siding | [NAME] 1 | [NAME]
Membrane Roofing | [NAME] 3 | [NAME]
Fireproofing and Containment | [NAME] 3 | [NAME]
[NAME] and Firestopping | [NAME] 1 | [NAME]
Spray Insulation | [NAME] 1 | [NAME]
Weather and [NAME] | [NAME] 1 | [NAME]
Spreadsheet: 79713d1279900615-keeping-count-total-after-cells-have-been-deleted-service-dispatch-w-tabs
Sheet: DELIVERY

 |  |  |  |  | ALL WORK IN SHOP |  |  |  | COMPLETED WORK
TOTALS | AW | KT | PK |  | AW | KT | PK |  | AW | KT | PK
DELIVERY | 0 | 0 | 2 |  | 0 | 0 | 0 |  | 0 | 0 | 2
DROPOFF | 5 | 9 | 3 |  | 4 | 5 | 3 |  | 1 | 4 | 0
APPT | 6 | 2 | 3 |  | 3 | 2 | 2 |  | 3 | 0 | 1
EXPRESS | 1 | 0 | 1 |  | 1 | 0 | 1 |  | 0 | 0 | 0
Total Jobs | 12 | 11 | 9 |  | 8 | 7 | 6 |  | 4 | 4 | 3
Unspecified | 33 | 34 | 13 |  | 20 | 18 | 4 |  | 13 | 16 | 9
Total Jobs | 45 | 45 | 22 |  | 28 | 25 | 10 |  | 17 | 20 | 12
This sheet sums the types of jobs taken in for each service writer. It pulls information from the ALL WORK IN SHOP and COMPLETED WORK tabs.
Any job that is not listed as Delivery, Dropoff, Appt, or Express is labelled as Unspecified.
This is not a running total, only a total of all the current jobs in those two tabs. As a job gets deleted the numbers will change.
Spreadsheet: 690908d1597351530-vlookup-index-match-multiple-records-to-find-demo4
Sheet: ABC CO

 | ABC CO
MEMBER_ID | PROD | DESC | CODE_1 | CATEGORY_1 | CODE_2 | CATEGORY_2 | CHARGE | COUNT | OWED | INDEX | LAST | START | GROUP | Name
Spreadsheet: 8aca7b9d-7785-4bba-845a-8908d261e705
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
DYSFE | Test | DYSFE | [NAME] (Bill Only) | [NAME] | Histochemical |  |  |  |  |  | This test is not orderable.  Order HMAX Histochemistry of Sent-In Muscle Specimen Maximum.  The consult will determine the need for special stains. This test is for billing purposes only. [NAME] |  |  | This request will be processed as a consultation. An interpretation will be provided. |  |  |  | 1 | 88342 |  |  |  |  | Rochester
DYSFE | [NAME] | TISSUE | Tissue |  |  |  | Frozen
Spreadsheet: 823589d1680022417-sumif-formula-to-calculate-cells-in-between-sheets-based-on-cell-dropdown-r-and-ft-template
Sheet: Resources - 2024

 | RESOURCE TRACKER - YYYY
 | Date | Forecast Days (At Strategise/Shape) | Forecast Days (At Initiate) | Change Requests |  | TOTALS
 |  |  |  | Reference | Days
 | TOTALS
 | RESOURCES |  |  |  |  |  | MONTHLY ALLOCATION |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTALS
 | Name | Business Area | [NAME] | Resource Requested Until | Resource Confirmed Until | Unit Amount | 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 |  | 2023-10-01 00:00:00 |  | 2023-11-01 00:00:00 |  | 2023-12-01 00:00:00
 |  |  |  |  |  |  | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | TOTAL FORECAST | TOTAL FORECAST  TO DATE | TOTAL ACTUALS | TOTAL ACTUALS COST | [NAME]
 |  |  | BA Team Managers | JUN | APR | 500 | 1 | 1.2 | 0.5 | 0.7 | 2 | 2.4 | 1.25 | 0.4 | 1 |  | 1 |  | 1
 |  |  | BI Life |  |  |  | 1 | 1.3 | 1 | 1.3 | 1 | 1.3 | 1 |  | 1 |  | 1 |  | 1
 |  |  | Automation test |  |  |  | 2 | 2.4 | 1 | 1.2 | 1 | 1.2 | 1 |  | 1 |  | 1 |  | 1
 |  |  | BillingCenter |  |  |  | 1 | 1.3 | 1 | 1.3 | 0.5 | 0.7 | 1 |  | 1 |  | 1 |  | 1
 |  |  | Project Manager |  |  |  | 1 | 1.2 | 2 | 2.4 | 1 | 1.2 | 1 |  | 1 |  | 1 |  | 1
 |  |  | MI Tester |  |  |  | 1 | 1.3 | 1 | 1.3 | 1 | 1.3 | 1 |  | 1 |  | 1 |  | 1
 |  |  | Technical Service Owner |  |  |  | 1 | 1.2 | 0.5 | 0.7 | 1 | 1.2 | 1 |  | 1 |  | 1 |  | 1
 |  |  | MDM |  |  |  | 1 | 1.3 | 1 | 1.3 | 0.5 | 0.7 | 1 |  | 1 |  | 1 |  | 1
 |  |  | Print ISIS Papyrus |  |  |  | 0.5 | 0.7 | 1 | 1.2 | 1 | 1.2 | 1 |  | 1 |  | 1 |  | 1
 |  |  | Test WSL |  |  |  | 1 | 1.3 | 0.5 | 0.7 | 1 | 1.3 | 1 |  | 1 |  | 1 |  | 1
 | TOTALS DAYS
 | TOTALS IN £s
Spreadsheet: 88999d1288798090-update-daily-goal-copy-of-rep-daily-numbers
Sheet: Sheet1

[NAME] | Acts | Bus Acts | Handsets | Buy Backs | [NAME] | Accessories
Goal | 27 | 2 | 76 | 20 | 0.65 | 2000
MTD | 10 | 0 | 12 | 12 | 10 | 900
Need | 17 | 2 | 64 | 8 | 8 | 1100
Daily Goal | 4 | 1 | 5 | 5 |  | 150
Actual | 1 | 1 | 0 | 0 |  | 50
Needed | 3 | 0 | 5 | 5 |  | 100
 |  |  |  |  |  | Send Numbers
 |  |  |  |  | Date | 2010-11-03 08:12:51
 |  |  |  |  | Day's Remaining | 3
Spreadsheet: 770506d1646127938-vlookup-issue-or-alternative-fix-example
Sheet: Sheet1

 | Month | Actual | Target | Result | Bonus |  | REVENUE | MONTHLY BONUS
 | January | 2105 | 2000 |  |  |  | 1.1 | 300
 | February | 3110 | 3000 |  |  |  | 1.09 | 280
 | March | 3201 | 3000 |  |  |  | 1.08 | 260
 |  |  |  |  |  |  | 1.07 | 240
 |  |  |  |  |  |  | 1.06 | 220
 |  |  |  |  |  |  | 1.05 | 200
 |  |  |  |  |  |  | 1.04 | 180
 |  |  |  |  |  |  | 1.03 | 160
 |  |  |  |  |  |  | 1.02 | 140
 |  |  |  |  |  |  | 1.01 | 120
 |  |  |  |  |  |  | 1 | 100
Spreadsheet: phillip_allen__28910__version 2_20
Sheet: Summary

 | Category | Rates | Amounts | % Value | % Cost | Per Unit | Per SF
 | TOTAL VALUE | 10% [NAME]
 | TOTAL ANNUAL NOI
 | ANNUAL MORTGAGE COST
 | NET ANNUAL CASH
 | INVESTOR SHARE | 0.5
 | PERMANENT LOAN | 0.8
 | Construction Cost
 | Construction Profit | 0.15
 | TOTAL COST
 | TOTAL PERMANENT LOAN EQUITY
 | ANNUAL RETURN ON EQUITY
 | INTERIM LOAN
 | No Forward Commitment
 | Total Cost to Lender |  | 13185811
 | Interim Loan
 | Equity Required With No Forward Commitment
 | Less Construction Profit -To Lender
 | EXPECTED LOAN EQUITY
 | MAXIMUM LOAN EQUITY
 | With Forward Commitment
 | Total Cost to Lender
 | Interim Loan
 | Equity Required
 | Less Construction Profit -To Lender
 | NET CASH LOAN EQUITY
 | KEY ELEMENTS:
 | Bank One has stated that they will apply all reasonable construction profit to the interim loan equity.  They have also stated that 25% is typical for a for build to suit, therefore, we have used it here, but it could be reduced to !5-22%.
 | Maximum Loan Equity Reflects the MINIMUM Construction Profit of 15%
 | Interim Interest:  8.75% rate, with 75% avg. balance and 9 month term
 | Origination Points - 1.0% of Loan, Closing Costs - 0.25% of Loan
 | Forward Commitment Fee Permanent Loan - 1.25% - Included in total cost for that option.
 | 134 Units Including 1 manager's unit
 | 2Bedroom 2.5 Bath, Townhome with covered parking & 1,000 SF for $1180
 | 3 Bedroom 3.5 Bath, Townhome with Garage and 1,200 SF for $1530
 | Lease Up:  3-6 months Maximum
 | Amenities:  Pool, [NAME], BBQ, Volleyball, Basketball, Business Center, Vending Machines, Fitness Center, Full Perimeter Fence, Security Gates, Pre-Wired For Unit Security, Free Cable Tv, Free High Speed Internet, Oversized Units, Low Density And Townhome Unit Design.
Spreadsheet: 1638d671-5d6e-4cad-a72a-932257a68138
Sheet: Publishers (Poetry)

Publisher (Poetry) | Titles | Percentage
Zephyr Press | 7
New Directions | 6
Seagull Books | 5
White Pine | 4
Archipelago | 2
BOA Editions | 2
Fence Books | 2
[NAME] | 2
New York Review Books | 2
Restless Books | 2
Syracuse University Press | 2
Talisman House | 2
Action Books | 1
[NAME] | 1
[NAME] | 1
Bitter Oleander Press | 1
Burning Deck Press | 1
City Lights | 1
Copper Canyon | 1
[NAME] | 1
FSG | 1
Ilex Foundation | 1
Liveright | 1
Milkweed | 1
Open Letter | 1
Phoneme Books | 1
Rodmell Press | 1
Stone Bridge Press | 1
Tavern Books | 1
Wakefield Press | 1
Wave Books | 1
Wesleyan University Press | 1
Spreadsheet: 91544d1291237410-populate-list-based-on-selection-check
Sheet: Sheet1

click boxes list appears here
destination 3 | 7654
destination 5 | 987
destination 1 | 1234 |  |  |  |  |  |  |  |  |  | list of dest/phone
 |  |  |  | destination 1 |  |  | 1 | 0.8767592592592592 |  |  | destination 1 | 1234
 |  |  |  |  |  |  |  |  |  |  | destination 2 | 4567
 |  |  |  | destination 2 |  |  | 0 |  |  |  | destination 3 | 7654
 |  |  |  |  |  |  |  |  |  |  | destination 4 | 8975
 |  |  |  | destination 3 |  |  | 1 | 0.8763773148148148 |  |  | destination 5 | 987
 |  |  |  | destination 4 |  |  | 0
 |  |  |  | destination 5 |  |  | 1 | 0.8767361111111112
Spreadsheet: 781963d1653658675-max-and-average-formulae-needed-if-conditions-met-in-other-cells-max-ave-aligw
Sheet: Sheet1

 | Status | Start date | ID | Name | Place | Details | Level | Required by | Given to | No of days | End date
 |  | 2022-05-01 00:00:00 |  |  |  |  | High |  |  |  |  |  |  | MAX
 |  | 2022-05-05 00:00:00 |  |  |  |  | Medium |  |  |  | 2022-05-25 00:00:00 |  |  | AVERAGE
 |  | 2022-05-06 00:00:00 |  |  |  |  | High
 |  | 2022-05-27 00:00:00 |  |  |  |  | High
Spreadsheet: 98406d1297314704-soccer-reg-workbook-soccer-red-example
Sheet: Data

 |  | Lookup |  | Birthday
 | x | U5 | Kid1 | 2006-06-15 00:00:00 | 2006
 |  | U6 | Kid2 | 2005-05-14 00:00:00 | 2005
 | x | U7 | Kid3 | 2004-04-13 00:00:00 | 2004
 |  | U8 | [NAME] | 2003-03-12 00:00:00 | 2003
 | x | U9 | Kid5 | 2002-02-11 00:00:00 | 2002
 |  | U10 | [NAME] | 2001-07-16 00:00:00 | 2001
 |  | U4 | [NAME] | 2007-06-15 00:00:00 | 2007
 | x | U5 | Kid8 | 2006-05-14 00:00:00 | 2006
 |  | U6 | Kid9 | 2005-04-13 00:00:00 | 2005
 |  | U7 | Kid10 | 2004-03-11 00:00:00 | 2004
 | x | U8 | Kid11 | 2003-02-11 00:00:00 | 2003
 |  | U9 | Kid12 | 2002-07-16 00:00:00 | 2002
Spreadsheet: 841856d1693998821-how-to-get-mutilple-search-results-using-index-and-match-formulas-shreenivas_automobiles_price_list-slatad-
Sheet: Castrol

Sr.No | Product_Name | Quantity | MRP | DLP | Combined_Name
1 | Magneteac 5w30 | 3.5L | 2537 | 1918
2 | Magneteac 0w16 | 3.5L | 2300 | 1900
3 | Magneteac 0w20 | 3.5L | 2300 | 1900
4 | Magneteac 5w30 | 0.5L | 370 | 278
5 | Edge 5w40 | 4L | 3900 | 2800
6 | GTX Ultraclean 5w30 | 3.5L | 1570 | 1300
7 | CRB Turbomax 15w40 | 5L | 1970 | 1660
8 | CRB Multi 15w40 | 3L | 964 | 783
9 | CRB Minitruck 15w40 | 3L | 1073 | 920
10 | Power1 [NAME] 15w50 | 2.5L | 1170 | 900
11 | CRB Turbomax 15w40 | 7.5L | 2696 | 2270
12 | CRB Turbomax 15w40 | 7.5L | 2770 | 2268
13 | RX Turbok 15w40 | 15L | 6489 | 5275
14 | GTX Ultraclean 5w30 | 3.5L | 1473 | 1241
15 | Manual 80w90 | 2.5L | 1073 | 911
16 | Activ+GO 10w30 | 0.8L | 420 | 340
17 | [NAME] | 0.8L | 372 | 307
18 | Ultimate 10w40 | 1L | 694 | 504
19 | Edge 5w40 | 4L | 5022 | 3223
20 | Rx SAE 30 | 20L | 8841 | 7193
21 | Essential 20w50 | 1L | 321 | 265
22 | GTX 20w50 | 1L | 445 | 373
23 | CRB Turbomax CH-4 15w40 | 15L | 5327 | 4527
24 | Ultimate Scooter 5w40 | 0.8L | 555 | 407
Spreadsheet: 697503d1601387205-using-an-isblank-index-and-match-functions-for-a-progressive-afl-finals-table-afl-finals-draw
Sheet: Sheet1

 | Ladder
 |  |  |  | W
 |  |  |  | L
1 | Port Power
2 | Brisbane Lions |  | QF1: 1st Qualifying Final
3 | Richmond | 1st |  | L
4 | Geelong | 4th |  |  | SF1: 1st Semi Final
5 | West Coast Eagles
6 | [NAME] |  |  |  |  |  | PF1: 1st Preliminary Final
7 | Bulldogs |  | EF1: 1st Elimination Final
8 | Collingwood | 5th
 |  | 8th |  |  |  |  |  |  | Grand Final
9 | Melbourne |  |  |  |  |  |  |  |  |  | GF Winner
10 | GWS Giants
11 | Carlton |  | EF2: 2nd Elimination Final |  |  |  | PF2: 2nd preliminary Final
12 | Fremantle | 6th
13 | Essendon | 7th |  |  | SF2: 2nd Semi Final
14 | Gold Coast Suns
15 | Hawthorn
16 | Sydney |  | QF2: 2nd Qualifying Final
17 | North Melbourne | 2nd
18 | Adelaide | 3rd
Spreadsheet: 734254d1622070297-how-do-i-make-the-date-change-when-cell-in-row-is-updated-sample-key-document
Sheet: Sheet1

Key | Key Tag # | Room/Use | Last Name | First Name | Date | Availability | Comments
D-1 | 1 |  |  |  | 2017-05-25 00:00:00 | Yes
D-2 | 1 |  |  |  | 2017-05-25 00:00:00 | Yes
D-3 | 1 |  |  |  | 2017-05-25 00:00:00 | Yes
D-4 | 1 |  |  |  | 2017-05-25 00:00:00 | Yes
D-5 | 1 |  |  |  | 2017-05-25 00:00:00 | Yes
D-6 | 1 |  |  |  | 2017-05-25 00:00:00 | Yes
[NAME] | 1 |  |  |  | 2017-05-25 00:00:00 | Yes
D-8 | 1 |  |  |  | 2017-05-25 00:00:00 | Yes
D-9 | 1 |  |  |  | 2017-05-25 00:00:00 | Yes
D-10 | 1 |  |  |  | 2017-05-25 00:00:00 | Yes
Spreadsheet: 117628d1312917158-looking-for-a-formula-for-a-template-to-pull-data-under-specific-criteria-pull-data-under-specific-criteria
Sheet: Sheet2

Enter a Day > | 3
Row # | Number | Estimate Date | Actual Date | Difference in days
Spreadsheet: 599852d1543336390-conditional-formatting-highlight-every-intersection-point-in-pivot-table-exampletable
Sheet: Sheet1

Packages | Date
Predicted Date | 2018-11-07 | 2018-11-08 | 2018-11-09 | 2018-11-10 | 2018-11-11 | 2018-11-12 | 2018-11-13 | 2018-11-14 | 2018-11-15 | Grand Total
11/08/2018 |  | 19 | 38
11/09/2018 |  | 9 | 3147 | 714 | 7 | 1 | 18 | 1 | 1
11/10/2018 |  | 3 | 533 | 41317 | 21 | 130 | 1340 | 68 | 11
11/11/2018 |  |  |  |  | 125 | 18 | 96 | 2
11/12/2018 |  |  | 1 | 3 |  | 741 | 5160 | 69 | 10
11/13/2018 |  | 35 | 9 | 841 | 255 | 1146 | 38424 | 1222 | 29
11/14/2018 |  | 10 | 6 | 15 |  | 16 | 2765 | 83412 | 1126
11/15/2018 | 1 | 4 |  | 4 |  |  | 32 | 8893 | 52046
11/16/2018 |  |  | 2 | 2 |  | 2 | 94 | 197 | 5722
Grand Total
Spreadsheet: benjamin_rogers__1159__Base
Sheet: Wheatland

INCOME STATEMENT - WHEATLAND
('000 $) |  |  |  | 1999
Revenue
PPA Period:
Demand Payment |  |  |  | 0
Energy Payment
Block Payment |  |  |  | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Market Period:
Demand Payment |  |  |  | 0 | 0 | 0 | 0
Variable Revenue |  |  |  | 0 | 0 | 0 | 0
Energy Margin |  |  |  | 0 | 0 | 0 | 0
Interest Income
Total Revenue
Expense
Fuel |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fixed O&M |  |  |  | 0
Variable O&M |  |  |  | 0
Major Maintenance & Ongoing Capex |  |  |  | 0
Insurance |  |  |  | 0
SG&A |  |  |  | 0
Utility Start Up Power |  |  |  | 0
Property, Other Taxes |  |  |  | 0 | 335.11988732968 | 305.53364568 | 393.967241108452 | 665.7447794913775 | 959.0666278219292 | 1057.522043124469 | 1172.531686871709 | 1305.28983356803 | 1399.514346101357 | 1429.580905835357 | 1467.405353015643 | 1647.705553299947 | 1668.8480706845 | 1663.088395112042 | 1682.609527553574 | 1701.639422357626 | 1720.138770763951 | 1746.660255600564 | 1776.004310876915 | 1778.194135077955 | 945.4164985980001
Debt Service L/C Fee |  |  |  | 0
Marketing Fee |  |  |  | 0 | 0 | 0 | 0
Administrative Fee |  |  |  | 0
O&M Fees |  |  |  | 0
Total Expense
EBITDA
Depreciation & Amortization |  |  |  | 0
EBIT
Interest Expense |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
EBT
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense) |  |  |  | 0
Wheatland Net Income
CASH FLOW - WHEATLAND
Investor Interest
('000 $) |  |  |  | 1999
EBITDA
Capital Expenditures |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Debt Service |  |  |  | 0
Pre Tax Cash Flow
State Cash Taxes Benefit (Expense) |  |  |  | 0
Federal Cash Taxes Benefit (Expense) |  |  |  | 0
After Tax Cash Flow
Investor Net Income
Investor [NAME]
INCOME/ GROSS RECEIPTS TAX - WHEATLAND (SPECIFIC TO WHEATLAND ONLY)
Adjusted Gross Income Tax
Book Income
Adjusted Gross Income Rate |  |  |  |  | 0.034 | 0.034 | 0.034 | 0.034 | 0.034 | 0.034 | 0.034 | 0.034 | 0.034 | 0.034 | 0.034 | 0.034 | 0.034 | 0.034 | 0.034 | 0.034 | 0.034 | 0.034 | 0.034 | 0.034 | 0.034
State Adjusted Gross Income Tax
State Gross Receipts Taxes
Gross Receipts on non TVA hours ONLY
Gross Receipts Tax Rate |  |  |  |  | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0
Gross Receipts Tax Liability
Greater of Adjusted or Gross Receipts
Spreadsheet: 49638d1248981025-index-and-match-693753
Sheet: Sheet1

Items | Quality | Jan | Feb | March | April
BC1 | QM1 | 1000 | 1200 | 1300 | 1350
BC2 | QM1 | 800 | 850 | 950 | 970
BC3 | QM1 | 600 | 620 | 612 | 650
KI | QM1 | 10 | 16 | 12 | 14
KI | QM2 | 4 | 6 | 5 | 6
KI | QM3 | 2 | 3 | 2 | 2
BA | QM1 | 30 | 32 | 35 | 40
BA | QM2 | 0 | 3 | 0 | 0
Quality | (All)
 | Data
Items | Sum of Jan | Sum of Feb | Sum of March | Sum of April
BA | 30 | 35 | 35 | 40
BC1 | 1000 | 1200 | 1300 | 1350
BC2 | 800 | 850 | 950 | 970
BC3 | 600 | 620 | 612 | 650
KI | 16 | 25 | 19 | 22
Grand Total | 2446 | 2730 | 2916 | 3032
Spreadsheet: 533c62e9-f356-403c-8ab3-aac0daf6782f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
30 Montgomery Street, 3rd Floor, Jersey City  NJ  07302
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Description of Mortgage Collateral for Submission
Member [NAME]  ______________________________     Member # : __________    Sub Acct: _______
Date of Submission:  __________ |  |  | Data Source:   _________________ |  |  |  | Authorized Signature:  __________________________    Name and Title: _______________________________
Loan Number | Borrower Name | Property Address | State | Zip Code | Closing Date | Original      Loan Amount | Term (Mo) | Maturity Date | P&I | Unpaid Balance | Int. Rate | LTV | Last Paid Date | Adj. or [NAME] | 1st or 2nd Mtg | FHA, VA or Conv. | Property  type **
Total Loans:  ________ |  |  |  |  |  |  |  |  | Total UPB:  _______________ |  |  |  |  |  | Page  ____  of ____
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Effective Date: __________
*FORWARD SUBMISSIONS TO: |  | FEDERAL HOME LOAN BANK OF NEW YORK
 |  | 30 Montgomery Street, 3rd Floor
 |  | Jersey City, NJ  07302-3821
**NOTE-PLEASE PLACE ORIGINAL COL-108 WITH MORTGAGE SUBMISSION & E-MAIL SUBMISSION IN EXCEL FORMAT TO: [EMAIL]
** Please use the following property type codes when submitting mortgage collateral:
"RSMTG" = 1-4 family,  "CONDO", "CO-OP"
"MULTI" = multifamily,  "MXUSE" = mixed use, "CMMTG" = commercial
Spreadsheet: 96840d1296117944-formula-to-sort-rows-automatically-sales-data
Sheet: Data

Date Sold | Order Number | Company | Sold | H | A | PM | Inst | Deposit | Discount