Terminé

Create Excel Macros

There are 5 sheets (activity, small project, medium project, large project and program) I have included rules at the bottom of the activity and small project sheets. These rules need to be scaled up for medium project etc. Activity has 7 boxes with 5 lines each but only 1 criteria of each box completed. small project has 7 boxes with 5 lines each with 2 criteria of each box completed etc until program which has 7 boxes with 5 criteria of each box completed.

Using the rules the corresponding health status diamond will change to the key's colour and letter. For example if schedule is +5% over then the health status schedule diamond will automatically change to red with the R in the middle and so on. All criteria weightings need to be the same % but in the future if I wish to change these weightings then I need an easy method to do so. Maybe adding a weighting column. Please note criteria needs to be editable. So only the criteria or weighting will be changed. The input result won't.

To ensure you have read the scope of work please insert "Purple Bird" at the start of your response. Failure to do so will mean no reading of bid.

I need a working draft by monday 18th April by 9:00am Sydney time

Compétences : Excel, Visual Basic

en voir plus : key criteria, purple, excel small work, excel 7, excel colour, macros excel basic, large scope project, status create, visual schedule excel, visual schedule, need excel macros, visual rules, scaled, small excel, create example, automatically change colour excel, example failure project, excel small, read excel visual, program create, create project excel, weighting, small project using excel, schedule sheets, work schedule excel

Concernant l'employeur :
( 52 commentaires ) Riyadh, Australia

Nº du projet : #1023185

Décerné à:

vserv

Purple Bird: Please see your messages. Thanks

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 5 jours
(63 Commentaires)
5.7

25 freelance font une offre moyenne de $70 pour ce travail

bharanisrihari

"Purple Bird" - Hello, Excel Macro expert here. Please check PM for details. Thanks!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(64 Commentaires)
6.5
koolsidz

Purple Bird, Please see PMB

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(103 Commentaires)
5.8
northwolves

Purple Bird,see PMB please.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(46 Commentaires)
5.0
piyushdpatel

Hi This is Piyush Patel I have 6 yrs of Exp in VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Please Check My PM

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(10 Commentaires)
4.0
muthumuni

Dear sir I am expert for this project. Kindly see my message Thank you.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(11 Commentaires)
3.8
linglom

Purple Bird. Please check PM.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(9 Commentaires)
3.4
cdumitru

"Purple Bird" I would like to do this task. Please see PMB. Regards

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(5 Commentaires)
3.2
vbeh

Ready to start. ~Purple Bird~

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(3 Commentaires)
2.1
neelu7779

purple bird Hi, I am an expert VBA programmer. Please check the sample work in the pmb. I am sure you would like the work. regards Neelesh

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(2 Commentaires)
2.0
kavitasingh

I have worked on excel for more than 4 years. Can do this one efficiently

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
jmsong

Please see PMB. Thanks

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

Purple Bird : Please find attached the sample file for first sheet, Thanks.

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

I can do this job, please hire [url removed, login to view]

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
mabja

Purple Bird - Here is the solution.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
0.0
vickey87

Hi I would be able to do the job. Purple bird.

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

"Purple Bird" I have implemented similar kind of macros, I can finish this macro in 2 day including thorough testing

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
deepakbb

"Purple Bird" - Thank you for providing this opportunity. Please check PM.

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

"Purple Bird" - Hi, I want to get this project. I have 6 years of experience doing macros for excel, I know i can do this.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
EXCELPROBG

Please check PM.

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

Hi, i am intrested in this project. Thanks

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