def standard_formats(workbook):
    """ the formats used in the spreadsheet """
    atomica_blue = '#98E0FA'
    optional_orange = '#FFA500'
    BG_COLOR = atomica_blue
    OPT_COLOR = optional_orange
    BORDER_COLOR = 'white'
    formats = {}
    formats['bold'] = workbook.add_format({'bold': 1})
    formats['center'] = workbook.add_format({'align': 'center'})
    formats['center_bold'] = workbook.add_format({'bold': 1, 'align': 'center'}
        )
    formats['rc_title'] = {}
    formats['rc_title']['right'] = {}
    formats['rc_title']['right']['T'] = workbook.add_format({'bold': 1,
        'align': 'right', 'text_wrap': True})
    formats['rc_title']['right']['F'] = workbook.add_format({'bold': 1,
        'align': 'right', 'text_wrap': False})
    formats['rc_title']['left'] = {}
    formats['rc_title']['left']['T'] = workbook.add_format({'bold': 1,
        'align': 'left', 'text_wrap': True})
    formats['rc_title']['left']['F'] = workbook.add_format({'bold': 1,
        'align': 'left', 'text_wrap': False})
    formats['unlocked'] = workbook.add_format({'locked': 0, 'bg_color':
        BG_COLOR, 'border': 1, 'border_color': BORDER_COLOR})
    formats['center_unlocked'] = workbook.add_format({'align': 'center',
        'locked': 0, 'bg_color': BG_COLOR, 'border': 1, 'border_color':
        BORDER_COLOR})
    formats['general'] = workbook.add_format({'locked': 0, 'num_format': 0,
        'bg_color': BG_COLOR, 'border': 1, 'border_color': BORDER_COLOR})
    formats['unlocked_boolean_true'] = workbook.add_format({'bg_color':
        OPT_COLOR})
    formats['unlocked_boolean_false'] = workbook.add_format({'bg_color':
        BG_COLOR})
    formats['not_required'] = workbook.add_format({'bg_color': '#EEEEEE',
        'border': 1, 'border_color': '#CCCCCC'})
    formats['white_bg'] = workbook.add_format({'bg_color': '#FFFFFF',
        'border': 1, 'border_color': '#CCCCCC'})
    formats['ignored'] = workbook.add_format({'pattern': 14})
    formats['warning'] = workbook.add_format({'bg_color': '#FF0000'})
    formats['ignored_warning'] = workbook.add_format({'pattern': 14,
        'bg_color': '#FF0000'})
    formats['ignored_not_required'] = workbook.add_format({'pattern': 14,
        'bg_color': '#EEEEEE', 'border': 1, 'border_color': '#CCCCCC'})
    return formats
