Blog
-
Alive again
So, my previous iteration was just abysmal, navigation impossible, kind of looked cool, but… not my best work.
So, after much chopping, I managed to get an old backup from the previous unit alive. Ugly, but functional – my webstore, with working e commerce. Yay. -
Hello again world.
This is not in fact, my first post – but given the nomenclature, our platform may well have some room for improvement.
“WordPress is not getting better”
-
Go fast and break Sheeeeeet…
That is the kiwi translation that those of us who sometimes darken the door of geek and business events all know, albeit slightly sanitised, because no-one expects a builder to know swearing words of profanity, right? (or maybe we are supposed to know them, but not use them, I dunno)
Guts is, we have been working this product lineup for a while – I built a messy messy messy database, which helps us produce reports a fair bit faster than the old hunt and peck method ever could, but heck, this game is still time consuming.
For reference, our average time on site is now back up to just under 2 hours. Why? We started collecting plans. This lets us answer some very specific questions, mainly prompted by the residential tenancies act, and healthy homes guarantees act. But it also plays into our goal to know more about your house than anyone.The idea, is big data, applied to houses – How long does a roof last? When will my hot water cylinder fail? What cladding actually requires more maintenance? Which suburbs grow moss or lichen faster? What renos are objectively the best value for money? Etc etc.
Time offsite, well, 15 odd minutes to collate 2.7k head camera videos (Gopro hero 7 black, awesome stability, good microphone, terrible file naming convention!!) another 10 minutes to set and forget processing for our 5.7k 360 degree videos, which typically take an hour or two to process per house. The basic file structure setup, so that when you click buy, you get the correct and complete report, well, that is in theory easy to automate. In practice, its easier to break! Then comes the writeup. My world record time is 27 minutes. Normally however, it is more like 2 or so hours per inspection.
- 15 mins – Drive the cool little prosperbuild BMW i3 to the house.
- 120 mins – Inspect
- 10 mins – collate data sources onsite
- 15 Mins – Drive return
- 15 mins – Gopro vids
- 10 mins – Insta 360 oneX vids (plus 2 hrs processing)
- 120 mins – Produce your report
- 20 Mins – Collate data sources to cloud and stick em on the webshop.
That’s 5 hours and 25 minutes, not allowing for CPD, research, admin, overhead etc that is necessary for both our software, and technical inspecting. The new system aims to about half that!
This is kind of a round about way of saying, man, we are pretty good at collecting whack data, and doing awesome stuff with it (You want to know REDACTED about REDACTED? We already collect and compare that!) But sometimes we suck a bit at getting the material out the door where it matters to you, as fast as we would like… And if we don’t immediately jump on text messages etc, it is probably because distraction is far too easy a road to meander down, which only delays things more! (but hey, if you have ever rung me, you will know I do love a good yarn with good people!)
To that end, very shortly, our reports appearance will change – a new, more fully featured system is just around the corner, one that uses a LOT of logic, JSON, and some pretty gnarly back end gymnastics to try and punch our written report out by the time our video has finished processing, (or even before!) – its a frikken nightmare to make that look as pretty pretty as the offerings of our last few years, but we will. I have broken the system more times than I care to count, but you guys made it pretty clear – a day timeframe, in this day and age, its too long, now is far gooderer. I have worked a bunch of 14 hour days this year, with one end goal in mind – I have done enough breaking sheet, now its time to go fast (and learn everything about your property, so we can tell it to you in a way which doesn’t sound like we are speaking in martian)
Thanks for the love, and continuing support as we learn to grow better!
Jonno
Hey, one of the next steps is an easy to use CRM, that is basically JonnoProof - It has to chase me, because I am a bit rubbish at chasing it. It needs to poll me after my phone rings - was that work? What did they want? Who was it? I'll save the number and categorise it for you, without leaving it to the vagiaries of your memory! Heck, even attaching recordings might be good (forgettery, nothing to do with paranoia!) Any suggestions for an on phone app which could do that, would be well received - this one would be a pain if it has to hit the cloud!
-
Sway, Power point, Word, Dynamic Heuristic Data basing ARGH!!
Once upon a time, there was a little 14 year old nerd, who got a nice ticket that let him wag school, to fix the computers in the lab whenever they went down. Somehow I got one too, haha. Ah, the good old days of NT4.
I stayed hard out on the old computers until I guess I was about 21 or so. Then I became something more of a dabbler as superbike racing, quantity surveying and arguing on forums took over my life.
What kind of sucks about that? It means databases no longer come naturally to me – it is a hard slog.
To produce these reports, everything goes into a creaky database structure. My earnings for the last quite some time have come from writing reports, but my work for the last 2 years has been defining the data to collect, and figuring out how to meaningfully extract information, for you, from that.
In the bid to try and make that information better (read non linear, multiple levels of detail, automated informatics) I have been playing with everything in microsofts low end arsenal.
But there comes a time, when every man must recognize his limitations, and when a man recognizes a software limitation.
I have spent the last few weeks trying to get to a better system of report delivery, I hate PDF. It is so, well, limiting. Using word as the generator disallows one from easily using Iframes – which matters when half of the product is 3d models of a house, and 360 videos of it!
The goal is to take a huge wad of complex information, and distill it until you can get exactly what you need without reading swathes of gibberish.
And because I have standards, I want it to look good too.
I got the idea in my head, I might be able to use the non linear functions of powerpoint to do that – you see, word does some funny things, as noted above – It can cope with video Iframes, until you export as a PDF. I could send reports out as word documents, but that destroys the “must look pretty” imperative if you open it on a computers web viewer, or office 365 online. Can’t figure it out, works mint on mobile (where 57% of you look) but turns to jelly on a real computer. Powerpoint should have been able to deal with that. But it didn’t.
You see, making powerpoint connect to vast data sources is difficult, and formatting for variability is even harder!
I was gutted that microsoft removed graph support in sway, because in theory, though difficult to set up, and slightly undergunned, that would have been perfect for reporting. Sadly, it seems a bit like a shelved product now.
A web infrastructure that can dynamically generate reports from database content would be ideal, but there is a lot of time, learning and money to go under the bridge before I can make that work properly. That said. If you are reading this, and seeing what I am doing, and you can see the implications (no, I ain’t putting the whole business plan online for the world to see, sheesh!)
If you like what I am doing and have lazy capital, that is performing worse than the property market on mars, or mad DB, or UX, or UI, or front end, or back end skills, maybe give me a holler – 0212440865. I ain’t that much of a secret squirrel nut, and I’d like to get this cat going a bunch better and faster.
If you just like what I am doing, or are nosy (or worried), sweet. Keep watching, because it only gets better from here.
Rant out.
-
Playing with visualisation
There are a bunch of ways of visualising houses.
I like 360 Cameras – but the difference between 360 camera, and 3d is not insignificant. with a 360 Camera, you can see X and Y, but you cannot navigate the Z axis.
I also really like 3d laser scanning – there are some amazing things you can do, but economy matters – and one thing about good 3d scanners – they don’t come cheap!
Once again, I find myself playing with magicplan.
This is something of a test of that – behold, my office, with no textures or details, but a rough representation.
Have a play.
-
Mould and condensation problems, OH NO!!
I got a phone call today from a lovely lady, she is an investor, one of those good landlords.
She said this house has a mould problem. I had visions of long flowing locks of spiney mould. The fear began to grow – I put an extra organic dustmask in the car.
Imagine my surprise, when I was showed the mould issue, a little mildew, barely visible, unless the light caught it just right. She had treated it with the off the shelf cleaners several times, and was a little mystified that it kept coming back.
Now this problem was far more low level than I was anticipating. The owner was wise to try and find an intervention early.
Sometimes with condensation issues, I place data loggers throughout the house, record temperature and humidity for a few days straight, because good data is key to getting a good intervention.
Previous tenants had not had this issue – because it was a single person. Current tenants are a family – two adults breathing at night generate a fair bit of moisture. Current tenants were also forgetting to wipe down the wet windows and open the curtains in the day time!
The house is a 1940s brick state home. Positioning for sunlight is particularly woeful – it is built straight facing onto the street.
One bedroom, the one in question, will almost never see the sun. It is on the southern tip of the house. In addition, it has a partial skillion roof – where the gib is directly fixed to the bottom of the rafters. Though insulation has been retrofitted, r4.0 in the roof in general, this area is very difficult to insulate effectively. It has none at present.
The temperature differential between the insulated ceiling, and the uninsulated portion is very significant as a percentage (yeah, we could argue that zero kelvin should be the reference point, but earth never experiences that temperature – so) using 273.15 degrees kelvin as zero, which coincides nicely with the freezing point of water. 9 degrees Celsius to 6 degrees Celsius is a 33% differential. Infrared is great in these circumstances – instant diagnosis on one third of the condensation equilibrium.
If you are familiar with the World Health Organisation recommendations, you should already see a problem – recommended minimum temperature is 18 degrees inside.
So why doesn’t that landlord just get a heater, sheesh?!
Funnily enough, she has actually installed a fireplace, installed a big heat pump, and purchased a dehumidifier for the tenants to use. But they only work if they are used.
Remember, the house is well insulated, at least in the ceiling and subfloor.
To understand the issue with condensation completely requires a PhD in voodoo wizardry – Start here. But suffice to say, like cold milk left on the bench, cold surfaces cause condensation to form. Temperature gradients are the issue. To prevent condensation, either heat the air, which allows it to hold more moisture before condensation occurs or dry the air, which cracks everyones lips etc.
Heating is expensive, we want to keep it in the house once heat is generated.
So what else can she do?
The law of diminishing returns kicks in if we aren’t careful!
My suggestions for her in this house.
Install a positive air pressure system. There are pros and cons – Some systems cost a lot more than they are worth. Some off the shelf systems are fundamentally useless. What is the middle ground?
I can vouch for DVS systems – they have a few different systems, heat exchangers can be beneficial if the house is otherwise relatively well sealed. For the house we are talking about, it has a concrete tile roof, with no underlay; the ceiling is quite draughty. A simple ventilation system will help a bunch.
Also consider moisture master, smartvent – systems I can speak about from experience.
If a new Passivhaus certified home gets an arbitrary score of 100 on heating efficiency, then a rough (ad hoc, and specific to this house, not scientific) guide to the benefits of various interventions are below.
[table id=1 /]
Now the funny thing, there are overlaps – the gold standard would of course be to reline the room, with building paper and as close to an airtight barrier as could be installed, then good insulation (consider packing the walls to add extra!) then a sealed internal lining – plywood or similiar, with taped joins and penetrations, Replace the windows with evacuated, thermally broken new double (or triple) glazed units, and uprate the ceiling insulation, installing building paper under the tile roof, and then installing a ventilation system with heat recovery, and probably ducted heat.
Downside is, that would be well more than $30,000 – a years rent – if you are freehold, that might be acceptable, but if you are paying a mortgage, that is going to hurt.
So what are the reasonable interventions that won’t cost the earth?
First, in this situation, you can poke some insulation into the skillion portion – it will be difficult, but worth the effort. The insulation cannot touch the roofing material, and needs t be moisture impervious in this eave location. My favourite insulation is technobond. It is nice to work with, not itchy or dusty, doesn’t sag, and its made in Dunedin!
Second, I would look for second hand double glazing units, but if I couldn’t find any, then I would install polycarbonate.
Thirdly, I would install a good quality ventilation system. What I am looking for here, is a sensor operated system, ideally that can route airflow around the house as needed. It should have lagging/insulated piping (airlines lose a lot of heat in a short distance).
A forth suggestion to my friendly Landlady – She is giving the tenants a significant weekly discount to allow for heating.
It really annoys me to read some of the common media and comments that all landlords (with extra acid thrown at Asian landlords – guess from what extraction the subject of this post is?) don’t care about their tenants.
I suggested that she consider renting the house with “free firewood”. If the house is kept warm, it is much less likely that condensation can form – that of course much reduces the likelihood of mould ever forming.
Tenants come in all shapes, sizes and variations. If they are trying to save, maybe for their own house deposit, then it is entirely possible they will skimp on heating costs – Maybe, they simply cannot afford to heat a house. As landlords, oftentimes we are blessed with the ability to help people in these situations. You can’t turn on the heat for them, but you can remove every reason they have to not warm the place up.
So, insulation works, I’ll go into more blah blah blah on that in another post.
Making a shiney diamond out of an old state home is an expensive business.
These are a few interventions which can work in an economic fashion.
Hopefully you feel a bit more informed about those now – if you have specific questions, give me a bell, or an email or facebook or whatever, and I will try and talk you through options in your situation.
-
16 June Trademe Property review
Saint Clair, DunedinListed yesterday
Price by negotiationWow, location is awesome.Things I see: Garage rough – roadside matters, especially here in st kilda!Paint – nice easy thing to tidy up. Consider insulating walls – benefit is there, and no consent fees apply now!House is much higher than racetrack (which got fairly wet in the big floods)Sand foundations can move a bit.Has had condensation issues – query gas heater use. Easy fix, elbow grease required! Sugar soap on a new mop sponge works fairly well. Wear safety glasses, because water never is nice splashed in the eyes, Less so when it has stuff in it!Kitchen is due a pimping – fairly easy to improve on what is there.Bathroom was started, but not finished.Consider just stripping carpet, and polyurethaning floors – cheapest way – then can use mats.
North East Valley, DunedinListed yesterday
Price by negotiationI am familiar with these units – well done in general. This is out of my normal scope – but this has uniqueness on its side, plus proximity to uni.
South Dunedin, DunedinListed yesterday
Enquiries over$225,000They have done quite a lot to this house, and are not asking much money. Not much value to be dragged further out of it, maybe installing window in kitchen, and replacing roofing, plus weeding.The bottom never seems to fall out of the bottom of the market – worth a shot, but someone else has already seen that, under offer as it is listed on trademe!
Brockville, DunedinListed yesterday
To be auctionedOne of my core reno rules is simple – I want to buy a house where I cut the lawns and make 10k. BINGO!I recognise the house, because I grew up in one that is nearly identical. This is a house where, the gold standard may not be ideal – you don’t neccesarily have to reno to within an inch of its life. Just tidying the interior and exterior of the house will lift the value, while leaving someone else a clear view to make landscaping work.
Halfway Bush, DunedinListed yesterday
Price by negotiationFairly big section – As long as plaster and foundations are in good order, this is likely to be a pretty good house all in all. Would be checking the roof tiles fairly carefully, including pointwork. Also, due hills, looking for where groundwater does and doesn’t go.
Caversham, DunedinListed yesterday
Enquiries over$319,000This one has the appearance of having been continually maintained, perhaps more on the inside than outside. That said, kitchen is looking dated. New roof is always nice to see.The main value add in this one is exterior landscaping – 1:5 bleach to water solution in a garden sprayer, or a heap of water blasting.
Mornington, DunedinListed yesterday
Price by negotiationLooks like some fairly cutting edge decor – main comments – plywood floors are awesome, but can look a bit naff.Shower curtains are not the best solution – glass doors are a much better tool for keeping water in the wet zone.On the surface, pretty much all of the majors have been done – a good one if you don’t mind the odd weird maintenance thing – it is an older house after all!
Search open homes in Dunedin, Otago -
Making stuff better
I apologise in advance, but without the benefit of a pure mathematics degree, I still find myself to be a bit of a numbers geek…
What you will see soon in reports, (more noticable if you become a regular consumer,) is I will be adding some new graphs.
These bad boys are going to help you to see, at a glance, a back of envelope maintenance budget/timeframe for the house, and will allow you to sort for investment ability in the first instance. The note on my whiteboard says “Asymptote“. The note on my brain screams “Pareto!”
Captain planet says “By our powers combined…”
Bear in mind, these have NOTHING to do with NZS4306:2005 – they are some extra value I have been working on – end goal, you will be able to subscribe, and compare houses I have inspected based on what matters to you. Instead of reading blurblurbluhdeblah, or braving motion sickness watching a video, you will be able to see a specific graph. Magic!
If that has you curious enough to want to yack about it, give me a bell, I love being able to get real live feedback! I promise any such calls will give you value in return.
Cheers!
-
Verbosity
Those of you who have talked to me on the phone will quickly realise – I make the lie of the old trope of a man needing to speak half the words in a day of a woman. My wife will gladly attest. Talking, I can do. Verbosity, I got that on lock!
That said, reports written with verbosity as the means of delivery, that gets old pretty quick.
A client said to me during the week – self examination is a sign you are on the right track. I am trying to work on this – to be a more efficient speaker and writer.
I’ll try and test that theory on you.
-
Business models
I realise that business models only excite a small portion of the population – most of us are focused more on the outcome of any transaction – what we get, rather than the working parts inside that transaction.
I happen to agree with Dale Carnegie – the other persons perspective is vital.
Hence, I add this section – a way to compartmentalise my business yammering, while still making it available. My personality tests on the big 5 aspects reveal I am very open. What does that mean?
For the longest time, I have considered open sourcing this businesses financial data. I am not quite there yet, but here are a few reflections from my data collection.
Dunedin sells between 2500 and 3200 houses per year – with much less market fluctuation than many cities.
Approximately 1 out of 3 property sales have a building inspection clause.
Dunedin has 11 private building inspectors.
Each inspection takes 1.5 – 2.5 hours.
Writing a report can be done with a checkbox approach in half an hour or so – I don’t use one of those systems – It limits the value of what can be said.
My report writing/research time can vary from 1.5 hours (when I am absolutely on fire and focused!) Through to 16 hours for some of the very hairy ones. (ever tried to digest and understand a 200 page LIM?!)
That gives enough information for you to roughly calculate what building inspectors can earn – but you should also be able to work out that we have a very real theoretical cap on the amount of work we can do.
This new model aims to solve that problem – necessity is the mother of invention. At 10 inspections a week, I am forcing myself to be more efficient than I normally am.
In simpler terms, I am trying to swap a high value low turnover business model, for a significantly lower value, but much higher turnover business model. More work? Maybe, but more scalability? Yup.
Hit me up with any questions.