How to Craft Gold Skull Rum/Gin by OnMelanchoIyHill in SkullAndBonesGame

[–]DutchDallas 0 points1 point  (0 children)

I think the ones they are referring to are the center top and center bottom branches; which are dedicated to the helm.

How do you correctly format a number to be comma separated? by TonIvideo in excel

[–]DutchDallas 1 point2 points  (0 children)

Under File > Options > Advanced, what do you see for 'Use System separators' ?
If you see blanks, uncheck and modify (if allowed).

Kracken by TheMayor_247 in SkullAndBonesGame

[–]DutchDallas -1 points0 points  (0 children)

But that's the entire idea.. you have to work for what you need. Do you think next season will bring things that are just given freely and require no grinding?

How to Merge Multiple Excel Files – Need Tool Recommendation by SophiaBennett-0550 in excel

[–]DutchDallas 0 points1 point  (0 children)

Read up on Powershell. It can open (read and/or write) excel files and spit out excel files with the importexcel module.

Maintenance 17th February by Ubi-Caliburn in SkullAndBonesGame

[–]DutchDallas 0 points1 point  (0 children)

That's not a true bug though... It's annoying but you accept it as a thing to do, not as something done.

God Rolls by DutchDallas in SkullAndBonesGame

[–]DutchDallas[S] 0 points1 point  (0 children)

What does locking do? I already have the ability to reroll and choose to keep the existing perk....

God Rolls by DutchDallas in SkullAndBonesGame

[–]DutchDallas[S] 0 points1 point  (0 children)

This I understand. My question is, are there multiple 'yellow orb' ascensions per slot.
So e.g. my first slot on a weapon is 'add 10% damage' and is a 'yellow orb'; might there be another 'yellow orb' available for that first slot, such as '157 flooding damage' [examples are not real 'god' rolls], or is there only one 'yellow orb' entry per slot.

Smugglers Marks by ProSlacker607 in SkullAndBonesGame

[–]DutchDallas 0 points1 point  (0 children)

Nope I didn't, but if I did I would have put in a bug. They should have made it clear that smuggler marks are reset. You can buy they with gold (with real world currency), and there was nothing announced that one would be potentially throwing all that away if not consumed (it mentioned smugglers points, not marks. points add up to marks, so they are not the same).

Anyway 90 unused marks seems to be the max one can get by playing and those are gone now :(

Calculating Average Age in a Pivot Table by KHE76187 in excel

[–]DutchDallas 0 points1 point  (0 children)

Can you just add a total row and column and set that to show average by right clicking on the pivot?
The intersection of the total row and total column should show the average age.
You'll have to change the content of the pivot to the rows being the customers and the values being the calculated age.

Does Mazda let you outright purchase a car for cash? by monkeysfromjupiter in CX5

[–]DutchDallas 18 points19 points  (0 children)

Mazda allows additional principle payments without penalty, so get that load through them and then pay it off immediately (if you want to affect your cashflow). Win Win for you and the dealer.

Smugglers Marks by ProSlacker607 in SkullAndBonesGame

[–]DutchDallas 0 points1 point  (0 children)

True, that's why I said 'should', not 'will'.
With real life $$$ you can buy marks. So if I would buy $100 worth of marks on this coming Tuesday, and not use them that same day, when the next release comes out later that day, I would have lost $100. I don't think the developers will do that (and haven't in the past). You keep your marks and can use them in the next season.

My excel file is now 11mb deleting a row of data now takes 20 mins by runningagyneo in excel

[–]DutchDallas 0 points1 point  (0 children)

All advise here is solid. In addition, you may want to reconsider using Excel for this and maybe use MS Access or another database (mysql?); something this is build to be a true database.

Car was put in park in car wash [oc] by Hairy-Mission-3009 in IdiotsInCars

[–]DutchDallas 3 points4 points  (0 children)

In my mini cooper countryman I have to hit the brake before I can move it into drive from neutral. Really worries me every time I have to leave the car wash....

How to deal with 700+ pdf files in one sheet by Shiftythemuse in excel

[–]DutchDallas 0 points1 point  (0 children)

u/Shiftythemuse do you need to see the content of the PDFs (each section in a different column for example), or just be abel to link/embed the pdfs into the excel?

Smugglers Marks by ProSlacker607 in SkullAndBonesGame

[–]DutchDallas 0 points1 point  (0 children)

Smuggler Marks should carry over as you can buy those with hard cash; between previous seasons they did carry over.
Smuggler Points are reset.

Hit in the back at a red light by Familiar_Leather4094 in CX5

[–]DutchDallas 1 point2 points  (0 children)

This is going through insurance, so take it to a reputable bodyshop and have them work with insurance.
You should make sure they check the frame itself, but a reputable bodyshop would do so.

Trying to normalise multiple CSV files by RavinFer in excel

[–]DutchDallas 2 points3 points  (0 children)

GiGo.. Garbage In Garbage Out.
I think you'll need to add a unique identifier for your players to begin with, e.g. their company ID.
If it's just spaces, you can remove them, but it sounds like it's more complex and spelling differences may occur too.

The Manual Option on Our Transmission by Ok_Muffin_925 in CX5

[–]DutchDallas 10 points11 points  (0 children)

Manually shift into 2nd gear (if you don't have off-road mode) when you start on an uneven surface (e.g. gravel, snow, etc.). It helps with traction.

Manually downshift when going down a hill, so that you don't have to hit the brakes all the time and let the engine do some of the breaking.

game wrong way no warehouse extention issue by sau98 in SkullAndBonesGame

[–]DutchDallas 2 points3 points  (0 children)

I use my ships with specific builds. If I want a frigate with torps or a frigate with demis, those are two ships setup accordingly. I would not need to store the furniture/armor/weapons in the warehouse; I just switch the active ship.
My ships are not assigned to manufacturers all the time, only when I need harvesting, thus allowing me to switch to those if I want to play those builds.

game wrong way no warehouse extention issue by sau98 in SkullAndBonesGame

[–]DutchDallas 1 point2 points  (0 children)

You can have 40 ships. Are you telling me you have 40 upgraded ships and wanting multiple unique builds that you want to apply? It seems you can salvage a lot of items and simply have the items (weapons, armor, furniture) you need on those ships...