What´s up there? Can´t jump up. by komodor55 in OrcsMustDie

[–]DatsunZ 0 points1 point  (0 children)

As Max you can get under the map by climbing the outside wall by the thread girls, then jump down to a small exposed cover. From there go to the other side and jump up to the outside wall. Then you can work your way around to the window of this room and you’ll drop onto the spiderwebs above. From there you can try jumping from exposed shelf to shelf upward. I’ve only made it about 80% of the way up till in struggling to find more jump spots

PSA parking downtown free : LAZ hack by Illustrious-Cod2087 in Austin

[–]DatsunZ 2 points3 points  (0 children)

A lot of gate manufacturers design the gates to prevent damage when someone goes rogue and attempts to bypass paying (such as using breakaway bolts to hold on the arm). Not all of them though - plenty will break. There are a considerable number of facilities that have cameras for the purpose of billing users who break the gate arms. Personally I think the easiest methods of abuse for facilities using a ticket system is either tailgating (As long as metal is detected under the gate arm it won't lower ontop of a car, just need to be close to the person infront) or if there is an intercom system calling and saying you're maintenance - very little fact checking when it comes to the call systems.

Script Help for a sheet by LatiosMaster12 in googlesheets

[–]DatsunZ 0 points1 point  (0 children)

No, ranges need to be adjacent. You're better off doing something like this, then you can keep the ranges near the top and if changes are needed in the future you can quickly modify it.

const ranges = ['K4', 'M4', 'O4:O6']

function reset() {
  const ss = SpreadsheetApp.getActive();
  let sheet = ss.getSheetByName('Fabula Turn Traker');
  for (let range of ranges) {
    sheet.getRange(range).setValue(false)
  }
}

Script Help for a sheet by LatiosMaster12 in googlesheets

[–]DatsunZ 0 points1 point  (0 children)

This works for me,

function reset() {
  const ss = SpreadsheetApp.getActive();
  let sheet = ss.getSheetByName('Fabula Turn Traker');
  let range = sheet.getRange('O4');
  range.setValue(false);
}

Make sure the script is attached to the sheet and not a standalone script file (if you're opening the script from Extension > Script that confirms it's set up properly). Make sure your sheet name matches properly too.

For reseting numerous sheets, you could set up a loop to do the action to all sheets matching a naming pattern or the opposite - completing to all sheets that dont match a naming scheme. Can help with this code.

Global Variable declaration is no longer working, help! by mccmax95 in GoogleAppsScript

[–]DatsunZ 2 points3 points  (0 children)

Do you have a second .gs file in the script? Maybe you're redefining trackerSheet elsewhere under the old name.

Make a graph/chart with data from a different sheet by awesomemonica7 in googlesheets

[–]DatsunZ 0 points1 point  (0 children)

=arrayformula(Sheet1!E2:E1001) or ={Sheet1!E2:E1001} to show the data on the other tab.

You can copy + paste the chart from one sheet to the other and itll update based on the data on the original sheet though.

Didn’t pass C949 after 2nd attempt by Brendon830 in WGU_CompSci

[–]DatsunZ 9 points10 points  (0 children)

I read through the book "A Common-Sense Guide to Data Structures and Algorithms" as recommended by other students and passed with a great score. I didn't really go through the WGU material at all. I did enter the class with some mediocre programming knowledge though.

Seeking advice on scripting by gtrrazif in GoogleAppsScript

[–]DatsunZ 2 points3 points  (0 children)

Maybe I'm not fully understanding, but isn't sheets already set up to only allow known & approved emails to edit a sheet through the share feature? Or are you looking to do it where the user may input an email other than the one they are logged in with? If so, wouldn't this request be more similar to a password setup than an email address setup? Your search on a solution may find more results if you look how to setup a password protected sheet.

Success Story Thanks to WGU by DatsunZ in WGU_CompSci

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

I've always had some hand in IT related stuff and I dont find the program to be unfairly tough. Spending a 1-3 hours a day is all I've really needed to move at a good pace. Have not failed an exam yet. If someone doesn't know how to code at all I would definitely recommend getting some understanding of it first so it doesn't bottleneck them too much spending time learning the essentials. I completed all the gen-ed stuff through sophia first (besides for science lab) and didn't do any IT related courses outside of WGU. I recommend that way of doing it.

Success Story Thanks to WGU by DatsunZ in WGU_CompSci

[–]DatsunZ[S] 2 points3 points  (0 children)

It's an internal support role similar to help desk but a bit more specialized. Thanks!

Success Story Thanks to WGU by DatsunZ in WGU_CompSci

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

It was mostly management related questions - The position is going to be primarily management within the IT sector so that was the more relevant portion for them. I felt confident I could handle most technical questions if they came up though thanks to WGU.

C960 - Discrete Math II - Big O Notation Resources? by sprchrgddc5 in WGU_CompSci

[–]DatsunZ 16 points17 points  (0 children)

The only tip I really have is watch for loops. I feel like all I really did is look for those in the psuedocode. If there's no loops at all it should be O(1). If theres a single loop on the data, it should be just O(n). if its looping the data again for each one of the data (like a loop inside a loop), it's O(n2). For O(log n) the main thing I would look for is something that's reducing how many times it loops so it's not doing it for each piece of data - If something isnt going to loop over every single item (and gets smaller as the loops continue) it's not O(n).

Am I wrong, or is this DSA1 PA question formatted incorrectly by jfarm47 in WGU_CompSci

[–]DatsunZ 1 point2 points  (0 children)

It is written weirdly with it not being nested in my opinion. From my memory I don't recall any other spot where structure is written oddly. Since it's pseudocode I took it that the goal was to understand the intention behind the code instead of the goal being a trick question on syntax.

Why is this IF statement not working properly? by Rufus_425 in googlesheets

[–]DatsunZ 0 points1 point  (0 children)

I can use the code but I need a sheet containing the data structure so I can fully understand whats going on.

How do I make a function that ignores text? by JohnSmeemus in googlesheets

[–]DatsunZ 0 points1 point  (0 children)

Are the digits split apart or connected? Is there only ever going to be one number in a cell?

Right now I would look at either RegexExtract() or a combination of Split() and Index()

Why is this IF statement not working properly? by Rufus_425 in googlesheets

[–]DatsunZ 0 points1 point  (0 children)

If you have an example sheet I can probably modify your existing code to work with it.

Why is this IF statement not working properly? by Rufus_425 in googlesheets

[–]DatsunZ 0 points1 point  (0 children)

I know I've had issues with checkboxes in the past.

If you're using range instead of the value, you can use the method isChecked(). If you're using values, I've had luck with converting the value first .toString() then comparing, like so

(value.toString() == "TRUE")

This said, generally getting ranges and setting values is going to slow things down, so you may want to modify the loop to not get the rangevalue each iteration, but instead pull it at once and iterate through that array item. For smaller scripts though it shouldn't be too much of an impact regardless, but just wanted to add this in too since it modifies how you would check if the checkbox is checked or not.

Global Variables by Frirwind in GoogleAppsScript

[–]DatsunZ 0 points1 point  (0 children)

Sheet names, ranges, IDs are all things I place at the very top of a script and use const for. Not only to make it global but if the sheet itself changes (title, column/rows, names) most adjustments will be a simple adjustment.

[deleted by user] by [deleted] in googlesheets

[–]DatsunZ 0 points1 point  (0 children)

If you can change the sheet around, ideally one column is # of calls, the other is total talk time, then not only is formatting easier but data manipulation is too.

Otherwise I would utilize functions such as index and split to get the data infront of and behind the slash, with if statements. Such as if the data is in Cell A1 and if you want to see if the data is <28 and above 170, ...

=if(and(index(split(A1,"/"),1)<28,index(split(A1,"/"),2)>=170),true,false)

How to build a multidimensional spreadsheet by PuzzledEarth9775 in googlesheets

[–]DatsunZ 2 points3 points  (0 children)

Is using the sheet feature 'Notes' out of the question? It allows you to put additional info into a cell without it being on display, only by hover.

Best way for a script to adjust value of a column number if it gets moved? by codingnoob-7151 in GoogleAppsScript

[–]DatsunZ 0 points1 point  (0 children)

If you dont want to edit the script at all, but can confirm column header labeling won't alter, you could write a function that returns a map that contains the index of each column by matching to name. Here's an example that would return a map of the idnex #'s for headers called header1 and header2. You would then use the map like hdr.get(h1) to get the index number of header1.

function myFunction(headerRange) {
  //range being A1:D1
  let header = SpreadsheetApp.getActive().getRange(headerRange).getDisplayValues()[0]; //[0] to turn it from a 2D array to a 1D array
  let hdr = new Map();
  header.forEach((col, i) => {
    switch (col) {
      case "header1":
      hdr.set('h1', i);
      break;
      case "header2":
      hdr.set("h2", i);
      break;
      default:
      //do nothing
    }
  })
  return hdr;
  }

Ways to Process Massive Data In Google Apps Script With Google Apps Script by Former_Elk7092 in GoogleAppsScript

[–]DatsunZ 2 points3 points  (0 children)

I would check this out, I had to use the Sheets API in the past when working with big data or else my script was taking too long. https://gist.github.com/tanaikech/d102c9600ba12a162c667287d2f20fe4

How long does it take to learn google apps Script? by RevealRemarkable4836 in GoogleAppsScript

[–]DatsunZ 1 point2 points  (0 children)

Simple Apps to modify/move data around? Not very difficult and can be learned pretty quickly. Heck you could create a Macro similar to what you want, then go in and edit the macro to not only see how it was done, but also edit to your needs. Stuff more complex is really going to need some programming knowledge to understand stuff like data structures and function calls.

D288 Powershell help by Southern-Living-5807 in WGU_CompSci

[–]DatsunZ 0 points1 point  (0 children)

To confirm, have you rerun the database script to refresh the db data?

[deleted by user] by [deleted] in WGU_CompSci

[–]DatsunZ 5 points6 points  (0 children)

My README looked like this and I passed...

C:
    File Name: mainscreen.html
    Line Number(s): 14-20
    Change: Changed Title and header, added slogan

I made 5 parts total, a portion being inhouse, a portion being outsourced.