It is done. The system is now finished with all validations working and everything in working order. No more tinkering with things anymore so I guess, this is the last post in this blog.
It was a tough trip but I am happy with the final outcome.
See ya'll around.
COLLEGE PROJECT COMPLETE
Friday, 22 February 2008
[Success]Graph Creation
It seems once again, I have been able to do what I thought was impossible so late on.
I have been able to create graphs using data from drop down lists by using the COUNTIF function in excel.
Tough as it was, I now have two graphs. They look pretty cool and work great. Changing numbers along with changes in the data, it's working better than I expected.
I have been able to create graphs using data from drop down lists by using the COUNTIF function in excel.
Tough as it was, I now have two graphs. They look pretty cool and work great. Changing numbers along with changes in the data, it's working better than I expected.
Wednesday, 16 January 2008
[Note] Sort Macro
I seem to have discovered that running my sort macro takes longer than every other macro I have. I'm not going to experiment ways to fasten it up cause it seems impossible.
When running the sort macros, it shows all the steps but in like fast motion. It finishes after approximately 2-3 seconds but it makes the program look buggy by the way it does it.
I have approximately 2 days to finish this program, and I forgot to change the sheet colours to make it more appealing! (gonk) ahhh.
When running the sort macros, it shows all the steps but in like fast motion. It finishes after approximately 2-3 seconds but it makes the program look buggy by the way it does it.
I have approximately 2 days to finish this program, and I forgot to change the sheet colours to make it more appealing! (gonk) ahhh.
Custom Sort: Success!
I've put the the options which I wanted in my custom drop list into my dataspace (changed font colour to match background) and imported the list. Suprisingly, it did it the way I wanted and in the order I wanted.
At least it's done something right.
At least it's done something right.
Monday, 14 January 2008
Graph Creation Issues
Another bug, excellent(!)
Seems as if you can't create graphs in excel using data from drop down lists. Even better, I can't edit Graph data from Date of Birth so it only shows people born on like a specific year instead of the
day/month/year format making it messy
Great.
CLEANUP - EDIT: I managed to fix 1 out of 2 of these problems. Graphs can be created but you have to use COUNTIF to get the figures and use your immagination to find suitable headings for your graph sections. If you want to count two different sets of data and accumilate one number, use two COUNTIFs in the same cell.
For example, Say I want to find out how many people registered in the sheet are aged 12 to 14. The formula I would enter is : =COUNTIF('Insert Sheet Name'!E7:E37,">=12")-COUNTIF('Insert Sheet Name'!E7:E37,">14")
The first countif formula is requesting excel to count how many cells in the selected sheet and range are more than or equal to 12. The - sign I assume is acting like a minus sign and is requesting excel to find how many cells in the selected sheet and range are more than 14.
[OBSERVATION] It's pretty confusing because it's suppose to be less than 14 right? I switched the sign to <14 but got a higher number to that of the original and the higher number is wrong. I'm not sure the reason as to why it's giving me that number but I suspect it has something to do with the "dash". If I have time, I'll look further into it for answers or I'll get a second opinion.
Seems as if you can't create graphs in excel using data from drop down lists. Even better, I can't edit Graph data from Date of Birth so it only shows people born on like a specific year instead of the
day/month/year format making it messyGreat.
CLEANUP - EDIT: I managed to fix 1 out of 2 of these problems. Graphs can be created but you have to use COUNTIF to get the figures and use your immagination to find suitable headings for your graph sections. If you want to count two different sets of data and accumilate one number, use two COUNTIFs in the same cell.
For example, Say I want to find out how many people registered in the sheet are aged 12 to 14. The formula I would enter is : =COUNTIF('Insert Sheet Name'!E7:E37,">=12")-COUNTIF('Insert Sheet Name'!E7:E37,">14")
The first countif formula is requesting excel to count how many cells in the selected sheet and range are more than or equal to 12. The - sign I assume is acting like a minus sign and is requesting excel to find how many cells in the selected sheet and range are more than 14.
[OBSERVATION] It's pretty confusing because it's suppose to be less than 14 right? I switched the sign to <14 but got a higher number to that of the original and the higher number is wrong. I'm not sure the reason as to why it's giving me that number but I suspect it has something to do with the "dash". If I have time, I'll look further into it for answers or I'll get a second opinion.
Sort Macro issues
Well, I'm reaching the final few days of my system and what better than to have bugs plaguing everything.
I'm trying to create another macro to sort a "rank" field I have. Unfortunately, they all have similar numbers on the rank excel confuses everything and sorts it wrong. I'm in a real dilemma to fix this before friday.
CLEANUP - EDIT: I was able to fix this. Luckly for me, excel has a custom list option hidden around through the excel options. It's reallly really inefficent that it's in the options and not in a place where it can be located easier.
-Sigh-. It's located through these steps:
Logo->Excel Options->Under Popluar tab there is an Edit Custom List button
You now have the option of creating a new list, using a preset list (days of the weeks, days of the weeks shortened, months, months shortened). There's also an option to import a list from cells which is useful and time efficient. That is what I ended up doing.
I'm trying to create another macro to sort a "rank" field I have. Unfortunately, they all have similar numbers on the rank excel confuses everything and sorts it wrong. I'm in a real dilemma to fix this before friday.
CLEANUP - EDIT: I was able to fix this. Luckly for me, excel has a custom list option hidden around through the excel options. It's reallly really inefficent that it's in the options and not in a place where it can be located easier.
-Sigh-. It's located through these steps:
Logo->Excel Options->Under Popluar tab there is an Edit Custom List button
You now have the option of creating a new list, using a preset list (days of the weeks, days of the weeks shortened, months, months shortened). There's also an option to import a list from cells which is useful and time efficient. That is what I ended up doing.
Sunday, 6 January 2008
The Finalè
I am reaching the end of the creation of this system. The final bits that need to be done is entering the data and creating sort macros. Although most things I would of hoped to have done will not be possible, I think I have achieved my goal of the user-friendly interface I was aiming for.
All in all, it looks and runs pretty efficently.
All in all, it looks and runs pretty efficently.
Subscribe to:
Posts (Atom)