256 Kilobytes

Scripting and Automation Answers

Type AnswersAsk and answer questions, if that is something that you want to do. Category Scripting and AutomationInformation and discussion of scripting of various types.

Profile Photo - Some Guy
Profile Photo - Univa

Last Reply A simple case that generates this error message: In [8]: [1,2,3,4,5][np.array([1])] --------------------------------------------------------------... Univa,

A simple case that genera...

Sat, 01 Jun 2019 09:14:49 -0700 1 month ago
🗨
1
🐏
0
👁
146
Profile Photo - Some Guy

[Google Sheets] Dollar sign usage? What does it do?

Answers in Spreadsheets | By Some Guy

Published 5 months agoWed, 06 Feb 2019 14:35:22 -0800

Profile Photo - Univa

Last Reply The $ is used in a cell reference to create an absolute reference. An absolute reference is one that will not change when the formula is copied. Th... Univa,

The $ is used in a cell r...

Fri, 31 May 2019 10:47:38 -0700 1 month ago
🗨
2
🐏
0
👁
139
Profile Photo - Some Guy
Profile Photo - Univa

Last Reply In case you get this error it might also be related to how you included the javascript file into your html page. When loading modules you have to expl... Univa,

In case you get this erro...

Sun, 26 May 2019 10:46:17 -0700 1 month ago
🗨
1
🐏
0
👁
133
Profile Photo - Whisky Fren
Profile Photo - Whisky Fren

Now I can use tab completion on my celeb...

MoreThe answer is that you're out of storage space. Possibly because of temporary files, but also possibly your hard drive is close to full. Or your serve...
🗨
0
🐏
0
👁
99
Profile Photo - Some Guy
Profile Photo - Univa

Last Reply Create sheets by clicking the "+" button at the bottom of your browser window. In Sheet1, type this formula into any cell in column A: =INDIRECT("... Univa,

Create sheets by clicking...

Thu, 16 May 2019 08:10:10 -0700 2 months ago
🗨
1
🐏
0
👁
124
Profile Photo - Some Guy
Profile Photo - Univa

Last Reply Run print(os.environ['PATH']) in the system terminal using the same interpreter Copy the result and add as a PATH environment variable to your Ru... Univa,

Sun, 05 May 2019 03:19:56 -0700 2 months ago
🗨
1
🐏
0
👁
166
Profile Photo - Some Guy
Profile Photo - Univa

Last Reply Typeerror This Constructor Takes No Arguments Python Error error codes are caused, in one way or another, by misconfigured system files in your Window... Univa,

Typeerror This Constructo...

Fri, 26 Apr 2019 08:18:20 -0700 2 months ago
🗨
1
🐏
0
👁
138
Profile Photo - Some Guy

How to use the Quick Analysis tool in Excel 2016?

Answers in Spreadsheets | By Some Guy

Published 7 months agoSun, 16 Dec 2018 09:31:51 -0800

Profile Photo - Univa

Last Reply Select the cells of data that you want to analyze Notice the Quick Analysis Tool icon that is displayed at the bottom of the data. Click it Rol... Univa,

Mon, 22 Apr 2019 08:09:47 -0700 2 months ago
🗨
1
🐏
0
👁
140
Profile Photo - Some Guy

Finding outliers in Excel?

Answers in Spreadsheets | By Some Guy

Published 7 months agoSun, 16 Dec 2018 09:37:00 -0800

Profile Photo - Univa

Last Reply By using Box and Whisker charts, you can easily identify outliers of your data, and it shows you where the data lies in and outside your inner quartil... Univa,

By using Box and Whisker...

Mon, 22 Apr 2019 07:37:10 -0700 2 months ago
🗨
1
🐏
0
👁
114
Profile Photo - Some Guy

How to round number to nearest 5 in Excel?

Answers in Spreadsheets | By Some Guy

Published 7 months agoSun, 16 Dec 2018 09:35:18 -0800

Profile Photo - Univa

Last Reply For rounding numbers to the nearest 5, you can use the formula =MROUND(number,5) Let's take an example that in cell B contains number 17 in Row 6 a... Univa,

For rounding numbers to t...

Sat, 20 Apr 2019 09:03:37 -0700 2 months ago
🗨
1
🐏
0
👁
135
Profile Photo - Some Guy
Profile Photo - August R. Garcia

Last Reply dhcpd.conf Should be located at: /etc/dhcp/dhcpd.conf August R. Garcia,

dhcpd.conf

Wed, 17 Apr 2019 17:25:05 -0700 2 months ago
🗨
1
🐏
0
👁
136
Profile Photo - Some Guy

How to split cells in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 7 months agoSun, 16 Dec 2018 09:33:30 -0800

Profile Photo - Univa

Last Reply In Google Sheets, paste your data into a column. You’ll see a little clipboard icon appear in the lower right-hand corner of your data. Click on... Univa,

In Google Sheets, paste y...

Tue, 16 Apr 2019 07:58:40 -0700 3 months ago
🗨
1
🐏
0
👁
118
Profile Photo - Some Guy
Profile Photo - Univa

Last Reply Before posting any codes try using the formatting tools, sometimes it solves the problem.  You can also try pasting this code:  a_str,... Univa,

Before posting any codes...

Sun, 14 Apr 2019 03:06:36 -0700 3 months ago
🗨
1
🐏
0
👁
185
Profile Photo - Some Guy

[Python] Fix for "TypeError: 'bool' object is not iterable?"

Answers in Scripting and Automation | By Some Guy

Published 6 months agoSun, 13 Jan 2019 05:39:20 -0800

Profile Photo - August R. Garcia

Last Reply You probably have your code set up where some value can either be: An array (or whatever) or FALSE (for when there are no values) Th... August R. Garcia,

You probably have your&nb...

Sun, 07 Apr 2019 12:14:43 -0700 3 months ago
🗨
1
🐏
0
👁
543
Profile Photo - Some Guy

How to find and replace in Excel?

Answers in Spreadsheets | By Some Guy

Published 7 months agoSun, 16 Dec 2018 09:43:56 -0800

Profile Photo - roxblade

Last Reply Go to the Home tab on the ribbon. Here, click on the Find and Select button. In the drop-down that appears, choose Replace. Find and Replace was al... roxblade,

Go to the Home tab on the...

Thu, 04 Apr 2019 04:37:24 -0700 3 months ago
🗨
1
🐏
0
👁
131
Profile Photo - Some Guy

A good Gauss-Jordan calculator?

Answers in Scripting and Automation | By Some Guy

Published 5 months agoWed, 06 Feb 2019 13:47:58 -0800

Profile Photo - Vrawler119

Last Reply Not sure if you want to carry an actual calculator around with you on the job but if you're interested in the Gauss-Jordan calculator app from Amazon... Vrawler119,

Not sure if you want to c...

Sat, 30 Mar 2019 15:52:58 -0700 3 months ago
🗨
1
🐏
0
👁
113
Profile Photo - Some Guy

How to install RetroArch on SNES Classic?

Answers in Machine Learning | By Some Guy

Published 5 months agoWed, 06 Feb 2019 16:08:41 -0800

Profile Photo - thegstocersson

Last Reply I looked at different pages trying to figure out which one was best to send you too. The following page should answer your questions and get RetroArch... thegstocersson,

I looked at different pag...

Sat, 30 Mar 2019 14:55:55 -0700 3 months ago
🗨
1
🐏
0
👁
149
Profile Photo - Some Guy

How to copy formulas in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 5 months agoWed, 06 Feb 2019 14:50:14 -0800

Profile Photo - KacssPL

Last Reply Select the cell you would want to copy from the formula and select edit on the toolbar. Once selected navigate to copy and you can then paste the form... KacssPL,

Select the cell you would...

Sat, 30 Mar 2019 14:37:55 -0700 3 months ago
🗨
1
🐏
0
👁
127
Profile Photo - Some Guy
Profile Photo - masshoIe3

Last Reply Range () returns the values in a limited list, and is an iterable. Xrange is a generator. Xrange can handle a huge list and uses the process of 'yield... masshoIe3,

Range () returns the valu...

Sat, 30 Mar 2019 14:25:29 -0700 3 months ago
🗨
1
🐏
0
👁
100
Profile Photo - Some Guy

Where do I find a good pool volume calculator?

Answers in Scripting and Automation | By Some Guy

Published 5 months agoWed, 06 Feb 2019 13:47:48 -0800

Profile Photo - krobidson_3232

Last Reply There are multiple places that you can find a a good pool volume calculator. I found the best option with the most details is hosted at www.swimmingpo... krobidson_3232,

There are multiple places...

Sat, 30 Mar 2019 14:11:29 -0700 3 months ago
🗨
1
🐏
0
👁
104
Profile Photo - Some Guy

How to fix content file locked?

Answers in Machine Learning | By Some Guy

Published 5 months agoWed, 06 Feb 2019 16:08:21 -0800

Profile Photo - Zhaybib

Last Reply Since you are trying to understand why the content file is locked, check out this Reddit discussion right here, https://www.reddit.com/r/Steam/comment... Zhaybib,

Since you are trying to u...

Sat, 30 Mar 2019 13:59:47 -0700 3 months ago
🗨
1
🐏
0
👁
132
Profile Photo - Some Guy
Profile Photo - -alxl_

Last Reply Having these error messages come up can be frustrating to work with. Without seeing specifics/knowing more of the spreadsheet you deal with it can be... -alxl_,

Having these error messag...

Sat, 30 Mar 2019 13:46:47 -0700 3 months ago
🗨
1
🐏
0
👁
193
Profile Photo - Some Guy

How to print without a newline in Python?

Answers in Scripting and Automation | By Some Guy

Published 5 months agoWed, 06 Feb 2019 13:47:28 -0800

Profile Photo - Zhaybib

Last Reply Since you say that you are curious as to how to print without a newline in Python, I suggest that you look here, https://stackoverflow.com/questions/4... Zhaybib,

Since you say that you ar...

Sat, 30 Mar 2019 13:39:40 -0700 3 months ago
🗨
1
🐏
0
👁
80
Profile Photo - Some Guy

How to apply a formula to an entire column in Excel?

Answers in Spreadsheets | By Some Guy

Published 7 months agoSun, 16 Dec 2018 09:37:55 -0800

Profile Photo - Univa

Last Reply Follow the steps below to apply the formula quickly to entire rows or columns in Excel. METHOD 1: Drag the fill handle to copy the formula In... Univa,

Follow the steps below to...

Wed, 27 Mar 2019 11:41:15 -0700 3 months ago
🗨
1
🐏
0
👁
109
Profile Photo - Some Guy

How to tab in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 5 months agoWed, 06 Feb 2019 15:02:45 -0800

Profile Photo - roxblade

Last Reply I believe you mean another sheet, right? On the bottom of the screen, you will find a bar that houses your sheet on the left. Further left and, in fac... roxblade,

I believe you mean anothe...

Thu, 21 Mar 2019 01:07:37 -0700 3 months ago
🗨
1
🐏
0
👁
123
Profile Photo - Twostntle
Profile Photo - entrokamoI

Last Reply ls isn't actually a built-in for Windows. It's a command meant to be used on Unix machines such as those running MacOS or Linux. If you want to achiev... entrokamoI,

ls isn't actually a built...

Wed, 20 Mar 2019 17:33:24 -0700 3 months ago
🗨
1
🐏
0
👁
101
Profile Photo - NelsAmmo

Best PowerShell scripting tutorials?

Answers in Shell Scripting | By NelsAmmo

Published 3 months agoTue, 19 Mar 2019 15:12:54 -0700

Profile Photo - Japanese

Last Reply Since this was developed by Microsoft in 2003, it makes sense to start with Microsoft tutorials. Microsoft Virtual Academy (MVA) has many tutorials on... Japanese,

Since this was developed...

Wed, 20 Mar 2019 14:25:13 -0700 3 months ago
🗨
1
🐏
0
👁
102
Profile Photo - sewlaw

What Bash scripting keyword terminates a case statement?

Answers in Shell Scripting | By sewlaw

Published 3 months agoTue, 19 Mar 2019 02:09:14 -0700

Profile Photo - Edgelady43069

Last Reply The Base scripting keyword that terminates a case statement is esac to end a case statement. Which is actually case spelled backwards. Edgelady43069,

The Base scripting keywor...

Wed, 20 Mar 2019 06:10:44 -0700 3 months ago
🗨
1
🐏
0
👁
95
Profile Photo - pls_stop_this

How do you know whether a PowerShell tutorial is good or not?

Answers in Shell Scripting | By pls_stop_this

Published 3 months agoTue, 19 Mar 2019 15:07:00 -0700

Profile Photo - Zhaybib

Last Reply Many people who are interested in learning PowerShell, will seek out a tutorial on the internet to help. Not all tutorials are created equal, but I wo... Zhaybib,

Many people who are inter...

Wed, 20 Mar 2019 05:10:56 -0700 3 months ago
🗨
1
🐏
0
👁
77
Profile Photo - SMVVR2

Best way to rename part of filename in multiple files?

Answers in Scripting and Automation | By SMVVR2

Published 3 months agoTue, 19 Mar 2019 07:05:20 -0700

Profile Photo - Edgelady43069

Last Reply This is the easiest and quickest way: 1. Open File Explorer. 2. Browse to the folder that includes all the files you want to rename. 3. Select the fir... Edgelady43069,

This is the easiest and q...

Wed, 20 Mar 2019 02:02:20 -0700 3 months ago
🗨
1
🐏
0
👁
99