tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 120450d1315311159-how-to-do-this-lookup-copy-of-stats-help
Sheet: Picking Stats

 | ZONE 1 |  |  |  | ZONE 2 |  |  |  | ZONE 3 |  |  |  | ZONE 4 |  |  |  | TOTAL PICK RATE
DATE | PICKED | NOT PICKED | PICKER | PICK RATE | PICKED | NOT PICKED | PICKER | PICK RATE | PICKED | NOT PICKED | PICKER | PICK RATE | PICKED | NOT PICKED | PICKER | PICK RATE
2011-09-05 00:00:00 | 28 | 10 | [NAME] |  | 76 | 7 | [NAME] |  | 8 | 2 | [NAME] |  | 16 | 22 | [NAME]
2011-09-06 00:00:00 | 3 | 2 | [NAME] |  | 24 | 8 | [NAME] |  | 3 | 0 | [NAME] |  | 4 | 3 | [NAME]
2011-09-07 00:00:00 | 13 | 3 | [NAME] |  | 13 | 3 | [NAME] |  | 13 | 3 | [NAME] |  | 13 | 3 | [NAME]
2011-09-08 00:00:00 | 24 | 5 | [NAME] |  | 24 | 5 | [NAME] |  | 24 | 5 | [NAME] |  | 24 | 5 | [NAME]
2011-09-09 00:00:00 | 54 | 15 | [NAME] |  | 54 | 15 | [NAME] |  | 54 | 15 | [NAME] |  | 54 | 15 | [NAME]
2011-09-12 00:00:00
2011-09-13 00:00:00
2011-09-14 00:00:00
2011-09-15 00:00:00
2011-09-16 00:00:00
2011-09-19 00:00:00
2011-09-20 00:00:00
2011-09-21 00:00:00
2011-09-22 00:00:00
2011-09-23 00:00:00
2011-09-26 00:00:00
2011-09-27 00:00:00
2011-09-28 00:00:00
2011-09-29 00:00:00
2011-09-30 00:00:00
2011-10-03 00:00:00
2011-10-04 00:00:00
2011-10-05 00:00:00
2011-10-06 00:00:00
2011-10-07 00:00:00
2011-10-08 00:00:00
Spreadsheet: 00d9646e-2702-49e0-ace1-b5add65f63e9
Sheet: Total

St. Dunstan's Episcopal Church Budgeted Financial Statement by Mission Center October 2012 | 2012 Budget | Actual for Period | Actual YTD | Var. Actual to Annual Budget Dollar | Var. Actual to Annual Budget %
Total Income
Worship
Evangelism
Youth
[NAME]
Children's Formation
Community Life
Pastoral Care
Outreach
Leadership & Support
Campus
Total Expenses
Income Over/(Under) Expenses
Spreadsheet: 221345d1363489644-lookup-and-count-count-female
Sheet: Sheet1

 |  | Company A | [NAME] | F
 |  | Company A | [NAME] | M
 |  | Company A | Lous | M |  | No of Female
 |  | Company A | [NAME] | M | Company A | 1
 |  | Company B | [NAME] | M | Company B | 2
 |  | Company B | [NAME] | M | Company C | 3
 |  | Company B | [NAME] | F
 |  | Company B | Cicelia | F
 |  | Company C | Rem | M
 |  | Company C | [NAME] | F
 |  | Company C | Evie | F
 |  | Company C | Jass | F
 |  | Company C | [NAME] | M
 |  | Company C | [NAME] | M
Spreadsheet: 112978d1308933495-excel-2007-help-in-converting-to-numbers-and-filterring-book1-3-
Sheet: Sheet1

Code | Value1 | Value2
ab12 | € 59.50 | 59.5
ab13 | € 63.75 | 63.75
ab15 | € 528.75 | 528.75
ab17 | € 184.50 | 184.5
ab18 | € 60.75 | 60.75
ab20 | € 92.25 | 92.25
ab21 | € 67.50 | 67.5
ab28 | € 2.25 | 2.25
ab30 | € 9.00 | 9
ab31 | € 54.00 | 54
ab33 | € 129.75 | 129.75
[NAME] | € 4.50 | 4.5
Spreadsheet: 862914d1710487718-if-a-value-exists-in-a-string-return-a-value-in-another-cell-sample1-10-aligw
Sheet: Sheet1

 | Top 3 | Top 4 | Top 4 |  | Winner
 | 4,8,2 |  |  |  | 4
 |  | 4,8,2,1 |  | W | 4 |  |  | if winner (Column F)  exists in Top 3 (Col B) I want W in Column E otherwise L in column E
 |  |  | 4,8,2,1,7 | W | 4
 | 1,2,5 |  |  | W | 1
 |  | 1,2,5,8 |  | W | 1
 |  |  | 1,2,5,8,9 | W | 1
 | 1,5,14 |  |  | L | 4
 |  | 1,5,9,14 |  | L | 4
 |  |  | 1,5,9,14,4,2 | W | 4
 | 2,1,7 |  |  | L | 5
 |  | 2,1,7,3 |  | L | 5
 |  |  | 2,1,5,3,7,6 | W | 5
 | 5,9,10 |  |  | W | 5
 |  | 5,9,10,2 |  | W | 5
 |  |  | 5,9,10,2,4 | W | 5
Spreadsheet: 864800d1711949502-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record-aligw
Sheet: Acrylamide

Raw Material |  | Acrylamide
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 569.264
2023-10-02 00:00:00 |  |  |  |  | 33.3
2023-10-03 00:00:00 |  |  |  |  | 33.3
2023-10-04 00:00:00 |  |  |  |  | 33.3
Total
Spreadsheet: 37677d1235698879-create-list-w-2-or-more-same-subject-header-for-sort-matchlist-1
Sheet: Sheet2

Column1 | cookies
 | ITEMS
Data | Chewy | Grand Total
Count of ITEMS | 1 | 1
Sum of REDS | 8 | 8
Sum of FLAGS | 4 | 4
Count of WHITE | 1 | 1
Sum of FLAG | 2 | 2
Count of BLUES | 1 | 1
Sum of BLUES18 | 15 | 15
Sum of WHITE11 | 25 | 25
Spreadsheet: 124212d1318248625-find-and-move-text-sample-data
Sheet: Sheet1

Input Data |  |  |  |  |  | Output Data
Contract No
Section size | kg/m | m | Qty |  |  | Description | Length | Qty
254x146UB | 43 | 3.6 | 7 |  |  | UB254x146x43 | 3600 | 7
254x146UB | 43 | 4 | 2 |  |  | UB254x146x43 | 4000 | 2
254x146UB | 43 | 5.7 | 1 |  |  | UB254x146x43 | 5700 | 1
203x133UB | 25.1 | 6 | 1
203x133UB | 25.1 | 6.4 | 1
203x133UB | 25.1 | 2.4 | 1
203x133UB | 25.1 | 2 | 1
203x133UB | 25.1 | 3.4 | 1
203x133UB | 25.1 | 2.74 | 1
203x133UB | 25.1 | 1.5 | 1
203x133UB | 25.1 | 7 | 1
203x133UB | 25.1 | 10.5 | 1
203x133UB | 30 | 3.1 | 1
203x133UB | 30 | 2.2 | 1
150x90 PFC | 23.9 | 0.4 | 1
150x90 PFC | 23.9 | 0.5 | 1
150x90 PFC | 23.9 | 0.6 | 1
150x90 PFC | 23.9 | 0.7 | 1
150x150x10 SHS | 43.6 | 2 | 1
150x150x10 SHS | 43.6 | 2.2 | 2
100x100x10 SHS | 27.9 | 3.3 | 1
Spreadsheet: 724423d1616156789-if-function-with-partial-text-match-if-function-problem
Sheet: Problem

[NAME] | Branch | Payments |  | Branches
NK01051 | Kisumu (NK) | 1000 |  | Bondo (ND)
NM00034 |  | 1495 |  | Bungoma (WS)
WS00710 |  | 100 |  | Corporate Sales (M5)
NK00943 |  | 13525 |  | Eldoret (VE)
VK00986 |  | 10000 |  | [NAME] (NH)
NK01083 |  | 10000 |  | Kakamega (WK)
VK00690 |  | 2000 |  | Kapenguria (NG)
WU00417 |  | 300 |  | Kapsabet (RA)
WS00708 |  | 3000 |  | Kisii (NI)
WU00543 |  | 970 |  | Kisumu (NK)
WS00710 |  | 98 |  | Kitale (VK)
NM00096 |  | 100 |  | Mbita (NT)
WU00499 |  | 20000 |  | Migori (NM)
WU00333 |  | 1500 |  | [NAME] (NU)
NH00408 |  | 3500 |  | Oyugis (NO)
M500002 |  | 6500 |  | Siaya (WU)
NH00781 |  | 6400
NM00033 |  | 3000
WU00049 |  | 1000
NH00431 |  | 1000
NM00384 |  | 15000
VK00773 |  | 3067
NM00052 |  | 73
NH00334 |  | 8000
WU00019 |  | 400
NG00078 |  | 20000
NH00711 |  | 4000
NO00152 |  | 10000
NM00613 |  | 9500
NM00539 |  | 12723
WU00193 |  | 1200
VK00458 |  | 7000
WS00710 |  | 49
NH00654 |  | 1500
NG00298 |  | 5000
VK00990 |  | 3500
Total
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 53

कार्यक्रम PROGRAM |  |  | पररर्ियन कार्य (अिंचल कार्ायलर्/क्षेत्रीर् कार्ायलर् के  एमआईपीडी/तर्पणन अनुभाग प्रमुख) FOCUSED PROGRAM FOR RESOURCES SECTION HEADS. | PROG CODE
 |  |  |  | IT 1754
तर्षर् समूह/JOB FAMILY |  |  | INTERNAL CONTROL, INSPECTION & RISK MANAGEMENT
उद्देश्य/OBJECTIVE |  |  | UPSKILLING OF SECTION HEADS
लतक्षि समूह/TARGET GROUP |  |  | [NAME]
अर्तध/DURATION |  |  | 3 DAYS
DAY | SESSION | CONTENTS
Day 1 | I | Inauguration/Knowing   section   level   problems   &   expectations Analysis  of  growth  of  peer  banks  under  deposit  and  strategy  for marketing & sourcing the same; Future Banking
 | II | Publicity & advertisement, Image building & CSR activities, Banker a Marketeer  -  New  Marketing  modules,  Govt.  Business  &  Strategic Planning; Associate products, Monitoring of MOs Digital awareness
 | III | SWOT analysis of Branches/Branch heads and command area, how to use SLBC/LEAD  Bank  data
 | IV | Product  knowledge  &  wallet  maximization,  extending  non-credit concessions, Cost benefit analysis Profit planning, Reduction of Loss making Branches, opening of new Branch
Day 2 | I | Digital  products  &  its  marketing  &  sensitization  to  [NAME]  staff, CARD, POS
 | II | [NAME] service policies viz., Customer Protection policy, Customer Rights Policy ATM Cash Transaction Dispute and [NAME],  Cheques  Collection  Policy,  Compliance  Policy, Customer Limited Liability Policy, Dishonor of Cheques policy, Social Media Policy, RTI, CPGRS, Ombudsman How to minimize customer complaints & Grievances
 | III | KYC, E-KYC, C-KYC, AML. Use of Technology in these aspects How to conduct structured periodical review of branches.
 | IV | Preventive Vigilance - Stitch in Time Saves Nine
Day 3 | I | Frontline Customer Service; Tips for Improvement
 | II & III | Achievement Motivation – Personal and Organizational Growth
 | IV | Business Ethics and Value Systems; Valediction
Spreadsheet: 0e7d636a-cb70-44d7-9993-a151dbd1b018
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  |  |  |  |  |  | Embryo Cryopreservation Request Form
 |  |  |  |  |  |  | University of Maryland, Baltimore    School of Medicine Transgenic Core Laboratory   Howard Hall 581    [PHONE]
 |  |  |  |  |  | Request Date
 |  |  |  |  |  | PI Name |  |  |  |  | Campus Address
 |  |  |  |  |  | Greenebaum Cancer Center Member? |  |  |  |  | (Office)
 |  |  |  |  |  |  | YES | NO |  |  | (Lab)
 |  |  |  |  |  | Department
 |  |  |  |  |  | Phone |  |  |  |  | email
 |  |  |  |  |  | Lab Contact |  |  |  |  | email
 |  |  |  |  |  | Chartstring to be charged
 |  |  |  |  |  | Strain for Cryopreservation:
 |  |  |  |  |  | (include strain backgroud in description)
 |  |  |  |  |  | Name Designation of Strain:
 |  |  |  |  |  | Indicate Genetic Status of Strain: |  |  |  |  | HOMOZYGOUS |  |  | HETEROZYGOUS
 |  |  |  |  |  | Will Cryopreserved Embryos be Thawed Within 6 Months? |  |  |  |  |  |  | YES | NO
 |  |  |  |  |  | Animal Space Location: |  |  |  |  |  | ARF# |  | Exp. Date
 |  |  |  |  |  |  |  |  |  |  |  | Please include a copy of your protocol approval letter
 |  |  |  |  |  | Note: | 5 (minimum)-10 (optimal) fertile, experienced, adult males 2-4 months of age are required for all cryo
 |  |  |  |  |  |  | projects. IF YOU DO NOT HAVE 5-10 PROVEN BREEDERS OF THE APPROPRIATE AGE DO NOT REQUEST
 |  |  |  |  |  |  | EMBRYO CRYOPESERVATION. Males are mated to wild type females of the same (or closely related) strain
 |  |  |  |  |  |  | and the resulting embryos are cryopreserved. Homozygous males give heterozygous embryos;
 |  |  |  |  |  |  | heterozygous males give half heterozygous embryos and half wild type (null) embryos. Approximately 200
 |  |  |  |  |  |  | embryos should be frozen per project. A test thaw is included in the cryopreservation cost to determine
 |  |  |  |  |  |  | efficiency of cryopreservation for your strain. Genotyping may be required to determine cryopreservation
 |  |  |  |  |  |  | efficiency, this will be the responsibility of the requesting PI. Males can be returned at project completion.
 |  |  |  |  |  |  | Pricing is for set-up and one day of cryopreservation, test thaw, and transfers.
 |  |  |  |  |  |  | Additional days of cryopreservation incur additional charges. Use of only 5 males will require additional days.
 |  |  |  |  |  |  |  |  |  |  | ALLCRYOPRESERVATION PROJECTS REQUIRE CONSULTATION
 |  |  |  |  |  |  |  |  |  |  | WITH TRANSGENIC LAB STAFF PRIOR TO INITIATION
 |  |  |  |  |  | PI Signature: |  |  |  |  |  |  |  | Date
 |  |  |  |  |  | Transgenic Lab Approval: |  |  |  |  |  |  |  | Date
 |  |  |  |  |  | Return this completed form to: Transgenic Core Facility, [NAME] (FAX [PHONE])
 |  |  |  |  |  | This form and all requested information and supporting data must be received prior to project initiation
Spreadsheet: 327598d1403624151-need-to-add-another-field-to-my-vlookup-formula-or-possibly-need-a-new-formula-old-vs-new-breakdown
Sheet: New Breakdown

State | Rep | Term Digits
AK | Sotheavy | All
AL |  | All
AR |  | All
AZ |  | All
CA |  | All
CO |  | All
CT |  | All
DC |  | All
DE |  | All
FL | Sotheavy | 00-14
FL | [NAME] | 15-28
FL | Sophany | 29-42
FL | Danielle | 43-56
FL | [NAME] | 57-71
FL | Dameyan | 72-85
FL | [NAME] | 86-99
GA |  | All
HI |  | All
IA |  | All
ID |  | All
IL |  | All
IN |  | All
KS |  | All
KY |  | All
LA |  | All
MA |  | All
MD |  | All
ME |  | All
MI |  | All
MN |  | All
MO |  | All
MT |  | All
MS |  | All
NC | Sotheavy | 00-14
NC | [NAME] | 15-28
NC | Sophany | 29-42
NC | Danielle | 43-56
NC | [NAME] | 57-71
NC | Dameyan | 72-85
NC | [NAME] | 86-99
ND |  | All
NE | [NAME] | All
NH |  | All
NJ | Sotheavy | 00-14
NJ | [NAME] | 15-28
NJ | Sophany | 29-42
NJ | Danielle | 43-56
NJ | [NAME] | 57-71
NJ | Dameyan | 72-85
NJ | [NAME] | 86-99
NM |  | All
NV |  | All
NY | Sotheavy | 00-14
NY | [NAME] | 15-28
NY | Sophany | 29-42
NY | Danielle | 43-56
NY | [NAME] | 57-71
NY | Dameyan | 72-85
NY | [NAME] | 86-99
OH | Sotheavy | 00-14
OH | [NAME] | 15-28
OH | Sophany | 29-42
OH | Danielle | 43-56
OH | [NAME] | 57-71
OH | Dameyan | 72-85
OH | [NAME] | 86-99
OK |  | All
OR |  | All
PA |  | All
PR | Sotheavy | All
RI |  | All
SC |  | All
SD | Danielle | All
TN |  | All
TX |  | All
UT |  | All
VA |  | All
VI | Sotheavy | All
VT |  | All
WA |  | All
WI |  | All
WV |  | All
Spreadsheet: 66391d1267049554-lookup-up-multiple-variables-question-1-
Sheet: Sheet1

Table A | Ref | Prod | Date |  | Table B | Ref | Prod | Date
 | 123 | ABC | 2010-02-24 00:00:00 |  |  | 123 | ABC | 2010-02-05 00:00:00
 | 123 | DEF | 2010-02-23 00:00:00 |  |  | 123 | ERT | 2010-05-17 00:00:00
 | 123 | ERT | 2010-05-08 00:00:00 |  |  | 234 | KLM | 2010-02-24 00:00:00
 | 234 | KLM | 2010-02-24 00:00:00 |  |  | 354 | RST | 2010-02-23 00:00:00
 | 354 | RST | 2010-02-23 00:00:00 |  |  | 789 | DEF | 2010-02-21 00:00:00
 | 354 | ABC | 2010-05-10 00:00:00 |  |  | 354 | PQR | 2010-02-24 00:00:00
 | 354 | PQR | 2010-02-24 00:00:00 |  |  | 354 | HIJ | 2010-02-23 00:00:00
 | 354 | HIJ | 2010-02-23 00:00:00 |  |  | 456 | ABC | 30/02/2010
 | 456 | ABC | 2010-02-24 00:00:00 |  |  | 456 | KLM | 2010-02-24 00:00:00
 | 456 | KLM | 2010-02-24 00:00:00 |  |  | 567 | VWX | 2010-02-24 00:00:00
 | 456 | XYZ | 2010-02-19 00:00:00
 | 567 | VWX | 2010-02-24 00:00:00
Spreadsheet: 712760d1610393577-finding-out-the-name-of-the-most-expensive-item-in-the-product-group-fruits-you-probably-have-never-seen
Sheet: Lapas1

Article group | Article discription | Price | Name of most expensive article in group
1 | Blue Apples | 266.38 | Orange Banana
6 | Red Cucumber | 128.94 | Orange Banana
8 | [NAME] | 102.88 | [NAME]
4 | Green Cherry | 301 | Red Cucumber
3 | Red Cucumber | 299.5 | Red Cucumber
5 | Black Carrot | 287.55 | Blue Apples
5 | Black Carrot | 212.2 | Blue Apples
5 | Blue Apples | 82.78 | Blue Apples
8 | [NAME] | 810 | [NAME]
9 | Red Cucumber | 324.51 | Red Cucumber
6 | Orange Banana | 137.94 | Orange Banana
3 | Orange Banana | 274.8 | Red Cucumber
1 | Blue Apples | 139.5 | Orange Banana
7 | Red Cucumber | 182.3 | Red Cucumber
4 | Red Cucumber | 697 | Red Cucumber
5 | Blue Apples | 563.52 | Blue Apples
2 | Orange Banana | 141.75 | Blue Apples
8 | Green Cherry | 418.3200000000001 | [NAME]
8 | Black Carrot | 245 | [NAME]
4 | Blue Apples | 80.07000000000001 | Red Cucumber
7 | Green Cherry | 68.22 | Red Cucumber
5 | [NAME] | 206.2 | Blue Apples
6 | Green Cherry | 67.05000000000001 | Orange Banana
1 | Orange Banana | 85.36 | Orange Banana
1 | Orange Banana | 298.88 | Orange Banana
3 | Red Cucumber | 299 | Red Cucumber
1 | Black Carrot | 123.25 | Orange Banana
1 | Red Cucumber | 181.3 | Orange Banana
2 | Blue Apples | 855.6 | Blue Apples
Spreadsheet: 85942d1285936390-lookup-match-confusion-lookupmatch
Sheet: Sheet1

5 | 3 | 2 | 3 | 6 | 4
4 | 5 | 3 | 3 | 4 | 6
3 | 7 | 5 | 5 | 6 | 7
2 | 5 | 6 | 7 | 6 | 6
1 | 3 | 4 | 5 | 7 | 8
 | 1 | 2 | 3 | 4 | 5
First Value:
Second Value:
Result:
Spreadsheet: 130852d1322619643-matching-dates-and-returning-another-column-instructor
Sheet: Sheet3

 |  |  |  |  |  | Instructor resource
 |  |  | Period 1 |  |  | 1
 |  |  | Period 2 |  |  | 1
 |  |  | Period 3 |  |  | 1
 |  |  | Period 4 |  |  | 1
 |  |  | Period 5 |  |  | 1
 |  |  | Period 6 |  |  | 1
 |  |  | Period 7 |  |  | 1
 |  |  | Period 8 |  |  | 1
 |  | 2012-01-19 00:00:00 | Period 9 |  |  | 1
 |  |  | Period 1 |  |  | 0
 |  |  | Period 2 |  |  | 0
 |  |  | Period 3 |  |  | 0
 |  |  | Period 4 |  |  | 0
 |  |  | Period 5 |  |  | 0
 |  |  | Period 6 |  |  | 2
 |  |  | Period 7 |  |  | 2
 |  |  | Period 8 |  |  | 2
 |  | 2012-01-20 00:00:00 | Period 9 |  |  | 2
 |  |  | Period 1
 |  |  | Period 2
 |  |  | Period 3
 |  |  | Period 4
 |  |  | Period 5
 |  |  | Period 6
 |  |  | Period 7
 |  |  | Period 8
 |  | 2012-01-21 00:00:00 | Period 9
 |  |  | Period 1
 |  |  | Period 2
 |  |  | Period 3
 |  |  | Period 4
 |  |  | Period 5
 |  |  | Period 6
 |  |  | Period 7
 |  |  | Period 8
 |  | 2012-01-22 00:00:00 | Period 9
 |  |  | Period 1
 |  |  | Period 2
 |  |  | Period 3
 |  |  | Period 4
 |  |  | Period 5
 |  |  | Period 6
 |  |  | Period 7
 |  |  | Period 8
 |  | 2012-01-23 00:00:00 | Period 9
Spreadsheet: 780086d1652283768-cumulative-dynamic-array-per-nth-column-cumulative-sum-per-nth-column
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Moving Columns |  | 4
Desired Result per 4 (cell C5) columns
Spreadsheet: bf809635-78f1-48c2-aeb7-306d19fb1d1f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-02-16 09:22:01.190000
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.25 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.125 | 101.761 | 101.636 | 101.511 | 101.136
4 | 101.313 | 101.188 | 101.063 | 100.688 |  | Note: | Refer To Price [NAME]
3.875 | 100.407 | 100.282 | 100.157 | 99.782 |  |  | For all Price Adjs
3.75 | 99.702 | 99.577 | 99.452 | 98.827
3.625 | 99.249 | 99.124 | 98.999 | 98.374
3.5 | 98.743 | 98.618 | 98.493 | 97.868
 |  |  |  |  |  | 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.625 | 102.048 | 101.923 | 101.798 | 101.423
3.5 | 101.708 | 101.583 | 101.458 | 101.083
3.375 | 101.167 | 101.042 | 100.917 | 100.542
3.25 | 100.52 | 100.395 | 100.27 | 99.895
3.125 | 99.905 | 99.78 | 99.655 | 99.03
3 | 99.562 | 99.437 | 99.312 | 98.687
2.875 | 98.989 | 98.864 | 98.739 | 98.114 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-03-01 09:22:01.190000
30 DAY | 2012-03-16 09:22:01.190000
45 DAY | 2012-03-31 09:22:01.190000
60 DAY | 2012-04-15 09:22:01.190000
90 DAY | 2012-05-15 09:22:01.190000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 2fbc83b9-eb27-433b-b8bb-555ac5762c60
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
CARITA NATIONAL FINAL RESULTS
TEAM RESULTS
Under 11 Girls
School | Total |  |  | Group | Floor | Vault
Maltmans Green | 102.15 | 1 | 1 | 27.9 | 36.85 | 37.4
Streatham & Clapham | 98.75999999999999 | 2 | 2 | 27.85 | 34.61 | 36.3
Tormead | 97.05000000000001 | 3 | 3 | 26.75 | 34.45 | 35.85
Haberdashers Askes | 92.00999999999999 | 4 |  | 26.3 | 31.16 | 34.55
Norden | 89.75 | 5 |  | 24.65 | 30.55 | 34.55
Carsfield | 88.53999999999999 | 6 |  | 24.85 | 29.59 | 34.1
Coppice | 86.12 | 7 |  | 24.95 | 27.02 | 34.15
Stanwix | 84.45 | 8 |  | 24.75 | 25.1 | 34.6
Catcott | 83.5 | 9 |  | 23.85 | 25.65 | 34
Under 11 Boys
School | Total |  |  | Group | Floor | Vault
Chalfont St Peters | 96.25 | 1 | 1 | 24.95 | 35.2 | 36.1
Newcastle RGS | 91.6 | 2 | 3= | 23.3 | 33 | 35.3
Mundella | 89.4 | 3 |  | 22.65 | 33.1 | 33.65
Coppice | 89.1 | 4 | 2 | 23.6 | 31.9 | 33.6
[NAME] | 87.30000000000001 | 5 |  | 22.6 | 32 | 32.7
Great Dunmow | 84.4 | 6 | 3= | 23.3 | 27.8 | 33.3
Marpool | 80.35 | 7 |  | 18.55 | 29.4 | 32.4
Under 16 Girls
School | Total |  |  | Group | Floor | Vault
Craigmount | 100.81 | 1 |  | 26.75 | 35.86 | 38.2
Streatham & Clapham | 100.42 | 2 | 3 | 26.85 | 35.62 | 37.95
Tormead | 99.44 | 3 | 1 | 27.75 | 35.09 | 36.6
Coopers Coborn | 98.5 | 4 | 2 | 26.9 | 34.35 | 37.25
West Kirby | 94.78 | 5 |  | 26.4 | 32.88 | 35.5
Beaconsfield | 94.75 | 6 |  | 26.15 | 33.15 | 35.45
[NAME] | 94.4 | 7 |  | 25.25 | 33.35 | 35.8
Brussels | 92.33 | 8 |  | 26.15 | 31.48 | 34.7
Newfield | 92.21000000000001 | 9 |  | 25.75 | 32.31 | 34.15
[NAME] | 89.75999999999999 | 10 |  | 24.5 | 31.11 | 34.15
Trinity | 89.03 | 11 |  | 25.5 | 29.03 | 34.5
Lees Brooke | 88.42 | 12 |  | 25.45 | 29.42 | 33.55
Under 16 Boys
School | Total |  |  | Group | Floor | Vault
Newcastle RGS | 97.4 | 1 | 1 | 25 | 35.7 | 36.7
Fitzwimarc | 92.05 | 2 | 3 | 22.75 | 34.3 | 35
[NAME] | 91 | 3 | 2 | 23 | 32.9 | 35.1
Spreadsheet: 756708d1637722646-drop-down-link-to-table-test
Sheet: BOM IFD

PASTE ENTIRE TABLE IN CELL A1
IFD Design Rainfall Intensity (mm/h)
Issued:
Location Label:
Requested coordinate:
Nearest grid cell:
 |  | Annual Exceedance Probability (AEP)
Duration | Duration in min | 0.632 | 0.5 | 0.2 | 0.1 | 0.05 | 0.02 | 0.01
1 min | 1 | 98.9 | 109 | 144 | 169 | 195 | 231 | 260
2 min | 2 | 86 | 94.6 | 123 | 143 | 163 | 193 | 217
3 min | 3 | 77 | 84.7 | 110 | 129 | 148 | 175 | 197
4 min | 4 | 69.9 | 77.1 | 101 | 118 | 136 | 161 | 182
5 min | 5 | 64.3 | 71 | 93.2 | 109 | 126 | 149 | 168
6 min | 6 | 59.6 | 65.9 | 86.8 | 102 | 117 | 139 | 157
10 min | 10 | 46.9 | 52 | 68.7 | 80.8 | 93.2 | 110 | 124
15 min | 15 | 37.8 | 41.9 | 55.4 | 65.1 | 75 | 88.7 | 99.7
20 min | 20 | 32.1 | 35.6 | 46.9 | 55.1 | 63.4 | 74.9 | 84.2
25 min | 25 | 28.1 | 31.1 | 41 | 48.1 | 55.3 | 65.4 | 73.4
30 min | 30 | 25.2 | 27.8 | 36.6 | 42.9 | 49.3 | 58.3 | 65.5
45 min | 45 | 19.5 | 21.6 | 28.2 | 33.1 | 38 | 45 | 50.7
1 hour | 60 | 16.3 | 17.9 | 23.4 | 27.4 | 31.6 | 37.5 | 42.3
1.5 hour | 90 | 12.6 | 13.8 | 17.9 | 21 | 24.3 | 29 | 33
2 hour | 120 | 10.4 | 11.4 | 14.9 | 17.5 | 20.2 | 24.3 | 27.7
3 hour | 180 | 8.05 | 8.8 | 11.4 | 13.5 | 15.7 | 19 | 21.8
4.5 hour | 270 | 6.21 | 6.79 | 8.83 | 10.4 | 12.2 | 14.9 | 17.2
6 hour | 360 | 5.17 | 5.65 | 7.36 | 8.72 | 10.2 | 12.5 | 14.5
9 hour | 540 | 3.99 | 4.36 | 5.69 | 6.75 | 7.93 | 9.74 | 11.3
12 hour | 720 | 3.32 | 3.63 | 4.74 | 5.62 | 6.6 | 8.09 | 9.4
18 hour | 1080 | 2.55 | 2.8 | 3.64 | 4.31 | 5.03 | 6.14 | 7.1
24 hour | 1440 | 2.11 | 2.32 | 3.01 | 3.54 | 4.11 | 4.98 | 5.73
30 hour | 1800 | 1.82 | 2 | 2.59 | 3.04 | 3.5 | 4.21 | 4.81
36 hour | 2160 | 1.61 | 1.77 | 2.29 | 2.67 | 3.06 | 3.65 | 4.15
48 hour | 2880 | 1.33 | 1.46 | 1.88 | 2.17 | 2.46 | 2.9 | 3.26
72 hour | 4320 | 1.02 | 1.11 | 1.42 | 1.62 | 1.81 | 2.1 | 2.32
96 hour | 5760 | 0.841 | 0.923 | 1.17 | 1.33 | 1.47 | 1.69 | 1.85
120 hour | 7200 | 0.73 | 0.8 | 1.01 | 1.15 | 1.27 | 1.45 | 1.58
144 hour | 8640 | 0.654 | 0.716 | 0.904 | 1.03 | 1.14 | 1.3 | 1.42
168 hour | 10080 | 0.599 | 0.655 | 0.828 | 0.944 | 1.06 | 1.21 | 1.32
 |  | 1 Year  63% AEP | 2 Year  50% AEP | 4.48 Year  20% AEP | 10 Year  10% AEP | 20 Year  5% AEP | 50 Year  2% AEP | 100 Year  1% AEP