Well hello there. What’s a nice reader like you doing in a place like this?
Yes, it’s time again for some fantastic statistics, brought to you by the wonderful folks at Excel OverShare.
Today we’re going to delve into the magical life of Bert and Kat by the numbers – we’ll be tracking things by the day, by the week, by the month and also by the trip. I’ll do the budget by months, and then everything else will be up to todays date (hopefully it won’t take me 3 weeks to write this, because then I’ll have to re-write it.
We’ve been on the road now for 112 days (as of 19th August), and we’re currently in Wyoming (just moved from Colorado).
Number of places we’ve camped = 19
Which makes an average of 6 nights per stay (by the time we leave this campsite).
We’ve been super fortunate to ‘moochdock’ with good friends, so the average nightly cost of our stays = $16.20
Number of states visited (counted as staying overnight in) = 9
Tennessee, Kentucky, Indiana, Illinois, Missouri, Kansas, Nebraska, Colorado, Wyoming
We’ve visited a Walmart in every state we’ve stayed in, except Wyoming ‘cos we just got here.
At this rate it’ll take us a tad under 2 years to the see all of the lower 48, but we haven’t really been optimizing our route, so we’ll end up with a highly inefficient ‘traveling salesman’ dilemma. Oh dear – we’ll have to spend a bit more time driving around then. What a pity.
We’ve seen 3 snakes in total on this trip – the last one was massive:
The snakes run away from correlates to the previous number, at 3.
Luckily, the ‘snakes that don’t give a shit that we’re there’ statistic is also constant at 3.
We’ve also seen several other species (as you can tell from Berts last posts), including turkeys, cows, goats, elk, chipmunks, goblins, chickens, alpacas, toads, rabbits and small children. We didn’t see any mice, but we smelt one. I also found a praying mantis on my shoulder the other day, and before I had the presence of mind to take a photo with it perched there, I brushed it off, and so had to take a photo of it in some grass. Which looks like a photo of grass.
Another statistic that I thought you might be interested in, seeing as we live in a ‘classic’ (read ‘dated’) home on wheels that has an amazing entertainment system (do you like the faux wood enclosure? Classy):
Number of cassettes listened to = 0
Total number of miles driven in the trip: 6793
Average number of miles traveled per day: 59.6
Total number of transit miles driven in the trip (campsite to campsite) = 2581
Average number of transit miles per trip = 135.8
Longest distance traveled between campgrounds = 240 miles
Shortest distance traveled between campgrounds = 12 miles
Average cost of fuel per mile = 15.8 cents
Cheapest diesel = $1.779 on 6th May in Sevierville, TN
Most expensive diesel = $2.399 on 26th June in Carlyle, IL
Best mpg as reported by the truck = 19.2 mpg
Best mpg as reported by my spreadsheet = 17.85 mpg
Which data do I have the most faith in = spreadsheet, but I like the trucks numbers better…..
Here’s an overview of our spending in the first 3 months (excluding truck/RV insurance that we paid annually before we left, health insurance and also cell phones – I suppose I could share all that stuff with you, but it’s in a different excel spreadsheet, and I can’t quite bring myself to amalgamate it at the moment. It’s a lazy Thursday evening.)
|Membership/ club/ education||$350||$0||$0|
Yes, I know – pretty big drop from May to July, but I think July was an aberration, and expect things to be more like May/June than July going forward. We spent a large chunk of time at friends houses in July (and some in June too), which decreased the accommodation costs a lot, but now we’re back on the road till we reach our next victim place to stay ………………….(Volunteers, please write your name and address on a postcard and we’ll carefully consider your application).
Alarmingly our parking category has been climbing rapidly. We’ll have to park in Walmarts and walk to places in order to keep our spending on that under control.
Altogether, the average spent per day = $78.87 (nice numerical symmetry)
We also need to start a ‘things to fix around the camper’ category – we have:
- Fix a vent cap on the black tank – the other one fell off apparently
- Black tank flush tubing
- Reattach waste water pipes to the camper body – the brackets seem to have rusted away, and now it’s just flopping around a bit
- Rethread one more blind
- Fix leak under vanity sink
- Fix bathroom fan (yes, still not done after a month….. must try harder)
…. And that’s to start with!
Also of interest – number of times Bert has drunk from a toilet = 1 (I hope…..) – more on that one in another post, but here’s a teaser pic:
And the best statistic:
Most fortunate people in the world to be able to get to see and do all this, and meet some awesome people along the way = 2 – us!