Tutorial: Create and Deploy a New web App

This tutorial will walk you through creating a simple mortgage analyzer web app from an Excel spreadsheet.  You can access the spreadsheet we're using here, and try the actual mortgage analyzer web app we've built here.  Feel free to download the spreadsheet and try it yourself!

1.

Upload your spreadsheet

 

Go to app.nexs.com and click the "Create a new App button.

 
 

Fill in the Form. Give your application a name and choose an Excel .xlsx file to upload, then click "Next" to begin creating your app.

 
 

You will see this screen which shows your spreadsheet contents.  You're now ready to begin creating the views that will define your web app.  A "view" is a block of cells in your spreadsheet that your app users are allowed to see.  You can make some cells within a view editable, which means app users can change their values and see the calculated results, just as they would on your actual spreadsheet.  For convenience, we've colored the cells we want to make editable yellow.

 

2.

Configure your new web app.

 

Next, click the OK button in the upper right to create your first view.

 
 

Give your view a name. Our first view in this example will be the section at the left containing the yellow cells.  We'll call this view "Mortgage variables".

 
 

Set the cells to put in this view. To set a range, first click on the first cell in a cell range.

 
 

Click on the opposite corner of the range to select a range of cells.

 
 

Press the OK button to set the view boundary.

 
 

This defines a range of viewable cells, and the range becomes outlined.

 
 

Next we need to set the editable cells. Start by selecting the first yellow cell in the upper section of the view.

 
 

Select the last yesllow cell in the range.

 
 

Press the OK button to set the highlighted cells as editable

 
 

The editable cells become highlighted in green.

 

 

 

 

 

Repeat the procedure to add a second block of editable cells. We have now defined a view along with its editable cells.

 
 

Create a second view to show the results. Go under the View menu and select "Create New View".

 
 

Give the view a name. Let's call it "10 year analysis".

 
 

Repeat the procedure to set the viewable range of cells. Start by selecting cell E6 (the upper left corner of the range of cells we want users to view).

 
 

Click on cell J17 to select the entire range.

 
 

Press the OK button to set the view boundary.

 
 

We have defined our second view. This view won't have any editable cells in it - it will simply be used to display the results of changing the mortgage variables. Now we can press the "Preview your App" button to see what it will look like to users.

 
 

This is the app preview. You can see there are two tabs, one called "Mortgage variables" and one called "10 year analysis" for the two views.

 
 

Click on one of the editable cells to change its value.

 
 

Notice that the rest of the cells update with the new calculated results.  (Change a yellow cell and note the payment.)

 
 

On the Result tab notice the result values, calculated from our inputs on the first view.

 
 

Press the back button on your browser. Then go to the next step by pressing the "Configure App Access" button.

 
 

Notice the three options: Open Access, Individual Login, and Team Login.

 
 

Open Access lets anyone with the link access the spreadsheet. If you choose this option, there are no further options to configure.

 
 

Individual login only allows the individuals listed access to the app, and gives each user their own copy. Enter users' email addresses here to give them access

 
 

Team login allows the listed users access, but gives everyone access to the same copy of the app, allowing users to share data. Enter users' email addresses here to give them access.

 
 

Press Review and Deploy to go to the review page where you can see the details of your app before it's deployed and published.

 

3.

Share it.

 

Once your app is published, you can take the LIVE link (highlighted in green) and share it with others so they can use your new app.