tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 220381d1363136601-find-max-vaules-of-a-set-of-data-max-left_right-of-min-example
Sheet: Sheet1

319 | 320 | 320 | 320 | 319 | 319 | 319 | 319 | 318 | 318 | 318 | 317 | 316 | 316 | 315 | 316 | 317 | 317 | 318 | 318 | 319 | 320 | 320 | 321 | 322 | 322 | 323 | 323 | 323 | 324 | 323 | 324
Min Val =
[NAME] of =
[NAME] of =
Single Cell Solutions
[NAME] of =
[NAME] of =
Spreadsheet: 38683d1236826283-how-to-manipulate-current-and-last-values-of-a-cell-oec-spreadsheet-a
Sheet: John's DOM Layout

1 |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A |  | 0 | 0
 | 1
 |  |  |  |  |  | Ask | Ask [NAME]
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 739.75 | 4
 |  |  |  |  |  | 737 | 4
 |  |  |  |  |  | 736 | 2
 |  |  |  |  |  | 735 | 3
 |  |  |  |  |  | 730.5 | 1
 |  |  |  |  |  | 730 | 1
 |  |  |  |  |  | 728.5 | 2
 |  |  |  |  |  | 727 | 21
 |  |  |  |  |  | 726.5 | 26
 |  |  |  |  |  | 725.75 | 1
 | Last | Size Last |  |  |  | 725.25 | 6
 | 720.5 | 1 |  |  |  | 724.75 | 1
 |  |  |  |  |  | 724.25 | 1
 |  |  |  |  |  | 723.5 | 3
 |  | Trade Size | Trade Size |  |  | 723 | 100 |  |  | W
 |  | Taking | Hitting |  |  | 722.75 | 3
 |  | Offers | Bids |  |  | 722.5 | 1
Current Trade Size: |  | 1 | 0 |  |  | 722 | 1
Change from prior: |  | 0 | 0 |  |  | 721.75 | 17
Cummulative Trades : |  | 0 | 0 |  |  | 721.5 | 1181 |  |  | WWWWWWWWWWWW
 |  |  |  |  |  | 721.25 | 1039 |  |  | WWWWWWWWWW
 |  | 1 | 1 |  |  | 721 | 1066 |  |  | WWWWWWWWWWW
 |  | 1 | 1 |  |  | 720.75 | 753 | 1.157033518078649 | 0.9606066989677691 | WWWWWWWW
 |  |  | Z | 720.5 | 1 | 720.5 | 323 | 4384 | 4560 | WWW
4747 | 3789 | 67 | 720.25 | 720.5 | 0 |  |  |  | W
1.041008771929825 | 0.864279197080292 | 395 | 720 | 0 | 0 |  |  |  | [NAME]
 |  | 794 | 719.75 | 0 | 0 |  |  |  | WWWWWWWW
 |  | 1582 | 719.5 |  |  |  |  |  | WWWWWWWWWWWWWWWW
 |  | 899 | 719.25 |  |  |  |  |  | WWWWWWWWW
 |  | 10 | 719
 |  | 8 | 718.75
 |  | 34 | 718.5
 |  | 90 | 718.25 |  |  |  |  |  | W
 |  | 13 | 718
 |  | 4 | 717.75
 |  | 2 | 717.5
 |  | 15 | 717.25
 |  | 1 | 717
 |  | 4 | 716.75
 |  | 3 | 716.25
 |  | 1 | 715.75
 |  | 5 | 715.5
 |  | 4 | 715.25
 |  | 11 | 714.75
 |  | 1 | 714.5
 |  | 1 | 714.25
 |  | 7 | 713
 |  | 7 | 712.75
 |  | 306 | 712.5 |  |  |  |  |  | WWW
 |  | 1 | 712.25
 |  | 201 | 712 |  |  |  |  |  | WW
 |  | 7 | 711.25
 |  | 1 | 711
 |  | 8 | 710.75
 |  | 5 | 710.5
 |  | 5 | 710
 |  | 250 | 709.5 |  |  |  |  |  | WWW
 |  | 2 | 708
 |  | 1 | 705
 |  | 1 | 682
 |  | 1 | 349.25
 |  | Bid Size | Bid
Spreadsheet: 132010d1323438849-nested-if-or-and-matched-indexed-statements-final-yez-sample
Sheet: Pre.Post Accom

 | Pre-tour Accommodation in Amsterdam |  |  |  |  |  | Post-tour Accommodation in Amsterdam
 | Tour code |  |  | Date tour starts |  |  | Tour code |  |  | Date tour ends
 | Name |  | Room Type | # of nights | Pax arrives at hotel |  | Name |  | Room Type | # of nights | Pax departs hotel
1 | Driver |  | Single | 1 |  |  | Driver |  | single | 2
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
Spreadsheet: 74323d1274871943-excel-2007-ifs-function-simplified
Sheet: C2

 |  | SCHOOL
 |  | Casual Relief
Casual Teacher
Period | Class | Room | Replacing
Period 0 or Roll Call
Period 1
Period 2
Recess
Period 3
Period 4
Lunch 1
Lunch 2
Period 5
Period 6
Spreadsheet: 723943d1615969365-diet-plan-formula-kopia-pliku-weekly-macro-tracker
Sheet: Lookups

Meal Descriptions |  | Meal Choice |  | Day |  | Serving Proportion |  | Target Day |  | Godziny posiłów |  |  | Ilość treningów |  |  | Aktywność
Meal 1 |  | Breakfast |  | Mon |  | 0.1 |  | High |  | 00:00 |  |  | 0 |  |  | Siedzący tryb życia poza treningami |  |  |  |  | 0.2
Meal 2 |  | Snack 1 |  | Tue |  | 0.2 |  | Low |  | 00:30 |  |  | 1 |  |  | Sporadyczne chodzenie poza treningami |  |  |  |  | 0.4
Meal 3 |  | Snack 2 |  | Wed |  | 0.25 |  | Mid |  | 1:00 |  |  | 2 |  |  | Duża aktywność fizyczna poza treningami |  |  |  |  | 0.7
Meal 4 |  | Snack 3 |  | Thu |  | 0.3 |  |  |  | 1:30 |  |  | 3
Meal 5 |  | Lunch |  | Fri |  | 0.33 |  |  |  | 2:00
Meal 6 |  | Dinner |  | Sat |  | 0.4 |  |  |  | 2:30 |  |  | Rodzaj treningu
Meal 7 |  | Supper |  | Sun |  | 0.5 |  |  |  | 3:00 |  |  | [NAME]
Meal 8 |  | Pre Train |  |  |  | 0.6 |  |  |  | 3:30 |  |  | Siłowy
Meal 9 |  | Mid Train |  |  |  | 0.66 |  |  |  | 4:00
 |  | Post Train |  |  |  | 0.7 |  |  |  | 4:30 |  |  | Cel
 |  |  |  |  |  | 0.75 |  |  |  | 5:00 |  |  | Redukcja tkanki tłuszczowej |  |  | -300
 |  |  |  |  |  | 0.8 |  |  |  | 5:30 |  |  | [NAME] mięśniowej |  |  | 300
 |  |  |  |  |  | 0.9 |  |  |  | 6:00 |  |  | Utrzymanie wagi |  |  | 0
 |  |  |  |  |  | 1 |  |  |  | 6:30
 |  |  |  |  |  | 1.1 |  |  |  | 7:00 |  |  | [NAME]
Type |  |  |  |  |  | 1.2 |  |  |  | 7:30 |  |  | Nie
 |  |  |  |  |  | 1.3 |  |  |  | 8:00
Fruit |  |  |  |  |  | 1.4 |  |  |  | 8:30
Vegetables |  |  |  |  |  | 1.5 |  |  |  | 9:00
Meat |  |  |  |  |  | 1.6 |  |  |  | 9:30
 |  |  |  |  |  | 1.7 |  |  |  | 10:00
 |  |  |  |  |  | 1.8 |  |  |  | 10:30
 |  |  |  |  |  | 1.9 |  |  |  | 11:00
 |  |  |  |  |  | 2 |  |  |  | 11:30
 |  |  |  |  |  | 3 |  |  |  | 12:00
 |  |  |  |  |  | 4 |  |  |  | 12:30
 |  |  |  |  |  | 5 |  |  |  | 13:00
 |  |  |  |  |  | 6 |  |  |  | 13:30
 |  |  |  |  |  |  |  |  |  | 14:00
 |  |  |  |  |  |  |  |  |  | 14:30
 |  |  |  |  |  |  |  |  |  | 15:00
 |  |  |  |  |  |  |  |  |  | 15:30
 |  |  |  |  |  |  |  |  |  | 16:00
 |  |  |  |  |  |  |  |  |  | 16:30
 |  |  |  |  |  |  |  |  |  | 17:00
 |  |  |  |  |  |  |  |  |  | 17:30
 |  |  |  |  |  |  |  |  |  | 18:00
 |  |  |  |  |  |  |  |  |  | 18:30
 |  |  |  |  |  |  |  |  |  | 19:00
 |  |  |  |  |  |  |  |  |  | 19:30
 |  |  |  |  |  |  |  |  |  | 20:00
 |  |  |  |  |  |  |  |  |  | 20:30
 |  |  |  |  |  |  |  |  |  | 21:00
 |  |  |  |  |  |  |  |  |  | 21:30
 |  |  |  |  |  |  |  |  |  | 22:00
 |  |  |  |  |  |  |  |  |  | 22:30
 |  |  |  |  |  |  |  |  |  | 23:00
 |  |  |  |  |  |  |  |  |  | 23:30
Spreadsheet: 128210d1320854725-r2-value-from-regr-lin-and-regression-on-chart-cartel1
Sheet: Foglio1

 | X | Y
 | 12 | 24.3
 | 13 | 26.2
 | 14 | 27.5
 | 15 | 30.2
 | [NAME]
m | 2.00299727520436 | 0
 | 0.01370186636700763 | #N/A
R2 | 0.9998596349357431 | 0.3712169152712088
 | 21369.83957289709 | 3
 | 2944.806594005449 | 0.4134059945504154 | 0.9998596349357431
 | X | Y
 | 12 | 24.3
 | 13 | 26.2
 | 14 | 27.5
 | 15 | 30.2
 | [NAME]
m | 1.899999999999999 | 1.400000000000009
 | 0.1897366596101027 | 2.570213998872466
R2 | 0.9804454101032049 | 0.4242640687119283
 | 100.2777777777778 | 2
 | 18.04999999999999 | 0.3599999999999997 | 0.9804454101032049
Spreadsheet: 100819d1299058448-multiple-x-axis-value-misalignment-766359b
Sheet: Seasonal Raw

Months |  | Weeks |  | TV Stands |  | Fireplaces, Electric |  | Grills |  | Patio/Outdoor Furniture |  | Fitness/Exercise Equipment |  | Luggage |  | Futons |  | Fireplaces, Gel |  | Computer Desks |  | [NAME] |  | [NAME]
 | January | 1 | =IF(VLOOKUP('Seasonal Raw'!$F$1,'Seasonality Speculative'!A:B,2,FALSE)<>"",
 |  | 2 | ,NA())
 |  | 3
 |  | 4
February |  | 5
 |  | 6
 |  | 7
 |  | 8
 | March | 9
 |  | 10
 |  | 11
 |  | 12
April |  | 13
 |  | 14
 |  | 15
 |  | 16
 | May | 17
 |  | 18
 |  | 19
 |  | 20
 |  | 21
June |  | 22
 |  | 23
 |  | 24
 |  | 25
 | July | 26
 |  | 27
 |  | 28
 |  | 29
 |  | 30
August |  | 31
 |  | 32
 |  | 33
 |  | 34
 | September | 35
 |  | 36
 |  | 37
 |  | 38
October |  | 39
 |  | 40
 |  | 41
 |  | 42
 |  | 43
 | November | 44
 |  | 45
 |  | 46
 |  | 47
December |  | 48
 |  | 49
 |  | 50
 |  | 51
 | January | 52
 |  | 53
 |  | 1
Spreadsheet: darrell_schoolcraft__7303__imball0201
Sheet: crosstex

Crosstexx Energy Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
 | contr 21571 - poi 56935 |  | contr 23994 - poi 58444
 | Integrated Services DP |  | I.S.I. Farm Tap- [NAME]
 | Measured | Scheduled | Measured | Scheduled
1 | -2143 | -1613 | -799 | -2000
2 | -2506 | -1613 | -2650 | -2000
3 | -2105 | -1613 | -2614 | -2000
4 | -2259 | -1613 | -2483 | -2000
5 | -1911 | -1613 | -2346 | -2000
6 | -2272 | -1613 | -807 | -2000
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
index
2001-12-31 00:00:00 |  |  |  |  | -133109.25
2002-01-06 00:00:00
CBS Volume
 |  |  | -40794
Spreadsheet: 829489d1684252291-lookupvalue-in-xlookup-that-contains-3-values-sample
Sheet: master

week | site |  | datum | ANT | ANT DATE
wk 19 | AAAAA | 2023-05-08 00:00:00 | 2023-05-08 00:00:00 | ANT | 2023-05-20 11:24:40
wk 19 | AAAAB | 2023-05-08 00:00:00 | 2023-05-08 00:00:00 | ANT | 2023-05-16 00:00:00
wk 19 | AAAAC | 2023-05-08 00:00:00 | 2023-05-08 00:00:00 | ANT | 2023-05-24 00:00:00
 |  |  |  |  | what I need
Spreadsheet: 169586d1342969424-how-to-apply-countif-formula-when-data-are-on-different-sheets-book1
Sheet: September

 |  |  |  | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun
S.no | Employee Name | SID | Process | 2012-09-01 00:00:00 | 2012-09-02 00:00:00 | 2012-09-03 00:00:00 | 2012-09-04 00:00:00 | 2012-09-05 00:00:00 | 2012-09-06 00:00:00 | 2012-09-07 00:00:00 | 2012-09-08 00:00:00 | 2012-09-09 00:00:00 | 2012-09-10 00:00:00 | 2012-09-11 00:00:00 | 2012-09-12 00:00:00 | 2012-09-13 00:00:00 | 2012-09-14 00:00:00 | 2012-09-15 00:00:00 | 2012-09-16 00:00:00 | 2012-09-17 00:00:00 | 2012-09-18 00:00:00 | 2012-09-19 00:00:00 | 2012-09-20 00:00:00 | 2012-09-21 00:00:00 | 2012-09-22 00:00:00 | 2012-09-23 00:00:00 | 2012-09-24 00:00:00 | 2012-09-25 00:00:00 | 2012-09-26 00:00:00 | 2012-09-27 00:00:00 | 2012-09-28 00:00:00 | 2012-09-29 00:00:00 | 2012-09-30 00:00:00
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Spreadsheet: 28263d1222292936-order-query-book1
Sheet: Sheet1

VS1 | 1
VS100 | 100
VS1000 | 1000
VS11 | 11
VS12 | 12
VS13 | 13
VS14 | 14
VS15 | 15
VS16 | 16
VS17 | 17
VS2 | 2
VS20 | 20
VS4 | 4
[NAME] | 44
VS6 | 6
VS7 | 7
[NAME] | 9
Spreadsheet: 35359d1232976760-copying-hyperlinks-december-2008-excel-forum-daily-accts
Sheet: 1

Total Money in the accounts
at the beginning of 1 DEC.  2008
Name of Company | Money X | Money Y | Total
Вагриус | 80030.42 | 0 | 80030.42
Вагриус книги | 238.7 | 0 | 238.7
Вагриус правда | 0 | 0 | 0
Вагриус минус | 628.08 | 0 | 628.08
Плюс-минус | 2982.36 | 0 | 2982.36
Издательство Вагриус | 444.69 | 0 | 444.69
Вагриус плюс-минус | 0 | 0 | 0
Grand Total | 84324.25 | 0 | 84324.25
Spreadsheet: 95101d1294780260-match-cells-between-column-and-return-result-book1_redmid17
Sheet: Sheet1

share1 | server1\group1\share4 | server2\group4\share1
share2 | server1\group2\share2 | server1\group2\share2
share3 | server2\group3\share3 | server2\group3\share3 | Corrected
share3 | server2\group3\share4 |  | share3 | server2\group3\share3
share4 | server2\group4\share1 | server1\group1\share4
share5 | server3\group5\share7
share6 | server3\group6\share6 | server3\group6\share6
ABCD-3B_XYZ_FIN | abcde1001pu\xx_s29\ABCD-A_Words-go-here | abcde1001pu\xx_d29\ABCD-3B_XYZ_FIN
ABCD-A_Words-go-here | abcde1001pu\xx_d29\ABCD-3B_XYZ_FIN | abcde1001pu\xx_s29\ABCD-A_Words-go-here
Spreadsheet: 0719ca6f-edb4-4bcd-805a-b4a22c4bf2e1
Sheet: Other (500)

Part II Budget Detail
Amounts paid for services rendered by organizations or personnel not on payroll of the school, and other than Professional and Technical Services (300),
or Purchased Property Services (400).  This would also include expenses for meeting facilities, conference hotels (which may include direct-billed items for
group meals and lodging provided to participants, equipment, space charges, and miscellaneous).  Also, any travel and per-diem expenses for participants.
Other Purchased Services (500)
Description | Project Year 1 | Project Year 2 | Project Year 3 | Total
Spreadsheet: 84002d1284010446-shipping-calculator-shipping-calculator
Sheet: Sheet1

 | DATA |  |  |  |  | TO FIND
 |  |  | Shipping Rate |  |  | Shipping Weight |  | Shipping Price
 | 0g - 100g |  | 1.3 |  |  | 60 |  | ?
 | 101g - 250g |  | 1.6 |  |  | 80 |  | ?
 | 251g - 500g |  | 2 |  |  | 50 |  | ?
 | 501g - 750g |  | 2.35 |  |  | 400 |  | ?
 | 751g - 1000g |  | 2.8 |  |  | 123 |  | ?
 | 1001g - 1250g |  | 3.65 |  |  | 601 |  | ?
 | 1251g - 1500g |  | 4.05 |  |  | 890 |  | ?
 | 1501g - 1750g |  | 4.45 |  |  | 2001 |  | ?
 | 1751g - 2000g |  | 4.9 |  |  | 2000 |  | ?
 | above 2000 |  | 6.5 |  |  | 1100 |  | ?
Spreadsheet: 811631d1672705198-want-to-add-multiple-milestones-colors-in-same-row-to-gantt-study-timeline-gantt
Sheet: Study Timelines Gantt

 | Company name |  |  | Legend | Legend: | On track |  |  |  |  | Low risk |  |  |  |  | Med risk |  |  |  |  | High risk |  |  |  |  | Unassigned
 | Project Lead
 | Project Start Date: | 2022-12-01 00:00:00
 | Scrolling Increment: | 33
 | Milestone description | Category | Progress | Start | Days
 | Dr. [NAME]
 | Pt 1 | On Track | 1 | 2022-10-08 00:00:00 | 14
 | Pt 2 | On Track | 1 | 2022-10-18 00:00:00 | 14
 | Pt 3 | On Track | 1 | 2022-11-13 00:00:00 | 14
 | Pt 4 | On Track | 1 | 2022-12-05 00:00:00 | 14
 | Pt 5 | On Track | 1 | 2023-01-06 00:00:00 | 14
 | Pt 6 | On Track | 1 | 2023-01-14 00:00:00 | 14
 | Pt 7 | On Track | 0 | 2023-02-17 00:00:00 | 14
 | Pt 8 | On Track | 0 | 2023-02-28 00:00:00 | 14
 | Pt 9 | On Track | 0 | 2023-03-11 00:00:00 | 14
 | Pt 10 | On Track | 0 | 2023-03-15 00:00:00 | 14
 | Pt 11 | On Track | 0 | 2023-04-22 00:00:00 | 14
 | Dr. [NAME]
 | Pt 1 | On Track | 0.6 | 2023-01-08 00:00:00 | 14
 | Pt 2 | On Track | 0.5 | 2023-02-18 00:00:00 | 14
 | Pt 3 | On Track | 0 | 2023-02-22 00:00:00 | 14
 | Pt 4 | On Track | 0 |  | 14
 | Pt 5 | On Track | 0 |  | 14
 | Dr. M
 | Pt 1 | On Track |  | 2023-01-08 00:00:00 | 14
 | Pt 2 | On Track |  |  | 14
 | Pt 3 | On Track |  |  | 14
 | Pt 4 | On Track |  |  | 14
 | Pt 5 | On Track |  |  | 14
 | Dr. A
 | Pt 1 | On Track |  |  | 14
 | Pt 2 | On Track |  |  | 14
 | Pt 3 | On Track |  |  | 14
 | Dr. P
 | Pt 1 | On Track |  |  | 14
 | Pt 2 | On Track |  |  | 14
 | Pt 3 | On Track |  |  | 14
 | Pt 4 | On Track |  |  | 14
 | Pt 5 | On Track |  |  | 14
 | Dr. [NAME]
 | Pt 1 | On Track |  |  | 14
 | Pt 2 | On Track |  |  | 14
 | Pt 3 | On Track |  |  | 14
 | Dr. T
 | Pt 1 | On Track |  |  | 14
 | Pt 2 | On Track |  |  | 14
 | Pt 3 | On Track |  |  | 14
 | Dr. [NAME]
 | Pt 1 | On Track |  |  | 14
 | Pt 2 | On Track |  |  | 14
 | Pt 3 | On Track |  | 2023-04-13 00:00:00 | 14
Spreadsheet: 822359d1679303694-merge-tables-and-sum-in-different-sheets-10_60
Sheet: Jan

PRODUCT | 10 | 20 | 30 | 40 | 50 | 60
A | 1 |  | 1 |  | 1 | 1
B | 1 | 1 | 1 | 1 | 1
C |  | 1 | 1 |  |  | 1
D | 1 |  | 1 | 1 | 1
E |  |  |  |  |  | 1
F | 1 | 1 | 1 | 1 | 1
G | 1 |  |  | 1 | 1 | 1
Spreadsheet: 103071d1300902981-sumif-unique-book2
Sheet: Sheet1

1-1 | 8
1-2 | 14
1-3 | 19
2-1 | 2
2-1 | 2
2-2 | 15
5-1 | 16
5-1 | 19
5-1 | 10
5-1 | 14
5-1 | 11
5-1 | 6
5-1 | 1
5-2 | 12
6-1 | 16
6-1 | 16
6-1 | 10
6-1 | 8
6-1 | 5
6-1 | 19
6-1 | 11
6-2 | 18
6-2 | 10
7-1 | 11
7-1 | 5
7-1 | 13
7-1 | 8
7-1 | 2
7-1 | 1
7-1 | 20
7-1 | 2
7-1 | 7
7-1 | 8
7-2 | 16
8-1 | 17
8-2 | 9
9-1 | 6
9-1 | 7
9-1 | 19
9-1 | 14
9-1 | 12
Spreadsheet: 683098d1592484415-cant-figure-out-mid-function-shift-leave
Sheet: Leave Roster

 |  |  | Year: | 2020-01-01 00:00:00
 |  | Annual Leave Groups
 |  | Group 1 |  |  | Group 2 |  |  | Group 3 |  |  | Group 4
 |  |  | R |  |  | J |  |  | P |  |  | M
 |  |  | J |  |  | G |  |  | J |  |  | M
 |  |  | P |  |  | A |  |  |  |  |  | D
 | 2010-01-01 00:00:00
 | 3241
 | 4132 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017 | 2018 | 2019 | 2020
 | 1423 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 3 | 2 | 4
 | 4231 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 4 | 1 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 2 | 4 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 1 | 3 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | * | 2017 | 2018 | 2019 | 2020
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 3 | 2 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 4 | 1 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 1 | 4 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 2 | 3 | 1
Spreadsheet: 685041d1593692206-multiple-independent-columns-pivot-table-pivot-table-issue
Sheet: Sheet1

 | Score | Gender | Region | Age
 | 5 | Male | South | >40
 | 6 | Female | North | >40
 | 7 | Male | East | <40
 | Current
 |  | Column Labels
 |  | Female |  | Female Total | Male |  |  |  | Male Total | Grand Total
 |  | North | North Total |  | East | East Total | South | South Total
 |  | >40 |  |  | <40 |  | >40
 | Average of Score | 6 | 6 | 6 | 7 | 7 | 5 | 5 | 6 | 6
 | Desired
 |  | Column Labels |  |  | Region |  |  |  | Age
 |  | Female | Male | Grand Total | South | North | East | Grand Total | >40 | <40 | Grand Total
 | Average of Score | 6 | 6 | 6 | 5 | 6 | 7 | 6 | 5.5 | 7 | 6
Spreadsheet: 170421d1343265359-how-to-compare-the-similarity-of-2-cells-cell-similarity
Sheet: Sheet1

Acquirer SIC | Target SIC | Similarity |  |  |  |  | Acquirer SIC | Target SIC | Similarity
1896 | 1896 |  |  |  |  |  | 1896 | 1896 |  | <<Better Formula
1963 | 1900 |  |  |  |  |  | 1963 | 1900
6952 | 6327 |  |  |  |  |  | 6952 | 6327
5369 | 5369 |  |  |  |  |  | 5369 | 5369
6321 | 6312 |  |  |  |  |  | 6321 | 6312
1234 | 4321 |  | <<[NAME] - Should be zero |  |  |  | 1234 | 4321
Spreadsheet: 833065d1686758025-extract-string-left-of-first-special-character-extractstring
Sheet: Sheet2

Key | Category |  | Search $ | Exclude$ | Return $
AnyTextChoice5 |  |  | Choice1 |  | Return1
AnyTextChoice3 |  |  | Choice2 | Choice4 | Return2
AnyTextChoice1 |  |  | Choice3 |  | Return3
AnyTextChoice3 |  |  | Choice4 |  | Return4
AnyTextChoice2 |  |  | Choice5 |  | Return5
Choice4Choice2
AnyTextChoice5
AnyTextChoice1
AnyTextChoice4
AnyTextChoice4
AnyTextChoice5
AnyTextChoice5
=IF(ISNUMBER(SEARCH("zabbix[",D2)),"Zabbix Agent Default", IF(ISNUMBER(SEARCH("zabbix.",D2)),"Zabbix Agent Default", IF(ISNUMBER(SEARCH("system.",D2)),"System Parameters Monitoring", IF(ISNUMBER(SEARCH(".discovery",D2)),"System [NAME]", IF(ISNUMBER(SEARCH("systemd",D2)),"System Daemon", IF(ISNUMBER(SEARCH("sensor.",D2)),"System Sensor", IF(ISNUMBER(SEARCH("fan",D2)),"System Fan Monitoring", IF(ISNUMBER(SEARCH("vfs.",D2)),"Virtual File System", IF(ISNUMBER(SEARCH("net",D2)),"Network Monitoring", IF(ISNUMBER(SEARCH("icmp",D2)),"ICMP Monitoring", IF(ISNUMBER(SEARCH("vm.",D2)),"Virtual Memory Monitoring", IF(ISNUMBER(SEARCH("virtualdisk.",D2)),"Virtual Disk Monitoring", IF(ISNUMBER(SEARCH("physicaldisk.",D2)),"Physcial Disk Monitoring", IF(ISNUMBER(SEARCH("proc.",D2)),"Process Monitoring", IF(ISNUMBER(SEARCH("kernel.",D2)),"Kernel Monitoring", IF(ISNUMBER(SEARCH("snmp",D2)),"SNMP Monitoring", IF(ISNUMBER(SEARCH("agent.ping",D2)),"Zabbix Ping Monitoring", IF(ISNUMBER(SEARCH("agent.hostname",D2)),"Zabbix hostname Monitoring", IF(ISNUMBER(SEARCH("agent.version",D2)),"Zabbix Agent [NAME]", "NA")))))))))))))))))))
Spreadsheet: 471915d1469279714-student-info-need-help-pass-fail-na-grades
Sheet: Sheet1

Class | Status | Eng | Urd | Math | Isl | PS | GS | Com | AMD | AGR |  |  | Class | Subject | Pass | Fail | N.A
6Th Red | Pass | 9 | 14 | 27 | 28 | 16 | 1 | 12 | 3 | 26 |  |  | 6Th Red | AMD
6Th Red | Fail | 27 | 18 | 9 | 9 | 20 | 34 | 23 | 31 | 8 |  |  | 6Th Green | AMD
6Th Red | n.a | 1 | 4 | 1 | 0 | 1 | 2 | 2 | 3 | 3 |  |  | 6Th White | Com
6Th Green | Pass | 10 | 39 | 17 | 13 | 26 | 0 | 30 | 0 | 6 |  |  | 7Th Red | URD
6Th Green | Fail | 31 | 1 | 24 | 27 | 14 | 40 | 12 | 38 | 30 |  |  | 7th Green | AMD
6Th Green | n.a | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 5 | 7 |  |  | 7Th White | MATH
6TH White | Pass | 16 | 24 | 22 | 30 | 23 | 5 | 12 | 33 | 32
6TH White | Fail | 17 | 10 | 10 | 4 | 9 | 28 | 21 | 0 | 0
6TH White | n.a | 3 | 2 | 4 | 2 | 4 | 3 | 3 | 3 | 4
7Th Red | Pass | 11 | 24 | 11 | 19 | 25 | 6 | 21 | 9 | 32
7Th Red | Fail | 25 | 11 | 23 | 10 | 9 | 28 | 12 | 24 | 1
7Th Red | n.a | 1 | 2 | 3 | 8 | 3 | 3 | 4 | 4 | 4
7Th Green | Pass | 14 | 33 | 15 | 29 | 33 | 7 | 13 | 10 | 25
7Th Green | Fail | 30 | 11 | 29 | 10 | 11 | 34 | 31 | 35 | 20
7Th Green | n.a | 2 | 2 | 2 | 7 | 2 | 5 | 1 | 1 | 1
7Th White | Pass | 27 | 0 | 10 | 27 | 20 | 6 | 26 | 12 | 21
7Th White | Fail | 1 | 0 | 18 | 1 | 9 | 22 | 2 | 15 | 5
7Th White | n.a | 3 | 31 | 3 | 3 | 2 | 3 | 2 | 4 | 5
Spreadsheet: c372862d-acf4-4929-8fdc-d5878b88a632
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: |  |  | 2013-08-13 09:30:35.240000
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.75 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.625 | 101.628 | 101.503 | 101.378 | 101.003
4.5 | 100.803 | 100.678 | 100.553 | 100.178 |  | Note: | Refer To Price [NAME]
4.375 | 99.934 | 99.809 | 99.684 | 99.309 |  |  | For all Price Adjs
4.25 | 99.219 | 99.094 | 98.969 | 98.344
4.125 | 98.484 | 98.359 | 98.234 | 97.609
4 | 97.575 | 97.45 | 97.325 | 96.7
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.125 | 102 | 101.875 | 101.5
3.875 | 101.988 | 101.863 | 101.738 | 101.363
3.75 | 101.495 | 101.37 | 101.245 | 100.87
3.625 | 101.158 | 101.033 | 100.908 | 100.533
3.5 | 100.668 | 100.543 | 100.418 | 99.793
3.375 | 99.924 | 99.799 | 99.674 | 99.049
3.25 | 99.203 | 99.078 | 98.953 | 98.328 |  | Minimum loan amount:
3.125 | 98.275 | 98.15 | 98.025 | 97.4 |  | 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 | 2013-08-27 09:30:35.240000
30 DAY | 2013-09-11 09:30:35.240000
45 DAY | 2013-09-26 09:30:35.240000
60 DAY | 2013-10-11 09:30:35.240000
90 DAY | 2013-11-10 09:30:35.240000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.