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.
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
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
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!
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.
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/
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.
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!
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/
I have no words to describe your work for the S&C profession.
Well, I'll try. Absolutely awesome
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.
whats S&C profession?
Thank you for putting this video together!
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
That's a great idea! That makes things way easier/more convenient. Thank you for sharing this tip!
This is awesome - Great job.
Thank you so much, Vern! Don't hesitate to reach out if you have any questions.
Thank you Adam! You're a legend!
Thank you, Will! I'm glad that the video provided value for you!
This is awesome! Is there a download of this completed excel file, please?
Very nice Sr. Thanks from Medellín, Colombia
Thank you, Nelson! I really appreciate your kind words.
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
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!
simply brilliant
Thank you!
How do I include both the severity level and the injury type?
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.
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/
Sent you an email via your website, thanks again. Joe
Just subscribe for this great video
Can you share the spreadsheet? Thanks
adamvirgile.com/product/body-map-dashboard/
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.
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!
Hi Adam hope you are well, can we use this same formula in google sheets?
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/
Jesus is the Way the Truth and the Life no man cometh to the Father but by Him