Abstract: This paper discusses the implementation of the boundary element method (BEM) on an Excel spreadsheet and how it can be used in teaching vector calculus and simulation. There are two separate spreadheets, within which Laplace equation is solved by the BEM in two dimensions (LIBEM2) and axisymmetric three dimensions (LBEMA). The main algorithms are implemented in the associated programming language within Excel, Visual Basic for Applications (VBA). The BEM only requires a boundary mesh and hence it is a relatively accessible method. The BEM in the open spreadsheet environment is demonstrated as being useful as an aid to teaching and learning. The application of the BEM implemented on a spreadsheet for educational purposes in introductory vector calculus and simulation is explored. The development of assignment work is discussed, and sample results from student work are given. The spreadsheets were found to be useful tools in developing the students’ understanding of vector calculus and in simulating heat conduction.
Abstract: This article interrogates the question of leadership in the context of the antidemocratic tendencies of Africa’s political leaders. The African continent has continued to struggle behind other continents of the world as a result of the failure of leadership to address the political and socio-economic challenges of the continent. Thus, bedevilled with the challenges of development, the African continent is in need of people-centred leadership. However, as the continent struggles to overcome its political and development predicaments, it is stuck in the dystopia of demagoguery that promises nothing but apocalyptic future for its teeming population. Thus, despite the enormous resources available in Africa, leadership failures have made progress difficult to achieve. At the centre of this leadership failure are demagogues: a set of leaders who have influence over a large number of people but take advantage of that influence to undermine democracy and good governance. Citing various examples across Africa, the article describes how demagogues, especially in democratic countries, have become the problem of the African continent in its quest to achieve democratic progress, development and peaceful progress.
Abstract: This study, for its research subjects, uses patients who
had undergone total knee replacement surgery from the database of the
National Health Insurance Administration. Through the review of
literatures and the interviews with physicians, important factors are
selected after careful screening. Then using Cross Entropy Method,
Genetic Algorithm Logistic Regression, and Particle Swarm
Optimization, the weight of each factor is calculated and obtained. In
the meantime, Excel VBA and Case Based Reasoning are combined
and adopted to evaluate the system. Results show no significant
difference found through Genetic Algorithm Logistic Regression and
Particle Swarm Optimization with over 97% accuracy in both
methods. Both ROC areas are above 0.87. This study can provide
critical reference to medical personnel as clinical assessment to
effectively enhance medical care quality and efficiency, prevent
unnecessary waste, and provide practical advantages to resource
allocation to medical institutes.
Abstract: The main function of Medium Access Control (MAC) is to share the channel efficiently between all nodes. In the real-time scenario, there will be certain amount of wastage in bandwidth due to back-off periods. More bandwidth will be wasted in idle state if the back-off period is very high and collision may occur if the back-off period is small. So, an optimization is needed for this problem. The main objective of the work is to reduce delay due to back-off period thereby reducing collision and increasing throughput. Here a method, called the virtual back-off algorithm (VBA) is used to optimize the back-off period and thereby it increases throughput and reduces collisions. The main idea is to optimize the number of transmission for every node. A counter is introduced at each node to implement this idea. Here counter value represents the sequence number. VBA is classified into two types VBA with counter sharing (VBA-CS) and VBA with no counter sharing (VBA-NCS). These two classifications of VBA are compared for various parameters. Simulation is done in NS-2 environment. The results obtained are found to be promising.
Abstract: Cost of governance in Nigeria has become a challenge
to development and concern to practitioners and scholars alike in the
field of business and social science research. In the 2010 national
budget of NGN4.6 trillion or USD28.75billion for instance, only a
pantry sum of NGN1.8trillion or USD11.15billion was earmarked for
capital expenditure. Similarly, in 2013, out of a total national budget
of NGN4.92trillion or USD30.75billion, only the sum of
NGN1.50trllion or USD9.38billion was voted for capital expenditure.
Therefore, based on the data sourced from the Nigerian Office of
Statistics, Central bank of Nigeria Statistical Bulletin as well as from
the United Nations Development Programme, this study examined
the causes of high cost of governance in Nigeria. It found out that the
high cost of governance in the country is in the interest of the ruling
class, arising from their unethical behaviour – corrupt practices and
the poor management of public resources. As a result, the study
recommends the need to intensify the war against corruption and
mismanagement of public resources by government officials as
possible solution to overcome the high cost of governance in Nigeria.
This could be achieved by strengthening the constitutional powers of
the various anti-corruption agencies in the area of arrest, investigation
and prosecution of offenders without the interference of the executive
arm of government either at the local, state or federal level.
Abstract: The scope of this paper is to evaluate and compare the potential of LS-PV(Large Scale Photovoltaic Power Plant) power generation systems in the southern region of Libya at Al-Kufra for both stationary and tracking systems. A Microsoft Excel-VBA program has been developed to compute slope radiation, dew-point, sky temperature, and then cell temperature, maximum power output and module efficiency of the system for stationary system and for tracking system. The results for energy production show that the total energy output is 114GWh/year for stationary system and 148GWh/year for tracking system. The average module efficiency for the stationary system is 16.6% and 16.2% for the tracking system.
The values of electricity generation capacity factor (CF) and solar capacity factor (SCF) for stationary system were found to be 26% and 62.5% respectively and 34% and 82% for tracking system. The GCR (Ground Cover Ratio) for a stationary system is 0.7, which corresponds to a tilt angle of 24°. The GCR for tracking system was found to be 0.12. The estimated ground area needed to build a 50MW PV plant amounts to approx. 0.55km2 for a stationary PV field constituted by HIT PV arrays and approx. 91MW/ km2. In case of a tracker PV field, the required ground area amounts approx.2.4km2 and approx. 20.5MW/ km2.
Abstract: This paper investigates the application of large scale (LS-PV) two-axis tracking photovoltaic power plant in Al-Jagbob, Libya. A 50MW PV-grid connected (two-axis tracking) power plant design in Al-Jagbob, Libya has been carried out presently. A hetero-junction with intrinsic thin layer (HIT) type PV module has been selected and modeled. A Microsoft Excel-VBA program has been constructed to compute slope radiation, dew-point, sky temperature, and then cell temperature, maximum power output and module efficiency for this system, for tracking system. The results for energy production show that the total energy output is 128.5 GWh/year. The average module efficiency is 16.6%. The electricity generation capacity factor (CF) and solar capacity factor (SCF) were found to be 29.3% and 70.4% respectively. A 50MW two axis tracking power plant with a total energy output of 128.5 GWh/year would reduce CO2 pollution by 85,581 tonnes of each year. The payback time for the proposed LS-PV photovoltaic power plant was found to be 4 years.
Abstract: Off-grid Photovoltaic (PV) systems are empowering
technology in underdeveloped countries like Ethiopia where many
people live far away from the modern world. Where there is
relatively low energy consumption, providing energy from grid
systems is not commercially cost-effective. As a result, significant
people groups worldwide stay without access to electricity. One
remote village in northern Ethiopia was selected by the United
Nations for a pilot project to improve its living conditions. As part of
this comprehensive project, an intelligent charge controller circuit for
Off-grid PV systems was designed for the clinic in that village. In
this paper, design aspects of an intelligent charge controller unit and
its load driver circuits are discussed for an efficient utilization of PVbased
supply systems.