Convert Excel into Pivot Table with Forecasts and Annual/Monthly/Daily Comparisons, Etc.

完了済み 投稿 4年前 着払い
完了済み 着払い

PLEASE READ FIRST.

ADVANCED EXPERTS ONLY

THIS PROJECT IS CONFIDENTIAL.

The attached Excel sheet provides a sample of the data entered into by employees of a restaurant. The attached sheet is blank, but the formulas and appearance are there for reference.

The data includes daily sales, inventory, ledger balance, number of transactions, etc. Please note that the calculations that the sheets produce is accurate. You will need to look at the formulas to understand how each field is calculated.

There are areas within the sheet that can be improved. We are only looking for someone to take that data, improve the functionality of the sheet, and present the data in a more usable form (on another sheet within the Workbook), such as with graphs, charts, etc.

We are looking for an expert to do this.

Potential areas of improvement (though I will ask that you provide additional suggestions):

1)The dates on the sheet end on 12/31/25 through the Subtotals function. This will need to be extended many years into the future.

2) The data is not currently charted or graphed in any way. Forecasts, an easy way to compare this month with the prior month, this month with the same month last year, or this day to the same day last year, etc. would be useful.

3) The chart is a little slow, which may be from the use of Subtotals.

4) Other areas of improvement that you identify.

5) It would be helpful to compare data between the two locations.

6) Filter the data, subtotal by various ranges and compare.

7) Generate reports based on the data.

8) Easily see % growth or decline in each of the categories.

9) Etc.

There are two locations, one location has about 6 years of data and the other has 3 years of data. I will provide the sheets with the fields completed upon project acceptance. I will also provide explanation for each column as needed.

This will likely be an ongoing project, as we find more uses for the Workbook.

Finally, the work must be clear and well documented.

エクセル 情報処理 ビジュアルベーシック データ入力 PHP

プロジェクトID: #21337815

プロジェクトについて

50個の提案 リモートプロジェクト アクティブ 4年前

アワード:

bhupendrayadav

I am postgraduate (MBA) in finance with more than 6 years of experience in financial modeling, dynamic dashboards, graphs & charts, MIS reports, advanced excel based tools, VBA automation, google scripting and data pr もっと

$250 USD 3日以内
(44レビュー)
5.8

50人のフリーランサーが、平均$164 で、この仕事に入札しています。

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl もっと

$250 USD 4日以内
(476件のレビュー)
8.3
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$150 USD 3日以内
(454件のレビュー)
7.8
zekovicm

Hi there,I am Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed もっと

$235 USD 7日以内
(208件のレビュー)
7.9
sparkingboy2010

Hi, I am ready to start right away. I'm an expert in Data Entry. I have reviewed your job description as well and very confident to handle this project perfectly. I understood your all requirements. I have done many もっと

$140 USD 1日以内
(361件のレビュー)
7.2
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje もっと

$250 USD 7日以内
(299件のレビュー)
7.2
rashedkhanrubel

Hi, I have understand the project requirement & interested to update current data file with dynamic report, chart and pivot as required for this project. Please send a message so we can discuss more & start the project もっと

$60 USD 2日以内
(262件のレビュー)
6.8
StormLion227

Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert VBA programmer on freelancer.com and I do not bid on もっと

$155 USD 3日以内
(94件のレビュー)
6.3
razvancotofana

Hello, I have substantial experience in excel and VBA, and I will be happy to assist you with the visuals you are looking for. Most probably the solution that may fit your requirements will be a Power BI dashboard. Ple もっと

$250 USD 10日以内
(20件のレビュー)
6.0
tutulsoft

--- READ TO WORK -- Same field i have experiences.............................................................................

$250 USD 7日以内
(24件のレビュー)
5.5
paulodayto08

Hi Good Day! A serious freelancer here. I've done a lot of work like this one before. I suggest to create a automated tool using VBA macro to make it more efficient and use this tool for long term. I can help you wit もっと

$100 USD 3日以内
(56件のレビュー)
5.0
reubengi

Hi, I have constructed similar performance review systems using raw data running into more than 10 years of data using simple dropdown selection boxes at the user end. The datasheet has to be rationalised a bit and the もっと

$170 USD 7日以内
(19件のレビュー)
4.9
GopalJp

Hello Sir, I will improve your spreadsheets and add more values into it in terms of smoothness and reliability. I am extremely good at excel as it's part of my daily professional life. I am an accountant having 8 ye もっと

$250 USD 10日以内
(16件のレビュー)
4.7
mowachira77

Hi there. I have read and understood your project requirements. I understand that your need to create a pivot table with future projections. I am proficient in excel and VBA to deliver this work in two days. I am avail もっと

$100 USD 2日以内
(32件のレビュー)
4.6
Prompty

Hi, i am a data analyst expert using EXCEL for portfolio management and other applications. I understand your requirements for analysis and report. Will do it neatly in consultation with you

$180 USD 6日以内
(23件のレビュー)
4.4
Aragornsan

Hi there, I would like to discuss possible improvements and ask a few questions regarding this sheet. I am an accountant from South Africa and I have extensive Excel and MSOffice experience. I specialise in excel repor もっと

$250 USD 7日以内
(10件のレビュー)
4.4
emilianoreyes70

HI! Im able to work in a draft version. Its important to keep it simple (i know restaurant Business), Sugestion, shoul add sales /Dept. in case your final sales report it. REgards, Emiliano I am a entrepenour ( ex- もっと

$150 USD 7日以内
(16件のレビュー)
4.5
eduuardo

Can i share screenshots with you of my beautifull Cash Flow, Gross Margin model, CoPlan budget dashboard and other tools developed by me with high standard algorithms and Finance knowledge? 13 years excellence in MS もっと

$250 USD 7日以内
(21件のレビュー)
4.0
UsmanNasar87

Hello, I have very good knowledge of MS Excel such as formulas (sumifs, vlookup, and, average, concatenate, countifs, iserror, match, min, max, mid, left, offset and many more), charts, data analysis, calculation, diff もっと

$225 USD 5日以内
(22件のレビュー)
3.3
aatqahussain

Hi, I am ready to start right away. I have done many similar projects like this and have vast experience of working with formulas and pivot charts.. I have reviewed your job description as well and very confident to ha もっと

$150 USD 7日以内
(レビュー1件)
2.8
ramchauhan11

1)The dates on the sheet end on 12/31/25 through the Subtotals function. This will need to be extended many years into the future. 2) The data is not currently charted or graphed in any way. Forecasts, an easy way to c もっと

$140 USD 7日以内
(0件のレビュー)
0.0