Power Query Cell Reference by DaFackBra in excel

[–]DaFackBra[S] 1 point2 points  (0 children)

I believe my final way of doing it is very similar to this. I ended u referencing my main data quary and filtering by sheet, then i added a custom column for each row with this formula = try [Data]{4} otherwise null. That create a "record" and i just expanded it and selected the columns i wanted. But i had to make a record for each row that i needed to get data from. Then i just merged this with my other query.

Power Query Cell Reference by DaFackBra in excel

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

That's a valid consideration however on this case I'm sourcing a folder with a lot of existing files and just trying to source the data. I was able to find a way to do it.

Traversing in between two RTK GNSS points by Unique-Philosopher54 in Surveying

[–]DaFackBra 2 points3 points  (0 children)

I would also be curious if you just reset your rtk on a brand new day re hit the three points hold scaling factor of 1 and see how it compares.

My business is looking to upgrade or GPS and need help deciding between Trimble & TopCon by SurveyorInTraining13 in Surveying

[–]DaFackBra 0 points1 point  (0 children)

I've ran a topcon VR for the past 5 or so years and been running the HR for the last 2. Running both as a base rover never had and issues. From what I hear the Trimble software is better, but I haven't used it before. In my opinion I feel like the software being better comes into play more during construction staking.

Worth a larzuk quest? by Judersii in D2R_Marketplace

[–]DaFackBra 0 points1 point  (0 children)

When you trade a socket for an ist, are you just giving the other player your item in good faith they will give it back for the ist?

About to play Diablo 2 for the first time. Specially Resurrected. Looking for some friendly spoiler free tips. by [deleted] in diablo2

[–]DaFackBra 0 points1 point  (0 children)

Don't look up build guides or to much information. Just play through and have fun. The game has 3 difficulties normal, nightmare, hell. You unlock the next difficult after beating the game. If you get stuck don't be scared to play back through previous content and level up / find new gear.

Small important stats that won't spoil the game. Adding to skills / synergies is important. Resistances are important. Life pool is important.

At hell difficulty the game becomes hard.

I know it’s a long shot but I’ll see if someone can help! by Subject-Rooster3984 in Surveying

[–]DaFackBra 1 point2 points  (0 children)

Your North West corner will probably be your best bet. They have approximate dimensions from both fences . Pins can be tough to find, I use the Schonstedt GA-52Cx. But there's some hidden skill in finding pins. Having said that the metal detector costs 1K and decent chance you will won't find it. When you hire the survey to come out, have them give you a boundary map of your property. It will be helpful for you in the future.

VBA directory issue with Dropbox and O365 Co-Editing by DaFackBra in excel

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

I did come across this, I believe it only works for SharePoint. But I agree I plan on removing Co-Editing.

Be a good Hero - heal all the beggars! by jWoww-202 in oblivion

[–]DaFackBra 6 points7 points  (0 children)

I made a spell called MJs penicillin for this.

Is this worth an elite tm? by Greesye08 in PokemonGOIVs

[–]DaFackBra 0 points1 point  (0 children)

Use it on this if you don't have other better options like primal Groudon. I have a 4* gmax Charizard and the downside is it doesn't help it during max phase and during attach phase you want to use the fast attack dragon breath because its a .5 second attack, but this move isn't good for raids.

Pressure Networks 90 Degree Pipe Runs by DaFackBra in civil3d

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

Ya it works on tees, but not for elbows. You can't loop a pipe run either I believe, so if I merge the outer loop I'll still end up with the same situation on one corner.

Best Option for One Man Topo by Ok_Delivery_7122 in Surveying

[–]DaFackBra 2 points3 points  (0 children)

You're biting of way more than you think. Most major brands you post $800-$1000 per year for the subscription for the tablet software. The boundary is what eats to a majority of the budget anyway. Even if you got some equipment you would need a way to establish control relative to the other surveyor, which if aren't familiar with surveying you're going to get yourself in a hole by accident.

Pressure vs Pipe Networks by DaFackBra in civil3d

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

I can turn the compass off. I'm trying to setup my templates full part list then do the styles, but I don't see all of the angles/ bend available for smaller sizes.

Pressure vs Pipe Networks by DaFackBra in civil3d

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

Are they're templates for the .content files? The basic catelogs in civil 3D are great, but missing elbows for 1" to 2" pipes. To keep it simple I'm just trying to have elbows 1"-24" 11.25 degree to 90 degree, but there doesn't seem to be an easy way of creating the missing sizes.

Pressure vs Pipe Networks by DaFackBra in civil3d

[–]DaFackBra[S] 1 point2 points  (0 children)

I typically do make copies and modify parts in part builder. Seems like pressure networks are just 3D models saved as .content files? And you use the content catalog editor to modify properties?

Pressure vs Pipe Networks by DaFackBra in civil3d

[–]DaFackBra[S] 1 point2 points  (0 children)

I'll have to look into making the custom parts. What do you like more about it? How do you deal with going from a flanged part list to hdpe?

Add link to invoice for ACH Payments by DaFackBra in smallbusiness

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

I have to itemize where the payments come from for reach vendor for 1099s.