tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 271738d1382031277-conditional-vlookup-call-log-sample
Sheet: Sheet1

 | Name_Surname | Dialled_DIGITS | Out_Call_Type
 | [NAME] | 453236458 | P
 | ISAAC | 453005468 | P
 | MELISSA | 453639940 | P
 | Kelly | 462569801 | T
 | [NAME] | 534589378 | P
 | SYDWELL | 167093464 | P
 | Chad | 237643982 | T
 | [NAME] | 936945357 | P
 | [NAME] | 166795646 | T
 | Cenotia | 704694128 | P
 | [NAME] | 644597318 | T
 | Samantha | 234236497 | P
 | Out_Call_Type | P
 | Row Labels | Dialled_DIGITS
 | Cenotia | 704694128
 | ISAAC | 453005468
 | [NAME] | 936945357
 | [NAME] | 453236458
 | MELISSA | 453639940
 | Samantha | 234236497
 | SYDWELL | 167093464
 | [NAME] | 534589378
 | Grand Total
Spreadsheet: 850351d1700720968-retrieve-all-entries-of-data-based-on-several-criteria-help-2-aligw
Sheet: Sheet1

Individual
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Individual | FY Qtr | Status
 |  |  |  |  |  |  |  |  |  |  |  |  | - | - | -
 | Q1-2024 | Q2-2024 | Q3-2024 | Total |  |  |  |  |  |  |  |  | [NAME] | Q1-2024 | Likely
Value |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Q2-2024 | Unlikely
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Q3-2024
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Q4-2024
 |  |  |  |  |  |  |  |  |  |  |  | THIS INFORMATION LIVES IN DIFFERENT WORKSHEETS
 |  |  |  |  |  |  |  |  |  |  |  |  | Main | Contributor | Status | Name | Value | Date | Open Duration | Qtr
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Likely | Job 1 | 949341.5571235716 | 2023-09-18 00:00:00 | 300 | Q1-2024
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | Unlikely | Job 2 | 620542.7314814815 | 2023-09-18 00:00:00 | 22 | Q1-2024
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Unlikely | Job 3 | 607525.4421148185 | 2023-09-18 00:00:00 | 25 | Q1-2024
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Unlikely | Job 4 | 523661.7935816891 | 2024-06-01 00:00:00 | 500 | Q3-2024
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | Likely | Job 5 | 450526.5480562501 | 2023-09-18 00:00:00 | 20 | Q1-2024
FY Qtr | Status |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Likely | Job 6 | 446820.7080492995 | 2023-09-18 00:00:00 | 333 | Q1-2024
Q1-2024 | Unlikely |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Unlikely | Job 7 | 423105.9867414866 | 2023-09-18 00:00:00 | 641 | Q2-2024
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Unlikely | Job 8 | 410648.018245858 | 2024-02-01 00:00:00 | 95 | Q3-2024
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | Likely | Job 9 | 394325.80825093 | 2024-06-01 00:00:00 | 661 | Q1-2024
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Unlikely | Job 10 | 374007.5766874127 | 2023-09-18 00:00:00 | 22 | Q1-2024
Name | Value | Date | Open Duration |  |  |  |  |  |  |  |  |  | [NAME] |  | Unlikely | Job 11 | 369480.0642801212 | 2023-09-18 00:00:00 | 258 | Q2-2024
 | 620542.7314814815 | 2023-09-18 00:00:00 | 22 |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | Unlikely | Job 12 | 363119.7857068661 | 2024-02-01 00:00:00 | 211 | Q3-2024
Job 3 | 607525.4421148185 | 2023-09-18 00:00:00 | 25 |  |  |  |  |  |  |  |  |  | [NAME] |  | Likely | Job 13 | 352942.7583610414 | 2024-06-01 00:00:00 | 100 | Q1-2024
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Likely | Job 14 | 352512.5646852856 | 2023-09-18 00:00:00 | 5446 | Q1-2024
 |  |  |  | Question: Is it possible for this table from A27 to D46 to autopopulate the fields from the information in N15 to U29 based on the infidvidual selected in A2, the FYQtr in A21 and Status in B22  The query: - If I select Q1-2024 and Likely status in cells A & B 22  -show me the information (Name, Value, Date, Open Duration)  -for the individual in A2 if they are the 'Main' or 'Contributor'    I have just linked for the pupose of this example to demonstrate what i want the formula to automatically do
Spreadsheet: 153535d1335957270-excel-2007-small-function-in-an-array-test2
Sheet: Sheet1

DATE | 2012-01-01 00:00:00 | 2012-01-08 00:00:00 | 2012-01-15 00:00:00 | 2012-01-22 00:00:00 | 2012-01-29 00:00:00 | 2012-02-05 00:00:00 | 2012-02-12 00:00:00 | 2012-02-19 00:00:00 | 2012-02-26 00:00:00 | 2012-03-04 00:00:00 | 2012-03-11 00:00:00 | 2012-03-18 00:00:00 | 2012-03-25 00:00:00 | 2012-04-01 00:00:00 | 2012-04-08 00:00:00 | 2012-04-15 00:00:00 | 2012-04-22 00:00:00 | 2012-04-29 00:00:00 | 2012-05-06 00:00:00 | 2012-05-13 00:00:00 | 2012-05-20 00:00:00
 | 38 | 36 | 40 | 38 | 42 | 36 | 38 | 41 | 35 |  |  | 39 |  | 41
Spreadsheet: 67212d1267801473-excel-2007-vlookup-with-multiple-results-separated-by-commas-scoi-report-3-1-10-thru-3-7-10
Sheet: Totals

 | 2010-03-01 00:00:00 |  |  |  |  |  | Thru
Technician | Tech # | Total SCOI | DIGI PRB | CONV PRB | HSI OUT | HSI NTWK | HSI SPEED | DVR | HDTV | POOR PIX | NO PIX | CDV NDT | CDV CALQ | CDV PHJ | CDV CONP | VOD | AUD PRB | RPT T/C | CCO-RF | COMM ACC | BCV-NDT | CABLE CRD | MULTIPLE | 2ND TVPRB | INGRESS | LINE PIX | FLSH PIX | SING OUT | PREM/PPV | SDV PRB | [NAME] | CDV FSIK | HSD FSIK | CCO-MODM | CCO-IP G | CCO-HOSP | BCV-DEG | DRP DWN | NWCBLGRD | SPP | SPP NA | SPP DECL | NOPAYCON | ALLPDOUT | SCI60DAY | DTAPROB | T2WPROB | ESC TC
[NAME] | 6402
[NAME] | 6414
[NAME] | 6418
[NAME] | 6464
[NAME] | 6465
[NAME] | 6466
[NAME] | 6468
[NAME] | 6472
[NAME] | 6475
[NAME] | 6482
[NAME] | 6485
[NAME] | 6409
Spreadsheet: 1fbaafda-7640-4a13-9551-073ac8b98b44
Sheet: UVA Leadership Pilot

Grant: |  | Title 1A UVA Leadership Pilot |  |  |  |  |  | Title 1A UVA Leadership Pilot
CFDA # |  | 84.010 |  |  |  |  |  | FY2012-13
GRANT NUMBER: |  | 5010
FISCAL YEAR: |  | 2012-13
[NAME]: |  | Not allowed on this grant
Question regarding payments: |  | [NAME]   [PHONE] or [EMAIL]
Questions regarding grant: |  | [NAME]6389 or [EMAIL]
LAST DAY TO SUBMIT REQUESTS FOR THIS GRANT  - November 15, 2013
Code | District Name | School Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | DECEMBER 2012 | JANUARY 2013 | FEBRUARY 2013 | MARCH 2013 | APRIL 2013 | MAY 2013 | JUNE 2013 | JULY 2013 | AUGUST 2013 | SEPTEMBER 2013 | OCTOBER 2013 | NOVEMBER 2013
30 | Adams 14 | [NAME], [NAME], Adams City Middle School | 157141 |  |  |  | 32009 | 46875 |  | 11452 |  | 17043 | 1848
123 | [NAME] | [NAME], Middle, and [NAME] | 108200 |  |  |  |  |  | 58800 |  |  | 9400 |  | 31600
3140 | Weld County | Weld County | 231000 |  |  |  |  |  |  |  |  |  |  |  | 36000
Spreadsheet: kevin_hyatt__19592__ProjReqForm
Sheet: Req-Chkist

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Origination Date:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enron Transportation Services |  |  |  |  |  |  |  |  | Revision Date:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project Request/Checklist |  |  |  |  |  |  |  |  |  |  | Revision #: | 0
General Information:
Requestor Name: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Location/Dept.:
Request Number: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Required Date:
Project Name:
Cust. Rep. [NAME]/Phone:
Pipeline: |  |  |  | scsc |  |  |  |  |  |  |  |  |  |  | Other:
System/Line No.: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Connection Mile Post:
 |  |  |  | Facilty Planner: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Region:
Project Location(s):
Scope:
Design Parameters:
 |  |  |  |  |  |  | Conditions | minimum |  |  | normal |  |  | high |  |  |  |  |  |  |  | Characteristics | minimum |  |  | normal |  |  | high
 |  |  |  |  |  |  | Pressure (psig) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H2O (lbs/MMcf)
 |  |  |  |  |  |  | Volume (MMcfd) |  |  |  |  |  |  |  |  |  |  | H2S
 |  |  |  |  |  |  | Gas Quality (BTU, dry) |  |  |  |  |  |  |  |  |  |  | CO2
 |  |  |  |  |  |  | Gas Quality (SG) |  |  |  |  |  |  |  |  |  | other comp.-units
 |  |  |  |  |  |  | System MAOPs(psig) |  | [NAME] |  |  |  |  | dwnstrm |  |  | other comp.-units
Facilities:
 |  |  | Measurement: |  |  |  |  |  |  |  |  |  | Compression: |  |  |  |  |  |  |  |  |  |  | Power:
 |  |  | Regulation: |  |  |  |  |  |  |  |  |  | Piping: |  |  |  |  |  |  |  |  |  |  | Other:
 |  |  |  |  |  |  |  |  |  | Gas Treating Fac. (select all that apply): |  | Other: |  |  |  |  |  |  |  |  |  |  |  | Other:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other:
 | Describe Facility Ownership/Operation:
Notifications:
 |  |  |  |  | Regulatory: |  |  |  |  |  | Type:
 |  |  |  |  | Environmental:
 |  |  |  |  | Legal Review: |  |  |  |  |  |  |  |  |  | Right-of-Way: |  |  |  |  |  |  |  |  |  | Landowner:
Estimated Costs:
 |  |  |  |  |  | Materials | 0 |  |  |  |  |  |  |  |  |  | Engineering | 0 |  |  |  |  |  |  |  | Contingency | 0
 |  |  |  |  |  | Labor & Equipment | 0 |  |  |  |  |  |  |  |  |  | Contract Installation | 0
 |  |  |  |  |  | Environmental | 0 |  |  |  |  |  |  |  |  |  | Overhead | 0 |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  | Construction Support | 0 |  |  |  |  |  |  |  |  |  | Other | 0
Comments:
Spreadsheet: 762118d1641400972-need-formula-that-satisfies-3-criteria-for-text-in-a-cell-forum-sample
Sheet: Sheet1

 |  |  | DESIRED RESULT
1PR | BWGG | INSERT FORMULA | G |  |  | CRITERIA
NR | OWGR | INSERT FORMULA |  |  |  | 1. Col A must contain  "1PR"
NR | BPWO | INSERT FORMULA |  |  |  | 2. Col B must contain any of the same Letters twice any any order
1PR | PWWG | INSERT FORMULA | W |  |  | 3. Which ever letter appears twice in the cell in Col A, that letter must be displayed in Col C, where the formula is inserted
1PR | YPWW | INSERT FORMULA | W
1PR | PROP | INSERT FORMULA | P
1PR | RPBB | INSERT FORMULA | B
1PR | OROW | INSERT FORMULA | O
ALL | RRRR | INSERT FORMULA
1PR | YOWO | INSERT FORMULA | O
2PR | GRGR | INSERT FORMULA
NR | BYWO | INSERT FORMULA
Spreadsheet: 723335d1615641199-conditional-formatting-and-color-cells-with-formula-changecolor-1-
Sheet: Blad1

I thought it was simple to make a formula with conditional formatting. I didn't succeed to use it if the number is 1 or 2. If its empty of filled it was no probem
amount | inside | outside |  |  |  |  |  |  |  |  |  |  |  | project | amount | inside | outside
1 | x |  |  |  |  |  |  |  |  |  |  |  |  | 5129 | 1 |  | nl
1 |  | x |  | kolum A can change the number 1 or 2 |  |  |  |  |  |  |  |  |  | 5129 | 1
1 |  |  |  | kolum B and C needs to change color till correct or incorrect |  |  |  |  |  |  |  |  |  | 5129 | 1 | g | nl
1 | x | x |  | i want to see the result when i filled one row (by example A2) |  |  |  |  |  |  |  |  |  | 5130 | 2 | willem | wing
2 | x | x |  |  |  |  |  |  |  |  |  |  |  | 5130 | 2
2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5130 | 2 | willem | wing
2 | x |  |  | amount | inside | outside |  |  |  |  |  |  |  | 5131 | 1 | willem
2 |  | x |  |  |  |  |  |  |  |  |  |  |  | 5131 | 1 | nl
"" |  |  |  |  |  |  |  |  |  |  |  |  |  | 5131 | 1 | nl
 |  |  |  | If E9=1 And F9=X: G9="" then F9andG9 has to become green |  |  |  |  |  |  |  |  |  | 5131 | 1 | ik
 |  |  |  | If E9=1 And F9=""; G9=X then F9andG9 has to become green |  |  |  |  |  |  |  |  |  | 5132 | 2 | ik | ast
 |  |  |  | So if i fill the cells in E9, F9 and G9 it has to become green or red. Like example |  |  |  |  |  |  |  |  |  | 5133 | 2 | ik
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5133 | 2
another question is? If see example O1:R19. that i can count in colom O how many nl there are and how many willem etc. This names are random. Also seperate for colom P |  |  |  |  |  |  |  |  |  |  |  |  |  | 5134 | 2 | ik | nl
The most important for me is that the colors change wenn i fill in the names. That for me to control of i use the right amount of people |  |  |  |  |  |  |  |  |  |  |  |  |  | 5134 | 2 |  | nl
forms and tekst in A1 is the example what could be posiible E3 is the meaning |  |  |  |  |  |  |  |  |  |  |  |  |  | 5134 | 2 | rene | rene
E8 is x is example , it would be names that are filled in the cells, see [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 5135 | 1 |  | rene
A15 is the meaning that it would be simple for me to count how many i need form customer nl and how much from customer willem etc> |  |  |  |  |  |  |  |  |  |  |  |  |  | 5135 | 1 |  | ics
Spreadsheet: 762581d1641644060-consecutive-dates-to-from-and-to-sickness-report
Sheet: Sheet1

RAW DATA |  |  |  |  | Expected Data
Name | Date |  |  |  | Name | From | To
AAB | 09/12/2021 |  |  |  | AAB | 2021-12-09 00:00:00 | 2021-12-09 00:00:00
AAB | 16/12/2021 |  |  |  | AAB | 2021-12-16 00:00:00 | 2021-12-21 00:00:00
AAB | 17/12/2021 |  |  |  | AP | 2021-12-29 00:00:00 | 2021-12-29 00:00:00
AAB | 18/12/2021 |  |  |  | AP | 2021-12-15 00:00:00 | 2021-12-15 00:00:00
AAB | 19/12/2021 |  |  |  | AR | 2021-12-16 00:00:00 | 2021-12-16 00:00:00
AAB | 20/12/2021 |  |  |  | AR | 2021-12-20 00:00:00 | 2021-12-21 00:00:00
AAB | 21/12/2021 |  |  |  | AR | 2021-12-23 00:00:00 | 2021-12-23 00:00:00
AP | 29/12/2021 |  |  |  | AR | 2021-12-25 00:00:00 | 2021-12-25 00:00:00
AP | 15/12/2021 |  |  |  | AF | 2021-12-18 00:00:00 | 2021-12-24 00:00:00
AR | 16/12/2021 |  |  |  | AS | 2021-12-08 00:00:00 | 2021-12-09 00:00:00
AR | 20/12/2021 |  |  |  | AS | 2021-12-11 00:00:00 | 2021-12-11 00:00:00
AR | 21/12/2021 |  |  |  | AS | 2021-12-26 00:00:00 | 2021-12-26 00:00:00
AR | 23/12/2021 |  |  |  | AS | 2021-12-28 00:00:00 | 2021-12-28 00:00:00
AR | 25/12/2021 |  |  |  | AS | 2021-12-12 00:00:00 | 2021-12-12 00:00:00
AF | 18/12/2021
AF | 19/12/2021
AF | 20/12/2021
AF | 21/12/2021
AF | 22/12/2021
AF | 23/12/2021
AF | 24/12/2021
AS | 08/12/2021
AS | 09/12/2021
AS | 11/12/2021
AS | 26/12/2021
AS | 28/12/2021
AS | 12/12/2021
Spreadsheet: 758181d1638724216-vlookup-across-multiple-sheets-kod195-129-commercial-road
Sheet: Provisional Sums

 | [NAME]
 | Description | Unit | Rate | Qty | Extension
 | Provisional allowance of £150 to grease and service the door floor springs | psum | 150 | 1
 | Allow a Provisional Sum of £500.00 to strip out any electrical services feeding other areas of the Property | psum | 500 | 1
 | Allow a Provisional Sum of £1,250 to undertake fire stopping works where instructed by the Contract Administrator to provide 60 minute fire resistance between the ground and first floors. Works to be undertaken by a FIRAS or equivalent approved installer. | psum | 1250 | 1
 | Total
 | Construction Cost
 | Description | Unit | Rate | Qty | Extension | Paid | Outstanding
 | Total
Spreadsheet: 129862d1321944157-need-help-pulling-data-from-a-list-based-on-a-condition-schedule
Sheet: Sheet1

 | SCHEDULE & RESULTS
 | DATE | TIME | AWAY |  | SCORE | SCORE | HOME
 | 2011-09-13 00:00:00 | 18:30:00 | Team 8 |  | 4 | 0 | Team 1
 | 2011-09-13 00:00:00 | 19:20:00 | Team 2 |  | 3 | 2 | Team 7
 | 2011-09-13 00:00:00 | 20:10:00 | Team 3 |  | 4 | 5 | Team 6
 | 2011-09-13 00:00:00 | 21:00:00 | Team 4 |  | 6 | 8 | Team 5
 | 2011-09-20 00:00:00 | 18:30:00 | Team 7 |  |  |  | Team 1
 | 2011-09-20 00:00:00 | 19:20:00 | Team 8 |  |  |  | Team 6
 | 2011-09-20 00:00:00 | 20:10:00 | Team 2 |  |  |  | Team 5
 | 2011-09-20 00:00:00 | 21:00:00 | Team 3 |  |  |  | Team 4
 | 2011-09-27 00:00:00 | 18:30:00 | Team 6 |  |  |  | Team 1
 | 2011-09-27 00:00:00 | 19:20:00 | Team 7 |  |  |  | Team 5
 | 2011-09-27 00:00:00 | 20:10:00 | Team 8 |  |  |  | Team 4
 | 2011-09-27 00:00:00 | 21:00:00 | Team 2 |  |  |  | Team 3
 | 2011-10-04 00:00:00 | 18:30:00 | Team 5 |  |  |  | Team 1
 | 2011-10-04 00:00:00 | 19:20:00 | Team 6 |  |  |  | Team 4
 | 2011-10-04 00:00:00 | 20:10:00 | Team 7 |  |  |  | Team 3
 | 2011-10-04 00:00:00 | 21:00:00 | Team 8 |  |  |  | Team 2
 | 2011-10-11 00:00:00 | 18:30:00 | Team 1 |  |  |  | Team 4
 | 2011-10-11 00:00:00 | 19:20:00 | Team 5 |  |  |  | Team 3
 | 2011-10-11 00:00:00 | 20:10:00 | Team 6 |  |  |  | Team 2
 | 2011-10-11 00:00:00 | 21:00:00 | Team 7 |  |  |  | Team 8
 | 2011-10-18 00:00:00 | 18:30:00 | Team 1 |  |  |  | Team 3
 | 2011-10-18 00:00:00 | 19:20:00 | Team 4 |  |  |  | Team 2
 | 2011-10-18 00:00:00 | 20:10:00 | Team 5 |  |  |  | Team 8
 | 2011-10-18 00:00:00 | 21:00:00 | Team 6 |  |  |  | Team 7
 | 2011-10-25 00:00:00 | 18:30:00 | Team 1 |  |  |  | Team 2
 | 2011-10-25 00:00:00 | 19:20:00 | Team 3 |  |  |  | Team 8
 | 2011-10-25 00:00:00 | 20:10:00 | Team 4 |  |  |  | Team 7
 | 2011-10-25 00:00:00 | 21:00:00 | Team 5 |  |  |  | Team 6
 | 2011-11-01 00:00:00 | 18:30:00 | Team 1 |  |  |  | Team 5
 | 2011-11-01 00:00:00 | 19:20:00 | Team 4 |  |  |  | Team 6
 | 2011-11-01 00:00:00 | 20:10:00 | Team 3 |  |  |  | Team 7
 | 2011-11-01 00:00:00 | 21:00:00 | Team 2 |  |  |  | Team 8
 | Team 1
 | DATE | TIME | AWAY |  | SCORE | SCORE | HOME
 | Team 2
 | DATE | TIME | AWAY |  | SCORE | SCORE | HOME
 | Team 3
 | DATE | TIME | AWAY |  | SCORE | SCORE | HOME
 | Team 4
 | DATE | TIME | AWAY |  | SCORE | SCORE | HOME
 | Team 5
 | DATE | TIME | AWAY |  | SCORE | SCORE | HOME
 | Team 6
 | DATE | TIME | AWAY |  | SCORE | SCORE | HOME
 | Team 7
 | DATE | TIME | AWAY |  | SCORE | SCORE | HOME
 | Team 8
 | DATE | TIME | AWAY |  | SCORE | SCORE | HOME
Spreadsheet: 20f846de-ad1b-4896-960c-14f1523ac0d7
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4659 | 23541 | [NAME] | Tastets | CHI
4659 | 7759 | [NAME] | Miramontes | MEX
4659 | 20908 | [NAME] | Hernandez | MEX
4659 | 22340 | Michelle | Flipo | MEX
4659 | 6862 | Amanda | Felder | USA | 53 | 00:21:45 | 00:01:04 | 01:05:52 | 00:00:29 | [NAME] | 2 | [NAME]
4659 | 29391 | Anahi | [NAME] | MEX | 57 | 00:20:34 | [NAME] | 01:09:21 | 00:00:30 | 00:40:29 | 4 | [NAME]
4659 | 22341 | Claudia | Ruiz | MEX | 58 | 00:20:37 | [NAME] | 01:09:20 | 00:00:28 | 00:42:20 | 5 | 02:13:36
4659 | 5433 | [NAME] | Barrera | MEX | 54 | 00:23:27 | 00:00:56 | 00:00:00 | 00:00:00 | 00:00:00 | DQ | 00:00:00
Spreadsheet: 2f9cb0e6-426e-49ac-87da-e948ea94d7dc
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
OTS Thrift Institution
Makes (Originates or Purchases) Long-Term (Term to Maturity >= 5 Years)
Home Mortgage Loan Eligibility Test
Institution Name:
Quarter Ended: |  |  |  |  | OTS Docket Number:
Dollar Amount in Thousands
Long-Term First [NAME] Permanent Mortgage Loans
Long-Term First [NAME] (5 or More) Permanent Mortgage Loans
[NAME] or Guaranteed Pass-Through Mortgage-Backed Securities
backed by Long-Term First [NAME] 1-4 Family or Multifamily Permanent Mortgage Loans
Other Pass-Through Mortgage-Backed Securities
backed by Long-Term First [NAME] 1-4 Family or Multifamily Permanent Mortgage Loans
Long-Term Home Mortgage Loans (Sum of Above)
Pass makes long-term home mortgage loan eligibility test?
10% of Total Assets in Residential Mortgage Loans Eligibility Test
First [NAME] Permanent Mortgage Loans |  |  |  |  |  |  |  | SC 254
Junior [NAME] 1-4 Family Permanent Mortgage Loans |  |  |  |  |  |  |  | SC 255
Revolving Open-End 1-4 Family Permanent Mortgage Loans |  |  |  |  |  |  |  | SC 251
Multifamily (5 or More) Permanent Mortgage Loans |  |  |  |  |  |  |  | SC 256
Eligible Mortgage Loans (Sum of Above) |  |  |  |  |  |  |  | (1)
[NAME] or Guaranteed Pass-Through Mortgage-Backed Securities |  |  |  |  |  |  |  | SC 210
Other Pass-Through Mortgage-Backed Securities |  |  |  |  |  |  |  | SC 215
Other GSE Issued or Guaranteed Mortgage-Backed Securities |  |  |  |  |  |  |  | SC 217
Other Collateralized GSE Issued or Guaranteed Mortgage-Backed Securities |  |  |  |  |  |  |  | SC 219
All Other Mortgage-Backed Securities |  |  |  |  |  |  |  | SC 222
Eligible Mortgage-Backed Securities (Sum of Above) |  |  |  |  |  |  |  | (2)
Residential Mortgage Loans |  |  |  |  |  |  |  | (1)+(2)
Total Assets |  |  |  |  |  |  |  | SC 60
Residential Mortgage Loans/Total Assets
Pass 10% of total assets in residential mortgage loans eligibility test?
Signed By: |  |  |  |  |  | Date:
Print Name: |  |  |  |  |  | Title:
Spreadsheet: 762823d1641834558-add-a-criterion-to-sumproduct-sumproduct-sumif
Sheet: Sheet1

 |  |  | AAA | 250
 |  |  | AAA | 75
 |  |  | BBB | 120
 |  |  | BBB | 45 | 1
 |  |  | CCC | 123
 |  |  | DDD | 130 | 1
 |  |  | AAA | 30
 |  |  | AAA | 90
 |  |  | BBB | 125 | 1
 |  |  | BBB | 350 | 0.5
 |  |  | BBB | 77 | 1
 |  |  | AAA | 1 | 460
 |  |  | AAA | 1 | 100
Spreadsheet: 148830d1333568348-array-formula-to-calculate-average-average-salary
Sheet: Sheet1

Name | Month | Hours | Amt
[NAME] | 2011-04-01 00:00:00 | 2000 | 110000
[NAME] | 2011-04-01 00:00:00 | 14000 | 1050000
[NAME] | 2011-01-01 00:00:00 | 7540 | 452400
[NAME] | 2011-01-01 00:00:00 | 7449 | 670410
[NAME] | 2011-04-01 00:00:00 | 2300 | 138000
[NAME] | 2011-01-01 00:00:00 | 6877 | 550160
[NAME] | 2011-04-01 00:00:00 | 9000 | 675000
[NAME] | 2011-04-01 00:00:00 | 11987 | 479480
Average Hourly Wage | 2011-01-01 00:00:00 | 76.51010701545779
 | 2011-04-01 00:00:00 | 62.42472064550615
Spreadsheet: 080b08c9-443f-4c4c-9589-6039f39f6983
Sheet: Sheet1

 |  | CITY OF SAINT PAUL |  |  | FIRE SPRINKLER
 |  | Department of Fire and Safety Services |  |  | SUPPRESSION SYSTEM
 |  | Fire Safety Inspection Division |  |  | PERMIT APPLICATION
 |  | 375 [NAME] 220, [NAME], MN 55101 |  |  | Updated July 2014
**This application is designed to be saved to your computer and filled out for each project**
*All areas must be completed or application will be returned.
*Correct fee must be enclosed or application will be returned.
* If you have questions please call (651) 266-8989.
Project Name and Address:
Property Owner Name and Address: |  |  |  | Contact Information:
[NAME] and Address: |  |  |  | Contact Information (including email):
Select one: |  | Commercial | Residential | Select one: | New Building | Existing Building
Estimated Start: |  |  |  | End Date:
Estimated Value of Project:
Detailed Description of Work:
Calculation Fee: |  |  |  | Quantity: | Charges per Quantity: | Fee:
1)Initial Fee: |  |  |  |  | 65
2)Sprinkler Heads Installation |  |  |  |  | 20
3)Standpipes |  |  |  |  | 64
*First 5 floors cost $64.00 per standpipes
*Add $7.00 per each additional floors above 5th floors |  |  |  |  | 7
4)Fire Pump |  |  |  |  | 50
5)Plan Review
*Required for new systems and plans with over 25 Heads
*Place a 1 in the green box if there is a plan review
6)Water Flow |  |  |  |  | 65
*$65.00 when required for hydraulic calculation
*Place a 1 in the green box if you obtained water flow data from the City
*Place a 1 in the green box if using this calculation
7)Other [NAME] Work that is not cover by items 2-4
*Fee is 1% of value of work and minimum of $65.00
*Place a 1 in the green box if using this calculation
 |  |  |  | SUMMARY FEE:
State Surcharge $5.00
*Exception if permit fee is greater than $10,000.00 then the permit cost times 0.0005 |  |  |  |  |  | 5
 |  |  |  | TOTAL PERMIT FEE:
*Applicant certifies that all information is correct and that all pertinent state regulations
and city ordinances will be complied with in performing the work for which this permit is issued.
Signature_________________________________________ |  |  |  |  | Date: __________________
Fax inspection request form to (651) 266-8951 when you are ready for an inspection.
An inspector will contact you within 48 hours to set up an inspection time.
Permit application information can be obtained by calling (651) 266-8989
Monday – Friday 8:00 AM – 4:00 PM
*Make checks payable to the City of Saint Paul or [NAME] out the credit cards section