Canreef Aquatics Bulletin Board

Canreef Aquatics Bulletin Board (http://www.canreef.com/vbulletin/index.php)
-   Lounge (http://www.canreef.com/vbulletin/forumdisplay.php?f=14)
-   -   MS Excel wizz's Is there a script for? (http://www.canreef.com/vbulletin/showthread.php?t=52037)

banditpowdercoat 04-24-2009 03:17 PM

umm, I dunno

mike31154 04-24-2009 03:45 PM

Something like this....

http://hlj1yw.blu.livefilestore.com/...oAeeSW/eg2.jpg

The last date entry uses the function which automatically inserts today's date. All the previous ones are entered manually as the date the parameters were taken. There's also a feature in Excel (Freeze Panes under the Window menu) which allows you to lock the top row so that when you scroll down, it continues to be displayed for reference.

banditpowdercoat 04-24-2009 03:48 PM

Hey Mike, thx. Locking the top row would be neat. That page looks good. I don't know why I never thought of putting it that way.

mike31154 04-24-2009 03:58 PM

No probs and no need for complex look up formulae this way, but you can still do it if you wish to produce a graph or something on a separate page. To lock/freeze the top row, in my example pic, you would select the entire row 2 by clicking on the the number 2 on the left (second row), then click the Window menu and choose the "Freeze Panes" option.

banditpowdercoat 04-24-2009 04:03 PM

Ya, the graph thing would be nice. I'm more used to looking at graphs and such. Easier to undersatnd and see the changes over time. Man, theres alot in Excel I don't know hehehe

mike31154 04-24-2009 04:08 PM

Just tried a quick line graph for Ca using the graph wizard and wasn't really all that great since the values were all 400. So in this case it's a flat line. Need more varied data to have a nifty graph I think.

banditpowdercoat 04-24-2009 04:18 PM

Ya, same here. But untill 10 min ago, I never knew I could do a graph.

mike31154 04-24-2009 07:51 PM

It's a powerful application and you can learn a lot just using the help feature, if you know what you're looking for and have time on your hands. Most people (including myself) only ever scratch the surface of what's available, maybe make use of 5% of the apps capability. I've noticed many people use Excel to make lists etc. because it's in a nice grid/table format. If you're not making any kind of calculations, graphing or data tracking, a table in the word processor of your choice makes a list just as well. You just need to format the table to show gridlines or cell borders. MS Word even has the capability of formatting cells in tables with rudimentary calculations. Mind you I'm still using the Office 2000 version of all this stuff. No idea what can be done with the latest & greatest.

brizzo 04-24-2009 09:16 PM

http://www.mrexcel.com/learn-excel.html

Hands down one of the best excel books I've ever read.. Actually it's probably one of the best techy books I've ever read!

When the book first came out you could download the eBook for free; too bad the offer has ended :(


All times are GMT. The time now is 03:48 AM.

Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.