Em Andamento

Compounding spread sheet

I start with a specific number. Lets say 1557.

I then have 5 steps which will be 5 different columns in excel which add up to 1557.

The first step starts at 27 the second step 63, the 3rd 157.5, 4th 382.5 and the 5th 927. So if we add all the steps up it will equal 1557.

Each Step will equal 70% of that number. EG 27 = 70% of 27= 18.9 Step 2 70% of 63=44.1 ect.

When the first step is deducted from the specific number, the second steps 70% must equal greater then the specific number, by the first steps 70%.

EG: Specific number is 1557, first step is 27. 1557 - 27 = 1530. So now the second steps 70 % must equal greater then 1557 by the first steps 70% (70 of 27=18.9) which is 1557 + 18.9 = 1575.9.

If the first step is deducted from the specific number and the second step is deducted from the specific number then the 3rd step must equal greater then the specific number by the original first steps 70% amount. EG: specific number = 1557 - first step (27) - second step (63) = 1467 so now the 3rd steps 70% must equal the same as the first steps 70%. So now the sum should equal 1575.9. This must happen for all the steps 1-5

I want to be able to simply input the specific number and all the steps show up straight away.

I would like it to show the Step number, how much eg 27 for first step and what that step equal from 70% (18.9) all the way to step 5.

It could look something like this on Excel:

Specific number: 1557

Step1 Step 2 Step 3........ ..................Step5

27=18.8 63= 44.1

So to clarify all the steps have to add up to 1557 or what ever specific number I choose to input.

Each Step has to have a 70% value

If step 1 is deducted then step 2's 70% has to add to step 1's 70% + 1557 (specific number)

If step 1,2,3,4 is deducted then step 5 has to add to step 1's 70% + 1557 (specific number)

Simple

Habilidades: Processamento de Dados, Processamento de dados, Excel

Ver mais: want excel spread sheet, step1 data entry, spread, excel spread sheet, excel input sheet, excel simple steps, 157, simple spread sheet, excel show different value, excel sheet add, spread sheet entry, clarify excel, spread excel, spread sheet excel, sheet columns, excel sum data sheet, compounding, excel sum columns, simply excel sheet data, spread excel sheet, sum data excel, excel sum data, sum data sheet excel, online sheet spread, excel sum

Acerca do Empregador:
( 3 comentários ) Melbourne., Australia

ID do Projeto: #5090706

Premiar a:

microk

Dear eureka888, VBA expert here.. Please award project.. I've started working on it and can deliver this within 3-4 hrs. As I'm building the logic, can you please a sheet where you've put some numbers manually..? Mais

$25 AUD em 3 dias
(24 Avaliações)
4.4

18 freelancers estão ofertando em média $25 para este trabalho

Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$50 AUD in 0 dias
(145 Comentários)
6.4
ravi666

hello Sir i am ready now plz send me more details so i start project now. sir my team have good experience thanx

$25 AUD in 3 dias
(17 Comentários)
4.1
SiroosJafary

Good day, I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. Here are the links for my past exper Mais

$25 AUD in 0 dias
(11 Comentários)
3.7
zExcel

Hi, would it be possible to send me the table showing all the desired results for the 5 steps for the specfic number 1557. That would help better understand the concept. Thanks

$30 AUD em 1 dia
(8 Comentários)
3.5
dviruki

Hi, I understand what you need and can do it right away. I have 12 years of extensive Excel experience.

$26 AUD in 0 dias
(8 Comentários)
2.9
anshara123

Knowledge honesty and commitment, I know that I can work with comfort and ease. I have an MBA degree and so it is so simple for me to accomplish this task in time.

$25 AUD in 3 dias
(0 Comentários)
0.0
Shanika2013

I'm new to this side but i think i can do my best for this job with my knowledge of Microsoft office . If you can please give me a chance. thank you

$25 AUD in 3 dias
(0 Comentários)
0.0
Blue123sky

A proposal has not yet been provided

$25 AUD in 3 dias
(0 Comentários)
0.0
teeares

I am conversant with Excel and I am sure to deliver to your expectations. However, I seek afew clarifications. If the starting number is 1557 how did you get the the first to the fifth step numbers,that is 27,63,157.5, Mais

$15 AUD in 3 dias
(0 Comentários)
0.0
amalienahilmy

I am available at any time , flexible in working anywhere and anytime as i own a laptop excellent internet connection, fast internet speed. A very discipline person,will complete work in duration stated. Good in open o Mais

$20 AUD in 3 dias
(0 Comentários)
0.0
Dimciu

Hello, I am the best candidate for the short project because I work with Excel daily, especially with formulas like this. I will complete the assignment within 12 hours. Hope to work with you. Thanks

$15 AUD em 1 dia
(0 Comentários)
0.0
romeliasaineh

I can finish this task easily.I am student of information of technology and soon to be graduated. hire me.

$25 AUD in 3 dias
(0 Comentários)
0.0
chamika012

Hi, I have completely understood your requirement about the data entry and i am a data entry professsional who can be fitted to any sort of a article writing and documenting. I pocess very good knowledge about the Mais

$25 AUD in 3 dias
(0 Comentários)
0.0
manujawijesekara

I have enough skills to do this job. So, you have no doubts to offer this job to me. Any how you search my abilities and decide whether award or not. Good luck

$23 AUD in 3 dias
(0 Comentários)
0.0
manafza

Hi, it seem interesting to try as my experience was love to do migration and calculation on excel, access. Can I have a try.

$25 AUD in 3 dias
(0 Comentários)
0.0
booiim

A proposal has not yet been provided

$25 AUD in 3 dias
(0 Comentários)
0.0
Derigh

Excellent in English. Been using EXCEL since 1990s. Currently unemployed. Strong belief in productivity and quality control

$25 AUD in 3 dias
(0 Comentários)
0.0