How to Make an Interactive Body Map in Excel (No Macros Needed)

[@aaangel30]

Great video! THANK YOU! Pain, especially chronic pain, is very difficult to communicate, and I'm very excited about using this kind of tool to more effectively document what happens and how it affects daily functioning throughout the month (or months!) between my doctor appointments. There's two things I'd like to incorporate, and I'd appreciate your input on them. 1. TYPE of pain, such as burning, numb, stabbing, etc. 2. Date range Again, I want to express my appreciation for your time and detailed instructions. Oh! ALSO, I'm so glad you didn't use some generic computer generated voice to walk us through; I enjoyed your candid video, and you even kept my attention during the tedious necessities that one's got to do to get it done! Happy Wishes ⭐

[@AdamVirgile34]

Hi there! These are fantastic thoughts. Thank you for sharing them. Depending on the situation, having different sensations displayed on the body map could definitely be helpful (such as burning, numb, etc.). I also think that being able to view how this information changes over time would be helpful. In other words, I agree! Thank you for watching.

[@Ubbnockshuss]

Thank you for putting this video together!

[@JonaGln9]

I have no words to describe your work for the S&C profession. Well, I'll try. Absolutely awesome

[@AdamVirgile34]

Wow, thank you so much, Jonatan! You're too kind. If you end up working through any of my content and have any questions, feel free to reach out - I'm happy to help in any way that I can.

[@yeahx32p69]

whats S&C profession?

[@notenoughtime23]

Great job, one quick tip you can add the background image to the table itself so you don't need to adjust the image when you remove the XY Grid Axis just click the central box and click format and add the image as a back ground and it will allow you to map the Feet as they are off the map grid in your video

[@AdamVirgile34]

That's a great idea! That makes things way easier/more convenient. Thank you for sharing this tip!

[@Tamagoyaro]

Thank you Adam! You're a legend!

[@AdamVirgile34]

Thank you, Will! I'm glad that the video provided value for you!

[@gambettasports]

This is awesome - Great job.

[@AdamVirgile34]

Thank you so much, Vern! Don't hesitate to reach out if you have any questions.

[@NelsonValleTenis]

Very nice Sr. Thanks from Medellín, Colombia

[@AdamVirgile34]

Thank you, Nelson! I really appreciate your kind words.

[@hectorazul7462]

I am currently attempting to build this myself.... I am a Safety Technician who is passionate about Ergonomics, this tool/ Spreadsheet will be God sent if i manage to duplicate it. Its a long shot, but do you have a downloadable example online?... If there is a ready to use sheet I'd love to get it. Thank you!

[@AdamVirgile34]

I do, but it is not free: adamvirgile.com/product/body-map-dashboard/

[@hectorazul7462]

@AdamVirgile34 How much is the spreadsheet? And can the value be changed or additional data collected?

[@hectorazul7462]

Awesome 👌 just saw the link. I am very interested in purchasing it. Would it affects the data if titles such as "Athletes" are renamed or the overall value of the pain level is changed? Or would you custom fit it?.... if so, how much would it be.

[@AdamVirgile34]

@@hectorazul7462 the file on the website is literally the Excel file that is produced in this video. It will operate as described in this video. If your data format differs from what is described in this video, it will not be a great option for you. I would encourage you to watch the video to understand how the body map works prior to making a decision. Thank you!

[@eddietorres2622]

Great instruction video. I'm attempting to utilize this video for my own body map. However, my body parts are listed within a row of other information. Does the order column make it break this process

[@AdamVirgile34]

Thank you for your kind words! Unfortunately, the organization of the data will dictate the setup and formulas used. On my website, I have a tutorial for long and wide data formats (e.g., it seems like yours is long, and mine is wide in this video) alongside a free body map dashboard in Google Sheets. I believe it requires a paid membership though. In case you're interested in checking: adamvirgile.com/interactive-body-map-dashboard-tutorial/ I hope this helps. Thank you!

[@dicksonrobert1492]

simply brilliant

[@AdamVirgile34]

Thank you!

[@video42please]

This is awesome! Is there a download of this completed excel file, please?

[@hadidi1]

Can you share the spreadsheet? Thanks

[@AdamVirgile34]

adamvirgile.com/product/body-map-dashboard/

[@josephkessler9989]

This is tremendous, thank you for sharing. I continue to receive an error message when writing the "IF" formula for mapping. The table names are not showing up per body part when entering in the formula tbl_data[Head]. Does this have something to do with it? The error message I recieve indicates that excel is not recongizing it as a formula and suggests I place an ' in the first AVERAGEIF tbl_data[Head] area. Can you provide any insight? Thank you in adavance.

[@AdamVirgile34]

Hi Joseph. I'm so sorry that you're experiencing this issue. It's a bit difficult to diagnose without seeing what's going on in your spreadsheet. The first thing that comes to mind is the formula being used. The formula should be AVERAGEIFS, not AVERAGEIF (they work in different ways). In any case, please feel free to send me your sheet and I'll help you troubleshoot. You can find my contact information here: adamvirgile.com/

[@josephkessler9989]

Sent you an email via your website, thanks again. Joe

[@coachdavidspeciale]

Hey Adam, would this be possible in Google Sheets? I thought I saw you had done a similar tutorial for Sheets, but I can't find it on your channel or your website.

[@AdamVirgile34]

Hi Davd. Great question. You can access the tutorial (and free spreadsheet) via this page: adamvirgile.com/members-paradise/ It is only accessible to Silver and Gold Members on the website, however. I hope this helps!

[@russelllowke6618]

Could not see where to download?

[@keenanwatson7523]

Hi Adam hope you are well, can we use this same formula in google sheets?

[@AdamVirgile34]

Hi Keenan! Thanks for reaching out about this! No, these formulas will not work in Google Sheets. I have a tutorial on how to build body map dashboards in Google Sheets, as well as a spreadsheet that has the body map already created for you. A membership to my website is required. Here is more information: adamvirgile.com/members-paradise/

[@giuliodambrosio9038]

How do I include both the severity level and the injury type?

[@aaangel30]

Curious what you mean about "injury type"... Would you have to add more data such as numb, tingling, sprain, strain, etc.?

[@bajonivideos]

Just subscribe for this great video

[@ryanperez8179]

Jesus is the Way the Truth and the Life no man cometh to the Father but by Him