İ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 values, work online free, work find, visual basic 5 online, pivot design, online visual basic 2010, online database work, online charts, numbers function, how to know how i work with formulas on excel, how to find someone to design a product, function numbers, free work online, find work online, find where people work for free, find people work, find online work, find it work, filters fast, execution table, design for individuals need, design for free online, design analysis report, c# report, bid for work online

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

Proje NO: #755024

42 freelancers are bidding on average $411 for this job


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)

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

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

Serious bid here, I can start ASAP.

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

Can be done perfectly. Thanks Al

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

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

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

Please see PMB for details. Thanks, Drew

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

Hello, pleas see PM

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

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

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

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)

Hello, please read the PM

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

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)

Please check inbox

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

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)

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

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

Ready to start right now.

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

Please, check your PM box

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

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)

please check PMB for details

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

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)

I m from India, working with windows, sql server, access, vb6, vb.net,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)