Scribd
Upload
29 views12 pages

Programming in Excel and SketchUp

This document provides an introduction to programming in Excel and SketchUp. It discusses using Excel for calculations but notes its limitations with extensive use. SketchUp allows for fast modeling but lacks automation. The document outlines examples of calculating polygon properties in Excel and automating tasks in SketchUp. It lists objectives of understanding programming principles, learning to program in Excel and SketchUp using Ruby, and discusses fundamental algorithms and programmable software options. An agenda is provided covering programming concepts, algorithms, and programming in Excel, SketchUp basics and Ruby.

Uploaded by

Junar Amaro
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPT, PDF, TXT or read online on Scribd
29 views12 pages

Programming in Excel and SketchUp

This document provides an introduction to programming in Excel and SketchUp. It discusses using Excel for calculations but notes its limitations with extensive use. SketchUp allows for fast modeling but lacks automation. The document outlines examples of calculating polygon properties in Excel and automating tasks in SketchUp. It lists objectives of understanding programming principles, learning to program in Excel and SketchUp using Ruby, and discusses fundamental algorithms and programmable software options. An agenda is provided covering programming concepts, algorithms, and programming in Excel, SketchUp basics and Ruby.

Uploaded by

Junar Amaro
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPT, PDF, TXT or read online on Scribd

Programming

in Excel and SketchUp


Introduction

Danijel Rebolj 2009


Motivation
Software is being developed to cover as
many requirements as possible, but
some function is always missing
Using functions in Excel is great, but has
its limitations and becomes unclear with
extensive use and interlinked cells
With SketchUp you can model fast and
easy, but there is little automation
Excel example
Area and center of a polygon
SketchUp example
Automation
Database example
Movie list
What data?
What can we do with a spreadsheet?
What we cant do?
Database example
Movie database
Objectives
To understand the basic principles
of computer programing
To be able to program in Excel
To understand the principles of
SketchUp and be able to use it
efficiently
To be able to write a program in
SketchUp using Ruby
Agenda
Computer programming principles
Some fundamental algorithms
(Fibonacci sequences, geometrical
operations, matrix operations,
searching and sorting)
Programming in Excel
SketchUp basics
Programming in Ruby
Programmable software
VBA in
MS Office (Word, Excel, Access,
Outlook)
MS Project, MS MapPoint, MS Visio
Autodesk AutoCAD
ArcGIS
OpenOffice Basic
Ruby in SketchUp
Program languages
Programmers
view for 2013
Discussion
Experiences?
Expectations? (What would you like
to program?)
Do engineers need to know
computer programming? How
much?
Lab 1
Find a suitable problem
Analyse it, considering
data
procedures
Design a solution
Formulate limitations
Sketch a user interface

You might also like