PDA

View Full Version : New Event Logging Tool



white frog
05-12-2012, 07:20 AM
I just wanted to remind everyone of the new event logging tool I created. With the new event started, this would be a great chance to test it out! See the link in my signature!

Plumbernick9
05-12-2012, 09:08 AM
Wow man. So clean.

iteachem
05-12-2012, 09:19 AM
What do you consider a day in this? Does it matter..or do you go by the event timer list of days

white frog
05-12-2012, 09:45 AM
However you wanna do it!

iteachem
05-12-2012, 09:51 AM
However you wanna do it!

sent you a pm with another piece of info... thanks again. I asked about the day issue due to the statistics some folks collect. I know a bunch of you folks have completely figured out rates etc and thought maybe the day issue was for that drop rate calculation.

Plux
05-12-2012, 01:39 PM
I teachem, what is your evil lego man holding there, that's one seriously worrying urine sample. He's got some on his shirt by the way.

Dillinja
05-12-2012, 01:55 PM
Thanks for taking the time out to make the spreadsheet..
Now the hard bit of remembering to update it :/

white frog
05-12-2012, 02:00 PM
This was actually the first one I did solely for the benefit of the community. The others I created out of personal need... I don't really even play the events though, so this one if for all of you guys!

iteachem
05-12-2012, 02:03 PM
I teachem, what is your evil lego man holding there, that's one seriously worrying urine sample. He's got some on his shirt by the way.

Well since I teach sixth graders about body systems, I am sure it is some form of bile...I will have to ask them if we extracted that fluid from the body :-)

kimberleyj
05-12-2012, 04:26 PM
how do i fill it in?,i have clicked on the link and have tried clicking on sheet 1 but nothing happens.

iteachem
05-12-2012, 04:44 PM
how do i fill it in?,i have clicked on the link and have tried clicking on sheet 1 but nothing happens.

I had that trouble.. there is a cell to the right of the words its in D3 so click on the right side of the grey box to fill in the money..

iteachem
05-12-2012, 04:45 PM
how do i fill it in?,i have clicked on the link and have tried clicking on sheet 1 but nothing happens.

oh and you have to save/open it in xcel on your computer

iteachem
05-12-2012, 04:45 PM
http://i673.photobucket.com/albums/vv100/iteachemscience/Capture.jpg

kimberleyj
05-12-2012, 05:03 PM
oh and you have to save/open it in xcel on your computer

please can you tell me how do i save it on my ipad.

iteachem
05-12-2012, 05:08 PM
please can you tell me how do i save it on my ipad.

not sure about that.. I think you could use google docs. I will see if I can figure it out

iteachem
05-12-2012, 05:11 PM
Found this site that shows how to open and edit xcel docs in ipad

http://techawakening.org/open-word-excel-files-on-ipad-iphone/768/

I don't have any of these apps. Also the Numbers App will do it apparently as well as Pages.

iteachem
05-12-2012, 05:43 PM
If you have a google account try this

https://docs.google.com/spreadsheet/ccc?key=0Almxrx-TkJKSdHlUR1p3QzdfUVJYQ2xnbkpiSG4xT2c

I uploaded mine to google docs.. You should be able to make a copy and edit it.. Havent tested yet

kimberleyj
05-12-2012, 06:11 PM
thank you for your help. i will try to see if i can work the log with google but i will leave it to later because it is 1am and i feel tired.

white frog
05-13-2012, 06:22 PM
I just wanted to let you all know that I found a minor error in the tool. Currently, if your first attempt of the day was a failure, then the "Successful Opens %" will not calculate at the end of each day. Steps to fix the problem:

1. Highlight the cell to the right (where it should be calculated) of "Successful Opens %"
2. In the formula bar, change the TRUE value (X=0) to X=""
3. Repeat these steps for each day

For example, the formula for Day 1 reads =IF(D10=0,"",AVERAGE(D10:D32))...
change it to =IF(D10="","",AVERAGE(D10:D32))