Aaron

Monolith Addict
Member
Joined:
Jul 15, 2017
Messages:
777
Points:
87
Awards
2

7

Years of Mono

LV
1
 
Ultimate Gun Crafting Spreadsheet

After some debate I've decided to publicly release my spreadsheet. My schedule has become too busy to run a business on Monolith, and when I'm on I'll be taking tickets/on duty. This is my gift to all those who want to run a successful gun crafting business. This spreadsheet will likely remain updated for all gun crafting recipes in the future, as @Mark regularly uses it to balance recipes.

There are controls at the bottom that will allow you to configure several facets of your business. They are very simple to use and have been made as simple as possible for your use. The cost and profit sheet will be your main screen, and the controls will allow you to fully understand where your costs are, and where you should focus to maximize your profits for up to 8 hours of grinding. Please note: Much of this pricing is based off of an ore chunk PURCHASE model. This means you do not mine your own ore, but purchase the chunks from miners. These prices can be found on the ore/weapon pricing sheet where Price Per Stack will dictate how much you should pay for a stack of 16 of that specific ore. If you stick to that purchase model, your profit margins should be relatively accurate when you include rent costs. (Ignore stated stack size on that sheet. It factors in how a stack of 16 will convert to 64 of refined ore)

https://docs.google.com/spreadsheets/d/19h3S48QP9Ql0dSymmliDW90B8GZ4yKFtwtaoaeS_6MQ/edit?usp=sharing

Control Guide
Bar Smelt Cost: This is a feature that allows you to factor in the cost of paying another player to do only the smelting for you on a factory. Default: Off

Rent Cost Toggle: This feature allows you to factor your rent cost into your profit margins. Default: $2,500

Gun Price Multiplier: This will allow you to compensate for a loss in margin if you're paying someone to smelt, or if rent goes up. In general, you want to keep your profit margins at 75% for gun crafting to be relatively competitive with other methods of earning money. Default: 1

Discount Amount (%): If you are making an order for a customer who wants a discount, this is where you will input that discount. Default: None

Shipment Size: Self explanatory. You can make the spreadsheet show you requirements for a larger shipment of weapons. Default: 1

Crushers In Operation: If you have multiple crushers running, this will modify based on that metric. Default: 1

Factories In Operation: If you have multiple factories running, this will modify based on that metric. Default: 1


------

If you have questions or comments, feel free to contact me here on this thread, on Steam, or on Discord.​
 

DangerZone640

Monolith Addict
Member
Joined:
Feb 2, 2018
Messages:
830
Points:
117

6

Years of Mono

LV
0
 
This is one damn clean spreadsheet if I've ever seen one
 

Gregg

Monolith Legend
Member
Joined:
Aug 11, 2017
Messages:
2,521
Points:
157

7

Years of Mono

LV
0
 
Thank you for the information.

Pinned.
 

hunter0o9

Monolith Newcomer
Member
Joined:
Jan 26, 2020
Messages:
1
Points:
10

4

Years of Mono

LV
0
 
Ultimate Gun Crafting Spreadsheet

After some debate I've decided to publicly release my spreadsheet. My schedule has become too busy to run a business on Monolith, and when I'm on I'll be taking tickets/on duty. This is my gift to all those who want to run a successful gun crafting business. This spreadsheet will likely remain updated for all gun crafting recipes in the future, as @Mark regularly uses it to balance recipes.

There are controls at the bottom that will allow you to configure several facets of your business. They are very simple to use and have been made as simple as possible for your use. The cost and profit sheet will be your main screen, and the controls will allow you to fully understand where your costs are, and where you should focus to maximize your profits for up to 8 hours of grinding. Please note: Much of this pricing is based off of an ore chunk PURCHASE model. This means you do not mine your own ore, but purchase the chunks from miners. These prices can be found on the ore/weapon pricing sheet where Price Per Stack will dictate how much you should pay for a stack of 16 of that specific ore. If you stick to that purchase model, your profit margins should be relatively accurate when you include rent costs. (Ignore stated stack size on that sheet. It factors in how a stack of 16 will convert to 64 of refined ore)

https://docs.google.com/spreadsheets/d/19h3S48QP9Ql0dSymmliDW90B8GZ4yKFtwtaoaeS_6MQ/edit?usp=sharing

Control Guide
Bar Smelt Cost: This is a feature that allows you to factor in the cost of paying another player to do only the smelting for you on a factory. Default: Off

Rent Cost Toggle: This feature allows you to factor your rent cost into your profit margins. Default: $2,500

Gun Price Multiplier: This will allow you to compensate for a loss in margin if you're paying someone to smelt, or if rent goes up. In general, you want to keep your profit margins at 75% for gun crafting to be relatively competitive with other methods of earning money. Default: 1

Discount Amount (%): If you are making an order for a customer who wants a discount, this is where you will input that discount. Default: None

Shipment Size: Self explanatory. You can make the spreadsheet show you requirements for a larger shipment of weapons. Default: 1

Crushers In Operation: If you have multiple crushers running, this will modify based on that metric. Default: 1

Factories In Operation: If you have multiple factories running, this will modify based on that metric. Default: 1


------

If you have questions or comments, feel free to contact me here on this thread, on Steam, or on Discord.​
where can i get the forms to guides for crafting guns ? i still have no clue what to do
 
Top