tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2a1eb375-0ee4-43a9-8e4a-28bbb93b2c5e
Sheet: 7.4 Faculty Research

Institution
Indicator 7: Personnel Demographics, Professional Development, Research, and Outcomes
Table 7.4: Faculty/Administrator/Staff Research, [NAME], and Outcomes / AY 2011-12
Please enter faculty/administrator/staff research and creative activities and outcomes.
Publications and Presentations
 |  | AY 2011-12
 |  | Number of Faculty / Administrator / Staff | Number of Pub. & Pres.
Refereed Journal Papers Submitted |  | 11 | 13
Refereed Journal Papers Published |  | 8 | 7
Other Publications(books, chapters, etc.) |  | 11 | 7
Conference Proceedings Published |  | 10 | 12
Scholarly creative cultural activities (ex. exhibit, play) |  | 15 | 20
Professional Presentations at National Conferences |  | 14 | 26
Professional Presentations at on-campus workshops/ seminars |  | 11 | 15
Professional Presentations at off-campus workshops/ seminars |  | 9 | 22
Proposals Submitted and Funded
 |  | AY 2011-12
 |  | Number of Faculty / Administrator / Staff | Number of Proposals
Proposals Submitted for External Funding |  | 11 | 14
External Proposals Funded |  | 1 | 10
Total Amount of Funded Awards ($) |  | 305239
Faculty/Administrator/Staff Support for Research
 |  | AY 2011-12
 |  | Number of Faculty / Administrator / Staff | Total Hours
Release Time/Reduction of Course Load |  | 6 | 450
Provision of Professional Research Staff |  | 3 | 783
Provision of Student Research Assistant |  | 27 | 260
Are any of your faculty or students engaged in research?  (Yes/No) |  |  | yes
If yes, please describe some of the research projects being conducted by faculty or students (e.g., community-based participatory research, locally relevant (applied) research in which your TCU faculty has particular expertise, research partnerships with other entities, etc.)
All graduat students carry out school-. and community action projects.  More information is attached.  Research Class.
Notes:
Spreadsheet: 75869d1276499350-auto-copy-record-to-different-spreadsheets-example
Sheet: programe 4

Surname | Name | code | Sallary | Shift | Company | Τype | [NAME]
surname2 | name 2 | 60400255 | 1014.71 | 8 | mark | Advisor | programe 4
surname10 | name 10 | 60400255 | 1014.71 | 8 | mark | Advisor | programe 4
surname13 | name 13 | 60400111 | 1014.71 | 8 | mark | Advisor | programe 4
surname15 | name 15 | 60400999 | 1014.71 | 8 | mark | Advisor | programe 4
surname17 | name 17 | 60400111 | 1014.71 | 8 | mark | Advisor | programe 4
surname19 | name 19 | 60400999 | 1014.71 | 8 | mark | Advisor | programe 4
surname21 | name 21 | 60400999 | 1014.71 | 8 | mark | Advisor | programe 4
surname23 | name 23 | 60400225 | 1014.71 | 8 | mark | Advisor | programe 4
surname25 | name 25 | 60400111 | 1014.71 | 8 | mark | Advisor | programe 4
surname28 | name 28 | 60400225 | 1014.71 | 8 | mark | Advisor | programe 4
surname29 | name 29 | 60400999 | 1014.71 | 8 | mark | Advisor | programe 4
surname31 | name 31 | 60400999 | 1014.71 | 8 | mark | Advisor | programe 4
surname35 | name 35 | 60400999 | 1014.71 | 8 | mark | Advisor | programe 4
surname38 | name 38 | 60400999 | 1014.71 | 8 | mark | Advisor | programe 4
Spreadsheet: 698572d1602058356-proportional-distribution-upto-the-cap-test-13-
Sheet: Iteration 1 

Example 1
 |  | Inventory Available |  | 7000
 | Total
 | Item | Required | [NAME] cap | Requirement with cap
 | A | 0 | 2000 | 0
 | B | 4000 | 2000 | 2000
 | C | 4500 | 5000 | 5000
 | D | 0 | 5000 | 0
Example 2 |  | Inventory Available |  | 7000
 | Total
 | Item | Required | [NAME] cap | Requirement with cap
 | A | 2000 | 2000
 | B | 4000 | 2000
 | C | 4500 | 5000
 | D | 1000 | 5000
Spreadsheet: 740720d1626498544-hierachy-of-consequence-work-file
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | Consequence
Sl | ID | Name | Category | Count | Instance | Consequence | Actual to be | Remarks |  |  |  | Violation | First Instance | Second Instance | Third Instance | Fourth Instance
1 | 12 | ABCD | Violation-2 |  |  |  |  |  |  |  |  | Violation-1 | [NAME]
 | 10 | ADS | Violation-3 |  |  |  |  |  |  |  |  | Violation-2 | Final Warning | [NAME]
 | 1 | BSR | Violation-4 |  |  |  |  |  |  |  |  | Violation-3 | First Warning | Final Warning | [NAME]
 | 22 | RSP | Violation-3 |  |  |  |  |  |  |  |  | Violation-4 | Verbal Warning | First Warning | Final Warning | [NAME]
 | 12 | ABCD | Violation-4 |  |  |  |  |  | it's 2nd instance averall, previous was "Final Warning", so this instance is next level "Dismissal" of Vio-4
 | 1 | BSR | Violation-4 |  |  |  |  |  | it's 2nd instance averall, previous was "Verbal", so this instance is next level "First warning" of Vio-4
 | 21 | [NAME] | Violation-1
 |  | Can someone to help me resolve this issue.
 |  | I am looking for a formula where if a person got the warning for the first instance, second instance consequence has to go to the next level of warning even if the severity of the violation & the consequence for the violation is low.
Spreadsheet: 855617d1705134434-get-data-from-1-sheet-to-other-sheets-depending-on-drop-down-list-christmas-comp-trial-for-extra-species-ans
Sheet: Flathead

FLATHEAD
Angler # | Length (mm) | Angler Name | Age Group
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
Spreadsheet: ac95a80e-4ea2-4e3e-8ae2-95afd589c5f5
Sheet: Sheet1

SF-3 Report | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
FORM SF3 |  | OHIO DEPARTMENT OF EDUCATION-DIVISION OF SCHOOL FINANCE
 |  | (FY 2008 OCTOBER NO 1 PAYMENT, [PROJECTED])
DATE 10/06/2007
******** ALL DISTRICTS  ******
ADM |  | KDG | 1-12 | Total
1A. | Special Ed Category 1 | 5024.21 | 30952.39 | 35976.6
1B. | Special Ed Category 2 | 1963.76 | 154606.31 | 156570.07
1C. | Special Ed Category 3 | 369.77 | 21445.83 | 21815.6
1D. | Special Ed Category 4 | 178.42 | 2821.03 | 2999.45
1E. | Special Ed Category 5 | 769.18 | 10877.85 | 11647.03
1F. | Special Ed Category 6 | 771.47 | 9183.13 | 9954.6
1G. | JVSD,JVSD [NAME] |  | 38143.42 | 38143.42
1H. | Non-Jnt OE JVSD,JVSD [NAME] |  | 922.81 | 922.81
1I. | All Other Students | 123012.56 | 1401445.16 | 1524457.72
1J. | MRDD |  | 505.75 | 505.75
1K. | Ed. Choice | 725.54 | 2228.04 | 2953.58
2. | Total | 132814.91 | 1673131.72 | 1805946.63
3. | Formula ADM K*.5+(1-12)Total-(.80 Line 1G JVSD)+(.20 CVOC-RES) |  |  | 1709407.72
4A. | Assessed Valuation |  | 257280634308
4B. | Recognized Valuation |  | 248128812318
4C. | Adjusted Recognized Valuation |  | 247292376882
4D. | Property Exemption Value (TIF) |  | 2402600
4E. | Charge Off Amt ((4C+4D) * .023 |  | 5687779928.39
5A. | 5,565 * Line 3 |  |  | 9512853961.8
5B. | Add On Building Blocks |  |  | 84483580.12
6. | [NAME] (5A+5B-4E) |  |  | 4029859821.64
7. | Total Poverty Based Assistance (PBA) |  |  | 445777156.85
8. | Parity Aid |  |  | 483252746.08
9. | Base Cost Funding (6+7+8) |  |  | 4956416929.59
10. | State Share % (Line 9 / (Line 5A+5B+7+8)) |  | 0
11. | Special Education Weighted Amount |  |  | 467253807.57
12. | Career-Tech/[NAME]. | Cat1 FTE:   20622.41 | Cat2 FTE:   17423.36 | 52445450.46
13A. | Number of Classroom Teachers |  |  | -75139.84
13B. | Training & Experience of Classroom Teachers (50% of Total) |  |  | 14609524.68
13C. | Educational Service Personnel |  |  | -42874.34
14. | Gifted Aid                                    Units:    894.15 |  |  | 33855988.36
15. | Total State Basic Aid (Lines 9+11+12+13A+13B+13C+14) |  |  | 5524463686.48
16. | Transportation |  |  | 363272099.5
17. | Excess Cost Supplement |  |  | 51156750.25
18. | Charge-Off Supplement (GAP) |  |  | 82068369.89
19. | Transitional Aid Guarantee |  |  | 385430642.37
Additional Aid Items
20A. | Preschool Clrm Units:        658.78  Related:    202.23 |  |  | 36543414.86
20B. | Special Ed Transportation |  |  | 50328874.98
21. | Total State Foundation Aid (Line 15 thru 20B) |  |  | 6493263838.33
Spreadsheet: 139413d1328226467-30-days-perfect-attendance-sample
Sheet: Sheet1

 |  | 1
Points
Date |  | Reason | Points | Rolloff | Excuse | Perfect Attendance | Accrued Points | Reason for Absence
2010-10-24 00:00:00 |  | Out | 1 | 2011-04-25 00:00:00 |  |  | 0 | Called out
2010-11-20 00:00:00 |  | Out | 1 | 2011-05-21 00:00:00 |  |  | 0 | Called out
2011-01-22 00:00:00 |  | Out | 1 | 2011-07-23 00:00:00 |  |  | 0 | Late to shift by 30 minutes
2011-08-28 00:00:00 |  | Out | 1 | 2012-02-29 00:00:00 |  |  | 0 | Called out
2011-09-30 00:00:00 |  | ER | 0.5 | 2012-03-31 00:00:00 |  |  | 0.5 | Left early still 4hrs left of shift
2011-10-04 00:00:00 |  | Late | 0.5 | 2012-04-05 00:00:00 |  |  | 0.5 | Late to shift by 60 minutes
Spreadsheet: 857996d1706807562-totaling-a-row-if-a-number-doesnt-apply-hours-tally
Sheet: Sheet1

2024-01-01 00:00:00
freelancer | hourly rate | hours worked | total billed | upwork fee % | Total
Jeremy
[NAME] | 40 | 3
[NAME] | 35 | 7 |  | 1.2
Adan |  |  |  | 1.2
[NAME]
Julia |  |  |  | 1.2
Exur | 14.1 | 10 |  | 1.2
Spreadsheet: 107424d1304599166-need-formula-for-a-macro-function-example
Sheet: 24

1552
Name | Amount
Name 3 | 109
Name 1 | 188
Name 3 | 176
Name 2 | 163
Name 1 | 128
Name 1 | 193
Name 2 | 192
Name 3 | 162
Name 1 | 173
Name 3 | 157
Name 1 | 176
Name 2 | 199
Name 3 | 183
Name 3 | 135
Name 2 | 135
Name 1 | 183
Name 2 | 137
Name 3 | 122
Name 1 | 174
Name 1 | 114
Name 1 | 109
Name 2 | 123
Name 1 | 114
Name 2 | 179
Name 3 | 145
Spreadsheet: 8de27a59-86fe-40d2-abfd-51d24c1ddf5b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5216 | 32627 | [NAME] | Chaffey | AUS | 0 | [NAME] | 00:03:31 | 01:15:57 | 00:02:26 | 00:29:07 | 1 | [NAME]
5216 | 32110 | [NAME] | Moreau | CAN | 0 | 00:34:08 | 00:03:23 | 01:16:41 | 00:02:28 | 00:32:52 | 2 | 02:29:30
5216 | 32628 | George | Gallego | USA | 0 | 00:36:59 | 00:03:53 | 01:27:07 | 00:02:21 | 00:33:15 | 3 | 02:43:34
5216 | 22738 | Rafael | López Ordoñez | ESP | 0 | [NAME] | 00:04:18 | 01:31:11 | 00:02:24 | 00:37:23 | 4 | 02:57:43
Spreadsheet: 885731d1735565754-calculate-completion-date-using-duration-complete-todays-date-calculate-completion-date-using-duration-complete-todays-date
Sheet: Sheet1

 | Task duration in days
 | % completion as at | 2024-12-30 00:00:00 | 0.5 |  | 2024-12-30 00:00:00 | 0.1 |  | 2024-12-30 00:00:00 | 0.9
 | # days to go
 | Predicted completion date
 | Predicted Completion Date = Today's Date + Task Duration * (1 - % Completion)
Spreadsheet: acc39e1d-2806-4f65-bb20-c84d1af89679
Sheet: 12c

Product | AUD* | CAD | CHF | DKK | KRW | NOK | NZD | SEK | ZAR | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated swap dollar volumes, week ending July 26, by product type and major currency (value of all trades in millions of USD), cleared swaps only, all participant types and tenors.  Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: larry_may__21651__OPTIONMODEL
Sheet: SPREAD OPTION

PUT/CALL | 1 | 1 | 1 | 1 | 1
PIPE ONE |  |  | 4.52 | 4.3875 | 3.81
PIPE TWO | 3.273 | 3.183 | 3.15 | 3 | 2.84 |  | 3.04 | 3.13 | 3.15 | 3 | 2.84
STRIKE | 0.82 | 0.8 | 1.15 | 1.15 | 1.15
EXPIRATION | 2000-08-30 00:00:00 | 2001-08-30 00:00:00 | 2001-01-30 00:00:00 | 2001-02-27 00:00:00 | 2001-03-29 00:00:00
TIME
VOL 1 |  |  | 0.45 | 0.45 | 0.45
VOL 2 | 0.33 | 0.27 | 0.4 | 0.4 | 0.4
CORR | 0.9 | 0.9 | 0.97 | 0.97 | 0.97
INT. RATE | 0.06 | 0.06 | 0.06 | 0.06 | 0.06
VALUE
DELTA
GAMMA
spread vol
 |  | 0.2368680047351198
 |  | 0.2456640859965758
Spreadsheet: 113471d1309363345-multiple-if-function-book1_sophy_1402
Sheet: Sheet1

Name | Referral Date | Appointment Date | Waiting Time
Name 1 | 2011-06-01 00:00:00 | 2011-06-17 00:00:00 | 16
Name 2 | 2011-06-02 00:00:00 |  | 27
Name 3 | 2011-06-03 00:00:00 | 2011-06-19 00:00:00 | 16
Name 4 | 2011-06-04 00:00:00 |  | 25
Name 5 | 2011-06-05 00:00:00 |  | 24
Name 6 | 2011-06-06 00:00:00 | 2011-06-22 00:00:00 | 16
Name 7 | 2011-06-07 00:00:00 | 2011-06-23 00:00:00 | 16
Name 8
Name 9 | 2011-06-09 00:00:00 | 2011-06-25 00:00:00 | 16
Name 10 |  | 2011-06-26 00:00:00
Name 11 | 2011-06-11 00:00:00 | 2011-06-27 00:00:00 | 16
Name 12 | 2011-06-12 00:00:00 | 2011-06-27 00:00:00 | 15
Spreadsheet: 2d3952d8-fa73-45c3-a7c3-b21711f4b1cb
Sheet: Sheet1

Unnamed: 0 | Tuarascáil Ioncaim & Caiteachais | Unnamed: 2
Teideal an Deontais:
Uimh. Arn:
Uimh. Iarratais:
Comhaltas / Ainm an ealaíontóra:
Bliain
 | Ioncam | €
 | An Chomhairle Ealaíon
 | Ioncam ó dhíol ticéad
 | [NAME]
 | Ráthaíochtaí
 | [NAME]
 | Urraíocht
 | Eile
 | Iomlán
 | Caiteachas | €
 | Tuarastail & Táillí
 | Costais theicniúla agus léiriúcháin
 | Fógraíocht & Poiblíocht
 | Riarachán
 | Taisteal
 | Cóiríocht
 | Eile
 | Iomlán
Síniú *
 | * tá sé riachtanach go ndéanfadh duine a bhfuil údarás acu an tuarascáil I&C a shíniú
Spreadsheet: 33102d1229380667-removing-div-0-div-error
Sheet: Sheet2

INGREDIENTS | serving size | measurement | servings | calories /serving | [NAME] per serving | sat fat /serving | carbs per serving | fiber per serving | sugar per serving | protein per serving | total calories | total fat | total sat fat | total carbs | total fiber | total sugar | total protein |  | DIRECTIONS:
this should come out as 50 total calories not 7600 | 150 | grams | 75 | 100 |  |  |  |  |  |  | 50 | 0 | 0 | 0 | 0 | 0 | 0 |  | the formula I used for the total calories in b28 is    =SUM(D4*E4)+(D5*E5)+(D6*E6)+(D7*E7)+(D8*E8)+(D9*E9)+(D10*E10)+(D11*E11)+(D12*E12)+(D13*E13)+(D14*E14)+(D15*E15)+(D16*E16)+(D17*E17)+(D18*E18)+(D19*E19)+(D20*E20)+(D21*E21)+(D22*E22)+(D23*E23)+(D24*E24)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | but unless I put in .5 instead of 75 as in D4 the above caclulation is incorrect.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INSTEAD OF HAVING COLUMNS L THRU R (& CLUTTERING UP THE WORKSHEET) FOR THE TOTALS IS IT POSSIBLE TO HAVE IT ALL CALCULATED AT THE BOTTOM (TOTAL CALORIES IN COLUMN B ROW 52)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I have tried using    =SUM(D4/B4*E4)+(D5/B5*E5)+(D6/B6*E6)+(D7/B7*E7)+(D8/B8*E8)+(D9/B9*E9)+(D10/B10*E10)+(D11/B11*E11)+(D12/B12*E12)+(D13/B13*E13)+(D14/B14*E14)+(D15/B15*E15)+(D16/B16*E16)+(D17/B17*E17)+(D18/B18*E18)+(D19/B19*E19)+(D20/B20*E20)+(D21/B21*E21)+(D22/B22*E22)+(D23/B23*E23)+(D24/B24*E24)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | But I get the DIV/0!  in b25        I have also tried adding if(isblank(b4),"",  in front of SUM but I get the same error as well as      =IF(B4=0,0,SUM     as well as =IF(B4=0,"",SUM     all with the same result
total calories ====> | #N/A |  |  | carbs per recipe ====> |  |  | correct formula?? |  |  |  | total calories |  | 50 |  | calories / serving
servings per recipe ====> |  |  |  | carbs ([NAME]) per serving ====> |  |  | 0 |  |  |  | total fat |  | 0 |  | fat / serving
calories per serving ====> | 0 |  |  | fiber per recipe ====> |  |  | correct formula ?? |  |  |  | total sat fat |  | 0 |  | sat fat / serving
fat per recipe ====> | correct formula?? |  |  | [NAME] per serving ====> |  |  | 0 |  |  |  | total carbs |  | 0 |  | carbs / serving
[NAME] per serving ====> | 0 |  |  | sugar per recipe ====> |  |  | correct formula?? |  |  |  | total fiber |  | 0 |  | fiber / serving
sat fat per recipe ====> | correct formula?? |  |  | sugar per serving ====> |  |  | 0 |  |  |  | total sugar |  | 0 |  | sugar / serving
sat fat per serving ====> | 0 |  |  | protein per recipe ====> |  |  | correct formula?? |  |  |  | total protein |  | 0 |  | protein / serving
 |  |  | protein (grams) per serving ====> |  |  |  | 0 |  |  |  |  | servings per recipe
Spreadsheet: 770911d1646330079-ledger-transfering-to-monthly-calendar-book2
Sheet: Sheet Sample 2

 |  |  |  |  |  | Grand Total
Service Type | Event | Date | Expense Type | GL Code | GL Sub | Amount | Approved By |  | Employee Benefit | Doctors | EMS Lounge | Volunteers | Business
In House |  | 2022-02-02 00:00:00 | Employee Benefit Meals |  |  | 750 |  | January
In House |  | 2022-04-05 00:00:00 | Medical Staff Meals |  |  | 15 |  | February
In House |  | 2022-04-02 00:00:00 | Volunteer Meals |  |  | 35 |  | March
In House |  | 2022-08-25 00:00:00 | Business Meals |  |  | 500 |  | April
 |  | 2022-08-15 00:00:00 | Business Meals |  |  | 275 |  | May
 |  |  |  |  |  |  |  | June
 |  |  |  |  |  |  |  | August
 |  |  |  |  |  |  |  | September
 |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  | December
 |  |  |  |  |  |  |  | Total
Spreadsheet: 84399d1284463847-index-and-match-or-lookup-formula-copy-of-demo-excel
Sheet: October

 |  | month Number
 | October | 10
 | Name | Acount Number | Code | Amount | Date received
 | Mr A | 334 | 1001 | 10200 | 2010-09-05 00:00:00
 | Mr B | 34534 | 1003 | 5621 | 2010-09-07 00:00:00
 | Mr C | 2345 | 1005 | 9522 | 2010-09-15 00:00:00
 | Mr D | 4535 | 1006 | 6520 | 2010-09-06 00:00:00
 | Mr F | 3453 | 1008 | 6181 | 2010-09-07 00:00:00
 | Mr G | 1911.9 | 1009.7 | 5467.1 | 2010-09-07 00:00:00
 | Mr H | 3456 | 1011.4 | 4753.2 | 2010-09-09 00:00:00
 | Mr I | 3456 | 1013.1 | 4039.3 | 2010-09-05 00:00:00
 | Mr J | 54634 | 1014.8 | 3325.4 | 2010-09-07 00:00:00
 | Mr K | 546354 | 1016.5 | 2611.5 | 2010-09-12 00:00:00
 | Mr T | 546 | 1018.2 | 1897.6 | 2010-09-06 00:00:00
 | Mr R | 45 | 1019.9 | 1183.7 | 2010-09-05 00:00:00
 | Mr S | 5456 | 1021.6 | 469.800000000001 | 2010-09-15 00:00:00
 | Mr V | 345 | 1023.3 | 5662 | 2010-09-05 00:00:00
 | Mr Z | 3456 | 1025 | 9522 | 2010-09-07 00:00:00
 | Mr AA | 2345 | 1005 | 245 | #N/A
 | Mr I U | 4535 | 1006 | 42 | #N/A
 | Mr RR | 3453 | 1008 | 1183.7 | #N/A
 | Mr VV | 1911.9 | 1009.7 | 4524 | #N/A
 | Mr DD | 3456 | 1011.4 | 4524 | #N/A
 | Mr TT | 2345 | 1013.1 | 454 | #N/A
 | Mr BB | 4535 | 1005 | 5445 | #N/A
 | Mr F F | 3453 | 1006 | 52 | #N/A
 | Mr GG | 1911.9 | 1008 | 52 | #N/A
 | Mr JJ | 3456 | 1009.7 | 452452 | #N/A
 | Mr ZZ | 2345 | 1011.4 | 425245 | #N/A
 | Mr HH | 4535 | 1013.1 | 452 | #N/A
 | Mr KK | 3453 | 1025 | 52 | #N/A
 | Mr CC | 1911.9 | 1025 | 524 | #N/A
 | Mr SS | 3456 | 1025 | 454 | #N/A
Spreadsheet: 781015d1652944149-formula-to-sort-lowest-value-of-doublets-returning-criteria-aligw
Sheet: Ark1

 |  | Customer | Returning | Price
 |  | 56615 |  | 68.5
 |  | 153454 |  | 456
 |  | 6351351 |  | 15
 |  | 6468 |  | 95 | This should return single in A5, because it's the lowest price of the 2 on that customer
 |  | 635418564 |  | 541
 |  | 153513 |  | 15
 |  | 6548645 |  | 2123
 |  | 51356 |  | 61
 |  | 115 |  | 15461
 |  | 54561516 |  | 5641
 |  | 541561 |  | 5000 | Returning
 |  | 6468 |  | 750 | This should return single in A13, because it's 2 equal prices(750) and I only want 1 showing
 |  | 6468 |  | 750 | As long as just one is "Returning", this should work for you.
 |  | 879 |  | 81
 |  | 7545451 |  | 351
 |  | 4664 |  | 651
 |  | 8944 |  | 651
 |  | 84968964 |  | 1561
 |  | 541561 |  | 3000 | This should return single in A20, because it's the lowest price of the 2 on that customer
Spreadsheet: 3befac8a-6c9e-4e6c-ba88-e62f55ba0016
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Name | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  | Learner ID
 |  |  |  | School/College/University
Marketing, Sales and Service: Distribution and Logistics
Career Pathway Plan of Study for ►Learners ►Parents ►Counselors ►Teachers/Faculty
This Career Pathway Plan of Study (based on the Distribution and Logistics Pathway of the Marketing, Sales and Service [NAME]) can serve as a guide, along with other career planning materials, as learn-
ers continue on a career path. Courses listed within this plan are only recommended coursework and should be individualized to meet each learner’s educational and career goals. *This Plan of Study, used for
learners at an educational institution, should be customized with course titles and appropriate high school graduation requirements as well as college entrance requirements.
EDUCATION | LEVELS | GRADE | [NAME] | Math | Science | Social Studies/ Sciences | Other Required Courses Other Electives Recommended       Electives                         Learner Activities | *Career and Technical Courses                    and/ or Degree Major Courses for        Distribution and Logistics Pathway | SAMPLE                                   Occupations Relating                            to This Pathway
 |  | Interest Inventory Administered and Plan of Study Initiated for all Learners
[NAME] |  | 9 |  |  |  |  |  |  | ►Administrative Support                         .   Representative ►Customer Service Representative ►Distribution Coordinator ►Inventory Manager/Analyst ►Logistics Analyst/Engineer ►Logistics Manager ►Materials Manager ►Shipping/Receiving Administrator ►Shipping/Receiving Clerk ►Traffic Manager ►Transportation Manager ►Warehouse Manager
 |  | 10
 |  | 11
 |  | College Placement Assessments-Academic/Career Advisement Provided
 |  | 12
 |  | Articulation/Dual Credit Transcripted-Postsecondary courses may be taken/moved to the secondary level for articulation/dual credit purposes.
POSTSECONDARY |  | Year 13
 |  | Year14
 |  | Year 15
 |  | Year 16
 |  |  |  |  |  | Project funded by the U.S. Department of Education (VO51B020001)