Yes, it's Rocket Science!

How to Use

Purpose

I created Rocketsheet to make recording and analyzing launch data easier. Rocketsheet is quick to learn and simple to navigate. Gone are the days of flipping through endless pages of data sheets, now you and your team can view all launches or just one with the click of a button.

How to Install and Customize Rocketsheet for Your Team

Explanation of Scripts on Rocketsheet

There are two functions in the script editor, one that will create a new launch sheet and another that will save the launch data and paste it into the Launches sheet.

The method onEdit(e) will first check to see if the sheet that was edited was the 'Home' sheet. If so, the method will then check if the cell that was edited is the menu cell, or B7. If that is also true, the method will then set the value in the cell to the text "working..." and will call the method createLaunch(). The method createLaunch() sets up a new spreadsheet using the Launch Template and sets the date to the current day. Once the method createLaunch() is done, the script will go back to onEdit(e) and will clear the menu cell so that once again it is empty.

However, if the spreadsheet edited was not the Home sheet, the script will instead check to see if the sheet edited has a cell on F1 with the text "Menu". If true, the script will then call the saveLaunchData(sheet) method. saveLaunchData(sheet) uses the passed in sheet to insert a column into the Launches sheet, where it will then copy over the data that was inputed in the launch sheet into the Launches sheet. The for loop will take all the member's names and put them into a comma separated list.

How to Edit the Script

If you want to add or remove the number of data entries in your Launch Template, do so on the Launch Template sheet, then click on "Script editor" under Tools in the menu bar and adjust the range that saveLaunchData(sheet) will copy. This is to make the transfer of data from the individual launch sheet to the Launches sheet accurate. More specifically, change the variables sourceRange and destinationRange to get the correct range of data entries.