Track and manage Assets

£2.99

This Excel file help you to track and manage your assets. Which can be used for all kind of organization, companies and individuals. You can submit, update and view asset data, suppliers, persons who using the asset, utilization center, insurances, warranties, repair centers and periodical maintenance operations. This software is developed in Microsoft Excel based on Macro (VBA programming), so it’s really easy to use and can be edited as you need (because it’s just Excel).

For more information, please watch the video in description

This Excel file should be used by Microsoft Excel 2013, 2016 or above

Description

Product purpose

This software is developed for Track and manage assets in organizations, companies, offices, or individuals. By using this software, you are able to submit, maintain and track all your assets information. In general, this includes, asset data, suppliers, person who is responsible for this asset, the utilization center, maintenance operations, insurances, warranties and repair centers.

General description

Asset Form

The main user form in this software is the “Asset Form”, which is the place that users can define new assets and update previous ones. This form has following sections.

Asset information (for track and manage company assets)

information this section includes: Asset code, Asset title, Asset description, current status, status start date, and purchase date.

Responsible person

The person who use this asset, or who is responsible for its safety can be defined in this section. If you managing a company asset this person could be the employee who is using an asset. This section includes: Employee Id, name and contact information.

Utilization center

The utilization center is the place that a specific asset is there. This section includes: Utilization center title, Address, environmental condition. Also, you are able to define the asset specific environmental condition in this section.

Insurances

In this section you are able to define and manage all insurances related to a specific asset. This section includes: Insurance number, title, description, validity date as well as the information of company who issued this insurance (name, address and contact information)

Warranty

In this section you are able to define and manage all warranties related to a specific asset. This section includes: Warranty number, title, description, validity date as well as the information of company who supports this warranty (name, address and contact information)

Repair centers

When an asset damaged and needs to be repaired, we need to contact its well-known repair center, which can be lots of companies. In this section you are able to define all companies that are able to repair one specific asset as well as describe their customer services. This section includes: Repair center name, contact information, address, and note about this center.

Periodical maintenance

Most assets need periodical maintenance. So that, in this section you are able to define and manage all kind of operations that need to be done in a periodical manner. This section includes: Operation title, description, technical description, period. Also you can assign an individual (or a company) that is responsible for do each operation (their personal ID, name and contact information)

Supplier

In this section you can manage the purchase data. This section includes: invoice number, supplier name, contact information, address and note to supplier.

Data table

All data that are submitted in the asset form will placed in their own related tables. In this software we define a table for each section as well as one table for each company or person information. All tables can be easily viewed and data can be edited and also user can generate own report by them.

Other forms

This software contains following form for which users be able to see all asset related to each section of asset form.

Employee Form

By entering the employee ID (the person who is in charge of asset) in this form, users can see all assets that are in hand of this specific employee.

Also you are able to update the employee information here.

Maintainer Form

By entering the maintainer ID (the person or company who is in charge to do the periodical maintenance) you are able to see all operation and their relative periodical operations that should be done by this person.

Also you are able to update the maintainer information here.

Utilization center form

By entering the utilization center title (the place which assets are placed there) you are able to see all assets that are placed in this center.

Also you are able to update the utilization center information here.

Insurance form

By entering the company name (the insurance company) you are able to see all insurances and their relative assets that are issued by this company.

Also you are able to update the insurance company information here.

Warranty form

By entering the company name (the warranty company) you are able to see all warranties and their relative assets that are issued by this company.

Also you are able to update the warranty company information here.

Repairer form

By entering the company name (the repair center name), you are able to see all assets that can be repaired by this company.

Also you are able to update the repair center information here.

Supplier form

By entering the supplier name, you are able to see all assets that are purchased from this specific supplier.

Also you are able to update the supplier information here.

 General capabilities of software: Track and manage assets

This software is developed in Microsoft Excel by using VBA programming in Macros. Since this software is developed in Microsoft Excel, users can use all Excel tools. Also, there is no restriction or password in this software.

This software has below capabilities:

  • Submit, update and load assets data
  • Includes all needed information for all kind of assets
  • Can submit multiple insurances
  • Can submit multiple warranties
  • Can submit multiple repair center and define your own customer experiences for each of them
  • Can submit multiple periodical maintenance operations
  • Well defined data table for view, edit and generating reports
  • Viewing all related assets and information for each company or person

Reviews

There are no reviews yet.

Be the first to review “Track and manage Assets”

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.