完了

Excel Macro - Calculate Average Sales per weekday per customer

NOTE: This macro must be written for the Excel Personal File.

If you do not know what this means, please do not bid.

My accounting system is MYOB.

From this system, I intend to export a sales file covering a number of weeks. Usually 4 but can be more or less

I have a spreadsheet that functions as a MASTER sheet. It contains item codes in the Rows and needs to contain Customer Names in the columns.

In the cells corresponding to customer name and item code, the cell must contain the average sales quantity for that item as calculated from the MYOB sales file.

Requirements:

- Macro must create a new column per week day per customer as dictated by the Sales file.

- Average quantities that result in non-integers must be rounded up the nearest integer

- Items in the Sales file that do not appear in the Master file (if any) must be dealt with elegantly. Perhaps inserting their details at the bottom of the master is best.

-The Master sheet will contain a template customer column for duplication when inserting a new specific customer column.

- The top cell of the customer column (Row 1) must contain an abbreviation of the week day (Mon, Tue, Wed, Thu, Fri, Sat, Sun)

- The second cell of the customer column (Row 2) must contain an abbreviation of the customer name as specified withing the worksheet "shortnames" of the Master file

- Dialog box must show at completion of execution regarding status. I.e. whether all quantities were successfully inserted or if there were problems such as item codes that were not found.

スキル: 会計, データ入力, 情報処理, エクセル, ビジュアルベーシック

さらに表示: excel average per day, monthly average excel pivot table, how to calculate hourly average in excel, average by day of week excel, calculate average by date in excel, how to calculate weekly average in excel, excel calculate average by day of week, how to average based on day of week in excel?, excel macro fill empty cells, excel macro data cell, excel vba macro calculate business days, excel macro function moving average, excel calculate projected sales, formula calculate projected sales excel, calculate average days sales uncollected, average sheets excel macro, calculate average projected excel, macro calculate area bounding line excel, excel macro calculate spreadsheet, excel analyze historical sales data customer

採用者について:
( 7件のレビュー ) ERMINGTON, Australia

プロジェクトID: #18072160

アワード:

supper5guy

Hello there, thanks for inviting me to bid on your project, I am looking forward to serve you as best as i know how. Thanks again

$100 AUD 3日以内
(80レビュー)
5.5

18人のフリーランサーが、このジョブに平均$158で入札しています

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( もっと

$200 AUD 2日以内
(643件のレビュー)
8.3
schoudhary1553

Hello, Hope you are doing well. I can help with you in your project Excel Macro - Calculate Average Sales per weekday per customer . I can assure you the quality job. I have good experience in Accounting, Dat もっと

$250 AUD 4日以内
(303件のレビュー)
7.7
zExcel

I'd be happy to help you with this project. I'm experienced with all Excel functions including advanced formulas and macros and I have an excellent record of quick turnaround time. Just let me know when you're ready a もっと

$200 AUD 2日以内
(260件のレビュー)
7.7
dgled

Hi, I did similar projects regarding sales statistic and trends. regarding the " Excel Personal File", I will implement it at the end of the project it is just to change the file name to [login to view URL] and to put it un もっと

$250 AUD 3日以内
(74件のレビュー)
6.8
paris2785

Hello! My name is Paris. According to your brief, you need someone to write a macro that will perform some actions you mention in your summary. All of them make sense. I've no questions about them. At the end of the もっと

$140 AUD 4日以内
(171件のレビュー)
6.9
polarjin2017

Hello? How are you? I have good experiences in "Excel Macro - Calculate Average Sales per weekday per customer" as you can see my profile for these (Accounting, Data Entry, Data Processing, Excel, Visual Basic). I h もっと

$155 AUD 3日以内
(68件のレビュー)
6.4
rakeshwadhwani

Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and もっと

$155 AUD 3日以内
(66件のレビュー)
6.3
daniyal3214

I am a professional Financial Analyst, Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel to perform Financial Modeling, Financial Analysis, Financial Fore もっと

$85 AUD 1日以内
(145件のレビュー)
6.2
sonarkaushik

Sir, I am very able to create this macro flawlessly and can do your project as per your requirement. I am very much able to work on this. ***I am ready to start Message me for further discussion. Waiting to he もっと

$144 AUD 2日以内
(102件のレビュー)
6.2
dvcontact

Hi, You won’t select the right candidate without knowing what your project on developing a macro to calculate average sales per weekday per customer will look like. Fortunately, I can complete a part of your job befor もっと

$150 AUD 3日以内
(35件のレビュー)
5.5
citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mar もっと

$150 AUD 3日以内
(67件のレビュー)
5.6
sloker18

I am proficient with Microsoft excel and macro/VBA development, I can generate the report dataset as specified, if you are interested feel free to message me, I am available to start your project immediately, looking f もっと

$150 AUD 3日以内
(48件のレビュー)
5.0
jasalaz100

Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after com もっと

$177 AUD 5日以内
(30件のレビュー)
4.8
anisheco

Hi, I have 10+ years of experience in report/process automation using MS Excel with VBA. I read the job description and understand that you are looking for an addin (xlam) file (Personal macro book), to perform calcula もっと

$200 AUD 1日以内
(3件のレビュー)
3.3
kadianamit2609

Hey, I understand your requirements and i am sure i can build this efficient process for you. I am 9 years experienced professional with expert knowledge of data collection, transformation, analysis and visualiz もっと

$83 AUD 2日以内
(4件のレビュー)
2.4
GopalJp

Hi, I hope you are doing well! I have gone through your project description. I am able to develop your requirement in excel since I am having good knowledge on macros,VBA module and many more. I am ready to work und もっと

$100 AUD 2日以内
(3件のレビュー)
1.4
nukuly

Hi There, I'm an advance excel expert, can help you on your project and ready to start asap. Although I'm relatively new here but pretty confident of delivering excellent outcome. Please award me this project. もっと

$155 AUD 3日以内
(レビュー1件)
0.8