tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: debfe20a-d602-4452-a839-823545c1f10c
Sheet: Sheet1

Table 4--Wheat: Monthly food disappearance estimates (1,000 grain-equivalent bushels), 4/11/2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Mkt year and month 1/
 |  |  | Wheat ground for flour | + | Food imports 2/ | + | Nonmilled food use 3/ | - | Food exports 2/ | = | Food use 4/
2012/13 | Jun |  | 72876 |  | 2173 |  | 2000 |  | 1760 |  | 75290
 | Jul |  | 75861 |  | 2296 |  | 2000 |  | 2912 |  | 77245
 | Aug |  | 82910 |  | 2345 |  | 2000 |  | 2193 |  | 85063
 | Sep |  | 79725 |  | 2069 |  | 2000 |  | 2283 |  | 81511
 | Oct |  | 81567 |  | 2462 |  | 2000 |  | 1840 |  | 84189
 | Nov |  | 78073 |  | 2438 |  | 2000 |  | 1613 |  | 80897
 | Dec |  | 73283 |  | 2369 |  | 2000 |  | 1442 |  | 76210
 | Jan |  | 72290 |  | 2191 |  | 2000 |  | 1550 |  | 74931
 | Feb |  | 71716 |  | 2101 |  | 2000 |  | 1674 |  | 74143
 | Mar |  | 76088 |  | 2391 |  | 2000 |  | 1744 |  | 78734
 | Apr |  | 74599 |  | 2581 |  | 2000 |  | 1432 |  | 77748
 | May |  | 76274 |  | 2530 |  | 2000 |  | 2042 |  | 78763
2013/14 | Jun |  | 72975 |  | 2277 |  | 2000 |  | 2430 |  | 74823
 | Jul |  | 74417 |  | 2519 |  | 2000 |  | 1474 |  | 77461
 | Aug |  | 81332 |  | 2548 |  | 2000 |  | 1450 |  | 84431
 | Sep |  | 78207 |  | 2271 |  | 2000 |  | 1498 |  | 80981
 | Oct |  | 84799 |  | 2700 |  | 2000 |  | 1845 |  | 87654
 | Nov |  | 81166 |  | 2448 |  | 2000 |  | 1612 |  | 84002
 | Dec |  | 76186 |  | 2566 |  | 2000 |  | 1735 |  | 79018
 | Jan |  | 0 |  | 2590 |  | 0 |  | 1476 |  | 1113
 | Feb |  | 0 |  | 2285 |  | 0 |  | 1308 |  | 978
1/ Current year is preliminary. Previous year is preliminary through August of current year, estimated afterwards. 2/ Food imports and exports used to calculate total food use. Includes all categories of wheat flour, semolina, bulgur, and couscous and selected categories of pasta. 3/ Wheat prepared for food use by processes other than milling.
4/ Estimated food use equals wheat ground for flour plus food imports plus nonmilled food use minus food exports. See http://www.ers.usda.gov/Briefing/Wheat/wheatfooduse.htm for more information. Source: Data through the 2nd quarter of 2011 was calculated using data from U.S. Department of Commerce, Bureau of the Census’ Flour Milling Products (MQ311A) and U.S. Department of Commerce, Bureau of Economic Analysis’ Foreign Trade Statistics. Subsequent flour milling calculations are based on data from the North American Millers Association.
Date run: 4/11/2014
Spreadsheet: gerald_nemec__11311__HPL List - 06-05-01
Sheet: Sheet1

0264 | JP0903 | HOUSTON PIPE LINE COMPANY | TX | CITY OF TEXAS CITY, TEXAS | 100000 | 2001-06-11 00:00:00 | CONT. CERT. | BOND COVERING PIPELINE ACTIVITY | 2000-06-11 00:00:00 | 0 | 200 | 1080
0265 | JP0940 | HOUSTON PIPE LINE COMPANY | TX | HARRIS COUNTY, TEXAS | 150000 | 2001-09-22 00:00:00 | [NAME] | [NAME] | 2000-09-22 00:00:00 | 0 | 300 | 1080
0266 | JZ7775 | HOUSTON PIPE LINE COMPANY | TX | U.S. DEPT. OF INTERIOR, CORPUS CHRIS | 100000 | 2002-05-18 00:00:00 | [NAME] | PERF. BOND/OPERATION OF NATURAL GAS | 2001-05-18 00:00:00 | 0 | 200 | 1080
0267 | KG9663 | HOUSTON PIPE LINE COMPANY | TX | DISTRICT COURT OF CHAMBERS COUNTY,TX | 10170 | 2001-06-30 00:00:00 | [NAME] | CONDEMNATION BOND | 2000-07-12 00:00:00 | 0 | 50 | 1080
0268 | SF0432 | HOUSTON PIPE LINE COMPANY | TX | RAILROAD COMMISSION OF TEXAS | 50000 | 2002-08-02 00:00:00 | CONT. CERT. | BLANKET PERFORMANCE BOND | 2001-06-01 00:00:00 | 0 | 175 | 1080
0269 | 136504 | HOUSTON PIPE LINE COMPANY | TX | FORT BEND COUNTY, TEXAS | 2000 | 2002-05-19 00:00:00 | [NAME] | PERFORANCE (PIPELINE CROSSING) | 2001-05-19 00:00:00 | 0 | 50 | 0687
0278 | 203982 | HOUSTON PIPELINE COMPANY | TX | JEFFERSON COUNTY, TX. | 10000 | 2002-06-27 00:00:00 | [NAME] | ROAD CROSSING | 2001-06-27 00:00:00 | 0 | 50 | 0687
0272 | 22000420 | HOUSTON PIPE LINE COMPANY | TX | COUNTY OF GALVESTON, TEXAS | 10000 | 2002-06-01 00:00:00 | [NAME] | BLANKET PIPELINE CROSSING BOND | 2001-06-01 00:00:00 | 0 | 50 | 2515
0273 | 22000433 | HOUSTON PIPE LINE COMPANY | TX | COUNTY OF HARDIN, TX | 10000 | 2001-08-25 00:00:00 | [NAME] | BLANKET PIPELINE CROSSING PERMIT | 2000-08-25 00:00:00 | 0 | 50 | 2515
0274 | 22000439 | HOUSTON PIPE LINE COMPANY | TX | FORT BEND COUNTY, TEXAS | 50000 | 2001-08-28 00:00:00 | [NAME] | PERPETUAL BOND-COVERING PIPELINE | 2000-08-28 00:00:00 | 0 | 100 | 2515
0275 | KO2549815 | HOUSTON PIPE LINE COMPANY, ET AL | TX | 156TH JUDICIAL DIST. CT. OF LIVE OAK | 44000 | 2001-07-17 00:00:00 | [NAME] | CONDEMNATION BOND | 2000-07-17 00:00:00 | 0 | 440 | 0185
0277 | KO2549827 | HOUSTON PIPE LINE COMPANY, ET AL | TX | 156TH DIST COURT OF LIVE OAK | OPEN | 2002-07-17 00:00:00 | [NAME] | OPEN PENALTY COST BOND | 2001-07-17 00:00:00 | 0 | 50 | 0185
Spreadsheet: 58497d1258730782-getting-a-row-of-data-from-sheet-1-to-another-week-day-averages
Sheet: Master data file

Sunday | 9.380952380952381 | 9.714285714285714 | 6.65 | 5.428571428571429 | 5.047619047619047 | 4.666666666666667 | 5.476190476190476 | 9.476190476190476 | 15.66666666666667 | 18.14285714285714 | 20.19047619047619 | 20.42857142857143 | 20.85714285714286 | 21.57142857142857 | 20.14285714285714 | 19.66666666666667 | 21.14285714285714 | 19.52380952380953 | 18 | 14.52380952380952 | 15.33333333333333 | 14.61904761904762 | 12.28571428571429 | 10.95238095238095
Monday | 8.285714285714286 | 7.857142857142857 | 6.285714285714286 | 6.047619047619047 | 5.857142857142857 | 9.333333333333334 | 8.714285714285714 | 15.19047619047619 | 19.42857142857143 | 20.38095238095238 | 27.42857142857143 | 25.47619047619047 | 26.61904761904762 | 31.85714285714286 | 32 | 30.66666666666667 | 34 | 31.76190476190476 | 31.57142857142857 | 24.80952380952381 | 27.80952380952381 | 24 | 20.28571428571428 | 16.95238095238095
Tuesday | 13.57142857142857 | 9.333333333333334 | 7.190476190476191 | 6.190476190476191 | 4.904761904761905 | 7.190476190476191 | 8.952380952380953 | 17.71428571428572 | 20.66666666666667 | 26.04761904761905 | 29.61904761904762 | 30.09523809523809 | 30.85714285714286 | 31.57142857142857 | 32.52380952380953 | 34.38095238095238 | 36.61904761904762 | 34.71428571428572 | 29.80952380952381 | 23.71428571428572 | 28.23809523809524 | 24.85714285714286 | 21.95238095238095 | 17.33333333333333
Wednesday | 12.81818181818182 | 10.27272727272727 | 7.681818181818182 | 5 | 4.272727272727272 | 10.40909090909091 | 10.27272727272727 | 17.54545454545455 | 21.95454545454545 | 23.5 | 25.63636363636364 | 31.86363636363636 | 27.5 | 32.13636363636363 | 31.22727272727273 | 30.45454545454545 | 32.63636363636363 | 35.90909090909091 | 31.72727272727273 | 25.13636363636364 | 28.36363636363636 | 21.77272727272727 | 20.09090909090909 | 15.77272727272727
Thursday | 13.25 | 9.15 | 6.2 | 5.65 | 4.5 | 11.15 | 9.95 | 14.9 | 19.35 | 23.15 | 27.85 | 28.75 | 30.3 | 29.8 | 27.65 | 28.7 | 32.8 | 30.8 | 28.45 | 20.3 | 28.1 | 21.95 | 16.8 | 17.85
Friday | 9.904761904761905 | 9.19047619047619 | 7.523809523809524 | 5.619047619047619 | 5.047619047619047 | 12.09523809523809 | 9.142857142857142 | 12.95238095238095 | 19.66666666666667 | 23.23809523809524 | 24.95238095238095 | 32.76190476190476 | 26.47619047619047 | 30.19047619047619 | 33.71428571428572 | 29.33333333333333 | 33.85714285714285 | 34.23809523809524 | 31.09523809523809 | 22.52380952380953 | 27.28571428571428 | 21.47619047619047 | 18.71428571428572 | 17.14285714285714
Saturday | 11.36842105263158 | 9.421052631578947 | 7.894736842105263 | 5.526315789473684 | 5.263157894736842 | 7.789473684210527 | 7 | 8.368421052631579 | 16.68421052631579 | 18.47368421052632 | 23.52631578947368 | 24.52631578947368 | 23.36842105263158 | 24.89473684210526 | 25.42105263157895 | 25.10526315789474 | 24.47368421052632 | 24.73684210526316 | 21.10526315789474 | 15.94736842105263 | 17.89473684210526 | 16 | 14.36842105263158 | 11.63157894736842
Spreadsheet: 43402d1242072506-convert-decimal-days-hours-and-seconds-example-book
Sheet: Sheet1

 |  |  |  |  |  |  |  | Year
Pizza Deliveries 2008
48 | Cheese |  |  |  |  |  |  | 365 | DAYS
210 | Pepperoni |  |  |  |  |  |  | 24 | HOURS
24 | Sale Item |  |  |  |  |  |  | 60 | MINUTES
135 | Special |  |  |  |  |  |  | 60 | SECONDS
267 | Drinks |  |  |  |  |  |  |  | Seconds per year
160 | [NAME]
16 | [NAME]
9 | Sauces |  |  |  |  |  |  | Cheese Pizza
 |  |  |  |  |  |  |  |  | SEC
 |  |  |  |  |  |  |  |  | MIN
 |  |  |  |  |  |  |  |  | HOURS
 |  |  |  |  |  |  |  |  | DAYS
Spreadsheet: 794880d1662378235-absence-trackershowing-extra-days-in-some-months-how-to-fix-employee-absence-tracker
Sheet: Spet Abs Data

 |  |  | PLEASE NOTE:  The start day is the first day of leave/sickness and the end date is the last day of leave/sickness and NOT the day that they retun to work
 | Employee Name | Start Date | End Date | Type of Leave | Reason for Sickness Absence | Other reasons for Leave Of Absence | Days | Self Cert Completed | Teaching / Non Teaching | Continued absence from previous month? | Has a Doctors Note been submitted? | Doctors Note Start | Doctors Note End | Is the [NAME] ongoing at the end of the month
 | Employee 1 | 2022-12-22 00:00:00 | 2022-12-30 00:00:00 | Sickness Absence | Heart (Pressure, Circulation etc)
 | Employee 1 | 2022-08-03 00:00:00 | 2022-08-05 00:00:00 | Sickness Absence | Mental Health (Stress / Anxiety etc)
 | Employee 1 | 2022-08-10 00:00:00 | 2022-08-12 00:00:00 | Sickness Absence | Back / Neck
 | Employee 1 | 2022-08-17 00:00:00 | 2022-08-19 00:00:00 | Dependant Care Paid
 | Employee 1 | 2022-08-24 00:00:00 | 2022-08-26 00:00:00 | Compassionate Paid
 | Employee 1 | 2022-12-22 00:00:00 | 2022-12-29 00:00:00 | Leave of Absence Paid |  | Fertility
 | Employee 1 | 2022-03-03 00:00:00 | 2022-03-10 00:00:00 | Leave of Absence Unpaid |  | Study Leave
 | Employee 1 | 2022-05-05 00:00:00 | 2022-05-15 00:00:00 | Dependant Care Unpaid
 | Employee 1
 | Employee 1
Spreadsheet: 0b0e7a2c-31bd-42ef-b7cc-17a629e7462a
Sheet: import success seats course

Row Labels | FA11 | SP12 | Grand Total | 0 | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 010 | 011 | 012 | 013 | 014 | 015 | 016 | 017 | 018 | 019 | 020 | 021
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26
Sum of Count
Row Labels
ART-101 | 16 |  | 16
ART-102 |  | 11 | 11
ASL-103 | 20 |  | 20
ASL-104 |  | 20 | 20
BIOL-117 |  | 26 | 26
ENGL-101 | 135 |  | 135
ENGL-103 |  | 107 | 107
ENVS-101 | 28 |  | 28
HIST-111 | 25 |  | 25
HIST-112 |  | 24 | 24
MATH-105 | 148 |  | 148
MATH-110 | 20 | 141 | 161
MATH-211 | 18 | 11 | 29
MATH-212 |  | 15 | 15
MUL-110 | 25 |  | 25
[NAME] | 13 |  | 13
PSYC-101 | 36 | 14 | 50
SPAN-101 | 93 |  | 93
SPAN-102 |  | 90 | 90
Grand Total | 577 | 459 | 1036
Spreadsheet: 687384d1595176256-how-to-convert-standardise-the-date-format-dates
Sheet: Sheet1

Date (raw) | Date (dd-mmm-yyyy)
12/17/2015 12:00:00 AM
12/16/2015 12:00:00 AM
12/15/2015 12:00:00 AM
12/14/2015 12:00:00 AM
12/13/2015 12:00:00 AM
2015-12-12 00:00:00
2015-11-12 00:00:00
2015-10-12 00:00:00
2015-09-12 00:00:00
Spreadsheet: 698655d1602096374-how-to-match-cells-that-have-numbers-and-text-and-arent-exact-matches-server-and-sn-comparison-old-servers-10-7-20
Sheet: Server & SN Match

Server Type | SN | Match | Server Name
COMPAQ COMP PROLIANT DL380P G8 | 00123456A | Yes | ABC1
COMPAQ COMP PROLIANT DL380P G8 | 00123456B | Yes | [NAME]
COMPAQ COMP PROLIANT DL380P G8 | 00123456C | No
COMPAQ COMP PROLIANT DL380P G8 | 00123456D | Yes | [NAME]
COMPAQ COMP PROLIANT DL380P G8 | 00123456E | No
COMPAQ COMP PROLIANT DL380P G8 | 00123456F | Yes | ABC6
COMPAQ COMP PROLIANT DL380P G8 | 00123456G | No
COMPAQ COMP PROLIANT DL380P G8 | 00123456H | Yes | ABC8
COMPAQ COMP PROLIANT DL380P G8 | 00123456I | Yes | ABC9
COMPAQ COMP PROLIANT DL380P G9 | 00123456J | Yes | ABC10
 |  | Want to compare Server & SN Match worksheet B2:B11 to Server & SN List B2:B11 and return matches. If yes put server name in next column. | If match=yes what's the server name from  Server & SN List worksheet column A2:A11
Spreadsheet: 748739d1632320073-work-out-daily-amount-to-target-31-day-figures
Sheet: 21st

 |  |  |  | TURNOVER |  |  |  |  | REVENUE
 | AREA 3 |  |  | Target | Needed Daily | Actual | [NAME] |  | Target | Needed Daily | Actual | [NAME] |  | [NAME]'s | ATV |  | [NAME] | SALT £ |  | TMC |  | BB+ |  | Errors
 | Asda - Aintree
 | Asda - Huyton
 | Asda - Hunts Cross
 | Asda - Horwich
 | Asda - Leigh
 | Asda - Burnley
 | Asda - Westbrook
 | Asda - Widnes
 | Asda - Bromborough
 | Asda - Accrington
 | Asda - Colne
 | Asda - Clayton Green
 | Asda - Runcorn
 | Asda - Blackburn
 | Asda - Walton
 | Asda - Blackpool
 | Asda - Wigan
 | Asda - Preston
Spreadsheet: 4274f7b4-7641-47c7-8561-b03fee21ba93
Sheet: Sheet1

Country Statistical Tables for North Africa
This contents sheet provides an explanation of each worksheet in the file.
Users are encouraged to read Food Security Assessment, 2005 (FSA), which discusses global food
security issues and estimates food gaps for 70 lower income countries. The report was published in
May 2006 and is available at:
http://www.ers.usda.gov/Publications/GFA17/
The report estimates the number of hungry people to evaluate the progress made toward the
World Food Summit goal of reducing the number of hungry people by half by 2015.
The progress in alleviating hunger between 1992-94, the base year for the World Food Summit
goals, and 2005, is reviewed.
The tables and charts provided in this file are not found in the report.
This file contains:
- 4 country statistical tables
The tab for each country table is identified by its 2-letter country code (the country code key is listed
below.) The table contains 9 years of historical data and estimates/projections for 2005, 2010, and 2015.
Grain production data are extracted from the Foreign Agriculture Service's Production, Supply and
Demand database of USDA as of October 2005. The 2005 figure of grain production is actual data.
Root production data are from FAOSTAT, available through 2004, then converted into grain equivalent.
Commercial grain imports are also from FAOSTAT and Food aid data are from World Food Program,
converted into grain equivalent based on calorie content. Aggregate availability of all food is a calculated
amount of all food available, converted into grain equivalent. For information on the definitions and method
of calculation of food gaps please see [NAME] in the FSA report.
Country code key:
DZ = Algeria
EG = Egypt
MA = Morcocco
TN = Tunisia
Spreadsheet: 875790d1722415113-getting-a-top3-using-small-based-on-multiple-criteria-and-ignoring-duplicates-map2
Sheet: Blad1

Code | Started | Due | Completed |  | Required result
ABC1 | 2024-01-01 00:00:00 |  | 2024-02-22 00:00:00 |  | ABC5
[NAME] | 2024-01-04 00:00:00 |  | 2024-02-22 00:00:00 |  | ABC6
ABC3 | 2024-01-04 00:00:00 |  | 2024-02-24 00:00:00 |  | ABC7
[NAME] | 2024-01-07 00:00:00 |  | 2024-03-08 00:00:00
ABC5 | 2024-01-13 00:00:00
ABC6 | 2024-01-19 00:00:00
ABC7 | 2024-01-19 00:00:00
ABC8 | 2024-01-20 00:00:00 |  | 2024-03-17 00:00:00
ABC9 | 2024-02-03 00:00:00 |  | 2024-03-16 00:00:00
ABC10 | 2024-02-17 00:00:00
ABC11
ABC12
Spreadsheet: 0b3bbd78-441a-4a68-bf3d-aa4d772f757f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7836 | 13031 | Marijke | Zeekant | NED | 199 | 00:17:10 | 00:01:31 | 01:32:33 | [NAME] | 00:48:16 | 1 | 02:41:19
Spreadsheet: 888105d1738507197-possible-to-change-highlight-cells-different-color-before-and-after-cf-with-3-colors_2
Sheet: Sheet1

 |  | 2025-01-01 00:00:00 | 2025-01-02 00:00:00 | 2025-01-03 00:00:00 | 2025-01-04 00:00:00 | 2025-01-05 00:00:00 | 2025-01-06 00:00:00 | 2025-01-07 00:00:00 | 2025-01-08 00:00:00 | 2025-01-09 00:00:00 | 2025-01-10 00:00:00 | 2025-01-11 00:00:00 | 2025-01-12 00:00:00 | 2025-01-13 00:00:00 | 2025-01-14 00:00:00 | 2025-01-15 00:00:00
2025-01-04 00:00:00 | 2025-01-10 00:00:00
2025-01-02 00:00:00 | 2025-01-12 00:00:00
2025-01-05 00:00:00 | 2025-01-07 00:00:00
2025-01-09 00:00:00 | 2025-01-12 00:00:00
Spreadsheet: d79466b7-95d6-42e2-88f1-b21dae9a62fb
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
HIAA | Test | HIAA | 5-Hydroxyindoleacetic Acid (5-HIAA), [NAME] | 5-Hydroxyindoleacetic Acid, U | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | [NAME], 24-hour graduated: 24Urine |  |  | 5 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 5 mL Collection Instructions:  1. Collect a 24-hour urine specimen. 2. Add 25 mL of 50% acetic acid as preservative at start of collection. Use 15 mL of 50% acetic acid for children <5 years old.  3. Patients should not eat avocados, bananas, butternuts, cantaloupe, dates, eggplant, grapefruit, hickory nuts, honeydew melon, kiwifruit, melons, nuts, pecans, pineapple, plantains, plums, tomatoes and tomato products, or walnuts which are high in serotonin for 48 hours before or during collection. 4. Certain medications, such as L-dopa, acetaminophen, salicylates, and cough syrup containing guaifenesin must also be avoided. Additional Information: 1. 24-hour volume is required. 2. See [NAME] in Special Instructions for multiple collections.   Urine Preservative Collection Options Ambient	No Refrigerated	Yes Frozen	Yes 6N HCl	Yes (30 mL) 50% Acetic Acid	Preferred Na2CO3	Yes (5 g) Toluene	Yes (30 mL) 6N HNO3	Yes (15 mL) Boric Acid	Yes (10 g) Thymol	Yes (10%) Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 3.5 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | Adults: < or =8 mg/24 hours | Monday through Friday; 11 a.m. | 2 days (not reported on Saturday or Sunday) | 4 days | 1 | 83497 |  |  |  |  | Rochester
HIAA | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 56 days
HIAA | Order Question | TM35 | Collection Duration |  | Plain Text
HIAA | Order Question | VL33 | [NAME] |  | Plain Text
HIAA | Result | 9248 | 5-Hydroxyindoleacetic Acid, U | 5-Hydroxyindoleacetic Acid, U | Numeric |  |  |  |  | mg/24 h |  |  |  |  |  |  |  |  |  | 1695-6 | 5-Hydroxyindoleacetate:MRat:24H:[NAME]:Qn:
HIAA | Result | TM35 | Collection Duration | Collection Duration | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13362-9 | Collection duration:Time:*:Urine:Qn:
HIAA | Result | VL33 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28009-9 | [NAME] volume:Vol:Pt:[NAME]:Qn:
Spreadsheet: 110203d1306938023-calculating-a-range-of-data-with-two-different-values-if-that-makes-sense-example
Sheet: Media's Capital Budget 2010-11

Description | Qty | Unit Price | Total | Priority
Area 1
xxxxx | 1 | 13900 |  | 1
xxxxx | 1 | 1950 |  | 1
xxxxx | 1 | 21050 |  | 1
xxxxx | 1 | 13200 |  | 1
xxxxx | 1 | 2500 |  | 2
xxxxx | 2 | 850 |  | 2
xxxxx | 1 | 140 |  | 2
xxxxx | 1 | 5434 |  | 2
xxxxx | 4 | 795 |  | 2
xxxxx | 1 | 250 |  | 2
xxxxx | 1 | 10000 |  | 2
SUB TOTAL
VAT @ 20%
TOTAL
Area 2
xxxxx | 10 | 4445 |  | 1
xxxxx | 10 | 943 |  | 1
xxxxx | 10 | 141 |  | 1
xxxxx | 10 | 31 |  | 1
xxxxx | 20 | 767 |  | 1
xxxxx | 30 | 79 |  | 1
xxxxx | 10 | 895 |  | 1
xxxxx | 10 | 1715.34 |  | 1
SUB TOTAL
VAT @ 20%
TOTAL
Area 3
xxxxx | 3 | 140 |  | 1
xxxxx | 10 | 175 |  | 1
xxxxx | 10 | 43 |  | 1
xxxxx | 35 | 469.5 |  | 1
xxxxx | 35 | 294.16 |  | 1
xxxxx | 5 | 2044.41 |  | 1
xxxxx | 2 | 1524.17 |  | 1
xxxxx | 1 | 413 |  | 1
xxxxx | 5 | 415 |  | 1
xxxxx | 5 | 289 |  | 1
xxxxx | 20 | 9.7 |  | 1
xxxxx | 10 | 304 |  | 1
xxxxx | 10 | 16 |  | 1
xxxxx | 10 | 17 |  | 1
xxxxx | 2 | 120 |  | 1
xxxxx | 1 | 155 |  | 1
xxxxx | 1 | 19.95 |  | 1
xxxxx | 3 | 417 |  | 2
xxxxx | 1 | 21 |  | 2
xxxxx | 1 | 53 |  | 2
xxxxx | 1 | 929.95 |  | 2
xxxxx | 2 | 45 |  | 2
xxxxx | 1 | 102.07 |  | 2
xxxxx | 1 | 45.91 |  | 2
xxxxx | 1 | 50.96 |  | 2
xxxxx | 1 | 81.6 |  | 2
xxxxx | 1 | 40.8 |  | 2
xxxxx | 1 | 20.38 |  | 2
xxxxx | 1 | 69.95 |  | 2
xxxxx | 2 | 99.95 |  | 2
xxxxx | 1 | 109.95 |  | 1
xxxxx | 2 | 54.95 |  | 2
xxxxx | 1 | 49.95 |  | 2
xxxxx | 1 | 49.95 |  | 2
xxxxx | 1 | 349.99 |  | 2
xxxxx | 10 | 19 |  | 2
SUB TOTAL
VAT @ 20%
TOTAL
Area 4
xxxxx | 10 | 850 |  | 1
xxxxx | 10 | 38 |  | 1
xxxxx | 10 | 89 |  | 1
xxxxx | 10 | 31.07 |  | 1
xxxxx | 10 | 376.05 |  | 1
xxxxx | 10 | 184.38 |  | 1
xxxxx | 10 | 34.4 |  | 1
xxxxx | 10 | 24.2 |  | 1
xxxxx | 10 | 3.24 |  | 1
xxxxx | 5 | 549.17 |  | 1
xxxxx | 5 | 20.83 |  | 1
xxxxx | 5 | 20.83 |  | 1
xxxxx | 5 | 29.17 |  | 1
xxxxx | 5 | 29.17 |  | 1
xxxxx | 20 | 343.2 |  | 2
xxxxx | 20 | 37.44 |  | 2
xxxxx | 20 | 123.252 |  | 2
xxxxx | 50 | 7.12 |  | 2
xxxxx | 20 | 18 |  | 2
xxxxx | 20 | 216.7085 |  | 2
xxxxx | 20 | 115.57 |  | 2
SUB TOTAL
VAT @ 20%
TOTAL
Area 5
xxxxx | 5 | 850 |  | 1
xxxxx | 5 | 38 |  | 1
xxxxx | 5 | 89 |  | 1
xxxxx | 5 | 31.07 |  | 1
xxxxx | 10 | 376.05 |  | 1
xxxxx | 5 | 24.2 |  | 1
xxxxx | 5 | 635.99 |  | 1
SUB TOTAL
VAT @ 20%
TOTAL
Area 6
xxxxx | 20 | 850 |  | 1
xxxxx | 20 | 38 |  | 1
xxxxx | 20 | 89 |  | 1
xxxxx | 20 | 31.07 |  | 1
SUB TOTAL
VAT @ 20%
TOTAL
 |  | TOTAL inc. VAT
 |  | Priority 1 - Total
 |  | Priority 2 - Total
Spreadsheet: 839877d1692276559-formula-to-sum-the-first-6-to-8-characters-of-the-text-test-worksheet-1-
Sheet: Reconcile 

References | Quantity (Physical)
Dell.285.SA.TT | 2
CZT.1321519.DD.900 | 2
FF.00032.00.55.TT.01 | 1
T33652.4SD.0000 | 1
References | Quantity (Physical) Using countIF
Dell.285.SA.TT
CZT.1321519.DD.900
FF.00032.00.55.TT.01
T33652.4SD.0000
Spreadsheet: 240115d1370208663-scan-a-row-for-text-return-row-and-column-header-info-rooms2
Sheet: Sheet4

Room A | [NAME] | 2013-05-01 00:00:00
Room B | [NAME] | 2013-05-04 00:00:00
Room D | [NAME] | 2013-05-05 00:00:00
Room C | [NAME] | 2013-05-02 00:00:00
Room A | [NAME] | 2013-05-04 00:00:00
Room E | [NAME] | 2013-05-06 00:00:00
Room B | George | 2013-05-01 00:00:00
Auditorm | George | 2013-05-05 00:00:00
Spreadsheet: 682016d1591878685-averageifs-with-or-averageifs-with-or
Sheet: COUNTIFS SUMIFS AVERAGEIFS

Type | Salary | Rating
Full Time | 60981 | 2
Full Time | 60915 | 1
Contract | 48536 | 1 |  | Full Time
Contract | 57711 | 3 |  | Part Time
Full Time | 115547 | 5 |  | Contract
Full Time | 69212 | 4 |  | Hourly
Full Time | 120198 | 2
Contract | 53818 | 5
Full Time | 113020 | 4
Full Time | 82341 | 4
Full Time | 98598 | 3
Part Time | 23175 | 1
Full Time | 61076 | 1
Full Time | 107968 | 2
Full Time | 102146 | 5
Part Time | 23005 | 3
Hourly | 26700 | 2
Part Time | 22710 | 5
Full Time | 69038 | 4
Hourly | 23082 | 5
Full Time | 70990 | 5
Part Time | 22658 | 4
Full Time | 102687 | 3
Full Time | 121213 | 5
Full Time | 74666 | 2
Full Time | 90032 | 1
Part Time | 21735 | 3
Full Time | 68870 | 5
Contract | 56571 | 4
Full Time | 104719 | 5
Full Time | 61443 | 5
Full Time | 115351 | 5
Full Time | 71321 | 2
Contract | 62399 | 5
Full Time | 96545 | 2
Full Time | 98833 | 2
Contract | 62349 | 5
Contract | 53227 | 4
Full Time | 88169 | 5
Full Time | 83157 | 3
Hourly | 35982 | 1
Full Time | 84121 | 4
Full Time | 73059 | 4
Contract | 57628 | 2
Full Time | 75259 | 1
Full Time | 104597 | 5
Contract | 62071 | 3
Contract | 59733 | 4
Part Time | 25745 | 2