Merry Christmas 2018
Plaatsoft website statistics
KerkinGouda Android App 1.1.0
PlaatSoft has released a new version of the KerkinGouda Android App in the Google Play Store.
The following changes were made:
– Back button is now working
– Portrait mode activated
Click here to download the latest version.
BassieMusic Android App 1.0
A new Android app BassieMusic is released in the Google Play Store by bplaat.
This app has the following features:
– Listen to all the music that is on your device
– fast app that costs little power for your battery
Click here to download the app
PlaatSoft Youtube channel!
Dear people since a few days ago, PlaatSoft has an official youtube channel! See trailers, gameplays and much more! Check it out and Subscribe now on YouTube.
KerkinGouda Android App 1.0.0
PlaatSoft has released this evening a KerkinGouda Android App in the Google Play Store. If you want to receive up-to-date Gouds church news on your phone, download the app!
Click here to download the latest version.
WarQuest Android App 1.0.0
A new WarQuest Android app (v1.0) is released in the Google Play Store by bplaat.
This version has the following new features:
– Zoom in and out
– Communication with server is based on HTTPS. So information exchange is encrypted end to end.
– Page scrolling is much better
Click here to download the latest version.
PlaatOnline 0.1.0
The first (very basic) version of PlaatOnline is released. I have created this project two years ago but did not released it then. Now its available for everyone. Enjoy it.
Click here to download the latest version.
WarQuest 7.1
This is the next release of WarQuest. This release contain the following changes and bug fixes:
Game Server
– Enable HTTPS for secure access
– Update copyright banner
Play
Click here to enter directly the game!
PlaatSign 1.1
The next version of PlaatSign is released and contain the following changes:
– Added parameter field to script content form.
– The parameter will used during execution of script
– Uploading script more the ones is now alowed again
– Added KerkinGouda demo script
– Added PlaatSoft demo script
– Update copyright banners
Click here to download the latest version.
PlaatSoft runs in Dutch Church

PlaatSoft software (PlaatSign and PlaatEnergy) runs on two Raspberry Pi’s in a Dutch Church “De Oostpoort” in Gouda. The created information system will provide church visitors realtime information about the energy use and energy production (more then 100 solar panels are installed on the roof) of the church building.
New website Look-and-Feel
Today this website has been renewed. The layout has been given a modern dark look. The website is now also suitable for tablets and smartphones. Depending on the device type, the look and feel of the information is adjusted. In the short term, the server hardware on which this website is running will also be modernized so that the interaction is also accelerated.
Raspberry Pi Tower

My Raspberry Pi Tower is growing steadily. At this moment I have 4 Raspberry Pi’s (mini computer) running. One Pi is designed as an Access Point to the Internet and provides the SSL offloading. Furthermore, he routes the HTTP traffic via an Apache Reverse Proxy to the underlying three Pi’s. These Pi’s are arranged as web server and provide 22 websites. The advantage of this solution is that the total energy consumption (including gigabit switch) is approximately 30 Watt and the websites still provide a good response.
The following domains are hosted on the above hardware. Each domain also has a number of subdomains
PlaatSoft.nl
PlaatResort.nl
WarQuest.nl
KerkInGouda.nl
StichtingOpenHuisGouda.nl
PlaatSoft Intro
PlaatSign 1.0.0
The next version of PlaatSign is released and contain the following changes:
- Added energy day consumption script
- Added energy month consumption script
- Added energy year consumption script
- Added gouda weatherstation script
- Added broodkruimels script
- Improve file use on disk
- Added feature to enable / disable content
- Added plaatenergy database settings to settings page
- Updated copyrights banner
- Added new version check
Click here to download the latest version.
PlaatEnergy 1.5
The next version of PlaatEnergy is released and contain the following changes:
– Added feature to edit manual solar month history
– Added cron backup script which aggregrate data older then 1 year
Click here to download the latest version.
PlaatEnergy 1.4
The next version of PlaatEnergy is released and contain the following changes:
– Added energy1_detail table to measure 3 phases (voltage, current and power) of 380VAC connection
– Added voltage day chart
– Added current day chart
– Added power day chart
– Added extra energy setting to switch on/off detail information
Click here to download the latest version.
PlaatEnergy View
I have created a nice extra view in PlaatEnergy. Check it out.

PlaatResort
The last 12 months I was very busy designing and building a small chalet on an island (1300m2) in Reeuwijk, The Netherlands. That’s the reason that the PlaatSoft software development was on hold. The house project is almost finished, so i am back again.
For more information about the house project visit:
https://family.plaatsoft.nl
https://www.plaatresort.nl
Windows 10 upgrade takes hours
This afternoon my Quad Core 3GHZ Desktop finally received the Windows 10 creator patch. It took my desktop more than 4 hours to install it. Why is a Windows 10 patch always so slow? If i upgrade a Raspberry Pi Quad Core 1.2GHZ Linux kernel it’s only take 10 minutes. Strange that low end linux hardware upgrades are must faster than high end Windows hardware. I think that the Microsoft staff must go on training to learn how to patch Operating Systems fast and without reboots 🙂
Raspberry Pi Noobs cleanup
If you want to have a nice and clean Raspberry Pi Noobs installation. Execute te followings commands to remove unless tools:
sudo apt-get purge wolfram-engine (Reduce image size with 683MB)
sudo apt-get purge sonic-pi (Reduce image size with 151MB)
sudo apt-get purge scratch (Reduce image size with 93MB)
sudo apt-get purge scratch2 (Reduce image size with 147MB)
sudo apt-get purge scratch3 (Reduce image size with 147MB)
sudo apt-get autoclean
This initial Noobs image size will now be arround 4GB 🙂
WordPress upgrade
This afternoon I have upgraded my web server.
The following changes were implemented:
– WordPress is upgrade to 4.8.4
– All WordPress plugins are upgraded to latest available version.
Google Charts zoom in dataset example
I took me a while to understand how Google Charts can be extended with a zoom/drill in data set feature. You have to add then google.visualization.events.addListener method which fetch the selected datapoint of a graph. With some extra javascript code you can reload the chart with a more detailed dataset. See example below!
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript">
google.load("visualization", "1", {packages:["bar"]});
google.setOnLoadCallback(drawChart);
function drawChart() {
var options = {
bars: "vertical",
bar: {groupWidth: "90%"},
legend: { position: "none"},
vAxis: {format: "decimal"},
isStacked:true,colors: ["#0066cc", "#808080"],vAxis: { format:"decimal", viewWindow: { min: 0, max: ".round($max_forecast+100)." } }, series: {
3: {
targetAxisIndex: 1
}
}
};
var data = google.visualization.arrayToDataTable([['','Low (kWh)','Normal (kWh)','Solar (kWh)','Forecast (kWh)'],['2006',0,0,0,0],['2007',0,0,0,0],['2008',0,0,0,0],['2009',0,0,0,0],['2010',0,0,0,0],['2011',0,0,0,0],['2012',0,0,0,0],['2013',0,0,0,0],['2014',0,0,0,0],['2015',0,0,0,0],['2016',20,20,11,278.75]]);
var chart = new google.charts.Bar(document.getElementById("chart_div"));
chart.draw(data, google.charts.Bar.convertOptions(options));
google.visualization.events.addListener(chart, "select", selectHandler);
function selectHandler(e) {
var year = data.getValue(chart.getSelection()[0].row, 0);
link("pid=30&eid=88&date="+year+"-1-1");
}
}
function link(value)
{
var form = document.forms['plaatenergy'];
var newInput = document.createElement('input');
newInput.setAttribute('type','hidden');
newInput.setAttribute('name','token');
newInput.setAttribute('value',value);
form.appendChild(newInput);
form.submit();
}
PlaatProtect 0.3
This is the next release of PlaatProtect. The release contain the following changes and bug fixes:
– Improve new version detection script
– Improve php cron job. Now no output is created anymore
– Added battery chart for all zwave devices
– Added temperature chart for all zwave devices
– Added humidity chart for all zwave devices
– Added lumaniance chart for all zwave devices
– Added location of zwave sensors on home page
– Protect scenario and panic buttons against accidental click
– Bugfix: Fix critical bug in event.php in sleep and away mode
– Bugfix: Temperature above 25.5c is now correctly measured
Click here to download the latest version.


