Excel Mini Program (out of exam scope)

Salam Alaykom,

I created a mini program on Excel.
It's a different solution for the first excel assignment, which was at the second lecture of Networks.

Here is the Excel file:
http://rapidshare.com/files/176642037/Cost_Calculation.zip (26 KB)

You have to enable Macros in Excel to use the excel file.
If anyone is interested, just reply here to explain more.

explain more

Glad that someone is interested.
There is something called "VBA" which is "Visual Basic for Applications"

That means that programs who has this feature enabled, opens the door to developers and advanced users to do whatever they like in the original program.

All office applications (plus AutoCAD now) have this feature.
In office, just press "ALT + F11" and you will find the Visual Basic window that gives you the availability to powerfully use the original program tools.

You can write a simple program to do things that may take a lot of work.
For example, if you want to write down from 1 to 10 in cells, you can write a simple code:
For x = 1 to 10
cell.write(x)
next
(this is only explaining example, the syntax is a bit different)

So I used this capability and I wrote a simple code to do all the stuff that we made manually in that problem.

You can't imagine the power you can get using these feature.

The power of this feature in Excel specifically, that you never need to know any syntax AT ALL.

Macros can do everything for you !!!
Macros is a very great feature in excel. Macros record all actions you do in excel (writing formulas, formatting cells and anything else) and convert those actions to programmatic code !!

For example, you want to write a code to make the cell background color red.
You never need to search or dig.

Just simply, make a new macro and start recording. Now go and make any cell red. Stop recording and press "ALT + F11"
Now you will see the exact code used to make that cell red !!!

It's really very easy, if you started to like the whole thing.

ya ahmed is these method the dr. teach it?

Do you mean the solver in excel ?
Or do you mean the programmatic method that the other dr wrote on the board ??

Well, it's not the solver method.
It's something like the programmatic method, but the difference is that I made it with excel, and I made the output shown in Excel formatted cells.
(By the way, I made this file before the dr wrote that programmatic method, beside that his program lacks a lot of small details)

-----------------
In case anyone didn't notice the title, I mentioned "Out of exam scope"
That means that we are discussing here a new method, not related to lectures or exams. I just don't want to disappoint anyone who may come here to check if anything important for the next exam.

If some of you want to discuss this later after the exams, it's ok.
Always glad and open to help and share experiences. (I'm just very busy usually after exams)

mmmmm

can't we say that the relation between MACROS and PROGRAMMATIC CODES are the same relation between FRONTPAGE and HTML CODES ?

Yes, it's "similar" to that relation. Nice thinking
I think that macros are easier to use.

You don't need to know anything at all. Just click "record macro", then for example sort a range of cells A-Z. Now stop recording.
If you clicked later on "Play Macro" and chose the macro you just recorded, the cells will be automatically sorted.

It's a simple way to do the repeated tasks more quickly and efficiently.

On the other side, they're very useful for people who want to start writing a simple code. The macros show you how to write the code.

that's coooooool

i designed an excel sheet for the storm water network calculations but it's so complicated so i think macros technique will help me a lot in simplifying this sheet

tomorrow ill discuss it with you