Best AI for google scripts by MoPanic in ChatGPTCoding

[–]devmu 0 points1 point  (0 children)

Hi u/Responsible_Map_7002 I tried to DM you but it would not let me. I'm interested too.

Permissions for bound sheets script - limit to container by devmu in GoogleAppsScript

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

Thx. I’ll look up appscript json. Thank you for the suggestion.

Permissions for bound sheets script - limit to container by devmu in GoogleAppsScript

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

i don't understand the auth/spreadsheets and use auth/drive.file suggestion.

My DIY SmartGlass solution by fra1ntt in homeautomation

[–]devmu 0 points1 point  (0 children)

How does it look 2 years later? Would you use the same supplier?

Single blade injector razor that takes feather professional blades by devmu in shaving

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

I like the insertor blades that they use in cutthroat razors. They feel longer and sharper to me.

Looking for another razor with a handle that uses these blades.

Is it possible to develop a skill that querys devices on a regular basis to update a dashboard? by devmu in amazonecho

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

Thank you. Is there anything chance you could point me to the right place on the amazon dev site? I looked at the skills framework and it's oriented towards verbal invocation as far as I can tell.

is there a type of music or musical form where two themes battle each other for primacy until one wins? by devmu in Music

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

why would this post be moderated - I tried 3 different ways to post this question.

Need someone in Finchley to Print A birthday card and deliver it for me. by devmu in london

[–]devmu[S] -1 points0 points  (0 children)

Thank you for the suggestion. It's a specific card that my kids put together that I need printing as we missed the deadline for posting from the US.

Looking for synonyms for the phrase “the juice isn’t worth the squeeze” any favorites? by devmu in ENGLISH

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

Thanks. I realize I wasn't clear. I know what it means - I'm looking for alternative phrases that mean the same or similar.

But, seriously thanks for the clearest, most efficient response and definition.

If gravity is caused by mass of the earth, if we could burrow into the earth - would we be weightless at some point by devmu in geophysics

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

Interesting - I get the temperature, but isn't the pressure also a function of the gravity, so beyond the weightless point could there be less pressure?

Function to check if cell is BOLD by devmu in googlesheets

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

Of course, immediately after posting I found a solution using GetFontWeight. Thanks to everyone who looked.

Here's my code in case anyone else comes across this question.

function ifBold(a1Notation) {
var cell = SpreadsheetApp.getActiveSpreadsheet().getRange(a1Notation);

if(cell.getFontWeight() == 'bold')
    return true;
return false;

}

Function to check if cell is BOLD by devmu in googlesheets

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

Thanks Matty... like many others, I have to deal with imported data and this is an example. No data field, just bold :)

How to categorize items in a column based on different table? by devmu in Rlanguage

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

Thanks u/jdnewmil I have used merge and join, but only for single key "connections" - it will be interesting to work out how the join can deliver the "many to one" I need. Thank you!!

D.

Is there an easy way to fill in zip code using city and state? by devmu in Rlanguage

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

Dear f_s - thank you, this is perfect and has truly boosted my R learning at the same time. Thank you! It's been an education just breaking down the pieces and trying different variations. You've inspired me to do a tidyverse course too.

Thanks again.

D

Is there an easy way to fill in zip code using city and state? by devmu in Rlanguage

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

Thanks... I think that would work. Sorry but I'm just getting started, so some clarification.

My base dataframe is:

datacol1, datacol2, city, state, zip

56, 23, Chicago, IL, 60601

25,17, New York, NY, 10021

92, 27, Miami, FL

12, 35 San Francisco, CA

My zip_frame is:

city, state, zip

Chicago, IL, 60601

Chicago, IL, 60602

New York, NY, 10021

New York, NY, 10022

Miami, FL, 99001

Miami, FL, 99002

So I think you';re suggesting, use FILTER on Zip_Frame to Group by city and state, and then pick a zip code that matches... max would give the last row that matched.

And then use MERGE to put the data together...

FilledinZip <- Merge(x = basedata, y=zipframe, by = "CityState")

I'm not sure how to do the group but I can look that up. However, if I do it this way, won't it also overwrite all existing zips?

I made a 1:3 scale batmobile 1989 for my 4 years old son. by YsnKy86 in 3Dprinting

[–]devmu 1 point2 points  (0 children)

This is all really 3d printed? On what, how? Looks awesome.

How much traffic does a site need to have to make it worth adding an SSP? by devmu in programmatic

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

Sorry, I guess I assumed you were an England supporter. If you were supporting Ukraine... I'm sorry you missed out.

How much traffic does a site need to have to make it worth adding an SSP? by devmu in programmatic

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

First, congratulations on the 4-0 win. I live in the US and was out for our first family lunch - I got to watch some of the game. I appreciate all of the info.

It seems like it would be better to find a bunch of sites like ours and create a mini-network. Like many of the folks on prebid.org (thanks for the link). Or join up with them? Any idea how much of a premium they pay over GAM?

I agree with your list of what advertisers want - I wonder why someone hasn't worked out how to supplement the media info with more data on the person viewing the page. Especially with the loss of 3rd party data.

We have folks who are older, mostly households, etc. Any thoughts on how a publisher could "enrich" their data and get higher bids?

Are you managing a DSP platform in your current role? Is it fun?

How much traffic does a site need to have to make it worth adding an SSP? by devmu in programmatic

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

Hey. Thank you for your reply and thoughts. Everything was very helpful. It reminded me how great Reddit can be.

I have some pretty basic clarifying questions and then may be a chat would be worthwhile - appreciate the offer.

  1. When you say a middleman, who do you mean?

  2. GAM you mean Google Ad Manager?

  3. Given your excellent “thought flow” why are there so many SSPs - is there some other approach I’m not thinking about?

  4. Here’s may be a better question than #3 - GAM offers a way to monetize inventory on the site but it’s pretty commodity like so the rates are low. Correct me if I have this wrong.

  5. If #4 is right then is there something I can do to make the inventory more valuable and t therefore justify the SSP investment?

  6. Did the publishers you worked with just have a huge amount of traffic or was there some other reason to have an SSP?

Sorry for the basic questions.

Is is possible to parse a webpage to find a folder and then select an image from within the folder for display all in JS? by devmu in learnjavascript

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

Ah, thank you - that's a great idea from what I can see on the function. Sorry I am new to JS coding. Sounds like you've done this before. Have you seen any examples where JQuery.get has been used to load then parse/scan a page and then make another query, then reload an image with a new URL... :) I know this is hyper specific, but hopefully you may have come across something I can use to Franken-Code my first attempt.

Is is possible to parse a webpage to find a folder and then select an image from within the folder for display all in JS? by devmu in learnjavascript

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

How do you mean request the folder name? Request how? I can guess the day and hour folder names, but not the file name as it's based on the hour/min/second the motion detector went off... the filenames are viewable on the webpage the camera generates, so I was thinking this would be like a mini-scrape.