Excel vba sql based column value jobs
I have a detailed list on an Excel sheet that I need converted into an organizational chart. The chart needs to include information like 'Grade', 'Nationality' and 'Occupation' and display them in a visually appealing format. Key Requirements: - Convert an Excel sheet which consists of approximately 140 line items into an organizational chart. - Display the following information in the chart: 'Grade', 'Nationality' and 'Occupation'. - Create visual lines connecting positions to indicate the reporting relationships. - Provide the final output in both PowerPoint and Visio formats. Customization: I am looking for a moderate level of customization in the design of the organizational chart. This includes playing wit...
I'm currently looking for a specialist in selling NFTs on the Ethereum network, specifically in the field of art. The NFTs are alrea...blockchain - A strong understanding of the digital art market and a solid network of potential buyers - Excellent marketing and promotional skills - Strong communication skills to facilitate negotiations with potential buyers Key responsibilities include: - Developing and implementing effective marketing strategies to sell the existing NFT artwork - Engaging with potential buyers and promoting the value of the NFTs - Managing the entire sales process from initial contact to final transaction - Maintaining accurate records of all sales and ensuring timely delivery of purchased NFTs If you have the required experience and skills, I'd be ke...
I'm seeking a skilled individual to a... The spreadsheet will be primarily used for inputting income and expenses and should be updated on a monthly basis. Key requirements: - Design and development of a custom cash flow spreadsheet - Implement budget tracking, expense categorization, and cash flow projections - Ensure ease of use and understandability for monthly updates Ideal Skills: - Proficiency in spreadsheet software (e.g., Excel, Google Sheets) - Experience in creating budget tracking and cash flow projection tools - Strong understanding of financial data and analysis I'm looking for someone who can deliver a high-quality, user-friendly spreadsheet that meets these requirements. If you have relevant experience and think you're a good fit for this project, I...
I am in need of a cloud-based POS system tailored for a small restaurant with 10-20 tables. This system should account for a variety of functionalities, including table reservation, table management, staff management, discounts, and salary tracking. Key Features: - Cloud-Based: The system must operate on a cloud platform for easy access and management. - Table Reservation: The POS system should include a feature for customers to reserve tables ahead of time. - Staff Management: It should allow tracking of staff activities, including salary calculations. - Discounts: The system should support discount application as needed. Additional Requirements: - Inventory Management: While not listed in the initial requirements, an inventory management feature would be highly beneficial...
I require a freelancer to assist with a one-time copy typing project. The task involves entering data from a single document into an Excel spreadsheet. Ideal Skills and Experience: - Proficient in copy typing - Proficient in Excel - Attention to detail and accuracy - Previous experience in similar projects is a plus.
The program must be compatible with Windows 10, which searches for data inserted from a CVS file, therefore which has the possibility of loading a CVS file (one or more files) which, through a search window, tells me whether a certain value (alphanumeric) is present in the CVS file. If you have uploaded more than one, please tell me which one it belongs to. I already have the initial screenshot to show when starting the software and the one of the search window that I will provide, upon acceptance I will also provide a flowchart that explains in detail.
... This document outlines the requirements for a supply chain software application designed to optimize inventory management, automate distribution to branches, and classify products based on demand. 2. Business Needs Reduce inventory carrying costs: By optimizing stock levels based on demand and product value (Pareto analysis), the software will minimize unnecessary inventory holding. Improve stock availability: Ensure branches have sufficient stock to meet customer demand, reducing stockouts and lost sales. Increase efficiency in distribution: Automate order generation and shipment processes to branches based on real-time demand data. Enhance data-driven decision making: Provide insights into product classifications (A, B, C) and demand patterns to inform s...
I'm looking for an experienced freelancer to assist in crafting compelling proposals for my translation services business. The goal is to create proposals that effectively communicate my services' value to potential clients and help secure new contracts. - Expertise in professional business writing - Experience in the translation industry preferred - Strong persuasive and marketing skills to highlight unique selling points - Ability to tailor proposals to various client needs and industries - Proficiency in creating well-structured, clear, and concise proposals - Familiarity with proposal submission processes and requirements The ideal candidate will have a proven track record of successful proposal writing and a deep understanding of how to position translation services...
ADMIN ASSISTANT Required - Bookings - Email and Messenger correspondence - Online Advertising on Facebook Marketplace and Gumtree - Search online information - Excel Spreadsheets - Bookkeeping - Office work Job is full time Monday to Friday Thankyou
I'm in need of a Excel setup algo that can execute orders on Zerodha from excel file. I require the following features: - One click button: The system should be able to place and execute my selected orders from excel with one click button. - Customizable Order Parameters: I need to be able to set my own order parameters, including the stock, quantity, price, and other variables. The ideal freelancer for this project should have experience in: - Developing python algo application with excel. - Integrating with Zerodha API. - Implementing automated trading systems. - Creating user-friendly interfaces, with some level of custom design.
Velocity alert analysis and provide actionable insights. Key requirements include: - Proficient in analyzing velocity alerts using SQL or SPL or Python - Capable of translating data from a word file into actionable insights - Experienced in the field of identity analytics, risk engine, authentication channel for the digital banking platforms - Understanding of Account Takeover (ATO) or digital identity compromise - Leverage known data as it relates to the digital customer identity and risk decisioning. - Analyze data logs from customer authentication channels and digital banking applications for malicious use and bad actors. - Create long-term solutions and automation to processes that can be improved when digital member identity is being utilized. Refer to attached document for b...
I need a proficient PHP developer to integrate a WhatsApp module into our existing web-based restaurant management software. Key Responsibilities: - Configuring the module to scan each customer's WhatsApp - Facilitating media message sending - also see status of failed and successful report Ideal Skills: - Excellent knowledge of PHP - Experience with Web-based systems - Familiarity with APIs especially WhatsApp - Previous work on Restaurant Management Software would be an added advantage In conclusion, the main objective is to enhance communication with our customers by leveraging the popular WhatsApp platform. We believe that this functional addition to our software will significantly improve our customer service engagements.
I'm in need of an SEO expert who can help my Dubai-based travel business that primarily offers tour packages to families. Key Requirements: - **SEO Strategy:** I'm looking for someone who can develop and implement a comprehensive SEO strategy that is tailored to attract families interested in exploring Dubai. - **Keyword Research & Optimization:** I need a professional who can identify the right keywords to optimize for search engines, ensuring that our website is visible and appealing to our target audience. - **Content Optimization:** The ideal candidate should also have experience in optimizing website content, including our tour packages, to increase organic traffic and encourage bookings. - **Reporting & Analysis:** Regular reporting on the progress of our SE...
...business units 8. Team Management: Managed cross-functional teams responsible for successful completion of projects and programs according to scope, timeline, budget constraints and quality requirements 9. Standardization in Operations : Maintained a repository of all documents related to projects and programs such as financial records, technical specifications with quality assurance 10. Overall Value Addition : Created a detailed financial reports on bi-weekly & Monthly basis for 4 on-going projects, supported on multiple projects as a PMO Leads, supported in internal ODC Management as per client requirements, coordinated with on-shore teams for team collaborations & provided support on Market Research engagements...
I'm interested in crafting a trust deed aimed at protecting my assets, specifically my occupied home. This trust deed has a single beneficiary. - Primary Objective: The objective is to safeguard my home from any potential risks or liabilities. This is intended to maintain my property's status and value and decrease my exposure to future liabilities. - Beneficiary: The trust deed will only have a single beneficiary. The desired candidate should have an understanding of how to properly structure a trust deed to ensure the beneficiary's benefits are secure and legally sound upon my passing. - Asset Details: My primary residence is the asset I wish to protect through this trust deed arrangement. It's crucial that the freelancer understands real estate and can in...
As a client seeking to improve my understanding of excel, I would like a skilled instructor to guide me through the basics of formulas and functions, data analysis and reporting, as well as formatting and conditional formatting in Excel. Although I don't have a specific completion time, expediency is appreciated. Skills and experiences that would be ideal for this job: - Advanced Knowledge of Excel - Excellent Teaching Skills - Flexibility to cater to learning pace No preference was selected for the type of learning medium, so offering a blend of online videos, live training sessions, and written instructions could be beneficial to cover all bases.
I'm looking to have a web application built and hosted in AWS Cloud. The application needs the following features: - User Authentication: A secure login system where users can create an account, log in, and manage their profile. - Forms: User-friendly forms for data entry. - Database: Reliable and organized storage system for user data. - Data Validation: Ensuring the integrity of user input data before it's stored in the database. - Should be accessible through all devices (laptop and phone) The choice of programming language or framework for this project is flexible - I am more interested in finding someone who can deliver a quality product rather than sticking to a strict technology stack. That being said, experience with AWS Cloud, user authentication systems, form handling...
I am looking for a proficient fitness trainer who's also knowledgeable in creating and managing a high-protein diet plan. Objectives: In our sessions, our main focus will be on: - Muscle building and strength enhancement. Skills and expertise: I will highly value: - Experience in helping others increase muscle mass and strength. - Skills in creating high-protein diet plans to accelerate muscle building. Experience level: Potential trainers should note: - Although I have some previous experience in exercising and muscle building, it's limited hence open to all the professional guidance I can get.
ADMIN ASSISTANT Required - Bookings - Email and Messenger correspondence - Online Advertising on Facebook Marketplace and Gumtree - Search online information - Excel Spreadsheets - Bookkeeping - Office work Job is full time Monday to Friday Thankyou
I'm going to build auth login page using the react , tailwind css, express Mysql DB. Also we have to join with google acc , facebook acc, apple acc.
I am looking to establish a reliable and professional ironing and pressing service tailored to busy professionals. Key Requirements: - The primary service offered is ironing and pressing of clothes....establish a reliable and professional ironing and pressing service tailored to busy professionals. Key Requirements: - The primary service offered is ironing and pressing of clothes. - I am specifically targeting busy professionals who value quality and convenience. - I would like the scheduling of pickups and deliveries to take place through phone calls. Ideal Skills and Experience: - Experience in providing high-quality ironing and pressing services. - Understanding of customer needs, especially of busy professionals. - Ability to manage a service-based business with phone...
DO NOT BID UNLESS YOU ARE BASED OUT OF PH. I'm in need of a detail-oriented and communicative Virtual Assistant to manage key elements of my laptop repair business. This would be a position that would require 4-8 hours per day, depending on the availability of the individual Key Responsibilities: - Book keeping, reconcilliation of payments & invoices - Assisting with keeping track of repairs using Zoho Desk - Handle customer support inquiries via Email, Phone, and Live chat --Respond directly to basic queries --Forward on relevant information to our local staff - Execute order management tasks The ideal candidate should have: - Excellent written and verbal communication skills - Data management and excel skills are critical - Ability to manage multiple tasks sim...
I'm in need of a detail-oriented and communicative Virtual Assistant to manage key elem...reconcilliation of payments & invoices - Assisting with keeping track of repairs using Zoho Desk - Handle customer support inquiries via Email, Phone, and Live chat --Respond directly to basic queries --Forward on relevant information to our local staff - Execute order management tasks The ideal candidate should have: - Excellent written and verbal communication skills - Data management and excel skills are critical - Ability to manage multiple tasks simultaneously - Familiarity with various customer support and order management tools - Available for 4-8 hours per day. - Experience with Zoho one - Understanding of laptop parts or experience in the laptop repair industry Please quot...
...required. - Experience using customer service software, HubSpot or similar is an advantage. - Experience supporting a Web application business, or telehealth or video conferencing technologies is an advantage. - Experience creating or contributing to written help articles or how-to videos would be an advantage. Learn more and meet the humans of Coviu here: We deeply value people from diverse cultures, abilities, genders and respect multiplicity of thoughts and free expression, allowing people to feel accepted and valued. We strive to provide a safe and flexible workplace as a remote first business. By providing flexible ways of working, we at Coviu want to empower our team to feel trusted and respected every day. Please no recruitment agencies, if we require assistance
Printing function is done. Each product only print one time, if new product added to the order, print the new product only. Only developer who can work with ftp.
...freelancer who can handle both video editing and excel management. - Video Editing: I have various types of videos that need to be edited. This includes marketing videos, tutorial videos, event videos, and reels. The ideal candidate is proficient in video editing tools and can create engaging, professional videos that suit different platforms such as social media, websites, and presentations. - Excel Management: On the other hand, I also require assistance in organizing and managing data on Excel. You should have a good grasp of Excel functions and be able to maintain and update spreadsheets effectively. Ideal skills: - Proficient in video editing software - Experience in creating marketing, tutorial, and event videos - Skilled in managing data on Exc...
...entering high complexity data into Excel. The data is scientific research data and involves working with an extensive database. Key Requirements: - High level of attention to detail is crucial, as inaccurate data entry could have significant implications. - Familiarity with Excel and proficiency in data entry. - The data involves scientific research data, so any background in related fields would be beneficial. Tasks: - Entering the data accurately and efficiently. - Applying conditional data validation as required (e.g., specific formats or criteria for entries). - Ensuring the database is updated and maintained accurately. Ideal Skills and Experience: - Proven experience in data entry, ideally with high complexity data. - Strong understanding of Excel, particul...
I'm looking for an expert to scrape data from a website. I will provide the list of data (approx. 16K entries) that will be entered into the search bar and I need 2 fields extracted from each search into an excel sheet. This will be a one-off scrape of the website.
I require a freelancer skilled in data entry. Unfortunately, I was unable to determine the specific type of data entry needed, total entries required, and the format of the data. However, I am seeking a dependable professional who can adapt to different tasks. Ideal skills include: - Strong atte...freelancer skilled in data entry. Unfortunately, I was unable to determine the specific type of data entry needed, total entries required, and the format of the data. However, I am seeking a dependable professional who can adapt to different tasks. Ideal skills include: - Strong attention to detail - Data categorization - Data verification - Data conversion The applicant should be proficient in Excel, CSV, and PDF. This role is likely to involve handling various types of data, so versatili...
...looking for a detail-oriented individual to assist with a data entry project. The task involves entering a variety of data types including numeric, text, and alphanumeric, into an Excel file. Key Details: - You will be working with a spreadsheet that has more than 10 columns. - I require the data to be formatted in a specific way: - Color coding: Certain cells should be filled with specific colors. - Conditional formatting: Cells should be formatted based on specific criteria. - Data validation rules: Certain cells should only accept specific types of data. Skills required: - Proficiency in Excel, including experience with conditional formatting, data validation, and color coding. - Strong attention to detail to ensure accurate data entry. - Efficien...
As part of my business operations, I need a robust and all-inclusive Excel-based Point of Sale (POS) and Inventory system. KEY FEATURES: - **Sales Tracking**: The system should track all sales, revealing important stats that can aid decision-making. - **Inventory Management**: Stock should sync automatically with sales from POS, maintaining an accurate record of available goods. - **Customer Database**: Important fields such as Contact Information and Purchase History should be part of this system. Important tax-related fields like the tax fee and tax ID number should also be included. IDEAL SKILLS: Freelancers with a strong background in Excel and inventory management systems are preferred. Experience in integrating POS systems and data entry automation is also des...
As part of my business operations, I need a robust and all-inclusive Excel-based Point of Sale (POS) and Inventory system. KEY FEATURES: - **Sales Tracking**: The system should track all sales, revealing important stats that can aid decision-making. - **Inventory Management**: Stock should sync automatically with sales from POS, maintaining an accurate record of available goods. - **Customer Database**: Important fields such as Contact Information and Purchase History should be part of this system. Important tax-related fields like the tax fee and tax ID number should also be included. IDEAL SKILLS: Freelancers with a strong background in Excel and inventory management systems are preferred. Experience in integrating POS systems and data entry automation is also des...
I'm searching for a passionate photographer who can encapsulate the essence of a traditional engagement in the natural settings of an outdoor park. - The photo session should highlight key elements such as us holding hands, close-ups of the engagement ring, and tender moments of us kissing. - I highly value the traditional style in photography. Ideal skills and experience - Extensive experience in traditional-style photography - Excellent outdoor shoot portfolio - Expertise in capturing intimate moments and intricate details such as the engagement ring closeup
I'm seeking a proficient Excel expert who can help me create a complex formula for my Excel sheet. The formula will involve an IF statement assessing multiple values and conditions. its one simple formula Key Details: - The formula should be able to evaluate whether a given value is: - Greater than a certain threshold, - Less than a certain threshold, or - Equal to a specific value. - Each of these conditions should trigger a different calculation (to be defined). You should be familiar with creating complex formulas and IF statements in Excel. Your attention to detail and understanding of data manipulation will be crucial in ensuring the formula works accurately. Additionally, your proactive problem-solving skills will be highly valued as...
I'm seeking a skilled professional to create a comprehensive payroll management tool for my construction company. We're a medium-sized business with 11-50 employees, and we need a robust system in place to effectively manage employee time tracking, payroll processing, and report generation. ...clear insights into payroll activities Ideal Skills and Experience: - Proven experience with construction payroll administration - In-depth knowledge of employee time tracking systems - Proficient in payroll processing software - Experience in report generation and data analysis Delivering this project will streamline our payroll process, promoting efficiency in our construction business. We value precision, accountability, and punctuality - if these are your strengths, we look ...
I need a professional who can quickly and accurately input less than 100 rows of data into an Excel file. You'll be provided with all the necessary data, so there's no need for additional sourcing. Ideal Skills and Experience: - Proficiency in Excel - Fast and accurate data entry skills - Attention to detail to ensure correctness - Experience in working with data sets This is a straightforward project that needs to be completed quickly, so I'm looking for someone efficient and reliable. If the data entry is done well, there is potential for more work in the future.
...an amazing job using WordPress, WooCommerce, and an RnB rental and booking plugin downloadable from to create a website and was paid accordingly. The website also has a single product page where users can book a lane, as shown below. However, there are some design changes I would like to make to the single product page based on feedback from my client. I must reiterate that the changes need to be compatible with the current single product page’s layout, WooCommerce, and the RnB plugin used. Firstly is the page layout. Currently, users choose a lane first, then choose a date second, then choose a time third. Instead, I would like to change the sequence these appear so you choose a date first, then choose a lane second
I'm seeking a skilled developer to create a user-friendly macro calculator that's accessible on the web. This tool will help individuals in calculating their daily calorie needs based on their fitness objectives, whether it's weight loss or muscle gain. Key Features: - A simplistic yet engaging web interface that allows users to easily input their details - Capability to calculate an individual's daily caloric needs based on their goals - A results page that provides users with a clear breakdown of their macronutrient requirements The calculator will not require user accounts for tracking progress. Instead, users will have the opportunity to download their results after entering in the details for lead generation. This project is intended to generate lea...
I need an Excel expert to help me generate all possible combinations of 12 distinct objects, amounting to 2048 total objects. This will involve the use of Pivot Tables, Macros, and Complex Formulas. Key Requirements: - Proficiency in Excel: You should be highly skilled and experienced in using Excel and its various functions. - Experience with Pivot Tables: You must know how to create and manipulate Pivot Tables to organize the data effectively. - Macro Creation: You will be required to write macros to automate certain processes and tasks. - Strong Command of Complex Formulas: You should be comfortable working with complex formulas to handle the extensive data manipulation required. The end result will be a PDF file containing all possible combinations, derived from...
As I am writing a Bachelor thesis on the subject of value creation in cultural diversity, I am seeking an experienced academic writer with a strong background in intercultural studies, economics, and innovation. The project involves investigating the role of innovation and creativity as central themes. Ideal Skills: - Academic research and writing - Knowledge in intercultural studies - Creativity and innovation understanding Tasks: - Analyze the economic impact of different cultures through the lens of innovation and creativity. - Understand and communicate the importance of social cohesion in this context. - Conduct case studies about value creation in diverse cultural settings. - Carry out a comparative analysis of these case studies to highlight apparent trends. - Fo...
...speech recognition and natural language processing - Experience in developing software compatible with Windows and Mac - Strong understanding of calendar integration and email automation On-Prem Client: Quivr Agent * Installation * Install Quivr Agent on Windows or macOS * Configure Quivr Agent to connect to local database and file system * Local Database * Use Azure Storage or Microsoft SQL Server as local database * Store indexed data and search results in local database * File System * Use Windows File System or macOS File System * Index local files and folders * Search * Search local database and file system for relevant results * Display search results in user interface * User Interface * Develop user interface for Quivr Agent * Inclu...
I'm looking for an experienced developer to a piece of software for my jewellery repair business. I do work for several stores and they each send me multiple jobs per week. Some of these jobs are ok to just do, however some require quotes/estimates. I need software that will let my customers log in to a portal and view and be able to proceed/decline and comment on each individual estimate. I would like them to get notified of each estimate to their email and also for my email to be notified whenever they proceed/decline or comment on an estimate Key Requirements: - The software could be designed primarily for use on the web or an app - The main purpose of the software is allow customers to each have there own portal where jobs can be viewed and any proceed or comments will be sent via...
I'm in need of an administrative assistant who is proficient in Microsoft Excel for data entry and updating tasks. Specifically, this role entails managing my product inventory. Your primary responsibilities would involve: - Entering and updating inventory data on a regular basis - Organizing and ensuring the accuracy of each entry - Handling large data sets in Microsoft Excel - Following-up to make sure if the items in the inventory is still available It would be beneficial if you're detail-oriented and have prior experience in this kind of work. Don't hesitate if you have questions. Looking forward to your bids.
I'm in need of a professional who can manage the wholesale selling of my personal items. The items include m...expert who can connect me with potential buyers in the wholesale market. - Auction Management: I require a professional who can handle the auction process, ensuring smooth and profitable transactions. - Online and Physical: The expert should be able to manage both online auction platforms and physical auction events. Ideal skills and experience: - Proven track record in wholesale selling of high-value personal items. - Proficient in auction management, both online and physical. - Adept in the marketing of items such as musical equipment, fine art, and antiques. - Excellent negotiation skills to ensure optimum profit. Please reach out if you have the right expertise ...
I'm in need of an Excel expert to assist in creating advanced statistical or financial functions. Your job will be to help me with these complex Excel tasks and generate charts or graphs as the final output. Key Requirements: - Deep understanding of Advanced statistical or financial functions in Excel. - Ability to generate visual representations through charts or graphs. Your role would entail: - Collaborating with me to understand the data and the desired outcomes. - Leveraging your expertise to implement the appropriate statistical or financial functions within Excel. - Presenting the results in a visually compelling manner through the creation of charts or graphs. Please share your relevant experience and any sample work you've done in the pa...
Hi, I am new to react. If I click open panel a panel opens. if I drag the item from the panel to column2 it should add to the table and simulataneously it should add to column 1. same way if I add to column 1 it should add to column 2 table two. I am able to achieve for column 1 but not inside column 2 table. can you lee me know how to fix it. Providing my code and fiddle link below. ,src%,src%2FApp.jsx&terminal=dev import { useState } from 'react'; import reactLogo from './assets/'; import viteLogo from '/'; import './'; import { DragDropContext, Droppable, Draggable } from 'react-beautiful-dnd'; function App() { const [panelOpen, setPanelOpen] = useState(false); const [columns, setColumns]
...products we offer and these are aimed at a young audience ranging from 14 to 30 years old. What is our value/concept? Our concept lies in offering an experience based on direct communication with our Clients, with a literary narrative in the genre of fables. For this reason, the 3 rabbits we have have direct communication with the customer, according to the selected product segment, which makes interacting with us tell a story. Our added value focuses on our store prototype which promotes an urban, pleasant, fresh, modern lifestyle and encourages us to enter a parallel world full of surreal imagination covered by art and music that generates cultural identification with our clients. , always based on the 3 rabbits. Our main purposes lie in 3 pillars that mee...
- Nana's Cornbread Casserole Vegan Homecooking (subtitle) Mostly text but can try to include image silhouette or outline.
