Excel vba sql based column value jobs
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.
I'm looking for a creative and innovative designer to craft a promotional brochure for a product aimed at teachers and prof...teachers and professors. The brochure should effectively communicate the product's features and benefits in a style that's both engaging and professional. Key Responsibilities: - Design a brochure that is visually appealing and aligns with an innovative and creative style. - Understand and target the content towards teachers and professors. - Use a formal yet approachable tone to convey the product's value. Ideal Skills: - Experience in designing promotional materials, particularly for the education sector. - Strong understanding of visual design principles and creative thinking. - Excellent communication skills to understand project req...
...sizes. Which requirements (specifications) do the machines need to fulfill? Select suitable machines --> internet/catalogue research If you need specialized machines or equipment that have to be especially designed for your application (e. g. assembly stations) please make qualified assumptions about the costs and process times. What is the assembly sequence? What are your assembly steps? Show the value chain in form of a flow chart for the inhouse production. Note: There are many different options for the design of your assembly processes: You have several numbers of similar assembly stations. On each station you assemble one product from all single parts to the final product. You have a assembly line where one main part is forwarded an on every assembly station 1 or a few pa...
I'm in need of a skilled professional who can compile Data from a Website for me. Ideal Skills: - Proficiency in data collection and analysis - Familiarity with Food Delivery Platforms - Competence in using Excel proficiently The final product should be delivered as an Excel spreadsheet that I will provide. Please ensure the data is well-organised and easy to navigate. NOTE: THIS PROJECT HAS A FIX PRICE OF **INR 600**, ONLY APPLY IF YOU´RE OKAY WITH THAT. Please, start your Bid with "I Can Do It"
I am looking for a Python expert to help build an algorithmic trading strategy focused on trend following in the stock market. Key Requirements: - Design and implement a trend following algorithm using Python. - Tailor the strategy specifically for the stock market. Ideal Skills: - Extensive knowledge and experience in algorithmic trading. - Proficient in Python programming. - Familiarity with the stock market and trend following strategies. Please include examples of your previous work in algorithmic trading when you bid.
We are developing a Hospital Management System (HMS) using Odoo, where the Doctor Dashboard is a critical feature. The goal is to dynamically display all patient records in the Doctor Dashboard, enable doctors to record consultation details seamlessly, and maintain a consultation history log for each patient, similar to how activities and records are logged in Odoo CRM for quotations/invoices. Current Problem The current implementation does not fulfill the following key requirements: Patient Listing: The Doctor Dashboard does not dynamically display all patient records from the Patient model. Key patient details (e.g., Name, DOB, Email) are missing or not properly displayed. Workflow: The workflow to navigate from the dashboard to a consultation form for recording vitals, prescription...
...looking for a talented frontend engineer with experience in React and other modern frontend technologies to work on an exciting 45-day project. The goal is to build a polished, interactive dashboard based on a Figma high-fidelity design. About the Project: The project involves creating a high-quality dashboard that is visually appealing, responsive, and user-friendly. We’ll share a sample of the Figma design to give you a clear idea of what we’re aiming for. Your expertise will be critical in translating this design into a functional product. Responsibilities: Implementing the dashboard UI based on Figma designs. Writing clean, scalable, and reusable code. Ensuring the dashboard is responsive and performs well across devices. Collaborating wi...
...consequently, the positive and negative fluctuations that Bitcoin will have over the next 7 days. This data will be used to find a historical time series from the past that had percentage fluctuations (not based on price levels) as similar as possible. Once the most similar 7-day historical series to the predicted future series is found, the date of the historical series should be displayed on the screen. The entire software must be fully "commented" and explained in every function and calculation, clarifying the practicality and utility of each element within the model and highlighting the added value it provides. The software must include a frontend to visualize the period (between two dates) that most closely resembles the one analyzed by the forecasting. It ...
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.
...communication abilities, and the initiative to handle tasks independently. Responsibilities: Daily Tasks Check and respond to booking requests. Update and maintain the calendar with confirmed appointments. Send appointment reminders to clients. Handle rescheduling or cancellations promptly. Weekly Tasks Review the upcoming week’s schedule for conflicts or gaps. Prioritize bookings for high-value clients. Provide a summary of all scheduled sessions and pending requests. Required Skills Strong communication skills in English. Experience with scheduling tools (e.g., Google Calendar, Calendly). Attention to detail and ability to manage multiple tasks. Familiarity with client communication platforms (e.g., Discord, WhatsApp). Highly organized and capable of prioritizing e...
I'm looking for a web-based program that can help me keep track of job participants, their payment statuses, and visualize data through a bar chart. Key Features: - Each participant should have a unique ID for identification. - A section to add new participants, requiring their Name and Contact Details, Date Joined and Payment Status. - Capability to indicate how many people are involved in a job and how many have made a payment. - A chart to visualize the number of participants added each month. Access: - Users should be able to log in with a Username and Password. Ideal Skills: - Proficiency in web development. - Experience with data visualization and creating interactive charts. - Knowledge in user authentication systems.
I'm looking for a skilled professional who can integrate Telegram's API with Excel. The goal is to download real-time data regarding Bitcoin trades from a specific channel, focusing primarily on market analysis. Key Requirements: - Set up a system to download market analysis related to Bitcoin trades in real-time from Telegram. - Ensure the data is properly formatted and easily readable in Excel. - Implement error handling and data validation to ensure the integrity of the downloaded data. Ideal Skills and Experience: - Extensive experience with Excel, including knowledge of advanced functions and data manipulation techniques. - Proven track record of working with Telegram's API. - Strong programming skills, particularly in languages commonly...
Tagline: "Professional Logo for Tube Fittings, Valves, and Accessories" Project Description: We are seeking a talented logo designer to create a professional and eye-catching logo for our website, Excel Flow Control. Our company specializes in providing high-quality tube fittings, valves, and accessories for various industries. The logo should reflect our expertise and commitment to excellence in the flow control solutions industry. Key Requirements: Brand Name: Excel Flow Control Industry: Industrial and Engineering – Tube fittings, valves, and accessories Design Style: Modern, sleek, and professional with a hint of industrial elements to reflect our niche. Color Scheme: Preferably shades of blue, gray, or metallic tones, but we are open to creati...
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
