EXCEL Program

  1. This template was developed in EXCEL 2016 environment. We recommend users to use Office 2016 or higher versions to ensure full functionality and avoid unpredictable errors.
    EXCEL users should use XLCS Core V7.2 Full Cost Calculation Template_Excel Edition.xlsm for better performance!
    We recommend purchasing genuine Office software from Microsoft’s official website:
    https://www.microsoft.com/zh-cn/download/office
    Temporary trial users can search for “office2016 permanent activation code” on Taobao (typically priced at 5-15 RMB). After purchase, the seller will provide:

    Installation guide:

    • Right-click the downloaded file → Extract → Run “setup”
    • Enter the activation key when prompted
    • If activation limit is reached, select “Phone Activation” → Choose China → Send the 9-group ID to the seller

  2. XLSM files contain macros. To fully use this template:

    • Enable VBA editor: File → More → Options → Customize Ribbon → Main Tabs → Developer → Add to right panel
      Add VBA Editor
    • Add references: Developer → VB Editor → Tools → References → Select required items
      Add VBA References

  3. Macro Security Settings:

    • File → More → Options → Trust Center → Trust Center Settings → Macro Settings → Enable All Macros
      Modify Macro Settings

  4. Enable automatic calculation:

    • File → More → Options → Formulas → Enable “Automatic Calculation” and “Iterative Calculation”
      Calculation Settings

WPS Program

  1. WPS uses JS language which may not support VBA. Use XLCS Core V7.2 Full Cost Calculation Template_WPS Edition.xlsm for full functionality.

  2. Recommended WPS professional editions:

    • WPS2019 State Grid Edition
    • WPS2019 Wuhan Government Edition
    • WPS2019 Postal Enterprise Edition

  3. For free WPS versions:

    • When opening the template, click “Get VBA Macro Permission”
      WPS Prompt
    • WPS Super Membership is required for full functionality
      WPS Membership

  4. Without Super Membership:

    • Install the WPS VBA plugin (wps.vba.rar) from the package
    • After installation, click “Continue” and “Enable Macros”
      WPS Plugin

  5. To disable repetitive prompts:
    WPS Options

  6. Enable automatic calculation in WPS:

    • Start → Options → Recalculation → Enable “Automatic Calculation” and “Iterative Calculation”
      WPS Calculation

  7. If macros are blocked:

    • Right-click the file → Properties → Unblock under Security options

  8. Macro Security in WPS:

    • Tools → Macros → Security → Set to Medium or Low (not recommended long-term)
      WPS Macro Settings

  9. External links prompt:

    • Click “Update” to automatically connect to cloud city database

  10. Enable VBA in WPS:

    • File → More → Options → Customize Ribbon → Developer → Add to right panel
      WPS VBA Editor
    • Add references: Developer → VB Editor → Tools → References
      WPS References

  11. Now all XLCS WPS features are ready for use.

Official Websites:
http://fccs.cc
http://fckcs.cn
http://fckcs.com
http://fdc.sd
http://fccsz.com
http://cskits.com

Support:
http://xlcs.de/
Leave comments or email: mailto:admin@fdc.sd