cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
xsanchezwsca Frequent Visitor
Frequent Visitor

Desktop indicator/monitor

Good day,

 

I would like to create a desktop indicator with data that is updated from an excel sheet (fast updates but not necessarly real time but every minute let's say). This indicator would only consist of an exchange rate and an amount of money. I would like to be able to visualize it like I visualize my desktop clock or window toolbar.

 

At the place I'm working, we use contracts to cover our foreign sales. It is important for us to be able to see how much money is there left on the contract.

 

Ex: 1.354623 / 78 000$

 

Then if I create a foreign sale invoice of 8 000$, the amount would shrink to 70 000$. By this I know when to buy the next contrat.

 

Thank you

Would it be possible to create such an indicator ? Could I share it on my collegues computer desktop ?

 

Thank you

2 REPLIES 2
Moderator Eric_Zhang
Moderator

Re: Desktop indicator/monitor


@xsanchezwsca wrote:

Good day,

 

I would like to create a desktop indicator with data that is updated from an excel sheet (fast updates but not necessarly real time but every minute let's say). This indicator would only consist of an exchange rate and an amount of money. I would like to be able to visualize it like I visualize my desktop clock or window toolbar.

 

At the place I'm working, we use contracts to cover our foreign sales. It is important for us to be able to see how much money is there left on the contract.

 

Ex: 1.354623 / 78 000$

 

Then if I create a foreign sale invoice of 8 000$, the amount would shrink to 70 000$. By this I know when to buy the next contrat.

 

Thank you

Would it be possible to create such an indicator ? Could I share it on my collegues computer desktop ?

 

Thank you


I'm not getting what eactly you'd like to do, when creating a sale invoice of 8000$, why "1.354623 / 70 000$" instead of "8001.354623 / 78 000$"? 

 

For further suggestion, please post some sample data, expected output and more explanation of your scenario.

xsanchezwsca Frequent Visitor
Frequent Visitor

Re: Desktop indicator/monitor

Good day,

 

Thank you for answering.

1.354623 is the exchange rate

78 000$ is the amount left to protect the future foreign sales at that exchange rate.

 

It could also appear like : 78 000$ @ 1.354623

 

I just want to be able to see what is my exchange rate and how fast the amount is shrinking.

 

Then when I am under 10 000$, I know I should buy another 100 000$ contract to protect the sales and that contract has another exchange rate...

 

I just want to see two datas coming from an excel sheet in a fast-way...Like the clock in my windows desktop.

 

It could have been something else like wheater or stocks quotations...

 

Is it clear ?

 

Thank you

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)