Part 1
The Items Sold Template has three datasets. The first is the Sales Data; this has several years of data and shows, by invoice number, what was purchased and the quantity shipped. Item Code is the field which lists the part numbers. The second table is Bill To information: by invoice number, who was the customer which purchased the items. Finally, Parts Data lists, by part number, the manufacturer and spray category or application of the part.
The initial model should include a drop down box for the Primary part number; invoice numbers of the transaction when the part was purchased; customer name and whether they are repeat customers for this part; a list of parts purchased on the invoice except the one in the drop down box. A PDF is provided for guidance, with two caveats’: First, you can make whatever model fulfills the requirements; two, this is not necessary comprehensive either vertically or horizontally, but the print area was formatted to fit something on one page.
Hint: on the Sales Data worksheet, generate a list of the Part Numbers sold, and the number of transactions they were part of. Then, develop a similar list of Invoice Numbers. This will give you an idea as the scope of the issue, both in terms of the maximum number of times a part was purchased, and the maximum number of parts that was purchased at one time.
Part 2
Design a table that will list all parts sold with the Primary part, the number of time sold, and number of times sold with a repeat customer as well as unique order. Also include the manufacturer and manufacturing category.
Hint: Link into the analysis in Part 1 and create two fields: one for the list of parts sold with the primary, and another indicating whether it was a repeat order or not. Create a unique list of parts, and perform the rest of the analysis.
Attached PDF Files contain outputs of what I am desiring the models to match. Raw data can be found in Items Sold Template Excel File. Please place models on new sheet in original raw data file.
Hello, I can help you with your project. You can check my reviews and portfolio to check my competence. Award me and I am starting right away. With regards, Tom
I am Data Entry, MS Word and MS Excel Expert. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high quality.
I have the sheet (with both parts completed) ready with me. Can email it to you once confirmed. I am Expert in Excel and have done numerous projects.
Message me in case you need any clarification.
In Microsoft Excel formulas I am confident in using Vlookup, If, And, Or, Sumif(s), Countif(s), and how to combine multiple formulas and use Sort, Filters, Data Validation, Conditional Formatting, Pivot tables. So I very confidence can give you what you want as soon as possible, I can start my work in any time.
Hi
I have 6+ years exp in data processing, formatting and entering in word, excel and powerpoint which includes formatting of plain text, tables, flowcharts and all other type. (e.g. TOC, header-footer, columns, subscript & superscript, hyperlinks, all excel formulea)
I also have Medical billing experience of around 4 years which includes charge entry, payment posting and other correspondence document maintaining.
Please provide me sample input and output, also please contact me on messenger so that I can start it asap.
thank you
sir, I have done a excel work a couple of days ago. So i have experience in this field. I can assure you that I will do your work as you asked. I'm looking forward to contact with you.
Hello,
this is quite simple database work that I believe can be done in less than one day.
I have 15 years of experience with Excel as well as other dabase tools as I was working in reporting and analysis jobs.
I am quite new at Freelancer but willing to work hard to fulfill your needs.
Thanks for considering me,
Stepanka Uchytilova
Yes I can complete this work within time with 100% efficiency. I use to do this type of work. My skill in MS OFFICE is very good. It’s definite that you will be satisfied with my work. My USP is that I can complete the work before scheduled time with 100% Accuracy.
So It will be very kind of you if you provide me the Job.
We are the Team of professional Article writers and DataEntry Operators, you can pay us on 100% satisfaction and we are ready to provide you unlimited revisions in our work
I'm highly interested about this opportunity and i'm ready to learn more about it. Please let me know more about the details and on what i need to do to be qualified. I am a hard-working customer support specialist. I've been with BPO industry for over 5 years. I have gained substantial experience and outstanding skills in customer service with strong written and oral communication skills. I was promoted as Resolutions Supervisor assigned to take escalated calls, trained and experienced in resolving customer complaints and promote conflict resolution. I am accustomed to working in fast-paced environments with the ability to think quickly and successfully handle difficult clients. I can do multitasking and can work under pressure. I also have great experience and a thorough understanding of sales and marketing.
I am flexible with the pay amount and have the time to focus on this project relatively quickly. I have much experience as an excel specialist and have skills that range from graphing and data processing to macros and list management.
Greetings,
I am an expert in creating Excel databases including drop-down menus utilizing Vlookup and formulas that summarize data. As part of the project I will include a dashboard to highlight the findings visually.
Thanks for you consideration,
Nathan