Lw-preparation

VAST Challenge 2017 - Mini Challenge 2

Presented by: HUANG Liwei  (liwei.huang.2016@mitb.smu.edu.sg)
Visualization tool: Tableau

Introduction

Questions and Reports

Data Preparations

Comments

Data Preparation

Modifications on Source Table

1. Create an excel file for recording coordinates of monitors/factories.
   

1. Modify "Meteorological Data.xlsx", create two new columns for order index, 'index' is for overall order, 'time order' is for representing the order of each month.
   

1. Create another sheet in "Meteorological Data.xlsx", calculate the x-y coordinates based on wind directions & speed.

The formular of x coordinates is:
WindSpeed*SIN(RADIANS(WindDirection))*(-1)+'TimeOrder
The formular of y coordinates is:
WindSpeed*COS(RADIANS(WindDirection))*(-1)
Append a set of same-length values representing the original points of x-y coordinates. x is as same as the 'time order', y is 0.