680 likes | 1.03k Views
Relius Government Forms 5500 Advanced Topics. RGF 5500 Advanced Topics. Tom Hunsinger You can download this presentation from: ftp://64.34.162.102/http_files/RGF5500Advanced.ppt. Welcome!. RGF 5500 Advanced Topics. Continue to listen to the voice call
E N D
Relius Government Forms 5500 Advanced Topics
RGF 5500 Advanced Topics Tom Hunsinger You can download this presentation from: ftp://64.34.162.102/http_files/RGF5500Advanced.ppt Welcome!
RGF 5500 Advanced Topics • Continue to listen to the voice call • Try to login again to the meeting using your browser • For more help, call Relius Training Online Meeting Support at (800) 326-7235 extension 1189 If you lose the meeting connection:
RGF 5500 Advanced Topics • Spreadsheet Data Import • Electronic Filing What we will cover today:
RGF 5500 Advanced Topics • Format spreadsheet • Create link map • Run spread import utility Spread Import Steps:
RGF 5500 Advanced Topics Schedule SSA
RGF 5500 Advanced Topics Schedule SSA (page 2)
RGF 5500 Advanced Topics • Lotus 123 (*.wk1, *.wk3, or *.wk4) • MS Excel (*.xls or *.xlw) Spreadsheet file types supported:
RGF 5500 Advanced Topics Sample Spreadsheet:
RGF 5500 Advanced Topics • File created in RGF 5500 • Directs the data from the cells of the spreadsheet into the fields of the form What is a link map?
RGF 5500 Advanced Topics Schedule SSA
RGF 5500 Advanced Topics Schedule SSA
RGF 5500 Advanced Topics Running the Spread Import Utility
RGF 5500 Advanced Topics Importing Into Repeating Pages
RGF 5500 Advanced Topics There are two other ways to import data: • ASCII Text File Import • XML Import
RGF 5500 Advanced Topics Electronic Filing