Excel vba update sql tableроботи
Обязательные знания: 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...
Рейтинги підраховуються на основі готових формул. Рейтиги повинні постійно перераховуватись після завершення матчу в залежності від результату. Всі дані беруться з сайту через api. Ціна обговорюється після детального ознайомлення з завданням. Детальний опис завдання відправлю в повідомлення.
... Шукає 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.
Потрібно зробити легкі лабораторні роботи, терміново! Файли прикріпив, за потребою скину методичку.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
Я маю довгострокову роботу, яка пов'язана з нашим попереднім проектом 'Change Framework CMS from Shopify to Prestashop - PHP, HTML, CMS, SQL'
I'm experiencing issues with Excel's conditional formatting and need an expert to help. Key issues: - Cannot copy entire conditional formatting rules across the spreadsheet. Ideal skills for this project: - Advanced Microsoft Excel expertise - Proficiency in identifying and resolving Excel-related issues - Strong understanding of conditional formatting techniques Please provide regular updates via remote. The troubleshooting will be for Excel 365.
...web application in wordpress. It must have a landing page stile, the payment of service, so creation of account, login and payment. It must have a form plugin to do questionnaire. At th eend of the questionnaire the AI must show a report baed on answers. The web must have a form plugin jotform) The job to do: make the landing pages with information of service, add the buy page of service using table price and direct ckeckout (you can use woocommerce); add jotform; integrate the questionnaire of jotform and the answer with AI to create the authomatic report. The questions of jotform and the answer of jotform must be saved inside my mysql database. So it is necessary use a plugin to create the tables and save the answer add a plugin or code to comunicate with an AI the plugin (wp...
I'm seeking an instructor to help me grasp the concept of optimization, focusing primarily on Linear Programming. As a beginner with Excel Solver, I need someone who can guide me through solving questions with various constraints. Key Requirements: - Expertise in Linear Programming. - Proficient in teaching Excel Solver. - Capable of explaining different types of constraints depending on the case study. -solve with me questions Ideal Skills: - Advanced knowledge of optimization techniques. - Strong communication and teaching skills. - Experience in using Excel Solver for complex problems. As the type of constraints we will be working with will depend on the case, I require a flexible and knowledgeable instructor who can adapt to different scenarios and explai...
Start your bid post with "apple" I'm looking for an experienced WordPress developer who can revamp the layout of my current theme () to meet our specific ne...demonstration videos to provide more dynamic content. - Customer Reviews Section: Integrate a section for customer reviews and ratings to build trust. - Customizable Filters: Implement advanced filtering options for users to easily sort through products. Ideal Skills and Experience: - Proven experience in WordPress theme customization - Strong understanding of layout design - Graphic design skills to update imagery and graphics - Experience with e-commerce and product page design - Ability to implement changes across multiple sections of the website Under a few days or 24 hours.
Product Update and Listing Optimization on Shopify + Google Integration I need a freelancer to assist in updating and optimizing product listings on my Shopify store. Additionally, I require the integration and proper syncing of my Shopify store with Google to ensure the products are correctly displayed on Google Shopping and Tasks: Product Updates on Shopify: Review current product listings and update with accurate details (images, descriptions, pricing, tags, etc.). Ensure each product is properly categorized for easier navigation and searchability. Add any missing product variants (size, color, material, etc.). Update or add SEO-friendly titles, meta descriptions, and product URLs for better search ranking. Google Integration: Ensure that the Shopify store is c...
I have approximately 3000 rows of data spread across three Excel 365 sheets. I need someone to extract, link, and manage this data for me. The final deliverable will be a detailed report in Excel. This report should include: - Data summaries - Trends and patterns - Comparative analysis PEASE REFER TO THE ATTACHED EXCEL FILES WHICH WILL BE USED THE SCOPE FOR THE BID IS IN THE WORD DOCUMENT There's no need for complex formulas, but the ability to identify and highlight these aspects of the data will be crucial. Your expertise in data management and proficiency in Excel will be key to the success of this project. THANK YOU FOR THE TIME TO READ AND BID
...Northwest Seed & Pet on top + Spokane, Wa est. 1944 on the bottom (top & bottom words in a circular arc) *I can send a better pic asap. one of the entire bear showing him with no one sitting on it. 8. Tucker, the tortoise 9. Flower/Plant design with Northwest Seed & Pet Spokane, WA est. 1944 on top 10. Plants/Green House with Gertie the cat silhouette by the back door, Ruby the parrot on the pants table, and an iguana on the top bar, as in the picture. 11. Fish design with Northwest Seed & Pet Spokane, WA est. 1944 on top 12. Division store outline - in sketch style - please include the geckos that are on the building. 13. Sprague store—in sketch style—can include cars out from like in the pic, but if it looks better without them, that'...
I ha...warnings due to some dependencies. I need a skilled developer to: - Fix the deprecation warnings by addressing the dependencies issues - Deploy the fixed app on Vercel - Add a custom domain to the deployed app - Implement a password-protected page for user access only - Perform a thorough review of the existing codebase for additional issues - Optimize the web app for performance enhancements - Update the version to the latest stable release Experience with Vercel and domain management is a must. I also need your expertise in setting up the password protection. The specific method for this has not been decided yet, so I would appreciate your input on the best and most secure option. Please note, the goal is to make this web app accessible only to a selected group of use...
I am looking for a data operator to assist with a complex data entry project. The ideal candidate should have experience in data entry from digital files, specifically using Microsoft Excel. The work involves significant formatting and clean-up of the data. Skills and experience required: - Proficiency in Microsoft Excel - Strong attention to detail - Ability to handle complex data entry tasks - Experience in formatting and cleaning up data - Experience with creating and using Excel Macros 1 year If you are meticulous, experienced in data entry, and proficient in Microsoft Excel, please apply for this project.
I have 35 pages of handwritten documents that need to be typed in xl. The specific requirements, such as document format and font style, can be budget is $10 if you think this is good for you then you are welcome. Otherwise please do not be on this project.
...Python, PostgreSQL, and UI development with Tailwind and Bootstrap. The project entails working on our MVP for a product. Key tasks include: 1. Splitting our two Python engines and UI, currently housed in a single GitHub repository, into three independent repositories based on module type. It's critical that all three repositories function independently post-split. 2. Enhancing the UI, where most SQL tables are already feeding. This involves: 2.1. Mirroring three additional tables. 2.2. Incorporating more advanced filtering options, as well as enabling users to edit, save, and export data. 2.3. Cleaning up user groups, specifically 'Admins' and 'Regular users'. 2.4. Adding additional functionalities to the UI. Ideal candidates should have a...
I'm seeking a professional content creator to prepare a comprehensive help guide for my app aimed primarily at new users. Key Requirements: - The guide should contain clear and concise text instructions complemented by visual aids such as sc...easy-to-understand language. - Proficiency in creating or working with visual aids. The goal is to make this help guide as user-friendly and informative as possible for new users. The help guide should be created as a web-based resource. Visual aids should primarily use screenshots for better understanding. The content should maintain a casual and friendly tone throughout the help guide. Please update the help guide in the website admin panel. The help guide should be detailed and thorough. Only text instructions and visual aids wi...
I'm seeking a skilled photo editor to help me with 50 food photography images featuring pizzas. The task is to remove the table and tray backgrounds, leaving just the pizza. The final images should be delivered in PNG format, ready for use in print materials. Key Requirements: - Remove backgrounds from food photography - Crop images naturally, exactly at the edge of the pizza - Deliver final images in PNG format Ideal Skills: - Proficiency in photo editing software - Attention to detail - Experience with food photography editing Please only apply if you can deliver clean, natural-looking images ready for print.
I'm seeking a freelancer adept at data entry, specifically from digital PDFs into an Excel spreadsheet. The task involves extracting solely text data from these documents. Ideal Skills: - Proficient in Excel - Excellent attention to detail - Experienced in data entry from PDFs Expectations: - Accurate and timely completion of the task - Ability to maintain data confidentiality - Effective communication for any clarifications needed
I'm seeking a professional for data entry, specifically focused on numeric data. The data will be sourced from various digital documents and should be entered into either Excel or Google Sheets. Ideal Skills: - Proficient in Excel or Google Sheets - Attention to detail - Experience in data entry, particularly with numeric data - Ability to maintain confidentiality and handle sensitive information responsibly.
I'm seeking an experienced data analyst and Power BI expert to design an engaging and insightful dashboard for tracking both project progress and financial metrics in the construction industry. Key Features: - The dashboard should track project-related metrics such as completion percentage, milestones achieved, and tasks overdue. - Financial metrics shou...percentage, milestones achieved, and tasks overdue. - Financial metrics should include revenue forecasts, expense categorization, and project rating. Ideal Skills: - Proficient in Power BI - Strong background in project management tracking and financial reporting - Experience in the construction industry is a plus - Excellent data visualization skills The dashboard should integrate data from Excel/CSV files. start propos...
I need someone to change the color theme of my PowerPoint presentation as per specific colour codes that I will provide. The update should be applied uniformly across all slides, without altering any images.
I need a data entry/web/Instagram scraping specialist who can help me categorize the 2600 businesses I follow on Instagram. The businesses primarily belong to the fields of architecture, construction, and development, with specific focus on: - Architects - Builders - Developers - Project ...construction, and development, with specific focus on: - Architects - Builders - Developers - Project Managers - Landscape Architects The categorization should include the following fields: - Company Name - Website - State - Profession - Do they follow me back A good command of English is essential for this task, as is the ability to follow clear instructions and input data accurately into an Excel spreadsheet. Experience in data entry, web scraping, and social media analysis would be highly b...
As a Package Handler/Shipment Coordinator in Orlando, FL, I am looking for a reliable individual to manage the receipt and forwarding of packages. You will primarily deal with small parcels and medium-sized boxes. Special handling will include fragile items. Key Responsibilities: - Inspect incoming packages for damages or discrepancies - Verify package contents and update records - Forward packages to designated recipients via in-person delivery - Maintain accurate records of package receipt and forwarding
... - If a **Destination does not have Subcategories**, list Tours directly. - This modification should be applied to **``**. 4️⃣ **Modify the Subcategory Archive Pages (`/tours/destination-name/subcategory-name/`)** - These should **only list Tours belonging to that Subcategory**. - Ensure that no duplicate tours appear across multiple categories. 5️⃣ **Update Permalink Structure for Custom Tours Post Type** - Ensure the URL hierarchy follows this structure: ``` /tours/ → Lists Destinations /tours/destination-name/ → Lists Subcategories (if any), then Tours /tours/destination-name/subcategory-name/ → Lists only relevant Tours /tours/destination-name/subcategory-name/tour-name/ → Individual Tour Page ``` - Modify ...
I'm seeking a proficient Excel user for data entry and analysis. Skills and Experience: - Proficient in Excel with experience in using Pivot tables, Formulas and calculations, Charts and graphs - Attention to detail for accurate data entry - Ability to analyze data and generate reports if needed Please note that the specific type of data and primary goal for this project have not been specified. The successful freelancer will need to be flexible and adaptable to different types of data and tasks.
... Purchase a domain name and set up hosting. Go Live: Deploy the website and monitor for any issues. Marketing: Use digital marketing strategies like Google Ads, social media campaigns, and email marketing. Offer promotions and discounts to attract initial customers. Analytics: Integrate Google Analytics to track user behavior and sales performance. 8. Maintain and Update Regular Updates: Add new products, update prices, and refresh promotions. Customer Support: Provide excellent customer service via chatbot Feedback: Collect customer feedback to improve the website and user experience. To automatically extract data from PB Tech NZ () and load it onto your website, you can use web scraping techniques. However, before proceeding, it's important to note
I need an annual Profit and Loss statement prepared for an SBA loan application. It will be in Excel format. Key Tasks: - Prepare the P&L statement in Excel - Follow a standard template or best practices, as I don't have a specific template - Cover the statement for the entire year Skills and Experience: - Proficiency in Excel - Experience in preparing Profit and Loss statements - Familiarity with SBA loan requirements - Ability to suggest and implement standard templates or best practices.
I need assistance understanding my app's situation and legal guidance. I'm looking to set up a dedicated group chat on Freelancer messaging with a legal expert. - Legal Help: I'm not sure what's happening with my app, so I could use a legal professional's perspective to help me understand the situation and assess any updates. - App Developer Communication: I'm not getting any responses or updates from my app developer, so I need someone who can also ask them what's going on. - Analyze existing contracts with the app developer to identify any breaches or obligations. - Prepare a detailed report of the current legal standing of the app. - Suggest updates to terms of service or privacy policy in light of recent app developments. - Provide a risk assessme...
I'm seeking assistance in improving the organization of my Excel sheet which records staff daily work activities. The primary focus will be on refining the data layout for better clarity and accessibility. I need to separate outreach calls vs in-person assistance/community events. I started formula to total based on week and the month. Ideal Skills: - Proficiency in Excel, particularly in data sorting and filtering. - Experience with creating organized data layouts. Although I don't have specific formulas in mind, I would appreciate a professional with knowledge of various Excel functions who can suggest and implement suitable ones to enhance the functionality of the sheet.
...data should include: - Company name and its corresponding LinkedIn page URL - Work email addresses of facility managers and office managers (London-based) - LinkedIn profile URLs of the aforementioned managers - The source link for each piece of data An Excel template will be provided for you to input the data. The ideal freelancer for this project should be: - Detail-oriented and able to follow instructions accurately - Proficient in data collection and research - Familiar with LinkedIn and its functionality - Able to work with Excel Please note, I only require work emails, not personal ones. The companies should be in the legal industry. Budget: Flat rate 5 NZD per 100 companies (100 office managers & 100 facility managers) Time: 2 days Please start your bid...
...relevant action. Page: [Specify the relevant URL] --- 8. Auto-Update Issue After Clicking "Monsters" Issue: Even if the user does not click the update button, the profile is automatically updated after clicking "Monsters." Request: Prevent automatic updates unless the user manually clicks the update button. Page: [Specify the relevant URL] --- 9. Adjust Font Size from 14px to 16px Request: Change the default font size from 14px to 16px across the site. Page: [Specify the relevant URL] --- 10. Hover Effect for New Monsters Request: Add an orange hover effect similar to the reference image when a user hovers over a new monster. Page: [Specify the relevant URL] --- 11. Fix Footer Buttons in Pop-ups Issue: The "Update...
...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 have numerous Excel workbooks containing sales data that need to be cleansed and transformed into a single table. This project requires expertise in data processing and analysis. Key Tasks: - Cleanse the data from individual workbooks to a single workbook table - Transform the cleansed data into a single comprehensive table -there are approximately 300 workbooks, that each have about 8 sheets of similar data that is not tabled -extracting "amount paid to installer" sheet information is not part of this scope, but could be added at additional cost if it make since to extract that data at the same time. Do not include this in your price, but if interested chat message about details. The final table should include: - Date of sale - Customer det...
...Branding Video Overview: I’m creating a high-energy, cinematic personal branding video as part of a job application for a Strategy Consultant / Business Development role at Arcane Marketing. This is not a standard talking-head video—this is a visually dynamic, engaging storytelling piece that blends humor, authenticity, and creativity to showcase who I am, my skills, and what I bring to the table. I’m looking for a freelance videographer to assist with shooting, framing, and potentially some light editing. The shoot involves multiple locations, a mix of cinematic and comedic shots, and drone footage. I’ll provide a detailed shot list and schedule—just need the right pro to help execute the vision. What I Need from a Videographer: ✅ Pro-l...
I'm looking for someone to analyze an academic paper focused on the energy sector within the realm of science. The analysis should specifically c...presented in the paper. Key Requirements: - Expertise in the energy sector of science. - Strong skills in analyzing experimental results. - Ability to provide clear and concise interpretations of findings. Task: - Understand the method that undergoes in the following research paper - Write the maths that goes from the data till the results step by step on paper and send the pdf - After that make an excel for conducting such step by step maths The ideal freelancer for this project will have a strong background in science, specifically the energy sector, and can demonstrate experience in analyzing academic papers and their experi...
...the Figma design. Additionally, if possible, you'd like to combine mobile versions with desktop versions, making the design responsive. For pages that don't have a mobile version, they should be made responsive, as there are no specific Figma designs for them. You already have a frontend built with Vanilla JS, but due to recent changes in the design and some issues with the frontend, you need to update it to match the Figma layout. There was a separate version for mobile, but not all pages had a mobile version. So the goal is to merge existing mobile versions with the desktop versions and make everything responsive. Pages without a mobile version should be adapted to be responsive since there's no Figma layout for them. For reference, you can look at the website
I'm looking for a talented web designer/developer to redesign my X-CART website with a modern visual aesthetic. The primary goal is to update the visual design, so a strong grasp of contemporary design trends and principles is essential. Key Requirements: - Expertise in X-CART platform - Proficient in modern web design principles - Strong visual design skills - Experience in website migration Please provide examples of your previous work that align with a modern design style.
...system (e.g.: Auth0, Firebase Auth, or JWT + OAuth2). Add permission controls (e.g.: admin, analyst, client). Real-Time Notifications: Develop an alert system using WebSocket or tools like Pusher/Socket.io. 2. Data Features Data Synchronization: Create jobs to automatically update campaign data (e.g.: every 5 minutes). Store metrics history for temporal analysis. Automatic Insights Calculation: Develop algorithms to identify trends (e.g.: "CPA increased by 20% in the last week"). Report Export: Generate PDF/Excel with filtered data (e.g.: performance by period, platform). 3. AI System AI Integration in Chat: Connect to an NLP API . Train the model to answer technical marketing questions (e.g.: "How to improve ROAS?"). Automatic Insights Ge...
