View Full Version : New Event Logging Tool
white frog
05-12-2012, 06: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, 08:08 AM
Wow man. So clean.
iteachem
05-12-2012, 08: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, 08:45 AM
However you wanna do it!
iteachem
05-12-2012, 08: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.
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, 12: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, 01: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, 01: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, 03: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, 03: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, 03: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, 03:45 PM
http://i673.photobucket.com/albums/vv100/iteachemscience/Capture.jpg
kimberleyj
05-12-2012, 04: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, 04: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, 04: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, 04: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, 05: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, 05: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))
Powered by vBulletin® Version 4.2.2 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.