How to write update query in excel sheet jobs
...Power BI professional to assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced knowledge of data modeling - Pr...
I'm looking for someone to integrate an existing machine learning model into a Discord bot. The bot should cater to three main functionalities - sending daily race predictions, responding to user queries about race outcomes, and providing real-time race updates. Key Requirements: - Integrate an existing machine learning model into a Discord bot - Implement a feature to send daily race predictions on a specific channel - Develop a query system that effectively responds to user queries about race outcomes - Enable the bot to provide real-time race updates Your Skills: - Proficiency in machine learning model integration with Discord bots - Experience in developing chatbots, particularly for Discord - Knowledge of horse rac...
Objective: Our company aims to automate its logistics process to improve efficiency and reduce manual workload. We are looking for a freelancer with expertise in automation to develop a system that streamlines the process from transport request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to...
...for a skilled developer to help me change the admin email without altering the username, password, or other settings. The primary reason for this change is to ensure that the contact information displayed is up-to-date. Key requirements include: - Updating the admin email: The new email address will be provided to the selected freelancer. - Maintaining username and password: It's crucial that these details remain unchanged. - Preserving other settings: The current configurations, including security measures and other account settings, should not be affected. Ideal skills and experience for this job: - Proficiency in WordPress: The ideal candidate should have a strong background in WordPress development. - Experience in working wit...
I'm in search of a talented tattoo artist who can create a unique blackwork tattoo design for me. NOTE: The design is to be based on an existing tattoo (photo is attached, must incorporate this tattoo), but expanded upon with a fresh blackwork twist. The placement is upper arm/shoulder area. The current tattoo is approx. 3 inches but I would like the new design to cover more area. The ideal candidate should be well-versed in tattoo design, particularly blackwork style. It's crucial that you've got a keen eye for incorporating sacred geometry and symbolism into your designs. Key Points: - Proficiency in blackwork tattoo style - Ability to artfully incorporate sacred geometry into the design - Understanding of creating symbolism ...
I'm seeking an expert in Google Sheets to help me create a functional document geared towards tracking paint and repair tasks, and cleaning schedules across a busy summer camp campus. This sheet will be regularly updated by our facility maintenance team. The ideal candidate should: - Have substantial experience in creating dynamic and user-friendly Google Sheets. - Understand logistics and scheduling in a maintenance setting. Key features of the Sheet should include: - A system for recording painting/repair locations. - Fields for indicating the type of paint or repair needed. - An integrated cleaning schedule that doesn't disrupt ongoing summer camp activities. - A remark section to note if the cleaning crew has cleaned, dusted ...
...FEEL FREE TO APPLY. DO NOT USE GENERIC BID TEXT (NO COPY PASTING)*** Role is perfect for motivated and learning individuals who are eager for feedback and want to grow skills. Duration is 30 days internship. Those who surpass expectations will receive a serious offer to stay on team with better compensation. Sample tasks and responsibilities include, and are NOT limited to: 1. Research key topics or areas of interest and presenting options for the next steps. -> googling 2. Executing next steps and promptly executing action items from discussions. -> take instructions and act fast 3. Propose options from research as requested -> more googling 4. Be able to advise proactively on details including step by step documents where needed -&g...
Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.
More details: What is the purpose of the astrology website? Offer astrology-related services What elements should it contain to make the content engaging for the readers? Infographics, Short on-site videos, want to give youtube Chanel videos .need a way to regularly update new videos How would you like the website to showcase the YouTube channel videos? Displaying video thumbnails with links to YouTube. want it to be seo compatible
I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.
...Error 500 issue that's occurring when users access my website. The error seems to be an 'Internal Server Error', but I'm not sure what's causing it or how to fix it. Key Tasks: - Identify the root cause of the Error 500 - Implement a solution to resolve the issue - Provide recommendations to prevent similar errors in the future Ideal Skills and Experience: - Extensive experience with WordPress - Proven ability to troubleshoot and fix Error 500 issues - Familiarity with server configurations and potential causes of Internal Server Errors - Strong problem-solving skills to identify and resolve the root cause of the issue - Good communication to explain the issue and recommended solutions in a...
More details: What is the purpose of the astrology website? Offer astrology-related services What elements should it contain to make the content engaging for the readers? Infographics, Short on-site videos, want to give youtube Chanel videos .need a way to regularly update new videos How would you like the website to showcase the YouTube channel videos? Displaying video thumbnails with links to YouTube
I'm in need of a professional who can update config which utilized ESRI's cloud builder tool on Azure. Specifically, the role requires assisting in configuring the ArcWeb server, transforming a site created in IIS to be public-facing. This includes making the site accessible from the internet with a basic level of security, such as HTTPS. Key Responsibilities: - Configure ESRI Cloud Builder tool on Azure - Make existing IIS site on ArcWeb server public-facing - Implement basic security measures (e.g., HTTPS) Required Skills and Experience: - Proficiency in ESRI/ArcGIS platform - Experience with ESRI's cloud builder tool - Familiarity with Azure cloud services - Strong knowledge of web server configurations, particularly IIS - Prio...
Create excel sheet with data for best location of new factory to optimize cost of transportation using three different methods with all data required including VBA code
...freealancer to create an mcq list for moodle quiz website in Aiken formatting. Aiken format I am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: A Sulphasalazine tablets 500mg are on hand. The dosage required is 2g. How many tablets are required? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: C So can you create options like a teacher, you don't need to know a lot about the topics. If you are wondering, It is nursing mcq (multiple choice questions). I have the questions and answers ready in a pdf. The first 428 questions are ready. Once the Question and Answer pdf is given, In the format mentioned above, just add anothe...
I'm in need of a PHP page that helps our agents to send an order. This page should be intuitive and user-friendly while ensuring all necessary information is captured. The platform should be interactive and user-friendly, ensuring a smooth order submission process for our agents. Ideal Skills: - Proficient in PHP - Strong experience in web development - Knowledge in creating secure web forms - Experience in agent-based systems would be a plus Please bid for this project if you believe you have the skills and experience needed to deliver a high-quality, efficient, and secure PHP page for our agents. Our customer sells products (not online, but in shop). He wants to receive orders from agents. I have an excel fi...
...terface for data entry We want to have multiple users to view and edit information for subscribers (names) in a database. Those users must be able to login on a web page, with a username and password. All users will see same information. But certain fields, those they will be able to edit, will be visible only to that specific user (and admin). Multiple users must be able to enter data (different) for each subscriber. User must be able to filter certain columns, search in all fields, hide/show columns. Online (on web) visible to users, will be only the fields mentioned in table visible) MS Access (local file) Administrator must be able to see and edit all after importing with an interface you will crea...
We need an experienced Magento developer to assist with updating third-party extensions when conflicts arise due to newer php/mysql versions. Timeline: Start on the first project on 20th May using remote desktop tools like UltraViewer or AnyDesk for real-time collaboration. Bidders must be highly proficient in Magento 2.4x.
...monitor a MySQL database on my Windows system. The app should be able to perform the following functions: - **Monitoring MySQL Database**: The application should constantly monitor my MySQL database and detect when a new record is created. - **WYSIWYG Template Management**: There should be a feature that allows me to manage various WYSIWYG templates. These templates would be used to generate dynamic PDFs based on the new records in the database. - **PDF Generation**: Upon detecting a new record, the application should automatically generate a PDF based on a selected WYSIWYG template. Naming convention based on filed in processing record. Option Password added to pdf. I would like the application to be user-friendly and easy to...
I'm in search of a diligent and detail-oriented individual to assist me on a part-time basis with data entry tasks mainly in the finance sector. Key Responsibilities: - Data Entry: You will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageous but not mandatory. - Strong atte...
...myself beset by an issue related to the appearance of my homepage on mobile devices. First, it appears the layout of the mobile version differs significantly from the desktop version. I'm looking for someone who can troubleshoot this and ensure consistency across both versions. Your first task will involve ensuring the same layout for both desktop and mobile versions, mirroring the successful desktop version's layout. Next, there's a glitch with the content display on my mobile homepage. It seems to be displaying content incorrectly, and I need you to rectify this. Essentially, your role here will be to fix any errors that cause incorrect content display on mobile, making sure all elements appear as they should. Lastly, there is a problem wi...
I need a skilled developer to help me create a high-quality app sheet for the education industry. The main aim of this project is to increase my online visibility and generate more leads. Key Features Required: - Primarily, the app must have quizzes and assessments. Ideal Skills and Experience: - Experience developing app sheets or similar software within the education sector. - Knowledge of incorporating interactive elements like quizzes into an app. - Strong understanding of how to optimize visibility online and generate leads. As an app developer on this project, you'll take on a pivotal role in creating a valuable educational tool. If you’re passionate about development and education, I'm eager to hear from you.
I am in need of a skilled professional who can assist me in setting up the Odoo Books system for my invoicing processes. Requirements: - Configure the system to enable the creation of goods and service invoices in USD. - Implement moderate customization to the invoice templates, focusing on layout changes and adding custom fields. - Import all of my product information from an Excel sheet. This includes product names and their respective cost prices (which are in INR). - Enable and Teach me to Use Odd's OCR feature to fetch pdf data from invoice to transfer it to software Ideal Candidate: - Proficient in working with Odoo Books and setting up invoicing processes. - Experience with customizi...
We are in search of a skilled software integrator to help me integrate my personal deployment system with an IA/Chatgpt API. This project involves building and implementing a chatbot that's capable of: - Natural language processing: The chatbot should be able to understand and interpret human language, not just in a literal sense, but also in context. - Chatbot functionality: The chatbot should have the capacity to engage in meaningful conversations with users, along with the ability to learn and adapt over time. - Question and Answers: The chatbot should be able to provide answers to frequently asked questions and find relevant answers from PDF files content. Experience and Skills: - Strong understanding of natur...
I'm experiencing an issue with my IIS 8 server. Specifically, I'm unable to reflect image updates across the server. Key Requirements: - Troubleshoot IIS : You should be experienced with IIS and capable of identifying and resolving server-related issues. - Server Configuration: The problem may be related to server settings, so a deep understanding of IIS configuration and management is desirable. - File Management: The issue seems to be related to file update. You should have expertise in managing files on Windows servers and diagnosing related issues. - Image Handling: The problem specifically pertains to image updating. You should be well-versed in how servers handle image uploads and updates. Your task will inv...
...informational website that I need to be made responsive across all devices. This means that the layout and content on the site should adjust automatically to the screen size of the device being used. Key requirements: - Ensure all elements of the site render correctly on any device. - Maintain the visual appeal and user-friendliness of the site. - Implement best practices for responsive web design. Ideal skills and experience: - Proven experience in responsive web design. - Proficiency with HTML, CSS, and JavaScript. - Understanding of cross-browser compatibility. - Strong attention to detail and design aesthetics. I need help making a website ‘Responsive’ for all devices. I last worked on this site eight years ago but I'm now 80 years ol...
I need a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new
I'm in need of an AI developer to create a sophisticated algorithm. This algorithm will assess specific symptoms related to hormonal imbalances and provide tailored recommendations accordingly. Key Features: - The AI algorithm should be able to assess the following symptoms --> FOR WOMEN : Fatigue, Weight gain/loss, Mood swings, Sweats, Menstrual irregularities, Premenstrual Problems, Acne, Libido decline, Hair loss, Hirsutism, Menstrual Migraine, and Sleep --> FOR MEN : Lowered libido, weight gain, mood changes, sweating The recommendations should be individualised and based on the symptoms identified. A sleek and intuitive user interface I'm looking for a freelancer with expertise in AI development and a proven track...
I'm looking for an expert to create a web-based CRM database aimed at efficiently storing and managing information. The data I intend to keep include: - Customer contact details - Sales history - Communication logs - Course details - Course Refresher notifications This project also requires the creation of functionalities to: - Add new contacts - Update existing contact information - Track sales performance Ideal freelancers should have substantial experience in CRM database development, with knowledge of implementing web-based solutions. Familiarity with training or course-based entities would be a bonus. Your expertise ought to allow seamless additions, updates, and performance tracking of stored information. Demonstrable success in...
...for an experienced React + developer to optimize the loading times of my web application. Key Points: - The main issue with the current site seems to be the product pages, which need to have their loading times significantly improved. - Additionally, I suspect that large images or media files, inefficient code or algorithms, and server response times are also contributing to the overall slow performance. - Moreover, I need to update application packages, currently I am using nextjs 9.2.0 and some depreciated libraries. Ideal Candidate: - Proficient in React and to be able to efficiently refactor the code and optimize the loading times. - Experience with image and media optimization, as well as knowledge of best practi...
I need to install a new WordPress template, whilst keeping all my data. The primary aim is to update the functionality of my e-commerce site. - **Data Preservation**: It's crucial that all existing data is retained during the template change. - **Functional Overhaul**: The new e-commerce theme should come with enhancements, particularly in terms of the product review system.
I am in need of an interactive affiliates page for my website that showcases sister radio stations globally. This page should have a map with icon markers pinpointing station locations, a search feature to find stations by name or zip code, and a list of station names accompanied by location information. Map should allow zoom and going to country specific. So users can see entire map of their country with locations. Ideally we want world map to show first. I want tabs where users can switch between USA or world map. This page will go onto and can be with html 5 and css and js. Key Features: - Display of Sister Radio Stations: - An interactive map should be the centerpiece of the affiliates page, showing all sister radio station locations globally. - A ...
I require a one-time data scraping project completed on multiple website...Real estate agency Qatar Commercial Real estate agency Kuwait Commercial Real estate agency Bahrain I have made a start to the spreadsheet with a template for each of the regions which can be continued to be filled in. In the Google searches, just take the first 3 pages with the main agent listings and see what agent names/ email addresses you can find. - DATA REQUIRED: The primary data needed is text content. - TIMELINE: This is a one-time task, with no ongoing scraping requirements. Skills/Experience: - Proficiency in web scraping, especially from multiple websites. - Strong ability to extract data in a structured format, with a focus on text content. - Exp...
We are developing a spreadsheet-based database of the most popular English quotations (or English translations), and are looking for a researcher with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of existi...
I came across a minor issue on my website on Digital ocean cloud server. Refer the below error information. I need someone who can fix me immediately in an hour. Error 500 PleskExceptionDatabase DB query failed: SQLSTATE[HY000] [2002] Connection refused
...skilful Android Developer or designer to give a refreshing look to my app by reskinning it. Despite having a design template picked out, some area was left untouched and those are where you'd come in: - Color Scheme Adjustment: I'm particularly attached to the existing color scheme and want it kept, but don't mind a few tweaks here and there to enhance the app's aesthetic. - Logo Redesign: Although I'm satisfied with the current template, the logo could do with a revamp. Embrace your creativity here but please bear in mind that it has to jell with the existing color scheme. - Typography Update: While remaining within the constraints of the Android platform, breath some new life into the app's typograp...
I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.
As discussed, this includes the following - 1. Automated trading functionality in excel using the TWS API 2. Customization of entry and any other rules post discussion 3. Python codes 4. Deployment support and 2-weeks support for smooth operation
I am in need of someone adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dos...
I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.
i need to get the services of a developer who understands PHP & Java to correct and update some open source software. I have access to raw code and git hub library. Programs work, but needs some adjustments to get them to operate properly. There is not a lot of parts of the the different software that needs correcting and so i would not expect it to take too long, as most of the features work fine, but there are some features that are not working in correct manner. I want to start off with one application fix. Then if work fine, we can work together to add extra features.
...your offer with the word in the attachment, otherwise we dropp you out. We are looking for a database with websites, HAVING EMBEDDED YOUTUBE Videos on their sites. Prepare a list with : Name of the company, youtube Channel, Link to the first youtube video you find on the site, PLZ, City, State, Phone, Mail, Website Niches: Construction Systems in Austria, Germany and Switzerland Phsiotherapeuts in Austria, Germany and Switzerland I would like to have at least 2000 websites with top-quality data. Delivered in 1 day. Delivery in one Excel file. Time of delivery is a key element in our decision. Offer a price for 2.000 data entries. We extend our partners for this kind of task´s. With all of them we have a longterm P...
I'm looking to extensively update the homepage of our golf course's website. Occupying a unique space in the golfing industry, we need a skilled professional who can elevate our online presence. Specifically, the tasks would involve a revamp of our site that is on jonas club management software - Revamping the visual design and page layout. This will give enhanced visual appeal and improved UX. - Integrating a video: A critical part of the new designs will be the addition of video content. Thus, proficiency in embedding and optimizing web video content is extremely crucial to this project. - Implementing an Event RSS feed: The next major addition will be an Event RSS feed. Our chosen professional should have extensive experience in wo...
NERC Holidays Insertion Directions I am creating a excel sheet for electricity pricing research. There are typical days and there are holidays for which the typical load (demand) shape gets distorted. As a preliminary step in this project, I need to identify all of the holidays that occurred from January 1, 2006 until present. The recognized holidays for the US electricity markets are called “NERC holidays,” which is the abbreviation for the North American Electric Reliability Corporation. The six recognized NERC holidays are New Year’s Day Memorial Day (last Monday in May) Independence Day (always July 4) Labor Day (first Monday in September) Thanksgiving Day (the fourth Thursday in November) Christmas Day (always Dece...
...field. As a VA, you will play a pivotal role in managing various tasks associated with our crypto-related platforms, including a YouTube channel, social media accounts, a blog, and a Telegram community. Key Responsibilities: Research and Summarization: Conduct research on new crypto products, trading companies, and product features. Summarize findings in visually appealing Excel sheets or Designs or reports for easy comprehension. Partnership Outreach: Reseacrch & Contact potential partner programs to explore collaboration opportunities. Negotiate special deals, such as free products or community discounts, or paid sponsorships. Follow up with potential partners to finalize agreements. To manage inbox and keep it up to date ...
I'm in need of a skilled freelancer to assist with some data entry work. While the specifics of the work have not been defined yet, it will likely involve entering data into a database, transcribing written documents into digital format, and/or filling out online forms. The task can involve different formats such as Excel spreadsheets, Word documents, or online platforms.
...for a Python expert to help me create a new Python script for data analysis purposes. The primary goal of the script will be to analyze a dataset that I already possess. The script should be able to handle large amounts of data efficiently, allowing for insightful analysis and visualization. The key requirements include: - Writing new code from scratch - Prior experience in data analysis using Python - Proficiency in Python libraries such as Pandas, NumPy, and Matplotlib If you have a solid background in data analysis and Python, and are able to create efficient, clean, and well-documented code, I'd like to hear from you. Here are details- I have to create a simulation that will find the optimal solution to...
I'm seeking to secure funding for a multi-industry workers' accommodation project. The accommodation caters to construction, seasonal farm, wind farm, abattoir, and gold mine workers. For this, I need a professionally crafted project proposal and a corresponding financial model in Excel. Ideal freelancers for this project should possess: - Proven experience in drafting project proposals related to housing or accommodation - In-depth knowledge in the creation of financial models using Excel - A strong understanding of multi-industry accommodations - Great analytical and strategic thinking skills - Familiarity in the Construction, Agriculture, Energy, Food Processing, and Mining Industries would be advantageous...
...Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB integration &b...
