Assemble a computer or iPhone, need to make a detailed list? PHP editor Baicao brings you a solution, detailing the methods and techniques for assembling computer quotations and iPhone lists. In this article, you'll learn how to organize your inventory efficiently, ensure you source all necessary components, and avoid missing any important items.
Take a high-configuration computer worth 8,000 yuan as an example:
Accessory name, brand, model, reference price (yuan)
Processor: Intel Xeon E3-1230v3 (bulk) 1,299 yuan
Radiator: Kyushu Fengshen Dashang Tower 160 yuan
Motherboard: ASUS H97 Pro Gamer 899 yuan
Memory: Corsair Avengers 8GB game memory 549 yuan
Graphics card: Colorful iGAME 970 Flame God of War U 2499 yuan
Mechanical hard drive: Seagate 1TB SATA3.0 7200 rpm 389 yuan
Apple mobile phone assembly accessories require: motherboard, camera, battery, cable, screen, casing, home key, power button, button gasket: 2X4 pieces, cable protection cover, brushed aluminum alloy back cover, Card cutter, capdase screen, high imitation bumper + dustproof plug + front and rear high-transparency film, Apple mobile phone assembly is mixed according to different proportions, it is not very wise to assemble it by yourself at the moment,
Generally includes the following accessories: casing, picture tube, deflection coil, high-voltage package, tuner, microprocessor, intermediate frequency processing integrated block, input signal selection switching integrated block, line and field scanning and color decoding Small signal processing blocks, sound power amplifier integrated blocks, speakers, switching power supplies, line tubes, field output integrated blocks, video amplifier tubes, various high and low frequency small power tubes, various electrolytic capacitors, various dielectric capacitors, various Resistors with different power values, various input and output interfaces, etc.
Assembling a computer does require a checklist, because when we assemble the computer, after determining the configuration and operation requirements of the computer, we can purchase some suitable motherboards online, and then determine the power supply, graphics card and other configurations based on the motherboard. If you ask, just make a list and ask the computer factory or dealer to buy directly.
If you want to make a computer quotation form template, you can follow the steps below:
1. Open Excel and create a new workbook.
2. In the first worksheet, add a header. You can give each column a title, such as product name, brand, model, CPU model, memory, hard disk, price, etc. Make sure the header is clear and easy to read.
3. Add data to the table. According to the column headings in the table header, fill in the corresponding data, such as: computer brand, model, CPU model, memory, hard disk capacity and price, etc.
4. Format the table. You can use the "Format" button on the Excel toolbar to format the table, such as changing the font and size, modifying the cell color, etc., to make it more beautiful and easier to read.
5. Add filters. You can use the "Data" button on the Excel toolbar and select "Filter" to turn on the filtering function, allowing users to filter the information they need according to their needs.
6. Set conditional formatting. Conditional formatting can be added to make the computer quotation form more intuitive and readable. For example, add conditional formatting to the price column. When the price is lower than a certain value, the cell turns green; when the price is higher than a certain value, the cell turns red, etc.
7. Save the file. After completing the table, save it in Excel file format. If desired, it can be saved in other file formats such as PDF or CSV.
The above is the detailed content of Quote for assembling a computer? iPhone assembly checklist?. For more information, please follow other related articles on the PHP Chinese website!
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
