The spreadsheet has been created with Microsoft Excel. If you do not have access to Microsoft Excel, you can open and edit the war memorial spreadsheet using the following free spreadsheet applications:
| Microsoft Windows: | OpenOffice.org | http://www.openoffice.org/ |
| Mac OS X: | NeoOffice | http://www.neooffice.org/ |
On the War Memorial Details sheet, make sure you provide as much information as possible. You may need to do some background research to find out some of the details, such as the dedication date. Accuracy is important, so if in doubt, leave the field blank.
If there are names listed on the war memorials, you will need to record those into the Listed Veteran Names sheet.
The War Memorials data entry spreadsheet contains a number of separate sheets. Switch between sheets by clicking on the tab toolbar in the bottom left corner of your spreadsheet application. For example, to enter veterans' names, you would click on the Listed Veteran Names tab.
The following contains information about the various field names from the Name entry sheet and list some common examples.
| AB | Able Seaman |
| Bmdr | Bombardier |
| Brig | Brigadier |
| Cadet | Cadet |
| Capt | Captain |
| Cpl | Corporal |
| Gnr | Gunner |
| Lt | Lieutenant |
| Maj | Major |
| Pte | Private |
| Sgt | Sergeant |
| Sqn Ldr | Squadron Leader |
Other ranks can be obtained by searching in the Roll of Honour Database at http://www.awm.gov.au/database/roh.asp
Status Codes refers to the fate of a veteran during the course of the war. This field should be left blank if the veteran survived the war.
| Code | Explanation |
| Acc Kd | Accidently Killed |
| DOC | Died of Other Causes |
| DOD | Died of Disease |
| DOS | Died on Service |
| DOW | Died of Wounds |
| DPOW | Died Prisoner of War |
| In Memoriam | In Memory of the Departed |
| KIA | Killed in Action |
| MIA | Missing in Action |
| POW | Prisoner of War |
| RAN | The Royal Australian Navy |
| WRANS | Women's Royal Australian Naval Service |
| Army | Australian Army |
| AWAS | Australian Women's Army Service |
| WRAAC | Royal Australian Women's Army Corps |
| RAAF | The Royal Australian Air Force |
| WAAF | Women's Auxiliary Australian Air Force |
| WRAAF | Women's Royal Australian Air Force |
For an explanation of military services, access the Australian War Memorial site at http://www.awm.gov.au/atwar/structure/
For an explanation of military units for each service, access the Australian War Memorial site: http://www.awm.gov.au/units/
Campaign refers to a major military undertaking with a definite objective, often comprising a number of battles or engagements. Some NSW war memorials list individual campaigns. Campaigns are often referred to by place names, eg Fromelles.
Use M for males and F for females. Usually women are listed along with their unit names, eg. AWAS (Australian Women's Army Service), or have a rank of Sister (i.e. a nurse).
| AFC | Air Force Cross |
| AFM | Air Force Medal |
| BEM | British Empire Medal |
| CBE | Commander Order of British Empire |
| CB | Companion Order of Bath |
| CGM | Conspicuous Gallantry Medal |
| DCM | Distinguished Conduct Medal |
| DFC | Distinguished Flying Cross, Bar |
| DFM | Distinguished Flying Medal, Bar |
| DSC | Distinguished Service Cross, Bar |
| DSM | Distinguished Service Medal, Bar |
| DSO | Distinguished Service Order |
| RRC | Distinguished Service Order, Bar Royal Red Cross |
| LOH | French Legion D'Honneur |
| GC | George Cross |
| GM | George Medal, Bar |
| KBE | Knight Commander Order of British Empire |
| GBE | Knight Grand Cross Order of British Empire |
| MBE | Member Order of British Empire |
| MD | Mentioned in Dispatches |
| MC | Military Cross, Bar |
| MM | Military Medal, Bar |
| OBE | Officer Order of British Empire |
| VC | Victoria Cross |
| QSA | Queen's South Africa Medal 1899-1902 |
| KSA | King's South Africa Medal 1901-1902 |
For a discussion of Australian military awards, visit http://www.asacaustralia.com/medals.htm
Some war memorials, especially those with veteran's graves, include service numbers.
A service number for a memorial listed First World War veteran can usually be identified by accessing the Biographical Databases at the Australian War Memorial. http://www.awm.gov.au/database/biographical.asp
| Email: | warmemorials@sl.nsw.gov.au |
| Address: |
War Memorial Register State Library of NSW Macquarie Street Sydney NSW 2000 |
| Telephone: | (02) 9273 1554 |