VBA excel dashboard jobs

I have a sheet that collects check-in/out times, project names and employee names. The sheet is updated by a google form. Names and projects on the form can change. I need this s...Google sheet as text (OCCUPIED/CLEAR) next to the project name or change color (red/green) of project name. - Weekly time report: The time report can be in Google Sheets format. - Technology/Platform: You are free to choose the best technology or platform to automate this process. Ideal Skills: - Proficiency in data analysis and automation - Experience in project management and time tracking - Excel expertise - Strong problem-solving skills and attention to detail. Looking forward to seeing your proposals!

More details: We have an internal excel worksheet that has currently not been put into production, we would like this converted to an editable PDF document that only selected boxes are editable and once finished we can then fill and sign to use on an Ipad, Iphone or Desktop if amendments were needed to be made. We would need a slightly bigger signature box at the bottom to allow our engineers to the click on the box and sign with either their finger or an Apple Pencil.

am seeking a competent data entry specialist with excellent attention to detail and proficiency in Tally. The assignment entails adding around 300 entries from an excel file to tally data (i.e. update company Tally Books ). Each entry in excel has comments that specifies the heading & vendor name for the data entry. Once the data is entered the same will be verified by us for correctness. Key Responsibilities: - Organizing extensive financial data within Tally with accuracy and precision - Ensuring the data is properly categorized and easy to understand - Verifying the accuracy of the financial data, correcting any errors, and handling any discrepancies. Ideal Skills and Experience: The ideal candidate should be precise, meticulous, incredibly organized, and possess th...

As per requirement, I will deliver the required district's School details in Excel format

I'm looking for a skilled statistician who can calculate the winning probability and the probability of a specific number appearing in ...number appearing in a number game I'm working on. The winning probability should be calculated under specific conditions that I will provide. I want the calculations to be presented in a clear and concise Excel sheet. The Excel sheet should be basic, focusing on essential calculations. Role Requirements: - Proficiency in statistical analysis and probability calculations - Advanced Excel skills for creating clear and concise spreadsheets - Ability to follow specific instructions for conditional probability calculations Ideal Skills: - Statistical analysis - Probability calculations - Excel - Data presentation - A...

I'm seeking a seasoned developer for an advanced VBA application. This application should principally assist in data analysis, while also automating routine tasks. The exact tasks that need automation include data import/export and manipulation. Key Requirements: - Development of a VBA app with a robust data analysis feature - The app should automate data import/export and manipulation tasks The application should also be capable of seamlessly integrating with various software tools. While Microsoft Excel and Access are a given, the ability to integrate with other tools is also vital. Having experience working with a variety of software packages is a considerable advantage. Skills and Experience Required: - Proven experience in VBA development, particul...

I need a talented and experienced designer who can help me execute an extensive redesign of my Canva project. Ideally, you should have excellent skills in working with Canva and a keen eye for aesthetics. Specifically, the project will involve: - Text modifications: The font style will have to be changed while al...- Image replacements: Replace existing images with those I will provide. Skills and Experience: - Proven experience in managing Canva design projects - Excellent eye for detail - Strong graphic design skills - Good understanding of fonts, colors and layouts - Excellent communication skills to understand and translate my vision into the project design If this sounds like a project you can excel at, I invite you to place your bid. I look forward to seeing your ama...

I'm looking for a skilled professional who can create a VBA solution in Excel that can interact with a MySQL database. The system should be able to perform the following CRUD operations: Insert, Select, Update, and Delete. This will be a continuous requirement. Key requirements: - Proficiency in MySQL and Excel VBA - Strong understanding of SQL ODBC connections from Excel VBA - Ability to deliver the project within timelines. Your main task would be to create a reliable, easy-to-use, and efficient system to automate the specified database operations from Excel. In addition, the final solution should be well-documented for future reference. If you have experience in similar projects and can commit to the timeline, I'd love to he...

I have less than 10 columns of text and numbers data, currently in scanned documents that need to be accurately typed into an Excel sheet. I am looking for someone highly detail-oriented with: - Proven experience in data entry or similar roles - Excellent typing speed and accuracy - Proficient in using Excel - Experience in digitizing scanned documents is a plus Responsibilities include: - Typing text and numbers data from scanned documents into Excel accurately - Ensuring no data is missed or misrepresented - Completing project within the agreed deadline. Looking forward to working with a diligent and efficient freelancer.

...working with a Windows PC, I am seeking a proficient software programmer to write a program for USB to RS-485 communication. This program will retrieve real-time operating conditions from my solar inverter and present it on a visual dashboard - the program also needs to be able to change key operating parameters. Key Requirements: - Development of a program that facilitates communication between PC and solar inverter over USB to RS-485 - Enable the retrieval of real-time operating conditions data from the solar inverter - Create a clear, easy-to-use visual dashboard to display this data in real-time Ideal Skills and Experience: - Proficiency in software programming and systems integration - Previous experience with USB to RS-485 communication - Solar energy systems knowl...

I have a pipe recorder plug-in on my website, , but I am having issues with the recordings not uploading to the employee dashboard. This task is to help fix the issue. Key requirements: - Identify the cause of the recordings not uploading to the employee dashboard - Resolve the issue to ensure that recordings can be successfully uploaded - Test the functionality on Google Chrome to ensure the issue is resolved Ideal skills for this project: - Proficient in web development, particularly with plug-ins and dashboards - Strong problem-solving skills to identify the root cause of this issue - Experience in troubleshooting browser compatibility issues, especially with Google Chrome Please provide a brief summary of your experience in web development and any relevant projects you...

I need assistance to convert an Excel file into the RES2DINV software for the purpose of visualizing and interpreting my data. The Excel file's content type isn't specified but it may contain geophysical measurements, soil resistivity, or survey data. This turnaround for this task needs to be as soon as possible. Ideal skills and experience: - Proficiency in utilizing RES2DINV software - Strong understanding of geophysical data interpretation - Experience in data conversion from Excel to RES2DINV - Ability to work on tight timelines.

I am in need of an Excel expert who can create a formula that will allow for real-time updating across multiple sheets. This formula should automatically transfer all inputs from sheet one to both sheet 2 and sheet 3. Key requirements: - Expertise in Excel and formula creation - Experience with real-time data updating in Excel - Ability to automate data transfer across multiple sheets The assignments from sheet 1 should appear as the words written and not "assignment" in the weekly and monthly calendars.

Need a proven expert in HTML5, CSS, and JavaScript who is familiar with Tailwind, to create a dynamic CRM dashboard. Key Project Points: - Features: The dashboard should include key features such as user management, lead tracking, and sales analytics. - User Management: You'll weave together an engaging and intuitive user management system. Specific functionalities required are missing, so a firm understanding of standard User Management tools such as roles, permissions, and profile management is a must. - Data Visualization: The ability to integrate data visualizations such as bar, pie, and line charts into the dashboard is crucial. Ideal applicants should have a detailed understanding of web design principles and be able to present portfolio evidence showcas...

I'm in need of an expert web scraping developer who can extract textual data from specific Wikipedia pages. This should be a one-off task as there is no requirement for handling updates or changes to these particular pages. Key specifications: - Targeted content: Textual data - Pages to scrape: Specific, to be provided Ideal skill...one-off task as there is no requirement for handling updates or changes to these particular pages. Key specifications: - Targeted content: Textual data - Pages to scrape: Specific, to be provided Ideal skills and experience: - Proven expertise in web scraping - Previous experience with Wikipedia or similar tasks preferred - Ability to deliver accurate data in a structured format such as CSV, Excel, etc. Please avoid any unnecessary or redunda...

I am in need of a personal assistant to professionally handle phone calls, answer emails, and meticulously track rental payments and expenses for 6-10 rental propertie...some responsibilities of a bookkeeper; hence, an understanding of and experience in basic to intermediate accounting is highly preferred. Key duties will involve: - Efficient management of rental properties - Timely tracking and recording of rental payments - Accurate accounting of expenses - Handling telephone and email communications A candidate with skills and experience in these areas will excel at this role: - Bookkeeping - Accounting (Intermediate level) - Property Management - Communication. For my peace of mind and the smooth operation of the rental properties, a meticulous, detail-oriented individual ...

I need a React Native developer to create an app that works on both iOS and Android using a design that I have in figma, and a backend already live on AWS. There are 13 screens: - Splash screen - Sign In - Forgot password - Reset Password - Create account (4) – 3 slides of onboarding info and then the create account form - Confirm email - Dashboard - Item Details - Profile - Reset password (logged in) The two main screens with logic are: - Dashboard - get request to list items and display them - Item Details – Get item details and display them, a few buttons with API calls, and popup forms with API calls I have the figma file and also image files for the logo and can provide colour information. The main tasks for the developer are as follows: - Build the UI for...

I'm looking for an Excel expert who can modify the pricing formula and user interface of my existing price calculator. It is a very basic lookup, with quite rudimentary discounts that need to be applied, and we have a working example to share which you can backsolve how to build/update as needed. Here are the specifics: 1. Update the lookup to a new pricebook tab (Both current, working example, and new example with the new price book will be shared) 2. Introduce new add-ons tick list on the calculator (basic calculations (percentage of total, and fixed price) 3. Build out a visual display of a basic discount matrix (10%, 20% etc - this will be supplied) $. User Interface Improvement: - The updated calculator should still be user-friendly and intuitive. - Experience ...

I am seeking an expert in Excel to conduct comprehensive analysis on collected customer feedback, aiming to evaluate customer satisfaction. The raw data is currently stored in Excel spreadsheets and it essentially contains the comments and feedback from our customers. Key Responsibilities: - Deeply analyze the comments and feedback - Identify patterns, trends and vital points from the feedback - Importantly, provide a detailed report on these findings to aid further business decisions Ideal candidate must have: - Proficiency in Excel data analysis tools - Past experience in feedback analysis - Understanding of consumer behavior - Excellent reporting skills.

I'm looking for an expert to convert my existing Microsoft Excel Macro into a Google Sheet function with some added enhancements. The key enhancement is auto sorting on the newly created worksheets. The sort should utilize multiple columns, each with a unique order, either ascending or descending. Indispensable Skills: - Proficiency in Excel and Google Sheets - Familiarity with Macros and Google Scripts - Strong attention to detail, especially with data sorting and organization When you bid for this project, please say your opening comment as "Convert Excel Macro to Google Sheet Guru" - this way we will know who had done auto bidding and who has actually bothered to read out requirements. This job should be pretty easy and straight forward for some...

I'm in need of a meticulous professional skilled in data entry, particularly with numerical data, to populate an Excel spreadsheet for me. Key Tasks: - Processing a variety of numeric data - Entering this data accurately into an Excel spreadsheet - Categorizing and sorting this data by date Ideal Skills: - Excellent attention to detail - Ability to work with numerical data effectively - Proficiency in Excel - Data organization abilities - Ability to categorize and sort data in assigned order

I need a skilled freelancer to conduct data analysis on an array of mixed data (both numerical and textual) using Excel. The data will be provided in CSV file format. This project requires a sound understanding of data analysis concepts and proficiency in the use of Excel or similar spreadsheet software. Key Responsibilities: • Convert CSV files into a usable format for Excel • Analyze the given mixed data • Generate comprehensive findings from the data Ideal Skills: • Familiarity with CSV files • Proficient in Excel/Google Sheets • Experience in data analysis • Detail-oriented and accurate data entry • Good communication skills to effectively summarize findings.

Please Sign Up or Login to see details.

I am looking for a professional with strong data entry and analysis skills to assist with a key task. This engagement will involve entering both numeric and textual data in Excel for the purpose of data analysis. Here are the specifics: Look at the attached excel document. I need every country to look like the top 2 rows Afghanistan and Albania. Very simple and for the right person, I dont think it would take more then 2 hours. I need this done within 10 hours time. All links must be removed. All numbers must be numeric format. If this sounds like something you could excel at, then I would love to hear from you. Please include how you would approach this project as part of your proposal. I can pay $13 for this task. Bids higher then $13 will be ignored. T...

I am looking for someone to assist me with data entry in Excel for a project. The ideal candidate will have experience in data entry and be proficient in using Excel. Specific requirements for the project include: - Perform accurate and efficient data entry tasks - Organize and manage large amounts of data - Input data into Excel spreadsheets according to specific guidelines - Ensure data is entered correctly and consistently - Verify and update data as needed Additionally, the data will need to be presented in a graph or chart format. Therefore, the ideal candidate should also have experience in creating graphs and charts using Excel. Skills and experience required for this project: - Proficiency in Microsoft Excel - Strong attention to detail - Ex...

I'm seeking a proficient PHP coder to construct a dashboard that features user authentication, data visualization, and real-time updates, specifically for bulk email processes. The dashboard creation should be nuanced to handle a local mail server setup. While the number of emails to be handled daily is still being established, it'd be beneficial for the local mail server to be adaptable. Skills and Experience Required: - Deep understanding and expertise in PHP coding - Prior experience creating dashboards, specifically for bulk emailing - Proficiency in user authentication processes and data visualization - Knowledge of local mail server setup - The ability to deliver real-time updates. Looking forward to working with an applicant that aligns with these requir...

In need of a proficient Excel expert to shoulder some administrative duties. The role involves primarily data entry tasks, including but not limited to: - Simple data entry through copying and pasting - Repeat entries only need to be entered once - Looking at about 500 entries, (actual about 300 entries) Ideal candidate should demonstrate proficiency in Excel, attention to detail and data cleaning, and should be able to handle large volumes of data efficiently and meticulously. Organizational and analytical skills would come in handy to ensure data is presented in a user-friendly manner. Previous experience in data entry is well-regarded.

As part of my project, I'm dealing with a large set of data (more than 10,000 rows) in Excel, for which I require professional assistance. Key Tasks: - Apply specific Excel formulas to perform financial calculations, including NPV, IRR, and ROI. - Utilize logical and text functions such as IF, CONCATENATE, and VLOOKUP for data management and analysis. Ideal Candidate: - Proficient in Excel functions and formula calculations - Experienced in handling large datasets - Strong financial analysis background The right freelancer will help me analyze this data successfully and draw meaningful conclusions. This project requires detailed and careful work due to the extensive dataset. I appreciate your time and consideration of this project.

Hello, In formula mode, Excel only shows reference to cells and not the actual number. I need an excel function that will convert formulas (Cell B4) to actual numbers (Cell C4). The attached image will explain what is needed.

Looking for an expert to set up a comprehensive dashboard in Datadog for our Java and Oracle applications. The ideal candidate will have experience in Application Performance Monitoring and be able to implement full monitoring features with capabilities for in-depth analysis and performance optimization. Scope of work will include the following: - Monitor CPU usage, memory usage and response time - Set up application and database monitoring - Implement real-time monitoring This is a crucial role that requires a high level of technical expertise, particularly in Java and Oracle applications. Applicants with previous experience in using Datadog for similar tasks will have an advantage. Please submit a proposal detailing how you would approach this task.

I need assistance with a large-scale data extraction from an Excel spreadsheet. The data includes about 38000 line items, from which I require certain specific pieces of information – namely, the Names, Addresses, and Email Addresses. This extracted information will be used for creating a logical and organized mailing list. Here are the important elements of the project: - Extracting Names, Addresses, and Email Addresses from approximately 38000 line items - No specific extraction criteria or conditions to follow Ideal freelancers for this job would have experience in data extraction, data entry and be efficient in Excel spreadsheet operations. Precision and attention to detail are paramount for this role, as the information gathered will directly impact the efficacy ...

Please Sign Up or Login to see details.

Please Sign Up or Login to see details.

I'm in need of a proficient professional who can provide a detailed quantity take-off for a project Value RM3.4 Million equivalent to USD711,000. Key Responsiblities: - Providing a comprehensive full building quantity take-off service. - All data to be provided in Excel Format - Complete within 2 days. - Initial tender quantity will be provided, to compare it with taking-off quantity (re-measurement) Ideal Skills: - Familiar with Planswift would be a plus - Experience with industrial-type construction projects. - 5+ years experience in Quantity Surveying Field - Strong analytical skills and attention to detail. - Familiar with Malaysia standard of measurement, SMM2 By offering this service, you will provide an integral part of the planning and budgeting process for the succ...

Need a freelancer that can extract a list of cities (200 - 400) from a website and provide in an excel sheet. Quick job for the right freelancer. Pays $20

I'm looking for a proficient programmer to create a graphical user interface (GUI) dashboard for my manufacturing business. A high level of experience with Linux platforms is required as this will be the operating system used. The primary task will be programming the dashboard to display key production metrics which will assist in tracking and assessing manufacturing performance and efficiency. Experience and Skills needed: - Linux platform proficiency - Python or Docker - GUI development skills - Using Metabase - Metabase and SQLite familiarity - Deployment on VPS and Locahost Desired aesthetic: I prefer the GUI dashboard to exploit the capabilities of Metabase and SQLite to achieve a functional yet appealing aesthetic. Experience in designing and developing wi...

I'm in need of an Excel expert who can assist me in creating an advanced tracking system for specific KPI's and security measures. For the KPI tracking, you'll work with: - Sales - Profit Margin - Customer Satisfaction It's also crucial for the data we manage is secure with a well-setup security system. Data security is paramount, and I need these set up: - Data encryption - User authentication - Firewall protection Moreover, the security measures should include an effective incident tracker that, in case of any violation, notifies me through email. Skills needed: - Expert in Excel - Understanding of Data Security - Knowledge in setting up email notifications. Please, only apply if you have a strong understanding of these areas.

I'm in need of a top-notch mobile app developer with excellent technical skills and experience i...Reward System: A reward system should be integrated within for employee motivation. ●User Authentication ●Habit Tracking ●Customizable Habit Categories ●Reminder Notifications ●Progress Tracking ●Goal Setting ●Daily, Weekly, and Monthly Views ●Notes and Reflections ●User Profiles ●Add Friend ●Leaderboard for competition ●Privacy and Security Along with this, a custom admin panel dashboard to control the app and its users. If you have a proven track record in mobile app development, preferably with experience in habit tracking or related apps, let's get in touch. Your ability to reconcile ease-of-use with highly functional features will be a major advantage.

I require an expert who can handle a multifaceted data analysis task. This project (Excel dataset) revolves around a questionnaire survey I've conducted for research purposes. Key Tasks: - Carry out descriptive statistics - Conduct correlation analysis - Perform validity and reliability tests Specifically, I need the following tests to be utilized: - Chi-Square test - Cronbach’s statistic - Item-total correlation - Discriminant & Construct validity The ideal candidate should have solid experience in statistical analysis (no preferred Software), a strong understanding of the mentioned statistical tools, and an academic or marketing background to comprehend the intricacies of my research. Familiarity with surveys and questionnaire analysis will be a significant adva...

I'm currently working on my MBA project, and I'm looking for a statistician with a strong background in regression analysis and Excel. Here's an overview of what I'll need from you: - Perform a comprehensive regression analysis: I've chosen to focus my research on this area of statistics. - Use Excel for this project: I have decided to use Excel for this project due to its simplicity and because it's a tool I'm familiar with. - Complete the project as soon as possible: I'm running on a tight schedule, so time is of the essence. Required Skills: - Strong grasp of regression analysis - Proficiency in Excel - Ability to work under a tight deadline This project is quite urgent, so I'd appreciate a swift response from ...

...Arequipa that requires hiring a supervisor for works whose amount is greater than 4 million? We dont want a system like chatpdf or private GPT We need the workiflow of the job (simple) and details about the training steps Please take a look, we think that chatgpt with ChromaDB for vectordb will work better, faster and efficiently. My boss will ask for the python code, screenshots and Trello dashboard for this project, and some explication or tutorial in some points i guess, for example how to add a new bucket for more files for the system and chatgpt answers. He will present this system in this month to one client that ask for it, and depends of him to scalate the project, maybe integrate with other services (SUNAT for example for taxes information), develop mobile app or word...

...warehouse management. - Offer flexibility in payment methods, currency handling, and shipping configurations. - Ensure scalability, performance, and security of the platform. Key Features for the end user: Giftcards and Store Credit Multiple Currencies and Payment Methods Invoicing System with Invoice Upload Package Tracking and Management Warehouse Management System (WMS) Point of Sale (POS) System Dashboard with Stats and Reporting Multi-Employee Support with Role-based Access Control Subscription Tier Management with Admin Controls Third party Integration Requirements: - Integration with Stripe payments for secure transactions. - Integration with a mailing system (please advise) Performance Requirements: - Prompt response time for user interactions. - Scalability to handle ...

a Christian brand that delivers inspir...media account on your device. We will provide guidance on how to do this if needed. Compensation: This is a commission-based position. You will receive a competitive commission on every sale generated through your referral links. We provide exclusive discounts and offers for your audience to encourage sales. You will be able to track your performance and your earnings through your personal dashboard We're excited to partner with someone who is passionate about making a difference and spreading inspiration through their platforms. Join us in sharing a message of hope and faith that resonates with hearts around the world. To Apply: Please submit your application with the following: Any previous experience with affiliate marketing or b...

In this project, I'll need your expertise with Excel to map names across multiple tabs - K1, K2, and K3 - against a listing in the 'mapping' tab. Before you agree, you should understand that each name could be slightly different, meaning you can't rely completely on automation; you will need to manually review and align each entry. Key Responsibilities: - Copy names directly from tabs K1, K2, and K3 into columns E, F, and G respectively. - Use unique identifiers to categorize and organize this data. - If a name in K1, K2, or K3 doesn't match any entry in the 'mapping' tab, leave the corresponding cell in columns E, F, or G blank. The successful freelancer for this project will ideally be proficient in Excel, detail-orientated and has a st...

Data Organize and Analyze Excel VBA guy with Data Analysis skills.

...enabling parking lot owners to efficiently manage their spaces and generate revenue. Key Features: 1. Home Page: - Login for Drivers - Login for Parking Lot Owners 2. Parking Lot Owner Dashboard: - Manage multiple locations - View usage and revenue analytics for each location - Configure location details: - Available times - Location attributes (e.g., secure gate, washroom, cameras, nearby amenities) - Capacity - View future and present reservations - View past reservations and issue refunds - Review drivers - Chat with drivers - Set prices for lots 3. Driver Dashboard: - Search for available parking locations - Select location, date, and time - Process payment securely using credit cards - Report a location or is...

I'm seeking a skilled website developer for the creation of a simple and efficient freight management platform. Key Deliverables: - A user-friendly interface that clearly displays freight rates and charges. - A reliable tracking system integrated into the dashboard. - The need for a login or registration feature for users is currently indecisive, you must therefore be flexible with this feature. - Transbank payment available (webpay). - Link to social media. Special Features: - To ensure effective communication with our clients, a WhatsApp button is to be included. Skills and Experience Needed: - Prior experience with freight-based or logistics websites would be highly advantageous. - Proficiency in creating interactive, user-friendly web pages. - Ability to design and inte...

...developer to create a sophisticated and interactive dashboard. This project involves the end-to-end development of a dashboard system that will enable advisors to monitor their clients, consumption patterns, margin and payments, as well as provide organizational-level insights into advisor performance, customer data, and financial metrics. Scope of Work: Advisor Dashboard: Display active client counts per advisor. Allow for client selection and viewing individual client details. Present total and per-client-level energy consumption (kWh and Gas). Reveal margins for selected clients. Show monthly revenue and upcoming payment statuses for each advisor. Provide data on paid amounts in the last month and total payments received. Organizational Dashboard: Over...

...management for site owners and user registration. • Integration with local payment processing experience with subscription-based models and credit card payments. • Capability to add products linking to Aliexpress through an affiliate program (Note: This is not an eCommerce platform, but a feature to add product details leading to Aliexpress). • Development should include a dashboard for managing subscribers, monthly revenue tracking, and Aliexpress affiliate products. ### What I Will Provide: • Complete project designs for the application layout. • Further details on system features and functionalities. • Project Delivery:The application needs to be fully developed, launched, and operational. Source files must be provided upon completion.I a...

We need a specialist to scrape names, addresses, location, and contact details from a targeted database website. This is primarily for data analysis purposes. The scraped data will be required to be cleaned and structured for our specific data analysis tools. Therefore, attention to detail will be paramount in this project. Requi...from a targeted database website. This is primarily for data analysis purposes. The scraped data will be required to be cleaned and structured for our specific data analysis tools. Therefore, attention to detail will be paramount in this project. Requirements: - Proven experience in web scraping - Knowledge of data cleaning techniques, specifically for data analysis - Proficiency in working with Excel files - Attention to detail - Adherence to privacy r...