Compare data sets vbaPekerjaan
Projek ini sudah dikerjakan namun memiliki beberapa kekurangan terkait dengan aplikasinya. aplikasi ini digunakan untuk menyusun layout produk. ada banyak variabel dan kompleks di file berikut. kosongdelapan1229223642
Pekerjaan akan kami selesaikan secara bertahap selama sepekan. Dan tiap hari akan kami laporkan progressnya. 2 pekerjaan yang akan dikerjakan. 1. Dikembanbkan dengan sxript VBA Excel 2. Dikembangkan dengan script PHP & Mysql
Pembuatan aplikasi kasir dengan VBA
Hi All, Let me give you short rundown of the project. We have an existing excel VBA Program for room hotel booking. The program is very simple, as it only managed 4 rooms (in this case cabins). And it does the scheduling and booking quite well. We want to upgrade the existing excel file to be able to perform the following tasks: 1. Create authority level on who can edit and who can view the file, makes it more secure and less prone to input error. 2. Allow for easier multiple cabins booking, as of right now if the customer wants to book all four cabins, we need to individually input the booking. 3. Create a simple POS System for the cabins restaurant, this consist of simple food and beverages. Make it easy for us to add or discard items in the menu as it frequently change. 4. M...
Saya membutuhkan aplikasi android/VBA untuk menginput pengeluaran harian perusahaan (petty cash) yang nantinya akan diexport ke excel untuk pengolahan data lebih lanjut. Sistemnya seperti aplikasi moneypro. Tinggal klik saja biaya yang cocok untuk nantinya diinput nominal biayanya.
Kami biasa mendapat laporan harian dari banyak peer kami. Kami perlu megkoleksinya lalu merekapnya di sheet terpisah dengan tampilan output tertentu dengan satu tombol klik sudah bisa merekap banyak file dalam 1 sheet xls.
Gambaran program : 1. Barangnya adalah ikan 2. Data Ikan : Nama Ikan dan Size (jadi, 1 jenis ikan bisa mempunyai bbrp size) 3. Alur prosesnya : a. Ikan segar ditimbang (output : KG).. kmdn dibekukan. b. Ikan beku dikemas dlm karung/koli (output : KG dalam 1 koli & Jumlah Koli) .. kmdn masuk gudang. (Note : tulisan ".. Kg" ditulis di karung). c. Ikan kemasan karung dijual/keluar gudang (output : KG dalam 1 koli & Jumlah Koli) 4. Data yg diinput & OUTPUT yg bisa diprint : - Nilai KG (saat proses timbang, saat dikemas dalam karung dan saat keluar gudang ) - Jumlah KOLI (saat dikemas dan saat keluar gudang) Demikian gambarannya, cukup sederhana.. Contoh data dan penjelasannya saya sertakan dalam attachment file Excel. Terima kasih.
DESAIN LINE ART DRAWING Hai Gan/Sis… Saya sedang mencari desain Line Art Drawing untuk kebutuhan Desain Kaos bertema “JOGJA” Style desainnya silahkan lihat di link ini : Nah yang mau dibuat ada beberapa desain tentang Jogja, Jika saya cocok, saya ingin kerja sama jangka Panjang, karena nantinya akan banyak desain yang dibikin. Kriterianya bisa buat Line Art seperti link di atas ya Gan/Sis, apalagi bisa memahami Jogja karena akan lebih mudah briefnya nanti. Nah dimohon buat Agan dan Sista Ketika ngebid cantumin harga perdesain sama portfolio Line Art Drawingnya ya. Silahkan kasih contoh desain Line Art Drawingnya Tugu Jogja beserta aktivitasnya (bebas imajinasi agan sista). agar lebih mudah saya kurasi (saya ingin jangka panjang), jadi pengen nyari
English I work in the Ministry of Public Works PUPR as an analyst for Roads and Bridges. I want to do data scrapping on the website monitoring (website requires login, I will give the login data later to the bidding winner) so that the data will be entered and updated automatically into my Excel document using the VBA Excel code Indonesia: Saya bekerja di Pemerintahan Kementerian PUPR sebagai analis Jalan dan Jembatan. Saya ingin melakukan scrapping data pada website emonitoring (website membutuhkan login, data login akan saya berikan nanti pada pemenang bidding) sehingga data tersebut akan masuk dan terupdate otomatis ke dalam document excel saya menggunakan kode VBA Excel
Bantu saya menyempurnakan aplikasi saya dengan membuatkan - username otomatis pada form penjualan dan pembelian - menyempurnakan hak akses - membuatkan list meja yg aktif
hallo pak saya yg dari facebook itu mau dibuatkan aplikasi asuransi data polis Excel VBA
Mengaktifkan scroll mouse (bukan scroll bar) pada userform, scroll harus kompatibel dengan win 64.
Proyek ini bertujuan untuk simplifikasi waktu pembuatan laporan dari data excel ke data word dengan menggunakan VBA Makro
expert dalam menggunakan hyperlink exel (googlesheet) mengerti pembukuan untuk proyek mengerti pembukuan kantor (jurnal umum,buku kas, neraca saldo,laba rugi,neraca casflow) bisa di kerjakan dalam 1 minggu dengan templet yang sudah ada )saya akan memberikan templet untuk pemb...neraca saldo,laba rugi,neraca casflow) bisa di kerjakan dalam 1 minggu dengan templet yang sudah ada )saya akan memberikan templet untuk pembukuan kantor serta templet untuk pembukuan proyek) untuk pembukuan kantor hanya jurnal umum dan kas proyek yang ter isikan, yang lain harus otomasis ngelink untuk lapangan pada umumnya sudah jadi tinggal di link ke pembukuan utama kantor tidak menggunakan VBA, karena di googlesheet tidak bisa contoh file ada di bawah, tp untuk real nanti saya kasih yang link ke google...
Jadi proyek ini tujuannya adalah untuk mepersingkat waktu input data excel dgn VBA Makro dan kalo bisa data tersebut langsung terhubung ke word, untuk contoh hasil atau hasil ketik manualnya adalah sebagai berikut
Saya punya data X dan data telepon yang dimasukkan ke excel. Data X ini perlu untuk bisa dikirimkan secara otomatis ke WA cukup dengan menekan tombol saja di worksheet Excel
hallo pak. Jika bapak lagi butuh bantuan untuk menyelesaikan project tentang excell. mungkin bapak berkenan hire saya. saya bekerja di salah satu perusahaan, dan saya pernah buat training formula excell dan pernah membuat payroll calculation dengan vba excel. terima kasih
I need VBA macro button to combine hundreds of workbooks contain several sheets into one sheet only. You can see the sample of raw workbooks (kd10s file) to extract into one sheet in tblairjoman.xls. You can download to see what kind of data that i need. If you can, please attach of the result your vba macro button that fits my demand then i'll give you award and complete the job and payment. NOTE : sheet 1 is for data compilation, sheet 2 contains vba macro button with link folder workbooks to extract. If you dont understand, please dont bid.
Saya memerlukan sejumlah desain grafis untuk proyek Marketing Campaign #YANGPENTINGORI Tujuan campaign: Memberikan persepsi bahwa Footprints Indonesia menjual barang-barang yang original, sehingga merasa aman untuk membeli sneakers dan apparel : - banyak orang tertipu dalam membeli sneakers, bukan banyak lagi, banyak sekali - banyak penjual ...bisa membedakan ori dan fake - ga nyaman bahannya, presisinya, Solution: - peryakin bahwa Footprints jual barang original - bagaimana tahunya bahwa ini original: QC Check, Legit Spots - berani bertanggung jawab bila tidak legit - bisa COD - video legit check - testimoni Graphic design material needed: - campaign logo - template video - template post instagram - frame testimoni customer - 3 sets advertisement (AIDA framew...
Melakukan sejumlah pekerjaan Excel generated report, rekap data transaction,compare data trx H+1,cek incoming dan outgoing payment ,buat analisa kerjaan
yang kami inginkan anda bisa mendesign ikon dengan media gambar berupa sprei berukuran LxPxT (120 x 200 x 15) dan (100 x 200 x 15 ) dalam beberapa tema : - space - football - robot icon (movie atau cartoon) - dll (asalkan bukan makhluk bernyawa yang di gambar menjadi kartun atau siluet)
...tertarik utk membuat "quick report" pengukuran vibrasi yg berbasis VBA macro excel. Jadi saya punya tool pengukuran vibrasi yaitu fluke 805. Tool ini dilengkapi dg template yg berbasis vba macro excel utk menampilkan nilai2 pengukuran vibrasi dan grafik trendingnya saat tool ini dikoneksikan dg komputer. Saya punya ide modifikasi pada tool ini utk membantu mempercepat penyajian laporan. Modifikasinya adalah 1. menampilkan nilai2 dan grafik tadi pada "form data hasil pengukuran vibrasi" yg formatnya sdh ada di perusahaan saya. 2. Sistem ini jg nantinya diharapkan dilengkapi dengan formula utk memberikan "rekomendasi dan analisa" secara otomatis dr nilai2 pengukuran yg ada. Berikut saya lampirkan form, template bawaan tool, dan da...
...tertarik utk membuat "quick report" pengukuran vibrasi yg berbasis VBA macro excel. Jadi saya punya tool pengukuran vibrasi yaitu fluke 805. Tool ini dilengkapi dg template yg berbasis vba macro excel utk menampilkan nilai2 pengukuran vibrasi dan grafik trendingnya saat tool ini dikoneksikan dg komputer. Saya punya ide modifikasi pada tool ini utk membantu mempercepat penyajian laporan. Modifikasinya adalah 1. menampilkan nilai2 dan grafik tadi pada "form data hasil pengukuran vibrasi" yg formatnya sdh ada di perusahaan saya. 2. Sistem ini jg nantinya diharapkan dilengkapi dengan formula utk memberikan "rekomendasi dan analisa" secara otomatis dr nilai2 pengukuran yg ada. Berikut saya lampirkan form, template bawaan tool, dan da...
Salam kenal. Saya Sandro. Saya tertarik utk membuat "quick report" pengukuran vibrasi yg berbasis VBA macro excel. Jadi saya punya tool pengukuran vibrasi yaitu fluke 805. Tool ini dilengkapi dg template yg berbasis vba macro excel utk menampilkan nilai2 pengukuran vibrasi dan grafik trendingnya saat tool ini dikoneksikan dg komputer. Saya punya ide modifikasi pada tool ini utk membantu mempercepat penyajian laporan. Modifikasinya adalah 1. menampilkan nilai2 dan grafik tadi pada "form laporan rekomendasi dan analisa vibrasi" yg formatnya sdh ada di perusahaan saya. 2. Sistem ini jg nantinya diharapkan dilengkapi dengan formula utk memberikan "rekomendasi dan analisa" secara otomatis dr nilai2 pengukuran yg ada. apakah Anda bisa membantu say...
Salam kenal. Saya Sandro. Saya tertarik utk membuat "quick report" pengukuran vibrasi yg berbasis VBA macro excel. Jadi saya punya tool pengukuran vibrasi yaitu fluke 805. Tool ini dilengkapi dg template yg berbasis vba macro excel utk menampilkan nilai2 pengukuran vibrasi dan grafik trendingnya saat tool ini dikoneksikan dg komputer. Saya punya ide modifikasi pada tool ini utk membantu mempercepat penyajian laporan. Modifikasinya adalah 1. menampilkan nilai2 dan grafik tadi pada "form laporan rekomendasi dan analisa vibrasi" yg formatnya sdh ada di perusahaan saya. 2. Sistem ini jg nantinya diharapkan dilengkapi dengan formula utk memberikan "rekomendasi dan analisa" secara otomatis dr nilai2 pengukuran yg ada.
I have some work, in an Excel spreadsheet. Halo freelancer. Salam kenal. Saya Sandro. Saya tertarik utk membuat "quick report" pengukuran vibrasi yg berbasis VBA macro excel. Jadi saya punya tool pengukuran vibrasi yaitu fluke 805. Tool ini dilengkapi dg template yg berbasis vba macro excel utk menampilkan nilai2 pengukuran vibrasi dan grafik trendingnya saat tool ini dikoneksikan dg komputer. Saya punya ide modifikasi pada tool ini utk membantu mempercepat penyajian laporan. Modifikasinya adalah 1. menampilkan nilai2 dan grafik tadi pada "form laporan rekomendasi dan analisa vibrasi" yg formatnya sdh ada di perusahaan saya. 2. Sistem ini jg nantinya diharapkan dilengkapi dengan formula utk memberikan "rekomendasi dan analisa" secara otomat...
Membuat rumus Macro Excel untuk mempermudah pekerjaan administrasi di kantor saya. Rumus untuk perhitungan komisi marketing, komisi manajer, gaji karyawan, perhitungan pajak, stock barang.
Saya ingin membuat sebuah website yang sangat mirip dengan Budget Rp 1.500.000,- di luar hosting dan domain. Silahkan di compare terlebih dahulu. Project ini Penting namun tidak mendesak.
Menulis artikel tentang excel, menginput data, membuat program vba excel sederhana
Informasi Manajemen Akuntansi Menggunakan VBA
Menyelesaikan entri data E-SPT (Pajak Keluaran) dalam hitungan detik secara otomatis. Ratusan data Faktur Pajak dengan format (*.xls) akan dirangkum ke dalam sebuah file (*.csv) sehingga mudah di impor ke dalam software E-SPT ver. 1.5.0.0. (keberhasilan 100%)
Saya perlu bantuan vba excel expert untuk salah satu proyek yang saya kerjakan. Proyek ini tentang menggabungkan dua Worksheets (Perusahaan dan Kontak) menjadi satu Report. Kunci pencocokan adalah nama Perusahaan Dalam satu nama company bisa ada 1 atau lebih nama kontak. Beberapa nama kontak yg terkorespondensi dalam 1 nama perusahaan perlu dipisahkan dengan line break. Jadi semuanya dalam 1 cell saja. Nama University dan tahu lulusan, alamat email, dan catatan juga perlu digabungkan per line. Tetap dalam 1 cell pada row yang matched. Begitupun no telp perusahaan digabungkan dengan no hp dari tab kontak (jika ada). Report harus dalam Format yang kami tentukan (warna, border, page break, orientation, dll) Proyek ini relative mudah, bagi yang expert mungkin hanya perlu...
Looking for an expert in Oracle Integration Cloud to assist with my tasks in application integration and process automation. The integration should compare two files on the FTP, and send an email to the recipients. - In-depth understanding of Oracle Integration Cloud - Strong knowledge in Application integration - Process automation skill set - Ability to advise on best integration strategies
...institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements without disrupting existing functionalities. Key Features to Include: Advanced User Management: Implement a secure login system with multi-tier user roles and permissions. Dynamic Data Handling: Design the system to manage large volu...
I'm in need of a dynamic and vibrant logo for Wheel Master Dispatch Solutions, my trucking dispatch business. The chosen colors should incorporate shades of Pink, White, Purple, and a hint of black. I'm leaning towards a retro theme that successfully captures the essence of the transportation industry. Essen...candidates for this project should have: - Proven design experience, especially with retro themes - Strong portfolio in logo design - Proficient in delivering high-quality JPEG files - Knowledge about the trucking industry would be a bonus. Please, when applying, show examples from your portfolio that best represent your capabilities in meeting this brief. I'm anticipating an eye-catching logo that sets our business apart in the industry. Looking forward to ...
...organizational skills to assist in a product sourcing and data entry project. This task involves purchasing Orangina soft drink from at least two different stores, entering specific product data on our platform, labeling the purchased items clearly, and preparing for their shipment to Ireland. **Task Overview:** - **Purchase Orangina:** Secure 29 bottles of Orangina from a minimum of two distinct retail locations. Preference for varying shops to compare regional stock variances. - **Data Entry:** Log into our online platform to input two critical pieces of information for each product: the best before date and the store from where it was purchased. - **Labeling:** Each of the 29 bottles must be labeled in a manner that correlates with the entered data...
...organizational skills to assist in a product sourcing and data entry project. This task involves purchasing Orangina soft drink from at least two different stores, entering specific product data on our platform, labeling the purchased items clearly, and preparing for their shipment to Ireland. **Task Overview:** - **Purchase Orangina:** Secure 4 bottles of Orangina from a minimum of two distinct retail locations. Preference for varying shops to compare regional stock variances. - **Data Entry:** Log into our online platform to input two critical pieces of information for each product: the best before date and the store from where it was purchased. - **Labeling:** Each of the 4 bottles must be labeled in a manner that correlates with the entered data, ...
...comprehensive warehouse inventory replenishment tracking system for our Fastener drawer at Home Depot. The system should have a focus on reporting and analytics, real-time bin shrink, and work with an electronic keypad and analog/digital interface. Key Features: - **Reporting and Analytics:** The system should provide insightful reports on inventory levels and trends. This will help us make data-driven decisions. - **Real-Time Bin Shrink:** I need to know if the quantity of items in the bin matches the recorded amount. - **Interface:** A mobile app interface will be ideal, making it easy for staff to work on the go. Inventory Tracking: - The system should involve manual entry for inventory tracking. The system should be user-friendly and easy to use for our staff. ...
I'm looking for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based on ...
We are looking for native-level fluency in Japanese with fluent English. If you qualify as Data entry, Copywriter, Proofreader or Translator kind of specialist, welcome to our linguistic project where you will assist in training a Large Language Model (Artificial Intelligence) Work format: remote Schedule: choose a 5-hour shift within the time range 14:00 - 23:00 Duration: long-term project Contract: NDA You have a great opportunity to get: - Rate 12,5 $ - Experience in a leading-edge field of training Artificial Intelligence - Work for an advance American IT company - Free training provided by the company and the Client - Creative and dynamic tasks, very different from monotonous translation Your assignment: The tasks will contain a question and 2 answers to it written in ...
...Construct a simulation model using the information provided to you above, and your average model as the starting point. a. Unit of interest – a DNA sample collected by a CSI. That is, each sample must be modelled individually. b. Each iteration of the simulation is one week of processing samples. c. Use the same assumptions as for the Task 2 model. d. You MUST use @RISK. Do NOT save raw simulation data in the file. e. You must save all your work in one file saved on your OneDrive account. There are no exceptions to this. See Saving and Sharing instructions on pages 10-12. f. You will need to determine the appropriate probability distribution for each input. g. Run the model for 10,000 iterations. h. Set the random number seed to the last four digits of your Student ID numbe...
Overview: We are seeking a skilled UI/UX designer to create the design for a fantasy sports app. The app will provide users with an engaging platform to participate in various fantasy sports leagues and competitions. Key Features: Splash Screen: A visually appealing splash screen that captivates users' attention and sets the tone for the app experience. App Opening Screen: A seamless and intuitive app opening screen that guides users into the main interface of the app. Onboarding Screen: A user-friendly onboarding process that allows users to register/login using their mobile number and OTP authentication. Registration/Login: Smooth and secure registration/login process, integrating mobile number verification for authentication. Refer Code Screen: After successful login o...
I am seeking a skilled graphic designer with sufficient experience in logo design to create a unique and attractive logo for my business that captures our brand identity, attracts our target audience, and sets us apart from our competitors. I expect: • Showcasing of your past experience relevant to logo design • Demonstration of creative thinking and original design ideas • Understanding of modern design trends and aesthetics Skills Needed: • Proficient in Adobe Illustrator or similar design software • Strong portfolio demonstrating design skills • Creativity and ability to implement brand personality into design • Understanding of target audience and market trends.
Looking for an experienced freelancer to fix a problematic issue in an Android Studio mobile application. Due to large data sets, a specific page isn't functioning properly on some mobile phones (Real Me), which needs to be efficiently addressed. Primary Tasks: - Implement Pagination and Lazy Loading to mitigate issues around large dataset rendering - Optimize data representation from an API that returns text Ideal candidate: - Must have a compelling portfolio demonstrating experience with similar tasks in Android Studio. No need for extensive proposals, I am more interested in your experience and how you've demonstrated it in the past. Let's fix this quick and clean!
I need some help with ...need some help with a data model I created in Power Pivot. I have 2 data sets: one is Sales and the other is Stock. I have added both data sets to my data model and am now trying to create a pivot which pulls data from both tables. My Sales table pulls the data perfectly but the Stock table does not. Some context... When I pulled the data into the data model I added a column which I called DataModelLink. This created a 1 (Sales) to many (Stock) relationship between the two tables. As an example, I tried to pull the data of one particular style which had one line in the Sales table but 2 lines in the Stock table. For this reason, my Pivot is only reading one of two of the lines on the S...
...tutor with an intermediate level understanding of Finite Mathematics, to assist me with my course work. The specific topic focus I require guidance on, has been left open to include Sets and Counting, Probability, and/or Linear Equations, depending on the freelancer's area of expertise. Ideal Skills Include: - Understanding of various Finite Mathematics topics - Proven tutoring skills - Experience with teaching or tutoring in these areas - Ability to explain complex mathematical concepts in a simplified manner Please include in your proposal: - An outline of your experience with Finite Mathematics particularly in Sets and Counting, Probability, and/or Linear Equations. - Your teaching methodology - Your availability and proposed schedule This is a great opportunity...
I'm seeking an expert to assist with the complete transfer from my current WooCommerce setup to my own account. The data size is between 1GB to 5GB. Key Requirements: - Expertise in WooCommerce: You should have a deep understanding of WooCommerce and its functionalities. - Data Migration Experience: Proven experience in transferring large data sets in WooCommerce efficiently and securely. - Ownership Transfer Knowledge: Familiarity with the process of transferring ownership rights in WooCommerce, ensuring a smooth transition without data loss or disruptions. Your role will be to handle the migration process while ensuring the integrity and security of all transferred data. I'm looking for someone who can guarantee a seamless transfer, ...
PLEASE SEE ZIP FILE 4 sets of Numbers - 1 to 13 (1,2,3,4,5,6,7,8,9,10,11,12,13) 4 Colors include four shapes - triangle -square -circle -Heart Name of cards: THE H CARDS Please share your portfolio and any related projects you've worked on. Looking forward to your bid!
