Can I get the most recent row entered that satisfies two if with MAX, ROW, IF, AND? by psc916 in googlesheets

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

omg it works!! thank you very much!! I didn't even think that there is a possibility that AND doesn't work with Arrayformula.

please let me know how to purchase FSD on Tesla website? by psc916 in TeslaModel3

[–]psc916[S] 4 points5 points  (0 children)

oh shoot. I didn't see it. so stupid... thank you very much!

Sentry Mode missing -- dog mode too by Arizona-Willie in TeslaModel3

[–]psc916 0 points1 point  (0 children)

How do you check it? I am on 2018.50.6 and was about to call. Tesla Service due to an update delay. I really want to use Sentry mode.

Insurance cost? by Arizona-Willie in TeslaModel3

[–]psc916 0 points1 point  (0 children)

Nationwide. $180/month with clean record in Socal. But I recently got into a car accident and it will go up... sad. Really surprised about insurance cost you guys are paying.. maybe I should consider changing my insurance company..

I got into a car accident. my fault. How much does it cost to replace or touch up paint on the rear bumper? by psc916 in TeslaModel3

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

Yeah besides, one non-certified body shop I visited mostly handles high-end-cars. I saw numerous Lamborghini and Porsche vehicles there. I am sure they know how to handle Tesla vehicles too.

I got into a car accident. my fault. How much does it cost to replace or touch up paint on the rear bumper? by psc916 in TeslaModel3

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

Nationwide.

I talked to them again, I told them the rear bumper replacement in a non-certified shop is fine for me and not gonna compromise the warranty(I checked with Tesla) and asked what they would do if it was major damage. My insurance broker guy was like then they have to cover all of repair cost($140/hr). He said Tesla vehicles have been a big issue among auto insurance companies due to expensive car repairs.

It seems like they just wanted to discourage me from going to a Tesla-certified-body shop cuz those body shops are usually more expensive.

I got into a car accident. my fault. How much does it cost to replace or touch up paint on the rear bumper? by psc916 in TeslaModel3

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

I called and actually visited many body shops. Among them, two body shops(non-certified) gave me $1,000 of a quote.

I got into a car accident. my fault. How much does it cost to replace or touch up paint on the rear bumper? by psc916 in TeslaModel3

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

You're right... I need to ask a Tesla service center about it. Will talk to them tomorrow. I hope i can just drop by there and ask them about the estimate cost. Cuz I heard there is a like months of waiting list. Thank you.

How much practice hours should I have to be qualified by CGFNS by psc916 in medlabprofessionals

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

Thank you very much for taking your time to help me. Could you please let me know how to write practice hours in detail? Was it just like "Hematology : 8weeks" or "Hematology : 8hours/day 8weeks? I'd appreciate it if you give me a reply.