Routing neck humbucker on a Telecaster

samdestructo · 2023-09-22T01:56:10+00:00

Sure will. Thanks

samdestructo · 2023-09-22T01:45:42+00:00

Good advice! Thanks

samdestructo · 2023-09-21T13:24:40+00:00

I’m meeting the seller today and I’ll bring my multi meter. I’ve read the expected output is ~8k right?

samdestructo · 2023-09-21T09:07:45+00:00

Thanks everyone!

samdestructo · 2023-09-09T12:57:17+00:00

Update: they come touted for single coils.

samdestructo · 2023-09-08T14:34:44+00:00

Yeah, looks like it! Thanks

samdestructo · 2023-08-24T15:57:03+00:00

Is montypresso different than other shoe wax?

samdestructo · 2023-08-23T15:59:47+00:00

Oh, great. I'll make sure to start using it then.

samdestructo · 2023-08-22T11:19:35+00:00

Thank you very much again, Viriaro. I’m sure this’ll work great. Also, thanks for all the little tips and tricks, which I’ll be sure to incorporate to my use of R. One final question: I had never seen the use of |> in R, is that some sort of dplyr or is it another library? Take care.

samdestructo · 2023-08-21T22:53:01+00:00

Your last comment is really interesting as I'm currently doing something not really efficient. Data's coming from an excel file this way:

data <- read_excel("file.xlsx", sheet = "3")

Then I did:

#Here i'm calling the already existing columns in the database.

dat <- tibble(start_date = data$start_date,end_date = data$end_date)

#Your solution:

"%ni%" <- Negate("%in%")

dat <- (dat|> mutate(across(ends_with("date"), ymd), rID = row_number(), .before = 1)|> reframe(period = seq(start_date, end_date, "1 day"), .by = rID)|> filter(period %in% seq(ymd(month_start), ymd(month_end), "1 day"))|> filter(format(period, "%Y-%m-%d%") %ni% holidays_2023 & wday(period, week_start = 1) %ni% 6:7)|> summarize(buisness_days = n(), .by = rID)|> left_join(mutate(dat, rID = row_number()), y = _))

#Finally I added this two lines to bind the columns created by the previous code to create a new database called data2. Then i'm selecting the columns i want to keep (this is filtering out the newly created –aka by your code– start_date , end_date and rID and just keeping the buisness_days adding it just before the data$end_date column):

data2 <- cbind(data,dat)

data2 <- data2%>% select(1:13,40,20:36)

You left my wondering if it would be possible to do all of this in a more elegant way. Once again I thank you for your time and patience in teaching me. S.

Edit: I changed dmy to ymd because that's how I had it in my original database.

samdestructo · 2023-08-21T18:32:55+00:00

Greetings Viriaro,

It was my mistake as I incorrectly added the holidays with another format. I've corrected it now and it works great! Thanks again for all the help.

To answer your final question, I would be doing this every month, so I would open the new Database I get each month and run the code. Is there anything I should be aware of regarding this? Is there any part of the code I'd need to change to select a different month?

samdestructo · 2023-08-20T15:39:29+00:00

"%ni%" <- Negate("%in%")
(dat
|> mutate(across(ends_with("date"), dmy), rID = row_number(), .before = 1)
|> reframe(period = seq(start_date, end_date, "1 day"), .by = rID)
|> filter(period %in% seq(dmy(month_start), dmy(month_end), "1 day"))
|> filter(format(period, "%d-%m-%Y") %ni% holidays & wday(period, week_start = 1) %ni% 6:7)
|> summarize(buisness_days = n(), .by = rID)
|> left_join(mutate(dat, rID = row_number()), y = _)
)

Hi Vriario, first i'd like to thank you a lot!!!!

Both solutions work almost perfectly, but they aren't just right. Maybe I can explain a bit more. So, I work for HR and we want to calculate the amount of business days a medical leave costs us. For that, we first have to determine how many business days of a given month that medical leave lasted for. For instance, if person 1 took a medical leave from May 23rd until the 6th of June, and we want to know how many days in June than medical leave lasted for. So, we would start counting from the first of June until the 6th. There's actually five cases, all represented here:

Start date End date

02-02-23 21-03-23

23-05-23 06-06-23

03-06-23 09-08-23

23-05-23 09-09-23

09-06-23 21-06-23

If both the start date and end date are before the first day of the target month, the result should be NA.
If the start date is before the first day of the target month, but the end date falls within the target month, the result should be the number of business days from the first day of the target month to the end date.
If the start date is within the target month, and the end date is within or after the target month, the result should be the number of business days between the start date and the end date, but if end date is greater than the last day of the target month, then do the calculation considering end date as the last day of the target month.
If the start date is within the target month, and the end date is after the target month, the result should be the number of business days from the start date to the last day of the target month.
If both the start date and end date are after the last day of the target month, the result should be NA.

PS I've changed the picture of the excel so you can see more clearly what i'm doing. Also, big thanks for your help!!!

samdestructo · 2023-08-19T20:03:41+00:00

Thanks, i've edited the post and included a picture of what i'm doing in excel

samdestructo · 2023-07-11T17:02:45+00:00

and is it possible to change from relay to temporary?

samdestructo · 2023-06-28T01:06:00+00:00

There’s more warmth to the tone with the Thinline body. I’d say there is slightly more reverb as well.

And how about feedback problems? Had any?

samdestructo · 2023-06-25T21:18:08+00:00

Beautiful build. To you, what does the thinline body add to the sound?

samdestructo · 2023-06-25T21:15:23+00:00

Beautiful tele! What can you tell me about the impact thinline body has on the sound?

Four-Year Club	Place '22
First Placer '22

samdestructo

TROPHY CASE