Online Budget Analysis system
Online Budget analysis System
ABSTRACT:
Budget analysis is a useful web application that helps all sorts of business firms. The main strategy of the project is to automate the excel data and calculations into RDBMS to make data retrieval and manipulations easier. The application is done using ASP.Net and we have used SQL Server as the back end to make it more powerful. The main features of budget analysis are:
- Fast excel file parsing
- Project wise summary report
- Date range summary report
- Month wise summary report
- Year wise summary report
The application is build kept in mind that any users will find to use it friendlier. We just need to upload the excel file into the application through the friendly user interface provided and the application, will parse the excel file into the database for calculations and manipulations. The users are also given the facility to create a new project by themselves which helps them to handle the excel applications into the database more friendly.
PROJECT OUTPUT VIDEO:
EXISTING SYSTEM:
Present system is a windows application, in which users can upload data only to that system. Here the user must enter the rate, quantity and sales result at each time when transaction occurs.
LIMITATIONS OF EXISTING SYSTEM:
The user must always be available with the system to do the process. The user has to enter the details all time. So the process is time consuming.
PROPOSED SYSTEM
It is a web application in which users can upload excel file which contains the transaction details. User can store the details under a project category which helps them to identify daily data.
ADVANTAGES OF PROPOSED SYSTEM:
User can upload the excel file from anywhere at anytime. User can view summary reports of each project between two dates, monthly and yearly report.
SYSTEM SPECIFICATIONS
HARDWARE DESCRIPTION
The selection of hardware is very important in the existence and proper working of any software. When selecting hardware, the size and requirements are also important.
Minimum Requirements:
Processor : Pentium II class, 450MHz
RAM : 128MB
Hard Disk Drive : 3GB
Video : 800X600, 256 colors
CD-ROM : Required
The proposed System is developed on:
Processor : INTEL Pentium 4
RAM : 512MB
Hard Disk Drive : 40GB
Key Board : Standard 101/102 or Digi Sync Family
Monitor : Display Panel (1024 X 764)
Display Adapter : Trident Super VGA
Network Adapter : SMC Ethernet Card Elite 16 Ultra
Mouse : Logitech Serial Mouse
SOFTWARE DESCRIPTION
Operating System : Windows XP
Front- End : C#. NET with ASP. NET
Back- End : MS SQL SERVER 2005 EXPRESS
