Raspberry Pi News

I know I'm late to the show with my own blog post about the new happenings issuing forth from the Raspberry Pi Foundation, but I figured better late than never.

A few new developments have made news recently and bode well for hobbyists and inventors alike. The first (chronologically) was the release of the compute module. This is a raspberry pi just like any other, except that the whole thing is designed onto a chip that looks just like a laptop memory module.

The cool part about this is that people can now design their own main board and slip in this tiny chip to get all the features or the raspberry. This means that the main board can be designed to fit just about any need out there from small point-and-shoot cameras to large supercomputers. The foundation came out with an example main board:

But this is just an example and a board like this could be designed to meet the inventor's needs, changing the number of pins, ports, connectors, etc.

The second bit of gooey goodness is the release of the Raspberry Pi Model B+. This is the next evolutionary (not revolutionary) step in the progression of this little platform.

This new model is pretty much backward compatible with the Model B, but adds a couple of really useful features:

• More GPIO pins - 40 pins instead of 26. (This also allows old IDE hard drive ribbon cables to be used!)
• More USB ports - 4 ports instead of 2.
• Micro SD - the SD is smaller, has a secure latch, and doesn't stick out anymore.
• Power redesign - the B+ uses less power due to better technology.
• Better audio - this should be good for my PiTunes.
• Better form factor - all the onboard ports now only come out of 2 sides instead of the 4. This should make stuffing the Pi into a small corner a bit easier. Also, the mounting holes are uniform and there are 4 of them, which should make building cases a bit easier. Also it helped pave the way for HATs (more on this later).

Some good information about the B+.

The third bit of really cool news is the release of specifications around HATs (Hardware Attached to the Top). To break it down very simply, this allows add-on boards to tell the Pi that they're connected and give specific information about themselves to the Pi. This could make connecting an add on board very simple since instructions could be included in the add on board itself that help set it up (install software, configure pins, setup shortcuts on the desktop, etc.). I haven't found the official blog post announcing it, but James Adams spoke about it in a recent interview. Here is what they're theoretically supposed to look like. I'm guessing Adafruit will be releasing a HAT starter board soon which would at least include the mounting hardware (since the holes should line up with the holes on the B+) and maybe the EEPROM and other components defined by the standard.

In case that wasn't enough, I've seen two articles recently that I've kept in my browser tabs so that I can refer to them the next time I purchase a Pi (usually every other month). The first is an update about the method used by many to turn the Pi into a video game emulator. This used to be a really complicated process that took a ton of time, but thanks to the guys over at petRockBlog and Emulation Station, this process is greatly improved. You can go straight to the source, or you can check out this article which gives instructions for the uninitiated (it's spelled out pretty clearly). I've got a B+ on order right now, so as soon as it comes in, this will be on of the first things I do with it.

And if that's not enough, here's an article about the first 5 things to do after powering on your Pi. While installing Minecraft and overclocking aren't required, they are mentioned as the most popular things to do.

Pinewood Derby Race Track Timer

This content is now being hosted on GitHub: https://github.com/sweenig/pinewoodderbytimer/

Counting Down to a date with Javascript

I recently added a couple of countdown timers to the right side of my blog for some major events coming up.  If you're wondering how I did it, I did what any self-respecting coder would do: I checked Google.

Unfortunately I didn't come up with anything that was very easy to use.  So I took what I found and modified it.  The result is here on Github.

The comments in the code should make it self explanatory.  The function can be called any number of times for any number of countdown timers on the page.  Just set a different var name and target.

PiTunes with USB Sound

Continuing my ever improving efforts towards my PiTunes system, I've made some modifications.  The most recent modifications were to address two different problems: 1) sound quality isn't great and 2) WiFi.

First, the sound quality.  We've noticed sometimes that the sound playback isn't great.  Sometimes the sound skips or pops.  This is apparently an issue with the analog audio port on the Raspberry Pi.  I'm not totally versed on it, but basically, it's not a regular audio out port.  The RPi guys skimped by not putting in a dedicated digital to audio converter (to convert the digital signal from the chip to analog) so they used a workaround that isn't great.  Since most people use the digital signal through the HDMI port it isn't a problem.  The workaround is to use a separate sound card.  I opted for a USB sound card.  They're pretty cheap and fairly ubiquitous. I got mine for $2.51 plus shipping.  Not bad.  I installed the USB card and rebooted the Pi.  Now all I had to do was get the Pi to recognize the USB sound card as the default instead of the on board analog out port.  I wouldn't have figured this one out without the help of my good friend down under, SirLagz.  He's got a lot of cool stuff about RPi on his blog.  Check it out!  No seriously, you need to look at it.
So, to disable the on board sound card, the /etc/modprobe.d/alsa-base.conf file needs to be edited.  Mine now looks like this:
# autoloader aliases #install sound-slot-0 /sbin/modprobe snd-card-0 #install sound-slot-1 /sbin/modprobe snd-card-1 #install sound-slot-2 /sbin/modprobe snd-card-2 #install sound-slot-3 /sbin/modprobe snd-card-3 #install sound-slot-4 /sbin/modprobe snd-card-4 #install sound-slot-5 /sbin/modprobe snd-card-5 #install sound-slot-6 /sbin/modprobe snd-card-6 #install sound-slot-7 /sbin/modprobe snd-card-7 # Cause optional modules to be loaded above generic modules install snd /sbin/modprobe --ignore-install snd && { /sbin/modprobe --quiet snd-ioctl32 ; /sbin/modprobe --quiet snd-seq ; : ; } install snd-rawmidi /sbin/modprobe --ignore-install snd-rawmidi && { /sbin/modprobe --quiet snd-seq-midi ; : ; } install snd-emu10k1 /sbin/modprobe --ignore-install snd-emu10k1 && { /sbin/modprobe --quiet snd-emu10k1-synth ; : ; } # Keep snd-pcsp from beeing loaded as first soundcard options snd-pcsp index=-2 # Keep snd-usb-audio from beeing loaded as first soundcard #options snd-usb-audio index=-2 # Prevent abnormal drivers from grabbing index 0 options bt87x index=-2 options cx88_alsa index=-2 options snd-atiixp-modem index=-2 options snd-intel8x0m index=-2 options snd-via82xx-modem index=-2

 After a reboot, the USB device became the primary.  Then I had to update my script so that it would change the volume on the proper output port.  To find out what it had to be changed to, I ran alsamixer and looked at the name at the bottom of the slider.  In my case, the name was 'Speaker'.  So, here's what my script looks like now.  I've tested it once, we'll see how it works tonight.  So far, the sound quality is much better:

#!/bin/sh logfile=/home/pi/PiTunes.log echo \<hr /\> >> $logfile echo \<br /\>$(date "+%D %T") - finding mod of date >> $logfile whichday=$(( ($(date "+%s") / 86400) % 3 )) echo \<br /\>$(date "+%D %T") - determining folder to play >> $logfile case $whichday in 0) playlist="music";; 1) playlist="waves";; 2) playlist="nothing";; esac echo \<br /\>$(date "+%D %T") - playing $playlist >> $logfile if [ "$whichday" -ne 2 ]; then echo \<br /\>$(date "+%D %T") - starting mplayer >> $logfile mplayer -slave -nolirc -shuffle -loop 0 /home/pi/PiTunes/$playlist/* & mplayerpid=$! vol=0 amixer -q set Speaker $vol% echo \<br /\>$(date "+%D %T") - volume set to $vol >> $logfile echo \<br /\>$(date "+%D %T") - ramp up the volume by 1% then wait 1 second >> $logfile while [ $vol -le 100 ] do amixer -q set Speaker $vol% echo \<br /\>$(date "+%D %T") - setting the volume to $vol >> $logfile vol=`expr $vol + 1` sleep 1 done echo \<br /\>$(date "+%D %T") - play for 3 hours >> $logfile sleep 10800 echo \<br /\>$(date "+%D %T") - reset volume to 99, instead of 101 >> $logfile vol=99 echo \<br /\>$(date "+%D %T") - ramp down the volume by 1% then wait 10 seconds >> $logfile while [ $vol -ge 0 ] do amixer -q set Speaker $vol% echo <br />$(date "+%D %T") - setting the volume to $vol >> $logfile vol=`expr $vol - 1` sleep 10 done echo \<br /\>$(date "+%D %T") - finished ramping up and down >> $logfile echo \<br /\>$(date "+%D %T") - killing mplayer >> $logfile kill $mplayerpid fi

My Wallpaper Collection

I have amassed a fairly large collection of wallpapers over the years.  At one point, I decided to start over since I was tired of all the wallpapers I had.  My new wallpaper collection only uses high resolution photos from themes or other sources that look really good on high resolution monitors.

If you want to have a copy of my wallpaper collection, you can get it using BTSync (more info here), which will also allow you to get any new wallpapers I add to my collection (I usually add 5-8 per week).  If you haven't already, install the app, then add a new sync folder.  Choose where you want my wallpapers to be stored, then put the following in for the secret:

BFVR62FRM2AOZT3TLBISA2MLNZJ4XO5CA

This should get you started downloading.  Whenever I add new wallpapers, you'll get them.  If there are any you don't want, just delete them.

If you need help setting up your wallpaper to cycle through these images, go here.  The only instruction I would add is in step 3, browse to the folder where the pictures are being downloaded.

Cycling DIVs on a web page

Just before my boys were born, I installed a Foscam IP Camera on the ceiling of their room.  I have enjoyed being able to check on the boys as they're napping or sleeping in their cribs.  The model I got has pan/tilt capabilities and a microphone built in.  So, I can hear them breathing or crying and focus on one or the other.  I can do all this without opening their door.  Also, since it's mounted on the ceiling, they don't ever notice it.  It's equipped with a bank of IR LEDs around the lens that turn on whenever the room is too dark, so I can even look in on them when their room is completely dark.  I found a decent iPhone app that allows me to connect to the camera.  I could even hook up some speakers to the camera and use a feature of the app to talk to the boys in their room.  Not much different than a baby monitor.

Since then, a three pack of outdoor cameras went on sale so I went ahead and purchased them.  I mounted them on my front porch, and the back corner of the house overlooking the back door and the sideyard approaching the gate.  The cameras have motion detection and automatic file uploading, so I get a picture every time the lawn guys approach the gate and any time a solicitor approaches the front door.  I also built a simple html page displaying the feed from all four cameras on one page.  Unfortunately, at the highest resolution (and why wouldn't I want the highest resolution?) the four feeds don't show up on a single page unless i scale the page to 75%.  This is easy to do and Chrome even remembers that when I am looking at that page to automatically scale it down to 75%.  This has worked well, but I've always wanted a better way.

Yesterday, I finally got the tricky parts of what I really wanted to do worked out.  The goal was to have a web page that would show all four feeds but only show one at a time.  The page should cycle through each video feed and stay on it for a few seconds before moving on to the next feed.  You wouldn't expect this to be too difficult and in the end, it really wasn't.  This is the first version and the intent of this post is not to show the finished code for my page but to show how DIV elements on a web page can be cycled.

To start with, here is the html page with the DIV elements:
<div id="containerDiv2"> <div id="Div1" style="display:block;"> Div1</div> <div id="Div2" style="display:none;"> Div2</div> <div id="Div3" style="display:none;"> Div3</div> <div id="Div4" style="display:none;"> Div4</div> </div>

In my situation, each DIV contains the code to display the video feed from a single camera. The first DIV starts out visible while the rest are hidden. This doesn't really matter since the first time the javascript runs it will reset everything anyway. Technically, all four DIVs could start out hidden or displayed.

Here is the javascript code itself.  The comments should make it pretty self explanatory.  The very bottom starts the function running.  At the end of the function, the setTimeout command instructs the browser to call the function again after 1000 seconds.  This could be modified to read from an input box so that the user can adjust the cycle speed.  I guess i could look for some gauges out there to make it pretty. <div id="nextdiv" style="display:none;"> 0</div> <script> var containerDiv = document.getElementById("containerDiv2"); //specifies the container of the divs to cycle var innerDivs = containerDiv.getElementsByTagName("DIV"); //grabs an array of each of the divs var numdivs=innerDivs.length; //gets the total number of divs (affects rollover) function switchdivs() { //function to switch to the next div var nextdiv=document.getElementById("nextdiv").innerHTML //grabs the index of the div to display next nextdiv=parseInt(nextdiv); //converts the nextdiv index to an actual number (instead of a string) for(var i=0; i<innerDivs.length; i++){ //loops through each div in the container if(i==nextdiv){ innerDivs[i].style.display="block"; //if the current index is the index //of the nextdiv, display it } else { innerDivs[i].style.display="none"; //if the current index is not the index //of the nextdiv, hide it } } nextdiv=nextdiv+1; //increment the nextdiv index if(nextdiv==numdivs){nextdiv=0;} //if the currentdiv is the last one, roll over to the beginning document.getElementById("nextdiv").innerHTML=nextdiv; //store the nextdiv value in the hidden div for use next time var keepgoing=setTimeout("switchdivs()",1000); //set the function to repeat after 1000 seconds } window.onload=switchdivs(); //start the function switchdivs() for the first time </script> I had to get a little sloppy by storing the next div index in a hidden div. This was the easiest way that I as a non-programmer could avoid problems with global vs. local variables in the function. Theoretically, this could be used for any number of DIVs within the container DIV.  There are some fun transition effects available in the webkit and through CSS3, but like I said, that's not what this post is about.

Thanks to SirLagz for helping me debug my code and check my syntax (it's amazing what a missing double quote will do)!

PiTunes

Previously, I posted my experience automating iTunes for use in the nursery.  That has been working very well and I wouldn't normally see any reason to change it.  However, since I recently acquired a Raspberry Pi, I've had several ideas about what to do with it.  The idea that won was to replace the nursery room computer (which was already a Dell Studio Hybrid small form factor PC).  The advantages would be that the Pi is fanless and quite a bit smaller.  I could also then reuse the Dell Hybrid for other things.

The same objectives apply:

1. I want the music to come on and turn off by itself
2. I don't want the music to start off at full blast in case we've put the boys down early.    
3. I want the music to play whenever we put the boys to sleep, which could be as early as 7pm but as late as 9pm.
4. I want to be able to rotate playlists so it's not the same thing every night.
5. I want to be able to kick off the music any time.
6. I want to be able to manually override either the current song or the current volume level.

So, of course the first thing I did was download the Rasbian image and get it booted up, connected via SSH, and downloading updates.  I'll assume if you're also trying to do this that you'll use the instructions at RaspberryPi.org to get you started with that.  To get the most recent updates, type sudo apt-get update && sudo apt-get upgrade.  This may take a while, depending on your internet speed.  The Raspberry Pi doesn't have that much CPU either, so you might just kick this one off and go to bed.

I also purchased a Netgear G54/N150 Wireless USB Micro Adapter and plugged it in.  I'm a Windows guy, so most of what Linux does appears magical to me.  I had a suspicion that the Raspberry Pi would get on my wifi all by itself.  Of course it didn't because at the very least it didn't have my SSID and WPA pre-shared key (the password).  I was lucky enough that the Raspbian distribution recognized it and fired it up without requiring me to load any drivers (thank the stars!).  I verified this by issuing an iwconfig command.  This showed me that it was all ready to go.  Since my network uses WPA2 encryption, I had to configure a built in utility called supplicant.  In the end, all I had to do was edit /etc/wpa_supplicant/wpa_supplicant.conf and add a couple lines:

ctrl_interface=DIR=/var/run/wpa_supplicant GROUP=netdev
update_config=1

network={
    ssid="Hobbiton"
    proto=RSN
    key_mgmt=WPA-PSK
    pairwise=CCMP TKIP
    group=CCMP TKIP
    psk="yeahright"
}

Much documentation online says all you have to do to get it working is bring the interface down and back up.  I wasn't able to get it to grab a DHCP address without rebooting the Pi. To get the interface to come online at boot time, I added ifup wlan0 to /etc/rc.local.

After I got the Pi up and running, it was time to install a few things that aren't included in the base image.  Mainly, I needed mplayer (that's the media player that will actually play the music) and ffmpeg (a bunch of codecs that will allow mplayer to play all kinds of files including mp3 and m4a).  I also wanted to be able to access the log file from wherever, so I decided to install a lightweight web server.  I'll log to index.html in the www folder.  Type sudo apt-get install lighttpd mplayer ffmpeg and sit back for a while.    

The next thing is to get the actual music onto the Raspberry Pi.  At first, I started out by putting all the music (and my scripts) on a USB stick.  In order to give the Pi access to a USB drive, just follow the instructions here.  I eventually went instead with a network attached hard drive, so I followed the instructions here to create a persistent mount to my NAS.  After a while, I noticed some jitter in the music, so I moved the data back to the SD card (where the OS is also installed).  I'm trying to listen now to see if that makes a difference to the jitter.

Now, on to the script.  The script runs as a cron job.  The comments should explain exactly what's happening.

By the way, the contents of /mnt/nas/PiTunes are: christmas/  nothing/  music/  play.sh  waves/.  Version 2 of the script will play the Christmas directory instead of the music directory during the month of December.

The next part involves running the script from CRON, which is equivalent to Windows' Scheduled Tasks.  To add jobs, just run crontab -e.  The format is one job per line, parameters separated by spaces:
* * * * * command to be executed ┬ ┬ ┬ ┬ ┬ │ │ │ │ │ │ │ │ │ │ │ │ │ │ └───── day of week (0 - 7) (0 or 7 are Sunday, or use names) │ │ │ └────────── month (1 - 12) │ │ └─────────────── day of month (1 - 31) │ └──────────────────── hour (0 - 23) └───────────────────────── min (0 - 59)

Mine looks like this:
29 18 * * * pi /mnt/nas/PiTunes/sound.sh 30 18 * * * pi python /mnt/nas/PiTunes/play.py

So, let's look at the objectives again:

1. I want the music to come on and turn off by itself - check!
2. I don't want the music to start off at full blast in case we've put the boys down early - check!
3. I want the music to play whenever we put the boys to sleep, which could be as early as 7pm but as late as 9pm - check!
4. I want to be able to rotate playlists so it's not the same thing every night - check!
5. I want to be able to kick off the music any time - this can be done, although it's not as easy.  I have to ssh to the Raspberry Pi and kick off the script manually.  However, if it's a silent day, nothing will happen.  I'll probably look at a way to adjust the script so that when it's called from CRON it does its normal thing but when called from command line it always plays music.
6. I want to be able to manually override either the current song or the current volume level - This can also be done, but it's not as easy.  While in ramp up or ramp down mode, the volume doesn't increase/decrease by 1, it gets set to a particular level.  Overriding the volume during ramp up/down won't make any difference because as soon as the script loops it will reset the volume to right back where it was.  I may be able to change this in the future.  While playing, I can change the volume by logging in via SSH and issuing amixer -q set PCM X% where X is the volume I want to set to.  However, during ramp down, the volume starts back at 100% before dropping down.  It may not take much, but the next version may have an increment/decrement instead of fixed volume levels.  If I get this working, this objective will be met.

Some of the plans I have for the future are an automatic switch over to Christmas music instead of regular music during the month of December, web service based controls, & incremental/decremental volume controls.  We'll see when I have time to work on it.

Raspberry Pi

Today I joined the latest craze sweeping the Internet.  No, not Vadering (although I should look into how that could be done with the boys).  I bought two brand new computers today.  It cost me a total of $70 + shipping.  Well, actually, I didn't buy the whole computer, I just bought the motherboard, which has the processor, RAM, video card (with HDMI and analog RCA out), audio card, SD card reader, onboard NIC and 2x USB ports.  It's all built into a special little PCB (printed circuit board) that takes advantage of SOC (system on a chip: basically the main guts of a computer all on one chip, similar to most tablets and phones).

It's called Raspberry Pi and is produced by a non-profit organization that designed them to be used in developing countries for education.  Since it's a charity, they designed the board to be extremely cheap and can sell it for $35!  They're currently being distributed through three reseller partners officially.  Each reseller also sells in bulk to other companies so you can find them elsewhere.  The main drive for resellers is the accessories that go a long with it (more about this later).  RS (only in Europe), Allied Electronics, and Element14 (through Newark) are the official resellers.  For more information, check out the video below or read this article.

I ordered two of them today because for a long time both model A and model B were out of stock everywhere.  My dad reminded me last night that they were back in stock so I got one for him and one for me this morning.  Here's a good video to introduce what's really behind it.
It should be here within a few days.  All that actually comes in the box is the board, no case, no cables, no nothing.  So, I'll go dumpster diving into my crates of extra parts in the garage for a 700mA USB power supply (I wonder if the dual USB plug for my portable hard drive would allow this to be powered from my USB hub...), HDMI to VGA converter so I can plug it into my desk monitor, a USB keyboard and a USB mouse (maybe I'll use my Bluetooth dongle and the Logitech diNovo Mini keyboard...), and an SD card.  I think I'll start by running Rasbian Wheezy, just to see how well it performs normal desktop tasks.  After that I'm going to use it as a test bed for XBMC with RaspBMC to potentially replace my current Windows Media Center dependent installation.

Anyway, I'll try to post my progress as things go along.  Eventually, I'll be looking into putting this thing into a case and see what happens.  Here are some of the cases I'm looking at

I might even consider making a competitor to the iMac:

 versus 

The Law of Averages

The Law of Averages is not actually a law, but really just a lay term for some mathematical principles either completely unfounded in any mathematical law or borrowed from the Law of Large Numbers.  For more information, see this Wikipedia article.  However, this post is titled 'The Law of Averages' because I wanted to go into some detail about averaging averages.

In particular, I was asked this question: "If I have a data point for every minute of the data, I also have an average of 15 data points for every 15 minute period of the day, and I wanted to calculate the daily average, it would be better to use the 1 minute data versus the 15 minute averages (aka rollup data).  The average of the 15 minute averages would really be an average of averages and is therefore not accurate."

The reality is actually contrary to that thinking.  The average of averages of data is exactly the same as the average of the same source data.  To illustrate this, let's look at some data.

Below, we have random numbers between 0 and 100 to represent our data.  We have one data point for each minute of the day.  Every 15 minutes, an average is calculated.  For example, at 0:30 an average is calculated averaging the points from 0:30-0:44.

Time	1 Minute Data	15 Minute Average
0:00	37	51.6666666666667
0:01	74
0:02	49
0:03	21
0:04	59
0:05	15
0:06	32
0:07	69
0:08	40
0:09	26
0:10	87
0:11	38
0:12	96
0:13	79
0:14	53
0:15	60	25.8
0:16	35
0:17	7
0:18	24
0:19	46
0:20	3
0:21	22
0:22	1
0:23	39
0:24	9
0:25	34
0:26	0
0:27	42
0:28	34
0:29	31
0:30	4	33.8
0:31	5
0:32	81
0:33	36
0:34	35
0:35	9
0:36	36
0:37	41
0:38	76
0:39	93
0:40	21
0:41	12
0:42	10
0:43	21
0:44	27
0:45	5	48.8
0:46	42
0:47	83
0:48	48
0:49	18
0:50	79
0:51	24
0:52	78
0:53	19
0:54	5
0:55	52
0:56	100
0:57	39
0:58	70
0:59	70
1:00	14	44.0666666666667
1:01	45
1:02	82
1:03	34
1:04	74
1:05	90
1:06	33
1:07	10
1:08	43
1:09	24
1:10	96
1:11	12
1:12	17
1:13	62
1:14	25
1:15	96	54.7333333333333
1:16	19
1:17	91
1:18	58
1:19	76
1:20	24
1:21	86
1:22	35
1:23	48
1:24	31
1:25	67
1:26	72
1:27	9
1:28	45
1:29	64
1:30	79	40.4
1:31	68
1:32	0
1:33	10
1:34	30
1:35	23
1:36	65
1:37	74
1:38	53
1:39	78
1:40	4
1:41	3
1:42	38
1:43	78
1:44	3
1:45	91	47.6
1:46	85
1:47	44
1:48	4
1:49	6
1:50	13
1:51	39
1:52	93
1:53	52
1:54	35
1:55	49
1:56	69
1:57	67
1:58	64
1:59	3
2:00	11	56.8666666666667
2:01	72
2:02	54
2:03	45
2:04	16
2:05	17
2:06	75
2:07	96
2:08	96
2:09	62
2:10	80
2:11	55
2:12	96
2:13	34
2:14	44
2:15	73	46.6666666666667
2:16	57
2:17	21
2:18	61
2:19	28
2:20	11
2:21	16
2:22	1
2:23	86
2:24	23
2:25	64
2:26	89
2:27	46
2:28	38
2:29	86
2:30	42	45.8
2:31	15
2:32	7
2:33	3
2:34	40
2:35	41
2:36	8
2:37	66
2:38	1
2:39	85
2:40	59
2:41	89
2:42	94
2:43	42
2:44	95
2:45	64	57.6
2:46	58
2:47	6
2:48	14
2:49	17
2:50	100
2:51	85
2:52	72
2:53	93
2:54	58
2:55	100
2:56	32
2:57	53
2:58	36
2:59	76
3:00	4	38.7333333333333
3:01	19
3:02	32
3:03	14
3:04	84
3:05	26
3:06	17
3:07	65
3:08	20
3:09	15
3:10	26
3:11	52
3:12	79
3:13	31
3:14	97
3:15	8	55.6666666666667
3:16	47
3:17	87
3:18	66
3:19	23
3:20	88
3:21	28
3:22	53
3:23	87
3:24	66
3:25	32
3:26	71
3:27	87
3:28	10
3:29	82
3:30	84	54.9333333333333
3:31	81
3:32	54
3:33	88
3:34	77
3:35	98
3:36	2
3:37	15
3:38	92
3:39	72
3:40	16
3:41	45
3:42	4
3:43	60
3:44	36
3:45	84	63.4666666666667
3:46	97
3:47	87
3:48	29
3:49	53
3:50	11
3:51	84
3:52	83
3:53	76
3:54	64
3:55	50
3:56	36
3:57	83
3:58	38
3:59	77
4:00	3	64.1333333333333
4:01	79
4:02	90
4:03	91
4:04	46
4:05	53
4:06	26
4:07	77
4:08	46
4:09	62
4:10	60
4:11	93
4:12	78
4:13	92
4:14	66
4:15	35	37.1333333333333
4:16	81
4:17	42
4:18	50
4:19	14
4:20	26
4:21	72
4:22	4
4:23	15
4:24	65
4:25	14
4:26	9
4:27	10
4:28	38
4:29	82
4:30	14	51
4:31	48
4:32	62
4:33	36
4:34	89
4:35	3
4:36	53
4:37	58
4:38	86
4:39	71
4:40	49
4:41	67
4:42	20
4:43	96
4:44	13
4:45	0	47.3333333333333
4:46	91
4:47	64
4:48	28
4:49	96
4:50	23
4:51	37
4:52	37
4:53	77
4:54	15
4:55	13
4:56	98
4:57	7
4:58	58
4:59	66
5:00	48	48.6
5:01	22
5:02	5
5:03	76
5:04	96
5:05	5
5:06	10
5:07	3
5:08	34
5:09	56
5:10	82
5:11	96
5:12	58
5:13	80
5:14	58
5:15	48	48.1333333333333
5:16	30
5:17	50
5:18	71
5:19	12
5:20	12
5:21	98
5:22	24
5:23	41
5:24	21
5:25	66
5:26	24
5:27	99
5:28	73
5:29	53
5:30	8	37.3333333333333
5:31	67
5:32	17
5:33	0
5:34	0
5:35	37
5:36	51
5:37	33
5:38	28
5:39	58
5:40	3
5:41	74
5:42	79
5:43	90
5:44	15
5:45	56	55.7333333333333
5:46	82
5:47	66
5:48	64
5:49	69
5:50	94
5:51	81
5:52	23
5:53	22
5:54	41
5:55	16
5:56	89
5:57	47
5:58	74
5:59	12
6:00	70	49.2666666666667
6:01	72
6:02	76
6:03	28
6:04	62
6:05	28
6:06	46
6:07	62
6:08	61
6:09	34
6:10	52
6:11	69
6:12	12
6:13	37
6:14	30
6:15	79	51.8666666666667
6:16	35
6:17	74
6:18	71
6:19	12
6:20	52
6:21	72
6:22	6
6:23	89
6:24	16
6:25	17
6:26	30
6:27	64
6:28	76
6:29	85
6:30	47	42.8666666666667
6:31	44
6:32	46
6:33	46
6:34	2
6:35	83
6:36	12
6:37	24
6:38	47
6:39	94
6:40	32
6:41	70
6:42	70
6:43	24
6:44	2
6:45	77	54.2
6:46	1
6:47	27
6:48	47
6:49	18
6:50	75
6:51	46
6:52	83
6:53	58
6:54	24
6:55	58
6:56	81
6:57	65
6:58	57
6:59	96
7:00	34	66.8666666666667
7:01	99
7:02	79
7:03	75
7:04	89
7:05	92
7:06	63
7:07	47
7:08	49
7:09	93
7:10	45
7:11	40
7:12	97
7:13	41
7:14	60
7:15	56	52.0666666666667
7:16	71
7:17	92
7:18	31
7:19	68
7:20	1
7:21	3
7:22	64
7:23	21
7:24	7
7:25	82
7:26	8
7:27	99
7:28	96
7:29	82
7:30	97	51.4
7:31	5
7:32	1
7:33	82
7:34	67
7:35	30
7:36	29
7:37	89
7:38	53
7:39	80
7:40	14
7:41	88
7:42	73
7:43	36
7:44	27
7:45	53	47.4666666666667
7:46	47
7:47	55
7:48	4
7:49	46
7:50	65
7:51	47
7:52	21
7:53	25
7:54	51
7:55	87
7:56	24
7:57	46
7:58	75
7:59	66
8:00	63	41.5333333333333
8:01	46
8:02	69
8:03	58
8:04	14
8:05	21
8:06	83
8:07	75
8:08	23
8:09	12
8:10	60
8:11	63
8:12	6
8:13	9
8:14	21
8:15	53	40.6
8:16	42
8:17	22
8:18	0
8:19	65
8:20	6
8:21	66
8:22	16
8:23	85
8:24	8
8:25	78
8:26	44
8:27	86
8:28	30
8:29	8
8:30	98	68.3333333333333
8:31	81
8:32	93
8:33	66
8:34	60
8:35	27
8:36	84
8:37	62
8:38	81
8:39	76
8:40	94
8:41	19
8:42	60
8:43	38
8:44	86
8:45	92	47.7333333333333
8:46	39
8:47	18
8:48	49
8:49	36
8:50	57
8:51	59
8:52	84
8:53	8
8:54	36
8:55	14
8:56	48
8:57	51
8:58	67
8:59	58
9:00	73	44.7333333333333
9:01	90
9:02	59
9:03	2
9:04	1
9:05	2
9:06	33
9:07	51
9:08	33
9:09	81
9:10	2
9:11	93
9:12	79
9:13	18
9:14	54
9:15	87	48.8666666666667
9:16	75
9:17	33
9:18	19
9:19	24
9:20	14
9:21	45
9:22	13
9:23	93
9:24	54
9:25	69
9:26	12
9:27	2
9:28	99
9:29	94
9:30	42	44.4666666666667
9:31	70
9:32	83
9:33	20
9:34	66
9:35	10
9:36	35
9:37	74
9:38	18
9:39	35
9:40	7
9:41	64
9:42	67
9:43	55
9:44	21
9:45	48	53.4
9:46	91
9:47	88
9:48	3
9:49	11
9:50	45
9:51	8
9:52	20
9:53	96
9:54	17
9:55	76
9:56	78
9:57	54
9:58	99
9:59	67
10:00	18	53.5333333333333
10:01	52
10:02	33
10:03	19
10:04	65
10:05	88
10:06	56
10:07	99
10:08	18
10:09	98
10:10	50
10:11	46
10:12	42
10:13	53
10:14	66
10:15	61	58.5333333333333
10:16	84
10:17	66
10:18	44
10:19	43
10:20	8
10:21	26
10:22	77
10:23	55
10:24	85
10:25	6
10:26	91
10:27	66
10:28	66
10:29	100
10:30	74	46.3333333333333
10:31	70
10:32	10
10:33	72
10:34	35
10:35	19
10:36	86
10:37	72
10:38	7
10:39	31
10:40	95
10:41	35
10:42	46
10:43	2
10:44	41
10:45	45	46.3333333333333
10:46	85
10:47	3
10:48	11
10:49	48
10:50	90
10:51	59
10:52	40
10:53	26
10:54	9
10:55	94
10:56	7
10:57	70
10:58	31
10:59	77
11:00	67	47
11:01	78
11:02	59
11:03	0
11:04	70
11:05	77
11:06	71
11:07	49
11:08	51
11:09	63
11:10	21
11:11	21
11:12	50
11:13	11
11:14	17
11:15	4	46.9333333333333
11:16	54
11:17	9
11:18	49
11:19	30
11:20	82
11:21	41
11:22	22
11:23	33
11:24	29
11:25	78
11:26	88
11:27	37
11:28	84
11:29	64
11:30	23	47.4666666666667
11:31	50
11:32	8
11:33	50
11:34	24
11:35	84
11:36	53
11:37	78
11:38	80
11:39	2
11:40	61
11:41	89
11:42	77
11:43	16
11:44	17
11:45	19	36.2666666666667
11:46	64
11:47	85
11:48	9
11:49	30
11:50	24
11:51	5
11:52	10
11:53	59
11:54	7
11:55	42
11:56	21
11:57	69
11:58	55
11:59	45
12:00	37	48.0666666666667
12:01	60
12:02	85
12:03	44
12:04	28
12:05	89
12:06	35
12:07	18
12:08	48
12:09	64
12:10	3
12:11	38
12:12	96
12:13	5
12:14	71
12:15	71	46.4
12:16	93
12:17	37
12:18	7
12:19	38
12:20	85
12:21	28
12:22	86
12:23	12
12:24	65
12:25	38
12:26	6
12:27	66
12:28	24
12:29	40
12:30	26	42
12:31	98
12:32	74
12:33	13
12:34	46
12:35	52
12:36	39
12:37	14
12:38	38
12:39	25
12:40	28
12:41	30
12:42	44
12:43	63
12:44	40
12:45	96	41.0666666666667
12:46	13
12:47	50
12:48	8
12:49	43
12:50	27
12:51	38
12:52	97
12:53	0
12:54	11
12:55	84
12:56	73
12:57	11
12:58	20
12:59	45
13:00	39	60.1333333333333
13:01	94
13:02	95
13:03	82
13:04	39
13:05	26
13:06	80
13:07	70
13:08	19
13:09	79
13:10	74
13:11	78
13:12	16
13:13	20
13:14	91
13:15	58	46
13:16	67
13:17	52
13:18	55
13:19	47
13:20	25
13:21	8
13:22	78
13:23	53
13:24	55
13:25	43
13:26	9
13:27	28
13:28	56
13:29	56
13:30	26	27.7333333333333
13:31	5
13:32	17
13:33	2
13:34	53
13:35	9
13:36	5
13:37	63
13:38	91
13:39	46
13:40	7
13:41	23
13:42	25
13:43	3
13:44	41
13:45	94	49.0666666666667
13:46	70
13:47	49
13:48	60
13:49	59
13:50	51
13:51	71
13:52	16
13:53	37
13:54	31
13:55	13
13:56	64
13:57	76
13:58	30
13:59	15
14:00	0	32.5333333333333
14:01	6
14:02	7
14:03	13
14:04	52
14:05	25
14:06	53
14:07	15
14:08	65
14:09	70
14:10	72
14:11	12
14:12	23
14:13	23
14:14	52
14:15	87	50.9333333333333
14:16	98
14:17	24
14:18	60
14:19	32
14:20	31
14:21	10
14:22	63
14:23	28
14:24	20
14:25	42
14:26	90
14:27	43
14:28	81
14:29	55
14:30	60	53.7333333333333
14:31	45
14:32	98
14:33	96
14:34	11
14:35	14
14:36	3
14:37	97
14:38	63
14:39	29
14:40	23
14:41	96
14:42	35
14:43	89
14:44	47
14:45	67	58.4666666666667
14:46	41
14:47	66
14:48	70
14:49	98
14:50	47
14:51	37
14:52	68
14:53	61
14:54	16
14:55	70
14:56	19
14:57	46
14:58	100
14:59	71
15:00	97	56.7333333333333
15:01	65
15:02	99
15:03	60
15:04	54
15:05	3
15:06	60
15:07	79
15:08	30
15:09	50
15:10	37
15:11	54
15:12	51
15:13	63
15:14	49
15:15	27	43.0666666666667
15:16	10
15:17	77
15:18	82
15:19	15
15:20	55
15:21	68
15:22	74
15:23	11
15:24	0
15:25	72
15:26	49
15:27	62
15:28	41
15:29	3
15:30	54	64.8666666666667
15:31	86
15:32	95
15:33	31
15:34	45
15:35	71
15:36	100
15:37	59
15:38	43
15:39	15
15:40	88
15:41	3
15:42	97
15:43	88
15:44	98
15:45	76	49.7333333333333
15:46	17
15:47	82
15:48	34
15:49	64
15:50	85
15:51	52
15:52	29
15:53	60
15:54	76
15:55	16
15:56	12
15:57	64
15:58	52
15:59	27
16:00	84	42.8
16:01	10
16:02	11
16:03	13
16:04	99
16:05	29
16:06	64
16:07	29
16:08	20
16:09	64
16:10	36
16:11	14
16:12	38
16:13	69
16:14	62
16:15	96	52.0666666666667
16:16	39
16:17	10
16:18	80
16:19	88
16:20	14
16:21	2
16:22	4
16:23	54
16:24	25
16:25	78
16:26	88
16:27	99
16:28	89
16:29	15
16:30	73	56
16:31	68
16:32	29
16:33	43
16:34	26
16:35	54
16:36	13
16:37	100
16:38	89
16:39	33
16:40	48
16:41	35
16:42	92
16:43	56
16:44	81
16:45	30	50.1333333333333
16:46	99
16:47	4
16:48	100
16:49	5
16:50	10
16:51	37
16:52	12
16:53	92
16:54	99
16:55	95
16:56	69
16:57	20
16:58	52
16:59	28
17:00	45	44.3333333333333
17:01	27
17:02	20
17:03	35
17:04	57
17:05	88
17:06	91
17:07	7
17:08	66
17:09	41
17:10	20
17:11	32
17:12	77
17:13	8
17:14	51
17:15	38	53.6
17:16	36
17:17	39
17:18	40
17:19	15
17:20	91
17:21	45
17:22	37
17:23	99
17:24	98
17:25	54
17:26	64
17:27	97
17:28	48
17:29	3
17:30	55	50.6
17:31	33
17:32	71
17:33	40
17:34	65
17:35	80
17:36	46
17:37	57
17:38	43
17:39	3
17:40	70
17:41	30
17:42	73
17:43	63
17:44	30
17:45	79	67.4
17:46	67
17:47	49
17:48	75
17:49	98
17:50	78
17:51	83
17:52	83
17:53	54
17:54	77
17:55	46
17:56	52
17:57	66
17:58	64
17:59	40
18:00	95	58.8666666666667
18:01	100
18:02	83
18:03	61
18:04	9
18:05	11
18:06	35
18:07	40
18:08	75
18:09	80
18:10	14
18:11	82
18:12	37
18:13	72
18:14	89
18:15	48	45.6666666666667
18:16	40
18:17	90
18:18	27
18:19	10
18:20	65
18:21	52
18:22	4
18:23	29
18:24	23
18:25	29
18:26	90
18:27	92
18:28	1
18:29	85
18:30	62	63.2
18:31	46
18:32	99
18:33	50
18:34	61
18:35	74
18:36	90
18:37	45
18:38	91
18:39	100
18:40	93
18:41	67
18:42	19
18:43	16
18:44	35
18:45	86	58.9333333333333
18:46	64
18:47	99
18:48	26
18:49	99
18:50	19
18:51	31
18:52	93
18:53	11
18:54	74
18:55	88
18:56	36
18:57	56
18:58	68
18:59	34
19:00	18	69.3333333333333
19:01	97
19:02	26
19:03	84
19:04	98
19:05	53
19:06	79
19:07	95
19:08	72
19:09	92
19:10	24
19:11	95
19:12	86
19:13	96
19:14	25
19:15	50	58.8
19:16	88
19:17	95
19:18	20
19:19	85
19:20	41
19:21	39
19:22	45
19:23	67
19:24	39
19:25	63
19:26	98
19:27	2
19:28	61
19:29	89
19:30	90	57.8666666666667
19:31	74
19:32	84
19:33	98
19:34	83
19:35	25
19:36	92
19:37	72
19:38	26
19:39	34
19:40	48
19:41	2
19:42	70
19:43	7
19:44	63
19:45	38	53.7333333333333
19:46	12
19:47	44
19:48	23
19:49	0
19:50	80
19:51	88
19:52	88
19:53	93
19:54	34
19:55	69
19:56	15
19:57	95
19:58	85
19:59	42
20:00	37	35
20:01	100
20:02	3
20:03	17
20:04	5
20:05	44
20:06	99
20:07	29
20:08	100
20:09	2
20:10	5
20:11	11
20:12	25
20:13	24
20:14	24
20:15	63	40.7333333333333
20:16	81
20:17	90
20:18	44
20:19	61
20:20	18
20:21	37
20:22	6
20:23	85
20:24	1
20:25	53
20:26	3
20:27	54
20:28	5
20:29	10
20:30	9	54.4666666666667
20:31	68
20:32	89
20:33	69
20:34	74
20:35	50
20:36	84
20:37	15
20:38	58
20:39	80
20:40	30
20:41	69
20:42	86
20:43	11
20:44	25
20:45	0	45.4666666666667
20:46	49
20:47	29
20:48	65
20:49	26
20:50	62
20:51	41
20:52	65
20:53	27
20:54	78
20:55	70
20:56	17
20:57	90
20:58	5
20:59	58
21:00	24	49.4
21:01	95
21:02	23
21:03	16
21:04	0
21:05	25
21:06	70
21:07	70
21:08	85
21:09	81
21:10	81
21:11	90
21:12	44
21:13	9
21:14	28
21:15	67	53.1333333333333
21:16	89
21:17	54
21:18	11
21:19	17
21:20	63
21:21	97
21:22	88
21:23	95
21:24	63
21:25	65
21:26	56
21:27	13
21:28	3
21:29	16
21:30	14	55.8
21:31	83
21:32	2
21:33	73
21:34	81
21:35	70
21:36	5
21:37	84
21:38	63
21:39	88
21:40	33
21:41	49
21:42	90
21:43	75
21:44	27
21:45	43	53.7333333333333
21:46	67
21:47	61
21:48	17
21:49	49
21:50	32
21:51	100
21:52	93
21:53	93
21:54	53
21:55	23
21:56	16
21:57	4
21:58	76
21:59	79
22:00	47	39.6
22:01	46
22:02	9
22:03	92
22:04	67
22:05	2
22:06	39
22:07	38
22:08	52
22:09	1
22:10	15
22:11	17
22:12	78
22:13	14
22:14	77
22:15	70	43.8666666666667
22:16	58
22:17	54
22:18	71
22:19	0
22:20	68
22:21	10
22:22	79
22:23	50
22:24	57
22:25	49
22:26	0
22:27	50
22:28	5
22:29	37
22:30	50	46.8
22:31	27
22:32	54
22:33	39
22:34	1
22:35	88
22:36	23
22:37	81
22:38	70
22:39	54
22:40	39
22:41	52
22:42	33
22:43	2
22:44	89
22:45	5	58.9333333333333
22:46	78
22:47	39
22:48	82
22:49	79
22:50	73
22:51	36
22:52	75
22:53	81
22:54	71
22:55	40
22:56	33
22:57	90
22:58	38
22:59	64
23:00	14	51.2666666666667
23:01	27
23:02	93
23:03	80
23:04	12
23:05	98
23:06	9
23:07	67
23:08	87
23:09	10
23:10	15
23:11	69
23:12	60
23:13	60
23:14	68
23:15	21	59.4666666666667
23:16	86
23:17	76
23:18	21
23:19	81
23:20	31
23:21	71
23:22	68
23:23	90
23:24	63
23:25	8
23:26	85
23:27	95
23:28	29
23:29	67
23:30	45	46.2666666666667
23:31	71
23:32	73
23:33	58
23:34	23
23:35	16
23:36	16
23:37	79
23:38	84
23:39	100
23:40	4
23:41	23
23:42	55
23:43	25
23:44	22
23:45	8	45.4
23:46	27
23:47	49
23:48	22
23:49	84
23:50	46
23:51	24
23:52	19
23:53	53
23:54	32
23:55	72
23:56	69
23:57	96
23:58	20
23:59	60

Here's the funny part.  The question that was posited essentially asked if the average of the 1 minute data would be more accurate than the average of the 15 minute averages.  Here are the results:

Average of all the 1 minute data points: 49.76319444
Average of all the 15 minute averages: 49.76319444

They're exactly the same!  The reason for this comes from the associative property of addition.  Think about the formula for an average:
x̄ = (a₁+a₂+a₃+...+a_n)/n

If you had multiple sets (i.e. 15 minute averages):
x̄ = {(a₁+a₂+a₃+...+a_n)/n_a + (b₁+b₂+b₃+...+b_n)/n_b + (c₁+c₂+c₃+...+c_n)/n_c}/3

Since in this case n_a=n_b=n_c, then substitue n and factor out:
x̄ = {(a₁+a₂+a₃+...+a_n) + (b₁+b₂+b₃+...+b_n) + (c₁+c₂+c₃+...+c_n)}/3n

Associative property of addition:
x̄ = (a₁+a₂+a₃+...+a_n+b₁+b₂+b₃+...+b_n+c₁+c₂+c₃+...+c_n)/3n

Since in this case 3n = n + n + n and n_a=n_b=n_c=n, then substitue for n:
x̄ = (a₁+a₂+a₃+...+a_n+b₁+b₂+b₃+...+b_n+c₁+c₂+c₃+...+c_n)/(n + n + n)
x̄ = (a₁+a₂+a₃+...+a_n+b₁+b₂+b₃+...+b_n+c₁+c₂+c₃+...+c_n)/(n_a + n_b + n_c)

Knowing that n_a + n_b + n_c is actually the total number of original points gets us back to the original equation for calculating the average of the 1 minute data.  So the average of all the data points is the same as the average of evenly spaced averages of all the data points.  If you're wondering if this works, go ahead and mock it up in Excel.  I did.