Excel macro xml csvроботи
З приводу обмінів залишків API. Ми надаємо дані у вигляді xml-файлів, які з вашого боку підхоплюються скриптом і впроваджуються в CMS (це повинні зробити програмісти на вашій стороні). Плюс програмістам з вашого боку потрібно буде налаштувати та поставити в крон парсер, який звертатиметься за xml-файлом розвантаження. Для отримання доступу до вивантаження файлу - підтвердьте IP-адреси вашої мережі, з якої надходять запити. У вкладенні – інструкція щодо формування запитів. У ній є опис наших тегів і три приклади коду на PHP, C# і AJAX (залежно від мови, яка використовується у вашій системі або зручна для програміста). Звертаю увагу, що у запиті вказується e-mail та пароль, які використовуються для входу на наш портал. Адреса сервісу вказана в інструкції, дублюю її тут:...
Потрібно налаштувати вже робочу синхронізацію прайсу між сайтом та Prom ua Сайт віддає прайс у форматі xml, який формується за допомогою плагіну у виді як на скріншоті. 1)Необхідно налаштувати двомовність фіду, зараз тільки одна мова 2)Правильне визначення категорію товару промом - "Категорія на маркетплейсі" 3)Налаштування переміщення товарів із свого розділу на сайті до аналогічного розділу на промі (категорії збігаються)
Потрібний спеціаліст для редагування 4 XML фідів на платформі Mergado.com. Внесення змін у доставку, зміна цін, заокруглення, зміна параметрів товарів а тд. Або потрібне інше рішення яке дозволить автоматизувати створення XML фідів на основі таких правил Працюємо до коректного відображення всіх змін на вихідному фіді.
Мені потрібен макрос/скріпт/бот для гри, мені потрібно декілька раз проходити карти, однаково. Це 3д гра, я намагався сам розробити макрос але у мене з'явилась проблема на тому етапі, коли я хочу записати проходження карти Macro Recorder'ом, щоб в мене був макрос на проходження карти автоматичне, але коли я це записую, у мене не записується повороти камерою у грі. Прописувати дії у скрипт у ручну, я не намагався, бо загальне проходження біля 1 години.
Нужен скрипт для загрузки товаров на сайт из фидов форматов xml/yml/api. Товары от разных поставщиков нужно обьеденить согласно категорий и подкатегорий сайта. CMS Wordpress. Также скрипт должен автоматически обновлять информацию о товарах (наличие и цена) 1-2 раза в день.
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Робота для програміста з досвідом роботи в Python + XML. В додатку є svg файл , що по суті є XML документом. В цьому файлі де-які відрізки є ідентичними за своєю довжиною, розміщенням і координатами і дублюються. Мені треба якось підрахуати скільки разів зустрічається кожен відрізок у файлі та створити новий файл у якому будуть всі відрізки з початкового файлу але без дублікатів + в атрибутах відрізків буде новий атрибут "numba", значення якого дорівнюватиме кільксті дублікатів цього відрізка, що було знайдено в початковому файлі ''" Хочу отримати ipynb файл, який би я міг запустити на виконати його і отримати Перевага виконавцю з України.
Потрібно реалізувати автоматичну вигрузку csv файла з фтп в БД сайта. На сайті повинно бути поле вводу номера телефона (для перевірки кількості бонусів на сайті) після вводу, людині повинна прийти смс з кодом підствердження, після вводу відкривається інформація про клієнта, а саме ПІБ, номер телефону, номер бонусної картки та кількість накоплених бонусів
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Потрібно розробити імпорт інформацію з csv файлу та створити під неї сторінку телепередачі для сайту Детальне ТЗ в доці Приклад файлу імпорту прикріплений, для імпорту буде такий же, але в форматі csv
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
Laravel who can start immediately. Work with ftp only. Import excel work
Yesterday, OpenAI released the new module "ChatGPT 4.0". I want to create a video on how to automate and visualize Excel files using this new version. The thumbnail should include my face, the Excel logo, the OpenAI logo, and the text "Automate Excel with ChatGPT 4.0".
I am in need of a professional web scraper with Python expertise, who can scrape data from a website(with filter Options) and convert it into Excel format. Key Requirements: - Expertise in web scraping with Python, including dealing with website search filters. - Proficiency in data extraction and manipulation. - Experience in converting extracted data into Excel format. Please note that the specific website and the type of data to be extracted has not been provided as it was skipped by me. The project can be detailed further with the selected freelancer. If you have the skills and experience in this area, please do apply.
...a logo for the "FCA Jugend Förderverein e.V." The association was founded in 2012 and focuses on nurturing young talent in football. **Brief Overview:** - **Name:** FCA Jugend Förderverein e.V. - **Year Founded:** 2012 - **Colors:** Black and Orange - **Description:** The association is dedicated to promoting youth football development and providing opportunities for young players to grow and excel in the sport. **Design Requirements:** - The logo should reflect the essence of youth, growth, and football. - Incorporate elements that symbolize progress, teamwork, and dedication. - Use the colors black and orange prominently in the design. - Avoid complex designs and aim for simplicity and clarity. **Additional Information:** - Feel free to experiment with...
I'm looking for a virtual assistant to help with email management, data entry, and simple analysis in Excel. Key Responsibilities: - Sorting and organizing less than 50 daily emails - Responding to customer inquiries promptly - Filtering spam emails effectively - Entering new data into Excel - Updating existing records - Creating basic reports and charts The ideal candidate should have: - Excellent email management skills - Strong communication and customer service skills - Proficiency in Excel for data entry and basic analysis - Ability to work accurately and swiftly - Prior experience in similar roles is a plus. This is a long-term project with potential for growth.
I have a detailed list on an Excel sheet that I need converted into an organizational chart. The chart needs to include information like 'Grade', 'Nationality' and 'Occupation' and display them in a visually appealing format. Key Requirements: - Convert an Excel sheet which consists of approximately 140 line items into an organizational chart. - Display the following information in the chart: 'Grade', 'Nationality' and 'Occupation'. - Create visual lines connecting positions to indicate the reporting relationships. - Provide the final output in both PowerPoint and Visio formats. Customization: I am looking for a moderate level of customization in the design of the organizational chart. This includes playing wit...
I'm seeking a skilled individual to a... The spreadsheet will be primarily used for inputting income and expenses and should be updated on a monthly basis. Key requirements: - Design and development of a custom cash flow spreadsheet - Implement budget tracking, expense categorization, and cash flow projections - Ensure ease of use and understandability for monthly updates Ideal Skills: - Proficiency in spreadsheet software (e.g., Excel, Google Sheets) - Experience in creating budget tracking and cash flow projection tools - Strong understanding of financial data and analysis I'm looking for someone who can deliver a high-quality, user-friendly spreadsheet that meets these requirements. If you have relevant experience and think you're a good fit for this project, I...
I require a freelancer to assist with a one-time copy typing project. The task involves entering data from a single document into an Excel spreadsheet. Ideal Skills and Experience: - Proficient in copy typing - Proficient in Excel - Attention to detail and accuracy - Previous experience in similar projects is a plus.
The program must be compatible with Windows 10, which searches for data inserted from a CVS file, therefore which has the possibility of loading a CVS file (one or more files) which, through a search window, tells me whether a certain value (alphanumeric) is present in the CVS file. If you have uploaded more than one, please tell me which one it belongs to. I already have the initial screenshot to show when starting the software and the one of the search window that I will provide, upon acceptance I will also provide a flowchart that explains in detail.
ADMIN ASSISTANT Required - Bookings - Email and Messenger correspondence - Online Advertising on Facebook Marketplace and Gumtree - Search online information - Excel Spreadsheets - Bookkeeping - Office work Job is full time Monday to Friday Thankyou
I'm in need of a Excel setup algo that can execute orders on Zerodha from excel file. I require the following features: - One click button: The system should be able to place and execute my selected orders from excel with one click button. - Customizable Order Parameters: I need to be able to set my own order parameters, including the stock, quantity, price, and other variables. The ideal freelancer for this project should have experience in: - Developing python algo application with excel. - Integrating with Zerodha API. - Implementing automated trading systems. - Creating user-friendly interfaces, with some level of custom design.
As a client seeking to improve my understanding of excel, I would like a skilled instructor to guide me through the basics of formulas and functions, data analysis and reporting, as well as formatting and conditional formatting in Excel. Although I don't have a specific completion time, expediency is appreciated. Skills and experiences that would be ideal for this job: - Advanced Knowledge of Excel - Excellent Teaching Skills - Flexibility to cater to learning pace No preference was selected for the type of learning medium, so offering a blend of online videos, live training sessions, and written instructions could be beneficial to cover all bases.
ADMIN ASSISTANT Required - Bookings - Email and Messenger correspondence - Online Advertising on Facebook Marketplace and Gumtree - Search online information - Excel Spreadsheets - Bookkeeping - Office work Job is full time Monday to Friday Thankyou
Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.
I'm in need of a detail-oriented and communicative Virtual Assistant to manage key elem...reconcilliation of payments & invoices - Assisting with keeping track of repairs using Zoho Desk - Handle customer support inquiries via Email, Phone, and Live chat --Respond directly to basic queries --Forward on relevant information to our local staff - Execute order management tasks The ideal candidate should have: - Excellent written and verbal communication skills - Data management and excel skills are critical - Ability to manage multiple tasks simultaneously - Familiarity with various customer support and order management tools - Available for 4-8 hours per day. - Experience with Zoho one - Understanding of laptop parts or experience in the laptop repair industry Please quot...
...freelancer who can handle both video editing and excel management. - Video Editing: I have various types of videos that need to be edited. This includes marketing videos, tutorial videos, event videos, and reels. The ideal candidate is proficient in video editing tools and can create engaging, professional videos that suit different platforms such as social media, websites, and presentations. - Excel Management: On the other hand, I also require assistance in organizing and managing data on Excel. You should have a good grasp of Excel functions and be able to maintain and update spreadsheets effectively. Ideal skills: - Proficient in video editing software - Experience in creating marketing, tutorial, and event videos - Skilled in managing data on Exc...
I need a simple PowerShell s...SharePoint Online site. This script will help me get the DocumentID (DocIDRedir) for each folder in a specified document library and then generate a CSV file with the name of the folder and its respective DocumentID. - When a folder lacks a DocumentID, the script should still output the folder name with a placeholder text specified. - The script should also incorporate information about subfolders within each primary folder. Ideal Skills: - Extensive experience in PowerShell scripting is a must. - Proficiency in working with SharePoint Online. - Prior experience with SharePoint DocumentIDs, particularly DocIDRedir. - Familiarity with creating CSV files using PowerShell. In case it is not possible via PowerShell, A Microsoft Graph equivalent ...
...entering high complexity data into Excel. The data is scientific research data and involves working with an extensive database. Key Requirements: - High level of attention to detail is crucial, as inaccurate data entry could have significant implications. - Familiarity with Excel and proficiency in data entry. - The data involves scientific research data, so any background in related fields would be beneficial. Tasks: - Entering the data accurately and efficiently. - Applying conditional data validation as required (e.g., specific formats or criteria for entries). - Ensuring the database is updated and maintained accurately. Ideal Skills and Experience: - Proven experience in data entry, ideally with high complexity data. - Strong understanding of Excel, particul...
I'm looking for an expert to scrape data from a website. I will provide the list of data (approx. 16K entries) that will be entered into the search bar and I need 2 fields extracted from each search into an excel sheet. This will be a one-off scrape of the website.
I require a freelancer skilled in data entry. Unfortunately, I was unable to determine the specific type of data entry needed, total entries required, and the format of the data. However, I am seeking a dependable professional who can adapt to different tasks. Ideal skills include: - Strong atte...freelancer skilled in data entry. Unfortunately, I was unable to determine the specific type of data entry needed, total entries required, and the format of the data. However, I am seeking a dependable professional who can adapt to different tasks. Ideal skills include: - Strong attention to detail - Data categorization - Data verification - Data conversion The applicant should be proficient in Excel, CSV, and PDF. This role is likely to involve handling various types of data, so ve...
...looking for a detail-oriented individual to assist with a data entry project. The task involves entering a variety of data types including numeric, text, and alphanumeric, into an Excel file. Key Details: - You will be working with a spreadsheet that has more than 10 columns. - I require the data to be formatted in a specific way: - Color coding: Certain cells should be filled with specific colors. - Conditional formatting: Cells should be formatted based on specific criteria. - Data validation rules: Certain cells should only accept specific types of data. Skills required: - Proficiency in Excel, including experience with conditional formatting, data validation, and color coding. - Strong attention to detail to ensure accurate data entry. - Efficient and r...
As part of my business operations, I need a robust and all-inclusive Excel-based Point of Sale (POS) and Inventory system. KEY FEATURES: - **Sales Tracking**: The system should track all sales, revealing important stats that can aid decision-making. - **Inventory Management**: Stock should sync automatically with sales from POS, maintaining an accurate record of available goods. - **Customer Database**: Important fields such as Contact Information and Purchase History should be part of this system. Important tax-related fields like the tax fee and tax ID number should also be included. IDEAL SKILLS: Freelancers with a strong background in Excel and inventory management systems are preferred. Experience in integrating POS systems and data entry automation is also desirable....
As part of my business operations, I need a robust and all-inclusive Excel-based Point of Sale (POS) and Inventory system. KEY FEATURES: - **Sales Tracking**: The system should track all sales, revealing important stats that can aid decision-making. - **Inventory Management**: Stock should sync automatically with sales from POS, maintaining an accurate record of available goods. - **Customer Database**: Important fields such as Contact Information and Purchase History should be part of this system. Important tax-related fields like the tax fee and tax ID number should also be included. IDEAL SKILLS: Freelancers with a strong background in Excel and inventory management systems are preferred. Experience in integrating POS systems and data entry automation is also desirable....
I'm seeking a proficient Excel expert who can help me create a complex formula for my Excel sheet. The formula will involve an IF statement assessing multiple values and conditions. its one simple formula Key Details: - The formula should be able to evaluate whether a given value is: - Greater than a certain threshold, - Less than a certain threshold, or - Equal to a specific value. - Each of these conditions should trigger a different calculation (to be defined). You should be familiar with creating complex formulas and IF statements in Excel. Your attention to detail and understanding of data manipulation will be crucial in ensuring the formula works accurately. Additionally, your proactive problem-solving skills will be highly valued as you help me d...
I have a large file from my old website, saved in an unknown format (likely HTML, CSV, or XML). Key Points: - The file is from my old website, saved in an unknown format. - I have access to the old website's database or server files. - The main goal is to retrieve the articles and media from the old website to publish them on a new website. - The exact format of the file is unknown. It will be a TAR file and it is rather large file (5.49 gb) Ideal Skills and Experience: - Proficient in web development and file parsing. - Experienced in handling legacy website data. - Strong problem-solving skills for dealing with unknown file formats. - Ability to extract, organize, and migrate content effectively. This project requires someone who can navigate legacy systems and ext...
I need a professional who can quickly and accurately input less than 100 rows of data into an Excel file. You'll be provided with all the necessary data, so there's no need for additional sourcing. Ideal Skills and Experience: - Proficiency in Excel - Fast and accurate data entry skills - Attention to detail to ensure correctness - Experience in working with data sets This is a straightforward project that needs to be completed quickly, so I'm looking for someone efficient and reliable. If the data entry is done well, there is potential for more work in the future.
...40 hours a week You are working too hard!! Example If an employee worked less than 4 hours on Thursday, the message “Insufficient hours worked on Thursday” will be output to the screen. c) Your program should then write each employee record to file and include the following information: • Week Number • Employee ID • Employee Name • Hours worked for each day A sample entry in your text file (or .csv file) might be: Week 2, 123, Vicki Brainsworth, 3,6,8,12,9 Week 2, 345, Joey Genius, 8,12,6,11,7 a list), Data Structure 2. This information will be used later to produce the Employee Weekly Report on the screen after you have entered the work pattern for all employees. For example: Data Structure 2 – This stores the total weekly hours worked for ...
I'm seeking a skilled developer to create a user-friendly macro calculator that's accessible on the web. This tool will help individuals in calculating their daily calorie needs based on their fitness objectives, whether it's weight loss or muscle gain. Key Features: - A simplistic yet engaging web interface that allows users to easily input their details - Capability to calculate an individual's daily caloric needs based on their goals - A results page that provides users with a clear breakdown of their macronutrient requirements The calculator will not require user accounts for tracking progress. Instead, users will have the opportunity to download their results after entering in the details for lead generation. This project is intended to generate leads for ...
In urgent need of an experienced freelancer who can proficiently deal with sitemap and search console issues. The problems I'm facing are manifold: - Sitemap errors - No index errors - Redirect errors Further, my sitemap seems to have several issues like missing pages, incorrect URLs, and XML format problems. I am hopeful to have these issues resolved as soon as possible. Ideal candidates should have extensive experience in error fixing, handling sitemaps, and search consoles. Knowledge in XML format will be an added advantage. It's a critical and urgent task, so please consider before bidding.
I need an Excel expert to help me generate all possible combinations of 12 distinct objects, amounting to 2048 total objects. This will involve the use of Pivot Tables, Macros, and Complex Formulas. Key Requirements: - Proficiency in Excel: You should be highly skilled and experienced in using Excel and its various functions. - Experience with Pivot Tables: You must know how to create and manipulate Pivot Tables to organize the data effectively. - Macro Creation: You will be required to write macros to automate certain processes and tasks. - Strong Command of Complex Formulas: You should be comfortable working with complex formulas to handle the extensive data manipulation required. The end result will be a PDF file containing all possible combinations, deriv...
I'm in need of a skilled PHP developer with experience in PrestaShop 1.6 to add new features to my eCommerce website. Your role will involve: - Implementing new features as dictated by the project roadmap, with one activity being importing orders from a CSV file - Possessing a thorough understanding of Prestashop 1.6 is vital, along with a sound knowledge of PHP development - Demonstrating previous experience with similar projects would give you an advantage - Being proactive and communicative, with the ability to work autonomously and efficiently Please include links or details of previous eCommerce websites and similar projects you've worked on in your proposal.
...an expert on building website with prestashop and deeply know SEO. 1. Installing caching system as below and configure them to get my website speed faster. Memcached via PHP::Memcache Memcached via PHP::Memcached They can be found at advanced parameters/performance/caching 2. Develop a pricing module to set the retail price. There is a installed module to import the product xml to my prestashop store. From those xml, there are two prices, cost price and retail price. The installed module has its own price rule but I want a individual module to override the pricing part of that module. The main requirement should be like this. • A friendly UI to set variables and fetch and list all brands with checkbox • The price will be calculated on below basis. a. a referenc...
I'm in need of an administrative assistant who is proficient in Microsoft Excel for data entry and updating tasks. Specifically, this role entails managing my product inventory. Your primary responsibilities would involve: - Entering and updating inventory data on a regular basis - Organizing and ensuring the accuracy of each entry - Handling large data sets in Microsoft Excel - Following-up to make sure if the items in the inventory is still available It would be beneficial if you're detail-oriented and have prior experience in this kind of work. Don't hesitate if you have questions. Looking forward to your bids.
I'm in need of an Excel expert to assist in creating advanced statistical or financial functions. Your job will be to help me with these complex Excel tasks and generate charts or graphs as the final output. Key Requirements: - Deep understanding of Advanced statistical or financial functions in Excel. - Ability to generate visual representations through charts or graphs. Your role would entail: - Collaborating with me to understand the data and the desired outcomes. - Leveraging your expertise to implement the appropriate statistical or financial functions within Excel. - Presenting the results in a visually compelling manner through the creation of charts or graphs. Please share your relevant experience and any sample work you've done in the pa...
I have a requirement for someone well versed in Excel formulas and calculations, specifically with respect to tracking approaching dates. The main objective is to monitor upcoming deadlines. Ideal candidates should have: - Proficiency in Excel calculations and conditional formatting - Expertise in implementing algorithms to track deadlines - Strong attention to detail - Previous experience in project tracking or similar Your role would involve setting up the necessary formulas and conditional formatting to efficiently track these dates. Understanding the importance and urgency of deadlines, your input would greatly assist in managing our tasks better.
I'm experiencing issues with an Excel file that shows as 'We found a problem with some content...' when trying to open it. The file is 99.7 MB, which may be the issue. File is mainly contact details, text and photos. I've tried Excel's 'Open and Repair' tools with no success. I am aiming to work with an Excel expert who can recover the data without loss, if possible. The freelancer should have: - Intensive experience with Excel - A deep understanding of Excel file structures and experience in fixing corrupted Excel files - Familiarity with various recovery methods beyond just 'Open and Repair' I am looking forward to saving my data with your expertise. Let's discuss a potential solution ASAP. Please ...
I'm looking for an Excel expert to repair my medium-sized spreadsheet which is currently corrupted and crashes upon trying to open. Key tasks include: - Diagnosing why the file is crashing upon opening - Recovering both crucial data and restoring the original structure The success of this project is crucial as there is vital information that needs to be salvaged from the corrupted Excel file. Ideal freelancer should have: - Extensive experience working with large Excel datasets - Proven ability to recover corrupted files - Strong attention to detail to ensure all data and structure is accurately restored