Thank you David for your feedback. I appreciate your help.
I have one question left about distance. I actually ran your formula against an Excel file that I previously made for my imports, and I realized that the way I calculate distance is probably wrong; or the formula is not accurate.
Columns:
Distance: 2D distance calculated using the data in Cities.DBF (via this
online calculator)
The columns StdPrice, Freight Index were taken from Product_Types.DBF
The City-To-City Cost is the price displayed in the game's UI
The CapLab formula represents the column I used to run your formula, which seems to unrealistic compared to the game's numbers...
Also...
the formula as you said is:
freight cost = standard product price after applying inflation * freight index / 100 * distance
For Milk, the freight cost is $0.19 (City-To-City Cargo Ship)
=> Distance = Freight Cost / [ StdPrice * (Freight Index / 100) ] => Distance = $0.19 / [ 1 * ( 60 / 100) ] = 0.19 / 0.606 = 0.313 ?
On the other hand, when I calculate the distance between PAris and Seoul based on the data in Cities.DBF (I used the columns GLOBE_LOCX and GLOBE_LOCY of each city), the distance seems to be 167
I think I'm missing something HUGE here... Thank you again
EDIT:
I updated the values because I apparently used old DBT files. Now, I use the ones from MOD-kit.zip, but still, there seems to be something "mysterious"... Actually I came to the conclusion that there is a factor "missing" in the formula I guess. Because of all the calculations I made, when I compare what the formula gives with what the UI displays, there is a ~520 multiplier (represented by the last column in my screenshot).
In other words, the formula is :
freight cost = standard product price after applying inflation * freight index / 100 * distance / 520
I don't know where it comes from and what it means or represents but I'd like to have this clarified^^ Thank you