tag:blogger.com,1999:blog-57043680834969309062024-03-04T20:38:00.765-08:00David Møller Hansens blogmollerhansenhttp://www.blogger.com/profile/16885120984919315092noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-5704368083496930906.post-13343725896259787232013-02-03T09:15:00.000-08:002013-02-03T09:17:07.078-08:00Excel: Bubble Chart Macro<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJ5FgqPWcAK3h8SXe0cE3K8-GhE2I1-25sn0IZ2mOrvUSfs3SRPdgyQm81vXQ8p-ZRorwkEzHYkhNqdoSJlEwzdA9yJUyBA1_lRyCCQsPglorGNSs9QB65fyoiNj7_tl_TBd99E6uciDQs/s1600/Bubble-Bubble.png" imageanchor="1" style="margin-left:1em; margin-right:1em"><img border="0" height="213" width="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJ5FgqPWcAK3h8SXe0cE3K8-GhE2I1-25sn0IZ2mOrvUSfs3SRPdgyQm81vXQ8p-ZRorwkEzHYkhNqdoSJlEwzdA9yJUyBA1_lRyCCQsPglorGNSs9QB65fyoiNj7_tl_TBd99E6uciDQs/s320/Bubble-Bubble.png" /></a></div>
Apparently the only way to lable XY chart objects sensibly in MS Excel is by writing a macro. Also the only way to create a Bubble chart without loosing your marbles is also by writing a macro. So I wrote the following macro based on <a href="http://blogs.msdn.com/b/tomholl/archive/2011/03/28/creating-multi-series-bubble-charts-in-excel.aspx" target="_blank">Tom Hollander's blog post</a>.<br />
<br />
<textarea name="textarea" cols="70" rows="40" wrap="VIRTUAL">
'The following routine assumes that you have a 5 column data selection with a header column
'Column 5 defines the color category by setting the color value c based on the cell value of column 5
Public Sub CreateMultiSeriesBubbleChart()
If (Selection.Columns.Count <> 5 Or Selection.Rows.Count < 3) Then
MsgBox "Selection must have 5 columns and at least 2 rows"
Exit Sub
End If
Dim bubbleChart As ChartObject
Set bubbleChart = ActiveSheet.ChartObjects.Add(Left:=Selection.Left, Width:=600, Top:=Selection.Top, Height:=400)
bubbleChart.Chart.ChartType = xlBubble
Dim r As Integer
For r = 2 To Selection.Rows.Count
Dim c
If Selection.Cells(r, 5).Value = "red" Then
c = RGB(100, 0, 0)
ElseIf Selection.Cells(r, 5).Value = "green" Then
c = RGB(0, 100, 0)
Else
c = RGB(0, 0, 100)
End If
With bubbleChart.Chart.SeriesCollection.NewSeries
.Name = "=" & Selection.Cells(r, 1).Address(External:=True)
.XValues = Selection.Cells(r, 2).Address(External:=True)
.Values = Selection.Cells(r, 3).Address(External:=True)
.BubbleSizes = Selection.Cells(r, 4).Address(External:=True)
.Interior.Color = c
.ApplyDataLabels
.DataLabels.ShowSeriesName = True
.DataLabels.ShowValue = False
.DataLabels.Position = xlLabelPositionCenter
End With
Next
bubbleChart.Chart.SetElement (msoElementPrimaryCategoryAxisTitleAdjacentToAxis)
bubbleChart.Chart.Axes(xlCategory, xlPrimary).AxisTitle.Text = "=" & Selection.Cells(1, 2).Address(External:=True)
bubbleChart.Chart.SetElement (msoElementPrimaryValueAxisTitleRotated)
bubbleChart.Chart.Axes(xlValue, xlPrimary).AxisTitle.Text = "=" & Selection.Cells(1, 3).Address(External:=True)
bubbleChart.Chart.SetElement (msoElementPrimaryCategoryGridLinesMajor)
bubbleChart.Chart.Axes(xlCategory).MinimumScale = 0
End Sub
</textarea>mollerhansenhttp://www.blogger.com/profile/16885120984919315092noreply@blogger.com0tag:blogger.com,1999:blog-5704368083496930906.post-39913116276437708492013-01-06T13:49:00.001-08:002013-01-06T13:53:34.711-08:00Reading List: Ghost in the Wires<div class="separator" style="clear: both; text-align: none;"> </div>
<div class="separator" style="clear: both; text-align: center;"><a href="http://creeva.com/wp-content/uploads/2012/08/ghostinthewires.jpeg" target="_blank" style="margin-left: 1em; margin-right: 1em;"><img src="http://creeva.com/wp-content/uploads/2012/08/ghostinthewires.jpeg" id="blogsy-1357509207836.8892" class="aligncenter" alt="" width="360" height="360"></a></div>
This is a late post. I actually read this book last summer. Now a New Year resolution is forcing me to do a quick post on my thoughts. <br/><br/>The book starts of slow and I'm most of the time looking forward to the end, since I loosely know the chase story to be told. But as I continue through the chapters I quickly eat up the next one. This book is well written and an easy read. The author is good at channeling the excitement Mitnick describes during his social engineering hacks. <br/><br/>I've never stolen or swindled anyone in my life and sitting next to Mitnick while he is narrating how he does it really gets the adrenaline running. Thanks for a great read and an exciting story!<br/><br/> <br/><br/><div style="text-align: right; font-size: small; clear: both;" id="blogsy_footer"><a href="http://blogsyapp.com" target="_blank"><img src="http://blogsyapp.com/images/blogsy_footer_icon.png" alt="Posted with Blogsy" style="vertical-align: middle; margin-right: 5px;" width="20" height="20" />Posted with Blogsy</a></div>mollerhansenhttp://www.blogger.com/profile/16885120984919315092noreply@blogger.com0tag:blogger.com,1999:blog-5704368083496930906.post-86004279200662045682012-02-19T03:05:00.000-08:002012-02-19T07:16:03.599-08:00Reading List: Steve Jobs<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhmuKUhcgZIkC4xmB2d02ZnwpeKSOPZhKzMKIsHSGXVBGRdVRGRi7CEAlaS8gtPnOPYUMRkLeAo3OZfizVFn3u9WBcYrakd3ZBnkwBmEmRH8Mrrx6o_AEHyym78ARst2pSM-Iky-3iV5CW/s1600/steve_jobs_biography_walter_isaacson.jpg" imageanchor="1" style="margin-left:1em; margin-right:1em"><img border="0" height="316" width="228" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhmuKUhcgZIkC4xmB2d02ZnwpeKSOPZhKzMKIsHSGXVBGRdVRGRi7CEAlaS8gtPnOPYUMRkLeAo3OZfizVFn3u9WBcYrakd3ZBnkwBmEmRH8Mrrx6o_AEHyym78ARst2pSM-Iky-3iV5CW/s320/steve_jobs_biography_walter_isaacson.jpg" /></a></div>
Steve Jobs the currently most read bio written by Walter Isaacson. Nicely written history piece, you're getting a real close up of Jobs and you get a feeling of the reality distortion field just from reading the book.
An interesting critical review of the book on Daring Fireball: <a href="http://daringfireball.net/2012/02/walter_isaacson_steve_jobs"></a>mollerhansenhttp://www.blogger.com/profile/16885120984919315092noreply@blogger.com0tag:blogger.com,1999:blog-5704368083496930906.post-89477287174990660482012-01-09T12:32:00.001-08:002012-02-19T02:58:16.297-08:00Reading List: The Fallible Fiend<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRCzh2RYJEDdMpGAhEzQn4cNsXovuxr00yY7JzPh41L6TDONKm5xPyRv5aFFp7Q76mu1i71LklpNJNZyBVx-yDN5ceLfNIlycqfJESKM7qOuSI_0Py5c7STVmGOReL2qN2SBL8bPq493mK/s1600/images.jpeg" imageanchor="1" style="margin-left:1em; margin-right:1em"><img border="0" height="225" width="225" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRCzh2RYJEDdMpGAhEzQn4cNsXovuxr00yY7JzPh41L6TDONKm5xPyRv5aFFp7Q76mu1i71LklpNJNZyBVx-yDN5ceLfNIlycqfJESKM7qOuSI_0Py5c7STVmGOReL2qN2SBL8bPq493mK/s320/images.jpeg" /></a></div>
The Fallible Fiend by L. Sprague de Camp is a good humoristic Terry Pratchet style book. Filled with beurocracy and logic from his own world, our hero the Demon Zdim, is summoned to the prime plane. The story is quickly pased and with some action. Good witty light read.mollerhansenhttp://www.blogger.com/profile/16885120984919315092noreply@blogger.com0tag:blogger.com,1999:blog-5704368083496930906.post-40557440612259247892011-06-25T03:04:00.001-07:002011-06-25T03:07:52.131-07:00Jailbreaking Apple TV and installing Plex<p>The reason for jailbreaking devices is as always to open the device up for functionality which is possible but made unavailable. Application installation on the Apple TV is interesting from a Plex home cinema setup point of view. The apple TV has great premises to be a great Plex Client.</p><p><center><a href="http://osxdaily.com/wp-content/uploads/2011/01/apple-tv-2.jpg" target="_blank"><img src="http://osxdaily.com/wp-content/uploads/2011/01/apple-tv-2.jpg" id="blogsy-1308996353063.2266" class="aligncenter" alt="" width="487" height="236"></a></center></p><p>So this morning I tried to jailbreak my Apple TV. First of all you need to find a micro USB - USB. Impossible to buy in CPH, so better hope you know someone who owns a device using micro USB. </p><p><center><a href="http://cultofmac.cultofmaccom.netdna-cdn.com/wordpress/wp-content/uploads/2011/02/Seas0npass.png" target="_blank"><img src="http://cultofmac.cultofmaccom.netdna-cdn.com/wordpress/wp-content/uploads/2011/02/Seas0npass.png" id="blogsy-1308996353030.4111" class="alignright" alt="" width="50%"></a></center></p><p>I updated to the iOS to version 4.3 and started on the Seas0nPass jailbreak. I hit the following issues:</p><ul><br/><br/><li>Unzipping IPSW image hanged. Apparently the IPSW file server did not deliver the full file. Just tried to re-download until got the full file. </li><br/><br/><li>creating the ramdisk hanged. Seemed that there was an old virtual windows .bundle file in libraryplugins.. That just needed to be deleted. Machine needed to be rebooted. </li><br/><br/></ul><p>After jail breaking I just had to go to the Plex forum where there is posted a great guide to install a Plex client on the apple tv using the Terminal.</p><p><center><a href="http://www.androiduknewsetc.com/wp-content/uploads/2011/02/plex-logo-2.jpg" target="_blank"><img src="http://www.androiduknewsetc.com/wp-content/uploads/2011/02/plex-logo-2.jpg" id="blogsy-1308996353034.0142" class="aligncenter" alt="" width="240" height="187"></a></center></p>mollerhansenhttp://www.blogger.com/profile/16885120984919315092noreply@blogger.com1tag:blogger.com,1999:blog-5704368083496930906.post-69482199419628885032011-05-15T03:16:00.000-07:002011-05-15T05:21:39.378-07:00Reading list: InfernoJust finished reading Inferno by Larry Niven & Jerry Pournelle. <br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6siTg9q8EckDuaMjLREOTTD4ECPbgkGipNl5YBfqONJ-cip_Ljxmy2pVzdx_pxL8-90AYnA44YH02KeLuYVYNw0-NtGfpXvrUoM5uZSdwW9684oeg76Ord1H4Y7YaZd99q-t9ewNRvNwX/s1600/Inferno.jpg" imageanchor="1" style="clear:left; float:left;margin-right:1em; margin-bottom:1em"><img border="0" height="320" width="197" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6siTg9q8EckDuaMjLREOTTD4ECPbgkGipNl5YBfqONJ-cip_Ljxmy2pVzdx_pxL8-90AYnA44YH02KeLuYVYNw0-NtGfpXvrUoM5uZSdwW9684oeg76Ord1H4Y7YaZd99q-t9ewNRvNwX/s320/Inferno.jpg" /></a></div><br />
The book is about a sci-fi novelist who gets drunk on the side off a skyscraper and falls off the side as he hurls. The fall kills him and he wakes up in Hell where he is guided through Dante's vision of Hell. <br />
<br />
The book paints the torments in Dante's circles very well and in a modern light where the main character the sci-fi writer tries to rationalise everything from the 1600 italian vision of Hell. <br />
<br />
Good entertaining and fast read.mollerhansenhttp://www.blogger.com/profile/16885120984919315092noreply@blogger.com1tag:blogger.com,1999:blog-5704368083496930906.post-11800878907551454012011-05-08T13:27:00.001-07:002011-05-08T13:27:35.386-07:00IPad magazines<p>I've veen playing around with The iPad for a week now and I have tried to get an overview of which good iPad magazines are available. </p>
<p>I should start by defining 'good': </p>
<p>Let's get it out the way, price. If you're going to charge per issue then I don't want to pay more than 2€ per magazine. You have an infinite space (almost) so get some adds in there. I am used to adds in magazines. News papers creating iPad apps should be either low fee subscription based or totally free, 2€ each day is way too heavy. </p>
<p>Content, do not do not move to a new media if you can't keep up to the previous standard. </p>
<p>Media, feel free to use the new media for user comments. For extra user driven exploration and so on, but do not make it a challenge to read the magazine. </p>
<p>What have I been looking at? Danish newspapers, American magazines, mashup magazines and advertisement collections. </p>
<p>Danish newspaper Ekstrabladet actually have an interesting (at first) model. The first week is free while after <br>This it follows the model from the rest of the Danish newspapers. 2€ or using your regular subscription number. Price is to high, unless it is an incentive for me to buy a cheaper iPad only subscription. We will have to see when I will be offered that. At least not now and therefore I don't read newspapers on the iPad (sadly). <br> <br>American tech magazines Wired and Project. Wired is 3€ while the iPad only magazine is only 2€, hey, they got it! Content wise they are much the same, Wired seem to be deeper but they also have a much larger group behind them. I am very impressed with Project doing such a great job at a lower prize point. Well almost a good job, both Wired and Project are still exploring the new media and some times me the user takes the hit. I literally have found places in Project where I can't guet to the next article without going to the navigation menu. Common guys, a magazine where you can't turn the page... Not to good. But I expect to see them do a better and better job. I buy both magazines when they come out. </p>
<p>Mashup magazines. I am currently using Zite and Hitpad, and I love them! Free apps that collects interesting articles and creates a magazine which is constantly changing along time as new stuff is published online. This is the future of magazines. I am looking forward to see the impact on edited magazines from these mashup mags. </p>
<p>The last type of mashup mag I want to mention is a Danish app eTilbudsAvisen collecting the current paper commercials from store websites and makes them Searchable! This is awesome, I can search for offers based on radius from my current position and plan my purchases. I just miss integration with some grocery list web service. </p>
<p>The tablet is here and paper is dying, finally!<br></p>
mollerhansenhttp://www.blogger.com/profile/16885120984919315092noreply@blogger.com3tag:blogger.com,1999:blog-5704368083496930906.post-59805283741943144282011-05-01T10:10:00.001-07:002011-06-25T03:11:12.119-07:00Bishops Arms in Copenhagen<p>We welcome you swedes. Especially when you bring beer and especially when most of it isn't from Sweden :-) Just joking - some swedish beers are superb, while at least also one of your bars is great!</p><p><center><a href="http://www.ussmullinnix.org/2007_Restaurants_GothenburgSweden1.jpg" target="_blank"><img src="http://www.ussmullinnix.org/2007_Restaurants_GothenburgSweden1.jpg" id="blogsy-1308996655076.4907" class="aligncenter" width="235" height="256" alt=""></a></center></p><p>The swedish beer bar venue chain Bishop Arms opened there first venue in Denmark in the beginning of April. I visited a couple of weeks ago and here's my verdict. </p><p class=""><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7JuckG0or5p-qyexCU9Xy4Vq6nbOGDbShZA5kw_o2GwtsFdHXXqVNGKWUKf4Vw8yPFP3jfIHxSom15q-RNQDRp_IfP-66QGvrH83dyNdLCKl7OE25ELq9vY7cJNO1T8veZa8O7EwRtLJq/" target="_blank"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7JuckG0or5p-qyexCU9Xy4Vq6nbOGDbShZA5kw_o2GwtsFdHXXqVNGKWUKf4Vw8yPFP3jfIHxSom15q-RNQDRp_IfP-66QGvrH83dyNdLCKl7OE25ELq9vY7cJNO1T8veZa8O7EwRtLJq/s500/IMG_0292.JPG" id="blogsy-1308996655070.1416" class="aligncenter" width="500" height="375" alt=""></a></p><p>I love the way this baris decorated, the details are great. The handle bars on the stairs is wrapped in leather. The lounge area is designed as a reading den, where you can pull books down from the shelfes. </p><p>The bar is also beautiful and the tap system is out of a british pub with bras tubing. Only thing is you have more than just real ale running from these guys. So what's on tap?</p><p>Everything. There is no specific style or no countries. The beers range from swedish lagers to American california IPAs. This would normally scare me off, 'World off beers' and all those frases telling that we're settled with boring huge mainstream brews. Well, this is where I start to love the place. They travel the world beers like you should, don't go for huge seights but go local and explorer the native beers. The good beers that you can't get at the airport!</p>mollerhansenhttp://www.blogger.com/profile/16885120984919315092noreply@blogger.com1tag:blogger.com,1999:blog-5704368083496930906.post-32414888769450281712011-04-25T04:46:00.001-07:002011-04-25T06:01:51.460-07:00Blogging from Blogsy<p>I've always wanted to blog more than i've been able to so far. So I've decides to do some changes to make the trip from the keyboard to the Web shorter and at the same time also the trip to the keyboard. </p><h3>Architecture</h3><p>Before I tried to host my blog at the domain host <a href="one.com">one.com</a> servers. The obvious benefit is of course control the downside is more work to maintain the webpage. Idea: move to a blog service provider. </p><p>I already had a Google account so why not just choose the Google service <a href="blogger.com"></a><a href="blogger.com">Blogger</a>. Since this is an experiment I haven't yet moved my domain to point to the blogger page. The Quick and dirty solution is of course just to forward the visitor via the meta referat command. </p><p>Trip from keyboard to Web just became shorter. </p><h3>Tools</h3><p>I am very positive on Bloggers webapp editor, so I will most likely use that as my desktop editor.</p><p>But to make the trip to the keyboard shorter I am trying out <a href="blogsyapp.com"></a><a href="blogsyapp.com">Blogsy</a> for tha iPad. After doing some iTunes store browsing it was apparent that Blogger is the only main blog service (squarespace and wordpress as the other) without their own free iPad app. </p><p>But I found a paid app named Blogsy which I am writing this post from now. Blogsy works as I need it too! Blogging from a café in Copenhagen. </p><p>But how do I insert a picture of my burger from my iPad photo library?</p><p></p><p></p>mollerhansenhttp://www.blogger.com/profile/16885120984919315092noreply@blogger.com1tag:blogger.com,1999:blog-5704368083496930906.post-64134485878147739682011-04-23T23:43:00.001-07:002011-04-23T23:43:39.059-07:00Test entryJust to get a feel for it...mollerhansenhttp://www.blogger.com/profile/16885120984919315092noreply@blogger.com0