Bin Numbers - We’ll be inputting an RX BIN + possibly PCN + RX Group
This is how we want the program/macro to work.
User will be inputting data in a completely separate google sheet than where the data is pulling from. In that completely separate google sheet, the data will also be output.
Input/Output sheet is [login to view URL]
Data for all the steps below is in [login to view URL]
Step 1) We’ll input a BIN #, a possible PCN alphanumeric, and possible RX Group alphanumeric. Data for these fields are located in the “Bin Numbers” tab.
That will spit out what is in Column A of “Bin Numbers” Tab.
Step 2) Column A will then be used to match with columns B, D, F, H, J, L, etc. in the “Data” tab
Step 3) From there, It will go through the “Data” tab and will show which Drugs (RX column) are covered (indicated by letter “Y”) and which drugs are indicated by “PA”.
Need two types of outputs from here. User will select from list of Disease States listed in Column A of “Disease States” tab. User will also have an option to select “Unknown” as a disease state. If user selects “Unknown” then proceed to step 4. If user selects a disease state, skip Step 4 and go to Step 5.
Step 4) We want to show all these drugs that are tied to the RX BIN + possible PCN + RX Group. We want to show them split by “Y” and “PA”. All “PA” drugs that will be listed need to include their corresponding PA notes from the “PA notes” column in the “Pricing/Package Size” tab. So in all we should be able to see drugs split by “Y” individually and also by “PA” individually. Those PA drugs will need to show the corresponding “PA notes.”
Step 4a) Take the amount paid (“Data” tab) for each of those drugs that came from Step 4 and subtract it from “Acquisition Price” in Pricing/Package Size tab. Use this to sort those drugs that were pulled in step 4 and sort from highest to lowest.
Step 4b) Show those drugs, sorted highest to lowest.
Step 5) We want to show all drugs tied to the selected disease state. These will be tied to the RX BIN + possible PCN + RX Group first inputted. We want to show them split by “Y” and “PA”. All “PA” drugs that will be listed need to include their corresponding PA notes from the “PA notes” column in the “Pricing/Package Size” tab. So in all we should be able to see drugs split by “Y” individually and also by “PA” individually. Those PA drugs will need to show the corresponding “PA notes.”
Step 5a) Take the amount paid (“Data” tab) for each of those drugs that came from Step 5 and subtract it from the “Acquisition Price” in Pricing/Package Size tab. Use this to sort those drugs that were pulled in step 5 and sort from highest to lowest.
Step 5b) Show those drugs, sorted highest to lowest.
Hi there
I am interested in your project with Google Apps script, I have done many similar project and can help you with project, discussion as below
1. So you got 2 spreadsheet with connected to other by apps script, it will need to provide the reference sheet id/url for the extraction
2. The process should be triggered via custom menu rather custom function to increase the processing time
3. According to step 5, the drugs are listed in 'Freelancer Search' across 3 column in sorted order right?
4. I can do a demostration upon request
Similar ones:
https://www.freelancer.com/projects/mailchimp/Import-Mailchimp-Audience-Into-Google/reviews
https://www.freelancer.com/projects/javascript/Google-Script-Google-Sheets-Google/reviews
$425 USD in 3 days
5.0 (11 reviews)
4.9
4.9
24 freelancers are bidding on average $447 USD for this job
Hi, Greetings!
✅checked your project details: Create a macro/program in Google Sheets
✅Completed Time: In project deadline
We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly.
My Portfolio Items: https://www.freelancer.com/u/schoudhary1553
I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion..
Thank you
Sandeep
Digital screencast
Hy Sir I am expert in Google sheet, Macro, Script and customer function, I have already done the same job last day. I can do it perfectly. you can check my reviews. thanks
Hello
I am a Google Sheets specialist. You can check my reviews for similar projects. I will create your Google Sheet program to the speciafication you described. I am English and have great communication skills. I look forward to talking more.
Regards
Sean
Hi,
I am Swarnali, available online more than 16 hours everyday. I have read your project details. Recently, I have completed the excel formula, google sheet script and excel VBA macro based projects (see in portfolio). I can start now. Therefore, I would like to discuss with you about the project details. Looking forward to hearing from you!
Thanks in advance.
Best Regards,
Swarnali
Hello, I have checked your two Sheets and read your description/Business logic carefully.
Basically I understood what I have to do, and what skillset would be needed to do this job.
I am a Google Spreadsheet/Doc app script/addon Expert, I think I am suitable to this project.
Google App script would be ideal to do this job, I am sure.
I appreciate the opportunity to send you this proposal and I look forward to working with you!
Sincerely,
Jee Szes L.
Hi there
I hope all's well with you.
I see you'r looking for a developer proficient in Ms Excel/VBA.
I'm professional Ms Access/Excel/vba coder. I'm coding in vba since Ms Office 97 released.
Please visit (where I'm working basically):
https://www.freelancer.com/u/zu02?w=f
I can code all from 1) step to 5b)- based on this instructions - professionally and on time.
I hope hearing from you soon.
Thank you for your consideration and Regards,
Zurab
Hi there,
I am an expert in google sheets,excel macros , dashboards, formulas.I have gone through the description on your project and will be able to finish before the deadline.
Thanks
Arun
Hi! Hope to find you in the best of your health and happiness. I have rich experience in google sheets automation workflow process.
Had completed the similar project recently wherein data to be moved appropriately according to the instructions provided.
Been creating GAS for 4 years now. Web Apps, Automation Script, Onsheet automation using the available inbuilt functions and custom function too.
Hope, this will definitely make sense.
Thanks and regards,
Sanjay.
Hi, How are you?
I just saw your job posting and I felt that I can help you with this job considering the experience I have with Google Docs, Google Sheets, Google APIs and Excel Macros.
Please check my portfolio: https://www.freelancer.com/u/AITSoft
Regards,
Shamshad
Sir,
I am well versed in these kind of jobs and can do your project as per your requirement.
I am very much able to work on this. ***I am ready to start
Message me for further discussion.
Waiting to hear from you.
with thanks and regards
Hi!
I have read about your project Create a macro/program in Google Sheets
I am KickAss in Google Docs, Google Sheets, Google APIs and Excel Macros, so I'am totally sure I can deliver Your project !
Please contact me to discuss more regarding this project.
Thanks & regards
Hi
I have expertise in excel and can help you in completing your project successfully.
Can show demo some of the tools which created in Google spreadsheet using APP Scripting
I have experience on
1) Creating Excel Dashboard
2) Creating macros using Visual studios
3) Google spreadsheets for customised used
4) Using advanced formulas in excel
5) Creation of business tool using excel
6) Fastening excel processing using app scripting or visual studio or python programing.
7) 3d graphs for visualization purpose
and many more
Hope you will give a chance to showcase my excel skills on your project
Respected Hirer!
I read project detail, I will deliver as per requirement and in minimum time.
I am expert in ms excel. Please see my port folio.
Thanks & Best Regards
Salman Naseer