Tablue
function to 
mgrs grid system
if an observer citizen it doesn't define a new site.
if trained, and on the observer app, it would create a new site even if it is hte same mgrs site.
test d.e.

entries at midnight in S.A.
many obs that have 0 cloud cover

perhaps bad midnights 13333
in S.A. 3690
in S.A. and Oman 3903

mgrs zone =CONCATENATE(H2, " ",I2,"  ",AD2,AF2)

mgrs northing =RIGHT(INT(K2),5)  
K  =IF(B2>0,V2,10000000+V2) 
V  =(AW2+AX2*AU2*AU2+AY2*AU2^4) 
AW =AN2*AH2  
AX =AM2*SIN(P2)*COS(P2)*AV2^2*AH2*(100000000)/2  <----- off fix it
AU =(AT2)*3600/10000  
AY =((AV2^4*AM2*SIN(P2)*COS(P2)^3)/24)*(5-TAN(P2)^2+9*AJ2*COS(P2)^2+4*AJ2^2*COS(P2)^4)*AH2*(10000000000000000)

AM =Y2/((1-(AI2*SIN(P2))^2)^(1/2))
AN =AO2*P2 - AP2*SIN(2*P2) + AQ2*SIN(4*P2) - AR2*SIN(6*P2) + AS2*SIN(8*P2)
   =AO2*P2 - AP2*SIN(2*P2) + AQ2*SIN(4*P2) - AR2*SIN(6*P2) + AS2*SIN(8*P2)
AH =0.9996
AT =C2-J2
AV =PI()/(180*3600)
AM =Y2/((1-(AI2*SIN(P2))^2)^(1/2))
P  =B2*PI()/180
AJ =AI2*AI2/(1-AI2*AI2)
Y  =VLOOKUP(W2,DatumList,3)  <**********
AI =SQRT(1-(Z2/Y2)^2)
AO =Y2*(1-AK2+(5*AK2*AK2/4)*(1-AK2) +(81*AK2^4/64)*(1-AK2))
AP =(3*Y2*AK2/2)*(1-AK2-(7*AK2*AK2/8)*(1-AK2)+55*AK2^4/64)
AQ =(15*Y2*AK2*AK2/16)*(1-AK2+(3*AK2*AK2/4)*(1-AK2))
AR =(35*Y2*AK2^3/48)*(1-AK2+ 11*AK2*AK2/16)
AS =(315*Y2*AK2^4/51)*(1-AK2)
J  =6*H2-183
H  =IF(C2<0,INT((180+C2)/6)+1,INT(C2/6)+31)
B  =LATITUDE
C  =LONGITUDE
Z  =VLOOKUP(W2,DatumList,4)  <********** 
AK =(Y2-Z2)/(Y2+Z2)
™
6378137
Theresa_go_report.txt
mgrs easting =RIGHT(INT(L2),5)   
L  =500000+(AZ2*AU2+BA2*AU2^3)
AZ =AM2*COS(P2)*AV2*AH2*10000
AU =(AT2)*3600/10000  ####
BA =(AV2*COS(P2))^3*(AM2/6)*(1-TAN(P2)^2+AJ2*COS(P2)^2)*AH2*(1000000000000)

mgrs zone   =CONCATENATE(H2, " ",I2,"  ",AD2,AF2)
I  =VLOOKUP(B2,LatZones,2)
AD =VLOOKUP(AC2,A_100K_E,2)
AF =VLOOKUP(AE2,A_100K_N,2)
R  =8*MOD((H2-1),3)+1
AC =R2+INT((L2)/100000)-1
AE =MOD(T2+INT(V2/100000),20)
T =1+5*MOD(H2-1,2)  done
V =(AW2+AX2*AU2*AU2+AY2*AU2^4) done