tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 583577d1532516853-rework-a-template-in-order-to-create-a-weekly-calendar-2018_07_24__kalender
Sheet: Feiertage

2018
2018-01-01 00:00:00 | Neujahr
2018-03-30 00:00:00 | [NAME]
2018-04-01 00:00:00 | Ostersonntag
2018-04-02 00:00:00 | Ostermontag
2018-05-01 00:00:00 | Tag der Arbeit
2018-05-10 00:00:00 | [NAME]
2018-05-21 00:00:00 | Pfingstmontag
2018-05-31 00:00:00 | Fronleichnam
2018-10-03 00:00:00 | Tag der deutschen Einheit
2018-11-01 00:00:00 | Allerheiligen
2018-12-25 00:00:00 | 1. Weihnachtsfeiertag
2018-12-26 00:00:00 | 2. Weihnachtsfeiertag
2019-01-01 00:00:00 | Neujahr
Spreadsheet: 837207d1689937079-formula-to-pull-from-one-tab-to-another-efhelp
Sheet: Summary

PWO # | Status | SKU | Description | [NAME] | Fill Type | Qty Req | Bulk Code | Bulk Req | Label Code | Bottle Code | [NAME]
1 | Closed | HU16860 | HU Sea Kelp 4000mg 180 Vegan Tablets | 180 | Tablets | 1111 | BULK-16860 | 199980 | LAB-HU-16860 | BOT-100Clear | CAP-38mmGold
2 | Closed | CU16860 | DNR - CU Sea Kelp 2000mg 180 Tablets | 180 | Tablets | 1111 | BULK-16860 | 199980 | LAB-CU-9092 | BOT-100Clear | CAP-38mmSilver
Spreadsheet: 583628d1532539087-index-formula-output-error-index-formula-sample-workbook
Sheet: Sheet1

 | Name | Value |  |  |  |  |  |  | Expected Results
 | A | 10 |  |  |  | Name | Value |  | Name | Value
 | B | 20 |  |  |  |  |  |  | A | 10
 | C | 30 |  |  |  |  |  |  | B | 20
 | D | 40 |  |  |  |  |  |  | C | 30
 | E | 50 |  |  |  |  |  |  | D | 40
 | F | 60 |  |  |  |  |  |  | E | 50
 | G | 70 |  |  |  |  |  |  | F | 60
 | H | 80 |  |  |  |  |  |  | G | 70
 | I | 90 |  |  |  |  |  |  | H | 80
 | J | 100 |  |  |  |  |  |  | I | 90
 | K | 0 |  |  |  |  |  |  | J | 100
 | L | 0 |  |  |  |  |  |  | X | -10
 | M | 0
 | N | 0
 | O | 0
 | P | 0
 | Q | 0
 | R | 0
 | S | 0
 | T | 0
 | U | 0
 | V | 0
 | W | 0
 | X
Spreadsheet: 67140d1267732447-vlookup-2-conditions-testsheet
Sheet: full data

 | B
 | B
 | B
 | B
 | oddnameout
 | B
 | B
 | B
 | B
 | B
 | c
 | c
 | c
 | c
 | c
 | c
 | c
 | c
 | c
 | B
 | B
 | B
 | B
 | B
 | BK
 | BK
 | BK
 | BK
 | BK
 | BK
 | BK
 | BK
 | BK
 | BK
 | C
 | C
 | C
 | C
 | C
 | C
 | C
 | C
 | C
 | ODDNAMEOUT
 | orange
 | orange
 | orange
 | orange
 | orange
 | orange
 | orange
 | orange
 | orange
 | orange
 | orange
 | orange
 | orange
 | orange
 | orange
 | orange
 | orange
 | orange
 | orange
 | plum
 | plum
 | plum
 | prune
 | prune
 | prune
 | prune
 | prune
 | prune
 | prune
 | prune
 | prune
 | george
 | prune
 | prune
 | prune
 | D
 | D
 | D
 | D
 | D
 | kiwi
 | kiwi
 | kiwi
 | kiwi
 | kiwi
 | kiwi
 | ORANGE
 | ORANGE
 | ORANGE
 | ORANGE
 | ORANGE
 | ORANGE
 | ORANGE
 | ORANGE
 | ORANGE
 | ORANGE
 | E
 | E
 | E
 | E
 | E
 | E
 | E
 | E
 | MANGO
 | MANGO
 | MANGO
 | MANGO
 | kiwi
 | kiwi
 | kiwi
 | kiwi
 | kiwi
 | kiwi
 | kiwi
 | kiwi
 | kiwi
 | kiwi
 | kiwi
 | kiwi
 | G
 | G
 | H
 | H
 | H
 | H
 | H
 | H
 | H
 | H
 | H
 | H
 | H
 | I
 | I
 | I
 | I
 | I
 | I
 | I
 | I
 | GRAPE
 | GRAPE
 | GRAPE
 | GRAPE
 | GRAPE
 | GRAPE
 | GRAPE
 | GRAPE
 | GRAPE
 | GRAPE
 | GRAPE
 | GRAPE
 | J
 | J
 | J
 | J
 | J
 | J
 | K
 | K
 | K
 | K
 | K
 | K
 | K
 | K
 | L
 | L
 | L
 | L
 | L
 | L
 | car
 | car
 | car
 | car
 | car
 | car
 | boat
 | boat
 | boat
 | boat
 | boat
 | plane
 | plane
 | plane
 | plane
 | plane
 | plane
 | plane
 | plane
 | plane
 | plane
 | plane
 | plane
 | plane
 | plane
Spreadsheet: 776615d1649830152-count-no-of-cases-based-on-a-given-date-range-countnocase
Sheet: Defect

S/No | Car | Defect | WO/JR No. | Since | Status | Clear | >3 | No of Cases | >7 |  | >3 | cases | >7
1 | 10 |  | NA | 02-09-20 | Pending Investigation | 2020-09-12 00:00:00 |  |  |  |  | 4 | 7 | 0
2 | 19 |  | NA | 05-09-20 | Pending Investigation | 2020-09-09 00:00:00 |  |  |  |  | 0 | 2 | 0
3 | 16 |  | NA | 10-09-20 | To Replace Low P Pipe | 2020-09-12 00:00:00 |  |  |  |  | 0 | 0 | 0
4 | 12 |  | NA | 15-09-20 | Pending Investigation |  |  |  |  |  | 9 | 12 | 5
Spreadsheet: darrell_schoolcraft__7304__imball0201
Sheet: Citizens

Citizens Communications
 | Measured | Scheduled | Imbalance
56659 |  | -1386
500046 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500086 |  |  |  |  |  |  |  |  |  |  | lunch | 7.6
500134 |  | -19719
500528
500529
500619
INDEX
2001-12-31 00:00:00 |  |  | -537692.79
2002-01-12 00:00:00
CBS Volume
 |  |  | -36823
2002-01-12 00:00:00
Spreadsheet: 138130d1327521372-creating-multiple-rows-of-data-from-a-single-row-source-example
Sheet: Item Master

Item Number | Description
1 | Apple
2 | [NAME]
3 | [NAME]
4 | Coconut
5 | Blueberry
6 | Lime
7 | Lemon
8 | Grape
9 | Watermelon
10 | Peach
Spreadsheet: 115786d1311283269-need-to-locate-numbers-in-a-list-785218-need-to-locate-numbers
Sheet: Long List

1
4
7
9
10
11
12
13
14
15
16
21
22
23
24
28
29
30
31
32
Spreadsheet: 875895d1722518426-help-with-overtime-formula-overtime-example-2
Sheet: Mon-Thurs 9.15 hr-day 49 hr Wk 

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

 |  | Uruguay | Uzbekistan | [NAME] | Vatican City | Venezuela | Vietnam | Yemen | Zambia | Zimbabwe | Merge
1 |  | Uruguay | Uzbekistan |  | Vatican City
2 | USA |  |  |  |  |  |  |  | Zambia |  | USA, Zambia |  | example
3 |  |  | Uzbekistan
4 |  |  |  |  |  |  | Vietnam | Yemen
5 | USA |  |  |  |  |  |  |  |  | Zimbabwe
Spreadsheet: 819022d1677179335-highlight-entire-row-with-cf-and-2-criteria-sumproduct_greater_dropdown_many_criteria
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  | COUNT | SUM
 |  | No | Name | Amount | Status |  |  | HIRED | 20
 |  | 1 | A | 44 | HIRED |  | PENDING
 |  | 2 | B | 89 | PENDING |  | PAID
 |  | 3 | C | 15 | HIRED
 |  | 4 | D | 32 | PENDING
 |  | 5 | E | 18 | PENDING
 |  | 6 | F | 22 | PENDING
 |  | 7 | G | 18 | PENDING
 |  | 8 | H | 93 | PENDING
 |  | 9 | I | 81 | PENDING
 |  | 10 | J | 46 | PENDING
 |  | 11 | K | 49 | PENDING
 |  | 12 | L | 68 | PENDING
 |  | 13 | M | 70 | HIRED
 |  | 14 | N | 92 | HIRED
 |  | 15 | O | 57 | HIRED
 |  | 16 | P | 15 | PAID
Spreadsheet: 39812d1238084268-bar-chart-with-highliting-lines-trend-report
Sheet: Snapshot

 | September 08 | October 08 | November 08 | December 08 | Janurary 09 | February 09
product 1 | 1379 | 1383 | 1512 | 1425 | 1673 | 1606
product 2 | 637 | 732 | 1128 | 837 | 952 | 773
product 3 | 0 | 138 | 217 | 184 | 177 | 178
product 4 | 113 | 150 | 256 | 169 | 188 | 171
product 5 | 0 | 0 | 0 | 0 | 0 | 540
Spreadsheet: 207017d1358348626-is-it-possible-to-sum-first-and-last-cells-dmmy
Sheet: Sheet1

2013-05-05 00:00:00 | 1564
2013-05-06 00:00:00 | 158
2013-05-07 00:00:00 | 14894
2013-05-08 00:00:00 | 18165
2013-05-09 00:00:00 | 1564
2013-05-10 00:00:00 | 5645458
2013-05-11 00:00:00 | 588
2013-05-12 00:00:00 | 15848
2013-05-13 00:00:00 | 1564
2013-05-14 00:00:00 | 1848
Spreadsheet: 157658d1337821874-pulling-statistics-based-on-name-ef98_role-store
Sheet: Data By Store

Store Name | Sales Team Breakdown |  |  |  | Open Opportunities | Closed Deal - Closed | Closed - Lost | Cancelled | Opportunity Conversion Rate
Store 1
 | [NAME] |  | Role 5
 | LESLEY BUCKLAND |  | Role 3
 | LESLIE TEO |  | Role 3
 | [NAME] |  | Role 4
 | MIRANDA KWAN |  | Role 2
 | [NAME] |  | Role 2
 | EVEY PARK |  | Role 1
 | JUSTIN BARNES |  | Role 1
 | ARUNA RATNAYAKE |  | Role 1
 | IRIS GUO |  | Role 1
 | ASHA CHERIAN |  | Role 1
 | [NAME] |  | Role 1
Spreadsheet: 072f70b8-aa8f-48d2-9e4c-1ac48548fa42
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
FFTEM | Test | FFTEM | Temazepam (Restoril), Serum | Temazepam (Restoril) | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp OR Plain, Red-Top Tube: Red OR |  |  | 2 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top (sodium heparin) tube(s). ([NAME] is not acceptable.) Spin down and send 2 mL sodium heparin plasma refrigerated. Note:	1. Indicate plasma on request form.    	2.  [NAME] specimen appropriately (plasma).  	3. Trough levels are most reproducible   Serum Draw blood in a plain, red-top tube(s). (Serum gel tube is not acceptable.) Spin down and send 2 mL of serum refrigerated. Note:	1. Indicate serum on request form. 	2. Label specimen appropriately (serum). 	3. Trough levels are most reproducible | 0.3 mL NOTE: Submission of the m | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | [NAME]: 50 - 1000 ng/mL   Test Performed by: Medtox Laboratories, Inc.                              402 W County Road D                              St. Paul, MN 55112 | Monday through Sunday | 3 days | 5 - 7 days | 1 | 80154 |  |  |  |  | Medtox Laboratories, Inc
FFTEM | Result | [NAME] | Temazepam (Restoril) | Temazepam (Restoril) | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 1cd205eb-0c49-481d-b08f-26e2692dc6e8
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | DISTRICT USE ONLY | Unnamed: 16 | Unnamed: 17 | Unnamed: 18
Request for Appropriation Transfer |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Document No.
TO: | DISTRICT ACCOUNTING OFFICE |  |  |  |  |  |  |  |  |  |  |  |  |  | DATE:
 | ADMINISTRATIVE SERVICES
TRANSFER TO:
Account Number |  |  |  |  |  |  |  |  |  | Account Description |  |  |  |  |  |  |  | Amount
Fund (2) | Program (4) |  | Sub-Program (1) | TOPS ( 6) |  |  |  | OBJECT (4)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  |  | 0
TRANSFER FROM:
Account Number |  |  |  |  |  |  |  |  |  | Account Description |  |  |  |  |  |  |  | Amount
Fund (2) | Program (4) |  | Sub-Program (1) | TOPS ( 6) |  |  |  | OBJECT (4)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  |  | 0
Explanation: |  | (Describe source of income and purpose of project, etc.)
Requested by: |  |  |  |  |  |  |  |  |  | Approved by:
Signature |  |  |  |  |  |  |  |  |  | Signature
Print Name and Title |  |  |  |  |  |  |  |  |  | Print Name and Title of Supr/Pres. or Vice President
Spreadsheet: 806740d1669547857-populating-cells-with-number-of-hours-taken-during-that-week-book2-hd
Sheet: Sheet2

 | Week Ending
[NAME] | 2022-11-12 00:00:00 | 2022-11-19 00:00:00 | 2022-11-26 00:00:00 | 2022-12-03 00:00:00 | 2022-12-10 00:00:00 | 2022-12-17 00:00:00 | 2022-12-24 00:00:00 | 2022-12-31 00:00:00 | 2023-01-07 00:00:00 | 2023-01-14 00:00:00 | 2023-01-21 00:00:00 | 2023-01-28 00:00:00 | 2023-02-04 00:00:00 | 2023-02-11 00:00:00 | 2023-02-18 00:00:00 | 2023-02-25 00:00:00 | 2023-03-04 00:00:00 | 2023-03-11 00:00:00 | 2023-03-18 00:00:00 | 2023-03-25 00:00:00
Leave
Mark | 2022-11-12 00:00:00 | 2022-11-19 00:00:00 | 2022-11-26 00:00:00 | 2022-12-03 00:00:00 | 2022-12-10 00:00:00 | 2022-12-17 00:00:00 | 2022-12-24 00:00:00 | 2022-12-31 00:00:00 | 2023-01-07 00:00:00 | 2023-01-14 00:00:00 | 2023-01-21 00:00:00 | 2023-01-28 00:00:00 | 2023-02-04 00:00:00 | 2023-02-11 00:00:00 | 2023-02-18 00:00:00 | 2023-02-25 00:00:00 | 2023-03-04 00:00:00 | 2023-03-11 00:00:00 | 2023-03-18 00:00:00 | 2023-03-25 00:00:00
Leave
Spreadsheet: 880845d1728673076-need-latest-value-in-the-row-based-on-a-cell-reference-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 | YTD |  | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar
Total | A |  | 5 | 2 | 4 | 7 | 9 | 6 | 9 | 5 | 7 | 4 | 8 | 2
 | B |  | 4 | 3 | 3 | 7 | 8 | 9 | 6 | 5 | 1 | 2 | 6 | 4
 | C |  | 3 | 4 | 7 | 6 | 5 | 2
Spreadsheet: 590195d1536902095-how-to-get-top-10-in-excel-from-an-unsorted-list-practice_top_10
Sheet: Sheet1

 | Employee | Department | Item Dispensed | Quantity | Prices Per Unit | Total |  | 1
 | Cesar | Engineering | [NAME] | 2 | 0.5 |  |  | 2
 | [NAME] | Accounting | Blue Pen | 1 | 0.5 |  |  | 3
 | Cesar | Engineering | Flashlight | 1 | 9.99 |  |  | 4
 | Cesar | Engineering | Switch | 2 | 3.99 |  |  | 5
 | Julia | Human Resources | Paperclips | 10 | 0.25 |  |  | 6
 | [NAME] | Security | Flashlight | 1 | 9.99 |  |  | 7
 | [NAME] | Accounting | Blue Pen | 1 | 0.5 |  |  | 8
 | [NAME] | Accounting | [NAME] | 4 | 0.5 |  |  | 9
 | [NAME] | Security | Gloves | 1 | 5.99 |  |  | 10
 | Julia | Human Resources | Flashlight | 1 | 9.99
 | Julia | Human Resources | Wrench | 1 | 5.99
 | Julia | Human Resources | Blue Pen | 1 | 0.5
 | Cesar | Engineering | [NAME] | 4 | 0.5
Spreadsheet: sally_beck__33763__NA GAS AND POWER-REGION BREAKOUT 08-30-00 EM
Sheet: NORTH AMERICAN GAS CHARTS

ENRON - North American Gas
AVERAGE EOL AND NON-EOL TRANSACTIONS PER DAY
REGION BREAKOUT
As of August 30, 2000
 |  | AVERAGE DEALS PER DAY
MONTH | DAYS | EOL | NON-EOL | TOTAL
1999-11-01 00:00:00 | 2 | 53 | 619 | 672
1999-12-01 00:00:00 | 21 | 225 | 599 | 824
2000-01-01 00:00:00 | 20 | 492 | 636 | 1128
2000-02-01 00:00:00 | 20 | 777 | 640 | 1417
2000-03-01 00:00:00 | 23 | 1039 | 606 | 1645
2000-04-01 00:00:00 | 19 | 1079 | 635 | 1713
2000-05-01 00:00:00 | 22 | 1582 | 729 | 2311
2000-06-01 00:00:00 | 22 | 1952 | 667 | 2619
2000-07-01 00:00:00 | 19 | 1845 | 689 | 2535
2000-08-01 00:00:00 | 22 | 1924 | 638 | 2562
TOTAL AVERAGE | 190 | 1209 | 648 | 1857
REGION BREAKOUT (Region breakout based on deal locations and pub code)
Spreadsheet: 148681d1333511425-identifying-current-streaks-of-goals-points-streak-example
Sheet: Sheet1

Date | OPP | Goal | Assist | Points
2011-09-23 00:00:00 | vs NAN | 1 | 0
2011-09-24 00:00:00 | vs NAN | 1 | 2 |  |  |  |  | [NAME] | Correct Result
2011-09-28 00:00:00 | at CVC | 0 | 0 |  |  |  | Goal Streak |  | 4
2011-10-01 00:00:00 | vs LAN | 0 | 1 |  |  |  | Assist Streak |  | 1
2011-10-02 00:00:00 | vs LAN | 1 | 0 |  |  |  | Point Streak |  | 5
2011-10-07 00:00:00 | vs ABV | 1 | 1
2011-10-08 00:00:00 | at LAN | 1 | 0
2011-10-09 00:00:00 | at COQ | 1 | 1
2011-10-13 00:00:00 | at MER
Spreadsheet: 232158d1367343093-sumif-help-clean
Sheet: Assumptions

 | Inputs and Assumptions
 |  | GENERAL
 |  | First month/year of forecast in model: |  |  | 2013-01-01 00:00:00
 |  | Duration |  |  | 11
 |  | Duration of Model |  | Start
 |  |  |  | End
 |  | Working Hours/ Day |  |  | 8
 |  | Actuals as on |  |  | 2013-03-31 00:00:00
 |  | [NAME]
 |  | Level |  |  | RateCard
 |  | N/A |  |  | 100
 |  | 7 |  |  | 100
 |  | 8 |  |  | 100
 |  | 9 |  |  | 100
 |  | 10 |  |  | 100
 |  | 11 |  |  | 100
 |  | 12 |  |  | 100
 |  | VP |  |  | 100
 |  | 0 |  |  | 100
 |  | Categorical Descriptors
 |  | Project Group | Workstream |  | Primary Role | Secondary Role | [NAME]Internal | Accounting Descriptors | Location | Billing Type | Status | Sourced
 |  | Other | Other |  | Other | Other | Other | Other | Other | Other | Other | Other
 |  | Other | Other |  | Other | Other | Other | Other | Other | Other | Other | Other
 |  | Other | Other |  | Other | Other | Other | Other | Other |  | Other | Other
 |  | Other | Other |  | Other | Other | Other | Other
 |  | Other | Other |  | Other | Other | Other | Other
 |  | Other | Other |  | Other | Other | Other
 |  |  |  |  | Other | Other | Other
 |  |  |  |  | Other | Other | Other
 |  |  |  |  | Other | Other | Other
 |  |  |  |  | Other | Other | Other
 |  |  |  |  | Other | Other | Other
Spreadsheet: 4445fe5f-61c7-494c-9168-08899020cdd9
Sheet: Charter School Student Imprvmnt

Grant: |  | Title 1A Charter School Student Improvement
CFDA # |  | 84.010
GRANT NUMBER: |  | 5010
FISCAL YEAR: |  | 2011-12
[NAME]: |  | Not allowed on this grant
Question regarding payments: |  | [NAME]   [PHONE] or [EMAIL]
Questions regarding grant: |  | [NAME]6905 or [EMAIL]
LAST DAY TO SUBMIT REQUESTS FOR THIS GRANT  - November 15, 2012
Code | District Name | School Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | JULY 2011 | AUGUST 2011 | SEPTEMBER 2011 | OCTOBER 2011 | NOVEMBER 2011 | DECEMBER 2011 | JANUARY 2012 | FEBRUARY 2012 | MARCH 2012 | APRIL 2012 | MAY 2012 | JUNE 2012 | JULY 2012 | AUGUST 2012 | SEPTEMBER 2012 | OCTOBER 2012
8001 | CSI - Phase 2 Award |  | 148537 |  |  |  |  |  |  |  |  |  |  | 66390 |  |  |  | 66765 |  |  | 15382
Spreadsheet: dfbd03b7-c739-48bb-98ee-a591bca5ff50
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
RAMSU | Test | RAMSU | Amylase, Random, [NAME] | Amylase, Random, U | Enzymatic Rate | Plastic, urine tube: PlUrTb |  |  | 5 | mL | Container/Tube: Plastic, 6-mL tube (Supply T465) [NAME]: 5 mL Collection Instructions: 1. Collect a random urine specimen. 2. No preservative. | 1 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | No established reference values | Monday through Sunday; Continuously | 1 day | 2 days | 1 | 82150 |  |  |  |  | Rochester
RAMSU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
RAMSU | Result | RAMSU | Amylase, Random, U | Amylase, Random, U | Numeric |  |  |  |  | U/L |  |  |  |  |  |  |  |  |  | 1799-6 | Amylase:CCnc:Pt:[NAME]:Qn:
Spreadsheet: 782732d1654211763-find-fuzzy-match-from-single-column-example-match
Sheet: Sheet1

UPC | UPC char [NAME] | Suggested Result
[PHONE] |  | [PHONE]
[PHONE] |  | [PHONE]
[PHONE] |  | [PHONE]
[PHONE] |  | [PHONE]
[PHONE] |  | [PHONE]
[PHONE] |  | [PHONE]
[PHONE] |  | [PHONE]
[PHONE] |  | [PHONE]
[PHONE] |  | [PHONE]
[PHONE] |  | [PHONE]
Spreadsheet: 100831d1299066365-speed-up-max-if-array-sample-1-
Sheet: Equipment

ID | Value | [NAME]
1 | 1 | 1
1 | 1 | 1
2 | 1 | 2
2 | 2 | 2
3 | 2 | 2
3 | 2 | 2
3 | 1 | 2
4 | 1 | 3
4 | 2 | 3
4 | 3 | 3
5 | 1 | 2
5 | 2 | 2
5 | 2 | 2
5 | 1 | 2
5 | 2 | 2
6 | 1 | 3
6 | 3 | 3
6 | 2 | 3
6 | 3 | 3
Spreadsheet: 117038d1312403967-add-urls-based-on-number-of-images-example
Sheet: Sheet1

number of images | product id |  | Desired Output | Image Number | URL
1 | cd254664 |  | http://example.com/cd254664.jpg | 1
3 | cd554655 |  | http://example.com/cd554655.jpg,http://example.com/cd554655a.jpg,http://example.com/cd554655b.jpg | 2
3 | cd456111 |  | http://example.com/cd456111.jpg,http://example.com/cd456111a.jpg,http://example.com/cd456111b.jpg | 3
1 | cd648979 |  | http://example.com/cd648979.jpg
2 | cd321549 |  | http://example.com/cd321549.jpg,http://example.com/cd321549a.jpg
Spreadsheet: 820410d1678097599-data-selection-using-drop-down-options-book1
Sheet: 0203

[NAME] | Status | Contract Value
123 | Won | 132500
124 | In Process | 155000
127 | Lost | 76000
128 | Won | 145000
130 | Won | 30000
131 | In Process | 22000
134 | Won | 86000
137 | In Process | 90000
139 | Lost | 40000
141 | Won | 200000
Spreadsheet: 735993d1623311863-vlookup-to-calculate-the-total-per-site-test-example-etaf-1
Sheet: Sheet1

Site | Postcode | Lat | Long | Work | Number |  |  |  |  | Site | Postcode | Work | Sum of Number
Peacock Lane | BA12 9FA | 51.199468 | -2.174562 | Grass | 20 |  |  |  |  | Eden Grove | SN12 8QJ | Shrub | 105
Peacock Lane | BA12 9FA | 51.19936 | -2.174367 | Grass | 46 |  |  |  |  | Peacock Lane | BA12 9FA | Grass | 66
Eden Grove | SN12 8QJ | 51.395637 | -2.163002 | Shrub | 61 |  |  |  |  | Grand Total |  |  | 171
Eden Grove | SN12 8QJ | 51.395646 | -2.162932 | Shrub | 44
Results to be: | [NAME] which adds up all of the values for a work for the same site
Peacock Lane | BA12 9FA | 51.199468 | -2.174562 | Grass
Eden Grove | SN12 8QJ | 51.395637 | -2.163002 | Shrub
Spreadsheet: 120905d1315622745-cell-reads-other-cells-from-another-sheet-nfl-football-schedule-2011-2012-testing-
Sheet: Week 10

Thursday, November 10, 2011
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Oakland Raiders
San Diego Chargers
Sunday, November 13, 2011
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Arizona Cardinals
Philadelphia Eagles
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Tennessee Titans
Carolina Panthers
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Houston Texans
Tampa Bay Buccaneers
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Washington Redskins
[NAME]
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
[NAME]
Indianapolis Colts
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Denver Broncos
Kansas City Chiefs
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Buffalo Bills
Dallas Cowboys
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Detroit Lions
Chicago Bears
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
New Orleans Saints
Atlanta Falcons
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
St. Louis Rams
[NAME]
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Pittsburgh Steelers
Cincinnati Bengals
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Baltimore Ravens
[NAME]
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
New York Giants
San Francisco 49ers
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
New England Patriots
New York Jets
Monday, October 14, 2011
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Minnesota Vikings
Green Bay Packers
Teams on Bye
Spreadsheet: 295857d1391821372-power-trendline-equation-used-in-a-cell-tare-test-data
Sheet: Plot Data

 |  |  |  | To unlock the sheet, just unlock, no password required
 |  |  |  | Each of these has trendline equation data to allow for the creation of power trend lines on the graphs where a "0" value is not allowed.
 | From Tare Test Data |  |  | Step 1 Friction |  | Step 1 Blended |  | Step 2 Friction |  | Step 2 Blended |  | F/S Friction |  | F/S Blended |  | Emergency |  | Step 1 ECBI |  | Step 2 ECBI |  | F/S ECBI
 | Application | Stop Dist. | Speed | Stop Dist. | Speed | Stop Dist. | Speed | Stop Dist. | Speed | Stop Dist. | Speed | Stop Dist. | Speed | Stop Dist. | Speed | Stop Dist. | Speed | Stop Dist. | Speed | Stop Dist. | Speed | Stop Dist. | Speed
Spreadsheet: 33847d1230693114-lookup-with-words-monday-summer-2009
Sheet: Grades

Ladies Sect. 1 |  | Ladies Sect. 4/5 |  | Mixed B1 |  | [NAME]
Monday Night Roast | early | Chicken Collness | late | The Ferries | late | Mission Critical | late
Fancy Pants | late | Utopia | early | Dromanarama | early | Club [NAME] | early
[NAME] Ducks | early | City-Metro Pines ** | none | The Buff Nuffs | early | Go Go Ninja Geese | none
GOW | late | City-Metro Swifts | none | Hyped To Death | early | Terror Squad | none
City-Metro Bloopers ** | none | [NAME] | none | City-Metro Dodgers ** | none | The Mittens | early
[NAME] | early | Cougars | early | GreenWosh | early | Thumper ** | none
City-Metro Firebirds | none | Munch Bunch | early | Bullets | early | City-Metro Titans | none
 |  | The Ponies | early |  |  | The Fighting Mongooses | early
 |  | Generic | early |  |  | Team Dex | none
Clashes
City-Metro Bloopers |  | City-Metro Dodgers
City-Metro Bloopers |  | City-Metro Pines
City-Metro Bloopers |  | [NAME]
City-Metro Pines |  | [NAME]