RA 1.42 Sonar Profile XLS layout

FPSchazly · 07-26-17, 01:14 PM

I personally like seeing all the types of platforms mishmashed together, with the only organization being ascending order of frequencies. I like seeing the full range of what unidentified contacts could be.

The way the LwAmi frequency was broken up is interesting, also. They sort things by ship type and then number of propellers, for example, if I remember it correctly.

Pisces · 07-26-17, 03:22 PM

Imho, the order in the list does not matter. Select all the columns and use the sort and filter function of Excel (2010, but all versions have it I think). Then you can select all applicable frequencies from a pull-downlist when you click on the column header. Or better you can even use compound relational filters (frequency larger than X and lower than Y). Only those rows with frequencies (cell values in general) that match show up in the list.

07-26-17, 01:14 PM	#1
FPSchazly Good Hunting! Join Date: Apr 2014 Location: Beantown Posts: 776 Downloads: 15 Uploads: 1	I personally like seeing all the types of platforms mishmashed together, with the only organization being ascending order of frequencies. I like seeing the full range of what unidentified contacts could be. The way the LwAmi frequency was broken up is interesting, also. They sort things by ship type and then number of propellers, for example, if I remember it correctly. __________________ Your friendly neighborhood modern submarine YouTuber. My videos: Exclusive Look at Modern Naval Warfare! Dangerous Waters Liu Doctrine (LwAmi Learn to play Dangerous Waters

07-26-17, 03:22 PM	#2
Pisces Silent Hunter Join Date: Dec 2004 Location: AN9771 Posts: 4,904 Downloads: 304 Uploads: 0	Imho, the order in the list does not matter. Select all the columns and use the sort and filter function of Excel (2010, but all versions have it I think). Then you can select all applicable frequencies from a pull-downlist when you click on the column header. Or better you can even use compound relational filters (frequency larger than X and lower than Y). Only those rows with frequencies (cell values in general) that match show up in the list.