Results 1 to 52 of 52

Determining electric purchase and self consumption

Threaded View

  1. #1
    Registered User
    Join Date
    11-29-2021
    Location
    England
    MS-Off Ver
    2012
    Posts
    26

    Determining electric purchase and self consumption

    Hey Guys I have a problem with an excel task

    Can somebody tell me what I should do with the task 4 ?
    Open the "SLP load profile - household H0". You will find a 15-minute load profile in
    Active power KW before. When importing the opening, make sure that you do not use the "comma" as a
    Select separation option, otherwise the values ​​will not be imported correctly.
    2. Insert a new column between B and C, this will now have the name C.
    3. Click in the third row of the new column and add the date and time
    together approximately = sum (A3 + B3). Now you will see a point number in the program
    represents a point in time.
    4. Now format the cell in a format that gives you the date and time
    displays at the same time. The result looks like this for one cell (01/01/2011 00:15)
    5. Click the cell (here C3). Now move your pointer to the lower right corner
    the cell. A thick point will appear there. Double click on this point.
    Now the previously inserted formula should have been copied to the cells below.
    Check to see if this has happened. There are around 35,000 lines.

    The problem is I cant post an image what I have done lol
    Has somebody an idea ?
    Last edited by Mason12; 12-20-2021 at 05:09 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. western electric rules output match value vba
    By Step01 in forum Excel General
    Replies: 2
    Last Post: 05-21-2018, 03:03 AM
  2. Power Dispatcher for a Electric Utility
    By PDMuzak in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 12-21-2015, 01:00 PM
  3. Replies: 1
    Last Post: 12-21-2015, 12:51 PM
  4. Excel 2008 Gas n Electric bills
    By chaserchaser in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-07-2014, 02:53 PM
  5. [SOLVED] calculating electric charges
    By djnosnow in forum Excel General
    Replies: 3
    Last Post: 04-02-2014, 04:13 AM
  6. [SOLVED] Calculate electric costs
    By Creature in forum Excel General
    Replies: 8
    Last Post: 06-01-2012, 09:57 AM
  7. Replies: 12
    Last Post: 10-05-2011, 08:19 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1