Create Excel Template with Macro for automated sortation and simple time analysis of imported CSV-Data
$30-250 USD
Paid on delivery
he music students of our university are able to pick up a key to over 60 (usually locked) The music students of our university are able to pick up a key to over 60 (usually locked) practicing rooms via a KeyWin-Box, which they access with a personal badge. To maintain a fair use, the students are only allowed to practice up to 2 hours per room during rush hours (Mo-Fr from 9am to 6pm), then they have to bring back the key and pick up a new one or give it to someone who’s been waiting because all rooms are occupied.
The KeyWin-Box-Protocol produces a CSV (UTF8)-Log, which can be imported into Excel. We want to be able to automatize the log check to warn or block students who don’t follow the rules.
The log data contains columns like date (A), time (B), action (C), user (D) and key (E). We are talking about over 30’000 logs within 10 days. Analyzing just one day and filtering out all the “bad guys” in the log takes manually over an hour. Unfortunately I don’t know how to program a Macro. I assume it won't take much longer than a few hours to program the macro. All the steps are explained very detailed in the attached file.
The data in the attached excel sheet is dummy data of course. And just you know: It's the students, who want this semi-automatic control to happen, so we can count with a fair play ;-)
Project ID: #10989537
About the project
35 freelancers are bidding on average $144 for this job
Hi, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful
Hi: I understand that you want to upload the log from the Key-Win Box and generate the list of students who do not follow the rules defined by you. This can be very well achieved with a macro in Excel. Please note that More
hi. checked the documents. I can write the macro you need (actually it is more like a series analysis with some IF loops) Lets discuss more at chat.
Hi, Thanks for very detailed and clear explanation in the word and excel docs. I've studied them all completely. Now, all I need is just your csv sample for testing purpose in the importing process. Feel free t More
hi I can provide you an automated system, which can import the generated CSV automatically, read the logs and perform actions based on whatever settings are applicable. The same can be enhance by time. I can also d More
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega More
Hello, My name is Chris and, as you can see from my profile, I have 15+ years experience working with Excel/VBA and 13+years teaching them both (all levels). I read carefully the Makro_rules doc and reviewed the xls More
Dear Sir/Madam, I have 3 years of experience in Excel VBA programming. I work as a business data analyst Ford Motor Company creating automated reports and dashboards on car sales figures of 21 European countries. More
Hi, my name is Daniel, i am an Excel Expert and vba programmer, my proposal is create a macro where at the beggining you will have to find/open the csv file, and then the macro will do all the analisys that you want
I am a postgraduate in finance (MBA) with more than 5 years of experience having expertise in Excel, and VBA. Currently working in an MNC Analytical company on a large financial model including dashboards and presenta More
Hello, this is Sourabh Gupta from New Delhi :) I am an advanced VBA programmer. I have been a part of Excel Forum for many years and today I stand at the post of "FORUM EXPERT" at the forum and among the top 111 mem More
Dear Sir/ Madam I'm a professional VBA, VB and C# developer. I have 7+ years of experience in MS OFFICE and 4+ years of experience in VBA, VB and C# development. If you want your job done professionally and on time, More
Iam expert in excel manipulation and VBA Iam thinking also to implement you a java desktop program if that interests you thanks
Hello! I'm a graduate of Michigan State University with a Bachelors Degree in Computer Science. I have 5+ years working with excel and scripting (VBA). I could achieve this task for you in no time and could even write More
Hi, I am interested for you project. I am able to hard work and I guaranteed that you will fully satisfied after hiring me. Thank you -Sajib I am expart in vba
I am an excel macro expert for almost 10 years experience. I can do excel macros, pivot tables, formula calculations, charts and others.
