I need an EXCEL expert that can Massage excel data so we can prepare for an import
$30-250 USD
Dibayar saat pengiriman
We have an excel sheet that has a column of data that is formatted the following way: Ideally they will work for us on a need-by-need basis, but right now we have a large import we need to clean up. I am attaching a sample sheet for you to review. This grouping will be on Category CPU, Server, Laptop. Review Column H
I need this done in the next 20 hours.
It is approximately 15K line items of inventory.
Sub Type: Server / Form Factor: 2U / Processor Manufacturer: Intel / Processor Family: Core Xeon / Processor Model: E5-2650 v3 / Processor Gen. (i-Series Only): Not Applicable / Speed: 2.30GHz / Core Count: 10 / Processor Manufacturer: Intel / Processor Family: Core Xeon / Processor Model: E5-2650 v3 / Processor Gen. (i-Series Only): Not Applicable / Speed: 2.30GHz / Core Count: 10 / Size: 16GB / Memory Type: DDR4 / Speed: 2133 / Error Correction: ECC / Size: 16GB / Memory Type: DDR4 / Speed: 2133 / Error Correction: ECC / Size: 16GB / Memory Type: DDR4 / Speed: 2133 / Error Correction: ECC / Size: 16GB / Memory Type: DDR4 / Speed: 2133 / Error Correction: ECC / Size: 16GB / Memory Type: DDR4 / Speed: 2400 / Error Correction: ECC / Size: 16GB / Memory Type: DDR4 / Speed: 2400 / Error Correction: ECC / Size: 16GB / Memory Type: DDR4 / Speed: 2400 / Error Correction: ECC / Size: 16GB / Memory Type: DDR4 / Speed: 2400 / Error Correction: ECC / Size: 16GB / Memory Type: DDR4 / Speed: 2133 / Error Correction: ECC / Size: 16GB / Memory Type: DDR4 / Speed: 2133 / Error Correction: ECC / Size: 16GB / Memory Type: DDR4 / Speed: 2133 / Error Correction: ECC / Size: 16GB / Memory Type: DDR4 / Speed: 2133 / Error Correction: ECC / Size: 16GB / Memory Type: DDR4 / Speed: 2400 / Error Correction: ECC / Size: 16GB / Memory Type: DDR4 / Speed: 2400 / Error Correction: ECC / Size: 16GB / Memory Type: DDR4 / Speed: 2400 / Error Correction: ECC / Size: 16GB / Memory Type: DDR4 / Speed: 2400 / Error Correction: ECC / HD Removed: Yes / Services Performed/Requested: Hard Drive Wipe X 1 / HD Manufacturer: Seagate / HD Model: ST300MM0008 / HD Serial#: S420MJ2L / HD Capacity: 300GB / HD Interface: SAS / HD Form Factor: 2.5 / HD Source Serial #: 49GL482 / Storage Type: 10000 RPM HDD / HD Removed: Yes / Services Performed/Requested: Hard Drive Wipe X 1 / HD Manufacturer: Seagate / HD Model: ST300MM0008 / HD Serial#: S420MHVE / HD Capacity: 300GB / HD Interface: SAS / HD Form Factor: 2.5 / HD Source Serial #: 49GL482 / Storage Type: 10000 RPM HDD / Model: Standard SATA AHCI Controller / Model: PERC H730 Mini / Model: Standard SATA AHCI Controller / Graphic Card Interface: Integrated Graphics / GPU: Matrox G200eR2 /
I need someone to Go Through EACH Row and Parse the Memory, Hard Drives, and Processors, but most are going to be the memory.
When you parse the purple you will Sum the GB of all the sticks and call it Total Memory and add it in the format below. Then you will add the configuration. So in this case it is 16 X 16GB DDR4. but if it was 8 sticks of 8GB and 4 of 16GB I need you to parse it as 8 X 8GB, 4 X 16GB
You will also summarize Memory Type, and Speed.
ID Proyek: #36288907
Tentang proyek
Diberikan kepada:
Hi, I have gone through the Job details and am interested in taking it up. I am working now on the memory part, and I will deliver the required tasks before your deadline and accurately. I’m Ahmed Hassanein. I’ve been Lebih banyak
41 freelancer rata-rata menawar $127 untuk pekerjaan ini
Greetings, As a highly skilled Excel specialist with 10 years of experience, I am confident in my ability to complete the Excel job you have to perfection. I have expertise in the following areas: - Formulas and fu Lebih banyak
"Sir, EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, AUTOMATION, TEMPLATE, REPORTS, FORMULA'S, DASHBOARD in EXCEL Advanced Level Expert. This is my field and I can comp Lebih banyak
Hello Robert, I can assist you to extract and count Size, Memory Type, and Speed. Could you please send the full list? Thanks Please refer to my similar job https://www.freelancer.com/projects/excel/Extract-multiple-UR Lebih banyak
Hello Bill, I hope this message finds you well. I will be able to help you with your project. I read through the description and it sounds like I am just the right person for it. I have the right skill Lebih banyak
Greetings Thanks for checking my proposal. I have understood your project and can start your project immediately. I am full- time freelancer having job experience of more than two decades. It included more than decade Lebih banyak
Hello, I am an Excel and VBA/Macro expert. I have thoroughly read the requirements/instructions and checked the attached Excel file and screenshot. I offer my services to complete parsing the Memory, Hard Drives and Pr Lebih banyak
Hi, I'm Access/Excel/vba/SQL expert. I can help you with your Excel problem . I'll solve it in next 20 hours. Please, contact me. Zurab
I have read your project description and think I can help. Let’s chat in more detail about your project's needs. I have experience in Virtual Assistant. Please check my profile for related Click on the "CHAT" butto Lebih banyak
Hello I am a professional python developer. My main specializations are automation, web scrapers and bots development. I have already developed over 200 scrapers. From the simplest (for example, a competitor's price Lebih banyak
Hello ! I have gone through your requirements of "need an EXCEL expert that can Manage excel data so we can prepare for an import" and want to offer my services to complete this for you as I am a qualified accountant h Lebih banyak
Hi greetings!, I read your requirements I understand the work. I can provide you the work in very short time.I am waiting for your response Thanks. Regards, Ravindra..
Looks like a really simple task. I think I can do it using Python’s pandas library. Number of rows is not an issue since I’ll do it via coding (not manually).
Hello As a professional content writer and article writer , I believe I have the expertise necessary to deliver high-quality work that meets your needs. To begin, I would like to provide you with a brief overview of Lebih banyak
Dear Hiring Manager, Greetings, I have read your project details and I can complete the project flawlessly within the stipulated time. Please message me for further communication. Thanks
Dear Client, I hope you are well! I have read the description of your project and I can do your Data entry work. I am an expert in computers and know everything and I'll be able to do your work with accuracy and effi Lebih banyak
Dear Hiring Manager, I read with interest your job posting for "Data Entry and Virtual Assistant". I have the necessary skills and experience that you need. I would make a valuable addition to your company by providin Lebih banyak
Hello Respected, Hope You are doing Well. I saw your Project that is the best opportunity for me and I am interested in this because that skill I have which need to complete this project. As you said you need to manag Lebih banyak
Good Day! This is Maryan, licensed chemical engineer looking for new work opportunities. I am a quick learner in a fast paced environment who seeks to submit before the deadline. I am experienced in Data entry and I a Lebih banyak
I can assure you I'll do your work at the exact time that I described and in appropriate fee, and I have a experience of this work before
Hi sir my name is Amol. sir I read job description and I can do your project. i can ever work on urgent basis and complete your project soon. contact me for more information.
