tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 863527d1710973548-formula-to-subtotal-values-based-on-multiple-criteria-example-data
Sheet: Example Data

EXAMPLE DATA
Type | Invoice # | Date Sold | Product ID | Trade | Trade STE | GM | GM% | AGMNT
New | 5618089 | 2024-02-15 00:00:00 | 355391 |  |  | 258.12 | 0.1475 | 0
Used | 5617567 | 2024-02-15 00:00:00 | 1039133 |  |  | 3950 | 0.0195 | 0
New | 5617537 | 2024-02-15 00:00:00 | 353470 |  |  | 7672.08 | 0.1311 | 0
New | 5617558 | 2024-02-15 00:00:00 | 350402 |  |  | 1788.47 | 0.0727 | 0
New | 5617558 | 2024-02-15 00:00:00 | 350816 | 1039242 | Not Loaded | 9360.19 | 0.0736 | 0
New | 5617558 | 2024-02-15 00:00:00 | 350401 |  |  | 12044.12 | 0.0339 | 0
New | 5617574 | 2024-02-15 00:00:00 | 342146 |  |  | 805.02 | 0.0969 | 0
New | 5617558 | 2024-02-15 00:00:00 | 350397 | 1039133 |  | 11414.49 | 0.022 | 0
New | 5617971 | 2024-02-15 00:00:00 | 355595 |  |  | 861.92 | 0.1326 | 0
New | 5607276 | 2024-02-01 00:00:00 | 357231 |  |  | 2798 | 0.1003 | 0
New | 5607109 | 2024-01-31 00:00:00 | 351606 |  |  | 3052.44 | 0.1135 | 0
New | 5607109 | 2024-01-31 00:00:00 | 351605 | 1039264 | Not Loaded | 336.71 | 0.0125 | 0
New | 5607074 | 2024-01-31 00:00:00 | 342967 | 1039254 |  | 887.74 | 0.074 | 0
New | 5607072 | 2024-01-31 00:00:00 | 350354 |  |  | 3387.95 | 0.1189 | 0
New | 5607070 | 2024-01-31 00:00:00 | 341332 |  |  | 823.46 | 0.071 | 0
New | 5606782 | 2024-01-31 00:00:00 | 344628 |  |  | 99.81 | 0.1597 | 0
New | 5606734 | 2024-01-31 00:00:00 | 356094 |  |  | 102.25 | 0.1203 | 0
Used | 5606724 | 2024-01-31 00:00:00 | 1038779 | 1039253 | Not Loaded | 1818.79 | 0.0353 | 0
Used | 5606722 | 2024-01-31 00:00:00 | 1038600 |  |  | 1435.63 | 0.0122 | 0
New | 5606713 | 2024-01-31 00:00:00 | 355723 |  |  | 252.41 | 0.2103 | 0
Used | 5606662 | 2024-01-31 00:00:00 | 1038159 | 1038978 | Not Loaded | 529.95 | 0.0321 | 0
New | 5606642 | 2024-01-31 00:00:00 | 351584 |  |  | 502.83 | 0.0739 | 0
Used | 5603703 | 2024-01-26 00:00:00 | 1031042 |  |  | 267.07 | 0.178 | 0
New | 5603692 | 2024-01-26 00:00:00 | 343710 |  |  | 1194.17 | 0.0412 | 697
New | 5603638 | 2024-01-26 00:00:00 | 318300 |  |  | 200 | 0.277 | 0
Used | 5603638 | 2024-01-26 00:00:00 | 1038987 | 10392191039220 | Not Loaded | 2368.12 | 0.0474 | 0
New | 5603638 | 2024-01-26 00:00:00 | 301735 |  |  | 777 | 0.9987 | 0
Used | 5603632 | 2024-01-26 00:00:00 | 1036646 |  |  | 2738.74 | 0.2883 | 0
New | 5603166 | 2024-01-25 00:00:00 | 345726 |  |  | 2230.41 | 0.1716 | 0
New | 5603160 | 2024-01-25 00:00:00 | 355727 |  |  | 4573.7 | 0.1307 | 0
New | 5603152 | 2024-01-25 00:00:00 | 333590 | 1039231 | Not Loaded | 2886 | 0.0411 | 0
New | 5603152 | 2024-01-25 00:00:00 | 337925 |  |  | 486.64 | 0.0559 | 0
Used | 5596758 | 2024-01-11 00:00:00 | 1037585 |  |  | 9953.62 | 0.024 | 0
New | 5596717 | 2024-01-11 00:00:00 | 350012 | 10386591038660 | Not Loaded | 847.47 | 0.1011 | 716
New | 5596717 | 2024-01-11 00:00:00 | 350013 |  |  | -229.66 | -0.1699 | 0
New | 5596707 | 2024-01-11 00:00:00 | 339992 |  |  | 444.4 | 0.2469 | 0
New | 5596613 | 2024-01-10 00:00:00 | 337963 |  |  | 2478.98 | 0.0472 | 0
 |  |  |  |  |  | Total GM for invoices with Trade STE "Not Loaded"
 |  |  |  |  |  | Should = | 36266.24
Spreadsheet: 599636d1543233038-multiple-criteria-ranking-help-needed-multiple-criteria-ranking
Sheet: Sheet1

D | E | F | Rank
46 | 3 | 3
45 | 5 | 3
44 | 4 | 12
42 | 2 | 9
56 | 1 | 17
64 | 3 | 17
23 | 3 | 17
64 | 5 | 17
Spreadsheet: 672826d1587034920-how-to-set-formula-to-select-top-5-student-based-on-their-result-example
Sheet: Sheet1

 |  |  | Student Name | Test 1 Point | Test 2 Point | Total | Status
 |  |  | Name 1 | 10 | 10 |  | Selected
 |  |  | Name 2 | 8 | 8 |  | Selected
 |  |  | Name 3 | 10 | 3 |  | X
 |  |  | Name 4 | 10 | 8 |  | Selected
 |  |  | Name 5 | 5 | 10 |  | X
 |  |  | Name 6 | 9 | 2 |  | X
 |  |  | Name 7 | 7 | 6 |  | X
 |  |  | Name 8 | 7 | 7 |  | X
 |  |  | Name 9 | 9 | 8 |  | Selected
 |  |  | Name 10 | 10 | 9 |  | Selected
 |  |  | Top 5 will be selected
Spreadsheet: 0d4b54c2-d3c2-47bc-ad03-a83a1f8c9ded
Sheet: Sheet1

STATE REPRESENTATIVES - BELKNAP COUNTY | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
District No. 29 (3) | Ahern, Jr., r | Laflam, r | Wendelboe, r | Dodge, d | [NAME], d | Reichstein, d | Warner, d
Center Harbor | 152 | 154 | 169
New Hampton | 145 | 150 | 234 |  |  |  |  | 6
Sanbornton | 274 | 239 | 258 |  |  | 1 |  | 3
[NAME] | 200 | 220 | 259 | 5 |  |  |  | 5
TOTALS | 771 | 763 | 920 | 5 |  | 1 |  | 14
District No. 30 (7) | Dewhirst, r | Fitzgerald, r | Flanders, r | Holbrook, r | Lawton, r | Nedeau, r | [NAME], r
[NAME] | 440 | 500 | 495 | 532 | 493 | 463 | 481
[NAME] | 229 | 227 | 236 | 274 | 246 | 221 | 249
[NAME] 3 | 220 | 260 | 262 | 262 | 237 | 221 | 243
[NAME] | 187 | 207 | 259 | 264 | 185 | 185 | 213
[NAME] | 127 | 133 | 123 | 136 | 116 | 113 | 130
[NAME] 6 | 233 | 230 | 245 | 255 | 232 | 229 | 254
Meredith | 599 | 633 | 638 | 618 | 792 | 890 | 630
TOTALS | 2035 | 2190 | 2258 | 2341 | 2301 | 2322 | 2200
District No. 31 (8) | Akstin, r | Allen, r | [NAME], r | Boyce, r | [NAME], r | DeForrest, r | Pilliod, r
Alton | 203 | 391 | 545 | 535 | 245 | 192 | 329
Barnstead | 276 | 322 | 242 | 292 | 206 | 124 | 132
Belmont | 192 | 342 | 498 | 379 | 307 | 143 | 509
Gilford | 216 | 544 | 732 | 654 | 631 | 248 | 673
Gilmanton | 117 | 262 | 278 | 291 | 211 | 113 | 295
TOTALS | 1004 | 1861 | 2295 | 2151 | 1600 | 820 | 1938
District No. 31 (8) | [NAME], r | Showers, Jr., r | [NAME], r | Waters, r | [NAME], r
Alton | 555 | 221 | 465 | 286 | 459
Barnstead | 262 | 198 | 185 | 229 | 207
Belmont | 320 | 166 | 475 | 288 | 371
Gilford | 547 | 136 | 581 | 388 | 707
Gilmanton | 402 | 97 | 228 | 189 | 239
TOTALS | 2086 | 818 | 1934 | 1380 | 1983
Spreadsheet: 89992d1289752986-part-of-formula-returning-wrong-results-excel-example
Sheet: Sheet1

AVERNA,[NAME]
Corn,Marlin
[NAME],ROBERT H
CATANESE,SALVATORE J & OLGA M
JIMENEZ,ALEJANDRO & HILDA M
Corn,Marlin
Hernara,Harry & Marie Anne Martin
White,Alex & John M
[NAME],[NAME]
[NAME]Harry & Marie Anne
[NAME],Harry & Marie Anne
HernaraMartin,Harry & Marie Anne
MartinHernara,Harry & Marie Anne
Martin,Harry & Marie Anne Hernara
CORNWALL,A ROBERT & CORNWALL,ANNA
HernaraMartin,Harry & Marie Anne & Ann Sally
HernaraMartin,Harry & Marie  & Ann Sally
HernaraMartin,Harry & Cortes,[NAME]
HernaraMartin,Harry & Smith,Marie Anne & Jenners,[NAME]
[NAME]
HernaraMartin,Harry & Marie,Anne & Ann Sally
KNUD J & MARIA L HOSTRUP
RAFIK RAYES & HODA TABAR
PRIMEAU,I & PRIMEAU,JANETTE
Spreadsheet: 90068d1289830006-excel-2007-dsum-question-referralsreceived2-example
Sheet: Sheet1

City | Response | Number
1 | Yes | 1
2 | No | 1
3 | Yes | 1
1 | No | 1
2 | Yes | 1
3 | No | 1
1 | Yes | 1
2 | No | 1
3 | Yes | 1
1 | Yes | 1
2 | Yes | 1
3 | Yes | 1
1 | No | 1
2 | No | 1
3 | No | 1
1 | No | 1
2 | Yes | 1
3 | Yes | 1
1 | Yes | 1 |  |  |  | City | City | City
2 | No | 1 |  |  |  | 1 | 2 | 3
3 | Yes | 1
1 | No | 1
2 | Yes | 1
3 | No | 1
1 | Yes | 1
2 | No | 1
3 | Yes | 1
2 | Yes | 1
1 | Yes | 1
1 | Yes | 1
1 | yes | 1
2 | no | 1
Spreadsheet: 300459d1393480245-help-making-data-more-efficient-pv-formula
Sheet: Sheet1

Periods | Coupon Rate | Face Value | Yield to Maturity | Years to Maturity | Payment Frequency | Present Value
0 | 0.0625 | 1000 | 0.0425 | 30 | 2
1 | 0.0625 | 1000 | 0.0425 |  | 2
2 | 0.0625 | 1000 | 0.0425 |  | 2
3 | 0.0625 | 1000 | 0.0425 |  | 2
4 | 0.0625 | 1000 | 0.0425 |  | 2
5 | 0.0625 | 1000 | 0.0425 |  | 2
6 | 0.0625 | 1000 | 0.0425 |  | 2
7 | 0.0625 | 1000 | 0.0425 |  | 2
8 | 0.0625 | 1000 | 0.0425 |  | 2
9 | 0.0625 | 1000 | 0.0425 |  | 2
10 | 0.0625 | 1000 | 0.0425 |  | 2
11 | 0.0625 | 1000 | 0.0425 |  | 2
12 | 0.0625 | 1000 | 0.0425 |  | 2
13 | 0.0625 | 1000 | 0.0425 |  | 2
14 | 0.0625 | 1000 | 0.0425 |  | 2
15 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
 | 0.0625 | 1000 | 0.0425 |  | 2
Spreadsheet: 22967d1212198513-identify-missing-values-test
Sheet: Sheet1

# | ABC | A | B | C
1 | C
2 | B
3 | B
4 | C
5 | C
6 | B | 0 | 2 | 3 | If A, B, or C not present in #1-5, then display not present value here
7 | C | 0 | 3 | 2 | If A, B, or C not present in #2-6, then display not present value here
8 | A | 0 | 2 | 3 | If A, B, or C not present in #3-7, then display not present value here
9 | C | 1 | 1 | 3 | If A, B, or C not present in #4-8, then display not present value here
10 | C | 1 | 1 | 3
11 | A | 1 | 1 | 3
12 | A | 2 | 0 | 3
13 | A | 3 | 0 | 2
14 | B | 3 | 0 | 2
15 | A | 3 | 1 | 1
16 | A | 4 | 1 | 0
17 | C | 4 | 1 | 0
18 | C | 3 | 1 | 1
19 | B | 2 | 1 | 2
20 | C | 2 | 1 | 2
Spreadsheet: 766227d1643813150-multiple-if-statement-that-contains-a-search-and-lookup-element-test-1
Sheet: Raw1

PAC Job | Title | Job Type | Product Code
S167222 | [NAME] | AMD | DO - Door
[NAME] | [NAME] | NTR | BQ - PVC-U Barge, Facia or Soffit Board
S265086 | sdsdsssdsdsssssssssssssssssssssssssssss | NTR | LP - PVC-U Cladding
S266193 | sdsdsssdsdsssssssssssssssssssssssssssss | REV | AF - Window and Door Hardware
S266224 | DFDF | STD | AW - Window & Door Accessories
S266605 | sdsdsssdsdsssssssssssssssssssssssssssss00/3665 | RVA | AW - Window & Door Accessories
S264890 | sdsdsssdsdsssssssssssssssssssssssssssss | ASS | WZ - Window Fabricators
S266803 | DFDF | STD | AF - Window and Door Hardware
S267009 | DFDF00/3675 | REV | RO - Rooflight
S266559 | DFDF | REV | AF - Window and Door Hardware
S167349 | DFDF | WER | WQ - A PVC-U system supplier that also fabricates
S266589 | sdsdsssdsdsssssssssssssssssssssssssssss | CTC | DZ - Door Fabricator
S265525 | sdsdsssdsdsssssssssssssssssssssssssssss00/3674 | ASS | RO - Rooflight
S266358 | sdsdsssdsdsssssssssssssssssssssssssssss | APS | VC - Vapour Control Layer
S266280 | fdsff | TRE | LA - Roofing (liquid-applied)
S167072 | sdsdsssdsdsssssssssssssssssssssssssssss00/3668 | ASS | SS - Sealing Strip
S266678 | sdsdsssdsdsssssssssssssssssssssssssssss | ASS | LA - Roofing (liquid-applied)
S167195 | sdsdsssdsdsssssssssssssssssssssssssssss | REV | LA - Roofing (liquid-applied)
S266434 | sdsdsssdsdsssssssssssssssssssssssssssss | ASS | SF - Roof Tile Underlay
S266701 | DGF | TRE | LA - Roofing (liquid-applied)
S265710 | sdsdsssdsdsssssssssssssssssssssssssssss | STD | LA - Roofing (liquid-applied)
S167009 | DFDF | NTR | SF - Roof Tile Underlay
S167116 | sdsdsssdsdsssssssssssssssssssssssssssss | ASS | SF - Roof Tile Underlay
S267061 | DFDF | TRE | RP - Roofing (roll form-polymeric)
S167265 | sdsdsssdsdsssssssssssssssssssssssssssss | TRE | RT - Roofing Tile
S266355 | sdsdsssdsdsssssssssssssssssssssssssssss | TRE | SF - Roof Tile Underlay
Spreadsheet: 747625d1631620487-monthly-rental-revenue-calculation-with-rcd-and-red-date-and-different-escalation-rates-excel-formula-rent-calculation-nehal1109-
Sheet: MOD Calculation

 |  |  | 2020-01-01 00:00:00
 |  |  |  | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR
Unit | Area | RCD | RED | 2020-21 | 2021-22 | 2022-23 | 2023-24 | 2024-25 | 2025-26 | 2026-27 | 2027-28 | 2021-01-31 00:00:00 | 2021-02-28 00:00:00 | 2021-03-31 00:00:00 | 2021-04-30 00:00:00 | 2021-05-31 00:00:00 | 2021-06-30 00:00:00 | 2021-07-31 00:00:00 | 2021-08-31 00:00:00 | 2021-09-30 00:00:00 | 2021-10-31 00:00:00 | 2021-11-30 00:00:00 | 2021-12-31 00:00:00 | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00 | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00 | 2025-01-31 00:00:00 | 2025-02-28 00:00:00 | 2025-03-31 00:00:00 | 2025-04-30 00:00:00 | 2025-05-31 00:00:00 | 2025-06-30 00:00:00 | 2025-07-31 00:00:00 | 2025-08-31 00:00:00 | 2025-09-30 00:00:00 | 2025-10-31 00:00:00 | 2025-11-30 00:00:00 | 2025-12-31 00:00:00 | 2026-01-31 00:00:00 | 2026-02-28 00:00:00 | 2026-03-31 00:00:00 | 2026-04-30 00:00:00 | 2026-05-31 00:00:00 | 2026-06-30 00:00:00 | 2026-07-31 00:00:00 | 2026-08-31 00:00:00 | 2026-09-30 00:00:00 | 2026-10-31 00:00:00 | 2026-11-30 00:00:00 | 2026-12-31 00:00:00
1 | 5000 | 2020-01-01 00:00:00 | 2025-12-31 00:00:00 | 100 | 110 | 150 | 130 | 140 | 150
2 | 10000 | 2021-05-11 00:00:00 | 2025-09-10 00:00:00 | 100 | 110 | 120 | 130 | 140 | 150
Spreadsheet: 129133d1321464307-vlookup-over-multiple-sheets-copy-of-2011-barter-and-trade-test
Sheet: July

Customer | Net | [NAME] | Size | Rep
Another Broken Egg Cafe | 1 | 1 | 1/3 Page Square | [NAME]
I Jump Kids Adventure | 2 | 2 | 1/4 Page | [NAME]
Spectrum Resorts/See Beach Club | 3 | 3 | 1/2 Page | [NAME]
Red Mountain Theatre Company | 4 | 4 | 2/3 Page | [NAME]
California Pizza Kitchen | 5 | 5 | 1/2 Page | [NAME]
Crystal Springs Water Co. | 6 | 6 | 1/6 Page | [NAME]
[NAME] Center | 7 | 7 | 1/3 Page Square | [NAME]
McWane Science Center | 8 | 8 | [NAME] | [NAME]
Alabama Public Television | 9 | 9 | 1/3 Page Square | [NAME]
Books A Million | 10 | 10 | 1/3 Page Vertical | [NAME]
JAMM Entertainment Services | 11 | 11 | 1/3 Page Square | [NAME]
Meyer Real Estate | 12 | 12 | 1/3 Page Square | [NAME]
[NAME] | 13 | 13 | 1/3 Page Square | [NAME]
Al.com | 14 | 14 | 2/3 Page | [NAME]
Leukemia and Lymphoma Society- AL/ Gulf Coast Chapter | 15 | 15 | [NAME] | [NAME]
Digital Signage 3 | 16 | 16 | 1/3 Page Square | [NAME]
Birmingham Mountain Radio | 17 | 17 | [NAME] | [NAME]
[NAME] | 18 | 18 | [NAME] | [NAME]
[NAME] | 19 | 19 | [NAME] | [NAME]
Childcare Resources | 20 | 20 | [NAME] | [NAME]
Cox Radio | 21 | 21 | [NAME] | [NAME]
Cultural Alliance of Greater Birmingham - Birmingham 365 | 22 | 22 | [NAME] | [NAME]
Sidewalk Film Festival | 23 | 23 | [NAME] | [NAME]
The Birmingham News | 24 | 24 | [NAME] | [NAME]
Spreadsheet: 753129d1635262121-index-match-formula-for-duplicate-values-duplicate-index-matches-1-1-
Sheet: Date Order

Part | Due |  |  |  | Part | Due
 |  |  | Should be: |  | AG22155 | 2019-01-04 00:00:00
 |  |  |  |  | SP18475 | 2019-01-04 00:00:00
 |  |  |  |  | BX35640 | 2019-01-07 00:00:00
 |  |  |  |  | SE25509 | 2019-01-10 00:00:00
 |  |  |  |  | LS18007 | 2019-01-13 00:00:00
 |  |  |  |  | RQ33652 | 2019-01-14 00:00:00
 |  |  |  |  | DT20254 | 2019-01-17 00:00:00
 |  |  |  |  | XJ28600 | 2019-01-17 00:00:00
 |  |  |  |  | LT21272 | 2019-01-22 00:00:00
 |  |  |  |  | YV31055 | 2019-01-23 00:00:00
 |  |  |  |  | XR24765 | 2019-01-28 00:00:00
 |  |  |  |  | SI15345 | 2019-01-29 00:00:00
 |  |  |  |  | TB15510 | 2019-01-29 00:00:00
 |  |  |  |  | BK36701 | 2019-01-31 00:00:00
 |  |  |  |  | JF34904 | 2019-01-31 00:00:00
 |  |  |  |  | [NAME] | 2019-02-04 00:00:00
 |  |  |  |  | ZS11542 | 2019-02-04 00:00:00
 |  |  |  |  | XA32691 | 2019-02-06 00:00:00
 |  |  |  |  | CC20434 | 2019-02-14 00:00:00
 |  |  |  |  | GQ18803 | 2019-02-15 00:00:00
 |  |  |  |  | MW33367 | 2019-02-16 00:00:00
 |  |  |  |  | NF34465 | 2019-02-16 00:00:00
 |  |  |  |  | GD38853 | 2019-02-17 00:00:00
 |  |  |  |  | JU13976 | 2019-02-17 00:00:00
 |  |  |  |  | NR26220 | 2019-02-17 00:00:00
 |  |  |  |  | OX17453 | 2019-02-24 00:00:00
 |  |  |  |  | SG20341 | 2019-02-26 00:00:00
 |  |  |  |  | WA14608 | 2019-02-26 00:00:00
 |  |  |  |  | OS14484 | 2019-02-27 00:00:00
 |  |  |  |  | QY34954 | 2019-02-27 00:00:00
Spreadsheet: 189ecd8d-f839-4c74-b143-8a0c95c1caa8
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-28 13:45:46.620000
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.375 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.25 | 101.106 | 100.981 | 100.856 | 100.481
4.125 | 100.45 | 100.325 | 100.2 | 99.825 |  | Note: | Refer To Price [NAME]
4 | 100.046 | 99.921 | 99.796 | 99.421 |  |  | For all Price Adjs
3.875 | 99.469 | 99.344 | 99.219 | 98.594
3.75 | 98.517 | 98.392 | 98.267 | 97.642
 |  |  |  |  |  | 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.625 | 101.144 | 101.019 | 100.894 | 100.519
3.5 | 100.806 | 100.681 | 100.556 | 100.181
3.375 | 100.433 | 100.308 | 100.183 | 99.808
3.25 | 99.897 | 99.772 | 99.647 | 99.272
3.125 | 98.43 | 98.305 | 98.18 | 97.555
3 | 98.092 | 97.967 | 97.842 | 97.217
 |  |  |  |  |  | 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-10-12 13:45:46.620000
30 DAY | 2011-10-27 13:45:46.620000
45 DAY | 2011-11-11 13:45:46.620000
60 DAY | 2011-11-26 13:45:46.620000
90 DAY | 2011-12-26 13:45:46.620000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 490551d1479919078-calculate-the-payment-on-tow-stage-book1
Sheet: Sheet1

 | Namber of Month | 6
 | Total monthly pay
NO | Name | Monthly Pay | Number of Pay Bake | Total Pay for 60 Month | first pay bake | second [NAME]
 | Person 1 | 300 | 1
 | Person 2 | 800 | 1
 | Person 3 | 200 | 2
 | Person 4 | 600 | 2
 | Person
 |  |  | 4
 |  |  | 3
 |  |  | 2
 |  |  | 1
Spreadsheet: phillip_m_love__30149__9908_OA
Sheet: EAST-LRC-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  LRC
REGION:  SOUTHEAST
 |  |  | Total |  | Reclasses |  | August |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | 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 | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
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:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | 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
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  |  |  | 0
 |  | TOTAL
Spreadsheet: 127954d1320701144-max-in-list-that-input-value-compare-with-list
Sheet: Sheet1

# units desired | Shipments | Number of units in shipment
902 | 1 | 10
how many shipments will take: | 2 | 22
11 | 3 | 38
with how many til next shipment needed: | 4 | 61
130 | 5 | 95
 | 6 | 147
 | 7 | 227
 | 8 | 349
 | 9 | 499
 | 10 | 667
 | 11 | 846
 | 12 | 1032
 | 13 | 1225
 | 14 | 1425
 | 15 | 1632
 | 16 | 1846
 | 17 | 2067
 | 18 | 2295
 | 19 | 2531
 | 20 | 2775
 | 21 | 3027
 | 22 | 3287
 | 23 | 3555
 | 24 | 3831
 | 25 | 4115
 | 26 | 4407
 | 27 | 4707
 | 28 | 5015
 | 29 | 5332
 | 30 | 5658