Excel vba sql update sampleроботи

Обязательные знания: 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...

...уровень, способность на слух распознать и правильно записать текст (можно использовать text to speech софт, но нужно быть в состоянии вычитать). Required skills: Adobe Premiere Pro user (basic level+) Japanese language - Upper-Intermediate to Advanced level is a must Мы предоставим готовый premiere pro проэкт и инструкцию (на японском) в качестве примера. We will provide a manual in Japanese and the sample project file for reference. Видео будут предоставляться на постоянной основе. Оплата по инвойсу в конце следующего месяца. Например - с 1 по 31 августа было отредактировано 10 видео. Оплата за все 10 будет в конце сентября. Videos will be provided on a regular basis. The payment will be done at the end of the next month (if you finished 10 videos during August, you'll g...

... Шукає 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'

...Failure to perform Misinterpretation or ambiguity in agreements General Contract Disputes Family Law: Divorce and separation Child custody and visitation Child and spousal support Property division and prenuptial agreements Criminal Law: DUI/DWI Drug-related offenses Misdemeanors and felonies Assault and battery Theft and property crimes Blog Area for Legal Articles and Insights: Dynamic, easy-to-update blog for sharing content that drives organic traffic. SEO-friendly layout to rank blog posts on relevant local and legal topics. About Us/Attorney Profile Page: Detailed bios, professional experience, and credentials. Option for potential clients to connect through embedded contact forms. Contact Page: Includes firm’s address, phone, email, and integrated Google Maps...

I'm looking for a web expert proficient in WordPress and Elementor Pro, to assist with updating my current website. The site needs to be transformed into a bilingual platform, catering to the tour operator industry. Key Project Requirements: - Import a new WordPress version and utilize Elementor Pro to refresh my site. - Modify the website into a bilingual (two languages) setup. - Construct a detailed tour page, incorporating a photo gallery and a customer reviews section. - Apply pre-built templates from Elementor Pro, ensuring a seamless and professional design. - Migrate existing content for the bilingual setup. Ideal Skills and Experience: - In-depth knowledge and experience working with WordPress and Elementor Pro. - Previous work with travel companies, particularly tour operat...

I'm looking for a freelancer to create an Excel workbook that consolidates data from 7 source sheets into a main sheet. The solution should dynamically update in real-time as the data in the source sheets change. PLEASE SEE THE ATTACHED PDF FOR A BETTER UNDERSTANDING. Key requirements: - Use either Excel formulas or Power Query. VBA and Macros are not allowed. - Summarize totals for each unique combination of columns A-D from the source sheets. Note : data both sheets could go up to 1000 + rows. Deliverables: - A fully functional Excel file where the main sheet updates in real-time. - Clear documentation or a short instructional guide explaining how the solution works. Ideal skills and experience: - Strong Excel skills and expertise in ...

Enhance an Excel file about real estate investment. I'll highlight entry values in green, correct and insert formulas when needed.

...performances in upcoming cricket matches. - Points calculation and tracking: Points should be awarded based on the accuracy of predictions and tracked over time. - Leaderboard display: A leaderboard should be displayed to show the top predictors. Prediction Submission: Users will submit their predictions via a form-based input system, which should be easy to navigate and user-friendly. Points Update Frequency: Points should be updated daily to keep the game dynamic and engaging for users. Ideal Skills and Experience: The ideal candidate for this project should have substantial experience in developing Telegram bots, preferably with a background in gaming or betting systems. They should be proficient in creating user-friendly interfaces and have a solid understanding of point c...

I'm seeking a proficient WooCommerce developer to help with customizing my existing store. There's a need for both design/layout changes and functionality enhancements. Specific Tasks: - Redesign the homepage: I'm looking for a fresh, modern look to attract and retain customers. - Change product page layouts: Product pages should be user-friendly and visually appealing. - Update the navigation/menu: The site should be easy to navigate. - Include some new elements: These will be discussed in detail upon selection. Ideal Skills and Experience: - Extensive experience with WooCommerce. - Strong background in web design and UX/UI. - Proficient in PHP, WordPress and HTML. - Excellent problem-solving skills. - Good communication skills for discussing new elements.

I'm looking for a custom Excel template to organize my extensive sports memorabilia collection. The collection includes various types of items, such as: - Autographed items - Trading cards - Game-used items - Pop figures - Jerseys - Balls - Movie memorabilia The template should be user-friendly, allowing for easy input and tracking of each item. Ideal candidates should have experience in creating digital templates, preferably for memorabilia or similar collections. Skills needed: - Advanced proficiency in spreadsheet software - Experience in template creation - Knowledge of sports memorabilia is a plus. Please submit your proposal if you have the required skills and experience. I am not looking to create a logo or websitr

I'm in need of an affordable service capable of sending daily SMS newsletters to my clients with customer updates. Specifics: - The primary goal of this SMS marketing campaign is to keep my customers informed. - The content of these updates will primarily consist of newsletters. Ideal Skills: - Experience with SMS marketing is preferred. - Ability to provide c...service capable of sending daily SMS newsletters to my clients with customer updates. Specifics: - The primary goal of this SMS marketing campaign is to keep my customers informed. - The content of these updates will primarily consist of newsletters. Ideal Skills: - Experience with SMS marketing is preferred. - Ability to provide cost-effective solutions is a must. - Prior work with customer update services will b...

I'm encountering a problem with my website where posts are not appearing. This issue started after a recent update. I'm seeking a skilled Laravel developer who can diagnose and fix this problem. No recent changes have been made to the content or structure of the site, so the issue should be isolated to the last update.

...base de datos. - Definir el stack tecnológico ### **Requisitos:** - Experiencia 7+años en diseño y desarrollo de bases de datos, preferentemente para e-commerce o marketplaces. - debe demostrar su experiencia - Sólidos conocimientos en bases de datos relacionales (SQL) y no relacionales (NoSQL). - Competencia en herramientas de modelado de datos como Lucidchart, ER/Studio o similares. - Experiencia con sistemas de gestión de bases de datos (DBMS) como MySQL, PostgreSQL, MongoDB. - Familiaridad con entornos de desarrollo como SQL Developer, DBeaver, etc. - Alta capacidad para la resolución de problemas y atención al detalle. - Excelente comunicación y habilidades interpersonales. - Conocimiento del mercado automotriz...

I need an Excel dashboard created from our data that we currently track in Excel across multiple locations. The dashboard should display a variety of key metrics including: - Sales data - YOY Data - Membership Sales - Membership Conversions - Labor as a percentage of revenue - Birthday party revenue and YOY data for same week LY - Concessions Revenue and YOY data for same week LY The ideal freelancer should have: - Expert proficiency in Excel - Experience in creating dynamic dashboards - Ability to visualize data using bar charts and line graphs - Understanding of sales and revenue tracking The dashboard should be able to visualize data using bar charts and line graphs, as well as dynamic dashboard visuals. The dashboard will need to refresh data on a weekly basis. ...

I'm in need of a detailed Excel sheet for my company, specifically for the Operations department. This sheet should include various registers and time sheets, all interlinked with formulas for seamless data flow. Key Components: - Invoice Register - Expense Register - Salary Register - Employee Time Sheet - Invoice Incoming - Invoice Outgoing - Outgoing Purchase Order - Purchase Order Incoming (Sales Order) - Apex and Opex Register - Asset List - Billing Forecast - Expense Forecast - Hire Employee List and Salary Register - Payroll Master and ESOB Calculator and Register The project also requires the creation of a single dashboard. The main purpose of this dashboard is to track the financial performance of the company. It should prominently display: - Total revenue and exp...

...support unlimited users, each with access to their own set of lamps. Each user should have login credentials (username and password) and be able to manage their designated group of lamps. Upon completion of the software, we expect the source code and all intellectual property rights related to the platform to be transferred to our company. This includes full ownership and the ability to manage and update the software independently in the future. Please provide a detailed proposal that includes: A technical overview of how you would approach the development of this system. Estimated timeline for completion. A cost breakdown for the development of the software. Information on any similar projects you have completed. Your terms for transferring intellectual property rights. The ...

...4. PCB Design & Prototyping • Design a compact, flexible PCB suitable for smart glasses. • Implement best practices for high-speed signals, RF design, and power integrity. • Generate Gerber files, BOM, and manufacturing documents. 5. Firmware & Communication Framework (Optional, but a plus) • Assist with low-level firmware development for FPGA, Bluetooth, and sensor integration. • Provide sample code for Bluetooth communication and camera interfacing. Deliverables: 1. Updated Circuit Schematic (with necessary modifications). 2. Optimized PCB Design (Altium/KiCad/Eagle, including Gerber files). 3. Component List & BOM (Bill of Materials). 4. Prototyping Support (guidance for testing and debugging). 5. (Optional) Basic Firmware for C...

...docker container Requirements: - The resulting tables should be exactly the same as when you run the original import script. - The import time should be significantly reduced compared to the import time of the original import script using the same hardware requirements. - It should be easy to run everything: clearly document how to run it How you achieve this is completely up to you (Bash + SQL, pure SQL, Python, …)....

I have an Excel workbook with 7 source sheets and 1 LV (Landing View) sheet. The task is to automatically consolidate data from the 7 sheets into the Main sheet using either Excel formulas or Power Query (VBA and Macros are strictly off-limits). Requirements: - The solution needs to be dynamic, updating the LV sheet in real time as data in the 7 source sheets changes. Deliverables: - A fully functional Excel file where the LV sheet updates in real-time based on data from the 7 sheets. - Clear documentation, or a short instructional guide, explaining how the solution works. Ideally, the freelancer will have strong Excel skills, expertise in using Power Query, and a good understanding of data mapping. Experience with creating dynamic Excel solu...

El objetivo principal del Dashboard es monitorear el avance y control de la etapa de preparación de diversas obras públicas, incluyendo el seguimiento de entregables, plazos, presupuesto, riesgos y adquisición de recursos, todo ello en EXCEL. El Dashboard es clave para controlar los avances de múltiples obras, asegurando que el presupuesto no se exceda, que los plazos se respeten y que los recursos (personales y materiales) estén disponibles a tiempo. La toma de decisiones debe ser ágil y basada en datos claros, por lo que los indicadores y las alertas deben estar configurados para resaltar cualquier problema (retrasos, sobrecostos, falta de recursos). Cuento con el alcance y datos claves que deberia tener el dashboard. Contactarme al +*5*1...

Scrape agent's full name, company, mobile number, and suburb from the provided RealCommercial link. Store the data in a structured spreadsheet format. Remove duplicate entries to ensure clean data. Deliver the final CSV or Excel file.

...developer / network packet analyzer to help get my bot program working again. I have the source code of the bot and need to get it to function properly with another bot program and the game. The game is a mainstream RPG game that you will need to download in order to complete the project. I believe there is an issue with bot sending/receiving packets to game server. It was cause by a recent update of the game that made the bot no longer function. This is assumed to be the issue but there may be more to it. So to be successful you will need to analyze game packets compare them to bot packet structure and modify where needed. The ideal candidate will have strong expertise in network packet analysis, C#, experience with DLL development and familiar with reverse engineering game...

I'm seeking a skilled Python developer to create an online script. This script needs to extract readable data from Twine 2 / Sugarcube saved files.... ) Key Requirements: - The script should be able to decode saved games to read data. - The script should check if the given saved game is a valid Twine 2 saved game. - The primary data to be extracted includes basic information, mainly the Title. If the initial project is successful, there's potential for expansion to create an editor for saved games. You will be provided with sample Twine 2 saved files for testing. The extracted data needs to be outputted in plain text. Ideal Skills: - Proficiency in Python - Experience with data extraction and decoding Attached is an example saved game from a Twine 2 + Sugarcube gam...

...directed to a tenant-branded verification page. • The page displays authentication details such as a unique identifier, verification status, and additional metadata. 4. Secure Backend & Database • Multi-tenant database architecture (either shared DB with tenant IDs or separate DBs per tenant). • Secure storage of item records, unique NFC tag data, and verification logs. • Admin access to add, update, and deactivate authentication records. • API/webhook support for potential integrations. 5. Security & Compliance • Encryption & hashing for NFC tag data storage and transmission. • Rate limiting to prevent automated scanning abuse. • Audit logs for admin and user actions. • Secure authentication via JWT or OAuth. 6...

I'm seeking a skilled professional to assist with my existing Wordpress website. The project involves integrating a new appointment system for service bookings with the following features: - Automated reminders - Email and SMS notifications for new appointments In addition to the appointment system, I would like an overall update to the site, enhancing its functionality and user experience. Therefore, the ideal candidate should possess: - Proficiency in Wordpress - Experience with implementing scheduling systems - Knowledge in website updates and enhancements Please ensure to include your previous work related to this project.

...Scientific research labs • Medical and clinical labs • School/educational labs • Governmental labs • Food testing labs • HPLC labs • Cytogenetics labs • Industrial labs Data Requirements: Each laboratory entry must include the following: 1. Laboratory Name 2. Address 3. Telephone Number 4. Email Address (mandatory) 5. Website (if available) Project Deliverables: • A spreadsheet (Excel, Google Sheets, or CSV format) containing at least 1,500 unique laboratory contacts. • Each row should represent one laboratory, with columns for the required data points above. Important Details: • Labs from Mexico or Brazil will NOT be accepted. Please do not include any contacts from those countries. • All data must be acc...

...Tiktok, Temu, Amazon, Shopify, and WooCommerce. I need a freelancer who can assist with the registration of a developer account, as well as provide guidance for the integration of various APIs. Key Responsibilities: - Help register a developer account on my behalf. - Understand and outline the API structure for the integration. - Assist in integrating APIs to read sellers' sales and return info, update shipping status, and sync the warehouse inventory with the sales platforms. Ideal skills for this project include: - Proficiency in API design and integration. - Experience with the aforementioned sales platforms. - Ability to register accounts and understand API authentication methods such as OAuth, API Key, and JWT. Freelancers who can provide a comprehensive understandin...

I need assistance in exporting questions, answers, and explanations from a ChatGPT report into an Excel document. The data consists of 400 items formatted as text paragraphs in the report. Please see example link below: If you open the file above, you will see there are 400 questions organised into: 1) questions 2) correct answer 3) Explanations When you try to ask ChatGPT to export all data into an excel document it doesn't do this properly. It only gives a sample of the questions. I want a freelancer to find a way so that you can instruct ChatGPT to properly export all data so it matches what is produced from before. We have over 100+ documents with each document containing 400+ questions. If you can do it for 1 correctly

...Additional points based on the number of wickets the team or players took. 5. Leaderboard System: The bot should track each user’s points and display a leaderboard. Users can check their current rank and points with the command /leaderboard. The leaderboard should show rankings by: Overall Points. Weekly and Monthly Rankings. 6. Notifications & Updates: After each match, the bot will automatically update the users’ points based on the match results. The leaderboard will be updated as soon as the points are calculated. Additional Features: The bot should be able to fetch match data from an API or a website (for team performance, player stats, runs, wickets). Ensure that the bot can handle multiple users interacting with it at the same time. The bot should be simple...

I'm seeking a skilled freelancer to retype and format an old, scanned, hand-typed Covenants, Conditions, and Restrictions (CC&R) document for a Property Owners Association. Key Tasks: - Accurately retype the entire document into Microsoft Word. - Maintain the original formatting, including structure, headings, and sections. - Incorporate original seals and notary stamps from the s...documents. - Proficiency in Microsoft Word formatting. - Ability to insert and align images (seals and stamps) properly at the exact location from the original document. Deliverables: - A fully formatted Microsoft Word version of the CC&R document that retains the original look while ensuring clean, editable text. When bidding, please provide a timeline for completion and any relevant experience...

I'm looking for a freelancer who can set up an automated process that transfers my inventory details from QuickBooks Desktop to an Excel sheet on a daily basis. Key Requirements: - Data Transfer: The project entails transferring inventory details from QuickBooks to an Excel sheet on a daily basis. - Data Processing: After the data is transferred, I need it to be summarized in the Excel sheet. Ideal Skills: - Proficiency in QuickBooks Desktop - Advanced Excel skills - Experience with data automation Please ensure you have the relevant experience and skills before bidding. I look forward to your proposals.

I'm seeking a proficient accountant with strong financial analysis skills and expertise in Microsoft Excel. Key Responsibilities: - Conduct comprehensive financial analysis - Manage accounts payable and receivable Ideal Skills: - Proficient in Microsoft Excel - Strong financial analysis capabilities - Experienced in managing accounts payable/receivable

...a tailored Excel template to streamline my work checks. Currently, I have to manually copy and paste complicated formulas and use text replace functions to substitute keywords like LESS and PLUS with their mathematical counterparts. For examples sake, I want to put in "(25%LESS1/8LESS1/16 of 7/8) of 1/2 of 1/2 of 8/8" in A1, and have a Cell then automatically output that info. I have used substitute functions, then did evaluate formulas, but doesn't turn out right. Key Responsibilities: - Develop an Excel template that can process long form mathematical expressions and return values automatically, saving me the tedious work. - Ensure the template can handle mixed operations including addition, subtraction, multiplication, and division. Ideal Skills: - St...

I need a professional to assist in updating my Shopify store. The updates involve design adjustments, setting up Google Analytics and linking my Facebook account. Also, the store's contact information and links need to be updated to reflect the company's new email and phone number. Ideal Skills: - Proficiency in Shopify - Experience with Google Analytics and Facebook integration - Strong design skills - Excellent attention to detail

I'm in search of a proficient Excel specialist to assist with various tasks related to public data and knows how to do formulas ! . Your primary responsibilities will include: - Data Entry: Accurately inputting information into Excel sheets. - Data Analysis: Utilizing Excel's powerful tools to make sense of the data, organize it and seperate it - Report Generation: Creating comprehensive reports based on the data analysis. Key skills and experience required for the job include: - Proficiency in Excel, with a particular focus on data entry, analysis and report generation. - Experience working with public data. - Expertise in generating charts and applying formulas.

I'm looking for a freelance web designer with extensive GoDaddy experience to completely revamp my existing website. The main goal of this project is to update the design and layout to reflect a more professional and modern style. Key requirements: - GoDaddy expertise is a must - Ability to design in a professional and modern style - Previous experience in website redesign Budget is $250-$500 max.

Woork Scoop I need to update only some text an HTML template file through a plugin's admin page. The update primarily involves adding some new text content to the main section of the html template. Some area and text in the html template file have to be untouched or locked for updating due to functionality. Plugin : The admin plugin page is already created , this HTML approach is an aditional functionality to the page. The html file is located in the wordpress plugin folder structure. This html file is connected to the dompdf library function to attach a pdf file to customer mail when order is completed. Ideal Skills: - Proficiency in HTML - Experience with WordPress plugins - Attention to detail for content placement - Experience in PHP code