Dec 212017

A very interesting and helpful sample of Templates and Macros for Lotus applications in the laboratory. | |||
---|---|---|---|

File Name | File Size | Zip Size | Zip Type |

1STDERV.WK1 | 36097 | 8016 | deflated |

COMMENT.WK1 | 5513 | 1427 | deflated |

COMNUMS.WK1 | 5712 | 1578 | deflated |

CONFIDEN.WK1 | 6300 | 1665 | deflated |

CONTROL.WK1 | 3998 | 764 | deflated |

CONTROLM.WK1 | 5522 | 1325 | deflated |

CONTRUN.WK1 | 5146 | 1361 | deflated |

DAYOFWEK.WK1 | 1558 | 295 | deflated |

ERRORBAR.WK1 | 7342 | 2441 | deflated |

LINE.WK1 | 5610 | 1422 | deflated |

LOTUSLAB.DOC | 15849 | 4819 | deflated |

MULSCAT.WK1 | 3296 | 925 | deflated |

MULTIXY.WK1 | 3296 | 923 | deflated |

POLYPLOT.WK1 | 24402 | 3297 | deflated |

PREDICT.WK1 | 12748 | 2667 | deflated |

REACTOR.WK1 | 6035 | 1331 | deflated |

SECOND.WK1 | 10246 | 2030 | deflated |

SLIDESHW.WK1 | 18128 | 4227 | deflated |

SURFACE.WK1 | 46781 | 7141 | deflated |

THIRD.WK1 | 12474 | 2513 | deflated |

TIMER.WK1 | 2031 | 627 | deflated |

VIEWGRPH.WK1 | 18500 | 4440 | deflated |

# Download File SCITEMPS.ZIP Here

## Contents of the LOTUSLAB.DOC file

Lotus in the Lab: Macros and Templates

A sampling of Templates and Macros for Lotus applications in the

laboratory.

These applications were compiled by Glenn Ouchi, Ph.D., editor-

in-chief of Laboratory PC User, a newsletter for laboratory PC

professionals. If you like what you see, we also offer "Dr.GO's

Best, fifty of the world's best templates and macros for the

world of Lotus in the Lab.

Printing This Information

The manual for these Macros and Templates is on disk. You can

print this manual on your print with the command:

COPY LOTUSLAB.DOC PRN

Good Luck using Lotus 1-2-3 in Your Laboratory. If you have

comments or questions about these templates please contact:

Personal Computing Tools Inc.

101 Church Street, Unit 12

Los Gatos, CA 95030

or call us at (408) 395-6600

Dave Willard and Leon Hamner

1

Lotus in the Lab: Macros and Templates

(c) Copyright 1987 Glenn I. Ouchi all rights reserved.

Limitation of Liability

In no event will Glenn I. Ouchi his companies or heirs be liable

for direct, indirect , special, incidental, or consequential

damages arising out of the use or inability to use the software

and material contained on this disk or document, even if advised

of the possibility of such damages. In particular, Glenn I.

Ouchi, his companies or heirs is not responsible for any costs

including, but not limited to, those incured as a result of lost

profit or revenue, loss of use of the computer applications, loss

of data, the cost of subsitute programs, claims by third parties

or other similar costs.

Glenn I. Ouchi has tested each of the applications on these

disks. Glenn I. Ouchi, however, does not guarantee that the

applications contain no errors, the applications are sold "as is"

and you, the user, are assuming all risk in their quality.

Lotus, and 1-2-3, are registered trademarks of Lotus Development

Corporation.

IBM, XT, AT, and PS/2 are registered trademarks of International

Business Machines.

Laboratory PC User is a trademark of BREGO Research.

2

Introduction

Lotus 1-2-3 was once viewed as a program written solely for

business applications. But now, thousands of scientists and

engineers have discovered the power of Lotus 1-2-3 for solving

their laboratory data analysis, data display and data management

problems. This set of Lotus 1-2-3 templates and macros will

introduce you to many applications of Lotus 1-2-3 you can use in

your laboratory today to solve your data handeling problems.

Many of these applications were first published in the monthly

newsletter Laboratory PC User. If you would like a free

introductory issue of this newsletter contact:

Laboratory PC Users Group

5989 Vista Loop

San Jose, CA 95124

or telephone: (408) 723-0947

The newsletter costs $36 for 12 issues (one year) in the US and

is $56 for 12 issues outside the US. The users group also has a

library of over 70 freeware/shareware disks for just $6 per disk.

These programs were selected for their ability to solve scientific

and engineering problems.

A special newsletter plus monthly disk subscription is available

for just $96 in the US and $123 in other countries. this

subscription includes 12 issues of the newsletter and 12 monthly

freeware/shareware disks.

Dr GO's BEST

If you like this sampling, you should buy Dr. GO's Best with

fifty of the world's best templates and macros for the world of

Lotus 1-2-3 in the laboratory. To order Dr. GO's Best contact:

Personal Computing Tools

101 Church Street, Unit 12

Los Gatos, CA 95030

telephone (408) 395-6600

Before You Start

Make a back-up copy of the disk before you start. This will

insure you will always have an original copy of the applications.

The easiest way to make a back-up is to use the DOS copy command

or the DOS diskcopy command to copy the contents of the disk to a

blank formatted disk.

Getting Started

Welcome to the World of Lotus 1-2-3 in the Lab. We are sure you

3

will find these Lotus 1-2-3 Macros and Templates valuable and

thought provoking. There are many ways to use these Macros and

Templates. Here are a few examples:

* Immediately - They can be used immediately to solve the

problem they were developed to solve. You can enter new raw data

values and obtain a new report or graph.

* Customize - You can customize them to perfectly meet your

needs. A Macro or Template may perform 70, 80 or 90 percent of

what you need, you can customize that macro or template and get

exactly what you want.

* Combine - You can combine one or more of these templates

with your own templates to perform new functions, reporting and

graphs.

* Training - Learn new applications of Lotus 1-2-3 by using

these macros and templates. See how specific Lotus commands can

be used to perform various laboratory reporting and graphics.

* New Ideas - Some of these macros and templates will perform

tasks you never thought Lotus 1-2-3 could perform.

What You Will Need

To use these Macros and Templates you will need an IBM PC, XT,

AT, PS/2, or IBM compatible computer with the ability to perform

graphics. You will need a copy of Lotus 1-2-3 version 2 or

greater. If you do not have Lotus 1-2-3 version 2, you can still

upgrade from version 1A for $150. Contact Lotus Development on

how to upgrade your copy of Lotus 1-2-3.

How to Use the Macros and Templates

Each of the Macros and Templates is on disk and ready to use.

Load Lotus 1-2-3 and use the command:

/File Retrieve

to load the Macro or Template you wish to use. You can also

combine one or more of the Macros and Templates with your own

work by using the command:

/File Combine Entire-File

Macros and Templates Index

Here are the file names of the Macros and Templates along with a

short description of each application. A longer description of

each macro and template is in the next section.

CONTROL.WK1 Control charting template.

CONTROLM.WK1 Control charting template with auto-entry macro.

CONTRUN.WK1 Control charting template using unbiased (n-1) STD.

4

LINE.WK1 Linear Regression and plot template.

SECOND.WK1 Quadratic Least Squares Fit and plot template.

THIRD.WK1 Third-Order Least Squares Fit and plot template.

PREDICT.WK1 Predict value from regression line macro.

POLYPLOT.WK1 Plot a polynomial, template.

1STDERV.WK1 Plot first and second derivative for values.

ERRORBAR.WK1 Linear Regression with Error Bars Plot macro.

CONFIDEN.WK1 Linear Regression with Confidence Lines template.

COMMENT.WK1 Plots with comments or text directly on the plot.

COMNUMS.WK1 Plots with text and numbers directly on the plot.

SURFACE.WK1 Plot a surface template.

MULTIXY.WK1 Plot multiple XY line graphs with diverse data.

MULSCAT.WK1 Plot multiple XY scatter graph with diverse data.

SLIDESHW.WK1 Graphics Slide Show macro.

TIMER.WK1 Elasped time keeping macro.

DAYOFWEK.WK1 Print the day of the week for any date.

VIEWGRPH.WK1 Select graphs from a list to display macro.

REACTOR.WK1 Semilog plot of a chemical reaction.

Macros and Template Description

CONTROL.WK1 Control charting template. This template creates

a control chart using the data in the named range "DATA". Press

F10 to see this chart. This chart was created using two standard

deviations as the control limits. You can alter this value

easily. Control charts are valuable tools in monitoring your

data. A control sample can be run on a regular schedule and the

results charted. If the results of an analysis on the control

sample are outside the control limits the instrument operator

must take action to correct the problem.

CONTROLM.WK1 Control charting template with auto-entry macro.

A menu and macros is added to the control charting template.

Press Alt-m to see the menu. The operator can now enter a new

control chart value or graph the control chart by simply

answering a prompt. This macro shows how to create a menu and

make an easy to use menu driven system using Lotus macros.

CONTRUN.WK1 Control charting template using unbiased (n-1)

STD. The standard deviation function in Lotus 1-2-3 uses the n

(biased) method of computing. This template uses the n-1

(unbiased) standard deviation computation method.

LINE.WK1 Linear Regression and plot template. This

template performs a linear regression and plots the resulting

linear least squares fit line. Press F10 to see the plot.

SECOND.WK1 Quadratic Least Squares Fit and plot template.

This template perform a quatratic regression and plots the

5

resulting quadratic least squares fit curve. Press F10 to see

the plot.

THIRD.WK1 Third-Order Least Squares Fit and plot template.

This template performs a cubic (third-order) regression and plots

the resulting cubic least squares fit curve. Press F10 to see

the plot.

PREDICT.WK1 Predict value from regression line macro. This

macro will report the predicted value from a regression line.

You enter the X value and the resulting Y value will be

displayed.

POLYPLOT.WK1 Plot a polynomial, template. This template will

plot any polynomial up to fifth order if you know the

coefficients. Enter the coefficients and then press F10 to see

the plot.

1STDERV.WK1 Plot first and second derivative for values. This

template shows how you can plot the first and second derivative

of any function or set of values. Press F10 to see the plots.

ERRORBAR.WK1 Linear Regression with Error Bars Plot macro.

This macro will produce error bars along with a linear least

square fit line. Press F10 to see the plot. The macro reads

values from the table in the upper left corner of the template.

These values are then placed on the template in "blocks" to

create the graph.

CONFIDEN.WK1 Linear Regression with Confidence Lines template.

This template plots confidence intervals for a set of linear

regression data. Confidence intervals are computed from the

amount of potential error in the regression. The larger the

potential error in the regression, the larger (wider apart) the

confidence interval. The "FVAL" is entered from an F-

Distribution table, a table found in most statistics books.

Press F10 to see the regression with confidence intervals.

COMMENT.WK1 Plots with comments or text directly on the plot.

This template shows how any text can be added to a Lotus graph.

COMNUMS.WK1 Plots with text and numbers directly on the plot.

This template shows how text and numeric values can be placed on

a Lotus graph.

SURFACE.WK1 Plot a surface template. This template allows you

to plot weird surface plots. Enter a new set of parameters and a

new graph can be plotted. This template shows the versatility of

Lotus graphics.

MULTIXY.WK1 Plot multiple XY line graphs with diverse data.

You are not limited in the number of sets of data you can plot

using Lotus 1-2-3. On the surface, it would seem you can plot

only 6 sets of data, but in fact you can plot literally as many

sets of data as you wish. By leaving a blank cell between sets

6

of data, one range can plot multiple lines.

MULSCAT.WK1 Plot multiple XY scatter graph with diverse data.

Scatter plots can also be generated on multiple sets of data.

You are limited to just six sets of data.

SLIDESHW.WK1 Graphics Slide Show macro. This macro allows you

to display many graphs of your data like a slide show. It is

very useful if you need to compare sets of data or need to show

your data to others.

TIMER.WK1 Elasped time keeping macro. This macro will

compute the amount of time you spent using a spreadsheet. It can

also be easily modified to simply print the elasped time between

event like a stop watch. The elasped time along with a date

stamp is placed in the spreadsheet.

DAYOFWEK.WK1 Print the day of the week for any date. This

template, shows how to compute the day of the week from any date

function value.

VIEWGRPH.WK1 Select graphs from a list to display macro. This

macro will allow you to display any of your named graphs. You

simple, make a list of the named graphs and then select the graph

you wish to view from the list.

REACTOR.WK1 Semilog plot of a chemical reaction. This

template plots a semilog plot of a chemical reaction with

concentration on the Y-axis and time on the X-axis. Press F10 to

see the plot.

7

December 21, 2017
Add comments