Ditutup

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.

Kemahiran: Excel, Visual Basic, Destop Windows

Lihat lebih lanjut: need new employee, employees new, new excel, n excel, need employees data entry, windows automatic, summary table, pivot tables, pivot table excel, formulas sheets, excel visual basic, excel speed, excel pivot, excel pivot table, excel formulas, excel calculation, excel based, excel 7, data correction, correction, calculating, c update, data excel work sheets, amp excel, across multiple

Tentang Majikan:
( 0 ulasan ) Alder Point, Canada

ID Projek: #292239

46 pekerja bebas membida secara purata $125 untuk pekerjaan ini

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 dalam 5 hari
(1 Ulasan)
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 Lagi

$120 USD dalam 5 hari
(12 Ulasan)
3.0
lakshmidhanam

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

$50 USD dalam 2 hari
(1 Ulasan)
2.2
GISguru

Please check your PMB. Best regards.

$200 USD dalam 10 hari
(1 Ulasan)
2.0
vishdube

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

$50 USD dalam 2 hari
(1 Ulasan)
1.9
slashxdash

I can do this for you.5 days max. may be sooner.check my pm

$50 USD dalam 5 hari
(1 Ulasan)
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 dalam 3 hari
(0 Ulasan)
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 Lagi

$60 USD dalam 3 hari
(0 Ulasan)
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 Lagi

$150 USD dalam 15 hari
(0 Ulasan)
0.0
rajanvohra

we can done Any kind of manipulation on excel

$100 USD dalam 3 hari
(0 Ulasan)
0.0
eiger7703

I'm ready to do this job

$30 USD dalam 4 hari
(0 Ulasan)
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. Lagi

$30 USD dalam 5 hari
(0 Ulasan)
0.0
sjconte

I will provide a quality product with exceptional turnaround.

$50 USD dalam 3 hari
(0 Ulasan)
0.0
krishnapriya81

I am pretty fast in using excel,advance excel etc.can deliver the project even before 7 days.

$200 USD dalam 7 hari
(0 Ulasan)
0.0
kathir447

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

$180 USD dalam 10 hari
(0 Ulasan)
0.0
hgtyuj

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

$130 USD dalam 7 hari
(0 Ulasan)
0.0
calcul8ors

Please visit our website www.calcul8ors.com.au 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 Lagi

$250 USD dalam 10 hari
(0 Ulasan)
0.0
mohbu

I am interested in the project.

$200 USD dalam 7 hari
(0 Ulasan)
0.0
raghuraj1980

Please see the PM

$100 USD dalam 5 hari
(0 Ulasan)
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 dalam 3 hari
(0 Ulasan)
0.0