Excel macro data consolidationроботи

Мені потрібен макрос/скріпт/бот для гри, мені потрібно декілька раз проходити карти, однаково. Це 3д гра, я намагався сам розробити макрос але у мене з'явилась проблема на тому етапі, коли я хочу записати проходження карти Macro Recorder'ом, щоб в мене був макрос на проходження карти автоматичне, але коли я це записую, у мене не записується повороти камерою у грі. Прописувати дії у скрипт у ручну, я не намагався, бо загальне проходження біля 1 години.

Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.

Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.

Transfer news websites advertising texts...

Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией

Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.

I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.

I am in need of a comprehensive Excel sheet that does calculation. Data entry is not too complex; it includes dates, dropdowns and formulas. Requirements: - Design an Excel sheet that calculates basic arithmetic operations, performs statistical analysis, and handles financial calculations. - The form should be user-friendly and able to accommodate the moderate complexity of data entry. - I need an expert who can create a clear and concise interface for the user, making data entry and subsequent calculations easy and efficient. It would be great if the freelancer has experience with: - Excel design for calculation purposes - Data entry form design - Experience in basic arithmetic operations, statistical analysis, and financial calculations...

una pagina web que...seran enviados a su correo y whatapp, tambien tendran la opcion de cambiar su clave o recuperar su clave; los socios podran ver el historial de ventas, comisiones, pagos realizados, saldo, estadisticas, la informacion sera enviada a su correo y whatapp, tambien tendran la opcion de cambiar su clave y recuperar su clave. todo tiene que ser almacenado en una base de datos que se pueda exportar a excel, la pagina web tiene que ser amigable y podra visualizarse desde una computadora, tablet y telefono celular. la pagina web debe estar en idioma español y tener la opcion de cambiar a idioma ingles, el proyecto incluye el codigo fuente el proyecto debe tener la opcion de ofertar varias promociones a los clientes, estas promociones se deben visualizar al inicio ...

Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.

Let's do it. let's do it. let's do it

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I'm in need of an Excel expert to enhance my files. The tasks include: - Removing duplicate rows - Fixing formatting issues - Merging two sheets into one Additionally, I would like to incorporate a corporate branding style in the file, utilizing appropriate colors and logos. Ideal Freelancer: - Proficient in Excel with experience in data cleaning - Skilled in formatting and merging multiple sheets - Familiar with incorporating corporate branding within Excel

I need a detail-oriented and efficient freelancer to assist me with a data entry project. The specifics are as follows: - The project requires entering a combination of numeric and text data. - The goal is to have the data organized in a clear and coherent manner. The format of the data is likely to be in spreadsheets, although it may vary. Proficiency in Excel and Google Sheets will be essential for this task. Previous experience in data entry with formulas will be considered a plus. The ideal candidate will be able to deliver high-quality work in a timely manner.

I'm in need of a skilled developer to create a text-based GPT (Generative Pre-trained Transformer) specifically for analyzing excel outputs and give answer according to user pre-defined questions.

Active Directory Expert to create a Python script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, AD RMS (Rights management Services) group policy GPO etc. and export to a MS Excel File. More information attached.

I require a skilled developer to create a Windows-based low level keyboard emulator primarily for gaming purposes. Key Requirements: - OS Compatibility: The emulator should work on Windows systems only. - Emulation Focus: The main target of this project is to mimic keyboard inputs for gaming applications. Ideal Skills and Experience: - Profi...Caps Lock LED is on, and stop when it is off. Friends who want to provide a solution with 'keybd_event' and 'SendInput'; this method does not work. A lower-level approach is required Conditions: Notes: The keyboard emulator must work in the game. The project must be compatible with Windows 10. The project should use one of the following languages: C++, Python, or Pascal. Important Information: Macro usage in the game i...

I'm looking for a dedicated virtual assistant to assist me with simple data entry tasks. The data will be provided in handwritten notes. Ideal Skills and Experience: - Proficiency in data entry - Ability to handle simple copy-pasting tasks - Experience with handwritten notes data entry is a plus - Attention to detail and accuracy - Excellent time management skills - Familiarity with tools like Excel or Google Sheets for organizing the data Please note that while the tasks are straightforward, attention to detail is crucial. I'm looking for someone who can deliver accurate and timely results.

I desire a ...developer with a strong portfolio to create a macro for any use. The objective of the macro is to read a CSV file and automatically send a specific WhatsApp message to each phone number listed in the file. Key requirements include: - import a CSV file (Name,Given Name,Additional Name,Family Name,Phone 1 - Type,Phone 1 - Value) - Creation of a macro that automatically triggers WhatsApp messages. - The macro should be programmed to initiate the messages when it reaches a phone number listed in the CSV file. - The message is from CSV or default the same for all numbers in the CSV file. Ideal Candidate: - Proficiency and extensive experience working with Macrodroid. - A proven track record with similar projects. - Strong attention to detail to ensu...

What we have -------------------------- 1: Excel or CSV file. containing addresses to post letters 2: Letter Quality ( Paper weight, Sizes, Cost per letter etc configuration in JSON array) What we need -------------------- - Standalone PHP Script where we will be able to select an item from provided JSON. - Through DHL API we will validate the provided addresses(in the form of exel or csv) if each individual address is valid - or we should be able to select the areas of over choice over google map is shown in the provided video - this funcationaly is also provided over DHL api I think. and there demographic filters can also be applied which are provided be DHL api also shown in the video Please apply only if you the the required experience. these links may help

...documents and photos into simple data in Excel format (language is not in English workable when one can use translate and understand the few terms that are there). The ideal candidate will have the following skills and experience: - Proficient with MS office - Expert in handling MS Excel - Ability to follow a specific Excel template provided - Attention to detail to ensure accurate data entry ***The task is very simple and just requires attention to detail. I need mainly 4 Data Rows: 1. Date 2. Payor/Payee 3. Amount 4. Short Description of Transaction (if given in the doc) Please message me to talk about the project and the realistic bid price per Job. Your responsibility would be to ensure that the scanned files and photos are accurate...

We are an Ecommerce company dealing with variety products and we are looking for a Social Media Ads Manager to join our ...variety products and we are looking for a Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications skills Can work on Excel Have sufficient experience in Social Media Ads and ...

I'm looking for a skilled AI Developer to program module that speaks with AI (Gemini or GPT) as batch analysis of Excel files. Key Responsibilities: - Conducting pattern recognition and insights in the data Ideal Skills: - Strong AI development experience - Proficiency in Excel and data analysis - Ability to automate analysis processes

I require an individual proficient in VB macro script for Mach3. This project entails recreating a Mach4 script that particularly focuses on: - Arc motion control - Tool length calculation from spindle holder to tool tip - B/C axis management and position zeroing I have mach4 script that need to be rewriten to mach3 VB language, I have also a video how it works in mach4 fo refernece. You should be able to implement these specifications based on available documentation. Please remember that the recreated script should maintain as much fidelity to the original Mach4 script as possible. Ideal skills and experiences for the job include: - Familiarity with Mach3 and Mach4 CNC software - Expertise in creating VB macro scripts - Understanding of CNC machine operation, particul...

I am seeking an experienced Power BI expert who can assist with generating intermediate reports. This role involves: - Working with Excel datasets. - Developing seamless processes to generate user-friendly reports. - Troubleshooting any issues that may arise during report generation. The ideal freelancer should have: - Excellent understanding of Power BI. - Experience in report generation. - Adept knowledge in handling Excel datasets. - An analytical mindset with attention to detail. Proficiency in Excel and experience with intermediate report generation will be highly advantageous.

I'm looking for an experienced Excel expert to create a customized spreadsheet for my construction project. The primary usage of the sheet will be for material and labor cost estimation, and I need it to include visualizations in the form of charts for budget allocation. Key Tasks: - Set up the sheet with the right formulas and functions to ensure accurate calculations for material and labor costs. - Design the sheet to be user-friendly, yet professional in appearance. The ideal candidate should have: - Proficient knowledge and experience in using Excel for construction projects. - Prior experience in creating similar spreadsheets with formulas and visualizations. - An understanding of the construction industry and the specific needs of this field in terms of estima...

I have a complex Excel file with more than 10 worksheets that I need help with. The project involves three main tasks: data entry, formulas and calculations, and data analysis. Key Responsibilities: - Data Entry: - Ensure accurate entry of information across various tabs - Formulas and Calculations: - Implement necessary formulas and calculations to make sure that the data is accurately processed - Data Analysis: - Utilize Excel functions for data analysis Skills and Experience Required: - Proficient in Excel, including strong skills in data entry and formula creation - Experience in data analysis and visualization would be a plus - Attention to detail and accuracy are crucial as the data is sp...

necesito un Software punto de venta con estas caracteristicas Especificaciones • Software de escritorio • Base de datos mariadb • Control de Licencias de manera remota con servidor • Demo de presentación • Grabado de videos de su desarrollo paso a paso Menú principal • En forma de pestañas • iconos e...teléfono 6. Correo 7. Sitio web 8. País 9. Departamento 10. Ciudad 11. Creador de moneda 12. Logo foto 13. Facturas tamaño carta y recibo 14. Creación de formas de pago 15. Creador de impuesto porcentaje de uso RESPALDO DE BASE DE DATOS 1. Respaldo de base de datos manual 2. Respaldo de base de datos al cerrar programa Configuración 1. Subida y bajada de productos de forma masiva con tablas de ...

Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation

I want someone who can create a database in Excel/Access for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List) with the field names I will provide. 2- A list of all Contracts with the field names I will provide. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. The database should have a main page, with link to the above mentioned list pages plus Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages. For Add New Invoice page, I should be able to add an invoice details in it, and if it's related to a contract or purchase order, I should ...

Functionality: Data Collection: Retrieve historical stock data (price and volume) for a given set of stocks from a reliable financial data provider (e.g., Yahoo Finance, Alpha Vantage). Store the data in a suitable format (e.g., CSV files or a database). Data Preprocessing: Clean and preprocess the collected data, handling missing values and ensuring consistent formatting. Calculate necessary technical indicators, such as moving averages (e.g., 50-day, 200-day), Relative Strength Index (RSI), and trading volume. Technical Analysis: Implement functions to identify bullish signals based on technical indicators, such as: Moving Average Crossovers: Detect when a shorter-term moving average crosses above a longer-term moving average (e.g., gold...

I’m in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data accuracy This will be a valuable addition to our w...

...need an Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage. The Excel sheet should track the following: - Project cost - Project revenue - Project expenses - Percentage of account receivable - Percentage of account paid - How the client paid after tax - Description for the costs - Percentage of the costs - Percentage of the profit before tax - Percentage of account receivable before tax - Date of payment The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit calculations, as well as capability to...

We are looking for freelancer for technological catalogues redesign and build in adobe indesign. Freelancer should be expert in adobe indesign, photoshop, ilustrator. We provide example project templates in adobe indesign, source data in pdf and excel. Based on source data our catalogue should be created and redesigned as template project. Project should be done in adobe indesign for printing and web

...with over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversions would be a ...

--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - Automat...

...looking for help from a talented programmer with C++ experience and low-level programming knowledge. The main purpose of this project is to develop a keyboard input emulator specifically for gaming purposes. Basic requirements: - Compatibility: The emulator must be designed to run on Windows operating systems. - Programming Language: It is important to develop the emulator using C++. - Purpose: Macro tests will be performed with the emulator in the game. Your role will be as follows: - Design and develop a reliable and efficient keyboard input emulator for gaming. System level programming is required. (It will simulate the keyboard on the hardware and perform keydown and keyup operations. I want it to press the z1 key when the Capslock LED is on. I want it to stop when it is tu...

Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understand...

I am looking for an expert who can as...expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compat...

...AI assistant with a focus on language understanding and real-time conversation support. Key Features: - Cross-Platform: The app should be developed for both iOS and Android, ensuring a wide user base. - Page Translation: Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency in React Native for cross-platform development. - Experience in building apps with live translation capabilities. - Strong background in AI development, specifi...

I am in need of a freelancer who can accurately convert my PDF files into Excel. The materials consist mainly of printed, electronically generated text. Given the nature of the work, the ideal candidate should: - Be proficient in both PDF and Excel formats - Have an eye for detail to ensure accuracy - Have experience dealing with extensive text documents - Possess strong typing and data entry skills Please bid if you fully understand the tasks and feel capable to deliver high-quality results. Your attention to detail and commitment to accurately completing tasks would make you an ideal candidate for this project.

...is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation from SQL data - Excellent problem-solving skills and log...

For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!

I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experience, and can start work...

I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.

I'm looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant...

...details : a) Mobile Number (Must verify through OTP) b) Email id (Must verify through OTP) c) GST Number (if available ) d) Google map location (if available) after successful registration customer can login and request quotations 3. All the products details like: Product Name, photo, description, features, pdf (data sheet), warranty information, stock (available quantity), sale prices etc. can be uploaded directly through portal and mobile app and also can be uploaded through excel sheet with serial number of all products. 4. Customer can see all the uploaded products and can request for quotation. There is no need to show the available quantity (stock) to customers. 5. Admin can see the requested quotes where the prices and quantity will be reflected of all the product...

I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.