tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 416dc931-f36d-48e7-bff2-65a44254c577
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
References | [NAME] (2003)
Disease | MCL
Platform | cDNA
# of genes | 8810
sample size | 92
Representative features | R3
Estimates (representative features)
 | Module # | PC # | Estimate
 | 2 | 2 | 0.024
 | 2 | 5 | 0.046
 | 2 | 6 | 0.141
 | 2 | 7 | 0.001
 | 2 | 9 | 0.071
 | 2 | 11 | -0.004
 | 9 | 1 | -0.145
Estimates (genes with the largest regression coefficients)
 |  | UNIQID | Estimate | Gene
 |  | 28869 | 0.034 | Hs.458414, Interferon induced transmembrane protein 1 (9-27)
 |  | 17333 | 0.03 | Hs.395482, PTK2 protein tyrosine kinase 2
 |  | 27752 | 0.028 | Hs.521903, [NAME] antigen 6 complex, locus E
 |  | 17918 | 0.027 | Hs.75862, SMAD, mothers against DPP homolog 4 (Drosophila)
 |  | 24721 | 0.027 | Hs.147433, Proliferating cell nuclear antigen
 |  | 27903 | 0.027 | Hs.498313, Adenylosuccinate synthase
 |  | 34768 | 0.026 | Hs.529798, Basic transcription factor 3
 |  | 27308 | 0.025 | Hs.149239, Ephrin-B2
 |  | 28578 | 0.025 | Hs.272062, Protein tyrosine phosphatase, receptor type, F
 |  | 17194 | 0.024 | Hs.546245, Chemokine (C-C motif) receptor 5
 |  | 17690 | 0.024 | Hs.434059, [NAME] variant gene 4 (E1A enhancer binding protein, E1AF)
 |  | 34679 | 0.024 | Hs.287471, Chromosome 1 open reading frame 43
 |  | 27047 | 0.024 | Hs.519057, Neuropeptide Y receptor [NAME]
 |  | 24720 | 0.024 | [NAME], Proteasome (prosome, macropain) subunit, beta type, 9 (large multifunctional protease 2)
 |  | 24653 | 0.024 | Hs.349283, Chromobox homolog 5 (HP1 alpha homolog, Drosophila)
 |  | 27067 | 0.023
 |  | 30280 | 0.023 | Hs.380389, Chromosome 9 open reading frame 77
 |  | 25101 | 0.023 | Hs.262150, CD22 antigen
 |  | 28344 | 0.022 | Hs.194350, Protein kinase, cAMP-dependent, catalytic, alpha
 |  | 27153 | 0.022 | Hs.291533, Son of sevenless homolog 2 (Drosophila)
Spreadsheet: 102913d1300809886-excel-2007-conditional-formatting-what-im-trying-to-do-is-all-dates-cfduedates
Sheet: Sheet1

Job # | Inspected | 30 | 60 | 90
Job1
Job2
Job3 |  |  |  |  |  | Look at the conditional formatting rules for this page
Job4 |  |  |  |  |  | All rules are based on Cell Between and Today()
[NAME] |  |  |  |  |  | The Inspected Dates are random so press F9 to recalc
Job6
Job7
Job8
Job9
Job10
Job11
[NAME]
Job13
[NAME]
Job15
Job16
Job17
[NAME]
[NAME]
Job20
Job21
[NAME]
Job23
Job24
Job25
[NAME]
Job27
[NAME]
Job29
Job30
Job31
Job32
Job33
[NAME]
Job35
Job36
[NAME]
[NAME]
Job39
Job40
[NAME]
[NAME]
Job43
[NAME]
Job45
Job46
Job47
[NAME]
Job49
Spreadsheet: 763300d1642096373-search-for-a-text-string-to-return-a-value-for-further-calculation-searchstring_returnvalue-for-calculation
Sheet: Sheet1

Material Type | Price per g
PLA | 10
NIN | 20
NINARM | 30
Product | Product Description | Weight in g | Cost
Mount | NINARM_lightMount | 10
Mount | lightmount | 20
Spreadsheet: f4f85d33-b1b9-47ef-892a-9f4cdc1c6d3e
Sheet: 2015-2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Modern Languages
Spring 2016
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 125835d1319237796-matching-on-name-to-phone-email-addresses-sample-1-
Sheet: Phone Numbers

Name First | Name Last | Phone/E-mail [NAME] | [NAME]
[NAME] | Nakama | (818)662-9132
(Joel) Bradley | King | (831)663-6616
A | Marshalleck | (323)291-5031
A. Jerard | Bryant | (323)397-5880
[NAME] | Green | (323)602-3773
[NAME] | [NAME] | (323)930-0444
[NAME] | [NAME] | (626)688-8885
[NAME] | [NAME] | (310)-324-6959
Spreadsheet: 1fbaafda-7640-4a13-9551-073ac8b98b44
Sheet: Abstinence Education

Grant: |  | Title V - Abstinence Education Grant Program
CFDA # |  | 93.235
GRANT NUMBER: |  | 6710
FISCAL YEAR: |  | 10/1/2012 THROUGH 9/30/2013
[NAME]: |  | Not allowed on this grant
Question regarding payments: |  | [NAME]   [PHONE] or [EMAIL]
Questions regarding grant: |  | Marti Rodriguez [PHONE] or [EMAIL]
LAST DAY TO SUBMIT REQUESTS FOR THIS GRANT  - November 15, 2013
Code | District Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | JULY 2012 | AUGUST 2012 | SEPTEMBER 2012 | OCTOBER 2012 | NOVEMBER 2012 | DECEMBER 2012 | JANUARY 2013 | FEBRUARY 2013 | MARCH 2013 | APRIL 2013 | MAY 2013 | JUNE 2013 | JULY 2013 | AUGUST 2013 | SEPTEMBER 2013 | OCTOBER 2013 | 2013-11-01 00:00:00
2810 | Center Consolidated Schools | 95812 |  |  |  |  |  |  |  |  |  |  | 15176 |  |  |  | 80636
Y582 | Pueblo City-County Health Dept | 57193 |  |  |  |  |  |  |  |  |  | 3945 |  |  |  |  |  |  | 4064 |  | 8314
Y583 | Friends First, Inc. | 211867 |  |  |  |  |  |  | 17256 | 17225 | 25218 | 7778 |  | 17549 | 15619 | 13096
Y584 | Center for Relationship Education | 229757 |  |  |  |  |  |  |  | 57478 | 25061 | 11146 |  |  | 18854 | 23658 | 14576 |  | 9000
Spreadsheet: 83042d1283086745-refering-to-specific-entry-in-a-drop-down-list-fsr-wc-2010-statistic-book
Sheet: Driver Statistics

 | Name |  | [NAME]
 | Nationality
 |  |  |  |  |  |  | BAH | AUS | MAL | CHI | ESP | MON | TUR | CAN | EUR | GBR | GER | HUN | BEL | ITA | SIN | JPN | BRA | ABU
 | Starts |  |  |  | k:k | Race Position
 | Points |  |  |  | f:f | Qualifying Position
 | Average Race Position |  |  |  | k:q | Points
 | Average Qualifying Position |  |  |  | k:o | [NAME]
 | DNF Rate
 |  |  |  |  | D3 | Race Laps
 | Wins |  |  |  | k:m | Laps Completed
 | Poles |  |  |  |  | % of Potential Laps Completed
 | [NAME]
 | Fastest Laps |  |  |  | k:n | Lead Laps Run
 |  |  |  |  |  | Lead Laps % of Total Laps Run
 | DNFs |  |  |  |  |  | BAH | AUS | MAL | CHI | ESP | MON | TUR | CAN | EUR | GBR | GER | HUN | BEL | ITA | SIN | JPN | BRA | ABU
 |  |  |  |  | f:f | Start
 | Laps Completed |  |  |  | f:h | Q Penalty
 | % of Potential Laps Completed |  |  |  | k:p | DNF
 | Lead Laps Run
 | Lead Laps % of Total Laps Run
Spreadsheet: 78983d1279223898-graphing-the-top-row-of-filtered-data-exam-calc
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | name | jan | feb | [NAME] | apr | may | jun | jul | aug | sep | oct | nov | dec
name | jan | feb | [NAME] | apr | may | jun | jul | aug | sep | oct | nov | dec |  | 130000 | martin4 | 19 | 8 | 4 | 1 | 1 | 3 | 8 | 1 | 18 | 13 | 13 | 15
[NAME] | 10 | 15 | 4 | 13 | 19 | 9 | 18 | 18 | 20 | 20 | 18 | 19 | 30000
martin7 | 12 | 10 | 15 | 18 | 19 | 8 | 10 | 17 | 4 | 10 | 9 | 10 | 40000
martin6 | 14 | 10 | 2 | 19 | 10 | 2 | 17 | 9 | 14 | 11 | 12 | 18 | 50000
[NAME] | 9 | 5 | 1 | 17 | 7 | 10 | 4 | 6 | 10 | 4 | 11 | 14
[NAME] | 9 | 4 | 10 | 2 | 20 | 15 | 17 | 19 | 10 | 16 | 3 | 12 | 70000
martin5 | 10 | 2 | 5 | 20 | 2 | 18 | 2 | 18 | 8 | 1 | 15 | 19 | 80000
martin6 | 9 | 12 | 14 | 3 | 14 | 12 | 7 | 17 | 4 | 19 | 9 | 8
[NAME] | 7 | 10 | 17 | 18 | 15 | 2 | 6 | 20 | 10 | 5 | 6 | 17
martin8 | 3 | 19 | 12 | 3 | 14 | 20 | 7 | 4 | 12 | 5 | 2 | 3 | 110000
martin6 | 1 | 17 | 16 | 13 | 7 | 19 | 14 | 6 | 6 | 5 | 5 | 16
martin4 | 19 | 8 | 4 | 1 | 1 | 3 | 8 | 1 | 18 | 13 | 13 | 15 | 130000
martin8 | 5 | 18 | 2 | 11 | 8 | 10 | 16 | 16 | 13 | 2 | 2 | 15
[NAME] | 18 | 12 | 17 | 11 | 20 | 1 | 13 | 9 | 9 | 17 | 3 | 17
martin1 | 11 | 16 | 4 | 11 | 8 | 15 | 17 | 16 | 12 | 4 | 15 | 9 | 160000
martin4 | 4 | 7 | 11 | 18 | 9 | 17 | 16 | 18 | 6 | 6 | 19 | 1
martin3 | 13 | 6 | 2 | 14 | 1 | 3 | 4 | 14 | 3 | 9 | 18 | 6 | 180000
martin5 | 1 | 13 | 11 | 8 | 7 | 12 | 20 | 11 | 16 | 19 | 10 | 18
martin3 | 18 | 16 | 5 | 7 | 13 | 14 | 17 | 13 | 1 | 16 | 13 | 18
martin3 | 18 | 13 | 5 | 20 | 12 | 11 | 18 | 9 | 13 | 18 | 18 | 11
martin8 | 10 | 1 | 18 | 4 | 18 | 1 | 8 | 18 | 17 | 13 | 15 | 20
martin5 | 1 | 4 | 1 | 9 | 1 | 12 | 15 | 15 | 14 | 10 | 17 | 8
martin1 | 16 | 17 | 11 | 6 | 13 | 16 | 6 | 4 | 5 | 6 | 16 | 13
martin7 | 13 | 1 | 15 | 4 | 10 | 17 | 12 | 20 | 11 | 4 | 8 | 17
martin4 | 4 | 10 | 14 | 4 | 16 | 17 | 3 | 1 | 1 | 20 | 1 | 2
martin7 | 3 | 14 | 7 | 12 | 17 | 4 | 14 | 2 | 19 | 13 | 2 | 9
[NAME] | 5 | 11 | 18 | 5 | 3 | 20 | 18 | 17 | 13 | 6 | 18 | 3
martin1 | 11 | 16 | 14 | 18 | 12 | 13 | 20 | 14 | 4 | 8 | 9 | 5
Spreadsheet: 98598d1297453908-pivot-table-displaying-data-rows-into-columns-inventory
Sheet: Inv Purchase_Ebay

Date | Item Name | Quantity | Cost | Shipping | Total
2011-01-01 00:00:00 | SATA80GB | 10 | 15.9 |  | 159
2011-01-01 00:00:00 | [NAME] | 5 | 5 |  | 25
2011-01-10 00:00:00 | SATA750GB | 2 | 15 |  | 30 |  |  | Item Name | Data | Total
2011-01-10 00:00:00 | DDR 533 1 GB | 4 | 7.5 |  | 30 |  |  | SATA80GB | Quantity_Total | 10
2011-01-10 00:00:00 |  |  |  |  | 0 |  |  |  | Purhase Total | 159
 |  |  |  |  | 0 |  |  | [NAME] | Quantity_Total | 5
 |  |  |  |  | 0 |  |  |  | Purhase Total | 25
 |  |  |  |  | 0 |  |  | SATA750GB | Quantity_Total | 2
 |  |  |  |  | 0 |  |  |  | Purhase Total | 30
 |  |  |  |  | 0 |  |  | DDR 533 1 GB | Quantity_Total | 4
 |  |  |  |  | 0 |  |  |  | Purhase Total | 30
 |  |  |  |  | 0 |  |  | Total Quantity_Total |  | 21
 |  |  |  |  | 0 |  |  | Total Purhase Total |  | 244
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0 |  |  | This is how I want the data to be displayed.
 |  |  |  |  | 0 |  |  | Item Name | Quantity Total | Purchase Total
 |  |  |  |  | 0 |  |  | SATA80GB | 10 | 159
 |  |  |  |  | 0 |  |  | [NAME] | 5 | 25
 |  |  |  |  | 0 |  |  | SATA750GB | 2 | 30
 |  |  |  |  | 0 |  |  | DDR 533 1 GB | 4 | 30
 |  |  |  |  | 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: chris_germany__2296__DecCohCHOICE-ENA
Sheet: Dec 13

 | COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2000-12-13 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1644 |  | 1254 |  | 67694 |  |  |  |  |  | 19 | 1 | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | 2 | 24
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 7076 |  | 6110 |  | 67694 |  |  |  |  |  | 20 | 3 | 25
 |  |  |  |  |  |  |  |  | 5000 |  | 5000 |  | 68918 | 0 |  |  |  |  | 20 | 4 | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 5 | 29
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 2776 |  | 2264 |  | 67694 |  |  |  |  |  | 21 | 6 | 27
 |  |  |  |  |  |  |  |  | 1535 |  | 1535 |  | 68915 | 0 |  |  |  |  | 20 | 7 | 24
 |  |  |  |  |  |  |  |  | 1540 |  | 1540 |  | 69693 | 0 |  |  |  |  | 23 | 8 | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | 9 | 30
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 18991 |  | 15728 |  | 67694 |  |  |  |  |  | 26 | 15 | 35
 |  |  |  |  |  |  |  |  | 673 |  | 673 |  | 69149 | 0 |  |  |  |  | 20 | 35 | 29
 |  |  |  |  |  |  |  |  | 0 |  |  |  | 68915 | 0 |  |  |  |  | 20 | 39 | 26
 |  |  |  |  |  |  |  |  | 0 |  |  |  | 68918 | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 2152 |  | 1651 |  | 67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1683 |  | 1218 |  | 67694 |  |  |  |  |  | Storage
 |  |  |  |  |  |  |  |  | 1915 |  | 1915 |  | 68916 | 0 |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.7
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 16642 |  | 12894 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 2660 |  | 2030 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 4839 |  | 4034 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 6190 |  | 5035 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 1446 |  | 742 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 52 |  | 45 |  | 67694 | 1
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 06ff77eb-931c-440a-88e7-b324e8d52bb7
Sheet: Sheet1

Release: Harmonized Indices of Consumer Prices (HICP) | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=251
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-09-18 12:57 PM CDT
 | Real-Time | Period
Name: | Start | End
Harmonized Indices of Consumer Prices (HICP) | 2012-06-15 00:00:00 | Current
Link:
http://epp.eurostat.ec.europa.eu/portal/page/portal/hicp/data/main_tables | 2012-06-15 00:00:00 | Current
Source:
Eurostat | 2012-06-15 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2012-06-15 00:00:00
2012-07-15 00:00:00
2012-08-16 00:00:00
2012-09-14 00:00:00
2012-10-16 00:00:00
2012-11-15 00:00:00
2012-12-14 00:00:00
2013-01-16 00:00:00
2013-02-28 00:00:00
2013-03-15 00:00:00
2013-04-16 00:00:00
2013-05-16 00:00:00
2013-06-14 00:00:00
2013-07-16 00:00:00
2013-08-16 00:00:00
2013-09-16 00:00:00
2013-10-16 00:00:00
2013-11-15 00:00:00
2013-12-20 00:00:00
2014-01-21 00:00:00
2014-02-24 00:00:00
2014-03-17 00:00:00
2014-04-21 00:00:00
2014-05-16 00:00:00
2014-06-16 00:00:00
2014-07-17 00:00:00
2014-08-14 00:00:00
2014-09-17 00:00:00
Spreadsheet: 273744d1382896036-cell-s-to-be-populated-from-various-results-of-drop-down-sample-exercise
Sheet: Bob

 |  | Tariff Option | Tariff A |  |  |  |  |  |  | Tariff A | Tariff B
 | Free Minutes Peak | Free Minutes Off Peak | Charged Minutes Peak | Charged Minutes Off Peak | Cost Peak Usage | Cost Off Peak Usage | Total Cost | Total Cumulative Cost
Sep
Oct
Nov
Dec
Spreadsheet: 122626d1317033347-help-on-designing-a-workbook-wcb-sandbox2
Sheet: Day 1

Area | Unit | Type | Unit Price | Per Cleaner | Cleaner 1 | [NAME] | Cleaner 3 | [NAME]
Team 1
Zone 1 | 46 | L | 7.65 | 3.825 | Shaun G | [NAME]
Zone 1 | 54 | L | 7.65 | 3.825 | Shaun G | [NAME]
Zone 1 | 67 | P | 11 | 5.5 | Shaun G | [NAME]
Zone 1 | 4A | P | 11 | 5.5 | Shaun G | [NAME]
Zone 1 | 18 | L | 7.65 | 3.825 | Shaun G | [NAME]
Zone 2 | 6 | P | 11 | 5.5 | Shaun G | [NAME]
Zone 2 | 21 | L | 7.65 | 3.825 | Shaun G | [NAME]
Zone 2 | 48 | L | 7.65 | 3.825 | Shaun G | [NAME]
Zone 2 | 12 | L | 7.65 | 3.825 | Shaun G | [NAME]
Zone 2 | 62 | L | 7.65 | 3.825 | Shaun G | [NAME]
Total Cleans | 10 |  | 86.55000000000001 | 43.27500000000001 | 43.27500000000001 | 43.27500000000001
Area | Unit | Type | Unit Price | Per Cleaner | Cleaner 1 | [NAME] | Cleaner 3 | [NAME]
Team 2
Zone 3 | 101 | L | 7.65 | 3.825 | [NAME] | [NAME]
Zone 3 | 101A | P | 7.65 | 3.825 | [NAME] | [NAME]
Zone 3 | 67 | L | 11 | 5.5 | [NAME] | [NAME]
Zone 3 | 70 | L | 11 | 5.5 | [NAME] | [NAME]
Zone 3 | 71 | L | 7.65 | 3.825 | [NAME] | [NAME]
Zone 4 | 73 | L | 11 | 5.5 | [NAME] | [NAME]
Zone 4 | 76 | L | 7.65 | 3.825 | [NAME] | [NAME]
Zone 4 | 80 | L | 7.65 | 3.825 | [NAME] | [NAME]
Zone 4 | 82 | L | 7.65 | 3.825 | [NAME] | [NAME]
Zone 4 | 83 | L | 7.65 | 3.825 | [NAME] | [NAME]
Total Cleans | 10 |  | 86.55000000000001 | 43.27500000000001 | 43.27500000000001 | 43.27500000000001
Area | Unit | Type | Unit Price | Per Cleaner | Cleaner 1 | [NAME] | Cleaner 3 | [NAME]
Team 3
Zone 5 | 83a | L | 7.65 | 2.55 | Elaine S | Kylie B | Sonia B
Zone 5 | 88 | L | 7.65 | 2.55 | Elaine S | Kylie B | Sonia B
Zone 5 | 95 | L | 11 | 3.666666666666667 | Elaine S | Kylie B | Sonia B
Zone 5 | 97 | L | 11 | 3.666666666666667 | Elaine S | Kylie B | Sonia B
Zone 5 | 10 | P | 7.65 | 2.55 | Elaine S | Kylie B | Sonia B
Zone 5 | 11 | L | 11 | 3.666666666666667 | Elaine S | Kylie B | Sonia B
Zone 6 | 44 | P | 7.65 | 2.55 | Elaine S | Kylie B | Sonia B
Zone 6 | 5 | L | 7.65 | 2.55 | Elaine S | Kylie B | Sonia B
Zone 6 | 1 | L | 7.65 | 2.55 | Elaine S | Kylie B | Sonia B
Zone 6 | 4 | L | 7.65 | 2.55 | Elaine S | Kylie B | Sonia B
Total Cleans | 10 |  | 86.55000000000001 | 28.85 | 28.85 | 28.85 | 28.85
Area | Unit | Type | Unit Price | Per Cleaner | Cleaner 1 | [NAME] | Cleaner 3 | [NAME]
Team 4
Zone 6 | 37a | L | 7.65 | 3.825 | [NAME] | [NAME]
Zone 6 | 40a | L | 7.65 | 3.83 | [NAME] | [NAME]
Zone 6 | 1 | L | 11 | 3.83 | [NAME] | [NAME]
Zone 7 | 56 | L | 11 | 3.83 | [NAME] | [NAME]
Zone 7 | 57 | L | 7.65 | 3.83 | [NAME] | [NAME]
Zone 7 | 58 | L | 11 | 3.83 | [NAME] | [NAME]
Zone 7 | 59 | L | 7.65 | 3.83 | [NAME] | [NAME]
Zone 7 | 60 | L | 7.65 | 3.83 | [NAME] | [NAME]
Zone 7 | 12 | L | 7.65 | 3.83 | [NAME] | [NAME]
Zone 7 | 5 | L | 7.65 | 3.83 | [NAME] | [NAME]
Total Cleans | 10 |  | 86.55000000000001 | 38.29499999999999 | 38.29499999999999 | 38.29499999999999
Spreadsheet: kate_symes__18351__MidC
Sheet: DJ Mid-C 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-04-20 00:00:00 |  | 231.51 | 18784 | 177.42 | 4648
 | 2001-04-19 00:00:00 |  | 273.89 | 15536 | 203.31 | 7832 | 261.94 | 766 | 218.69 | 1280
 | 2001-04-18 00:00:00 |  | 273.89 | 15536 | 203.31 | 7832 | 311.3 | 1840 | 232.11 | 1075
 | 2001-04-17 00:00:00 |  | 273.89 | 15536 | 203.31 | 7832 | 337.92 | 120 | 157.38 | 965
 | 2001-04-16 00:00:00 |  | 379.99 | 21296 | 356.66 | 8480 | 359.26 | 135 | 202.5 | 100
 | 2001-04-15 00:00:00 |  | 368.33 | 1200 | 350 | 0 | 400 | 50 | 325 | 25 |  | 357.42 | 27864
 | 2001-04-14 00:00:00 |  | 369.89 | 22096 | 344.35 | 6848 | 365.25 | 505 | 346 | 0
 | 2001-04-13 00:00:00 |  | 369.89 | 22096 | 343.87 | 6048 | 392.86 | 420 | 421.33 | 60
 | 2001-04-12 00:00:00 |  | 411.66 | 16160 | 376.19 | 5352 | 431.44 | 1740 | 339.62 | 419
 | 2001-04-11 00:00:00 |  | 386.02 | 10560 | 337.56 | 7552 | 391.16 | 540 | 372.42 | 291
 | 2001-04-10 00:00:00 |  | 379.15 | 19760 | 331.04 | 9192 | 398 | 621 | 337.4 | 615
 | 2001-04-09 00:00:00 |  | 311.43 | 19600 | 264.75 | 6584 | 334.15 | 437 | 337.5 | 100
 | 2001-04-08 00:00:00 |  | 273.75 | 1600 | 255 | 0 | 349.76 | 1330 | 342.22 | 135 |  | 264.68 | 20136
 | 2001-04-07 00:00:00 |  | 291.19 | 18496 | 225.83 | 11824 | 293.05 | 1559 | 279.89 | 435
 | 2001-04-06 00:00:00 |  | 291.19 | 18496 | 225.83 | 11824 | 290.88 | 400 | 227.31 | 325
 | 2001-04-05 00:00:00 |  | 348.81 | 22560 | 266.94 | 2480 | 259.38 | 200 | 158.94 | 610
 | 2001-04-04 00:00:00 |  | 314.36 | 18160 | 238.83 | 8040 | 307.45 | 455 | 246.52 | 460
 | 2001-04-03 00:00:00 |  | 305.4 | 18160 | 224.33 | 7200 | 300.45 | 350 | 288.25 | 1310
 | 2001-04-02 00:00:00 |  | 284.36 | 24400 | 227.63 | 9504 | 294.16 | 942 | 216.95 | 351
 | 2001-04-01 00:00:00 |  | 236.99 | 2336 | 225 | 0 | 243.67 | 158 | 219.78 | 273 |  | 229.73 | 26352
 | 2001-03-31 00:00:00 |  | 179.66 | 24400 | 125.17 | 9640 | 220.77 | 698 | 100 | 4
 | 2001-03-30 00:00:00 |  | 179.99 | 23600 | 125.18 | 9040 | 203.23 | 798 | 173.41 | 504
 | 2001-03-29 00:00:00 |  | 187.27 | 26400 | 130.98 | 10880 | 181.96 | 553 | 151.95 | 154
 | 2001-03-28 00:00:00 |  | 161.91 | 27600 | 100.36 | 9480 | 170.67 | 208 | 110.85 | 544
 | 2001-03-27 00:00:00 |  | 155.95 | 22800 | 89.58 | 6200 | 152.08 | 1038 | 121.24 | 169
 | 2001-03-26 00:00:00 |  | 334.36 | 15600 | 230.55 | 6600 | 102.59 | 243 | 60.96 | 287
 | 2001-03-25 00:00:00 |  | 260 | 0 | 230 | 0 | 70 | 200 | 41.32 | 456 |  | 229.94 | 19200
 | 2001-03-24 00:00:00 |  | 312.79 | 15600 | 217.52 | 5960 | 113.77 | 1687 | 139.44 | 832
 | 2001-03-23 00:00:00 |  | 312.79 | 15600 | 217.52 | 5960 | 331.82 | 1155 | 150 | 4
 | 2001-03-22 00:00:00 |  | 377.69 | 16800 | 274.53 | 6400 | 233.97 | 521 | 266.13 | 248
 | 2001-03-21 00:00:00 |  | 452.08 | 17280 | 319.69 | 4928 | 443.97 | 58 | 294.11 | 259
 |  |  |  |  |  | ..
Spreadsheet: 64837d1265660749-completely-freeze-formulas-help-help
Sheet: Sheet1

unsorted data |  |  |  | sorted data |  |  |  | How it should be
[NAME] | data2 |  |  | [NAME] |  |  |  | [NAME]
data3 | data3 |  |  |  | data2 |  |  |  | data2
data4 | data5 |  |  | data3 | data3 |  |  | data3 | data3
data5 | [NAME] |  |  | data4 |  |  |  | data4
[NAME] | data7 |  |  | data5 | data5 |  |  | data5 | data5
 |  |  |  | [NAME] | [NAME] |  |  | [NAME] | [NAME]
 |  |  |  |  | data7 |  |  |  | data7
 |  |  |  |  |  | now they reference different cells |  |  |  | everything is good so I do not need to fix anything