GPSLog: Weiterentwicklung

Zitat

Original von gpspassion
Yes, it works here too.
With this you can compare line by line, but not very easy to draw conclusions

Yes, it's realy not easy.

The existing summaries help a lot and if we can add the two "fix tests" then it would be perfect

I go to think..

And work...

See You later, about 3, 4 days ... or so...

Ok, thanks, now back to some testing

While I think of it could we also have an average "sat in use" even when there is no fix ? That would penalize receivers that lose the fix

Zitat

Original von gpspassion
While I think of it could we also have an average "sat in use" even when there is no fix ? That would penalize receivers that lose the fix

Hello??

If is "invalide" in GGA, sat in use are 0! (Is'nt it?)

Do You have an example with other results?

Look at the test-Excel, is it this, what You mean??

Please test it.

What I mean is that if it's 0 it should count in the average or better one line with Fix average and one line with all average, i:e:

Sats in Use : 5 - 3 - 4 - 0 - 0
Fix average=4 (what he have now)
Overall average= 2.4

Got a problem with that new version, see attached:

Zitat

Original von gpspassion
While I think of it could we also have an average "sat in use" even when there is no fix ? That would penalize receivers that lose the fix

hi gpspassion,
i always make this manually by editing the logfile.
I think it is not important to evaluate only sats with fix, but they must have a real value (not zero).
What advantage do you see by looking at the number of sats in use?
In my opinion this isn't helpful. Modern receivers (Xtrack, Sirf III) permit satlevels about 15 dB, i believe this is no hint for the quality of the antenna (or for the quality of the track).

(Charly, i'm not really happy with this thread in offtopic What about "GPS-Tracking ....Auswertung von GPS-Positionsdaten" ? i'm not shore ...)

Hi Peter, sorry for not getting back after contacting you in March, it's been hectic since CeBIT. I knew I'd find you here one day

Well average sats is just one indication, a quantitative one, but you can't beat "looking" at the track of course. Since you mention signal strength, I was going to ask you the other day why you looked at maximum signal (now we also have average), since as you point out SS3 can track at 16dB, so it doesn't really matter if say the EmtacIII has a signal of 35 and can't track properly when the 338 has a signal of 32 and tracks at 16. And I'm not convinced each chipset reports comparable values. I'm not saying it's not an interesting factor, it's just that I don't think it should come before aveage sats in the fix that does show how well a chipset deals with the various components (environment, antenna design, etc...) and of course the "truth is in the track" !

@Peter: help,help.

Denn das:

"Hallo wird Peter, das für das Erhalten nicht rückseitig traurig ist, nachdem man mit Ihnen im März, es in Verbindung getreten hat, seit CeBIT hektisch gewesen. Ich wußte, daß ich Sie hier ein Tag; - finden würde) Wohle durchschnittliche sats ist gerade eine Anzeige, ein quantitatives, aber Sie können nicht der Schiene "selbstverständlich betrachten" schlagen. Da Sie Signalstärke erwähnen,WAR ich im Begriff, zu fragen Sie, daß der andere Tag, warum Sie maximales Signal betrachteten (jetzt haben uns auch Durchschnitt), da, während Sie SS3 unterstreichen, an 16dB aufspüren kann, also es nicht wirklich ausmachen, wenn Sagen das EmtacIII ein Signal von 35 hat und nicht richtig aufspüren können, wenn die 338 ein Signal von 32 hat und bei 16 aufspürt. Und ich bin nicht überzeugte vergleichbare Werte der Reports jedes Chipsets. Ich sage nicht, es nicht ein interessanter Faktor ist, ist es gerecht, daß ich nicht denke, es vor aveage sats in der Verlegenheit kommen sollte, die zeigt, daß wie gut Abkommen eines Chipsets mit den verschiedenen Bestandteilen (Klima, Antenne Design, usw....) und selbstverständlich die "Wahrheit in der Schist nicht iene ist"!"

wirklich hilfreich. Babelfish!

A new version with
aver. use not fix
aver. all, >=0
aver. >0

for testing.

Super !
Aber meinst su aver.>0 = average mit fix ? yes same as the previous average you gave
A small problem maybe, see below :
13+13<>4+14
Oder gibt es 2D-Fix mit 0 satelliten Nemerix ist schlecht !

Zitat

Original von gpspassion
Super !
Aber meinst su aver.>0 = average mit fix ? yes same as the previous average you gave
A small problem maybe, see below :
13+13<>4+14
Oder gibt es 2D-Fix mit 0 satelliten Nemerix ist schlecht !

<grmpf...>

Thats right. Do you have the log for me??

sure, I'll email it to you

Hallo an alle "Translater",

ich bin mit meinem englisch mal wieder am Ende, es hapert an der Detailübersetzung. Offenbar gibt es Verständnisprobleme zwischen Guillaume und mit bez. der Mittelwertbildungen (average). Ich habe ihm eben folgendes gemailt:

Hello Guillaume,

i send You both, makro "Quality" and "Test". "z" is end of table, first green line in sheet = z+3.

I hope you can interpret this makro, it shows the algorythm. Better, you look directly in excel-makro, there are comments are green (excuse my grammatik!!).

Difference: You have in line 24 to 35 "2D-Fix" but sat in use = 0. But I are not sure, I understand You exactly.

Viele Grüße, Charly

Sub Quality()
0
'Dim z%
Dim QualInv&, Qual2D&, Qual3D&, QualDGPS&, QualDead& ' invalid, 2D, 3D, DGPS, alle Long
Dim a$, b$

'z = 1509

QualInv = 0 'Number oflines "invalid"
Qual2D = 0 '" "2D-fIX
Qual3D = 0 '" "3D-Fix"
QualDGPS = 0 '" "DGPS/EGNOS"
QualDead = 0 '" "Dead Reconning"
Use31 = 0 'sat in use 1 or 2, not tested for fix
Use32 = 0 'sat in use >= 3, not tested for fix
Use33 = 0 'summe of all sat in use
Use34 = 0 'number of lines all sat in use
UseNoFix = 0 'sat in use for row 27 = "invalide"
UseNoFixZ = 0 'number of lines for row 27 "invalide"

If Cells(6, 28).Value = "" Then 'if row 28 "", then = "2D-Fix (if GGA not 1)
If Cells(6, 27).Value = "invalid" Then
b = Cells(6, 27).Value
Else
b = "2D"
End If
End If
For i = TabAnfang To z
a = Cells(i, 27).Value
Cells(i, 28).Select ' Testwert

'If i = 794 Then Stop ' Testwert

If Cells(i, 27).Value = "GPS-Fix" Then
b = "2D-Fix"
End If

If Cells(i, 28).Value <> "" Then
b = Cells(i, 28).Value
End If
Select Case b 'from GSA
Case "invalid"
QualInv = QualInv + 1
Case "2D-Fix"
If a = "GPS-Fix" Then
Qual2D = Qual2D + 1
End If
Case "3D-Fix"
If a = "GPS-Fix" Then
Qual3D = Qual3D + 1
End If
End Select

Select Case a 'from GGA
Case "EGNOS Fix"
QualDGPS = QualDGPS + 1
Case "Dead Reckonning"
QualDead = QualDead + 1
End Select


Select Case Cells(i, 34).Value 'number of sat in use
Case 1 To 2
Use31 = Use31 + 1
Case Is >= 3
Use32 = Use32 + 1
'Case Is >= 0
' Use33 = Use33 + Cells(i, 34).Value
' Use34 = Use34 + 1
'Case Is >= 0
' Use34 = Use34 + 1
End Select
Use33 = Use33 + Cells(i, 34).Value 'for all
Use34 = Use34 + 1

If Cells(i, 27).Value = "invalid" Then 'for no fix
UseNoFix = UseNoFix + Cells(i, 34).Value
UseNoFixZ = UseNoFixZ + 1
End If

Next i

Cells(z + 8, 27).Value = "invalid ="
Cells(z + 9, 27).Value = "2D-Fix ="
Cells(z + 10, 27).Value = "3D-Fix ="
Cells(z + 11, 27).Value = "DGPS/EGNOS-Fix ="
Cells(z + 12, 27).Value = "Dead Reconning ="
Cells(z + 8, 28).Value = QualInv
Cells(z + 9, 28).Value = Qual2D
Cells(z + 10, 28).Value = Qual3D
Cells(z + 11, 28).Value = QualDGPS
Cells(z + 12, 28).Value = QualDead
Cells(z + 8, 33).Value = "Use 1 .. 2"
Cells(z + 9, 33).Value = "Use >= 3"
Cells(z + 10, 33).Value = "aver. use not fix"
Cells(z + 11, 33).Value = "aver. all, >=0"
Cells(z + 12, 33).Value = "aver. >0"
Cells(z + 8, 34).Value = Use31
Cells(z + 9, 34).Value = Use32
If UseNoFixZ > 0 Then
Cells(z + 10, 34).Value = Format(UseNoFix / UseNoFixZ, "##0.00")
Else
Cells(z + 10, 34).Value = Format(0, "##0.00")
End If
Cells(z + 11, 34).Value = Format(Use33 / Use34, "##0.00")
Cells(z + 12, 34).Value = Format(Cells(z + 7, 34).Value, "##0.00")

End Sub
Function test()

Cells(z + 8, 35).Value = "Zeilen, sat in use 1 und 2"
Cells(z + 9, 35).Value = "Zeilen, sat in use ab 3"
Cells(z + 10, 35).Value = "Mittelwert fix quality invalid, "
Cells(z + 11, 35).Value = "aver. use not fix"
Cells(z + 12, 35).Value = "aver. all, >=0"
Cells(z + 12, 35).Value = "aver. >0"
Cells(z + 13, 33).Value = "UseNoFix"
Cells(z + 13, 34).Value = UseNoFix
Cells(z + 14, 33).Value = "UseNoFixZ"
Cells(z + 14, 34).Value = UseNoFixZ
Cells(z + 15, 33).Value = "Use1...2"
Cells(z + 15, 34).Value = Use31
Cells(z + 16, 33).Value = "Use >3"
Cells(z + 16, 34).Value = Use32
Cells(z + 17, 33).Value = "in use all"
Cells(z + 17, 34).Value = Use33
Cells(z + 18, 33).Value = "in use all, Anzahl"
Cells(z + 18, 34).Value = Use34
Cells(z + 13, 28).Value = Cells(z + 8, 28).Value + Cells(z + 9, 28).Value _
+ Cells(z + 10, 28).Value + Cells(z + 11, 28).Value + Cells(z + 12, 28).Value
Cells(z + 14, 28).Value = Cells(z + 13, 28).Value + 6

End Function

Das Makro "test" ist nicht Bestandteil der offiziellen Version, es dient nur zur Verdeutlichung und Anzeige einiger Variablen.

Vielleicht hat jemand Zeit und könnte sich zur Übersetzung mir einschalten. Auch die Postings mit peterpu, in denen m.E. auch Details stehen, kann ich nicht voll verstehen.

Danke. Die Testversion hänge ich nochmal hier an. Eine Erklärung der Variablen ist im Teil "Quality" kommentiert. Am besten ruft man es aus Excel über "Extras/Makro/Makros", "Qulity/bearbeiten" auf, dort sind die Kommentare wegen der grünen Farbe besser lesbar.