Log in
Language:

MERAL Myanmar Education Research and Learning Portal

  • MERAL
  • Universities
  • Ranking
AND
To


Index Link

Index Tree

WEKO

One fine body…

Item

{"_buckets": {"deposit": "18514cd7-3962-4f05-9cf3-ce4849c69879"}, "_deposit": {"id": "388", "owners": [], "pid": {"revision_id": 0, "type": "recid", "value": "388"}, "status": "published"}, "_oai": {"id": "oai:meral.edu.mm:recid/388"}, "control_number": "388", "item_1583103067471": {"attribute_name": "Title", "attribute_value_mlt": [{"subitem_1551255647225": "Reducing Spread-sheet Calculation Time by using High Performance Computing Cluster", "subitem_1551255648112": "en"}]}, "item_1583103085720": {"attribute_name": "Description", "attribute_value_mlt": [{"interim": "High-performance computing (HPC) encompasses advanced computation over parallel processing, enabling faster execution of highly compute intensive tasks. HPC cluster is an interconnected configuration of servers, typically having 2 or more processing cores per server or node. HPC uses a cluster of servers to split complex computations into smaller tasks that can be calculated in parallel on multiple servers. HPC Services for Excel supports a variety of new programming models to run Excel calculations on an HPC cluster. HPC Services for Excel include service-oriented architecture (SOA) clients and services that enable developers to quickly convert workbooks to run on a cluster. When a workbook runs iteratively, the best option for parallelizing of the calculation is to run the entire workbook in the cluster. Workbooks in Microsoft Excel not only record and display data but also perform computations and simulate complex models. However, as these computations and models increase in size and complexity, the time required for calculation grows and workbook use becomes cumbersome due to long waiting for calculation results. The HPC system is developed to provide users speed-up in Excel calculations on it by reducing in size, complexity and calculation time. This work describes how an HPC cluster can be utilized to run Excel calculations in parallel. Excel includes Visual Basic for Applications (VBA) language. VBA is the tool to develop programs that control Excel. The system is operated by Windows\u00ae HPC Server 2008 R2 and Office Excel 2010 process is used to calculate the workbook in the cluster."}]}, "item_1583103108160": {"attribute_name": "Keywords", "attribute_value_mlt": [{"interim": "High Performance Computing"}]}, "item_1583103120197": {"attribute_name": "Files", "attribute_type": "file", "attribute_value_mlt": [{"accessrole": "open_access", "date": [{"dateType": "Available", "dateValue": "2020-05-05"}], "displaytype": "preview", "filename": "Reducing Spread-sheet Calculation Time.pdf", "filesize": [{"value": "799 Kb"}], "format": "application/pdf", "licensetype": "license_free", "mimetype": "application/pdf"}]}, "item_1583103131163": {"attribute_name": "Journal articles", "attribute_value_mlt": [{"subitem_issue": "1", "subitem_journal_title": "Yadanabon Universithy Research Journal", "subitem_volume": "6"}]}, "item_1583103147082": {"attribute_name": "Conference papaers", "attribute_value_mlt": [{}]}, "item_1583103211336": {"attribute_name": "Books/reports/chapters", "attribute_value_mlt": [{}]}, "item_1583103233624": {"attribute_name": "Thesis/dissertations", "attribute_value_mlt": [{"subitem_supervisor(s)": []}]}, "item_1583105942107": {"attribute_name": "Authors", "attribute_value_mlt": [{"subitem_authors": [{"subitem_authors_fullname": "May Myint Thwe"}]}]}, "item_1583108359239": {"attribute_name": "Upload Type", "attribute_name_i18n": "Upload Type", "attribute_value": "Publication"}, "item_1583108428133": {"attribute_name": "Publication type", "attribute_name_i18n": "Publication type", "attribute_value": "Journal article"}, "item_1583159729339": {"attribute_name": "Publication date", "attribute_name_i18n": "Publication date", "attribute_value": "2016"}, "item_title": "Reducing Spread-sheet Calculation Time by using High Performance Computing Cluster", "item_type_id": "21", "owner": "1", "path": ["1582963788001/1582966639740"], "permalink_uri": "http://hdl.handle.net/20.500.12678/0000000388", "publish_date": "2020-03-05", "publish_status": "0", "recid": "388", "relation": {}, "relation_version_is_last": true, "title": ["Reducing Spread-sheet Calculation Time by using High Performance Computing Cluster"], "weko_creator_id": "1", "weko_shared_id": -1}
  1. Yadanabon University
  2. Department of Computer Science

Reducing Spread-sheet Calculation Time by using High Performance Computing Cluster

Permalink : http://hdl.handle.net/20.500.12678/0000000388
5e1faf1c-2cf2-40f5-8680-6bc2374ef6bf
18514cd7-3962-4f05-9cf3-ce4849c69879
Preview
Name / File License Actions
Reducing Reducing Spread-sheet Calculation Time.pdf (799.1 kB)
sha256: 061df68d00fdfec69d60dc02b618551dda7561a310481d7d2612e090d8b4ce9f
Publication type Journal article
Upload Type Publication
Title
Reducing Spread-sheet Calculation Time by using High Performance Computing Cluster
en
Publication date 2016
Authors
May Myint Thwe
Description
High-performance computing (HPC) encompasses advanced computation over parallel processing, enabling faster execution of highly compute intensive tasks. HPC cluster is an interconnected configuration of servers, typically having 2 or more processing cores per server or node. HPC uses a cluster of servers to split complex computations into smaller tasks that can be calculated in parallel on multiple servers. HPC Services for Excel supports a variety of new programming models to run Excel calculations on an HPC cluster. HPC Services for Excel include service-oriented architecture (SOA) clients and services that enable developers to quickly convert workbooks to run on a cluster. When a workbook runs iteratively, the best option for parallelizing of the calculation is to run the entire workbook in the cluster. Workbooks in Microsoft Excel not only record and display data but also perform computations and simulate complex models. However, as these computations and models increase in size and complexity, the time required for calculation grows and workbook use becomes cumbersome due to long waiting for calculation results. The HPC system is developed to provide users speed-up in Excel calculations on it by reducing in size, complexity and calculation time. This work describes how an HPC cluster can be utilized to run Excel calculations in parallel. Excel includes Visual Basic for Applications (VBA) language. VBA is the tool to develop programs that control Excel. The system is operated by Windows® HPC Server 2008 R2 and Office Excel 2010 process is used to calculate the workbook in the cluster.
Keywords
High Performance Computing
Files 799 Kb
Available
2020-05-05
application/pdf
preview
application/pdf
open_access
Reducing Spread-sheet Calculation Time.pdf

Journal articles
1
Yadanabon Universithy Research Journal
6
Conference papaers
Books/reports/chapters
Thesis/dissertations
Back
0
0
views
downloads
See details
Views Downloads

Versions

Ver.1 2020-03-08 07:58:52.286812
Show All versions

Share

Mendeley CiteULike Twitter Facebook Print Addthis

Export

OAI-PMH
  • OAI-PMH DublinCore
Other Formats
  • JSON

Confirm


Back to MERAL


Back to MERAL