tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 683961d1593074558-if-and-or-combination-example
Sheet: Sheet1

purpose | value | date | date, if A4 purpose and value A,B or C
A4 | A | 2020-06-06 00:00:00 | 2020-06-06 00:00:00
S3 | B | 2020-06-07 00:00:00
S2 | E | 2020-06-08 00:00:00
S1 | D | 2020-06-09 00:00:00
S3 | C | 2020-06-10 00:00:00
A4 | B | 2020-06-11 00:00:00 | 2020-06-11 00:00:00
S3 | A | 2020-06-12 00:00:00
A4 | B | 2020-06-13 00:00:00 | 2020-06-13 00:00:00
S2 | E | 2020-06-14 00:00:00
A4 | D | 2020-06-15 00:00:00
S1 | A | 2020-06-16 00:00:00
CR | E | 2020-06-17 00:00:00
to give a blank cell if both or either one of the columns are not matching rules
to copy the date only when both rules are matched
if purpose is A4 but value is D, give blank
if  value is A, B or C but pupose is not A4, give blank
if purpose is A4 and value is A/B/C, give date when it was valued
Spreadsheet: 126718d1319832879-running-average-productivity-2011adam
Sheet: Mar

March Valet Totals
PIPER |  |  |  |  | MAIN |  |  |  |  | TOTAL
Average Wait Time |  |  |  |  | Average Wait Time |  |  |  |  | Average Wait Time
Average Storage Length |  |  |  |  | Average Storage Length |  |  |  |  | Average Storage Length
 | Total Parked/            Returned | Average/hour | Scheduled Productive Hours |  |  | Total Parked/            Returned | Average/hour | Scheduled Productive Hours |  |  | Total Parked/            Returned | Average/hour | Scheduled Productive Hours
5:00am-5:59am |  |  | 1 |  | 5:00am-5:59am | 0 | 0 | 0 |  | 5:00am-5:59am | 0 | 0 | 1
6:00am-6:59am |  |  | 2 |  | 6:00am-6:59am | 0 | 0 | 0 |  | 6:00am-6:59am | 0 | 0 | 2
7:00am-7:59am |  |  | 3.5 |  | 7:00am-7:59am |  |  | 2 |  | 7:00am-7:59am | 0 | 0 | 5.5
8:00am-8:59am |  |  | 5 |  | 8:00am-8:59am |  |  | 2 |  | 8:00am-8:59am | 0 | 0 | 7
9:00am-9:59am |  |  | 5.5 |  | 9:00am-9:59am |  |  | 2 |  | 9:00am-9:59am | 0 | 0 | 7.5
10:00am-10:59am |  |  | 5 |  | 10:00am-10:59am |  |  | 3 |  | 10:00am-10:59am | 0 | 0 | 8
11:00am-11:59am |  |  | 5 |  | 11:00am-11:59am |  |  | 3 |  | 11:00am-11:59am | 0 | 0 | 8
12:00pm-12:59pm |  |  | 5 |  | 12:00pm-12:59pm |  |  | 2 |  | 12:00pm-12:59pm | 0 | 0 | 7
1:00pm-1:59pm |  |  | 5 |  | 1:00pm-1:59pm |  |  | 2 |  | 1:00pm-1:59pm | 0 | 0 | 7
2:00pm-2:59pm |  |  | 4.5 |  | 2:00pm-2:59pm |  |  | 3 |  | 2:00pm-2:59pm | 0 | 0 | 7.5
3:00pm-3:59pm |  |  | 3.5 |  | 3:00pm-3:59pm |  |  | 3 |  | 3:00pm-3:59pm | 0 | 0 | 6.5
4:00pm-4:49pm |  |  | 1.5 |  | 4:00pm-4:49pm |  |  | 2 |  | 4:00pm-4:49pm | 0 | 0 | 3.5
5:00pm-5:59pm |  |  | 1 |  | 5:00pm-5:59pm |  |  | 2 |  | 5:00pm-5:59pm | 0 | 0 | 3
6:00pm-6:59pm |  |  | 1 |  | 6:00pm-6:59pm |  |  | 2 |  | 6:00pm-6:59pm | 0 | 0 | 3
7:00pm-8:00pm | 0 | 0 | 0 |  | 7:00pm-8:00pm |  |  | 2 |  | 7:00pm-8:00pm | 0 | 0 | 2
 | 0 | 0 | 48.5 |  |  | 0 | 0 | 30 |  |  | 0 | 0 | 78.5
Spreadsheet: 60710d1261235476-displaying-multiple-results-using-vlookup-or-similar-record-lookup
Sheet: Records

 | Artiste | Track | Year | Format | Label | Value | Comments
1-Smokey RobinsonSmokey | [NAME] | Smokey | 1982 | LP | Motown | 10 | test comment  1 | 1 | Smokey RobinsonSmokey
1-Smokey RobinsonInternational Baby | [NAME] | International Baby |  |  |  |  | test comment  2 | 1.1 | Smokey RobinsonInternational Baby
1-Smokey RobinsonMerry-Go-Round | [NAME] | [NAME] |  |  |  |  | test comment  3 | 1.2 | [NAME]
1-Smokey RobinsonBeing With You | [NAME] | Being With You | 2000 | cd remix | prom | 10 | test comment  4 | 1.3 | Smokey RobinsonBeing With You
1-Arthur AdamsYou Got The Floor | [NAME] | You Got The Floor | 1981 | 12" | Incalculation | 15 | test comment  5 | 2 | [NAME]
1-Jimmy RuffinWhat Becomes Of The  Broken Hearted | [NAME] | What Becomes Of The  Broken Hearted | 1967 | 7" | [NAME] | 5 | test comment  6 | 3 | [NAME] Of The  Broken Hearted
1-Chaka KhanI Feel For You | [NAME] | I Feel For You | 1982 | LP | Warner Bros. | 10 | test comment  7 | 4 | [NAME] For You
1-Aretha FranklinBest of... | [NAME] | Best of... | Various | LP | Atlantic | 10 | test comment  8 | 5 | [NAME] of...
2-Smokey RobinsonBeing With You | [NAME] | Being With You | 1982 | 7" | Epic | 5 | test comment  9 | 6 | Smokey RobinsonBeing With You
3-Smokey RobinsonBeing With You | [NAME] | Being With You | 1983 | 7" | Warner Bros. | 25 | test comment  10 | 100.3 | Smokey RobinsonBeing With You
4-Smokey RobinsonBeing With You | [NAME] | Being With You | 1984 | 7" | Atlantic | 6 | test comment  11 | 23.7 | Smokey RobinsonBeing With You
1-
2-
3-
4-
5-
6-
7-
8-
9-
10-
11-
12-
13-
14-
15-
16-
17-
18-
19-
Spreadsheet: 266353d1379590257-excel-formula-help-for-calculate-days-from-first-min-date-depends-on-so-helptricks
Sheet: Sheet1

SERIAL NUMBER | CRM DATE | DAYS | I WANT FORMULA HERE EXPECTED RESULT | REASON
500123 | 2013-04-01 00:00:00 | 0 | 0 Days | FIRST SO FOR FIRST DATE
500123 | 2013-04-06 00:00:00 |  | 5 days | CALCULATE WITH FIRST DATE OF SERIAL NO 500123
500124 | 2013-04-11 00:00:00 | 0 | 0 Days | FIRST SO FOR FIRST DATE
500123 | 2013-04-16 00:00:00 |  | 15 Days | CALCULATE WITH FIRST DATE OF SERIAL NO 500123
500124 | 2013-04-21 00:00:00 |  | 10 Days | CALCULATE WITH FIRST DATE OF SERIAL NO 500124
500123 | 2013-05-01 00:00:00 |  | 30 Days | CALCULATE WITH FIRST DATE OF SERIAL NO 500123
500124 | 2013-06-30 00:00:00 |  | 80 Days | CALCULATE WITH FIRST DATE OF SERIAL NO 500124
500125 | 2013-07-01 00:00:00 |  | 0 Days | FIRST SO FOR FIRST DATE
500126 | 2013-07-02 00:00:00 |  | 4 Days | CALCULATE WITH FIRST DATE OF SERIAL NO 500126
500125 |  |  | 1 Days | CALCULATE WITH FIRST DATE OF SERIAL NO 500125
500124 | 2013-06-30 00:00:00 |  | 80 Days | CALCULATE WITH FIRST DATE OF SERIAL NO 500124
500126 | 2013-06-28 00:00:00 | 0 | 0 Days | FIRST SO FOR FIRST DATE
500126 | 2013-06-29 00:00:00 |  | 1 Days | CALCULATE WITH FIRST DATE OF SERIAL NO 500126
500126 | 2013-06-30 00:00:00 |  | 2 Days | CALCULATE WITH FIRST DATE OF SERIAL NO 500126
500126 | 2013-06-30 00:00:00 | 2 | 2 Days
Spreadsheet: matt_motley__26380__West_Sens_new
Sheet: OptionNetPosition

 | OPTION_TYPE | (All)
 | EXP_FREQ | (All)
 | BOOK | (All)
 | REGION | (All)
 | Physical/Financial | (All)
 | Call/Put | (All)
 | Sum of MWH | DELIVERY_DT
 | STRIKE | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 2002-06-01 00:00:00 | 2002-07-01 00:00:00 | 2002-08-01 00:00:00 | 2002-09-01 00:00:00 | 2002-10-01 00:00:00 | 2002-11-01 00:00:00 | 2002-12-01 00:00:00 | 2003-01-01 00:00:00 | 2003-02-01 00:00:00 | 2003-03-01 00:00:00 | 2003-04-01 00:00:00 | 2003-05-01 00:00:00 | 2003-06-01 00:00:00 | 2003-07-01 00:00:00 | 2003-08-01 00:00:00 | 2003-09-01 00:00:00 | 2003-10-01 00:00:00 | 2003-11-01 00:00:00 | 2003-12-01 00:00:00
 | 0 |  | 10000 | 10400 | 9600 | 10400 | 10400 | 10400 | 10000 | 10400 | 10800 | 9600 | 10800 | 10000 | 10000 | 10400 | 9600 | 10400 | 10400 | 10400 | 10000 | 10400 | 10400 | 10000
 | 15 | 0 | 0
 | 20 |  |  | 20800 | 19200 | 20800
 | 30.03 |  | -12500 | -13000 | -12000 | -13000 | -13000 | -13000 | -15625 | -16250 | -16875 | -12000
 | 31.25 |  |  |  |  |  |  |  |  |  |  |  | -16200 | -15000 | -15000 | -15600 | -14400 | -15600 | -15600 | -15600 | -18750 | -19500 | -19500 | -15000
 | 35 |  | -20000
 | 38.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10400 | 9600 | 10400 | 10400 | 10400 | 10000 | 10400 | 10400 | 10000 | 10800 | 9600 | 10400
 | 40 |  |  |  |  |  |  |  |  |  |  |  | -43200 | -40000 | -40000
 | 50 |  |  |  |  |  | 10400 | 10400 | 10000
 | 65 |  |  | 20800 | 19200 | 20800 | 20800 | 20800 | 20000 | 20800 | 21600 | 19200 | 21600 | 20000 | 20000
 | 70 |  |  | -20800 | -19200 | -20800
 | 75 |  |  | -10400 | -9600 | -10400 | -10400 | -10400 | -10000 | -10400 | -10800 | -9600 | -10800 | -10000 | -10000
 | 90 |  |  | 31200 | 28800 | 31200
 | 125 |  |  |  |  |  |  |  |  | 10400 | 10800 | 9600
 | 150 |  | 20000 | 31200 | 28800 | 31200 | 31200 | 31200 | 30000 | 31200 | 32400 | 28800 | 32400 | 30000 | 30000
Spreadsheet: 768308d1644921835-can-you-ignore-0-s-in-a-colum-using-averageif-excel-help-
Sheet: Sheet1

 |  | Name | Percentage |  | Name | averge
 |  | [NAME] | 0.4222730739893211 |  | [NAME] | 0.43
 |  |  | 0 |  | [NAME] | 0.44
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  | [NAME] | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  | [NAME] | 0.4514634146341464
 |  | [NAME] | 0
 |  |  | 0
 |  | [NAME] | 0.4013201320132013
 |  |  | 0
 |  |  | 0
 |  | [NAME] | 0.4202695417789757
 |  |  | 0
 |  | [NAME] | 0.4514634146341464
 |  |  | 0
 |  | [NAME] | 0.4514634146341464
 |  |  | 0
 |  |  | 0
 |  | [NAME] | 0
 |  | [NAME] | 0
 |  | [NAME] | 0
 |  | [NAME] | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
Spreadsheet: 185325f3-614f-461d-9727-21c8ad89cd32
Sheet: Sheet1

Provider: | Happy Preschool | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Month and Year: | September, 2012
Your program is required by state licensing guidelines and your DPP agreement to retain detailed attendance records for a minimum of 3 years.*
 | Required for All | Required for All | *** | Complete All that Apply | ***
 | Days Scheduled | Days Attended | Schedule Change | Start Date | End Date | General Notes
DPP Child | Number of days the child was scheduled to attend. | Number of days the child was present at your site. | Has this child increased or decreased hours of attendance this month? If Yes, please indicate the child's new schedule. | If this child enrolled at your program this month, please indicate his or her first day of attendance. | If this child has left your program, please indicate his or her last day.
[NAME] | 20 | 19
[NAME] | 20 | 17
[NAME] | 9 | 9 |  | 2012-09-17 00:00:00
Alejandro Martinez | 13 | 13 | YES
[NAME] | 13 | 11 |  |  | 2012-09-24 00:00:00
Completed by: | [NAME]
Approved by: | [NAME]
Submit your attendance: Please submit form via fax to [PHONE], or email to [EMAIL]
*Your program is not required to use this tool. If your program already has a simple means to report your DPP student's attendance to us, which retains the information needed to generate accurate payment, then by all means continue to use that method.
Spreadsheet: 123924d1317927740-excel-2007-trigger-me-timbers-ahah-my-2-days-of-formulae-doing-dont-work-can-you-solve-it
Sheet: Sheet1

S | S | S | S |  | Row 1 Manual
 | S |  |  |  |  | S |  |  |  |  | S |  | Row 2 Auto S in any cell
 | S | S | S | S |  | S | S | S | S |  | S | S | S | S |  | Row 3 Result
Spreadsheet: 875690d1722305586-return-highest-count-of-consecutive-numbers-that-have-the-same-first-or-last-digit-consecutive-last-digit_wk9128
Sheet: Sheet1

Consecutive Example: 5 numbers in a row
 |  |  |  |  |  |  | 10s Result
1 | 5 | 8 | 18 | 28 |  |  | 3 |  | 0 was repeated 3 times consecutively (01,05,08)
4 | 14 | 24 | 25 | 35 |  |  | 2 |  | 2 was repeated 2 times consecutively (24,25)
3 | 13 | 17 | 23 | 33 |  |  | 2 |  | 1 was repeated 2 times consecutively (13,17)
Example with 6 numbers in a row:
 |  |  |  |  |  |  | 10s Result
2 | 10 | 12 | 20 | 22 | 36 |  | 2 |  | 1 was repeated 2 times consecutively , 2 was repeated 2 times consecutively (10,12),(20,22)
4 | 11 | 14 | 15 | 25 | 34 |  | 3 |  | 1 was repeated 3 times consecutively (11,14,15)
12 | 17 | 22 | 27 | 37 | 47 |  | 2 |  | 7 was repeated 3 times consecutively (27,37,47) |  |  |  |  | 1 was repeated 2 times consecutively , 2 was repeated 2 times consecutively (12,17),(22,27)
1 | 5 | 8 | 15 | 19 | 36 |  | 3 |  | 0 was repeated 3 times consecutively (01,05,08)
7 | 11 | 14 | 15 | 20 | 29 |  | 3 |  | 1 was repeated 3 times consecutively (11.14,15)
[NAME]: 5 numbers in a row
 |  |  |  |  |  |  | 1s Result
01 | 05 | 08 | 18 | 28 |  |  | 3 |  | 8 was repeated 3 times cosecutively (08, 18, and 28).
04 | 14 | 24 | 25 | 35 |  |  | 3 |  | 4 was repeated 3 times consecutively (4,14,24)
03 | 13 | 17 | 23 | 33 |  |  | 2 |  | 2 was repeated 2 times consecutively twice (3,13 ), (23,33)
[NAME] with 6 numbers in a row:
 |  |  |  |  |  |  | 1s Result
02 | 10 | 12 | 20 | 22 | 36 |  | 0 |  | no number of last digits were repeated consecutively
04 | 11 | 14 | 15 | 25 | 34 |  | 2 |  | 5 was repeated 2 times consecutively (15,25)
12 | 17 | 22 | 27 | 37 | 47 |  | 3 |  | 7 was repeated 3 times consecutively (27,37,47)
01 | 05 | 08 | 15 | 19 | 36 |  | 0 |  | no number of last digits were repeated consecutively
07 | 11 | 14 | 15 | 20 | 29 |  | 0 |  | no number of last digits were repeated consecutively
Consecutive Example: 5 numbers in a row
1 | 5 | 8 | 18 | 28
4 | 14 | 24 | 25 | 35
3 | 13 | 17 | 23 | 33
Spreadsheet: 763084d1641986700-count-based-on-entry-uk-prod-lt-holiday-calendar-2022-copy
Sheet: Feb 22

 | Absence Type Key | V | Vacation |  |  | H | Public Holiday |  |  | S | Sick |  | ML/PL | Maternity/ Paternity leave |  |  | BD | Birthday |  |  | T | Training
 | 2022-02-01 00:00:00 | Dates of Absence |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022
 |  | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon
 | Employee Name | 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 | Total Days
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | T | T | T
 | Fran |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V | V | V | V | V
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V | V
 | Jo
 | Maria
 | Mark
 | Michelle
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Zak | V | V
Spreadsheet: 6d6f4446-5e07-4deb-b378-39c897a0129b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
7209 | 53598 | Julia | [NAME] | GBR | 0 | 0:38:48 | 0:01:20 | 4:57:44 | 0:01:33 | 2:22:15 | 1 | 8:01:41
7209 | 53601 | [NAME] | [NAME] | GER | 0 | 0:41:32 | 0:02:00 | 4:59:42 | 0:01:58 | 2:30:43 | 2 | 8:15:57
7209 | 53602 | Irmgard | Luetticken | GER | 0 | 0:41:19 | 0:02:09 | 4:57:55 | [NAME] | 2:35:55 | 3 | 8:19:49
7209 | 53600 | Alexandra | Fellmann | GER | 0 | 0:45:57 | 0:02:09 | 5:17:19 | 0:01:53 | 2:55:43 | 4 | 9:03:03
7209 | 53604 | [NAME] | [NAME] | SUI | 0 | 0:50:08 | 0:02:26 | 5:26:22 | 0:03:27 | 3:14:53 | 5 | 9:37:18
7209 | 53599 | [NAME] | [NAME] | GER | 0 | 0:46:49 | 0:02:26 | 0:00:00 | 0:00:00 | 0:00:00 | DNF | 0:00:00
7209 | 53603 | Cornelia | Huber | SUI | 0 | 0:48:30 | 0:03:12 | 0:00:00 | 0:00:00 | 0:00:00 | DNF | 0:00:00
Spreadsheet: sally_beck__35416__gas settlements key personnel
Sheet: Sheet1

Gas Settlements |  |  |  | Must Keep
1 | Baxter | [NAME] |  | *
2 | Dozier | [NAME] |  | *
3 | Dhont | [NAME] |  | *
4 | Cashin | [NAME] |  | *
5 | Parker | [NAME] |  | *
6 | Jacobs | [NAME] |  | *
7 | Obey | Rena |  | *
8 | [NAME] | [NAME] |  | *
9 | Carlsward | [NAME] |  | *
10 | [NAME] | [NAME] |  | *
11 | Harwell | [NAME]
12 | McFatridge | [NAME]
13 | Curtis | [NAME]
14 | Ellenberger | [NAME]
15 | [NAME] | [NAME]
16 | [NAME] | Kusum
17 | Mousteiko | [NAME]
18 | Nguyen | [NAME]
19 | Price | Wade
20 | Saucier | [NAME]
21 | Ellis | [NAME]
22 | Eubanks Jr | [NAME]
23 | Hamic | Priscilla
24 | Chism | [NAME]
25 | Doner | [NAME]
26 | [NAME] | [NAME]
27 | Mendoza | Genaro
28 | Resendez | Isabel
29 | [NAME] | Willie
30 | Truong | Trisha
31 | Fore | Jeanne
32 | Vela | [NAME]
33 | Youngblood | Kristie
34 | Ortiz | [NAME]
Spreadsheet: 872326d1718715716-look-up-table-between-min-and-max-pricing-example
Sheet: Sheet1

 |  |  |  | Item Cost | Retail Prices
Min | [NAME] | Margin |  | 2.9852
0 | 100 | 0.45 |  | 15.0348
100.01 | 750 | 0.43 |  | 365.534
750.01 | 2000 | 0.4 |  | 3024.6196
2000.01 | 5000 | 0.38 |  | 395.2228
5000.01 | 999999 | 0.345 |  | 404.7768
 |  |  |  | 950
 |  |  |  | 5320
 |  |  |  | 55.6036
 |  |  |  | 2320
 |  |  |  | 800
 |  |  |  | 35.3124
 |  |  |  | 41.5004
Spreadsheet: 577b1f69-76d6-4598-85af-8f2e1b8e48c8
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-11-28 09:27:38.400000
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.553 | 101.428 | 101.303 | 100.928 |  | and are added to price quote
4.375 | 101.038 | 100.913 | 100.788 | 100.413
4.25 | 100.248 | 100.123 | 99.998 | 99.623 |  | Note: | Refer To Price [NAME]
4.125 | 99.81 | 99.685 | 99.56 | 99.185 |  |  | For all Price Adjs
4 | 99.342 | 99.217 | 99.092 | 98.467
3.875 | 98.753 | 98.628 | 98.503 | 97.878
3.75 | 97.863 | 97.738 | 97.613 | 96.988
 |  |  |  |  |  | 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.248 | 101.123 | 100.998 | 100.623
3.75 | 100.716 | 100.591 | 100.466 | 100.091
3.625 | 100.225 | 100.1 | 99.975 | 99.6
3.5 | 99.891 | 99.766 | 99.641 | 99.266
3.375 | 99.498 | 99.373 | 99.248 | 98.623
3.25 | 98.907 | 98.782 | 98.657 | 98.032
 |  |  |  |  |  | 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-12 09:27:38.400000
30 DAY | 2011-12-27 09:27:38.400000
45 DAY | 2012-01-11 09:27:38.400000
60 DAY | 2012-01-26 09:27:38.400000
90 DAY | 2012-02-25 09:27:38.400000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 214613d1361002199-help-needed-related-to-excel-vba-macros-final
Sheet: portfolio

CUSIP | MARKET VALUE | PORTFOLIO NAME | DEAL Name
1 | 24 | vij | WB 2007-C33
2 | 25 | viji | WB 2007-C33
3 | 26 | vijen | WB 2007-C33
4 | 27 | [NAME] | GE 2007-C1
6 | 29 | ran | pcc-2003-1
7 | 30 | ra | pcc-2003-1
8 | 31 | r | [NAME]
9 | 32 | jatinder | [NAME]
10 | 33 | jatin | [NAME]
11 | 34 | meena | che2001
12 | 35 | meen | che2001
13 | 36 | [NAME] | che2001
14 | 37 | me | che2002
15 | 38 | m | che2003
16 | 39 | gurbaksh | che2004
17 | 40 | gurbaks | che2005
18 | 41 | guru | che2006
19 | 42 | vishAL | che2007
20 | 43 | vish | che2008
21 | 44 | vis | che2009
22 | 45 | vi | che2010
23 | 46 | [NAME] | che2010
24 | 47 | anit | che2011
25 | 48 | ani | che2011
26 | 49 | an | che2011
27 | 50 | rajinder | che2012
28 | 51 | rajin | che2013
29 | 52 | jogin | che2014
30 | 53 | joginder | che2015
31 | 54 | [NAME] | che2016
32 | 55 | nirb | che2017
33 | 56 | nir | che2017
34 | 57 | ni | che2018
35 | 58 | shefali | che2019
36 | 59 | shefal | che2020
37 | 60 | sh | che2021
38 | 61 | kamal | che2022
39 | 62 | [NAME] | che2023
40 | 63 | kam | che2024
41 | 64 | purshottam | che2025
42 | 65 | pursh | che2025
43 | 66 | pur | che2025
44 | 67 | pu | che2026
45 | 68 |  | che2032
46 | 69 |  | che2033
47 | 70 |  | che2034
48 | 71 |  | che2035
49 | 72 |  | che2036
50 | 73 |  | che2037
51 | 74 |  | che2038
52 | 75 |  | che2039
53 | 76 |  | che2040
54 | 77 |  | che2041
55 | 78 |  | che2042
56 | 79 |  | che2043
57 | 80
58 | 81
59 | 82
60 | 83
61 | 84
62 | 85
63 | 86
64 | 87
65 | 88
66 | 89
67 | 90
68 | 91
69 | 92
70 | 93
71 | 94
72 | 95
73 | 96
74 | 97
75 | 98
76 | 99
77 | 100
78 | 101
79 | 102
80 | 103
81 | 104
82 | 105
83 | 106
84 | 107
85 | 108
86 | 109
87 | 110
88 | 111
89 | 112
90 | 113
91 | 114
92 | 115
93 | 116
94 | 117
95 | 118
96 | 119
97 | 120
98 | 121
99 | 122
100 | 123
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
Spreadsheet: 46362d1245251360-vlookup-and-dates-copy-of-dashboard-1
Sheet: dashboard

197773 | 6/11/2009
197775 | 6/11/2009
197776 | 6/11/2009
197906 | 6/15/2009
198051 | 6/15/2009
198055 | 6/15/2009
198068 | 6/15/2009
198070 | 6/15/2009
198072 | 6/15/2009
198074 | 6/15/2009
198092 | 6/16/2009
198131 | 6/16/2009
198150 | 6/16/2009
198194 | 6/16/2009
Spreadsheet: 813500d1673821241-iferror-vlookup-help-when-lookup-is-not-found-or-column-sorted-different-vehicle-sheet-for-excelforum2
Sheet: August2022

Biosecurity Operations Branch Vehicle Fleet August 2022
[NAME] | Make | Lease | Location | Region | Cost Code | Responsible Area / Driver | Service Interval Mnths/Kms | Expected KM | vlookup lease | Current Kilometres | Current KM Decimal | Expected KM + 5000 | Expected KM - 5000 | Utilisation + or - 5 | Utilisation | Under / Over Agreement | Comments
G00DA | Toyota Rav4 | 36 mnths/60,000K | [NAME] | NW | BB8100112442 | Biosecurity Operations - Pool | 12 / 15,000
G04CL | [NAME] Dual Cab 4x4 Ute | 36 mnths/60,000K | Mt Pleasant | N | BB8200402442 | Biosecurity Operations - Pool | 12 / 15,000
G06CW | Toyota Corolla Hatchback | 36 mnths/60,000K | [NAME] | NW | BG2401302442 | Biosecurity Operations - Pool | 12 / 15,000
G25CO | Toyota Camry | 36 mnths/60,000K | Mt Pleasant | N | BB8100112442 | Biosecurity Operations - Pool | 12 / 15,000
G28CR | Toyota Camry | 36 mnths/60,000K | New Town | S | BB8200402442 | Biosecurity Operations - Pool | 12 / 15,000
G29CO | Toyota Rav4 | 36 mnths/60,000K | Mt Pleasant | N | BB8100112442 | Biosecurity Operations - Pool | 12 / 15,000
A79KH | Make/Model Manually added for forum | 36 mnths/60,000K | [NAME] | NW | BG2401302442 | Biosecurity Operations - Pool | 12 / 15,000 | 1.67 | 1.67
Spreadsheet: 102112d1300148451-formula-with-2-variables-and-2-fixed-values-amenasce
Sheet: Sheet1

Month | Customers paying one time Fee | Customers paying the Montly Fee | Your Anserw?
2011-01-01 00:00:00 | 30 | 30
2011-01-02 00:00:00 | 20 | 50
2011-01-03 00:00:00 | 20 | 70
2011-01-04 00:00:00 | 20 | 90
2011-01-05 00:00:00 | 20 | 110
Spreadsheet: 03021515-fde1-43ea-a506-41a2bc20cae7
Sheet: Sheet1

 |  | THE UNIVERSITY OF SOUTHERN QUEENSLAND |  |  |  |  |  |  |  |  |  | Version 1.3
 |  | Misc. ASSESSMENT NOTICE |  |  |  |  |  |  |  |  |  | May 2012
 |  | Assessment No: |  |  |  |  | Invoice No:
 |  |  | Dept Name: |  |  |  | Dept ID: |  | New A/c: |  | Yes / No**
 |  |  |  |  |  |  |  | (** If No - Customer Account Code must be entered.)
Assessment Date: |  |  |  |  | Customer Account Code: |  |  |  |  |  | Location:
Order No: |  |  |  |  | Customer Name:
 |  |  |  |  | Postal Address:
 |  |  |  |  |  |  |  |  | State: |  | P'code:
 |  |  |  |  | Contact Name: |  |  |  |  | Ph No:
 |  |  |  |  |  | Name/Address change? | Yes / No | Additional Address: |  |  | Yes / No
 | Please note: | If any field marked in red has not been completed, your assessment will be returned to you for completion.  This will delay the raising
 |  | of your invoice.  Please refer to instructions on 'how to complete'.
Line | Charge ID | Qty | Unit $Price | $[NAME] excl GST | $ GST** | Line Description | Account | Fund | Dept ID | Prog | Project
1 |  |  |  |  |  |  |  | 2
2 |  |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  |  | 2
4 |  |  |  |  |  |  |  | 2
5 |  |  |  |  |  |  |  | 2
** | If GST is not applicable to an item then supporting documentation must be supplied with the assessment notice - eg copy of contract.
TOTAL (Ex GST) $ |  |  |  | Total GST   $ |  |  | GROSS TOTAL      $
Requested by |  |  |  | /     / | Authorised by |  | /      / | Entered PS
 |  | Signature |  |  |  | Signature |  |  |  | Signature
Print Name: |  |  |  | Ext No: | Print Name: