Content: Slate Blackcurrant Watermelon Strawberry Orange Banana Apple Emerald Chocolate Marble
Background: Slate Blackcurrant Watermelon Strawberry Orange Banana Apple Emerald Chocolate Marble
Pattern: Blank Waves Notes Sharp Wood Rockface Leather Honey Vertical Triangles
Welcome to TerraFirmaCraft Forums

Register now to gain access to all of our features. Once registered and logged in, you will be able to contribute to this site by submitting your own content or replying to existing content. You'll be able to customize your profile, receive reputation points as a reward for submitting content, while also communicating with other members via your own private inbox, plus much more! This message will be removed once you have signed in.

  • Announcements

    • Dries007

      Server Move   09/13/18

      I (Dries007) have recently taken over as main developer and server admin. This involved moving servers to reduce cost. It's likely there will be some more downtime in the future but most  things should be sorted by now. This forum is in dire need of replacement as the software is quite old and can't be easily updated. If you wish to discuss or stay updated, join our discord: https://invite.gg/terrafirmacraft. The forum will remain available to read, but will be locked in the future, when a new system is setup. The forum and wiki are now ad free. If you'd like to contribute to keeping it that way, you can do so via paypal or patreon.
Bennneh

TFC (+Technofirmacraft) Alloy Smelting Calculation Helper [V1.2]

6 posts in this topic

Hi everyone,

 

I've created my own Google sheet alloy calculator/helper that I wanted to share with you all.

It was created for use between my group of friends whom I play Technofirmacraft with on a private server, and thought it could be useful for others.

 

*Quick note

I based my design off an older sheet made by vzertaman that he released back in September 2014 (forum post)

This is why the layout is similar and i used his colours too because they were great identifiers. The calculations and formula's are my own and the idea has been modified to my own liking, I have in no way directly ripped this off as the calculations he did are basic SUM, PRODUCT and DIVIDE

 

This sheet as a lot of linked cells for formula's, and updates with the changes you make

 

What is it?

It is a Google doc excel sheet made for a small group, but released for everyone to use.

The ingot calculator will help you discover how many units of each material you need, based on the ratios of required ore/metal. The ratio’s are defaulted to what I (on a whim) declared ideal, but can be changed on your own sheet by editing the values within the range.

 

The alloy calculator will help you work out how much of each ore piece you need to get to the ratio and amount of units you desire. This page can be altered using the “Game” drop-down box (default to TFC) which is automatically alter the values per ore for the respective game/mod selected. (currently only “vanilla” TFC and Technofirmacraft)

 

How do I use it?

Access the sheet here: https://docs.google.com/spreadsheets/d/18IKPCwMfqP2_Bxe06ygK057YAFLgBcWOdpOHZeN2TAU/edit?usp=sharing

1: Go to file, and select “make a copy.” This will make a copy of the sheet on your own Google drive for you to use, this version is read only so that everyone can take the same version I've uploaded, and nothing can be changed.

2: Access the sheet from your own Google drive (wherever it saved to, usually default root folder)

 

Ingot Calculator

You can only edit the green boxes on this page

1: Select the kind of metal you want to make, and how many ingots you want

2: Alter the ratio’s to your liking, depending on the resources you have available. I.e. If you want to make Rose Gold, but you want to use more gold than copper, alter the ratio’s on the right for Rose Gold to values within the required ranges (shown above them) and ensure they equal 100%

3: The values below the metal selection will update and tell you the total units created, and the required number of units per metal for the alloy you are creating.

 

Alloy Calculator

You can only edit the game drop down window, and the quantities column in this sheet

1: Alter the numbers in the quantities column to choose how much of each material you want to use in your alloy.

2: The calculator will put together all the statistics you need, to show you the total units per metal, total units overall, each metal’s ratio and how many ingots/remaining units left over

3: The “Alloys” grid on the right will give you real time updates to show you when you are within or not within the ranges you need for an alloy. The “In Vessel” rows will go green when your ratio matches the required levels. When all metals are within the required ranges, and they all turn green, the red/pink bar to the left of the alloy will also become green. This indicates to you that your alloy is correct, and this is the product you will receive.

4: The reset button at the top requires you to be signed into Google to use, this runs a basic script to reset all values in the “Quantity” column back to 0

 

Using these helpers, you can calculate what you need before you do it in game, meaning less wastage of materials, less wasted time and more time on the forge. You can go from looking up the units you need for a certain amount of ingots, to working out what exactly you need to melt to get your result.

 

 

Version History

V1.0 – Basic alloy calculator to show ratio’s on the left, inspired by vzertaman

Added visual helper for alloy ratio’s on the right

Scripted Reset button to clear quantities quickly

Added “How to use” on the sheet for quick overview

 

 

V1.1 – Added ingot calculator sheet for early steps for new players, on request of a friend who hadn't touched metal forming and wanted an extra step of help

Added “How to use” on the sheet for quick overview

 

 

V1.2 (24/01/16)– Added “Mod ore values” sheet, input ore values for TFC and Technofirmacraft

Added “Game:” option on alloy calculator

Re-functioned alloy calculator so units update with game selected

Re-functioned ore list so the titles also update values with game selected

 

Bug History:

None so far, first major release no bugs known

 

Rights to use:

This sheet can be used by anyone, anywhere in any space time dimension

You may use this in videos and/or streams

You may redistribute this to others

All I ask is you don’t take credit for making it, as I haven’t taken credit for the original design

 

Disclaimer:

I  am by no means in any way trained in using an excel sheet to this degree, this is the largest and most complicated sheet I have made in excel and there may be ways to improve the formulae and functionality, I created this to the best of my ability and it functions well when tested by me and 4 others. If you do have suggestions to improve the sheet, I am more than willing to look into it. The sheet may not be perfect, ore values may change or be incorrect, but during testing no incorrect values were found.

 

 

I am open to suggestions regarding changes, improvements and any other thoughts you have.

Please leave these notes in this thread for me so I can see them, I will respond and update this post as I go, any new versions of the sheet will require you to make a new copy to receive the up to date features.

0

Share this post


Link to post
Share on other sites

What I'd like to see in one of these calculators is the ability to put in a quantity of desired ingots of black, red, or blue steel, and then an output which tells me the quantities of all the *base* metals I'll need.  So not the alloys that go into the colored steels, but the base metals that go into the alloys that go into the steels.  I want to be able to say 'ok, how much copper, iron, nickel, silver, etc do I need for 14 blue steel ingots to make the anvil?  Then I can look at my stock of base metals and figure out where I need to fill in the gaps, and then spend a nice long session of smelting and smithing with the end result being a quantity of blue steel meeting or exceeding my goal.  Or, look at a cube of 64 copper ingots, and be able to figure out simply how many blue steel ingots I can get out of that.   I'd really love to see that kind of calculation.

2

Share this post


Link to post
Share on other sites

What I'd like to see in one of these calculators is the ability to put in a quantity of desired ingots of black, red, or blue steel, and then an output which tells me the quantities of all the *base* metals I'll need.  So not the alloys that go into the colored steels, but the base metals that go into the alloys that go into the steels.  I want to be able to say 'ok, how much copper, iron, nickel, silver, etc do I need for 14 blue steel ingots to make the anvil?  Then I can look at my stock of base metals and figure out where I need to fill in the gaps, and then spend a nice long session of smelting and smithing with the end result being a quantity of blue steel meeting or exceeding my goal.  Or, look at a cube of 64 copper ingots, and be able to figure out simply how many blue steel ingots I can get out of that.   I'd really love to see that kind of calculation.

 

That actually wouldnt be that hard, ive already got the calculator for ingots so i guess all i need to do is just drill it down, i've just reformatted my PC so once its all up and running again ill take a look and post an update for you :)

0

Share this post


Link to post
Share on other sites

The main problem with this would, of course, be the "between x% and y% of copper" bit for the alloys.
This would possibly mean that for your 100 ingots of blue steel you need between (for example) 20 and 50 ingots of copper, 10 to 30 ingots of tin etc... 
The problem then, of course, would be how much of that copper has been calculated in the bronze and how much into the brass, or sterling silver...

0

Share this post


Link to post
Share on other sites

His calculator allows you to specify the percentages of each alloy, so the user can control what percentages are being used for each.  I actually have my own spreadsheet similar to this for figuring out what 1 ingot of each colored steel costs.  But I've always wondered if I'm doing the root alloy calculations right.  For instance, I came up with one ingot of blue steel costing, in the end, 265 iron, 39.25 copper, 22.5 nickel, 9.75 silver, 7.5 gold, 3 bismuth, and 3 zinc (at my own preferred percentages of course - 50% BS, 15%BB, 25%Steel, and 10%SS, and the sub-alloys having their own of course).  350 total units go into that one ingot of blue steel - which confused me at first, as I expected 300, but it's that vanishing pig iron you weld onto the black steel that does it, in the weak blue steel stage which I have at 50% BS, which means you're having 1.5 pig irons vanish, not just 1 for the weld-on BS I was considering off the top of my head.  I made this after mining a ton of nickel, and wondering how long it would last me.  Discovered I should have spent a lot less time on the nickel and silver, and a LOT more time on the iron.  I calculated the bare minimum iron possible is 245 units, for 1 ingot of either red or blue, but you use more silver and nickel doing that.  I was basically maxing out the alloys not involving iron, nickel, or silver, and then decided to prioritize saving the rares, since the 20 point iron swing, in the scope of 350 total units, is kind of minor.

Edited by Darmo
0

Share this post


Link to post
Share on other sites

this does rather show how ridiculously expensive the coloured steeels are, doesn't it :)

0

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now