Loading 5 year forecast
Download
1 / 16

Loading 5 Year Forecast - PowerPoint PPT Presentation


  • 136 Views
  • Uploaded on

Loading 5 Year Forecast. April 18, 2008. Loading 5 Year Forecast. Loading 5 Year Forecast. Complete your 5 year forecast on the Excel spreadsheet. Save the document in a CSV format. Select File >> Transfer from your Reflections main menu.

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 ' Loading 5 Year Forecast' - sammy


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
Loading 5 year forecast

Loading 5 Year Forecast

April 18, 2008



Loading 5 year forecast2
Loading 5 Year Forecast

  • Complete your 5 year forecast on the Excel spreadsheet.

  • Save the document in a CSV format.

  • Select File >> Transfer from your Reflections main menu.

  • Select the Show Host Files button in the File Transfer dialog box to see host files and directories. You will need to enter your userid and password when prompted. They will be the same as your reflections login. FTP the document into the appropriate directory for the user performing the upload. This directory sits on the district directory (Example Mapl.Jones).

  • After transfer is complete, close the File Transfer dialog box.


Transfer button

3. Make sure the Protocol is FTP and the Transfer type is ASCII. Select Transfer.

1. Select the directory where the file is located and select the file to transfer

2. Select where the file is to go on the host


Loading 5 year forecast3
Loading 5 Year Forecast

  • Select the appropriate database for importing the 5 year forecast.

    • Select EMIS

    • Select EMIS_SEL

    • Enter the number for XXP (Fiscal Year 2009, Reporting Period P)

    • Press the return key


Loading 5 year forecast4
Loading 5 Year Forecast

  • From your prompt, run the program called FFIMPORT and verify your column numbers match the forecast fields.If they match, execute the program. Your 5 year forecast will load allowing for viewing in the EMSFF option.Make sure your column numbers for the forecast fields match your spreadsheet going from left to right.


Make sure your column numbers for the forecast fields match your spreadsheet going from left to right.


Loading 5 year forecast5
Loading 5 Year Forecast your spreadsheet going from left to right.

  • Run the program called EMSFCN >> EMSFF

    • Validate your data using the appropriate function key.

      • If the validation is incorrect, it should give you the line number the system had an issue with. Check your 5 Year and determine where the problem is located, fix it, and re-import.

    • The program allows you to scroll up and down through the line numbers using your function keys to verify numbers.

    • If the validation is ok and your data looks correct, your 5 Year Forecast is ready to be submitted. Note: verify the forecast is the correct one. Sometimes an old 5 year is loaded accidently.

    • An example of the screen is below.


Loading 5 year forecast6
Loading 5 Year Forecast your spreadsheet going from left to right.

  • If you are submitting regular text for your assumptions, Run the program EMSFCN >> EMSFN (Select #3 Edit)

    • Clear the old data out of the editor that will no longer be needed. You can edit your notes using a combination of your <END> key with your left, right, up and down arrow keys to select data you wish to remove. Selecting the <Delete> key will delete the data from the editor. Note: Depending on the keyboard, these keys could be different.

    • Copy and Paste your notes into the editor.

    • You can edit your notes using a combination of your <END> key and left, right, up and down arrow keys to select data you wish to remove. Selecting the <Delete> key will delete the data from the editor. Note: Depending on the keyboard, these keys could be different.

    • Use the key combination <CTRL>Z to Save the notes


Loading 5 year forecast7
Loading 5 Year Forecast your spreadsheet going from left to right.

  • If you are submitting a PDF file for your notes, PDF files should have the naming convention DISTRICT_NAME-IRN, where all parts of the name are separated with an underscore followed by a dash and the IRN, and contain no spaces, and should be e-mailed to [email protected] Those districts using this method will also need to include in the EMIS assumption submission (Refer to number 9 above) the phrase:  "Please visit the Ohio Department of Education website at  “ftp://ftp.ode.state.oh.us/geodoc/5-yrForecast/” to see the complete forecast assumptions file." 


Loading 5 year forecast8
Loading 5 Year Forecast your spreadsheet going from left to right.

  • Run EMSRDET

    Note: Please work with your EMIS Coordinator for running this step.

    • Enter the correct Fiscal Year

    • Enter the correct Period to submit. For 5 year forecasts, the period is always ‘P’.

    • Select Continue.

    • This will create a sequential file to be submitted to ODE and a txt file showing any errors.


Loading 5 year forecast9
Loading 5 Year Forecast your spreadsheet going from left to right.

  • Run EMS_SUBMIT (Example is below)

    Note: Please work with your EMIS Coordinator for running this step.

    Have you completed all the necessary steps for an EMIS submission? (Y/N <N>) y

    Enter Fiscal Year to submit: 09

    Enter Report Period to submit: P

    Enter DataBase Code to submit: 09P


Loading 5 year forecast10
Loading 5 Year Forecast your spreadsheet going from left to right.

  • This program places the five year into the queue that submits the 5 year forecast and other EMIS information to ODE. This queued information is sent out on Thursday at 5:00PM to ODE and should appear on their website the next week.

  • In the following week, check and verify the ODE web site for 5 year forecasts contains the correct up to date forecast with assumptions.

  • Place a ticket in helpdesk letting TCCSA know you have uploaded and submitted the 5 year forecast. If you have any problems, contact TCCSA for assistance.


  • ad