Become a Guru!

FAQs GURU

Run!AzTech Ribbon FAQs

1. I successfully installed Run!AzTech, but I do not see the Run!AzTech Ribbon / Tab. Why?
2. Why does my toolbar not work when I click on a button?
3. Why do some macros not work (Stats, Links, OOS, etc.)?
4. My processes run slow, how can I speed them up?
5. How do I get rid of multiple File, Edit, and View toolbars?
6. What is included in a super user license?
7. How do I resolve an error when running OOS?
8. How do I find the Critical Path for a given milestone?
9. Why am I unable to export from MSP to Excel?
10. Can Run!AzTech compute Critical Path Length Index (CPLI)? DCMA CPLI?
11. What is the formula used for Baseline Execution Index (BEI)?
12. Why does MS Project 2003 crash under Windows Vista?
13. How do I find the driving predecessor for a given Task?
14. What does Error 53 mean when I try to export Maps?
15. Why am I getting Error code 1101?
16. Can I use Run!AzTech Template for MSP with other programs?
17. How do I convert hours or weekdays?
18. Error Accessing File. Network Connection May Have Been Lost.
19. Why don't any of the function (macros) work when I open MSP?
20. What's the difference between AzTech Stats and the DCMA 14 Point Assessment?
21. Stats seem to exclude tasks on the Status Date, what can I do?
22. Why do the Stats counts appear incorrect?
23. I ran a ribbon function, but nothing appears to be happeningl is there a problem?
24. How do I install Run!AzTech? Do I still need an AzTech Excel add-in and .txt file?

1. Is there any preferable way to delete rows in AutoVAR?
2. Is it ok to increase the font size in the VAR_Data Tab fields (the whole table)?
3. Why is automatic calculation turned off?
4. Even with automatic calculation turned off, my large AutoVAR file is still calculating very slowly. Why is this?
5. Can I have empty rows at the bottom of my data range?
6. Is the copy formula function based on the number of rows of data?
7. The copy formula function should not change my current and cum data, right?
8. When I download the AutoVAR file, it opens with macros disabled. What am I doing wrong?



Several possibilities may be the reason why the Run!AzTech tool is not appearing. The following steps walk a user through several diagnostics to resolve the issue:
  1. Open MS Project 2010 / 2013. Navigate to the File drop down
  2. Look for the AzTech Run!AzTech Add-In. Highlight this Add-In by single clicking on it, and ensure the radio button to the left of the Add-In contains a check mark. If not, please select it. Further, if you receive the following error (highlight with a red box below, in step 3) in Load Behavior section of the COM Add-Ins dialogue box, proceed with the these instructions. If not, please contact Hotline@goAzTech.com.
  3. Click OK
  4. Navigate to the Start menu in Windows, then click on Control Panel. Click on Programs > Programs and Features, then click on Microsoft Project Professional 2010 (or 2013) within the list.
  5. A Change button will appear in the dialogue box above the program list. Click Change (as shown in step 7)
  6. An MS Office dialogue box will appear. Select Repair and follow the steps to repair the program.
  7. A reboot of Windows may be necessary. Note: If this does not correct the problem, uninstall the Add-In from both MS Project (File/Options/Add-Ins/Go...) and Windows (Program Features > Run!AzTech > Uninstall).
  8. Repeat steps 4-7, as necessary and Install Run!AzTech using Setup.exe

Either the Run!AzTech Template is not open or macros are not enabled. Run!AzTech Ribbon automatically opens the Run!AzTech Template (.MPP) file when MSP opens. When working in MSP make sure you have the Run!AzTech Template .MPP file OPEN at all times. Also be sure to select "Enable Macros" when prompted after opening the template file.



File extensions need to be visible for some of the macros to work correctly. If you recently installed Run!AzTech, you may need to modify your Windows Explorer settings.
  1. Go to Programs > Control Panel > Folder Options > View (tab).
  2. Under Files and Folders > Hidden Files and Folders, make sure "Hide extensions for known file types" is UN-checked.
 

Setting MSP to manual calculation can help save time and speed up some processes while working in MSP. To change the calculation mode go to Tools > Options > Calculation (tab) and change the Calculation mode to 'Manual'. If this option is used be sure to hit F9 when any calculations are necessary.

 
  1. Right-click in the Toolbars area and select 'Customize...' 
  2. De-select or delete AzTech Menu.
  3. Exit & restart MS Project.
  4. Right-click in the Toolbars, select 'Customize...' and select 'Reset'.
  5. Exit & restart MSP (if needed).
  6. Drag & drop other toolbars to set up toolbars as desired.

Super User Licenses allow for secure access to AzTech's proprietary web knowledge base for Microsoft Project, Integrated Master Plan / Schedule IMP / IMS), & Earned Value Management Systems (EVMS). Super Users receive dedicated, off-site support for Wish List items, customized functionality, & advanced implementation & analysis support. Within the off-site hours, AzTech will make a best effort to include client's desired enhancements & provide detailed off-site support.

  • Run!AzTech Template for Microsoft Project Professional 2000 through 2013, plus documentation in un-editable, electronic format.
  • Remote Training via periodic Webinars or AzTech Web based training videos.
  • AzTech supports installation of our Template for MS Project for Super Users.
  • Basic & Intermediate Training for Super Users via off-site support & Webinars. including tips for generating project-specific metrics & AzTech Schedule
  • Analysis & Technical Support within off-site hours.
  • Priority customization. Client has priority input into AzTech's Wish List tracking for enhanced functionality.

Be sure to run the 'N15' command to copy the Unique IDs to the Number 15 field. The OOS report uses this field to report the Unique ID in parentheses next to each Task Name.


Select the given milestone and run the Trace function. Input the letter C to trace using total float, and F to sort the results by finish date. If the schedule is set up properly, the results should make a continuous task waterfall in the Gantt chart.




Note: You can select D instead of C, and the Trace function will output the driving path.

AzTech recommends that users update their version of MSP with the latest Service Packages & other MS provided updates. Un-updated versions of MSP may result in export issues.

Using Run!AzTech, simply select the Program Milestone (or any other milestone or task, for that matter) and use Run! '
CPLI' to walk through the CPLI wizard. The CPLI determines the critical path length, adds or subtracts the Total Float value (adds a positive Total Float value or subtracts a negative Total Float value), then divides this by the critical path length. Thus, a Program Milestone with zero Total Float yields a CPLI of 1.0; negative Total Float yields a CPLI less than 1.0; positive Total Float yields a CPLI greater than 1.0.

Caveats: This index assumes that the Total Float is a valid value based on sound network logic and a valid Baseline Finish Date.

The AzTech Stats report does not automatically compute the CPLI, but you can compute it using the following steps:

To manually calculate the CPLI (per DCMA's method), first you need to figure out the length from time now (or status date) to the program end. The easiest way to do this is to create a dummy task in the schedule, set the start date equal to the status date and set the duration long enough to 'hit' the Program Complete milestone's Baseline Finish Date. This duration is the distance between time now and the program milestone and is known as the 'Critical Path Length'. There are other ways to do this, but this is the easiest way to incorporate the project's calendars/working times on any given schedule & any scheduling tool. Next the least amount of Total Slack/Float in the schedule should be found and is known as the 'Float Duration'. Use the following formula to determine the CPLI:

CPLI = (Critical Path Baseline Duration + Float Duration) / Critical Path Baseline Duration

The BEI is based on the Defense Acquisition University (DAU) Gold Card that contains commonly used Earned Value terms and acronyms, including formulas for variances, metrics, and indices.

The AzTech Stats report uses an algorithm that counts the number of Completed Tasks with a Baseline Finish date <= the Status Date divided by the number of Tasks with a Baseline Finish date <= the Status Date. While a project is in progress, the BEI fluctuates due to performance against the baseline plan. A BEI < 1 means the project is behind schedule in regards to the baseline, and a BEI >1 means the project is ahead of schedule or exceeding the baseline plan.As a project nears completion, the BEI will trend towards 1.0. Once the project has reached completion, the BEI will equal 1.0 
(the same is true for Schedule Performance Index, SPI).

BEI = Number of Baseline Tasks Actually Completed / Number of Baseline Tasks Scheduled for Completion

Unfortunately this is an issue with MS (please talk to Bill G., not AzTech!). We have found that if you use Help to search for how to turn User Accounts off, you can uncheck User Accounts and then MS Project (& other applications) work without the constant crashing under Vista.

!! Please do this step at YOUR OWN RISK!! (but it does work)

Use the Links button or Run > Links. The driving predecessor will have an asterisk to the left of the predecessor in the Excel Links report.



It could be that the AzTech_Maps.TXT file is not in the same folder as your Project .MPP file. Or, it could be that the .TXT file does not contain a valid Map name.

Note: Maps reside in Global.MPT on each computer and must be created in Global.MPT using File Save As, and the Maps Wizard--or copied into Global.MPT using Tools, Organizer.

This usually means your .MPP file has a formula in a field that our Template uses. Check the field (most likely Number15, Text3, Flag19, Number20) by inserting that field´s column, right clicking, and choosing Customize Field, then uncheck the bottom three radio buttons.

Yes, so long as the tool can produce a .MPP file, you can use our Template. Run!AzTech works with any .MPP file

From the Run!AzTech tab, type the command Convert into the Run! command prompt field.
 
Warning: Only works on SELECTED Tasks that are showing (not filtered out) and does not work on Tasks with ELAPSED durations (you´ll have to change those manually).
Also: We think AzTech's function works better than MS Project's 'Format Durations´ macro.

This is a known MS Project issue that occurs when the Global.MPT file becomes corrupted.

To resolve this, you will need to locate this file in your application folder, then make a backup copy of the file (simply copy and paste within the same folder), then obtain a new global.MPT from another MSP user to replace the corrupted version.

The file location will vary, but is usually under something like this:
C:\Documents and Settings\(?yourlogin?)\Application Data\MS Project\12\1033

OR

Open and save a new .mpp. Open the Organizer and copy everything except Modules from the Global.MPT to the new file (remember to look for the Task and Resource radio buttons and to switch between them on the tabs that have them). Save the new file. Open the Organizer again and one by one copy all the modules to the new file. If any that will not copy were not native to MS Project's Global.mpt file, you may need to open Project Visual Basic and copy the content of those modules to a text file or otherwise back them up. Save the backup file and close MS Project. Go to C:\Documents and Settings\(?yourlogin?)\Application Data\MS Project\12\1033 & rename the Global.mpt file. Re-open MS Project and save Project1 somewhere, to recreate a new Global.mpt file. Re-open the backup file you created earlier, and copy everything in the Organizer back to the Global.mpt.


Make sure Macros were enabled when you opened Run!AzTech.

20. What's the difference between AzTech Stats and the DCMA 14 Point Assessment?

DCMA’s 14 Point Assessment represents a high-level snapshot of schedule health, Run!AzTech Stats is a robust, customizable tool with more than 200 “points” of analysis. Not quite apples-to-apples, but acknowledging the importance of the DCMA analysis, the Run!AzTech Stats includes a “14 Point Assessment” preset. 

The 14 Point Assessment preset populates the AzTech Statistics interface with standard DCMA Hit, Total Float, and Task Duration tolerances (0, 44, and 44, respectively). It also enables the 14 Point assessment Stats setting that places a table containing the threshold, results, numerator, and denominator for each of the 14 tests into the Excel report. It is important to recognize these tolerances are open to user edits. As a reminder, the tolerances are printed in columns C to F of the first two rows of the Excel report.



Assuming proper threshold selection, there are differences between the AzTech Stats 14 Point Assessment and DCMA’s:

  1. Test 1 (Missing Logic) – Run!AzTech includes milestones in the count while DCMA does not. Given the frequency of task-to-milestone logic, it is important not to exclude milestones from logic analysis. In most cases, passing AzTech’s version passes DCMA’s.
  2. Test 11b (Late to Baseline) – Run!AzTech includes future tasks while DCMA does not. AzTech BEI predictively reflect whether the schedule has (or has not) addressed recovery plans to get future unfinished work back to a predicted baseline finish variance of 0.
  3. Test 12 (Critical Path). The DCMA test changes the remaining duration for any incomplete task (including unstarted future tasks) by 600 days. If the user selected Finish Milestone moves to the right an appropriate number of days (usually 600 unless the randomly selected task has positive Total Slack), DCMA Test 12 passes.
  4. The AzTech 14 Point Assessment always select an in progress task and fails (even if the randomly selected task moves 600 days) under these conditions; (a.) Microsoft Project settings force all tasks to honor their constraint dates (found in File &gt; Options &gt; Schedule). (b.) If any unfinished tasks (excluding LOE and summaries) lack at least one FS or F. (c.) Any unfinished task lacks logic. In effect, Test 1 must be 0% for the AzTech Test 12 to pass. If there are tasks lacking logic in the schedule, passing Test 12 is purely by chance.
  5. Test 14 (BEI) – Run!AzTech includes tasks lacking a Baseline Finish while DCMA does not.

Project 2013 / 2010 defaults the status date to 8:00 AM, the start of the work day. Be certain to enter the status date using a full date and time including the correct stop time, normally 5:00 PM. Additionally, it is safest to enter the status date from the Project Information dialog on the Project tab  




Best results are obtained by including hh:mm in the date format. Select an appropriate date format from the Back Stage (File/Options/General)




Run!AzTech for Microsoft Project 2013 / 2010 runs in the background and is running properly although screen updates may not appear frequently. Should the screen fade, or, display “Not Responding”, then press CTRL+Break and then click continue in the dialog box. 



To install Run!AzTech, run the setup.exe file downloaded from GoAzTech.com. The Excel add-in and .txt files are no longer needed, except for Run!AzTech Versions 1.0 - 6.0 for MS Project 2003/07 users. When updating Run!AzTech, uninstall the current version of Run!AzTech, and then run the latest .exe setup file.




Just delete within the VAR_Data records by selecting row(s) and right click delete.

Yes, but just be aware that some reports might not fit well on 8.5 x 11 afterward, but if you are mostly reviewing and not printing, that should be fine.

The AutoVAR data tends to be large for some programs and the calculation time can be excessive, so it's best to keep it on Manual. Tip: Use AzTech's Excel Add-in > Admin > Manual to set all open worksheets to Manual calculation. That is AzTech's preferred setting for all spreadsheets and having even ONE spreadsheet open that is set to Auto Calculation will cause frequent recalculation that might be excruciating to endure.

The AutoVAR data tends to be large for some programs and the calculation time can be excessive, so it's best to optimize the user of your laptop's formula calculations by maximizing your processor usage. Tip: Set your Excel tool (via Excel Options > Advanced > Formulas) to enable multi-threaded calculation and also set it so that the maximum number of processors is being used. That is AzTech's preferred setting.



Yes, but best to select those rows, right click, and delete them.

If performance is not an issue, then you can ignore this function; it is only required for very large programs where calculation time is taking too long. The Header tab has a value that determines the number of rows to copy down. Please let us know if that function is working correctly, so we can make any necessary fixes.
Right, it will leave your green cells alone. Again, let us know if you see otherwise. Always save before running this function and run two or three VARs to do a sanity check on the values.


  1. First, open a blank Excel spreadsheet.
  2. Your security settings may be set to automatically disable all macros. 
  3. To check, go to File > Options > Trust Center > Trust Center Settings (button on the right), a new window will appear > Macro Settings. 
  4. Ensure that one of two options (radio buttons) are selected. Select either: 
  5. "Disable all macros with notification" - or - "Enable all macros". The latter is a bit risky depending on the XLS files you work within, but if all are trusted and from known sources, this can help. 
  6. The former, will prompt you before disabling macros, giving you the option to choose NOT to disable macros. One potential issue could be that your current setting is "Disable all macros without notification".     
  7. If you are running an L-3 machine, it is possible that IT has locked your settings and disabled macros. If this is true, you would need to work with them to request a change to these settings. 
  8. If this does not work, it may be an issue in your trust settings. Google, or use MS Help, to understand all of your trust setting options (Publishers, Locations, Documents), then tweak your settings accordingly to allow AutoVAR to function properly.
  9. Confirm that Excel Security is set to Medium.

FAQs