tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 385584a6-96bc-48da-b544-79ffd9a9b294
Sheet: Sheet1

2012 DUMONT SOCCER LEAGUE REGISTRATION (Please Print) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
PRIMARY CONTACT INFORMATION (parent/guardian) |  |  |  |  | PARTICIPANT MEDICAL INFORMATION
First Name (parent)
Last Name |  |  |  |  | Emergency Contact
 |  |  |  |  | First Name
Street
 |  |  |  |  | Last Name
City
 |  |  |  |  | Phone Number
State
Zip Code
 |  |  |  |  | OTHER PARTICIPANT INFORMATION  (CIRCLE ONE)
Telephone
 |  |  |  |  | [NAME] |  | Youth S | [NAME]
ACCOUNT INFORMATION (will allow you to access |  |  |  |  |  |  | Youth M | [NAME]
your account online) |  |  |  |  |  |  | Youth L | [NAME]
Create a User Name |  |  |  |  |  |  |  | [NAME]
League will assign if you do not create above.
Create a Password |  |  |  |  | Short Size |  | Youth S | [NAME]
League will assign if you do not create above. |  |  |  |  |  |  | Youth M | [NAME]
 |  |  |  |  |  |  | Youth L | [NAME]
[NAME] |  |  |  |  |  |  |  | [NAME]
PARTICIPANT (Child's name)
 |  |  |  |  | VOLUNTEER INFORMATION
Your Relationship w
Participant |  |  |  |  | Head Coach
Participant First Name |  |  |  |  | Assistant Coach
Participant Last Name |  |  |  |  | Team Parent
Gender | M | F |  |  | Field Setup
 |  |  |  |  |  |  |  |  |  |  | ,
Date of Birth
PARTICIPANT ADDRESS (if different then above) |  |  |  |  | 5 YEAR OLD CLINIC ONLY
Street |  |  |  |  | 9AM TO 10AM
City |  |  |  |  | 10AM TO 11AM
State |  |  |  |  | 11AM TO 12PM
Zip Code |  |  |  |  | We will make every effort to accommodate your choice
 |  |  |  |  | however, due to space there are no guarantees.
PARENTAL RELEASE:       I, parent/guardian of the above named child, do hereby give my approval to his/her participation in the 2012
soccer season and in any and all of the activities of the DUMONT SOCCER LEAGUE. The above participant is in good health and able to
participate in physical, vigorous activities. I willingly and voluntarily assume all risks and hereby release, absolve and hold harmless the League,
its Coaches, Officers, referees and other volunteers from any and all liability, including negligence, and damages as a result of Club activities.
In case of injury to my child, I waive all claims on behalf of my child, myself, and my child’s other parent.  In the event of illness or injury, I give my
permission to provide emergency medical care. I will arrange and assume any and all responsibility for my child’s transportation.
Parent/Guardian Signature: |  |  |  |  |  |  | Date:
Registration# |  |  |  |  | Check # |  |  | Cash
Spreadsheet: stacey_white__38836__new curve request_Vepco
Sheet: Sheet1

 |  |  |  | Enron Corporation
 |  |  |  | New Curve Setup Form
To: | Risk Analysis & Reporting ([NAME]/[NAME]) |  | Request #
From: | Casey Evans |  | Department: | Risk Management
Subject: | New Curve Setup |  | Date:
 | To be Completed by Book Administrator:
 |  |  |  |  | Reporting -Subledger
 | Book Administrator Name: | Casey Evans
 |  |  |  |  | MTM | Prud | Realized
 | Trader Requesting New Curve: | [NAME]
 | Curve Code: | R1V
 | Full Name and Description of Curve: | VEPCO
 | Commodity: | PWR
 | Unit of Measure: | MW/ hour
 | [NAME]: | R1E
 | To be Provided by Risk Analysis & Reporting/RAC:
 | [NAME]. Factor:
 | Curve Setup Checklist: | Undertaken by (please initial): | Date:
1 | Add Curve to Trading System
2 | [NAME] to GRMS Benchmark Definitions
3 | [NAME] to GRMS Value at Risk
Spreadsheet: 810528d1671828861-row-distribution-testing-hd
Sheet: Data Needed

[NAME]: |  |  | Dist 1: |  | 6
[NAME] by 8: |  |  | Dist 2: |  | 11 |  | Roberts D | 1 |  |  | Roberts D | 1 |  |  | Roberts D | 1
Round: |  |  | Dist 3: |  | 17 | 2 | [NAME] O | 5 |  | 2 | [NAME] O | 5 |  | 2 | [NAME] O | 5
 |  |  | Dist 4: |  |  | 3 | [NAME] | 126 |  | 3 | [NAME] | 126 |  | 3 | [NAME] | 126
 |  |  | Dist 5: |  |  | 4 | Atikinson N | 198 |  | 4 | Atikinson N | 198 |  | 4 | Atikinson N | 198
 |  |  | Dist 6: |  |  | 5 | Sheldon A | 348 |  | 5 | Sheldon A | 348 |  | 5 | Sheldon A | 348
 |  |  |  |  |  | 6 | Shaw C | 378 |  | 6 | Shaw C | 378 |  | 6 | Shaw C | 378
 |  |  |  |  |  |  | Blogs F | 497 |  | 1 | Blogs F | 497 |  | 1 | Blogs F | 497
 |  |  |  |  |  | 2 | Smith A | 504 |  | 2 | Smith A | 504 |  | 2 | Smith A | 504
 |  |  |  |  |  | 3 | Bradley K | 1188 |  | 3 | Bradley K | 1188 |  | 3 | Bradley K | 1188
 |  |  |  |  |  | 4 | Farden U | 1279 |  | 4 | Farden U | 1279 |  | 4 | Farden U | 1279
 |  |  |  |  |  | 5 | [NAME] | 1360 |  | 5 | [NAME] | 1360 |  | 5 | [NAME] | 1360
 |  |  |  |  |  |  | Sunny J | 1936 |  | 1 | Sunny J | 1936 |  | 1 | Sunny J | 1936
 |  |  |  |  |  | 2 | Adams H | 2070 |  | 2 | Adams H | 2070 |  | 2 | Adams H | 2070
 |  |  |  |  |  | 3 | [NAME] | 2071 |  | 3 | [NAME] | 2071 |  | 3 | [NAME] | 2071
 |  |  |  |  |  | 4 | O'Hart | 2248 |  | 4 | O'Hart | 2248 |  | 4 | O'Hart | 2248
 |  |  |  |  |  | 5 | [NAME] T | 2425 |  | 5 | [NAME] T | 2425 |  | 5 | [NAME] T | 2425
 |  |  |  |  |  | 6 | [NAME] | 2502 |  | 6 | [NAME] | 2502 |  | 6 | [NAME] | 2502
Spreadsheet: 8874ac1b-c96f-4549-b0ee-9a2d604c0bc7
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Elbe-Röder-Dreieck - Variante 1
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 15 | 2812 | 2834 | 2567 | 2301
15 - 65 | 17118 | 15798 | 14179 | 12529
65 und mehr | 6682 | 6698 | 7141 | 7595
Insgesamt | 26612 | 25330 | 23887 | 22425
%
unter 15 | 10.56666165639561 | 11.18831425187525 | 10.74643111315778 | 10.26086956521739
15 - 65 | 64.3243649481437 | 62.36873272799053 | 59.3586469627831 | 55.87068004459309
65 und mehr | 25.10897339546069 | 26.44295302013423 | 29.89492192405911 | 33.86845039018952
Insgesamt | 100 | 100 | 100 | 100
Abhängigkeitsquotient
Jugendquotient | 16.42715270475523 | 17.93897961767312 | 18.1042386628112 | 18.36539228988746
Altenquotient | 39.03493398761537 | 42.39777186985695 | 50.36321320262361 | 60.61936307765983
Gesamtquotient | 55.4620866923706 | 60.33675148753007 | 68.4674518654348 | 78.9847553675473
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: ce011653-06ff-4d27-995e-7798a25bfb7d
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
CMIL | Test | CMIL | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m.; | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
CMIL | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
CMIL | Result | CMIL | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6175-4 | Panicum milliaceum Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 270330d1381438235-formula-help-with-multiple-tabs-sampe-workbook-for-forum-1-
Sheet: Dept 3

 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7
 | Revenue | 2706405.504000001 | 2771640.067679999 | 3032062.491674305 | 3176781.343223644 | 3399278.070435699 | 3467263.631844413 | 3546298.243945634
 | Expenses | 1759163.5776 | 1801566.043992 | 1970840.619588298 | 2064907.873095369 | 2209530.745783205 | 2253721.360698868 | 2305093.858564662
 | Net Income
Spreadsheet: 116195d1311669018-need-help-in-complicated-nested-function-to-change-arrangements-of-data-display-example-workbook
Sheet: Required Data Arrangement

ARTICLE NUMBER | SIZE | COLOR | CODE | Retail Price | Discount | Nett Price | Qty | Nett Price | Invoice Number | Date | Cashier | Serving staff 1 | Serving Staff 2
ABC | 5 | WASHED | F | 129 | $ | 25.8 | 1 | 103.2 | 1226012546 | 2011-01-01 00:00:00 | STAFF A | STAFF B | STAFF C
CDE | 11 | NY/BLU | F | 49 | $ | 4.9 | 1 | 44.1 | 1226012546 | 2011-01-01 00:00:00 | STAFF A | STAFF B | STAFF C
FGH | 0 | MTI | F | 25 | $ | 20 | 1 | 5 | 1226012546 | 2011-01-01 00:00:00 | STAFF A | STAFF B | STAFF C
[NAME] | 11 | NY/BLU | E | 49 | $ | 0 | -1 | -49 | 1226012547 | 2011-01-01 00:00:00 | STAFF A | STAFF B | STAFF C
YYY | 12 | NY/BLU | S | 49 |  | 0 | 1 | 49 | 1226012547 | 2011-01-01 00:00:00 | STAFF A | STAFF B | STAFF C
AAA | 5 | PEACH | S | 149 |  | 0 | 1 | 149 | 1226012548 | 2011-01-02 00:00:00 | STAFF A | STAFF B | STAFF C
BBB | 6 | STING | S | 99 |  | 0 | 1 | 99 | 1226012548 | 2011-01-02 00:00:00 | STAFF A | STAFF B | STAFF C
CCC | 4 | PK/YLW | S | 99 |  | 0 | 1 | 99 | 1226012548 | 2011-01-02 00:00:00 | STAFF A | STAFF B | STAFF C
Spreadsheet: 87362d1287166907-excel-2007-macro-gives-a-run-time-error-1004-ff-code-issue
Sheet: Sheet1

Sub FFReport()
'
' FFReport Macro
' First failure after inspection for Tar-Heel
'
'
Range("F1").Select
Selection.AutoFilter
ActiveSheet.Range("$A$1:$G$777").AutoFilter Field:=6, Criteria1:="<>"
Columns("D:D").Select
Selection.Delete Shift:=xlToLeft
Range("E2").Select
ActiveWorkbook.Worksheets("20101011060401grayner_eventsbas").AutoFilter.Sort. _
SortFields.Clear
ActiveWorkbook.Worksheets("20101011060401grayner_eventsbas").AutoFilter.Sort. _
SortFields.Add Key:=Range("B2:B777"), SortOn:=xlSortOnValues, Order:= _
xlAscending, DataOption:=xlSortNormal
ActiveWorkbook.Worksheets("20101011060401grayner_eventsbas").AutoFilter.Sort. _
SortFields.Add Key:=Range("A2:A777"), SortOn:=xlSortOnValues, Order:= _
xlAscending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("20101011060401grayner_eventsbas").AutoFilter. _
Sort
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Range("F2").Select
ActiveCell.FormulaR1C1 = _
"=IF(AND(R[-1]C[-3]=""Inspection"",RC[-4]=R[1]C[-4],RC[-3]<>""Inspection""),1,0)"
Selection.FillDown
Range("F1525").Select
Selection.End(xlUp).Select
ActiveSheet.Range("$A$1:$F$1525").AutoFilter Field:=6, Criteria1:="1"
Range("F778").Select
ActiveWindow.SmallScroll Down:=-192
ActiveSheet.Range("$A$1:$F$1525").AutoFilter Field:=5, Criteria1:="<>"
ActiveWindow.SmallScroll Down:=171
Range("A1:F1526").Select
Range("F1526").Activate
Selection.Copy
Sheets.Add After:=Sheets(Sheets.Count)
ActiveSheet.Paste
Columns("A:A").EntireColumn.[NAME]
Columns("A:G").Select
Columns("A:G").EntireColumn.[NAME]
Range("E2").Select
Application.CutCopyMode = False
ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Add Key:=Range("E2:E74") _
, SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("Sheet1").Sort
.SetRange Range("A1:F74")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Selection.Subtotal GroupBy:=5, Function:=xlCount, [NAME]), _
Replace:=True, PageBreaks:=False, SummaryBelowData:=True
Cells.Replace What:="Count", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
ActiveSheet.Outline.ShowLevels RowLevels:=2
ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Add Key:=Range("F2:F124") _
, SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("Sheet1").Sort
.SetRange Range("A1:F123")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
End Sub
Spreadsheet: 120991d1315736849-picking-out-the-10-highest-numbers-from-a-table-large_10
Sheet: Sheet1

47 | 59 | 93 | 43 | 64 | 2 | 47 | 27 | 69 | 100
52 | 81 | 72 | 65 | 69 | 22 | 95 | 37 | 25 | 5
43 | 68 | 47 | 85 | 68 | 52 | 98 | 27 | 83 | 80
80 | 84 | 80 | 94 | 36 | 100 | 67 | 71 | 27 | 50
65 | 30 | 1 | 3 | 62 | 2 | 55 | 40 | 84 | 14
32 | 33 | 55 | 91 | 95 | 71 | 96 | 74 | 82 | 27
74 | 61 | 21 | 98 | 78 | 32 | 21 | 39 | 25 | 30
83 | 26 | 97 | 75 | 77 | 58 | 64 | 39 | 92 | 89
51 | 88 | 22 | 45 | 73 | 59 | 60 | 27 | 30 | 76
47 | 14 | 88 | 44 | 35 | 95 | 95 | 67 | 44 | 8
 | NAMED RANGE/FORMULA |  | TESTF
 |  |  | [NAME] IS =TESTF
 |  |  | if tenth number is repeated that will also be high lighted
 |  | eg | 100,99,98,97,96,95,94,93,92,91,91,91 |  | all 91s will highlite as they are =10th
Spreadsheet: 799944d1665408049-count-and-display-duplicates-in-an-array-display_duplicates
Sheet: display_duplicates

COUNT AND DISPLAY DUPLICATES OF A COLUMN |  |  |  | (case-sensitive)
array: | =A8:A30
formula:
expected result: | 2 A, 3 B, 2 b
grade
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
Spreadsheet: mark_taylor__24699__Potential Customers EOL
Sheet: C Report

EOL Registration Report
Enron Commercial: |  |  |  |  |  |  | Originator:
Counterparty Information
Parent Company: |  |  |  |  |  |  |  | Location
Counterparty’s Full Legal Name:
Complete Address:
Commercial Contact: |  |  |  |  |  | Credit Contact:
Phone: |  |  |  | Fax: |  |  |  | Mail:
Invoice Contact: |  |  |  |  |  |  |  | Phone:
Complete Invoice/Payment Address:
Federal Tax ID #: |  |  |  |  | Provincial Tax ID #: |  |  |  |  | VAT/ IVA Rate:
[NAME]? (yes or no): |  |  |  |  | Special Instructions:
Please attach a copy of documentation verifying counterparty information and fax to: (713)853-0561.
Approach Record
Who did you Meet: |  |  |  |  |  |  |  | Date of Meeting
[NAME]:
Response you got:
What did you leave him: | Presentation: |  | Brochure: |  | PA: |  | ETA: |  | GTC's |  | RF
What products was he interested in: |  |  | N. Gas |  | Power Phy |  | Power Fin |  | Other:
Comments on Products:
Which are your next steps:
Other Comments:
Customer Profile
Gas Consumption: | Volume: |  |  |  | LDC: |  |  |  | Contract Expiration
Power Consumption: | Volume: |  |  |  | Provider: |  |  |  | Contract Expiration
Fuel Consumption: | Volume: |  |  |  | Provider: |  |  |  | Does he hedge:
Follow Up
Legal Documents: | PA |  | ETA |  | GTC - N Gas |  | GTC - P Phy |  | GTC - P Fin |  | Other
Comments to Legal Documents:
Credit Approval: | Financials |  | Colateral or [NAME]:
Estimated Exposure: | $ / USD: |  |  |  | Term:
Comments:
Password: | Guest User |  | Trading User |  | Profile:
Spreadsheet: 733921d1621892625-copy-and-transpose-formula-auto-1-
Sheet: Payables

I kindly asking for a formula which can automatically transpose data from Auto sheet to Payables  sheet as shown in the desired outcome.
DESIRED OUTCOME
1 | ST 002 | Net Salaries
 | Receipt | Invoice | Debit | Credit | Cumulative Balance
2021-01-01 00:00:00 | 7 | 2 | 0 | 0 | 0
2021-01-25 00:00:00 | 0 | January |  | 185503.5 | -185503.5
2021-01-26 00:00:00 | 16 | 5 | 6581 |  | -178922.5
2021-01-26 00:00:00 | 17 | 5 | 5793 |  | -173129.5
2021-01-26 00:00:00 | 18 | 5 | 4461 |  | -168668.5
2021-01-26 00:00:00 | 19 | 5 | 7913 |  | -160755.5
2021-01-26 00:00:00 | 20 | 5 | 4953 |  | -155802.5
2021-01-26 00:00:00 | 21 | 5 | 4043 |  | -151759.5
2021-01-26 00:00:00 | 22 | 5 | 4584 |  | -147175.5
2021-01-26 00:00:00 | 23 | 5 | 11043 |  | -136132.5
2021-01-26 00:00:00 | 24 | 5 | 3399 |  | -132733.5
2021-01-26 00:00:00 | 25 | 5 | 4580 |  | -128153.5
2021-01-26 00:00:00 | 26 | 5 | 11134 |  | -117019.5
2021-01-26 00:00:00 | 27 | 5 | 4107 |  | -112912.5
2021-01-26 00:00:00 | 28 | 5 | 4359 |  | -108553.5
2021-01-26 00:00:00 | 29 | 5 | 7929 |  | -100624.5
2021-01-26 00:00:00 | 30 | 5 | 10480 |  | -90144.5
2021-01-26 00:00:00 | 31 | 5 | 9370 |  | -80774.5
2 | ST 003
 | Receipt | Invoice | Debit | Credit | Cumulative Balance
2021-01-01 00:00:00 | 2 | 2 | 0 | 0 | -1983.41
 | 0 | January
2021-02-25 00:00:00 | 0 | february |  |  | -5950.23
2021-03-25 00:00:00 | 0 | march |  |  | -7933.64
2021-03-31 00:00:00 | 136 | 136 |  |  | -2.273736754432321e-13
2021-04-25 00:00:00 | 0 | April |  |  | -30183.13
3
 | Receipt | Invoice | Debit | Credit | Cumulative Balance
2021-01-01 00:00:00 | 1 | 1 | 0 | 0 | -4054.46
 | 0 | January
2021-02-25 00:00:00 | 0 | february |  |  | -12163.26
2021-03-25 00:00:00 | 0 | March |  |  | -16217.66
2021-03-31 00:00:00 | 140 | 140 |  |  | -0.06000000000040018
Spreadsheet: 548899d1511367326-how-to-assign-a-random-number-from-a-range-of-cells-that-meet-given-criteria-random-city-with-numbers
Sheet: Sheet1

Rand |  | 9 | << Choose Number
0.02 | 5 |  | << [NAME] |  |  |  |  |  |  | So if I select the #9 in C1, 40% of the time C3 will return 1, and 20% of the time it will return the other 3 values
0.4 | -2 |  | << Returns a random value of Column B for all items where A=C2
0.44 | 1
0.47 | -3 | You will need to sort column A from Small to Large for the Match formula to work correctly
0.61 | -5
0.74 | 2 | << Example of what I think you want.
0.82 | -4 | Use numbers only might be easier.
0.88 | 3 | Press F9 a few times to pluck out random set values.
0.93 | 5
1.05 | 5
1.2 | 3
1.22 | 3
1.24 | -1
1.26 | 5
1.28 | -2
1.32 | 3
1.4 | -4
1.46 | -1
1.51 | 5
1.51 | 5
1.51 | -2
1.52 | 2
1.69 | 3
1.75 | -4
1.81 | -2
1.86 | 5
2.01 | 4
2.1 | 5
2.28 | -3
2.29 | 2
2.32 | 3
2.56 | 1
2.69 | -2
2.72 | -5
2.78 | -4
2.8 | 5
2.88 | -4
2.92 | 4
3.03 | -3
3.04 | 2
3.07 | -5
3.08 | 4
3.14 | 2
3.25 | -5
3.44 | 4
3.56 | 2
3.56 | 1
3.6 | -4
3.72 | 1
3.77 | -2
4.25 | 2
4.31 | 3
4.34 | 4
4.45 | 2
4.61 | 4
4.81 | -3
5 | 1
5 | 3
5.07 | 5
5.3 | 5
5.57 | 5
5.58 | -4
5.58 | -4
5.62 | -4
5.66 | -3
5.69 | 3
5.72 | 2
5.97 | 3
6.3 | -5
6.31 | -4
6.42 | -4
6.46 | 4
6.48 | 5
6.51 | 1
6.82 | -4
6.84 | 5
7 | 2
7.03 | -4
7.06 | 2
7.11 | 3
7.13 | -2
7.15 | 3
7.19 | 1
7.73 | -5
7.84 | 4
7.89 | 2
7.89 | 3
8 | -1
8.11 | -3
8.44 | 5
8.44 | -5
8.55 | -1
8.62 | -2
8.78 | 3
8.9 | -3
9.1 | 1
9.9 | 3
9.9 | 2
9.9 | -5
9.9 | 1
Spreadsheet: 169548d1342933678-interesting-data-extraction-and-calculation-conundrum-example-sales-report
Sheet: Service Printout

 | Report Date:   07/21/2012
 | Day  of
 |  | Margin
 | ADN | 3174.38
 | CSA | 2305.53
 | SML | 2212.25
 | RVR | 2017.49
 | JMR | 2000
 | BAM | 1764.58
 | JFC | 1609.69
 | RJM | 1565.55
 | JDK | 1068.33
 | JTF | 790.86
 | BWW | 507.07
 |  | 19015.73
Spreadsheet: 808896d1670748008-filter-function-how-to-condense-the-include-argument-include-argument-of-the-filter-function-ans-1-
Sheet: Sheet1

All Items | Tree | All Items | <- Drop-Down Box
[NAME] | Plant
Bowl | Tree | Plant |  | Plant
Bus | Cat | Tree |  | Tree
Cat | Plant | Cat |  | Cat
Chair | Rabbit | Plant |  | Plant
Honey | Jacket | Rabbit |  | Rabbit
Jacket | Bus | Jacket |  | Jacket
Key | Plant | Bus |  | Bus
Orange | Orange | Plant |  | Plant
Pants | Rabbit | Orange |  | Orange
Plant | Cat | Rabbit |  | Rabbit
Rabbit | Chair | Cat |  | Cat
Table | Orange | Chair |  | Chair
Tree | Orange | Orange |  | Orange
 | Key | Orange |  | Orange
 | Orange | Key |  | Key
 | Pants | Orange |  | Orange
 | Chair | Pants |  | Pants
 | Rabbit | Chair |  | Chair
 | Rabbit | Rabbit |  | Rabbit
 | Cat | Rabbit |  | Rabbit
 | Rabbit | Cat |  | Cat
 | Table | Rabbit |  | Rabbit
 | Key | Table |  | Table
 |  | Key |  | Key
Spreadsheet: 299b6199-7149-49fd-b186-9217c8ede77d
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
FLIMB | Test | FLIMB | [NAME] | [NAME] | DNA Sequencing  MLPA | EDTA (lavender-top) tube: EDTA |  |  | 20 | mL | Draw blood in a lavender-top (EDTA) tube(s). Ship 20 mL EDTA whole blood ambient. Note:  Collection date is required. | 10 mL | Specimens other than	Whole blood Anticoagulants other than	EDTA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | A final report will be attached in MayoAccess.   Test Performed By:  Athena Diagnostics                                          377 Plantation St.                                          Four Biotech Park                                          Worcester, MA  01605 | Monthly | 4-6 weeks | 4-6 weeks |  | Profile |  |  |  |  | Athena Diagnostics
FLIMB | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient | 6 days
FLIMB | Result | Z0103 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FLIMB | Billing Component | FLIMB |  | MOPATH PROCEDURE LEVEL 6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 81405
FLIMB | Billing Component | FLIMB |  | 91635MOPATH PROCEDURE LEVEL 7 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 81406
FLIMB | Billing Component | FLIMB |  | MOPATH PROCEDURE LEVEL 9 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 81408
FLIMB | Billing Component | FLIMB |  | UNLISTED MOLECULAR PATHOLOGY |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 81479
FLIMB | Billing Component | FLIMB |  | MOPATH PROCEDURE LEVEL 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 81404
Spreadsheet: 213767d1360640668-create-top-ten-list-based-on-number-of-classes-currently-overdue-desired-result
Sheet: Overdue

Overdue Top Ten
SECT | NAME | EMP | GRD | UNIT | CCODE | TITLE | DUR | INT | STATUS | COMP | DUE
Overdue Top Ten
 |  |  |  | RANK | CCODE | TITLE | QUANTITY
 |  |  |  | 1 | 002124 | EXCEPTIONAL RELEASE | 3
 |  |  |  | 2 | 002093 | AUTH SIGN ALL COND TAGS | 2
 |  |  |  | 3 | 002099 | AUTH SIGN NRTS ALL | 1
 |  |  |  | 4 | 018078 | [NAME] | 1
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 7
 |  |  |  | 8
 |  |  |  | 9
 |  |  |  | 10
Spreadsheet: 708492d1607871817-using-text-in-one-cell-keep-a-running-total-in-another-of-the-amount-in-out-of-item-pth-test-inventory-v3-shareable
Sheet: Lists

Contractors |  | Item
 |  | Tests | Cost | Retest Cost |  | Region |  | In/Out
 |  |  | 45 | 55 |  |  |  | In
 |  |  | 35 | 45 |  |  |  | Out
 |  |  | 35 | 45
 |  |  | 25 | 25
 |  |  | 15 | 15
 |  |  | 25 | 35
 |  |  | 25 | 35
 |  |  | 25 | 35
Spreadsheet: 113620d1309457922-dates-and-colouring-dummy
Sheet: Desired results

 | May | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | G
 | AACD
 | ACCE
 | CWEC
 | DTW3
 | DTWD
 | DTWE
 | [NAME]
 | JLWD
 | [NAME]
 | LWE
 | PDR1
 | PDR2
 | PDRC
 | SCD3
 | [NAME]
 | TCLD
 | TCLE
 | TMCD
 | TMCW
 | TMDD
 | TMDW
 | TPW3
 | TPWD
 | TPWE
 | WEB3
 | WEBD
 | WEBE
 | N4
 | 0
 | 2
 | 3
 | 4
 | 5
Spreadsheet: 876153d1722846756-need-formula-for-tier-incentive-calculation-calculation-doing-formula-etaf
Sheet: Dr. Ayman Helmi Aug

Profit Share
 | No of Days | Revenue | 1135440 |  |  |  |  |  |  |  | 3150
 | 30 | Salaries + Staff Direct Exp. |  |  |  |  |  |  | AL | AT | [NAME] | Ins. | EOS prov. | Gosi
 |  | [NAME]
 |  | [NAME] | 4000
 |  | Jussel | 3750 |  |  |  |  |  |  | 104
 |  | [NAME] | 3750 |  |  |  |  |  |  | 105
 |  | [NAME] | 3500 |  |  |  |  |  |  | 104
 |  | Consumables | 6329
 |  | Hospital Fees
 |  | Net To Pay
 |  | Service | Amount | % | Comm. % | Comm.
 |  | Consultation | 21200 |  | 0.5
 |  | Referral | 0 |  | 0.1
 |  | Procedure |  |  | 0.5
 |  | OR In the Clinics | 0 |  | 0.55
 |  | OR Outside the Clinics |  |  | 0.65
 |  | Other Exp.
 |  |  | 0
 |  | OHE | 15000
 |  | 2 Additional Rooms