Excel data connection sql query with parametersJobs

Analizar Tabla de calculo de probabilidades de internet. Hacer lo necesario para comprender los calculos internos y poder replicarlos es un libro de excel. El trabajo comprende la hoja de Excel y la explicación de los calculos implicitos.

I need a proficient data analyst who can effectively perform basic operations such as calculating totals, averages, and percentages on my Excel sheet. The ideal candidate should have a strong background in Excel data entry and analysis and a keen attention to detail. Efficient data formatting to produce clear and concise analysis results in a spreadsheet format is crucial for this task. Please, only bid if you are confident in carrying out these operations accurately and effectively.

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-fri...

I'm in need of a skilled professional to establish and maintain a seamless connection between my GoDaddy site () and Digistore. The primary objective of this relationship is to boost the sales of my product through affiliate marketing on Digistore. Experience with javascript needed. Key Responsibilities: - Facilitate the connection between Digistore and GoDaddy, ensuring that my product is promoted effectively by the affiliates on the former. - Implement strategies to increase the sales of my product on Digistore through the affiliate marketing program. - Create and manage support materials for the affiliates. This includes pre-written social media posts and product information sheets. Ideal Skills and Experience: - Proficiency in setting up and managing affilia...

...that can convert PDF voter lists into Excel in a text format. Here's a breakdown of what I'm looking for: - Conversion Style: I'd like the tool to convert the PDF voter list by combining all columns into a single table. This will make it easier for me to work with the data in Excel. - Error Detection: It's important to me that the tool can automatically detect and correct errors in the text. Nevertheless, I also want to have the ability to manually review and correct the text to ensure its accuracy. - Language: In this case, the tool only needs to handle English language texts. You don't need to worry about incorporating multi-language support. Ideal Skills and Experience: - Proficiency in PDF extraction and conversion tools - Str...

...pax name, mobile number, pick up location, pick up time, date of flight travel, flight departure time, drop off location - Every day 3 buses are departing to airport. Say morning 8am, 1pm and 8pm. We need to get auto emails based on this bus timings of scheduled pax list and they take manually report with date/time filter. Ideal Skills: - Strong background in web application development - Experience in booking system or related is a huge plus - Fluency in database management, preferably SQL - Proficiency in PHP or a similar back-end programming language - Strategic problem-solving skills and attention to detail The success of this project requires not just technical expertise, but also a clear understanding of travel agency operations and the importance of efficient...

I have a significant amount of text that needs to be typed into Excel quickly. The data is in a simple text format, no complex formatting required. Key requirements: - Proficient in Excel and typing - Attention to detail - Ability to work under tight deadlines The data is straightforward text and requires no specific formatting or analysis. The ideal freelancer will be skilled in data entry and be able to commit to a quick turnaround time.

I'm seeking a skilled...barcode printer - specifically an Argox model. Key Requirements: - The codeset should be designed to work on a Windows operating system. - The printer will be used to print barcode labels which include product information. - The codeset should be able to establish connection with printer, layout of text+barcode, reset any existing settings on printer, basic troubleshooting. Ideal Skills: - Proficiency in Java and experience with printer integration. - Prior experience with barcode printing software is a strong plus. - Familiarity with Argox printers would be a significant advantage. This project is ideal for someone who understands programatic barcode printing, has a good grasp of Java and can deliver efficient and qual...

...and integrations to get the site fully functional and integrated with my overall business process. 4) I don't have an exact site plan yet, would like to just work on it with you - not looking over your shoulder every minute, but just work while I am working so that I can be your guide and help with structure and content. I am in CDT , central time, and would like someone who can work on this time zone say 2-3 hours at a time during my hours so I can help guide the process, track the work, and see the progress. 5) If it works out and I like the connection, I have other existing websites that I need help with, and a variety of other technical tasks. This would be a long term relationship! 6) I would like to work with someone who c...

I'm looking for a skilled AutoCAD designer for a mechanical design project. You'll be responsible for creating a simple drawing with few parts. Key considerations for this project include: - Emphasising dimensions within the design - Including detailed material specifications - Clearly indicating connection details Ideal skills for this project: - Proficiency with AutoCAD, with a focus on mechanical design. - Strong attention to detail to clearly display all required elements. - Experience interpreting and applying design specifications. Please add samples of relevant work to your bid.

I need assistance with extracting data from PDF files into Excel. The task involves: 1. Converting PDF to Excel: Use Adobe Pro to convert tabular data from PDFs into Excel. You can use cracked version to do this. 2. Formatting: The existing tables mostly match the required format but will need adjustments a. Remove unnecessary columns and rows and map the right column names. b. Convert hierarchical data to a flat format. There are 200 PDF files (10 of which have been already done but you can verify them as well), each averaging 4-5 pages (many files have 1-2 pages but there are some with more than 20 pages, averaging to around 4-5 pages per pdf) Here is a google doc that contains references of the pdfs and the expected ...

I need someone who can simplify a c++ project for me. The project is the openDTU repository on GitHub () . I want just the inverter control functionality without all the web and cloud connection stuff. I want a library where I can add a device and control it on a ESP32 directly without connecting it to the internet.

I'm in need of assistance with certain advanced functionality in Excel. My project heavily depends on modifying complex Excel files and requires a specialist with a strong grip on: - Formulas and functions: Ability to apply and manipulate these is critical. - Statistical Functions: Will be used extensively, so expertise in this subset is necessary. - Lookup & Reference Functions: Another function set that the project necessitates. I'm looking for someone with remarkable ability to use these features to streamline data analysis and visualization. The completion timeline for this project is within the next month. Proven proficiency in Excel and the capacity to adhere to the given timeline is mandatory.

I need an online store data extraction specialist to pull key information (product name, price, and barcode number) from a particular online store. - The extracted data should be delivered in an Excel spreadsheet. - This is a one-time task; there is no need for continuous extraction. It's essential that you're proficient in web scraping techniques, able to navigate through the store's pages, and extract the right data accurately. Experience with online store data extraction is preferable. Please indicate any relevant past projects in your bid. Looking forward to working with a pro who can deliver quality results efficiently.

I require a savvy Excel specialist who can effectively perform data analysis for a small volume of data. The data set to be input and analyzed has less than 500 entries and is composed of both numerical and textual data. Ideal Skills and Experience: - Excel proficiency - Previous experience with data analysis - Ability to handle both textual and numerical data The task will involve data entry and thorough data analysis to extrapolate insights from the dataset. Accuracy, attention to detail, and a keen analytical mind are essential qualities for this project.

I'm looking for a freelancer to help with the data entry of a combination of text and numerical data into an Excel sheet. The data will be provided in digital text files. Key Requirements: - Proficiency in Excel and data entry - Attention to detail - Ability to accurately enter both text and numerical data Experience in similar projects will be an added advantage. Please include any relevant samples or references in your bid.

I need an Excel expert to perform a specific data analysis task for me. - The job involves conducting an analysis where two cells are fed values from 1-100. - The task is to find the highest value in a third cell, based on the values of the first two cells. - The values in the two initial cells should be generated using a combination of user input and random generation. Ideal skills and experience for this job include: - Proficiency in advanced Excel functions, particularly those related to data analysis and cell value calculations. - Experience with probability, permutation, and combination would be a plus. - A strong understanding of statistical analysis and data interpretation. This project would be perfect for someone who is detail-oriented...

I need to integrate Tableau with my SQL database, and I'm looking for a skilled freelancer to handle this. Key Responsibilities: - Setup Tableau integration with SQL database - Ensure seamless connection and data flow between the two - Deliver a functional, user-friendly interface for data visualization Ideal Skills: - Strong experience with Tableau and SQL - Excellent understanding of database management and integration - Ability to create interactive dashboards - Proficiency in optimizing data for Tableau visualization This project will require a keen eye for detail and a commitment to delivering a quality, tailored solution.

I need a freelancer to assist me in connecting my MIT App Inventor to my HiveMQ broker. The main goal of this project is for me to gain knowledge and understanding about IoT connectivity. I have the arduino code working succssfuly when I ente...broker. The main goal of this project is for me to gain knowledge and understanding about IoT connectivity. I have the arduino code working succssfuly when I enter the topic and the message manullay in HiveMQ broker. Now I like to use MIT App inventor to connect to broker and passes the topic & messages Key requirements: - Connection of MIT App Inventor to HiveMQ broker - Ability to switch ESP32 LED on/off Ideal Skills: - Proficiency in IoT connectivity - Experience with MIT App Inventor and HiveMQ - Strong understanding of ES...

I'm currently in need of an experienced full stack developer who is proficient in both JavaScript and PHP. Key requirements: - Strong skills in front-end development, specifically using JavaScript. - Proven experience in handling backend development with PHP. - Knowledge of SQL is also important. - While not a strict requirement, familiarity with JavaScript frameworks such as React, Angular, or Vue and PHP frameworks like Laravel or CodeIgniter would be a big plus. - Experience with SSL implementation is a must, but there are no strict preferences as to the type of SSL to be used (Wildcard or EV SSL). Being able to pick the right SSL depending on the project’s needs will be part of your responsibility. If you're the kind of developer who is ad...

As discussed, bird netting calculator editable pdf & xls conversion with formulas from excel, next button and submit.

...click few buttons and select input file to extract numeric digits from JPEG images hosted on a cloud server using the Google Vision API with their TEXT_DETECTION. More detail information from google on text extraction on remote image: The task involves extracting numeric digits using Google's TEXT_DETECTION feature from JPEG images hosted on a cloud server.: - Image URLs are provided in an Excel file (sample attached), with over 200 URLs. - The extracted numeric digits need to be added to the same Excel file in columns next to each corresponding image URL. We require only the digits with a length between 4 to 8 digits. Other text information is not needed. Google Vision API supports offline asynchronous batch image annotation

...to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Data" Cloumn B into A11 as a QR Code Need Text Data from "Sheet Data" Cloumn C into G1 as QR Code The data will be manually pasted into "Sheet Data" I need this for 50 Sheets Pages to ignore Coverpage, Inside and Page Breaks Key Requirements: - Ability to generate QR codes in Excel: The end product should be an Excel script or add-in that can create QR codes based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is on gene...

I am looking for an expert to guide me through my upcoming SHL Numerical Reasoning Assessment. The current level of my understanding falls under the 'intermediate' category. I specifically need to strengthen my Problem Solving abilities before my deadline on April 17th. Ideal skills and experience for this task would be: - Strong knowledge ...strengthen my Problem Solving abilities before my deadline on April 17th. Ideal skills and experience for this task would be: - Strong knowledge and experience in SHL assessments, especially Numerical Reasoning - Excellent in teaching Problem Solving strategies - Proven track record of coaching intermediate level candidates Your guiding hand will help me excel in this assessment. Please submit your bid if these requirements ali...

I am seeking a developers with excellent knowledge of Windows OS and system software development. This project requires creation of a registry monitor that utilizes a hook-based approach for Windows 7, 8, 10, and 11. The monitor will specifically keep an eye on application settings and alert me via email whenever any changes have been made. Key features will include: - Targeting application settings in the registry. - The ability to detect any changes to said settings. - Sending an email alert every time a change is detected. Freelancers with experience in creating similar systems or possessing a deep understanding of the workings of Windows OS will be preferred. Additional Details: Monitor Regedit for the changes related to the policies applied through Service. Send not...

...looking for a professional with proficiency in Power Query and PowerBI. The key objectives are: - Data Transformation: The expert is expected to possess the skills to thoroughly transform operational data since this is primarily what's going to be handled. - Excel Proficiency: Once transformed, the data should be presented in an Excel file. A good command of Excel functionality is important. - PowerBI Reporting: The transformed data needs to be applied in creating interactive reports. Mastery of PowerBI tools is a prerequisite. - Visual Dashboard Creation: A visually engaging dashboard should be created in PowerBI. Practical knowledge of industry practices in dashboard creation is a plus. Prior experience in handling ...

...PCIe lanes and power connections. 5. USB C Type Data + Power Connector (3 Male Connectors) & (3 Female Connectors): - Connect the USB Type-C connectors to the RK3588 SoC or an appropriate USB controller, ensuring proper signal routing for data and power delivery. - Implement circuitry to support dynamic switching between male and female connectors as required. 6. On-board Cooling Fan Pinout (3/5V): - Provide connections for the on-board cooling fan, including power and control signals. Ensure compatibility with both 3V and 5V fan types. 7. WiFi 5: - Integrate the WiFi module into the schematic, connecting it to the appropriate interfaces on the RK3588 SoC and providing necessary power and antenna connections. 8. Power Connection via USB Ty...

I am d...modem will be located so I have a hardwired connection on each floor of the house. I would use those ethernet outlets to connect TVs that would stream content from the internet, and I'm also thinking of having a wireless access point on each floor to ensure strong wireless access throughout the house. I need help figuring out the exact equipment I should buy, and to confirm that my wiring plan will work as intended. I might also need help configuring the router and access points to make sure that I have one wireless network that my devices can easily use as I move throughout the house, switching to the strongest signal as I go. I think my electrician can do all the physical work, so I really just need a design and someone who I can turn to with questions as ...

...robust Progressive Web Application (PWA) with support for offline mode and background sync. Key Project aspects: - The PWA should have offline mode support so that all content can be made accessible even without internet connection. - Implementation of background sync to ensure data consistency upon re-establishing connectivity. - No user authentication is required for this PWA, making it accessible for all users effortlessly. Ideal Skills: - Expertise in and building PWAs - Strong understanding of Offline-first design - Experience with background sync implementation. Your proposal should include details about your experience with similar projects and a proposed timeline for delivery. Looking forward to collaborating with you! if you read...

I need help configuring DNS settings for my 6 Blue Host domains and connecting them to my Estage hub via Cloudflare. Currently, all domains show as active on both Blue Host and Cloudflare, but they ...Investigating the reason why the domains are not connecting to Estage - Ensuring that the domains are successfully connected to Estage by resolving the issue As this is my first attempt at connecting domains to Estage, I'm looking for an experienced professional who can efficiently troubleshoot and resolve this issue. Ideal Skills: - Proficient with DNS configuration - Experienced with Cloudflare and Estage - Skilled in troubleshooting domain connection issues - Excellent communication to explain the process and potential issues Your assistance in resolving this ...

I need assistance with formatting an MS Word document that has been converted from PDF. The document contains some unwanted frames that need to be removed and various sections of the main body text that require amendments. Specifically, you'll need to: - Remove unnecessary frames from the document - Amend specific sections of the main body text - Optionally, transfer the figures in the document into Excel Ideal skills for this project include: - Proficiency in MS Word and Excel - Experience in document formatting and editing - Attention to detail for accurate text amendments - Optional: Experience in data transfer to Excel

I am seeking a ML, Data Science, and software architect specialist to help me conceptualize and design my platform's architecture, specifically experience with embeddings and vector search. I am building a platform where creators can share content across multiple formats and be remunerated fairly. We ingest various content, from podcasts, articles, white papers and infographics, then agglomerate it, extract the most relevant pieces of information based on the end user's profile (demographic data, parameters, queries, etc) and generate a response. Based on the user, the response may have multiple sources with various contributions to the generated answer. Using weighted calculations, we can allocate the proceeds to the content creators. Example...

...is for the website The ranking must hold for 3 months before escrow is released. I must be 100% happy with the result. I require daily reports on what you are doing. I want daily backlink reports. I want daily position ranking reports. In addition, I want to see more backlinks that are high DA and PA and are more niche related. The niche has to do with accident lawyers and accident attorneys. I require top notch communication efforts with my team and myself. Software should not be used to gain rankings. Everything should be manual. Evidence of software being used will be grounds for project cancellation. I am OK with Chat GPT being used to create blog articles that contain appropriate backlinks to the website. Only white hat methods may be used. If bla...

Project Deliverables: 1. Complete research paper manuscript in accordance with JAN guidelines. 2. Data sheet such as MS Excel or SPSS etc. Payment schedule: Complete payment transfer after the manuscript is received and checked by the client. P.S. The revisions proposed by JAN will be incorporated even after the payment release or project completion.

I'm seeking a professional who can make an Excel page from a word document and then make it auto organize for our department. This job requires an ability to create a code to organize and automatically count values in certain columns. The code should be designed to recognize and count based on column values. Unfortunately, I'm uncertain about which specific columns should be counted; clarification will be needed later. Key skills would be proficiency in Excel, programming, and an eye for design. Experience in data organization and tracking is a must.

I am seeking a proficient typist to convert my printed English documents into typed format. Nearly 50 to 100 pages need...into typed format. Nearly 50 to 100 pages need to be completed. - Tasks: The project involves transcribing printed pages into digital format. All printed documents are in English, and I expect the typed versions to replicate the content accurately. - Skills: A strong command of the English language is parameters. This project requires attention to detail, accuracy, speed, and fluent typing skills. - Experience: Previous experience in copy typing would be an advantage, and familiarization with English written materials should be proven. Bids are open for freelancers who can deliver a top-notch task. Your diligence and expertise are essential to this p...

Looking for an expert in Excel VBA and Macros to automate various processes in my work-flow. Here's the brief rundown of the task involves: - Automated data analysis which includes summarizing data, filtering, Slicers, automatic calculation, and the visualization of data. - Creation of a Custom excel automatic dashboard for real-time reporting and data visualization. Ideal Skill-Set: You should be knowledgeable and experienced in the use of Excel VBA and Macros for automation. Prior experience in VBA, Macros, data analysis and report generation would be a major advantage. Familiarity with automated summary, filtering, Slicer and calculation methods is essential; knowledge of using Macros to create dashboards for real-t...

I'm looking for an experienced VBA programmer to extend and modify the existing 'getpdf' project. The key focus is on integrating it with Microsoft Excel. Key Responsibilites: - Integration with Microsoft Excel: This involves extracting data from Excel files and downloading data from VBA which is PDF-based data, renaming it, and using Selenium. Ideal Skills: - Strong VBA programming skills. - Proficiency in integrating VBA with Microsoft Excel. - Experience with Selenium for web data extraction. - Prior work with GETPDF data extraction preferable.

I'm looking for a translator skilled in both English and Spanish education terminology to translate an Elementary level New Comer Math Assessment. The aim is to assist Spanish-speaking students grasp and excel in their math curriculum. This translation project covers topics in basic arithmetic operations. Candidates who have prior experience in education or translation in a similar field will be preferred. This project is particularly significant for enhancing accessibility and inclusivity in mathematics education for Spanish-speaking students. The successful freelancer will bring: - Proficiency in Spanish and English - Experience in translating educational materials - Understanding of basic arithmetic operations - Passion for education and inclusivity.

We required to develop some requirements to be done on Excel macro using office 365.

Myrio connection and operate ...

As the project owner, I am looking for a talented individual who can handle two crucial tasks in Excel: 1. Adding advanced functionality with IF, VLOOKUP, and INDEX MATCH formulas. 2. Implementing conditional formatting. To be successful in this project, you should have: • Proficiency in Excel's advanced functions and calculations • Experience with customizing Excel using conditional formatting • Attention to detail and the ability to execute tasks accurately. Your primary task will be to help me improve Excel's current functionality by implementing the advanced functions mentioned and customizing my Excel using conditional formatting. Your deep understanding of Excel will be crucial to successfully carrying o...

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-fri...

I need assistance in simplifying the library management of a Platformio project. I need the openDTU Project to be simplified so that all the network and mqtt stuff is removed. I want just the inverter control functionality in that library so that im able to control it with the ESP32 without internet connection.

...will enter the login information of another user, in this case it should not proceed. Configure the correct redirect to the necessary sites * insert a link to a document for download on one of the site pages (this document has already been generated and there is a download link on another page of the site) * Add generation of an invoice for using the site in pdf form (the form will be provided) with saving on the pages in the admin panel and on the user page. * Edit the account pages created in the admin panel, add a filter by user, month, account status and account number (these fields have been created, you just need to display them on the page). It should be possible to delete and download invoices, both individual documents and all at once. * There are 2 fields created on...

I urgently need a proficient CSS developer who can style HTML elements, create responsive designs and implement animations into an HTML/JAVA project in Pycharm. The design should be clean and minim...developer who can style HTML elements, create responsive designs and implement animations into an HTML/JAVA project in Pycharm. The design should be clean and minimalist. The ideal candidate needs to be adept at: - Styling HTML elements within minimalistic parameters - Creating responsive designs that scale beautifully across devices - Implementing beautiful yet unobtrusive animations - Working efficiently under time constraints Prior experience with Pycharm and Java is a bonus. The successful applicant will demonstrate strong proficiency with CSS and have a knack for c...

...experienced developer to handle a two-way synchronization between the Bling system and the ERP DeluxeUp. - You will need to import vendors from the Bling system and update their information on the ERP DeluxeUp. - Also, you'll update the Bling system with the latest information from the ERP DeluxeUp. - A GitHub connection is required for the DeluxeUp vendor registration. The synchronization process should be scheduled to run daily and should work efficiently. The ideal candidate for this project should have: - Proficiency in API integration, specifically with the Bling system and GitHub - Experience in two-way synchronization between systems - Strong understanding of the ERP systems Please note that access to the Bling system's source code is a requi...

...built on Firestore is currently experiencing a connection issue in situations where the client's network is firewalled, causing it to fail to connect. What I'm looking for is a reliable solution that can bypass these network firewalls, ensuring that the application can connect smoothly in all types of network environments. Key Project Details: - The primary issue is that the default method used for establishing connections fails when the client's network has a firewall in place. - The solution needs to implement a long-polling connection to workaround these firewall restrictions. - I require this solution to be implemented specifically for desktop browsers. Ideal Skills and Experience: - Proficiency in Firestore web applications and its connection ...

...and posters, facilitating the posting and bidding of jobs, as well as managing project progress and payments. The ideal candidate will have expertise in both front-end and back-end development, with experience in TypeScript frameworks for server-side rendering and React.js or Vue.js for web development, as well as React Native or Flutter for mobile app development. Responsibilities: - Develop user authentication and profiling features, including sign up, basic details collection, and user categorization. - Implement job posting functionalities, allowing users to create detailed job listings with prompts and boilerplate templates. - Design and integrate payment gateways, specifically utilizing Midtrans Indonesia for secure transactions. - Develop interactive features ...

Looking for a savvy surveyor who can get to the crux of the ready mix concrete market in Varanasi, India immediately. I need an in-depth study on: - Current market size & its growth trends - Rival firms & their market share Key requireme...Varanasi, India immediately. I need an in-depth study on: - Current market size & its growth trends - Rival firms & their market share Key requirements include: - Compile a detailed report, covering your analysis & proposing actionable strategies. - Provide raw data in Excel or CSV format in addition to the report. Prior experience in market surveying and a knowledge of the construction industry are big pluses. Your ability to work fast while maintaining accuracy is paramount. Let's revolutionize the Varanasi ...