KEMBAR78
DR - MG MG Min Min Aung Aung DR - Su Su DR - Myo Myo | PDF | Southeast Asia | Myanmar
Scribd
Upload
114 views15 pages

DR - MG MG Min Min Aung Aung DR - Su Su DR - Myo Myo

The document contains employee information including name, age, position, and salary. It also includes sales data with date, branch, salesperson and amount. Various tables provide information on holidays, townships, product codes and prices.

Uploaded by

XaronAngel
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
114 views15 pages

DR - MG MG Min Min Aung Aung DR - Su Su DR - Myo Myo

The document contains employee information including name, age, position, and salary. It also includes sales data with date, branch, salesperson and amount. Various tables provide information on holidays, townships, product codes and prices.

Uploaded by

XaronAngel
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 15

Dr.

Mg Mg
Min Min
Aung Aung
Dr.Su Su
Dr.Myo Myo
Mg Mg 1/1/2012

Min Min 1/8/2013 Min Min

Myo Myo 8/1/2014 လု ပ္သက္(5)ႏွစ္အထက္သူေတြကို ရ္ိုက္ခြင့္ျပဳခ်င္တာ

Ko Ko 9/1/2015

Kyaw Kyaw 1/19/2016


Sr Name Age Position Salary

1 Daw Sandar Aung 37 Chief Accountant 650,000

2 U Yan Paing 34 Marketing 400,000

3 Daw May Myint 32 Sales Admin 270,000

4 Daw Ei Khaing Kyaw 28 Promoter 310,000

5 U Nyi Nyi Khine 40 Manager 530,000

6 Ma Kyi Thu Zaw 37 Office Staff 300,000

7 Daw Mya Thet Aung 30 HouseKeeper 510,000

8 Ma Ei Thiri Lwin 24 Sales 220,000

9 Ma Khin Lay Nwe 21 Marketing 220,000

10 Ma Han Nwe Soe 26 Sales 350,000

11 Ko Hein Depa 36 Marketing 400,000

မိန္းကေလးျဖစ္ၿပီး အသက္ (၃၀)ေက်ာ္ ၊ လစာ (၅၀၀၀၀၀) ႏွင့္ အထက္ သမားေတြကု ိ Column F တြင္ စတား(***) သုံ းခု ျပေအ
င္ စတား(***) သုံ းခု ျပေအာင္ Formula ေရးပါ။
Month Working Day Holidays

Jan 1/1/2017 New Year

Feb 1/4/2017 Independent Day

Mar 2/12/2017 Union Day

Apr 3/1/2017 War Soe Fullmoon Day

May 4/13/2017 Thingyan

Jun 4/14/2017 Thingyan

Jul 4/15/2017 Thingyan

Aug 4/16/2017 Thingyan

Sep 4/17/2017 Thingyan

Oct 5/1/2017 Labour Day

Nov

Dec
Column G တြင္ ရက္အ လု ိက္ ေရာင္းရေငြ စု စု ေပါင္းအား Formula ေရးၿပီး Autofill သုံ းပါ။

Sales Date Branch Sale Person Amount Days Total Amt


1/1/2016 Nay Pyi Taw Aung Aung 410,000 Mon
1/3/2016 Nay Pyi Taw Yan Paing 180,000 Tue
1/5/2016 Mandalay Mg Mg 163,000 Wed
1/7/2016 Mandalay Aung Aung 48,000 Thu
1/9/2016 Nay Pyi Taw Mg Mg 37,000 Fri
1/11/2016 Nay Pyi Taw Mg Mg 450,000 Sat
1/13/2016 Yangon Mya Mg 180,000 Sun
1/15/2016 Nay Pyi Taw Aung Aung 62,000
1/17/2016 Nay Pyi Taw Aung Aung 298,000
Name Gender
U Aung Myint
U Min Aung
Daw Khin Thet
Daw Aye New
Daw Cho Cho
U Lin Aung
U Htay Maung
Daw Tint
Daw Aye Mar
U Wai Lin
U Aung Thiha
City Yangon Mandalay Taungoo
Yangon Bahan Aung Myay Thar Zan Taungoo
Mandalay Botataung Chan Aye Thar Zan Oktwin
Taungoo Hlaing ahar Aung Myay Tantabin
Hlaingthaya Chan Mya Thar Si Yedashe
Insein Pyi Kyi Tan Kon Pyu
Kamayut Kyauktaga
Kyauktada Kyaukkyi
Kyimyindaing
Lanmadaw
Latha
Mayangon
City Township
Sr Date Code Qty Price Amt

1 1/1/2016 SPBL-16 1

2 1/2/2016 TS-42 1

3 1/3/2016 JM-28 2

4 1/4/2016 JM-28 1

5 1/5/2016 SP-18 1

6 1/6/2016 SPBL-12 1

7 1/7/2016 JM-18 1

8 1/8/2016 JM-40 1

9 1/9/2016 TS-40 1

10 1/10/2016 SPBL-16 1

11 1/11/2016 SPBL-18 1

12 1/12/2016 TS-26 1

13 1/13/2016 JM-28 1

14 1/14/2016 JM-28 2

15 1/15/2016 TS-26 1

16 1/16/2016 SP-18 1

17 1/17/2016 SPBL-16 1

18 1/18/2016 SPBL-16 1

19 1/19/2016 SPBL-18 1

20 1/20/2016 SPBL-18 1

21 1/21/2016 SPBL-12 1

22 1/22/2016 JM-25 1
23 1/23/2016 TS-26 1

24 1/24/2016 SP-18 1

25 1/25/2016 JM-35 1

26 1/26/2016 JM-28 2

27 1/27/2016 SP-18 1

28 1/28/2016 SP-18 1

29 1/29/2016 SPBL-16 1

30 1/30/2016 JM-25 1

31 1/31/2016 JM-28 1

32 2/1/2016 JM-30 1

33 2/2/2016 SPBL-18 1

34 2/3/2016 JM-35 1

35 2/4/2016 TS-26 1

36 2/5/2016 JM-16 2

37 2/6/2016 SPBL-16 2

38 2/7/2016 TS-40 2

39 2/8/2016 SPBL-12 1

40 2/9/2016 JM-30 2

41 2/10/2016 JM-28 1

42 2/11/2016 SP-18 1

43 2/12/2016 SPBL-16 2

44 2/13/2016 JM-25 2

45 2/14/2016 TS-42 2
46 2/15/2016 JM-16 1

47 2/16/2016 TS-40 2

48 2/17/2016 JM-40 2

49 2/18/2016 TS-40 2

50 2/19/2016 SP-18 2

51 2/20/2016 JM-18 1

52 2/21/2016 JM-40 2

53 2/22/2016 TS-26 2

54 2/23/2016 JM-25 1

55 2/24/2016 TS-40 2

56 2/25/2016 TS-42 1

57 2/26/2016 JM-16 1

58 2/27/2016 TS-26 1

59 2/28/2016 JM-16 1

60 2/29/2016 TS-40 1

61 3/1/2016 JM-18 2

62 3/2/2016 TS-26 2

63 3/3/2016 TS-42 1

64 3/4/2016 SPBL-18 1

65 3/5/2016 TS-40 2

66 3/6/2016 TS-26 1

67 3/7/2016 JM-40 1

68 3/8/2016 JM-25 2
69 3/9/2016 JM-30 2

70 3/10/2016 SP-18 1

71 3/11/2016 JM-28 1

72 3/12/2016 JM-30 1

73 3/13/2016 JM-16 1

74 3/14/2016 JM-40 1

75 3/15/2016 SP-18 1

76 3/16/2016 TS-40 1

77 3/17/2016 JM-18 1

78 3/18/2016 SPBL-18 1

79 3/19/2016 SP-18 2

80 3/20/2016 JM-28 2

81 3/21/2016 SPBL-16 2

82 3/22/2016 SP-18 2

83 3/23/2016 JM-28 2

84 3/24/2016 SPBL-18 1

85 3/25/2016 SPBL-12 1

86 3/26/2016 JM-30 1

87 3/27/2016 SPBL-18 2

88 3/28/2016 JM-25 2

89 3/29/2016 JM-40 2

90 3/30/2016 SP-18 2

91 3/31/2016 TS-42 2
92 4/1/2016 TS-42 1

93 4/2/2016 JM-30 2

94 4/3/2016 SPBL-16 2

95 4/4/2016 JM-30 2

96 4/5/2016 JM-30 1

97 4/6/2016 JM-35 1

98 4/7/2016 JM-25 2

99 4/8/2016 JM-30 2

100 4/9/2016 JM-25 1

101 4/10/2016 SPBL-18 1

102 4/11/2016 JM-28 1

103 4/12/2016 JM-35 1

104 4/13/2016 SP-18 2

105 4/14/2016 JM-40 2

106 4/15/2016 SPBL-12 2

107 4/16/2016 TS-42 1

108 4/17/2016 JM-16 2

109 4/18/2016 JM-35 2


SIZE JM TS SP SPBL

12 6,000 2,800 4,200 3,200

16 6,500 3,200 5,000 4,000

18 7,000 3,500 5,300 4,300

25 8,000 5,500 5,700 4,700

26 9,200 6,500 6,000 5,000

28 9,500 7,500 6,400 5,400

30 10,000 8,500 6,800 5,800

35 11,000 9,500 7,200 6,200

40 12,000 10,500 7,600 6,600

42 14,000 11,500 8,000 7,000

You might also like