Excel vba sql based column value jobs
I'm seeking an experienced developer or team to create a cloud-based, multi-tenant (SAAS model), user-friendly CRM system. The front-end will be built using Angular, while the backend API will be developed using .NET Core. Key Requirements: - The CRM should manage various customer interactions, including email communications, phone call tracking, and live chat support. - It should incorporate sales pipeline management and automatic lead scoring as crucial sales tracking features. - The system needs to handle different types of leads: cold, warm, and hot. - The design must prioritize a user-friendly interface for end-users, coupled with a scalable backend. Ideal Skills and Experience: - Proficiency in Angular for front-end development. - Extensive experience with .NET Core for...
...Manager for Electrical Contracting and Generator Installation Business Description: We are a well-established electrical contracting and generator installation business seeking an experienced and creative Social Media Manager to enhance our online presence on Facebook, Instagram, and other platforms. The ideal candidate will have a proven track record in managing and creating content for service-based businesses, with a specific focus on: Generac generator installations Quotes, maintenance, and repairs Electrical contracting (residential, commercial, and industrial sectors) This role will involve strategy development, content creation, posting, engagement, and performance tracking. Scope of Work: Account Setup and Branding: Create and optimize new accounts for Facebook, Insta...
...specific, secret tasks and distributes them individually to other users. Each user earns "secret points" upon successful completion of their assigned tasks, without knowing the ultimate goal of their actions or who will benefit. These secret points are later used by the user to have their own desires and needs fulfilled, as the application secretly orchestrates plans to make their wishes come true based on their accumulated points. Examples to Illustrate the Concept with Secret Points and Rewards: Example 1: Someone Dreams of a New Book: Person A submits to the application: "I wish to get the book [Book Title]." The Application: Sends a secret task to Person B: "Go to the library and take a picture of the science fiction book shelf. You will receive ...
As we seek long-term work, I am seeking value for money, so please provide your lowest possible bid. We are looking for a WordPress expert with strong server management skills and Linux knowledge to work on long-term projects. The ideal candidate will have expertise in the following areas: Key Responsibilities: 1. Website Migration Repair: o Fix issues with websites that have been migrated but are not functioning properly. o Ensure smooth and error-free performance after migration. 2. Malware Cleanup and Restoration: o Restore websites that have been compromised by hacking. o Clean and secure websites, ensuring that they function optimally. o Utilize available backups for complete restoration. 3. Client Backend Restoration: o Rebuild and restore the backend admin panels to allow cli...
I'm seeking a skilled developer to create a web-based application that simplifies the creation of Word documents, specifically for tax documentation reports. Requirements: - Build a user-friendly e-commerce platform that allows for easy document creation and purchasing of additional features. - The web based application should let users add their data and generates word documents in a particular manner. - The web based application should enable user to add tables and the data to be linked. - Integrate a secure payment system for transactions. - Implement a content management system for users to save, edit and track their reports. Ideal Skills and Experience: - Extensive experience in web application development, preferably with e-commerce and CMS systems. - Str...
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'm looking for an Excel VBA expert who can help me generate financial reports using VBA macros. The final reports should be delivered in Excel format. Key Requirements: - Strong expertise in Excel and VBA - Experience in generating financial reports - Ability to automate report generation process - Delivering final reports in specified Excel format Your bid should reflect your experience and capability to deliver this project on time.
I need my Excel data modified for better visual appeal and branded to match my website. Requirements: - Apply custom themes and colors to the Excel file. - Incorporate my website's color scheme and font style. - Add my contact number to the header of the Excel file. There's no need to change any of the data, as everything has already been filled.
I have an Excel sheet with text data in various columns that needs to be sorted according to a specific sequence. The task involves: - Identifying the text data in the columns - Sorting this data following a predetermined custom sequence Ideal candidates for this project should have: - Proficient Excel skills - Experience in sorting data according to custom criteria - Attention to detail to ensure all data is sorted accurately according to the specific sequence
...specific, secret tasks and distributes them individually to other users. Each user earns "secret points" upon successful completion of their assigned tasks, without knowing the ultimate goal of their actions or who will benefit. These secret points are later used by the user to have their own desires and needs fulfilled, as the application secretly orchestrates plans to make their wishes come true based on their accumulated points. Examples to Illustrate the Concept with Secret Points and Rewards: Example 1: Someone Dreams of a New Book: Person A submits to the application: "I wish to get the book [Book Title]." The Application: Sends a secret task to Person B: "Go to the library and take a picture of the science fiction book shelf. You will receive ...
I need someone to create a excel spread sheet to show and auto populate the following cost and expenses Labor Costs: Track employee hours worked in each service category using timesheets or a time tracking system. Record the hourly wage for each employee. Calculate daily labor cost: (Number of employees) x (Hourly wage) x (Hours worked). Supply Costs: Maintain a daily log of all supplies used in each service category. Record the quantity and unit cost of each supply item. Calculate daily supply cost: (Quantity used) x (Unit cost) for each item, then sum up all item costs. Vehicle Mileage: Record the starting and ending mileage for each company vehicle used daily. Calculate the total mileage driven for each vehicle. Fuel Consumption: Collect and retain all gas card receipts. Record t...
I need an Excel spreadsheet designed for daily expense tracking and financial calculations. The ideal freelancer for this project would be someone with strong Excel skills, particularly in creating formulas and functions for financial analysis. Key Requirements: - Create an Excel spreadsheet for daily expense tracking - Implement financial calculations within the spreadsheet - Ensure the spreadsheet is user-friendly and easy to update Skills & Experience: - Strong proficiency in Excel - Experience with financial spreadsheets - Excellent attention to detail
Will create a proper google form and sheet according to your requirements.
...return gifts to customers based on Invoice size- hence the designs is detailed accordingly You need to first ensure that Gift cards with 16 digit or 12 digit secure login with pin code (as an example shown in myntra), • Coupons creation in admin panel with expiry date and with a condition which will be discussed later • Gift page which works on multiple conditions but basically works based on cart value • DLT API - which should be used for OTP verification (for profile creation), Abandoned cart notification to the customer, Order confirmation notification, Gift card purchase notification & any other where applicable • User profile which needs to be copied from some other ecommerce portal • Admin panel management on - customer communicat...
...specific, secret tasks and distributes them individually to other users. Each user earns "secret points" upon successful completion of their assigned tasks, without knowing the ultimate goal of their actions or who will benefit. These secret points are later used by the user to have their own desires and needs fulfilled, as the application secretly orchestrates plans to make their wishes come true based on their accumulated points. Examples to Illustrate the Concept with Secret Points and Rewards: Example 1: Someone Dreams of a New Book: Person A submits to the application: "I wish to get the book [Book Title]." The Application: Sends a secret task to Person B: "Go to the library and take a picture of the science fiction book shelf. You will receive ...
I'm seeking a developer to create a straightforwa...both automatic and manual data synchronization when internet access is available. The dashboard, meant for advanced analytics, should track: - Top Customers - Best-Selling Products - Delivery Staff Performance This dashboard will have role-based access to limit sensitive information. Additionally, the app should support importing a client database from Excel. Ideal skills and experience for this job include: - Proficiency in Android app development - Experience with offline functionality and data synchronization - Knowledge of creating role-based access systems - Capability to develop advanced analytics dashboards I am looking for a functional, simple, and cost-effective solution to enhance our daily sa...
I'm looking for someone to gather various data about food and beverage products from the internet. This includes information such as the manufacturer, marketer, country of origin, and ingredients. Key Responsibilities: - Research and collect data from official webs...various data about food and beverage products from the internet. This includes information such as the manufacturer, marketer, country of origin, and ingredients. Key Responsibilities: - Research and collect data from official websites and retailer sites. - Compile the data into an Excel spreadsheet. Ideal Skills and Experience: - Proficient in online research. - Experienced in data collection and data entry. - Familiar with food and beverage products. - Able to compile information into a clear and organized ...
Attached is a image of an icon. I would like a 256px x 256px version. It should have the same appearance but look good at that resolution.
I'm seeking a dynamic salesperson to market and sell our comprehensive suite of digital marketing services, which includes SEO, social media marketing, and Pay-per-click advertising. This role is commission-based, offering you the potential for significant earnings commensurate with your sales success. Key Responsibilities: - Drive sales across various platforms including Google Ads, Facebook Ads, and LinkedIn Ads. - Cultivate relationships with potential clients and negotiate sales. Ideal Candidate: - Previous experience in digital marketing sales is essential. - Possesses strong communication and negotiation skills. - Has a proven track record of meeting sales targets. Skills and Experience: - In-depth understanding of digital marketing services. - Experience with Google ...
...page-id=84%3A1486&node-id=149-2579&node-type=canvas&viewport=238%2C173%2C0.02&t=rYA2znUGosArvFcq-1&scaling=scale-down&content-scaling=fixed&starting-point-node-id=149%3A2579&show-proto-sidebar=1 Key Requirements: - All components from the old site must be retained and linked to the same DB, but with a new identity. - The design must be compatible with the Figma design and implemented using .NET framework 8, SQL server DB, JavaScript, and AJAX (in search). - Two language versions are required: Arabic and English. - All website functionalities need to remain unchanged, including user authentication, data reporting, real-time updates, and all existing links and data. Some links should be editable from the control panel to open external links ; So you...
I am looking for an experienced Moodle plugin developer to create a custom plugin that allows users to view uploaded documents directly in a separate tab without providing any option to download, print, or save the document. The plugin should enable users to open documents such as PDFs, Word files, and Excel sheets seamlessly while ensuring that the document cannot be downloaded or copied in any way. Security is a top priority, and the plugin must implement robust measures to protect the documents from unauthorized access or sharing. The plugin must be compatible with the latest version of Moodle and integrate smoothly with Moodle’s existing file management system. It should have a user-friendly interface for both administrators and users, ensuring a hassle-free experience. T...
I'm looking for a proficient Terraform developer to create a script for Google Cloud. We need the script to create these items 1. networking 2. GKE cluster with one node 3. permanent volume and claim for GKE 4. Postgres SQL service - needs to be accessible from GKE 5. API Gateway - if API URL is /example1 > run a lambda function - otherwise forward API request to /endpoint/{incoming URL) (a service running in GKE) 6. IAM Role Binding for Cluster Access
...retrieved quantities into a designated WPS Spreadsheet. Convert the raw quantity numbers into predefined ranges: 0 → Display "X." 1-5 → Display "1 tick." 6-10 → Display "2 ticks." 11-15 → Display "3 ticks." 16-20 → Display "4 ticks." 21+ → Display "5 ticks." Based on the SKU, place the transformed values into the correct boxes in the WPS Spreadsheet. 2. Macro for Creating Invoices Purpose: Automate the process of generating a printable invoice in a new tab within the WPS Spreadsheet. Filter Data: Remove any products (SKUs) that do not have a value entered next to them. Invoice Layout: Create a new tab in the WPS Spreadsheet with: The header section from the original sheet. Only the pr...
Strategy details Indicator – Range filter (DW) DonovanWall and Average True Range (RMA)  Keep above indicator inputs changeable in strategy  Buy Condition  First check this condition “Current candle Range Filter (RF) value – Previous Candle RF value should be greater than ATR value * (give option Changeable Percentage) and Previous Candle RF value – Previous previous candle RF value should be greater than Previous candle ATR * (give option Changeable Percentage)” and Current candle RF – current Candle High should be less than Current candle ATR * Percentage give option  If above condition met then check condition for entry  Entry condition  First current RF equals previous RF  Second Candle low should be less th...
...ranges: 0 → Display "X." 1-5 → Display "1 tick." 6-10 → Display "2 ticks." 11-15 → Display "3 ticks." 16-20 → Display "4 ticks." 21+ → Display "5 ticks." Based on the SKU, place the transformed values into the correct boxes in the WPS Spreadsheet. Example: If a SKU has 50 items in stock, the macro will place "5 ticks" in the corresponding cell in the WPS Spreadsheet. Trigger: Create a button in the WPS Spreadsheet that, when clicked, executes the macro. 2. Macro for Creating Invoices Purpose: Automate the process of generating a printable invoice in a new tab within the WPS Spreadsheet. Filter Data: Remove any products (SKUs) that do not have a value entered next to them. I...
Office The project you shared caught my attention. Thanks to my expertise in architecture and [specific field: interior design, 3D modeling, etc.] I believe I can add value to the dimension in this project. Throughout my 4 years of experience in architecture, I have worked specifically in 3D modeling. I have carried out similar projects before and used [tools such as Autodesk Revit, 3dsmax, AutoCAD] effectively in this process." "I look forward to discussing how I can help with the size of this project.. Thank you and I look forward to your feedback."
We are seeking an experienced Excel expert to assist in developing a dynamic and user-friendly Excel dashboard or summary tab for our HR team. The project will involve leveraging pivot tables and other advanced Excel functionalities to create an interactive and automated reporting tool that provides clear insights into key HR metrics. The ideal candidate will have a strong background in data visualization, formula optimization, and dashboard design to ensure efficiency, accuracy, and ease of use. Our goal is to enhance data analysis and reporting capabilities, allowing the HR team to make informed decisions effectively. Delivery flexible but ideally within 2 or 3 weeks
...rewarding journeys. Be it trying to solve a problem, creating value, or making people financially independent, the right choice of business idea plays an important role. The following are some innovative ideas that entrepreneurs can take up to leave their mark in the world of business: 1. E-commerce of Niche Products E-commerce will continue to grow, but success usually occurs when targeting a niche market. Selling a product that a particular audience would want-for instance, handmade products, eco-friendly products, or fashion items that are a little different-can make your business stand out. It's never been easier to get your online store up and running with Shopify and Etsy. 2. Subscription Box Services Subscription-based models clicked very well, therefore, p...
I'm in urgent need of a cyber security specialist who can perform thorough penetration testing on my React web application. The primary goal is to identify any potential security vulnerabilities, particularly: - Cross-Site Scripting (XSS) - SQL Injection - Cross-Site Request Forgery (CSRF) Your expertise in assessing these specific types of vulnerabilities will be crucial. The ideal candidate would also have experience in Quality Assurance, particularly with automated testing tools such as Selenium and Cypress. Your role will not only involve identifying security vulnerabilities, but also ensuring the overall code quality through automated testing. Please include in your proposal your relevant experience and any examples of previous work that may be applicable. Thank you.
I need a freelancer to set up a daily backup of my Microsoft SQL Server database from a dedicated Windows server to S3 AWS Storage. The backup files need to be compressed. Ideal Skills and Experience: - Proficiency in Microsoft SQL Server - Experience with AWS S3 - Knowledge of Windows Server - SQL database management - Data compression techniques
...this project, I leveraged the full potential of Microsoft Office to streamline business operations and enhance productivity. My expertise in MS Office applications, including Word, Excel, PowerPoint, and Outlook, allowed me to deliver high-quality results tailored to meet specific client needs. Key Achievements: Document Creation and Formatting: Created and formatted professional documents, reports, and proposals using Microsoft Word. Implemented advanced formatting techniques and customized templates to ensure consistency and professionalism. Data Analysis and Visualization: Developed complex spreadsheets in Excel to analyze financial data, track budgets, and visualize trends. Utilized formulas, pivot tables, and charts to provide actionable insights and support decisi...
...emphasize app download as the primary goal. * Create a clean, modern, and intuitive user interface that aligns with our brand identity. * Optimize the user journey to minimize friction between landing on the site and downloading the app. * Design engaging landing pages that clearly communicate the app’s value and feature strong download CTAs. * Ensure all designs are mobile-responsive and provide an excellent experience across devices. * Collaborate with our team to understand our app’s value proposition and key features. * Deliver final designs in Figma with organized layers and components for seamless handoff. Qualifications: * Proven experience in website design with a focus on user experience (UX) and app conversion. * Proficiency in Figma, with a portfoli...
I'd like to have a slide template design in ppt format matching logo design guidelines.
If you you bid to consider, please send me in message .. a sample infographic/chart based on the excel file I am attaching here: _____________________ I'm in need of a freelancer skilled in database analysis and Microsoft Excel. The project involves analyzing demographic data from an Excel spreadsheet. Key Responsibilities: - Conduct descriptive analysis on provided demographic data. - Create charts and infographics to illustrate findings. Freelancer Requirements: - Proficiency in Microsoft Excel. - Experience in data analysis, particularly with demographic data. - Ability to create visual representations of data (charts, infographics).
I need a professional to conduct regression analysis, ANOVA tests, and write a brief report on their findings. Key Requirements: - Perform regression analysis (exact type to be determined) and ANOVA tests - Write a concise report detailing the findings - Deliver the report in an Excel file Ideal Skills: - Proficiency in statistical analysis and software - Experience in writing analytical reports - Strong understanding of ANOVA and regression techniques
I'm seeking a talented Figma designer who can improve upon a provided sample. The focus will be on two card types that display key metrics. Key Requirements: - Improve design elements for enhanced visual appeal - Ensure a clean, modern, and user-friendly layout - Strict adherence to the provided mockups as inspiration Please avoid introducing random designs or themes that deviate from the sample's structure and intent. I'm open to your expertise, but if there are any doubts or clarifications required, please ask before proceeding to avoid misalignment with expectations. If the design meets expectations, we can collaborate further on additional requirements.
I'm looking for an experienced graphic designer who can also help me analyze financial data to identify trends. Key Responsibilities: - Utilize Photoshop and CorelDRAW to create engaging graphic designs - Use MS Excel to analyze financial data - Present findings in an appealing way using MS Powerpoint Ideal Skills: - Proficiency in Graphic Design software (Photoshop, CorelDRAW) - Advanced skills in MS Excel and PowerPoint - Experience in analyzing financial data - Strong ability to identify trends from data - Excellent graphic design skills Your main task will be to help me visualize the data trends through compelling graphic design and presentations.
...Document Management: OCR-based document reading for faster verification. Credit Assessment: Automated scoring with parameters like income, property value, and credit history. Workflow Management: Customizable approval hierarchies. Loan Management System (LMS): Repayment Tracking: Auto-reconciliation of payments. Customer Support: Service requests like account statements, loan closure. Analytics: Generate performance reports (e.g., NPA tracking, overdue reports). 5. Technical Requirements Platform: Web-based application with mobile responsiveness. Integration: APIs for credit bureau checks. Payment gateway and accounting software. CRM and external legal tools. Data Security: Compliance with data protection laws (e.g., GDPR, IT Act). Secure access with role-bas...
Need this recreated and add deals you can find for 2024 (leave the metrics to me) Need the PPT, and set up additional rows for 2024. So this turns into two pages probably. Then also need an excel backup thanks of the same data.
I'm seeking a researcher for writing a paper on "Role of ESG Criteria in inf..."Role of ESG Criteria in influencing Financial Decision-making". The paper already has introduction written and sources collected. The final wordcount should be more than 10,000 words. Key Requirements: - Mixed-methods research approach, with a focus on academic journals. - Emphasis on all aspects of ESG criteria: environmental impact, social responsibility, and governance. - Data collection and Excel calculations as necessary. Prefer someone with a background in economics or finance. The project is low-stress with a requirement of around 1500 words per week. note, strict adherence to NO AI use mandatory. Minimal use of AI for guidance is acceptable, but no AI-generated content sho...
I need assistance in recovering a deleted Excel spreadsheet file from my external hard drive. Ideal skills for this job: - Expertise in data recovery - Familiarity with external hard drive recovery processes - Proficiency with Excel and understanding of spreadsheet structures - Ability to work with urgency and confidentiality The project is time-sensitive as I need the file for an ongoing task. Please only apply if you have proven experience in file recovery.
I need a JavaScript-based URL redirect that includes the source URL and dynamic query parameter. The query and the source url information should be forwarded to the redirected page. Ideal candidates for this project should have a strong understanding of JavaScript, URL structures, and web redirection processes. Please also have the ability to test and troubleshoot the redirects to ensure all parameters are being correctly included and displayed.
...Python - Experience with Interactive Brokers platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation If you accept my term apply this task: Budget:Rs 900 I will give good review, if you complete my budget, Dont expect more money, Money will paid after complete the job successfully, dont ...
I'm looking for a skilled Snowflake developer with extensive experience in data warehousing. The project involves integrating various data sources, primarily AWS S3 and SQL databases, with Snowflake. Key Responsibilities: - Data Warehousing: You'll be primarily focusing on the data warehousing aspect of Snowflake. - Data Integration: Integrating AWS S3, SQL databases, DBT, and Snowpark with Snowflake. - Data Transformation: Your main use of dbt will be for data transformation. Ideal Skills: - Proficient in Snowflake, dbt, and AWS. - Experience with data warehousing and integration. - Hands-on experience with live projects using these technologies. - Strong understanding of data transformation processes. Successful candidates will have previous experience working...
...Sales Navigator and other digital marketing techniques. Target Definition Identify the Ideal Customer Create a detailed profile of luxury travel agencies and direct clients, with a focus on: - Agencies specializing in customized travel and exclusive packages. - High-level professionals and executives needing premium transportation services. - Segmentation - Classify agencies based on their specialization, such as high-profile events or partnerships with luxury hotels. --- Setting Up Sales Navigator - Lead List Creation - Compile a list of 50-100 potential agencies and clients using Sales Navigator. - Use keywords like "luxury travel," "VIP transport" for the search. - Using Notes and Tags - Categorize leads into relevant g...
I'm looking for a professional video editor based in the USA to edit 25 promotional videos monthly for my client. Each video is under 1 minute in length, and the editing style should be clean and professional. Details: - Monthly Requirement: 25 videos - Payment: $25 per video - Freelancing: Allowed - Editing Style: Clean and professional, suitable for promotional content. Reference and raw clip
I need a Python Data Analyst skilled in processing data from an SQL database and conducting descriptive statistics.
