Suoritettu

Excel Plate Formatting Sheet

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.

Taidot: tiedonsyöttö, tietojenkäsittely, Excel, Matematiikka, Visual Basic

Näytä lisää: daily food cost report format in excel, costing sheet in excel, recipe format in excel, measurement sheet format in excel free download, production register format in excel, costing worksheet, catering worksheet excel, recipe formats worksheet, convert excel seet access sheet, create sheets excel using master sheet, excel macro formatting phone, excel create data sheet, excel calorie counting sheet, excel formula call sheet, excel quality control sheet, excel dispatch spread sheet, php excel 2007 formatting, excel basic lastline sheet, excel customer outstanding sheet, vba excel manual calculation sheet

Tietoa työnantajasta:
( 0 arvostelua ) North Richland Hills, United States

Projektin tunnus: #17167288

Myönnetty käyttäjälle:

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 Lisää

$277 USD 2 päivässä
(0 Arvostelua)
0.0

12 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 10 päivässä
(103 arvostelua)
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 3 päivässä
(144 arvostelua)
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 10 päivässä
(39 arvostelua)
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 10 päivässä
(2 arvostelua)
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 Lisää

$333 USD 1 päivässä
(0 arvostelua)
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 Lisää

$388 USD 10 päivässä
(0 arvostelua)
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 Lisää

$555 USD 10 päivässä
(0 arvostelua)
0.0
Prabh1995

Hii Sir, I have more knowledge and experience in this filed as you post [login to view URL] I understand your views what actual have you [login to view URL] this way I will complete your project with 100 % quality and accuracy within less Lisää

$277 USD 5 päivässä
(1 arvostelu)
0.0
tanphodk192

hello. i'm [login to view URL] nice to meet you. i can help you do this job. i can good finish. believe me. thanks!

$350 USD 4 päivässä
(0 arvostelua)
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 Lisää

$250 USD 3 päivässä
(0 arvostelua)
0.0
$555 USD 10 päivässä
(0 arvostelua)
0.0