Start Your Project. Prepare your data using templates

Start your Project. Prepare your data using templates

In the Overview of The DEPLOY Process I mentioned:

"We Learn by Doing."

So far you have run three demo projects.

  • Cheesecake Project
  • Molding Project
  • ReactorOptimization Project

So you now know, how to run the software.

Now, let us take a deeper dive. 

  1.  Learn how to create new data files for your Projects
  2. Run Your Projects using FastR&D software.

Remember we need to create THREE data files.

Select Project Name:

Pick a project.

Ideally one for which you have about 15 -20 experiments, It is not a critical requirement. But it is small enough that you can create three files needed, edit data if necessary and run the FastR&D software.

Let us start by selecting a simple, project name that describes your project.  Ideally it should be one word, e.g., Cheesecake. If you must use a few words, consider something like, Cheesecake_Demo or Cheesecake_Simulated_Data. Remember, we typically use the same starting word or phrase for the three file names. Use hyphens or underscore to connect two or more words. Single Word names are preferable.

Let us assume you have picked the name of your project as "Myname"

So the three file names are:

  1. 1
    Myname_proj_desc.csv
  2. 2
    Myname_proj_def.csv
  3. 3
    Myname_proj_data.csv

File 1: Myname Project Description

This is a free from description for your project.

Ideally it should be 5-10 sentences, written in simple English, so even a non-technical person understand what the project is all about.

A suggestion. In the first line include your project name, e.g., Myname Project or Myname Optimization

In the next several lines briefly describe the key project objectives. If needed, mimic the Cheesecake Project template provided - "Cheesecake_Defining-Problem-Clearly-Template-in-EXCEL_v_2" It is by no means perfect, but will get you started.

File 2: Myname Project Definition

For your project definition file, start with the Cheesecake template provided - "Cheesecake_Defining-Problem-Clearly-Template-in-EXCEL_v_2"

Copy these file for your project use.

Edit the copy by mimicking the Cheesecake spreadsheet that looks like the image below.  This is strictly for your personal use and understanding. Make a copy of this spreadsheet tab.

Cleanup this copy of the spreadsheet using instructions provided in the note below this pretty graphic in the excel file. It should look like pure vanilla excel csv file with all the fonts, colors, graphics, borders removed. See another spreadsheet file if needed. Save it as Myname_proj_def.csv file.

File 3: Myname Project Data

Again mimic the Cheesecake template provided - "Cheesecake_Defining-Problem-Clearly-Template-in-EXCEL_v_2."

Copy the file, review the Cheesecake_proj_data.csv

Follow the guidelines provided in the note, modify the template copy to meet your needs. 

- Do not delete three columns - "Type" , "No" and "Date"

- Follow the instructions in the Note. Cleanup your file and save it as Myname_proj_data.csv 


Run the FastR&D software

To run the FastR&D software, you will need to answer two questions:

Question 1: Enter Project Nickname:    Answer:    Myname

Question 2:  Enter Team Members names:  Answer:  Your name, any other name as needed

Next Step: Upload three data files for the Myname project, in the right order. Verify.

Next Step: Click on "Generate Report"  Wait 30 seconds or so, a Report will be generated. Go to the Menu at the top of the software page and click on Report.


This concludes this lesson.

About Author

Mukul Mehta


Mukul Mehta has over 40 years of proven industrial experience in chemical , polymer, and plastics industry. Worked as a Sr. Manager, Statistics and Computer Aided Research for BF Goodrich Chemical, a Fortune 500 company, and then as a software entrepreneur, promoted "quantitative, predictive modeling in one minute or less as a mantra for R&D and New Product Development." Many multi-million dollar successes for dozens of Corporate R&D clients in chemical and pharma industry. Trained over 750 R&D chemists, engineers and managers to Speedup New Product Development through statistical design of experiments.

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}
>