Translating SQL to Spreadsheet: A Survey

Spreadsheets are the most popular and conventionally databases in use today. Since Spreadsheets are visual and expression based languages, research into the features of spreadsheets is therefore a highly relevant topic to study. Spreadsheet can be viewed as a Relation Database which contains a sheet and its corresponding information in terms of rows, while in RDBMS each table or say relation also represents its contained information in terms of rows. Each row represents a record which belongs to one or more relation. Spreadsheets uses different formulae to extract required information but it need expert knowledge about the tool and its usage. One can extend the usage of Spreadsheet in any direction as it provides great flexibility in terms of data storage and dependency of stored data. We surveyed some of research which took great attention over Spreadsheets and its applicability in different functional cases, such as Data Visualization, SQL Engines and many more. Our survey focuses on QUERYSHEET, ES-SQL, MDSHEET and PrediCalc [3], [5], [4], [8]. These different researches are motivations to our survey and attraction in Spreadsheets and its functional extensibility

ANTIOXIDANT ACTIVITY AND ANTIPROLIFERATIVE ACTION OF METHANOLIC EXTRACT OF LIQUORICE (GLYCYRRHIZA GLABRA) IN HEPG2 CELL LINE

Objective: To evaluate the in vitro antioxidant activity of liquorice (Glycyrrhiza glabra) against H2O2 induced oxidative stress in HepG2 cell line.Methods: Antioxidant activity of methanolic extracts of Glycyrrhiza glabra was investigated by measuring total phenolic content using folin-ciocalteu reagent (FCR), free radical scavenging activity by DPPH and ferric reducing antioxidant power (FRAP). The presence of phenolic compounds and flavonoids in the extract was confirmed by Liquid Chromatography-Mass Spectrometry (LC-MS) analysis. Furthermore, the protective effect of methanolic extract of Glycyrrhiza glabra against oxidative stress induced by H2O2 in HepG2 cells was investigated by MTT assay. HepG2 cells were exposed with five different treatments viz. liquorice, H2O2, ascorbic acid, H2O2+liquorice and H2O2+ascorbic acid, to explore the effect of the extract on malondialdehyde (MDA) production, catalase activity, and glutathione reductase levels.Results: The total phenolic content estimated in Glycyrrhiza glabra extract was found to be 241.47 µg per 1000 µg/ml of methanolic extract. It was found that as the concentration of the extract was increased both the free radical scavenging activity and ferric ion reducing power was also found to increase. LC-MS analysis confirmed the presence of eight different phenolic compounds in the methanolic extract which are possibly contributing to the antioxidant activity exhibited by the extract. It was also observed that liquorice treated HepG2 cells showed lower MDA and higher glutathione and catalase levels as compared to only H2O2 treated HepG2 cells where increased MDA production, decreased glutathione reductase and catalase production was observed.Conclusion: Our results thus conclude that, the methanolic extract of Glycyrrhiza glabra can be used as natural supplements in various disease conditions where oxidative stress has been reported. Â

An alum [KAl (SO4)2.12H2O] catalyzed microwave assisted multicomponent synthesis of bioactive functionalized benzylpyrazolyl coumarin and quinolinone derivatives in PEG

An efficient and environmentally benign method has been developed for the synthesis of benzylpyrazolyl coumarin and quinolinone derivatives, hydroxy coumarin derivatives using Alum [KAl (SO4)2.12H2O] catalyst and Polyethylene glycol as green solvent under microwave condition. Keywords: Knoevenagel, Michael addition reaction, coumarins, quinolinones, alum, polyethylene glycol, multicomponent microwave irradiation method

Solar fuels photoanode materials discovery by integrating high-throughput theory and experiment

The limited number of known low-band-gap photoelectrocatalytic materials poses a significant challenge for the generation of chemical fuels from sunlight. Using high-throughput ab initio theory with experiments in an integrated workflow, we find eight ternary vanadate oxide photoanodes in the target band-gap range (1.2–2.8 eV). Detailed analysis of these vanadate compounds reveals the key role of VO_4 structural motifs and electronic band-edge character in efficient photoanodes, initiating a genome for such materials and paving the way for a broadly applicable high-throughput-discovery and materials-by-design feedback loop. Considerably expanding the number of known photoelectrocatalysts for water oxidation, our study establishes ternary metal vanadates as a prolific class of photoanode materials for generation of chemical fuels from sunlight and demonstrates our high-throughput theory–experiment pipeline as a prolific approach to materials discovery

Bi-containing n-FeWO_4 Thin Films Provide the Largest Photovoltage and Highest Stability for a sub-2 eV Band Gap Photoanode

Photoelectrocatalysis of the oxygen evolution reaction remains a primary challenge for development of tandem-absorber solar fuel generators due to the lack of a photoanode with broad solar spectrum utilization, a large photovoltage, and stable operation. Bismuth vanadate with a 2.4–2.5 eV band gap has shown the most promise becauses its photoactivity down to 0.4 V vs RHE is sufficiently low to couple to a lower-gap photocathode for fuel synthesis. Through development of photoanodes based on the FeWO_4 structure, in particular, Fe-rich variants with addition of about 6% Bi, we demonstrate the same 0.4 V vs RHE turn-on voltage with a 2 eV band gap metal oxide, enabling a 2-fold increase in the device efficiency limit. Combinatorial exploration of materials composition and processing facilitated synthesis of n-type variants of this typical p-type semiconductor that exhibit much higher photoactivity than previous implementations of FeWO_4 in solar photochemistry. The photoanodes are particularly promising for solar fuel applications given their stable operation in acid and base

Albiglutide and cardiovascular outcomes in patients with type 2 diabetes and cardiovascular disease (Harmony Outcomes): a double-blind, randomised placebo-controlled trial

Background: Glucagon-like peptide 1 receptor agonists differ in chemical structure, duration of action, and in their effects on clinical outcomes. The cardiovascular effects of once-weekly albiglutide in type 2 diabetes are unknown. We aimed to determine the safety and efficacy of albiglutide in preventing cardiovascular death, myocardial infarction, or stroke. Methods: We did a double-blind, randomised, placebo-controlled trial in 610 sites across 28 countries. We randomly assigned patients aged 40 years and older with type 2 diabetes and cardiovascular disease (at a 1:1 ratio) to groups that either received a subcutaneous injection of albiglutide (30–50 mg, based on glycaemic response and tolerability) or of a matched volume of placebo once a week, in addition to their standard care. Investigators used an interactive voice or web response system to obtain treatment assignment, and patients and all study investigators were masked to their treatment allocation. We hypothesised that albiglutide would be non-inferior to placebo for the primary outcome of the first occurrence of cardiovascular death, myocardial infarction, or stroke, which was assessed in the intention-to-treat population. If non-inferiority was confirmed by an upper limit of the 95% CI for a hazard ratio of less than 1·30, closed testing for superiority was prespecified. This study is registered with ClinicalTrials.gov, number NCT02465515. Findings: Patients were screened between July 1, 2015, and Nov 24, 2016. 10 793 patients were screened and 9463 participants were enrolled and randomly assigned to groups: 4731 patients were assigned to receive albiglutide and 4732 patients to receive placebo. On Nov 8, 2017, it was determined that 611 primary endpoints and a median follow-up of at least 1·5 years had accrued, and participants returned for a final visit and discontinuation from study treatment; the last patient visit was on March 12, 2018. These 9463 patients, the intention-to-treat population, were evaluated for a median duration of 1·6 years and were assessed for the primary outcome. The primary composite outcome occurred in 338 (7%) of 4731 patients at an incidence rate of 4·6 events per 100 person-years in the albiglutide group and in 428 (9%) of 4732 patients at an incidence rate of 5·9 events per 100 person-years in the placebo group (hazard ratio 0·78, 95% CI 0·68–0·90), which indicated that albiglutide was superior to placebo (p<0·0001 for non-inferiority; p=0·0006 for superiority). The incidence of acute pancreatitis (ten patients in the albiglutide group and seven patients in the placebo group), pancreatic cancer (six patients in the albiglutide group and five patients in the placebo group), medullary thyroid carcinoma (zero patients in both groups), and other serious adverse events did not differ between the two groups. There were three (<1%) deaths in the placebo group that were assessed by investigators, who were masked to study drug assignment, to be treatment-related and two (<1%) deaths in the albiglutide group. Interpretation: In patients with type 2 diabetes and cardiovascular disease, albiglutide was superior to placebo with respect to major adverse cardiovascular events. Evidence-based glucagon-like peptide 1 receptor agonists should therefore be considered as part of a comprehensive strategy to reduce the risk of cardiovascular events in patients with type 2 diabetes. Funding: GlaxoSmithKline

Robust estimation of bacterial cell count from optical density

Optical density (OD) is widely used to estimate the density of cells in liquid culture, but cannot be compared between instruments without a standardized calibration protocol and is challenging to relate to actual cell count. We address this with an interlaboratory study comparing three simple, low-cost, and highly accessible OD calibration protocols across 244 laboratories, applied to eight strains of constitutive GFP-expressing E. coli. Based on our results, we recommend calibrating OD to estimated cell count using serial dilution of silica microspheres, which produces highly precise calibration (95.5% of residuals <1.2-fold), is easily assessed for quality control, also assesses instrument effective linear range, and can be combined with fluorescence calibration to obtain units of Molecules of Equivalent Fluorescein (MEFL) per cell, allowing direct comparison and data fusion with flow cytometry measurements: in our study, fluorescence per cell measurements showed only a 1.07-fold mean difference between plate reader and flow cytometry data

Autocharge: Automatically Charge Smartphone Using Light Beam

Today's smartphones are very power hungry. They use powerful hardware including multicore CPU, many GPU cores, large screen and high-speed wireless network interfaces, all with a high power consumption. They also run many energy-expensive applications such as high-end games, full HD video playback, and various continuous sensing tasks for context awareness. As a result, many users suffer from a short battery lifetime on their smartphones and thus they often have to recharge their smartphones every day or even multiple times per day. To make user put in less efforts and have a full battery every time they use their smartphone we have researched the idea of AutoCharge. The idea was conceived by Microsoft [1], but their design was a costly affair for the regular consumer. Taking inspiration from Microsoft we have made a prototype which can cater users from all walks of life

Harnessing VLSI System Design with EDA Tools

This book explores various dimensions of EDA technologies for achieving different goals in VLSI system design. Although the scope of EDA is very broad and comprises diversified hardware and software tools to accomplish different phases of VLSI system design, such as design, layout, simulation, testability, prototyping and implementation, this book focuses only on demystifying the code, a.k.a. firmware development and its implementation with FPGAs. Since there are a variety of languages for system design, this book covers various issues related to VHDL, Verilog and System C synergized with EDA tools, using a variety of case studies such as testability, verification and power consumption. * Covers aspects of VHDL, Verilog and Handel C in one text; * Enables designers to judge the appropriateness of each EDA tool for relevant applications; * Omits discussion of design platforms and focuses on design case studies; * Uses design case studies from diversified application domains such as network on chip, hospital on chip, analog to digital conversion and embedded system design; * Facilitates with code and tool flows the design cycle for systems on chip with increasing complexity; * Demonstrates standard development cycles, making use of latest concepts such as ‘Soft IP Cores’, ‘Hardware Software Codesign’ etc

Harnessing VLSI System Design with EDA Tools

XXVIII, 156 p.online resource