Lukket

Excel Workbook Update/Correction

I have an excel workbook containing various calculations across multiple sheets.

The current workbook consists of 100 Data Entry & 100 matched Data Sheets (Pivot Tables), with the Collected Data being summarized on 6 Team Sheets, 1 Floor Summary & 1 Program Summary Sheet.(This is a Quality Tracking Spreadsheet, so every employee, has a pair of labeled sheets.)

The Data Entry sheets primarily consist of various Dropdown options with all of the Workbook Dropdown options consolidated on one separate Data Sheet.

1)I need someone to review the workbook calculations, currently there appears to be an error when calculating averages, on the Team Sheet based on entries made on the 'Employee' Data Sheets. (An average of two averages?)

2)When adding a new 'employee' Data Sheet, or relabeling a current sheet, the calculation tables on the Team Sheet change, requiring that each be rechecked & corrected manually. I need a work-around, either having the Spreadsheet correct the formulas automatically (preferred), or Semi-automatic process which will allow for a less labor intensive update (Each of the 6 Team Sheets has 5-7 tables, with up to 30 employees listed for each table). If one Name/Sheet is changed/added every table must be validated & corrected.

3)Suggestions for streamlining the spreadsheet to improve speed, and reducing it's size using Visual Basic.

Færdigheder: Excel, Visual Basic, Windows Skrivebord

Se mere: need a new employee, excel &, employees new, new excel, n excel, need employees for data entry, windows automatic, Visual Basic Excel, summary table, pivot tables, pivot table excel, formulas sheets, excel\ , excel, excel visual basic, excel table, excel speed, excel PIVOT, excel pivot table, Excel Formulas, excel calculation, excel c#, excel based, excel 7, data correction

Om arbejdsgiveren:
( 0 bedømmelser ) Alder Point, Canada

Projekt-ID: #292239

46 freelancere byder i gennemsnit $125 for dette job

OlegBPavlov

Hello. Don't you want to rebuild your solution to the single compiled exe program with desktop database that does not require the MS Office to be installed for working? Plus - a high reliability and security. Regards

$250 USD in 5 dage
(1 bedømmelse)
3.6
cyberdeveloper

Hello Sir, Please send me the files and I can make free demo for you before you accept any bid. Then you can decide. I'm an excel programmer with 10 year of experience . Now I maintain large excel applications arun Mere

$120 USD in 5 dage
(12 bedømmelser)
3.0
lakshmidhanam

Hai, I am ready to work on this project with you to your utmost satisfaction. with regards, Lakshmi

$50 USD in 2 dage
(1 bedømmelse)
2.2
GISguru

Please check your PMB. Best regards.

$200 USD in 10 dage
(1 bedømmelse)
2.0
vishdube

Hi, Let me have this opportunity to provide you with the best solutions

$50 USD in 2 dage
(1 bedømmelse)
1.9
slashxdash

I can do this for you.5 days max. may be [url removed, login to view] my pm

$50 USD in 5 dage
(1 bedømmelse)
0.8
MEPS

Hello, I will gladly do this project for u in 3 days...I am a computer student and very well versed with Excel. Pls give me a chance to prove myself... Meena

$100 USD in 3 dage
(0 bedømmelser)
0.0
rmkalinrmk

Hello, Have much experience in finding and rooting out errors, in excel-based and visual basic applications. We have fully trained graduate-level peron and also Professional Engineer on staff. Thank you for your Mere

$60 USD in 3 dage
(0 bedømmelser)
0.0
tekbayga

I am new to the GAF community, but I can tell that you don't need someone to do this fast. You need it done right. My time estimate is based on the information you've posted, and I believe that once we find the calcu Mere

$150 USD in 15 dage
(0 bedømmelser)
0.0
rajanvohra

we can done Any kind of manipulation on excel

$100 USD in 3 dage
(0 bedømmelser)
0.0
eiger7703

I'm ready to do this job

$30 USD in 4 dage
(0 bedømmelser)
0.0
rcrinfotech

Dear Sir, I have 6 years experience about Excel or Data Entry and 5 years .Net(VB,C#.ASP)(VB,VC++, PhotoShop, HTML, Database Management System and other related S/ws). So, Hope I will have to complete your project. Mere

$30 USD in 5 dage
(0 bedømmelser)
0.0
sjconte

I will provide a quality product with exceptional turnaround.

$50 USD in 3 dage
(0 bedømmelser)
0.0
krishnapriya81

I am pretty fast in using excel,advance excel [url removed, login to view] deliver the project even before 7 days.

$200 USD in 7 dage
(0 bedømmelser)
0.0
kathir447

Hi, We can do this in minimum time frame .Please check PMB for detail.

$180 USD in 10 dage
(0 bedømmelser)
0.0
hgtyuj

Hi, I have a long experience in solving this kind of situations. I can do the Job. JT

$130 USD in 7 dage
(0 bedømmelser)
0.0
calcul8ors

Please visit our website [url removed, login to view] to see examples of previous work we have done. We are a small consultancy based in Melbourne Australia with years of commercial experience. Kind regards Shail Akhil C Mere

$250 USD in 10 dage
(0 bedømmelser)
0.0
mohbu

I am interested in the project.

$200 USD in 7 dage
(0 bedømmelser)
0.0
raghuraj1980

Please see the PM

$100 USD in 5 dage
(0 bedømmelser)
0.0
jitz4500

Hi, I understood what you are trying to get.. Let me see your file, i'll let you know in a day if i cannot do it, else will get it done by two days.

$30 USD in 3 dage
(0 bedømmelser)
0.0