| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
AFTER ARRIVAL FROM 5TH DAYS TO START CHARGES
Please help me as below details
FRIST 5 DAYS FREE OF CHARGES, AFTER 5 DAYS WILL BE CHARGES AS BELOW: ALSO I NEED GOODS ARRIVED AFTER FIVE DAYS WILL BE TO START THE BELOW CALCULATION. (FOR EX: 1800.000 KGS / 3.000 CBM X 8 = 75.00 (MIN 75.00) 3000.000 KGS / 12.000 CBM X 8= 96.00 (MIN 75.00) 16000.000 KGS / 4.800 CBM X 8 =128.00 (MIN 75.00) (which is higher) 1 TO 5 DAYS 8 PER W/M 8.00 6 TO 10 DAYS 13 PER W/M 21.00 11 TO 15 DAYS 18 PER W/M 39.00 16 TO 20 DAYS 23 PER W/M 62.00 21 TO 25 DAYS 28 PER W/M 90.00 26 TO 30 DAYS 33 PER W/M 123.00 31 TO 35 DAYS 38 PER W/M 161.00 36 TO 40 DAYS 43 PER W/M 204.00 41 TO 45 DAYS 48 PER W/M 252.00 46 TO 50 DAYS 48 PER W/M 300.00 51 TO 55 DAYS 48 PER W/M 348.00 56 TO 60 DAYS 50 PER W/M 398.00 61 TO 65 DAYS 50 PER W/M 448.00 66 TO 70 DAYS 50 PER W/M 498.00 71 TO 75 DAYS 50 PER W/M 548.00 76 TO 80 DAYS 50 PER W/M 598.00 81 TO 85 DAYS 50 PER W/M 648.00 86 TO 90 DAYS 55 PER W/M 703.00 91 TO 95 DAYS 55 PER W/M 758.00 96 TO 100 DAYS 55 PER W/M 813.00 101 TO 105 DAYS 55 PER W/M 868.00 106 TO 110 DAYS 55 PER W/M 923.00 111 TO 115 DAYS 55 PER W/M 978.00 116 TO 120 DAYS 60 PER W/M 1038.00 121 TO 125 DAYS 60 PER W/M 1098.00 126 TO 130 DAYS 60 PER W/M 1158.00 131 TO 135 DAYS 60 PER W/M 1218.00 136 TO 140 DAYS 60 PER W/M 1278.00 141 TO 145 DAYS 60 PER W/M 1338.00 146 TO 150 DAYS 65 PER W/M 1403.00 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AFTER ARRIVAL FROM 5TH DAYS TO START CHARGES
More information is needed.
It seems that your samples translate to: 1800 kilograms x 3 cubic meters x 8 (don't know what this is) = 75. My math says: 1800/3*8=4800 How do the examples you posted relate to the table? I don't see the word "days" anywhere in your example. Your table doesn't define what "W", "M", or "W/M" are. I'm guessing that your table is indicating that values from 6 to 10 are charged 13 per each "W", with a minimum of 8. Is that correct? Can you give an example that clearly uses the table? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) wrote in message ups.com... Please help me as below details FRIST 5 DAYS FREE OF CHARGES, AFTER 5 DAYS WILL BE CHARGES AS BELOW: ALSO I NEED GOODS ARRIVED AFTER FIVE DAYS WILL BE TO START THE BELOW CALCULATION. (FOR EX: 1800.000 KGS / 3.000 CBM X 8 = 75.00 (MIN 75.00) 3000.000 KGS / 12.000 CBM X 8= 96.00 (MIN 75.00) 16000.000 KGS / 4.800 CBM X 8 =128.00 (MIN 75.00) (which is higher) 1 TO 5 DAYS 8 PER W/M 8.00 6 TO 10 DAYS 13 PER W/M 21.00 11 TO 15 DAYS 18 PER W/M 39.00 16 TO 20 DAYS 23 PER W/M 62.00 21 TO 25 DAYS 28 PER W/M 90.00 26 TO 30 DAYS 33 PER W/M 123.00 31 TO 35 DAYS 38 PER W/M 161.00 36 TO 40 DAYS 43 PER W/M 204.00 41 TO 45 DAYS 48 PER W/M 252.00 46 TO 50 DAYS 48 PER W/M 300.00 51 TO 55 DAYS 48 PER W/M 348.00 56 TO 60 DAYS 50 PER W/M 398.00 61 TO 65 DAYS 50 PER W/M 448.00 66 TO 70 DAYS 50 PER W/M 498.00 71 TO 75 DAYS 50 PER W/M 548.00 76 TO 80 DAYS 50 PER W/M 598.00 81 TO 85 DAYS 50 PER W/M 648.00 86 TO 90 DAYS 55 PER W/M 703.00 91 TO 95 DAYS 55 PER W/M 758.00 96 TO 100 DAYS 55 PER W/M 813.00 101 TO 105 DAYS 55 PER W/M 868.00 106 TO 110 DAYS 55 PER W/M 923.00 111 TO 115 DAYS 55 PER W/M 978.00 116 TO 120 DAYS 60 PER W/M 1038.00 121 TO 125 DAYS 60 PER W/M 1098.00 126 TO 130 DAYS 60 PER W/M 1158.00 131 TO 135 DAYS 60 PER W/M 1218.00 136 TO 140 DAYS 60 PER W/M 1278.00 141 TO 145 DAYS 60 PER W/M 1338.00 146 TO 150 DAYS 65 PER W/M 1403.00 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AFTER ARRIVAL FROM 5TH DAYS TO START CHARGES
Dear Ron,
i mean minimum amount is 75.00 1.000 cbm equal to 1000 kgs if weight is higher than cbm, will calculate wiehgt charges if cbm is higher tha weight, will calculate as cbm charges Thanks & Best Regards Anshad On Nov 7, 5:11 pm, "Ron Coderre" wrote: More information is needed. It seems that your samples translate to: 1800 kilograms x 3 cubic meters x 8 (don't know what this is) = 75. My math says: 1800/3*8=4800 How do the examples you posted relate to the table? I don't see the word "days" anywhere in your example. Your table doesn't define what "W", "M", or "W/M" are. I'm guessing that your table is indicating that values from 6 to 10 are charged 13 per each "W", with a minimum of 8. Is that correct? Can you give an example that clearly uses the table? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) wrote in message ups.com... Please help me as below details FRIST 5 DAYS FREE OF CHARGES, AFTER 5 DAYS WILL BE CHARGES AS BELOW: ALSO I NEED GOODS ARRIVED AFTER FIVE DAYS WILL BE TO START THE BELOW CALCULATION. (FOR EX: 1800.000 KGS / 3.000 CBM X 8 = 75.00 (MIN 75.00) 3000.000 KGS / 12.000 CBM X 8= 96.00 (MIN 75.00) 16000.000 KGS / 4.800 CBM X 8 =128.00 (MIN 75.00) (which is higher) 1 TO 5 DAYS 8 PER W/M 8.00 6 TO 10 DAYS 13 PER W/M 21.00 11 TO 15 DAYS 18 PER W/M 39.00 16 TO 20 DAYS 23 PER W/M 62.00 21 TO 25 DAYS 28 PER W/M 90.00 26 TO 30 DAYS 33 PER W/M 123.00 31 TO 35 DAYS 38 PER W/M 161.00 36 TO 40 DAYS 43 PER W/M 204.00 41 TO 45 DAYS 48 PER W/M 252.00 46 TO 50 DAYS 48 PER W/M 300.00 51 TO 55 DAYS 48 PER W/M 348.00 56 TO 60 DAYS 50 PER W/M 398.00 61 TO 65 DAYS 50 PER W/M 448.00 66 TO 70 DAYS 50 PER W/M 498.00 71 TO 75 DAYS 50 PER W/M 548.00 76 TO 80 DAYS 50 PER W/M 598.00 81 TO 85 DAYS 50 PER W/M 648.00 86 TO 90 DAYS 55 PER W/M 703.00 91 TO 95 DAYS 55 PER W/M 758.00 96 TO 100 DAYS 55 PER W/M 813.00 101 TO 105 DAYS 55 PER W/M 868.00 106 TO 110 DAYS 55 PER W/M 923.00 111 TO 115 DAYS 55 PER W/M 978.00 116 TO 120 DAYS 60 PER W/M 1038.00 121 TO 125 DAYS 60 PER W/M 1098.00 126 TO 130 DAYS 60 PER W/M 1158.00 131 TO 135 DAYS 60 PER W/M 1218.00 136 TO 140 DAYS 60 PER W/M 1278.00 141 TO 145 DAYS 60 PER W/M 1338.00 146 TO 150 DAYS 65 PER W/M 1403.00- Hide quoted text - - Show quoted text - |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AFTER ARRIVAL FROM 5TH DAYS TO START CHARGES
Perhaps your newsreader truncated the bottom of my post.
You didn't address these questions: How do the examples you posted relate to the table? I don't see the word "days" anywhere in your example. Your table doesn't define what "W", "M", or "W/M" are. I'm guessing that your table is indicating that values from 6 to 10 are charged 13 per each "W", with a minimum of 8. Is that correct? Can you give an example that clearly uses the table? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) wrote in message ups.com... Dear Ron, i mean minimum amount is 75.00 1.000 cbm equal to 1000 kgs if weight is higher than cbm, will calculate wiehgt charges if cbm is higher tha weight, will calculate as cbm charges Thanks & Best Regards Anshad On Nov 7, 5:11 pm, "Ron Coderre" wrote: More information is needed. It seems that your samples translate to: 1800 kilograms x 3 cubic meters x 8 (don't know what this is) = 75. My math says: 1800/3*8=4800 How do the examples you posted relate to the table? I don't see the word "days" anywhere in your example. Your table doesn't define what "W", "M", or "W/M" are. I'm guessing that your table is indicating that values from 6 to 10 are charged 13 per each "W", with a minimum of 8. Is that correct? Can you give an example that clearly uses the table? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) wrote in message ups.com... Please help me as below details FRIST 5 DAYS FREE OF CHARGES, AFTER 5 DAYS WILL BE CHARGES AS BELOW: ALSO I NEED GOODS ARRIVED AFTER FIVE DAYS WILL BE TO START THE BELOW CALCULATION. (FOR EX: 1800.000 KGS / 3.000 CBM X 8 = 75.00 (MIN 75.00) 3000.000 KGS / 12.000 CBM X 8= 96.00 (MIN 75.00) 16000.000 KGS / 4.800 CBM X 8 =128.00 (MIN 75.00) (which is higher) 1 TO 5 DAYS 8 PER W/M 8.00 6 TO 10 DAYS 13 PER W/M 21.00 11 TO 15 DAYS 18 PER W/M 39.00 16 TO 20 DAYS 23 PER W/M 62.00 21 TO 25 DAYS 28 PER W/M 90.00 26 TO 30 DAYS 33 PER W/M 123.00 31 TO 35 DAYS 38 PER W/M 161.00 36 TO 40 DAYS 43 PER W/M 204.00 41 TO 45 DAYS 48 PER W/M 252.00 46 TO 50 DAYS 48 PER W/M 300.00 51 TO 55 DAYS 48 PER W/M 348.00 56 TO 60 DAYS 50 PER W/M 398.00 61 TO 65 DAYS 50 PER W/M 448.00 66 TO 70 DAYS 50 PER W/M 498.00 71 TO 75 DAYS 50 PER W/M 548.00 76 TO 80 DAYS 50 PER W/M 598.00 81 TO 85 DAYS 50 PER W/M 648.00 86 TO 90 DAYS 55 PER W/M 703.00 91 TO 95 DAYS 55 PER W/M 758.00 96 TO 100 DAYS 55 PER W/M 813.00 101 TO 105 DAYS 55 PER W/M 868.00 106 TO 110 DAYS 55 PER W/M 923.00 111 TO 115 DAYS 55 PER W/M 978.00 116 TO 120 DAYS 60 PER W/M 1038.00 121 TO 125 DAYS 60 PER W/M 1098.00 126 TO 130 DAYS 60 PER W/M 1158.00 131 TO 135 DAYS 60 PER W/M 1218.00 136 TO 140 DAYS 60 PER W/M 1278.00 141 TO 145 DAYS 60 PER W/M 1338.00 146 TO 150 DAYS 65 PER W/M 1403.00- Hide quoted text - - Show quoted text - |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AFTER ARRIVAL FROM 5TH DAYS TO START CHARGES
yes you are correct
W/M is weight & measurment, if wight is high, will charge weight charges or measurment (CBM) is high, will charge CBM Regards Anshad On Nov 7, 5:51 pm, "Ron Coderre" wrote: Perhaps your newsreader truncated the bottom of my post. You didn't address these questions: How do the examples you posted relate to the table? I don't see the word "days" anywhere in your example. Your table doesn't define what "W", "M", or "W/M" are. I'm guessing that your table is indicating that values from 6 to 10 are charged 13 per each "W", with a minimum of 8. Is that correct? Can you give an example that clearly uses the table? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) wrote in message ups.com... Dear Ron, i mean minimum amount is 75.00 1.000 cbm equal to 1000 kgs if weight is higher than cbm, will calculate wiehgt charges if cbm is higher tha weight, will calculate as cbm charges Thanks & Best Regards Anshad On Nov 7, 5:11 pm, "Ron Coderre" wrote: More information is needed. It seems that your samples translate to: 1800 kilograms x 3 cubic meters x 8 (don't know what this is) = 75. My math says: 1800/3*8=4800 How do the examples you posted relate to the table? I don't see the word "days" anywhere in your example. Your table doesn't define what "W", "M", or "W/M" are. I'm guessing that your table is indicating that values from 6 to 10 are charged 13 per each "W", with a minimum of 8. Is that correct? Can you give an example that clearly uses the table? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) wrote in message roups.com... Please help me as below details FRIST 5 DAYS FREE OF CHARGES, AFTER 5 DAYS WILL BE CHARGES AS BELOW: ALSO I NEED GOODS ARRIVED AFTER FIVE DAYS WILL BE TO START THE BELOW CALCULATION. (FOR EX: 1800.000 KGS / 3.000 CBM X 8 = 75.00 (MIN 75.00) 3000.000 KGS / 12.000 CBM X 8= 96.00 (MIN 75.00) 16000.000 KGS / 4.800 CBM X 8 =128.00 (MIN 75.00) (which is higher) 1 TO 5 DAYS 8 PER W/M 8.00 6 TO 10 DAYS 13 PER W/M 21.00 11 TO 15 DAYS 18 PER W/M 39.00 16 TO 20 DAYS 23 PER W/M 62.00 21 TO 25 DAYS 28 PER W/M 90.00 26 TO 30 DAYS 33 PER W/M 123.00 31 TO 35 DAYS 38 PER W/M 161.00 36 TO 40 DAYS 43 PER W/M 204.00 41 TO 45 DAYS 48 PER W/M 252.00 46 TO 50 DAYS 48 PER W/M 300.00 51 TO 55 DAYS 48 PER W/M 348.00 56 TO 60 DAYS 50 PER W/M 398.00 61 TO 65 DAYS 50 PER W/M 448.00 66 TO 70 DAYS 50 PER W/M 498.00 71 TO 75 DAYS 50 PER W/M 548.00 76 TO 80 DAYS 50 PER W/M 598.00 81 TO 85 DAYS 50 PER W/M 648.00 86 TO 90 DAYS 55 PER W/M 703.00 91 TO 95 DAYS 55 PER W/M 758.00 96 TO 100 DAYS 55 PER W/M 813.00 101 TO 105 DAYS 55 PER W/M 868.00 106 TO 110 DAYS 55 PER W/M 923.00 111 TO 115 DAYS 55 PER W/M 978.00 116 TO 120 DAYS 60 PER W/M 1038.00 121 TO 125 DAYS 60 PER W/M 1098.00 126 TO 130 DAYS 60 PER W/M 1158.00 131 TO 135 DAYS 60 PER W/M 1218.00 136 TO 140 DAYS 60 PER W/M 1278.00 141 TO 145 DAYS 60 PER W/M 1338.00 146 TO 150 DAYS 65 PER W/M 1403.00- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| On time arrival | Excel Discussion (Misc queries) | |||
| On time arrival | Excel Discussion (Misc queries) | |||
| I want to count days between two dates including start date | Excel Worksheet Functions | |||
| HOW DO I SET UP A COUNTDOWN OF DAYS LEFT FROM START TO FINISH. | Setting up and Configuration of Excel | |||
| Display latest arrival date | Excel Discussion (Misc queries) | |||
Linear Mode
