In order to maintain the required 30 seconds of data silence after a group poll has been sent out from your base, the first GPS radio callsign that can be used is the one with a reply slot time of 30 seconds, that's fairly obvious but with a significant variable having been introduced into the calculation by the FFSK Lead-In Delay value, the position of the GPS radio callsign slides up and down the list of 127 as the Lead-In delay value changes. As such I've designed the spreadsheet so that it will colour all the callsigns with a reply slot time of 30 seconds or more pale green. Thus any callsign from the list with a pale green background can be used for your GPS radios providing you have entered the correct FFSK Lead-In Delay value you are using in your system. The callsigns from 1 to whatever this number is are coloured pale orange and these are available for use with mobile phones or non-GPS assets.
The spreadsheet was designed using MS Excel 2007 where the Conditional Formatting functions have changed significantly from earlier versions. As with most things, 'improvements' make it harder to use. If anyone has problems opening the file which has been saved in the earlier format, or finds they cannot see the necessary cell colour changes, please let me know and I'll produce an Adobe Acrobat .pdf version specifically for your team if you send me the value of FFSK_Lead In Delay you use.
The new version of the spreadsheet is attached to the top of this posting.
As most of you will already know, the point in time when any individual radio sends in its position report is calculated by the radio itself. MRMap only sends out a fire and forget request for a position report, the rest is handled entirely by the radios.
In the past the formula for the calculation used the individual callsign for that radio to produce a unique time slot. All other values were constants held in the radio firmware. Recently this has changed and another variable has been introduced, the FFSK Lead-In Delay. The location of this value in the programming software is shown here.
This is the configuration for an SRM9030 radio intended to be used as an MRMap base receiver.

The calculation for those interested is:-
Response Time (mS) = (( ownDataAddress - baseData Address ) * (350 +> FFSK_LID (mS) ) ) + 320
It's the variable shown as 'FFSK_LID' that has changed from a fixed value previously to the actual value you've entered into the configuration file for your radio.
There is now the potential for teams using the higher callsign values from their block of 127 to have a re-poll period that will mean radios are re-polled before they've actually sent in any position reports. This will cause some radios to disappear from the map and only send in reports when the PTT is released etc. They won't be polled in the normal way.
The MRMap ini file parameter responsible for this is:-
PollRadiosEvery=80
Because of this possibility, I've re jigged the spreadsheet to accept both your team number and the FFSK Lead-in delay you opt to use. The decision you need to make here is that 320 milliseconds is average for systems that don't use repeaters or rebroadcast. And 600ms is about right for teams who do use repeaters etc. From this you can see that the final figure produced by the above calculation can potentially vary quite a bit. Once this 'bit' exceeds the value you have in your ini file for the poll period then those radios may be affected.
The spreadsheet will take your team number and calculate your block of 127 callsigns for MRMap. It will also give you the reply slot time for each callsign and a suggested minimum value for the PollRadiosEvery= parameter in the MRMap ini file. You can use values larger than this but not smaller. The suggested value isn't rocket science, it's two seconds longer than the maximum reply time value calculated for your list of callsigns. That's two seconds longer than the value against radio 127 in the list.
Alongside these changes I've also included cells adjacent to each callsign which you can edit to show the name or description of who has that particular MRMap callsign should you wish to.
The spreadsheet is currently setup for Patterdale MRT using an FFSK_LID value of 250ms. You will need to change both these values to reflect those appropriate to your own team and the spreadsheet should do the rest.
Note that the above currently only applies to data sent at 1200 baud. 2400 baud data does not yet use the modified slot time calculation.