Agmt12 Daly City IT - Laserfiche WebLink

Browse Search

SERVICES TO BE PROVIDED: Develop an Excel 2010 application that allows the user to select department budget spreadsheets in the format in Exhibit A and extract the data to populate the highlighted columns in the IFAS Budget spreadsheet in Exhibit B. The application will have the following workflow: 1. Create a folder (name and location unimportant). 2. Save the "IFAS Budget.xlsm" in the folder created in step 1. 3. Create a folder under the folder created in step 1(name unimportant). 4. Save the individual department budget spreadsheets in this folder. 5. Open the spreadsheet "IFAS Budget.xlsm." 6. Go to the "configuration" worksheet. 7. Push the button � located approximately in cell C3. Steps 7 and 8 only need to be run the first time or if you change the location of the department worksheets. 8. It will open a folder selection dialog box. Traverse to and select the folder you created in step 3 where you put the individual department worksheets and push the ok button. This will also save the location of the files for future use. You will see the location in cell C2. 9. Go to the "BATCH" worksheet. Process Department worksheets 10. Push the button located approximately in cell N1. 11. It should open a file selection dialog box showing the individual department files you saved in step 4. 12. Select one or more of the files by hovering over them and clicking the checkbox on the left of each file you wish to process. The checkbox appears when you hover over the file name. Once you've selected the files push the "OK" button at the bottom of the dialog box. 13. You will see that a new worksheet is created titled, "Processed_mmddyyyy." For each file you selected in step 12 you will get a dialog box saying it is processing it. The application will save each day's processing in the IFAS spreadsheet, allowing the user to run it multiple days without overwriting previous runs. If a user runs it multiple times in one day however, it will prompt the user if he/she wants to overwrite the previous run of the day. S:\Clients\External\Daly City\ITSvc-Daily City IFAS project 2012 . docx 7 081911