En cours

Excel Analysis - Can Excel be coded in VBA to achieve my resource planning and reporting requirements


My company uses Excel to manage projects and assign resources in general to deliver the work we get in.

We now need to extend the use of excel to our team leaders so they can assign work to individual team members. We also need each team member to be able to see what they have been assigned to do (in a week), what deadlines there are and then also to show how they actually spent their time.

I am unsure whether this is achievable within Excel and would like someone to analyse our requirements in a little more detail and report back with options.

Compétences : Excel

Voir plus : reporting projects, enterprise resource planning using aspnet, enterprise resource planning flash banners, open source resource planning tool, joomla resource planning tool, resource planning applicationweb, people resource planning tools, resource planning tools, enterprise resource planning bangladesh, resource planning tool

Concernant l'employeur :
( 1 commentaire ) Brighton, United Kingdom

N° du projet : #8467616

Décerné à :


Excel is designed to analyse and present a fixed set of data and it does this job very well. However it is very poor at storing and managing data which accumulates over time and it only allows one user at a time to mod Plus

180 $ USD en 10 jours
(2 Commentaires)

24 freelance ont fait une offre moyenne de 187 $ pour ce travail


A proposal has not yet been provided

200 $ USD en 3 jours
(199 Commentaires)

Hi: I have a few questions: Do you want to a single Excel sheet that is viewable by all but only team leaders able to edit the file? Do you want it to be hosted online? Please note that I have 100% completion rate and Plus

150 $ USD en 3 jours
(68 Commentaires)

I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. Please see reviews on my profile. It would be my pleasure to do your project. Please have a look at some Excel project Plus

130 $ USD en 3 jours
(40 Commentaires)

MsExcel is an excellent product for doing ad hoc reporting and analysis, however, as a tool to perform the mundane tasks of day-to-day operational work (particularly in coordinating multiple users), it leaves a lot to Plus

147 $ USD en 3 jours
(21 Commentaires)

Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 250 projects. Please look at the feedback left by my employers to know more about my work. Wai Plus

250 $ USD en 15 jours
(69 Commentaires)

Thanks for inviting me to bid on your project and apologies for the delay in responding. I would be interested in speaking to you about the project as I feel I am in a good position to help. I have recently compl Plus

789 $ USD en 5 jours
(10 Commentaires)

PMP, MBA and professional data analyst here. Worked with large and complex data sets in Excel, Tableau, SPSS etc. to generate reports, analysis and presentation.

263 $ USD en 7 jours
(9 Commentaires)

Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have b Plus

250 $ USD en 3 jours
(12 Commentaires)

Dear Sir/Madam, I have 12 years of experience in data processing and analysis using Excel and VBA while working in finance, audit and accounting industries (including 4 years at a Big 4 audit firm). I have completed a Plus

118 $ USD en 3 jours
(56 Commentaires)

Dear Sir, Done numerous similar projects in past the and always impressed the clients with my excellent VBA solutions. Out of my 40 projects, almost 35+ are complex VB/VBA projects, hence i can definitely deliv Plus

144 $ USD en 3 jours
(31 Commentaires)

Hello! I work with VBA for last 5 years and have created hundreds of different scripts, including different data analytic tools,DashBoards and Userforms; Also a have a lot experience with Access DB, and some with PH Plus

147 $ USD en 3 jours
(12 Commentaires)

Hi! Project plan: 1. Collection of information and requirements 2. Preparation of file 3. Testing of file by client 4. Client's modifications / additions 5. Modifications / Additions done 6. Testing by clien Plus

150 $ USD en 5 jours
(48 Commentaires)

Hi, This is a placement bid. Further analysis need to be done on your requirements and current Excel file. We shall finalize our bid price and time of delivery upon clarification of all requirements. Hoping to he Plus

100 $ USD en 3 jours
(13 Commentaires)

A proposal has not yet been provided

133 $ USD en 5 jours
(26 Commentaires)

Hi there My name is Redouane I am very interested in your project. Kindly start messaging so we can discuss further details. Thank you

100 $ USD en 3 jours
(32 Commentaires)

You dont need to recruit me to finish this. Drop me a message, and lets see what i can do for you. If you get happy, we can progress. (as i need some good references in my profile, i provide this service) I have a 5 Plus

177 $ USD en 3 jours
(16 Commentaires)

A proposal has not yet been provided

155 $ USD en 3 jours
(15 Commentaires)

Consider it done. Check my past reviews for your reference eagerly looking forward for your reply so that I can start with the implementation

200 $ USD en 3 jours
(4 Commentaires)

Hi, I can develop this but would like to discuss in detail with you about all requirements you would need. I have done complex computations in excel. For example, I have prepared a Progress Measurement System in Excel Plus

250 $ USD en 15 jours
(3 Commentaires)

A proposal has not yet been provided

144 $ USD en 3 jours
(2 Commentaires)