Search Contextures Sites

Ron Coderre's Excel Template Files

Excel Templates

Latest File Upload

 

Charts and Graphics

  20-Sep-2007   RCH0002

Data Validation

  17-Jul-2007 

External Data

  17-Jul-2007 

Functions

  17-Jul-2007

Excel Templates - Charts and Graphics

RCH0002 - Insert Pictures from Folder -- ShowFilePicsDemo demonstrates how to insert picture files (bmp, gif, jpg, etc) directly from a network or web folder into an Excel sheet by selecting an item from a cell data validation drop-down list. Created by Ron Coderre. ShowFilePicsDemo.zip 27kb 20-Sep-07   

RCH0001 - Pareto Plotter -- Contains a traditional Pareto Chart. Enter your categories and their values, then click a button. The program adjusts the chart columns in descending order and plots the cumulative total line (adjusting sizes so the line meets the upper right corner of the first column and the upper right corner of the chart area. Sample Excel template file from Ron Coderre. ParetoPlotter.zip 23kb   Updated 27-Jul-06    

Excel Templates - Data Validation

RDV0001 - Flexible Item List -- Use formulas to automatically add new unique items to a data validation dropdown list. Sample Excel template file from Ron Coderre. DataValFlexList.zip 6kb   Updated 27-Jul-06    

Excel Templates - External Data

RED0003 - PivotPlay PLUS Add-in -- Facilitates changes to the connection strings and queries that extract the external source data that pivot tables use. Created by Ron Coderre. PivotPlayPLUS.zip 72kb  Updated 15-Mar-08    Detailed Instructions

RED0002 - Query Master -- Makes it easy for users who are knowledgable in SQL (but not VBA) to create a catalog of up to 10 queries that can be run on demand. Sample Excel template file from Ron Coderre. QueryMaster.zip 61kb   Updated 07-Aug-06 

RED0001 - Pull Essbase Data into all Worksheets -- Copy your existing Essbase reports into this Excel template or build new ones. Then...with the click of a button... log-in to Hyperion Essbase (only one time!) and pull data into each worksheet in the workbook. Sample file from Ron Coderre. EB_Pull_All_Sheets.zip 43kb   Updated 07-Aug-06 

Excel Templates - Functions

RF0001- Convert Numbers to Words 17-Jul-07 -- Two choices: VBA version or Non-VBA version.
Both approaches translate numbers into their spelled words.

The VBA version (NumsToWords_VBA.zip 24kb) offers the following features:

  • The NumsToWords() function, with parameters that allow you to change currencies and formats.
  • A sample sheet demonstrating usage of the function's parameters.
  • PLUS...If you're intimidated by VBA..Don't be!...Click one button and the function is automatically exported into any open workbook. You never have to touch or see the program.
The Non-VBA version (NumsToWords_No_VBA.zip 9kb) offers these features:
  • An annotated list of the Named Constants and Named Formulas used to perform the translation without any VBA programming.
  • Instructions on how to easily export those ranges to any workbook.
  • This method does not generate a Macro warning when the Excel template file is opened (unless you have other VBA programs in your file).

No help file is available for the sample Excel template files. If you have comments or suggestions, please contact ddalgleish@contextures.com 
These sample Excel template files are provided "as is" for the sole purpose of illustrating Excel techniques. The authors do not warrant that the Excel template examples will meet your requirements or that the operation of the Excel template examples will be error free.

For links to newsgroup help, and consulting services:
Contextures contact information

Last updated: August 8, 2010 7:15 PM

 

Privacy Policy