tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 472025d1469407026-converting-data-between-tabs-department-performance
Sheet: 149798

TEAM
149798 |  | [NAME]
 |  |  | RCV Goal = 30 PPH |  |  | FH Goal = 30 PPH |  |  | [NAME] = 20 PPH
Week |  |  | RCV Qty | RCV Time | RCV PPH | FH  Qty | FH  Time | FH  PPH | RCH  Qty | RCH  Time | RCH  PPH | Average PPH | Total Time | Notes
2016-07-03 00:00:00 | - |  | 367 | 13.28 |  | 286 | 12.31 |  | 222 | 8.26
2016-07-10 00:00:00 | - |  | 653 | 21.15 |  | 41 | 3.26 |  | 0 | 0
2016-07-17 00:00:00 | -
2016-07-24 00:00:00 | -
2016-07-31 00:00:00 | -
2016-08-07 00:00:00 | -
2016-08-14 00:00:00 | -
2016-08-21 00:00:00 | -
2016-08-28 00:00:00 | -
2016-09-04 00:00:00 | -
2016-09-11 00:00:00 | -
2016-09-18 00:00:00 | -
2016-09-25 00:00:00 | -
2016-10-02 00:00:00 | -
2016-10-09 00:00:00 | -
2016-10-16 00:00:00 | -
2016-10-23 00:00:00 | -
2016-10-30 00:00:00 | -
2016-11-06 00:00:00 | -
2016-11-13 00:00:00 | -
2016-11-20 00:00:00 | -
2016-11-27 00:00:00 | -
2016-12-04 00:00:00 | -
2016-12-11 00:00:00 | -
2016-12-18 00:00:00 | -
2016-12-25 00:00:00 | -
 |  | TOTAL
Spreadsheet: 176057d1345720593-graph-help-please-graph-1-
Sheet: Week on Week

Week # | Items | cost | profit | [NAME]
Week 13 | [NAME] | 612 | 464.6644000000001 | 68
 | [NAME] ECLIPSE | 76.64 | 90.02640000000001 | 8
Week 14 | DVS DULLY TANK | 45.5 | 30.33290000000001 | 13
 | ETN KICK IT | 44 | 84.33260000000001 | 22
Spreadsheet: 830982d1685343270-how-to-use-xlookup-with-a-max-date-criteria-sample-1-aligw
Sheet: Sheet1

source Table |  |  |  |  |  | Result | Result
[NAME] | Value | Value Date |  |  | [NAME] | Value | Value Date |  |  |  |  |  |  |  |  |  |  |  | Value | Value Date | <<<<< AliGW Original
21185 | -1.27 | 2020-12-12 00:00:00 |  |  | 21185 |  | 2020-12-12 00:00:00 |  | Column G and H are the two data I want from the source data from the source table |  |  |  |  |  |  |  |  | 21185 | -1.27 | 2020-12-12 00:00:00
21185 | -0.25 | 2020-10-21 00:00:00 |  |  | 21219 | -1.1 | 2020-12-12 00:00:00 |  |  |  |  |  |  |  |  |  |  | 21219 | -1.1 | 2020-12-12 00:00:00
21185 | -0.25 | 2020-09-30 00:00:00 |  |  | 24011 | -0.95 | 2020-11-10 00:00:00 |  |  |  |  |  |  |  |  |  |  | 24011 | -0.95 | 2020-11-10 00:00:00
21219 | -1.1 | 2020-12-12 00:00:00 |  |  | 24015 | -0.45 | 2020-04-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 24015 | -0.45 | 2020-04-04 00:00:00
21219 | -0.4 | 2020-08-29 00:00:00 |  |  | 24031 | 0.111 | 2020-09-30 00:00:00 |  |  |  |  |  |  |  |  |  |  | 24031 | 0.111 | 2020-09-30 00:00:00
21219 | -1.29 | 2020-04-11 00:00:00
21219 | 0 | 2020-03-05 00:00:00
24011 | -0.95 | 2020-11-10 00:00:00
24011 | 0 | 2020-09-30 00:00:00
24011 | -0.52 | 2020-02-20 00:00:00
24015 | -0.43 | 2020-02-20 00:00:00
24015 | -0.45 | 2020-04-04 00:00:00
24031 | -0.38 | 2020-03-28 00:00:00
24031 | 0.111 | 2020-09-30 00:00:00
24031 | -0.71 | 2020-05-18 00:00:00
21182
21216
24014
24015
24031
Spreadsheet: 846891d1698048633-find-the-sum-and-number-of-numbers-in-variable-intervals-data
Sheet: Sheet1

 | Data |  |  | Result
 | Number | Range |  | Count | Sum
 | 1 | A |  | 5 | 15
 | 2
 | 3
 | 4
 | 5
 | 6 | B |  | 4 | 30
 | 7
 | 8
 | 9
 | 10 | C |  | 8 | 108
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18 | D |  | 3 | 57
 | 19
 | 20
 |  | end
Spreadsheet: 140827d1328901149-splitting-amount-into-individual-cells-starting-from-the-right-messybutworks
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stripped to digits only from Accounting format number | [NAME]
 | 98765412
 | 1678987456
 | 1
 | 100
 | 10000671
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *Note: You can only copy formulas down the column not across!
Spreadsheet: 0f1f7833-0537-44d1-a158-126a5c6b18b8
Sheet: T73

الجدول 73: أسباب الوفيات المسجلة في قطر
Table 73: Registered deaths by cause in Qatar
قطر | 2000 |  |  | 2005 |  |  | آخر سنة متوفرة - 2011
QATAR |  |  |  |  |  |  | Latest available - 2011
سبب الوفاة (1) | مجموع | ذكور | اناث | مجموع | ذكور | اناث | مجموع | ذكور | اناث
Cause of death (1) | Total | Male | Female | Total | Male | Female | Total | Male | Female
1 | 47 | 35 | 12 | 12 | 7 | 5 |  | 12 | 11
2 | 129 | 63 | 66 | 162 | 102 | 60 |  | 111 | 87
3 | 75 | 43 | 32 | 109 | 56 | 53 |  | 78 | 81
4 | 8 | 4 | 4 | 11 | 7 | 4 |  | 5 | 3
5 | 5 | 2 | 3 | - | - | - | - | - | -
6 | 20 | 7 | 13 | 15 | 9 | 6 |  | 17 | 11
7 | 350 | 250 | 100 | 314 | 203 | 111 |  | 168 | 69
8 | 51 | 31 | 20 | 61 | 32 | 29 |  | 45 | 24
9 | 30 | 17 | 13 | 36 | 29 | 7 |  | 36 | 17
10 | 65 | 40 | 25 | 44 | 26 | 18 |  | 24 | 21
11 | - | - | - | 3 | - | 3 |  | - | 1
12 | - | - | - | 13 | 8 | 5 |  | 2 | 4
13 | 5 | 1 | 4 | - | - | - | - | - | -
14 | 57 | 22 | 35 | 39 | 19 | 20 |  | 25 | 34
15 | 52 | 34 | 18 | 48 | 27 | 21 |  | 48 | 27
16 | 103 | 76 | 27 | 340 | 286 | 54 |  | 491 | 116
17 | 176 | 154 | 22 | - | - | - | - | - | -
18 | - | - | - | 338 | 297 | 41 | - | - | -
19 | - | - | - | - | - | - | - | - | -
20 | - | - | - | - | - | - | - | - | -
21 | - | - | - | - | - | - |  | 340 | 41
22 | - | - | - | - | - | - | - | - | -
المجموع                 Total | 1173 | 779 | 394 | 1545 | 1108 | 437
(1) Causes of death given in annex 1 |  |  |  |  |  |  |  |  | (1) اسباب الوفيات في الملحق رقم 1
Spreadsheet: 162630d1340015677-when-i-hide-columns-my-bar-column-colors-change-automatically-839038
Sheet: Sheet1

 | last year | budget | actual | forecast
Jan
Feb
Mar
Apr
category | Jan | Feb | Mar | Apr
last year
budget
actual
forecast
Spreadsheet: 0c413d35-843a-477f-b8d3-110dc33cde01
Sheet: Sheet1

Precertification from Insurance Carrier may be required for all MRI & MRA Procedures. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
HEAD/NECK
 |  | Without Gad |  |  | With Gad
Region | Indication | CPT |  |  | CPT
 |  | 70551 |  |  | 70553
Brain | Acute Stroke | x
 | Alzheimers/Dementia | x
 | Memory Loss | x
 | Mental Status Change | x
Brain/IAC/Pituitary | Cranial Nerve Abnormalities |  |  |  | x
 | [NAME]/Vertigo |  |  |  | x
 | Headache w/Focal Symptoms |  |  |  | x
 | IAC/Hearing Loss |  |  |  | x
 | Infection |  |  |  | x
 | Multiple Sclerosis |  |  |  | x
 | Pituitary Lesion |  |  |  | x
 | Seizures |  |  |  | x
 | Tumor/Mass |  |  |  | x
 | Cancer/Metastases |  |  |  | x
 | Vascular Lesions |  |  |  | x
 |  |  |  |  | 70543
Orbits | Graves Disease |  |  |  | x
 | Exopthalmos |  |  |  | x
 | Pseudotumor |  |  |  | x
 | Cancer/Mets |  |  |  | x
 | Vascular Lesion |  |  |  | x
 |  |  |  |  | 70543
Soft Tissue  Neck | Infection |  |  |  | x
 | Pain |  |  |  | x
 | Tumor/Mass |  |  |  | x
 | Cancer/Metastases |  |  |  | x
 |  |  |  |  | 71552
Brachial Plexus | Brachial Plexus Injury |  |  |  | x
 | Nerve Avulsion |  |  |  | x
 | Tumor/Mass |  |  |  | x
 | Cancer/Metastases |  |  |  | x
Spreadsheet: 822634d1679466746-a-little-complicated-range-selection-example-40-ans
Sheet: List1

Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday
12 |  | 12 | 5 | 7 |  |  | 12 | 5 | 7 |  | 12 | 12 | 5 | 7
 | FIRST |  |  |  |  |  |  | SECOND |  |  |  |  |  |  | THIRD
 |  | Here are only 2 sequence
Spreadsheet: phillip_m_love__30076__aaaCredit Report
Sheet: Sheet1

DEAL ORIGINATION REPORT
Deals Input on 3/19/01
PENDING CREDIT ITEMS
Counterparty | Deal Number | Deal Type | Comm | Contact/Action Needed
Arizona Public Service Company | QX6828.1 QX7472.1 QX7491.1 | F | NG | [NAME]
Belden & Blake Corporation | QX7905.1 | P | NG | [NAME]
Energy Production Corporation | QX7679.1 | F | NG | Credit Previously Provided
Pickens Fuel Corp. | QX7453.1 QX7454.1 | F | NG | Credit Previously Provided
Utilities Board of the City of… | QX6236.1 | P | NG | [NAME]
REBOOK ITEMS
Counterparty | Deal Number | Deal Type | Comm | Rebook To--
Bank of America Corporation | QX6756.1/2/3/4 | F | BRNT | Bank of America, National Association
Coral Energy Resources, LP | QX6649.1 | F | NG | Coral Energy Holding, LP
Dynegy Canada Inc. | QX7532.1 | F | NG | Dynegy Canada Inc. (w/ECC)
Torch Energy TM, Inc. | QX6425.1 | P | NG | Torch Energy Marketing Inc.
Spreadsheet: 775963d1649414647-make-a-calendar-for-2-month-with-upates-monthly-forumla-calendar
Sheet: Sheet1

 |  |  |  |  |  |  |  | 2022
 | 2022-04-01 00:00:00 |  |  |  |  |  |  |  | 2022-05-01 00:00:00
 | Mandag | Tirsdag | Onsdag | Torsdag | Fredag | Lørdag | Søndag |  | Mandag | Tirsdag | Onsdag | Torsdag | Fredag | Lørdag | Søndag
 |  | 2022-03-29 00:00:00 | 2022-03-30 00:00:00 | 2022-03-31 00:00:00 | 2022-04-01 00:00:00 | 2022-04-02 00:00:00 | 2022-04-03 00:00:00 |  |  | 2022-04-26 00:00:00 | 2022-04-27 00:00:00 | 2022-04-28 00:00:00 | 2022-04-29 00:00:00 | 2022-04-30 00:00:00 | 2022-05-01 00:00:00
 | 2022-04-04 00:00:00 | 2022-04-05 00:00:00 | 2022-04-06 00:00:00 | 2022-04-07 00:00:00 | 2022-04-08 00:00:00 | 2022-04-09 00:00:00 | 2022-04-10 00:00:00 |  | 2022-05-02 00:00:00 | 2022-05-03 00:00:00 | 2022-05-04 00:00:00 | 2022-05-05 00:00:00 | 2022-05-06 00:00:00 | 2022-05-07 00:00:00 | 2022-05-08 00:00:00
 | 2022-04-11 00:00:00 | 2022-04-12 00:00:00 | 2022-04-13 00:00:00 | 2022-04-14 00:00:00 | 2022-04-15 00:00:00 | 2022-04-16 00:00:00 | 2022-04-17 00:00:00 |  | 2022-05-09 00:00:00 | 2022-05-10 00:00:00 | 2022-05-11 00:00:00 | 2022-05-12 00:00:00 | 2022-05-13 00:00:00 | 2022-05-14 00:00:00 | 2022-05-15 00:00:00
 | 2022-04-18 00:00:00 | 2022-04-19 00:00:00 | 2022-04-20 00:00:00 | 2022-04-21 00:00:00 | 2022-04-22 00:00:00 | 2022-04-23 00:00:00 | 2022-04-24 00:00:00 |  | 2022-05-16 00:00:00 | 2022-05-17 00:00:00 | 2022-05-18 00:00:00 | 2022-05-19 00:00:00 | 2022-05-20 00:00:00 | 2022-05-21 00:00:00 | 2022-05-22 00:00:00
 | 2022-04-25 00:00:00 | 2022-04-26 00:00:00 | 2022-04-27 00:00:00 | 2022-04-28 00:00:00 | 2022-04-29 00:00:00 | 2022-04-30 00:00:00 | 2022-05-01 00:00:00 |  | 2022-05-23 00:00:00 | 2022-05-24 00:00:00 | 2022-05-25 00:00:00 | 2022-05-26 00:00:00 | 2022-05-27 00:00:00 | 2022-05-28 00:00:00 | 2022-05-29 00:00:00
 | 2022-05-02 00:00:00 | 2022-05-03 00:00:00 | 2022-05-04 00:00:00 | 2022-05-05 00:00:00 | 2022-05-06 00:00:00 | 2022-05-07 00:00:00 | 2022-05-08 00:00:00 |  | 2022-05-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-01 00:00:00 | 2022-06-02 00:00:00 | 2022-06-03 00:00:00 | 2022-06-04 00:00:00 | 2022-06-05 00:00:00
Spreadsheet: 32861d1229028111-list-first-instances-only-and-ignore-blanks-in-rows-excel_problem
Sheet: Sheet2

ausbil | amp | vanguard |  | ausbil | amp | bt | ausbil | amp | vanguard | bt
amp | [NAME] | fidelity |  |  | amp | bt | amp | [NAME] | fidelity | bt
 |  |  |  |  |  |  | Desired result
Spreadsheet: 142517d1329882731-excel-2007-consolidating-different-values-under-different-names-indifferent-tabs-to-master-sheet-varification-doc
Sheet: GANDI NAGAR

GANDI NAGAR |  |  |  |  |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR |  |  |  | EAST AZAD NAGAR
SNO | Part Code | Description | Qty | Qty (As on Date 16th Jan-2012)
Section-V,  Part A, SNO-3, 5 | PE-SV Router, PE-SDN Router |  | 1
Existing Material Redeployment
A | Power System
 | 200 AH Battery |  | 2
Spreadsheet: 799600d1665155236-if-value-is-than-c3-values-15-then-ok-if-not-check-new-microsoft-excel-worksheet-etaf
Sheet: Sheet1

Requisition |  | 445988 | 446996 | 1002273 | 1002248 | 1004373
PO Number |  | 390295 | 391283 | 1003254 | 1003255 | 1008126
Number |  | 7165465 | 7297165 | 7558838 | 7628331 | 7702396 |  |  | to check if the value in [NAME] is less equal or greater than 15% of the value in F8, if its within 15% thats OK, if above than it needs to write CHECK
Period |  | 1 - 30 Apr 22 | 01 - 31 May 22 | 01 - 30 Jun 2022 | 01 - 31 Jul 2022 | 01 - 31 Aug 22
Date |  | 2022-04-25 00:00:00 | 2022-05-24 00:00:00 | 2022-07-04 00:00:00 | 2022-07-26 00:00:00 | 2022-08-22 00:00:00
Total Excluding VAT |  | 2023.9 | 1475.73 | 1991.69 | 1887.58 | 1907.49
Invoice VAT Total
Invoice Total Including VAT |  | 2023.9 | 1475.73 | 1991.69 | 1887.58 | 1907.49
 |  | SFP: 07/06/2022 | SFP: 15/06/2022 | SFP: 22/08/2022 | SFP: 05/09/2022 | SFP: 20/09/2022
 |  |  |  | 9/13/2022 | 9/13/2022 | 9/21/2022
number |  | 1 | 2 | 3 | 4 | 5
CHECK
 |  |  |  |  | 15% less than
 |  |  |  |  | 15% greater than
Spreadsheet: 5c428341-de01-47d1-b097-07bfdc311411
Sheet: Sheet2

Oregon Sales
 | Portland | Springfield | Medford | In-Store Sales Total | Online Sales Total | Total Sales
 | 2880 | 2552 | 2116 |  | 10664
 | 3215 | 2742 | 1955 |  | 9285
 | 3180 | 2650 | 2018 |  | 11550
 | 2967 | 2820 | 2234 |  | 10384
Spreadsheet: 876607d1723327331-index-and-2-matches-formula-not-working-indexmatch-sample
Sheet: Sheet2

 |  |  | 1 | 6 | 5 | 2 | 8 | 9 | 4 | 7 | 0 | 3 |  |  | Q4 to R7 are user imputs
 |  | 6 | L | P | L | M | M | B | M | L | B | P |  |  |  |  |  |  | [NAME]
 |  | 3 | B | M | L | P | L | P | M | M | L | B |  |  | 1st | 6 | 0 |  | =INDEX($D$3:$M$12, MATCH(Q4, $C$3:$C$12, 0), [NAME], $[NAME], 0)) | L
 |  | 7 | B | P | M | L | M | B | B | L | M | L |  |  | 2nd | 7 | 3 |  | =INDEX($D$3:$M$12, MATCH(Q5, $C$3:$C$12, 0), MATCH(R5, $[NAME], 0)) | M
 |  | 1 | M | L | L | P | B | P | M | L | B | B |  |  | 3rd | 0 | 0 |  | =INDEX($D$3:$M$12, MATCH(Q6, $C$3:$C$12, 0), MATCH(R6, $[NAME], 0)) | L
 |  | 8 | M | L | P | P | B | L | M | L | B | M |  |  | 4th | 3 | 3 |  | =INDEX($D$3:$M$12, MATCH(Q7, $C$3:$C$12, 0), [NAME], $[NAME], 0)) | B
 |  | 0 | P | L | P | M | B | P | B | B | L | P
 |  | 2 | P | L | M | P | M | B | M | P | B | P |  |  |  |  |  |  | Looking for it to return in U4:u:7
 |  | 4 | L | M | L | B | L | L | P | L | B | M |  |  | 1st example [NAME], R4=0 is highlighted in E8
 |  | 5 | M | P | B | L | L | M | P | B | P | B
 |  | 9 | P | B | P | M | P | P | M | B | B | M
Spreadsheet: 154609d1336494921-subtracting-values-in-cells-from-a-total-and-counting-the-number-of-cells-to-reach-0-strawberry-temp-forecast
Sheet: Temp.

Date |  |  | 2012-05-07 00:00:00 | 2012-05-08 00:00:00 | 2012-05-09 00:00:00 | 2012-05-10 00:00:00 | 2012-05-11 00:00:00 | 2012-05-12 00:00:00 | 2012-05-13 00:00:00 | 2012-05-14 00:00:00 | 2012-05-15 00:00:00 | 2012-05-16 00:00:00 | 2012-05-17 00:00:00 | 2012-05-18 00:00:00 | 2012-05-19 00:00:00 | 2012-05-20 00:00:00 | 2012-05-21 00:00:00 | 2012-05-22 00:00:00 | 2012-05-23 00:00:00 | 2012-05-24 00:00:00 | 2012-05-25 00:00:00 | 2012-05-26 00:00:00 | 2012-05-27 00:00:00 | 2012-05-28 00:00:00 | 2012-05-29 00:00:00 | 2012-05-30 00:00:00 | 2012-05-31 00:00:00 | 2012-06-01 00:00:00 | 2012-06-02 00:00:00 | 2012-06-03 00:00:00 | 2012-06-04 00:00:00 | 2012-06-05 00:00:00 | 2012-06-06 00:00:00 | 2012-06-07 00:00:00 | 2012-06-08 00:00:00 | 2012-06-09 00:00:00 | 2012-06-10 00:00:00 | 2012-06-11 00:00:00 | 2012-06-12 00:00:00 | 2012-06-13 00:00:00 | 2012-06-14 00:00:00 | 2012-06-15 00:00:00 | 2012-06-16 00:00:00 | 2012-06-17 00:00:00 | 2012-06-18 00:00:00 | 2012-06-19 00:00:00 | 2012-06-20 00:00:00 | 2012-06-21 00:00:00 | 2012-06-22 00:00:00 | 2012-06-23 00:00:00 | 2012-06-24 00:00:00 | 2012-06-25 00:00:00 | 2012-06-26 00:00:00 | 2012-06-27 00:00:00 | 2012-06-28 00:00:00 | 2012-06-29 00:00:00 | 2012-06-30 00:00:00 | 2012-07-01 00:00:00 | 2012-07-02 00:00:00 | 2012-07-03 00:00:00 | 2012-07-04 00:00:00 | 2012-07-05 00:00:00 | 2012-07-06 00:00:00 | 2012-07-07 00:00:00 | 2012-07-08 00:00:00 | 2012-07-09 00:00:00 | 2012-07-10 00:00:00 | 2012-07-11 00:00:00 | 2012-07-12 00:00:00 | 2012-07-13 00:00:00 | 2012-07-14 00:00:00 | 2012-07-15 00:00:00 | 2012-07-16 00:00:00 | 2012-07-17 00:00:00 | 2012-07-18 00:00:00 | 2012-07-19 00:00:00 | 2012-07-20 00:00:00 | 2012-07-21 00:00:00 | 2012-07-22 00:00:00 | 2012-07-23 00:00:00 | 2012-07-24 00:00:00 | 2012-07-25 00:00:00
Observed Temp. | [NAME] | Group 01
Observed Temp. | [NAME] | Group 02
Observed Temp. | [NAME] | Group 03
Observed Temp. | [NAME] | Group 04
Observed Temp. | [NAME] | Group 05
Observed Temp. | [NAME] | Group 06
Observed Temp. | [NAME] | Group 07
Observed Temp. | Elsanta | Group 08
Observed Temp. | Elsanta | Group 09
Observed Temp. | Elsanta | Group 10
Observed Temp. | Elsanta | Group 11
Observed Temp. | Elsanta | Group 12
Observed Temp. | Elsanta | Group 13
Forecast Temp. | [NAME] | Group 01
Forecast Temp. | [NAME] | Group 02
Forecast Temp. | [NAME] | Group 03
Forecast Temp. | [NAME] | Group 04
Forecast Temp. | [NAME] | Group 05
Forecast Temp. | [NAME] | Group 06
Forecast Temp. | [NAME] | Group 07
Forecast Temp. | Elsanta | Group 08
Forecast Temp. | Elsanta | Group 09
Forecast Temp. | Elsanta | Group 10
Forecast Temp. | Elsanta | Group 11
Forecast Temp. | Elsanta | Group 12
Forecast Temp. | Elsanta | Group 13
Spreadsheet: 120301d1315182930-counting-a-football-teams-record-week-by-week-winlosstie
Sheet: Sheet1

Year | Team | Wk | [NAME] | W | L | T
2010 | 49ers | 1 | L | 0 | 1 | 0 |  |  |  |  | Year | (All)
2010 | 49ers | 2 | L | 0 | 1 | 0 |  |  |  |  | Team | (All)
2010 | 49ers | 3 | L | 0 | 1 | 0
2010 | 49ers | 4 | L | 0 | 1 | 0 |  |  |  |  |  | Column Labels
2010 | 49ers | 5 | L | 0 | 1 | 0 |  |  |  |  |  | W |  | L |  | Total Count of Res | Total Count of Res2
2010 | 49ers | 6 | W | 1 | 0 | 0 |  |  |  |  | Row Labels | Count of Res | Count of Res2 | Count of Res | Count of Res2
 |  |  |  |  |  |  |  |  |  |  | 1 |  | 0 | 1 | 1 | 1 | 1
Year | Team | Wk | [NAME] | W | L | T | [NAME] | Rec L | Rec T |  | 2 |  | 0 | 1 | 2 | 1 | 2
2010 | 49ers | 1 | L | 0 | 1 | 0 | 0 | 1 | 0 |  | 3 |  | 0 | 1 | 3 | 1 | 3
2010 | 49ers | 2 | L | 0 | 1 | 0 | 0 | 2 | 0 |  | 4 |  | 0 | 1 | 4 | 1 | 4
2010 | 49ers | 3 | L | 0 | 1 | 0 | 0 | 3 | 0 |  | 5 |  | 0 | 1 | 5 | 1 | 5
2010 | 49ers | 4 | L | 0 | 1 | 0 | 0 | 4 | 0 |  | 6 | 1 | 1 |  | 5 | 1 | 6
2010 | 49ers | 5 | L | 0 | 1 | 0 | 0 | 5 | 0 |  | Grand Total | 1 |  | 5 |  | 6
2010 | 49ers | 6 | W | 1 | 0 | 0 | 1 | 5 | 0
Spreadsheet: 771719d1646813642-in-a-table-how-can-i-select-to-display-only-certain-columns-and-not-others-how-to-display-only-certain-columns
Sheet: Sheet1

Original Data
Name | Surname | Apples sold | Pears sold | Oranges sold | Bananas sold
[NAME] | Smith | 122 | 2 | 585 | 74
[NAME] | Jones | 669 | 441 | 455 | 88
[NAME] | Doe | 589 | 47 | 556 | 445
[NAME] | Jones | 59 | 478 | 88 | 445
[NAME] | Lopez | 58 | 5465 | 1 | 445
 |  |  |  |  |  |  | (Columns H,I,J,K, and L are hidden)
Columns to display |  |  |  |  |  |  | Desired Outcome (Hiding non needed columns)
Name | Yes |  |  |  |  |  | Name | Surname | Apples sold | Pears sold | Oranges sold | Bananas sold
Surname | No |  |  |  |  |  | [NAME] | Smith | 122 | 2 | 585 | 74
Apples sold | No |  |  |  |  |  | [NAME] | Jones | 669 | 441 | 455 | 88
Pears sold | No |  |  |  |  |  | [NAME] | Doe | 589 | 47 | 556 | 445
Oranges sold | No |  |  |  |  |  | [NAME] | Jones | 59 | 478 | 88 | 445
Bananas sold | Yes |  |  |  |  |  | [NAME] | Lopez | 58 | 5465 | 1 | 445
Spreadsheet: kate_symes__18706__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-02-23 00:00:00 |  | 196.43 | 2800 | 140 | 200
 | 2001-02-22 00:00:00 |  | 261 | 4000 | 200 | 200 | 233.22 | 2500 | 222.69 | 1730
 | 2001-02-21 00:00:00 |  | 283.75 | 4800 | 240 | 200 | 425 | 1050 | 372 | 750
 | 2001-02-20 00:00:00 |  | 326.82 | 4400 | 300 | 600 | 324.71 | 8650 | 350.06 | 1975
 | 2001-02-19 00:00:00 |  | 326.15 | 5200 | 300 | 600 | 382.2 | 4390 | 356.1 | 1540
 | 2001-02-18 00:00:00 |  |  |  |  |  |  |  | 399.12 | 4290 |  | 320 | 600
 | 2001-02-17 00:00:00 |  | 346.07 | 3360 | 320 | 200 | 397.33 | 8623 | 394.97 | 2510
 | 2001-02-16 00:00:00 |  | 448.85 | 5200 | 425 | 200 | 444.06 | 5450 | 419.61 | 1985
 | 2001-02-15 00:00:00 |  | 448.85 | 5200 | 425 | 200 | 436.92 | 5630 | 480.72 | 1815
 | 2001-02-14 00:00:00 |  | 323 | 2000 | 300 | 0 | 601.45 | 2755 | 404.44 | 1970
 | 2001-02-13 00:00:00 |  | 307.5 | 2400 | 315 | 0 | 400.85 | 9115 | 379.49 | 2005
 | 2001-02-12 00:00:00 |  | 287.5 | 2400 | 277.5 | 0 | 380.82 | 9260 | 330.18 | 1690
 | 2001-02-11 00:00:00 |  |  |  |  |  |  |  | 398.34 | 5105 |  | 250 | 0
 | 2001-02-10 00:00:00 |  | 255.63 | 3200 | 217.5 | 400 | 385.49 | 9007 | 373.04 | 3310
 | 2001-02-09 00:00:00 |  | 255.63 | 3200 | 217.5 | 400 | 385.64 | 9525 | 391.75 | 2705
 | 2001-02-08 00:00:00 |  | 360.63 | 3200 | 300 | 48 | 407.79 | 7436 | 402.59 | 2830
 | 2001-02-07 00:00:00 |  | 301.25 | 4800 | 231.43 | 1400 | 415.92 | 7768 | 431.28 | 1750
 | 2001-02-06 00:00:00 |  | 211.67 | 3600 | 200 | 600 | 458.43 | 2225 | 373.4 | 1560
 | 2001-02-05 00:00:00 |  | 200 | 4400 | 200 | 200 | 346.5 | 4395 | 308.59 | 2105
 | 2001-02-04 00:00:00 |  |  |  |  |  |  |  | 339.43 | 4946 |  | 206.67 | 1800
 | 2001-02-03 00:00:00 |  | 223.95 | 7600 | 196.25 | 800 | 390.12 | 4411 | 362.33 | 1500
 | 2001-02-02 00:00:00 |  | 223.95 | 7600 | 196.25 | 800 | 489.58 | 1945 | 388.1 | 1470
 | 2001-02-01 00:00:00 |  | 368.81 | 8400 | 319.17 | 1200 | 507.77 | 2990 | 399.65 | 1410
 | 2001-01-31 00:00:00 |  | 410.67 | 6000 | 330 | 240 | 558.06 | 2700 | 457.58 | 825
 | 2001-01-30 00:00:00 |  | 475 | 3600 | 330 | 200 | 570.15 | 1790 | 441.67 | 900
 | 2001-01-29 00:00:00 |  | 409.94 | 6640 | 387.5 | 0 | 508.72 | 2665 | 432.7 | 925
 | 2001-01-28 00:00:00 |  |  |  |  |  |  |  | 573.46 | 3080 |  | 350 | 600
 | 2001-01-27 00:00:00 |  | 295.84 | 6160 | 255.71 | 1400 | 575 | 1900 | 453.79 | 896
 | 2001-01-26 00:00:00 |  | 295.84 | 6160 | 255.71 | 1400 | 484.63 | 1750 | 475.17 | 757
 | 2001-01-25 00:00:00 |  | 319.3 | 5760 | 300 | 400 | 408.1 | 3642 | 485.29 | 850
 | 2001-01-24 00:00:00 |  | 314.3 | 4560 | 260 | 0 | 466.67 | 1350 | 450 | 600
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.