tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 719694d1613757283-count-distinct-values-in-two-columns-where-the-third-matches-a-value-unique-count
Sheet: Sheet1

days | ID | organisation |  |  | expected results
2020-01-01 00:00:00 | 1 | CNN |  |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00
2020-01-02 00:00:00 | 124 | CNN |  |  | ABC | 0 | 2 | 1
2020-01-21 00:00:00 | 123 | CNN | same day and IDs |  | CNN | 3 | 0 | 1
2020-01-21 00:00:00 | 123 | CNN |  |  | IBM | 0 | 1 | 0
2020-02-01 00:00:00 | f | IBM | same day different IDs
2020-02-01 00:00:00 | C | IBM
2020-02-02 00:00:00 | B | ABC | same ID different dates
2020-02-03 00:00:00 | B | ABC
2020-03-01 00:00:00 | B | ABC
2020-03-01 00:00:00 |  | CNN | blank ID - handling this (i.e. not producing an error) is not essential
2020-03-01 00:00:00 | v | CNN
Spreadsheet: 165107d1341021085-sum-month-columns-into-years-book1_imholter
Sheet: Sheet1

Data
 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00
Chemical1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Chemical2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Chemical3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
Chemical4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
Result
 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013
Chemical1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 12 | 1
Chemical2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 24 | 2
Chemical3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 36 | 3
Chemical4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 48 | 4
Spreadsheet: 879350d1726831568-data-lookup-based-upon-date-range-test-document-windknife
Sheet: Report

From Date | 2024-09-21 00:00:00
To Date | 31/09/2024
ID | V1 COMMENTS | REJECTION REASON | V2 COMMENTS | REJECTION REASON
555624 |  | [NAME]
Expected results
Date range set to 01/01/2024 to 20/09/2024
ID | V1 COMMENTS | REJECTION REASON | V2 COMMENTS | REJECTION REASON
555624 | Test comment | Incorrect Colour
Expected results
Date range set to 01/01/2024 to 31/09/2024
ID | V1 COMMENTS | REJECTION REASON | V2 COMMENTS | REJECTION REASON
555624 | Test comment | Incorrect Colour | Test comment number 2 | [NAME]
Expected results
Date range set to 21/09/2024 to 31/09/2024
ID | V1 COMMENTS | REJECTION REASON | V2 COMMENTS | REJECTION REASON
555624 |  |  | Test comment number 2 | [NAME]
Spreadsheet: 880356d1727992819-adding-another-equation-into-the-the-mix-test-file-4-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02 | / Month
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TERM
 |  |  |  | 15013 |  | 2023-05-01 00:00:00 | 2024-09-03 00:00:00 | True | False | 61570 | 58010 | 1000 |  |  | 34300 | HARD FIGURE
 |  |  |  | 14858 |  | 2023-06-30 00:00:00 | 2024-08-29 00:00:00 | True | False | 59950 | 56545 | 1000 |  |  | 35100 | HARD FIGURE
 |  |  |  | 16029 |  | 2024-01-31 00:00:00 | 2024-08-31 00:00:00 | True | False | 62910 | 59245 | 1000 |  |  | 42500 | HARD FIGURE
 |  |  |  | 8E18669 |  | 2024-01-31 00:00:00 |  | False | False | 45065 | 42655 | 500 |  |  |  | False
 |  |  |  | 7N62794 |  | 2024-01-31 00:00:00 |  | False | False | 42895 | 40640 | 500 |  |  |  | False
 |  |  |  | 7N71090 |  | 2024-01-31 00:00:00 |  | False | False | 44195 | 41850 | 500 |  |  |  | False
 |  |  |  | FS28362 |  | 2024-01-31 00:00:00 |  | False | False | 54115 | 51070 | 500 |  |  |  | False
 |  |  |  | 9V40554 |  | 2024-02-29 00:00:00 | 2024-08-31 00:00:00 | True | False | 51330 | 48470 | 500 |  |  | 38800 | HARD FIGURE
 |  |  |  | 15849 |  | 2024-02-29 00:00:00 |  | False | False | 63395 | 59705 | 1000 |  |  |  | False
 |  |  |  | 15851 |  | 2024-02-29 00:00:00 |  | False | False | 61945 | 58355 | 1000 |  |  |  | False
Spreadsheet: lindy_donoho__21970__TW2010ProjCap&Rev
Sheet: TW Capacity & Rev thru 2010

 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
SUBSCRIBED
WEST
System Capacity | 1160000 | 1210000 | 1210000 | 1210000 | 1210000 | 1210000 | 1210000 | 1210000 | 1210000
Subscribed Volume | 1126842 | 1083283 | 999783 | 846533 | 477033 | 262658 | 184117 | 101033 | 98700
Average Rate
Revenue | 120550803 | 124112524 | 120044973 | 104371463 | 52847205 | 27357003 | 18651674 | 13343910 | 13216230
EAST
System Capacity | 688827 | 688827 | 688827 | 688827 | 688827 | 688827 | 688827 | 688827 | 688827
Subscribed Volume | 619809 | 220196 | 74363 | 72218 | 35500 | 667 | 0 | 0 | 0
Average Rate |  |  |  |  |  |  | 0 | 0 | 0
Revenue | 8066199 | 3764821 | 1853421 | 1802132 | 948480 | 12160 | 0 | 0 | 0
IGNACIO TO BLANCO
System Capacity
Subscribed Volume | 652000 | 555000 | 262917 | 252500 | 63542 | 55000 | 0 | 0 | 0
Average Rate |  |  |  |  |  |  | 0 | 0 | 0
Revenue | 10777651 | 7563885 | 2580960 | 2352960 | 59280 | 0 | 0 | 0 | 0
SAN JUAN (BL TO TH)
System Capacity | 850000 | 850000 | 850000 | 850000 | 850000 | 850000 | 850000 | 850000 | 850000
Subscribed Volume | 841863 | 843929 | 807333 | 698000 | 433500 | 156000 | 93083 | 10000 | 10000
Average Rate
Revenue | 21688947 | 22489926 | 21748403 | 18943578 | 12409949 | 1745021 | 0 | 0 | 0
TOTAL SUBSCRIBED REVENUE
UNSUBSCRIBED (at Risk)
WEST
System Capacity | 1160000 | 1210000 | 1210000 | 1210000 | 1210000 | 1210000 | 1210000 | 1210000 | 1210000
ReSubscribed Volume | 33158 | 126717 | 210217 | 363467 | 732967 | 947342 | 1025883 | 1108967 | 1111300
Average Rate | 0.2565 | 0.2565 | 0.2565 | 0.2565 | 0.2565 | 0.2565 | 0.2565 | 0.2565 | 0.2565
Revenue
EAST
System Capacity | 688827 | 688827 | 688827 | 688827 | 688827 | 688827 | 688827 | 688827 | 688827
ReSubscribed Volume | 69018 | 468631 | 614464 | 616609 | 653327 | 688160 | 688827 | 688827 | 688827
Average Rate | 0.0591 | 0.0591 | 0.0591 | 0.0591 | 0.0591 | 0.0591 | 0.0591 | 0.0591 | 0.0591
Revenue
IGNACIO TO BLANCO
System Capacity | 681000 | 681000 | 681000 | 681000 | 681000 | 681000 | 681000 | 681000 | 681000
ReSubscribed Volume | 29000 | 126000 | 418083 | 428500 | 617458 | 626000 | 681000 | 681000 | 681000
Average Rate | 0.0428 | 0.0428 | 0.0428 | 0.0428 | 0.0428 | 0.0428 | 0.0428 | 0.0428 | 0.0428
Revenue
SAN JUAN (BL TO TH)
System Capacity | 850000 | 850000 | 850000 | 850000 | 850000 | 850000 | 850000 | 850000 | 850000
ReSubscribed Volume | 8137 | 6071 | 42667 | 152000 | 416500 | 694000 | 756917 | 840000 | 840000
Average Rate | 0.1043 | 0.1043 | 0.1043 | 0.1043 | 0.1043 | 0.1043 | 0.1043 | 0.1043 | 0.1043
Revenue
TOTAL UNSUBSCRIBED REVENUE
TOTAL REVENUE
Spreadsheet: 771316d1646607316-receivable-balance-list-of-companies-with-duplicate-total-sums-greater-than-2500-307
Sheet: Sheet1

Company | Receivable balance
G | 2500 |  | Company | Receivable balance |  |  | A
Q | 1500 |  | A | 6000 |  |  | B
T | 1000 |  | B | 5950 |  |  | C
I | 2000 |  | C | 4080 |  |  | D
B | 5950 |  | D | 3000 |  |  | E
D | 2000 |  | E | 3000 |  |  | F
D | 1000 |  | F | 2600 |  |  | G
C | 4080 |  |  |  |  |  | H
J | 2000 |  | Receivable balance >2500 |  |  |  | I
K | 2000 |  |  |  |  |  | J
L | 2400 |  |  |  |  |  | K
S | 1336 |  |  |  |  |  | L
M | 2000 |  |  |  |  |  | M
E | 300 |  |  |  |  |  | N
E | 700 |  |  |  |  |  | O
E | 2000 |  |  |  |  |  | P
V | 700 |  |  |  |  |  | Q
O | 2000 |  |  |  |  |  | R
U | 900 |  |  |  |  |  | S
N | 2000 |  |  |  |  |  | T
A | 6000 |  |  |  |  |  | U
R | 1730 |  |  |  |  |  | V
P | 2000
H | 2500
F | 1600
F | 1000
Spreadsheet: 148855d1333578576-cross-checking-and-filtering-help
Sheet: Numbers

537790 | 5 | 4
8743030 | 1 | 1
8748189 | 3 | 0
8748196 | 1 | 1
8748301 | 1 | 1
8748385 | 1 | 1
8748539 | 1 | 1
8748798 | 1 | 1
8752417 | 4 | 0
8752634 | 1 | 2
8754909 | 1 | 2
8756932 | 2 | 1
8758311 | 1 | 0
8758661 | 1 | 1
8759571 | 2 | 2
8759746 | 2 | 3
8760292 | 2 | 2
8760299 | 1 | 1
8760397 | 1 | 1
8760691 | 1 | 1
8760726 | 1 | 1
8760929 | 2 | 1
8760978 | 5 | 7
8761013 | 1 | 1
8761125 | 1 | 1
8761356 | 1 | 0
8761664 | 1 | 1
8763239 | 1 | 2
8763386 | 1 | 1
8763505 | 1 | 1
8763596 | 1 | 0
8764058 | 1 | 1
8764100 | 1 | 0
8764660 | 1 | 1
8764891 | 3 | 2
8764968 | 3 | 3
8765318 | 1 | 1
8765661 | 2 | 2
8765731 | 1 | 1
8766060 | 1 | 2
8766102 | 1 | 1
8766109 | 2 | 3
550029757 | 1 | 1
550037889 | 1 | 1
550057045 | 1 | 2
550057047 | 1 | 2
550066467 | 2 | 3
550068935 | 1 | 0
550080302 | 1 | 2
550154812 | 1 | 1
550325364 | 1 | 1
Spreadsheet: tom_donohoe__39953__First Mth Noms for Enron 2001single sheet
Sheet: 0501

 |  | Available Nominations for ENRON
FINAL!!!
 |  | 2001-05-01 00:00:00
#'S | Available Property | Pipeline | [NAME] # | MMBTU | 0.5
1 | East Breaks 110 | HIOS | 150408 | 7800
 | East Breaks 160 | HIOS | 33056 | 1088
 | East Breaks 165 | HIOS | 33055 | 1044
 | High Island 302 | HIOS | 161720 | 0
 | High Island 309 | HIOS | 161760 | 53
 | High Island 310 | HIOS | 161759 | 392
 | High Island 330 | HIOS | 161820 | 0
 | High Island 474/475 | HIOS | 161647 | 471
 | High Island 489 | HIOS | 161648 | 264
 | West Cameron 172E | ANR | 263952 | 1084
Attention: [NAME]
(713) 646-3390 fax
(713) 853-7164 phone
HIOS
1 | East Cameron 359 | STINGRAY | 905955 | 129
 | West Cameron 172D | STINGRAY | 36111 | 1094
 | West Cameron 180/144 | STINGRAY | 900483 | 913
Attention: Trish
(713) 646-8543 fax
(713) 853-4222 phone
Stingray
1 | Price Lake (LRC) | LRC | 848042-1 | 0
Attention: [NAME]
(713) 646-3239 fax
(713) 853-6796 phone
1 | Eugene Island 372 | TGP | 018043 | 0
 | Ship Shoal 111 | TGP | 012102 | 266
 | West Delta 54 | TGP | 010472 | 6600
4 | Price Lake (TGP) | TGP | 12540 | 11000
Attention: [NAME] or [NAME]
(713) 646-2626 fax
(713) 853-4210 phone
Tennessee
1 | Ft. St. Phillips | [NAME] | 012685 | 0
Attention: [NAME]
(713) 646-8453 fax
(713) 345-7791 phone
[NAME]
1 | South Timbalier 185 | TRUNKLINE | 81709 | 0
 |  |  | Total Nominations of all fields:
Attention: Nelson Ferries |  |  |  |  | PANACO'S NOMINATIONS
[EMAIL] |  |  |  |  | PHONE: (713) 970-3133
(713) 646-3239 fax |  |  |  |  | FAX: (713) 970-3151
(713) 853-3061 phone |  |  |  |  | Lesley Strange
 |  |  |  |  | Volume Control Analyst
Attention:  [NAME]
[EMAIL]
Attention:  [NAME]
[EMAIL]
Spreadsheet: 689545d1596498626-forecast-high-low-book1
Sheet: Participants

 | Golden State 5k
 | Location | Los Angeles | 20000
 | Year | Participants | Donations |  | Intercept | Slope | RSQ | Standard Error
 | 2005 | 3000 | 10000
 | 2006 | 3750 | 14500
 | 2007 | 4000 | 17000 |  | Forecast | High | Low
 | 2008 | 4500 | 20000
 | 2009 | 5000 | 22500
 | 2010 | 7500 | 30000
 | 2011 | 8750 | 45000
 | 2012 | 9000 | 50100
 | 2013 | 9000 | 56000
 | 2014 | 9200 | 58250
 | 2015 | 10000 | 60125
 | 2016 | 10250 | 62500
 | 2017 | 11750 | 64000
 | 2018 | 12250 | 70000
 | 2019 | 12500 | 75000
 | 2020 | 15000 | 85500
Spreadsheet: 01578909-c0f3-467f-b7b6-ef2fe6fabe75
Sheet: Sheet1

Unnamed: 0 | Net Current Expenditures Per Pupil in Fall Enrollment | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Charter [NAME], FYs 2000-2004
 |  | Current Expenditures Per Pupil |  |  |  |  |  |  | Fall Enrollment
 |  |  |  |  |  |  | 2003-2004 |  | FY 2004 | 2003-2004
 | Charters | 2000 | 2001 | 2002 | 2003 | 2004 | Change |  | Total | Change
68 | Ogden Preparatory Academy | 0 | 0 | 0 | 0 | 3959 | 0 |  | 213 | 0
69 | Dream Foundation | 0 | 0 | 0 | 0 | 4772 | 0 |  | 31 | 0
74 | American Preparatory Academy | 0 | 0 | 0 | 0 | 3914 | 0 |  | 460 | 0
81 | Discovery Charter School | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
82 | Freedom Academy | 0 | 0 | 0 | 0 | 3427 | 0 |  | 332 | 0
83 | Ames | 0 | 0 | 0 | 0 | 4528 | 0 |  | 260 | 0
84 | CBA Center | 8517 | 6443 | 6978 | 5919 | 6091 | 0.029 |  | 39 | 0.026
85 | Jean Massieu School | 8898 | 12160 | 12744 | 13142 | 11349 | -0.136 |  | 36 | 0.2
86 | Pinnacle Canyon Academy | 3750 | 3205 | 5197 | 6490 | 5226 | -0.195 |  | 320 | 0.255
87 | Center City School |  | 8789 | 7861 | 6506 | 5751 | -0.116 |  | 163 | 0.132
88 | Success School | 5876 | 5091 | 6560 | 5276 | 6132 | 0.162 |  | 68 | 0.133
89 | Solider Hollow1 | 4822 | 4979 | 5512 | 6359 | 4155 | -0.347 |  | 66 | 1.357
90 | Tuacahn HS for Performing Arts | 4521 | 5843 | 5319 | 3694 | 4451 | 0.205 |  | 171 | 0.089
92 | Uintah River Alternative HS | 4298 | 9587 | 7561 | 6067 | 8362 | 0.378 |  | 44 | -0.214
93 | [NAME] | 0 | 0 | 0 | 3870 | 4333 | 0.12 |  | 184 | 0.15
94 | [NAME] | 0 | 0 | 0 | 2732 | 4399 | 0.61 |  | 272 | 0
95 | Timpanogos Academy | 0 | 0 | 0 | 3197 | 2828 | -0.115 |  | 374 | 0.072
96 | Park City Learning Center | 0 | 0 | 6208 | 7184 | 5889 | -0.18 |  | 48 | 0.371
97 | Salt Lake Arts Academy | 0 | 0 | 0 | 0 | 5328 | 0 |  | 117 | 0
98 | Fast Forward Charter HS | 0 | 0 | 0 | 0 | 5942 | 0 |  | 55 | 0
A2 | The Ranches Academy, Inc. | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
A3 | Riverside Technology HS | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
A5 | Itineris Early College HS | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
 | Charters2 | 4838.91240875912 | 5712 | 6385 | 5078 | 4597 | -0.095 |  | 3253 | 1.479
 | STATE2: | 4169.86098026363 | 4477 | 4706 | 4651 | 4762 | 0.024 |  | 486938 | 0.012
 | U.S.: | 6811 | 7156 | 7524 | 7777 | 7826 | ------ |  |  | ------
 | Sources: USOE, Finance and Statistics and the U.S. Dept. of [NAME]., National Center for Education Statistics.
 | Current Expenditures as defined by the National Center for Education Statistics:
 | Included: Instruction and support services (salaries, benefits, supplies, purchased services, and other) expenditures.
 | Excluded: Property, equipment, community services, and debt service expenditures.
 | Deducted: Title I and Title VI expenditures, food service, tuition, transportation, textbook, summer school,
 | and student activities revenues.
 | 1Sundance Mountain Charter School changed their name to [NAME].
 | 2The FY2003 does not include Thomas Edison Charter School.
Spreadsheet: sally_beck__36212__Weekly Operating Report 5-30
Sheet: WE 2-22 EOL Data

EOL
 | Week ending 2/22 |  | Volumetric
New Deals for: | New Deals | Volume | Units
EA
Gas | 10211 | 1100132468 | MMBTU
Power | 1796 | 15451320 | MHtz
EGM
Liquids | 1548 | 40624000 | BBL
Coal | 1 | 37500 | TONNE
Coal International | 3 | 135000 | TONNE
Weather | 1 | 300 | HDD/CDD
IR/FX | 0 | 0 | USD
Emissions | 0 | 0 | CONTRACTS
EIM
Pulp & Paper | 0 | 0 | TONNE
Steel | 0 | 0 | TONNE
Number of new EOL Counterparties | 6
Non-EOL
 |  |  | Volumetric
New Deals for: | New Deals | Volume | Units
EA
Gas | 2449 | 1765555183 | MMBTU
Power | 1860 | 22539170 | MHtz
EGM
Liquids | 1587 | 107025834 | BBL
Coal | 14 | 1613000 | TONNE
Coal International | 10 | 640000 | TONNE
Weather | 23 | 377500 | HDD/CDD
IR/FX | 142 | 5786000 | USD
Emissions | 6 | 37500 | CONTRACTS
EIM
Pulp & Paper | 72 | 56436 | TONNE
Steel | 0 | 0 | TONNE
Clickpaper
 |  |  | Volumetric
New Deals for: | New Deals | Volume | Units
EIM
Lumber | 4 | 176000 | Board Feet
Newsprint
Pulp (recycled paper) |  |  | [NAME]
Number of new CP Counterparties | 1
Lumber Converted
EIM TOTAL
Spreadsheet: phillip_m_love__30694__July_Sithe_Capacity Hedges
Sheet: Results

 |  |  |  |  |  |  |  |  | Totals
 |  | Phy/ |  |  | Monthly | PV | Discount | Mid | Fixed |  | Mid
Counterparty | Deal Num | Fin | Pub Code | Period | Quantity | Quantity | Factor | Price | Price | Cash | Value
FT-CENTRAL | EQ3897.C | F | ANNUITY | 01-JUL-2000 | 0 | 0 | 1 | 4.369000000000001 | 0 | 17500 | 0
Spreadsheet: 862476d1710195032-exclude-holidays-in-total-holiday-sample
Sheet: Jan

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday Count | Weekdays Count | Weekend Count | Entitlement | Total Taken | Balance
 |  |  |  | 2017-01-02 00:00:00 | 2017-01-03 00:00:00 | 2017-01-04 00:00:00 | 2017-01-05 00:00:00 | 2017-01-06 00:00:00 | 2017-01-07 00:00:00 | 2017-01-08 00:00:00 | 2017-01-09 00:00:00 | 2017-01-10 00:00:00 | 2017-01-11 00:00:00 | 2017-01-12 00:00:00 | 2017-01-13 00:00:00 | 2017-01-14 00:00:00 | 2017-01-15 00:00:00 | 2017-01-16 00:00:00 | 2017-01-17 00:00:00 | 2017-01-18 00:00:00 | 2017-01-19 00:00:00 | 2017-01-20 00:00:00 | 2017-01-21 00:00:00 | 2017-01-22 00:00:00 | 2017-01-23 00:00:00 | 2017-01-24 00:00:00 | 2017-01-25 00:00:00 | 2017-01-26 00:00:00 | 2017-01-27 00:00:00 | 2017-01-28 00:00:00 | 2017-01-29 00:00:00 | 2017-01-30 00:00:00 | 2017-01-31 00:00:00 |  |  |  |  |  | 10
 |  |  |  | 2017-01-02 00:00:00 | 2017-01-03 00:00:00 | 2017-01-04 00:00:00 | 2017-01-05 00:00:00 | 2017-01-06 00:00:00 | 2017-01-07 00:00:00 | 2017-01-08 00:00:00 | 2017-01-09 00:00:00 | 2017-01-10 00:00:00 | 2017-01-11 00:00:00 | 2017-01-12 00:00:00 | 2017-01-13 00:00:00 | 2017-01-14 00:00:00 | 2017-01-15 00:00:00 | 2017-01-16 00:00:00 | 2017-01-17 00:00:00 | 2017-01-18 00:00:00 | 2017-01-19 00:00:00 | 2017-01-20 00:00:00 | 2017-01-21 00:00:00 | 2017-01-22 00:00:00 | 2017-01-23 00:00:00 | 2017-01-24 00:00:00 | 2017-01-25 00:00:00 | 2017-01-26 00:00:00 | 2017-01-27 00:00:00 | 2017-01-28 00:00:00 | 2017-01-29 00:00:00 | 2017-01-30 00:00:00 | 2017-01-31 00:00:00
 |  | 2017-01-01 00:00:00 | 1 | 1 | 1 |  |  |  | 1 | 1 |  |  | 1 | 0.5 |  |  |  |  |  |  |  |  | 1 | 1
Spreadsheet: 488564d1478715381-advanced-filter-three-conditions-does-not-contain-between-and-contain-advance-filter-not-parameter-and-type
Sheet: Sheet1

CITY | VENUE | ROOM 1 CAPACITY | ROOM 1 CAPACITY 2 | ROOM 1 CAPACITY 3 | [NAME] | SECONDARY EMAIL | TYPE |  | QUERY
 |  |  |  |  |  |  |  |  | Show venues that meet all three criteria
CITY | VENUE | ROOM 1 CAPACITY | ROOM 1 CAPACITY 2 | ROOM 1 CAPACITY 3 | [NAME] | SECONDARY EMAIL | TYPE |  | Criteria 1
Arbroath | Webster Theatre | 550 | 120 |  | AR@WT | TH@WT | O |  | SHOW VENUES THAT ARE NOT IN THE FOLLOWING CITIES: ARBROATH, DERBY, NEWPORT
[NAME] | Market Place Theatre | 397 |  |  | AR@MPT | GH@MPT | T
Clacton-On-Sea | West Cliff Theatre | 600 |  |  | CL@WCT | EA@WCT
Coventry | Belgrade Theatre | 850 |  | 250 | CO@BT | RY@BT | O
Cromer | Pavilion | 510 |  |  | CR@P | ER@P | T
Derby | Conkers Amphitheatre | 700 |  |  | DE@CA | BY@CA
DORKING | Dorking Hall | 790 |  | 176 | DO@DH | NG@DH
Gravesend | Woodville | 700 |  |  | GR@W | ND@W |  |  | [NAME]
Loughborough | Loughborough Town Hall | 550 | 120 |  | LO@LTH | GH@LTH | O |  | Only show venues with capacities in either of the three rooms that are between 100 and 200 but include blanks
Musselburgh | Brunton Theatre | 550 | 120 | 300 | MU@BT | GH@BT | T
Newport | Medina Theatre | 400 |  |  | NE@MT | RT@MT
Penistone | Paramount | 350 |  |  | PE@P | NE@P | T
PORT SUNLIGHT | Gladstone Theatre | 430 |  |  | PO@GT | HT@GT | T
Radlett | [NAME] | 300 |  |  | RA@RC | TT@RC | 0
Rotherham | [NAME] | 356 |  |  | RO@RCT | AM@RCT
Swindon | Wyvern Theatre | 635 | 635 |  | SW@WT | ON@WT | O |  | Criteria 3
Yeovil | Octagon Theatre | 622 |  |  | YE@OT | IL@OT | O |  | Only show venues that have type T or blank
Bury St Edmunds | The Apex | 650 | 516 |  | BU@TA | DS@TA | T
Cockermouth | The Kirkgate | 125 |  |  | CO@TK | TH@TK | 0
Aberdare | Coliseum Theatre | 300 | 376 |  | AB@CT | RE@CT | T
Aberdeen | The Lemon Tree | 550 |  |  | AB@TLT | EN@TLT |  |  | result should be
Aberdeen | Tunnels | 300 |  |  | AB@T | EN@T | T |  | Brunton Theatre
Aberdeen | Krakatoa | 200 |  |  | AB@K | EN@K | O
Aberdeen | Music Hall | 1000 | 1300 |  | AB@MH | EN@MH
Spreadsheet: 219030d1362650453-how-to-delete-the-text-total-in-each-sumerizing-category-sample
Sheet: escalc_a05_liquors

Name | Type | Production | Stock
 | Grand Total |  | 18297
 | [NAME] |  | 4833
[NAME] | [NAME] | France | 665
Conjure Cognac | [NAME] | France | 583
Courvoisier [NAME] | [NAME] | France | 451
Germain-Robin Select Barrel XO | [NAME] | American | 773
Hennessy X.O. | [NAME] | France | 783
[NAME] | [NAME] | France | 687
R¨?my [NAME] | [NAME] | France | 756
[NAME] | [NAME] | France | 135
 | Cordials Total |  | 1365
Baileys Irish Cream | Cordials | Ireland | 434
Canterbury Cream | Cordials | New Zealand | 479
Drambuie | Cordials | Scotland | 84
Grand Marnier [NAME] | Cordials | France | 118
Jagermeister | Cordials | Germany | 30
Kahlua | Cordials | Mexico | 220
 | Gin Total |  | 2048
Bombay Sapphire | Gin | England | 608
[NAME] | Gin | England | 278
Gordons | Gin | England | 287
Seagers | Gin | England | 700
Tanqueray | Gin | Scotland | 175
 | [NAME] |  | 2340
Appleton Estate Reserve | [NAME] | Jamaica | 202
Bacardi Superior | [NAME] | Puerto Rico | 741
Black Heart Rum | [NAME] | New Zealand | 338
Captain [NAME] 100 Proof | [NAME] | Jamaica | 585
Coruba Royal | [NAME] | Jamaica | 30
Malibu Coconut | [NAME] | England | 306
Mount Gay Eclipse | [NAME] | Barbados | 138
 | Whisky Total |  | 7711
Ballantines Special 12 Year | Whisky | Scotland | 237
Canadian Club [NAME] | Whisky | Canada | 272
Chivas Regal 25-Year-Old | Whisky | Scotland | 43
[NAME] | Whisky | Australia | 277
Dewar's | Whisky | Scotland | 215
[NAME] Daniel??s Tennessee Whiskey | Whisky | American | 755
Jamesons Irish Whiskey | Whisky | Ireland | 164
[NAME] | Whisky | American | 669
Jim Beam Small Batch | Whisky | American | 634
[NAME] | Whisky | Scotland | 799
[NAME] Label | Whisky | Scotland | 586
[NAME] | Whisky | American | 760
Teachers | Whisky | Scotland | 143
The Famous Grouse | Whisky | Scotland | 473
The Glenlivet 12-Year-Old | Whisky | Scotland | 552
[NAME] | Whisky | Scotland | 788
Woodstock | Whisky | Australia | 344
Spreadsheet: 60483d1261004031-time-formula-online-time-formula
Sheet: Sheet1

Color 1 | Color 2 | Description | Quantity to be Produced | start time | stop time
Black | Black | Product A | 8 | 05:00:00 | 07:10:00
Black | Blue | Product B | 12 | 07:10:00 | 10:20:00
Black | Blue | Product C | 20 | 10:20:00 | 15:20:00
Blue | Blue | Product D | 28 | 15:20:00 | 17:00:00
Blue | Blue | Finish Product D | 22 | 05:00:00 | 10:40:00
Black | Blue | Product E | 4 | 10:40:00 | 11:50:00
Black | Blue | Product F | 16 | 11:50:00 | 15:50:00
Black | Green | Product G | 4 | 15:50:00 | 17:00:00
Black | Green | Product H | 8 | 5:00AM | 07:10:00
Spreadsheet: benjamin_rogers__1065__Peaker Valuation 071700
Sheet: Caledonia

INCOME STATEMENT - CALEDONIA
('000 $) | 2000-01-01 00:00:00 | 2000-12-31 00:00:00 | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 |  | Check
Capacity Prices ($/kW-mo)
Capacity Revenue from Desk (Real $)
Capacity Revenue from Desk (Nominal $)
Expense
Mobilization
Fixed Operation & Maintenance
Variable Operation & Maintenance
Major Maintenance & Ongoing Capex
O&M Management Fee
Owner's Expense
Property Taxes
Total Expense
EBITDA
Salvage Value |  | 0 | 0
Without Salvage Value
Net Equity Cashflow | 0
Weighted Average Cost of Capital
Enterprise Value
With Salvage Value
Net Equity Cashflow | 0
Weighted Average Cost of Capital
Enterprise Value
Spreadsheet: 02d0aba9-4e63-4a58-8fe0-010bf1615e85
Sheet: SciFinderScholar

SciFinder Scholar
2006-2007
 | 2006-07-01 00:00:00 | 2006-08-01 00:00:00 | 2006-09-01 00:00:00 | 2006-10-01 00:00:00 | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | Total | 2006-2007 Price | Price per search
Sessions | 242 | 190 | 241 | 203 | 185 | 147 | 186 | 203 | 229 | 194 | 181 | 240
Searches | 1029 | 771 | 783 | 671 | 917 | 488 | 586 | 898 | 764 | 732 | 753 | 798 |  | 29485
Turnaways | 257 | 124 | 105 | 56 | 123 | 52 | 50 | 148 | 77 | 124 | 122 | 126
Simultaneous users | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
COUNTER-Compliant?: | No