Vba script excel xmlроботи

З приводу обмінів залишків API. Ми надаємо дані у вигляді xml-файлів, які з вашого боку підхоплюються скриптом і впроваджуються в CMS (це повинні зробити програмісти на вашій стороні). Плюс програмістам з вашого боку потрібно буде налаштувати та поставити в крон парсер, який звертатиметься за xml-файлом розвантаження. Для отримання доступу до вивантаження файлу - підтвердьте IP-адреси вашої мережі, з якої надходять запити. У вкладенні – інструкція щодо формування запитів. У ній є опис наших тегів і три приклади коду на PHP, C# і AJAX (залежно від мови, яка використовується у вашій системі або зручна для програміста). Звертаю увагу, що у запиті вказується e-mail та пароль, які використовуються для входу на наш портал. Адреса сервісу вказана в інструкції, дублюю її тут:...

Потрібно налаштувати вже робочу синхронізацію прайсу між сайтом та Prom ua Сайт віддає прайс у форматі xml, який формується за допомогою плагіну у виді як на скріншоті. 1)Необхідно налаштувати двомовність фіду, зараз тільки одна мова 2)Правильне визначення категорію товару промом - "Категорія на маркетплейсі" 3)Налаштування переміщення товарів із свого розділу на сайті до аналогічного розділу на промі (категорії збігаються)

Потрібний спеціаліст для редагування 4 XML фідів на платформі Mergado.com. Внесення змін у доставку, зміна цін, заокруглення, зміна параметрів товарів а тд. Або потрібне інше рішення яке дозволить автоматизувати створення XML фідів на основі таких правил Працюємо до коректного відображення всіх змін на вихідному фіді.

Нужен скрипт для загрузки товаров на сайт из фидов форматов xml/yml/api. Товары от разных поставщиков нужно обьеденить согласно категорий и подкатегорий сайта. CMS Wordpress. Также скрипт должен автоматически обновлять информацию о товарах (наличие и цена) 1-2 раза в день.

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

Робота для програміста з досвідом роботи в Python + XML. В додатку є svg файл , що по суті є XML документом. В цьому файлі де-які відрізки є ідентичними за своєю довжиною, розміщенням і координатами і дублюються. Мені треба якось підрахуати скільки разів зустрічається кожен відрізок у файлі та створити новий файл у якому будуть всі відрізки з початкового файлу але без дублікатів + в атрибутах відрізків буде новий атрибут "numba", значення якого дорівнюватиме кільксті дублікатів цього відрізка, що було знайдено в початковому файлі ''" Хочу отримати ipynb файл, який би я міг запустити на виконати його і отримати Перевага виконавцю з України.

Необхідно розробити jquery плагін, що буде дозволяти дінамічну зміну компонентів продукту та їх опис з подальшою пере...net/layout/) або розробка нового. Обговорюється. У разі швидкого успішного виконання можлива постіна співпраця на довготривалому проекті. We need and jquery plugin, that will allow a dynamic changing of pruduct options (look) and its description with sending the result to db (add to cart, separate button). You can update the existing script ([login to view URL]) or write the new one. It's a matter of discuss. It's possible to get a long term deal if this project will be finished well and fast.

При роботі з деякими pop3/imap серверами за допомогою fetchmail час від часу виникає помилка, наприклад: fetchmail: Unknown login or authentication error on user@server fetchmail: socket error while fetching from user@server При цьому логін/пароль вірний, так як через декілька спроб запит виконується успішно. Завдання - написати скрипт, котрий буде відстежувати помилки вказані вище, засинати на певну кількість секунд і пробувати знову. На початку скрипту повинні бути налаштування: 1) кількість спроб 2) час очікування між спробами 3) перелік типів помилок, які повинні бути відстежені за текстом помилки для виконання наступних спроб, наприклад %socket error while fetching from% 4) перелік exit codes (вказані в man fetchmail), які повинні бути відстежені за номером коду для виконання на...

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

Transfer news websites advertising texts...

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

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

I am looking for someone proficient in typing to convert content from a 30 page PDF into Word and Excel documents. The majority of the content will go in Word with a few items to be transcribed into Excel. Requirements: - High typing accuracy and speed - Familiarity with Word and Excel formatting Specific instructions: - For Word, the content should be formatted in Calibri 12 point font and single spaced. - For Excel, maintain one row per entry for optimal readability. Ideal candidates should have prior experience in similar data entry tasks. Familiarity with PDF conversion tools, text formatting, and spreadsheet management would be a plus.

...can export the text and numeric data from a PDF table into an Excel spreadsheet. I would like the Excel data to be organized according to the fields in the PDF table. All fields in the PDF table should be included in the Excel sheet. Key requirements: - Export text and numeric data from a PDF table into an Excel spreadsheet - Organize the data on Excel according to the fields in the PDF table - Include all fields in the PDF table in the Excel sheet Ideal Candidate: - Proficient in PDF to Excel data transfer - Excellent attention to detail for verifying and cross-checking data - Familiarity with text and numeric data formatting in Excel - Capable of delivering accurate and organized final results. There will be 901 rows of Ex...

...diligent freelancer with strong attention to detail and experience with Microsoft Excel and Shopify for a data entry project. Having a deep understanding of these two platforms is crucial to the seamless execution of the task. The project involves: - Using a spreadsheet to find and identify approx 4500 books on Amazon. - Using an online import tool to bring book data into a Shopify website - Adding extra product information in the shopify website from the spreadsheet about the book. - Determine the genre of the book and categorising in shopify accordingly. The ideal candidate should have: - Proven experience in data entry, preferably within Shopify. - Access to US version of Amazon. - Proficiency in Microsoft Excel. - High level of accuracy and organisation. - Good leve...

I need a PHP script to calculate working hours based on the start and end time. The script should: - Calculate working hours based on the start and end time - Handle only standard working hours - Automatically deduct a fixed break time Ideal skills and experience for this project include: - Strong PHP programming skills - Experience with time and date calculations - Understanding of working hour calculations and break time deductions - Ability to create a clean and efficient script

I'm in need of an accomplished JavaScript developer to fine-tune my current JSON to XML conversion process for Roku. The entire focus is on enhancing the accuracy of format. As the matter is of utmost importance, I need this to be executed with immediate effect. - Key Task: Refining the JSON to XML conversion for Roku. - Required Expertise: Advanced proficiency in JavaScript and a solid grasp in handling JSON and XML data types. - Timeline: Urgent. The need is for it to be completed as soon as possible. Your responsibility would be to scrutinize the current programming and effectively enhance its format accuracy. Proven experience of similar tasks will be considered a significant plus. Your ability to prioritize tasks and deliver solutions promptly will be high...

As the client, I am looking for a reliable professional to build a customized Excel plugin that will enhance my financial data management. Key Features: - Automatic Calculations: The plugin should be capable of performing automatic calculations, saving time, and minimizing any possible errors. - Data Validation: Ensuring data accuracy is crucial, thus the plugin should include data validation steps that help identify and correct any inaccuracies promptly. - Customizable Formatting: To enable smoother navigation and interpretation, the plugin should allow for customizable formatting tailored to my data and personal preferences. - Model Versioning: Unlike other models that auto-update or create new versions, I require a plugin that allows me to manually select the version to w...

I have a list of addresses for invitations that need to be transcribed from a handwritten list into an Excel spreadsheet. The addresses should be formatted consistently in the following structure: Name, Street Address, City, State, Zip Code. - Handwritten list will be provided, and should be transcribed accurately - Standardize the address format for consistency - No correction needed for typos, just ensure the format is standardized The ideal freelancer for this project would have: - Proficiency with Excel for data entry and formatting - Attention to detail to ensure accuracy and consistency - Experience with handling addresses or similar data is a plus

I'm seeking an experienced Excel professional to assist with the implementation of various financial formulas and functions in my spreadsheets. I am trying to create an excel sheet for sales people to put some data entry and get final pricing. i have the basic excel sheet ready, and if you willing to work on it i can share it and explain in more details In particular, I need help with: - The execution and application of financial functions specifically. - An ability to accurately conduct cost and estimating calculations. - Strong problem-solving skills to fine-tune formulas for efficiency and accuracy. A background in finance and substantial experience with Excel's wide array of financial functions would be very advantageous for the successful completion o...

I'm in need of a sophisticated chatbot solution. This chatbot should have the capability to interact with and analyse documents uploaded to it – including PDF, Excel, and Word files. Here is what I am expecting: Document Interaction: • Extract information from PDF, Excel and Word files • Provide document descriptions that enable efficient and informative interactions Graph Generation: • Generate graphical representations from data extracts • Capable of creating bar charts, pie charts, and line graphs Desirable Skills & Experience: • Expertise in Django is a must • A good understanding and experience of GT4 API • Knowledge of ORM and DRF • Familiarity with data visualization may come in handy To recap, I'm seek...

We have a Solana Trading Bot designed to automate the buying and selling of tokens on the Solana blockchain. It is configured to execute trades based on predefined parameters and strategies set by the user in the .env file. The bot can monitor market conditions in real-time, such as pool burn, mint renounced and other factors, and it will execute trades when these conditions are fulfilled. There is a bug taking place in one of the filters. Specifically the mint renounced filter. We have checked with other sources to confirm this bug. In short, the renounced filter checks if the creator of a token has disabled the mint and freeze authority of the new token. As of right now, when our users set this filter in the .env file as "CHECK_IF_MINT_IS_RENOUNCED=true", when the trace log i...

I need a proficient freelancer to assist in the conversion of a PDF and an Excel file into a CSV format, specifically tailored for WIX integration. Key Requirements: - Conversion of a PDF file into a CSV format. The PDF contains crucial information that needs to be extracted and transformed into an easily readable and usable format for WIX. - The Excel file contains customer data, specifically including names, email addresses, and phone numbers. This information should also be integrated into the CSV file. Ideal Skills and Experience: - Strong expertise in data conversion, particularly from PDF and Excel to CSV. - Familiarity with WIX Integration - including the ability to format the CSV file in a way that is ready for immediate use in WIX. - Experience handling cus...

I'm in need of a professional to help populate my BIGIN CRM with contact information from an Excel file. The task will involve: - Transferring data from Columns A, B, C of my Excel file to BIGIN CRM. - Achieving appropriate data segregation based on geographic location within the CRM. This task will require a keen attention to detail and strong experience in and BIGIN CRM and integrate emails to Outlook. A solid understanding and experience in data segregation & bIGIN PLATFORM is also key for successful delivery of this project. The aim is to streamline my contacts for easier management. Your keen knowledge of geography and ability to dissect contact data is highly needed.

As someone struggling with certain aspects of Excel 2016, I need an experienced VBA Developer who can assist in creating custom Excel functions and rectifying existing Excel errors. Key duties will include: - Macros programming to automate repetitive tasks - Troubleshooting and fixing inaccuracies in the current Excel functions, if any Despite my lack of specificity about the exact functions or errors, I expect the developer to have a strong understanding of Excel functions in general and to use this knowledge to identify any issues that may exist. Ideal candidates should: - Have significant experience in VBA development - Have a solid understanding of custom Excel functions - Be proficient in troubleshooting & error handling...

I need to have an excel sheet to track expenses made on each items coming under 'purchases for office construction works', stationery for office, project software tool like project management tools, hosting service plans etc also for nterior decoration, expense on inaugration and also i need to list expected cost for future purchases

I am currently in need of a proficient Excel expert capable of aiding me in data analysis for my investment data portfolio. The Ideal Candidate Should: - Have in-depth knowledge and experience in Excel, particularly in handling and managing large amounts of data with efficiency. - Be familiar with investment-related data and understand trends to aid in analysis. - Be able to demonstrate past work on similar projects, ideally in the investment sector. Project Scope: - The task involves in-depth data analysis of my investment portfolio which encompasses various types of data. - The freelancer will need to interpret and analyze the data using advanced Excel formulas and techniques. The successful freelancer should include their past work in their application. An unde...

I require an expert in Python and Excel to assist with data analysis and manipulation tasks. The central focus will be: - Data Reshaping: You'll be transferring data from daily received *.xls files to a timeseries database. Tee database must be updated regularly, every day when one or more new datasets are available. - Data Cleaning: This involves improving the quality of data in our Excel files. Inaccuracies are often a result of missing data, which you'll need to identify and rectify. Key skills and experience needed: - Proficient in using Python with Excel for data analysis and manipulation. - Expertise in data cleaning, particularly in identifying and addressing missing data, double occurences, inconsistent datas - Experience in reshaping data i...

I'm looking for a VBA programmer to help me with creating custom functions and macros for data analysis in Excel. Key Tasks: - Creating Macros: The project involves developing macros that can automate repetitive tasks and facilitate data analysis. - Building Custom Functions: I need custom functions to aid in data cleaning and manipulation, as well as report generation. Ideal Skills: - Proven experience in VBA programming, especially in Excel. - Strong background in automating tasks and data analysis. - Ability to develop custom functions for data cleaning and report generation. Output: - The generated reports should be in an Excel spreadsheet format, as well as a PDF document. Please provide samples of your previous VBA work, specific...

I have a powershell script that is made to work as a DNS utility that will allow me to create/delete/update DNS entries. It is not currently able to handle CNAME as i think it was made to handle A records based on the create scetion of it. I need it be able to do all 3 fuinctions on different record types with thier individual required inputs. One of the main problems im running into is it is not able to handle a hostname instead of IP4 when trying to run it. I need it done very promptly. Preferably today.

I'm looking for a skilled MS Excel professional who can work on a multi-sheet file that requires data analysis, formula application, and design enhancements. Key Requirements: - Data Analysis: The primary aspect of this project is to analyze the existing data. - Formulas and Functions: Implementing formulas and functions to drive accurate calculations and insights. - Formatting and Design: Enhancing the visual appeal of the sheets, ensuring they are user-friendly and professional. The file contains 2-5 sheets, and I anticipate that the work will involve a mix of data analysis, formula implementation, and design adjustments. Since I've opted to complete the project, I'm open to any additional suggestions you might have to enhance the overall functionality of the she...

I'm looking for a skilled developer who can create a custom trading script in Pinescript on the TradingView platform. This script will be based on identifying and monitoring market trends. Key Project Details: - The script should be able to accurately identify a trend based on the definition of "higher highs and higher lows". - When a trend is identified, the script should take no immediate action but continue to monitor the market conditions. Ideal Skills and Experience: - Proficiency in Pine Script and experience with TradingView platform. - Strong understanding of technical analysis, particularly in the context of identifying trends. - Previous experience in developing trading scripts or bots is highly advantageous. - A background in ...

In order to effectively drive my ongoing project, I'm in need of someone skilled at gathering specific data and preparing it into a highly organized spreadsheet. The data needed include: - Name - Email - Job/Business - Phone number(Whats app) of (NRI) Non Resident Indians in UAE The ideal ca...specific data and preparing it into a highly organized spreadsheet. The data needed include: - Name - Email - Job/Business - Phone number(Whats app) of (NRI) Non Resident Indians in UAE The ideal candidate for this task should demonstrate: - Proficiency in data collection, and data management. - High level of accuracy and attention to detail. - Proven experience in sourcing data and utilizing Excel or similar spreadsheet software. Looking forward to advancing my project with ...

I need someone to transcribe the content of the picture to a excel as the same way. I have 100 picutures like this one. How much for this job?

My powershell script calls a function to get a filtered list of servers. When the filter returns a single server, (.count) or (.length) returns nothing. Only works when the filter returns multiple servers. Need help to debug and fix so it returns always.

I need an experienced professional to create an XML file for me. The file will be primarily text-based, with no need for images or tables. Key Responsibilities: - Create a custom schema for the XML file - Ensure that the text content is structured appropriately within the XML file - Deliver the file in a timely manner Ideal Skills and Experience: - Proficiency in XML creation - Experience in creating custom schemas - Attention to detail - Ability to work independently - Good communication skills, as you may need to clarify certain aspects of the project. Please note, I will rely on your expertise to create a suitable schema for the XML file. The end goal is to have a well-structured and functional XML file.

My Excel file is very heavy and unorganized. I want it to get cleaned and effecient

I'm looking for a skilled graphic designer to create an attractively minimalistic logo for my landscaping business. Emphasizing on green, black and transparent colors, the design should feature 3 trees. Do not want blended/faded colors, all solid colors. It can incorporate the name "Megan Montgomery Design" in a script font, but does not have to have this text. It could also incorporate the letters "MMD" within or among the trees, but does not have to. Here's what the project entails: - Incorporate green and black colors dominantly. - Design should be stylishly minimalistic. - The logo will be featuring on both digital platforms and merchandise. Ideal experience and skills for the job would include: - Proficiency in minimalistic design - Experienc...

We have setup an XML feed custom made + Merchant center but the products never appear when we expect them to for names of products for example, need someone to look through and find out the issue

I’m looking for a freelancer proficient in Excel who can create a dynamic tool for my restaurant business that helps in managing my food costs and menu pricing calculations. Key responsibilities include: 1. Cost Analysis: Crafting a spreadsheet that can factor-in: - Food cost percentage - Gross profit margin - Break-even analysis 2. Menu Pricing: The spreadsheet should provide calculations on: - Menu item profitability - Menu item pricing based on the desired profit margin Ideal candidates are detailed-oriented and have substantial knowledge in cost analysis and pricing strategy in the restaurant industry. Excel expertise including functions and formulas is paramount. Past experience in successfully building such tools will be a definitive plus.

We're on the lookout for skilled animators adept at infusing life into our milkbag persona through captivating and witty Instagram Reels and animated content. Our ideal candidate possesses a solid grasp of animation principles and consis...of content we're aiming for. We aspire to achieve a similar level of ingenuity and amusement in our milkbag character Instagram Reels. How to Apply: If you're passionate about animation and possess a talent for crafting entertaining Instagram Reels and understand cryptocurrencies and trading we're eager to hear from you! Please include your portfolio and a brief statement outlining why you'd excel in this role in your application. Additionally, feel free to share any relevant experience or ideas on bringing our milkbag c...

I need a simplistic, one-page website linked to a database. This page will have limited content, including a logo and a 'check authenticity' button. The database will be provided in an Excel sheet format, and must be integrated seamlessly into the page. Key Requirements: - Develop a one-page website - Integrate an Excel database for product authentication - Provide a clean, simplistic design Ideal Skills and Experience: - Experience in web development, particularly one-page websites - Proficiency in database integration, specifically Excel - Ability to create clean and minimalist designs - Strong understanding of web security and authentication processes

I'm seeking an expert in data analysis to help with profiling and analyzing our financial data. The ideal professional will have the following experience and skills: - Proficient in financial data analysis - Able to generate comprehensive analytical reports - Experienced in Excel for data presentation

I need an experienced PHP developer to help with customizing a PHP script. The specific details of the modifications are: - User Authentication: Implement an effective user authentication system. - Database Integration: Ensure seamless integration with our existing database. - UI/UX Enhancements: Enhance the user interface and user experience of the script. Please note that the specific PHP script has not been disclosed, and further details regarding the script's functionalities have not been provided. The successful freelancer will need to be able to navigate and modify PHP scripts efficiently and have a good understanding of user authentication, database integration, and UI/UX principles. Your expertise in PHP and familiarity with various scripts and their m...

I need a Pine Script expert to create an alert for my custom indicator. Key Requirements: - Develop a set of codes to let my custom indicator to send signal - Mainly, I use daily chart but I want the signal to create an alert before the bar close. For instance if the daily bar close at 4:00 am, it has to calculate everything around 3:45 am and then send the signal immediately after that. - Please note that I have my custom indicator finished written so you might like to create the signal only when the conditions are met. Ideal Skills: - Strong Pine Script and Trading Indicator experience. - Excellent understanding of trading and financial markets. - Ability to optimize code for performance. - Effective communication and support for the project.

I'm searching for a skilled Virtual Assistant (VA) to manage a small inventory of less than 100 entries. Your responsibilities will include: - Data entry: Accurately inputting necessary information into our system. - Spreadsheet management: Expertly organizing and managing our inventory data in Excel. - Reporting: Creating clear, concise, and actionable reports based on the inventory data. To execute these tasks proficiently, you should be well-versed in the SUMIF and Pivot Tables functions in Excel. Prior experience in managing small to medium-sized inventories will prove beneficial. Your ability to pay attention to detail, demonstrate excellent problem-solving skills, and deliver results in a timely manner will be important for success in this role.

summarize in a specific table in Excel

Hi Ravi Ranjan K.,I have a task of import of purchase excel to tally prime for now .

I'm in need of an expert in Excel for data entry and cleaning. The tasks involve handling text-based, numeric, and date & time data. Key Responsibilities: - Perform accurate data entry - Cleanse and format the data as needed Ideal Skills and Experience: - Proficiency in MS Excel - Proven experience with data entry and data cleaning - Attention to detail - Ability to work with various data types, including text-based, numeric, and date & time data

I am currently using ZOHO Books and am looking to migrate to Odoo Accounting. I need an Excel expert to help with the migration process. Key Tasks: - Migrate complete set of invoices and bills from ZOHO Books to Odoo Accounting. - Transfer all customer and vendor details accurately to Odoo. - Ensure that financial reports are maintained and migrated correctly. Ideal Candidate: - Proficient in both ZOHO Books and Odoo Accounting software. - Excellent experience in data migration and Excel. - Familiar with maintaining and handling large databases. - Detail oriented, ensuring data integrity throughout the process. This is a large scale project as my current ZOHO Books database exceeds 1000 records. I need someone who can efficiently and effectively handle the migration proc...