coelacanth
New Member
- Joined
- Mar 31, 2012
- Messages
- 3
The SleepBot mobile app allows users to log their sleep times. I've been doing so for over a year now. The output includes a table of start and end times, but it's organized like this, with the Date referring to the Sleep Time, not the Wake Time.
<table border="0" cellpadding="0" cellspacing="0" width="267"><colgroup><col width="75"><col span="3" width="64"></colgroup><tbody><tr height="20"> <td style="height:15.0pt;width:56pt" height="20" width="75" align="center">Date</td> <td style="width:48pt" width="64" align="center"> Sleep Time</td> <td style="width:48pt" width="64" align="center"> Wake Time</td> <td style="width:48pt" width="64" align="center"> Hours</td> </tr></tbody></table><table border="0" cellpadding="0" cellspacing="0" width="267"><tbody><tr style="height:15.0pt" height="20"><td class="xl63" style="height:15.0pt; width:56pt" height="20" width="75" align="right">2/20/2012</td> <td class="xl64" style="width:48pt" width="64" align="right">19:50</td> <td class="xl64" style="width:48pt" width="64" align="right">5:00</td> <td style="width:48pt" width="64" align="right">9.16</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt" height="20" align="right">2/21/2012</td> <td class="xl64" align="right">22:20</td> <td class="xl64" align="right">5:00</td> <td align="right">6.66</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt" height="20" align="right">2/22/2012</td> <td class="xl64" align="right">20:52</td> <td class="xl64" align="right">6:15</td> <td align="right">9.38</td> </tr> </tbody></table>
The app also allows you to view an assortment of graphs, my favorite being this one:
(apparently I don't take naps in the summer).
Unfortunately, you can't edit the graphs they produce within the app, they're exported as images. How can I use the data to make my own, editable version of this graph (Excel 2010)?
<table border="0" cellpadding="0" cellspacing="0" width="267"><colgroup><col width="75"><col span="3" width="64"></colgroup><tbody><tr height="20"> <td style="height:15.0pt;width:56pt" height="20" width="75" align="center">Date</td> <td style="width:48pt" width="64" align="center"> Sleep Time</td> <td style="width:48pt" width="64" align="center"> Wake Time</td> <td style="width:48pt" width="64" align="center"> Hours</td> </tr></tbody></table><table border="0" cellpadding="0" cellspacing="0" width="267"><tbody><tr style="height:15.0pt" height="20"><td class="xl63" style="height:15.0pt; width:56pt" height="20" width="75" align="right">2/20/2012</td> <td class="xl64" style="width:48pt" width="64" align="right">19:50</td> <td class="xl64" style="width:48pt" width="64" align="right">5:00</td> <td style="width:48pt" width="64" align="right">9.16</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt" height="20" align="right">2/21/2012</td> <td class="xl64" align="right">22:20</td> <td class="xl64" align="right">5:00</td> <td align="right">6.66</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt" height="20" align="right">2/22/2012</td> <td class="xl64" align="right">20:52</td> <td class="xl64" align="right">6:15</td> <td align="right">9.38</td> </tr> </tbody></table>
The app also allows you to view an assortment of graphs, my favorite being this one:
![tzXr8.png](/board/proxy.php?image=http%3A%2F%2Fi.imgur.com%2FtzXr8.png&hash=cb22d94932f800a7adc8b7f3656ec937)
(apparently I don't take naps in the summer).
Unfortunately, you can't edit the graphs they produce within the app, they're exported as images. How can I use the data to make my own, editable version of this graph (Excel 2010)?