Excel Pivot Tables & Graphs for Sea Wave Data
Budget: $30 – $250 AUD
I need an Excel expert to generate pivot tables and graphs from my sea wave data, which is currently in CSV format.
Key Requirements:
- Pivot Tables: I want to analyze the frequency of wave heights across different months and years, and also calculate the average significant and maximum heights per month.
- Graphs: You'll need to visualize the direction of waves into 22.5 degree wedges of a compass, showing the average significant and maximum heights per month for each direction wedge.
- Automation: Crucially, I need these pivot tables and graphs to automatically update when new data is added.
Ideal Skills:
- Expertise in Microsoft Excel, particularly in creating pivot tables and graphs.
- Experience with data analysis and visualization.
- Ability to set up automatic updates in Excel.
Please only bid if you are confident in meeting these requirements.
Key Requirements:
- Pivot Tables: I want to analyze the frequency of wave heights across different months and years, and also calculate the average significant and maximum heights per month.
- Graphs: You'll need to visualize the direction of waves into 22.5 degree wedges of a compass, showing the average significant and maximum heights per month for each direction wedge.
- Automation: Crucially, I need these pivot tables and graphs to automatically update when new data is added.
Ideal Skills:
- Expertise in Microsoft Excel, particularly in creating pivot tables and graphs.
- Experience with data analysis and visualization.
- Ability to set up automatic updates in Excel.
Please only bid if you are confident in meeting these requirements.