Sep 3, 2009

Base 60 Transmutation Table

I wrote an Excel Spreadsheet grading table that references a Base60 Transmutation Table.

Here's the lookup table that I used for the grading sheet. The top column shows the total number of Items. The first column on the left is the equivalent final grade (1 being the highest, 5 the lowest). The second column from the left is the equivalent grade in percentage.


























































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































%

100

90

80

70

60

50

40

30

20

10

5

60

0

0

0

0

0

0

0

0

0

0


60

1

1

1

1

1

1

1





60

2

2

2

2








60

3











61

4

3

3

3

2

2

2

1

1



61

5

4

4

4

3

3


2




61

6

5

5

5

4







61

7

6










62

8

7

6

6

5

4

3

3

2

1


62

9

8

7

7

6

5

4





62

10

9

8

8








62

11

10

9









63

12

11

10

8

7

6

5

4

3



63

13

12

11

9

8

7

6





63

14

13

12

10

9







63

15











64

16

14

13

11

10

8

7

5




64

17

15

14

12

11

9






64

18

16

15

13








64

19

17


14








65

20

18

16

14

12

10

8

6

4

2


65

21

19

17

15

13

11

9





65

22

20

18

16








65

23

21










66

24

22

19

17

14

12

10

7

5



66

25

23

20

18

15

13


8




66

26

24

21


16







66

27











67

28

25

22

19

17

14

11

9

6

3


67

29

26

23

20

18

15

12





67

30

27

24

21








67

31


25









68

32

28

26

22

19

16

13

10

7



68

33

29

27

23

20

17

14





68

34

30

28

24

21







68

35

31










69

36

32

29

25

22

18

15

11




69

37

33

30

26

23

19






69

38

34

31

27








69

39

35









4

70

40

36

32

28

24

20

16

12

8

4


70

41

37

33

29

25

21

17





70

42

38

34

30








70

43

39










71

44

40

35

31

26

22

18

13

9



71

45

41

36

32

27

23






71

46

42

37


28







71

47











72

48

43

38

33

29

24

19

15

10

5


72

49

44

39

34

30

25

20





72

50

45

40









72

51


41









73

52

46

42

36

31

26

21

16

11



73

53

47

43

37

32

27

22





73

54

48

44

38

33







73

55

49










74

56

50

45

39

34

28

23

17




74

57

51

46

40

35

39






74

58

52

47

41








74

59

53









3

75

60

54

48

42

36

30

24

18

12

6


76

61

55

49

43

37

31






76

62

56




32





2.75

77

63

57

50

44

38

33

25

19

13



77

64

58

51

45








78

65

59

52

46

39


26

20




79

66

60

53

47

40







79

67










2.5

80

68

61

54

48

41

34

27

21

14

7


80

69

62

55









81

70

63

56

49

42

35

28




2.25

82

71

64

57

50

43

36

29

22

15



82

72

65










83

73

66

58

51

44

37

30





83

74

67

59

52








84

75

68

60

53

45






2

85

76

69

61

54

46

38

31

23

16

8


85

77











86

78

70

62

55

47

39

32

24




86

79

71

63









87

80

72

64

56

48

40





1.75

88

81

73

65

57

49

41

33

25

17



88

82

74










89

83

75

66

58

50

42

34





89

84


67

59








90

85

76

68

60

51






1.5

91

86

77

69

61

52

43

35

26

18

9


91

87

78










92

88

79

70

62

53

44

36

27




92

89

80

71









93

90

81

72

63

54

45





1.25

94

91

82

73

64

55

46

37

28

19



94

92

83










95

93

84

74

65

56

47

38





95

94

85

75

66








96

95

86

76

67

57






1

97

96

87

77

68

58

48

39

29

20

10


97

97











98

98

88

78

69

59

49

40

30




98

99

89

79









99

100

90

80

70

60

50





No comments: