Excel vba sql updateроботи

Обязательные знания: Python, SQLAclhemy, PostgresSQL, Aiogram, FastApi, HTML, CSS Особенно важны: Aiogram, FastApi, Python, SQL Краткий список работ: 1. Добавление проверки/валидации сдачи отчетов 2. Интеграция Telegram бота с фуд-треккером FatSecret 3. Проверка на оплату 4. Изменение общего визуала сайта и информации, которая отображается 5. Добавить дату добавления админа 6. Трекинг действий куратора 7. Добавить закреп юзера за определенным куратором Подробнее при личном контакте

...идей: Возможность внедрения новых стратегий на демо-счете. Ожидаемый результат: Бот должен быть полностью автоматизирован, учитывать динамические параметры (риск, тейк-профит, стоп-лосс), работать только на бирже Bybit и обеспечивать максимальную прибыльность при соблюдении разумных рисков. Вот основы для написания кода: import ccxt import pandas as pd import numpy as np from telegram import Update, Bot from import ApplicationBuilder, CommandHandler, ContextTypes from sklearn.linear_model import LinearRegression import time import logging import asyncio import talib # Логирование (level=, format="%(asctime)s - %(levelname)s - %(message)s") logger = (__name__) # Настройки API и токенов API_KEY = 'YOUR_BYBIT_API_KEY' SECRET_KEY

Hi, we simply need to integrate AppsFlyer now and connect appsflyer actions to webview url, Also we need to deploy this app into our apple-dev-account as an update. Our budget for this particular task is between $50 and $100 . In the future if you are interested we may ask you to create whole app from scratch with $200 budget for each application. People who make such applications usually make 1-3 apps per day.

Необхідно розробити макрос з перетворенням 1 файлу excel "для обробки" у кілька файлів-шаблонів теж у excel. Суть заповнення всіх полів у цих шаблонах з даних файлу excel "для обробки" згідно з алгоритмом описаним у технічному завданні.

Доброго дня! Шукаю фрілансера, хто міг би допомогти час від часу писати коди SQL запитів для SAP B1.

...Супроводження процесу впровадження. Вимоги: • Досвід роботи – від 2-х років. • C++11, STL, GCC/CLang, GDB/LLDB, GNU Make, CMake, Bash. • Знання STL — контейнерів та алгоритмів. • Знання файлового вводу/виводу у стандарті POSIX. • Знання POSIX Threads —нитки, м’ютекси, умовні змінні. • Вміння користуватися системою контроля версій Git. • Вміння користуватися командним рядком Linux. • Реляциійні БД, SQL. • Основи функціонування комп’ютерних мереж, протоколи TCP и HTTP. Знання HTTP/1.1. Знанння архитектури REST. • Багатопоточність. Буде плюсом: • C++14, 17, 20. • Qt. • Boost. • Засоби статичного і и динамічного анализа коду (cppcheck, clang-tidy, clazy, valgrind, gprof, &helli...

... Шукає Unity розробника для створення багатокористувацької браузерної 3D гри, Unity за допомогою WebGL. Обов'язкові навички: Вміння працювати в Unity і знання мови C#. Плюсом буде додаткові знання: JS, HTML 5. І back end розробника для написання серверної частини на ASP.NET Core. Обов'язкові навички: ASP.NET Core Entity framework core SQL С кидайте свої резьуме на: business@ або проджект менеджеру проекту: viktorstor@ KICKOOS GAMES - це молода outsourc GameDev компанія, що з недавна почала розробляти і внутрішні проекти. Друзі компанія зараз розширюється і влітку планує відкрити офіс в Україні, тому долучайтеся до нашої спільноти у телеграмі, де публікуются відкриті вакансії на різні позиції.

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

Необхідно розробити jquery плагін, що буде дозволяти дінамічну зміну компонентів продукту та їх опис з п...) або розробка нового. Обговорюється. У разі швидкого успішного виконання можлива постіна співпраця на довготривалому проекті. 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.

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

Потрібно зробити легкі лабораторні роботи, терміново! Файли прикріпив, за потребою скину методичку.

Transfer news websites advertising texts...

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

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

Я маю довгострокову роботу, яка пов'язана з нашим попереднім проектом 'Change Framework CMS from Shopify to Prestashop - PHP, HTML, CMS, SQL'

I'm looking for a freelancer who can meticulously extract a large mixed data (numerical and text) table from a statistical website and transfer it into Excel without missing any details. The ideal candidate should ensure that the data is formatted in Excel in the exact same way as it appears on the website. Skills and Experience: - Proficient in data extraction and Excel - Attention to detail to ensure no information is missed - Ability to format data in Excel as per the client's request

...things.  I am looking for someone who can understand the intricacies of data processing and can help ease the burden of manual tasks. The goal is to streamline our operations and enhance productivity. -- Basically, we have a data processing project which is going to be presented into our new website. We need a backend Python Developer whom can process data in our Google sheet then be dumped into SQL, eventually going to be presented into our new website. Therefore, the Python developer needs to be familiar with Google sheet API, Django framework API, and scrapping for our data processing. Data synchronization should occur in real-time. Our budget is $3/hour for maintaining the codes and website $5/fix rate for replicating or making a new code, but for a specific code if...

...Data Scientists - **Overview**: As a fresher data scientist, you’ll be expected to contribute effectively to data-driven decision-making. This presentation will outline the key expectations that employers have when hiring fresh talent in data science. --- #### **Slide 2: Core Skills Expected from Freshers** - **Technical Skills**: - **Programming Languages**: Proficiency in Python, R, SQL. - **Data Analysis**: Ability to manipulate and clean data (using Pandas, NumPy, etc.). - **Statistical Analysis**: Understanding of core statistical concepts and techniques (e.g., hypothesis testing, distributions, A/B testing). - **Machine Learning**: Basic understanding of common algorithms (linear regression, decision trees, clustering, etc.). - **Data Visualiz...

I need a skilled Python programmer who can help in extracting table data from PDFs and converting it into an Excel file. The tables in the PDFs have varying structures, so your ability to handle different table layouts is essential. Key requirements: - Extract tables from multiple PDFs - Convert the data into a well-structured Excel file with 4 different formats across 2 sheets - Ensure the data is accurately represented as mixed data (both numeric and text) Ideal Skills: - Proficiency in Python, with experience in data manipulation using Pandas DataFrame - Excellent attention to detail for accurate data extraction and conversion - Prior experience in handling PDFs and Excel files With your expertise, I hope to streamline my data processing task and make it more ef...

I'm seeking a seasoned Business Analyst with 3-6 years of experience, particularly in the retail sector. This remote, 3-month project entails developing and implementing brand marketing strategies to boost our brand visibility. Key Responsibilitie...case studies - Monitor and assess the impact of marketing initiatives - Analyze competitors' operations and identify their strengths and weaknesses. Desired Skills: - Strong analytical capabilities - Excellent marketing knowledge - Superb communication skills - A touch of sales experience. Ideal candidates will possess a BCA, MCA, B.E. or a relevant degree. Experience with tools like Microsoft Excel, Google Analytics, and Salesforce is a plus. Though not mandatory, a primary objective of enhancing brand recognition would be ...

I've encountered some issues with my Hummingbot's Spot - Perpetual Arbitrage script and I need a developer with Hummingbot experience to help me modify it. Issues: - There's an imbalance between the Spot Fee which affects the Order amount. - Errors on the Perpetual Order that has already closed but Hummingbot doesn’t update its status. This prevents it from opening the next arbitrage. Requirements: - Adjust the Spot Fee calculations for variable fees. - When a Perpetual order closes and the status is not updated, it should trigger an alert. The ideal freelancer should have: - Strong experience with Hummingbot. - Familiarity with HyperLiquid and Gate.io. - Ability to modify scripts and set up alerts. Please reach out if you can assist with these modifications...

...products are visible in Catalog > Products in the Magento Admin Panel. The catalog_category_product_index and related indexing tables are not being updated properly. There might be database integrity issues preventing proper indexing and schema creation. What I Have Tried: Recreating missing tables manually using expected structures and constraints. Manually populating missing index tables using SQL queries. Running Magento reindexing commands (indexer:reset, indexer:reindex), but they do not resolve the issue. Checking database integrity by verifying related tables (catalog_category_product, catalog_category_entity, catalog_product_entity, catalog_product_entity_int). Reviewing Magento logs (var/log/, var/log/) for errors, but nothing significant was found. Ensuring

I'm seeking a seasoned Windows developer with robust SQL Server expertise to assist in data updates on a Windows server database. Key Responsibilities: - Execute updates on existing records within the SQL Server database. - Ensure data integrity and consistency during the update process. Ideal Skills: - Proficient in Windows development and SQL Server management. - Excellent problem-solving capabilities, particularly in data handling. - Strong attention to detail to maintain data accuracy.

...from the backend. 2) The app will handle user login and account management, with a one-time setup for adding printers. Printers will be pre-installed on the desktop. Users will select from a list of printers to associate with their print category (eg: passport photos -> printer1, page printing -> printer2 etc). 3) The app will facilitate printing of photos and PDFs using a pre-selected printer and update the firebase with the print status. User Roles: The app will primarily cater to standard users, so the design should be intuitive and user-friendly. Authentication: User login will be managed via phone number and OTP Ideal Skills: - Proficiency in C# and desktop application development. - Experience with Firebase integration. - Understanding of print management systems. ...

I'm looking to update my HumHub installation to the latest version. The task will also involve preserving and updating my custom themes and modules. I do have backups of my current installation, so that should simplify the process. Ideal Skills: - Extensive experience with HumHub - Proficiency in handling and updating custom themes and modules - Strong understanding of data backup and restoration processes I need someone who can ensure a seamless transition to the latest version without disrupting the functionality of my custom setups. You need to know Hestia Control Panel. You have root access.

I need assistance in entering mixed data, which is currently stored in digital files, into MS Word. Requirements: - Proficient in MS Word and data entry - Able to work with mixed data (text and numeric) - Experience handling digital files, particularly text files The data is sourced from various digital files including Excel, PDF and text files. Your role would primarily involve transcribing this into MS Word, so attention to detail and accuracy is crucial.

... and any other pages that may be applicable to the site. Functionality Needs: Custom theme development/customization Plugin integration (SEO, security, performance, etc.) SSL certificate implementation for secure browsing Contact forms Social media integration Responsive design for mobile and tablet Speed and performance optimization SEO-friendly structure Content Management: Easy-to-update backend for non-technical users Timeline: 2 months Key Responsibilities: Develop a fully functional WordPress website according to project requirements Customize themes to fit the brand identity Install and configure necessary plugins for enhanced functionality Ensure website responsiveness across all devices Implement SSL certificate for website security Optimize the website...

...front-end frameworks (React, Angular, or Vue). Understanding of responsive design and UI/UX principles. Back-End Development: Expertise in Node.js and frameworks like or NestJS. Experience with real-time communication using or similar technologies. Familiarity with RESTful APIs and WebSockets. Database Management: Proficiency in working with NoSQL databases like MongoDB or SQL databases like PostgreSQL. Experience with database design, indexing, and query optimization. Other Key Skills: Knowledge of authentication mechanisms (OAuth2, JWT, etc.). Experience with deployment tools like Docker, AWS, or Heroku. Version control with Git and collaboration tools like GitHub/GitLab. Preferred Qualifications: Prior experience building chat or real-time applications. Familiarity

Hi there, I'd like to propose 1 more month's work, with the following tasks to be completed by 20 Feb: 1) 5-6x more posts across both FB/Insta (same flavour, informative, graphics/video and I provide some bullet points for you in terms of info) 2) Update my Connect Films LinkedIn profile page and any advice there on improvements/marketing for this audience. 3) Create 2x paid Google Ads (that I pay for) My goal is for 400 followers on FB/Insta ideally :) And to start to get ROI, ie. new clients.

I need a freelancer to help with data scraping and organizing the information into an Excel file. The data source will be various databases. - Scope of Work: - Scraping email addresses and names/contact information from databases. - Organizing the data into an Excel file with separate columns for each data type. Ideal Skills: - Proficient in data scraping techniques. - Excel expertise, specifically in organizing and formatting data into separate columns. - Attention to detail to ensure data accuracy. - Previous experience with data scraping from databases is a plus.

I need a multi-purpose chassis designed for a heavy-duty construction vehicle primarily intended for excavation in mountainous terrains. The vehicle will face challenging conditions, so the chassis must excel in durability and flexibility. Key Requirements: - Design a chassis that can withstand tough, mountainous terrains while being able to adapt to different conditions and tasks. - The design should not prioritize being lightweight, but rather focus on durability and flexibility. - Previous experience in designing vehicle chassis, particularly for construction or heavy-duty vehicles, is highly desirable. Ideal Skills: - Mechanical Engineering - CAD Design - Experience with heavy-duty vehicle design - Knowledge of materials for durability - Creativity for flexible design

Project Title: Data Entry and Administrative Support Needed Project Description: Update a large database with accuracy and efficiency. Use Google Sheets and Excel for data entry and management. Ensure all data entries are accurate and error-free. Submit daily progress reports. Required Skills: Proven experience in data entry. Proficiency in Google Sheets and Microsoft Excel. Ability to complete tasks within deadlines and maintain accuracy. --- If your project is related to Sales & Marketing or Translation & Languages, you can modify it accordingly. Example: Project Title: Content Writing for Marketing Campaigns Project Description: Create engaging and customer-attractive content for a new product launch. Write short yet impactful copy for soc...

I am an eBay seller seeking assistance to enhance my Boost Space automation with Google Sheets. The primary goal is to streamline my shipping purchasing and automate my accounting updates while ensuring my data is properly formatted. Key Responsibilities: - Integrate Boost Space with Integromat and Google Sheets - Connect various shipping platforms, primarily eBay and possibly Pirate Ship - Update my spreadsheets with order numbers and formatting dates to a U.S. style date format Ideal Skills: - Proficient in Boost Space and eBay shipping processes - Extensive experience with Integromat and Google Sheets - Strong understanding of eBay and Pirate Ship integration - Excellent attention to detail for data formatting and accuracy Your expertise will help me significantly reduce manu...

...assigned team, status. Edit project details inline. Milestones tracking and deadline management. 3. Task Management Create, assign, and update tasks. Task views: List View Kanban Board Gantt Chart Task filters (by status, priority, due date). Subtasks and recurring tasks support. 4. Risk and Budget Management Risk matrix (impact vs. probability). Mitigation plans and conditional formatting for high-risk items. Budget tracking: Total budget, expenses, and remaining funds. Visualizations for expenses and trends (charts). 5. Reporting and Analytics Real-time charts for: Task completion rates. Project delays. Resource utilization. Export options for reports (PDF, Excel, Word). Embedded Power BI dashboards. 6. Automation and Notifications Email and Teams notifications for t...

Apdate card designs with agreed CARDLAB logo, adjust colour palette, make change to the animation in line with these requests including some changes to the back of the card in the animation.

I need assistance with data entry. The data is mixed (text and numbers) and is currently in Excel/CSV format. The primary purpose of this data entry task is to populate a database. Ideal candidate should be proficient with: - Excel/CSV - Data entry - Attention to detail Experience with database management and data handling is a plus.

I'm seeking a designer to give our website a fresh, bold and vibrant visual design. The main objective of the redesign is to update the visual style of the site, making it more engaging and exciting for our users. Key Pages for Redesign: - Founder's Page - About Us - Contact - E-commerce Section - Revision Page Ideal Candidate: - Proficient in modern web design principles. - Experience with creating bold and vibrant visual styles. - Familiarity with e-commerce website design. - Able to deliver a comprehensive redesign of multiple website pages.

I’m looking to automate sending birthday promotion messages to a list of contacts via WhatsApp. Here’s what I need: What I Have: • An Excel sheet with nearly 2,000 contacts. o Each entry has:  Name  Contact number (with country code)  Birthday date • I’ve also got 2 promotional images and a message I’d like to send. What I Need: 1. Send WhatsApp Messages (direct from excel) two images I provide. 2. Reusable for Future Months o For upcoming months, I want to just update the Excel sheet with new names, numbers, and birthdays, and then click something to send messages to the new list. 3. Extras I’d Like: o Skip duplicate numbers so no one gets spammed. o Log which messages were sent successfully and which weren’t...

...to place orders for prescription medications online. - *Optional Customer Accounts: * Allowing customers to create accounts for easy order tracking and faster checkout on future visits. - *Essential Legal Pages: * Inclusion of necessary legal pages such as Privacy Policy, Terms and Conditions, and Refund Policy to comply with regulations and ensure transparency. Additional Features: - *New Bulk Update for Availability, Stock, Prices, and Menu Items: * Facilitating a streamlined process for bulk updates, enabling quick changes to product availability, stock levels, prices, and other essential information across the website. - *Fully Integrated POS System: * Ensuring the website is fully integrated with your existing Point of Sale (POS) system, allowing for real-time synchronizati...

I need an Android mobile application that synchronizes with my C# desktop application. The sync should primarily involve user data from a SQL Server database. The mobile app's design should be modern and user-friendly. Key Requirements: - Synchronization of user data from C# desktop application to Android mobile app. - Expertise in C# and Android development is essential. - Experience with SQL Server and data synchronization is a must. - Strong skills in modern UI/UX design principles. Please note, the mobile app should showcase some level of design sophistication while adhering to a modern aesthetic.

Bullet Points: Copywriting Skills: I have extensive experience in writing articles, product descriptions, website copy, and other forms of content. SEO Copywriting: I am proficient in creating SEO-friendly content that helps improve search engine rankings. Engaging and Persuasive Writing: I excel in writing compelling content that connects with readers and enhances brand engagement. Client Communication: I understand client needs and can craft clear, persuasive copy tailored to their target audience. Portfolio Examples: I have a portfolio showcasing my work, including blog posts, website copy, and product descriptions. Full Description: I am a skilled copywriter with a passion for creating content that not only informs but also engages and motivates readers. With a strong background...

...between different screenshots. OCR Data Extraction and Excel Conversion: Use OCR tools (like Tesseract) to extract text from the cropped images. Convert the extracted data into a structured format, and save it into an Excel file, with each piece of data placed into corresponding columns. Requirements: Proficiency in Python (Pillow, OpenCV, pytesseract). Experience with OCR for text extraction from images. Ability to work with Excel files using Python (openpyxl, pandas). Experience with automating image processing tasks. Strong attention to detail and problem-solving skills. Project Details: This is a freelance task-focused project with flexible variations in screenshots. You’ll need to provide code for both cropping and conversion to Excel. So I can ...

I run a small farm, luxury holiday let and café and need a skilled graphic designer to update my existing logo. Key Details: - The new design should maintain a similar colour and theme to the old one, which uses a turquoise green colour and stylised seedhead image. I have a photo of a seedhead from my meadow I would like to base the new logo on so illustration skills would be useful. - The logo should reflect our luxury retreat in the wilderness vibes. - I prefer a modern but timeless style for the updated logo, rather than rustic or minimalist. - The logo will be used for both digital and print versions, so colour and black and white versions are required. Existing logo and photo attached. Ideal skills and experience: - Proven experience in logo design, pref...

As a client, I am looking for a detailed SQL database of all Indian medicines and OTC products. I am also attaching a sample file it should contains all the fields from sample files. This database should include: - Brand name, generic name, and price - Ingredients and usage instructions - Side effects and contraindications - An image of the product The database should also be categorized or classified by: - Type of medicine - Manufacturer - Treatment category Ideal candidates for this project should have experience in data collection and database management, particularly in the pharmaceutical or healthcare sectors. Knowledge of SQL and an understanding of medicine classification systems will be highly beneficial.

Update for android dating app with php server side

We need an experienced data researcher with the following skills: 1) Experience in Internet Research 2) Good English skills 3) Knowledge of google sheets & excel 4) Attention to detail This is a long term project.

...with my website's theme. The specific requirements include: - Implementing a COD option at the checkout - Customizing the COD interface to match my website's style - Incorporating features like order confirmation via email and a verification step before order completion - Conducting thorough testing and troubleshooting to guarantee a seamless user experience - Providing future maintenance and update guidance The ideal candidate should have: - Proven experience with Wix development - A solid background in payment gateway customization - Excellent problem-solving and communication skills - Previous projects involving COD implementation (a bonus!) To apply, please send me: - A brief introduction about your Wix experience - Links to relevant previous projects - Your prop...

Excel Data Cleaning: Removing duplicates, errors, and inconsistencies for accurate analysis. Excel Data Formatting: Organizing data into a clear and professional layout. Excel Dashboards: Creating interactive and visually appealing dashboards for data visualization. Excel VBA: Automating repetitive tasks and creating custom macros to save time. Pivot Tables and Charts: Summarizing and visualizing large datasets effectively. Data Analysis: Performing advanced calculations and trend analysis for insights. Conditional Formatting: Highlighting important data with rules and color coding. Formulas and Functions: Using advanced formulas (e.g., VLOOKUP, INDEX-MATCH) for dynamic calculations. Data Validation: Ensuring data accuracy with dropdown lists and validati...

...control functions can be added. These ECU software updates may need to be performed at specific locations. (2. technology search) The technology I would like to find is a technology that, when updating the software of ECUs installed in a vehicle, notifies the user of the vehicle of the update request at a specified location if the update is predetermined update task. Specific examples are given below, but the survey should be conducted broadly and not limited to these examples. Examples of predetermined update tasks include software updates with large amounts of data, when a direct explanation to the user is required, or when parts need to be replaced. Examples of predetermined locations include vehicle dealerships, maintenance shops, places where Wi-Fi is a...

...seeking an experienced Power BI developer to create a comprehensive report for our sales and marketing data. The ideal candidate should have a strong background in data visualization and analysis, with a proven track record of delivering high-quality Power BI reports. **Project Requirements:** 1. **Data Integration:** - Integrate sales and marketing data from various sources (e.g., CRM, ERP, Excel files). - Ensure data accuracy and consistency. 2. **Report Design:** - Create visually appealing and interactive dashboards. - Include key metrics such as sales performance, marketing campaign effectiveness, customer segmentation, and ROI analysis. - Design reports that are easy to navigate and understand. 3. **Data Analysis:** - Perform in-depth analysis to identi...