Analyte Import Tool (AIT) development

Completed Posted Oct 9, 2014 Paid on delivery
Completed Paid on delivery

The AnalyteImportTool will help users to populate the POOLING spreadsheet, by letting them specify which AnalysisResults file to add and which TestSubjectIDs the AnalysisResults apply to. we are uploading a movie to orient you, but refer to the other documents for application details.

The POOLING spreadsheet has columns for all of the Analyses types: CRP (48), VCAM, ICAM, Hu MCP-1, Hu MIP-1b (18), MMP-1 (1), MMP-2 (3), MMP-7 (7), MMP-9 (27), MMP-10 (29). Each Analysis Type occupies 6 columns, although only three of these will be populated with the AnalyteImportTool.

The POOLING spreadsheet also includes all of the Test Subjects Identifiers, in Column A. The identifiers start at 1 and end at 1698.

A sample POOLING spreadsheet is provided.

The AnalysisResults Spreadsheets contain results of one analysis per worksheet, for one set of 36 Test Subjects with consecutive numbers, in numerical order. There may be one or more worksheets in the spreadsheet: they must all be processed one at a time, while prompting the user to confirm selected ranges (to and from) before proceeding with the import.

All of the AnalysisResults spreadsheets contain the following labels in consecutive rows, somewhere in column B: X1,X1,X2,X2,X3,X3, (...) X36,x36. These labels identify the rows that are of interest. In all cases, the first row of interest can be identified in the same manner (it is the first occurrence of "X1" in Column B, that is followed by "X1" in the very next row of the same column, see video)

The COLUMN of interest may be any column between D and Z: it will contain the words "Obs Conc" in the row ABOVE the rows of interest.

In the AnalysisResults spreadsheet, results are presented one per row; in the POOLING spreadsheet, they must be presented two per row. To clarify: in the AnalysisResults spreadsheet, there are two consecutive rows with "x1" in the B column: these represent two attempts to analyse a sample for the same TestSubject. In the POOLING spreadsheet, there is a single row per TestSubject, and the two X1 values are presented in consecutive COLUMNS. A graphical representation of this statement is included.

A sample AnalysisResults spreadsheet is provided.

A flowsheet of the process is provided.

**************************************************************************************************************************

Considerations: must work in Windows Xp through 8; Microsoft Excel 2007 through 2013. Must work from a usb flashdrive. Must work without the need for Administrator-level access AT ALL. We intend to select a bidder no sooner than noon on Friday October 10 and no later than Tuesday October 13. The selected coder will be given a username and password for use with our Bloodhound ticket system, where all project communication MUST take place. Weekly reporting (every Friday) is a requirement as well.

**************************************************************************************************************************

In your bid:

- indicate cost for development of the application;

- proposed strategy: platform, etc

- timelines to deliver a fully-functional TESTED application

- cost for supporting the application for 60 days

- your agreement to post weekly reports every Friday

- your agreement to use Bloodhound for communication

Excel Visual Basic Visual Basic for Apps

Project ID: #6568055

About the project

4 proposals Remote project Active Oct 10, 2014

Awarded to:

gperete

- indicate cost for development of the application; $250 - proposed strategy: platform, etc Excel VBA, if there is only one user to edit a worksheet at a time - timelines to deliver a fully-functional TESTED applic More

$250 USD in 3 days
(8 Reviews)
3.3

4 freelancers are bidding on average $385 for this job

dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 215 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive More

$200 USD in 10 days
(45 Reviews)
5.5
abhinovpankaj

Hi, I am working as software professional in IT industry from last 4 years. I work on VB scripting along with VBA for MS office applications. Also developed various Desktop based application using Visual Studio More

$201 USD in 4 days
(6 Reviews)
3.0