Description
1- Need the grade of each ID ( if the ID not exist, highlight the sell and assume entry- level)
2- Need the sector of each ID
3- Need the level of each Grade
4- Need the total cost of each level
5- Need the total of the cost of the program + total cost of level
Another sheet with explain how you did each
1- Total budget of 2023 programs
2- the average cost of each sector
3- the expected budget of 2024 ( two scenario (Best Case, Average Case)
Unformatted Attachment Preview
Grade
ID
9
389
9
389
9
411
9
411
9
411
7
1029
953
8
1077
10
501
A
A
11
499
7
1029
7
1051
7
1051
8
971
7
1032
1031
8
1002
484
486
473
900
900
421
942
Sector
Level
916
916
916
487
958
1035
498
1046
972
1015
1014
1062
493
384
971
1047
921
925
1019
1005
1040
498
973
1020
1048
972
391
1001
1014
478
1027
1021
429
1047
475
1019
1004
1007
1051
1008
1061
407
1035
1046
1039
1015
470
1041
1041
490
502
483
1027
492
965
480
478
1039
1021
1041
125
492
430
961
932
932
412
1013
494
494
1009
940
483
1032
494
1002
1039
913
1046
490
1027
915
1009
1035
1053
1007
961
1041
1034
1021
973
1041
1036
1000
956
483
1035
1039
956
903
1036
963
962
925
1110
1055
1057
1020
1022
384
900
1032
1002
915
913
1053
1061
429
915
951
936
492
485
491
389
1029
1083
958
963
964
951
483
1089
973
1022
970
1015
101
1008
977
1086
515
1102
957
1034
1090
1021
1053
1032
1102
1040
1039
972
1042
1007
930
958
964
977
930
384
101
1048
1108
1104
484
1063
391
1024
423
943
916
1039
1009
1013
1019
1102
1083
1086
1070
1041
1061
1103
470
935
421
467
491
430
97
395
482
498
501
473
502
493
500
480
485
474
921
515
486
1091
1034
957
1052
1109
1029
1047
499
972
1014
487
1005
1021
478
389
461
391
1040
411
484
101
1062
1020
973
429
475
953
Place
Period of Time
Cost of the Program
External
4
0
Enternal
10
0
Enternal
10
0
External
4
0
Local
4
0
Enternal
10
0
Enternal
7 weeks
0
Enternal
5
7854.36 SR
Enternal
10
0
External
3
0
External
5
0
Enternal
10
0
External
5
0
Enternal
5
7854.36 SR
Local
4
0
Enternal
10
0
External
5
0
External
3
0
External
5
0
Enternal
10
0
Enternal
10
0
Enternal
5
7854.36 SR
Local
4
0
External
3
0
External
5
0
External
5
0
External
10
0
Local
4
0
External
5
0
Enternal
10
0
Local
5
0
Enternal
5
7854.36 SR
Enternal
10
0
Enternal
5
7854.36 SR
Enternal
10
0
Enternal
5
7854.36 SR
Enternal
10
0
Enternal
10
0
Enternal
5
7854.36 SR
Local
4
0
Enternal
5
7854.36 SR
Enternal
10
0
Enternal
7 weeks
0
Enternal
7 weeks
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
5
7854.36 SR
Enternal
10
0
Enternal
10
0
Enternal
7 weeks
0
Enternal
5
7854.36 SR
Enternal
10
0
Enternal
10
0
Enternal
5
7854.36 SR
Enternal
10
0
Enternal
5
7854.36 SR
Enternal
10
0
Enternal
10
0
Enternal
5
7854.36 SR
Enternal
10
0
Enternal
5
7854.36 SR
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
5
7854.36 SR
Enternal
10
0
Enternal
10
0
Enternal
5
7854.36 SR
Enternal
10
0
External
5
0
Enternal
5
7854.36 SR
External
5
0
Enternal
10
0
Enternal
5
7854.36 SR
Enternal
10
0
Enternal
10
0
Enternal
5
7854.36 SR
Enternal
10
0
Enternal
5
7854.36 SR
Enternal
5
7854.36 SR
Enternal
10
0
Enternal
7 weeks
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
External
5
0
Enternal
7 weeks
0
Enternal
5
7854.36 SR
Enternal
10
0
External
10
0
Enternal
10
0
Enternal
5
7854.36 SR
Enternal
10
0
Enternal
10
0
External
5
0
External
10
25000 SR
Enternal
15
0
External
10
25000 SR
Enternal
15
0
External
10
25000 SR
Enternal
15
0
External
10
25000 SR
External
10
25000 SR
External
10
25000 SR
Enternal
15
0
External
10
25000 SR
External
10
25000 SR
Enternal
15
0
External
10
25000 SR
Local
5
0
External
10
25000 SR
External
5
0
External
5
0
External
5
0
External
4
0
External
4
0
External
5
0
External
5
0
External
4
0
External
4
0
External
4
0
External
4
0
External
5
0
External
5
0
External
5
9000 SR
External
5
9000 SR
External
5
9000 SR
External
5
9000 SR
External
Months 6
0
External
Months 6
0
External
5
0
External
5
0
External
5
0
External
5
0
Enternal
5
0
Enternal
5
0
Enternal
5
0
External
4
0
External
4
0
External
5
0
External
5
0
External
5
0
External
5
0
External
5
0
External
5
0
External
5
0
External
5
0
External
5
0
External
5 Weeks
9995$
External
5 Weeks
9995$
External
26
74254 SR
External
26
74254 SR
External
26
74254 SR
External
26
74254 SR
External
5 Weeks
37472.25 SR
External
6 Weeks
37472.25 SR
External
7 Weeks
37472.25 SR
External
8 Weeks
37472.25 SR
External
9 Weeks
37472.25 SR
External
10 Weeks
37472.25 SR
External
5
0
External
5
0
External
5
0
External
5
0
External
5
0
External
5
0
External
5
0
External
5
0
External
5
0
External
3
0
External
5
0
External
5
0
External
10
0
External
10
0
External
5
0
External
5
0
External
10
0
External
135
0
External
5
0
Enternal
5
0
Enternal
5
0
External
5
0
External
5
0
External
5
0
External
10
0
External
5
0
External
5
0
External
5
0
External
5
0
Enternal
5
0
Enternal
5
0
External
5
0
Enternal
5
0
External
4
1974.25 SR
External
4
1974.25 SR
External
4
1974.25 SR
External
4
1974.25 SR
External
4
1974.25 SR
External
4
1974.25 SR
External
5
0
External
5
0
Local
4
500 EUR
Local
4
500 EUR
Local
4
0
Enternal
5
0
External
5
0
External
4
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Enternal
10
0
Local
5
0
Total Cost of Level
Total
Level
Entry-level
Intermediate-level
Mid-level
Senior-Level
Executive-level
Level
Grade
7
9
12
14
17
11
15
18
COST OF EACH LEVEL PER DAY
INTERNAL
LOCAL / EXTERNAL
Entry-level
Intermediate-level
Mid-level
Senior-Level
Executive-level
PLACE
8
10
1000
1250
1500
2000
2500
INTERNAL
1 DAY Befor and After
Total cost of level = days* cost of level per day
1500
2000
2500
3000
3500
EXTERNAL
2 DAYs Befor and After
LOCAL
1 DAY Befor and After
522
473
471
498
499
474
472
492
487
478
482
480
395
486
125
490
430
495
461
500
497
1004
1015
1007
1035
1021
1027
421
1005
1113
943
483
1109
1133
1132
957
1061
1034
419
973
1020
423
1008
1022
391
411
515
921
1001
1091
1040
1062
1090
99
484
101
1130
1126
1119
1125
1124
1128
1102
1104
1086
1089
1083
1121
1082
1064
470
927
942
429
1012
936
941
958
925
951
964
962
963
961
953
1111
1108
1048
476
519
940
475
477
388
1017
1018
912
488
481
913
915
970
939
1002
1081
1088
931
1053
1087
1032
1084
ID
412
1094
1045
100
1127
1055
1131
983
982
989
1042
386
1037
1057
1052
467
501
491
493
389
965
1013
1009
1029
1120
1117
1030
494
485
502
916
972
1014
1019
932
971
1046
1039
1047
1051
1122
1041
97
Sector
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
GRADE
10
10
8
12
8
7
7
12
9
9
8
9
9
7
10
10
10
10
10
9
8
8
8
7
7
7
7
11
10
9
9
9
8
8
8
8
7
7
7
7
7
7
12
522
473
471
498
499
474
472
492
487
478
482
480
395
486
125
490
430
495
461
500
497
1004
1015
1007
1035
1021
1027
421
1005
1113
943
483
1109
1133
1132
957
1061
1034
419
973
1020
423
1008
1022
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
GHI
GHI
GHI
GHI
GHI
GHI
GHI
GHI
GHI
11
11
11
11
11
11
10
10
10
10
10
10
10
10
10
9
9
9
8
8
8
8
8
8
7
7
7
9
8
7
12
11
12
7
7
8
8
7
10
8
7
8
8
7
391
411
515
921
1001
1091
1040
1062
1090
99
484
101
1130
1126
1119
1125
1124
1128
1102
1104
1086
1089
1083
1121
1082
1064
470
927
942
429
1012
936
941
958
925
951
964
962
963
961
953
1111
1108
1048
JKL
JKL
JKL
JKL
JKL
JKL
JKL
JKL
JKL
JKL
JKL
JKL
JKL
JKL
JKL
JKL
JKL
JKL
JKL
JKL
JKL
JKL
JKL
JKL
JKL
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
9
9
8
8
8
7
7
7
7
12
11
10
7
7
7
7
7
7
11
8
7
7
7
7
7
12
11
10
10
9
8
11
10
9
8
8
8
8
8
8
8
7
7
6
476
519
940
475
477
388
1017
1018
912
488
481
913
915
970
939
1002
1081
1088
931
1053
1087
1032
1084
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
MNO
11
11
10
10
9
9
7
7
12
11
10
9
8
8
8
8
7
7
7
7
7
7
7
Purchase answer to see full
attachment
