Opening the 1348 short or long Excel form




Yüklə 74.08 Kb.
tarix12.03.2016
ölçüsü74.08 Kb.

DDForm1348-1a
Using Excel to Create a
Disposal Turn-In Document




Opening the 1348 short or long Excel form

From the web page https://www.drms.dla.mil/turn-in/usable/documentation-usable.shtml the following choices are available just click to open. These files use macros these will need to be enabled after opening the file for drop down options to be usable.

1. Original 1348 Short Form (.xls) 1348 Short Form per MIL-STD-129 (.xls)
Basic information required for your turn-in document.

2. Original 1348 Long Form (.xls) 1348 Long Form per MIL-STD-129 (.xls)


The Long Form accommodates all columns and blocks on the DD 1348-1A to include selecting  many different drop down menu certification statements.


Adding the 3 of 9 Barcode Font to a computer




Copy the Barcode font to your Computer


1. Right click on the 3of 9 font below, copy and paste in your computer.




  1. Right Click on Start, Click on Explore, and Click on C: drive then paste this font file in the c:\ folder.




  1. Click on Start, open Control Panel, then open Fonts folder





  1. Click on File, Install New Font

  2. You may need to click on the C:\ folder for the 3 of 9 Barcode to appear.

  3. Highlight the file and click on OK.







  1. The font is now installed in you Font folder.


E

nabling Macros when using Microsoft Excel 2007



For the short and long form


  1. A Security warning will display that the file uses Macros. These Macros enable the drop down options.

  2. Select the Options tab



  1. Next select Enable this content and select OK.



  1. After enabling Macros the drop down options will be usable.

  2. Type in generic data and Save this new file to your desk top as a blank file. Save completed turn-in files in a folder using the DTID number as the files name you may also want to add the NSN or noun.

DTID: Example

C:\DTIDS for 2009\W91ATB92350001.xls

DTID-NSN: Example



C:\DTIDS for 2009\W91ATB92350001-7021004564451.xls

DTID-NSN-NOUN: Example



C:\DTIDS for 2009\W91ATB92350001-7021004564451-COMPUTERMODUAL.xls

Enabling Macros when using Microsoft Excel 2003

For the short and long form


When you first open the program you will be prompted with this menu. Choose Enable Macros.

The Short Form





1

The input form will appear. The first block of information that you will need to choose is which servicing DRMO you will be delivering the property to. A drop down box will appear with all participating DRMOs (1).



2

The next step is to place the mouse cursor on the POC Block and click once. Make sure your CAP Locks are on. This will make the printable document easier to read. Once you type in the POC name hit Enter (Do not use the Tab key in this program, only use your mouse and enter key). Now type in your telephone number, () and – are allowed and then press Enter. Next input your 6 digits DODAAC and press Enter.

3

The Refresh POC Information button (3) will refresh all the POC fields.

4

Place your mouse cursor or hit Enter until you have the DTID NUMBER field highlighted. Enter in your 14-digit Disposal Turn In Document (DTID) number. The number consists of your 6 digit DoDAAC, 4 digit Julian Date and 4 digit serial number assigned by you. Do not use dashes. Once DTID is completed, press Enter.

5

Input your National Stock Number (NSN) or Local Stock Number (LSN) with out dashes (5) and press Enter. All efforts to obtain a valid NSN should be made prior to using an LSN.

6

Input the Nomenclature (6) for the item and press Enter. Please use as descriptive of Nomenclature as possible.

7

A drop down box will appear when you click on the arrow. You will be able to choose the proper Unit of Issue (7). You can select by using the mouse or using the arrow keys to select. Once you have selected press Enter.


8

You must place the mouse cursor on the Quantity field and click once to continue. Input the Quantity (8) of your item and press Enter.

9

A drop down box will appear when you click on the arrow. You will be able to choose the proper DEMIL Code (9). You can select by using the mouse or using the arrow keys to select. Once you have selected press Enter. Note: DRMOs cannot accept DEMIL P property.


10

You must place the mouse cursor on the Condition Code field and click once to continue. Input the Condition Code (10) of your item and press Enter. It is the customer’s responsibility to provide a proper Condition of the property.

11

Input the Unit Price (11) for the item and press Enter. If the price is a round figure you do not have to input the cents, the program will reflect the dollar value. If necessary add the cents, but do not add the dollar sign.

12

A drop down box will appear when you click on the arrow. You will be able to choose the proper Disposal Authority Code (12). You can select by using the mouse or using the arrow keys to select. Once you have selected press Enter.

13

You must place the mouse cursor on the Fund Site field (if applicable) and click once to continue. Input the Fund Site (13) and press Enter. It is the customer’s responsibility to provide a proper Fund Site (ie. NAF, Lost & Abandoned, RRRP, etc..).

14

The Refresh Input Information button (14) will refresh all the required document fields.

15

If your item has Additional Information (ie.. Serial Numbers (ADPE) , Model, etc…). The Additional Info in red has enough space for 180 characters. This will allow for any type of statement (i.e.. ADPE, DEMIL, etc..) Check with your DRMO local for what statements might apply.

16

The Refresh Additional Information button (16) will refresh all the Additional Information fields.

17

If all of the fields have been completed, you can know press the Print DD 1348-1A (17) button. This will print a 1 page copy with 2 DD 1348-1a documents on the page. (See Attachment 1)


The Long Form




1

Place your mouse cursor on the DTID NUMBER field (1). Make sure your Cap Locks are on and enter in your 14-digit Disposal Turn In Document (DTID) number. The number consists of your 6 digit DoDAAC, 4 digit Julian Date and 4 digit serial number assigned by you. Do not use dashes. Once DTID is completed, press Tab. In this program you will use Tab to go left to right, Enter to go up and down or the mouse and click on each field.


2

Input your National Stock Number (NSN) or Local Stock Number (LSN) with out dashes (2) and press Enter. All efforts to obtain a valid NSN should be made prior to using an LSN.

3

You must place the mouse cursor on the Quantity field and click once to continue. Input the Quantity (3) of your item and press Enter.



4

A drop down box will appear when you click on the arrow. You will be able to choose the proper Unit of Issue (4). You can select by using the mouse or using the arrow keys to select and press Enter.

5

You must place the mouse cursor on the DISP AUTH field and click once to continue. A drop down box will appear when you click on the arrow. You will be able to choose the proper Disposal Authority Code (5). You can select by using the mouse or using the arrow keys to select and press Enter.


6

You must place the mouse cursor on the COND field and click once to continue. A drop down box will appear when you click on the arrow. You will be able to choose the proper Condition Code (6). You can select by using the mouse or using the arrow keys to select and press Enter.

7

You must place the mouse cursor on the Unit Price (7) for the item and press Enter. If the price is a round figure you do not have to input the cents, the program will reflect the dollar value. If necessary add the cents, but do not add the dollar sign.

8

A drop down box will appear when you click on the arrow. You will be able to choose the proper DEMIL Code (8). You can select by using the mouse or using the arrow keys to select and press Enter. Note: DRMOs cannot accept DEMIL P property.

9

Input the Nomenclature (9) for the item and press Enter. Please use as descriptive of Nomenclature as possible.


10 10

Place the mouse cursor on the SHIP to DRMO box to choose is which servicing DRMO you will be delivering the property to. A drop down box will appear with all participating DRMOs (10). You can select by using the mouse or using the arrow keys to select and press Enter.

11 10

Place the mouse cursor on the SHIP From Field box (11) and input your DoDAAC. After input of the information, TAB to the next field.


12 10

Input your POCs name in the Point of Contact Field (12) . After input of the information, TAB to the next field.

13 10

Input your POCs Phone Number in the Phone Number Field (13). After input of the information, place the mouse cursor on the drop down box for Text Statements.
Note: The POC Phone number is the last required field. The remainder of the fields are for property that require special handling or text statements


14 10

After Clicking on the drop down arrow (14), a choice of possible statements (Automation Equipment, DEMIL, Mutilation, etc.). Choose the appropriate statement for the type of property if applicable. To choose click on the appropriate statement or arrow down to the appropriate statement and press enter. Place the mouse cursor on the drop down box for Signature Statements.

15 10

After Clicking on the drop down arrow (15), a choice of possible Signature statements appears. Choose the appropriate signature statement that matches the property statement.


16 10

If the item has a Serial Number input the information into the Serial Number Fields (16). You can use the mouse, Tab and Enter Keys.
The remainder of the document is optional fields, but any additional information you can provide is beneficial to the DRMO and possible future DoD customers. (Instructions for filling out the optional information can be found in DoD 4000.25-1-M)


17 10

If there is no additional information you can know press the Print DD 1348-1A (17) button. This will print a 1 page copy with 2 DD 1348-1a documents on the page. (See Attachment 2)


18 10

If you would like to input additional information you can refresh the Mandatory fields by clicking the Refresh Button (18).
Optional Information:

19 10

Place the mouse cursor on the DOC IDENT field (19) and click. Input the DOC IDENT information and press Tab to continue to the next fields.

20 10

Input the RI COND information (20) and press Tab to continue to the next fields.

21 10

Input the M & S information (21) and press Tab to continue to the next fields.



22 10

Input the SER information (22) and press Tab to continue to the next fields.

23 10

Input the SUPPLEMENT ADDRESS information (23) and press Tab to continue to the next fields.


24 10

Input the FUND information (24) and press Tab to continue to the next fields.

25 10

Input the DISTRIBUTION information (25) and press Tab to continue to the next fields.

26 10

Input the PROJ information (26) and press Tab to continue to the next fields.

27 10

Input the PRI information (27) and press Tab to continue to the next fields.

28 10

Input the RI information (28) and press Tab to continue to the next fields.

29 10

Input the O/P information (29) and press Tab to continue to the next fields.

30 10

Input the MGT information (30) and press Tab to continue to the next fields.

31 10

Input the MARK FOR information (31) and press Enter.

32 10

The DOC DATE information is automatically completed with the currents days date (32).


32 10

Place the mouse cursor on the NMFC field (32) and click. Input the NMFC information and press Tab to continue to the next fields.



33 10

Input the FRT RATE information (33) and press Tab to continue to the next fields.

34 10

Input the TYPE CARGO information (34) and press Tab to continue to the next fields.

35 10

Input the PS information (35) and press Tab to continue to the next fields.

36 10

Input the QTY RECEIVED information (36) and press Tab to continue to the next fields.

37 10

Input the UP information (37) and press Tab to continue to the next fields.

38 10

Input the UNIT WEIGHT information (38) and press Tab to continue to the next fields.

39 10

Input the UNIT CUBE information (39) and press Tab to continue to the next fields.

40 10

Input the UFC information (40) and press Tab to continue to the next fields.

41 10

Input the SL information (41) and press Tab to continue to the next fields.

42 10

Input the SIG information (42) and press Tab to continue to the next fields.

43 10

Place the mouse cursor on the FREIGHT CLASSIFICATION field (43) and click. Input the FREIGHT CLASSIFICATION information and press Tab to continue to the next fields.

44 10

Input the TYPE CONT information (44) and press Tab to continue to the next fields.

45 10

Input the NO CONT information (45) and press Tab to continue to the next fields.

46 10

The TOTAL WEIGHT information (46) is entered for you. Press Tab to continue to the next fields.

47 10

Input the TOTAL CUBE information (47) and press Enter.

48 10

You can know press the Print DD 1348-1A (17) button. This will print a 1 page copy of the DD 1348-1a document. (See Attachment 3)


49 10

To begin a new document Refresh the Mandatory and Optional Fields (49) and follow the instructions from the beginning again. Once you do it a few times you will no longer need the instructions.


(ATTACHMENT 1)

(ATTACHMENT 2)

(ATTACHMENT 3)


Verilənlər bazası müəlliflik hüququ ilə müdafiə olunur ©azrefs.org 2016
rəhbərliyinə müraciət

    Ana səhifə