Spreadsheet ProgrammingSpreadsheet Programming
Spreadsheet Programming
Spreadsheet Programming

Please send for a free quote on your project now!

Welcome to Certified Computer Services













 

  Welcome to Certified Computer Services

Automation Specialists! Top rated Certified Computer Services implements computer programming solutions that simplify your labor intensive computerized tasks to a few leisurely steps.

Jan Levenson, Lead Programmer ⁄ Analyst, will assure that your programming project receives the highest levels of detail and quality control under his and your auspices.

Many programming options are available for a wide variety of systems and software environments. Offering customized solutions for databases, spreadsheets, business or industrial computer integration processes. Our specialty is automating unusual computer applications of seemingly unrelated software processes. We make your job easier, simplifying and integrating your software, saving you time and money, . Get help today!







Quality Designed Programming
and Business Solutions

Expertise in Database, Spreadsheet
rewrites and conversions.

Professional Friendly Service

Programming Featuring
Microsoft Excel
Lotus 123
Quattro Pro
Visual Basic
Visual FoxPro Databases
Licensed Microsoft Software Programming
Intuit QuickBooks Professional Accounting
Multiple Platforms and Programs Supported


Automation processes of unrelated programs software,
Internet and networking data various system configurations

Search Engine Optimization
Web Site Editing
Computer Technical Writing and Web Services

Customized Data Entry Forms
Combining data from different sources
Simplifying tasks
Making your job easier


***** Top rated *****
Listed in the BBB
Better Business Bureau's
Database of Better Businesses

Custom Designed Spreadsheets
Conversions / Integrations
Migrations / Troubleshooting
Debugging
Data validations
Programming, Analysis
and Design.


bookmark us!
(CTRL-D)

(30 day billing available)

Short-term, temporary or periodic
Custom designed services
Emergency Services available
Online services

Specializing in spreadsheet and database
data integration.
Featuring Microsoft Excel, Lotus 123,
Quattro Pro, Visual FoxPro database,
QuickBooks and various accounting data integration.

Get your job done and get lots of help

Send for a free estimate today !



Our goal:

To offer
the best computer services available.




Do you need help with a programming project?


 Click here for a free estimate
Click here for a free estimate.



Quality Programming
Certified Computer Services
Serving the Business community since 1983.


Links
 Help with Database and Spreadsheet Project

Copyright © 2008












































Excel spreadsheet rewrite projects

Certified Computer Services

Advanced Spreadsheet Programming Concepts
Analysis and Design

Get your job done!
Request a Free estimate

A Certified Computer Professional helps you with your spreadsheet work.

DO you need help with Microsoft Excel, macros spreadsheet programming, spreadsheet integration conversion, program design or support?

Specializing in large complex spreadsheets programming, analysis and design, a Certified Computer Professional helps you with your spreadsheet work. Fast turn around. Spreadsheet programming format conversions between Microsoft Excel, Lotus 123, Quattro Pro. and various database programs. Customized Intuit QuickBooks Professional, Business Consulting Services including database, accounting, inventory systems, industrial support, and security issues.


Custom Designed Spreadsheets Programming
(30 day billing available)
• Short-term • Periodic •
• custom designed services •
• Online consulting via email • •
• Request a free estimate today •
• Get your job done and get lots of help •


For computer spreadsheet help and contact information, send an EmailSend an Email request - thank you!
http://ccsplus.com
Email: ccs@ccsplus.com



Do you need some help to complete a computer project?

Jan Levenson holds a Computer Science Degree and is a Certified Adult Computer Instructor.

Jan will make sure that your project receives attention in detail, analysis, design and quality controls, under his and your auspices. Follow up support and training is standard.

Affordable Solutions and Expert Support Services available for your Computer and Business needs include:
Database, Spreadsheet Accounting Support,
business system analysis programming, design analysis, spreadsheet conversions, database integration, coding and macro programming. Customized Manuals, Statistical Research and friendly support.



Customized programming and consulting can tailor computer work to your exact needs.
Giving you expert solutions in all areas of your work, saving you significant time and money.

J a n Levenson grew up in a family business that grounded his technical education in reality and practicality.

His hands-on teaching experience and unique understanding of personnel's role help him implement software programs he designs.

Professional software programming catered directly to your needs.

COMPUTERS can help you do your work faster and better, but before the magic begins, you must tell the computer exactly what you want. Computers, converse in languages foreign to most of us.

J a n Levenson speaks many computer languages known to computers and software of limitless uses.

SYSTEMS ANALYSIS-DESIGN
J a n routinely automates businesses, first analyzing needs and goals, next designing and writing programs tailor-made for the desired results.
Jan then assures ongoing success by training staff to use the systems and equipment correctly.

If you are contemplating developing an application or you are disappointed with your current software solution, you will profit from Jan's impartial and professional advice. J a n Levenson sells knowledge and skills.

Jan has worked as an instructor at the following entities:
CAMCARE Inc. - One of the largest U.S. hospital systems - Training hospital personnel, doctors and nurses to learn new SMS health software, students at: NIT - National Institute of Technology, West Virginia Career College, Garnet Career Center, Benjamin Franklin Career & Technical Education Center and Carver Technical Education Center.

J a n has trained business personnel of International based businesses to use various spreadsheet programs, database systems, accounting systems, word processors and the Internet. As a consultant for multi-national corporations, Jan has written many computer programs including the following :

• Scheduling Program
• PIM Personal Information Management System
• School Lunch Billing and Juice Program,
• Sales tracking software, and
• Database Audit Analysis Software for a major national health care provider.
He speaks the language of business: your language.
Custom Designed Programming
(30 day billing cycle arrangements available)
• Short-term • Periodic • Annual • Intermediate • custom designed services • Online Consulting Available •
Send Jan an Email and make a reliable working connection today.



Please send an email to discuss options that will work for you. I will offer you practical, logical and working solutions in a friendly and reliable manner.

Sincerely.


J a n S. L e v e n s o n

For computer spreadsheet help  and contact information send an Email
Send an Email request - thank you!



Go to computer solutions pageReturn to top of page



Quattro Pro, Lotus 123 and Microsoft Excel Macro Programming
Quattro Pro, Lotus 123 and Microsoft Excel Macro Programming
 

Jan Levenson lead programmer at Certified Computer Services is a Certified Adult Computer Instructor Programmer ⁄ Analyst. Offering software programming solutions for businesses of all sizes.   

Specializing in Excel, Lotus 123, Quattro Pro, FoxPro database and QuickBooks accounting software integration programming. Jan Levenson offers time and labor saving techniques implementing computer solutions that simplify your process programming labor intensive tasks to a few automated leisurely steps.    Headquartered in beautiful Elkview, West Virginia (USA), Certified Computer Services can help you solve business problems by using powerful computer software that can be used to your best advantage.

Certified Computer Services goal is to offer trust, confidence and a job completed correctly!

Certified Computer Services is listed in the Better Business Bureau's database of better businesses' with the highest public service rating possible.

The following Programming and Consulting jobs are in the experience portfolio of Jan Levenson and Certified Computer Services.   Jan Levenson has received many accolades on his work:

 


DATABASE SPREADSHEET PROGRAMMING DEVELOPMENT and SUPPORT
Project: Analysis Dentistry book keeping System written in Microsoft Excel
Client: Accounting Specialist Company specializing in simplifying Dental accounting bookkeeping systems programmed using Microsoft Excel
Description: Jan's programming / analysis skills assisted in developing a Professional Accounting System written specifically for Dental practices and could be used in small medical or health related practices or Small business offices. Real-time graphs are the key to the software that display for all profit and cost margin reports. Making this program a very to use accounting system with a WYSIWYG "what you see is what you get". Enter the data and see the data reports in multi colored graphs, accounting bookkeeping system.

Project: Stock Market Real Time Ticker Programming and Design
Client: Client in England using eSignal real time world wide stock exchange data analysis system
Description: Developed a Microsoft Excel Visual Basic add-on system with macro programming that enabled the client to receive live streaming ticker tape stock exchange data trends updated in real time every second so that instant micro trading decisions could be automated, playing the stock market. This program was designed as a custom add-on using the eSignal real time data electronic stream ticker tape data.

Project: Excel Spreadsheet Programming and Design Support
Client: J.P. Morgan Chase Finance
Description: Spreadsheet Microsoft Excel Visual Basic Macro programming, design and support.

Project: Accounting system update and rewrite in Microsoft Excel
Client: Nationally Recognized College
Description: Spreadsheet Accounting System rewrite in Microsoft Excel Visual Basic. This project included analyzing, debugging and adding new additions to an extremely large and multifaceted accounting system used by the college adding new design improvements and support.  Client exclaimed, "you really do help people, it is such a large and complex spreadsheet."

Project: QuickBooks Professional Programming Excel database conversion programming systems and Design
Client: MGMT. Group, Inc. Las Vegas, NV
Description: Jan programmed Visual Basic macros for the company that allowed the company to bypass manually entering data into QuickBooks. This process automatically imported data from satellite offices daily Excel spreasheets via secure email to the home office QuickBooks Professional Accounting System whereby with Jan's macro's, correct balanced accounting processes and flags were maintained in their QuickBooks Accounting system after importing each Excel set into their main office Quickbooks Accounting system, saving additional data entry costs (time and money) everyday.

Project: Shipping service tally sheet used to automatically notify apartment residence of shipping packages due to be delivered via email
Client: Nationwide Apartment Management Company
Description: Microsoft Excel Spreadsheet Visual Basic Macro programming, design and support. The spreadsheet was used to send emails to residences that were to receive packages via different mail courier services automatically with included shipping pickup information. A second generated log sheet was used for each resident to sign off with their name when they received their packages as noted. The sheet would automatically be reset as needed and recreated automatically on a daily basis with a backup of the sheet used for record keeping purposes and to remind residences of when packages were to be received or picked up using their shipping pickup preferences.

Project: Graphing Utility Usage Software Microsoft Excel Visual Basic
Client: Real Estate Management property's maintenance and utility usage records, Crescent Heights, Los Angeles, California 90035
Description: Automated Real Estate rental properties maintenance records usage 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 resulting usage and costs over a four year period of time for that user. Averages were presented in attractive easy to understand graphs. The charts could then be used for marketing or printed out for the client´s to visualize their consumption of different utilities over a period of time. Data was plotted on graphs showing usage in months and years and during seasonal events.

Project: Web Site Database Programming Project Support
Client: 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."

Project: Data Conversion to QuickBooks Professional - Real Estate Appraisal Service
Client: 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, Excel spreadsheet data was converted so that sales billing statements, addresses, quotes, client lists and invoices were instantly available in QuickBooks Pro with customer data ready to print (Quickbooks invoices and multiple page billing statements generated and emailed to clients for immediate payment and account processing).

Project: Equipment Maintenance Control Corporation automated Vendor Invoicing System (paperless office)
Client: Equipment Maintenance Control Corporation
Description: Jan developed an Excel system for EMC Corp. to automate their 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 and can be accessed), (a variety of customer transaction reports are automatically generated). The entire system is based on a paperless office model whereby most communications take place via email, computerized fax emails, PDF files, electronic messaging and automated payments. A data source and paper trail can be generated as a backup record system.

Project: Hospital Equipment Manufacturer
Client: Intra-op Monitoring Services, Inc.
Description: Manufacturer of high tech medical monitoring equipment. Jan developed a set of spreadsheets to analyze sales reps' commissions, sales and equipment product demonstrations. The sophisticated Excel program allows easier scheduling of sales and multiple product support sessions and national training by the national territory sales team.

Project: Multiple projects including conversion of complex Quattro Pro spreadsheets to Microsoft Excel formats and sophisticated interactive forms in Word Perfect.
Client: NOAA - National Oceanic and Atmospheric Administration - United States National Weather Service
Description: Converted a set of scientific related Quattro Pro spreadsheets to Microsoft Excel to generate statistical reports regarding nationwide river flooding potentials of individual river systems. CCS (Jan) won consecutive multiple bid contracts on projects including conversion of Word Perfect data entry forms to automated Microsoft Word data entry forms allowing easier data entry and functionality to reports in a Microsoft Office suite and word processing documents. Updating templates for forms as a vba developer. This increased efficiency in National office document processing.

Project: Microsoft Excel Visual Basic PLC Programming Logic
Client: Engineering Firm - Missouri
Description: Wrote a program that interfaced Microsoft Excel Visual Basic with mechanically machinery. The program could be used as a control panel and run several routines to maximize the bin content and then communicate to a $70,000 PLC (Programming Logic Control) machine that bagged food within seconds for a large food producer in California using a PLC interface to Visual Basic and Excel.

Project: Pharmaceutical Drug Trials event planning scheduling program written in Excel Visual Basic
Client: Johnson and Johnson Pharmaceuticals
Description: Multiple projects included developing an easy to use form for senior marketing people world wide in different international Locations of this billion dollar company to quickly calculate sets of dates of prospective Pharmaceutical Drug Trials (event planning scheduling). The program was written in Excel Visual Basic with a graphic interface.

Project: Lotus 123 to Excel conversions
Client: RAC Royal Auto Club Motoring Services, UK
Description: Converted and redesigned a complex and automated Lotus 123 accounting program to Excel for RAC "Royal Auto Club" internationally known Travel and Automobile Service Agency in England, U. K. The program imported and exported data as an important part of their sales person´s travel cost analysis accounting system.

Project: Contractors tool using Microsoft Excel
Client: Building contractor - TX
Description: Multifaceted Contractors tool using Microsoft Excel for sales people to quickly give 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 subcontractors was used to assist in the bidding process. Each sales person's portable handheld computer data could then be downloaded to the office computer to create lists of invetory and⁄or service sub contracting jobs needed in the purchases department for jobs. 

Project: National Education Consulting Services and Solutions Group, a National Education Analysis Resource for local statistics
Client: National Education Consulting Services and Solutions Group
Description: File Conversion Tool Kit Software update for a nationally known Education Consulting Services and Solutions Group in the United States. The Professionally used software product is used in house and offered as a flagship software product for student, teacher, school analysis, course and grade analysis and can be used for analysis accounting from different perspectives for education courses, teachers, students and strategic analysis programs to assess degrees of success and/or failures by various statistics.

Project: Project Milestones Analysis tool using Microsoft Excel
Client: Project Analysis System with automatic active graphing system
Description: A tool written in Excel Visual Basic that is used as an accessory project management analysis tool that integrates with Microsoft Project software to simplify initial scheduling of steps within projects and visual viewing the scheduling data. Comments made by the client "You did a knock out job on the project", "thank you Jan", "thank you for you lightning fast turn around",

Project: Development of a real time, multi membership, web based interactive Sports Statistical analysis entertainment program web site.
Client: Sports Statistical analysis entertainment program
Description: Development of a real time, web based multi membership web site interactive Sports Statistical analysis entertainment program

Project: Nutrition and Vitamin company software product using Microsoft Excel
Client: Nutrition and Vitamin related company
Description: Nutrition and Vitamin related company software product sold to clients. The program accesses a vitamin nutrition database so that a breakdown of foods consumed on a daily basis could be broken down to types of food eaten, units of protein, related vitamins, carbohydrates, cholesterol, amino acids by Gram, weight and calories. (protein, lipids, carbs, chol, sat fats, mono fats, poly fats, water, ash, calcium, copper, fiber, iron, mag, mang, phos, potash, selenium, sodium, sugar, zinc, thiamin, ribo, niacin, pan acid, foliate, folic acid, food, foliate, foliated fe, retinol, vitamin iu, vitamin rae, vitamin B12, vitamin B6, vitamin C, vitamin E, vitamin K, alpha carotene, beta-carotene, lycopene, gram weight amounts totaled daily for users for nutrition, weight gain or loss or food intake analysis).

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

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

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

Project: Real Estate Financial Analyst/Developer Automatic download of web site data to the client's computer for mass mailings
Client: Real Estate Financial Analyst/Developer
Description: Researched and developed automated software using Computer Automation Programming Tools, Network Automation's automation tools, Macro Express Tools, Automation Anywhere Automation Tethys Solutions that most powerful and capable automation programming tools currently available to automate complex sequences of different computer processes, Jan automated real time website download of system data to the client's office computer system for dispersion and mass mailing distribution (increasing sales, saving time and steps to sell real-estate. Jan programmed the macro languages creating a complete automatic download of real-estate foreclosure data and automatically calculated standard real-estate houses pricing practices used to establish the actual value of houses for sale, foreclosure or other real-estate uses, so that a current listing of actual prices with the brokers percent of profit on the sale included so that the real-estate broker could determine what properties were within the criteria they wanted to purchase and offer to clients and at the same time send mass mailing of thousands of currently available houses to prospective purchasing information, what ever real-estate descriptions about the properties so that the potential buyers could make a decision on properties they may want to purchase and send back to the broker a contract to finalize the sale, because all of the paper work determining standard methods of costing methods had already been prepared by the software, allowing and automated system, that could be updated on a daily, weekly, monthly or other schedule with near real-time data to make fast sales, offer excellent purchasing properties for clients, and after verification, of all of the paper work, a quick sale could be made, so you would have a happy salesman, and a happy buyer with purchase of their dreams, profit for the sales team and savings for the buyer, by receiving a no haggling form of buying and purchasing of real estate. this system could be used with many forms of real-estate, car and/or other researchable products whereby the computer data is available. with up to twenty comparisons of similar properties values so those quick sales could be made to potential home owners looking for low cost housing and ownership. RealQuest real estate web site was used for an almost inexhaustible list of foreclosure and any other type of real estate records for research and automated sales. This program could run 24 hours per day on a dedicated computer with internet access. It would take a team of computer data entry persons 24 hours per day seven days a week, to do the same work as the automated program.

Project: Advertising Mass Mailing Address Database
Client: Professional Typing and Computer Services Company
Description: Large Professional FoxPro address database system in the greater Charleston area for professional mass mailings and marketing.

Project: Invoicing spreadsheet Sales Analysis System
Client: 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.

Project: State Assets Inventory System
Client: 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.

Project: Truck Chemical Inventory System
Client: 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 batch data files processing, inventory database.

Project: Automotive Repair Service Analysis & Reporting System
Client: 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.

Project: Statewide Healthcare Comparative Analysis System
Client: 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 statistics of institutions in West Virginia for the West Virginia Department of Health.

Project: School Lunch/Juice Accounts Receivables and Program
Client: Catholic School System
Description: Wrote a School Lunch/Juice Accounts Receivable program interfacing a Lotus 123 Spreadsheet template with a FOXPRO database that was used by each student to have a credit card like account where lunches and juice money payments could be charged and monthly billing statements conveniently sent to parents bi-weekly or on a monthly basis.

Project: Elevator Sales Invoice System
Client: Dover Elevator Company
Description: Jan designed a FoxPro database 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 ."

Project: Turner Construction Company Internal Accounting Database Analysis program to satisfy government report requirements and print reports.
Client: Turner Construction Company
Description: Won multiple bid contracts from this international construction company. Jan was asked by a senior CPA Financial Analyst for this international company to design a customized database program that could be used to categorize and analyze employee payroll records for multiple projects that each employee works so that the payroll system could run more efficiently and reports could be based on governmental reporting requirements. A complicated set of employee and project records could be maintained and reports printed for a wide variety of payroll systems and analysis. The database program was written in Visual FoxPro Database language compiler programming. The financial analyst told Jan that "he was glad Jan was working on the database program because Jan's understanding of programming⁄analysis was simplifying their payroll records and streamlining their overall accounting system".

Project: Medical Insurance Cost Analysis System
Client: 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".

Project: Visual Basic Business Programming and Design
Client: Royal Guard Fence Company
Description: Lotus 123 Bid Sheet program converted to Microsoft Excel. This project included programming, design analysis and support. This Bid Sheet presentation tool was converted and included two different databases in Excel that were automated and integrated with Visual Basic macros that simplified and enabled the (sales team) users to quickly generate and submit bids for potential jobs. A separate integrated Excel spreadsheet gave the management an overview from every accounting perspective of the costs, profits and account breakdown on potentially large bids to better manage their bidding process, project management and planning.

Project: Excel Programming and Design
Client: BioTrak Corporation
Description: Excel spreadsheet template for customer proposals given to customers as a free financial spreadsheet interactive model. Program implemented drop down menus and automatically populating cell areas with data depending on the selections chosen by the user. Customers enjoyed receiving the software for their own use and financial review of discount factors used in their proposed portfolio of financial options performance analyst for personalized software.

Project: Excel Spreadsheet Programming and Design
Client: National Art Gallery of Canada
Description: Jan converted their Quattro Pro spreadsheet to Excel, redesigned and simplified their spreadsheet bookkeeping system enabling their spreadsheet system to work better maintain more data records, operate more smoothly and include more reliable automation, reports and auditing.

Project: Party Sales Fund Raising Business
Client: 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.

Project: COBOL Programmer ⁄ Analyst
Client: West Virginia Department of Employment Security
Description: COBOL Programmer ⁄ Analyst for the State of West Virginia Department of Employment Security, Division of Labor and Economic Research, Jan wrote a COBOL program that calculated and printed WV unemployment statistics. Jan organized extensive and detailed flowcharts and designed a written analysis of a complex COBOL program for State employment and Federal employment records, part of a Federally funded computer project.

Project: Accounting and marketing support
Client: Foxfire Vacation Resort
Description: Vacation resort and family recreation center. Helped with advertising campaign doubling the company's business. Assisting with Accounting System overhaul, mass mail marketing brochures and database support.

Project: Computer Instruction & Organization Advisory Council Member
Client: 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 record bookkeeping and practices training.

Project: SMS Health Record Software
Client: CAMCARE, Inc.
Description: CAMCARE Inc. - As a Programmer ⁄ Analyst several of Jan's security and programming module design concepts were used in the actual run time version of this worldwide software record keeping product. As a trainer in one of the largest national health care systems in the United States- Jan 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. This software allows less error in patient medical records so medically decisions can be made quicker and more reliably.

Project: Accounting Software Systems Analysis and Program Implementation
Client: 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

Project: Excel Sales team and individual sales analysis system.
Client: 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.

Project: First Run Features, Theatrical media booking agency, New York, New York
Client: First Run Features
Description: Supercalc to Excel legacy accounting spreadsheet systems conversion services.

Project: Veterinary Financial Software Design Consultation
Client: Veterinary Hospital Finances
Description: Enhanced integration insight overview of Excel accounting spreadsheet data analysis programming and design consulting services for a nationally known veterinary practice in California featuring peer group analysis networks solution integration source code programming. transforming consolidated accounting practices, systems evaluations demonstrations, easy-to-use technologies,

Project: Lotus 123 to Excel conversions
Client: 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.

Project: Lotus 123 spreadsheet programming macro updates for Trinity Lutheran Church accounting
Client: Trinity Lutheran Church
Description: Conversion of early Lotus 123 spreadsheet to newer version of Lotus 123 macros.

Project: Vertical Sales Mass Mailings Marketing
Client: Servco Fasteners
Description: Designed a vertical sales marketing direct mass mailing database for the Servco Fasteners Company.

Project: Lottery Program
Client: Gaming client
Description: Designed a lottery game program in Microsoft Excel that simulated random Lottery ball pulls.

Project: Statistical Analysis Questionnaire
Client: 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 real time. The program is menu driven with viewing and printing options menus within Quattro Pro.

Project: Designed an Excel program that simplified the sales telephone, faxing and email contact order system
Client: Maddox Shelving Sales Company
Description: Designed an Excel program that simplified the sales telephone, faxing and email contact order system to help speed up and increase sales for a Midwestern company that sold volumes of Maddox shelving products.

Project: Superior Test and Balance Inc.
Client: Superior Test and Balance Inc.
Description: Designed an automated spreadsheet for equipment maintenance, quality control and certification records.

Client: Professional musician, Greenbrier Hotel, sheet music transposed notations

Project: FoxPro Programmer
Client: Osteopathic Physicians of West Virginia Inc.
Description: Jan programmed an organization database based on logic that was used to produce form letters, maintain member´s information for organizational support and political action benefiting the group.

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

Project: Business Support and programming
Client: Auto Repair Service Center
Description: Computer assistance, trained employees, programmed and support for QuickBooks used in a professional NAPA auto service/repair business.

EDUCATIONAL TEACHING POSITIONS HELD BY JAN LEVENSON

Institution: Capital High Community Education Teacher
Position: Technical Education Center Instructor, Industrial Computer Trainer

Institution: Benjamin Franklin Career & Technical Education Center
Position: Computer Instructor

Institution: Training Place, Town Center Mall, Charleston, WV
Position: Jan instructed a wide variety of computer classes including technology and computer learning software strategies for business increasing a data rich environment using Analysis, trends, visual graphic representations (numeric data graphs) easy-to-use technologies, increased efficiency, logical operations, security, solutions, better results, controlling strategies, reduced errors, more reliable software performance, strategic issues. 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 classes in computer business related technologies.

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, Accounting, RPG, COBOL and BASIC programming. Logic and Systems Analysis, programming and coding strategies. Transparency of accounting, utilizing network based telecommunications and computer systems programming tools.


Project: Industrial Instructor Training Programmer
Client: Federal Express
Description: Jan was selected as a spreadsheet-training consultant to train employees of Federal Express.

Various:

Jan was a payroll operator in charge of payroll processing and accounting system maintenance at a large Garden Center Business.

Jan has programmed many applications for Spreadsheets (Quattro Pro, Excel, Lotus 123), file recovery, formulae conversion customized accounting software database systems for a wide variety of businesses and institutions including strategic analysts, interactive data analysis, forensic investigations.

System Analysis tools and techniques are used to analyze the needs of prospective client’s accessory software program integration and uses, interfacing various software programs and data sources, and advising each client on the correct use of the recommended software programs. 


Certified Computer Services is listed in the Better Business Bureau's database of businesses with the highest business recommendation rating possible.

Copyright © 2008 Certified Computer Services
 
Send an Email !
VisaMasterCardDiscoverAmerican ExpressPayPal









Automation Software for business, consulting, sales, scientific, automated techniques software, voting systems, opinions research, automated data mining, and databases integration turned into simple to use turn key systems. Web site integration, Spreadsheets, Microsoft Excel, Lotus 123, Quattro Pro, FoxPro, MySQL, databases, QuickBooks accounting, billing, inventory, integration, migration, PLC (program logic control), word processors, data management, programming hardware and software integration. The user is responsible for all computer hardware, software, licenses, network software, secure connections, internet access, if internet access is required for your automation process). Specialized databases, web sites links, electronic services, licenses or subscriptions that will be used within the automation process. Integrate processes into one automated process that can be initiated from your computer desktop. The automation software automated services supplied by Certified Computer Services allows all processes that the user can produce manually to take place at a certain time or time interval. Contact Jan at Certified Computer Services for a free proposal for your project to determine the amount of labor hour units that will be necessary to complete your automation project. Make the magic happen! Projects will be accepted on a first come, first serve basis. Project time line will depend on the current workload. Please contact us to discuss special issues and options that are available for your automation project. For real estate related research purposes the user would need a subscription to a real estate database site similar to RealQuest.com and have access an internet connection, a dedicated computer and /or software that to obtain the users results. Real-estate foreclosure or any available criteria to search for (potential clients) and automatically calculate standard real-estate comparable houses pricing practices to establish the actual value of house. A current regional area listing of actual price percent of profit, on the sale can be determined by criteria variables that are previously defined, and offered to (prospective customers for a particular product). Potential buyers could make decisions on properties they may want to purchase and sign an agreement or contract to finalize the sale, via automated email, fax and / or courier services. Real Estate Financial data can be automatically downloaded from a web site similar to www.RealQuest.com, logical, operations multiple sorts and filtering of data, formulas applied data manipulation automatic mass mailings by e-mail or courier services can be sent to potential clients. Up to twenty comps of similar regional properties are compared and the correct value determined by the user by way of formulas. Quick sales can be made to potential home owners looking for low cost housing and ownership. www.RealQuest.com real estate web site was used for an almost inexhaustible list of foreclosure and any other type of real estate records for research and automated sales. This program should run on a dedicated computer without interference except for periodic observation, by the user that it is running correctly, (viewing program logs). Computer Automation Programming Tools allow automation to be commenced from your desktop to produce sophisticated, complex, elaborate reports (for your particular use) (mass mailing lists, pre sales contracts can be signed on a near instantaneous basis. Automate complex sequences of computer processes, automate real time websites, download of current data for dispersion and mass mailing distribution (increase sales, saving time and money to sell specialized products or services, collectibles or information mining, in one step using one computer. Paper work prepared, and sent to prospective customers. Reports can be updated with fresh data searches resulting in live data to make, new exciting offers for clients or buyers, researches, analysis, etc. After verification, contracts can complete the deal; a quick sale can be made. Customers (clients) are happy with fresh data to make quick finds treasured deals, decision report filtering, sorting, tally, sophisticated data manipulation, logically based data for distribution for the user to obtain results they are seeking. Personal use or professional use - many options are available to automate processes. Customers purchase their product; the user can set profit margins and / or use a no haggling form of buying and purchasing. This system can be used in many different forms, different areas of commerce, research etc., or other researchable products whereby the computer data is available. The automation can be tailored to your exact needs. It could take teams of computer data persons 24 hours per day seven days a week, to do the same work, as the automated program on one computer. The speed of the automation depends on the software languages used, the speed of the computer and peripherals, the speed of the internet connection, and the complexity and number of formulas and/or or programming routines that are necessary to derive at a particular set of reports of data for the user. It is the user's responsibility to supply the internet access, data, web hosting service for a dedicated web site server, data computer ready lists, database software, subscriptions, any special language licenses for the computer hardware or software, other than the automation software licenses that will be supplied by our company. There are many solutions that are available that may require more or less programmed labor hours. Customized automation macro advice and automation software license starts at $650 U.S. dollars. This includes 10 unit hours programming analysis at $65 U.S. dollars per hour. Contact CCS for a free proposal to determine how many unit hours will be necessary to complete your project. (What will be involved and how long your project will take to complete) before you finalize and purchase work hours to be applied to your project. An abbreviated description proposal with an estimate to complete you automated process will be included and sent to you for your review. Contract agreement services are available and special arrangements may be considered. The automation process is dependent on a repeatable set of commands (no matter how complex) that you currently use or are wanting to use to obtain a particular computerized result. The automated process can be repeated as needed. Many services are available at www.ccsplus.com listed on the Better Business Beaurow Web site bbb.com as Certified Computer Services with a satisfactory (highest) customer rating. Contact CCS for a free estimate to determine how many programming labor hours and or other costs will be necessary for your project. Thank you. All requests will be kept confidential and answered as completely as possible. Project work is portioned in a "work as you go basis", so you can see progress being made on your project taking place before making further payments and commencing to the next step of your project. On a large or very complex project it may be necessary to charge for one to several programming analysis hours of labor to make a careful evaluation of what is needed to complete your software project. Please contact CCS for a free estimate on what is needed to proceed to on your project. Thank you. Sincerely, J. S. Levenson Certified Computer Services Certified Computer Services is an experienced computer company offering solutions for many computer programming topics: including (spreadsheets workbooks, worksheets and advanced tables) converting outdated programming to newer versions of software (databases, spreadsheets, Excel, Lotus 123 and Quattro Pro). formulas resulting in easier to use, more meaningful information for the end user.

Current professional software support includes: software analysis and deployment, enhanced functionality, development, digital processing, faster speed optimization, increased efficiency, logical operations, security, solutions,better results, controlling strategies, reduced errors, more reliable software performance, strategic issues, risk assessment, rapid software development, modeling operations, transparent help desk, web based, virtual office, verify accuracy, spread sheet programming macros and scripts programming development, help with VBA Visual Basic applications macros, Microsoft Excel, Corel Quattro Pro, Lotus 123, Visual FoxPro, QuickBooks Professional, technical writing, editing, technical manual writing editor, database management control, hospitality management systems - micros pos spreadsheets interfacing with Microsoft Word, Word Perfect, Windows Professional, XP, Vista, Microsoft Visual FoxPro, Computer animated graphics, internet web design html, css, Java, seo search engine optimization editing, web page development, Paint Shop Pro imaging, desktop publishing, structured programming techniques, Logic&flowcharting, applications development, accounting programs Intuit QuickBooks professional integration, forensic data password recovery research, accounts setup, systems analysis and design.

A certified computer professional helps you with your work. Solution Provider, custom designed unique turn-key automatic applications.
If you need help converting Lotus 123 macros to Excel Visual Basic macros, Quattro Pro to Excel VB macros, databases, spreadsheet programming. linking scripts macros, interactive, skills accounting management system, software integration, software development. Online spreadsheets, computer help desk available 24/7/365. Applications programming development designed for Lotus 123, designer spreadsheets, Visual FoxPro - VFP - Visual Basic- Teacher educator trainer can help and be of assistance. accounting system integration, template advanced programming, app integration, application automation, architecture database, automated integration, automation interface, business spreadsheet, calc conversion, chart analyst compiler programming, applications analyst, clipper conversion, coldfusion programmer, computer applications help, computer programming logic, computer coders, Facilitating, support, programming methods and results. Automated computerized programming. marketing advertising. If you ask,"where can I find good computer help"or"I need help with a computer Project?"Or"who can I trust to find programmers computer work offering Reliable help?"Online database systems. Languages compatible for most available software and computers. Contact Certified Computer Services. Our specialty is to solve problems with easy to use, customized database and spreadsheet programs, complex large spreadsheets, original out of the box creativity, flexible macros and scripts solving complex problems. If you need temporary help, our staff is technically and computer ready to help. Professional spreadsheet computer help is a call away + simplify your work load - business spreadsheet solutions, get more done in less time - data entry forms - input output menu driven applications with multiple choice easy to use menu systems for database and spreadsheet and accounting systems.( buttons, pull down, multi choice menus) Jan Levenson, software developer has developed distributed spreadsheet systems using excel software integration source code hardware integrate applications, integrate apps integrating software, integrating systems, excel 6.0, lotus 1 2 3,lotus 9.8,123 97, 1-2-3 Millennium Edition, Excel XP, Quattro Pro 9, or Calc 6, Quattro Pro for Windows, Microsoft Excel 5.0 6.0 7.0 1.0 dos versions lotus approach, lotus conversion, lotus smart suite, lotus SmartSuite 9.8, VB , vb6 excel VB FoxPro, vb net excel, vb net FoxPro, plc automation, lotus SmartSuite millennium, Microsoft access spreadsheet, Microsoft office spreadsheet, FoxPro database software, internet programmer, FoxPro, visual basic, excel dbase, spreadsheet 123 accounting Jan Levenson lead director of programming and Certified Computer Services provide the following: engineering programmer, IT programmer, excel consultants, excel conversions, excel developer, excel experts, excel migrations, excel relational database managers, excel spreadsheets,find programmers, FoxPro access, FoxPro conversion, function programming, historical analyst, India programmers, applications architecture, softwares management, solution, solutions, technology, interface programming, Linux programmer, Macintosh macro programmer, methods analysts, Microsoft spreadsheet help, model analyst, model database, monthly spreadsheet,ms access conversion,ms access spreadsheet,ms spreadsheet, object oriented spreadsheet,odbc database,office web components spreadsheet, online programming course, open conversion, opens source conversion, Openoffice conversion, pivot table spreadsheet, pocket pc custom, price analyst, problem analyst, process analyst, process control automation, process migration, process software, product integration, product software, production analyst, professional programmer programing computers, programing help, programmer agreement, programmer developer, for hire, India, programmers help project integration, project management integration, project management software, management spreadsheet, migration, quality control, project spreadsheet, PeopleSoft, paradox conversion, qa programmer, quantitative analyst, Quattro conversion, quickbook developer methodology, quote analyst, Rdbms database, query spreadsheet, requirements software, research analyst simulation analyst software integrators, software life cycle, lifecycle, methodologies, methods, models, programmers, sdlc,analysis spreadsheet converters spreadsheet, databases spreadsheet developer, spreadsheet development, doc, document, engineering forecasting, format, forms, formulas, functions, help lotus openoffice, operations, optimization pdf, pro, problems, programs, projects report, research share, simulation source code, statistics stocks, table techniques, template testing, tools, trading sql conversion,sql migration statistical analyst, analyst support programmer, systems administrator, systems automation, systems programmer tables, technical programmer calendars, telecommute programmer, text to conversion, Toronto tutor trade trading analyst, training automation, transportation analyst, Unix programmer vb excel, vb6 programmer, vba programmer,vba,visual basic 6 programmer, visual basic accounting, visual basic automation word, works conversion, wps conversion, xls, xml programmer. Save money (up to thousands of dollars) Contact us for customized programming analysis services. Thank you!

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 .

Help is a click away!

Please Email for expert, reliable help and assistance today. Thanks !








Help is a click away!

Please Email for expert, reliable help and assistance today. Thanks !











Certified Computer Services is listed in the Better Business Bureau's database of businesses with the highest business recommendation rating possible.

Copyright © 2008 Certified Computer Services
 
Send an Email !

Visa

















        Certified Computer Services Company
        Offering Excellent help Writing and Designing 
        Spreadsheet and Database Applications.
         

Email Jan for expert computer programming, analysis, design, help and assistance today. You will be glad you did . Help is a click away!




Go to computer solutions pageReturn to top of page