Excel data connection sql query with parameters jobs

Hi, I need help with optimizing this air-venturi. The goal is to: 1, Adjust this air-venturi to maximize the water-aeration with as small air bubbles as possible with given parameters 2, Make it to deliver 200 and 300 liters/h (2 variants) of at 3 bars water pressure. Plus that i need some help to calculate pressure drops in PVC pipes and other flow related tasks . I prefer to pay per hour. And as we are a unfortunately poor startup, lowest rate wins. Please answer with a personal reply and not an AI generated one.

I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using Word 2010 and will be working with ...

I would need a script written in nodejs where a USB NFC reader (specifically the ACR122U or the ACR125U) wait for a NTAG424 DNA tag. Once an NFC tag is tapped write a URL data into the tag as well as encryption keys. Make sure the URL contains query parameters which are mirrored uid, counter, and cmac that are all encrypted. Part of this is to write a nodejs script to validate the above parameters from the URL and decrypt the uid/counter (or some Rust that can do the same)

exactly similar to this f-system

I have a list of 50000 urls, I would like to scape the pages to see if they contain references to scripts - I will provide a list of the urls and the scripts. Deliverable should be an excel with the 50000 urls and whether they contain the link for each script. Looking for fast turnaround

...from online databases with full permissions. Your main task is to focus on downloading and saving audio files smoothly and efficiently. Main responsibility: - Download audio files with full permissions from the online database provided. - Ensure all downloaded files are in audio file format and properly labeled according to instructions. - Save these audio files to your personal Dropbox account which has a minimum capacity of 1TB. Qualification: - Experience and proficiency in storing and managing files in Dropbox. - Have a Dropbox account with a minimum storage capacity of 1TB. - Exceptional attention to detail to ensure each file is stored properly and organized. - Ability to work quickly and efficiently, with 1 day deadlines. - Has unlimited internet ...

Title: Automated Data Retrieval from Websites Using CRM and CID Numbers Description: We are looking for an experienced developer to automate the process of retrieving data from specific websites using CRM and CID numbers. The goal is to develop a script or tool that will: Look up Doctor's Specialization: Use CRM numbers to search on the website: CFM Doctors Search Extract doctor's information including their specialization. Look up Disease Descriptions: Use CID numbers to search on the website: MedicinaNet CID10 Search Extract the disease description. Deliverables: ( ) A script or tool that can take a list of CRM and CID numbers as input. Automate the search process on the specified websites. Extract

I have a WordPress site where I'm facing some issues with taxonomies. Specifically, I'd like to organize my games by categories using custom taxonomies. Please read the SPECIFICATIONS BEFORE BIDDING - I need assistance with fixing the taxonomy issues and setting up the custom taxonomies to organize my games. - The main objective here is to help me effectively categorize the games on my site. - This will involve back-end work and ensuring that the taxonomies are correctly linked to the relevant content. SPECIFICATIONS (REFERENCE IMAGES PROVIDED): ----------------------------------------------------------------------------------------------------------------------------------------------------------------- I need to remove the Service Number Taxonomy that was add...

...Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 300 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS Office skills to drive automation opportunities. • ...

Hello, I need convert a PDF invoice to Excel to import to our invoices software

I'm looking for an experienced Power BI developer to create bespoke reports and dashboards, which will be integrated into Microsoft Teams. Tasks: - Handling data from Excel spreadsheets and converting it into insightful reports and dashboards. Skills and Experience: - Strong command of Power BI for report and dashboard creation. - Proven experience with Excel spreadsheets. - Good knowledge of integrating Power BI into Microsoft Teams. The goal is to make complex data easy to understand, facilitating better decision-making within our team. Your work will directly impact our day-to-day operations and strategies.

...in need of a specialized WordPress developer with experience in Excel operations and data showcasing. Key tasks: - Create a WordPress page that extracts numeric and text data from an Excel sheet. - Implement highlights and color-coded information on the webpage for better readability and understanding. - The data on the Excel sheet will be updated on a monthly basis, hence the website should be able to fetch the data automatically upon any modifications. Ideal skills: - Proficiency in WordPress and Excel integration - Experience in creating visually appealing data showcases or infographics - Strong understanding of data extraction and display technologies The aim is to have a user-friendly webpage that...

I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my specific needs is essential.

I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using Word 2010 and will be working with ...

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I'm looking for someone who can design a sophisticated budget template for me in Excel. This template should: - Track both income and expenses - Project weekly outcomes - Compare actual amounts to budgeted amounts - Include more than 20 budget categories - Incorporate graphs and charts for visual representation. Skills necessary for this project will include advanced Excel knowledge and experience with financial modeling. The ideal candidate will have previously worked with complex budget templates and be comfortable creating a user-friendly interface. You should know how to devise a system that simplifies input and keeps data organized and easy to understand. Your ability to turn raw numbers into straightforward graphs and charts will be particu...

I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.

I am in need of a comprehensive Excel sheet that does calculation. Data entry is not too complex; it includes dates, dropdowns and formulas. Requirements: - Design an Excel sheet that calculates basic arithmetic operations, performs statistical analysis, and handles financial calculations. - The form should be user-friendly and able to accommodate the moderate complexity of data entry. - I need an expert who can create a clear and concise interface for the user, making data entry and subsequent calculations easy and efficient. It would be great if the freelancer has experience with: - Excel design for calculation purposes - Data entry form design - Experience in basic arithmetic operations, statistical analysis, and financial calcu...

Please Sign Up or Login to see details.

...Google Cloud Platform (GCP). The ideal candidate should have extensive experience with GCP, CI/CD pipelines, and HTTPS configuration. Scope of Work: 1. CI/CD Implementation: - Set up a CI/CD pipeline using GitHub Actions for automated testing, building, and deployment of both frontend and backend applications. - Integrate the pipeline with our GCP infrastructure, including Compute Engine, Cloud SQL, and Cloud Storage. 2. Logging Setup: - Configure logging for all services: -- Frontend (Nginx, ): Log HTTP requests, errors, and application logs. -- Backend (Gunicorn, Django): Log application errors, access logs, and system logs. -- Celery and Beat: Log task execution and periodic tasks. -- Database (Cloud SQL): Log database queries and errors. -- Redis (Clo...

Let's do it. let's do it. let's do it

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

...a 25-page double-spaced report which delves into the connection between ESG scores and real estate company performance. The main questions I'm looking to address in the study are; - Are real estate companies with high ESG scores more profitable? - Does having a high ESG score increase investor interest in real estate companies? - What is the correlation between ESG scores and stock performance of real estate companies? The data for this analysis should be sourced from the past 5 years, and the report should be comprehensive and well-structured, with clear methodology and results. The study should be global in scope, encompassing a range of real estate companies and markets worldwide. This project would be best suited for someone with a backgro...

I'm in need of an Excel expert to enhance my files. The tasks include: - Removing duplicate rows - Fixing formatting issues - Merging two sheets into one Additionally, I would like to incorporate a corporate branding style in the file, utilizing appropriate colors and logos. Ideal Freelancer: - Proficient in Excel with experience in data cleaning - Skilled in formatting and merging multiple sheets - Familiar with incorporating corporate branding within Excel

I need a detail-oriented and efficient freelancer to assist me with a data entry project. The specifics are as follows: - The project requires entering a combination of numeric and text data. - The goal is to have the data organized in a clear and coherent manner. The format of the data is likely to be in spreadsheets, although it may vary. Proficiency in Excel and Google Sheets will be essential for this task. Previous experience in data entry with formulas will be considered a plus. The ideal candidate will be able to deliver high-quality work in a timely manner.

I'm in need of a skilled developer to create a text-based GPT (Generative Pre-trained Transformer) specifically for analyzing excel outputs and give answer according to user pre-defined questions.

I'm looking for a skilled coder to program a...Makecode and Parralax servo. The goal is for the robot to navigate through a fixed blueprint maze without the use of sensors. Key Tasks: - Coding the robot to follow a fixed maze blueprint - Implementing line following, obstacle avoidance, and remote control functionalities Ideal freelancer candidates should: - Have in-depth experience with Microbit Makecode and Parralax servo - Demonstrate ability to create complex movement patterns within strict parameters - Provide past work examples showcasing similar tasks This project requires meticulous attention to detail to effectively program a robot that can independently navigate a preset labyrinth. Your expertise in this specific coding language and hardware will be a critic...

use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65 for 30%; 12 for 40%; 78 for 10%; 5 for 15%; 23 for 70%;...

...in need of a talented developer to design and establish a platform that connects volunteers with nursing homes. The features do include: - User profiles which will consist of the name, contact information, as well as skills and interests. - Search and filtering options that will make finding specific user profiles easier. - A user-friendly messaging functionality for enhanced communication. The user roles on the platform are divided into two categories: - Volunteers who will utilize this platform to seek service opportunities in nursing homes. - Administrators in charge of monitoring and managing the platform. The ideal freelancer for this project should have experience in web development with a focus on user interface design and backend functionality. Balancing the n...

Active Directory Expert to create a Python script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, AD RMS (Rights management Services) group policy GPO etc. and export to a MS Excel File. More information attached.

I have a project where I need assistance with a few specific aspects of deploying node.js. These include: - Connecting to a PostgreSQL database that is currently partially set up, - Integrating with Sequelize, specifically addressing problems with model relationships, - Establishing a connection to AWS. This will be an hourly consultation, so I'm in need of a freelancer who is highly skilled in node.js deployment, PostgreSQL database set up, Sequelize integration, and AWS connections.

I'm looking for a dedicated virtual assistant to assist me with simple data entry tasks. The data will be provided in handwritten notes. Ideal Skills and Experience: - Proficiency in data entry - Ability to handle simple copy-pasting tasks - Experience with handwritten notes data entry is a plus - Attention to detail and accuracy - Excellent time management skills - Familiarity with tools like Excel or Google Sheets for organizing the data Please note that while the tasks are straightforward, attention to detail is crucial. I'm looking for someone who can deliver accurate and timely results.

We are looking for 5-10 years of .Net experienced developer who can also have experienced in React and .Net based web development. Long terms multiple projects development. Using Mainly Azure SQL server database with Visual Studio .Net Core API. Graph QL and EF. Worked on Azure Key Vault, Azure Logic app, Azure function is bonus.

use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days *****you provide code to simulate input data -> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 transactions per day for given product for promotion random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product...

What we have -------------------------- 1: Excel or CSV file. containing addresses to post letters 2: Letter Quality ( Paper weight, Sizes, Cost per letter etc configuration in JSON array) What we need -------------------- - Standalone PHP Script where we will be able to select an item from provided JSON. - Through DHL API we will validate the provided addresses(in the form of exel or csv) if each individual address is valid - or we should be able to select the areas of over choice over google map is shown in the provided video - this funcationaly is also provided over DHL api I think. and there demographic filters can also be applied which are provided be DHL api also shown in the video Please apply only if you the the required experience. these links may help

...documents and photos into simple data in Excel format (language is not in English workable when one can use translate and understand the few terms that are there). The ideal candidate will have the following skills and experience: - Proficient with MS office - Expert in handling MS Excel - Ability to follow a specific Excel template provided - Attention to detail to ensure accurate data entry ***The task is very simple and just requires attention to detail. I need mainly 4 Data Rows: 1. Date 2. Payor/Payee 3. Amount 4. Short Description of Transaction (if given in the doc) Please message me to talk about the project and the realistic bid price per Job. Your responsibility would be to ensure that the scanned files and photos are a...

We are an Ecommerce company dealing with variety products and we are looking for a Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications skills Can work on Excel Have sufficient experience in Social Media Ads and Digital Marketing

I'm looking for a skilled AI Developer to program module that speaks with AI (Gemini or GPT) as batch analysis of Excel files. Key Responsibilities: - Conducting pattern recognition and insights in the data Ideal Skills: - Strong AI development experience - Proficiency in Excel and data analysis - Ability to automate analysis processes

I am seeking a skilled developer to create a WebRTC web phone. The primary purpose of this application will be to handle both audio and video calls. It is crucial that this phone appl...designed to function smoothly exclusively on desktop devices. Key Tasks: - Implement audio and video calling functionality - Ensure clear user interface for desktop usage - Ensure high-quality and smooth call capabilities - Secure and reliable connection for calls Please note, there's no need to implement any call recording feature in this product. Required Skills: - Proficiency in WebRTC - Solid grasp of UI/UX principles for desktop software - Proven experience in web phone app development - Strong understanding of connection security Those with prior experience in similar ...

I need a Laravel developer to create a simple, yet effective admin dashboard with user authentication. The template for the dashboard is ready, and the SQL tables have been set up. The main features of this project include: - **Dashboard:** This should display data from the other 3 pages in a list format as well as in a bar chart. - **Page 1 - Callback List:** A simple list of data from the 'callback' table. - **Page 2 - Token List:** A simple list of data from the 'token' table. - **Page 3 - Name List:** A simple list of data from the 'name' table. For the dashboard, I'm looking for a clean, professional design and prefer the use of bar charts for the graphical representation of the data. User authen...

I'm seeking a talented data scientist specializing in ship engine assembly to analyze key parameters and offer process insights. Key Parameters and Metrics: - **Efficiency:** Analyze the efficiency of our ship engine assembly processes. - **Performance:** Look into the performance metrics of the assembly line. - **Reliability**: Assess the reliability of our ship engine assembly. Process Insights: - **Workflow Optimization:** Provide insights and recommendations on how we can optimize our workflow for better efficiency and productivity. - Collect datasets for llmRAG and embedding vector database - You should choose the models for llms and RAG and frameworks Ideal Skills: - Proven experience in data science, particularly in the manufacturing industry ...

...an experienced and skilled engineer, data scientist to assist in optimizing the cooling power of a new metamaterial. The project involves algorithm development to achieve our cooling optimization goals. I will forward you a report where they've used Genetic Algorithm method to optimize parameters. She has used four flux theory to predict optical properties for different particle parameters. you should not optimize the reflectance... in your work, you should optimize the cooling power Requirements: Proficiency in MATLAB Strong background in optics, material science, or related fields. Experience with genetic algorithms and parameter optimization techniques. Excellent communication skills and ability to work independently. Nice to have:...

I'm seeking a skilled Unity developer who can work on the development of a tower defense strategy game. The core mechanics of the game are ready. Your only job will be syncing the data across all clients in a match. Skills requirements: - Expertise in Unity game development - Experience in Photon Engine - Knowledge about Github will be a bonus In this project: - You will create a connection between multiple clients for multiplayer gameplay - Sync the data across all clients (Don't bid if you have no idea about Unity or Photon. AI proposals will be discarded too)

I'm in need of an Advanced SAP PAPM Trainer to join our dynamic team. The ideal candidate should: - Possess advanced expertise...Advanced SAP PAPM Trainer to join our dynamic team. The ideal candidate should: - Possess advanced expertise in SAP PAPM - Be able to deliver engaging and interactive training - Have prior experience in training others on this particular module Please note that we are specifically looking for an individual with a strong background in this specific module, rather than a general SAP professional. The training will be conducted remotely, so good communication skills and a strong internet connection are essential. If you fit this criteria, I'd love to hear from you. Let's discuss the details and how we can work together to ensure a...

...organization and identification. Key Features & Functionality: - Tracking Items in Different Boxes: The primary and most crucial function of the app is to enable the user to keep a comprehensive record of the items stored in various boxes. - QR Code Creation & Scanning: The app should offer the functionality to generate QR codes for items and boxes, and the ability to scan these codes for easy data input. - Item Lists per Box: It is essential that the app can maintain a list of items uniquely attributed to each box. This feature should be intuitive and user-friendly, allowing for easy additions, deletions, and modifications. - Image & Photo Integration: To enhance the tracking process, the app should offer the capability to take photos or add pre-existing images for ...

I'm in need of a skilled TradingView Pinescript developer to merge two ...usability of the merged indicator The ideal freelancer for this project is expected to have: - Solid experience in TradingView Pinescript development - Expertise in merging and adding indicators in Pinescript - Ability to understand and implement user requirements without a detailed specification. Please note that the project details regarding the specific indicators to be merged and the input parameters are not available at this point. You will be required to analyze existing indicators and decide on the best way to merge them, and potentially add a few extra indicators to improve the overall functionality. This will require good problem-solving skills and a deep understanding of technical indicators u...

We have a project developed with VS2022, c#, datatables, SQL database, javascript and similar.... The user experience is not good. We need a professional and nice interface and user experience, but, mantain our actual code and funcionality.

Hi, I am looking for a developer to maintain, make upgrades and fix bugs on my current website and booking system. The system has been done in SQL written in C# by my old developer. He has had a change of career and can no longer work on things but is happy to do a handover to make things easier. This will be an ongoing business relationship and not a one off thing so will need someone with good communication and accurate times of completion. Thanks, Luke.

I am seeking an experienced Power BI expert who can assist with generating intermediate reports. This role involves: - Working with Excel datasets. - Developing seamless processes to generate user-friendly reports. - Troubleshooting any issues that may arise during report generation. The ideal freelancer should have: - Excellent understanding of Power BI. - Experience in report generation. - Adept knowledge in handling Excel datasets. - An analytical mindset with attention to detail. Proficiency in Excel and experience with intermediate report generation will be highly advantageous.

...remain intact. Optimize SQL Queries: Review and optimize all SQL queries to handle heavy loads efficiently. The current system experiences performance issues during peak times, and the new version should resolve these. Fix Bugs and Security Issues: Identify and fix any existing bugs and security vulnerabilities in the current project. Ensure the new version adheres to the latest security standards. API Integration: Connect the backend with the frontend using APIs. The APIs should be well-documented, secure, and efficient, allowing seamless communication between the backend and frontend. Requirements: Proven experience with CodeIgniter 3 and 4. Strong knowledge of SQL query optimization. Expertise in identifying and fixing bugs and security ...