tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 96192d1295611186-how-to-use-two-dependent-combo-boxes-to-display-prices-printing-prices
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Master | Price
 |  |  |  |  |  |  |  | 1 | White Paper 50 - 100 Copies Single Sided (Minimum Charge) - includes Master - Agency Paper |  |  |  |  |  |  |  | 0 | 1.75
 |  |  |  |  |  |  |  | 2 | White Paper 50 - 100 Copies Double Sided (Minimum Charge) - Includes Master - Agency Paper |  |  |  |  |  |  |  | 0 | 2.5
 |  |  |  |  |  |  |  | 3 | White Paper 100+ Copies Single Sided (Minimum Charge) - Agency Paper |  |  |  |  |  |  |  | 0.25 | 0.02
 |  |  |  |  |  |  |  | 4 | White Paper 100+ Copies Double Sided (Minimum Charge) - Agency Paper |  |  |  |  |  |  |  | 0.25 | 0.02
 |  |  |  |  |  |  |  | 5 | Coloured Paper 50 - 100 Copies Single Sided (Minimum Charge) - Includes Master - Agency Paper |  |  |  |  |  |  |  | 0 | 2.25
 |  |  |  |  |  |  |  | 6 | Coloured Paper 50 - 100 Copies Double Sided (Minimum Charge) - Includes Master - Agency Paper |  |  |  |  |  |  |  | 0 | 3
 |  |  |  |  |  |  |  | 7 | Coloured Paper 100+ Copies Single Sided (Minimum Charge) - Agency Paper |  |  |  |  |  |  |  | 0.25 | 0.02
 |  |  |  |  |  |  |  | 8 | Coloured Paper 100+ Copies Double Sided (Minimum Charge) - Agency Paper |  |  |  |  |  |  |  | 0.25 | 0.03
 |  |  |  |  |  |  |  | 9 | White Paper 50 - 100 Copies Single Sided (Minimum Charge) - includes Master - Own Paper |  |  |  |  |  |  |  | 0 | 0.75
 |  |  |  |  |  |  |  | 10 | White Paper 50 - 100 Copies Double Sided (Minimum Charge) - Includes Master - Own Paper |  |  |  |  |  |  |  | 0 | 1.5
 |  |  |  |  |  |  |  | 11 | White Paper 100+ Copies Single Sided (Minimum Charge) - Own Paper |  |  |  |  |  |  |  | 0.25 | 0.05
 |  |  |  |  |  |  |  | 12 | White Paper 100+ Copies Double Sided (Minimum Charge) - Own Paper |  |  |  |  |  |  |  | 0.25 | 0.01
 |  |  |  |  |  |  |  | 13 | Coloured Paper 50 - 100 Copies Single Sided (Minimum Charge) - Includes Master - Own Paper |  |  |  |  |  |  |  | 0 | 0.75
 |  |  |  |  |  |  |  | 14 | Coloured Paper 50 - 100 Copies Double Sided (Minimum Charge) - Includes Master - Own Paper |  |  |  |  |  |  |  | 0 | 1.5
 |  |  |  |  |  |  |  | 15 | Coloured Paper 100+ Copies Single Sided (Minimum Charge) - Own Paper |  |  |  |  |  |  |  | 0.25 | 0.01
 |  |  |  |  |  |  |  | 16 | Coloured Paper 100+ Copies Double Sided (Minimum Charge) - Own Paper |  |  |  |  |  |  |  | 0.25 | 0.01
 |  |  |  | Selection |  |  |  |  |  |  |  |  |  |  | Link Cell | 2 |  | Link Cell | 1
 |  |  |  |  |  |  |  |  | Agency Paper
 |  |  |  | Quantity |  |  |  |  | Own Paper
 |  |  |  | Total |  |  |  |  | Link Cell | 2
Spreadsheet: john_lavorato__16612__2002 Consol Plan Review Template
Sheet: EWS Power

 |  |  |  | Enron Wholesale Power
 |  |  |  | 2002 Plan Review
 |  | 2001 Forecast |  |  |  | 2002 Plan
 |  |  | Direct | Net |  |  | Direct | Net |  | 2001 Forecast |  | 2002 Plan |  | Fav/(Unfav)
Team |  | Margin | Expenses | Margin |  | Margin | Expenses | Margin |  | Headcount |  | Headcount |  | [NAME]
Options Desk |  | 0 | 0 |  |  | 0 | 0.7 |  |  | 0 |  | 5
Power Commodity East |  | 0 | 0 |  |  | 0 | 2.9 |  |  | 0 |  | 21
Power Commodity West |  | 0 | 0 |  |  | 0 | 1.1 |  |  | 0 |  | 8
Power Structuring East |  | 0 | 0 |  |  | 0 | 2.4 |  |  | 0 |  | 16
Power Structuring West |  | 0 | 0 |  |  | 0 | 0.5 |  |  | 0 |  | 4
Retail Gas Commodity |  | 0 | 0 |  |  | 0 | 6.5 |  |  | 0 |  | 42
Retail West |  | 0 | 0 |  |  | 0 | 3.4 |  |  | 0 |  | 23
Utility Risk Management East |  | 0 | 0 |  |  | 0 | 6.6 |  |  | 0 |  | 49
Utility Risk Management West |  | 0 | 0 |  |  | 0 | 1.8 |  |  | 0 |  | 11
Total EWS Power
Int Related Costs/Facility Costs
Prepays
Corp
Intercompany Billings
 | EBIT
 | Interest Expense
 | EBT
Spreadsheet: 887110d1737254583-generating-1-column-of-data-into-a-calendar-generating-1-column-of-data-into-a-calendar
Sheet: Sheet2

Treatment Plan Reviews pg2
Name | TPR | Provider | Case Manager | Admission Date (will highlight if less than 1 year) | [NAME](will highlight if less than 22) | Last TPR | TPR Due By              (will highlight if less than 30 days away or if date has passed) | NEXT Scheduled TPR day               (per calendar) | FUTURE Scheduled TPR day               (per calendar) | FUTURE Scheduled TPR day               (per calendar) | FUTURE Scheduled TPR day               (per calendar) | FUTURE Scheduled TPR day               (per calendar)
Black Widow | 90 | other data | other data | 2000-01-01 00:00:00 | 1980-01-01 00:00:00 | 2024-11-15 00:00:00 |  | 2025-02-04 00:00:00
Red Guardian | 90 | other data | other data | 2000-01-01 00:00:00 | 1960-01-01 00:00:00 | 2024-11-21 00:00:00 |  | 2025-02-11 00:00:00
Black Panther | 90 | other data | other data | 2000-01-01 00:00:00 | 1970-01-01 00:00:00 | 2024-12-05 00:00:00 |  | 2025-02-25 00:00:00
Spreadsheet: 800205d1665540969-trying-to-find-the-correct-formula-book1-mattd39-
Sheet: Source

Carrier | Public/Private | Renewal Date | Insured | Industry | Market [NAME] | US Traded | Limit | Insuring Clause | Retention | 2021 Premium | 2022 Premium | % Change
AIG | Public | 2022-09-08 00:00:00 |  | Aviation | 0 | No | 5000000 | ABC | 150000 |  | 44000
Travelers | Public | 2022-09-15 00:00:00 |  | Junior Mining | 53000000 | No | 5000000 | ABC | 25000 | 14500 | 14500
[NAME] | Private | 2022-09-28 00:00:00 |  | Junior Mining | 0 | No | 1000000 | ABC | 25000 | 2870 | 2870
Banyan | Public | 2022-09-29 00:00:00 |  | Junior Mining | 1100000000 | Yes | 2500000 | ABC | 2500000 | 325000 | 170588
AIG | Private | 2022-09-30 00:00:00 |  | Consumer Products | 0 | No | 10000000 | ABC | 500000 | 70500 | 87500
Banyan | Public | 2022-10-01 00:00:00 | [NAME] | Cannabis | 365000000 | Yes | 5000000 | A | 0 | 950000 | 650000
AIG | Public | 2022-10-03 00:00:00 |  | Junior Mining | 146000000 | No | 5000000 | ABC | 75000 | 30000 | 33500
AWAC | Public | 2022-11-23 00:00:00 |  | Tech | 66000000 | Yes | 5000000 | ABC | 5000000 | 1058000
Chubb | Public | 2022-12-05 00:00:00 |  | Operational Mining | 134000000 | No | 2000000 | ABC | 150000 | 30000
Spreadsheet: 118844d1314043805-copying-down-last-relevant-header-to-fill-all-cells-if-statement
Sheet: Sheet1

 |  | This is what I've got |  |  |  |  |  | This is where I need to get to
 |  | 11/12 Description 1 |  | Header |  |  |  | 11/12 Description 1 | 11/12 Description 1 |  | Header
 |  | 05/01/2011 - 25/01/2011 |  | Amount |  |  |  | 11/12 Description 1 | 05/01/2011 - 25/01/2011 |  | Amount
 |  |  |  | 0 |  |  |  | 11/12 Description 1 |  |  | 0
 |  |  |  |  |  |  |  | 11/12 Description 1
 |  |  |  | Node |  |  |  | 11/12 Description 1 |  |  | Node
 |  |  |  | 1234 |  |  |  | 11/12 Description 1 |  |  | 1234
 |  |  |  | 1234 |  |  |  | 11/12 Description 1 |  |  | 1234
 |  |  |  | 1234 |  |  |  | 11/12 Description 1 |  |  | 1234
 |  |  |  | 1234 |  |  |  | 11/12 Description 1 |  |  | 1234
 |  |  |  | 1234 |  |  |  | 11/12 Description 1 |  |  | 1234
 |  |  |  | 1234 |  |  |  | 11/12 Description 1 |  |  | 1234
 |  |  |  | Totals |  |  |  | 11/12 Description 1 |  |  | Totals
 |  |  |  |  |  |  |  | 11/12 Description 1
 |  | 11/12 Description 2 |  | Header |  |  |  | 11/12 Description 2 | 11/12 Description 2 |  | Header
 |  | 05/01/2011 - 25/01/2011 |  | Gate fees |  |  |  | 11/12 Description 2 | 05/01/2011 - 25/01/2011 |  | Gate fees
 |  |  |  | 0 |  |  |  | 11/12 Description 2 |  |  | 0
 |  |  |  |  |  |  |  | 11/12 Description 2
 |  |  |  | Node |  |  |  | 11/12 Description 2 |  |  | Node
 |  |  |  | 12345 |  |  |  | 11/12 Description 2 |  |  | 12345
 |  |  |  | 12345 |  |  |  | 11/12 Description 2 |  |  | 12345
 |  |  |  | 12345 |  |  |  | 11/12 Description 2 |  |  | 12345
 |  |  |  | 12345 |  |  |  | 11/12 Description 2 |  |  | 12345
 |  |  |  | 12345 |  |  |  | 11/12 Description 2 |  |  | 12345
 |  |  |  | 12345 |  |  |  | 11/12 Description 2 |  |  | 12345
 |  |  |  | 12345 |  |  |  | 11/12 Description 2 |  |  | 12345
 |  |  |  | Totals |  |  |  | 11/12 Description 2 |  |  | Totals
Spreadsheet: 715464d1611718272-need-help-correcting-an-accrual-formula-shareable-time-sheet
Sheet: Sheet1

TIMESHEET
EMPLOYEE'S NAME: |  |  |  |  |  |  |  | FOR THE PAY PERIOD: |  |  |  |  | to
EMPLOYEE'S SIGNATURE: |  |  |  |  |  |  |  | BATTALION CHIEF SIGNATURE:
 |  |  |  |  |  |  |  | CHIEF SIGNATURE:
DAY: | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | TOTAL
DATE: | 2021-01-02 00:00:00
 | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours
Regular Time (Hrs)
Overtime (Hrs)
Vacation (Hrs)
[NAME] (Hrs)
Holiday Pay (Hrs)
Total:
 |  |  |  |  |  | Disclaimer: Time-and-a-half is only paid after 106 total hours. Anything under 106 will be paid at straight time……….^^
=IF(SUMPRODUCT(--(DAY(B16:O16+1)=1)),DATE(), (B10:B16)-F27,{0;90;365;3650})-1)/2","0")
 |  |  |  |  | 2015-03-05 00:00:00 |  | Prior Balance |  | Used This Period |  | Added This Period |  | Total Remaining
 |  |  |  |  | Vacation (Days): |  |  | - |  | + |  | =
 |  |  |  |  | [NAME] (Days): |  |  | - |  | + |  | =
 |  |  |  |  | Comp Time (Days): |  |  | - | 0 | + | 0 | =
 | NOTES:
Spreadsheet: 707631d1607381754-calculate-median-by-certain-criteria-median-formula-bvj-
Sheet: Sheet1

Region | Month | Sales | North | south | east | west
East | 1 | 522 |  |  |  |  | manual change with growing list
East | 2 | 200 |  |  |  |  | dynamic for a growing list
East | 3 | 325
East | 4 | 400
East | 5 | 152
West | 1 | 654
West | 2 | 218
West | 3 | 365
West | 4 | 584
West | 5 | 459
South | 1 | 351
South | 2 | 742
South | 3 | 954
South | 4 | 825
South | 5 | 452
North | 1 | 100
North | 2 | 200
North | 3 | 300
North | 4 | 400
North | 5 | 500
Spreadsheet: 493205d1481575801-vlookup-for-a-date-in-a-certain-range-sample-data-for-oos
Sheet: Sheet1

Store | Date | Vendor | # of OOS | Over 5 OOS was it escalated? | Date Submitted |  | Store | Date | Vendor
1 | 2016-11-14 00:00:00 | Coke | 8 |  |  |  | 1 | 2016-11-22 00:00:00 | Coke
2 | 2016-11-15 00:00:00 | Pepsi | 6 |  |  |  | 2 | 2016-11-17 00:00:00 | Pepsi
3 | 2016-11-15 00:00:00 | Lays | 11 |  |  |  | 3 | 2016-12-10 00:00:00 | Lays
4 | 2016-11-15 00:00:00 | [NAME] | 10 |  |  |  | 4 | 2016-11-12 00:00:00 | [NAME]
5 | 2016-11-16 00:00:00 | Oreo | 8 |  |  |  | 5 | 2016-12-10 00:00:00 | Oreo
6 | 2016-11-16 00:00:00 | Smithfield | 6 |  |  |  | 6 | 2016-11-22 00:00:00 | Smithfield
7 | 2016-11-16 00:00:00 | [NAME] | 6 |  |  |  | 7 | 2016-11-09 00:00:00 | [NAME]
 |  |  |  |  |  |  | This is an entirly different table in the same workbook
Spreadsheet: 725343d1616632540-how-to-get-result-using-nested-if-with-5-multiple-conditions-nested-if-or-statement
Sheet: Sheet2

Legacy Case | Order Number | ERP | Case Number | Result
 | 10606 | E34560 | 650650 | Pending Case
 | 10306 |  | 102005 | Pending Case
 |  |  | 113606 | New Case
 |  | [NAME] | 123578 | Reassigned Case
1 | 10336 | 10003 | 105556 | Delegate case
1 |  | 10606 | 106060 | Delegate case
1 |  |  | 106060 | Delegate case
Spreadsheet: 840322d1692645381-formula-to-return-previous-month-balance-edate-not-working-sample-etaf-2
Sheet: Sheet1

Current Date | apr
Current Balance
Previous Month Balance
Month | Balance
2023-01-01 00:00:00 | 5000
2023-02-01 00:00:00 | 6000
2023-03-01 00:00:00 | 7000
2023-04-01 00:00:00 | 6000
2023-05-01 00:00:00 | 8000
2023-06-01 00:00:00 | 10000
2023-07-01 00:00:00 | 11000
2023-08-01 00:00:00 | 9000
2023-09-01 00:00:00 | 8000
2023-10-01 00:00:00
2023-11-01 00:00:00
2023-12-01 00:00:00 | 1
Spreadsheet: 522304d1496958052-real-estate-tiered-commission-calculator-commision-calculator
Sheet: Sales

 |  |  |  |  |  |  |  |  |  | Gross Sales | Broker Rate | [NAME]
 |  |  |  |  |  |  |  |  |  | 0 | 0.3 | 0.7
 |  |  |  |  |  |  |  |  |  | 2000000 | 0.1 | 0.9
 |  |  |  |  |  |  |  |  |  | 99000000 | 0.1 | 0.9
Date | Client | Address | Price | YTD Sales | Commision Rate | Commission Amount | Broker Commission | Realtor Commission
 |  |  |  |  | 0.03
2016 Totals
2017-06-16 00:00:00 |  |  | 473500 |  | 0.03
 |  |  | 1526500 |  | 0.03
 |  |  |  |  | 0.03
 |  |  |  |  | 0.03
 |  |  |  |  | 0.03
2017 Totals
Spreadsheet: 118714d1313944672-too-many-nested-if-statements-nested-if-statements
Sheet: Sheet1

Spin | Bet1 | Bet2 | Bet3 | Bet4 | Bet5 | Bet6 | Bet7 | Bet8 | Bet9 | Bet10 | Bet11 | [NAME] | Bet13 | Bet14 | Bet15 | Bet16 | Bet17 | Bet18 | Bet19 | Bet20 | Bet | Ttl Loss | Min Gain | PayOut | Gain1 | Gain2 | Gain3 | Gain4 | Gain5 | Gain6 | Gain7 | Gain8 | Gain9 | [NAME] | Gain11 | Gain12 | [NAME] | [NAME] | Gain15 | Gain16 | Gain17 | [NAME] | Gain19 | Gain20 | Gain
1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 3 |  | 54
Spreadsheet: 135179d1325860112-excel-2007-formatting-match-performance-tracker
Sheet: AR Shortcomings

 | Season
X | Area/Match | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
A | Offside Judgements (active/passive)
B | Support & Assistance to the Referee
C | Alertness and Awearness
D | Signals
E | Fitness and Positioning
Spreadsheet: 803754d1667664490-need-an-alternative-to-vlookup-that-returns-all-values-found-livro1-aligw
Sheet: Folha1

 |  |  |  | Expected result |  |  |  | AliGW
 |  |  |  | A | 1/4/5/10
 |  |  |  | B | 2
 |  |  |  | C | 3
 |  |  |  | D | 6
 |  |  |  | E | 7
 |  |  |  | F | 8/9
Spreadsheet: 4c7b0c1d-a9d9-41f1-8242-384fb7a1824d
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
PFGE | Test | PFGE | Bacterial Typing by Pulsed-Field Gel Electrophoresis (PFGE) | Bacterial Typing | Pulsed-Field Gel Electrophoresis of DNA Fragments | [NAME], sterile centrifuge tubes: ScwStlTb |  |  |  | Varies | Container/Tube: Agar slant [NAME] Isolates on separate agar slants Collection Instructions:  1. Individually bag each pulsed-field gel electrophoresis (PFGE) specimen, then place all PFGE specimens (all patients and/or sites to be compared) together in a large bag, and send in the same shipping container. This is necessary for comparison of isolates by this method.  2. Label specimen as an etiologic agent. Additional Information: 1. Specimen source and organism identification are required. 2. Each slant must be submitted under a separate order. 3. Original isolates should be saved at the client site if additional PFGE testing may be needed. 4. See Infectious Specimen Shipping Guidelines in Special Instructions for shipping information. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | Reported as isolates from these sources are "indistinguishable" or "different" by pulsed-field gel electrophoresis. Results will be faxed to the client. | Monday through Friday; Continuously | 5 days | 13 days (Testing may take longer if a large number of isolates are  submitted) | 1 | 87152 |  |  |  |  | Rochester
PFGE | [NAME] | VARIES | Varies |  |  |  | Ambient
PFGE | Order Question | Q00M0047 | [NAME]) and Organism Identification (Required) |  | Plain Text
PFGE | Result | PFGE | Bacterial Typing | Bacterial Typing | Alphanumeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 0833fc44-50ca-48e2-83c3-8532a8dacdcd
Sheet: Sheet1

(Please Enter Company Name)
Instructions/Definitions:
Goal - Big, related to overall outcome.
Objectives - Narrow, the steps to reaching the goal.  Space has been provided for four objectives.  Add additional if needed by copying and pasting the format from and updating the numbered objective.
Deliverable - This would be the tangible products in line with meeting your objectives.  For example: attendance sheet stats showing a 5 then 10% increase would be 2 separate deliverables.  There may be more than one deliverable per objective.  Please skip a line  between deliverables.
Action Steps - List the steps you need to take in order to produce the deliverable.  There may be more than one action step per deliverable.  Please skip a line between each one.
Responsible Party and Contact Information - List the primary person responsible per deliverable and/or action step with contact information.
Participating Partners - Use this space to show the relationship of your partners' supportive services to you project activities and meeting your goal.
Target Date - Please provide the targeted date of each action step and/or deliverable.
Status -  If approved for funding this section will be used to indicate the status of your action steps and/or deliverables.
Notes - Please provide any additional information you feel would clarify your activities.
Goal:
Objective 1:
Deliverable | Action Step | Responsible Person | Contact Info | Participating Partners | Target Date | Status | Notes
Objective 2:
Deliverable | Action Step | Responsible Person | Contact Info | Participating Partners | Target Date | Status | Notes
Objective 3:
Deliverable | Action Step | Responsible Person | Contact Info | Participating Partners | Target Date | Status | Notes
Objective 4:
Deliverable | Action Step | Responsible Person | Contact Info | Participating Partners | Target Date | Status | Notes
Spreadsheet: vkaminski__40666__SimResults
Sheet: Read Me

 |  |  | Summer Cal PX Simulation Results
Description of Workbook
The attached plots (Charts 1-5) show the results of a simulation of California Power Exchange hourly volumes and
 | unconstrained market clearing prices (UMCP's).  The data employed are from the periods July-September,
 | 1998 and 1999.  Due to notably low volumes and concern about the anomolous start up period for the CPX,
 | the first 4 days of July, 1998 were omitted from the sample.  Otherwise, historic hourly data are taken from
 | 5X16 periods, exclusive of NERC holidays, for the days stated.  Total sample size was 124 days by 16 hours.
Probabilistic models generated simulated loads and, from them, simulated prices.  The architecture of the calculation is such
 | that intra-day relationships as well as overall price and load distributions were captured.  In particular, the average
 | prices of the 4 super peak hours, hours 15-18, and the remainder of the hourly prices are comparable as well
 | (chart not included).  The simulation has two major parts.  The first contains a methodology for emulating
 | the distribution and hourly serial correlations of loads in this market.  The second is a separate set of methods
 | for genereating prices probabilistically from load inputs.  This latter half can be used to calculate price distributions
 | from the base case loads, from scenarios developed from that history or from stand-alone load scenarios.
Simulated data reported are from a 2000 day by 16 hour run.  That size is small compared to the variability in the model, but
 | adequate for discussion purposes.  A larger simulation of 50,000+/- days is required for appying the model.
 | The 2,000 day run takes less than 30 seconds computational time.  The larger runs can be accomplished in
 | 15 minutes.  The calculations were accomplished on a 450 MHz, PIII personal computer.  Raw data sets
 | create files too large for e-mailing, but are available for inspection.
[NAME]
Chart 1:  a comparison of the historic and simulated hourly load distributions.  [NAME] size = 1000MW's
Chart 2:  a similar comparison of hourly prices (please note changing [NAME] size at higher values).
Charts 3 and 4: the 16-hour daily price data sets were sorted by average daily price for HLH, then divided into and averaged
 | across 10 ten-percentile slices.  This allows comparison of the intra-day shape of historic and simulated prices.
 | Recall that each slice in the history chart contains each hour's average across 12 or 13 days, whereas the simulation
 | slices average across 200 days for each hour.
Chart 5:  Price-duration curve comparison for historic and simulated hourly prices.
Spreadsheet: 64499d1265331823-import-content-from-separate-excel-files-to-a-single-spreadsheet-result
Sheet: Sheet1

File1.xls | Worksheet: 日本語
ToImport | ToImport | ToImport | ToImport
ToImport | ToImport | ToImport | ToImport
ToImport | ToImport | ToImport | ToImport
ToImport | ToImport | ToImport | ToImport
ToImport | ToImport | ToImport | ToImport
ToImport | ToImport | ToImport | ToImport
ToImport | ToImport | ToImport | ToImport
ToImport | ToImport | ToImport | ToImport
ToImport | ToImport | ToImport | ToImport
ToImport | ToImport | ToImport | ToImport
File1.xls | Worksheet: English
ToImport | ToImport | ToImport | ToImport
ToImport | ToImport | ToImport | ToImport
ToImport | ToImport | ToImport | ToImport
ToImport | ToImport | ToImport | ToImport
ToImport | ToImport | ToImport | ToImport
ToImport | ToImport | ToImport | ToImport
ToImport | ToImport | ToImport | ToImport
ToImport | ToImport | ToImport | ToImport
ToImport | ToImport | ToImport | ToImport
ToImport | ToImport | ToImport | ToImport
Spreadsheet: 106077d1303309781-pull-from-list-based-on-multiple-criteria-sample
Sheet: Criteria Table

Criteria | Ga. | Density | Size 1 | [NAME] | weight per ft
Stainless Max Dimension up thru 24" | 12 | 4.531 | 2x2x1/4 | 2x2x1/4 | 3.19
Stainless Max Dimension 25" thru 36" | 12 | 4.531 | 2x2x1/4 | 2x2x1/4 | 3.19
Stainless Max Dimension 37" thru 48" | 12 | 4.531 | 3x3x1/4 | 3x3x1/4 | 4.9
Stainless Max Dimension 49" thru 60" | 10 | 5.781 | 4x4x1/4 | 4x4x1/4 | 6.6
Stainless Max Dimension 61" thru 80" | 12 | 4.531 | 2x2x1/4 | 2x2x1/4 | 3.19
Galv. [NAME] up thru 24" | 12 | 4.531 | 2x2x1/4 | 2x2x1/4 | 3.19
Galv. [NAME] 25" thru 36" | 12 | 4.531 | 2x2x1/4 | 2x2x1/4 | 3.19
Galv. [NAME] 37" thru 48" | 12 | 4.531 | 3x3x1/4 | 3x3x1/4 | 4.9
Galv. [NAME] 49" thru 60" | 10 | 5.781 | 4x4x1/4 | 4x4x1/4 | 6.6
Galv. [NAME] 61" thru 80" | 16 | 2.656 | 2x2x1/4 | 2x2x1/4 | 3.19
Spreadsheet: 167881d1342130582-output-cell-address-of-value-in-left-hand-cell-no-macros-program-for-duplicates-10-ef119_duplicates
Sheet: Sheet1

name | cell address | dup_1 | dup_2 | dup_3 | dup_4 | dup_5
[NAME] | A2,A3 | 2 | 3
[NAME]
[NAME] | A4,A6,A7 | 4 | 6 | 7
Jake | A5 | 5
[NAME]
[NAME]
Spreadsheet: 342836d1409696050-event-calendar-with-recurring-event-140902_-calendar-of-events-2014-_-test
Sheet: Event Calendar - JUN 15

 |  |  |  | EVENT CALENDAR
 |  |  |  |  |  | ENTER MONTH: | June
 |  |  |  |  |  | ENTER YEAR: | 2015
 |  |  |  |  |  | ENTER START DAY: | Sunday
 | TO EVENT LIST >>