tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 173319d1344515521-sumproduct-formula-only-counting-dates-in-column-sumproduct-sample
Sheet: Export

 |  |  |  |  |  |  |  |  |  |  |  | LastReported
 |  |  |  |  |  |  |  |  |  |  |  | 2/21/2012 2:14:09
 |  |  |  |  |  |  |  |  |  |  |  | 2012-02-08 12:47:44
 |  |  |  |  |  |  |  |  |  |  |  | 2012-02-08 12:52:05
 |  |  |  |  |  |  |  |  |  |  |  | 2012-04-07 07:41:42
 |  |  |  |  |  |  |  |  |  |  |  | 2012-02-08 12:48:59
 |  |  |  |  |  |  |  |  |  |  |  | 2012-02-08 12:48:29
 |  |  |  |  |  |  |  |  |  |  |  | 7/27/2012 1:50:09
 |  |  |  |  |  |  |  |  |  |  |  | 2012-02-08 12:46:03
 |  |  |  |  |  |  |  |  |  |  |  | 7/31/2012 10:21:11
 |  |  |  |  |  |  |  |  |  |  |  | 2012-02-08 12:48:51
 |  |  |  |  |  |  |  |  |  |  |  | 7/16/2012 11:55:07
 |  |  |  |  |  |  |  |  |  |  |  | 7/16/2012 11:26:15
 |  |  |  |  |  |  |  |  |  |  |  | 2012-01-08 13:36:53
 |  |  |  |  |  |  |  |  |  |  |  | 2012-02-08 12:53:01
 |  |  |  |  |  |  |  |  |  |  |  | 2/22/2012 1:59:09
 |  |  |  |  |  |  |  |  |  |  |  | 2012-09-05 11:01:45
 |  |  |  |  |  |  |  |  |  |  |  | 2012-01-08 18:56:42
 |  |  |  |  |  |  |  |  |  |  |  | 12/23/2011 11:11:46
 |  |  |  |  |  |  |  |  |  |  |  | 5/29/2012 8:42:05
 |  |  |  |  |  |  |  |  |  |  |  | 12/23/2011 10:40:40
 |  |  |  |  |  |  |  |  |  |  |  | 2012-03-01 08:19:52
 |  |  |  |  |  |  |  |  |  |  |  | 12/23/2011 [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | 12/23/2011 10:50:21
 |  |  |  |  |  |  |  |  |  |  |  | 2012-09-03 15:15:01
 |  |  |  |  |  |  |  |  |  |  |  | 2012-07-01 20:12:31
 |  |  |  |  |  |  |  |  |  |  |  | 2012-10-02 10:33:42
 |  |  |  |  |  |  |  |  |  |  |  | 1/31/2012 12:56:32
 |  |  |  |  |  |  |  |  |  |  |  | 2012-08-03 10:32:25
 |  |  |  |  |  |  |  |  |  |  |  | 2012-08-03 10:50:57
 |  |  |  |  |  |  |  |  |  |  |  | 2/22/2012 3:51:06
 |  |  |  |  |  |  |  |  |  |  |  | 2012-09-03 12:24:10
 |  |  |  |  |  |  |  |  |  |  |  | 2012-07-03 15:07:48
 |  |  |  |  |  |  |  |  |  |  |  | 2012-08-03 10:32:55
 |  |  |  |  |  |  |  |  |  |  |  | 2012-08-03 10:21:43
 |  |  |  |  |  |  |  |  |  |  |  | 2012-08-03 10:29:18
 |  |  |  |  |  |  |  |  |  |  |  | 3/27/2012 4:04:50
 |  |  |  |  |  |  |  |  |  |  |  | 12/19/2011 2:55:57
 |  |  |  |  |  |  |  |  |  |  |  | 2012-08-03 12:47:11
 |  |  |  |  |  |  |  |  |  |  |  | 2012-09-03 09:55:19
 |  |  |  |  |  |  |  |  |  |  |  | 12/21/2011 3:34:52
 |  |  |  |  |  |  |  |  |  |  |  | 4/18/2012 9:08:10
Spreadsheet: 542546d1507907367-please-critique-my-spreadsheet-please-critique-my-spreadsheet-payroll-worksheets-year-2017
Sheet: #14. 07 July 2017

Paychecks Dated 07 July 2017 |  | A | check | B | C | D | E |  | F |  | G | Total Job Hours | Total Hours-Per Job |  |  | [NAME]-first week |  |  |  |  |  | [NAME]-second week
 |  | Total Hours | Total Hours | Regular Hours | Overtime Hours | Total Hours | Total Hours |  | Overtime Hours |  | Overtime Hours |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
 |  |  |  |  |  | Week #1 | Week #2 |  | Week #1 |  | Week #2 |  | 1 | 2 | 3 | 2017-06-19 00:00:00 | 2017-06-19 00:00:00 | 2017-06-20 00:00:00 | 2017-06-21 00:00:00 | 2017-06-22 00:00:00 | 2017-06-23 00:00:00 | 2017-06-26 00:00:00 | 2017-06-26 00:00:00 | 2017-06-27 00:00:00 | 2017-06-28 00:00:00 | 2017-06-28 00:00:00 | 2017-06-29 00:00:00 | 2017-06-30 00:00:00 | 2017-07-01 00:00:00
# | Job |  |  |  |  |  |  | > | 40 | > | 40 |  |  |  |  |  | T&M |  |  |  |  |  |  |  | T&M
1 | customer #1 name |  |  |  |  |  |  |  |  |  |  |  | x |  |  | X | X | X | X | X | X
2 | customer #2 name |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X
3 | customer #3 name |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  | X | X | X
Employee
1 | name of employee #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.25 | 6 | 9.75 | 9.5 | 9.75 | 8.5
 | name of employee #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.5 | 10.25 | 9.5 | 4
 | name of employee #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.5 |  | 6.5
 | Hours-Regular
 | Hours-Overtime
2 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.5 | 6 | 2 | 7.5 | 8.5 | 8
 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.5 | 9 | 8.75 | 4
 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 6.5
 | Hours-Regular
 | Hours-Overtime |  |  |  |  |  |  |  |  |  |  |  | ,
 | Subtotal-A
 | subtotal-B+C |  |  |  |  | check |  |  |  |  |  |  | check
 | Subtotal-Hours Per Job
 | Subtotal-detail |  |  |  |  |  |  |  |  |  |  | 0 | less: shop
 |  |  |  |  |  |  |  |  |  |  |  |  | hours without shop
 | Weighted-Average
Sales
 | n/a | 0 |  | 0
Employee-Office/Overhead |  | regular | overtime | total
Sales/Officer Salary |  | total
 | [NAME] | 0 |  | 0
Employee-Office/Overhead |  | regular | overtime | total
8 | Juro | 70
 |  | 0
 |  | Regular | Overtime | Total
 | Cost of Goods Sold
 | Overhead
 | Total
Spreadsheet: 733133d1621414863-excel-data-transpose-for-adding-slicers-sample-skill
Sheet: Sheet2

Name | Category | Sub Category | Rating
Employee-A | Project Control | Project Data Analysis (Financial Utilisation, WIP) | 4
Employee-A | Project Control | Management Information System | 2
Employee-A | Project Control | Project Scheduling | 0
Employee-A | Project Control | Project Monitoring | 0
Employee-A | Project Control | Earned Value Management | 0
Employee-A | Project Control | Change Management | 0
Employee-A | Project Schedule | Cost Control | 0
Employee-A | Project Schedule | Project Closure | 0
Employee-A | Project Schedule | Risk Management | 0
Employee-A | Project Schedule | Project Budgeting | 0
Employee-A | Project Schedule | Estimate at Completion | 0
Employee-A | Project Schedule | Document Control | 0
Employee-B | Project Control | Project Data Analysis (Financial Utilisation, WIP) | 5
Employee-B | Project Control | Management Information System | 5
Employee-B | Project Control | Project Scheduling | 5
Employee-B | Project Control | Project Monitoring | 3
Employee-B | Project Control | Earned Value Management | 3
Employee-B | Project Control | Change Management | 3
Employee-B | Project Schedule | Cost Control | 3
Employee-B | Project Schedule | Project Closure | 3
Employee-B | Project Schedule | Risk Management | 3
Employee-B | Project Schedule | Project Budgeting | 3
Employee-B | Project Schedule | Estimate at Completion | 3
Employee-B | Project Schedule | Document Control | 3
Employee-C | Project Control | Project Data Analysis (Financial Utilisation, WIP) | 2
Employee-C | Project Control | Management Information System | 1
Employee-C | Project Control | Project Scheduling | 4
Employee-C | Project Control | Project Monitoring | 3
Employee-C | Project Control | Earned Value Management | 3
Employee-C | Project Control | Change Management | 3
Employee-C | Project Schedule | Cost Control | 3
Employee-C | Project Schedule | Project Closure | 3
Employee-C | Project Schedule | Risk Management | 3
Employee-C | Project Schedule | Project Budgeting | 4
Employee-C | Project Schedule | Estimate at Completion | 4
Employee-C | Project Schedule | Document Control | 4
Employee-D | Project Control | Project Data Analysis (Financial Utilisation, WIP) | 4
Employee-D | Project Control | Management Information System | 4
Employee-D | Project Control | Project Scheduling | 4
Employee-D | Project Control | Project Monitoring | 3
Employee-D | Project Control | Earned Value Management | 3
Employee-D | Project Control | Change Management | 5
Employee-D | Project Schedule | Cost Control | 5
Employee-D | Project Schedule | Project Closure | 5
Employee-D | Project Schedule | Risk Management | 4
Employee-D | Project Schedule | Project Budgeting | 4
Employee-D | Project Schedule | Estimate at Completion | 5
Employee-D | Project Schedule | Document Control | 3
Spreadsheet: 840185d1692540811-transforming-database-with-formulas-transforming-database-with-formula_3
Sheet: Starting Base

 | Raw Date
 | Date | Account | General ledger account | Mapped | Our ref. | Your reference | Entry number | Debit | Credit
 | 2022-01-01 00:00:00 | AeroConnections | 148000 | Trade and other receivables | 20003686 | AC121020M | 24320016 | 0 | 26121.69
 | 2022-01-01 00:00:00 | AeroConnections | 311000 | Trade and other payables | 20003686 | AC121020M | 24320016 | 26121.69 | 0
 | Required Result
 |  |  | This header inserted, and is on debit site, as the amount in I8 is on Debit. |  |  |  |  |  | This header inserted, and is on debit site, as the amount in J7 is on Credit.
 | Date | Account | Dr | Mapped | Our ref. | Your reference | Entry number | Mapped | Cr | Amount
 | 2022-01-01 00:00:00 | AeroConnections | 311000 | Trade and other payables | 20003686 | AC121020M | 24320016 | Trade and other receivables | 148000 | 26121.69
Spreadsheet: 0934c595-d8ce-4e97-bb54-d8ebb454503d
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-12-02 12:58:04.450000
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.5 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.375 | 101.526 | 101.401 | 101.276 | 100.901
4.25 | 100.781 | 100.656 | 100.531 | 100.156 |  | Note: | Refer To Price [NAME]
4.125 | 100.389 | 100.264 | 100.139 | 99.764 |  |  | For all Price Adjs
4 | 99.933 | 99.808 | 99.683 | 99.058
3.875 | 99.359 | 99.234 | 99.109 | 98.484
3.75 | 98.488 | 98.363 | 98.238 | 97.613
 |  |  |  |  |  | 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.875 | 101.498 | 101.373 | 101.248 | 100.873
3.75 | 100.966 | 100.841 | 100.716 | 100.341
3.625 | 100.6 | 100.475 | 100.35 | 99.975
3.5 | 100.266 | 100.141 | 100.016 | 99.641
3.375 | 99.873 | 99.748 | 99.623 | 98.998
3.25 | 99.282 | 99.157 | 99.032 | 98.407
 |  |  |  |  |  | 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-12-16 12:58:04.450000
30 DAY | 2011-12-31 12:58:04.450000
45 DAY | 2012-01-15 12:58:04.450000
60 DAY | 2012-01-30 12:58:04.450000
90 DAY | 2012-02-29 12:58:04.450000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 809316d1671026772-identify-top-2-and-lowest-2-value-and-include-in-comment-dynamic-varaince-summary_test
Sheet: Sheet1

 |  | Products | Sales
 | All regions | Prod1 | 75
 | All regions | Prod2 | 65
 | All regions | Prod3 | 85
 | All regions | Prod4 | 87
 | All regions | Prod5 | 82
 | N.America | Prod1 | 36
 | N.America | Prod2 | 9
 | N.America | Prod3 | -5
 | N.America | Prod4 | 65
 | N.America | Prod5 | 102
 | Europe | Prod1 | 13
 | Europe | Prod2 | 36
 | Europe | Prod3 | -10
 | Europe | Prod4 | -40
 | Europe | Prod5 | 20
 | [NAME] | Prod1 | 12
 | [NAME] | Prod2 | 20
 | [NAME] | Prod3 | 100
 | [NAME] | Prod4 | 62
 | [NAME] | Prod5 | -40
 | [NAME] | Prod1 | 15
 | [NAME] | Prod2 | -17
 | [NAME] | Prod3 | 39
 | [NAME] | Prod4 | 15
 | [NAME] | Prod5 | -30
 | UK | Prod1 | 17
 | UK | Prod2 | 12
 | UK | Prod3 | -19
 | UK | Prod4 | 10
 | UK | Prod5 | -15
 | AUS | Prod1 | -18
 | AUS | Prod2 | 5
 | AUS | Prod3 | -20
 | AUS | Prod4 | -25
 | AUS | Prod5 | 45
Spreadsheet: 858182d1706911901-if-and-with-multiple-conditions-report-creditcard-dj
Sheet: Sheet1

Cardholder | Expense Item | Transaction Date | Post Date | Merchant | Total (USD) | Status | Image Count | Flag | Coded | Status2
[NAME] | General Expense | 01/09/2024 | 01/10/2024 | FSP*BCSP BOARD OF CERT | 90 | In [NAME] | 1 | Red | No
[NAME] | Lodging | 01/17/2024 | 01/19/2024 | DAYS INN | 385.56 | In [NAME] | 1 | Red | No
[NAME] | Lodging | 01/10/2024 | 01/12/2024 | DAYS INN | 385.56 | In [NAME] | 1 | Red | No
[NAME] | General Expense | 01/24/2024 | 01/26/2024 | HOMEDEPOT.COM | 239.09 | In [NAME] | 1 | Red | No
[NAME] | General Expense | 01/24/2024 | 01/26/2024 | HOMEDEPOT.COM | 79.86 | In [NAME] | 1 | Red | No
[NAME] | General Expense | 01/25/2024 | 01/27/2024 | PRO TOOL WA | 1941.36 | In [NAME] | 1 | Red | No
[NAME] | General Expense | 01/12/2024 | 01/14/2024 | THE HOME DEPOT #8916 | 780.71 | In [NAME] | 1 | Red | No
[NAME] | Travel - Other | 01/30/2024 | 01/31/2024 | AVIS RENT-A-CAR | 896.09 | In [NAME] | 0 | Red | No
[NAME] | Fuel | 01/17/2024 | 01/19/2024 | PJ'S TRAVEL CENTER | 24.24 | In [NAME] | 1 | Red | No
[NAME] | Fuel | 01/26/2024 | 01/27/2024 | EXXON JORDANS KWIK STO | 67.01 | In [NAME] | 1 | Red | No
[NAME] | Fuel | 01/30/2024 | 01/31/2024 | EXXON JORDANS KWIK STO | 22.49 | In [NAME] | 0 | Red | No
[NAME] | Fuel | 01/16/2024 | 01/17/2024 | EXXON JORDANS KWIK STO | 59.79 | In [NAME] | 1 | Red | No
[NAME] | Vehicle Repairs | 01/19/2024 | 01/20/2024 | TRACTOR SUPPLY CO #161 | 55.89 | In [NAME] | 1 | Red | No
[NAME] | General Expense | 01/04/2024 | 01/05/2024 | WM SUPERCENTER #1345 | 15.86 | In [NAME] | 0 | Red | No
[NAME] | General Expense | 01/06/2024 | 01/06/2024 | UPS*1Z35TPG00328759424 | 12.37 | In [NAME] | 0 | Red | No
[NAME] | Meals & Entertainment | 01/06/2024 | 01/07/2024 | TST* WHISKEY KITCHEN D | 400 | In [NAME] | 0 | Red | No
[NAME] | Fuel | 01/04/2024 | 01/05/2024 | EXXON SHORT STOP | 31.51 | In [NAME] | 0 | Red | No
[NAME] | Fuel | 01/06/2024 | 01/08/2024 | SHEETZ 0340   00003400 | 61.54 | In [NAME] | 0 | Red | No
[NAME] | Fuel | 01/10/2024 | 01/11/2024 | EXXON SHORT STOP | 60.32 | In [NAME] | 0 | Red | No
[NAME] | General Expense | 01/08/2024 | 01/10/2024 | EAST COAST LUMBER | 33.15 | In [NAME] | 1 | Green | Yes
[NAME] | General Expense | 01/19/2024 | 01/20/2024 | C&C MACHINE AND FABRIC | 500 | In [NAME] | 1 | Green | Yes
[NAME] | General Expense | 01/29/2024 | 01/30/2024 | PARRISH GENERAL SUPPLY | 29.95 | In [NAME] | 1 | Green | Yes
[NAME] | General Expense | 01/05/2024 | 01/06/2024 | HARBOR FREIGHT TOOLS 7 | 79.15 | In [NAME] | 1 | Green | Yes
Spreadsheet: 119373d1314358568-excel-2007-how-do-i-get-multiple-values-form-a-vlookup-multiple-vlookups
Sheet: Sheet1

Date | Code | Arrived Time | Finish Time |  |  |  | Date | Code
2011-06-01 00:00:00 | A5PS | 14:29:00 | 14:32:00 |  |  |  | 2011-06-01 00:00:00 | A5PS
01/06/2011 | TONE | 11:15:00 | 11:25:00 |  |  |  | 01/06/2011 | TONE
01/06/2011 | EEDS | 11:56:00 | 12:11:00 |  |  |  | 01/06/2011 | EEDS
02/06/2011 | A4RS | 08:32:00 | 08:34:00 |  |  |  | 01/06/2011 | A4RS
01/06/2011 | A4RS | 12:00:00 | 12:08:00 |  |  |  | 01/06/2011 | LAYS
01/06/2011 | LAYS | 10:10:00 | 10:20:00 |  |  |  | 01/06/2011 | A6RH
01/06/2011 | A6RH | 10:56:00 | 11:36:00 |  |  |  | 01/06/2011 | STER
23/06/2011 | A6RH | 12:14:00 | 12:16:00 |  |  |  | 01/06/2011 | PSOM
01/06/2011 | STER | 11:34:00 | 11:44:00 |  |  |  | 01/06/2011 | A3GL
01/06/2011 | LAYS | 07:50:00 | 08:00:00 |  |  |  | 01/06/2011 | A8DG
01/06/2011 | EEDS | 12:05:00 | 12:20:00 |  |  |  | 02/06/2011 | A4RS
02/06/2011 | A8DG | 21:13:00 | 21:14:00 |  |  |  | 02/06/2011 | A8DG
08/06/2011 | A3GL | 12:13:00 | 12:14:00 |  |  |  | 02/06/2011 | A3GL
01/06/2011 | PSOM | 13:00:00 | 13:15:00 |  |  |  | 02/06/2011 | TONE
01/06/2011 | PSOM | 13:00:00 | 13:12:00 |  |  |  | 08/06/2011 | A3GL
01/06/2011 | A3GL | 12:49:00 | 13:01:00 |  |  |  | 23/06/2011 | A6RH
02/06/2011 | A3GL | 10:49:00 | 11:08:00
01/06/2011 | STER | 11:43:00 | 11:53:00
02/06/2011 | TONE | 07:20:00 | 07:35:00
01/06/2011 | A8DG | 14:04:00 | 14:45:00
01/06/2011 | A5PS | [NAME] | 09:56:00
Spreadsheet: 5bd2b50a-33a4-4890-a91c-49138ce7c91f
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-08-01 13:42:23.520000
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 | 101.956 | 101.831 | 101.706 | 101.331 |  | and are added to price quote
4.625 | 101.303 | 101.178 | 101.053 | 100.678
4.5 | 100.477 | 100.352 | 100.227 | 99.852 |  | Note: | Refer To Price [NAME]
4.375 | 99.608 | 99.483 | 99.358 | 98.983 |  |  | For all Price Adjs
4.25 | 99.019 | 98.894 | 98.769 | 98.144
4.125 | 98.284 | 98.159 | 98.034 | 97.409
4 | 97.374 | 97.249 | 97.124 | 96.499
 |  |  |  |  |  | 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
4 | 102.125 | 102 | 101.875 | 101.5
3.875 | 101.619 | 101.494 | 101.369 | 100.994
3.75 | 101.126 | 101.001 | 100.876 | 100.501
3.625 | 100.789 | 100.664 | 100.539 | 100.164
3.5 | 100.3 | 100.175 | 100.05 | 99.425
3.375 | 99.556 | 99.431 | 99.306 | 98.681
3.25 | 98.834 | 98.709 | 98.584 | 97.959 |  | Minimum loan amount:
3.125 | 98 | 97.875 | 97.75 | 97.125 |  | 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-08-15 13:42:23.520000
30 DAY | 2013-08-30 13:42:23.520000
45 DAY | 2013-09-14 13:42:23.520000
60 DAY | 2013-09-29 13:42:23.520000
90 DAY | 2013-10-29 13:42:23.520000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 95937d1295452304-formula-to-calculate-money-due-order-book
Sheet: TOTALS

WEEK ENDING | AMOUNT |  | JOB NAME | TOTAL AMOUNT | AMOUNT DUE | COMPLETION DATE | DAYS TO COMPLETION
2011-01-21 00:00:00
2011-01-28 00:00:00
2011-02-04 00:00:00
2011-02-11 00:00:00
2011-02-18 00:00:00
2011-02-25 00:00:00
2011-03-04 00:00:00
2011-03-11 00:00:00
2011-03-18 00:00:00
2011-03-25 00:00:00
TOTAL |  |  | TOTAL
MATCH?
Spreadsheet: 93717d1293478770-excel-2007-invoice-and-database-in-one-puppy-love-2-
Sheet: Invoice

 | PUPPY LOVE THERAPY
 |  |  |  |  |  |  |  |  |  |  |  | INVOICE
 | Customer
 | Owner Name |  |  |  |  |  |  |  |  |  | Date | 2010-12-27 00:00:00
 | Dog Name
 | Address
 | City |  |  | State |  | ZIP
 | Phone
 | Qnty |  | Description |  |  |  |  |  |  |  | Unit Price | TOTAL
 |  |  | THERAPY
 |  | 1 | 30 MINS |  |  |  |  |  |  |  | 25 | 0
 |  | 2 | 60 MINS |  |  |  |  |  |  |  | 50 | 0
 |  | 3 | BODY WORK |  |  |  |  |  |  |  | 50 | 0
 |  |  | MASSAGE
 |  | 4 | 30 MINS |  |  |  |  |  |  |  | 25 | 0
 |  | 5 | 60 MINS |  |  |  |  |  |  |  | 50 | 0
 |  |  | HOME CARE:
 |  | 6 | ADMINISTER MEDS |  |  |  |  |  |  |  | 10 | 0
 |  | 7 | WALK |  |  |  |  |  |  |  | 20 | 0
 |  | 8 | BATHING |  |  |  |  |  |  |  | 20 | 0
 |  | 9 | MEAL |  |  |  |  |  |  |  | 10 | 0
 |  |  |  |  |  |  |  |  |  |  | Subtotal
 | Payment |  | Select One… |  |  |  |  |  | Tax |  | 0.065
 | Comments |  |  |  |  |  |  |  |  |  | TOTAL
 | Name
 | CC #
 | Expires
 | COMMENTS:
Spreadsheet: 680241d1590872431-how-to-copy-every-10-rows-from-multiple-sheets-to-one-sheet-rezaworksheet
Sheet: sheet9

7
76
54
988
352
63
79
1
45
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Spreadsheet: 7659ff16-a634-4435-8488-71c1891515bc
Sheet: Sheet1

SELCS teaching sessions | Registry weeks | Weeks starting on
Induction week | 5 | 27.09.10
tm1 session 1 | 6 | 04.10.10
tm1 session 2 | 7 | 11.10.10
tm1 session 3 | 8 | 18.10.10
tm1 session 4 | 9 | 25.10.10
tm1 session 5 | 10 | 01.11.10
RWk | 11 | 08.11.10
tm1 session 6 | 12 | 15.11.10
tm1 session 7 | 13 | 22.11.10
tm1 session 8 | 14 | 29.11.10
tm1 session 9 | 15 | 06.12.10
tm1 session 10 | 16 | 13.12.10
vac1 | 17 | 20.12.10
vac2 | 18 | 27.12.10
vac3 | 19 | 03.01.11
tm2 session 1 | 20 | 10.01.11
tm2 session 2 | 21 | 17.01.11
tm2 session 3 | 22 | 24.01.11
tm2 session 4 | 23 | 31.01.11
tm2 session 5 | 24 | 07.02.11
RWk | 25 | 14.02.11
tm2 session 6 | 26 | 21.02.11
tm2 session 7 | 27 | 28.02.11
tm2 session 8 | 28 | 07.03.11
tm2 session 9 | 29 | 14.03.11
tm2 session 10 | 30 | 21.03.11
vac1 | 31 | 28.03.11
vac2 | 32 | 04.04.11
vac3 | 33 | 11.04.11
vac4 | 34 | 18.04.11
vac 5 | 35 | 25.04.11
tm3 | 36 | 02.05.11
tm3 | 37 | 09.05.11
tm3 | 38 | 16.05.11
tm3 | 39 | 23.05.11
tm3 | 40 | 30.05.11
tm3 | 41 | 06.06.11
tm3 | 42 | 13.06.11
vac1 | 43 | 20.06.11
vac2 | 44 | 27.06.11
vac3 | 45 | 04.07.11
vac4 | 46 | 11.07.11
vac5 | 47 | 18.07.11
vac6 | 48 | 25.07.11
vac7 | 49 | 01.08.11
vac8 | 50 | 08.08.11
vac9 | 51 | 15.08.11
vac10 | 52 | 22.08.11
vac11 | 53 | 29.08.11
vac12 | 54 | 05.09.11
vac13 | 55 | 12.09.11
vac14 | 56 | 19.09.11
Spreadsheet: 99812d1298386180-consolidating-data-across-multiple-rows-sample-data
Sheet: Sample Output

Patient Name | Therapist | Visit Month/Year | Service | 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
[NAME] | [NAME] | 2010-06-03 00:00:00 | Massage Therapy |  |  | 11.61 |  | 11.61 |  | 11.61 |  |  |  | 11.61 |  |  |  |  |  |  | 11.61 | 11.61 |  |  | 11.61 |  |  | 11.61 |  |  |  | 11.61
[NAME] | [NAME] | 2010-07-02 00:00:00 | Massage Therapy |  | 11.61 |  |  |  |  |  |  | 11.61 | 11.61 |  |  | 11.61 |  |  | 11.61