vba_valuation
1.0.0
Software: VBA Excel
Version: 1.0
Date: Jan 21, 2018
Author: Dirk Mueller
Purpose
The objective of this questionnaire software is to track the output of clinical collaboration sites, their added value and impact to Company, by giving numbers on a scale for each criterium. Company's contributions are also given as input. The formula to calculate the balance of in- and output is not (yet) part of this software. The collected data and all associated information are placed in a worksheet table for further analysis.
Fig 1: Snapshot of entry form. Company could be any organization wanting to assess the value of its collaborations.
When moving to the next form the following input mask is shown:
Fig 2: Snapshot of input mask for items that the partner brings to the collaboration, and of those Company contributes.
Fig 3: Snapshot of source code that processes one particular type of input and takes care of sanity checks.
After filling in yet another form all the data will be stored in an Excel worksheet for further processing.
