tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 738391d1625001579-ranking-sales-team-when-columns-have-different-weight-values-base-list-ranking
Sheet: Sheet1

 | CURRENT WEEK
 |  |  |  |  |  |  |  |  | 0.5 |  | 0.2 |  | 0.3
 | # | Base List |  | RANK |  | # | 2 Week Rolling |  | Gross |  | PRU MTD |  | Appts Set |  | EG | Week 3 June | Week 4 June | Total
 | 1 | Manual |  | 1 |  | 1 | Manual |  | 37501 |  | 1941 |  | 10 |  | Mario | 12691 | 13920 | 26611
 | 2 | Mario |  | 2 |  | 2 | Mario |  | 26611 |  | 2667 |  | 15 |  | DD | 13372 | 4425 | 17797
 | 3 | Riki |  | 3 |  | 3 | Riki |  | 22709 |  | 2926 |  | 8 |  | Rufus | 3652 | 11736 | 15388
 | 4 | [NAME] |  | 4 |  | 4 | [NAME] |  | 20002 |  | 1862 |  | 20 |  | [NAME] | 10799 | 9203 | 20002
 | 5 | DD |  | 5 |  | 5 | DD |  | 17797 |  | 2144 |  | 5 |  | [NAME] | 4361 | 10484 | 14845
 | 6 | [NAME] |  | 6 |  | 6 | Rufus |  | 15388 |  | 1912 |  | 6 |  | [NAME] | 2553 | 10495 | 13048
 | 7 | Rufus |  | 7 |  | 7 | [NAME] |  | 14845 |  | 2299 |  | 3 |  | Adam | 6786 | 7042 | 13828
 | 8 | [NAME] |  | 8 |  | 8 | [NAME] |  | 13888 |  | 1985 |  | 5 |  | [NAME] | 6691 | 7197 | 13888
 | 9 | Adam |  | 9 |  | 9 | Adam |  | 13828 |  | 1967 |  | 8 |  | [NAME] | 10093 | 1990 | 12083
 | 10 | [NAME] |  | 10 |  | 10 | [NAME] |  | 13048 |  | 1654 |  | 10 |  | Manual | 23562 | 13939 | 37501
 | 11 | [NAME] |  | 11 |  | 11 | [NAME] |  | 12083 |  | 1421 |  | 12 |  | Riki | 15066 | 7643 | 22709
 | 12 | Arty |  | 12 |  | 12 | [NAME] |  | 5974 |  | 996 |  | 4 |  | [NAME] | 2721 | 3253 | 5974
 | 13 | [NAME] |  | 13 |  | 13 | Arty |  | 4966 |  | 1655 |  | 7 |  | Arty | 0 | 4966 | 4966
 | PREVIOUS WEEK
 |  |  |  |  |  |  |  |  | 0.5 |  | 0.2 |  | 0.3
Previous | # | Base List |  | RANK |  | # | 2 Week Rolling |  | Gross |  | PRU MTD |  | Appts Set |  | EG | Week 2 June | Week 3 June | Total
 | 1 | Manual |  | 1 |  | 1 | Manual |  | 39263 |  | 2077 |  | 10 |  | Mario | 11892 | 12691
 | 2 | DD |  | 2 |  | 2 | DD |  | 25090 |  | 2196 |  | 15 |  | DD | 11718 | 13372
 | 3 | Mario |  | 3 |  | 3 | Riki |  | 24862 |  | 2925 |  | 8 |  | Rufus | 7472 | 3652
 | 4 | Riki |  | 4 |  | 4 | Mario |  | 24583 |  | 2458 |  | 7 |  | [NAME] | 13266 | 10799
 | 5 | [NAME] |  | 5 |  | 5 | [NAME] |  | 24065 |  | 1752 |  | 5 |  | [NAME] | 6614 | 4361
 | 6 | Adam |  | 6 |  | 6 | Adam |  | 20839 |  | 1894 |  | 6 |  | [NAME] | 14730 | 2553
 | 7 | [NAME] |  | 7 |  | 7 | [NAME] |  | 18000 |  | 1465 |  | 3 |  | Adam | 14053 | 6786
 | 8 | [NAME] |  | 8 |  | 8 | [NAME] |  | 17283 |  | 1511 |  | 5 |  | [NAME] | 6749 | 6691
 | 9 | [NAME] |  | 9 |  | 9 | [NAME] |  | 13440 |  | 1727 |  | 8 |  | [NAME] | 7907 | 10093
 | 10 | Rufus |  | 10 |  | 10 | Rufus |  | 11124 |  | 1544 |  | 10 |  | Manual | 15701 | 23562
 | 11 | [NAME] |  | 11 |  | 11 | [NAME] |  | 10975 |  | 2455 |  | 12 |  | Riki | 10945 | 13917
 | 12 | [NAME] |  | 12 |  | 12 | [NAME] |  | 2721 |  | 907 |  | 4 |  | [NAME] |  | 2721
 | 13 | Arty |  | 13 |  | 13 | Arty |  | 0 |  | 0 |  | 7 |  | Arty |  | 0
Spreadsheet: 877386d1724225071-lookup-based-on-unique-value-and-date-within-a-date-range-employee-number-and-date-within-range-lookup
Sheet: Sheet1

Employee Number | Leave Type | Leave Group | End Date |  |  | Employee Number | Position Start | Position End | Leave Group
1000397 | ANN | 724 | 2024-08-19 00:00:00 |  |  | 1000397 | 2023-10-05 00:00:00 |  | 724
1000397 | ANN | 724 | 2024-08-16 00:00:00 |  |  | 1000397 | 2015-01-27 00:00:00 | 2022-10-04 00:00:00 | SA1
1000397 | ANN | 724 | 2024-07-10 00:00:00
1000397 | ANN | 724 | 2024-06-20 00:00:00
1000397 | ANN | 724 | 2024-05-23 00:00:00
1000397 | ANN | 724 | 2024-05-03 00:00:00
1000397 | ANN | 724 | 2024-03-22 00:00:00
1000397 | ANN | 724 | 2023-11-17 00:00:00
1000397 | ANN | 724 | 2023-11-10 00:00:00
1000397 | ANN | 724 | 2023-10-10 00:00:00
1000397 | ANN | SA1 | 2023-09-14 00:00:00
1000397 | ANN | SA1 | 2023-09-01 00:00:00
1000397 | ANN | SA1 | 2023-08-30 00:00:00
1000397 | ANN | SA1 | 2023-06-16 00:00:00
1000397 | ANN | SA1 | 2023-05-30 00:00:00
1000397 | ANN | SA1 | 2023-05-19 00:00:00
 |  | Lookup leave group based on unique employee number and leave end date
Spreadsheet: 86c5eb40-1e61-42cc-8c7f-e9ebc24a4e95
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21
Table S1: Comparison of Campylobacter species plasmids
Organism |  |  | C. coli |  | C. lari |  |  | C. upsaliensis |  |  | [NAME]
 |  |  | RM2228 |  | RM2100 |  |  | RM3195 |  |  | 81-176
Name |  |  | pCC178 |  | pCL46 |  | pCU110 |  | pCU3 |  | pVir
[NAME] (nucleotides) |  |  | 178271 |  | 46199 |  | 110280 |  | 3134 |  | 37486
G+C content |  |  | 0.2862 |  | 0.2678 |  | 0.3023 |  | 0.2656 |  | 0.26
Number of ORFs (less pseudogenes) |  |  | 201 |  | 45 |  | 147 |  | 5 |  | 54
ORFs on plus strand (percent) |  |  | 105 (57) |  | 28 (62) |  | 115 (78) |  | 0 (0) |  | 52 (96)
ORFs on minus strand (percent) |  |  | 96 (47) |  | 17 (38) |  | 32 (22) |  | 5 (100) |  | 2 (4)
Hypothetical |  |  | 98 |  | 16 |  | 71 |  | 3 |  | 44
 |  |  | 0.4875621890547264 |  | 0.3555555555555556 |  | 0.4829931972789115 |  | 0.6 |  | 0.8148148148148148 |  |  |  |  |  |  |  | 25 |  | 81.48148148148148
Conserved Hypothetical |  |  | 50 |  | 2 |  | 18 |  | 1 |  | *
 |  |  | 0.2487562189054726 |  | 0.04444444444444445 |  | 0.1224489795918367 |  | 0.2
Assigned function |  |  | 49 |  | 26 |  | 53 |  | 1 |  | 10
 |  |  | 0.2437810945273632 |  | 0.5777777777777777 |  | 0.3605442176870748 |  | 0.2 |  | 0.1851851851851852
Unknown function |  |  | 6 |  | 1 |  | 5 |  | 0 |  | *
 |  |  | 0.02985074626865672 |  | 0.02222222222222222 |  | 0.03401360544217687 |  | 0
Pseudogenes |  |  | 2 |  | 0 |  | 0 |  | 0 |  | *
 |  |  | 0.009950248756218905 |  | 0 |  | 0 |  | 0
a Bacon et al Infection and Immunity 70(11): 6242-6250
Spreadsheet: louise_kitchen__22506__Turbine Position Report 090701
Sheet: Summary by Region

Turbine Position Report |  |  |  |  |  |  |  | CONFIDENTIAL
Summary by Controlling Region
($ MMs)
 |  |  |  |  |  |  | Financial Data as of
UNITS | MODEL | CONTROLLED BY | STATUS | DASH APPROVAL DATE / STATUS | PROJECT(S) | CONTRACT COST | SCHEDULED CONTRACT PYMTS TO DATE | CANCELLATION
EEL
 |  |  |  |  | TOTAL EEL
EA
 |  |  |  |  | TOTAL EA
EGM
PGE
 | UNITS - TOTAL |  |  |  | GRAND TOTALS
 |  |  |  |  | per Summary By [NAME] report
 |  |  |  |  | Difference
Spreadsheet: 219288d1362699741-make-a-list-from-items-not-checked-off-isolation-blinds-tracker
Sheet: 2800

BLIND List
February 2013 Refinery Shutdown
 |  | Total Blinds |  | 2800 Isolation Blinds
Common To | Date | Blind/ LOTO # | Tag # | Size | Rating | Service | Location | [NAME] | [NAME] | [NAME] | Needs Insulation Removed | Ready to Blind | Blinded
 |  | 1 |  | 1" |  | Fuel Gas | Spec blind on line to D-2801 inlet line |  |  |  |  |  |  |  | % Hung
 |  | 2 |  | 8" |  | Fuel Gas | D2801 inlet between valve and check valve |  |  |  |  |  |  |  | % Needing Scaffold
 |  | 3 |  | 3" |  | N2 | N2 to D-2801 upstream of 28FT009 |  |  |  |  |  |  |  | % Scaffold Built
 |  | 4 |  | 1 ½" |  | Water | 28LC005 Upstream block valve |  |  |  |  |  |  |  | % Needs Insulation Removed
 |  | 5 |  | 1 ½" |  | Water | 28LC005 bypass valve |  |  |  |  |  |  |  | % Ready to Blind
 |  | 6 |  | 1 ½" |  | Water | 28LC013 upstream block valve |  |  |  |  |  |  |  | % Blinded
 |  | 7 |  | 1 ½" |  | Water | 28LC013 bypass valve
 |  | 8 |  | 1 ½" |  | Water | 28LC009 upstream block valve
 |  | 9 |  | 1 ½" |  | Water | 28LC009 bypass valve
 |  | 10 |  | 4" |  | Fuel Gas | Compressed Fuel gas to 28PC059
 |  | 11 |  | [NAME]" |  | Odorant | Odorant Injection point
 |  | 12 |  | 1" |  | Fuel Gas | PSEG Sales Gas Analyzer Tap
 |  | 13 |  | 8" |  | Fuel Gas | Refinery Fuel Gas to PSEG
 |  | 14 |  | 1 ½" |  | LPG | 28LC020 upstream block valve
 |  | 15 |  | 1 ½" |  | LPG | 28LC020 bypass valve
 |  | 16 |  | 2" |  | Propane | C3 to vaporizer 28FT003 downstream block
 |  | 17 |  | 2" |  | Propane | C3to vaporizer 28FT003 bypass
 |  | 18 |  | 3" |  | Fuel Gas | Fuel Gas Compression Bypass to 28FC302
 |  | 19 |  | 3" |  | Fuel Gas | Fuel Gas Compression Bypass to 28FC302
 |  | 20 |  | 1" |  | Fuel Gas | Fuel Gas to D-603 from PSEG at D-2803
 |  | 21 |  | 1" |  | Fuel Gas | Buffer Gas to D-603
 |  | 22 |  | 3" |  | Fuel Gas | FG to D-2804, 28PC367B Upstream Block
 |  | 23 |  | 3" |  | Fuel Gas | FG to D-2804, 28PC367B Bypass
 |  | 24 |  | 2" |  | H2 | LP H2 to D2804, 42FC366 downstream Block
 |  | 25 |  | 2" |  | H2 | LP H2 to D2804, 42FC366 Bypass
 |  | 26 |  | 6" |  | Fuel Gas | Vaporizer Outlet to D-2803
 |  | 27 |  | 4" |  | FG/H2 | Purge Gas and [NAME] to D-2803
Spreadsheet: dfc52391-71f7-48b1-8412-fdbd93e6e647
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
TOXGP | Test | TOXGP | Toxoplasma gondii Antibody, IgG, Serum | [NAME], IgG, S | [NAME] (MFI) | Plain, Red-Top Tube: Red Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK  Lipemia	Mild OK; Gross reject Icterus	NA Other	Heat-inactivated specimen | Toxoplasma ANTIBODY, IgG Negative   Toxoplasma IgG VALUE < or =9 IU/mL (Negative) 10-11 IU/mL (Equivocal) > or =12 IU/mL (Positive) | Monday through Saturday, 9 a.m. | Same day/1 day | 3 days | 1 | 86777 |  |  |  |  | Rochester
TOXGP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
TOXGP | Result | TOXG | [NAME], IgG, S | [NAME], IgG, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5388-4 | Toxoplasma gondii Ab.[NAME]:ACnc:Pt:Ser:Qn:EIA
TOXGP | Result | DEXG6 | Toxoplasma IgG Value | Toxoplasma IgG Value | Numeric |  |  |  |  | IU/mL |  |  |  |  |  |  |  |  |  | In Process | Toxoplasma gondii Ab.IgG avidity:Threshold:Pt:Ser:Ord:EIA
Spreadsheet: 160695d1339167179-show-time-cell-last-edited-employee-work-sheet
Sheet: Sheet1

EMPLOYEE WORK SHEET
 | Club Ped/Office Fuction | Training/Meetings | Time Off/Holiday | Breaks | Phone Coverage | Downtime | [NAME] | Lunch | Processing Hours
Monday |  |  |  | 0.5 |  |  |  | 0.5
Tuesday |  | 0.5 |  | 0.5 |  |  |  | 0.5
Wednesday |  |  |  | 0.5 |  |  |  | 0.5
Thursday |  |  |  | 0.5 |  |  |  | 0.5
Friday |  |  | 0.5 | 0.5 |  |  |  | 0.5
Totals
Spreadsheet: 178591d1346850203-how-to-assign-a-value-to-a-data-point-bill
Sheet: Sheet2

Team | [NAME] |  | Leggo My Ego |  | ABC &RGIII |  | [NAME] |  | 3 QBs |  | Gamebreakers |  | Favorites |  | Hillbilly Teeth |  | UGF |  | [NAME] |  | First place Votes | Ranking pts |  |  | Vote | Value
LBs Vag |  |  | 4 |  |  |  | 8 |  | 5 |  | 5 |  |  |  | 6 |  | 7 |  |  |  |  |  |  |  | 1 | 12
Leggo My Ego | 6 |  |  |  |  |  | 6 |  | 7 |  | 2 |  |  |  | 2 |  | 4 |  |  |  |  |  |  |  | 2 | 10
ABC Easy as RGIII | 8 |  | 9 |  |  |  | 9 |  | 9 |  | 9 |  |  |  | 5 |  | 6 |  |  |  |  |  |  |  | 3 | 8
[NAME] | 5 |  | 7 |  |  |  |  |  | 8 |  | 1 |  |  |  | 3 |  | 5 |  |  |  |  |  |  |  | 4 | 6
3QBs are better than 1 | 4 |  | 8 |  |  |  | 7 |  |  |  | 7 |  |  |  | 4 |  | 9 |  |  |  |  |  |  |  | 5 | 4
Kings Gamebreakers | 3 |  | 1 |  |  |  | 1 |  | 4 |  |  |  |  |  | 9 |  | 8 |  |  |  |  |  |  |  | 6 | 2
Preseason Favorites | 1 |  | 2 |  |  |  | 5 |  | 1 |  | 6 |  |  |  | 8 |  | 3 |  |  |  |  |  |  |  | 7 | 0
Hillbilly Teeth | 2 |  | 3 |  |  |  | 4 |  | 2 |  | 8 |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 8 | -2
Ugandan Horse Factory | 9 |  | 6 |  |  |  | 2 |  | 3 |  | 4 |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 9 | -4
Team Dotseth | 7 |  | 5 |  |  |  | 3 |  | 6 |  | 3 |  |  |  | 7 |  | 1
Spreadsheet: darrell_schoolcraft__7816__imbalsumm0109
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 | -10654 | -6710
9238 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 | -605395 | -541704
58710 | -1 | -230
60921 | 430152 | 340561
78026 |  | 17447
500084 | -3948 | -5000
500085
500097 | -1752
INDEX
2001-08-31 00:00:00 |  |  | 133131.64
2001-09-05 00:00:00
CBS Volume
 |  |  | 8541
Spreadsheet: 768091d1644839508-joining-2-formulas-to-produce-a-count-data2
Sheet: Sheet1

Product ID | Product ID from Sheet 2 exist in Product ID column on Sheet1? | Status
G0100016728404 |  | Active
G010002709922A
G010002712594Z |  | Active
G010003974546C
G010000743924O |  | Active
G010003535476B
G010000641457T
G010003715027R
G010003711100X
G010003535432X
G010003535463L |  | Active
G0100037116702 |  | Active
G010003711673V |  | Active
G010003535462N |  | Active
G010003535343Z
G010003711093W
G010003711671Z |  | Active
G0100035352286
G010003711710I
G010003535345V
G010003535259R |  | Active
G010002001586A
G010003535187R
G0100035352294 |  | Active
 |  |  |  | Total Yes
 |  |  |  | Total Active
 |  |  |  | Total Yes and Active
Spreadsheet: cc874787-a3a7-482c-9e7a-5c0519a69155
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
6319 | 10229 | Ragnhild | Bolstad | NOR | 0 | [NAME] | 00:00:00 | [NAME] | 00:00:00 | 00:23:18 | 1 | 01:14:34
6319 | 10248 | Anne | Hernani | ESP | 0 | 00:17:43 | 00:00:00 | [NAME] | 00:00:00 | 00:28:29 | 2 | 01:24:40
6319 | 10324 | [NAME] | [NAME] | ITA | 0 | 00:19:04 | 00:00:00 | 00:41:23 | 00:00:00 | 00:31:45 | 3 | 01:32:12
6319 | 10251 | [NAME] | Angioi | ITA | 0 | 00:18:47 | 00:00:00 | 00:44:39 | 00:00:00 | 00:56:08 | 4 | [NAME]
Spreadsheet: e71cf91d-9410-4c39-aba2-4fe28fd26163
Sheet: Sheet1

Judgeship Number 6 (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 5/23/2013 5:29:57 PM
Precincts Reporting: 607/607 - Total Ballots Cast: 316016
2004 General Election - OFFICIAL RESULTS
Precinct | [NAME] | TOTALS
Precinct 2006 | 265 | 265
Precinct 2010 | 76 | 76
Precinct 2012 | 226 | 226
Precinct 2013 | 231 | 231
Precinct 2401 | 322 | 322
Precinct 2402 | 667 | 667
Precinct 2403 | 410 | 410
Precinct 2404 | 608 | 608
Precinct 2405 | 856 | 856
Precinct 2407 | 213 | 213
Precinct 2408 | 103 | 103
Precinct 2409 | 210 | 210
Precinct 2411 | 510 | 510
Precinct 2414 | 106 | 106
Precinct 2415 | 223 | 223
TOTAL | 5026 | 5026
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 818246d1676664378-expanding-a-formula-school-closures-new-formula
Sheet: MASTER

School | OPERATIONAL REQUIREMENTS | WEATHER | FACILITY | FUNERAL
AES
ALO
AQS
ARN
ATT
IGH
IHS
INU
JOA
NAK
NAN
NAS
NUI
PAA
PPS
QAQ
QAR
QIK
QUL
SMS
SPS
ULA
UMI
Spreadsheet: 672101d1586736924-from-daily-data-display-each-months-maximum-value-and-its-date-test_set
Sheet: Sheet1

Date | Value |  | Month-Year | [NAME]. Value |  |  | Month | Year
2012-03-01 00:00:00 | 26.16 |  | 2012-03-01 00:00:00 |  |  |  | 3 | 2012
2012-03-02 00:00:00 | 25.44 |  | 2012-04-01 00:00:00 |  |  |  | 4 | 2012
2012-03-03 00:00:00 | 11.92 |  |  |  |  |  | 5 | 2012
2012-03-04 00:00:00 | 14.32 |  |  |  |  |  | 6 | 2012
2012-03-05 00:00:00 | 5.84 |  |  |  |  |  | 7 | 2012
2012-03-06 00:00:00 | 11.58 |  |  |  |  |  | 8 | 2012
2012-03-07 00:00:00 | 20.59 |  |  |  |  |  | 9 | 2012
2012-03-08 00:00:00 | 19.38 |  |  |  |  |  | 10 | 2012
2012-03-09 00:00:00 | 24.52 |  |  |  |  |  | 11 | 2012
2012-03-10 00:00:00 | 25.61 |  |  |  |  |  | 12 | 2012
2012-03-11 00:00:00 | 17.31 |  |  |  |  |  | 1 | 2013
2012-03-12 00:00:00 | 18.51 |  |  |  |  |  | 2 | 2013
2012-03-13 00:00:00 | 23.5 |  |  |  |  |  | 3 | 2013
2012-03-14 00:00:00 | 6.49 |  |  |  |  |  | 4 | 2013
2012-03-15 00:00:00 | 14.49 |  |  |  |  |  | 5 | 2013
2012-03-16 00:00:00 | 14.7 |  |  |  |  |  | 6 | 2013
2012-03-17 00:00:00 | 12.08
2012-03-18 00:00:00 | 8.54
2012-03-19 00:00:00 | 16.27
2012-03-20 00:00:00 | 18.82
2012-03-21 00:00:00 | 16.27
2012-03-22 00:00:00 | 6.37
2012-03-23 00:00:00 | 13.45
2012-03-24 00:00:00 | 21.9
2012-03-25 00:00:00 | 18.55
2012-03-26 00:00:00 | 19.82
2012-03-27 00:00:00 | 22.85
2012-03-28 00:00:00 | 20.02
2012-03-29 00:00:00 | 21.97
2012-03-30 00:00:00 | 22.05
2012-03-31 00:00:00 | 21.25
2012-04-01 00:00:00 | 19.47
2012-04-02 00:00:00 | 20.4
2012-04-03 00:00:00 | 23.23
2012-04-04 00:00:00 | 19.44
2012-04-05 00:00:00 | 20.78
2012-04-06 00:00:00 | 20.84
2012-04-07 00:00:00 | 22.8
2012-04-08 00:00:00 | 16.22
2012-04-09 00:00:00 | 22.34
2012-04-10 00:00:00 | 19.99
2012-04-11 00:00:00 | 17.85
2012-04-12 00:00:00 | 18.84
2012-04-13 00:00:00 | 15.97
2012-04-14 00:00:00 | 13.5
2012-04-15 00:00:00 | 11.3
2012-04-16 00:00:00 | 13.52
2012-04-17 00:00:00 | 12.76
2012-04-18 00:00:00 | 17.78
2012-04-19 00:00:00 | 18.75
2012-04-20 00:00:00 | 13.44
2012-04-21 00:00:00 | 20.04
2012-04-22 00:00:00 | 16.74
2012-04-23 00:00:00 | 14.34
2012-04-24 00:00:00 | 6.13
2012-04-25 00:00:00 | 7.29
2012-04-26 00:00:00 | 20.97
2012-04-27 00:00:00 | 4.12
2012-04-28 00:00:00 | 1.72
2012-04-29 00:00:00 | 9.47
2012-04-30 00:00:00 | 18.62
Spreadsheet: darrell_schoolcraft__7802__imbalsumm0108
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 | -68011 | -37500 | -90 | -29410
2 | -49057 | -20000 |  | -27910
3 | -48415 | -11000 |  | -36910
4 | -29951 |  |  | -29410
5 | -29999 |  |  | -29410
6 | -29297 |  |  | -28307
7 | -64051 | -11000 |  | -51049
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-07-31 00:00:00 |  |  |  | 30084
 | 2001-08-07 00:00:00
CBS Dollars
 |  |  | -47295
Spreadsheet: 714227d1611148089-hlookup-with-nested-match-function-hlookupfile
Sheet: Summary

 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
McDonalds
GM
Apple
IBM
Microsoft
Honda
Toyota
Chevron
Shell
Belkin
Spreadsheet: 815392d1674917126-nested-if-and-or-statements-issue-criteria
Sheet: criteria

 |  | Eileen and a.jpg | E and a.jpg
 | 1900s_Dick_grt_grndprnts_maternal_side_est_0001.jpg
 | 1900s_Dick_E_grt_grndprnts_maternal_side_est_0001.jpg
 | 1900s_Dick_E_grt_grndprnts_maternal_side_est_0001a.jpg
 | 1900s_Dick_Eileen_grt_grndprnts_maternal_side_est_0001.jpg
 | 1900s_Dick_Eileen_grt_grndprnts_maternal_side_est_0001a.jpg
 | 1900s_Dick_Eileen_grt_grndprnts_maternal_side_est_0001a.jpg
 | 1900s_Dick_Eileen_grt_grndprnts_maternal_side_est_0001a.jpg | IF(OR(ISNUMBER(SEARCH("Eileen",B9)),ISNUMBER(SEARCH("_E_",B9))),(AND((ISNUMBER(SEARCH("a.jpg",B9)),ISNUMBER(SEARCH("b.jpg",B9),"Valid ","")
 |  | Test
 | 1900s_Dick_Eileen_grt_grndprnts_maternal_side_est_0001a.jpg |  | for [NAME] or E
 | 1900s_Dick_E_grt_grndprnts_maternal_side_est_0001a.jpg |  | for a.jpg or b.jpg
 | 1900s_Dick_E_grt_grndprnts_maternal_side_est_0001b.jpg |  | for a.jpg or b.jpg
 | 1900s_Dick_E_grt_grndprnts_maternal_side_est_0001.jpg |  | for a.jpg or b.jpg
 |  | Test | Combined formulaes
 | 1900s_Dick_Eileen_grt_grndprnts_maternal_side_est_0001a.jpg
 | 1900s_Dick_E_grt_grndprnts_maternal_side_est_0001a.jpg
 | 1900s_Dick_E_grt_grndprnts_maternal_side_est_0001b.jpg
 | 1900s_Dick_E_grt_grndprnts_maternal_side_est_0001.jpg
Spreadsheet: 860633d1708653218-does-a-derivative-of-sumif-exist-avgirondistance
Sheet: Sheet1

 |  | Average Distance
 | 5i | For each "5i" in column B, add the value in Column A to the value in column C.  Then, divide by the count of "5i" in column B.
 | 5i |  | <- This formula incorporates Shot #1, 3, and 5.  However, there wasn't a shot and thus the cell (D11) was null.  How can null cells be excluded from the formula?  If they aren't excluded, this formula overstates the average distance.
Shot | Yardage | Iron | -Lft / +Rgt
1 | 195 | 5i | -2
2 | 135 | 58* | 11
3 | 200 | 5i | 8
4 | 120 | 58* | -7
5 | 205 | 5i |  | If not
6 | 175 | 58*
Spreadsheet: 165626d1341306314-conidtional-formatting-across-columns-0acf-6
Sheet: Φύλλο2

col1 |  |  |  |  | [NAME]
[NAME] |  |  |  |  | fg
fg |  |  |  |  | fggh
col58 |  |  |  |  | col12
yyy |  |  |  |  | col5
col5 |  |  |  |  | col6
Spreadsheet: 24342d1214556705-inserting-a-block-of-cells-using-an-if-statement-sample1
Sheet: Sheet1

 | 3 |  | 26 |  | 34 |  | 50 |  |  | 1
 | 4 |  | 27 |  | 35 |  | 51 |  |  | 2
 | 5 |  | 28 |  | 36 |  | 52 |  |  | 3
 | 6 |  | 29 |  | 37 |  | 53 |  |  | 4
 | sample |  | sample1 |  | sample2 |  | [NAME]
 | text |  | text1 |  | text2 |  | text3
Select number: | 1
Spreadsheet: john_griffith__15952__11_15_01GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 49 | 400 | 500 | 56.5 | 70.6 | 1.96 | 2001-11-15 14:55:00
 | HU F2 | 50 | 720 | 820 | 54.1 | 61.7 | 1.82 | 2001-11-15 14:55:00
 | HU G2 | 52 | 910 | 1050 | 49.2 | 56.8 | 1.73 | 2001-11-15 14:55:00
 | [NAME] | 53 | 1125 | 1250 | 51 | 56.7 | 1.79 | 2001-11-15 14:55:00
 | [NAME] | 60 | 1300 | 1450 | 46.3 | 51.7 | 1.85 | 2001-11-15 14:55:00
 | [NAME] | 60 | 1450 | 1550 | 46.6 | 49.8 | 1.82 | 2001-11-15 14:55:00
 | [NAME] | 60 | 1475 | 1675 | 43.4 | 49.4 | 1.75 | 2001-11-15 14:55:00
 | HU N2 |  |  |  | 39.3 | 43.3 | 1.64 | 2001-11-14 11:13:00
 | [NAME] |  |  |  | 36.7 | 41.4 | 1.64 | 2001-11-09 14:53:00
 | HU U2 |  |  |  | 36 | 39.4 | 1.59 | 2001-10-29 14:33:00
 | [NAME] |  |  |  | 32.2 | 36.6 | 1.43 | 2001-10-22 14:23:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | HU F3
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | HU H3
Spreadsheet: 66830d1267523841-help-needed-trying-to-match-values-helpv2
Sheet: Portfolio

GID | City / Town | Contra GID | Contra Name | City / Town | [NAME] | Material | Stock Type | Contra Stock Type | DoD | DoR | DoN | Posting Date | Ref 1 | Ref 2 | Ref 3 | UMI | Qty | Stock | add | deduct | query
100548290 | PONTEFRACT | 100389736 | DBC Foodservice Ltd | THATCHAM | DBC Foodservice Ltd | 1 | 1 | 5 | 2008-12-18 00:00:00 | 2008-12-18 00:00:00 | 2008-12-18 00:00:00 | 18/12/2008 | [PHONE] | 11030971 | # | 02008089593804 | -13 | 2887 |  | -13
100548290 | PONTEFRACT | 100200450 | Hunts Frozen Food Ltd | BRISTOL | Hunts Frozen Food Ltd | 1 | 1 | 5 | 2008-12-18 00:00:00 | 2008-12-18 00:00:00 | 2008-12-18 00:00:00 | 18/12/2008 | [PHONE] | 11031003 | # | 02008089593807 | -7 | 3256 |  | -7
100548290 | PONTEFRACT | [PHONE] | Total Food Services | HUDDERSFIELD | Total Food Services | 1 | 1 | 5 | 2008-12-18 00:00:00 | 2008-12-18 00:00:00 | 2008-12-18 00:00:00 | 18/12/2008 | [PHONE] | 11031007 | # | 02008089593798 | -7 | 2880 |  | -7
100548290 | PONTEFRACT | 100340519 | Delitalia | BARNSLEY | Delitalia | 1 | 1 | 5 | 2008-12-18 00:00:00 | 2008-12-18 00:00:00 | 2008-12-18 00:00:00 | 18/12/2008 | [PHONE] | 11031008 | # | 02008089593803 | -4 | 2912 |  | -4
100548290 | PONTEFRACT | [PHONE] | TYNESIDE FOOD SERVICES | BLAYDON | TYNESIDE FOOD SERVICES | 1 | 1 | 5 | 2008-12-18 00:00:00 | 2008-12-18 00:00:00 | 2008-12-18 00:00:00 | 18/12/2008 | [PHONE] | 11031010 | # | 02008089593800 | -4 | 2876 |  | -4
100548290 | PONTEFRACT | 100532527 | McBurney Ltd ([NAME]) | LIVERPOOL | [NAME] | 1 | 1 | 1 | 2009-01-05 00:00:00 | 2009-01-05 00:00:00 | 2009-01-05 00:00:00 | 05/01/2009 | [PHONE] | 11031020 | # | 02009000670727 | -7 | 3582 |  | -7
100548290 | PONTEFRACT | 100532527 | McBurney Ltd ([NAME]) | LIVERPOOL | [NAME] | 1 | 1 | 1 | 2009-01-06 00:00:00 | 2009-01-06 00:00:00 | 2009-01-06 00:00:00 | 06/01/2009 | [PHONE] | 11031020 | # | 02009000935994 | -7 | 3480 |  | -7