\documentclass[10pt,a4paper]{article}
% Packages
\usepackage{fancyhdr} % For header and footer
\usepackage{multicol} % Allows multicols in tables
\usepackage{tabularx} % Intelligent column widths
\usepackage{tabulary} % Used in header and footer
\usepackage{hhline} % Border under tables
\usepackage{graphicx} % For images
\usepackage{xcolor} % For hex colours
%\usepackage[utf8x]{inputenc} % For unicode character support
\usepackage[T1]{fontenc} % Without this we get weird character replacements
\usepackage{colortbl} % For coloured tables
\usepackage{setspace} % For line height
\usepackage{lastpage} % Needed for total page number
\usepackage{seqsplit} % Splits long words.
%\usepackage{opensans} % Can't make this work so far. Shame. Would be lovely.
\usepackage[normalem]{ulem} % For underlining links
% Most of the following are not required for the majority
% of cheat sheets but are needed for some symbol support.
\usepackage{amsmath} % Symbols
\usepackage{MnSymbol} % Symbols
\usepackage{wasysym} % Symbols
%\usepackage[english,german,french,spanish,italian]{babel} % Languages
% Document Info
\author{{[}deleted{]}}
\pdfinfo{
/Title (calculating-cooling-capacity.pdf)
/Creator (Cheatography)
/Author ({[}deleted{]})
/Subject (Calculating Cooling Capacity Cheat Sheet)
}
% Lengths and widths
\addtolength{\textwidth}{6cm}
\addtolength{\textheight}{-1cm}
\addtolength{\hoffset}{-3cm}
\addtolength{\voffset}{-2cm}
\setlength{\tabcolsep}{0.2cm} % Space between columns
\setlength{\headsep}{-12pt} % Reduce space between header and content
\setlength{\headheight}{85pt} % If less, LaTeX automatically increases it
\renewcommand{\footrulewidth}{0pt} % Remove footer line
\renewcommand{\headrulewidth}{0pt} % Remove header line
\renewcommand{\seqinsert}{\ifmmode\allowbreak\else\-\fi} % Hyphens in seqsplit
% This two commands together give roughly
% the right line height in the tables
\renewcommand{\arraystretch}{1.3}
\onehalfspacing
% Commands
\newcommand{\SetRowColor}[1]{\noalign{\gdef\RowColorName{#1}}\rowcolor{\RowColorName}} % Shortcut for row colour
\newcommand{\mymulticolumn}[3]{\multicolumn{#1}{>{\columncolor{\RowColorName}}#2}{#3}} % For coloured multi-cols
\newcolumntype{x}[1]{>{\raggedright}p{#1}} % New column types for ragged-right paragraph columns
\newcommand{\tn}{\tabularnewline} % Required as custom column type in use
% Font and Colours
\definecolor{HeadBackground}{HTML}{333333}
\definecolor{FootBackground}{HTML}{666666}
\definecolor{TextColor}{HTML}{333333}
\definecolor{DarkBackground}{HTML}{2107A3}
\definecolor{LightBackground}{HTML}{F1EFF9}
\renewcommand{\familydefault}{\sfdefault}
\color{TextColor}
% Header and Footer
\pagestyle{fancy}
\fancyhead{} % Set header to blank
\fancyfoot{} % Set footer to blank
\fancyhead[L]{
\noindent
\begin{multicols}{3}
\begin{tabulary}{5.8cm}{C}
\SetRowColor{DarkBackground}
\vspace{-7pt}
{\parbox{\dimexpr\textwidth-2\fboxsep\relax}{\noindent
\hspace*{-6pt}\includegraphics[width=5.8cm]{/web/www.cheatography.com/public/images/cheatography_logo.pdf}}
}
\end{tabulary}
\columnbreak
\begin{tabulary}{11cm}{L}
\vspace{-2pt}\large{\bf{\textcolor{DarkBackground}{\textrm{Calculating Cooling Capacity Cheat Sheet}}}} \\
\normalsize{by \textcolor{DarkBackground}{{[}deleted{]}} via \textcolor{DarkBackground}{\uline{cheatography.com/2754/cs/8566/}}}
\end{tabulary}
\end{multicols}}
\fancyfoot[L]{ \footnotesize
\noindent
\begin{multicols}{3}
\begin{tabulary}{5.8cm}{LL}
\SetRowColor{FootBackground}
\mymulticolumn{2}{p{5.377cm}}{\bf\textcolor{white}{Cheatographer}} \\
\vspace{-2pt}{[}deleted{]} \\
\uline{cheatography.com/deleted-2754} \\
\end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
\SetRowColor{FootBackground}
\mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Cheat Sheet}} \\
\vspace{-2pt}Published 18th July, 2017.\\
Updated 18th July, 2017.\\
Page {\thepage} of \pageref{LastPage}.
\end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
\SetRowColor{FootBackground}
\mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Sponsor}} \\
\SetRowColor{white}
\vspace{-5pt}
%\includegraphics[width=48px,height=48px]{dave.jpeg}
Measure your website readability!\\
www.readability-score.com
\end{tabulary}
\end{multicols}}
\begin{document}
\raggedright
\raggedcolumns
% Set font size to small. Switch to any value
% from this page to resize cheat sheet text:
% www.emerson.emory.edu/services/latex/latex_169.html
\footnotesize % Small font.
\begin{multicols*}{2}
\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Introduction}} \tn
\SetRowColor{white}
\mymulticolumn{1}{x{8.4cm}}{This is where the rubber meets the road. Capacity planning is part mathematical calculations: adding up all power which will be consumed then calculating what kind of cooling will be needed to remove the heat waste, and is also part art: guessing what the facility will require in the future as technology and requirements change. Since the "art" part of planning can get a little wonky, let's start with the math. \newline % Row Count 9 (+ 9)
The best place to start when calculating required cooling is power draw. With very few exceptions (like POE) all power consumed by IT equipment is turned into heat. Since the electrical signals coming into and leaving the datacenter are negligible, and IT equipment doesn't output any kind of mechanical work, it is safe to assume that all power is being turned into waste heat. This means if you know how much power each device will consume, then you know how much heat it will produce. Face it, your datacenter is nothing but a big, expensive heater.% Row Count 21 (+ 12)
} \tn
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{8.4cm}}{Credit: \seqsplit{https://packetpushers.net/back-basics-cooling-part-2/}} \tn
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}
\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Calculations}} \tn
\SetRowColor{white}
\mymulticolumn{1}{x{8.4cm}}{Figuring out your total wattage (power) draw can typically be done by looking at the capacity of your UPS system. If your UPS can only output 10,000 Watts/VA (there is a difference, but suffice it to say: it is negligible for IT equipment), then you can start at 10,000 watts (10kW) for your cooling calculation. We will use this as a starting point in the example calculation \newline % Row Count 8 (+ 8)
UPS Max Output = 10kW \newline % Row Count 9 (+ 1)
Expected UPS utilization: 50\%, or 5kW of draw by equipment \newline % Row Count 11 (+ 2)
After determining we only expect to draw 5kW of power, we can add in some additional metrics: \newline % Row Count 13 (+ 2)
(1) UPS Inefficiencies: (.04 × UPS Max Watt Rating) + (.05 × expected wattage draw) \newline % Row Count 15 (+ 2)
(2) Power Distribution: (.01 × UPS Max Watt Rating) + (.02 × expected wattage draw) \newline % Row Count 17 (+ 2)
(3) Lighting: (22 Watts × Floor Area in m$^{\textrm{2}}$) or (2 Watts × Floor Area in ft$^{\textrm{2}}$) \newline % Row Count 19 (+ 2)
(4) People: (100 Watts × max number of people) \newline % Row Count 20 (+ 1)
Saving you the long form math, considering 100ft$^{\textrm{2}}$ of space and no people, we end up with 6050 Watts of heat production.% Row Count 23 (+ 3)
} \tn
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}
\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Cooling Power Requirements}} \tn
\SetRowColor{LightBackground}
\mymulticolumn{1}{p{8.4cm}}{\vspace{1px}\centerline{\includegraphics[width=5.1cm]{/web/www.cheatography.com/public/uploads/davidpol_1467781442_cooling.png}}} \tn
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{8.4cm}}{\seqsplit{http://www.datacentrepowermag.com/features/18252-calculating-total-power-requirements-for-data-centres}} \tn
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}
\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{The "Art"}} \tn
\SetRowColor{white}
\mymulticolumn{1}{x{8.4cm}}{Now we get into the "art" and the more elusive metrics. It is obvious that much of the heat gained or lost by a facility is due to the environment around it. Depending on the insulation in the external walls and the climate, this factor can be orders of magnitude higher or lower. Since this factor is, by itself, very complex and tricky, we will leave it out of the discussion for now. It is also important to note that if your datacenter is an air conditioned room inside of an already climate controlled building (like a data room in an office building), then you can, for the most part, ignore this metric. \newline % Row Count 13 (+ 13)
The other evasive metric is utilization change or "room for growth". We scoped a 10kW UPS but only expect to use 50\% of that max capacity. If we scope a cooling system which perfectly matches the expected 6050 watts of heat production, then we have no room for growth in regards to cooling. We can scope a cooling system which matches the UPS, but that can get expensive. This metric varies widely depending on the particular installation. My advice is to calculate the cooling needed for initial expected consumption, then calculate the cooling for the max capacity of the power systems, and pick a size in the middle based on your best guess of required headroom.% Row Count 27 (+ 14)
} \tn
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}
\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Converting Units}} \tn
\SetRowColor{white}
\mymulticolumn{1}{x{8.4cm}}{The cooling cycleNow we have determined we need to account for 8000 Watts of heat production (6050 + some growing room), we can convert this to a number which is meaningful to a HVAC engineer. Using the conversion tables above, we can determine we need 26296 BTUs or 2.272 tons of refrigeration capacity. Since refrigeration units come in integer sizes of tons, or factors of 12,000BTU, we have to round up to a 3 ton or 36000 BTU unit. And there you have it.% Row Count 10 (+ 10)
} \tn
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}
% That's all folks
\end{multicols*}
\end{document}