Here is a guide on how to set up or create an automated computer assembly budget using Microsoft Excel software.
In this Excel video tutorial this time, Asaljeplak will give you a little simple tutorial on how to create a budget that is used to build computer assemblies that can be filled automatically using Microsoft Excel.
How can this help? Because this will be easier than you have to back and forth to change the price of computer spare parts manually, and if there is any price change you can immediately update quickly.
This method can also be used by anyone, whether you just want to calculate the cost of computer assemblies for personal or for gaming, until you who want to establish a cafe or internet cafe, and you want to calculate the total cost of computers for the needs of the company / office .
Put simply, the steps you need to do are as follows:
Create a table with columns entitled Components, Amounts, Brands, Unit Price, and Total Price.
In the Components column. enter the desired spare part category, eg Processor / CPU, RAM / Memory, Hard Disk, VGA Card, Casing, etc.
In the Amount field, enter the quantity of each desired spare part, generally there is only 1 spare part unit per computer, with the exception of for example you want to buy 2 RAM, 2 Harddisk or 2 VGA Card.
In the Brand and Unit Price columns leave blank, this will later be filled automatically.
In the Total Price column, enter the multiplication formula between the Number cell and the Unit Price cell
Create new sheets by category of spare parts (CPU, RAM, Hard disk, VGA, casing, etc.)
Enter the Brand name and unit price of each spare part on the sheets you have created.
For example, on the sheet CPU, enter brands such as intel i3, intel i5, intel i7, AMD Ryzen, etc. then in the next column enter the unit price.
Go back to the first sheet created first, then change each cell in the Brand column to drop down by going to Data> Data Validation menu, then select List in Allow option, then select its data source (in sheet spare part desired), then click OK.
In the Unit Price field, enter the function INDEX and MATCH (Please watch the video in this article or in the article on the link if it is unclear).
The example of the INDEX and MATCH functions is like this: = INDEX (Case A2: B5; MATCH ([@Merk]; Casing! A2: A5; 0); 2)
Well there is a little simple tutorial on how to set up or create a computer assembly budget that can be filled automatically using Microsoft Excel.
For the excel template you can download here:
Excel Template Computer Budget
Hopefully useful yes.