Đang Thực Hiện

Design an Excel spreadsheet

I’m looking for someone to draft a simple to use excel spreadsheet that will include the following;

- Column B – Labelled Generic Code - partial barcode number (partial barcodes are scanned using a USB connected barcode reader out of book for various inventory items)

This partial barcode is then deciphered into Column C;

- Column C – Labelled DESCRIPTION – an item name taken from a list on a separate worksheet page

The following information is then added to the barcode;

- Column A – Labelled IDENTIFIER - sequential numbers from 1 to ?? (next scan of any Generic Code automatically has the next number attributed to it)

- Column D – Labelled TEST DATE - populated with today’s date when the item is scanned

- Column E – Labelled RETEST IN - left for manually entered data and used to populate Column F

- Column F – Labelled RETEST DATE - populated with todays date PLUS (the number of months manually entered in column E (eg, 6, 12, 36 or 60months)

- Column G – Labelled TEST RESULT - left blank for manually entered data that has no influence on other columns

- Column H – ITEM BARCODE - the actual item barcode updated from Column B Generic Code and including Identifier data (from Column A)

- Column I - A###### - left blank for manually entered data that has no influence on other columns but will print out on labels

- Column J - B###### - left blank for manually entered data that has no influence on other columns but will print out on labels

-

The requirement is to be able to use a barcode scanner to scan a Generic Code (ie. partial barcode) from our inventory book and have the data automatically populate a line on the spreadsheet. Once populated, we need to be able to send the data to a label printer which will pull information from a single line of the spreadsheet and print a label containing information contained in Columns A, C, D, F, G, I & J as well as a barcode generated from data in Column H.

We also need to be able to scan the actual ITEM BARCODE (ie. Column H) and have that scan repopulate the corresponding line on the spreadsheet, updating only Column D to current days date and therefore influencing Column F but not impacting Column A (ie. the IDENTIFIER & therefore the location on the spreadsheet doesn’t change)

Kỹ năng: Excel

Xem thêm: column design spreadsheet excel, beam design spreadsheet excel, xls excel spreadsheet bridge design, iphone design developer spreadsheet excel, convert numbers spreadsheet excel, convert numbers spreadsheet excel spreadsheet, convert apple numbers spreadsheet excel, excel spreadsheet files design, excel spreadsheet cool design, excel spreadsheet custom design, excel spreadsheet graphic design, excel spreadsheet graphical design, word spreadsheet excel, project status spreadsheet excel chart, excel convert text numbers commas

Về Bên Thuê:
( 1 nhận xét ) Nth Ryde, Australia

Mã Dự Án: #14823253

Đã trao cho:

bernardkh

Hi, the Excel seems pretty straightforward, it should take 1 or 2 days max; as long as you can iterate quickly and are clear on what you want. Relevant Skills and Experience I am a BCG strategy consultant, I have deve Thêm

$111 AUD trong 7 ngày
(0 Đánh Giá)
0.0

6 freelancer đang chào giá trung bình $154 cho công việc này

schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. i can do this Task as per your requirement. Relevant Skills and Experience I have the 5 years of e Thêm

$200 AUD trong 3 ngày
(176 Đánh Giá)
6.9
dvcontact

Hi, If you are looking for a professional and reliable Excel expert with proficiency in data analysis, I'm your ideal candidate. I'm highly experienced in producing mathematical solutions with Excel and I have a stron Thêm

$100 AUD trong 3 ngày
(7 Đánh Giá)
3.7
humayoonsheikh4u

A proposal has not yet been provided

$207 AUD trong 3 ngày
(8 Đánh Giá)
3.9
$155 AUD trong 1 ngày
(0 Đánh Giá)
0.0
furqanahmed55

Hello, I graduated from Boston University USA. I have a lot of experience working on excel. I never miss work and always deliver on time. My personal qualities are: - Detail Oriented, as handled many sensiti Thêm

$150 AUD trong 1 ngày
(0 Đánh Giá)
0.0