Käynnissä

Excel sheet, graphs, charts

Need someone to quickly draw a tabbed Excel file for employee/resource costs calculation.

-> In one tab, you'll have hourly/monthly rate for each type of team-member

-> In second tab, I want to specify 7 teams and specify # of team members

For example:

# "Mobile team" = 1 developer, 1 QA, 1 BA

# "Web team" = 1 developer, 1 QA, 1 BA

(ideally, I should be able to select from drop-down)

I also want to be able to select a resource for 100%, 50%, 25%

If I select resource for 50%, cost will be 50% of specified in tab 1.

In Third tab (or maybe same tab as second tab), I want a graphical display that shows "team chart", along with costs. See attachment for a rough mock-up of chart.

Need someone to quickly draw a tabbed Excel file for employee/resource costs calculation.

-> In one tab, you'll have hourly/monthly rate for each type of team-member
-> In second tab, I want to specify 7 teams and specify # of team members

For example:
# "Mobile team" = 1 developer, 1 QA, 1 BA
# "Web team" = 1 developer, 1 QA, 1 BA

(ideally, I should be able to select from drop-down)

I also want to be able to select a resource for 100%, 50%, 25%
If I select resource for 50%, cost will be 50% of specified in tab 1.


In Third tab (or maybe same tab as second tab), I want a graphical display that shows "team chart", along with costs. See attachment for a rough mock-up of chart.


So, OVERALL - I want three things:
1. specify resources/cost
2. define team names and # of resources in each team
And sheet should:
1. show me each team with # of resources, subtotal costs
2. show me a graphical view of the above, with total cost

***** TO BE COMPLETED in 12 hours. I don't have much time. *******

Taidot: tietojenkäsittely, Excel, Microsoft Office, Powerpoint, Word

Näytä lisää: product cost sheet excel format, excel charts graphs vba, charts graphs based excel data, cost sheet excel construction, product cost sheet excel, vba excel charts graphs, creation charts graphs excel, cost sheet excel, scheduled updates excel charts graphs, travel agent cost sheet excel, charts graphs, sellers net sheet excel free, seller net sheet excel, code update sheet excel, format salary sheet excel, buyers net sheet excel, assumption sheet excel, shift roster sheet excel, real estate net sheet excel

Tietoa työnantajasta:
( 85 arvostelua ) Plano, Canada

Projektin tunnus: #13107851

Myönnetty käyttäjälle:

ArbazNaqvi

Hi i will create Excel file for Employee Cost management using Tabs as you have specified. Please take a look at following rephrased tasks and let me know if i am wrong. 1. First tab will Contain Monthly or Hourly ra Lisää

45 $ USD 1 päivässä
(2 arvostelua)
1.4

40 freelanceria on tarjonnut keskimäärin 147 $ tähän työhön

170 $ USD 1 päivässä
(252 arvostelua)
7.6
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Lisää

155 $ USD 3 päivässä
(129 arvostelua)
6.3
koolsidz

Hello :) My Credentials: 20+ of Excel/VBA Experience. [url removed, login to view] I am an MS-Excel Expert besides being an MVP (Microsoft Valuable Professional). If you see my reviews by navigatin Lisää

222 $ USD 1 päivässä
(152 arvostelua)
6.5
P0L

150 $ USD 3 päivässä
(147 arvostelua)
6.5
dpune

Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Let us discuss more details so that I can estimate cost and time better. I have completed more than 300 projects. Plea Lisää

100 $ USD 3 päivässä
(116 arvostelua)
6.2
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach y Lisää

150 $ USD 7 päivässä
(110 arvostelua)
6.1
TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me for further detail Lisää

100 $ USD 1 päivässä
(150 arvostelua)
5.8
sandroshubladze

Hi, I am Excel Expert and VBA programmer I can create for you dynamic drop down lists without blanks and auto-update option. And of course provide rest calculations and graphic illustrations If interested, contac Lisää

111 $ USD 1 päivässä
(50 arvostelua)
5.6
ksriniravi

Greetings! Having been a Program Manager myself, I understand what you are looking for from this report. I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented Lisää

100 $ USD 2 päivässä
(48 arvostelua)
5.2
vsprybhanu

I will complete this job within 21 hrs. Hi, Experienced Excel Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Dro Lisää

120 $ USD 1 päivässä
(42 arvostelua)
4.6
250 $ USD 5 päivässä
(6 arvostelua)
4.2
70 $ USD 1 päivässä
(14 arvostelua)
4.0
chyconsl

Hi, Can you share more details about your project? I have done similar project and understood the project outline. Please give me a chance. A trial will convince you. Looking forward to work with you.

155 $ USD 3 päivässä
(6 arvostelua)
4.2
50 $ USD 1 päivässä
(12 arvostelua)
4.0
Arjun1106

Being a PUBLISHED AUTHOR, I understand what QUALITY WRITING is and how to convert an idea, a subject into ENGAGING collection of words. I specialize in Business, Technical, Academic, Commercial, Fiction, and Blog writi Lisää

222 $ USD 3 päivässä
(3 arvostelua)
3.3
147 $ USD 3 päivässä
(7 arvostelua)
3.3
kalyaninawathe

Hello There, I would like to work on this project as I am can deliver you the tabbed excel sheet as explained in the project description. I have prior exp. in such excel jobs, testimonials and reviews are on my pro Lisää

111 $ USD 3 päivässä
(6 arvostelua)
2.9
fb57e1f6608abfb

Hi, I have ~4+ years of experience of creating and operating low to very high complexity of Excel/VBA/SQL,SAS, Powerpoint based tools/processes, reports. I can assure you of high quality and on-time deliverable Lisää

244 $ USD 1 päivässä
(6 arvostelua)
2.6
MarijaTod

Hi, First of all, I would like to urge you to take a look at my portfolio for your reference of my professional knowledge of the Microsoft Office Package. You can see my full tutorial on the sublect there. I would lo Lisää

222 $ USD 1 päivässä
(2 arvostelua)
1.9
robin1108

Dear Hiring Manager, I read your project description properly and I am able to complete it on your budget. I am ensuring you 100% valid quality service following your requirements. For any query, please send me a Lisää

155 $ USD 3 päivässä
(3 arvostelua)
1.7