Tasks:

Practice with FUNcube telemetry data

To download the satellite data, copy this link to your browser:

http://warehouse.funcube.org.uk/wod.html?satelliteId=2

Click the links that marked in the figure below:

Use this one if you can't have a good data package downloaded.

Create a new Excel file, and load the .csv file into your worksheet. Plot the time as the X axis and the 'Solar Panel X mV' as the Y axis.

Truncate the data, just keep the first 300 data points. You can do this by change the number in the range:

The truncated data can looks like this:

If your X Axis automatically changes after this modification, try to bring it back by doing the following steps:

The satellite is running along the orbit, when it goes into the eclipse, there is no solar power, so the voltage becomes 0; when it goes into the bright area, the solar panel converts the solar power into voltages. So the 'Period' of this waveform should be the time it takes for the satellite to complete one orbit. Hover your mouse on two points to read the time at these two points, the differences between these two times will be the period of one orbit.

Probably the time will be around 100 min. This is typical for a Low Earth Orbit satellite.

Next, let's do a multi-plot on one graph. Add an new series by: (Use the column of 'Solar Panel +X deg C')

You will see the data looks like this:

The new data is just a flat line. The reason is the two data, one is mV, one is 'degree', they are in different units. So you want to add a new unit (Y axis) for the new data. We can use the Y axis on the right side of graph to fit the degree units in.

Do the following:

Now the new data starts making sense. Add the titles/legends to complete the plot:

Complete all the tasks above in ONE excel file.

Send your excel file to homeworkflc02@gmail.com

Due Friday