Author Topic: Excel RTD  (Read 3292 times)

0 Members and 1 Guest are viewing this topic.

Offline Meteo Middelburg

  • Member
  • *
  • Posts: 16
Excel RTD
« on: June 08, 2019, 02:53:18 AM »
Hi,

I want to have my realtime data imported live in Excel.
The source file, .dat file, is updated every 250ms.
Ive heard the RTD function in Excel can do that, but i dont know how.


Offline Meteo Middelburg

  • Member
  • *
  • Posts: 16
Re: Excel RTD
« Reply #2 on: June 08, 2019, 01:37:22 PM »
Hi,

Thanks for your response [tup]
But unfortunately thats way above my knowledge #-o

Offline Bushman

  • Forecaster
  • *****
  • Posts: 7549
    • Eagle Bay Weather
Re: Excel RTD
« Reply #3 on: June 08, 2019, 03:13:19 PM »
What exactly are you trying to do?  Just convert a static .DAT file to Excel?  Or  add a new line to an Excel spreadsheet  every time a new .DAT file is written?
Need low cost IP monitoring?  http://wirelesstag.net/wta.aspx?link=NisJxz6FhUa4V67/cwCRWA or PM me for 50% off Wirelesstags!!

Offline Meteo Middelburg

  • Member
  • *
  • Posts: 16
Re: Excel RTD
« Reply #4 on: June 08, 2019, 03:38:31 PM »
Hi, thanks for your reply [tup]
I already have my one minute .dat file updating in excel every minute and use that data for graphing etc.

And ive got another .dat file updating every 250ms live data.
That data (a single string with wind, winddirection, temperature, humidity, solar, barometer etc.) i want to be shown in just a single cell in the same excel workboo/sheet as the one minute updating file already working.
So for example windspeed in cell A1, winddirection in A2 or B1 and so on.
Not appending, just updating in its own cell.

« Last Edit: June 08, 2019, 03:40:16 PM by Meteo Middelburg »

Offline Bushman

  • Forecaster
  • *****
  • Posts: 7549
    • Eagle Bay Weather
Re: Excel RTD
« Reply #5 on: June 08, 2019, 03:44:18 PM »
If you have it running already, why not just clone that for a single cell on a  new sheet?  Personally I would use Openpyxl (under Python)
Need low cost IP monitoring?  http://wirelesstag.net/wta.aspx?link=NisJxz6FhUa4V67/cwCRWA or PM me for 50% off Wirelesstags!!

Offline Meteo Middelburg

  • Member
  • *
  • Posts: 16
Re: Excel RTD
« Reply #6 on: June 08, 2019, 03:53:15 PM »
I have the one minute dat file updating every minute in excel.
But excel cant update faster then that with the excel auto update function.

I want the 250ms updating dat file to show data in excel to.

Offline nincehelser

  • Forecaster
  • *****
  • Posts: 3337
Re: Excel RTD
« Reply #7 on: June 08, 2019, 03:55:28 PM »
That's where you've lost me.  Why do you want to update that fast?

It seems rather excessive.  Wouldn't 2.5 seconds or so be more reasonable?

Offline Meteo Middelburg

  • Member
  • *
  • Posts: 16
Re: Excel RTD
« Reply #8 on: June 08, 2019, 03:56:36 PM »

Offline nincehelser

  • Forecaster
  • *****
  • Posts: 3337
Re: Excel RTD
« Reply #9 on: June 08, 2019, 04:10:46 PM »
I see, but realistically, weather data typically doesn't need to be sampled that fast unless you're doing something really special.

Excel's 2-second limitation would satisfy most any PWS available today.

Offline Bushman

  • Forecaster
  • *****
  • Posts: 7549
    • Eagle Bay Weather
Re: Excel RTD
« Reply #10 on: June 08, 2019, 04:11:15 PM »
Ah... I see what you are trying to do.  BTW, Excel acquires a lock to prevent another app from using it so that throws a spanner into the works UNLESS you write a special DCOM server (which is what I think the Yoctopuce thingy does).  But salvation could be close if you don't mind using a bit of Python.  Sadly, the best implementation of this without a lot of coding is PyXXL - but it costs.
Need low cost IP monitoring?  http://wirelesstag.net/wta.aspx?link=NisJxz6FhUa4V67/cwCRWA or PM me for 50% off Wirelesstags!!

Offline Meteo Middelburg

  • Member
  • *
  • Posts: 16
Re: Excel RTD
« Reply #11 on: June 08, 2019, 04:47:38 PM »
Ah ok.
Are you familiar with python?

Offline Bushman

  • Forecaster
  • *****
  • Posts: 7549
    • Eagle Bay Weather
Re: Excel RTD
« Reply #12 on: June 08, 2019, 05:56:47 PM »
Yeah, very familiar with Python.  It is pretty easy and there are code blocks all over the place.
Need low cost IP monitoring?  http://wirelesstag.net/wta.aspx?link=NisJxz6FhUa4V67/cwCRWA or PM me for 50% off Wirelesstags!!

Offline Meteo Middelburg

  • Member
  • *
  • Posts: 16
Re: Excel RTD
« Reply #13 on: June 09, 2019, 04:47:38 AM »
Do i have to install Python to get this to work in excel or has it to be made in Python and can be installed as add option in excel?

Offline Bushman

  • Forecaster
  • *****
  • Posts: 7549
    • Eagle Bay Weather
Re: Excel RTD
« Reply #14 on: June 09, 2019, 10:03:52 AM »
Well, yeah, but then you have register it via win32com etc.  Honestly, due to limitations in Excel (2 second file lock IIRC) you have to override a lot of stuff to make this work unless you buy PyXXL.  There is a fair bit of coding. 
Need low cost IP monitoring?  http://wirelesstag.net/wta.aspx?link=NisJxz6FhUa4V67/cwCRWA or PM me for 50% off Wirelesstags!!

Offline Meteo Middelburg

  • Member
  • *
  • Posts: 16
Re: Excel RTD
« Reply #15 on: June 11, 2019, 11:58:59 AM »
Mm ok. I thought i could use excel to have my live and database weather data in it.
But its likely a bit difficult to get that working.
I managed to have excel to update every second with some vb code, but that made my laptop fan spin fast and took alot of memory...
I probably stick with Loggernet then. Wich is what i used to get excel its data.

Im using Loggernet LNDB database sql ce currently. Limited to 4gb if im right.
But the advantage of excel is i could edit the data on the spot instead of having to find an sql ce editor to manipulate data if needed.

Offline Bushman

  • Forecaster
  • *****
  • Posts: 7549
    • Eagle Bay Weather
Re: Excel RTD
« Reply #16 on: June 11, 2019, 01:30:10 PM »
Excel is not the tool to use here.
Need low cost IP monitoring?  http://wirelesstag.net/wta.aspx?link=NisJxz6FhUa4V67/cwCRWA or PM me for 50% off Wirelesstags!!

Offline Meteo Middelburg

  • Member
  • *
  • Posts: 16
Re: Excel RTD
« Reply #17 on: June 11, 2019, 01:39:21 PM »
Hi,

What do you use, soft and hardware wise?

Offline Bushman

  • Forecaster
  • *****
  • Posts: 7549
    • Eagle Bay Weather
Re: Excel RTD
« Reply #18 on: June 11, 2019, 07:39:33 PM »
I would use a realtime DB like ReThinkDB or even Mongo (NoSQL) but one of the SQL dbs supported by WeeWx etc.  Excel is not a database.
Need low cost IP monitoring?  http://wirelesstag.net/wta.aspx?link=NisJxz6FhUa4V67/cwCRWA or PM me for 50% off Wirelesstags!!

Offline Meteo Middelburg

  • Member
  • *
  • Posts: 16
Re: Excel RTD
« Reply #19 on: June 12, 2019, 10:11:12 AM »
Ive installed Microsoft SQL Server 2017 yesterday, but its difficult to get it working.
I now how to add  a database, but Loggernet LNDB engine doesn run with it...

Offline Bushman

  • Forecaster
  • *****
  • Posts: 7549
    • Eagle Bay Weather
Re: Excel RTD
« Reply #20 on: June 12, 2019, 10:26:11 AM »
I am not familiar with that but https://www.campbellsci.com/lndb  Looks doable.
Need low cost IP monitoring?  http://wirelesstag.net/wta.aspx?link=NisJxz6FhUa4V67/cwCRWA or PM me for 50% off Wirelesstags!!

Offline Meteo Middelburg

  • Member
  • *
  • Posts: 16
Re: Excel RTD
« Reply #21 on: June 12, 2019, 10:27:32 AM »
Yes i know, but that has sql compact edition max 4gb...
I dont know why, maybe that editable in same way:)

Offline Bushman

  • Forecaster
  • *****
  • Posts: 7549
    • Eagle Bay Weather
Re: Excel RTD
« Reply #22 on: June 12, 2019, 10:47:41 AM »
4 GB and you are out of space?
Need low cost IP monitoring?  http://wirelesstag.net/wta.aspx?link=NisJxz6FhUa4V67/cwCRWA or PM me for 50% off Wirelesstags!!

 

anything