SPSS Statistics

I am using the SPSSINC MODIFY OUTPUT command to output TABLES to specific cell locations in Excel using /CUSTOM FUNCTION="customoutputfunctions.excelexport...", with very inconsistent results.  I got my first round of tables to get placed where they need to be, with some tweaking, but I am unable to get additional tables to consistently go or even appear where they need to be.  Sometimes they show up in the excelexport file, and sometimes they do not. I have several repeating charts that require the use of PROCESS=PRECEDING immediately after the function syntax is executed (EXAMINE VARIABLES, FREQUENCIES VARIABLES, etc), instead of using PROCESS=ALL.  I have the guidance previously sent for this Python custom function, but the parameters (file, sheet, action, location, starting cell, etc) do not consistently work, and I've spent several hours testing different combinations.  I am looking for some kind of tutorial or better explanation for how these work and behave.  So far, I am finding their behavior inconsistent for producing the necessary data at the necessary locations needed for further use.

Any more detailed guidance would be greatly appreciated! Thx!

I am using the SPSSINC MODIFY OUTPUT command to output TABLES to specific cell locations in Excel using /CUSTOM FUNCTION="customoutputfunctions.excelexport...", with very inconsistent results.  I got my first round of tables to get placed where they need to be, with some tweaking, but I am unable to get additional tables to consistently go or even appear where they need to be.  Sometimes they show up in the excelexport file, and sometimes they do not. I have several repeating charts that require the use of PROCESS=PRECEDING immediately after the function syntax is executed (EXAMINE VARIABLES, FREQUENCIES VARIABLES, etc), instead of using PROCESS=ALL.  I have the guidance previously sent for this Python custom function, but the parameters (file, sheet, action, location, starting cell, etc) do not consistently work, and I've spent several hours testing different combinations.  I am looking for some kind of tutorial or better explanation for how these work and behave.  So far, I am finding their behavior inconsistent for producing the necessary data at the necessary locations needed for further use.

Any more detailed guidance would be greatly appreciated! Thx!

Thank you for the explanation.  This makes sense.  I have put the MODIFY OUTPUT code immediately following a function with PROCESS=PRECEDING because I have several tables with the same OMS Subtype name, and I don't know of any way to adequately track them or transfer specific ones to Excel otherwise.  I will tinker with the delay, but I do need SPSS to function at its fastest speed as much as possible due to the volume of models I need to run.   I assume that changing time.sleep(1) would change this to 1 second (to test for speed)?

Thank you so much for your quick response!

I am using the SPSSINC MODIFY OUTPUT command to output TABLES to specific cell locations in Excel using /CUSTOM FUNCTION="customoutputfunctions.excelexport...", with very inconsistent results.  I got my first round of tables to get placed where they need to be, with some tweaking, but I am unable to get additional tables to consistently go or even appear where they need to be.  Sometimes they show up in the excelexport file, and sometimes they do not. I have several repeating charts that require the use of PROCESS=PRECEDING immediately after the function syntax is executed (EXAMINE VARIABLES, FREQUENCIES VARIABLES, etc), instead of using PROCESS=ALL.  I have the guidance previously sent for this Python custom function, but the parameters (file, sheet, action, location, starting cell, etc) do not consistently work, and I've spent several hours testing different combinations.  I am looking for some kind of tutorial or better explanation for how these work and behave.  So far, I am finding their behavior inconsistent for producing the necessary data at the necessary locations needed for further use.

Any more detailed guidance would be greatly appreciated! Thx!

Thank you for the explanation.  This makes sense.  I have put the MODIFY OUTPUT code immediately following a function with PROCESS=PRECEDING because I have several tables with the same OMS Subtype name, and I don't know of any way to adequately track them or transfer specific ones to Excel otherwise.  I will tinker with the delay, but I do need SPSS to function at its fastest speed as much as possible due to the volume of models I need to run.   I assume that changing time.sleep(1) would change this to 1 second (to test for speed)?

Thank you so much for your quick response!

I am using the SPSSINC MODIFY OUTPUT command to output TABLES to specific cell locations in Excel using /CUSTOM FUNCTION="customoutputfunctions.excelexport...", with very inconsistent results.  I got my first round of tables to get placed where they need to be, with some tweaking, but I am unable to get additional tables to consistently go or even appear where they need to be.  Sometimes they show up in the excelexport file, and sometimes they do not. I have several repeating charts that require the use of PROCESS=PRECEDING immediately after the function syntax is executed (EXAMINE VARIABLES, FREQUENCIES VARIABLES, etc), instead of using PROCESS=ALL.  I have the guidance previously sent for this Python custom function, but the parameters (file, sheet, action, location, starting cell, etc) do not consistently work, and I've spent several hours testing different combinations.  I am looking for some kind of tutorial or better explanation for how these work and behave.  So far, I am finding their behavior inconsistent for producing the necessary data at the necessary locations needed for further use.

Any more detailed guidance would be greatly appreciated! Thx!

It works!  I tested a range of 0.1 to 2 seconds and all values worked.  I plan to use 0.1 seconds moving forward.  Tables are now loading consistently and in the right places.  One small minor issue that is not a big deal for my functionality is table formatting.  It seems that each table appears in Excel formatted differently.  Some have cells filled in with gray or black, and text ranges from light gray to black, rendering the tables unreadable to humans, but not unreadable to Excel (my target audience).  Is there a command/subcommand that could be added at the end that would remove all fills and make all text black, without manual intervention? I've uploaded an image that shows the disparate fills and text colors.

Thank you for all your help!

Thank you for the explanation.  This makes sense.  I have put the MODIFY OUTPUT code immediately following a function with PROCESS=PRECEDING because I have several tables with the same OMS Subtype name, and I don't know of any way to adequately track them or transfer specific ones to Excel otherwise.  I will tinker with the delay, but I do need SPSS to function at its fastest speed as much as possible due to the volume of models I need to run.   I assume that changing time.sleep(1) would change this to 1 second (to test for speed)?

Thank you so much for your quick response!

I am using the SPSSINC MODIFY OUTPUT command to output TABLES to specific cell locations in Excel using /CUSTOM FUNCTION="customoutputfunctions.excelexport...", with very inconsistent results.  I got my first round of tables to get placed where they need to be, with some tweaking, but I am unable to get additional tables to consistently go or even appear where they need to be.  Sometimes they show up in the excelexport file, and sometimes they do not. I have several repeating charts that require the use of PROCESS=PRECEDING immediately after the function syntax is executed (EXAMINE VARIABLES, FREQUENCIES VARIABLES, etc), instead of using PROCESS=ALL.  I have the guidance previously sent for this Python custom function, but the parameters (file, sheet, action, location, starting cell, etc) do not consistently work, and I've spent several hours testing different combinations.  I am looking for some kind of tutorial or better explanation for how these work and behave.  So far, I am finding their behavior inconsistent for producing the necessary data at the necessary locations needed for further use.

Any more detailed guidance would be greatly appreciated! Thx!

It works!  I tested a range of 0.1 to 2 seconds and all values worked.  I plan to use 0.1 seconds moving forward.  Tables are now loading consistently and in the right places.  One small minor issue that is not a big deal for my functionality is table formatting.  It seems that each table appears in Excel formatted differently.  Some have cells filled in with gray or black, and text ranges from light gray to black, rendering the tables unreadable to humans, but not unreadable to Excel (my target audience).  Is there a command/subcommand that could be added at the end that would remove all fills and make all text black, without manual intervention? I've uploaded an image that shows the disparate fills and text colors.

Thank you for all your help!

Thank you for the explanation.  This makes sense.  I have put the MODIFY OUTPUT code immediately following a function with PROCESS=PRECEDING because I have several tables with the same OMS Subtype name, and I don't know of any way to adequately track them or transfer specific ones to Excel otherwise.  I will tinker with the delay, but I do need SPSS to function at its fastest speed as much as possible due to the volume of models I need to run.   I assume that changing time.sleep(1) would change this to 1 second (to test for speed)?

Thank you so much for your quick response!

I am using the SPSSINC MODIFY OUTPUT command to output TABLES to specific cell locations in Excel using /CUSTOM FUNCTION="customoutputfunctions.excelexport...", with very inconsistent results.  I got my first round of tables to get placed where they need to be, with some tweaking, but I am unable to get additional tables to consistently go or even appear where they need to be.  Sometimes they show up in the excelexport file, and sometimes they do not. I have several repeating charts that require the use of PROCESS=PRECEDING immediately after the function syntax is executed (EXAMINE VARIABLES, FREQUENCIES VARIABLES, etc), instead of using PROCESS=ALL.  I have the guidance previously sent for this Python custom function, but the parameters (file, sheet, action, location, starting cell, etc) do not consistently work, and I've spent several hours testing different combinations.  I am looking for some kind of tutorial or better explanation for how these work and behave.  So far, I am finding their behavior inconsistent for producing the necessary data at the necessary locations needed for further use.

Any more detailed guidance would be greatly appreciated! Thx!

Thanks!  I am now testing using SPSSINC MODIFY OUTPUT on graphs and charts other than tables, but have not cracked the code yet.

After running a pplot command (which successfully goes to the output window every time), here is an example of syntax I am using, but it is not exporting to Excel:

It works!  I tested a range of 0.1 to 2 seconds and all values worked.  I plan to use 0.1 seconds moving forward.  Tables are now loading consistently and in the right places.  One small minor issue that is not a big deal for my functionality is table formatting.  It seems that each table appears in Excel formatted differently.  Some have cells filled in with gray or black, and text ranges from light gray to black, rendering the tables unreadable to humans, but not unreadable to Excel (my target audience).  Is there a command/subcommand that could be added at the end that would remove all fills and make all text black, without manual intervention? I've uploaded an image that shows the disparate fills and text colors.

Thank you for all your help!

Thank you for the explanation.  This makes sense.  I have put the MODIFY OUTPUT code immediately following a function with PROCESS=PRECEDING because I have several tables with the same OMS Subtype name, and I don't know of any way to adequately track them or transfer specific ones to Excel otherwise.  I will tinker with the delay, but I do need SPSS to function at its fastest speed as much as possible due to the volume of models I need to run.   I assume that changing time.sleep(1) would change this to 1 second (to test for speed)?

Thank you so much for your quick response!

I am using the SPSSINC MODIFY OUTPUT command to output TABLES to specific cell locations in Excel using /CUSTOM FUNCTION="customoutputfunctions.excelexport...", with very inconsistent results.  I got my first round of tables to get placed where they need to be, with some tweaking, but I am unable to get additional tables to consistently go or even appear where they need to be.  Sometimes they show up in the excelexport file, and sometimes they do not. I have several repeating charts that require the use of PROCESS=PRECEDING immediately after the function syntax is executed (EXAMINE VARIABLES, FREQUENCIES VARIABLES, etc), instead of using PROCESS=ALL.  I have the guidance previously sent for this Python custom function, but the parameters (file, sheet, action, location, starting cell, etc) do not consistently work, and I've spent several hours testing different combinations.  I am looking for some kind of tutorial or better explanation for how these work and behave.  So far, I am finding their behavior inconsistent for producing the necessary data at the necessary locations needed for further use.

Any more detailed guidance would be greatly appreciated! Thx!

Thanks!  I am now testing using SPSSINC MODIFY OUTPUT on graphs and charts other than tables, but have not cracked the code yet.

After running a pplot command (which successfully goes to the output window every time), here is an example of syntax I am using, but it is not exporting to Excel:

It works!  I tested a range of 0.1 to 2 seconds and all values worked.  I plan to use 0.1 seconds moving forward.  Tables are now loading consistently and in the right places.  One small minor issue that is not a big deal for my functionality is table formatting.  It seems that each table appears in Excel formatted differently.  Some have cells filled in with gray or black, and text ranges from light gray to black, rendering the tables unreadable to humans, but not unreadable to Excel (my target audience).  Is there a command/subcommand that could be added at the end that would remove all fills and make all text black, without manual intervention? I've uploaded an image that shows the disparate fills and text colors.

Thank you for all your help!

Thank you for the explanation.  This makes sense.  I have put the MODIFY OUTPUT code immediately following a function with PROCESS=PRECEDING because I have several tables with the same OMS Subtype name, and I don't know of any way to adequately track them or transfer specific ones to Excel otherwise.  I will tinker with the delay, but I do need SPSS to function at its fastest speed as much as possible due to the volume of models I need to run.   I assume that changing time.sleep(1) would change this to 1 second (to test for speed)?

Thank you so much for your quick response!

I am using the SPSSINC MODIFY OUTPUT command to output TABLES to specific cell locations in Excel using /CUSTOM FUNCTION="customoutputfunctions.excelexport...", with very inconsistent results.  I got my first round of tables to get placed where they need to be, with some tweaking, but I am unable to get additional tables to consistently go or even appear where they need to be.  Sometimes they show up in the excelexport file, and sometimes they do not. I have several repeating charts that require the use of PROCESS=PRECEDING immediately after the function syntax is executed (EXAMINE VARIABLES, FREQUENCIES VARIABLES, etc), instead of using PROCESS=ALL.  I have the guidance previously sent for this Python custom function, but the parameters (file, sheet, action, location, starting cell, etc) do not consistently work, and I've spent several hours testing different combinations.  I am looking for some kind of tutorial or better explanation for how these work and behave.  So far, I am finding their behavior inconsistent for producing the necessary data at the necessary locations needed for further use.

Any more detailed guidance would be greatly appreciated! Thx!

Thanks for the clarification.  This looks really complicated. Where could I access the documentation?

Thanks!  I am now testing using SPSSINC MODIFY OUTPUT on graphs and charts other than tables, but have not cracked the code yet.

After running a pplot command (which successfully goes to the output window every time), here is an example of syntax I am using, but it is not exporting to Excel:

It works!  I tested a range of 0.1 to 2 seconds and all values worked.  I plan to use 0.1 seconds moving forward.  Tables are now loading consistently and in the right places.  One small minor issue that is not a big deal for my functionality is table formatting.  It seems that each table appears in Excel formatted differently.  Some have cells filled in with gray or black, and text ranges from light gray to black, rendering the tables unreadable to humans, but not unreadable to Excel (my target audience).  Is there a command/subcommand that could be added at the end that would remove all fills and make all text black, without manual intervention? I've uploaded an image that shows the disparate fills and text colors.

Thank you for all your help!

Thank you for the explanation.  This makes sense.  I have put the MODIFY OUTPUT code immediately following a function with PROCESS=PRECEDING because I have several tables with the same OMS Subtype name, and I don't know of any way to adequately track them or transfer specific ones to Excel otherwise.  I will tinker with the delay, but I do need SPSS to function at its fastest speed as much as possible due to the volume of models I need to run.   I assume that changing time.sleep(1) would change this to 1 second (to test for speed)?

Thank you so much for your quick response!

I am using the SPSSINC MODIFY OUTPUT command to output TABLES to specific cell locations in Excel using /CUSTOM FUNCTION="customoutputfunctions.excelexport...", with very inconsistent results.  I got my first round of tables to get placed where they need to be, with some tweaking, but I am unable to get additional tables to consistently go or even appear where they need to be.  Sometimes they show up in the excelexport file, and sometimes they do not. I have several repeating charts that require the use of PROCESS=PRECEDING immediately after the function syntax is executed (EXAMINE VARIABLES, FREQUENCIES VARIABLES, etc), instead of using PROCESS=ALL.  I have the guidance previously sent for this Python custom function, but the parameters (file, sheet, action, location, starting cell, etc) do not consistently work, and I've spent several hours testing different combinations.  I am looking for some kind of tutorial or better explanation for how these work and behave.  So far, I am finding their behavior inconsistent for producing the necessary data at the necessary locations needed for further use.

Any more detailed guidance would be greatly appreciated! Thx!

Thanks for the clarification.  This looks really complicated. Where could I access the documentation?

Thanks!  I am now testing using SPSSINC MODIFY OUTPUT on graphs and charts other than tables, but have not cracked the code yet.

After running a pplot command (which successfully goes to the output window every time), here is an example of syntax I am using, but it is not exporting to Excel:

It works!  I tested a range of 0.1 to 2 seconds and all values worked.  I plan to use 0.1 seconds moving forward.  Tables are now loading consistently and in the right places.  One small minor issue that is not a big deal for my functionality is table formatting.  It seems that each table appears in Excel formatted differently.  Some have cells filled in with gray or black, and text ranges from light gray to black, rendering the tables unreadable to humans, but not unreadable to Excel (my target audience).  Is there a command/subcommand that could be added at the end that would remove all fills and make all text black, without manual intervention? I've uploaded an image that shows the disparate fills and text colors.

Thank you for all your help!

Thank you for the explanation.  This makes sense.  I have put the MODIFY OUTPUT code immediately following a function with PROCESS=PRECEDING because I have several tables with the same OMS Subtype name, and I don't know of any way to adequately track them or transfer specific ones to Excel otherwise.  I will tinker with the delay, but I do need SPSS to function at its fastest speed as much as possible due to the volume of models I need to run.   I assume that changing time.sleep(1) would change this to 1 second (to test for speed)?

Thank you so much for your quick response!

I am using the SPSSINC MODIFY OUTPUT command to output TABLES to specific cell locations in Excel using /CUSTOM FUNCTION="customoutputfunctions.excelexport...", with very inconsistent results.  I got my first round of tables to get placed where they need to be, with some tweaking, but I am unable to get additional tables to consistently go or even appear where they need to be.  Sometimes they show up in the excelexport file, and sometimes they do not. I have several repeating charts that require the use of PROCESS=PRECEDING immediately after the function syntax is executed (EXAMINE VARIABLES, FREQUENCIES VARIABLES, etc), instead of using PROCESS=ALL.  I have the guidance previously sent for this Python custom function, but the parameters (file, sheet, action, location, starting cell, etc) do not consistently work, and I've spent several hours testing different combinations.  I am looking for some kind of tutorial or better explanation for how these work and behave.  So far, I am finding their behavior inconsistent for producing the necessary data at the necessary locations needed for further use.

Any more detailed guidance would be greatly appreciated! Thx!