Do you have an existing Excel Application?

Netmajic can help your business with an existing Microsoft Excel VBA Application. Perhaps your application needs upgrading, or new features added. Perhaps a feature is no longer used and needs removing. Is the application acting slow? Netmajic can help with all enhancements so you can get back to the work at hand, your business.

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

Excel is the core spreadsheet application within the Office suite. Using VBA (Visual Basic for Applications), the user can create programs in what is a subset of the Visual Basic programming language.

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a host of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with three-dimensional graphical display. It allows sectioning of data to view its dependencies on various factors for different perspectives (using pivot tables and the scenario manager). It has a programming aspect, Visual Basic for Applications (VBA), allowing the user to employ a wide variety of numerical methods, for example, for solving equations and logic and then reporting the results back to the spreadsheet. It also has a variety of interactive features allowing user interfaces that can completely hide parts or the whole spreadsheet from the user, so the spreadsheet presents itself as a so-called application, via a custom-designed user interface, for example, a mortgage analyzer, or in general, as a design tool that asks the user questions and provides answers and reports. In a more elaborate realization. An Excel application can automatically poll external databases and measuring instruments using an update schedule, analyze the results, make a Word report or Power Point slide show, and then e-mail these presentations on a regular basis to a list of participants. Excel was not designed to be used as a database, but can be a demonstration of possibilities.

Netmajic has helped with many Excel VBA Applications.

1. Client Reporting of Individual Projects
   
2. Financial Keeping Systems
   
3. Trading Systems
   
4. Retail Systems
   
5. Customer Records Systems

... and many more.

Netmajic can come in and make a quick change or if there is a lot more, Netmajic offers a free hour consultation. If more is needed Netmajic follows a structured software process, using as much detail as you and your company need.

STATEMENT OF NEED

Does your company have need for a new Excel Application to automate company processes?

Is there a need for multiple employees to access the application at the same time? Do you need multiple security levels of user access? Would it be help if the new Excel application saved transactions over time?

Ultimately, the Excel application will be a solution efficiently servicing company officers, 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 existing Excel VBA application needs.