Find Jobs
Hire Freelancers

365098 Excel utility for FT program

N/A

In Progress
Posted over 14 years ago

N/A

Paid on delivery
Daniel, this is an urgent Excel refinement to the FT program. Could you do it on the fly ? If not, I must ask somebody else. ---------------------------------Description--------------------- This Excel utility aims at preparing for easier further calculations te output files of Formula 3 A ------------------------------------------------------------------- 0) the utility will open all F3A files and save them each as Excel file (Excel 2003 workbook xls) with their same name 1) select the whole worksheet and set font "calibri 10" 2) select first row at the top and center content (these will be the headers of the columns) 3) set headers'font to bold , "black color", "light yellow" background 4) place headers'row in an horizontal pane and freeze it, so that the headers remain fixed when the window is scrolled 5) select all worksheet's columns and autofit their width 6) select "ClosingDate column" and set format of its content to "[login to view URL]" 7) select all columns right to ClosingDate (from "Price" to "EV/Ebit" column) and align their content to the right, then set their numerical format to "two decimals" and with "red" as color of the negative numbers: #,##0,00_);[Red](#,##0,00) --- be careful keeping alignment of headers to center, not to the right ! 8) eliminate gridlines'view 10) select the whole content of the worksheet and sort by "ClosingDate" ascending 11) select columns from P/S to EV/Ebit and highlight their background in "light turquoise" 12) create as many copies of the worksheet of (the worksheet not the workbook !), as there are years in the content of ClosingDate column: 2004, 2005, 2006, 2007, etc.. Each single worksheet shall be named after the year !! 13) delete from each single year-worksheet all rows of data that refer to a different year than the name of the worksheet. As an example, the 2004-worksheet shall contain only 2004 data 14) select the content of each year-worksheet and sort by "Market Capitalisation", ascending 15) out of each year-worksheet generate two worksheets: the first will contain only the rows of data that have a Market Capitalisation equal or lower than 500.000.000. The second will contain only the rows of data that have a Market Capitalisation higher than 500.000.000,00. You will label the resulting worksheets this way: "YYYY 500M-" and "YYYY 500M+" (examples: "2005 500M- " "2009 500M+") save and close all files ----------------------------------------------------------- I attach a sample. Please reply soon Ciao Ascanio
Project ID: 2110936

About the project

Remote project
Active 12 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of ITALY
Rome, Italy
5.0
13
Member since Jul 18, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.