Xin chào
To create a summary of JNE shipping rates from Bandung to all over Indonesia, you can follow these steps:
Step 1: Gather Information
Collect the latest shipping rates from JNE for Bandung to all over Indonesia. This information can be obtained from the JNE official website or by contacting their customer service.
Step 2: Create a New Excel Worksheet
Open a new Excel worksheet and name it "JNE Shipping Rates".
Step 3: Set Up the Table
In the first row of the worksheet, create headers for "Destination", "Weight (kg)", "JNE Service Type", "Shipping Cost (IDR)".
Step 4: Fill in the Information
In the "Destination" column, list all the cities or regions in Indonesia where JNE provides shipping services. In the "Weight (kg)" column, enter the weight range for which the shipping rates apply. In the "JNE Service Type" column, list all the available services offered by JNE such as regular, express, overnight, etc. In the "Shipping Cost (IDR)" column, enter the corresponding shipping rates for each service and weight range combination.
Step 5: Calculate Total Cost
In the last row of the "Shipping Cost (IDR)" column, use the SUM function to calculate the total cost of shipping for each destination. This will give you the total cost for all weight ranges and services.
Step 6: Format the Table
Format the table by adding borders, shading, and cell colors for better readability.
Step 7: Save the Worksheet
Save the worksheet with a name that is easy to remember such as "JNE Shipping Rates Bandung to Indonesia".
Step 8: Update the Worksheet Regularly
To keep the worksheet up-to-date, make sure to update the shipping rates regularly as JNE may change their rates from time to time.
By following these steps, you can create an Excel summary of JNE shipping rates from Bandung to all over Indonesia. This will make it easier for you to compare rates and choose the most suitable service for your needs.
Best regards,
Giáp Văn Hưng