Preserved Topic: Spreadsheeting (Page 1 of 1)

This should prbably be in a programming forum, but I don't really know a relevant one. SO here goes. I'm trying to create a spreadsheet that does the following:

1. Takes information from five forms fields
2. Uses two form fields for the actaul information going into the spreadsheet (in this case a name and a 3 letter code)
3. Uses one of those form fields to determine which of the five other sheets in the workbook to place the information in.
4. Uses the next form field to determine where down the column to place the information
5. Uses the next form field to determine have far allong the row to place the information.
6. I want it to also remember the information for one week, so that the same peice of infomration cannot be entered more than once on each sheet, and no more than three sheet at any given time.

Besides this, I also want it to be constantly password protected so that when you tell it to process the information, it asks for a password.

Any ideas guys and goils?




In the beginning, there was the word...and the word was 'God', although by the time it reached the other end of the phone line... the word was 'Gznd'

Oh, sure. No problem. Would you like fries with that?

[can't help, just being a smartarse; skip this post if you like ]

What you'd need is a struct to handle the actual variables. you set it up with five members, each of which containts the pertinent information. Assuming all the variables are integers and one string:

struct Record

{

  int field1, field2, field3, field4;

  string field5;

};

Now, this is okay if the data types are static, but if you want them to be more dynamic, you'd need a template struct:

template <typename ValueType>

struct RecTemp<ValueType>

{

  ValueType field1, field2, field3, field4, field5;

}

However, this would mean you would only have one type of data. Therefore, you'd probably want a mix of structs and classes. That is, if you want a dynamic database.

Now, you could probably do this in MS Access and Excel, but I have no idea how and you didn't specify that's what you were using. So, I'll need a team of about two people besides myself, and $40,000 and we'll get you a db program that fulfills the provided requirements in 6 - 8 months.

Oh hardy-fucking-har har.




In the beginning, there was the word...and the word was 'God', although by the time it reached the other end of the phone line... the word was 'Gznd'