PSModel a look inside

HOME

Introduction

Quick Start

Quick Series
Facts

PSModel
Program

Data Input

Data Output

Importing a
Data file into
MS Excel

Main Menu

Main Screen

Printing
Graphs
and Data

Screen Colors
and Fonts

Screen
Graphs

Shortcuts

Working
with Data

Testing:

Test Sheet

Examples

19' Ski Boat

34' Sailboat

41' Utility Boat

Technical

Blade Area
Ratio

Calculating
the Cavitation
Number

Horsepower
Losses

Hull Speed

Kt Breakdown

Propeller
Geometry

Propeller Law

Wake Factors

Glossary

References

Importing A Data File Into MS Excel:

PSModel data files (*.psm_data) can be imported into a Microsoft Excel spreadsheet as follows:

1) From MS Excel's main menu select Data\ Import External Data\ Import Data.

2) In the dialog box that opens select All Files (*.*) from the "Files of Type" drop down list.

3) Navigate to the directory where the PSModel data files are kept.

4) Double click on the PSModel data file (*.psm_data) to be imported.

5) Under File Types in MS Excel's Text Import Wizard dialog box, choose "Delimited" .

6) Click Next.

7) Under Delimiters check the "Space" check box, also check the "Treat consecutive delimiters as one" check box, uncheck any other check boxes that may have been checked.

8) Click Next.

9) In the data preview window of the Text Import Wizard dialog box, all columns should be selected as "General".

10) Click Finish.

Column headers as well as column data should be imported into Microsoft Excel, and should look similar to the Data Window in PSModel.  The above example is for Microsoft Excel 2002, and should be similar for other versions of Excel.