tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 117340d1312677717-copying-specific-cells-from-one-worksheet-to-another-mockworkbook
Sheet: Invoice

 |  |  |  |  |  |  | INVOICE
SOLD TO:
 |  |  |  |  | INVOICE NUMBER |  | 101
 |  |  |  |  | INVOICE DATE | Net 30 | 2011-08-06 00:00:00
 |  |  |  |  | TERMS | Ricky
 |  |  |  |  | SALES REP | Delivery
 |  |  |  |  | DELIVERY OR PICK UP |  | Delivery
 |  |  |  |  | DELIVERY DATE | COLL | 7/20/2011
SHIPPED TO: |  |  |  |  | PREPAID or COLLECT |  | Prepaid
Same
Sales Tax Rate: | 0.13
QUANTITY | [NAME] |  |  |  | PRICE PER UNIT | UNIT PRICE | AMOUNT
5 | DD 1029 |  |  | Karma | 20 | 40744 | 100
6 | DD 407-60 |  |  |  | 10 |  | 60
 |  |  |  |  | Sub Total | SUBTOTAL | 160
 |  |  |  |  | HST | TAX | 20.8
 |  |  |  |  |  | FREIGHT
 |  |  |  |  |  |  | 180.8
DIRECT ALL INQUIRIES TO: |  | MAKE ALL CHECKS PAYABLE TO: |  | MAKE ALL CHECKS PAYABLE TO: |  |  | PAY THIS
 |  |  |  | Diya Decor |  |  | AMOUNT
 |  |  |  | Attn: Accounts Receivable
 |  |  |  | 200 Edgeley Blvd Unit 4
 |  |  |  | Vaughan, Ontario L4K3Y8
THANK YOU FOR YOUR BUSINESS!
STEPS | 1 |  |  |  | 2 |  | 3
Spreadsheet: tracy_geaccone__40295__O&M Sch Tracy G
Sheet: O&M TracyG

DIRECT  O & M COSTS
2002 - 2003PLAN
TW Commercial
( $ In Millions)
 |  |  |  | 2000 Actuals |  | Restated 2001 Plan |  |  |  |  |  |  |  |  |  | 2001 2nd Current Estimate |  |  |  |  |  |  |  |  |  | 2002 Plan
 |  |  |  |  |  |  |  | Project |  |  |  |  |  |  |  |  |  | Project |  |  |  |  |  |  |  |  |  | Project
 |  |  |  |  |  |  |  | Specific |  | Overhead |  |  |  |  |  |  |  | Specific |  | Overhead |  |  |  |  |  |  |  | Specific |  | Overhead |  |  |  |  |  | Gross O&M
 |  |  |  | Net |  | Gross |  | Capital |  | Capital |  | Allocations |  | Net |  | Gross |  | Capital |  | Capital |  | Allocations |  | Net |  | Gross |  | Capital |  | Capital |  | Allocations |  | Net |  | % O(U)
Department |  |  |  | O & M |  | O & M |  | O & M |  | O & M |  | In/(Out) |  | O & M |  | O & M |  | O & M |  | O & M |  | In/(Out) |  | O & M |  | O & M |  | O & M |  | O & M |  | In/(Out) |  | O & M |  | 2000 Plan
TW Commercial |  |  |  | 2.5 |  | 3 |  |  |  | 0.1 |  | 0 |  |  |  | 3 |  | 0 |  | 0.1 |  | 0 |  |  |  |  |  | 0 |  | 0.1 |  | 0
Depreciation Expense |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.4
NOTE:   This schedule should include those costs that roll into O & M, according to the heirarchies you established in SAP, and payroll taxes.
Spreadsheet: 50073d1249476374-excel-2007-information-merge-from-multiple-sheets-automatic-end-of-month-report-year-09
Sheet: JANUARY 10

 | CONTRACTOR UTILIZED: |  | [NAME]
 | WEEK #1 |  | # of HOURS | # of STUDENTS | CLASS #
ENTER COURSE, CLASS # & # OF STUDENTS IN THE TOTALS BLOCK AT BOTTOM OF PAGE | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | LEAVE (H/V)
ENTER DATES AT WEEK # FIRST THEN ENTER HOURS FOR APPROPRIATE COURSE | WEEK #1 TOTAL |  | 0 | 0
 | WEEK #2 |  | # of HOURS | # of STUDENTS | CLASS #
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | LEAVE (H/V)
 | WEEK #2 TOTAL |  | 0 | 0
 | WEEK #3 |  | # of HOURS | # of STUDENTS | CLASS #
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | LEAVE (H/V)
 | WEEK #3 TOTAL |  | 0 | 0
 | WEEK #4 |  | # of HOURS | # of STUDENTS | CLASS #
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | LEAVE (H/V)
 | WEEK #4 TOTAL |  | 0 | 0
 | WEEK #5 |  | # of HOURS | # of STUDENTS | CLASS #
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | LEAVE (H/V)
 | WEEK #5 TOTAL |  | 0 | 0
 | WEEK #6 |  | # of HOURS | # of STUDENTS | CLASS #
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | LEAVE (H/V)
 | WEEK #6 TOTAL |  | 0 | 0
 |  |  | TOTALS |  | CLASS #
Enter Course Here------------> |  |  | 0 |  |  | <--------Enter Class # Here
Enter Second Course Here------------> |  |  | 0 |  |  | <--------Enter Second Class # Here
Enter Third  Course Here------------> |  |  | 0 |  |  | <--------Enter Third  Class # Here
 | LEAVE (H/V) |  | 0
 | GRAND TOTAL |  | 0 | 0 |  | Enter # of Students in # of Students Column Next to Appropriate Class
Spreadsheet: 779588d1651873419-extract-path-names-from-list-of-full-pathnames-sample
Sheet: Blad1

. | Pictures | Photos - 2 | PHOTOS DUMP | 44652 | IMG_3637.jpg
. | Pictures | Photos iPhone | Photos 2020-2021 | BPQC6806.jpg
. | Pictures | Image 6872.jpg
. | Library | Mail | V2 | xyz | [Gmail].mbox | All messages.mbox | abc | Data | 4 | 1 | Attachments | 14132 | 17 | image026.jpg
Spreadsheet: chris_germany__1976__Ponderosa Pine Est Imbalance0502
Sheet: Sheet1

Ponderosa Pine Energy Cleburne Plant
TXU Lone Star Pipeline
May, 2002
Estimated Usages*
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
RECEIVED | 34517 | 34650 | 34650 | 34650 | 34650 | 34650 | 0 | 0 | 0 | 0
DELIVERED | 46582.503 | 38779 | 39407 | 40571 | 43385 | 38488 | 0 | 0 | 0 | 0
DAILY IMBALANCE
MONTHLY IMBALANCE
ACCUM IMBALANCE
 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
RECEIVED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DELIVERED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DAILY IMBALANCE
MONTHLY IMBALANCE
ACCUM IMBALANCE
 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
RECEIVED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DELIVERED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DAILY IMBALANCE
MONTHLY IMBALANCE
ACCUM IMBALANCE
*These numbers are based on estimates and are subject to change
Spreadsheet: 164959d1340970623-adding-2-if-statements-together-sample-stock-movement
Sheet: 2806

Daily Trade Report
 | Nominal Price |  |  | Purchases |  |  |  |  | Sales |  |  |  |  | Movement
 | BUY | SELL |  | Weight | Value (£) | Per tonne | Profit/(Loss) |  | Weight | Value (£) | Per tonne | Profit/(Loss) |  | Quantity | Profit/(Loss)
PROD 1 | 1000 |  |  | 0.1 | 188
PROD 2 | 1000 |  |  | 0.05 | 55
PROD 3 | 300 |  |  | 0.285 | 84.9 |  |  |  | 13 | 4900
PROD 4 | 800 |  |  | 1 | 912
PROD 5 | 1500 |  |  | 0.05 | 18 |  |  |  | 0.1 | 150
PROD 6 | 1000 |  |  | 0.13 | 120.1
PROD 7 | 2000 |  |  | 0.051 | 112.2
PROD 8 | 1500 |  |  | 0.075 | 120 |  |  |  | 0.5 | 1000
PROD 9 | 2000 |  |  | 0.007 | 15
PROD 10 | 25 |  |  | 3 | 70 |  |  |  | 4 | 131
PROD 11 | 15 |  |  | 1 | 12
Spreadsheet: 771974d1646936694-sort-function-id-like-as-data-changes-in-table-the-sort-automatically-updates-golf-workings
Sheet: Stats

 | Player | Round 1 Score | Round 2 Score | Round 3 Score | Round 4 Score | Total | Revised | Position | Score | Points | Number of holes in 1
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | Talor Gooch
[NAME] | [NAME] Im
[NAME] | Mackenzie Hughes
[NAME] | [NAME]
Campbell | Jon Rahm
Campbell | Shane Lowry
Campbell | [NAME]
Campbell | [NAME]
Campbell | [NAME]
Campbell | [NAME]
Pearce | [NAME]
Pearce | [NAME]
Pearce | [NAME]
Pearce | [NAME]
Pearce | [NAME]
Pearce | [NAME]
Spreadsheet: 770325d1645992312-indirect-list-help-excelhelp
Sheet: Week 2

 |  |  |  | Week 2
 |  |  |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 |  |  | [NAME] |  |  |  |  |  | Day Off
 |  |  | [NAME] |  |  |  |  | Day Off
 |  |  | [NAME] |  |  |  | Day Off
 |  |  | Helen |  |  | Day Off
 |  |  | Emily |  | Day Off
 |  |  | [NAME] | Day Off
 |  |  | [NAME] |  |  |  |  |  | Day Off
 |  |  | [NAME] |  |  |  |  | Day Off
 |  |  | [NAME] |  |  |  | Day Off
 |  |  | Trevor |  |  | Day Off
Spreadsheet: 58a4f1d3-c1ab-47f1-b014-f349961473be
Sheet: Sheet1

The Ohio Department of Alcohol and Drug Addiction Services | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Equipment/Furniture/Computer Software/Hardware Itemization Form
Please list each item separately.  [NAME] as many forms as needed.
Date: |  |  |  | Grant Number:
Agency Name:
Program Title:
Name of Person Completing This Form:
Title: |  |  |  | Phone Number:
Item Description:
Make: |  |  |  | Model Number:
Serial Number: |  |  |  | Asset ID Number:
Date Acquired: |  |  |  | Purchase Price:
Funding Source: |  | State |  | Federal
Item Description:
Make: |  |  |  | Model Number:
Serial Number: |  |  |  | Asset ID Number:
Date Acquired: |  |  |  | Purchase Price:
Funding Source: |  | State |  | Federal
Item Description:
Make: |  |  |  | Model Number:
Serial Number: |  |  |  | Asset ID Number:
Date Acquired: |  |  |  | Purchase Price:
Funding Source: |  | State |  | Federal
Item Description:
Make: |  |  |  | Model Number:
Serial Number: |  |  |  | Asset ID Number:
Date Acquired: |  |  |  | Purchase Price:
Funding Source: |  | State |  | Federal
Spreadsheet: 47870d1247041222-calender-table-lookup-query-test-query
Sheet: display

Calender view of buying blocks
The table includes the 'Review' (if given) and the 'Buying trip' (if there is no 'Review') dates for each department.
The sequence of stages in the buying process are as follows;
1-Review
2-Buying trips
3-Compile range
4-Approve range
5-Place & order
Company | Department | Category name | Season_Name | January | February | March | April | May | June | July | August | September | October | November | December
Ajax | Boys/Men | Apparel | Summer T1 |  |  |  |  |  |  |  | 1-Review
[NAME] | General | Apparel | Christmas |  |  |  |  |  |  | 1-Review
Bones | Apparel- Men | Apparel | Spring |  |  |  |  |  |  |  |  |  |  |  | 2-Buying trips
Bones | Apparel- Men | Apparel | Summer
Bones | Apparel- Men | Apparel | Winter
Bones Home store | Apparel | Apparel | Spring
Bones Home store | Apparel | Apparel | High Summer
Spreadsheet: 846215d1697491154-convert-formula-to-power-query-example
Sheet: Sheet1

XX DI | Type | [NAME]
104716 | 00014857
104716 | 00016502
104716 | 00011880
104723
104723 | 00011905
104729 | 00004088
104745 | 00011889
104802 | 00015879
104804 | 00011909
104804 | 00008210
105370 | 00013536
105370
106534 | 00012356
106534
111338 | 00015861
111338
137132
Spreadsheet: andy_zipper__714__Asian Options
Sheet: Pricing & Hedging

Pricing and Hedging of Asian Options
 | The volatility of an Asian option is lower than that of the underlying prices used in the calculation of the average.  Hence an Asian
option at inception is similar to a European option with a lower volatility.  Therefore an Asian option will be less expensive than the
corresponding European options, since premiums increase with increasing volatility.  In addition to the lower premiums, another advantage of
Asian options is that their payoffs (as defined in the previous table) is less sensitive to any extreme market conditions that may prevail on the
expiration day (due to random shocks or outright manipulation).
 | An important question asked by a potential client may be how to price such exotic options contracts and also, in the case of EPMI,
how to hedge them. Asian options can't be priced using the Black-Scholes formula since an average of prices will not be lognormally distributed
even though the individual components prices are.  To price any type of exotic option, one should
 | * First attempt to replicate the exotic option with a package of vanilla options.  If this is possible, then each component option
should be priced individually, and the sum of all the long and short positions should give the desired exotic option price.
 | *  If the replication approach doesn't work, in some cases one may find an analytical solution that's comparable to the Black-Scholes
formula.
 | *  If an analytical solution can't be found, one may be able to find an approximation method that gives "acceptable" pricing accuracy.
 | *  If none of the above works, then it's necessary to use some type of numerical method.  The numerical methods used for option
valuation fall into 3 categories:  [NAME] simulation methods; tree (binomial or multinomial) methods; and finite-difference or numerical
integration methods.
 | Asian options are preferred products because they're easier to hedge.  Such options with long averaging periods don't have the high
gamma risk that ATM European options may have near expiry.  After the Asian option enters its averaging period and the average begins to
"set", the gamma risk of the option decreases and approaches zero near the end of averaging for options with reasonably long averaging periods.
However, if the averaging period is only 2 or 3 days, the gamma may still be sizeable at expiration.
 | The options trading desk has at its disposal two software libraries (Exotica and Financial Engineering Associates (FEA), Inc.)
which contain models for the pricing of various types of exotic options - including  Asian Options
Spreadsheet: phillip_m_love__30149__9908_OA
Sheet: WE-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  WEST
 |  |  | Total |  | Reclasses |  | August |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -25002 | -35828.53 | 0 | 0
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 166.79 | -8614 | -33015.5 | 0 | 0
7 |  | Liquidations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 92 | 307.92 | 0 | 0
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33524 | 77541 | 0 | 0
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  | 0
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 767041d1644253252-what-would-cause-excel-to-pause-its-calcs-when-it-is-set-to-automatic-livecards
Sheet: Padres

Hitters |  |  | Pitchers
UIG | NAME |  | UIG | NAME
Spreadsheet: 831538d1685705968-formular-to-call-data-from-another-sheet-5-and-6-ask
Sheet: UFAULU KIMASOMO

2. (a) Matokeo kimasomo: ( [NAME] wa shule)
(i) Kiswahili
SHULE | Jinsi | Waliofanya | [NAME] |  |  |  |  |  |  |  |  |  | NAFASI KIMKOA
 |  |  | A | B | C | A-C | % ya ufaulu | D | E | D-E | % [NAME] | GPA
 | Wav
 | Was
 | Jml
(ii) Kiingereza
SHULE | Jinsi | Waliofanya | [NAME] |  |  |  |  |  |  |  |  |  | NAFASI KIMKOA
 |  |  | A | B | C | A-C | % ya ufaulu | D | E | D-E | % [NAME] | GPA
 | Wav
 | Was
 | Jml
(iii) [NAME]
SHULE | Jinsi | Waliofanya | [NAME] |  |  |  |  |  |  |  |  |  | NAFASI KIMKOA
 |  |  | A | B | C | A-C | % ya ufaulu | D | E | D-E | % [NAME] | GPA
 | Wav
 | Was
 | Jml
(iv)  Hisabati
SHULE | Jinsi | Waliofanya | [NAME] |  |  |  |  |  |  |  |  |  | NAFASI KIMKOA
 |  |  | A | B | C | A-C | % ya ufaulu | D | E | D-E | % [NAME] | GPA
 | Wav
 | Was
 | Jml
(v)  Sayansi
SHULE | Jinsi | Waliofanya | [NAME] |  |  |  |  |  |  |  |  |  | NAFASI KIMKOA
 |  |  | A | B | C | A-C | % ya ufaulu | D | E | D-E | % [NAME] | GPA
 | Wav
 | Was
 | Jml
(vi)  URAIA NA MAADILI
SHULE | Jinsi | Waliofanya | [NAME] |  |  |  |  |  |  |  |  |  | NAFASI KIMKOA
 |  |  | A | B | C | A-C | % ya ufaulu | D | E | D-E | % [NAME] | GPA
 | Wav
 | Was
 | Jml
(vii)  [NAME]
SHULE | Jinsi | Waliofanya | [NAME] |  |  |  |  |  |  |  |  |  | NAFASI KIMKOA
 |  |  | A | B | C | A-C | % ya ufaulu | D | E | D-E | % [NAME] | GPA
 | Wav
 | Was
 | Jml
2 (b)  [NAME])
SHULE | Jinsi | Waliofanya | [NAME] |  |  |  |  |  |  |  |  |  | NAFASI KIMKOA
 |  |  | A | B | C | (A-C) | % ya ufaulu | D | E | (D-E) | % [NAME] | GPA
 | Wav
 | Was
 | Jml
Spreadsheet: 94884d1294656730-help-needed-agent-stats-tracker-teamstats
Sheet: KR

 |  | [NAME] | Packs Out | Collections | Packs Back | Col % 2 PB | FMP Out | FMP In | Calls Taken | Calls Out | Attendence
 | 2011-01-17 00:00:00 |  |  |  |  | 1
 | 2011-01-18 00:00:00 | 7.5 | 7 | 5 | 4 | 0.8 | 282
 | 2011-01-19 00:00:00 | 7.5 | 7 | 5 | 4 | 0.8 | 1000
 | 2011-01-20 00:00:00 | 7.5 | 7 | 4 | 4 | 1 | 664
 | 2011-01-21 00:00:00 | 7.5 | 5 | 3 | 3 | 1 | 995
 | Weekly Total | 37.5 | 33 | 21 | 19 | 0.9047619047619048 | 3391 | 0 | 0 | 0 | 0
 | 2011-01-24 00:00:00 |  | 7 | 4 | 4 | 1 | 450
 | 2011-01-25 00:00:00 |  | 7 | 5 | 4 | 0.8 | 282
 | 2011-01-26 00:00:00 |  | 7 | 5 | 4 | 0.8 | 1000
 | 2011-01-27 00:00:00 |  | 7 | 4 | 4 | 1 | 664
 | 2011-01-28 00:00:00 |  | 5 | 3 | 3 | 1 | 995
 | Weekly Total |  | 33 | 21 | 19 | 0.9047619047619048 | 3391 | 0 | 0 |  | 0
 | 2011-01-31 00:00:00 |  | 7 | 4 | 4 | 1 | 450
 | 2011-02-01 00:00:00 |  | 7 | 5 | 4 | 0.8 | 282
 | 2011-02-02 00:00:00 |  | 7 | 5 | 4 | 0.8 | 1000
 | 2011-02-03 00:00:00 |  | 7 | 4 | 4 | 1 | 664
 | 2011-02-04 00:00:00 |  | 5 | 3 | 3 | 1 | 995
 | Weekly Total |  | 33 | 21 | 19 | 0.9047619047619048 | 3391 | 0 | 0 |  | 0
 | 2011-02-07 00:00:00 |  | 7 | 4 | 4 | 1 | 450
 | 2011-02-08 00:00:00 |  | 7 | 5 | 4 | 0.8 | 282
 | 2011-02-09 00:00:00 |  | 7 | 5 | 4 | 0.8 | 1000
 | 2011-02-10 00:00:00 |  | 7 | 4 | 4 | 1 | 664
 | 2011-02-11 00:00:00 |  | 5 | 3 | 3 | 1 | 995
 | Weekly Total |  | 33 | 21 | 19 | 0.9047619047619048 | 3391 | 0 | 0 |  | 0
 | 2011-02-14 00:00:00 |  | 5 | 4 | 4 | 1
 | 2011-02-15 00:00:00 |  | 7 | 5 | 4 | 0.8
 | Weekly Total |  | 12 | 9 | 8 | 0.8888888888888888 | 0 | 0 | 0 |  | 0
 | Monthly Total |  | 144 | 93 | 84 | 0.9032258064516129 | 13564 | 0 | 0 |  | 0
Spreadsheet: bf175d3a-624d-4e00-9d5c-37283136d6ae
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: Manufacturing and Trade Inventories and Sales
 |  | Total Business: U.S. Total
 |  | Seasonally Adjusted Sales - Monthly [Millions of Dollars]
 |  | Period: 1992 to 2012
 |  | Data Extracted on: November 23, 2014 (8:26 pm)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1992 | 517614 | 520336 | 530741 | 533340 | 536747 | 541503 | 545225 | 541365 | 546740 | 546043 | 550307 | 552172
1993 | 558834 | 558337 | 554961 | 560916 | 568507 | 566310 | 566323 | 566653 | 571344 | 577026 | 577704 | 577117
1994 | 584321 | 588458 | 595183 | 596712 | 600178 | 605075 | 610294 | 619481 | 619861 | 628011 | 631771 | 642350
1995 | 644674 | 645296 | 641155 | 649552 | 647749 | 654826 | 653413 | 657875 | 664747 | 662167 | 665467 | 678386
1996 | 660416 | 659670 | 676135 | 677539 | 684017 | 688424 | 687282 | 689695 | 695677 | 695111 | 703144 | 700539
1997 | 703741 | 717658 | 717888 | 717917 | 714803 | 722073 | 728507 | 727347 | 732154 | 730046 | 737107 | 734570
1998 | 731902 | 739913 | 741249 | 740484 | 742328 | 736629 | 733547 | 738185 | 743323 | 750040 | 752300 | 756662
1999 | 757167 | 765364 | 765422 | 769499 | 780950 | 782123 | 786124 | 795697 | 796769 | 804506 | 809750 | 817607
2000 | 825940 | 816239 | 830837 | 833913 | 829648 | 839229 | 834150 | 830038 | 844708 | 838555 | 834374 | 841045
2001 | 834602 | 836791 | 824054 | 818648 | 828077 | 814906 | 812190 | 817391 | 802978 | 816093 | 807872 | 805961
2002 | 805539 | 808017 | 808071 | 822157 | 821667 | 824729 | 826608 | 835012 | 831492 | 831209 | 836692 | 829942
2003 | 841162 | 840995 | 850396 | 835465 | 836984 | 848071 | 857956 | 858281 | 865661 | 868968 | 873672 | 875893
2004 | 876774 | 885384 | 911496 | 906367 | 915027 | 914775 | 919179 | 929072 | 936521 | 948128 | 956134 | 966253
2005 | 972739 | 977581 | 977278 | 993824 | 986449 | 998292 | 1004490 | 1014711 | 1026270 | 1033752 | 1034102 | 1044627
2006 | 1057311 | 1055634 | 1059915 | 1058680 | 1071620 | 1074917 | 1073199 | 1085589 | 1066053 | 1062057 | 1069962 | 1093605
2007 | 1078707 | 1094023 | 1106380 | 1112146 | 1127076 | 1124383 | 1125519 | 1132440 | 1138506 | 1148428 | 1170950 | 1162637
2008 | 1177608 | 1168833 | 1170322 | 1193234 | 1201617 | 1220316 | 1217473 | 1192922 | 1158888 | 1104673 | 1030729 | 991065
2009 | 971570 | 976960 | 950466 | 947375 | 953856 | 971132 | 976839 | 992587 | 992432 | 1000291 | 1018923 | 1027745
2010 | 1034623 | 1037279 | 1057412 | 1068631 | 1063471 | 1063027 | 1074088 | 1081294 | 1090629 | 1105169 | 1117238 | 1131658
2011 | 1156243 | 1155350 | 1185237 | 1188287 | 1184831 | 1194491 | 1201266 | 1207271 | 1207264 | 1215797 | 1214318 | 1222664
2012 | 1232155 | 1241348 | 1248239 | 1250068 | 1246181 | 1226879 | 1235500 | 1244628 | 1263908 | 1257934 | 1267272 | 1270202
Spreadsheet: 36193d1233956703-returning-multiple-rows-based-on-date-range-sample
Sheet: Expected Results

Barn # | 1
From | 2008-09-26 00:00:00
To | 2008-10-02 00:00:00
Results based on Barn # and Date Range
Date | Customer | Barn # | Invoice # | Vendor Count | Customer Count | 100% Deductions | Partial Deductions
2008-09-26 00:00:00 | Jurassic | 1 | TS279 | 531 | 530 | 4 | 4.75
2008-09-29 00:00:00 | Jurassic | 1 | TS280 | 551 | 551 | 12 | 5
2008-09-30 00:00:00 | Jurassic | 1 | [NAME] | 548 | 548 | 1 | 6
2008-10-01 00:00:00 | Jurassic | 1 | TS282 | 549 | 555 | 7 | 4.25
2008-10-02 00:00:00 | Jurassic | 1 | TS283 | 550 | 552 | 4 | 5.5