Excel Mini Program (out of exam scope)

Go down

Excel Mini Program (out of exam scope)

Post by amelsakka on Thu 25 Dec 2008, 3:30 pm

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.
avatar
amelsakka

Number of posts : 77
Reputation : 3
Registration date : 2008-11-14

View user profile

Back to top Go down

Re: Excel Mini Program (out of exam scope)

Post by bassem zakarya on Thu 25 Dec 2008, 4:48 pm

explain more Very Happy
avatar
bassem zakarya

Number of posts : 200
Reputation : 0
Registration date : 2008-02-28

View user profile

Back to top Go down

Re: Excel Mini Program (out of exam scope)

Post by amelsakka on Thu 25 Dec 2008, 8:16 pm

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.
avatar
amelsakka

Number of posts : 77
Reputation : 3
Registration date : 2008-11-14

View user profile

Back to top Go down

Re: Excel Mini Program (out of exam scope)

Post by amelsakka on Thu 25 Dec 2008, 8:23 pm

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.
avatar
amelsakka

Number of posts : 77
Reputation : 3
Registration date : 2008-11-14

View user profile

Back to top Go down

Re: Excel Mini Program (out of exam scope)

Post by tatooo on Thu 25 Dec 2008, 11:31 pm

ya ahmed is these method the dr. teach it?
avatar
tatooo

Number of posts : 27
Reputation : 0
Registration date : 2008-04-10

View user profile

Back to top Go down

Re: Excel Mini Program (out of exam scope)

Post by amelsakka on Fri 26 Dec 2008, 1:45 am

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)
avatar
amelsakka

Number of posts : 77
Reputation : 3
Registration date : 2008-11-14

View user profile

Back to top Go down

Re: Excel Mini Program (out of exam scope)

Post by bassem zakarya on Fri 26 Dec 2008, 2:46 pm

mmmmm

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

Number of posts : 200
Reputation : 0
Registration date : 2008-02-28

View user profile

Back to top Go down

Re: Excel Mini Program (out of exam scope)

Post by amelsakka on Sat 27 Dec 2008, 5:25 pm

Yes, it's "similar" to that relation. Nice thinking Smile
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.
avatar
amelsakka

Number of posts : 77
Reputation : 3
Registration date : 2008-11-14

View user profile

Back to top Go down

Re: Excel Mini Program (out of exam scope)

Post by bassem zakarya on Sat 27 Dec 2008, 10:07 pm

that's coooooool Very Happy

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
avatar
bassem zakarya

Number of posts : 200
Reputation : 0
Registration date : 2008-02-28

View user profile

Back to top Go down

Re: Excel Mini Program (out of exam scope)

Post by Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum