tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 847582d1698434054-how-to-add-the-content-of-cell-to-the-next-empty-cell-if-cell-contains-a-specifc-string-example-for-excel-forum-jean_sibelius-
Sheet: Sheet1

Current dataset about 900 rows => | Up to 90 columns => |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 2 |  | 3
 | [EN] CLAIMS 1. An end-effector for handling a substrate, comprising: XXX | 2. The end-effector of claim 1, [NAME] | 3. The end-effector of claim 1 or 2, [NAME] | 4. The end-effector of claim 3, [NAME] | 5. The end-effector of claims 3 or 4, [NAME] | 6. The end-effector of claims 3 to 5, [NAME] | 7. The end-effector of any of the previous claims, [NAME] | 8. The end-effector of any of the previous claims, [NAME] | 9. The end effector of any of the previous claims, [NAME] | 10. The end-effector of any of the previous claims, [NAME] | 11. The end-effector of claim 10, [NAME] | 12. The end-effector of claim 11, XXX | 13. The end-effector of one of the previous claims, the XXX | 14. An apparatus comprising the end-effector according to one of claims 1 to 13. | 15. A method of using an end-effector for handling a substrate, XXX | 16. The method of claim 15, [NAME] | 17. The method of claim 15 or 16, [NAME] | 18. The method of one of claims 15 to 17, [NAME] | 19. The method of one of claims 15 to 18, comprising XXX
 | [EN] 1. A method for ordering and/or selection [NAME] | 2. A method as claimed in claim 1, [NAME] | 3. A method as claimed in claim 1 or 2, [NAME] | 4. A method as claimed in any preceding claim, [NAME] | 5. A method as claimed in any preceding claim, [NAME] | 6. A method as claimed in any preceding claim, [NAME] | 7. A method as claimed in any preceding claim, [NAME] | 8. A method as claimed in claim 7, [NAME] | 9. A method as claimed in any preceding claim, [NAME] | 10. A method as claimed in any preceding claim, [NAME] | 11. A method as claimed in any preceding claim, [NAME] | 12. A method as claimed in claim 11, [NAME] | 13. A method as claimed in any preceding claim, comprising XXX | 14. A method as claimed in any preceding claim, [NAME] | 15. An apparatus configured to XXX to perform the method of any of claims 1 to 14.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Anticipated Strings
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | An end-effector
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | An apparatus
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A method
 |  | How to add the content of cell to the next empty cell if cell contains a specifc string? (excelforum.com)
Spreadsheet: 300903d1393601152-expanding-a-data-set-in-one-column-by-inserting-a-data-set-from-another-column-index-match-answer-2-same
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Look at the green formulas
 |  |  |  |  |  |  |  |  |  |  | After putting them in
 |  |  |  |  |  |  |  |  |  |  | Sort data set 2 by Number or Letter. |  |  |  |  |  | Look at orange cell formula.
 |  |  |  |  |  |  | Data Set 1 |  |  |  |  | Data Set 2 |  |  |  |  |  | Desired Result
 |  |  |  |  |  |  |  |  |  |  |  | J | 9 |  |  |  |  | A | 1
 |  |  |  |  |  |  |  |  |  |  |  | J | 7 |  |  |  |  | A | 2
 |  |  |  |  |  |  |  |  |  |  |  | A | 1 |  |  |  |  | A | 3
 |  |  |  |  |  |  |  |  |  |  |  | A | 2 |  |  |  |  | B | 2
 |  |  |  |  |  |  | 123 | A |  |  |  | A | 3 |  |  |  |  | B | 7
 |  |  |  |  |  |  | 123 | B |  |  |  | B | 2 |  |  |  |  | B | 4
 |  |  |  |  |  |  | 124 | F |  |  |  | B | 7 |  |  |  |  | B | 5
 |  |  |  |  |  |  | 124 | J |  |  |  | B | 4 |  |  |  |  | F | 7
 |  |  |  |  |  |  |  |  |  |  |  | B | 5 |  |  |  |  | F | 4
 |  |  |  |  |  |  |  |  |  |  |  | F | 7 |  |  |  |  | F | 5
 |  |  |  |  |  |  |  |  |  |  |  | F | 4 |  |  |  |  | J | 9
 |  |  |  |  |  |  |  |  |  |  |  | F | 5 |  |  |  |  | J | 7
 |  |  |  |  |  |  |  |  |  |  |  | Help needed
Spreadsheet: debra_perlingiere__8421__Interconn Resources Omnibus
Sheet: ANEWSWP2

CONFIRMATION CREDIT INFORMATION SHEET: Deal -TAGG# VZ7721.1
 |  | ATTORNEY: | [NAME]
DATE: | 2001-09-04 00:00:00 | DEAL MAKER:
COUNTERPARTY: | Interconn Resources, Inc. | CONTACT:
ADDRESS: |  | TITLE:
 |  | PHONE:
 |  | FAX:
Incorporation State |  | S&P Rating | N/A
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING)
LIMIT $ MILLIONS
Incorporation State
ELEGIBLE SWAP PARTICIPANT
Counterparty | N/A | N/A
Guarantor
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and
Moody's ratings |  | $10MM
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X | X
Cash | - | -
Treasuries/Maturity limit
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING
Delivery Amount | 250000 | 250000
Return Amount | 250000 | 250000
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change |  | X
-Below = S&P/Moody's |  | BBB-
Financial Covenants
-Funded Debt to Worth
-Minimum Net Worth
-EBITDA/Interest Expense
-Funded Debt / EBITDA
Non-Specific | X
-Unilateral | X
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt
-Counterparty ($[NAME]) | $1MM
-Guarantor ($[NAME]) |  | $100MM
Change in ownership
SPECIFIED ENTITY
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER COMMENTS:
**Counterparty will receive a zero threshold and no outgoing Enron Gty will be issued.
Trade Date 8/29/01.
GLOBAL CREDIT:  Please complete the attached form below if the following conditions exist:
A)  No previous guidance limit exists or .....
B)  The proposed contractual limits exceed the existing guidance limits.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x6-6002
Spreadsheet: michelle_lokay__26621__imbalsumm0102
Sheet: KN_Westar

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 8289 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
[NAME] | 500168 | Westar Ward
 | Scheduled | Measured
1 | 38264 | 38260
2 | 40528 | 41288
3 | 55919 | 52759
4 | 55926 | 52856
5 | 55221 | 55727
6 | 54884 | 57962
7 | 66274 | 56463
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
index
2001-01-31 00:00:00 |  |  | 517990.98
2001-02-07 00:00:00
Spreadsheet: 789474d1659109396-multiple-cell-references-if-two-equal-zero-excel-sample-sheet-mb-data-1-
Sheet: 26

 |  |  |  |  |  |  | Date
Dept 1
Ingredient | Volume | Fat | [NAME] | TS
Whey Cream
Organic Skim Milk | 0 | 0 | 0 | 0
Organic Milk | 0 | 0 | 0 | 0
Dept 2
Ingredient | Volume | Fat | [NAME] | TS
Sweet Cream
 | 0
 | 0
 | 0 | 0 | 0 | 0
Spreadsheet: 09e6a2e2-2356-4f26-b5a7-d165817acf12
Sheet: ACF Regs

Team | [NAME] | Set | PPG | PPB | 15PG
Bellarmine | Texas ACF Regionals | [NAME] | 361.8 | 19.56 | n/a
Centennial | Texas ACF Regionals | [NAME] | 267.9 | 15.83 | n/a
Chattahoochee (GA) | Texas ACF Regionals | [NAME] | 147.1 | 11.76 | n/a
DCC | Texas ACF Regionals | [NAME] | 218.9 | 14.62 | n/a
Dorman | Texas ACF Regionals | [NAME] | 201.5 | 15.22 | n/a
GDS | Texas ACF Regionals | [NAME] | 185 | 14.92 | n/a
[NAME] | Texas ACF Regionals | [NAME] | 310.7 | 17.65 | n/a
Kealing | Texas ACF Regionals | [NAME] | 112.5 | 12.44 | n/a
LASA A | Texas ACF Regionals | [NAME] | 212.9 | 15.98 | n/a
LASA B | Texas ACF Regionals | [NAME] | 160.7 | 12.98 | n/a
Loyola | Texas ACF Regionals | [NAME] | 222.9 | 15.42 | n/a
Seven Lakes | Texas ACF Regionals | [NAME] | 292.1 | 17.72 | n/a
SJS | Texas ACF Regionals | [NAME] | 125.7 | 11.21 | n/a
SJS B | Texas ACF Regionals | [NAME] | 58.8 | 10.4 | n/a
Spreadsheet: 215259d1361316460-if-function-issue-picture-check
Sheet: Sheet1

AccountNumber | LnameV | NameCombinedV | FNameV | Owneraddress | Ownercitystate_V | PostalCodeNew | PropertyAddress | Check
2060582 | Francies R | [NAME]  Francies R | [NAME] | PO BOX 1455 | EULESS TX | 76039 | 709 SIMMONS DR
3227502 | [NAME] | Moore  Verna | Moore | 2541 COCKRELL AVE | FORT WORTH TX | 76109 | 2541 COCKRELL AVE
Spreadsheet: 489141d1479128233-help-summing-values-from-several-worksheets-tabs-collector-summary-november-2016
Sheet: NOV 5 2016

 | MTD | Collector | Subroll $ | Roll $ | Rate $ | Combined | # Calls | RPC | RPC % Ratio | PTP | PTP % Ratio | Scored Call
1 | 532733 | ESPERANZA ESCOBEDO | 48129 | 93294 | 39880 |  | 144 | 25 |  | 22
2 | 483458 | [NAME]
3 | 390192 | [NAME]
4 | 87619 | KRISTY WOODS | 0 | 13410 | 894 |  | 161 | 28 |  | 12
5 | 297652 | CRAIG VANTERPOOL | 7113 | 47022 | 250 |  | 133 | 23 |  | 10
6 | 79001 | RASHEED SHABAAZ
7 |  | DANNY CANTU
8 | 195217 | TOINETTE WEST
9 | 800921 | NINA HERNANDEZ
10 | 318444 | [NAME]
11 | 765447 | PHILIP PARSON
12 | 227372 | MARIA ARISPE | 0 | 0 | 3031 |  | 0 | 0 | 0 | 0 | 0
13 | 399546 | HANSON STRICKLING | 34608 | 65692 | 300 |  | 95 | 9 |  | 8
14 | 52807 | DEVANTE STRAIGHT
15 | 1068496 | MARTINE PALLAI
16 | 207747 | COMFORT AKINOLA
17 | 208885 | SAMANTHA CASTILLO | 44288 | 45560 | 0 |  | 180 | 17 |  | 13 | 0
18 | 423350 | LISA RODRIGUEZ
19 | 243537 | SHAUN COOPER | 38569 | 59381 | 0 |  | 170 | 31 |  | 19
20 | 174220 | CONSUELA JAVIER
21 | 379060 | QUEANA MAHONEY | 63235 | 14080 | 0 |  | 82 | 7 |  | 7
 |  | AVERAGE:
 |  | MEETING NOTES
 |  | *** DANNY, [NAME], ERICA, RASHEED, TOINETTE, NINA, [NAME], PHILIP, DEVANTE, [NAME], [NAME],
 |  | LISA, CONSUELA, MARIA OFF
 |  | **
 |  | **
Spreadsheet: 60f1f268-3cc1-43f5-a23e-f0a459bc3fdf
Sheet: Holds

2012-08-01 00:00:00 |  | Mental Holds (I.C. 66-326) by Ordering County
 |  |  |  |  |  |  |  | [NAME] -YTD
 |  | 24 Hour-MD Hold | 24 Hour-Police Hold | Field Petition | Administrative Hold | County Total | Regional Total | 24 Hour-MD Hold | 24 Hour-Police Hold | Field Petition | Administrative Hold | County Total | Regional Total
Region 1 | Benewah |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | [NAME] | 1 | 8 |  |  |  |  | 1 | 14 | 0 | 0
 | Boundary |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | Kootenai | 15 | 27 | 1 | 5 |  |  | 20 | 48 | 1 | 15
 | Shoshone | 1 |  |  |  |  |  | 2 | 1 | 0 | 0
Region 2 | Clearwater | 1 |  |  |  |  |  | 1 | 0 | 0 | 1
 | Idaho |  |  | 1 |  |  |  | 0 | 0 | 3 | 0
 | Latah |  | 2 |  |  |  |  | 2 | 2 | 2 | 0
 | Lewis |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | Nez Perce | 7 | 3 |  | 1 |  |  | 13 | 8 | 0 | 1
Region 3 | Adams | 1 | 1 |  |  |  |  | 2 | 1 | 0 | 0
 | Canyon | 30 | 41 |  | 1 |  |  | 68 | 84 | 0 | 3
 | Gem | 4 | 3 |  |  |  |  | 7 | 5 | 0 | 0
 | Owyhee | 1 |  |  |  |  |  | 3 | 0 | 0 | 0
 | Payette |  | 1 |  |  |  |  | 1 | 3 | 0 | 0
 | Washington | 1 | 2 |  |  |  |  | 2 | 4 | 0 | 0
Region 4 | [NAME] | 97 | 53 | 10 | 1 |  |  | 195 | 109 | 23 | 2
 | Boise |  | 1 |  |  |  |  | 0 | 1 | 0 | 0
 | Elmore | 3 | 6 | 2 |  |  |  | 3 | 7 | 2 | 0
 | Valley |  |  |  |  |  |  | 1 | 1 | 0 | 0
Region 5 | Blaine | 4 |  |  |  |  |  | 8 | 1 | 0 | 0
 | [NAME] |  | 1 |  |  |  |  | 0 | 1 | 0 | 0
 | Cassia | 3 | 1 |  |  |  |  | 5 | 3 | 0 | 1
 | Gooding | 3 | 3 |  |  |  |  | 5 | 3 | 0 | 0
 | [NAME] | 1 |  |  |  |  |  | 4 | 2 | 0 | 0
 | Lincoln |  |  |  |  |  |  | 1 | 0 | 0 | 0
 | Minidoka |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | [NAME] | 24 | 8 |  |  |  |  | 46 | 15 | 0 | 0
Region 6 | Bannock | 18 | 4 |  | 3 |  |  | 39 | 6 | 0 | 10
 | Bear Lake |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | [NAME] |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | Franklin |  | 1 |  | 1 |  |  | 0 | 1 | 0 | 1
 | Oneida |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | Power |  |  |  |  |  |  | 0 | 0 | 0 | 1
Region 7 | Bingham | 2 | 1 |  | 11 |  |  | 4 | 1 | 0 | 15
 | [NAME] |  | 1 |  | 23 |  |  | 3 | 6 | 0 | 35
 | [NAME] |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | [NAME] |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | Custer |  |  |  |  |  |  | 0 | 0 | 0 | 1
 | Fremont |  |  |  |  |  |  | 0 | 1 | 0 | 2
 | [NAME] | 1 |  |  | 2 |  |  | 3 | 0 | 0 | 2
 | Lemhi | 1 | 1 |  | 1 |  |  | 1 | 2 | 0 | 3
 | [NAME] |  |  |  |  |  |  | 1 | 0 | 0 | 4
 | Teton |  |  |  |  |  |  | 0 | 0 | 0 | 0
Out of State and Other |  | 2 |  |  |  |  |  | 3 | 0 | 0 | 0
Statewide |  | 221 | 169 | 14 | 49 |  |  | 444 | 330 | 31 | 97
Spreadsheet: f976117c-40b2-44b0-92e3-c6f67d68b29e
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (2 Entries):
 | 4 Micronano-systems 4.2 MEMS 4.2.1 RF MEMS 4.2.1.8 FBAR resonators
No. | Company | Country | City | [NAME] | Hall/Booth
1 | EPCOS AG, A Group Company of TDK-EPC Corporation | Germany | München | 81669 | B5.506
2 | TDK-EPC Corporation, A Group Company of TDK Corporation, c/o EPCOS AG | Germany | München | 81669 | B5.506
Spreadsheet: 36669d1234538580-drop-down-list-without-duplicates-example-1-
Sheet: List

Drop Down List with Duplicates |  | Drop Down List without Duplicates? |  | Count of Names
 |  |  |  | Names | Total
 |  |  |  | [NAME] | 3
 |  |  |  | [NAME] | 3
 |  |  |  | howard | 2
 |  |  |  | [NAME] | 2
 |  |  |  | mark | 1
 |  |  |  | Rita | 2
 |  |  |  | [NAME] | 2
 |  |  |  | (blank)
 |  |  |  | Grand Total | 15
Spreadsheet: 599536d1543166613-only-top-two-samples-1-ans
Sheet: Sheet1

I want only top two alphabets
 |  |  |  |  |  | FORMULA
A |  |  |  |  | A |  |  | ARRAY Formula is used
A |  | like this |  |  | A |  |  | How ARRAY formula is entered
A |  |  |  |  | B
B |  |  |  |  | B |  |  | [NAME] in the cell.
B |  |  |  |  | C |  |  | Press F2
B |  |  |  |  | C |  |  | Hold Shift+ [NAME] and hit Enter key.
C |  |  |  |  | D |  |  | Now  the formula is surrounded by {} by excel.
D |  |  |  |  | D
D |  |  |  |  | E |  |  | [NAME] takes care even If there is only one value is available in data.
D |  |  |  |  | E |  |  | Eg: C and E
D |  |  |  |  | F
D |  |  |  |  | F
E
F
F
F
F
G
G
H
Spreadsheet: mary_fischer__25630__1581 - 2001
Sheet: E5.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
ANALYSIS OF GOODWILL
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-5
 |  |  |  | 12-31-2000 Balance
 |  |  |  | BEGINNING |  |  |  |  |  |  |  |  |  | 12-31-2001
[NAME] OR ENTITY |  | AMORTIZATION |  | BALANCE |  |  |  |  |  | OTHER |  |  |  | BALANCE
 |  | PERIOD (Yrs.) |  | DR. (CR.) |  | ADDITIONS |  | AMORTIZATION** |  | AMOUNT |  | (DESCRIBE) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Goodwill* |  |  |  |  |  |  |  |  | ** |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0344 | Same signs as Hyperion
**MUST TIE TO HYPERION ACCOUNT 1418 | Reverse signs from Hyperion
Spreadsheet: 876895d1723612566-horizontal-and-vertical-search-jmerecki-order-sample-raw-data-and-result-365-aligw
Sheet: Table 2

Dataset
Style | color | 7 | 8 | 9 | 10 | 11 | 12 | Total:
1150 | Black |  | 3 | 2 | 1
1150 | Black |  |  |  | 2 | 4
1170 | [NAME] | 2 | 2 | 2
1170 | [NAME] |  |  | 1 | 5
1190 | Green | 2 | 4
1190 | Green |  |  | 6
Result
SKU |  | Qty |  |  |  |  | Qty
1150-Black-8 |  | 3 |  |  |  | 1150-Black-8 | 3
1150-Black-9 |  | 2 |  |  |  | 1150-Black-9 | 2
1150-Black-10 |  | 3 |  |  |  | 1150-Black-10 | 3
1150-Black-11 |  | 4 |  |  |  | 1150-Black-11 | 4
1170-Brown-7 |  | 2 |  |  |  | 1170-Brown-7 | 2
1170-Brown-8 |  | 2 |  |  |  | 1170-Brown-8 | 2
1170-Brown-9 |  | 3 |  |  |  | 1170-Brown-9 | 3
1170-Brown-10 |  | 5 |  |  |  | 1170-Brown-10 | 5
1170-Green-7 |  | 2 |  |  |  | 1190-Green-7 | 2
1170-Green-8 |  | 4 |  |  |  | 1190-Green-8 | 4
1170-Green-9 |  | 6 |  |  |  | 1190-Green-9 | 6
 |  |  |  |  |  |  | 36
Spreadsheet: 398c8f77-0346-43d2-a7e9-890ed1a7f2df
Sheet: Sheet1

Table 1--Wheat: U.S. market year supply and disappearance, 4/11/2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Item and unit |  |  | 2007/08 | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13 | 2013/14
 | Area: Planted | Million acres | 60.46 | 63.193 | 59.168 | 53.593 | 54.409 | 55.666 | 56.156
 | Harvested | Million acres | 50.999 | 55.699 | 49.893 | 47.619 | 45.705 | 48.921 | 45.157
 | Yield | Bushels per acre | 40.2 | 44.9 | 44.5 | 46.3 | 43.7 | 46.3 | 47.2
 | Supply: Beginning stocks | Million bushels | 456.153 | 305.818 | 656.505 | 975.637 | 862.246 | 742.62 | 717.889
 | Production | Million bushels | 2051.088 | 2499.164 | 2218.061 | 2206.916 | 1999.347 | 2266.027 | 2129.695
 | Imports 1/ | Million bushels | 112.631 | 126.971 | 118.59 | 96.92 | 112.069 | 122.756 | 165
 | Total supply | Million bushels | 2619.872 | 2931.953 | 2993.156 | 3279.473 | 2973.662 | 3131.403 | 3012.584
 | Disappearance: Food use | Million bushels | 947.865 | 926.769 | 918.92 | 925.641 | 941.387 | 944.723 | 960
 | Seed use | Million bushels | 87.615 | 78.045 | 69.471 | 70.889 | 76.199 | 73.014 | 74.379
 | Feed and residual use | Million bushels | 15.962 | 255.219 | 149.831 | 129.251 | 162.372 | 388.415 | 220
 | Total domestic use | Million bushels | 1051.442 | 1260.033 | 1138.222 | 1125.781 | 1179.958 | 1406.152 | 1254.379
 | Exports 1/ | Million bushels | 1262.612 | 1015.415 | 879.297 | 1291.446 | 1051.084 | 1007.362 | 1175
 | Total disappearance | Million bushels | 2314.054 | 2275.448 | 2017.519 | 2417.227 | 2231.042 | 2413.514 | 2429.379
 | Ending stocks | Million bushels | 305.818 | 656.505 | 975.637 | 862.246 | 742.62 | 717.889 | 583.205
 | Stocks-to-use ratio |  | 13.2157 | 28.8517 | 48.3583 | 35.6709 | 33.2858 | 29.7446 | 24.0063
 | Loan rate | Dollars per bushel | 2.75 | 2.75 | 2.75 | 2.94 | 2.94 | 2.94 | 2.94
 | Contract/direct payment rate | Dollars per bushel | 0.52 | 0.52 | 0.52 | 0.52 | 0.52 | 0.52 | 0.52
 | Farm price 3/ | Dollars per bushel | 6.48 | 6.78 | 4.87 | 5.7 | 7.24 | 7.77 | 6.75-6.95
 | Government payments | Million dollars | 1118
 | Market value of production | Million dollars | 13289.326 | 16625.759 | 10654.115 | 12827.254 | 14322.909 | 17491.304 | 14588.4108
Latest market year is projected; previous market year is estimated. Totals may not add due to rounding. 1/ Includes flour and selected other products expressed in grain-equivalent bushels. 2/ Stocks owned by USDA's Commodity Credit Corporation (CCC). Most CCC-owned inventory is in the Bill Emerson Humanitarian Trust.
3/ U.S. season-average price based on monthly prices weighted by monthly marketings. Prices do not include an allowance for loans outstanding and government purchases. Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates and supporting materials.
Date run: 4/11/2014
Spreadsheet: 821821d1678909898-using-sumproduct-to-calculate-sales-based-on-date-time-and-product-sample-data
Sheet: Sample Data

DASHBOARD |  |  |  |  | 06:00:00
 |  |  |  |  | 05:59:59
Date | Time | Product | Sales |  |  | Sales
2021-10-01 00:00:00 | 23:38:24 | A | 120 |  | 2021-10-01 00:00:00
2021-10-01 00:00:00 | 23:40:38 | B | 125 |  | 2021-10-02 00:00:00
2021-10-01 00:00:00 | 23:43:58 | D | 100 |  | 2021-10-03 00:00:00
2021-10-01 00:00:00 | 23:47:56 | B | 0 |  | 2021-10-04 00:00:00
2021-10-01 00:00:00 | 23:49:59 | D | 0 |  | 2021-10-05 00:00:00
2021-10-01 00:00:00 | 23:51:41 | C | 0
2021-10-02 00:00:00 | 23:31:26 | A | 0 |  | Optimal Table
2021-10-02 00:00:00 | 23:32:49 | D | 102 |  | Date | A | B | C | D
2021-10-02 00:00:00 | 23:33:56 | C | 50 |  | 2021-10-01 00:00:00
2021-10-02 00:00:00 | 23:35:33 | B | 0 |  | 2021-10-02 00:00:00
2021-10-02 00:00:00 | 23:36:02 | A | 0 |  | 2021-10-03 00:00:00
2021-10-02 00:00:00 | 23:36:35 | D | 0 |  | 2021-10-04 00:00:00
2021-10-02 00:00:00 | 23:38:33 | D | 0 |  | 2021-10-05 00:00:00
2021-10-02 00:00:00 | 23:42:20 | A | 0
2021-10-02 00:00:00 | 23:46:42 | A | 0
2021-10-02 00:00:00 | 23:49:18 | A | 20
2021-10-02 00:00:00 | 23:54:35 | D | 22
2021-10-02 00:00:00 | 23:55:24 | C | 50
2021-10-03 00:00:00 | 23:47:45 | C | 164
2021-10-04 00:00:00 | 23:37:58 | B | 2500
2021-10-04 00:00:00 | 23:39:15 | C | 15
2021-10-04 00:00:00 | 23:45:29 | B | 100
2021-10-04 00:00:00 | 23:46:47 | D | 20
2021-10-04 00:00:00 | 23:52:16 | B | 0
2021-10-04 00:00:00 | 23:53:10 | A | 0
2021-10-05 00:00:00 | 23:36:55 | C | 30
2021-10-05 00:00:00 | 23:45:10 | C | 40
2021-10-05 00:00:00 | 23:56:38 | B | 200
2021-10-05 00:00:00 | 23:59:46 | A | 58
Spreadsheet: 31449d1227279390-pivot-table-values-without-sum-avg-example
Sheet: Sheet1

Col1 | Col2 | Col3 | Col4 | Col5 | Col6
Values | Values | Values | Values | Red | no calc
Values | Values | Values | Values | green | no calc1
Values | Values | Values | Values | blue | no calc2
Col1 | Col2 | Col3 | Col4 | Red | green | blue
Values | Values | Values | Values | no calc | no calc1 | no calc2
Spreadsheet: 006eae21-26af-4e2f-8d9c-6207e3a57cb9
Sheet: Fill Handle

 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
Spreadsheet: 741613d1627203608-excel-room-booking-sheet-using-sumproduct-and-conditional-formatting-test-forum-booking-sheet-25-july-2021
Sheet: Room Reservation

Room Type - for calendar | Room No - only for calendar |  |  |  |  |  |  |  | Guest Name | Check In | Check Out
Standard | 2 |  |  |  |  |  |  |  | Guest 4 | 2021-07-15 00:00:00 | 2021-07-22 00:00:00
Standard | 4 |  |  |  |  |  |  |  | Guest 5 | 2021-07-15 00:00:00 | 2021-07-23 00:00:00
Standard | 1 |  |  |  |  |  |  |  | Guest 6 | 2021-07-17 00:00:00 | 2021-07-24 00:00:00
Standard | 2 |  |  |  |  |  |  |  | Guest 8 | 2021-07-23 00:00:00 | 2021-07-29 00:00:00
Standard | 3 |  |  |  |  |  |  |  | Guest 7 | 2021-07-24 00:00:00 | 2021-07-28 00:00:00
Standard | 1 |  |  |  |  |  |  |  | Guest 9 | 2021-07-24 00:00:00 | 2021-07-30 00:00:00
Spreadsheet: 271306d1381905973-help-creating-a-formula-that-using-if-index-match-and-displays-only-the-newest-dates-0a1fothelp
Sheet: Staff Summary - AQ

EMPLOYEE | [NAME] | [NAME]
WHMIS | No Exp | No Exp
Transportation of Dangerous Goods (TDG)
Light Vehicle Maintenance & Repair **NEW**
Defensive Driving |  | 2014-04-26 00:00:00
Trailering | 2011-04-16 00:00:00
Remedial Driving
ARGO - CSC - Level 1
ARGO - Manufacture |  | 2013-05-05 00:00:00
Maintenance - ARGO
ATV | 2016-05-06 00:00:00 | 2014-04-26 00:00:00
UTV |  | 2015-08-28 00:00:00
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Robert Krebs

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
I'd like to explain my position
Explain your fair share position, if you choose.
If anyone choses to teach or engage in other professions, they should not be forced to join a union or support union activites. Similarly
the union or bargaining unit should not be required to represent/defend a teacher in a grievance (or similar) if they chose not to belong
to a union.
Teachers' Retirement: Support in the State Budget
I'd like to explain my position
Explain your teachers' retirement position, if you choose.
If the State has made contractual agreements with the teachers, it should meet those obligations and commitements.
Health Care: Continuing System Reform
I'd like to explain my position
Explain your health care reform position, if you choose
Health care is an evolving system and it is too early to make pronouncements about coverage and who will pay.
Teaching Career: Retaining New Teachers
I'd like to explain my position
Explain your teaching career position, if you choose
A quality education is probably one of the most important opportunites we can offer to our children. It is incumbent on all Vermonters
to support a policy that encouarages qualified young professionals to make teaching a lifelong occupation.
Teaching Profession: Simplifying Professional Relicensing
I'd like to explain my position
Explain your relicensing position, if you choose
This a matter for the office of professional regulation or the Board. If there is redundancy or unecessary requests for information, then
the process should be streamlined.
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | 134 East Shore Road South Hero, Vermont | State Representative | Yes |  | Grand Isle