OOB database and found errors

[Imp]

If somebody could convert this into a common database format this would be very useful, can anybody get this into microsoft office? Or if as you said you have time to improve the interface.
Otherwise needs someone who can use it & understands properly to report the errors.
Perhaps a screenshot of possible error results or cut & pasting into say a word document.
Completly from memory & have not done yet as designers said they work on after summer which suites me AAguns is the biggest area with errors by a long way.
Takes some real looking at though as think majority is cut & paste.
As said memory what it looked like to me.
1) Several guns seem to be generic & the odd one mixes the info from 2 generic guns, you can recognise the gun based on as named in some OOBs
2) The odd multi mount unit if come in 1,2,4 mounts info for one mount one entry looked a bit off say HE Kill for the Quad unit looked wrong.
3) Is a bit of a headache this area but in game terms the 3 major points are probably size (for fire at) & Range FC (for fire by) the odd minor discrepency in HE Kill probably wont impact the game much.
I do plan on looking at it at some point but have discovered you can explain a lot away by casting a human eye over the results & the good news is I think there are very few errors left a fraction of a % which is amazing considering the amount of info involved & the amount of times it has been updated.

[dmnt]

Originally Posted by Imp

If somebody could convert this into a common database format this would be very useful, can anybody get this into microsoft office? Or if as you said you have time to improve the interface.
Otherwise needs someone who can use it & understands properly to report the errors.

It's way too big for excel or any other spreadsheet program. The data consists of 86 columns and 34360 rows making it too slow and cumbersome for office programs. BTW, postgresql is a widely used open source database along with mysql, but I chose it because of better built-in functions and adherence to standards.

I do plan on looking at it at some point but have discovered you can explain a lot away by casting a human eye over the results & the good news is I think there are very few errors left a fraction of a % which is amazing considering the amount of info involved & the amount of times it has been updated.

Yes, the developers have indeed made a huge effort but I hope this can be useful in cross-checking and having each nation reported the same way. This can spot for example units with the out-of-line class choices, such as the Somalian Heavy O/M Artillery, which is 130mm and every other nation has Medium O/M Artillery as a class. Just a minor issue, but it helps you switch between the nations.

I'm currently replacing the data with official one, so please be patient. The results you see might be wrong as long as I haven't updated the whole database.

[DRG]

Originally Posted by dmnt

This can spot for example units with the out-of-line class choices, such as the Somalian Heavy O/M Artillery, which is 130mm and every other nation has Medium O/M Artillery as a class. Just a minor issue, but it helps you switch between the nations.

What are you talking about ? If your database says that your database is in error

There IS NO "Somalian Heavy O/M Artillery" using using 130mm guns ( UC 156 ) or ANY guns for that matter. All Off map 130 mm guns are UC 155 " O/M Medium artillery" in that OOB

Searching for Units of class 155 O/M Medium Artillery
229 - 122mm Platoon - Available 01/069 to 12/091
230 - 122mm Platoon - Available 01/075 to 12/093
231 - 122mm Platoon - Available 01/084 to 12/093
232 - 130mm Platoon - Available 01/076 to 12/090
233 - 155mm Platoon - Available 06/082 to 12/090
234 - 155mm Platoon - Available 01/086 to 12/090

and those are found in
210 Medium Battery - Available: 01/69-12/93
211 Med Howitzer Bn - Available: 01/69-12/90

Searching for Units of class 156 O/M Heavy Artillery
NOTHING

Don