tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 45096d1243878476-if-and-and-max-function-file_excel-help
Sheet: Sheet1

C1 | C2 | [NAME] | Calculated Value |  |  | Correct Value
E | 13 | 5.75 |  | I have checked for the letter E from column 1, the maximum Value for Letter E from Column 2 and then the Maximum Value from Column 3 for the two conditions |  | 6.25
E | 6 | 2.3 |  |  |  | The yellow colored row is the option that I mjust be pulling out.
E | 8 | 0
E | 8 | 0
E | 8 | 1.6
E | 14 | 2.25
E | 12 | 1.4
E | 14 | 6.5
E | 8 | 1.26
N | 16 | 1.6695
N | 0 | 0.48
N | 0 | 0.039
N | 0 | 0
N | 0 | 0.5171
N | 0 | 0.528
N | 0 | 0
N | 0 | 0.008
N | 0 | 0.1646
N | 0 | 0
N | 0 | 0
N | 0 | 0.28
N | 0 | 92.74
N | 0 | 0.176
N | 0 | 0
N | 0 | 0.099
N | 5 | 2.56
N | 0 | 0.5115
N | 6 | 4.28
N | 6 | 1.16
N | 6 | 4.2
N | 8 | 3.4
N | 7 | 0.185
N | 0 | 0.29
N | 3 | 2.47
N | 0 | 0.2
N | 14 | 1.1
N | 8 | 0.072
N | 7 | 4.55
N | 3 | 2.65
N | 4 | 1.89
N | 7 | 6.118
N | 10 | 18.7
N | 8 | 4.12
N | 0 | 0.4166
N | 8 | 3.25
N | 8 | 1.343
N | 0 | 1.305
N | 14 | 22.62
N | 0 | 0.045
N | 4 | 1.7
N | 4 | 0.22
N | 7 | 0.43
N | 9 | 0.79
N | 10 | 2.25
N | 0 | 0.977
N | 14 | 2.7368
N | 0 | 0.56
N | 0 | 0
N | 0 | 0.013
N | 4 | 12.9
N | 0 | 0.0552
N | 7 | 0.43
N | 0 | 0.9
N | 7 | 0.86
N | 16 | 0.78
N | 0 | 0.14
N | 0 | 0
N | 6 | 0.036
N | 4 | 4.3
N | 0 | 0.0364
N | 6 | 2.0216
N | 8 | 1.8
N | 0 | 0.394
N | 0 | 0.022
N | 9 | 0.428
N | 8 | 2.25
N | 13 | 2.88
N | 0 | 0.0918
N | 8 | 0.07
N | 0 | 0.33
N | 5 | 0.88
N | 0 | 0.1312
N | 18 | 6.96
N | 0 | 0
N | 3 | 9.2
N | 3 | 1.08
N | 0 | 0.81
N | 0 | 0
N | 0 | 0
N | 0 | 0
N | 0 | 0.351
N | 0 | 0.24
N | 0 | 0
N | 0 | 0
N | 0 | 0.6
N | 12 | 0.032
N | 0 | 0
N | 0 | 0.026
N | 0 | 0
N | 0 | 0.023
N | 0 | 0
N | 8 | 0.94
N | 0 | 0.038
N | 8 | 0.72
N | 0 | 0.0448
N | 0 | 1.296
N | 12 | 0.016
N | 12 | 0.016
N | 0 | 0.0158
N | 0 | 0.024
N | 0 | 1.21
N | 0 | 0.0698
N | 12 | 2
N | 0 | 0.128
N | 0 | 0.0342
N | 0 | 0
N | 0 | 0
N | 0 | 1.2
N | 0 | 0.0144
N | 0 | 0
N | 0 | 0.0036
N | 0 | 0.004
N | 12 | 0.128
N | 0 | 0.008
N | 0 | 0
N | 12 | 0.096
N | 0 | 0.003
N | 0 | 0.004
N | 12 | 0.176
N | 0 | 0.0164
N | 0 | 0.0234
N | 0 | 0.54
N | 0 | 0.1008
N | 0 | 0.0306
N | 0 | 0
N | 0 | 0.004
N | 0 | 0.004
N | 0 | 0.03
N | 8 | 0.036
N | 0 | 1.0681
N | 0 | 0.006
N | 0 | 0.051
N | 0 | 0
N | 0 | 0.56
N | 0 | 0.0294
N | 0 | 0.043
N | 0 | 0.088
N | 0 | 0.0064
N | 0 | 0.005
Spreadsheet: matthew_lenhart__26344__TexacoPG&ETopock deals
Sheet: 695849

Deal Id | 695849 |  |  |  |  |  | Original Deal Volume |  |  | Deal Price
Month | 2001-04-01 00:00:00 |  |  |  |  |  | 7465 |  |  | 7.2
 |  | Pipe | Zone | MeterCode
 |  | PG&E |  |  | Sum
 |  | SBELP TPCK |  | Sum |  |  |  |  | PG&E Large Packages |  |  | Contract |  | PG&E Large Packages
 | Date | EP0202RSB - SB-EPNG/ | Sum |  |  |  | Volume Cut |  | Gas Daily Price |  |  | Penalty |  | Gas Daily Hi Price |  | Hi - Penalty
 | 1 |  |  |  |  |  |  |  | 7.65 |  |  |  |  | 8.31
 | 2 | 6420 | 6420 | 6420 | 6420 |  |  |  | 7.65 |  |  |  |  | 8.31
 | 3 | 7112 | 7112 | 7112 | 7112 |  |  |  | 6.035 |  |  |  |  | 6.66
 | 4 | 6873 | 6873 | 6873 | 6873 |  |  |  | 7.96 |  |  |  |  | 9.3
 | 5 | 4198 | 4198 | 4198 | 4198 |  |  |  | 10.895 |  |  |  |  | 12.12
 | 6 | 5338 | 5338 | 5338 | 5338 |  |  |  | 11.59 |  |  |  |  | 12.99
 | 7 | 7465 | 7465 | 7465 | 7465 |  |  |  | 11.83 |  |  |  |  | 12.24
 | 8 |  |  |  |  |  |  |  | 11.83 |  |  |  |  | 12.24
 | 9 | 7465 | 7465 | 7465 | 7465 |  |  |  | 11.83 |  |  |  |  | 12.24
 | 10 | 6450 | 6450 | 6450 | 6450 |  |  |  | 11.575 |  |  |  |  | 12.25
 | 11 | 7465 | 7465 | 7465 | 7465 |  |  |  | 11.73 |  |  |  |  | 11.93
 | 12 | 4539 | 4539 | 4539 | 4539 |  |  |  | 11.62 |  |  |  |  | 12.23
 | 13 | 309 | 309 | 309 | 309 |  |  |  | 11.805 |  |  |  |  | 12.3
 | 14 | 134 | 134 | 134 | 134 |  |  |  | 11.805 |  |  |  |  | 12.3
 | 15 | 1142 | 1142 | 1142 | 1142 |  |  |  | 11.805 |  |  |  |  | 12.3
 | 16 |  |  |  |  |  |  |  | 11.805 |  |  |  |  | 12.3
 | 17 |  |  |  |  |  |  |  | 11.775 |  |  |  |  | 12
 | 18 | 3528 | 3528 | 3528 | 3528 |  |  |  | 11.42 |  |  |  |  | 11.9
 | 19 | 7465 | 7465 | 7465 | 7465 |  |  |  | 11.37 |  |  |  |  | 11.9
 | 20 |  |  |  |  |  |  |  | 11.045 |  |  |  |  | 11.67
 | 21 |  |  |  |  |  |  |  | 10.67 |  |  |  |  | 11.23
 | 22 | 7465 | 7465 | 7465 | 7465 |  |  |  | 10.67 |  |  |  |  | 11.23
 | 23 |  |  |  |  |  |  |  | 10.67 |  |  |  |  | 11.23
 | 24 | 7132 | 7132 | 7132 | 7132 |  |  |  | 10.855 |  |  |  |  | 11.42
 | 25 | 770 | 770 | 770 | 770 |  |  |  | 11.995 |  |  |  |  | 12.6
 | 26 | 2534 | 2534 | 2534 | 2534 |  |  |  | 12.52 |  |  |  |  | 13.1
 | 27 | 1927 | 1927 | 1927 | 1927 |  |  |  | 12.105 |  |  |  |  | 12.6
 | 28 | 546 | 546 | 546 | 546 |  |  |  | 12.005 |  |  |  |  | 12.18
 | 29 | 4393 | 4393 | 4393 | 4393 |  |  |  | 12.005 |  |  |  |  | 12.18
 | 30 | 7464 | 7464 | 7464 | 7464 |  |  |  | 12.005 |  |  |  |  | 12.18
 | Sum |  | 108134 | 108134 | 108134
Spreadsheet: 493332d1481659785-how-to-create-a-rolling-data-feed-example1
Sheet: Daily

day | Clicks | Views
2016-12-01 00:00:00 | 268876 | 268162
2016-12-02 00:00:00 | 268564 | 267726
2016-12-03 00:00:00 | 230941 | 230302
2016-12-04 00:00:00 | 254523 | 253753
2016-12-05 00:00:00 | 306240 | 305265
2016-12-06 00:00:00 | 144388 | 143696
2016-12-07 00:00:00 | 201966 | 201131
2016-12-08 00:00:00 | 220552 | 219827
2016-12-09 00:00:00 | 193175 | 192729
2016-12-10 00:00:00 | 155766 | 155314
2016-12-11 00:00:00 | 62407 | 61894
2016-12-12 00:00:00 | 82578 | 82083
2016-12-13 00:00:00 | 163902 | 163480
Spreadsheet: 872721d1719091845-sumproduct-sum-date-range-down-to-second-transactions-sample-time-tests
Sheet: Data

Column1 | Column2 | Transaction Type | Status | Unit Date | Requested / Deposited Amount | Column3 | Column4 | Column5 | Column6
 |  | 5 | Completed | 2024-05-03 00:59:59 | 112.82 |  |  |  |  |  | <The unit date/time here is 12:59:59 AM, but it is not being included in the formula on sheet 2.
 |  | 5 | Completed | 2024-05-03 00:01:36 | 25.23
 |  | 5 | Completed | 2024-05-03 00:01:38 | 100
 |  | 5 | Completed | 2024-05-03 00:02:37 | 100.33
 |  | 5 | Completed | 2024-05-03 00:02:48 | 50.26
 |  | 6 | Completed | 2024-05-03 00:02:48 | 100.05
 |  | 5 | Completed | 2024-05-03 00:03:00 | 100
 |  | 6 | Completed | 2024-05-03 00:03:34 | 251.5
 |  | 1 | Completed | 2024-05-03 00:04:37 | 120
Spreadsheet: 766282d1643826740-get-a-number-reference-for-last-colum-with-data-test-5
Sheet: Feuil1

 |  | date | 2021-01-01 00:00:00 | date | 2021-03-01 00:00:00 | date | 2021-05-01 00:00:00 | date | 2021-08-01 00:00:00 | date | 2021-12-01 00:00:00 | date | 2022-02-01 00:00:00
LAST COLUMN WITH DATA | item # | qty | price | qty | price | qty | price | qty | price | qty | price | qty | price
14 | 123 | 150 | 1.25 |  |  |  |  |  |  |  |  | 130 | 1.4
12 | 124 |  |  | 1025 | 0.09 |  |  |  |  | 1025 | 0.09
12 | 125 |  |  | 1100 | 0.08 |  |  |  |  | 1100 | 0.08
14 | 126 | 125 | 6.5 |  |  |  |  |  |  |  |  | 105 | 7
12 | 127 |  |  |  |  | 500 | 2.3 |  |  | 200 | 3.5
8 | 128 |  |  |  |  | 400 | 6.9
1 | 129
14 | 130 | 310 | 22 |  |  |  |  |  |  |  |  | 250 | 26
Spreadsheet: 28864d1223424017-list-only-items-with-value-0-in-a-matrixs-line-or-column-diet-thingy
Sheet: Sheet1

 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
pizza
more pizza |  | 2 |  |  | 2 |  | 1
mac n cheese | 1 | 2 | 2 |  | 2 | 1
beer |  |  | 4 | 3
whiskey | 2 | 3 |  | 2
vodka |  |  | 1 |  | 1 | 2 | 3
cheese | 1 |  | 2 |  |  | 1
more beer |  |  |  | 1 |  |  | 2
even more pizza |  | 3 |  |  |  | 1
pizza pops | 2 |  | 2 |  | 2 | 3 | 3
Spreadsheet: 0fbf52eb-f0af-4ccd-957e-cfb566f2d583
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
 | Time Series Workbook
 | 5625.0 Private New Capital Expenditure and Expected Expenditure, Australia
 | TABLE 9A. Actual and Expected Capital Expenditure by Asset - South Australia:Current Prices $m
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Actual Expenditure - Current Price ;  South Australia ;  Total All Industries ;  Total (Employment Size) ;  [NAME] and [NAME] ; |  |  | Original | A2148150L | 1989-06-01 00:00:00 | 2009-06-01 00:00:00 | 81 | $ Millions | FLOW | Quarter | 3
Actual Expenditure - Current Price ;  South Australia ;  Total All Industries ;  Total (Employment Size) ;  Equipment, Plant and Machinery ; |  |  | Original | A2148178R | 1989-06-01 00:00:00 | 2009-06-01 00:00:00 | 81 | $ Millions | FLOW | Quarter | 3
Actual Expenditure - Current Price ;  South Australia ;  Total All Industries ;  Total (Employment Size) ;  Total (Type of Asset - Detailed Level) ; |  |  | Original | A2148206L | 1989-06-01 00:00:00 | 2009-06-01 00:00:00 | 81 | $ Millions | FLOW | Quarter | 3
Long Term Expected Expenditure - Current Price ;  South Australia ;  Total All Industries ;  Total (Employment Size) ;  [NAME] and [NAME] ; |  |  | Original | A2148152T | 1989-06-01 00:00:00 | 2009-06-01 00:00:00 | 81 | $ Millions | FLOW | Quarter | 3
Long Term Expected Expenditure - Current Price ;  South Australia ;  Total All Industries ;  Total (Employment Size) ;  Equipment, Plant and Machinery ; |  |  | Original | A2148180A | 1989-06-01 00:00:00 | 2009-06-01 00:00:00 | 81 | $ Millions | FLOW | Quarter | 3
Long Term Expected Expenditure - Current Price ;  South Australia ;  Total All Industries ;  Total (Employment Size) ;  Total (Type of Asset - Detailed Level) ; |  |  | Original | A2148208T | 1989-06-01 00:00:00 | 2009-06-01 00:00:00 | 81 | $ Millions | FLOW | Quarter | 3
Short Term Expected Expenditure - Current Price ;  South Australia ;  Total All Industries ;  Total (Employment Size) ;  [NAME] and [NAME] ; |  |  | Original | A2148151R | 1989-06-01 00:00:00 | 2009-06-01 00:00:00 | 81 | $ Millions | FLOW | Quarter | 3
Short Term Expected Expenditure - Current Price ;  South Australia ;  Total All Industries ;  Total (Employment Size) ;  Equipment, Plant and Machinery ; |  |  | Original | A2148179T | 1989-06-01 00:00:00 | 2009-06-01 00:00:00 | 81 | $ Millions | FLOW | Quarter | 3
Short Term Expected Expenditure - Current Price ;  South Australia ;  Total All Industries ;  Total (Employment Size) ;  Total (Type of Asset - Detailed Level) ; |  |  | Original | A2148207R | 1989-06-01 00:00:00 | 2009-06-01 00:00:00 | 81 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2009
Spreadsheet: 91833d1291508049-average-duration-for-canceled-bills-average-duration
Sheet: average duration

# client | Status | duration
 | canceled/pending | days
1 | c | 4
2 | c | 9
3 | p | 2
1 | p | 3
4 | c | 12
3 | c | 2
1 | c | 17
1 | c | 28
2 | p | 12
2 | c | 3
3 | c | 14
client# | average duration
 | only for canceled bills
1 | 16.3 | I  need the formula in cell B18:B21
2 | 6
3 | 8
4 | 12
Spreadsheet: 228191d1366036002-populating-an-excel-purchase-order-example
Sheet: Sheet1

 |  | Item Number | Description | CDN Price
 |  | 010631 | VLV 1.5 X 2 3P POS | 39.53
 |  | 010632 | VLV 2 X 2.5 3P POS | 63.68
 |  | 010646 | VLV 1.5 SPA RTN CK THD | 16.78
 |  | 010651 | VLV 1.5 SPG CK 1# | 32.77
 |  | 010652 | VLV 2.0 SPG CK 1# | 47.35
 |  | 010655 | VLV 2.0 SPG CK 3# | 47.35
 |  | 011008 | PMP INTELLIFLO i1 | 835.61
 |  | 011012 | PMP INTELLIFLO VF | 1187.03
 |  | 011017 | PMP INTELLIFLO VS+ SVRS | 978.36
 |  | 011018 | PMP INTELLIFLO VRBLE SPD | 835.61
 |  | 011019 | PMP INTELLIFLO VS+SVRS DISPLAY UNIT ALMOND | 421.71
 |  | 011021 | PMP WFK-3 208/230/460V 3/4HP 3PH 60HZ | 408.21
 |  | 011088 | PMP INTLFLO VRBLE DSPLY UNIT | 421.71
 |  | 011486 | PMP W/SWTCH WFDS-4 230V 1HP 2SP FULLRATED 60HZ | 459.62
 |  | 011511 | PMP WFE-2 115/208-230V 1/2HP FULLRATED ENGY EFF | 355.38
 |  | 011512 | PMP WFE-3 115/208-230V 3/4HP FULLRATED ENGY EFF | 382.98
 |  | 011513 | PMP WFE-4 115/208-230V 1HP FULLRATED ENGY EFF | 413.88
 |  | 011514 | PMP WFE-6 20/-230V 1.5HP FULLRATED ENGY EFFICIENT | 454.61
 |  | [NAME] | PMP WFE-8 208-230V 2HP FULLRATED ENGY EFFICIENT | 534.57
 |  | 011516 | PMP WFE-12 208-230V 3HP FULLRATED ENGY EFFICIENT | 653.9
 |  | 011517 | PMP WFE-24 115/208-230V 1HP UPRATE ENGY EFFICIEN | 392.23
 |  | 011518 | PMP WFE-26 115/208-230V 1 1/2HP UPRATE ENGY EFFI | 423.88
 |  | 011519 | PMP WFE-28 208-230V 2HP UPRATE ENGY EFFICIENT | 465.59
 |  | 011520 | PMP WFE-30 208-230V 2 1/2HP UPRATE ENGY EFF | 547.48
 |  | 011522 | PMP W/SWTCH WFDS-6 230V 11/2HP FULLRATED 60HZ | 553.39
 |  | 011523 | PMP W/SWTCH WFDS-8 230V 2HP 2SP FULLRATED 60HZ | 643.87
 |  | 011524 | PMP W/SWTCH WFDS-28 230V 2HP 2SP UPRATED 60HZ | 553.36
 |  | 011525 | PMP W/SWTCH WFDS-30 230V 21/2HP 2SP UPRATED 60HZ | 643.87
 |  | 011555 | FLT SMBW 4048 | 624.24
 |  | 011568 | PMP WFK-4 208/230/460V 1HP 3PH 60HZ | 436.34
 |  | 011569 | PMP WFK-6 208/230/460V 1 1/2HP 3PH 60HZ | 479.29
 |  | 011570 | [NAME] 208/230/460V 2HP 3PH 60HZ | 563.59
 |  | 011571 | PMP WFK-12 208/230/460V 3HP 3PH 60HZ | 689.39
 |  | 011578 | PMP WF-2 115/230V 1/2HP STD | 341.63
 |  | 011579 | PMP WF-3 115/230V 3/4HP STD | 373.26
Spreadsheet: 74505d1274997997-sumproduct-book1
Sheet: Data

 | Company | Address
Halifax | TCHC | 1
Halifax | TCHC | 2
Halifax | TCHC | 3
Halifax | TCHC | 4
Halifax | TCHC | 5
Halifax | Contract managed | 6
Halifax | Other companies | 7
Halifax | Other companies | 8
Halifax | Other companies | 9
Halifax | Other companies | 10
Halifax | TCHC | 11
Halifax | Contract managed | 12
Kitchener | TCHC | 13
Kitchener | Contract managed | 14
Kitchener | TCHC | 15
Kitchener | Other companies | 16
Kitchener | Other companies | 17
Kitchener | Other companies | 18
Kitchener | Other companies | 19
Kitchener | Other companies | 20
Kitchener | Contract managed | 21
Kitchener | TCHC | 22
Kitchener | Contract managed | 23
London | Contract managed | 24
London | Contract managed | 25
London | Other companies | 26
London | Other companies | 27
London | Other companies | 28
London | Other companies | 29
London | TCHC | 30
London | Contract managed | 31
Spreadsheet: lisa_gang__22248__ENA_PGE_APRIL_3_2002
Sheet: SYS-JD OR GRIZZ BR

From: | EPMI
To: | PGE System Transactions
Date: | 2002-04-03 00:00:00
HE
ENDING |  |  |  |  | SINK | SINK | SINK | SINK | SINK
Pacific Prevailing
Time | SYS/SYS OUT AT GRIZZLY | SYS | PGE LOSSES | PGE LOSSES | EPMI COB S/N | PGE LOSSES | TO GRIZZLY | TO SYS | TO [NAME] | BUY/RESALE
(PPT) |  |  |  |  | LOSS RETURN |  |  |  |  | [NAME]
0100 |  |  | 2 |  |  | -2
0200 |  |  | 2 |  |  | -2
0300 |  |  | 2 |  |  | -2
0400 |  |  | 2 |  |  | -2
0500 |  |  | 2 |  |  | -2
0600 |  |  | 2 |  |  | -2
0700 |  |  |  | 2 |  | -2
0800 |  |  |  | 2 |  | -2
0900 |  |  |  | 2 |  | -2
1000 |  |  |  | 2 |  | -2
1100 |  |  |  | 2 |  | -2
1200 |  |  |  | 2 |  | -2
1300 |  |  |  | 2 |  | -2
1400 |  |  |  | 2 |  | -2
1500 |  |  |  | 2 |  | -2
1600 |  |  |  | 2 |  | -2
1700 |  |  |  | 2 |  | -2
1800 |  |  |  | 2 |  | -2
1900 |  |  |  | 2 |  | -2
2000 |  |  |  | 2 |  | -2
2100 |  |  |  | 2 |  | -2
2200 |  |  |  | 2 |  | -2
2300 |  |  | 2 |  |  | -2
2400 |  |  | 2 |  |  | -2
 |  |  | IPC(G)SYS | PAC(G)MIDC |  |  |  |  |  | SHOULD BE ZERO
 |  |  | IPC(T)SYS/LOLO | PNM | EPMI COB S/N | PGE LOSSES | TO COB' | TO COB' | TO COB'
 |  |  | WWP(T)LOLO/MIDC | ALLEGHENY | LOSS RETURN |  | SEE COB SHEET | SEE COB SHEET | SEE COB SHEET
 |  |  | IPC | EPMI(PSE)
 |  |  | MORGAN | SNPD(T) MIDC/PGE SYS
 | PGE(L,R)SYS/SYS OUT AT GRIZZLY | PGE(L,R)SYS   SYSTEM SALE | DYPM | EPMI(PSE)
 |  |  | AVISTA | PGE@SYS   LOSSES
 |  | NOT A BUY/RESALE | ALLEGHENY
 |  |  | EPMI(PSE)
 |  |  | SNPD(T) BPAP/PGE SYS
 |  |  | EPMI(PSE)
 |  |  | PGE@SYS   LOSSES
Spreadsheet: jim_schwieger__14294__STOR9830
Sheet: STOR951

ENRON CAPITAL & TRADE RESOURCES |  |  |  |  |  |  |  |  |  |  |  |  |  | Confidential - For Internal Use Only
STORAGE UPDATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | File: STOR9830
Below is a summary of the estimated storage working gas levels
for the week ending: |  |  | 2001-05-04 00:00:00
 |  | Gas In Stg | Gas in | Quantity | Percent | Percent |  |  |  |  | Last Year | Three | Five | Quantity | Quantity | Quantity
 |  | Prev Week | Storage | Change | Change | of Full |  |  |  |  | Same | Year | Year | Change From | Change From | Change From
U.S. Region |  | (Bcf) | (Bcf) | from last week | from last week | Capacity |  |  |  |  | Week | Average | Average | last year | 3 year avg. | 5 year avg.
Production Area |  | 286 | 320
(TX, LA, OK, KS, MS)
Market Area - East |  | 372 | 432
Market Area - West |  | 192 | 206
TOTAL U.S.
MONTH TO DATE
Enron Gas Services |  |  | 36.2 | 0 | 0 | 0.924 |  |  |  |  | ECTR is refilling [NAME] as third parties
(as of 1/20/95) |  |  |  |  |  |  |  |  |  |  |  |  |  | are withdrawing, this keeping our
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total position flat for the week.
AGA FULL CAPACITY |  |  | 3294 |  |  |  |  |  |  |  |  |  |  | 3294 | 3294 | 3294
Maximum Gas In Stg Level (Bcf) |  |  | 3127 |  |  |  |  |  |  |  |  |  |  | 3127 | 2832 | 2915
Minimum Gas In Stg Level (Bcf) |  |  | 831 |  |  |  |  |  |  |  |  |  |  | 1006 | 794 | 871
Spreadsheet: 116892d1312276572-if-formula-not-working-help
Sheet: Sheet1

item | item codes
15 | 15 | 0
27 | 27 | 0
44 | 44 | 0
56 | 56 | 0
68 | 68 | 0
71 | 71 | 0
75 | 75 | 0
79 | 79 | 0
83 | 83 | 0
89 | 89 | 0
92 | 92 | 0
94 | 94 | 0
97 | 97 | 0
101 | 101 | 0
103 | 103 | 0
108 | 108 | 0
116 | 116 | 0
122 | 122 | 0
125 | 125 | 0
135 | 135 | 0
136 | 136 | 0
137 | 137 | 0
149 | 149 | 0
156 | 156 | 0
157 | 157 | 0
161 | 161 | 0
176 | 176 | 0
181 | 181 | 0
187 | 187 | 0
191 | 191 | 0
195 | 195 | 0
197 | 197 | 0
201 | 201 | 0
203 | 203 | 0
205 | 205 | 0
210 | 210 | 0
211 | 211 | 0
216 | 216 | 0
217 | 217 | 0
220 | 220 | 0
221 | 221 | 0
222 | 222 | 0
223 | 223 | 0
224 | 224 | 0
225 | 225 | 0
226 | 226 | 0
234 | 234 | 0
236 | 236 | 0
242 | 242 | 0
249 | 249 | 0
254 | 254 | 0
260 | 260 | 0
263 | 263 | 0
265 | 265 | 0
267 | 267 | 0
270 | 270 | 0
275 | 275 | 0
280 | 280 | 0
289 | 289 | 0
292 | 292 | 0
296 | 296 | 0
299 | 299 | 0
328 | 305 | 1
333 | 310 | 1
336 | 311 | 1
339 | 328 | 1
358 | 333 | 1
366 | 336 | 1
367 | 339 | 1
372 | 358 | 1
373 | 366 | 1
388 | 367 | 1
393 | 372 | 1
394 | 373 | 1
397 | 388 | 1
399 | 393 | 1
401 | 394 | 1
402 | 397 | 1
403 | 399 | 1
406 | 401 | 1
414 | 402 | 1
417 | 403 | 1
420 | 406 | 1
423 | 414 | 1
426 | 417 | 1
430 | 420 | 1
446 | 423 | 1
449 | 426 | 1
459 | 430 | 1
461 | 446 | 1
463 | 449 | 1
486 | 459 | 1
489 | 461 | 1
490 | 463 | 1
495 | 486 | 1
497 | 489 | 1
507 | 490 | 1
512 | 495 | 1
515 | 497 | 1
521 | 507 | 1
523 | 512 | 1
526 | 515 | 1
530 | 521 | 1
531 | 523 | 1
534 | 526
536 | 530
541 | 531
544 | 534
547 | 536
549 | 541
550 | 544
552 | 547
554 | 549
558 | 550
560 | 552
567 | 554
568 | 558
569 | 560
571 | 567
572 | 568
574 | 569
577 | 571
587 | 572
591 | 574
592 | 577
600 | 587
603 | 591
619 | 592
656 | 600
661 | 603
667 | 619
671 | 656
677 | 661
687 | 667
689 | 671
692 | 677
693 | 687
698 | 689
702 | 692
711 | 693
720 | 698
723 | 702
748 | 711
754 | 720
773 | 723
777 | 748
780 | 754
782 | 767
788 | 773
789 | 777
800 | 778
809 | 780
813 | 782
821 | 788
826 | 789
836 | 800
 | 809
15-839 | 813
 | 821
 | 826
 | 836
 | 839
 | 867
 | 882
 | 919
 | 947
 | 951
 | 957
 | 977
 | 982
 | 987
 | 995
 | 999
 | 1017
 | 1020
 | 1025
 | 1035
 | 1058
 | 1062
 | 1067
 | 1069
 | 1073
 | 1080
 | 1089
 | 1091
 | 1092
 | 1097
 | 1100
 | 1108
 | 1111
 | 1127
 | 1130
 | 1141
 | 1151
 | 1158
 | 1163
 | 1166
 | 1167
 | 1176
 | 1182
 | 1183
 | 1185
 | 1195
 | 15-839
 | 867-1195
Spreadsheet: 818152d1676623332-sum-return-look-daily-and-return-weekly-copy-of-psr-daily-report-2023
Sheet: Sheet1

186 | 200 | 144 | 156 | 138 | 122 | 128 | 164 | 106 | 180 | 180 | 180 | 182 | 180 | 164 | 143 | 190 | 183 | 207 | 193 | 190 | 187 | 139 | 196 | 181 | 111 | 213 | 187 | 146 | 140 | 155 | 190 | 190 | 156 | 180 | 210 | 210 | 200 | 209 | 146 | 116 | 103 | 90 | 88 | 221 | 170 | 183 | 160 | 156 | 218 | 198 | 191 | 201 | 196 | 200 | 190 | 193 | 154 | 177 | 180 | 116 | 149 | 135 | 152 | 155 | 206 | 166 | 180 | 190 | 192 | 144 | 193 | 202 | 131 | 182 | 160 | 198 | 200 | 190 | 192 | 190 | 167 | 158 | 159 | 193 | 149 | 193 | 179 | 179 | 203 | 213 | 197 | 193 | 180 | 190 | 198 | 176 | 174 | 170 | 190 | 150 | 175 | 184 | 176 | 89 | 162 | 175 | 207 | 169 | 161 | 134 | 165 | 192 | 152 | 190 | 150 | 197
191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191 | 191
186 | 200 |  | 156 |  |  |  | 164 |  | 180 | 180 | 180 | 182 | 180 | 164 |  | 190 | 183 | 207 | 193 | 190 | 187 |  | 196 | 181 |  | 213 | 187 |  |  | 155 | 190 | 190 | 156 | 180 | 210 | 210 | 200 | 209 |  |  |  |  |  | 221 | 170 | 183 | 160 | 156 | 218 | 198 | 191 | 201 | 196 | 200 | 190 | 193 | 154 | 177 | 180 |  |  |  |  | 155 | 206 | 166 | 180 | 190 | 192 |  | 193 | 202 |  | 182 | 160 | 198 | 200 | 190 | 192 | 190 | 167 | 158 | 159 | 193 | 149 | 193 | 179 | 179 | 203 | 213 | 197 | 193 | 180 | 190 | 198 | 176 | 174 | 170 | 190 |  | 175 | 184 | 176 |  | 162 | 175 | 207 | 169 | 161 |  | 165 | 192 |  | 190 |  | 197
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 117
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45
Spreadsheet: 762179d1641429552-help-on-formula-with-3-criteria-in-columns-sample-book
Sheet: What I want it to be

Entity | Suite | DBA | Lease  Type | RCD  Date | Term RPSF | RPSF | Change
100370 | 00001 | Skyzone | Modified | 2017-11-01 00:00:00 | 15.27 | 14.82
100370 | 00001 | Skyzone | Contract | 2022-11-01 00:00:00 | 15.27 | 15.27
100370 | 00001 | Skyzone | REJREN | 2024-05-01 00:00:00 | 15.27 | 15.27
100370 | 00002 | Kids Empire | SPEC | 2022-09-01 00:00:00 | 22.58000307692308 | 18
100370 | 00003 | T-Mobile | Contract | 2016-11-01 00:00:00 | 23.48592734225621 | 23.48592734225621
100370 | 00003 | 215 Shops<10k | SPEC | 2022-12-01 00:00:00 | 23.49 | 23.49
100370 | 00004 | [NAME] | Contract | 2015-06-01 00:00:00 | 16.94 | 16.94
100370 | 00004 | 111 Anchors>10K | SPEC | 2025-10-01 00:00:00 | 18.63 | 16.94
100370 | 00005 | Lowe's Home Center | Contract | 2010-05-04 00:00:00 | 8.531810539928872 | 8.08276753960556
100370 | 00006 | [NAME] | Modified | 2018-07-13 00:00:00 | 17.35999226455231 | 15.50000386772384
100370 | 00007 | Planet Fitness | Modified | 2012-06-14 00:00:00 | 11.9168004196171 | 10.64
100370 | 00007 | Planet Fitness | ACCEPT | 2023-08-01 00:00:00 | 11.92 | 11.92
100370 | 00008 | Taco Bell | Contract | 2020-07-17 00:00:00 | 30.22443433029909 | 30.22443433029909
100370 | 00009 | [NAME] | Contract | 2015-04-10 00:00:00 | 14.50000158755358 | 13.5
100370 | 00010 | Outback Steakhouse | Modified | 2019-01-01 00:00:00 | 20.77719962157048 | 20.77719962157048
100370 | 00010 | 612 Shops<10K (Re)Dev | SPEC | 2024-10-01 00:00:00 | 101.5100094607379 | 92.28
100370 | 00011 | Shakey's Pizza | Modified | 2020-03-01 00:00:00 | 24.55403076923077 | 24.55403076923077
100370 | 00012 | Aldi | Modified | 2015-02-01 00:00:00 | 15.31 | 13.92
100370 | 00014 | [NAME] | Contract | 2017-04-01 00:00:00 | 44.08620624408704 | 44.08620624408704
100370 | 00014 | Fujin Ramen | Contract | 2021-02-22 00:00:00 | 45.40881740775781 | 44.08620624408704
100370 | 00014 | Fujin Ramen | Contract | 2022-04-01 00:00:00 | 51.10796594134342 | 45.40881740775781
100370 | 00015 | Cold Stone(SubT=AAG Enterprise | MTMEXT | 2018-03-01 00:00:00 | 45.96527472527473 | 43.32668131868132
100370 | 00015 | 202 Shops<10k | SPEC | 2025-12-01 00:00:00 | 51.74004395604395 | 45.97002197802198