Sample Excel files to download, provided by Ron Coderre.
- 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.
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
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
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 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 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 Updated 07-Aug-06
RF0001- Convert Numbers to Words -- Two choices: VBA version or Non-VBA version. Both approaches translate numbers into their spelled words.
The VBA version (NumsToWords_VBA.zip) offers the following features:
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.
More Excel Files
Last updated: February 24, 2021 9:33 AM