We have a Google Spreadsheet that multiple people can enter data into. For each entry we have created a series of formulas to run calculations and derive totals from the values entered.

We decided to make it simpler to enter data by using a form. This works amazingly, as you can control what data can be entered, and then even control who can edit it. It's a great way to ensure consistency and even data security.

However, I ran into a major problem. Each time a form was submitted, this creates a new row of data (which is expected). However, the problem is that the formulas were not being copied from previous rows, the formulas cells were just empty and nothing was calculated.

After many hours of searching, here's how I was able to fix it: (more…)

I was looking around for some popular flash games to post on the site. I found this one – Ski Simulator. I was kind of hoping it would be like that old Ski.exe game we had on our 386 Windows 3.1 machine. But it was not to be. It's more like a first-person ski game, which just gets faster and faster.

Drop a comment and let everyone know how many posts you're able to get!
(more…)

Ok, so, most of the flash games on this site are failing to work on school computers. So I'm going to find some more that do work for you to play! Jewel Quest is a classic – you're supposed to make all items gold by deleting the jewels on them within the limited time.

Drop a comment and let everyone know your high score!
(more…)