Excel Plate Formatting Sheet

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

Our client’s lab receives sample information in an Excel file, which is then used to create multiple plates for analytical testing. The same sets of samples are usually split into three method plates, which are different in position on the plates. Different methods plates also use different reagents for QC, and then the data is used by outputting it to method-specific acquisition sheets. The acquisition sheets are formatted in Excel, but then they are pasted into our analytical testing software to create the actual run for that particular plate. The acquisition file literally tells the software, and therefore the machine, how to run the batch of samples. The file also tells the machine which sample number or standard is in each well of the plate, and the machine/software uses this information to associate the sample results or QC results with the appropriate sample ID/QC for the run. The testing parameters for a patient sample are determined by these sheets, and the sheets make sure that the correct results are paired with each patient. The conversion of the input information into the correct acquisition templates is therefore absolutely necessary for our client’s lab to report accurate patient results in a timely manner. There is no room for error, and the template sheet has to work right every time. The lab has been manually scanning the barcodes on each sample test tube into each method template before they run the samples, but the lab recently had to re-plate an entire batch of samples because some of the test tubes had been moved (long after the actual plates had been created from the samples). We need a way to keep everything streamlined and accurate, and we would like some way so that the same (original) plate input file can be used to create all of the method plate templates for any day/batch. The acquisition files need to have a plate map that identifies the QC names, as well as the sample accession (ID) numbers, as they are on the plate (including the plate coordinates). Each output sheet also needs to output the correct acquisition template(s) for creating the run. I have samples the two different forms of input sheets, as well as the templates for all 6 output files. There are 6 because each of the 3 method plates may be run with a calibration curve or without a calibration curve. I don’t know how exactly you would do this, but I would like some simple way to just select the input file, select a method, and then have the proper acquisition sheet/plate map output for us. The input sheet will show whether or not there is a curve on the plate, but they may have to look at the input file and then select whether or not it has a curve. That would be fine, but ideally we think there would be less room for error if they never have to mess with the input sheet (and just have the Excel sheet do it). They are rechecking every sample each time they run a plate right now, and they would like to have something quickly because it is really slowing down the lab workflow.

Data Entry Data Processing Excel Mathematics Visual Basic

Project ID: #17167288

About the project

12 proposals Remote project Active 5 years ago

Awarded to:

KISSMethods

Our company has performed work for your clients before, and thank you for accepting our referral. We can complete this project in 2 days, and we should be able to identify the curve plates from the source data. Pleas More

$277 USD in 2 days
(0 Reviews)
0.0

12 freelancers are bidding on average $438 for this job

Nidhijain123

hello, I can do this project. I have experience in doing such project, Will deliver on time with 100% accuracy. Thanks Nidhi

$555 USD in 10 days
(103 Reviews)
6.3
fatimatuzzohura

Hi, I am experienced on Microsoft Access , Excel and VBA. I can start your job immediately also. Please contact me to discuss the project in details. Thanks

$555 USD in 3 days
(144 Reviews)
6.2
aanvikm

Hello Sir, I am an expert with Excel and VBA programming and would like to discuss this project you. May I please request you to open chat and discuss? Thanks Aanvik

$777 USD in 10 days
(39 Reviews)
6.3
vijayvizzu7

I have 10+ years of experience in Advance Excel, VBA. Macros and other office integration development. I am sure i can handle your request

$388 USD in 10 days
(2 Reviews)
1.3
officeassistant7

Dear Hiring Manager Thanks for posting your project. I have six years experience as data entry operator. i have also complete 10+ projects in past similar to this project. I have good knowledge of :- MS Word More

$333 USD in 1 day
(0 Reviews)
0.0
jamesskymedia1

We have done similar work before, if you want we can create you a FREE demo. Yes that was not a spelling mistake we will create you a FREE demo before you award the project to us. Click on that chat icon below to find More

$388 USD in 10 days
(0 Reviews)
0.0
rohit4858

Hello Read your description and would like to help you with same as we have done very similar kind of projects earlier. My team has all the skills required and mentioned by you to complete the project with quality in More

$555 USD in 10 days
(0 Reviews)
0.0
tejraj23

Hello Sir, BEprojects is the Engineering Design Service Provider to supply 3D Modeling, Product Design & Development, CAD Drawing, FEA & CFD Simulation, Mechanism Video, 3D Printing, Manufacturing & Fabrication. Prom More

$250 USD in 3 days
(0 Reviews)
0.0