$activeSheet->getStyle("{$letter}{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
$letter++;
$activeSheet->setCellValue("{$letter}{$count}", "=F{$count}*G{$count}");
$activeSheet->getStyle("{$letter}{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED4);
$letter++;
$activeSheet->setCellValue("{$letter}{$count}", $row['reference']);
$letter++;
$activeSheet->setCellValue("{$letter}{$count}", $row['o_date']);
$letter++;
$activeSheet->setCellValue("{$letter}{$count}", zeroBlank($row['order']));
$activeSheet->getStyle("{$letter}{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED4);
$letter++;
$activeSheet->setCellValue("{$letter}{$count}", zeroBlank($row['o_rate']));
$activeSheet->getStyle("{$letter}{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED4);
$letter++;
$activeSheet->setCellValue("{$letter}{$count}", zeroBlank($row['rec']));
$activeSheet->getStyle("{$letter}{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED4);
$letter++;
$activeSheet->setCellValue("{$letter}{$count}", "=K{$count}-M{$count}");
$activeSheet->getStyle("{$letter}{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED4);
$letter++;
$activeSheet->setCellValue("{$letter}{$count}", "=N{$count}*K{$count}");
$activeSheet->getStyle("{$letter}{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED4);
$letter++;
$count++;
$letter = 'A';
}
$activeSheet->mergeCells("A{$count}:G{$count}");
$activeSheet->setCellValue("A{$count}", "");
$activeSheet->setCellValue("H{$count}", "=sum(H" . $startCount . ":H" . ($count - 1) . ")");
$activeSheet->getStyle("H{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED4);
$letter++;
$costLetter = $letter;
$profitMargin = $row['profit_margin'];
$activeSheet->setCellValue("{$letter}{$count}", zeroBlank($row['cost']));
$activeSheet->getStyle("{$letter}{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
$letter++;
$s = "=({$profitMargin}/100*{$costLetter}{$count}) + {$costLetter}{$count}";
$activeSheet->setCellValue("{$letter}{$count}", "=({$profitMargin}/100*{$costLetter}{$count}) + {$costLetter}{$count}");
$activeSheet->getStyle("{$letter}{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
$letter++;
}
if ($_GET['mm'] == 'complete' || $_GET['mm'] == 'rate') {
$activeSheet->setCellValue("{$letter}{$count}", zeroBlank($row['fix_rate']));
$activeSheet->getStyle("{$letter}{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED4);
$letter++;
$activeSheet->setCellValue("{$letter}{$count}", zeroBlank($row['circular_rate']));
$activeSheet->getStyle("{$letter}{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED4);
$letter++;
}
$activeSheet->setCellValue("{$letter}{$count}", $row['days']);
$activeSheet->getStyle("{$letter}{$count}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED4);
$letter++;
$count++;
$letter = 'A';
}
$activeSheet->getStyle("A" . ($startCount - 1) . ":{$lastLetter}" . ($count - 1))->applyFromArray($tableBorderArray);
$activeSheet->setBreak("A{$count}", PHPExcel_Worksheet::BREAK_ROW);
$count++;
}
$objPHPExcel->setActiveSheetIndex(0);
$fileName = "mm_{$_GET['mm']}.xlsx";
