tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: cara_semperger__1431__PGE_NOVEMBER_MIDC_PATHS
Sheet: NOV (3)

 |  |  | To Portland General Electric : [NAME], [NAME], and [NAME]
 |  |  | Phone 464-7067
 |  |  | From Enron: Cara, [NAME], and [NAME] |  |  |  |  |  | DAILY COLSTRIP = 0
 |  |  | Phone 464-3814, 3902, 3831 |  |  |  |  |  | MONTH LONG COLSTRIP = 47 ATC
 |  |  |  |  |  |  |  |  | SYSTEM TO MIDC B/R = 25 LLH
 |  |  |  |  | Mid Columbia Paths
11/2/2001-11/3/01
 | HLH
 | DAY | 3 | BPA C#10440-CLATSKANPE-BPA(T)BPAP/PGE #10649NF | X | CLATSKANPE | ENRON | PGE | X | COLSTRIP B/R
 | DAY | 19 | IDC(G)SYS IPC(T)SYS/LOLO-AVA(T)LOLO/MIDC | X | [NAME] | ENRON | PGE | X | COLSTRIP B/R
 | DAY | 25 | [NAME] MPC(T)COLSTRIP/BURKE-DETM-AVA(T)BURKE/PGE-DETM-PNGC-AQUILA | X | CARGILL | ENRON | PGE | X | COLSTRIP B/R
 | LLH
 | DAY | 3 | BPA C#10440-CLATSKANPE-BPA(T)BPAP/PGE #10649NF | X | CLATSKANPE | ENRON | PGE | X | COLSTRIP B/R | 3
 | DAY | 19 | WWP(G)MIDC | X | WWP | ENRON | PGE | X | COLSTRIP B/R | 19
 | DAY | 25 | CHELAN(G)MIDC-IPCMO1-IDAC | X | EWEB | ENRON | PGE | X | COLSTRIP B/R | 25
 | DAY | 25 | MIDC GEN | X | PGE | ENRON | SNO | X | SNPD BPA(T)MIDC/SNDP #96092HNF
 | MONTH COLSTRIP PATHS
 | ALL HOURS
 | MONTH | 6 |  | X | PGE | ENRON | ASHGROVE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 6 |  | X | PGE | ENRON | EXPRESS PIPE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 7 |  | X | PGE | ENRON | HOLNAM | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 8 |  | X | PGE | ENRON | LOUISIANA P | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 5 |  | X | PGE | ENRON | LUZENAC | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 15 |  | X | PGE | ENRON | SMURFIT | X | MPCO NETWORK TRANSMISSION TO LOAD
Spreadsheet: db2fc3c8-12c7-4ee3-9cd2-f1de5fadc1ed
Sheet: Sheet1

1 of 2 | PRESIDENT OF THE UNITED STATES | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | SUMMARY BY COUNTIES/DEMOCRATIC
 | Bradley, d | Buckley, d | [NAME], d | Crow, d | Eaton, d | [NAME], d | Greenstein, d | Hamm, d
Belknap | 2711 | 13 | 0 | 0 | 7 | 2837 | 4 | 0
Carroll | 2139 | 10 | 0 | 2 | 6 | 1968 | 1 | 1
Cheshire | 4567 | 14 | 2 | 0 | 8 | 4766 | 4 | 0
Coos | 1478 | 17 | 7 | 2 | 11 | 2394 | 4 | 2
[NAME] | 5321 | 18 | 1 | 2 | 4 | 3824 | 7 | 1
Hillsborough | 21276 | 97 | 11 | 12 | 40 | 24919 | 21 | 7
Merrimack | 8145 | 27 | 3 | 1 | 16 | 9156 | 5 | 0
Rockingham | 16054 | 69 | 3 | 9 | 23 | 16572 | 18 | 7
[NAME] | 6659 | 33 | 2 | 0 | 10 | 8112 | 10 | 4
[NAME] | 2152 | 24 | 1 | 1 | 9 | 2349 | 1 | 0
TOTALS | 70502 | 322 | 30 | 29 | 134 | 76897 | 75 | 22
 | Harder, d | Koos, d | LaRouche, Jr. d | Mullins, d | O'Donnell, Jr., d | [NAME], d | Skok, d | [NAME], d
Belknap | 8 | 1 | 5 | 1 | 2 | 7 | 0 | 4
Carroll | 17 | 0 | 6 | 2 | 0 | 26 | 0 | 3
Cheshire | 8 | 1 | 4 | 2 | 1 | 5 | 0 | 3
Coos | 2 | 1 | 7 | 4 | 2 | 7 | 1 | 5
[NAME] | 16 | 1 | 4 | 2 | 0 | 6 | 1 | 3
Hillsborough | 36 | 11 | 47 | 6 | 17 | 43 | 8 | 31
Merrimack | 13 | 0 | 14 | 4 | 7 | 14 | 1 | 14
Rockingham | 41 | 3 | 28 | 7 | 3 | 29 | 5 | 13
[NAME] | 26 | 1 | 8 | 7 | 2 | 11 | 1 | 9
[NAME] | 25 | 0 | 1 | 0 | 1 | 8 | 1 | 2
TOTALS | 192 | 19 | 124 | 35 | 35 | 156 | 18 | 87
2 of 2 | PRESIDENT OF THE UNITED STATES
 | SUMMARY BY COUNTIES/DEMOCRATIC
 | Bauer, r | Berry, Jr., r | [NAME], r | Capalbo, r | Forbes, r | Harnes, r | Hatch, r | Keyes, r
Belknap | 0 | 0 | 49 | 0 | 63 | 0 | 0 | 29
Carroll | 0 | 0 | 19 | 0 | 13 | 0 | 0 | 7
Cheshire | 2 | 0 | 59 | 0 | 64 | 0 | 0 | 16
Coos | 2 | 0 | 36 | 0 | 59 | 0 | 0 | 20
[NAME] | 3 | 0 | 29 | 0 | 42 | 7 | 0 | 26
Hillsborough | 18 | 0 | 279 | 0 | 362 | 0 | 0 | 157
Merrimack | 1 | 0 | 74 | 0 | 113 | 0 | 0 | 43
Rockingham | 4 | 0 | 144 | 0 | 165 | 0 | 0 | 62
[NAME] | 13 | 0 | 99 | 0 | 79 | 0 | 0 | 55
[NAME] | 1 | 0 | 39 | 0 | 38 | 0 | 0 | 9
TOTALS | 44 | 0 | 827 | 0 | 998 | 7 | 0 | 424
 | Martin, r | [NAME], r | Mosby, r | Oyler, r | Peet, r | Yeager, r | [NAME]
Belknap | 0 | 229 | 0 | 0 | 0 | 0 | 2
Carroll | 0 | 80 | 0 | 0 | 0 | 0 | 11
Cheshire | 0 | 300 | 0 | 0 | 0 | 0 | 10
Coos | 0 | 124 | 0 | 0 | 0 | 0 | 7
[NAME] | 0 | 195 | 0 | 0 | 0 | 0 | 99
Hillsborough | 2 | 726 | 0 | 0 | 0 | 0 | 93
Merrimack | 0 | 403 | 0 | 0 | 0 | 0 | 68
Rockingham | 0 | 676 | 0 | 0 | 0 | 0 | 28
[NAME] | 0 | 390 | 0 | 0 | 0 | 0 | 22
[NAME] | 0 | 197 | 0 | 0 | 0 | 0 | 0
TOTALS | 2 | 3320 | 0 | 0 | 0 | 0 | 340
Spreadsheet: 234155e6-61c7-471c-a7ca-811f31424825
Sheet: Sheet1

Spend over £25,000 - Publication template | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  | Payment
Department family | Entity | Date | Expense type | Expense area | Supplier | Transaction number | Amount
DCMS | NMSI | 2011-08-04 00:00:00 | Maintenance | NRM Estates | Honeywell Controls Ltd | 143578 | 124645.99
DCMS | NMSI | 2011-08-02 00:00:00 | Equipment/Materials | [NAME] | Mindsets (UK) Limited | 143640 | 29379.1
DCMS | NMSI | 2011-08-18 00:00:00 | Rent | Science Museum Estates | The British Museum | 143650 | 46737.91
DCMS | NMSI | 2011-08-04 00:00:00 | Rates (CILOR) | Science Museum Estates | Royal Borough of Kensington & Chelsea | 143674 | 44938
DCMS | NMSI | 2011-08-18 00:00:00 | Maintenance | NRM Estates | Honeywell Controls Ltd | 143946 | 28746
DCMS | NMSI | 2011-08-04 00:00:00 | Electricity | Science Museum Estates | Natural History Museum | 144044 | 37112.54
DCMS | NMSI | 2011-08-04 00:00:00 | Electricity | Science Museum Estates | Natural History Museum | 144046 | 37996.05
DCMS | NMSI | 2011-08-04 00:00:00 | Electricity | Science Museum Estates | Natural History Museum | 144047 | 32213.16
DCMS | NMSI | 2011-08-04 00:00:00 | Electricity | Science Museum Estates | Natural History Museum | 144048 | 34628.38
DCMS | NMSI | 2011-08-04 00:00:00 | Electricity | Science Museum Estates | Natural History Museum | 144049 | 35519.15
DCMS | NMSI | 2011-08-04 00:00:00 | Electricity | Science Museum Estates | Natural History Museum | 144050 | 31661.32
DCMS | NMSI | 2011-08-18 00:00:00 | Build Construction | Science Museum Swindon Estates | [NAME] (Swindon) Limited | 144079 | 44712
DCMS | NMSI | 2011-08-09 00:00:00 | Equipment/Materials | York Brand | DB Schenker Rail UK Limited | 144320 | 38000
DCMS | NMSI | 2011-08-18 00:00:00 | Build Construction | York Major project | [NAME] | 144532 | 25531.01
DCMS | NMSI | 2011-08-18 00:00:00 | Profit Share | [NAME] | [NAME] | 103613 | 25175.36
Spreadsheet: 888143d1738587022-extract-multiple-employee-id-based-on-project-name-from-one-sheet-to-another-using-formula-sample_repivot_data
Sheet: Data

EMP ID | Name | Project
1401 | Name-1 | Project-1 | Project-2 | Project-3
 | [NAME] | Project-2 | Project-5 | Project-10 | Project-11
 | Name-3 | Project-1 | Project-3 | Project-9 | Project-10
 | Name-4 | Project-4 | Project-5 | Project-6 | Project-10
 | Name-5 | Project-2 | Project-5 | Project-10 | Project-11
 | Name-6 | Project-1 | Project-6 | Project-8 | Project-9
 | Name-7 | Project-12
 | Name-8 | Project-13 | Project-12
Spreadsheet: 139614d1328337304-excel-2010-bi-weekly-paycheck-tracker-income-calculator
Sheet: Jan 2012

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Made with [NAME]: | Calendar Creator Software
 | ◄ December |  |  |  | ~ January 2012 ~ |  |  |  |  |  |  |  | February ► |  |  |  |  |  |  |  |  |  |  |  | 2011 XLS Calendars
 | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  |  |  |  |  |  |  |  |  |  |  | 2012 XLS Calendars
 | 2012-01-01 00:00:00 |  | 2012-01-02 00:00:00 |  | 2012-01-03 00:00:00 |  | 2012-01-04 00:00:00 |  | 2012-01-05 00:00:00 |  | 2012-01-06 00:00:00 |  | 2012-01-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | XLS Calendar Templates
 | 2012-01-08 00:00:00 |  | 2012-01-09 00:00:00 |  | 2012-01-10 00:00:00 |  | 2012-01-11 00:00:00 |  | 2012-01-12 00:00:00 |  | 2012-01-13 00:00:00 |  | 2012-01-14 00:00:00
 | 2012-01-15 00:00:00 |  | 2012-01-16 00:00:00 |  | 2012-01-17 00:00:00 |  | 2012-01-18 00:00:00 |  | 2012-01-19 00:00:00 |  | 2012-01-20 00:00:00 |  | 2012-01-21 00:00:00
 | 2012-01-22 00:00:00 |  | 2012-01-23 00:00:00 |  | 2012-01-24 00:00:00 |  | 2012-01-25 00:00:00 |  | 2012-01-26 00:00:00 |  | 2012-01-27 00:00:00 |  | 2012-01-28 00:00:00
 |  |  |  |  |  |  |  |  | 8 |  | 8 |  | 8
 | 2012-01-29 00:00:00 |  | 2012-01-30 00:00:00 |  | 2012-01-31 00:00:00 |  | Notes:
 | 0 |  | 7.5 |  | 7.5
Spreadsheet: 115335d1310993654-look-up-formula-sample
Sheet: GBP £1bn Ref 004

 |  |  |  |  |  |  | othl04
Value Date | Maturity Date | Amount | Currency | Fee |  |  | Cert LLOY003
 |  |  |  |  |  |  | H117
2008-11-27 00:00:00 | 2011-11-28 00:00:00 | 1000000000 | GBP | 0.0089
Fee Accrual
Period Start | Period End | No. of Days | Period Accrual |  | Fee To Be Paid |  | Payment Date
Spreadsheet: 159264d1338563775-creating-a-quotation-by-selecting-items-on-another-page-in-the-same-workbook-poundsy-excelexamplequote
Sheet: rawdata

Parts Number | Description | Price
1 | A | 1
2 | B | 1.5
3 | C | 2
4 | D | 2.5
5 | E | 3
6 | F | 3.5
7 | G | 4
8 | H | 4.5
9 | I | 5
10 | J | 5.5
11 | K | 6
12 | L | 6.5
13 | M | 7
14 | N | 7.5
15 | O | 8
16 | P | 8.5
17 | Q | 9
18 | R | 9.5
19 | S | 10
20 | T | 10.5
21 | U | 11
22 | V | 11.5
23 | W | 12
24 | X | 12.5
25 | Y | 13
26 | Z | 13.5
27 | AA | 14
28 | AB | 14.5
29 | AC | 15
30 | AD | 15.5
31 | AE | 16
32 | AF | 16.5
33 | AG | 17
34 | AH | 17.5
35 | AI | 18
36 | AJ | 18.5
37 | AK | 19
38 | AL | 19.5
39 | AM | 20
40 | AN | 20.5
41 | AO | 21
42 | AP | 21.5
43 | AQ | 22
44 | AR | 22.5
45 | AS | 23
46 | AT | 23.5
47 | AU | 24
48 | AV | 24.5
49 | AW | 25
50 | AX | 25.5
Spreadsheet: 778933d1651471102-link-two-different-tables-together-over-1-code-that-exists-in-both-tables-find-codes-aligw
Sheet: Tabel 2

Code 2 | Street | # | City | Link | Code 1
 | [NAME] | 11 | Denver
123456789789 | [NAME] | 12 | Denver
123456789891 | [NAME] | 13 | Denver
123456789568 | [NAME] | 14 | Denver
Spreadsheet: 160182d1338998847-excel-2007-a-formula-calculates-a-cycle-open-and-close-same-day-an-extension-needed-different-day-spiros63_the_case_ron_v1b
Sheet: Testing

 | =IF($C7="","",IF(COUNT($G7:$H7),SUMIF($C$6:$C7,$C7,$E$6:$E7)*IF(INDEX($D$6:$D7,MATCH($C7,$C$6:$C7,0))="ã",1,-1)*(SUMIF($C$6:$C7,$C7,$G$6:$G7)-SUMIF($C$6:$C7,$C7,$F$6:$F7))-SUMIF($C$6:$C7,$C7,$H$6:$H7),""))
 | 2012-05-01 00:00:00
 | Date | Ascending Numbering | Direction | Amount  € | In | Out | Costs   € | P/L   €
 |  | 1 | ã | 100000 | 1.31 | 1.25 | 100
 |  | 2 | ä | 100000 | 1.31 | 1.25 | 100
 |  | 3 | ã | 100003 | 1.31
 |  | 3 |  |  |  | 1.25 | 100
 |  | 4 | ã | 100000 | 1.31 | 1.25 | 100
 |  | 5 | ä | 100000 | 1.31 | 1.25 | 100
 |  | 6 | ã | 100000 | 1.31 | 1.25 | 100
 |  | 7 | ä | 100000 | 1.31 | 1.25 | 100
 |  | 8 | ä | 100000 | 1.31 | 1.25 | 100
 |  | 9 | ä | 100000 | 1.31 | 1.25 | 100
 |  | 10 | ã | 100000 | 1.31 | 1.25 | 100
 |  | 11 | ã | 100003 | 1.31
 |  | 11 |  |  |  | 1.25 | 100
 |  | 12 | ã | 100000 | 1.31 | 1.25 | 100
 |  | 13 | ä | 100000 | 1.31 | 1.25 | 100
 |  | 14 | ã | 100000 | 1.31 | 1.25 | 100
 |  | 15 | ä | 100000 | 1.31 | 1.25 | 100
Spreadsheet: 145875d1331790808-transfer-data-from-one-sheet-to-another-when-specific-value-entered-in-first-sheet-example_2012_file
Sheet: Sept

Reporter | Date Rec. | Date Comp. | Witness | Description | Pages Rec | Pages Rtn | Job Type | Rate | Total | Tithe Amount | Tithed | Invoice # | Invoice Date | Date Paid | Monthly Tithe | Tithed MTD | Left to Tithe | Total | Amount Received | Total By Reporter | Amount Due | Amount Received
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jeanne
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Karisa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 467856d1467009038-extracting-the-count-based-on-several-conditions-file_requirement
Sheet: Sheet2

 | RESULT REQUIRED
 | CATEGORY OF CUSTOMER |  |  |  |  |  |  |  | BASE DATA
EMP | A | B | C | D |  |  |  |  | CATEGORY | COUNT OF TOTAL CUSTOMERS
1 | 27 | 30 | 18 | 29 |  |  |  |  | A | 8000
2 | 21 | 18 | 17 | 21 |  |  |  |  | B | 12000
3 | 10 | 18 | 10 | 28 |  |  |  |  | C | 9000
4 | 13 | 24 | 24 | 17 |  |  |  |  | D | 11000
5 | 23 | 12 | 18 | 29
6 | 13 | 29 | 13 | 26
7 | 27 | 11 | 23 | 18
8 | 16 | 16 | 27 | 16
9 | 25 | 13 | 20 | 27
10 | 13 | 26 | 25 | 28
11 | 24 | 12 | 14 | 29
12 | 12 | 20 | 25 | 22
13 | 14 | 12 | 24 | 26
14 | 28 | 22 | 20 | 27
15 | 30 | 27 | 30 | 13
16 | 12 | 25 | 18 | 21
17 | 13 | 13 | 15 | 17
18 | 17 | 18 | 14 | 28
19 | 11 | 25 | 12 | 20
Spreadsheet: 775968d1649419614-countif-with-a-unique-value-from-a-different-column-sample-unique_opens_countif
Sheet: Summary

 | delivered | opens | Unique | clicks | Unique
Total | 546575 |  | Opens |  | Clicks
2021/3 | 48631 |  |  | 209
2021/4 | 50019 |  |  | 18
2021/5 | 46539 |  |  | 9
2021/6 | 61425 |  |  | 14
2021/7 | 0 |  |  | 16
2021/8 | 60282 |  |  | 34
2021/9 | 58780 |  |  | 19
2021/10 | 59761 |  |  | 5
2021/11 | 30308 |  |  | 39
2021/12 | 60182 |  |  | 76
2022/1 | 31596 |  |  | 0
2022/2 | 39052 |  |  | 0
Spreadsheet: 03373572-eb03-4b04-a7a0-0e56c4e76134
Sheet: Sheet1

WEST VIRGINIA STATE UNIVERSITY
GUS R DOUGLASS INSTITUTE
[NAME]
For Credit Card
Card Holder/User Name: |  |  | Account Number:
DEPARTMENT/UNIT: |  |  | DATE:
 |  |  | PURCHASE DATE:
NAME & ADDRESS OF VENDOR:
PROGRAM FUND | DISCRETIONARY
Item Number | Quantity | Description | Unit Price | Amount
1 | 1 |  | 1532
2 | 2 |  | 5
3 | 43 |  | 5412
4 | 5 |  | 12
5 | 6 |  | 1245
6 | 7 |  | 213
7 | 9 |  | 123
8 | 0 |  | 123
9 | 12 |  | 123
TOTAL:
Explanation for Purchase:
Spreadsheet: 43202d1241781239-formula-help-till-ballance
Sheet: Sheet1

 |  | Float Balance
 |  | Float | [NAME] | Left | Needed | takings
 |  | 20 | 2 | 3 | 0 | 1
 |  | 10 | 1 | 5 | 0 | 4
 |  | 5 | 2 | 1 | 1 | -1
 |  | 1 | 10 | 1 | 9 | -9
 |  | 50p | 10 | 1 | 9 | -9
 |  | 20P | 10 | 1 | 9 | -9
 |  | 10P | 10 | 1 | 9 | -9
 |  | 5P | 10 | 1 | 9 | -9
 |  | 2P | 10 | 1 | 9 | -9
 |  | 1P | 10 | 1 | 9 | -9
 |  | Total Float | 78.8 | 116.88 | 21.92 | 38.08
Spreadsheet: 765933d1643679003-error-when-using-not-simple-defined-function-in-drop-down-list-drop-down-from-named-range-igoramdias-
Sheet: Sheet1

Value | 1 |  | 1
Value
Value
Value
Value
Value
Value
Profitability
Profitability
Profitability
Profitability
Profitability
Profitability
Growth
Growth
Growth
Growth
Growth
Growth
Growth
Spreadsheet: 20753000-33d3-4dfd-98b2-5059b634d32a
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 | 2005/06 | 2006/07 | 2007/08 | 2008/09 | 2009/10 | 2010/11 | 2011/12
 |  |  |  |  |  |  | 2/
TOTAL RICE |  |  |  | Million acres
Area:
Planted | 3.384 | 2.838 | 2.761 | 2.995 | 3.135 | 3.636 | 2.689
Harvested | 3.364 | 2.821 | 2.748 | 2.976 | 3.103 | 3.615 | 2.618
 |  |  |  | Pounds per harvested acre
Yield | 6624 | 6898 | 7219 | 6846 | 7085 | 6725 | 7067
 |  |  |  | Million cwt
Beginning stocks | 37.71 | 42.992 | 39.315 | 29.492 | 30.419 | 36.499 | 48.467
Production | 222.833 | 194.585 | 198.388 | 203.733 | 219.85 | 243.104 | 185.009
Imports | 17.134 | 20.581 | 23.9 | 19.218 | 19.019 | 18.336 | 20
Total supply | 277.677 | 258.158 | 261.603 | 252.443 | 269.288 | 297.939 | 253.5
Food, industrial,
& residual 3/ | 116.329 | 124.671 | 123.152 | 123.77 | 120.012 | 134.502
Seed | 3.503 | 3.408 | 3.697 | 3.87 | 4.488 | 3.324
Total domestic use | 119.832 | 128.079 | 126.849 | 127.64 | 124.5 | 137.826 | 124
Exports | 114.853 | 90.764 | 105.262 | 94.384 | 108.341 | 111.646 | 89
Rough | 33.449 | 32.112 | 37.663 | 31.633 | 40.351 | 34.896 | 31
Milled 4/ | 81.404 | 58.652 | 67.599 | 62.751 | 67.953 | 76.75 | 58
Total use | 234.685 | 218.843 | 232.111 | 222.024 | 232.841 | 249.472 | 213
Ending stocks | 42.992 | 39.315 | 29.492 | 30.419 | 36.499 | 48.46700000000004 | 40.5
 |  |  |  | Percent
Stocks-to-use ratio | 18.31902337175363 | 17.96493376530206 | 12.70598980660115 | 13.70077108781033 | 15.67550388462513 | 19.42783158029761 | 19
 |  |  |  | $/cwt
Average farm |  |  |  |  |  |  | 13.9
price 5/ | 7.65 | 9.96 | 12.8 | 16.8 | 14.4 | 12.7 | 14.5
 |  |  |  | Percent
Average
milling rate | 70.25 | 71 | 69.88 | 70.83 | 71.53 | 68.86 | 70
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 March 9, 2012.
Spreadsheet: 87480d1287372854-formula-chart-representing-percentages-book2
Sheet: Sheet1

Region | Number | NewRegion |  | Count of NewRegion
Japan | 2 | Japan |  | NewRegion | Total
Japan |  |  |  | Japan | 0.6
SE Asia | 4 | SE Asia |  | Korea | 0.2
Korea | 17 | Korea |  | SE Asia | 0.2
Japan | 8 | Japan |  | (blank) | 0
Japan |  |  |  | Grand Total | 1
Japan | 3 | Japan
Spreadsheet: 124115d1318136109-copying-a-formula-and-skipping-rows-columntorowindirect
Sheet: Sheet1

First | [NAME] |  | First | Last | City | State | Zip | Phone
Last | Doe |  |  |  |  |  |  |  | <<Look at these formulas and pull down.
City | Anytown
State | Anystate
Zip | 12345
Phone | [PHONE]
First | [NAME]
Last | Doe
City | Everytown
State | Everystate
Zip | 98765
Phone | [PHONE]
First | [NAME]
Last | Smith
City | Sometown
State | Somestate
Zip | 56473
Phone | [PHONE]
Spreadsheet: 772830d1647483188-retrieving-data-using-row-numbers-and-column-letters-sample-consecutive-scores
Sheet: Sheet1

Row Number | Score 1 | Score 2 | Score 3 |  | Score 1a | Score 2a | Score3a
 | 123 | 124 | 125 |  | 123 | 124 | 125
 | 130 | 115 | 114 |  | 145 | 147 | 125
 | 145 | 147 | 146
 | 134 | 190 | 100
 | 141 | 140 | 142
 | 123 | 124 | 125
 | 130 | 115 | 114
 | 145 | 147 | 146
 | 134 | 190 | 100
 | 141 | 140 | 142
 | 123 | 124 | 125
 | 130 | 115 | 114
 | 145 | 147 | 146
 | 134 | 190 | 100
 | 141 | 140 | 142
 | 120 | 119 | 118
 | 130 | 140 | 135
I want a formula that sees that Row E1 has something in it .
Then uses the row number  where this information was obtained  along with the column letter (i.e. B2) to come up with
the number in Column F.  Columns G and H would be the same formula except they would be using columns C and D.  I have manually input the information in Columns  F2 : H3 as examples.
Spreadsheet: 724692d1616322004-top-ten-scores-in-separate-list-testing
Sheet: Sheet1

 | Names | Week one | Week two | Week Three |  |  |  | Total |  | Top 10
 | D Frith | 15 | 14
 | P Carter | 15 | 12
 | T Seymore | 15 | 15
 | A Terry | 14 | 15
 | J Vince | 14 | 10
 | M Frith | 14 | 8
 | [NAME] | 12 | 8
 | M Micklefield | 12 | 10
 | K Ellis | 12 | 16
 | K Lester | 12 | 11
 | C Medlin | 12
 | K De Veen | 12 | 12
 | J Thompson | 12 | 12
 | K  Thompson | 12 | 14
 | G Godhard | 12 | 7
 | L Lester | 12 | 11
 | L Harvey | 10
 | DS [NAME] | 10 | 15
 | C Micklefield | 10 | 15
 | D Bridges | 10
 | H De Veen | 10 | 15
 | L Bray | 10 | 7
 | W Seymore | 10 | 11
 | M Bray | 10 | 7
 | G Atkinson | 10 | 11
 | [NAME] | 10 | 8
 | D Ebdon | 8 | 15
 | J Sunderland | 8 | 11
 | A Levelle | 8 | 7
 | B Green | 7 | 11
 | C Laverty | 7
 | D Colquhoun | 7 | 8
 | M Holmes |  | 15
 | K Burnam |  | 7
 | [NAME] |  | 8
Spreadsheet: 116131d1311617369-match-multiple-citeria-to-multiple-results-test
Sheet: Sheet1

Criteria 1 | [NAME] | Criteria 3 |  |  |  | 1-5 | 6-10 | 11-15 | 16-20 | 21-25
BB | 2 | 16-20 |  | AA | 1 | [NAME] | [NAME] | ggg | ggg | ggg
 |  |  |  | AA | 1 |  |  |  | hhh | hhh
 |  |  |  | AA | 2 |  |  |  |  | iii
 |  |  |  | BB | 2 | jjj | jjj | jjj | jjj | jjj
 |  |  |  | BB | 2 |  | lll | lll | lll | lll
 |  |  |  | BB | 3 |  |  |  | mmm | nnn
Matching the 3 criteria above to the table beside them would return results in J6 and [NAME] as both these cells cross reference using the same 3 criteria. The table will actually be on a different sheet, but to make it easier to read I have put everything on one sheet.
Spreadsheet: 37777d1235780229-count-the-occurence-of-a-value-across-multiple-worksheets-example1-a
Sheet: Summary

RANK | NAME |  | Candidates | Counts | Repetition | Unique
5101 | tortor vitae |  | fusce congue | 1 | 101 | 1101
4101 | vestibulum nisl |  | tortor vitae | 5 | 101 | 5101
2102 | felis condimentum |  | [NAME] | 2 | 101 | 2101
2101 | [NAME] |  | vestibulum nisl | 4 | 101 | 4101
1114 | [NAME] |  | placerat vitae | 1 | 102 | 1102
1113 | eget pretium |  | [NAME] | 1 | 103 | 1103
1112 | euismod rutrum |  | felis condimentum | 2 | 102 | 2102
1111 | vivamus ac |  | metus lectus | 1 | 104 | 1104
1110 | suspendisse condimentum |  | id magna | 1 | 105 | 1105
1109 | suscipit vehicula |  | risus nunc | 1 | 106 | 1106
1108 | est nec |  | mauris suspendisse | 1 | 107 | 1107
1107 | mauris suspendisse |  | est nec | 1 | 108 | 1108
1106 | risus nunc |  | suscipit vehicula | 1 | 109 | 1109
1105 | id magna |  | suspendisse condimentum | 1 | 110 | 1110
1104 | metus lectus |  | vivamus ac | 1 | 111 | 1111
1103 | [NAME] |  | euismod rutrum | 1 | 112 | 1112
1102 | placerat vitae |  | eget pretium | 1 | 113 | 1113
1101 | fusce congue |  | [NAME] | 1 | 114 | 1114
Spreadsheet: 202943d1356821015-explain-excel-sheets-formulas-sample
Sheet: Master

Seq | Name | ID | Total | A | B | C | D | E | F | G | H | I | J | L | Seq | 1
 | Name1 | 1 | 100
 | [NAME] | 2 | 300
 | [NAME] | 2 | 500
 | Name3 | 3 | 140
 | Name1 | 1 | 143
 | Name3 | 3 | 200
 | Name4 | 4 | 347
 | Name1 | 1 | 500
 | [NAME] | 2 | 260
 | Name4 | 4 | 367
Spreadsheet: 698806d1602183970-vlookup-via-dropdown-from-second-sheet-sampledata
Sheet: Sheet2

 | Example 1 | 12 Months | 2000
 | Example 2 | 13 Months | 2000
 | Example 3 | 14 Months | 2000
 | Example 4 | 15 Months | 2000
 | Example 5 | 16 Months | 2000
 | Example 6 | 17 Months | 2000
 | Example 7 | 18 Months | 2000
 | Example 8 | 19 Months | 2000
 | Example 9 | 20 Months | 2000
 | Example 10 | 21 Months | 2000
 | Example 11 | 22 Months | 2000
 | Example 12 | 23 Months | 2000
Spreadsheet: 7206eeea-92d9-4bd1-b2f7-3bf6ea9bee30
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Curb Records | 715187936126 | [NAME] | You [NAME] | 2014-08-19 | Compact Disc | Insp | 13.99 | Y | NYP
Word Records | 80688772222 | [NAME] | [NAME] | 2008-08-12 | Compact Disc | Insp | 9.99 | Y | Available
Special Markets Product Rec | 80688644826 | [NAME] | Duets Compilation | 2005-10-25 | Compact Disc | Insp | 9.99 | Y | Available
Word Records | 80688112028 | [NAME] | Hymns Just For You | 1990-10-24 | Compact Disc | Insp | 9.99 | Y | Available
Word Records | 80688112226 | [NAME] | More Than Wonderful | 1990-10-30 | Compact Disc | Insp | 9.99 | Y | Available
Curb Records | 715187871328 | [NAME] | Press On | 2001-05-29 | Compact Disc | Insp | 5.99 | Y | Available
Special Markets Product Rec | 80688786922 | [NAME] | Duets 2 | 2009-03-17 | Compact Disc | Insp | 9.99 | N | Available
Curb Records | 715187925021 | [NAME] | Hope Of The Broken World | 2011-08-23 | Compact Disc | Insp | 13.99 | Y | Available
Curb Records | 715187921627 | Dr. [NAME] | [NAME], The: The Definitive Collection | 2011-09-13 | Compact Disc | Insp | 24.98 | Y | Available
Curb Records | 715187913820 | [NAME] | You Deliver Me | 2009-08-25 | Compact Disc | Insp | 9.99 | Y | Available
Curb Records | 715187894426 | [NAME] | Bless The Broken Road: The Duets Album | 2006-08-08 | Compact Disc | Insp | 9.99 | Y | Available
Curb Records | 715187895225 | [NAME] | Shadow Of Your Wings: Hymns And [NAME], The | 2006-10-24 | Compact Disc | Insp | 9.99 | Y | Available
Word Records | 80688723323 | [NAME] | Voice, The | 2008-09-09 | Compact Disc | Insp | 13.99 | Y | Available
Word Records | 80688723224 | [NAME] | One Wintry Night: A [NAME] | 2007-09-25 | Compact Disc | Insp | 13.99 | Y | Available
Curb Records | 715187883420 | [NAME] | Hiding Place | 2004-05-25 | Compact Disc | Insp | 7.99 | Y | Available