spreadsheet | Google Go library for reading and writing | Data Visualization library

I have a spreadsheet for inserting values of scores of different teams. Column A has the team names and column B has their scores. The same goes for column C and D. There are 10 teams with 5 in Column A and C. My goal is to code when you enter a score for a team it goes two to the right and when you enter that value, it goes down one and left two. I had that working before, but I had to implement one more thing, and it stopped working. I had to implement that when an invalid score is entered, a non-number, negative number, etc. it would delete itself. I am not sure what I did wrong or what may have led me in the wrong direction.

Here's What I Have

It is the first time I am using Google sheet and I need to sort tables from two differents sheets. I want to keep only the ref that don't have a grade of A

here is a link in google sheet https://docs.google.com/spreadsheets/d/1quXkNuSYPF7MCs7_PGzjHKOLDf0TSvPqlEumNCWc0lc/edit?usp=sharing

February '22

March '22

Expected result (comparison between Feb and March)

Thanks for helping

I have started to create a form with Apps Script, using materializecss to create a menu with 3 different layouts.

1. when I embed my URL to the New Google Sites, it doesn't use the layout (modal), I need to know how to select one of the 3 sidebar options.
2. After submit, the form data is posted to the spreadsheet, but it doesn't redirect to a different page.
3. it seems it will redirect without validating data, the if sentence is not connected to the redirect function.

What is the equivalent of header=0 in pandas, which recognises the first line as a heading in gspread?

pandas import statement (correct)

I've been doing a good amount of research on AMD64 (x86-64) instructions, and its been kind of confusing. A lot of the time official CPU documentation doesn't designate instruction as part of a specific set, and the internet is sometimes split on which instruction set a specific instruction belongs to. One example of this is SFENCE, with some sources claiming that it's part of EMMX and others claiming it's part of SSE.

I'm trying to organize all of them in a spreadsheet to help with learning, but these inconsistencies are incredibly frustrating in a field that is famously technical and precise.

I have an app that opens the json version of a spreadsheet that I've published to the web. I used the instructions on this website: https://www.freecodecamp.org/news/cjn-google-sheets-as-json-endpoint/

It's been working fine for a couple months, but today I realized that the url of my json file is no longer working since yesterday. It gives the message, "Sorry, unable to open the file at this time. Please check the address and try again." The regular link to view the spreadsheet as a webpage still works though.

Did Google drop support for this feature? Is there another way to get the data of a spreadsheet in json format through a URL? I started looking into the Google Developer API, but it was really confusing.

In a spreadsheet, I am trying to somehow make it so any new numerical value that gets inputted into a cell in column D to multiply by 85%. Basically, if I go to any cell 2-100,000 in column D and input a numerical value, I want it to automatically show 85% of it.

If I input '100' into D5, I want it to show '85'.

If I input '200' into D317, I want it to show '170'.

Is this possible to do in any way?

Manually multiplying by another cell or by 0.85 can't be used.

Thank you so much!

I have some go code that opens a spreadsheet and for each row, uses a lanid in the row to lookup some data. I would like to add this derived data as two new columns in the sheet.

Opening the sheet and looping over all the rows works fine. I just can't figure out how to add the new columns. Any suggestions welcome.

The code below throws an error of

panic: runtime error: index out of range [7] with length 7

like the columns haven't been added.

Macros on my spreadsheet that have been working for years, stopped working via buttons, though they still work from the VBA Developer window.

I use a normal shape (rectangle) as the button and assigned the macro to it (selecting from "ThisWorkbook").

To head off suggested fixes I've seen for other similar posts:

• It is still an .xlsm file
• Macros are still enabled.
• It's running on the same laptop as before (Windows 10, Office 365).
• No Windows updates have occurred lately.
• I only have this one file open.
• I tried rebooting laptop and restarting Excel.
• I'm not using an Active-X Control.
• I tried it with a Form Control button and a regular Shape button - neither work.
• It's not related to the actual VBA code (see below for proof).

I created a new program to show the problem is not the code itself: