Question 1

How to Use LCB Book Creator (Powerpoint product)

Accepted Answer

This tutorial describes how to Use LCB Book Creator (Powerpoint product). It applies to:

For the Reseller / White Label product, the screenshots may look slightly different because of product customisation. for the Source Code product, this tutorial shows how the scripts and macros work after delivery.

First Things First - Handling Security Issues

If you get security warning from Powerpoint when you start the product, you have to tell both Windows and Powerpoint that you accept the file and the macros. We have a separate tutorial that shows you in detail how to do this: Enable Powerpoint Macros

Using LCB Book Creator

You can find LCB Book Creator on the Add-ins ribbon:

LCB Book Creator Finding the Add-In

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/wuGqS3zSeN/resources/2t13ML5EZa/LCB%20Book%20Creator%20Finding%20the%20Add-In.png (LCB Book Creator Finding the Add-In)

LCB Book Creator Finding the Add-In

Click the "LCB Book Creator" text or icon to start the LCB Book Creator:

LCB Book Creator Main Window

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/wuGqS3zSeN/resources/Bnja5XbYzz/LCB%20Book%20Creator%20Window.png (LCB Book Creator Main Window)

LCB Book Creator Main Window

There are 5 different (small) steps:

Select the CSV File, the data file for your Low Content Book or Images,
Select the Powerpoint Template file
Verify Placeholders - Check that all placeholders in the Powerpoint file do have data in the CSV file
Set the Powerpoint Output file
Generate Slides.

Optionally you can create example files, this will save a sample CSV file and a sample Powerpoint file to your computer. (You can select the sample files for step 1 and 2, to do a first test-run with LCB Book Creator).

CSV Files

CSV means "Comma Separated Variable length". In other words: the different values, texts, on each line are separated by commas. Besides that, it's just a plain text file, that you can type in Notepad, or save in Excel (use csv as the output format).

For LCB Book Creator, the first line needs to have the 'Placeholder' names, that will be present in the Powerpoint file.

After the first line with the placeholders, you can add lines with data. The lines will be processed one at a time.

Powerpoint Templates

Powerpoint Templates for LCB Book Creator are regular Powerpoint files. You can use placeholders (like "%TITLE%") that will be replaced with text from the CSV file.

The image below is from the sample Powerpoint Template file.

PPT Sample File

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/wuGqS3zSeN/resources/XE7n05BEIF/PPT%20Sample%20File.png (PPT Sample File)

PPT Sample File

The sample file is plain, and it is not recommended to use it 'as is'. It is intended to show you how the placeholders work. You can design the Powerpoint file any way you like, and you can even use multiple slides for each row of data in the CSV file.

Whever the text for a placeholder is an existing file on your computer (e.g. "C:/Images/Books.jpg"), LCB Book Creator will replace the placeholder with the image. Otherwise, it will only replace the placeholder text with the next text.

Output Settings

To generate a Powerpoint file, you'll always need to specify where the new file must be saved (step 4).

Additionally, you can automatically generate image files in PNG, JPG and PDF format. These will be saved in a subfolder. The value in the first column of your CSV file will be used as the filename.

Generate Powerpoint Slides

When you click Generate, a Powerpoint file will be created and saved to your computer, with the name and location that you selected in step 4. This may take a couple of seconds, depending on the complexity of your template, the number of placeholders and the size of the CSV file.

Question 2

How Can I Create Books with Mixed Puzzle Books (plugin for Powerpoint)?

Accepted Answer

Getting Started

This tutorial explains the steps to create puzzle books using Mixed Puzzle Books (plugin for Powerpoint).

If you are using Puzzle Maker Pro, you can quickly create puzzles and puzzle books with a single mouse-click. However, there is a lot of puzzle-software available - free and commercial - that only creates the puzzles, not the books. That's where Mixed Puzzle Books comes in. (Fair warning: the Easy Puzzle Book plugins may not work properly with certain Puzzle Maker Pro puzzle types, such as Word Search or JigSaw).

Install the Plugin

First of all, you'll need to install the software: Easy Puzzle Books is a plugin for Powerpoint - it requires MS Windows and MS Powerpoint to be installed on your computer. It does not work with the cloud (browser) version of MS Office / Powerpoint.

If you haven't installed the plugin yet, you should do that first. There's a tutorial for downloading and installing the plugin here.

Start the Plugin

To start Easy Puzzle Books, open the "Add-ins" ribbon in Powerpoint (this is a menu option, usually just to the left of the Help Menu).

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/wuGqS3zSeN/resources/c2xd7twyDJ/Add-in%20menu.jpg (Add-in menu.jpg)

The Add-ins ribbon should contain the BookPublisherTools group of options. Click "More Options" to open the dropdown menu, and select "Mixed Puzzle Books".

Mixed Puzzle Books - Overview

If you have used the Easy Puzzle Books plugin for Powerpoint, please be aware that Mixed Puzzle Books is designed slightly differently.

The Mixed Puzzle Books plugin will open a panel at the right (just like the shape edit panel in Powerpoint). The panel has two tabs:

First things first: Page Setup

Always set up the page size first, otherwise you'll be generating grids and puzzle page in the wrong format later.

Automatic Book Generation

As you can see in the screen shots, there are 4 steps to set up and create your puzzle book:

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/wuGqS3zSeN/resources/sMpP6hL201/Mixed%20Puzzle%20Books%20001%20Overview.jpg (Mixed Puzzle Books 001 Overview.jpg)

At the top of the tab page is a "Preset" section: You can save the entire book setup as a preset, and retrieve it later. This will NOT save the Powerpoint contents, and saving the Powerpoint file will NOT save the Easy Puzzle Books data!

Step 1: Set up the puzzles

Select puzzle and solution files on your computer for your puzzle book. Click the green button "Select Puzzles". More details can be found in the Puzzle Setup Tutorial.

After selecting the puzzles and solutions, you should see the status information next to the green button.

There are two additional options:

"Start At" - The first puzzle number to use. In most cases this will be 1 (one), but if you want to create parts of a puzzle book to combine later, you can enter a different number here,
"Balance Puzzle Sets" - Use this option to make sure each page will contain an equal number of puzzles from each set. An example: if you have 4 sets of 50 puzzles and want to balance them, the four puzzles will be used in a random order. The order can be A-B-C-D C-A-B-D D-A-C-B, but it will never be A-A-B-C D-A-C-D.

Note: For Mixed Puzzle Books it makes sense to name the puzzle sets properly, to prevent making mistakes.

Note: If you select just one set of puzzles, Mixed Puzzle Books create books that are identical to Easy Puzzle Books output.

Step 2: Set up the Puzzles Grid

Easy Puzzle Books will use a grid-style layout for your puzzles, e.g. 1 per page, 2x2, 3x4, etc. Click the green button "Set Up Grid (Puzzles)" to set up the number of puzzles per page and the margins and padding. Details can be found in the Grid Setup Tutorial

When the grid setup for the puzzles is done, the selected grid size should be shown next to the green button.

Step 3: Set up the Solutions Grid

There are two options for the solutions grid:

It can be identical to the puzzles grid. Click the "Use Puzzles Grid" option and make sure it's checked. This is usually the best format if you want to create a solutions page right after each puzzles page;
Set up a separate grid for the solutions - for example you can have 6 puzzles on a page and 12 solutions on a page

Setting up the solutions grid is done identical to the puzzle grid.

Step 4: Create Puzzle Book

The final step is to create a puzzle book, using the settings specified in the previous steps.

There are three options here:

Keep Aspect Ratio - If you use different types of puzzles, with different shapes, e.g. rectangles and squares, you want to keep the original size of the puzzle. By default, images are stretches to fit in the shapes of the grid. However, adjusting the size of each shape (based on the shape of the puzzle or solution) strongly affects the processing time;
Collate - Print the puzzles first and the solutions later. if unchecked, it will print a puzzle page, then a solution page, then the next puzzle page, etc;
New Powerpoint File: It's possible to create the puzzle pages in a new Powerpoint file. It will automatically copy the page setup (width and height) from the current file. Otherwise the new pages will be appended at the end of the current Powerpoint file.

Example

To show you what it can look like, this screenshot shows the setup for a sudoku puzzle book with 50 puzzles. The next screenshot shows the pages that have been generated in Powerpoint.

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/wuGqS3zSeN/resources/L2NEj8vewb/Mixed%20Puzzle%20Books%20002%20Auto%20Filled%20Overview.jpg (Mixed Puzzle Books 002 Auto Filled Overview.jpg)

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/wuGqS3zSeN/resources/9o3nAexdjc/Mixed%20Puzzle%20Books%20003%20Example%20Powerpoint.jpg (Mixed Puzzle Books 003 Example Powerpoint.jpg)

Next steps

In many cases the automatic puzzle book creation will be just what you need. It's fast.

Once you have a configuration that works for you, with the proper grid sizes and margins, you can even save the entire setup as a preset, to use for several books. Each time you create a new book, you can load the preset, and just clear the puzzle sets and select different puzzles.

It's possible to have many presets, for example if you publish different book sizes or different puzzle types.

Manual Puzzle Book Creation

With Easy Puzzle Books you can also customize the grids, page style, fonts, etc before filling the templates with puzzles and solutions. This is called Manual Puzzle Book Creation. You can find a tutorial here.

Question 3

How Can I Create Books with Easy Puzzle Books (plugin for Powerpoint)?

Accepted Answer

Getting Started

This tutorial explains the steps to create puzzle books using Easy Puzzle Books (plugin for Powerpoint).

If you are using Puzzle Maker Pro, you can quickly create puzzles and puzzle books with a single mouse-click. However, there is a lot of puzzle-software available - free and commercial - that only creates the puzzles, not the books. That's where Easy Puzzle Books comes in. (It may not work properly with certain Puzzle Maker Pro puzzle types, such as Word Search or JigSaw).

Install the Plugin

First of all, you'll need to install the software: Easy Puzzle Books is a plugin for Powerpoint - it requires MS Windows and MS Powerpoint to be installed on your computer. It does not work with the cloud (browser) version of MS Office / Powerpoint.

If you haven't installed the plugin yet, you should do that first. There's a tutorial for downloading and installing the plugin here.

Start the Plugin

To start Easy Puzzle Books, open the "Add-ins" ribbon in Powerpoint (this is a menu option, usually just to the left of the Help Menu).

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/wuGqS3zSeN/resources/c2xd7twyDJ/Add-in%20menu.jpg (Add-in menu.jpg)

The Add-ins ribbon should contain the BookPublisherTools group of options. Click "More Options" to open the dropdown menu, and select "Easy Puzzle Books".

Easy Puzzle Books - Overview

The Easy Puzzle Books plugin will open a panel at the right (just like the shape edit panel in Powerpoint). The panel has three tabs:

Auto - Automatic puzzle book creation - you'll still have to set up the puzzles and the layout, but after that it's automatic. We'll cover the details below;
Manual - This is a little bit more complex - you'll create a grid with placeholders first, and then fill the placeholders with puzzles. There's a separate "Manual Book Creation" tutorial, but it's best to start with automatic book creation, to learn how the plugin works;
Page Setup - Quickly set up the proper trim size for Powerpoint.

First things first: Page Setup

Always set up the page size first, otherwise you'll be generating grids and puzzle page in the wrong format later.

Automatic Book Generation

As you can see in the screen shots, there are 5 steps to set up and create your puzzle book:

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/wuGqS3zSeN/resources/5Bfobqk8LA/Easy%20Puzzle%20Books%20-%20001%20Auto%20Overview.jpg (Easy Puzzle Books - 001 Auto Overview.jpg)

At the top of the tab page is a "Preset" section: You can save the entire book setup as a preset, and retrieve it later. This will NOT save the Powerpoint contents, and saving the Powerpoint file will NOT save the Easy Puzzle Books data!

Step 1: Set up the puzzles

Select puzzle and solution files on your computer for your puzzle book. Click the green button "Select Puzzles". More details can be found in the Puzzle Setup Tutorial

After selecting the puzzles and solutions, you should see the status information next to the green button.

Note: For Easy Puzzle Books it's not required to enter a name for the set of puzzles.

Step 2: Set up the Puzzles Grid

Easy Puzzle Books will use a grid-style layout for your puzzles, e.g. 1 per page, 2x2, 3x4, etc. Click the green button "Set Up Grid (Puzzles)" to set up the number of puzzles per page and the margins and padding. Details can be found in the Grid Setup Tutorial

When the grid setup for the puzzles is done, the selected grid size should be shown next to the green button.

Step 3: Set up the Solutions Grid

There are two options for the solutions grid:

It can be identical to the puzzles grid. Click the "Use Puzzles Grid" option and make sure it's checked. This is usually the best format if you want to create a solutions page right after each puzzles page;
Set up a separate grid for the solutions - for example you can have 6 puzzles on a page and 12 solutions on a page

Setting up the solutions grid is done identical to the puzzle grid.

Step 4: Set Titles for Puzzles and Solutions

The next step is setting your titles for the puzzles and solutions. This is totally up to you.

The "Number Symbol" can be changed as well - this is a placeholder in the title that will be replaced with the right puzzle or solution number, when the book is created.

Step 5: Create Puzzle Book

The final step is to create a puzzle book, using the settings specified in the previous steps.

There are two options here:

Collate - Print the puzzles first and the solutions later. if unchecked, it will print a puzzle page, then a solution page, then the next puzzle page, etc
New Powerpoint File: It's possible to create the puzzle pages in a new Powerpoint file. It will automatically copy the page setup (width and height) from the current file. Otherwise the new pages will be appended at the end of the current Powerpoint file.

Example

To show you what it can look like, this screenshot shows the setup for a sudoku puzzle book with 50 puzzles. The next screenshot shows the pages that have been generated in Powerpoint.

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/wuGqS3zSeN/resources/6V8BnXxAlR/Easy%20Puzzle%20Books%20-%20002%20Auto%20Filled%20Overview.jpg (Easy Puzzle Books - 002 Auto Filled Overview.jpg)

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/wuGqS3zSeN/resources/w0H7dOeaq4/Easy%20Puzzle%20Books%20-%20003%20Powerpoint%20Example.jpg (Easy Puzzle Books - 003 Powerpoint Example.jpg)

Next steps

In many cases the automatic puzzle book creation will be just what you need. It's fast.

Once you have a configuration that works for you, with the proper grid sizes and margins, you can even save the entire setup as a preset, to use for several books. Each time you create a new book, you can load the preset, and change the puzzle and solution files.

It's possible to have many presets, for example if you publish different book sizes or different puzzle types.

Manual Puzzle Book Creation

With Easy Puzzle Books you can also customize the grids, page style, fonts, etc before filling the templates with puzzles and solutions. This is called Manual Puzzle Book Creation. You can find a tutorial here.