Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Determining when calculation has completed
Hello, I have a calculation that can take about 20 seconds to complete. I
then need to use the answer as an input to another program outside of Excel. The problem I have is knowing when the calculation has finished so I know I'm reading the most recent answer. Ideally, I'd like to set a value in a cell that I can test so I know the last calculation is complete. Is this possible or is there a better way. Thank you for your help. David |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Determining when calculation has completed
Hi David
What is the formula that is taking so long to calculate? -- Regards Roger Govier "DavidS" wrote in message ... Hello, I have a calculation that can take about 20 seconds to complete. I then need to use the answer as an input to another program outside of Excel. The problem I have is knowing when the calculation has finished so I know I'm reading the most recent answer. Ideally, I'd like to set a value in a cell that I can test so I know the last calculation is complete. Is this possible or is there a better way. Thank you for your help. David |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Determining when calculation has completed
The formula is a dll file that has a proprietary algorithm so I don't know
what its doing. I do know it uses 30 columns in Excel and its calculation is based over 40 previous readings. Another reading comes into Excel every 5 minutes and an output is calculated. The output is sent to a program that plots this data with other data. I have some control over the program that plots the data but I can't ask it to wait for 20 seconds before it reads the output in Excel. I could ask it to read Excel based upon a flag or condition. I'm trying to find this i.e. something that says Excel processing is complete and therefore calculation relates to the last 5 minute reading. Without this, the chart program just reads Excel when the 5 minute data is sent to Excel so it picks up the last calculation. I hope this makes sense. Thanks, David "Roger Govier" wrote in message ... Hi David What is the formula that is taking so long to calculate? -- Regards Roger Govier "DavidS" wrote in message ... Hello, I have a calculation that can take about 20 seconds to complete. I then need to use the answer as an input to another program outside of Excel. The problem I have is knowing when the calculation has finished so I know I'm reading the most recent answer. Ideally, I'd like to set a value in a cell that I can test so I know the last calculation is complete. Is this possible or is there a better way. Thank you for your help. David |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Determining when calculation has completed
How are you invoking the algorithm? Presumably you have some macro
which updates Excel with the new reading then calls the algorithm, so can't you incorporate the flag cell into your macro? - something like receive new value, clear flagged cell, invoke algorithm, reset flagged cell when complete, call graphing program. Hope this helps. Pete On Mar 16, 9:11 am, "DavidS" wrote: The formula is a dll file that has a proprietary algorithm so I don't know what its doing. I do know it uses 30 columns in Excel and its calculation is based over 40 previous readings. Another reading comes into Excel every 5 minutes and an output is calculated. The output is sent to a program that plots this data with other data. I have some control over the program that plots the data but I can't ask it to wait for 20 seconds before it reads the output in Excel. I could ask it to read Excel based upon a flag or condition. I'm trying to find this i.e. something that says Excel processing is complete and therefore calculation relates to the last 5 minute reading. Without this, the chart program just reads Excel when the 5 minute data is sent to Excel so it picks up the last calculation. I hope this makes sense. Thanks, David "Roger Govier" wrote in message ... Hi David What is the formula that is taking so long to calculate? -- Regards Roger Govier "DavidS" wrote in message ... Hello, I have a calculation that can take about 20 seconds to complete. I then need to use the answer as an input to another program outside of Excel. The problem I have is knowing when the calculation has finished so I know I'm reading the most recent answer. Ideally, I'd like to set a value in a cell that I can test so I know the last calculation is complete. Is this possible or is there a better way. Thank you for your help. David- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Determining when calculation has completed
Pete, the algorithm is a dll file that has been registered in Excel. When
data is placed in a cell, Excel calls the dll and places the output in another cell. There is a macro but I'm not sure that if I add a flag it will be seen before or after the calculation completes but its worth investigating. I may settle for putting each output in a new row. I can then check the expected row for a result. Thanks "Pete_UK" wrote in message ups.com... How are you invoking the algorithm? Presumably you have some macro which updates Excel with the new reading then calls the algorithm, so can't you incorporate the flag cell into your macro? - something like receive new value, clear flagged cell, invoke algorithm, reset flagged cell when complete, call graphing program. Hope this helps. Pete On Mar 16, 9:11 am, "DavidS" wrote: The formula is a dll file that has a proprietary algorithm so I don't know what its doing. I do know it uses 30 columns in Excel and its calculation is based over 40 previous readings. Another reading comes into Excel every 5 minutes and an output is calculated. The output is sent to a program that plots this data with other data. I have some control over the program that plots the data but I can't ask it to wait for 20 seconds before it reads the output in Excel. I could ask it to read Excel based upon a flag or condition. I'm trying to find this i.e. something that says Excel processing is complete and therefore calculation relates to the last 5 minute reading. Without this, the chart program just reads Excel when the 5 minute data is sent to Excel so it picks up the last calculation. I hope this makes sense. Thanks, David "Roger Govier" wrote in message ... Hi David What is the formula that is taking so long to calculate? -- Regards Roger Govier "DavidS" wrote in message ... Hello, I have a calculation that can take about 20 seconds to complete. I then need to use the answer as an input to another program outside of Excel. The problem I have is knowing when the calculation has finished so I know I'm reading the most recent answer. Ideally, I'd like to set a value in a cell that I can test so I know the last calculation is complete. Is this possible or is there a better way. Thank you for your help. David- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Determining when calculation has completed
You're welcome - hope you can get something working.
Pete On Mar 16, 9:31 pm, "DavidS" wrote: Pete, the algorithm is a dll file that has been registered in Excel. When data is placed in a cell, Excel calls the dll and places the output in another cell. There is a macro but I'm not sure that if I add a flag it will be seen before or after the calculation completes but its worth investigating. I may settle for putting each output in a new row. I can then check the expected row for a result. Thanks"Pete_UK" wrote in message ups.com... How are you invoking the algorithm? Presumably you have some macro which updates Excel with the new reading then calls the algorithm, so can't you incorporate the flag cell into your macro? - something like receive new value, clear flagged cell, invoke algorithm, reset flagged cell when complete, call graphing program. Hope this helps. Pete On Mar 16, 9:11 am, "DavidS" wrote: The formula is a dll file that has a proprietary algorithm so I don't know what its doing. I do know it uses 30 columns in Excel and its calculation is based over 40 previous readings. Another reading comes into Excel every 5 minutes and an output is calculated. The output is sent to a program that plots this data with other data. I have some control over the program that plots the data but I can't ask it to wait for 20 seconds before it reads the output in Excel. I could ask it to read Excel based upon a flag or condition. I'm trying to find this i.e. something that says Excel processing is complete and therefore calculation relates to the last 5 minute reading. Without this, the chart program just reads Excel when the 5 minute data is sent to Excel so it picks up the last calculation. I hope this makes sense. Thanks, David "Roger Govier" wrote in message ... Hi David What is the formula that is taking so long to calculate? -- Regards Roger Govier "DavidS" wrote in message ... Hello, I have a calculation that can take about 20 seconds to complete. I then need to use the answer as an input to another program outside of Excel. The problem I have is knowing when the calculation has finished so I know I'm reading the most recent answer. Ideally, I'd like to set a value in a cell that I can test so I know the last calculation is complete. Is this possible or is there a better way. Thank you for your help. David- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF completed THEN invisible | Excel Discussion (Misc queries) | |||
Force a field to be completed | Excel Worksheet Functions | |||
Determining calculation slowdowns | Excel Worksheet Functions | |||
How do I add rows to a completed worksheet? | Excel Worksheet Functions | |||
How do I add rows to a completed worksheet? | Excel Worksheet Functions |