alogorithm ms os

Fermé Publié le il y a 5 ans Paiement à la livraison
Fermé Paiement à la livraison

PC app on the easier language for microsoft OS

Process description:

Register by user of amount objective (ex.: 40)

Register number of lines that will contain numbers

Register tax percentage (by default 21%)

Register a line with fix value for calculus

Register a line with a fix value for calculus:

Step 3 multiplied by 21%

Register value for every line

A line for tax value, will contain the sum of all values registered multiplied by 21%

Algorithm execution:

Will be in a loop until value objective will be obtained as result

Increase or decrease value of first line in 0,01

Recalculate the total of all lines registered by customer

Recalculate the value of tax value

SUM Total amounts of lines + tax value of total amount of lines + line with fix value for calculus + value of tax for fix value for calculus

If value of 5 is lower that the objective, increase 0,01 to the value of second line...

When increased 0.01 for all lines, will continue again from the first line, to the last one

When value objectived obtained loop will stop and new values from lines will be available to user

Table example:

Number of lines: Número líneas: 3

Fix amount: Importe fijo: 10

Tax fix amount: 21%: Impuesto importe fijo 21%: 2,1

Taxes: Impuesto: 21%

Line 1 value: Valor linea línea 1: 25

Line 2 value: Valor linea línea 2: 100

Line 3 value: Valor línea 3: 56

Objective: Objetivo: 195

Condition example for increasin or decreasing on every loop:

IF Line1+Line2+Line3+(Line1+Line2+Line3)*21%+Fix amount+Tax fix amount: 21% > Objective THEN decrease 0,01 on every loop

IF Line1+Line2+Line3+(Line1+Line2+Line3)*21%+Fix amount+Tax fix amount: 21%

Excel Excel Macros Microsoft Access PHP Python

Nº du projet : #16765563

À propos du projet

1 proposition Projet à distance Actif il y a 5 ans

1 freelance fait une offre moyenne de $30 pour ce travail

rcnvw

I think I understand the requirement and can achieve this using Microsoft Excel Macros. Can have the user input screen for entering the values of Line1, Line2, Line 3, Objective ect. The code within the VBA can execute Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(13 Commentaires)
4.5