Hi. I’m looking for a spreadsheet formula that can calculate the price per JIN 斤 and price per gram.
I’d like a simple spreadsheet that would let me enter 2斤, the known price of my material is fifteen Taiwan dollars per Jin. I’d like it to automatically tell me the price per pound and its total.
would like a multi-column spreadsheet that would let me change the amount of grams or Jin needed. Then the price and volume would the jin or grams would adjust itself and give me the total cost for both units.
Well, a jin is 600 grams. A pound is 454 grams. One pound is 454/600 jin. known price per jin * 454/600 = price per pound. Pretty simple. Do you know how to use a spreadsheet at all?
5 Likes
I didn’t know a jin was 600g. I just knew it was different from a pound and smaller than a kilo.
1 Like
So was that of any help to you @The_Seeker?
That’s how they get you if you don’t ask Táijīn or Gōngjīn.
1 Like
Taiwan 斤 is 600g. Chinese 斤 is 500g. ISO 斤 (公斤) is 1000g.
6 Likes
I misspoke. Though it would be nice to find the amount per pound I’m really interested in the price per gram, sorry.
I’m not much of a genius at math, but I understand how spread sheets work.
I’d like to be able to enter in the number of gin I require because my market uses that.
Then, I’d like the equivalent about in Graham’s appear on the screen along with the cost per gram which will be set of course
Well then, weight in jin * 600 = weight in grams. price per jin * 1/600 = price per gram. 1 jin = 600g
2 Likes
Not possible! 
1 Like
Voice typing with no glasses on the fly. Graham Crackers are not standardized so I guess that would be impossible.
An other measurement I want to add is one primarily used for a rice.
I think it’s called The Dou. I’m looking for Its metric equivalent. It doesn’t seem to appear in the Taiwan Weights and measures article of Wikipedia.
Looking around Chinese answer sites, it seems the “dou” is actually a unit of volume and not weight, but for rice works out to approximately 7 kilograms. There might be some minor variations in different locations. 1 dou = 10 “sheng”
Here is a simple spreadsheet with formulas:
You will need an event macro to achieve that. Here is an example:
1 Like
Here are some tables regarding conversion between Dou and kilograns stolen from the wall of my local rice depot.
They sell a wide variety of rice and grains, since the Dou is a measure of volume rather than weight you’d expect the same volume of different grains to have different weights.
Perhaps Dou no longer refers to volume and is now an official Taiwanese measurement of weight for rice.
the first chart is a little curious. I think it has to do with the price. but I’ve been a bad boy and left the house without my glasses and know that when I return home I will not have time to post further until later.
