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!
it works
it works
it works