Specializing in Excel, Lotus 123 , Quattro Pro, database and accounting software programming, Jan S. Levenson, a Certified Adult Computer Instructor Programmer/Analyst has consulted with producers, owners and managers offering time and labor hour savings implementing computer solutions that simplify labor intensive work to a few leisurely steps.

Programming applications, Jan can help you understand and use powerful software to your best advantage.

Jan Levenson of Certified Computer Services maintains excellence in business practices, offering trust and confidence on the internet.

Jan has worked on the following Programming, Consulting and Training projects and has received many accolades on his work:

DATABASE/SPREADSHEET PROGRAMMING DEVELOPMENT and SUPPORT Project: Visual Basic Business Programming and Design Client: Royal Fence Company
Description: Lotus 123 bid Spreadsheet converted to Microsoft Excel programming, design and support. This Bid presentation tool was converted and includes relational databases in Excel to automate and be able to quickly submit bids for jobs.

Stock Market Streaming Real Time Data Programming and Design
Description:Client in England using eSignal real time world stock exchange data analysis system Developed a Microsoft Excel Visual Basic system with macro programming that enabled the client to receive world wide stock exchange data updated in real time every second so that micro trading trends can be observed and instant decisions can be made on playing the stock market. Program includes add-ons using the eSignal real time data electronic stream ticker tape.

Programming and Design Support J.P. Morgan Chase Finance Spreadsheet Microsoft Excel Visual Basic Macro programming, design and support. Graphing Utility Usage Software Microsoft Excel Visual Basic Real Estate Management property's maintenance and utility usage records
Description: Real Estate apartment and rental properties maintenance records charts. Using Microsoft Excel Visual Basic, Jan designed a program enabling the Real estate manager to select any particular residential address and graph the utility usage and costs over a four year period. Averages were presented in attractive easy to understand graphs. The charts could then be used for marketing or printed out for the clients to visualize their consumption of different utilities over a period of time. For consumer use, utility data was plotted on graphs showing usage in months and years and during seasonal events.

Web Site Programming Database Analysis Support Symbolic Media Services Description: The president of the company said, "when a person is looking for spreadsheet help and finds your web site, what they find is a genius, with good information, thank you Jan."

Data Conversion to QuickBooks Professional - Real Estate Appraisal Service Real Estate Appraisal Service in Las Vegas, NV Description: As stated in an email, "just what the doctor ordered". Records previously maintained in a Microsoft Excel database were converted to correct formats and imported into QuickBooks Professional. When the new version of QuickBooks was implemented by the client's business. Records previously entered into Excel were converted so that sales billing statements, addresses, quotes, client list and invoices were readily available within QuickBooks Professional, allowing the client to quickly start using QuickBooks Pro with customer data ready to be printed (records ready to invoice and multiple page billing statements could immediately be generated and emailed to clients for immediate payment and accounting processing).

Equipment Maintenance Control Corporation automated Vendor Invoicing System (in a no paper office) Equipment Maintenance Control Corporation Description: EMC accounting insurance, automated Vendor Invoicing System part of a paper free office automation system based on Excel Macros, invoices are emailed, Adobe Acrobat files are hyper linked to Excel spreadsheet invoice records, a variety of different customer transaction reports generated. Hospital Equipment Manufacturer Client: Intra-op Monitoring Services, Inc.

Description: Manufacturer of state of the art medical monitoring equipment. Development of a spreadsheet to analyze sales reps' commissions, sales and equipment product demonstrations. Multiple projects including conversion of complex Quattro Pro spreadsheets to Microsoft Excel formats.

NOAA - National Oceanic and Atmospheric Administration - United States National Weather Service Description: Converted statistical Quattro Pro spreadsheets to Microsoft Excel formats. Multiple projects included conversion of Word Perfect Macro data entry forms to Microsoft Word data entry forms allowing easier automated data entry and functionality to reports in word processing documents.

Microsoft Excel Visual Basic PLC Programming Logic Engineering Firm - Missouri Description: Wrote a program interface so that Microsoft Excel could run several routines to maximize the bin content and then communicate to a $70,000 PLC (Programming Logic Control) machine that bagged carrots within a second for a large food producer in California. Johnson and Johnson Pharmaceutical Company

Client: Johnson and Johnson Pharmaceuticals Description: Multiple projects including developing an easy to use form for senior marketing people of this billion dollar company to quickly calculate dates of prospective Pharmaceutical Drug Trials scheduling dates. Lotus 123 to Excel conversions

Client: RAC Royal Auto Club Motoring Services, UK Description: Converted and redesigned a complex Lotus 123 accounting program to Excel for RAC "Royal Auto Club" internationally known Travel and Automobile Service Agency in England, U. K.

Contractors tool using Microsoft Excel Building contractor - TX Description: Multifaceted Contractors tool using Microsoft Excel for sales people to be able to quickly give quotes and print sales quotes on-site to potential clients. After the quote was accepted a formal proposal using the same data was used. The sales quoting system enhanced sales of home pools, spas, utility buildings and miscellaneous building and home improvements. A relational database of other builders and subcontractors was used to assist in the bidding process, and each sales person sales proposals could then be downloaded to the main company computer helped to create lists of items needed in the purchases department for jobs.

Company Address Database Elk Corporation
Description: Spreadsheet Address Database System written in Visual Basic within Microsoft Excel as a desktop utility interfacing all of the companies´ employees and offices.

Oil Well Discovery Database Spreadsheet Reporting System Geo Digital Imaging Company
Description: Edited a spreadsheet to analyze, calculate and print needed reports for an international oil well discovery business.

Slot Machine Gaming Profit Analysis Software System Grand Casino Avoyelles
Description: Developed a complex Excel spreadsheet using Visual Basic to simplify statistical cost analysis reports regarding expectations and probability audits of profits and or losses of thousands of slot machines for management.

Advertising Mass Mailing Address Database Professional Typing and Computer Services Company
Description: Large Professional FoxPro address database system in the greater Charleston area for professional mass mailings and marketing.
Invoicing spreadsheet Sales Analysis System GEM Printing Equipment
Description: Developed team sales invoice generating spreadsheets system in Lotus 123 where custom invoices can be produced and reports printed before a final sales invoice of the same is presented to the buyer towards the purchase of high-end printing equipment. this optimized the sales process increasing sales and incentives for sales personnel and final sales purchase orders for the equipment company.

State Assets Inventory System State of West Virginia Description: Helped design a computer database application that contained all of the assets of the State of West Virginia, for the state governments Department of Finance. Complimented on "a job well done" by a CPA analyst from Deloitte & Touché accounting firm.

Truck Chemical Inventory System Union Carbide Corporation currently Dow Chemical
Description: Designed Lotus 123 spreadsheets and inputted data to analyze a yearly period of scheduled truck chemical inventory shipments to and from the Carbide Institute plant for Union Carbide Corporation Roune Polenc.

Automotive Repair service Reporting System Smith Motor Car, Mercedes Dealership
Description: Enhanced a spreadsheet application for the local Mercedes Motor Car dealership that totaled monthly through yearly repair department amounts and printed reports for the company's cost and profit analysis.

Healthcare Comparative Analysis System West Virginia Department of Health
Description: Developed a spreadsheet template program that produced a comparative analysis of costs of health facilities, profits and quality control of institutions in West Virginia for the West Virginia Department of Health.

School Lunch/Juice Accounts Receivable Program Catholic School System
Description: Wrote a School Lunch/Juice Accounts Receivable program interfacing a Lotus 123 Spreadsheet templates with a FOXPRO database that was used enabling each child to have a credit card like account where lunches and juice money payments could be charged and monthly billing statements conveniently were sent to parents.

Elevator Sales Invoice System Dover Elevator Company
Description: Jan designed a dBase computerized elevator sales invoice system that printed sales invoices for custom designed elevators. The regional manager of Dover Elevator Company liked the program and said, "The entire project paid for itself when one new elevator was sold using the program ."

Medical Insurance Overrun Analysis System University Health Associates
Description: Designed and programmed a FoxPro database application that analyzed cost over and under payments that were made by the major federal and state medical insurance companies to a large health care billing financial organization, University Health Associates. Jan was told by his supervisor, "He successfully programmed an application on the project that the 100 million-dollar company's team of computer programmers' said was impossible to do".

Party Sales Fund Raising Business Party Sales Fund Raising Business, Dallas, TX
Description: Accounting system for a Regional Manager of a party sales business to maintain sales records for sales reps and details of products sold for each Rep to maintain commissions, overall costs, profits and expenses.

COBOL Programmer West Virginia Department of Employment Security Description: COBOL programmer for the West Virginia Department of Employment Security, Division of Labor and Economic Research, Wrote a COBOL program that calculated and printed WV unemployment statistics. Jan organized detailed flowcharts and designed a written analysis of a complex COBOL program, part of a Federally funded computer project.

Computer Instruction & Advisory Council Multi-Cap, Inc. Description: Served as Multi-Cap, Inc. Advisory council member and computer business related instructor. Charleston, WV 1992-93. Support instructor for clients of Multi-Cap : Best accounting practices, overview of the corporate and small business work place including multi facetted and critical business competence training.

SMS Health Record Software CAMCARE, Inc.
Description: CAMCARE Inc. - One of the largest national health care providers in the United States- Trained hospital personnel, doctors and nurses to learn new SMS health record software ( a real time national records management system key to information achieving accuracy and responsibility in hospital record maintenance procedures.
Financial Accounting Implementation Canadian Manufacturing Company
Description: Analyst and Consultant recommending and help implementing financial accounting system to a large product manufacturing company in Canada. This allowed for quicker reporting and processing of product development and market place accounting transparency, decision rich analysis and evaluation of past, current and future business trends and statistics. MISCELLANEOUS

Excel Sales team and individual sales analysis system. Pierce Management Group - CPA
Description: Assisted a Certified Public Accountant develop software for cost analysis and specialized internal information systems reports for sales persons in the funeral industry using in Microsoft Excel. The lead CPA said "the program has been used on twenty different systems everyday and that they have been able to find more uses for the software beyond what they originally could have dreamed". The program is used for current and historical sales data, forecasting expectations in trends for individual company financial statements and sales personnel records.
First Run Features, Theatrical media booking agency, New York, New York First Run Features
Description: Supercalc to Excel legacy accounting spreadsheet systems conversion services.

Veterinary Financial Software Design Consultation Veterinary Hospital Finances
Description: Enhanced integration of insight and overview of Excel accounting spreadsheet data analysis programming and design consulting services for a nationally known veterinary practice in California peer group analysis network.

Lotus 123 to Excel conversions Real Estate Company, Florida
Description: Designed an automated reporting system with proven reliability performance and premier presentations showing relevant profitability and expenses reporting in Microsoft Excel for a real estate company in Florida.
Lotus 123 spreadsheet programming macro updates for Trinity Lutheran Church accounting Trinity Lutheran Church
Description: Conversion of early Lotus 123 spreadsheet to newer version of Lotus 123 macros.
Vertical Sales Mass Mailings Marketing Servco Fasteners Description: Designed a vertical market direct mass mailing database for Servco Fasteners Company.

Lottery Program Gaming client Description: Designed a lottery program in Microsoft Excel. Statistical Analysis Questionnaire Business in England UK Description: Designed a Questionnaire and statistical analysis and real time graphing system for a company in the U.K. The system can be used for a large organization that after questionnaires are answered on screen, data is imported into the main spreadsheet where hundreds of statistical chart graphs showing relationships of numbers and statistical analysis is shown in near real time. The program is menu driven with viewing and printing options menus within Quattro Pro.
Lotus 123 macro programming enhancements Tony Valentine Construction Company, CA

Description: Enhanced a Lotus 123 spreadsheet for sales control, auditing and accounting reports. Designed an accounting program prototype for marketing in Microsoft Excel. Modules include Purchasing, inventory, check register, payables, monthly and yearly profit loss reports. Garden Center Inventory System Valley Gardens Garden Center
Description: Inventory reports could be sorted by the sizes of plants, families of plants, types of plants, costs of plants and many other sort variations allowing the company greater flexibility to produce reports that were used as sales fliers, marketing advertisements and inventory assessment

Computerized Music Song Chord Notation Database System Professional musician, Greenbrier Hotel, sheet music transposed notations

EDUCATIONAL/TECHNICAL INSTRUCTION Institution: Capital High Community Education Teacher Position: Technical Education Center Instructor, quality assurance computer training Institution: Benjamin Franklin Career & Technical Education Center Position: Computer Instructor Institution: Training Place, Town Center Mall, Charleston, WV Position: Secure strategies for business data rich and streamlined efficient environment using Analysis, trends, visual graphic representations of numeric data (graphs). Business and Industry Computer Instructor for employees of Bell Atlantic Telephone, McDonough, Caperton Insurance Inc. McJunkin Corporation, and the Kanawha County Board of Education.
Institution: Garnet Career Center , Charleston, WV Position: Computer Instructor of traditional computer training in computer technologies based on business models Institution:

Carver Career Technical Education Center, Belle, WV Position: Business/Industry Instructor organized workspace data processing seamlessly used in simplifying significant amounts of office data. Institution: St. Albans High School Community Education Position: Computer Instructor Institution: West Virginia Junior College, Charleston, WV Position: Computer Instructor of data processing, computer science, spreadsheet office automation. Institution: National Institute of Technology, National Education Center, Charleston, WV Position: Instructor of computer science, PRG, COBOL and BASIC programming. Logic and systems analysis, programming and coding strategies. Transparency of accounting, utilizing web based telecommunications and computer programming tools.

Bookkeeping Spreadsheet Support Wright-Patterson Air Force Base Description: Wright-Patterson Air Force Base Excel spreadsheet enhancement project consultant.

Industrial Instructor Federal Express Jan was selected as a spreadsheet-training consultant to train employees of Federal Express.

FoxPro Programmer Osteopathic Physicians of West Virginia Inc. Jan programmed an address database that was used for form letters to members, based on logic for organization support and political action.

Business Support and programming Auto Repair Service Center Description: Computer assistance, trained employees, programmed supported office employees using QuickBooks used in conjunction with NAPA automobile service center software.

Certified Computer Services Company Offering Excellent help Writing and Designing Spreadsheet Applications with Excel, Lotus 123 and Quattro Pro.

Email Jan for expert computer spreadsheet help and assistance today.

You will be glad you did .