tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 210138d1359388138-data-validation-fromn-two-different-named-range-alternatives-data-for-help
Sheet: 2010

 |  | NEW CLAIMS |  |  | FEES | 2010/2011 |  |  |  |  |  |  |  |  |  | FEES | 2012
 |  | MONTH | POLICYHOLDER | AGENCY | Nov to Feb | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Mar | April | May | June | July | Aug | Sept | Oct | Nov | Dec
 |  | Sep
1 | 1 | Nov |  | *Pwllheli*
2 | 2 | Nov |  | Diss
3 | 3 | Nov |  | Royston
4 | 4 | Nov |  | Royston
5 | 5 | Nov |  | Royston
6 | 6 | Nov |  | Royston
7 | 7 | Nov |  | Royston
8 | 1 | Dec |  | *Yorks*
9 | 2 | Dec |  | *Yorks*
10 | 3 | Dec |  | *Yorks*
11 | 4 | Dec |  | *Yorks*
12 | 5 | Dec |  | *Yorks*
13 | 6 | Dec |  | *Yorks*
14 | 7 | Dec |  | *Yorks*
15 | 8 | Dec |  | *Yorks*
16 | 9 | Dec |  | *Yorks*
17 | 10 | Dec |  | Cambridge
18 | 11 | Dec |  | Diss
19 | 12 | Dec |  | Hethersett (Hingham)
20 | 13 | Dec |  | Hethersett (Hingham)
21 | 14 | Dec |  | Hethersett (Hingham)
22 | 15 | Dec |  | Holt
23 | 16 | Dec |  | Huntingdon
24 | 17 | Dec |  | Northampton
25 | 18 | Dec |  | [NAME]
26 | 19 | Dec |  | [NAME]
27 | 20 | Dec |  | [NAME]
28 | 21 | Dec |  | Royston
29 | 22 | Dec |  | Royston
30 | 23 | Dec |  | [NAME]
31 | 24 | Dec |  | Swaffham
32 | 25 | Dec |  | Swaffham
33 | 26 | Dec |  | Swaffham
34 | 27 | Dec |  | Swaffham
35 | 28 | Dec |  | Swaffham
36 | 29 | Dec |  | TBC (Cornish)
Spreadsheet: 833136d1686807348-if-statement-with-multiple-conditions-result-is-inconsistent-look-up-with-multiple-if-condition-aligw
Sheet: Data

Part No. | Closing Stock | TTL |  | AliGW
P04538 | 99061.53 | 908.62
P07694-21A | 8000 | 842.2
P20554-01 | 0 | 0 |  |  | ???
L05302 | 7200 | 730
Condition:
 | IF B2 is not zero in Data tab, [NAME] (only first 6 digit if lookup data only has 6 digit)
 | from the element tab, match and look at the highest number from B column
 | if A2 has decimal - like P07694-21A in B3 Data tab and B3 has more than zero match it to the Element Tab
 | exactly as is - result is 842.20
 | Another condition will be if we could not match A5 from the element tab column A - substitute that Look up value A5
 | from Other Source tab column B then match it with the Element Tab column A and pick the highest number in column B
 | also with the condition if B5 in Data tab is not zero
Spreadsheet: 803985d1667832635-extracting-data-from-excel-tables-sales-control
Sheet: Test

 | Type | (Multiple Items)
 | Name | ID | Date | Invoice | Reference | Debit | Credits | Balance
 | Abi | A002 | 2022-11-05 00:00:00 | (blank) | 23 | 3000 | (blank) | 3100
 |  |  |  |  | 70 | 250 | (blank) | 450
 |  |  | 2022-11-06 00:00:00 | (blank) | 25 | 3500 | (blank) | 4000
 |  |  | 2022-11-07 00:00:00 | (blank) | 40 | 1000 | (blank) | 5130
 |  |  |  |  | 80 | 250 | (blank) | 6200
 | ADAM | A008 | 2022-11-09 00:00:00 | (blank) | 102 | (blank) | 500 | 2200
 |  |  |  |  |  |  |  | 3330
 |  |  |  |  |  |  |  | 3800
 |  |  |  |  |  |  |  | 9400
 | Bern | A005 | 2022-11-07 00:00:00 | (blank) | 100 | (blank) | 300 | 3700
 |  |  |  |  |  |  |  | 4800
 |  |  |  |  |  |  |  | 4830
 |  |  |  |  |  |  |  | 5900
 | Bigboy | A003 | 2022-11-05 00:00:00 | (blank) | 24 | 2000 | (blank) | 5100
 |  |  |  |  | 37 | 4000 | (blank) | 4130
 |  |  | 2022-11-06 00:00:00 | (blank) | 71 | 2000 | (blank) | 2450
 | [NAME] | A006 | 2022-11-08 00:00:00 | (blank) | 101 | (blank) | 1000 | 2700
 |  |  |  |  |  |  |  | 3830
 |  |  |  |  |  |  |  | 4300
 |  |  |  |  |  |  |  | 9900
 |  |  | 2022-11-09 00:00:00 | (blank) | 103 | (blank) | 300 | 1900
 |  |  |  |  |  |  |  | 3030
 |  |  |  |  |  |  |  | 3500
 |  |  |  |  |  |  |  | 9100
 |  |  | 2022-11-10 00:00:00 | (blank) | 101 | (blank) | 1000 | 900
 |  |  |  |  |  |  |  | 2030
 |  |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  |  | 8100
 | Rose | A001 | 2022-11-06 00:00:00 | (blank) | 72 | 3500 | (blank) | 5950
 |  |  | 2022-11-07 00:00:00 | (blank) | 30 | 5000 | (blank) | 10900
 |  |  |  |  | (blank) | 500 | (blank) | 5300
Spreadsheet: 711707d1609856834-pulling-one-of-multiple-headers-in-single-column-based-on-information-below-schedule-template-wip
Sheet: Master Schedule

 | 2021-01-17 00:00:00
 | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa
Department 1
Name 1
Name 2
Name 3 |  |  |  |  |  |  |  |  | P
Name 4 |  |  |  |  |  |  |  |  | A
Name 5 |  |  |  |  |  |  |  |  | P
Name 6 |  |  |  |  |  |  |  |  | A
Name 7
Department 2
Name 8
Name 9
Name 10
Name 11 |  |  |  |  |  |  |  |  | A
Name 12 |  |  |  |  |  |  |  |  | A
Name 13 |  |  |  |  |  |  |  |  | P
Department 3
Name 14
Name 15
Name 16
Name 17 |  |  |  |  |  |  |  |  | A
Name 18 |  |  |  |  |  |  |  |  | P
Name 19 |  |  |  |  |  |  |  |  | P
Department 4
Name 20
Name 21
Name 22
Name 23
Name 24 |  |  |  |  |  |  |  |  | A
Name 25 |  |  |  |  |  |  |  |  | P
Name 26
 | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa
Department 5
Name 27
Name 28
Name 29
Name 30 |  |  |  |  |  |  |  |  | P
Name 31 |  |  |  |  |  |  |  |  | P
Name 32 |  |  |  |  |  |  |  |  | A
Name 33 |  |  |  |  |  |  |  |  | A
Name 34
Department 6
Name 35 |  |  |  |  |  |  |  |  | A
Name 36 |  |  |  |  |  |  |  |  | A
Name 37 |  |  |  |  |  |  |  |  | P
Name 38 |  |  |  |  |  |  |  |  | P
Name 39 |  |  |  |  |  |  |  |  | P
Name 40
Department 7
Name 41
Name 42 |  |  |  |  |  |  |  |  | P
Name 43 |  |  |  |  |  |  |  |  | A
Name 44 |  |  |  |  |  |  |  |  | A
Name 45 |  |  |  |  |  |  |  |  | P
Name 46
Department 8
Name 47 |  |  |  |  |  |  |  |  | A
Name 48
Name 49 |  |  |  |  |  |  |  |  | P
Name 50 |  |  |  |  |  |  |  |  | A
Name 51 |  |  |  |  |  |  |  |  | P
Name 52
Name 53 |  |  |  |  |  |  |  |  | A
Department 9
Name 54
Name 55
Name 56
AM
PM
Spreadsheet: 809306d1671022228-to-count-the-number-of-instances-for-ranged-dates-query-date-ranges-condition
Sheet: Sheet1

 |  |  |  | [NAME] | 2021-08-06 00:00:00 | 2021-08-16 00:00:00 |  | [NAME]
 |  |  |  | [NAME] | 2021-12-06 00:00:00 | 2021-12-16 00:00:00 |  | [NAME]
 |  |  |  | [NAME] | 2022-10-06 00:00:00 | 2022-10-16 00:00:00 |  | [NAME]
 |  |  |  | [NAME] | 2021-08-05 00:00:00 | 2021-08-15 00:00:00
 |  |  |  | [NAME] | 2021-12-05 00:00:00 | 2022-12-14 00:00:00
 |  |  |  | [NAME] | 2022-10-05 00:00:00 | 2022-10-15 00:00:00
 |  |  |  | [NAME] | 2021-12-06 00:00:00 | 2021-12-16 00:00:00
 |  |  |  | [NAME] | 2022-10-06 00:00:00 | 2022-10-16 00:00:00
Spreadsheet: 0ca293d5-1242-4b19-bb1c-a2d605baacd0
Sheet: Purchase Requisition

Office of Student Activities and Engagement
COMMONWEALTH OF VIRGINIA
University of [NAME]
1301 College Avenue
Fredericksburg, VA   22401
Direct Pay c |  |  |  |  | Banner Invoice  # |  | I
(used for paying performers/speakers,registration/conference fees & cash awards)
Honorarium c |  |  |  |  | Vendor #
 |  |  |  |  | Contact Name:
 |  |  |  |  | Contact Phone Number:
 |  |  |  |  | E-mail:
VENDOR / PAYEE NAME AND ADDRESS |  |  |  |  | MAIL INVOICE TO: Office of Student Activities and Engagement University of [NAME] 1301 College Avenue Fredericksburg, VA  22401-5358 (540) 654-1061
NAME
ADDRESS
 | CITY |  | STATE | ZIP
 | PHONE # |  | FAX #
Description |  |  |  |  |  |  | Amount
Is payment due immediately upon completion of service/performance?  Yes c    No c
Funding Source to be charged:
Fund | 1556
Org. |  |  | 1st authorized signer |  |  |  |  | Date
Account
Program | 10520
Check Information
 |  |  | 2nd authorized signer |  |  |  |  | Date
Mail_____________
Pick Up______ | Date__________
*Pick up checks at the Cashier's office in
[NAME] |  |  | SAE authorized signer |  |  |  |  | Date
 |  |  |  |  |  |  |  | Rev. 11-11-11
Spreadsheet: 164137d1340656043-simple-sumproduct-or-countif-formula-sample
Sheet: DATA

 |  |  |  |  | Named User | All Trained | No Budget | No Further Requirements | Dissatisfied with Product / Service | Other | Ongoing | Total | Number renewed
 |  |  |  |  | NU | AT | NB | NFR | DS | OT | ONG |  | R
 |  |  |  | May | 2 |  |  | 3 |  | 1 | 5 | 15 | 4
 |  |  |  | June | 2 |  |  | 3 |  | 1 | 6 | 16
 |  |  |  | July |  | 1 |  | 5 |  | 1 | 31 | 39
Spreadsheet: 161113d1339420207-random-results-based-on-percentages-baseball-simulator
Sheet: Players

Pitchers
League |  |  | 0.55 |  |  | 0.265 | 0.28 | 0.275 | 0.275 | 0.2 | 0.375 |  | 0.375 | 0.075 |  |  |  |  | 0.0975
Name |  | L/R | Control | Lefty | Righty | FB- | CH- | SL- | [NAME] | SwStr+ | GB% | LD% | FB% | IFFB% | GB+ | LD+ | FB+ | IFFB+ | HR/FB
Template
[NAME] | 3 |  | 0.81 | 0.95 | 0.92 | 1.18 | 1.13 | 0.94 | 0.221 | 0.93 | 0.382 |  | 0.334 | 0.091 |  |  |  |  | 0.125
Hitters
League |  |  | 0.65 | 0.25 |  |  |  |  | 0.8 | 0.275 | 0.375 | 0.175 | 0.375 | 0.075 |  |  |  |  | 0.0975 | 0.1625
Name |  | L/R | InSwing | OutSwing | Inside | Outside | Lefty | Righty | Contact | BA | GB | LD | FB | IFFB | GB | LD | FB | IFFB | HR/FB | ISO
Template
[NAME] | 1 |  | 0.744 | 0.224 | 1 | 0.86 | 0.94 | 1.14 | 0.709 | 0.288 | 0.274 | 0.363 | 0.296 | 0.067 | 0.7306666666666667 | 2.074285714285714 | 0.7893333333333333 | 0.8933333333333334 | 0.105 | 0.183
Spreadsheet: 812130d1672988085-autofill-with-if-formula-if-formula
Sheet: Sheet1

 |  |  | [NAME] | Grade | BC | Ket |  |  | SOURCE  IF | TEXT
THE RESULT I WANT (AUTO FILL) |  |  |  |  |  | FARM 1 |  |  | FARM 1 | MPS FARM 1
 |  |  |  |  |  | FARM 1 |  |  | FARM 2 | MPS FARM 2
 |  |  |  |  |  | FARM 1 |  |  | FARM 1 FARM 2 | MIX MPS FARM 1 AND FARM 2
 |  |  |  |  |  | FARM 1
 |  |  |  |  |  | FARM 1
 |  |  |  |  |  | FARM 1 FARM 2 |  | I ENTER THE TEXT HERE FROM D4:D12
 |  |  |  |  |  | FARM 2
 |  |  |  |  |  | FARM 2
 |  |  |  |  |  | FARM 2
 |  |  |  |  |  | FARM 1 FARM 2
 |  |  | [NAME] | Grade | BC | Ket |  |  | [NAME] | Grade | BC | Ket
THE RESULT I WANT |  |  | MPS FARM 1 |  |  | FARM 1 |  | THE RESULT I WANT | MIX MPS FARM 1 AND FARM 2 |  |  | FARM 2
 |  |  |  |  |  |  |  |  |  |  |  | FARM 2
 |  |  |  |  |  |  |  |  |  |  |  | FARM 1
Spreadsheet: 805196d1668585590-beginning-of-month-date-formula-cell-beginning-of-month-range-aligw
Sheet: Sheet1

 | 2022-11-01 00:00:00
 | Period From: |  |  |  |  |  |  | Until:
 |  |  |  | Cell used to show week number
 | Desciption |  |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 |  |  |  |  | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
Spreadsheet: 839024d1691596251-template-sheet-that-when-edited-updates-all-sheets-template-for-updating-sheets
Sheet: Sheet1

 | These cells are user input
 | These cells are Excel output
Graphic Design
Starting $ | 100 |  |  | [NAME] (moved because of new row and column)
NEW ROW
Name | Date | Add $ | NEW COLUMN | OG Description | New Total $ | Notes | Links
Name 1 |  | 10
Name 2 |  | 5
Name 3 |  | 1
Name 4 |  | -20
Name 5 |  | 100
Name 6 |  | 200
Name 7 |  | -150
Spreadsheet: mark_taylor__25054__105657 - O&M 063001
Sheet: Headcount - 105659

 | ENRON NORTH AMERICA
 | ENA - Upstream Originations (105659)
 | HEADCOUNT AS OF 06-30-01
Employee | Co | Team | Job Title | Headcount
GRAY,BARBARA N | 413 | ENA - Legal | Vice President | 1
HODGE,JEFFREY T | 413 | ENA - Legal | Vice President | 1
 |  |  | Total
VAN HOOSER,[NAME] | 413 | ENA - Legal | [NAME] | 1
 |  |  | Total
DICKSON,STACY E | 413 | ENA - Legal | SR Counsel | 1
NEMEC,[NAME] R | 413 | ENA - Legal | Counsel | 1
SOLE, CARLOS | 413 | ENA - Legal | SR Counsel | 1
 |  |  | Total
[NAME], KATHLEEN | 413 | ENA - Legal | Other  Non-commercial | 1
FARRELL, KEEGAN | 413 | ENA - Legal | Other  Non-commercial | 1
FERGUSON, SAMANTHA M | 413 | ENA - Legal | Other  Non-commercial | 1
MEADOWS, RAE | 413 | ENA - Legal | Other  Non-commercial | 1
OGDEN,[NAME] | 413 | ENA - Legal | Other  Non-commercial | 1
PERLINGIERE,[NAME] A | 413 | ENA - Legal | Other  Non-commercial | 1
 |  |  | Total
 |  |  | Total for 105659
Spreadsheet: darrell_schoolcraft__7786__imbalsumm0107
Sheet: williams

 | Milagro |  | La Maquina |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 351698 | 350476 | 53117 | 45924 | 82042 | 94042 | 78203 | 73803
2 | 362354 | 371662 | 51911 | 42633 | 83617 | 93854 | 79048 | 73052
3 | 365025 | 376259 | 55426 | 51697 | 78010 | 79498 | 93776 | 87381
4 | 325437 | 340000 | 69673 | 50321 | 77207 | 88206 | 97217 | 90822
5 | 350462 | 349059 | 67107 | 50924 | 74905 | 80810 | 92558 | 96546
6 | 292062 | 283742 | 56072 | 56077 | 79495 | 84766 | 135836 | 137216
7 | 294812 | 305776 | 62730 | 53264 | 82099 | 99041 | 92059 | 79280
8 | 290868 | 290687 | 64631 | 47973 | 68848 | 98561 | 80456 | 78910
9 | 290040 | 297891 | 65272 | 49000 | 80530 | 83999 | 16200 | 16227
10 | 301867 | 286878 | 92797 | 105649 | 79960 | 84690 | 33661 | 37593
11 | 288105 | 285000 | 116130 | 114192 | 77152 | 82179 | 97419 | 89000
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00 |  |  |  |  |  |  |  |  | 286331
2001-07-11 00:00:00
 |  |  | 300359.04
 |  |  | -250735.54
 |  |  | 44931.54
 |  |  | 2153062.32
 |  |  | 0.0238
 |  |  | 0.0153
Spreadsheet: 798365d1664447721-help-required-on-a-vertical-and-horizontal-lookup-matching-criterias-cycle-matching-001
Sheet: Sheet1

Example 1
Item | A
Quantity | 48
Current Cycle | Cycle 012
[NAME] |  | The Cycle cannot before the 'Current Cycle'
Item | Cycle 010 | Cycle 011 | Cycle 012 | Cycle 013 | Cycle 014 | Cycle 015
A | 10 | 20 | 30 | 40 | 50 | 60
B | 20 | 40 | 60 | 80 | 100 | 120
The formula currently retruns Cycle 14 which is the first 'value' that is >= to the Quanity and the 'Planned Cycle' >= 'Current Cycle'
Example 2
Item | A
Quantity | 48
Current Cycle | Cycle 012
[NAME] |  | The Cycle cannot before the 'Current Cycle'
Item | Cycle 010 | Cycle 011 | Cycle 012 | Cycle 013 | Cycle 014 | Cycle 015
A | 40 | 60 | 80 | 100 | 120 | 140
B | 20 | 40 | 60 | 80 | 100 | 120
How can the existing formula be amended to incorporate a list of multiple items, selecting the matching item and then selecting the corresponding [NAME] (similar to VLOOKUP…)
Spreadsheet: 160069d1338957487-generating-a-4-part-alphanumeric-sequence-generate-labels
Sheet: Sheet1

First | helper | second | third | fourth | trigger | label
A | 1 | 1 | 1 | 1 | print
 |  |  |  |  | print
 |  |  |  |  | print
 |  |  |  |  | print
Spreadsheet: 885244d1734686374-changing-multiplier-based-on-cell-value-points-form-jt-v2
Sheet: January

Date | Day | Attended | Points
2025-01-01 00:00:00 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
Total
 | Day | Attended | Points
 | Mon
 | Tue
 | Wed
 | Thu
 | Fri
 | Sat
 | Sun
 | Total
Spreadsheet: 720823d1614296688-formula-to-auto-populate-cost-codes-sample-workbook-7-
Sheet: Sample Tab

Indirect Labor | Cost Code
Project Manager (30hrs/wk x 36wks)
Superintendant (40hrs x 36 wks)
General [NAME] (Electrical work)(40hrs/wk x 22wks)
General [NAME] (Civil work)(60 hrs/wk x 12wks)
Electrical [NAME] (2 x 40hrs/wkx22wks)
[NAME] (to work with solar team)(2 x 40hrs/wk x 6wks)
Records (3 hrs/wk x 36 wks)
Cost Controller (5 hrs/wk x 36 wks)
Field Technician (40 hrs/wk x 16 wks)
Material Handling (2 x 40hrs/wk x 20wks)
Safety (40hrs x 36 wks)
ORIENTATION / TRAINING (30 x 8HRS)
Spreadsheet: 817299d1676106287-negative-amount-and-summation-issue-2023-commission-for-designers-sample-ans
Sheet: Yearly

Month | [NAME] | Travis | [NAME] | JJ | Shawnee | Emily and [NAME] | Month Total
January
February
March
April
May
June
July
August
September
October
November
December
Yearly Total
Spreadsheet: 811365d1672432314-excel-formula-to-track-salary-raise-by-pay-period-test-employee-raise-by-period-calculated-on-each-period-1-
Sheet: Test

 | Sum of  (1)Regular Earnings
Employee Count | Employee Name | Raise % | Hire Date | Start Date | Same Year Current | 2023 Anniversary | Term Date | Current Salary | [NAME] | Total Comp w Raise | Annual Salary | SS/Tax | Medicare | SUI | MCTMT | Health Insurance | Total Fringe | 2023 Comp |  |  | 2023-01-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Salary
1 | Employee 1 | 0.06 | 2021-12-13 00:00:00 | 2023-01-01 00:00:00 |  |  |  | 84000 |  |  | 84000 | 5487 | 1283 | 484 | 301 | 9085 |  |  | thru Q2; $50k
1 | Employee 2 | 0.05 | 2022-01-31 00:00:00 | 2023-01-01 00:00:00 |  |  |  | 335000 |  |  |  |  |  |  |  |  |  |  | thru Feb 2023
1 | Employee 3 | 0.05 | 2004-09-13 00:00:00 | 2023-01-01 00:00:00 |  |  |  |  |  |  | 156000 | 9114 | 2262 | 484 | 530 | 0 |  |  | freelance; $50k
1 | Employee 4 | 0.025 | 2021-03-01 00:00:00 | 2023-01-01 00:00:00 |  |  |  | 182000 |  |  | 182000 | 9114 | 2784 | 484 | 653 | 0 |  |  | 9 mos; $160,751
1 | Employee 5 | 0.02 | 2017-03-24 00:00:00 | 2023-01-01 00:00:00 |  |  |  | 255000 |  |  | 255000 | 9114 | 4567 | 484 | 1071 | 9105 |  |  | thru Q1;  $88,459
1 | Employee 6 | 0.02 | 2021-06-28 00:00:00 | 2023-01-01 00:00:00 |  |  |  | 90000 |  |  | 90000 | 6200 | 1450 | 484 | 340 | 7200 |  |  | thru Q1; $30,201
1 | Employee 10 | 0.07 | 2014-01-01 00:00:00 | 2023-01-01 00:00:00 |  |  |  | 215000 |  |  | 215000 | 9114 | 3552 | 484 | 833 | 18901
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $ -
 | Grand Total
Spreadsheet: 724172d1616047933-if-or-statement-not-working-correctly-selection-calculator
Sheet: Lists

 |  | Sensor 1 | Temperature | Relative Humidity | Both
Relative Humidity |  | Sensor 2 | Temperature | Moisture | Both
Both |  | Sensor 3 | Temperature | Moisture | Both
 |  | Sensor 4 | Temperature | Moisture | Both
 |  | Sensor 5 | Temperature | Co2 | Both
 |  | Sensor 6 | Differential Pressure | N/A | Both
 |  | Sensor 7 | [NAME].
 |  | Sensor 8 | Temperature
 |  | Sensor 9 | Displacement
 |  | Sensor 10 | Displacement
 |  | Sensor 11 | Heat Flux
 |  | Sensor 12 | Heat Flux
Spreadsheet: 20a968ac-50e2-4f58-8eb3-c7945c5f9339
Sheet: Sheet1

Table 1--Wheat: U.S. market year supply and disappearance, 12/13/2011 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Item and unit |  |  | 2005/06 | 2006/07 | 2007/08 | 2008/09 | 2009/10 | 2010/11 | 2011/12
 | Area: Planted | Million acres | 57.2 | 57.3 | 60.5 | 63.2 | 59.2 | 53.6 | 54.4
 | Harvested | Million acres | 50.1 | 46.8 | 51.0 | 55.7 | 49.9 | 47.6 | 45.7
 | Yield | Bushels per acre | 42.0 | 38.6 | 40.2 | 44.9 | 44.5 | 46.3 | 43.7
 | Supply: Beginning stocks | Million bushels | 540.1 | 571.2 | 456.2 | 305.8 | 656.5 | 975.6 | 862.2
 | Production | Million bushels | 2,103.3 | 1,808.4 | 2,051.1 | 2,499.2 | 2,218.1 | 2,206.9 | 1,999.3
 | Imports 1/ | Million bushels | 81.4 | 121.9 | 112.6 | 127.0 | 118.6 | 96.9 | 120.0
 | Total supply | Million bushels | 2,724.8 | 2,501.5 | 2,619.9 | 2,932.0 | 2,993.2 | 3,279.5 | 2,981.6
 | Disappearance: Food use | Million bushels | 917.1 | 937.9 | 947.9 | 926.8 | 918.9 | 925.6 | 940.0
 | Seed use | Million bushels | 77.1 | 81.9 | 87.6 | 78.0 | 69.5 | 70.9 | 78.2
 | Feed and residual use | Million bushels | 156.6 | 117.1 | 16.0 | 255.2 | 149.9 | 131.9 | 160.0
 | Total domestic use | Million bushels | 1,150.8 | 1,136.8 | 1,051.4 | 1,260.0 | 1,138.2 | 1,128.4 | 1,178.2
 | Exports 1/ | Million bushels | 1,002.8 | 908.5 | 1,262.6 | 1,015.4 | 879.3 | 1,288.8 | 925.0
 | Total disapperance | Million bushels | 2,153.6 | 2,045.3 | 2,314.1 | 2,275.4 | 2,017.5 | 2,417.2 | 2,103.2
 | Ending stocks | Million bushels | 571.2 | 456.2 | 305.8 | 656.5 | 975.6 | 862.2 | 878.4
 | CCC inventory 2/ | Million bushels | 43.0 | 41.0
 | Stocks-to-use ratio |  | 26.5 | 22.3 | 13.2 | 28.9 | 48.4 | 35.7 | 41.8
 | Loan rate | Dollars per bushel | 2.75 | 2.75 | 2.75 | 2.75 | 2.75 | 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 | 3.42 | 4.26 | 6.48 | 6.78 | 4.87 | 5.70 | 7.05-7.55
 | Government payments | Million dollars | 1,151 | 1,120 | 1,118 | 1,118
 | Market value of production | Million dollars | 7,167 | 7,695 | 13,289 | 16,626 | 10,654 | 12,579 | 14,595
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: 12/9/2011
Spreadsheet: 752649d1634881094-help-to-create-an-order-list-based-on-products-by-cheapest-supplier-price-comparison-test-1-
Sheet: TA 

Product | Supplier | Price | Quantity | Unit Price | Date | % change | Notes | PRODUCT | ABPAC | BAKO | Catering 24 | Cheapest | From | Saving | x50 bought
10" Greaseproof bag | ABPAC | 16.82 | 1000 |  |  |  |  | 10" Greaseproof bag
10" Greaseproof bag | BAKO | 8.12 | 1000
10" Greaseproof bag | Catering 24 | 19.02 | 1000
12oz compostable d/w cup | Catering 24 | 45.54 | 500
12oz compostable d/w cup | Next Day Coffee | 43.19 | 500
12oz compostable d/w cup | [NAME] | 53.1 | 500
12oz compostable lid | Catering 24 | 53.99 | 1000
12oz compostable lid | Next Day Coffee | 29.75 | 500
12oz compostable lid | [NAME] | 54.84 | 1000
7" Greaseproof bag | ABPAC | 10.28 | 1000
7" Greaseproof bag | BAKO | 6.88 | 1000
7" Greaseproof bag | Catering 24 | 9.77 | 1000
8oz compostable d/w cup | Catering 24 | 38.34 | 500
8oz compostable d/w cup | Next Day Coffee | 38.39 | 500
8oz compostable d/w cup | [NAME] | 43.56 | 500
8oz compostable lid | Catering 24 | 59.34 | 1000
8oz compostable lid | Next Day Coffee | 25.19 | 500
8oz compostable lid | [NAME] | 45.35 | 1000
Nesting Tray | ABPAC | 32.74 | 500
Nesting Tray | Bonds Packaging | 21.12 | 220
No. 1 [NAME] | Catering 24 | 56.99 | 450
No. 1 [NAME] | Enviropack | 59.94 | 450
No. 1 [NAME] | Enviropack 4+ | 56.39 | 450
No. 3 [NAME] | Catering 24 | 42.24 | 180
No. 3 [NAME] | Enviropack | 44.34 | 180
No. 3 [NAME] | Enviropack 4+ | 41.99 | 180
Perforated Film Front [NAME] bag | Enviropack | 36.54 | 1000
Perforated Film Front [NAME] bag | Enviropack 5+ | 33.59 | 1000
Perforated Film Front [NAME] bag | Next Day Coffee | 39.59 | 1000
SOS Carrier Bag | Catering 24 | 21.59 | 250
SOS Carrier Bag | Enviropack | 21.59 | 250
SOS Carrier Bag | Enviropack 5+ | 19.79 | 250
10" Greaseproof bag | ABPAC | 15