Results 1 to 9 of 9

New project -- how to handle weather data

Threaded View

  1. #1
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,403

    New project -- how to handle weather data

    For Christmas, I got one of those inexpensive home weather station things. It collects data from sensors in the yard, then stores that information in a .csv file. I can pull this data onto my computer and do stuff with it, if I want. I could:

    plot data in charts to show trends with time
    analyze data for statistical information (averages, max, min, etc.)
    or whatever I want and can figure out how to do.

    My question for the group at this stage is -- how to deal with this data for maximum future flexibility and interest?

    The unit stores data every 12 minutes (120 readings/day, about 45,000 readings/year), so I will be well within Excel's limitations for a long time if I choose to import the data into Excel. But is Excel really the best place to store this information for future access?

    I'm not very proficient in pivot tables, but a pivot table seems like one good way to extract information from the broader database. But pivot tables have certain limitations (such as when you want to use a scatter plot to visualize the data).

    Filters can be used to extract subsets of the data.

    I could download an open source database program (like MySQL or something like that), and use that as the main point for accessing and extracting data.

    I guess I am seeking for some input from those who are more proficient in some of the "database type" tools as I try to set something up to access this data, before I get myself committed to any specific approach to storing and retrieving data. How would you set this up for accessing and analyzing a .csv database file like this? What considerations would you take into account? Would you use Excel exclusively, or would you prefer a separate database program?
    Attached Files Attached Files
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Change Hourly Weather Data to Simulate 15 minute increments
    By Dana_Watershed in forum Excel General
    Replies: 5
    Last Post: 02-11-2016, 02:21 PM
  2. Ploting weather data
    By pezalmendra in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-29-2012, 05:39 AM
  3. weather gadgets
    By nazar_agawin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-28-2010, 06:40 AM
  4. If i entered any project code in sheet2 display all data of that project
    By koolguys4u in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-21-2009, 03:09 AM
  5. Averaging Weather Data
    By JMD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-07-2008, 08:13 PM
  6. Weather Chart
    By David D in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-05-2005, 11:39 AM
  7. Weather data Sorting with formula
    By betomovil in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-06-2005, 02:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1