I have a series of reports that are downloaded from an online service. They always have different names, but their format is always identical. Each report includes a personal scorecard for a different user.
Each scorecard contains a list of tests that the user did or did not complete. There are 7 different types of test, each test is labelled in the scorecard as to what type it is.
I have an existing spreadsheet that I manually enter results into, compiling the user's name from each scorecard, along with how many of each type of test they completed.
I need an automated system that will harvest the data from each scorecard and enter it into the final spreadsheet for me.
I have included the following attachments which outline my desired workflow.
Stage 1 Data: Collect the Login and Username field from each file
Stage 2 Data: count how many instances of each type (A, B, C, D, etc) of test there are. Only count instances that have a defined percentage score next to them.
Stage 3 Data: input the name, login, and instance count for each Test type into the fields highlighted in this screenshot. All the other fields are calculated fields that base their calculations off the numbers in the highlighted fields. Then create a new row for each scorecard file in the folder.
Dear Sir/Madam, I have 12 years of experience in automation of data processing and analysis using Excel and VBA . My recent projects on Freelancer include preparation of an automated equities portfolio reporting spread Plus
29 freelance font une offre moyenne de $105 pour ce travail
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among Plus
Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have b Plus
Hi Sir/Madam. Ready to start. Thanks. Our slogan : ** What we do, you can find elsewhere ** ** How we do it, makes all the difference **
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 40 projects, almost 35+ are complex VB/VBA projects, hence i can definitely deliv Plus
Hi, i m serious freelancer with 100% completion rate and i can create this macro for you. Can you please upload the rest of the pictures so i can get clear picture of what needs to be done. Also i m interested in how m Plus
I have created many macros in Excel to perform various tasks. Your projects appears simple. Please attach the Excel file instead of the png and also give the template of the Excel spreadsheet into which you are enterin Plus
Hello, I can help you with the project. Please check out my profile .... We can go with Excel VBA and some formulas in order to perform calculation. There would be some type of a button for you to click and have Plus
I have the expertise in Excel and can complete the task as per your described specification, accurately. Ready to start work immediately
We excel at Excel automation! Can show you samples if required. Our bid is for $72. Negotiable. The Website commission is $8. Our profile page with reviews: https://www.freelancer.com/u/sureshiyengar.html (may sh Plus
Hello, I'm a VBA expert with over 14 years of experience, I will be delivering a high quality an professional solution to your project, thanks in advance for considering my proposal.
hello. i can do this for you. i have experience and expertise in excel and macros. please see my feedbacks.
Hi, This is Jatin. I have good knowledge on Excel Macros. I already have a macro to import the data from multiple excel workbooks. I can guarantee the delivery on the same day. Thanks & Regards, Jatin R
Hello , I would like to work on your project,. I have great experience using excel and macros / vba ,parsing and manipulating data in excel. I have had similar works, for example, one of them: a macro will copy every Plus
Hi Im an expert in Microsoft technologies with over tan 20 years of experience in banking sw development Regrads Carlos
Hey! Hope your having a fantastic day! My name is Shali Bala and I am a third year science & technology student at Uva Wellassa University. I believe I am the right candidate for this job because I am fluent in English Plus
Hi Greetings!! I am interested to work with you. I have worked prior on this kind of assignments. I would like to take brief info about the work as how critical is the work what exactly need to be done, after that o Plus
Hello Sir. I'm Japanese national, native Japanese speaker. Now I'm staying in Bangladesh. I'm always working on Windows application development, using VB.NET, C#, etc. VBA is my fundamental tool. You explain Plus
ok, very good i can help you it is very easy, but it needs some time and effort i can provide you program under acceptable price. plz check pm hope to contact with you thanks