SQL Excel

Description: Excel Macro, package FREE – Simple Import external data in order to analyze in Excel  – Works with ODBC compliant data sources: SQL Server, Oracle, Sybase, Access, MySQL, Firebird, DB2, etc. … – Compatible with Excel 2000, 2002 (XP), 2003 and 2007 Date created: 11 Jun 2008 Size: 3 MB Type: exe Author: Al … Continue reading SQL Excel

StatistiXL

Description: Tool and statistical analysis to Excel. The data stored in spreadsheets can be immediately subject to various statistical tests (analysis of variance, correlation, contingency table, factor analysis, linear and circular descriptive statistics, etc..). The software also offers a wide selection of plots (scatter trace, normal probability plots, etc..). And as the results are placed … Continue reading StatistiXL

StatBoxPro Powerful statistical analysis

Description: Ms-Excel StatBoxPro transforms into a powerful statistical analysis (descriptive statistics, tests, factor analysis, classification, analysis of variance, …) It is fully integrated with MS-Excel. You select your data directly into Excel spreadsheets and graphs and the results are also placed in the leaves. email: info@grimmersoft.com File Type: Shareware Excel version required: Excel 97, 2000, … Continue reading StatBoxPro Powerful statistical analysis

Pareto dynamic

Excel file for checking whether a list of data values ​​and respect the Pareto principle (20-80).  The code allows for calculations, graphics and interpretation. This works regardless of the size of the list. Creation date: March 1, 2009  Size: 725 KB Type: xls Author: Francois Flament

Decid

DECID is intended for entrepreneurs, designers, students, training organizations, and expert advice. DECIDES, a uniform and structured approach to formalization of business project. DECIDES publishes Business Plan for your file and runs Microsoft Excel Tm. The downloadable version here is a version of presentation, it is complete and becomes fully operational on receipt of user code transmitted following … Continue reading Decid

Turnover calculation

Description: Three tables that calculate directly a turnover estimated thanks to the three known methods of linear fit:. the method of endpoints. Meyer’s method. the least squares method is ideal for business students.  email: mapa@tiscali.fr File Type: Freeware  Excel version required: All  OS supported: PCMac  Creation Date: 31 Aug 2007  Size: 49 KB  Author: Pascal STONE Website: … Continue reading Turnover calculation

Evaluation of the cost of purchase

Description: This program assesses the resale price of products purchased, a coefficient multiplier. The VAT differential between purchase and sale, net and gross margins may also be targeted.  The point is how to manage one or more products based on economic criteria, balance sheet, income statement, even. The program uses the VALUE TARGET, put it is automated. Useful … Continue reading Evaluation of the cost of purchase

Projects budget

For use by would-be creators wishing to have the status of TNS (not employees) Calculating a basic assumption; impacts of changes in key data; review of the cash the first months; break even … email: belleville@sobec.experts-comptables.fr File Type: Freeware  Excel version required: Excel 97 + OS supported: PCMac Creation Date: 31 Aug 2007 Size: 239 … Continue reading Projects budget

Annual Budgets for Enterprise

New version 2.0, adding the concept of cost center. Implementation monitoring of annual budgets by cost centers and types of expenses Directorates and Departments of Enterprise.  Carried out in Excel, the purpose of this application is to enable the monitoring of annual budgets by types of expenses Directorates and Departments of Enterprise. It allows you to … Continue reading Annual Budgets for Enterprise

Activity Schedule

You can set this schedule with the actors and activities. Each sheet represents one month, and each day can be divided into two parts or not. To generate it, follow the instructions in the “Settings” page (it takes leap years). This new version contains a sheet  “Stats” that recognizes activities in half-days per month and per year. … Continue reading Activity Schedule

Annual Planning

Description: This program manages an annual schedule. It enables the recording of leave laid, the hours worked. One can generate several years with the French public holidays (can change the list of holidays).  Features: – Ability to manage twelve codes of the absence or presence of custom. – Ability to define and implement a series of … Continue reading Annual Planning

Planning SSIAD V5-2

Description: This file is used to manage the planning of a nursing service (or other) of 51 individuals with monthly schedule for all service and print a schedule for each employee. creative planning with rolling. Included time management, the number of salaries required for the service. email: christian.raoux @ wanadoo.fr File Type: Freeware Excel version required: … Continue reading Planning SSIAD V5-2

Pental 30

Description: Here’s a spreadsheet to track the work attendant systematic work of a bottling company, and by minutes per section (s). It is unpretentious but it allows a daily monitoring of all interventions.  I do not doubt for one moment that this sheet can be significantly improved, and I count on all of you to do … Continue reading Pental 30

Calendar TOSS

Description: A new calendar to manage working time. Discover. News of January 29, 2005: Adding a menu to navigate through the various options. Help is available in sheet1. email: denjoly@wanadoo.fr File Type: Freeware Excel version required: Excel 2000 + OS supported: PCMac Creation Date: January 29, 2005 Size: 503 KB Type: zip Author: Denis Joly

Calendar DFConcept

Planning management of working time. email: denis.flamand @ wanadoo.fr File Type: Freeware Excel version required: Excel 97 + OS supported: PCMac Creation Date: 10 Apr 2006  Size: 608 KB Type: zip Author: Denis FLEMISH Version: 8.0 Website: denis.flamand @ wanadoo.fr

Salary

Description: This workbook created in Excel 97 is intended to facilitate the preparation of pay slips to a household employee. You will find, associated with the file 40.xls Salary, the text of the “National Collective Bargaining Agreement for employees of particular employer.” Version 4.0 now allows to choose between membership fee or real wages. Furthermore … Continue reading Salary

Payroll Plus

Description: Payroll Plus version 8 to edit payslips for a company with a maximum of 9 employees, as simply and as quickly as possible, while remaining the most effective. In this version display in Euro (EUR) takes priority. email: @ paie.plus netwizz.net File Type: Shareware  Excel version required: Excel 5 + supported: PC Creation Date: … Continue reading Payroll Plus

Control services

This application allows to calculate the benefit of staff members based on their schedule. Navigation between the sheets is done via a list UserFrom which leaves except the hidden sheet.  Similarly a UserForm can remove the excess media (except the three sheets needed.) Code prevents a leaf without name is created (with the default name sheet1) … Continue reading Control services

Payroll for Marocco

Payroll for Marocco – Statement of pay for working in Marocco. Regime employer social security and income tax base overall 2008 for Marocco. Bareme WRI 2008. Creation Date: 25 June 2008 Size: 173.50 Kb Type: xls Author: A. BRAIKI

Payroll for Tunisia

Payroll for Tunisia – Statement of pay for working in Tunisia. Regime employer social security and income tax base overall 2008 for Tunisia. Bareme WRI 2008. Creation Date: 12 Mar 2010 Size: 173.50 Kb Type: xls Author: A. BRAIKI

Expense Automation – management of costs

Euromatic Expense automates the management of costs in corporate notes, since the input to the Integration Accountant.  Key Features: * Parameter setting spending limits for each category of employees, and according to their area of ​​displacement. * Setting up accounts accounting, account titles, names of services, information about your procedure expense, etc … * Control … Continue reading Expense Automation – management of costs

Expense Note Cost

Description: NOTE Cost is a model of classical note costs that can easily be adapted to most companies. It appears automatically the tax amounts and generates accounting entries. Creation date: 27 May 2006 Size: 30 KB  Type: zip Author: Euromatic Version: 1.0  Website: http://euromatic. online.fr/

Payslip

Description: Here is a payslip on excel with the calculation of overtime and absences. Creation Date: January 24, 2009 Size: 507.00 Kb Version: 1.0  Type: xls Author: Lawrence DCG2 MILLIE. Lurçat Maubeuge

S3201 certificate sick pay

Description: The certificate of pay to complete and send to the CPAM when an employee is sick or is on maternity or paternity leave FDF format (PDF autoremplie). Creation date: March 24, 2009 Size: 158.05 Kb Version: 1.0 Type: zip Author: Claudusaix Website: http://claudusaix. spaces.live.com/ spaces.live.com /

Model of Fax

Description: Stop wasting time trying to write a fax in French, English and another one third in German. Pour faire face à la mondialisation, To cope with globalization, here is a sheet that allows to apply indiscriminately to francophones, anglophones and the Germanophones. Nothing more simple and effective to treat the image of your company, … Continue reading Model of Fax

Model specifications

This sheet will allow you to quickly offer your customers clear and professional estimate. After entering the information necessary header (recipient, delivery time, ect.), Just type in at least a certain quantity and unit price per item for a total cost. This cost may possibly reflect a percentage discount, with the option of archiving your quote … Continue reading Model specifications

Sample Invoice with carbon copy

It is not uncommon to have a double or a triple bill aimed at accounting services to your customer. This model can automatically fill the original and the copy just as you would have done with carbon paper. Duplicate invoice Size: 53 Kb Type: zip Author: ROBERT René Version: 1.0

Generate a list of addresses

Description: This file has to generate pages of addresses from an alphabetical list. Each page can then be inserted into the handheld organizer of your employees. Also possible to edit envelopes and labels according to your database of addresses. Size: 160 Kb Type: zip Author: ROBERT René Version: 1.0 Website:

Planning special leave

Description: Planning special leave, just put the start and end of holidays and the number of days absent this calculation automatically taking account of public holidays and Saturdays and Sundays. Size: 61 Kb Type: zip Author: ROBERT René Version: 1.0 Website:

Medical follow-up of company personnel

Description: This file “medical monitoring” allows a company to track and review your medical staff. Upon opening the file you will immediately be notified through an alert message of invitations to perform. Choose the number of days warning before the due date. Size: 125 Kb Type: zip Author: ROBERT René

Planning for monitoring appointments

Description: With this file follow your appointments. An embedded calendar and schedule are on hand to choose the dates of appointment, three forms are provided (New – List – Cancellation of appointment), Ability to print the list of appointments to the selected date. Size: 56 Kb Type: zip Author: ROBERT René Version: 1.0 Website:

Planning monitoring Reservation

Description: Planning special room reservation, simply set the start and end of the book to see the schedule will accrémenté. Ability to add the number of room of your choice.  Reservations will be automatically deleted obsolete when opening the file. Automatic detection of whether or not a reservation according to the dates entered. Size: 223 … Continue reading Planning monitoring Reservation

Follow-up appointments 15 minutes

This file contains a follow-up appointment dates. Thanks to a built-in calendar, simply select the date and time and then “Submit” to your schedule is incremented. The range of appointment is 15 minutes Highlights: Automatic deletion of old appointments beyond two months before the current date and automatic detection of appointments already made. Size: 3248 Kb … Continue reading Follow-up appointments 15 minutes

Follow-up appointments 20 minutes

This file contains a follow-up appointment dates. Thanks to a built-in calendar, simply select the date and time and then “Submit” to your schedule is incremented. The range of appointment is 20 minutes Highlights: Automatic deletion of old appointments beyond two months before the current date and automatic detection of appointments already made. Size: 3248 Kb Type: … Continue reading Follow-up appointments 20 minutes

Follow-up appointments 30 minutes

This file contains a follow-up appointment dates. Thanks to a built-in calendar, simply select the date and time and then “Submit” to your schedule is incremented. The range of appointment is 30 minutes Highlights: Automatic deletion of old appointments beyond two months before the current date and automatic detection of appointments already made. Size: 3248 Kb Type: … Continue reading Follow-up appointments 30 minutes

Model of invoice and specifications for masonry

This workbook contains a quote convertible invoice, special masonry with a database of over 8255 rates (Batiprix) of different body (Structural work, plastering, carpentry, cleaning and many other), with a menu with forms down, make an estimate or invoice will be very simple and easy. Rates are changed with a single click with the increase of … Continue reading Model of invoice and specifications for masonry

Invoice Template

Invoice Template designed for designations to Vat 19.6% and 5.5%, according to a database of pre-entry of your customers and appointments, make your bills easily with the ability to archive it to them out at any time. Size: 2747 Kb Type: zip Author: ROBERT René Version: 1.0

Technical Analysis and Stock Information V2

V2 Technical Analysis: The Three Line Break (Break Line three), Bollinger, SAR, OVB The novelty of this second version is the famous Three Line Break in Excel developped and described by Steve Nison you can view it on a graph. Passionate trading and technical analysis, excel spreadsheet that will also allow you to develop your … Continue reading Technical Analysis and Stock Information V2

Stocks via MSN Course

This excel file to retrieve the site of MSN’s share price to update the valuation of a stock portfolio. This model excel facilietra manage your stock investments and your financial investments by accelerating the recovery of stock prices.  flyonets@yahoo.fr Creation date: 22 May 2007 Size: 25 KB Version: 1.2 Type: zip Author: Francois Launay

Monitoring Portfolio – Portfolio Management

 Model “Portfolio Monitoring” allows continuous monitoring and periodic evaluation of a list of values ​​and investments. The model excel to enter investment transactions for a period of monitoring and managing its portfolio optimally. Furthermore, incremental investment transactions undertaken during a period are fully explained in the calculations of the performance period. Turnover included in the model … Continue reading Monitoring Portfolio – Portfolio Management

Portfolio Optimization – Portfolio Optimization

Model “Portfolio Optimization” calculates the optimal capital weightings for a basket of investments that gives the return on investment for the higher risk whatsoever. High return on investment and risk monidre here is that stock market investors should satisfy the most demanding. The unique design allows it to be applied to brochures financial instrument or business. The ability … Continue reading Portfolio Optimization – Portfolio Optimization

XlsCorrelation

Easily track the correlation, volatility and the historical max drawdown between two actions with this simple and effective application. XlsCorrelation : From two tickers Bloomberg XlsCorrelation: 1) Download the course of two actions 2) Calculate the correlation between the two actions within 3 year rolling 3) Calculate the maximum drawdown 4) Calculate historical volatility. Creation … Continue reading XlsCorrelation

Regression Forecasting – forecast analysis

The model of “Regression Forecasting” is an effective basis for identifying value drivers and forecast financial data as part of stock market investments. This excel file uses a range of statistical measures to examine the validity of the analysis results are summarized in text for ease of use. Once reports have been identified, financial projections may be … Continue reading Regression Forecasting – forecast analysis

Accounting Balancesheet

Accounting Balancesheet Excel is an application compatible with open office. It will allow you to make the accounting of a non-accounting but only know the main principles. Already more than 5000 users in France, many clubs, once paid, the author now offers to all. WITHOUT ACCOUNTING, comptabilan will allow you to make write-offs, income statements, balance … Continue reading Accounting Balancesheet

Cooperative Accounting Class 22.1

This very accomplished Excel sheet was written to facilitate the bookkeeping of the cooperative class. It behaves much the structure of the specifications provided by the accounting OCCE. The bookkeeping are simplified to the maximum; ventilation and the production of the annual review are automatically generated, thereby eliminating the risk of potential errors.  (Developed with Excel … Continue reading Cooperative Accounting Class 22.1

Doc AidCompta

Accounting assistance of a private doctor – Must be usable by any profession. Facilitates accounting tables requested by AGA Automates scales balancing items Allows calculation of driving costs (scales) allows the calculation of business tax actually due … Date created: 21 Jun 2004 Author: Jean-Luc Perrot jlperrot001@wanadoo.fr jlperrot001@wanadoo.fr Size: 32.3 KB Type: zip

Micro enterprise

Micro-enterprise, by the simplicity of administrative requirements, may have disadvantages: Absence of data to monitor management, Difficulties in the banking relationships because of the lack of papers. Inability to have a basis for discussion with an accountant asked for advice, counsel. This module allows to fulfill the basic obligations of the micro system: Bookkeeping Newspaper … Continue reading Micro enterprise

Ratio Tree

Details : A simple and comprehensive tree of ratios for most businesses in Excel. Size : 46 ko Type : xls Author : Strategy Expert Web site : http://www.strategyexpert.com/

EVA Model

Details : Excel template worksheets for calculating Economic Value Added (EVA). In corporate finance, Economic Value Added or EVA is an estimate of a firm’s economic profit – being the value created in excess of the required return of the company’s shareholders – where EVA is the profit earned by the firm less the cost … Continue reading EVA Model

Project Plan

Details : Project Scheduling Template currently setup for a Balanced Scorecard Project. Project versus Business. The Finance perspective: Project Cost Overrun (PCO). The Customer perspective: On Time Delivery (OTD). The Process perspective: Resources Planning Accuracy (RPA). The Learning perspective: Project Management Quality (PMQ). Size : 170 ko Type : xls Author : Business-process-it.com Web site … Continue reading Project Plan

History

Details : Menu driven Excel program (must enable macros) for Historical Financial Statements from the book Analysis for Financial Management. Size : 429 ko Version : 5.0 Type : xls Author : Robert C. Higgins Web site : http://www.mhhe.com/higgins8e

DCF

Details : Menu driven Excel program (must enable macros) for Discounted Cash Flow Analysis from the book Analysis for Financial Management. Size : 382 ko Version : 6.0 Type : xls Author : Robert C. Higgins Web site : http://www.mhhe.com/higgins8e

Master Budget Model

Details : Excel sheets multi-period multi-product budget model for a fictional bicycle manufacturing company. Size : 168 ko Version : 2010 Type : xls Author : Jason Porter, PhD at University of Idaho and Teresa Stephenson, PhD at University of Wyoming Web site : jporter@uidaho.edu and teresas@uwyo.edu

Simple ABC Model

Details : Microsoft Excel workbook with a simple model that illustrates Activity Based Costing. costing model that identifies activities in an organization and assigns the cost of each activity resource to all products and services according to the actual consumption by each: it assigns more indirect costs (overhead) into direct costs. In this way, an … Continue reading Simple ABC Model

Financial Projections Model

Details : A comprehensive financial model for forecasting a complete set of financials with breakeven and valuation tabs developed. Size : 787 ko Version : 6.8.4 Type : xls Author : Frank Moyes and Stephen Lawrence at Leeds School of Business Web site : http://leeds-faculty.colorado.edu/moyes and http://leeds-faculty.colorado.edu/lawrence

Income Statement What If Analysis

Details : Income Statement What If Analysis (Alternative term for sensitivity analysis). Simulation analysis in which key quantitative assumptions and computations (underlying a decision, estimate, or project) are changed systematically to assess their effect on the final outcome. Employed commonly in evaluation of the overall risk or in identification of critical factors, it attempts to … Continue reading Income Statement What If Analysis

Assessment Templates

Details : Set of templates for assessing an organization based on the Malcolm Baldrige Quality Model. The Malcolm Baldrige National Quality Award is an annual award that recognizes U.S. organizations in the business, health care, education, and nonprofit sectors for performance excellence. The Baldrige Award is the only formal recognition of the performance excellence of … Continue reading Assessment Templates

Income Statement What If Analysis

Details : Income Statement What If Analysis (Alternative term for sensitivity analysis). Simulation analysis in which key quantitative assumptions and computations (underlying a decision, estimate, or project) are changed systematically to assess their effect on the final outcome. Employed commonly in evaluation of the overall risk or in identification of critical factors, it attempts to … Continue reading Income Statement What If Analysis

Hamlin’s Financial Addin for Excel

Details : An addin program for Microsoft Excel version 7.0 or higher (Excel for Windows 95, Excel 97 and Excel 2000). This addin includes the following functions: Adjusted Black Scholes valuation of Call and Put options. Calculation of Interest Expense based on average debt outstanding without ‘Circular Reasoning’ when the ending debt outstanding depends on … Continue reading Hamlin’s Financial Addin for Excel

Black Scholes Option Pricing

Details : Excel add on for the pricing of options. The Black–Scholes model is a mathematical description of financial markets and derivative investment instruments. The model develops partial differential equations whose solution, the Black–Scholes formula, is widely used in the pricing of European-style options. Size : 42 ko Version : 1.6 Type : zip

VeryGoodChoice Multi-Criteria Decision Analysis

Details : VeryGoodChoice is an advanced program for doing comparison and analysis of solutions regarding criteria. It is used in various professional context to make the right decision at the right time. Each time you need to compare alternatives, you can use VeryGoodChoice which is powered by a scientific algorithm. This algorithm reproduce the real … Continue reading VeryGoodChoice Multi-Criteria Decision Analysis