Updating access spreadsheet
Microsoft is conducting an online survey to understand your opinion of the Technet Web site.If you choose to participate, the online survey will be presented to you when you leave the Technet Web site. We’ve updated the script to reflect Fitbit’s move to only accept HTTPS requests to access their API.Make sure to update your own scripts if you’ve modified the one linked below in Step 4 (updated 10/15/14).As luck would have it one of our very own QS Meetup Organizers, Mark Leavitt from QS Portland, decided to make some modifications to that script to make it even easier to get your data.In this video below I walk you through the steps necessary to setup your very own Fitbit data Google spreadsheet. Now that you’ve set it all up your Fitbit data will automatically be downloaded to that spreadsheet.
For example, if it is your goal to maintain data integrity in a format that can be accessed by multiple users, Access is your best choice, whereas Excel is better suited for complex numerical data that you want to analyze in depth.
As you may know, there are a wide variety of charts and Google Gadgets that you can use to visualize that data.
If you’re using this method to look at your Fitbit data we want to know!
In many cases, you can use both programs, employing each for the purpose to which it is best suited.
In general, Access is better for managing data: helping you keep it organized, easy to search, and available to multiple simultaneous users.