Find Jobs
Hire Freelancers

Buildng VBA for excel program for citation analysis

$250-750 USD

クローズ
投稿日: 8年以上前

$250-750 USD

完了時にお支払い
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: 8301051

プロジェクトについて

35個の提案
リモートプロジェクト
アクティブ 8年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
この仕事に35人のフリーランサーが、平均$327 USDで入札しています
ユーザーアバター
A proposal has not yet been provided
$300 USD 2日以内
4.9 (254 レビュー)
7.6
7.6
ユーザーアバター
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 4日以内
4.9 (334 レビュー)
7.7
7.7
ユーザーアバター
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 2日以内
5.0 (61 レビュー)
7.1
7.1
ユーザーアバター
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 3日以内
4.9 (274 レビュー)
7.2
7.2
ユーザーアバター
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 2日以内
5.0 (86 レビュー)
7.0
7.0
ユーザーアバター
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 1日以内
5.0 (142 レビュー)
7.1
7.1
ユーザーアバター
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 3日以内
5.0 (206 レビュー)
6.8
6.8
ユーザーアバター
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 3日以内
4.9 (156 レビュー)
6.9
6.9
ユーザーアバター
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 5日以内
5.0 (155 レビュー)
6.9
6.9
ユーザーアバター
A proposal has not yet been provided
$250 USD 5日以内
4.9 (255 レビュー)
6.5
6.5
ユーザーアバター
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 6日以内
4.9 (144 レビュー)
6.7
6.7
ユーザーアバター
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 3日以内
5.0 (100 レビュー)
6.5
6.5
ユーザーアバター
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 7日以内
4.9 (105 レビュー)
6.4
6.4
ユーザーアバター
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 10日以内
4.9 (123 レビュー)
6.2
6.2
ユーザーアバター
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 1日以内
5.0 (98 レビュー)
6.0
6.0
ユーザーアバター
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 3日以内
4.8 (95 レビュー)
6.4
6.4
ユーザーアバター
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 5日以内
4.8 (73 レビュー)
5.8
5.8
ユーザーアバター
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 1日以内
5.0 (14 レビュー)
5.6
5.6
ユーザーアバター
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 2日以内
4.9 (62 レビュー)
5.7
5.7
ユーザーアバター
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 2日以内
5.0 (66 レビュー)
5.4
5.4

クライアントについて

UNITED STATESのフラグ
United States
0.0
0
メンバー登録日:8月 19, 2015

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。