Sql update vba excel jobs
I need an expert who can update my frontend to ensure compatibility with PHP8. The project involves updating all PHP packages and libraries. You find the frontend here
...marketing and content execution. Please ensure to track social media engagement as a key performance indicator. We are looking for candidates with mid-level experience. We are looking for entry-level candidates. The content should primarily be promotional. The company focuses on the technology sector. The primary goal for the digital marketing efforts is to increase brand awareness. Applicants should excel in content creation. Remote candidates are welcome to apply. educational products and services Expertise in social media management is highly preferred....
Clean home page: slider, attractive promotions, well-organised categories, no duplication. Footer with appropriate links, no words in English. Clean product and category pages (advanced filters, appropriate images). Optimised shopping basket and payment. Mass import of products via Excel file. ATUM confirmed for stock management. Delivery methods configured (zones and extensions). Site ready to inspire confidence and sell.
I'm seeking assistance in extracting numerical data from individual stock pages on a website and storing it in an Excel file in a specific format for multiple stocks. This needs to be done monthly. - Data Points: The data points to be extracted include various metrics like annual sales, operating profit margin (OPM), net profit, and others. - Excel Formatting: The extracted data needs to be stored in a particular format in Excel. Ideal Skills: - Proficiency in Excel - Experience with web data extraction - Attention to detail to ensure data is accurately captured and formatted. Please note, I need this to be set up for monthly updates.
I am looking for a data operator to assist with a complex data entry project. The ideal candidate should have experience in data entry from digital files, specifically using Microsoft Excel. The work involves significant formatting and clean-up of the data. Skills and experience required: - Proficiency in Microsoft Excel - Strong attention to detail - Ability to handle complex data entry tasks - Experience in formatting and cleaning up data If you are meticulous, experienced in data entry, and proficient in Microsoft Excel, please apply for this project.
Clean home page: slider, attractive promotions, well-organised categories, no duplication. Footer with appropriate links, no words in English. Clean product and category pages (advanced filters, appropriate images). Optimised shopping basket and payment. Mass import of products via Excel file. ATUM confirmed for stock management. Delivery methods configured (zones and extensions). Site ready to inspire confidence and sell.
I want a news paper app for my newspaper EidsvollPuls. The newspaper is made in ASP. NET and the database is SQL server.
I'm looking for a highly skilled tutor in Excel and KoboToolBox to teach me data collection/visualization/evaluation. Excel: - Help me improve my data analysis skills - Explain complex concepts in an easy-to-understand manner, provide practical examples, and guide me through various data analysis tasks KoboToolBox: - Creating surveys - Teach me how to collect, visualize, and evaluate data Ideal Candidate: - Strong background in data analysis, proficient in Excel, and highly experienced in using KoboToolBox for data collection. - Excellent teaching skills, patience, and the ability to adapt to my learning pace.
I need assistance with updating a Java, CSS, and HTML code to auto-fit the dimensions of a chart on a size chart page. Ideal skills and experience for the job include: - Proficiency in Java, CSS, and HTML - Experience working with charts and data visualization - Understanding of responsive design principles
I'm looking to implement a day trading strategy using an automated trading setup in Excel with the Shoonya Finvasia broker. This setup will focus on trading options. Key Requirements: - The system must be capable of automated order execution. This is crucial as it will allow for timely responses to market movements. - The system should have a backtesting feature to test trading strategies on historical data. Ideal Skills and Experience: - Proficiency in Excel and experience with creating trading systems within it. - Familiarity with day trading strategies, specifically in options trading. - Understanding of automated order execution systems and their integration within Excel. - Prior experience with the Shoonya Finvasia broker would be a significant advantage. ...
I'm in need of an Excel Macro specialist who can assist in extracting tables from multiple PDF files into Excel. Budget - 20 Max Key Requirements: - Expertise in Excel Macro development - Experience in data extraction from PDF files, particularly tables - Ability to deliver a quick turnaround Ideal Skills: - Proficient in Excel and Excel Macro - Skilled in handling and processing PDF files - Fast and reliable with a strong attention to detail. Please note, the task involves multiple PDF files, so the ability to handle bulk data and automate the process efficiently is crucial. I look forward to your bid and your proposed timeline for completion.
...Centre), Cert Cognitive Behaviour Therapy (Cairn Millar Institute), Certificate IV in Assessment and Workplace Training (Centre for Adult Education) Rapid Transformational Therapist (Marisa Peer), Cert Animal Communication (Faye Rogers, NZ) Clinical Hypnotherapist. Number of courses offered: 6 name of the course and its url along with price and Duration and lecture count. save all this to text and excel file. Ideal skills for this project include: - Web scraping - Data extraction - Proficient in Python or similar programming languages - Familiarity with Udemy platform Please ensure the tool is efficient and can handle large amounts of data. The tool should automatically run on a schedule....
I'm currently using a Selenium driver via Excel VBA to scrape a website, but I'm running into some issues that I need help fixing. The project involves a scrollable table where the link element needs to come into view before data can be extracted. Key Problems: - Extracting data from the table consistently fails. - Many elements are not found when trying to scroll the table into view. Methods Tried: - I have attempted using Execute JavaScript to scroll the table into view. I am happy to share my current code and provide access to the website so that you can see the problem first hand. I am looking for a freelancer who has experience with Selenium and Excel VBA and can help me fix this quickly.
I'm currently using a Selenium driver via Excel VBA to scrape a website, but I'm running into some issues that I need help fixing. The project involves a scrollable table where the link element needs to come into view before data can be extracted. Key Problems: - Extracting data from the table consistently fails. - Many elements are not found when trying to scroll the table into view. Methods Tried: - I have attempted using Execute JavaScript to scroll the table into view. I am happy to share my current code and provide access to the website so that you can see the problem first hand. I am looking for a freelancer who has experience with Selenium and Excel VBA and can help me fix this quickly.
I need an experienced UI/UX designer/developer to update my app's UI from PatternFly to Ant Design. The specific components that need to be updated include the Navigation Menu, Form Elements, and Dashboard Widgets. - Device Compatibility: The updated app must be optimized for Desktop, Tablet, and Mobile. - Functionality: It's crucial that all existing functionalities are maintained while the design is being updated. Ideal candidates should have: - Proven experience with both PatternFly and Ant Design - Strong understanding of responsive design principles - Excellent attention to detail to ensure all functionalities are retained.
...want to target specific job titles within various industries, focusing primarily on the technology sector. Target Job Titles: - CEO/Founder - Technology head - Instrumentation head - Quality head - Digitization manager - Methods and process excellence The primary focus of this project is on gathering phone numbers of these targeted users. However, the deliverable should also include a CSV or Excel file with validated data points such as names, job titles, company details, and contact information. Along with this, a brief report detailing the scraping methods used would be appreciated. Your proposal should include your budget and an estimated timeline for project completion. Essential skills include: - Proficiency with web scraping tools - Experience with LinkedIn and Crunchba...
I'm seeking an Excel expert proficient in creating complex formulas. The task involves working with financial data. The project is a test for a Financial Planning and Analysis (FP&A) profile, consisting of three questions. The formulas need to generate accurate financial projections.
I'm looking for a WordPress expert to address some issues and refresh my website, www.uberdesignandbuild.co.za. The site currently has broken links and pages, along with some design/layout problems primarily on the homepage, service pages, and contact page. Additionally, I need assistance replacing some of the current pictures with new ones. Skills and Experience: - Proficient in WordPress - Strong web design and troubleshooting skills - Experience with website content updates and image replacements
I'm looking for an Excel specialist who can help me compare three files containing inventory data. Specifically, I need to identify quantity discrepancies and item mismatches. Key Responsibilities: - Compare data across three Excel files - Identify quantity discrepancies and item mismatches - Create a separate summary sheet highlighting these differences Ideal Skills: - Proficiency in Excel with extensive experience in data analysis - Detail-oriented with a knack for spotting discrepancies - Ability to organize data in a clear and concise manner
I need an Excel expert to design a spreadsheet for me that includes various charts and graphs for data visualization. The project specifically requires the creation of bar charts and pie charts. Ideal Skills: - Proficiency in Microsoft Excel - Experience in designing custom Excel spreadsheets - Ability to create clear, effective data visualizations Please note, the main purpose of the Excel file has not been defined yet, hence flexibility and adaptability will be key in this project.
I'm looking for an expert in Power BI and SQL Server who can assist with data integration and transformation. Key Responsibilities: - Integrate various data sources into SQL Server - Transform and prepare data for analysis Ideal Skills: - Proficiency in Power BI and SQL Server - Experience in data integration and transformation - Strong analytical skills Please note that specific data sources and transformation tasks may be discussed further. Your ability to handle and manipulate complex datasets will be crucial for success in this project.
...preferences). 4. Admin Panel: The admin should have a secure login to the admin panel. Admin Features: View a list of all users who have signed up for membership. Filter users based on membership type, registration date, etc. View each user’s details, including form data (e.g., name, contact information). Approve or disapprove membership requests if necessary. Download or export user data to CSV/Excel for reporting purposes. See statistics about user sign-ups, including total users, active/inactive members, etc. 5. Data Security: All user data must be securely stored (preferably using encryption for sensitive data such as passwords). User passwords should be hashed and not stored in plaintext. Admin should have access to manage user data but should only view sensitive infor...
I need an experienced software developer to update my existing MDB database software and create a new desktop application. Key Requirements: - Updating existing database software: The updates would include adding new data entry forms and improving reporting features. - Developing a new desktop application: This application should be able to interact with the updated database software. Ideal Skills: - Proficiency in working with MDB files. - Strong experience in software development, particularly in creating desktop applications. - Excellent skills in enhancing database software with new functionality and features. - Ability to improve reporting features and create new data entry forms. Please provide examples of similar projects you've completed in your bid.
I'm looking for a skilled Excel Macro specialist to automate the importing of data from PDF files into my Excel spreadsheet. Fixed Pay - $20 Key Responsibilities: - Create an Excel Macro to automate data entry from PDF files into Excel. Ideal Skills and Experience: - Proven experience with Excel Macros. - Proficiency in data manipulation and automation. - Familiarity with importing data from PDF files. - Excellent problem-solving skills.
Hi Jay P., You may recall you did some work for us to create an app by coding an excel spread sheet. I am wanting to review the app, troubleshoot and update some features and want to retain your services to do so. Can you please advise if you can assist? Thanks Duncan
I'm seeking a proficient developer to create an AI agent for me. The agent's primary function will be to locate fitness-related businesses in multiple specific regions. The collected data will need to be organized into an Excel table, including details such as: - Name and website of the business - Location and contact details - Person name and job title An example of the task would be finding all personal trainers in Redcliffe, Australia, Postcode 4020. Ideal Skills and Experience: - AI and machine learning development - Data mining and web scraping - Proficient in Excel and data organization - Understanding of fitness industry would be a plus
I need help updating a CDR file. The updates primarily involve text changes, and I also need some new elements added to the layout. These new elements will include text blocks, images, and graphics/icons. Ideal candidates for this project should have: - Proficiency in CorelDRAW - Experience with CDR file editing - Strong graphic design skills - Attention to detail
I'm looking for someone to help me create a financial model in Excel focused on budgeting. The primary task will be filling in the blanks with the appropriate formulas. Ideal Skills: - Proficient in Excel - Experience in financial modeling - Knowledgeable in budgeting processes Please ensure your proposal highlights relevant experience and skills.
...WordPress developer to customize the KROWD template according to my specifications. The tasks include layout changes, color scheme adjustments, and adding new functionalities and new plugin Specific customizations include: - Layout: I need a complete redesign of the homepage, a rearrangement of the menu layout, and adjustments to the footer design. - Color: You will need to change the primary colors, update the background colors, and adjust font colors. Ideal candidates for this project should have: - Extensive experience with WordPress and the KROWD template. - A strong eye for design and color coordination. - The ability to implement new functionalities as per request. - Excellent data entry skills to populate the site post-customization. Please provide examples of previous...
I need assistance with matching two lists of brand and company names. The data is in Excel format. - The first list has 4 columns and the second list has 1 column. - The type of matching required is 'fuzzy match'. Ideal skills for this project include proficiency in Excel, experience with data analysis, and knowledge of fuzzy matching techniques. The work needs to be completed by Friday morning India time .
I'm in urgent need of a WordPress expert to create a modern and minimalist home page for my website. I also need some changes made to my logo, specifically enhancing its resolution and changing its color. Key Responsibilities: - Develop a clean, modern and minimalist home page on WordPress - Make high-resolution alterations to my logo - Change the color of the logo as specified - Implement SEO best practices to enhance website visibility - Source high-quality images that match the modern and minimalist design aesthetic Ideal Skills and Experience: - Proven experience with WordPress - Strong understanding of modern and minimalist design principles - Graphic design skills, particularly in logo modification - Ability to work quickly and efficiently to meet urgent deadlines
I'm looking for a skilled developer to transform my MS Excel files into a functional web application. Key Requirements: - The web application should be focused on data entry and form submission. - It should be compatible with desktop only. Ideal Skills: - Proficient in web application development. - Experience with data entry and form submission interfaces. - Understanding of desktop compatibility requirements.
...fully functional Android Studio project that: Opens the serial port at 115200, robustly. Implements the 3 tabs (Configure, Control, Monitor) with all required functionalities. Guides the user through the Setup Wizard with a step-by-step GUI (no raw text prompts). Supports firmware update procedures for both the main controller and sidekick. Includes at least a minimal “getting started” or “user guide.” 7. Project Timeline & Budget Timeline: Looking for a working proof-of-concept within 4-6 weeks (including firmware update features). Budget: Negotiable. Please propose a fixed price or an hourly rate with an estimate of hours needed. 8. What I Will Provide The firmware code for the main controller (and sidekick if needed), which shows: The text-ba...
My website needs updating. #1 priority is to retain current look and feel. #2 priority is to make it display correctly with various, phone sizes, ipads, and computer screen sizes. #3. update it as necessary to load faster and optimize
I'm looking for a freelancer who can download numerical data from a specific website and organize it in an Excel spreadsheet. The data is updated daily every 3 min, so this will be a regular task. Requirements: - Download and organize all available numerical data columns from the website into Excel. - This task needs to be done daily in sync with the website's updates. Ideal Skills: - Proficiency in Excel and web data extraction. - Attention to detail and ability to follow daily schedules.
I need help fixing various SQL triggers and stored procedures that have stopped executing. The issue arose unexpectedly, and I need an experienced professional to diagnose and rectify the problem efficiently.
...directory is not allowed to empty) * Business Mobile: * OTP mobile: This is to be used for OTP Authentication (you dont need to make OTP authentication this has to be define only * Telephone: If the user update his profile the unit manager and division manager should get email. Able to upload his own photo (this is not part of Active directory should not upload from there) Note: if the user update his profile it should sync to active directory as well " to update the user profile the system should talk to active directory using the creditials i will provide to you otherwise it will not update" KEEP IN MIND THIS PART 2nd pages is contain 3 icon - first icon is directory we will map the main directory where all user is connected...
My application, which tracks the learning progress of students, teachers, and parents, needs some updates and bug fixes. It is developed using basic jQuery, HTML, and Apache Cordova. The updates are required in the following areas: - Student Progress Tracking: This part of the application needs UI enhancements and bug fixes. - Teacher Management: UI enhancements and bug fixes are also required in this section. - Parent Communication: This area also needs updates. Ideal candidates for this project should have extensive experience with jQuery, HTML, and Apache Cordova. You should also have a keen eye for UI improvements and a knack for identifying and fixing bugs. Prior experience with educational applications would be a plus.
I'm looking for a professional Excel macro developer who can help me create a macro that extracts specific information from one Excel file and organizes it into another new Excel file. Key Requirements: - The Macro should be able to extract specific information from Sample A and make it into an organized Excel file exactly like Sample B. - NOTE: Sample A will have Comments on what specific information will be extracted and become Sample B. Hover over them to view the comments - NOTE 2: If some of the information in Sample A is Blank, then leave them blank for Sample B Ideal Skills: - Proficient in Excel, especially in creating and implementing macros. - Experience with data organization and manipulation in Excel. - Strong attention to detai...
I'm looking for a skilled software developer to create a program for an automated food vending machine. The program should include: - Online payment system: Specifically, the integration of credit/debit card options. - Real-time stock tracking: The program should be able to monitor and report the stock levels in real time. - Failure/Update Notifications: The system should be able to send notifications for machine failures or required updates. The ideal freelancer for this project should have experience in programming for vending machines, knowledge of online payment integration and stock tracking systems. Skills in creating alert systems for machine status would also be beneficial.
The objective of this project is to produce an instructional video utilizing Kali Linux to transmit an observer file to a WhatsApp number. This endeavor is intended solely for educational purposes. The following requirements must be met: 1. Kali Linux must be accessed via Oracle Virtual Machine. 2. The video should detail the process of creating the file in formats such as PDF, JPG, Excel, Word, or even video or audio files. 3. The file must be recognized as safe by WhatsApp and Android security measures. 4. The file should enable the sender to view the gallery photos and camera of the WhatsApp Android device. 5. The file must not contain any malicious algorithms. To receive payment, you must demonstrate that you have successfully completed the aforementioned steps. 1. The...
I'm looking for an experienced SQL database specialist to help me design a robust database for my e-commerce platform. Key Responsibilities: - Design a comprehensive SQL database tailored for e-commerce. - Ensure the database can handle high traffic and large volumes of data. Ideal Skills and Experience: - Proven experience in SQL database design, particularly for e-commerce. - Strong understanding of e-commerce data requirements. - Ability to create scalable and efficient database systems.
...Key Responsibilities: - Optimizing listings for T-shirt designs, including title, brand, bullet 1, bullet 2, and description. -This is Results based. Rank first page get paid. Will pay $3-5 per first page ranking - Conducting a FREE test listing to determine if you can rank on first page (And can do what you say you can). You will provide title, brand, bullet 1, bullet 2, and description. I will update listing link so we can both watch and follow. If it ranks then we can begin and I will send you batches of listings to optimize on an ongoing basis -Will determine if you know what you are doing with Merch on demand for Amazon tshirts (not products, not FBA, not store front which are different) The ideal candidate will have a deep understanding of the Amazon A10 algorithm and can...
I'm looking for a data vendor who can provide a list of homeowners in Los Angeles, California, who have expressed interest in home improvement within the last two weeks. The list should include: - Name and contact details - Property details - Type of home improvement needed - List phone numbers for quick contact. Please deliver the list in an Excel spreadsheet. Ideal candidates for this project should have experience in data collection and analysis. They should be able to provide accurate, up-to-date information in a timely manner. Knowledge of the home improvement sector would be a plus.
Set up to run 300 emails a day Create 14 emails Set up 14 day auto responder Provide and create campaign from ideal client worksheet Setup Google Analytics based on having access to being able to update the website with google information Provide reporting Predicated on fact finding worksheet data 2 hour consultation via phone Provide emails and contact list of leads based on ideal client worksheet Make sure campaign is running and sending Monitor with reporting and consult times
I'm looking for a skilled Power BI professional who can create multiple operational reports. The data primarily comes from Excel spreadsheets and will be processed through Power BI. Your proficiency in Excel is crucial. Key Responsibilities: - Create operational reports in Power BI - Utilize Excel spreadsheets and Power BI as primary data sources Preferred Skills: - Mastery in Excel - Expertise in Power BI - Experience in creating operational reports Ideal Candidate: - Able to create visualizations such as bar charts and graphs, pie charts and doughnut charts, and heatmaps.
I'm seeking a proficient SQL developer with extensive experience in Sage X3 ERP. The task is to craft a query that compiles an Inventory Valuation by Date across multiple warehouses. The valuation method is FIFO. Key Requirements: - Expert in SQL with a focus on writing complex queries within Sage X3. - Deep understanding of Sage X3's data structure, particularly inventory and valuation data. - Ability to retrieve accurate inventory valuation details broken down by date. - Skill in referencing the correct tables and fields, and applying all necessary joins and conditions. The query should accurately reflect FIFO inventory valuation across multiple locations. Experience with this ERP system is crucial for success in this role.
Need Freelancer for development of excel spreadsheet tool for financial projections, scenario analysis and presentation materials for same. Spreadsheet function is to calculate cash position and standard EBIT/EBITDA information from 2023 to 2040 (pre-revenue through profitability) for a (renewable energy) technology development and licensing company: not manufacturer, not a software developer, nor SAS provider. The basic financial structure includes simple operating cost structure, project-based revenues, non-operating income, minimal capex and equity infusion. Project Revenue Types are: • License payments based on milestones related to tangible progress for design, construction and commissioning of commercial and annual annuities (royalties) based on plant capacity (or ...
...in-game item store for players to purchase skins. Design & Inspiration The website should be clean, responsive, and professional while embodying Rust’s survival aesthetic. Developers can reference the Vital Rust Store for inspiration. Technical Requirements Frontend: Modern, responsive UI (React, Vue, or similar preferred). Backend: Secure and scalable (Node.js, Python, PHP, etc.). Database: SQL or NoSQL depending on scalability needs. Authentication: Steam API for player logins. Payment Processing: Stripe, PayPal, or equivalent. Proposal Requirements Interested developers should submit: A portfolio of relevant projects. A breakdown of technologies they plan to use. Estimated time for completion. Cost estimate and payment structure....