Categories
English Startup

My 2019 in numbers

Happy 2020! May all your companies turn into unicorns and all your projects be bought by Facebook!

I have a tendency to blindly jump into new projects, lose interest along the way and then abandon them. It’s been a constant in my carreer, so in january 2019 I decided to do something about that. I started doing timetracking on my just-for-fun projects.

Turns out I worked on 16 projects this year, some of them as little as half an hour. I have also kept note of any income generated by the projects, and calculated an hourly income. Note that I’m ignoring any costs involved (servers, transport, equipment and external labour), and all amounts are VAT excluded.

ProjectHoursRevenueHourly
Work for hire1.013,76€ 77.897,38€ 76,84
QuizWitz388,75€ 8.547,76€ 21,99
Dolumar10,25€ 78,67€ 7,68
Quizfabriek336,00€ 925,00€ 2,75
Quizkalender33,00€ 13,78€ 0,42
CatLab Drinks167,00€ 0,00€ 0,00
Kitten Race55,00€ 0,00€ 0,00
Werewolves34,00€ 0,00€ 0,00
Escape game21,00€ 0,00€ 0,00
Research project13,00€ 0,00€ 0,00
Administratie11,00€ 0,00€ 0,00
Word game11,00€ 0,00€ 0,00
Eukles8,00€ 0,00€ 0,00
Dolumar TCG6,00€ 0,00€ 0,00
Trading game2,00€ 0,00€ 0,00
Wittegeit0,50€ 0,00€ 0,00

Since this is the first year I’m doing time tracking, I don’t have running totals of the projects. The bulk of QuizWitz development has happened over the past few years, and a quick estimation shows at least 5000 hours have been put in before (by various people). However, to not completely lose my mind, I have decided to only measure this years activity.

In total, I’ve logged 2110,26 working hours, which is about 44 hours a week (at 48 weeks / year, holidays excluded).

An overview

Don’t quit your dayjob just yet is probably the lesson to learn here. I deciced to turn down a lucrative project in May, in order to take some time off and take on projects a little closer to home. It took a cut out of the hourly rate, but at least I don’t have to drive for two hours every day. But even then, pet projects don’t even come close to working for the man.

Next up: the big one. QuizWitz has been my main project for the past few years, so I’m happy to see at least some revenue coming in. Quizfabriek, a little lower on the list, should actually be added to QuizWitz as well, as any income from Quizfabriek comes in the form of license fees for QuizWitz. That brings QuizWitz to €9472,76 in revenue, or €24,36 hourly. (I’m not counting the 336 hours worked as a volunteer, since none of the other volunteers get paid either.)

The bulk of the QuizWitz revenue comes from offering support at live events and renting out equipment (so basically me doing actual work) totalling €6544,50. That means QuizWitz generated €2928,26 in software sales (including Airconsole).

Related, but not exactly the same: Quizfabriek, our now 10-headed non profit that tries to revolutionise the traditional pub quiz. As stated above, all revenue that is listed here comes out of QuizWitz license fees. All hours put in should be considered ‘unpaid voluntary work’, but just for funsies I split them up anyway.

I’m not sure what happened, but for some reason Dolumar also generated some sales this year. Not enough to keep the server running, but since this game was my first proper try to build a strategy browser game, I can’t bring myself to shutting it down. And obviously thousands of hours have sunk into the Dolumar project, so the hourly revenue is way off. Thanks for the support though!

The last project that generated any revenue was Quizkalender. This project was built to give to provide some free advertising space for our Quizfabriek quizzes. It uses data from various sites to compile the most complete overview of the Flemish quiz scene. When we’re not advertising our own quizzes, we’re using the space to show paid ads, resulting in a tiny bit of extra beer money.

On to another big time-waster, but one that has had a significant impact on the way we organise our quizzes at Quizfabriek. CatLab Drinks is a very rudimentary web based cash register system with support for NFC topup cards. It can be integrated in the QuizWitz quiz software, which allows players to order drinks from the bar during the game. When the NFC topup system is used, players can topup their card and all payments are done behind the scene, so that bartenders don’t have to worry about anything. I’ve released the code under GPLv3.

That leaves us with the projects that have had no value whatsoever. Kitten race was an attempt on an educational ‘classroom game’, but ended up being a refactor of our ‘CatLab Remote’ engine. That same refactored engine was then used to create a party game implementation of the game Werewolves (also known as Maffia in some parts of the world). Both games are still sitting on a shelf and might be released on Airconsole or Steam at some point in the future.

With Escape Game I wanted to see if the CatLab Remote engine could be used for a mass escape game, where tens to hundreds of people would try to solve a mystery or avoid a disaster, but I didn’t get much further than a few sketches.

Finally there’s a bunch of projects where I only spent a few hours on; prototypes that I still want to explore at a later stage. I even have a rough draft of a Dolumar themed card game, but it hasn’t come to the playtesting stage yet.

Technology

Overall, I’ve had a fun year. Not always productive, but I’ve played around with fun ideas and tinkered with lots of things I hardly knew anything about.

I’ve used DMX and WebMidi to automate moving lights and led pars at our quizzes. I’ve used WebRTC to stream QuizWitz to raspberry pi’s connected to displays (to avoid having to use HDMI splitters and unhandly cables).

I’ve played with NTAG213 NFC tags and readers to implement a cashless topup system and used html offline features to make sure the system runs even when internet connection fails.

I’ve made my old libraries compatible with npm and typescript, to make the game development less painful.

Oh, and I’ve also bought a new car!

Next up

I don’t think 2020 will be much different from 2019. I’ll probably try to put in some more work-for-hire hours, as you can’t spend every summer sitting on your arse, but I don’t think I’ll stop starting silly projects and giving up on them. It’s just too much fun.

I should look into more ways to get QuizWitz into the hands of event planners and quiz organisers. Everyone who’s used the software is enthousiastic and our very first client still calls us for every quiz they organise. I feel like I’m leaving a lot of potential on the table. I’m just not very confident reaching out and doing sales. Improving my business skills is pretty high on my list of new year resolutions. Or finding a cofounder who can handle that part.

Finally, I should finish renovating my tiny little house. I haven’t really done any construction work in 2019, and renovating a house of this size shouldn’t take 5 years to finish. 🙂

Categories
English

5 months of QuizWitz on Airconsole

Airconsole is an awesome project by Swiss startup ‘N-Dream’. It offers a ‘game console in the cloud‘ where the games are played on a smart tv / laptop / … and the players use smartphones to as controllers. Most games are party games, so there is an obvious match with QuizWitz.

QuizWitz has been available on Airconsole since july, and since there is very little information on how games on Airconsole generally fare (and there are no NDAs that prevent me from sharing), I’ve decided to share the results of publishing QuizWitz on the Airconsole network.

Statistics: QuizWitz is the 23th most popular game on the network, yay! I should note that the ranking changes frequently and violently, QuizWitz has been jumping between 40 and 20 for the past few weeks.
Revenue since July 2019. Lets not quit that dayjob just yet.

Airconsole has recently raised $3 million in a series A funding round, so I’m pretty excited to see where the platform is going from here.

Categories
English Mijn Wereld

How to fix a remote control (without any special products or tools)

One of my buttons from my remote has been broken for a while now. First I had to push really hard for it to work, now it doesn’t do anything anymore. So I decided to break the damn thing open and take a look inside.

The keys on most remotes are so called “dome switches”. They consist of a plastic sheet with buttons on it with a little black dot at the bottom. When the black stuff touches the pcb, the button gets pushed.

Turns out the black stuff didn’t work anymore. After doing some reading on one of ’em internets, I found out this black stuff is supposed to be conducting. Turns out my black stuff didn’t conduct anymore. I could easily fix it by buying some conducting paint or paste (according to the internets), except that I obviously didn’t want to wait a few days for the product to arrive.

On to another solution then: I took some aluminium foil and some glue and glued a tiny piece of aluminium foil to the switch. I then put everything together again and… tada! The button is working again.

Mind you that I have no clue how long the glue will hold, but with some proper glue it should be fine.

Happy glueing!

Categories
English Mijn Wereld World Wide Web

“Ye, people, hear my story”

An English post, for English people. My blogging frequency goes up another notch and I’m quicly approaching the 3 blogs a year border!

But enough about my blogging rituals. As some of you guys, my frequent visitors, might know, the National Novel Writing Month. The idea is fairly simple: write a 50000 words novel in less than one month. An easy challenge indeed; how hard can it be to write a fifty thousands word story?

Since last year, I only heard about it when it was half over, I decided to give it a try. Since I had completely forgotten about the weird contest, I heard the deadline started yesterday… yesterday. In other words, I’m starting on this in the purest form possible: without a storyline in my mind nor a letter on paper.

The only way to keep myself motivated to do this is to proclaim my victory here now. This way, if I succeed, nothing happens. But when I fail, I will fail you guys, my worthy visitors.

But do not dispair, I will finish this novel before the 30th of this month. I’ve blogged, therefor I will succeed. Bring it on, Novel! I can take you!

Categories
English World Wide Web

LinkedIn

I had some trouble logging into LinkedIn lately, so I contacted customer support.

This is the answer I got:

Categories
Dolumar English

Dolumar Art: Sneak preview

Here is a little sneak preview of what is to come 😉

Categories
Dolumar English

Dolumar Summer of Code

The Dolumar Summer of Code has began! Like we announced earlier, Dolumar would get some serious updates in august, so last wednesday we began.

More information on the renewed battle system and the improved GUI will follow soon. Most of the graphics will be replaced with brand new, very cool looking graphics and a bunch of new gameplay element will be introduced.

Stay tuned for more information!

Our main designer & art director at workSneak preview to the new Dolumar ;-)

Categories
English Mijn Wereld Spam Uncategorized

I love the Whole World

And here you can find the XKCD version of this song 😉

Categories
English World Wide Web

Thijs’ guide to UTF8

The Thijs way!
This might not be the best way, but it does work like a charm!

First of all: make sure your document is written in UTF8. This will make sure that all forms you submit (yes, even in xmlHttpRequest calls) will be encoded in UTF8.

Second: make sure that your database connection is using UTF8 aswell! Using UTF8 as charset in your fields and tables is one thing, you have to make sure that your connection is using UTF8 aswell! You can change the default charset in your mysql configuration files, but the easiest way to make sure you are using UTF8 is actually telling your connection to use UTF8.
mysql_connect (DB_SERVER, DB_USER, DB_PASS);
mysql_select_db (DB_DATABASE);
mysql_query ("SET NAMES utf8");

This way you will lose those ugly non-utf8 characters in your database.

Now let’s take a look at the xmlHttpRequest. This is fairly simple: what do you want to do? Submit a form ofcourse. What do we have to take in mind? & and = are special characters, so we can’t use those in the form. A simple escape in javascript should take care of that.

The html:
<textarea id="myfield">Some data</textarea>
<button onclick="submitForm();">Submit</button>

The javascript (function submitForm()):
// Only escape the form field
var myfield = encodeURIComponent(document.getElementById('myfield').value);
var req= getXmlHttpRequest (); // Use your own function here..
req.open ('post', 'index.php', true);
req.setRequestHeader("Method", "POST index.php HTTP/1.1");
req.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");
req.send ('myfield='+myfield);

How to receive it in PHP:
// Just remove the special url chars
$myfield = rawurldecode ($_POST['myfield']);

And that’s it really. Since your document is in UTF8 and your form fields are encoded in UTF8, the only thing you have to keep in mind is the “split symbols”. No need to encode or decode anything.

Categories
Dolumar English

SlashLife sais…

Muhaha. The first positive thing he ever said about me, and I’ve got it on logs!

[16:55] <SlashLife> Even though I’m still sure that you’re an inferior coder to me, I have to admit, that you’ve got ideas.

Now tell me that’s not positive!