...Working with Excel files in Python Chris Withers with help from John Machin EuroPython 2009, Birmingham The Tutorial Materials These can be obtained by CD, USB drive or downloaded from here: • http://www.simplistix.co.uk/presentations/europython2009excel.zip The Website The best place to start when working with Excel files in Python is the website: • http://www.python-excel.org © Simplistix Ltd 2009 Page 2 License THE WORK (AS DEFINED BELOW) IS PROVIDED UNDER THE TERMS OF THIS CREATIVE COMMONS PUBLIC LICENCE ("CCPL" OR "LICENCE"). THE WORK IS PROTECTED BY COPYRIGHT AND/OR OTHER APPLICABLE LAW. ANY USE OF THE WORK OTHER THAN AS AUTHORIZED UNDER THIS LICENCE OR COPYRIGHT LAW IS PROHIBITED. BY EXERCISING ANY RIGHTS TO THE WORK PROVIDED HERE, YOU ACCEPT AND AGREE TO BE BOUND BY THE TERMS OF THIS LICENCE. THE LICENSOR GRANTS YOU THE RIGHTS CONTAINED HERE IN CONSIDERATION OF YOUR ACCEPTANCE OF SUCH TERMS AND CONDITIONS. This Creative Commons England and Wales Public Licence enables You (all capitalised terms defined below) to view, edit, modify, translate and distribute Works worldwide for Non-Commercial purposes under the terms of this Licence, provided that You credit the Original Author. 'The Licensor' [one or more legally recognised persons or entities offering the Work under the terms and conditions of this Licence] and 'You' agree as follows: 1. Definitions a) b) "Attribution" means acknowledging all the parties who have contributed to and have rights in the...
Words: 12667 - Pages: 51
...EXCEL DIGI LAB Hemant Yashwant Satpute Electronic Science Department, Fergusson College, Pune 4 [Affiliated to University of Pune] India (Maharashtra) hys0671@rediffmail.com Abstract Being a teacher, my aim is to always encourage students and other colleague teachers to make optimum use of PC machine which one has purchased and full functionality of the softwares available with that machine. As an example, here I am illustrating use of EXCEL to learn Digital Electronics. One can verify Truth tables and study the working of various logic gates (AND, OR, NOT, EXOR, EXNOR, NAND, NOR), Various combinational logic circuits like Half Adder, Full Adder, Controlled Inverter, Multi bit adder, Multi bit subtractor, Multi bit adder Subtractor, Multiplexers, Demultiplexers, Shift Registers, Flip flops, Counters, Parity Generators and checkers using EXOR gates, Encoders, Decoders, Controlled Inverter using EXOR gates and their uses and many more, by entering inputs directly and verifying outputs at various intermediate stages. One can also study use of universal gates to build various logic functions with the help of this tool. These outputs are derived by using various functions built in EXCEL. This was demonstrated to teachers and students. This idea helps teachers to make subject more illustrative and interesting. It has been proved to be an excellent tool for innovative class room teaching. This can be used as a learning material for open source learning and distance...
Words: 2004 - Pages: 9
...Ordering a service or product Teacher’s notes TIME: 50 minutes SKILLS: speaking, reading, writing AIM: to practise language related to describing products and services in a sales context MATERIALS: one copy of the worksheet per student; one set of question and answer strips and one Star Limo Ltd. leaflet per pair of students; flip chart or whiteboard; pens; internet access or printed copies of the Amazon homepage (www.amazon.co.uk) per pair of students difference: a product is something you can use, see, hold, or touch while a service is something a company provides or does for the customer that doesn’t involve selling them a physical product. Distribute the copies of the Amazon homepage, go to the homepage on your class laptop or ask the students to access the page on their phones, tablets or laptops. In pairs, ask the students to list three products and three services on the Amazon website (www.amazon.co.uk). Write the following on the flipchart or whiteboard to guide them: Online shopping on Amazon Products 1 2 3 Grammar use of the present simple for description review of do in forming questions Useful words and phrases As a warm-up activity, ask students how they shop: in person or online? Which do they prefer? Why? What kind of products and services can be ordered online? Then, ask them to give an example of a product and a service that they use. Check their understanding of the © Macmillan Publishers Ltd 2013 BUSINESS /...
Words: 1886 - Pages: 8
...G062 Similar but Different Answers – 2014-15 CONTENTS INTRODUCTION ............................................................................................................................... 3 Task 1 – RELATIONAL DATABASE .................................................................................................... 4 1ai – Import data..................................................................................................................... 4 1aii – Relationships ................................................................................................................. 6 1bi – Church form ................................................................................................................... 7 1bii – Campers form................................................................................................................ 8 1biii – Camper photographs ................................................................................................... 9 1biv – Church details on Camper form ................................................................................. 11 1ci – Booking form ................................................................................................................ 14 1cii – Booking form annotation ............................................................................................ 15 1di – Adult campers report ........................................................................................
Words: 4923 - Pages: 20
...CALABAR HIGH SCHOOL CSEC INFORMATION TECHNOLOGY (General Proficiency) School Based Assessment SPREADSHEET ------------------------------------------------- Description of Project It takes 90 seconds or less for a car thief to take your vehicle. It is no longer enough to just roll-up your windows and lock your doors. Although few stolen vehicles are recovered within 48 -72 hours, the damage has already been done. The Spartahouse City Council in collaboration with the Spartahouse Police Department is encouraging residents to protect their vehicles. This is due to the fact that Incidents of Grand Theft Auto in the city have spiked by over 35% over the last year. There is work to be done to educate citizens on how to protect their vehicles to reduce this particular crime even more. The council has been approached by the National Motor vehicle Theft Reduction Organization NMTRO and has planned to launch a campaign entitled “PROTECT YOUR VEHICLE". The program is specifically targeted at encouraging owners of high risk vehicles to install immobilizers and other antitheft devices. NMTRO works with other stakeholders to develop and implement countermeasures that will impede the activities of organized criminals. In the city and surrounding suburbs, any make or model of car is subject to theft. Toyota and Nissan models made between 2005 and 2012 and Honda products are the most vulnerable for being stolen. The City has hired a team of specialist to analyze...
Words: 2817 - Pages: 12
...Form 5 Nature Table of Contents Introduction Synopsis Elements Activities Assessment Answer Key Glossary Panel of writers NATURE POETRY The Poet Flag of Jamaica Map of Jamaica Hugh Doston Carberry, 1921-1989, was educated at Jamaica College before going to Oxford University. He worked as a Barrister of Law and was later appointed a Judge of the Court of Appeal, where he remained until his retirement at the age of 67. Synopsis This poem is about celebration. It is a descriptive poem about the changing scenes. It celebrates the richness of the land’s produce and how alive and plentiful Nature is. However, amidst the harsh rain and lashing wind, things are always bright and glorious when the sun shines again. NATURE POETRY SETTING The poem is set in Jamaica. The poet uses nature and describes the weather being hot and wet. The poet also uses trees, bushes, flowers, and fruits to portray nature as alive and abundant. The...
Words: 4432 - Pages: 18
...MS-EXCEL FOR CHARTERED ACCOUNTANTS SUNIL B GABHAWALLA CHARTERED ACCOUNTANT WESTERN INDIA REGIONAL COUNCIL OF THE INSTITUTE OF CHARTERED ACCOUNTANTS OF INDIA TABLE OF CONTENTS 1 2 Basics & Beyond......................................................................................................... 4 1.1 Introduction......................................................................................................... 4 1.2 The EXCEL Screen............................................................................................. 4 1.3 Moving Around................................................................................................... 5 Data Entry ................................................................................................................... 8 2.1 Text ..................................................................................................................... 8 2.2 Number (including date, time, percent) .............................................................. 8 2.3 Formulae ............................................................................................................. 8 2.4 Functions............................................................................................................. 9 2.5 AutoComplete ..................................................................................................... 9 2.6 AutoCorrect........................................................................................
Words: 16077 - Pages: 65
...------------------------------------------------- University of Phoenix Material Earth and Earth Materials I Worksheet From Visualizing Earth Science, by Merali, Z., and Skinner, B. J, 2009, Hoboken, NJ: Wiley. Copyright 2009 by Wiley. Adapted with permission. Part 1 Complete the WileyPLUS® GeoDiscoveries Earth Drag and Drop from Chapter 1. Label and describe each letter in the space below. A B C D E F G H A. Ocean | B. Continental crust | C. Oceanic crust | D. Solid inner core | E. Liquid outer core | F. Mesosphere | G. Anthenosphere | H. Lithosphere | Part 2 Resources: Minerals Drag and Drop (Chapter 2) Virtual Rock Lab (Chapter 2) * * Complete the following WileyPLUS® GeoDiscoveries and answer the following questions: What is the difference between a rock and a mineral? A mineral is a naturally going on the non-living compound with a unique chemical structure and the physical properties. An the rock is a solid, rocky mass composed of a combination of minerals or other organic complex. 1. 2. What types of tests are used to identify minerals? The type of test that are used to identify a mineral is I think depending on the colour,luster, and the hardness and as well the gravity. Also by the event test the chemical of the mineral they can see what type it is. 3. Part 3 1. Label the part and mineral resource that compose each part of this lightbulb. Refer...
Words: 903 - Pages: 4
...Display the largest value | =min(B12:B18) | Display the smallest value | =B4*C4 | Multiplies the values | This is not an exhaustive list. See Excel menu command fx for a complete list of functions | User created | (…)+-*/^ | Mathematic operations brackets sum, subtract, multiplydivideexponentiation (power)=(3*(A5+B5)-C5)/2+D5^1.5 | Exercise 1 Using appropriate formulae, complete the table below in Excel. Item Name | price | Commission | Camera | $150.00 | $ 15.00 | Omega | $120.00 | | Kodak | $130.00 | | Sony | $140.00 | | F | $95.00 | | Canon | $150.00 | | JVC | $210.00 | | Total | $845.00 | | | | | Commission Rate: | 10% | | Exercise 2 Complete the personal budget worksheet for the period indicated. Add your own figures where there are spaces. Extend the table to include a full calendar year. Personal Budget | | | | Monthly Expenses | Jan | Feb | Mar | Rent | $850.00 | $850.00 | $850.00 | Groceries | $691.00 | $527.00 | $709.00 | Electricity | $85.00 | $54.00 | $73.00 | Water | $33.00 | $33.00 | $33.00 | Clothing | $250.00 | $75.00 | $163.00 | Transport | $85.00 | $95.00 | $140.00 | Entertainment | $125.00 | | | Totals | $2,119.00 | | | Fixed Income | $3,500.00 | | | Savings | | | | Exercise 3 The table shows green...
Words: 2177 - Pages: 9
...Glossary Panel of Writers [pic] SHORT STORY Welcome to the World of Literature and to Short Stories! We hope you will enjoy working with this guidebook, which has been specially designed to help you prepare your students enjoy the Literature Component of the KBSM English Language syllabus. A brief explanation of the short story genre has been provided together with suggested activities, teaching steps and worksheets/handouts. An answer key with suggested answers has been provided at the end of the guide to assist you. There is also an assessment section with contextual questions and ideas for authentic assessment and a glossary at the end of each story. We recommend that the activities in this guidebook be adapted for your students’ needs and be carried out creatively in order to develop students’ appreciation and critical analysis of the short stories. Be ready to listen to students’ views and opinions, and encourage them to work out the answers. It is our sincere hope that the activities and worksheets in this guidebook will act as a springboard for your own ideas and methods of exploring the individual stories. SHORT STORY What is a Short Story? Can you explain what makes a short story? Well, a short story is a short piece of fiction aiming at unity of characterization, theme and effect. It aims to produce a single narrative effect with the greatest economy of means and utmost emphasis. Did you know that modern short...
Words: 6476 - Pages: 26
...CHAPTER 1 What Is Financial Modelling? here are all sorts of complicated definitions of financial modelling, and in my experience there is quite a bit of confusion around what a financial model is exactly. A few years ago, we put together a Plum Solutions survey about the attitudes, trends, and uses of financial modelling, asked respondents “What do you think a financial model is?” Participants were asked to put down the first thing that came to mind, without any research or too much thinking about it. I found the responses interesting, amusing, and sometimes rather disturbing. Some answers were overly complicated and highly technical: n T n n n n “Representation of behaviour/real-world observations through mathematical approach designed to anticipate range of outcomes.” “A set of structured calculations, written in a spreadsheet, used to analyse the operational and financial characteristics of a business and/or its activities.” “Tool(s) used to set and manage a suite of variable assumptions in order to predict the financial outcomes of an opportunity.” “A construct that encodes business rules, assumptions, and calculations enabling information, analysis, and insight to be drawn out and supported by quantitative facts.” “A system of spreadsheets and formulas to achieve the level of record keeping and reporting required to be informed, up-to-date, and able to track finances accurately and plan for the future.” Some philosophical: n “A numerical...
Words: 17366 - Pages: 70
...2011, 2012 and 2013. ‘Shoplifting’ is undoubtedly a psychological issue for most of the people. Shoplifting for most individuals is rarely about greed or poverty. It’s about people struggling with their own personal conflicts and needs. There are approximately 27 million shoplifters (or 1 in 11 people) in the USA today. More than 10 million people have been caught shoplifting in the last five years. The pleasure produced from “getting away with it” yields a chemical reaction causing in what shoplifters describe as an incredible “rush” or “high” feeling. Many shoplifters have committed to the fact that this high is their “true reward,” rather than the stolen product itself. It is assumed in this project that all the shoplifting instances in different states of the USA have been performed by the front-end Retail Salesperson. This might not be 100% true as the members of the Retail Store management of a company may also get themselves involved in such heinous crime, but this possibility has been disregarded. Data from the three aforementioned sources were compiled according to the respective states, years and concrete data-sets were formulated. MS Excel’s TreePlan was then used to create Decision tree models in order to determine whether the Retail...
Words: 3519 - Pages: 15
...S.NO. | CONTENT | PAGE.NO | 1. | ABSTRACT | 1 | 2. | INTRODUCTION | 2 | 3. | CUSTOMER FOCUS | 3 | 4. | CUSTOMER RELATIONSHIP MANAGEMENT | | 5. | CONCLUSION | | CUSTOMER FOCUS AND RELATIONSHIP MANAGEMENT CUSTOMER FOCUS AND RELATIONSHIP MANAGEMENT 1.Abstract CRM (Customer Relationship Management), sometimes it is called customer management, customer value management, customer centricity, and customer-centric management. CRM has long been the buzzword for airlines aspiring to 'one-to-one' relationships with all customers, all of the time. Its underlying principles are well established too - those airlines that can effectively attract, serve and retain the best customers will see significant positive effects on their bottom line profitability. The deeper the relationship the airline holds with these customers, the more opportunities there will be for selling additional products and services. However, with the emergence of e-business and the 'new economy', the challenges of building strong customer relationships have become even greater. 2.Introduction The jet age and the resulting euphoria in the market have given the ultimate weapon in the hands of the marketers. They now possess many options with them to persuade the customers to buy their products and services. But also because all of these advance, the...
Words: 4338 - Pages: 18
...Student self-study worksheet 06/01/2015 Lecturer….Mr Whitson Unit 609 Prepare and cook food by baking, roasting and grilling You are to research the following questions that relate to this unit: Q What does the word accompaniment mean? A. Something that you eat or drink with something else: A dry champagne makes the ideal accompaniment for/to this dish. List as many roasting methods as you can find A low-temperature oven, 95°C to 160°C (200°F to 325°F), is best when cooking with large cuts of meat, turkey and whole chickens. This is not technically roasting temperature, but it is called slow-roasting. The benefit of slow-roasting an item is less moisture loss and a more tender product. More of the collagen that makes meat tough is dissolved in slow cooking. At true roasting temperatures, 200°C (400°F) or more, the water inside the muscle is lost at a high rate Cooking at high temperatures is beneficial if the cut is tender enough—as in filet mignon or strip loin—to be finished cooking before the juices escape. A reason for high temperature roasting is to brown the outside of the food, similar to browning food in a pan before pot roasting or stewing it. Fast cooking gives more variety of flavour, because the outside is brown while the centre is much less done. The combination method uses high heat just at either the beginning or the end of the cooking process, with most of the cooking at a low temperature. This method produces the golden-brown texture...
Words: 1717 - Pages: 7
...Associate Level Material Appendix G Classifying Organisms Worksheet Complete the following chart. Format citations for references and diagrams consistent with APA guidelines. Organism Kingdom Phylum Characteristics Moss Plantae Bryophyta “1. Mosses grow on moist brick walls, in sidewalks, as thick mats on forest floors, and on the Shaded Side of Trees. Some are adapted to the Desert, or can survive periodic dry spells, reviving when Water becomes available. 2. All mosses need water to complete their life cycle.. 3. MOSSES SHARE SOME CHARACTERISTICS OF OTHER BRYOPHYTES: A. They do not have complicated Vascular Systems. - Nonvascular Plants B. Water passes from cell to cell by Osmosis. They are only a few cells thick. C. They do not have true Roots, Leaves, or Stems. D. They require Water for Fertilization. E. They are small land plants” http://schools.bvsd.org/p12/broomfieldhigh/Teachers/little/APBiology/Shared%20Documents/Plant%20Kingdom%20and%20Fungi/Early%20Plant%20and%20Fungi%20Notes/CHARACTERISTICS%20OF%20MOSSES.pdf Trypanosome Excavata Sarcomastigophora “Typanosomes are microscopic unicellular protozoa that are ubiqitous parasites of insects, plants, birds, bats, fish, amphibians and mammals. The scanning electron micrograph of a single trypanosome shows how the flagellum, which is responsible for movement, emerges from the posterior end , then adheres to the body of the cell, causing the characteristic appearance of the moving cells...
Words: 1323 - Pages: 6
