Excel vba sql update statement jobs
...feature is reliable and accurately reflects the status of the shipments - Offering suggestions on how to maximize customer satisfaction through the tracking feature ***Above is the general jargon Freelancer created. I want to know you've read the following so please start any responses with WOOWOO as the first words. What I need is the simple API that I can use within other PHP code that will update a woocommerce site with a tracking number/service/url for an order. That's all. I have the key and secret strings but I assume you don't need those as you would have already done thi before and pretty much know exactly what I need. I will be inserting this code within PHP where by I will pass over the necessary variables. This updated tracking number will in turn trigg...
Hi Rajesh, apologies for not releasing the last milestone. I'm email addressed has changed and I hadn't update on freelancer. Could you deep etch these two file
The website is designed primarily to serve as an informative platform about our services and broadcasting experience in the Free To Air sector. Information that needs to be conveyed on the website: 1. Detailed overview of the services we offer, outlining how we excel in the market. 2. Showcase our extensive experience in the field, driving confidence in our capabilities. The site will be mainly aimed towards potential clients and Free To Air broadcasters who are looking for reliable broadcast service providers. Ideal freelancers for this job should have proficiency in web design with experience developing informational websites for service-based businesses. Understanding of the broadcasting or related sector would be an advantageous, but not necessary.
I have full code flutter app I want using firebase database 1 -Experience https://console.agora. video and call streaming Also 2- Update app to stores Apple store Android store
I need a skilled Wordpress expert to address a migration i...the migration from a server running PHP 7.2.4 where the site worked to a server running PHP 8.2. The front end of the site works but now access to the back end gives the error "There has been a critical error on this website. Learn more about troubleshooting WordPress." I need someone to correct the code so that it works correctly. I believe that the issue may be connected to WPBakery To excel in this project, you should be highly experienced in Wordpress, with a deep understanding of PHP, theme and plugin compatibility issues. Your ability to troubleshoot and resolve migration issues will be crucial. I'm looking for a professional who can efficiently tackle this issue and ensure a smooth, seamless t...
...suggest appropriate controls from different cybersecurity frameworks (e.g., CIS18, NIST) to mitigate these risks. Users can document and store test results and procedures to verify the effectiveness of the controls. Application-Specific Risks and Controls: Provide risks, controls, and tests tailored to specific applications and regulations. Backend Portal: Admins will use a backend portal to update risks, controls, test instructions, procedures, and associated applications and regulations. The portal will include features for mapping across different regulations. Scalability: The application should be designed to handle multiple tenants, ensuring data isolation and security for each tenant. Responsive Design: The front-end should be user-friendly and responsive, working seaml...
Create CAD drawings from PDF scan and update bathroom and kitchen drawings afterwards.
I'm in need...tasks. This may include various forms of data manipulation, collection, and input. - Email Management: You'll be responsible for managing my email inbox. This includes reading, responding, and flagging important messages for my attention. - Appointment Scheduling: The role will also involve coordinating my schedule and setting up appointments. To excel in this role, you should have experience with: - Microsoft Office Suite, including Word, Excel, and PowerPoint. - CRM Software: Knowledge of Customer Relationship Management software will be a huge advantage. I'm looking for someone who can be available on an on-call basis for this role, as tasks may come up sporadically. Your punctuality, attention to detail and excellent communication skill...
...…otherwise it must be exported from. physician profile (as noted below) to a new QR code created by this process • Instantcard will send out cards to USA healthcare registrants. • Healthcare providers’ card outside the USA will be sent to Dr. David P Kalin, IBMS, POB 2396 Oldsmar, FL 34677 • The IBMS International Medial License expires in 3 years from date of issue so a mechanism to update credentials and apply for renewal of IBMS International medical license should start approximately 4 months prior to expiration and this will have to be updated on the healthcare providers profile. • THE ULTIMATE SOLUTION IS AN AUTOMATED SYSTEM TO DEVELOP AND PREPARE THE IBMS IML FOR MAILING, RENEWAL • QUALITY CONTROL - The final completion will be revie...
I'm in need of an experienced presentation designer who can help me update the slide layout of my current presentation. Ideal candidates should: - Have a strong eye for design and detail - Be proficient in PowerPoint or a similar software - Have experience in creating professional and clean slide layouts Key Responsibilities: - Reformat the current slides to a new, professional and clean layout - Ensure that the new layout is consistent throughout the presentation - Provide suggestions for further improvements that can enhance the overall presentation The ideal freelancer will be able to take my existing content and breathe new life into it through their design skills. I am looking for someone who can deliver high-quality work in a timely manner.
I'm seeking a skilled and versatile bookkeeper to manage my accounts in QuickBooks. Key Responsibilities Include: - Daily entry of transactions - Financial statement preparation - Tax planning and filing Ideal Qualifications: - Proficiency in QuickBooks - Experience in managing both accounts payable and receivable - Strong understanding of tax planning - Excellent attention to detail - Previous experience working with a diverse range of transactions I value clear communication and a proactive approach to managing my finances. The role may be expanded in the future if the right candidate demonstrates a keen eye for financial strategy.
Main task: The DFG team currently has a large backlog of cases, both children and adult, that needs to be dealt and processed promptly and efficiently. We will be undertaking a process review to enable us to achieve eliminating the backlog. What suggestion would you have to update the process, the service, ensure HBC compliance, and ultimately customer satisfaction I've got a comprehensive pdf presentation on health and wellness and my goal is to transform it into an impressive, high-quality presentation suitable for a corporate setting. Key Points: - I need a professional, polished style, similar to what would be expected in a boardroom presentation. - The presentation is targeted towards executives, so it needs to be visually engaging and informative. - It's crucial ...
I need assistance to effectively integrate a post form into my project...assistance to effectively integrate a post form into my project. The form should be skillfully designed to send data to a MySQL database, and to handle CRUD operations. Key Requirements: - Collaborate with me to understand the form's workflow and user interaction. - Skillfully implement the form to effectively send user data to a MySQL database. - Ensure the form is able to perform Create, Read, Update and Delete operations, where necessary. Ideal Skills: - Proficiency in form implementation. - Strong experience with MySQL databases. - Good understanding of web project workflows. Your bid should demonstrate your understanding of the requirements and provide a clear strategy for how you intend to approac...
I have full code flutter app I want using firebase database 1 -Experience https://console.agora. video and call streaming Also 2- Update app to stores Apple store Android store
I'm looking for a freelancer who can take the annual billing data from my personal business and create a professional, neat invoice from it. ...Some knowledge of these areas will be beneficial for understanding the context and importance of the data being presented. Please note that I don't need any interactive elements such as clickable links or formulas. The main focus here is on turning the raw billing data into a clear, professional invoice. You're going to take a simple excel file with customer data and account numbers and create an easy to understand, simple annual billing invoice/income statement with my company logo on it. Account numbers will be redacted except for a unique 4 digit code at the end. There won't be endless re-writes. I'll be...
Needing a semi-annual price update on our extensive sewing thread inventory, which surpasses 200 different colors and types. This project requires keen attention to detail and strong organization skills to accurately track prices. Ideal Skills: - Strong numeracy and detail-orientated abilities. - Prior inventory and pricing experience in the textile industry is preferred. - An understanding of the variety and pricing of sewing threads.
...like three different testimonial images: Anglo (white), Latino, and African-American. We will use different images based on the zip codes and the prominent ethnicity in the area. Our business is data-driven so we can target our customers based on problems we know they're facing and have solutions for them. In the Example 1 card, you can see where it says "We can help with: <STATEMENT 1>, <STATEMENT 2>, <STATEMENT 13>. Please see the Targeted Messages image to see some of the variable data that will be placed in this section. We really like the look of Example 2 and would like to combine our messaging with their overall theme. You can see our efforts to do so in Example 1 image and Example 1 Edits draft. We will use their name &l...
...program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mo...
I am seeking a vibrant, innovative brand strategist for a budding brand. The ideal candidate will understand how to speak to professionals in the 25-40 range successfully, recognizing their needs, tastes, and aspirations. Tasks: - Development of a brand strategy from scratch encompassing all key factors: the vision, mission, personality and the positioning statement. - In-depth competitive analysis to understand stand-out strategies in the current market. - Collaborative creation of a novel, targeted marketing plan. The suitable candidate should have: - Able track record of successful brand creation from zero. - Proficient understanding of marketing towards a professional demographic. - Sound knowledge of competitive analysis techniques.
...suppliers. • Miscellaneous Documents: Space to store and manage other project-related documents. 2. Year-To-Date (YTD) Tracker This module focuses on providing a comprehensive overview of the company's profit and loss by incorporating all projects and back-office expenses. Features: • Consolidated P/L Dashboard: Aggregates data from all projects and expenses to display a real-time profit and loss statement. • Expense Tracking: Management of back-office expenses including rent, insurance, advertising, and labor costs. • Financial Reports: Generation of detailed reports like balance sheets, income statements, and cash flow statements. • Budget Management: Tools to set budgets, compare actual spending, and forecast future expenses. 3. Employee/Subcon...
I'm urgently seeking an experienced freelancer to help me update my Joomla template and modules. Your responsibilities will include: 1. **Color Scheme Revamp:** The updated design should reflect the specific designs I've prepared. Expertise in creating an exact match is crucial. 2. **Adding New Functions:** Some new functions to improve my website's interactivity and user-experience need to be introduced. Having prior experience delivering such features will be advantageous. 3. **Styling Update:** I also require modifications and tweaks to the existing Joomla components and modules. Your skills should include Joomla templating and module modifications. The timely completion of this project is essential as I'm looking to implement these changes urgently...
I'm currently in need of an experienced WordPress developer to help me update my site. The key aspects of this project include: - **Content/Images**: I need assistance updating the content and images on my site. This will include both adding new content and updating existing information. - **Functionality/Plugins**: I'm also looking to update the functionality of my site. There are several plugins that need updating and some new ones that need to be integrated. - **Editor Error**: Recently, I've been encountering an error on the content editor. This is preventing me from making the necessary changes to my site. It's crucial that the freelancer be able to identify and fix this issue, so I can continue to update my site as needed. While I have...
I am looking for a professional who can effectively utilize d3.js to create a custom bar chart that shows growing indebtedness after a series of catastrophes. The data to be ...years. Required Skills: - Proficiency in JavaScript and d3.js - Experience in data visualization - Ability to organize and clean the data for the chart Project Goals: - Develop a d3.js bar chart displaying income and debt balance over time - Ensure the chart maintains both readability and aesthetics, as well as the custom hover over explanations that need to go along with it - Functionality to update chart with new data for future years Please apply if you are an expert with d3.js and have previous experience in illustrated data with this tool. Your prior experience in sales-type data visualization will ...
I need a skilled WordPress developer for updating my website's content and optimizing its loading speed. Here are the tasks at hand: - Adding new pages to the existing site. - Ensuring highly responsive and fast page loading times across the website. The ideal candidate has a solid background in WordPress, page speed optimization, and can deliver in a timely manner. Familiarity with SEO best practices would also be beneficial. I look forward to receiving your bids.
I'm looking for a skilled developer to create a custom script for Jira Cloud. The script should modify the behavior of a select field within the platform. Key Features: - Dynamic Select Field: The select field should dynamically change based on the values chosen by other issues in the project. This means that as the field is selected, it should update to exclude values already in use by other issues. - Hide Values Already In Use: The script should ensure that the select field does not present options that have already been selected by other issues in the project. - Customize Form Behavior: The script should also allow for custom form behavior in Jira Cloud. This project requires a developer with experience in Jira Cloud and strong skills in Groovy, the required programming l...
I need to change the way my web site updates schedules for tv channels. Right now my site scrapes external sites and pickle dumps and returns data to the site. I want a json or csv to upload to updates all channels manually or we can use my admin to update with file.
...scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting data into Excel is a m...
Data Specialist: The Data Specialist is responsible for providing information that is in databases, organizing and assembling the information so that teams can make decisions using data. Responsabilities: > Access database. > Create dashboards and analysis according to the demand of the business areas. > Update and automate dashboards that need frequent updating. > Provide suggestions of improvements in business areas. Requirements: > Mandarim is a must > SQL > Office Package > Database usage At Shein, we believe that diversity is the force that drives innovation. We are committed to creating an environment where all voices are heard, valued and respected. All our vacancies are inclusive for people with disabilities, women, black people, LG...
Multi-scenarios Custom Sales Commissions Excel Spreadsheets Dashboards. Develop a bespoke Microsoft Excel spreadsheet to accurately calculate sales commissions. The specifics: - The variables: the spreadsheet to take into account the Sales Volume, the Profit, and the Commission Percentage while computing sales commissions. - Calculation specifics: Commission should be determined accurately according to custom formulas (using the previous variables) that considers the Commission Percentage. - Data input: The spreadsheet will be easy to use, allowing to manually input the data for calculation. This tool (Multi-scenarios Custom Sales Commissions Excel Spreadsheets Dashboards) will enhance efficient determination of commissions, hence accuracy and precision are paramo...
Seeking a tech-savvy professional to establish an automated system leveraging ChatGPT and Make Automation. The aim is to: - Automatically extract specific information from a variety of documents including Word, PDF files, Excel Spreadsheets, and Scanned documents - Thoroughly analyze extracted content including text, tables, charts, and images for compliance and precision - Automatically generate comprehensive reports based on extracted information for easy reference For this task, proficiencies in AI, Machine Learning, ChatGPT, and automation are necessary. Likewise, experience in OCR technology for processing scanned documents will be valuable. Not only should the candidate be detail-oriented - they should also be adept at debugging and ensuring the system seamlessly integrates...
a) investment cost analysis ) b) p&l c) Revenue analysis and d) Analysis of operating expenses
1) investment cost analysis (fixed) b) p&l c) Revenue analysis (3 years minimum) d) Analysis of operating expenses
I have full code flutter app I want using firebase database 1 -Experience https://console.agora. video and call streaming Also 2- Update app to stores Apple store Android store
...Panel Features: Ability to activate or deactivate chatbots Update chatbots with new responses or features Manage clients and their chatbots effectively Display statistics about chatbots usage Provide access to chatbots' configurations Include a client database with their contact information The system should enable me to sell, update, and manage chatbots with ease. On the flip side, my clients should be able to access their chatbots through a login and utilize them effectively in both English and Spanish. Additionally, it is essential that the chatbot can integrate and be used on social media platforms like Facebook, Instagram, or WhatsApp. It should be easily configurable for clients and capable of pulling data from databases, Excel, or Google Sheets. Ideal c...
I need a skilled professional who's an expert in Azure Data Factory (ADF) development, SQL, Power BI, and ADF monitoring. Key Tasks: - Creating data pipelines - Building data transformation workflows - Integrating with SQL databases Power BI Usage: - Visualizing data through interactive dashboards - Creating data reports and analytics - Real-time monitoring and alerts ADF Monitoring: - Tracking data pipeline performance - Monitoring data integration processes - Setting up alerts and notifications for job failures. Ideal Skills and Experience: - Expertise in Azure Data Factory (ADF) development - Proficiency in SQL, Power BI, and data visualization - Strong background in monitoring ADF performance - Experience setting up real-time alerts and notifications - Pr...
Hello, I need someone to update a logo with a TM icon and change the tagline to “Auto Implicación-Extrema” Logo file is attached
To woRk collectivialey to create with leadership an engaged and positive work enviroment lour peers innovation | research understand stewards budget communcatioN scheduling & planning Provide a positive an work experienflanning. events, acuare Uncationg, tenteR recognition a astargning opportunity,
I'm seeking an independent ASP.NET developer based in India with at least 5 years of experience, strong C# programming skills, and familiarity with SQL Server and Asp.net core. Your English skills will be crucial as direct communication with me is required. Key Responsibilities: - Develop a robust business management system leveraging ASP.NET - Implement user authentication and authorization features - Integrate appropriate APIs to enhance system functionality Ideal Candidate: - Minimum 5 years experience in ASP.NET development - Proficient in C# programming and SQL Server - Familiarity with Asp.net core - Experience in developing business management systems preferred - Strong communication skills for client call Please note that this project is only open to Indian-ba...
I am in need of an expert who can assist me with the customization and setup of Microsoft Office applications. Key responsibilities: - Ass...applications. Key responsibilities: - Assessing my requirements and suggesting the best ways to customize the Microsoft Office software. - Configuring the settings and options of the software to meet my specific needs. - Providing step-by-step guidance to help me understand and use the customized features efficiently. Ideal Skills and Experience: - Proficient in Microsoft Office Suite (Word, Excel, Outlook). - Experience in customizing and setting up Microsoft Office applications for various purposes. - Excellent communication skills to explain technical information in a clear and understandable manner. Your assistance would be greatly ap...
I'm currently facing a critical error on my Wordpress site, , immediately following an update the WordPress. I don't have the time to resolve this myself as I'm traveling. so I'm looking for someone to assist me in fixing this issue. It should be a quick fix. I'm looking for someone who can jump in quickly and complete this task promptly. Thank you.
I require a clean and professional logo for my project management consulting business, Let’s Sort This Out, LLC. There isn't any specific imagery I am tried to, perhaps incorporate a pen, clipboard or excel style doc - I am 100% open to creative suggestions! Ideal designers will be experienced in corporate branding and able to present a portfolio of similar work.
I'm in a rush and need a skilled designe...detailed design phase. I need you to take concepts and transform them into detailed plans, elevations, and sections. There's a deadline to be mindful of, as the completion is needed as soon as possible. Key responsibilities include: - Translating architectural concepts into detailed designs - Creating detailed plans, elevations, and sections - Ensuring the design meets all necessary standards To excel in this project, you should have: - Proficiency in AutoCAD and 3D Max - A deep understanding of architectural design principles - Experience in detailed architectural design - The ability to work efficiently under pressure and meet tight deadlines If you're confident in your skills and can deliver high-quality work quickly, I...
I need an Android or PC based application for creating quotations, generating invoices, and tax receipts. It should support offline functionality, with essential features available without an internet connection. Key Features: - Creating Quotations: The app should allow users to create comprehensive and customizable quotations, including options to choose profile, colour, glass, mosquito netting, etc. - Generating Invoices: Users should be able to conveniently generate invoices based on the created quotations. - Generating Tax Receipts: The app should also support the generation of tax receipts. Additional Requirements: - Save as PDF: The ability to save these documents in a PDF format is essential. - Customer Data: The app should maintain a database of customer information. - Edit Old ...
Small update to the android app. Change the payment gateway "cryptomus" to stripe. After that. Compile the code to obtain the apk version and an .aab version that will be used in the Google Play Store. In turn, upload the updated code to the app server. Send me the updated source code as well. The app is made on react Native, and the backend is Python. All the API's are made on Python. This may require modification in FrontEnd. in that case. You must be able to complete the project. Maximum budget $300
Since the error message isn't displaying after Yoast SEO plugin update, the verification process is incomplete. I'm looking for a freelancer with the right skills to assist me in resolving this issue. Key Requirements: - Diagnose the source of the issue: Identify why the error message isn't displaying, even after the update. - Resolve the issue: Implement a solution that will allow for successful verification with Google Search Console. - Test and validate: Ensure the verification process is successful and that the error message is correctly displaying. Ideal Candidate: - Experience with Yoast SEO plugin: Proven track record of working with Yoast SEO and fixing similar issues. - Proficient in Google Search Console: Understanding of how Google Search Console w...
I'm seeking an experienced freelancer to clean up and modernize a collection of PDF forms, exceeding 10 in total. The project will encompass a full design update to create a sleek and contemporary aesthetic, as well as the addition of new fields and removal of unnecessary ones for a streamlined user experience. Moreover, the forms should be made fillable and consistent across all versions. Including dropdown boxes and such interactive elements is a must, making ease-of-use a priority. Proficiency in Adobe Acrobat Pro or similar software, coupled with a keen eye for design, will be ideal for the successful execution of this project. A couple examples of our current forms are attached for reference as well.
...will grow accordingly. Responsibilities: - Send 75 personalized email outreach messages each day using pre-created templates. - Perform various tasks on LinkedIn to prospect and connect with potential clients. - Manage message sequences to engage with prospects and schedule consultation calls. - Maintain and build a database of email contacts and interaction details. - Check in with me daily to update on progress and ask for additional tasks. - Provide daily updates on tasks completed and check out before logging off. **Requirements:** - Previous experience with email outreach and LinkedIn prospecting preferred. - Excellent written communication skills and attention to detail. - Ability to work independently and meet daily outreach targets. - Reliable internet connection and av...
I'm in need of a skilled professional who can scrape data from Google. The project requires the extraction of names and email addresses for specific profiles to be used...professional who can scrape data from Google. The project requires the extraction of names and email addresses for specific profiles to be used as a potential leads database. Upon successful extraction, the data needs to be presented in an Excel spreadsheet, CSV, etc. Ideal Skills and Experience: - Proven experience in data extraction from websites - Proficiency in Excel - Strong attention to detail and accuracy - Experience in extracting usernames and emails is a plus Deliverables: - The extracted Data - The data must be clean, organized, and formatted in an Excel spreadsheet I look forward...
... The role may also involve programming. Key points: - Coaching: I need 1/1 coaching via Teams on Data Analysis & Data Visualization within Azure Analytics - Programming: If the opportunity arises, the candidate could get involved in programming using SQL - Proficiency: I consider myself at an Intermediate level with Azure Analytics Ideal Skills and Experience: - Proficient in Azure Analytics: You should have a strong understanding of Azure Analytics, specifically in Data Analysis and Data Visualization - SQL Programming: Experience with SQL is a must as you may be involved in programming for this project - Teaching or Coaching Experience: Prior experience in teaching or coaching Azure Analytics would be advantageous - Strong Communication: The ability to clear...
