Closed

# Price calculation aosta

This project received 6 bids from talented freelancers with an average bid price of €247 EUR.

€8 - €70 EUR
6
###### Project Description

Goodmorning,

We need a little software or app running on Windows or, even better, on our server based on Linux. We don’t want an Ebay’s macro.

The software starting from the files attached must calculate some values:

- Prezzo + ricarico + IVA = ((price [cell M2 in the file 1] * (1 + ricarico [cell B3 in the file 2])) * (1 + IVA [cell B2 in the file 2])

- Costi Paypal (Paypal freight) = ((Prezzo sito + ricarico + IVA [calculated up] + spese di trasporto [cell B14 in the file 2]) * (% Paypal [cell B12 in the file 2]) + fisso Paypal [cell B11 in the file 2]

- Prezzo sito = Prezzo + ricarico + IVA [calculated up] + Costi Paypal (Paypal freight) [calculated up]

- Costi Ebay (Ebay freight) = Prezzo sito [calculated up] * % Ebay (Ebay freight) [cell B7 in the file 2]

- Prezzo Ebay senza trasporto = Prezzo sito [calculated up] + Costi Ebay (Ebay freight) [calculated up]

- Prezzo Ebay con trasporto = Prezzo Ebay senza trasporto [calculated up] + trasporto [cell B14 in the file 2]

At this point the software must do 2 tests:

1° test: check if low total [cell AP2 in the file 1] is > of Prezzo Ebay con trasporto [calculated up]

if low total [cell AP2 in the file 1] is > our selling price is = low total [cell AP2 in the file 1] - scarto prezzo [cell B16 in the file 2] OK

if low total [cell AP2 in the file 1] is < we have to check if is > of (price [cell M2 in the file 1] * (1+ IVA [cell B2 in the file 2])) + Costi Ebay (Ebay freight) [calculated up] + Costi Paypal (Paypal freight) [calculated up]

2° test check if (low total [cell AP2 in the file 1] – scarto prezzo [cell B16 in the file 2] - (price [cell M2 in the file 1] * (1+ IVA [cell B2 in the file 2])) + Costi Ebay (Ebay freight) [calculated up] + Costi Paypal (Paypal freight) [calculated up] is > of [cell B18 in the file 2]

if yes our selling price is = low total [cell AP2 in the file 1] - Costi Ebay (Ebay freight) [calculated up] - Costi Paypal (Paypal freight) [calculated up] – scarto [cell B16 in the file 2] OK

if no don’t take care of the item

In an added column report all the OK (values) of the 2 tests.

Thanks,

Regards,

Marco

## Hire Freelancers who also bid on this project

• Forbes
• The New York Times
• Time
• Wall Street Journal
• Times Online