1 Getting Started with Battery Life Calculator

To get started with Battery Life Calculator tool,
  1. Download the attachment zip file containing AT07995_Battery_life_calculator.xlsm file.
  2. Open the file using Microsoft® Office 2013.
  3. Click on Enable Content to allow the execution of Macros in excel sheet.
  4. File > Options > Trust Center > Trust Center Settings > Macro Settings > Enable All Macros.
  5. Click the Microsoft Excel® spreadsheet window in Task Bar to open Battery life calculator tool.
Figure 1-1. Battery Life Calculator Tool
To view the corresponding Visual Basic code,
  1. Close Battery life Calculator window.
  2. Select the AT07995_Battery_life_calculator excel sheet.
  3. Press ALT + F11.
  4. Go to Forms >AT07995.
Figure 1-2. Battery Life Calculator Visual Basic Editor

Limitations:

  • Other Excel spreadsheets cannot be opened, simultaneously.
  • For editing the Excel sheet power consumption numbers, the battery life calculator window must be closed.
  • If GUI window is closed, only option to re-invoke battery life calculator is to restart.
  • Only common scenarios are considered in this battery life calculator example.
  • This tool has only been validated on Microsoft Office 2013.