1 / 25

BMS Data Integration and Consolidation

BMS Data Integration and Consolidation. Create Folder at Drive C:. Name of folders to be created: BMS-ALLOTMENT BMS-UTILIZATION BMSAllData. C:BMS-ALLOTMENT C:BMS-UTILIZATION C:BMSAllData. Exporting and keeping of Excel Files from each Implementing Unit BMS . Export data to Excel.

charla
Download Presentation

BMS Data Integration and Consolidation

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. BMSDataIntegrationandConsolidation

  2. CreateFolderat Drive C: Name of folders to be created: • BMS-ALLOTMENT • BMS-UTILIZATION • BMSAllData C:\BMS-ALLOTMENT C:\BMS-UTILIZATION C:\BMSAllData

  3. Exporting and keeping of Excel Files from each Implementing Unit BMS

  4. Export data to Excel. Step 1 Step 2 Utilizations Allotments Step 3 Step 4

  5. SAVE ASto C:\BMS-UTILIZATION folder.Filename:Name of Division/School

  6. SAVE ASto C:\BMS-ALLOTMENT folder.Filename: Name of Division/School

  7. Exported Excel FilesSaved at C:\BMS-ALLOTMENT folder Names of implementing units including the division office proper

  8. Exported Excel FilesSaved at C:\BMS-UTILIZATION folder Names of implementing units including the division office proper

  9. Integration of Excel Files

  10. Two (2) Excel FilesIntegrator of all BMS excel files Filenames:

  11. Integrate data fromC:\BMS-UTILIZATION folder 1. Open this excel file: Integrator – BMS-UTILIZATION Click this button.

  12. Integrate data fromC:\BMS-UTILIZATION folder Output: Delete column A

  13. Integrate data fromC:\BMS-UTILIZATION folder Output: If you noticed, there is no heading. The next step is to copy the heading from one of exported excel files (C:\BMS-UTILIZATION folder). Insert row at first row (A1)

  14. Integrate data fromC:\BMS-UTILIZATION folder Output: Copy columns A1:T1 from one exported excel file and Paste here at A1

  15. SAVE TOC:\BMSAllData folder Output: Save As to C:\BMSAllData folder. Use exactly this filename:tempTableSave as Type: Excel Workbook (*.xlsx)

  16. Integrate data fromC:\BMS-ALLOTMENT folder 1. Open this excel file: Integrator – BMS-ALLOTMENT Click this button.

  17. Integrate data fromC:\BMS-ALLOTMENT folder Output: Delete column A

  18. Integrate data fromC:\BMS-ALLOTMENT folder Output: If you noticed, there is no heading. The next step is to copy the heading from one of exported excel files (C:\BMS-ALLOTMENT folder). Insert row at first row (A1)

  19. Integrate data fromC:\BMS-ALLOTMENT folder Output: Insert row at first row (A1)

  20. Integrate data fromC:\BMS-ALLOTMENT folder Output: Copy columns A1:X1 from one exported excel file and Paste here at A1

  21. SAVE TOC:\BMSAllData folder Output: Save As to C:\BMSAllData folder. Use exactly this filename:tblAllRAODataAnnexA1 Save as Type: Excel Workbook (*.xlsx)

  22. Contents ofC:\BMSAllData folder tblAllRAODataAnnexA1 tempTable

  23. CONSOLIDATEDATA

  24. Consolidate Data 1. Open this Access file: Consolidator Access File Step 3 Step 4 Step 1 Step 2

  25. Thank you!

More Related