tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: eric_saibi__9867__101701
Sheet: Braidwood 02 

Owner Name |  | Exelon Nuclear
Station Name |  | Braidwood Nuclear Power Station
Unit Name |  | Braidwood 02
NERC Region |  | MAIN
State |  | IL
Fuel Type |  | Nuclear
Capacity |  | 1,225 MW
Start Date |  | 2001-10-16 00:00:00
End Date |  | 2001-10-19 00:00:00
Comments |  | Unit is currently @ 65% for generator work.
SIC |  | 4931
Plant ID |  | 1016362
Unit ID |  | 1007402
Outage ID |  | 18678
Spreadsheet: 0d559763-5d18-41d8-aacd-eba6e073d806
Sheet: Hornet

Hornet
Place | Car # | Name | April 12th
1 | 17 | [NAME] | 69
2 | 48 | [NAME] | 65
3 | 30 | KC Scott | 59
4 | 46 | [NAME] | 40
Spreadsheet: 0dece6ba-9cbb-4708-b791-ffc172b18493
Sheet: December

 | SUNDAY
 |  | 2014-12-01 00:00:00 | 2014-12-02 00:00:00 | 2014-12-03 00:00:00 | 2014-12-04 00:00:00 | 2014-12-05 00:00:00 | 2014-12-06 00:00:00
 |  | 2014-12-08 00:00:00 | 2014-12-09 00:00:00 | 2014-12-10 00:00:00 | 2014-12-11 00:00:00 | 2014-12-12 00:00:00 | 2014-12-13 00:00:00
 |  | 2014-12-15 00:00:00 | 2014-12-16 00:00:00 | 2014-12-17 00:00:00 | 2014-12-18 00:00:00 | 2014-12-19 00:00:00 | 2014-12-20 00:00:00
 |  | 2014-12-22 00:00:00 | 2014-12-23 00:00:00 | 2014-12-24 00:00:00 | 2014-12-25 00:00:00 | 2014-12-26 00:00:00 | 2014-12-27 00:00:00
 |  |  |  | Campus files to CO by noon | Christmas | Delete Deadline 5pm
 |  | 2014-12-29 00:00:00 | 2014-12-30 00:00:00 | 2014-12-31 00:00:00 | 2015-01-01 00:00:00 | 2015-01-02 00:00:00 | 2015-01-03 00:00:00
 |  | ACH File to Treasury |  | Pay Day
 |  | 2015-01-05 00:00:00 | NOTES
Spreadsheet: 145630d1331667656-isolate-duplicates-in-column-b-if-column-a-also-duplicate-example
Sheet: Sheet1

Style | Size
1001 | small
1001 | medium
1001 | large
1002 | small
1002 | small
1002 | small
1003 | small
1003 | medium
1003 | large
1004 | medium
1004 | medium
1004 | medium
Spreadsheet: 052c3ddf-7624-400b-8d94-5066754d3191
Sheet: Sheet2

Grand Total
F
M
(blank)
W | White
Hispanics | Hispanic
B | African American
A | Asian
N | Native American
F | Filipino
P | Pacific Islander
Multi-Race | Multi-Race
 | Unknown
Spreadsheet: 99234d1297943733-why-doesnt-this-vlookup-work-test
Sheet: Journal

Transaction Code | Company Code | [NAME] | Reference | Document Date | Posting Date | Posting Period | Reversal Date | Translation Date | Currency | Document Type | Posting Key | Sp/GL Indicator | Account Number | Document Amount | Local    Amount | Group    Amount | Index    Amount | Business Area | Cost Center | Profit Center | Internal Order | WBS Element | Transaction Type | Intercompany Code | Trading Partner | Line Item Text | Assignment | Reference 1 | Reference 2 | Reference 3 | Settlement Period | Baseline Date
F-02 |  | Intercompany Interest Qtr4 | Enter Data | 31.03.2011 |  | 12 |  |  | USD | SI | 40 |  | 141250
 |  |  |  |  |  |  |  |  |  |  | 50 |  | 470300
 |  |  |  |  |  |  |  |  |  |  |  |  | 141250
 |  |  |  |  |  |  |  |  |  |  |  |  | 802400
Spreadsheet: 481912d1474739230-two-dimensional-lookup-return-column-header-two-dimensional-lookup
Sheet: Sheet1

 | M | N | O | P | Q | ERROR |  | Type | Value | Expected
A | 10 | 20 | 30 | 40 | 50 | 999999 |  | C | 2010 | N
B | 100 | 200 | 300 | 400 | 500 | 999999
C | 1000 | 2000 | 3000 | 4000 | 5000 | 999999
D | 10000 | 20000 | 30000 | 40000 | 50000 | 999999
return column header where cell value does not exceed 'value' and 'type' match column A
Spreadsheet: 159094d1338492383-vlookup-help-sample
Sheet: Sales Raw

Employee Name | Sales | New Accounts | Weekending
Store 1 | 12 | 17 | 2012-03-04 00:00:00
Store 2 | 1 | 98 | 2012-03-04 00:00:00
Store 3 | 8 | 18 | 2012-03-04 00:00:00
Store 4 | 2 | 18 | 2012-03-04 00:00:00
Store 5 | 3 | 28 | 2012-03-04 00:00:00
Store 6 | 12 | 52 | 2012-03-04 00:00:00
Company | 38 | 231 | 2012-03-04 00:00:00
[NAME] | 0 | 11 | 2012-03-04 00:00:00
[NAME] | 0 | 21 | 2012-03-04 00:00:00
[NAME] | 0 | 0 | 2012-03-04 00:00:00
[NAME] | 0 | 0 | 2012-03-04 00:00:00
Store 1 | 5 | 12 | 2012-03-11 00:00:00
Store 2 | 4 | 31 | 2012-03-11 00:00:00
Store 3 | 3 | 23 | 2012-03-11 00:00:00
Store 4 | 5 | 15 | 2012-03-11 00:00:00
Store 5 | 7 | 19 | 2012-03-11 00:00:00
Store 6 | 18 | 49 | 2012-03-11 00:00:00
Company | 42 | 149 | 2012-03-11 00:00:00
[NAME] | 0 | 10 | 2012-03-11 00:00:00
[NAME] | 2 | 7 | 2012-03-11 00:00:00
[NAME] | 0 | 0 | 2012-03-11 00:00:00
[NAME] | 0 | 0 | 2012-03-11 00:00:00
Store 1 | 4 | 11 | 2012-03-18 00:00:00
Store 2 | 3 | 6 | 2012-03-18 00:00:00
Store 3 | 0 | 11 | 2012-03-18 00:00:00
Store 4 | 4 | 17 | 2012-03-18 00:00:00
Store 5 | 6 | 18 | 2012-03-18 00:00:00
Store 6 | 8 | 40 | 2012-03-18 00:00:00
Company | 25 | 103 | 2012-03-18 00:00:00
[NAME] | 4 | 9 | 2012-03-18 00:00:00
[NAME] | 3 | 6 | 2012-03-18 00:00:00
[NAME] | 0 | 0 | 2012-03-18 00:00:00
[NAME] | 0 | 0 | 2012-03-18 00:00:00
Spreadsheet: 820337d1678035424-display-best-to-worst-exit-template-test_03
Sheet: Test_03

 |  |  |  | 5M
 |  |  |  | SHIFTS | TRUE
 |  |  |  | Wins | VBC | LC | 70/30 | 60/40 | SL | ↑ Value | Losses
 |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  | x
 |  |  |  |  |  |  | 0 |  |  |  | x
 |  |  |  | x | 0.5 | 0.25
 |  |  |  | x |  |  | 0.1
 |  |  |  | x |  |  | 0 | 0.1
 |  |  |  | x | 0.75 | 0.23 | 0
 |  |  |  | x
 |  |  |  |  | 0.35 | 0.15 |  |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  |  | 0.47 | 0.21 |  |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  |  | 0.57 | 0.12 |  |  |  |  | x
 |  |  |  | x
 |  |  |  | x | 0.87 | 0.13 |  |  | -0.1
 |  |  |  | x
 |  |  |  | x | 0.93 | 0.56
 |  |  |  | x
 |  |  |  | WINS | VBC | LC | 70/30 | 60/40 | SL | ↑ Value | LOSSES
 |  | Totals
 |  |  | High Success |  |  |  |  |  |  |  | BEST EXIT
 |  |  | Low Success |  |  |  |  |  |  |  | Highest
 |  |  | Best Return |  |  |  |  |  |  |  | 2nd Highest
 |  |  | Least Return |  |  |  |  |  |  |  | 3rd Highest
 |  |  | Total Plays |  |  |  |  |  |  |  | Lowest
 |  |  | % Per Play |  |  |  |  |  |  |  | <--Avg. %
 |  |  | Total - SL
Spreadsheet: ae1ea98a-7205-4697-95f6-e1b078078354
Sheet: Sheet1

2. Agriculture Management Entities | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
(by nationwide agricultural regions)
(6) Number of Agriculture Management Entities engaged in Sustainable Agriculture
 |  |  |  |  |  |  |  |  |  | Unit: management entities
Agricultural Regions |  |  |  |  | Management Entities engaged in Sustainable Agriculture | Reducing Use of Chemical Fertilizers |  | Reducing Use of Agricultural Chemicals |  | Using Compost in Soil Preparation
 |  |  |  |  |  | Yes | No | Yes | No | Yes | No
Nationwide |  |  |  |  | 828753 | 585101 | 243652 | 671637 | 157116 | 465114 | 363639
 | Hokkaido |  |  |  | 32981 | 25619 | 7362 | 25432 | 7549 | 24099 | 8882
 | Prefectures |  |  |  | 795772 | 559482 | 236290 | 646205 | 149567 | 441015 | 354757
 | Tohoku |  |  |  | 165088 | 121208 | 43880 | 133241 | 31847 | 98005 | 67083
 | Hokuriku |  |  |  | 73008 | 60565 | 12443 | 64269 | 8739 | 30250 | 42758
 | Kanto / Tozan |  |  |  | 168812 | 111739 | 57073 | 134373 | 34439 | 101100 | 67712
 |  | Northern Kanto |  |  | 65812 | 44409 | 21403 | 53123 | 12689 | 36743 | 29069
 |  | Southern Kanto |  |  | 58448 | 35279 | 23169 | 46057 | 12391 | 35867 | 22581
 |  | Tozan |  |  | 44552 | 32051 | 12501 | 35193 | 9359 | 28490 | 16062
 | Tokai |  |  |  | 70394 | 48775 | 21619 | 59282 | 11112 | 32966 | 37428
 | Kinki |  |  |  | 74253 | 53806 | 20447 | 62582 | 11671 | 35003 | 39250
 | Chugoku |  |  |  | 67791 | 44667 | 23124 | 54961 | 12830 | 35732 | 32059
 |  | Sanin |  |  | 21838 | 14855 | 6983 | 17369 | 4469 | 11363 | 10475
 |  | Sanyo |  |  | 45953 | 29812 | 16141 | 37592 | 8361 | 24369 | 21584
 | Shikoku |  |  |  | 44956 | 29207 | 15749 | 37470 | 7486 | 21472 | 23484
 | Kyushu |  |  |  | 123895 | 84594 | 39301 | 94829 | 29066 | 81801 | 42094
 |  | Northern Kyushu |  |  | 84206 | 59015 | 25191 | 66739 | 17467 | 51671 | 32535
 |  | Southern Kyushu |  |  | 39689 | 25579 | 14110 | 28090 | 11599 | 30130 | 9559
 | [NAME] |  |  |  | 7575 | 4921 | 2654 | 5198 | 2377 | 4686 | 2889
Spreadsheet: 856398d1705654711-formula-in-excel-book1
Sheet: Sheet1

Sales201 | 11
Sales421 | 55
Sales201 | 125.1211
Sales345 | 10
Sales201 | 100
Sales201 | 1000
Spreadsheet: 672071d1586712369-adding-variable-number-of-cells-without-n-a-ever-showing-adding
Sheet: Sheet2

 | Equipment | Weight | Cost | batteries |  |  | etc..
1 | Flashlight | 10 | 30 | 2
2 | screw | 1 | 2 | 0
3 | bolts | 1.5 | 2 | 0
4 | drill | 25 | 50 | 5
5 | padding | 3 | 4 | 0
6 | nail | 1 | 2 | 0
Spreadsheet: 605717d1547226556-applying-multiple-formulas-to-multiple-columns-ot-version-1
Sheet: Sheet2

Code: | Reason:
A | Shutdown
B | Start Up
C | Cores
D | Clean Broke
E | Replace Vacation
F | Two Hour Call
G | Four hour call
H | Foam Floors
I | Six hour call (Felt Change)
J | Seven hour call
K | Water Bottles
L | Felt Guiding
M
Spreadsheet: 682178d1591955499-determine-if-all-criteria-fit-between-numerial-ranges-for-excel-and-google-sheets-test-1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1
name1 | [NAME] | 2 | 2 | [NAME] | 2 | 2 | item2 | 1 | 4 | NO MATCH |  | item2 | 2
[NAME] | [NAME] | 1 | 1 | item2 | 1 | 4 | item3 | 1 | 4 | NO MATCH |  | item3 | 6
name3 | item2 | 3 | 3 | [NAME] | 2 | 2 | item4 | 1 | 3 | NO MATCH |  | item4 | 0
name4 | [NAME] | 1 | 2 | item3 | 5 | 8 | item2 | 2 | 3 | MATCH |  | [NAME] | 2
name5 | [NAME] | 1 | 4 | item2 | 1 | 4 | item3 | 1 | 4 | NO MATCH
Spreadsheet: 737926d1624676314-top-10-but-only-newest-data-testbook
Sheet: Data

Jalika | Elf | 1750 | 2020-12-21 00:00:00
[NAME] | [NAME] | 1380 | 2021-02-02 00:00:00
[NAME] | [NAME] | 1351 | 2021-02-10 00:00:00
[NAME] | [NAME] | 1350 | 2021-02-02 00:00:00
Maltris | Elf | 1277 | 2021-03-12 00:00:00
Xelten | Elf | 1004 | 2021-02-02 00:00:00
[NAME] | Human | 1004 | 2021-02-10 00:00:00
Antharos | Gor'Tog | 958 | 2021-02-02 00:00:00
Brahmer | Elf | 925 | 2020-10-21 00:00:00
[NAME] | Elf | 50 | 2020-05-05 00:00:00
[NAME] | [NAME] | 1510 | 2021-06-23 00:00:00
Spreadsheet: 798512f1-d34c-422a-a60a-472bfadc4afb
Sheet: Sheet1

CHILTERN DISTRICT COUNCIL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
FULL PLANS SUBMISSION Building Act 1984 Building Regulations 2010
To |  |  |  |  |  | FOR OFFICIAL USE ONLY
BuildingControl Division |  |  |  |  |  | Dep Fee |  | Building Regulations Plan No.
CHILTERN DISTRICT COUNCIL |  |  |  |  |  | Invoice No
KiNG [NAME] |  |  |  |  |  | Invoice Date
KING GEORGE V ROAD |  |  |  |  |  | CBCO
AMERSHAM    BUCKS   HP6  5AW |  |  |  |  |  | Inspect Fee
Tele: (01494) 732249  Direct Line Answer phone (01494) 732911   Fax No. (01494) 732911 |  |  |  |  |  |  |  | http://www.chiltern.gov.uk/
1 | Applicant's details
 | Name:
 | Address:
 | E Mail : |  |  |  | Postcode |  |  | [NAME]
2 | Agents details (if Applicable)
 | Name:
 | Address:
 | E Mail : |  |  |  | Postcode |  |  | [NAME]
3 | Location to which work relates
 | Address:
 |  |  |  |  | Postcode |  |  | [NAME]
4 | Proposed Work
 | Description
5 | Use of Building
 | 1. If new building or extension please state proposed use.
 | 2. If existing building please state present use.
 | 3.Is the building used or to be put to a  use that is not solely a dwelling ? |  |  |  |  |  |  | Yes/No
6 | Initial Charge ( see [NAME] on Charges for information )
 | Domestic Work (Table A) state floor area: |  |  |  |  | [NAME]. (A1) state cat No. from table
 | New Dwellings Table B or other detail :
 | Non Domestic Table C state category from table:
 | Note if a quote is to be provided then further info may be required |  |  |  |  |  | Initial Charge : £
7 | Additional Information
 | Method of Drainage Disposal: (I.e. to Public Sewer, Septic Tank, Soakaway etc. ) |  |  |  | a:   [NAME]
 |  |  |  |  | b:   Surface Water.
8 | Extension of Time Do you consent to an automatic extension of time if required  (Y/N)
9 | Conditions Do you consent to the plans being passed subject to conditions  (Y/N)
10 | Electrical/Gas Works
 | If a registered competent installer is not to be used the supplementary charge will be applicable
 | Is a registered competent installer to be used?      Y/N
11 | Statement
 | This notice, is given in relation to the building work as describedand is submitted in accordance with
 | Regulation 12(2)(b) and is accompanied by the Initial Charge
 | Name: |  |  | Signature: |  |  |  | Date:
 | DATA PROTECTION ACT  Chiltern District Council is a Data Controller under the Data Protection Act.  We hold information for the purposes specified in our notification to the Information Commissioner and may use this information for any of them.  We may get information about you from others, or we may give information to them.  If we do it will only be as the law permits, to check the accuracy of information, prevent fraud or detect crime or to protect public funds.  Chiltern District Council conforms to the requirements of the Data Protection Act 1998.  The information requested herewith is required under The Building Regulations 2010 and The Building (Local Authority Charges) Regulations 2010.
Spreadsheet: 675149d1588176517-i-need-some-help-with-an-index-and-match-function-tracker-excel-blank-etaf
Sheet: Sheet 1

 |  |  | Date
 |  |  |  |  |  |  | 2020-04-20 00:00:00 | 2020-04-21 00:00:00 | 2020-04-22 00:00:00 | 2020-04-23 00:00:00 | 2020-04-24 00:00:00 | 2020-04-25 00:00:00 | 2020-04-26 00:00:00 | 2020-04-27 00:00:00 | 2020-04-28 00:00:00 | 2020-04-29 00:00:00 | 2020-04-30 00:00:00 | 2020-05-01 00:00:00 | 2020-05-02 00:00:00 | 2020-05-03 00:00:00 | 2020-05-04 00:00:00 | 2020-05-05 00:00:00 | 2020-05-06 00:00:00 | 2020-05-07 00:00:00 | 2020-05-08 00:00:00 | 2020-05-09 00:00:00 | 2020-05-10 00:00:00 | 2020-05-11 00:00:00 | 2020-05-12 00:00:00 | 2020-05-13 00:00:00 | 2020-05-14 00:00:00 | 2020-05-15 00:00:00 | 2020-05-16 00:00:00 | 2020-05-17 00:00:00 | 2020-05-18 00:00:00 | 2020-05-19 00:00:00 | 2020-05-20 00:00:00 | 2020-05-21 00:00:00 | 2020-05-22 00:00:00 | 2020-05-23 00:00:00 | 2020-05-24 00:00:00 | 2020-05-25 00:00:00 | 2020-05-26 00:00:00 | 2020-05-27 00:00:00 | 2020-05-28 00:00:00 | 2020-05-29 00:00:00 | 2020-05-30 00:00:00 | 2020-05-31 00:00:00 | 2020-06-01 00:00:00 | 2020-06-02 00:00:00 | 2020-06-03 00:00:00 | 2020-06-04 00:00:00 | 2020-06-05 00:00:00 | 2020-06-06 00:00:00 | 2020-06-07 00:00:00 | 2020-06-08 00:00:00 | 2020-06-09 00:00:00 | 2020-06-10 00:00:00 | 2020-06-11 00:00:00 | 2020-06-12 00:00:00 | 2020-06-13 00:00:00 | 2020-06-14 00:00:00 | 2020-06-15 00:00:00 | 2020-06-16 00:00:00 | 2020-06-17 00:00:00 | 2020-06-18 00:00:00 | 2020-06-19 00:00:00 | 2020-06-20 00:00:00 | 2020-06-21 00:00:00 | 2020-06-22 00:00:00 | 2020-06-23 00:00:00 | 2020-06-24 00:00:00 | 2020-06-25 00:00:00 | 2020-06-26 00:00:00 | 2020-06-27 00:00:00 | 2020-06-28 00:00:00 | 2020-06-29 00:00:00 | 2020-06-30 00:00:00 | 2020-07-01 00:00:00 | 2020-07-02 00:00:00 | 2020-07-03 00:00:00 | 2020-07-04 00:00:00 | 2020-07-05 00:00:00 | 2020-07-06 00:00:00 | 2020-07-07 00:00:00 | 2020-07-08 00:00:00 | 2020-07-09 00:00:00 | 2020-07-10 00:00:00 | 2020-07-11 00:00:00 | 2020-07-12 00:00:00
Project ID | Project Name | Project Size | Start Date | End Date |  | Allocation
123456 | Test 1 | S | 2020-04-01 00:00:00 | 2020-06-30 00:00:00
Stage 1 |  | S | 2020-04-27 00:00:00 | 2020-05-02 00:00:00
Stage 2 |  | S | 2020-05-05 00:00:00 | 2020-05-17 00:00:00
Stage 3 |  | S | 2020-05-18 00:00:00 | 2020-05-20 00:00:00
Stage 4 |  | S | 2020-05-21 00:00:00 | 2020-05-22 00:00:00
Stage 5 |  | S | 2020-05-24 00:00:00 | 2020-05-30 00:00:00
234567 | Test 2 | M | 2020-04-21 00:00:00 | 2020-05-21 00:00:00
Stage 1 |  | M | 2020-04-23 00:00:00 | 2020-04-24 00:00:00
Stage 2 |  | M | 2020-04-26 00:00:00 | 2020-04-27 00:00:00
Stage 3 |  | M | 2020-04-28 00:00:00 | 2020-05-03 00:00:00
Stage 4 |  | M | 2020-05-04 00:00:00 | 2020-05-14 00:00:00
Stage 5 |  | M | 2020-05-14 00:00:00 | 2020-05-21 00:00:00
Spreadsheet: daren_farmer__5027__HPLN0327
Sheet: Sheet1

HPLN0327.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - March 27, 2001
 |  |  |  |  |  | **Tuesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-03-27 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | Oasis Sealy |  | Enron | 20 | 10
Enron (ES) |  | Oasis Sealy |  | Enron | 5 | 0
Enron (S) |  | LS HPL [NAME] |  | Enron | 0 | 25
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 94068d1293877513-data-validation-book1
Sheet: Sheet3

 | EMU | 60 Class | 100 | 200 | 120 | 220 | 160 | 260
 | 1 | 60 | 101 | 201 | 121 | 221
 | 2 | 61 | 102 | 202 | 122 | 222
 | 3 | 62 | 103 | 203 | 123 | 223
 | 4 | 63 | 104 | 204 | 124 | 224
 | 5 | 64 | 105 | 205 |  | 225
 | 6 | 65 | 106 | 206 |  | 226
 | 7 | 66 | 107 | 207 |  | 227
 | 8 | 67 | 108 | 208 |  | 228
 | 9 | 68 | 109 | 209 |  | 229
 | 10 | 69 | 110 | 210 |  | 230
 | 11 | 70 |  | 211 |  | 231
 | 12 | 71 |  | 212 |  | 232
 | 13 | 72 |  |  |  | 233
 | 14 | 73 |  |  |  | 234
 | 15 | 74 |  |  |  | 235
 | 16 | 75 |  |  |  | 236
 | 17 | 76 |  |  |  | 237
 | 18 | 77 |  |  |  | 238
 | 19 | 78 |  |  |  | 239
 | 20 | 79 |  |  |  | 240
 | 21 |  |  |  |  | 241
 | 22 |  |  |  |  | 242
 | 23 |  |  |  |  | 243
 | 24 |  |  |  |  | 244
 | 25 |  |  |  |  | 245
 | 26 |  |  |  |  | 246
 | 27 |  |  |  |  | 247
 | 28 |  |  |  |  | 248
 | 29 |  |  |  |  | 249
 | 30 |  |  |  |  | 250
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 80
 | 81
 | 82
 | 83
 | 84
 | 85
 | 86
 | 87
 | 88
Spreadsheet: gerald_nemec__11465__10 00 noms
Sheet: .

 | FIRST OF THE MONTH NOMS
 | 2000-10-01 00:00:00
 |  |  |  | WELLHEAD
 | WELL NAME |  | METER # | MMBTU/D
 | DAKOTA
 | Blackhorse 31-1 |  | 30139 |  |  | SA #4 | 87
 | Federal Gilbert |  | 9564 |  |  | SA #17 | 4
 | San Arroyo #3 |  | 9860 |  |  | SA #18 | 31
 | San Arroyo #4 |  | 401040 |  |  | SA #21 | 59
 | San Arroyo #8 |  | 401080 |  |  | SA #24 | 57
 | San Arroyo #9 |  | 401090 |  |  | SA #26 | 46
 | San Arroyo #11 |  | 401110 |  |  | SA #27 | 22
 | San Arroyo #12 |  | 401120 |  |  | SA #28 | 41
 | San Arroyo #13 |  | 401130 |  |  | SA #30 | 38
 | San Arroyo #16 |  | 401160 |  |  | SA #3 | 64
 | San Arroyo #17 |  | 401170 |  |  | SA #35 | 55
 | San Arroyo #18 |  | 401180 |  |  | SA #36 | 35
 | San Arroyo #19 |  | 401190 |  |  | SA #37 | 25
 | San Arroyo #20 |  | 401200 |  |  | SA #12 | 123
 | San Arroyo #21 |  | 401210 |  |  | SA #16 | 110
 | San Arroyo #24 |  | 401240 |  |  | SA #20 | 44
 | San Arroyo #25 |  | 401250 |  |  | ROUTE #1 TOTAL
 | San Arroyo #26 |  | 401260
 | San Arroyo #27 |  | 401270 |  |  | SA #8 | 84
 | San Arroyo #28 |  | 401280 |  |  | SA #9 | 179
 | San Arroyo #29 |  | 401290 |  |  | SA #11 | 287
 | San Arroyo #30 |  | 401300 |  |  | SA #13 | 88
 | San Arroyo #31 |  | 401310 |  |  | SA #19 | 79
 | San Arroyo #33 |  | 401330 | 0 |  | SA #22 | 48
 | San Arroyo #35 |  | 401350 |  |  | SA #25 | 386
 | San Arroyo #36 |  | 401360 |  |  | SA #29 | 25
 | San Arroyo #37 |  | 401370 |  |  | SA #31 | 13
 | San Arroyo #38 |  | 401380 |  |  | SA #32 | 31
 | San Arroyo #174 |  | 401410 |  |  | SA #38 | 375
 | Arco 27-1 |  | 401420 |  |  | FED 174-1 | 48
 | Bittercreek #1 |  | 401440 |  |  | BITTERCREEK#1 | 163
 | San Arroyo #22 |  | 501220 |  |  | FEDERAL GILBERT | 123
 | San Arroyo #32 |  | 501320 |  |  | ARCO 36-7 | 67
 | Arco State #2-1 |  | 501650 |  |  | ARCO 36-8 | 26
 | Arco State #2-2 |  | 501660 |  |  | ARCO 2-1 | 83
 | Arco 36-7 |  | 501670 |  |  | ARCO 2-2 | 30
 | Arco 36-8 |  | 501680 |  |  | BLACKHORSE 31-1 | 37
 |  |  | TOTAL: |  |  | ARCO 27-1 | 23
 |  |  |  |  |  | ROUTE #2 TOTAL
Spreadsheet: 152894d1335569473-nested-if-function-to-determine-a-winner-s-and-losers-e08m1minigolf
Sheet: Summary

Round | Jon | [NAME] | [NAME] | Midge
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Spreadsheet: 38359d1236523133-how-many-items-per-month-and-average-accounts
Sheet: Sheet1

 |  |  |  | 2008 | June
 |  |  | [NAME] | Unique list code | Unique list produce | Total units | Average cost per purchase | Average cost per unit
 |  |  | 195 | 9 | Electricity | 1 | 525 | 525
 |  |  | 194 | 55 | Newspaper | 1 | 107 | 107
 |  |  | 193 | 82 | Santharaj | 1 | 1000 | 1000
 |  |  | 192 | 81 | Travel Expenses | 1 | 1250 | 1250
 |  |  | 191 | 12 | House Rent | 1 | 2500 | 2500
 |  |  | 188 | 21 | Sugar | 2 | 34 | 17
 |  |  | 187 | 17 | Potatoes | 3 | 48 | 16
 |  |  | 185 | 16 | Onions Sm | 1 | 16 | 16
 |  |  | 184 | 13 | [NAME] | 10 | 255 | 25.5
 |  |  | 174 | 52 | Hair Cutting | 4 | 80 | 20
 |  |  | 169 | 51 | Ginger | 1 | 31 | 31
 |  |  | 157 | 46 | Gooseberry | 1 | 25 | 25
 |  |  | 154 | 80 | School Fees | 5 | 235 | 47
 |  |  | 153 | 40 | Snack Items | 1 | 56 | 56
 |  |  | 121 | 45 | [NAME] | 1 | 40 | 40
 |  |  | 93 | 43 | [NAME] | 1 | 28 | 28
 |  |  | 84 | 79 | [NAME] | 5 | 200 | 40
 |  |  | 82 | 54 | Car Rent | 2 | 375 | 375
 |  |  | 80 | 39 | [NAME] | 2 | 48.5 | 48.5
 |  |  | 79 | 15 | Onions Lrg | 5 | 29.33333333333333 | 17.6
 |  |  | 67 | 42 | Cumin | 1 | 25 | 25
 |  |  | 66 | 10 | [NAME] | 1 | 20 | 20
 |  |  | 58 | 41 | Mango | 3 | 40 | 40
 |  |  | 46 | 78 | [NAME] | 1 | 63 | 63
 |  |  | 45 | 38 | Egg | 4 | 56.125 | 56.125
 |  |  | 44 | 37 | Curd | 4 | 20 | 20
 |  |  | 43 | 36 | Tomato | 3 | 19 | 19
 |  |  | 40 | 35 | [NAME] | 2 | 9 | 9
 |  |  | 36 | 34 | Hospital Fees | 2 | 102 | 102
 |  |  | 24 | 100 | [NAME] | 7 | 424.8571428571428 | 424.8571428571428
 |  |  | 21 | 77 | Breakfast | 9 | 90.77777777777777 | 90.77777777777777
 |  |  | 15 | 75 | Mobile Charge | 4 | 50 | 50
 |  |  | 14 | 33 | Coriander | 2 | 96 | 48
 |  |  | 13 | 6 | [NAME] | 2 | 158 | 79
 |  |  | 12 | 32 | Cake | 2 | 92.5 | 92.5
 |  |  | 11 | 31 | Lemon | 1 | 30 | 30
 |  |  | 10 | 30 | Fish | 17 | 102.9411764705882 | 102.9411764705882
 |  |  | 9 | 29 | Coconut | 25 | 28.24 | 28.24
 |  |  | 8 | 76 | Vegetables | 27 | 33.51851851851852 | 33.51851851851852
 |  |  | 7 | 28 | Photo | 1 | 550 | 550
 |  |  | 5 | 27 | Biscuits | 17 | 26.84615384615385 | 20.52941176470588
 |  |  | 4 | 14 | Milk | 180 | 57 | 9.5
 |  |  | 3 | 26 | Chicken | 5 | 364 | 364
 |  |  | 2 | 25 | Parotte | 175 | 262.5 | 3
 |  |  | 1 | 24 | Donation | 0 | 0 | #N/A
Spreadsheet: 92751d1292310529-using-countifs-on-entries-in-multiple-columns-pm-chart-trial
Sheet: Spot PM count

Using formulas
 | 2010
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
TR
BL
 | 2011
 | Jan
Hand Counting
 | 2010
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
TR |  |  |  | 13 | 5 | 7 | 10 | 21 | 10 | 2 | 2
BL |  |  |  | 18 | 12 | 13 | 24 | 52 | 22 | 2 | 8