Calcular kpi vbatrabajos

I am looking for an experienced Excel VBA programmer to automate and improve data entry and manipulation tasks for my project. Skills and Experience: - Advanced level of experience with Excel and VBA - Strong understanding of data entry and manipulation techniques - Proficient in creating macros and automating tasks in Excel - Ability to manipulate and format data efficiently - Knowledge of VBA functions and formulas for data validation - Experience in working with large datasets and complex calculations Project Details: - The main objective of this project is to automate the data entry process and improve data manipulation tasks in Excel using VBA. - The program should be able to streamline the data entry process by eliminating manual input and reducing erro...

I am looking for a skilled freelancer to develop a simple CMMS (Computerized Maintenance Management System) using either Excel. The main focus of the CMMS will be on preventive & schedule maintenance. Specific features needed for the CMMS include: - Asset Management: The ability to track and manage assets, including equipment, machinery, and facilities. Contractors service Dashboard - Calendar hyperlinks to maintenance folder As the client, I do not have any existing data to be integrated into the CMMS but I have a sample excel to share with you, as your reference. It is important that the freelancer is familiar with Excel, as these will be the primary tools used for developing the CMMS. Overall, I am looking for a freelancer with expertise in CMMS development, specifically us...

The code requires refactoring to remove infinity in loop and condition to handle exception like row del etc. So I will update code according to this review.

I am looking for a skilled Excel expert who can help me automate my daily Excel tasks. The specific task that needs to be automated is data formatting. Requirements: - Proficiency in Excel macros and VBA programming - Experience in automating data formatting tasks - Familiarity with working with moderate data structures, including several data types and tables - Ability to follow a specific format or template for the macro The ideal candidate should have a strong attention to detail and the ability to deliver accurate and efficient solutions. They should also be able to suggest improvements or provide suggestions based on their expertise. If you have experience in automating data formatting tasks and are confident in your Excel skills, I look forward to hearing from you.

Expert VBA & VBA Form Developer Needed for Existing Form Modifications - Seeking an experienced VBA developer to modify an existing VBA form - Specific modifications required: enhancing functionality - Current issue with the form's functionality: not user-friendly - Desired timeline for modifications: one day Skills and Experience Required: - Expertise in VBA development and VBA form modification - Strong understanding of form functionality enhancement - Ability to improve user-friendliness of VBA forms - Efficient and timely completion of modifications within a short timeframe

I am looking for a VBA expert who can refine and adapt existing code to automate repetitive tasks in Excel. The project needs to be completed within 1 week. Specific Requirements: - Refine and adapt existing VBA code to automate repetitive tasks in Excel - Ensure the code is efficient and error-free - Create custom user forms for improved user experience Ideal Skills and Experience: - Strong proficiency in VBA programming - Experience in automating tasks and data analysis in Excel - Ability to refine and optimize existing code - Knowledge of creating custom user forms If you are a skilled VBA developer with a proven track record of delivering high-quality and efficient solutions, I would love to hear from you.

I need Excel to call me on the phone when a certain condition is met. I don't know if it can be done with vba code or if an add-in is needed

We are looking for a statistician to analyse our data and create visual diagrams using data visualization tools. We also require the use of appropriate statistical tests to analyse the data. More details about the job can be found in the following link. Thank you for your consideration.

I have very little experience in VBA. I downloaded a file from a YouTube video (Excel for Freelancers) and have put together most of the work for an Inventory Management system on Excel. I keep getting some errors and cannot see what I have done wrong.

I am in need of a skilled VBA expert who can assist me with automating Excel processes. I have a clear process flow that needs to be automated, and I am looking to have this completed within a short-term timeline of one month. Skills and Experience Required: - Proficiency in VBA programming - Strong knowledge of Excel functions and formulas - Experience in automating Excel processes - Attention to detail and ability to accurately analyze data - Ability to meet deadlines and work efficiently

Hello I need to design a Power Bi dashboard with some KPI. It needs to look like the example photo below, souce is xls file KPI visual card should include : - number - rate - trend line in background past 12month - 12month moving average line it can be design using R or python extension if needed

We are looking for an experienced VBA developer to create a custom script for Microsoft Excel. The task involves analyzing a data set within a single column, which consists of approximately 800 rows of numerical values. Your goal is to write a VBA script that can efficiently identify and extract the highest and lowest numbers from the given range. Requirements: Proficient in VBA programming for Excel. Strong understanding of data manipulation and analysis. Ability to create efficient algorithms for identifying the highest and lowest values. Experience working with large datasets in Excel. Attention to detail to ensure accurate results. Clear communication skills to understand and implement any additional project specifications. Instructions: The data set is located ...

VBA Macro Code Modification for Basic Excel Application Project Details: - I am looking for a VBA expert who can help me modify existing VBA macro code in Excel. - The task involves making changes to the basic level VBA code. - The VBA macro code is specifically for an Excel application. - The ideal freelancer should have strong knowledge and experience in VBA programming. - The freelancer should be proficient in Excel and have a good understanding of macros. - Attention to detail and the ability to understand and modify existing code is crucial for this project. - The freelancer should be able to work efficiently and deliver the modified code within the given timeframe. - Experience with debugging and troubleshooting VBA code is a plus. - ...

I am looking to hire VBA developers who can assist me with creating custom macros for a complex project with many steps. The ideal candidate should have experience in automating Excel functions and debugging and troubleshooting existing VBA code. The project has a tight deadline and needs to be completed within a week.

Need an Expert VBA Developer who understands Office Scripts. We have several automation projects that we need to work on using VBA, but then transition them to Office Scripts. We need to work in the UK based shift and the person should be available during the UK hours. 1. Candidate should have excellent communication skills 2. Candidate will be working for a UK-based company, so, they should be ready to work on a UK-based shift 3. Candidate should have knowledge of Office Scripts 4. Candidate should have problem-solving and leadership skills

I am looking for a skilled VBA developer to help me with a project. The goal is to extract specific text data from a Word file and organize it in a specific format in Excel using a VBA macro. Requirements: - Proficiency in VBA programming - Experience with extracting text data from Word files - Ability to organize data in Excel based on a specific format Key Details: - The project requires extracting text data only from the Word file. - The extracted data needs to be organized in a specific format in Excel. - The macro should be set to run automatically. I need a very simple and understandable code which a VBA beginner level person can understand. Creating a Macro code that will bring the comments from the attached word document into the excel attached for ...

Provide the VBA code in an Excel sheet to control an excel graph: => Manual inputs to the VB code in an Excel form: -Range of rows to graph: ex if I enter 250-1240 only row from 250 to 1240 will appear on the graph with horizontal axis showing values from 250 to 1240. -Graph all columns checked: list with checkboxes of all columns within the table. The columns being checked are graphed on the Y-axis. Check all/ none button available. The X-axis column is always the "Index" column. -Additionally to those being checked, graph all columns whose header in row 1 contains a given string. Ex: if "2251" is manually entered in the form, graph columns in the table whose header contains "2251" (4 columns). Multiple strings can be entered (separated with com...

READ CAREFULLY! Hello, need Excel VBA script which will transfer these data from PDF TO EXCEL: - Invoice number - Invoice date - VAT CODE - Invoice amout The invoice format may be different, there is like 10-20 different sellers invoice templates, need to recognize all of them, attaching last month invoices to check. Invoices: As one freelancer told, this is possible and i want sript work like this: "Tool will do automatically, you just need to Brower and import pdf file folder where all pdf files are saved" If you can't do it, please do not bid!

...Title: VBA Debug Description: I am currently experiencing a logic error in my VBA code for an Excel application. I am looking for a skilled professional who can help me debug and resolve this issue. Specific requirements: - Proficiency in VBA programming and experience with Excel applications - Strong problem-solving skills to identify and fix logic errors in the code - Ability to work with sample data sets provided by the client for testing and debugging purposes Ideal skills and experience: - In-depth knowledge of VBA syntax and debugging techniques - Familiarity with Excel functions and formulas - Experience in troubleshooting and resolving logic errors in VBA code - Strong attention to detail and ability to effectively communicate and collabora...

I am looking for an experienced VBA programmer to assist me with my Program Office project. The main tasks for this project include automation of processes and report generation. Skills and Experience: - Strong proficiency in VBA programming - Experience in data analysis and process automation - Knowledge of generating reports using VBA scripts The project will involve modifying existing VBA scripts as well as developing new scripts from scratch. Timeline: The project has a moderate timeline of 1-2 weeks, so it is important that the freelancer can work efficiently and deliver within the specified timeframe. If you have the necessary skills and experience in VBA programming and can meet the project requirements within the given timeline, please subm...

I am looking for a freelancer who can create Excel macros to automate data extraction from an application to an Excel file. Specific tasks that need to be automat...freelancer who can create Excel macros to automate data extraction from an application to an Excel file. Specific tasks that need to be automated include data entry, data analysis, and report generation. I have a sample file that the macros should be applied to. The timeline for this project is within a week. Ideal skills and experience for the job include: - Proficiency in Excel macros and VBA programming - Experience in data extraction and automation - Attention to detail and accuracy in data entry and analysis If you have the necessary skills and can deliver within the specified timeline, please submit your...

I am looking for a VBA expert to help me with a project involving a database saved on major ask it that the tool should display the data from database to User-Form and the project requires the following functionalities: - View, Edit, and Update the database. The VBA project needs to be compatible with Access 2013 or later. Ideal skills and experience for the job include: - Proficiency in VBA - Experience working with databases - Knowledge of Sharepoint - Familiarity with Access 2013 or later.

...identify the reason for a compile error in a control on a form in Access 2013. The specific details of the project are as follows: Error Message: The compile error is showing as "Invalid qualifier". Control Causing the Error: The control on the form that is causing the error is a Textbox. Last Modification Before Error: The error occurred after I updated the VBA code. Skills and Experience Required: - Strong knowledge of Access 2013 and VBA programming - Experience in troubleshooting compile errors in forms and controls - Proficiency in identifying and resolving syntax errors and invalid qualifiers - Attention to detail and ability to analyze and debug code effectively If you have the necessary skills and experience to help me with this project, please subm...

I need someone to write the json api calls to get order information from Amazon SellerCentral and post back tracking info. Skills and experience required: - Proficiency in MS Access VBA and JSON - Experience with Amazon API integration - Knowledge of retrieving order details and tracking information - Ability to develop a new code or script for this project

I am looking for a freelancer who can make moderate changes to my VBA software in Excel. Here are the details of the project: Type of software: VBA in Excel Function or feature: I do not have a specific function or feature in mind for the software, but I am open to suggestions. Level of customization: Moderate changes are needed for the software. Ideal skills and experience: - Strong proficiency in VBA programming in Excel - Experience in customizing and modifying existing VBA software - Ability to suggest and implement improvements to enhance the software's functionality and usability

I am looking for a freelancer who can develop a VBA procedure to download fiscal correspondences from the ADE website. Skills and Experience: - Strong proficiency in VBA programming - Experience in web scraping and data extraction - Familiarity with the ADE website and its structure - Attention to detail to ensure accurate and complete data retrieval Functionality and Features: - The freelancer should follow a detailed list of functionalities provided by me - The procedure should be able to navigate through the ADE website and download the fiscal correspondences - The downloaded data should be organized and saved in a structured format - Error handling and exception handling should be implemented to ensure smooth execution of the procedure Deadline: - The project should b...

I am looking for a macro coder who is proficient in Excel. The specific goal for the macro is to perform automated tasks. Skills and experience required: - Proficiency in Excel and VBA programming - Strong understanding of automated tasks and macros - Ability to manipulate data and perform tasks efficiently - Attention to detail and ability to analyze and report data accurately The ideal candidate will have experience in creating macros in Excel to automate tasks and manipulate data effectively. They should be able to understand the specific task requirements and develop a macro that meets the client's needs.

I am looking for an Excel VBA expert to help me with a data visualization project. I need someone with experience in creating interactive dashboards and highlighting specific data points. The ideal candidate should have a strong background in Excel VBA and be proficient in creating visually appealing and user-friendly data visualizations. This project will involve analyzing and visualizing data using Excel VBA to create interactive dashboards that highlight specific data points. If you have experience in data visualization and are skilled in Excel VBA, please submit your proposal.

READ CAREFULLY! Hello, need Excel VBA script which will transfer these data from PDF TO EXCEL: - Invoice number - Invoice date - VAT CODE - Invoice amout The invoice format may be different, there is like 10-20 different sellers invoice templates, need to recognize all of them, attaching last month invoices to check. Invoices: As one freelancer told, this is possible and i want sript work like this: "Tool will do automatically, you just need to Brower and import pdf file folder where all pdf files are saved" If you can't do it, please do not bid!

Converting HTML to Python typically involves using a library that facilitates HTML manipulation. IF YOU HAVE THE MENTIONED SKILLS KINDLY PLACE BID FOR FURTHER DISCUSSION

I am looking for an experienced developer to provide advice on how to get my prototype PowerPoint flashcard application ready for online selling and the Microsoft Store. The application is currently in development and is a working prototype in Powerpoint with VBA automation. Specifically, I am interested in adding integration with online selling platforms to the application. This will allow me to sell the flashcard application online and reach a wider audience. The ideal candidate should have experience integrating applications with online selling platforms, particularly the Microsoft Store and other digital stores. They should be knowledgeable about the requirements and guidelines for selling applications on these platforms. Overall, I am seeking guidance on how to prepar...

I am looking for a freelancer who can automate Excel integration into Word to generate reports using VBA. Tasks to be automated: - Generating reports through integration of excel into Word. Preferred method: - VBA Data: - I will provide a description of the data that needs to be used for creating the reports.

Hello, i have alot of invoices which need to be submited to excel monthly basis, i am submiting it manually, i am thinking how to make the work easier, 30% of the Invoices is Img format, i am using Image OCR to copy value from Image and 70% is PDF format, ive tried using python script and OpenAi, but the result not very good. I have idea, but i don't know it is possible or not. Maybe excel have any shortcuts keys, which would fill the selected cell of the Column by specific key? Example: I open , copy The Faktura number, and pressing "Shortcut Key" and the selected value appears in the specific cell of the column? Then same thing with invoice date, but different key and different cell of column? hope so my idea wil be understood, i really have big headache with alot of invoi...

Convert my excel VBA one-page file to 5 liner webpage.

Hello, i have alot of invoices which need to be submited to excel monthly basis, i am submiting it manually, i am thinking how to make the work easier, 30% of the Invoices is Img format, i am using Image OCR to copy value from Image and 70% is PDF format, i've tried using python script and OpenAi, but the result not very good. I have idea, but i don't know it is possible or not. Maybe excel have any shortcuts keys, which would fill the selected cell of the Column by specific key? Example: I open , copy The Faktura number, and pressing "Shortcut Key" and the selected value appears in the specific cell of the column? Then same thing with invoice date, but different key and different cell of column? hope so my idea wil be understood, i really have big headache with alot of...

Hi, I would like to create an Excel file in VBA for betting, which takes data from a betexplorer. I need the total ranking, home, away of both teams, and the bookmakers' odds of over 1.5-2.5 and goals of the 2 teams. Salve, vorrei creare un file Excel in VBA per le scommesse, che prenda i dati da un betexplorer. Mi servono la classifica totale, casa e trasferta di entrambe le squadre, le quote dei bookmaker superiori a 1,5-2,5 e i gol delle 2 squadre.

Hey, I will be doing your work in 10$ as discussed, Thanks

Por favor, regístrate o inicia sesión para ver los detalles.

I am looking for a freelancer who can create a flow from Outlook to Excel, specifically transferring emails. The data should be formatted in a table in Excel. Furthermore, it is crucial that the data is updated in real time, meaning that any changes in Outlook should immediately reflect in Excel. Ideal Skills and...a flow from Outlook to Excel, specifically transferring emails. The data should be formatted in a table in Excel. Furthermore, it is crucial that the data is updated in real time, meaning that any changes in Outlook should immediately reflect in Excel. Ideal Skills and Experience: - Proficiency in Microsoft Outlook and Excel - Experience in creating automated data transfer flows - Knowledge of VBA scripting for Excel macros - Attention to detail to ensure accurate dat...

I am looking for a developer who can create a code that allows me to open specific set of folders as tabbed on my Windows operating system. The code could be written in any language and does not require a user interface. Requirements: - Experience in programming language - Familiarity with Windows operating system - Knowledge of file handling and navigation Skills: - Proficient in Python, VBA, C#, etc. - Strong problem-solving skills - Attention to detail If you have the necessary skills and experience, please submit your proposal. Thank you.

I am looking for a freelancer who can create a user form in Excel for me. The form that I need is a data entry form. I have a specific design in mind for the form, so the ideal candidate should be able to replicate that design accurately. The user form should have between 6 to 10 fields for data entry. Skills and experience needed for this project include: - Proficiency in Excel and VBA - Experience in creating user forms - Attention to detail to accurately replicate the design - Ability to create a user-friendly and intuitive form for data entry.

Project Title: Python + Excel VBA Fresher Required for 1 Month for Script Development with Guidance Tasks: - Develop customised UTILITIES using Python and Excel VBA - Implement functionalities for data scraping and analysis Required Skills: - Basic Skills in Python 3 with selenium - Basic skills with excel VBA - Desire to get experience, self learn with Guidance Team and Mentorship: - The Python fresher will have a mentor to provide guidance and support throughout the project Note: This project is ideal for a Python fresher looking to gain practical experience in automation script development with the guidance of a mentor.

see attached project description... if you dont understand dont waste my time with your messages!!!!

we have excel sheet that via vba auto creates new data columns. ie column C and D are property 1 and when we create a new property we populate E and F with that new props data. as lower down in column C and D we have charts (2 of them) for property 1, when we copy columns C and D into E and F the charts should copy as well (you can resize property 1 chart so it fits cleanly inside columns C and D). Then we need you to via VBA ensure the charts are using correct data(for teh new columns) and set titles (ie property 2 and 3 etc). this will be 2-3 hours vba testing etc.

Project Title: Excel dashboard Description: - I need an Excel dashboard to track sales on defferent parameters and month and month tracker on different parameters - The dashboard should be interactive, allowing me to easily explore and analyze the data. - I prefer a combination of charts and tables in t...data. - I prefer a combination of charts and tables in the dashboard format. - The ideal freelancer for this project should have expertise in Excel and data visualization. - Experience in creating interactive dashboards with a combination of charts and tables is a plus. - Attention to detail and the ability to present complex data in a user-friendly manner are essential skills for this job. And VBA including is also added advantage Will connect on remote desktop and explain wh...

I am looking for an Excel expert who can provide Key Performance Indicators (KPIs) from the last 3 years. Specific KPIs needed: - Sales and Recruiting Data collection: - The data is already collected, so the freelancer will not need to gather it and order it in a comprehensive file. Presentation preference: - Excel and visual graphs of the KPIs Ideal skills and experience: - Strong proficiency in Excel and data analysis, pivot and macro - Excellent ability to interpret and present data in a clear and concise manner. - Experience in creating both written reports and visual graphs or charts. - Attention to detail and accuracy in analyzing and presenting KPIs. We attach the file to be completed and/or improved. We will provide different excel with all the informations required.

I need make some excel vb in a file I need to add some VBA script in a excel files Thanks

Ciao Nazmus S., il tuo profilo mi ha colpito e mi piacerebbe assegnarti il mio progetto. Possiamo discutere i dettagli tramite chat.

...Offering Products and Services benefits Your Marketing Objectives and goals Your main Competition in the Market Your Active Social Media Platforms Your current Marketing Budget REMOVE FIELDS: content strategy kpi 3/ CODES SHALL BE UPDATED ACCORDINGLY {if {product_field} != ""}Product Field: {product_field}{/if} {if {audience_field} != ""}Audience Field: {audience_field}{/if} {if {competitor_field} != ""}Competitor Field: {competitor_field}{/if} {if {vision_field} != ""}Vision Field: {vision_field}{/if} {if {budget_field} != ""}Budget Field: {budget_field}{/if} {if {kpi_field} != ""}KPI Field: {kpi_field}{/if} {if {objective_field} != ""}Objective Field: {objective_field}{/if} {if {strategy_field} != &q...

I am looking for a freelancer to create an Employee KPI scorecard for a large Australian Agricultural Business. The scorecard will be used for up to 100 staff on a bi-annual basis. The scorecard will need to pull together a mix of both: - subjective metrics (manual assessment by a manager) - objective data points (from a variety of excel reports) The KPI scorecard should report on an employee performance across 14 different categories including: Quality Cultural Fit Final Reports Productivity Efficiency Leave Planning Client Interaction Travel Record Sheets Admin Compliance (Connx/Concur) ANOVA App Logging Safety The scorecard should follow a specific format and layout, as I already have an existing template in mind. Coverage: - Up to 100 employees Ideal skills and e...