magnify
Home Topic XLOne scheduler file names and tab names

XLOne scheduler file names and tab names

Home Forums XLOne XLOne scheduler file names and tab names

This topic contains 0 replies, has 1 voice, and was last updated by  Penny Hamlett 3 years, 7 months ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #674

    Penny Hamlett
    Participant

    This post is to share some excel formulas that I use to create file and tab names on xlone scheduler created spreadsheets.
    In this example I have a number of DRP reports that I run every hour via the DP. It only takes takes about 3 minutes to run all 6 reports. Each report generates its own xlone spreadsheet and each time the scheduler is run a new tab with the current time is added to the current days spreadsheet.
    As the formula changes the file name daily a new spreadsheet is created for each day.
    This gives me a snapshot of key account balances and document file status progressivly during a day.
    In a recent DRP test I was able to use these files to determine the data recovery point of the recovery simulation.
    Please refer to the attached document for screenshots.

    • This topic was modified 3 years, 7 months ago by  Jamie Scott.
    Attachments:
    You must be logged in to view attached files.
Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.