AWP Manager - Version 2.62 has been uploaded with the latest
bug fixes. This very useful tool will greatly increase the speed at which the DIFM Report can be scrubbed. Although
the AWP Manager is a work in progress, its capabilities are an asset to any AWP crew. This program, like all the others,
takes an Adhoc and parses the data into a workable, meaningful format. If you want to know how many WP status WRA's
are over 24 hours old, simply click the WP button on the AWP tab and print the results. You can do the same thing for
any other AWP or Maintenance status WRA.
The AWP Manager also monitors SRA (bit peice) status, Acitivity Percentages in AWP, and Overcost WRA's. Future program
features will include (time permitting) Transpose Candidates, and Generate Reports.
AWP Transpose: This tool will eventually make its way into the
AWP Manager program. Its function is to compare COMPL / REFER SRA's with like part numbers and list them in adjacent
tables to compare to the DIFM. Work Centers, PC, and AWP alike can run this tool and then find these items in the DIFM
to consider for transpose. Simply run the Adhoc in NALCOMIS and save the result over the text file already named "AWP
Transpose Candidates.txt" then click the [Find Transpose Candidates] button.
AWP SOP's (NAS JAX FL) : A comprehensive guide to normal
day to day operations at AWP NAS JAX FL. (Link removed)
Subjects covered in this SOP:
- AWP Basics
- BCM 4
- Bit Peice Receipt Processing
- Component Receipt
- Component Release/Cann
- Daily Numbers
- Reorder Procedures
Quarterly UMMIPS Report - Generates a breakdown of IPG percentages based
on activity. Edit/Add/Remove Activity Name (requsitioner) / Org codes, and import the latest UMMIPS.ah results to
quickly calculate the Requisition IPG's for all activities. (Includes 'Help' tab)
FAQ0 - Clean up empty NALCOMIS locations with this tool by locating
NIIN's with 0 FAQ, 0 DUE, 0 DTO, and 0 on hand quantities and remove them [locations] from NALCOMIS. This tool
is mostly useful for the DBA.
DIFM/NRFI Balance - This simple but useful tool requires
two Adhoc results. One from NALCOMIS and one from R-Supply. Its purpose is to reconcile the difference of
DIFM/NRFI Balance between NALCOMIS and R-Supply. (Includes 'Help' tab)
IOU Carcass Tracking Report - This, slightly more complex, Excel
program will scrub the IOU report via Adhoc and generate an IOU Carcass Tracking report that can be saved and emailed to the
appropriate levels for expediting IOU turn in's. Run the IOU.ah and Import the results into the program and run the
Report. The results are categorized into sections: 5S, Non RIP, COMPL 24 hours, DTI, and Other.
Review each section and "tag" discrepancies to be noted and refresh the report. A validity percentage will be calculated
based on the review of 21 items. If there are more than 21 discrepancies, the program will alert the user. Each
report is compared to the Previous Report loaded. (Includes 'Help' tab)