<div>
Directed member to the correct resource
</div>


<div>
<div class="content wysiwyg-content">
Hi all,<br />
<br />
I'm trying to create a Google Sheet that will automatically create Home/Away game matchups given some user-provided parameters:<br />
<br />
Total teams: 8 (Lions, Tigers, Bears, ...). This number can vary.<br />
Total games played per team: 10 (5 Home / 5 Away if possible. This number can vary.<br />
<br />
I need the best possible diversity in terms of matchups.<br />
<br />
I'm hoping the Google Sheet can kick out a simple columnar schedule like the following.<br />
<br />
&nbsp;<a href="https://filedb.experts-exchange.com/incoming/2017/08_w33/1188111/____2017-08-16-12_21_31-__Softball-I.jpg" target="_blank" title="Screen Grab (25 KB)"><img alt="Screen Grab" class="file-block lazyload" style="max-width: 492px;" data-src="https://filedb.experts-exchange.com/incoming/2017/08_w33/1188111/____2017-08-16-12_21_31-__Softball-I.jpg" /></a><br />
Can this be done without Javascript? <br />
<br />
Thanks in advance.
</div>
</div>


____2017-08-16-12_21_31-__Softball-I.jpg

Hi all,

I'm trying to create a Google Sheet that will automatically create Home/Away game matchups given some user-provided parameters:

Total teams: 8 (Lions, Tigers, Bears, ...). This number can vary.
Total games played per team: 10 (5 Home / 5 Away if possible. This number can vary.

I need the best possible diversity in terms of matchups.

I'm hoping the Google Sheet can kick out a simple columnar schedule like the following.

 

Can this be done without Javascript? 

Thanks in advance.

Google Sheets and baseball scheduling

Google is an American multinational technology company specializing in Internet-related services and products that include online advertising technologies, search, cloud computing, software, and hardware.

Google

JavaScript is a dynamic, object-based language commonly used for client-side scripting in web browsers. Recently, server side JavaScript frameworks have also emerged. JavaScript runs on nearly every operating system and  in almost every mainstream web browser.

JavaScript

Google Workspace is a suite of cloud computing productivity and collaboration software tools and software. It includes Google’s popular web applications including Gmail, Drive, Hangouts, Calendar, and Docs. While these products are available to consumers free of charge, Google Workspace adds business-specific features such as custom email addresses at your domain and storage for documents and email.