tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 272860d1382534723-referencing-values-above-the-last-cell-in-a-row-dates
Sheet: Sheet1

Accumulative Absences |  |  |  |  |  |  |  |  |  |  |  |  |  | Not required to attend          (all sessions on sheet) |  | Total Individual absences up to last date entered
Dates of Each Session
[NAME] | n | n |  |  | n | n |  |  | n | n |  |  |  |  |  |  | < should be 4 as student only has 4 sessions not to attend up to last date on sheet
[NAME] | n | n |  |  |  |  |  |  | n | n |  |  |  |  |  |  | < should be 2 as student has 2 sessions not to attend up to last date on sheet
[NAME] |  |  |  |  |  |  |  |  | n | n |  |  |  |  |  |  | < should be 0 as student has 0 sessions not to attend up to last date on sheet
[NAME] | n | n |  |  |  |  |  |  | n | n |  |  |  |  |  |  |  |  |  |  | <Todays Date
[NAME] | n | n |  |  | n | n |  |  | n | n |  |  |  |  |  |  |  |  |  | 2013-10-18 00:00:00 | Dates of all sessions entered here. These then appear in each "Dates of Each Session" cells if they are =< today's date.
George | n | n |  |  | n | n |  |  | n | n |  |  |  |  |  |  |  |  |  | 2013-10-19 00:00:00
[NAME] |  |  | n | n |  |  | n | n |  |  | n | n |  |  |  |  |  |  |  | 2013-10-20 00:00:00
Harold |  |  | n | n |  |  | n | n |  |  | n | n |  |  |  |  |  |  |  | 2013-10-21 00:00:00
Trevor |  |  | n | n |  |  | n | n |  |  | n | n |  |  |  |  |  |  |  | 2013-10-22 00:00:00
[NAME] |  |  | n | n |  |  | n | n |  |  | n | n |  |  |  |  |  |  |  | 2013-10-23 00:00:00
Mark |  |  | n | n |  |  | n | n |  |  | n | n |  |  |  |  |  |  |  | 2013-10-24 00:00:00
[NAME] |  |  | n | n |  |  | n | n |  |  | n | n |  |  |  |  |  |  |  | 2013-10-25 00:00:00
[NAME] |  |  | n | n |  |  | n | n |  |  | n | n |  |  |  |  |  |  |  | 2013-10-26 00:00:00
 |  |  |  |  |  |  |  |  |  | Sum of all the "n" on the sheet > |  |  |  |  |  |  | <Total of all individual absences entered up to last date |  |  | 2013-10-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-28 00:00:00
Total Absences up to last date entered = |  |  |  | ? | < result of formula in this cell should be 13 by correctly referencing (H2) as that is the total of the accumulative absences up to the last date entered on the form (H3) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-30 00:00:00
Spreadsheet: 680720d1591163844-summing-by-matching-parts-of-a-value-to-a-matrix-sum-or-sumif
Sheet: OS

[NAME] | MODEL/SZ | Total Plan
1111222333 | SSS333-02
1111222333 | SSS333-03
1111222333 | SSS333-04
1111222333 | SSS333-05
1111222333 | SSS333-06
1111222333 | SSS333-07
1111222333 | SSS333-08
1111222333 | SSS333-09
1111222333 | SSS333-10
1111222333 | SSS333-11
1111222333 | SSS333-12
1111222333 | SSS333-13
1111222443 | DDD4444-02
1111222443 | DDD4444-03
1111222443 | DDD4444-04
1111222443 | DDD4444-05
1111222443 | DDD4444-06
1111222443 | DDD4444-07
1111222443 | DDD4444-08
1111222443 | DDD4444-09
1111222443 | DDD4444-10
1111222443 | DDD4444-11
1111222443 | DDD4444-12
1111222443 | DDD4444-13
1111222355 | WWW999DW-02
1111222355 | WWW999DW-03
1111222355 | [NAME]
1111222355 | WWW999DW-05
1111222355 | WWW999DW-06
1111222355 | WWW999DW-07
1111222355 | WWW999DW-08
1111222355 | WWW999DW-09
1111222355 | WWW999DW-10
1111222355 | WWW999DW-11
1111222355 | WWW999DW-12
1111222355 | WWW999DW-13
Spreadsheet: 101331d1299492404-formula-time-time-formula-timesheet
Sheet: March 2010

[NAME] [NAME]
Date: | Project | From | To | Hours
2010-03-09 00:00:00 | XYZ | 01:45:00 | 03:30:00 | 01:45:00
 | ABC | 07:30:00 | 07:40:00 | 00:10:00
2010-03-10 00:00:00 | XYZ | 13:15:00 | 11:50:00 | 22:35:00
 | ABC | 19:00:00 | 16:00:00 | 21:00:00
2010-03-11 00:00:00 | ABC | 1904-01-02 00:45:00 | 20:10:00 | 19:25:00
 | XYZ | 1904-01-02 06:30:00 | 1904-01-02 00:20:00 | 17:50:00
2010-03-12 00:00:00 | Total XYZ | 21:10:00
2010-03-13 00:00:00 | Total ABC | 1904-01-03 11:50:00
2010-03-15 00:00:00
2010-03-16 00:00:00
2010-03-19 00:00:00
2010-03-22 00:00:00
2010-03-24 00:00:00
Spreadsheet: 262605d1378217928-open-file-dynamically-and-copy-data-using-advanced-filter-output-file
Sheet: Sheet1

Owners | Projects | Date | End date | Price | Priority |  |  |  |  |  | Required members
[NAME] | Prj1 | 2014-12-05 00:00:00 | 2015-12-02 00:00:00 | 5000 | High |  |  |  |  |  | [NAME]
[NAME] | Prj1 | 2013-10-05 00:00:00 | 2014-10-05 00:00:00 | 5000 | High |  |  |  |  |  | [NAME]
[NAME] | Prj1 | 2013-10-05 00:00:00 | 2014-10-05 00:00:00 | 5000 | High |  |  |  |  |  | [NAME]
[NAME] | Prj2 | 2014-10-05 00:00:00 | 2015-10-05 00:00:00 | 12000 | High |  |  |  |  |  | [NAME]
Yuan | Prj2 | 2014-10-05 00:00:00 | 2015-10-05 00:00:00 | 12000 | High |  |  |  |  |  | Yuan
[NAME] | Prj2 | 2014-10-05 00:00:00 | 2015-10-05 00:00:00 | 12000 | High |  |  |  |  |  | [NAME]
[NAME] | Prj2 | 2014-10-05 00:00:00 | 2015-10-05 00:00:00 | 12000 | High
[NAME] | Prj3 | 2016-10-05 00:00:00 | 2017-10-05 00:00:00 | 18000 | High
[NAME] | Prj2 | 2014-10-05 00:00:00 | 2015-10-05 00:00:00 | 12000 | High
[NAME] | Prj3 | 2016-10-05 00:00:00 | 2017-10-05 00:00:00 | 18000 | High
Spreadsheet: 778776d1651312467-number-the-repeated-empolyee-based-on-their-id-count-duplicates-aligw
Sheet: DataEntry

S/No | Date | Employee ID | Department | Cabinet | User Name | Count |  | Expected Result
1 | 2022-04-27 00:00:00 | 11111 | Finance | N-A | FN-Jame |  |  | 1
2 | 2022-04-27 00:00:00 | 11151 | Finance | N-B | FN-Jean
3 | 2022-04-27 00:00:00 | 11122 | Production | N-A | PD-Ali
4 | 2022-04-27 00:00:00 | 11115 | Store | N-B | ST-KokZheng
5 | 2022-04-27 00:00:00 | 11133 | HR | N-A | HR-Alex
6 | 2022-04-27 00:00:00 | 11355 | Production | N-B | PD-Ng [NAME]
7 | 2022-04-27 00:00:00 | 11155 | Production | N-C | PD-Leo Siang Hock |  |  | 1
8 | 2022-04-27 00:00:00 | 11111 | Finance | N-D | FN-Jame |  |  | 2
9 | 2022-04-30 00:00:00 | 11111 | Finance | N-B | FN-Jame |  |  | 3
10 | 2022-04-30 00:00:00 | 11155 | Production | N-C | PD-Leo Siang Hock |  |  | 2
Spreadsheet: 857741d1706671275-solve-for-multiple-objective-cells-in-solver-sff-2024-solver-copy
Sheet: Roadworks

Roadworks summary
Bitumen resurfacing
Year 7
Year 12
Year 15
Sub Total
Roadway repairs
Year 5
Year 10
Year 15
Sub Total
Spreadsheet: 587188d1534883500-finding-unique-not-duplicates-values-using-index-and-multiple-criteria-mock-calcs
Sheet: Green Lantern

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Biweekly Time Sheet
 | Please Input Job # for each week in Red Boxes to calculate hours and LOA: |  |  |  |  |  |  |  |  | Pay period start date:
 |  |  |  |  |  |  |  |  |  | Pay period end date:
 | Employee: |  | [NAME]
 | WEEK 1 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  | Total | Total | Total
 | Job # | REG | OT | REG | OT | REG | OT | REG | OT | REG | OT | REG | OT | REG | OT | REG | OT | Hours
 | LOA |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total LOA
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly Totals
 | WEEK 2 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  | Total | Total | Total
 | Job # | REG | OT | REG | OT | REG | OT | REG | OT | REG | OT | REG | OT | REG | OT | REG | OT | Hours
 | LOA |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total LOA
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly Totals
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NET Hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NET LOA
Spreadsheet: jonathan_mckay__16906__Soccerdome
Sheet: Deal Sheet

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | Calgary Soccer Centre |  |  |  | Deal Date: | 2001-07-17 00:00:00 |  |  |  |  |  |  | 3 | March
Originator: | Greg Frers |  |  |  | Deal ID #: |  |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-09-01 00:00:00 |  |  |  | Unit of Measure: | GJ |  |  |  |  |  |  | 6 | June
Deal End Date: |  |  |  |  | Volume (Monthly/Daily): | Monthly |  |  |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  | Price: |  |  |  |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  | Buy/Sell: |  |  |  |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Combined Volume | Fuel | Total
 | January | 640 | 1788
 | February | 533 | 774
 | March | 568 | 1439
 | April | 402 | 845
 | May | 306 | 590
 | June | 169 | 375
 | July | 130 | 299
 | August | 141 | 212
 | September | 345 | 616
 | October | 466 | 1189
 | November | 571 | 1773
 | December | 646 | 1824
 | TOTAL:
Spreadsheet: 165850d1341358166-unusual-fraction-to-decimal-fractionformatting2
Sheet: Sheet1

Price | Fraction
5.22 | 0.25 |  |  |  | <----format as number depends on how many you like for decimal palces...
5.22 | 0.5625
5.22 1/4 |  |  |  | < -------- SINGLE CELL ENTRY |  | <----format as number depends on how many you like for decimal palces...
5.22 9/16 |  |  |  | <---------SINGLE CELL ENTRY
5.22 2/3 |  |  |  | <---------SINGLE CELL ENTRY
5.22 9/16 |  |  |  | <---------SINGLE CELL ENTRY
5.22 5/6 |  |  |  | <---------SINGLE CELL ENTRY
Spreadsheet: 858717d1707301012-display-date-within-month-only-sample-07-list-of-date-from-month-selection-for-2003-and-365-aligw
Sheet: Summary

FEB | 2024
Date (workday) | Day | Date (all day in months) | Day |  |  | public holiday |  |  | 365
 |  |  |  |  |  | 2024-01-01 00:00:00 | New Year
 |  |  |  |  |  | 2024-01-25 00:00:00 | [NAME] |  | 2024-02-02 00:00:00
 |  |  |  |  |  | 2024-02-01 00:00:00 | Feb |  | 2024-02-03 00:00:00
 |  |  |  |  |  | 2024-02-12 00:00:00 | Feb |  | 2024-02-04 00:00:00
 |  |  |  |  |  | 2024-03-28 00:00:00 | Feb |  | 2024-02-05 00:00:00
 |  |  |  |  |  | 2024-04-08 00:00:00 | test |  | 2024-02-06 00:00:00
 |  |  |  |  |  |  |  |  | 2024-02-07 00:00:00
 |  |  |  |  |  |  |  |  | 2024-02-08 00:00:00
 |  |  |  |  |  |  |  |  | 2024-02-09 00:00:00
 |  |  |  |  |  |  |  |  | 2024-02-10 00:00:00
 |  |  |  |  |  |  |  |  | 2024-02-11 00:00:00
 |  |  |  |  |  |  |  |  | 2024-02-12 00:00:00
 |  |  |  |  |  |  |  |  | 2024-02-13 00:00:00
 |  |  |  |  |  |  |  |  | 2024-02-14 00:00:00
 |  |  |  |  |  |  |  |  | 2024-02-15 00:00:00
 |  |  |  |  |  |  |  |  | 2024-02-16 00:00:00
 |  |  |  |  |  |  |  |  | 2024-02-17 00:00:00
 |  |  |  |  |  |  |  |  | 2024-02-18 00:00:00
 |  |  |  |  |  |  |  |  | 2024-02-19 00:00:00
 |  |  |  |  |  |  |  |  | 2024-02-20 00:00:00
 |  |  |  |  |  |  |  |  | 2024-02-21 00:00:00
 |  |  |  |  |  |  |  |  | 2024-02-22 00:00:00
 |  |  |  |  |  |  |  |  | 2024-02-23 00:00:00
 |  |  |  |  |  |  |  |  | 2024-02-24 00:00:00
 |  |  |  |  |  |  |  |  | 2024-02-25 00:00:00
 |  |  |  |  |  |  |  |  | 2024-02-26 00:00:00
 |  |  |  |  |  |  |  |  | 2024-02-27 00:00:00
 |  |  |  |  |  |  |  |  | 2024-02-28 00:00:00
 |  |  |  |  |  |  |  |  | 2024-02-29 00:00:00
Spreadsheet: 599609d1543221070-if-function-code
Sheet: Summary

Machine No. | 4353
Service Parts |  |  |  | Accumulator
Part Code | Description | Qty |  | Part Code | Description | Qty
Spreadsheet: 47745d1246920389-need-a-formula-that-works-out-hours-staff-worked-and-if-meals-required-functionsformulas-1
Sheet: Sheet1

 |  | Passes/ Accreditation |  |  |  |  |  | Catering
 |  |  |  |  |  |  |  | Time meal is served
 |  |  |  |  |  |  |  | 8am | 12:30pm | 5pm | 7am | 1pm | 6pm
 |  |  |  |  |  |  |  | 10am | 2pm | 8pm | 10am | 2:30pm | 9pm
 |  |  |  |  |  |  |  | 2nd |  |  | 3rd
NAME | Job Title | 2nd | Start | Finish | 3rd | Start | Finish | B | L | D | B | L | D
[NAME] | Event Manager | 1 | 08:00:00 | 14:00:00 | 0
[NAME] | Event Assistant | 1 | 08:00:00 | 20:00:00 | 1 | 13:00:00 | 22:30:00
[NAME] | Site Manager | 1 | 15:00:00 | 22:30:00 | 1 | 08:00:00 | 15:00:00
Teresa Green | Co-ordinator | 1 | 12:00:00 | 22:30:00 | 1 | 15:00:00 | 22:30:00
[NAME] | Press | 1 | 14:00:00 | 17:00:00 | 0
[NAME] | Stage Hand | 1 | 16:00:00 | 22:30:00 | 1 | 21:00:00 | 08:00:00
TOTALS
Spreadsheet: 773588d1647948287-formula-to-sum-multiple-cells-according-to-filter-example
Sheet: Sheet1

PRODUCT ID | QTY
111111 | 50 |  | Sum of QTYs where PRODUCT ID=111111
222222 | 22
111111 | 60
222222 | 22
222222 | 22
111111 | 70
222222 | 22
222222 | 22
222222 | 22
222222 | 22
111111 | 90
Spreadsheet: 069ecbac-df65-4b3c-8429-d33ea1818f61
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
YMICR | Test | YMICR | Y Chromosome Microdeletions, Molecular Detection | Y Microdeletion | Polymerase chain reaction (PCR) is used to test DNA for the presence of microdeletions of the Y chromosome (region AZFa, AZFb, and AZFc). (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA OR Yellow-Top (ACD) Tube: ACD OR |  |  | 5 | mL | [NAME] must arrive within 96 hours of draw.   [NAME] blood Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant	 [NAME]: 3 mL Collection Instructions:	 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms: 1. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 2. If not ordering electronically, submit a Molecular Genetics Request Form (Supply T245) with the specimen. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Friday; 2 p.m. | 5 days | 10 days | 1 | 81403 |  |  |  |  | Rochester
YMICR | [NAME] | VARIES | Varies |  |  |  | Ambient
YMICR | Result | 17302 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
YMICR | Result | 17303 | [NAME] | [NAME] | Alphanumeric
YMICR | Result | 17304 | Source | Source | Alphanumeric
YMICR | Result | 17311 | Order Date | Order Date | Alphanumeric
YMICR | Result | 17305 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
YMICR | Result | 17306 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35456-3 | Y chromosome deletion:Prid:Pt:Bld/Tiss:Nom:
YMICR | Result | 17307 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9 | Service comment 01:Imp:Pt:[NAME]:Nom:
YMICR | Result | 17308 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
YMICR | Result | 17309 | Reviewed By | Reviewed By | Alphanumeric
YMICR | Result | 17310 | Released Date | Released Date | Alphanumeric
Spreadsheet: 39e0695e-0dbb-420a-9423-c6eb31fc61f9
Sheet: Sheet1

PARK CITY SCHOOL DISTRICT |  |  |  |  |  |  |  |  |  |  |  |  | Note: | The yellow cells are formulas
SPECIAL ACTIVITIES REPORT |  |  |  |  |  |  |  |  |  |  |  |  |  | The blue cells are drop-down lists
 |  |  |  |  |  |  |  |  | TO
Location # | Location Name |  |  |  | Reporting Dates (see payroll schedule)
 |  |  |  |  | ACCOUNT NUMBER
[NAME] (Last, First) | [NAME] |  | DATE |  | ORG |  | OBJ |  | Total Hours or Days | Pay Rate | Stipend | Total Amount to Pay
TOTALS
For School information when using Program 9998 |  | Total Amount To Pay | Employer Portion FICA |  | Employer Portion URS | Employer Portion WC |  |  | Total Cost |  | Check Number
 |  | Total Amount To Pay | Employer Portion FICA |  | Employer Portion URS | Employer Portion WC |  |  | Total Cost |  | Check Number
_________________________________________________
Principal/Supervisor Signature |  | Total Amount To Pay | Employer Portion FICA |  | Employer Portion URS | Employer Portion WC |  |  | Total Cost |  | Check Number
_________________________________________________
District Approval |  | Total Amount To Pay | Employer Portion FICA |  | Employer Portion URS | Employer Portion WC |  |  | Total Cost |  | Check Number
 |  | Total Amount To Pay | Employer Portion FICA |  | Employer Portion URS | Employer Portion WC |  |  | Total Cost |  | Check Number
104 | Parleys Park Elementary School
108 | [NAME]
112 | Jeremy Ranch Elementary School
116 | Trailside Elementary School
304 | Treasure Mountain Int'l Middle School
308 | Ecker Hill Int'l Middle School
500 | District Office
526 | Aquatic Center
534 | Park City Learning Center
555 | Transportation
704 | Park City High School
2011-07-30 00:00:00 | 2011-09-02 00:00:00
 | 2011-09-30 00:00:00
 | 2011-10-28 00:00:00
 | 2011-11-25 00:00:00
 | 2011-12-30 00:00:00
 | 2012-01-27 00:00:00
 | 2012-03-02 00:00:00
 | 2012-03-30 00:00:00
 | 2012-04-27 00:00:00
 | 2012-06-01 00:00:00
 | 2012-06-29 00:00:00
 | 2012-07-27 00:00:00
Spreadsheet: 889360d1740155355-creating-a-dynamic-table-from-a-pivot-from-google-sheets-pgt-aol-dashboard
Sheet: Lookup - PASTE LINK HERE

Programme | Module | Year | Below expectations | Meets expectations | Exceeds expectations | Dashboard!a7:f11
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1B37SHd5uy7eYHqXEHv3kxP8myBMIRjrUoVjCTTeupIk/edit?gid=54982496#gid=54982496
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1FXsN_7aoJSGmPbWQQdbewT3C1B363aEvsqFW3FHzfkw/edit?gid=54982496#gid=54982496
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1iqMT1dKx7uSeLlgxSw7pDceBJQj4e5sJCVQF99t2bbg/edit?gid=54982496#gid=54982496
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1y-8o4-wwDYYici3J6gqU4wjyJA6lsGI2D5P_tWE1za4/edit?gid=54982496#gid=54982496
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1iOlGUIa-e2Tg07ADHZQ6MMl2T6OIwi4vzB3z3KT2x_U/edit?gid=[PHONE]#gid=[PHONE]
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1ukZclxqiR6uX4vazxSnpFULwsDYn4J8di_sPrc9Cfgg/edit?gid=[PHONE]#gid=[PHONE]
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/18Sv2gzrD6Fv-UHzTUl6v3eBD_9aQRyN08LbbXl1ym9Q/edit?gid=[PHONE]#gid=[PHONE]
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/10GRe5pK0ZAHEZizBYF9mrCHigkHTffayXLvevYTvbtA/edit?gid=[PHONE]#gid=[PHONE]
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1tyb3DwUQHetdEqoMy3k-IaC5Ilgb7iK6kHCAk4SDTdM/edit?gid=[PHONE]#gid=[PHONE]
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1Gpr8vJyQevkQt9LlizZGd7T4fDLTc5r9861E47_gFr8/edit?gid=[PHONE]#gid=[PHONE]
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1DwMWkGhyQmM-GodUpcBEBID5-4kEFTw5Rf1a9Jaqbko/edit?gid=[PHONE]#gid=[PHONE]
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1763ZpmQJWat7lFqVFE0ZvDQp8ST9gmzBjhFhoAUr6s0/edit?gid=[PHONE]#gid=[PHONE]
Spreadsheet: 0a8f0ff3-9a62-4fd0-9f54-565d1c314110
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-09-21 14:57:25.440000
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.872 | 101.747 | 101.622 | 101.247
4.25 | 101.696 | 101.571 | 101.446 | 101.071 |  | Note: | Refer To Price [NAME]
4.125 | 100.727 | 100.602 | 100.477 | 100.102 |  |  | For all Price Adjs
4 | 100.323 | 100.198 | 100.073
3.875 | 99.746 | 99.621 | 99.496
 |  |  |  |  |  | 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.75 | 101.875 | 101.75 | 101.625 | 101.25
3.625 | 101.875 | 101.75 | 101.625 | 101.25
3.5 | 101.694 | 101.569 | 101.444 | 101.069
3.375 | 101.298 | 101.173 | 101.048 | 100.673
3.25 | 100.768 | 100.643 | 100.518
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-10-05 14:57:25.440000
30 DAY | 2011-10-20 14:57:25.440000
45 DAY | 2011-11-04 14:57:25.440000
60 DAY | 2011-11-19 14:57:25.440000
90 DAY | 2011-12-19 14:57:25.440000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 874444d1721041793-transfer-a-table-of-data-into-another-table-but-in-a-different-format-jchandler8314-excel-help-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Outstanding Paperwork
 |  | 2023-02-13 00:00:00 | VEHICLE 1 | VEHICLE 2 | VEHICLE 3
 |  |  |  |  |  |  |  |  |  | Week Commencing | Registration | Inspection required | Update / Notes?
 |  | 2023-02-27 00:00:00 | VEHICLE 6 | VEHICLE 14 |  |  |  |  |  |  | VEHICLE 1
 |  |  |  |  |  |  |  |  |  | 2023-02-13 00:00:00 | VEHICLE 2
 |  | 2023-03-13 00:00:00 | VEHICLE 1 |  |  |  |  |  |  | 2023-02-13 00:00:00 | VEHICLE 3
 |  | 2023-03-20 00:00:00 | VEHICLE 14 |  |  |  |  |  |  | 2023-02-27 00:00:00 | VEHICLE 6
 |  |  |  |  |  |  |  |  |  | 2023-02-27 00:00:00 | VEHICLE 14
 |  | 2023-04-03 00:00:00 | VEHICLE 3 |  |  |  |  |  |  | 2023-03-13 00:00:00 | VEHICLE 1
 |  |  |  |  |  |  |  |  |  | 2023-03-20 00:00:00 | VEHICLE 14
 |  | 2023-04-17 00:00:00 | VEHICLE 6 | VEHICLE 11 |  |  |  |  |  | 2023-04-03 00:00:00 | VEHICLE 3
 |  |  |  |  |  |  |  |  |  | 2023-04-17 00:00:00 | VEHICLE 6
 |  | 2023-05-01 00:00:00 | VEHICLE 3 |  |  |  |  |  |  | 2023-04-17 00:00:00 | VEHICLE 11
 |  |  |  |  |  |  |  |  |  | 2023-05-01 00:00:00 | VEHICLE 3
 |  | 2023-05-15 00:00:00 | VEHICLE 7 |  |  |  |  |  |  | 2023-05-15 00:00:00 | VEHICLE 7