Code Context }
if ($quota['quota']['quota_person'] != 0)
$viewFile = '/home/store3/public/www3.bukabuku.com/app/View/Browses/product_book.ctp'
$dataForView = array(
'browse_view' => 'grid',
'system' => array(
'store' => array(
'id' => '3',
'name' => 'Bukabuku.com',
'name_label' => 'Bukabuku.com',
'url' => 'www.bukabuku.com',
'email_name' => 'Bukabuku.com',
'key' => '83be148a0563b4bebcb391917485dcc2',
'logo' => 'logo.gif',
'email_order' => 'cs@bukabuku.com',
'email_order_amazon' => 'cs@emails.bukabuku.com',
'address1' => 'Ruko Cempaka Mas Blok M/50',
'address2' => 'Jln. Letjen Suprapto',
'address3' => 'Jakarta Pusat',
'zip' => '10640',
'phone1' => '0896-7269-1122',
'phone2' => '',
'show_language_picker' => 'no',
'show_department_picker' => 'no',
'maintenance_mode' => 'no',
'readonly_mode' => 'no',
'show_banners' => 'yes',
'show_top_20' => 'yes',
'social_media_login' => 'yes',
'email_partnership' => 'partnership@bukabuku.com',
'allow_cod' => 'yes',
'sphinx_host' => 'sphinx2.bukabuku.net',
'sphinx_product_index_local' => 'product_bukabuku',
'sphinx_product_index' => 'product_bukabuku_rt'
),
'cart_content' => array(
'products' => array([maximum depth reached]),
'count' => (int) 0
),
'language' => array(
'ind' => 'Indonesia'
),
'depts' => array(
'all' => 'Semua Departemen',
'book' => 'Books'
),
'store_depts' => array(
(int) 0 => array(
[maximum depth reached]
)
),
'menu_categories' => array(
'Books' => array(
[maximum depth reached]
)
),
'wishlists' => array()
),
'show_edit' => false,
'products_by_author' => array(
(int) 0 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 1 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 2 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 3 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 4 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 5 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 6 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 7 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 8 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 9 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 10 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 11 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 12 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 13 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 14 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 15 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 16 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 17 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 18 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 19 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 20 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 21 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 22 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 23 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 24 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 25 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 26 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 27 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 28 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 29 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 30 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 31 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 32 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 33 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 34 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 35 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 36 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 37 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
),
(int) 38 => array(
'SearchCache' => array(
[maximum depth reached]
),
'BrandRule' => array(
[maximum depth reached]
),
'ProductRank' => array(
[maximum depth reached]
),
'Category' => array(
[maximum depth reached]
),
'SearchCacheDetail' => array(
[maximum depth reached]
)
)
),
'current_author' => array(
'People' => array(
'id' => '91779',
'name' => 'Yudhy Wicaksono & Solusi Kantor',
'description' => null,
'email' => null,
'website' => null,
'facebook' => null,
'twitter' => null,
'instagram' => null,
'google+' => null
),
'PeopleImage' => array()
),
'products_bought_relation' => array(),
'availability' => array(
'text' => 'Stock di Gudang Supplier',
'color' => 'product_status_orange',
'qty' => '0'
),
'promo_combined' => array(),
'result' => array(
'ProductBook' => array(
'id' => '2010001335467',
'EAN' => '9786230048319',
'code' => null,
'name' => 'Panduan Lengkap Formula dan Fungsi Excel 2007, 2010, 2013, 2016, 2019 untuk Pemula',
'subname' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'brand_discount_id' => null,
'dimension_x' => '140',
'dimension_y' => '210',
'dimension_z' => '0',
'shipping_weight' => '400',
'weight_flag' => 'brand',
'price' => '140000',
'price_dollar' => '140000',
'currency' => null,
'description' => '-',
'eol' => 'no',
'product_group_id' => null,
'department_id' => '0',
'review_rating' => '0',
'review_count' => '0',
'review_count_1' => '0',
'review_count_2' => '0',
'review_count_3' => '0',
'review_count_4' => '0',
'review_count_5' => '0',
'sold' => '0',
'status' => 'active',
'isbn' => null,
'isbn13' => '9786230048319',
'date_release' => '14 Juni 2023',
'date_available' => '0000-00-00',
'serie_id' => '0',
'serie' => null,
'edition' => null,
'pages' => null,
'tax' => 'include',
'status_available' => 'normal',
'redirect_ean' => null,
'data_source' => null,
'data_source_id' => null,
'data_source_updated' => null,
'created' => '2023-06-18 09:03:37',
'modified' => null,
'price_discount' => (int) 112000,
'discount_percent' => '20',
'dimension' => '140 mm x 210 mm'
),
'Brand' => array(
'id' => '21',
'name' => 'Elex Media Komputindo',
'name_web' => 'Elex Media Komputindo',
'website' => '',
'phone' => '',
'fax' => '',
'email' => '',
'facebook' => '',
'twitter' => '',
'cash_status' => null,
'cash_value' => null,
'credit_status' => null,
'credit_value' => null,
'consign_status' => null,
'consign_value' => null,
'status' => 'active',
'created' => '2014-04-16 17:55:16',
'modified' => '2014-04-16 17:55:19',
'department_id' => '1'
),
'SearchCache' => array(
'id' => '1177076',
'product_id' => '2010001335467',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Panduan Lengkap Formula dan Fungsi Excel 2007, 2010, 2013, 2016, 2019 untuk Pemula',
'subname' => null,
'edition' => null,
'date_release' => '2023-06-14',
'date_calc' => '0000-00-00',
'date_available' => '0000-00-00',
'ean' => '9786230048319',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => null,
'code_x1' => null,
'code_x2' => '9786230048319',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '140000',
'price_max' => '0',
'price_dollar' => '140000',
'currency' => null,
'rating' => '0',
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => '85ad53c15c5cf3b62ab987c1108a8798.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '140',
'dimension_y' => '210',
'dimension_z' => null,
'weight' => '400',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'normal',
'tax' => 'include',
'description_small' => '- ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => null,
'created' => '2023-06-18 09:03:37',
'modified' => null,
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no'
),
'ProductCategory' => array(
(int) 0 => array(
[maximum depth reached]
)
),
'ProductImage' => array(
(int) 0 => array(
[maximum depth reached]
)
),
'Detail' => array(
'author' => array(
[maximum depth reached]
),
'language' => array(
[maximum depth reached]
),
'format' => array(
[maximum depth reached]
)
)
),
'rating' => array(
'count' => (int) 0,
'rating' => (int) 0,
'count1' => (int) 0,
'count2' => (int) 0,
'count3' => (int) 0,
'count4' => (int) 0,
'count5' => (int) 0
),
'reviews' => array(),
'first_image' => array(
'id' => '846324',
'l1' => '8',
'l2' => '5',
'image' => '85ad53c15c5cf3b62ab987c1108a8798.jpg'
),
'promo' => array(),
'unavailable' => false,
'meta' => array(
'description' => 'Panduan Lengkap Formula dan Fungsi Excel 2007, 2010, 2013, 2016, 2019 untuk Pemula - Oleh: Yudhy Wicaksono & Solusi Kantor - -',
'og:title' => 'Panduan Lengkap Formula dan Fungsi Excel 2007, 2010, 2013, 2016, 2019 untuk Pemula - Oleh: Yudhy Wicaksono & Solusi Kantor',
'og:type' => 'book',
'og:image' => 'https://img.bukabuku.net/product/8/5/85ad53c15c5cf3b62ab987c1108a8798.jpg',
'og:url' => 'https://www.bukabuku.com/browses/product/9786230048319/panduan-lengkap-formula-dan-fungsi-excel-2007-2010-2013-2016-2019-untuk-pemula.html',
'og:description' => '-',
'twitter:title' => 'Panduan Lengkap Formula dan Fungsi Excel 2007, 2010, 2013, 2016, 2019 untuk Pemula - Oleh: Yudhy Wicaksono & Solusi Kantor',
'twitter:description' => '-',
'twitter:image' => 'https://img.bukabuku.net/product/8/5/85ad53c15c5cf3b62ab987c1108a8798.jpg'
),
'title_for_layout' => 'Panduan Lengkap Formula dan Fungsi Excel 2007, 2010, 2013, 2016, 2019 untuk Pemula - BukaBuku.com - Toko Buku Online',
'url' => 'browses/product/9786230048319/panduan-lengkap-formula-dan-fungsi-excel-2007-2010-2013-2016-2019-untuk-pemula.html'
)
$browse_view = 'grid'
$system = array(
'store' => array(
'id' => '3',
'name' => 'Bukabuku.com',
'name_label' => 'Bukabuku.com',
'url' => 'www.bukabuku.com',
'email_name' => 'Bukabuku.com',
'key' => '83be148a0563b4bebcb391917485dcc2',
'logo' => 'logo.gif',
'email_order' => 'cs@bukabuku.com',
'email_order_amazon' => 'cs@emails.bukabuku.com',
'address1' => 'Ruko Cempaka Mas Blok M/50',
'address2' => 'Jln. Letjen Suprapto',
'address3' => 'Jakarta Pusat',
'zip' => '10640',
'phone1' => '0896-7269-1122',
'phone2' => '',
'show_language_picker' => 'no',
'show_department_picker' => 'no',
'maintenance_mode' => 'no',
'readonly_mode' => 'no',
'show_banners' => 'yes',
'show_top_20' => 'yes',
'social_media_login' => 'yes',
'email_partnership' => 'partnership@bukabuku.com',
'allow_cod' => 'yes',
'sphinx_host' => 'sphinx2.bukabuku.net',
'sphinx_product_index_local' => 'product_bukabuku',
'sphinx_product_index' => 'product_bukabuku_rt'
),
'cart_content' => array(
'products' => array(),
'count' => (int) 0
),
'language' => array(
'ind' => 'Indonesia'
),
'depts' => array(
'all' => 'Semua Departemen',
'book' => 'Books'
),
'store_depts' => array(
(int) 0 => array(
'Department' => array(
[maximum depth reached]
),
'Store' => array([maximum depth reached])
)
),
'menu_categories' => array(
'Books' => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
),
(int) 4 => array(
[maximum depth reached]
),
(int) 5 => array(
[maximum depth reached]
),
(int) 6 => array(
[maximum depth reached]
),
(int) 7 => array(
[maximum depth reached]
),
(int) 8 => array(
[maximum depth reached]
),
(int) 9 => array(
[maximum depth reached]
),
(int) 10 => array(
[maximum depth reached]
),
(int) 11 => array(
[maximum depth reached]
),
(int) 12 => array(
[maximum depth reached]
),
(int) 13 => array(
[maximum depth reached]
),
(int) 14 => array(
[maximum depth reached]
),
(int) 15 => array(
[maximum depth reached]
),
(int) 16 => array(
[maximum depth reached]
),
(int) 17 => array(
[maximum depth reached]
),
(int) 18 => array(
[maximum depth reached]
),
(int) 19 => array(
[maximum depth reached]
),
(int) 20 => array(
[maximum depth reached]
),
(int) 21 => array(
[maximum depth reached]
),
(int) 22 => array(
[maximum depth reached]
),
(int) 23 => array(
[maximum depth reached]
),
(int) 24 => array(
[maximum depth reached]
),
(int) 25 => array(
[maximum depth reached]
),
(int) 26 => array(
[maximum depth reached]
),
(int) 27 => array(
[maximum depth reached]
),
(int) 28 => array(
[maximum depth reached]
),
(int) 29 => array(
[maximum depth reached]
),
(int) 30 => array(
[maximum depth reached]
),
(int) 31 => array(
[maximum depth reached]
),
(int) 32 => array(
[maximum depth reached]
),
(int) 33 => array(
[maximum depth reached]
),
(int) 34 => array(
[maximum depth reached]
),
(int) 35 => array(
[maximum depth reached]
),
(int) 36 => array(
[maximum depth reached]
),
(int) 37 => array(
[maximum depth reached]
),
(int) 38 => array(
[maximum depth reached]
),
(int) 39 => array(
[maximum depth reached]
),
(int) 40 => array(
[maximum depth reached]
),
(int) 41 => array(
[maximum depth reached]
),
(int) 42 => array(
[maximum depth reached]
),
(int) 43 => array(
[maximum depth reached]
),
(int) 44 => array(
[maximum depth reached]
),
(int) 45 => array(
[maximum depth reached]
),
(int) 46 => array(
[maximum depth reached]
)
)
),
'wishlists' => array()
)
$show_edit = false
$products_by_author = array(
(int) 0 => array(
'SearchCache' => array(
'id' => '1183713',
'product_id' => '2010001401841',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Belajar Sendiri Menjadi Programmer Excel',
'subname' => null,
'edition' => null,
'date_release' => 'September 2024',
'date_calc' => '0000-00-00',
'date_available' => '0000-00-00',
'ean' => '9786230060724',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => '',
'string_x3' => null,
'code' => '724050651',
'code_x1' => null,
'code_x2' => '9786230060724',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '145000',
'price_max' => '0',
'price_dollar' => '145000',
'currency' => null,
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => '39243059070798215509d42714a59e46.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '210',
'dimension_y' => '140',
'dimension_z' => null,
'weight' => '500',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'normal',
'tax' => 'include',
'description_small' => 'Ingin pekerjaan rutin yang membosankan menjadi lebih mudah dan cepat? Pemrograman Excel hadir untuk mengotomatisasi pekerjaan rutin yang dilakukan secara berulang-ulang sehingga Anda bisa menghemat waktu, tenaga, dan meningkatkan produktivitas. Bahkan jika Anda sudah ahli dalam Excel, tanpa otomatisasi, pekerjaan manual akan tetap menyita banyak waktu dan energi.
Buku "Belajar Sendiri Menjadi Programmer Excel" dirancang untuk membantu Anda menguasai pemrograman Excel secara mandiri. Dengan ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => null,
'created' => '2024-09-24 23:03:46',
'modified' => null,
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '145000',
'price_discount' => (int) 116000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1581328',
'search_cache_id' => '1183713',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2024-09-24 23:03:46',
'modified' => null
)
),
(int) 1 => array(
'SearchCache' => array(
'id' => '1182253',
'product_id' => '2010001387169',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Panduan Lengkap Office 2007, 2010, 2013, 2016, 2019, 2021 untuk Pemula',
'subname' => null,
'edition' => null,
'date_release' => 'Maret 2024',
'date_calc' => '0000-00-00',
'date_available' => '0000-00-00',
'ean' => '9786230057786',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '724050270',
'code_x1' => null,
'code_x2' => '9786230057786',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '149000',
'price_max' => '0',
'price_dollar' => '149000',
'currency' => null,
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => 'dfe6f0dcb61a0d1e0cbd3741b4d39837.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '140',
'dimension_y' => '210',
'dimension_z' => null,
'weight' => '250',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'normal',
'tax' => 'include',
'description_small' => 'Hampir semua pekerjaan menggunakan Microsoft Office terutama aplikasi Office Word, Excel, dan PowerPoint untuk membuat laporan, proposal, analisis perhitungan, pengolahan data, presentasi dan banyak pekerjaan lainnya. Ketiga aplikasi tersebut dapat menyelesaikan berbagai macam tugas di sekolah, instansi pemerintahan, UMKM, organisasi nirlaba maupun korporasi besar. Menguasai Word, Excel, dan PowerPoint merupakan kunci sukses bagi siapa pun, karena dengan menguasai Word, Excel, dan PowerPoint ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => null,
'created' => '2024-04-06 23:04:18',
'modified' => null,
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '149000',
'price_discount' => (int) 119200,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1575499',
'search_cache_id' => '1182253',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2024-04-06 23:04:18',
'modified' => null
)
),
(int) 2 => array(
'SearchCache' => array(
'id' => '1182032',
'product_id' => '2010001384953',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Mengungkap Kedahsyatan 300+ Rumus Excel untuk Pemula',
'subname' => null,
'edition' => null,
'date_release' => 'Maret 2024',
'date_calc' => '0000-00-00',
'date_available' => '0000-00-00',
'ean' => '9786230057182',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '724050190',
'code_x1' => null,
'code_x2' => '9786230057182',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '105000',
'price_max' => '0',
'price_dollar' => '105000',
'currency' => null,
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => '840e88d5273792c1f2cbd1d823b31676.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '140',
'dimension_y' => '210',
'dimension_z' => null,
'weight' => '250',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'normal',
'tax' => 'include',
'description_small' => 'Salah satu kunci sukses untuk menguasai Excel adalah kemampuan dalam menggunakan rumus Excel secara efektif, efisien, dan profesional. Jika Anda menguasai kemampuan tersebut, pekerjaan Anda sehari-hari tentu dapat diselesaikan dengan mudah dan cepat. Buku ini membahas secara lengkap penggunaan rumus Excel dalam dunia bisnis, pendidikan, dan perkantoran sehari-hari. Pembahasan buku yang lebih mengedepankan praktik dibandingkan teori menjadikan buku ini cocok digunakan oleh siapa saja, baik Anda ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => null,
'created' => '2024-03-09 23:02:31',
'modified' => null,
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '105000',
'price_discount' => (int) 84000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1574609',
'search_cache_id' => '1182032',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2024-03-09 23:02:31',
'modified' => null
)
),
(int) 3 => array(
'SearchCache' => array(
'id' => '1179253',
'product_id' => '2010001357261',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Mengeksplorasi Fungsi Vlookup, Hlookup, Lookup, Dan Xlookup',
'subname' => null,
'edition' => null,
'date_release' => 'Oktober 2023',
'date_calc' => '0000-00-00',
'date_available' => '0000-00-00',
'ean' => '9786230050565',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => null,
'code_x1' => null,
'code_x2' => '9786230050565',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '88000',
'price_max' => '0',
'price_dollar' => '88000',
'currency' => null,
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => 'c90565072674fd2385f6e0a07d6e7a0b.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '140',
'dimension_y' => '210',
'dimension_z' => null,
'weight' => '250',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'normal',
'tax' => 'include',
'description_small' => 'Fungsi VLOOKUP, HLOOKUP, LOOKUP, dan XLOOKUP merupakan fungsi Excel yang sangat membantu dalam pengolahan data. Namun kemampuan keempat fungsi ini tidak tereksplorasi secara optimal karena kerumitannya. Mulai saat ini, buang jauh-jauh kesan bahwa fungsi VLOOKUP, HLOOKUP, LOOKUP, dan XLOOKUP sulit dipahami. Pelajari buku ini dan penulis menjamin pembaca akan dengan cepat menguasainya! Buku ini adalah buku terlengkap yang mengupas penggunaan fungsi VLOOKUP, HLOOKUP, LOOKUP, dan XLOOKUP. ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => null,
'created' => '2023-10-19 09:03:07',
'modified' => null,
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '88000',
'price_discount' => (int) 70400,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1563641',
'search_cache_id' => '1179253',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2023-10-19 09:03:08',
'modified' => null
)
),
(int) 4 => array(
'SearchCache' => array(
'id' => '1184406',
'product_id' => '2010001408864',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Panduan Lengkap Menggunakan Excel Android untuk Pemula',
'subname' => null,
'edition' => null,
'date_release' => 'November 2024',
'date_calc' => '0000-00-00',
'date_available' => '0000-00-00',
'ean' => '9786230067938',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '724050779',
'code_x1' => null,
'code_x2' => '9786230067938',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '90000',
'price_max' => '0',
'price_dollar' => '90000',
'currency' => null,
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => 'ce07f5d75fe286144ddbe6a0a51a803b.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '210',
'dimension_y' => '140',
'dimension_z' => null,
'weight' => '250',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Dengan Excel Android, kini Anda bisa membuat, mengedit, dan berbagi spreadsheet langsung dari ponsel atau tablet Anda. Aplikasi ini memungkinkan Anda bekerja dari mana saja, bahkan saat dalam perjalanan, tanpa perlu membuka laptop. Fungsionalitas lengkap Excel kini ada dalam genggaman Anda, dan Anda bisa mengunduh aplikasi ini secara gratis di Google Play Store.
Meskipun fleksibel, banyak pengguna hanya menggunakan Excel Android untuk membuka file tanpa memahami fitur-fitur hebat yang ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => null,
'created' => '2024-11-25 09:00:19',
'modified' => null,
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '90000',
'price_discount' => (int) 72000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1584423',
'search_cache_id' => '1184406',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2024-11-25 09:00:20',
'modified' => null
)
),
(int) 5 => array(
'SearchCache' => array(
'id' => '1181679',
'product_id' => '2010001381419',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Panduan Lengkap Pivottable Dan Pivotchart Excel 2007, 2010, 2013, 2016, 2019, 2021',
'subname' => null,
'edition' => null,
'date_release' => 'Februari 2024',
'date_calc' => '0000-00-00',
'date_available' => '0000-00-00',
'ean' => '9786230056741',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '724050121',
'code_x1' => null,
'code_x2' => '9786230056741',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '100000',
'price_max' => '0',
'price_dollar' => '100000',
'currency' => null,
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => '0c94110c76ae9c771bdace5e72ea9610.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '140',
'dimension_y' => '210',
'dimension_z' => null,
'weight' => '250',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Penggunaan Excel yang semakin luas saat ini menjadi tuntutan bagi karyawan dan pelaku bisnis untuk dapat menguasai aplikasi ini secara optimal. Salah satu kunci sukses untuk menguasai Excel adalah kemampuan dalam mengelola data secara efektif, efisien, dan profesional. Jika Anda menguasai kemampuan tersebut, pengelolaan data tentu dapat diselesaikan dengan mudah dan cepat. Excel menyediakan fitur pengelolaan data yang cukup lengkap. PivotTable dan PivotChart termasuk fitur canggih yang ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => null,
'created' => '2024-02-20 23:05:27',
'modified' => null,
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '100000',
'price_discount' => (int) 80000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1573157',
'search_cache_id' => '1181679',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2024-02-20 23:05:27',
'modified' => null
)
),
(int) 6 => array(
'SearchCache' => array(
'id' => '1178974',
'product_id' => '2010001354444',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Panduan Lengkap Menggunakan Excel 2021',
'subname' => null,
'edition' => null,
'date_release' => 'September 2023',
'date_calc' => '0000-00-00',
'date_available' => '0000-00-00',
'ean' => '9786230050039',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => null,
'code_x1' => null,
'code_x2' => '9786230050039',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '140000',
'price_max' => '0',
'price_dollar' => '140000',
'currency' => null,
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => '7833092813d0cf8b719758b5dab06386.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '140',
'dimension_y' => '210',
'dimension_z' => null,
'weight' => '350',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Excel merupakan software pengolah data yang canggih dan populer. Kemampuan dan kelengkapan fasilitas yang disediakan Excel dalam mengolah dan menganalisis data sangat andal, sehingga menjadikan Excel banyak dipakai pengguna komputer dari berbagai bidang profesi. Buku ini mengupas penggunaan berbagai fungsi dan fitur yang dimiliki Excel versi terbaru, yaitu Excel 2021. Buku ini cocok digunakan oleh siapa saja, baik yang sudah pernah menggunakan Excel versi sebelumnya ataupun yang sama sekali ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => null,
'created' => '2023-09-19 09:02:51',
'modified' => null,
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '140000',
'price_discount' => (int) 112000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1562461',
'search_cache_id' => '1178974',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2023-09-19 09:02:51',
'modified' => null
)
),
(int) 7 => array(
'SearchCache' => array(
'id' => '1173505',
'product_id' => '2010001300175',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Mengeksplorasi Fungsi IF Excel',
'subname' => '',
'edition' => '',
'date_release' => 'November 2022',
'date_calc' => '2022-11-23',
'date_available' => '2022-11-23',
'ean' => '9786230036637',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '',
'code_x1' => '',
'code_x2' => '9786230036637',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '95000',
'price_max' => '0',
'price_dollar' => '95000',
'currency' => 'IDR',
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => '966ee3d65e2a80bb3a4554978d40bf8a.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '140',
'dimension_y' => '210',
'dimension_z' => '0',
'weight' => '300',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Salah satu kunci sukses menggunakan Excel adalah dengan menguasai fungsi IF secara benar. Namun, masih banyak pengguna Excel yang belum mengetahui kedahsyatan fungsi IF ini. Padahal, mustahil menguasai Excel secara optimal tanpa menggali lebih dalam kedahsyatan yang dimiliki fungsi IF. Mengeksplorasi Fungsi IF Excel mengungkap rahasia-rahasia yang dimiliki fungsi IF. Materi buku ini ditulis secara khusus dengan menggali kemampuan fungsi IF yang dikombinasikan dengan fungsi dan fasilitas lain ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => '',
'created' => '2022-11-18 09:02:56',
'modified' => '2022-12-26 20:33:01',
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '95000',
'price_discount' => (int) 76000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1543869',
'search_cache_id' => '1173505',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-12-26 15:38:01',
'modified' => '2022-12-26 15:38:01'
)
),
(int) 8 => array(
'SearchCache' => array(
'id' => '1171914',
'product_id' => '2010001284130',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Belajar Sendiri Power Query untuk Pemula',
'subname' => null,
'edition' => null,
'date_release' => 'Oktober 2022',
'date_calc' => '0000-00-00',
'date_available' => '0000-00-00',
'ean' => '9786230035609',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => null,
'code_x1' => null,
'code_x2' => '9786230035609',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '85000',
'price_max' => '0',
'price_dollar' => '85000',
'currency' => null,
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => 'f145124521193a5fa546efc8734bc1ab.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '140',
'dimension_y' => '210',
'dimension_z' => null,
'weight' => '235',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Power Query adalah fitur yang sangat banyak kegunaannya untuk mengolah data dengan Excel. Dengan Power Query, Anda dapat menyambungkan berbagai sumber data dengan Excel. Sumber datanya dapat berupa Table Excel, Workbook, File Text/CSV, data dari web, data dari aplikasi database seperti Access, dan sumber data lainnya. Setelah tersambung, Anda dapat mengolahnya, misalnya mengubah format, mengurutkan, menyaring, memecah, menggabungkan, dan berbagai perlakuan lainnya sesuai dengan keperluan. ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => null,
'created' => '2022-09-30 09:02:42',
'modified' => null,
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '85000',
'price_discount' => (int) 68000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1529487',
'search_cache_id' => '1171914',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-30 09:02:44',
'modified' => null
)
),
(int) 9 => array(
'SearchCache' => array(
'id' => '1168873',
'product_id' => '2010001253709',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Belajar Sendiri Membuat Fungsi Excel untuk Pemula',
'subname' => '',
'edition' => '',
'date_release' => 'September 2022',
'date_calc' => '2022-09-28',
'date_available' => '2022-09-28',
'ean' => '9786230035616',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '722050642',
'code_x1' => '',
'code_x2' => '9786230035616',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '30000',
'price_max' => '0',
'price_dollar' => '30000',
'currency' => 'IDR',
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => '76286a14dc473cd3072511b7c683057f.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '0',
'dimension_y' => '0',
'dimension_z' => '0',
'weight' => '325',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Di dalam buku Belajar Sendiri Membuat Fungsi Excel untuk Pemula ini disajikan banyak contoh kasus sehari-hari yang dapat diselesaikan dengan fungsi Excel buatan sendiri. Pembahasan dalam buku ini dapat diaplikasikan pada semua versi Excel. Pembahasan dibuat simpel dan ringan sehingga sangat cocok untuk pemula. Dengan metode membaca dan mencoba, buku ini merupakan solusi untuk belajar membuat fungsi Excel secara otodidak. Sebagai bonus, Anda dapat mendownload file latihan dan hasil latihan serta ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => '',
'created' => '2022-09-26 16:03:19',
'modified' => '2022-12-26 20:33:01',
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '30000',
'price_discount' => (int) 24000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1543865',
'search_cache_id' => '1168873',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-12-26 15:36:37',
'modified' => '2022-12-26 15:36:37'
)
),
(int) 10 => array(
'SearchCache' => array(
'id' => '1164527',
'product_id' => '2010001210320',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Mengeksplorasi Formula dan Fungsi Logika Excel',
'subname' => null,
'edition' => null,
'date_release' => 'Juli 2022',
'date_calc' => '0000-00-00',
'date_available' => '0000-00-00',
'ean' => '9786230034404',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => null,
'code_x1' => null,
'code_x2' => '9786230034404',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '80000',
'price_max' => '0',
'price_dollar' => '80000',
'currency' => null,
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => '622dded452f712582bc80ed10b9b7d95.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '140',
'dimension_y' => '210',
'dimension_z' => null,
'weight' => '200',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Formula dan fungsi logika Excel merupakan fitur yang sangat membantu dalam pengolahan data. Formula dan fungsi ini bertujuan untuk membandingkan dua kondisi atau lebih pada perhitungan Excel, yang sering digunakan sebagai dasar dalam pengambilan keputusan. Sayangnya, kemampuan formula dan fungsi logika Excel tidak tereksplorasi secara optimal karena dianggap susah dipahami. Mulai saat ini, buang jauh-jauh kesan susah dipahami. Pelajari buku ini dan penulis jamin pembaca akan dengan cepat ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => null,
'created' => null,
'modified' => null,
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '80000',
'price_discount' => (int) 64000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1469118',
'search_cache_id' => '1164527',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-23 00:12:23',
'modified' => null
)
),
(int) 11 => array(
'SearchCache' => array(
'id' => '1163366',
'product_id' => '2010001198642',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Panduan Lengkap Word dan Excel 2007, 2010, 2013, 2016, 2019 untuk Pemula',
'subname' => '',
'edition' => '',
'date_release' => 'Mei 2022',
'date_calc' => '2022-05-25',
'date_available' => '2022-05-25',
'ean' => '9786230032981',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '722050324',
'code_x1' => '6230032988',
'code_x2' => '9786230032981',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '130000',
'price_max' => '0',
'price_dollar' => '130000',
'currency' => 'IDR',
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => '54de7a363120f03221cf0969e114501f.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '0',
'dimension_y' => '0',
'dimension_z' => '0',
'weight' => '395',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Panduan Lengkap Word dan Excel 2007, 2010, 2013, 2016, 2019 untuk Pemula
Microsoft Word atau Microsoft Office Word atau Word adalah perangkat lunak pengolah kata andalan Microsoft. Pertama diterbitkan pada 1983 dengan nama Multi-Tool Word untuk Xenix, versi-versi lain kemudian dikembangkan untuk berbagai sistem operasi, misalnya DOS, Apple Macintosh, SCO UNIX, OS/2, dan Microsoft Windows.
Sementara, Microsoft Excel adalah program perangkat lunak yang memungkinkan pengguna untuk mengolah ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => '',
'created' => '2022-05-30 14:15:00',
'modified' => '2022-12-26 20:33:01',
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '130000',
'price_discount' => (int) 104000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1543873',
'search_cache_id' => '1163366',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-12-26 15:38:23',
'modified' => '2022-12-26 15:38:23'
)
),
(int) 12 => array(
'SearchCache' => array(
'id' => '1163071',
'product_id' => '2010001195726',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Mengeksplorasi Fungsi INDEX dan MATCH Excel',
'subname' => '',
'edition' => '',
'date_release' => 'April 2022',
'date_calc' => '2022-04-20',
'date_available' => '2022-04-20',
'ean' => '9786230032257',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '722050269',
'code_x1' => '6230032252',
'code_x2' => '9786230032257',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '20000',
'price_max' => '0',
'price_dollar' => '20000',
'currency' => 'IDR',
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => '991ced1189b755078374fa20127f9286.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '0',
'dimension_y' => '0',
'dimension_z' => '0',
'weight' => '210',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Mengeksplorasi Fungsi INDEX dan MATCH Excel
Microsoft Excel, atau biasa disebut Excel, merupakan program spreadsheet (pengolah data) yang mempunyai kemampuan mengolah data secara luas pada hampir semua bidang yang memerlukan perhitungan dengan cepat dan teliti. Excel dikenal sebagai program spreadsheet yang lebih mudah digunakan dibandingkan program spreadsheet yang lain. Kemudahan tersebut terlihat jelas dari banyaknya fasilitas rums siap pakai (fungsi) yang disediakan Excel.
Ada ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => '',
'created' => '2022-04-19 11:49:56',
'modified' => '2022-04-19 11:49:56',
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '20000',
'price_discount' => (int) 16000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1498953',
'search_cache_id' => '1163071',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-29 13:26:39',
'modified' => null
)
),
(int) 13 => array(
'SearchCache' => array(
'id' => '1163018',
'product_id' => '2010001195153',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Panduan Lengkap Menggunakan Excel 365',
'subname' => '',
'edition' => '',
'date_release' => 'April 2022',
'date_calc' => '2022-04-06',
'date_available' => '2022-04-06',
'ean' => '9786230031960',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '722050229',
'code_x1' => '6230031965',
'code_x2' => '9786230031960',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '130000',
'price_max' => '0',
'price_dollar' => '130000',
'currency' => 'IDR',
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => '48775d9559f46595c1f7d551862cfa6b.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '0',
'dimension_y' => '0',
'dimension_z' => '0',
'weight' => '410',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Panduan Lengkap Menggunakan Excel 365
Microsoft Excel, atau lebih umum dikenal dengan sebutan Excel, merupakan program spreadsheet yang digunakan untuk mengolah berbagai jenis data. Excel 365 merupakan versi berlangganan yang termasuk dalam paket Microsoft 365. Sebagai pelanggan Microsoft 365, Anda akan secara ruin mendapatkan update fitur dan fungsi baru yang terus ditingkatkan.
Bagi Anda yang ingin mempelajari microsoft excel 365, buku “Panduan Lengkap Menggunakan Excel 365” ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => '',
'created' => '2022-04-05 11:17:26',
'modified' => '2022-05-29 19:08:07',
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '130000',
'price_discount' => (int) 104000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1500227',
'search_cache_id' => '1163018',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-29 13:27:17',
'modified' => null
)
),
(int) 14 => array(
'SearchCache' => array(
'id' => '1162955',
'product_id' => '2010001194545',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Mengeksplorasi Fungsi VLOOKUP, HLOOKUP, dan LOOKUP Excel',
'subname' => '',
'edition' => '',
'date_release' => 'Maret 2022',
'date_calc' => '2022-03-30',
'date_available' => '2022-03-30',
'ean' => '9786230031748',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '722050206',
'code_x1' => '6230031744',
'code_x2' => '9786230031748',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '5000',
'price_max' => '0',
'price_dollar' => '5000',
'currency' => 'IDR',
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => '1f8087872176bd842d48414fe25b959a.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '0',
'dimension_y' => '0',
'dimension_z' => '0',
'weight' => '200',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Mengeksplorasi Fungsi VLOOKUP, HLOOKUP, dan LOOKUP Excel
Microsoft Excel, atau biasa disebut Excel, merupakan program spreadsheet (pengolah data) yang mempunyai kemampuan mengolah data secara luas pada hampir semua bidang yang memerlukan perhitungan dengan cepat dan teliti. Excel dikenal sebagai program spreadsheet yang lebih mudah digunakan dibandingkan program spreadsheet yang lain. Kemudahan tersebut terlihat jelas dari banyaknya fasilitas rums siap pakai (fungsi) yang disediakan ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => '',
'created' => '2022-03-28 13:06:28',
'modified' => '2022-03-28 13:06:29',
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '5000',
'price_discount' => (int) 4000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1498961',
'search_cache_id' => '1162955',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-29 13:26:39',
'modified' => null
)
),
(int) 15 => array(
'SearchCache' => array(
'id' => '1162886',
'product_id' => '2010001193814',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Kupas Tuntas Form Control Excel',
'subname' => '',
'edition' => '',
'date_release' => 'Maret 2022',
'date_calc' => '2022-03-23',
'date_available' => '2022-03-23',
'ean' => '9786230031717',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '722050203',
'code_x1' => '623003171X',
'code_x2' => '9786230031717',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '70000',
'price_max' => '0',
'price_dollar' => '70000',
'currency' => 'IDR',
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => 'c222b30ae02483ee60bffd6faed38af4.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '0',
'dimension_y' => '0',
'dimension_z' => '0',
'weight' => '200',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Form Controls merupakan fitur Excel yang digunakan untuk mengelola data secara interaktif. Fitur Form Controls selama ini jarang digunakan secara optimal. Hal ini dapat dimaklumi karena belum ada buku yang secara khusus membahas penggunaan Form Controls untuk menyelesaikan berbagai kasus bisnis dan perkantoran yang sering ditemui. Padahal, penggunaan Form Controls relatif mudah karena hampir seluruh kontrol tidak memerlukan kode pemrograman VBA Macro. Kupas Tuntas Form Controls Excel membahas ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => '',
'created' => '2022-03-21 16:22:09',
'modified' => '2022-03-21 16:22:09',
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '70000',
'price_discount' => (int) 56000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1498963',
'search_cache_id' => '1162886',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-29 13:26:39',
'modified' => null
)
),
(int) 16 => array(
'SearchCache' => array(
'id' => '1162885',
'product_id' => '2010001193807',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Membuat Aplikasi Stok Barang dengan VBA Macro Excel dan Access',
'subname' => '',
'edition' => '',
'date_release' => 'Maret 2022',
'date_calc' => '2022-03-23',
'date_available' => '2022-03-23',
'ean' => '9786230031700',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '722050202',
'code_x1' => '6230031701',
'code_x2' => '9786230031700',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '5000',
'price_max' => '0',
'price_dollar' => '5000',
'currency' => 'IDR',
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => '861ceba47c99c6169f76a8fd3209ee2b.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '0',
'dimension_y' => '0',
'dimension_z' => '0',
'weight' => '350',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Excel dan Access merupakan dua program andal yang sudah familiar bagi pengguna komputer di Indonesia. Sebagai program spreadsheet yang canggih, Excel menyediakan VBA Macro, yaitu fitur otomatisasi yang dapat Anda gunakan untuk menyelesaikan pekerjaan rutin yang bersifat kompleks. Access sendiri merupakan program database yang terstruktur dan efisien.
Kolaborasi VBA Macro Excel dan Access dapat Anda gunakan untuk membuat aplikasi stok barang. Aplikasi ini dapat menyajikan informasi data stok ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => '',
'created' => '2022-03-21 16:18:59',
'modified' => '2022-03-21 16:18:59',
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '5000',
'price_discount' => (int) 4000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1500218',
'search_cache_id' => '1162885',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-29 13:27:17',
'modified' => null
)
),
(int) 17 => array(
'SearchCache' => array(
'id' => '1162446',
'product_id' => '2010001189442',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Tip & Trik Excel 2007, 2010, 2013, 2016, 2019',
'subname' => '',
'edition' => '',
'date_release' => 'Januari 2022',
'date_calc' => '2022-01-26',
'date_available' => '2022-01-26',
'ean' => '9786230030413',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '722050067',
'code_x1' => '6230030411',
'code_x2' => '9786230030413',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '85000',
'price_max' => '0',
'price_dollar' => '85000',
'currency' => 'IDR',
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => '5c412fd2c63a64e51496524b307b843f.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '0',
'dimension_y' => '0',
'dimension_z' => '0',
'weight' => '350',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Excel merupakan aplikasi pengolah data andal yang mempunyai banyak sekali kelebihan. Sayangnya, sebagian besar pengguna Excel tidak mengetahui cara mengoptimalkan kelebihan tersebut. Padahal, dengan menggunakan Excel secara optimal, setiap pekerjaan dapat diselesaikan dengan lebih mudah dan lebih cepat. Tip dan Trik Excel 2007, 2010, 2013, 2016, 2019 ini mengungkap tip dan trik praktis penyelesaian masalah pekerjaan yang sering dijumpai sehari-hari. Tip dan trik dikelompokkan ke dalam kategori ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => '',
'created' => '2022-01-17 14:59:35',
'modified' => '2023-11-27 12:08:02',
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '85000',
'price_discount' => (int) 68000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1500254',
'search_cache_id' => '1162446',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-29 13:27:19',
'modified' => null
)
),
(int) 18 => array(
'SearchCache' => array(
'id' => '1162212',
'product_id' => '2010001187127',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Panduan Lengkap Mengelola Data Excel 2007, 2010, 2013, 2016, 2019',
'subname' => '',
'edition' => '',
'date_release' => 'Desember 2021',
'date_calc' => '2021-12-22',
'date_available' => '2021-12-22',
'ean' => '9786230029677',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '721050730',
'code_x1' => '6230029677',
'code_x2' => '9786230029677',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '100000',
'price_max' => '0',
'price_dollar' => '100000',
'currency' => 'IDR',
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => '69775d21c549ede43a83643f5ae07566.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '0',
'dimension_y' => '0',
'dimension_z' => '0',
'weight' => '450',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Penggunaan Excel yang semakin luas saat ini menjadi tuntutan bagi pelajar, mahasiswa, karyawan ataupun pelaku bisnis untuk dapat menguasainya secara optimal. Salah satu kunci sukses menguasai Excel adalah kemampuan mengelola data secara efektif, efisien, dan profesional. Jika Anda menguasai kemampuan ini, pengelolaan data dapat diselesaikan dengan mudah dan cepat sehingga produktivitas kerja akan meningkat. Panduan Lengkap Mengelola Data Excel 2007, 2010, 2013, 2016, 2019 membahas secara ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => '',
'created' => '2021-12-20 14:51:05',
'modified' => '2022-12-22 17:38:02',
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '100000',
'price_discount' => (int) 80000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1500238',
'search_cache_id' => '1162212',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-29 13:27:18',
'modified' => null
)
),
(int) 19 => array(
'SearchCache' => array(
'id' => '1161908',
'product_id' => '2010001184263',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Kupas Tuntas Formula dan Fungsi Dynamic Array',
'subname' => '',
'edition' => '',
'date_release' => 'November 2021',
'date_calc' => '2021-11-03',
'date_available' => '2021-11-03',
'ean' => '9786230028298',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '721050570',
'code_x1' => '6230028298',
'code_x2' => '9786230028298',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '5000',
'price_max' => '0',
'price_dollar' => '5000',
'currency' => 'IDR',
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => 'e2daf135805e7af0cd4be5d12e5f7143.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '0',
'dimension_y' => '0',
'dimension_z' => '0',
'weight' => '300',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Formula dynamic array (array dinamis) merupakan kemajuan terbesar pada formula Excel dalam beberapa puluh tahun terakhir atau mungkin perubahan terbesar yang pernah ada hingga saat ini. Penggunaan formula dynamic array memungkinkan Anda bekerja dengan banyak nilai sekaligus, menggunakan sebuah formula yang simpel.
Formula dan fungsi dynamic array hanya tersedia dalam Excel 365. Excel 2019 dan Excel versi sebelumnya tidak menawarkan dukungan formula dan fungsi dynamic array ini. Tanpa trik ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => '',
'created' => '2021-10-29 14:55:43',
'modified' => '2022-09-28 09:08:04',
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '5000',
'price_discount' => (int) 4000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1500276',
'search_cache_id' => '1161908',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-29 13:27:19',
'modified' => null
)
),
(int) 20 => array(
'SearchCache' => array(
'id' => '1161689',
'product_id' => '2010001182054',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Semua Bisa Menjadi Programmer Web Python Basic (Django 3.2)',
'subname' => '',
'edition' => '',
'date_release' => 'September 2021',
'date_calc' => '2021-09-29',
'date_available' => '2021-09-29',
'ean' => '9786230027895',
'string_x1' => 'IR. YUNIAR SUPARDI, RAHMAT ARIF MS',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '721050533',
'code_x1' => '6230027895',
'code_x2' => '9786230027895',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '82000',
'price_max' => '0',
'price_dollar' => '82000',
'currency' => 'IDR',
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => 'd540cdc92c772e186b0191c97947e5cb.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '0',
'dimension_y' => '0',
'dimension_z' => '0',
'weight' => '300',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Buku berjudul Semua Bisa Menjadi Programmer Web Python Basic (Django 3.2) ini membuktikan bahasa pemrograman Python menjadi bahasa nomor satu di dunia dan akan menjadi bahasa pemrograman masa depan. Bahasa pemrograman ini menjadi bahasa yang sangat efisien dan efektif dalam membuat aplikasi, baik desktop maupun web. Buku ini disusun dengan sistematika yang baik, sehingga pembaca dapat dengan mudah belajar dan menjadi webmaster dengan bahasa Django Python. Dalam buku ini penulis menggunakan ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => '',
'created' => '2021-09-28 14:42:30',
'modified' => '2021-09-28 14:42:30',
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '82000',
'price_discount' => (int) 65600,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1500352',
'search_cache_id' => '1161689',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-29 13:27:21',
'modified' => null
)
),
(int) 21 => array(
'SearchCache' => array(
'id' => '1161200',
'product_id' => '2010001177296',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Belajar Sendiri VBA Macro Excel untuk Pemula',
'subname' => '',
'edition' => '',
'date_release' => 'Juli 2021',
'date_calc' => '2021-07-14',
'date_available' => '2021-07-14',
'ean' => '9786230027123',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '721050453',
'code_x1' => '6230027127',
'code_x2' => '9786230027123',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '5000',
'price_max' => '0',
'price_dollar' => '5000',
'currency' => 'IDR',
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => 'e9f4c1fa3ca201f6b5d682602318dbb4.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '0',
'dimension_y' => '0',
'dimension_z' => '0',
'weight' => '500',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Visual Basic for Applications (VBA) atau yang dikenal dengan istilah Macro, merupakan fitur Excel yang sangat populer. VBA Macro dapat digunakan untuk mengotomatisasi pekerjaan sehingga pekerjaan yang bersifat rutin dapat diselesaikan dengan lebih mudah dan cepat. Kecanggihan VBA Macro dalam mengotomatisasi pekerjaan membuat banyak pengguna Excel yang semakin tertarik untuk mempelajarinya. Belajar Sendiri VBA Macro Excel untuk Pemula ini membahas secara lengkap cara menggunakan VBA Macro secara ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => '',
'created' => '2021-07-09 18:46:39',
'modified' => '2021-07-09 18:46:39',
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '5000',
'price_discount' => (int) 4000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1500296',
'search_cache_id' => '1161200',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-29 13:27:20',
'modified' => null
)
),
(int) 22 => array(
'SearchCache' => array(
'id' => '1160872',
'product_id' => '2010001174011',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => ' Belajar Sendiri PivotTable Excel untuk Pemula',
'subname' => '',
'edition' => '',
'date_release' => 'Juni 2021',
'date_calc' => '2021-06-02',
'date_available' => '2021-06-02',
'ean' => '9786230026492',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '',
'code_x1' => '623002649X',
'code_x2' => '9786230026492',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '85000',
'price_max' => '0',
'price_dollar' => '85000',
'currency' => 'IDR',
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => 'b183474c61b3376de6a6030e2be58818.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '0',
'dimension_y' => '0',
'dimension_z' => '0',
'weight' => '400',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Berlaku pada Excel 2007, 2010, 2013, 2016, dan 2019 PivotTable merupakan salah satu fitur andal Excel untuk membuat tabel interaktif. Penggunaannya tidak memerlukan formula atau pemrograman VBA yang rumit. PivotTable sangat bermanfaat untuk keperluan pembuatan laporan, analisis data, presentasi, dan pengambilan keputusan bisnis. PivotTable sangat dianjurkan bagi pengguna Excel yang pekerjaan sehari-harinya berhubungan dengan pengelolaan database. Belajar Sendiri PivotTable Excel untuk Pemula ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => '',
'created' => '2021-05-28 11:26:08',
'modified' => '2021-05-28 11:26:08',
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '85000',
'price_discount' => (int) 68000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1500298',
'search_cache_id' => '1160872',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-29 13:27:20',
'modified' => null
)
),
(int) 23 => array(
'SearchCache' => array(
'id' => '1160692',
'product_id' => '2010001172178',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Membuat Aplikasi Kasir dengan VBA Macro Excel',
'subname' => '',
'edition' => '',
'date_release' => 'Mei 2021',
'date_calc' => '2021-05-05',
'date_available' => '2021-05-05',
'ean' => '9786230025952',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '721050296',
'code_x1' => '6230025957',
'code_x2' => '9786230025952',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '20000',
'price_max' => '0',
'price_dollar' => '20000',
'currency' => 'IDR',
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => '9e90ae2d8419cd61510631e728cb945c.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '0',
'dimension_y' => '0',
'dimension_z' => '0',
'weight' => '410',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Sebagai program spreadsheet yang canggih, Excel menyediakan fitur VBA Macro, yaitu fitur otomatisasi untuk menyelesaikan pekerjaan yang kompleks dengan cepat dan mudah. Salah satu contoh penerapan VBA Macro dalam dunia bisnis adalah untuk membuat aplikasi kasir. Aplikasi kasir yang dibuat dengan VBA Macro dapat menyelesaikan transaksi pembelian dan penjualan dengan mudah dan cepat karena hampir semuanya dikerjakan secara otomatis. Buku ini berisi panduan langkah demi langkah pembuatan aplikasi ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => '',
'created' => '2021-05-04 11:09:48',
'modified' => '2022-09-28 09:08:04',
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '20000',
'price_discount' => (int) 16000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1500339',
'search_cache_id' => '1160692',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-29 13:27:21',
'modified' => null
)
),
(int) 24 => array(
'SearchCache' => array(
'id' => '1160322',
'product_id' => '2010001168416',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Mengolah Data Statistik dengan MS Excel',
'subname' => '',
'edition' => '',
'date_release' => 'Maret 2021',
'date_calc' => '2021-03-24',
'date_available' => '2021-03-24',
'ean' => '9786230024603',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '721050180',
'code_x1' => '6230024608',
'code_x2' => '9786230024603',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '95000',
'price_max' => '0',
'price_dollar' => '95000',
'currency' => 'IDR',
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => '180aa5efe7a79dc1ccbd303393bdaaa6.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '0',
'dimension_y' => '0',
'dimension_z' => '0',
'weight' => '410',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Kecanggihan Excel sebagai software pengolah data sudah diakui di seluruh dunia. Salah satu fasilitas yang disediakan Excel adalah fungsi dan program bantu (add-in) untuk mengolah data statistik. Walaupun bukan software yang secara khusus digunakan untuk mengolah data statistik, keandalan Excel untuk mengolah data statistik tidak perlu diragukan lagi. Pengolahan data statistik dari yang sederhana hingga yang kompleks dapat diselesaikan secara cepat dan mudah menggunakan Excel. Mengolah Data ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => '',
'created' => '2021-03-22 12:06:14',
'modified' => '2022-09-28 09:08:04',
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '95000',
'price_discount' => (int) 76000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1500324',
'search_cache_id' => '1160322',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-29 13:27:21',
'modified' => null
)
),
(int) 25 => array(
'SearchCache' => array(
'id' => '1160166',
'product_id' => '2010001166832',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Aplikasi Kuitansi, Stok Barang, & Penggajian Dengan Ms Excel',
'subname' => '',
'edition' => '',
'date_release' => 'Maret 2021',
'date_calc' => '2021-03-10',
'date_available' => '2021-03-10',
'ean' => '9786230024016',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '721050106',
'code_x1' => '6230024012',
'code_x2' => '9786230024016',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '20000',
'price_max' => '0',
'price_dollar' => '20000',
'currency' => 'IDR',
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => '33052cdc138f383a71387c1a0c4f8c25.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '0',
'dimension_y' => '0',
'dimension_z' => '0',
'weight' => '350',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Microsoft Excel merupakan software pengolah data yang sangat populer serta diakui kecanggihannya. Excel dapat digunakan untuk berbagai macam kebutuhan, mulai dari yang sederhana sampai tingkat lanjut. Penerapan yang sederhana misalnya membuat tabel, mengolah data, menghitung data, membuat grafik, dan sebagainya. Contoh penerapan Excel tingkat lanjut adalah membuat aplikasi bisnis terapan. Aplikasi yang ada umumnya dibuat menggunakan pemrograman VBA Macro Excel. Bagi pengguna Excel yang ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => '',
'created' => '2021-03-03 14:46:40',
'modified' => '2021-12-17 18:33:06',
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '20000',
'price_discount' => (int) 16000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1500313',
'search_cache_id' => '1160166',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-29 13:27:20',
'modified' => null
)
),
(int) 26 => array(
'SearchCache' => array(
'id' => '1163761',
'product_id' => '2010001202608',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Membuat Aplikasi Penggajian Dengan Vba Macro Excel Dan Mysql',
'subname' => '',
'edition' => '',
'date_release' => '2021',
'date_calc' => '2021-01-01',
'date_available' => '2021-00-00',
'ean' => '9786230028533',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '',
'code_x1' => '6230028530',
'code_x2' => '9786230028533',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '82000',
'price_max' => '0',
'price_dollar' => '82000',
'currency' => 'IDR',
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => 'b77bfad2de50f473bf7ed8866ad3ed1d.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '0',
'dimension_y' => '0',
'dimension_z' => '0',
'weight' => '401',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Sebagai program spreadsheet yang canggih, Excel menyediakan VBA Macro, yaitu fitur otomatisasi yang dapat Anda gunakan untuk menyelesaikan pekerjaan rutin yang bersifat kompleks dalam dunia bisnis dan perkantoran. MySQL merupakan salah satu software manajemen database yang sering digunakan. Selain gratis, MySQL terkenal andal dan dapat digunakan untuk berbagai platform sistem operasi. Membuat Aplikasi Penggajian dengan VBA Macro Excel dan MySQL dapat Anda gunakan sebagai panduan untuk membuat ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => '',
'created' => '2022-08-02 15:12:06',
'modified' => '2022-08-25 17:03:34',
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '82000',
'price_discount' => (int) 65600,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1500351',
'search_cache_id' => '1163761',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-29 13:27:21',
'modified' => null
)
),
(int) 27 => array(
'SearchCache' => array(
'id' => '1168386',
'product_id' => '2010001248842',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Panduan Lengkap Menggunakan Template Excel',
'subname' => null,
'edition' => null,
'date_release' => 'Desember 2020',
'date_calc' => '0000-00-00',
'date_available' => '0000-00-00',
'ean' => '9786230022005',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => null,
'code_x1' => null,
'code_x2' => '9786230022005',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '75000',
'price_max' => '0',
'price_dollar' => '75000',
'currency' => null,
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => 'c62cd73db5567fa1a04ce9c9a8fb4fd2.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '140',
'dimension_y' => '210',
'dimension_z' => null,
'weight' => '300',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Pembuatan workbook (buku kerja) pada umumnya memiliki pola tertentu. Semakin sering dan semakin lama kita bekerja dengan workbook yang serupa, maka kita akan semakin mengetahui apa saja sebenarnya yang menjadi dasar dan diperlukan untuk membuat workbook, baik itu laporan bulanan, triwulanan, semester ataupun tahunan. Semua hal penting yang dibutuhkan dalam sebuah workbook dapat Anda jadikan menjadi template, ketika kita hendak membuat laporan kita hanya perlu membuat workbook baru berdasarkan ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => null,
'created' => null,
'modified' => null,
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '75000',
'price_discount' => (int) 60000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1486418',
'search_cache_id' => '1168386',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-23 13:58:14',
'modified' => null
)
),
(int) 28 => array(
'SearchCache' => array(
'id' => '1168390',
'product_id' => '2010001248880',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Panduan Lengkap Membuat Add-In Excel',
'subname' => '',
'edition' => '',
'date_release' => 'November 2020',
'date_calc' => '2020-11-04',
'date_available' => '2020-11-04',
'ean' => '9786230021626',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '',
'code_x1' => '',
'code_x2' => '9786230021626',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '78000',
'price_max' => '0',
'price_dollar' => '78000',
'currency' => 'IDR',
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => '5fb6ea0e229a1ad3d48b99d77e95f7f0.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '140',
'dimension_y' => '210',
'dimension_z' => '0',
'weight' => '300',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Excel dikenal sebagai program spreadsheet canggih, terlihat dari banyaknya fungsi dan fitur yang disediakan. Namun karena luasnya bidang pengolahan data, tidak semua fungsi dan fitur yang disediakan dapat memenuhi kebutuhan penggunanya. Untuk mengatasinya, Excel menyediakan fitur Visual Basic for Applications (VBA) atau macro. Dengan macro, Anda dapat menambahkan fungsi dan fitur Excel buatan sendiri dalam bentuk Add-In. Panduan Lengkap Membuat Add-In Excel ini merupakan buku pertama yang ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => '',
'created' => null,
'modified' => '2022-09-23 23:09:15',
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '78000',
'price_discount' => (int) 62400,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1487436',
'search_cache_id' => '1168390',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-23 23:09:15',
'modified' => '2022-09-23 23:09:15'
)
),
(int) 29 => array(
'SearchCache' => array(
'id' => '1168391',
'product_id' => '2010001248897',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Kupas Tuntas Kriteria dalam Formula Excel',
'subname' => null,
'edition' => null,
'date_release' => 'Maret 2020',
'date_calc' => '0000-00-00',
'date_available' => '0000-00-00',
'ean' => '9786230015717',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => null,
'code_x1' => null,
'code_x2' => '9786230015717',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '60000',
'price_max' => '0',
'price_dollar' => '60000',
'currency' => null,
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => '844977b644f04b91dd2a6b1d9a76558a.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '140',
'dimension_y' => '210',
'dimension_z' => null,
'weight' => '300',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Salah satu keterampilan terpenting dalam menggunakan formula Excel adalah kemampuan untuk membuat kriteria, yaitu bagian dari formula yang memutuskan apa yang akan dimasukkan atau dikecualikan dalam perhitungan. Pengguna Excel pada umumnya mengalami kesulitan dalam membuat kriteria yang efektif karena membutuhkan pemahaman yang baik tentang cara Excel menangani data. Pelajari buku ini, dijamin Anda akan dengan cepat menguasai pembuatan kriteria. Ini adalah buku pertama dan terlengkap yang ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => null,
'created' => null,
'modified' => null,
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '60000',
'price_discount' => (int) 48000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1486450',
'search_cache_id' => '1168391',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-23 14:08:12',
'modified' => null
)
),
(int) 30 => array(
'SearchCache' => array(
'id' => '1157133',
'product_id' => '2010001136354',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Membuat Aplikasi Stok Barang dengan VBA Macro Excel',
'subname' => '',
'edition' => '',
'date_release' => 'Januari 2020',
'date_calc' => '2020-01-13',
'date_available' => '2020-01-13',
'ean' => '9786230012518',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '',
'code_x1' => '6230012510',
'code_x2' => '9786230012518',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '20000',
'price_max' => '0',
'price_dollar' => '20000',
'currency' => 'IDR',
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => 'c557cacf67f178aae9ae5edf24ca5c88.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '0',
'dimension_y' => '0',
'dimension_z' => '0',
'weight' => '420',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Mengelola stok barang secara manual memakan banyak waktu dan tenaga. Pengelolaan stok barang bisa dilakukan menggunakan aplikasi komputer. Aplikasi stok barang dapat digunakan untuk mengetahui stok barang yang dimiliki oleh lembaga, toko, atau perusahaan. Dengannya Anda dapat membuat laporan data stok barang secara cepat dan akurat. Jika Anda membutuhkan aplikasi stok barang, Anda dapat membuatnya sendiri dengan Excel. Membuat Aplikasi Stok Barang dengan VBA Macro Excel ini berisi panduan ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => '',
'created' => '2020-01-13 14:33:25',
'modified' => '2020-01-13 14:33:25',
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '20000',
'price_discount' => (int) 16000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1500292',
'search_cache_id' => '1157133',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-29 13:27:20',
'modified' => null
)
),
(int) 31 => array(
'SearchCache' => array(
'id' => '1156388',
'product_id' => '2010001129028',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Kupas Tuntas Fungsi Lookup dan Reference',
'subname' => '',
'edition' => '',
'date_release' => 'Oktober 2019',
'date_calc' => '2019-10-21',
'date_available' => '2019-10-21',
'ean' => '9786230008238',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '719051436',
'code_x1' => '6230008238',
'code_x2' => '9786230008238',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '66000',
'price_max' => '0',
'price_dollar' => '66000',
'currency' => 'IDR',
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => '9effbd3782ef0fc18d4b19e1b5b10074.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '0',
'dimension_y' => '0',
'dimension_z' => '0',
'weight' => '250',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Excel menyediakan ratusan fungsi untuk mempermudah dan mempercepat proses pengolahan data. Fungsi dalam kategori Lookup dan Reference sangat membantu dalam pengolahan data, terutama dalam pencarian informasi dari database. Sayangnya, kemampuan ini tidak tereksplorasi secara optimal karena dianggap susah dipahami. Sebenarnya, fungsi Lookup dan Reference tidak susah dipahami. Pelajari buku ini, dijamin Anda akan cepat menguasainya. Kupas Tuntas Fungsi Lookup dan Reference ini ditulis dengan ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => '',
'created' => '2019-10-16 15:02:18',
'modified' => '2019-10-16 15:02:18',
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '66000',
'price_discount' => (int) 52800,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1500260',
'search_cache_id' => '1156388',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-29 13:27:19',
'modified' => null
)
),
(int) 32 => array(
'SearchCache' => array(
'id' => '1156085',
'product_id' => '2010001126041',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Kolaborasi Macro Excel dan Access untuk Membuat Aplikasi Penjualan',
'subname' => '',
'edition' => '',
'date_release' => 'September 2019',
'date_calc' => '2019-09-16',
'date_available' => '2019-09-16',
'ean' => '9786230006760',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '719051307',
'code_x1' => '6230006766',
'code_x2' => '9786230006760',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '85000',
'price_max' => '0',
'price_dollar' => '85000',
'currency' => 'IDR',
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => 'f1ff5bd084eba1b290442defe0f6f6b6.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '0',
'dimension_y' => '0',
'dimension_z' => '0',
'weight' => '420',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Excel dan Access merupakan dua program andal yang sudah familiar di Indonesia. Excel menyediakan Macro, yaitu fitur otomatisasi untuk menyelesaikan pekerjaan rutin yang kompleks. Access sendiri merupakan program database yang terstruktur dan efisien. Kolaborasi Macro Excel dan Access dapat Anda gunakan untuk membuat aplikasi penjualan. Aplikasi penjualan ini dapat menyelesaikan transaksi jual beli dengan mudah dan cepat karena hampir semuanya dikerjakan secara otomatis. Buku ini adalah ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => '',
'created' => '2019-09-11 17:16:12',
'modified' => '2019-09-20 23:30:29',
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '85000',
'price_discount' => (int) 68000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1500261',
'search_cache_id' => '1156085',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-29 13:27:19',
'modified' => null
)
),
(int) 33 => array(
'SearchCache' => array(
'id' => '1168409',
'product_id' => '2010001249078',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Panduan Lengkap Membuat Fungsi Excel',
'subname' => null,
'edition' => null,
'date_release' => 'Juli 2019',
'date_calc' => '0000-00-00',
'date_available' => '0000-00-00',
'ean' => '9786230001444',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => null,
'code_x1' => null,
'code_x2' => '9786230001444',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '78000',
'price_max' => '0',
'price_dollar' => '78000',
'currency' => null,
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => '659617ec0a55a67877dd7d0d49f7c002.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '140',
'dimension_y' => '210',
'dimension_z' => null,
'weight' => '410',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Fungsi Excel merupakan rumus siap pakai yang digunakan sebagai alat bantu dalam proses perhitungan. Excel menyediakan ratusan fungsi untuk menyelesaikan pekerjaan dengan lebih mudah dan lebih singkat. Namun karena luasnya bidang pengolahan data, tidak semua fungsi yang disediakan Excel dapat memenuhi kebutuhan pengguna. Hal tersebut dapat dimengerti, karena kasus yang dihadapi pengguna yang satu seringkali berbeda dengan pengguna yang lain. Untuk mengatasi masalah tersebut, Excel menyediakan ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => null,
'created' => null,
'modified' => null,
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '78000',
'price_discount' => (int) 62400,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1486566',
'search_cache_id' => '1168409',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-23 14:24:17',
'modified' => null
)
),
(int) 34 => array(
'SearchCache' => array(
'id' => '1152988',
'product_id' => '2010001095149',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => '200+ Tip dan Trik Pivot Table Excel',
'subname' => '',
'edition' => '',
'date_release' => 'Agustus 2018',
'date_calc' => '2018-08-20',
'date_available' => '2018-08-20',
'ean' => '9786020478265',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '718051194',
'code_x1' => '',
'code_x2' => '9786020478265',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '66000',
'price_max' => '0',
'price_dollar' => '66000',
'currency' => 'IDR',
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => 'd3efc54fb921959d2256f40854acf057.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '0',
'dimension_y' => '0',
'dimension_z' => '0',
'weight' => '380',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'PivotTable termasuk fitur canggih yang disediakan Excel untuk mengelola database. Dengan fitur ini, Anda dapat mengelola database secara interaktif dengan cepat dan mudah. Ini akan sangat bermanfaat dalam pembuatan laporan, presentasi, analisis data, dan pengambilan keputusan. Penggunaan PivotTable sangat dianjurkan bagi pengguna Excel yang pekerjaan sehari-harinya berhubungan dengan pengelolaan database. Sampai saat ini, banyak yang menganggap PivotTable merupakan fitur rumit dan sulit ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => '',
'created' => '2018-08-02 11:12:10',
'modified' => '2020-05-13 10:11:49',
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '66000',
'price_discount' => (int) 52800,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1501538',
'search_cache_id' => '1152988',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-29 13:27:57',
'modified' => null
)
),
(int) 35 => array(
'SearchCache' => array(
'id' => '1180026',
'product_id' => '2010001364955',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Mengelola Data Excel dengan Sort dan Filter',
'subname' => null,
'edition' => null,
'date_release' => 'Oktober 2016',
'date_calc' => '0000-00-00',
'date_available' => '0000-00-00',
'ean' => 'SCOOPG115710',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => '',
'string_x3' => null,
'code' => null,
'code_x1' => null,
'code_x2' => 'SCOOPG115710',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '65000',
'price_max' => '0',
'price_dollar' => '65000',
'currency' => null,
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => 'dbd09e0e6dd07086c6cbb65f9f7c8639.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '0',
'dimension_y' => '0',
'dimension_z' => null,
'weight' => '0',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Excel menyediakan fitur pengelolaan data yang cukup lengkap dan dapat diandalkan. Sort dan Filter adalah fitur Excel yang sangat penting dalam pengelolaan data. Namun, banyak pengguna Excel yang belum mampu mengoptimalkan penggunaanya. Bahkan banyak pula yang belum mengenal fitur Sort dna Filter ini.
FItur Sort digunakan untuk mengurutkan data, sedangkan Filter digunakan unutk menampilkan data sesuai kriteria yang ditentukan. Dengan kedua fitur tersebut, Anda dapat mengelola data dengan mudah ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => null,
'created' => '2023-11-08 09:02:39',
'modified' => null,
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '65000',
'price_discount' => (int) 52000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1566473',
'search_cache_id' => '1180026',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2023-11-08 09:02:40',
'modified' => null
)
),
(int) 36 => array(
'SearchCache' => array(
'id' => '105098',
'product_id' => '2010000952924',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Trading Saham dengan Menggunakan Fibonacci Retracement',
'subname' => '',
'edition' => '',
'date_release' => 'Februari 2016',
'date_calc' => '2016-02-29',
'date_available' => '2016-02-29',
'ean' => '9786020281629',
'string_x1' => 'Satrio Utomo',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '716060348',
'code_x1' => '',
'code_x2' => '9786020281629',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '76800',
'price_max' => '0',
'price_dollar' => '76800',
'currency' => 'IDR',
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => 'b663c1f18e65f63f7474bb69811e9816.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '150',
'dimension_y' => '230',
'dimension_z' => '15',
'weight' => '350',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Buku ini adalah tentang bagaimana seorang trader bisa mengendalikan risiko yang dihadapinya dengan selalu melakukan positioning (posisi beli atau jual) berdasarkan sebuah rencana trading (trading plan). Bagi mereka yang masih dalam level pemula, pengetahuan mengenai suport dan resisten merupakan pengetahuan dasar yang harus dipelajari. Dan, bagi mereka yang tergolong intermediate dan mahir, penggunaan Fibonacci Retracement sebagai alat untuk memprediksi, dan sedikit pemahaman mengenai psikologi ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => '',
'created' => '2016-02-15 14:12:41',
'modified' => '2016-06-03 18:05:14',
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '76800',
'price_discount' => (int) 61440,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1500322',
'search_cache_id' => '105098',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-29 13:27:21',
'modified' => null
)
),
(int) 37 => array(
'SearchCache' => array(
'id' => '1161855',
'product_id' => '2010001183723',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Tip dan Trik Formula Excel 2007, 2010, 2013, 2016, 2019',
'subname' => '',
'edition' => '',
'date_release' => '0000-00-00',
'date_calc' => '0000-00-00',
'date_available' => '0000-00-00',
'ean' => '9786230028281',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '721050569',
'code_x1' => '623002828X',
'code_x2' => '9786230028281',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '75000',
'price_max' => '0',
'price_dollar' => '75000',
'currency' => 'IDR',
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => '90c54d2b7f5dd12e49f7990a911a9bbc.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '0',
'dimension_y' => '0',
'dimension_z' => '0',
'weight' => '300',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'out_of_stock',
'tax' => 'include',
'description_small' => 'Banyak pengguna Excel yang belum mampu menggunakan formula (rumus) Excel untuk menyelesaikan pekerjaan sehari-hari, baik di dunia bisnis, pendidikan, ataupun perkantoran. Padahal, salah satu kunci sukses untuk menguasai Excel adalah kemampuan dalam menggunakan formula secara efektif, efisien, dan profesional. Buku yang beredar pada umumnya hanya membahas penggunaan formula Excel untuk versi tertentu. Buku ini membahas secara lengkap, tip dan trik penggunaan formula Excel untuk versi 2007, 2010, ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => '',
'created' => '2021-10-21 14:34:33',
'modified' => '2021-12-06 15:08:05',
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '75000',
'price_discount' => (int) 60000,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1500321',
'search_cache_id' => '1161855',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-29 13:27:21',
'modified' => null
)
),
(int) 38 => array(
'SearchCache' => array(
'id' => '904813',
'product_id' => '2010001068488',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Kolaborasi Macro Excel dan Access untuk Mengelola Database',
'subname' => '',
'edition' => '',
'date_release' => 'Januari 2018',
'date_calc' => '2018-01-29',
'date_available' => '2018-01-29',
'ean' => '9786020452531',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => '718050041',
'code_x1' => '6020452530',
'code_x2' => '9786020452531',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '58250',
'price_max' => '0',
'price_dollar' => '58250',
'currency' => 'IDR',
'rating' => (int) 0,
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => 'cdaba70869925ce0001ece89dc564886.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '140',
'dimension_y' => '210',
'dimension_z' => '0',
'weight' => '320',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'eol',
'tax' => 'include',
'description_small' => 'Dalam pengelolaan database, Excel dan Access memiliki banyak kesamaan sehingga terkadang membuat kita menjadi bingung untuk menggunakan program yang mana. Sebagai program yang terpisah, masing-masing program mempunyai kelebihan. Access mempunyai kelebihan dalam database yang lebih terstruktur dan efisien, sedangkan Excel mempunyai kelebihan dalam kemudahan menganalisis data dan penyelesaian perhitungan yang rumit.
Pengelolaan database tentu akan lebih optimal jika Excel dan Access kita ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => '',
'created' => '2017-12-28 13:27:35',
'modified' => '2019-08-13 08:27:13',
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no',
'highlight' => '',
'price' => '58250',
'price_discount' => (int) 46600,
'discount_pct' => '20',
'availability' => array(
[maximum depth reached]
),
'count' => (int) 0
),
'BrandRule' => array(
'id' => '1658',
'brand_id' => '21',
'discount' => '20',
'store_id' => '3'
),
'ProductRank' => array(
'id' => null,
'product_id' => null,
'category_id' => null,
'store_id' => null,
'rank' => null,
'created' => null,
'modified' => null
),
'Category' => array(
'id' => null,
'name' => null,
'status' => null,
'parent' => null,
'child_ids' => null,
'parent_ids' => null,
'parent_ids_space' => null,
'cat_names' => null,
'weight' => null
),
'SearchCacheDetail' => array(
'id' => '1500554',
'search_cache_id' => '904813',
'key' => 'author',
'value_id' => '91779',
'value' => 'Yudhy Wicaksono & Solusi Kantor',
'created' => '2022-09-29 13:27:27',
'modified' => null
)
)
)
$current_author = array(
'People' => array(
'id' => '91779',
'name' => 'Yudhy Wicaksono & Solusi Kantor',
'description' => null,
'email' => null,
'website' => null,
'facebook' => null,
'twitter' => null,
'instagram' => null,
'google+' => null
),
'PeopleImage' => array()
)
$products_bought_relation = array()
$availability = array(
'text' => 'Stock di Gudang Supplier',
'color' => 'product_status_orange',
'qty' => '0'
)
$promo_combined = array()
$result = array(
'ProductBook' => array(
'id' => '2010001335467',
'EAN' => '9786230048319',
'code' => null,
'name' => 'Panduan Lengkap Formula dan Fungsi Excel 2007, 2010, 2013, 2016, 2019 untuk Pemula',
'subname' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'brand_discount_id' => null,
'dimension_x' => '140',
'dimension_y' => '210',
'dimension_z' => '0',
'shipping_weight' => '400',
'weight_flag' => 'brand',
'price' => '140000',
'price_dollar' => '140000',
'currency' => null,
'description' => '-',
'eol' => 'no',
'product_group_id' => null,
'department_id' => '0',
'review_rating' => '0',
'review_count' => '0',
'review_count_1' => '0',
'review_count_2' => '0',
'review_count_3' => '0',
'review_count_4' => '0',
'review_count_5' => '0',
'sold' => '0',
'status' => 'active',
'isbn' => null,
'isbn13' => '9786230048319',
'date_release' => '14 Juni 2023',
'date_available' => '0000-00-00',
'serie_id' => '0',
'serie' => null,
'edition' => null,
'pages' => null,
'tax' => 'include',
'status_available' => 'normal',
'redirect_ean' => null,
'data_source' => null,
'data_source_id' => null,
'data_source_updated' => null,
'created' => '2023-06-18 09:03:37',
'modified' => null,
'price_discount' => (int) 112000,
'discount_percent' => '20',
'dimension' => '140 mm x 210 mm'
),
'Brand' => array(
'id' => '21',
'name' => 'Elex Media Komputindo',
'name_web' => 'Elex Media Komputindo',
'website' => '',
'phone' => '',
'fax' => '',
'email' => '',
'facebook' => '',
'twitter' => '',
'cash_status' => null,
'cash_value' => null,
'credit_status' => null,
'credit_value' => null,
'consign_status' => null,
'consign_value' => null,
'status' => 'active',
'created' => '2014-04-16 17:55:16',
'modified' => '2014-04-16 17:55:19',
'department_id' => '1'
),
'SearchCache' => array(
'id' => '1177076',
'product_id' => '2010001335467',
'product_id_old' => null,
'serie' => '',
'serie_id' => '0',
'name' => 'Panduan Lengkap Formula dan Fungsi Excel 2007, 2010, 2013, 2016, 2019 untuk Pemula',
'subname' => null,
'edition' => null,
'date_release' => '2023-06-14',
'date_calc' => '0000-00-00',
'date_available' => '0000-00-00',
'ean' => '9786230048319',
'string_x1' => 'Yudhy Wicaksono & Solusi Kantor',
'string_x2' => 'Soft Cover',
'string_x3' => null,
'code' => null,
'code_x1' => null,
'code_x2' => '9786230048319',
'code_x3' => null,
'code_x4' => null,
'code_x5' => null,
'brand' => 'Elex Media Komputindo',
'brand_id' => '21',
'price_min' => '140000',
'price_max' => '0',
'price_dollar' => '140000',
'currency' => null,
'rating' => '0',
'reviewer' => '0',
'department' => 'Books',
'department_code' => 'book',
'department_id' => '1',
'picture' => '85ad53c15c5cf3b62ab987c1108a8798.jpg',
'picture_old' => null,
'product_group_id' => '0',
'parent_group_id' => null,
'dimension_x' => '140',
'dimension_y' => '210',
'dimension_z' => null,
'weight' => '400',
'qty' => '0',
'qty_supplier' => '0',
'sold' => '0',
'safety_stock' => '0',
'status' => 'normal',
'tax' => 'include',
'description_small' => '- ',
'preorder' => 'no',
'status_available' => 'normal',
'input_reset_status' => 'yes',
'redirect_ean' => null,
'created' => '2023-06-18 09:03:37',
'modified' => null,
'data_fetch' => 'no',
'data_fetch_date' => null,
'data_compare_ignore' => 'no'
),
'ProductCategory' => array(
(int) 0 => array(
'id' => '954606',
'product_id' => '2010001335467',
'category_id' => '62',
'category_text' => ':: Buku :: Anak-Anak :: Cerita :: General',
'category_ids' => '1,44,412,62',
'created' => '2023-06-18 09:03:38',
'modified' => null
)
),
'ProductImage' => array(
(int) 0 => array(
'id' => '846324',
'product_id' => '2010001335467',
'image' => '85ad53c15c5cf3b62ab987c1108a8798.jpg',
'weight' => '0',
'image_set_key' => null,
'image_set_id' => null,
'created' => '2023-06-18 09:03:38',
'modified' => null
)
),
'Detail' => array(
'author' => array(
(int) 91779 => 'Yudhy Wicaksono & Solusi Kantor'
),
'language' => array(
(int) 132 => 'Indonesia'
),
'format' => array(
(int) 100 => 'Soft Cover'
)
)
)
$rating = array(
'count' => (int) 0,
'rating' => (int) 0,
'count1' => (int) 0,
'count2' => (int) 0,
'count3' => (int) 0,
'count4' => (int) 0,
'count5' => (int) 0
)
$reviews = array()
$first_image = array(
'id' => '846324',
'l1' => '8',
'l2' => '5',
'image' => '85ad53c15c5cf3b62ab987c1108a8798.jpg'
)
$promo = array()
$unavailable = false
$meta = array(
'description' => 'Panduan Lengkap Formula dan Fungsi Excel 2007, 2010, 2013, 2016, 2019 untuk Pemula - Oleh: Yudhy Wicaksono & Solusi Kantor - -',
'og:title' => 'Panduan Lengkap Formula dan Fungsi Excel 2007, 2010, 2013, 2016, 2019 untuk Pemula - Oleh: Yudhy Wicaksono & Solusi Kantor',
'og:type' => 'book',
'og:image' => 'https://img.bukabuku.net/product/8/5/85ad53c15c5cf3b62ab987c1108a8798.jpg',
'og:url' => 'https://www.bukabuku.com/browses/product/9786230048319/panduan-lengkap-formula-dan-fungsi-excel-2007-2010-2013-2016-2019-untuk-pemula.html',
'og:description' => '-',
'twitter:title' => 'Panduan Lengkap Formula dan Fungsi Excel 2007, 2010, 2013, 2016, 2019 untuk Pemula - Oleh: Yudhy Wicaksono & Solusi Kantor',
'twitter:description' => '-',
'twitter:image' => 'https://img.bukabuku.net/product/8/5/85ad53c15c5cf3b62ab987c1108a8798.jpg'
)
$title_for_layout = 'Panduan Lengkap Formula dan Fungsi Excel 2007, 2010, 2013, 2016, 2019 untuk Pemula - BukaBuku.com - Toko Buku Online'
$url = 'browses/product/9786230048319/panduan-lengkap-formula-dan-fungsi-excel-2007-2010-2013-2016-2019-untuk-pemula.html'
$no_discount = array(
(int) 0 => (int) 2010001193678,
(int) 1 => (int) 2010001181750,
(int) 2 => (int) 2010001181767,
(int) 3 => (int) 2010001181736,
(int) 4 => (int) 2010001181743,
(int) 5 => (int) 2010001166962,
(int) 6 => (int) 2010001140221,
(int) 7 => (int) 2010001139553,
(int) 8 => (int) 2010001138846,
(int) 9 => (int) 2010001137580,
(int) 10 => (int) 2010001135500,
(int) 11 => (int) 2010001135135,
(int) 12 => (int) 2010001073796,
(int) 13 => (int) 2010001081821,
(int) 14 => (int) 2010001084686,
(int) 15 => (int) 2010001106319,
(int) 16 => (int) 2010001120469,
(int) 17 => (int) 2010001121046,
(int) 18 => (int) 2010001123521,
(int) 19 => (int) 2010001124139,
(int) 20 => (int) 2010001126324,
(int) 21 => (int) 2010001127574,
(int) 22 => (int) 2010001130055,
(int) 23 => (int) 2010001132219,
(int) 24 => (int) 2010001133490,
(int) 25 => (int) 2010001157434,
(int) 26 => (int) 2010001198611,
(int) 27 => (int) 2010001207054
)
$add_to_cart = 'normal'
$price_display = 'normal'
include - APP/View/Browses/product_book.ctp, line 60
View::_evaluate() - CORE/Cake/View/View.php, line 971
View::_render() - CORE/Cake/View/View.php, line 933
View::render() - CORE/Cake/View/View.php, line 473
Controller::render() - CORE/Cake/Controller/Controller.php, line 963
BrowsesController::product() - APP/Controller/BrowsesController.php, line 2268
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 110