Business Functions Library for Excel

      1. Getting Started
      2. Using The Help File
      3. Top Dozen Functions
      4. Golden Rules
      5. Excel 2007
      1. Go To
      2. Function Selector
      3. CalculateFull
      4. Calculate WorkSheet
      5. Trace Facility
      6. Quick Paste Example
      7. Tutorials
      8. Function Finder
      9. Examples
      10. Help
      11. Excel"s Function Wizard
      12. Access Internet
      13. Usage of Functions (Audit)
      14. Uninstall
      1. Time Periods
      2. Inclusive and Exclusive Dates
      3. Using Daycount
      4. Examples of DayCount
      5. Annual Date Sequences
      6. ProjMode and Inclusive Dates
      7. Date Rolling Convention
      1. Rate Projections Functions Walkthrough
      2. Accruals and Cash
      3. Repeating Formulae
      4. Range Names and References
      5. Optional Parameters
      6. Using PmtsPerYear
      7. Modelling Seasonality
      8. Calculating Interest
      9. Using Business Functions in VBA (Visual Basic for Applications)
      10. Array Functions
      11. Volatility
      12. Annual Equivalent Rates
      13. Array Function
      14. Auto Multi Functions
      15. Variable Plurality
      16. GoalSeek
      1. Introduction To the Worked Examples
      2. Daycount
      3. General Projections
      4. Business Plans
      5. Cashbasis And Periods
      6. Using Timebases
      7. Using Dates
      1. How To Generate a time scale for a structured financing
      2. How To Project Rents off a Rental Forecast
      3. How To Run a model on different time bases
      4. How To Isolate The Cause of a Errors in Cells using Trace
      1. Introduction to the Utilities
      2. Audit
      3. Synchronized Range Insert/Delete
      4. Database Edit
      5. Insert Macro Button
      6. Link Analyser
      7. Range Describer
      8. PrintScript (beta)
      9. Create Local Range Name
      1. Number Formats
      2. Apply BF"s Color Palette
      3. Bullets
      4. Color Cells
      5. Conditional Formats
      1. Validation DropDowms
      2. Validation Standards
      1. Select Excel Function
      2. Array Function Tools
      3. Sort Sheets
      4. Range Value
      5. Named Range Manager
      6. Enforce WorkBook Settings
      7. Monte-Carlo
      8. TimeChart
      1. The ".ini" file
      1. Forum
      2. Online Help
      3. Templates
      1. Conversion of Input Strings to Values
      2. List of Holidays
      3. Acknowledgements and Trademarks
      4. Published Editions Changes in Behaviour
      5. Range Handling And Constraints
      6. Dates in Excel and Business Functions
      7. Old Composite DayCount Format
      8. DayCount in Excels"s Functions
      1. NPV of Annual To Periodic CashFlows - CorrectionM
      2. Interest - Simple, Annual, Continous and Discount Factors
      1. New Functions
      2. Obsolete Functions
      3. Discontinued Functions
      4. Deprecated Functions
    PrintScript (beta)
    Automate printing with resorting to VBA
    Introduced in Version 1.31
    The problem: You want to print off the same sheets from your model on a regular basis, consistently. You don"t want to have to fire up the VBA editor every time to check what"s in the VBA macro (if you have one) to be printed, what the settings are etc.
    What PrintScript does:PS interprets a list of commands you type into an Excel sheet. The Excel sheet has to have the prefix "PS_" so that PrintScript can easiliy find it. You then give it a list of sheets to be printed. You can also define the same range area on each sheet to be printed - useful for multi-page cashflows where the format is the same (good discipline). And its all sitting there on a sheet, not a VBA module, so anyone can see it or change it (althouhg you can of course protect the sheet if you want to ).
    Example Commands
    Enter these or similar commans on a sheet named PS_MyPSSheet and then go BusinessFunctions/Utilities/PrintScript.
    Cell1Cell2Cell3Cell4 ?
    >THIS IS A COMMENT
    LANDSCAPE true
    BLACKANDWHITE true
    PRINTPSRangeSheet3Range
    RANGEa1:c3
    PRINTSHEET1SHEET3
    RANGE
    PRINTSHEETSSHEET1SHEET3


    The current full list of commands is:
    KeyWord1Contents of CellsMeaning
    > ?anythingAnythingComment (ignored by system)
    LANDSCAPE true or falseThe print ranges or sheets on subsequent lines are to be printed landscape.
    PORTRAIT true or falseThe print ranges or sheets on subsequent lines are to be printed portrait.
    BLACKANDWHITE true or falseThe print ranges or sheets on subsequent lines are to be printed in black and white or colour
    PRINTOne or more SheetNames, Sheet Indices, RangeNames, Range Addresses.Print the sheets or ranges specified.
    PRINTSHEETS or PRINTSHEETSFROMTOTwo SheetNames or Sheet Indices.Print the sheets between and including the two sheet identifiers.
    RANGEA cell area defined by a reference, eg a1:c3The range to be printed of the sheets on subsequent lines.


    Note that the macro goes through the list of commands in the order that they are in the worksheet, so you can print some sheets, then change some settings, print some more, and so on.

    There is an example called PrintScript.xls in the Worked Examples.

Business Functions phone: +44 (0)20 8144 9374 (London UK)
Website Design: Webpure