text:
19th -20th December, 2020
5th ACM-W India National Level Virtual Hackathon 2020 started with an ideology to support and motivate the girl students in the field of Computer Science. Initially, it was supposed to be in offline mode but the pandemic situation brought new challenges to overcome and it was finally decided that it will happen in online mode. This event was successfully hosted by ABES Engineering College, Ghaziabad. In this virtual hackathon there were three rounds. First was the idea selection round where the teams from all over India were asked to present their ideas/solution for a problem based on the given theme of 'SELF RELIANT INDIA' with various domains such as Healthcare, Education, Finance, Agricultural and Social Innovation. The entries for this round were initially accepted from 1st October 2020 to 25th October 2020 and due to the popular demand, the deadline was extended to 30th October 2020. For the first round more than 75 entries we received. From which only 20 teams were shortlisted for the 2nd round which was the interview round. In this round the selected teams had to explain their idea/project to a panel of judges from which 10 teams were supposed to be selected pan India. This round was organised on 22nd November,2020 and for this round we had 16 judges from the various industries, different ACM chapters and from ACM Student chapter and ACM-W student chapter of ABES Engineering College, Ghaziabad.
On 19th December 2020, the final round started with the inaugural ceremony which was addressed by Mr. Chandrashekhar Sahasrabuddhe (COO, ACM India) followed by Dr. Heena Timani (Chairperson, ACM-W India), Dr. Shailesh Tiwari (Director, ABESEC) and Dr. Pankaj K. Sharma (Head, CS Department, Faculty sponsor ACM ABES Chapter). This inauguration ceremony was concluded by Ms. Madhuri Gupta, Faculty Coordinator, ACM-W ABESEC Chapter followed by a vote of thanks by Ms. Sanika Singh. Finally, the hackathon began with the selected top 10 teams.
Glimpse of Virtual Inaugural Function of Hackathon
They were asked to develop a solution on a problem statement that was allotted to them on 19th December 2020. Problem statement of hackathon are listed below.
On the same day, there were two mentoring sessions for each team, to help them with the problem statement followed by one evaluation session on the same day. For refreshment purpose a cultural program was even organised on 19th December 2020. After continues coding for 24 hours the teams were ready with their project. By the end of the hackathon i.e. on 20th DECEMBER 2020 teams were supposed to submit a 3min video illustration of their project and after that a final evaluation was conducted with panel of reputed judges.
Glimpse of Presentation by participants of Hackathon
Glimpse of valedictory ceremony and prize distribution of Hackathon
The valedictory ceremony was initiated by Ms Ritika Malik, Faculty Sponsor of ACM-W ABESEC student Chapter with a small briefing of the entire event. Hackathon winners were announced by Dr. Heena Timani, Chairperson ACM-W India.
1st Prize: ₹ 24,000 Team Leader Ms.Sakshi Singh College: K.I.E.T Ghaziabad Project Title: Spam SMS Filtering 2nd Prize: ₹ 15,000 Team Leader Ms. Ruchika Sharan College: IIT Mandi Project Title: A system for detection of corona virus in human body using artificial intelligence 3rd Prize: ₹ 12,000 Team Leader Ms. Sanjana Jain College: ABES Engineering College, Ghaziabad Project Title: System for prescribing drug in hospitals and it's substitute availability in the medical shops of the area/city
Which was followed by address by Mr.Chandrashekhar Sahasrabudhe, COO, ACM India and a vote of thanks by Ms. Sanika Singh, Asst. Professor, ABESEC Ghaziabad, marked the end of hackathon.
ACM India Celebration of Women in Computing AICWiC 2020
A Virtual Event – 5th September, 2020- Report
ACM India celebration of women in computing –a virtual event was organized by ACM-W India, ACM Nagpur Professional Chapter in association with ACM Nagpur Student Chapter of Yeshwantrao Chavan College of Engineering, Nagpur, Shri Ramdeobaba College of Engineering and Management, Nagpur, Priyadarshini College of Engineering, Nagpur and Persistent Systems Ltd. on 5th September,2020 under the theme "Covid 19: Innovation in IT" . The inaugural ceremony started by Dr. Mukta Paliwal Technical Expert of Persistent Systems. Due to the current pandemic, the event was organized in virtual mode on the online platform zoom webinar.
She introduced the ACMW India, described recent events held and how the organization has played a vital role in motivating the women including professionals, researchers and students in technology. She mentioned how the tech industry has collectively demonstrated remarkable leadership in responding to the challenges posed by the Covid-19 pandemic while explaining about the theme of the event.
Main objective of AICWiC 2020 was to provide an explicit platform for women in technology to showcase their innovation and ideas and motivate others to take up the challenge and help the nation in becoming Independent technologically during these tough times.
She introduced Dr Heena Timani, ACM W India Council Chair, Data Scientist, Co-Founder, Director iAnanya Datalytix Pvt. Ltd. to deliver the welcome address and as a session chair for the keynote speech. As this event being the flagship event under ACM celebration women in computing Dr. Heena envisioned and heilighted the entire operational and key benefits of ACM-w membership and took the opportunity to brief about past events and upcoming events going to be held under the canopy of ACM India. She took initiative to provide the platform for women to showcase their talent and insisted on numerous opportunities for women scholars to grab several scholarships to the candidates under ACM-w India Chapter. She has always been a key inspiration to all young technocrats and actively involved in supporting and organizing computing events for women in India under ACM-Women Council.
Dr. Heena welcomed Prof. Reyyan Ayfer, Vice-Chair, ACM-W & Professor, Bikent University, Turkey for the keynote address. She contributed her expertise to international committees, most notably as a council member of ACM Europe and as the Founding Chair of ACM Women in Computing Europe Committee as well as leading a community of students who have formed the first international ACM-W Student Chapter. She is now serving for women in computing as the chair of Regional Activities of ACM-W. She received the Anita Borg Change Agent Award in 2008 after serving as the ACM-W Ambassador of Turkey for 8 years.
Dr. Reyyan delivered a keynote on "Changes, Challenges, Opportunities" and she began with saying that Our lives changed suddenly when the novel coronavirus spread throughout the world. We faced many challenges both in our personal and professional lives. Are there any opportunities in this especially for women in computing? She discussed some of the success tips and strategies for the budding innovators. Her address was mainly based on how COVID-19 has changed everyone's lives and meanwhile impacted the opportunities for the students.
Prof. Devishree Naidu, session chair of second keynote introduce Dr. Jaya Sreevalsan Nair from IIIT Bangalore. She leads the Graphics-Visualization-Computing Lab and is one of the core team members of the E-Health Research Centre at IIITB. Her research interests in data visualization, scientific computing, computer graphics, and computational geometry. She has projected many data modeling concepts for visualizations and identified appropriate visualizations for complex datasets in data science workflow. The most interesting research that includes semantic classification of LiDAR point clouds, spatial and statistical analysis of population surveys, automated data extraction from chart images, community detection in biological and brain networks, and virtual world reconstruction of traffic scenes from monocular images. She has been supported by grants from SERB, DST, GoK, Intel, IBM, to name a few. She is an ACM member and IEEE Senior member. Her keynote specifically brought attention to "Data Dissemination during COVID-19: The Rise of Visualizations" in which she discussed the significance of data dissemination techniques discovered during the present COVID-19 scenario and tools used by computer scientists to make a lay-man understand complex facts and figures. She elaborated about 5 V's Velocity, Veracity, Volume, Variety and Value of data. She also made all aware about Florence Nightingale as a data science who was also a pioneer in data visualization with infographics effectively used for graphical presentations of statistical data. Dr.Jaya discussed some of the research that took place at Karnataka region for showing statistics of Covid-19 and explored about the tools with additional futuristic which opened an eye for key research in the field of data science.
A panel discussion was organized during AICWiC2020 on theme "Innovation Opportunities for New Normal during Pandemic".A panel was moderated by Dr. Lipika Dey, Principal Scientist at the TCS Research and Innovation Labs. , faculty at the Department of Mathematics at IIT Delhi. (till 2007).The panelist were Dr. Maya Ingle, Director,DDU-Kaushal Kendra at DAVV Indore, Mrs. Rachna Patrikar,Senior Manager-Enterprise application and emerging technologies, Mahindra and Mahindra),Dr.Manik Gupta, Assistant Professor at BITS Pilani Mrs. Vandana Gupta, Director at Multivirt India Pvt Ltd & FNN Media Pvt Ltd ,28 years of experience in IT industry.
The Panel discussion started with a poll as a quick activity. The poll was conducted to know the experiences of the participants about Innovations during Covid-19 pandemic. After the poll chairperson of the panel Dr Nita Thakare welcomed all and briefed about the objective of panel discussion. She welcomed and introduced moderator of the panel Dr Lipika Dey. Dr Lipika Dey introduced the panel members and panel discussion was divided in to three phases. In the first phase all panel members have shared their experiences about the current scenario of innovations and their thought on the opportunities for IT innovations during covid pandemic. They discussed the Innovation Opportunities for New Normal during Pandemic in brief.
Moderator of panel Dr Lipika introduced panelist and coordinating with panel members. Dr Maya Ingle talked about the role of IT in education sector. She also discussed about the reasons for change in education methodologies and the opportunities for the educationalist and researchers during COVID 19 pandemic. Also she shared some examples on how practices changed from Offline classes to Online Classes. Mrs Rachana Patrikar ,discussed about current situation of Covid 19 pandemic and its effect on lifestyle of people also she talked on increase in usage of online market and online transaction. Dr Manik Gupta talked about latest technologies being used in innovations. She also discussed,how online platforms are helpful in pandemic and how blessed it is to share our knowledge with the community through virtual conference. Dr Vandana Gupta presented various products developed by her company to cater the pandemic situation.
She also discussed about innovations opportunities during Pandemic and motivated the participants to implement innovative ideas. During question – answer session, the Moderator Dr Lipika asked questions on behalf of the participants to panel members. The participants benefited by the answers of experts. The session ended with the concluding remark by Dr. Deveshree Naidu.
Poster Presentation Competition was part of Virtual Event for celebration of Women in Computing by ACM India. The competition was specially organized for UG/PG girl students of CS/CE and IT branches to boost innovative ideas. There were total three round in poser presentation competition. Education , Health care, Environment / Ecosystem / Waste Management , Age of Sustainable Development (Sustainable Cities and Communities) themes were decided for poster presentation competition. We received maximum posters in Health Care domain. We got good response from various reputed institutes of India, total 105 teams registered for poster presentation competition.
These groups were divided into 6 Teams of judges for evaluation and selection purpose. From this 24 teams were selected for second Skype interview round. Total 6 posters were selected for presentation in the final round during event.
Dr. Gauri Dhopavkar, Head, Department of Computer Technology, Yeshwantrao Chavan College of Engineering, Nagpur hosted the finale round of poster presentation competition on 5th September 2020 .Dr. Heena Timani, Chairperson, ACM-W, India, Dr. Rituparna Chaki, Professor, A K Choudhury School of IT, University of Calcutta, Dr. Tejaswini Apte,ACM-W Pune Professional Chapter Chair and ACM-W India council member, Mr. Darshan Kansara, Senior Consultant with Anblicks, Ahmedabad, were the judges for the finale.
During finale round, each finalists' posters and videos explaining the detailed concept was presented to all audience. This round was followed by question/answer session to the poster presenters by judges. Out of 105 groups registered for this competition, 6 groups were shortlisted for finale round. Cash prizes were sponsored by Tata Consultancy Services.1st Prize: Rs.16,000, 2nd Prize: Rs.12, 000,3rd Prize: Rs. 8,000
A result of the virtual poster presentation was declared by Dr.Heena Timani. Below is the list of poster presentation winners
Rank Name of Student Project Title Institute Name
1 Soundarya Krishnan Network Community Analysis based enhancement of Online Discussion forums BITS Pilani, Goa Campus
2 Sona S Technovid 2020 Thiagarajar College of Engineering,Madurai
3 Shradha Sehgal Sab Jeevika: Enabling job search for the deprived sector International Institute of Information Technology. Hyderabad
In concluding remarks Dr.Heena Timnai thanked organizing team Dr. Devishree Rohit Naidu, Asst. Prof. ,Shri Ramdeobaba College of Engineering and Management,Dr. Gauri Dhopavkar , HoD, Yeshwantrao Chavhan, College of Engineering, Nagpur,Dr. Mukta Paliwal ,Technical Expert -Data Science, Persistent Systems Nagpur,Dr. Nita Thakare, Associate Prof. and Head, DCT, Priyadarshini College of Engineering, Nagpur,Dr. Swati Hira, Asst. Prof., Shri Ramdeobaba College of Engineering and Management, Nagpur,Mr. Vinit Kapoor ,Chief Architect, Persistent Systems Nagpur and Dr. Rutvi Shah Assistant Porf at Chimanbhai Patel Institute of Computer Applictions. She also thanked the poster prizes sponsors Tata Consultancy Services and Platinum partners of ACM Google, Persistent, Icertis.Mr. Chandrashekhar Sahasrabudhe,COO, ACM India congratulated team for their successful smooth completion of virtual event using Zoom Webinar.
Dr. Mukta Paliwal thanked to Keynote speakers, Panelists, ACM India, ACM W India and ACM International office bearers Various sponsors, Partner Industries, Partnering institutes, Participating institutes, Committee members, Evaluators/Judges, Students who took part in poster competition, Finalists, the Organizing team & all those who are directly or indirectly involved in the organization of this event. Everyone agree with the promise of staying connected to each other through these events, as a supportive and strong women community in the field of computer science education, research, and industry.
ACM W India Grad Cohort Workshop 2020 Report- A Virtual Event
ACM-W India emphasizes on women empowerment in computer-related fields and domains. It focuses on providing a platform for sharing resources, information, ideas, and experiences with its diverse range of activities so that women can effectively tackle the challenges in their computing careers. It aims to promote computer literacy and provide strong networking opportunities, enabling women towards being independent, confident, self-reliant, and successful.
The Computing Research Association-Widening Participation (CRA-WP) is an international computing body that started conducting the Grad Cohort workshops from 2004 in the different educational institutions of the USA. Over the last 15 years, these sessions have guided many women through their academic and professional years. Drawing inspiration from it, ACM-W India decided to adopt this workshop model to the Indian setting. As a result, the first edition was organized at IIT Bombay in July 2018 and the second one was held at IIT Delhi in 2019.
ACM India Grad Cohort 2020, the third installment of this pan-India workshop series, was virtually co-organized by the CSE Discipline at IIT Gandhinagar and ACM-W from 24th – 26th July 2020. It kick started with a warm welcome address by Dr. Neeldhara Misra (faculty, IITGN and member, ACM-W), followed by the opening remarks from Dr. Heena Timani (chairperson, ACM-W India)Cofounder and Director, iAnanya Datalytix Pvt.Ltd, Dr. Nutan Limaye (faculty, IIT Bombay and vice-chairperson, ACM-W) and Dr. Meenakshi D'Souza (faculty, IIIT Bangalore). They highlighted that the long term objective is to positively shape the future of our societies by celebrating and advocating women in computing.
On Day 1, the first keynote lecture was delivered by Dr. Sunita Sarawagi (professor at IIT Bombay and the Infosys Prize 2019 winner), during which she talked about the journey of machine learning models, starting from their birth and going all the way to how they are serving the real world in the current times. Although they have an amazing number of applications, a lot more still needs to be done and this is the reason ML continues to be a fascinating area for further research in computing. The next talk was given by Dr. Manik Gupta (faculty, BITS Pilani-Hyderabad), where she provided her perspectives on how women can plan and progress in their computing careers. The key is to embrace womanhood, be focused, work hard, carve our own career paths, and define our own success. In another session, Dr. Bhavana Kanukurthi (faculty, IISc Bangalore) spoke on choosing a research advisor, topic, and group. According to her, the process should be well-planned, align with our skills, and exhibit practical relevance. Dr. Aparna Taneja (software engineer, Google research) described the practical aspects of this topic by sharing experiences and insights from her own thesis and present job responsibility.
Jaya Sreevalsan Nair (faculty, IIIT Bangalore) gave examples of some eminent minds in various fields and discussed the latest topics of online presence and personal branding. She stated that the trick is to maintain a proper combination of one's online and offline persona. This was followed by a captivating panel discussion that shed light on some aspects of remote working and maintaining a proper work-life balance. The panelists of this session were Dr. Tulika Mitra (Provost's Chair Professor of Computer Science, National University of Singapore), Dr. Joycee Mekie (faculty, IITGN), Dr. Hemangee Kapoor (faculty, IIT Guwahati), Dr. Rekha Singhal (senior research scientist, TCS) and Dr. Akanksha Agrawal (postdoctoral researcher, Ben-Gurion University, Israel).
Talking about their personal and professional experiences, they motivated the participants and advised them on how to carve their own niche in computer science.
Day 2 opened with the second keynote lecture of this event that was delivered by Dr. Meena Mahajan (professor, Institute of Mathematical Sciences). An eminent contributor in Discrete Algorithms, Complexity Theory, Matching Theory, Combinatorics, and Proof Complexity, she recounted some interesting experiences from her life and expressed that she grew increasingly fond of theoretical computing with time and proceeded to pursue her Ph.D. in this domain. She described some fascinating facets of this field. In her words, every unknown in complexity theory is like a creative puzzle yet to be solved and there is a place for everyone to work in this exciting area of education and research. The next session was given by Dr. Prajakta Nimbhorkar (faculty, Chennai Mathematical Institute), where she discussed the background preparation (breadth and depth) for Ph.D.
Dr. Ranjita Bhagwan (senior principal researcher, Microsoft) talked about confidence and encouragement by narrating some instances from her life and emphasized that failures are our path to success since they teach us how to firmly believe in ourselves and live positively. Akanksha Agrawal gave a session on quantity versus quality in publishing from the viewpoint of research in theoretical computing, and Tulika Mitra highlighted this topic with respect to the early career researcher level, giving examples from systems research. A thought-provoking panel discussion moderated by Dr. Lipika Dey (principal scientist, TCS) included Meena Mahajan, Dr. Uttama Lahiri (faculty, IITGN), and Dr. Arpita Korwar (faculty, IIT Goa) as panelists. They shared their life-journeys and provided quality guidance to the participants on how to cope up positively and effectively with uncertainty and other related challenges. After this, all the participants enjoyed the online screening of an inspirational documentary movie that is based on the life works of Maryam Mirzakhani, the first woman and the first Iranian to win the greatest prize in mathematics, the Fields Medal.
The third and final day of this workshop was initiated with an interactive session by Dr. Sushmita Gupta (faculty, National Institute of Science Education and Research). She discussed whether going for a post-doctorate is really a hit or a miss based on her experiences in theoretical computing. Next in line was a process-oriented talk given by Arpita Korwar, during which she explained the process of managing a job hunt and stated that it is all about constantly and actively being in the game. Richa Singh (faculty, IIT Jodhpur) and Anasua Bhowmik (Fellow Design Engineer, AMD Bangalore) provided valuable guidance on post-Ph.D. career options in the industry and academia respectively.
The ACM India Grad Cohort 2020 offered a perfect place for women in computing to connect with one another via several virtual platforms such as zoom, gather.town, WhatsApp, and social media.
Moreover, it also housed three major contests for women participants, with a chance to win exciting prizes. The last date for entry-submissions was 31st July 2020 and the goodies were sponsored by Tata Consultancy Services. The results were announced on 10th August 2020 over email, on the event website, and on different social media platforms.
With an attendance of more than 195 registered participants (students, researchers, and leading experts from industry and academia), the workshop was a huge success and concluded on an optimistic note. It proved to be an excellent platform for women in computing and its allied areas to build discussion forums with some of the most eminent minds in this field. Several participants voiced their views on how enriching it was to meet their women role-models. We received very good response of the participants on virtual format of Grad Cohort workshop. Opinion was taken using menti.com.
The next edition of this Grad Cohort will be conducted at IIT Jodhpur, with Dr. Richa Singh being its organizer. Dr. Heena Timani also shared the list of some upcoming interesting ACM India events. In their concluding remarks, Dr. Neeldhara Misra, Dr. Nutan Limaye, and Dr. Meenakshi D'Souza thanked IIT Gandhinagar, ACM-W, Google, TCS, the team of volunteers and all the Participants for massively supporting this event and making it a smashing success. Everyone bid adieu with the promise of staying connected to each other through these events, as a supportive and strong women community in the field of computer science education, research, and industry.
ACM-W India Regional Celebrations Report
The Regional Celebrations 2020 of the Association for Computing Machinery – Women's Council (ACM-W India) was held at Padre Conceicao College of Engineering, Verna, on 13th March 2020. The Annual mega-event was jointly organised by ACM, ACM-W, Padre Conceicao College of Engineering (PCCE), Indian Institute of Technology-Goa (IIT-Goa) and Goa University.
Ms. Revati Majumdhar, the Executive Director of Goa Electronics Limited, was the ChiefGuest for the Inaugural function. Rev. Fr. Anthony Castelo, Director of Agnel Technical Education Complex welcomed the delegates to the Campus. Ms. Maria D'Souza Chaudhary, Treasurer of ACM India, spoke about the purpose and initiatives of ACM. Also present on the dais were Dr. Mahesh Parappagoudar, Principal of PCCE, Dr. Sudhakshina Dutta, representing IIT-Goa, Assoc. Prof. Ramrao Wagh, representing Goa University and Ms. Razia de Loyola Furtado e Sardinha, Convenor of the event. Program Chairs Mr. Siddesh Sawant spoke aboutthe day's eventsand Ms. Cassandra Fernandes proposed the vote ofthanks.
Chief Guest Ms. Revati Majumdhar, with other dignitaries and organizing team members, after the Inaugural Ceremony.
Keynote Address by Mr. Riyaz Walikar
The theme chosen for the celebration was "Security Technology". Mr. Riyaz Waliker, Head of Security Research Team at Appsecco, Bengaluru, was the Keynote Speaker. Also hosted were the ACM-India National-level Prototype Presentation Competition and ACM-India National-level Poster Presentation Competition. Over 30 teams from colleges across India submitted their proposals on "Technology for Women Safety". The Prototype Presentations were judged by Mr. Ryan Pinto, Director of Innovantix Systems Private Limited, Goa, Ms. Akshata Raikar, Team Lead at PSL Goa and Mr. Riyaz Walikar. The Poster Presentationswere judged by Mr. Madhav Rangannekar, COO of S J Innovations and Ms. Maria D'Souza Chaudhary of Oracle Systems.
Prototype Presentation Competition in progress
The highlight of the event was an entertaining and insightful panel discussion by eminent women technocrats Dr. Veena Thenkanidiyoor, Dean at NIT-Goa, Prof. Anusha Pai, Head of Computer Engineering, PCCE, Dr. Kavita Asnani, Asst. Professor at GEC, Ms. Maria Chaudhary, MTS at Oracle Systems, Dr. Sudakshina Dutta and Dr. Poonulakshmi V. K.,Asst. Professors at IIT-Goa, Ms. Lourdes Soares, Founder of SabrCare, Goa and Ms. Nadisha Kamat, Product Owner at Odessa-Bengaluru. The animated panel discussion on the topic"Does Gender Impact Technology" was moderated by Ms. Razia de Loyola Furtado e Sardinha, Asst. Professor, PCCE.
Beaming Competition Winners
Panel Discussion in Progress
Distinguished Panelists with organizing team members
ACM-W India Workshop on "Women in Computer Science and Research" Report
Association for Computing Machinery's Council on Women in Computing (ACM-W) celebrates and advocates the involvement of girls and women in all aspects of computing education and research. It works to raise awareness about the opportunities available for females in the growing field of computer science through a diverse range of programs and services. Expanding globally, ACM-W has reached India, where it seeks to further novel ways for the next generation of females to face today's problems and challenges.
Some participants of the ACM-W workshop 2020 with Dr. Cherri Pancake (President, ACM) in the middle (first row)
Dr. Heena Timani (Chairperson, ACM-W India)
An ACM-W workshop on the theme "women in computer science and research" was organized on 14th February,2020 during the ACM Annual Event 2020 by the CSE Discipline at IIT Gandhinagar. The event kick-started with a welcome address by Dr. Heena Timani (Chairperson, ACM-W India), during which she highlighted the critical functions of ACM-W. She also explained several programs of this Council in detail, such as the India chapters, Hackathon, the Summer and Winter Schools for girls, Grad Cohort, and scholarships, in the long list of many others.
Dr. Cherri M Pancake (Professor Emeritus-Oregon State University, Director-NASCE, President-ACM)
The first keynote talk was by Dr. Cherri M Pancake (President, ACM), during which she described how ACM-W encourages females to revolutionize the field of CSE research. Sharing her life story, she said that ACM-W is all about being proactive, progressive, patient, strategic, flexible, ready to push oneself to perform the best, able to face challenges head-on, and active change agents, and helps women explore the latest developments in computing.
Dr. Arati M. Dixit (Senior Scientist, ARA; Research Associate Professor, NC State University, Raleigh, USA)
Next in line was the engaging session by Dr. Arati M. Dixit (Senior Scientist, ARA; Research Associate Professor, NC State University, Raleigh, USA), which shed light on the growing ACM-W leadership team. Now encompassing several regional groups viz., ACM-W North America, ACM-W Europe, and ACM-W South-Pacific Regions, it is in the process of expanding to Africa as well. Dr. Dixit proceeded to explain more about the various scholarships available for girls and women. She also discussed the future possibilities of efficient connections among different student chapters in a particular region.
Dr. Lipika Dey (Principal Scientist, TCS Innovation Lab)
The invited talk by Dr. Lipika Dey (Principal Scientist, TCS Innovation Lab) on Data Analytics, started with the changing buzz words synonymous with this field. Later followed the discussions on the main challenges of this domain, viz., consistency, explainability, security, reproducibility, and integrity. The session concluded with the message that proper utilization of data analytics can help convert data to information to knowledge. Dr. Dey also advised the females to give their best, utilize all possible opportunities to lead from the front, and adopt a positive outlook on all situations.
(L to R) Dr. Chitra Babu (Professor and HOD, SSN College of Engineering), Dr. Meenakshi D'Souza (Associate Professor, IIIT Bangalore), Dr. Arati M. Dixit and Dr. Nutan Limaye (Associate Professor, IIT Bombay)
One of the most thought-provoking sessions of this workshop was a panel discussion consisting of Dr. Meenakshi D'Souza (Associate Professor, IIIT Bangalore), Dr. Chitra Babu (Professor and HOD, SSN College of Engineering), and Dr. Arati M. Dixit, Dr. Nutan Limaye (Associate Professor, IIT Bombay). They all shared stories of their journeys in computing and the challenges they faced as women (personally and professionally). Talking about the issue of gender ratio in the educational institutes of the country, the panelists advised the female participants on how to carve a niche for themselves and become leaders in computer science.
Dr. Kalika Bali (Principal Researcher, Microsoft Research Lab, India)
Dr. Kalika Bali (Principal Researcher, Microsoft Research Lab, India) delivered an enlightening talk on computing technologies that could help in promoting the low resource languages of the country and the globe. She explained the importance of data, techniques, and applications in extending these languages and, hence, enabling efficient networking among communities. Another interesting session by Dr. Joycee Mekie (Assistant Professor, IIT Gandhinagar) provided insights into the world of approximations in computing: what should and shouldn't undergo approximation in an application, and how so – what sort of algorithms should go into it? How to tune it (accuracy) and where to apply it?
Dr. Joycee Mekie (Assistant Professor, IIT Gandhinagar)
The event came to an end with a valedictory function and a networking session. With an attendance of more than 100 participants – students, researchers, and leading experts, this workshop was a huge success. It proved an excellent platform for women in computer science and allied areas to build discussion forums with some of the most eminent minds in the field of computing education and research. Workshop was successfully completed under great enthusiasm and the encouraging support of Dr. Neeldhara Misra (Assistant Professor IITGN , Dr. Rutvi Shah (Assistant Professor CPICA) and Ms. Apeksha Srivastava (Senior Project Associate, IITGN)


Ryan Rice, a Mohawk of Kahnawake, Quebec, is the Delaney Chair in Indigenous Visual Culture at the Ontario College of Art and Design University (Toronto, ON). His curatorial career spans 20 years in museums and galleries, most recently having served as the Chief Curator at the IAIA Museum of Contemporary Native Arts in Santa Fe, NM. Rice's writing on contemporary Onkwehonwe art has been published in numerous periodicals and exhibition catalogues, and he has lectured widely. Some of his exhibitions include ANTHEM: Perspectives on Home and Native Land, FLYING STILL: CARL BEAM 1943-2005, Oh So Iroquois, Scout's Honour, LORE, Hochelaga Revisited, ALTERNATION, and Soul Sister: Re-imagining Kateri Tekakwitha. Rice was a co-founder and former director of the Aboriginal Curatorial Collective and currently sits on the Art Gallery of Ontario's Education Council and the Native American Arts Studies Association board.


text:
Police Decertification (US)
Shot By Police Boston & Beyond
Working to reform police practices to improve respect for basic human and civil rights, reforms should address concerns about policing, racial discrimination/profiling, diversity, excessive/deadly force and corruption.
City Level
Federal Level
Why We Need Reform
Reform News
News – City Level
Police Decertification in MA
Pending State Legislation
News – State Level
News – Federal Level
News – Research
Renewed interest in Massachusetts police civilian review boards
by Dondre | posted in: City, State, Why We Need Reform | 0
Karen Anderson & Kevin Rothstein
It's been three years since Jamarhl Crawford made a complaint about what he believed was misconduct by a Boston police officer, but he still has no answers.
"I was told by elected officials and administration and police officials that I should complain. That the system does work," he said. "I'm an activist. I did complain and I'm still waiting on my results."
Crawford is also a member of the Boston Police Reform Task Force, created earlier this month by Boston Mayor Marty Walsh.
"No one should be left in the dark and waiting for three years without hearing anything," he said.
Activist Jamarhl Crawford is on a new city panel studying police oversight.
Crawford said that the lack of communication is just one reason Boston needs a new civilian oversight board for the police department.
Former police officer and federal prosecutor Natashia Tidwell agrees.
"The question, does Boston have civilian oversight? Someone might answer, 'Yes, they have the CO-OP.' But the CO-OP is not civilian oversight," she said.
Tidwell served on the CO-OP, short for Community Ombudsman Oversight Panel, from 2011 to 2018. But she said its power is limited.
It can only look into whether completed Internal Affairs investigations were fair and thorough. The CO-OP can't say whether an officer committed misconduct.
In 2015, Tidwell and two other panel members released this report critical of the Boston Police internal affairs process, and the CO-OP's ability to improve it.
The report called for a new "independent community based police complaint review body."
"The difference in my mind is a civilian review board, or a civilian oversight board, is involved in the complaint intake and sort of the life of a complaint within the police department as it's being investigated and resolved," Tidwell said.
Natashia Tidwell, a former member Boston's Community Ombudsman Oversight Panel, said the CO-OP's power is limited.
Boston police did not respond to requests for comment. A spokesperson for Mayor Marty Walsh referred to earlier comments made by Walsh that he wants to strengthen the CO-OP board.
Jack McDevitt, the Director of Northeastern University's Institute on Race and Justice, has studied this issue for decades, and says strong civilian oversight of police has been lacking in Boston and around the country for years.
"The important part is that the community becomes an equal partner in doing the investigation," he said.
"So when you think about this board not doing very much now, what goes through your mind?" 5 Investigates' Karen Anderson asked him.
"Frustration," he responded. "But I do think that we're at a point where we can really revisit this and we could do it right and we could do something that the citizens of Boston could be proud of."
Tidwell said the time is right to push for change.
"I'm hoping that now that this is the time at the police department and the city is ready to do a little bit more," she said.Play Video
The push to expand civilian review of police is not limited to Boston. Brian Corr, director of the Cambridge Police Review and Advisory Board and a national expert on community oversight of police, has been taking calls from around the country asking for help creating community oversight boards.
"Ultimately, what we're doing is working to make things right," he said. "It's about having people who are not sworn law enforcement officers in the department looking at specific instances and broader trends in a police department or law enforcement agency."
Corr, a board member and recent past president of the National Association for Civilian Oversight of Law Enforcement, said some oversight boards review complaints of police misconduct. Others proactively look at policy. Many, including Cambridge's, do both.
Brian Corr, a national expert on civilian oversight of police, has been fielding calls from around the country on the topic.
They need access to information, according to Corr, but there's not just one way to get it.
Matthew Segal, legal director with the ACLU of Massachusetts said access as well as authority is key.
"Is the board going to have the power to investigate? Is the board going to have the power to subpoena took to require documents, to require testimony to be turned over? And is the board going to have any role in determining what happens to officers if they're deemed to have done something wrong?" he said.
Matthew Segal, legal director of the ACLU of Massachusetts, said the scope of powers that an oversight panel has is a key to its success.
Athanasi Darviris, president of the Cambridge Police Patrol Officers Association, said the police union "feels the city and the department has a fair and impartial system in place."
"As for a successful oversight board, it would have to be established with a group of diverse members. For example, retired law enforcement, retired or former district attorneys, members of the community, licensed social workers, nurses, and medical professionals," she said. "These members can then listen to the concerns of its citizens, police officers working in the community and make educated recommendations based on training, laws, policy's and procedures and the good of the community as a whole. Finally and most importantly the board members should be open to attending law enforcement training so they have a better knowledge of how police officers are trained, challenged, and educated."
There are four community review boards in Massachusetts: Cambridge, Pittsfield, Springfield and Boston.
Whatever powers it has, Corr says a civilian review board won't work well without a good relationship with the police department.
"We all have to come to the table as a community to make sure that we can have the best oversight possible in order to have the best law enforcement and policing that we can in our communities," he said.
Boston Police Task Force Releases Final Recommendations October 21, 2020
DOGGY SLAYCARE: COPS CLAIM K-9S TO BE KILLED IF POLICE REFORM PASSES October 6, 2020
Can a cop be in two places at once? September 30, 2020
BOSTON POLICE TASK FORCE COMMUNITY LISTENING SESSION September 22, 2020 September 17, 2020
Community Ombudsman Oversight Panel
National Decertification Index (NDI)
Fatal Encounters
The Counted
National Police Misconduct Reporting Project
Operation Ghetto Storm
Demonstrators Demand Reopening Of Police Shooting Cases In Boston Rally September 9, 2020
'Defund The Police': Activists In Boston's Black Neighborhoods Don't All Agree September 9, 2020
Calls For Boston Police Reform Evoke Almost 30 Years Of Tension September 3, 2020
Mass Police Reform Timeline August 3, 2020
Proposed Reforms
© 2021 Mass Police Reform | Site by JL

redpajama_set_name: RedPajamaCommonCrawl


← Take The Decisions Out Of Washington´s Hands!
There were times when all people on earth had to make decisions, in terms of a new direction.
But in the past few years I notice more and more that some professions and single private people don´t really have to decide for a new direction but rather need to learn how to sort their alternatives. Alternatives shall deliver a solution to a problem. Let´s look a little deeper and take a look at doctor´s daily work….
A doctor in a hospital for example can´t pick the illnesses, because the patient comes with the illness and delivers it. A patient confronts a doctor with facts. Of course he´s specified for particular illnesses or diseases, but still, the alternatives approach by itself without a necessary calling. The decisions a doctor has to take transformed into tough "sorting-decisions".
1. "Who out of 3 – 4 patients have to stay in the hospital? Who is "ill" enough?" A doctor has to decide about a patient who needs to stay overnight. She and he will make a few tests and then uses the clinic look. Some patients probably need to go home, others might be transfered to another hospital with empty beds on the ward. The responsibility lies in the "right" sorting.
2. "What is useful?" is the magic question. "Sorting the alternatives" for decision making is about dealing with the abundance. Solution method: people who permanently have to sort, need a detailed criteria list.
A doctor for example has to have passion to heal illnesses. The challenging patient a doctor suddenly faces might bring this question: "do I have the right to show up at your door ?" If the doctor answers with: "yes, you are a contribution to my success !" …..the patient will be sorted "into" the hospital to undergo a treatment.
A criteria list is a leveling for decision making. It´s relevant for the decisions.
Set qualification characteristics (as HR does when sorting): what´s relevant to get?
Another good example about sorting decisions via a criteria list from an abundace of solutions are the TOP MODEL TV-shows around the world. There´s obviously a certain height with sometimes 1 exception, certain body measurements, good looks and a great walk – as the main criteria to be "in".
But still the best top models can´t be chosen from a first meeting. Height, body, walk and looks won´t just do it. They function as a door opener "only".
Back to the doctor: A doctor needs to take the patient "in" to start the necessary healing process while top model searchers take a few potential models "into" the team to start improving their soft skills until the best comes out.
Both work with the luxury of time!
While time can be risky for a doctor, it is necessary for the top model producer. When we make decisions we often lack time! We need to be prepared for what we´re looking for, we need to be focused to get it. It´s either focus or information we need to add. If we own that luxury, we are able to make fast decisions! Once we´re a professional with quick decision making we can move on and start working with our intuition.
What is your experience with sorting decisions from abundance? What is challenging you? Which criteria did you chose?


TBQ'S Book Palace: [Cover Reveal]: "Tempting the Player" + Giveaway!
[Cover Reveal]: "Tempting the Player" + Giveaway!
Kat Latham is a California girl who moved to Europe the day after graduating from UCLA, ditching her tank tops for raincoats. She taught English in Prague and worked as an editor in London before she and her British husband moved to the Netherlands. Kat's other career involves writing and editing for charities, and she's traveled to Kenya, Ethiopia and India to meet heroic people helping their communities survive disasters. Find out more on her website: katlatham.com.
Ooh, that is a lovely cover! :) And I know Kame has been enjoying this series, so it's definitely going on my list.
Have you read many rugby romances?
I haven't read any of Kat's book and yes I am tempted by this one!!


How? Well, we'd recommend trying two ways: first, this Nirsoft utility should snag your Windows 10 product key. Copy it down and squirrel it away, just in case Windows eventually asks for it if you ever decide to upgrade again.


Club Veteran Chris Carter's great run of form continued on Sunday as he put 3 past Arlesey Vets.
Town's old boys won the match by 6 goals to 2, with a revitalised Richard Thorp scoring a brace, and James Neill adding to the impressive scoreline.
The Reserves found themselves up against tough resistance, and a few first teamers, when they faced Lemsford Reserves on Saturday; it was a good all-round performance by the team who led 2-1 with just minutes to go when Lemsford were awarded a penalty, leaving the final score at 2-2.
The First Team went down 2-1 to league leaders Bedmond Sports & Social Club, a disappointing result but proof that the team can now live with the best in the Division; we are stting ourselves up nicely for 2013.


A biology major remains one of the most flexible and in demand majors across disciplines, being widely applicable to both research and non-research entities. Whether your goal is to be a tenure- track professor with your own cohort of graduate students, a wildlife ecologist exploring the unexplored wilderness, or an industry scientist developing drug protocols, experiential education is a valuable component of your personal growth and discovery during your academic career. Obtaining research experience as an undergraduate allows you to hone in on your particular interests, while challenging you intellectually and personally. Professors and employers are consistently looking for highly motivated, passionate, students to join their labs or workforce. Obtaining research prior to graduation can provide skill sets that will be necessary for job placement in the future.
Yet how do you go about securing an internship or research project? Here we have provided a variety of resources that will allow you to explore the value of an undergraduate research experience, how to find one, and more importantly how to fund and/or budget properly to ensure success.


text:
Q: A Hamilton graph having a Hamilton cycle that traverse an edge more than once. I was asked to draw a Hamilton graph having a Hamilton cycle that traverse an edge more than once.
My first impression of this question was: what? I mean if we are not allowed to visit a vertex more than once doesn't it mean we are not allowed to traverse an edge more than once. But then I thought of the following solution. Consider the graph

Then this is a Hamilton graph with a Hamilton cycle
$$
v_1,e_1,v_2,e_1,v_1
$$

My question: First, am I right? Can you draw a different Hamilton graph having a Hamilton cycle that traverse an edge more than once? By a different I mean a graph that does not contain the given graph above as its subgraph?

redpajama_set_name: RedPajamaStackExchange


Radikal Churros are something special to us. We designed fun and funky, with just a hint of chocolatey branding and packaging to support these South American sugar treats. Anytime we're working with desserts is a happy time, but even better is when we were awarded a Creative Summit International award for our unique packaging.


Perkaroma can help you enroll in a one-of-a-kind coffee program for your New York or New Jersey office space. From single cup brewers to commercial carafe systems, we offer environmentally friendly brewing options for the workplace. We also offer monthly and quarterly coffee rotation to keep things interesting in the breakroom.
Great coffee is vital to a happy workplace. Whether your office runs best on the convenience of single cup brewing or on the high-volume production of a commercial carafe system, we have the right solution for you. Perkaroma also offers environmentally friendly brewing options that help our clients meet their green initiatives. Coffee selections range from premium single origin, locally roasted hand crafted, to the best known name brands. Upgrade your office's coffee experience with locally roasted whole beans and super premium third wave coffees.
We also provide monthly or quarterly rotation of coffee brands or varieties to keep your employees interested and always experiencing something new.
At Perkaroma, we proudly provide a wide array of hot beverage options, from classic drip coffee to espresso. Whether you prefer to order yourself and manage your own inventory, or you would rather we do that for you with our automatic restocking system, we can and will accommodate your unique needs. We'll gladly supply you with as little or as much as you need of coffee, creamer, and all of the other hot beverage products you may require.
Contact us now for a free demo of the latest and greatest coffees and coffee brewers available.
A refreshing cold drink makes the difference in an employee's work day. At Perkaroma, we offer cold refreshment options that make breakrooms a dynamic and inviting center at your office.
Your office can have access to the most popular and acclaimed brands of beverages and dispensers on the market, ensuring that you have what you need, when you need it. Sparkling waters, organic iced teas, healthy juices, coconut water and kombucha drinks are trending as the most popular office additions.
Reach out to us to learn how the new wave of drinks and dispensers can make your office breakroom more efficient and inviting for your staff.


text:
You are here: Archive Home > Community & health > Public and environmental health > Public health and safety > Tobacco control
Buying or transferring a food business
Food Safety Programs and supervisors
Start and register a new food business
Food business classes
Temporary and mobile food premises
Food complaints and recalls
Food and Health Related Business Registration Fees
What are health-related businesses?
Buying or transferring a health-related business
Start and register a new health related business
Complaints about health-related businesses
Health-related business complaints
Pollution and odours
Public pools and spas
Syringe and needle disposal
Use of warehouses and factories
Tobacco reforms
In Australia, tobacco smoking is the largest single preventable cause of death and disease.
Evidence shows that the earlier a person starts smoking, the more likely they are to become heavy smokers and experience difficulty quitting. For this reason, reducing the uptake of smoking by young people and preventing their exposure to the dangers of environmental tobacco smoke are key platforms of the Victorian Government's program to reduce the overall toll of tobacco use in Victoria.
Numerous tobacco reforms have been implemented in recent years in Victoria as part of the Tobacco Act 1987 which have led to sustained declines in both adult and youth smoking rates in Victoria.
Reforms include:
the introduction of plain packaging requirements for tobacco products
a ban on smoking in a motor vehicle if a person under the age of 18 years is present
advertising restrictions
tough fines for the sale of cigarettes to minors
a ban on the sale of tobacco products from temporary outlets, and
a ban on the display of tobacco products at the point of sale with the exemption for certified specialist tobacconists.
The Department of Health has more information on tobacco reforms and the Tobacco Act 1987 or you can contact Council.
Sale of tobacco
Tobacco retailers have obligations under the Tobacco Act 1987 regarding the display and sale of tobacco products:
tobacco products and packaging must not be visible to the public
health warning stickers must be displayed
vending machine location is tightly regulated, and
it is against the law to sell tobacco to anyone under 18.
For more information, see the Tobacco retailer guide.
Sale of tobacco to minors
Selling tobacco products, including cigarettes, cigars or loose tobacco, to any person under 18 is illegal. This includes the sale of tobacco products from a vending machine to a person under 18.
Local Councils throughout Victoria monitor tobacco sales to minors.
Merri-bek City Council regularly operates a tobacco test purchasing program, where we employ minors (people under the age of 18) to attempt to buy a tobacco product from local retailers.
Heavy financial penalties apply for selling tobacco products to minors. The only way to avoid fines is to ensure that you and all of your staff sell tobacco in accordance with the Tobacco Act 1987.
Smoke-free places
It is illegal to smoke at these places in Victoria:
most enclosed workplaces, including restaurants, cafes and shopping centres
train stations and platforms and bus and tram shelters
underage events
outdoor areas of public swimming pools
within 10 metres of children's playgrounds and skate parks
patrolled beaches
enclosed licensed premises including hotels, bars, clubs, pubs and gaming rooms, and
outdoor dining or drinking areas as per state legislation.
Cigarette litter
It is an offence under the Environment Protection Act 1970 to litter cigarette butts. On-the-spot fines can be issued to people caught littering cigarette butts.
Report to Council
You can contact Council to report incorrect practices related to smoking and tobacco. Council investigates all reports and all reports are confidential.
Get information for new residents
Book an immunisation session
Volunteer in the community
Family Day Care - Meet Hilary


Experts say the cost of treating health problems related to being overweight is immeasurable on a global scale.
The world is in the grip of an obesity pandemic that threatens to overwhelm every country's health system with ailments such as diabetes and heart disease and shorten the life span of future generations, experts at an international conference warned on Sunday.
"Obesity is an international scourge," Prof Paul Zimmet, chairman of the meeting of more than 2,500 experts and health officials, told delegates in a speech opening the International Congress on Obesity. "This insidious, creeping pandemic of obesity is now engulfing the entire world."
"It's as big a threat as global warming and bird flu," said Zimmet, an Australian diabetes expert.
Other experts at the conference said the cost of treating health problems related to being overweight was immeasurable on a global scale, but was estimated at billions of dollars a year in countries such as Australia, Britain and the United States.
"We are not dealing with a scientific or medical problem. We're dealing with an enormous economic problem that, it is already accepted, is going to overwhelm every medical system in the world," said Prof Philip James, chairman of a global task force set up by medical organisations that deal with weight-related problems.
He said governments are being forced to confront rising obesity rates because of the expense of treating related health issues. Among the most worrying problems is skyrocketing rates of obesity among children, which makes them much more prone to chronic diseases as they grow older and could shave years off their lives, experts said.
The children in this generation may be the first in history to die before their parents because of health problems related to weight, Prof Kate Steinbeck, an expert in children's health at Sydney's Royal Prince Alfred Hospital, said in a statement.
The World Health Organisation says more than 1 billion adults around the world are overweight and 300 million of them are obese, putting them at a much higher risk of diabetes, heart problems, high blood pressure, stroke and some forms of cancer.
Zimmet said there are now more overweight people in the world than people who are undernourished, who number about 600 million. People in wealthy countries are leading the world in overeating and not doing enough physical activity, but those in developing countries in Asia, Africa and Latin America are quickly learning bad habits, delegates said.
But the traditional way of dealing with the issue—focusing on getting individuals to adjust their diet and exercise—has failed, and a more multifaceted response involving governments, business and community groups is needed, they said.
Experts also said governments should impose bans on junk food advertising aimed directly at children, although they acknowledged such restrictions were unlikely to come about soon because the food industry would lobby hard against them.
"There is going to be a political bun fight over this for some time, but of course we shouldn't advertise junk food to children that makes them fat," said Prof Boyd Swinburn, a member of the international task force.
Leaders of the International Association for the Study of Obesity, an umbrella group for medical organisations dealing with weight-related and children's health issues, on Sunday approved backing such advertising bans as official policy, its president, Prof Claude Bouchard, announced.
One in four children in Australia are overweight or obese, said Steinbeck. Half of Australia's adult women are overweight, and two thirds of men. The rates were among the highest in the world, with the United States worse, she said, without giving figures for the US.
Underscoring health risks, a medical group on Sunday released statistics showing a fourfold increase in cases of gestational diabetes in Australia's New South Wales state in five years, and said the rising obesity rate was partly the cause.
The group, Diabetes Australia, said 18,500 cases of gestational diabetes—which increases the risk of pregnancy complications such as overweight babies—were reported in 2005 compared with 4,286 cases in 2000.
Modern life has created an environment that is counterproductive to staying at a healthy weight, experts said, including neighbourhoods that are increasingly being built with not enough public space for residents to exercise.
The conference will hear research and papers from almost 400 experts before wrapping up on Friday.


Professional Athletes Who Ride – Ray Lewis | Home of the Crofton Bike Doctor Blog!
Professional Athletes are integrating the bicycle into their workout routines in greater numbers. Many NASCAR drivers are riding and Jimmie Johnson recently said on Lance Armstrong's Podcast that in the mornings you'll often see large groups leaving the track to go for a ride.
Today we are going to talk about a local athlete Ray Lewis and his love of the bicycle. We'll circle back to NASCAR in an upcoming post.
Ravens coach John Harbaugh says the All-Pro linebacker is in the best shape that he's ever seen him in, and Lewis says that's thanks to cycling.
One reason Lewis brought out the bicycle is because it puts less stress on legs than pounding the pavement.
Have any of you seen Ray while out on a ride?
This post is part of our celebration of the 200th Anniversary of the Bicycle and the people who love them.


text:
Q: SQL Server Pivot Table, Null Results This is a popular question I know. I am just learning about pivot tables and don't know where I am going wrong.
create table #test
(
     id varchar(4),
     code varchar(2),
     received_dt varchar(8)
)

insert into #test values ('1234','10','20150312')
insert into #test values ('1234','71','20150312')
insert into #test values ('1234','C5','20150312')
insert into #test values ('4321','10','20150312')
insert into #test values ('4321','71','20150312')
insert into #test values ('987','10','20150312')
insert into #test values ('987','71','20150312')
insert into #test values ('987','C5','20150312')

select id, [code1], [code2], [code3]
from #test
pivot(MAX(code) for code in ([code1], [code2], [code3])) as pvt

drop table #test

Any help/guidance is greatly appreciated. I know this should be easy but I can't seem to wrap my brain around it.
Results in:
ID      Code1   Code2   Code3
1234    NULL    NULL    NULL
4321    NULL    NULL    NULL
987     NULL    NULL    NULL

Want:
ID      Code1   Code2   Code3
1234    10      71      C5
4321    10      71      NULL
987     10      71      C5

EDIT There are MANY code values.

A: You'll need to create another column that contains the Code1, Code2, Code3 values:
;WITH CTE AS
(
    SELECT  *,
            RN = 'Code' +
                 CAST(ROW_NUMBER() OVER(PARTITION BY ID ORDER BY code) AS CHAR(1))
    FROM #test
)
SELECT id, [code1], [code2], [code3]
FROM CTE
PIVOT(MAX(code) for RN in ([code1], [code2], [code3])) as pvt;

UPDATE
If you have an unknown number of codes, you'll need dynamic SQL:
DECLARE @sql NVARCHAR(MAX) = N'', @cols NVARCHAR(MAX) = N'';

WITH CTE AS
(
    SELECT  *,
            RN = 'Code' +
                 CAST(ROW_NUMBER() OVER(PARTITION BY ID ORDER BY code) AS CHAR(1))
    FROM #test
)
SELECT @cols += STUFF((SELECT ',' + QUOTENAME(RN)
                       FROM CTE
                       GROUP BY RN
                       FOR XML PATH('')), 1, 1, '');

SET @sql = N'
SELECT *
FROM (  SELECT  *,
                RN = ''Code'' +
                 CAST(ROW_NUMBER() OVER(PARTITION BY ID ORDER BY code) AS CHAR(1))
    FROM #test) AS d
PIVOT(MAX(code) for RN in (' + @cols + ')) AS p;';

EXEC sp_executesql @sql;


text:
Pitbull Singing Last Nigt Miami New Years Revolution 2019
March 13, 2019 | By admin | Filed in: Blog.
Last year, a headline in the Onion read. to be broadcast in 2019, and multipart films about the Mayo Clinic, Muhammad Ali, Ernest Hemingway, the American Revolution, Lyndon B. Johnson, Barack Obama.
Evidence of the really satisfying reading I did this year — as respite and stimulant — is in the stacks of books between a reading chair and a night table in the bedroom. Few were new. the revoluti.
Looking For A Music Video Where The Guy Is Singing On Top Of A Building Roof Parking Lot Did The Song She Works Hard For Her Money Play In Flash Dance Subtly speaking out? Paris Jackson reacted to the allegations made in the documentary Leaving Neverland against her late father, Michael Jackson. The latest news articles from Billboard Magazine, including reviews, business, pop, hip-hop, rock, dance, country and more. Do People Need Transforms
in this day for the last three years, I was with. their winter tour tomorrow night (November 15th) that will keep them on the road for the rest of the month. The short winter trek kicks off in Amit.
The news comes as he readies to host his annual Worldwide NYE event at Bayfront Park in Miami on New Year's Eve. Pitbull, who NYE event was known as Pitbull's New Year's Eve Revolution when. hits t.
New York gets a warm-up at Madison Square Garden on Oct. 18-19 (then again on Nov. 8-9) before another stop in the city on March 5-6, 2019, and the Barclays. a regular on the late-night television.
2015 in Miami, Florida. (Photo by John Parra/Getty Images for CIROC) The shindig served as a private after-party of sorts following his performance at Pitbull's New Year's Revolution 2016 televised by.
Due to a misstep with NFL programming, NBC will not be airing its usual New Year's Eve With Carson Daly special. And, Pitbull's New Year's Revolution has been canceled. flub before the ball drop la.
It seems we have Pitbull of all people to thank for this change. Mr. 305 will host his free New Year's Eve Revolution. last year about why so many young professionals in Miami remained hesitant abo.
New Year's Eve celebrators have a number of options when it comes to televised specials this year, among them Pitbull's New Year's Revolution. 305 will return to Miami to ring in the New Year," Fox.
Whichever you choose, expect a lot of star power on television this New Year's Eve night. Williams. Pitbull is setting up shop over at Fox for the "New Year's Revolution." He's hosting the special,
Live Streamed Show That Had Musical Artist Living In A Los Angelas Mansion He's in town from Los Angeles, where he lives and runs The Artist Group, a music management. Later, he shows me one room, While rapid gains in streaming revenue have helped the major. Wiltshire said the platform, which went live online in March of 2016, hosts music from more than 100,000 artists worldwide and has
The first musical performance of the night from Times. NBC's "New Year's Eve with Carson Daly" from Times Square will include a performance by Gwen Stefani. Fox has "Pitbull's New Year's Revolution.
Fox first began airing "Pitbull's New Year's Revolution" in 2014, with the rapper hosting the special from his native Miami. The 2016 edition of the. and Timabland. Last year's edition of Pitbull's.
The last few hours of 2016 are sure to be filled with performances, fun and of course, fireworks. Pitbull's New Year's Eve Revolution. Eve is the best night of the entire year," said President and.
Last. the night. Come down, leave your keys at home, your cars at home, and have a great time with the family." You can watch Pitbull's New Year's Revolution this Saturday, at 11 p.m., right here o.
The special will air live Saturday, December 31 at 11 PM from Miami's Bayfront Park. Performers will be announced later. Last year the show featured. and Queen Latifah. Pitbull's New Year's Revolut.
Visit LauderAle.co. The oceanfront Beach House Pompano will throw a James Bond-inspired Casino Night soiree. Facebook.com/WFortLauderdale. Pitbull's annual New Year's Eve Revolution draws tens of t.
San Bernardino Symphony Orchestra Los Robles Master Chorale Beethoven Insight with Beth Ruyak is taking a sabbatical for the month of March to do some behind the scenes renovations. We'll be back on Tuesday, April 2 with all-new shows. New Zealand Symphony Orchestra. Ney [nai, nāī, nāy, nay]. Ney, Elly. Ney, Joseph Napoléon, Prince de la Moskova. Neyschl. Nabokov, Nicolas [Nikolay] (b Lyubcha, Novogrudok,
When it comes to ringing in the new year Miami-style, there isn't a shortage of things to do. But it's no secret that those über-fabulous things will cost you a pretty penny. From fireworks to bars se.
She then took a dig at her competing Times Square host on ABC's "Dick Clark 's New Year's Rockin' Eve": "If Ryan Seacrest can do it, I can do it." Over the last few years. Fox will again head to Mi.
Classical Music Used In Pop Culture Goes To Explosions Open Culture, Open Poverty "Currency kept passing me by, but I didn't cry." –Tupac Shakur, Pain Henry: Give away the fruits of your brain, your journalism, your music, and the internet will be so bountiful in the opportunities it creates that you'll do better financially in the end. (Really just a variation on the "playing
Property Identification Number Old Town School Of Folk Music Live Streamed Show That Had Musical Artist Living In A Los Angelas Mansion He's in town from Los Angeles, where he lives and runs The Artist Group, a music management. Later, he shows me one room, While rapid gains in streaming revenue have helped the major. Wiltshire said the platform, which went live online in
« Property Identification Number Old Town School Of Folk Music
San Bernardino Symphony Orchestra Los Robles Master Chorale Beethoven »


text:
Episode 9, with guests Howard Wolfson, Deputy Mayor of NYC, and Kevin Sullivan, Former Communications Director for President George W. Bush
By Josh King, on May 6th, 2011
Howard Wolfson and Kevin Sullivan are our interview guests this week.
Original Air Date: May 7, 2011 on SiriusXM Satellite Radio "POTUS" Channel 124. Click above to listen
Howard Wolfson and I go back to the 1990's in Washington, D.C. We competed for the title of worst poker player in our weekly game of political types with thin wallets, and mine got thinner than Howards.
Howard was, back then, executive director of the Democratic Congressional Campaign Committee. But as I found out over various losing poker hands, Howard was also a baseball fan of the highest order, and also a critic of rock music critic with truly professional chops. His yearly Top Tens were eagerly awaited by his long list of followers looking for Christmas gifts of the best songs of the year.
But that's the Howard most people don't know. He gravitated back to New York, worked for Chuck Schumer during his Senate Run in '98 and then helped a certain First Lady, Hillary Rodham Clinton, take over Pat Moynihan's Senate State in 2000.
After Hillary was reelected in 2006, her sights turned to the White House, and Howard was there, by her side, until that day on June 7, 2008, when she finally said "Although we weren't able to shatter that highest, hardest glass ceiling this time, thanks to you, it's got about 18 million cracks in it."
Now, as Deputy Mayor of New York City, Howard has another high-profile boss, the three-term Mayor, Michael Bloomberg, who himself has to beat back persistent rumors that he may make a run for the presidency. Howard's presence at his side, and the experience he has in national campaigns, tends to feed speculation doesn't do a lot to damp those down.
Also on our broadcast this week, we talk to Kevin Sullivan, the former Director of Communications for President George W. Bush. It's a role that few people truly understand outside White House circles. It's not the press secretary, who spends so much of his or her time on camera. Rather, it's the behind-the-scenes operator who works to match Administration policy with public positioning. Kevin, who now runs his own firm, Kevin Sullivan Communications, held prior titles of Vice President of Communications for the Dallas Mavericks and NBC Sports, and Senior Vice President of Corporate Communications for NBC Universal. Check out Kevin's blog for more insights into the mind of a man who each day helped shape the message of the 43rd President of the United States.
On our Polioptics broadcast on SiriusXM Satellite radio, must also review the breaking news of the death of Osama bin Laden and how that affects New York City as well as some of the other issues that arrive on his doorstep. These include the rebuilding of the World Trade Center site, the debate over bike lanes in New York, the state of the New York City media community in general, and how social media tools like Twitter evolve the role of the modern media spokesman.
« Episode 10, with guest Anne Edwards, Former White House Director of Press Advance
Episode 8, with guest David Hume Kennerly, Pulitzer Prize-winning legendary photojournalist »


The Squam Lakes Conservation Society will be joining us to talk about the importance of the highlands in the Squam Watershed. The Squam Uplands Initiative establishes a framework for the protection of the large tracts of land lying above 900' in elevation, an area larger that the eight lakes in the Squam watershed. The Uplands contain the headwaters of Squam's tributaries, the viewpoints from the trail network, the majority of our working forests, and the watershed's largest blocks of unfragmented habitat. Roger Larochelle from the Squam Lakes Conservation Society will be describing the case for prioritizing the protection of these lands and the strategies for their permanent protection. Join us at the Squam Lakes Association, 534 US Route 3, Holderness, NH at 7pm. This program is free and open to the public.


NetLib Vocational Training Institute (NVTI) last Saturday graduated 120 young professionals in various disciplines, including computer technology, electricity, cosmetology, masonry, tailoring and hotel management.
The graduation exercise was held in the NVTI auditorium in Congo Town, and was attended by several government officials, parents, local and international partners.
Guest speaker Reverend Kennedy G. Sandy, political leader of the Liberia Transformation Party, said the absence of vocational education slows down the country's economy.
"Any nation that fails to prioritize vocational education would be committing economic suicide. For Liberia, I see vocational education as a means to reduce HIV/ AIDS so that our young girls will have something to do and not engage in things that will hamper their lives," Rev. Sandy said.
The involvement of Liberians in technical and vocational education has the potential to address some of the many challenges facing young people, including unemployment, said the LTP leader.
"Vocational education has the tendency to reduce crimes in Liberia and I believe that it remains the best strategy for our country in creating empowerment. I want to challenge you to transfer your education to others and also be entrepreneurs that Liberia will need," he admonished the graduates.
He noted that technical and vocational education can play important roles in strengthening the economic system of Liberia, as well as building a workforce for the current and future generations.
The founder of the NVTI, Abdullah Kamara, said he was delighted to see young people graduating in various disciplines and ready to contribute to the development of the society.
Since the institution was founded, it has graduated over 700 students in various professional disciplines. He, however, expressed disappointment in the Liberian government for its failure to support the institution, especially students who are unable to pay their fees.
"We have called on the various government ministries and agencies to support our children who want to acquire vocational and technical education, and we are yet to get a word from them," he lamented.
Mr. Kamara hailed members of the teaching staff, parents and local and international partners for their commitment in supporting the students' efforts to achieve their vocational and technical education goals.
Meanwhile, twenty of the graduates received scholarships to advance in their areas of qualification.


text:
Q: Difference between write method in ViewController and AppDelegate I want to ask a simple question as i am new in Objective c.
Is there are any difference to write method on AppDelegate instead of UIViewController??
Or which type of method i should write on AppDelegate.
And what if i write method in UIViewController and call from AppDelegate.
Is there are safe to write method on UIViewConroller class and call it from AppDelegate.m file by that UIViewController's object.???
If i write it on ViewController and call it from AppDelegate.m then is it safe or not???

A: Hi @Dhaval you can write and call method from any where in your project but for that you have to define the function definition in .h file and that make this function global for the project.
Next thing is that when you define any function in app delegate it access by it share instance because app delegate instance live still your application is not terminate.

A: The AppDelegate is shared singleton class.
That means appdelegate object will be created only once in your entire app life cycle.
Creating method in AppDelegate is recommended when you have to process something multiple times in your application and that method may be called through viewcontroller, from appdelegate itself or other singleton class.
Like. Process zip archive, Check version of iOS device
And yes Most important thing
This can also be done in other ways.
However if you want to call viewcontroller method from AppDelegate you need to create an object of viewcontroller or get viewcontroller object from memory. And there should be some solid reason to do that.
It depends on your app Architecture and Requirement.


"I'm hip to hip hop." Is he though?
When it comes to bringing the house down with pure comic genius, Michael Blackson is your guy. However, the same can't really be said for his hip hop knowledge. Fortunately, your boy kept the jokes coming as he worked his way through this rather tough round of Hip Hop Card Revoked.
Blackson is a Hip Hop Squares regular, but as it turns out, being a contestant in the hot seat is way harder than it looks. Even though questions about rapper/producer connections threw him for a whirl, he did redeem himself with a few answers he nailed like he'd been practicing all his life.
Think you've got what it takes to beat Michael Blackson at this game? Take the quiz below and then compare your score to his in the video below.
Don't forget to tune into the Hip Hop Squares season 2 finale tonight at 9/8c on VH1.


Ghanaian lawyer, media personality, entrepreneur and humanitarian-Sandra Ankobiah who is arguably one of the most intelligent Ghanaian female celebrities out there has opened up about her life including her legal work, past pageantry experience, her TV career days and other things on UTV's Chat Show, ATUU, hosted by Abeiku Santana.
Ankobiah who is an attorney in Ghana obtained her first and master's degrees from the University of Buckingham between 2005 and 2009, where she studied International and Commercial Law, with a specialisation in World Trade said she grew up wanting to become a lawyer—and she has worked hard to make that happen.
Sandra, a beautiful and eloquent brainer, talked about what has recently become a national conversation in relation to pageantry, the Miss Ghana scandal. She said the Miss Ghana brand has greatly been tainted and there's an absolute need for rebranding of the pageant she was a participant in 2002 and emerged as the first runner-up.
Speaking about her humanitarian works, the coordinator for The Legal Advocacy Foundation mentioned that she is the current Public Relations Officer (PRO) for the International Federation of Women Lawyers (FIDA) in Ghana—work she does as part of her give back to society.
During the Truth/Dare segment, Ankobiah named Yvonne Okoro has her favorite actress in Ghana.


This license plate lets you express your driving attitude and show off your love of the ocean. Made of sturdy & durable aluminum, it is water-resistant with a UV coating. This custom plate is the perfect complement for drivers with novelty plates on the front of their vehicles. Measures 12″ x 6″.


High End Cleanser First Impression!
On my last trip to Boots for a new Estee Lauder Double Wear foundation the lovely lady behind the counter gave me a handful of Estee Lauder's Perfectly Clean Multi-Action cleanser samples, sold for £22.50 per 150ml bottle.
This Cleanser can be used as a foam cleanser or a purifying mask depending on the way it is applied and the sample I was given was for normal/combination skin which is perfect for my skin type.
On first impression the cleanser was very strongly scented, almost as if I was applying perfume to my face, I don't mind fragranced products but if this is something that bothers you I would definitely steer clear!
I decided to use the product as a mask (I will insert a lil video of how I did it below) and it went on like a dream.
The cleanser rinsed really well and left my skin feeling as smooth as a baby's bottom and looking really fresh and clean.
However, I'm not so sure I'd be willing to move from my less than a fiver Simple cleanser that serves me well to a £22.50 one! I don't think I loved it that much.
Previous Post Just Another Liquid Lipstick?


text:
News Live 365: March 16, 2021
March 16, 20218:27 am
A Jamestown woman was arrested by the Pennsylvania State Police after allegedly pulling a gun on the staff of a bar and then shooting herself. According to eyewitnesses 31 year old Samantha Jo Wertz was causing a disturbance at a saloon in Crawford County's Summerhill Township and then threatened staff with a firearm when asked to leave. She was eventually wrestled to the ground and accidentally shot herself in the leg. Wertz was taken to Meadville Medical Center and has been charged with aggravated assault, recklessly endangering another person, terroristic threats, and firearms not to be carried without a license.
Meadville's VITA, or Volunteer Income Tax Preparation Service, which provides cost free income tax preparation for needy families will be back this year, but the operation will be much different than years past as volunteers attempt to navigate pandemic restrictions. This year VITA is only available to do federal and state returns for households with an annual adjusted income of $28,000 or less and they will only be preparing 400 returns this year on a first come, first serve basis. There will be no appointments, instead taxpayers need to bring all their appropriate tax documentation to the children's entrance of the Meadville Public Library and deposited in an envelope with a completed intake sheet. You will be contacted during or after your return is processed. More information can be found by emailing vita@allegheny.edu or calling (814)813-1350.
Governor Tom Wolf has announced that more COVID-19 restrictions will be changed in April. Some targeted restrictions on restaurants, bars, casinos, and sporting events will be lifted or changed on April the 4th. On the 4th restaurants may resume bar service, food purchases do not need to be made to purchase alcohol, and alcohol curfews are no longer in effect. Occupancy will be increased to 75% for bars and restaurants that self certify and continue to follow the self certify process and 50% for establishments that do not. Mask mandates and social distancing will still apply and the full details can be found at Governor Wolf's website.
The Pennsylvania State Police based in Corry are in possession of a blue tote containing SCUBA gear. The tote was located near Tarbell Road on State Route 6 in Union Township, Erie County on Monday, February 22nd. Please call (814)663-2043 if you know anything about this mysterious SCUBA gear.
After a meeting with Attorney General Josh Shapiro the largest gun show promoter in Pennsylvania, Eagle Arms Productions, has become the first firearms show promoter in the nation to agree to halt the sale of 80% receivers, which are sold in kits and can be used to produce fully functional firearms that do not require a serial number and are referred to as 'ghost guns' by police. These so-called ghost guns were recovered as evidence in more than 10,000 crimes in the United States in 2019, According the Shapiro criminal enterprises are using people to buy the 80% receivers and manufacture the rest of a weapon for weapons traffickers.
The Pennsylvania House Government Oversight Committee has begun an official investigation into the Wolf Administration's handling of nursing homes during the pandemic. Nearly 13,000 nursing home residents have died of COVID-19 related issues and the investigation seeks to determine whether government orders to return diagnosed COVID patients to nursing home contributed in any way to the death count. The Wolf Administration asserts that they were following the CDC's recommendations at the time.


Blue Air Flight 0B4223 connects Turin, Italy to Naples, Italy, taking off from Turin Caselle Airport TRN and landing at Naples Airport NAP.
The flight distance is 722 km / 448 miles and the average flight speed is 564 km/h / 350 mph. In the last 30 days, the average delay of the flight was 15 minutes and the flight was on-time 73% of the times. The average flight time is 1 hour and 16 minutes.
This Blue Air flight can also be referenced as BMS4223, 0B 4223, BMS 4223.
0B4223 Flight Delay Compensation up to 600€!
There was a total of 16 flights connecting Turin to Naples, operated by 7 different airlines in the past. At this time there is a total 5 flights connecting Turin to Naples, operated by 3 different airlines.


text:
Research & Academic / Publications / Publication Items / El Anatsui at the Clark
El Anatsui at the Clark
El Anatsui
El Anatsui in conversation with Chika Okeke-Agulu
With an essay by Alisa LaGamma
The Ghanaian-born sculptor El Anatsui is one of the most significant artistic innovators of our time, merging personal, local, and global concerns in his visual creations. By weaving together discarded aluminum tops from Nigerian liquor bottles, Anatsui creates large-scale sculptures that demonstrate a fascinating interplay of color, shape, and fluidity.
Published to accompany an exhibition at the Sterling and Francine Clark Art Institute, this catalogue features an intimate look at several of the artist's recent works, including Strips of Earth's Skin (2008), Intermittent Signals (2009), and Delta (2010). Scholar and curator Alisa LaGamma provides a brief illustrated history of El Anatsui's career and an analysis of his practice. The noted artist, curator, and professor Chika Okeke-Agulu engages his former teacher in a lively discussion of the themes of history, economy, sustainability, and identity explored within the artist's work. Dramatic photographs of the installations at the Clark provide a unique look at these immersive sculptures.
Alisa LaGamma is Curator in the Department of the Arts of Africa, Oceania, and the Americas at The Metropolitan Museum of Art and is the author of numerous books on African art.
Chika Okeke-Agulu is Assistant Professor in the Department of Art and Archaeology at Princeton University and has published widely on African and African Diaspora art history and theory.
48 pages, 9 1/4 x 9 inches
38 color illustrations
Published by the Sterling and Francine Clark Art Institute and distributed by Yale University Press
ISBN 978-1-935998-02-0 (softcover)


Geography is the study of Earth's landscapes, peoples, places and environments; quite simply it is about the world in which we live. Geography is unique in bridging the social sciences (human geography), with the natural sciences (physical geography). Reading around the subject and keeping up to date with current geographical issues are essential for this ever-changing subject. You will also be required to write formal essays, undertake fieldwork, conduct individual research and deliver presentations.
5 GCSEs at C grade or above including English, Mathematics, Science and Geography. If this subject is new to you we will explore your options at interview.


I'm sure you know that currently the biggest display smartphone in the mobile space is the smartphone/tablet hybrid the Samsung Galaxy Note, however it appears that Lenovo wants to get into the 5-inch handset game perhaps to challenge the Galaxy Note, by launching the LePhone S880 smartphone.
According to the guys over at Phone Arena by way of MicGadget, Lenovo has launched the LePhone S880 smartphone with a 5-inch WVGA touch screen for the Chinese market, and is the third LePhone handset for China.
Other than that 5-inch touch screen the Lenovo LePhone S880 offers the latest Android OS, Android Ice Cream Sandwich, is powered by a 1GHz single core Media Tek processor, 512MB RAM, a meagre 4GB storage, a 5 megapixel auto-focus rear facing camera, 0.3 megapixel front facing camera, GPS and microSD expansion.
The Lenovo LePhone S880 Android smartphone also features a dual SIM slot for GSM and WCDMA, is 9.9mm thick, has a 2250mAh battery and weighs in at 200 grams, and commands a price tag of some 2199 Yuan, roughly $345 US.
We also have a short video demonstrating the Lenovo LePhone S880 in action for your viewing consideration below; however unless you can understand Chinese the commentary wont be of much use to you, but at least you can see what the Android smartphone looks like as opposed to the Samsung Galaxy Note…enjoy.


Buttons is a 19 year old domestic shorthair cat who we met for the first time this July. She has been adopted by our veterinary nurse Sinead, who has a soft spot for gorgeous senior pets. Buttons has settled right into a very loving home, with Shadow, a beautiful 13 year old lurcher who Sinead also adopted a few years ago.
Buttons had very severe dental disease when we first saw her. She was underweight, her coat was in poor condition from her inability to self groom, and her mouth was very inflamed with several teeth very diseased and covered in heavy amounts of plaque and tartar.
We ran pre-anaesthetic blood work on her to check her kidneys and liver function was all fine, then gave her a general anaesthetic to treat her dental disease. Because of her age we had her on intravenous fluids throughout the procedure in order to help maintain her blood pressure. We also ensured her temperature stayed normal throughout, by having her on a heat mat with heat pads as well. We started by using our ultrasonic scaler to clean all the plaque off her teeth, before polishing them afterwards. She ended up having several teeth removed due to the severity of dental disease that she had, before which we gave her local anaesthetic injections into her gums. Once finished, we placed stitches in her gums to speed up healing. She went home later that day on some pain relief medication for a few days, and since then she hasn't looked back. She is thoroughly enjoying a pampered life and has become a much loved four-legged family member with Sinead, Rory and Shadow.


text:
Q: Append a Range to Log (Txt) file I want to append a range from "A2:B" & LastRow to a log txt file with a ; delimiter.
For now I know how to read from separate cells but not from "A2:B"
Column A = text
Column B2:B = =IF(A2="","",1)
My code:
Dim strData As String
Dim strLine As String
strData = ""
Open "\\x-ap01\Log.txt" For Input As #1
While EOF(1) = False
    Line Input #1, strLine
    strData = strData + strLine & vbCrLf
Wend

strData = strData + Cells(2, 1) & ";" & Cells(2, 2) & ";"

Close #1
Open "\\x-ap01\Log.txt" For Output As #1
Print #1, strData
Close #1

A: Do you mean like this?
Sub x()

Dim strData As String
Dim strLine As String
Dim lastrow As Long
Dim r As Long

lastrow = Range("A" & Rows.Count).End(xlUp).Row

Open "\\x-ap01\Log.txt" For Append As #1

For r = 2 To lastrow
    If Cells(r, 1) <> vbNullString Then
        strData = strData & Cells(r, 1) & ";" & Cells(r, 2) & ";"
        strData = strData & strLine & vbCrLf
    End If
Next r

Print #1, strData
Close #1

End Sub


On the weekend of February 2nd-3rd we held our annual Winter Concert Workshop. This is a weekend-long workshop dedicated solely to our concert program. We hired fifteen professional musicians, conductors and educators to spend a weekend with our students. The value of learning directly from industry professionals was a rewarding and long-lasting experience for our young musicians. In addition to having masterclasses on each individual instrument, the kids also worked with guest conductors on their Large Group Performance Evaluation programs.


Luang Prabang is a beautiful and tranquil dream-like setting with a fusion of foreign influences and splendid landscape scenery, making this an idyllic, unspoiled and charming destination for visitors.
Declared a UNESCO World Heritage City, Luang Prabang boasts both traditional Laos and colonial architecture with charming results that make exploring and touring the city an absolute delight. Take a tour around the temples, visit a popular waterfall or cave and soak in Luang Prabang's unique atmosphere.


text:
Amalric mixes eroticism, mystery in 'Blue Room'
Sheri Linden
There are two blue rooms in the spellbinding new feature by actor-director Mathieu Amalric: the provincial hotel room where a couple conducts an adulterous affair, and the courtroom where they later stand trial for murder. Just who they're accused of killing is only gradually revealed in this taut mystery.
What tantalizes is the way the story moves between their private passion and their public shame, the way then and now become synchronous. Amalric navigates the shifts with a lapidary precision.
With his co-star Stéphanie Cléau, Amalric has adapted a novel by the prolific Georges Simenon (creator of the detective Maigret), stripping it down to its essence. "The Blue Room" opens, like the book, in the heat of erotic enchantment, captured with bracing directness and beauty. There are warning signs, too, in the bedchamber where Julien (Amalric), a successful farm machinery rep, and pharmacist Esther (Cléau) rendezvous. Their excitement is laced with doom: the bite that leaves him bleeding, her pointed questions about his wife, the sight of her husband through the window.
The scene will play out again, in pieces, at the police precinct, where the dogged prosecutor (Laurent Poitrenaux, excellent) reads back the couple's intimate conversation. It's now part of an official transcript, and Julien listens in a state of disbelief. He's in over his head and, it becomes increasingly clear, was from the get-go.
Cléau, a non-actor who works mainly as an adapter of texts for theater, is remarkably unselfconscious. Over the course of the story she effects extraordinary changes in Esther's demeanor. But they're really changes in her lover's perception. Every revelation registers in the gifted Amalric's gaze: infinitesimal physical mutations, emotional detonations.
'The Blue Room'