Explore the vast range of titles available.

All conference organisers/editors are required to declare details about their peer review. Therefore, please provide the following information: • Type of peer review: Single-blind Single-anonymous: authors’ identities are known to the reviewers, reviewers’ identities are hidden from authors • Describe criteria used by Reviewers when accepting/declining papers. Was there the opportunity to resubmit articles after revisions? We advertised the conference with the expectation that each participant would author or co-author a presentation, and that most presentations would lead to a paper in the proceedings. Peer reviewers were directed to the IOPP Conference Series guidance, including the Proceedings peer review policy. Two peer reviewers were assigned to each paper: care was taken to ensure good mixing of pairings of reviewers. As many of the authors were students or early career researchers, we anticipated that there would be a need for multiple review iterations. Reviewer feedback was intended to be helpful and focussed on the technical content and the clarity of exposition. In addition to review of the technical content, there was also support for using the template, improving the layout of content, and referencing. We encouraged resubmissions and encouraged the authors to make as many improvements as would be feasible within reasonable amount of time. • Conference submission management system: The papers were numbered, and resubmitted versions were also numbered. Progress with the submission and the review process was monitored using a spreadsheet. • Number of submissions received: Initially, there were expected to be 35 papers, but one missed the abstract deadline, two did not register for the conference, and one withdrew after the conference. As a result, 31 paper submissions were received. • Number of submissions sent for review: 31 submissions were sent for review. • Number of submissions accepted: 27 submissions were accepted. • Acceptance Rate (Number of Submissions Accepted / Number of Submissions Received X 100): Acceptance rate = 87% • Average number of reviews per paper: Each paper was reviewed by two reviewers • Total number of reviewers involved: 13 reviewers • Any additional info on review process (ie plagiarism check system): Some support was provided for use of Word templates, English language grammar, checking accuracy of reference information. The two proceedings Editors provided support to reviewers and authors when required. • Contact person for queries: Alison McMillan a.mcmillan@glyndwr.ac.uk

This paper is prompted by and based on earlier research into developers' overconfidence as one of the main causes of spreadsheet errors. Similar to related research, the aim of the paper was to ascertain the existence of overconfidence, and then examine the possibility of its reduction by means of experimental treatment designed for the needs of the research. A quasi-experiment was conducted to this end, in which 62 students of the Faculty of Economics of the University of Novi Sad participated, divided into the experimental and control group. Participants of both groups developed domain free spreadsheets in two iterations each. After the first iterations, students in the experimental group were subjected to experimental treatment: they attended lectures on spreadsheet errors taxonomies supported by real-life examples, and about spreadsheet best practices in the area of spreadsheet error prevention. Results showed that spreadsheet developers who were informed about spreadsheet error taxonomies and spreadsheet best practices create more accurate spreadsheets and are less self-confident in terms of accuracy of their spreadsheets.

Learn to crunch huge amounts of data with PowerPivot and Power QueryDo you have a ton of data you need to make sense of? Microsoft’s Excel program can handle amazingly large data sets, but you’ll need to get familiar with PowerPivot and Power Query to get started. And that’s where Dummies comes in. With step-by-step instructions—accompanied by ample screenshots—Excel PowerPivot & Power Query For Dummies will teach you how to save time, simplify your processes, and enhance your data analysis and reporting. Use Power Query to discover, connect to, and import your organization’s data. Then use PowerPivot to model it in Excel. You’ll also learn to: Make use of databases to store large amounts of dataUse custom functions to extend and enhance Power QueryAdd the functionality of formulas to PowerPivot and publish data to SharePointIf you’re expected to wrangle, interpret, and report on large amounts of data, Excel PowerPivot & Power Query For Dummies gives you the tools you need to get up to speed quickly.

Unlock the power of Excel with a step-by-step roadmap to its formulas and functionsThere's a Swiss Army knife in your digital toolbox that can multiply your productivity and make you the smartest guy or gal in almost any room. It's called Microsoft Excel. If you're like most people, you've barely scratched the surface of what this powerful tool's hundreds of built-in functions can do. But with a little help from Excel Formulas & Functions For Dummies, you'll soon be organizing, analyzing, and interpreting data like a pro. For those who don't know the difference between a spreadsheet and a bedsheet, the book gets you up to speed with formula and function basics first. But you can also skip ahead to the fancy stuff and learn about working with probabilities, significance tests, and lookup functions. This easy-to-use Excel formulas and functions survival guide shows you how to: Work with financial functions like PMT, PPMT, NPER, RATE, and PVCalculate mean, median, mode, standard deviation, and many more statistical functionsTroubleshoot formulas for common errors and validate your data to avoid mistakesWork with dates, times, logic operators, conditions, and basic and advanced mathematical functionsYou don't need a degree in data science or advanced mathematics to take advantage of the full functionality and flexibility of Microsoft Excel. Let Excel Formulas & Functions For Dummies show you how to transform this unassuming program into the most useful tool in your toolbox.

Spreadsheets are commonly used to inform decision making across many business sectors, despite the fact that research performed in the financial sector has shown that they are quite error-prone. However, few studies have investigated spreadsheet errors and their impact in other domains, like the healthcare sector. This article derives a lifecycle-stage classification scheme of spreadsheet error types based on an aggregation of, and extension of, existing classifications. Based on these classifications, a case study is then presented, performed to investigate the prevalence of these spreadsheet error types in an Irish healthcare setting. Results reveal that more than 90% of the spreadsheets studied contained ‘bottom-line' errors and the average cell-error rate was 13%. There was also a correlation between increased perceived impact of the spreadsheets and the number of errors identified. Recommendations from this research include providing spreadsheet training and guidelines for developers and users, and systematically managing and auditing spreadsheet development and use.

Objectives This review fills the paucity of information on K. pneumoniae as a nosocomial pathogen by providing pooled data on epidemiological risk factors, resistant trends and profiles and resistant and virulent genes of this organism in Asia. Methods Exhaustive search was conducted using PubMed, Web of Science, and Google scholar for most studies addressing the prevalence, risk factors, drug resistant-mediated genes and/or virulent factors of K. pneumoniae in Asia. Data extracted for meta-analysis were analyzed using comprehensive meta-analysis version 3. Trends data for the isolation rate and resistance rates were entered into Excel spread sheet and the results were presented in graphs. Results The prevalence rate of drug resistance in K. pneumoniae were; amikacin (40.8%) [95% CI 31.9–50.4], aztreonam (73.3%) [95% CI 59.9–83.4], ceftazidime (75.7%) [95% CI 65.4–83.6], ciprofloxacin (59.8%) [95% CI 48.6–70.1], colistin (2.9%) [95% CI 1.8–4.4], cefotaxime (79.2%) [95% CI 68.0–87.2], cefepime (72.6) [95% CI 57.7–83.8] and imipenem (65.6%) [95% CI 30.8–89.0]. TEM (39.5%) [95% CI 15.4–70.1], SHV-11 (41.8%) [95% CI 16.2–72.6] and KPC-2 (14.6%) [95% CI 6.0–31.4] were some of the resistance mediated genes observed in this study. The most virulent factors utilized by K. pneumoniae are; hypermucoviscous phenotype and mucoviscosity-related genes, genes for biosynthesis of lipopolysaccharide, iron uptake and transport genes and finally, adhesive genes. Conclusion It can be concluded that, antimicrobial resistant in K. pneumoniae is a clear and present danger in Asia which needs strong surveillance to curb this menace. It is very important for public healthcare departments to monitor and report changes in antimicrobial-resistant isolates.