Posted: 19th Jul 2011 00:51
Edited at: 19th Jul 2011 00:58
The method I use in Excel is:
First a section with two columns containing the vertex count and the index count.
A second section (vertically) where the columns hold respective X#,Y#,Z#,u#,v#,nx#,ny#,nz#,and diffuse values for each vertex (in order). You can use additional or fewer parameters. With Ian's command, you set the FVF depending on which categories of vertex data you are including. (nx# etc. are normals, but you can sometimes avoid this using the Set Object Normals command after you have created the object with zero default values).(Use decimal number values for all but the double word parameters. So for full diffuse I would use 0xffffffff, setting the column format to "Text"). You will find that in many cases, using formulas for values speeds things up, especially when making angles or curves. For example, if you are making a polygonal disk of say, 16 sides, triangulated from the center, you need only enter a few formulas in the cells and copy them down. Excel takes care of all the calculations. Likewise, using formulas for the u#,v# data that express them as functions of the x#,y# and/or z# values is a great timesaver.
I then add a third series of rows which list the indices. Three (one triangle) to a line. Even here I have found opportunities to use cell formulas to calculate a series of triangles and automate data entry.
With regard to all three sections: at the far right I have a calculated column that arranges each entire line into a properly formatted string Data statement (i.e. beginning with the word "Data" and having comma-separated values). I highlight-select the relevant section of that column, copy, and paste into the appropriate data section in a dba module.
DBP produces the object at almost lighting speed compared to loading the object from an x or dbo file, in my experience.