tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 730869d1620006686-need-to-search-golf-scores-and-highlight-the-lowest-score-for-each-hole-if-it-is-unique-calculate-skins-answer
Sheet: Sheet1

(Program this...) |  |  |  |  | (...to look like this)
Hole | 1 | 2 | 3 |  | Hole | 1 | 2 | 3
Lowest score | 3 | 2 | 4 |  | Lowest score |  |  |  | << Low Score using Min
Skin Yes? |  |  |  |  | Count |  |  |  | << [NAME] that are Min
 |  |  |  |  | Skin Yes? |  |  |  | << Yes or no if count is 1 (Skin)
Player1 | 6 | 4 | 5 |  | Player1 | 6 | 4 | 5
Player2 | 5 | 2 | 5 |  | Player2 | 5 | 2 | 5
Player3 | 4 | 4 | 5 |  | Player3 | 4 | 4 | 5
Player4 | 3 | 2 | 5 |  | Player4 | 3 | 2 | 5
Player5 | 4 | 4 | 5 |  | Player5 | 4 | 4 | 5
Player6 | 5 | 4 | 4 |  | Player6 | 5 | 4 | 4
Player7 | 6 | 4 | 5 |  | Player7 | 6 | 4 | 5
Player8 | 7 | 2 | 5 |  | Player8 | 7 | 2 | 5
Player9 | 8 | 4 | 5 |  | Player9 | 8 | 4 | 5
Player10 | 9 | 4 | 5 |  | Player10 | 9 | 4 | 5
Spreadsheet: 111493d1307875148-want-to-write-macro-123
Sheet: Sheet1

sdkfjdlkjfdljkdlkjdlkj
kdfjlkdjfldkjflakdsj
sdkfjdlkjfdljkdlkjdlkj
Information | Invoice | Line | Critical | Special | Offers | [NAME] | Communication | Posting Date
abcd | 450452312 | 10 | 1 | No | sldkfjd | sdfelkdj | dskfjsdlk | 2011-02-03 00:00:00
efgh | 450342145 | 20 | 1 | Yes | ljfldkjf | dfdksjlk | dsfkjdslkf | 2011-02-04 00:00:00
abcd | 450231978 | 30 | 1 | No | [NAME] | dfkljsldkjf | klsdjflsdkj | 2011-02-05 00:00:00
efgh | 450121811 | 40 | 2 | Yes | jldkfjldkj | ksldkjflsdk | sdlkfjsdlkjfs | 2011-02-06 00:00:00
abcd | 450011644 | 50 | 1 | No | lkjdlfkjd | dslkjdfl | dsfjdslk | 2011-02-07 00:00:00
efgh | 449901477 | 60 | 3 | Yes | [NAME] | [NAME] | sdlkfjsdlkjfs | 2011-02-08 00:00:00
abcd | 449791310 | 70 | 1 | No | dskfjdlkj | sdlkfjdls | sdkfjsdl | 2011-02-09 00:00:00
efgh | 449681143 | 80 | 2 | Yes | [NAME] | jsdf;slj | dsfkjsldkjf | 2011-02-10 00:00:00
abcd | 449570976 | 90 | 1 | No | dslkfj | sdkljsdlk | sdkfjsldf | 2011-02-11 00:00:00
efgh | 449460809 | 100 | 4 | Yes | [NAME] | sdlfkjsdlkjf | sdlkfjsld | 2011-02-12 00:00:00
abcd | 449350642 | 110 | 1 | No | sdlkfjdsl | sdfkjsdl | sdflkjlsf | 2011-02-13 00:00:00
efgh | 449240475 | 120 | 2 | Yes | sdlkfjdsl | dsflkjljksd | sdfljlsdf | 2011-02-14 00:00:00
abcd | 449130308 | 130 | 1 | No | ldkfj | dlfksjlsdj | jsdlfkjlsd | 2011-02-15 00:00:00
efgh | 449020141 | 140 | 1 | Yes | sdlkfjdsl | sdlkfjsdlk | jsdlfjk | 2011-02-16 00:00:00
 | 448909974 | 150
 |  | I want to write Macro for below mentioned
 |  | Want to Remove Row A1,A2,A3,A5
 |  | 1. Need to Concatinate Collumn "B","C" (i.e.Invoice,Line)
 |  | 2. In collumn "C" need to filter by 1 (i.e.Critical)
 |  | 3. In Collumn "I" need to Sort by Desending
 |  | 4. In sheet 2 need Concatinate Collumn "A","B"
 |  | 5. Need to check both the concatinates and take from Collumn "I" data from Sheet 1
Spreadsheet: 48373b5f-395b-448d-b659-84183de36564
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-01-23 09:31:54.340000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.375 | 102.002 | 101.877 | 101.752 | 101.377
4.25 | 101.271 | 101.146 | 101.021 | 100.646 |  | Note: | Refer To Price [NAME]
4.125 | 100.775 | 100.65 | 100.525 | 100.15 |  |  | For all Price Adjs
4 | 100.347 | 100.222 | 100.097 | 99.472
3.875 | 99.774 | 99.649 | 99.524 | 98.899
3.75 | 98.903 | 98.778 | 98.653 | 98.028
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.125 | 102 | 101.875 | 101.5
3.75 | 101.623 | 101.498 | 101.373 | 100.998
3.625 | 101.346 | 101.221 | 101.096 | 100.721
3.5 | 101.03 | 100.905 | 100.78 | 100.405
3.375 | 100.625 | 100.5 | 100.375 | 99.75
3.25 | 100.051 | 99.926 | 99.801 | 99.176
3.125 | 99.426 | 99.301 | 99.176 | 98.551 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-02-06 09:31:54.340000
30 DAY | 2012-02-21 09:31:54.340000
45 DAY | 2012-03-07 09:31:54.340000
60 DAY | 2012-03-22 09:31:54.340000
90 DAY | 2012-04-21 09:31:54.340000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 847873d1698707300-conditional-formatting-of-referenced-cells-conditional-formatting-example-tms
Sheet: Sheet2

 |  | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | YTD
Item 1 |  |  | 100 | 65 | 12 | 98 | 100 | 65 | 12 | 12
Item 2 |  |  | 100 | 12 | 62 | 98 | 100 | 65 | 12 | 18
Item 3
 |  | 98 | 100 | 65 | 12 | 98 | 100 | 65 | 12 | 12
Item 2 |  | 100 | 100 | 12 | 62 | 98 | 100 | 65 | 12 | 18
Item 3
Spreadsheet: 133111d1324190952-find-and-copy-top-3-values-in-range-top-3-names-without-duplicates-by-dilipandey
Sheet: Sheet1

[NAME] | 1
[NAME] | 2
[NAME] | 3
[NAME] | 4
Julie | 5
[NAME] | 6
[NAME] | 7
[NAME] | 8
Will | 10
[NAME] | 10
Spreadsheet: 804042d1667853658-ref-error-ref-error-example
Sheet: Part 5

Part 5 | Usage
December | 20
January | 40
February | 20
March | 40
April | 20
May | 20
June | 20
July | 40
August | 40
September | 40
October | 40
November | 20
Spreadsheet: 711855d1609946473-cumulative-average-for-current-year-formula-ups2021
Sheet: Mar2021

UPS Shipping
 | STANDARD |  | OVERNIGHT
Date: | # [NAME] | $Cost$ | # [NAME] | $Cost$
2021-03-01 00:00:00
2021-03-02 00:00:00
2021-03-03 00:00:00
2021-03-04 00:00:00
2021-03-05 00:00:00
2021-03-06 00:00:00
2021-03-07 00:00:00
2021-03-08 00:00:00
2021-03-09 00:00:00
2021-03-10 00:00:00
2021-03-11 00:00:00
2021-03-12 00:00:00
2021-03-13 00:00:00
2021-03-14 00:00:00
2021-03-15 00:00:00
2021-03-16 00:00:00
2021-03-17 00:00:00
2021-03-18 00:00:00
2021-03-19 00:00:00
2021-03-20 00:00:00
2021-03-21 00:00:00
2021-03-22 00:00:00
2021-03-23 00:00:00
2021-03-24 00:00:00
2021-03-25 00:00:00
2021-03-26 00:00:00
2021-03-27 00:00:00
2021-03-28 00:00:00
2021-03-29 00:00:00
2021-03-30 00:00:00
2021-03-31 00:00:00
Totals:
Spreadsheet: 26279d1218330105-help-with-formula-book2
Sheet: Sheet2

NAME | SHIFT |  |  | HRS SCHED | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00 | 12:00:00 | 12:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00
[NAME] |  | - |  | 8 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: benjamin_rogers__1097__Ops Summary
Sheet: Sheet1

Plant |  | Starts |  | Run Hours
Brownsville |  | YTD (since 1/1/00) | Life to Date | YTD (since 1/1/00) | Life to Date
 | Unit 1 | 83 | 178 | 543.7 | 1100.9
 | Unit 2 | 77 | 151 | 457 | 917.8
 | Unit 3 | 77 | 174 | 348.8 | 819.3
 | Unit 4 | 81 | 166 | 376.2 | 933.2
 | Average/Unit
Caledonia
 | Unit 1 | 80 | 147 | 564.2 | 953
 | Unit 2 | 76 | 139 | 512.2 | 915
 | Unit 3 1 | 6 | 65 | 24.9 | 801.7
 | Unit 4 | 63 | 137 | 501.6 | 940.7
 | Unit 5 | 70 | 137 | 532.4 | 940.7
 | Unit 6 | 58 | 120 | 454.7 | 816.7
 | Average/Unit
[NAME]
 | Unit 1 | 44 | 44 | 179.5 | 179.5
 | Unit 2 | 40 | 40 | 247 | 247
 | Unit 3 | 55 | 55 | 276.4 | 276.4
 | Average/Unit
Lincoln Center
 | Unit 1 | 47 | 47 | 300.8 | 300.8
 | Unit 2 | 48 | 48 | 266.8 | 266.8
 | Unit 3 | 38 | 38 | 229.8 | 229.8
 | Unit 4 | 39 | 39 | 279 | 279
 | Unit 5 | 28 | 28 | 147.7 | 147.7
 | Unit 6 | 33 | 33 | 177.4 | 177.4
 | Unit 7 | 24 | 24 | 150 | 150
 | Unit 8 | 30 | 30 | 178.5 | 178.5
 | Average/Unit
New Albany
 | Unit 1 | 29 | 144 | 228.8 | 598.7
 | Unit 2 | 32 | 92 | 279.15 | 634.5
 | Unit 3 | 31 | 127 | 194.7 | 554.9
 | Unit 4 | 21 | 120 | 147 | 648.2
 | Unit 5 | 33 | 117 | 239.7 | 654.7
 | Unit 6 | 33 | 170 | 234.4 | 699.2
 | Average/Unit
Wheatland
 | Unit 1 | 46 | 46 | 97.8 | 97.8
 | Unit 2 | 44 | 44 | 116.9 | 116.9
 | Unit 3 | 34 | 34 | 132 | 132
 | Unit 4 | 24 | 24 | 60.5 | 60.5
 | Average/Unit
Notes:
1 | Caledonia unit 3 starts counter was reset during DCS Upgrade
Spreadsheet: 698782d1602173895-combining-formulas-indirect-and-lookup-and-vlookup-excel-indirect-lookup-v2
Sheet: App5

Date | Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7 | Data8 | Data9 | Data10
2020-10-05 00:00:00 | 6 | 3 | 4 | 4 | 3 | 5 | 5 | 3 | 3 | 4
2020-10-08 00:00:00 | 5 | 5 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 10
Spreadsheet: larry_campbell__20992__PCB Graphs
Sheet: 63.26A

Sample location |  |  | Date collected |  |  | PCB result (ppm) |  | Lab
PGE Mile pt. |  |  | 2000-06-21 00:00:00 |  |  | 27 |  | Sherwood
63.26 A Side |  |  | 2000-06-27 00:00:00 |  |  | 24 |  | Sherwood
 |  |  | 2000-07-05 00:00:00 |  |  | 20 |  | Sherwood
 |  |  | 2000-07-26 00:00:00 |  |  | 18 |  | Sherwood
 |  |  | 2000-08-23 00:00:00 |  |  | 16 |  | Sherwood
 |  |  | 2000-09-06 00:00:00 |  |  | 14 |  | Sherwood
 |  |  | 2000-10-04 00:00:00 |  |  | 15 |  | Sherwood
 |  |  | 2000-10-18 00:00:00 |  |  | 14 |  | Sherwood
 |  |  | 2000-11-08 00:00:00 |  |  | 18 |  | Sherwood
 |  |  | 2001-02-14 00:00:00 |  |  | 14 |  | Sherwood
 |  |  | 2001-03-14 00:00:00 |  |  | 10 |  | Sherwood
0 data values = ND or  less than a detection limit of 1ppm
Spreadsheet: 73056eef-f660-420b-aafa-667be57148bb
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2013-11-01 15:39:03.390000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.5 | 102.375 | 102.25 | 101.875 |  | and are added to price quote
4.625 | 101.937 | 101.812 | 101.687 | 101.312
4.5 | 101.782 | 101.657 | 101.532 | 101.157 |  | Note: | Refer To Price [NAME]
4.375 | 101.117 | 100.992 | 100.867 | 100.492 |  |  | For all Price Adjs
4.25 | 100.599 | 100.474 | 100.349 | 99.724
4.125 | 99.831 | 99.706 | 99.581 | 98.956
4 | 98.872 | 98.747 | 98.622 | 97.997
3.875 | 97.856 | 97.731 | 97.606 | 96.981
3.75 | 96.981 | 96.856 | 96.731 | 96.106 |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 102.214 | 102.089 | 101.964 | 101.589
3.625 | 101.808 | 101.683 | 101.558 | 101.183
3.5 | 101.294 | 101.169 | 101.044 | 100.669
3.375 | 100.541 | 100.416 | 100.291 | 99.916
3.25 | 99.817 | 99.692 | 99.567 | 98.942
3.125 | 99.1 | 98.975 | 98.85 | 98.225
3 | 98.35 | 98.225 | 98.1 | 97.475 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2013-11-15 15:39:03.390000
30 DAY | 2013-11-30 15:39:03.390000
45 DAY | 2013-12-15 15:39:03.390000
60 DAY | 2013-12-30 15:39:03.390000
90 DAY | 2014-01-29 15:39:03.390000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 692724d1598525263-multiple-spreadsheet-values-required-and-data-returned-over-48hrs-excel-forum
Sheet: 17.08.2020.

Emp No | Employee Name | Other Projects | Project Hours Total | Presence Hours | Absence Hours | Scheduled Hours
1 | [NAME] | Smith |  | 46.97 | 0 | 37
2 | [NAME] | Jones |  | 37 | 0 | 0
3 | Bobbi | [NAME] |  | 48 | 0 | 0
4 | [NAME] | Singh |  | 35.2 | 0 | 0
5 | [NAME] | [NAME] |  | 53 | 0 | 0
6 | Bertie | Davies |  | 47.5 | 0 | 0
7 | Obi | Stanley |  | 49.23 | 0 | 0
8 | Bobba | [NAME] |  | 39 | 0 | 0
9 | [NAME] | Bloggs |  | 56 | 0 | 0
Spreadsheet: phillip_m_love__30140__200005_OA
Sheet: Check

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - COMPREHENSIVE VARIANCE INTEGRITY CHECK
COMPANY:  ALL
REGION: ALL
PRODUCTION MONTH: 0005
Regions | Consolidated Flash | DPR vs. Consol. [NAME] | DPR | Adj. To NGPL | Revised NGPL | Actuals | [NAME]
Central
Sithe
Aruba
Mid Market
Northeast | 0 |  | 0 |  | 0 | 0
East-EGM
East-MKT East
East-LRC
FT-East
Texas-EGM
Texas-HPLR
Texas-HPLC
FT-SouthTexas
West
Denver
FT - Denver
Storage
Ontario
FT-Ontario
BUG
Total Per Indiv. Tabs
Per TOTAL Tab
 |  |  |  |  |  |  | 0
Spreadsheet: 56839d1256946395-linking-sheets-pipeline-template-weeks
Sheet: Week 1

Week | Name | Account | Amount | Status | L&G | Conquest | MC | Conquest | BHI | Conquest | Month | Active | Banked | Decline | Gone Off
1 | [NAME] | 9241332524 | 44000 | Active | 1 | 100 | One | 250 | BC | 340 | Jan | 1174 |  |  |  |  |  |  |  |  |  | ActiveJan | ActiveJan |  |  |  |  |  |  |  | ActiveJan
Spreadsheet: 851854d1701972565-need-help-converting-a-google-sheets-formula-to-excel-scheduling-test1
Sheet: VUTEK 3R's

T1 | 37.63 | Total hours |  |  |  |  | 2023-11-30 00:00:00 |  | 11:59:19
Time to Print | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due Date | Est. usage | PRESS | Notes
 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | 5-Pass | 2024-01-15 00:00:00 |  | VUTEK 3R's | For production quote- [NAME]
Spreadsheet: 54202644-0b76-4456-917b-88ae8ea24086
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0015931 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | The Village at the Point | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Iredell | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | D-1 |  | Field Name: |  | D-2 |  | Field Name: |  | D-3 |  | Field Name: |  | D-4
 |  |  |  |  |  | Area (acres): |  | 0.35 |  | Area (acres): |  | 0.35 |  | Area (acres): |  | 0.35 |  | Area (acres): |  | 0.35
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.12 |  | [NAME] (in): |  | 0.12 |  | [NAME] (in): |  | 0.12 |  | [NAME] (in): |  | 0.12
 |  |  |  |  |  | Annual Rate (in): |  | 52 |  | Annual Rate (in): |  | 52 |  | Annual Rate (in): |  | 52 |  | Annual Rate (in): |  | 52
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 853225d1703124110-array-reference-in-custom-formula-without-spilling-lambda-example
Sheet: Sheet1

Product type | Brand | [NAME] | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 |  | HISTORICAL CAGR
Ice Cream | [NAME] | Tio Lupe | 6652 |  |  |  |  | 0 | 0 | 0
Popsicle | Lime Storm | Bugsy Brands | 0 | 23
Popsicle | Blue-bearied | Mordor Inc | 528 |  |  |  |  |  |  | 0
Popsicle | Skarch | French Frances | 7785
Ice Cream | [NAME] | Bugsy Brands | 0 | 0 | 0 | 0 | 0
Ice Cream | Frankfurt Craze | French Frances | 0 | 0 | 898
=LAMBDA(a,IFERROR(RRI(COUNTIF(a,">0")-1,INDEX(a,[NAME],INDEX(a<>0,),0)),LOOKUP(2,1/(a<>0),a)),0))
just sp
 | <-----
Spreadsheet: 770525d1646140024-help-finding-qty-at-a-specific-date-on-inventory-burndown-plan-inventory-excess-example-ans
Sheet: Sheet1

Material | Inventory | Shop Deliveries | Total Inventory | Required Date | Required Qty | Allocation Window | Pegged Qty | Qty Remaining | Inventory
abc123 | 5 | 3 |  | 2022-02-28 00:00:00 | 2 | 2022-03-31 00:00:00
abc123 | 5 | 3 |  | 2022-04-15 00:00:00 | 6 | 2022-03-31 00:00:00 |  |  | 0
abc123 | 5 | 3 |  | 2022-05-31 00:00:00 | 3 | 2022-03-31 00:00:00 |  |  | 0
xyz345 | 9 | 2 | 21 | 2022-02-13 00:00:00 | 5 | 2022-03-31 00:00:00 |  |  | 0
xyz345 | 9 | 2 | 21 | 2022-02-14 00:00:00 | 2 | 2022-03-31 00:00:00 |  |  | 0
xyz345 | 9 | 2 | 21 | 2022-02-19 00:00:00 | 3 | 2022-03-31 00:00:00
xyz345 | 9 | 2 | 21 | 2022-04-30 00:00:00 | 2 | 2022-03-31 00:00:00 |  |  | 0
xyz345 | 9 | 2 | 21 | 2022-05-13 00:00:00 | 1 | 2022-03-31 00:00:00 |  |  | 0
qrs789 | 7 | 6 | 9 | 2022-02-27 00:00:00 | 3 | 2022-03-31 00:00:00 |  |  | 0
qrs789 | 7 | 6 | 9 | 2022-02-28 00:00:00 | 7 | 2022-03-31 00:00:00
qrs789 | 7 | 6 | 9 | 2022-04-01 00:00:00 | 5 | 2022-03-31 00:00:00
Spreadsheet: 886119d1736155575-sorting-data-from-a-dynamic-list-jeffcmusic-excel-help-tms
Sheet: Sheet1

Number of Stops | Road Name | Stops effected | Closure Type
 | data from 'stops list'  tab column E | data to 'text join' from 'stops list' column C | data from 'stop list' column H
 | EDGWARE WAY | 15758, 16105, 14702 | Publicity Only, Publicity & Hood
1 | EDGWAREBURY LANE (N AND S OF A41) | 15760 | Publicity Only
1 | GLOUCESTER PLACE | 29797 | Publicity & Hood
1 | STATION ROAD | 25118 | Publicity Only
EXAMPLE OF OUTCOME
Number of Stops | Road Name | Stops effected | Closure Type
1 | station road | 25118 | Publicity only
1 | edgwarebury lane | 15760 | Publicity only
1 | gloucester place | 29797 | publicity & hood
2 | [NAME] | 15758, 14702 | Publicity only
1 | [NAME] | 16105 | publicity & hood
Spreadsheet: phillip_m_love__30653__9903_OA
Sheet: BGC_FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
REGION: Boston Gas
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 5539729 | 6102564
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 11170675 | 22517317
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 16710404 | 28619881
 | Purchases:
6 |  | 3rd Party / Inter Enron | -3146663 | -2560765
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -13053354 | -25305233
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 316085 | 579242
 | Total Purchases: |  | -15883932 | -27286756
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 37747 | 0
15 |  | Cash In | 51682 | 102343
16 |  | Synthetic Storage | -60899 | -129782
 | Total Imbalances: |  | 28530 | -27439
 | Storage:
17 |  | Injection (Sales to Stg) | 13048 | 23225
18 |  | W/D (Purchase from Stg) | -868050 | -87524
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -868050 | -87524
 | Total Storage: |  | -855002 | -64299
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | 0 | 0
23 | Fuel: |  | -316085 | -579242
 | Transport Expense:
24 |  | Commodity | 0 | -474256
25 |  | Demand | 0 | -974389
 | Total Transport Expense: |  | 0 | -1448645
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | 0
31 |  | Prior Month Book Balance | 0 | 0
 |  | Total MTM Income | 0 | 0
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 149339
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 974389
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | -337772
 |  | TOTAL
Spreadsheet: john_griffith__15777__Daily Settles
Sheet: Sheet1

Today's Settles
$5 Swaption on CY 02 |  | 0
Cal 02 |  | 3.055
$6 Calls on Q1 02 |  | .025 @ .045 | 8 delta
$5.25 Calls on Cal 02 |  | .09 @ .11 | 15 delta
Jan 02 3.50 Calls |  | .21 @ .23 | 38 delta
Dec 01 $2.25 Puts (Gas Daily) |  | .12 @ .14 | -21 delta
Dec 01 $3.50 Calls (Gas Daily) |  | .15 @ .17 | 30 delta