tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 858266d1706990629-convert-yahoo-finance-date-ormat-to-the-russian-format-yyyy-mm-dd-russian-format
Sheet: Sheet1

S&P 500 (^GSPC)
Link below
https://finance.yahoo.com/quote/%5EGSPC/history?p=%5EGSPC
I need to reformat the Yahoo Finance format in Column A   to the Russian Format in Column B   yyyy.mm.dd
Date
Yahoo Finance Format | [NAME]yyyy.mm.dd
Jan 31, 2024 | 2024.01.31
Jan 30, 2024 | 2024.01.30
Jan 29, 2024 | 2024.01.29
Jan 26, 2024 | 2024.01.26
Jan 25, 2024 | 2024.01.25
Jan 24, 2024 | 2024.01.24
Jan 23, 2024 | 2024.01.23
Jan 22, 2024 | 2024.01.22
Feb 02, 2024 | 2024.02.01
Feb 01, 2024 | 2024.02.02
Hoping you can oblige     thank you in advance
Derek
I have deleted othe Columns of price data to make it clearer
Spreadsheet: 33118d1229408339-auto-summarise-summary-list
Sheet: Sheet1

 |  |  | Sunmary
 |  |  | Account | Value
 |  |  | 1000 | 109
 |  |  | 1001 | 116
 |  |  | 1003 | 33
 |  |  | 1005 | 118
 |  |  | 1006 | 222
 |  |  | 1007 | 172
Generate this summary |  |  | 1008 | 25
list from the detail below |  |  | 1010 | 77
 |  |  | 1012 | 60
 |  |  | 1015 | 60
 |  |  | 1016 | 67
 |  |  | 1017 | 97
 |  |  | 1019 | 36
 |  |  | 1020 | 31
 |  |  |  | 1223
 |  |  | [NAME]
 |  |  | Account | Value
 |  |  | 1012 | 60
 |  |  | 1016 | 35
 |  |  | 1017 | 38
 |  |  | 1008 | 25
 |  |  | 1017 | 59
 |  |  | 1007 | 60
 |  |  | 1000 | 38
 |  |  | 1010 | 36
 |  |  | 1006 | 19
 |  |  | 1016 | 16
 |  |  | 1006 | 33
 |  |  | 1006 | 33
 |  |  | 1015 | 30
 |  |  | 1005 | 59
 |  |  | 1001 | 58
 |  |  | 1007 | 56
 |  |  | 1006 | 19
 |  |  | 1016 | 16
 |  |  | 1006 | 33
 |  |  | 1006 | 33
 |  |  | 1015 | 30
 |  |  | 1005 | 59
 |  |  | 1001 | 58
 |  |  | 1007 | 56
 |  |  | 1000 | 29
 |  |  | 1019 | 36
 |  |  | 1020 | 31
 |  |  | 1010 | 16
 |  |  | 1006 | 52
 |  |  | 1003 | 33
 |  |  | 1010 | 25
 |  |  | 1000 | 42
 |  |  |  | 1223
Spreadsheet: 769398d1645525141-combine-if-function-and-sum-countif-indirect-testing2-1-
Sheet: Sheet1

NAME | DATE | Day Type |  | Holidays |  | NAME | NORMAL DAYS | WEEKEND DAYS | Holidays
RAMI | 2022-01-03 00:00:00 |  |  | 2022-01-03 00:00:00 |  | RAMI |  |  |  |  | RAMI | 2022-01-01 00:00:00
RAMI | 2022-01-08 00:00:00 |  |  | 2022-01-05 00:00:00 |  | NASSIM |  |  |  |  | NASSIM | 2022-01-02 00:00:00
[NAME] | 2022-01-02 00:00:00 |  |  | 2022-01-08 00:00:00 |  | FARID |  |  |  |  | FARID | 2022-01-03 00:00:00
[NAME] | 2022-01-07 00:00:00 |  |  |  |  | KARIM |  |  |  |  | KARIM | 2022-01-04 00:00:00
 |  |  |  |  |  | KHALED |  |  |  |  | KHALED | 2022-01-05 00:00:00
 |  |  |  |  |  | NIHAL |  |  |  |  | NIHAL | 2022-01-06 00:00:00
 |  |  |  |  |  | DJAMAL |  |  |  |  | DJAMAL | 2022-01-07 00:00:00
 |  |  |  |  |  | ALI |  |  |  |  | ALI | 2022-01-08 00:00:00
 |  |  |  |  |  | [NAME] |  |  |  |  | [NAME] | 2022-01-09 00:00:00
Spreadsheet: 478241d1472696964-attendance-sheet-how-to-best-summarise-data-attendance-sheet-how-to-best-summarise-data
Sheet: Sheet1

Date | Time | ID | Name | Check In/Check Out | Hours worked |  |  |  |  |  |  | ID | NAME
2016-08-28 00:00:00 | 20:00:00 | 15000 |  |  |  |  |  |  | The formula in E4 filled down is =IF(D2="","",IF(MOD(COUNTIF(D$2:D2,D2)-1,2),"Out","In")) |  |  | 13997 | [NAME]
2016-08-28 00:00:00 | 21:00:00 | 15000 |  |  |  |  |  |  |  |  |  | 15000 | [NAME]
2016-08-28 00:00:00 | 11:00:00 | 16000 |  |  |  |  |  |  |  |  |  | 16000 | [NAME]
2016-08-28 00:00:00 | 12:00:00 | 16000
2016-08-29 00:00:00 | 08:00:00 | 13997
2016-08-29 00:00:00 | 09:00:00 | 13997
2016-08-29 00:00:00 | 19:00:00 | 15000
2016-08-29 00:00:00 | 20:00:00 | 15000
2016-08-29 00:00:00 | 10:00:00 | 16000
2016-08-29 00:00:00 | 11:00:00 | 16000 |  |  |  |  |  |  |  |  |  | Summary
2016-08-30 00:00:00 | 08:00:00 | 13997 |  |  |  |  |  |  |  |  |  | 14:19:00 | 19:20:00
2016-08-30 00:00:00 | 09:00:00 | 13997
2016-08-30 00:00:00 | 19:00:00 | 15000
2016-08-30 00:00:00 | 20:00:00 | 15000
2016-08-30 00:00:00 | 10:00:00 | 16000
2016-08-30 00:00:00 | 11:00:00 | 16000
2016-08-31 00:00:00 | 12:00:00 | 13997
2016-08-31 00:00:00 | 14:00:00 | 13997
2016-08-31 00:00:00 | 20:00:00 | 15000
2016-08-31 00:00:00 | 21:00:00 | 15000
2016-08-31 00:00:00 | 11:00:00 | 16000
2016-08-31 00:00:00 | 12:00:00 | 16000
2016-09-01 00:00:00 | 06:30:00 | 13997
2016-09-01 00:00:00 | 07:00:00 | 16000
2016-09-01 00:00:00 | 07:30:00 | 15000
2016-09-01 00:00:00 | 14:00:00 | 16000
2016-09-01 00:00:00 | 15:30:00 | 13997
2016-09-01 00:00:00 | 16:20:00 | 15000
Spreadsheet: 847799d1698669223-highlighting-entire-rows-based-on-column-data-sample-202-aligw
Sheet: Sheet1

 | Starting | [NAME] Out |  |  |  |  |  |  |  |  |  |  |  | Ending
 | Balance | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Balance
Apples | 50 | 10 |  |  | 20 |  | 5 |  | 7
Oranges | 50 |  | 10 |  |  |  |  | 14
Bananas | 50 |  |  | 10
Kiwis | 50 |  |  |  | 10 |  | 10 |  | 20 |  | 5 | 5 |  |  | this entire row needs to be red bold text
Papayas | 50
Lemons | 50 |  |  | 12 |  |  | 10 |  |  |  | 4
Limes | 50 |  |  |  |  | 30 |  | 10 |  | 5
Spreadsheet: 770215d1645895114-need-help-solving-this-sumif-scenario-updated_sampledata_excelhelp
Sheet: Sheet3

Type | TK1 | TK2 | TK3 | TK4 | RESULT WANTED
NB | OUT | COMP | PEND | COMP | 60 |  | 0+30+20+10
DP | PEND | PEND | COMP | OUT | 65 |  | 10+15+40
RG | COMP | COMP | COMP | COMP | 100 |  | 20+30+40+10
AP | OUT | OUT | OUT | OUT
ZZ | PEND | COMP | COMP | OUT
CP | COMP | OUT | COMP | PEND
 | TK1 | TK2 | TK3 | TK4
 | OUT=0 | OUT=0 | OUT=0 | OUT=0
 | PEND=10 | PEND=15 | PEND=20 | PEND=5
 | COMP=20 | COMP=30 | COMP=40 | COMP=10
 | IF BLANK = 0 | IF BLANK = 0 | IF BLANK = 0 | IF BLANK = 0
WEIGHTED VALUE FOR TASK | 20 | 30 | 40 | 10 | EQUALS 100%
Spreadsheet: eric_saibi__9957__110801R
Sheet: Indian River 03

Owner Name |  | NRG Energy Inc.
Station Name |  | Indian River Power Station
Unit Name |  | Indian River 03
NERC Region |  | MAAC
State |  | DE
Fuel Type |  | Coal
Capacity |  | 177 MW
Start Date |  | 2001-08-02 00:00:00
End Date |  | 2001-12-08 00:00:00
Prv. Start Date |  | 2001-08-02 00:00:00
Prv. End Date |  | 2001-11-11 00:00:00
Comments |  | Turb, rotor problem. Expect to be offline for another month.
SIC |  | 4931
Plant ID |  | 1515051
Unit ID |  | 1008234
Outage ID |  | 17979
Spreadsheet: 216495d1361791741-possibly-an-if-then-formula-required-if-then-ans
Sheet: Sheet1

Table 1 |  |  |  |  |  | Table 2 |  |  |  |  |  | Table 3
A1 | B2 | [NAME] | D4 | E5 | WEEK 1 | F1 | G2 | H3 | I4 | J5 | WEEK 2 | K1 | L2 | M3 | N4 | O5 | WEEK 3
A2 | B3 | C4 | D5 | E6 | WEEK 2 | F2 | G3 | H4 | I5 | J6 | WEEK 3 | K2 | L3 | M4 | N5 | O6 | WEEK 1
A3 | B4 | C5 | D6 | E7 | WEEK 3 | F3 | G4 | H5 | I6 | J7 | WEEK 1 | K3 | [NAME] | M5 | [NAME] | O7 | WEEK 1
A4 | B5 | C6 | D7 | E8 | WEEK 1 | F4 | G5 | H6 | I7 | J8 | WEEK 1 | K4 | L5 | M6 | N7 | O8 | WEEK 2
A5 | B6 | C7 | D8 | E9 | WEEK 3 | F5 | G6 | H7 | I8 | J9 | WEEK 2 | K5 | L6 | M7 | N8 | O9 | WEEK 3
 |  |  |  |  |  | F6 | G7 | H8 | I9 | J10 | WEEK 3 | K6 | L7 | M8 | N9 | O10 | WEEK 2
Spreadsheet: 716f273e-7c07-463b-9be2-9fa942bf31ed
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | 80688708320 | [NAME] | Already There | 2007-09-11 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688649128 | [NAME] | With His Love (Sing Holy) | 2005-11-08 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688649029 | [NAME] | Gentle Savior | 2005-11-08 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688646424 | [NAME] | The Name Lives On | 2005-11-08 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688646325 | [NAME] | Behold The Lamb | 2005-11-08 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688646226 | [NAME] | Life Is A Church | 2005-11-08 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Spreadsheet: 764076d1642570756-arrange-letters-in-alpha-mode-incell_sort
Sheet: Sheet1

AAADLTA
AAEDLTA
AAIDLTA
AAODLTA
AAUDLTA
Spreadsheet: 4b5c030b-d36e-44d1-b728-6fda5b50f928
Sheet: Sheet1

Judgeship Number 6 (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 11/28/2014 2:22:26 AM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
County | [NAME] | TOTALS
[NAME] | 56811 | 56811
Steele | 848 | 848
Traill | 3411 | 3411
TOTAL | 61070 | 61070
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 133506d1324428239-conditional-charting-conditional-chart
Sheet: Data

Read Date | LCL | UCL | Average | Units Used
2010-11-15 00:00:00 | 30 | 90 |  | 35
2010-10-13 00:00:00 | 30 | 90 |  | 66
2010-09-16 00:00:00 | 30 | 90 |  | 48
2010-08-13 00:00:00 | 30 | 90 |  | 76
2010-07-14 00:00:00 | 30 | 90 |  | 89
2010-06-14 00:00:00 | 30 | 90 |  | 33
2010-05-15 00:00:00 | 30 | 90 |  | 77
2010-04-15 00:00:00 | 30 | 90 |  | 68
2010-03-16 00:00:00 | 30 | 90 |  | 52
2010-02-12 00:00:00 | 30 | 90 |  | 76
2010-01-15 00:00:00 | 30 | 90 |  | 61
2009-12-14 00:00:00 | 30 | 90 |  | 60
2009-11-12 00:00:00 | 30 | 90 |  | 73
2009-10-14 00:00:00 | 30 | 90 |  | 39
2009-09-15 00:00:00 | 30 | 90 |  | 46
Spreadsheet: eric_saibi__9772__012802
Sheet: Sutter 03 ST

Owner Name | Calpine Corporation
Station Name | Sutter Power
Unit Name | Unit 03 ST
NERC Region | WSCC
State | CA
Fuel Type | Natural Gas
Capacity | 200 MW
Start Date | 2002-01-28 00:00:00
End Date | 2002-02-01 00:00:00
Comments | Design Issues with Turbine
SIC | 4931
Plant ID | 1032188
Unit ID | 1012175
Outage ID | 19676
Spreadsheet: 273858d1382941855-help-plz-on-my-shipping-cost-calculator-boss-deadline-shipping-cost-calculator
Sheet: By Air Courier 1 - 20kg

 | FREIGHT COST BY AIR  From SIDOARJO By Courier
 | Destination | 1 kg | 5 kg | 20 kg
 | INDIA | 77.83 | 75.49 | 36.38
 | UAE | 99.4 | 96.41 | 46.28
 | FRANCE | 88.74 | 86.07 | 41.62
 | BANGKOK | 35.67 | 34.59 | 16.61
 | FREIGHT COST BY AIR From JAKARTA By Courier
 | Destination | 1 kg | 5 kg | 20 kg
 | INDIA | 65.5 | 63.54 | 30.46
 | UAE | 113.27 | 109.88 | 52.62
 | FRANCE | 86.61 | 84.05 | 40.28
 | BANGKOK | 35.94 | 34.85 | 15.24
Spreadsheet: 803586d1667560645-forecast-constrained-by-stock-availability-constrained-forecast-calc-example
Sheet: Sheet1

SKU | Base Weekly Sales | [NAME] (Units - unconstrained by stock availability) |  |  |  |  |  |  |  |  | Opening Stock on Hand (Units) | Closing Stock on Hand Forecast (Units) |  |  |  |  |  | [NAME] (Units - Constrained by Stock Availability) WHAT I'D LIKE TO BE ABLE TO SHOW |  |  |  |  |  |  |  |  | Order ETA Month | Notes
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Jan | Jan | Feb | Mar | Apr | May | Jun | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep
Option 1 | 7 |  |  |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May | No constraint in Jan as SOH >0; Feb = 50% of FC because Feb/Mar/Apr SOH <0 (3 forward months); Mar = 70% of FC because [NAME]/Apr<0 (2 forward months); Apr = 90% of FC as Apr SOH <0 (1 forward month) and stock is due in May (Order ETA Month).  No sales constraints after May because Order ETA Month is May.
Option 2 | 4 |  |  |  |  |  |  |  |  |  | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jun | Sales constraint only for May because order ETA is [NAME] and only May has SOH <0.  No sales constraints after [NAME] [NAME] is Jun.
Option 3 | 2 |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb | No sales constraint because Order ETA is Feb
# Months Out of Stock | % of Unconstrained Forecast to apply
0 | 1
1 | 0.9
2 | 0.7
3 | 0.5
4+ | 0
Monthly Sales Profile
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep
Option 1 | 1.1 | 1.3 | 1.2 | 1.5 | 1.8 | 2 | 1.2 | 1.5 | 1.8
Option 2 | 1.1 | 1.2 | 1.2 | 1.4 | 1.6 | 1.8 | 1.2 | 1.4 | 1.6
Option 3 | 0.9 | 1.1 | 1.2 | 1.1 | 1.1 | 0.9 | 1.2 | 1.1 | 1.1
Spreadsheet: 82464d1282554084-excel-2007-form-and-prepopulating-data-workstreams-ap
Sheet: Form

Prefix | Activity
Based Upon
Children's Centre Activity Name
Provider (tick one only)
Name of Project Leader
Location (Name of Centre)
Frequency
Theme (tick one only)
Access Groups (tick one only)
Outcome Type (tick one only)
Home Visit
Start Time
Duration (Minutes)
Capacity
PLEASE INDICATE LOCAL PERFORMANCE INDICATORS (LPI)/NATIONAL INDICATORS (NI) TO WHICH THIS ACTIVITY DIRECTLY CONTRIBUTES (please tick more than one box if applicable)
ü | LPI No. | LOCAL PERFORMANCE INDICATOR
 | LPI 1a | Increase in the number of 0-4 years (inc) registered with CC
 | LPI 1b | Increase % of 0-4 year olds accessing CC Services
 | LPI 1c | Increase % of Lone Parents accessing services
 | LPI 1d | Increase % of BME accessing CC services
 | LPI 1e | Increase % of teenage parents accessing CC services
 | LPI 1f | Increase in registered unemployed parents/carers attending training that has the potential of leading to employment (Impacts on  NI 116 Proportion of children in poverty)
 | NI 116
 | LPI1f (ii) | Increase in the % of those unemployed parents/carers completing training that has a potential of leading to employment (Impacts on  NI 116 Proportion of children in poverty)
 | NI 116
 | LPI 1g | % of those registered teenage parents that are NEETS that are engaged in training activities by the CC (Impacts on  NI 116 Proportion of children in poverty)
 | NI 116
 | [NAME] (i) | Increase in the number of fathers registered with this CC
 | LPI1h(ii) | Increase in the % of fathers registered with CC attending activities.
 | [NAME] (i) | Increase the % accessing CC services with special needs or disabilities.
 | LPI 3 | % of parental engagement in the delivery of CC services
 | LPI 3a | Making a Positive Contribution “Having a Say and Participate in Decision Making” (Consultation 0-4 yrs)
 | LPI4a (i) | Increase in number of pregnant mothers who are supported with advice and guidance through a referral to smoking cessation – Reduction in mothers who smoke during pregnancy.
 | LPI4a(ii) | % increase in mothers stopping smoking during pregnancy
 | LPI 5 | Reduction in inequalities in emergency admissions aged 0-4 years for gastro-enteritis, lower respiratory infection and severe injury (Impacts on  NI 70 – Hospital admissions caused by unintentional and deliberate injuries to children and young people [NAME])
 | NI70
 | LPI5a) | Reduction in inequalities in emergency admissions aged 0-4 years for gastro-enteritis, lower respiratory infection and severe injury (Impacts on  NI70 –  Hospital admissions caused by unintentional and deliberate injuries to children and young people [NAME])
 | NI70
 | NI 72 | Achievement of at least 78 points across the Early Years Foundation Stage with at least 6 in each of the scales in Personal Social and Emotional Development and Communication
 | NI 53 | Prevalence of breastfeeding at 6 – 8 weeks from birth
 | NI 55 | Obesity among primary school age children in Reception Year
 | NI 118 | Take up of formal childcare by low income families
Spreadsheet: 753088d1635241572-index-match-with-multiple-criteria-incl-wildcard-and-greater-than-a-value-test-index-match-problem
Sheet: Feuil1

Date | Time | Description | No of trays
2021-06-07 00:00:00 | 12:00:16 | Verrines | 28 |  | Criteria
2021-06-07 00:00:00 | 12:05:16 | Verrines | 32 |  | 1 | DATE | 2021-06-08 00:00:00
2021-06-07 00:00:00 | 12:10:16 | Verrines | 4 |  | 2 | FORMAT | GN 1/3*
2021-06-07 00:00:00 | 12:15:16 | GN 1/3 SLOW | 0 |  | 3 | NO OF TRAYS | >0
2021-06-08 00:00:00 | 12:20:16 | GN 1/3 SLOW | 6
2021-06-08 00:00:00 | 12:25:16 | GN 1/3 QUICK | 0
2021-06-08 00:00:00 | 12:30:16 | GN 1/3 QUICK | 0 |  | Formula 1 | TIME
2021-06-09 00:00:00 | 12:30:37 | Print manual | 0 |  | Formula 2 | TIME
2021-06-09 00:00:00 | 12:35:16 | GN 1/3 SLOW | 3
Spreadsheet: 841129d1693384822-how-to-calculate-networkdays-intl-excel-form-leave-record
Sheet: 2023 HK Statutory Holiday

Every Sunday | Date | Sunday
The day following the first day of January | 2023-01-02 00:00:00 | Monday
The second day of Lunar New Year | 2023-01-23 00:00:00 | Monday
The third day of Lunar New Year | 2023-01-24 00:00:00 | Tuesday
The fourth day of Lunar New Year | 2023-01-25 00:00:00 | Wednesday
Ching Ming Festival | 2023-04-05 00:00:00 | Wednesday
Good Friday | 2023-04-07 00:00:00 | Friday
The day following Good Friday | 2023-04-08 00:00:00 | Saturday
Easter Monday | 2023-04-10 00:00:00 | Monday
Labour Day | 2023-05-01 00:00:00 | Monday
The Birthday of the Buddha | 2023-05-26 00:00:00 | Friday
Tuen Ng Festival | 2023-06-22 00:00:00 | Thursday
Hong Kong Special Administrative Region Establishment Day | 2023-07-01 00:00:00 | Saturday
The day following the Chinese Mid-Autumn Festival | 2023-09-30 00:00:00 | Saturday
The day following National Day | 2023-10-02 00:00:00 | Monday
Chung Yeung Festival | 2023-10-23 00:00:00 | Monday
Christmas Day | 2023-12-25 00:00:00 | Monday
The first weekday after Christmas Day | 2023-12-26 00:00:00 | Tuesday
Spreadsheet: 99858d1298403281-calculating-fuel-economy-from-a-list-of-purchases-samplefile
Sheet: purchases

Vehicle Number | Transaction Date: | [NAME] | Gallons purchased
100 | 2011-01-10 00:00:00 | 85000 | 27.2
103 | 2011-01-10 00:00:00 | 92000 | 24
104 | 2011-01-10 00:00:00 | 64000 | 26.1
101 | 2011-01-11 00:00:00 | 71000 | 25.8
102 | 2011-01-11 00:00:00 | 83000 | 18.7
100 | 2011-01-12 00:00:00 | 85300 | 21.4
104 | 2011-01-12 00:00:00 | 64250 | 28
103 | 2011-01-13 00:00:00 | 92325 | 23.4
101 | 2011-01-13 00:00:00 | 71200 | 26
104 | 2011-01-13 00:00:00 | 64480 | 27.1
103 | 2011-01-14 00:00:00 | 92525 | 23
100 | 2011-01-14 00:00:00 | 85500 | 28.4
101 | 2011-01-14 00:00:00 | 71450 | 22.1
102 | 2011-01-14 00:00:00 | 83280 | 19
Spreadsheet: dan_hyvl__4816__Sempra Solutions_ENA
Sheet: AMASTPSA 

MASTER FIRM PURCHASE/SALE AGREEMENT INFORMATION SHEET
ENA Entity: | ENA | ATTORNEY:
DATE: | 2001-06-05 00:00:00 | ENA CONTACT:
COUNTERPARTY: | Sempra Energy Solutions, LLC | CONTACT: | [NAME]
ADDRESS: |  | TITLE:
 |  | PHONE: | [PHONE]
 |  | FAX: | [EMAIL]
INCORPORATION STATE: |  | S&P RATING: | n/a
STRUCTURE | COUNTERPARTY | ENA ENTITY
COLLATERAL
THRESHOLD  in $ | $10MM | $20MM
COMMITTED VOLUMES
THRESHOLD in $[NAME] | N/A | N/A
COLLATERAL REQUIRED FOR:
ALL TRADES
OTHER | N/A | N/A
COLLATERAL TYPE
Letter of Credit | OK | OK
COLLATERAL  MULTIPLE | 250000 | 250000
GUARANTOR (RATING) | Sempra Energy (A) ** | Enron Corp. (BBB+)
LIMIT in $[NAME] | $15MM | $25MM
Incorporation State: | CA | OR
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty
-Guarantor | X | X
Debt Ratings Change | X | X
-Below = | BBB-/Baa3 | BBB-/Baa3 | S&P/Moody's
Financial Covenants
-Funded Debt/Net Worth
-Minimum Net worth
-Cash Flow/CMLTD
-Current Ratio
Non-Specific
-Unilateral
Ownership Change
-Less than 51% owned by:
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
EVENTS OF DEFAULT
3rd party debt
-Counterparty
-Guarantor ($[NAME]) | $50MM | $100MM
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | YES: | NO:
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
OTHER COMMENTS
** A guaranty from Sempra has been issued for this counterparty for $5MM.  This guaranty should be
terminated and replaced by a new guaranty from Sempra tied to this contract.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x5-7095
Spreadsheet: 88274d1288137265-database-functionality-database-question
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | 100
 | ORIGINAL DATABASE |  |  |  |  |  |  |  |  | Database for Retail # 100 |  |  |  |  |  | Database for Retail #  250
 |  |  |  |  |  |  |  |  |  | 100 |  |  |  |  |  | 250
 | Retail Number | Name | School | Street |  |  |  |  |  | Retail Number | Name | School | Street |  |  | Retail Number | Name | School | Street
 | 250 | [NAME] | USC | Main | 1-250 |  |  |  |  | 100 | [NAME] | SC | Fairview |  |  | 250 | [NAME] | USC | Main
 | 100 | [NAME] | SC | Fairview | 1-100 |  |  |  |  | 100 | [NAME] | AU | Sterling |  |  | 250 | [NAME] | UGA | Jameston
 | 250 | [NAME] | UGA | Jameston | 2-250 |  |  |  |  | 100 | Erin | Org | Queens |  |  | 250 | [NAME] | Mich | Selwyn
 | 100 | [NAME] | AU | Sterling | 2-100 |  |  |  |  | 100 | [NAME] | TN | Devine
 | 250 | [NAME] | Mich | Selwyn | 3-250
 | 100 | Erin | Org | Queens | 3-100
 | 356 | Nick | TX | Kings | 1-356
 | 100 | [NAME] | TN | Devine | 4-100
 |  |  |  |  |  |  |  |  |  | I want to take the Original Database and create new worksheets to break out all Retail #100 and Retail #200 along with the relevent attributes.  I was trying to use a vlookup with a match functionality but I am getting repeating values as I go down the rows
 |  |  |  |  |  |  |  |  |  | Retail Number | Name | School | Street
 |  |  |  |  |  |  |  |  |  | 100 | [NAME] | SC | Fairview
 |  |  |  |  |  |  |  |  |  | 100 | [NAME] | SC | Fairview
 |  |  |  |  |  |  |  |  |  | 100 | [NAME] | SC | Fairview
 |  |  |  |  |  |  |  |  |  | 100 | [NAME] | SC | Fairview
Spreadsheet: 120744d1315494824-projected-component-change-outs-budget
Sheet: 5202

5202 |  |  |  | Current Hours |  | Year
 |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
 |  |  |  |  |  | 744 | 696 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 744 | 672 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 2160 | 2184 | 2208 | 2208 | 2160 | 2184 | 2208 | 2208 | 2184 | 2184 | 2208 | 2208
 |  |  |  |  | Projected 2011 End | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th
Projected Future Hours
Spreadsheet: 142821d1330020390-excel-2007-creating-a-usable-work-sheet-for-orders-cabinet-order-form-final
Sheet: Sheet1

Citywide Cabinetry - Order Sheet |  |  |  |  |  |  |  | Job Name ___________________________
(440) 235-3631 |  | 25271 Sprague Rd Columbia Station 44028 |  |  |  |  |  | Phone # _____________________________
Cabinet Styles
 | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | Bristol Chocolate |  |  | Hickory
 | [NAME] |  |  | Tuscany Rope |  |  | [NAME] |  |  | Arlington White |  |  | [NAME]
Base Cabinets |  |  |  |  |  |  | Upper Cabinets
Size |  | Retail |  | Your Price |  |  | Size |  |  | Retail | Your Price
 |  | 0 |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  | 0
Trim/ Molding |  |  |  |  | Total |  | Trim/ Molding |  |  |  |  | Total
 |  | 0 |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  | Total |  |  |  |  |  |  | Total
Customer Signature
X_________________________________________________ |  |  |  |  |  |  | Date  _______________ |  |  |  | Discounter |  | Total Cost
Management |  |  |  |  |  |  |  |  |  |  | 0.45
X_________________________________________________ |  |  |  |  |  |  | Date  _______________