tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 677576d1589403227-pivot-table-filter-1-
Sheet: SHEET 1

DATE | Description | Money in | Money Out | MONEY IN REASON | MONEY OUT REASON
2020-03-17 00:00:00 | CARD PAYMENT TO MAGNET ACTURIS RECEIPT,579.03 GBP, RATE 1.00/GBP ON 13-03-2020 |  | 45
2020-03-14 00:00:00 | CARD PAYMENT TO TFL TRAVEL CH,3.00 GBP, RATE 1.00/GBP ON 12-03-2020 |  | 3 |  | NON
2020-03-02 00:00:00 | DIRECT DEBIT PAYMENT TO VIRGIN MEDIA PYMTS REF 214427, MANDATE NO 0021 |  | 30
2020-03-02 00:00:00 | DIRECT DEBIT PAYMENT TO BRITISH GAS REF 123456, MANDATE NO 0075 |  | 50
2020-03-02 00:00:00 | DIRECT DEBIT PAYMENT DERPE, MANDATE NO 0026 |  | 60
2020-02-03 00:00:00 | DIRECT DEBIT PAYMENT DERPE, MANDATE NO 0026 |  | 60
2020-02-03 00:00:00 | DIRECT DEBIT PAYMENT TO VIRGIN MEDIA PYMTS REF 214427, MANDATE NO 0021 |  | 30
2020-02-03 00:00:00 | DIRECT DEBIT PAYMENT TO BRITISH GAS REF 123456, MANDATE NO 0075 |  | 50
2019-12-24 00:00:00 | CARD PAYMENT TO ISLEWORTH,9.99 GBP, RATE 1.00/GBP ON 21-12-2019 |  | 9.99 |  | REPAIRS 38
2019-12-18 00:00:00 | CARD PAYMENT TO FIREPROTECT,75.05 GBP, RATE 1.00/GBP ON 15-12-2019 |  | 15 |  | REPAIRS 38
Spreadsheet: 298909d1392939281-getting-the-average-of-only-some-columns-excelforum
Sheet: XXXZZZ

 |  |  |  |  | XXX   10/15/2013 | XXX   11/7/2013 | XXX   11/12/2013 | YYY   11/15/2013 | YYY   11/26/2013 | YYY   12/3/2013 | ZZZ  12/5/2013 | ZZZ  12/19/2013 | ZZZ  1/9/2014 | YYY  1/22/2013 | YYY   2/4/2013 | Coming Soon | Coming Soon | Coming Soon | Coming Soon | Coming Soon | Coming Soon | Coming Soon | Coming Soon | Coming Soon | Coming Soon | Coming Soon | Coming Soon | Coming Soon
xyz
Dear Ford,  Notice at the top there is text in the first cells that indicate three catagories of data in the the colums. The colums are either "XXX" "YYY" or " columns.  I need to be able to grab all of the "ZZZ" scores (from row) 22 and show their average on the side of my sheet somewhere.   Is there a function/formula to do this dynamically?   thx very much |  |  |  |  | 3 | 5 | 4 | 5 | 5 | 3 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  | 2 | 5 | 4 | 5 | 5 | 2 | 2 | 2 | 2 | 2 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XXXaverage
 |  |  |  |  | 2 | 5 | 4 | 5 | 5 | 2 | 4 | 7 | 4 | 4 | 8
 |  |  |  |  | 2 | 5 | 3 | 5 | 5 | 2 | 1 | 4 | 4 | 4 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YYYaverage
 |  |  |  |  | 2 | 5 | 3 | 5 | 5 | 2 | 4 | 4 | 4 | 4 | 4
 |  |  |  |  | 4 | 5 | 3 | 5 | 5 | 4 | 4 | 4 | 4 | 9 | 9
 |  |  |  |  | 1 | 5 | 3 | 5 | 5 | 1 | 1 | 7 | 4 | 4 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZZZaverage
 |  |  |  |  | 1 | 5 | 3 | 4 | 1 | 1 | 4 | 4 | 4 | 4 | 4
 |  |  |  |  | 1 | 5 | 3 | 5 | 1 | 1 | 4 | 4 | 4 | 4 | 4
 |  |  |  |  | 1 | 5 | 2 | 1 | 5 | 1 | 1 | 1 | 1 | 9 | 9
 |  |  |  |  | 1 | 5 | 2 | 1 | 5 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  | 3 | 5 | 2 | 1 | 5 | 3 | 1 | 1 | 1 | 1 | 2
 |  |  |  |  | 4 | 3 | 2 | 1 | 3 | 4 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  | 4 | 3 | 2 | 3 | 3 | 4 | 1 | 1 | 1 | 1 | 8
score  ▶
Spreadsheet: daren_farmer__6549__HL&PMTD
Sheet: Jan 00

HL&P MONTH TO DATE
 | NOMS |  |  |  |  |  |  |  |  |  |  |  |  |  | BAV FLOW
 |  |  |  |  |  |  |  |  |  |  |  |  | NOM |  |  |  |  |  |  |  |  |  | BAV
 | 7268 |  |  |  |  |  | 1554 |  | 1554 |  | 1554 |  | TOTAL |  | 1393 | 1396 | 1401 | 1412 | 1480 |  | 1554 |  | TOTAL |  | DIFF.
 | 3rd Party |  | HPL Spot |  |  |  | HPL |  | HPL SPOT |  | 3rd Party
2000-01-01 00:00:00 | 0 |  | 10000 |  |  |  | 34567 |  | 0 |  | 0 |  |  |  | 0 | 0 | 12884 | 0 | 0 |  | 31074
2000-01-02 00:00:00 | 0 |  | 10000 |  |  |  | 34567 |  | 0 |  | 0 |  |  |  | 0 | 0 | 13494 | 0 | 0 |  | 30436
2000-01-03 00:00:00 | 0 |  | 10000 |  |  |  | 34567 |  | 0 |  | 0 |  |  |  | 0 | 0 | 13945 | 0 | 0 |  | 31044
2000-01-04 00:00:00 | 0 |  | 0 |  |  |  | 34567 |  | 0 |  | 0 |  |  |  | 0 | 0 | 123 | 0 | 0 |  | 33595
2000-01-05 00:00:00 | 15000 |  | 0 |  |  |  | 34567 |  | 0 |  | 0 |  |  |  | 0 | 0 | 4180 | 0 | 10940 |  | 33032
2000-01-06 00:00:00 | 0 |  | 0 |  |  |  | 34567 |  | 0 |  | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 32370
2000-01-07 00:00:00 | 0 |  | 0 |  |  |  | 34567 |  | 0 |  | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 34799
2000-01-08 00:00:00 | 0 |  | 0 |  |  |  | 34567 |  | 0 |  | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 31261
2000-01-09 00:00:00 | 0 |  | 0 |  |  |  | 34567 |  | 0 |  | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 32690
2000-01-10 00:00:00 | 0 |  | 0 |  |  |  | 34567 |  | 0 |  | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 31584
2000-01-11 00:00:00 | 0 |  | 0 |  |  |  | 34567 |  | 0 |  | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 30390
2000-01-12 00:00:00 | 0 |  | 0 |  |  |  | 34567 |  | 0 |  | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 32435
2000-01-13 00:00:00 | 0 |  | 0 |  |  |  | 34567 |  | 0 |  | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 35157
2000-01-14 00:00:00 | 0 |  | 0 |  |  |  | 34567 |  | 0 |  | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 36068
2000-01-15 00:00:00 | 0 |  | 0 |  |  |  | 34567 |  | 0 |  | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 34455
2000-01-16 00:00:00 | 0 |  | 0 |  |  |  | 34567 |  | 0 |  | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 33403
2000-01-17 00:00:00 | 0 |  | 0 |  |  |  | 34567 |  | 0 |  | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 34027
2000-01-18 00:00:00
2000-01-19 00:00:00
2000-01-20 00:00:00
2000-01-21 00:00:00
2000-01-22 00:00:00
2000-01-23 00:00:00
2000-01-24 00:00:00
2000-01-25 00:00:00
2000-01-26 00:00:00
2000-01-27 00:00:00
2000-01-28 00:00:00
2000-01-29 00:00:00
2000-01-30 00:00:00
2000-01-31 00:00:00
DAY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All 3rd Party is kept
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | whole.
Spreadsheet: 104930d1302382672-totals-across-16-sheets-lineup4
Sheet: Season Batting Order

Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Garrett
[NAME]
Jonah
[NAME]
Kort
[NAME]
Lukas
Tyler
Kyler
Stuart
[NAME]
Keaton
Spreadsheet: 226950d1365544334-overall-sheet-pulling-in-info-from-multiple-workbooks-sample-sheet-for-help-forum-mar-2013
Sheet: Legend

No intervention needed | Patient | Male | 1 | 2 | Yes | Tablets | No action needed | Jan 13 | 1 | 1 | GP | Bellbrooke | Recent discharge letter not actioned | Ordered at time of collection | Phoned through to Pharmacy | 0-10 | 0-5
Drug quantity aligned to 28 days | Carer | Female | 1 | 2 | No | Capsules | Pharmacist appt arranged | Feb 13 | 5 | 2 | Practice Pharmacist | Lincoln Green | Irregular ordering | 1 week before due | Phoned through to Surgery | 11-20 | 6-10
Drug quantity aligned to 56 days | Care Home |  | 1 | 2 |  | Liquid | GP appt arranged | [NAME] 13 | 7 | 3 | Practice nurse | Lingwell Croft | Overordering | Never | Repeat dropped into Pharmacy | 21-30 | 11-15
Drug quantity aligned to other days | Pharmacy |  | 1 | 2 |  | [NAME] | Nurse appt arranged | Apr 13 | 14 | 4 | Other | Lofthouse | Underordering | Other | Repeat dropped into Surgery | 31-40 | 16-20
Drug put into past drugs | Other |  | 1 | 2 |  | Suppositories | Bloods arranged | May 13 | 21 | 5 |  | New Cross | Not ordered for a while |  | Surgery website | 41-50 | 21-25
Drug not issued as patient confirmed no longer uses | Other |  | 1 | 2 |  | Nebules | Bloods arranged | Jun 13 | 21 | 5 |  | New Cross | Not ordered for a while |  | Other | 51-60 | 26-30
Other |  |  | 1 | 2 |  | Injections | Drugs amended | Jul 13 | 42 | 7 |  | Oulton |  |  |  | 61-70 | 31-35
 |  |  | 1 | 2 |  | Ostomy | Other | Aug 13 | 14 | 4 | Other | Lofthouse | Underordering | Other | Repeat dropped into Surgery | 71-80 | 36-40
 |  |  | 1 | 2 |  | Catheters |  | Sep 13 | 84 | 9 |  | Shaftesbury |  |  |  | 81-90 | 41-45
 |  |  | 1 | 2 |  | Ointment |  | Oct 13 | 100 | 10 |  | [NAME] |  |  |  | 91-100 | 46-50
 |  |  | 1 | 2 |  | Cream |  | Nov 13 | 112 | 11 |  |  |  |  |  | 101-110
 |  |  | 1 | 2 |  | Gel |  | Dec 13 | 168 | 12
 |  |  | 1 | 2 |  | Drops |  |  | 200 | 13
 |  |  | 1 | 2 |  | Other |  |  | 224 | 14
 |  |  | 1 | 2 |  |  |  |  | 300 | 15
 |  |  | 1 | 2 |  |  |  |  | 500 | 16
 |  |  | 1 | 2 |  |  |  |  | 1000 | 17
 |  |  | 1 | 2 |  |  |  |  |  | 18
 |  |  | 1 | 2 |  |  |  |  |  | 19
 |  |  | 1 | 2 |  |  |  |  |  | 20
 |  |  | 1 | 2 |  |  |  |  |  | 21
 |  |  | 1 | 2 |  |  |  |  |  | 22
 |  |  | 1 | 2 |  |  |  |  |  | 23
 |  |  | 1 | 2 |  |  |  |  |  | 24
 |  |  | 1 | 2 |  |  |  |  |  | 25
 |  |  | 1 | 2 |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  |  |  | 28
Spreadsheet: f94639f4-871c-4ce0-a813-d7233eab1c77
Sheet: Sheet1

Name | Add1 | CSZ | phone | fax | e-mail | [NAME]
Commonwealth Tennis |  |  | [PHONE] |  | [EMAIL] | [NAME]
Sports Fun | 68 Parkman Street #1 | Brookline, MA 02446 | [PHONE] |  | [EMAIL] | [NAME]
Sports Fun | 68 Parkman Street #1 | Brookline, MA 02446 | [PHONE] |  | [EMAIL] | [NAME]
Mount Auburn Tennis Club | 57 Coolidge Ave. | Watertown, MA  02472 | [PHONE] |  | [EMAIL]
Net Results Tennis | 51 Boulder Rd | Wellesley Hills, [NAME] | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Suburban Athletic Club | 10 Roxanna Street | Framingham, MA  01702 | [PHONE]
The Longfellow Club | 524 Boston Post Road | Wayland, MA  01778 | [PHONE] |  | the longfellow club
USA Tennis New England | 110 Turnpike Road | Westborough, MA  01581 | [PHONE] |  | [EMAIL]
[NAME] | 134 West Street | Waltham, MA  02451 | [PHONE] |  | [EMAIL]
Spreadsheet: darrell_schoolcraft__7249__saledoc02_11TW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Astra Power
Deal Date: |  |  | 2002-02-11 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 2002-02-11 00:00:00 |  |  | FAX Number:
Total Quantity |  |  | 20000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 2.08
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
2/11/2002 | 2002-02-11 00:00:00 | 20000 |  | 20000 |  | 20000
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
WT Pool |  |  | 58646 |  | 20000 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
[NAME] [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 1f6d2297-fcce-401a-b618-9716a1585068
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42850873 | 2014-08-23 21:53:36 | ALLIES | 1 | 5 | 1 | 614490 | [NAME] | 6156 | western | 1944-09-17 | 1944-09-19 | [NAME] | [NAME]
42851069 | 2014-08-23 22:09:32 | AXIS | 0 | 3 | 5 | 614490 | [NAME] | 6156 | western | 1944-09-17 | 1944-09-19 | [NAME] | [NAME]
42851310 | 2014-08-23 22:21:08 | ALLIES | 1 | 5 | 4 | 923434 | [NAME] | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
42851452 | 2014-08-23 22:29:53 | AXIS | 0 | 1 | 5 | 923434 | [NAME] | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
Spreadsheet: 198716d1354876890-how-auto-filter-auto-filter
Sheet: Sheet1

kam
Name | Amount
kam | 1
lion | 2
shel | 3
lion | 2
kam | 5
shel | 4
lion | 8
kam | 9
shel | 1
lion | 3
shel | 4
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 24 Jan 2012

Daily Morning Staff |  |  |  |  | Tuesday
 | 07:30-14:30 |  | 2012-01-24 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Ralation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS
[NAME] | 4143 | Aircraft Team Leader | 07:00:00 | 14:30:00 | EFS
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME]
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: 44210d1242843173-excel-2007-compatability-issue-testing
Sheet: SEPT_OCT

No. | Date | PURCHASES | AMOUNT |  | ELECTRONICS | GROCERY | BOOKS AND [NAME] | MISCELLEANOUS | PETROL
 |  |  | 306.65 |  | 140.46 | 164.39 | 0 | 20 | 0
3 | 2009-09-16 00:00:00 | FOOD LION #1454 RALEIGH NC | 11.24 |  | 0 | 11.24 | 0 | 0 | 0
4 | 2009-09-17 00:00:00 | BIG LOTS #[PHONE] RALEIGH NC | 13.97 |  | 0 | 13.97 | 0 | 0 | 0
5 | 2009-09-22 00:00:00 | MARLIN P JONES & ASSOC [PHONE] FL | 50.05 |  | 50.05 | 0 | 0 | 0 | 0
6 | 2009-09-24 00:00:00 | [NAME] RALEIGH NC | 18.2 |  | 0 | 36.4 | 0 | 0 | 0
7 | 2009-09-24 00:00:00 | NCSU ALL CAMPUS MICROS RALEIGH NC | 2.19 |  | 0 | 2.19 | 0 | 0 | 0
8 | 2009-09-25 00:00:00 | FOOD LION #1454 RALEIGH NC | 23.17 |  | 0 | 23.17 | 0 | 0 | 0
9 | 2009-09-27 00:00:00 | ALMANDINA SUPER MARKET RALEIGH NC | 6.6 |  | 0 | 6.6 | 0 | 0 | 0
10 | 2009-09-29 00:00:00 | FOOD LION #1454 RALEIGH NC | 12.68 |  | 0 | 12.68 | 0 | 0 | 0
11 | 2009-09-30 00:00:00 | NCSU ALL CAMPUS MICROS RALEIGH NC | 1.18 |  | 0 | 1.18 | 0 | 0 | 0
12 | 2009-10-01 00:00:00 | NCSU ALL CAMPUS MICROS RALEIGH NC | 2.34 |  | 0 | 2.34 | 0 | 0 | 0
13 | 2009-10-04 00:00:00 | ALMANDINA SUPER MARKET RALEIGH NC | 22.56 |  | 0 | 22.56 | 0 | 0 | 0
14 | 2009-10-06 00:00:00 | BURGER KING #4521 Q07 RALEIGH NC | 10.8 |  | 0 | 10.8 | 0 | 0 | 0
15 | 2009-10-06 00:00:00 | NCSU ALL CAMPUS MICROS RALEIGH NC | 1.42 |  | 0 | 1.42 | 0 | 0 | 0
16 | 2009-10-06 00:00:00 | NCSU ALL CAMPUS MICROS RALEIGH NC | 0.6 |  | 0 | 0.6 | 0 | 0 | 0
17 | 2009-10-07 00:00:00 | PAYPAL *[NAME] | 15.75 |  | 15.75 | 0 | 0 | 0 | 0
18 | 2009-10-07 00:00:00 | NCSU ALL CAMPUS MICROS RALEIGH NC | 2.34 |  | 0 | 2.34 | 0 | 0 | 0
19 | 2009-10-08 00:00:00 | PAYPAL *IWANNEBUY [PHONE] CA | 11.31 |  | 11.31 | 0 | 0 | 0 | 0
20 | 2009-10-08 00:00:00 | NCSU ALL CAMPUS MICROS RALEIGH NC | 2.34 |  | 0 | 2.34 | 0 | 0 | 0
21 | 2009-10-09 00:00:00 | SIX TWELVE CONVENI RALEIGH NC | 1.05 |  | 0 | 1.05 | 0 | 0 | 0
22 | 2009-10-09 00:00:00 | PAYPAL *NJLASZ [PHONE] CA | 10.99 |  | 10.99 | 0 | 0 | 0 | 0
23 | 2009-10-09 00:00:00 | [NAME] | 20 |  | 0 | 0 | 0 | 20 | 0
24 | 2009-10-11 00:00:00 | ALLIED ELECTRONICS INC [PHONE] TX | 39.53 |  | 39.53 | 0 | 0 | 0 | 0
25 | 2009-10-11 00:00:00 | PAYPAL *WIDGETSUPPL [PHONE] OR | 6.38 |  | 6.38 | 0 | 0 | 0 | 0
26 | 2009-10-11 00:00:00 | PAYPAL *[NAME] CA | 6.45 |  | 6.45 | 0 | 0 | 0 | 0
27 | 2009-10-12 00:00:00 | BIG LOTS #[PHONE] RALEIGH NC | 7.44 |  | 0 | 7.44 | 0 | 0 | 0
28 | 2009-10-14 00:00:00 | FOOD LION #1454 RALEIGH NC | 6.07 |  | 0 | 6.07 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0
Spreadsheet: 49987d1249403802-excel-2007-excel-2007-chart-bug-template
Sheet: Grupo 1

Total Respostas | % Favorável | % Neutro | % Desfavorável |  |  |  | Favorável | [NAME] | Desfavorável |  |  |  | % Favorável | % Neutro | % Desfavorável
 |  |  |  |  |  | g1p1 | 205 | 44 | 9
 |  |  |  |  |  | g1p2 | 203 | 43 | 12
 |  |  |  |  |  | g1p3 | 208 | 42 | 8
 |  |  |  |  |  | g1p4 | 178 | 61 | 19
 |  |  |  |  |  | g1p5 | 194 | 54 | 10
 |  |  |  |  |  | g1p6 | 258 | 28 | 2
 |  |  |  |  |  | g1p7 | 183 | 56 | 19
Spreadsheet: 879522d1727098455-conditional-formatting-formula-based-on-two-criteria-time-or-space-jay325-sample1c
Sheet: Solution

 |  | Location
Time |  | 11
09:00:00 | 09:59:00
00:00:00
Spreadsheet: 34872d1232274884-max-function-counting-rows-example-rating1
Sheet: Sheet1

Race No. | Horse | API | Rating
1 | A | 3.1 | 3.444444444444445
1 | B | 4.1 | 4.555555555555555
1 | C | 3 | 3.333333333333333
1 | D | 6 | 6.666666666666666
1 | E | 7.8 | 8.666666666666668
1 | F | 9 | 10
1 | G | 2 | 2.222222222222222
2 | H | 3 | 3.79746835443038 | Here's where the problem is ie: I have to manually change the formula at this point to recognise the new race (race 2) and the fact there is not a consistent number of rows in each set of rows for each race….
2 | I | 4 | 5.063291139240506
2 | J | 5 | 6.329113924050632
2 | K | 3 | 3.79746835443038
2 | L | 4.2 | 5.316455696202532
2 | M | 6 | 7.594936708860759
2 | N | 7.8 | 9.873417721518987
2 | O | 7.9 | 10
2 | P | 4.5 | 5.696202531645569
3 | Q | 3 | 6 | And same here……….
3 | R | 4 | 8
3 | S | 5 | 10
3 | T | 3 | 6
3 | U | 4.2 | 8.4
3 | V | 3 | 6
3 | W | 4 | 8
3 | X | 5 | 10
3 | Y | 3 | 6
3 | Z | 4.2 | 8.4
Spreadsheet: 77289d1277799839-sumif-and-countif-and-omitting-blanks-example
Sheet: Sheet1

 | Project | Code | %
 | test project 1 | FI | 100
 | test project 2 | EI | 25
 | test project 3 | FI | 50
 | test project 4 | FI
 | test project 5 | EI | 35
 | test project 6 | FI | 25
 |  |  | 43.75
 | Code to filter on |  | FI
Spreadsheet: kim_ward__20823__DWP Gas Assets
Sheet: Pricing & Purchase Strategy

City of Los Angeles
Department of Water & Power
Union Pacific Fuels Gas Supply Contract
Price Determination; Purchase Strategy
Effective Date: |  | 1993-07-01 00:00:00
Term: | 15 Years
Contract Price = A * B / C, where
A = Monthly Base Price
B = Current Month Gas Price Index
C = Monthly Base Gas Price Index
Maximum Daily Quantity (MDQ): |  |  |  | 50900 | MMBtu/d
Minimum Monthly Purchase Obligation: |  |  |  |  | Greater of 70% of MDQ or Nominated Quantity
Demand Charge: |  |  |  |  | 0.03
Price Discount (purchases > 70% of MDQ): |  |  |  |  | 0.015
Twice/Mth Buyer, with 3 days notice, may reduce Nominations, subject to Minimum Purchase
Increasing Nomination is subject to Approval of Seller
Purchase Strategy:  [NAME] or Minimum Daily Quantity
 | A | C | A / C
Month | Monthly | Monthly | Monthly | Demand | Discount | Price | Price | UPF | Valuation @ | 3 | per [NAME]
 | Base | Base | Index | Charge | Applied | Relative | Relative | Purchase | 100% UPF; | 70% UPF: | Benefit | Purchase
 | Price | Gas Price | Adder | Applied | to Takes > | to Index | to Index | Strategy | 0% Market | 30% Market | of | Cost @
 | $/MMBtu | Index | (A / C) | to MDQ | 70% MDQ | @ 100% LF | @ 70% LF | (% of MDQ) | Purchase | Purchase | Strategy | Index
 |  | $/MMBtu |  |  |  |  |  |  | @ Index | @ Index
Jan | 2.08 | 2.06
Feb | 1.53 | 1.51
Mar | 1.2 | 1.18
Apr | 1.15 | 1.12
May | 1.12 | 1.1
Jun | 1.13 | 1.11
Jul | 1.19 | 1.17
Aug | 1.14 | 1.11
Sep | 1.17 | 1.15
Oct | 1.3 | 1.28
Nov | 1.63 | 1.61
Dec | 1.68 | 1.65
TOTAL:
Year | Discount | Cash | Discounted | Cumulative
 | Factor | Flow | Cash | Discounted
 | 0.05 |  | Flow | Cash
 |  |  |  | Flow
2000
2001
2002
2003
2004
2005
2006
2007
2008
Spreadsheet: 327681d1403642694-using-data-validation-to-pull-information-from-another-spreadsheet-excel-test
Sheet: Training History

name | Underwater Course 1 |  |  | Underwater Course 2
 | requirement | completed | due | requirement | completed | due
bob | annual | 2014-03-11 00:00:00 |  | annual | 2014-02-11 00:00:00
[NAME] | annual | 2014-03-12 00:00:00 |  | annual | 2014-02-12 00:00:00
sue | annual | 2014-03-13 00:00:00 |  | annual | 2014-02-13 00:00:00
[NAME] | annual | 2014-03-14 00:00:00 |  | annual | 2014-02-14 00:00:00
Spreadsheet: 865466d1712554912-choosecols-and-filter-test
Sheet: Ram

 |  | 616658945 | [NAME] (616658945) | 0 | 430281.17 | 391185 | 39096.17 |  |  | 39096.17
 |  | Bimal Chiya Packaging Udhyog | Simal Kiya Packaging Udhyog(2Ledger1PKS-302501791) | 307875.76 | 161375.88 | 0 | 469251.64 |  |  | 469251.64
 |  | 301501891 | Dimal Food Product,ahari (301501891) | 593120.65 | 330857.11 | 593121 | 330856.76 |  |  | 593120.65
 |  | 302263185 | Food Packaging Udhyog,[NAME] (302263185) | 0 | 267296.2 | 310871 | -43574.8 | 8 |  | 0
 |  | Mainik [NAME] | Mainik [NAME] | 54 | 0 | 100000 | -100000 | 26 |  | 0
 |  | Dakshesh Agro Pvt Ltd | Dakshesh Agro Pvt Ltd | 0 | 0 | 327000 | -327000 | 5 |  | 0
 |  | 608620093 | Elanta Health Care And Hyginene Products (608620093) | 2173.68 | 0 | 0 | -82173.68 |  |  | -82173.68
 |  |  | [NAME]. Ltd. | 12 | 0 |  | 256 |  |  | 12
Spreadsheet: 228396d1366107360-create-criteria-based-summary-table-from-table-rows-across-sheets-sample_summaryproblem_b
Sheet: Subsheet1 (3)

Sheet info line 1
Sheet info line 2
Table headline
No. | T | A | Misc1 | Misc2 | Misc3 | Misc4 | Misc5 | Misc6 | Misc7 | R | D | RI | Type | Status | Type2 | Status2 | [NAME] | Status3 |  | Type | Status
0101 | R1 | A1 |  |  |  |  |  |  |  |  |  |  | P | BR | P | FR | P | BR |  | P | BR
0102 | R2 | A2 |  |  |  |  |  |  |  |  |  |  | P | BR | P | BR | A | BR |  | A | FR
0103 | R3 | A3 |  |  |  |  |  |  |  |  |  |  | P | BR | P | FR
0104 | R4 | A4 |  |  |  |  |  |  |  |  |  |  | P | FR
0105 | R5 |  |  |  |  |  |  |  |  |  |  |  | P | BR | P | BR
0106 | R6 | A6 |  |  |  |  |  |  |  |  |  |  | P | BR | A | BR | P | FR
0107 | R7 | A7 |  |  |  |  |  |  |  |  |  |  | P | BR
0108 | R8 | A8 |  |  |  |  |  |  |  |  |  |  | P | FR | A | BR | P | FR
0109 | R9 | A9
0110 | R10 | A10
0111 | R11 | A11 |  |  |  |  |  |  |  |  |  |  | P | BR | P | FR
0112 | R12 | A12
 | Total
Irrelevant table
Random1 | Random12 | Random2 | Random3 | Random4
Random1
Random2
Random3
Random4
Random5
Random6
Random7
Random8