Terminé

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

Compétences : Traitement de Données, Excel, Architecture Logicielle, Visual Basic

en voir plus : 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

Concernant l'employeur :
( 153 commentaires ) Villanova Mondovì, Italy

Nº du projet : #17797919

Décerné à:

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 Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% EUR en 1 jour
(0 Commentaires)
0.9

14 freelance font une offre moyenne de €23 pour ce travail

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(54 Commentaires)
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]

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(52 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(11 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(3 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(2 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
0.0
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
0.0
RAJSINGHBANGAR

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(0 Commentaires)
0.0