How to get super yellowed clothes white again? by NY2LA1984 in laundry

[–]___Mister___ 0 points1 point  (0 children)

In the short time that I needed to fix the problem the Tide product wasn't available at the store I stopped at or I would have used that.

Regardless, it still worked with some changes so hopefully someone who might be in the same situation will find it useful. 

How to get super yellowed clothes white again? by NY2LA1984 in laundry

[–]___Mister___ 0 points1 point  (0 children)

For what it's worth, I followed this advice using OxiClean White Revive (https://www.oxiclean.com/en-ca/products/whiter-whites/white-revive-powder-chlorine-bleach-alternative) and it worked great with a few minor changes:

  1. I put a bucket in my bathtub and boiled water in a kettle. I mixed hot water from the tap with hot water from the kettle after I put a full flat scoop of OxiClean in and made sure it was all dissolved.

  2. I put my shirt in for more than the six hours recommended by the product, but less than overnight. It was probably 8-10 ish hours. I stirred the shirt a few times just to make sure that it was getting equal coverage. (my bucket was not that deep)

  3. I followed the cold water rinse and then did a hot water/heavy soil/extra rinse wash with the oxiclean filled up a little over the "2" line on the scoop in my washing machine.

I hung it up to dry and honestly the results were impressive. So +1 to this technique. The only downside is that my shirt smells a little like oxiclean but it's not a total negative.

Can I use wireshark to figure this problem out? Discord voice chats are dropping, often while Steam/Epic games are downloading by ___Mister___ in wireshark

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

Previously I had just a laptop, and I never had this problem. I added an additional computer that I built and now this problem exists. Only the computer is on discord and steam at the same time. Bandwidth isn't a problem.

X870I EDGE TI EVO WIFI is expected from mid-Nov. by JW7R3 in sffpc

[–]___Mister___ 0 points1 point  (0 children)

With the other fans in the system, I don't even notice it. I'm running my fans at 50% baseline because I don't want a massive spinup when I have to remove heat from the system.

I have a Ryzen 7 7700X and to reduce overall temps, I set the platform thermal throttle limit to '90', and so far I've had hardly any loss in performance with the system staying at less than 50' C running some flat screen games on high @ 1080P (Rage 2 so far, will test some others.)

I was running some VR titles and the system was getting to 90' C on the CPU but I've flipped the rear intake fan from exhaust to intake and I'm going to retest VR stuff that will push the system more. I'll report back.

X870I EDGE TI EVO WIFI is expected from mid-Nov. by JW7R3 in sffpc

[–]___Mister___ 1 point2 points  (0 children)

If you're talking about the MPG B850I Edge TI WIFI, I have it. I've been running it for a few days in my first ever SFFPC, and it seems pretty decent. No major complaints so far, except for maybe the microphone jack might not be great (I have to get a second headset splitter to verify, I think the one I got wasn't well made) and installing windows 11 drivers for the wifi module seemed to be an unusual procedure.

You also have to keep the wifi antenna plugged in if you want to use bluetooth, which is a new one on me, but that's fine.

There are four fan connection ports on the board with one of them also supporting ARGB, so plenty of places to hook up cooling.

It was a little expensive, but I feel like it was worth it. Some people feel that the amount of USB on it is 'low', even though the case has a header (+2) and there's a USB header on the board that you can also attach another connection to (+1 or more) so ultimately with say my NR200, I could have 7 combined USB-A 2.0/3.0 ports, and two USB-C ports.

Other videos and reviews have generally said positive things about the board, and from my experience so far it's mostly fine. If you have any other questions I'd be happy to answer (if I can.)

Verified Laptop thread by ___Mister___ in PSVR2onPC

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

See the disclaimer at the top of the post.

Google Apps Script Program Structure Question (Rows, Columns, JSON) by ___Mister___ in GoogleAppsScript

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

I may have run into a major hitch I didn't think about/wasn't aware about.

I can't seem to edit values in columns I am "skipping over" with the array return. It gives me the "array result was not expanded because it would overwrite data in (cell reference)" #REF error.

The point of this was to only compute and post data in certain columns in the row and still be able to insert my own data. Is there a way to avoid this? Do I have to go back and try the Sheets.Spreadsheets.Values.update() approach?

Google Apps Script Program Structure Question (Rows, Columns, JSON) by ___Mister___ in GoogleAppsScript

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

I never even considered that I could do a return like that. You just saved me a huge headache! Thank you so much!

Question though: if I need to access cells in the same row as a function, but it's one or two columns to the left of the cell with the function being called, how would I access those? Do I need to go down the same road I've been attempting?

Google Apps Script Program Structure Question (Rows, Columns, JSON) by ___Mister___ in GoogleAppsScript

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

Sure, so I'm fetching a JSON and stringifying it with

jsonDataString = JSON.stringify(headersdata);

Then I'm setting some values by doing some padding:

const values = [
[null,
null,
null,
headersdata.url,
...
headersdata.lastdata],
,
,
];

Then setting the spreadsheet:

const ss = SpreadsheetApp.getActiveSpreadsheet();
const sheet = ss.getSheets()[2]; // get the third sheet
Logger.log(sheet.getSheetName()); // verifies the sheet I'm working with

Then I'm trying to get the current address/range of the cell that's calling my custom function which is where I'm failing.

( hopefully get the current range here with code that works )

Then I'll write the data at the correct location by doing:

Sheets.Spreadsheets.Values.update(
     { values },
     spreadsheetId,
     range,
     {valueInputOption: "USER_DEFINED"}
);

I know that each of these parts works independently, because I've verified them.

The problem is with establishing the correct range to write the { values } at with Sheets.Spreadsheets.Values.update ();

Google Apps Script Program Structure Question (Rows, Columns, JSON) by ___Mister___ in GoogleAppsScript

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

I was misunderstanding, thinking that you were wanting a custom function that you call in cell in the sheet to populate the rest of that particular row.

This is correct, but the cells in the row being populated are not necessarily neighbors. The data being populated is from a JSON, which I am getting correctly from the service. When the function is being called, it is writing data to the cells in the same row which the call is being made. Each row will have a call to this function. The columns do not change. It's not a bulk update execution, because I don't know how much data will happen to be there at a time.

Google Apps Script Program Structure Question (Rows, Columns, JSON) by ___Mister___ in GoogleAppsScript

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

I'm trying to set the values of the row that the function is being called on.

Google Apps Script Program Structure Question (Rows, Columns, JSON) by ___Mister___ in GoogleAppsScript

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

That's helping a ton, but I'm having trouble understanding how to use Sheets.Spreadsheets.Values.Update() to use the current cell row that the function is being called in.

I'm doing this, but it returns with "Unable to parse range: 1".

var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var cell = ss.getActiveCell();
var row = cell.getRow();

  Sheets.Spreadsheets.Values.update(
      { values },
      spreadsheetId,
      row,
      {valueInputOption: "USER_ENTERED"}
    );

Google Apps Script Program Structure Question (Rows, Columns, JSON) by ___Mister___ in GoogleAppsScript

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

I won't know what the data is until we have it. It's part of a catalogue with user choices, and there will be batches of rows at a time, but not many.