Migrating Locations

I think it can be done with formulas. To get started, if the mins are
in B4, the bin would be =INT(B4/6)*6+3. This would put 0 thru 5.9 into
3, 6 thru 11.9 into 9 etc. To get the extra for 6 into 3, maybe an if
statement in another column to get the second bin for the 6,12 etc.
=if(int(b4/6)=b4/6,INT(B4/6)*6-3,""). Needs more work to get rid of the
-3 result for 0 in b4. Maybe this gets you going....

Len

Victor Hitchings via OfficeKB.com wrote:
> In biological mapping location data is often binned to central points. For
> example:
> 23 deg 01.50 mins N, 54 deg 07.30 mins E
> would bin (using 6 minute bins) to -
> 23 deg 03 mins N, 54 deg 09 min E
>
> As an added complication figures along a bin line would move into 2 bins, e.g.
>
> 23 deg 06 mins north would bin as 23 deg 03 mins N AND 23 deg 09 mins N
>
> I assume a look-up table is required but does anyone have an existing
> solution to this one, albeit that the data would sit in a true tabular form
> not text like this.
>
> Regards
> Vic

Len,
Thanks for the reply. I will work on it.
Regards
Vic

--
Message posted via http://www.officekb.com

I think it can be done with formulas. To get started, if the mins are
in B4, the bin would be =INT(B4/6)*6+3. This would put 0 thru 5.9 into
3, 6 thru 11.9 into 9 etc. To get the extra for 6 into 3, maybe an if
statement in another column to get the second bin for the 6,12 etc.
=if(int(b4/6)=b4/6,INT(B4/6)*6-3,""). Needs more work to get rid of the
-3 result for 0 in b4. Maybe this gets you going....

Len

Victor Hitchings via OfficeKB.com wrote:
> In biological mapping location data is often binned to central points. For
> example:
> 23 deg 01.50 mins N, 54 deg 07.30 mins E
> would bin (using 6 minute bins) to -
> 23 deg 03 mins N, 54 deg 09 min E
>
> As an added complication figures along a bin line would move into 2 bins, e.g.
>
> 23 deg 06 mins north would bin as 23 deg 03 mins N AND 23 deg 09 mins N
>
> I assume a look-up table is required but does anyone have an existing
> solution to this one, albeit that the data would sit in a true tabular form
> not text like this.
>
> Regards
> Vic

Len,
Thanks for the reply. I will work on it.
Regards
Vic

--
Message posted via http://www.officekb.com

In biological mapping location data is often binned to central points. For
example:
23 deg 01.50 mins N, 54 deg 07.30 mins E
would bin (using 6 minute bins) to -
23 deg 03 mins N, 54 deg 09 min E

As an added complication figures along a bin line would move into 2 bins, e.g.

23 deg 06 mins north would bin as 23 deg 03 mins N AND 23 deg 09 mins N

I assume a look-up table is required but does anyone have an existing
solution to this one, albeit that the data would sit in a true tabular form
not text like this.

Regards
Vic

I think it can be done with formulas. To get started, if the mins are
in B4, the bin would be =INT(B4/6)*6+3. This would put 0 thru 5.9 into
3, 6 thru 11.9 into 9 etc. To get the extra for 6 into 3, maybe an if
statement in another column to get the second bin for the 6,12 etc.
=if(int(b4/6)=b4/6,INT(B4/6)*6-3,""). Needs more work to get rid of the
-3 result for 0 in b4. Maybe this gets you going....

Len

Victor Hitchings via OfficeKB.com wrote:
> In biological mapping location data is often binned to central points. For
> example:
> 23 deg 01.50 mins N, 54 deg 07.30 mins E
> would bin (using 6 minute bins) to -
> 23 deg 03 mins N, 54 deg 09 min E
>
> As an added complication figures along a bin line would move into 2 bins, e.g.
>
> 23 deg 06 mins north would bin as 23 deg 03 mins N AND 23 deg 09 mins N
>
> I assume a look-up table is required but does anyone have an existing
> solution to this one, albeit that the data would sit in a true tabular form
> not text like this.
>
> Regards
> Vic

Len,
Thanks for the reply. I will work on it.
Regards
Vic

--
Message posted via http://www.officekb.com