After-sales service assessment form

After-sales service assessment formIt is a variety of service activities provided after the sale of goods. Huajun Software Park provides high-quality Excel template downloads. The download format of the after-sales service assessment form is xlsx. You can get the source file after downloading, which can be edited, modified and replaced. Download the after-sales service assessment form Excel for free at Huajun Software Park.

Tips for using after-sales service assessment form

​​​After-sales service assessment formPreparation of:

​​ 1. Install and debug products on behalf of consumers;
​ 2. Provide technical guidance on usage and other aspects according to consumer requirements;
​​ 3. Ensure the supply of maintenance spare parts;
​​ 4. Responsible for maintenance services and provide regular maintenance and regular maintenance;
5. Provide consumers with regular telephone follow-up visits or door-to-door follow-up visits;
​​ 6. Implement "three guarantees" for products, namely repair, replacement and return;
7. Handle consumer letters, visits and telephone complaints, and answer consumer inquiries.

General tips for after-sales service assessment form

​ ​ 1. Find duplicate content formula: =IF(COUNTIF(A:A,A2)>1, "Duplicate", "").

​ ​ 2. Use the year and month of birth to calculate the age formula: =TRUNC((DAYS360(H6, "2009/8/30", FALSE))/360,0).

3. Calculation formula from the birth year and month of the entered 18-digit ID number:

=CONCATENATE(MID(E2,7,4),"/",MID(E2,11,2),"/",MID(E2,13,2)).

​​ 4. To let the system automatically extract the gender from the entered ID number, you can enter the following formula:

=IF(LEN(C2)=15, IF(MOD(MID(C2,15,1),2)+1."Male","Female), IF(MOD(MID(C2,17, 1),2 )=1,"Male","Female")) "C2" in the formula represents the cell where the ID number is entered.

Recommended by the editor of Huajun Software Park

The after-sales service assessment form is a very practical form, and most of the forms are for general purposes. If you happen to need to download the after-sales service assessment form Excel form, please download it quickly.List of Undergraduate Graduation Projects,Procurement scheduleIt is also a good form. Welcome to click to download and experience it!