Monday, August 31, 2009

Cash Receipt Template(MS Excel)

This is a good template for those who work on monthly feasibility study for a longer time of period. I used three methods, used any one as per your convenience.
In this template you have to select receivable days, the model will adjust receivable amount, GST, Bad debts, write off and cash receipt automatically. Please consider blue font as a variable.
To achieve this objective, I used Hlook up function extensively. Through this model, I made my financial model more and more automated. Earlier, I have to manage receipts, bad debts and write off manually for direct cash flows.
Same tips one can apply as per his/ her requirement. This will be helpful particularly for Account, Finance and other Business professionals. It has been designed in more sophisticated way so that everyone could get advantage of it.

Please go through the template meticulously.

Note:
Through this template:
· You may learn Data Validation.
· You can apply H lookup function.
· You may use Nested If function and IsError.
· You may apply Index and Match function.

Download Template Link 1

Download Template Link2

Snapshot is given below for your interest.


Sunday, August 30, 2009

Variance Analysis (MS Excel)

This template is very strong.
This will be helpful particularly for Account, Finance and other Business professionals. Through this template, you can manage your periodic reporting in more effective and efficient way and definitely you will be more and more productive.
It has been designed in more sophisticated way so that everyone could get advantage of it. In data sheet, you will have to take care of sensitive area any deletion or insertion may create problem.
Please go through the template meticulously.
Note:
Through this template:
· You may learn Vlookup
· You may use Choose function.
· You may apply Offset function.
· You may use Text function with date

Click here to Download Link1

Click here to Download :Link2

Snapshot is given below for your interest.



Saturday, August 29, 2009

Final Year Project

Final Year Project (FYP) the time when you have to register your FYP the basic problem is Project "Idea". Something new,Somthing unique, never implemented before...blah blah :) a hell alot of constrains.

Well I research to find some new Idea,i found some links which i want to share, i hope it will helpful for Final Year students of Computer Science.


Well I chose Project on Computer vision.Here is a video which will give you an idea about computer vision projects.

I found an (open source, C#) framework for image processing AForge.Net.

In AForge.Net you can find samples and very helpful documentation just check AForge.NET website .