I have an excel document that's already built that i would like to email out to golfing individuals. This excel document has several cells that need input data from an individual. Essentially what i am trying to build is a golf scorecard. The excel document already has all the calculation formulas in there that a person needs. What the excel document does not have in there is the individuals personal information (e.g. name, date, number of players for that particular day, golf handicap, golf course name, etc...). I would like to build a form where users can go online and input their information, (e.g. Name, Date, Golf Course Name, friend names, etc) into a form and have it populate that data into the excel spreadsheet. Users will essentially go online enter the data needed for the spreadsheet, then proceed to a PayPal check out area where they will buy their scorecard. Once they purchase the excel scorecard and the funds are processed through PayPal, the user will receive an email with the excel document attached. The excel document will arrive as a "locked" workbook, this way users cannot modify the rows and column for continual future use. The locked spreadsheet will contain all of the data the user entered from the online form plus some empty unlocked cells where the user can enter their score later on that day.
I already have a website built that is running on a Linux server and coded with .PHP, so this will have to be written to fit within this framework. I am attaching a PowerPoint slide further detailing how i would like the process flow to work. It should provide more of a visual.
Once you begin working on the project i will send you the Excel document so that you can see which cells need to be made into input form fields.