Find Jobs
Hire Freelancers

Buildng VBA for excel program for citation analysis

$250-750 USD

Cerrado
Publicado hace más de 8 años

$250-750 USD

Pagado a la entrega
The goal is to create a program that will analyze authors' institutional affiliations included in their published scholarly work. The input to the program will be 3 sets of data. The first will be a list of all authors' last names. The second will be all of the papers published by a group of authors over a finite period of time. This data set will include the authors, title, and year for each publication, as well as a unique alphanumeric identifier (DOI) for each publication. All of this information will be in an excel spreadsheet. The first thing the program needs to do is read through the complete list of authors for each publication, identify the specific author of interest by cross-referencing to data set 1, and store that author name. The third data set will be similar to the second, but will contain only publications in which the authors affiliated with an institution/department/center of interest. The format of the data will be the same as the first data set. The second thing the program needs to do is to identify publications in the first data set that are not represented in the second data set, and return 2 values for each author for each year analyzed: total number of publications and total number of affiliated publications. In the end, the goal is to be able to determine for each author the fraction of annual publications in which that author affiliated with a specific institution. The attached sample data set contains pubs for 2 [login to view URL] first sheet includes their names and initials; the second includes all of their publications; the third includes all their affiliated publications.
ID del proyecto: 8301051

Información sobre el proyecto

35 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
35 freelancers están ofertando un promedio de $327 USD por este trabajo
Avatar del usuario
A proposal has not yet been provided
$300 USD en 2 días
4,9 (254 comentarios)
7,6
7,6
Avatar del usuario
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
$250 USD en 4 días
4,9 (334 comentarios)
7,7
7,7
Avatar del usuario
Hello! I work with VBA and data analysis for last 5 years, and have created hundreds of different script, including similiar to yours( and can show You examples). Thanks for clear specifications, and for attachment, I am totally sure, i can solve Your problem/You will have just one "Start" button, after pressing on it pog will do the rest( if You want more technical detail, i can explain them). I can start right now and finish it in one day. A have all skills You need for this project ( and can show You examples for your confidence) If You need somebody who can manage really difficult thing, I am right person, I am not indian who use recorded or stolen scripts, i have good background in VBA, and all my scripts work with 100% accuracy and performance. Hope for Your respond, Regards, Vlad. I have checked your update , it is not a problem to do such rules at script for me.
$277 USD en 2 días
5,0 (61 comentarios)
7,1
7,1
Avatar del usuario
Hello! I'm an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$300 USD en 3 días
4,9 (274 comentarios)
7,2
7,2
Avatar del usuario
Hi Sir. I have gone through the attached sample and I would like to ask a thing for clarification. I shall write up a VBA routing with in 2 days to collate the 3 data sets. Please discuss so we may continue. Thank you. Usman
$310 USD en 2 días
5,0 (86 comentarios)
7,0
7,0
Avatar del usuario
You dont need to recruit me to finish this. Drop me a message, give me a bit time and i can complete it. If you are happy, we can finish the process. (as i need some good references im my profile, i provide this service) I have a 5,5 years of business analyst experience in a global company and 2,5 years data scientist experience in a game company before my freelancer career. Excel is my legs and arms. I can make any reporting, formulas, pivot tables, macros etc. I am mostly online. Just drop me a message so that we can discuss further about pricing and job details. Thanks,
$333 USD en 1 día
5,0 (142 comentarios)
7,1
7,1
Avatar del usuario
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 regards
$300 USD en 3 días
5,0 (206 comentarios)
6,8
6,8
Avatar del usuario
Hi: Thanks for the additional clarification....I have few questions, it would be great if you could clarify them: 1) The first thing program needs to do is to identify publications that have been authored by the person in the data set 1. Please confirm....... 2) The format of the data set 3 will be similar to data set 2? There is some confusion because of this statement "The third data set will be similar to the second...... The format of the data will be the same as the first data set".......... 3) The final goal is to get the total number of publications and total number of affiliated publications for each author present in the data set 1, along with corresponding % in which that author affiliated with a specific institution........................Please note that I have 100% completion rate and 5-star feedback on all projects (>70 total completed projects). More than 90% of my completed projects are related to Excel and VBA Script. Please check my profile to confirm the quality of my work. Please connect with me to discuss more
$250 USD en 3 días
4,9 (156 comentarios)
6,9
6,9
Avatar del usuario
Hello Sr., how are you ? Jorge is my name and I have experience doing programs using VBA Code (with Excel for example). You can visit my Portfolio to know my last jobs regarding these skills, the reviews received from clients and as you can see, a higher percentage of jobs completed. i'm interested to help you on this particular project. What I prefer is to discuss with you more in detail all your terms and I'll give you a better proposal. No more Sr.; contact me if you'd like it and I will do the best, Regards. Jorge. P.S.: I will not accept any award before to discuss with you all the details needed.
$250 USD en 5 días
5,0 (155 comentarios)
6,9
6,9
Avatar del usuario
A proposal has not yet been provided
$250 USD en 5 días
4,9 (255 comentarios)
6,5
6,5
Avatar del usuario
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$250 USD en 6 días
4,9 (144 comentarios)
6,7
6,7
Avatar del usuario
I have been working with VBA for more than two years for companies like IBM, MSCI and Ford Motor Company. I have created numerous macro that was based on lookup functions and string manipulation. I am ready to start working on it immediately.
$277 USD en 3 días
5,0 (100 comentarios)
6,5
6,5
Avatar del usuario
Hello I am an excel expert and would like to bid on the project posted by you. I have completed more than 100 projects in excel. FYI: Freelancers are not authorized to send any attachments to the employer before we receive any personal message from the client. I request you to kindly initiate the conversion so that I can send examples of my work. Rgds Rohit Pithisaria
$444 USD en 7 días
4,9 (105 comentarios)
6,4
6,4
Avatar del usuario
Hi I have greatly admired develop this program using excel-VBA, I am taking this opportunity to apply and be considered. Besides that, I have versatile experiences about to do the online research, excel data analysis work with a small proficient team members of the group. Please find below my overview: Extensive Excel and pivot table development experience Excellent familiarity with all Microsoft Office applications Strong skills in maintaining accurate Excel spreadsheets High ability to meet strict project deadlines Exceptional proficiency with Build Scripts, macros, Excel add-ins and mail merges I am looking forward to discuss further if necessary for this position with you. Sincerely, Fatima
$250 USD en 10 días
4,9 (123 comentarios)
6,2
6,2
Avatar del usuario
Hello I can get the task done using VBA macro with in the next 24 to 48 hours. Let me know if you are interested. Thanks
$250 USD en 1 día
5,0 (98 comentarios)
6,0
6,0
Avatar del usuario
Hello there, I reviewed the data that you shared and can write and excel macro that will generate the desired output by selecting the records based on Authors of interest. I am an expert in Excel macros as you would see in my work history here, I have done several projects and have been highly rated and recommended for the professional quality work I deliver. Do let me know if you would like me to work on this project for you and we may discuss the next steps. Look forward to working with you and thank you for considering my bid. Regards, Rishi Automyze Consulting - The Business Process Automation and Optimization Experts
$250 USD en 3 días
4,8 (95 comentarios)
6,4
6,4
Avatar del usuario
Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Expert in MS office, which includes formatting, powerpoint presentation, mail merge, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers.
$263 USD en 5 días
4,8 (73 comentarios)
5,8
5,8
Avatar del usuario
Hi, I am Nallakumar. I have more than 9 years of experience in VBA and Excel. I understand the requirements as, against each of the others, we need to display the fraction of publications published to affiliates (Sum of affiliate publication/Sum of publications for each author) upon clicking a button in the Authors tab. Also, each the sum of affiliate publication and sum of publication is displayed against them. I can do this in less than a day. Thanks, Nalla
$315 USD en 1 día
5,0 (14 comentarios)
5,6
5,6
Avatar del usuario
I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files (or the folders containing them, as required by the job) and hosting command buttons and other controls if necessary. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
$250 USD en 2 días
4,9 (62 comentarios)
5,7
5,7
Avatar del usuario
Dear Sir/Madam, I have 12 years of experience in data processing and analysis using Excel and VBA while working in finance, audit and accounting industries (including 4 years at a Big 4 audit firm). My experience on Freelancer.com comprises a number of completed projects on creation, structuring and processing of data sets, including a project that had over 1 million rows of daily data. I will be glad to help you with your project. Please contact me to discuss project details. Thank you!
$250 USD en 2 días
5,0 (66 comentarios)
5,4
5,4

Sobre este cliente

Bandera de UNITED STATES
United States
0,0
0
Miembro desde ago 19, 2015

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.