tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 715214d1611604220-excel-formula-if-certain-text-shows-in-2-differnt-col-show-value-in-a-specific-column-test1
Sheet: Sheet1

 |  |  |  | Item1 |  |  |  |  |  |  |  | item2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Item3 | [NAME] Here
 |  |  |  | Raw |  |  |  |  |  |  |  | tomatoes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 0
 |  |  |  | Raw |  |  |  |  |  |  |  | grapes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 0
 |  |  |  | Prod |  |  |  |  |  |  |  | Orange |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 0
 |  |  |  | Fill |  |  |  |  |  |  |  | Apple |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 0
 |  |  |  | Coat |  |  |  |  |  |  |  | Apple |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 0
 |  |  |  | Coat |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 50
 |  |  |  | Coat |  |  |  |  |  |  |  | grapes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 50 |  | Show value in col BK it text Raw, Prod, Fill, Orange, Apple are not in col E & M
 |  |  |  | Coat |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -50 | -50
Spreadsheet: 832587d1686459461-how-to-split-cells-into-columns-and-fill-down-help0611
Sheet: Sheet1

Column1 | Column2 |  | Value | Column2
A,B,C,D | 10 |  | A | 10
E,F | 20 |  | B | 10
G | 30 |  | C | 10
 |  |  | D | 10
 |  |  | E | 20
 |  |  | F | 20
 |  |  | G | 30
X
X
X
X
X
X
X
X
1
2
3
3
4
5
6
7
8
9
9
10
10
11
11
12
13
13
14
15
15
16
17
17
17
18
18
19
20
21
21
22
22
23
23
23
23
23
23
24
25
25
26
26
26
26
26
27
27
27
27
27
27
28
28
28
28
29
29
29
29
29
29
29
29
30
30
31
31
32
32
32
32
32
33
33
33
33
33
34
34
34
34
34
34
34
35
35
35
35
35
36
37
37
37
37
37
37
37
37
38
39
39
39
39
39
39
40
40
40
40
40
40
40
40
41
42
42
42
42
42
42
42
42
42
42
43
43
43
44
44
44
44
44
44
44
45
45
46
46
46
46
46
47
47
48
48
48
48
49
49
49
49
49
50
50
50
50
51
51
51
52
52
52
52
52
52
53
54
54
54
54
54
55
55
55
55
56
56
56
56
56
56
57
57
57
58
59
59
59
59
60
60
61
61
61
62
63
63
63
63
63
64
64
Spreadsheet: john_griffith__16216__1_31_02GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HU G2 | EXP |  |  | 36.3 | 53.3 | 1.61 | 2002-01-25 15:08:00
 | [NAME] | 57 | 560 | 610 | 47.2 | 51.4 | 1.77 | 2002-01-31 15:11:00
 | [NAME] | 64 | 900 | 990 | 46.5 | 51.2 | 1.97 | 2002-01-31 15:11:00
 | [NAME] | 65 | 1100 | 1190 | 44.7 | 48.4 | 1.9 | 2002-01-31 15:11:00
 | [NAME] | 65 | 1240 | 1325 | 42.9 | 45.8 | 1.81 | 2002-01-31 15:11:00
 | HU N2 | 64 | 1325 | 1425 | 41.9 | 45.1 | 1.75 | 2002-01-31 15:11:00
 | [NAME] | 63 | 1350 | 1450 | 39.6 | 42.5 | 1.63 | 2002-01-31 15:11:00
 | HU U2 | 62 | 1380 | 1480 | 38 | 40.8 | 1.54 | 2002-01-31 15:11:00
 | [NAME] | 60 | 1350 | 1500 | 36.1 | 40.1 | 1.44 | 2002-01-31 15:11:00
 | [NAME] | 59 | 1360 | 1500 | 34.7 | 38.4 | 1.36 | 2002-01-31 15:11:00
 | [NAME] | 58 | 1360 | 1550 | 33.8 | 38.6 | 1.32 | 2002-01-31 15:11:00
 | HU F3 |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | HU H3
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | [NAME]
Spreadsheet: 167547d1342022463-trying-to-display-multiple-instances-of-same-value-maintenance-log-2012
Sheet: DATA ENTRY

Serial number | valve number | Date serviced | Work done | location
115554/8 | 6 | 2009-08-10 00:00:00 | changed seals and bolts | CIP 1
115554/8 | 6 | 2012-02-12 00:00:00 | new frame put on | CIP 2
115555/9 | 8 | 2009-06-15 00:00:00 | valves changed | CIP 4
Spreadsheet: 266224d1379532385-return-value-based-on-age-at-a-given-point-in-time-test-sheet
Sheet: test

Todays date
 | Name | DOB | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00
 | [NAME] bloggs | 2012-11-02 00:00:00
 | A Bloggs | 2013-06-15 00:00:00
 | Lookup range
 | <2 yrs | Orange
 | 2 - 3yrs | Blue
 | 3 - 4.5yrs | Red
 | 4.5> | Green
Spreadsheet: 758060d1638614884-search-for-any-text-from-multiple-cells-within-multiple-cells-sample-with-formula
Sheet: Sheet1

Name1 | [NAME] | Name3 | Name4 | Name5 | Name6 | Email1 | Email2 | Email3 | Email4 | Email5 | Email6 |  | Original |  | Tweak
[NAME] | Doe | 1 |  |  |  | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL]
[NAME] | M | Doe |  |  |  | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL]
[NAME] | Bi | Fred | Said | None | Yes | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL]
Julie | L | Some | Thing | Special |  | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL]
Ellie | Is | Last | Good | Mai | 12 | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL]
[NAME] | [NAME] | Yadda | Stuff |  |  | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL]
[NAME] | [NAME] | Yadda | Stuff |  |  | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL]
Spreadsheet: louise_kitchen__23083__Commercial Headcount for NEWCO
Sheet: Canada

CANADA
Power Orig |  | Gas Orig |  | Trading |  | Toronto
Biever |  | Burnham |  | Brodeur |  | Borg
Davies |  | Dunsmore |  | [NAME] |  | DeVries
Lalani |  | [NAME] |  | Cowan |  | Dorland
[NAME] |  | Hrap |  | Disturnal |  | Ellis
Milnthorp |  | Le Dain |  | Dorland |  | Goddard
Savidant |  | Oh |  | Draper |  | Sangermano
 |  | Sangwine |  | Garvey |  | Tripp
 |  |  |  | [NAME] |  | Wilson
 |  |  |  | Richey
 |  |  |  | [NAME]
 |  |  |  | Watt
 |  |  |  | Zufferli
6 |  | 7 |  | 12 |  | 8 |  | Total
Spreadsheet: 875895d1722518426-help-with-overtime-formula-overtime-example-2
Sheet: Mon-Fri 8 hrs-day 49hr Wk

You must use the format HH:[NAME] (ie 09:00 or 17:00) when entering your time. It reformats the cell if you use any other way (ie 9 or 17 or 9.00 ect) this will change the calculations and the sheet won't be correct.
 |  | Enter start time: 24hr clock | Enter time work over lunch. ie 00:30 minuets worked | Enter finish time: 24hr clock | Hours in work | Overtime. | Enter time taken back as hours:minutes | Final running total of overtime
Date | Day | Start | Lunch | Finish | Hours | Overtime | Time taken back | Total
2024-09-16 00:00:00 | Monday
2024-09-17 00:00:00 | Tuesday
2024-09-18 00:00:00 | Wednesday |  |  |  |  |  |  |  |  | Mon-Fri 8 hrs-day 49hr Wk
2024-09-19 00:00:00 | Thursday
2024-09-20 00:00:00 | Friday
2024-09-21 00:00:00 | Saturday
2024-09-22 00:00:00 | Sunday
2024-09-23 00:00:00 | Monday
2024-09-24 00:00:00 | Tuesday
2024-09-25 00:00:00 | Wednesday
2024-09-26 00:00:00 | Thursday
2024-09-27 00:00:00 | Friday
2024-09-28 00:00:00 | Saturday
2024-09-29 00:00:00 | Sunday
2024-09-30 00:00:00 | Monday
2024-10-01 00:00:00 | Tuesday
2024-10-02 00:00:00 | Wednesday
2024-10-03 00:00:00 | Thursday
2024-10-04 00:00:00 | Friday
2024-10-05 00:00:00 | Saturday
2024-10-06 00:00:00 | Sunday
Spreadsheet: 484608d1476352236-increase-sample
Sheet: Sheet1

 |  | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Total | % increase
 | 2014-2015 | 172220.77 | 197905.7 | 183176.7 | 135534.9 | 115595.9 | 109463.9 | 158504.5 | 83690 | 125369.7 | 99196.4 | 150367.1 | 94296.78 |  | N/A
 | 2015-2016 | 129337.8 | 84474.3 | 98308.6 | 134667.8 | 183409.6 | 117744.5 | 153147.3 | 78377.8 | 57478 | 75613 | 148785.3
 | 2016-2017
 |  | I would only like it to take into account up untill september as Octobers values have not been finalised. |  |  |  |  |  |  | I would like a formula in this cell that tells me if I am up or down in comparison to the preivious year.
Spreadsheet: 0ec46d94-31fa-430d-932a-193eee7fbea8
Sheet: Sheet1

Unnamed: 0 | BELKNAP COUNTY OFFICES - Democratic | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
2010-09-14 00:00:00 | Sheriff |  |  | Attorney |  | Treasurer
 | Wiggin, r | Others |  | Carroll, d | Others | Ahlgren, d | Muzzey, r | Others
Alton | 3 | 8 |  | 113 | 4 | 109 | 0 | 3
Barnstead | 0 | 0 |  | 112 | 0 | 108 | 0 | 0
Belmont | 6 | 7 |  | 149 | 1 | 121 | 0 | 0
Center Harbor | 1 | 2 |  | 43 | 0 | 39 | 1 | 0
Gilford | 7 | 6 |  | 247 | 0 | 213 | 0 | 0
Gilmanton | 1 | 3 |  | 98 | 0 | 94 | 0 | 0
[NAME] | 7 | 0 |  | 88 | 0 | 75 | 0 | 0
[NAME] | 2 | 1 |  | 87 | 0 | 71 | 0 | 0
[NAME] 3 | 4 | 2 |  | 99 | 2 | 75 | 2 | 0
[NAME] | 0 | 2 |  | 106 | 0 | 80 | 0 | 0
[NAME] | 3 | 0 |  | 65 | 0 | 55 | 0 | 0
[NAME] 6 | 7 | 2 |  | 97 | 0 | 81 | 1 | 1
Meredith | 10 | 3 |  | 218 | 0 | 205 | 0 | 0
New Hampton | 6 | 3 |  | 103 | 0 | 102 | 1 | 0
Sanbornton | 3 | 7 |  | 164 | 0 | 162 | 1 | 0
[NAME] | 3 | 10 |  | 133 | 0 | 136 | 0 | 0
TOTALS | 63 | 56 |  | 1922 | 7 | 1726 | 6 | 4
 | BELKNAP COUNTY OFFICES - Democratic
 | Reg. of Deeds |  |  |  | Reg. Of Probate
 | Chong, d | Luther, r | Others |  | [NAME], d | Brickner, r | Others
Alton | 115 | 0 | 2 |  | 114 | 0 | 2
Barnstead | 108 | 0 | 0 |  | 107 | 0 | 0
Belmont | 121 | 2 | 3 |  | 124 | 1 | 0
Center Harbor | 36 | 0 | 0 |  | 37 | 1 | 0
Gilford | 207 | 6 | 0 |  | 214 | 1 | 2
Gilmanton | 90 | 1 | 0 |  | 88 | 0 | 0
[NAME] | 75 | 4 | 3 |  | 78 | 1 | 0
[NAME] | 70 | 0 | 0 |  | 72 | 0 | 0
[NAME] 3 | 75 | 6 | 1 |  | 80 | 3 | 0
[NAME] | 79 | 0 | 2 |  | 81 | 0 | 0
[NAME] | 54 | 2 | 0 |  | 57 | 0 | 0
[NAME] 6 | 83 | 4 | 0 |  | 86 | 1 | 0
Meredith | 211 | 1 | 0 |  | 206 | 1 | 0
New Hampton | 98 | 3 | 1 |  | 100 | 3 | 0
Sanbornton | 170 | 2 | 3 |  | 148 | 0 | 1
[NAME] | 129 | 1 | 0 |  | 139 | 0 | 0
TOTALS | 1721 | 32 | 15 |  | 1731 | 12 | 5
 | BELKNAP COUNTY COMMISSIONERS
 | District 1 | District 2 |  |  |  | District 3
 |  | Cormier, d | Livernois, d | [NAME], r | Other | Copithorne, d | Grenier, r | Nedeau, d
Alton | NO ELECTION |  |  |  |  | 112 | 1 | 1
Barnstead |  | 76 | 33 | 0 | 0
Belmont |  | 84 | 63 | 0 | 0
Center Harbor |  |  |  |  |  | 38 | 0 | 1
Gilford |  |  |  |  |  | 212 | 3 | 1
Gilmanton |  | 55 | 33 | 0 | 0
[NAME]
[NAME]
[NAME] 3
[NAME]
[NAME]
[NAME] 6
Meredith |  |  |  |  |  | 201 |  | 5
New Hampton |  |  |  |  |  | 99 | 1 | 1
Sanbornton |  | 42 | 145 | 0 | 0
[NAME] |  | 72 | 72 | 0 | 1
TOTALS |  | 329 | 346 | 0 | 1 | 662 | 5 | 9
Spreadsheet: 86214d1286236753-reformatting-row-data-to-columns-consolidateuniquevalues
Sheet: Sheet1

[NAME] | tomato Pizza | Burger | Jelly | Ice Cream
[NAME] | Sausage | [NAME] | Jelly | Biscuits
[NAME] | Ham Salad | Cheese Sandwich | [NAME] | [NAME]
[NAME] | Burger | Sausage | Apple Pie | [NAME]
[NAME] | Pork Chops | [NAME] | Fresh Fruit | Apple Pie
[NAME] | Fish and Chips | Meat Loaf | Ice Cream | [NAME]
[NAME] | [NAME] | Meat Loaf | Ice Cream | Apple Pie
 |  |  |  |  |  | Press Alt-F8 and run the ConsolidateUnique macro
Spreadsheet: 708562d1607930387-array-index-problems-need-assistance-or-any-advice-to-help-to-create-formula-to-enable-to-book1
Sheet: Sheet2

Information in Spreadsheet 2
Family ID | Student ID | Student Name
2022 | 1000 | Adam
2022 | 1001 | Aarron
2023 | 1002 | [NAME]
2023 | 1003 | Rachel
2841 | 1004 | Phoebe
2841 | 1005 | Mark
2405 | 1006 | Calum
2026 | 1007 | Aiden
2378 | 1008 | [NAME]
2377 | 1009 | Petra
2378 | 1010 | [NAME]
2028 | 1011 | [NAME]
2691 | 1012 | Kaden
2331 | 1013 | [NAME]
Spreadsheet: 00db233c-0bde-4f68-9c57-f37374781ecf
Sheet: Sheet1

<< ㄱ  >> | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
여행사명 | 담당자 | 핸드폰 | E-Mail | 전화번호 | 팩스번호 | 방문날짜
<< ㄴ >>
여행사명 | 담당자 | 핸드폰 | E-Mail | 전화번호 | 팩스번호 | 방문날짜
<< ㄷ  >>
여행사명 | 담당자 | 핸드폰 | E-Mail | 전화번호 | 팩스번호 | 방문날짜
<< ㄹ  >>
여행사명 | 담당자 | 핸드폰 | E-Mail | 전화번호 | 팩스번호 | 방문날짜
<< ㅁ  >>
여행사명 | 담당자 | 핸드폰 | E-Mail | 전화번호 | 팩스번호 | 방문날짜
<< ㅂ  >>
여행사명 | 담당자 | 핸드폰 | E-Mail | 전화번호 | 팩스번호 | 방문날짜
<< ㅅ  >>
여행사명 | 담당자 | 핸드폰 | E-Mail | 전화번호 | 팩스번호 | 방문날짜
삼성해외여행사 | 정진규 사장 | [PHONE] | [EMAIL] | 055)363-6100 | 055)364-8700 | 2005-04-13 00:00:00
// | [NAME] | 010-4447-6800 | [EMAIL] | // | //
// (본사) | [NAME] |  |  | 055)385-6700 | 055)383-6666
<< ㅇ  >>
여행사명 | 담당자 | 핸드폰 | E-Mail | 전화번호 | 팩스번호 | 방문날짜
<< ㅈ  >>
여행사명 | 담당자 | 핸드폰 | E-Mail | 전화번호 | 팩스번호 | 방문날짜
<< ㅊ  >>
여행사명 | 담당자 | 핸드폰 | E-Mail | 전화번호 | 팩스번호 | 방문날짜
<< ㅌ  >>
여행사명 | 담당자 | 핸드폰 | E-Mail | 전화번호 | 팩스번호 | 방문날짜
<< ㅍ  >>
여행사명 | 담당자 | 핸드폰 | E-Mail | 전화번호 | 팩스번호 | 방문날짜
<< ㅎ  >>
여행사명 | 담당자 | 핸드폰 | E-Mail | 전화번호 | 팩스번호 | 방문날짜
한솔고속관광 | 이경미 대리 | 016-9775-6365 |  | 055)372-3333 | 055)382-3333
// | 윤창현 대리 | [PHONE] | [EMAIL] | // | //
// | 박원아 | [PHONE] |  | // | //
현대드림투어 | 이경훈 사장 | [PHONE] | [EMAIL] | 055)365-8877 | 055)365-3676
Spreadsheet: 4aa89cb2-d6e5-439a-88b5-b3a292a905bc
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | Job Corps Common Measures Performance Result by Selected Program Year
 | Common Measures Performance Indicators | PY07 Result | PY08 Result | PY09 Result | PY10 Result | PY11 Result
 | Entered Employment/Education | 0.73 | 0.66 | 0.6575 | 0.7339 | 0.73
 | Attained HSD/GED or Career Technical Training Certificate | 0.53 | 0.55 | 0.606 | 0.6437 | 0.6489
 | Achieved Literacy or Numeracy Gains | 0.53 | 0.58 | 0.6406 | 0.6532 | 0.6465
 | Source: Common Measures Report.
Spreadsheet: 52194d1251895005-rank-query-uploadfile
Sheet: Championship Leaderboard

 |  | Position |  | Old Links | Fairhaven | Clitheroe | Lancaster | Pleasington | Fleetwood | Shaw Hill | Green Drive | Total
 |  | #N/A | DS | 16 | 18 | 16 | 16 | 15 | 11 | 0 | 0 | 92 |  |  |  | 18 | 34 | 50 | 66 | 81 | 92 | 92 | 92
 |  | #N/A | SG | 20 | 13 | 18 | 0 | 12 | 16 | 0 | 0 | 79 |  | No. of Scores to Count |  | 20 | 38 | 54 | 67 | 79 | 79 | 79 | 79
 |  |  | AL | 12 | 5 | 8 | 20 | 16 | 13 | 0 | 0 | 74 |  | 6 |  | 20 | 36 | 49 | 61 | 69 | 74 | 74 | 74
 |  |  | [NAME] | 14 | 14 | 7 | 11 | 8 | 20 | 0 | 0 | 74 |  |  |  | 20 | 34 | 48 | 59 | 67 | 74 | 74 | 74
 |  |  | PC | 14 | 16 | 20 | 8 | 11 | 12 | 0 | 0 | 81 |  |  |  | 20 | 36 | 50 | 62 | 73 | 81 | 81 | 81
 |  |  | TD | 18 | 13 | 15 | 7 | 7 | 18 | 0 | 0 | 78 |  |  |  | 18 | 36 | 51 | 64 | 71 | 78 | 78 | 78
 |  |  | BB | 15 | 10 | 10 | 15 | 18 | 0 | 0 | 0 | 68 |  |  |  | 18 | 33 | 48 | 58 | 68 | 68 | 68 | 68
 |  |  | BS | 9 | 7 | 15 | 15 | 20 | 8 | 0 | 0 | 74 |  |  |  | 20 | 35 | 50 | 59 | 67 | 74 | 74 | 74
 |  |  | JF | 10 | 15 | 7 | 12 | 10 | 15 | 0 | 0 | 69 |  |  |  | 15 | 30 | 42 | 52 | 62 | 69 | 69 | 69
 |  |  | AW | 0 | 8 | 9 | 7 | 13 | 9 | 0 | 0 | 46 |  |  |  | 13 | 22 | 31 | 39 | 46 | 46 | 46 | 46
 |  |  | MB | 0 | 10 | 12 | 15 | 10 | 14 | 0 | 0 | 61 |  |  |  | 15 | 29 | 41 | 51 | 61 | 61 | 61 | 61
 |  |  | PW | 9 | 7 | 12 | 10 | 14 | 0 | 0 | 0 | 52 |  |  |  | 14 | 26 | 36 | 45 | 52 | 52 | 52 | 52
 |  |  | [NAME] | 0 | 20 | 15 | 18 | 0 | 0 | 0 | 0 | 53 |  |  |  | 20 | 38 | 53 | 53 | 53 | 53 | 53 | 53
 |  |  | PM | 0 | 11 | 5 | 10 | 0 | 11 | 0 | 0 | 37 |  |  |  | 11 | 22 | 32 | 37 | 37 | 37 | 37 | 37
 |  |  | test1 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A |  |  |  | 11 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | test2 |  |  |  |  |  |  |  |  | #N/A |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | test3 |  |  |  |  |  |  |  |  | #N/A |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | test4 |  |  |  |  |  |  |  |  | #N/A |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | test5 |  |  |  |  |  |  |  |  | #N/A |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | test6 |  |  |  |  |  |  |  |  | #N/A |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | [NAME] |  |  |  |  |  |  |  |  | #N/A |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | test8 |  |  |  |  |  |  |  |  | #N/A |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | test9 |  |  |  |  |  |  |  |  | #N/A |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | test10 |  |  |  |  |  |  |  |  | #N/A |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 750120d1633283041-indirect-formula-for-auto-categorize-advanced-filter-for-budget-payments
Sheet: Test

Posting Date | Description | Category | Amount | Index Cabegory |  |  |  | Key Word | Category
2021-08-31 00:00:00 | Online Payment MORTGAGE PAYMENT |  | -575 |  |  |  |  | MORTGAGE | Mortgage
2021-08-31 00:00:00 | Online Payment BOA |  | -880 |  |  |  |  | BOA | Mortgage
2021-08-30 00:00:00 | COMCAST ONLINE AUTODRAFT |  | -70 |  |  |  |  | COMCAST | Internet
2021-08-25 00:00:00 | Online Payment HOA Condominium Association |  | -198 |  |  |  |  | HOA | HOA
2021-08-24 00:00:00 | Spotify USA [PHONE] NY                   08/24 |  | -17.37 |  |  |  |  | Spotify | Subscription - Music
2021-08-23 00:00:00 | XCEL ENERGY-PSCO XCELENERGY |  | -92.14 |  |  |  |  | XCEL | Utilies
Spreadsheet: 035d692b-1b62-4805-b6f1-bd3da7eed116
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-08-05 12:30:37.410000
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.625 | 101.674 | 101.549 | 101.424 | 101.049 |  | and are added to price quote
4.5 | 101.253 | 101.128 | 101.003 | 100.628
4.375 | 100.708 | 100.583 | 100.458 | 100.083 |  | Note: | Refer To Price [NAME]
4.25 | 99.732 | 99.607 | 99.482 | 99.107 |  |  | For all Price Adjs
4.125 | 98.487 | 98.362 | 98.237
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 101.422 | 101.297 | 101.172 | 100.797
3.75 | 100.861 | 100.736 | 100.611 | 100.236
3.625 | 99.941 | 99.816 | 99.691 | 99.316
3.5 | 99.615 | 99.49 | 99.365 | 98.99
3.375 | 99.172 | 99.047 | 98.922
 |  |  |  |  |  | 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-08-19 12:30:37.410000
30 DAY | 2011-09-03 12:30:37.410000
45 DAY | 2011-09-18 12:30:37.410000
60 DAY | 2011-10-03 12:30:37.410000
90 DAY | 2011-11-02 12:30:37.410000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 820111d1677863334-import-data-from-another-sheet-if-conditions-are-met-test-1-1-
Sheet: May-22

Grade | etc | etc | etc | Salary 1
ALUNO | Individual | 1x | 75min | 1
ALUNO | Individual | 1x | 60min | 2
ALUNO | Individual | 2x | 75min | 3
ALUNO | Individual | 2x | 60min | 4
ALUNO | Individual | 3x | 75min | 5
ALUNO | Individual | 3x | 60min | 6
ALUNO | Individual | 4x | 75min | 7
ALUNO | Individual | 4x | 60min | 8
ALUNO | Individual | 5x | 75min | 9
ALUNO | Individual | 5x | 60min | 10
ALUNO | Dupla | 1x | 75min | 11
ALUNO | Dupla | 1x | 60min | 12
ALUNO | Dupla | 2x | 75min | 13
ALUNO | Dupla | 2x | 60min | 14
ALUNO | Dupla | 3x | 75min | 15
ALUNO | Dupla | 3x | 60min | 16
ALUNO | Dupla | 4x | 75min | 17
ALUNO | Dupla | 4x | 60min | 18
ALUNO | Dupla | 5x | 75min | 19
ALUNO | Dupla | 5x | 60min | 20
ALUNO | [NAME] | 1x | 75min | 21
ALUNO | [NAME] | 1x | 60min | 22
ALUNO | [NAME] | 2x | 75min | 23
ALUNO | [NAME] | 2x | 60min | 24
ALUNO | [NAME] | 3x | 75min | 25
ALUNO | [NAME] | 3x | 60min | 26
ALUNO | [NAME] | 4x | 75min | 27
ALUNO | [NAME] | 4x | 60min | 28
ALUNO | [NAME] | 5x | 75min | 29
ALUNO | [NAME] | 5x | 60min | 30
ALUNO | Grupa | 1x | 75min | 31
ALUNO | Grupa | 1x | 60min | 32
ALUNO | Grupa | 2x | 75min | 33
ALUNO | Grupa | 2x | 60min | 34
ALUNO | Grupa | 3x | 75min | 35
ALUNO | Grupa | 3x | 60min | 36
ALUNO | Grupa | 4x | 75min | 37
ALUNO | Grupa | 4x | 60min | 38
ALUNO | Grupa | 5x | 75min | 39
ALUNO | Grupa | 5x | 60min | 40
PROFESSOR | Individual | 1x | 75min | 41
PROFESSOR | Individual | 1x | 60min | 42
PROFESSOR | Individual | 2x | 75min | 43
PROFESSOR | Individual | 2x | 60min | 44
PROFESSOR | Individual | 3x | 75min | 45
PROFESSOR | Individual | 3x | 60min | 46
PROFESSOR | Individual | 4x | 75min | 47
PROFESSOR | Individual | 4x | 60min | 48
PROFESSOR | Individual | 5x | 75min | 49
PROFESSOR | Individual | 5x | 60min | 50
PROFESSOR | Dupla | 1x | 75min | 51
PROFESSOR | Dupla | 1x | 60min | 52
PROFESSOR | Dupla | 2x | 75min | 53
PROFESSOR | Dupla | 2x | 60min | 54
PROFESSOR | Dupla | 3x | 75min | 55
PROFESSOR | Dupla | 3x | 60min | 56
PROFESSOR | Dupla | 4x | 75min | 57
PROFESSOR | Dupla | 4x | 60min | 58
PROFESSOR | Dupla | 5x | 75min | 59
PROFESSOR | Dupla | 5x | 60min | 60
PROFESSOR | [NAME] | 1x | 75min | 61
PROFESSOR | [NAME] | 1x | 60min | 62
PROFESSOR | [NAME] | 2x | 75min | 63
PROFESSOR | [NAME] | 2x | 60min | 64
PROFESSOR | [NAME] | 3x | 75min | 65
PROFESSOR | [NAME] | 3x | 60min | 66
PROFESSOR | [NAME] | 4x | 75min | 67
PROFESSOR | [NAME] | 4x | 60min | 68
PROFESSOR | [NAME] | 5x | 75min | 69
PROFESSOR | [NAME] | 5x | 60min | 70
PROFESSOR | Grupa | 1x | 75min | 71
PROFESSOR | Grupa | 1x | 60min | 72
PROFESSOR | Grupa | 2x | 75min | 73
PROFESSOR | Grupa | 2x | 60min | 74
PROFESSOR | Grupa | 3x | 75min | 75
PROFESSOR | Grupa | 3x | 60min | 76
PROFESSOR | Grupa | 4x | 75min | 77
PROFESSOR | Grupa | 4x | 60min | 78
PROFESSOR | Grupa | 5x | 75min | 79
PROFESSOR | Grupa | 5x | 60min | 80
Spreadsheet: 56375d1256574607-if-function-deeper-than-8-nested-levels-indicator
Sheet: Sheet1

 |  |  |  |  |  | a
 |  |  |  |  |  | b
 |  |  |  |  |  | c
 |  | Unit:
 |  | Level 3 | Level 4 | Level 5 | Level 6 | Level 7
 |  | 0 | They combine and refine different forms of information from various sources. | They use ICT to structure, refine and present information in different forms and styles for specific purposes and audiences. | They plan and design ICT-based solutions to meet a specific purpose and audience, demonstrating increased integration and efficiency in their use of ICT tools. | 0 |  | effort | BFL/Warnings | detention(auto) | HWK |  | highest level achieved int THIS lesson | HWK score
 |  | eg: tell me | eg:show me | eg: show bias etc on PC | eg:>1 w/s shown | eg: write/tell and choice made
 |  | a | a |  | a | a |  | 3 |  |  |  |  | 3a | 0 | should read '4a'
 |  | a | a | a | c | a |  |  |  |  |  |  | #N/A | 0 | should be '5a'
 |  | a | a |  | a | a |  | 3 |  |  |  |  | 3a | 0
 |  | a | a | a | a | a |  | 3 |  |  |  |  | 7a | 0
 |  | a | c | a | a | a |  | 3 |  |  |  |  | #N/A | 0 | should read '4c'
 |  | a |  | a | a | a |  | 3 | 1 |  |  |  | 5a | 0 | should read '3a'
 |  | a |  | a | a | a |  | 3 |  |  |  |  | 5a | 0