Suoritettu

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)
2.4

39 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

$170 USD 1 päivässä
(254 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ä
(226 arvostelua)
7.3
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ä
(163 arvostelua)
6.9
P0L

$150 USD 3 päivässä
(241 arvostelua)
6.9
koolsidz

Hello :) My Credentials: 20+ of Excel/VBA Experience. [login to view URL] 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ä
(157 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ä
(126 arvostelua)
6.3
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ä
(128 arvostelua)
6.4
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ä
(126 arvostelua)
6.5
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ä
(235 arvostelua)
6.3
$70 USD 1 päivässä
(42 arvostelua)
5.2
$250 USD 5 päivässä
(13 arvostelua)
4.9
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ä
(50 arvostelua)
4.9
$50 USD 1 päivässä
(21 arvostelua)
4.7
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ä
(13 arvostelua)
4.1
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ä
(21 arvostelua)
4.0
$147 USD 3 päivässä
(11 arvostelua)
4.1
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ä
(8 arvostelua)
4.2
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ä
(7 arvostelua)
3.5
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
ranvli

I do this kind of roster all the time at the company I work, i do excel in general for a living and have also experience as typesetter that can be handy at projects like this that may require manual data entry.

$144 USD 3 päivässä
(2 arvostelua)
2.9