excel coding
$30-250 AUD
Paid on delivery
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%
Project ID: #16765595
About the project
Awarded to:
13 freelancers are bidding on average $134 for this job
Hello, I have the good knowledge of excel coding. I have more than 5 years of experience in Data Processing, Excel, Mathematics, Software Architecture, Visual Basic. We have worked on several similar projects before More
I can work for you. I'm interested in your project. I've an experience of works with excel macros. Ping me any time to discuss about this project.
I am an efficient writer i have experience in article writer and very efficient in excel and Microsoft office. Able to pay attention to detail and also create massive quality work
I've done this before. I know that this work can be done on time and I can finish without doing any wrongdoing.
Hello I am a multi-talented individual with skills not limited to; Mathematics work, content writing, data entry, excel programming, article writing, and typing. I have done 3 successful excel projects. , I shall pr More
