Fermé

Excel expert needed

I’m trying to automate the Navy’s pilot qualification program in excel. Their syllabus has exact days of training where they should complete simulator events and flight events. I want to be able to input a start day for a class (7 total classes) and excel place the required simulator number of x’s and flight x’s on an automated corresponding calendar.

I started trying to figure this out. I’m stuck trying to figure out a macro that will automatically allow my calendar to adjust to months with less than 31 days or how to get the X’s to automatically populate on the calendar.

In the attachment, the first tab is more for data. Class start dates are what’s important there and if you scroll down I created a chart that lists everyday of their syllabus training period.

Tab 2 is the important data as it is the syllabus Simulator and flight events. Row 3 is the actual event, row 2 defines if it’s a SIM or Flight. Row 4 is hours that event should take. Row 6 is the day of training that event should happen and is what I’m trying to automate on a calendar based on start dates. Row 7 is number of x’s each day requires. I want that number to fall on the calendar (tab 3) and be multiplied by number of students in a class. Our fiscal year is October to September and I want this to be something I can use every year. Starting on line 11 is each actual class and the x’s they have. I’d love to automate that somehow based on the x’s I put in to the calendar (the right calendar on tab 3, completed x’s).

I’m sure this explanation probably will bring more questions as it’s tough to explain this way.

Compétences : Saisie de Données, Excel VBA, Excel Macros, Excel VB Capabilities

En voir plus : php expert needed, joomla expert needed, toronto excel expert job, web security expert needed, photoshop expert needed san jose, volusion expert needed, digg expert needed, excel expert financial models, excel expert needed virtual assitant, query excel sheet excel expert needed, needed excel expert pivot table, excel vba expert needed, excel maths expert needed, excel vba expert needed write application, excel vba expert needed write, excel spreadsheet expert needed, data analysis excel expert needed, excel expert needed, excel expert needed in dubai

Concernant l'employeur :
( 0 commentaires ) Chesapeake, United States

Nº du projet : #30964138

22 freelances font une offre moyenne de 123 $ pour ce travail

(214 Commentaires)
8.2
(303 Commentaires)
8.1
(735 Commentaires)
7.9
(263 Commentaires)
7.1
(147 Commentaires)
6.7
(252 Commentaires)
6.3
(158 Commentaires)
6.5
daniyal3214

Hello, I will be glad to assist you with that. I am an advance level Excel expert holding years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(52 Commentaires)
6.0
(11 Commentaires)
5.7
merinsinha

Can do your project. Advance Excel Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are a Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(103 Commentaires)
5.2
(40 Commentaires)
5.0
nimiwebjuggler

Hi, I am an Excel Expert with Professional experience working with Excel. I believe I can do a great work for you and ensure your quality. I have more than 5 year experience with excel. Complete a lot of jobs on Freela Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(50 Commentaires)
4.8
GabrielBarreiro1

Hello, your project looks interesting, but I would try another approach, one based on forms and tables, then the generated data could be displayed more dynamically on a dashboard. I can achieve an optimal combination b Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(17 Commentaires)
4.3
haleem0786

i can do this. i have good command over Ms excel especially pivot table, charts, advance formulas, formatting, macro, VBA etc. Please inbox me and share detail. Thanks Abdul Haleem

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(23 Commentaires)
3.9
(14 Commentaires)
4.0
taniaismawati19

My full name is TANIA ISMAWATI, I have a good condition, for me integrity, professionalism, discipline, agile, responsibility is the main thing in every the task I do.i can master microsoft word, excel, power point

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(0 Commentaires)
0.0
KaushikKumar2004

Ghjwhfqwgjafjsghraksgjsgldhhfksyjsujatksfjstharjarksthgakarhatjatahuksfmdgksfstjsrksghafsmwrhsuhrsghasgjsykstkdh

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0
vidhyat

Hi, THis is a fun project. I have it done and ready. I can send it to you as soon as you need it. THanks Vidhya

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
saudtahirqureshi

Dear Friend, I have gone through your requirements and I believe am the most suitable candidate for this job. I have handled several assignments on this field and I will be glad to offer my expertise and skills on this Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0
aliakseidev2

How are you? I am a software and write. I have also lot of experience in Designing. I have some rules and regulations before start of project: 1. Provide 100% work within deadline. 2. Provide unlimited revisions unti Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0