...questions about VBA. † Finance Dept, Kellogg School, Northwestern University, 2001 Sheridan Rd., Evanston, IL 60208, tel: 847-491-8344, fax: 847-491-5719, E-mail: r-mcdonald@northwestern.edu. CONTENTS 2 5 Storing and Retrieving Variables in a Worksheet 5.1 Using a named range to read and write numbers from spreadsheet . . . . . . . . . . . . . . . . . . . . . . . . . 5.2 Reading and Writing to Cells Which are not Named. . . 5.3 Using the “Cells” Function to Read and Write to Cells. 10 the . . . . . . . . . 11 12 13 6 Using Excel Functions 13 6.1 Using VBA to compute the Black-Scholes formula . . . . . . 13 6.2 The Object Browser . . . . . . . . . . . . . . . . . . . . . . . 15 7 Checking for Conditions 16 8 Arrays 17 8.1 Defining Arrays . . . . . . . . . . . . . . . . . . . . . . . . . . 18 9 Iterating 19 9.1 A simple for loop . . . . . . . . . . . . . . . . . . . . . . . . . 20 9.2 Creating a binomial tree . . . . . . . . . . . . . . . . . . . . . 20 9.3 Other...
Words: 10883 - Pages: 44
...Java provides a data structure, the array, which stores a fixed-size sequential collection of elements of the same type. An array is used to store a collection of data, but it is often more useful to think of an array as a collection of variables of the same type. Instead of declaring individual variables, such as number0, number1, ..., and number99, you declare one array variable such as numbers and use numbers[0], numbers[1], and ..., numbers[99] to represent individual variables. This tutorial introduces how to declare array variables, create arrays, and process arrays using indexed variables. Declaring Array Variables: To use an array in a program, you must declare a variable to reference the array, and you must specify the type of array the variable can reference. Here is the syntax for declaring an array variable: ------------------------------------------------- dataType[] arrayRefVar; // preferred way. ------------------------------------------------- ------------------------------------------------- or ------------------------------------------------- ------------------------------------------------- dataType arrayRefVar[]; // works but not preferred way. Note: The style dataType[] arrayRefVar is preferred. The style dataType arrayRefVar[] comes from the C/C++ language and was adopted in Java to accommodate C/C++ programmers. Example: The following code snippets are...
Words: 1665 - Pages: 7
...Programming Logic and Design, 6th Edition Chapter 6 Exercises 1. a. Design the logic for a program that allows a user to enter 10 numbers, then displays them in the reverse order of their entry. Answer: A sample solution follows Flowchart: Pseudocode: start Declarations num index num SIZE = 10 num numbers[SIZE] = 0,0,0,0,0,0,0,0,0,0 getReady() while index < SIZE getNumbers() endwhile finishUp() stop getReady() index = 0 return getNumbers() output “Enter a number for position ”, index input numbers[index] index = index + 1 return finishUp() output “The numbers in reverse order are: ” while index > 0 index = index – 1 output numbers[index] endwhile return b. Modify the reverse-display program so that the user can enter up to 10 numbers until a sentinel value is entered. Answer: A sample solution follows Flowchart: Pseudocode: start Declarations num index num SIZE = 10 num numbers[SIZE] = 0,0,0,0,0,0,0,0,0,0 string CONTINUE = “Y” string moreNumbers = CONTINUE getReady() while index < SIZE AND moreNumbers equal to CONTINUE getNumbers() endwhile finishUp() stop getReady() index = 0 output “Do you want to enter a number? (Y/N)” input moreNumbers return getNumbers() output “Enter a number for position ”, index input numbers[index] index = index...
Words: 4366 - Pages: 18
...Lab 1: Introduction to MATLAB Warm-up MATLAB is a high-level programming language that has been used extensively to solve complex engineering problems. The language itself bears some similarities with ANSI C and FORTRAN. MATLAB works with three types of windows on your computer screen. These are the Command window, the Figure window and the Editor window. The Figure window only pops up whenever you plot something. The Editor window is used for writing and editing MATLAB programs (called M-files) and can be invoked in Windows from the pull-down menu after selecting File | New | M-file. In UNIX, the Editor window pops up when you type in the command window: edit filename (‘filename’ is the name of the file you want to create). The command window is the main window in which you communicate with the MATLAB interpreter. The MATLAB interpreter displays a command >> indicating that it is ready to accept commands from you. • View the MATLAB introduction by typing >> intro at the MATLAB prompt. This short introduction will demonstrate some basic MATLAB commands. • Explore MATLAB’s help capability by trying the following: >> help >> help plot >> help ops >> help arith • Type demo and explore some of the demos of MATLAB commands. • You can use the command window as a calculator, or you can use it to call other MATLAB programs (M-files). Say you want to evaluate the expression [pic], where a=1.2, b=2.3, c=4.5 and d=4....
Words: 2151 - Pages: 9
...Handout: Problem Solving and 'C' Programming Version: PSC/Handout/1107/1.0 Date: 16-11-07 Cognizant 500 Glen Pointe Center West Teaneck, NJ 07666 Ph: 201-801-0233 www.cognizant.com Problem Solving and C Programming TABLE OF CONTENTS About this Document ....................................................................................................................6 Target Audience ...........................................................................................................................6 Objectives .....................................................................................................................................6 Pre-requisite .................................................................................................................................6 Session 2: Introduction to Problem Solving and Programming Languages ...........................7 Learning Objectives ......................................................................................................................7 Problem Solving Aspect ...............................................................................................................7 Program Development Steps .......................................................................................................8 Introduction to Programming Languages ...................................................................................14 Types and Categories of Programming Languages...
Words: 4320 - Pages: 18
...grades should be stored in a two-dimensional (doubly subscripted) array of double numbers. The student's name should be stored in a single-dimensional string array. The student's course should be stored in a single-dimensional string array. Allow the program to store up to 100 students' grades. Once the student's grades have been added, display the student's name, course and average grade in the list box. The list box sorted property should be set to true. To edit a student's grades, select an entry from the list box. You will need to search through the students name array to find a match. Pull the information from the arrays and put them in the controls in the submit area. Disable the student's name and course text boxes, list box, and Edit and Delete buttons. The user may only modify the grades. These will be updated in the grades array and the average redisplayed in the list box. When a student's grades are deleted, physically move the data up in the arrays. See the Sample Output below for further instructions. Pseudocode: Declare this at the top of the form class // initialize number of students to zero int studentCount = 0; // one-dimensional array to store student names string[] studentNamesAr = new string[100]; // one-dimensional array to store course numbers string[] courseAr = new string[100]; // two-dimensional array to store grades int[,] gradesAr = new int[100, 4]; ...
Words: 733 - Pages: 3
...An Introduction to R Notes on R: A Programming Environment for Data Analysis and Graphics Version 3.2.0 (2015-04-16) W. N. Venables, D. M. Smith and the R Core Team This manual Copyright c Copyright c Copyright c Copyright c Copyright c is for R, version 3.2.0 (2015-04-16). 1990 W. N. Venables 1992 W. N. Venables & D. M. Smith 1997 R. Gentleman & R. Ihaka 1997, 1998 M. Maechler 1999–2015 R Core Team Permission is granted to make and distribute verbatim copies of this manual provided the copyright notice and this permission notice are preserved on all copies. Permission is granted to copy and distribute modified versions of this manual under the conditions for verbatim copying, provided that the entire resulting derived work is distributed under the terms of a permission notice identical to this one. Permission is granted to copy and distribute translations of this manual into another language, under the above conditions for modified versions, except that this permission notice may be stated in a translation approved by the R Core Team. i Table of Contents Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1 Introduction and preliminaries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 1.10 1.11 2 Intrinsic attributes: mode and length . . . . . . . . . . . . . . . . . . . . . . . . . . . ...
Words: 8172 - Pages: 33
... Programming Development: Personal Learning Management The part of the program I believe to need an array would be the entire program. The Subject, the Classes, the weeks, the keywords, and the notes. I am still unsure as to how the arrays work, I have been trying to practice them, but there is not much in the way of instruction on how to use them. I know it can be a list or a table, which works well with the program. For example, the program can be a table starting from the subject, breaking down into the classes, which break down into the weeks that break down into the keywords and the notes. In my opinion, the only way the program could be put together in its simplest form would be in an array. Using an array can reduce the number of variable names needed in a program because a single array can be used instead of a collection of simple variables to store related data (Venit, Stewart & Drake, Elizabeth; Prelude to Programming Concepts and Design; Chapter 6- Arrays: Lists and Tables.). So using an array is the best way to simplify my entire program. The best part of the array is being able to set up the search for the index of keywords. It will make being able to type in the keyword and pull up the table containing that keyword much easier. For this I will have to set it up for a binary search. The following pseudocode is updated to include the arrays and the binary search: Pseudocode Display “Student Notebook” Display “Subject...................
Words: 807 - Pages: 4
...| | d. Program ops | | | e. None of the above | | Correct Marks for this submission: 1/1. Question2 Marks: 1 Programmer-defined names of memory locations that may hold data are: Choose one answer. | a. Operators | | | b. Variables | | | c. Syntax | | | d. Operands | | | e. None of the above. | | Correct Marks for this submission: 1/1. Question3 Marks: 1 Which of the following best describes an operator? Choose one answer. | a. An operator is a rule that must be followed when constructing a program. | | | b. An operator allows you to perform operations on one or more pieces of data. | | | c. An operator marks the beginning or ending of a statement, or is used to separate items in a list. | | | d. An operator is a word that has a special meaning. | | | e. An operator is a symbolic name that refers to a variable. | | Correct Marks for this submission: 1/1. Question4 Marks: 1 What does the term hardware refer to? Choose one answer. | a. The relative difficulty of programming | | | b. The physical components that a computer is made of | | | c. The way a computer's storage space is organized | | | d. The logical flow of instructions | | | e. None of the above. | | Correct Marks for this submission: 1/1. Question5 Marks: 1 The computer's main memory is commonly known as: Choose one answer. | a. The hard disk | | | b. The floppy disk | | | c. RAM | | | d. Secondary...
Words: 10107 - Pages: 41
...elements, or values, the array can hold. a.|the new operator| b.|the array’s size declarator| c.|the array’s data type| d.|the version of Java| ANS: B 2. What does the following statement do? double[] array1 = new double[10]; a.|Declares array1 to be a reference to an array of double values| b.|Creates an instance of an array of 10 double values| c.|Will allow valid subscripts in the range of 0 - 9| d.|All of the above| ANS: D 3. It is common practice to use a ____________ variable as a size declarator. a.|static| b.|reference| c.|final| d.|boolean| ANS: C 4. What do you call the number that is used as an index to pinpoint a specific element within an array? a.|subscript| b.|global unique identifier| c.|element| d.|argument| ANS: A 5. Subscript numbering always starts at what value? a.|0| b.|1| c.|-1| d.|None of the above| ANS: A 6. By default, Java initializes array elements with what value? a.|0| b.|100| c.|1| d.|-1| ANS: A 7. What will be the value of x[8] after the following code has been executed? final int SUB = 12; int[] x = new int[SUB]; int y = 100; for(int i = 0; i < SUB; i++) { x[i] = y; y += 10; } a.|170| b.|180| c.|190| d.|200| ANS: B 8. Java performs ____________, which means that it does not allow a statement to use a subscript that is outside the range of valid subscripts for the array. a.|active array sequencing| b.|array bounds checking| c.|scope...
Words: 1531 - Pages: 7
...A Tutorial on Pointers and Arrays in C A TUTORIAL ON POINTERS AND ARRAYS IN C by Ted Jensen Version 1.1 (HTML version) July 1998 This material is hereby placed in the public domain Available in various formats via http://www.netcom.com/~tjensen/ptr/cpoint.htm TABLE OF CONTENTS Preface Introduction Chapter 1: What is a Pointer? Chapter 2: Pointer Types and Arrays. Chapter 3: Pointers and Strings Chapter 4: More on Strings Chapter 5: Pointers and Structures Chapter 6: More on Strings and Arrays of Strings Chapter 7: More on Multi-Dimensional Arrays Chapter 8: Pointers to Arrays Chapter 9: Pointers and Dynamic Allocation of Memory Chapter 10: Pointers to Functions file:///E|/My%20eBooks/_ESSENTIALS_/A%20Tutorial%...orial%20on%20Pointers%20and%20Arrays%20in%20C.htm (1 of 2)3/18/2007 12:09:49 AM A Tutorial on Pointers and Arrays in C Epilog file:///E|/My%20eBooks/_ESSENTIALS_/A%20Tutorial%...orial%20on%20Pointers%20and%20Arrays%20in%20C.htm (2 of 2)3/18/2007 12:09:49 AM Preface PREFACE This document is intended to introduce pointers to beginning programmers in the C programming language. Over several years of reading and contributing to various conferences on C including those on the FidoNet and UseNet, I have noted a large number of newcomers to C appear to have a difficult time in grasping the fundamentals of pointers. I therefore undertook the task of trying to explain them in plain language with lots of examples. The first version of this document was...
Words: 9878 - Pages: 40
...VBScript IP File Lab Objectives In this lab, students will complete the following objectives. * Create a VBScript program using NotePad++. * Write a two-dimensional array of IP addresses to a text file. * Read the IP Addresses text file into a script. * Append new Room/PC/IP address data to the text file. * Use the object Scripting.FileSystemObject. Lab Diagram During your session you will have access to the following lab configuration. Connecting to your lab For this lab, we will only need to connect to Vlab-PC1. * Vlab-PC1 To start simply click on the named Workstation from the device list (located on the left hand side of the screen) and click Power on in the tools bar. In some cases the devices may power on automatically. During the boot up process an activity indicator will be displayed in the name tab. * Black—Powered Off * Orange—Working on your request * Green—Ready to access If the remote console is not displayed automatically in the main window (or popup) click the Connect icon located in the tools bar to start your session. If the remote console does not appear please try the following option. * Switch between the HTML 5 and Java client versions in the tools bar. In the event this does not resolve your connectivity problems, please visit our Help/Support pages for additional resolution options. Task 1: Create the IP_FileWrite.vbs Program Note: All captures must be text only—DO NOT capture the NotePad++...
Words: 2335 - Pages: 10
...CHAPTER 5 – ARRAYS CASE STUDY SCENARIO Sorting Data A dozen umbrellas lie on the ground just inside the classroom door when Dr. Taylor begins his lecture. “A cold, rainy day like today makes me want to stay in and order pizza for delivery rather than go out myself.” Handing a phone book to a student in the front row, Dr. Taylor says “Gail, please look up the phone number for Domino’s Pizza on Main Street, and if you don’t mind, I will time how long it takes you to find the number.” Gail flips through a few pages while Dr. Taylor looks at his watch. “Here it is . . . 555-8275,” she says. “Seven seconds. Thank you Gail.” Dr. Taylor presses some keys on his cell phone while continuing his conversation. “Now please look up the name of the person with the phone number 555-5982, and again I will time you.” Dr. Taylor’s focus returns to his watch even as he speaks into the phone. Gail slowly flips a couple of pages, then stops just about the same time Dr. Taylor ends his call. “I assure you the number is in there, Gail. We will wait while you look it up.” “You will probably wait a long time,” she says, “because there is no fast way to find a number.” “Why not? It’s the same data.” “But the phone book is sorted by names, so finding a name is easy. Finding a number is very difficult because a phone book is not sorted by numbers.” Dr. Taylor takes the phone book from Gail. “Exactly! The sorting process does not change the data, but it organizes the data in a context...
Words: 5653 - Pages: 23
.... MC 1. (TCO 13) Text files are what type of file? 4 Points : Sequential Random access Binary Consecutive Instructor Explanation: Lecture / Chapter 13 Edit 3. MC 1. Delete (TCO 13) To create an input file object, what kind of type would you use? 4 Points : ifstream ofstream fstream instream Instructor Explanation: Lecture / Chapter 13.1 Introduction Edit 4. MC 1. Delete (TCO 13) To create an output file object, what kind of type would you use? 4 Points : ifstream ofstream fstream instream Instructor Explanation: Lecture / Chapter 13.1 Introduction Edit 5. MC 1. Delete (TCO 13) The header file that defines the classes for processing and manipulating files is called the _____. 4 Points : Instructor Explanation: Chapter 13.1 Introduction Edit 6. 7. 8. MC 2. Delete (TCO 13) What do the following statements accomplish? ifstream theFile; theFile.open( myFile.txt , ios::in); 4 Points : Opens myFile in read mode Opens myFile in append mode Creates an empty file named myFile Opens a file in input mode to write to Instructor Explanation: Lecture / Chapter 13 Edit 9. MC 2. Delete (TCO 13) What do the following statements accomplish? ofstream theFile; theFile.open( myFile.txt , ios::out); 4 Points : Opens myFile in read mode Opens myFile in append mode Creates an empty file named myFile Opens a file in input mode to write to Instructor Explanation: Lecture / Chapter 13 Edit...
Words: 2540 - Pages: 11
...Declaring constants in Pascal A constant is a value that is given a name. The constant can be used anywhere in a program and will always have the same value. Constants are declared in the declaration section of the program, that is the section before begin using the keyword, Const. Value Constant name Name: data type= value; Data type A command is an instruction that is a single word. Eg. READ For example to declare a constant to store a value for tax: Const Tax: real=.15; TEST YOUR UNDERSTANDING Initialize the following constants in Pascal: i. ii. The number of seconds in a minute. iii. The temperature at which water boils iv. The number of months in a year. v. The discount amount for 5%. Writing data to the screen (WRITE and WRITELN) Pascal uses write and writeln to display information on the computer screen. These statements are useful when prompting user for data and displaying information of a processed result to the screen. * Writeln is also useful when a space is needed in the program. You can create a space by typing: WRITELN; * Writeln can also be used to display a string and a variable: WRITELN (‘the sum is’, sum); Before you read, you must write. The write is used when we want the data to be displayed on the same line, while writeln is used when we want to accept data in a new line. Place the information that you are writing to the screen in brackets and single quotes. Example: Write (‘enter your...
Words: 3441 - Pages: 14
