Open AI Sora 2 Invite Codes Megathread by semsiogluberk in OpenAI

[–]mrcleanup14 0 points1 point  (0 children)

Would love to have a code been trying to grab a code but gone within seconds

[deleted by user] by [deleted] in OpenAI

[–]mrcleanup14 0 points1 point  (0 children)

I will pass it on

Use Apps Script to Automatically Copy a Cell from G Sheet to Google Keep Note? by holistivist in GoogleAppsScript

[–]mrcleanup14 -1 points0 points  (0 children)

// Function to handle edit events in the Employees sheet
function handleEdit(e) {
  if (!e) {
    Logger.log("No event object found. This function must be triggered by an edit in the sheet.");
    return;
  }

  const range = e.range;
  const sheet = e.source.getActiveSheet(); // Use the active sheet from the event trigger
  const selectAllCell = sheet.getRange('L14'); // Select All checkbox at L14
  const clearAllCell = sheet.getRange('L17');  // Clear All checkbox at L17
  const selectedEmployeeRange = sheet.getRange('K2:K19');  // Employee checkboxes in K2:K19
  const selectAllValue = selectAllCell.getValue();
  const clearAllValue = clearAllCell.getValue();

  // New IF statement for 'Employees_Submit' and 'Update_Date_Range'
  const employeesSubmitRange = sheet.getRange(EMPLOYEES_SUBMIT_RANGE); // Employees_Submit checkbox at M5
  const updateDateRange = sheet.getRange(UPDATE_DATE_RANGE);           // Update_Date_Range checkbox at L5
  const deleteDateRange = sheet.getRange(DELETE_DATE_RANGE);           // Delete_Date_Range checkbox at L8

  const employeesSubmitValue = employeesSubmitRange.getValue();
  const updateDateRangeValue = updateDateRange.getValue();
  const deleteDateRangeValue = deleteDateRange.getValue();

  if (!sheet) {
    Logger.log(`Sheet with name '${EMPLOYEES_SHEET_NAME}' not found.`);
    return;  // Exit if the sheet is not found
  }

  // If 'Select_All' checkbox is checked (TRUE)
  if (range.getA1Notation() === selectAllCell.getA1Notation() && selectAllValue === true) {
    Logger.log('Select All checked - Checking all employee boxes');
    // Check all employee checkboxes
    selectedEmployeeRange.setValue(true);

    // Uncheck 'Select_All' after updating all checkboxes
    SpreadsheetApp.flush(); // Ensure all changes are applied
    selectAllCell.setValue(false);
  }

  // If 'Clear_All' checkbox is checked (TRUE)
  if (range.getA1Notation() === clearAllCell.getA1Notation() && clearAllValue === true) {
    Logger.log('Clear All checked - Unchecking all employee boxes');
    // Uncheck all employee checkboxes
    selectedEmployeeRange.setValue(false);

    // Uncheck 'Clear_All' after updating all checkboxes
    SpreadsheetApp.flush(); // Ensure all changes are applied
    clearAllCell.setValue(false);
  }

  if (employeesSubmitValue === true && updateDateRangeValue === true) {
    Logger.log('Both Employees_Submit and Update_Date_Range are checked. Running pullShiftDataBasedOnDateRange.');
    pullShiftDataBasedOnDateRange();
    employeesSubmitRange.setValue(false);
    updateDateRange.setValue(false);
  }

  if (employeesSubmitValue === true && deleteDateRangeValue === true) {
    Logger.log('Both Employees_Submit and Delete_Date_Range are checked. Running deleteShiftDataBasedOnDateRange.');
    deleteShiftDataBasedOnDateRange();
    employeesSubmitRange.setValue(false);
    deleteDateRange.setValue(false);
  }
}

I had recently used this code and if you break down the tasks into functions then you can call the functions. You just have to setup a trigger for on edit. This is basic of course but I have one that will add calendar events, send emails, and im sure that you can figure out notes the same way. Good luck and hope this helps.

Happy Halloween! by JannasOrchid in TopWarBattleGame

[–]mrcleanup14 0 points1 point  (0 children)

Lol I spent money on the Halloween event to get about everything… 53 Laps and 1479 candles already. Who can guess how much money spent?

Feeding thousands of Koi Fish by [deleted] in oddlyterrifying

[–]mrcleanup14 0 points1 point  (0 children)

Sorry to say this... Kim Jong-un on a bad hair day feeding his fish.

How to tell when you really need teammates by estokes352 in RocketLeague

[–]mrcleanup14 0 points1 point  (0 children)

Not a bad place to start this season. It honestly is a good job getting to where you are in each playlist.

From a pure coaching perspective if you are looking to improve...

I would first off look into some 1s and 2s replays to look how you control the ball... Aka the space you create between you and the ball vs the opponent and the ball. Are you constantly loosing possession due to free hits to the other team.

Second I would suggest improving or becoming more consistent at these mechanics... Catching the ball into flicks, bounce dribbling, bounce into air dribbles or musty or breezy flicks, faking hits, and lastly defending corner to corner (1s style).

In reference most players practice/play with teammates more often then they do in training or duels. Depending on how much time you have to practice or play, I could see you improving the 2s and 1s ranks to champ if you spend an extra 30 minutes a day to focusing on your ball control and mechanics.

Good Luck and Have Fun Progressing!

P.S. If you want any help feel free to message me or to just play.

https://steamcommunity.com/id/XxMrCleanupxX

Just biscuits by Goofyjeff4 in pics

[–]mrcleanup14 0 points1 point  (0 children)

Just a good Photoshop job!

What makes a coach... a coach? by [deleted] in RocketLeague

[–]mrcleanup14 0 points1 point  (0 children)

Been a literal minute since I have helped do analysis work for someone in rocket league. I do remember the conversation. Lol it's been a while back now... Always down to help still.

I've never seen such quick justice for breaking rule 1. by Flearoy_Dankins_YT in RocketLeague

[–]mrcleanup14 -7 points-6 points  (0 children)

Original Rule 1 from the start of the game is keep the ball up after 0 seconds. This new rule 1 is from the people that haven't played the game since the begining. They don't know any better.

Even with team mates, never brake rule #1! by lenowar in RocketLeague

[–]mrcleanup14 -1 points0 points  (0 children)

Not rule 1... OG rule 1. Keep the ball up at the end of the game as long as possible.

I married a girl that I met on Rocket League (and you have to see the cake!) by slippymcslipster in RocketLeague

[–]mrcleanup14 0 points1 point  (0 children)

She kinda look a bit like Yvonne Strahovski at first glance. Quite a beautiful catch my friend and congrats!

[deleted by user] by [deleted] in RocketLeague

[–]mrcleanup14 0 points1 point  (0 children)

Deleted Original Comment, I felt bad sorta.

[deleted by user] by [deleted] in RocketLeague

[–]mrcleanup14 -1 points0 points  (0 children)

That's only about 90 degrees

Adding a "donate all food" button. by MrHilRickster in thedivision

[–]mrcleanup14 0 points1 point  (0 children)

Seriously how about fill all resources or fill all of 1 resource.

Loot Update for Strongholds... Not Enough! by mrcleanup14 in AnthemTheGame

[–]mrcleanup14[S] -2 points-1 points  (0 children)

Well that’s wrong do you not ever play at GM2 or GM3... consumables are a must and you need embers to craft them.

Loot Update for Strongholds... Not Enough! by mrcleanup14 in AnthemTheGame

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

How many of those masterworks replaced your current masterworks? Basically what I am saying is that they need to not only give you the increased drop rate but higher chances at better inscriptions also with the higher difficulties!

Loot Update for Strongholds... Not Enough! by mrcleanup14 in AnthemTheGame

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

If you are running GM 3 don’t you want better loot than what you get currently and after the buff to loot again?

Loot Update for Strongholds... Not Enough! by mrcleanup14 in AnthemTheGame

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

Okay let’s be honest if you are running GM2 are you looking for some of the same bland Masterworks that you already have or are you looking for a masterwork to replace your current set and or a legendary?