You the experts are going to have to tell me if this is even possible!
I need to build a database? Software? For my nutrition business, to be done in 3 phases (3 separate projects) in this order.
1. It will have to take certain inputed variables to calculate (calculation will be provided) Metabolic body weight, and a few others which will be multipled by nutritional value constants to come up with exact nutritional requirements.
i.e. If the metabolic body weight calculates to 10, and the multiplier for Vitamin A is 5, the end result would be Vitamin A requirement is 50.
This will be repeated for all nutritional requirements - figure 35 nutrients maximum total.
The end product would be to be able to print out a list of all nutrients as well as their exact values (when multiplied by the MBW) as well as the unit of measure (will be provided). Assume general client info would be included with inputs.
Because the calculations and total data entered would be finite, I would think a fixed cost on this part could be bid.
2. I need a linking (? not sure if this is the correct term) database where I can input ingredients as well as their nutritional content in 1 oz measures. If you were to look at a USDA or other nutritional values web site, it will give you the idea of what I will be inputting.
This should be bid fixed cost, you would be doing the 'programming', I would be doing the data entry.
3. The hard part: The ultimate job of the program will be, after determining the exact nutrient requirements (part 1) the user will be able to input various food items to come up with a recipe that will match the nutrient requirements determined in part 1. So, for example, if a person were to input 3 ingredients , the program will tell him how much of each to use to meet the nutritional goal, as well as identify any deficiencies. There will be several adjustments to this part to make it work, because of that, I would assume this phase would be charged hourly. This would also be the phase you may have to drink a lot of alcohol because I have to see the program work before I can see what the changes would be, and changes may cause me to decide there have to be more changes. So, this is the part I become annoying!
I am not a computer person so I have no clue what the most efficient or effective way to do this would be. I have done some mockup excel spreadsheets that show it's theoretically possible, but it's not clean enough to work very well with.
Part 1, maybe it's a quick, 30 day project, part 2, also maybe a pretty fast job, but part 3 is going to be very tricky. (Also, proceeding to part 3 will depend on how fast I get the data entry done for part 2!)
I'd like to keep working with the same person through all 3 phases because, chances are, after this is all done, there will be changes, either add ons or tweaks. Best done with the person who made the program.
Please tell me how you propose to build the program - software used, etc. and, obviously cost. If there is any more information I can provide - not sure if sending the nutritional tables, calculations, etc. will give you a better feel, please let me know.
I won't be making an overnight decision on hiring as there will probably be many questions both ways. I will notify everyone, however, once a hiring decision is made.
After posting this project, I received 2 pages of bids within 2 minutes. I will NOT be responding to these people. I will ONLY respond to those who have read the project and have submitted a proposal.