Friday, January 3, 2014

Download excel games

Download frog leap game
https://drive.google.com/file/d/0B4jM6Io8KxDUWlQ3d0xsR0ZaUGM/edit?usp=sharing

Download golf game
https://drive.google.com/file/d/0B4jM6Io8KxDUMzZlRURPQkZxN00/edit?usp=sharing

Download bang bang game
https://drive.google.com/file/d/0B4jM6Io8KxDUbnZlRm42WDBuQ0E/edit?usp=sharing

Labeling Machine

Markets today are filled with products. One can view or easily get the product info from the packaging itself. Today’s world is all about competition and to survive in the competition companies are investing huge on ads and giving Product information. This information can be easily read on the Product itself.
What is Labeling Machine?
Labeling Machines are used to apply labels on the Products. These labels give general information about the Product. For egg. One gets the Nutritional of the food items from the labels. All the brands in the market today are labeled. These labels give the price information, product information and uniqueness of the product.
Shopping for a Labeling Machine
There are different types of labeling Machine available in the market. While shopping one needs to keep few constraints in mind such as
  • Prepare the detail such as products to be labelled, dimensions of the products, size of labels, type of labels or labelling and finally select the speed or output required for labelling
  • The first and most important step in purchase of labelling equipment is to gather samples and specifications for the products and labels to purchase. 
  • Short list labelling machinery information that fits the needs. 
  • Verify technical information of machine as per requirements.
  • Check for major clientele and review of satisfied customer.  

How a labeling Machine can help your business?
Labelling machines are used in wide range of industries such as Pharmaceuticals, Cosmetics, Chemical, Food, Beverage, Pesticides, Gifts, Agriculture, Electronics and many more. Some companies use Labelling machines that are small, handheld, and easily portable to apply labels on different products.


Labelling machines also comes with special design to accommodate requirement of small scale companies where they do not have higher production requirement but similarly they have to do labelling on multiple product and packages where automatic labelling machine is not feasibleMarkets today are filled with products. One can view or easily get the product info from the packaging itself. Today’s world is all about competition and to survive in the competition companies are investing huge on ads and giving Product information. This information can be easily read on the Product itself.
What is Labeling Machine?
Labeling Machines are used to apply labels on the Products. These labels give general information about the Product. For egg. One gets the Nutritional of the food items from the labels. All the brands in the market today are labeled. These labels give the price information, product information and uniqueness of the product.
Shopping for a Labeling Machine
There are different types of labeling Machine available in the market. While shopping one needs to keep few constraints in mind such as
  • Prepare the detail such as products to be labelled, dimensions of the products, size of labels, type of labels or labelling and finally select the speed or output required for labelling
  • The first and most important step in purchase of labelling equipment is to gather samples and specifications for the products and labels to purchase. 
  • Short list labelling machinery information that fits the needs. 
  • Verify technical information of machine as per requirements.
  • Check for major clientele and review of satisfied customer.  

How a labeling Machine can help your business?
Labelling machines are used in wide range of industries such as Pharmaceuticals, Cosmetics, Chemical, Food, Beverage, Pesticides, Gifts, Agriculture, Electronics and many more. Some companies use Labelling machines that are small, handheld, and easily portable to apply labels on different products.

Labelling machines also comes with special design to accommodate requirement of small scale companies where they do not have higher production requirement but similarly they have to do labelling on multiple product and packages where automatic labelling machine is not feasible

Thursday, January 2, 2014

Excel Fun

EXCEL : Select all cells that contain comments
CTRL + SHIFT + O
Try it out.
--------------------------------------------------------------------------------------
EXCEL: Download and Play Fun Games on Excel
https://docs.google.com/file/d/0B4jM6Io8KxDUUXZ6MkFUYlhVMUE/edit
--------------------------------------------------------------------------------------
WORD : Shortcut to insert comment
Alt + Ctrl + M 
Try it out.
--------------------------------------------------------------------------------------
EXCEL : Use 'Wrap Text' to accommodate sentences / long words in one cell.
Text in cell longer than the width of the column? And constraints on column width?
Use Alt + H + W.
Try it out.
--------------------------------------------------------------------------------------
EXCEL : Shortcut to add FILTER on the table head
Ctrl + Shift + L
Try it out.
--------------------------------------------------------------------------------------
Select some text in Word and press Shift+F3 to quickly change the case of the selection. It toggles between UPPERCASE, lowercase and Camel Case (first letter in capital) and should come handy if you’ve accidentally left the CAPS LOCK key on while typing.
--------------------------------------------------------------------------------------
Most people use the Cut-Paste (Ctrl-x Ctrl-v) route to move text from one location to another within a Word document but there’s an alternate way as well. Highlight any block of text, press F2 and then place the cursor at the spot where you wish to move that text. Press Enter and the selection will be moved.
--------------------------------------------------------------------------------------
There’s a Lorem Ipsum generator built inside Word to help you insert filler text anywhere inside the document. Type =rand(p,l) and press Enter to insert ‘p’ number of paragraphs each having ‘l’ lines. For instance, =rand(3,6) will generate 3 dummy paragraphs  with 6 lines each.

VMware

VMware Server provides the VMware Management Interface, a web based management tool that allows you to:
·         Control (Power On, Suspend, Resume, Reset and Power off) the virtual machines on the hosting
·         Connect the VMware Server Console to a given virtual machine, for hands on management
·         View details about each virtual machine, including system summary, hardware information, any connected users and a log of recent events.
·         Secure console and management interface sessions with SSL (Administrator and root users only)
VMware virtual machine console (windows and Linux)
Components for windows
·         Windows VMware server console (.exe)
·         Com scripting API for windows (.exe)
·         Perl scripting API for windows (.exe)
·         Programming API (.exe)
Linux Client Component
·         Linux VMware server console (.tar and .rpm)
·         Perl scripting API for Linux (.tar)
·         Programming API (.tar)


Connecting remotely to Virtual Machines

Configuration a Virtual Machine for Access by a VNC Client only the 8-character password is encrypted with the standard VNC client. All VNC client traffic is sent unencrypted across the network. If security is a concern in your organization, VMware recommends using the VMware Virtual

You cannot take or revert to snapshots.

You cannot change the power state of the virtual machine; that is, you cannot power on, power off, suspend or resume. You can shut down the guest operating system, which may or may not power off the virtual machine (some operating system do not power off their system when shut down).

You cannot copy and paste text between the host and guest operating system.

You must install VMware tools in the virtual machine before you connect with the VNC client. Otherwise, the mouse cannot work. (VNC clients do not support relative mice; VMware tools contain absolute mouse drivers).


You cannot configure the virtual machine with the virtual machine settings editor, nor can you upgrade VMware Tools.

SaaS

Software as a Service (SaaS) is defined as a software distribution model in which applications are hosted by a vendor or service provider and made available to customers over a network. It offers high flexibility, proven support services, enhanced scalability, reduced customer maintenance, and reduced cost.
The NIST’s report includes a comprehensive list of security and privacy concerns that apply tocloud computing. Strategic Planning are the important aspects of cloud computing.
Strategic Planning can be done by following 5 steps given below
·         Begin with Big picture Plan
·         Always do a risk assessment
·         Set measurable goals for team and keep plans grounded
·         Recognize that there is no correct timeframe
·         Stay flexible
SaaS Providers
There are various Saas Providers available in the market
 Net Suite- Net suite’s Suite Cloud Platform is a comprehensive offering of on-demandproducts and development tools. It is a leading provider of Web-basedbusiness software suites for CRM, ERP tools, accounting and e-commerce.
Intuit - Founded in 1983, Intuit makes the well-known QuickBooks software. Itsannual revenue exceeds $3 billion. The Intuit Partner Platform allows customers to Rapidly  build  and  deploy  rich  Software  as  a  Service  (SaaS)  apps
Intact is a leading provider of cloud financial management and accountingapplications for companies of all sizes. It supports distributed and global business, making it easy andquick to consolidate financials from multiple businesses. Intact runs on the Oracle DBMS and uses SunGard as a part of its disaster recovery programs.
FinancialForce.comdeveloped on Force.com delivers comprehensive accounting and is reintegrated with Salesforce.com’s CRM.
Coupa Software is an extension of existing enterpriseplanning systems. Coupa tries to make procurement easier for employee’s ofall stripes within an enterprise
AT&T - Enables independent software vendors (ISVs) tolaunch a software-as-a-service (SaaS) business. AT&T now allows ISVs totap into AT&T’s infrastructure, methodologies, expertise, and reputation toavoid newcomers’ missteps and immediately seize a competitive advantage.

Making an application available over the Internet implies a commitment to providing web-scale, which in turn is an implicit commitment to cloud.

Private Cloud

Private cloud provides hosted services to a limited number of people behind a firewall. Advances in virtualization and distributed computing have allowed corporate network and datacenter administrators to effectively become service providers that meet the needs of their "customers" within the corporation."Customers will see that we can now better support an environment that’s up and running 24 hours a day, seven days a week. With System Center, we can scale … up and down faster and get more projects into the cloud."

What Is a Private Cloud?

Private cloud and internal cloud products claim to "deliver some benefits of cloud computing without the pitfalls", capitalizing on Data Security Policies, corporate governance, and reliability concerns. Private cloud is the implementation of cloud services on resources that are dedicated to your organization, whether they exist on-premises or off-premises. With a private cloud, you get many of the benefits of public cloud computing including self-service, scalability, and elasticity with the additional control and customization available from dedicated resources.
There are two models for cloud services that can be delivered in a private cloud: Infrastructure as a Service (IaaS) and Platform as a Service (PaaS). With IaaS, you can use infrastructure resources (compute, network, and storage) as a service, while PaaS provides a complete application platform as a service. Microsoft offers solutions that deliver IaaS and PaaS for both private and public cloud deployments.

Private Cloud Overview and Advantages

The main thing that sets a private cloud apart from a commercially-used public cloud is where the hardware is kept and how it’s maintained. A private cloud is typically hosted on the company’s own virtual servers, within their own network infrastructure.
The main advantage one has with a privately-managed cloud is direct control over every aspect of the cloud’s implementation: the hardware, the networking, the operating system and other software used to create the cloud itself; the way cloud security is implemented; even the APIs used (that is, if you’re using an open source system).
Another advantage of a private cloud is that it can generally be built from reasonably current commodity hardware. The most stringent requirements, apart from disk space and memory, are processors that support virtualization.
A third advantage is locality. A cloud hosted in your own datacenter, or on your own property, is far easier to move data into (and out of) than a cloud hosting elsewhere.
A fourth advantage iscloud security. If you are hosting your own cloud infrastructure on a private LAN, with no connections to the outside world, it’s theoretically a good deal easier to secure. Since it’s your network and your boxes, you can exercise that much more discretion over it.

Private Cloud Disadvantages

One major disadvantage of a private cloudis the work involved in creating and maintaining the cloud. The whole point of using someone else’s cloud infrastructure is to save you the trouble of having to build it. It becomes all the more difficult if you want to securely access the cloud from outside your corporate LAN
It’s doubly hard if you have no experience setting up such things, and need to figure it out as you go.

Virtual private cloud

A Virtual Private Cloud (VPC) is a private cloud existing within a shared or public cloud. It is a portion of a public cloud infrastructure that has been set aside for use by an organization, and is only accessible via an IPsec virtual private network connection.
Amazon Web Services launched Amazon Virtual Private Cloud which allows the Amazon Elastic Compute Cloud service to be connected to legacy infrastructure over an IPSec virtual connection. Google supports similar functionality via their Secure Data Connector.

Private Cloud Technology Examples

Eucalyptus

A major vendor of technology for creating private clouds is Eucalyptus. Eucalyptus interfaces directly with Amazon EC2, and in fact uses the same interface as EC2. Advantage of Eucalyptus is how the interface module can be swapped with something else. But for now, EC2 is the default choice due to its wide adoption.


Elestra
Another private-cloud company is Elestra, whose Enterprise Cloud Server was designed to make it easier to package and deploy application stacks into the cloud. Elestra provides packaging support for Oracle’s database and Web Logic app servers, among many others.

VMware

Own private-cloud architecture is built on top of VMware vSphere, and they also offer an “infrastructure-as-a-service” version via vCloud Express.

Microsoft


Microsoft came late to virtualization and have likewise come late to cloud computing, but are preparing their own private cloud offerings (“Azure”) for later this year. As you might expect, it’ll be built on top of Windows Server / Hyper-V, and will be managed with the forthcoming Dynamic Infrastructure Toolkit for System Center.

Excel Fun

EXCEL: Play the evergreen PACMAN on Excel. Download now !

http://www.systemfunda.com/forum/viewforum.php?f=5
-------------------------------------------------------------------
EXCEL : Keyboard shortcut to open Microsoft Visual Basic Editor 

ALT + F11 opens the Microsoft Visual Basic Editor, to create macro by using VBA (Visual Basic for Applications)

Try it out.
-------------------------------------------------------------------
EXCEL : Calculate the time difference between two times

=TEXT(C4-B4,"H") Hours between two times.

=TEXT(C5-B5,"HH:MM") Hours and minutes between two times. 

=TEXT(C6-B6,"HH:MM:SS") Hours, minutes, and seconds between two times.
-------------------------------------------------------------------
EXCEL : Use 'Wrap Text' to accommodate sentences / long words in one cell.

Text in cell longer than the width of the column? And constraints on column width?

Use Alt + H + W.

Try it out.
-------------------------------------------------------------------
WORD : Shortcut for Subscript and Superscript

Subscript - Ctrl + =

Superscript - Ctrl + Shift + =

Try it out.

Necessity of Business Communication

In today's competitive era, it is very important, for all business men and people who are entering into corporate world to have a sufficient skills to communicate with their clients, buyers, mediators, trading agencies & companies.

Currently there is a huge trend of electronic communication. We are here to help & guide to all those people who need some assistance for drafting of e-mails and support to how to communicate with corporates.

Drafting of e-mails should be very concise and meaningful so that the person with whom an individual wants to communicate can understand your message at first sight.

The Business at international level must require electronic communication because of various factors like : time difference, language difference, cultural differences and many more hence it is necessary for all the businessmen to have prominent communication with their clients.

Also, if our clients are having some issues regarding the product & services, so the most important thing is to support the clients with a very soft language which is possible only through good communication structure.

So we are here to support to all those who wants our help. If we can fulfill your requirement so please contact us at tejal2109@gmail.com

Wednesday, January 1, 2014

Excel tips

EXCEL : To know where a cell is getting its value from (reference)
(a) CTRL + [ : Select all cells directly referenced by formulas in the selection. 
(b) F5 : Goto - To go back to the cell where Ctrl + [ was pressed
Very useful when dealing with huge amount of data, especially referenced in multiple worksheets.
Try it out.
Business Analysts

Virtualization

A Virtual Machine
Most computers only have one operating system installed.Virtualization software allows a computer to run several operating systems at the same time. Virtualization refers to running multiple operating systems on a single machine. For example, a Windows computer with VMware Workstation installed can run Linux within the Windows interface. When another operating system (OS) is running on top of the main system, it is called a "virtual machine." A data center might become overcrowded with racks of servers consuming a lot of power and generating heat.The most important part of deployment is planning security policies. It is not possible to plan for security, however, until a full risk assessment has been performed. Security planning involves developing security policies, Disaster Recovery Programs and implementing controls to prevent computer risks from becoming reality.

Virtualization – An independent Machine

Virtualization, in computing, is the creation of a virtual version such as a hardware platform, operating system, a storage device or network resources
Why Use Server Virtualization
There are many reasons companies and organizations are investing in server virtualization. Some of the reasons are financially motivated, while others address technical concerns:
Server virtualization conserves space through consolidation. For companies that have hundreds or thousands of servers, the need for physical space can decrease significantly.
Server virtualization provides a way for companies to practice redundancy (running the same application on multiple servers) without purchasing additional hardware.
Virtual servers offer programmers isolated, independent systems in which they can test new applications or operating systems.

Three Kinds of Server Virtualization
There are three ways to create virtual servers: full virtualization, Para-virtualization and OS-level virtualization.
Full virtualization uses a hypervisor that interact directly with the physical server's CPU and disk space. The guest servers in a Para-virtualization system are aware of one another. The entire system works together as a cohesive unit. An OS-level virtualization approach is part of the host OS, which performs all the functions of a fully virtualized hypervisor.
Limitations of Server Virtualization
For servers dedicated to applications with high demands on processing power, virtualization isn't a good choice. That's because virtualization essentially divides the server's processing power up among the virtual servers.
It's also unwise to overload a server's CPU by creating too many virtual servers on one physical machine. Too many virtual servers could impact the server's ability to store data.
Another limitation is migration. Right now, it's only possible to migrate a virtual server from one physical machine to another if both physical machines use the same manufacturer's processor
Many companies are investing in server virtualization despite its limitations. As server virtualization technology advances, the need for huge data centers could decline

Data Migration

Abstract
Data  migration  is  one  of  the  key  operations  in many  enterprise data integration projects. Here software is purchased from one provider and has a direct relationship with the host. This makes migration to a new cloud provider easy, since one just needs to work with the software supplier to migrate to the new host and are not tied into one provider.
Data migration issue is not just about moving to another provider. Since some cloud providers have proprietary technology at times it may not support the solution that we want to stage before we put it live. That can create an interoperability problem. There are a lot of usage-based models at the moment, which doesn't suit everybody. There needs to be more variety and flexibility. Data security is also among cloud data migration challenges. Enterprises need to follow Security Policies to face such challenges.

Main Body
Article No. 4
Cloud computing is an emerging computing paradigm that was innovated to deploy cost effective solutions over Internet.  Companies  such  as  Google,  IBM,  Amazon, Yahoo and Intel have already started providing computing infrastructures  for  variety  of  data  processing  and  data storage  applications  on  a  pay-per-use  basis.
 System Description
The key components of this architecture include:
•    A distributed query processing engine
•    Business rules modeler
•    An automatic schema mapping and translation engine
•    A data migration engine

System Novelties
Some of the unique aspects of the proposed system are:
Auto Script generation for Mapping Data Elements to Cloud Entities
Microsoft Business connectors for interoperability between Commercial Databases.
On-Demand Bulk Data Transfer - The System can be hosted as an application on Microsoft Cloud Azure Platform and can be used to enable bulk data transfer on cloud.
Cloud Security is the major concern today hence detailed series of cloud security best strategic planning for partner evaluation, risk assessment and contractual negotiation are performed.
Disaster Recovery Programs -
Development of data backup routines that move the data out of the primary data center (and out of the control of the entity running that data center) and ensure that they are accessible in the event of a disaster. The   proposed   solution   facilitates   faster   migration service   and   quality   enrichment of the data, besides availing normal cloud benefits such as cost and elastic demand of resources.

Amazon EC2

Abstract
Amazon (EC2) designed to make web-scale computing easier for developers. Amazon EC2’s simple web service interface allows obtaining and configuring capacity Amazon EC2 provides developers the tools to build failure resilient applications and isolate themselves from common failure scenarios. One needs to pay only for what they use. There are no minimum fees. On-Demand Instances lets to pay for compute capacity by the hour hence one is free from the costs and complexities of planning, purchasing, and maintaining hardware. Amazon (EC2) is convenient to use and economical.

Main Body
EC2 allows scalable deployment of applications by providing a web service through which a user can boot an Amazon Machine Image to create a Virtual Server, which Amazon calls an "instance", containing any software desired.It offers features such as OS, Persistent Storage, Elastic IP Addresses, Amazon Cloud Watch and Automated Scaling. Amazon EC2allows users to create, launch, and terminate server instances as needed, paying by the hour for active servers.
Amazon EC2 Amazon announced the following features: a service level agreement for EC2, Microsoft Windows in beta form on EC2, Microsoft SQL Server in beta form on EC2, plans for an AWS management console, and plans for load balancing, auto scaling, and cloud monitoring services. These features were subsequently added on May 18, 2009.
Virtual Servers
EC2 uses Xen virtualization. Each Virtual Server, called an "instance", functions as a virtual private server. The system offers the following instance types:
Micro Instance
Small Instance – default
Large Instance
Extra Large Instance
Based on capacity of instances High-Memory Instances, High-CPU Instances and Cluster Compute Instances are also offered.
Amazon Virtual Private Cloud is a commercial cloud computing service that provides a virtual private cloud, allowing enterprise customers to access the Amazon Elastic Compute Cloud over an IPsec based virtual private network.
Amazon Cloud Security Policies
Amazon has laid down security policies for its clients so that hacking and other security concerns can be taken care of. Policies laid down are as follows
Check before connecting
Encrypt as much as possible
Open to only the trusted ones
Amazon Disaster Recovery Programs offers customers the ability to reserve large amounts of capacity for future use. The feature, known as Reserved Instances, is the latest in a series of steps by Amazon to make AWS more attractive to enterprise users

Email drafting


Support and good help to all Competitive Exams Aspirants and campus clearance

We are here to help you to clear competitive exams like Banking, MBA, MCA etc. which all includes a good score through Data analysis and Data interpretation section. Each competitive exam generally includes four section :

Data Interpretation & Data Analysis
Mathematics
English
Essay writing and passage analysis.

We will majorly focus on first two sections and for other two we will guide you to move ahead and achieve a great success with good score.

We are here to solve your queries regarding your academics, study material, preparation tools and the most important, time management.


Please contact me if your query matches to my answers. My contact ID is tejal2109@gmail.com 

We can solve any kind of statistical problem.

We are here to solve any kind of Statistical & Mathematical problems.

Statistical Problems : Which includes mean, median, mode, hypothetical analysis, statistical analysis of sales figures through various kinds of charts & figures. Statistical analysis may help an entrepreneur to take futuristic decision for growth of his firm.

Through this analysis we can help an individual to take out the new ideas and decision to survive in this competitive market.

Mathematical Problem : We are here to help all those students who needs mathematical support from our end. It will include all kind of problems regarding trigonometry, geometry, percentage calculation tricks and many more.

I will solve any type of statistical problem. You are requested to contact me if i can help you.

My contact ID is tejal2109@gmail.com