You are viewing [info]philmophlegm's journal

May. 16th, 2012

  • 7:14 PM
911

One of the few advantages of working away from home so often is that I rack up the frequent stayer points on various hotel loyalty schemes. I've stayed at Intercontinental hotels enough in the last couple of years to accumulate enough points for £50 of Waterstones vouchers. And this morning I spent them.

This is what I bought:

Joe Abercrombie's most recent novel 'The Heroes', a sort of sequel to the 'Book of the First Law' trilogy, which longstanding readers will remember me praising in the past.

A couple of SF classics (both in their SF Masterworks editions) - Greg Bear's 'Eon' and Dan Simmons's 'Hyperion'.

'Rule 34', the sequel to 'Halting State', by Charles Stross's. Again, long term readers of this blog will remember that I liked that novel a lot.

'Yellow Blue Tibia', by Adam Roberts, which struck me as a fun premise (Soviet SF writers called on by Stalin to create a convincing alien threat to unite the people, then disappear, then one reappears after Chernobyl and Challenger and says the plan is coming true).

'Moneyball' by Michael Lewis, which is a book about how the Oakland Athletics, despite being one of Major League Baseball's poorest franchises were able to compete with much richer clubs. Lewis is the author of 'The Big Short', which I recommend to anyone who wants to know how the credit crunch happened.

Robin Lane-Fox's 'The Classical World - An Epic History of Greece and Rome', which I think (hope) does exactly what it says on the tin.

'Peace and War', an omnibus edition of the trilogy which starts with 'The Forever War' by Joe Haldeman. 'The best military SF ever written.'


If anyone has ever read any of these, feel free to comment...

Posted via LiveJournal app for iPad.

Tags:

Excel AKICOLJ

  • May. 12th, 2012 at 9:44 PM
Traveller
I want a function that returns a value equal to (x six-sided dice minus y six-sided dice) but which returns the answer '0' if the formula would otherwise result in a negative answer.

Or, to put it in role-playing terms, something like "4d6-3d6, but show any negatives as zero".

Doing the 4d6-3d6 bit is easy:
=(RANDBETWEEN(1,6)+RANDBETWEEN(1,6)+RANDBETWEEN(1,6)+RANDBETWEEN(1,6))-(RANDBETWEEN(1,6)+RANDBETWEEN(1,6)+RANDBETWEEN(1,6))

I had thought of then putting this inside an IF function, so that if the formula above was >=0, it showed the formula above, but if it was <0, it showed 0:

=IF((RANDBETWEEN(1,6)+RANDBETWEEN(1,6)+RANDBETWEEN(1,6)+RANDBETWEEN(1,6))-(RANDBETWEEN(1,6)+RANDBETWEEN(1,6)+RANDBETWEEN(1,6)),(RANDBETWEEN(1,6)+RANDBETWEEN(1,6)+RANDBETWEEN(1,6)+RANDBETWEEN(1,6))-(RANDBETWEEN(1,6)+RANDBETWEEN(1,6)+RANDBETWEEN(1,6)),0)

Unfortunately, that second function doesn't work. The reason it doesn't work is that it is recalculating the 4d6-3d6 part. That means that if the original 4d6-3d6 is positive, the formula doesn't show that positive number. Instead it rolls 4d6-3d6 again and shows the answer to that.

Any ideas?

More Phligm Phlagm

  • May. 11th, 2012 at 11:39 AM
Hagia Sophia
The BBC has a new high-profile series on Roman history called 'Meet the Romans, with Mary Beard' presented by celebrity historian Mary Beard. You can tell she's a celebrity historian because the programme isn't called 'Meet the Romans', it's called 'Meet the Romans, with MARY BEARD'. I watched the first episode with bunn. We're both interested in Roman history, although she's self-taught and I did it at A-level. We also have very different interests. She's into social history, ordinary Romans during Imperial times and Roman Britain. My main interest in Roman history is the politics of the late Republic. In fictional terms, she's a big 'Eagle of the Ninth' fan, while I much preferred the HBO series 'Rome'.

This difference in tastes probably explains why bunn liked the programme rather more than I did. In fact, I thought MTRWMB was a little bit dull*, a little bit childish**, a little bit sensationalist*** and, dare I say it, a little bit dumbed down.

Read more )

Roy Hodgson v Harry Redknapp

  • Apr. 30th, 2012 at 12:36 PM
Duncan Edwards
It looks very much like Roy Hodgson will be the next England manager, and not Harry Redknapp. Seemingly everyone in football wanted Redknapp to get the job and not Hodgson.

I can't for the life of me see why.

Read more )
Duncan Edwards
Here’s something to do today if you’re feeling unnaturally happy with the state of the world and somehow feel guilty about it. What you need is something that will restore your previously held, cynical view that the world* is a horrible place full of really shit people.

Here’s what you should do. Go to twitter and search for the hashtag “#freeched”. Alternatively, go to facebook and search for the group “Free Ched Evans”.

For those of you who don’t follow the fortunes of Sheffield United Football Club, I’ll explain...


(Warning for readers of a nervous disposition: This really is quite unpleasant. If you thought my Michael Vick posts were bad, this is far, far worse.)

* Or at least South Yorkshire.

Read more )