tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 3e573432-0058-4d1a-a80e-fbccab929da3
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43509486 | 2014-10-09 21:08:29 | AXIS | 1 | 5 | 2 | 1634155 | toconarus | 8709 | mediterranean | 1942-06-12 | 1942-06-12 | Knightsbridge | Knightsbridge
43509669 | 2014-10-09 21:19:20 | ALLIES | 1 | 5 | 1 | 1634155 | toconarus | 8709 | mediterranean | 1942-06-12 | 1942-06-12 | Knightsbridge | Knightsbridge
43584058 | 2014-10-14 23:05:59 | ALLIES | 1 | 5 | 2 | 575415 | EMI44 | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
43584282 | 2014-10-14 23:23:38 | AXIS | 0 | 4 | 5 | 575415 | EMI44 | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
43609499 | 2014-10-16 21:40:36 | ALLIES | 0 | 3 | 5 | 678541 | Sauron93 | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
43609660 | 2014-10-16 21:51:59 | AXIS | 0 | 2 | 5 | 678541 | Sauron93 | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
Spreadsheet: 65710d1266407529-transform-12-50-in-12-50-example
Sheet: Sheet1

user1 | 16,48 € |  |  |  | user4
user2 | 7,03 €
user3 | 21,93 €
user4 | 98,04 €
user5 | 26,05 € |  |  |  | user1
[NAME] | 12,06 €
user7 | 10,62 €
user8 | 21,16 €
[NAME] | 150,28 € |  |  |  | [NAME]
user10 | 23,82 €
 |  |  |  |  | TOTAL:
Spreadsheet: 377537d1424042226-search-for-text-in-a-text-string-solution-to-search-for-text-string-and-blank-cell-lookup-excel-forum-2-15-15
Sheet: Sheet1

Available Brands | Customer Requests | What Brand is Available for a Customer? | Brand1 | Brand2 | Brand3 | Brand4 is another one | Brand5 | Brand678910111213 | Brand7 | Brand8 | B9 | Brand10
Brand1 | B9 Blue
Brand2 | Brand1 Blue
Brand3 | Brand1 [NAME]
Brand4 is another one | Brand1 Grey
Brand5 | Brand1 Red
Brand678910111213 | Brand1 White
Brand7 | Brand10 Black
Brand8 | Brand10 Brown
B9 | Brand11 Black
Brand10 | Brand11 Blue
 | [NAME]
 | Brand14 Green
 | [NAME]
 | Brand16 Black
 | Brand16 Purple
 | Brand17 Red
 | Brand18 Purple
 | Brand19 White
 | Brand2 Black
 | Brand2 Blue
 | Brand2 [NAME]
 | Brand2 Red
 | [NAME]
 | Brand3 Green
 | Brand3 [NAME]
 | Brand3 Purple
 | Brand4 [NAME]
 | Brand4 Green
 | Brand4 is another one Aqua
 | Brand4 is another one [NAME]
 | Brand5 Blue
 | Brand5 Pink
 | Brand6 Green
 | Brand678910111213 White
 | Brand7 Green
 | Brand8 Grey
 | Brand8 Purple
 | Brand9 [NAME]
Spreadsheet: 11ecf49a-3032-4086-b7c1-8cd6f135e10c
Sheet: ILCC Estherville Career Academy

Iowa Lakes Community College
2012-2013 Estherville Career Academy
Course Number | Course Title | Schedule | College Credit Hours | Contact Minutes | SCED Code           Replace 'uu' with sequencing | Comments
Sustainable Energy Resources Management ( 22 credits)
Year 1 - Fall Semester
EVS 114 | Environmental Studies I | M-F 8:00-10:00am | 4 credits | 2844 | 03003C040uu
EVS 114 | Environmental Studies I Lab | M-F 8:00-10:00am | 4 credits | 3904 | 03003C054uu
SER 101 | Intro to Sustainable Energy Resources | M-F 8:00-10:00am | 3 credits | 2848 | 18505C040uu
Year 1 - Spring Semester
EVS 124 | Environmental Studies II | M-F 8:00-10:00am | 4 credits | 2848 | 03003C040uu
EVS 124 | Environmental Studies II Lab | M-F 8:00-10:00am | 4 credits | 3901 | 03003C054uu
SER 111 | Intro to Wind Energy Resources | M-F 8:00-10:00am | 3 credits | 2848 | 18505C040uu
Criminal Justice ( 18 credits)
Year 1 - Fall Semester
CRJ 201 | [NAME] | M-F 8:00-10:00am | 3 credits | 3200 | 04259C044uu
CRJ 100 | Intro to Criminal Justice | M-F 8:00-10:00am | 3 credits | 3200 | 15051C044uu
CRJ 200 | Criminology | M-F 8:00-10:00am | 3 credits | 3200 | 04259C044uu
Year 1 - Spring Semester
CRJ 136 | Correctional Law | M-F 8:00-10:00am | 3 credits | 3200 | 04166C044uu
CRJ 208 | Introduction to Private Security | M-F 8:00-10:00am | 3 credits | 3200 | 15102C044uu
ELECTIVE | Elective | M-F 8:00-10:00am | 3 credits | 3200
Spreadsheet: f76cd970-abf8-4ff3-8ed8-922db157ce2a
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 14998417528 | Messenja | Take The City | 2009-01-27 | Compact Disc | [NAME] | 10.99 | Y | Available
Fervent Records | 80688687328 | Group 1 Crew | Group 1 Crew | 2007-02-20 | Compact Disc | Urban | 11.99 | Y | Available
Taseis | 14998415524 | [NAME] | Soulfood | 2007-03-20 | Compact Disc | Urban | 10.99 | Y | Available
Fervent Records | 80688732523 | Group 1 Crew | Ordinary Dreamers | 2008-09-16 | Compact Disc | Urban | 13.99 | Y | Available
Taseis | 14998416620 | [NAME] | Crisis: Change Is Required | 2008-05-20 | Compact Disc | Urban | 8.99 | Y | Available
Taseis | 821943280027 | Destiny Praise | Driven | 2008-06-03 | Compact Disc | Urban | 10.99 | Y | Available
Taseis | 14998416828 | Damita | No Looking Back | 2008-07-22 | Compact Disc | Urban | 10.99 | Y | Available
Taseis | 14998417320 | [NAME] | It'S Over | 2008-09-23 | Compact Disc | Urban | 8.99 | Y | Available
Taseis | 14998413926 | Voices Of Unity | All Star Edition | 2004-06-08 | Compact Disc | Urban | 10.99 | Y | Available
Spreadsheet: 57039d1257209342-us-federal-floating-holidays-calendar-wizard-1900-2078
Sheet: Calendar

 |  | Jan | Apr | Jul | Oct |  |  |  |  |  |  | Feb | May | Aug | Nov |  |  |  |  | Mar | Jun | Sep | Dec
Jan |  |  |  |  |  |  |  |  | Feb |  |  |  |  |  |  |  |  | Mar
Apr |  |  |  |  |  |  |  |  | May |  |  |  |  |  |  |  |  | Jun
Jul |  |  |  |  |  |  |  |  | Aug |  |  |  |  |  |  |  |  | Sep
Oct |  |  |  |  |  |  |  |  | Nov |  |  |  |  |  |  |  |  | Dec
 | What Year Calender you want ? |  |  |  |  |  |  | 2007 |  |  |  |  | CHANGE THE YEAR HERE
 |  | (1900  -  2078)
 | JANUARY |  |  |  |  |  |  |  |  | FEBRUARY |  |  |  |  |  |  |  |  | [NAME]
 | WK | SUN | MON | TUE | WED | THU | FRI | SAT |  | WK | SUN | MON | TUE | WED | THU | FRI | SAT |  | WK | SUN | MON | TUE | WED | THU | FRI | SAT
 | 1
 | APRIL |  |  |  |  |  |  |  |  | MAY |  |  |  |  |  |  |  |  | [NAME]
 | WK | SUN | MON | TUE | WED | THU | FRI | SAT |  | WK | SUN | MON | TUE | WED | THU | FRI | SAT |  | WK | SUN | MON | TUE | WED | THU | FRI | SAT
 | JULY |  |  |  |  |  |  |  |  | AUGUST |  |  |  |  |  |  |  |  | SEPTEMBER
 | WK | SUN | MON | TUE | WED | THU | FRI | SAT |  | WK | SUN | MON | TUE | WED | THU | FRI | SAT |  | WK | SUN | MON | TUE | WED | THU | FRI | SAT
 | OCTOBER |  |  |  |  |  |  |  |  | NOVEMBER |  |  |  |  |  |  |  |  | DECEMBER
 | WK | SUN | MON | TUE | WED | THU | FRI | SAT |  | WK | SUN | MON | TUE | WED | THU | FRI | SAT |  | WK | SUN | MON | TUE | WED | THU | FRI | SAT
Spreadsheet: 262350d1378115251-choosing-one-of-the-duplicate-customer-info-testworkbook_unsort_optimize_-ijulian-_
Sheet: Sheet1

CALL CENTER | Riv Riverside
DAY OF YEAR | (All)
 | Values
Row Labels | Sum of QUAL TOURS | Sum of NET SALES VOLUME | Sum of VPG1
Figlioli, [NAME] | 7 | 10600 | 1514.285714285714
[NAME], [NAME] | 18 | 23870 | 1326.111111111111
[NAME], [NAME] | 17 | 21599 | 1270.529411764706
[NAME], Stephen | 43 | 46879 | 1090.209302325581
[NAME], [NAME] | 45 | 37495 | 833.2222222222222
Reynolds, [NAME] | 149 | 106154 | 712.4429530201343
Cortez, Violetta | 235 | 160239 | 681.868085106383
Garrett, [NAME] | 238 | 154614 | 649.6386554621848
Shetterly, [NAME] | 92 | 58608 | 637.0434782608696
Haines, [NAME] | 215 | 127453 | 592.8046511627907
Varner, Desiree | 157 | 92845 | 591.3694267515923
Granillo, [NAME] | 276 | 162610 | 589.1666666666666
Tellez, Maria | 17 | 9875 | 580.8823529411765
Ochoa, Regina | 48 | 27731 | 577.7291666666666
[NAME], [NAME] | 58 | 31568 | 544.2758620689655
Beaver, [NAME] | 135 | 71803 | 531.8740740740741
Villalta, [NAME] | 122 | 64624 | 529.7049180327868
Sandoval, Christina | 267 | 141087 | 528.4157303370787
Popkin, Bridget | 207 | 108881 | 525.9951690821256
Carrillo, [NAME] | 232 | 121884 | 525.3620689655172
[NAME], [NAME] | 162 | 84710 | 522.9012345679013
Crowder, Carol | 214 | 96758 | 452.1401869158879
Reeder, [NAME] | 85 | 31231 | 367.4235294117647
Zayas, Lydia | 98 | 31021 | 316.5408163265306
Gustin, [NAME] | 82 | 12574 | 153.3414634146341
Sturgeon, Carol | 81 | 10675 | 131.7901234567901
Partlow, Shane | 8 | 0 | 0
Rodriguez, Rebecca | 6 | 0 | 0
Blue, Lashena | 1 | 0 | 0
[NAME], Debora | 2 | 0 | 0
Bonds, Sasha | 14 | 0 | 0
[NAME], [NAME] | 13 | 0 | 0
[NAME], [NAME] | 7 | 0 | 0
[NAME], [NAME] | 1 | 0 | 0
[NAME], [NAME] | 14 | 0 | 0
Thompson, [NAME] | 1 | 0 | 0
[NAME], [NAME] | 2 | 0 | 0
Degrave, [NAME] | 13 | 0 | 0
Agbara, Darleen | 8 | 0 | 0
[NAME], Amanda | 2 | 0 | 0
Cannone, [NAME] | 20 | 0 | 0
[NAME], [NAME] | 2 | 0 | 0
Harris, Brejette | 12 | 0 | 0
Sanders, Ruby | 19 | 0 | 0
Lasiter, [NAME] | 7 | 0 | 0
Cox, [NAME] | 7 | 0 | 0
Aguirre, Christina | 1 | 0 | 0
[NAME] | 7 | 0 | 0
[NAME], Leonard | 5 | 0 | 0
Unknown | 1 | 0 | 0
Agbara, Desiree | 4 | 0 | 0
Vasquez, [NAME] | 4 | 0 | 0
Omoruyi, [NAME] | 2 | 0 | 0
Wearp, [NAME] | 4 | 0 | 0
[NAME], Sheena | 1 | 0 | 0
Rank, [NAME] | 37 | 0 | 0
Rodriguez, Ana | 0 | 0 | #[NAME]!
[NAME], Hope | 0 | 7000 | #[NAME]!
Sylvester, [NAME] | 0 | 0 | #[NAME]!
Ervin, [NAME] | 0 | 0 | #[NAME]!
Rodgers, Jared | 0 | 0 | #[NAME]!
Esquivel, [NAME] | 0 | 0 | #[NAME]!
[NAME], [NAME] | 0 | 0 | #[NAME]!
Aguilar, [NAME] | 0 | 0 | #[NAME]!
Cox, [NAME] | 0 | -7605 | #[NAME]!
Grand Total | 3525 | 1846783 | 523.9100709219858
Spreadsheet: 105057d1302537866-how-to-pull-a-value-x-amount-of-rows-above-the-lookup-value-book1
Sheet: Sheet1

Code | Amt expected to be used
A104
A105
N207
N208
N209
N210
N201
N202
N203
N204
N205
N206
N213
N214
N211
N212
B301
B302
B303
B304
A106
F401
F402
F403
F404
A107
A108
A109
A110
A111
N215
N216
N217
N218
N219
N220
N221
N222
N223
B305
B306
F405
F406
N224
N225
N226
N227
N228
N229
N230
B307
B308
F407
F408
A102
A103
[NAME]
Spreadsheet: 0a3354a0-0890-44bd-a508-d6e7c890ae93
Sheet: One Week Block Calculator

.
 |  |  |  |  |  |  | Return to Index
Enrolled Minutes Calculator
One Week Block
Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday
 | Begin | End | Mins |  | Begin | End | Mins |  | Begin | End | Mins |  | Begin | End | Mins |  | Begin | End | Mins
Passing |  |  |  | Passing |  |  |  | Passing |  |  |  | Passing |  |  |  | Passing
Passing |  |  |  | Passing |  |  |  | Passing |  |  |  | Passing |  |  |  | Passing
Passing |  |  |  | Passing |  |  |  | Passing |  |  |  | Passing |  |  |  | Passing
Passing |  |  |  | Passing |  |  |  | Passing |  |  |  | Passing |  |  |  | Passing
Passing |  |  |  | Passing |  |  |  | Passing |  |  |  | Passing |  |  |  | Passing
Passing |  |  |  | Passing |  |  |  | Passing |  |  |  | Passing |  |  |  | Passing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0:00:00
Passing |  |  |  | Passing |  |  |  | Passing |  |  |  | Passing |  |  |  | Passing |  |  | 0:00:00
Passing |  |  |  | Passing |  |  |  | Passing |  |  |  | Passing |  |  |  | Passing
 |  | Total Minutes |  |  |  | Total Minutes |  |  |  | Total Minutes |  |  |  | Total Minutes |  |  |  | Total Minutes
 |  | In School Minutes per Day
 |  | College AVTS Minutes per Day
 |  | Total Minutes per Day |  |  |  |  |  | This number is entered into the Minutes per day field for KIDS
 |  |  | 1.   [NAME] and any passing time from lunch are not counted.
 |  |  | 2.   Passing time from a class period to a period not enrolled is not counted.
 |  |  | 3.   Passing time from a period where there is not an enrolled class is not counted
 |  |  | 4.   A period which is a combination of class time and lunch, only the class time would be counted.
 |  |  | 5.   There is no passing time to the first class of the day or from the last class of the day.
Return to Top
Spreadsheet: 598730d1542678683-lookup-multiple-values-in-the-same-column-i-think-this-is-what-im-looking-for-amazon-bookeeping-example
Sheet: Sheet1

Order ID | SKU | Transaction type | Payment Type | Payment [NAME] | Amount | Quantity | Product Title
222-3312-1819 | AS-TTYY-HSWR | Order Payment | Amazon fees | Commission | -2.44 |  | Primer [DVD]
222-3312-1820 | AS-TTYY-HSWR | Order Payment | Amazon fees | FBA fulfilment fee per unit | -1.94 |  | Primer [DVD]
222-3312-1821 | AS-TTYY-HSWR | Order Payment | Amazon fees | Shipping chargeback | -2.99 |  | Primer [DVD]
222-3312-1822 | AS-TTYY-HSWR | Order Payment | Amazon fees | Variable closing fee | -0.6 |  | Primer [DVD]
222-3312-1823 | AS-TTYY-HSWR | Order Payment | Product charges |  | 13.5 | 1 | Primer [DVD]
222-3312-1824 | AS-TTYY-HSWR | Order Payment | Other | Shipping | 2.99 |  | Primer [DVD]
212-8899-4545 | PW-YTRE-HHYY | Order Payment | Amazon fees | Commission | -7.2 |  | Game of Thrones
212-8899-4546 | PW-YTRE-HHYY | Order Payment | Amazon fees | FBA fulfilment fee per unit | -2.77 |  | Game of Thrones
212-8899-4547 | PW-YTRE-HHYY | Order Payment | Amazon fees | [NAME] wrap chargeback | -2.99 |  | Game of Thrones
212-8899-4548 | PW-YTRE-HHYY | Order Payment | Product charges |  | 39.98 | 1 | Game of Thrones
212-8899-4549 | PW-YTRE-HHYY | Order Payment | Other | [NAME] wrap | 2.99 |  | Game of Thrones
So as you can see with Amazon they have multiple transactions for 1 item, instead of just telling you how much you have made after fees. So this is what I am trying to figure out. Generally there are hundreds of transactions over the month and I cannot figure out how to subtract all the fees in red from the final amount of money coming in, in column F. Ideally I'd like something similar to something in Sheet 2 which will tell me exactly how much I have made for each item.
Spreadsheet: 174815d1345200901-golf-scoring-pulling-values-to-new-cells-and-sorting-based-on-value-etc-golf-pairing-example
Sheet: Event Winners

Winning Score Cards
 |  | Hole | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | OUT | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | IN | TOT
 |  | Par | 4 | 4 | 4 | 5 | 3 | 4 | 5 | 3 | 4 | 36 | 5 | 3 | 4 | 5 | 3 | 4 | 4 | 3 | 5 | 36 | 72 |  |  | Hole Index
Position | Team # | Name | 13 | 15 | 7 | 1 | 9 | 3 | 5 | 17 | 11 |  | 4 | 14 | 8 | 2 | 16 | 6 | 12 | 18 | 10 |  |  |  | Tie Breaker | 1 | 2 | 3 | 4 | 5
1 | 5 | [NAME] | 4 | 4 | 4 | 3 | 3 | 4 | 4 | 2 | 3 | 31 | 3 | 4 | 4 | 3 | 3 | 4 | 4 | 2 | 3 | 30 | 61 |  | 61.33434 | 3 | 3 | 4 | 3 | 4
2 | 3 | Cliff  + [NAME] | 3 | 4 | 4 | 3 | 3 | 4 | 4 | 3 | 3 | 31 | 3 | 4 | 4 | 3 | 4 | 4 | 4 | 3 | 3 | 32 | 63 |  | 63.33434 | 3 | 3 | 4 | 3 | 4
3 | 1 | [NAME] | 3 | 5 | 4 | 3 | 3 | 4 | 4 | 3 | 4 | 33 | 3 | 4 | 4 | 3 | 3 | 2 | 4 | 5 | 3 | 31 | 64 |  | 64.33434 | 3 | 3 | 4 | 3 | 4
4 | 2 | [NAME] | 4 | 5 | 4 | 3 | 3 | 4 | 3 | 3 | 3 | 32 | 3 | 4 | 4 | 4 | 4 | 3 | 3 | 3 | 4 | 32 | 64 |  | 64.34433 | 3 | 4 | 4 | 3 | 3
5 | 4 | [NAME] | 4 | 4 | 4 | 3 | 4 | 4 | 4 | 2 | 3 | 32 | 4 | 4 | 4 | 3 | 4 | 4 | 4 | 3 | 3 | 33 | 65 |  | 65.33444 | 3 | 3 | 4 | 4 | 4
6 | 6 | [NAME]  + Jarrod | 4 | 6 | 4 | 3 | 1 | 4 | 4 | 3 | 3 | 32 | 3 | 5 | 6 | 3 | 4 | 4 | 4 | 5 | 5 | 39 | 71 |  | 71.33434 | 3 | 3 | 4 | 3 | 4
7 | 7 | [NAME] | 5 | 5 | 5 | 3 | 4 | 4 | 4 | 3 | 4 | 37 | 4 | 6 | 5 | 3 | 4 | 5 | 4 | 3 | 4 | 38 | 75 |  | 75.33444 | 3 | 3 | 4 | 4 | 4
Spreadsheet: 860741d1708723240-trying-to-combine-info-in-two-different-files-that-each-have-different-info-i-need-sample-file-2-
Sheet: Contact Information

Student_Number | Last_Name | First_Name | Middle_Name | Grade | Gender | Student_Email | F2G1_name | F2G1_relationship | F2G1_phone | F2G1_email | F2G1_address
123456 | Smith | Sue | S | 9 | F | [EMAIL] | [NAME] | Father | (473) 358-2847 | [EMAIL] | 12345 N Rebel Dr, City, State 54321
135790 | [NAME] | [NAME] | B | 10 | M | [EMAIL] | [NAME] | Mother | (475) 479-3865 | [EMAIL] | 2345 SW Destiny Cir, City, State 54321
246801 | Jones | [NAME] | J | 11 | M | [EMAIL] | Julia Jones | Mother | (348) 475-3284 | [EMAIL] | 3456 Lake Ave, City, State 54321
121314 | [NAME] | [NAME] | J | 10 | F | [EMAIL] | [NAME] | Father | (248) 578-7568 | [EMAIL] | 765 Power St, City, State, 54321
151718 | White | Wally | W | 12 | M | [EMAIL] | [NAME] | Mother | (887) 687-3547 | [EMAIL] | 55 N Middle Ter, City, State 54321
579544 | Wayne | [NAME] | G | 12 | M | [EMAIL] | [NAME] | Mother | (234)474-2877 | [EMAIL] | 74 [NAME], City, State 54321
123575 | Kent | [NAME] | U | 12 | M | [EMAIL] | [NAME] | Mother | (769) 484-4359 | [EMAIL] | 9756 [NAME], City, State 54321
975684 | [NAME] | [NAME] | E | 10 | M | [EMAIL] | [NAME] | Mother | (375) 574-2184 | [EMAIL] | 2357 New York St, City, State 54321
136547 | Rogers | [NAME] | W | 9 | M | [EMAIL] | [NAME] | Mother | (583) 584-1739 | [EMAIL] | 213 Brooklyn Ave, City, State 54321
156975 | Munroe | Ororo | M | 9 | F | [EMAIL] | [NAME] | Mother | (648) 894-6885 | [EMAIL] | 8756 [NAME], City, State, 54321
Spreadsheet: 131009d1322687341-help-with-an-excel-formula-test
Sheet: Sheet2

Staff ID | W/E | Surname | Invoice number | Date sent to AP
1 | 2011-11-20 00:00:00 |  | 16 | 2011-12-12 00:00:00
1 | 2011-11-06 00:00:00 |  | 12 | 2011-12-13 00:00:00
3 | 2011-11-27 00:00:00 |  | 86 | 2011-12-14 00:00:00
1 | 2011-11-13 00:00:00 |  | 64 | 2011-12-15 00:00:00
1 | 2011-11-13 00:00:00 |  | 26 | 2011-12-12 00:00:00
2 | 2011-11-20 00:00:00 |  | 14 | 2011-12-13 00:00:00
3 | 2011-11-06 00:00:00 |  | 42432 | 2011-12-14 00:00:00
4 | 2011-11-06 00:00:00 |  | 97 | 2011-12-14 00:00:00
5 | 2011-11-27 00:00:00 |  | 32 | 2011-12-12 00:00:00
Spreadsheet: 287064d1388611391-how-do-i-hide-and-unhide-cell-contents-teams
Sheet: Sheet1

 |  | Enter no of teams | 5
 |  |  |  |  |  | When team no is entered, excel must show or hide the the team
 |  |  |  |  |  | e.g when you enter 5 as the required team number then only 5 teams appear and the rest of the teams are hidden
Spreadsheet: 357059d1415291405-vlookup-to-show-multile-values-in-one-cell-november_dashboard
Sheet: 11-4-14

paste BAY here start in a3
bay |  | 545 | 150.6 |  |  | 1 | [NAME] (0513) | 353 | 169.6
1 | [NAME] (0360) | 545 | 150.6 |  |  | bulk |  | 524 | 206.3
bay |  | 501 | 124.7 |  |  | 1 | [NAME] (0684) | 524 | 206.3
1 | [NAME] (0513) | 501 | 124.7 |  |  | bulk |  | 238 | 115.6
bay |  | 607 | 136.3 |  |  | 1 | [NAME] (1618) | 238 | 115.6
1 | [NAME] (0684) | 607 | 136.3 |  |  | bulk |  | 374 | 155.7
bay |  | 346 | 90.0 |  |  | 1 | [NAME] (2746) | 374 | 155.7
1 | [NAME] (1618) | 346 | 90.0 |  |  | bulk |  | 448 | 231.3
bay |  | 530 | 149.5 |  |  | 1 | [NAME] (3286) | 448 | 231.3
1 | [NAME] (2746) | 530 | 149.5 |  |  | bulk |  | 351 | 142.7
bay |  | 526 | 127.7 |  |  | 1 | [NAME] (4518) | 351 | 142.7
1 | [NAME] (3286) | 526 | 127.7 |  |  | bulk |  | 351 | 168.1
bay |  | 572 | 137.9 |  |  | 1 | [NAME] (5948) | 351 | 168.1
1 | [NAME] (4518) | 572 | 137.9 |  |  | bulk |  | 533 | 211.5
bay |  | 443 | 102.6 |  |  | 1 | [NAME] (7643) | 533 | 211.5
1 | [NAME] (5948) | 443 | 102.6 |  |  | bulk |  | 423 | 167.9
bay |  | 622 | 140.0 |  |  | 1 | [NAME] (7661) | 423 | 167.9
1 | [NAME] (7643) | 622 | 140.0 |  |  | bulk |  | 372 | 213.0
bay |  | 560 | 136.2 |  |  | 1 | [NAME] (7947) | 372 | 213.0
1 | [NAME] (7661) | 560 | 136.2 |  |  | bulk |  | 458 | 180.9
bay |  | 548 | 133.7 |  |  | 1 | [NAME] (9223) | 458 | 180.9
1 | [NAME] (7947) | 548 | 133.7 |  |  | bulk |  | 257 | 123.1
bay |  | 447 | 138.7 |  |  | 1 | Donnie Justice (9330) | 257 | 123.1
1 | [NAME] (9177) | 447 | 138.7 |  |  | bulk |  | 317 | 136.9
bay |  | 314 | 76.3 |  |  | 1 | [NAME] (9336) | 317 | 136.9
1 | [NAME] (9223) | 314 | 76.3 |  |  | bulk |  | 316 | 138.8
bay |  | 451 | 108.4 |  |  | 1 | Brent Pickard (9657) | 316 | 138.8
1 | Donnie Justice (9330) | 451 | 108.4
bay |  | 395 | 106.6
1 | [NAME] (9336) | 395 | 106.6
bay |  | 555 | 144.5
1 | Brent Pickard (9657) | 555 | 144.5
Spreadsheet: 1bf66c83-a824-419b-89cb-87353f863076
Sheet: Sheet1

Course Type:                                                  PALS-Provider | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Course Date:                   Course Time:
 | CPR | First Name | MI | Last Name | MD/RN | Dept Name & Number | H/S/O | Emailed | Bk | Auth | Pd
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Spreadsheet: 05f80a87-1d8f-4476-bc2c-2abf5e8ef7f6
Sheet: PETRA

 |  |  | 2014  PETRA - Delivery Calendar
 | January |  |  |  |  |  |  |  | February |  |  |  |  |  |  |  | March
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15
 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22
 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 23 | 24 | 25 | 26 | 27 | 28 |  |  | 23 | 24 | 25 | 26 | 27 | 28 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 31
 | April |  |  |  |  |  |  |  | May |  |  |  |  |  |  |  | June
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  | 1 | 2 | 3 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | 8 | 9 | 10 | 11 | 12 | 13 | 14
 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  | 11 | 12 | 13 | 14 | 15 | 16 | 17 |  | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | 22 | 23 | 24 | 25 | 26 | 27 | 28
 | 27 | 28 | 29 | 30 |  |  |  |  | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | 29 | 30
 | July |  |  |  |  |  |  |  | August |  |  |  |  |  |  |  | September
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  |  | 1 | 2 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  | 10 | 11 | 12 | 13 | 14 | 15 | 16 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  | 17 | 18 | 19 | 20 | 21 | 22 | 23 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 27 | 28 | 29 | 30 | 31 |  |  |  | 24 | 25 | 26 | 27 | 28 | 29 | 30 |  | 28 | 29 | 30
 |  |  |  |  |  |  |  |  | 31
 | October |  |  |  |  |  |  |  | November |  |  |  |  |  |  |  | December
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  | 1 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 23 | 24 | 25 | 26 | 27 | 28 | 29 |  | 28 | 29 | 30 | 31
 |  |  |  |  |  |  |  |  | 30
 |  | Pre-determined Tuesdays monthly.  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  | Holidays, Food Bank is Closed |  |  |  |  |  |  |  | Delivery dates to your area
Spreadsheet: 100243d1298647775-referencing-from-multiple-sheets-back-to-sheet1-copy-of-marely-tunnel-21-11-10-profile-datasheet
Sheet: 000-22762KBM

VER=3.00
REL=4.04
SYD=000
KEY=000
CUS=000
[NAME]
MODE=Lasersweep
INPT=[NAME]
ELR=MLN1
NAME=Marley Tunnel
DATE=21/11/10
DIST= | Here I want to be able to add the decimal mile for this section from column P (227.7813), ideally it would read DIST=227.7813
FLN= | Here I want it to be the same as the sheet name with the number prefix
REP=0
NTK=1
ID1=B
[NAME]
LSP1= 96.5
OSP1=96.5
ID2=
RAD2=
LSP2=
OSP2=
NCOL=3
COL1=x(m)
COL2=y(m)
[NAME]=Att
NPT=
EDIT=23/02/2011
OPER=[NAME]
Three coulmns of data will be inserted here from a separate workbook with sheet names that match the first three numbers of the sheet names in this workbook
I then will export each sheet as a text file using the sheet name below as the file name.