Excel vba sql based column valueроботи

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

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

Task: Develop a thermometer module based on the TMP36 temperature sensor. Provide operation in three modes: temperature measurement in degrees Celsius, degrees Fahrenheit and Kelvin (change of mode using the button). Use the display (4-digit 7-segment indicator and 74HC595 shift register) to display all necessary data. Use the button and LEDs to set the operating mode and display the current mode. Additional materials: TMP36 documentation: Documentation for 74HC595: Using a 7-segment indicator: Example of implementation:

Доброго дня! Шукаю фрілансера, хто міг би допомогти час від часу писати коди 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 та внести в неї данні з касових чеків. Розбити по періодам та групам.

Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу 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'

...realistic oscilloscope image based on a int entry value. At the end this function will be crucial for a mini-game where players must determine the correct value by interpreting the generated oscilloscope image. Key Requirements: - Create a realistic oscilloscope image - Integrate grid lines and waveform amplitude into the display - Ensure the function is callable by blueprint Ideal Skills: - Proficiency in UE5.5, particularly with blueprints and C++ - Experience with game development and designing interactive elements - Understanding of realistic graphical styles - Ability to create engaging and intuitive user interfaces The oscilloscope should include grid lines and display waveform amplitude. There is no interaction, only generated image from a entry value...

...creating compelling social media posts that resonate with target audiences. In addition to my writing expertise, I offer video editing and creation as a secondary skill, allowing clients to develop content from script to screen. My experience spans editing explainer videos, social media content, and ads, allowing for a seamless process that strengthens your brand’s message. As a Virtual Assistant, I excel in efficiently managing administrative tasks, from email management to digital marketing. My expertise in social media marketing is particularly beneficial for managing e-commerce sites and ad campaigns, boosting conversions and brand visibility. I’m committed to delivering exceptional service, ensuring every project meets the highest standards. Let’s collab...

I'm an individual start-up seeking a dedicated team for ongoing maintenance and updates for my Flutter-based app, DropIn Surf. The app employs a Firebase backend, Google Maps API, and a Flutter-built admin panel. - The app's user interface and experience require the most attention. - The code can be complex, so I'm looking for someone flexible, patient, and capable of adjusting, fixing errors, and debugging as necessary. - As a start-up, budget is crucial. Ideal candidates would have extensive experience with Flutter, Firebase, and Google Maps API, with a knack for UI/UX improvement. I value a friendly and cooperative working relationship, with a team who understands the needs of a start-up. Please note that I have not yet determined a specific method for ...

...additional logic to populate more values into the table in the most efficient way possible, with minimal overhead on the database. I will provide an Excel spreadsheet with simple formulas required to replicate the logic. The extension involves implementing approximately 9 additional calculations and updating a different table using simple IF statements based on the calculated values. Key Requirements: • Extend the existing MySQL cursor, which already has a loop set up for fetching values. • Implement about 9 additional calculations based on simple formulas provided in an Excel spreadsheet. • Update a different table using simple IF conditions based on the calculated values. • Ensure the solution is optimized for minimal databa...

I'm in need of an Excel expert who can help automate some of my book-keeping tasks. The main focus will be on reconciling accounts. Your responsibilities: - Utilise experience with excel formulas and macros to refresh existing reconciliation process for the book-keeping and management reporting of a small UK charity. - Ensuring accuracy and efficiency in the automation. Ideal skills and experience: - Proficiency in Excel, particularly in using formulas and creating macros. - Background in book-keeping and accounting. - Experience in automating tasks in Excel.

Project Title: Real Estate Cashback Platform Project Overview: This platform is designed to revolutionize the real estate industry by streamlining property sale registration while offering tangible benefits for buyers, developers, companies, and freelancers. It enables property buyers to receive 1.5% cashback of the property value directly into their digital wallet, accessible via a unique barcode. This cashback can be used freely, giving buyers greater flexibility and value. The platform also provides a legally compliant and efficient solution for developers and freelancers to register property transactions, ensuring transparency and accountability throughout the process. Key Features: For Developers and Real Estate Companies: Seamless Registration: Register as a verifi...

...with advanced Excel tasks, day-to-day inventory management, and voucher entries. The candidate should be proficient in VLOOKUP, charts, and pivot tables, and adept at removing duplicates. Key responsibilities include: - Utilizing advanced Excel functions for data analysis and visualization. - Regularly updating stock levels and performing inventory reconciliations. - Assisting with various voucher entries, including expenses and income, purchases and sales, and journal entries. - Maintaining comprehensive account books, including cash and bank, sundry debtors and creditors, current assets and liabilities. - Performing BRS and journal entries, as well as managing credit and debit notes and party ledgers. Ideal skills and experience: - Extensive experience with Microsoft ...

...world’s first Simplified AI Agent Management Platform, designed to empower users by removing the burden of repetitive, labor-intensive tasks. DelegateX allows users to delegate their work to customized AI Agents—your X Bots—freeing up your time to focus on what truly matters. We are seeking design professionals to create a compelling brand identity that reflects our vision, highlights our unique value propositions, and inspires trust and excitement among our diverse audience. Challenge Goals We aim to establish a brand identity that: 1. Communicates Empowerment Through Delegation • Showcase how DelegateX enables users to “leave their worries behind” and delegate tasks to AI agents across various domains. • Examples include campaign me...

I'm looking for a comprehensive list of Honda 2-wheelers dealers across India, extracted from the provided website. The data should be organized in an Excel file with the following characteristics: - Specific Details: For each dealer, I need the dealer name and address, as well as their contact numbers and email. - Geographic Scope: The list should cover all of India. - Data Organization: The dealers should be organized in the Excel file by state. Ideal skills for this job include data extraction, proficiency in Excel, and attention to detail. Previous experience in compiling similar lists would be an advantage.

I'm looking for a skilled database programmer to create a stored procedure for data retrieval across five tables. This procedure should handle complex joins and maintain foreign key relationships. Key Requirem...skilled database programmer to create a stored procedure for data retrieval across five tables. This procedure should handle complex joins and maintain foreign key relationships. Key Requirements: - Design a stored procedure primarily for data retrieval. - Proficient in managing joins across multiple tables. - Understands and can maintain foreign key relationships. Ideal Skills: - Proficiency in SQL and experience with stored procedures. - Strong understanding of database management and relational databases. - Excellent problem-solving skills to handle complex data r...

telegram to excel btc and others coins

I'm looking for a VBA developer who can create a code for my Microsoft Excel. When I copy/cut a cell, the previous 5 cells should be blocked from being copied/cut as well. This restriction should apply only to the active worksheet. Ideal Skills: - Proficient in VBA programming - Deep understanding of Microsoft Excel - Previous experience in creating Excel macros

...secure AWS-based backend architecture that ensures seamless data ingestion, transformation, and real-time interaction with our website. Key Responsibilities Data Ingestion Schedule Python scripts using AWS Lambda to fetch data from APIs. Handle API rate limits, errors, and retry mechanisms. Store raw data temporarily in Amazon S3. Data Parsing Clean and structure raw data for further processing. Ensure data validity and store parsed data in S3. Data Transformation Enrich and reshape parsed data for analysis or database upload. Store intermediate results in S3 for staging. Data Upload to SQL Database Save transformed data into Amazon RDS (PostgreSQL/MySQL) with optimized database inserts. Ensure data integrity and performance. Data Analysis and SQL Transformatio...

...throughout the transaction process, addressing any issues or delays promptly. Maintain meticulous records and follow up to ensure smooth deal closures. What We’re Looking For We value creativity, organization, and professionalism. The ideal candidate will: Have excellent communication skills (both written and verbal). Be confident making outbound calls and thrive on building connections. Possess a knack for design and marketing (experience with Canva and Constant Contact is a plus). Demonstrate exceptional organizational skills and attention to detail, especially when coordinating transactions. Be self-motivated and excel in a remote environment. Have interest or experience in real estate (wholesaling or transaction coordination experience is a bonus!). Why Join Us?...

I am seeking an experienced sales professional, specifically a senior-level candidate, to close sales for my consulting business. Your role will be critical in making a tangible difference in our growth. Ideal Skills: - Proven track record in sales closing - Extensive experience i...consulting business. Your role will be critical in making a tangible difference in our growth. Ideal Skills: - Proven track record in sales closing - Extensive experience in consulting industry - Experience in recruitment - Exceptional communication and negotiation skills - Ability to understand and convey the value of our services - Committed to making a positive impact Required: - Be located in the Pacific Northwest - Be open to commission-based work Desired: - Mission-based (you wa...

My web-based driving school management system built on PHP is facing some issues that need urgent attention. Ideal Skills and Experience: - Extensive experience in PHP development - Proven track record of troubleshooting web-based systems - Ability to improve system performance and user experience Please note, specific issues with the system have not been identified yet, and it would require a thorough examination of the system to determine the exact problems. The primary users of the system are students, instructors, and administrators.

I'm seeking an Excel expert who can help me automate a project progress report using macros. The report will track task completion status. Ideal Skills and Experience: - Extensive knowledge and experience with Excel - Proficient in creating and implementing automation and macros - Previous experience with project tracking and reporting - Excellent attention to detail

I am seeking a proficient freelancer with expertise in automating data entry tasks particularly related to spreadsheet entries. Specifically, the task involves automating the process of entering client details into Excel spreadsheets. The chosen professional should be well-versed with automation tools suitable for this task and have a keen eye for detail to ensure accurate entries. Ideal Skills and Experience: - Proficiency in Excel and data management tools - Previous experience in data automation projects - Detail-oriented and accurate in data handling - Familiarity with client details entry is a plus. Your responsibility will be to ensure that the automation process is seamless with minimal room for errors. Accuracy and speed are of the essence in this project.

...Python - Experience with Interactive Brokers platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation If you accept my term apply this task: Budget:Rs 900 I will give good review, if you complete my budget, Dont expect more money, Money will paid after complete the job successfully, dont ...

...presented on a separate page, enhancing user focus and engagement. - Users should navigate through the questionnaire using both 'Next' and 'Previous' buttons, allowing for flexible pacing. Ideal Skills: - Experience with questionnaire design and user interface (UI) principles - Proficiency in relevant software/tools - Ability to deliver a seamless and interactive user experience. Description of the Excel Attachment: - The text in BLACK are the questions - The text in RED are the possible answers on that particular page - The text in GREEN is a bar that shows the percentage of the questionnaire that is complete. It should be a green bar. - NOTHING ELSE on the outline should appear on any of the pages. That is to help explain the outline and flow. Please DM...

I need a professional Excel macro specialist to help automate the generation of maintenance reports. Key Requirements: - The macro will need to compile and format data into tables and lists for the reports. - The ideal candidate should be proficient in writing Excel macros and have experience with report generation. - Attention to detail is crucial to ensure the reports are accurate and well-structured. If you can help me streamline this process, please get in touch.

I'm seeking a medium-sized realistic tattoo design for my arm, to pay tribute to my late grandfather "Poppy", who was my greatest hero. The tattoo should incorporate an excavator, his name "Poppy", his birth and death years (1945 - 2014), and ball...symbolizing the ones we released at his memorial. Ideal skills and experience for this job include: - Proficiency in realistic tattoo design - Experience with sentimental and personal designs - Understanding of incorporating text and symbols within designs - Strong portfolio of previous work - Excellent communication skills to ensure the design meets my vision This tattoo holds significant sentimental value for me and I want it to reflect my love and respect for my grandfather. Please, only apply if you have t...

I need to enhance my spreadsheets with dropdowns and automations. Specifics: - Implement predefined list of options dropdowns in 3 spreadsheets. - Create macros to handle data formatting tasks that are currently repetitive. Ideal candidate should have: - Proficiency in Excel or Google Sheets, including experience with dropdowns and macros. - Understanding of data formatting processes. - Ability to complete the job within 0.5 to 1 day's work.

I'm in need of a seasoned PHP developer to create a user login system that caters to different user roles - 'seller' and 'buyer'. This system should incorporate essential features such as login, registration, profile editing, and password resetting. Key Requirements: - Use of MySQL as the database for the user login system. - Incorporation of an email verification service for added security and user authenticity. - Design of a modern, graphics and animation infused user interface for the login system. Ideal Skills: - Extensive experience with PHP and MySQL. - Proven track record in developing user login systems. - Proficiency in creating modern, animated interfaces. - Experience with integrating email verification services. Your expertise in these areas will be ...

I'm seeking an Excel professional to assist with organizing and sorting data, as well as designing layouts and templates for a spreadsheet that will be used for uploading emails to a platform. Key Responsibilities: - Organize and sort data efficiently - Design user-friendly layouts and templates Ideal Skills: - Proficiency in Excel, particularly in spreadsheet management - Experience with data organization - Ability to create intuitive layouts and templates

...brands, About KSTAR: KSTAR, specializes in household disposable products such as kitchen rolls, toilet tissues, aluminum foils, disposable plates, and cleaning supplies. The brand represents modernity, reliability, and practicality, delivering high-quality solutions for everyday household needs. ________________________________________ Target Audience: KSTAR caters to individuals and families who value convenience, quality, and dependability in household products. ________________________________________ Key Design Elements: 1. Style: • Modern and Minimalist: Reflects professionalism and efficiency. • Dynamic and Memorable: Adaptable across various product types, from mono cartons to tissue rolls. 2. Typography: • Use a bold, clean sans-serif font that is easy ...

...step into this versatile role and make an impact. This position offers the chance to work on diverse projects and contribute directly to our success. --- Proposals that do not include answers to all of these questions will be ignored. While we love AI, please do not use AI to answer these questions—we want true, authentic responses. Don’t worry about spelling, grammar, or sounding perfect; we value honesty over perfection. 1. What experience do you have maintaining HubSpot CRM, ensuring data quality, and managing records? 2. If your working hours differ from your local time zone, which time zone do you primarily work in? 4. How many hours a month would you available/provide with your given proposal? 4. Will you be completing this work individually as an indepe...

I'm starting a service-based startup in the maintenance sector and need assistance filling out a startup business plan form provided by a financial institution. The form is in an Excel file and primarily requires future income and expense calculations to be filled. - You will need to analyse provided rough figures and fill in the form accordingly. - Previous financial statements or historical data. - A quick turnaround is essential. Ideal candidates for this project should have financial analysis skills, experience with startup business plans, and proficiency in Excel. Your ability to quickly and accurately complete this task will be key.

I am seeking a skilled web developer who can help create a tool to automate travel itinerary generation from an existing Excel database. This tool will also carry out various calculations and assist in enhancing the quality of the current database. Key Requirements: - Develop a web application that automates the creation of daily travel plans based on flight details and hotel bookings. - Incorporate cost estimation features to help determine the most economical travel options, including the optimal travel pass for each customer. - Assist in refining and professionalizing the existing Excel database. Ideal Skills and Experience: - Proven experience in web application development. - Strong proficiency with database management. - Previous work with travel-related softwa...

I need a developer to create a new Ethereum-based, deflationary token for me. The token will have a web browser wallet with core functionalities including sending/receiving tokens, token swap features, and transaction history. Key Requirements: - A unique deflationary model where a percentage of tokens is automatically burned with each transaction. - Reflection rewards for holders, incentivizing long-term holding and distribution. - A buyback and burn mechanism to support the token's value and supply control. Skills and Experience: - Proficiency in Ethereum blockchain and smart contract development. - Prior experience in creating deflationary tokens and associated web wallets. - Knowledge of implementing unique token features such as burning mechanisms and reflection r...

I'm looking for a highly organized and efficient secretary to assist with organizing our department's work. This role will involve arranging meetings, writing internal communications, and coordinating teams and their schedules. The ideal candidate will have: - Proficiency in Excel, Word, and PowerPoint - Excellent typing and reading skills in both Arabic and English - Preferably, a background in medical terminology and experience as a medical secretary Your main tasks will be to ensure the smooth operation of our department, facilitating communication and coordination. If you have the required skills and experience, I look forward to receiving your bid.

Develop AI backend based on existing templates

I'm in search of a seasoned photo editor who can enhance my furniture product images. This is not a one-off task, but a continuous collaboration; e...Correct any uneven lighting. - Retouching: Remove any imperfections and enhance the overall image quality. - Shadow Addition: Create realistic shadows to add depth. - Product Manipulation: Straighten lines, remove wrinkles and imperfections. You will need to put the edited images on a white background. I'm not looking for a quick edit to just put the image on a white background and send it back. I value quality work that makes each product look its absolute best. I can pay by the image, please let me know what your proposed per image rate is. In your response, please include the word "apple" to demonstrate that y...

Solicito apoyo para realizar llamadas a un listado de clientes ubicados en México, con el objetivo de presentar los servicios de mi empresa. Es necesario que se complete un formulario con la información proporcionada por los clientes, incluyendo un apartado de comentarios en formato Excel. El propósito principal de esta tarea es obtener los datos de contacto (nombre, teléfono y correo electrónico) de las personas encargadas de compras y de las áreas de laboratorio.

Convert Excel data to Access for monthly data storage and invoice calculation and creation for small water utility company.

...script that interacts with a MySQL database for bulk code updates. Requirements: Input Handling: The script should accept a list of codes through a text box, where each code will be pasted on a new line. Database Interaction: For each code input, the script must locate the corresponding record in the MySQL database, where the codes are stored in individual rows. Value Update: Upon finding a match, the script should update the value of that code with a number specified in a second text box. Error Handling: If the script cannot find a code in the database, it should skip that code and display a warning message, rather than throwing an error. Additional Details: Must be user-friendly and simple to operate. Ensure seamless interaction with MySQL, without causing unnecessary l...

I'm in need of an experienced app developer to help me create a web app focused on enhancing productivity. Key Requirements: - Expertise in web app development - Strong understanding of productivity tools - Ability to design intuitive and user-friendly interfaces - Experience in creating seamless, efficient, and high-performance applications Your bid will be evaluated based on your relevant experience, portfolio of similar projects, and understanding of productivity tools. Please include examples of previous web app projects you've completed, particularly those focused on productivity. Looking forward to your proposals.