Category: Tutorials

Track your local R scheduled tasks with CommandCenter2000!!!

There are many ways to automate your scripts running, for example using RScript, or in-R itself (and now even as an add-in for RStudio) (check all here). But after a while, it can get a bit overwhelming to track tasks and ensure they are firing as planned. In order to address this, I have developed some futuristic advanced tech that lets us… Read more →

Make dashboard Tiles/Notecards in R

Update!! Due to the popularity of this script, I released it as a package. To install it, use: devtools::install_github(“mexindian/TileMaker”) ———————————————————– Dashboard Tiles/Notecards are a great way to visualize just one number, and make it big and pretty. They can emphasize results in an easily digestible and colourful format. I was surprised that there was no way to create tiles offline… Read more →

KPI dashboard in R with animated icons

So Key Performance Indicators (KPIs) are all the rage in the dashboarding community… well everywhere really. The premise is simple… check a list of measurements against targets and show how they compare using some kind of visualization. I haven’t yet seen, however, a version that can utilize animated icons to display indicators that REALLY need attention. So here you go, a… Read more →

How to move ODBC DSN information from one computer to another

YAAAAAAAAY!!!! I got a new computer!!! Oh crap how do I move the DSN connections that I made on this computer?? This is how (assuming you’re on windows)! But before, we do, we have to make sure we have the right drivers… so lemme first go over the basikses my precious: TO ADD NEW CONNECTIONS: Build a shortcut on your… Read more →

Excel is how I do maps…

Following the footsteps of this cool post I saw by JohnNelsonIDV, I wanted to try to and make a map using Excel. Fast forward 2 days and the opportunity came up. Lo and behold, a Map of Reference Evapotranspiration built in Excel! Instructions: Read data file into Excel (skip top rows with metadata), make sure to delimit correctly so that each… Read more →

Best way to make a custom palette with ggplot2

      A better way to pick colours with ggplot2 First, get the excellent package by Marco D Visser: library(devtools) install_github(“MarcoDVisser/choosecolor”) call it library(choosecolor) This lets us interactively pick colors ourselves. Just for fun and to get the hang of it, experiment with color.choose() now make a palette. In the syntax below means that you get to pick 4… Read more →

Excel basics

Most of the things posted on this page will make reference to Visual Basic for Applications (VBA). How do you get to the Visual Basic Editor? Excel versions prior to 2007: Under the Tools menu, go to Macros, and the option should be there. Excel 2007: Available through the Developer tab on the ribbon. If you don’t see a developer tab: Add the Developer tab… Read more →

Human armature from d3Network!

So a little bit of R, a little bit of d3Network and boom! Instant interactive html human!     Code to make your own or edit as you see fit: library(d3Network) Nodes <- c( “Head”, “Sternum”, “Shoulder.r”, “Shoulder.l”, # 0 1 2 3 “Elbow.r”, “Elbow.l”, “Wrist.r”, “Wrist.l”, # 4 5 6 7 “rib.r”, “hip.c”, “hip.r”, “hip.l”, # 8 9 10… Read more →

kml maker for Excel -> Google Earth

I made a userform that quickly and easily allows you to make a kml file that’s readable by google earth based on some excel dataset that has coordinates. Features: Simple and advanced modes userform for convenience Icons change when highlighted Allows html to be passed to popup contents, everything is customizable Issue a default icon, and change icons for specific… Read more →

Change lists into tables and tables into lists

Designed a userform that converts dimension formats, i.e. information from tabular format to list (or flat) format, and viceversa. Some options include preserving formatting or not, as well as including blank cells or not. >>Form is here:Dim changer userform >>Excel file with embedded form and a macro to make the form pop up is here:Dim_changer >>Tutorial is here: https://www.youtube.com/watch?v=EvaRfIZo0QY Code… Read more →

Search or filter through controls in a userform

This bit might be useful if you have a lot of controls on a form, and need a quick way to highlight them. This post supports the video: I uploaded a video tutorial, you can see it here (please view in fullscreen mode, or watch the video in youtube by clicking on the youtube logo):[http://www.youtube.com/watch?v=5RtV9msZ2RE]. Download the file here (Search on… Read more →

Compare lists and identify matches macro

This macro provides an alternative to vlookup (which looks at two lists and provides data from one list to the second) that retains similar functionality while providing certain benefits. It accomplishes this by physically moving one list to the other. It’s impossible to get a false positive, and it doesn’t provide that annoying #N/A that messes up calculations. Additionally, it… Read more →

Macro userform – a good visual way to organize macros

At a certain point it can become challenging to quickly find and run the macro we need. Below are some options to organize our macros. I will focus on using a pop-up form because it’s the method I prefer, but at the bottom of the article, you can see other options. A pop-up menu looks like this: How to make your own… Read more →

%d bloggers like this: