{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Coversheet","Connect Information","Template","Data Input","Staging & Submission","Mass Upload Instructions","Important Points To Remember"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":48,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Coversheet","index":0,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"ExcelToCI"]
[null,null,"The purpose of this workbook is to upload data from Excel into PeopleSoft using the Component Interface to execute business logic for each transaction. This source workbook contains both worksheets and Excel VBA code modules.  The Worksheets can be copied to other workbooks for distribution without copying the code modules."]
[]
[null,"Process:"]
[null,"1)","Connection Information sheet: The information provided on this sheet is required to create a new template or submit data to the database. You will need to specify environment information as well as information in regard to how each transaction should be handled. The Action will be filled in automatically."]
[]
[null,"2)","Template sheet: Here you create the template that you are going to use. The template is based upon the structure of a Component Interface on the PeopleSoft database."]
[null,null,"2.1. New Template: When prompted, enter the name of your PeopleSoft User ID, password, and the Component Interface you wish to use. The connect information previously provided is used to retrieve the PeopleSoft Component Interface properties. The Component Interface structure is displayed graphically."]
[null,null,"2.2. Manipulate Template: Here input cells are selected for inclusion on the Data Input and Staging & Submisson sheets.  The purpose of each button provided to allow manipulation of the template is more fully described by mousing over the button on the toolbar."]
[null,null,"2.3. New Data Input: This button copies the selected input cells into the Data Input sheet. The Data Input sheet becomes active, and you will be prompted before the structures and data on that sheet are deleted."]
[]
[null,"3)","Data Input sheet: Here you enter data values for submission to the PeopleSoft database."]
[null,null,"3.1. Stage Data for Submission: The data entered on the Data Input sheet is then staged in hierarchical form in preparation for submission to the database."]
[]
[null,"4)","Staging & Submission sheet: The last step is to format the data and submit to the database."]
[null,null,"4.1. Submit Data: This submits the data to the database.  Your PeopleSoft User ID and Password will be required. Each row submitted is marked with the reply from the database which will either be OK, Warning, or Error."]
[null,null,"4.2. Post Results: This posts the status for each row submitted to the database on the Data Input sheet so that data in a status of error can be corrected and resubmitted."]

{"sheet":"Connect Information","index":1,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,"Web Server Machine Name:","finance.yorku.ca"]
[null,"Protocol:"]
[null,"HTTP Port:"]
[null,"Portal:","EMPLOYEE"]
[null,"PeopleSoft Site Name:","FIN92PRD"]
[null,"Node:","ERP"]
[null,"Language Code:","ENG"]
[]
[null,"Chunking Factor:","40"]
[null,"Error Threshold:","3000"]
[]
[null,"Action:","CREATE"]
[]
[]
[]
[null,"Y_LED_BUDG_CNTL_CI"," "]

{"sheet":"Template","index":2,"n_rows":12,"n_cols":22,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
["Y_LED_BUDG_CNTL_CI"]
[]
[null,null,"Collection","Y_LED_BUDG_CNTL_CI","Y_LED_BUDG_CNTL_CI","Y_LED_BUDG_CNTL_CI","Y_LED_BUDG_CNTL_CI","Y_LED_BUDG_CNTL_CI","Y_LED_BUDG_CNTL_CI","Y_LED_BUDG_CNTL_CI","Y_LED_BUDG_CNTL_CI","Y_LED_BUDG_CNTL_CI","Y_LED_BUDG_CNTL_CI","Y_LED_BUDG_CNTL_CI","Y_LED_BUDG_CNTL_CI","Y_LED_BUDG_CNTL_CI","Y_LED_BUDG_CNTL_CI","Y_LED_BUDG_CNTL_CI","Y_LED_BUDG_CNTL_CI","Y_LED_BUDG_CNTL_CI","Y_LED_BUDG_CNTL_CI"]
[null,null,"Property","BUSINESS_UNIT","LEDGER","FISCAL_YEAR","Y_BUDGET_LVLDESC","ACCOUNT","FUND_CODE","OPERATING_UNIT","PRODUCT","PROGRAM_CODE","CLASS_FLD","BUDGET_PERIOD","CURRENCY_CD","ACCOUNTING_PERIOD","POSTED_TOTAL_AMT","POSTED_BASE_AMT","POSTED_TRAN_AMT","BASE_CURRENCY","NOTES_1000"]
[null,null,"Record Type","000","000","000","000","000","000","000","000","000","000","000","000","000","000","000","000","000","000"]
[null,null,"Field Type","CHARACTER","CHARACTER","NUMBER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","NUMBER","SIGNED_NUMBER","SIGNED_NUMBER","SIGNED_NUMBER","CHARACTER","CHARACTER"]
[null,null,"Field Length","5","10","4","3","10","5","8","6","5","5","8","3","3","23.3","23.3","23.3","3","254"]
[null,null,"Key / Required","Y/R","Y/R","Y/R"," / ","Y/ ","Y/ ","Y/ ","Y/ ","Y/ ","Y/ ","Y/ ","Y/ ","Y/R"," / "," / "," / "," / "," / "]
[null,null,"Sequence","1","2","3","18","4","5","6","7","8","9","10","11","12","13","14","15","16","17"]
["Status","Line No","Record Type","Business Unit","Ledger","Fiscal Year","Forecast Level","Account","Fund Code","Cost Centre","Activity","Time","Location","Forecast Period","Currency Code","Accounting Period","Posted Total Amount","Posted Base Currency Amount","Posted Transaction Amount","Base Currency","Comments"]
["Template",null,"000","","","",null,"","","","","","","","","","","","","","",""]

{"sheet":"Data Input","index":3,"n_rows":4,"n_cols":12,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
["Y_LED_BUDG_CNTL_CI"]
["Record Type 000","Record Type 000","Record Type 000","Record Type 000","Record Type 000","Record Type 000","Record Type 000","Record Type 000","Record Type 000","Record Type 000","Record Type 000","Record Type 000"]
["Business Unit","Ledger","Fiscal Year","Forecast  Level","Account","Fund Code","Cost Centre","Activity","Time","Location","Posted Transaction Amount","Comments"]

{"sheet":"Staging & Submission","index":4,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
["Y_LED_BUDG_CNTL_CI"]
[]
[]
[]
[]
[]
[]
[]
[]
["STOP"]

{"sheet":"Mass Upload Instructions","index":5,"n_rows":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Mass Forecast Upload Instruction:"]
[]
["Steps:"]
[1,"Go to Data Input worksheet"]
[]
[2,"Enter Data as per column headings (Tips for the following 3 major column headings):"]
[null,"i) Enter Business Unit as YORK in Column A"]
[null,"ii) Enter one of the following Forecast Ledgers (FCASTCURR,  FCASTFIN,  FORECAST1) for each cost centre in Column B "]
[null,"iii) Enter Forecast Level as either CC or ATL in Column D"]
[]
[3,"Click on the Add-Ins Tab, if you are using Excel 2010  (Note: Skip this step if you are using Excel 2003)."]
[]
[4,"Click the Stage Data For Submission Button on top left hand corner of worksheet "]
[null,"This will bring you to the Staging and Submission worksheet"]
[]
[5,"Click on the Submit Data Button on the top left hand corner of the worksheet"]
[]
[6,"Enter your Passport York User ID & Password.  Click on OK"]
[]
[7,"Click on Post Results Button from the Staging & Submission worksheet to transfer all status into the Data Input worksheet."]
[]
[8,"Review the upload status (i.e. OK or Error)"]
[]
[9,"Select rows with Error Status by using the filter function"]
[]
[10,"Correct all errors in the Data Input worksheet"]
[]
[11,"Repeat Step 4 to 8 to ensure all rows now have OK status"]
[]
[12,"Review forecast data from the Forecast View Report"]

{"sheet":"Important Points To Remember","index":6,"n_rows":36,"n_cols":1,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Mass Forecast Upload Template --- Major Points (Summary):"]
[]
["1.        Download the Mass Forecast Upload Template from the Finance website (http://www.yorku.ca/finance/forms.htm).  Save a copy into your own computer or share drive of your department for future usage."]
[]
["2.        Do not open more than one Mass Forecast Upload Template at the same time.  Otherwise, the template will be corrupted and the forecast data will not be uploaded into PeopleSoft."]
["           If you accidentally open more than one Mass Forecast Upload Template, you should close all Excel application first before re-opening a new (blank) Mass Forecast Upload Template."]
[]
["3.       All forecast data entries, including entries to correct errors lines, should be entered in the Data Input worksheet."]
[]
["4.       Use Post Results button to post the status for each row in the Data Input worksheet."]
[]
["5.       Do not change any of the 6 worksheet names from the Mass Forecast Upload Template because Visual Basic Programming is embedded into these worksheets.  Any name change of the 6 worksheets "]
["          can corrupt the whole file for uploading.  "]
[]
["6.       In the Data Input worksheet, you should enter YORK in the SetID column.  If the SetID is missing, the system will not upload any forecast rows underneath that missing SetID row entry."]
[]
["7.       Do not have leave any empty rows in between forecast lines.  Otherwise, the system will not upload any forecast amounts and comments that are entered under that empty row.  "]
[]
["8.      Any account with zero forecast amount can be entered as follows:"]
["a)      Entered as 0 "]
["b)      Leave the cell empty"]
["c)      Place a dash (-) in the Forecast Amount column"]
[]
["9.      If the Fund Code – Cost Centre – Account combination (e.g. 200 – 231000 – 301000 Office Supplies) shows up more than once in the Mass Forecast Upload Template (e.g. $100 in row 5 and $200 in row 8), "]
["         then the system will only accept the last Forecast Amount ($200 in this example) and Comment."]
[]
["10.    Ensure to select the correct Forecast Ledger (Column B of Data Input Tab) that the forecast amount for each cost centre.  There are four Forecast Ledgers available:"]
["         FCASTCURR (Current or Working Forecast Ledger)"]
["         FCASTFIN (Finance Forecast Ledger)"]
["         FORECAST1 (Academic Divisional Submission 1 Forecast Ledger)"]
[]
[]
["11.    Do not click the Stage Data for Submission button if there are any direct linkages with another Excel Spreadsheets.  If you need to copy any information from another Excel working files into the Mass "]
["        Forecast Upload Template, please ensure to use Copy → Paste Special → Values function to eliminate all formulas and linkages before clicking the Stage Data for Submission button."]
[]
["12.   Use the Filter function to select any rows with Error Status.  Correct all errors in the Data Input worksheet.  Re-submit those corrected rows for uploading.  Review all forecast data from the Forecast View Report."]