Reliable Spreadsheet Solutions - Call Now 281-379-2000 Microsoft Excel - Visual Basic for Applications Consultant Reliable Spreadsheet Solutions - Call Now 281-379-2000 !
PROFESSIONAL SOFTWARE DEVELOPMENT
Reliable Excel VBA Solutions !
 
Microsoft Office : Excel - Visual Basic for Applications [ VBA ] Software 

Beyond Technology

Insight for Microsoft Excel POWER-Users
  Excel Solutions Letter ® FREE  excel solutions letter
Spreadsheet Power-User Tips
  Enable ease and consistency of data entry with a dropdown list of possible entries for a range  dropdown list in cell
  Designing an array formula that functions similar to a VLOOKUP function with multiple criteria and returns a text entry  mult-criteria text lookup
  How Excel workbooks become bloated and what can be done about it  spreadsheet bloat
  Spreadsheet Power-User Tips  more ...
Getting to Know Microsoft Visual Basic for Applications
  Decision Structure that conditionally executes the embedded code  if...then[...else]
  If you are new to VBA and trying to get a handle on programming, this is a MUST READ article for you!  what are variables ?
  Discover a special, more flexible variety of arrays  dynamic arrays
  Getting to Know Microsoft Visual Basic for Applications  more ...
Microsoft Excel Advanced VBA - Just for Geeks
  MUST SEE!  A named range that expands and contracts automatically based on the number of items in the source data table  dynamic named ranges
  MUST SEE! How to identify the last used row in an Excel worksheet  finding real last cell
  Creating charts that adapt as the size of the source data range varies  charting dynamic data
  Microsoft Excel Advanced VBA - Just for Geeks  more ...
Excel Spreadsheet Tools and Tutorials
  Mortgage & Auto Loan Payment Calculator » Amortization with Excel Spreadsheets  amortization guide
  Breakeven Analysis with Excel Spreadsheets Tutorial  breakeven analysis
  Permutations & Combinations with Excel Spreadsheets  combinatorics
  Standard Deviation in Excel Spreadsheets Tutorial  standard deviation
  Weighted Average in Excel Spreadsheets Tutorial  weighted average


Microsoft Excel VBA Custom Application Development
  Microsoft Excel VBA Custom Application Development  excel vba customization
  Microsoft Excel VBA Professional Development Experience  professional experience
  Microsoft Excel VBA Custom Application Development  project request form
Microsoft Excel VBA Solutions : Real-World Project Profiles
  How deep is your data?  engineering analysis
  Financial reporting can be a challenging endeavor.  financial reporting
  To anticipate customers needs is to be rewarded with their business.  sales forecasting
  Are time-hungry paperwork tasks building up on you?  automated billing
  An Engineer-in-a-Box  engineering design
  Partial List of Beyond Technology Clients - Past & Present  clients - past & present


Reliable Spreadsheet Solutions - Call Now 281-379-2000 !
  Visitors' Comments  gratuitous kudos
  Add to Favorites 
  Reliable Spreadsheet Solutions - Call Now 281-379-2000 !  e-mail contact

20831 Rosehill Church Rd
Tomball, Texas 77377


Combinatorics with Excel Spreadsheets

Rodney POWELL
Microsoft MVP - Excel

Combinatorics is about the arrangement of elements within sets. The Beyond Technology COMBINATOR ® software tool and the accompanying tutorial will enable you how to perform some high-speed calculations to analyze the multitude of possible arrangements of a list of items.

You will learn answers to these questions and more :
  • What are permutations, combinations, and factorials ?

  • What is the difference between permutations and combinations ?

  • How are permutations and combinations effected by repetition ?

  • How do the calculations for permutations, combinations, and factorials work ?
We will explain the functions and formulas using Microsoft Excel to perform permutation and combination calculations ... step-by-step with illustrations.


How the Beyond Technology COMBINATOR ® software helps

Beyond counting how many permutations or combinations can be formed, this powerful tool generates all the actual result sets for you !
  • It enables you to provide your own list of up to 16 inputs at a time and select the output set sizes to produce results tables with 2, 3, or 4 fields

    ... with results sets as large as 65,536 permutations.

  • Simple controls enable you to select whether you want permutations or combinations, and choose whether to allow or not allow repetitions.

  • It has a feature that generates permutations from multiple lists.

  • Results tables are written into a simple Excel worksheet that you can copy or save for other purposes.

Combinatorics with Excel Spreadsheets


The tutorial included provides a clear, easy-to-follow visual guide for how to use and work with the Beyond Technology COMBINATOR ® tool.

You will get a simple explanation of combinatorics [ only 11 pages ] that includes illustrations, formulas, and examples.

Within 15 minutes you will understand permutations and combinations and how to use them !


Combinatorics with Excel Spreadsheets



Combinatorics with Excel Spreadsheets   $ 15.00 USD
Click this link to download a copy licensed for personal use ...

Combinatorics with Excel Spreadsheets

2CheckOut.com Inc. (Ohio, USA)
is an authorized retailer for
goods and services provided by Beyond Technology.


Follow the links provided on this page to download in minutes a ZIP file containing the Combinatorics with Excel Spreadsheets guide [PDF]. It's EASY !

Your download will also have an Excel file which is the Beyond Technology COMBINATOR ®.

This XLS file is compatible with Excel 97-2003 and Excel 2007.

With your own input values, you can use this powerful tool to perform high-speed calculations to build and analyze permutation and combination arrangements in spreadsheets.



Combinatorics with Excel Spreadsheets   $ 15.00 USD
Click this link to download a copy licensed for personal use ...

Combinatorics with Excel Spreadsheets

2CheckOut.com Inc. (Ohio, USA)
is an authorized retailer for
goods and services provided by Beyond Technology.

Beyond Technology Custom Application Development
  home Microsoft Excel VBA Custom Application Development  professional consulting Insight for Microsoft Excel POWER-Users  developer tips Visitors Comments  visitor kudos Beyond Technology - Microsoft Solution Provider  e-mail  

Your suggestions and comments are greatly appreciated. Please keep them coming.

Mail to:   rodney@beyondtechnology.com

All terms, product designs, and company names used in this site may be trademarks or registered trademarks of their respective owners, and are hereby acknowledged. © 1996 - 2008 Beyond Technology. All rights reserved.