Find Jobs
Hire Freelancers

Converting Excel to Software

$30-200 USD

Cerrado
Publicado hace alrededor de 15 años

$30-200 USD

Pagado a la entrega
I have a fairly detailed Excel Spreadsheet that tracks daily sales statistics for sales people then builds reports based upon those numbers that are input. It is based upon a Quarterly system and I am looking to expand it and make it more functional ... and more stable. I am looking for stability and simplicity. I created this as I learned Excel and now I want someone to update it into more of an Excel database with more fully functional charts/graphs and ratios pages ## Deliverables What Type of Error ??" Checking or debugging does your price include? I do not want an internet based system. I want an Excel or VBA or similiar based system. Ideally something that I, or if I put it on another computer, they won’t need to download additional software from somewhere else. I am looking for almost identical functionality but I want to change the functionality of the forms. I want to be able to print the forms for any time frame given, currently I can only see forms for the given quarter as a whole and I want to be able to compare this year to last year or this month to last month this quarter to last quarter(see below for examples of time frames). PLEASE NOTE: make sure you have the zip file named: Victory System ??" Updated. In this version, I have deleted a couple of tabs that are not important to keep in this project. If you don’t have that one, let me know and I will get it to you. Description of files: weeks 1-13 are where the data gets input then everything else from there everything gets calculated based on those numbers. there is a ratio page, a reports page and then a quarter at a glance and each month of the quarter at a glance then the cumulative file is just that a synopsis of each of the quarterly files liked together to get some annual figures but more importantly the career based numbers. I have also attached a Word File that I currently use. The Word file is how I track the information on an hourly basis through the day and then enter the data in the Excel file at the end of the day. FUTURE USE: I don't have anything set up to sell online currently ... but I do wish to head in that direction. Once I have it working very well for me, my intent is to market it to others that do the same type of work as I do. TYPE OF PROGRAMMING: I am looking for an Excel based system or VBA. Reports - time frames for comparison: Include all dates ??" career cumulative Mth to date Qtr to date Yr to date Last mth last qtr last yr Comparisons this mth to last mth this qtr to last qtr this yr to last yr ideally, comparisons between to custom dates Goal to Result: mth to date goal to result Qtr to date goal to result Yr to date goal to result Daily Report Goal to Result I am open to input on structuring this but this is my first impression. How many sales staff do you have that you would like to track? currently it is just me ... as long as I could have the system running for multiple people at their own desk without interruption between them ... it could be a stand alone system for each individual person ??" not connected to each other in any way. That would make it simpler, for sure. Once I get it working for me individually then I would think about changing it for multiple people. there has been some questions on the Word Document ... It is simply the document that I use on a hourly/daily basis to track my call volume. I have attached a completed version of it as a PDF just so you can see how I use it. I track the data on an hourly basis for my own records but I only input the data for the entire day into the spreadsheet. Inputting hourly data IS NOT REQUIRED ... that would simply be information overload. I only track the total daily numbers in the spreadsheet.
ID del proyecto: 2684167

Información sobre el proyecto

47 propuestas
Proyecto remoto
Activo hace 15 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
47 freelancers están ofertando un promedio de $234 USD por este trabajo
Avatar del usuario
See private message.
$126,65 USD en 14 días
5,0 (507 comentarios)
7,6
7,6
Avatar del usuario
See private message.
$170 USD en 14 días
4,9 (282 comentarios)
7,5
7,5
Avatar del usuario
See private message.
$680 USD en 14 días
5,0 (717 comentarios)
7,4
7,4
Avatar del usuario
See private message.
$510 USD en 14 días
4,9 (406 comentarios)
7,1
7,1
Avatar del usuario
See private message.
$170 USD en 14 días
4,8 (158 comentarios)
7,0
7,0
Avatar del usuario
See private message.
$680 USD en 14 días
4,8 (127 comentarios)
6,1
6,1
Avatar del usuario
See private message.
$170 USD en 14 días
4,7 (60 comentarios)
5,7
5,7
Avatar del usuario
See private message.
$1.572,50 USD en 14 días
5,0 (51 comentarios)
5,5
5,5
Avatar del usuario
See private message.
$106,25 USD en 14 días
4,8 (27 comentarios)
5,4
5,4
Avatar del usuario
See private message.
$170 USD en 14 días
4,5 (51 comentarios)
6,0
6,0
Avatar del usuario
See private message.
$382,50 USD en 14 días
4,4 (80 comentarios)
6,0
6,0
Avatar del usuario
See private message.
$170 USD en 14 días
4,5 (92 comentarios)
5,4
5,4
Avatar del usuario
See private message.
$212,50 USD en 14 días
5,0 (22 comentarios)
4,8
4,8
Avatar del usuario
See private message.
$170 USD en 14 días
4,9 (16 comentarios)
4,6
4,6
Avatar del usuario
See private message.
$127,50 USD en 14 días
5,0 (21 comentarios)
4,5
4,5
Avatar del usuario
See private message.
$161,50 USD en 14 días
4,9 (17 comentarios)
4,2
4,2
Avatar del usuario
See private message.
$170 USD en 14 días
5,0 (48 comentarios)
4,3
4,3
Avatar del usuario
See private message.
$127,50 USD en 14 días
5,0 (30 comentarios)
4,2
4,2
Avatar del usuario
See private message.
$1.020 USD en 14 días
4,5 (9 comentarios)
4,7
4,7
Avatar del usuario
See private message.
$170 USD en 14 días
5,0 (9 comentarios)
3,8
3,8

Sobre este cliente

Bandera de UNITED STATES
Holt, United States
5,0
4
Miembro desde mar 23, 2009

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.