Em Andamento

Excel Inventory report with 2 graphs

Changes to the Inventory Excel report. Excel with about 16 columns of basic inventory information. but will need some new values and totals added to the report.

Modernize the look. Please do not look at how the report is currently setup and use your own ideas. We have been using this report for a long time and need a different look. Make changes of colors as you like.

Add logo to the report

Totals at the top of the report so they stand by themselves; Decking Inventory and Direct on Order. This can be determined by column “H” = to ‘DE’ for Decking and ‘DO’ = Direct on Order.

New column we are adding. Column ‘J’ called Days. This amount in this field will be calculated based on column “I” / unload/pd date’/ Current Date. For example if unload date is 10/05/2013 and today is 11/05/2013, the ‘Day’s will equal 31 days. In addition to the days that will display, I would like to see 1 of 3 symbols. If the days are between 0-180 then print the days and a ‘Green symbol’. If the days are between 181-360 then print the days with ‘yellow symbol’. If the days are more than 360 then print the days with ‘red symbol.

Sort report by Column ‘g’ and ‘h’. and a total after each ‘G’ Location

I would like 2 basic graphs.

Graph #1. Looking at column ‘j’ Percentage of inventory that is in the three different categories. 0-180 then print the days and a ‘Green symbol’. If the days are between 181-360 then print the days with ‘yellow symbol’. If the days are more than 360 then print the days with ‘red symbol.

Graph #2 Inventory Total with percentage based on ‘Location’. i.e. Regal has this much total inventory and is this percentage of inventory.

A column at the end of the report that we can filter on ‘active inventory’ Yes or No. All the Totals that will be referenced in the report will be for items that are equal to active inventory ‘yes’ meaning they are still on inventory.

Habilidades: Excel

Ver mais: inventory report, top graph, how to graphs, graph top, graphs in c, graphs c, graph graphs, example of graphs, c graphs, all about graphs, a graphs, about graphs, symbol of red, report example, make your own symbol, sort excel, modernize, h symbol, graphs, Excel report, excel inventory, excel graphs, decking, active filter, excel sort date

Acerca do Empregador:
( 7 comentários ) West Linn, United States

ID do Projeto: #5097562

Premiar a:

zExcel

My name is Jon and I'll be happy to help you with this project. I'm available to start on it right away if you're ready ------------------------------------------------------------------------------------------------- Mais

$66 USD em 1 dia
(9 Avaliações)
3.8

11 freelancers estão ofertando em média $97 para este trabalho

nagybatonyi

In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are include Mais

$77 USD in 3 dias
(48 Comentários)
5.7
rohitpithisaria

Hello Please find attach my previous work on excel which will give u a fair idea of my excel skills. So with the type of work i have done till now in excel will make me a suitable candidate to apply for this job. Rg Mais

$155 USD in 3 dias
(9 Comentários)
3.6
inoussakabore

I am a statistician working as a database manager and data analyst there is 4 years. I am ready to do this job for you

$54 USD in 3 dias
(2 Comentários)
3.3
pankajgarg10

More then 7 years of working experience in Telerik Open Access ORM, Entity FrameWork using Code First, Database First Approaches, ASP.NET, Window Service, Web Service, MVC 3.0, MVC 4.0, C#, VB.NET, SQL Server 2008, JQU Mais

$50 USD in 5 dias
(0 Comentários)
0.0
tito5615104

A proposal has not yet been provided

$77 USD in 3 dias
(0 Comentários)
0.0
mastermontilla

Hi,. I would like to offer my service to this project. My qualification can help you to reach your goal. Feel free to check my portfolio. Look forward to it. Thanks... Check my previous excel job: https://www.dropbox.c Mais

$155 USD in 3 dias
(0 Comentários)
0.0
esguejp123

I have been practicing accounting for the past 10 years and use MS Excel as one of my primary programs. I can be of help to your job requirement. Cheers!

$77 USD in 3 dias
(0 Comentários)
0.0
silva1990

A proposal has not yet been provided

$133 USD in 2 dias
(0 Comentários)
0.0
boukari1

le traitement du texte et la saisie des données par le Word et Excel sont tout ce que je sais faire. faites moi confiance alors et vous verrez. cordialement

$45 USD in 4 dias
(0 Comentários)
0.0
DaceS

A proposal has not yet been provided

$155 USD in 3 dias
(0 Comentários)
0.0
SRAULT

Hello - I have worked with dozens of different types of inventory reports in Excel format, some of which are very complex and in various industries. I think that I could incorporate some of the best features from these Mais

$55 USD in 3 dias
(0 Comentários)
0.0
jyotsnaaus2012

Hi, I have done a lot of data analysis and I have an eye for detail. Moreover, I have advanced level proficiency in excel. Regards, Jyotsna

$155 USD in 3 dias
(0 Comentários)
0.0