Find Jobs
Hire Freelancers

advanced excel spreadsheet help

$30-50 USD

Terminado
Publicado hace alrededor de 14 años

$30-50 USD

Pagado a la entrega
I have attached an excel document that basically has static data. I need some one to turn most of the cells used into something dynamic with calculations and all of that advanced stuff. :) Honestly some of this may be so advanced that I am not sure if it can be done. But I will take partial completion. Please post your comments in your bid. ;) The way I have it is that May is the starting point with 100 orders. In cell B4 I entered a cumulative monthly growth rate of 10%. I would like a function that looks at the value of B4 and makes the calculation updates the months for the rest of the year. In my example I have a 10% build up of orders per month of 110,121,133, etc.. Then I have B5 with a value of $10 per order, so row 14 should look at this value and multiply by total orders to get revenue. Then B6 has 50% to be given to affiliates. this should be taken into consideration when calculating row 15. F5 should update the values on row 16 Here is the part that I am unsure as to whether it can be done. let me explain, it is a service being sold that costs $10 a month. row 13 is total orders which means total orders this month plus previous months. The value for F4 is the number of months that we assume the customer will keep the service. So in my example I have Nov made to look like the customers in May are canceling and the orders are being left out of the total. F6 has a similar function with affiliate payments. In my example we're not going to pay affiliates after 4 months, so by the time we get to Sept., we're not going to credit affiliates for orders referred to us in May. I should be able to update F4 and F6 and have it update the sheet. Is this possible? Also, please try to format this document to make it look nice and presentable. :) ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables): a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform excel, openoffice, or google docs
ID del proyecto: 3192566

Información sobre el proyecto

1 propuesta
Proyecto remoto
Activo hace 14 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
See private message.
$34 USD en 4 días
4,8 (39 comentarios)
3,8
3,8

Sobre este cliente

Bandera de UNITED STATES
United States
5,0
174
Forma de pago verificada
Miembro desde mar 26, 2002

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.