The SECTION/SUMS report does not appear to recalculate when a value is changed.
Because of the size of the file, calculation is done only when the file is initially
opened. If a spreadsheet value is manually changed, hit F9 to recalculate. If an
EXCEL file copy is saved, automatic recalculation can be restored by TOOLS |
OPTIONS | CALCULATION | [select automatic calculation].
The report takes a long time to regenerate and appears to be recalculating frequently.
You have other Excel files open and you have opened them prior to viewing the
EMS reports. Either (1) close all open Excel files (including EMS reports) and
start again with the EMS reports opened first; or (2) use TOOLS | OPTIONS |
CALCULATIONS on the EMS report to reset calculation to MANUAL.
No FTES projections appear for some courses
EMS projects FTES based upon the estimated enrollment values and the
apportionment accounting method in the SECTIONS report. If these columns
have blank or zero values, no projections can be made for the section. Use the
EMS Estimate Enrollment functions to change estimated enrollment values. Use
PeopleSoft to set the apportionment accounting method. Note: The EST flag in
the SECTIONS report advises users of any problems with these fields.
A saved copy of the report doesn’t function properly
EMS spreadsheet reports contain numerous internal and internallyreferencing
formulas. Adding, deleting, or moving rows or columns of data may (is likely to)
corrupt these formulas. Copying and then pasting the spreadsheet as “values”
(Paste Special) will replace the formulas with values and prevent this problem
from occurring. Otherwise, use the entire spreadsheet and add new columns for
additional data analysis.
A saved copy of the SUMS report contains no values
The SUMS report derives its data from the SECTIONS report. If you wish to save
a standalone
copy of the SUMS report, first replace the formulas in the report
with values (COPY | PAST SPECIAL | VALUES).
Expert WordPress Hosting
SiteGround provides superior WordPress hosting focused on speed, security and customer service. We take care of WordPress sites security with unique server-level customizations, WP auto-updates, and daily backups. We make them faster by regularly upgrading our hardware, offering free CDN with Railgun and developing our SuperCacher that speeds sites up to 100 times! And last but not least, we provide real WordPress help 24/7! Learn more about SiteGround WordPress hosting
WordPress tutorial and knowledgebase articles
WordPress is considered an easy to work with software. Yet, if you are a beginner you might need some help, or you might be looking for tweaks that do not come naturally even to more advanced users. SiteGround WordPress tutorial includes installation and theme change instructions, management of WordPress plugins, manual upgrade and backup creation, and more. If you are looking for a more rare setup or modification, you may visit SiteGround Knowledgebase.
Free WordPress themes
SiteGround experts not only develop various solutions for WordPress sites, but also create unique designs that you could download for free. SiteGround WordPress themes are easy to customize for the particular use of the webmaster.
Hi, this is a comment.
To delete a comment, just log in and view the post's comments. There you will have the option to edit or delete them.