tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 865849d1712830477-excel-omits-adjacent-cells-fix-test-excel
Sheet: Cash Flow 2024

Date | Type | Activity | Amount | Description | Total Spend (Past Week) | Total Spend (YTD Type) | Total Spend (YTD Activity) | Total Spend (YTD)
2024-01-01 00:00:00 | Debit | Shopping (Recreational) | 319
2024-01-01 00:00:00 | Transfer | [NAME] (Account Transfer) | 1752.67
2024-01-04 00:00:00 | Debit | Food | 13.2
2024-01-05 00:00:00 | Debit | Food | 21.21
2024-01-05 00:00:00 | Transfer | Misc (Savings) | 250
2024-01-07 00:00:00 | Debit | Living Expenses (Board) | 50
2024-01-09 00:00:00 | Debit | Entertainment (Subscriptions) | 20.99
2024-01-10 00:00:00 | Credit | Income | 2064.82
2024-01-10 00:00:00 | Debit | Shopping (Recreational) | 23.94
2024-01-12 00:00:00 | Transfer | Misc (Savings) | 250
2024-01-13 00:00:00 | Debit | Food | 24.24
2024-01-14 00:00:00 | Debit | Living Expenses (Board) | 50
2024-01-14 00:00:00 | Debit | Events | 8.7
2024-01-14 00:00:00 | Debit | Shopping ([NAME]) | 35
2024-01-14 00:00:00 | Debit | Shopping ([NAME]) | 12.35
2024-01-15 00:00:00 | Debit | Events | 500
2024-01-15 00:00:00 | Debit | Events | 500
2024-01-16 00:00:00 | Credit | Reimbursement | 9
2024-01-18 00:00:00 | Debit | Shopping (Grocery) | 66.68
2024-01-19 00:00:00 | Debit | Food | 24.95
2024-01-19 00:00:00 | Transfer | Misc (Savings) | 250
2024-01-20 00:00:00 | Credit | Present | 100
2024-01-20 00:00:00 | Debit | Events | 147.32
2024-01-20 00:00:00 | Debit | Entertainment (Subscriptions) | 11.95
2024-01-20 00:00:00 | Transfer | [NAME] (Account Transfer) | 8.88
2024-01-21 00:00:00 | Debit | Living Expenses (Board) | 50
2024-01-22 00:00:00 | Debit | Food | 13.75
2024-01-23 00:00:00 | Debit | Transport | 56.1 | MetroCard
2024-01-24 00:00:00 | Credit | Income | 2627.99
2024-01-24 00:00:00 | Debit | Food | 19.3
2024-01-24 00:00:00 | Debit | Food | 7
2024-01-25 00:00:00 | Debit | Living Expenses (Misc) | 35.53 | Haircut
2024-01-25 00:00:00 | Debit | Shopping (Recreational) | 33.15
2024-01-25 00:00:00 | Debit | Shopping ([NAME]) | 16.15
Spreadsheet: e2b12ade-2c8f-4765-9a31-5372e809bffb
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: |  |  | 2012-09-21 09:56:39.900000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
3.875 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.75 | 102.125 | 102 | 101.875 | 101.5
3.625 | 101.957 | 101.832 | 101.707 | 101.332 |  | Note: | Refer To Price [NAME]
3.5 | 101.408 | 101.283 | 101.158 | 100.783 |  |  | For all Price Adjs
3.375 | 100.585 | 100.46 | 100.335 | 99.71
3.25 | 99.635 | 99.51 | 99.385 | 98.76
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 102.125 | 102 | 101.875 | 101.5
3.25 | 102.125 | 102 | 101.875 | 101.5
3.125 | 101.999 | 101.874 | 101.749 | 101.374
3 | 101.544 | 101.419 | 101.294 | 100.919
2.875 | 100.883 | 100.758 | 100.633 | 100.008
2.75 | 100.233 | 100.108 | 99.983 | 99.358
 |  |  |  |  |  | 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 | 2012-10-05 09:56:39.900000
30 DAY | 2012-10-20 09:56:39.900000
45 DAY | 2012-11-04 09:56:39.900000
60 DAY | 2012-11-19 09:56:39.900000
90 DAY | 2012-12-19 09:56:39.900000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 110477d1307117615-adding-multiple-rows-based-on-column-info-example-sheet
Sheet: Sheet1

Before
A | 2 | X
A | 3 | X
A | 5 | X
B | 2 | X
B | 4 | X
B | 5 | X
C | 1 | X
C | 5 | X
After
A | 1 | Null
A | 2 | X
A | 3 | X
A | 4 | Null
A | 5 | X
B | 1 | Null
B | 2 | X
B | 3 | Null
B | 4 | X
B | 5 | X
C | 1 | X
C | 2 | Null
C | 3 | Null
C | 4 | Null
C | 5 | X
Spreadsheet: lynn_blair__24470__NNGWKednotes_2001
Sheet: May 12,13 2001

NNG WEEKEND NOTES
For cc Mail distribution:  [NAME], [NAME], [NAME], S. January, [NAME], [NAME], [NAME], TMS OnCall
SATURDAY |  |  | 2001-05-12 00:00:00
Mail distribution send to the above listing on Sunday evening.
H:\DATA\Process Guidelines\[NNGWKednotes Template.xls]Dec 25 & 26
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 7:00 A.M. Non-grid:
 | Gas Day: | FRI |  |  | No difficulties with the process.
 | 8:00 AM Final Storage
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 5:00 P.M. Intraday 2:
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 11:30 A.M. Timely
 | Gas Day: | SUN |  |  | No difficulties with the process
 | 6:00 P.M. Evening
 | Other Comments:
 | On Call Reps. |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
SUNDAY
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 7:00 A.M. Non-grid:
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 8:00 AM Final Storage
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 5:00 P.M. Intraday 2:
 | Gas Day: | MON |  |  | No difficulties with the process.
 | 11:30 A.M. Timely
 | Gas Day: | MON |  |  | No difficulties with the process.
 | 6:00 P.M. Evening
 | Other Comments:
 | On Call Reps: |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
Spreadsheet: 779928d1652190784-fuzzy-matching-text-list-with-variations-of-same-text-fuzzy-match-example
Sheet: Sheet2

List to be fuzzy matched to Master | Result column |  | Master List
Bombay Science and Technology University, Phuna, India | Bombay University of Science and Technology, Phuna, India |  | Bombay University of Science and Technology, Phuna, India
Bombay University of Science and Technology, Phuna, India | Bombay University of Science and Technology, Phuna, India |  | School of Craft and Technology, Toronto University
Bombay University of Science and  Technology, India | Bombay University of Science and Technology, Phuna, India |  | Columbus University
Bombay University of Science and Technology, Phuna, India. | Bombay University of Science and Technology, Phuna, India |  | Rhode Island University
Bombay University of Science & Technology | Bombay University of Science and Technology, Phuna, India |  | Connetticut College of Fashion
School of Craft & Technology, The University of Toronto | School of Craft and Technology, Toronto University |  | DRAP University
School of Craft and Technology, Toronto University | School of Craft and Technology, Toronto University
Columbus University | Columbus University
Columbus University | Columbus University
Columbus University | Columbus University
Rhode Island University | Rhode Island University
Rhode Island Uni. | Rhode Island University
Connetticut College of Fashion | Connetticut College of Fashion
Connetticut Fashion College | Connetticut College of Fashion
DRAP [NAME], (Univeristy of DRAP) | DRAP University
List to be fuzzy matched to Master | Master List
Bombay Science and Technology University, Phuna, India | Bombay University of Science and Technology, Phuna, India
Bombay University of Science and Technology, Phuna, India | Bombay University of Science and Technology, Phuna, India
Bombay University of Science and  Technology, India | Bombay University of Science and Technology, Phuna, India
Bombay University of Science and Technology, Phuna, India. | Bombay University of Science and Technology, Phuna, India
Bombay University of Science & Technology | Bombay University of Science and Technology, Phuna, India
School of Craft & Technology, The University of Toronto | School of Craft and Technology, Toronto University
School of Craft and Technology, Toronto University | School of Craft and Technology, Toronto University
Columbus University | Columbus University
Columbus University | Columbus University
Columbus University | Columbus University
Rhode Island University | Rhode Island University
Rhode Island Uni. | Rhode Island University
Connetticut College of Fashion | Connetticut College of Fashion
Connetticut Fashion College | Connetticut College of Fashion
DRAP [NAME], (Univeristy of DRAP) | DRAP University
Spreadsheet: 34419d1231697074-excel-search-marcus-czerny-losas-93
Sheet: Caso 1

1 | 1.05 | 1.1 | 1.15 | 1.2 | 1.25 | 1.3 | 1.35 | 1.4 | 1.45 | 1.5 | 1.55 | 1.6 | 1.8 | 2
1.35 | 1.35 | 1.34 | 1.33 | 1.32 | 1.3 | 1.28 | 1.27 | 1.25 | 1.23 | 1.22 | 1.2 | 1.18 | 1.15 | 1.12
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1.05 | 1.1 | 1.15 | 1.2 | 1.25 | 1.3 | 1.35 | 1.4 | 1.45 | 1.5 | 1.55 | 1.6 | 1.8 | 2
27.2 | 25.8 | 24.6 | 23.7 | 22.9 | 22.3 | 21.8 | 21.4 | 21 | 20.7 | 20.5 | 20.4 | 20.3 | 20.3 | 20.8
27.2 | 28.9 | 30.7 | 32.7 | 34.9 | 37.5 | 40.2 | 43 | 45.9 | 48.9 | 52 | 54.9 | 57.9 | 69.3 | 80.6
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
21.6 | 21.7 | 21.8 | 21.9 | 22.1 | 22.4 | 22.7 | 23.1 | 23.5 | 23.9 | 24.4 | 24.9 | 25.4 | 27.7 | 30.2
Spreadsheet: 148719d1333534139-looking-for-help-with-vlookup-i-think-jobcalc
Sheet: Sheet1

 | Job Tracking Detail for Dennis |  |  |  |  |  |  |  |  | Application Totals
 | Grade | Week | Job | Start Time | End Time | Minutes | Hours | Application |  | Access (A)
 |  | 1 |  |  |  |  |  |  |  | DreamWeaver (D)
 |  | 1 | Job 1 | 2012-04-02 09:00:00 | 2012-04-02 09:15:00 |  |  | S |  | Excel (E )
 |  | 1 | Job 2 | 2012-04-02 09:30:00 | 2012-04-02 10:45:00 |  |  | W |  | Outlook (O)
 |  | 1 | Job 3 | 2012-04-02 13:00:00 | 2012-04-02 15:45:00 |  |  | W |  | PowerPoint (P)
 |  | 1 | Job 4 | 2012-04-03 08:00:00 | 2012-04-03 16:45:00 |  |  | A |  | Publisher (U)
 |  | 1 | Job 5 | 2012-04-03 18:00:00 | 2012-04-03 22:00:00 |  |  | E |  | SharePoint (S)
 |  | 2 | Job 1 | 2012-04-04 08:00:00 | 2012-04-04 16:45:00 |  |  | S |  | Word (W)
 |  | 2 | Job 1 | 2012-04-04 08:00:00 | 2012-04-04 16:45:00 |  |  | W |  | Total
 |  | 2 | Job 2 | 2012-04-04 08:00:00 | 2012-04-04 16:45:00 |  |  | W |  | Week Totals
 |  | 2 | Job 3 | 2012-04-04 08:00:00 | 2012-04-04 16:45:00 |  |  | A |  | Week 1
 |  | 3 | Job 1 | 2012-04-06 08:00:00 | 2012-04-06 16:45:00 |  |  | E |  | Week 2
 |  | 3 | Job 1 | 2012-04-06 08:00:00 | 2012-04-06 16:45:00 |  |  | S |  | Week 3
 |  | 3 | Job 2 | 2012-04-06 08:00:00 | 2012-04-06 16:45:00 |  |  | W |  | Week 4
 |  | 3 | Job 3 | 2012-04-06 08:00:00 | 2012-04-06 16:45:00 |  |  | W |  | Week 5
 |  | 4 | Job 1 | 2012-07-03 08:00:00 | 2012-07-03 16:45:00 |  |  | A |  | Week 6
 |  | 5 | Job 1 | 2012-04-03 08:00:00 | 2012-04-03 17:45:00 |  |  | E |  | Week 7
 |  | 5 | Job 2 | 2012-04-03 08:00:00 | 2012-04-03 17:45:00 |  |  | S |  | Week 8
 |  | 6 | Job 1 | 2012-04-03 08:00:00 | 2012-04-03 17:45:00 |  |  | W |  | Week 9
 |  | 6 | Job 2 | 2012-04-03 08:00:00 | 2012-04-03 17:45:00 |  |  | W |  | Week 10
 |  | 6 | Job 3 | 2012-04-03 08:00:00 | 2012-04-03 17:45:00 |  |  | A |  | Week 11
 |  | 7 | Job 1 | 2012-04-03 08:00:00 | 2012-04-03 18:45:00 |  |  | E |  | Week 12
 |  | 7 | Job 2 | 2012-04-03 08:00:00 | 2012-04-03 18:45:00 |  |  | S
 |  | 8 | Job 1 | 2012-04-03 08:00:00 | 2012-04-03 18:45:00 |  |  | W
 |  | 8 | Job 2 | 2012-04-03 08:00:00 | 2012-04-03 18:45:00 |  |  | W
 |  | 8 | Job 3 | 2012-04-03 08:00:00 | 2012-04-03 18:45:00 |  |  | A
 |  | 9 | Job 1 | 2012-04-03 08:00:00 | 2012-04-03 19:45:00 |  |  | E
 |  | 9 | Job 2 | 2012-04-03 08:00:00 | 2012-04-03 19:45:00 |  |  | S
 |  | 10 | Job 1 | 2012-04-03 08:00:00 | 2012-04-03 19:45:00 |  |  | W
 |  | 10 | Job 2 | 2012-04-03 08:00:00 | 2012-04-03 19:45:00 |  |  | W
 |  | 11 | Job 1 | 2012-04-03 08:00:00 | 2012-04-03 21:45:00 |  |  | A
 |  | 11 | Job 2 | 2012-04-03 08:00:00 | 2012-04-03 21:45:00 |  |  | E
 |  | 12 | Job 1 | 2012-04-03 08:00:00 | 2012-04-03 21:45:00 |  |  | S
Spreadsheet: darron_c_giron__8040__Hierarchy change request
Sheet: Sheet1

 |  |  |  | Enron Corporation
 |  |  |  | Hierarchy Change Request Form
To: | Risk Analysis and Reporting ([NAME]/[NAME]) |  | Request #
From: | Book Administrator |  | Department: | Risk Management
Subject: | Hierarchy change request (to change hierarchy in RisktRAC) |  | Date:
 | To be Completed by Book Administrator:
 |  |  |  |  | Reporting -Subledger
 | Book Administrator Name:
 |  |  |  |  | MTM | Prud | Realized
 | Book Name:
 | [NAME]:
 | Old Portfolio Name:
 | New Portfolio Name:
 | Date to have the change completed:
 | Reason change needs to be made:
CHANGE WILL NOT BE MADE IF THERE IS ANY MISSING INFORMATION.
For questions, call:
[NAME] (x57197)
[NAME] (x31462)
[NAME] (x33102)
Spreadsheet: 455973d1460579486-need-help-with-complex-if-formula-i-guess-excel-help
Sheet: Ark1

 | 53.84615384615385 | 42.67558342814329 | 29 | 35 | 40 | 55.52674048992501 | 53.24851998123201 | 65 | 71 | 75 | 45 | 28 | 35 | 51 | 60 | 71 | 72 | 52 | 49 | 48 | 29 | 25 | 28 | 35 | 51
 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | -1 | -1 | 0 | 1 | 1 | 0 | 0 | -1 | -1 | -1 | 0 | 0 | 1 | 1 | 1 | 1 | 0
Spreadsheet: 07a9c093-df65-4b8e-9f06-023db37e9cd8
Sheet: Sheet1

TABLE 1 | 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 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21
MULTIPLE REGISTRANTS
UNIVERSITY OF HAWAI‘I
(Unduplicated Headcount Across the UH System)
FALL 2003 TO FALL 2010
 |  |  |  |  |  |  |  |  |  |  | Number of Campuses at Which Students Are Enrolled
Fall |  |  | Total |  | Students Enrolled |  |  | Multiple
Semester |  |  | Unduplicated |  | at Only 1 Campus |  |  | Registrants |  |  | Two |  |  | Three |  |  | Four |  |  | Five
 |  |  | Headcount |  | No. | H% |  | Subt | H% |  | No. | H% |  | No. | H% |  | No. | H% |  | No. | H%
 | Fall 2010 |  | 55456 |  | 51297 | 92.5 |  | 4159 | 7.5 |  | 3726 | 6.72 |  | 393 | 0.71 |  | 38 | 0.07 |  | 2 | <0.1
 | Fall 2009 |  | 53656 |  | 49764 | 92.75 |  | 3892 | 7.25 |  | 3525 | 6.57 |  | 339 | 0.63 |  | 26 | <0.1 |  | 2 | <0.1
 | Fall 2008 |  | 50090 |  | 46962 | 93.76 |  | 3128 | 6.24 |  | 2841 | 5.67 |  | 268 | 0.54 |  | 17 | <0.1 |  | 2 | <0.1
 | Fall 2007 |  | 47621 |  | 45018 | 94.53 |  | 2603 | 5.47 |  | 2389 | 5.02 |  | 199 | 0.42 |  | 14 | <0.1 |  | 1 | <0.1
 | Fall 2006 |  | 47391 |  | 45036 | 95.03 |  | 2355 | 4.97 |  | 2136 | 4.51 |  | 197 | 0.42 |  | 19 | <0.1 |  | 3 | <0.1
 | Fall 2005 |  | 47763 |  | 45577 | 95.42 |  | 2186 | 4.58 |  | 1994 | 4.17 |  | 177 | 0.37 |  | 14 | <0.1 |  | 1 | <0.1
 | Fall 2004 |  | 48246 |  | 46125 | 95.6 |  | 2121 | 4.4 |  | 1940 | 4.02 |  | 162 | 0.34 |  | 17 | <0.1 |  | 2 | <0.1
 | Fall 2003 |  | 48347 |  | 46527 | 96.24 |  | 1820 | 3.76 |  | 1683 | 3.48 |  | 124 | 0.26 |  | 13 | <0.1 |  | 0 | 0
 | Note:  System unduplicated headcount = Students Enrolled at Only 1 Campus + subtotal Multiple Registrants.
 | This table counts each student only once for the University of Hawai‘i system.
 | Source:  [NAME];  Census data.
Spreadsheet: 488852d1478869666-subtract-only-the-matched-criteria-from-row-amount-prepayment-schedule_11112016
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | 2017-01-31 00:00:00 | 2017-01-31 00:00:00 | 2017-01-31 00:00:00 | 2017-01-31 00:00:00 | 2017-01-31 00:00:00 | 2017-02-28 00:00:00 | 2017-02-28 00:00:00 | 2017-02-28 00:00:00 | 2017-02-28 00:00:00 | 2017-02-28 00:00:00 | 2017-03-31 00:00:00 | 2017-03-31 00:00:00 | 2017-03-31 00:00:00 | 2017-03-31 00:00:00 | 2017-03-31 00:00:00 | 2017-04-30 00:00:00 | 2017-04-30 00:00:00 | 2017-04-30 00:00:00 | 2017-04-30 00:00:00 | 2017-04-30 00:00:00 | 2017-05-31 00:00:00 | 2017-05-31 00:00:00 | 2017-05-31 00:00:00 | 2017-05-31 00:00:00 | 2017-05-31 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-07-31 00:00:00 | 2017-07-31 00:00:00 | 2017-07-31 00:00:00 | 2017-07-31 00:00:00 | 2017-07-31 00:00:00 | 2017-08-31 00:00:00 | 2017-08-31 00:00:00 | 2017-08-31 00:00:00 | 2017-08-31 00:00:00 | 2017-08-31 00:00:00 | 2017-09-30 00:00:00 | 2017-09-30 00:00:00 | 2017-09-30 00:00:00 | 2017-09-30 00:00:00 | 2017-09-30 00:00:00 | 2017-10-31 00:00:00 | 2017-10-31 00:00:00 | 2017-10-31 00:00:00 | 2017-10-31 00:00:00 | 2017-10-31 00:00:00 | 2017-11-30 00:00:00 | 2017-11-30 00:00:00 | 2017-11-30 00:00:00 | 2017-11-30 00:00:00 | 2017-11-30 00:00:00 | 2017-12-31 00:00:00 | 2017-12-31 00:00:00 | 2017-12-31 00:00:00 | 2017-12-31 00:00:00 | 2017-12-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | Annual ASM | Add-On ASM | [NAME] | Post Go-Live Services | Leasing | Annual ASM | Add-On ASM | [NAME] | Post Go-Live Services | Leasing | Annual ASM | Add-On ASM | [NAME] | Post Go-Live Services | Leasing | Annual ASM | Add-On ASM | [NAME] | Post Go-Live Services | Leasing | Annual ASM | Add-On ASM | [NAME] | Post Go-Live Services | Leasing | Annual ASM | Add-On ASM | [NAME] | Post Go-Live Services | Leasing | Annual ASM | Add-On ASM | [NAME] | Post Go-Live Services | Leasing | Annual ASM | Add-On ASM | [NAME] | Post Go-Live Services | Leasing | Annual ASM | Add-On ASM | [NAME] | Post Go-Live Services | Leasing | Annual ASM | Add-On ASM | [NAME] | Post Go-Live Services | Leasing | Annual ASM | Add-On ASM | [NAME] | Post Go-Live Services | Leasing | Annual ASM | Add-On ASM | [NAME] | Post Go-Live Services | Leasing
 | Category | Invoice Date | Invoice Amount | Amount Paid Date | Paid Value | Prepaid Months | Revenue Per Month | Prepaid Value | Begin Month | Begin Date | End Date
 | Leasing | 2017-01-31 00:00:00 | 150000 | 2017-01-16 00:00:00 | 150000 | 12
Spreadsheet: dc7e59ff-d2cb-4924-a62a-d40685666e2f
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: |  |  | 2013-11-05 09:23:05.820000
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.75 | 102.5 | 102.375 | 102.25 | 101.875 |  | and are added to price quote
4.625 | 102.323 | 102.198 | 102.073 | 101.698
4.5 | 101.968 | 101.843 | 101.718 | 101.343 |  | Note: | Refer To Price [NAME]
4.375 | 101.116 | 100.991 | 100.866 | 100.491 |  |  | For all Price Adjs
4.25 | 100.598 | 100.473 | 100.348 | 99.723
4.125 | 99.83 | 99.705 | 99.58 | 98.955
4 | 98.871 | 98.746 | 98.621 | 97.996
3.875 | 97.856 | 97.731 | 97.606 | 96.981
3.75 | 96.981 | 96.856 | 96.731 | 96.106 |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 102.351 | 102.226 | 102.101 | 101.726
3.625 | 101.946 | 101.821 | 101.696 | 101.321
3.5 | 101.431 | 101.306 | 101.181 | 100.806
3.375 | 100.678 | 100.553 | 100.428 | 100.053
3.25 | 99.955 | 99.83 | 99.705 | 99.08
3.125 | 99.144 | 99.019 | 98.894 | 98.269
3 | 98.394 | 98.269 | 98.144 | 97.519 |  | 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 | 2013-11-19 09:23:05.820000
30 DAY | 2013-12-04 09:23:05.820000
45 DAY | 2013-12-19 09:23:05.820000
60 DAY | 2014-01-03 09:23:05.820000
90 DAY | 2014-02-02 09:23:05.820000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 97629d1296753401-cross-sheet-calc-that-would-omit-0-possible-solution-but-am-getting-a-ref-error-2011trending
Sheet: Team Member Trending

TEAM MEMBER TRENDING
Flint | 18.73905323869934 |  | PPH GOAL - 17.00
Dustin | 29.4686131612383
Sharron | 15.38421863238037
Roxy | 16.12785993504225
[NAME] | 15.89419695904244
Ana | 17.31449034817547
Maria | 24.50420168067227
[NAME] | 19.42013393471132
Petra | 13.514283994567
Regina | 17.79432195717632
Noy | 17.5217402540996
[NAME] | 17.64711281975551
[NAME] | 18.12884005718592
Michelle | 25.86300366300366
Keisha | 11.71793157506052
[NAME] | 15.0382690914258
Average | 18.37989195638976
TEAM MEMBER AVG  PRODUCTION HRS
Flint | 6.526315789473684
Dustin | 7.628333333333334
Sharron(10hr) | 8.487368421052631
Roxy | 8.368823529411763
[NAME] | 9.446153846153848
Ana | 8.127500000000001
Maria | 8.25
[NAME] | 8.894736842105264
Petra | 9.657894736842104
Regina | 6.811538461538461
Noy | 9.072142857142858
Steven(10hr) | 9.798333333333337
[NAME] | 4.005833333333333
Michelle | 2.801818181818182
Keisha(10hr) | 8.955
[NAME] | 8.869333333333335
Average  for 8hr FTE | 8.340277272933465
Average  for 10hr FTE | 9.080233918128656
Total Average | 8.51103649874774