tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 18b64b08-6226-4441-a7dc-d96be136f581
Sheet: Sheet1

Agent Name | License Number | County | Expires | Agent Address | Agent City | Agent State | Agent Zip | Salvage Dealer Name | Region
ALMANSORI,AHMED | 057A45822 | DALLAS | 2014-10-21 00:00:00 | 2440 W IRVING BLVD #190 | IRVING | TX | 75061 | TEXAS AUTO SERVICE | DALLAS
ARELLANO,JOHNNY MEZA | 221A44701 | TAYLOR | 2015-05-07 00:00:00 | 3023 CREST RIDGE DR | DALLAS | TX | 75228 | U S A  AUTO SALES | ABILENE
BOHANNON,TINA MARIE | 220A54754 | TARRANT | 2015-07-29 00:00:00 | 1121 CANTRELL SANSOM ROAD | FORT WORTH | TX | 76131 | TRUCKCENTER.COM | FORT WORTH
CARTER,[NAME] | 057E00465 | DALLAS | 2015-02-02 00:00:00 | 7321 ASHCREST | DALLAS | TX | 75249 | PICK N PULL AUTO DISMANTLERS | DALLAS
COX,STEVEN | 015A50571 | BEXAR | 2014-10-19 00:00:00 | 7439 OBBLIGATO LN | SAN ANTONIO | TX | 78266 | CAR QUICK | SAN ANTONIO
CRUZ,JORGE OSVALDO | 108A48874 | HIDALGO | 2015-02-24 00:00:00 | 6707 VALDIVIA ST | PHARR | TX | 78577 | CRUZ AUTO SALES | PHARR
HARLEY,DON WARD | 116B03088 | [NAME] | 2015-04-20 00:00:00 | 2244 HWY 69 S | GREENVILLE | TX | 75402 | WARDS AUTO PARTS & SALVAGE | DALLAS
HAYNES,PHIL D. | 188D47046 | POTTER | 2015-05-16 00:00:00 | [NAME] | [NAME] | TX | 79108 | HOWELL EQUIPMENT COMPANY | [NAME]
HOWELL,JACOB DUSTIN | 188C47046 | POTTER | 2015-05-06 00:00:00 | [NAME] | [NAME] | TX | 79108 | HOWELL EQUIPMENT COMPANY | [NAME]
[NAME] | 014A31007 | BELL | 2015-08-30 00:00:00 | 626 GILL DRIVE | ABILENE | TX | 79601 | ATC AUTO GROUP | WACO
JUAN MONTOYA | 123A51391 | JEFFERSON | 2015-03-15 00:00:00 | 3148 25TH ST | PORT ARTHUR | TX | 77642 | PORT ARTHUR AUTO MOTIVE | BEAUMONT
KING,[NAME] | 020A46271 | BRAZORIA | 2015-01-10 00:00:00 | 110 TANNER ST | BRAZORIA | TX | 77422 | M & M SALVAGE | HOUSTON
MCCRARY,LEE | 037B31910 | CHEROKEE | 2015-04-27 00:00:00 | 506 FRANKSTON ST | JACKSONVILLE | TX | 75766 | DAVES AUTOMOTIVE | LONGVIEW
MELIA,WALLACE G | 101A43502 | HARRIS | 2014-12-21 00:00:00 | 10011 NORTH LOOP EAST | HOUSTON | TX | 77029 | HOUSTON FREIGHTLINER,STERLING &WESTERN STAR | HOUSTON
MIRANDA,[NAME] | 101A48010 | HARRIS | 2014-09-19 00:00:00 | 1478 MUNGER | HOUSTON | TX | 77023 | JAM'S AUTO SALES | HOUSTON
NGUYEN,LAN T | 220A40380 | TARRANT | 2015-05-01 00:00:00 | 1105 COLORADO LN #[NAME] | ARLINGTON | TX | 76015 | LEES BODY AUTO REPAIR SALES INC | FORT WORTH
PEREZ,[NAME] | 101B41487 | HARRIS | 2014-09-30 00:00:00 | 13502 ROBBINS RD | CYPRESS | TX | 77429 | [NAME]'S CENTRO #2 | HOUSTON
PEREZ,MANUEL | 101A41487 | HARRIS | 2014-09-27 00:00:00 | 1411 GESSNER STE H | HOUSTON | TX | 77080 | [NAME]'S CENTRO #2 | HOUSTON
SEGOVIA,JESUS | 057B42330 | DALLAS | 2015-05-12 00:00:00 | 9810 BRIERHILL DR | DALLAS | TX | 75217 | FAMA AUTO SALES | DALLAS
TARCO,RICHARD VIRGILIO | 101A02536 | HARRIS | 2015-05-31 00:00:00 | 2635 ANNISTON DR | HOUSTON | TX | 77080 | V & R AUTO SALES | HOUSTON
[NAME],ADA LEYDA | 101A41942 | HARRIS | 2015-02-10 00:00:00 | 6310 SPRUCE FOREST | HOUSTON | TX | 77092 | MOLINA | HOUSTON
WARD,[NAME] | 116A03088 | [NAME] | 2015-04-04 00:00:00 | 2244 HWY 69 S | GREENVILLE | TX | 75402 | WARDS AUTO PARTS & SALVAGE | DALLAS
Spreadsheet: darrell_schoolcraft__7383__NNG LAMAR NOMNATION
Sheet: 01-(27)

 |  |  |  | Time/Date
 |  |  |  | Beginning Gas Day: | 2002-01-27 00:00:00 | Sunday only
 |  |  |  | Ending Gas Day: | 2002-01-27 00:00:00
 |  | [NAME] |  |  | 45000
 |  | Hour
 |  | Ending | [NAME] | Accumulated | Remaining | Daily Burn
 |  | CST |  |  |  | Rate
 |  | 10 | 1850
 |  |  | 1850
 |  |  | 1850
 |  |  | 1850
 |  |  | 1700
 |  |  | 1700
 |  |  | 1700
 |  |  | 1700
 |  |  | 1700
 |  |  | 1850
 |  |  | 1850
 |  |  | 1850
 |  |  | 1850
 |  |  | 1400
 |  |  | 1400
 |  | 1 | 1250
 |  | 2 | 1250
 |  |  | 1250
 |  |  | 1250
 |  |  | 1250
 |  |  | 1400
 |  |  | 3750
 |  |  | 3750
 |  |  | 3750
Spreadsheet: 145700d1331718123-how-to-cross-check-data-based-on-time-format-test3
Sheet: single double query

DriverName | CarNumber | StartHour | EndHour | Column1 | if F=B , and G between C&D , then copy A to H
Hugh | 203 | 06:43:00 | 08:49:00 |  | 1000 | 08:32:00
Roland | 1000 | 08:49:00 | 08:52:00 |  | 203 | 07:33:00
Estra | 2000 | 08:52:00 | 08:56:00 |  | 900 | 09:16:00
[NAME] | 900 | 09:15:00 | 09:19:00 |  | 208 | 07:35:00
Maxy | 5000 | 06:40:00 | 06:41:00 |  | 2069 | 07:36:00
Renon | 5000 | 07:40:00 | 07:40:00 |  | 5000 | 07:40:00
Dude | 6000 | 06:56:00 | 07:22:00 |  | 5000 | 07:40:00
[NAME] | 6001 | 07:22:00 | 07:32:00 |  | 981 | 07:41:00
[NAME] | 6002 | 07:33:00 | 07:57:00 |  | 6002 | 07:42:00
[NAME] | 6003 | 13:54:00 | 14:00:00 |  | 960 | 07:43:00
Spreadsheet: 482012d1474852400-new-empty-table-for-each-element-of-dropdown-list-city-example-button
Sheet: Sheet2

City 1
Criteria | 2012 | 2013 | 2014 | 2015 | 2016
Population | 1 | 1 | 1 | 1 | 1 | 1
GDP | 2 | 2 | 2 | 2 | 2 | 2
Life expectancy | 3 | 3 | 3 | 3 | 3 | 3
Spreadsheet: 48566d1247780594-indirect-mod-row-skipping-a-lot-of-rows-test-f-ms-annual-student-report-template-07-16-09-fs
Sheet: Intervention

Date | Log Entry Text | Follow-Up
Subtype
Sub-subtype
Action Status
Reporter
Level
Spreadsheet: 045741da-4d14-4f76-9917-1fad909b682b
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
FCHH | Test | FCHH | Chloral Hydrate (Noctec) | Chloral Hydrate (Noctec) | Gas Chromatography/Flame Ionization Detection (GC/FID) | 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 of  sodium heparin plasma refrigerated. Note:	1. Trough levels are most reproducible. 	2. Indicate plasma on request form. 	3. Label specimen appropriately (plasma).   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. Trough levels are most reproducible. 	2. Indicate serum on request form. 	3. Label specimen appropriately (serum). | 0.3 mL NOTE: Submission of the m | Specimens other than	Serum, plasma Anticoagulants other than	Plain red-top, sodium heparin, EDTA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Trichloroethanol  Reference Range:   2-12 ug/mL   Chloral Hydrate measured as trichloroethanol. Chloral Hydrate is rapidly converted to trichloroethanol.   Test Performed By: Medtox Laboratories, Inc. 402 W. County Road D St. Paul, MN 55112 | Monday through Sunday | 7 days | 8-10 days | 1 | 82491 |  |  |  |  | Medtox Laboratories, Inc
FCHH | [NAME] | VARIES | Varies |  |  |  | Refrigerated
FCHH | Result | Z1144 | Chloral Hydrate (Noctec) | Chloral Hydrate (Noctec) | Numeric |  |  |  |  | ug/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 692095d1598080923-how-to-copy-the-conditional-formatting-formula-book1
Sheet: Rating

By Member
Member | Vendor 1
Member 1 |  |  | Need a Conditional Formating formula which will higlight the Row 3 to 10 accoingly based on the Min & Max Result in Row 54 to 59 (i.e. Row 3 should be highligthed in Green color as MIN and Row 10 highligthed in Yellow color as MAX.
Member 2 |  |  | How to copy the Conditional Formating formula above which Row 11 should be highligthed in Green color as MIN and Row 18 highligthed in Yellow color as MAX.based on the Min & Max Result in Row 60 to 65
 |  |  |  |  |  | Have below error when trying to apply the formula
Member 3 |  | How to copy the Conditional Formating formula similar format from Member 1 in Row 3-10 & from Member 2 in Row 11-18 to Member 3 in Row 19-26 especially the unlock portion =54 at row 3, =B60 at row 4, =B66 at row 4, etc. | How to copy the Conditional Formating formula her and foe below as wells
Member 4 |  | How to continue copy the Conditional Formating formula similar format  to Member 1, 2 & 3 to Member 4 in Row 27 to 34
Member 5 |  | same as above
Member 6 |  | same as above
By [NAME]
Criteria | Vendor 1
1 | 0
 | 1
 | 2
 | 3
 | 4
 | 5
2 | 0
 | 1
 | 2
 | 3
 | 4
 | 5
3 | 0
 | 1
 | 2
 | 3
 | 4
 | 5
4 | 0
 | 1
 | 2
 | 3
 | 4
 | 5
5 | 0
 | 1
 | 2
 | 3
 | 4
 | 5
6 | 0
 | 1
 | 2
 | 3
 | 4
 | 5
7 | 0
 | 1
 | 2
 | 3
 | 4
 | 5
8 | 0
 | 1
 | 2
 | 3
 | 4
 | 5
Spreadsheet: 056a93bd-4af2-4f21-b263-2034eda08783
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | Figure 1.2.1 – Wine production in Veneto provinces per designation – Year 2006
 | Source: processing by [NAME] SISTAR on Istat data
 | Use of grape production in the Veneto - wine grape - wine-producing campaign 2005-2006
 |  | Belluno | Padova | Rovigo | Treviso | Venezia | [NAME] | [NAME]
 | VQPRD wine |  | 57755 |  | 410509 | 91520 | 1411340 | 310000
 | IGT wine | 380 | 486986 | 23800 | 1833228 | 505036 | 769000 | 650000
 | Table wine | 4500 | 26140 | 26870 | 223264 | 23500 | 150000 | 89285
 | Source: processing by [NAME] SISTAR on Istat data
Spreadsheet: 51343609-35dc-412c-b318-cd5d10343e9f
Sheet: Sheet1

Table 1--U.S. rice supply and use  1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Item | 2007/08 | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13 | 2013/14
 |  |  |  |  |  | 2/ | 2/
TOTAL RICE |  |  |  | Million acres
Area:
Planted | 2.761 | 2.995 | 3.135 | 3.636 | 2.689 | 2.699 | 2.611
Harvested | 2.748 | 2.976 | 3.103 | 3.615 | 2.617 | 2.678 | 2.59
 |  |  |  | Pounds per harvested acre
Yield | 7219 | 6846 | 7085 | 6725 | 7067 | 7449 | 7317
 |  |  |  | Million cwt
Beginning stocks | 39.315 | 29.492 | 30.419 | 36.499 | 48.467 | 41.07900000000001 | 34.05799999999999
Production | 198.388 | 203.733 | 219.85 | 243.104 | 184.941 | 199.479 | 189.5
Imports | 23.9 | 19.218 | 19.019 | 18.336 | 19.361 | 21.5 | 22.5
Total supply | 261.603 | 252.443 | 269.288 | 297.939 | 252.769 | 262.058 | 246.058
Food, industrial,
& residual 3/ | 123.152 | 123.77 | 120.012 | 133.191 | 106.77
Seed | 3.697 | 3.87 | 4.488 | 3.324 | 3.332
Total domestic use | 126.849 | 127.64 | 124.5 | 136.515 | 110.102 | 120 | 115
Exports | 105.262 | 94.384 | 108.304 | 112.959 | 101.588 | 108 | 98
Rough | 37.663 | 31.633 | 40.351 | 35.146 | 32.72 | 35 | 36
Milled 4/ | 67.599 | 62.751 | 67.953 | 77.813 | 68.868 | 73 | 62
Total use | 232.111 | 222.024 | 232.793 | 249.474 | 211.69 | 228 | 213
Ending stocks | 29.492 | 30.419 | 36.499 | 48.46700000000004 | 41.07900000000001 | 34.05799999999999 | 33.05799999999999
 |  |  |  | Percent
Stocks-to-use ratio | 12.70598980660115 | 13.70077108781033 | 15.67873604446869 | 19.42767582994622 | 19.40526241201758 | 14.93771929824561 | 15.52018779342723
 |  |  |  | $/cwt
Average farm |  |  |  |  |  | 14.80 to | 14.50 to
price 5/ | 12.8 | 16.8 | 14.4 | 12.7 | 14.5 | 15 | 15.5
 |  |  |  | Percent
Average
milling rate | 69.88 | 70.83 | 71.53 | 68.86 | 69.93 | 70 | 70.25
N/A = not available.  1/ August-July market year; rough equivalent.  2/ Projected.  3/ Residual includes unreported
use, processing losses, and estimating errors.  4/  Rough-rice equivalent.  5/ Market-year weighted average.
Source: World Agricultural Supply and Demand Estimates, WAOB, USDA.
Updated June 12, 2013.
Spreadsheet: 707420d1607261797-using-a-list-to-reduce-worksheets-midshires-master-ans
Sheet: BH

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: 141341d1329227171-use-3-icons-in-conditional-formatting-by-formula-cf-demo
Sheet: Sheet1

Not Started |  |  |  |  | Status
Cancelled |  |  |  |  | Cancelled
COMPLETED |  |  |  |  | Not Started
 |  |  |  |  | Just Started
 |  |  |  |  | In Progress
 |  |  |  |  | On Hold
 |  |  |  |  | COMPLETED
Spreadsheet: 465402d1465610326-find-similar-coordinate-pairs-in-a-2-column-list-match-tolerances
Sheet: Sheet1

1 | -5.63 | 48.77
2 | -12 | 49.18
3 | -40.35 | 51.02
4 | -18.46 | 49.6
5 | -15.13 | 49.38
6 | -33.33 | 50.57
7 | -38.1 | 58.55
8 | -31.29 | 51.5
9 | -32.45 | 52.57
10 | -32.77 | 50.53
11 | -39.54 | 59.58
12 | -28.87 | 50.28
13 | -5.69 | 48.87
14 | -5.55 | 48.57
Spreadsheet: 0322f2d5-9594-4723-af56-f658809eb337
Sheet: Sheet1

Alliant SB Orders as of September 30, 2012 | Unnamed: 1
In Obligated Dollars
Agency Name | Total Order
ARMY | 101567509.23
DEPARTMENT OF AGRICULTURE | 79408731.15999998
DEPARTMENT OF COMMERCE | 61420245.45
DEPARTMENT OF DEFENSE | 173897797.56
DEPARTMENT OF ENERGY | 173308340.43
DEPARTMENT OF HEALTH AND HUMAN SERVICES | 23089106.83
DEPARTMENT OF HOMELAND SECURITY | 41998325.48999999
DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT | 1816642.3
DEPARTMENT OF INTERIOR | 19712313.25
DEPARTMENT OF JUSTICE | 32422871.88
DEPARTMENT OF LABOR | 7743979.76
DEPARTMENT OF STATE | 65341325.53999999
DEPARTMENT OF THE AIR FORCE | 51424307.80999999
DEPARTMENT OF THE NAVY | 19493030.52
DEPARTMENT OF THE TREASURY | 1414366.85
DEPARTMENT OF TRANSPORTATION | 544041.65
DEPARTMENT OF VETERANS AFFAIRS | 35222656.04
ENVIRONMENTAL PROTECTION AGENCY | 10359461.2
EQUAL EMPLOYMENT OPPORTUNITY COMMISSION | 3084278.01
EXECUTIVE OFFICE OF THE PRESIDENT | 6602281.91
GENERAL SERVICES ADMINISTRATION | 34414509.03
GOVERNMENT AGENCY - NOT OTHERWISE SPECIFIED | 89465.21
INDEPENDENT U.S. GOVERNMENT OFFICES | 21170.18
NATIONAL AERONAUTICS AND SPACE ADMINISTRATION | 367750.38
SMALL BUSINESS ADMINISTRATION | 1839256.82
Grand Total | 946603764.4899998
Spreadsheet: 103190d1300983247-vlookup-based-on-date-example-1-
Sheet: Application Dates

 |  | 2011
 |  | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00
Project No. | Project Name
1 | Project1 | 21 | 18 | 21 | 20 | 21 | 20 | 21 | 21 | 20 | 21 | 20 | 18
2 | Project2 | 4 | 4 | 14 | 5 | 2 | 7 | 10 | 20 | 10 | 6 | 20 | 11
3 | Project3 | 11 | 2 | 11 | 21 | 13 | 20 | 7 | 27 | 23 | 1 | 7 | 16
4 | Project4 | 14 | 20 | 21 | 3 | 17 | 17 | 1 | 18 | 1 | 25 | 12 | 22
5 | Project5 | 5 | 2 | 8 | 5 | 13 | 27 | 7 | 7 | 11 | 2 | 8 | 18
6 | Project6 | 6 | 26 | 9 | 16 | 22 | 14 | 1 | 28 | 5 | 19 | 8 | 7
Spreadsheet: 67271d1267870459-if-dates-return-value-if-dates-return-value
Sheet: Sheet1

 | SCENARIO 1:  From start then every 90 days (or whatever is in cell c4) the amount will be posted and zero to the last date if not up to 90 days.
 | AMOUNT: | 34000
 | DAYS: | 90
 | [NAME] | START | FINISH | 2010-01-31 00:00:00 | 2010-02-28 00:00:00 | 2010-03-31 00:00:00 | 2010-04-30 00:00:00 | 2010-05-31 00:00:00 | 2010-06-30 00:00:00 | 2010-07-31 00:00:00 | 2010-08-31 00:00:00 | 2010-09-30 00:00:00 | 2010-10-31 00:00:00 | 2010-11-30 00:00:00 | 2010-12-31 00:00:00 | 2011-01-31 00:00:00 | 2011-02-28 00:00:00 | 2011-03-31 00:00:00 | 2011-04-30 00:00:00 | 2011-05-31 00:00:00 | 2011-06-30 00:00:00 | 2011-07-31 00:00:00 | 2011-08-31 00:00:00 | 2011-09-30 00:00:00 | 2011-10-31 00:00:00 | 2011-11-30 00:00:00 | 2011-12-31 00:00:00
 | International Ticket | 2010-05-01 00:00:00 | 2010-12-31 00:00:00 | 0 | 0 | 0 | 0 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Should be in row 7 |  |  | 0 | 0 | 0 | 0 | 34000 | 0 | 34000 | 0 | 0 | 34000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SCENARIO 2:  From start then every 90 days (or whatever is in cell c15) the amount will be posted and also if there is any balance to the last date even if it is not up to 90 days.
 | AMOUNT: | 34000
 | DAYS: | 90
 | [NAME] | START | FINISH | 2010-01-31 00:00:00 | 2010-02-28 00:00:00 | 2010-03-31 00:00:00 | 2010-04-30 00:00:00 | 2010-05-31 00:00:00 | 2010-06-30 00:00:00 | 2010-07-31 00:00:00 | 2010-08-31 00:00:00 | 2010-09-30 00:00:00 | 2010-10-31 00:00:00 | 2010-11-30 00:00:00 | 2010-12-31 00:00:00 | 2011-01-31 00:00:00 | 2011-02-28 00:00:00 | 2011-03-31 00:00:00 | 2011-04-30 00:00:00 | 2011-05-31 00:00:00 | 2011-06-30 00:00:00 | 2011-07-31 00:00:00 | 2011-08-31 00:00:00 | 2011-09-30 00:00:00 | 2011-10-31 00:00:00 | 2011-11-30 00:00:00 | 2011-12-31 00:00:00
 | International Ticket | 2010-05-01 00:00:00 | 2010-12-31 00:00:00 | 0 | 0 | 0 | 0 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Should be in row 18 |  |  | 0 | 0 | 0 | 0 | 34000 | 0 | 34000 | 0 | 0 | 34000 | 0 | 34000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 186447d1350044420-sum-within-a-date-range-sum-within-date-range
Sheet: Sheet1

 | Output Table |  |  |  |  | Transaction data
 |  | 1 Sept - 14 Sept | 15 Sept - 29 Sept | 30 Sept - 14 Oct |  | Date of Purchase | Item | Cost
 |  |  |  |  |  | 2012-09-01 00:00:00 | Green hat | 50
 | Green hat | Total cost of green hats during the above date range? |  |  |  | 2012-09-03 00:00:00 | Green hat | 37.8
 | Red hat |  |  |  |  | 2012-09-05 00:00:00 | Red hat | 61.05
 | Black hat |  |  |  |  | 2012-09-14 00:00:00 | Black hat | 2
 | Yellow hat |  |  |  |  | 2012-09-18 00:00:00 | Black hat | 50
 |  |  |  |  |  | 2012-09-21 00:00:00 | Black hat | 100
 |  |  |  |  |  | 2012-09-25 00:00:00 | Yellow hat | 781.68
 |  |  |  |  |  | 2012-10-01 00:00:00 | Green hat | 44.23
 |  |  |  |  |  | 2012-10-08 00:00:00 | Yellow hat | 77.88
 |  |  |  |  |  | 2012-10-09 00:00:00 | Green hat | 228.4
 |  |  |  |  |  | 2012-10-11 00:00:00 | Red hat | 30
Spreadsheet: 144994d1331243510-converting-database-of-transactions-to-a-time-series-betweendatesample
Sheet: database

Date | Item | InStock
2012-04-01 00:00:00 | Item1 | 1
2012-04-15 00:00:00 | Item2 | 1
2012-04-20 00:00:00 | Item1 | 0
2012-04-30 00:00:00 | Item3 | 1
2012-06-14 00:00:00 | Item4 | 1
2012-06-15 00:00:00 | Item2 | 0
Spreadsheet: 156566d1337347597-how-to-associate-multiple-cells-associated-with-one-cell-until-a-different-date-is-entered-051812-ex
Sheet: FRONT TEST

 | CHECK (√ ) ONE: |  |  |  |  |  | TRIP # |  |  | AMOUNT |  | OFFICE USE ONLY
IN STATE |  |  | √ |  |  |  | PER DIEM IN LIEU OF
 |  |  |  |  |  |  | [NAME]
OUT OF STATE |  |  |  |  |  |  | TAXABLE MEALS
OUT OF COUNTRY |  |  |  |  |  |  | NON-TAXABLE MEALS
 |  |  |  |  |  |  | LODGING
 |  |  |  |  |  |  | Travel - AUTO-PRIVATE
 |  |  |  |  |  |  | Travel - AUTO-RENTAL
 |  |  |  |  |  |  | Travel - PUBLIC CARRIER
 |  |  |  |  |  |  | OTHER: | Tip
 |  |  |  |  |  |  | SUB-TOTAL
 |  |  |  |  |  |  | LESS TRAVEL ADVANCE
 |  |  |  |  |  |  | NET REIMBURSEMENT
 |  |  |  |  |  |  | (Refund)
Spreadsheet: 845220d1696751291-formula-difficulties-for-aussie-timesheet-test-test-test-1-
Sheet: Sheet1

Friday |  |  | Saturday |  |  | Sunday
Time In | Time Out | HRS | Time In | Time Out | HRS | Time In | Time Out | HRS | Total | [NAME] | Toil/OT
07:30:00 | 14:00:00
10:00:00 | 17:30:00
Friday |  |  | Saturday |  |  | Sunday
Time In | Time Out | HRS | Time In | Time Out | HRS | Time In | Time Out | HRS | Total | [NAME] | Toil/OT
07:30:00 | 14:00:00
 |  |  |  |  |  | 07:00:00 | 14:00:00
10:00:00 | 17:30:00 |  |  |  |  | 07:30:00 | 19:29:00
Spreadsheet: 148845d1333575732-retrieve-data-from-another-worksheet-test
Sheet: Sheet2

Company Name | Payment
B | 100
C | 25
D | 50
E | 35
F | 60
H | 25
I | 40
J | 2552
K | 50
L | 254
M | 52
N | 52
O | 50
P | 50
Q | 5
R | 50
S | 45
T | 8
U | 5
V | 66
WW | 55
Spreadsheet: 126526d1319733649-variable-data-location-lookup-variable-data
Sheet: Data

 | 2011-10-21 00:00:00
 | 13 | 16 | 4 | 9 | 19 | 3 | 15 | 19 | 15 | 18 | 10
Daily Volume
Spreadsheet: 100954d1299161674-comparing-numbers-in-2-sheets-closed
Sheet: Sheet1

[NAME] | 01581317
[NAME] | 01581382
[NAME] | 01581409
[NAME] | 01563740
[NAME] | 01581938
[NAME] | 01581973
[NAME] | 01576831
[NAME] | 01577126
[NAME] | 01582246
[NAME] | 01582274
[NAME] | 01582573
[NAME] | 01579384
[NAME] | 01582696
[NAME] | 01579351
[NAME] | 01582871
[NAME] | 01583107
[NAME] | 01578985
[NAME] | 01583252
[NAME] | 01583294
[NAME] | 01583299
[NAME] | 01583659
[NAME] | 01583670
[NAME] | 01584449
[NAME] | 01584311
[NAME] | 01584578
[NAME] | 01584622
[NAME] | 01578823
[NAME] | 01572433
[NAME] | 01585386
[NAME] | 01585512
[NAME] | 01585558
[NAME] | 01585621
[NAME] | 01584002
[NAME] | 01587435
[NAME] | 01587473
[NAME] | 01587500
[NAME] | 01563101
[NAME] | 01584638
[NAME] | 01588048
[NAME] | 01588093
[NAME] | 01588105
[NAME] | 01588141
[NAME] | 01588150
[NAME] | 01571902
[NAME] | 01588239
[NAME] | 01588434
[NAME] | 01577420
[NAME] | 01579206
[NAME] | 01588561
[NAME] | 01589243
[NAME] | 01589390
[NAME] | 01583421
[NAME] | 01589554
[NAME] | 01589590
[NAME] | 01589640
[NAME] | 01590008
[NAME] | 01590075
[NAME] | 01590235
[NAME] | 01590863
[NAME] | 01590977
[NAME] | 01590979
[NAME] | 01587886
[NAME] | 01591228
Barb | 01581251
Barb | 01577014
Barb | 01578612
Barb | 01582044
Barb | 01582643
Barb | 01582941
Barb | 01580174
Barb | 01583530
Barb | 01580335
Barb | 01559729
Barb | 01570239
Barb | 01581252
Barb | 01571097
Barb | 01575220
Barb | 01580605
Barb | 01570001
Barb | 01571245
Barb | 01543276
Barb | 01585107
Barb | 01583054
Barb | 01586112
Barb | 01570139
Barb | 01587366
Barb | 01584735
Barb | 01585022
Barb | 01586208
Barb | 01584183
Barb | 01568700
Barb | 01581608
Barb | 01585389
Barb | 01584936
Barb | 01589235
Barb | 01584772
Barb | 01574930
Barb | 01591068
Barb | 01591075
Barb | 01590764
Barb | 01591994
Barb | 01592042
Barb | 01592929
Barb | 01593076
Barb | 01593424
Barb | 01592922
Barb | 01593317
Barb | 01594773
Barb | 01537519
Barb | 01578114
Barb | 01594925
Barb | 01590218
Barb | 01596774
Barb | 01596330
Barb | 01598367
Barb | 01591931
Barb | 01576753
Barb | 01603842
Barb | 01605856
Barb | 01595510
Barb | 01605854
Barb | 01603146
Barb | 01592978
Barb | 01606184
Barb | 01594601
Spreadsheet: 70a5ebe4-2519-4144-a2fd-b16f27b8315e
Sheet: Sheet1

Table 6--Wholesale corn milling product and byproduct prices, 5/14/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Mkt year and month 1/ | Corn meal, yellow,  Chicago, IL (dollars per cwt) |  | Corn meal, yellow,  New York, NY (dollars per cwt) |  | Corn starch,  Midwest 3/ (dollars per cwt) |  | Dextrose,  Midwest (cents per pound) |  | High-fructose corn syrup (42%),  Midwest (cents per pound)
 | 2010/11 | 2011/12 | 2010/11 | 2011/12 | 2010/11 | 2011/12 | 2010/11 | 2011/12 | 2010/11 | 2011/12
Sep | 20.339 | 27.9925 | 22.644 | 30.2975 | 15.43 | 23.25999999999999 | 31.2 | 30.85 | 17.375 | 21.375
Oct | 22.42 | 26.7825 | 24.725 | 29.0875 | 16.87 | 22.62999999999999 | 30.85 | 30.85 | 20.375 | 21.375
Nov | 22.435 | 26.8975 | 24.74 | 29.2025 | 18.28 | 20.04999999999999 | 30.85 | 30.85 | 21.375 | 21.375
Dec | 23.125 | 25.74 | 25.43 | 28.045 | 18.61 | 20.88999999999999 | 30.85 | 30.85 | 21.375 | 21.375
Jan | 24.0375 | 24.855 | 24.29 | 26.555 | 18.94 | 19.89999999999999 | 30.85 | 34.85 | 21.375 | 23.375
Feb | 26.94625 | 26.39833333333333 | 29.25125 | 30.37 | 20.23 |  | 30.85 | 33.85 | 21.375 | 23.375
Mar | 27.51 | 26.1675 | 29.815 | 27.92 | 21.48999999999999 |  | 30.85 | 35.85 | 21.375 | 23.375
Apr | 28.47125 | 25.5175 | 30.77625 | 27.545 | 21.31 |  | 30.85 | 34.85 | 21.375 | 23.375
May | 27.48833333333333 |  | 29.79333333333333 |  | 22.72 |  | 30.85 |  | 21.375
Jun | 27.465 |  | 29.77 |  | 22.56999999999999 |  | 30.85 |  | 21.375
Jul | 28.24 |  | 30.545 |  | 23.31999999999999 |  | 30.85 |  | 21.375
Aug | 28.775 |  | 31.08 |  | 22.14999999999999 |  | 30.85 |  | 21.375
Mkt year 2/ | 25.60436111111111 |  | 27.73831944444444 |  | 20.16 |  | 30.87916666666667 |  | 20.95833333333333
1/ September-August. Latest month is preliminary. 2/ Simple average of monthly prices for the marketing year. 3/ Bulk-industrial, unmodified. Source: Milling and Baking News, except for corn starch which is from private industry.
Date run: 5/11/2012