A Visual Follow-Along Guide to the Instructions of the
This presentation is the property of its rightful owner.
Sponsored Links
1 / 32

A Visual Follow-Along Guide to the Instructions of the NBTA Modular Hotel RFP PowerPoint PPT Presentation


  • 66 Views
  • Uploaded on
  • Presentation posted in: General

A Visual Follow-Along Guide to the Instructions of the NBTA Modular Hotel RFP. This is a sample of how one of the text files that the hotel or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.

Download Presentation

A Visual Follow-Along Guide to the Instructions of the NBTA Modular Hotel RFP

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


A visual follow along guide to the instructions of the nbta modular hotel rfp

A Visual Follow-Along Guide to the Instructions of the

NBTA Modular Hotel RFP


A visual follow along guide to the instructions of the nbta modular hotel rfp

This is a sample of how one of the text files that the hotel or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.

In the next steps, we will show you how to make this into workable data for you.


A visual follow along guide to the instructions of the nbta modular hotel rfp

From your email, RIGHT

CLICK on your MOUSE,

highlight ‘SAVE AS’ and turn

the‘TXT” file into a ‘CSV’ file


A visual follow along guide to the instructions of the nbta modular hotel rfp

Put the file in your computer,

at the end of the file name

enter “.csv” at the end of the file

name. This will change the file

type on to your computer.


A visual follow along guide to the instructions of the nbta modular hotel rfp

Go to where you save the file on

your computer. You’ll see the file

with a ‘excel’ logo with an ‘a’ --

double click on the file with your

mouse to open the file


A visual follow along guide to the instructions of the nbta modular hotel rfp

This is now the same data

file, placed separated

into an excel file format.


A visual follow along guide to the instructions of the nbta modular hotel rfp

WARNING! CRITICAL STEP!

Click on “DATA” and from the drop

down menu select “Sort” to rearrange

the data by the first column.


A visual follow along guide to the instructions of the nbta modular hotel rfp

The SORT BOX will appear and

sort by “Column A”, ASCENDING,

with “NO HEADER ROW” selected.

Click on “OK”


A visual follow along guide to the instructions of the nbta modular hotel rfp

Notice that “COLUMN A”

is now sorted numeric ascending.

WARNING! PLEASE REPEAT

THIS STEP FOR EVERY

MODULE. THIS WILL BE A KEY

IN CREATING THE SUMMARY


A visual follow along guide to the instructions of the nbta modular hotel rfp

Click on ‘File’ and highlight

‘Save’ to save the file in

the new format.


A visual follow along guide to the instructions of the nbta modular hotel rfp

A warning screen will pop-up to

ensure you want to replace the

existing file. Click on “YES”

to complete the save process.


A visual follow along guide to the instructions of the nbta modular hotel rfp

Now, you’re ready to paste the first part of the

data into the Master Template.

Click on ‘File’ and highlight ‘OPEN’. Find the file

where you have your Master Template saved.

Highlight the file and open the file.


A visual follow along guide to the instructions of the nbta modular hotel rfp

Your Master Template is now open


A visual follow along guide to the instructions of the nbta modular hotel rfp

To get back to the data file, click on ‘WINDOW’

and on the bottom you’ll see all the open files

that you have open in excel. Click highlight

the data file name and hit enter.


A visual follow along guide to the instructions of the nbta modular hotel rfp

You’re now back at your data file. Highlight

the data rows that you would like to bring

over to the Master Template. This can be

done by highlighting the ‘Row Number’.

Once you have all the rows highlighted,

‘RIGHT CLICK’ on the mouse. Highlight

‘Copy’ and then move back to your template.


A visual follow along guide to the instructions of the nbta modular hotel rfp

To move back to the Master Template,

click on ‘Window’ and then highlight

the Master Template and hit enter.


A visual follow along guide to the instructions of the nbta modular hotel rfp

Click on the first cell under the

‘PROPCODE’, now RIGHT CLICK

on the mouse and highlight ‘PASTE’


A visual follow along guide to the instructions of the nbta modular hotel rfp

And the data copied will

appear on the Master Template


A visual follow along guide to the instructions of the nbta modular hotel rfp

REPEAT STEPS.

SORT DATA FIRST

WARNING! CRITICAL STEP!

Click on “DATA” and from the drop

down menu select “Sort” to rearrange

the data by the first column.


A visual follow along guide to the instructions of the nbta modular hotel rfp

The SORT BOX will appear and

sort by “Column A”, ASCENDING,

with “NO HEADER ROW” selected.

Click on “OK”


A visual follow along guide to the instructions of the nbta modular hotel rfp

COPY THE DATA.

Highlight the data rows that you would like to bring

over to the Master Template. This can be done

by highlighting the ‘Row Number’.

Once you have all the rows highlighted,

‘RIGHT CLICK’ on the mouse. Highlight

‘Copy’ and then move back to your template.


A visual follow along guide to the instructions of the nbta modular hotel rfp

WARNING! Please look at the TABS below and

ensure you paste each module into the correct

section of the template.

OOPS! Make a mistake? It’s okay, just highlight

the data and cut and paste it in the right module.


A visual follow along guide to the instructions of the nbta modular hotel rfp

CREATING A SUMMARY.

Now that you’ve got all the data in each in the

modules. You want to just see the data that will

be the most meaningful to you.

STEP ONE. Create a New Worksheet.

Click on ‘INSERT’ and highlight ‘Worksheet’


A visual follow along guide to the instructions of the nbta modular hotel rfp

STEP TWO. Rename the Worksheet.

Click on ‘FORMAT’ and highlight ‘Sheet’ and

highlight ‘Rename’ and then you’ll see the

‘Sheet1’ highlighted. Hit the “Delete” button and

Type in ‘SUMMARY’. Hit enter.


A visual follow along guide to the instructions of the nbta modular hotel rfp

Notice that the new worksheet has been

renamed “SUMMARY”


A visual follow along guide to the instructions of the nbta modular hotel rfp

  • STEP THREE. Pulling the Fields Over to the Summary

  • To bring over the fields you want in the Summary sheet:

  • Click on cell A1 in the “Summary” worksheet

  • Go up to the formula bar and click on the “=”

  • Next, click on the worksheet tab that you want to link to

  • (i.e., if you want to bring property name into your summary

  • sheet, click on the Core tab)


A visual follow along guide to the instructions of the nbta modular hotel rfp

STEP THREE. Pulling the Fields Over to the Summary

Next, click on the worksheet tab that you want to link to

(i.e., if you want to bring property name into your summary

sheet, click on the Core tab)


A visual follow along guide to the instructions of the nbta modular hotel rfp

STEP THREE. Pulling the Fields Over to the Summary

Hit the “Enter” key (or click “OK”) and you will be brought back to the

“Summary” sheet and the header will be populated


A visual follow along guide to the instructions of the nbta modular hotel rfp

Now that you have all the fields pulled over, you’re ready to pull

over the data into the spreadsheet.


A visual follow along guide to the instructions of the nbta modular hotel rfp

Highlight the first header row by clicking on “Row 1”.

RIGHT CLICK on the mouse and highlight COPY.


A visual follow along guide to the instructions of the nbta modular hotel rfp

Highlight all the rows that would like to have the data populated.


A visual follow along guide to the instructions of the nbta modular hotel rfp

Right click on PASTE and all the data will appear. And now, you’re

ready negotiate a program.


  • Login