Find Ship :
SELECT z_pk, ztitle FROM zbsmanagedship



Ship code :
SELECT zcolor, zprototype, zquaternion, ztranslationx, ztranslationy, ztranslationz FROM zbsmanagedunit WHERE zship = ???



Parts code :
SELECT z_pk, zname FROM zbsprototypeunit



Comparison Parts :
=OFFSET(Sheet2!$B$1,C1-1,0,1,1)



Generate code :
="<dict><key>color</key><integer>"&B1&"</integer><key>prototypeName</key><string>"&A1&"</string><key>quaternion</key><integer>"&D1&"</integer><key>translationX</key><real>"&E1&"</real><key>translationY</key><real>"&F1&"</real><key>translationZ</key><real>"&G1&"</real></dict>"



/Library/Preferences/com.phyzios.Battleship.plist

/Documents/.db/battleship.sqlite

/Battleship.app/Prototype.plist

/Battleship.app/Mission.plist