tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 802921d1667150935-deferred-commission-calculation-automate-commission-formula
Sheet: Monthly

 |  |  |  |  |  | 1
 |  |  | Amount earned (new and [NAME]) |  | Check | 2019-02-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2020-02-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2021-02-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2022-02-28 00:00:00
1 | 2019-02-28 00:00:00 |  | 20640 | 60
2 |  |  | 96664 | 60
3 |  |  | 15480 | 60
4 |  |  | 32508 | 60
Step 4 | Dr. deferred commission - ST 12320
Spreadsheet: 53f131f5-4ec9-4f03-a114-e14cd5ad79d0
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42273006 | 2014-07-12 20:37:40 | AXIS | 0 | 3 | 6 | 954955 | [NAME] | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42273475 | 2014-07-12 20:56:05 | ALLIES | 0 | 2 | 6 | 954955 | [NAME] | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
Spreadsheet: 68125d1268678690-multiple-nesting-lookup-index-match-gerogiagolfer_example
Sheet: NBFI

 | A | Total Cashed | Total Face Amt | Total Fees |  | Foreign Itms Dep | Cash Withdrawn |  | B | Total Cashed | Total Face Amt | Total Fees |  | Foreign Itms Dep | Cash Withdrawn
 | July | 1 | 10 | 100 |  | 1000 | 10000 |  | July
 | Aug | 10 | 100 | 1000 |  | 10000 | 100000 |  | Aug
 | Sept | 100 | 1000 | 10000 |  | 100000 | 1000000 |  | Sept
 | 3rd QTR '09 | 111 | 1110 | 11100 |  | 111000 | 1110000 |  | 3rd QTR '09 | 0 | 0 | 0 |  | 0 | 0
 | Oct |  |  |  |  |  |  |  | Oct | 2 | 20 | 200 |  | 2000 | 20000
 | Nov |  |  |  |  |  |  |  | Nov | 20 | 200 | 2000 |  | 20000 | 200000
 | Dec |  |  |  |  |  |  |  | Dec | 200 | 2000 | 20000 |  | 200000 | 2000000
 | 4th QTR '09 | 0 | 0 | 0 |  | 0 | 0 |  | 4th QTR '09 | 222 | 2220 | 22200 |  | 222000 | 2220000
 | Jan |  |  |  |  |  |  |  | Jan
 | Feb |  |  |  |  |  |  |  | Feb
 | Mar |  |  |  |  |  |  |  | Mar
 | 1st QTR '10 | 0 | 0 | 0 |  | 0 | 0 |  | 1st QTR '10 | 0 | 0 | 0 |  | 0 | 0
 | APR |  |  |  |  |  |  |  | APR
 | MAY |  |  |  |  |  |  |  | MAY
 | [NAME] |  |  |  |  |  |  |  | [NAME]
 | 2nd QTR '10 | 0 | 0 | 0 |  | 0 | 0 |  | 2nd QTR '10 | 0 | 0 | 0 |  | 0 | 0
 | JULY |  |  |  |  |  |  |  | JULY
 | AUG |  |  |  |  |  |  |  | AUG
 | SEPT |  |  |  |  |  |  |  | SEPT
 | 3rd QTR '10 | 0 | 0 | 0 |  | 0 | 0 |  | 3rd QTR '10 | 0 | 0 | 0 |  | 0 | 0
 | OCT |  |  |  |  |  |  |  | OCT
 | NOV |  |  |  |  |  |  |  | NOV
 | DEC |  |  |  |  |  |  |  | DEC
 | 4th QTR '10 | 0 | 0 | 0 |  | 0 | 0 |  | 4th QTR '10 | 0 | 0 | 0 |  | 0 | 0
Spreadsheet: 27901d1221621414-how-to-change-a-calculated-cell-to-a-value-customers
Sheet: Data

Month: | Customers
Stuff1 | 1435
Stuff2 | 1502
Stuff3 | 1517
Stuff4 | 1499
Stuff5 | 1458
Stuff6 | 1432
Stuff7 | 1402
Stuff8 | 1373
Stuff9 | 1343
Stuff10 | 1314
Stuff11 | 1284
Stuff12 | 1255
Spreadsheet: 96885d1296144145-creating-a-report-with-5-drop-down-menus-dummy-workbook
Sheet: Lookup

Channel Lookup | Time Period: |  |  | NB | Market
All | [NAME] | [NAME] | A: Successful Start | 0.04656456953642384 | 0.03837152185847612 | Brand1 | Motor | Quotes
Aggregator | [NAME] | [NAME] | B: Happy Housemates | 0.06550082781456953 | 0.05238521771793464 | Brand2 | Home | New Business
Phone | Mar-2010 | Mar-2010 | C: Surviving Singles | 0.06125827814569536 | 0.05224074662660002 | Brand3 | Pet | Inforce
Web | Apr-2010 | Q1-2010 | D: On the Bread Line | 0.08247102649006623 | 0.07428703516426363 | Brand4 | Travel | Lapsed |  |  | 2
 | [NAME] | Apr-2010 | E: Flourishing Families | 0.1008899006622517 | 0.08789621196798521 |  |  |  |  |  | 3
 | [NAME] | [NAME] | F: Credit-hungry Families | 0.173841059602649 | 0.1569822878442024 |  |  |  |  |  | 4
 | [NAME] | [NAME] | G: Gilt-edged Lifestyles | 0.02411009933774835 | 0.02268196133953596 |  |  |  |  |  | 5
 | Aug-2010 | Q2-2010 | H: Mid-life [NAME] | 0.05536009933774835 | 0.05241411193620157 |  |  |  |  |  | 6
 | Sep-2010 | H1-2010 | I: Modest Mid-years | 0.080091059602649 | 0.07564506342280909 |  |  |  |  |  | 7
 | Oct-2010 | [NAME] | J: Advancing Status | 0.06405215231788079 | 0.06683232685139703 |  |  |  |  |  | 8
 | Nov-2010 | Aug-2010 | K: Ageing Workers | 0.09292218543046357 | 0.1077754341356295 |  |  |  |  |  | 9
 | Dec-2010 | Sep-2010 | L: Wealthy Retirement | 0.08733443708609272 | 0.1143922101187552 |  |  |  |  |  | 10
 | 2010 Total | Q3-2010 | M: Elderly Deprivation | 0.06560430463576158 | 0.09809587101620966 |  |  |  |  |  | 11
 | Jan-2011 | Oct-2010 |  |  |  |  |  |  |  |  | 12
 |  | Nov-2010 |  |  |  |  |  |  |  |  | 13
 |  | Dec-2010 |  |  |  |  |  |  |  |  | 14
 |  | 2010 Total
 |  | Q4-2010
 |  | H2-2010
 |  | Jan-2011
Graph1
Brand1 | Home | FSS | Aggregator | Channels Household group index against New Business Market Population | Jan-2011
Brand1 Home FSS Aggregator Channels Household group index against New Business Market Population Jan-2011
Churchill FSS Channel household group index against the entire online population
Graph2
Brand1 | Home | FSS | Aggregator | Channels Household Inforce index against Market Population | Jan-2011
Brand1 Home FSS Aggregator Channels Household Inforce index against Market Population Jan-2011
Graph3
#N/A | #N/A | FSS | #N/A | Channels Household group index against New Business Market Population | Jan-2011
#N/A
Churchill FSS Channel household group index against the entire online population
Graph4
#N/A | #N/A | FSS | #N/A | Channels Household Inforce index against Market Population | Jan-2011
#N/A
Spreadsheet: daren_farmer__5411__hpl0811
Sheet: Sheet1

HPLN0811XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
 |  |  |  |  |  | ** Friday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-08-11 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 40  0900hrs | 0 to 40  0900hrs
 |  |  |  |  | 40  to 0 2100hrs | 40  to 0 2100hrs
 |  | Firm Summary
Enron (S) |  | LS HPL [NAME] |  | ENA | 4 | 0
Enron (S) |  | Reklaw |  | ENA | 20 | 0
Enron (S) |  | Oasis Sealy |  | ENA | 50 | 0
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
Empire (Enron) |  | [NAME]. |  | Empire | 8 | 8
Empire (Enron) |  | Oasis Turbine |  | Empire | 10 | 10
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 0a317e74-4d87-4d19-8f3f-19a2947d9ec4
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
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 21. Value of Dwelling Units Approved in New Residential Buildings, Original, Australia
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ;  New ;  Total houses ; |  |  | Original | A418405W | 1970-07-01 00:00:00 | 2010-10-01 00:00:00 | 484 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Semi-detached, row or terrace house, townhouse with one storey and similar ; |  |  | Original | A415787K | 1991-07-01 00:00:00 | 2010-10-01 00:00:00 | 232 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Semi-detached, row or terrace house, townhouse with two or more storeys ; |  |  | Original | A422928K | 1991-07-01 00:00:00 | 2010-10-01 00:00:00 | 232 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Total semi-detached, row or terrace houses, townhouses and similar ; |  |  | Original | A416423R | 1991-07-01 00:00:00 | 2010-10-01 00:00:00 | 232 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Flat, unit or apartment in a building of one or two storeys ; |  |  | Original | A423531F | 1991-07-01 00:00:00 | 2010-10-01 00:00:00 | 232 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Flat, unit or apartment in a building of three storeys ; |  |  | Original | A424176T | 1991-07-01 00:00:00 | 2010-10-01 00:00:00 | 232 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Flat, unit or apartment in a building of four or more storeys ; |  |  | Original | A424728C | 1991-07-01 00:00:00 | 2010-10-01 00:00:00 | 232 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Total flats, units or apartments, excl. [NAME] flats and other/unknown ; |  |  | Original | A417065V | 1991-07-01 00:00:00 | 2010-10-01 00:00:00 | 232 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Total other residential building ; |  |  | Original | A419140V | 1970-07-01 00:00:00 | 2010-10-01 00:00:00 | 484 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Total residential building ; |  |  | Original | A419826L | 1956-01-01 00:00:00 | 2010-10-01 00:00:00 | 658 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: bb8df584-f0ea-4733-9b5a-34c689b3b015
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
FMITO | Test | FMITO | Mitotane (Lysodren) | Mitotane (Lysodren) | Gas Chromatography/Flame Ionization Detection (GC-FID) | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  | 2 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a heparin (green-top) tube(s).   ([NAME] is not acceptable.)  Spin down and send 2 mL of heparinized plasma refrigerated. Note:	1. Indicate plasma on request form. 	2.  [NAME] specimen appropriately (plasma). 	3. Trough levels are most reproducible.   Serum Draw blood in a plain, red-top tube(s). (Serum gel tube is not acceptable.) Spin down and send 2 mL of serum refrigerated. Note:	1. Indicate serum on request form. 	2. Label specimen appropriately (serum). 	3. Trough levels are most reproducible. | 0.3 mL NOTE: Submission of the m | Specimens other than	Plasma, serum Anticoagulants other than	Sodium heparin, EDTA, plain red-top Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Therapeutic and toxic ranges have not been established.   Usual therapeutic doses produce Mitotane serum concentrations  of less than 100 ug/mL.   Test Performed By:  Medtox Laboratories, Inc.                               402 W. County Road D                               St. Paul, MN  55112 | Monday through Sunday | 5 days | 7 - 9 days | 1 | 82491 |  |  |  |  | Medtox Laboratories, Inc
FMITO | Result | Z1197 | Mitotane | Mitotane | Alphanumeric |  |  |  |  | ug/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 605869d1547335515-dynamic-array-unique-values-from-multiple-columns-unique-values-from-multiple-columns
Sheet: Sheet1

 | Base data - can have unlimited rows |  |  |  |  |  |  | Values from each column |  |  |  |  |  |  | Values stacked |  | unique values |  | SORTED UNIQUE - END GOAL
 | c1 | c2 | c3 | c4 | c5 | c6 |  |  | c2 | c3 | c4 | c5 | c6 |  | c11
 | c11 | c21 | c31 | c41 | c51 | c61 |  |  |  |  |  |  |  |  | c12 |  | c12 |  | c12
 | c12 | c22 | c32 |  |  |  |  | c12 | c22 | c32 | c31 | c54 |  |  | c13 |  | c13 |  | c13
 | c13 | c11 | c54 |  |  |  |  | c13 | c11 | c54 | c45 |  |  |  | c14 |  | c14 |  | c14
 | c14 | c24 | c34 | c31 | c54 |  |  | c14 | c24 | c34 |  |  |  |  | c21 |  | c21 |  | c21
 | c14 | c25 | c35 | c45 |  |  |  |  | c25 | c35 |  |  |  |  | c22 |  | c22 |  | c22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c11 |  | c24 |  | c24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c24 |  | c25 |  | c25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c25 |  | c31 |  | c31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c31 |  | c32 |  | c32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c32 |  | c54 |  | c34
 |  |  |  |  |  |  |  | Solution? |  |  |  |  |  |  | c54 |  | c34 |  | c35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c34 |  | c35 |  | c41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c35 |  | c41 |  | c45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c41 |  | c45 |  | c51
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c31 |  | c51 |  | c54
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c45 |  | c61 |  | c61
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c51
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c54
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c61
Spreadsheet: 80828d1281011832-dynamic-charts-book2
Sheet: Sheet1

 |  | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00
Monthly Hours Worked |  | 97400 | 108878 | 105895 | 98982 | 109544 | 141675 | 119063 | 117294 | 146706 | 118103 | 90237 | 89648 | 98205 | 86873 | 72920 | 65339 | 79444 | 79445
Reportable Accidents |  | 5 | 3 | 5 | 6 | 8 | 7 | 7 | 7 | 6 | 9 | 8 | 7 | 8 | 7 | 3 | 6 | 9 | 7
Spreadsheet: 271025d1381785907-sum-adjacent-cell-to-a-reference-throughout-workbook-copy-of-xl0000040
Sheet: WE 12th Jan

Date | 14.01.14 |  |  | 14.01.14 |  |  | 14.01.14 |  |  | 14.01.14
Co./Code/Price | Blackwoods | Dept | Price | Inverell Bearing Cente | Dept | Price | L&H | Dept | Price | Bindaree Stores | Dept | Price
Item 1 | 1x ladder | 1C | 654.3 | 2x A84 v-belts | 1A | 19 | 1x box L36W/865 fluro tubes | 1B | 35.75
Item 2 | 1x box cutting discs | 1C | 49 | 2x 3525-4" t/lock | 1A | 38.99 | 1x box - phillips S10 starters | 1B | 13.7
Item 3
Item 4
Item 5
Item 6
Item 7
Item 8
Item 9
Item 10
Item 11
Item 12
Item 13
Item 14
Item 15
Item 16
Item 17
Item 18 |  |  |  |  |  |  |  |  |  | 15x racking shelves | 1B | 150000
Item 19 |  |  |  |  |  |  |  |  |  | test | 20H | 4260
Item 20
Freight (Price inc) |  |  |  |  | 21A | 8 |  |  |  |  | 21A | 2500
Notes
[NAME]. #
Req'd By
Invoice total (inc) | 703.3 |  |  | 65.99000000000001 |  |  | 49.45 |  |  | 156760 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Other….
Spreadsheet: 0a772aa1-81b0-4711-81d4-cf7368a13e92
Sheet: Sheet1

Texas Public Community, Technical, and State Colleges | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Average Budgeted Faculty Salary by Sector
FY 2011
 | Community Colleges | State Colleges | Technical Colleges | All Sectors
FY 2011
FTE Faculty | 8377 | 173 | 344 | 8894
Average Salary | 53773.85782499702 | 44689.8612716763 | 35634.58139534884 | 52895.57555655498
FY 2010
FTE Faculty | 8396 | 170 | 345 | 8911
Average Salary | 52874 | 44492 | 35647 | 52047.32465492089
% Change
FTE Faculty | -0.002 | 0.018 | -0.003 | -0.002
Average Salary | 0.017 | 0.004 | 0 | 0.016
 |  |  |  | Last Updated May, 2013
Spreadsheet: 887620d1737889999-lost-in-a-challenging-formula-challenge-costs-with-revenue-word-djclements
Sheet: Costs

 |  |  | Identifier | Costs
 |  |  | SE.100 | 1000
 |  |  | SE.101 | 2300
 |  |  | SE.102 | 3200
 |  |  | SE.103 | 2100
 |  |  | SE.104 | 400
 |  |  | SE.105 | 690
 |  |  | SE.106 | 4550
 |  |  | SE.107 | 1200
 |  |  | [NAME] | 1210
Spreadsheet: 464543d1465197746-data-validation-list-with-sumif-function-oeldere-464481d1465144521-data
Sheet: Sheet1

Receipt | Invoice | Item | Amount | Payment | bedrag
1212 |  |  | 200 | 200 |  | Dear All
 | 2222 |  | 500 |  |  | Is it possible to make data validation in cell G1 with the data from Invoices number that still have not got the full payment?
 | 3333 |  | 600 |  |  | If from the table, the invoices number that still not have full payment are : 3333, 4444, 5555
 | 4444 |  | 1000 |  |  | so the data validation list should be : 3333,4444, 5555.
 | 5555 |  | 800
1213 | 3333 |  |  | 300 |  |  | Rijlabels | Som van bedrag
1214 | 2222 |  |  | 500 |  |  | 2222 | 0
1216 | 4444 |  |  | 600 |  |  | 3333 | 300
 |  |  |  |  |  |  | 4444 | 400
 |  |  |  |  |  |  | 5555 | 800
 |  |  |  |  |  |  | Eindtotaal | 1500
Spreadsheet: 160077d1338962742-problem-in-making-pivot-table-aaaa
Sheet: Pivot look

 | count
App | Yes | No
 | Values
Row Labels | Sum of Yes | Sum of No
Alloc | 0 | 4
Back Office 13.4 | 0 | 4
BI Publisher | 0 | 4
CO 13.4 | 0 | 4
E Business | 4 | 0
E Shop-T1 | 1 | 3
EShop-PAT | 4 | 0
EShop-T2 | 4 | 0
ESHOP-T3 | 4 | 0
EShop-T4 | 4 | 0
ReIM | 0 | 4
RIB Payload XSD | 0 | 4
RIB-RMS ADMIN GUI | 0 | 4
RIB-RPM ADMIN GUI | 0 | 4
RIB-SIM ADMIN GUI | 0 | 4
RIB-TAFR ADMIN GUI | 0 | 4
RM24 | 0 | 4
RMS | 0 | 4
RPM | 0 | 4
SIM | 0 | 4
Solve Centurion | 0 | 4
Solve Centurion - Chip and Pin Transactions:- Primary | 0 | 4
Solve Centurion - Chip and Pin Transactions:- Secondary | 0 | 4
Solve Centurion Webservices: Primary | 0 | 4
Solve Centurion Webservices: Secondary | 0 | 4
Solve Portal: Primary | 0 | 4
Solve Portal: Secondary | 0 | 4
SVAP- VAP11 | 4 | 0
SVAP- VAP12 | 0 | 4
SVAP- VAP3 | 4 | 0
SVAP- VAP5 | 4 | 0
SVAP- VAP7 | 4 | 0
VELTI | 0 | 4
[NAME] | 0 | 4
[NAME] for CO 13.4 | 0 | 4
[NAME] for RIB, RSL | 0 | 4
[NAME] for RM 2.4 | 0 | 4
[NAME] for RMS, ReIM, RPM, Alloc, SIM | 0 | 4
Grand Total | 37 | 115
Spreadsheet: 000e50e7-054d-44b8-8d7c-e20ed77316cd
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-10-16 09:16:50.390000
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.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.625 | 101.813 | 101.688 | 101.563 | 101.188
4.5 | 101.064 | 100.939 | 100.814 | 100.439 |  | Note: | Refer To Price [NAME]
4.375 | 100.13 | 100.005 | 99.88 | 99.505 |  |  | For all Price Adjs
4.25 | 99.45 | 99.325 | 99.2 | 98.575
4.125 | 98.659 | 98.534 | 98.409 | 97.784
4 | 97.671 | 97.546 | 97.421 | 96.796
 |  |  |  |  |  | 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.875 | 102.114 | 101.989 | 101.864 | 101.489
3.75 | 101.748 | 101.623 | 101.498 | 101.123
3.625 | 101.329 | 101.204 | 101.079 | 100.704
3.5 | 100.801 | 100.676 | 100.551 | 100.176
3.375 | 100.046 | 99.921 | 99.796 | 99.171
3.25 | 99.318 | 99.193 | 99.068 | 98.443
3.125 | 98.333 | 98.208 | 98.083 | 97.458 |  | 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-10-30 09:16:50.390000
30 DAY | 2013-11-14 09:16:50.390000
45 DAY | 2013-11-29 09:16:50.390000
60 DAY | 2013-12-14 09:16:50.390000
90 DAY | 2014-01-13 09:16:50.390000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 769446d1645543727-lookup-formula-for-unique-value-in-data-table-ef-help
Sheet: Sheet1

Team Member Selected
Team Member 1
 |  |  |  | Team Members: | Relationship Name |  |  |  |  | Need:
 |  |  |  | Team Member 1 | Name 1 |  |  |  |  | Name 1
 |  |  |  | Team Member 2 | Name 2 |  |  |  |  | Name 18
 |  |  |  | Team Member 3 | Name 3 |  |  |  |  | Name 19
 |  |  |  | Team Member 4 | Name 4 |  |  |  |  | Etc.
 |  |  |  | Team Member 5 | Name 5 |  |  |  |  | Etc.
 |  |  |  | Team Member 6 | Name 6 |  |  |  |  | Etc.
 |  |  |  | Team Member 7 | Name 7 |  |  |  |  | Etc.
 |  |  |  | Team Member 8 | Name 8 |  |  |  |  | Etc.
 |  |  |  | Team Member 9 | Name 9 |  |  |  |  | Etc.
 |  |  |  | Team Member 10 | Name 10 |  |  |  |  | Etc.
 |  |  |  | Team Member 2 | Name 11 |  |  |  |  | Etc.
 |  |  |  | Team Member 2 | Name 12 |  |  |  |  | Etc.
 |  |  |  | Team Member 2 | Name 13 |  |  |  |  | Etc.
 |  |  |  | Team Member 9 | Name 14 |  |  |  |  | Etc.
 |  |  |  | Team Member 9 | Name 15 |  |  |  |  | Etc.
 |  |  |  | Team Member 9 | Name 16 |  |  |  |  | Etc.
 |  |  |  | Team Member 9 | Name 17 |  |  |  |  | Etc.
 |  |  |  | Team Member 1 | Name 18 |  |  |  |  | Etc.
 |  |  |  | Team Member 1 | Name 19 |  |  |  |  | Etc.
 |  |  |  | Team Member 1 | Name 20 |  |  |  |  | Etc.
 |  |  |  | Team Member 4 | Name 21 |  |  |  |  | Etc.
 |  |  |  | Team Member 4 | Name 22 |  |  |  |  | Etc.
 |  |  |  | Team Member 4 | Name 23 |  |  |  |  | Etc.
 |  |  |  | Team Member 4 | Name 24 |  |  |  |  | Etc.
 |  |  |  | Team Member 4 | Name 25 |  |  |  |  | Etc. blank if no values, which I will have a countif function that will tell me how many relationships that specific team member has. After that number is reached, the formula will produce a "" value.
 |  |  |  | Team Member 4 | Name 26
 |  |  |  | Team Member 6 | Name 27
 |  |  |  | Team Member 6 | Name 28
 |  |  |  | Team Member 6 | Name 29
 |  |  |  | Team Member 6 | Name 30
 |  |  |  | Team Member 5 | Name 31
 |  |  |  | Team Member 5 | Name 32
 |  |  |  | Team Member 5 | Name 33
 |  |  |  | Team Member 5 | Name 34
 |  |  |  | Team Member 1 | Name 35
Spreadsheet: 157221d1337667287-excel-2007-lookup-to-return-multiple-rows-of-data-test-template
Sheet: Job 4

 | # | Date | Description | Requested | Spent
 | 1 | 2012-01-02 00:00:00 | Training | 387.75 | 387.75
 | 1 | 2012-01-03 00:00:00 | Office | 231.41 | 231.41
 | 1 | 2012-01-04 00:00:00 | Misc | 6000 | 6000
 | 1 | 2012-01-05 00:00:00
 | 1 | 2012-01-06 00:00:00
 | 1 | 2012-01-07 00:00:00
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 2 |  | Misc | 832.99 | 832.99
 | 2 | 2011-02-07 00:00:00 | Misc | 1716 | 1716
 | 2 | 2011-02-01 00:00:00 | Misc | 248.04 | 248.04
 | 2 | 2011-02-10 00:00:00 | Misc | 13.22 | 13.22
 | 2 | 2011-01-27 00:00:00 | MIsc | 840 | 840
 | 2 | 2011-02-11 00:00:00 | Misc | 507.5 | 507.5
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 3 | 2011-02-24 00:00:00 | Misc | 2.65 | 2.65
 | 3 | 2011-03-04 00:00:00 | Misc | 2.82 | 2.82
 | 3 | 2011-02-28 00:00:00 | Misc | 650 | 650 | **Invoice in R#4
 | 3 | 2011-03-01 00:00:00 | Misc | 76.05 | 76.05
 | 3 | 2010-12-02 00:00:00 | MIsc | 47.99
 | 3 | 2011-03-21 00:00:00 | Misc | 37.5 | 37.5
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 6
 | 6
 | 6
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 7
 | 7
 | 7
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 8
 | 8
 | 8
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
Spreadsheet: 817941d1676518561-date-formula-date-formula
Sheet: Sheet2

Last Contact Date | not contacted > 3 M
2019-10-25 00:00:00
2020-07-22 00:00:00
-
-
-
-
-
-
-
-
2020-12-30 00:00:00
2020-10-02 00:00:00