tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 189294d1351148817-editing-multiple-files-on-excel-2010-modified-file
Sheet: Sheet1

Some details about the project in this area
Sr. No. | Detail of work | Qty | Unit | rate | Amount
Heading 1
1 | Activity Details | 8 | [NAME] | 10
2 | Activity Details | 9 | [NAME] | 11
3 | Activity Details | 10 | [NAME] | 12
4 | Activity Details | 11 | [NAME] | 13
5 | Activity Details | 12 | Kg | 14
6 | Activity Details | 13 | Sft | 15
7 | Activity Details | 14 | [NAME] | 16
8 | Activity Details | 15 | sft | 17
 | Activity Details | 15 | sft | 20
9 | Activity Details | 16 | each | 18
10 | Activity Details | 17 | Each | 19
11 | Activity Details | 18 | Sft | 20
12 | Activity Details | 19 | Sft | 21
13 | Activity Details | 20 | cft | 22
14 | Activity Details | 21 | Each | 23
15 | Activity Details | 22 | Rft | 24
16 | Activity Details | 23 | each | 25
17 | Activity Details | 24 | Rft | 26
18 | Activity Details | 25 | Nos | 27
19 | Activity Details | 26 | Rft | 28
20 | Activity Details | 27 | Each | 29
Heading 2
21 | Activity Details | 29 | [NAME] | 31
22 | Activity Details | 30 | [NAME] | 32
23 | Activity Details | 31 | Sft | 33
24 | Activity Details | 32 | Sft | 34
Heading 3
25 | Activity Details | 33 | Each | 35
26 | Activity Details | 34 | [NAME] | 36
27 | Activity Details | 35 | sft | 37
28 | Activity Details | 36 | [NAME] | 38
29 | Activity Details | 37 | Kg | 39
Heading 4
30 | Activity Details | 38 | Rft | 40
31 | Activity Details | 39 | Rft | 41
32 | Activity Details | 40 | Each | 42
 | Grand Total
Spreadsheet: kimberly_watson__20555__imbalsumm0108
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 905097 | 935278
500232 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 | 859340 | 842565 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 | 1174590 | 1234138
500293 | 393088 | 546819
500302 |  | 10152
500303 | 236730 | 301114
500305 | 925899 | 1198302
500307 | 96406 | 104790
500313 |  | 2831
500314
500655 | 606960
500657 | 131964 | 148449
INDEX
2001-07-31 00:00:00 |  |  | -131785.95
2001-08-27 00:00:00
CBS Volume
 |  |  | -81746
Spreadsheet: 778336d1651005561-divide-a-number-into-multiples-of-6-without-decimals-or-remainder-testworksheet1
Sheet: Sheet1

 | 1 Delivery | 2 Deliveries
Color | 1st Delivery | 1st Delivery | 2nd Delivery | Percentage
Red |  |  |  | 0.0225
Blue |  |  |  | 0.015
Yellow |  |  |  | 0.015
Orange |  |  |  | 0.0225
Green |  |  |  | 0.0175
[NAME] |  |  |  | 0.0175
Purple |  |  |  | 0.0225
Magenta |  |  |  | 0.0175
Pink |  |  |  | 0.02
[NAME] |  |  |  | 0.0225
Black |  |  |  | 0.0375
White |  |  |  | 0.0175
Violet |  |  |  | 0.01
Biege |  |  |  | 0.0375
[NAME] |  |  |  | 0.0175
Gold |  |  |  | 0.04
Teal |  |  |  | 0.02
Ivory |  |  |  | 0.05
[NAME] |  |  |  | 0.035
Navy |  |  |  | 0.14
Grey |  |  |  | 0.0225
[NAME] |  |  |  | 0.02
Silver |  |  |  | 0.02
Dark Red |  |  |  | 0.02
[NAME] |  |  |  | 0.02
Dark yellow |  |  |  | 0.02
Rose |  |  |  | 0.02
[NAME] |  |  |  | 0.0225
Forest Green |  |  |  | 0.01
Pistachio |  |  |  | 0.0275
[NAME] |  |  |  | 0.025
Sea Green |  |  |  | 0.025
Light Gray |  |  |  | 0.025
Olive |  |  |  | 0.02
Maroon |  |  |  | 0.01
[NAME] |  |  |  | 0.01
Espresso |  |  |  | 0.01
Beet |  |  |  | 0.01
Clear |  |  |  | 0.0225
Frosted |  |  |  | 0.0175
Frosted Blue |  |  |  | 0.025
TOTALS
Intended Total Amount | 252
Calculated Total Amount
Spreadsheet: 857120d1706183389-how-to-look-up-a-result-if-two-criteria-are-met-example1-etaf
Sheet: Results

 |  |  |  |  |  |  | Results I'd like to see
Order number | Fabric | Country | Small | Medium | Large |  | CHAIR-IE-VINYL-S | CHAIR-IE-VINYL-M | CHAIR-IE-VINYL-L | CHAIR-UK-G-S | CHAIR-UK-B-L | CHAIR-US-B-M | CHAIR-US-B-L
102658 | Vinyl | Ireland | 35 | 65 | 6
105398 | Green | UK | 106
125694 | [NAME] | UK |  |  | 106
135984 | [NAME] | US |  | 106
158635 | Vinyl | Ireland | 40 | 50 | 16
178945 | [NAME] | US |  | 50 | 56
198675 | Green | UK | 106
 |  |  |  |  |  |  | 1035 | 1035 | 1035
 |  |  |  |  |  |  |  |  |  | 1293
 |  |  |  |  |  |  |  |  |  |  | 1299
 |  |  |  |  |  |  |  |  |  |  |  | 1350
 |  |  |  |  |  |  | 1398 | 1398 | 1398
 |  |  |  |  |  |  |  |  |  |  |  | 1436 | 1436
 |  |  |  |  |  |  |  |  |  | 1698
Spreadsheet: 0b405207-99c7-4a3a-bc47-07e0b78c73c5
Sheet: 18

Product* | October 11 | October 18 | October 25 | November 1 | November 8
Total**
Non-Deliverable Forwards | N/A | N/A | N/A | N/A | N/A
Options | N/A | N/A | N/A | N/A | N/A
Forwards | N/A | N/A | N/A | N/A | N/A
Swaps | N/A | N/A | N/A | N/A | N/A
OTHER | N/A | N/A | N/A | N/A | N/A
TOTAL
Gross notional amount outstanding, November 8 weekly snapshot, by product type, all participant types, tenors and currencies.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**These numbers are estimates.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 70706d1271414822-sumproduct-across-worksheets-cello-2-
Sheet: Sheet2

 |  |  |  |  |  | Term
 |  |  |  |  |  | inst
 |  |  |  |  |  | inst
 |  |  |  |  |  | inst
 |  |  |  |  |  | inst
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | idl
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | idl
 |  |  |  |  |  | idl
 |  |  |  |  |  | idl
 |  |  |  |  |  | idl
 |  |  |  |  |  | inst
 |  |  |  |  |  | idl
 |  |  |  |  |  | idl
 |  |  |  |  |  | idl
 |  |  |  |  |  | idl
 |  |  |  |  |  | inst
 |  |  |  |  |  | inst
 |  |  |  |  |  | inst
 |  |  |  |  |  | inst
 |  |  |  |  |  | inst
 |  |  |  |  |  | inst
 |  |  |  |  |  | inst
 |  |  |  |  |  | inst
 |  |  |  |  |  | inst
 |  |  |  |  |  | inst
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | idl
 |  |  |  |  |  | idl
Spreadsheet: 39824d1238089660-return-blank-cells-if-the-same-value-is-returned-4-times-jelp-med-formel
Sheet: Ark1

Anleggsinformasjon
[NAME] | Jakobsteinsvika, Leka kommune
Antall konsesjoner | 4 | stk
Maksimal tillatt biomasse |  | kilo
MOM kvalifikasjon
Fôrflåte | Akvamaster [NAME]
Notleverandør | Mørenot
6 | Polarcirkel 450, Ø120meter
Volum | 226,2 m³
6 | Polarcirkel 450, Ø160meter
volum | 402,2m³
Smoltleverandør | [NAME]
Antall ansatte | 5 personer
Oppstart | 2009-03-01 00:00:00
[NAME] | 1300000 |  | [NAME] for en utskriftsvennlig versjon med kun de
Utsett pr. [NAME] |  |  | viktgste [NAME]
Vektklasse på [NAME] uke 9 | 70 | gram
Vektklasse på motatt smolt uke 10 | 75 | gram
Vektklasse på motatt smolt uke 11 | 80 | gram
Gjennomsnittlig dødelighet | 0.0011
Gjennomsnittlig dødelighet ved utsett | 0.03
[NAME] fra anlegget
Datonummer (skjult)
Dato 1. dag i uken(skjult)
Måned
Ukenummer
[NAME] (C°)
 | HVIS(ELLER(B3={"tekst1";"tekst2"});"";B4+B5) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
[NAME] (utsett uke 9)
Antall
Individuell vekt (gr)
Biomasse (kg)
Dødelighet
SGR
Fôrtype
Fra fôrsilo (nr)
Utfôring (kg)
Antall dager fôring
Slakting
Arbeidsoppgaver | [NAME] her for oppgaver | [NAME] her for oppgaver | [NAME] her for oppgaver | [NAME] her for oppgaver | [NAME] her for oppgaver | [NAME] her for oppgaver |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MERKNAD
produksjonstid
[NAME] (utsett uke 9)
Antall
Individuell vekt
Biomasse
Dødelighet
SGR
Fôrfaktor
Fôrtype
Fra fôrsilo
Slakting
Arbeidsoppgaver | MERKNAD!
[NAME] (utsett uke 10)
Antall
Individuell vekt
Biomasse
Dødelighet
SGR
Fôrfaktor
Fôrtype
Fra fôrsilo
Slakting
Arbeidsoppgaver |  | MERKNAD!
[NAME] (utsett uke 10)
Antall
Individuell vekt
Biomasse
Dødelighet
SGR
Fôrfaktor
Fôrtype
Fra fôrsilo
Slakting
Arbeidsoppgaver |  | MERKNAD!
[NAME] (utsett uke 11)
Antall
Individuell vekt
Biomasse
Dødelighet
SGR
Fôrfaktor
Fôrtype
Fra fôrsilo
Slakting
Arbeidsoppgaver |  |  | MERKNAD!
[NAME] (utsett uke 11)
Antall
Individuell vekt
Biomasse
Dødelighet
SGR
Fôrfaktor
Fôrtype
Fra fôrsilo
Slakting
Arbeidsoppgaver |  |  | MERKNAD!
Forflåte informasjon
Silo 1 (kilogram) | 8000
Silo 2 (kilogram)
silo 3 (kilogram)
Silo 1 (kilogram)
Silo 2 (kilogram)
silo 3 (kilogram)
Arbeidsoppgaver for anlegget
 |  | slakteklar
Spreadsheet: 167247d1341933384-data-validation-dependent-on-other-validation-pipe-calculations
Sheet: Oil Viscocity

Shell Tellus 32
Temp (˚F) | Viscocity (cs)
-40 | 9854
-30 | 4967
-20 | 2672
-10 | 1523
0 | 913
10 | 573
20 | 374
30 | 254
40 | 177
50 | 128
60 | 94
70 | 71
80 | 55
90 | 43
100 | 35
110 | 28
120 | 23
130 | 20
140 | 17
150 | 14
160 | 12
170 | 11
180 | 9
190 | 8
200 | 7
Spreadsheet: 139546d1328291040-excel-2007-return-a-value-based-on-column-date-and-row-headers-names-incidentes
Sheet: SillyStats

 |  | Quantas vezes ocorre AGENTE + PROFESSOR
 |  | Ownership | End User | Soma | ∑ ocorrencias
Spreadsheet: 135149d1325846457-extracting-string-using-formula-extracting_string
Sheet: Sheet1

 |  | Is there a more sophisticated way of extracting the string in between the (-) dashes?  I tried using this formula =MID(B3,FIND("-",B3)+1,4) but since the [NAME] are not the same length it doesn’t quite work.  Result is below. |  | I also try this formula from my previous post =MID(B3,FIND("-",B3)+1,LEN(B3)-(FIND("-",B3)+1)) with the addition of this formula =LEFT(D3,FIND("-",D3)-1)  Result is in Column G  Seems to work but still not perfect.  Would appreciate your help to make this right.  Thanks.
 | [PHONE]-CYP2-20111120
 | [PHONE]-CJC152-20111024
 | [PHONE]-CJC171-20111024
 | [PHONE]-DSH171-20110630
 | [PHONE]-DYC131-20110922
 | [PHONE]-DWC175-20110723
 | [PHONE]-DZC523-
 | [PHONE]-CLC54-
 | [PHONE]-DXC397-20110918
 | [PHONE]-DYC222-20110918
 | [PHONE]-CJC196-
 | [PHONE]-CJAA138-20111019
Spreadsheet: 68512d1269030543-finding-the-sum-of-the-matches-between-two-ranges-counting
Sheet: Sheet1

# | Correct | S1 | S2 | S3 | [NAME] | S5 | S6
5 | E | E | E | E | D | E | E
4 | E | E | D | E | E | D | E
5 | E | E | E | E | D | E | E
5 | A | A | A | A | A | A | B
1 | B | A | C | B | A | A | A
5 | A | A | B | A | A | A | A
4 | A | B | A | A | A | B | A
4 | E | E | D | E | E | E | D
1 | B | A | C | A | A | A | B
3 | D | E | D | D | E | D | C
2 | B | A | B | A | C | A | B
2 | B | C | A | B | C | A | B
3 | D | C | D | D | E | E | D
3 | C | D | B | C | B | C | C
1 | C | D | D | D | C | B | B
5 | A | A | B | A | A | A | A
3 | E | E | E | D | D | E | D
2 | B | A | B | C | B | A | C
1 | C | B | D | D | C | B | D
4 | C | C | D | C | C | C | B
3 | E | E | D | D | E | D | E
4 | E | D | D | E | E | E | E
2 | B | B | C | A | A | C | B
0 | D | E | E | C | E | E | E
1 | D | D | C | C | C | C | E
2 | D | C | D | D | E | E | E
5 | A | A | A | A | A | B | A
3 | C | D | B | C | D | C | C
1 | D | C | C | D | E | C | C
Spreadsheet: 54770d1254832301-help-with-variable-ranges-pre-test-analysis
Sheet: report

Question No. | Difficulty Index | Discrimination Index | DIFFICULTY | INTERPRETATION
q1
q2
q3
q4
q5
q6
q7
q8
q9
q10
q11
q12
q13
q14
q15
q16
q17
q18
q19
q20
[NAME]
q22
q23
q24
q25
q26
q27
q28
q29
q30
q31
q32
q33
q34
q35
q36
q37
q38
q39
q40
Spreadsheet: eric_saibi__9848__Market briefs
Sheet: Sheet1

Market Briefs | Tuesday, October 9
Stocks | Close | Change | % Change
DJIA | 9052.44 | -15.5 | -0.001709318764791121
DJ 15 Util. | 315.05 | -5.300000000000011 | -0.01654440455751525
NASDAQ | 1570.19 | -35.76 | -0.02226719387278557
S&P 500 | 1055.96 | -5.700000000000045 | -0.005368950511463222
Market Vols | Close | Change | % Change
AMEX (000) | 116845 | -9148 | -0.0726072083369711
NASDAQ (000) | 1521987 | 106931 | 0.07556662068497642
NYSE (000) | 1173467 | 196836 | 0.2015459267625132
Commodities | Close | Change | % Change
Crude Oil (Nov) | 22.4 | 0.1899999999999977 | 0.008554705087798186
Heating Oil (Nov) | 0.6445 | 0.003499999999999948 | 0.005460218408736267
Nat. Gas (Henry) | 2.385 | 0.1019999999999999 | 0.04467805519053871
Propane (Nov) | 39.75 | 0.25 | 0.006329113924050633
Palo Verde (Nov) | 34 | 0 | 0
COB (Nov) | 31.5 | 0 | 0
PJM (Nov) | 28.9 | 0 | 0
Dollar US $ | Close | Change | % Change
Australia $ | 1.997 | 0.02600000000000002 | 0.01319127346524608
Canada $ | 1.565 | 0.002999999999999892 | 0.001920614596670865
Germany Dmark | 2.14 | 0.01200000000000001 | 0.005639097744360907
Euro | 0.9131 | -0.007900000000000018 | -0.008577633007600454
Japan ¥en | 120.2 | 0.4000000000000057 | 0.003338898163606057
Mexico NP | 9.44 | -0.120000000000001 | -0.01255230125523023
[NAME] | 0.6854 | 0.007099999999999995 | 0.0104673448326699
Foreign Indices | Close | Change | % Change
Arg MerVal | 213.52 | -1.349999999999994 | -0.006282868711313791
[NAME]. | 3087.7 | 11.89999999999964 | 0.003868912152935703
[NAME] | 10284.45 | 189.8900000000012 | 0.01881112203008365
Can TSE 300 | 6869.3 | -24.9399999999996 | -0.003617512590220184
Germany DAX | 4472.42 | -22.72999999999956 | -0.005056560960145839
[NAME] | 10358.93 | 391.1 | 0.03923622292916316
Japan Nikkei 225 | 10011.77 | -194.1 | -0.01901846682350455
[NAME] | 5558.86 | 31.75 | 0.005744412541092904
UK FTSE 100 | 5009.8 | -22.89999999999964 | -0.004550241421105895
Source:  Yahoo! & TradingDay.com
Spreadsheet: 708297d1607707372-sum-formula-with-multiple-cases-filters-sum-formula-example
Sheet: Data

Owner | Symbol | Description | Quantity | Price | Amount | Trading Month | Open Position
[NAME] | ETHE | Bought | 150 | 50.21 |  | 1 | yes
[NAME] | ETHE | Bought | 150 | 49.28 |  | 1 | yes
[NAME] | GBTC | Bought | 100 | 80.98 |  | 2 | no
[NAME] | RKT | Bought | 20 | 23.12 |  | 3 | yes
[NAME] | APPS | Bought | 50 | 24.66 |  | 4 | no
[NAME] | RKT | Bought | 80 | 24 |  | 3 | yes
[NAME] | RKT | Sold | 75 | 22.53 |  | 3 | yes
[NAME] | ETHE | Sold | 295 | 51.23 |  | 1 | yes
[NAME] | GBTC | Sold | 100 | 78.43 |  | 2 | no
[NAME] | APPS | Bought | 15 | 22.1 |  | 4 | no
[NAME] | APPS | Bought | 15 | 20.35 |  | 4 | no
[NAME] | APPS | Sold | 80 | 26 |  | 4 | no
[NAME] | APPS | Bought | 50 | 22.33 |  | 1 | no
[NAME] | APPS | Sold | 50 | 22.34 |  | 1 | no
[NAME] | APPS | Bought | 150 | 20.15 |  | 2 | yes
Spreadsheet: 680983d1591285309-grouping-continuous-dates-dates-example
Sheet: Sheet1

Tenant | From | To | Tenancy
A | 2011-04-10 00:00:00 | 2011-08-31 00:00:00 | 1 |  | 2011-04-10 00:00:00 | 2014-08-31 00:00:00
A | 2011-09-01 00:00:00 | 2012-08-31 00:00:00 | 1 |  | 2015-09-01 00:00:00 | 2015-12-20 00:00:00
A | 2012-09-01 00:00:00 | 2013-06-30 00:00:00 | 1 |  | 2016-09-01 00:00:00 | 2017-08-31 00:00:00
A | 2013-07-01 00:00:00 | 2013-08-31 00:00:00 | 1 |  | 2018-09-01 00:00:00 | 2019-08-31 00:00:00
A | 2013-09-01 00:00:00 | 2014-08-31 00:00:00 | 1
A | 2015-09-01 00:00:00 | 2015-12-20 00:00:00 | 2
B | 2016-09-01 00:00:00 | 2017-08-31 00:00:00 | 1
B | 2018-09-01 00:00:00 | 2019-08-31 00:00:00 | 2
Spreadsheet: 693906d1599211345-zone-weight-base-rate-calculation-excel-formula-file1
Sheet: Daily Data

CHARGBLE WEIGHT | ZONE | BASE RATE
8.3 | 4
20 | 5
1 | 5
20 | 5
30 | 5
0.1 | 5
49 | 5
0.5 | 4
1.5 | 4
22 | 5
7 | 5
0.5 | 5
21 | 4
21 | 4
23 | 4
12.5 | 4
0.5 | 7
1 | 5
44 | 4
16 | 4
32.5 | 4
23 | 4
3 | 5
12 | 4
6.5 | 4
5 | 5
2.5 | 4
1 | 5
8 | 6
22 | 4
9 | 4
1.5 | 6
21.5 | 5
22 | 5
0.1 | 4
25 | 5
11.5 | 5
1.5 | 4
1 | 4
21 | 4
12 | 4
9 | 5
2 | 6
7 | 4
30 | 5
30 | 6
15 | 5
7.5 | 5
1 | 5
Spreadsheet: 154037d1336156803-find-highest-value-in-a-row-and-return-a-value-from-a-different-row-row-lookup-example
Sheet: Sheet1

Number of Occurences  in the Majority of Hours |  | Hours with 0 Occurences | Hours with 1 Occurrence | Hours with 2 Occurences | Hours with 3 Occurences | Hours with 4 Occurences | Hours with 5 Occurences | Hours with 6 Occurences | Hours with 7 Occurences | Hours with 8 Occurences | Hours with 9 Occurences | Hours with 10 Occurences | Hours with 11 Occurences | Hours with 12 Occurences | Hours with 13 Occurences
 |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 |  | 0 | 1 | 0 | 743 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 1 | 743 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 1 | 0 | 0 | 0 | 0 | 743 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 43 | 0 | 0 | 700 | 0 | 0
 |  | 1 | 233 | 510 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 1 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 733 | 0 | 0 | 0
 |  | 1 | 743 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 2 | 42 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 700 | 0
 |  | 1 | 741 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Want Column A to find highest value in the row and return the corresponding row 2 value for that column with the highest value from the row
For example: [NAME] to display 3 (finds 743 in F3 to be highest row value and then returns the number in cell F2, which is 3)
For example: Want A6 to display 11 (finds 700 in N6 to be highest row value and then returns the number in cell N2, which is 11)
Correct numbers for the final output in Column A will be:
Number of Occurences  in the Majority of Hours
3
1
5
11
2
10
1
12
1
Spreadsheet: gstorey__12024__DEC00
Sheet: table2

NATURAL GAS EXPORTS BY TERM, REGION, AND CUSTOMER TYPE |  |  |  |  |  |  |  |  |  |  |  | TABLE 2
EXPORTATIONS DE GAZ NATUREL PAR TERME, RÉGION, ET CLIENT
 |  |  |  | AVERAGE PRICE |  |  |  |  |  | AVERAGE PRICE
 | VOLUME |  |  | PRIX MOYEN |  |  | VOLUME |  |  | PRIX MOYEN
 | (MILLIONS M3) |  |  | ($CDN/GJ) |  |  | (MILLIONS M3) |  |  | ($CDN/GJ)
 |  |  | % CHANGE |  |  | % CHANGE |  |  | % CHANGE |  |  | % CHANGE
 |  |  | VARIATION |  |  | VARIATION | 1999-11-01 00:00:00 | 2000-11-01 00:00:00 | VARIATION | 1999-11-01 00:00:00 | 2000-11-01 00:00:00 | VARIATION
 | 1999-12-01 00:00:00 | 2000-12-01 00:00:00 | EN % | 1999-12-01 00:00:00 | 2000-12-01 00:00:00 | EN % | 1999-12-01 00:00:00 | 2000-12-01 00:00:00 | EN % | 1999-12-01 00:00:00 | 2000-12-01 00:00:00 | EN %
TERM/TERME
LONG-TERM (FIRM)/LONG TERME (GARANTI) | 2373.4 | 1976.8 | -16.7 | 3.33 | 8.2 | 146.5 | 4411.9 | 3936 | -10.8 | 3.62 | 7.22 | 99.6
SHORT-TERM (FIRM)/COURT TERME (GARANTI) | 3910.3 | 4646.4 | 18.8 | 3.05 | 10.5 | 243.9 | 7467.3 | 9004.5 | 20.6 | 3.39 | 8.71 | 157.1
SHORT-TERM/COURT TERME (INTERRUPTIBLE) | 2383.3 | 3622.9 | 52 | 3.07 | 10.68 | 248.2 | 5017.3 | 6526.5 | 30.1 | 3.46 | 9.03 | 161.1
TOTAL - TERM/TERME | 8667 | 10246 | 18.2 | 3.13 | 10.13 | 223.2 | 16896.5 | 19466.9 | 15.2 | 3.47 | 8.52 | 145.6
REGION/RÉGION
CALIFORNIA/CALIFORNIE | 1916.2 | 1717.5 | -10.4 | 3.13 | 10.69 | 241.5 | 3595 | 3240.6 | -9.9 | 3.41 | 8.89 | 160.7
MIDWEST/MIDWEST | 3192.8 | 3901.4 | 22.2 | 2.86 | 8.84 | 208.5 | 6207.1 | 7318.7 | 17.9 | 3.32 | 7.67 | 130.7
MOUNTAIN/ROCHEUSES | 74.9 | 37.2 | -50.3 | 2.89 | 6.77 | 134.4 | 158.2 | 87.2 | -44.9 | 3.11 | 5.99 | 92.7
NORTHEAST/NORD-EST | 2246.7 | 3301.8 | 47 | 3.56 | 9.18 | 157.8 | 4414.7 | 6297.8 | 42.7 | 3.83 | 8.18 | 113.6
PACIFIC NORTHWEST/NORD-OUEST PACIFIQUE | 1236.5 | 1288.2 | 4.2 | 3.07 | 15.76 | 412.8 | 2521.4 | 2522.6 | 0 | 3.31 | 11.42 | 245.2
TOTAL - REGION/RÉGION | 8667 | 10246 | 18.2 | 3.13 | 10.13 | 223.2 | 16896.5 | 19466.9 | 15.2 | 3.47 | 8.52 | 145.6
CUSTOMER TYPE/CLIENT
END-USER/UTILISATEURS ULTIMES | 669.4 | 541.5 | -19.1 | 3.68 | 6.89 | 87.3 | 1336.6 | 1011.3 | -24.3 | 3.84 | 6.45 | 68.1
LDC/SDL | 2294.1 | 2165.8 | -5.6 | 3.26 | 10.11 | 209.8 | 4376.8 | 4366.1 | -0.2 | 3.53 | 8.35 | 136.5
MARKETING CO./DISTRIBUTEURS | 5381.4 | 7243.5 | 34.6 | 3 | 10.46 | 249.2 | 10567.1 | 12988.8 | 22.9 | 3.4 | 8.85 | 160
PIPELINE/PIPELINES | 322.2 | 295.2 | -8.4 | 3.37 | 7.92 | 135 | 616 | 1100.7 | 78.7 | 3.37 | 7.19 | 113.6
TOTAL - CUSTOMER TYPE/CLIENT | 8667 | 10246 | 18.2 | 3.13 | 10.13 | 223.18 | 16896.5 | 19466.9 | 15.2 | 3.47 | 8.52 | 145.6
NOTE: | THE AVERAGE PRICE IS THE WEIGHTED AVERAGE |  |  |  |  |  | NOTA: | LE PRIX MOYEN EST LE PRIX MOYEN PONDÉRÉ
 | PRICE AT THE INTERNATIONAL BORDER |  |  |  |  |  |  | À LA FRONTIÈRE INTERNATIONALE
Spreadsheet: 879330d1726821170-find-a-date-in-a-row-of-data-and-return-the-value-in-the-cell-next-to-it-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-09-16 00:00:00 | 2024-09-17 00:00:00 | 2024-09-18 00:00:00 | 2024-09-19 00:00:00 | 2024-09-20 00:00:00 | 2024-09-21 00:00:00 | 2024-09-22 00:00:00 | 2024-09-23 00:00:00 | 2024-09-24 00:00:00 | 2024-09-25 00:00:00 | 2024-09-26 00:00:00 | 2024-09-27 00:00:00 | 2024-09-28 00:00:00 | 2024-09-29 00:00:00 | 2024-09-30 00:00:00 | 2024-10-01 00:00:00 | 2024-10-02 00:00:00 | 2024-10-03 00:00:00 | 2024-10-04 00:00:00 | 2024-10-05 00:00:00
 | RC13029D | 2024-09-19 00:00:00 | 1802 | 2024-09-26 00:00:00 | 3180 | 2024-10-04 00:00:00 | 1908-09-14 00:00:00 | 2024-10-11 00:00:00 | 1908-09-14 00:00:00 | 2024-10-18 00:00:00 | 1272 |  |  |  | RC13029D | 3600
 | RC40041 | 2024-09-19 00:00:00 | 1982 |  |  |  |  |  |  |  |  |  |  |  | RC40041 | 2400
 | RC90044 | 2024-10-15 00:00:00 | 3663 |  |  |  |  |  |  |  |  |  |  |  | RC90044 | 10912
 | RC15012 |  |  |  |  |  |  |  |  |  |  |  |  |  | RC15012 | 6190
 | RC50059 |  |  |  |  |  |  |  |  |  |  |  |  |  | RC50059 | 12224
 | RC60091 | 2024-09-25 00:00:00 | 6846 | 2024-10-04 00:00:00 | 6846 | 2024-10-13 00:00:00 | 1918-09-28 00:00:00 |  |  |  |  |  |  |  | RC60091 | 8800
 | RC25337 |  |  |  |  |  |  |  |  |  |  |  |  |  | RC25337 | 3300
 | RC60092 | 2024-09-25 00:00:00 | 59014 | 2024-10-02 00:00:00 | 63553 | 2024-10-09 00:00:00 | 2073-12-30 00:00:00 | 2024-10-16 00:00:00 | 1999-06-05 00:00:00 |  |  |  |  |  | RC60092 | 26400
 | RC50057 | 2024-09-20 00:00:00 | 81719 | 2024-10-03 00:00:00 | 40860 | 2024-10-10 00:00:00 | 2011-11-13 00:00:00 | 2024-10-17 00:00:00 | 1949-09-19 00:00:00 |  |  |  |  |  | RC50057 | 15400
 | RC60094 | 2024-10-04 00:00:00 | 13709 | 2024-10-11 00:00:00 | 13709 | 2024-10-18 00:00:00 | 1937-07-13 00:00:00
 | RC60095 | 2024-10-07 00:00:00 | 13834
Spreadsheet: 98861d1297701508-formula-or-formatting-solution-for-currency-and-percentage-number-display-number-and-percentage-test-sheet
Sheet: Sheet1

 |  |  |  |  | Initial Budget | LE | Actual
 | Approved Budget |  |  | January | 0 | 0 | 300000
 | 1845500 |  |  | February | 0 | 0 | 0
 |  |  |  | March | 144992.5 | 144992.5 | 0
 | Remaining Budget |  |  | April | 0 | 0 | 0
 |  |  |  | May | 0 | 0 | 0
 |  |  |  | June | 889519.8000000002 | 889519.8000000002 | 0
 | Over/Under Budget |  |  | July | 0 | 0 | 0
 |  |  |  | August | 0 | 0 | 0
 |  |  |  | September | 380250 | 380250 | 0
 | Unallocated Funds |  |  | October | 0 | 0 | 0
 | 0 |  |  | November | 0 | 0 | 0
 |  |  |  | December | 496792.5 | 496792.5 | 0
 |  |  |  | Total | 1911554.8 | 1911554.8 | 300000
 | Correct Percentage:
Spreadsheet: 828906d1683791260-search-a-text-from-an-array-of-values-fetch-object-aligw
Sheet: Data

Text | Find Object | Expected Result | AliGW
1.  Hours and [NAME] (P311221) |  | P311221
1. RMA Revisions - P400511 (ZJDE0001) |  | P400511
6. Preference Profile (R40400) |  | R40400
12. Specify P4113 version to use (Recognize blank LOTS) custom PO's from P4113 to hold TO_LOCATION lot status even though it is blank.   Note - this option is used inline with above PO option value -1.    Default - ZJDE0001 |  | P4113
2. Enter Version for R04110ZA |  | R04110ZA
1. Enter Version for R47011 : |  | R47011
3.  Enter the version for [NAME] (cvt to .txt) to call.       Blank = Version XBX0002 with the country        code defined here. |  | [NAME]
12. P42101 [NAME] |  | P42101
1. R42565 Version |  | R42565
Spreadsheet: darron_c_giron__7933__ENA Upstream physicaldeals 120101 SBR
Sheet: Deals NOT to auto-terminate

Internal Party | External | Deal # | Comm | start | End | Contract | Sitara
ENA Upstream Company LLC | ECT Merchant Investments Corp. | QH6036.1 | NG | 2001-01-01 00:00:00 | 2003-06-30 00:00:00 | None 96058252 | 703613 | No, affiliate
ENA Upstream Company LLC | ECT Merchant Investments Corp. | QH6036.3 | NG | 2001-01-01 00:00:00 | 2003-06-30 00:00:00 | None | None | No, affiliate