Ditutup

Excel- Combining Reports & Formatting Comparison Spreadsheet

There are several 4 folders.  Within each folder, there are Quarterly Reports for the last 10 years. I need certain data from each of these Quarterly reports combined in to one Master spreadsheet for each folder. I will go into more detail about the data that needs to be extracted and combined on to one Master spreadsheet with the winner of the bid as it may be confusing to describe here. 

Once the data is combined, I need every other week highlighted. The date ranges are provides in a separate spreadsheet that is designed to be a side by side comparison. 

A column titled "Total Net Profit" needs to be created which literally taken 30 seconds to do.  

 I also need to know run ups and drawdowns. If there are several profitable trades in a row, I need that added up in the "Runup" Column. If there are several losses in a row, I need that added up in the "Drawdown" column.

All the data described above will be used to fill in the blanks on the Comparison Spreadsheet.

For the Comparison Spreadsheet, a tab has been created for each month. Within each monthly tab, you will see the weekly date ranges for the last 10 years for that month.

For each of the 4 Master spreadsheets just created (the 5th one is already completed), I need a sum for the date ranges provided under the columns titled "Gross...".  The amount used in this column is found in the spreadsheet you are creating titled "Profit/Loss." This spreadsheet can be formatted any way that makes the extracting the sums from the other spreadsheets easier as there may be an automated way of completing this. 

I will take care of the rest of the spreadsheet. 

Kemahiran: Pemasukan Data, Pemprosesan Data, Excel

Lihat lebih lanjut: bid master spreadsheet, bid comparison spreadsheet, excel column, month spreadsheet, master excel, row spreadsheet, fill spreadsheets excel, excel reports, data formatting, excel row column, net spreadsheet, data fill excel, excel column row, drawdown, column row excel, excel fill, profit amp loss, fill data spreadsheet, creating spreadsheets, entry trades excel, data entry folders, net reports, fill excel spreadsheet data, columns excel, profit spreadsheet

Tentang Majikan:
( 0 ulasan ) eheliyagoda, Sri Lanka

ID Projek: #1541508

14 pekerja bebas membida secara purata $125 untuk pekerjaan ini

microk

Expert here.. Please check PM..

$40 USD dalam 2 hari
(32 Ulasan)
4.5
himanshuhc

Hi, I can prepare an automated solution for you so that you get 100% accuracy and fast execution speed. The generalized solution would work for you even if you wish to do similar processing in future eliminating the ne Lagi

$50 USD dalam 2 hari
(13 Ulasan)
4.3
feri1212

hi sir i am ready this work.

$30 USD dalam sehari
(0 Ulasan)
0.0
ahmed497

i am ready for this job

$250 USD dalam 7 hari
(0 Ulasan)
0.0
sapnaramchand

Hi, I am Sapna ( 20 years experience in microsoft packages, Adobe packages and Autodesk Packages), willing to complete your excel project work in 20 days. so that you have 10 days to re-check and make yourself comfort Lagi

$30 USD dalam 20 hari
(0 Ulasan)
0.0
aryathelife

i excel at excel sheets and provide the best of the works within limited time and always work towards perfection!

$50 USD dalam 2 hari
(0 Ulasan)
0.0
PankajMalhotra

Hi, I have worked in a very similar project.I assure you that I can do your work with efficiency and in time. Thanks & Regards Pankaj Malhotra

$150 USD dalam 10 hari
(0 Ulasan)
0.0
gilgalant

Hi sir. I have strong knowledge on excel spreadsheets and have been dealing with large files and consolidation for several years in the banking sector. Will finish your work in time and totally according to your needs Lagi

$70 USD dalam 10 hari
(0 Ulasan)
0.0
cstwitterffbfnsg

Please check PMB

$30 USD dalam sehari
(0 Ulasan)
0.0
drkvsubramanian

Dr. K.V. Subramanian is a graduate in Electrical Engineering from NITK and a Fellow in Management from IIM Bangalore. He has over 30 years of experience in Engineering, IT & Management Consultancy, Management Education Lagi

$500 USD dalam 7 hari
(0 Ulasan)
0.0
engr321

ready to chilllllll

$200 USD dalam 20 hari
(0 Ulasan)
0.0
btripathy76

Hi, This is an excellent data entry operator since a decade ago.Assure you 100% accuracy. Thank you.

$30 USD dalam 2 hari
(0 Ulasan)
0.0
mrkamranumer

Hi Please see my PMB Regards

$120 USD dalam 4 hari
(0 Ulasan)
0.0
Asareere

Hi, With regards to the output requirement we can write a Excel VBA macro which could consolidate the data into the single spreadsheet and make formatting/evaluations as per the specification. I have experience on c Lagi

$200 USD dalam 10 hari
(0 Ulasan)
0.0