tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 678109d1589721264-formula-for-column-g-searcched-exclusion-of-value-in-column-e-if-values-are-repeated-example_excel-problemxlsx
Sheet: Hoja1

customer | details | details | details | inventory | orders on the way | demand |  |  | =IF(B3="";"";IF(COUNTIFS($C$3:$C3;C3;$D$3:$D3;D3;$E$3:E3;E3)=1;E3-F3;F3))
A | B | C | D | E | F | G | H |  | the idea is to have:
1 | 100 | 1000000000 | 500 | 200 | 4 | 5 |  |  | one formula applicable for the whole column G (my original data has more than 3000 lines and is based on makros)
 |  | 1000000001 | 12
 |  | 1000000002 | 12
 |  | 1000000003 | 1
 |  |  |  |  |  |  |  |  | first argument: | (already covered with the current solution)
1 | 200 | 1000000000 | 500 | 200 | 4 | 3 |  |  | If [NAME], [NAME] and E3 equal A8, C8 and E8, then the value in column E should only be considered once (the first time)
 |  | 1000000001 | 12
 |  | 1000000002 | 12
 |  | 1000000003 | 1 |  |  |  |  |  | second argument:
 |  |  |  |  |  |  |  |  | If C3 and E3 are equal to C8 and E8, but [NAME] and F3 differ to A8 and F8, then F3 should only be considered once (when it first appears)
2 | 300 | 1000000000 | 2000 | 200 | 3 | 2 |  |  | means in a concrete the calculation should look like:
 |  | 1000000003 | 1 |  |  |  |  |  |  | =F13-G13 | (E in this case will not be considered as it has been used already in the result of "H3")
 |  | 1000000005 | 1
 |  | 1000000006 | 8 |  |  |  |  |  | so there are 3 possible calculations to get the correct result:
 |  | 1000000007 | 8 |  |  |  |  |  |  | =E3+F3-G3 | if its the first argument (argument covered by the solution provided by you)
 |  |  |  |  |  |  |  |  |  | =G8 | if the value has already been considered (argument covered by the solution provided by you)
1 | 400 | 1000000004 | 2000 | 50 | 2 | 6 |  |  |  | =F13-G13 | additional argument
 |  | 1000000003 | 1
 |  | 1000000005 | 1
 |  | 1000000006 | 8 |  |  |  |  |  | if the value in column E has already been considered in the calculation once in this case row 13 (taken into consideration that A13, B13 and [NAME] contained the same information, it should not be considered anymore)
 |  | 1000000007 | 8
2 | 500 | 1000000004 | 2000 | 20 | 2 | 6
 |  | 1000000003 | 1
 |  | 1000000005 | 1
 |  | 1000000006 | 8
 |  | 1000000007 | 8
2 | 300 | 1000000004 | 2000 | 20 | 2 | 4
 |  | 1000000003 | 1
 |  | 1000000005 | 1
 |  | 1000000006 | 8
 |  | 1000000007 | 8
2 | 700 | 1000000004 | 1500 | 20 | 8 | 3
 |  | 1000000003 | 1
 |  | 1000000005 | 1
 |  | 1000000006 | 8
 |  | 1000000007 | 8
Spreadsheet: john_griffith__15745__10_16_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL X1 | 22.5 | 60 | 70 | 63.8 | 74.4 | 0.98 | 2001-10-16 12:39:00
 | CL Z1 | 22.5 | 270 | 278 | 53.5 | 55.1 | 0.77 | 2001-10-16 12:39:00
 | CL F2 | 23 | 355 | 365 | 48.5 | 49.8 | 0.71 | 2001-10-16 12:39:00
 | CL G2 | 23 | 415 | 430 | 45.6 | 47.2 | 0.67 | 2001-10-16 12:39:00
 | CL H2 | 23 | 450 | 465 | 43.3 | 44.7 | 0.64 | 2001-10-16 12:39:00
 | CL J2 | 23 | 478 | 493 | 41.4 | 42.7 | 0.61 | 2001-10-16 12:39:00
 | CL K2 | 23 | 495 | 515 | 39 | 40.6 | 0.58 | 2001-10-16 12:39:00
 | CL M2 | 23 | 510 | 525 | 37.5 | 38.6 | 0.55 | 2001-10-16 12:39:00
 | CL N2 | 23 | 515 | 535 | 35.4 | 36.8 | 0.52 | 2001-10-16 12:39:00
 | CL Q2 | 22.5 | 520 | 540 | 34.7 | 36 | 0.5 | 2001-10-16 12:39:00
 | CL U2 | 22.5 | 520 | 540 | 33.1 | 34.4 | 0.48 | 2001-10-16 12:39:00
 | [NAME] | 22.5 | 525 | 545 | 31.8 | 33.1 | 0.46 | 2001-10-16 12:39:00
 | [NAME] | 22 | 530 | 550 | 30.6 | 31.8 | 0.43 | 2001-10-16 12:39:00
 | CL M3 | 21.5 | 530 | 570 | 26.6 | 28.7 | 0.37 | 2001-10-16 12:39:00
 | CL Z3 | 21.5 | 530 | 570 | 23.8 | 25.6 | 0.33 | 2001-10-16 12:39:00
Spreadsheet: 05f35a72-5492-4c24-a427-a3dca901f024
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
Control Plan Number: |  |  |  | Key Contact/ Phone: |  |  |  | Date (Orig.): |  |  | Date (Rev.):
Part Number: |  | Rev. |  | Core Team: |  |  |  | [NAME] Approval/ Date (If required)
Part Name/ Description: |  |  |  | Supplier/ Plant Approval/ Date (If required) |  |  |  | Customer Quality Approval/ Date (If required)
Supplier/ Plant: |  |  |  | Other Approval/Date (If required) |  |  |  | Other Approval/ Date (If required)
Part / Process Number | Process Name/ Operation Description | Machine, Device, [NAME], Tools for Mfg. | Characteristics |  |  | Special Char. Class | Methods |  |  |  |  | Reaction Plan
 |  |  | No | Product | Process |  | Products/ Process Specs/ Tolerances | Evaluation/ Measurement Technique | Sample |  | Control Method
 |  |  |  |  |  |  |  |  | Size | Frequency
Spreadsheet: 134825d1325654174-commission-formula-based-on-cumulative-percentages-commission-sales-tracker-3-
Sheet: Q1 Commission Tracker

 |  | January | February | March | April | Total
 | QUOTA | 14000 | 18000 | 25000 | 22000 | f
 | Cumulative | 14000 | 32000 | 57000 | 79000
 | Total Monthly GP | 13000 | 18000 | 23000 | 18000 | 72000
 | Cumulative Total | 13000 | 31000 | 54000 | 72000
 | % ACHIEVED | 0.9285714285714286 | 1 | 0.92 | 0.8181818181818182 | #N/A
 | [NAME] ACHIEVED | 0.9285714285714286 | 0.96875 | 0.9473684210526315 | 0.9113924050632911
PAYOUT | Actual Paid | January | February | March | April | Total
Level 1 | 0 - 84.99% | 0 | 0 | 0 | 0 | 0
Level 2 | 85% - 99.99% | 929 |  | 920 | 0 | 1849
Level 3 | 100% to 125% | 0 | 1000 | 0 | 0 | 1000
 |  |  |  |  | TOTAL PAID | 2849
 |  | Adjusted Commission
Level 1 | 0 - 84.99% | 0 | 0 | 0 | 0 | 0
Level 2 | 85% - 99.99% | 929 | 969 | 947 | 911 | 3756
Level 3 | 100% to 125% | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | TOTAL OWED | 3756
 | Annual Bonus Earned | 929 | 1000 | 0 | 0 |  | Balance Owed to staff Q1
 | Monthly Bonus Paid | 929 | 71 | 0 | 0 | 1000 |  | 907
 | [NAME]
Cumulative POT | 4000 | 1000 | 1000 | 1000 | 1000
Spreadsheet: 99656d1298272885-if-statement-if-sol
Sheet: Sheet1

<-- | A | RNS | WIC | OVR | [NAME] | B | RNS | WIC | OVR | Win | Los | Draw 1 | Draw 2 | Win Margin | Win Basis | Result
--> | [NAME] | 161 | 8 | 41.2 | --> | [NAME] | 178 | 10 | 46.1
 | The [NAME] in Columns O3:Q3 are working absolutely fine for scenario 1 and 2.
S. No | Scenario | [NAME]
1 | [NAME] | Ok
2 | H3>C3 | Ok
3 | [NAME]H3 | [NAME]
 | Modification required in such manner that formula works for all three scenarios. And when [NAME], the formula gives the Value in Q3 as " No Result",
Spreadsheet: 772884d1647511385-copying-every-3rd-cell-across-copy-every-3rd-cell-accross-example-10-
Sheet: Example 1

Before |  |  | After
Date | info |  | Date | info
 | Red |  |  | Red
 | Rubber |  |  | Rubber
 | Updated: 14 March 2022
 | Blue |  | Updated: 19 March 2022 | Blue
 | Brick |  |  | Brick
 | Updated: 19 March 2022
 | yellow |  | Updated: 02 March 2022 | yellow
 | Coat |  |  | Coat
 | Updated: 02 March 2022
 | Purple |  | Updated: 01 March 2022 | Purple
 | Hat |  |  | Hat
 | Updated: 01 March 2022
 | Green |  | Updated: 10 March 2022 | Green
 | Scarf |  |  | Scarf
 | Updated: 10 March 2022
Spreadsheet: 44699d1243466578-listing-unique-values-and-summing-w-o-a-pivot-table-unique-values_no-pivot
Sheet: Sheet1

 | Sample Data |  |  |  | Desired results
 | Event Code | Qty of related Minutes |  |  | Unique Codes | Associted Total Minutes | Number of instances |  | 1) Trying to look at B$3:$B$9, list the unique values in that range
 | 23 | 10 |  |  | 23 | 50 | 3 |  | 2) For the unique values, sum their minutes from $C3:$C:$9
 | 26 | 20 |  |  | 25 | 10 | 1 |  | 3) Further, sum the quantity of instance each code occurs
 | 27 | 10 |  |  | 26 | 50 | 2
 | 23 | 30 |  |  | 27 | 10 | 1
 | 25 | 10
 | 26 | 30
 | 23 | 10
Spreadsheet: 0db12bfb-4d56-4c08-8498-9ab47a696964
Sheet: Sheet2

In-Store
 | Climbing Roses | Patio Roses | Tea Roses
 | 1493.21 | 1681.92 | 1594.22
 | 1689.37 | 1552.58 | 1624.44
 | 1271.12 | 1709.58 | 1386.26
 | 1192.61 | 1584.02 | 1596.72
 | 1558.58 | 1526.63 | 1735.51
 | 1483.62 | 1486.91 | 1656.56
 | 1605.58 | 1783.64 | 1526.23
Spreadsheet: 490324d1479821460-sort-of-countif-question-excel-help
Sheet: Sheet2

[NAME] | a | e | d | b | e | b
[NAME] | b | d | c | d | b | c
[NAME] | d | d | b | a | d | c
Spreadsheet: 8505af7c-95e0-4502-af08-d0de0417efa5
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
IMMG | Test | IMMG | Immunoglobulins (IgG, IgA, and IgM), Serum | Immunoglobulins IgG,A,M, S | Nephelometry | Serum Gel Tube: SGT |  |  | 1 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | IgG 0-<5 months: 100-334 mg/dL 5-<9 months: 164-588 mg/dL 9-<15 months: 246-904 mg/dL 15-<24 months: 313-1,170 mg/dL 2-<4 years: 295-1,156 mg/dL 4-<7 years: 386-1,470 mg/dL 7-<10 years: 462-1,682 mg/dL 10-<13 years: 503-1,719 mg/dL 13-<16 years: 509-1,580 mg/dL 16-<18 years: 487-1,327 mg/dL > or =18 years: 767-1,590 mg/dL  IgA 0-<5 months: 7-37 mg/dL 5-<9 months: 16-50 mg/dL 9-<15 months: 27-66 mg/dL 15-<24 months: 36-79 mg/dL 2-<4 years: 27-246 mg/dL 4-<7 years: 29-256 mg/dL 7-<10 years: 34-274 mg/dL 10-<13 years: 42-295 mg/dL 13-<16 years: 52-319 mg/dL 16-<18 years: 60-337 mg/dL > or =18 years: 61-356 mg/dL   IgM 0-<5 months: 26-122 mg/dL 5-<9 months: 32-132 mg/dL 9-<15 months: 40-143 mg/dL 15-<24 months: 46-152 mg/dL 2-<4 years: 37-184 mg/dL 4-<7 years: 37-224 mg/dL 7-<10 years: 38-251 mg/dL 10-<13 years: 41-255 mg/dL 13-<16 years: 45-244 mg/dL 16-<18 years: 49-201 mg/dL > or =18 years: 37-286 mg/dL | Monday through Saturday; Continuously until 3 p.m. | 1 day | 3 days | 3 | 82784 |  |  |  |  | Rochester
IMMG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
IMMG | Result | IGA | Immunoglobulin A (IgA), S | Immunoglobulin A (IgA), S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2458-8 | IgA:MCnc:Pt:Ser:Qn:
IMMG | Result | IGM | Immunoglobulin M (IgM), S | Immunoglobulin M (IgM), S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2472-9 | IgM:MCnc:Pt:Ser:Qn:
IMMG | Result | IGG | [NAME] (IgG), S | [NAME] (IgG), S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2465-3 | IgG:MCnc:Pt:Ser:Qn:
Spreadsheet: 880275d1727896342-sum-multiple-rows-if-3-criteria-match-return-sum-value-sum-index-match-epicstandard-bsb-
Sheet: Sheet1

Order number | Line No | Shipped Value | Item Number |  | Order number | Line No | Shipped Value Total | Item Number
123 | 1.1 | 5000 | Part ABCD |  | 123 | 1.1 |  | Part ABCD
123 | 1.1 | 6000 | Part ABCD
546 | 1.3 | 2000 | Part 123
546 | 1.2 | 4000 | Part 456
Spreadsheet: 326281d1403114150-concatenate-variable-ranges-of-character-strings-ron
Sheet: Sheet1

ACCIDENT_NUMBER |  | OCCUPANT_KILLED_AMT | OCCUPANT_INJURED_AMT
3308006 |  | 0 | 0
3308006 |  | 1 | 2
3315013 |  | 0 | 1
3315013 |  | 1 | 0
3360799 |  | 0 | 0
3360799 |  | 1 | 1
3366040 |  | 0 | 0
3366040 |  | 1 | 1
3382598 |  | 0 | 2
3382598 |  | 1 | 0
3386801 |  | 0 | 0
3386801 |  | 1 | 0
3395060 |  | 0 | 1
3395060 |  | 1 | 2
3409926 |  | 1 | 0
3409926 |  | 0 | 1
3441281 |  | 0 | 1
3441281 |  | 0 | 0
3441826 |  | 0 | 1
3441826 |  | 0 | 0
3501538 |  | 0 | 0
3501538 |  | 0 | 0
3501538 |  | 0 | 0
3501538 |  | 0 | 0
3503224 |  | 0 | 0
3503224 |  | 0 | 0
3503224 |  | 0 | 0
3504774 |  | 0 | 1
3504774 |  | 0 | 2
3504774 |  | 0 | 2
3479875 |  | 0 | 0
3479875 |  | 0 | 0
3479875 |  | 0 | 0
Spreadsheet: 37796d1235820212-grouping-together-book1
Sheet: Sheet2

 |  | Name | Group |  | Group 1 | Group 2 | Group 3 | Group 4 | Group 5 | Group 6 | Group 7 |  | Helper Col.
 |  | A | 7 |  | B | C | D | G | E | I | A |  | Group 7:1
 |  | B | 1 |  | F | H |  |  | J |  |  |  | Group 1:1
 |  | C | 2 |  | M | K |  |  |  |  |  |  | Group 2:1
 |  | D | 3 |  |  | L |  |  |  |  |  |  | Group 3:1
 |  | E | 5 |  |  |  |  |  |  |  |  |  | Group 5:1
 |  | F | 1 |  |  |  |  |  |  |  |  |  | Group 1:2
 |  | G | 4 |  |  |  |  |  |  |  |  |  | Group 4:1
 |  | H | 2 |  |  |  |  |  |  |  |  |  | Group 2:2
 |  | I | 6 |  |  |  |  |  |  |  |  |  | Group 6:1
 |  | J | 5 |  |  |  |  |  |  |  |  |  | Group 5:2
 |  | K | 2 |  |  |  |  |  |  |  |  |  | Group 2:3
 |  | L | 2 |  |  |  |  |  |  |  |  |  | Group 2:4
 |  | M | 1 |  |  |  |  |  |  |  |  |  | Group 1:3
Spreadsheet: 8ff9add7-35a0-487d-b063-a4ed1b5e9442
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
5289 | 8126 | [NAME] | Leverett | GBR | 0 | 00:11:45 | 00:00:00 | 00:20:32 | 00:00:00 | 00:13:18 | 1 | [NAME]
5289 | 32460 | Christine | Walker | AUS | 0 | 00:11:18 | 00:00:00 | 00:21:27 | 00:00:00 | 00:13:53 | 2 | 00:46:38
5289 | 8131 | Tiare | Lund | NZL | 0 | 00:12:21 | 00:00:00 | 00:21:17 | 00:00:00 | 00:14:28 | 3 | 00:48:05
5289 | 21309 | [NAME] | Bachus | USA | 0 | 00:13:11 | 00:00:00 | 00:25:21 | 00:00:00 | 00:16:08 | 4 | 00:54:39
5289 | 28102 | [NAME] | [NAME] | GBR | 0 | 00:13:09 | 00:00:00 | 00:25:38 | 00:00:00 | 00:16:08 | 5 | 00:54:55
5289 | 24358 | Lana | Marcine | CAN | 0 | 00:13:53 | 00:00:00 | 00:25:20 | 00:00:00 | 00:16:39 | 6 | [NAME]
5289 | 13168 | Rosalind | Jarrett | USA | 0 | 00:16:04 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 755696d1637042849-formulas-with-multiple-range-criteria-not-returning-result-sample1-2-
Sheet: Sheet1

sales [NAME] | Int Date | Debit Amount | Cleaing Date | Remark | Days Calculation | 0.1 | 0.13 | 0.16 |  |  | SUMPRODUCT
2021-07-04 00:00:00 |  | 10000 | 2021-06-30 00:00:00 | Advance Payment |  | Nil |  |  |  |  |  | 0 | 0.1 | 0.1
2021-07-04 00:00:00 |  | 10000 | 2021-07-15 00:00:00 | Payment received after int date |  |  |  |  |  | Less than 15 |  | 7 | 0.13
2021-07-04 00:00:00 |  | 10000 | 2021-07-25 00:00:00 | Payment received after int date |  |  |  |  |  | > 15 <60 |  | 52 | 0.16
2021-07-04 00:00:00 |  | 10000 | 2021-09-25 00:00:00 | Payment received after int date |  |  |  |  |  | >61
Spreadsheet: 106168d1303367215-if-statement-together-with-a-couple-of-functions-copy-of-crane-assessment
Sheet: Crane Assessment -2009-2011

No. | DECK  A | Heli ticket no. |  | DESIGNATION | HYDRALIFT | SEATRAX |  |  | [NAME] /WORK ONLY | COMMENTS | No. of Crane Operators.
 |  |  | License number
1 | Person 1 | 6839 | 22062 | DECK FOREMAN | 18.06.2012 | 18.06.2012 |  |  |  | CRANE OPERATOR | 1
2 | Person 2 | 5861 | 22019 | DECK FOREMAN | 26.07.2009 | 26.07.2009 |  |  |  | CRANE OPERATOR | 1
3 | Person 3 | 8734 | 9108 | CRANE OPERATOR | 18.06.2012 | 18.06.2012 |  |  |  | CRANE OPERATOR | 1
4 | Person 4 | 5371 | 22022 | CRANE OPERATOR | 19.5.2010 | 19.5.2010 |  |  |  | CRANE OPERATOR | 1
5 | Person 5 | 2558 |  | CRANE OPERATOR | 02.07.2011 | 02.07.2011 |  |  |  | CRANE OPERATOR | 1
6 | Person 6 | 11165 | 22021 | CRANE OPERATOR | 18.06.2012 | 18.06.2012 |  |  |  | CRANE OPERATOR | 1
7 | Person 7 | 18218 | 22060 | CRANE OPERATOR | 18.8.2010 | 18.8.2010 |  |  |  | CRANE OPERATOR | 1
8 | Person 8 | 18276 | 22061 | CRANE OPERATOR | 20.8.2010 | 20.8.2010 |  |  |  | CRANE OPERATOR | 1
9 | Person 9 | 22713 | 295/002/09 | CRANE OPERATOR | 18.6.2012 | 18.6.2012 |  |  |  | CRANE OPERATOR | 1
10 | Person 10 | 19567 | 22079 | CRANE OPERATOR | 6.2.2011 | 6.2.2011 |  |  |  | CRANE OPERATOR | 1
11 | Person 11 | 14192 | 22071 | CRANE OPERATOR | 4..4.2011 | 4..4.2011 |  |  |  | CRANE OPERATOR | 1
12 | Person 12 | 20002 | 25148 | CRANE OPERATOR | 18.11.2011 | 18.11.2011 |  |  |  | CRANE OPERATOR | 1
13 | Person 13 | 5487 | 22025 | CRANE OPERATOR | 18.6.2012 | 18.6.2012 |  |  |  | CRANE OPERATOR | 1
14 | Person 14 | 16109 | 25129 | CRANE OPERATOR | 6.10.2011 | 6.10.2011 |  |  |  | CRANE OPERATOR | 1
15 | Person 15 | 19371 | 20198 | CRANE OPERATOR | 18.6.2012 | 18.6.2012 |  |  |  | CRANE OPERATOR | 1
16 | Person 16 | 21919 |  | CRANE OPERATOR | 20.4.2012 | 20.4.2012 |  |  |  | CRANE OPERATOR | 1
17 | Person 17 | 30857 |  | CRANE OPERATOR |  |  |  |  |  |  | 1
Spreadsheet: 80638d1280857054-excel-checkboxes-construction_workbook2
Sheet: Invoice Sheet

Construction Contractors, Inc |  |  |  |  |  |  | Invoice Number
895 Flushing Avenue, Brooklyn NY 11206 |  |  |  |  |  |  | 2010-0010
Tel: [PHONE]  Fax: [PHONE]
Customers Name |  | [NAME]
Customers Address |  | 54-89 Chauncey Street
City/State | New York State | Zip Code | 11096-1514 |  | 1
Telephone | [PHONE] | Fax | [PHONE]
SubTotal | 0 | State Tax | 8.625% | Tax Amount | 0 | Total Price | 0
Qty | Description | Retail  Price | Discount | Price | Balance
 | Stock Cabinet 24x36 | 99 | 0 | 0 |  |  |  |  | [NAME] downs are now in column B using the
 |  |  | 0 |  |  |  |  |  | Data Validation List: STOCK
 |  |  | 0
 |  |  | 0 |  |  |  |  |  | Prices will be drawn into C using a new formula
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
Spreadsheet: 7af1aebb-de05-4c0a-b920-4415cc11dd60
Sheet: BAd 443

COURSE ASSESSMENT MATRIX
COURSE: BAd 443 Problems in Business
Objective | Assessment Method | Desired Result | Corrective Action
Assess Why to do a case study | Quizzes                                        Weekly Assignments                                                             Exams | 90 % students pass quizzes                                   80% students pass exams                                              Pass weekly assignments | revise quizzes                    revise exams                         revise weekly assignments
Assess a Case Study Outline | Quizzes                                        Weekly Assignments                                                             Exams | 90 % students pass quizzes                                   80% students pass exams                                              Pass weekly assignments | revise quizzes                    revise exams                         revise weekly assignments
Write a Case Study | Quizzes                                        Weekly Assignments                                                             Exams | 90 % students pass quizzes                                   80% students pass exams                                              Pass weekly assignments | revise quizzes                    revise exams                         revise weekly assignments
Apply the application of APA formatting to their writing | Quizzes                                        Weekly Assignments                                                             Exams | 90 % students pass quizzes                                   80% students pass exams                                              Pass weekly assignments | revise quizzes                    revise exams                         revise weekly assignments
Spreadsheet: 159988d1338919758-vlookup-or-macro-book1
Sheet: Sheet1

Name | Category | Task |  |  |  | Name | Group
[NAME] | Service | 4 |  |  |  | 1 | Service |  |  | Project1
[NAME] | Project | 1 |  |  |  | 2 | Project |  |  | Project2
[NAME] | Project | 2 |  |  |  | 3 | Other
[NAME] | Project | 3 |  |  |  | 4 | Project
[NAME] | Service | 2
[NAME] | Service | 2
[NAME] | Service | 5
[NAME] | Service | 2
[NAME] | Service | 6
[NAME] | Service | 2
[NAME] | Service | 3
[NAME] | Service | 4
[NAME] | Service | 1
[NAME] | Project | 5
[NAME] | Project | 1
[NAME] | Project | 1
[NAME] | Project | 1
[NAME] | Project | 1
[NAME] | Project | 2
[NAME] | Project | 2
[NAME] | Service | 3
[NAME] | Service | 8
[NAME] | Service | 3
[NAME] | Service | 4
[NAME] | Service | 4
[NAME] | Service | 9
[NAME] | Project | 4
[NAME] | Project | 1
[NAME] | Project | 1
[NAME] | Project | 1
[NAME] | Project | 2
Spreadsheet: 776223d1649614058-automatic-ranking-standings-bouwcenter-poule-f1-2022-v1a
Sheet: Head to Head

Head-to-Head
44. [NAME] | Mercedes | 77. Bottas
 | Kwalificatieduel |  |  | Kwalificatieduel
 | RaceDuel |  |  | RaceDuel
 | Aantal Punten |  |  | Aantal Punten
 | Zeges |  |  | Zeges
 | Positie WK |  |  | Positie WK
 | Kwalificatieduel |  |  | Kwalificatieduel
 | RaceDuel |  |  | RaceDuel
 | Aantal Punten |  |  | Aantal Punten
 | Zeges |  |  | Zeges
 | Positie WK |  |  | Positie WK
 | Kwalificatieduel |  |  | Kwalificatieduel
 | RaceDuel |  |  | RaceDuel
 | Aantal Punten |  |  | Aantal Punten
 | Zeges |  |  | Zeges
 | Positie WK |  |  | Positie WK
 | Kwalificatieduel |  |  | Kwalificatieduel
 | RaceDuel |  |  | RaceDuel
 | Aantal Punten |  |  | Aantal Punten
 | Zeges |  |  | Zeges
 | Positie WK |  |  | Positie WK
 | Kwalificatieduel |  |  | Kwalificatieduel
 | RaceDuel |  |  | RaceDuel
 | Aantal Punten |  |  | Aantal Punten
 | Zeges |  |  | Zeges
 | Positie WK |  |  | Positie WK
Spreadsheet: 83099d1283166465-excel-2007-assigning-values-in-cells-and-then-summing-total-score-excluding-blanks-udf_scoring_table-1-
Sheet: Sheet1

 | ac1 | ty1 | ac2 | ty2 | ac3 | ty3 | ac4 | ty4 | ac5 | ty5 | ac6 | ty6 | ac7 | ty7 | ac8 | ty8 | ac9 | ty9 | Score?? | Missing
person1 | 2 | 2 | 1 | 3 | 2 | 3 | 2 | 1 | 2 | 1 |  |  | 1 |  | 4 |  | 2 | 3 | 7 | 1
person2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 9
person3 | 1 | 2 | 2 | 3 | 4 |  | 2 | 1 | 2 | 1 | 3 | 5 | 2 | 1 | 4 | 2 | 1 | 3 | 5 | 0
person4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 9
person5 | 2 | 2 | 1 | 5 | 1 | 5 | 1 | 5 | 2 | 1 | 2 | 3 | 1 | 5 | 1 | 5 | 2 | 3 | 9 | 0
person6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 9
person7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 9
person8 | 2 | 2 | 1 |  | 2 | 3 | 2 | 1 | 2 | 1 | 2 | 3 | 1 |  | 2 | 2 | 2 | 3 | 9 | 0
person9 | 2 | 3 | 1 |  | 2 | 3 | 2 | 1 | 2 | 1 | 2 | 3 | 1 |  | 4 |  | 1 | 3 | 8 | 0
person10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 9
person11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 9
person12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 9
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 9
person14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 9
person15 | 2 | 2 | 4 |  | 2 | 3 | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 2 | 3 | 3 | 0
person16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 9
person17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 9
person18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 9
person19 | 3 | 5 | 2 | 5 | 2 | 3 | 2 | 1 |  | 1 | 2 | 3 | 4 |  |  | 2 | 2 | 3 | 4 | 2
[NAME] | 1 |  | 1 |  | 2 | 3 | 1 |  | 2 | 1 | 4 |  | 1 |  | 3 |  | 2 | 3 | 6 | 0
person21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 9
person22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 9
person23 | 4 |  | 4 |  | 4 |  | 1 |  | 2 | 3 | 3 |  | 1 |  | 3 |  | 4 |  | 1 | 0