How do you access data that are locked? Anonymous access doesn't work, the other authorization methods don't work as anticipated, and I'm not certain about the Web API key.

Still useful ! thx man

Thanks for teaching me excel! A real spoonful of sugar situation

Rally useful video thanks, now I've got to add a job tracker and sales profit sheet :)

Just curious are you still playing Eve and if you are I was wondering if you could help me with the concat list for ammo. is it possible to have all charges, missiles, crystals... ect all in one build sheet or should I create one sheet for each type of charge. Thank you in advance

Do you know how to do the same for SSO to give a player access to a website as his ingame character to also pull data from his char?

The flaw I see with this is that over time if you are adding more and more buy rows then your average price seems to be the combination of all the prices you have paid ever. That isn't a very realistic model for what the cost to build something today is. An improvement would be to have your formula pick up the average warehouse stock value of your mineral at the point in time you take it out, but then copy paste those averages as numbers to fix that price as the cost you incurred to make that item. Your warehouse then needs to calculate the total stock you have as the total received less the total used, and the total isk cost of that stock as the sum of cost prices less the sum of the value of the units used. Ideally you would actually have the average price for stock in your warehouse taken from the current market price, not what you happened to pay for it, potentially meaning your stock could go up or down in value while you are away. Then you would get a realistic cost of using that stock to make something vs just selling the stock back to the market for a profit. (Using the 100 trit you purchased for 100 isk to make something you can sell for 150 isk looks good, but if by the time you make it you could just sell the trit back to the market for 300 isk because its price has tripled, then the 150 doesn't look quite such a great use of your stock.)

How do you modify the me/pe and have the amounts adjust accordingly

I love the video. I have been digging deeper into excel this year and this video helped explained new functions. But even better it taught me for use in a pass time I love (video games) but gave me a skill I can use in my professional life (logistics management). Thanks

Fantastic, perfect inspiration. Perfect instruction. Multi buy copy and paste, EPIC!

can you do multibuy and type in the price for a buy order?

"Let's make a 'Warehouse' -Warhouse-, Not a Warhouse, actually, Yea " *Laugh hard. **Clicks - Like/Subscribe.

To be honest i dont know how the average industry guy makes money from industry. I understand how its done and i have looked into starting doing it but after checking prices and potential profits, in 90% of the time it always end up as a lose and same if u wanna get into ship production: Especially when dealing in ammo production. Do ppl think that just becouse u mined the minerals yourself its free? In pretty mutch all T1 ammo production the minerals cost more then the ammo is selling for so if u mined it yourself u would make more if u sold the minerals seperate over selling the ammo.

I really like it

Do you have a series for making these tools, all your twitch vods are gone :(

You’re INSANE! Subbed. 🤓

Wow, I never thought I'd be able to sit still and pay close attention for 50 minutes straight on a video about Excel, but here I am, lol. Also this basically just taught me how to use spreadsheets in general because I never knew before.

Теперь буквально Excel

1) pay account 2) do market research 3) build BP library 4) discover you'll never turn any non-meme tier profit unless you have 10 (at the very minimum) paid and trained accounts churning out stuff 24/7 5) quit industry and/or game there i just saved you lot a half hour

its 2022 and piecing this spreadsheet page by page is like unearthing the ten commandments piece by piece :)

Does anyone else get turned on when we get the opportunity to talk about PowerQuery.

This is an excellent guide. Thank you so much. I'm getting back into EVE and focusing on ship building and industry and this is so help me get organized. Thanks again. Fly safe.

Wtb indysheet like this

Do you still stream?

You are amazing bro! Super useful info as I'm a noob interested in industry (i like numbers). I'm not done setting everything up just yet, but I have my 3 BnB sheets, plus my warehouse(minus the shopping list) Edit: this is actually my first experience with spreadsheets, im using google sheets and the shortcuts as well as formulas are identical so i can follow along easily. to test my understanding of your teachings, at 31:06, I paused and did the recieved sumif on my own. thanks so much man.

LOVE IT 😍

Caspar David Friedrich.

Quick question how are you getting the estimated item value? I know what to do from there just not sure where exactly to get that.

Ive Been Looking Forward To This

appreciated ))

I appreciate this lesson.

Auto like as always

gosh darn it!! I'll have to give it another go - I just love your spreads!!!!!

Awesome video

I like industry, but am very poor at organizing. Do you have a discord or chat channel?

Thank you! Cool series, much inspiration! Now I understand how important goal setting is.

The audio literally sounds like you're on stage at a comedy show xD

Welcome to my ammar my boii

Eve seriously needs a graphical update , I mean nothing still can challenge the economy of EVE Online , except maybe some new stuff coming out that uses a completly different theme like fantasy theme. For some reason that is working for complex economy themes cause Eve just doesn't allow a competitor in sci fi it seems as i cannot even think of another game , and dont say star citizen or elite dangerous i play those games they dont have anything as near as complex or detailed as eve .

Great video, I have one question how would you suggest pricing materials which you have sourced yourself? I am trying to use this to organise my PI and work out which things I need to purchase in over and above my production capabilities. But I guess when I get to minerals and stuff the same will hold true as I rat and repo the loot and moon mine quite a bit as well. I was thinking I could use Jita buy price on the input side does that seem sensible?

These videos are great. I use Excel professionally and these are better than alot of expensive training I've received. I do have a question... I've noticed you tend to not make ranges "tables" (using the command on the insert tab) and instead used named ranges and absolute references in your formulas. I am in the habit of ALWAYS making things tables to make them easier to call out in formulas. Is this a style choice or am I limiting myself using the table option?

Basically how to get better at eve online , learn Windows Excel.

Nice video, but you have to consider the fact maybe it s just traders so they don t care about the reprocess stuff o7

Awesome tutorial, thanks for uploading!

Found you a couple weeks ago. I think your stream and videos are amazing. I have started working on industry and plan to start with components. I have basically been trying to reverse engineer your spreadsheet. I can pull the data from the bread and butter sheets into the componentmanufacture sheet, but I can't figure out how to adjust the values for different MEs. Anyway that you can point me in the right direction?

🙌 mupah us the sheet king

What skills effect this, I heard you say "scrap metal reprocessing", but I only see "reprocessing"

Just be careful with this. CCP has been known to make goofy choices and the tin hat in me is flirting with the idea that this is borderline botting.

From where is this data sourced?

Amazing work. If I were you I would make the script do extra crunching and order the modules by total profit, placing the best profits on top of the list.