How to make more presentable data out of large raw data excel files

[questforexcel]

Hi All,

I have large raw data files in excel (over 150MB in size) due to the size of records. Its a record of assets in book of the company and their depreciation schedule.

I have just added some dummy variables of a few records. How can I make this concise chart and more meaningful report.
The actual records range over 100K and the categories / name might be in hundred different kinds.

Firstly, I tried saving the excel file as binary but it did not reduce the file size by a lot. Is there any other way to compress the size without zipping it?

Secondly, How can i make this data for meaningful for my analysis and presentation to the team?

Thirdly, Could you guide on the best way to make a macro out of automating this task monthly.

Trying to learn working with larger data sets better, thank you for your guidance and understanding.

Name

Unique ID

Location

Group

Asset Name

Supplier

Total Cost

Useful Life

Months Depreciated

Months Remaining

Accumulated Depreciation

Book Value

Y1M1

Y1M2

Y1M3

Y1M4

Y1M5

Y1M6

Y1M7

Y1M8

Y1M9

Y1M10

Y1M11

Y1M12

Y1M13

Y1M14

Land

6387765.8​

185459.08​

60​

25.58

34.42

79,079.45

106,379.63

Machinery

35047584​

140064.66​

50​

6.60

43.40

18,478.75

121,585.91

Buildings

30914887​

869992.28​

50​

31.68

18.32

551,177.41

318,814.87

Automobiles

96140612​

763343.72​

60​

42.70

17.30

543,247.79

220,095.93

Fixtures and Fittings

32165975​

598640.85​

50​

1.13

48.87

13,504.70

585,136.15

Laptops

36431144​

406740.08​

60​

13.17

46.83

89,249.86

317,490.22

 

[awoohaw]

you could do column charts with icons for certain proportions of each series. 1 Building Shape could be $100,000 of builings.
a car shape could be $100,000 of automobiles, or 100 cars? same for laptops. Land would be a tough icon to figure out, Laptops would be a laptop.

you could split them up into items with useful life remaining in month buckets (0-6,7-12, etc).