Excel file help?

[alim khan]

expert mai sales ke taluk se ek file banana chahta hun.mere dus rout hain aur har route per do customer hain.mere paas char products hain(waise to customer aur prod. zyada hain per maine file mein itne hi batae hain).mai har rout pe mahine mein do ya teen bar jata hun.har rout pe kuch na kuchh bikta hai.mai apne is sale ka data banana chahta hun ke maine kis rout per kis tarikh ko kon se customer ko kya aur kitna becha.MUJHE EK SHEET MEIN YEH SAMMURY CHAHIYE.

(A) TOTAL SHOP = JITNI SHOP AREA MEIN HAIN
(B) PRODUCTIVE SHOP = JITNI SHOP MEIN MAAL BECHA
(C) PRODUCTIVITY = =(B/A)
(D) VISITED SHOP = JITNI SHOP MEIN MAI GAYA THA
(E) AREA coverage = =(A/D)
TOTAL ITEM = JO MERE PAAS HAIN
(G) ITEM SOLD = JO MINE BECHEN
(H) INVOICE = MAHINE MEN AGAR DO BAR MAAL BECHA TO DO.

ab aap logon se yeh guzarish hai ke mujhe aisi file bana ke dein ke jis mein mai apne customer ka data saal bhar tak bana sakun.



WSLM::