页面中无法容纳导入的 Excel 表格(水平框和垂直框过满)

页面中无法容纳导入的 Excel 表格(水平框和垂直框过满)

大家晚上好。我正拼命想把这个表格放进一个水平页面。因为我用 excel2latex 导入它,所以我用的是环境array,我真的不知道该怎么做才能让它适合...我试过使用tabularx,但我的 LaTeX 无法编译...这个表似乎太大太高了...

\documentclass{article}
\usepackage[utf8]{inputenc}
\linespread{1.3}
\usepackage[margin=1.2in]{geometry}
\usepackage{eurosym}
\usepackage{makeidx}
\usepackage{amsfonts}
\usepackage{amssymb}
\usepackage{graphicx}
\usepackage{amsmath}
\usepackage{cases}
\usepackage[titletoc]{appendix}
\usepackage{color,soul}
\usepackage{amsthm}
\usepackage{thmtools}
\usepackage{mathrsfs}
\usepackage{enumerate}
\usepackage{hyperref}
\usepackage[hyphens]{url}
\usepackage{pgfplots}
\usetikzlibrary{patterns}
\usepgfplotslibrary{groupplots}
\usepackage{lscape}
\usepackage{caption}
\usepackage{subfigure}
\usepackage{tabularx}

\begin{document}
\begin{landscape}
\begin{array}{l l l l l l l l l l l l}

    \  & \  & \  & \  & \  & \  & \  & \  & \  & \  & \  & \  \\
    Economic Analysis & Unit of Measure & BAU &  &  &  & \textbf{PROJECT} &  &  &  &  &  \\ \hline
     &  & 2024-2029**  &  & 2030-2041  &  & 2024-2025 &  & 2026-2029**  &  & 2030-2041  &  \\ \hline
     &  & Peak & Off-Peak & Peak & Off-Peak & Peak & Off-Peak & Peak & Off-Peak & Peak & Off-Peak \\ 
    Investment & € & 0 &  & 0 &  & 175 &  & 0 &  & 0 &  \\ \hline
    VOT  & €/h & 10 & 10 & 10 & 10 & 10 & 10 & 10 & 10 & 10 & 10 \\ \hline
    Extra Delay  & h & 0.67 & 0.33 & 0.67 & 0.33 & 0.67 & 0.33 & 0.33 & 0.17 & 0.33 & 0.17 \\ \hline
    Delay costs & € & 6.67 & 3.33 & 6.67 & 3.33 & 6.67 & 3.33 & 3.33 & 1.67 & 3.33 & 1.67 \\ \hline
    A\&D Tourist & mln / year & 8 & 2 & 5.5 & 1.17 & 8 & 2 & 8.33 & 2.06 & 5.83 & 1.22 \\ \hline
    A\&D Locals  & mln / year & 2 & 3 & 1.875 & 2.75 & 2 & 3 & 2.07 & 3.07 & 1.89 & 2.77 \\ \hline
    TOTAL & mln / year & 10 & 5 & 7.36 & 3.92 & 10 & 5 & 10.4 & 5.12 & 7.72 & 3.99 \\ \hline
    Price Tourist & €/trip & 160 & 120 & 185 & 145 & 160 & 120 & 160 & 120 & 185 & 145 \\ \hline
    Elasticity (Tourist) &  & 2 & 2 & 2 & 2 & 2 & 2 & 2 & 2 & 2 & 2 \\ \hline
    Res. Price (Tourist)  & €/trip & 240 & 180 & 240 & 180 & 240 & 180 & 240 & 180 & 240 & 180 \\ \hline
    Price Locals & €/trip & 40 & 30 & 65 & 55 & 40 & 30 & 40 & 30 & 65 & 55 \\ \hline
    Elasticity (Locals)  &  & 0.4 & 0.4 & 0.4 & 0.4 & 0.4 & 0.4 & 0.4 & 0.4 & 0.4 & 0.4 \\ \hline
    Res. Price (Locals)  & €/trip & 560 & 420 & 560 & 420 & 560 & 420 & 560 & 420 & 560 & 420 \\ \hline
    Subsidy (€/trip)  & €/trip & 120 & 90 & 120 & 90 & 120 & 90 & 120 & 90 & 120 & 90 \\ \hline
    Revenues (Tourist)  & mln € & 1280 & 240 & 880 & 140 & 1280 & 240 & 1333.33 & 246.67 & 933.33 & 146.67 \\ \hline
    Revenues (Locals) & mln € & 80 & 90 & 75 & 82.5 & 80 & 90 & 82.67 & 92 & 75.67 & 83 \\ \hline
    TOTAL REVENUES & mln € & 1690 &  & 1177.5 &  & 1690 &  & 1754.67 &  & 1238.67 &  \\ \hline
    CS (Tourist)  & mln € & 320 & 60 & 151.25 & 20.42 & 320 & 60 & 347.22 & 63.38 & 170.14 & 22.41 \\ \hline
    CS (Locals)  & mln € & 640 & 720 & 576.5625 & 625.625 & 640 & 720 & 664.78 & 738.56 & 584.84 & 631.72 \\ \hline
    TOTAL CS & mln € & 1740 &  & 1373.85 &  & 1740 &  & 1813.94 &  & 1409.11 &  \\ \hline
    GROSS WELFARE  & mln € & 3430 &  & 2551.35 &  & 3430 &  & 3568.6 &  & 2647.76 &  \\ \hline
    Permits 2030  & (€ / ton CO2 pas trip) & 50 &  &  &  & 50 &  &  &  & 50 &  \\ \hline
    Social Discount Rate &  & 0.05 &  &  &  & 0.05 &  &  &  & 0.05 &  \\ \hline
    Actual Permit Prices & / ton CO2 pas trip) & 37.31 &  &  &  & 37.31 &  &  &  & 37.31 &  \\ \hline
    Emissions & \text{ton $CO_2$ / pas trip} & 0.5 &  &  &  & 0.5 &  &  &  & 0.5 &  \\ \hline
    TOTAL EXTERNAL COSTS* & (€) (year) & 279.83 &  & 0 &  & 279.83 &  & 289.57 &  & 0 &  \\ \hline
    FLOW EXTERNAL COSTS* & (€) & 1678.98 &  & 0 &  & 559.66 &  & 1158.29 &  & 0 &  \\ \hline
    NPV & (€) & 31544.88 &  &  &  & 32223.96 &  &  &  &  &  \\ \hline
     &  &  &  &  & \  & \  & \  & \  & \  & \  & \  \\ \hline
    NET BENEFIT &  &  & 679.072 &  &  &  &  &  &  & \  & \  \\ \hline
     &  &  &  &  &  &  &  &  &  &  & \  \\ \hline
    IRR &  &  & 0.29 & \#NUM! &  &  &  &  &  &  & \  \\ \hline
\end{array}
\end{landscape}


\end{document}

Overfull \hbox (307.39384pt too wide) in paragraph at lines 154--193
Overfull \vbox (129.3531pt too high) has occurred while \output is active []

答案1

这是一个解决方案,它使用tabular环境(实际上是tabular*环境)而不是array环境,将表格材料嵌入环境中sidewaystable,小心地构造标题材料,并使用少量但间距适当的水平规则。无需减小字体大小。

在此处输入图片描述

\documentclass{article}
\usepackage[utf8]{inputenc}
%\linespread{1.3} % don't use the low-level macro '\linespread' directly
\usepackage{setspace}\setstretch{1.3}
\usepackage[margin=1.2in]{geometry}
\usepackage{eurosym}
\usepackage{makeidx}
%%\usepackage{amsfonts} % is loaded automatically by 'amssymb'
\usepackage{amssymb}
\usepackage{graphicx}
\usepackage{amsmath}
\usepackage{cases}
\usepackage[titletoc]{appendix}
\usepackage{color,soul}
\usepackage{amsthm}
\usepackage{thmtools}
\usepackage{mathrsfs}
\usepackage{enumerate} % 'enumitem' package would be a better choice
\usepackage{pgfplots}
\usetikzlibrary{patterns}
\usepgfplotslibrary{groupplots}
%%\usepackage{lscape}
\usepackage{pdflscape}
\usepackage{caption}
%%\usepackage{subfigure} % 'subfigure' is deprecated! 
\usepackage{subcaption}
\usepackage{tabularx}
\usepackage{booktabs,mhchem,rotating} % <-- new
%%\usepackage[hyphens]{url}
\usepackage{xurl}
\usepackage{hyperref} % load this package _last_

\begin{document}

\begin{sidewaystable}
\setlength\tabcolsep{0pt}
\begin{tabular*}{\textwidth}{@{\extracolsep{\fill}} *{12}{l} }
    \toprule
    Economic variable & Unit & \multicolumn{4}{c}{BAU} & \multicolumn{6}{c}{PROJECT} \\ 
    \cmidrule{3-6} \cmidrule{7-12}
     & &  \multicolumn{2}{c}{2024--2029**} & 
          \multicolumn{2}{c}{2030--2041}   & 
          \multicolumn{2}{c}{2024--2025}   & 
          \multicolumn{2}{c}{2026--2029**} &  
          \multicolumn{2}{c}{2030--2041}   \\ 
    \cmidrule{3-4} \cmidrule{5-6} \cmidrule{7-8} \cmidrule{9-10} \cmidrule{11-12}
    & &  Peak & O/P & Peak & O/P & Peak & O/P & Peak & O/P & Peak & O/P \\ 
    \midrule
    Investment   & €        & 0 & & 0 & & 175 & & 0 & & 0 &  \\ 
    VOT          & €/h      & 10 & 10 & 10 & 10 & 10 & 10 & 10 & 10 & 10 & 10 \\ 
    Extra Delay  & h        & 0.67 & 0.33 & 0.67 & 0.33 & 0.67 & 0.33 & 0.33 & 0.17 & 0.33 & 0.17 \\ 
    Delay costs  & €        & 6.67 & 3.33 & 6.67 & 3.33 & 6.67 & 3.33 & 3.33 & 1.67 & 3.33 & 1.67 \\ 
    A\&D Tourist & mln/year & 8 & 2 & 5.5 & 1.17 & 8 & 2 & 8.33 & 2.06 & 5.83 & 1.22 \\ 
    A\&D Locals  & mln/year & 2 & 3 & 1.875 & 2.75 & 2 & 3 & 2.07 & 3.07 & 1.89 & 2.77 \\ 
    TOTAL        & mln/year & 10 & 5 & 7.36 & 3.92 & 10 & 5 & 10.4 & 5.12 & 7.72 & 3.99 \\ 
    Price Tourist& €/trip   & 160 & 120 & 185 & 145 & 160 & 120 & 160 & 120 & 185 & 145 \\ 
    Elasticity (Tourist) & -- & 2 & 2 & 2 & 2 & 2 & 2 & 2 & 2 & 2 & 2 \\ 
    Res. Price (Tourist)  & €/trip & 240 & 180 & 240 & 180 & 240 & 180 & 240 & 180 & 240 & 180 \\ 
    Price Locals & €/trip & 40 & 30 & 65 & 55 & 40 & 30 & 40 & 30 & 65 & 55 \\ 
    Elasticity (Locals)  & -- & 0.4 & 0.4 & 0.4 & 0.4 & 0.4 & 0.4 & 0.4 & 0.4 & 0.4 & 0.4 \\ 
    Res. Price (Locals)  & €/trip & 560 & 420 & 560 & 420 & 560 & 420 & 560 & 420 & 560 & 420 \\ 
    Subsidy (€/trip)  & €/trip & 120 & 90 & 120 & 90 & 120 & 90 & 120 & 90 & 120 & 90 \\ 
    Revenues (Tourist)  & mln € & 1280 & 240 & 880 & 140 & 1280 & 240 & 1333.33 & 246.67 & 933.33 & 146.67 \\ 
    Revenues (Locals) & mln € & 80 & 90 & 75 & 82.5 & 80 & 90 & 82.67 & 92 & 75.67 & 83 \\ 
    TOTAL REVENUES & mln € & 1690 & & 1177.5 & & 1690 & & 1754.67 & & 1238.67 &  \\ 
    CS (Tourist)   & mln € & 320 & 60 & 151.25 & 20.42 & 320 & 60 & 347.22 & 63.38 & 170.14 & 22.41 \\ 
    CS (Locals)    & mln € & 640 & 720 & 576.5625 & 625.625 & 640 & 720 & 664.78 & 738.56 & 584.84 & 631.72 \\ 
    TOTAL CS       & mln € & 1740 & & 1373.85 & & 1740 & & 1813.94 & & 1409.11 &  \\ 
    GROSS WELFARE  & mln € & 3430 & & 2551.35 & & 3430 & & 3568.6 & & 2647.76 &  \\ 
    Permits 2030   & €/ton \ce{CO2} pas trip & 50 & &  & & 50 & &  & & 50 &  \\ 
    Social Discount Rate & & 0.05 & &  & & 0.05 & &  & & 0.05 &  \\ 
    Actual Permit Prices &/ton \ce{CO2} pas trip & 37.31 & &  & & 37.31 & &  & & 37.31 &  \\ 
    Emissions      & ton \ce{CO2}/pas trip & 0.5 & &  & & 0.5 & &  & & 0.5 &  \\ 
    \addlinespace
    TOTAL EXT. COSTS* & € (year) & 279.83 & & 0 & & 279.83 & & 289.57 & & 0 &  \\ 
    FLOW EXT. COSTS* & € & 1678.98 & & 0 & & 559.66 & & 1158.29 & & 0 &  \\ 
    NPV & € & 31544.88 & &  & & 32223.96   \\ 
    NET BENEFIT & &  & 679.072 \\ 
    IRR & &  & 0.29 & \#NUM!  \\ 
    \bottomrule
\end{tabular*}
\end{sidewaystable}

\end{document}

答案2

首先,我添加了booktabs,这总是对更好的行间距和规则有用,并且pdflscape能够在监视器中水平查看横向表,以便于调试。字体大小为\small,行\arraystretcharray包中拉伸。我添加了一些multicolumns以使第二行在 Peak / Off-Peack 上居中,并使大多数列居中以便更好地查看。

在此处输入图片描述

\documentclass{article}
\usepackage[utf8]{inputenc}
%\linespread{1.3}
\usepackage[margin=1.2cm]{geometry}
\usepackage{eurosym}
\usepackage{makeidx}
\usepackage{amsfonts}
\usepackage{amssymb}
\usepackage{graphicx}
\usepackage{amsmath}
\usepackage{cases}
\usepackage[titletoc]{appendix}
\usepackage{color,soul}
\usepackage{amsthm}
\usepackage{thmtools}
\usepackage{mathrsfs}
\usepackage{enumerate}
\usepackage{hyperref}
\usepackage{pgfplots}
\usetikzlibrary{patterns}
\usepgfplotslibrary{groupplots}
\usepackage{lscape}
\usepackage{caption}
\usepackage{subfigure}
\usepackage{tabularx}

\RequirePackage{pdflscape} % added  
\RequirePackage{booktabs} % added

\begin{document}
\begin{landscape}
    \small
\renewcommand{\arraystretch}{1.3} %% added  
    
\begin{tabular}{l c c c c c c c c c c c}

%    \  & \  & \  & \  & \  & \  & \  & \  & \  & \  & \  & \  \\
\toprule
    Economic Analysis & Unit of Measure  BAU &\multicolumn{10}{c}{\textbf{PROJECT}} \\ 
    \toprule
     &  & \multicolumn{2}{c}{2024-2029**}   & \multicolumn{2}{c}{2030-2041 } & \multicolumn{2}{c}{2024-2025} & \multicolumn{2}{c}{2026-2029**}  & \multicolumn{2}{c}{2030-2041} \\ \hline      
     &  & Peak & Off-Peak & Peak & Off-Peak & Peak & Off-Peak & Peak & Off-Peak & Peak & Off-Peak \\ \midrule
    Investment & € & 0 &  & 0 &  & 175 &  & 0 &  & 0 &  \\ \hline
    VOT  & €/h & 10 & 10 & 10 & 10 & 10 & 10 & 10 & 10 & 10 & 10 \\ \hline
    Extra Delay  & h & 0.67 & 0.33 & 0.67 & 0.33 & 0.67 & 0.33 & 0.33 & 0.17 & 0.33 & 0.17 \\ \hline
    Delay costs & € & 6.67 & 3.33 & 6.67 & 3.33 & 6.67 & 3.33 & 3.33 & 1.67 & 3.33 & 1.67 \\ \hline
    A\&D Tourist & mln / year & 8 & 2 & 5.5 & 1.17 & 8 & 2 & 8.33 & 2.06 & 5.83 & 1.22 \\ \hline
    A\&D Locals  & mln / year & 2 & 3 & 1.875 & 2.75 & 2 & 3 & 2.07 & 3.07 & 1.89 & 2.77 \\ \hline
    TOTAL & mln / year & 10 & 5 & 7.36 & 3.92 & 10 & 5 & 10.4 & 5.12 & 7.72 & 3.99 \\ \hline
    Price Tourist & €/trip & 160 & 120 & 185 & 145 & 160 & 120 & 160 & 120 & 185 & 145 \\ \hline
    Elasticity (Tourist) &  & 2 & 2 & 2 & 2 & 2 & 2 & 2 & 2 & 2 & 2 \\ \hline
    Res. Price (Tourist)  & €/trip & 240 & 180 & 240 & 180 & 240 & 180 & 240 & 180 & 240 & 180 \\ \hline
    Price Locals & €/trip & 40 & 30 & 65 & 55 & 40 & 30 & 40 & 30 & 65 & 55 \\ \hline
    Elasticity (Locals)  &  & 0.4 & 0.4 & 0.4 & 0.4 & 0.4 & 0.4 & 0.4 & 0.4 & 0.4 & 0.4 \\ \hline
    Res. Price (Locals)  & €/trip & 560 & 420 & 560 & 420 & 560 & 420 & 560 & 420 & 560 & 420 \\ \hline
    Subsidy (€/trip)  & €/trip & 120 & 90 & 120 & 90 & 120 & 90 & 120 & 90 & 120 & 90 \\ \hline
    Revenues (Tourist)  & mln € & 1280 & 240 & 880 & 140 & 1280 & 240 & 1333.33 & 246.67 & 933.33 & 146.67 \\ \hline
    Revenues (Locals) & mln € & 80 & 90 & 75 & 82.5 & 80 & 90 & 82.67 & 92 & 75.67 & 83 \\ \hline
    TOTAL REVENUES & mln € & 1690 &  & 1177.5 &  & 1690 &  & 1754.67 &  & 1238.67 &  \\ \hline
    CS (Tourist)  & mln € & 320 & 60 & 151.25 & 20.42 & 320 & 60 & 347.22 & 63.38 & 170.14 & 22.41 \\ \hline
    CS (Locals)  & mln € & 640 & 720 & 576.5625 & 625.625 & 640 & 720 & 664.78 & 738.56 & 584.84 & 631.72 \\ \hline
    TOTAL CS & mln € & 1740 &  & 1373.85 &  & 1740 &  & 1813.94 &  & 1409.11 &  \\ \hline
    GROSS WELFARE  & mln € & 3430 &  & 2551.35 &  & 3430 &  & 3568.6 &  & 2647.76 &  \\ \hline
    Permits 2030  & (€ / ton CO2 pas trip) & 50 &  &  &  & 50 &  &  &  & 50 &  \\ \hline
    Social Discount Rate &  & 0.05 &  &  &  & 0.05 &  &  &  & 0.05 &  \\ \hline
    Actual Permit Prices & / ton CO2 pas trip) & 37.31 &  &  &  & 37.31 &  &  &  & 37.31 &  \\ \hline
    Emissions & \text{ton $CO_2$ / pas trip} & 0.5 &  &  &  & 0.5 &  &  &  & 0.5 &  \\ \hline
    TOTAL EXTERNAL COSTS* & (€) (year) & 279.83 &  & 0 &  & 279.83 &  & 289.57 &  & 0 &  \\ \hline
    FLOW EXTERNAL COSTS* & (€) & 1678.98 &  & 0 &  & 559.66 &  & 1158.29 &  & 0 &  \\ \hline
    NPV & (€) & 31544.88 &  &  &  & 32223.96 &  &  &  &  &  \\ \hline
     &  &  &  &  & \  & \  & \  & \  & \  & \  & \  \\ \hline
    NET BENEFIT &  &  & 679.072 &  &  &  &  &  &  & \  & \  \\ \hline
     &  &  &  &  &  &  &  &  &  &  & \  \\ \hline
    IRR &  &  & 0.29 & \#NUM! &  &  &  &  &  &  & \\ \bottomrule
\end{tabular}
\end{landscape}


\end{document}

答案3

您使用的是array数学模式之外的环境。此外,还存在与包相关的冲突url。我还减小了字体大小。这将起作用:

\documentclass{article}
\usepackage[utf8]{inputenc}
\linespread{1.3}
\usepackage[margin=1.2in]{geometry}
\usepackage{eurosym}
\usepackage{makeidx}
\usepackage{amsfonts}
\usepackage{amssymb}
\usepackage{graphicx}
\usepackage{amsmath}
\usepackage{cases}
\usepackage[titletoc]{appendix}
\usepackage{color,soul}
\usepackage{amsthm}
\usepackage{thmtools}
\usepackage{mathrsfs}
\usepackage{enumerate}
\usepackage{hyperref}
\usepackage{pgfplots}
\usetikzlibrary{patterns}
\usepgfplotslibrary{groupplots}
\usepackage{lscape}
\usepackage{caption}
\usepackage{subfigure}
\usepackage{tabularx}

\begin{document}
\begin{landscape}\tiny
\begin{tabular}{l l l l l l l l l l l l}

    \  & \  & \  & \  & \  & \  & \  & \  & \  & \  & \  & \  \\
    Economic Analysis & Unit of Measure & BAU &  &  &  & \textbf{PROJECT} &  &  &  &  &  \\ \hline
     &  & 2024-2029**  &  & 2030-2041  &  & 2024-2025 &  & 2026-2029**  &  & 2030-2041  &  \\ \hline
     &  & Peak & Off-Peak & Peak & Off-Peak & Peak & Off-Peak & Peak & Off-Peak & Peak & Off-Peak \\ 
    Investment & € & 0 &  & 0 &  & 175 &  & 0 &  & 0 &  \\ \hline
    VOT  & €/h & 10 & 10 & 10 & 10 & 10 & 10 & 10 & 10 & 10 & 10 \\ \hline
    Extra Delay  & h & 0.67 & 0.33 & 0.67 & 0.33 & 0.67 & 0.33 & 0.33 & 0.17 & 0.33 & 0.17 \\ \hline
    Delay costs & € & 6.67 & 3.33 & 6.67 & 3.33 & 6.67 & 3.33 & 3.33 & 1.67 & 3.33 & 1.67 \\ \hline
    A\&D Tourist & mln / year & 8 & 2 & 5.5 & 1.17 & 8 & 2 & 8.33 & 2.06 & 5.83 & 1.22 \\ \hline
    A\&D Locals  & mln / year & 2 & 3 & 1.875 & 2.75 & 2 & 3 & 2.07 & 3.07 & 1.89 & 2.77 \\ \hline
    TOTAL & mln / year & 10 & 5 & 7.36 & 3.92 & 10 & 5 & 10.4 & 5.12 & 7.72 & 3.99 \\ \hline
    Price Tourist & €/trip & 160 & 120 & 185 & 145 & 160 & 120 & 160 & 120 & 185 & 145 \\ \hline
    Elasticity (Tourist) &  & 2 & 2 & 2 & 2 & 2 & 2 & 2 & 2 & 2 & 2 \\ \hline
    Res. Price (Tourist)  & €/trip & 240 & 180 & 240 & 180 & 240 & 180 & 240 & 180 & 240 & 180 \\ \hline
    Price Locals & €/trip & 40 & 30 & 65 & 55 & 40 & 30 & 40 & 30 & 65 & 55 \\ \hline
    Elasticity (Locals)  &  & 0.4 & 0.4 & 0.4 & 0.4 & 0.4 & 0.4 & 0.4 & 0.4 & 0.4 & 0.4 \\ \hline
    Res. Price (Locals)  & €/trip & 560 & 420 & 560 & 420 & 560 & 420 & 560 & 420 & 560 & 420 \\ \hline
    Subsidy (€/trip)  & €/trip & 120 & 90 & 120 & 90 & 120 & 90 & 120 & 90 & 120 & 90 \\ \hline
    Revenues (Tourist)  & mln € & 1280 & 240 & 880 & 140 & 1280 & 240 & 1333.33 & 246.67 & 933.33 & 146.67 \\ \hline
    Revenues (Locals) & mln € & 80 & 90 & 75 & 82.5 & 80 & 90 & 82.67 & 92 & 75.67 & 83 \\ \hline
    TOTAL REVENUES & mln € & 1690 &  & 1177.5 &  & 1690 &  & 1754.67 &  & 1238.67 &  \\ \hline
    CS (Tourist)  & mln € & 320 & 60 & 151.25 & 20.42 & 320 & 60 & 347.22 & 63.38 & 170.14 & 22.41 \\ \hline
    CS (Locals)  & mln € & 640 & 720 & 576.5625 & 625.625 & 640 & 720 & 664.78 & 738.56 & 584.84 & 631.72 \\ \hline
    TOTAL CS & mln € & 1740 &  & 1373.85 &  & 1740 &  & 1813.94 &  & 1409.11 &  \\ \hline
    GROSS WELFARE  & mln € & 3430 &  & 2551.35 &  & 3430 &  & 3568.6 &  & 2647.76 &  \\ \hline
    Permits 2030  & (€ / ton CO2 pas trip) & 50 &  &  &  & 50 &  &  &  & 50 &  \\ \hline
    Social Discount Rate &  & 0.05 &  &  &  & 0.05 &  &  &  & 0.05 &  \\ \hline
    Actual Permit Prices & / ton CO2 pas trip) & 37.31 &  &  &  & 37.31 &  &  &  & 37.31 &  \\ \hline
    Emissions & \text{ton $CO_2$ / pas trip} & 0.5 &  &  &  & 0.5 &  &  &  & 0.5 &  \\ \hline
    TOTAL EXTERNAL COSTS* & (€) (year) & 279.83 &  & 0 &  & 279.83 &  & 289.57 &  & 0 &  \\ \hline
    FLOW EXTERNAL COSTS* & (€) & 1678.98 &  & 0 &  & 559.66 &  & 1158.29 &  & 0 &  \\ \hline
    NPV & (€) & 31544.88 &  &  &  & 32223.96 &  &  &  &  &  \\ \hline
     &  &  &  &  & \  & \  & \  & \  & \  & \  & \  \\ \hline
    NET BENEFIT &  &  & 679.072 &  &  &  &  &  &  & \  & \  \\ \hline
     &  &  &  &  &  &  &  &  &  &  & \  \\ \hline
    IRR &  &  & 0.29 & \#NUM! &  &  &  &  &  &  & \  \\ \hline
\end{tabular}
\end{landscape}


\end{document}

相关内容