Excel Application

STATEMENT OF NEED

Does your company have need for a new Excel Application to automate company processes? Or perhaps communicate project information with clients?

Is there a need for multiple tabs and formulas that update automatically as data changes? Would it be helpful if the new Excel application imported previous data into the new version seamlessly?

Ultimately, the Excel application will be a solution efficiently servicing company officers, clients, department heads, and workers in achieving daily tasks through the company's internal network.

Let Netmajic help your company achieve a new Excel Application to help your bottom line.

EXCEL APPLICATION DEVELOPMENT PROCESS

OVERVIEW

Netmajic's software development process has been designed to follow the Rational Unified Process modified to include the creative portion so necessary in today’s application development. The Rational Unified Process is really just quality software development practices communicated to all members of the team. The process allows Netmajic to deliver consistently high-quality applications that capture the very essence of what you desire. We achieve this through a client-centric process that integrates the client as part of our team.

Our process is made up of five main steps: Relationship, Discovery/Design, Development/Test, Promotion and Maintenance. In order to ensure we are building what you really want, each milestone ends with a client review and approval before work proceeds.

Netmajic's process also involves an iteractive design element. Many times the client knows what their overall need is, but not what technology can do for them. This is where Netmajic really comes through, in the understanding of business processes, and suggesting technology solutions to streamline the business process. Each step can include a discovery process as new potential is realized for the application. As the application is developed, these new features can be scheduled into the application in an iterative development method.

PROCESS

“Netmajic plans reviews and formal sign-offs at each milestone of the project. These reviews are essential for getting feedback from you, our client…”

Ultimately, each company user must understand why should I help with the functionality of the new application, and understand - what’s in it for me?

Netmajic is a firm believer in the value of proven processes and procedures to maximize efficiency and eliminate surprises.

Relationship
This step builds our relationship by our understanding of your business needs and you understanding of our capabilities. The business vision, brand, strategy and rough project scope will be discussed. We hope a mutual trust will be established which through defined expectations, honest communications and timely delivery results in a long-term partnership.

A Discovery Proposal will be delivered to proceed to the next step. The investment will cover just the discovery/design step. The investment for development/test step is unknown until the requirements are revealed in discovery. The Discovery/Design Proposal provides a statement of the business need, preliminary analysis and discovery investment.

A budgetary estimate is included in this proposal. Further refinement of the work to be done will be discussed to solidify the estimate of time.

Discovery/Design

This step begins with a meeting of the sponsors to establish scope and top-level requirements. Next is a workshop and interviews with stakeholders to capture current and future requirements. Use cases of the preferred user experience with the application will be explored and recorded step by step.

The Discovery portion concludes with a presentation and acceptance of the Discovery Brief including creative, information architecture, functions and technical requirements.

The Design step concludes with a presentation and acceptance of the information architecture and sample creative layout.

A Development/Test Proposal covering design, implementation, test, and transition to production steps will be delivered. The proposal will outline a recommended solution and associated investment.

A rough order of magnitude estimate is included in this proposal for discussion.

Development/Test

This step begins with a meeting of the sponsors to establish scope, roles and responsibilities, and gain commitment to resources.

Technology Design Step

The technology design step builds on the design step and will produce a user interface design. The design step also implements and tests technology risk areas for the creative option. It will be reviewed with the client for approval to continue.

This design step will result in an Alpha Document that articulates exactly what we are going to build. The Alpha is one complete path through the site and a complete site map and wire navigation diagram. This stage still requires significant customer involvement and sign-off in order to proceed.

Implementation and Test

The application then moves through full implementation and test in our facility with increments posted on your computers. The objective of the implementation and test steps are to build exactly what is articulated in the Alpha Document. During these steps the customer’s involvement becomes one of reviewing our Beta releases and providing feedback on any bugs or issues to be resolved. The test step consists of a minimum of three milestones. The actual number of steps will be determined at the start of the project and is based on the project timeline and/or complexity. The stages are: Beta 1, Beta 2, and Gold.

The Beta deliveries are for client testing to requirements. The client should find most corrections at this time. These steps end with written feedback from the client. Approval of Beta 2 goes to Gold which is the final application.

Transition to Production

The transition to production occurs in three steps. First the final application “Gold” is transferred to a staging area for review. Any staging corrections are made at this time. Client approval is requested to continue. The application is moved to production, I.e. “Go Live”. The application should go through a client acceptance test procedure for final approval. Any production corrections are made as quickly as possible. Step three, the application is monitored over a period of mutually agreed time, i.e. one week before final acceptance and sign-off of the application. Gold includes a final report, compiled code and documentation, returning assets to the client, and surveying the Netmajic team and client team for feedback on the process and the team.

A successful client acceptance of the application concludes the development contract.

PROMOTION

A Promotion Proposal will be delivered detailing the promotion campaign. The investment will cover just the promotion activities. The investment for promotion is dependent on the purpose of the application and the intended audience.

The Promotion Phase is a separate contract to promote the application with the end users. Training classes will be conducted as needed.

This contract begins with a meeting of the sponsors to understand all aspects of promoting the application.

A successful client acceptance of the promotion activities and materials concludes the contract.

MAINTENANCE

A Maintenance Proposal will be delivered detailing a master service agreement for monitoring and routine updates to the application.

The effort covered under the master service agreement is a monthly rate plus time and materials.

EXCEL PROJECT MANAGEMENT TOOLS

“Netmajic believes your application is a digital employee with your requirements as the job description and its value is a return on your investment…”

Netmajic employs the following procedures to ensure timely and accurate delivery of your web site.

Rational Unified Process

The Rational Unified Process embodies the best practices of proven software development methods since the industry began. It provides a disciplined approach to assigning and managing tasks and responsibilities within the project team. The goal of this process is to produce, within a predictable schedule and budget, high-quality software that meets the needs of its end users.

Netmajic has extended the process to include the creative development process. The attention to brand, user experience and creative treatment has been incorporated into the overall structure and deliverables. This ensures a smooth flowing project from concept through development.

Project Management

We closely document the progress of all projects, using a team selected tool. This project management tool helps to illustrate and track progress, and helps keep your project on time, on target and on budget. The Timeline section of this proposal contains a summary of the major milestones and dates in the proposed project plan.

Regular Scheduled Team Meetings

Because time and communication play such critical roles in a project, team meetings will be set up to keep the project on track, and keep everyone involved up-to-date. The meetings are attended by the senior level people on the team and always include a “to do” list of milestones, as well as a project recap. These meetings often prove crucial when it comes to identifying early warning signs and the basic dissemination of information.

Regular Scheduled Client Updates

In our experience, updates tend to work well for most clients, but we will be happy to schedule progress reports and budget updates to meet your specific needs.

Call Reports

After each client-involved meeting or conference call, a Call Report is generated. It restates the purpose for the meeting, and identifies action items to be fulfilled by the client and Netmajic. The Call Report can be sent via e-mail, or by PDF when sign-off on changes in scope are required.

Milestone Sign-offs

Netmajic plans reviews and formal sign-offs at each milestone of the project. These reviews are essential for getting feedback from our clients, so that we can make efficient, timely changes to the application as necessary.

Netmajic - Excel Application VBA Programmer

Netmajic has extensive experience designing and maintaining MS Excel VBA Applications, Call, 612-581-0332 today to discuss your Excel VBA needs.