Completed

Free shipping calculation

Hello

i need to calculate, in excel, many conditions and keep the profit margin at least 20%. The varibable are

. Shipping cost

. Product cost

. Free shipping rate

The product more cheap cost 1€/kg

The markup is 50%

The fix costs are 3€

The shipping cost depend from weight

The free shipping is when order total is > 39€

The module is already done (look [login to view URL]), the goal is make a macro that test

From Total products > 1€ to <= 500€

And Weight > 0 to <=100Kg

And print all conditions when the profit margin is = 20% (i need to know how much is requied for fix the loss for each condition, so i will set a different supplement to ask to customers for each condition).

This is very simple for who know Vba, the file is done at 98%

You will pass me the file with all conditions printed (in the range indicated above) and the macro also (because i have to make some tests after with little change in conditions)

I already tested a macro, and i think you simple improve it

Sub Macro1()

'

' Macro1 Macro

'

Do

Range("m2").GoalSeek Goal:=10, ChangingCell:=Range("b2")

Range("m3").GoalSeek Goal:=10, ChangingCell:=Range("b3")

Range("m4").GoalSeek Goal:=10, ChangingCell:=Range("b4")

Loop Until Abs(Range("m2")) + Abs(Range("m3")) + Abs(Range("m4")) <= Range("m5")

MsgBox "Work done", vbInformation

End Sub

Skills: Data Processing, Excel, Software Architecture, Visual Basic

See more: oscommerce free shipping item, ups shipping calculation chart, oscommerce free shipping united states, oscommerce fix free shipping, oscommerce free shipping selected products, volusion free shipping gift certificates, free shipping graphics websites, osc free shipping zone, oscommerce free shipping icon product info, shipping calculation, virtuemart free shipping, free shipping mod oscommerce, real time usps fedex ups shipping calculation, cre loaded free shipping downloads, ccgv free shipping, cre loaded free shipping module

About the Employer:
( 153 reviews ) Villanova Mondovì, Italy

Project ID: #17797919

Awarded to:

WeiSongJi

Hi I have read your project description and exciting. I think your project is very simple for me. I can finish your project immediately, and I can do perfectly. If you go with me in this project I can help you anyt More

€24 EUR in 1 day
(0 Reviews)
0.9

14 freelancers are bidding on average €23 for this job

sysdesigner13

Hi, bro. I have read your description CAREFULLY so I am very confidence for your project I am very experienced and skillful with calculation in Excel. You can visit my profile to confirm that. A few days ago, I More

€23 EUR in 1 day
(54 Reviews)
5.5
aubrey03

I am an Excel specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

€24 EUR in 1 day
(52 Reviews)
5.1
sevillajk01

hello! let me help you with your project. Just award the project to me and I will take care of the rest. Hope you will consider me. thanks

€19 EUR in 1 day
(11 Reviews)
3.6
Proolancer

Hello, I'm a web and desktop developer with 8 years of experience in this field, I read your project description and attached files I can dp what you want just get in touch with me and we can discuss more about your More

€14 EUR in 3 days
(3 Reviews)
3.0
nikopolidis

My name is Nicola, an experienced accountant and financial controller, currently Group Controller in a multinational automotive group. I use Excel daily and I'm a wizard with this software! I have created many dashb More

€30 EUR in 1 day
(2 Reviews)
2.7
benith1

i can do any of excel work as perfect if you want to do this please contact me soon with your information thank you very much

€23 EUR in 1 day
(0 Reviews)
0.0
box1508

hi,i may be new here but i have a more than 10 years experience in Microsoft softwares like Excel,word ,and power point . I Can do this project LET'S START....PICK ME NOW

€27 EUR in 1 day
(0 Reviews)
0.0
zra12

Morning sir/madam, I am skillful in calculating, well versed in excel. If you give me the opportunity I will do my best and thanks.

€24 EUR in 1 day
(0 Reviews)
0.0
Mortasim

Dear Sir, thanks to you, i would to like to do your work. i have an experience on this filed last two your. thanks & best regds

€23 EUR in 1 day
(0 Reviews)
0.0
manasaatir

hello I belong to the profession of chartered accountancy i think i can help you in the best possible way as i have related experience as well

€23 EUR in 1 day
(0 Reviews)
0.0
€24 EUR in 1 day
(0 Reviews)
0.0
RAJSINGHBANGAR

i will do this job very well.............................................................................................................................................................................................. More

€19 EUR in 3 days
(0 Reviews)
0.0
€21 EUR in 3 days
(0 Reviews)
0.0