Scriptsheets.com

Download

The scriptsheets Add-in is freeware software that is available for use at no cost.

Take home!

Download: Scriptsheets.zip (702 kB)

If you are satisfied with the product and start saving time and money you could consider making a donation and support future development efforts!

Some tips

  • Readme.pdf
    After you UnZip all files you should open the Readme.pdf which shows you how to install the Scriptsheets.xlam file!
  • Auditing toolbar
    Microsoft Excel provides tools that help you track down data in your worksheets, just open the Auditing toolbar. You then can trace the precedents (the cells that provide data to a specific cell) or you can trace the dependents (the cells that depend on the value in a specific cell).
  • Create names to represent cells
    If you build many formulas which depend on lots of cells throughout your workbook, you should create names for these cells.
    That way you can use the name in formulas which makes them easier to understand.
  • Change security level for macro virus protection to medium
    MS Excel uses security levels for macro virus protection.
    If the security level is set to high then macros are automaticlly disabled when a workbook is opened!
    Each scriptsheet workbook contains additional worksheet functions which are implemented as VBA macro’s.

Drawing Setup Sample

Download: Drawingsetup.zip (33 kB)

This sample scriptsheet template automates the insertion of a drawing border and title block. The sheet makes use of named cell-ranges to store data and spreadsheet functions to look it up again.

This is an excelent sheet to study the basics of programming using the Scriptsheets Add-In and it also get you started drawing in AutoCAD aswell.

Survey data sample

Download: Survey.zip (21 kB)

This sample scriptsheet holds a named cell range which could hold various rows of XYZ coordinates.  For each row in the range a point command is written to the scriptfile. Standard worksheets functions are used to get the verying number of rows and to lookup the XYZ coordinates.

This sheet is interesting because it shows how to use a FOR/NEXT loop to pharse the rows in a named cell range.