Home Automation and CP290 with Excel


Home Automation and CP290 with Excel
If you're using a CP 290 interface to do a bit of home automation and, for example, regulate your heating, you must have used the "Lighthouse" software under DOS and Windows 3.1.
Apart from the fact that this software is in English with AM and PM times, and that it wasn't very user-friendly, the biggest problem is that it no longer works, or works very poorly, on systems beyond XP.

I couldn't find a successor or evolution of Lighthouse on the web, so the idea came to me to make an Excel sheet that could drive the interface.
Excel came about quite logically, because to plan my heating I had already drawn a Gantt chart for all the modules over the week with this spreadsheet. I then transcribed the various ranges into orders for Lighthouse, which transmitted them to the interface.

So of course, if the Excel workbook could itself program the interface according to the zones on the Gantt chart, that would be very handy, and it is now...
146 K 4.2/5 (83 reviews)
Grade this page:
Comment Send by e-mail to a friend Follow this page
Last modified on: September 1st 2024

How Does It Work?

gantt gp290

It's very simple :

  1. In the file, there is a tab name "Paramétrage", write the numbers of your modules in it, as well as the room or the equipment the correspond to (there is also an abbreviated designation, about 3 letters for the forthcoming editions).
  2. Then, click on the tab "Gantt" and colour (you can choose the colour) the areas where you want the module running for the chosen days and modules,
  3. Finally, choose the tab "Lues-Reçues" and click on the "analyse Gantt " button, your diagram is translated into a board of orders for the interface.
  4. Click on the " Programmation CP 290" button and all the orders are programmed in the interface.
  5. Then, you can verify this programming (or another, if you own another software) by clicking on the "Lecture CP 290 " button, that draws a board of orders which are already programmed.

What The File Does

Everything that is explained above, more, with a single click :

a tab of the file (Framework) contains a "rough" version of the information received end sent by the interface.

What It Does Not Do (yet)

Optimizing the orders from the Gantt : It cannot detect that several modules are working at the same time and that it only requires a single order. For the time being, it send as many orders as there are modules to run.

It does not process peculiar commands of graphic downloading.

Its only way of commanding is "on" and "off" (no variation of intensity for the lamps) and it does not deal with the parameters like "yesterday", "tomorrow" and "today".

How To Use It

You just have to download the file cp290.xls (Excel 2000, 220 kb) to get almost everything

Your PC has to be able to use the port Com 1 (or other, see the source code of the file).

You can also download the benchmark documentation for programmers concerning CP 290 available on the SmartHome website.

Conclusion

Here it is, you can probably improve the all thing, but it is up to you to decide of what you need. Here is a few trail to follow if you feel like it :

Of course, if you need further information, if you want to make your contribution to the subject or give me your opinion, please send me an e-mail.

Back to top of page

Other pages you may also like
Bread oven
Bread oven
Building a bread oven was until a few years ago a job for the professionals. But now you can buy a kind of kit which allows you to build your own bred oven without professional masonry know-how. You should know that the kits only provide the main part of oven, the hearth, where you light the fire...
October 15th 20241.17 M3.6
Random menu...
Random menu...
This page presents you with a random 3-course menu: a starter, a main course and a dessert, based on the recipes on the site. You can change each dish individually, or all 3 at once, or request a menu that does not contain certain ingredients of your choice.
October 27th 2024894 K3.9
Flours
Flours
At the most basic level, wheat grain is put through a mill, which produces a white-ish powder flour... Well, actually it's not quite that simple. First of all we need to distinguish between the different grains that can be made into flour: wheat of course, but also rye, barley, buckwheat, etc. So we...
June 3rd 2024730 K 413.6
Make your own hot-wire or styrofoam cutter
Make your own hot-wire or styrofoam cutter
A filicoupeur is a hot-cutting tool for polystyrene, which can be used to enhance any piece of polystyrene you've salvaged, and to do all kinds of things with it: model building, model making, arts and crafts, and so on. See here how to make your own.
February 20th 2024512 K 433.5
A mist free mirror
A mist free mirror
I don't know if you're like me, but I find it very annoying after a shower or bath to have to wipe down the bathroom mirror 36 times with a towel just so I can see myself shaving (or putting on make-up for the girls).How do you solve this tricky problem? First of all, by looking at the cause of the...
August 29th 2023220 K 13.6

Post a comment or question
Posted by:
I am not a leaving thing
Follow this page
If you are interested in this page, you can "follow" it, by entering your email address here. You will then receive a notification immediately each time the page is modified or a new comment is added. Please note that you will need to confirm this following.
I am not a leaving thing
Note: We'll never share your e-mail address with anyone else.
Alternatively: you can subscribe to the mailing list of cooling-ez.com , you will receive a e-mail for each new recipe published on the site.

Back to top of page