How to write sql query in excel sheet jobs
... More specifically, I need you to integrate logistics and operations management into this research. Key Requirements: - Research on how logistics and operations management practices are contributing to climate change. - Explore how these practices can be altered to have a positive impact on the regional environment. - Provide insights and recommendations on potential changes that businesses can implement to address climate change. - The report should be comprehensive and data-driven. Ideal Skills and Experience: - A background in environmental studies or climate change research. - Experience in operations management would be beneficial. - Strong research and report writing skills. - Understanding of the regional implications of c...
I am looking for a skilled and experienced virtual server administrator to manage my Microsoft Azure virtual server based on Ubuntu. Key tasks will include: - Software installation and updates - Security and access control - Regular backups - SQL Server and MariaDB management - Websites configuration and administration - Domains configuration and administration I would like software updates to be performed as needed. The ideal candidate should have: - Proven experience with Microsoft Azure - Strong grasp of security and access control best practices - Proficiency in SQL Server and MariaDB management - Prior experience in website configuration and administration
creating an API with VB.NET NF 4.5.2 with vb not c# I need it to have an initial authorization with a username/password and then with a token for the rest of the requests. I only need the project base with the authorization and then an example of data query and data registration. A ws type 'http://url...' POST type The input JSON should be something like this: { "username": "nombre_usuario", "password": "contraseña" } If the credentials are incorrect you must return a 401 If there is any other type of error, a 500 If it is OK you must return a 200 along with a token. That is the token that will be passed in the rest of the calls and that you will have to validate, and that I will save. It will go ...
Expert in Google Spreadsheets only. Someone who can combine data from other files, and websites, and connect it into one spreadsheet. Key requirements: - Website image scraping - Combine data of external websites with existing spreadsheets / excel csv files. - Data scrape images from external websites, and copy url to match the google spreadsheet lines - Download mass URL of these images into a separate accessible folder for future management. Potentially around 50,000 lines of data to manage and enter. Ideal Skills: - Google Spreadsheets - Data Organization - Image uploading and management - Web form integration - Excel We will provide as much data as possible. your job is to enter it in. Most of the database is in English, so...
...professional who can leverage artificial intelligence (AI) analytics to enhance my business efficiency. The project will involve: - Data analysis - Predictive modeling - Natural language processing These tasks aim to utilize machine learning (ML), as well as harness the power of Azure Databricks, Azure Data Lake Storage, Copilot, and Azure Data Factory. This project will also use Azure Kubernetes to ensure that the analytics processes are scalable. The main goal is to augment our standard business processes and make them more effective by leveraging these technologies. The data to be analyzed is structured and originates from various sources like Excel, CSV, SQL, etc. Ideal skills for this project include: - Proficient in AI ...
...looking for a skilled copywriter to help increase the brand awareness for my company. The copywriting will be targeted to professionals aged 26-40, so having an understanding of this demographic is crucial. Idealofessionals aged 26-40, so having an understanding of this demographic is crucial skills and experience for this job ofessionals aged 26-40, so having an understanding of this demographic is crucialinclude: - Proven experience in copywriting - Understanding of how to tailor messages to specific target audiences - Ability to write in a formal and professional tone - Familiarity with creating brand awareness campaigns Your work will be instrumental in helping my company's growth and exposure. Please prov...
More details: What type of data do you need to convert? Text data What is the desired output format for the converted text data? Excel spreadsheet Do you require any specific data manipulation or analysis within the Excel spreadsheet? Data sorting and filtering
I have an Excel sheet that contains text data and I need it to be parsed. I am looking for a Python expert who can use pandas to extract the text data and present it neatly in a new Excel sheet. Key requirements: - Extracting text data from an Excel sheet using Python pandas - Presenting the extracted text data in a new Excel sheet - Sorting and filtering the extracted text data as per business requirements Ideal Skills: - Excellent knowledge of Python, especially pandas - Proficiency in working with Excel sheets - Experience in sorting and filtering text data - Strong attention to detail and commitment to quality
I am seeking an experienced and creative fashion designer who specializes in men's clothing, specifically focused on trendy casual wear. Your responsibilities and qualifications would ideally include: 1. Creativity: Demonstrated ability to conceptualize and design unique bottomwear pieces that align with Verve Clothing's brand identity. 2. Trend Awareness: Stay updated with current fashion trends, especially in bottomwear, and incorporate them innovatively into designs. 3. Color Sense: Strong understanding of color theory and the ability to create visually appealing color palettes for bottomwear collections. 4. Software Proficiency: Proficient in CAD (Computer-Aided Design) software for creating technical drawings and Adobe Creative Suite (Ill...
Explain how we get from the layout screen in blender to a rendered line view as shown at the samples.
Looking for a true professional in the world of Google data scraping. Your task will be focused on obtaining text content. Accessibility and knowledge of stringent guidelines for ethical compliance is of utmost importance. Ideal Skills: - Proven experience in Google data scraping. - Legal knowledge on data scraping. - Exceptional attention to details. - Highly skillful in data analysis. Requirements from the Freelancers: - Provide evidence of past experiences, preferably in Google data scraping. Final Use of the Data: - The data collected will be used to gain insights, helping me make informed decisions. Please note that only applicants with the above-described skills and adherences will be considered. Applications missing the enumerated e...
...am looking for an experienced freelance to convert my past year's Profit and Loss statement into a fully itemised budget for the upcoming year. This will encompass the following elements: Key Requirements: - Extract and organise data from a PDF P&L statement - Formulate an Excel-based budget plan for the upcoming year including Revenue, Expenditure, and Cost of Goods Sold - Base projection data on the historical records from the P&L statement - Breakdown of expenditure must be category-wise - Incorporation of a pie chart visualising the budget details Considering the urgency of this project, I require the final product within the next 12 hours. Ideal Skills: - Excellent understanding of financial document analysis - Proficiency in using Excel...
...looking for a skilled copywriter to help increase the brand awareness for my company. The copywriting will be targeted to professionals aged 26-40, so having an understanding of this demographic is crucial. Idealofessionals aged 26-40, so having an understanding of this demographic is crucial skills and experience for this job ofessionals aged 26-40, so having an understanding of this demographic is crucialinclude: - Proven experience in copywriting - Understanding of how to tailor messages to specific target audiences - Ability to write in a formal and professional tone - Familiarity with creating brand awareness campaigns Your work will be instrumental in helping my company's growth and exposure. Please prov...
I need a data entry specialist to compile an Excel spreadsheet database of addresses and opening times relating to approximately 400 branches of the Citizens Advice Bureau. The data will be collected from URLs that I will provide. Ideal Skills and Experience: - Proficient in data entry and Excel - Experience with web research - Attention to detail - Ability to meet tight deadlines - Previous experience with similar projects is a plus This is an urgent project and I need it completed as soon as possible. Thank you.
I'm in need of a passionate Oracle expert who can assist me in both administration and development of an Oracle database. Key responsibilities for this project include: * Database design * Query optimization * Performance tuning * Implementing a brand new database development from scratch The ideal candidate will have: * Profound knowledge and sound experience in Oracle database design and performance tuning * Excellent capabilities in optimizing database query * Strong track records of developing Oracle database from the ground up. This project is more about proficiency and less about years of experience. If you're eager and confident in your Oracle skill-set then I'd like to hear from you. Given the complex nature...
I'm looking for an expert with significant experience in setting up and configuring Amazon Web Services (AWS) Relational Database Service (RDS) for my MSSQL server. Or who can guide me to process with Google Cloud SQL. Key Details: - Database Size: The anticipated database size is medium, ranging between 10GB to 100GB. - Cloud Platform: The preferred cloud platform for this project is AWS. The project may require setting up several AWS features, however, I am unsure at the moment about the accessibility features needed. An ideal candidate for this project should be highly experienced in AWS, be capable of advising on the best setup to optimize performance, and have a strong understanding of MSSQL. Any expertise advising on high availa...
I have a website. I need to show some SQL values in AG Grid with filter functionality in admin panel.
...MERN Stack Developer to lead our development efforts. Your expertise will drive the creation of cutting-edge web applications while mentoring junior developers and contributing to technical strategy. Key Responsibilities: • Lead and participate in the architecture, design, and development of complex applications. • Mentor and guide junior developers, fostering skill development and growth. • Collaborate with cross-functional teams to define technical roadmaps and strategies. • Conduct code reviews and ensure adherence to coding standards and best practices. • Stay updated with emerging technologies and advocate for their integration. • Develop and maintain robust and scalable web applications using the MERN stack. • ...
I'm in need of a skilled SQL user who can promptly write me 2 complex SQL queries involving my transaction data. Requirements: - Familiarity with SQL - Proficient at creating complex SQL queries Involving Tables: - Api_Transaction - Api_user - Api_ipaddress I specifically require information from: - Transaction amount - Transaction date - Customer details If you are skilled at converting detailed requirements into complex SQL queries, this job is for you. Your advanced understanding of database management systems will be crucial for this task.
Hi please read the attachment and then bid Thank You
...consists of: 1- extract the information from a calendar as the one I put as an example (can be another one) 2- Download the information to excel and using chatgpt for excel modify the description of each fair so that the content is original (we will give access to the plugin for excel with enough credits and chatgpt 4). 3- by means of chatgpt for excel modify the date format 4- include a no follow link to the fair in question. 5- (very important) check that Chatgpt does not make mistakes in the description or dates (this happens very often) We will not release the milestone if we see mistakes. 5- Create a dynamic calendar for wordpress that removes the old dates and leave only the content from the date of
I'm in need of a skilled professional who can help me showcase live game data directly from an Excel spreadsheet on my WordPress website. Key Requirements: - Real-time data update: The data should be updated on the website as soon as changes are made in the Excel file. Ideal Skills: - Proficient in Excel: The freelancer should be well-versed in Excel in order to effectively parse and represent the data in a user-friendly manner. - WordPress Expertise: A solid understanding of WordPress is essential to ensure the data is displayed correctly on the website. - Experience with Real-time Data: Previous experience in displaying real-time data is a huge advantage. I don't have a specific plugi...
More details: Have you already started building the android application for Odoo 17? Yes What aspect of the android application do you need help with? Explanation of Odoo warehouse operations What specific warehouse operations functionality do you need assistance with in your Odoo application? Understanding all details of Odoo 17 Packaging and Packages PLEASE NOTE: YOU WILL NOT BE DEVELOPING ANY SOFTWARE. YOU WILL BE HELPING OUR DEVELOPERS UNDERSTAND THE PACKAGING AND PACKAGES FUNCTIONALITIES.
WHO WE ARE Want to join an amazing family owned business that’s on a mission to bring people together? If you’re a top Rep with experience who takes initiative, self-motivates and make things happen this is the job for you. We have a market filled with opportunity and are happy to offer aggressive compensation - provided you bring results. tinyB chocolate specializes in Brazilian chocolate truffles called brigadeiros. We offer chocolate-making team building activities, chocolate gifts and chocolate-filled LavaCookies. Our work has earned a 5-star rating from consumers and Fortune 500 companies alike. We often hear people say that our products are some of the best they’ve ever tried. DESCRIPTION/RESPONSIBILITIES We’re expanding int...
...developer to create a stock and options trading system implemented through an Excel sheet. This tool will execute real-time data trade operations, following a specific strategy. Ideal Skills and Experience: - Proficient in Python programming - Experience in Stock Market trading systems - Knowledge of Excel VBA and integrating with Python - Understanding of Custom Trading View Indicator strategy The work involves: - Engaging in the end-to-end development of the Excel system. - Coding a Python script to fetch and populate real-time trading data. - Implementing the Custom Trading View Indicator strategy in the Python script. - Testing the system to ensure the accuracy and efficiency of the trading. P...
I am in need of a freelancer well-acquainted with data entry for translating text data into a usable Excel spreadsheeet. Key Requirements: - Proficiency in text data entry - Experience working with a diverse range of project types - Skilled in Excel, especially formatting and data organization Your task will be to translate the original data (which could be a PDF file, printed hardcopies, handwritten notes, or a different format depending on the project) into neat, easy-to-read Excel spreadsheets. Prior experience with Excel and other similar tasks will be crucial for completing this project accurately and efficiently.
I'm in need of a professional proficient in Excel macros to assist with creating custom formulas specifically for data manipulation. The primary task would be to formulate macros that can effectively merge and separate data. Demonstrable experience in managing large datasets and solid knowledge in automated data manipulation will be essential for successful completion of the project. A background in eliminating duplications or inconsistencies would also be advantageous. I look forward to a hassle-free process and accurate results.
I Want to Select Hierarchical Data From Mysql Multiples Tables using eloquent/Query Builder both.
I am in need of a skilled freelancer with a versatile set of skills to help me with a variety of content creation and management tasks. The ideal candidate will have experience in blog writing, editing, PDF creation, PowerPoint design, Excel data management, AI integration, translation services, and gaming-related tasks. Specifically, the tasks will include: - Blog writing: The primary purpose of the content is to share information with the general public. The ideal candidate will be able to write engaging, informative blog posts that are accessible to a wide audience. - Editing: The candidate will be responsible for ensuring that all content is well-written, error-free, and adheres to the project guidelines. - PDF creation: T...
I'm seeking a professional with extensive Excel experience who can help convert data from a spreadsheet into a more user-friendly form. Here are the key elements for this project: - Autofilling: The form should make use of specific criteria for autofilling using text. Your proficiency in creating autofill functionality is crucial. - Conditional Formatting: I require a unique approach to formatting cells containing more than one line of text. Specifically, if a cell has multiple line items, they should be combined in the same cell but placed underneath each other. - File Format: The data to be converted resides in an Excel spreadsheet, therefore your familiarity with Excel is paramount. This task requires not only technical sk...
...file that was saved in 2009. The file contains important financial data which I urgently need to access. I am currently using Reckon Accounts 2013 Pro and did not keep the earlier versions of the Quicken software. Based in Australia, I have evidence that I own the company who owns the Quickbook file and the software registration details. What I don't have is knowledge of the specific password that I used for the file at the time. I have a list of 35 passwords that I was using for various tech systems around 2009. One of which is likely to open it or as a professional you may know a different way to access the data. In addition to a Reckon Accounts 2013 Pro file of the data I can use, at minimum I need from you an Microsoft ...
I am in need of an experienced data entry specialist who can assist me with entering basic data into Excel. The data to be entered will be from handwritten notes. Ideal skills and experience for the job: - Proficient in Excel for basic data entry and formatting - Detail-oriented with high accuracy in entering data - Ability to work with handwritten notes - Good communication skills to clarify data points if needed
I'm in need of someone adept in bookkeeping, expense tracking, and financial reporting. You don't have to have experience in a specific software, but being proficient in tools like QuickBooks, Excel, and Xero would be ideal. I need the Account Assistant to handle: - Bookkeeping - Expense Tracking - Financial Reporting In your proposal, please include: - Details of your past work and experience in similar roles - A detailed project proposal outlining how you'll carry out the tasks I'm excited to hear from you, and start working together on this project.
I am in search of a seasoned data analyst who will perform a comprehensive analysis on a large Excel dataset, with more than 10,000 rows. The range of tasks to be undertaken includes: - Data Cleaning: Ensuring the data quality, eliminating any errors or redundancies. - Data Visualization: Creating intuitive charts and graphs to illustrate the data trends and patterns. - Statistical Analysis: Implementing statistical methods like Regression Analysis, Time Series Analysis, and Hypothesis Testing to interpret the data and draw conclusions. This demands a great deal of experience in Excel, data cleaning, statistical analysis, as well as in working with large datasets. A solid understanding of regression analysis, time series analysis,...
I require an expert in Excel macros that can help me with a specific task. I have numerous .dl files from which I need certain sections of text extracted. Here's what I need: - Development of a reliable Excel macro that can accurately identify and extract the necessary data from .dl files. - The macro should be robust enough to handle any inconsistencies or errors within the .dl files. In the event of an issue, rather than stopping entirely or skipping the file, the macro should create a log file noting the inconsistency or error for later review. Ideal skills: - Experience in Excel macro development - Familiarity with .dl file structure - Attention to detail - Problem-solving skills, particularly regarding file inconsisten...
Hello, 1: you will create aspx webpage, and load data from mssql table to gridview with paging. 2: when user check some checkboxes, and enter value in textboxes and click on a button, it will store those values in session and save in database table. 3: when user enter some values in page 1 or anyother page and go to next page like page#2 and come back to page#1, the values he entered must show and not loss. Note: has the gridlayout. ischecked and grosspremium are editable checkbox and textbox I included the vb code as well in endorsements-vb The datasource contains 86 rows and attached as excel.
... Your job is to find a contact email address or/and online form for authors to submit a book proposal for each of the publishers on the list. Most of them have an online form. Get the www link. For each of them, get a contact email address. If there is no email address for authors, get some other general contact email address of the press. You will submit an Excel file with three columns: name of the publisher, email, www link with a form (if there is an online form). In this list I provided, for some publushers there are two names (left and right) or more than two names (one left and several right). In these cases of multiple names, you just need to do it for one name/publisher, not more. If one of the few names has a word “press&rd...
I have python script to copy title and keywords from excel sheet to image metadata , I need to add category to subject filed and price to comment filed so excel sheet will be title , keywords , category , price , data will be copied to image metadata
We have a quick project for a Google Sheets / Excel Expert We have a Google Sheet that we need to filter and match customer names up to a sales rep. Essentially it needs to work like this: - Master customer data will go in sheet 1. This contains a list of customer names in column 1, and the corresponding sales rep in column 2. - Each week, we create a new sheet with payment data. - The payment data contains the payment and customer name. - we need the filter to match the customer name in the new sheet with the rep and insert the sales rep name in a new column. This will probably need to be done with a scrip - we need a proficient and experienced person to do this. If you ha...
I'm in search for a professional well-versed in Google Sheets, specifically with the capability to execute and manipulate custom complex functions. You will be dealing with a medium sized dataset of 100-1000 rows. Key tasks include: - Implementing advanced formulas and calculations to an existing google sheet - Analyzing and providing visual representation of data in real time The ideal candidate should be proficient in data analysis, has excellent skills working with sizable datasets, and is a master of working with custom functions within Google Sheets. Your ability to interpret data and present in a user-friendly format will be essential.
I am urgently in need of an expert to assist me with a set of complex electrical circuit problems. Your task would be to: - Solve higher order ODE circuit problems - Assist with convolution problems - Tackle Laplace transfer issues The successful accomplishment of this project will result in: - Finding the transfer function - Analyzing the frequency response - Solving for the circuit variables This project requires a great understanding of electrical engineering principles, particularly, higher order ODE, convolution problems, and Laplace transfer. Proficiency in complex problem-solving under limited time conditions is an added advantage. I need this job completed ASAP. If this sounds like the kind of project that you'd excel at, please ge...
I am in need of a skilled Bookkeeper with a sound understanding of quotes, POs, and invoices. I require 2 hours of these services everyday to maintain and organize my financial records. I currently manage my accounts using Excel, so ability to work with it effectively is key. Key Tasks: - Maintain financial transactions - Manage and update financial records Ideal Skills: - Proven track record in bookkeeping - Familiarity with technology sector taxes - Proficient in Excel - Great attention to detail and accuracy. Experience working in a similar role within the technology sector would be highly beneficial. If you have the necessary skills and experience, I look forward to receiving your proposal.
I need an expert in SQL, Python, Tableau to undertake data analysis project on less than 1GB of categorical data. The main requirements of the job include: - Proficiency in Python, SQL, Jupyter, Spyder, and Tableau recommended - Strong background in data analysis, regression, and machine learning - Experience working with categorical data specifically - See for details The chosen freelancer should be able to analyze and interpret the data in a way that can drive actionable insights. While the data set is not overly large, accuracy and attention to detail are paramount. Previous experience working on similar projects is highly desirable.
...be able to import orders from a CSV file, xlsx file , track the status of each order, and update it when necessary. In addition, it should provide me with insightful inventory and order history reports, enabling us to monitor our stock levels and analyze our order trends effectively. Ideally, freelancers would have prior experience in web application development, with a particular emphasis on order and inventory management solutions. Some knowledge of CSV file manipulation and report generation would be a definite plus. Major Task which we need to accomplish with this system. 1- Upload daily order files - EXCEL/CSV. 2. Update daily orders , quanity, status (avaiable/not avaiable, when avaiable with dates) etc. 3- Genarate procurement orders ...
I'm in need of a skilled data scraper who can extract specific information from three different websites: Website A, Website B, and Website C. The data to be extracted include: - Product details - Customer reviews - Pricing information The successful candidate should have proven experience in data scraping and should be proficient in navigating different types of websites seamlessly. The final output format I require for the scraped data is Excel. Proficiency in Excel or similar data organizing tools would be needed. The ideal candidate should be meticulous in ensuring the accuracy of data and adhere strictly to the provided format without missing details. This task may require repetitive data entry, hence patience, ...
Consolidated Sales Calendar report put in excel spread sheet.
More details: Small Business Beauty Salon excel program required Inventory management: Track products in stock, Set reorder points for products, Generate purchase orders Point of Sale (POS): Cash, Credit/Debit cards, Mobile payments for Retail products [GST&PST] and services Daily Reports: Sales report, Inventory report, Employee productivity report Client management: History records or services done with client details and specification Employee management: Information; Timesheets; Vacation Payroll: Run semi-monthly payroll with hourly rate vs commission rate [Canadian payroll information] Salon supplies: Calculate and track supplies used during services to add to POS on checkout Schedule: Appointment schedule for clients with ability to send remin...
