Excel data connection sql query with parameters jobs
...innovative application that connects users with qualified tradespeople in real-time. The app should feature: - Separate registration processes for customers and tradespeople, with the app being free for customers and implementing a monthly fee for tradespeople. - A map displaying the nearest tradespeople upon a customer's selection of a trade service. - A rating system akin to Uber's, appearing when a customer clicks on a nearby tradesperson. - An eye-catching orange and grey color scheme. The user registration process should include: - Email verification - Phone number verification Skills and Experience: - Proficient in cross-platform app development for both the Apple Store and Google Store - Experience with real-time tracking features in apps - Famil...
I'm seeking a skilled Excel or Google Sheets expert to create a comprehensive spreadsheet to track my crews in hotels. The data I need to monitor for each crew includes: - Crew names and contact information - Hotel check-in/out dates - Room assignments - Purchase Order (PO) numbers - Job Numbers The spreadsheet should have the following functionalities: - Automatic notifications before the hotel booking ends Ideal candidates should have extensive experience in creating complex spreadsheets with advanced features, and a strong understanding of data management. Please include examples of similar projects you've completed in your bid.
... or Articles Designing Survey Questionnaires Designing Posts or Banners Creating Survey Results Presentations from Data Retouching Images (Single or Multiple) Building Simple Landing Pages We are seeking an experienced OpenAI developer to help us build a custom content writing tool tailored to the specific writing styles of multiple clients. This tool will leverage OpenAI's language models (such as GPT-4) to generate content that aligns with the unique preferences, tone, and voice of each client. The vision is to create a system where users can select a client from a list. Upon selection, the tool will adapt its content generation approach based on client-specific parameters, stored in a database. Additionally, the tool should learn and adapt its writing style...
I need help with pointing my domain to my Odoo website. The website is already hosted and live, but I need assistance with configuring DNS settings and setting up an SSL certificate to ensure a secure connection. Ideal Skills: - DNS configuration - SSL certificate setup - Odoo platform experience - Bluehost familiarity Please note: This task requires a high level of precision and understanding of web configuration to avoid any downtime or service interruptions.
I'm in need of an export sales professional to help expand my network of wholesale distributors in the Middle East, specifically within the aesthetic and cosmetics industry. Key Responsibilities: - Identify and connect with potential wholesale distributors in the Middle East. - Focus on aesthetic and cosmetics resellers and distributors. Ideal Skills: - Proven experience in export sales, particularly in the Middle East. - Strong connections within the aesthetic and cosmetics industry. - Excellent communication and networking skills. If you can help me build a solid network of wholesale distributors in the Middle East, I would love to hear from you.
I require a talented web developer to fine-tune my unfinished WordPress site. Key Areas of Improvement: - Design/Layout: Customizing the theme and enhancing visu...Customizing the theme and enhancing visual aesthetics to create a more appealing and user-friendly interface. - Functionality/Features: Troubleshooting and improving certain plugins/add-ons, as well as refining forms and interactive elements for seamless functionality. - Content/SEO: Optimizing the site’s content and SEO parameters for better visibility and reach. Ideal Skills: - Proficiency in WordPress with a strong focus on theme customization. - Extensive experience with WordPress plugins and interactive elements. - Strong understanding of SEO principles and content optimization. - A keen eye for...
...Typography and Symbol: The logo features a bold and modern typeface, with "GM" prominently displayed above "Matelas & Mousse." The "G" and "M" appear stylized, potentially resembling a mattress frame or structure, reinforcing the connection to bedding products. Color Palette: Dominant colors include a bright turquoise and a deep blue, which convey freshness, comfort, and trust. These shades align with the brand's focus on relaxation and quality sleep products. Background and Context: The logo is superimposed on an image of a rolled-up mattress or foam material, directly relating to the products the company offers. This visual connection immediately clarifies the brand's niche and industry. Design Style:...
...product packaging, marketing materials, and digital platforms. This is your opportunity to bring a meaningful vision to life, merging tradition, strength, and modern elegance. Design Guidelines: Core Elements: Replace the large "WPB" concept with two gold war paint strikes to symbolize strength and protection. Include a tagline: Empowered and Proud beneath the logo. Incorporate arrowhead symbols on each side of the logo, but only one arrowhead per side, designed to fill the space proportionally. A subtle teepee-inspired "A" can be explored to align with Indigenous artistry. Inspiration: Fonts similar to VERSACE or DIOR for a high-end, sophisticated look. Indigenous symbols such as Thunderbird (power, protection, strength) and arrowheads (resilience,...
...talented designer to create a sleek and modern logo for our all-natural, plant-based hair care product line. The logo should embody minimalism while reflecting that is a hair product. It must incorporate both an icon and text, ensuring that it is easily recognizable and readable. Key Requirements: Style: Minimalist design. Color Scheme: Earth-tone palette (e.g., browns, beiges) to evoke a connection to nature. Elements: A combination of an icon and text that complements the natural theme. Readability: Clear and professional text that works well in various sizes and formats. Scalability: The logo should look great on packaging, websites, and promotional materials. Deliverables: A primary logo design (icon + text). Variations for light and dark backgrounds. Vector files (...
I need an AWS AI Expert with experience in creating chabots connected to PDF, Words, Excels... Also they need to be able to query data from SQL Databases. You need to integrate this in an existing Flask App. I am Python developer and will be supervising your job, just need assistance with this AI service.
...children's book aimed at 3-5 year olds, with a focus on Christian themes. Key Responsibilities: - Craft an engaging, age-appropriate story centered around Christianity - Design and deliver captivating full-page illustrations that complement the story - Ensure the book is suitable for its intended audience in terms of language, themes and illustrations Ideal Skills and Experience: - Proven experience in writing and illustrating children's books - Strong understanding and personal connection to Christian themes - Ability to create engaging, age-appropriate content - Excellent illustration skills, with a portfolio of similar work - Understanding of the needs and interests of the 3-5 year old age group Please provide samples of your previous work with...
i need help with an exam for Microsoft server tecnologies(MST), the exam is 5 hours, its 7 questions, might need to be done trough only desk to remote control my pc, the date for the exam is 05.01.2025. lowest price bider wil be choosen, the person need to have experience with microsoft server. Installation and Configuration: Understanding Windows Server deployment, updates, and patching. Active Directory (AD): Managing domains, forests, trusts, Group Policy (GPO), and user/group permissions. DNS, DHCP, and Networking: Configuring and troubleshooting network services like DNS, DHCP, IP addressing, and subnets. 2. Virtualization and Cloud Hyper-V: Setting up virtual machines, virtual networks, and storage in a Hyper-V environment. Azure Services (if relevant): Knowledge of Azu...
...up an eCommerce fulfilment warehouse, and I'm looking for an experienced developer with a good understanding of Kotlin, JavaScript, Spring Boot and AWS to help out with the backend development and integration with external platforms. Key Responsibilities: Ad-hoc support bug fixing (should be less than 3-4hrs per week) Full stack development for new feature (e.g new warehouse feature, or new API integration etc…..) (approx, 20hrs per week) Required Skill Backend Development: This will involve developing and maintaining the backend systems of the warehouse. Experience with Kotlin, JavaScript, Spring Boot and AWS is a must for this role. Integration with External Platforms: I need help connecting the system with Shopify, TikTok, and v...
...for the Solana blockchain. The current version is not functioning as required, as it is returning inaccurate or false data. The issue is suspected to stem from the API being used, though it could also be code-related. The purpose of the wallet scanner is to analyze wallet performance based on profit and loss (PnL), win rate, and other parameters like weekly or monthly performance. The resulting CSV file must reflect accurate wallet performance metrics. Key Requirements: Data Accuracy: The data in the CSV file must accurately reflect the actual performance of the wallets. Before submission, the developer must verify the accuracy of the output data and ensure it aligns with wallet performance. API Integration: If the current API is the root ca...
I have a two-year-old Flutter project that needs to be made compatible with the latest Flutter version and run on my server. Key Requirements: - Fix any compilation or compatibility issues with the Flutter project - Ensure proper connection with the backend server running on Python - No need for updates or new features, just compatibility Ideal Skills: - Experience with Flutter and Python - Proficient in diagnosing and resolving compilation and compatibility issues - Capable of ensuring seamless backend connection
REQUIREMENTS AND INSTRUCTIONS FOR A BETTER WP WEBSITE. ***THIS MAY REQUIRE YOU TO DELETE THE SITE BUT KEEP THE DATA**** If you do have to delete the site to restart everything again please note that you pay great attention to the required designs mentioned below and features that have been added to particularly the product page. - ACF: this help with categorising in the back end. Please use effectively. - payment gateway-woocommerce/stripe: We are currently using both but I would like to really know if you have some skill in using Stripe and using its powerful features. - shipping fees need to be adjusted (increase the current shipping fee by +£40). Sort by weight but also cheaper models of watches and dials under £1000 will have a different shipping fee (I ...
Create a tool that scrapes online business profile reviews for any business I input. Key Requirements: - The tool should allow me to input the name of a business with online reviews - It should capture ALL the reviews in a single excel document like the attached Timeline is 2 to 3 days
...need experienced PCB designer to help with correcting and updating my KiCAD PCB design for an ESP32 shield. The project involves: - Improving the routing and trace layout to ensure all connections are finished according to requirements - Preparing a BOM file with all components ready for upload to PCBWay I have detailed connection requirements, so you won't need to help with defining them. However, your expertise in optimizing the routing and traces is critical for this project. Please read the requirements file for details. Don't hesitate to ask any questions. Ideal skills and experience for the job include: - Professional english level desirable. - Ability to think critically and identify potential issues / flaws in design. - Proficient in Ki...
I am in need of a skilled backend developer to create an API that will interact with a SQL database (MySQL or PostgreSQL). The API should be capable of performing various operations such as: - CRUD (Create, Read, Update, Delete) operations on records - Executing complex data queries and generating reports - Handling user authentication and session management The ideal freelancer for this project should have extensive experience in API development and working with SQL databases. Understanding of user authentication systems and session management is also crucial.
I need assistance with an Excel project where I am trying to find unique permutations of mixed data (text and numbers). Key Requirements: - Expertise in Excel, particularly in handling permutation matching. - Ability to work with mixed data sets (text and numbers). - Experience in displaying results in separate columns. I would like the results to be displayed in separate columns. If you have the necessary skills and experience to assist me with this project, please reach out.
...video tutorials on Embedded Systems. Your content should cover key topics such as Real-time operating systems (RTOS), advanced microcontroller programming, and embedded system security. The Educational Engineering Academy (EEA) is seeking experienced instructors to create high-quality video tutorials across a range of technical topics. We are hiring for multiple courses, covering Embedded Systems, Data Analytics, ARM Programming, IoT, Automotive Technologies, and Linux Administration. Overview: Payment is based on the number of final video hours delivered. Applicants must submit a sample video (Google Drive link or file upload) explaining a mid-to-advanced embedded systems topic to demonstrate teaching and recording ability. Flexible schedule – work at your own pace whi...
...It will provide users with real-time information about nearby tourist spots, weather forecasts, and trending travel events or activities using data from external APIs. The app will also allow users to store favorite destinations and manage their travel plans by saving locations and upcoming events. Users can interact with the app through a simple interface, offering functionalities such as exploring events, viewing weather updates, and navigating to different locations using Google Maps. Functionalities: 1. User Authentication: Users can sign up and log in using Firebase Authentication, and their data (name, email, etc.) will be stored in Firebase Firestore. 2. Travel Destinations List: Display a list of nearby tourist attractions or destinations in a Recyc...
...modify an existing Docker image to incorporate a connection through a static residential proxy. The Docker image in question is designed to simplify the deployment of Grass () and can be found at this link: Key Requirements: - Implement connection through a static residential proxy provided by proxyscrape. - Each cloned Docker image must set up with individual proxy account credentials. Deliverables: - A step-by-step tutorial to deploy the Docker image using Portainer. - The modification of the Docker image to facilitate easy scaling of mining Grass by duplicating and deploying the Docker image. Ideal Skills and Experience: - Proficiency in Docker and Linux server deployment. - Experience with proxy services and implementing them in Docker
...skilled Python developer with experience in Raspberry Pi, I2C communication, and MLX90640 thermal camera modules. This project involves developing a Python library to enable the continuous and parallel operation of four thermal cameras, capturing data at a minimum frequency of 8Hz per camera, without the use of a multiplexer. Key Requirements: 1. Python Library Development: - Create a custom Python library for MLX90640 thermal camera modules. - Enable continuous data capture for all pixels (24x32 resolution) for four cameras, saving the data into CSV files. 2. Communication Setup: - Establish custom I2C buses for each camera using predefined Raspberry Pi pins (rearrangements possible but limited). - If a more optimal way of communicat...
...involves QR code scanning and data logging. Key Features: 1. Login Activity: Users will log in by scanning a QR code with their device's camera. A default user will be provided and other users will be pulled from a specified Excel file on the device. 2. Matching Activity: Users will scan three different QR codes, which the system will match. Each QR code has 4 fields, which the shall be processed and match logically. Add a container to add additional QR codes when a field does not match. once all matches, The user can press a button to save the record as an Excel file. There will be a Photo container that will lookup jpg file in device local folder, if one of the field from QR code is entered . 3. Report Activity: A simple list format for viewing sav...
I'm seeking an adept professional with strong Excel and MySQL skills for a project centered around the creation and management of a database. Key Responsibilities: - Creating and managing a new database in MySQL - Entering and updating a mix of numerical and textual data in Excel Ideal Candidate: - Proficient in Excel with experience in data entry and updates - Skilled in MySQL, with a solid understanding of database creation and management - Capable of handling and effectively managing mixed data sets (text and numbers)
I'm looking for an expert in web scraping who can extract product data from two specific e-commerce sites. I need the data to be organized in a well-structured Excel file, categorizing the products into 'product family', 'sub family', and 'product'. Key Requirements: - Extracting the 'Product name' and 'Price' for each product. - Excluding product images; scraping should only focus on product name and price. - Delivering the data in a clear, organized manner in an Excel file. Ideal Skills and Experience: - Proven experience in web scraping, particularly with Shopify and WordPress. - Proficiency in Excel and data organization. - Attention to detail to ensure data is accur...
I'm seeking an experienced professional to assist with the design of a rural drainage system. The key tasks include: - Preparing a detailed list of design requirements for the rural drainage system, focusing on determining an acceptable return period for critical rainfall conditions. - Conducting preliminary design work for both the drainage and irrigation systems. This will entail calculating design parameters, net irrigation requirements, and selecting appropriate equipment. - Analyzing leaching requirements during irrigation to prevent salinization. I also need a comprehensive analysis of calculation results under various rainfall conditions using SOBEK software. The final deliverable should be a clear report detailing the design steps and results, alongside a pro...
...have a legacy Excel workbook developed over the last decade that I want to transform into a web-based platform. This will involve using the Excel workbook as an 'engine' in the background. The final product should include: - A web-based interface with user logins - Payment processing capabilities for licensing - An Admin dashboard - User analytics features - Integration of some AI elements, specifically natural language processing The platform should also have a user database where project details can be stored, allowing users to handle multiple projects and modify existing ones. Ideal skills for this project include: - Proficiency in web development - Experience with legacy system integration - Knowledge of AI, particularly natural language pro...
I'm seeking an Excel expert to create a comprehensive sales commission report. I receive monthly reports from my company, but they don't balance the commission sold versus the commission final at job completion. Key Requirements: - Creation of a report that can be used ongoing, allowing future data input - Each job has three commission payments based on billed/paid - The report should provide as much data as possible Data to be Included: - Sales amounts - Commission percentages - Job completion status - Cost - Price - Margin - Profit - Commission Rate - Commission amount sold - Commission amount executed - Commission due Ideal Skills: - Proficient in Excel - Experience with sales and commission reporting - Ability to create reports fo...
I'm looking for a freelancer who can create two report templates in Zoho Writer connected with our Zoho CRM data. The templates should be modeled after an Excel report design and tailored for client presentations, hence they need to be professional and easy to follow. The first report is 3 pages long, and the second one is 8 pages long. The templates should include: Essential Elements: - Data feed from Zoho CRM - Conditional formatting for certain text field The ideal candidate will have experience with Zoho Writer and Zoho CRM, as well as a clear understanding of creating business report templates. I've specific branding guidelines that need to be applied to the report templates, so the freelancer should be able to adhere to these closely....
I'm in need of a seamless connection between Afterbuy and Clever Reach for effective newsletter management. This project will involve transferring customer information, specifically email addresses, from Afterbuy to Clever Reach on a weekly basis. Further: We need someone who is familar with afterbuy to ensure, that we are getting the customer approval inside of our Afterbuy Shop (during the order process). Key Requirements: - Update our Afterbuy Shop to get customer approval for Newsletter - Setup of the data transfer process on a weekly schedule. - Ensuring the transfer of only relevant customer information, specifically email addresses. Ideal Skills and Experience: - Proficiency with Afterbuy and Clever Reach platforms. - Experience in data in...
I'm facing problems with my Laravel application. Specifically, I'm unable to create issues from the Admin panel, as they simply won't save. When I attempt to save an issue, nothing happens at all - the page doesn't reload nor do I receive a validation error. In addition to this, I also need assistance with importing an Excel file into my database. Ideal Skills and Experience: - Proficient in Laravel - Database management and Excel import experience - Strong debugging skills to identify and resolve issues - Familiarity with Admin panel functionalities in web applications.
I am in need of a professional who can help me repair a corrupted SQL Server 2005 .bak file. The file is not restoring properly and I have received an error message while attempting to do so. The specific error message I received was "Unexpected end of file". Ideal skills and experience for this job include: - Extensive knowledge and experience with SQL Server 2005 - Proven track record of repairing .bak files - Ability to troubleshoot and resolve file restoration issues - Excellent understanding of SQL Server error messages and their solutions. Your expertise in this matter would be greatly appreciated.
I'm looking for a professional to create a PowerPoint presentation from my Excel data. The presentation will primarily focus on sales statistics, specifically sales by region. The visual representation of the data will be in pie chart format. Ideal skills for this project include: - Proficiency in Excel for data extraction - Expertise in PowerPoint for presentation creation - Ability to create clear and engaging pie charts - Experience in sales report preparation The final output should be a well-structured and visually appealing PowerPoint presentation that effectively communicates the sales data.
I want to make an excel FILE template to make sure I have enough enough staff available cover the work duties The staff will provide services according to below Market sessions Saudi Days: Sunday to Thursday Session: 11:00 AM – 3:30 PM Daylight Saving Time: Not applicable UAE Days: Monday to Friday Session: 10:00 AM – 2:00 PM Daylight Saving Time: Not applicable London Days: Monday to Friday Session: Standard Time (October to March): 11:00 AM – 7:30 PM (AST) Daylight Saving Time (March to October): 12:00 PM – 8:30 PM (AST) US Days: Monday to Friday Session: Standard Time (November to March): 5:30 PM – 12:00 AM (AST) Daylight Saving Time (March to November): 4:30 PM – 11:00 PM (AST) I want to make excel template to -plan and track staff...
I have a chandelier in my residential home that's not working and I need an electrician to diagnose the issue. The chandelier has a remote control feature, which may be part of the problem. Key Requirements: - Professional inspection of the chandelier and its wiring - Determining whether the issue lies with the lights themselves or the connection - Repairing the issue, if possible The ideal candidate for this project should have: - Proven experience as an electrician, preferably with residential light fixtures - Skills in troubleshooting and repairing remote control light fixtures - Ability to provide a thorough inspection and diagnosis of the chandelier's issue Please note, I've already checked the remote control batteries, so they are not the sourc...
I'm in need of a Microsoft Power App that connects to an Excel sheet for creating data entries across 6 columns. The data entries will be a mix of text and numeric values. Key Features: - Mixed data types: The app should allow for both text and numeric entries. - Some predefined options: Certain columns will require dropdowns or fixed options for text entries, while others will be open for free text. - No numeric validation: There are no specific rules or range limits for the numeric entries. Ideal candidate should have: - Proven experience in developing Microsoft Power Apps. - Strong skills in Excel, particularly in setting up sheets for data connection. - Ability to create user-friendly interfaces with dropdowns an...
I'm looking for a .NET professional who can help me develop a WebSocket connection for CoinSwitch. The main purpose of this connection is to receive real-time price updates for multiple cryptocurrencies. Reference code is as below. Specific Requirements: - The WebSocket code should efficiently handle updates from various cryptocurrencies. - It should primarily focus on capturing price changes. Ideal Skills: - Proficiency in .NET programming language. - Prior experience with WebSocket connections. - Familiarity with cryptocurrency data and CoinSwitch platform is a plus. Please note that the primary goal is to receive real-time price updates. Your expertise in handling this task will be crucial for the success of this project
I need assistance extracting data from PDF files into a structured Excel table. The data is primarily in table format and the formatting is consistent throughout the document. Ideal skills and experience for the job include: - Proficiency in Excel - Experience with data extraction from PDF - Attention to detail - Ability to follow instructions carefully
I need an expert in Shopify and GTM to create a custom conversion event named 'Paid Purchase'. This event will trigger when a customer successfully completes a payment through SSLCommerz and arrives on the payment confirmation page. The parameters must be transmitted via both the Pixel and the Conversion API. Key Responsibilities: - Create a custom conversion event named 'Paid Purchase'. - Ensure the event triggers upon customer payment confirmation. - Transmit parameters through both Pixel and Conversion API. Data Points to be Tracked: - Transaction ID - Purchase Amount - Customer ID - First Name - Last Name - Address - Phone Number - City Please provide your quote and estimated time for completion. Thank you. Here is my website
...skilled Power BI Developer with a passion for turning raw data into actionable insights? We’re looking for a freelance professional to help us unlock the full potential of our data with dynamic dashboards and tailored analytics solutions. What We Need: • Expertise in Power BI: Custom dashboards, data modeling, and advanced DAX formulas. • Experience with integrating data from multiple sources (SQL, Excel, APIs, etc.). • Strong understanding of business intelligence and data visualization principles. • Ability to create visually compelling and interactive reports tailored to specific business needs. • Excellent communication and problem-solving skills. Your Responsibilities: &bull...
Hi there - I'll deliver the file as we've discussed by VBA in Excel. Thanks for your trust!
I am in need of an experienced IT professional to setup a Linux server for me. The specific configuration requirements a...Linux server for me. The specific configuration requirements are as follows: - Linux Distribution: Ubuntu - .NET Version: Please install .NET Core 3.1 - MySQL Version: I require MySQL 8.0 - React - Node JS Server - MongoDB instance This server will be hosting a React application with a database connection. It is crucial that the setup is done correctly to ensure smooth operation of the server and application. Ideal Skills: - Extensive knowledge and experience with Ubuntu - Proficient in .NET Core 3.1 - Familiar with MySQL 8.0 - Experience in setting up servers for React applications - Strong problem-solving skills to troubleshoot any issu...
I need an expert to install SQL 2019 on my server, which currently has SQL 2014 Express. The primary purpose of this installation is to facilitate a database migration involving mixed data types. Your responsibilities will include: - Installing SQL 2019 on the existing server - Assisting with both the database schema and data migration Ideal candidates for this project should have extensive experience with SQL installations, particularly SQL 2019, and a deep understanding of both database schema and data migration processes.
I need an experienced professional who can link two separate Microsoft Excel Online sheets. The requirement is as follows: - One-way Data Sync: The first sheet (Sheet 1) should automatically update the second sheet (Sheet 2) whenever there's a change. It's crucial that this sync does not interfere with the sheets' existing functionality, colours, or any other design elements. - Data Type: The primary data being used in these sheets is a combination of text and numbers. Please ensure that the integrity of the original sheets is maintained and their visual aspects remain unchanged post-sync. I am looking for someone with proven expertise in Excel Online and data synchronization. Your bid will be considered more favorabl...
I require assistance with data entry into an Excel sheet. The data is currently stored in databases and consists of a mix of numeric and textual information. The data needs to be categorized by department in the Excel sheet. Ideal skills for this job include: - Proficiency in Excel - Experience with data entry - Ability to categorize data effectively - Attention to detail - Familiarity with databases
...Requirements: - Automate the placement of Market orders, Limit orders, and Stop orders - Strong proficiency in 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 90...
