A Visual Follow-Along Guide to the Instructions of the
Download
1 / 32

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


  • 102 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' A Visual Follow-Along Guide to the Instructions of the NBTA Modular Hotel RFP' - clover


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

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.


From your email, RIGHT or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.

CLICK on your MOUSE,

highlight ‘SAVE AS’ and turn

the‘TXT” file into a ‘CSV’ file


Put the file in your computer, or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.

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.


Go to where you save the file on or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.

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


This is now the same data or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.

file, placed separated

into an excel file format.


WARNING! CRITICAL STEP! or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.

Click on “DATA” and from the drop

down menu select “Sort” to rearrange

the data by the first column.


The SORT BOX will appear and or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.

sort by “Column A”, ASCENDING,

with “NO HEADER ROW” selected.

Click on “OK”


Notice that “COLUMN A” or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.

is now sorted numeric ascending.

WARNING! PLEASE REPEAT

THIS STEP FOR EVERY

MODULE. THIS WILL BE A KEY

IN CREATING THE SUMMARY


Click on ‘File’ and highlight or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.

‘Save’ to save the file in

the new format.


A warning screen will pop-up to or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.

ensure you want to replace the

existing file. Click on “YES”

to complete the save process.


Now, you’re ready to paste the first part of the or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.

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.


Your Master Template is now open or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.


To get back to the data file, click on ‘WINDOW’ or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.

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.


You’re now back at your data file. Highlight or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.

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.


To move back to the Master Template, or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.

click on ‘Window’ and then highlight

the Master Template and hit enter.


Click on the first cell under the or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.

‘PROPCODE’, now RIGHT CLICK

on the mouse and highlight ‘PASTE’


And the data copied will or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.

appear on the Master Template


REPEAT STEPS. or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.

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.


The SORT BOX will appear and or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.

sort by “Column A”, ASCENDING,

with “NO HEADER ROW” selected.

Click on “OK”


COPY THE DATA. or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text 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.


WARNING! Please look at the TABS below and or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.

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.


CREATING A SUMMARY. or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.

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’


STEP TWO. Rename the Worksheet. or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.

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.


Notice that the new worksheet has been or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.

renamed “SUMMARY”


  • STEP THREE. Pulling the Fields Over to the Summary or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.

  • 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)


STEP THREE. Pulling the Fields Over to the Summary or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.

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)


STEP THREE. Pulling the Fields Over to the Summary or hotel company will send you via email. This is the raw data. This is called an “ASCII Comma Quote Delimited Text File.

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

“Summary” sheet and the header will be populated


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

over the data into the spreadsheet.


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

RIGHT CLICK on the mouse and highlight COPY.




ad