Saturday, May 29, 2010

JIT vs the Death Wobbles

A modern capitalistic society has a number of companies which supply the populace with staple goods. These companies, like all others of significant size, are listed on stock exchanges, and require "shareholder value". This means being as efficient as possible, not wasting money, you understand. Which sounds reasonable, particularly if you own some stock of said company.

There is a problem though. A chain of supermarkets has warehousing costs that they want to keep at a minimum. When you get down to the nuts and bolts of this problem, you end up with the "just in time" philosophy. In essence, it means that they store only enough stock of goods to supply their stores "just in time" for them to run out, and keep a minimum buffer of goods. How skinny is this supply? Well, it is measured in days. Honestly, I work in retail, and I know this for a fact. In Australia, Woolworths (one of the biggest chains) keeps about a week of inventory. Of course, slow moving lines might go for longer (eg blank DVDs), and fast ones (like bread) are almost measured in hours.

You may be struggling to see a problem with this, and I don't blame you so far. Lets look a little further down the supply chain. The companies that supply the supermarkets warehouses work in a similar fashion - just in time - more of less, on aggregate to the entire market. It is not in their interest to be out of stock, but at the same time (and depending on the product) it is also not in their interest to have a large oversupply warehoused as well. It's a balancing act. So anyway, there is perhaps another week or so of supply in the next tier down, perhaps a little more, depending on the product. Could be a few weeks more, but probably not months.

OK, big deal, two+ weeks of stored supply before you reach the manufacturers. What's the point here? Well, the point is what might happen in a crisis. And by that, I mean any crisis, but there are several big ones potentially looming. I'm a bit of a "doomer" and what I have in mind is a currency collapse (Euro, US Dollar you name it), coupled with a stock market collapse. This may lead to a collapse in international trade and banking, even local banking. What happens then?

Well, people panic, and they buy food. And it will all be gone overnight. I mean it, overnight. Because the JIT philosophy works only under normal trade environments. In a panic, the shelves will not be refilled in time, and as soon as they are refilled (which mostly happens at night, by the way) they will be emptied. Even seasonal times, such as Christmas, throw this out of whack, and is a preview of what I am talking about.

I thought about all this today as I happened to go shopping, and at the checkout register I chose the credit card reader was not working - I had to go to another area to have my card processed. But I started thinking about what would happen if all the cards readers were not working. In a banking crisis, this would be the case. Credit would be frozen, and even access to a positive balance would probably be frozen. It would be cash only, and that would be a problem for a lot of people past the first few days. Do you have more than one weeks shopping cash on hand right now?

Assuming you could even pay for the food, the supply of staples is likely to be sold out anyway. There are a lot of lists online that people have compiled showing what is likely to run out first. These lists are not just made up (although some are), but are based on observations during recent crisis times such as Katrina, or during the collapse of the Russian empire. Some things are what you would expect - Fuels, Generators etc. Other things are perhaps a little odd-ball, and may not be front of mind, such as the gloriously politically correct "feminine products". How long can your household go without buying more of these?

What I am trying to get at here, and probably failing dismally, is the link between the JIT and the buffer society has against a panic during crisis. They really are at opposite sides. Now, one could reasonably argue that the times that JIT seriously fails us are "once-in-century", or less often even. The trouble here is that we have had stability since WWII, and that seriously looks like it could end any time to me. It is possible that I am either paranoid or delusional, but it is also possible that I am seeing things just a bit before everyone else. I keep a close eye on international finance and the story is very complicated, but in general we have gone from a lending crisis to a company/banking solvency crisis to a sovereign solvency crisis. There is no next tier up from here, except perhaps a global solvency crisis, and that is where the buck stops. We are well into uncharted waters in this arena. World wars have started on less than the conditions that we currently are under. The level of volatility is likely to rise dramatically in the near future which will cause extreme government policy action.

As a young boy I rode my skateboard down a lot of hills, much to my mothers disdain as this also meant quickly worn out sneakers that I used as brakes. There is a condition on a skateboard which was called by my friends and I - the "death wobbles". This starts out slowly, but the amplitude of the wobble grows despite your efforts to correct it, and culminates in you being thrown off the board at full speed. These events often ended in a minimum of war wound like skin scrapes, and at most broken bones. In the very final moments, when you know for sure you are doomed, your mind seeks in panic a place to fall to as a soft landing, to minimize the certain damage. Heaven in these circumstances is a patch of soft grass. It's also notable how the panic comes late in the game - up until that moment things are "under control" - until they aren't.

The analogy here is that with JIT in place, it's like getting the economic death wobbles and being surrounded by rough tarmac, and having no shoes on. There is just no escaping the damage. Food supply, along with personal security (and liberties), will become the primary concern when this thing gets out of control. The global banking system is in a death wobble right now, with the amplitude of the problems are growing. This is how I see it all anyway....

Saturday, May 22, 2010

2013 - Future entry

Well, it's now 2013 and we can finally look back on 2012. What a year. As we all know, it wasn't quite like the movie. No giant meteors. No cosmic intervention, just the average human carry on. Mind you, that can be just as destructive.

I was reminded by the hype and tension for the Y2K. I worked in the computer industry and the fear by some pre-2000 was bordering on irrational. Set the clocks forward and see what happens if you are that worried, I said. Y2K? No real problems. 2012 was similarly supposed to be the end of the world because of some Mayan calendar issue. C'mon. And my tea leaves say Apple is a good buy at the moment, and if you are a Sagittarius born under the year of the Monkey, then you are going to get a pimple on your left butt cheek.

And yet, 2012 sucked bad. Let's face, it wasn't a good year. 2011 wasn't either, and 2010 wasn't much better - near the end of it anyway. It's a wonder how the fan keeps on working with all that shit being thrown at it. I am hopeful that the worldwide misery has peaked, but time will tell on that. The clowns running the show still don't get it, or worse, get it and are actively part of the problem. The human condition seems to excel in suffering.

There are lot's of things people miss now. It's strange to think that just a few years ago anything, and I mean anything, could be purchased for a price. Not that everyone exercised this "right", but the dream that it was there was at least something. Now this dream has well and truly gone and reality is biting down hard for almost everyone. What do you miss most?

For many, despite the lack of a meteor, 2012 was indeed quite like the movie, the outcome was similar. Worse even, as the deaths we have seen were not instant, innocent and painless. Nobody really wants to dwell on what has happened, in case it happens again, or worse, happens to us. I hope it doesn't happen to me or my family, and I hope it doesn't happen to you or yours. Survival, it turns out, is still a very strong instinct in the human species.

Anyway, I wanted to wish you all a happy new year. I hope 13 is not an unlucky number for me or you. Here's to a better year! Drink it if you've got it!

Kobo eBook Reader rough Review

A "Kobo", for the uninitiated, is an anagram of "Book", and it is an eInk based ebook reader. It cost A$199 from Borders bookstore. We got a black one, for reasons which I will explain in a minute. If you want some photos and thoughts on this device, I suggest a quick read here first before I give my take. Don't worry, I'll wait as long as needed.

Back? Ok. Well, let's start with my conclusion first - what's it like? ..... Good!

A book reader is a one trick pony. It must display text, as readable as possible, in a comfortable package. Taking this criteria, and keeping as many bells and whistles away, the Kobo achieves these simple goals. This also helps keep the price down, I might add, not to get distracted by other features.

I've used computers for decades, but I'd never seen an eInk display before. It looks a little like a very old Mac SE display (told you I have been using them for decades). Although not as many grey scales at 8. This is enough for simple images, but it ain't a portable photo album folks. It can just manage a passable book cover. As for the pixels, they are small enough to make a serif font look decent, and the complete stability of the display adds to its readability. You see, it only refreshes the pixels when it repaints the whole screen, something it does each page turn. This involves a complete black then white write, then the display is drawn black again. Think of an etch-a-scetch and you are not far of the mark. The contrast ratio is not perfect, the background is light grey rather than white, and the text is very dark grey rather than black, but in even semi-decent light it's easy to read without eyestrain. And yes, you need external light as it has no backlighting - something that enables the battery life to be measured in days.

What I also like about this unit is the dimensions - it's small but not too small (about the size of common paperback), and very light. It needs to be light because reading can take a long time, and every tiny gram starts to multiply with each hour. It is lighter than most books, so really it's a plus. It also has a nice "quilted" back, which is really just a textured matte surface, which does feel quite pleasant.

Navigation of pages is done with the 4 way controller on the bottom right of the unit, and it's dead easy to do - your brain does it by itself after a while so there is no taking away from concentrating on the book.

So, are there any negatives? Sure, I can give you a whole bunch. But they are minor gripes really.

Let's talk ergonomics. The first issue is the location of the USB port, which is directly under the 4-way controller at the base/side of the unit. As you are holding this one handed your hand falls on this port and it's uncomfortable compared the rest of the silky back. The controller also has slight bumps on them, like braille, and they surprisingly irritate the surface of the fingers after a l0ng while. If this was my unit, and it's not, it's my wifes, I would get a razor blade and shave them off. I know where to press, they are not needed.

We got the black Kobo, and that was for two main reasons, and one minor one. Firstly, the controller on the white unit is a really bright blue, which is distracting to your eye as you are reading. On the black unit it's a more subtle grey. Secondly, I felt that the white might end up looking grubby after a while of use, and black will hide this. The minor reason is that I just felt it looked better, just simple opinion.

So, in use there is another minor issue - the slow response time. The screen is not like an LCD on a computer, or a TV. You do something and then wait a second or two for it to refresh the screen. And you see the flashing while it does it, it's quite obvious, not subtle at all. I use it as an opportunity to blink, or close my eyes for a second, to give them a split-second break from reading, but that's just my way of dealing with this issue. I am not an overly patient person, and if it was even a fraction of a second longer it would be too slow, but as it is, it is acceptable. Straight reading is ok, but navigation to other pages at random is trickier.

The unit does have expandable memory, which is good because some other readers don't have this (ie Kindle). However, the SD card slot only reads SD cards up to 4GB, and it doesn't come with the spacer (blank plastic) card which keeps the dust out. I had a spare lying around, but c'mon. Oh, and there is not cover or carry case of any kind included, nor can you buy any yet, so you have to be super careful not to damage the unit. Not that it feels flimsy, and the screen has a plastic feel to it, not glass covered, so a slight knock might be ok.

In terms of syncing the unit, and buying books, the experience is fine. It can handle only a few formats, ePub and PDF, but they claim to be "working to improve this". We'll see what the future brings there. I would expect at least support for plain text files, that should be a no brainer.

What is the point of buying such a thing, you may still be wondering? Is it just another totally unnecessary tech toy the world can do without? Well, I sympathize with this sentiment, but counter with a bit of mathematics, and a bit of green ethos sprinkled on top (which may or may not hold water)

So - mathematics? Well, dollars and cents. My wife is a fairly "Constant reader" and churns through a few books a month. These cost somewhere between $20 - $30 each in paperback, and we have groaning bookshelves of them despite her giving them away when she can (to school book fates and the likes). Anyway, in a single years reading, at 2 books a month, she might spend 2x12x25 = $600. It all adds up you know. So, enter the Kobo. It cost $200. And books cost $10-$20, that is, they are often $10 or more cheaper. I think you can see where this is heading. So the year cost of the Kobo, with the purchase price included, is 200+2x12x15 = $560. So it's making money back after a year. If you keep it up, after several years you have made back a sizable sum as you don't have the cost of the Kobo in there.

So - green ethos? Well, ignoring for the minute the environmental cost of manufacturing, shipping the Kobo itself, and possibly the poisons released when it's disposed of at the end of it's life (See why I said "may not hold water"?) - eBooks are better than Paper Books. It's the whole atoms verses electrons thing. You can move electrons - information - about with a lot less effort than atoms - thinly sliced trees with ink (ie books). Books have weight and volume, and manufacture and shipping have costs. Hard for me to measure exactly, but picture a Kobo on one side of the scales, and all those books on the other.

You can carry a decent library with you on a trip with a lot less weight than the real thing. But to me that's balanced by the issue of having to look after the device - battery level and make sure you don't damage/lose it etc. When you finish a paper book, you can pass it onto a friend, if you wish. With any eBook reader there is the issue of DRM (the dreaded Digital Rights Management) and of big brother stopping you from doing anything generous and natural like that. There are free formats, but most of the things you want are probably not free.

You could yack all day about the pros and cons of ebooks versus paper books. In the end, I think they both have their place. eBooks are a bit like a movie rental - for something you are more or less going to consume and not really need afterwards. Paper books are for things of sentimental value, or those with pictures, or something you have a stronger emotional connection to perhaps and you want to really "own" a copy.

Other random gripes are the inability to delete a book from the reading now list (open a book once, and you are reading it pal, like it or not, until you scroll past the last page). Also, in the book store, the 100 free classics don't show up in your bookshelf, which seems counter intuative, and there does not seem to be a way of deleting any of these if you don't want to have them any more. Some people are having poor battery performance (a few days), and the battery level indicator and the charging seem to be somewhat contradictory and confusing. I suspect people are not turning the unit "off" and this has something to do with it, but perhaps that's me, and besides, it should have some sort of auto-off feature. It asks you the time, but yet there is no easy way to find out what the time is. These all feel like version 1.0 issues, and I'm hoping in time they will more or less all go away with software updates. Things like colour, full touchscreen, MP3 playback etc are all overkill in my opinion. I see this as a very different device to an iPad, for example, even though you can read books on an iPad or a computer.

There is a lot of potential for simple refinements in the Kobo. It think a dictionary would be a good one. It may not be possible, but in terms of the eInk screen a selective refresh would be a great improvement (that is, if it only needs to redraw part of the screen, just black/white/redraw that bit rather than full screen). And better grey levels and contrast ratios, faster response etc will all come with the subsequent generations of devices. Wait for them if you want, but I think this device is cheap enough to dip your toes in the water with this technology. It's fun, we are all enjoying reading on it, and anything that encourages reading can't be bad, right? Right?

Saturday, March 27, 2010

32bit or 64bit OS?

Ah, for most people, the answer would be a something like "Er, What?". Clearly it shouldn't matter, and I think that is important to keep in mind. Because I think it's getting to the point where this is probably the case.

In the Windows world, we more or less moved over to 32 bit with Windows 95. What is 32 bit anyway? Well, imagine 32 1's or 0's in a row. That's a representation of a number. It's 2 to the power of 32, or 2x2x2x2...x2 (32 times), which = 4 billion or so. Now, there are 8 bits in a byte, and, well, I'll let wiki explain the rest if you are interested. The practical implication of this is that you are limited to 4GB of memory. Which is a lot, right?

Well, no. Not really any more. And certainly not if you want to do anything serious, like a database or virtualization. Even consumer PC's these days, since the hungry-hungry-hippo called Vista was let loose, have come with 2GB ram as a reasonable medium standard. If you have even remotely paid any attention to spec changes over the years you will know that they double every now and then. So we are only one double away from hitting that 4GB limit.

There was a 64 bit version of windows XP. It was very much the bleeding edge. Almost nothing worked on it, and peripherals in particular were the pain point. Getting that printer or scanner, video card etc to work was a real gamble, and most times you got snake-eyes. Vista was actually better, as the 64-bit version was released at launch date, and flagged that hardware vendors had to start producing 64-bit drivers from now on or else. And they have. Of course, the 32/64 bit question was somewhat hidden by the overall horribleness that was Vista. Windows 7 is really just Vista done right, and to be honest, the latest patched version of Vista is actually not too bad. However, it's reputation is permanently tarnished and much like Windows ME will spend it's eternity in History as a dud, a lemon and a turkey.

Well, most sane people, and those cautious in businesses around the world, have largely been hanging on the XP platform waiting to jump over Vista. It has helped that since the Core2 the CPU's have more or less also been "good enough" to keep going for a few years. The GFC has not helped IT budgets much either, so this has also influenced things.

Anywhoo, at my place of work we recently replaced a bunch of XP machines. What did we get? Well, some intel i7 based Dell boxes, with Window 7 and 6GB of RAM. Yours with a 23" LCD and Office for around $1700 Australian - which is a pretty good deal in the current market. Yes, I know Office 2010 is just around the corner. Sometimes these buying opportunity windows open up just briefly and you go for it when you can, even if it's not 100% ideal. I also think of the permanently revolving doors you see at some hotels -- if you wait for it to stop you are waiting forever.

So, perhaps you are wondering, which did we get - the 32 or 64 bit version of Windows 7? Well, the clue should be the 6GB RAM. Are you paying attention? Stay with me here!

So, how have i found the 64 bit experience? On the whole, like the rest of Win7, it's almost flawless. Really, the water is fine, jump right on in. With new hardware, you know the PC itself is going to work. The trick then is any legacy software and hardware. In my environment the biggest bugbear was Access 95 databases we were still using. This was the final push for me to upgrade them all to 2000 format, and I'm glad I did. My previous post goes over this in tragic detail if you are interested in that saga.

The other problems I had were --
  1. Installing SQL 2000 client tools. The installer recognised the 64 bit environment and didn't like the idea of putting the 32 bit version on the CD there. Fortunately, I found that you can still install it by running an installer buried a bit on the CD. A google search turned up this solution in under 5 minutes. Yes, and caused by trying to continue to use old software note.
  2. Printing to our copier at work required downloading a new driver. Printing to an older, less popular and consumer grade printer also provided interesting problems, but I was even able to do this using the Vista driver.

Overall, I have (so far) not had a problem I have not been able to solve. This is as much a testament to Win7 as the 32/64 issue, but I think there has been significant evolution of the software over the years to prepare for this moment.

You may be wondering - will we have to move to a 128bit OS in a few years time? Well, there is that whole "never say never" thing (which is clearly self-contradicting, but that's not what I mean). Remember that each extra bit doubles the number it represents. So a 64 bit number isn't double a 32 bit number, it's 4 billion or so larger. That's a LOT of memory (16 billion GB). Like, probably as much as has been manufactured in the history of mankind, or not even. In one PC. Doesn't seem all that likely, does it? So, I think this is probably safe to say the this is the last of these kinds of changes we will have to make in our lifetimes. I've lived through 8, 16, 32 and now 64 bit OS's. Change is pain, but to be honest, this is the least painful of these transitions I have experienced.

Sunday, March 14, 2010

Upgrading from Access 95 to Access 2000 (or greater)

This blog entry will only interest a relatively few people on the planet. If you don't use Microsoft Access 95, then I suggest you stop now. This will not make much sense nor be particularly riveting.

I have used Access 95 at work for about the last decade or so. The main piece of software the company uses was written in it, before I started working there and I have carried on from there. On the whole it is a good piece of software, and I think it speaks well that it can be used for so long. It even has some advantages over more recent versions, primarily the ability to have a single server copy of the front end that everyone uses which can be edited in real-time. It might seem like an afterthought, but it has excellent help that is actually helpful. Contrast this to .NET or Excel help which is generally useless. I think perhaps Access 97 was better than 95, and it shared many of the positives and had some features I like such as intellisense (where it completes the word in code, and also gives you parameters for functions etc). Anyway, it's a moot point as we were stuck with 95.

However, it is also not without it's flaws. The most notable being the limit to a machine with 1GB RAM (usable, which is a point worth noting). It also is quite slow sometimes and has some interesting compatibility issues with SQL server data types and locks. For example, it shows boolean values as 0 or -1, but does not actually work in a query if you compare it to -1, but does if you compare to <>0. It fails to delete data in linked ODBC tables reasonably often, I'm not sure why, but at least it let's you know it didn't work. Mind you, we are using the now-old SQL 2000, so that might have something to do with it.

There are some patches that are mandatory for any Access 95 install, by the way, including a patch to the Visual Basic for Applications (VBA) VBA232.dll. The right version is just over 1MB, the wrong one is just under.

Anyway, the deal breaker for us is the RAM issue. 1GB seemed like a massive amount of memory back in good old 1995 when this software was "new", and I believe it still is a lot, but todays machines have and need this and more. Vista was a massive memory hog, which is why at work we stuck with XP, but Windows 7 is a lot more reasonable. Recently we have upgraded a number of desktops at work and they have come with 6GB of RAM and Win 7 Pro 64 bit. This blows poor old Access 95's mind, and it perversely gives the error that that it is out of memory when you try and launch it.

Now, recently I discovered it IS possible to run Access 95 on a machine with over 1GB of RAM. Well, sort of. What you do is limit the machine to only use 1GB (actually, just under), no matter how much RAM is installed. It's certainly easier than physically removing the SIM cards, and it means that you don't have to have the exact SIM configurations installed. To do this you use (in Run type) MSCONFIG and then go to the BOOT.INI, and look at the Advanced Options. In there you can set the max RAM to 1023 MB. This is one MB under 1GB, which as we all know is 1024 and not the dubious marketing 1000 MB. A reboot later and Access 95 will indeed work. The downside of this technique is that the rest of your OS will probably suck badly with this limit. There is a possible relief valve you can use to eek out just a little more performance, if you are determined to go this way, and that is to then increase your virtual memory. This is done in the My Computer (right click), Properties, Advanced, Performance, Virtual Memory. If you set the minimum to 2048, max to 4096 (ie 2-4GB of VM) then things will go.. ok.. probably. When I tried the above to the new 6GB machines, they did indeed work ok. Not as quickly as with the full 6GB, but not too badly. I tried multitasking with 5 or 6 applications (eg Outlook, Word, Excel, Paint, IE, etc) and it all ran. But despite getting this working (and it was somewhat of a revelation to me that this was even possible, I was resigned to the fact that it wasn't), I felt this was a "second best" solution. Really, the time has come to move on from Access 95.

Over the years I have tried to "bulk" upgrade from Access 95. That is, to create a blank database and import the objects from the Access 95 database. I have tried it to 97 and 2000 without success. I can't recall now what exactly went wrong, but after importing a number of objects the whole thing just died - mostly with errors about the code being corrupt or something.

However, on Friday I was able, for the first time, to do this. The machine that did this miracle was my recently rebuilt (due to a hard drive failure) XP box, which has just under 1GB of RAM, and Office 2003 installed, patched to the latest of course. The database being imported into was actually in the older Access 2000 format. The trick was to make sure that the Access 95 database I was importing from could compile first (don't even think about importing it if it doesn't). I imported objects also in a fairly specific order, which may or may not matter. First make sure all the linked tables are there, and any references (I have Excel reference because there is some code that manipulates spreadsheets). I imported the code modules and macros first. Then the queries. Then the forms/reports. Why in this order? Well, these things can rely on each other - and it works best if the thing that is being relied upon is already present. It also allows you to try compiling the database between each step to make sure it all still works.

In our case I need to import three databases into one existing one. The issue of good naming conventions of objects becomes apparent. I have a policy of naming forms, for example, with the prefix "Form A01 - ", showing that it is a form in the database "A", and its number is 01. After the dash is some description of the form. If there is a query used in that form, then the query is called "Form A01 -" too. Reports are "Report A01 - ". Where possible queries are saved and named, so recordsources of forms and objects (eg lists and combo boxes) get saved as named queries. It makes for a lot of queries, but it means they are all visible outside of the form editing. Anyway, one advantage of this system is that when 3 databases are combined the objects are all uniquely named. If they are not, the first duplicate gets a "1" added to the end of it's name, or "2" or "3", depending on how many duplicates there are already. For this reason alone it is also a good convention never to END a named object with a number. The duplicates may or may not be the same of course (think : code fork), which will need to be checked, and if there are hundreds of these it may become an insurmountable problem. Either that or work our where each object is used and rename it, which is a big job again. This needs to be sorted out before the first object is even created, so it's either a problem or it isn't at this stage of the game.

So, was the process perfect? Well, no, not quite. I have only tested certain functions, and most things seem to be working correctly, but there are some oddities. For example, some forms have up to 6 copies of the "file" menu, which is definitely abnormal. These are custom menus, and usually there is just one. I'm not sure what that means at this stage.

[Edit - I worked out what this was caused by. The forms with multiple menus all had subforms, and these subforms had menus set. In access 95, only the parents menus were used but in later version all forms menus were drawn. The fix was therefore simple - remove the menus on the subforms. They were not supposed to be there anyway, it was just from sloppy form copying.]

I seem to recall that there might be issues with the DAO versus ADO view of life - that is, how recordsets are handled in code. I need to check into that pronto as a lot of the important code actually uses this. A re-ordering of references might be all I need to ensure it does what I want, and certainly it has compiled the code, so that's encouraging.

What more is there to say?

Oh, I know. I have had to do some slightly tricky things to emulate the development I had with Access 95. I'm used to editing the server copy and everyone uses that. The problem is that Access 2000 and onward seems to delight in corrupting any multi-user front end. You have to really have a local copy for each user. So how to do this? The solution I came up with is to have a local copy of the front end. When it launches it checks a version number in a table versus a version number which is a constant on the main menu form. If these are different it warns the user that there is an upgrade available. They then press an upgrade button on the form which launches a batch file the quits the app. The batch file pauses for a second (waits for the quit) then copies the server version to the local directory, and then re-launches the database. It all works quite well, apart from the issue that I have different versions of Excel installed around the place (2000, 2003, 2007) and this breaks the references. This is something that needs to be fixed each time - the first time it tried to run code it fails, and drops into debug. Stop the code and deselect the missing reference, and select the right one. Compile and off you go. I have thought of perhaps having three different versions of the master, one for each version of excel, but I can't be assed doing this as I don't have enough users to justify the hassle. If I had hundreds of users I would. Mind you, if I had hundreds of users I don't think I'd be using Access. We do also have a web-based front end, but it's oh-so-much-quicker to develop stuff in Access.

I will be slightly sad to see Access 95 go. It's been a solid workhorse. From 2000 format, I suspect it will be relatively easy to go to 2003 or 2007, but these things have a way of making a liar out of me, so take that with a grain of salt. I'll post here if/when we cross that bridge.

Saturday, January 30, 2010

Class definitions

For some reason I was thinking about the "middle class", and wondered what a good working definition of this group of people was. I have checked a few places, such as wiki, and it seems to be a bit of a grey area on how you define this. So here is the definition I came up with

Working Class - Need to work (obviously), and if their assets were all converted to cash, would still be in debt, or have so few assets that they are basically living hand to mouth (renting and less than 1 paychech in the bank). It is likely that they will need the full term of any debt to pay it off, causing also the repayment of about twice the initial value of the debt. They are most likely to slip off into bankruptcy as the become unable to replay debt. "Destitute" should probably be a class all of it's own, under working class.

Middle Class - Also need to work, but if their assets were all converted to cash, would not be in debt. This doesn't mean that they don't have loans - they almost all do - but on balance they have more assets than debt. For example, John and Sue might have a mortgage for $200K, and a car load for $30K, but the house is worth $600K, so they are net positive if they had to sell everything. These people are still susceptible to cash flow problems - such as losing a job, but on the whole are more secure financially. They are also likely to have superannuation and possibly other investements which they hope will advance in value so that they can retire or move to Upper class. Possibly the "upper middle" class have no debt, but not enough capital to give up work. The danger for someone in middle class is if they aquire the taste for the upper class lifestyle, and use debt to live it - which they can for a while - then it's back to Working class for them. Similarly, if that house is revalued in a falling market to $150K then John and Sue are redefined as being in the working class (and are "underwater"). This is happening on a grand scale in America at the moment.

Upper Class - do not need to work, but mostly do anyway. These people like money, know how to play various corporate games, and investments and enjoy the status of having wealth. On this basis, they continue to accumulate it. However, they do not have to as they could easily live off their wealth instead, and retire, to a modest lifestyle. These people do sometimes bet "the farm" on various investments and can be sent all the way back to working class if bets go bad, but that's often the "new money" that does this. The old money is more careful, I think. These people go into debt, but only as a tool to make more money - they never let the interest repayments suck the lifeblood out of them like the other classes do (particularly working class). They enter into agreements which can be paraphrased as "heads I win, tails you lose". These people often re-write the rules of the game so that things are very much in their favour.

Well, that was my way of splitting up the classes. I think it works.

Tuesday, January 26, 2010

Economic Links

Links.. really? How 1990's is a links list? Very, but I feel the need. You see, there are many excellent sites out there explaining what's going on, and you may want to get to know some of them. Also, it's possible I've missed one or two and you could leave a comment letting me know. I'll try to explain a bit about how I use each site.

CNN Money - Pre market I use this simply to see what the open is likely to be like in the US. As I live in Australia, on a Mon - Fri night this is an interesting thing to observe. Also the currencies page shows you how the AUD is faring against the USD. Lastly, this is a "MSM" ("Main Stream Media") and it's interesting to see what they are obsessing about or how they are explaining market action. You may start to feel a bit stupid if you read too much though, so save yourself any in depth exploration, there are better options below.

Kitco Live Gold Chart is somewhere I go fairly often. If you own gold, or gold mining stocks, it's interesting. And you probably should! It gives you 3 days of activity, and you get used to the chart.

Bullionvault Live Gold Ok, another one? Why? Well - this time it does something very useful - it converts it to a live price in Australian dollars. It also can go down to activity in the last 10 minutes, and has some fairly groovy chart options. The only downside is that it uses Java, heavily, so this can take a moment to launch. Fun to watch when the fireworks are happening in the gold market. The gold market is global, so it's open almost all of the working week - there are some hours where it's not though.

Mish. Is a blog with frequent and interesting articles, and just as interesting a comments section and community. Mish is a fairly hard deflationist, who sides on the Austrian school of economics. I don't always agree with him, but I certainly find his perspective interesting, and I give him points for calling the March low in the market almost to the day. I was not a believer at that time.

Denninger / Market Ticker Karl is a bit of an angry man sometimes. Often justifiably so, but sometimes not. He does take the time to really spell stuff out though, and so it's worth enduring the sometimes ranty/condescending tone to get to the heart of the matter. Something he does quite well and often. I've never explored the forum, it's probably good but also probably huge. You might consider Karl on the lunatic fringe at times, or a "true patriot", depending on your point of view.

Zerohedge I have been following this web site since it started. It is more or less a web site for financial industry insiders, it can be very technical, very little is explained, which can make it practically incomprehensible to newcomers. It is worth the effort though, as many of the articles provide highly relevant (to the market) news and discussions. If you want to understand whats driving the market really (not the CNN version), this is the place. They also discuss US treasury auctions, gold and other topics, and like Mish, the comments section is often a better read than the articles themselves. Work your way up to this site.

The Automatic Earth Some of the best articles I read in a while have come from this site. It is well thought out and written, updated relatively infrequently (once per day-ish).

The Market Oracle is a UK based site, which is a compendium of articles syndicated elsewhere. You will see some of Mish's stuff here, for instance. Many of the articles are leaders to try and get you to subscribe, but others are the full deal. After a time you get to know the various contributors and where they stand. Some are full on doomers, while others are not.

Implode / Explode is another list of articles, which again may point you back to Mish or Denninger. However, what I find interesting is the "Bank Failure Friday" coverage, where they go into details of how many and how big each failed bank is.

Jim Kunstler is an author of a book called "the long emergency" which was a big eye opener to me when I read it. He is a perma-bear, who sees the US as a car dependent society in decline. His timing might be wrong, but a lot of his ideas are not. There are a lot of fatalistic survivalist types who follow him, so be prepared for a bit of that action.

The Oil Drum is not actually an economic web site, it's more of a peak-oil web site. However, if you see energy as the driver of economies, this is a great read. Again, the comments are often very thought provoking. I very much believe in peak oil, by the way. I have read quite a lot about it and might do a follow up list of books that are worth reading on the subject.

Urban Survival is a real "lunatic fringe" entry, but one I find weaves in and out reality. He believes in a system he sells which analyses web language content to predict the future. He believes in government conspiracies, predicting things such as earthquakes and is anti-flu vaccines. You may find it all too "out there" but sometimes it is an interesting read.

Soot and Ashes was dormant for ages but seems to have risen...ahhh... from the ashes. Keith runs the show and he has an attitude of sorts. Good comments. Worth a check in for the amusement value, as much as anything. He used to moderate the housingpanic web site, which was huge for a time when the whole sub-prime bomb exploded.

Are there more? Well, yes, but the above list covers a most of the interesting ones. I check the Sydney Morning Herald for my general news, and sometimes read the business section there about local companies and influences. If you are unsure of the value of owning gold, there are a couple of seriously one-sided fan sites of the metal here and here.