Hi,
I'm new here and could do with some help with Excel if there's anyone out there who might know the answer to this rather tricky query.
I've got an image which users click and drag on to create up to 5 boxes on an image to show their points of interest on it. The boxes can vary in shape and size. The results are then exported to Excel and show in the following format: {x:204,y:152,w:-96,h:-35}
As you've most likely figured out, x and y show the vertical and horizontal positions. w and h show the width and height. I'm told that a negative "w" value means the user moved left when creating their box and a negative "h" value means they moved up, rather than down.
We will have a long list of these data results and what we want to do is somehow use this data to create a set of tables which can then be placed back over the original image to create a point of interest map. Ideally this would be a thermal map which shows different colours for points of higher interest but I understand this adds to the complexity.
I know this might be difficult to visualise exactly what I need so please let me know if anything else needs explaining better. I also apologised if I haven't followed any protocol correctly or if I've left any information out.
Thanks so much in anticipation for your help.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
I'm new here and could do with some help with Excel if there's anyone out there who might know the answer to this rather tricky query.
I've got an image which users click and drag on to create up to 5 boxes on an image to show their points of interest on it. The boxes can vary in shape and size. The results are then exported to Excel and show in the following format: {x:204,y:152,w:-96,h:-35}
As you've most likely figured out, x and y show the vertical and horizontal positions. w and h show the width and height. I'm told that a negative "w" value means the user moved left when creating their box and a negative "h" value means they moved up, rather than down.
We will have a long list of these data results and what we want to do is somehow use this data to create a set of tables which can then be placed back over the original image to create a point of interest map. Ideally this would be a thermal map which shows different colours for points of higher interest but I understand this adds to the complexity.
I know this might be difficult to visualise exactly what I need so please let me know if anything else needs explaining better. I also apologised if I haven't followed any protocol correctly or if I've left any information out.
Thanks so much in anticipation for your help.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>
