Spreadsheets Projects
Looking for freelance Spreadsheets jobs and project work? PeoplePerHour has you covered.
Laboratory Test Volume and Client Activity Excel Dashboard
Hello! Not sure if I am in the right category or not, so I don't know how to price this out so its entered as $10, but please specify what the cost would be. Summary: I work for a diagnostic laboratory. Today I don't have the combined data to track our laboratory client activity, provider utilization and testing volume. I have a few different reports I can download, but none of them come together. I was tasked with this project and I am really struggling trying to bring it to life. I am not an excel expert so I thought I would ask around... In an ideal scenario, I could download the reports and plug the data into a template and a dashboard would repopulate via excel spreadsheet. I listed few items I would be interested in starting with and I would look to your expertise at the same time to help us identify growth opportunities and missed opportunities as well on client and provider utilization. I should also state that I may want an NDA signed for this purpose when the data is shared. I could only attach 3 files so I attached only a few screenshots (Report A, B and D to start) Report A: Volume by Test Panel by Client - This is the only main tracking by test/panel volume that we have today besides individually going into each client portal - I would have to pull a report by month for last year so we can compare previous volume by client - Interested in Total Volume by Sales Rep (month over month) Report B: Client List - A list of all clients. - This report is unique because it shows: - CREATED DATE: Date client was entered (meaning closed won account - it doesn’t necessarily mean a test was received on this date though). - LAST ORDERED DATE: Date client last ordered a test Report B2: Facility Type - I’d want to see where largest volume is coming from by industry channel Report C: All Data by Client by Day - This shows detailed volume by provider by day - Data by sales rep - Can we see provider utilization - Total volume by month/week (4 bar charts) - 2 charts (EX: Month of March Bar Chart - with week 1, week 2, week 3, week 4 volume inside chart). Then show month of February and month of January Report D: All Providers by Client - This includes a list all providers in our system. So any provider on this list, but not on the report C, would be considered an inactive provider Other Data Points: - Would love to see total number of accounts in last 3 months - Graph showing the total number of active and inactive accounts (should add up to total # of accounts) - Percent of actives to inactive Thank you and look forward to hearing from you and your feedback! Thank you! Christine
18 days ago21 proposalsRemoteopportunity
Experienced WordPress and Elementor Website Developer
Job Description We are looking for a highly skilled Website Developer with extensive experience in WordPress and Elementor to make updates to our existing website on an ongoing ad-hoc basis. The ideal candidate will be adept at both using Elementor's visual editor and integrating custom-coded elements to achieve unique, user-centric web solutions. Responsibilities General Changes: • Make some amendments to the hero image and text in the hero position on the homepage. • Add a new prominent link on the homepage, to another page on the site. • Add call to action buttons to 6 coded flip-tiles on the website. • Create and integrate new sections within the existing layout. (There are a total of 5 pages which may require a new section to be added here and there, all copy will be provided). • Efficiently reposition existing sections to enhance user experience and site navigation. • Ensure that the website is fully responsive and works beautifully on mobiles, tablets and reduced browser windows. • Ensure that the latest copy - the document of which will be shared with the freelancer, is reflected on the website. • Ensure that there are no 404/broken links on the site. • Ensure that the Wordpress, Elementor and all active plugins are all updated to most current versions. • Work closely with our team to ensure the visual communication of our website aligns with our brand and message. We are also looking for the design and implementation of a Members' Login area to our existing site. The details are: • There will be no payment portal - Members will have already purchased the items offline, before coming to sign in on this page. • The business (us) will provide members with a login that gives them access to a certain subset of our proprietary research or databases, based on what they purchased offline. We should be able to select through tickbox optionality what each login can access from our stored documents on the backend, when we generate this login. • There will need to be a pleasing, branded and easy interface for the clients to see the documents that they have access to, once they’ve signed in. • The members will not be able to download or screenshot or copy any of this proprietary research, so it has to be locked on the backend. • As each client will have a set number of licenses, the sign in will be tied their unique device ID (MAC address), so that there is no password sharing. • The proprietary items will be stored in this website's back end, and they will be in PDF, excel spreadsheet or video formats (if videos are too large, we will host on Vimeo - first option, or Youtube - second option) Requirements: • Proven experience as a WordPress developer with specific skills in Elementor. • Strong portfolio with at least 5 websites that demonstrate the ability to integrate custom-coded elements using Elementor. • Proficiency in HTML, CSS, JavaScript, and PHP—specifically within the context of WordPress and Elementor. • Excellent attention to detail and a commitment to delivering highly effective and visually appealing website designs. • Ability to communicate clearly and collaborate effectively with our team members. • Experience in creating responsive, user-friendly website designs. • Experience with advanced Elementor functionalities, including motion effects and dynamic content. • Previous work on websites that require secure login and personalised user content. Conditions for reviewing your bid: • Please begin your proposal with the code "ELMNTR3" to confirm your understanding of the job requirements. • Include in your application a minimum of 5 portfolio links showcasing your experience with Elementor and custom coding capabilities. Detail your role and contributions for each project submitted. • You will need to provide exact timing for completion of this project - The deadline will be agreed with the freelancer in advance, but will be a strict deadline, as we will have several other key action items that will rely on this. Please don't provide a deadline that you can't meet. Please provide a total cost for completion of this project, we have been detailed in our brief to ensure everything is laid out clearly. We will not be accepting proposals with an hourly rate, or place-holder bids. • We will shortlist only 3 parties to have video calls with, to award the project - we cannot do so for everyone who asks for this. • If you have good questions for clarification, please ask them as part of your bid. We are excited to find a developer who can bring technical skill and creative insight to our team. We look forward to reviewing your proposals and potentially starting a long-term collaboration.
3 days ago53 proposalsRemote