Quick Links

Other stuff

Site owners

  • Bruce Mcpherson

Services‎ > ‎Desktop Liberation‎ > ‎

Downloads

What to download

All the individual downloadable items referenced in this site can be found here. Please scroll down to find the package(s) you want.  The 2 most likely ones are cDataSet.xlsm or GoogleMapping.xlsm.  

Note that there is a huge amount of samples and code in these workbooks, and you won't need most of it. However, you can update your own workbook with selected code online  automatically  - see this  post for how. Using that, I have  created an empty version using that with the main modules and classes that you can use if you want to build an application. I can't guarantee i'll remember to keep it up to the latest version - its called emptycdataset.xlsm

Everything on this site is free to use. See Reusing code from this site for more details. If you find something of use, please share it on your favorite social network or tweet about it.  For help and more information join our forum,follow the blog or follow me on twitter or Google Plus

Google Analytics
Google Analytics is used to in some workbooks to see what is popular, and what versions of what are being used  - see Instrumenting VBA for Google Analytics for details. You can read how I use this on this post.

No personally identifiable information is stored as per Google Terms of Service. If you have problems (no internet connection or proxy problem, or otherwise want to opt out of that),  please follow the instructions below, and modify your copy of what you have downloaded.

You can easily opt out of google analytic reporting by setting pOptOut to true in the cUAMeasure class as below.

Private Sub Class_Initialize()
    Set pBrowser = New cBrowser

    ' change this to true to opt out of analytic reporting
    pOptOut = False


 Data Manipulation
ċ
arrayformulas.xlsm
Download
demonstrate the use of array formulas and optimization with MAtCH()  3962k v. 2 Jan 17, 2012, 9:35 PM Bruce Mcpherson
Ĉ bitCoinAuto.xlsm
Download
  608k v. 2 Dec 13, 2013, 10:10 AM Bruce Mcpherson
Ĉ blisterFunctions.xlsm
Download
examples of google apps script blister custom functions being accessed directly from excel  277k v. 2 Sep 30, 2013, 4:39 AM Bruce Mcpherson
Ĉ cDataSet.xlsm
Download
CdataSet - class files for caching and working with structured excel data and parameters. Also includes Excel/jSon/Excel,d3.js, an Excel/Rest library and various other examples                                                5677k v. 257 Apr 11, 2014, 6:40 AM Bruce Mcpherson
ċ
d3Force interactive example
View
This is a fore diagram representation of some test data from the iTunes database  Jun 24, 2012, 5:54 AM Bruce Mcpherson
Ĉ emptycdataset.xlsm
Download
This is a version of cDataSet that only contains the most useful classes and modules, and has no samples. You can download this for a clean version to build upon  315k v. 2 Apr 9, 2014, 8:51 AM Bruce Mcpherson
Ĉ funnycharts.xlsm
Download
  407k v. 2 Apr 10, 2013, 1:45 AM Bruce Mcpherson
ċ
Google apps version of rest library
View
You can get the shared restLibrary Google Workbook here. To access the scripts, go to file and make a copy.   Nov 1, 2012, 4:26 AM Bruce Mcpherson
Ĉ googleImport.xlsm
Download
import data into excel from google spreadsheets - oauth2 is implemented  430k v. 3 Oct 15, 2013, 2:53 AM Bruce Mcpherson
ċ
horsesankey.html
Download
  20k v. 2 Feb 18, 2013, 3:18 AM Bruce Mcpherson
Ĉ oauth2credentials.xlsm
Download
use this to contain all your oauth2 credentials. It only needs to be run once  292k v. 2 Nov 22, 2013, 4:28 AM Bruce Mcpherson
Ĉ promises.xlsm
Download
This is a basic implementation of promises in vba to handle orchestration of asynchronous activities  574k v. 7 Aug 9, 2013, 3:01 AM Bruce Mcpherson
ċ
restLibrary.html
Download
This is the online rest library. Will be updated with additional entries from time to time  3k v. 3 Apr 12, 2012, 10:27 AM Bruce Mcpherson
ċ
sankey.html
Download
this is a sankey diagram using d3.js generated out of Excel. Note - probably doesnt work on IE8 and below. Use firefox or chrome if you can  15k v. 3 May 29, 2012, 3:42 AM Bruce Mcpherson
 Embedding Google visualizations in Excel and serializing Excel Data
Ĉ googleCharts.xlsm
Download
An example workbook that creates google visualizations and embeds them in your worksheet, as well as standalone .html and serialized data files         272k v. 14 Apr 25, 2012, 8:09 AM Bruce Mcpherson
ċ
googleMotionWrapper.html
Download
A skeleton .html file with the code needed to show a google motion chart. Will take serialized data created by the example workbook or from googleDocs   1k v. 6 Jan 14, 2011, 9:12 AM Bruce Mcpherson
ċ
googleVisWrapper.html
Download
A wrapper that will create google visualizations. It needs a dataURL containing the Excel data in JSON format. This serialized data is created by the googlecharts.xlsm example application      2k v. 6 Jan 26, 2011, 5:54 AM Bruce Mcpherson
 General purpose Countdown Timer or Progress Bar
ċ
ProgressBar.xlsm
Download
A general purpose countdown timer or progress Bar which can use either form controls or excel shapes as a template.   112k v. 4 Jan 9, 2011, 8:44 PM Bruce Mcpherson
 Get Data from Outlook
ċ
outlookLookup.xlsm
Download
Get Data from Outlook classes and example   82k v. 2 May 27, 2011, 11:36 AM Bruce Mcpherson
 Getting Started Snippets
Ĉ gettingstartedSeries.xlsm
Download
Contains all the code referenced in the getting started snippets section            347k v. 13 Mar 20, 2012, 11:05 AM Bruce Mcpherson
 gistThat
ċ
bootstrap code for gisThat VBA
View
Bootstrap code. This will get you started maintaining your VBA code automatically  Aug 21, 2012, 5:31 AM Bruce Mcpherson
ċ
cDataSet gistthat manifest
View
xml manifest for use with gistthat for cDataSet and cJobject  Aug 21, 2012, 5:30 AM Bruce Mcpherson
Ĉ gistThat.xlsm
Download
bootstrap code and examples for maintaining vba code automatically using github  60k v. 8 Aug 24, 2012, 6:28 AM Bruce Mcpherson
 Google Analytics
ċ
Google Analytic Gadget
View
Link for general purpose google gadget to add tracking code for google analytics  Apr 18, 2011, 5:10 AM Bruce Mcpherson
 Google Mapping
ċ
bingMarkerGenerated.html
Download
Bing version generated by Excel to plot data on Bing maps  5k v. 2 Sep 7, 2011, 4:13 AM Bruce Mcpherson
Ĉ GoogleMappinglocale.xlsm
Download
this is a test version to deal with mismatched excel and browser locale  788k v. 3 Jul 15, 2013, 5:45 AM Bruce Mcpherson
Ĉ GoogleMapping.xlsm
Download
Generate complete VizMap applications for Google Earth or Google Maps that combine mapping, visualization and twitter. Use mapping APIs to extract address components from a table of Excel unstructured addresses and plot them directly on Google Maps, Yahoo Maps, Bing Maps, Ovi Maps and Google Earth.                      1067k v. 76 Feb 5, 2014, 6:11 AM Bruce Mcpherson
ċ
googleMarkerGenerated.html
Download
This is generated when you use the test data to place customer markers on google maps.    8k v. 6 Mar 28, 2012, 5:50 AM Bruce Mcpherson
ċ
kmlMarkerGenerated.kml
Download
kml markers for use with google earth. Example generated by googleMapping.xlsm  2k v. 2 Oct 13, 2011, 2:49 AM Bruce Mcpherson
ċ
oviMarkerGenerated.html
Download
Ovi Maps version of mapped Excel data  5k v. 2 Sep 6, 2011, 9:55 AM Bruce Mcpherson
ċ
vizMapFamilyGeneratedEarth.html
Download
British Royal family and their homes - Generated VizMap application - Google Earth version       81k v. 7 Nov 12, 2011, 2:03 AM Bruce Mcpherson
ċ
vizMapFamilyGenerated.html
Download
British royal family and their homes - generated Google Maps VizMap application     81k v. 5 Nov 12, 2011, 2:03 AM Bruce Mcpherson
ċ
vizMapOrdersGeneratedEarth.html
Download
Earth version of customer/orders vizmap generated application   48k v. 4 Nov 12, 2011, 2:04 AM Bruce Mcpherson
ċ
vizMapOrdersGenerated.html
Download
VizMap generated application. Customer/Orders visualization     48k v. 5 Nov 12, 2011, 2:04 AM Bruce Mcpherson
ċ
vizMapOrgGeneratedEarth.html
Download
Google Earth example showing integration with Org charts and twitter  59k v. 2 Nov 22, 2011, 1:49 AM Bruce Mcpherson
ċ
vizMapOrgGenerated.html
Download
Google Maps example showing integration with Org charts and twitter  59k v. 2 Nov 22, 2011, 1:49 AM Bruce Mcpherson
ċ
vizMapPalacesGeneratedEarth.html
Download
Palace vizmap using google earth instead of maps      47k v. 6 Nov 12, 2011, 2:05 AM Bruce Mcpherson
ċ
vizMapPalacesGenerated.html
Download
VizMap generated application. Dictators/Palaces visualization     47k v. 5 Nov 12, 2011, 2:05 AM Bruce Mcpherson
ċ
vizMapVenuesGeneratedEarth.html
Download
Google Earth version of generated venues application     50k v. 5 Nov 12, 2011, 2:06 AM Bruce Mcpherson
ċ
vizMapVenuesGenerated.html
Download
VizMap generated application. Artist/Venues visualization     50k v. 6 Nov 12, 2011, 2:06 AM Bruce Mcpherson
ċ
yahooMarkerGenerated.html
Download
Excel data marked up on a Yahoo Map   4k v. 3 Oct 8, 2011, 3:41 AM Bruce Mcpherson
 Google visualization implementation of Roadmapper
ċ
Roadmapper package
View
All the files you need to embed a roadmapper gadget  Mar 21, 2011, 1:44 PM Bruce Mcpherson
 Hiding data in Excel Objects and JSON serialization
ċ
trackingData.xlsm
Download
This is the example workbook to illustrate the serialization and deserialization of JSON data and hiding it in shapes, cells and cookies   92k v. 6 Aug 10, 2011, 3:10 AM Bruce Mcpherson
 images
ą
757.png
View Download
heat map version 1  40k v. 3 Jan 5, 2012, 8:07 AM Bruce Mcpherson
ą
758.png
View Download
heatmapversion 2  32k v. 3 Jan 5, 2012, 8:07 AM Bruce Mcpherson
 Optimization
Ĉ optimizeExample.xlsm
Download
This is just if you want a very simple reporting on sheet calculation. A more fully featured version in included in the procprofiler package  56k v. 3 Mar 21, 2012, 2:47 AM Bruce Mcpherson
ċ
procProfiler.zip
Download
Optimization Package: Includes worksheet analyzer, procedure profiler, and automatic profiler as excel Add-ins    75k v. 4 Jan 9, 2011, 8:43 PM Bruce Mcpherson
 pinyin
Ĉ pinyin.xlsm
Download
  94k v. 2 Sep 2, 2013, 10:39 AM Bruce Mcpherson
 Roadmapper Project
ċ
Gadget Source
View
This is the open source project for the google gadget visualization version of this.  Apr 8, 2011, 8:23 AM Bruce Mcpherson
ċ
Gadget version
View
This is a version of the roadmapper implemented as a google gadget.  Apr 8, 2011, 8:21 AM Bruce Mcpherson
ċ
Link to google Apps Script Roadmapper
View
This is the Google Apps Script version of the roadmapper. You should use file/make a copy to make your own proivate copy to access the code  Apr 13, 2012, 12:29 AM Bruce Mcpherson
 Sudoku Solver and Generator Project
Ĉ ExcelDoku.xlsm
Download
  432k v. 3 Jan 30, 2013, 11:19 AM Bruce Mcpherson
Ĉ sudbittwiddle.xlsm
Download
Constraint formulas to find the rule for identifying naked sets in sudoku. Also demonstrates the use of bittwiddling functions  75k v. 5 Oct 12, 2012, 4:52 AM Bruce Mcpherson
 Useful User defined Functions
ċ
diminishingreturn.xlsm
Download
Example of UDF and formula for calculating diminishing returns  18k v. 2 Jun 4, 2011, 3:09 AM Bruce Mcpherson
ċ
rxLib.xlsm
Download
Regex package for executing regEX patterns as UDF, as well as a regex library capability.   34k v. 3 Nov 28, 2011, 11:29 AM Bruce Mcpherson
 xx Deprecated Archive
ċ
cDataSetSkeleton.xlsm
Download
deprecated:An empty workbook containing only the classes needed to be able to use cDataSet and cJobject    215k v. 7 Nov 22, 2011, 1:50 AM Bruce Mcpherson
ċ
changeColorclick.xlsm
Download
Change color based on cell value using a command button rather than worksheet event.  21k v. 4 Sep 3, 2011, 4:49 AM Bruce Mcpherson
ċ
changeColor.xlsm
Download
change the background color of a cell to the same as another in the same column based on a value. from http://www.eggheadcafe.com/forumpostsubmission.aspx?topicid=66&forumpostid=10226616  18k v. 5 Sep 3, 2011, 4:49 AM Bruce Mcpherson
Ĉ dynamicchartrange.xlsx
View Download
Using dynamic ranges in charts. http://www.eggheadcafe.com/community/aspnet/66/10226737/xaxis-range-change.aspx  15k v. 4 Sep 3, 2011, 4:49 AM Bruce Mcpherson
ċ
MakeShapes.xlsm
Download
Make shapes with size based on a range. http://www.eggheadcafe.com/community/aspnet/66/10251513/creating-autoshapes-using-vba-for-excel-2003.aspx  16k v. 5 Sep 5, 2011, 11:12 AM Bruce Mcpherson
ċ
optimizerZip.zip
Download
Example Sheet and add in .bas for worksheet optimizer   28k v. 5 Sep 3, 2011, 4:49 AM Bruce Mcpherson
ċ
randomize.xlsm
Download
Code snippet to randomize timesheet completion. http://www.eggheadcafe.com/community/aspnet/66/10225953/macro-to-randomly-autofill-time-tracking.aspx  18k v. 6 Sep 3, 2011, 4:49 AM Bruce Mcpherson
ċ
randomPopulate.xlsm
Download
For randomly populating a range with unique numbers.  18k v. 5 Sep 5, 2011, 11:12 AM Bruce Mcpherson
ċ
regexp.xlsm
Download
deprecated:Demonstrate the use of regular expressions   17k v. 5 Sep 3, 2011, 4:49 AM Bruce Mcpherson
ċ
RoadmapGenerator.xlsm
Download
Roadmap generator- Dynamic forms and clickable roadmaps. V3  - Note that the latest version of roadmapper is now maintained in cDataSet.xlsm  419k v. 15 Jul 27, 2012, 6:16 AM Bruce Mcpherson
Ĉ starterRoadmapParameters.xlsx
View Download
Deprecated:Starter Parameter worksheet: Get started with a skeleton parameter sheet for your roadmap   16k v. 5 Sep 3, 2011, 4:49 AM Bruce Mcpherson
ċ
stressTestcDataSet.xlsm
Download
Deprecated:CDataSet Package: class files plus stress Test procedures. Please download cDataSet.xlsm instead  150k v. 6 Sep 3, 2011, 4:49 AM Bruce Mcpherson
ċ
testprocprofiler.xlsm
Download
Test workbook for cProcProfiler  17k v. 4 Sep 3, 2011, 4:49 AM Bruce Mcpherson
ċ
UsefulUserDefinedFunctions.xlsm
Download
Deprecated:Useful User defined functions referenced throughout this site    23k v. 7 Sep 5, 2011, 11:12 AM Bruce Mcpherson