I am looking to create a smart form in excel that will:
1. Includes standard entry fields, such as:
b. Contact details
c. Location address
d. Site type etc (drop down list)
e. Cost Centre,
f. Approver details
g. Etc – nothing too clever, there may be some more fields
2. Parameters related to the Site:
a. Number of terminals (a numerical value)
b. Expected volume of activity (a numerical range, drop down list)
c. Type of Request (new/change)
d. Reason for request (drop down list)
e. Free form field of entry
f. Requested technologies (drop down list) – likely to be 5 to 7 boxes, not all need to be selected
3. Based upon 2.a to 2.d., the Excel file shall perform a verification of the Requested Technologies and provide readily identifiable messages identifying what requested technologies are “acceptable” (within agreed parameters) or “Unacceptable” (outside of agreed parameters).
4. Creates backend output – utilising most/all of the fields described in 1. and 2. above that will need to comply with certain parameters to support the upload into another system. Such backend output may also include a macro for the creation of a CSV file for upload.
Currently, I’m seeking a ROM quote in order to determine the business case and seek approval to proceed. Please don’t lowball and think you will be able to scope creep. I want a good quality job at a fixed price. If you need additional information please ask. I may not be able to give you much more information, if you need to make assumptions, please ensure that they are reasonable and practical.
18 freelancers are bidding on average £40/hour for this job
Hey, I am interested in your project and can work with you. Your timely communication will required to complete your project in reasonable time. Please discuss if you have any questions.