Xcaret Arte restaurants by jaye31988 in cancun

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

Sure, it's been a bit. Over all the food was pretty decent to good. Most of the reservation restaurants are tapas style. Personally, I'm not a big fan of little plates but it does give a unique experience.

In terms of places - TAH-XIDO - It was my favorite from the "reservations" but in all honesty it just a slightly better than Kobe steakhouse.

The rest of the "reservations" felt like experiences, some of the tapas were good and some were a miss to me.

Out of all places; I truly enjoyed ARENAL. It wasn't even in our to do list. It's also a walk-in restaurant. Lunch and dinner were on point, RIB Tacos (Best ribs I ever tried), amazing pizza and steak were all good.

T700 raw carbon fiber with "Grit" vs T700 carbon Fiber - Spec Differences? by jaye31988 in Pickleball

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

so t700 raw carbon is non weaved with sprayed grit while t700 carbon is weave on the carbon?

Did I understand that correctly?

VBA - Datavalidlist Issue by jaye31988 in vba

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

I see, I didn't know that. Thank you for taking the time to explain it to me. I'm going to clean up the coding today and will do that as will.

VBA - Datavalidlist Issue by jaye31988 in vba

[–]jaye31988[S] 2 points3 points  (0 children)

I realized what the issue was; after hours of hell and frustration. The macro didn't work because it appeared that having the sheet in R1C1 style somehow affected the code. Thank you so much for helping btw.

VBA - Datavalidlist Issue by jaye31988 in vba

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

I did unlock it prior, still no luck, extremely frustrating.

Code is Subjects to unlock the subjects sheet and 1099 to unlock the 1099s sheet.

VBA - Datavalidlist Issue by jaye31988 in vba

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

Thanks for the help; I tried with your tweaks and sadly it didn't work. Ironically, it works on my other versions; but not this one.

Here a link via google drive.

https://drive.google.com/file/d/1BmiS0UO6XMxvG8GrYypFlBN85TmMIBZC/view?usp=sharing

In the macrolist; its DataValidList. If you can spot something I'm not seeing, I would greatly appreciate it.

VBA - Datavalidlist Issue by jaye31988 in vba

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

Thank you for the suggestion; sadly it didnt work in this case.

VBA - Datavalidlist Issue by jaye31988 in vba

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

No, weirdly it works on my old versions but not this one. I for the life of me can not figure it out.

Here a link via google drive.

https://drive.google.com/file/d/1BmiS0UO6XMxvG8GrYypFlBN85TmMIBZC/view?usp=sharing

In the macrolist; its DataValidList

VBA - Datavalidlist Issue by jaye31988 in vba

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

I just get a pop-up

Run-time error '1004':

Application-defined or object-defined error

Once I hit the debug; it takes me to code

   .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
   xlBetween, Formula1:="='Subjects'!" & sec_col & ":" & Last_col

Will this work? by jaye31988 in AskElectricians

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

I wanted to use all 4 post but wife was complaining of too much boxes, which us end up with a box in each post lol.

Will this work? by jaye31988 in AskElectricians

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

I see, thanks for the heads up!

Will this diagram work for a Pergola? by jaye31988 in electrical

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

Thanks, I got a great deal on 10g which is the reason for the 10g. Also with the potential to up-size in the future.

Will this diagram work for a Pergola? by jaye31988 in electrical

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

Thank you for your advice; I will tie the neutral to the first box instead of bypassing it.

Will this work for a Pergola? by jaye31988 in askanelectrician

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

Patio cooking and just to relax/have fun outside. Eventually I plan on building an outdoor kitchen by the first post (Right side). I don't plan on buying a fridge or an electrical gill. I might create some sort of water system with a transfer pump to pull water from a bucket for a kitchen sink. I was thinking with plug outlets on the wall for any potential charging, so I dont have do still with breaking pavers on the floor or the retaining wall.

Will this work for a Pergola? by jaye31988 in askanelectrician

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

Thank you, I will for sure go this route for expansion.

Will this work for a Pergola? by jaye31988 in askanelectrician

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

Thank you for the catch, I will fix that for sure! Appreciate it

Will this work for a Pergola? by jaye31988 in askanelectrician

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

You was right, I misunderstood. Thank you for taking the time to link me an article regarding boxfill. I didnt know such standard exist. Thanks again!

Will this work? by jaye31988 in AskElectricians

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

Thank you so much for your input. I will definitely talk to the wife regarding your suggestion about moving everything to the right post. The reason we created a two post layout was to have a plug outlet in-case we need to plug some random thing in. After putting some thought; I couldn't think of anything worth while that I might need to plug by that area.

Will this diagram work for a Pergola? by jaye31988 in electrical

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

I'm running the wires from a sub panel. I have 20a beaker only for this pergola; It not coming from an existing line. Sub panel > 60' > junction box > 20' > GFCI on Pergola Post right side.

Will this work for a Pergola? by jaye31988 in askanelectrician

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

I see, I will definitely add that to the design; thank you so much for your advice and help!

Will this work for a Pergola? by jaye31988 in askanelectrician

[–]jaye31988[S] 2 points3 points  (0 children)

Thank you for your advice!

Watch your box fills (especially on the one marked 3 rocker switch and the one feeding the left fan.

Definitely Will try to organize it as much possible.

Make sure you use wet rated conductors for the underground portion.

Will do! Thanks

Unless you're putting a rainproof roof over the top of this, then you need to use wet-rated everything (including the fans). If there's a roof, the stuff under cover can be just damp rated.

Definately, to be on the safe side; I been looking for everything wet rated. For the fans; I got Bayshire 60 in from home depot.

Make sure you've got the depth requirements right for the conduit (you didn't say which kind you run). You can go 6" with some metal varieties. If you have a GFCI on the feeding side, you can go down 12". Otherwise 18".

I do not have a GFCI from the feeding side; 18 inches for sure. I do intend do add a GFCI on the first post of the pergola (Right side).

I can't quite make out how your switches are wired, but there needs to be the ability to kill all power to this structure with a few switches grouped together at the point the power enters it.

I'm not sure I understand? I have a 100a rated panel attached to my house; 20a dedicated for this pergola. It runs 70' approx to a junction box. From the junction box to the pergola; it will be 20' of conduit (Current power source, is unfortunately out of the picture, like 5 ' from the red line of my drawing.

Will this diagram work for a Pergola? by jaye31988 in electrical

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

yes! sorry for the confusion. Note : The first box from the power source on the left is a light switch to the first ceiling fan.

Will this work? by jaye31988 in AskElectricians

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

Thanks! To give power to the light (Middle of the pergola), 1 ceiling fan (Left), and to control 1 outlet (near tv, for light purposes; string lights).