tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 708063d1607604570-85th-percentile-speed-survey-thorns-road-data-set-example
Sheet: SB

Date | Time Period | All vehc | <5 | <10 | <15 | <20 | <25 | <30 | <35 | <40 | <45 | <50 | <55 | <60 | <65 | <70
Thursday 19/06/2014 | 12:00-12:15 | 208 | 2 | 0 | 2 | 40 | 102 | 44 | 13 | 5 | 0 | 0 | 0 | 0 | 0 | 0
Thursday 19/06/2014 | 12:00-12:15 | 208 | 2 | 0 | 2 | 40 | 102 | 44 | 13 | 5 | 0 | 0 | 0 | 0 | 0 | 0
Thursday 19/06/2014 | 12:15-12:30 | 203 | 0 | 4 | 14 | 47 | 70 | 63 | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Thursday 19/06/2014 | 12:30-12:45 | 211 | 0 | 0 | 3 | 44 | 98 | 57 | 6 | 2 | 1 | 0 | 0 | 0 | 0 | 0
Thursday 19/06/2014 | 12:45-13:00 | 192 | 0 | 1 | 1 | 29 | 110 | 42 | 8 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Thursday 19/06/2014 | 13:00-13:15 | 233 | 4 | 2 | 5 | 37 | 102 | 68 | 12 | 2 | 0 | 1 | 0 | 0 | 0 | 0
Thursday 19/06/2014 | 13:15-13:30 | 198 | 3 | 0 | 8 | 28 | 92 | 60 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Thursday 19/06/2014 | 13:30-13:45 | 219 | 0 | 0 | 18 | 39 | 91 | 59 | 11 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Thursday 19/06/2014 | 13:45-14:00 | 176 | 2 | 3 | 9 | 39 | 77 | 40 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Thursday 19/06/2014 | 14:00-14:15 | 208 | 7 | 2 | 9 | 58 | 65 | 54 | 12 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 781835d1653575293-count-of-certain-text-based-on-value-on-another-cell-test
Sheet: Data

Project | Assigned to | Status
ABC report | [NAME] | In Progress
XYZ Project | [NAME] | Complete
ABC Presentation | [NAME] | In Progress |  |  |  | Count of Status | Column Labels
Costings report | [NAME] | Not started |  |  |  | Row Labels | In Progress | Grand Total
AAA Report | [NAME] | In Progress |  |  |  | [NAME] | 1 | 1
Pricing report | [NAME] | In Progress |  |  |  | [NAME] | 2 | 2
 |  |  |  |  |  | [NAME] | 1 | 1
 |  |  |  |  |  | Grand Total | 4 | 4
Spreadsheet: 839435d1691982064-correction-in-vlookup-function-in-relative-reference-test1-3-
Sheet: Sheet1

STRING | LEN | Desired result | [NAME] results | LEN | Function
SYD DL LAX DL ATL DL LAX DL SYD | 31 |  |  | 17 | =Right(D4,3)
SYD DL LAX DL SYD |  |  |  | 31 | =MID(D4, 15, 3)
SYD DL LAX DL DTW DL LAX DL SYD |  |  |  | 36 | = MID(D4,15,3)
SYD DL LAX DL SAN//PHX DL LAX DL SYD |  |  |  | 45 | =MID(D4,22,3)
SYD DL LAX DL ATL DL GIG DL JFK DL LAX DL SYD
SYD DL LAX DL ATL DL CHS DL MSP DL LAX DL SYD
SYD DL LAX DL ATL DL FLL DL ATL DL LAX DL SYD
SYD DL LAX DL TUS DL LAX DL SYD
 |  |  | Function to use corresponding B column instead D
Spreadsheet: 839100d1691657936-sumif-formula-help-financial-report-2023-season-financial-report
Sheet: June

Date | Transaction | Withdrawals | Deposits | Balance | Code | Comments
Opening balance |  |  |  | 8573.77
2023-06-01 00:00:00 | INTEREST |  | 0.08 | 8573.85 | INT
2023-06-02 00:00:00 | DIRECT CREDIT SQUARE AU PTY LT    [PHONE] |  | 46.84 | 8620.69 | SQ
2023-06-08 00:00:00 | DIRECT CREDIT KIRSTI WILSON       [PHONE] |  | 50 | 8670.69 | OTH+ | Dayman family fees
2023-06-08 00:00:00 | OSKO PAYMENT   [NAME] reimbursed | 19.34 |  | 8651.35 | REIMB
2023-06-09 00:00:00 | DIRECT CREDIT SQUARE AU PTY LT    [PHONE] |  | 191.49 | 8842.84 | SQ
2023-06-12 00:00:00 | OSKO PAYMENT   Ashlee M Craig Reimbursed juniors canteen | 152.67 |  | 8690.17 | REIMB
2023-06-13 00:00:00 | DIRECT CREDIT SQUARE AU PTY LT    [PHONE] |  | 267.76 | 8957.93 | SQ
2023-06-16 00:00:00 | DIRECT CREDIT SQUARE AU PTY LT    [PHONE] |  | 241.78 | 9199.71 | SQ
2023-06-19 00:00:00 | OSKO PAYMENT   [NAME] | 28 |  | 9171.71 | REIMB
19 Jun | OSKO PAYMENT   [NAME] auskick canteen 8/6 | 51.2 |  | 9120.51 | REIMB
19 Jun | OSKO PAYMENT   [NAME] auskick dinner 15/6 | 61.59 |  | 9058.92 | REIMB
22 Jun | DIRECT CREDIT KIRSTI WILSON       [PHONE] |  | 50 | 9108.92 | OTH+ | Dayman family fees
23 Jun | OSKO PAYMENT   KIRSTI WILSON Thursday canteen dayman family |  | 37 | 9145.92 | OTH+
23 Jun | DIRECT CREDIT SQUARE AU PTY LT    [PHONE] |  | 155.36 | 9301.28 | SQ
23 Jun | OSKO PAYMENT   Zacks Commercial Art Inv 4040 - playing jumpers | 149.85 |  | 9151.43 | UNI
23 Jun | OSKO PAYMENT   [NAME] [NAME] store | 48.01 |  | 9103.42 | REIMB
26 Jun | DIRECT CREDIT SQUARE AU PTY LT    [PHONE] |  | 137.18 | 9240.6 | SQ
Transaction totals / Closing balance |  | 510.66 | 1177.49 | 9240.6
Spreadsheet: 328460d1403901666-complex-if-formula-using-timestamp-allocation-of-meal-tickets-edit
Sheet: Aug 14

 | Allocation of Meal Tickets
Time Stamp for Formatting | Ticket No: | Name of person ticket issued to | Ticket holders name | Quantity | Course and Code | Date Required | Budget Code | signed by (receptionist)
 | ie MAY01 | [NAME] | ie Student X / [NAME] | x1 | Specials [NAME] | 1st May 2013 | RTJ | F Sewell |  |  |  |  | Cost Centre: |  |  |  |  | Cost Centre:
 |  |  |  |  |  |  |  |  |  | Lunch Only |  |  | Authorised By: |  | Lunch Only |  |  | Authorised By:
 |  |  |  |  |  |  |  |  |  | Date Valid: |  |  |  |  | Date Valid:
 |  |  |  |  |  |  |  |  |  | Course: |  |  |  |  | Course:
 |  |  |  |  |  |  |  |  |  | Name: |  |  | Number: |  | Name: |  |  | Number:
 |  |  |  |  |  |  |  |  |  |  |  |  | Cost Centre: |  |  |  |  | Cost Centre:
 |  |  |  |  |  |  |  |  |  | Lunch Only |  |  | Authorised By: |  | Lunch Only |  |  | Authorised By:
 |  |  |  |  |  |  |  |  |  | Date Valid: |  |  |  |  | Date Valid:
 |  |  |  |  |  |  |  |  |  | Course: |  |  |  |  | Course:
 |  |  |  |  |  |  |  |  |  | Name: |  |  | Number: |  | Name: |  |  | Number:
 |  |  |  |  |  |  |  |  |  |  |  |  | Cost Centre: |  |  |  |  | Cost Centre:
 |  |  |  |  |  |  |  |  |  | Lunch Only |  |  | Authorised By: |  | Lunch Only |  |  | Authorised By:
 |  |  |  |  |  |  |  |  |  | Date Valid: |  |  |  |  | Date Valid:
 |  |  |  |  |  |  |  |  |  | Course: |  |  |  |  | Course:
 |  |  |  |  |  |  |  |  |  | Name: |  |  | Number: |  | Name: |  |  | Number:
 |  |  |  |  |  |  |  |  |  |  |  |  | Cost Centre: |  |  |  |  | Cost Centre:
 |  |  |  |  |  |  |  |  |  | Lunch Only |  |  | Authorised By: |  | Lunch Only |  |  | Authorised By:
 |  |  |  |  |  |  |  |  |  | Date Valid: |  |  |  |  | Date Valid:
 |  |  |  |  |  |  |  |  |  | Course: |  |  |  |  | Course:
 |  |  |  |  |  |  |  |  |  | Name: |  |  | Number: |  | Name: |  |  | Number:
 |  |  |  |  |  |  |  |  |  |  |  |  | Cost Centre: |  |  |  |  | Cost Centre:
 |  |  |  |  |  |  |  |  |  | Lunch Only |  |  | Authorised By: |  | Lunch Only |  |  | Authorised By:
 |  |  |  |  |  |  |  |  |  | Date Valid: |  |  |  |  | Date Valid:
 |  |  |  |  |  |  |  |  |  | Course: |  |  |  |  | Course:
 |  |  |  |  |  |  |  |  |  | Name: |  |  | Number: |  | Name: |  |  | Number:
 |  |  |  |  |  |  |  |  |  |  |  |  | Cost Centre: |  |  |  |  | Cost Centre:
 |  |  |  |  |  |  |  |  |  | Lunch Only |  |  | Authorised By: |  | Lunch Only |  |  | Authorised By:
 |  |  |  |  |  |  |  |  |  | Date Valid: |  |  |  |  | Date Valid:
 |  |  |  |  |  |  |  |  |  | Course: |  |  |  |  | Course:
 |  |  |  |  |  |  |  |  |  | Name: |  |  | Number: |  | Name: |  |  | Number:
 |  |  |  |  |  |  |  |  |  |  |  |  | Cost Centre:
 |  |  |  |  |  |  |  |  |  | Lunch Only |  |  | Authorised By:
 |  |  |  |  |  |  |  |  |  | Date Valid:
 |  |  |  |  |  |  |  |  |  | Course:
 |  |  |  |  |  |  |  |  |  | Name: |  |  | Number:
Spreadsheet: 836348d1689287700-trying-to-sum-case-duration-minutes-by-hour-case-minutes
Sheet: Sheet1

 |  |  | Minutes Used Each Hour
Case Begins | Case Ends | 00:00:00 | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00
01:38:00 | 04:15:00 | 0 | 22 | 60 | 60 | 15
23:45:00 | 01:23:00 | 60 | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
Spreadsheet: 43955d1242640912-excel-2007-seperate-shees-and-summary-example-sheets-summary
Sheet: Fred

 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Month Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 836881d1689695221-data-transformation-power-query-data-into-the-one-record
Sheet: After

Name | Subject1 | Date1 | Session1 | Subject2 | Date2 | Session2 | Subject3 | Date3 | Session3 | Subject4 | [NAME] | Session4
[NAME] | Math | 2023-07-14 00:00:00 | 1 | English | 2023-07-11 00:00:00 | 2 | Drama | 2023-07-11 00:00:00 | 1
[NAME] | Math | 2023-07-15 00:00:00 | 1 | English | 2023-07-15 00:00:00 | 2 | Drama | 2023-07-13 00:00:00 | 1 | Science | 2023-07-13 00:00:00 | 3
Name | Subject 1 | Date 1 | Session 1 | Subject 2 | Date 2 | Session 2 | Subject 3 | Date 3 | Session 3 | Subject 4 | Date 4 | Session 4
[NAME] | Math | 2023-07-14 00:00:00 | 1 | English | 2023-07-11 00:00:00 | 2 | Drama | 2023-07-11 00:00:00 | 1
[NAME] | Math | 2023-07-15 00:00:00 | 1 | English | 2023-07-15 00:00:00 | 2 | Drama | 2023-07-13 00:00:00 | 1 | Science | 2023-07-13 00:00:00 | 3
Spreadsheet: 860705d1708700134-populate-from-another-sheet-with-duplicates-book1-version-1-
Sheet: Sheet3

Customer # | Customer Name | Product name | [NAME] (lbs) | [NAME] (kgs)
3001 |  | Carton | 150 | 68.03893641534596
3004
2918 |  | Large Carton | 5000 | 2267.964547178199
2714
Spreadsheet: 63778d1264636878-excel-2007-count-repeat-names-count_names_v2
Sheet: 214th Master List

NO SHOW MASTER LIST |  |  | Total for PT
DATE | [NAME]'S NAME | TIME
2010-01-04 00:00:00 | DOE, [NAME] | 1110
2010-01-04 00:00:00 | DOE, [NAME] | 1100
2010-01-04 00:00:00 | CARR, JANICE | 1310
2009-01-05 00:00:00 | DOUGLAS, [NAME] | 1010
2009-01-05 00:00:00 | CHRISTOPHER, SUE | 0820
2010-01-12 00:00:00 | [NAME], BONNIE | 1400
2010-01-12 00:00:00 | BIBBEE, JERRY | 1310
2010-01-12 00:00:00 | GREENFIELD, [NAME] | 0830
2010-01-12 00:00:00 | THOMPSON, CATHERINE | 0840
2010-01-12 00:00:00 | COWGER, MATHEW | 1000
2010-01-12 00:00:00 | SHANNON, GEORGE | 1130
2010-01-12 00:00:00 | CISTRUNK, REPEAT | 1300
2010-01-13 00:00:00 | [NAME], RENEE | 1130
2010-01-14 00:00:00 | BLADE, RYAN | 1440
2010-01-14 00:00:00 | LINDSTROM, DANIEL | 0810
2010-01-14 00:00:00 | ERB, RONALD | 1120
2010-01-14 00:00:00 | HANSON, [NAME] | 0920
2010-01-14 00:00:00 | CURRY, JOE | 0930
2010-01-14 00:00:00 | THOMPSON, CATHERINE | 1100
2010-01-14 00:00:00 | HAAN, [NAME] | 1420
2010-01-19 00:00:00 | BOURQUE, MICHELLE | 0920
2010-01-21 00:00:00 | SHAFER, JOHN | 0930
2010-01-21 00:00:00 | THOMPSON, CATHERINE | 1030
2010-01-21 00:00:00 | CARR, JANICE | 0820
2010-01-21 00:00:00 | BIBBEE, JERRY | 0920
2010-01-21 00:00:00 | CISTRUNK, REPEAT | 1640
2010-01-22 00:00:00 | TRUAX, DERRICK | 0820
2010-01-25 00:00:00 | MCKITTRICK, CHRISTOPHER | 1540
2010-01-25 00:00:00 | CISTRUNK, REPEAT | 1010
2010-01-26 00:00:00 | SHANNON, BILLY | 0932
2010-01-26 00:00:00 | GREENFIELD, DANIEL | 0936
2010-01-26 00:00:00 | DOE, [NAME] | 0938
2010-01-26 00:00:00 | [NAME], RENEE | 1000
2010-01-26 00:00:00 | BIBBEE, JERRY | 1123
Spreadsheet: 135321d1325930142-conditional-formatting-2003-more-that-three-conditions-not-vba-custom-format
Sheet: Sheet1

 | [NAME] | Cell Entry | How it Appears
Using text
 | #,##0 "US Dollars" | 1500 | 1500
 | "Answer: "General | 1500 | 1500
 | "The amount is "#,##0" dollars" | 1500 | 1500
Scaling large numbers
 | #,##0, | 123456789 | 123456789
 | #,##0, | 12345678912 | 12345678912
 | #,##0, | 1234 | 1234
Data Validation
 | 0.00;"Positive numbers only!" | 123 | 123
 | 0.00;"Positive numbers only!" | -123 | -123
 | 0.00;"Positive numbers only!" | 0 | 0
Zero with Dashes
 | #,##0_);(#,##0);-0-_) | 0 | 0
 | #,##0_);(#,##0);-0-_) | 12.2 | 12.2
 | #,##0_);(#,##0);-0-_) | -12 | -12
Telephone Numbers
 | (###) ###-### | 8005551212 | 8005551212
 | ###"/"###-#### | 8005551212 | 8005551212
Social Security Numbers
 | ###-##-#### | 421897322 | 421897322
 | SSN ###-##-#### | 421897322 | 421897322
Date Formats
 | mmmm-yy | 1995-06-01 00:00:00 | 1995-06-01 00:00:00 |  | 2011-12-15 00:00:00
 | mmmm d, yyyy | 1995-06-01 00:00:00 | 1995-06-01 00:00:00
 | dddd | 1995-06-01 00:00:00 | 1995-06-01 00:00:00
 | mmmm d, yyyy (dddd) | 1995-06-01 00:00:00 | 1995-06-01 00:00:00
 | "It's" dddd | 1995-06-01 00:00:00 | 1995-06-01 00:00:00
Different colors and formatting
 | [Red][<1]0.0%;[Blue][>=1]#,##0;General | 1 | 1
 | [Red][<1]0.0%;[Blue][>=1]#,##0;General | -1 | -1
 | [Red][<1]0.0%;[Blue][>=1]#,##0;General | 45 | 45
 | General;General;General;[Red]General | Only text is red | Only text is red
 | General;General;General;[Red]General | 234 | 234
Special symbols
 | ©General | 1994 | 1994
 | General;General;General;General® | Registered | Registered
 | General;General;General;General™ | Coca-Cola | Coca-Cola
 | General;General;General;“General” | Text in quotes | Text in quotes
 | General;General;General;“General” | 123 | 123
Descriptive | Positive;"Negative";"Zero";"Text" | 12 | 12
 | Positive;"Negative";"Zero";"Text" | -32 | -32
 | Positive;"Negative";"Zero";"Text" | 0 | 0
 | Positive;"Negative";"Zero";"Text" | Hello | Hello
Hidden | ;;; | 1234 | 1234
 | ;;; | -145 | -145
Conditional |  |  | 99
 | [>100]#,000;;; | 99 | 99
 | [>100]#,000;;; | 102 | 102
 | [>100]#,000;;; | -54 | -54
 | [>100]#,000;;; | Hello | Hello
Spreadsheet: 736363d1623547539-monthly-unearned-revenue-unearned-revenue-ws
Sheet: DR Worksheet (2)

Unearned Revenue Worksheet
Customer | Invoice # | Invoice Amount | Invoice Date | Service Starting Date | Service Ending Date | Subcriptions | 2021-01-21 00:00:00 | 2021-02-21 00:00:00 | 2021-03-21 00:00:00 | 2021-04-21 00:00:00 | 2021-05-21 00:00:00 | 2021-06-21 00:00:00 | 2021-07-21 00:00:00 | 2021-08-21 00:00:00 | 2021-09-21 00:00:00 | 2021-10-21 00:00:00 | 2021-11-21 00:00:00 | 2021-12-21 00:00:00 | Unearned Revenue to date 2021 | Unearned Revenue Balance | 2021-01-22 00:00:00 | 2021-02-22 00:00:00 | 2021-03-22 00:00:00 | 2021-04-22 00:00:00 | 2021-05-22 00:00:00 | 2021-06-22 00:00:00
Amazon | 123 | 15000 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 12 Months | 1250
Bell Canada | 456 | 25000 | 2021-04-01 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 3 Months |  |  |  |  | 8333.33 | 8333.34
Financial Times | 789 | 12000 | 2021-03-01 00:00:00 | 2021-03-01 00:00:00 | 2022-03-01 00:00:00 | 12 Months |  |  |  | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 |  |  | 1000 | 1000
Step 1 - Determine how many periods between the service starting date and ending date.
Step 2 - Divide the number of periods by the invoice amount to arrive at the monthly revenue.
TOTAL
Spreadsheet: 56303988-b96b-416b-838c-7c7639ec930b
Sheet: Page 19

Permit No.: |  |  | WQ0028552 |  |  | Facility Name: |  | Briar Chapel Development |  |  |  |  |  | County: | Chatham |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | E-2A |  | Field Name: |  | E-3A |  | Field Name: |  | E-3B |  | Field Name: |  | E-3C
 |  |  |  |  |  | Area (acres): |  | 9 |  | Area (acres): |  | 0.8 |  | Area (acres): |  | 2.2 |  | Area (acres): |  | 3.5
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.1 |  | [NAME] (in): |  | 0.1 |  | [NAME] (in): |  | 0.1 |  | [NAME] (in): |  | 0.1
 |  |  |  |  |  | Annual Rate (in): |  | 37.31 |  | Annual Rate (in): |  | 19.95 |  | Annual Rate (in): |  | 19.95 |  | Annual Rate (in): |  | 37.31
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 220955d1363326095-please-help-max-function-with-multiple-criteria-mortgage
Sheet: Sheet2

Years
Mortgage 15 20 25 30 35 | 15 | 20 | 25 | 30 | 35
250000 | 1830.48 | 1495.26 | 1298.97 | 1172.02 | 1084.56
260000 | 1903.7 | 1555.07 | 1350.93 | 1218.9 | 1127.94
270000 | 1976.92 | 1614.89 | 1402.89 | 1265.78 | 1171.32
280000 | 2050.14 | 1674.7 | 1454.85 | 1312.66 | 1214.7
290000 | 2123.36 | 1734.51 | 1506.81 | 1359.54 | 1258.09
300000 | 2196.58 | 1794.32 | 1558.77 | 1406.42 | 1301.47
310000 | 2269.8 | 1854.13 | 1610.73 | 1453.31 | 1344.85
320000 | 2343.02 | 1913.94 | 1662.69 | 1500.19 | 1388.23
330000 | 2416.24 | 1973.75 | 1714.65 | 1547.07 | 1431.61
340000 | 2489.46 | 2033.56 | 1766.61 | 1593.95 | 1475
350000 | 2562.68 | 2093.37 | 1818.56 | 1640.83 | 1518.38
Maximum Affordable Monthly Payment $1,500
# years Max. Mortgage |  |  | 1500
15
20 | 250000
25 | 280000
30 | 310000
35 | 340000
Spreadsheet: darrell_schoolcraft__7552__0202 NNG Lamar Nomination
Sheet: 02-(26-31)

 |  |  |  | Time/Date
 |  |  |  | Beginning Gas Day: | 2002-02-26 00:00:00
 |  |  |  | Ending Gas Day: | 2002-02-28 00:00:00
 |  | [NAME] |  |  | 45000
 |  | Hour
 |  | Ending | [NAME] | Accumulated | Remaining | Daily Burn
 |  | CST |  |  |  | Rate
 |  | 10 | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 600
 |  |  | 600
 |  | 1 | 600
 |  | 2 | 600
 |  |  | 600
 |  |  | 600
 |  |  | 600
 |  |  | 800
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
Spreadsheet: 819375d1677475467-formula-to-get-monthly-total-from-full-data-sheet-ytdsalessummary
Sheet: Jan

 |  |  | Jan
 |  |  |  |  | YTD
 |  |  | Beverage
 |  |  | Cakes
 |  |  | Food
 |  |  | Novelties
 |  |  | SoftServe
 |  |  | NetSales
Spreadsheet: benjamin_rogers__1049__Consolidated 6 Peaker-051800-PE
Sheet: Wheatland

INCOME STATEMENT - WHEATLAND
('000 $)
Revenue
Fixed Price Period: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Demand Payment
Energy Payment
Start Charge
Amortization of Power Contract
Merchant Period:
Demand Payment | 0 | 0 | 0
Variable Revenue | 0 | 0 | 0
Interest Income
Total Revenue
Expense
Fixed O&M
Variable O&M
Major [NAME]
O&M Management Fee
Owner's Expense
Property Taxes Liability | 0 | 117.987 | 216.843 | 295.985 | 346.251 | 468.657 | 641.059 | 753.232 | 765.3 | 699.258 | 854.333 | 854.3 | 854.3 | 854.3 | 854.3 | 854.3 | 854.3 | 854.3 | 854.3 | 854.3
Franchise Tax | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
EBT
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
After Tax Book Income
CASH FLOW - WHEATLAND
('000 $) | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check
EBITDA less Amortization of Power Contract
Plus Property Tax Liability
Less Property Tax Expense | -203.273
Debt Service
Pre Tax Cash Flow
State Cash Taxes Benefit (Expense)
Federal Cash Taxes Benefit (Expense)
After Tax Cash Flow
STATE TAX & SUPPLEMENTAL TAX - WHEATLAND
 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
('000 $) | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
SUPPLEMENTAL TAXES
Adjusted Gross Income Tax
Pretax Book Income less Amortization of Power Contract
Adjusted Gross Income Rate
State Adjusted Gross Income Tax
State Gross Receipts Taxes
Gross Receipts less Amortization pf Power Contract
Gross Receipts Tax Rate
Gross Receipts Tax Liability
Greater of Adjusted or Gross Receipts
STATE TAXES
Pretax Book Income less Amortization of Power Contract
Plus Book Depreciation & Amortization
Less Tax Depreciation
State Taxable Income
State Income Tax Rate
Current State Income Tax Expense (Benefit)
Beginning NOL's | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
New NOL's
Expired NOL's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NOL Utilization
Ending NOL's
Total State Taxes Utilizing NOLs
Total State & Misc. Taxes
Spreadsheet: 118527d1313748578-count-mb-value-when-date-is-the-same-book1
Sheet: Sheet1

2011-08-11 00:00:00 | 2011-08-12 00:00:00 | 71276973 | R | MB
2011-08-11 00:00:00 | 2011-08-12 00:00:00 | 71278662 | R | MB
2011-08-11 00:00:00 | 2011-08-12 00:00:00 | 71277630 | R | MB
2011-08-11 00:00:00 | 2011-08-12 00:00:00 | 71279132 | R | MB
2011-08-11 00:00:00 | 2011-08-12 00:00:00 | 71278069 | R | MB
2011-08-11 00:00:00 | 2011-08-12 00:00:00 | 71277940 | R | MB
2011-08-12 00:00:00 | 2011-08-12 00:00:00 | 71279484 | R | MB
2011-08-12 00:00:00 | 2011-08-12 00:00:00 | 71278913 | R | MB
2011-08-12 00:00:00 | 2011-08-12 00:00:00 | 71279009 | R | MB
2011-08-12 00:00:00 | 2011-08-12 00:00:00 | 71278771 | R | MB
2011-08-12 00:00:00 | 2011-08-12 00:00:00 | 71278843 | R | MB
2011-08-12 00:00:00 | 2011-08-12 00:00:00 | 71278924 | R | MB
2011-08-12 00:00:00 | 2011-08-16 00:00:00 | 71280015 | R | MB
2011-08-12 00:00:00 | 2011-08-16 00:00:00 | 71278729 | R | MB
2011-08-12 00:00:00 | 2011-08-16 00:00:00 | 71279069 | R | MB
2011-08-12 00:00:00 | 2011-08-16 00:00:00 | 71277897 | R | MB
2011-08-16 00:00:00 | 2011-08-16 00:00:00 | 71279488 | R | MB
2011-08-16 00:00:00 | 2011-08-16 00:00:00 | 71279166 | R | MB
2011-08-16 00:00:00 | 2011-08-16 00:00:00 | 71279870 | R | MB
2011-08-16 00:00:00 | 2011-08-16 00:00:00 | 71279982 | R | MB
2011-08-16 00:00:00 | 2011-08-16 00:00:00 | 71278747 | R | MB
2011-08-16 00:00:00 | 2011-08-16 00:00:00 | 71280080 | R | MB
2011-08-16 00:00:00 | 2011-08-16 00:00:00 | 71279524 | R | MB
2011-08-16 00:00:00 | 2011-08-16 00:00:00 | 71279974 | R | MB
2011-08-12 00:00:00 | 2011-08-16 00:00:00 | 71279770 | R | MB
2011-08-16 00:00:00 | 2011-08-16 00:00:00 | 71278174 | R | MB
2011-08-16 00:00:00 | 2011-08-17 00:00:00 | 71280445 | R | MB
2011-08-16 00:00:00 | 2011-08-17 00:00:00 | 71280965 | P | MB
2011-08-16 00:00:00 | 2011-08-17 00:00:00 | 71280472 | R | MB
2011-08-16 00:00:00 | 2011-08-17 00:00:00 | 71280353 | P | MB
2011-08-16 00:00:00 | 2011-08-17 00:00:00 | 71280397 | P | MB
2011-08-16 00:00:00 | 2011-08-17 00:00:00 | 71278579 | P | MB
Spreadsheet: darron_c_giron__8029__Sched_C Form
Sheet: Schedule C

SCHEDULE C
DOCUMENTATION FORM
ITEM |  | DATA
Transaction or Book Name |  | GD-NEW
Amount |  | 64200000
Entry Date |  | 2000-11-21 00:00:00
Reason for Using Schedule C (e.g., income adjustment) |  | Liquidity risk due to West positions
Removal Date
(If amortization is required, attach the appropriate
amortization schedule)
Methodology for Removal (e.g., amortization or one time removal)
Individual Using Schedule
Trader/Structuring |  | Business Analysis & Reporting
Energy Operations |  | [NAME]
Spreadsheet: 033d4855-ec7b-4602-8b8c-aaab9c75b6fc
Sheet: 12c

Product | AUD* | CAD | CHF | DKK | KRW | NOK | NZD | SEK | ZAR | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated swap dollar volumes, week ending February 1, by product type and major currency (value of all trades in millions of USD), cleared swaps only, all participant types and tenors.  Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].