I have a worksheet that records estimated hours to be spent on projects for various staff members along with the value of time spent on projects to date. Data is summarised on a couple of different worksheets.
Because the workbook sums data from the same cells across multiple worksheets and these cells can move around (continually adding and removing projects) the formulas are a little more complicated than usual. The main problem I am encountering is that the workbook is completed by people who are no sophisticated Excel users and I am finding that they are frequently overwriting formulas etc with incorrect data - despite me trying to have them protect the worksheets. So I am looking to either make the spreadsheet more user proof or alternatively, I kind of think it might lend itself to a Access database instead of using Excel.
The worksheet is attached and a few salient points are noted below:
1. Generally one staff member complete the sheet on a weekly basis by updating the list of projects (across the master project list and all individual staff sheets - of course, staff members come and go and the totals on the master sheet need to include all staff [login to view URL] cost spent to date is also entered at this time - this comes from another application where staff enter timesheets - it is a SQL database and being able to copy that data into this worksheet/database would be a big timesaver.
2. Then estimated hours per project per day for the coming week for each staff member are entered.
3. This is summarised into the Master Project List and the Designer Summary.
They are the main points but would need to discuss our needs in a little but more detail working through the workbook - overall I don't think it is that complex but I don't have time nor inclination to brush up on Access skills and Excel skills fall just a little short to improve this. Don't really have any idea how long the project will take so the budget I have indicated is a guess only - happy to work on hourly rate basis as well if I am comfortable twith who I am using.
Bu iş için 28 freelancer ortalamada $997 teklif veriyor
Hi mate, Not sure if we already know each other :) but I am still bidding if it is not you Tom. I am available for next 2 weeks and based out of Melbourne. So definitely can do this work for you. Ajz Hey ther Daha Fazla
Hi, I went through the sheet that you attached with job description and very keen to discuss with you on this to work out what would be best approach. (e.g. Excel data sent to MS Access, or a winform application sen Daha Fazla
Hello sir i can develop an MS Access database to replace the existing Excel worksheets or at best Develop a stand alone application using .NET Framework (C# or VB.NET) as frontend and Access / SQL Server or MySQL a Daha Fazla
Hi, We are a team of 4 people working as software professional in IT industry from last 4 years. Mainly working as DBA and Database Maintenance using SQL Dev and MS Access. We have great exposure to work on VB sc Daha Fazla
HI I am an excel-vba Expert and I can help U with your project pm me ...........................................................
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 215 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive Daha Fazla
Hello There. Definitely this is a hard work to do in Excel. But after read and check all your specs and needs, I'm not quite sure that MsAccess will be your best solution. I want suggest to you a few things: 1) Cons Daha Fazla
Hello, I can understand why you may be struggling with this. The current configuration lends itself to be vulnerable to a lot of room for usererrors. I would STRONGLY recommend incorporating forms that allow for s Daha Fazla
Hi, I have been developing applications in both Excel and Access for over 20 years and have a good track record on the UK for major organizations such as the NHS and Thomas Cook Airlines. I have completed a number of F Daha Fazla
Software developer since 2000, specializing in Visual Basic, SQL server, Crystal Reports/VBA for MS Office. I recommend using UserForms to minimize (if not totally eliminate) user errors
Greetings for the Day!!! I have 5 years of experience in VB, VBA along with SAP. Internet Explorer, PDF & Text files, MS Access and SQL Server databases, VB SCripts, Hope if awarded with this project i can make i Daha Fazla
I know officeBasic like the back of my hand and have written MS Access applications for entire workflows. I can convert this into a nice Ms Access application with necessary input forms and reports.
I am expert in excel , macros and access. I have built several complex applications using these. I would like to work with you. Please let me know further. Regards, Selvan
Hello, I am very interested in this project. These sorts of automated spreadsheets are what I spend a lot of my time developing at work. Please have a look at my feedback. Background: I am an Engineer from Nov Daha Fazla
Hi, I can help you with your requirement. I have closed more than 150 excel projects at various forums. Please provide more details to help you better. Regards Sawan
We can start right now! Kindly give me chance for work really very interested for this project. I have read all your requirements and I can do this job very professionally and you will get Pro Quality Work. EXCEL AND Daha Fazla
Hi there, I'm expert in Advance Excel and Access, Formula, Function and Macro. I can do this. Please check my feedback as I've done several Excel and Access project on freelancer. Please PM me. Thank you, FARZAN Daha Fazla
Hello, Thanks for the posting the project on freelancer. I am having 10 years professional experience in software development. I have worked with various reputed IT organizations like Capgemini and Dell before I Daha Fazla
I have gone through the Sample Excel Sheet. It seems to have made things complicated. I understand one designer is feeding the data one at a time. I understand you need a mechanism to feed the daily data and the desir Daha Fazla
i have an experience of more than 10 years in VB development. Great command in Sql server,MS access.