tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 220839d1363278185-populating-data-into-a-summary-tab-using-multiple-data-tabs-s1e-ver-1
Sheet: YZA

 |  |  |  | 202 | 204 | 52 | 20 | Total
 |  |  | BCB | 12 | 0 | 222 | 55
 |  |  | MCM | 33 | 4 | 55 | 0
 |  |  | AET | 33 | 0 | 0 | 44
 |  |  | UHC | 4 | 4 | 44 | 0
 |  |  | WCM | 110 | 18 | 1 | 0
 |  |  | COM | 1 | 0 | 0 | 13
 |  |  | CIG | 15 | 12 | 2 | 44
 |  |  | AFH | 1 | 11 | 33 | 0
 |  |  | UNA | 2 | 0 | 13 | 0
Spreadsheet: 419246d1442333169-month-over-month-headcount-with-sumproduct-excel-forum-test
Sheet: Sheet1

Hire Date | Term Date |  | Month 2016 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00
2010-12-02 00:00:00 |  |  | Current
2011-05-02 00:00:00 |  |  | Term/Resign/Trans
2011-06-27 00:00:00 |  |  | Budget | 25 | 25 | 27 | 27 | 29 | 29 | 31 | 31 | 33 | 33 | 35 | 35
2012-01-23 00:00:00 |  |  | Difference
2012-07-20 00:00:00 | 2016-01-01 00:00:00
2013-01-24 00:00:00
2013-06-12 00:00:00
2014-01-13 00:00:00
2014-01-13 00:00:00
2014-05-27 00:00:00
2014-06-09 00:00:00
2014-09-02 00:00:00
2014-12-08 00:00:00
2015-04-06 00:00:00
2015-04-20 00:00:00
2015-05-18 00:00:00
2015-05-18 00:00:00
2015-06-01 00:00:00
2015-06-08 00:00:00
2015-08-10 00:00:00
2015-10-19 00:00:00
Spreadsheet: ff6588ee-02b8-4ea3-81e9-d72dd85fd43c
Sheet: 4.6-13

Cuadro 4.6-13
REPUBLICA DOMINICANA: Ahogamientos ocurridos y registrados por año y sexo, según grupos [NAME], 2007-2011
Grupos de Edad | 2007 |  |  | 2008 |  |  | 2009 |  |  | 2010 |  |  | 2011p
 | Total | Sexo |  | Total | Sexo |  | Total | Sexo |  | Total | Sexo |  | Total | Sexo
 |  | Masculino | Femenino |  | Masculino | Femenino |  | Masculino | Femenino |  | Masculino | Femenino |  | Masculino | Femenino
Total
 |  |  |  |  |  |  |  |  |  | 0
Menores 15 años |  | 68 | 27 |  | 87 | 38 |  | 76 | 32 |  | 72 | 32 |  | 69 | 35
15-19 |  | 42 | 4 |  | 26 | 4 |  | 43 | 7 |  | 42 | 9 |  | 36 | 3
20-24 |  | 34 | 3 |  | 36 | 1 |  | 25 | 4 |  | 20 | 1 |  | 37 | 3
25-29 |  | 22 | 0 |  | 23 | 1 |  | 26 | 1 |  | 16 | 1 |  | 22 | 0
30-34 |  | 19 | 1 |  | 17 | 1 |  | 11 | 2 |  | 8 | 2 |  | 19 | 3
35-39 |  | 21 | 2 |  | 14 | 1 |  | 14 | 0 |  | 17 | 2 |  | 13 | 2
40-44 |  | 5 | 0 |  | 13 | 1 |  | 9 | 1 |  | 12 | 1 |  | 15 | 1
45-49 |  | 9 | 0 |  | 3 | 3 |  | 4 | 3 |  | 9 | 1 |  | 6 | 1
50-54 |  | 5 | 0 |  | 8 | 0 |  | 7 | 1 |  | 7 | 2 |  | 13 | 1
55-59 |  | 3 | 0 |  | 6 | 0 |  | 4 | 0 |  | 7 | 0 |  | 10 | 3
60-64 |  | 9 | 0 |  | 11 | 1 |  | 2 | 0 |  | 6 | 0 |  | 8 | 1
65 y más |  | 10 | 2 |  | 11 | 2 |  | 12 | 2 |  | 20 | 1 |  | 13 | 1
[NAME] |  | 41 | 7 |  | 56 | 6 |  | 47 | 2 |  | 23 | 9 |  | 32 | 2
p: Cifras preliminares
Fuente: Registros administrativos de la Oficina de Estadísticas y Cartografía de la Policía Nacional
Spreadsheet: 473060d1470021031-how-to-have-macro-insert-row-based-on-other-cells-value-example
Sheet: Sheet1

Chartering ID | Errors | Fixtures | YY/MM | Error % This Month | Total Error % Thus Far | Average Errors per Month Thus Far | Average Fixtures per Month Thus Far
ABZ | 2 | 2 | 12-12
ABZ | 0 | 1 | 13-01
ABZ | 2 | 2 | 13-02
ABZ | 1 | 2 | 13-03
ABZ | 1 | 2 | 13-04
ABZ | 0 | 1 | 13-05
ABZ | 0 | 2 | 13-06
ABZ | 1 | 4 | 13-07
ABZ | 0 | 1 | 13-08
ABZ | 2 | 2 | 13-09
ABZ | 3 | 3 | 13-10
ABZ | 0 | 2 | 13-11
ABZ | 0 | 0 | 13-12
ABZ | 2 | 2 | 14-01
ABZ | 0 | 0 | 14-02
ABZ | 4 | 4 | 14-03
ABZ | 3 | 6 | 14-04
ABZ | 1 | 6 | 14-05
ABZ | 2 | 4 | 14-06
ABZ | 2 | 3 | 14-07
ABZ | 1 | 3 | 14-08
ABZ | 0 | 0 | 14-09
ABZ | 0 | 1 | 14-10
ABZ | 2 | 3 | 14-11
ABZ | 2 | 4 | 14-12
ABZ | 0 | 0 | 15-01
ABZ | 1 | 2 | 15-02
ABZ | 0 | 0 | 15-03
ABZ | 2 | 6 | 15-04
ABZ | 2 | 5 | 15-05
ABZ | 1 | 6 | 15-06
ABZ | 2 | 7 | 15-07
ABZ | 3 | 6 | 15-08
ABZ | 0 | 3 | 15-09
ABZ | 1 | 2 | 15-10
ABZ | 0 | 0 | 15-11
ABZ | 0 | 1 | 15-12
ABZ | 1 | 3 | 16-01
ABZ | 0 | 2 | 16-02
ABZ | 1 | 4 | 16-03
ABZ | 0 | 1 | 16-04
ABZ | 1 | 4 | 16-05
ABZ | 0 | 0 | 16-06
ABZ | 0 | 1 | 16-07
I WANT TO INSERT | NEW | ROW | ABOVE | THIS ONE HERE | AND THEN COPY | ROW 45 INTO THE NEW ROW 46 | AND THEN CHANGE VALUES IN | COLUMN B AND C IN THE NEW ROW 46 TO 0
ABZ Past 3 Months: |  |  | ACTIVE
ABZ Total:
AMH | 0 | 2 | 12-12
AMH | 2 | 8 | 13-01
AMH | 4 | 9 | 13-02
AMH | 1 | 2 | 13-03
AMH | 3 | 5 | 13-04
AMH | 0 | 4 | 13-05
AMH | 1 | 4 | 13-06
AMH | 1 | 2 | 13-07
AMH | 1 | 7 | 13-08
AMH | 0 | 1 | 13-09
I DON'T WANT | ANY | THING | [NAME] | IN THIS SECTION | AS THIS GUY IS | NO LONGER WITH THE FIRM | (SEE CELL D61 SAYING "DEACTIVATED")
AMH Past 3 Months: |  |  | DEACTIVATED
AMH Total:
AN | 3 | 6 | 12-12
AN | 1 | 1 | 13-01
AN | 1 | 1 | 13-02
AN | 1 | 3 | 13-03
AN | 0 | 1 | 13-04
AN | 0 | 0 | 13-05
AN | 3 | 4 | 13-06
AN | 0 | 1 | 13-07
AN | 0 | 0 | 13-08
AN | 0 | 1 | 13-09
AN | 0 | 0 | 13-10
AN | 0 | 1 | 13-11
AN | 2 | 3 | 13-12
AN | 2 | 4 | 14-01
AN | 3 | 5 | 14-02
AN | 2 | 8 | 14-03
AN | 0 | 1 | 14-04
AN | 0 | 5 | 14-05
AN | 0 | 2 | 14-06
AN | 0 | 7 | 14-07
AN | 0 | 8 | 14-08
AN | 3 | 14 | 14-09
AN | 2 | 7 | 14-10
AN | 2 | 6 | 14-11
AN | 2 | 6 | 14-12
AN | 1 | 8 | 15-01
AN | 2 | 7 | 15-02
AN | 1 | 7 | 15-03
AN | 1 | 10 | 15-04
AN | 0 | 4 | 15-05
AN | 0 | 4 | 15-06
AN | 2 | 11 | 15-07
AN | 0 | 7 | 15-08
AN | 1 | 6 | 15-09
AN | 0 | 4 | 15-10
AN | 0 | 4 | 15-11
AN | 1 | 1 | 15-12
AN | 1 | 4 | 16-01
AN | 1 | 8 | 16-02
AN | 0 | 4 | 16-03
AN | 1 | 7 | 16-04
AN | 1 | 2 | 16-05
AN | 0 | 4 | 16-06
AN | 0 | 0 | 16-07
I WANT THE SAME | THING | FOR | THIS SECTION | AS FOR THE ONE | FOR ABZ
AN Past 3 Months: |  |  | ACTIVE
AN Total:
Spreadsheet: 80927d1281154256-count-countif-how-to-count-a-portion-of-a-list-count-question
Sheet: Sheet1

Days | Count
0 | 0
0 | 0
1 | 5
2 | 5
3 | 5
4 | 5
5 | 5
0 | 0
0 | 0
1 | 3
2 | 3
3 | 3
0 | 0
0 | 0
Spreadsheet: 330535d1404782665-dependent-drop-down-list-issue2
Sheet: Static Data

STATIC DATA
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Helper column
 |  |  |  |  |  |  | List based on criteria |  | TRAINING TYPE |  |  |  |  | =IFERROR(INDEX($J$6:$J$11,MATCH(0,IF($M$6:$M$11="Current",COUNTIF($O$5:$O5,$J$6:$J$11)),0)),"")
 |  |  |  |  |  |  | course 1 |  | Description | #Days Req'd | Notes | STATUS
 |  |  |  |  |  |  |  |  | course 1 | 2 |  | Current
 |  |  |  |  |  |  |  |  | course 2 | 1 |  | Current
 |  |  |  |  |  |  |  |  | course 3 | 1 |  | Retired
 |  |  |  |  |  |  |  |  | course 4 | 2 |  | Retired
 |  |  |  |  |  |  |  |  | course 5 | 1 |  | Current
 |  |  |  |  |  |  |  |  | course 6 | 2 |  | Retired
Spreadsheet: 855405d1704980687-derive-a-formula-without-calculating-multiple-countifs-wfh_o-ratio
Sheet: Sheet1

 | TOM
 | DAVE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
January | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | Days worked
 | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We |  |  | WFO (Days)
[NAME] |  | O | O | O | O |  |  | O | O | O | O | O |  |  | O | O | O | O | O |  |  | H | H | O | O | O |  |  | H | O | O |  |  | WFO (%)
[NAME] |  | H | O | O | O |  |  | H | O | O | O | H |  |  | O | H | H | H | H |  |  | O | O | O | H | H |  |  | O | O | O |  |  | WFO/H Ratio
February | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | Days worked
 | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa |  |  | WFO (Days)
[NAME] | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WFO (%)
[NAME] | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WFO/H Ratio
Spreadsheet: 138305d1327598248-conditional-formatting-depending-on-another-cell-sample3
Sheet: Sheet1

Size in [NAME] | 6 |  | S System≤5 | 0.001 | 5
System Type/Size ([NAME]) | 11>SS>5 |  | S Package≤5 | 0.001 | 5
 |  |  | 11>SS>5 | 5.001 | 10.999
 |  |  | 20>SS≥11 | 11 | 19.999
 |  |  | 63>SS≥20 | 20 | 62.999
 |  |  | SS≥63 | 63 | 1000
Spreadsheet: 887114d1737273581-sumproduct-case-sensitive-formcs
Sheet: Foglio1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RES |  |  | RES |  | ASS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | f | f | f | f | f |  |  |  |  |  |  |  |  |  | F |  | F
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | F | F | F | F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fx |  | Fx
 |  |  |  |  |  |  |  | A | A | A | R | R |  |  | R | R | R | R | R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R
ASS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
Spreadsheet: 473755d1470381147-pulling-in-data-from-a-register-book1-1-
Sheet: Sheet1

 | issue | [NAME] |  | [NAME] | FREQ/ISSUE
 | 001 | JH |  | `
 | 002 | SA
 | 003 | SA
 | 004 | SA
 | 005 | SA
 | 006 | TG
 | 007 | DS
 | 008 | PB
 | 009 | TG
 | 010 | TG
 | 011 | TB
 | 012 | JH
 | 013 | GK
Spreadsheet: 702119d1604087836-dragging-my-formula-wont-auto-update-cell-references-that-are-in-quotes-example
Sheet: Master P.O.

 | Master P.O. |  |  |  | Reference Sheet
 |  |  |  |  | 2
 | Item # | Item Description | Quantity | Cost Ea. | Total
Spreadsheet: benjamin_rogers__1109__contact numbers
Sheet: Wheatland

 | Wheatland Generating Plant
 | 480 North Hall Road, Wheatland, IN 47597
 | General Phone Numbers |  |  | Plant Personnel
 | Control Room 1 | [PHONE] |  | Name | Title | Office | Cellular | FAX | Home | [NAME]
 | Control Room 2 | [PHONE] |  | [NAME] | Plant Manager | [PHONE] | [PHONE] | [PHONE] | [PHONE]
 | Control Room Fax | [PHONE] |  | [NAME] | Reception Phone | [PHONE] | N/A | [PHONE] | N/A
 | On Call Pager 1 | [PHONE] |  | [NAME] | Plant Supervisor | [PHONE] | [PHONE] | [PHONE] | [PHONE]
 | On Call Pager 2 | [PHONE] |  | [NAME] | Tech | [PHONE] | N/A | [PHONE] | N/A |  |  | Ind Power & Light Gen | [PHONE]
 |  |  |  | [NAME] | Tech | [PHONE] | N/A | [PHONE] | N/A
 | Neighboring Control Areas |  |  | [NAME] | Tech | [PHONE] | N/A | [PHONE] | N/A
 | [NAME] | [PHONE] |  | [NAME] | Tech | [PHONE] | N/A | [PHONE] | N/A
 | Cinergy Transmission | [PHONE] |  | [NAME] | Tech | [PHONE] | N/A | [PHONE] | N/A
 | Cinergy FAX | [PHONE] |  | [NAME] | Tech | [PHONE] | N/A | [PHONE] | N/A
 | Ind Power & Light Gen | [PHONE] |  | [NAME] | Tech | [PHONE] | N/A | [PHONE] | N/A
 | Ind Power & Light Trans | [PHONE]
 | Hoosier Electric- Trans | [PHONE] |  | Name | Title | Office | Pager | FAX | Home | [NAME]
 | [NAME] | [PHONE] |  | [NAME] | Engineers Office | [PHONE] | [PHONE] | [PHONE] | N/A
 | Pipeline
 | Gas Control | [PHONE]
 | [NAME]
 | One | [PHONE]
 | Two | [PHONE]
 | Three | [PHONE]
 | Four | [PHONE]
 | Five | [PHONE]
 | Six | [PHONE]
Spreadsheet: 104837d1302277741-offset-of-a-max-array-formula-possible-max_offset_array
Sheet: List_Frame_1

Column A | PO | [NAME] | Line Desc | Order Date | [NAME] | [NAME] | Unit Cost | U/M | Order Cost | Received Cost | Remaining Cost | Due Date | Deliver To
 |  |  | [NAME] | 2011-03-25 00:00:00 |  |  |  |  |  |  |  | 2012-03-25 00:00:00
 |  |  | Le Orange | 2011-03-25 00:00:00 |  |  |  |  |  |  |  | 2012-03-25 00:00:00
 |  |  | Limers | 2011-04-05 00:00:00 |  |  |  |  |  |  |  | 2012-03-25 00:00:00
 |  |  | Kiwi | 2011-03-25 00:00:00 |  |  |  |  |  |  |  | 2012-03-25 00:00:00
 |  |  | Lemon | 2011-01-24 00:00:00 |  |  |  |  |  |  |  | 2011-12-24 00:00:00
 |  |  | Lime | 2010-12-16 00:00:00 |  |  |  |  |  |  |  | 2011-12-16 00:00:00
 |  |  | Pineapple | 2010-12-16 00:00:00 |  |  |  |  |  |  |  | 2011-12-16 00:00:00
 |  |  | [NAME] | 2010-12-16 00:00:00 |  |  |  |  |  |  |  | 2011-12-16 00:00:00
 |  |  | Pepper Jack | 2010-12-16 00:00:00 |  |  |  |  |  |  |  | 2011-12-16 00:00:00
 |  |  | Soda | 2011-02-24 00:00:00 |  |  |  |  |  |  |  | 2011-09-11 00:00:00
 |  |  | Orange | 2011-02-08 00:00:00 |  |  |  |  |  |  |  | 2011-07-22 00:00:00
 |  |  | Yellow things | 2011-02-10 00:00:00 |  |  |  |  |  |  |  | 2011-06-29 00:00:00
 |  |  | Chiquitas | 2011-03-28 00:00:00 |  |  |  |  |  |  |  | 2011-06-01 00:00:00
 |  |  | [NAME] | 2011-03-24 00:00:00 |  |  |  |  |  |  |  | 2011-05-30 00:00:00
 |  |  | Green Lime | 2011-03-24 00:00:00 |  |  |  |  |  |  |  | 2011-05-30 00:00:00
 |  |  | Chiquitas | 2011-03-24 00:00:00 |  |  |  |  |  |  |  | 2011-05-30 00:00:00
 |  |  | Chiquitas | 2011-03-24 00:00:00 |  |  |  |  |  |  |  | 2011-05-30 00:00:00
 |  |  | [NAME] | 2011-03-24 00:00:00 |  |  |  |  |  |  |  | 2011-05-30 00:00:00
 |  |  | Pop | 2011-03-24 00:00:00 |  |  |  |  |  |  |  | 2011-05-30 00:00:00
 |  |  | [NAME] | 2011-03-30 00:00:00 |  |  |  |  |  |  |  | 2011-05-26 00:00:00
 |  |  | [NAME] | 2011-02-10 00:00:00 |  |  |  |  |  |  |  | 2011-05-24 00:00:00
 |  |  | Chiquitas | 2011-02-10 00:00:00 |  |  |  |  |  |  |  | 2011-05-24 00:00:00
 |  |  | [NAME] | 2011-02-10 00:00:00 |  |  |  |  |  |  |  | 2011-05-24 00:00:00
 |  |  | Green Lime | 2011-02-10 00:00:00 |  |  |  |  |  |  |  | 2011-05-18 00:00:00
 |  |  | Lime | 2010-11-16 00:00:00 |  |  |  |  |  |  |  | 2011-05-15 00:00:00
 |  |  | Pineapple | 2010-11-16 00:00:00 |  |  |  |  |  |  |  | 2011-05-15 00:00:00
 |  |  | [NAME] | 2010-11-16 00:00:00 |  |  |  |  |  |  |  | 2011-05-15 00:00:00
 |  |  | Pepper Jack | 2011-03-14 00:00:00 |  |  |  |  |  |  |  | 2011-05-10 00:00:00
 |  |  | Soda | 2011-03-14 00:00:00 |  |  |  |  |  |  |  | 2011-05-10 00:00:00
 |  |  | Orange | 2011-03-14 00:00:00 |  |  |  |  |  |  |  | 2011-05-10 00:00:00
Spreadsheet: 109594d1306415898-macro-to-copy-row-to-another-sheet-if-row-contains-a-certain-word-cost-breakdown
Sheet: Noise Reduction (Fassade)

 |  |  |  |  |  |  |  |  | new construction |  |  | reconstruction works |  |  | maintainance
 | CG | Description of the cost group | Amount | Unit | Price/Unit | Cost Total |  |  | 2011 | 2012 | 2013 | 2011 | 2012 | 2013 | 2011 | 2012 | 2013 | % from Total | Remarks
 |  |  |  |  |  |  | Priorität | Ort
 | 100 | Site
 | 110 | Site value
 | 120 | Incidental site costs
 | 332 | [NAME] |  |  |  | 2062548 |  | Noise
 |  | [NAME] | 4324 | m² | 434 | 1876616 | 1 | Noise | 938308 | 938308 |  |  |  |  |  |  |  |  |  |  | Noise
 |  | [NAME] bla3 | 4324 | m² | 43 | 185932 | 1 | Noise | 92966 | 92966 |  |  |  |  |  |  |  |  |  |  | Noise
an |  | [NAME] | 4324 | m² | 43 | 185932 | 2 | Noise |  |  |  | 65076.2 | 65076.2 | 55779.6 |  |  |  |  |  |  | Noise
an |  | [NAME] | 1 | lot | 45000 | 45000 | 1 | Noise | 45000 |  |  |  |  |  |  |  |  |  |  |  | Noise
Spreadsheet: 0fee8ba2-d806-47c7-9d5c-9cc1cc386729
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-07-02 09:30:25.430000
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 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.625 | 101.5 | 101.375 | 101
3.75 | 100.721 | 100.596 | 100.471 | 100.096 |  | Note: | Refer To Price [NAME]
3.625 | 100.44 | 100.315 | 100.19 | 99.815 |  |  | For all Price Adjs
3.5 | 99.841 | 99.716 | 99.591 | 98.966
3.375 | 98.953 | 98.828 | 98.703 | 98.078
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 101.667 | 101.542 | 101.417 | 101.042
3.25 | 101.136 | 101.011 | 100.886 | 100.511
3.125 | 100.803 | 100.678 | 100.553 | 100.178
3 | 100.475 | 100.35 | 100.225 | 99.85
2.875 | 99.892 | 99.767 | 99.642 | 99.017
2.75 | 99.214 | 99.089 | 98.964 | 98.339
 |  |  |  |  |  | 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-07-16 09:30:25.430000
30 DAY | 2012-07-31 09:30:25.430000
45 DAY | 2012-08-15 09:30:25.430000
60 DAY | 2012-08-30 09:30:25.430000
90 DAY | 2012-09-29 09:30:25.430000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 110552d1307158055-look-up-info-from-multiple-columns-look-up-info-from-multiple-columns
Sheet: Sheet1

 | Table 1 |  |  | Look up F3 and retrieve Data
 | 1 | 100 |  | Look Up | ASD4DE
 | 2 | 101
 | 3 | 102 |  | Tbl 1 Data | 103
 | 4 | 103 |  | Tbl 2 Data | 103
 | 5 | 104
 | 6 | 105 |  | Note:  The look up data is not always a number by itself; sometimes it has letters or symbols behind it, which explains why the formula is not just a simple [NAME].
 | 7 | 106
 | 8 | 107
 | 9 | 108
 | 10 | 109 |  | Table 2
 | 11 | 110 |  | 1 | 100 | 200 | 120 | 301 | 136
 | 14 | 111 |  | 2 | 101 | 201 | 121 | 302 | 137
 | 15 | 112 |  | 3 | 102 | 202 | 122 | 303 | 138
 | 16 | 113 |  | 4 | 103 | 203 | 123 | 304 | 139
 | 100 | 114 |  | 5 | 104 | 211 | 124 | 305 | 140
 | 105 | 115 |  | 6 | 105 | 212 | 125 | 321 | 141
 | 106 | 116 |  | 7 | 106 | 213 | 126 | 322 | 142
 | 120 | 117 |  | 8 | 107 | 220 | 127 | 324 | 143
 | 123 | 118 |  | 9 | 108 | 221 | 128 | 336 | 144
 | 130 | 119 |  | 10 | 109 | 222 | 129 | 428 | 145
 | 133 |  |  | 11 | 110 | 231 | 130 | 431 | 146
 | 200 | 120 |  | 14 | 111 | 232 | 131 | 432 | 147
 | 201 | 121 |  | 15 | 112 | 241 | 132 | ASP | 148
 | 202 | 122 |  | 16 | 113 | 242 | 133 | CA2 | 149
 | 203 | 123 |  | 100 | 114 | 243 | 134 | LT2 | 150
 | 211 | 124 |  | 105 | 115 | 244 |  | PUH | 151
 | 212 | 125 |  | 106 | 116 | 250 | 135 | ta1 | 152
 | 213 | 126 |  | 120 | 117 | 251 | 136 | TA2 | 153
 | 220 | 127 |  | 123 | 118 | 252 | 137 | TFX | 154
 | 221 | 128 |  | 130 | 119 | 268 | 138 | WSHR | 155
 | 222 | 129 |  | 133 |  | 300 | 139
 | 231 | 130
 | 232 | 131
 | 241 | 132
 | 242 | 133
 | 243 | 134
 | 244
 | 250 | 135
 | 251 | 136
 | 252 | 137
 | 268 | 138
 | 300 | 139
 | 301 | 140
 | 302 | 141
 | 303 | 142
 | 304 | 143
 | 305 | 144
 | 321 | 145
 | 322 | 146
 | 324 | 147
 | 336 | 148
 | 428 | 149
 | 431 | 150
 | 432 | 151
 | ASP | 152
 | CA2 | 153
 | LT2 | 154
 | PUH | 155
 | ta1 | 156
 | TA2 | 157
 | TFX | 158
 | WSHR | 159
Spreadsheet: 83610d1283573091-vlookup-best-option-to-populate-cells-helpvlookup
Sheet: TABLES

 |  |  |  |  |  |  |  |  |  |  |  | THESE COLUMNS BELOW ARE TO BE ABLE TO CONTINUALLY ADDED
 |  |  |  |  |  |  |  |  |  |  |  | TO WITH NEW TOWNS AND RAINFALL DATA
 |  | TOWN NAME:
 |  |  |  |  |  |  |  |  |  |  |  |  | TOWN1
 |  | MIN | 1 Year | 2 years | 5 years | 10 years | 20 years | 50 years | 100 years
 |  | 5 |  |  |  |  |  |  |  |  |  |  | 86.3 | 111 | 142 | 161 | 188 | 224 | 253
 |  | 6 |  |  |  |  |  |  |  |  |  |  | 80 | 103 | 132 | 150 | 175 | 209 | 236
 |  | 10 |  |  |  |  |  |  |  |  |  |  | 65.6 | 84.6 | 107 | 121 | 141 | 168 | 189
 |  | 20 |  |  |  |  |  |  |  |  |  |  | 48.9 | 62.7 | 78.2 | 87.9 | 101 | 120 | 134
 |  | 30 |  |  |  |  |  |  |  |  |  |  | 39.8 | 51 | 63.2 | 70.8 | 81.3 | 95.7 | 107
 |  | 60 |  |  |  |  |  |  |  |  |  |  | 26.3 | 33.6 | 41.5 | 46.3 | 53.1 | 62.3 | 69.6
 |  | 120 |  |  |  |  |  |  |  |  |  |  | 16.3 | 20.8 | 25.6 | 28.6 | 32.7 | 38.4 | 42.8
 |  | 180 |  |  |  |  |  |  |  |  |  |  | 12.1 | 15.4 | 19 | 21.1 | 24.2 | 28.4 | 31.7
 |  | 360 |  |  |  |  |  |  |  |  |  |  | 7.1 | 9.07 | 11.2 | 12.5 | 14.4 | 16.9 | 18.9
 |  | 720 |  |  |  |  |  |  |  |  |  |  | 4.17 | 5.36 | 6.7 | 7.54 | 8.7 | 10.3 | 11.6
 |  | 1440 |  |  |  |  |  |  |  |  |  |  | 2.44 | 3.17 | 4.08 | 4.66 | 5.45 | 6.55 | 7.44
 |  | 2880 |  |  |  |  |  |  |  |  |  |  | 1.37 | 1.82 | 2.44 | 2.86 | 3.42 | 4.21 | 4.86
 |  | 4320 |  |  |  |  |  |  |  |  |  |  | 0.939 | 1.26 | 1.74 | 2.06 | 2.49 | 3.11 | 3.63
 |  |  |  |  |  |  |  |  |  |  |  |  | TOWN2
 |  | Cells E3:F3 are to be for user input of the town name. |  |  |  |  |  |  |  |  |  |  | 92.6 | 119 | 150 | 168 | 194 | 230 | 258
 |  |  |  |  |  |  |  |  |  |  |  |  | 86 | 111 | 139 | 157 | 181 | 214 | 240
 |  | The yellow cells are to be populated by the rainfall data that coresponds with the towns name |  |  |  |  |  |  |  |  |  |  | 70.6 | 90.6 | 113 | 127 | 147 | 173 | 194
 |  |  |  |  |  |  |  |  |  |  |  |  | 52.8 | 67.5 | 83.6 | 93.3 | 107 | 125 | 140
 |  |  |  |  |  |  |  |  |  |  |  |  | 43.2 | 55.1 | 67.9 | 75.6 | 86.3 | 101 | 112
 |  |  |  |  |  |  |  |  |  |  |  |  | 28.6 | 36.4 | 44.7 | 49.7 | 56.7 | 66.2 | 73.5
 |  |  |  |  |  |  |  |  |  |  |  |  | 17.5 | 22.3 | 27.5 | 30.6 | 35 | 41 | 45.6
 |  |  |  |  |  |  |  |  |  |  |  |  | 12.8 | 16.3 | 20.2 | 22.6 | 25.9 | 30.4 | 33.9
 |  |  |  |  |  |  |  |  |  |  |  |  | 7.35 | 9.43 | 11.8 | 13.3 | 15.3 | 18.1 | 20.3
 |  |  |  |  |  |  |  |  |  |  |  |  | 4.3 | 5.54 | 7.04 | 7.96 | 9.23 | 11 | 12.3
 |  |  |  |  |  |  |  |  |  |  |  |  | 2.6 | 3.37 | 4.32 | 4.91 | 5.73 | 6.85 | 7.74
 |  |  |  |  |  |  |  |  |  |  |  |  | 1.56 | 2.04 | 2.64 | 3.02 | 3.54 | 4.26 | 4.84
 |  |  |  |  |  |  |  |  |  |  |  |  | 1.11 | 1.44 | 1.89 | 2.18 | 2.55 | 3.08 | 3.51
Spreadsheet: 169467d1342869873-countifs-statement-with-a-vlookup-as-well-countif-based-on-vlookup
Sheet: Zip Codes

States | City | Zip Codes
CA | Private infromation | 92274
 |  | 92276
IL |  | 62618
AZ |  | 85002
 |  | 85001
OH |  | 43026
MA |  | 2148
VT |  | 5482
OR |  | 97502
WY |  | 82414
Spreadsheet: 880601d1728409193-automated-calendar-with-changing-holidays-vakantie-template-mbv-cadix
Sheet: oktober

 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Opgenomen vakantie | Resterende vakantie
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | Maxime
VPK | [NAME]
 | Cédric
 | Elke
 | Ellen
 | Els
 | Gert
 | Ief
 | [NAME]
 | Joeri
 | [NAME]
 | Kelly
 | [NAME]
 | [NAME]
 | Michel
 | Mirthe
 | Nadia
 | Neslihan
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Aanwezig | 1
 | ADV | A
 | Vakantie | V
 | Ziek | Z
ZK | Annelies
 | Herly
 | Nadia
 | Nele
 | Ranka
 | Sid
 | Aanwezig | 1
 | ADV | A
 | Vakantie | V
 | Ziek | Z
[NAME] | [NAME]
 | [NAME]
 | Hilde
 | Samira
 | Vicky
 | Tyra
 | Aanwezig | 1
 | ADV | A
 | Vakantie | V
 | Ziek | Z
Spreadsheet: 708378d1607771801-counting-discount-based-on-date-criteria-and-top-3-first-discount_problem_new
Sheet: EDITED

 |  |  |  |  |  |  |  |  |  | 2021-01-31 00:00:00
 |  |  |  |  |  |  | my expected result |  |  | 2021-03-31 00:00:00
 |  |  | name | date payment |  | name | discount
 |  |  | jhon | 2020-12-04 00:00:00 |  | jhon | 100
 |  |  | [NAME] | 2020-12-08 00:00:00 |  | [NAME] | 50
 |  |  | frans | 2020-12-06 00:00:00 |  | frans | 100
 |  |  | darius | 2020-12-07 00:00:00 |  | darius | 100
 |  |  | [NAME] | 2021-02-02 00:00:00 |  | [NAME] | 50
 |  |  | joko | 2021-03-31 00:00:00 |  | joko | 50
 |  |  | sisca | 2021-05-31 00:00:00 |  | sisca | 0
 |  |  | [NAME] | 2021-04-02 00:00:00 |  | [NAME] | 0