tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 030de5c9-08d1-4687-adb5-d9cdb35d7d5f
Sheet: M

Course color corresponds with term of offering.  ORANGE  for Fall semester, PURPLE for J-term, GREEN for both Fall and J-term.
 | AOK Designation | CAR Designation | Comment
Mathematics
MATH 105 | Natural & Mathematical Sciences-Mathematics
MATH 107 | Natural & Mathematical Sciences-Mathematics | Computing
MATH 111 | Natural & Mathematical Sciences-Math Sci other
MATH 113 | Natural & Mathematical Sciences-Math Sci other | Computing
MATH 120 | Natural & Mathematical Sciences-Mathematics
MATH 123 | Natural & Mathematical Sciences-Mathematics
MATH 131 | Natural & Mathematical Sciences-Mathematics
MATH 132 | Natural & Mathematical Sciences-Mathematics
MATH 141 | Natural & Mathematical Sciences-Mathematics | Computing
MATH 142 | Natural & Mathematical Sciences-Mathematics | Computing
MATH 203 | Natural & Mathematical Sciences-Mathematics | Computing
MATH 220 | Natural & Mathematical Sciences-Mathematics
MATH 270 |  | Experiential-Travel; Non-Western
MATH 415 |  | Capstone
MATH 470 |  | Experiential-Travel
MATH 487 |  | Experiential-Research
MATH 488 |  | Experiential-Research
Music
MUSC 101 | Arts & Literature-Arts
MUSC 110 | Arts & Literature-Arts
MUSC 111 | Arts & Literature-Arts
MUSC 200 | Arts & Literature-Arts
MUSC 210 | Arts & Literature-Arts
MUSC  211 | Arts & Literature-Arts
MUSC 212 | Arts & Literature-Arts
MUSC 215 | Arts & Literature-Arts
MUSC 221 | Arts & Literature-Arts
MUSC 222 | Arts & Literature-Arts
MUSC 230 | Arts & Literature-Arts
MUSC 231 | Arts & Literature-Arts
MUSC 232 | Arts & Literature-Arts
MUSC 240 | Arts & Literature-Arts | Non-Western
MUSC 243 | Arts & Literature-Arts | Experiential-Travel; Non-Western
MUSC 260 | Arts & Literature-Arts
MUSC 270 |  | Computing
MUSC 278 | Arts & Literature-Arts | Experiential-Travel; Experiential-Research
MUSC 301-309 | Arts & Literature-Arts (3 1-hour courses with same course number)
MUSC 310 | Arts & Literature-Arts (3 times at 1 hour)
MUSC 321 | Arts & Literature-Arts
MUSC 322 |  | Computing
MUSC 371 |  | Computing
MUSC 381 | Arts & Literature-Arts | Non-Western | J-Term 2013(Music of Brazil)
MUSC 381 | Arts & Literature-Arts | Experiential-Travel | J-Term 2014(Choral Music of Greece, Turkey & Italy); J-Term 2010 (Music of the Reformation)
MUSC 420 | Arts & Literature-Arts | Experiential-Research
MUSC 422 | Arts & Literature-Arts | Experiential-Research; Capstone
MUSC 450 |  | Experiential-Internship
Spreadsheet: 586589d1534450789-copy-data-from-one-excel-sheet-to-another-if-a-value-is-present-only-from-drop-down-list-sample-of-billing-matrix
Sheet: ADT

DATE | COMPANY | TOTAL COUNT | 1 COUNT | 1 AMOUNT | 2 COUNT | 2 AMOUNT | 3 COUNT | 3 AMOUNT | 4 COUNT | 4 AMOUNT | 5 COUNT | 5 AMOUNT | 6 COUNT | 6 AMOUNT | TOTAL AMOUNT
2018-08-01 00:00:00 | 2 - ADT | 5 | 0 | 0 | 0 | 0 | 5 | 400 | 0 | 0 | 0 | 0 | 0 | 0 | 400
2018-08-02 00:00:00 | 2 - ADT | 5 | 0 | 0 | 0 | 0 | 5 | 400 | 0 | 0 | 0 | 0 | 0 | 0 | 400
2018-08-03 00:00:00 | 2 - ADT | 10 | 0 | 0 | 0 | 0 | 10 | 800 | 0 | 0 | 0 | 0 | 0 | 0 | 800
Spreadsheet: 141070d1329069376-indirect-ext-2007-summary
Sheet: 2007

weekend | tanning | tickets | product | tickets
Week ending 02-03-2007.xls
Week Ending 02-10-2007.xls
Week Ending 02-17-2007.xls
Week Ending 02-24-2007.xls
Week Ending 03-03-2007.xls
Week Ending 03-10-2007.xls
Week Ending 03-17-2007.xls
Week Ending 03-24-2007.xls
Week Ending 03-31-2007.xls
Week Ending 04-07-2007.xls
Week Ending 04-14-2007.xls
Week Ending 04-21-2007.xls
Week Ending 04-28-2007.xls
Week Ending 05-05-2007.xls
Week Ending 05-12-2007.xls
Week Ending 05-19-2007.xls
Week Ending 05-26-2007.xls
Week Ending 06-02-2007.xls
Week Ending 06-09-2007.xls
Week Ending 06-16-2007.xls
Week Ending 06-23-2007.xls
Week Ending 06-30-2007.xls
Week Ending 07-07-2007.xls
Week Ending 07-14-2007.xls
Week Ending 07-21-2007.xls
Week Ending 07-28-2007.xls
Week Ending 08-04-2007.xls
Week Ending 08-11-2007.xls
Week Ending 08-18-2007.xls
Week Ending 08-25-2007.xls
Week Ending 09-01-2007.xls
Week Ending 09-08-2007.xls
Week Ending 09-15-2007.xls
Week Ending 09-22-2007.xls
Week Ending 09-29-2007.xls
Week Ending 10-06-2007.xls
Week Ending 10-13-2007.xls
Week Ending 10-20-2007.xls
Week Ending 10-27-2007.xls
Week Ending 11-03-2007.xls
Week Ending 11-10-2007.xls
Week Ending 11-17-2007.xls
Week Ending 11-24-2007.xls
Week Ending 12-01-2007.xls
Week Ending 12-08-2007.xls
Week Ending 12-15-2007.xls
Week Ending 12-22-2007.xls
Week Ending 12-29-2007.xls
Spreadsheet: 822959d1679615090-xirr-formula-that-recognizes-change-of-group-xirr-formula-that-recognizes-change-of-group
Sheet: Sheet1

A | 2020-01-01 00:00:00 | -300
A | 2021-02-03 00:00:00 | -400 |  |  |  |  | B
A | 2022-12-31 00:00:00 | 500 |  |  |  |  | C
B | 2020-01-01 00:00:00 | -300 |  |  |  |  | D
B | 2021-02-03 00:00:00 | -400 |  |  |  |  | E
B | 2021-03-05 00:00:00 | -500 |  |  |  |  | F
B | 2021-06-20 00:00:00 | -700
B | 2022-01-15 00:00:00 | -50
B | 2022-06-15 00:00:00 | -150
B | 2022-12-31 00:00:00 | 2000
C | 2020-01-01 00:00:00 | -300
C | 2022-12-31 00:00:00 | 700
D | 2020-01-01 00:00:00 | -300
D | 2021-03-05 00:00:00 | -60
D | 2022-12-31 00:00:00 | 1500
E | 2020-01-01 00:00:00 | -300
E | 2021-02-03 00:00:00 | -800
E | 2021-03-05 00:00:00 | -900
E | 2021-06-20 00:00:00 | -150
E | 2022-01-15 00:00:00 | -200
E | 2022-06-15 00:00:00 | -70
E | 2022-08-03 00:00:00 | -200
E | 2022-12-31 00:00:00 | 800
F | 2020-01-01 00:00:00 | -300
F | 2022-12-31 00:00:00 | 500
Spreadsheet: 120744d1315494824-projected-component-change-outs-budget
Sheet: Utilization

 |  |  |  |  | Year
 |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
 |  |  |  |  | 744 | 696 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 744 | 672 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 2160 | 2184 | 2208 | 2208 | 2160 | 2184 | 2208 | 2208 | 2184 | 2184 | 2208 | 2208
 |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th
Link Belt | 460LX | K7J5-9653 | George
Hitachi | EX750-5 | 17CP005162 | Plant
Caterpillar | D8R | 7XM3440 | Plant
Komatsu | D155AX-6 | 80859 | Ash Disposal
Komatsu | D155AX-6 | 80860 | Plant
Caterpillar | D10R | 3KR01039 | Plant
Caterpillar | D10N | 2YD01412 | Plant
Caterpillar | D9L | 14Y75547 | Plant
Caterpillar | D6R | 8LN00554 | George
Caterpillar | 262B | PDT02507 | 4W
Caterpillar | 980H | [NAME] | 4W
Caterpillar | 980H | [NAME] | Prime
Komatsu | WA500-3LK | A71021 | Ash Disposal
Komatsu | WA500-3L | A70601 | #8
Komatsu | [NAME] | A70122 | Arco
Michigan | L160 |  | Plant
Caterpillar | 980C | 63X08405 | Ash Disposal
Caterpillar | 988H | BXY01283 | Dock
Caterpillar | 980G | 2KR01935 | Plant
Caterpillar | 980G | 2KR01625 | Prime
Caterpillar | 980G | 2KR03780 | 4W
Caterpillar | 966C | 76J15339 | PA Shop
Caterpillar | 252B | SCP01666 | Ash Disposal
Caterpillar | 252B | [NAME] | [NAME]
Caterpillar | 272C | RED00311 | Plant
Caterpillar | 988F | 8YG0679 | Plant
Caterpillar | 988F | 8YG75020 | Plant
Caterpillar | 988H | BXY04193 | Plant
Caterpillar | 988H | BXY04196 | Dock
Terex | TA40 | A8421035 | Plant
Terex | TA40 | A8421031 | Plant
[NAME] | 400D | 210795 | Plant
[NAME] | 400D | 613796 | Plant
Champion | 710 | 710A15746318690 | Plant
[NAME] | SP116DX | 192981 | Plant
Spreadsheet: 85313d1285335215-look-up-funtion-or-if-or-example
Sheet: Sheet1

Size of area | Grade
151 | B |  | upto | 100 | A
752 | F |  | 101 | 200 | B
 |  |  | 201 | 300 | C
 |  |  | 301 | 500 | D
 |  |  | 501 | 750 | E
 |  |  | 751 | 1000 | F
 |  |  | 1001 | 1250 | G
 |  |  | 1251 | 1500 | H
 |  |  | 1501 | 1750 | I
 |  |  | 1751 | 2000 | J
 |  |  | 2001 | 2500 | K
 |  |  | 2501 | 3000 | L
 |  |  | 3001 | 3500 | M
 |  |  | 3501 | 4000 | N
 |  |  | 4001 | 4500 | O
 |  |  | 4501 | 5000 | P
 |  |  | 5001 | 6000 | Q
 |  |  | 6001 | 7000 | R
 |  |  | 7001 | 8000 | S
 |  |  | 8001 | 9000 | T
 |  |  | 9001 | 10000 | U
Spreadsheet: 734395d1622137692-finding-closest-index-match-from-lat-lon-without-repeats-closest-no-duplicate
Sheet: TEST DATA

 |  |  |  |  |  | LIST OF VIABLE OPTIONS:
old SITE NO GOOD | lat | lon | DELTA (FT) | NEW CLOSEST - UNIQUE - NO REPEAT.. |  | NEW LOCATION | OPTION LAT | OPTION LON |  |  |  |  | Distance FT
1 | 28.07323653 | -82.434513245009 |  |  |  | A | 28.014566 | -82.42321322399
2 | 28.079231 | -82.4234182 |  |  |  | B | 28.0343247 | -82.4124214212344 |  |  |  |  | Trying to incorporate this, but in a RANGE, rather than point to point… When I add in instead of the SQRT I get an NA…
3 | 28.02342359172 | -82.3914 |  |  |  | C | 28.1231206 | -82.11500885 |  |  |  |  | (3.2808*6378.13*1000*ACOS(COS(RADIANS(90-B3))*COS(RADIANS(90-H3))+SIN(RADIANS(90-B3))*SIN(RADIANS(90-H3))*COS(RADIANS(C3-I3))))
4 | 28.03327463435 | -82.345401795 |  |  |  | D | 28.0711323653 | -82.334531343881 |  |  |  |  | ;;=INDEX($G$3:$G$16,MATCH(MIN((3.2808*6378.13*1000*ACOS(COS(RADIANS(90-B3))*COS(RADIANS(90-H3))+SIN(RADIANS(90-B3))*SIN(RADIANS(90-H3))*COS(RADIANS(C3-I3)))),0),1)
5 | 28.027427075 | -82.526185 |  |  |  | E | 28.0300444006 | -82.44387445 |  |  |  |  | Above is giving an NA - I am sure I have something off, but still would have duplicates either way.
6 | 28.302527 | -82.324553761 |  |  |  | F | 28.0110061 | -82.0798434414
7 | 28.04273349 | -82.48274372 |  |  |  | C | 28.220621 | -82.9808429
8 | 28.027427075 | -82.500835 |  |  |  | D | 28.07323653 | -82.5060885
9 | 28.024726385 | -82.500885 |  |  |  | E | 28.018 | -82.369661
 |  |  |  |  |  | F | 28.0139 | -82.393265
 |  |  |  |  |  | g | 28.027463435 | -82.500729
 |  |  |  |  |  | h | 27.967849 | -82.48274372
 |  |  |  |  |  | i | 28.029205 | -82.526185
 |  |  |  |  |  | j | 28.011245 | -82.324553761
 |  |  |  |  |  | k | 28.02342359172 | -82.500729
Spreadsheet: 222822d1363957380-data-label-assistance-909256
Sheet: TOTAL

MONTH | 2013 "Actual" Total - RFA | 2013 "Actual" Total - EHP | 2013 "Actual" Total - EHSQ | 2013 "Actual" Total - WHP | 2013 "Actual" Total - Misc. | IP Total Collated Days Available | Percentage Usage
December
November
October
September
August
July
June
May
April
March
February
January
MONTH | 2013 "Forecast" Total - RFA | 2013 "Forecast" Total - EHP | 2013 "Forecast" Total - EHSQ | 2013 "Forecast" Total - WHP | 2013 "Forecast" Total - Misc. | IP Total Collated Days Available | Percentage Usage
December
November
October
September
August
July
June
May
April
March
February
January
MONTH | 2013 Combined Total - RFA | 2013 Combined Total - EHP | 2014 Combined Total - EHSQ | 2013 Combined Total - WHP | 2013 Combined Total - Misc. | IP Total Combined Days Available | Percentage Usage
December
November
October
September
August
July
June
May
April
March
February
January
Spreadsheet: 733330d1621515250-combine-extract-text-and-trim-clean-function-possible-pclog_eh
Sheet: Sheet1

Ionternal | Real Barcode | Product
50015595870025 | [PHONE]
 | 609613809941
 | 5030765037077
 | Various
50010016802652 | 5000168026527
50010016802654 |  | 5 CT 136 GR - 50010016802654
 |  | correctiom
50020035491634 | [PHONE] | Unicorn cake mix
50020035491000 | [PHONE] | American pancake mix
50020035490999 | [PHONE] | Classic pancake mix
50020035491016 | [PHONE] | Crumble mix
50 01 00354 91914 | [PHONE] | Batchelors Cup a Soup Thai Chicken & Lemongrass Correction
50011025192099 | [PHONE] | MORRISONS FREE FROM VANILLA SPONGE CAKE MIX SHELF STABLE 350 GR - 50011025192099
Spreadsheet: 214688d1361051032-re-how-to-auto-send-email-from-multiple-sheets-it-works-on-one-not-on-multiple-production-chart-sample2
Sheet: Master sheet

Hello
 |  |  | Job Specification & Description |  |  |  | Start | End | Review 1 | Review 2 | Review Due |  | Message | Current Status
Pty | Customer | W.O.No. | Job Type | Unit Desc | Serial No. | Part No. | Date | Date | in Days | in Days | Yes/No |  | Sent
2 | [NAME] | 10350 | New Cylinders | Ford Escort | 123456 | 39844 | 2013-03-03 00:00:00 | 1904-01-22 00:00:00 | 11 | 39876 | N | 0 | 0 | Nowhere near complete
 |  | Totals & |  |  |  |  |  |  |  |  |  | Current |  |  |  |  |  | Engine
 |  | Sub totals | Quote | Date | Estimated | Quoted/TBC | Accepted | Date | Payment 2 | Date | Outstanding | Invoice Status |  |  |  |  |  | [NAME] today
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 1
 |  |  |  |  |  |  | Engine Sheet |  |  | 2013-02-16 00:00:00
Spreadsheet: darron_c_giron__8007__AGAVE
Sheet: July

 | Note: Insert the #'s in red to calculate the customer price
 | Crude Merc | IF-Elpaso Perm | IF-HH | IF-Elpaso/SJ | IF-TW-Permian
 | 19.659 | 2 | 2.16 | 1.97 | 1.99
 |  |  | Spot price |  | Index Price
CPR# | TAGG # | PanEnergy/Duke | Facility | Term | Calculated Price
98063 | E21728 | 2,500/day | 813780 | 7/95-12/2001
CPR# | TAGG # | Union Pacific | Facility | Term | Calculated Price
48853 | E11400 | 2,500/day | 813367 | 1/92-12/2003
CPR# | TAGG # | Union Pacific | Facility | Term | Calculated Price
3217 | E22656 | 7,000/day | 813367 | 1/95-12/2001
CPR# | TAGG # | Vastar | Facility | Term | Calculated Price
3231 | E21977 | 10,000/day | 501079 | 6/96-4/2002
CPR# | TAGG # | Agave/Yates | Facility | Term | Calculated Price
93788 | E20337 | 10,000/day | 58649 | 1/93-12/2002
Spreadsheet: 81731d1281901847-counting-how-often-numbers-in-a-range-occur-in-rows-of-data-countoccurrences
Sheet: Sheet1

Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 |  | 40>49 | 30>49 | 20>29 | 10>19 | 1>9 | Zeros |  | Occurences | 40>49 | 30>49 | 20>29 | 10>19 | 1>9 | Zeros
10 | 0 | 9 | 0 | 41 | 44 |  | 2 | 0 | 0 | 1 | 1 | 2 |  | 1 | 5 | 10 | 6 | 1 | 2 | 0
12 | 17 | 23 | 31 | 43 | 46 |  | 2 | 1 | 1 | 2 | 0 | 0 |  | 2 | 10 | 4 | 3 | 14 | 1 | 1
15 | 18 | 23 | 29 | 32 | 43 |  | 1 | 1 | 2 | 2 | 0 | 0 |  | 3 | 0 | 0 | 0 | 0 | 0 | 0
10 | 11 | 32 | 38 | 41 | 44 |  | 2 | 2 | 0 | 2 | 0 | 0 |  | 4 | 0 | 0 | 0 | 0 | 0 | 0
12 | 17 | 23 | 31 | 43 | 46 |  | 2 | 1 | 1 | 2 | 0 | 0 |  | 5 | 0 | 0 | 0 | 0 | 0 | 0
15 | 18 | 23 | 29 | 32 | 43 |  | 1 | 1 | 2 | 2 | 0 | 0 |  | 6 | 0 | 0 | 0 | 0 | 0 | 0
10 | 11 | 32 | 38 | 41 | 44 |  | 2 | 2 | 0 | 2 | 0 | 0 |  | Not in Rows | 0 | 1 | 6 | 0 | 12 | 14
12 | 17 | 23 | 31 | 43 | 46 |  | 2 | 1 | 1 | 2 | 0 | 0
15 | 18 | 8 | 29 | 32 | 43 |  | 1 | 1 | 1 | 2 | 1 | 0 |  | [NAME]
10 | 11 | 32 | 38 | 41 | 44 |  | 2 | 2 | 0 | 2 | 0 | 0 |  | Grouping |  | 1 | 2 | 3 | 4 | 5 | 6
12 | 17 | 23 | 31 | 43 | 46 |  | 2 | 1 | 1 | 2 | 0 | 0 |  | 40>49 | 40 | 5 | 10 | 0 | 0 | 0 | 0
15 | 18 | 2 | 2 | 32 | 43 |  | 1 | 1 | 0 | 2 | 2 | 0 |  | 30>49 | 30 | 10 | 4 | 0 | 0 | 0 | 0
10 | 11 | 32 | 38 | 41 | 44 |  | 2 | 2 | 0 | 2 | 0 | 0 |  | 20>29 | 20 | 6 | 3 | 0 | 0 | 0 | 0
12 | 17 | 23 | 31 | 43 | 46 |  | 2 | 1 | 1 | 2 | 0 | 0 |  | 10>19 | 10 | 1 | 14 | 0 | 0 | 0 | 0
15 | 18 | 23 | 29 | 32 | 47 |  | 1 | 1 | 2 | 2 | 0 | 0 |  | 1>9 | 0 | 2 | 1 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Zeros | Zeros | 0 | 1 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Grouping | Not in |  | Grouping Band |  | Totals |  | Totals
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 40>49 | 0 |  | 40>49 | 49 | 25 |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30>49 | 1 |  | 30>49 | 39 | 18 |  | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 20>29 | 6 |  | 20>29 | 29 | 12 |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10>19 | 0 |  | 10>19 | 19 | 29 |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1>9 | 12 |  | 1>9 | 9 | 4 |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Zeros | 14 |  | Zeros | 0 | 2 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Check |  | 1 | 2 | 3 | 4 | 5 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 0 | 1 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 1 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 1 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sum | 2 | 1 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2 | 1 | 0 | 0 | 0 | 0
Spreadsheet: 237511d1369235182-when-i-filter-a-column-my-hyperlinks-go-to-the-wrong-location-sample_hyperlinked_spreadsheet_5_22_2013
Sheet: Clue

Customer Number | Customer Name | Year Purchased | Version | Number of Times Played
AA1004 | [NAME] | 2001 | 1 | 16
AB1005 | [NAME] | 2003 | 1 | 38
AB1087 | [NAME] | 2000 | 2 | 94
Spreadsheet: 131378d1322942467-filtering-data-in-pivot-table-book1
Sheet: Sheet1

[NAME] | Client fidèle | Count of [NAME]
Drummondville | oui | 3
Gatineau | oui | 8
Granby | oui | 12
La Baie | oui | 9
Nicolet | oui | 11
Québec | oui | 6
Saint-Hyacinthe | oui | 10
Sherbrooke | oui | 11
Terrebonne | oui | 8
Trois-Rivières | oui | 7
Grand Total |  | 85
Row Labels
2011-05-01
2011-05-02
2011-05-03
2011-05-04
2011-05-06
2011-05-07
2011-05-08
2011-05-09
2011-05-10
2011-05-11
2011-05-12
2011-05-13
2011-05-14
2011-05-15
2011-05-16
2011-05-17
2011-05-18
2011-05-19
2011-05-20
2011-05-21
2011-05-22
2011-05-24
2011-05-25
2011-05-26
2011-05-27
2011-05-28
2011-05-29
2011-05-30
2011-05-31
2011-06-01
2011-06-02
2011-06-03
2011-06-04
2011-06-05
2011-06-06
2011-06-07
2011-06-08
2011-06-09
2011-06-10
2011-06-11
2011-06-12
2011-06-13
2011-06-14
2011-06-15
2011-06-16
2011-06-17
2011-06-18
2011-06-19
2011-06-20
2011-06-21
2011-06-22
2011-06-23
2011-06-24
2011-06-25
2011-06-26
2011-06-27
2011-06-28
2011-06-29
2011-06-30
2011-07-01
2011-07-02
2011-07-03
2011-07-04
2011-07-05
2011-07-06
2011-07-07
2011-07-08
2011-07-09
2011-07-10
2011-07-11
2011-07-12
2011-07-13
2011-07-14
2011-07-15
2011-07-16
2011-07-17
2011-07-18
2011-07-19
2011-07-20
2011-07-21
2011-07-22
2011-07-23
2011-07-24
2011-07-25
2011-07-26
2011-07-27
2011-07-28
2011-07-29
2011-07-30
2011-07-31
2011-05-01 00:00:00
2011-07-31 00:00:00
Grand Total
Spreadsheet: 92c62351-0708-460c-b379-b9ab6fdc45b8
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FBANG | Test | FBANG | [NAME] | [NAME] | Enzyme Immunoassay (FEIA) |  |  |  |  |  | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | <2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.   Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr. 			Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FBANG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FBANG | Result | FBANG | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 99117d1297865326-if-formula-for-multiple-conditions-if-formula-help
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inns
 | Team A | Runs | Wickets | Overs | Innings | Runs | Wickets | Overs | Team B |  |  |  |  | Result |  |  |  |  |  | Team Bat First | <--
 | England | 289 | 6 | 50 | <-- | 209 | 9 | 50 | Bangladesh |  |  |  |  |  |  |  |  |  |  |  | --> | Team Bat First
 | Pakistan | 306 | 5 | 48.3 | --> | 304 | 8 | 50 | India
 | Australia | 317 | 8 | 50 | --> | 320 | 6 | 50 | S.Africa
 | Kenya | 281 | 9 | 50 | <-- | 282 | 5 | 47.1 | Canada
 | Notes
a | I want to modify the formula in column M and column N in such manner that it will work for rows 5 and 6 as well as it is working perfectly for row 3 & 4.
b | The only difference is that in rows 3 & 4 winners are from colum B, while in rows 5&6 winners are from Column J.
c | In M5, the formula as to calculate the difference between G5&C5,while in M6, it has to calculate the difference between 10-H6
Spreadsheet: 122112d1316617774-planner-roo-booking-example-1-
Sheet: Sheet2

Date | Time Start | Time End | Booked By
2011-10-01 00:00:00 | 07:30:00 | 11:30:00 | Mr [NAME]
2011-10-03 00:00:00 | 10:30:00 | 14:30:00 | [NAME]
2011-10-15 00:00:00 | 10:00:00 | 14:30:00 | [NAME]
2011-10-04 00:00:00 | 09:00:00 | 13:00:00 | [NAME]
Spreadsheet: 70692d1271408818-lookup-function-lookup-example
Sheet: Sheet1

AA-068V | 2005 | AA-654F | 2009 | #N/A
AA-661F | 2006 | AA-724 | 2008 | #N/A
[NAME] | 2006 | AA-738 | 2010 | #N/A
AA-660 | 2006 | AA-759 | 2008 | #N/A
AA-670 | 2006 | AA-773 | 2009 | #N/A
AA-687F | 2007 | AA-819 | 2009 | #N/A
AA-699F | 2007 | AA-820 | 2009 | #N/A
AA-700F | 2007 | AA-821 | 2010 | #N/A
AA-701F | 2007 | AA-822 | 2009 | #N/A
AA-702F | 2007 | AA-828F | 2010 | #N/A
AA-728 | 2007 | AA-829F | 2010 | #N/A
AA-730F | 2007 | AA-661F | #N/A | #N/A
AA-731 | 2007 | [NAME] | #N/A | #N/A
AA-669 | 2007 | AA-687F | #N/A | #N/A
AA-672F | 2007 | AA-695F | 2008 | #N/A
[NAME] | 2007 | AA-699F | #N/A | #N/A
AA-684 | 2007 | AA-700F | #N/A | #N/A
AA-698F | 2007 | AA-701F | #N/A | #N/A
AA-703F | 2007 | AA-702F | #N/A | #N/A
AA-714F | 2007 | AA-727 | 2008 | #N/A
AA-720 | 2007 | AA-728 | #N/A | #N/A
AA-668 | 2007 | AA-730F | #N/A | #N/A
AA-679F | 2007 | AA-731 | #N/A | #N/A
AA-682 | 2007 | AA-739 | 2008 | #N/A
AA-713 | 2007 | AA-748 | 2008 | #N/A
AA-715 | 2007 | AA-749 | 2008 | #N/A
AA-716 | 2007 | AA-756 | 2008 | #N/A
AA-718 | 2007 | AA-767 | 2008 | #N/A
AA-719 | 2007 | AA-783F | 2009 | #N/A
AA-721 | 2007 | AA-785 | 2009 | #N/A
AA-722 | 2007 | AA-786 | 2009 | #N/A
AA-723 | 2007 | AA-804 | 2009 | #N/A
AA-733 | 2007 | AA-669 | #N/A | #N/A
AA-734 | 2007 | AA-671F | 2009 | #N/A
AA-735 | 2007 | AA-672F | #N/A | #N/A
AA-736 | 2007 | AA-680 | 2008 | #N/A
AA-724 | 2008 | [NAME] | #N/A | #N/A
AA-759 | 2008 | AA-683 | 2008 | #N/A
AA-695F | 2008 | AA-684 | #N/A | #N/A
AA-727 | 2008 | AA-698F | #N/A | #N/A
AA-739 | 2008 | AA-703F | #N/A | #N/A
AA-748 | 2008 | AA-714F | #N/A | #N/A
AA-749 | 2008 | AA-717 | 2008 | #N/A
AA-756 | 2008 | AA-720 | #N/A | #N/A
AA-767 | 2008 | AA-725 | 2008 | #N/A
AA-680 | 2008 | AA-747 | 2008 | #N/A
AA-683 | 2008 | AA-751 | 2008 | #N/A
AA-717 | 2008 | AA-753F | 2008 | #N/A
AA-725 | 2008 | AA-772 | 2008 | #N/A
AA-747 | 2008 | AA-776 | 2008 | #N/A
AA-751 | 2008 | AA-784 | 2009 | #N/A
AA-753F | 2008 | AA-787 | 2009 | #N/A
AA-772 | 2008 | AA-812 | 2009 | #N/A
AA-776 | 2008 | AA-068 | #N/A | #N/A
AA-752 | 2008 | AA-660 | #N/A | #N/A
AA-757F | 2008 | AA-668 | #N/A | #N/A
AA-760F | 2008 | AA-670 | #N/A | #N/A
AA-771 | 2008 | AA-679F | #N/A | #N/A
AA-777 | 2008 | AA-682 | #N/A | #N/A
AA-654F | 2009 | AA-713 | #N/A | #N/A
AA-773 | 2009 | AA-715 | #N/A | #N/A
AA-819 | 2009 | AA-716 | #N/A | #N/A
AA-820 | 2009 | AA-718 | #N/A | #N/A
AA-822 | 2009 | AA-719 | #N/A | #N/A
AA-783F | 2009 | AA-721 | #N/A | #N/A
AA-785 | 2009 | AA-722 | #N/A | #N/A
AA-786 | 2009 | AA-723 | #N/A | #N/A
AA-804 | 2009 | AA-733 | #N/A | #N/A
AA-671F | 2009 | AA-734 | #N/A | #N/A
AA-784 | 2009 | AA-735 | #N/A | #N/A
AA-787 | 2009 | AA-736 | #N/A | #N/A
AA-812 | 2009 | AA-752 | #N/A | #N/A
AA-782 | 2009 | AA-757F | #N/A | #N/A
AA-803 | 2009 | AA-760F | #N/A | #N/A
AA-738 | 2010 | AA-771 | #N/A | #N/A
AA-821 | 2010 | AA-777 | #N/A | #N/A
AA-828F | 2010 | AA-782 | #N/A | #N/A
AA-829F | 2010 | AA-803 | #N/A | #N/A