Search Contextures Sites
Ron Coderre's Excel Template Files
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 ShowFilePicsDemo2007.zip 33kb 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 Non-VBA version (NumsToWords_No_VBA.zip 9kb) offers these 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.
- 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 firstname.lastname@example.org
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: May 22, 2013 7:47 PM