Find Jobs
Hire Freelancers

Editing a complex MS Excel formula

$10-30 AUD

Completed
Posted over 6 years ago

$10-30 AUD

Paid on delivery
Hello, I have an Excel formula that is used to work out prices for printing on shirts. The Formula is quite complex as different quantities and colours equal to different prices. Changes I need: *Screen Discharge/Specialty Inks If you select Screen Discharge/Eco in the Printing type (D3-7) on the Printing tab. It uses the EXACT same pricing as Screen printing but ads 20% onto the price * If you select Digital Printing or Digital Discharge for Cell D3 in the Printing Tab you can not select any more than 0 and 1 colour for Cells D4-7 when Screen printing is selected * Basic embroidery quoting Is it possible to set this up similar to how Screen printing etc is? On the Embroidery Tab, if a set up is selected in Cell D3-7 then it will add the price from INK PRICES tab P52 / P53 and input the price to DATA tab L36 (from P52 price) / M36 (from P53 price) On the Embroidery Tab, if you select Stitches E3-7 it will grab the pricing from INK PRICES Tab and the formula will be based depending on the quantity and stitches. Example, if there is a qty of 5 and 1-5000 stitches is selected then it will grab the price $3.25. It will input this data on the DATA tab L37-41 I will send the file to you if interested and then we can chat more
Project ID: 15247537

About the project

30 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much. Relevant Skills and Experience Excel automation Proposed Milestones $25 AUD - 100% milestone and release upon completion
$25 AUD in 1 day
4.9 (75 reviews)
5.7
5.7
30 freelancers are bidding on average $37 AUD for this job
User Avatar
Expert Excel Programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) Relevant Skills and Experience I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. Proposed Milestones $100 AUD - Please pay me once the job is 100% complete
$100 AUD in 2 days
5.0 (921 reviews)
9.4
9.4
User Avatar
Hello Sir, I have read your project requirement and i can deliver your project with 100% quality . please give me chance to work on your job. Relevant Skills and Experience I have more than 7 years of experience in Data Entry, Editing, Excel, Microsoft Office, PHP. Please see my profile i have deliver almost 270 projects with 100% client satisfaction. Proposed Milestones $100 AUD - Project completion
$100 AUD in 1 day
4.9 (629 reviews)
8.6
8.6
User Avatar
Hello, I’m an Excel expert and I would like to help you with your formula. Please check my profile and contact me to discuss. Regards.
$30 AUD in 1 day
5.0 (504 reviews)
8.0
8.0
User Avatar
Hello, I read your requirements very-well and i i have 10 years working experience with spreadsheet excel. I Hope you will give me a chance to do work with you. Thank you Relevant Skills and Experience I have 7 years experience. Proposed Milestones $50 AUD - Milestone
$50 AUD in 1 day
4.9 (349 reviews)
8.0
8.0
User Avatar
Hello, I am ready to start. Can you please provide your excel file? Thank you and Best regards, Hoang Relevant Skills and Experience Excel Proposed Milestones $70 AUD - Excel formulas
$70 AUD in 3 days
5.0 (195 reviews)
7.3
7.3
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Habilidades y experiencia relevante VBA/Formulas Htos propuestos $30 AUD - final delivery
$30 AUD in 0 day
5.0 (332 reviews)
7.5
7.5
User Avatar
Hello I am an excel expert and would like to bid on the project posted by you. I have completed more than 100 projects in excel. Will send sample of my work, if requested. Rgds Rohit Pithisaria Relevant Skills and Experience Excel VBA Proposed Milestones $55 AUD - Milestone
$55 AUD in 1 day
4.9 (124 reviews)
6.7
6.7
User Avatar
Hi, Pretty much interesting challenge. Can you share the spreadsheet so I can directly give you more accurate opinion and solution? Regards, Daniel Relevant Skills and Experience I have more than 15 years experience working on excel spreadsheet and its automation. Have 100% completed project rating, 100% on time and 100% on budget Feel free to review my profile page. Proposed Milestones $30 AUD - Completed formula as described and discussed I am only 3 hours behind you, can we discuss this now?
$30 AUD in 1 day
5.0 (194 reviews)
6.8
6.8
User Avatar
I'm an expert in .Net technologies and SQL Server. I have been working in software development for the last 20 years I'm a specialist in web solutions and desktop applications Habilidades y experiencia relevante I'm an expert in .Net technologies and SQL Server. I have been working in software development for the last 20 years I'm a specialist in web solutions and desktop applications Htos propuestos $25 AUD - Milestone
$25 AUD in 10 days
4.9 (38 reviews)
5.4
5.4
User Avatar
Hi, It's pretty interested, pls send me the relevant files, i will go thru and discuss soon, Hope to support you to success this project thanks thushara Relevant Skills and Experience Data Entry, Editing, Excel, Microsoft Office, VBA Proposed Milestones $25 AUD - once done
$25 AUD in 3 days
5.0 (42 reviews)
5.3
5.3
User Avatar
Hi, i can help you with this project, please let me know more about it :) .
$30 AUD in 1 day
5.0 (28 reviews)
5.3
5.3
User Avatar
I supposed you use macro function to make multi pricing of your printing company. Relevant Skills and Experience I am a macro programmer and I did some projects that may have similar function like yours before. Proposed Milestones $30 AUD - Create some macro functions
$30 AUD in 1 day
5.0 (43 reviews)
4.6
4.6
User Avatar
Dear Hiring Manager, I have read the project description and understand that you would like to setup a formula for price calculation. I am a professional with extensive experience in excel and have worked with complex formulas. I have recently closed few projects in excel. I will create the formula for you. Looking forward to hear from you. Regards Chintu
$29 AUD in 1 day
5.0 (8 reviews)
3.9
3.9
User Avatar
Hi. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now Relevant Skills and Experience I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle Proposed Milestones $50 AUD - complete
$50 AUD in 2 days
4.6 (20 reviews)
4.3
4.3
User Avatar
Dear I am an Excel professional having hands on expertise in applying advanced excel formulas I will do your project as per your requirements by applying advanced excel formulas . Relevant Skills and Experience Excel
$33 AUD in 1 day
4.7 (12 reviews)
4.1
4.1
User Avatar
30 aud for 1 days working Relevant Skills and Experience I have over 10 years of experience and knowledge of accounting and good skill data entry, good at Office software and Xero, Myob, Quickbooks software all so Proposed Milestones $30 AUD - Milestones $35 AUD - payment
$35 AUD in 1 day
4.6 (7 reviews)
3.7
3.7
User Avatar
very interested to work for i can assure you that if you provide me the job i will complete this process within the stipulated period completing as per your specifications. Please send the DETAILS Relevant Skills and Experience Data entry, Exel Proposed Milestones $10 AUD - Data entry
$10 AUD in 1 day
4.9 (18 reviews)
3.3
3.3
User Avatar
I will update your excel file for the following: * Screen Discharge/Specialty Inks * Basic embroidery quoting Relevant Skills and Experience I have been coding in basic & MS Office (Word, Excel, PowerPoint etc...) VBA script since 2000. Proposed Milestones $25 AUD - Project Successfully Completion
$25 AUD in 3 days
5.0 (1 review)
3.4
3.4
User Avatar
Hello. I bid for this project because I'm an Accountant with lot of experience in MS Excel Habilidades y experiencia relevante I guarantee you an accurate job, full functionality and fast delivery, all this in exchange of a fair rate that is perfectly adjusted to your budget. Htos propuestos $25 AUD - Providing help with formulas in Excel Could you share the file, please?
$25 AUD in 1 day
4.9 (24 reviews)
3.5
3.5
User Avatar
I can easily do this it is a peice of cake for me please give me the project
$25 AUD in 1 day
4.0 (1 review)
0.4
0.4

About the client

Flag of AUSTRALIA
Sydney, Australia
5.0
20
Payment method verified
Member since Mar 12, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.