Skip to content

Suji Smart Solutions

Computer & Mobile Tips, Tutorials, Video Lessons, Online Tests, Free Music & Free Games

  • Home
  • Online Tests
    • H5P Test Creator
    • SSS Online Tests
  • Tips-Tricks & Tutorials
    • Windows
    • MS Office
    • Best Websites
    • Best Mobile Apps
    • Video Editing
    • H5P Content
  • Free Music
  • Free Apps
  • Free Tools
    • Word Search Puzzle Creator
    • Crossword Puzzle Creator
    • Photo Resizer
    • HTML Thumbnail Creator – Free Tool for Creating HTML file with thumbnails of given pics
    • Typing Game – Typing Tutorial as a Game [FREEWARE]
  • School Tools
    • School Bonafide (bona fide) Certificate Preparation Tool- with Monthly Returns & Strength Abstract
    • SHAALA SIDDHI SELF EVALUATION REPORT TABLES PREPARATION TOOL
    • SSC INTERNAL MARKS ONLINE UPLOADING AND REGISTER PREPARATION TOOL
    • MDM (Mid-Day-Meals) Bill Preparation Tool- with Auto Rice Account
  • Web Designing
  • about me
  • Home
  • 2020
  • January
  • 18
  • MDM (Mid-Day-Meals) Bill Preparation Tool- with Auto Rice Account
School Tools

MDM (Mid-Day-Meals) Bill Preparation Tool- with Auto Rice Account

January 18, 2020 Admin

MDM (Mid-Day-Meals) Bill Preparation Tool- with Auto Rice Account

prepared in excel

MDM (Mid-Day-Meals) Bill Preparation Tool- with Auto Rice Account – Can be used in any school in Telangana or Andhra Pradesh or any state if the format is applicable.

 

 

SIMPLE TOOL TO PREPARE MDM BILL IN 10 Minutes

 

 

HOW TO USE?

 

 

After Downloading the file from the links given in the bottom of this post,

DOWNLOAD AVAILABLE IN 2 Types

  1. MDM without Castewise Entry
  2. MDM with Castewise Entry

Copy the file into your system folder, then open the file by Double-clicking

then Open the file,

after opening the file you will be presented with this (Primary Information )screen

 

 

STEP 1 :

The First Thing to Do…

-Enter School Name
– Enter Mandal
-Enter MDM Agency Name
-Enter MDM Agency Account Number
-Enter Month as (1-1-2020 for Jan,2020)

– Enter UPS RICE OPENING BALANCE IN KG

– Enter HS RICE OPENING BALANCE IN KG

-Enter COST PER CHILD UPS( 6th-8th)
– Enter COST PER CHILD HS (9th – 10th)
-Enter EGG Cost

-Enter UPS Strength
– Enter HS Strength

-Enter NEXT MONTH RICE REQUIREMENT  FOR UPS AND HS

THIS IS ONE TIME ENTRY

EVERY MONTH WE NEED TO CHANGE ONLY MONTH NAME

https://sujismartsolutions.in
MDM Tool Primary Information

 

STEP 2 :

IN THE ENTRY SHEET

ENTER DETAILS AS SHOWN BELOW
YOU CAN DO THIS DAILY OR WEEKLY

https://sujismartsolutions.in/gvOnlineTest/login.php
MDM Bill Preparation Tool Usage

 

STEP 3 :

YOUR MDM BILL WILL BE PREPARED AUTOMATICALLY

YOU CAN PRINT

  • 6-8-MDMMonthly
  • 6-8-EGG BILL

  • 9-10-MDM&EGG &

  • RICE ACCOUNT

IMPORTANT!

AFTER DOWNLOADING THE FILE ENTER PRIMARY DETAILS AND SAVE THE FILE

TAKE THIS FRESH PRIMARY INFORMATION GIVEN FILE EVERY MONTH

 

  • ENTER “EGG” on the Egg given day otherwise leave it BLANK
  • ENTER RICE RECEIVED  and RICE OPENING BALANCE in Kg only




DOWNLOAD by clicking below links 

    1. MDM without Castewise Entry
    2. MDM with Castewise Entry

if you get an error ( macros not enabled error ) do this

Click Excel File Menu –> Options –> Trust Center – Trust Center Settings
–>Macro Settings –> Enable All Macros
–>Protected View –> Uncheck All

–> Click OK, then close Excel and open the file again.
see this video…

 

 

hope this will help HMs,

Thank you…

Related Posts

School Tools

QUICK & EASY RESULT ANALYSIS TOOL FOR U-DISE TABLES

July 12, 2021July 12, 2021 Admin
School Tools

SHAALA SIDDHI SELF EVALUATION REPORT TABLES PREPARATION TOOL

February 25, 2020 Admin

Post navigation

Previous: Useful Website and Applications Links for Teachers – Part 1
Next: Best websites for school going kids & their parents-part1

Best deals in Electronics

Best Deals in Daily Use

Recent Posts

  • How to Install and Use KineMaster, Android Apps & Games on Computer or Laptop
  • How to Clean Storage in Windows – Windows Tips and Tricks-5
  • Setting different volume for different applications – Windows Tips and Tricks-2
  • How to Edit Videos with Free Video Editor OpenShot and Audacity
  • Creating Image Pairing in H5P
  • Creating Mark the Words in H5P
All Rights Reserved by [email protected]
Proudly powered by WordPress | Theme: Fairy by Candid Themes.