tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 5a5032c5-5a41-447c-a6a0-8cbacd6d132f
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-04 09:31:34.120000
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 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.625 | 101.808 | 101.683 | 101.558 | 101.183
4.5 | 101.599 | 101.474 | 101.349 | 100.974 |  | Note: | Refer To Price [NAME]
4.375 | 101.066 | 100.941 | 100.816 | 100.441 |  |  | For all Price Adjs
4.25 | 100.03 | 99.905 | 99.78
 |  |  |  |  |  | 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
4 | 101.875 | 101.75 | 101.625 | 101.25
3.875 | 101.736 | 101.611 | 101.486 | 101.111
3.75 | 101.175 | 101.05 | 100.925 | 100.55
3.625 | 100.348 | 100.223 | 100.098 | 99.723
3.5 | 100.023 | 99.898 | 99.773
 |  |  |  |  |  | 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-18 09:31:34.120000
30 DAY | 2011-09-02 09:31:34.120000
45 DAY | 2011-09-17 09:31:34.120000
60 DAY | 2011-10-02 09:31:34.120000
90 DAY | 2011-11-01 09:31:34.120000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 773534d1647908276-vlookup-from-rank-and-style-book1
Sheet: Sheet1

How can I create a vlookup formula based on top rank and refer to style. Or is there an easier way for this formula. Thank you.
EXAMPLE 1
LEARNING STYLE
STYLE | IKP | SKOR | RANK | TOP RANK | VLOOKUP
VISUAL | VLBM | 75 |  |  | AUDITORI |  | [NAME] ?
 | VLBI | 55
 | LM | 60
 | VR | 75
AUDITORI | MU | 40
 | NAT | 40
 | INTRA | 80
KINESTETIK | INTER | 75
 | KINES | 55
 | EKSIS | 65
EXAMPLE 2
LEARNING STYLE
STYLE | IKP | SKOR | RANK | TOP RANK | VLOOKUP
VISUAL | VLBM | 90 |  |  | VISUAL |  | [NAME] ?
 | VLBI | 55
 | LM | 60
 | VR | 75
AUDITORI | MU | 40
 | NAT | 40
 | INTRA | 80
KINESTETIK | INTER | 75
 | KINES | 55
 | EKSIS | 65
Spreadsheet: 112182d1308310683-dynamic-charts-in-excel-create-chart-with-the-last-12-entries-example_charting_4_using_offsets
Sheet: LNR2

Month | Header1 | Header2 | Header3 | Header4
2010-02-01 00:00:00 | 135 | 134 | 0.95
2010-03-01 00:00:00 | 139 | 139 | 0.95
2010-04-01 00:00:00 | 84 | 83 | 0.95
2010-05-01 00:00:00 | 74 | 73 | 0.95
2010-06-01 00:00:00 | 123 | 121 | 0.95
2010-07-01 00:00:00 | 104 | 101 | 0.95
2010-08-01 00:00:00 | 123 | 120 | 0.95
2010-09-01 00:00:00 | 56 | 56 | 0.95
2010-10-01 00:00:00 | 64 | 64 | 0.95
2010-11-01 00:00:00 | 85 | 84 | 0.95
2010-12-01 00:00:00 | 47 | 47 | 0.95 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb' 10 | 2010-02-01 00:00:00
2011-01-01 00:00:00 | 112 | 111 | 0.95 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar' 10 | 2010-03-01 00:00:00
2011-02-01 00:00:00 | 75 | #[NAME]! | 0.95 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr'10 | 2010-04-01 00:00:00
2011-03-01 00:00:00 | 100 | 15 | 0.95 | 1 |  | chrtLNR | INDEX(LNR!$A:$A, MATCH("zzz", LNR!$A:$A)):INDEX(LNR!$E:$E, MATCH("zzz", LNR!$A:$A)-9) |  |  |  |  |  |  |  |  |  |  |  | May'10 | 2010-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jun'10 | 2010-06-01 00:00:00
 |  |  |  |  |  | tblLnr5 | INDEX(LNR!chrtLNR, 0, 5) |  |  |  |  |  |  |  |  |  |  |  | Jul'10 | 2010-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aug'10 | 2010-08-01 00:00:00
 |  |  |  |  |  | tlbLnr4 | INDEX(LNR!chrtLNR, 0, 4) |  |  |  |  |  |  |  |  |  |  |  | Sep'10 | 2010-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oct'10 | 2010-10-01 00:00:00
 |  |  |  |  |  | tblLnr2 | INDEX(LNR!chrtLNR, 0, 2) |  |  |  |  |  |  |  |  |  |  |  | Nov'10 | 2010-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dec'10 | 2010-12-01 00:00:00
 |  |  |  |  |  | tblLnrMonth | INDEX(LNR!chrtLNR, 0, 1) |  |  |  |  |  |  |  |  |  |  |  | Jan'11 | 2011-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb`11 | 2011-02-01 00:00:00
 |  |  |  |  |  | Series1 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-03-01 00:00:00 | 2011-03-01 00:00:00
 |  |  |  |  |  | SERIES(LNR!$B$1,tblLnrMonth,tblLnr2,1) |  |  |  |  |  |  |  |  |  |  |  |  | 2011-03-01 00:00:00 | 2011-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-03-01 00:00:00 | 2011-03-01 00:00:00
 |  |  |  |  |  | Series2 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-03-01 00:00:00 | 2011-03-01 00:00:00
 |  |  |  |  |  | SERIES(LNR!$D$1,tblLnrMonth,tblLnr4,2)
 |  |  |  |  |  | Series2
 |  |  |  |  |  | SERIES(LNR!$E$1,tblLnrMonth,tblLnr5,3)
 |  |  |  |  |  |  |  | INDEX(LNR!$A:$A, MATCH(9E307, LNR!$A:$A)):INDEX(LNR!$E:$E, MATCH(9E307, LNR!$A:$A)-9)
 |  |  |  |  |  |  |  | INDEX(LNR!$A:$A, MATCH(9E+307, LNR!$A:$A)):INDEX(LNR!$E:$E, MATCH(9E+307, LNR!$A:$A)-9)
Spreadsheet: 837981d1690567590-lists-excel-list-example
Sheet: Sheet1

HAVE
Student ID | student name | course | Code | current score | final score | unposted current score | unposted final score
2208171411 | Student A | Foundations Clinical | PN102 |  | 0 |  | 0
2008153791 | Student A | Foundations of Practical Nursing | PN104 | 79.04 | 13.09 | 79.04 | 13.09
1801133000 | Student A | IV Therapy | IV202 | 86.67 | 13 | 86.67 | 13
1607120895 | Student B | Career Readiness | CD101 | 73.28 | 7.46 | 73.28 | 7.46
2210173391 | Student B | Nursing III | PN301 | 88 | 66.03 | 88 | 66.03
1912148923 | Student B | [NAME] -Akhere | CLINICAL | 100 | 63.16 | 100 | 63.16
NEED
Student ID | student name | course | Code | current score | final score | unposted current score | unposted final score | course | Code | current score | final score | unposted current score | unposted final score | course | Code | current score | final score | unposted current score | unposted final score
2208171411 | Student A | Foundations Clinical | PN102 |  | 0 |  | 0 | Foundations of Practical Nursing | PN104 | 79.04 | 13.09 | 79.04 | 13.09 | IV Therapy | IV202 | 86.67 | 13 | 86.67 | 13
1607120895 | Student B | Career Readiness | CD101 | 73.28 | 7.46 | 73.28 | 7.46 | Nursing III | PN301 | 88 | 66.03 | 88 | 66.03 | [NAME] -Akhere | CLINICAL | 100 | 63.16 | 100 | 63.16
 | Student A | Foundations Clinical | PN102 |  | 0 |  | 0 | Foundations of Practical Nursing | PN104 | 79.04 | 13.09 | 79.04 | 13.09 | IV Therapy | IV202 | 86.67 | 13 | 86.67 | 13
1607120895 | Student B | Career Readiness | CD101 | 73.28 | 7.46 | 73.28 | 7.46 | Nursing III | PN301 | 88 | 66.03 | 88 | 66.03 | [NAME] -Akhere | CLINICAL | 100 | 63.16 | 100 | 63.16
Spreadsheet: 89706d1289464450-using-spinner-to-increase-decrease-a-minimum-value-allocation-list
Sheet: Sheet 1

 | T-SHIRT ALLOCATION
 | Activation Cycle : |  | 2 | WEEKS |  | DATE : |  |  |  | 11 Oct - 31 Oct
 | PREMIUMS ORDERED | 5000 |  |  |  |  | 5000 |  |  |  | PREMIUMS OUTSTANDING
 | PREMIUM TYPE | Select
 | REGION | EZD | TEAM | CEs | HOURS | DAYS | PPH | SPIN CTRL |  | TOTAL | PREMIUMS FOR EZD
 | KL | [NAME] | LAMP | 28 | 5 | 3 |  | 0
 |  |  | GT | 51 | 5 | 6 |  | 0
 | JB | WA Distributor | LAMP | 12 | 5 | 3 |  | 0
 |  |  | GT | 45 | 5 | 6 |  | 0
 | PG | [NAME] | LAMP | 11 | 5 | 3 |  | 0
 |  |  | GT | 12 | 5 | 6 |  | 0
 | BW | Ban Chuan Agency | LAMP | 4 | 5 | 3 |  | 0
 |  |  | GT | 8 | 5 | 6 |  | 0
 | PRK | [NAME] JITRA | LAMP |  |  |  |  | 0
 |  |  | GT | 6 | 5 | 6 |  | 0
 | IP | [NAME] | LAMP | 9 | 5 | 3 |  | 0
 |  |  | GT | 15 | 5 | 6 |  | 0
 | SBN | KTT | LAMP |  | 5 | 3 |  | 0
 |  |  | GT | 6 | 5 | 6 |  | 0
 | MLK | [NAME] | LAMP | 9 | 5 | 3 |  | 0
 |  |  | GT | 12 | 5 | 6 |  | 0
 | KTN | [NAME] | LAMP | 7 | 5 | 3 |  | 0
 |  |  | GT | 9 | 5 | 6 |  | 0
 | HQ | [NAME]
 | GRAND TOTAL |  |  |  |  |  |  |  |  |  | 0
 | Notes:
Spreadsheet: 60918d1261499325-attendance-spreadsheet-summary-sample_attendance
Sheet: Sheet1

STUDENT | GRADE | Monday [NAME] | Tuesday [NAME] | Wednesday [NAME] | Thursday [NAME] | mon | tue | wed | thu | mon | tue | wed | thu
[NAME] | 9 | 0 | 1 | 0 | 0 |  | t
[NAME] | 12 | 1 | 1 | 0 | 2 | m |  |  | h |  | t |  | h
Sue | 10 | 1 | 0 | 1 | 1 | m |  | w |  |  |  |  | h
[NAME] | 11 | 1 | 1 | 0 | 1 |  | t |  | h | m
[NAME] | 12 | 1 | 1 | 1 | 0 | m |  |  |  |  | t | w
[NAME] | 9 | 1 | 0 | 1 | 0 |  |  | w |  | m
[NAME] | 11 | 0 | 1 | 1 | 1 |  | t | w |  |  |  |  | h
 |  |  | TOTAL STUDENTS |  |  | 3 | 3 | 3 | 2 | 2 | 2 | 1 | 3
 |  |  | TOTAL FRESHMEN
 |  |  | TOTAL SOPHOMORES
 |  |  | TOTAL JUNIORS
 |  |  | TOTAL SENIORS
Spreadsheet: 289119d1389398718-excel-2007-drop-down-box-range-help-drop-down-sample
Sheet: Sheet1

1st Drop Down |  |  | Change1 |  | Change2 |  |  | Drop-Down A2 |  | Drop Down Change 1 |  |  |  | Drop Down Change 2
Yes |  |  |  |  | Unknown1 |  |  | Fixed |  | These are fixed data values |  |  |  | These Change
 |  |  |  |  |  |  |  | Yes |  | Name1 | Date1 | Unknown1
 |  |  |  |  |  |  |  | No |  | [NAME] | Date2 | Unknown2
 |  |  |  |  |  |  |  | Maybe |  | Name3 | Date3 | Unknown3
 |  |  |  |  |  |  |  |  |  | Name4 | [NAME] | Unknown4
 |  |  |  |  |  |  |  |  |  | Name5 | Date5 | Unknown5
 |  |  |  |  |  |  |  |  |  | Name6 | Date6 | Unknown6
 |  |  |  |  |  |  |  |  |  | Name7 | Date7 | Unknown7
 |  |  |  |  |  |  |  |  |  | Name8 | Date8 | Unknown8
 |  |  |  |  |  |  |  |  |  | Name9 | Date9 | Unknown9
 |  |  |  |  |  |  |  |  |  | Name10 | Date10 | Unknown10
 |  |  |  |  |  |  |  |  |  | Name11 | Date11 | Unknown11
Spreadsheet: 30889d1226587181-multiple-row-contents-into-one-row-multiple-row-contents-into-one-row
Sheet: Catalog

Material | PO Text | OEM part no. | OEM name
90100100 | RANGE 3 CONDUCTOR BOX X PIN | 123-8954 | AB-SYSTEMS
 | 309.72 LB/FT (1.000" WT)
 | XLF CONNECTIONS
90100101 | COND,30,310#,X52,XLF B,W/FS,R3 | 123-8955 | AB-SYSTEMS
 | RANGE 3 CONDUCTOR BOX X FLOAT SHOE
 | 309.72 LB/FT (1.000" WT)
 | XLF BOX X WELD ON FLOAT SHOE
90100102 | RANGE 3 CONDUCTOR BOX X PIN WITH STABILIZER FINS TYPE ? | 123-8956 | AB-SYSTEMS
 | 309.72 LB/FT (1.000" WT)
 | XLF CONNECTIONS
 | W/STABILIZER FINS WELDED ON
 | STARTER HEAD
90100103 | RANGE 3 CONDUCTOR BOX X PIN WITH CAMERON LOAD RING | 123-8958 | AB-SYSTEMS
 | 309.72 LB/FT (1.000" WT)
 | XLF CONNECTIONS
90100104 | RANGE 3 CASING BOX X PIN | 1012235-1 | MANNESMAN
 | 87.5 LB/FT (0.435" WT)
 | BIG OMEGA CONNECTIONS (WITH K-55 COUPLING)
90100105 | CASING COUPLING |  | STATES OIL
 | 87.5 LB/FT (0.435" WT)
 | BIG OMEGA CONNECTION
90100106 | RANGE 3 CASING PIN X PIN |  | STATES OIL
 | 87.5 LB/FT (0.435" WT)
 | API BUTTRESS CONNECTIONS
90100107 | CASING COUPLING |  | STATES OIL
 | 87.5 LB/FT (0.435" WT)
 | BTC CONNECTION
90100108 | RANGE 3 BOX X PIN CASING |  | SIDER
 | 68 LB/FT (0.480" WT)
 | BUTTRESS CONNECTIONS
 | (CHECK 90100378,90100379,90100828 FOR DUPLICATIONS)
90100109 | RANGE 3 PIN X PIN CASING |  | SIDER
 | 68 LB/FT (0.480" WT)
 | BUTTRESS CONNECTIONS
90100110 | CASING COUPLING |  | SIDER
Spreadsheet: darrell_schoolcraft__7316__imball0202
Sheet: burlington

56423
Day | Measured | Scheduled | Imbal
1 | 128480 | 128394
2 | 149328 | 149088
3 | 142965 | 142375
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
 |  |  |  |  |  |  | 20
2002-01-31 00:00:00 |  |  | -13712 |  |  |  | 530
2002-02-03 00:00:00
 |  |  |  |  |  |  | 5989
CBS Volume
 |  |  | -9206
Spreadsheet: 539895d1506423385-highlighting-based-on-value-in-a1-if-no-value-in-a1-do-not-highlight-anything-excelhelp-highlighting-
Sheet: Sheet1

 | 220 | 193 | 273 | 256 | 275 | 302 | 168 | 139 | 231 | 247 | 180 | 90 | 179 | 158 | 219 | 249
236 | 220 | 193 | 273 | 256 | 275 | 302 | 168 | 139 | 231 | 247 | 180 | 90 | 179 | 158 | 219 | 249
 | 220 | 193 | 273 | 256 | 275 | 302 | 168 | 139 | 231 | 247 | 180 | 90 | 179 | 158 | 219 | 249
 | 220 | 193 | 273 | 256 | 275 | 302 | 168 | 139 | 231 | 247 | 180 | 90 | 179 | 158 | 219 | 249
 | 220 | 193 | 273 | 256 | 275 | 302 | 168 | 139 | 231 | 247 | 180 | 90 | 179 | 158 | 219 | 249
 | 220 | 193 | 273 | 256 | 275 | 302 | 168 | 139 | 231 | 247 | 180 | 90 | 179 | 158 | 219 | 249 |  |  |  | 314 | 171 | 260 | 213 | 301 | 101
150 | 220 | 193 | 273 | 256 | 275 | 302 | 168 | 139 | 231 | 247 | 180 | 90 | 179 | 158 | 219 | 249 |  |  |  | 314 | 171 | 260 | 213 | 301 | 101
 | 220 | 193 | 273 | 256 | 275 | 302 | 168 | 139 | 231 | 247 | 180 | 90 | 179 | 158 | 219 | 249 |  |  |  | 314 | 171 | 260 | 213 | 301 | 101
 | 220 | 193 | 273 | 256 | 275 | 302 | 168 | 139 | 231 | 247 | 180 | 90 | 179 | 158 | 219 | 249
 | 220 | 193 | 273 | 256 | 275 | 302 | 168 | 139 | 231 | 247 | 180 | 90 | 179 | 158 | 219 | 249
 | 220 | 193 | 273 | 256 | 275 | 302 | 168 | 139 | 231 | 247 | 180 | 90 | 179 | 158 | 219 | 249
Spreadsheet: 164586d1340814133-annualize-data-going-back-2-1-2-years-complicated-case-volume-by-quarter
Sheet: Surgery Cases

 |  | 1Q 2010 | 2Q 2010 | 3Q 2010 | 4Q 2010 | 1Q 2011 | 2Q 2011 | 3Q 2011 | 4Q 2011 | 1Q 2012 | 2Q 2012 | 3Q 2012 | 4Q 2012 | 2010 | 2011 | 1/1/12-6/15/12 | 2012
 | COLONOSCOPY |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 8 | 6
 | PART SM BOWEL RESECT NEC |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 1 | 3
 | CECECTOMY |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 1
 | RIGHT HEMICOLECTOMY |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 4 | 2
 | SIGMOIDECTOMY |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 4 | 1
 | PART LG BOWEL EXCIS NEC |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 0 | 1
 | LG-TO-LG BOWEL ANASTOM |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 0 | 0
 | LG BOWEL EXTERIORIZATION |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 1 | 2
 | LAP APPENDECTOMY |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 12 | 3
 | OPN ABDPERNEAL RESC REC |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0
 | CHOLECYSTECTOMY |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 1 | 6
 | INCIS HERN REP-GRFT / PROS |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 1 | 2
 | REVISE KNEE REPLACEMENT |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 1
 |  | 1Q 2010 | 2Q 2010 | 3Q 2010 | 4Q 2010 | 1Q 2011 | 2Q 2011 | 3Q 2011 | 4Q 2011 | 1Q 2012 | 2Q 2012 | 3Q 2012 | 4Q 2012 | 2010 | 2011 | 1/1/12-6/15/12 | 2012
 | LAPAROSCOPIC CHOLECYSTEC |  |  |  |  |  |  |  |  |  |  |  |  | 91 | 95 | 33
45.13 | SM BOWEL ENDOSCOPY NEC |  |  |  |  |  |  |  |  |  |  |  |  | 52 | 46 | 29
 | OTHER APPENDECTOMY |  |  |  |  |  |  |  |  |  |  |  |  | 46 | 51 | 12
 | TOTAL KNEE REPLACEMENT |  |  |  |  |  |  |  |  |  |  |  |  | 37 | 38 | 15
 | EGD W/CLOSED BIOPSY |  |  |  |  |  |  |  |  |  |  |  |  | 32 | 15 | 5
 | CLOSED RED-INT FIX FEMUR |  |  |  |  |  |  |  |  |  |  |  |  | 29 | 5 | 16
Spreadsheet: 32b649f9-6bb1-4ea2-94d6-ef3a23c1da4a
Sheet: Sheet1

Table 5--Wheat: National average price received by farmers (dollars per bushel) 1/, 12/13/2011 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Month | All wheat |  | Winter |  | Durum |  | Other spring
 | 2010/11 | 2011/12 | 2010/11 | 2011/12 | 2010/11 | 2011/12 | 2010/11 | 2011/12
June | 4.16 | 7.41 | 4.05 | 7.13 | 4.58 | 9.18 | 4.58 | 9.26
July | 4.49 | 7.1 | 4.47 | 6.77 | 4.44 | 10.2 | 4.71 | 8.41
August | 5.44 | 7.61 | 5.47 | 7.26 | 4.45 | 10.2 | 5.47 | 8.3
September | 5.79 | 7.55 | 5.76 | 7.01 | 4.89 | 10.7 | 5.97 | 8.05
October | 5.88 | 7.29 | 5.83 | 6.54 | 5.07 | 9.58 | 6.14 | 8.2
November | 6.1 | 7.33 | 6.02 | 6.41 | 5.55 | 10.3 | 6.35 | 8.72
December | 6.44 |  | 6.4 |  | 5.71 |  | 6.6
January | 6.69 |  | 6.35 |  | 7.09 |  | 7.14
February | 7.42 |  | 7.03 |  | 8.45 |  | 7.68
March | 7.55 |  | 7.02 |  | 8.09 |  | 8.07
April | 8.01 |  | 7.37 |  | 8.6 |  | 8.67
May | 8.16 |  | 7.8 |  | 7.86 |  | 8.85
1/ Preliminary mid-month, weighted-average price for current month. Source: USDA, National Agricultural Statistics Service, Agricultural Prices.
Date run: 12/9/2011
Spreadsheet: 061c0ea6-9daa-4296-8978-53f6c5253611
Sheet: Survey Results_Lambda Chi

Meal Plan Survey | ? people surveyed | Number of Responses
What Fraternity are you in? | [NAME]
Please score all numerical questions on a scale of 1 (poor) to 10 (excellent) |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Average
The organization and coordinatoin of all meals?
Food Quality
Food Diversity
Food Portions
Food Presentation
Cleanliness of Trays
Catering Staff
Your kitchen manager
Open Ended Questions
Are there any parts of the mealplan that you are impressed with?
Are there any parts of the mealplan  that you would improve on?
Is your kitchen manager actively facilitating this process?
Spreadsheet: 41802d1240339247-small-function-smallfunctionquestion-1-
Sheet: Sheet1

Name | Gain | other data | other data | other data | other data | other data | Lost | other data |  | count | spikecpount
Fred | 2009-01-01 00:00:00 |  |  |  |  |  | 2009-01-29 00:00:00 |  | 2009-01-01 00:00:00 | 1 | 1
Johny | 2009-01-15 00:00:00 |  |  |  |  |  | 2009-02-10 00:00:00 |  | 2009-01-15 00:00:00 | 2 | 2
[NAME] | 2009-02-17 00:00:00 |  |  |  |  |  | 2009-03-22 00:00:00 |  | 2009-01-29 00:00:00 | 2 | #N/A
Betty | 2009-03-02 00:00:00 |  |  |  |  |  | 2009-04-01 00:00:00 |  | 2009-02-10 00:00:00 | 1 | 1
Scobby | 2009-03-18 00:00:00 |  |  |  |  |  | 2009-05-26 00:00:00 |  | 2009-02-17 00:00:00 | 1 | #N/A
 | 2009-03-30 00:00:00 |  |  |  |  |  | 2009-04-01 00:00:00 |  | 2009-03-02 00:00:00 | 2 | 2
 |  |  |  |  |  |  |  |  | 2009-03-18 00:00:00 | 3 | 3
 |  |  |  |  |  |  |  |  | 2009-03-22 00:00:00 | 3 | #N/A
 |  |  |  |  |  |  |  |  | 2009-03-30 00:00:00 | 3 | #N/A
 |  |  |  |  |  |  |  |  | 2009-04-01 00:00:00 | 3 | #N/A
 |  |  |  |  |  |  |  |  | 2009-04-01 00:00:00 | 3 | #N/A
 |  |  |  |  |  |  |  |  | 2009-05-26 00:00:00 | 1 | 1
Spreadsheet: 753727d1635682129-converting-coordinates-coordinates
Sheet: Sheet1

 | I changed the "." separator in the original coordinates (H15) to "," to let it work on my PC at home.
 |  |  |  |  |  |  |  |  |  | Point | Chart format |  | Google format
 |  |  |  |  |  |  |  |  |  |  |  |  | LAT | LONG
 |  |  |  |  |  |  | PBL   N1029,1W06804,7 |  |  |  |  |  |  |  |  | This one is correct... ,07833. Starting with a "0" behind the separator (04,7/60=0,078333)
 |  |  |  |  |  |  | PBL   N1029,1W06814,7 |  |  |  |  |  |  |  |  | This one is NOT correct. 14,7 (last 4 characters of H16) must be converted to ,24500 (14.7/60=0,24500)
Spreadsheet: 117903d1313198963-automated-calculation-of-percentages-of-the-row-trend-analysis
Sheet: Sheet2

Account | Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
100100 | 2008 | 10000 | 12000 | 15000 | 5000 | 3500 | 12000 | 11000 | 13500 | 6250 | 10500 | 12000 | 12500
100100 | 2009 | 12000 | 11500 | 8900 | 6500 | 4200 | 11000 | 10500 | 14250 | 7010 | 12000 | 13050 | 12650
100100 | 2010 | 12150 | 11570 | 12000 | 7000 | 4600 | 11700 | 11580 | 14260 | 8040 | 11590 | 12980 | 12780
100200 | 2008 | 12360 | 11680 | 10650 | 8200 | 5120 | 11580 | 12210 | 14280 | 9200 | 11200 | 13020 | 13000
100200 | 2009 | 12460 | 11700 | 9580 | 8980 | 5560 | 11990 | 12500 | 14500 | 8500 | 11350 | 13200 | 13050
100200 | 2010 | 12800 | 11900 | 9900 | 9020 | 6500 | 12050 | 12780 | 14780 | 8950 | 11450 | 13350 | 13260
Spreadsheet: 826453d1682015588-calculation-based-on-yos-yos-calculation
Sheet: YOS- % Calculation

Hire/Rehire Date | Check Date | Amount | YOS | Calculation Formula |  | Expected Result |  | 1 years of service = 0%
2010-08-23 00:00:00 | 2023-04-20 00:00:00 | 5162.87 |  |  |  |  |  | 2 years of service = 2%
2010-08-23 00:00:00 | 2023-04-20 00:00:00 | 4162.87 |  |  |  |  |  | 3 years of service = 3%
2011-07-05 00:00:00 | 2023-04-20 00:00:00 | 1709.18 |  |  |  |  |  | 4 years of service = 3.5%
2011-12-05 00:00:00 | 2023-04-20 00:00:00 | 796.39 |  |  |  |  |  | 5-9 years of service = 4%
2013-01-28 00:00:00 | 2023-04-20 00:00:00 | 3144.4 |  |  |  |  |  | 10+ years of service = 5%
2013-04-08 00:00:00 | 2023-04-20 00:00:00 | 1674.08
2013-04-22 00:00:00 | 2023-04-20 00:00:00 | 166.34
2013-04-29 00:00:00 | 2023-04-20 00:00:00 | 8898.08
2015-08-24 00:00:00 | 2023-04-20 00:00:00 | 1208.73
2015-12-31 00:00:00 | 2023-04-20 00:00:00 | 7139
2015-12-31 00:00:00 | 2023-04-20 00:00:00 | 6139
2016-03-07 00:00:00 | 2023-04-20 00:00:00 | 6445.92
2016-03-07 00:00:00 | 2023-04-20 00:00:00 | 2129.33
2016-05-16 00:00:00 | 2023-04-20 00:00:00 | 24109.95
2016-05-16 00:00:00 | 2023-04-20 00:00:00 | 25109.95
2016-06-01 00:00:00 | 2023-04-20 00:00:00 | 1528.56
2018-01-22 00:00:00 | 2023-04-20 00:00:00 | 817
2018-04-16 00:00:00 | 2023-04-20 00:00:00 | 936.77
2018-04-16 00:00:00 | 2023-04-20 00:00:00 | 936.77
2018-05-16 00:00:00 | 2023-04-20 00:00:00 | 333.07
2018-07-02 00:00:00 | 2023-04-20 00:00:00 | 4678.88
2018-07-02 00:00:00 | 2023-04-20 00:00:00 | 4578.88
2018-07-23 00:00:00 | 2023-04-20 00:00:00 | 1865.28
2019-02-25 00:00:00 | 2023-04-20 00:00:00 | 600.48
2019-03-25 00:00:00 | 2023-04-20 00:00:00 | 3038.82
2019-04-08 00:00:00 | 2023-04-20 00:00:00 | 2392
2019-05-01 00:00:00 | 2023-04-20 00:00:00 | 2241.49
2019-05-01 00:00:00 | 2023-04-20 00:00:00 | 1998.48
2019-05-16 00:00:00 | 2023-04-20 00:00:00 | 8999
2019-07-15 00:00:00 | 2023-04-20 00:00:00 | 10153.76
2019-12-02 00:00:00 | 2023-04-20 00:00:00 | 1074.21
2020-03-09 00:00:00 | 2023-04-20 00:00:00 | 6007.389999999999
2020-03-16 00:00:00 | 2023-04-20 00:00:00 | 6199.389999999999
2020-03-16 00:00:00 | 2023-04-20 00:00:00 | 1031.15
2020-05-20 00:00:00 | 2023-04-20 00:00:00 | 4935.84
2020-06-24 00:00:00 | 2023-04-20 00:00:00 | 710
2020-10-12 00:00:00 | 2023-04-20 00:00:00 | 2726.54
2021-02-01 00:00:00 | 2023-04-20 00:00:00 | 6435.17
2021-02-15 00:00:00 | 2023-04-20 00:00:00 | 709.57
2021-03-01 00:00:00 | 2023-04-20 00:00:00 | 2442.21
2021-06-16 00:00:00 | 2023-04-20 00:00:00 | 200 |  |  |  | 0
2021-07-01 00:00:00 | 2023-04-20 00:00:00 | 663.88 |  |  |  | 0
2021-11-01 00:00:00 | 2023-04-20 00:00:00 | 773.06 |  |  |  | 0
2021-11-29 00:00:00 | 2023-04-20 00:00:00 | 2137.75 |  |  |  | 0
2022-02-28 00:00:00 | 2023-04-20 00:00:00 | 2628.14 |  |  |  | 0
2022-05-23 00:00:00 | 2023-04-20 00:00:00 | 1753.8 |  |  |  | 0
2022-05-23 00:00:00 | 2023-04-20 00:00:00 | 1753.8 |  |  |  | 0