The various performance criteria applied in this analysis include the probability of reaching the ultimate target, the costs, elapsed times and system vulnerability resulting from any intrusion. This Excel file contains all the logical, probabilistic and statistical data entered by a user, and required for the evaluation of the criteria. It also reports the results of all the computations.

Price-To-Book-Ratio Time Series for Excel Force MSC Bhd. Excel Force MSC Berhad, together with its subsidiaries, develops, provides, and maintains software application solutions for the financial services industry in Malaysia. The company operates through Application Solutions, Maintenance Services, Application Services Provider, and Other segments. Its product portfolio includes CyberStock BTX, a bridging trader and exchange system platform that provides trading tools classes; and CyberStock ECOS, a stock broking solution which offers real time market information, place trades, and manage orders solution. In addition, the company provides CyberStock Mobile Trader, a mobile trading system that connects users smartphones to exchanges to manage trading activities; and CyberStock EDS, an exempt dealer system that provides advanced trading infrastructure and facilities for commercial banks. Further, it offers CyberStock SMF, a share margin financing system that enables financial institutions, brokerage firms, and banks to operate and manage margin financing services; and CyberStock CNS, a custodian and nominee system, which provides value-added services, such as trade settlement, cash balances investment, income collection, corporate actions processing, recordkeeping and reporting to custodian banks for domestic services. Additionally, the company provides CyberStock BOS, a back office system to manage enormous file and data; and offers network and security services. Excel Force MSC Berhad was founded in 1994 and is based in Petaling Jaya, Malaysia.

"The Statistical Abstract of the United States, published since 1878, is the standard summary of statistics on the social, political, and economic organization of the United States. It is designed to serve as a convenient volume for statistical reference and as a guide to other statistical publications and sources. The latter function is served by the introductory text to each section, the source note appearing below each table, and Appendix I, which comprises the Guide to Sources of Statisti cs, the Guide to State Statistical Abstracts, and the Guide to Foreign Statistical Abstracts. The Statistical Abstract sections and tables are compiled into one Adobe PDF named StatAbstract2009.pdf. This PDF is bookmarked by section and by table and can be searched using the Acrobat Search feature. The Statistical Abstract on CD-ROM is best viewed using Adobe Acrobat 5, or any subsequent version of Acrobat or Acrobat Reader. The Statistical Abstract tables and the metropolitan areas tables from Appendix II are available as Excel(.xls or .xlw) spreadsheets. In most cases, these spreadsheet files offer the user direct access to more data than are shown either in the publication or Adobe Acrobat. These files usually contain more years of data, more geographic areas, and/or more categories of subjects than those shown in the Acrobat version. The extensive selection of statistics is provided for the United States, with selected data for regions, divisions, states, metropolitan areas, cities, and foreign countries from reports and records of government and private agencies. Software on the disc can be used to perform full-text searches, view official statistics, open tables as Lotus worksheets or Excel workbooks, and link directly to source agencies and organizations for supporting information. Except as indicated, figures are for the United States as presently constituted. Although emphasis in the Statistical Abstract is primarily given to national data, many tables present data for regions and individual states and a smaller number for metropolitan areas and cities.Statistics for the Commonwealth of Puerto Rico and for island areas of the United States are included in many state tables and are supplemented by information in Section 29. Additional information for states, cities, counties, metropolitan areas, and other small units, as well as more historical data are available in various supplements to the Abstract. Statistics in this edition are generally for the most recent year or period available by summer 2006. Each year over 1,400 tables and charts are reviewed and evaluated; new tables and charts of current interest are added, continuing series are updated, and less timely data are condensed or eliminated. Text notes and appendices are revised as appropriate. This year we have introduced 72 new tables covering a wide range of subject areas. These cover a variety of topics including: learning disability for children, people impacted by the hurricanes in the Gulf Coast area, employees with alternative work arrangements, adult computer and Internet users by selected characteristics, North America cruise industry, women- and minority-owned businesses, and the percentage of the adult population considered to be obese. Some of the annually surveyed topics are population; vital statistics; health and nutrition; education; law enforcement, courts and prison; geography and environment; elections; state and local government; federal government finances and employment; national defense and veterans affairs; social insurance and human services; labor force, employment, and earnings; income, expenditures, and wealth; prices; business enterprise; science and technology; agriculture; natural resources; energy; construction and housing; manufactures; domestic trade and services; transportation; information and communication; banking, finance, and insurance; arts, entertainment, and recreation; accommodation, food services, and other services; foreign commerce and aid; outlying areas; and comparative international statistics." Note to Users: This CD is part of a collection located in the Data Archive of the Odum Institute for Research in Social Science, at the University of North Carolina at Chapel Hill. The collection is located in Room 10, Manning Hall. Users may check the CDs out subscribing to the honor system. Items can be checked out for a period of two weeks. Loan forms are located adjacent to the collection.

Days-of-Sales-Outstanding Time Series for Excel Force MSC Bhd. Excel Force MSC Berhad, together with its subsidiaries, develops, provides, and maintains software application solutions for the financial services industry in Malaysia. The company operates through Application Solutions, Maintenance Services, Application Services Provider, and Other segments. Its product portfolio includes CyberStock BTX, a bridging trader and exchange system platform that provides trading tools classes; and CyberStock ECOS, a stock broking solution which offers real time market information, place trades, and manage orders solution. In addition, the company provides CyberStock Mobile Trader, a mobile trading system that connects users smartphones to exchanges to manage trading activities; and CyberStock EDS, an exempt dealer system that provides advanced trading infrastructure and facilities for commercial banks. Further, it offers CyberStock SMF, a share margin financing system that enables financial institutions, brokerage firms, and banks to operate and manage margin financing services; and CyberStock CNS, a custodian and nominee system, which provides value-added services, such as trade settlement, cash balances investment, income collection, corporate actions processing, recordkeeping and reporting to custodian banks for domestic services. Additionally, the company provides CyberStock BOS, a back office system to manage enormous file and data; and offers network and security services. Excel Force MSC Berhad was founded in 1994 and is based in Petaling Jaya, Malaysia.

This interactive sales dashboard is designed in Excel for B2C type of Businesses like Dmart, Walmart, Amazon, Shops & Supermarkets, etc. using Slicers, Pivot Tables & Pivot Chart.

Dashboard Overview

1. Sales dashboard ==> basically, it is designed for the B2C type of business. like Dmart, Walmart, Amazon, Shops & supermarkets, etc.
2. Slices ==> slices are used to drill down the data, on the basis of yearly, monthly, by sales type, and by mode of payment.
3. Total Sales/Total Profits ==> here is, the total sales, total profit, and profit percentage these all are combined into a monthly format and we can hide or unhide it to view it as individually or comparative.
4. Product Visual ==> the visual indicates product-wise sales for the selected period. Only 10 products are visualized at a glance, and you can scroll up & down to view other products in the list.
5. Daily Sales ==> It shows day-wise sales. (Area Chart)
6. Sales Type/Payment Mode ==> It shows sales percentage contribution based on the type of selling and mode of payment.
7. Top Product & Category ==> this is for the top-selling product and product category.
8. Category ==> the final one is the category-wise sales contribution.

Datasheets Overview

1. The dataset has the master data sheet or you can call it a catalog. It is added in the table form.
2. The first column is the product ID the list of items in this column is unique.
3. Then we have the product column instead of these two columns, we can manage with only one also but I kept it separate because sometimes product names can be the same, but some parameters will be different, like price, supplier, etc.
4. The next column is the category column, which is the product category. like cosmetics, foods, drinks, electronics, etc.
5. Then we have 4th column which is the unit of measure (UOM) you can update it also, based on the products you have.
6. And the last two columns are buying price and selling price, which means unit purchasing price and unit selling price.

Input Sheet

The first column is the date of Selling. The second column is the product ID. The third column is quantity. The fourth column is sales types, like direct selling, are purchased by a wholesaler or ordered online. The fifth column is a mode of payment, which is online or in cash. You can update these two as per requirements. The last one is a discount percentage. if you want to offer any discount, you can add it here.

Analysis Sheet: where all backend calculations are performed.

So, basically these are the four sheets mentioned above with different tasks.

However, a sales dashboard enables organizations to visualize their real-time sales data and boost productivity.

A dashboard is a very useful tool that brings together all the data in the forms of charts, graphs, statistics and many more visualizations which lead to data-driven and decision making.

Questions & Answers

1. What percentage of profit ratio of sales are displayed in the year 2021 and year 2022? ==> Total profit ratio of sales in the year 2021 is 19% with large sales of PRODUCT42, whereas profit ratio of sales for 2022 is 22% with large sales of PRODUCT30.
2. Which is the top product that have large number of sales in year 2021-2022? ==> The top product in the year 2021 is PRODUCT42 with the total sales of $12,798 whereas in the year 2022 the top product is PRODUCT30 with the total sales of $13,888.
3. In Area Chart which product is highly sold on 28th April 2022? ==> The large number of sales on 28th April 2022 is for PRODUCT14 with a 24% of profit ratio.
4. What is the sales type and payment mode present? ==> The sale type and payment modes show the sales percentage contribution based on the type of selling and mode of payment. Here, the sale types are Direct Sales with 52%, Online Sales with 33% and Wholesaler with 15%. Also, the payment modes are Online mode and Cash equally distributed with 50%.
5. In which month the direct sales are highest in the year 2022? ==> The highest direct sales can be easily identified which is designed by monthly format and it’s the November month where direct sales are highest with 28% as compared with other months.
6. Which payment mode is highly received in the year 2021 and year 2022? ==> The payments received in the year 2021 are the cash payments with 52% as compared with online transactions which are 48%. Also, the cash payment highly received is in the month of March, July and October with direct sales of 42%, Online with 45% and wholesaler with 13% with large sales of PRODUCT24. ==> The payments received in the year 2022 are the Online payments with 52% as compared with cash payments which are 48%. Also, the online payment highly received is in the month of Jan, Sept and December with direct sales of 45%, Online with 37% and whole...

Project Priority Matrix (Dynamic Excel Tool)

Overview

This dataset provides a dynamic Excel model for prioritizing projects based on Feasibility, Impact, and Size.
It visualizes project data on a Bubble Chart that updates automatically when new projects are added.

Use this tool to make data-driven prioritization decisions by identifying which projects are most feasible and high-impact.

Goal

Organizations often struggle to compare multiple initiatives objectively.
This matrix helps teams quickly determine which projects to pursue first by visualizing:

• Feasibility → How achievable a project is
• Impact → The potential benefit or value it delivers
• Size → The level of effort or resources required

How It Works

1. Each project is rated on a 1–10 scale for:
   • Feasibility
   • Impact
   • Size
2. The Excel file uses a Bubble Chart:
   • X-axis: Feasibility
   • Y-axis: Impact
   • Bubble size: Project Size
3. The chart automatically updates when new projects or scores are added.

Example (partial data):

Interpretation Guide

Excel Features

• Dynamic Bubble Chart (updates with new data)
• Named Ranges for auto-expanding data
• Optional Conditional Formatting
• Data Validation for consistent scoring

How to Use

1. Download and open Project_Priority_Matrix.xlsx.
2. Go to the Data sheet.
3. Add your project names and scores (1–10).
4. Watch the chart update instantly to reflect your data.

You can use this for: - Portfolio management
- Product or feature prioritization
- Strategy planning workshops

File Information

• File: Project_Priority_Matrix.xlsx
• Format: Excel (.xlsx)
• Version: 1.0
• Last Updated: October 2025

License

Free for personal and organizational use.
Attribution is appreciated if you share or adapt this file.

Author: [Asjad]
Contact: [m.asjad2000@gmail.com]
Compatible With: Microsoft Excel 2019+ / Office 365

Net-Income-From-Continuing-Operations Time Series for Excel Force MSC Bhd. Excel Force MSC Berhad, together with its subsidiaries, develops, provides, and maintains software application solutions for the financial services industry in Malaysia. The company operates through Application Solutions, Maintenance Services, Application Services Provider, and Other segments. Its product portfolio includes CyberStock BTX, a bridging trader and exchange system platform that provides trading tools classes; and CyberStock ECOS, a stock broking solution which offers real time market information, place trades, and manage orders solution. In addition, the company provides CyberStock Mobile Trader, a mobile trading system that connects users smartphones to exchanges to manage trading activities; and CyberStock EDS, an exempt dealer system that provides advanced trading infrastructure and facilities for commercial banks. Further, it offers CyberStock SMF, a share margin financing system that enables financial institutions, brokerage firms, and banks to operate and manage margin financing services; and CyberStock CNS, a custodian and nominee system, which provides value-added services, such as trade settlement, cash balances investment, income collection, corporate actions processing, recordkeeping and reporting to custodian banks for domestic services. Additionally, the company provides CyberStock BOS, a back office system to manage enormous file and data; and offers network and security services. Excel Force MSC Berhad was founded in 1994 and is based in Petaling Jaya, Malaysia.

Number-of-Days-of-Payables Time Series for Excel Force MSC Bhd. Excel Force MSC Berhad, together with its subsidiaries, develops, provides, and maintains software application solutions for the financial services industry in Malaysia. The company operates through Application Solutions, Maintenance Services, Application Services Provider, and Other segments. Its product portfolio includes CyberStock BTX, a bridging trader and exchange system platform that provides trading tools classes; and CyberStock ECOS, a stock broking solution which offers real time market information, place trades, and manage orders solution. In addition, the company provides CyberStock Mobile Trader, a mobile trading system that connects users smartphones to exchanges to manage trading activities; and CyberStock EDS, an exempt dealer system that provides advanced trading infrastructure and facilities for commercial banks. Further, it offers CyberStock SMF, a share margin financing system that enables financial institutions, brokerage firms, and banks to operate and manage margin financing services; and CyberStock CNS, a custodian and nominee system, which provides value-added services, such as trade settlement, cash balances investment, income collection, corporate actions processing, recordkeeping and reporting to custodian banks for domestic services. Additionally, the company provides CyberStock BOS, a back office system to manage enormous file and data; and offers network and security services. Excel Force MSC Berhad was founded in 1994 and is based in Petaling Jaya, Malaysia.

📊 Bank Transaction Analytics Dashboard – SQL + Excel

🔹 Overview

This project focuses on Bank Transaction Analysis using a combination of SQL scripts and Excel dashboards. The goal is to provide insights into customer spending patterns, payment modes, suspicious transactions, and overall financial trends.

The dataset and analysis files can help learners and professionals understand how SQL and Excel can be used together for business decision-making, customer behavior tracking, and data-driven insights.

🔹 Contents

The dataset includes the following resources:

📂 SQL Scripts:

Create & Insert tables

15 Basic Queries

15 Advanced Queries

📂 CSV File:

Bank Transaction Analytics.csv (main dataset)

📂 Excel Charts:

Pie, Bar, Column, Line, Doughnut charts

Final Interactive Dashboard

📂 Screenshots:

Query outputs, Charts, and Final Dashboard visualization

📂 PDF Reports:

Project Report

Dashboard Report

📄 README.md:

Complete documentation and step-by-step explanation

🔹 Key Insights

26–35 age group spent the most across categories.

Amazon identified as the top merchant.

NetBanking showed the highest share compared to POS/UPI.

Travel & Shopping emerged as dominant categories.

🔹 Applications

Detecting suspicious transactions.

Understanding customer behavior.

Identifying top merchants and categories.

Building business intelligence dashboards.

🔹 How to Use

Download the dataset and SQL scripts.

Run Bank_Transaction_Analytics.SQL to create and insert data.

Execute the queries (Basic + Advanced) for insights.

Open Excel files to explore interactive charts and dashboards.

Refer to Project Report PDF for documentation.

🔹 Author

👩‍💻 Created by: Prachi Singh

GitHub: Bank Transaction Analytics Dashboard(https://github.com/prachi-singh-ds/Bank-Transaction-Analytics-Dashboard)

⚡This project is a complete SQL + Excel integration case study and is suitable for Data Science, Business Analytics, and Data Engineering portfolios.

Site includes data and information on remaining oil and gas reserves in the U.S., includes downloadable graphs, PDFs, and Excel charts.

Summary: In 2011, oil and gas exploration and production companies operating in the United States added almost 3.8 billion barrels of crude oil and lease condensate proved reserves, an increase of 15 percent, and the greatest volume increase since the U.S. Energy Information Administration (EIA) began publishing proved reserves estimates in 1977 (Table 1). Proved reserves of crude oil and lease condensate increased by 2.9 billion barrels in 2010, the previous record. Proved reserves of U.S. wet natural gas1 rose by 31.2 trillion cubic feet in 2011 to a new record high of 348.8 trillion cubic feet. Though this increase was lower than the 33.8 trillion cubic feet (Tcf) added in 2010, it was only the second year since 1977 that natural gas net reserves additions surpassed 30 Tcf.

To create the dataset, the top 10 countries leading in the incidence of COVID-19 in the world were selected as of October 22, 2020 (on the eve of the second full of pandemics), which are presented in the Global 500 ranking for 2020: USA, India, Brazil, Russia, Spain, France and Mexico. For each of these countries, no more than 10 of the largest transnational corporations included in the Global 500 rating for 2020 and 2019 were selected separately. The arithmetic averages were calculated and the change (increase) in indicators such as profitability and profitability of enterprises, their ranking position (competitiveness), asset value and number of employees. The arithmetic mean values of these indicators for all countries of the sample were found, characterizing the situation in international entrepreneurship as a whole in the context of the COVID-19 crisis in 2020 on the eve of the second wave of the pandemic. The data is collected in a general Microsoft Excel table. Dataset is a unique database that combines COVID-19 statistics and entrepreneurship statistics. The dataset is flexible data that can be supplemented with data from other countries and newer statistics on the COVID-19 pandemic. Due to the fact that the data in the dataset are not ready-made numbers, but formulas, when adding and / or changing the values in the original table at the beginning of the dataset, most of the subsequent tables will be automatically recalculated and the graphs will be updated. This allows the dataset to be used not just as an array of data, but as an analytical tool for automating scientific research on the impact of the COVID-19 pandemic and crisis on international entrepreneurship. The dataset includes not only tabular data, but also charts that provide data visualization. The dataset contains not only actual, but also forecast data on morbidity and mortality from COVID-19 for the period of the second wave of the pandemic in 2020. The forecasts are presented in the form of a normal distribution of predicted values and the probability of their occurrence in practice. This allows for a broad scenario analysis of the impact of the COVID-19 pandemic and crisis on international entrepreneurship, substituting various predicted morbidity and mortality rates in risk assessment tables and obtaining automatically calculated consequences (changes) on the characteristics of international entrepreneurship. It is also possible to substitute the actual values identified in the process and following the results of the second wave of the pandemic to check the reliability of pre-made forecasts and conduct a plan-fact analysis. The dataset contains not only the numerical values of the initial and predicted values of the set of studied indicators, but also their qualitative interpretation, reflecting the presence and level of risks of a pandemic and COVID-19 crisis for international entrepreneurship.

Geological events chart in excel, includes columns to input information on the plate tectonic setting, regional tectonic setting, depositional environment and lithostratigraphy. This list is not exhaustive and should be used to build on, adding your own (e.g. local datasets, petroleum systems, data by basin or quad).Age (Ma) based on the International Chronostratigraphic Chart v2018/08 by the International Commission on Stratigraphy. Use this spreadsheet as a basis for collating and cataloging information when starting a new project or when working in a new area. Allows tectonostratigraphic data to be laid out chronologically along the geological timescale.

Civil and geological engineers have used field variable-head permeability tests (VH tests or slug tests) for over one century to assess the local hydraulic conductivity of tested soils and rocks. The water level in the pipe or riser casing reaches, after some rest time, a static position or elevation, z2. Then, the water level position is changed rapidly, by adding or removing some water volume, or by inserting or removing a solid slug. Afterward, the water level position or elevation z1(t) is recorded vs. time t, yielding a difference in hydraulic head or water column defined as Z(t) = z1(t) - z2. The water level at rest is assumed to be the piezometric level or PL for the tested zone, before drilling a hole and installing test equipment. All equations use Z(t) or Z*(t) = Z(t) / Z(t=0). The water-level response vs. time may be a slow return to equilibrium (overdamped test), or an oscillation back to equilibrium (underdamped test). This document deals exclusively with overdamped tests. Their data may be analyzed using several methods, known to yield different results for the hydraulic conductivity. The methods fit in three groups: group 1 neglects the influence of the solid matrix strain, group 2 is for tests in aquitards with delayed strain caused by consolidation, and group 3 takes into account some elastic and instant solid matrix strain. This document briefly explains what is wrong with certain theories and why. It shows three ways to plot the data, which are the three diagnostic graphs. According to experience with thousands of tests, most test data are biased by an incorrect estimate z2 of the piezometric level at rest. The derivative or velocity plot does not depend upon this assumed piezometric level, but can verify its correctness. The document presents experimental results and explains the three-diagnostic graphs approach, which unifies the theories and, most important, yields a user-independent result. Two free spreadsheet files are provided. The spreadsheet "Lefranc-Test-English-Model" follows the Canadian standards and is used to explain how to treat correctly the test data to reach a user-independent result. The user does not modify this model spreadsheet but can make as many copies as needed, with different names. The user can treat any other data set in a copy, and can also modify any copy if needed. The second Excel spreadsheet contains several sets of data that can be used to practice with the copies of the model spreadsheet. En génie civil et géologique, on a utilisé depuis plus d'un siècle les essais in situ de perméabilité à niveau variable (essais VH ou slug tests), afin d'évaluer la conductivité hydraulique locale des sols et rocs testés. Le niveau d'eau dans le tuyau ou le tubage prend, après une période de repos, une position ou élévation statique, z2. Ensuite, on modifie rapidement la position du niveau d'eau, en ajoutant ou en enlevant rapi-dement un volume d'eau, ou en insérant ou retirant un objet solide. La position ou l'élévation du niveau d'eau, z1(t), est alors notée en fonction du temps, t, ce qui donne une différence de charge hydraulique définie par Z(t) = z1(t) - z2. Le niveau d'eau au repos est supposé être le niveau piézométrique pour la zone testée, avant de forer un trou et d'installer l'équipement pour un essai. Toutes les équations utilisent Z(t) ou Z*(t) = Z(t) / Z(t=0). La réponse du niveau d'eau avec le temps peut être soit un lent retour à l'équilibre (cas suramorti) soit une oscillation amortie retournant à l'équilibre (cas sous-amorti). Ce document ne traite que des cas suramortis. Leurs données peuvent être analysées à l'aide de plusieurs méthodes, connues pour donner des résultats différents pour la conductivité hydraulique. Les méthodes appartiennent à trois groupes : le groupe 1 néglige l'influence de la déformation de la matrice solide, le groupe 2 est pour les essais dans des aquitards avec une déformation différée causée par la consolidation, et le groupe 3 prend en compte une certaine déformation élastique et instantanée de la matrice solide. Ce document explique brièvement ce qui est incorrect dans les théories et pourquoi. Il montre trois façons de tracer les données, qui sont les trois graphiques de diagnostic. Selon l'expérience de milliers d'essais, la plupart des données sont biaisées par un estimé incorrect de z2, le niveau piézométrique supposé. Le graphe de la dérivée ou graphe des vitesses ne dépend pas de la valeur supposée pour le niveau piézomé-trique, mais peut vérifier son exactitude. Le document présente des résultats expérimentaux et explique le diagnostic à trois graphiques, qui unifie les théories et donne un résultat indépendant de l'utilisateur, ce qui est important. Deux fichiers Excel gratuits sont fournis. Le fichier"Lefranc-Test-English-Model" suit les normes canadiennes : il sert à expliquer comment traiter correctement les données d'essai pour avoir un résultat indépendant de l'utilisateur. Celui-ci ne modifie pas ce...

Total-Asset-Turnover Time Series for Excel Force MSC Bhd. Excel Force MSC Berhad, together with its subsidiaries, develops, provides, and maintains software application solutions for the financial services industry in Malaysia. The company operates through Application Solutions, Maintenance Services, Application Services Provider, and Other segments. Its product portfolio includes CyberStock BTX, a bridging trader and exchange system platform that provides trading tools classes; and CyberStock ECOS, a stock broking solution which offers real time market information, place trades, and manage orders solution. In addition, the company provides CyberStock Mobile Trader, a mobile trading system that connects users smartphones to exchanges to manage trading activities; and CyberStock EDS, an exempt dealer system that provides advanced trading infrastructure and facilities for commercial banks. Further, it offers CyberStock SMF, a share margin financing system that enables financial institutions, brokerage firms, and banks to operate and manage margin financing services; and CyberStock CNS, a custodian and nominee system, which provides value-added services, such as trade settlement, cash balances investment, income collection, corporate actions processing, recordkeeping and reporting to custodian banks for domestic services. Additionally, the company provides CyberStock BOS, a back office system to manage enormous file and data; and offers network and security services. Excel Force MSC Berhad was founded in 1994 and is based in Petaling Jaya, Malaysia.