Пікірлер
@denesch
@denesch 4 ай бұрын
u mind share google docs?
@andtechie5210
@andtechie5210 4 ай бұрын
Unfortunately this spreadsheet is long gone. If you to join the discord I’d be glad to chat with you and help!
@denesch
@denesch 4 ай бұрын
@@andtechie5210 please share DS with me as that under video doesnt work
@andtechie5210
@andtechie5210 4 ай бұрын
@@denesch discord.gg/tkJxmGVE
@paulharris6977
@paulharris6977 4 ай бұрын
@@andtechie5210 discord link expired, could you send me one please? :)
@andtechie5210
@andtechie5210 4 ай бұрын
discord.gg/4YxnEmY9
@mgvikings1484
@mgvikings1484 4 ай бұрын
I think i am late to the party^^ but did i miss part 3, i cannot find it. most follow up videos came out 3 years later....
@andtechie5210
@andtechie5210 4 ай бұрын
Hey 👋🏼, I’m glad you’re excited for part three. I hope these have somewhat helpful. Part three will not be coming out any time soon. 🥲. But feel free to join the discord we can chat further and I’d be glad to help
@MysticalDragon73
@MysticalDragon73 8 ай бұрын
1:44 You mean BLOCKADE runner NOT DST. You can cloak a dst yes. but you cannot warp cloaked.
@andtechie5210
@andtechie5210 8 ай бұрын
Yes.
@timtomlins1548
@timtomlins1548 9 ай бұрын
This is pretty much exactly how I have been doing it. Nice to have confirmation I'm not missing anything or over complicating something.
@andtechie5210
@andtechie5210 9 ай бұрын
I’m sure there are fancier ways but this is how I usually do it. And I just build up my library of things I know are decent.
@shantvincent782
@shantvincent782 10 ай бұрын
You could probably teach excel classes on the side... thanks for the content.
@andtechie5210
@andtechie5210 10 ай бұрын
I’m glad these are still inspiring people! 🎉
@jogaleidm3858
@jogaleidm3858 Жыл бұрын
So... where can I find this Spreadsheet?
@andtechie5210
@andtechie5210 Жыл бұрын
It’s currently a work in progress. You wouldn’t want it as it is right now trust me. But we do have a community of people that could help you make one or improve on yours.
@Quickbookish
@Quickbookish Жыл бұрын
Saw your back to producing, the eve reaction videos are great! Thanks again
@andtechie5210
@andtechie5210 Жыл бұрын
More to come!
@GDPanda69
@GDPanda69 Жыл бұрын
Glad to see you're back and what a choice to come back with!!!
@andtechie5210
@andtechie5210 Жыл бұрын
Thanks! Appreciate you sticking around.
@MrJackTowers
@MrJackTowers Жыл бұрын
Bro woke up and decided to make a banging factorio video
@andtechie5210
@andtechie5210 Жыл бұрын
Hope you enjoyed it!
@frechesferkel2749
@frechesferkel2749 Жыл бұрын
Industry for new player is total dead. Nearly all blueprints have higher build costs than the endproduct sells and that with a large difference.
@andtechie5210
@andtechie5210 Жыл бұрын
Yes it’s very hard to get into as more experienced players have invested into all the structures and bonuses to produce things cheaply. But with a good eye it’s possible to find things!
@joeevan6265
@joeevan6265 Жыл бұрын
Shit video
@andtechie5210
@andtechie5210 Жыл бұрын
@14:30 start
@dadillegaming1563
@dadillegaming1563 Жыл бұрын
Thnx man, you saved me a lot of headaches. Lol I would like to see the pricing part though but I think i can figure it out from here
@andtechie5210
@andtechie5210 Жыл бұрын
Glad it helped!!!
@andtechie5210
@andtechie5210 Жыл бұрын
Start @7:50
@zaron8614
@zaron8614 2 жыл бұрын
I have done my own sheet but I will like to know what colors are you using on your sheet 😅
@kliderskope3662
@kliderskope3662 2 жыл бұрын
WOW…… So I just moved to null and want to begin doing reactions as a complete newb to sell the refined moon products in Jita. I have a particular ice field close by and several available moons. I thought (in terms of PI, I would refine down to convenient transportable size with a reasonable resale value.) I began your guide series and this video and as it started I thought OMG what’s going on how complicated is this! But buy the end of this video I honestly felt, with your Excel explanations, that I can actually do this. So thanks 🙏 One question though, is this still relevant in today’s game? As a returning player I know there has been a lot of changes to mining all round.
@andtechie5210
@andtechie5210 2 жыл бұрын
That’s awesome!! Find our discord link in the latest stream, tons of help in our discord! This is definitely still relevant! Even though moons have changed resources or whatnot. The ingredients for the components are the same!
@kliderskope3662
@kliderskope3662 2 жыл бұрын
@@andtechie5210 thank. I will check the discord.
@christianreyes7931
@christianreyes7931 2 жыл бұрын
This method doesn't work anymore. Theres no way to split columbs to separate buy and sell.
@andtechie5210
@andtechie5210 2 жыл бұрын
It still works !
@NerdishNature
@NerdishNature 2 жыл бұрын
ive never really done industry in eve in nearly 19 years but now that i see your neat spreadsheet, i'm interested :D
@andtechie5210
@andtechie5210 2 жыл бұрын
Join the discord! We’ve got good people
@zaron8614
@zaron8614 2 жыл бұрын
Are the prices update automatic? Or i have to do the page query every time?
@andtechie5210
@andtechie5210 2 жыл бұрын
Do search every time, but the process of splitting things is already done you just need the new url
@Thunder_Yoda
@Thunder_Yoda 2 жыл бұрын
Awesome, thanks.
@nomad_nz8179
@nomad_nz8179 2 жыл бұрын
Very nice tutorial man.. I wasnt looking to do reactions due to the sheer amount of items/values you need but after watching your vid I'm excited to try it out :). Thank you
@m1k3y48
@m1k3y48 2 жыл бұрын
Thanks for this, not only was it the top search result, but it worked first try. Much appreciated!
@andtechie5210
@andtechie5210 2 жыл бұрын
Glad to hear!!!!
@FawinkGaming
@FawinkGaming 2 жыл бұрын
followed this to see if I can pull it off to build myself a T2 ship from scratch
@andtechie5210
@andtechie5210 2 жыл бұрын
Did it work?
@FawinkGaming
@FawinkGaming 2 жыл бұрын
@@andtechie5210 It did, I managed to get it done :), thx
@tr33br06
@tr33br06 2 жыл бұрын
Lol, you are a mind reader. I came to nerd out with stats to improve my own!
@sethikablip8607
@sethikablip8607 2 жыл бұрын
this is the reason why this game should be called spreadsheet online
@andtechie5210
@andtechie5210 2 жыл бұрын
It’s pure bliss
@typhon1861
@typhon1861 3 жыл бұрын
I followed your steps but I keep getting an authorization error. It takes to a screen to log into my eve account, i select my character and then pressing "authorize" just gives me an error :/
@andtechie5210
@andtechie5210 3 жыл бұрын
Hmm idk join our discord! We’ve got some people that may be able to help
@LokleyTheo
@LokleyTheo 3 жыл бұрын
Can't say you're doing it optimal, but it does explain the idea well! Thank you)
@andtechie5210
@andtechie5210 3 жыл бұрын
This was my first rendition for tackling reactions. I’m glad it was of some use my current setup works much better!
@Brazabrad
@Brazabrad 3 жыл бұрын
I'm using google sheets, I can't seem to just copy and paste the sumif like you can. And suggestions?
@andtechie5210
@andtechie5210 3 жыл бұрын
I would go back and try to make sure I understand the formula. Boa Sorte
@woollygoat8921
@woollygoat8921 3 жыл бұрын
Am I the only one who needs an Excel tutorial to follow along?
@andtechie5210
@andtechie5210 3 жыл бұрын
Probably not, I have to do some double takes to understand it sometimes.
@butter1649
@butter1649 3 жыл бұрын
Hey, is it possible from the large item list that you have there try to filter items like t2, factions or BP in the excel?
@andtechie5210
@andtechie5210 3 жыл бұрын
Join the discord I have a mega list of every bp in the game with their materials and qty, based off the SDE from fuzzworks
@NebakinezaOG
@NebakinezaOG 3 жыл бұрын
Learn to use EVE Isk Per Hour. It will save you hundreds of hours of your time
@andtechie5210
@andtechie5210 3 жыл бұрын
I enjoy the journey as much as the destination.
@Abezy712
@Abezy712 3 жыл бұрын
Love eve and all the aspects but damm my brain is hurting between hauling market abyssal lol
@andtechie5210
@andtechie5210 3 жыл бұрын
Oh you’re doing all 3?
@Abezy712
@Abezy712 3 жыл бұрын
@@andtechie5210 yup thats the problem. Got toons for all types of stuff but still seem to be spending more isk then making or braking even... 😕 still love the game tho
@andtechie5210
@andtechie5210 3 жыл бұрын
@@Abezy712 probably good to master one thing at a time
@Abezy712
@Abezy712 3 жыл бұрын
@@andtechie5210 Your right. Sad part everytime I see a video i want to try that but will focus on abyssal and small scale manufacturing. Then plex with that income. Thanks again for your videos
@andtechie5210
@andtechie5210 3 жыл бұрын
@@Abezy712 👍🏼 see you around!!!
@stevo6572
@stevo6572 3 жыл бұрын
very confusing video...U give no reasoning for anything U did...I will figure it out on my own
@andtechie5210
@andtechie5210 3 жыл бұрын
Hi 👋 sorry this one was a confusing one. I hope that it at least did something for you. Have a good day!
@RogerChessell
@RogerChessell 3 жыл бұрын
This a great insight into your processes and helps me a lot. I am building my own spreadsheet and i have got stuck a couple of times on how todo something. You have unblocked my thoughts and i thank you very much. I am a member of your discord and look forward to more useful insights when i wake up in the UK
@andtechie5210
@andtechie5210 3 жыл бұрын
See you around !
@isthisnew1627
@isthisnew1627 3 жыл бұрын
very helpful, thank you for this, my esi keeps braking in my sheets, this seems to keep working. ty sir
@andtechie5210
@andtechie5210 3 жыл бұрын
Awesome! Glad to know that.
@stevo6572
@stevo6572 3 жыл бұрын
Yawns...just another useless video
@andtechie5210
@andtechie5210 3 жыл бұрын
Sorry that it didn’t do anything for you. It’s a simple way of pulling prices for people. Hopefully you’ll find what you’re looking for.
@IanVaughanMe
@IanVaughanMe 3 жыл бұрын
Great video, many thanks! Only feedback would be to zoom in a lot as its hard to see.
@IanVaughanMe
@IanVaughanMe 3 жыл бұрын
Can you share the sheet you have created?
@pablosanhueza1454
@pablosanhueza1454 3 жыл бұрын
Amazing, thanks you
@bveenhuizen7876
@bveenhuizen7876 3 жыл бұрын
Hi,is there a way to avoid that the items change positions once you have added an item to the list? Exampl Item A is at position 134 but after adding a item it is at 135.So wen i wanna use the attached pice at that position in other sheets i get a wrong price
@andtechie5210
@andtechie5210 3 жыл бұрын
I think what would solve your problem is a vlookup, that formula will find what you need and bring the price back.
@crynfish5605
@crynfish5605 3 жыл бұрын
Add-on is gone, but look here: github.com/evepraisal/evepraisal-google-sheets
@IanVaughanMe
@IanVaughanMe 3 жыл бұрын
but it looks like it doesnt support lookup by name now, only by ID
@IanVaughanMe
@IanVaughanMe 3 жыл бұрын
ah, I missed the extra brackets!! all good now cheers
@jamesshields5302
@jamesshields5302 3 жыл бұрын
Would ?live=true solve the issue of needing new urls each time? not sure how that would work if you need ?full=true.
@andtechie5210
@andtechie5210 3 жыл бұрын
The ?Full=true removes the limit of how many prices you get back. With that the site will only return a limited amount of items. I haven’t found that the live?=true gave back updated prices let me knowing it does! But then it would return only a limited amount lines. This is obviously a very over simplified way of pulling live prices without having to go through the api it itself! Feel free to join the discord!
@zaron8614
@zaron8614 2 жыл бұрын
@@andtechie5210 can I have the discord link pls
@andtechie5210
@andtechie5210 2 жыл бұрын
@@zaron8614 discord.gg/5T8JeeFs
@Dyhrrr
@Dyhrrr 2 жыл бұрын
@@andtechie5210 me too pls, that one is expired :(
@andtechie5210
@andtechie5210 2 жыл бұрын
@@Dyhrrr discord.gg/qHFG2dWb
@thomasreed2427
@thomasreed2427 3 жыл бұрын
Thank God for python and openpyxl. I cannot imagine doing stuff manually like this, when a nice script does it automatically for all T2 items in a few minutes, while calculating profitability at current market prices.
@andtechie5210
@andtechie5210 3 жыл бұрын
Yes 👍🏼, this takes a bit of work. I really like my tracking system
@roelofversluis6680
@roelofversluis6680 3 жыл бұрын
Thank you for this. Not only did I see that reactions are not that hard to comprehend, I learned quite a few things of Excel as well. Hehe
@andtechie5210
@andtechie5210 3 жыл бұрын
I’m glad you enjoyed it!!