Find Jobs
Hire Freelancers

Automated Excel Calendar from Outlook

$30-250 USD

Cerrado
Publicado hace más de 7 años

$30-250 USD

Pagado a la entrega
Background: We have a weekly meeting that we all sit around and dish out our schedules and manually input them into a master excel sheet. This is inconvenient, time consuming, and inefficient. We would like to automate the process. What we need: Outlook Calendars (7 in total) -> Master Excel Sheet -> Member Schedule Excel Sheet Outlook needs: 1) We need all 7 outlook calendars to go into one single excel sheet. We want it to happen on a weekly basis on Fridays. 2) The excel sheet needs to have variables for the owner, category, subject, start date, end date, attendees. a. This is already in the code below 3) The code below needs to be edited to where it is automatic and not manual. At the moment we have to manually select the dates that the code draws from on the calendar. We want it to be an automated process to take place every Friday evening. 4) Also, we have a system of classification in place to say if the file is confidential or not. This has caused problems with the code when trying to save since it cannot tell the program what to do. This is a minor problem that we could probably work around, but would be nice to have it automated as well. Master excel sheet needs: 1) The 7 calendars need to be imported into this one sheet 2) The variables mentioned above should be the columns 3) The code below does this well, but as mentioned, we need it to be automated Member Schedule Excel Sheet: 1) This excel sheet has a list of the members with dates by day and month. 2) We need this excel sheet to be filled based on criteria from the master excel sheet a. Example: if Person1 has a vacation scheduled for 02/04/2017 to 02/10/2017, we need the corresponding boxes filled with a “V” on those dates for that person inside of the excel sheet. 3) The criteria needed for the sheet is: a. Date of event matches on both sheets b. Owner of Calendar matches Person (this will have to be searched by keyword… example: First Last on the Member Schedule Excel sheet will be displayed as “[login to view URL]\calendar “ on the master excel sheet.) c. Look for certain keywords (ie. “vacation”, “personal”, etc… we will set these) inside of the master sheet subject box column to determine if the specific date and person has added is a vacation day, personal day, half day vacation, etc. This command should fill in the sheet with the appropriate symbol to indicate what type of day it is d. If an event contains 2 or more of the Persons, then the column should be yellow with “Major Events/Meetings” being filled with the name of the event 4) The criteria need to return the correct code corresponding with the correct person, date and event 5) If an event is more than one day, the master excel will only have the start date and end date, we will need for all days in between to be highlighted with the correct symbol. The uploaded file contains the same information plus images. We have anticipation of more projects in the future and would like to find a freelancer to stay with us on these.
ID del proyecto: 12528085

Información sobre el proyecto

1 propuesta
Proyecto remoto
Activo hace 7 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
1 freelancer está ofertando un promedio de $194 USD por este trabajo
Avatar del usuario
Dear Client, Greeting of the day ahead !!! Thanks for providing us opportunity to place bid over the project and communicate with you. I am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned .I have checked your requirements.i have right skills to work on this assignmentWe find our expertise, skills and capabilities are perfectly blends with your project requirements because we have already worked on many projects. You'll love the whole layout, interface design , cross-browser compatibility and mobile-device-friendly interfaces that we design Our team has created over dozen of windows, and web based appliations iPhone/iPad games and apps, and over 10 Windows and Linux server APIs and security tools Don't waste any more time in your development We take care of all these things for you . Advanced custom coding for our clients. Anytime. can u provide your email or sky-pe etc for further discussion about the project. plz add me to discus I am ready to discuss with you Looking forward to hear from you. with best Regards
$194 USD en 6 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de INDIA
India
0,0
0
Miembro desde dic 16, 2016

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.