Rank: 3612 based on 27 downloads (last 30 days) and 5 files submitted
photo

Gunnar Aronsen

E-mail
Company/University
Trønder Energi Kraft AS
Lat/Long
63.42901, 10.392797

Personal Profile:

Senior Power analyst within Trønder Energi Kraft AS. Main responsibilities are optimization of our production, which is mainly hydropower. Also working with topics like bidding in physical powermarked, pricing of assets, and in general energymarked analysis.


 

Watch this Author's files

 

Files Posted by Gunnar Aronsen View all
Updated   File Tags Downloads
(last 30 days)
Comments Rating
14 Sep 2012 Write data to Excel Write matrix to Excel-file, and leave the files open. File written to is not saved. Author: Gunnar Aronsen excel, xlswrite, openfile, dataexport 10 2
23 Feb 2012 DST-function Find hours in anyday, and correction term on order to correct to normalized time. Author: Gunnar Aronsen daylight saving time, dst, hours in day 5 2
13 Sep 2011 Excel column header Take column number as input argument, and return Excel columheaders as letters. Author: Gunnar Aronsen excel, columnheaders 3 2
  • 4.0
4.0 | 1 rating
13 Sep 2011 Excel column number Convert Excel column header to colum number. Author: Gunnar Aronsen excel, column number 5 0
03 May 2011 Weeknumber Calculate ISO-weeknumber Author: Gunnar Aronsen isoweek, weeknumber, number of weeks, week based on date 4 2
  • 1.0
1.0 | 2 ratings
Comments and Ratings by Gunnar Aronsen View all
Updated File Comments Rating
06 Jun 2012 DST-function Find hours in anyday, and correction term on order to correct to normalized time. Author: Gunnar Aronsen

If you give in a date and set correction = 0 then you get the number of hours in that day. On the day when adjusting the clock forward it will give 23 as output and 25 when we adjust the clock backward.

I correction = 1 and you give in a vector of datevalues that also contain hour informastion, then you will get -1 during the hours which is part of what we call summertime in Norway. This vector can you then subtract from the time value given in, and then you get all timevalues are in normalized time. The last functionality is ment to be used when working towards databases which operate in normalized time, that is not taking into account daylight saving time.

04 May 2012 Write data to Excel Write matrix to Excel-file, and leave the files open. File written to is not saved. Author: Gunnar Aronsen

New version of the file is uploaded, errors are fixed.

18 Oct 2011 Excel column header Take column number as input argument, and return Excel columheaders as letters. Author: Gunnar Aronsen

Usually I write mye files in Norwegian, and when posting them I do som quick translation. Inndata was the variable name in Norwegian, which should be input, as you have corrected it to.

04 May 2011 Weeknumber Calculate ISO-weeknumber Author: Gunnar Aronsen

Correct information is that the m-file contains a function, that calculate week number, and corresponding year. I have done a checks for weeks around new-years from 1980 to 2020 without finding any errors.

Comments and Ratings on Gunnar Aronsen's Files View all
Updated File Comment by Comments Rating
20 Jul 2012 Weeknumber Calculate ISO-weeknumber Author: Gunnar Aronsen Fabrice

Bugs in the code.
fg

06 Jun 2012 DST-function Find hours in anyday, and correction term on order to correct to normalized time. Author: Gunnar Aronsen Gunnar Aronsen

If you give in a date and set correction = 0 then you get the number of hours in that day. On the day when adjusting the clock forward it will give 23 as output and 25 when we adjust the clock backward.

I correction = 1 and you give in a vector of datevalues that also contain hour informastion, then you will get -1 during the hours which is part of what we call summertime in Norway. This vector can you then subtract from the time value given in, and then you get all timevalues are in normalized time. The last functionality is ment to be used when working towards databases which operate in normalized time, that is not taking into account daylight saving time.

05 Jun 2012 DST-function Find hours in anyday, and correction term on order to correct to normalized time. Author: Gunnar Aronsen David Goldsmith

Hi, Gunnar. Perhaps it's a language thing, but I find your description very obscure--could you please provide some examples of what it does? Thanks!

04 May 2012 Write data to Excel Write matrix to Excel-file, and leave the files open. File written to is not saved. Author: Gunnar Aronsen Gunnar Aronsen

New version of the file is uploaded, errors are fixed.

02 May 2012 Write data to Excel Write matrix to Excel-file, and leave the files open. File written to is not saved. Author: Gunnar Aronsen Joseph

I get the following error

??? Error using ==> eq
Matrix dimensions must agree.

Error in ==> w2excel at 26
if aktivtark.codename == w2sheet

Error in ==> test_w2excel at 3
w2excel('Book1','Sheet1','B2',c');

Contact us