BUDGET ANALYSIS

                                                Budget Analysis

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:

1.      Fast excel file parsing

2.      Project wise summary report

3.      Date range summary report

4.      Month wise summary report

5.      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.

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

            Project will be done in ASP. NET with C# 2.0 as front end and SQL Server 2005 as back end. Microsoft .NET is software that connects information, people, systems and devices. It spans clients, servers and developer tools and consists of:

Ø  The .NET Framework programming model that enables developers to build Web-based applications which expose their functionality programmatically over a network using standard protocols such as SOAP and HTTP.

Ø  Developer tools such as Microsoft Visual Studio .NET, which provide a rapid application integrated development environment for programming with the .NET Framework.

Ø  A set of servers including Microsoft Windows 2000, Microsoft SQL, Server and Microsoft BizTalk Server that integrates, runs, operates and manages XML Web services and applications.

Ø  Client software such as Windows XP, Windows CE and Microsoft Office XP that helps developers deliver a deep and compelling user experience across a family of devices and existing products.

            The .NET Framework is the programming model of the .NET environment for building, deploying and running Web- based applications, smart client applications and XML Web services. It manages much of the plumbing, enabling developers to focus on writing the business logic code for their applications. The .NET Framework includes the common language runtime and class libraries.