Завершено

MRP and Earned Value

One data file is from a SAP system and updated weekly. The second file/sheet is a base file that will not change but needs to be compared to current data. Finally, the third file/sheet is the schedule.

The project always begins with the second file to create a baseline budget. The schedule is then created based on previous delivery of material from the baseline. The third file updated weekly need to be ingested into the file to compare what was originally in the baseline for cost and schedule. This also has to identify additions/differences from baseline to the current weekly file. Some lines will have duplicate material but may be assigned to a separate account and/or the same. It the same, the quantity and cost need to be summed.

The material is summed into a kit or module and needs to be added together so that the sheet shows progress to complete.

The data needs to be available on a dashboard tab that reflects earned value data and graphs for each account or work package.

This is a material resource plan and earned value together into one file. The weekly file will be updated weekly in the file.

Квалификация: Обработка данных, Excel Macros, Excel VBA

Показать больше booking module, differences excel files, subscribe module joomla, pmi earned value management pdf, earned value management formulas pdf, history of earned value management, earned value analysis, how to manage fixed price projects, earned value on fixed price contracts, rules of credit earned value, earned value management, zencart alertpay payment module, color value jsp, using mod rewrite create module system, module value calculator, earned value programwindows application vbnet, earned value international data standards, prestashop value discount module, EARNED VALUE, mrp module

О работодателе:
( 0 отзыв(-а, -ов) ) Santa Barbara, United States

ID проекта: #19310591

Поручен:

Изображение профиля                                                     dgled
                                                "                                                    >
                                                </a>
                                            </figure>
                                        </div>
                                        <div class=
dgled

Hi, I can prepare reports and dashboards in Excel by importing external databases from Intuit QuickBooks, (SQL, or Excel file) and manipulating the data in a structured database. During the process, Excel validates the Больше

$100 USD за 1 день
(17 отзывов(-а))
5.9

8 фрилансеров(-а) в среднем готовы выполнить эту работу за $157

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. Больше

$250 USD за 4 дней(-я)
(197 отзывов(-а))
7.6
polarjin2017

This is Excel /VBA result which I 've done [login to view URL] This is what i have done in Excel/VBA/MACRO. Just Crreating forms, query, Macro, custom formula, etc... I;ve done so many jobs in excel like l Больше

$150 USD за 3 дней(-я)
(40 отзывов(-а))
5.8
rishabhmishra93

Hi, I am an ETL developer with wide experience in data extract and load. I have wide experience in handling very large varieties of source files which included excels and csv as well. we have certain open source tool Больше

$111 USD за 7 дней(-я)
(1 отзыв)
1.1
VasilyIvoyzha

Hello, I can do this in short time (I've completed similar projects), here confirmation of my codding skills: [login to view URL]

$144 USD за 1 день
(0 отзывов(-а))
0.0
rahulsujatha03

super super cute little face and you can do it for me to come over and over again and I don't know what I want to upload like some of the African American Horror Story hotel episode of the African American Horror Story Больше

$30 USD за 1 день
(0 отзывов(-а))
0.0
fjanzen

Industrial Engineer with 7 years of experience in Project Management/ Engineering for major Oil&Gas Projects. Advanced skills in Excel, VBA, SAP integration , Project Baseline and Budget Analysis in SAP/ MS Project/ P Больше

$222 USD за 5 дней(-я)
(0 отзывов(-а))
0.0
markchristopher8

Hi, I hope all is well. I am a Certified Public Accountant here in the Philippines. I have been working as an auditor/accountant/finance analyst since 2010 (i.e., immediately after my graduation and after passing the Больше

$150 USD за 3 дней(-я)
(0 отзывов(-а))
0.0