abel/shopee-apps
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
shopee-apps/application/views/cetak/notused/excel_labarugi.php
T
abel db327c0305 copy dari repo om Irfan
2026-06-13 16:02:07 +10:00

690 lines
38 KiB
PHP
Raw Permalink Blame History

<?php
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
date_default_timezone_set('Europe/London');
require(APPPATH . 'PHPExcel-1.8/Classes/PHPExcel.php');
require(APPPATH . 'PHPExcel-1.8/Classes/PHPExcel/Writer/Excel2007.php');
use PHPExcel\Style\PHPExcel_Style_Alignment;
use PHPExcel\Style\PHPExcel_Style_Fill;
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setCreator("PC Master");
$objPHPExcel->getProperties()->setLastModifiedBy("PC Master");
$objPHPExcel->getProperties()->setTitle("Laporan");
$objPHPExcel->getProperties()->setSubject("");
$objPHPExcel->getProperties()->setDescription("");
$objPHPExcel->setActiveSheetIndex(0);
// font
$objPHPExcel->getDefaultStyle()
->getFont()
->setName("Calibri")
->setSize(12);
//heading
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'PT. TRIPERWIRA MULTI PAMENANG');
$objPHPExcel->getActiveSheet()->setCellValue('A2', 'LAPORAN LABARUGI');
$objPHPExcel->getActiveSheet()->setCellValue('A3', $judul);
//merge heading
$objPHPExcel->getActiveSheet()->mergeCells("A1:D1");
$objPHPExcel->getActiveSheet()->mergeCells("A2:D2");
$objPHPExcel->getActiveSheet()->mergeCells("A3:D3");
///font heading
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(18);
$objPHPExcel->getActiveSheet()->getStyle('A2:A3')->getFont()->setSize(17);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A2:A3')->getFont()->setBold(true);
//set cell alignment
$objPHPExcel->getActiveSheet()->getStyle('A1:A3')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('C6:C100')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('A6:B100')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('D6:D100')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
//lebar kolom
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setAutoSize(true);
//font Sela Antar Subtotal
$objPHPExcel->getActiveSheet()->getStyle('A5:D5')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('A5:D5')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A5')->getFont()->getColor()->setRGB('4C9D3B');
$objPHPExcel->getActiveSheet()->mergeCells("A5:D5");
$objPHPExcel->getActiveSheet()->setCellValue('A5', 'TOTAL PENJUALAN');
$objPHPExcel->getActiveSheet()->getStyle('A9:B9')->getFont()->setSize(15);
$objPHPExcel->getActiveSheet()->getStyle('A9:C9')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A9')->getFont()->getColor()->setRGB('5B5B5B');
$objPHPExcel->getActiveSheet()->mergeCells("A9:B9");
$objPHPExcel->getActiveSheet()->setCellValue('A9', 'Subtotal');
$objPHPExcel->getActiveSheet()->getStyle('A9')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('A11:D11')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('A11:D11')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A11')->getFont()->getColor()->setRGB('4C9D3B');
$objPHPExcel->getActiveSheet()->mergeCells("A11:D11");
$objPHPExcel->getActiveSheet()->setCellValue('A11', 'HARGA POKOK PENJUALAN');
$objPHPExcel->getActiveSheet()->getStyle('A16:B16')->getFont()->setSize(15);
$objPHPExcel->getActiveSheet()->getStyle('A16:C16')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A16')->getFont()->getColor()->setRGB('5B5B5B');
$objPHPExcel->getActiveSheet()->mergeCells("A16:B16");
$objPHPExcel->getActiveSheet()->setCellValue('A16', 'Subtotal');
$objPHPExcel->getActiveSheet()->getStyle('A16')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('A18:B18')->getFont()->setSize(15);
$objPHPExcel->getActiveSheet()->getStyle('A18:C18')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A18')->getFont()->getColor()->setRGB('5B5B5B');
$objPHPExcel->getActiveSheet()->mergeCells("A18:B18");
$objPHPExcel->getActiveSheet()->setCellValue('A18', 'Subtotal');
$objPHPExcel->getActiveSheet()->getStyle('A18')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('A20:B20')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('A20:C20')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A20')->getFont()->getColor()->setRGB('4C9D3B');
$objPHPExcel->getActiveSheet()->mergeCells("A20:B20");
$objPHPExcel->getActiveSheet()->setCellValue('A20', 'LABA KOTOR');
$objPHPExcel->getActiveSheet()->getStyle('A21:B21')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('A21:C21')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A21')->getFont()->getColor()->setRGB('F44336');
$objPHPExcel->getActiveSheet()->mergeCells("A21:D21");
$objPHPExcel->getActiveSheet()->setCellValue('A21', '(Total Penjualan - Harga Pokok Penjualan)');
$objPHPExcel->getActiveSheet()->getStyle('A23:D23')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('A23:D23')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A23')->getFont()->getColor()->setRGB('4C9D3B');
$objPHPExcel->getActiveSheet()->mergeCells("A23:D23");
$objPHPExcel->getActiveSheet()->setCellValue('A23', 'BIAYA PENJUALAN');
$objPHPExcel->getActiveSheet()->getStyle('A31:B31')->getFont()->setSize(15);
$objPHPExcel->getActiveSheet()->getStyle('A31:C31')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A31')->getFont()->getColor()->setRGB('5B5B5B');
$objPHPExcel->getActiveSheet()->mergeCells("A31:B31");
$objPHPExcel->getActiveSheet()->setCellValue('A31', 'Subtotal');
$objPHPExcel->getActiveSheet()->getStyle('A31')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('A33:D33')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('A33:D33')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A33')->getFont()->getColor()->setRGB('4C9D3B');
$objPHPExcel->getActiveSheet()->mergeCells("A33:D33");
$objPHPExcel->getActiveSheet()->setCellValue('A33', 'BIAYA UMUM DAN ADMINISTRASI');
$objPHPExcel->getActiveSheet()->getStyle('A76:B76')->getFont()->setSize(15);
$objPHPExcel->getActiveSheet()->getStyle('A76:C76')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A76')->getFont()->getColor()->setRGB('5B5B5B');
$objPHPExcel->getActiveSheet()->mergeCells("A76:B76");
$objPHPExcel->getActiveSheet()->setCellValue('A76', 'Subtotal');
$objPHPExcel->getActiveSheet()->getStyle('A76')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('A78:B78')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('A78:C78')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A78')->getFont()->getColor()->setRGB('4C9D3B');
$objPHPExcel->getActiveSheet()->mergeCells("A78:B78");
$objPHPExcel->getActiveSheet()->setCellValue('A78', 'TOTAL BIAYA');
$objPHPExcel->getActiveSheet()->getStyle('A79:B79')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('A79:C79')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A79')->getFont()->getColor()->setRGB('F44336');
$objPHPExcel->getActiveSheet()->mergeCells("A79:D79");
$objPHPExcel->getActiveSheet()->setCellValue('A79', '(Biaya Penjualan + Biaya Umum dan Administrasi)');
$objPHPExcel->getActiveSheet()->getStyle('A81:B81')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('A81:C81')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A81')->getFont()->getColor()->setRGB('4C9D3B');
$objPHPExcel->getActiveSheet()->mergeCells("A81:B81");
$objPHPExcel->getActiveSheet()->setCellValue('A81', 'LABA USAHA');
$objPHPExcel->getActiveSheet()->getStyle('A82:B82')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('A82:C82')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A82')->getFont()->getColor()->setRGB('F44336');
$objPHPExcel->getActiveSheet()->mergeCells("A82:D82");
$objPHPExcel->getActiveSheet()->setCellValue('A82', '(Laba Kotor - Total Biaya)');
$objPHPExcel->getActiveSheet()->getStyle('A84:B84')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('A84:C84')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A84')->getFont()->getColor()->setRGB('4C9D3B');
$objPHPExcel->getActiveSheet()->mergeCells("A84:B84");
$objPHPExcel->getActiveSheet()->setCellValue('A84', 'PENDAPATAN DAN (BEBAN) LUAR USAHA');
$objPHPExcel->getActiveSheet()->getStyle('A87:B87')->getFont()->setSize(15);
$objPHPExcel->getActiveSheet()->getStyle('A87:C87')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A87')->getFont()->getColor()->setRGB('5B5B5B');
$objPHPExcel->getActiveSheet()->mergeCells("A87:B87");
$objPHPExcel->getActiveSheet()->setCellValue('A87', 'Subtotal');
$objPHPExcel->getActiveSheet()->getStyle('A87')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('A90:B90')->getFont()->setSize(15);
$objPHPExcel->getActiveSheet()->getStyle('A90:C90')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A90')->getFont()->getColor()->setRGB('5B5B5B');
$objPHPExcel->getActiveSheet()->mergeCells("A90:B90");
$objPHPExcel->getActiveSheet()->setCellValue('A90', 'Subtotal');
$objPHPExcel->getActiveSheet()->getStyle('A90')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('A92:B92')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('A92:C92')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A92')->getFont()->getColor()->setRGB('4C9D3B');
$objPHPExcel->getActiveSheet()->mergeCells("A92:B92");
$objPHPExcel->getActiveSheet()->setCellValue('A92', 'TOTAL PENDAPATAN DAN (BEBAN) LUAR USAHA');
$objPHPExcel->getActiveSheet()->getStyle('A93:B93')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('A93:C93')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A93')->getFont()->getColor()->setRGB('F44336');
$objPHPExcel->getActiveSheet()->mergeCells("A93:D93");
$objPHPExcel->getActiveSheet()->setCellValue('A93', '(Total Pendapatan Luar Usaha - Total Beban Luar Usaha)');
$objPHPExcel->getActiveSheet()->getStyle('A95:B95')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('A95:C95')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A95')->getFont()->getColor()->setRGB('4C9D3B');
$objPHPExcel->getActiveSheet()->mergeCells("A95:B95");
$objPHPExcel->getActiveSheet()->setCellValue('A95', 'LABA BERSIH SEBELUM PAJAK');
$objPHPExcel->getActiveSheet()->getStyle('A96:B96')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('A96:C96')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A96')->getFont()->getColor()->setRGB('F44336');
$objPHPExcel->getActiveSheet()->mergeCells("A96:D96");
$objPHPExcel->getActiveSheet()->setCellValue('A96', '(Laba Usaha + Total Pendapatan Dan (Beban) Luar Usaha)');
$objPHPExcel->getActiveSheet()->getStyle('A98:B98')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('A98:C98')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A98')->getFont()->getColor()->setRGB('4C9D3B');
$objPHPExcel->getActiveSheet()->mergeCells("A98:B98");
$objPHPExcel->getActiveSheet()->setCellValue('A98', 'LABA BERSIH SETELAH PAJAK');
$objPHPExcel->getActiveSheet()->getStyle('A100:B100')->getFont()->setSize(15);
$objPHPExcel->getActiveSheet()->getStyle('A100:C100')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A100')->getFont()->getColor()->setRGB('5B5B5B');
$objPHPExcel->getActiveSheet()->mergeCells("A100:B100");
$objPHPExcel->getActiveSheet()->setCellValue('A100', 'Subtotal');
$objPHPExcel->getActiveSheet()->getStyle('A100')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
//Isi Data Total Penjualan
$objPHPExcel->getActiveSheet()->setCellValue('A6', '1');
$objPHPExcel->getActiveSheet()->setCellValue('B6', 'PENJUALAN');
$objPHPExcel->getActiveSheet()->setCellValue('C6', $l1);
$objPHPExcel->getActiveSheet()->setCellValue('D6', '+');
$objPHPExcel->getActiveSheet()->getStyle('D6')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D6')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A7', '2');
$objPHPExcel->getActiveSheet()->setCellValue('B7', 'RETUR PENJUALAN');
$objPHPExcel->getActiveSheet()->setCellValue('C7', $l2);
$objPHPExcel->getActiveSheet()->setCellValue('D7', '-');
$objPHPExcel->getActiveSheet()->getStyle('D7')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D7')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A8', '3');
$objPHPExcel->getActiveSheet()->setCellValue('B8', 'POTONGAN / DISKON PENJUALAN');
$objPHPExcel->getActiveSheet()->setCellValue('C8', $l3);
$objPHPExcel->getActiveSheet()->setCellValue('D8', '-');
$objPHPExcel->getActiveSheet()->getStyle('D8')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D8')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('C9', $sub1);
//Isi Data Harga Pokok Penjualan
$objPHPExcel->getActiveSheet()->setCellValue('A12', '1');
$objPHPExcel->getActiveSheet()->setCellValue('B12', 'PERSEDIAAN AWAL');
$objPHPExcel->getActiveSheet()->setCellValue('C12', $l4);
$objPHPExcel->getActiveSheet()->setCellValue('D12', '+');
$objPHPExcel->getActiveSheet()->getStyle('D12')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D12')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A13', '2');
$objPHPExcel->getActiveSheet()->setCellValue('B13', 'PEMBELIAN');
$objPHPExcel->getActiveSheet()->setCellValue('C13', $l5);
$objPHPExcel->getActiveSheet()->setCellValue('D13', '+');
$objPHPExcel->getActiveSheet()->getStyle('D13')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D13')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A14', '3');
$objPHPExcel->getActiveSheet()->setCellValue('B14', 'RETUR PEMBELIAN');
$objPHPExcel->getActiveSheet()->setCellValue('C14', $l6);
$objPHPExcel->getActiveSheet()->setCellValue('D14', '-');
$objPHPExcel->getActiveSheet()->getStyle('D14')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D14')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A15', '4');
$objPHPExcel->getActiveSheet()->setCellValue('B15', 'POT. PEMBELIAN');
$objPHPExcel->getActiveSheet()->setCellValue('C15', $l7);
$objPHPExcel->getActiveSheet()->setCellValue('D15', '-');
$objPHPExcel->getActiveSheet()->getStyle('D15')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D15')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('C16', $sub2);
$objPHPExcel->getActiveSheet()->setCellValue('A17', '5');
$objPHPExcel->getActiveSheet()->setCellValue('B17', 'PERSEDIAAN AKHIR');
$objPHPExcel->getActiveSheet()->setCellValue('C17', $l8);
$objPHPExcel->getActiveSheet()->setCellValue('D17', '-');
$objPHPExcel->getActiveSheet()->getStyle('D17')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D17')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('C18', $sub3);
//Isi Data Laba Kotor
$objPHPExcel->getActiveSheet()->setCellValue('C20', $sub4);
//Isi Data Biaya Penjualan
$objPHPExcel->getActiveSheet()->setCellValue('A24', '1');
$objPHPExcel->getActiveSheet()->setCellValue('B24', 'Biaya Operasional');
$objPHPExcel->getActiveSheet()->setCellValue('C24', $l9);
$objPHPExcel->getActiveSheet()->setCellValue('D24', '+');
$objPHPExcel->getActiveSheet()->getStyle('D24')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D24')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A25', '2');
$objPHPExcel->getActiveSheet()->setCellValue('B25', 'Biaya Pengiriman');
$objPHPExcel->getActiveSheet()->setCellValue('C25', $l10);
$objPHPExcel->getActiveSheet()->setCellValue('D25', '+');
$objPHPExcel->getActiveSheet()->getStyle('D25')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D25')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A26', '3');
$objPHPExcel->getActiveSheet()->setCellValue('B26', 'Biaya Service Kendaraan');
$objPHPExcel->getActiveSheet()->setCellValue('C26', $l11);
$objPHPExcel->getActiveSheet()->setCellValue('D26', '+');
$objPHPExcel->getActiveSheet()->getStyle('D26')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D26')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A27', '4');
$objPHPExcel->getActiveSheet()->setCellValue('B27', 'Biaya Bensin');
$objPHPExcel->getActiveSheet()->setCellValue('C27', $l12);
$objPHPExcel->getActiveSheet()->setCellValue('D27', '+');
$objPHPExcel->getActiveSheet()->getStyle('D27')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D27')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A28', '5');
$objPHPExcel->getActiveSheet()->setCellValue('B28', 'Biaya Parkir Umum');
$objPHPExcel->getActiveSheet()->setCellValue('C28', $l13);
$objPHPExcel->getActiveSheet()->setCellValue('D28', '+');
$objPHPExcel->getActiveSheet()->getStyle('D28')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D28')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A29', '6');
$objPHPExcel->getActiveSheet()->setCellValue('B29', 'Biaya Sparepart');
$objPHPExcel->getActiveSheet()->setCellValue('C29', $l14);
$objPHPExcel->getActiveSheet()->setCellValue('D29', '+');
$objPHPExcel->getActiveSheet()->getStyle('D29')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D29')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A30', '7');
$objPHPExcel->getActiveSheet()->setCellValue('B30', 'Biaya Kebutuhan Service');
$objPHPExcel->getActiveSheet()->setCellValue('C30', $l15);
$objPHPExcel->getActiveSheet()->setCellValue('D30', '+');
$objPHPExcel->getActiveSheet()->getStyle('D30')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D30')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('C31', $sub5);
//Isi Data Biaya Umum dan Administrasi
$objPHPExcel->getActiveSheet()->setCellValue('A34', '1');
$objPHPExcel->getActiveSheet()->setCellValue('B34', 'Biaya Gaji/THR');
$objPHPExcel->getActiveSheet()->setCellValue('C34', $l16);
$objPHPExcel->getActiveSheet()->setCellValue('D34', '+');
$objPHPExcel->getActiveSheet()->getStyle('D34')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D34')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A35', '2');
$objPHPExcel->getActiveSheet()->setCellValue('B35', 'Biaya Pajak PPh Psl 21');
$objPHPExcel->getActiveSheet()->setCellValue('C35', $l17);
$objPHPExcel->getActiveSheet()->setCellValue('D35', '+');
$objPHPExcel->getActiveSheet()->getStyle('D35')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D35')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A36', '3');
$objPHPExcel->getActiveSheet()->setCellValue('B36', 'Biaya Incentive');
$objPHPExcel->getActiveSheet()->setCellValue('C36', $l18);
$objPHPExcel->getActiveSheet()->setCellValue('D36', '+');
$objPHPExcel->getActiveSheet()->getStyle('D36')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D36')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A37', '4');
$objPHPExcel->getActiveSheet()->setCellValue('B37', 'Biaya PLN');
$objPHPExcel->getActiveSheet()->setCellValue('C37', $l19);
$objPHPExcel->getActiveSheet()->setCellValue('D37', '+');
$objPHPExcel->getActiveSheet()->getStyle('D37')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D37')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A38', '5');
$objPHPExcel->getActiveSheet()->setCellValue('B38', 'Biaya Telepon');
$objPHPExcel->getActiveSheet()->setCellValue('C38', $l20);
$objPHPExcel->getActiveSheet()->setCellValue('D38', '+');
$objPHPExcel->getActiveSheet()->getStyle('D38')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D38')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A39', '6');
$objPHPExcel->getActiveSheet()->setCellValue('B39', 'Biaya Internet');
$objPHPExcel->getActiveSheet()->setCellValue('C39', $l21);
$objPHPExcel->getActiveSheet()->setCellValue('D39', '+');
$objPHPExcel->getActiveSheet()->getStyle('D39')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D39')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A40', '7');
$objPHPExcel->getActiveSheet()->setCellValue('B40', 'Biaya PDAM');
$objPHPExcel->getActiveSheet()->setCellValue('C40', $l22);
$objPHPExcel->getActiveSheet()->setCellValue('D40', '+');
$objPHPExcel->getActiveSheet()->getStyle('D40')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D40')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A41', '8');
$objPHPExcel->getActiveSheet()->setCellValue('B41', 'Biaya Serv Charge Mangga Dua');
$objPHPExcel->getActiveSheet()->setCellValue('C41', $l23);
$objPHPExcel->getActiveSheet()->setCellValue('D41', '+');
$objPHPExcel->getActiveSheet()->getStyle('D41')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D41')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A42', '9');
$objPHPExcel->getActiveSheet()->setCellValue('B42', 'Biaya Parkir Kary Mangga Dua');
$objPHPExcel->getActiveSheet()->setCellValue('C42', $l24);
$objPHPExcel->getActiveSheet()->setCellValue('D42', '+');
$objPHPExcel->getActiveSheet()->getStyle('D42')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D42')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A43', '10');
$objPHPExcel->getActiveSheet()->setCellValue('B43', 'Biaya Serv Charge ITC');
$objPHPExcel->getActiveSheet()->setCellValue('C43', $l58);
$objPHPExcel->getActiveSheet()->setCellValue('D43', '+');
$objPHPExcel->getActiveSheet()->getStyle('D43')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D43')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A44', '11');
$objPHPExcel->getActiveSheet()->setCellValue('B44', 'Biaya Parkir Kary ITC');
$objPHPExcel->getActiveSheet()->setCellValue('C44', $l59);
$objPHPExcel->getActiveSheet()->setCellValue('D44', '+');
$objPHPExcel->getActiveSheet()->getStyle('D44')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D44')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A45', '12');
$objPHPExcel->getActiveSheet()->setCellValue('B45', 'Biaya Konsultan Pajak');
$objPHPExcel->getActiveSheet()->setCellValue('C45', $l25);
$objPHPExcel->getActiveSheet()->setCellValue('D45', '+');
$objPHPExcel->getActiveSheet()->getStyle('D45')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D45')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A46', '13');
$objPHPExcel->getActiveSheet()->setCellValue('B46', 'Biaya ATK');
$objPHPExcel->getActiveSheet()->setCellValue('C46', $l26);
$objPHPExcel->getActiveSheet()->setCellValue('D46', '+');
$objPHPExcel->getActiveSheet()->getStyle('D46')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D46')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A47', '14');
$objPHPExcel->getActiveSheet()->setCellValue('B47', 'Biaya Materai');
$objPHPExcel->getActiveSheet()->setCellValue('C47', $l27);
$objPHPExcel->getActiveSheet()->setCellValue('D47', '+');
$objPHPExcel->getActiveSheet()->getStyle('D47')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D47')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A48', '15');
$objPHPExcel->getActiveSheet()->setCellValue('B48', 'Biaya Fotocopy');
$objPHPExcel->getActiveSheet()->setCellValue('C48', $l28);
$objPHPExcel->getActiveSheet()->setCellValue('D48', '+');
$objPHPExcel->getActiveSheet()->getStyle('D48')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D48')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A49', '16');
$objPHPExcel->getActiveSheet()->setCellValue('B49', 'Biaya Majalah Komputer, Buku, Dll');
$objPHPExcel->getActiveSheet()->setCellValue('C49', $l29);
$objPHPExcel->getActiveSheet()->setCellValue('D49', '+');
$objPHPExcel->getActiveSheet()->getStyle('D49')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D49')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A50', '17');
$objPHPExcel->getActiveSheet()->setCellValue('B50', 'Biaya Cetak (Stempel, Kartu Nm, Kertas Kont B55dll)');
$objPHPExcel->getActiveSheet()->setCellValue('C50', $l30);
$objPHPExcel->getActiveSheet()->setCellValue('D50', '+');
$objPHPExcel->getActiveSheet()->getStyle('D50')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D50')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A51', '18');
$objPHPExcel->getActiveSheet()->setCellValue('B51', 'Biaya Surat Referensi, Jaminan, dll');
$objPHPExcel->getActiveSheet()->setCellValue('C51', $l31);
$objPHPExcel->getActiveSheet()->setCellValue('D51', '+');
$objPHPExcel->getActiveSheet()->getStyle('D51')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D51')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A52', '19');
$objPHPExcel->getActiveSheet()->setCellValue('B52', 'Biaya Kebutuhan Kantor');
$objPHPExcel->getActiveSheet()->setCellValue('C52', $l32);
$objPHPExcel->getActiveSheet()->setCellValue('D52', '+');
$objPHPExcel->getActiveSheet()->getStyle('D52')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D52')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A53', '20');
$objPHPExcel->getActiveSheet()->setCellValue('B53', 'Biaya Service Luar');
$objPHPExcel->getActiveSheet()->setCellValue('C53', $l33);
$objPHPExcel->getActiveSheet()->setCellValue('D53', '+');
$objPHPExcel->getActiveSheet()->getStyle('D53')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D53')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A54', '21');
$objPHPExcel->getActiveSheet()->setCellValue('B54', 'Biaya Tol');
$objPHPExcel->getActiveSheet()->setCellValue('C54', $l34);
$objPHPExcel->getActiveSheet()->setCellValue('D54', '+');
$objPHPExcel->getActiveSheet()->getStyle('D54')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D54')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A55', '22');
$objPHPExcel->getActiveSheet()->setCellValue('B55', 'Biaya Service AC');
$objPHPExcel->getActiveSheet()->setCellValue('C55', $l35);
$objPHPExcel->getActiveSheet()->setCellValue('D55', '+');
$objPHPExcel->getActiveSheet()->getStyle('D55')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D55')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A56', '23');
$objPHPExcel->getActiveSheet()->setCellValue('B56', 'Biaya Pajak Kendaraan');
$objPHPExcel->getActiveSheet()->setCellValue('C56', $l36);
$objPHPExcel->getActiveSheet()->setCellValue('D56', '+');
$objPHPExcel->getActiveSheet()->getStyle('D56')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D56')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A57', '24');
$objPHPExcel->getActiveSheet()->setCellValue('B57', 'Biaya Sumbangan dll');
$objPHPExcel->getActiveSheet()->setCellValue('C57', $l37);
$objPHPExcel->getActiveSheet()->setCellValue('D57', '+');
$objPHPExcel->getActiveSheet()->getStyle('D57')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D57')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A58', '25');
$objPHPExcel->getActiveSheet()->setCellValue('B58', 'Biaya Entertain');
$objPHPExcel->getActiveSheet()->setCellValue('C58', $l38);
$objPHPExcel->getActiveSheet()->setCellValue('D58', '+');
$objPHPExcel->getActiveSheet()->getStyle('D58')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D58')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A59', '26');
$objPHPExcel->getActiveSheet()->setCellValue('B59', 'Biaya BPJS');
$objPHPExcel->getActiveSheet()->setCellValue('C59', $l39);
$objPHPExcel->getActiveSheet()->setCellValue('D59', '+');
$objPHPExcel->getActiveSheet()->getStyle('D59')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D59')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A60', '27');
$objPHPExcel->getActiveSheet()->setCellValue('B60', 'Biaya Ass Karyawan & Ass Lainnya');
$objPHPExcel->getActiveSheet()->setCellValue('C60', $l40);
$objPHPExcel->getActiveSheet()->setCellValue('D60', '+');
$objPHPExcel->getActiveSheet()->getStyle('D60')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D60')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A61', '28');
$objPHPExcel->getActiveSheet()->setCellValue('B61', 'Biaya Training, Seminar dll');
$objPHPExcel->getActiveSheet()->setCellValue('C61', $l41);
$objPHPExcel->getActiveSheet()->setCellValue('D61', '+');
$objPHPExcel->getActiveSheet()->getStyle('D61')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D61')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A62', '29');
$objPHPExcel->getActiveSheet()->setCellValue('B62', 'Biaya Fee');
$objPHPExcel->getActiveSheet()->setCellValue('C62', $l42);
$objPHPExcel->getActiveSheet()->setCellValue('D62', '+');
$objPHPExcel->getActiveSheet()->getStyle('D62')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D62')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A63', '30');
$objPHPExcel->getActiveSheet()->setCellValue('B63', 'Biaya Dinas Luar');
$objPHPExcel->getActiveSheet()->setCellValue('C63', $l43);
$objPHPExcel->getActiveSheet()->setCellValue('D63', '+');
$objPHPExcel->getActiveSheet()->getStyle('D63')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D63')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A64', '31');
$objPHPExcel->getActiveSheet()->setCellValue('B64', 'Biaya Pajak PPh Psl 25 P Sgg & P Agoes dll');
$objPHPExcel->getActiveSheet()->setCellValue('C64', $l44);
$objPHPExcel->getActiveSheet()->setCellValue('D64', '+');
$objPHPExcel->getActiveSheet()->getStyle('D64')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D64')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A65', '32');
$objPHPExcel->getActiveSheet()->setCellValue('B65', 'Biaya Penyusutan');
$objPHPExcel->getActiveSheet()->setCellValue('C65', $l45);
$objPHPExcel->getActiveSheet()->setCellValue('D65', '+');
$objPHPExcel->getActiveSheet()->getStyle('D65')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D65')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A66', '33');
$objPHPExcel->getActiveSheet()->setCellValue('B66', 'Biaya Kegiatan Karyawan / Futsal dll');
$objPHPExcel->getActiveSheet()->setCellValue('C66', $l46);
$objPHPExcel->getActiveSheet()->setCellValue('D66', '+');
$objPHPExcel->getActiveSheet()->getStyle('D66')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D66')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A67', '34');
$objPHPExcel->getActiveSheet()->setCellValue('B67', 'Biaya Rekreasi Karyawan Kantor');
$objPHPExcel->getActiveSheet()->setCellValue('C67', $l47);
$objPHPExcel->getActiveSheet()->setCellValue('D67', '+');
$objPHPExcel->getActiveSheet()->getStyle('D67')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D67')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A68', '35');
$objPHPExcel->getActiveSheet()->setCellValue('B68', 'Biaya Pengeluaran Project / Cabling');
$objPHPExcel->getActiveSheet()->setCellValue('C68', $l48);
$objPHPExcel->getActiveSheet()->setCellValue('D68', '+');
$objPHPExcel->getActiveSheet()->getStyle('D68')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D68')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A69', '36');
$objPHPExcel->getActiveSheet()->setCellValue('B69', 'Biaya Bunga Kredit');
$objPHPExcel->getActiveSheet()->setCellValue('C69', $l49);
$objPHPExcel->getActiveSheet()->setCellValue('D69', '+');
$objPHPExcel->getActiveSheet()->getStyle('D69')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D69')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A70', '37');
$objPHPExcel->getActiveSheet()->setCellValue('B70', 'Biaya Kredit Bank');
$objPHPExcel->getActiveSheet()->setCellValue('C70', $l50);
$objPHPExcel->getActiveSheet()->setCellValue('D70', '+');
$objPHPExcel->getActiveSheet()->getStyle('D70')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D70')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A71', '38');
$objPHPExcel->getActiveSheet()->setCellValue('B71', 'Biaya Perawatan / Perbaikan Gedung');
$objPHPExcel->getActiveSheet()->setCellValue('C71', $l51);
$objPHPExcel->getActiveSheet()->setCellValue('D71', '+');
$objPHPExcel->getActiveSheet()->getStyle('D71')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D71')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A72', '39');
$objPHPExcel->getActiveSheet()->setCellValue('B72', 'Biaya Listrik ITC');
$objPHPExcel->getActiveSheet()->setCellValue('C72', $l60);
$objPHPExcel->getActiveSheet()->setCellValue('D72', '+');
$objPHPExcel->getActiveSheet()->getStyle('D72')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D72')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A73', '40');
$objPHPExcel->getActiveSheet()->setCellValue('B73', 'Biaya Sewa Stand');
$objPHPExcel->getActiveSheet()->setCellValue('C73', $l61);
$objPHPExcel->getActiveSheet()->setCellValue('D73', '+');
$objPHPExcel->getActiveSheet()->getStyle('D73')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D73')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A74', '41');
$objPHPExcel->getActiveSheet()->setCellValue('B74', 'Biaya Pajak Lainnya');
$objPHPExcel->getActiveSheet()->setCellValue('C74', $l62);
$objPHPExcel->getActiveSheet()->setCellValue('D74', '+');
$objPHPExcel->getActiveSheet()->getStyle('D74')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D74')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A75', '42');
$objPHPExcel->getActiveSheet()->setCellValue('B75', 'Biaya Lain Lain');
$objPHPExcel->getActiveSheet()->setCellValue('C75', $l52);
$objPHPExcel->getActiveSheet()->setCellValue('D75', '+');
$objPHPExcel->getActiveSheet()->getStyle('D75')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D75')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('C76', $sub6);
//Isi Data Total Biaya
$objPHPExcel->getActiveSheet()->setCellValue('C78', $sub7);
//Isi Data Laba Usaha
$objPHPExcel->getActiveSheet()->setCellValue('C81', $sub8);
//Isi Data Pendapatan Dan (Beban) Luar Usaha
$objPHPExcel->getActiveSheet()->setCellValue('A85', '1');
$objPHPExcel->getActiveSheet()->setCellValue('B85', 'Pendapatan Diluar Usaha');
$objPHPExcel->getActiveSheet()->setCellValue('C85', $l53);
$objPHPExcel->getActiveSheet()->setCellValue('D85', '+');
$objPHPExcel->getActiveSheet()->getStyle('D85')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D85')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A86', '2');
$objPHPExcel->getActiveSheet()->setCellValue('B86', 'Pendapatan Jasa Giro');
$objPHPExcel->getActiveSheet()->setCellValue('C86', $l54);
$objPHPExcel->getActiveSheet()->setCellValue('D86', '+');
$objPHPExcel->getActiveSheet()->getStyle('D86')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D86')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('C87', $sub9);
$objPHPExcel->getActiveSheet()->setCellValue('A88', '3');
$objPHPExcel->getActiveSheet()->setCellValue('B88', 'Beban Admin Bank');
$objPHPExcel->getActiveSheet()->setCellValue('C88', $l55);
$objPHPExcel->getActiveSheet()->setCellValue('D88', '+');
$objPHPExcel->getActiveSheet()->getStyle('D88')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D88')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('A89', '4');
$objPHPExcel->getActiveSheet()->setCellValue('B89', 'Beban Pajak Giro');
$objPHPExcel->getActiveSheet()->setCellValue('C89', $l56);
$objPHPExcel->getActiveSheet()->setCellValue('D89', '+');
$objPHPExcel->getActiveSheet()->getStyle('D89')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D89')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('C90', $sub10);
//Isi Data Total Pendapatan Dan (Beban) Luar Usaha
$objPHPExcel->getActiveSheet()->setCellValue('C92', $sub11);
//Isi Data Laba Bersih Sebelum Pajak
$objPHPExcel->getActiveSheet()->setCellValue('C95', $sub12);
$objPHPExcel->getActiveSheet()->setCellValue('A99', '1');
$objPHPExcel->getActiveSheet()->setCellValue('B99', 'Pajak Penghasilan');
$objPHPExcel->getActiveSheet()->setCellValue('C99', $l57);
$objPHPExcel->getActiveSheet()->setCellValue('D99', '+');
$objPHPExcel->getActiveSheet()->getStyle('D99')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->getStyle('D99')->getFont()->setBold(true);
//Isi Data Laba Bersih Setelah Pajak
$objPHPExcel->getActiveSheet()->setCellValue('C100', $sub12);
$filename = "Laporan LabaRugi " . $judul . '.xlsx';
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="' . $filename . '"');
header('Cache-Control: max-age=0');
$writer = PHPExcel_IOFactory::createwriter($objPHPExcel, 'Excel2007');
$writer->save('php://output');
exit();
Reference in New Issue View Git Blame Copy Permalink