Excel vba sql based column value jobs
I'm looking for an Excel expert to create a macro that will help in task automation. The specific tasks to be automated will be discussed later. Ideal Skills: - Proficiency in Microsoft Excel - Experience in developing macros for task automation - Excellent problem-solving skills - Ability to understand and analyze tasks for automation Please provide examples of similar projects you've completed in your proposal.
I'm looking for a professional to create a detailed 3D architectural model in Revit from the attached 2D structural and architectural drawings. The 3D model is intended for educational or training purposes, so a high level of detail and accuracy is critical. Key Responsibilities: - Create a comprehensive 3D architectural model in Revit. - Incorporate rebars in the slab, one beam, and one column, all using Revit. - Add necessary detailing, objects, and features such as a parapet, boundary wall, lawn, roads, furniture, etc., in line with modern architectural styles. - Conduct a professional 4D simulation using Navisworks. - Produce rendered images and a walkthrough/flythrough animation with sufficient detail. Ideal candidates should have extensive experience with: - Revit for c...
I have a project to be completed in Financial Modelling througn excel.
I'm seeking a seasoned Ruby on Rails developer for the maintenance and updates of an existing Business Services web application. The system is designed to manage client details, documents, and operations. Key Responsibilities: - Regular main...seeking a seasoned Ruby on Rails developer for the maintenance and updates of an existing Business Services web application. The system is designed to manage client details, documents, and operations. Key Responsibilities: - Regular maintenance and updates of the web application - Ensuring system efficiency and functionality Ideal Skills: - Proficiency in Ruby On Rails - Experience with Docker and SQL - Previous work on Business Services systems Please note, the selected developer must be contactable and able to work during UK standar...
I need a professional Excel macro specialist to help automate the generation of maintenance reports. Key Requirements: - The macro will need to compile and format data into tables and lists for the reports. - The ideal candidate should be proficient in writing Excel macros and have experience with report generation. - Attention to detail is crucial to ensure the reports are accurate and well-structured. If you can help me streamline this process, please get in touch.
I'm an intermediate user of Microsoft Advertising, looking for a hands-on tutor to help me create campaigns for my local service business. (Philadelphia) I want to expedite my learning curve and would appreciate your assistance with ongoing optimization of my existing account. Key Requirements: - Experience with Microsoft Advertising, particularly with keyword optimization - Ability to provide quick assistance via phone - Experience in teaching or tutoring, with the ability to explain complex concepts in a simple way Ideal Skills and Experience: - Strong understanding of pay-per-click advertising - Experience creating campaigns for local service businesses - Proven track record in keyword optimization - Excellent communication skills - Patience and understanding in teaching I pref...
I'm seeking an expert to assist with converting my Excel tables and data into HTML. This project will also require the conversion of my Excel charts and graphs into static images for HTML display. Skills needed: - Proficient in Excel and HTML - Experience in data conversion - Ability to create static images from Excel charts and graphs - Attention to detail to ensure all tables and data are accurately converted
I'm looking for a professional to create a detailed 3D architectural model in Revit from the attached 2D structural and architectural drawings. The 3D model is intended for educational or training purposes, so a high level of detail and accuracy is critical. Key Responsibilities: - Create a comprehensive 3D architectural model in Revit. - Incorporate rebars in the slab, one beam, and one column, all using Revit. - Add necessary detailing, objects, and features such as a parapet, boundary wall, lawn, roads, furniture, etc., in line with modern architectural styles. - Conduct a professional 4D simulation using Navisworks. - Produce rendered images and a walkthrough/flythrough animation with sufficient detail. Ideal candidates should have extensive experience with: - Revit for c...
...Amazon-style product galleries: 1. Infographic Image: Highlighting key features. 2. Lifestyle Image: Showcasing the product in use. 3. Benefits Image: Focusing on advantages for the customer. 4. Comparison Image: Positioning the product against competitors. 5. "Why Buy From Us" Image: Emphasizing brand value. 6. Main Image: Clean and eye-catching first impression. 7. CTA Image: Driving customer action. Note: While these are suggested types, flexibility is allowed based on each product's unique requirements. Write compelling, friendly yet professional copy that communicates effectively with customers, answers all potential questions, and leaves no loose ends. Requirements: Fluency in German (both written and spoken) is mandatory. Experie...
I'm seeking a web developer to create a small-scale HR management system. The application should allow the addition of new employees, inc...mark their own attendance. - Salary Management: The system should allow employees to download their salary slips. - Data Upload: There should be an option to upload employee data in bulk via Excel. - Email Integration: The system should be configured to send offer letters through Gmail. Ideal Skills: - Web Development: Proficiency in creating interactive and user-friendly web applications. - HR Software Knowledge: Prior experience with HR management systems would be beneficial. - Email Service Integration: Experience with Gmail's API for automated email sending. - Data Handling: Skills in setting up Excel data uploads for large...
I'm looking for an experienced SQL Server professional to set up log shipping for disaster recovery purposes. This will primarily involve transactional data, and log backups need to be taken and shipped every 5 minutes. Ideal skills and experience: - Extensive knowledge of SQL Server - Proven experience with log shipping - Strong understanding of disaster recovery strategies - Familiarity with handling transactional data - Ability to set up frequent log backups (every 5 minutes)
I need a formal, professional PowerPoint presentation tailored for a sales pitch to potential investors. The presentation's main goal is to effectively communicate our value proposition and secure funding. Ideal skills and experience include: - Proficient in PowerPoint with a creative mindset to design engaging slides - Previous experience creating investor-focused presentations - Excellent understanding of sales pitch dynamics - Ability to communicate complex ideas succinctly and effectively - Strong grasp of formal business language and tone
All details : 1. Color the full candles with a different color; the full candle is the candle that has the body that equals ...that equals at least 2 times or more the top wick and 2 times or more the bottom wick, and last condition the largest wick must equal at least 2 times the smallest wick. I want you to add an input "NBP" that displays this number of times for example if I set NBP = 2 or NBP=3........ 2. When I set "amp=8" I want the indicator to display only the colored candles that are below and above the entered value of "amp" 3. I want to move the signal display to the third candle; that is Only the alert signal is displayed unless the first candle and the second candle are colored and the third candle (colored or not colored), and the signa...
I'm a beginner in Power Queries, seeking a tutor to guide me through data transformation and merging queries. Together, we'll improve an existing Excel file for better data organization. Sessions will be over Zoom, which will be recorded for future reference. Ideal skills and experience include: - Proficiency in Excel, particularly Power Queries - Prior experience in online tutoring or teaching - Ability to simplify complex concepts - Strong communication skills - Patience and understanding towards beginners
I need assistance with manual data entry of customer information I receive via emails. Requirements: - Proficient in data entry - Able to handle and convert data from emails into Excel - Detailed-oriented - Able to maintain confidentiality
I'm seeking a professional who can assist with extracting performance data of Brazilian investment funds from the Refinitiv platform. The data should be specifically focused on performance indicators and delivered in Excel format. Key Requirements: - Access to the Refinitiv platform - Ability to extract performance data of Brazilian investment funds - Proficiency in Excel for data delivery - Capability to perform this task on a yearly basis The ideal freelancer for this project would have experience with data extraction from financial platforms, particularly Refinitiv. Understanding of investment fund performance metrics is a plus. Please bid only if you have access to the required platform and can deliver the data as specified.
I am seeking a seasoned Ruby on Rails (ROR) developer with a minimum of 4 years of experience, specifically with Rails 4/5. The ideal candidate will have a strong sense of ownership, a can-do attitude, and a collaborative spirit. You will be working closely with designers, product managers, and other software developers to deliver compe...within ROR. - Experience with system architecture and efficiency. - Strong drive, ownership, and team-oriented mindset. - Proficient in standard CS fundamentals (data structures, algorithms, complexity analysis). - Strong English proficiency. - Systematic debugging and problem-solving skills. The application will need to pull data from various sources including databases, external APIs, and CSV/Excel files. Your expertise in ROR is crucial for thi...
I'm in need of a Zoho Books professional who can assist with the setup and configuration of Zoho Books, specifically focusing on data import and migration, as well as customization and integrations. Key Requirements: - Importing large Excel files containing product information into Zoho Books - Customizing and integrating Zoho Books to suit my business needs - Initial setup and configuration of Zoho Books Ideal Skills and Experience: - Extensive experience with Zoho Books - Proficiency in data import from Excel to Zoho Books - Ability to customize and integrate Zoho Books - Previous experience in setting up Zoho Books
Our company is in search of a dedicated Full Stack Developer to join our team full-time. We specialize in web and mobile application development, and we need someone with a strong background in this area to help us create top-notch applications targeting both desktop and mobile users. Key Skills & Experience: - Proficiency in Laravel, Tailwind, Livewire , Filament, PHP, JavaScript, and SQL Database. - Experience with MVC Frameworks. - Creative UI development skills. - Strong understanding of user experience considerations including easy navigation, fast load times, and aesthetic design. - Previous work as a UI designer is a plus. - Familiarity with the Livewire Laravel package. The selected developer will enjoy a three-year fixed contract and will be part of the company payrol...
I need assistance with cleaning data from several digital Excel files. Key Responsibilities: - Review and clean data in Excel spreadsheets - Ensure data integrity and accuracy Ideal Candidate: - Proficient in Excel - Has experience with data cleaning - Detail-oriented and able to spot errors in data
I need a professional designer to help with redesigning a bungalow house aimed at increasing its market value. The focus will be primarily on the bedrooms and bathrooms, which need to be transformed into appealing, functional spaces that prospective buyers will love. Key Aspects of the Project: - Redesign of bedrooms and bathrooms - Aim to significantly increase property value - Should appeal to the current real estate market Ideal Skills and Experience: - Proven track record in residential design - Strong understanding of real estate market trends - Excellent knowledge of space optimization and aesthetic design
...convey your brand's essence. Here's why I believe I'm the perfect fit for your project: Tailored Creativity: Every design I create is unique, ensuring it aligns perfectly with your brand identity and stands out in the crowded marketplace. Timely Delivery: I understand the importance of deadlines. You can count on me to deliver high-quality designs on time, every time. Collaborative Approach: I value your input and believe the best designs come from a partnership. I’ll work closely with you to ensure the final product exceeds your expectations. Proven Track Record: My portfolio includes successful projects with companies like [mention any relevant companies or projects], which have helped them achieve [mention specific results, like "a 20% increase i...
...Candidate: 1. E-Learning Expertise: I have successfully converted complex presentations into engaging e-learning modules with clear learning objectives and measurable outcomes. 2. GoHighLevel Experience: I am highly skilled in using GoHighLevel to create membership site content and interactive learning experiences. 3. Educational Curriculum Design: My background includes designing knowledge-based, skill-based, and behavioral training programs for diverse audiences. 4. Content Versatility: From PowerPoint conversion to text formatting, I ensure content is user-friendly, professional, and aligned with learning goals. Proposed Plan: Transform your PowerPoint into e-learning modules with clear objectives and a seamless user experience. Develop membership site conte...
...convey your brand's essence. Here's why I believe I'm the perfect fit for your project: Tailored Creativity: Every design I create is unique, ensuring it aligns perfectly with your brand identity and stands out in the crowded marketplace. Timely Delivery: I understand the importance of deadlines. You can count on me to deliver high-quality designs on time, every time. Collaborative Approach: I value your input and believe the best designs come from a partnership. I’ll work closely with you to ensure the final product exceeds your expectations. Proven Track Record: My portfolio includes successful projects with companies like [mention any relevant companies or projects], which have helped them achieve [mention specific results, like "a 20% increase i...
I need a response paper that primarily supports my viewpoint. The paper should be based on a specific book and follow the MLA format. All the references or citations for the paper should come from Born in Blood and Fire a concise history of Latin America by John Charles Chasteen 4th Edition. I have the book online I can send it to you via Email. Ideal Skills: - Excellent writing and critical thinking skills - Proficient in MLA format - Ability to articulate and support a viewpoint Experience: - Prior experience in academic writing, particularly response papers - Familiarity with the specified book would be an advantage - Proven track record of adhering to specific formatting requirements.
We are seeking a skilled AI Developer or team to create a ChatGPT-based conversational AI tailored for , an adult subscription-based platform similar to OnlyFans. This is a project for an 18+ platform, so applicants must be comfortable working in the adult industry. The AI will be used by agencies managing creators on to automate subscriber interactions, increase engagement, and drive sales of PPV (pay-per-view) photos and videos. What We Need: AI Integration: Leverage ChatGPT’s API to develop an AI that can: Engage subscribers in seductive and natural conversations. Build relationships to maintain subscriber interest. Sell pre-uploaded media (photos/videos) using predefined scripts. Customization and Training: Educate the AI to: Mimic the personality and style of ...
I am looking for a Hindi-speaking individual to visit our warehouse in Port Klang, Malaysia. The purpose of this visit is to teach a small group of our Indian staff (1-5 members) basic computer skills. Skills to be taught include: - Using a web browser - Using Google Sheets - Using Microsoft Excel The level of proficiency we aim for is basic. Your role will be crucial in helping our staff become more computer literate and improving their productivity. Ideal candidates will have: - Proficiency in Hindi and Malay - Strong knowledge of basic computer skills - Experience in teaching or training - Patience and good communication skills
I'm in need of a skilled freelancer with extensive experience in Zoho CRM and database management to synchronize our Zoho CRM with our database. Key Responsibilities: 1. Data Update & Cleanup: - Align our CRM ... - Ensure the script is capable of handling incremental updates and can operate on a set schedule. 3. Documentation & Automation: - Create clear and concise documentation detailing the cleanup and synchronization processes. - Automate the sync script for regular execution (e.g., hourly via crontab). Ideal Skills: - Extensive experience with Zoho CRM and its API. - High proficiency in SQL and Python. - Strong familiarity with data cleaning and automation tools. Please reach out if you're interested and share examples of similar projects yo...
Creating marketing content and a website for a DevOps service involves presenting technical concepts in a simple, engaging, and value-focused way. Here’s a detailed idea: --- Website Structure & Content Plan 1. Homepage: The Gateway to DevOps Excellence Headline: “Transform Your Development Process – Achieve Faster Delivery with DevOps.” Subtext: “Streamline workflows, boost collaboration, and automate deployment with our end-to-end DevOps solutions.” Call-to-Action (CTA): "Get Started Today" or "Schedule a Free Consultation." Visuals: A dynamic banner with DevOps tools (like Jenkins, Kubernetes, Docker) and animations showing smooth collaboration. 2. Why DevOps? (Educational Section) Simplify DevOps benefits: fa...
I'm looking for a skilled freelancer with expertise in Power Automate and Excel coding. I need assistance with automating data entry and updates in my Excel worksheets. Key Requirements: - Automate importing data from an email and CSV/Excel files into my Excel sheets. - Streamline the process of updating existing records. Ideal Skills: - Proficiency in Excel and Power Automate. - Experience with data handling and automation. - Strong attention to detail and ability to validate data. The goal is to save time and enhance efficiency with data management. Please share your relevant experience and examples of previous projects.
I'm in need of an Excel expert who can help automate some of my book-keeping tasks. The main focus will be on reconciling accounts. Your responsibilities: - Utilise experience with excel formulas and macros to refresh existing reconciliation process for the book-keeping and management reporting of a small UK charity. - Ensuring accuracy and efficiency in the automation. Ideal skills and experience: - Proficiency in Excel, particularly in using formulas and creating macros. - Background in book-keeping and accounting. - Experience in automating tasks in Excel.
Project Title: Web-Based CRM System Development for HR and Employee Management Project Overview: I am looking for a skilled developer or team to build a Web-Based CRM System that will efficiently handle various HR and employee management functionalities. The system should provide features such as employee data management, attendance tracking, leave management, salary slip generation, performance evaluation, and other HR-related functionalities. I already have a domain and hosting set up; I only need the website to be designed, developed, and deployed. Key Features to Include: 1. Employee Management: Add, edit, and view employee details (e.g., name, department, position, contact information, etc.). Employee ID generation and profile picture upload. 2. Attendance Tracking: D...
I'm looking for a Python expert who can help analyze our customer data. - The primary goal of this project is to derive insights from our customer data to drive business decisions. - The data is stored in databases, so experience with SQL and database management is a plus. - A strong background in data analysis and Python is essential for this project. Please include your relevant experience and examples of similar projects you've completed in your proposal.
I'm looking for a professional developer who can create a network security API similar to Burp Suite. This API should primarily focus on vulnerability scanning, specifically for SQL injection and Host header injection. It should provide detailed technical reports on the vulnerabilities it discovers. Ideal Skills and Experience: - Proficient in API development - Extensive knowledge in network security - Experienced in vulnerability scanning - Familiar with SQL injection and Host header injection - Capable of generating detailed technical reports
...skilled video editor to enhance my social media content aimed for YouTube. Key Responsibilities: - Cutting and trimming: Efficiently refining the footage to maintain a fast-paced, engaging flow typical of successful YouTube content. - Adding text and graphics: Incorporating relevant on-screen text and graphics to underscore key points, promote viewer interaction, and enhance overall production value. Ideal Skills: - Proficient in industry-standard video editing software (e.g., Adobe Premiere Pro, Final Cut Pro). - Creative mindset with a strong understanding of YouTube content dynamics. - Experience in adding engaging text and graphics to videos. Please provide examples of similar projects you've completed in your bid. Thank you! I need this type of videos
I'm in need of a data cleaning professional to help me with a spreadsheet containing 50,000 rows of company details. The data is currently organized in a single column and includes company names in mixed formats. Key Responsibilities: - Extract company names from the data strings - Clean the data manually to ensure accuracy Ideal Candidate: - Proficient in Excel or similar data management software - Exceptional attention to detail - Previous experience with data cleaning or data entry - Able to work independently and meet deadlines Please note that the company names are in mixed formats, so the ability to recognize and standardize these is crucial.
...Token management needs What We're Building: ┌─────────────┐ ┌──────────────┐ ┌────────────┐ │ Beds24 │────►│ Business │────►│ Data │ │ │ │ Logic │ │ Layer │ └─────────────┘ └──────────────┘ └────────────┘ Building a robust data layer and business logic system using serverless functions (Cloudflare Workers/Supabase Functions) and SQL database (D1/PostgreSQL). 1. Modern Data Layer - Complete booking management - Change history tracking - Price and availability tracking - Full audit capability 2. Sync System - Reliable data synchronization - Error handling and recovery - Bidirectional updates - Performance optimization Technical Stack: - Serverless Functions (Cloudflare Workers or S...
I'm looking for a proficient data entry specialist who can help me record mixed data (text and numerical) from Excel files. Key Responsibilities: - Accurately inputting mixed data (text and numerical) from provided Excel files. - Ensuring data integrity and accuracy during the entry process. Ideal Skills: - Proficiency in Excel and data entry. - Attention to detail to ensure data accuracy. - Experience in handling mixed data types. Please provide your experience with similar projects in your bid. Thank you.
...Detail: Strong reporting skills to keep the team updated on progress. Previous experience in telecalling, sales, or customer interaction is a plus. What We Offer Remuneration: INR 20,000 per month (fixed) + attractive sales commission. Growth Opportunity: Potential to transition into a full-time role based on performance. Flexible Work Hours: Ideal for individuals looking to balance other commitments with a rewarding part-time role. How to Apply If you believe you have the skills and drive to excel in this role, please send your updated resume and a short voice recording introducing yourself....
Want to recreate this spreadsheet to add another section, a sixth one called Operations Also want to add our company logo
I'm seeking a professional pitch deck to present our healthcare portal app to potential investors and partners. Key Requirements: - Creative Content: The most crucial aspect of the pitch deck. I need someone who can help craft engaging, compelling content that captures the essence and potential of our app. - Design: The design should be professional and corporate. It should reflect the seriousness of our venture while being visually appealing. - Design Elements: The pitch deck should make use of infographics and charts, images and illustrations, as well as typography and layout. All these elements should be balanced and well integrated to enhance the overall presentation. Market Research: While not the primary focus, a component of market research to identify potential investors an...
I'm in need of a comprehensive Excel workbook that can assist in managing and scheduling both staff and volunteers. The workbook should be capable of: - Scheduling staff and tracking days off - Computing hours and calculating salaries Additionally, the workbook should enable viewing the schedule in Gantt charts. Ideal candidates for this project should have a strong background in Excel, particularly in creating complex workbooks with various functions. Experience in HR or volunteer management is a plus. Please note, I will be providing the data necessary for hours computation and salary calculation.
...Email ID (if available) Key Guidelines: 1. Accuracy: Ensure the data matches the right company and individuals. 2. Relevance: Only collect details from the specified departments or leadership levels. 3. Uniqueness: No duplicate entries; only one set of data per company. 4. Professionalism: Emails should be valid, active, and professional in format. Delivery: - Compile the data into a structured Excel or CSV file using the above format. - Ensure the file is easy to navigate and filter for quality assurance. Let me know if any clarification is needed! If you going to start chat with me come with your pricing....
I'm looking for a LinkedIn expert who can help me to enhance my presence on the platform. The primary goal of this project is to comment, network, and connect with people across the platform. Key Activities: - Commenting on posts: I want you to actively engage with relevant content on LinkedIn. - Networking ...Networking with professionals: I need you to identify and connect with key players in my industry. - Connecting with new people: Expanding my LinkedIn connections is a key part of this project. The ideal freelancer for this project should have: - A knack for networking - Excellent communication skills - Proven experience with LinkedIn engagement - Ability to comment on posts in a way that adds value and showcases expertise Daily Requirements - 50-60 comments Con...
I need a freelancer who can assist me with data extraction from PDF files. The task involves: - Extracting text content from PDF files. - Accurately entering the extracted data into an Excel file. Ideal skills and experience for the job: - Proficiency in data entry with high attention to detail. - Prior experience with PDF data extraction and Excel. - Ability to maintain confidentiality and handle sensitive information with discretion.
Are you new to freelancing or looking for a simple way to start earning money online? Whether you’re a beginner or experienced, this task is designed for anyone who wants to generate income without requiring special skills. Here’s your chance to kickstart your freelancing journey and gain valuable experience while earning bonuses for achieving milestones! •What You’ll Do: Promote Our Website: Share the website with your network via social media, chats, emails, or word of mouth. Generate Leads: Encourage them to sign up and make a profile on our website through your unique referral link. •Requirements & Extra Benefits: No Special Skills Required: We provide all the resources and training to get you started. A smartphone or computer with internet access. Gr...
...implement unit and integration tests to ensure code quality and functionality. Pages and Components (Detailed) Here's a breakdown of the pages and the functionality/components they will need, you can use this list when talking with the freelancer: Homepage (/) Purpose: The main entry point of the website, introducing Idealistic Solutions. Components: Hero Section: Headline (Compelling and clear value proposition) Subheadline (Brief explanation of what Idealistic Solutions does) Call-to-Action Button (e.g., "Explore Our Services," "Get a Demo," "Contact Us") Potentially an Image/Video/Animation related to the SAS industry About Us Teaser Section: Brief Company Introduction Key values or mission. Link to the About Us page. Services Highlight Sect...
