Just getting started - need some help with Excel

Question

Hello, All!&nbsp;I am a retired homebody with a lot of time on my hands and I am currently trying to design and implement an application, using Excel, to provide the end user with an easy way to calculate the making of a quilt - that's right, nothing high tech or complicated.&nbsp;So, that being said, I am using a PC/Windows 11 Pro (Version 21H2) with Microsoft 365, Excel Version 2211 (Build 15831.20208 Click-to-Run).&nbsp;Here's what I would like the app to do:&nbsp;&nbsp;&nbsp;&nbsp; 1. Allow the end user to Choose the Size of their quilt, Choose the Size of their Block and Choose a Block (or Blocks) to use in constructing the quilt.&nbsp;&nbsp;&nbsp; 2. Using images of Blocks (I have made a few of these images) provide a visual context for their finished quilt (based on their choices).&nbsp; &nbsp; 3. Provide the end user a materials list for their quilt project.&nbsp;OK, with all of that in mind, I know it is quite ambitious.&nbsp; But, I am not looking for someone to do all this for me, I just need some guidance and maybe some "training" on the mechanics and concepts of Excel.&nbsp;Here's the spreadsheet I have,&nbsp;&nbsp;Welcome to the Quilt Program&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;In this application, you can design a quilt, determine supplies needed and customize your creation.Note: All dimensions are inches!&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Choose the Size of Your Quilt:Queen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Custom Size&nbsp;&nbsp;Based on your Selection, this is the size of your quilt:WidthLengthWidthLength&nbsp;&nbsp;90966060If you chose Other, Please enter the dimensions here!&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;If you choose to add borders to your quilt, choose the width here:Border 1Border 2&nbsp;&nbsp;&nbsp;&nbsp;00Choose 0, if no Border is needed, or if only 1 Border is used&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Next, Choose the size of your Blocks:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;This the number of blocks you will need:&nbsp;&nbsp;&nbsp;Total Blocks&nbsp;&nbsp;99&nbsp;81&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;The finished dimension of your quilt will be:WidthLength&nbsp;&nbsp;&nbsp;&nbsp;9090&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Based on these calculation you will need approximately the Following:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Top of Quilt Fabric:6 1/4ydsNote: These estimations are based on the area of the quilt, and don't consider things like seam allowances, etc.&nbsp;&nbsp;&nbsp;Batting:6 3/4yds&nbsp;&nbsp;&nbsp;Backing:6 1/2yds&nbsp;&nbsp;&nbsp;Binding:&nbsp;3/4yds&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;The Choices are Based on Data Validation (List, Range of Cells).&nbsp; and all of the formulas reference the choices.&nbsp;I think this will accomplish most of Point number 1 of my expectations.&nbsp;My problem is this - how to manipulate images to construct the visual concept of the quilt.Card TrickShapesFabricsColumnsRowsSquareHSTTotal566&nbsp;&nbsp;&nbsp;A (White)&nbsp;&nbsp;48&nbsp;B (Mauve)&nbsp;&nbsp;24&nbsp;C (Green)&nbsp;&nbsp;24&nbsp;D (Red)&nbsp;&nbsp;24&nbsp;E (Blue)&nbsp;&nbsp;24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;36&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SizingBlock SizeChoose Block Size:12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Finished Column Width:2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Finished Row Height:2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Seam Allowance:&nbsp;1/4&nbsp;&nbsp;Raw HST Size:2 1/2&nbsp;&nbsp;Cut Fabric Size:3 1/4Individual&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;This is the Block worksheet (the image is just that - floating on the worksheet)&nbsp;I want to arrange the images, so how do I make the images objects that I can incorporate into formulas?&nbsp;Don't know if its possible - but maybe some one has some ideas&nbsp;Thanks for your consideration!Arkieking&nbsp;&nbsp;&nbsp;

patrick2788 · Answer

Arkieking&nbsp;I want to arrange the images, so how do I make the images objects that I can incorporate into formulas?The IMAGE function may be of use to you with this project.&nbsp; It's been rolling out to users recently and you may have access to it.IMAGE function - Microsoft Support

arkieking · Answer

Thanks Patrick2788!I did a quick trial - the IMAGE function requires "The URL path, using an "https" protocol, of the image file. Required.&nbsp;Supported file formats include BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and WEBP."My images are on my local computer - where do I find a "URL path" for them. I tried to put the path on my computer but apparently I need an address with the "https" protocol.How do I accomplish that?Again Thanks for your reply!Arkieking

Forum Discussion

Just getting started - need some help with Excel

Share

Resources

Welcome to the Quilt Program

In this application, you can design a quilt, determine supplies needed and customize your creation.
Note: All dimensions are inches!

		Choose the Size of Your Quilt:	Queen
					Custom Size
Based on your Selection, this is the size of your quilt:	Width	Length	Width	Length
90	96	60	60	If you chose Other, Please enter the dimensions here!

If you choose to add borders to your quilt, choose the width here:	Border 1	Border 2
0	0	Choose 0, if no Border is needed, or if only 1 Border is used

Next, Choose the size of your Blocks:
10	10

This the number of blocks you will need:				Total Blocks
9	9		81

The finished dimension of your quilt will be:	Width	Length
90	90


Based on these calculation you will need approximately the Following:

		Top of Quilt Fabric:	6 1/4	yds	Note: These estimations are based on the area of the quilt, and don't consider things like seam allowances, etc.
		Batting:	6 3/4	yds
		Backing:	6 1/2	yds
		Binding:	3/4	yds

Card Trick	Shapes
Fabrics	Columns	Rows	Square	HST	Total
5	6	6
A (White)			4	8
B (Mauve)			2	4
C (Green)			2	4
D (Red)			2	4
E (Blue)			2	4
					36










Sizing
Block Size
Choose Block Size:	12

Finished Column Width:	2
Finished Row Height:	2
Seam Allowance:	1/4
Raw HST Size:	2 1/2
Cut Fabric Size:	3 1/4	Individual