Renee Brooks - User contributions [en]

Paper Making

2023-05-07T15:08:31Z

Wikimaster: Created page with "== Goals == {| class="wikitable" |+ !Goal # !Description |- |1 |Use Paper Making to help reduce paper waste and to help make paper for more notebooks or sketchbooks. |- |2 |Help me to digitize everything I have to be able to access it from anywhere |} == Tools Necessary == {| class="wikitable" |+ !Tool !Status !Description !Estimated Cost |- |Picture Frames (Various Sizes) |Need to Purchase |I need 2x sets of each frame size so I can make 8.5 x 11 and 5 x 7 paper |$5-$1..."

== Goals ==
{| class="wikitable"
|+
!Goal #
!Description
|-
|1
|Use Paper Making to help reduce paper waste and to help make paper for more notebooks or sketchbooks.
|-
|2
|Help me to digitize everything I have to be able to access it from anywhere
|}

== Tools Necessary ==
{| class="wikitable"
|+
!Tool
!Status
!Description
!Estimated Cost
|-
|Picture Frames (Various Sizes)
|Need to Purchase
|I need 2x sets of each frame size so I can make 8.5 x 11 and 5 x 7 paper
|$5-$10
|-
|Screen Material
|Need to Purchase
|I need just enough screen material to cover one of each frame
|$10
|-
|Plastic Tub
|Need to Purchase
|I just need something that can hold the pulp suspended in the water
|$5
|-
|Blender
|Need to Purchase
|I need a blender just dedicated to blending the paper - not for foodstuffs
|$5-$15 Used
|-
|Paper Shredder
|Currently Own
|I have a standard paper shredder but it isnt a cross cut shredder so it will still leave the strips to be rather long
|$0
|-
|Scrap/Discarded Paper
|Currently Own
|I have a slew of scrap paper that I could repurpose to make my own paper
|$0
|}

Main Page

2023-05-07T14:39:45Z

Wikimaster: /* Crafts */

Welcome to the Renee Brooks Wiki. This is probably going to be a bit overkill, but I want to create a huge repository of everything that is mine that I care about. So without further adieu, let's get this wiki started!

== [[:Category:Google Sheets|Google Sheets]] ==
{| class="wikitable"
|+
!Link
!Description
|-
|[[Highlight Row Based on Cell Value]]
|When you have a table in Google Sheets, there are times that once a cell value has a specific value, you want the entire row to be highlighted with conditional formatting.
|-
|[[List Sheet Names and URLs for Each Sheet]]
|When you have multiple sheets in one Google Sheet Spreadsheet, this Google Scripts code will make a list of all of the sheets in this spreadsheet and the second code lists out the URLs for each tab to help make navigation easier.
|-
|[[Trimming Characters from Text String]]
|Sometimes, the data you get has junk to the right, left, or middle of what you really want out of the data. Use these to help you get the text you need.
|}

== IT How To ==
{| class="wikitable sortable mw-collapsible"
|+
!How To Documents
|-
|[[HL-2360DW Brother Laser Printer|Printer Setup]]
|-
|[[Creating Websites]]
|}

== Crafts ==
[[Paper Making]]

[[Linocut]]

[[Sticker/Decal Making]]

MediaWiki has been installed.

Consult the [https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents User's Guide] for information on using the wiki software.

== Getting started ==
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Configuration_settings Configuration settings list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:FAQ MediaWiki FAQ]
* [https://lists.wikimedia.org/postorius/lists/mediawiki-announce.lists.wikimedia.org/ MediaWiki release mailing list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Localisation#Translation_resources Localise MediaWiki for your language]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Combating_spam Learn how to combat spam on your wiki]

Main Page

2023-05-07T14:39:14Z

Wikimaster: /* Google Sheets */

Welcome to the Renee Brooks Wiki. This is probably going to be a bit overkill, but I want to create a huge repository of everything that is mine that I care about. So without further adieu, let's get this wiki started!

== [[:Category:Google Sheets|Google Sheets]] ==
{| class="wikitable"
|+
!Link
!Description
|-
|[[Highlight Row Based on Cell Value]]
|When you have a table in Google Sheets, there are times that once a cell value has a specific value, you want the entire row to be highlighted with conditional formatting.
|-
|[[List Sheet Names and URLs for Each Sheet]]
|When you have multiple sheets in one Google Sheet Spreadsheet, this Google Scripts code will make a list of all of the sheets in this spreadsheet and the second code lists out the URLs for each tab to help make navigation easier.
|-
|[[Trimming Characters from Text String]]
|Sometimes, the data you get has junk to the right, left, or middle of what you really want out of the data. Use these to help you get the text you need.
|}

== IT How To ==
{| class="wikitable sortable mw-collapsible"
|+
!How To Documents
|-
|[[HL-2360DW Brother Laser Printer|Printer Setup]]
|-
|[[Creating Websites]]
|}

== Crafts ==
[[Paper Making]][[Linocut]][[Sticker/Decal Making]]

MediaWiki has been installed.

Consult the [https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents User's Guide] for information on using the wiki software.

== Getting started ==
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Configuration_settings Configuration settings list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:FAQ MediaWiki FAQ]
* [https://lists.wikimedia.org/postorius/lists/mediawiki-announce.lists.wikimedia.org/ MediaWiki release mailing list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Localisation#Translation_resources Localise MediaWiki for your language]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Combating_spam Learn how to combat spam on your wiki]

Creating Websites

2023-03-22T02:03:19Z

Wikimaster: /* Adding Google Analytics to Website */

=== How to Add a New Website to In Motion Hosting ===
When creating a website on In Motion Hosting - do not start with a subdomain. Go to addon domains and add the website there.

=== Adding Google Analytics to Website ===

# Log into Google Analytics
# Go to Admin Section in Bottom Left Hand Corner
# Click "Create Property"
# Give the property a name and create the Property
# Choose Web as the Data Stream and enter in the website URL and create the stream
# It will load into the Google Tag section, copy the Manual Tag located on the other section
# Go to your website and log into the WP-Admin
# Go to plugins and install/activate WP Code Snippets by WP Code
# Go to the Header/Footer section of the plugin and paste the Google Tag into the header

=== How to Increase SEO for SmallBusinessandSundry.com Posts ===

# Create Title for Page
# Write at least 500 words of content for the blog post
# Review your content and scroll down to the EasySEO section and put the Target Keywork or Phrase that you are hoping to use to pull up this post.
# Then add in the post title in the Title section and put in a small description that will appear on Google when someone searches for your content
# Add in a relevant featured image
# Choose or Create an applicable category to organize the post
# Create tags that can also assist in organizing the content.

Main Page

2023-03-22T00:38:29Z

Wikimaster: /* IT How To */

Welcome to the Renee Brooks Wiki. This is probably going to be a bit overkill, but I want to create a huge repository of everything that is mine that I care about. So without further adieu, let's get this wiki started!

== [[:Category:Google Sheets|Google Sheets]] ==
{| class="wikitable"
|+
!Link
!Description
|-
|[[Highlight Row Based on Cell Value]]
|When you have a table in Google Sheets, there are times that once a cell value has a specific value, you want the entire row to be highlighted with conditional formatting.
|-
|[[List Sheet Names and URLs for Each Sheet]]
|When you have multiple sheets in one Google Sheet Spreadsheet, this Google Scripts code will make a list of all of the sheets in this spreadsheet and the second code lists out the URLs for each tab to help make navigation easier.
|-
|[[Trimming Characters from Text String]]
|Sometimes, the data you get has junk to the right, left, or middle of what you really want out of the data. Use these to help you get the text you need.
|}

== IT How To ==
{| class="wikitable sortable mw-collapsible"
|+
!How To Documents
|-
|[[HL-2360DW Brother Laser Printer|Printer Setup]]
|-
|[[Creating Websites]]
|-
|
|}

MediaWiki has been installed.

Consult the [https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents User's Guide] for information on using the wiki software.

== Getting started ==
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Configuration_settings Configuration settings list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:FAQ MediaWiki FAQ]
* [https://lists.wikimedia.org/postorius/lists/mediawiki-announce.lists.wikimedia.org/ MediaWiki release mailing list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Localisation#Translation_resources Localise MediaWiki for your language]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Combating_spam Learn how to combat spam on your wiki]

Main Page

2023-03-21T23:31:47Z

Wikimaster: /* IT How To */

Welcome to the Renee Brooks Wiki. This is probably going to be a bit overkill, but I want to create a huge repository of everything that is mine that I care about. So without further adieu, let's get this wiki started!

== [[:Category:Google Sheets|Google Sheets]] ==
{| class="wikitable"
|+
!Link
!Description
|-
|[[Highlight Row Based on Cell Value]]
|When you have a table in Google Sheets, there are times that once a cell value has a specific value, you want the entire row to be highlighted with conditional formatting.
|-
|[[List Sheet Names and URLs for Each Sheet]]
|When you have multiple sheets in one Google Sheet Spreadsheet, this Google Scripts code will make a list of all of the sheets in this spreadsheet and the second code lists out the URLs for each tab to help make navigation easier.
|-
|[[Trimming Characters from Text String]]
|Sometimes, the data you get has junk to the right, left, or middle of what you really want out of the data. Use these to help you get the text you need.
|}

== IT How To ==
{| class="wikitable sortable mw-collapsible"
|+
!How To Documents
|-
|[[HL-2360DW Brother Laser Printer|Printer Setup]]
|-
|[[Creating Websites]]
|-
|
|}

<iframe src="https://docs.google.com/spreadsheets/d/e/2PACX-1vTW6bmFbXVJg7vEpzyVVSps0MD2B1NYAiiTsf_-0ASAyJPKahPn3osWpcY8XwZklbEpQMCtlkEwvQuT/pubhtml?widget=true&amp;headers=false"></iframe>

MediaWiki has been installed.

Consult the [https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents User's Guide] for information on using the wiki software.

== Getting started ==
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Configuration_settings Configuration settings list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:FAQ MediaWiki FAQ]
* [https://lists.wikimedia.org/postorius/lists/mediawiki-announce.lists.wikimedia.org/ MediaWiki release mailing list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Localisation#Translation_resources Localise MediaWiki for your language]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Combating_spam Learn how to combat spam on your wiki]

Creating Websites

2023-03-20T00:20:09Z

Wikimaster:

When creating a website on InMotionHosting - do not start with a subdomain. Go to addon domains and add the website there.

=== Adding Google Analytics to Website ===

# Log into Google Analytics
# Go to Admin Section in Bottom Left Hand Corner
# Click "Create Property"
# Give the property a name and create the Property
# Choose Web as the Data Stream and enter in the website URL and create the stream
# It will load into the Google Tag section, copy the Manual Tag located on the other section
# Go to your website and log into the WP-Admin
# Go to plugins and install/activate WP Code Snippets by WP Code
# Go to the Header/Footer section of the plugin and paste the Google Tag into the header

User:Wikimaster

2023-03-19T16:19:39Z

Wikimaster:

[[File:Renee-Profile Picture.png|thumb|Renee Brooks]]

=== Introduction ===
Alias: Wikimaster

Name: Renee Lazuli Brooks

Bio: Renee is a weird 30 something non-binary individual living in West Virginia who decided they wanted a wiki about everything they knew. Rather than having to Google everything over and over for the things they retrieve an a continuous basis, a wiki sounded like a great idea to store everything in a non-clunky system.

=== Small Business and Sundry LLC (SB&S) ===
[[File:SB&S.png|thumb|Small Business and Sundry LLC (SB&S) Logo]]
Renee has a small business called [https://www.smallbusinessandsundry.com/ Small Business and Sundry LLC] (SB&S) where they work with small businesses in order to find low cost ways in order to promote their business. The overall and lofty goal of SB&S is to make West Virginia the Small Business Capitol of the World to help people achieve their dreams and to have everyone do what they want to do.

=== Worry Whale Co ===
Renee has also filed for a DBA under Small Business and Sundry LLC to create Worry Whale Co. My personal dream is to have a successful sticker store that replaces my need for a day job. While still in the infant stages, this is my most proud venture yet.

User:Wikimaster

2023-03-19T16:17:29Z

Wikimaster:

[[File:Renee-Profile Picture.png|thumb|Renee Brooks|left]]

=== Introduction ===
Alias: Wikimaster

Name: Renee Lazuli Brooks

Bio: Renee is a weird 30 something non-binary individual living in West Virginia who decided they wanted a wiki about everything they knew. Rather than having to Google everything over and over for the things they retrieve an a continuous basis, a wiki sounded like a great idea to store everything in a non-clunky system.

=== Small Business and Sundry LLC (SB&S) ===
[[File:SB&S.png|thumb|Small Business and Sundry LLC (SB&S) Logo]]
Renee has a small business called [https://www.smallbusinessandsundry.com/ Small Business and Sundry LLC] (SB&S) where they work with small businesses in order to find low cost ways in order to promote their business. The overall and lofty goal of SB&S is to make West Virginia the Small Business Capitol of the World to help people achieve their dreams and to have everyone do what they want to do.

=== Worry Whale Co ===
Renee has also filed for a DBA under Small Business and Sundry LLC to create Worry Whale Co. My personal dream is to have a successful sticker store that replaces my need for a day job. While still in the infant stages, this is my most proud venture yet.

File:Renee-Profile Picture.png

2023-03-19T16:16:45Z

Wikimaster:

This is the profile picture for [[User:Wikimaster|Renee]], the owner of this wiki.

This is artwork that I commissioned from [https://twitter.com/gabechanwrk?s=20 @gabechanwrk] and it was the first commission I had ever requested from any artist. One of my Favorite Purchases ❤️

User:Wikimaster

2023-03-19T16:15:02Z

Wikimaster:

[[File:Renee-Profile Picture.png|thumb|Renee Brooks|left]]

Alias: Wikimaster

Name: Renee Lazuli Brooks

Bio: Renee is a weird 30 something non-binary individual living in West Virginia who decided they wanted a wiki about everything they knew. Rather than having to Google everything over and over for the things they retrieve an a continuous basis, a wiki sounded like a great idea to store everything in a non-clunky system.

=== Small Business and Sundry LLC (SB&S) ===
[[File:SB&S.png|thumb|Small Business and Sundry LLC (SB&S) Logo]]
Renee has a small business called [https://www.smallbusinessandsundry.com/ Small Business and Sundry LLC] (SB&S) where they work with small businesses in order to find low cost ways in order to promote their business. The overall and lofty goal of SB&S is to make West Virginia the Small Business Capitol of the World to help people achieve their dreams and to have everyone do what they want to do.

=== Worry Whale Co ===
Renee has also filed for a DBA under Small Business and Sundry LLC to create Worry Whale Co. My personal dream is to have a successful sticker store that replaces my need for a day job. While still in the infant stages, this is my most proud venture yet.

File:SB&S.png

2023-03-19T16:09:56Z

Wikimaster:

This is the logo for Small Business and Sundry LLC

MediaWiki:Sidebar

2023-03-19T14:47:44Z

Wikimaster:

* Navigation
** mainpage|mainpage-description
** recentchanges-url|recentchanges
** randompage-url|randompage
** helppage|help-mediawiki
* Quick Navigation
** Category:Google_Sheets|Google Sheets
* Special Pages
** https://www.wiki.reneebrooks.com/index.php?title=MediaWiki:Sidebar&action=edit|Edit Sidebar
** Special:BrokenRedirects|Broken Redirects
** Special:DoubleRedirects|Double Redirects
** Special:SpecialPages|All Special Pages
* SEARCH
* TOOLBOX
* LANGUAGES

MediaWiki:Sidebar

2023-03-19T14:46:50Z

Wikimaster:

MediaWiki:Sidebar

2023-03-19T14:46:11Z

Wikimaster:

Main Page

2023-03-19T14:37:22Z

Wikimaster:

Welcome to the Renee Brooks Wiki. This is probably going to be a bit overkill, but I want to create a huge repository of everything that is mine that I care about. So without further adieu, let's get this wiki started!

== [[:Category:Google Sheets|Google Sheets]] ==
{| class="wikitable"
|+
!Link
!Description
|-
|[[Highlight Row Based on Cell Value]]
|When you have a table in Google Sheets, there are times that once a cell value has a specific value, you want the entire row to be highlighted with conditional formatting.
|-
|[[List Sheet Names and URLs for Each Sheet]]
|When you have multiple sheets in one Google Sheet Spreadsheet, this Google Scripts code will make a list of all of the sheets in this spreadsheet and the second code lists out the URLs for each tab to help make navigation easier.
|-
|[[Trimming Characters from Text String]]
|Sometimes, the data you get has junk to the right, left, or middle of what you really want out of the data. Use these to help you get the text you need.
|}

== IT How To ==
{| class="wikitable sortable mw-collapsible"
|+
!How To Documents
|-
|[[HL-2360DW Brother Laser Printer|Printer Setup]]
|-
|[[Creating Websites]]
|-
|
|}
MediaWiki has been installed.

Consult the [https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents User's Guide] for information on using the wiki software.

== Getting started ==
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Configuration_settings Configuration settings list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:FAQ MediaWiki FAQ]
* [https://lists.wikimedia.org/postorius/lists/mediawiki-announce.lists.wikimedia.org/ MediaWiki release mailing list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Localisation#Translation_resources Localise MediaWiki for your language]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Combating_spam Learn how to combat spam on your wiki]

HL-2360DW Brother Laser Printer

2023-03-19T14:35:11Z

Wikimaster: Wikimaster moved page Printer Setup to HL-2360DW Brother Laser Printer

[[File:HL-2360DW Brother Printer.jpg|thumb|HL-2360DW Brother Laser Printer - Image Courtesy of Brother Industries Ltd.]]
# Ensure your computer is connected to the network.
#Navigate to https://support.brother.com/g/b/downloadtop.aspx?c=us&lang=en&prod=hll2360dw_us
#Select the Operating System and version of your computer.
#Download the full software package and install the drivers.
##[[File:Full Software Version.png|none|thumb|329x329px]]
#Once the drivers are installed, return to the download page and install the Network Connection Repair Tool
##[[File:Network Connection Repair Tool.png|none|thumb]]
#Run the Network Connection Repair Tool and it should add and connect to the printer automatically.
#Print a Test Page

{{DEFAULTSORT:Printer_Test}}

Main Page

2023-03-19T14:17:13Z

Wikimaster: /* IT How To */

Welcome to the Renee Brooks Wiki. This is probably going to be a bit overkill, but I want to create a huge repository of everything that is mine that I care about. So without further adieu, let's get this wiki started!

== [[:Category:Google Sheets|Google Sheets]] ==
{| class="wikitable"
|+
!Link
!Description
|-
|[[Highlight Row Based on Cell Value]]
|When you have a table in Google Sheets, there are times that once a cell value has a specific value, you want the entire row to be highlighted with conditional formatting.
|-
|[[List Sheet Names and URLs for Each Sheet]]
|When you have multiple sheets in one Google Sheet Spreadsheet, this Google Scripts code will make a list of all of the sheets in this spreadsheet and the second code lists out the URLs for each tab to help make navigation easier.
|-
|[[Trimming Characters from Text String]]
|Sometimes, the data you get has junk to the right, left, or middle of what you really want out of the data. Use these to help you get the text you need.
|}

== IT How To ==
{| class="wikitable sortable mw-collapsible"
|+
!How To Documents
|-
|[[Printer Setup]]
|-
|[[Creating Websites]]
|-
|
|}
MediaWiki has been installed.

Consult the [https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents User's Guide] for information on using the wiki software.

== Getting started ==
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Configuration_settings Configuration settings list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:FAQ MediaWiki FAQ]
* [https://lists.wikimedia.org/postorius/lists/mediawiki-announce.lists.wikimedia.org/ MediaWiki release mailing list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Localisation#Translation_resources Localise MediaWiki for your language]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Combating_spam Learn how to combat spam on your wiki]

Creating Websites

2023-03-19T14:17:05Z

Wikimaster: Created page with "When creating a website on InMotionHosting - do not start with a subdomain. Go to addon domains and add the website there."

When creating a website on InMotionHosting - do not start with a subdomain. Go to addon domains and add the website there.

List Sheet Names and URLs for Each Sheet

2023-03-11T02:50:51Z

Wikimaster:

# Create a Google Sheet that has a ton of sheets
# Create a new Sheet that is left-most of all of the other sheets in the Google Sheet and name it <code>Index</code>
## If you wish to use something other than Index, you can change the Sheet Name to whatever you like, but in this code below, you will want to replace <code>Index</code> with what your desired sheet name is
## <code> var sh=ss.getSheetByName(''''Index'''<nowiki/>');</code>
# Insert the code below to the Scripts section and hit save
# Go back to the Google Sheets and refresh the file. In the menu you should get a new option called, "Sheets" and within that menu, there will be "List All Sheets" and "List All URLs". Click on each in order until you have the list of links

<code>function listSheets() {</code>

<code> var sheetNames = new Array();</code>

<code> var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();</code>

<code> var selectedSheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();</code>

<code> var selectedRow = selectedSheet.getActiveCell().getRow();</code>

<code> var selectedCol = selectedSheet.getActiveCell().getColumn();</code>

<code> var range = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getRange(selectedRow, selectedCol, sheets.length, 1);</code>

<code> for (var i = 0; i < sheets.length; i++) sheetNames.push([sheets[i].getName()]);</code>

<code> range.setValues(sheetNames);</code>

<code>}</code>

<code>function onOpen() {</code>

<code> SpreadsheetApp.getUi()</code>

<code> .createMenu('Sheets')</code>

<code> .addItem('List All Sheets', 'listSheets')</code>

<code> .addItem('List All URLS', 'listedSheetUrls')</code>

<code> .addToUi();</code>

<code>}</code>

<code>function mySheetName() {</code>

<code> var key = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getName();</code>

<code> return key;</code>

<code>}</code>

<code>function listedSheetUrls() {</code>

<code> var ss=SpreadsheetApp.getActive();</code>

<code> var sh=ss.getSheetByName('Index');</code>

<code> var rg=sh.getRange(1,1,sh.getLastRow(),1);</code>

<code> var vA=rg.getValues();</code>

<code> var nA=vA.map(function(r){return r[0];});</code>

<code> var shts=ss.getSheets();</code>

<code> shts.forEach(function(sh,i){</code>

<code> var idx=nA.indexOf(sh.getName());</code>

<code> if(idx!=-1) {</code>

<code> var url=Utilities.formatString('<nowiki>https://docs.google.com/spreadsheets/d/%s/edit#gid=%s',ss.getId(),sh.getSheetId())</nowiki>;</code>

<code> vA[idx].splice(1,0,url);</code>

<code> }</code>

<code> });</code>

<code> sh.getRange(1,1,vA.length,vA[0].length).setValues(vA);</code>

<code>}</code>
[[Category:Google Sheets]]

Category:Google Sheets

2023-03-11T02:50:45Z

Wikimaster:

This is my collection of all of the things that I have learned to do with Google Sheets. What an absolutely wicked cool system ❤️

Trimming Characters from Text String

2023-03-11T02:50:14Z

Wikimaster: Created page with "=== Basic String Manipulation === Left: Use this to get the x characters from the left side. <code>LEFT(string, extract length)</code> Right: Use this to get the x characters from the right side. <code>RIGHT(string, extract length)</code> Mid: Use this to get the x characters in the middle <code>MID(string, starting_at, extract_length)</code> Len: Use this to see how many characters are in a specific cell <code>LEN(text)</code> === Advanced String Manipulation..."

=== Basic String Manipulation ===
Left: Use this to get the x characters from the left side.

<code>LEFT(string, extract length)</code>

Right: Use this to get the x characters from the right side.

<code>RIGHT(string, extract length)</code>

Mid: Use this to get the x characters in the middle

<code>MID(string, starting_at, extract_length)</code>

Len: Use this to see how many characters are in a specific cell

<code>LEN(text)</code>

=== Advanced String Manipulation ===
Combining Mid and Len to get data that may not always be the same length due to unique data

<code>=MID(string,LEN(“Repeatable Phrase in String“),extract length)</code>

[[Category:Google Sheets]]

Main Page

2023-03-11T02:40:35Z

Wikimaster:

Welcome to the Renee Brooks Wiki. This is probably going to be a bit overkill, but I want to create a huge repository of everything that is mine that I care about. So without further adieu, let's get this wiki started!

== [[:Category:Google Sheets|Google Sheets]] ==
{| class="wikitable"
|+
!Link
!Description
|-
|[[Highlight Row Based on Cell Value]]
|When you have a table in Google Sheets, there are times that once a cell value has a specific value, you want the entire row to be highlighted with conditional formatting.
|-
|[[List Sheet Names and URLs for Each Sheet]]
|When you have multiple sheets in one Google Sheet Spreadsheet, this Google Scripts code will make a list of all of the sheets in this spreadsheet and the second code lists out the URLs for each tab to help make navigation easier.
|-
|[[Trimming Characters from Text String]]
|Sometimes, the data you get has junk to the right, left, or middle of what you really want out of the data. Use these to help you get the text you need.
|}

== IT How To ==
{| class="wikitable sortable mw-collapsible"
|+
!How To Documents
|-
|[[Printer Setup]]
|-
|
|-
|
|}
MediaWiki has been installed.

Consult the [https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents User's Guide] for information on using the wiki software.

== Getting started ==
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Configuration_settings Configuration settings list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:FAQ MediaWiki FAQ]
* [https://lists.wikimedia.org/postorius/lists/mediawiki-announce.lists.wikimedia.org/ MediaWiki release mailing list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Localisation#Translation_resources Localise MediaWiki for your language]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Combating_spam Learn how to combat spam on your wiki]

Main Page

2023-03-11T02:36:19Z

Wikimaster: /* Google Sheets */

Welcome to the Renee Brooks Wiki. This is probably going to be a bit overkill, but I want to create a huge repository of everything that is mine that I care about. So without further adieu, let's get this wiki started!

== [[:Category:Google Sheets|Google Sheets]] ==
{| class="wikitable"
|+
!Link
!Description
|-
|[[Highlight Row Based on Cell Value]]
|When you have a table in Google Sheets, there are times that once a cell value has a specific value, you want the entire row to be highlighted with conditional formatting.
|-
|[[List Sheet Names and URLs for Each Sheet]]
|When you have multiple sheets in one Google Sheet Spreadsheet, this Google Scripts code will make a list of all of the sheets in this spreadsheet and the second code lists out the URLs for each tab to help make navigation easier.
|-
|
|
|}

== IT How To ==
{| class="wikitable sortable mw-collapsible"
|+
!How To Documents
|-
|[[Printer Setup]]
|-
|
|-
|
|}
MediaWiki has been installed.

Consult the [https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents User's Guide] for information on using the wiki software.

== Getting started ==
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Configuration_settings Configuration settings list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:FAQ MediaWiki FAQ]
* [https://lists.wikimedia.org/postorius/lists/mediawiki-announce.lists.wikimedia.org/ MediaWiki release mailing list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Localisation#Translation_resources Localise MediaWiki for your language]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Combating_spam Learn how to combat spam on your wiki]

Category:Google Sheets

2023-03-11T02:35:37Z

Wikimaster:

[[Main Page]]

This is my collection of all of the things that I have learned to do with Google Sheets. What an absolutely wicked cool system ❤️

List Sheet Names and URLs for Each Sheet

2023-03-11T02:33:37Z

Wikimaster:

[[Main Page]]
# Create a Google Sheet that has a ton of sheets
# Create a new Sheet that is left-most of all of the other sheets in the Google Sheet and name it <code>Index</code>
## If you wish to use something other than Index, you can change the Sheet Name to whatever you like, but in this code below, you will want to replace <code>Index</code> with what your desired sheet name is
## <code> var sh=ss.getSheetByName(''''Index'''<nowiki/>');</code>
# Insert the code below to the Scripts section and hit save
# Go back to the Google Sheets and refresh the file. In the menu you should get a new option called, "Sheets" and within that menu, there will be "List All Sheets" and "List All URLs". Click on each in order until you have the list of links

<code>function listSheets() {</code>

<code> var sheetNames = new Array();</code>

<code> var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();</code>

<code> var selectedSheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();</code>

<code> var selectedRow = selectedSheet.getActiveCell().getRow();</code>

<code> var selectedCol = selectedSheet.getActiveCell().getColumn();</code>

<code> var range = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getRange(selectedRow, selectedCol, sheets.length, 1);</code>

<code> for (var i = 0; i < sheets.length; i++) sheetNames.push([sheets[i].getName()]);</code>

<code> range.setValues(sheetNames);</code>

<code>}</code>

<code>function onOpen() {</code>

<code> SpreadsheetApp.getUi()</code>

<code> .createMenu('Sheets')</code>

<code> .addItem('List All Sheets', 'listSheets')</code>

<code> .addItem('List All URLS', 'listedSheetUrls')</code>

<code> .addToUi();</code>

<code>}</code>

<code>function mySheetName() {</code>

<code> var key = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getName();</code>

<code> return key;</code>

<code>}</code>

<code>function listedSheetUrls() {</code>

<code> var ss=SpreadsheetApp.getActive();</code>

<code> var sh=ss.getSheetByName('Index');</code>

<code> var rg=sh.getRange(1,1,sh.getLastRow(),1);</code>

<code> var vA=rg.getValues();</code>

<code> var nA=vA.map(function(r){return r[0];});</code>

<code> var shts=ss.getSheets();</code>

<code> shts.forEach(function(sh,i){</code>

<code> var idx=nA.indexOf(sh.getName());</code>

<code> if(idx!=-1) {</code>

<code> var url=Utilities.formatString('<nowiki>https://docs.google.com/spreadsheets/d/%s/edit#gid=%s',ss.getId(),sh.getSheetId())</nowiki>;</code>

<code> vA[idx].splice(1,0,url);</code>

<code> }</code>

<code> });</code>

<code> sh.getRange(1,1,vA.length,vA[0].length).setValues(vA);</code>

<code>}</code>
[[Category:Google Sheets]]

Category:Google Sheets

2023-03-11T02:33:07Z

Wikimaster:

This is my collection of all of the things that I have learned to do with Google Sheets. What an absolutely wicked cool system ❤️

MediaWiki:Sidebar

2023-03-11T02:32:10Z

Wikimaster:

MediaWiki:Sidebar

2023-03-11T02:31:48Z

Wikimaster:

Category:Google Sheets

2023-03-11T02:31:16Z

Wikimaster: Created page with "Test"

Test

MediaWiki:Sidebar

2023-03-11T02:27:40Z

Wikimaster:

MediaWiki:Sidebar

2023-03-11T02:26:05Z

Main Page

2023-03-11T02:17:32Z

Wikimaster: /* Google Sheets */

Welcome to the Renee Brooks Wiki. This is probably going to be a bit overkill, but I want to create a huge repository of everything that is mine that I care about. So without further adieu, let's get this wiki started!

== Google Sheets ==
{| class="wikitable"
|+
!Link
!Description
|-
|[[Highlight Row Based on Cell Value]]
|When you have a table in Google Sheets, there are times that once a cell value has a specific value, you want the entire row to be highlighted with conditional formatting.
|-
|[[List Sheet Names and URLs for Each Sheet]]
|When you have multiple sheets in one Google Sheet Spreadsheet, this Google Scripts code will make a list of all of the sheets in this spreadsheet and the second code lists out the URLs for each tab to help make navigation easier.
|-
|
|
|}

== IT How To ==
{| class="wikitable sortable mw-collapsible"
|+
!How To Documents
|-
|[[Printer Setup]]
|-
|
|-
|
|}
MediaWiki has been installed.

Consult the [https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents User's Guide] for information on using the wiki software.

== Getting started ==
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Configuration_settings Configuration settings list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:FAQ MediaWiki FAQ]
* [https://lists.wikimedia.org/postorius/lists/mediawiki-announce.lists.wikimedia.org/ MediaWiki release mailing list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Localisation#Translation_resources Localise MediaWiki for your language]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Combating_spam Learn how to combat spam on your wiki]

File:Renee-Profile Picture.png

2023-03-11T01:16:49Z

Wikimaster:

This is the profile picture for the owner of this wiki.

This is artwork that Renee commissioned from [https://twitter.com/gabechanwrk?s=20 @gabechanwrk] and it was the first commission they had ever requested from any artist. One of my Favorite Purchases ❤️

User:Wikimaster

2023-03-11T01:09:56Z

Wikimaster: Created page with "Renee Brooks Renee is a weird 30 something non-binary individual living in West Virginia who decided they wanted a wiki about everything they knew. Rather than having to Google everything over and over for the things they retrieve an a continuous basis, a wiki sounded like a great idea to store everything in a non-clunky system."

[[File:Renee-Profile Picture.png|thumb|Renee Brooks]]
Renee is a weird 30 something non-binary individual living in West Virginia who decided they wanted a wiki about everything they knew. Rather than having to Google everything over and over for the things they retrieve an a continuous basis, a wiki sounded like a great idea to store everything in a non-clunky system.

File:Renee-Profile Picture.png

2023-03-11T01:06:05Z

Wikimaster:

This is the profile picture for the owner of this wiki.

List Sheet Names and URLs for Each Sheet

2023-03-11T01:03:17Z

Wikimaster:

List Sheet Names and URLs for Each Sheet

2023-03-11T00:57:06Z

Wikimaster:

List Sheet Names and URLs for Each Sheet

2023-03-11T00:51:18Z

Wikimaster: Created page with "# Create a Google Sheet that has a ton of sheets # Create a new Sheet that is left-most of all of the other sheets in the Google Sheet # Insert this code to the Scripts section and hit save <code>function listSheets() {</code> <code> var sheetNames = new Array();</code> <code> var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();</code> <code> var selectedSheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();</code> <code> var selectedRow..."

# Create a Google Sheet that has a ton of sheets
# Create a new Sheet that is left-most of all of the other sheets in the Google Sheet
# Insert this code to the Scripts section and hit save

<code>function listSheets() {</code>

<code> var sheetNames = new Array();</code>

<code> var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();</code>

<code> var selectedSheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();</code>

<code> var selectedRow = selectedSheet.getActiveCell().getRow();</code>

<code> var selectedCol = selectedSheet.getActiveCell().getColumn();</code>

<code> var range = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getRange(selectedRow, selectedCol, sheets.length, 1);</code>

<code> for (var i = 0; i < sheets.length; i++) sheetNames.push([sheets[i].getName()]);</code>

<code> range.setValues(sheetNames);</code>

<code>}</code>

<code>function onOpen() {</code>

<code> SpreadsheetApp.getUi()</code>

<code> .createMenu('Sheets')</code>

<code> .addItem('List All Sheets', 'listSheets')</code>

<code> .addItem('List All URLS', 'listedSheetUrls')</code>

<code> .addToUi();</code>

<code>}</code>

<code>function mySheetName() {</code>

<code> var key = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getName();</code>

<code> return key;</code>

<code>}</code>

<code>function listedSheetUrls() {</code>

<code> var ss=SpreadsheetApp.getActive();</code>

<code> var sh=ss.getSheetByName('Index');</code>

<code> var rg=sh.getRange(1,1,sh.getLastRow(),1);</code>

<code> var vA=rg.getValues();</code>

<code> var nA=vA.map(function(r){return r[0];});</code>

<code> var shts=ss.getSheets();</code>

<code> shts.forEach(function(sh,i){</code>

<code> var idx=nA.indexOf(sh.getName());</code>

<code> if(idx!=-1) {</code>

<code> var url=Utilities.formatString('<nowiki>https://docs.google.com/spreadsheets/d/%s/edit#gid=%s',ss.getId(),sh.getSheetId())</nowiki>;</code>

<code> vA[idx].splice(1,0,url);</code>

<code> }</code>

<code> });</code>

<code> sh.getRange(1,1,vA.length,vA[0].length).setValues(vA);</code>

<code>}</code>

Main Page

2023-03-11T00:47:38Z

Wikimaster: /* Google Sheet Shortcuts */

Welcome to the Renee Brooks Wiki. This is probably going to be a bit overkill, but I want to create a huge repository of everything that is mine that I care about. So without further adieu, let's get this wiki started!

== Google Sheets ==
{| class="wikitable"
|+
!Link
!Description
|-
|[[Highlight Row Based on Cell Value]]
|When you have a table in Google Sheets, there are times that once a cell value has a specific value, you want the entire row to be highlighted with conditional formatting.
|-
|[[List Sheet Names and URLs for Each Sheet]]
|When you have multiple sheets in one Google Sheet Spreadsheet, this Google Scripts code will make a list of all of the sheets in this spreadsheet and the second code lists out the URLs for each tab to help make navigation easier.
|-
|
|
|}

== Test Section 2 ==

== Test Section 3 ==
{| class="wikitable sortable mw-collapsible"
|+
!How To Documents
|-
|[[Printer Setup]]
|-
|
|-
|
|}
MediaWiki has been installed.

Consult the [https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents User's Guide] for information on using the wiki software.

== Getting started ==
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Configuration_settings Configuration settings list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:FAQ MediaWiki FAQ]
* [https://lists.wikimedia.org/postorius/lists/mediawiki-announce.lists.wikimedia.org/ MediaWiki release mailing list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Localisation#Translation_resources Localise MediaWiki for your language]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Combating_spam Learn how to combat spam on your wiki]

Highlight Row Based on Cell Value

2023-03-11T00:42:41Z

Wikimaster:

[[File:Google Sheets - Conditional Formatting to Highlight Entire Row Based on Cell Value.png|thumb|Use the formula <code>=$G1=true</code> if you are messing with Check Marks in the G Column - Otherwise it is <code>=$G1="ValueToTrigger"</code>]]

# Create your table of data
# Select your entire table of data
# Click on "Format" and then "Conditional Formatting"
# Create a new Conditional Formatting Rule
## Set the range to the table of data
## Change the rule to be "Custom formula is"
## Use the formula <code>=$G1=true</code> if you are messing with Check Marks in the G Column - Otherwise it is <code>=$G1="ValueToTrigger"</code>
[[Category:Google Sheets]]

Highlight Row Based on Cell Value

2023-03-11T00:41:09Z

Wikimaster: Created page with "Use the formula <code>=$G1=true</code> if you are messing with Check Marks in the G Column - Otherwise it is <code>=$G1="ValueToTrigger"</code> # Create your table of data # Select your entire table of data # Click on "Format" and then "Conditional Formatting" # Create a new Conditional Formatting Rule ## Set the range to the table of data ## Change the rule to be "Cust..."

File:Google Sheets - Conditional Formatting to Highlight Entire Row Based on Cell Value.png

2023-03-11T00:37:01Z

Wikimaster:

Google Sheets - Conditional Formatting to Highlight Entire Row Based on Cell Value

Main Page

2023-03-11T00:31:51Z

Wikimaster: /* Test Section 1 */

Main Page

2023-03-03T00:48:10Z

Wikimaster:

Welcome to the Renee Brooks Wiki. This is probably going to be a bit overkill, but I want to create a huge repository of everything that is mine that I care about. So without further adieu, let's get this wiki started!

== Test Section 1 ==

== Test Section 2 ==

== Test Section 3 ==
{| class="wikitable sortable mw-collapsible mw-collapsed"
|+
!How To Documents
|-
|[[Printer Setup]]
|-
|
|-
|
|}
MediaWiki has been installed.

Consult the [https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents User's Guide] for information on using the wiki software.

== Getting started ==
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Configuration_settings Configuration settings list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:FAQ MediaWiki FAQ]
* [https://lists.wikimedia.org/postorius/lists/mediawiki-announce.lists.wikimedia.org/ MediaWiki release mailing list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Localisation#Translation_resources Localise MediaWiki for your language]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Combating_spam Learn how to combat spam on your wiki]

Main Page

2023-03-02T03:31:27Z

Wikimaster:

Welcome to the Renee Brooks Wiki. This is probably going to be a bit overkill, but I want to create a huge repository of everything that is mine that I care about. So without further adieu, let's get this wiki started!
{| class="wikitable"
|+
!How To Documents
|-
|[[Printer Setup]]
|-
|
|-
|
|}
MediaWiki has been installed.

Consult the [https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents User's Guide] for information on using the wiki software.

== Getting started ==
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Configuration_settings Configuration settings list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:FAQ MediaWiki FAQ]
* [https://lists.wikimedia.org/postorius/lists/mediawiki-announce.lists.wikimedia.org/ MediaWiki release mailing list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Localisation#Translation_resources Localise MediaWiki for your language]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Combating_spam Learn how to combat spam on your wiki]

HL-2360DW Brother Laser Printer

2023-03-02T03:25:53Z

Wikimaster:

File:Network Connection Repair Tool.png

2023-03-02T03:23:55Z

Wikimaster:

This is the main thing that allows the printer to connect

File:Full Software Version.png

2023-03-02T02:52:17Z

Wikimaster:

This is the file to download

HL-2360DW Brother Laser Printer

2023-03-02T02:47:38Z

Wikimaster: Created page with "HL-2360DW Brother Laser Printer # Ensure your computer is connected to the internet. # {{DEFAULTSORT:Printer_Test}}"

[[File:HL-2360DW Brother Printer.jpg|left|thumb|HL-2360DW Brother Laser Printer]]
# Ensure your computer is connected to the internet.
#
{{DEFAULTSORT:Printer_Test}}