Using Spreadsheets for Management Tasks

Author(s):  
Dr Cathy Burgess

In this chapter we will see how using spreadsheets can help you with many of the control tasks that we have discussed in the different chapters. We’ll also see how you can use graphs and charts (hand-drawn and by spreadsheet) to help in decision-making and presenting results. We will look at some of the simple techniques that can make spreadsheets easier to use on a frequent basis and at some of the shortcuts you can take. Incorporating some basic design features can help with ongoing usage, and with enabling others to use spreadsheets that you have designed. The use of charts and how they can help with presenting complex information in a simpler way will also be considered. It’s assumed that you have a basic knowledge of spreadsheets. If some of this is boring because you’re at a higher level of competence, then please move on. There’s a refresher exercise to revise skills and perhaps practise some new ones, and some suggestions about using spreadsheets for personal tasks. By the end of this chapter, therefore, you should be able to: - Comprehend the basic principles of spreadsheet design - Practise a range of techniques to improve speed and efficiency - Comprehend the variety of areas where spreadsheets can be used - Draw a chart to scale by hand - Create a chart using a spreadsheet.

2017 ◽  
Vol 22 (2) ◽  
pp. 233-255
Author(s):  
Sven Nyholm

AbstractIt is commonly thought that on Kant’s view of action, ‘everyone always acts on maxims’. Call this the ‘descriptive reading’. This reading faces two important problems. First, the idea that people always act on maxims offends against common sense: it clashes with our ordinary ideas about human agency. Second, there are various passages in which Kant says that it is ‘rare’ and ‘admirable’ to firmly adhere to a set of basic principles that we adopt for ourselves. This article offers an alternative: the ‘normative reading’. On this reading, it is a normative ideal to adopt and act on maxims: it is one of the things we would do if our reason were fully in control of our decision-making.


2020 ◽  
Vol 32 (2) ◽  
pp. 223-242
Author(s):  
Fariza Romli ◽  
◽  
Harlida Abdul Wahab

The existence of a tribunal system, in addition to helping to smooth the administration system, is considered as sharing power with the judiciary in making decisions. Thus arose the question of decision- making power and prevention of abuse by the administrative body. In line with the Sustainable Development Goals 2030 to ensure justice in support of effective, responsible and inclusive institutions, transparent and fair practices are essential for ensuring people’s trust in the administrative body and government. This paper, therefore, discusses the tribunal system and its implementation in Malaysia. In view of this, tribunal systems that exist in other countries, especially the United Kingdom, are also examined as models for improvement. Matters such as autonomy or control of power and the trial process are among the issues raised. Recommendations for improvement are proposed based on three basic principles—openness, fairness and impartiality—to further strengthen the implementation of the existing tribunal system in line with developments abroad.


2018 ◽  
Vol 228 ◽  
pp. 05002 ◽  
Author(s):  
Yihan Wang

The problems of multi-objective decision making are analysed and studied. In order to solve its optimization problems, the basic principles and application steps of TOPSIS and AHP are introduced in this paper. Then some practical examples are given to show how to apply these two new methods in multi-objective decision making problems. Finally, the advantage and feasibility of the TOPSIS and AHP methods are demonstrated by theoretical analysis.


Author(s):  
John A. Sauceda ◽  
Karine Dubé ◽  
Brandon Brown ◽  
Ashley E. Pérez ◽  
Catherine E. Rivas ◽  
...  

HIV cure research carries serious risks and negligible benefits. We investigated how participants understand these risks and what influences their willingness to participate. Through internet-based and in-person convenience sampling, 86 HIV+ participants completed an experimental survey. Participants were randomized to read a standard consent form describing a hypothetical HIV cure study or one adapted using Fuzzy Trace Theory—a decision-making model to facilitate complex information processing. We measured consent understanding and cognitive (e.g., safe/harmful) and affective (e.g., concerning, satisfying) evaluations of HIV cure research. Participants who read the adapted consent form had improved consent understanding, but only positive affective evaluations were associated with a willingness to participate. Consent processes can use decision-making theories to facilitate comprehension of study information.


2020 ◽  
Vol 38 (4) ◽  
pp. 987-1005 ◽  
Author(s):  
Yao Song ◽  
Yan Luximon ◽  
Jing Luo

PurposeThe purpose of this study is to test the theoretical framework of lettering case, color temperature, perceived trustworthiness and investment intentions. First, it aims to test whether the effect of lettering case on investment intentions is mediated by trustworthiness. Second, the study will examine if this process is moderated by color temperature.Design/methodology/approachFollowing the behavioral research method, this study employed a 2 (the fully-lowercase slogan vs the initial-uppercase slogan) by 2 (warm-color design vs cool-color design) full factorial between-subject design. Two hundred participants were recruited for the experiment to test the hypotheses.FindingsFor the lowercase slogans (vs uppercase slogans), we found that people tended to have a high level of perceived trustworthiness, which led to a high level of investment intentions. In addition, the indirect effect of the lettering case on investment intentions through the perceived trustworthiness was moderated by color temperature. Specifically, the visually warm advertisement (vs visually cool design) would strengthen the effect of lowercase slogans on customers' investment intentions.Originality/valueWhen people make a financial decision with limited, incomplete or overly complex information, simplified visual heuristics, rather than rational algorithmic processing, play a significant role in their decision-making process. However, only a limited amount of research has addressed the effect of the lettering case on customers' perceptions and the consequent decision-making process from a financial advertising perspective. This study tries to supplement and extend the visual heuristics theory, highlighting the role of simplified heuristics, rather than rational algorithmic processing, in financial customers' decision-making process.


2019 ◽  
Vol 67 ◽  
pp. 06039
Author(s):  
Olga Novikova ◽  
Yaroslav Ostafiichuk ◽  
Olena Khandii ◽  
Marina Deich

The article defines the conceptual vision of the policy of implementing social and labor potential of the population with decentralization, formulates its basic principles as guidelines for practical actions. Essence and role of inter-municipal cooperation for intensification of social potential of communities are revealed, possible ways of its institutional support are suggested. It is found that decentralization processes require effective instruments for coordinating interests, and social mobilization plays an important role in this, which is to involve a maximum number of people in solving community problems and participating in decision making. It is concluded that social potential may turn into a decisive factor in the development of a territorial community in the implementation of the following principles: comparativeness and competitiveness; motivation; social connections and inclusion; mutual responsibility; network availability; openness and transparency; value orientation; individual social interaction; limited solidarity.


Symmetry ◽  
2018 ◽  
Vol 10 (11) ◽  
pp. 590 ◽  
Author(s):  
Xiaohui Wu ◽  
Jie Qian ◽  
Juanjuan Peng ◽  
Changchun Xue

Single valued trapezoidal neutrosophic numbers (SVTNNs) are very useful tools for describing complex information, because of their advantage in describing the information completely, accurately and comprehensively for decision-making problems. In the paper, a method based on SVTNNs is proposed for dealing with multi-criteria group decision-making (MCGDM) problems. Firstly, the new operations SVTNNs are developed for avoiding evaluation information aggregation loss and distortion. Then the possibility degrees and comparison of SVTNNs are proposed from the probability viewpoint for ranking and comparing the single valued trapezoidal neutrosophic information reasonably and accurately. Based on the new operations and possibility degrees of SVTNNs, the single valued trapezoidal neutrosophic power average (SVTNPA) and single valued trapezoidal neutrosophic power geometric (SVTNPG) operators are proposed to aggregate the single valued trapezoidal neutrosophic information. Furthermore, based on the developed aggregation operators, a single valued trapezoidal neutrosophic MCGDM method is developed. Finally, the proposed method is applied to solve the practical problem of the most appropriate green supplier selection and the rank results compared with the previous approach demonstrate the proposed method's effectiveness.


2018 ◽  
pp. 1-12
Author(s):  
Henry Ddungu ◽  
Elizabeth M. Krantz ◽  
Warren Phipps ◽  
Sandra Naluzze ◽  
Jackson Orem ◽  
...  

Purpose Optimal decision making regarding blood transfusion for patients with cancer requires appropriate knowledge of transfusion medicine among physicians. We assessed blood transfusion knowledge, attitudes, and reported practices among physicians working at Uganda Cancer Institute (UCI). Materials and Methods A cross-sectional self-administered survey of UCI physicians on their knowledge, attitudes, and practices regarding blood transfusion was conducted from June to September 2014. In consultation with transfusion medicine experts, 30 questions were developed, including 10 questions for each of the following three domains: knowledge, attitudes, and practices. For the knowledge domain, we created a knowledge score equal to the number of questions correctly answered out of 10. Results Of 31 physicians approached, 90% participated. The mean knowledge score was 5.3 (median, 5.5), and 32% correctly answered at least seven of 10 questions. Almost all (96%) understood the importance of proper patient identification before transfusion and indicated identification error as the most common cause of fatal transfusion reactions. More than 60% of physicians acknowledged they lacked knowledge and needed training in transfusion medicine. Most physicians reported sometimes changing their mind about whether to provide a patient with a transfusion on the basis of opinion of colleagues and sometimes administering unnecessary transfusions because of influence from others. Conclusion Although UCI physicians have some basic knowledge in transfusion, most reported gaps in their knowledge, and all expressed a need for additional education in the basics of blood transfusion. Transfusion training and evidence-based guidelines are needed to reduce inappropriate transfusions and improve patient care. Greater understanding of peer influence in transfusion decision making is required.


1982 ◽  
Vol 36 (2) ◽  
pp. 457-478 ◽  
Author(s):  
Benjamin J. Cohen

The regime for payments financing embedded in the postwar Bretton Woods system was based on the principle, formally articulated in the Charter of the International Monetary Fund (IMF), that nations should be assured of an adequate but not unlimited supply of supplementary financing for balance-of-payments purposes. Norms included the obligation to avoid policies inconsistent with the IMF Charter (i.e., to play by the agreed rules of the game). In the 1970s the regime seemingly underwent profound change, as the private credit markets emerged as an increasingly important rival to the IMF as a source of payments financing. Nonetheless, this change fell short of a transformation of kind, insofar as the Fund continues to play a role as informal certifier of creditworthiness in the markets. Rather, it represents an example of ‘norm-governed change.’ Despite greater ambiguity in rules and decision-making procedures, a strong element of continuity in basic principles and norms remains.


2012 ◽  
Vol 1 (1) ◽  
pp. 19-32 ◽  
Author(s):  
A. Francisca Snoeck Henkemans ◽  
Dima Mohammed

In this paper it is first investigated to what extent the institutional goal and basic principles of shared decision making are compatible with the aim and rules for critical discussion. Next, some techniques that doctors may use to present their own treatment preferences strategically in a shared decision making process are discussed and evaluated both from the perspective of the ideal of shared decision making and from that of critical discussion.


Sign in / Sign up

Export Citation Format

Share Document