tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1713739b-aad7-41db-a86b-05765c093027
Sheet: Sheet1

Unnamed: 0 | Name of Department | English-as-a-Second-Language | Unnamed: 3 | Unnamed: 4
 | Instructor Name
 | Name of Course
 | Semester, Year
Directions:
This document should match your official rolls.  Enter pre/posttest raw scores (grade before the
bonus) for each student on your official roll.  If the student misses the pretest or posttest,
enter an X in the appropriate area.  Use the tab to move from space to space.  When you
tab to the Value Added column, the program will automatically compute this information.
Complete a separate form for each course.  When completed, email as an attachment
to the E.S.L. Department Assistant.
 | Course Pre/Posttest Scores for the QEP Faculty Report
 | STUDENT NAME | PRE TEST | POST TEST | VALUE ADDED
1 |  |  |  | 0
2 |  |  |  | 0
3 |  |  |  | 0
4 |  |  |  | 0
5 |  |  |  | 0
6 |  |  |  | 0
7 |  |  |  | 0
8 |  |  |  | 0
9 |  |  |  | 0
10 |  |  |  | 0
11 |  |  |  | 0
12 |  |  |  | 0
13 |  |  |  | 0
14 |  |  |  | 0
15 |  |  |  | 0
16 |  |  |  | 0
17 |  |  |  | 0
18 |  |  |  | 0
19 |  |  |  | 0
20 |  |  |  | 0
21 |  |  |  | 0
22 |  |  |  | 0
23 |  |  |  | 0
24 |  |  |  | 0
25 |  |  |  | 0
26 |  |  |  | 0
27 |  |  |  | 0
28 |  |  |  | 0
29 |  |  |  | 0
30 |  |  |  | 0
Spreadsheet: 680215d1590858422-conditional-formatting-using-multiple-sheets-and-search-function-in-multiple-rows-and-column-2020-05-30-unlimited007-cf-680204d1590855331-conditional-formatting-using-multiple-sheets-and-
Sheet: Logs

Operation # | Operator | Misc | Equipment | Misc | Misc | Misc | Misc | Misc | Misc | Misc | Misc | Misc | Misc | Misc | Misc
14 | [NAME] |  | Hyster A
13 | [NAME] |  | Hyster B |  |  | Here are the logs. This sheet is automatically edited by software so im uneazy changing the column layout, hence why im interested in conditional formatting.
12 | Alfons |  | Hyster E
11 | Raul |  | Hyster A |  |  | Every row on this sheet (Logs) is added by the software. The other sheets I feel more comfortable adding stuff outside the used up columns.
10 | [NAME] |  | Hyster A
9 | [NAME] |  | Hyster G |  |  | We have 3 sheets, "Logs","Equipment" & "Operators"
8 | Martin |  | Hyster B
7 | [NAME] |  | Hyster E
6 | [NAME] |  | Hyster A
5 | Martin |  | Hyster G |  |  | Here I will describe what I want to get done.
4 | [NAME] |  | Hyster G
3 | Alfons |  | Hyster E |  |  | I want to add a conditional formatting which turns the cell red if the operator in question (column B) is not licensed to operate the equipment (column D). It is not as simple as performing a VLOOKUP on what the Operators license is and what the requirement for the equipment is. We need to keep in mind that a license might qualify you for several types of equipment.
2 | Raul |  | Hyster B
1 | Alfons |  | Hyster A |  |  | Example 1: In row 4 in the "Logs" sheet we have "Alfons" which operated "Hyster E". "Alfons" has an "A4" license (shown in the "Operators" sheet) and "Hyster E" requires a minimum of a "B2" license (shown in the "Equipment" sheet). Then in the "Logs" sheet I would want the cell B4 ("Alfons") to be filled red as he operated equipment outside of his license range.
 |  |  |  |  |  | Example 2: In row 2 in the "Logs" sheet we have "[NAME]" which operated "Hyster A". "[NAME]" has a "B2" license (shown in the "Operators" sheet) and "Hyster A" requires a minimum of a "A3" license (shown in the "Equipment" sheet). Then in the "Logs" sheet I would want the cell B2 ("[NAME]") to not be filled as she operated equipment within her license range. Although "[NAME]" doesnt have an "A3" license but her "B2" license qualifies her for operating "A3" equipment.
 |  |  |  |  |  | What have I tried?
 |  |  |  |  |  | I have tried using VLOOKUP to find the required license for the equipment and then using a mix of HLOOKUP and VLOOKUP to find in the grid J-Q in the "Operators" sheet if the license is TRUE or FALSE. I couldnt make it work properly.
 |  |  |  |  |  | If you have read this far thank you very much for spending the time reading this. I hope it has been clear enough to understand with the excel attachment
Spreadsheet: 775818d1649335782-formula-to-pull-data-from-master-bill-of-materials-excel-matrix-help
Sheet: Sheet1

 | Head ASM 1 | Head ASM 2 | Head ASM 3 | Head ASM 4 | Head ASM 5 | Head ASM 6
Part Description |  |  |  |  |  |  | OEM Part # | Supplier Part # | Supplier Part # [NAME]
OB SIDE SHIELD LH |  |  |  |  |  |  | 84964822 | 7416795-L/F | AA
OB SIDE SHIELD LH |  |  |  |  |  |  | 85100022 | 7416795-107H | AA | Pull information in Column H, I, and J to Sheet2 with Part Description
OB SIDE SHIELD RH |  |  |  |  |  |  | 84964855 | 3656796-L/F | AA
OB SIDE SHIELD RH |  |  |  |  |  |  | 85100077 | [PHONE] | AA | Pull information in Column H, I, and J to Sheet2 with Part Description
CENTER FRONT FOOT COVER |  |  |  |  |  |  | 84964888 | 8886801-L/F | AA
CENTER FRONT FOOT COVER |  |  |  |  |  |  | 85100099 | 8886801-401H | AA | Pull information in Column H, I, and J to Sheet2 with Part Description
LH 2 POSITION HIGH LATCH SHOULDER BEZEL (BLACK) |  |  |  |  |  |  | 13539055 | 9876802-L/F | AA
LH 2 POSITION HIGH LATCH SHOULDER BEZEL (BLACK) |  |  |  |  |  |  | 84929977 | 9876802-103H | AA | Pull information in Column H, I, and J to Sheet2 with Part Description
RH 2 POSITION HIGH LATCH SHOULDER BEZEL (BLACK) |  |  |  |  |  |  | 13539055 | 8886803-L/F | AA
RH 2 POSITION HIGH LATCH SHOULDER BEZEL (BLACK) |  |  |  |  |  |  | 84929988 | 8886803-103H | AA | Pull information in Column H, I, and J to Sheet2 with Part Description
 |  |  |  |  | Sheet 1 is a master list that includes colored and non-colored components Sheet 2 is a part matrix that includes only colored components  Need to populate cells on sheet 2 with components that do not include "L/F" in Supplier Part #. Cannot use a unique identifier in the Part Description and both the OEM and Supplier Part #[NAME] are updated as design changes are made
 |  |  |  |  |  |  |  | 84964855
 |  |  |  |  |  |  |  | 84964888
 |  |  |  |  |  |  |  | 13539055
 |  |  |  |  |  |  |  | 13539055
Spreadsheet: 176706d1346078057-indexing-with-duplicates-issue-copy-of-department-position-status-working-file-2
Sheet: InformationSystems

InformationSystems
 | Filled Positions |  |  |  |  |  |  |  |  |  |  |  | Open Positions
 | Title | Location | Category | Hiring Manager | Number of Openings | Number Filled | Date Activated | Date Filled | Start Date | Business Days to Offer | Comments |  |  | Title | Location | Category | Hiring Manager | Created Date | Age | Comments
Spreadsheet: 66041d1266669061-how-to-find-a-certain-value-in-a-table-718816_a94andwi
Sheet: PARTS

 |  |  |  |  |  | Parts | Companies | 0
111 | 444 | A | 123 | 3 |  | 111 | #N/A | #N/A
111 | 333 | B | 123 | 4 |  | 222 | #N/A | 0
222 | 444 | B | 32 | 4 |  | 333 | #N/A
333 | 111 | C | 43 | 3 |  | #N/A | #N/A
222 | 555 | D | 345 | 4 |  | #N/A | #N/A
 |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  | #N/A | #N/A
Spreadsheet: cara_semperger__1441__PGE_NOVEMBER_MIDC_PATHS
Sheet: NOV (19)

 |  |  | To Portland General Electric : [NAME], [NAME], and [NAME]
 |  |  | Phone 464-7067
 |  |  | From Enron: Cara, [NAME], and [NAME] |  |  |  |  |  | DAILY COLSTRIP = 0
 |  |  | Phone 464-3814, 3902, 3831 |  |  |  |  |  | MONTH LONG COLSTRIP = 47 ATC
 |  |  |  |  |  |  |  |  | DAILY DEAL=2 HLH(WE SELL) 4 LLH (WE BUY)
 |  |  |  |  | Mid Columbia Paths
2001-11-19 00:00:00
 | HLH
 | DAY | 2 | GRANT | X | BP | ENRON | PGE | X | SINK AT MIDC
 | DAY | 10 | PSPL(G)MIDC | X | PINWEST | ENRON | PGE | X | COLSTRIP B/R
 | DAY | 12 | GRANT | X | BP | ENRON | PGE | X | COLSTRIP B/R
 | MONTH | 25 | AVISTA(G)CHELAN | X | AVISTA | ENRON | PGE | X | COLSTRIP B/R
 | LLH
 | DAY | 2 | BPA C#10440-CLATSKANPE-BPA(T)BPAP/PGE #10649NF | X | CLATSKANPE | ENRON | PGE | X | COLSTRIP B/R
 | DAY | 20 | CHPD GEN | X | AVISTA | ENRON | PGE | X | COLSTRIP B/R
 | DAY | 4 | GEN MIDC | X | PGE | ENRON | AIRPROD | X | PSEI-LOAD
 | MONTH | 25 | WWP(G)MIDC | X | WWP | ENRON | PGE | X | COLSTRIP B/R
 | MONTH COLSTRIP PATHS
 | ALL HOURS
 | MONTH | 6 |  | X | PGE | ENRON | ASHGROVE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 6 |  | X | PGE | ENRON | EXPRESS PIPE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 7 |  | X | PGE | ENRON | HOLNAM | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 8 |  | X | PGE | ENRON | LOUISIANA P | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 5 |  | X | PGE | ENRON | LUZENAC | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 15 |  | X | PGE | ENRON | SMURFIT | X | MPCO NETWORK TRANSMISSION TO LOAD
Spreadsheet: 707406d1607251206-using-a-list-to-reduce-worksheets-midshires-master
Sheet: BA

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: 117434d1312808234-combining-data-atlanta-79
Sheet: Hubbard, Glenn

Game# | G | AB | R | H | 2B | 3B | HR | RBI | SB | CS | K | BB | HBP | SAC | SF | DP | E
1
2
3 | 1 | 3 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 1
4
5
6 | 1 | 1 |  |  |  |  |  |  |  |  | 1
7
8 | 1 | 4 |  |  |  |  |  |  |  |  | 1
9
10
11 | 1 | 3 |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1
12 | 1
13 | 1 | 4 |  |  |  |  |  |  |  |  | 1
14 | 1 | 5 | 2 | 3 | 1 |  |  | 1 | 1 |  | 2
15 | 1 | 4 |  | 1 |  |  |  | 1 |  |  | 1
16 | 1 | 5 |  | 2 |  |  |  |  |  |  | 1 | 1
17 | 1 | 2 |  | 1
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
Totals | 10 | 31 | 2 | 9 | 1 | 0 | 0 | 2 | 1 | 0 | 7 | 1 | 0 | 0 | 0 | 1 | 1
Spreadsheet: 0be7c83d-95f2-4814-aa58-e0897876ab84
Sheet:    Finance Report   

 | Finance Report |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Click to Submit & Attach File
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reason for report
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | End of Year
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] e in Leadership
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Group Divided
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Group Disbanded
 | The Annual Finance Report is required to be completed for each group and submitted to a Girl Scout Service Center by
 | June 1 of each year.  Please attach a copy of the Detailed Cash Report & 12 months ofcurrent bank statement to this report.
 | For the year ending: |  | May 31, |  |  |  |  |  | Group # |  |  |  |  |  |  |  | INCOME AND EXPENSES
 | Service Unit name: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Beginning Balance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (Previous year’s ending balance)
 | Level (check one) |  | D |  | B |  | J |  | C |  | S |  | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Income
 | Leader/Advisor name:
 | E-mail: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Subtotal
 | Phone: | Home |  |  |  |  |  | Cell |  |  |  |  |  |  |  |  | Less:
 | Address: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Expenses
 | City: |  |  |  |  |  |  |  |  | ZIP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL BALANCE
 | Financial Institution: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | As of: |  |  |  |  |  |  | _ _ / _ _ / _ _
 | Account # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Amount to be used
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | during summer months
 | Authorized Signatures: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Used for:
 |  | 1.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Person completing this report:
 |  | 2.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name
 |  | 3.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Phone
 | Please list any equipment (flags, books, camping gear, supplies, |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-mail
 | etc.) and the name and address where the equipment is stored:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Signature |  |  |  |  | Date
Spreadsheet: 126386d1319661117-closest-time-achieved-time-chart-example
Sheet: Sheet1

Age | 18
Time | 00:13:40 | 00:13:37 |  | Input time as 0:[NAME]:ss
Points | 75 | 77
 | 17 | 18 | 19 | 20 | 21
00:13:00 | 97 | 89 | 81 | 73 | 65
00:13:06 | 95 | 87 | 79 | 71 | 63
00:13:12 | 93 | 85 | 77 | 69 | 61
00:13:18 | 91 | 83 | 75 | 67 | 59
00:13:24 | 89 | 81 | 73 | 65 | 57
00:13:30 | 87 | 79 | 71 | 63 | 55
00:13:36 | 85 | 77 | 69 | 61 | 53
00:13:42 | 83 | 75 | 67 | 59 | 51
00:13:48 | 81 | 73 | 65 | 57 | 49
00:13:54 | 79 | 71 | 63 | 55 | 47
00:14:00 | 77 | 69 | 61 | 53 | 45
Spreadsheet: 36fc8934-1351-49e3-8489-ff9175b7e472
Sheet: Sheet1

AFLAC INC | Unnamed: 1 | Unnamed: 2
DEFA14A
04/22/2014
SECURITIES AND EXCHANGE COMMISSION
Filed by the Registrant x
Filed by a Party other than the Registrant o
Check the appropriate box:
o |  | Preliminary Proxy Statement
o |  | Confidential, for Use of the Commission
 |  | Only (as permitted by Rule 14a-6(e)(2))
o |  | [NAME]
x |  | Definitive Additional Materials
o |  | Soliciting Material under 240.14a-12
AFLAC INCORPORATED
(Name of Registrant as Specified In Its
Charter)
(Name of Person(s) Filing Proxy Statement,
if other than the Registrant)
Spreadsheet: 86679d1286633811-combo-box-lookup-only-projectdatadb
Sheet: Project Summary

 |  | Job Name |  |  |  |  |  |  | Job No
 |  |  |  |  |  | Actual Cost Totals |  |  |  |  |  |  |  | Variations
 | Employee Labour | Subcontract Labour | Contract Amounts | Materials | Plant & Equip | Superannuation | Workers Comp | Payroll Tax | P.L.S.L. | Accommodation | L.A.F.H.A. | Freight | Hours | Labour | Material
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Budgeted |  |  | Budgeted
 |  |  |  |  | Amounts |  |  | Amounts
 |  |  |  |  | Labour | Profit/Loss |  | Payroll Tax | Profit/Loss
 |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  | Materials | Profit/Loss |  | Portable Lsl | Profit/Loss
 |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  | Plant & Equip | Profit/Loss |  | Accommodation | Profit/Loss
 |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  | Superannuation | Profit/Loss |  | [NAME] | Profit/Loss
 |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  | Workers Comp | Profit/Loss |  | Freight | Profit/Loss
 |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  | Hours | Profit/Loss
 |  |  |  |  |  | 0
 |  |  |  |  | Contract Amount |  | Current Costs |  | Profit/Loss
 |  |  |  |  |  |  | 0 |  | 0
Spreadsheet: 46798d1245745947-hyperlink-or-formula-sample
Sheet:  Employees

Date: | 2009-06-23 11:02:51
Western Employees
Sl # | Emp No. | Name | Driving licence | Remarks
1 | 366 | [NAME] | Yes
2 | 408 | Loreto Emriqez | No
3 | 435 | [NAME] | No | Vacation from 5 June - 5 August09
4 | 393 | Joselito sombrero | Yes | Vacation on 3-May-16-June-09
5 | 364 | [NAME] | Yes
6 | 412 | [NAME] | No
7 | 416 | [NAME] | No
8 | 488 | [NAME] | No
9 | 969 | Odranoel Francisco | Yes
10 | 1939 | Richrd [NAME] | Yes
11 | 964 | [NAME] | Yes
12 | 966 | [NAME] | Yes
13 | 442 | [NAME] | Yes
14 | 480 | [NAME] | No
15 | 955 | [NAME] | No
16 | 965 | [NAME] | No
17 | 1030 | Almera Fabiosa | Yes
18 | 1050 | [NAME] | No
19 | 1513 | Leo D Vinarao | Yes
20 | 1536 | Maxima C Arizo | Yes | Vacation from 3 July-3Sep-2009
21 | 1553 | Zaldy R Ebal | No
Spreadsheet: 694424d1599593331-help-wanted-for-formula-looking-up-multiple-rows-and-columns-sales-office-targets-for-errors-and-orders
Sheet: By Employee

 |  |  | 2020 | 2020 | 2020
 | Person A |  | September | October | November
 | Orders Processed
 | Working Days Available
 | Target Orders Per Day
 | Actual Days Worked
 | Total Target Orders
 | % Target Achieved
Spreadsheet: 145543d1331645831-time-card-workbook-pivot-tables-best-way-copy-of-2012-hour-log
Sheet: Pivot Data

 |  | Values
 | Row Labels | Sum of Hours | Sum of Pay Rate
 | 2012 | 81 | 149.75
 | 1 | 81 | 149.75
 | [NAME] | 5 | 9.75
 | [NAME] | 2 | 13
 | Francisco | 2 | 11.5
 | [NAME] | 9 | 9.75
 | [NAME] | 8 | 13
 | [NAME] | 9 | 9.5
 | [NAME] | 2 | 8.5
 | [NAME] | 6 | 8.5
 | [NAME] | 8 | 9.75
 | [NAME] | 3 | 8.5
 | Manuel P | 7 | 10
 | Martin | 3 | 10.5
 | [NAME] | 4 | 10.5
 | [NAME] | 1 | 0
 | Natividad | 5 | 8.5
 | [NAME] | 1 | 0
 | Shadrik | 6 | 8.5
 | Grand Total | 81 | 149.75
Spreadsheet: 97672d1296775268-excel-2007-my-sisters-homework-if-and-or-functions-maybe-chap6_mid2_gradebook_solution
Sheet: Sheet1

Dr. [NAME]'s [NAME]
 | Test 1 | Test 2 | Test 3 | Test 4 | Test 5 | Average | Rounded Average | Credit Only | Grade | Rank
Basil, [NAME] | 75 | 90 | 65 | 80 | 90
[NAME], [NAME] | 90 | 90 | 90 | 80 | 0
Coulter, [NAME] | 75 | 70 | 52 | 60 | 80
Edwards, [NAME] | 84 | 88 | 92 | 96 | 0
Eidsen, [NAME] | 50 | 60 | 70 | 80 | 90
[NAME], [NAME] | 75 | 70 | 65 | 85 | 90 |  |  | Yes
Ford, [NAME] | 90 | 90 | 80 | 90 | 0
[NAME], [NAME] | 82 | 78 | 66 | 81 | 92
Jones, [NAME] | 65 | 65 | 62 | 55 | 0 |  |  | Yes
Laquer, [NAME] | 94 | 92 | 91 | 92 | 0
Martin, [NAME] | 55 | 0 | 45 | 60 | 50
[NAME], [NAME] | 92 | 78 | 65 | 81 | 0 |  |  | Yes
[NAME], Jan | 50 | 72 | 70 | 60 | 0
[NAME], [NAME] | 80 | 80 | 80 | 0 | 79
[NAME], [NAME] | 90 | 90 | 90 | 80 | 90
Stutz, Joel | 90 | 90 | 90 | 80 | 0
Average |  |  |  |  |  | [NAME] |  | [NAME]
Highest Grade |  |  |  |  |  | 0 | F |  | Number Fs
Lowest Grade |  |  |  |  |  | 60 | D |  | Number Ds
Range |  |  |  |  |  | 70 | C |  | Number Cs
Number taking exam |  |  |  |  |  | 80 | B |  | Number Bs
 |  |  |  |  |  | 90 | A |  | Number As
 |  |  |  |  |  | Credit Only | 65 |  | Number Pass
Spreadsheet: 752475d1634781091-formula-for-countif-down-rows-and-across-columns-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | Employee 1
Employee | Fortnight Ending | O/T |  |  |  |  |  |  |  |  |  |  | Employee 2
Employee 1 | 2021-07-03 00:00:00 | 3
Employee 2 | 2021-07-17 00:00:00 | 2 |  |  |  |  |  |  |  | Employee | Employee 1
Employee 1 | 2021-07-31 00:00:00 | 4
Employee 2 | 2021-08-14 00:00:00 | 1
Employee 1 | 2021-08-28 00:00:00 | 5
Employee 2 | 2021-09-11 00:00:00 | 2 |  |  | How It Is
Employee 1 | 2021-09-25 00:00:00 | 3
Employee 2 | 2021-10-09 00:00:00 | 2 |  |  | F/N Ending F/N 1 - 5 | O/T Hours F/N 1 - 5 | F/N Ending F/N 6 - 10 | O/T Hours F/N 6 - 10 | F/N Ending F/N 11 - 15 | O/T Hours F/N 11 - 15 | F/N Ending F/N 16 - 20 | O/T Hours F/N 16 - 20 | F/N Ending F/N 21 - 25 | O/T Hours F/N 20 - 25
Employee 1 | 2021-10-23 00:00:00 | 5
Employee 2 | 2021-11-06 00:00:00 | 1
Employee 1 | 2021-11-20 00:00:00 | 3
Employee 2 | 2021-12-04 00:00:00 | 2
 |  |  |  |  | How I Want It To Look
 |  |  |  |  | F/N Ending F/N 1 - 5 | O/T Hours F/N 1 - 5 | F/N Ending F/N 6 - 10 | O/T Hours F/N 6 - 10 | F/N Ending F/N 11 - 15 | O/T Hours F/N 11 - 15 | F/N Ending F/N 16 - 20 | O/T Hours F/N 16 - 20 | F/N Ending F/N 21 - 25 | O/T Hours F/N 20 - 25
 |  |  |  |  |  |  | 2021-11-20 00:00:00
Spreadsheet: 743352d1628437081-best-10-results-with-data-and-venue-top-10
Sheet: Sheet2

Name | Country | DoB | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Count | Average
Spreadsheet: 100486d1298851748-sumifs-alternative-for-excel-2003-sumproduct-not-working-newkvs
Sheet: Tuesday

Weekly [NAME] |  |  |  |  | Tuesday
Hour | T/C | TTL | TTL | Name | Shift Manager
0000 - 0100 | 0 | 0 | #N/A
0100 - 0200 | 0 | 0 | #N/A
0200 - 0300 | 0 | 0 | #N/A
0300 - 0400 | 0 | 0 | #N/A
0400 - 0500 | 0 | 0 | #N/A
0500 - 0600 | 0 | 0 | #N/A
0600 - 0700 | 11 | 33 | 3 |  | [NAME]
0700 - 0800 | 35 | 531 | 15.17142857142857 |  | [NAME]
0800 - 0900 | 51 | 604 | 11.84313725490196 |  | [NAME]
0900 - 1000 | 45 | 354 | 7.866666666666666 |  | [NAME]
1000 - 1100 | 31 | 686 | 22.12903225806452 |  | [NAME]
1100 - 1200 | 38 | 663 | 17.44736842105263 |  | [NAME]
1200 - 1300 | 40 | 827 | 20.675 |  | [NAME]
1300 - 1400 | 28 | 579 | 20.67857142857143 |  | [NAME]
1400 - 1500 | 27 | 515 | 19.07407407407407 |  | [NAME]
1500 - 1600 | 45 | 1022 | 22.71111111111111 |  | [NAME]
1600 - 1700 | 50 | 1336 | 26.72 |  | [NAME]
1700 - 1800 | 55 | 1287 | 23.4 |  | [NAME]
1800 - 1900 | 64 | 1595 | 24.921875 |  | [NAME]
1900 - 2000 | 38 | 752 | 19.78947368421053 |  | [NAME]
2000 - 2100 | 23 | 659 | 28.65217391304348 |  | [NAME]
2100 - 2200 | 16 | 568 | 35.5 |  | [NAME]
2200 - 2300 | 6 | 101 | 16.83333333333333 |  | [NAME]
2300 - 0000 | 0 | 0 | #N/A
Spreadsheet: dbfaf242-e5d3-4e67-8e5f-866e60d6bcc4
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40842032 | 2014-04-04 21:18:38 | AXIS | 1 | 5 | 3 | 1422784 | flarchi | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
40842322 | 2014-04-04 21:36:16 | ALLIES | 1 | 5 | 3 | 1422784 | flarchi | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
40858860 | 2014-04-05 22:04:38 | AXIS | 0 | 9 | 10 | 189550 | player189550 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40859345 | 2014-04-05 22:28:29 | ALLIES | 1 | 10 | 5 | 189550 | player189550 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40991884 | 2014-04-14 21:34:30 | AXIS | 0 | 1 | 4 | 1530003 | Entenfang14 | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
40992093 | 2014-04-14 21:47:15 | ALLIES | 1 | 4 | 2 | 1530003 | Entenfang14 | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
40992667 | 2014-04-14 22:32:18 | AXIS | 1 | 5 | 3 | 1444429 | michelecannone | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
40992963 | 2014-04-14 22:52:32 | ALLIES | 1 | 5 | 2 | 1444429 | michelecannone | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
41034555 | 2014-04-17 21:08:14 | ALLIES | 0 | 2 | 6 | 1542223 | guy.warmoes | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
41034779 | 2014-04-17 21:22:43 | AXIS | 1 | 6 | 3 | 1542223 | guy.warmoes | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
Spreadsheet: mark_haedicke__24632__2001ENA-only
Sheet: ENA Calculations

DETAILS FOR ENA ONLY (INSIDE COSTS ONLY)
Removed all Outside Services for all Cost Centers.
Removed all costs for CC 107062 (Industrial Markets).
Removed all costs for CC 105658 (Global Markets).
The following CCs have allocations to business groups outside of ENA:
CC 105653 (M&A): | 8 attorneys = 800 points
Non ENA allocations | 135 points
Total Inside costs | 2,841,954 divided by 800 = 3552 x 135 = 479,520
CC 105655 (Executive) | 1 attorney = 100 points
Non ENA allocations | 30 points
Total Inside Costs* | 807,991 divided by 100 = 8080 x 30 = 242,400
*not including Corp Legal
Corp Legal | 2,214,000 divided by 5600** = 395.35 x 685*** = 270,815
**no of all attys x 100
***total of all non-ENA points
Executive non-ENA | 242400
Corp Legal non-ENA | 270815
Total non-ENA
CC105657 Fin Trading/NW | 7 attorneys = 700 points
Non ENA allocations | 510 points
Total Insides Costs | 2,455,005 divided by 700 = 3507 x 510 = 1,788,570
CC 105659 Phy Trading | 14 attorneys = 1400 points
Non ENA allocations | 10 points
Total Inside Costs | 3,842,535 divided by 1400 = 2745 x 10 = 27,450