My Software & Spreadsheets, R

Excel Macro for Making Matrices in R

I am not an open-source purist. I love Excel!

For me it is tedious to make matrices in R from scratch. To save time, I made a simple spreadsheet with a set of VBA macros for making R matrices quickly in Excel. I use it all the time. I hope you find it to be useful.

Image

It is also linked to at my software page.

Advertisements
Standard

4 thoughts on “Excel Macro for Making Matrices in R

  1. Hi I like the Idea, but I usually just save my matrices as csv/excel files and let R import them as matrices. That way users can easily (visually) edit them later on. Dont you think that works better?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s