tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: john_griffith__15945__11_15_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG Z1 | 255 | 27.5 | 29.5 | 74.7 | 80.1 | 12.41 | 2001-11-15 12:00:00
 | NG F2 | 280 | 56.5 | 58.5 | 76 | 78.7 | 13.62 | 2001-11-15 12:00:00
 | NG G2 | 280 | 72 | 74.5 | 72.5 | 75 | 12.98 | 2001-11-15 12:00:00
 | NG H2 | 280 | 73 | 76 | 62.8 | 65.4 | 11.28 | 2001-11-15 12:00:00
 | NG J2 | 285 | 71 | 73.5 | 53.3 | 55.2 | 9.72 | 2001-11-15 12:00:00
 | NG K2 | 290 | 74 | 77 | 49.2 | 51.2 | 9.15 | 2001-11-15 12:00:00
 | NG M2 | 290 | 80 | 83 | 48.8 | 50.6 | 9.06 | 2001-11-15 12:00:00
 | NG N2 | 295 | 87 | 91 | 48.9 | 51.2 | 9.28 | 2001-11-15 12:00:00
 | NG Q2 | 300 | 94 | 98 | 48.9 | 51 | 9.42 | 2001-11-15 12:00:00
 | NG U2 | 305 | 100 | 105 | 48.5 | 51 | 9.54 | 2001-11-15 12:00:00
 | NG V2 | 305 | 104 | 110 | 48.2 | 51.1 | 9.52 | 2001-11-15 12:00:00
 | NG X2 | 325 | 117 | 121 | 48.7 | 50.4 | 10.12 | 2001-11-15 12:00:00
 | [NAME] | 345 | 127 | 134 | 48.2 | 50.9 | 10.75 | 2001-11-15 12:00:00
 | NG H3 |  |  |  |  |  |  | 2001-11-12 14:47:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 211928d1359992347-pull-data-based-on-day-of-week-from-another-workbook-for-previous-three-weeks-salesreport2013
Sheet: 0101

 | Date: | 2013-01-01 00:00:00
 | Day:
 | Time | Trans. | Total Sales | Avg. Sales
 | 09:00:00 | 1 | 20
 | 10:00:00 | 4 | 5.16
 | 11:00:00 | 33 | 349.17
 | 12:00:00 | 39 | 352.97
 | 13:00:00 | 53 | 416.98
 | 14:00:00 | 44 | 339.42
 | 15:00:00 | 43 | 304.96
 | 16:00:00 | 38 | 279.35
 | 17:00:00 | 57 | 540.75
 | 18:00:00 | 44 | 381.59
 | 19:00:00 | 22 | 142
 | 20:00:00 | 22 | 132.21
 | 21:00:00 | 15 | 85.27
 | 22:00:00 | 18 | 128.32
 | 23:00:00 | 11 | 79.26
 | 1900-01-01 00:00:00 | 14 | 69.27
 | 1900-01-01 01:00:00 | 2 | 9.05
 | 1900-01-01 02:00:00 | 3 | 18.69
 | 1900-01-01 03:00:00 | 0 | 0
 | 04:00:00 | 0 | 0
 | Total
Spreadsheet: 768885d1645188464-beginner-trying-to-compare-cells-in-two-columns-and-copy-a-third-column-if-it-is-a-match-order-test-aligw
Sheet: NE Trade

Release Date (Last 3 Months) | Module | Order | Product Code | Product Code | Barcode | Description | RSL | Qty in Pack | TPI | EUD | SKR | SKD | NKR | NKD | DKR | DKD | Commodity Code | Country of Origin | Weight (kg) | Cube (cm3) | 21-25 | Base Paint: Abaddon Black | IF this Matches D | Then [NAME] this to C
- |  |  | 01-05 | [PHONE] | [PHONE] | [NAME] | 0 | 1 | 40 | 22 | 360 | 190 | 330 | 173 | 300 | 156 | 95030095 | GB | 0.194 | 1522 | 66-27 | Citadel Colour Sub-assembly Holder | 62-02 | 1
2022-01-15 00:00:00 | E:B200a |  | 01-07 | [PHONE] | [PHONE] | ADEPTUS CUSTODES: CUSTODIAN GUARD | 1 | 1 | 45 | 24.75 | 420 | 221 | 390 | 202 | 350 | 182 | 95030095 | GB | 0.158 | 1384 | 66-09 | Citadel Painting Handle (Mark 2) | 66-16 | 3
2022-01-15 00:00:00 | E:B200a |  | 01-08 | [PHONE] | [PHONE] | ADEPTUS CUSTODES: SISTERS OF SILENCE | 1 | 1 | 38 | 20.9 | 360 | 198 | 325 | 179 | 300 | 156 | 95030095 | GB | 0.1183 | 1046 | 64-60 | Conservators - Battlezone Manufactorum | 66-27 | 3
- |  |  | 01-10 | [PHONE] | [PHONE] | CAPTAIN-GENERAL TRAJANN VALORIS | 0 | 1 | 32.5 | 17.88 | 300 | 165 | 275 | 151 | 250 | 130 | 95030095 | GB | 0.07699999999999999 | 700 | 29-37 | Contrast Paint: Basilicanum Grey | 66-09 | 3
- |  |  | 66-27 | [PHONE] | [PHONE] | ADEPTUS CUSTODES CUSTODIAN WARDENS | 0 | 1 | 45 | 24.75 | 420 | 221 | 390 | 202 | 350 | 182 | 95030095 | GB | 0.191 | 1248 | 29-13 | Contrast Paint: Flesh Tearers Red | 64-60 | 2
- |  |  | 64-60 | [PHONE] | [PHONE] | ADEPTUS CUSTODES VERTUS PRAETORS | 0 | 1 | 45 | 24.75 | 420 | 221 | 390 | 202 | 350 | 182 | 95030095 | GB | 0.276 | 1619 | 29-32 | Contrast Paint: Guilliman Flesh | 29-37 | 1
- | E:B200b |  | 01-12 | [PHONE] | [PHONE] | ADEPTUS CUSTODES ALLARUS CUSTODIANS | 1 | 1 | 40 | 22 | 360 | 190 | 330 | 173 | 300 | 156 | 95030095 | GB | 0.183 | 1242 | 29-10 | Contrast Paint: Iyanden Yellow | 29-13 | 1
2022-01-15 00:00:00 |  |  | 29-37 | [PHONE] | [PHONE] | CODEX: ADEPTUS CUSTODES (ENG) | 0 | 1 | 37.5 | 22.5 | 360 | 216 | 330 | 198 | 300 | 180 | 49019900 | CN | 0.657 | 825 | 29-21 | Contrast Paint: Nazdreg Yellow | 29-32 | 1
2022-01-15 00:00:00 |  |  | 01-14 | [PHONE] | [PHONE] | DATACARDS: ADEPTUS CUSTODES (ENG) | 0 | 1 | 20 | 11 | 180 | 99 | 170 | 94 | 150 | 78 | 49119100 | CN | 0.1324 | 211 | 29-22 | Contrast Paint: Ork Flesh | 29-10 | 2
- |  |  | 01-15
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Spreadsheet: 739979d1626109141-returning-a-value-to-a-summary-page-from-multiple-sheets-excel-tracker
Sheet: 1

Date | 1 Point Value | Outlay (£) | Outlay (Points)
2021-07-01 00:00:00 | 20 | 0
2021-07-02 00:00:00 | 20 | 0
2021-07-03 00:00:00 | 20 | 0
2021-07-04 00:00:00 | 20 | 0
2021-07-05 00:00:00 | 20 | 0
2021-07-06 00:00:00 | 20 | 0
2021-07-07 00:00:00 | 20 | 0
2021-07-08 00:00:00 | 20 | 0
2021-07-09 00:00:00 | 20 | 0
2021-07-10 00:00:00 | 20 | 0
2021-07-11 00:00:00 | 20 | 180
2021-07-12 00:00:00 | 20 | 180
2021-07-13 00:00:00 | 20 | 0
2021-07-14 00:00:00 | 20 | 0
2021-07-15 00:00:00 | 20 | 0
2021-07-16 00:00:00 | 20 | 0
2021-07-17 00:00:00 | 20 | 0
2021-07-18 00:00:00 | 20 | 0
2021-07-19 00:00:00 | 20 | 0
2021-07-20 00:00:00 | 20 | 0
2021-07-21 00:00:00 | 20 | 0
2021-07-22 00:00:00 | 20 | 0
2021-07-23 00:00:00 | 20 | 0
2021-07-24 00:00:00 | 20 | 0
2021-07-25 00:00:00 | 20 | 0
2021-07-26 00:00:00 | 20 | 0
2021-07-27 00:00:00 | 20 | 0
2021-07-28 00:00:00 | 20 | 0
2021-07-29 00:00:00 | 20 | 0
2021-07-30 00:00:00 | 20 | 0
2021-07-31 00:00:00 | 20 | 0
July | 20
Spreadsheet: 558666d1517257060-attendance-tracker-ref-errors-attendance-tracker-workbook
Sheet: Employee Leave Tracker

 | Employee [NAME]
 | Employee Name | Start Date | End Date | Type of Leave | Days
 | Employee 1 |  |  | [NAME]
 | Employee 2 |  |  | Other
 | Employee 3 |  |  | Other
 | Employee 5 |  |  | Bereavement
 | Employee 4 |  |  | [NAME]
 | Employee 1 |  |  | Vacation
 | Employee 4 |  |  | [NAME]
 | Employee 4 |  |  | Other
 | Employee 4 |  |  | Other
 | Employee 2 |  |  | [NAME]
 | Employee 5 |  |  | [NAME]
 | Employee 2 |  |  | Bereavement
 | Employee 5 |  |  | Bereavement
 | Employee 3 |  |  | Vacation
 | Employee 3 |  |  | Bereavement
 | Employee 1 |  |  | Other
 | Employee 1 |  |  | Vacation
 | Employee 2 |  |  | Bereavement
 | Employee 5 |  |  | Vacation
 | Employee 1 |  |  | Bereavement
 | Employee 1 |  |  | [NAME]
 | Employee 2 |  |  | Vacation
 | Employee 5 |  |  | Vacation
Spreadsheet: 27e1dbf7-f1c1-411a-b889-7c91ea7ccb53
Sheet: 14b

Product1 | HY3 | IG | Other | TOTAL
Index Tranche
Asia | - | - | - | -
Europe | - | - | 53 | 53
North America | 5 | 45 | . | 50
Other | - | - | - | -
Index
Asia | - | - | 49 | 49
Europe | - | - | 2550 | 2550
North America | 1666 | 2688 | 62 | 4416
Other | - | - | 196 | 196
Other
Exotic | - | - | 2 | 2
Swaptions | - | - | 176 | 176
Total Return Swap | - | - | 2 | 2
TOTAL
Spreadsheet: 0897616f-20b2-4337-ba87-8ac46260c723
Sheet: WithPerformance

Combined Bidder Activity Summary Report - November 2014  (Projects bid opened from July 2013 to November 2014, as of 12/01/2014)
Bid Month-YR | Engineer's Estimate | [NAME] | Low Bid vs. EE | Avg. Number of Bidders | Number of Projects Bid Opened | No. of  Projects Under 10% of EE | No. of Projects in ±10% of EE | No. of Projects Over 10% of EE | No. of Projects Within 110% of EE | Percent of  Projects Within ±10% of EE
2013-07-13 00:00:00 | 101578652.05 | 102192668.35 |  | 4.857142857 | 14 | 7 | 3 | 4
Aug-13 | 67879300.28 | 61238911.23 |  | 6 | 20 | 9 | 8 | 3
Sept-13 | 204165819.49 | 173258066.06 |  | 6.8846 | 26 | 18 | 5 | 3
Oct-13 | 162182345.53 | 146432319.92 |  | 5.3103 | 29 | 10 | 16 | 3
Nov-13 | 165502932.37 | 144277480.63 |  | 7.467 | 15 | 8 | 6 | 1
2013-12-12 00:00:00 | 124415660.37 | 119060555.57 |  | 6.9231 | 13 | 4 | 6 | 3
Jan-14 | 140813434.82 | 137191609 |  | 7.571428571 | 28 | 13 | 9 | 6
2014-02-14 00:00:00 | 92385807 | 83500057 |  | 6.6 | 27 | 10 | 13 | 4
2014-03-14 00:00:00 | 210853414 | 184251324 |  | 6.4 | 56 | 29 | 23 | 4
2014-04-01 00:00:00 | 231265534 | 205255562 |  | 5.5 | 62 | 31 | 25 | 6
2014-05-01 00:00:00 | 140508630 | 134448039 |  | 4.8 | 57 | 31 | 18 | 8
2014-06-14 00:00:00 | 231614414 | 221901164 |  | 5 | 20 | 5 | 12 | 3
Jul 13 to Jun 14
2014-07-01 00:00:00 | 139737164 | 127414388 |  | 5.6 | 24 | 11 | 12 | 2
* Aug-14 | 122496999 | 124108545 |  | 5 | 22 | 8 | 11 | 3
* Sept-14 | 150902234 | 133140985 |  | 7.2 | 21 | 11 | 9 | 1
* Oct-14 | 448449163 | 409417161 |  | 5.4 | 60 | 25 | 30 | 5
2014-11-01 00:00:00 | 338111206 | 320689870 |  | 6.3 | 29 | 12 | 14 | 3
2014-12-01 00:00:00
2015-01-01 00:00:00
2015-02-01 00:00:00
2015-03-01 00:00:00
2015-04-01 00:00:00
2015-05-01 00:00:00
2015-06-01 00:00:00
Jul 14 - Jun 15
Total
Note: 1) "*", numbers may be different from that in the previous report due to bid rank change(s); 2) Rejected projects are not included in calculations.
Spreadsheet: 35016d1232483768-possibly-combining-counta-and-vlookup-lookup-mcdealy
Sheet: Sheet1

cat | dog | thing | pat | suzy | allen | chicken | lisa | gremlin
1 | 1 | 5 | 5 | 5 | 5 | 5 | 5 | 5
3 |  | 5 | 5 |  | 5 |  |  | 5
4 | 2 |  | 5 | 5 |  | 5 | 5 | 5
 |  | 5 |  |  |  | 5 |  | 5
2 | 2 |  |  |  | 5 |  | 5
3 | 2 | 5 | 5 | 5 |  |  | 5 | 5
5 |  | 5 | 5 | 5 | 5 | 5
 | 2 | 5 |  |  | 5 | 5 | 5 | 5
6 |  | 5 | 5 | 5 | 5 | 5
 |  |  |  | suzy
 |  |  |  | TRUE
 |  |  |  | FALSE
 |  |  |  | TRUE
 |  |  |  | FALSE
 |  |  |  | FALSE
 |  |  |  | TRUE
 |  |  |  | TRUE
 |  |  |  | FALSE
 |  |  |  | TRUE
Spreadsheet: 830963d1685310362-how-to-use-xlookup-with-a-max-date-criteria-sample-1-
Sheet: Sheet1

source Table |  |  |  |  |  | Result | Result
[NAME] | Value | Value Date |  |  | [NAME] | Value | Value Date
21185 | -1.27 | 2020-12-12 00:00:00 |  |  | 21185 | -1.27 | 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 | -0.25 | 2020-10-21 00:00:00 |  |  | 21219
21185 | -0.25 | 2020-09-30 00:00:00 |  |  | 24011
21219 | -1.1 | 2020-12-12 00:00:00 |  |  | 24015
21219 | -0.4 | 2020-08-29 00:00:00 |  |  | 24031
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: 880232d1727866896-conditional-formatting-formula-problem-rmparp-example-table-cf-365-aligw
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | My Formatting
Auto | Manual | Auto | Auto | Auto
Auto | Auto | Manual | Auto | Auto
Auto | Manual | Auto | Auto | Manual
Auto | Auto | Auto | Auto | Auto
Spreadsheet: 686000d1594307968-help-if-4-is-the-4th-character-replace-it-with-example_update
Sheet: Data

Code | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | 19th | 20th | 21st | 22nd
123456789123456178912
102510000600028060522
Spreadsheet: 709787d1608557747-sort-cell-in-same-row-sort-2-cell-in-row
Sheet: a

[NAME] | column2 |  |  | [NAME] | column2
xx | yy | sort by row, return value |  | xx | yy
yy | xx |  |  | xx | yy
xy | yx |  |  | xy | yx
yx | xy |  |  | xy | yx
qj | ab |  |  | ab | qj
ab | qj |  |  | ab | qj
Spreadsheet: 878563d1725657350-need-formulas-to-get-average-of-monthly-productivity-per-person-productivity-changes_v2
Sheet: Monthly Average

Months | Person 1 | Months | Person 2 | Months | Person 3
2024-09-01 00:00:00 |  | 2024-09-01 00:00:00 |  | 2024-09-01 00:00:00
2024-10-01 00:00:00 |  | 2024-10-01 00:00:00 |  | 2024-10-01 00:00:00
2024-11-01 00:00:00 |  | 2024-11-01 00:00:00 |  | 2024-11-01 00:00:00
2024-12-01 00:00:00 |  | 2024-12-01 00:00:00 |  | 2024-12-01 00:00:00
2025-01-01 00:00:00 |  | 2025-01-01 00:00:00 |  | 2025-01-01 00:00:00
2025-02-01 00:00:00 |  | 2025-02-01 00:00:00 |  | 2025-02-01 00:00:00
Spreadsheet: 89280d1289039639-excel-2007-creating-a-formula-for-lookup-example-1-_naifu
Sheet: Sheet3

Persons | Values
In Column A, I want a list of all the persons in sheets 1 and sheets 2 | In this column, I want to ADD the values from Value3 that the person has.
FOR EXAMPLE:
[NAME] |  | <- From sheet 1
Q. Pondexter |  | <- From sheet 1 and 2
[NAME]
[NAME]
[NAME]
[NAME]
P. Vanderbolt
[NAME]
[NAME]
[NAME]
[NAME]
E. House
[NAME]
[NAME]
[NAME]
T. Boon
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
L. Platter
T. Douglas
O. Pondexter
[NAME]
[NAME]
[NAME]
Spreadsheet: d8036ebd-eb77-4017-8dda-ec0364f18942
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
FFES | Test | FFES | [NAME], Serum (includes [NAME] and SHBG) | Free Estradiol | Mass Spectrometry | Plain, Red-Top or serum gel tube: Red |  |  | 3 | mL | Draw blood in a plain, red-top tube or serum gel tube. Spin down, pour off into plastic vial within 1 hour of collection, and send 3 mL serum frozen. | 1.5 mL | Specimens other than	Serum Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Free Estradiol, Percent Reference Ranges (%)       Age		Range Adult Males		1.7 - 5.4 Adult Females		1.6 - 3.6   Free Estradiol, [NAME] Reference Ranges (pg/mL)       Age		Range Adult Males		0.2 - 1.5 Adult Females		0.6 - 7.1   Sex Hormone Binding Globulin (SHBG), Serum Reference Ranges (nmol/L)       Age			Range  1 - 23m			60 - 252 Prepubertal (24m - 8y)		72 - 220 Pubertal   Males				16 - 100   Females			36 - 125 [NAME]			20 - 60 Adult Females    Premenopausal		40 - 120    Postmenopausal		28 - 112   [NAME], [NAME] Reference Ranges (pg/mL)          Age		Range Newborn		Levels are markedly elevated at birth and fall rapidly during the first week to prepubertal values of <15  Males <6m		Levels increase to 10 - 32 between 30 and 60 days, hen decline to prepubertal levels of <15 by six months. Females <1y		Levels increase to 5.0 - 50 between 30 and 60 days, then decline to prepubertal levels of <15 during the first year. Prepubertal		<15 [NAME]		8.0 - 35 Adult Females  Follicular		30 - 100  Luteal			70 - 300  Postmenopausal	<15      Test Performed By:   Esoterix Endocrinology                                         4301 Lost Hills Road                                         Calabasas Hills, CA 91301 | Varies | 7 - 10 days | 9 - 12 days |  | Profile |  |  |  |  | Esoterix Endocrinology
FFES | [NAME] | SERUM | Serum |  |  |  | Frozen | 180 days
FFES | Result | [NAME] | Free Estradiol, Percent | Free Estradiol, Percent | Alphanumeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 14960-9
FFES | Result | [NAME] | Free Estradiol, Serum | Free Estradiol, Serum | Alphanumeric |  |  |  |  | pg/mL |  |  |  |  |  |  |  |  |  | 2240-0
FFES | Result | Z0230 | [NAME] (SHBG) | [NAME] (SHBG) | Alphanumeric |  |  |  |  | nmol/L |  |  |  |  |  |  |  |  |  | 13967-5
FFES | Result | Z0259 | [NAME], Serum | [NAME], Serum | Alphanumeric |  |  |  |  | pg/mL |  |  |  |  |  |  |  |  |  | 35384-7
FFES | Billing Component | FFES |  | unlisted chemistry procedure |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 84999
FFES | Billing Component | FFES |  | Sex Hormone Binding Glob |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 84270
FFES | Billing Component | FFES |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 82670
Spreadsheet: phillip_m_love__30490__arnold pos 2001
Sheet: 06-05-01

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NYMEX Equivalent Gas Position |  |  |  |  | 7 |  |  | 600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POSITION   REPORT
TIME BUCKET/KEY: |  | 1 |  |  |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14
(Positions in Cont. [NAME].)     From: |  |  |  | July |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total ECT |  | Prior Day |  |  |  | CHECK LINKS
To: |  |  |  | Index |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Change |  | to HEDGESTRIPS
[NAME]
NYMEX Price
NYMEX NG-MM
NG PR CAN
NG-Long Term Exotic
NG LTX  Hedge-Basis Notional
NG LTX  Hedge-Basis Equivalent
Exotic Options
Exotic Options-Basis Notional
Exotic Options-Basis Equivalent
NG EOL Basis
NG EOL Basis Equivalent
NYMEX-Gas Daily
NG-GDL
TOTAL: |  |  |  | 0
Previous Day Change
Spreadsheet: 759754d1639703127-deduplication-and-sorting-problem-forumhelp_12-17
Sheet: Sheet1

Product classification | score |  |  |  | 1 | 2 | 3
A | 75 |  |  | A | 90 | 75 | 70
A | 75 |  |  | B | 95 | 90
A | 90 |  |  | C | 92 | 90
A | 90
A | 70
B | 90
B | 95
B | 95
C | 92
C | 90
Spreadsheet: 784723d1655921947-count-cells-with-text-timmer2005-it-needs-data-test
Sheet: Breakdown by Weeks

Select System | System 4
Site |  | 2021-11-29 00:00:00 | 2021-12-13 00:00:00
PBS-C
PBS-K
SO
Spreadsheet: darrell_schoolcraft__7860__shipsummary
Sheet: Sheet4

TRANSWESTERN  PIPELINE
Shipper imbalances
 | 2001-08-31 00:00:00 | 9/2001 | 9/2001 | 2001-09-30 00:00:00 | 2001-10-16 00:00:00 | 10/2001 | 10/2001
Shipper | Balance | activity | payments | Balance | activity | payments | Balance | comments
BP Energy Company |  |  |  | 362637.31 |  |  |  | has agreed to payback volumes of 125,856
Duke Energy Trading & Marketing |  |  |  |  |  |  |  | invoiced 8/31/01
Williams Energy Marketing |  |  | -46764.71 | 3821.28
Mirant Americas |  |  |  | 2803.88
Enserco Energy | 16048.18 |  |  |  |  |  |  | invoiced 8/31/01
USGT | 26251 |  |  | 26251.25 |  |  |  | invoiced 8/31/01 - they asked for index backup on 10/8/01
Phillips Petroleum | 7264 |  |  |  |  |  |  | has agreed to 960 mmbtus but wants to see pricing language in tariff
Red Cedar Gathering | 6732 |  |  |  |  |  |  | invoiced 8/31/01- vol equiv pymt in Oct 2001
Aurora Natural Gas | 2362.1 |  |  | 2362.1
PGE Electric | 3412 |  |  |  |  |  |  | invoiced 8/31/01
ENA |  |  |  | 4268.02
Utilicorp | 113
Astra Power | -5.54 |  |  | 246.38
Richardson Products | -180
EES |  |  |  | -1910.98
SMUD | -608 | -158
Tenaska Marketing Ventures | -3718
El Paso Energy Marketing | -8120
PGE Energy Trading
SoCal |  |  |  | -25290.62
Enserch Gas | -29760
Sempra Energy Trading |  |  |  | -92551.75
TXU Energy Trading | 0 | -346
Texaco Natural Gas, Inc |  |  |  |  |  | -134233 |  | invoiced 8/31/01- has agreed to pay
Arizona Public Service | 1610.08 |  | -1610
Dynegy Gas Transportation |  |  |  |  |  | -6531 |  | invoiced 8/31/01- verbal promise to pay on 10/5/01
Burlington Resources Trading |  |  | -125393
Reliant Energy Services |  |  | -73576
Spreadsheet: 835037d1688234913-the-datevalue-function-does-not-work-well-datevalue
Sheet: Sheet1

Date | DATEVALUE | DATE | ROUNDDOWN | FLOOR
2011-03-01 00:00:00
2011-04-01 00:00:00
2011-05-01 00:00:00
2011-06-01 00:00:00
2011-07-01 00:00:00
2011-10-01 00:00:00
2011-11-01 00:00:00
2011-12-01 00:00:00
13/01/2011
14/01/2011
17/01/2011
18/01/2011
19/01/2011
20/01/2011
21/01/2011
24/01/2011
25/01/2011
26/01/2011
27/01/2011
28/01/2011
31/01/2011
2011-01-02 00:00:00
2011-02-02 00:00:00
2011-03-02 00:00:00
2011-04-02 00:00:00
2011-07-02 00:00:00
2011-08-02 00:00:00
2011-09-02 00:00:00
2011-10-02 00:00:00
2011-11-02 00:00:00
14/02/2011
15/02/2011
16/02/2011
17/02/2011
18/02/2011
21/02/2011
22/02/2011
23/02/2011
24/02/2011
25/02/2011
28/02/2011
2011-01-03 00:00:00
2011-02-03 00:00:00
2011-03-03 00:00:00
2011-04-03 00:00:00
2011-07-03 00:00:00
2011-08-03 00:00:00
2011-09-03 00:00:00
2011-10-03 00:00:00
2011-11-03 00:00:00
14/03/2011
15/03/2011
16/03/2011
17/03/2011
18/03/2011
21/03/2011
22/03/2011
Spreadsheet: 818055d1676564011-how-concatenate-cells-in-range-based-on-value-in-other-cell-range-question-how-concatenate-cells-in-range-based-on-value-in-other-cell-range
Sheet: Sheet1

Item# | Article 1 | Article 2 |  |  | Article # | Items
Item 1 | x | x |  |  |  | Item1, Item 2, Item 3, Item 4 | ◄ The result from the formula should be like the two cells G2:G3 (which is now static text)
Item 2 | x |  |  |  |  | Item1, Item 5, Item7
Item 3 | x
Item 4 | x
Item 5 |  | x
Item 6
Item 7 |  | x
Spreadsheet: 194737d1353319279-counting-unique-text-instances-with-conditions-example2
Sheet: Sheet2

Date | Item | ID | Fee | Amount
2012-07-19 00:00:00 | Womans Weekly Dinner Party Cookbook | 251070289333 | [NAME] | 0.5
2012-08-19 00:00:00 | Womans Weekly Dinner Party Cookbook | 261070289444 | [NAME] | 0.5
2012-09-19 00:00:00 | Womans Weekly Dinner Party Cookbook | 382070289668 | [NAME] | 0.5
2012-09-20 00:00:00 | Womans Weekly Dinner Party Cookbook | 382070289668 | FVF | 0.5
2012-09-21 00:00:00 | Womans Weekly Dinner Party Cookbook | 261070289668 | [NAME] | 0.5
2012-11-21 00:00:00 | Womans Weekly Dinner Party Cookbook | 273000289888 | [NAME] | 0.5
Spreadsheet: 871624d1718047747-how-to-copy-paste-all-rows-and-columns-of-data-from-one-sheet-to-another-sheet-2024_commissions_dale-inc-commission-report
Sheet: Sheet11

DALE INC COMMISSION REPORT / DAVIS WINDOWS AND DOOR SALES / NOVEMBER / 2024
# | CHECK # | CHECK AMOUNT INCLUDING TAX | % PAID BY CUSTOMER | CUSTOMER | JOB NAME | PRODUCT SOLD | INVOICE / SALES ORDER / ESTIMATE # | SUB-TOTAL | COST | GROSS PROFIT $$$ | GROSS PROFIT % | COMMISION RATE | COMMISSION AMOUNT | ORDERED | RECEIVED
1 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
2 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
3 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
4 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
5 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
6 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
7 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
8 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
9 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
10 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
11 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
12 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
13 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
14 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
# | CHECK # | CHECK AMOUNT INCLUDING TAX | % PAID BY CUSTOMER | CUSTOMER | JOB NAME | PRODUCT SOLD | INVOICE / SALES ORDER / ESTIMATE # | SUB-TOTAL | COST | GROSS PROFIT $$$ | GROSS PROFIT % | COMMISION RATE | COMMISSION AMOUNT | ORDERED | RECEIVED