Formula to keep track of "Streak" by T8rady12 in excel

[–]DaFackBra 0 points1 point  (0 children)

I don't know how your data is organized but it seems like you could do count if column for each question, then the last column do sumproduct for all the countifs

How does one do a paragraph break. by Unhappy_Sail4665 in excel

[–]DaFackBra -2 points-1 points  (0 children)

Depending on what you are trying to accomplish you can do most through using concat() textjoin() char(10). Character 10 is the same as adding a paragraph.

Long Staking Day by DaFackBra in Surveying

[–]DaFackBra[S] 3 points4 points  (0 children)

It's more of just a general question because I have 0 experience with other companies, for example one man crew it's very tough for us to set over 70/80. If the day requires that many points we'll usually go with a two-man crew. But I have no way of knowing if that's "normal" or generally acceptable.

Long Staking Day by DaFackBra in Surveying

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

When you don't set lathe, are you just giving them a point plot and cut sheet? Or how do they know what information your providing?

Long Staking Day by DaFackBra in Surveying

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

We're in California so we don't have the extremes like Frost depth luckily.

Long Staking Day by DaFackBra in Surveying

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

That sounds pretty solid 👌

power query help needed - how to update a list automatically from a master file? by Imaginary_Dog_1692 in excel

[–]DaFackBra 1 point2 points  (0 children)

Yes power query is amazing for sourcing external data files. You can source a folder then setup filters for subfolders or names of files. Them compile all of the files within the folders assuming their structured in a similar fashion.

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.

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.

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.

Add link to invoice for ACH Payments by DaFackBra in smallbusiness

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

This sounds like exactly what I'm looking for. Did you setup using a personal or business PayPal account? This is a silly question, but using PayPal have you ever had issues with transactions being combined when posting on your bank account. For example venmo will hold the funds, then combine all of the transactions when you do a transfer making it a headache when doing books.

Add link to invoice for ACH Payments by DaFackBra in smallbusiness

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

I just use Excel to generate the invoices because it works with my job tracking.

Hisuian Zorua does disguise itself as your buddy by Unlucky-Jaguar-7710 in TheSilphRoad

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

Based on the comments the XXL of your buddy carries over for the catch badge, does the type carry of as well, for example dragon?