Macro compile data excel files jobs

I'm looking to hire someone who can create an Excel VBA workbook to seamlessly integrate with my Zoho Desk setup. This workbook should be specifically engineered to perform the following: - Retrieve the required information from Zoho Desk tickets upon pressing a button inside Excel. Specifically, I need someone skilled in Excel VBA programming and API integration work to: - Design a user-friendly interface in the workbook where one can press a button to initiate the retrieval of ticket information. You should be able to retrieve the latest ticket, and then have two more buttons to go to next & previous tickets. - Implement secure API connections to Zoho Desk to enable the retrieval of ticket information usuing oauth. The fields I need are: Subject Account ...

I'm looki...handle executing regular exports from our Sequel Database to Excel, performing updates in Excel, and subsequently updating the Sequel Database with the altered data. Skills and Tasks; - Mastery in handling Sequel Database on Windows - Familiarity with Data Modeling and Design - Proficiency in exporting and updating database information via Excel - Being responsive and flexible as the frequency of this task may change. Initially, I will need it done daily for a week. Afterwards, it will be an as-needed basis for remote support. Experience in Performance monitoring, tuning, and database backup would be a bonus. The role demands strong organizational skills and attention to detail. A sound understanding of database principles and Exce...

I am seeking a detail-oriented freelancer to assist with a Data Entry project involving Excel. - Your major responsibility would be to populate Excel sheet with data. - The source format of the data is not clearly stated, therefore the freelancer should be prepared to handle data from multiple formats such as print or digital documents and online databases or websites. - The volume of the data wasn't disclosed, it could range from small to large quantity; hence flexibility and adaptability would be crucial. Ideal Skills and Experience: - Data entry proficiency - Excel proficient - Ability to handle multiple formats of data - Flexibility and attention to detail.

The project entails accurate entry of numerical data into an MS Excel spreadsheet, with a focus on report generation. The ideal freelancer should be well-versed with basic Excel functionalities, such as simulations and formulas, to ensure efficient data processing. Key responsibilities would include: - Accurate and efficient numerical data entry - Setting up Excel to run basic simulations and formulas - Generating effective and accurate reports from entered data The freelancer should have strong attention to detail to maintain data accuracy and proficiency in MS Excel, specifically in creating basic simulations and formulas. Previous experience in data entry and report generation is highly preferred.

...Feature Hiding: - Service Modification: The freelancer should modify the service that uploads data via MQTT. The primary tasks will be removing some existing filters and adding some new ones. Unfortunately, due to some constraints, I cannot provide specific details about which filters to remove, add, or modify. - Compilation: Finally, I need the freelancer to compile the revised application for TV apps as well Ideal Skills and Experience: For this endeavor, I need a freelancer proficient in software and app development, particularly with experience in modification and compilation for TV apps. Familiarity and experience with MQTT services are also crucial for the final task involving data upload filters. The project will be fixed cost ($100), underlining t...

...calibration process and gives a message saying "Don't put on the Mask". After the calibration process then it allows user to adjust the time/session duration. After editing some code it is getting stuck on the "Don't Put on the Mask" message during calibration and not getting to the next screen. When my other developer compiles the code on his computer it works fine on the same device. However when I compile the code on my computer then having these issues. After the repair, the software should be able to effortlessly advance beyond the first screen to run selected processes. To fulfill this job, expert knowledge in C++, a strong understanding of ESP32, and robust problem-solving abilities are essential. • Understand problem with C++ code f...

use submitted requirements and add to the existing figma protpotype. the job needs to be done rapidly

I require a professional with a keen understanding of both Excel and iOS Numbers to convert a single-sheet Excel spreadsheet into an iOS Numbers document. The converted document will need to retain multiple functionalities including: - Basic calculations - Data visualization - Conditional formatting No data interdependency or connectivity with other aspects is required in this case. The ideal candidate should have significant experience with data conversion between these two platforms and a solid grasp of maintaining functionalities in iOS Numbers. Familiarity with creating visually engaging spreadsheets will be highly regarded. I would like to have conversation with someone to make sure I am asking for something reasonable and to clarify exactly what...

...to work with me to achieve great rankings. If I say something needs tweaked a bit, I expect the team to listen to my desires as long as those desires will reach the end goal. While working on the main keywords, I expect additional keyword phrases to be used in Chat GDP blog and wiki articles that would benefit the website. That way not all backlinks will be from the list of 20. We can use our excel sheet from previous projects for this. I should see a drastic increase in DA and PA of the website. Post the phrase #seoGuru so I know you read and understand and agree to these terms. Post the sentence in your bid: "I understand and agree to the terms and conditions set forth in the project description. I agree that not following instructions will be grounds for termination a...

I have a baseline construction schedule built already; it has around 1000 activities, the schedule is cost & resource loaded. I will provide the update in excel (actual start, actual finish, actual cost), the monthly activities that needed to be updated (actual date & Cost) around 100 activities every month. Please note sometimes I need to provide you comments on the schedule update, so you need to fix the comments. I need you to update the start/finish date and insert the actual cost monthly (once every month). Plus, prepare small narrative report including some P6 PdF. I have the P6 layouts I will share with you. I have the report and layout built in already and I will share it with you. Finally, send me XER file, and Narrative report every month. It is very important y...

I am in need of an Excel relational database. The database should have the functionality to enter values automatically from an attached worksheet. The entry of these values will be based on specific criteria, more specifically, column values. Required Skills and Experience: - Strong knowledge and proficiency in Excel - Experience in database creation, management, and optimization - Understanding of data entry and data analysis - Proven experience in creating reporting capabilities within Excel. Using the "Reference data" tab, when the value in Column B is entered in the "Example worksheet" the corresponding values should automatically populate - Tariff code, Duty rate, CPF.

LOOK AT THE FIL...arguing that information and understanding can be a powerful tool against discrimination. Your proposal will demonstrate: - Deep understanding of the problem: the struggles parolees face when trying to secure housing - Clear plan of action: how community awareness programs can alleviate this issue - Benefits: how reducing discrimination could lead to a more inclusive and supportive society To excel in this project, you should have: - Exceptional skills in persuasive writing - Knowledge of recent legislature related to housing and parolees - An understanding of discrimination in housing applications - Experience in generating community-based solutions or policies Let's build a case to uplift this marginalized group, charting a path to fair and inclusive hou...

I'm in need of an Excel expert who can help me create a sophisticated formula for data analysis. The data I'm working with is moderately complex, involving multiple variables. It's all housed in Excel spreadsheets. Ideal Skills and Experience: - Proficiency in Excel, with a focus on complex data analysis - Experience in creating advanced formulas for data manipulation - Strong understanding of data structures in Excel and how to work with multiple variables - Previous projects involving statistical analysis would be an advantage I'm looking for someone who can not only create this formula, but also explain its function and how to adjust it for future data sets. Please provide examples of similar ...

I'm in need of a Java developer to create a standalone application for a small school. The application will be used to manage student records, various school resources, and facilitate communication with parents. Key Features: - Student Records: The application should be able to manage and track student progress through interactive line charts. - School Resources: The app should also ...Java development, previous experience in creating similar applications, and are confident in managing school resources and building a parent communication portal, feel free to bid on this project. I would need a preliminary discussion to assess the possible architecture/technologies. The initial bid if for the first module (main page, students list, DB, add/edit/delete students, load student data...

I need an intricate Excel model to calculate a cumulative threshold commission scheme, tailored to three varying levels of seniority: Junior, Mid-level, and Senior. The model needs to be exceptionally flexible and versatile to allow for easy manipulation and scenario planning. Key Requirements: - Create a multi-level commission scheme: The model should have different commission percentages for each level of seniority. - Cumulative Threshold Calculation: Incorporate a mechanism to calculate cumulative thresholds. - Revenue Generation Calculation: Develop an accurate formula that calculates the revenue generated. - Flexibility in Threshold Percentage: Ensure that the threshold percentage can be flexed. - Cash Retained in the Business: The final model should account for cash retained...

I need an expert in Excel spreadsheet and dashboard creation to help me with a project related to the management of properties. The project involves the following tasks: - Data analysis - Formulas and calculations - Data visualization The data to be used in this project will mainly revolve around a situation room containing property under management status and updates. Specifically, the dashboard should track and monitor the following key metrics: - Rent collection and payout status - Tenant and business complaints - Contacts details - Contracts status - Property profits - Property location - Owner notes - Comments If possible to have it as geolocation kml as a copy I'm looking for someone with strong experience in creating dashboards and spreadsh...

I'm facing a troublesome situation with my Springboot JDBC to Oracle project. While attempting to compile, it simply refuses to. Specifically, the issue seems to lie with classpath configuration errors. Key tasks and requirements include: - Fixing the classpath configuration errors that are currently preventing successful compilation. - Ensuring the project is optimized for performance post-fix. Ideal candidates should have: - Proficiency in Springboot and JDBC. - Solid understanding of Oracle databases. - Prior experience in resolving classpath configuration errors in Java projects. - Capable of optimizing performance in Java applications.

...web application developer with expertise in using Python for backend development, JavaScript and HTML for frontend. Key Components: - Backend programming using Python - Frontend programming implemented with JavaScript and HTML Key Functionalities: - Database Integration: The software developer should be able to create a seamless link to an existing database and enable secure data exchanges. there is already excel .xlsx file in the folder - API Integration: The project includes integration of specific APIs to provide essential functionality for the Web Application. Purpose of the Project: - The main goal for this project is to develop a functional web application and host it either on a server or GitHub. The application isn’t static and employs IT-technical featu...

...Freelance Logistics Analyst to develop a comprehensive monthly business review for our 3PL management operations (Warehouse and transportation) . The ideal candidate will compile performance data, analyze logistics processes, and present findings in a structured report. Responsibilities: - Gather and analyze logistics data to assess performance. - Create monthly business review reports highlighting key metrics and insights. - Suggest improvements based on data analysis. Required Skills: - Proven experience in logistics analysis or supply chain management. - Strong analytical and reporting skills. - Proficient in data visualization and presentation tools. Ideal candidates for this project should have experience in all 3PL logistics areas, particular...

I am seeking a skilled researcher to compile a 1000-word report on a technology-related topic. The report should be thoroughly researched with a focus on academic journals. Key Requirements: - Research on a technology topic - 1000-word written report - Extensive use of academic journals Ideal Skills: - Strong research skills - Proficiency in academic writing - Knowledge of technology trends and topics

I'm seeking a diligent researcher to help compile detailed market analysis and competitive landscape reports on companies in the Technology and Finance sectors across North America, Europe, and Asia-Pacific. Key Responsibilities: - Conduct thorough market analysis on selected companies in the Technology and Finance industries. - Research and assemble comprehensive competitive landscape reports for each company. - Focus on companies operating in North America, Europe, and Asia-Pacific. Ideal Skills and Experience: - Proficiency in market analysis and understanding of competitive landscapes. - Prior experience in researching and reporting on the Technology and Finance sectors. - Ability to gather and organize data effectively. - Strong communication skills, both written ...

I have the attached images , I need it to be in excel form.

I am in need of a proficient data entry operator, for a smaller task of less than 100 entries. The data will be provided to you in the form of scanned documents and you will be required to interpret and enter this data accurately into an Excel worksheet. - You should have experience with data entry from scanned documents into Excel and attention to detail is of utmost importance here. - Understanding of Excel basics is also required for successful execution of the task. - The format of data delivery will be an Excel worksheet. Proficiency in English and a strong attention to detail would be ideal attributes for this task.

I'm in need of a skilled Excel professional to assist with data analysis tasks. The primary focus will be on trend analysis and results should be presented in the form of detailed reports. Key requirements include: - Proficient in data analysis using Excel - Experience with creating reports - Attention to detail - Ability to communicate complex data in a clear and concise manner Please only apply if you have experience in trend analysis and report generation using Excel.

I am in immediate need of an Excel specialist who is well-versed in formula troubleshooting and fixing. There are 4 formulas that require attention; unfortunately, I am unable to enumerate them as I skipped that information. However, here's what I can provide: - Detailed description of how each formula should function - Expectations for the fixes I'm looking for individuals who are confident they can rectify the issues and can offer neoteric solutions. This project requires more than just experience, a resourceful approach to problem-solving is necessary. The application must include: - Detailed project proposal The proposal should provide clear insight into your troubleshooting steps, planned adjustments, and method of testing the new formulas. Time efficiency, ...

I am looking for a freelancer to assist me with a typing project. The project involves typing more than 100 pages of PDF documents. Requirements: - Proficient in typing and attention to detail - Ability to follow instructions and work independently - Experience with typing PDF documents is preferred but not required Specifics: - The documents do not require any specific formatting and can be typed in any standard format. - The freelancer has the freedom to choose the most suitable formatting for the documents. Skills and Experience: - Excellent typing speed and accuracy - Strong attention to detail - Ability to work independently and meet deadlines Please provide a sample of your previous typing work. Thank you for your interest in this project!

I am seeking a developer to create an Excel-based order placement tool for TradeStation, utilizing EasyLanguage. This tool will be designed to execute trades based on alerts from a specific indicator and strategy. Key functionalities should include support for OCO (One Cancels the Other), OSO (One Sends Other), and Basket orders. This is a fixed-price project. Payments will be released upon successful completion of predefined milestones. Please contact me if you're interested in this opportunity.

I'm looking for a skilled developer who can create a web application that can read data from multiple sources like Excel files, XML files, and APIs, and then match, aggregate, and save this data to a database. Requirements: - The web app should be able to read data from Excel files, XML files, and APIs. - The application should have the capability to match and aggregate data from these different sources based on specific fields, data types, and unique identifiers. - The end goal of the data matching and aggregation is to save the data into a database. Ideal candidate should: - Have experience in developing web applications that work with various data sources - Be proficient in database ...

I'm seeking a proficient Excel VBA coder to create a system that automates data entry from Excel files. The task involves: - Creating a VBA function that can input data automatically into my current system. - Implementing a data sorting feature as part of the data entry process to ensure that all data is easily read and interpreted. The ideal freelancer should have the following skills and experience: - Proficiency in Excel VBA - Experience with automated data entry - A solid understanding of data sorting techniques. This project requires precision and attention to detail. It should not only meet the needs listed above but also enhance data accuracy and save time.

...Illustrator to primarily vectorize my existing image and logo files. This is important for various applications, including print, web and video ads. Not only am I looking for someone to vectorize these files, but also apply necessary modifications via Photoshop or Illustration techniques. This will be done with a keen attention to detail and a good sense of design aesthetics. The ideal freelancer for this project should have: - Strong skills in Adobe Illustrator - Experience in image and logo file modification - An impressive portfolio showcasing similar projects When applying, please ensure to highlight your experience. Your unique touch and innovative techniques could be just what I need to bring these files to life. I have attached the files in quest...

I'm searching for a proficient developer to create a trading bot that operates on the Dhan platform. This bot must be integrated with Excel. Key Features: - It should have the functionality to automate trades based on calculations of quantities on a predefined Stop Loss (SL). - Its operation will involve using fixed quantities for all trades, regardless of SL level. Ideal Skills: - Experience in bot creation. - Knowledgeable about the Dhan trading platform and Microsoft Excel. - Strong understanding of trading algorithms and risk management. Your bid will be more competitive if you have previously done similar projects and can show a portfolio or examples of your work.

I am seeking an experienced data entry specialist to assist me with both digital and manual input into Microsoft Excel. The ideal freelancer will provide assistance with data extraction, cleaning, and verification to ensure accuracy and consistency of the data. Skills and experience required: - Proficient in digital and manual data entry - Expert in Microsoft Excel - Experience in data extraction, cleaning, and verification - Strong attention to detail - Ability to handle large amounts of data. The primary objective of this project is to manage and organize data efficiently. I'm expecting a high level of precision on the data entered. The candidate should be able to demonstrate experience in handling both digital...

...an oil & gas upstream company seeking a skilled developer to create a comprehensive library of automation tools. These tools will be designed to handle a wide range of tasks from data analysis to report generation and workflow management. The goal is to fully automate these processes to boost our operational & technical efficiency. project SOW: 1- build excel sheet list of company support of oil & gas upstream automation processes. first from UAE local company than find global company (list include: company name & type of tools service & description service tools & contact (website) 2- check the attachment excel, you will find the overall job & activity in oil company & type of tools need & find more activity + tools support. 3-...

Job: Change field names in vb source code according to Excel table (from/to)

Challenging opportunity for a skilled Excel Specialist. The details of the tasks are undefined due to insufficient information from the client. Candidate must be proficient in: - Data organization - Formula creation - Data analysis The size of the dataset is unknown and could range from small to large. You are expected to be able to handle any data size comfortably. While the type of analysis isn't specified, you should be skilled in: - Statistical analysis - Trend analysis - Financial analysis In summary, I need an Excel maestro who can confidently navigate any project, no matter how ambiguous. Your expertise, flexibility and adaptability will be essential for this project's success.

Challenging opportunity for a skilled Excel Specialist. The details of the tasks are undefined due to insufficient information from the client. Candidate must be proficient in: - Data organization - Formula creation - Data analysis The size of the dataset is unknown and could range from small to large. You are expected to be able to handle any data size comfortably. While the type of analysis isn't specified, you should be skilled in: - Statistical analysis - Trend analysis - Financial analysis In summary, I need an Excel maestro who can confidently navigate any project, no matter how ambiguous. Your expertise, flexibility and adaptability will be essential for this project's success.

Need someone who can create a complete video course for teaching excel from beginner level to expert level. Videos can be short as 2 minutes each to 8 minutes maximum. Need high quality videos showing right from how to open an excel sheet on a computer to on how to write real tome formulas.

I am looking for a proficient Excel expert who is highly experienced in financial data analysis. You will primarily be tasked with conducting comprehensive revenue and expense analysis. The ensuing breakdown of financial information will allow us to understand and evaluate our company's financial health. Ideal Skills and Experience: - Deep understanding of Excel, particularly in data analysis - Expertise in Financial analysis, specifically revenue and expense analysis is a must - Excellent in applying Excel for financial forecasting - Capacity to design efficient spreadsheets that emphasizes readability and ease of use - Fluency in formulating functions to automate data computations.

As a business owner, I need a proficient and efficient freelancer who can manage my company's financial data in Excel format. Key responsibilities: - Accurately entering, managing, and updating Income and Expense statements daily. - Ensuring data is correct, up-to-date, and accessible. Ideal skills: - Proficiency with Microsoft Excel - Strong attention to detail - Experience with financial data management Please note, this role requires daily work and a consistent, reliable, and professional approach. Experience in financial data entry is preferred but not mandatory.

I'm seeking an experienced Excel VBA expert to help me automate some basic, repetitive data entry and formatting tasks. Key Requirements: - Automate basic data entry and formatting tasks in Excel - Develop VBA script to ensure automation runs smoothly Ideal Skills and Experience: - Proven experience in developing VBA scripts for Excel - Strong understanding of Excel functions and data formatting - Ability to create automation systems that run seamlessly without user interaction Please note, no user interaction is required for this project. The VBA program should be designed to run automatically once set up. This task is relatively simple but needs to be executed precisely and efficiently. Looking forward to working with a professi...

I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs

I'm need of an expert in Excel, particularly with a strength in creating complex calculation systems, for the task of data keeping. Key Tasks: - Understand and implement a data structure for holding financial data - Build a system for complex calculations within the excel sheet Qualities Needed: - Proficiency in Excel - Experience dealing with financial data - Ability to design and incorporate complex formulas for calculations - Analytical thinking The Excel sheet will specifically monitor and report Budget versus Actuals, so experience in handling these aspects are an added advantage. The goal is to have a seamless, reliable system for my financial data.

I'm in need of a skilled professional who can diligently carry out a large volume of data entry involving text, numbers, and images. The data is to be accurately entered into an Excel spreadsheet. Ideal Skills: - Proficiency in Excel - Accuracy in data entry - Ability to handle large volumes of data - Familiarity with processing text, numeric, and image data The right freelancer should have substantial experience handling this type of project and able to demonstrate precision and attention to detail.

I'm seeking an experienced Brawl Stars coach who can help me elevate my gameplay to the next level. Having played on both Android and iOS platforms, I've developed a decent understanding of the game but I want to push my skills further to become a formidable competitor. **What I'm Looking For:** - **Expertise in Brawl Stars:** Someone who has a track record of high achievement in the game and can provide proof of their skills. - **Coaching Ability:** Not just a great player, but someone who can teach. You should be able to analyze my gameplay and offer actionable advice. - **Focus Areas:** Since I'm looking to generally improve my gameplay, having a broad understanding of key strategies, character usage, and gameplay mechanics is essential. **Expected Outcomes:** - ...

I'm looking for a skilled Java developer to help with a dependency issue in my project. The dependency currently has a compile time scope and we need to update it to a test scope. This update is moderately important, but it is essential for the project's integrity. The main goal behind this update is to resolve conflicts with other dependencies. One of the modules of the project is using a class textContext from the package 'context' from the same dependency, madhattee.fixture. This class is primarily used for unit testing, and it's crucial that the update does not disrupt this functionality. Ideal skills for this job: - Strong Java development experience - Proficiency in managing and updating dependencies - Familiarity with testing frameworks, especially...

I need to organize my activities with my personal assistant to share files, emails, tasks, calendars Etc.

...for a skilled data entry freelancer to help me with the entry of text data from digital files. The entered data will be utilized for analysis purposes. Key Responsibilities: - Transferring text data accurately from digital files into a specified format - Ensuring the data is entered completely and error-free - Maintaining data confidentiality and security The ideal candidate for this project: - Has a proven track record in data entry, specifically with text data - Is meticulous and detail-oriented, with strong organizational skills - Has the ability to handle potentially repetitive tasks with accuracy and efficiency - Understands the importance of data confidentiality and is committed to upholding it Your s...

I'm in need of a skilled Excel expert who can help me build a formula that integrates data across multiple sheets. The formula needs to leverage advanced functions like VLOOKUP, INDEX/MATCH, and ARRAY. Key Requirements: - Advanced Excel proficiency - Expertise in VLOOKUP, INDEX/MATCH, and ARRAY functions - Experience with multiple sheets data integration - Strong problem-solving skills and attention to detail Please note that this isn't a project suited for beginners in Excel. You should have a proven track record in working with complex formulas and integrating data across different sheets. Your ability to deliver accurate and efficient solutions will be greatly valued.

I am struggling with incorrect results when attempting to subtract two values in a column of clock times in Excel. My data is in a 12-hour clock format, and I signify AM and PM directly within the time cells. I require an expert in Excel to address this issue promptly. To take on this project successfully, you should have: - Proficient Excel skills - Solid understanding of the 12-hour time format and functions in Excel - Ability to troubleshoot and rectify the problem quickly

I have some duplicate data that need to be copied to different sheets. - The project entails copying the duplicate information into different sheets. - The reasoning behind organizing the data into separate sheets is so that I can perform statistical analysis on each set distinctly. This will enable me to have cleaner and clearer results, helping in decision making. Ideal Skills: - Proficient in Excel or any other data manipulation software - Experience with data entry and copying