Spreadsheet: 104800d1302259831-matching-data-from-one-sheet-to-another-based-on-cusips-kopie-von-merged_dataset
Sheet: profitab.measures

Quote Symbol | Entity Name | tf.CUSIP6 | tf.CUSIP | CUSIP | Global Company Key | tf.Operating Profit Margin[Y1996] | cs.EBITMargin[Y1996] | cs.EBITDAMargin[Y1996] | cs.Net Margin[Y1996] | tf.Return On Assets[Y1996] | ds.Market To Book Value[Y1996] | tf.Operating Profit Margin[Y1997] | cs.[NAME]] | cs.EBITDAMargin[Y1997] | cs.Net Margin[Y1997] | tf.Return On Assets[Y1997] | ds.Market To Book Value[Y1997] | tf.Operating Profit Margin[Y1998] | cs.EBITMargin[Y1998] | cs.EBITDAMargin[Y1998] | cs.Net Margin[Y1998] | tf.Return On Assets[Y1998] | ds.Market To Book Value[Y1998] | tf.Operating Profit Margin[Y1999] | cs.EBITMargin[Y1999] | cs.EBITDAMargin[Y1999] | cs.Net Margin[Y1999] | tf.Return On Assets[Y1999] | ds.[NAME] Value[Y1999] | tf.Operating Profit Margin[Y2000] | cs.[NAME] | cs.EBITDAMargin[Y2000] | cs.Net Margin[Y2000] | tf.Return On Assets[Y2000] | ds.[NAME] Value[Y2000] | tf.Operating Profit Margin[Y2001] | cs.EBITMargin[Y2001] | cs.EBITDAMargin[Y2001] | cs.Net Margin[Y2001] | tf.Return On Assets[Y2001] | ds.[NAME] Value[Y2001] | tf.Operating Profit Margin[Y2002] | cs.EBITMargin[Y2002] | cs.EBITDAMargin[Y2002] | cs.Net Margin[Y2002] | tf.Return On Assets[Y2002] | ds.Marketto Book Value[Y2002] | tf.Operating Profit Margin[Y2003] | cs.EBITMargin[Y2003] | cs.EBITDAMargin[Y2003] | cs.Net Margin[Y2003] | tf.Return On Assets[Y2003] | ds.[NAME] Value[Y2003] | tf.Operating Profit Margin[Y2004] | cs.EBITMargin[Y2004] | cs.EBITDAMargin[Y2004] | cs.Net Margin[Y2004] | tf.Return On Assets[Y2004] | ds.Marketto Book Value[Y2004] | tf.Operating Profit Margin[Y2005] | cs.EBITMargin[Y2005] | cs.EBITDAMargin[Y2005] | cs.Net Margin[Y2005] | tf.Return On Assets[Y2005] | ds.[NAME] Value[Y2005] | tf.Operating Profit Margin[Y2006] | cs.EBITMargin[Y2006] | cs.EBITDAMargin[Y2006] | cs.Net Margin[Y2006] | tf.Return On Assets[Y2006] | ds.[NAME] Value[Y2006] | tf.Operating Profit Margin[Y2007] | cs.EBITMargin[Y2007] | cs.EBITDAMargin[Y2007] | cs.Net Margin[Y2007] | tf.Return On Assets[Y2007] | ds.[NAME] Value[Y2007] | tf.Operating Profit Margin[Y2008] | cs.EBITMargin[Y2008] | cs.EBITDAMargin[Y2008] | cs.Net Margin[Y2008] | tf.Return On Assets[Y2008] | ds.[NAME] Value[Y2008] | tf.Operating Profit Margin[Y2009] | cs.EBITMargin[Y2009] | cs.EBITDAMargin[Y2009] | cs.Net Margin[Y2009] | tf.Return On Assets[Y2009] | ds.Marketto Book Value[Y2009] | tf.Operating Profit Margin[Y2010] | cs.EBITMargin[Y2010] | cs.[NAME]] | cs.Net Margin[Y2010] | tf.Return On Assets[Y2010] | ds.[NAME] Value[Y2010]
AIR-N | AAR Corp. | 000361 | 000361105 | 000361105 | 001004 | 6.42 | 7.28 | 9.36 | 3.91 | 5.31 | 1.79 | 7.28 | 8.27 | 10.1 | 4.56 | 6.21 | 2.36 | 8.27 | 8.43 | 10.29 | 4.54 | 7.51 | 2.03 | 8.43 | 6.9 | 8.69 | 3.43 | 7.69 | 1.45 | 6.9 | 5.24 | 7.36 | 2.12 | 6.87 | 1 | 4.62 | 0.74 | 4.26 | -9.23 | 4.54 | 0.78 | 0.74 | 0.59 | 5.07 | -2.05 | -6.53 | 0.56 | 0.59 | 3.19 | 7.28 | 0.54 | 0.04 | 1.59 | 3.29 | 4.52 | 8.26 | 2.07 | 2.25 | 1.4 | 4.52 | 6.98 | 10.24 | 3.92 | 3.67 | 1.87 | 6.98 | 8.17 | 11.21 | 5.53 | 5.48 | 2.17 | 8.17 | 9.28 | 12.17 | 5.43 | 6.79 | 2.92 | 9.28 | 8.82 | 11.66 | 5.52 | 7.29 | 1.22 | 8.82 | 7.06 | 9.94 | 3.3 | 6.61 | 1.36 | 6.67 | #N/A | #N/A | #N/A | 4.31 | 1.46
ABM-N | ABM Industries Inc | 000957 | 000957100 | 000957100 | 001410 | 3.84 | 3.84 | 5.1 | 2 | 7.15 | 1.81 | 3.96 | 3.96 | 5.25 | 2.17 | 7.25 | 2.61 | 4.06 | 4.06 | 5.36 | 2.26 | 7.9 | 2.67 | 4.25 | 4.25 | 5.52 | 2.43 | 8.13 | 1.44 | 4.21 | 4.21 | 5.51 | 2.45 | 8.14 | 1.94 | 2.85 | 2.85 | 4.2 | 1.68 | 5.49 | 1.98 | 2.77 | 2.77 | 3.46 | 2.14 | 7.19 | 1.71 | 2.46 | 2.6 | 3.26 | 4 | 12.68 | 1.91 | 1.96 | 2.67 | 3.4 | 1.26 | 4 | 2.04 | 2.52 | 2.51 | 3.27 | 2.24 | 7.09 | 1.76 | 2.88 | 3.1 | 3.86 | 3.44 | 9.96 | 1.82 | 2.7 | 2.76 | 3.42 | 1.85 | 4.91 | 1.68 | 3.25 | 3.15 | 3.93 | 1.25 | 4.36 | 1.51 | 2.65 | 2.37 | 3.33 | 1.56 | 3.98 | 1.55 | 3.35 | 3.4 | 4.44 | 1.83 | 4.54 | 1.87
AFL-N | Aflac Inc | 001055 | 001055102 | 001055102 | 062990 | 8.61 | 8.61 | 9.31 | 5.6 | 1.61 | 3.21 | 8.75 | 8.75 | 9.35 | 8.38 | 2.18 | 3.23 | 9.5 | 7.94 | 8.57 | 6.86 | 1.63 | 4.77 | 9.95 | 9.21 | 9.59 | 6.61 | 1.71 | 4.43 | 9.57 | 10.61 | 10.95 | 7.07 | 1.88 | 5.95 | 11.45 | 11.46 | 11.85 | 7.16 | 1.86 | 3.62 | 12.47 | 12.47 | 13.05 | 8 | 2.01 | 3.91 | 10.89 | 10.89 | 11.41 | 6.95 | 1.69 | 4.29 | 13.94 | 13.94 | 14.39 | 9.79 | 2.38 | 3.91 | 15.98 | 15.98 | 16.38 | 10.33 | 2.59 | 3.86 | 15.62 | 15.62 | 16.02 | 10.15 | 2.57 | 3.3 | 16.53 | 16.41 | 16.74 | 10.62 | 2.63 | 3.86 | 15.58 | 11.74 | 12.08 | 7.58 | 1.75 | 2.72 | 18.7 | 12.56 | 12.89 | 8.21 | 1.89 | 2.39 | 17.29 | #N/A | #N/A | #N/A | 2.53 | 2.94