İptal Edildi

An Access Report for Work Items

1. I have two tables that are being exported from an online database in an excel spreadsheet.

2. Each table contains data from a year.

3. The data contained in each table is similar.

4. There are unique item numbers in each table: completion dates for each item number, start dates, labor hours, etc. (date format: mm/dd/yyyy)

Example: Item 232323 - Date Created - Date Completed- Assigned to Agent Name- Labor Hours.

5. I need to build a report that can:

a. Compare the quantity of items present year to year, quarter to quarter (within years and between years), month to month.

b. Apply a numeric index for a range of hours for each item.

i. Example, item 2243 had 23 labor hours. I would have a scale where 1-5 gets an index value of 1, 5-10 gets 2, 10- 15 gets 3 etc…

ii. Once these indexes are calculated, I need to use this data to have percentage improvements comparisons year to year, quarter to quarter (with and between years), month to month.

c. Find turn around times for items. How fast they were completed (diff between date created and execution date) and here’s the catch. There’s another field called date completed. There needs to be a function that uses completion date in the calculation if execution date isn’t there.

d. FINALLY: I need to assemble all these numbers (the percentage improvements or decreases for each calculation, and give each calculation a weighted number based on the percentage. I need something like a progress bar at the bottom of the report to display this.

e. So need the progress bar, pivot charts to compare values (percentages and quantities), Tables. Etc. Is access the best option or excel to have something this analytical? THE CATCH: the report has to be reproducible, meaning, the end user can throw in next year’s item excel file from the online database and use that to compare last year’s data output. The quantity of items will constantly be increasing. So the xls output files being analyzed will be updated on a regular basis. . ALSO: I need to run multiple filters to weed out outliers in the data as well as specific members assigned to each item. (ex. Brian, bob, sandy, Jill are in the excel output… there are actually far more people in the output file (14000 items)), I would need to input a specific team with specific people (usually 10 people) into the report parameters, and filter those individuals and then run the metrics above. When it comes to outliers, I would want to not include certain data in the calculations for the report. For example, if I'm calculating turn around time, I would want to exclude items that have been worked on for more than 1 year. ALL IN ALL- This isn't too complex for someone who knows their stuff. There's just alot of formulas to put in and some clever design for the report. I'm asking for a performance report essentially. If any teams think they can accomplish the same analysis and task using excel (this includes being able to throw new data in every time we run the report), you are free to bid for that method as well. I need a complete product very soon.

THANK YOU. And please let me know if you have additional questions.

Beceriler: Veri Girişi, Veri İşleme, Excel, Microsoft Access, Visual Basic

Daha fazlasını görün: work find, pivot design, online visual basic 2010, online database work, online charts, numbers function, function numbers, free work online, find work online, find people work free, find online work, filters fast, execution table, design individuals need, best online work, bar work, asking work, pivot table report, uses excel, pivot online, free online excel spreadsheet, excel uses, complex meaning, report example, weed

İşveren Hakkında:
( 0 değerlendirme ) Glastonbury, United States

Proje NO: #755024

42 freelancer bu iş için ortalamada 411$ teklif veriyor

wsh2

Greetings Connecticut from Pennsylvania.. {smile} 25+ years of MsAccess (which you will need), MsExcel and Manufacturing (labor hours) experience. Please see PMB. Respectfully, Bill.

in 5 gün içinde750$ USD
(41 Değerlendirme)
6.3
schandraram

Hello - Please see PMB for details of my bid. Thank you. Chandra Ram.

in 15 gün içinde650$ USD
(123 Değerlendirme)
6.7
rajtuhin1

Serious bid here, I can start ASAP.

in 15 gün içinde750$ USD
(64 Değerlendirme)
6.2
Wonderer

Can be done perfectly. Thanks Al

in 5 gün içinde350$ USD
(44 Değerlendirme)
5.9
vbexcel

Over ten years experience in developing Excel/Access/VBA solutions.

in 7 gün içinde250$ USD
(31 Değerlendirme)
5.6
tootwotrue

Please see PMB for details. Thanks, Drew

in 7 gün içinde500$ USD
(9 Değerlendirme)
5.6
djucuti

Hello, pleas see PM

in 10 gün içinde250$ USD
(30 Değerlendirme)
5.1
KellogITSolution

Hello Ready to start right now. Please see your PMB for details. Thanks

in 7 gün içinde250$ USD
(40 Değerlendirme)
5.1
braghunath

I have been developing applications in MS Access since the year 2003. I can take up this project immediately. Thanks [url removed, login to view]

in 15 gün içinde360$ USD
(3 Değerlendirme)
4.1
ivancp

Hello, please read the PM

in 5 gün içinde350$ USD
(6 Değerlendirme)
3.7
amjadbashirawan4

Sir, I am an IT Professional having 8 years of working experience in Data Operations Management by using Databases , Applications & Web Based [url removed, login to view] deputed as Asst Manager in Largest Telecoms Company of Daha fazlası

in 30 gün içinde600$ USD
(2 Değerlendirme)
3.6
kaplar90

Please check inbox

in 2 gün içinde300$ USD
(6 Değerlendirme)
3.9
lohatama

What MS Access version do you use? If it is Access 2007, I could make it 1 or 2 days completion. The description you placed here is clear enough. But, I need to have the sample of xls file for my designing and programm Daha fazlası

in 0 gün içinde450$ USD
(5 Değerlendirme)
2.6
amf968

Good Morning - please see your private messages for bid details.

in 10 gün içinde650$ USD
(1 Değerlendirme)
2.6
freelancerbuzzo

Ready to start right now.

in 4 gün içinde250$ USD
(4 Değerlendirme)
2.6
lyusilru

Please, check your PM box

in 14 gün içinde260$ USD
(1 Değerlendirme)
2.4
proitagent

Hi there, I am a data analyst and programmer with an experience of over 15 years in application programming. I worked with SAS over years as consultant. I am happy to deliver you the [url removed, login to view] programming envir Daha fazlası

1 gün içinde 490$ USD
(1 Değerlendirme)
1.7
albariconsulting

please check PMB for details

in 20 gün içinde700$ USD
(1 Değerlendirme)
1.0
monycrap

I think the best solution is excel: Access is not too 'SMART' for reports: it's very good in databases management, but for analysis excel is preferred. I'm ready to start immediately.

in 5 gün içinde350$ USD
(0 Değerlendirme)
0.0
hemantgautam

I m from India, working with windows, sql server, access, vb6, [url removed, login to view],C, C#, Crystal Reports, foxpro since 1994, I have developed many projects like inventory, accounting, payroll, hotel management, School Fees Collect Daha fazlası

in 30 gün içinde700$ USD
(0 Değerlendirme)
0.0