Cell create formula will subtract total stock jobs

...power electronics product for industrial use. The current stage of development is in the prototype phase. For this project, I need a skilled professional who can help me with the following: - PCB Prototyping: I require assistance with the creation of the PCB for this new product. This includes the manufacturing of the board itself. - Creation of Test Plans: I need an expert who can help me create comprehensive test plans for this new product. This includes both hardware and software testing. Experience in creating test plans for electronics, would be highly beneficial. - Final Testing & Validation: Once the PCBs are produced and the test plans are in place, I would need a professional who can assist me in the final testing and validation of this new product. This include...

I want someone who can create a database in Excel/Access for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List) with the field names I will provide. 2- A list of all Contracts with the field names I will provide. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. The database should have a main page, with link to the above mentioned list pages plus Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages. For Add New Invoice page, I should be able to add an invoice details in it, and if it's related to a contract or purchase or...

I'm on a journey to create a full tarot deck consisting of both Major and Minor Arcana cards, amounting to a total of 78 exquisite pieces. - Art Style: I envision the art to be distinctly illustrative, rich in detail, and creatively showcasing each tarot's unique symbolism. - Design Requirements: I have comprehensive notes for each card to guide your design process, ensuring the resulting artwork aligns with the narrative and energy I envision. - Skills and Experience: Ideally, I am seeking a seasoned graphic designer with prior experience or a strong interest in tarot. Familiarity with symbolic representation and the ability to intertwine it coherently within the art is imperative. This project demands not only artistic talent but also a keen understanding of t...

Functionality: Data Collection: Retrieve historical stock data (price and volume) for a given set of stocks from a reliable financial data provider (e.g., Yahoo Finance, Alpha Vantage). Store the data in a suitable format (e.g., CSV files or a database). Data Preprocessing: Clean and preprocess the collected data, handling missing values and ensuring consistent formatting. Calculate necessary technical indicators, such as moving averages (e.g., 50-day, 200-day), Relative Strength Index (RSI), and trading volume. Technical Analysis: Implement functions to identify bullish signals based on technical indicators, such as: Moving Average Crossovers: Detect when a shorter-term moving average crosses above a longer-term moving average (e.g., golden cross). RSI Oversold: Identify s...

Just create 2 api to pass value. WOrk with ftp only. Simple work

...Merchant can create shop and promotion. User will get 0.1% of their total sales, check v3. - shop field (brand name, address, website, whtasapp, facebook, description, category, City, how many brands, open for agency?(radio button)) - promotion field (title, normal price, now selling price, description, expire date, point weight - V4 user can follow shop to see their promotion in feed, also can apply to be their agent. - agent can share the promotion with uniqic referral link which will earn 2% v3 - point system- user purpose any thing will get point same as the price, usd 23.12, will get 23.12 points. if point weight is 2, then he will get 46.24 point. - when userB purchase, user A will get 1% profit earning - when ANYONE share...

I have developed a new brand named Doinks. For one of my in store display, I have developed a product holder that needs a creative way to inform of the flavors. The first flavors are a total of 5. The look I want is produced all over the country by Trader Joes sign painters. See samples below. This art could be painted or penned on an 8.5" X 11" canvas or art board etc. I can scan and use as 1 layered image or could be a fully layered document The finished size may be 2" Tall by 10.5" Wide

I'm seeking a creative illustrator to bring to life two children's books, using the lyrics of my viral songs "Little Brown Girl" and "Little Brown Boy". Whoever can create the best book covers for both books according to the style and description I've provided will be chosen to illustrate both books in it's entirety. Total budget for both complete books is $650. There will only be 12 illustrations for the girl book and 13 illustrations for the boy book. Here are the character descriptions for the 3 boy characters: Character A: Age 7, Full curly afro, caramel-skinned, on the right of the cover Character B: Age 7, Dread locks, dark-skinned, in the center of the cover Character C: Age 10, Braids, light skinned, on the le...

As a growing company, we've fully set up our QuickBooks Online but it's in need of a thorough review and ongoing management. We're looking for a QuickBooks expert who can help in the following areas on a monthly basis: - Setting up sales and expenses - Managing stock - Budgeting Your responsibilities will involve keeping the system up-to-date, ensuring financial data consistency, and providing insights to support our decision-making process. The ideal candidate for this role would be an experienced accountant with previous QuickBooks Online experience. Knowledge of other accounting tools and financial acumen are also a plus.

Build an ISO for a raspberry pi (with cellular notecard) to scan for unique cell phones in a specific range and log the unique phone ID and timestamps/ping (distance) from the raspberry pi and store in mysql database using cellular adapter.

I need some to create a letter head and upon completion i need editable word file and print ready file

...who can build a feature-rich e-commerce app that will work seamlessly on both Android and iOS. The app will cater to a WordPress-based online shop, ensuring customers have a smooth shopping experience with access to unique features. Key Features & Functionalities: - User Registration & Login: A seamless and secure process for users to create accounts and log in. - Push Notifications: Utilizing notifications to engage with users and keep them updated with the latest offers, deals, and more. - Connected to WordPress Shop: The app should effectively fetch and display product data from the existing WordPress shop, ensuring real-time updates of the product catalog. - Custom Stock Management: Admin should have the capability to manage and update stock...

I'm eager to dive into music production, particularly focused on the world of dubstep and trap. As a total beginner with Ableton, I'm looking for a knowledgeable and patient tutor to guide me through the process. Specifically, I'm most interested in mastering the art of beat making, and polishing my tracks through mixing and mastering techniques. Key Points: - No prior experience with Ableton, so the teaching needs to start from the basics. - The focus will be on the drill/trap subgenre of dubstep and trap. - The ideal candidate should be able to explain concepts clearly and have a good understanding of beat making and mixing/mastering in the context of drill/trap. Your guidance is crucial, as my aim is to eventually produce high-quality, professional-soundi...

...producer who can create a highly complex and experimental beat for my upcoming EDM trap dubstep song. The beats should be energetic and upbeat, delivering a blend of intensity and rhythm that will captivate my listeners. Key Requirements: - The beats should be crafted using electronic effects and samples, reflecting a modern and edgy sound. This element is crucial to the overall vibe of the track. - The beat structure should be highly complex and experimental, pushing the boundaries of conventional EDM trap dubstep beats. I'm looking for something that stands out and excites. Ideal Skills and Experience: - Proven experience in producing EDM trap dubstep music with a portfolio of energetic, experimental, and upbeat tracks. - Proficient in using electronic effects an...

I'm in need of a skilled professional who can provide me with HD screenshots of successful stock trades made on the Robinhood platform. I will need at least 50 screenshots in total. The screenshots must include the following key details: - Trade date and time - Profit margins - Stock symbols and volume This project requires a meticulous and detail-oriented individual who is capable of accurately capturing and presenting the specified information. Experience with stock trading or familiarity with the Robinhood platform would be advantageous, but not mandatory. Thank you in advance for your help.

...2D animation professional. You will be creating a 2D-style video for the primary aim of promoting my brand. The target audience for this video is primarily adults. Key Responsibilities: - Develop a visually appealing and engaging cartoon-style 2D animation video - Clearly convey the brand's message and values - Ensure that the video is suitable for an adult audience Ideal Skills and Experience: - Extensive experience in creating 2D animations, particularly in a cartoon style - Proven track record of developing successful brand promotion videos - Excellent understanding of adult audience preferences and sensibilities - Strong communication skills to understand and translate my brand's core values into animation Your engaging and professional animation work will...

...automate a complex process. As of now, I manually gather numerical data from a variety of unstructured sources like images, text, and PDFs. This data includes formulas and is stored both on my local computer and the web. At present, I get ChatGPT to convert this data into a table which I then paste into excel. I do calculations in excel to find out what percent each ingredient is of a total formula. Then I create a new entry into a table in Airtable and paste this data into a different table in Airtable which references the first table. I need someone to automate this data extraction process, calculations and entry into two separate Airtable tables so I can do it repeatedly myself. I work in a standardised operating environment for work so ideally I need a web based...

Thank you, Mr. Nicola, for considering 8veer for your project. Below ...designers, to ensure efficient use of resources. • Risk Management: Identify potential risks and develop mitigation strategies to address them proactively. • Budget Estimation: Provide a detailed budget to ensure all aspects of the project are financially accounted for. • Stakeholder Communication Plan: Develop a communication plan to keep all stakeholders informed and engaged throughout the project. Total Due Now: £200.00 We are committed to delivering a comprehensive project plan that meets your needs and ensures the successful launch of your financial blog. Please let us know if there are any further instructions or requirements. Thank you for the opportunity to work with you. Best re...

...Description: We are seeking a talented designer to create a visually stunning, engaging, and informative page that highlights our distinctive vanilla cultivation and preparation process. The page should take viewers on an immersive journey through our vanilla's lifecycle, from the lush fields of Maroantsetra, Madagascar to the final crafting of our premium product. The designer should use the attached infographic, process flow diagram, and vanilla cut styling guide as visual references to creat our own infographic ou design steps shaping the page's content and design. These resources provide comprehensive details on our process, including key steps, techniques, timing, and quality control measures. Project Goal: The ultimate goal is to create a page that educa...

I need historical stock prices and income statement data, deliver python script to collect this data for an arbitrary stock from google finance.

...installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - Automatic calculation of the total payment owed to each installer based on the number of jobs completed. 3. **Customer Information:** - Columns for cust...

...the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria for merging specifically adjacent cells - Excellent problem-solving skills and attention to detail I will provide the working data sheets and a detailed explanation of the rules for adjacency-based merging to guide the creation of the macro. Any prior work regarding Excel macros for similar data manipulation tasks ...

Need a native Croatian translator who can translate from Croatian to English manually and accuracy. Please bid only native bidders. No agencies or firm. Total: 7 pages (100 words max per page) Budget: $2/ each page Deadline: 24 hours

Need a native Portuguese translator who can translate from Portuguese to English manually and accuracy. Please bid only native bidders. No agencies or firm. Total: 7 pages (100-150 words max per page) Budget: $2/ each page Deadline: 24 hours

...eCommerce platforms such as Flipkart and Amazon. The primary task is creating a website from scratch intended for product sales, with clear and appealing design, optimised for conversions and customer ease of use. Key Tasks: - Design and construct a new website for product sales from scratch. - Optimize for user-friendly navigation, SEO, and product presentation. The ideal freelancer for this job will have: - Proven experience in creating successful eCommerce websites. - Strong knowledge of site design, user experience, and SEO principles. - Previous experience managing Flipkart or Amazon product listings is beneficial. - Understanding of inventory management on eCommerce platforms. Make your bid if you are passionate about creating top-notch online shopping experiences and...

### Project Name: Optimize Scrap Metal Supply Chain ### Project Description: I am from Turkey and need a top-notch scrap metal consultant to streamline our supply chain. The consultant will work online as a freelancer and focus on: - **Metal Sourcing**: Finding reliable suppliers, getting total prices, and negotiating deals. - **Logistics**: Finding transportation solutions and ensuring CIF delivery to Turkey. Ideal skills include in-depth knowledge of the scrap metal industry, excellent logistics management, superior negotiation abilities, and strong communication skills. --- Feel free to use this refined version in your freelancer project description.

I am looking for a professional who can build a web application that automates the creation of Google Sheets formula...a professional who can build a web application that automates the creation of Google Sheets formulas. Requirements: - Build a web application that allows me to input a plain text command in a Google Sheets cell (i.e., I type "= find the mean of the data above". - Translate the plain text command into a Google Sheets formula using the ChatGPT API. - Authenticate and send the formula to Google Sheets for execution. Ideal candidate: - Proficient in web application development. - Experience with integrating APIs, particularly ChatGPT. - Familiarity with Google Sheets automation and formula creation. - Strong understanding of user interfa...

I need you to go into my Clickfunnels account and make a simple video landing page. However i need to have a purchase button that drops down at a particular time point in my video. You must have extensive experience in Clickfunnels because i will utilize you in the future for more complicated pages within Clickfunnels

I'm seeking a skilled programmer, proficient in Python, who can develop a trading algorithm according to my exact specifications. The algorithm itself must integrate with the TD Ameritrade platform and take into consideration an array of varying factors such as: - Historical stock prices - Market trends - Earnings reports - The presence of candles twice as large as the previous candle sma cro - Ignoring red and green bars - 8 sma crossing 21 at any time frame - 20 sma crossing 200 at any time frame - 50 sma crossing 200 sma - Double tail bars at any time frame A solid understanding of financial markets as well as a proficiency in developing trading algorithms is necessary. This task is intricate and requires meticulous attention to detail, only experienced developers should...

...promote my Etsy shop, as well as open my google business shop. I have an inventory of handmade and unique items, and I need help with both platforms for better visibility and improved customer engagement. Your tasks would primarily include: - Inventory Management: Keeping track of existing inventory, update listing details if necessary and coordinate to replenish stock. Knowledge of Etsy’s listing system is necessary. - Promotion: Create and execute Social Media promotion strategies for both Etsy Shop and Google Business. You should have experience in leveraging different social media platforms for business promotion. Ideal candidate would have prior experience managing Etsy shops and Google Business listings, with proven results in increasing traffic and convers...

We are seeking a talented animator to create a captivating 1-minute video showcasing our innovative transportation solution. This project involves animating a shuttle moving through a tube, aiming to revolutionize how people and goods travel. The animation will serve as an introduction to our invention to the general public, highlighting its unique features and benefits. *Requirements:* - Experience in creating engaging animations, preferably with a portfolio showcasing similar projects. - Proficiency in Blender, as the models for the shuttle and environment are pre-designed and available in Blender format. - Ability to convey the concept of futuristic transportation vividly and convincingly to a general audience. - Creativity in animation to ensure the final video is intri...

I am in need of a proficient editor and proofreader with excellent formatting skills for my personal documents. - I have a total of 2 documents that require attention. These documents are a mix of Word and PDF formats, and I require them to be meticulously edited, proofread, and professionally formatted. - The primary purpose of these documents is personal, so I'm seeking someone with an understanding of how to maintain a casual yet polished tone. Your expertise in English grammar, spelling, syntax, and an eye for detail is critical for this project. Experience in document formatting (maintaining consistent font types, sizes, and spacing) is also highly desirable. Proficiency in both Word and Adobe Acrobat is a big plus. Your ability to meet deadlines and communicate effectiv...

...experience professional to create this type of videos We need Someone to add in our team who brings unique set of skills and idea to the table. We only have products pictures so the animate of the product will be recreated from a 'fake 3d' of the .png image You must find the video to use free from copyright so it's need for us for you to have a stock repository like

...Filipina social media expert to create engaging and inspiring content for women aged 40 and over. Your main tasks will be to create 2 different posts every Monday, Wednesday, and Friday, and post them 3 times per week across Facebook, Instagram, Twitter, and LinkedIn. In addition to this, you will also need to actively engage with our audience, liking, commenting, and responding. Key Requirements: - Social Media Savvy: Proficient in using Facebook, Instagram, Twitter and LinkedIn, with a good understanding of what makes content engaging on each platform. - Content Creation: Ability to create original, inspirational quotes, educational tips, success stories, and motivational posts. - Design Skills: Familiarity with tools like Canva or similar apps to ...

I am looking for a developer who can build me a SaaS app that will transform AI-generated text into undetectable AI text. The app should include three modules: AI Humanizer, AI Detector, and AI Generator. AI Humanizer: This module will convert AI-generated text to undetectable AI text that can bypass AI detectors like Originality AI, Undetectable AI, GPTZero, ZeroGPT, and Turnitin. It would also ensure that the transformed text maintains the original meaning and context while appearing human-written. AI Detector: This module will detect if the text given by the user is AI generated or not. AI Generator: This module will be used by user to produce high-quality, undetectable AI-generated content, such as essays and articles. Please bid only if you have extens...

...Recognition - API integration with Google services This project will require rigorous testing to ensure quality and functional assurances. I am looking for experts with a keen eye for detail and the ability to deliver under deadlines. 1. Programmer has to use our web app url as attached in WebView framework of android. We need to provide link for camera and upload from gallary feature from many pages of our web app. kindly let us know how will programmer provide it?. 2. We only need use camera and file upload from mobile gallary into our webserver file folder via ftp and related data entry in sql server database. we will provide necessary tables, fields, data types, views and database connection strings to programmer. We will provide the design which wi...

...Buttons: Treasury Deposit/Withdrawal: A button that, when clicked, presents a dialog or an input field directly on the sheet to enter the deposit or withdrawal amount. Shipment: A button that allows users to input the following details: gangName memberName itemOrdered itemQuantity weightUsed currentWeight weightAfter orderedBy Automatic calculation of the total weight and price for each item (a list of items, their prices, and weights will be provided). TreasuryDB: A dedicated sheet to track all deposit and withdrawal transactions. ShipmentDB Sheet: A dedicated sheet to store all shipment records, including item details, quantities, weights, and prices. Additional Details: User-friendly interface for ease of data entry and retrieval. Automated calculations and data pr...

I have a list of 54 URLs, and I need someone to grab 2 images from each of them, convert them to .jpg and save them to a folder named 'Images'. Key Requirements: - Grab 2 images from each of the 54 provided URLs (all similar to below URL). 108 images in total. - Example URL is - Grab the biggest version of the image from lines 6613 and 6667 of page source code - Convert all grabbed images to .jpg from .webp - Save them to a folder named 'LC Images' - The images should be saved in the original size, with no resizing necessary. - See attached screenshot

...3. All the products details like: Product Name, photo, description, features, pdf (data sheet), warranty information, stock (available quantity), sale prices etc. can be uploaded directly through portal and mobile app and also can be uploaded through excel sheet with serial number of all products. 4. Customer can see all the uploaded products and can request for quotation. There is no need to show the available quantity (stock) to customers. 5. Admin can see the requested quotes where the prices and quantity will be reflected of all the products in quotation. Admin can edit the prices manually and can share and download the requested quotation to anyone. 6. Admin can create multiple sub admins and can assign different rights to them as he wants. 7. After app...

...only. (No commercial licenses for stock photos needed). Key requirements include: - Utilization of both stock and available video clips that you source/find. - *** I will provide a detailed list of the types of clips that should be included in the video. *** - Tone: The video should exude an inspirational vibe throughout the entire duration. It should speak to the soul, lifting spirits and encouraging reflection, HOPE, PEACE, JOY. - Color Scheme: The color palette for this video should be bright and vibrant. This choice is intentional, meant to further enhance the uplifting and positive nature of the video. The ideal candidate for this task should possess: - Proficiency in video editing tools and techniques. - Experience in curating and blending stock v...

I'm seeking an experienced Amazon account manager to take over and optimize multiple aspects of my Amazon account. - Product Listing and Optimization: Your role will include adding new products to the store, ensuring that listings are well-optimized using SEO and relevant keywords. - Inventory Management: You'll be responsible for keeping track of product stock levels, coordinating with suppliers, and ensuring a healthy inventory turnover rate. - Advertising Campaigns: You'll be tasked with creating and managing advertising campaigns on Amazon, ensuring that they are cost-effective and drive sales. Ideal candidates should have hands-on experience with Amazon seller accounts and possess a deep understanding of e-commerce best practices. Prior experience with...

...parent profile Gender Religion Father's name Mother's name Mobile number Date of birth Address Image (print in pdf) 4. I have some issue to fix on result system. Need to modify class name tyme 1. Compulsory (WIll add full marks and GPA with Result) 2. Optional (WIll add full marks and GPA with Result) 3. Additional (Just to show on Marksheet, (WIll add any marks and GPA with Result) example: Drawing 4. 4th Subject (WIll add marks above 40 and GPA above 2 with Result (need to set during add subject) Result will show Total mark (All marks + above 40 from 4th subject) Result will add with and without 4th subject (-2 GPA) Could you please review my discussion, here is summery plz Ideal candidate...

I'm having a tough time with my powerapp project and need an expert to step in. There a...and need an expert to step in. There are some crucial issues that need to be fixed quickly. These include: - Data not saving properly - Difficulty in integrating external APIs - Improving formula optimization I've attempted to save multiple screens to PDF and email it, as well as search for employees in my organization but am currently failing. This work needs completion ASAP. Therefore, I am seeking a freelancer who understands powerapp projects and their workings, down to the smallest detail. Your expertise in correcting data saving issues, integration of APIs and mastery of formula optimization will be crucial to get this project completed successfully. If this i...

Hello, Looking for someone to create video ads from a mobile game, you will need to play the game, get footage from and then give me 5 horizontal video and 5 vertical ads each video needs to be between 15-30 seconds long If you understand that you need to create everything from scratch and can do it in a short time frame please type GREEN at the beginning of your proposal. Proposals without it will be ignored.

...for you. It will only result in a few hours of work and poor reviews. Instead, we want a person that is patient and is willing to slowly prove that they are better, more capable and "hungrier" than the people we currently are using. We have grown from one, to many locations in two years, and we need to upgrade the team with competence. Marketing wise, we rely over 90% on inbound calls from Google. We want to increase our platforms to include Bing, Yelp Trip Advisor, and so on... We also want to work closely to get really high ranked backlinks (preferably not a birdwatcher's blog from Siberia with 2 followers). Everything we post is authentic, including pictures, AI and videos. We never want to see a cross-post on another website anywhere in the world of the same...

I'm seeking a skilled freelancer to help me standardize and improve the formatting of my Google Sheet. The main focus will be on creating consistent cell styles for optimal readability. Specific requirements include: - Implementing a minimalist and clean design theme throughout the sheet - Creating a uniform style for all cells, making sure the data is easy to understand at a glance The ideal candidate will have: - Proficiency in Google Sheets, with a strong understanding of formatting options and best practices - A keen eye for design and the ability to create a clean, minimalist look - Experience with data visualization and turning complex information into easily digestible formats If you're confident in your ability to transform a spreadsheet i...

IMPORTANT: The developer MUST be able to discuss the project verbally over the phone. I'm looking for a skilled website developer to enhance...with rectify issues we have had with the website. The key tasks include: - Redesign of the existing website for improved visual appeal and user engagement - Addition of new pages, particularly product & service showcase pages - Rectify problems with the website The project will require sourcing and integration of high-quality building related images and videos. You are expected to source these assets from stock image and video libraries. Experience with graphic design, website development and familiarity with stock image libraries is essential. Prior experience working on similar projects is highly desirable. L...

I have a project that requires the development of a robust Android application. Key Requirements: - Development of a comprehensive Android application with 18 screens - Integration of 12-14 APIs to ensure seamless functionality - Design and implementation of a user-friendly UI/UX - Optimization for performance and security Designs, icons and api's will be provided by us Time 10 days

I'm looking for a professional to edit 150 raw images and videos for my e-commerce website. The main goal of this project is to enhance product visibility and create a consistent brand look and feel. Key Requirements: - Edit images and videos in a clean and minimalist style - Highlight product details and textures - Showcase product usage or application The ideal candidate for this project should be experienced in e-commerce image and video editing, and have a portfolio that demonstrates their ability to create visually appealing content that aligns with the brand guidelines. A good understanding of e-commerce best practices and an eye for detail is crucial.

I need a building plan for an 860 Sq ...Floor: Parking space that accommodates both cars and bikes, along with a 1 BHK unit. - 1st and 2nd Floor: Each floor should have a 2 BHK unit and a 1 BHK unit. There should be a total of 3 bedrooms in each of these floors. - Design Style: I'm looking for a modern design for the building. Also looking of the Valuation of the building with seal and signature Ideal Candidate: - You should have a strong background in architectural design, especially for odd sites. - Experience in designing multi-story buildings with a modern aesthetic. - Knowledge of parking space design and optimization for both cars and bikes. - Able to create detailed floor plans and elevations. If you're confident in your ability to meet these requirements,...