Class12 - Class meeting #12 Monday, Oct 4th GEEN 1300...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
1 GEEN 1300 Introduction to Engineering Computing Class meeting #12 Monday, Oct 4 th Range objects Scope of variables 1 Using built-in functions, VBA’s and Excel’s Homework #5 due on Wednesday, October 6 th VBA “Nuts and Bolts” Data types, constants, variables, expressions, assignment Data types the most common: single, integer and string Single used for most numbers with decimal fractions and possibly exponents precision: about 6-to-7 significant figures range: from about 10 38 down to 10 -39 , both + and - uses 4 bytes of memory 2 Integer used for most counting numbers range: from –32,768 to 32,767 uses 2 bytes of memory
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 String used to store text 1 byte is used for each character characters are stored according to the standard ASCII code Additional data types Double used for numbers with decimal fractions and possibly exponents where high precision or extended range are required precision: about 15-to-16 significant figures 3 range: from about 10 308 down to 10 -309 , both + and - uses 8 bytes of memory Important : Excel uses “double” for the numbers stored in cells on the spreadsheet Long used for integers where extended range is required range is about - 2 billion to + 2 billion each number uses 4 bytes of memory used for T/F information two constant values: TRUE and FALSE 2 bytes are used for each Boolean quantity Boolean (also called “logical”) Object used for any defined object takes up 4 bytes of memory 4 Variant adjusts automatically to the data type required “chameleon” data type storage requirements vary
Background image of page 2
3 There are additional data types for currency, date It is also possible to define new data types:
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/07/2010 for the course CHEN 1300 at Colorado.

Page1 / 8

Class12 - Class meeting #12 Monday, Oct 4th GEEN 1300...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online