tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: ae40529b-5cbc-4560-8d37-dc04e467e992
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
 |  | U.S. Census Bureau
 |  | Source: New Residential Construction
 |  | Housing Units Completed: United States
 |  | Seasonally Adjusted Total Units [Thousands of Units]
 |  | Period: 2008 to 2012
 |  | Data Extracted on: September 21, 2014 (6:27 pm)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2008
2009
2010
2011
2012
Spreadsheet: 106275d1303439773-sum-if-to-compare-workload-by-person-supervisorperf
Sheet: Sheet2

AM SHIFT | Sum all of column B in sheet 1 in their name | Sum all of column c in sheet 1 in their name | Sum all of column d in sheet 1 in their name | Avg of column G in their name | Avg of column j in their name | Highest number in column b in their name | Highest number in column c in their name | Total number of times/shifts in their name |  | PM Shift | Sum all of column v in sheet 1 in their name | Sum all of column w in sheet 1 in their name | Sum all of column x in sheet 1 in their name | Avg of column aa in their name | Avg of column j  in their name | Highest number in column w in their name | Highest number in column x in their name | Total number of times/shifts in their name |  | Total | Sum all of column B & V in sheet 1 in their name | Sum all of column c  & Win sheet 1 in their name | Sum all of column d & X  in sheet 1 in their name | Avg of column G and AA in their name | Avg of column j & AD  in their name | Highest number in column b & win their name | Highest number in column c & x in their name | Total number of times/shifts in their name
[NAME] |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 05c80182-0b95-4e34-a9f8-cb9860d33c5b
Sheet: Sheet1

MINORS and MAJOR AREAS By FACULTY | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
2010-11
MINOR | FACULTY of MAJOR AREA
 | APHS | BUSI | HUMA | MASC | SOSC | OTHER | SUB-TOTAL | SHARE
BUSI | 22 | 0 | 13 | 12 | 43 | 1 | 91 | 0.104
HUMA | 34 | 12 | 227 | 18 | 124 | 3 | 418 | 0.4777142857142857
MASC | 8 | 5 | 14 | 27 | 12 | 0 | 66 | 0.07542857142857143
SOSC | 48 | 3 | 76 | 8 | 160 | 5 | 300 | 0.3428571428571429
UNIVERSITY TOTAL | 112 | 20 | 330 | 65 | 339 | 9 | 875 | 1
 | 0.128 | 0.02285714285714286 | 0.3771428571428572 | 0.07428571428571429 | 0.3874285714285715 | 0.01028571428571429 |  | 0
Note: * Major areas by Faculty for students with a minor.
Spreadsheet: 167405e2-e836-4d78-92a7-aa8f33db604a
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
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 48. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (NT), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | A2413737T | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413738V | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413739W | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413740F | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413741J | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413742K | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413743L | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413744R | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413745T | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413746V | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413747W | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 582017d1531678786-team-roster-creation-team-roster
Sheet: Sheet1

 | Claims |  |  |  |  | Customer Service |  |  |  |  | Sales
Person | Day1 | Day2 | Day3 | Day4 | Day5 | Day1 | Day2 | Day3 | Day4 | Day5 | Day1 | Day2 | Day3 | Day4 | Day5
Cl1 | CL1 |  | CL1 |  | CL1 |  | CL1 |  |  |  |  |  |  | CL1
Cl2 |  | Cl2 |  | Cl2 |  | Cl2 |  |  |  | Cl2 |  |  | Cl2
CS1 | CS1 |  | CS1 |  | CS1 |  | CS1 |  |  |  |  |  |  | CS1
CS2 |  | CS2 |  | CS2 |  | CA2 |  |  |  | CA2 |  |  | CS2
S1 | S1 |  | S1 |  | S1 |  | S1 |  |  |  |  |  |  | S1
S2 |  | S2 |  | S2 |  | S2 |  |  |  | S2 |  |  | S2
Spreadsheet: 0f84d38b-70d5-4502-97b3-bfab5f2ee564
Sheet: Sheet1

CDBG Missing Data | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25
CLACKAMAS COUNTY OR
Data as of 06/01/2009
Act ID | Status | [NAME] | Matrix CD | Prop Accomp MA04 | Actual [NAME] | Total [NAME] CDBG08 | Create FT Jobs CDBG11 | Create FT Jobs LM CDBG11 | Create PT Hours CDBG11 | Create PT Hours LM CDBG11 | Retain FT Jobs CDBG11 | Retain FT Jobs LM CDBG11 | Retain PT Hours CDBG11 | Retain PT Hours LM CDBG11 | Assist Type CDBG11 | [NAME] CDBG13 | [NAME] CDBG13 | Num Very Low Incm CDBG13 | Units Start CDBG14 | Units [NAME] CDBG14 | Units Occ LM Start CDBG14 | Units Exp CDBG14 | Units [NAME] CDBG14 | Units Occ LM Exp CDBG14 | LMA % CDBG07
568 | 3 | LMH | 03 |  | 100 | 0 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
948 | 3 | LMH | 14H | 0
951 | 3 | LMH | 14A | 0
Spreadsheet: 00fc35d4-13af-4f01-9f84-d00b9faa5798
Sheet: Data Entry

SSID Previous Reporting Period | Withdrawal Date (in CCYYMMDD format) | Withdrawal Reason | Row is [NAME]? (incomplete rows will be skipped when the upload file is created) | Notes (not included in export- for your reference)
 |  |  |  |  |  | 1 | Retirement
 |  |  |  |  |  | 3 | Employer initiated
 |  |  |  |  |  | 5 | Resigned - Took another education job in Ohio
 |  |  |  |  |  | 6 | Resigned - Took another education job out of state
 |  |  |  |  |  | 7 | Resigned - Other
 |  |  |  |  |  | 8 | Employee accepted new position within district
 |  |  |  |  |  | 9 | Deceased
Spreadsheet: 97185d1296416295-help-formula-macro-search-copy-paste-cells-change-daily-help
Sheet: Help

 | Here is an example of some data that will be populated automatically on a  daily basis. | Data | What I want is a formula/macro that will search every cell under "Data" (Column C) and return only the cells starting with "A" or "a", but also ignoring cells that start with an "A" or "a" that are not part of the categories. | Results | Examples
 |  | .+-+-+-+-+. |  |  | A 123
 |  | A 123 |  |  | C 123
 |  | B 123 |  |  | a 234
 |  | C 123 |  |  | c 234
 | But I only need two cells from each category (Cells starting with A through D) to show in another column (same sheet or another, it does not matter) without empty cells between them. | D 123 | For other formulas working in another part of my spreadsheet I need them to actual be in the same spot and not all over the place. (Meaning; The Filter Comand won't work if it is just going to hide the incorrect rows) |  | a 345
 |  | a 234 |  |  | C 345
 |  | B 234 |  |  | A 456
 |  | c 234 |  |  | c 456
 |  | D 234
 |  |  |  |  | I've tried a bunch of different variations and nothing is working correctly for me. So I hope I am just missing something. Thank you if you are able to help.
 | Also the data will change daily so there is no guarantee that the first catergory  or any other category will be in the same cell as the day before. | a 345
 |  | b 345 | To make it even trickier, once a cell is identified as the first cell in each category and copied to a new cell, I also need the formula/macro (Maybe a second formula/macro) to also reproduce the cell that is two below it. (The cells starting with a "C" or "c")
 |  | C 345
 |  | D 345
 |  | ABC 123456
 | The letters being gernerated can sometimes be capital and sometimes lower case letters, but in the end they are the same thing to me.
 |  | A 456
 |  | B 456 | So in the end, the forumula/macros's would be creating the information like you see in "Examples" (Column F) that I created.
 |  | c 456
 |  | d 456
 |  | abc 456789
Spreadsheet: darrell_schoolcraft__7317__imball0202
Sheet: PG&E

56698
Day | Measured | Scheduled
1 | -246404 | -244010
2 | -244917 | -244299
3 | -242647 | -242291
4 | -244008 | -243254
5 | -246342 | -243974
6 | -251402 | -250987
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
2002-01-31 00:00:00 |  |  | 28722
2002-02-06 00:00:00
CBS Dollars
 |  |  | -143669
Spreadsheet: joe_parks__14601__POSTIONTRAX_OCT
Sheet: PERM_SWAP

 | SELL |  |  |  | BUY
BEGINNING | 66 | 2.17 |  |  |  |  |  |  |  |  | MTM
 |  |  |  |  |  |  |  |  |  |  | ROLLOFF VAULE
 |  |  |  |  |  |  |  |  |  |  | NEW DEALS
 |  |  |  |  | 16.5 | 2 |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  | 3 DAY ROLL
 |  |  | ROLL VALUE
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 756150d1637311613-can-i-dynamically-reference-the-same-cell-across-multiple-worksheets-in-if-and-textjoin-therapists-availability-dj
Sheet: Visualization

JobA | [NAME] | JobC | JobD |  | Time | Monday | Tuesday | Wednesday | Thursday | Friday
Person1 | Person11 | Person31 | Person41 |  | 07:30:00
Person2 | Person12 | Person32 |  |  | 08:15:00
Person3 | [NAME] | Person33 |  |  | 09:00:00
Person4 | Person14 | Person34 |  |  | 09:45:00
Person5 |  | Person35 |  |  | 10:30:00
Person6 |  | Person36 |  |  | 11:15:00
Person7 |  | Person37 |  |  | 12:00:00
Person8 |  |  |  |  | 01:00:00
Person9 |  |  |  |  | 01:45:00
Person10 |  |  |  |  | 02:30:00
 |  |  |  |  | 03:15:00
 |  |  |  |  | 04:00:00
 |  |  |  |  | 04:45:00
 |  |  |  |  | 05:30:00
Spreadsheet: 684575d1593447243-lookup-text-value-for-with-multiple-results-from-another-tab-time-totals-summary
Sheet: Summary

First Name | Last Name | Training Complete | Total Time |  | [NAME] | Total Pay
[NAME] | Rogers | Complete |  |  | 10 |  | *Should be $105.00
Captain | America
Iron | Man | Complete
Wonder | Women
Black | Widow | Complete
Ant | Man | Complete
Spider | Man | Complete
Nick | Fury
Hawk | Eye
Loki |  | Complete
Hulk |  | Complete
[NAME] | Coulson
Maria | Hill
Thor
Wasp |  | Complete
Black | [NAME] | Complete
[NAME] | [NAME] | Complete
[NAME] | [NAME]
Hank | Pym
[NAME] | [NAME] | Complete
[NAME] | Barton | Complete
[NAME] |  | Complete
Natasha | [NAME]
Captain | Marvel
[NAME] | Rambeau | Complete
Wolverine |  | Complete
Logan | Howlett | Complete
Dr. | Strange
Spreadsheet: 124198d1318236688-pivot-table-customizing-and-updating-kennybonesexample-1-
Sheet: Summary

Name | [NAME]
ArtNr/Name | Amount | Price
1445 - Pants | 45 | 9405
1446 - Jacket | 41 | 16318
1447 - Winter jacket | 12 | 5460
1448 - Shoes | 32 | 4992
1449 - Winter Shoes | 10 | 4560
1450 - Hard hat | 21 | 4914
Grand Total
Spreadsheet: louise_kitchen__24242__JulYTD Orig w notes
Sheet: Derivatives

Derivatives
Originator |  | Commodity |  | Team |  | Total |  | %Total
[NAME] |  | Gas |  | Derivatives
Lagrasta |  | Gas |  | Derivatives
Black |  | Gas |  | Derivatives
Abramo |  | Gas |  | Derivatives
Otto |  | Gas |  | Derivatives
Breslau |  | Gas |  | Derivatives
Smith,[NAME] |  | Gas |  | Derivatives
[NAME] |  | Gas |  | Derivatives
Ortiz |  | Gas |  | Derivatives
[NAME] |  | Gas |  | Derivatives |  | 601115
Shipos |  | Gas |  | Derivatives
Figueroa |  | Gas |  | Derivatives
Ferries |  | Gas |  | Derivatives |  | 134979
Prevatt |  | Gas |  | Derivatives
Feitler |  | Gas |  | Derivatives
Titus |  | Gas |  | Derivatives
[NAME] |  | Gas |  | Derivatives |  | 29707
Singer |  | Gas |  | Derivatives
[NAME] |  | Gas |  | Derivatives |  | 17813
Enduser |  | Gas |  | Derivatives |  | 17739.32000000007
Berkeland |  | Gas |  | Derivatives |  | 17148
Wilson |  | Gas |  | Derivatives |  | 13500
Barbe |  | Gas |  | Derivatives |  | 7600
Villarreal |  | Gas |  | Derivatives |  | 7360
Racicot |  | Gas |  | Derivatives |  | 5059
DePaolis |  | Gas |  | Derivatives |  | 4650
Pollan |  | Gas |  | Derivatives |  | 2275
Sheetal |  | Gas |  | Derivatives |  | 1847
Munir |  | Gas |  | Derivatives |  | 1007
Seske |  | Gas |  | Derivatives |  | 1000
Breglam |  | Gas |  | Derivatives |  | 273
Total
Spreadsheet: 66312d1266999916-create-list-from-pivot-table-listfrompivot
Sheet: Pivot

 |  | 1product
operator | Data | blue | red | yellow | Grand Total
[NAME] | quote (not converted) | 5 |  | 2 | 7
 | sale (converted) | 1 | 2 | 1 | 4
 | total customers | 6 | 2 | 3 | 11
 | payment | 100 | 50 | 50 | 200 |  | PIVOT DATA COMES FROM AN EXTERNAL SOURCE
Jake | quote (not converted) | 2 | 3 | 4 | 9 |  |  |  | VIA AN ODBC DRIVER
 | sale (converted) | 4 | 3 |  | 7
 | total customers | 6 | 6 |  | 12
 | payment | 400 | 75 |  | 475
[NAME] | quote (not converted) | 6 | 3 | 2 | 11
 | sale (converted) | 1 | 1 | 4 | 6
 | total customers |  | 4 |  | 4
 | payment | 100 | 25 | 200 | 325
Total quote (not converted) |  | 13 | 6 | 8 | 27
Total sale (converted) |  | 6 | 6 | 5 | 17
Total total customers |  | 12 | 12 | 3 | 27
Total payment |  | 600 | 150 | 250 | 1000
Spreadsheet: 829876d1684506652-search-after-2-criteria-test123
Sheet: Tabelle1

Name | Subname | Supplier Part Number | Short Description | Time (Days) | Price Information | Net Price
Hans | Mele-Mobil GöMz GBR | 2.1.28 |  | 56 | 1 | 504
Hans | Mele-Mobil GöMz GBR | 2.1.28NameEXTRAS |  | 56 | 1 | 500
Hans | DomDross GBR & Do [NAME] (SDF) | 2.1.28NameExtras20 |  | 21 | 1 | 501
Hans | DMeam | 2.1.28NameExtras21 |  | 56 | 1 | 502
Hans | EQOS KommunikaMion GBR | 2.1.28NameExtras22 |  | 56 | 1 | 406.64
Hans | NPS NeMzwerk ProjekM [NAME] | 2.1.28NameExtras23 |  | 56 | 1 | 505
Hans | RND SoluMions GBR | 2.1.28NameExtras24 |  | 56 | 1 | 3900
Hans | [NAME] | 2.1.28NameExtras25 |  | 56 | 1 | 523.5
Hans | Volker Wessels MeleDom | 2.1.28NameExtras26 |  | 56 | 1 | 1799.5
Hans | [NAME] GBR | 2.1.28NameExtras27 |  | 21 | 1 | 734.17
Spreadsheet: 2b803099-85cd-4336-b198-1bfad7ad7cdd
Sheet: Raffle Recon Worksheet

 | Raffle Ticket Reconciliation Worksheet
 | Reconciled by:
 | Date:
 | Legend:
 | [NAME] your data in these cells
 | Formula Driven Cells - Formula will automatically calculate
 | Reconcile Tickets & Calculate Proceeds
 | Beginning Raffle Ticket Number
 | Next Raffle Ticket Number on Hand
 | Total Number of Tickets sold
 | Sales Price Per Ticket
 | Total Amount of Raffle Ticket Proceeds
 | Total Amount of Raffle Ticket Proceeds in Cash
 | Change Fund ( to make change for raffle ticket sales) | 0
 | Total Amount of Cash on Hand
 | (Less Change Fund)
 | Total Cash
 | Overage/(Shortage)
Spreadsheet: b0856050-d9fc-4459-8562-0ac3fd67b818
Sheet: Sheet1

Comparison of occult tumor characteristics in BRCA1 women versus all high-risk women. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | BRCA1 only | All High-Risk
Duration of preclinical period *a
Total (years) | 5.1 (3.2-8.1) | 5.4 (3.6-8.1)
Early Stage (years) | 4.3 (2.6-6.9) | 4.3 (2.8-6.6)
Advanced Stage (years) | 0.8 (0.4-1.9) | 1.1 (0.5-2.0)
Size distribution of (non-advanced) occult tumours *b
Tumor Diameter ([NAME]) | 3.0 (2.5-4.4) | 3.0 (2.5-4.0)
Location of occult tumors *b
[NAME] (FT) | 22 (59%) | 34 (65%)
Ovaries | 9 (24%) | 9 (17%)
FT + Ovaries | 4 (11%) | 6 (12%)
Peritoneal | 2 (5%) | 3 (6%)
TOTAL | 37 | 52
a =Median (95% CI)
b =Number (% of total)
Spreadsheet: 35463d1233072087-excel-2007-using-vlookup-to-find-multiple-values-within-a-stdev-sing-vlookup-to-find-multiple-values-within-a-stdev_1
Sheet: Sheet1

6 | Value: | 50
28 |  |  | 22 | 54
51 |  |  | 1 | 49
40 |  |  | 10 | 47
75 |  |  | 25 | 47
54 |  |  | 4
67 |  |  | 17
64 |  |  | 14
92 |  |  | 42
38 |  |  | 12
99 |  |  | 49
16 |  |  | 34
74 |  |  | 24
49 |  |  | 1
62 |  |  | 12
86 |  |  | 36
47 |  |  | 3
8 |  |  | 42
18 |  |  | 32
47 |  |  | 3
http://www.excelforum.com/excel-2007-help/669701-using-vlookup-to-find-multiple-values-within-a-stdev.html
Spreadsheet: 739861d1626014002-correction-needed-for-outbound-quantity-example_avg_cost-warehouse-approach-v3-
Sheet: Version5

Limits:
Trade Symbol | Transaction | Date | Sale Portion | [NAME] | Quantity | Price | Fees | Total Cost | Needed for correct cumulative average cost value |  | Cumulative Units | Cumulative Average Cost | Current Balance (FIFO) | Sales Only -  Separated for RAW data |  | Gain (Loss) P & L | Notes
 | Purchase | 2021-02-22 00:00:00 |  |  | 3.514923 | 14.21 | 0
 | Purchase |  |  |  | 1.95554 | 12.8 | 0
 | Purchase | 2021-02-23 00:00:00 |  |  | 2.121327 | 11.78 | 0
 | Purchase | 2021-03-24 00:00:00 |  |  | 374.242645 | 13.45 | 0
 | Sale | 2021-03-29 00:00:00 | All | Short | -381.834442 | 13.34 | 0
 | Purchase | 2021-04-17 00:00:00 |  |  | 13.380624 | 37.72 | 0
 | Purchase |  |  |  | 12.706329 | 39.39 | 0
 | Purchase | 2021-04-27 00:00:00 |  |  | 28.600846 | 35.18 | 0
 | Purchase | 2021-05-04 00:00:00 |  |  | 74.626678 | 67.52 | 0
 | Purchase |  |  |  | 270.208195 | 74.56 | 0
 | Sale | 2021-05-04 00:00:00 | All | Short | -399.522672 | 78.52 | 0
 | Purchase | 2021-05-04 00:00:00 |  |  | 179.734944 | 84.04 | 0
 | Purchase | 2021-05-05 00:00:00 |  |  | 49.622456 | 101.4 | 0
 | Purchase |  |  |  | 246.20782 | 102.55 | 0
 | Purchase |  |  |  | 165.37101 | 103.4 | 0
 | Sale | 2021-05-05 00:00:00 | All | Short | -640.93623 | 104.18 | 0
 | Purchase | 2021-05-05 00:00:00 |  |  | 30.301633 | 99.03 | 0
 | Purchase | 2021-05-06 00:00:00 |  |  | 276.819944 | 145.41 | 0
 | Sale | 2021-05-06 00:00:00 | All | Short | -307.121577 | 168.49 | 0
 | Purchase | 2021-05-06 00:00:00 |  |  | 277.1079 | 182.23 | 0
 | Purchase |  |  |  | 138.149505 | 182.77 | 0
 | Sale | 2021-05-08 00:00:00 | Partial | Short | -107.381606 | 127.43 | 0 |  |  |  |  |  |  |  |  |  | Should be a negative number … here is where things get complicated…
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | How do we get Q26 to show a value that represents a portion of the loss based on the fact that this partial sale was done to minimize some of the losses when the price dropped $55 per share? That value should equate to somewhere around $5000.00
Totals:
Spreadsheet: 95756d1295336237-combination-of-assessment-for-a-final-score-combination
Sheet: Combination

Subject | Weightage | Assessment Scale
A | 0.3 | 0 | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 1
B | 0.25 | 0 | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 1
C | 0.2 | 0 | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 1
D | 0.15 | 0 | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 1
E | 0.1 | 0 | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 1
Total
 | Rating Combination
Final Score | A | B | C | D | E | Check
1 | 1 | 1 | 1 | 1 | 1
0.99 | 1 | 1 | 1 | 1 | 0.9
0.98 | 1 | 1 | 1 | 1 | 0.8
0.98 | 1 | 1 | 0.9 | 1 | 1
0.97 | 1 | 1 | 1 | 1 | 0.7
0.97 | 0.9 | 1 | 1 | 1 | 1
0.97 | 1 | 1 | 1 | 0.8 | 1
Spreadsheet: 719326d1613622991-formula-to-find-if-a-set-of-values-in-excel-column-is-out-of-range-test
Sheet: Final

T | H | FILL | VOLM m3 | [NAME] | L.C.V m | T.C.V za | V,C.V in | IMOH m4 | FBM tm
0 | 0 | 0 | 0 | 0 | 152.125 | -2705 | 0.001 | 463.3 | 0
0.2 | 0.2 | 8.8 | 35.63 | 35.09 | 152.714 | -3.411 | 0.105 | 1135.9 | 1164.3
0.4 | 0.4 | 19.4 | 78.35 | 77.18 | 152.962 | -3.72 | 0.212 | 1485.3 | 1522.4
6000 | 0.6 | 30.7 | 124.05 | 122,19 | 153.054 | -3.912 | 0.319 | 1662.7 | 1704.3
8000 | 0.8 | 42.3 | 171 | 168.44 | 153.103 | -4.036 | 0.423 | 1762 | 1806
9000 | 1 | 54 | 218.51 | 215.23 | 153.133 | -4.12 | 0.527 | 1807.6 | 1852.8
1.2 | 1.2 | 65.8 | 266.19 | 262.2 | 153.152 | -4178 | 0.63 | 1820.5 | 1865
1.4 | 1.4 | 77,6 | 313.9 | 309.19 | 153.166 | -4.218 | 0.732 | 1820.5 | 1866
1.6 | 1,60 | 89.4 | 361.61 | 356,19 | 153.176 | -4.249 | 0.833 | 1820.5 | 1866
1,78 | 1,78 | 100 | 404.55 | 358,49 | 153.164 | -4.27 | 0.924 | 1820.5 | 0
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 26 March 2012

Daily Morning Staff |  |  |  |  | Monday
 | 07:30-14:30 |  | 2012-03-26 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Relation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS | Annual leave
[NAME] | 4143 | Aircraft Team Leader | 07:30:00 | 14:30:00 | EFS
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS | Com off Air Show
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME] | Annual leave
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS | Sick leave
[NAME] | 4440 | Attendant | 07:30:00 | 14:30:00 | EFS | Annual leave
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: 118311d1313600010-index-match-or-lookup-example
Sheet: Developed Claim Frequency

Claim Frequency Triangulated
Class | All
 |  | Development Year
 | Treaty Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
 | 1993
 | 1994
 | 1995
 | 1996
 | 1997
 | 1998
 | 1999
 | 2000
 | 2001
 | 2002
 | 2003
 | 2004
 | 2005
 | 2006
 | 2007
 | 2008
 | 2009
 | 2010
Class | EL
 |  | Development Year
 | Treaty Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
 | 1993
 | 1994
 | 1995
 | 1996
 | 1997
 | 1998
 | 1999
 | 2000
 | 2001
 | 2002
 | 2003
 | 2004
 | 2005
 | 2006
 | 2007
 | 2008
 | 2009
 | 2010
Spreadsheet: 738030d1624774933-formula-to-pull-only-the-differences-between-sheets-occ-geo-template-sample
Sheet: (C) ExistingGEO

Employee Number | First Name | Last Name | Hire Date | Primary Location | IsPrimary | GEO
102395 | [NAME] | [NAME] | 28399 | [NAME] | True | 57
102453 | PAUL R | [NAME] | 28906 | Bountiful - 12001 - AK C/P Engine Room | True | 20
500079 | NILO | OHMER | 29007 | [NAME] | True | 73
500859 | DAVE N | [NAME] | 30093 | [NAME] - AK Shore Salaries - Plant | True | 20
501058 | [NAME] | GRAY | 30468 | Dutch Harbor  OSI Fac - 53030 - Dutch Harbor Labor | True | 21
501287 | [NAME] | PELKEY | 30509 | Ketchikan Plant - 10101 - AK Shore Production | True | 73
501461 | WAYNE | JONES | 30795 | Dutch Harbor - 302 - LFS AK Sales | True | 14
501532 | TAI Y | CHO | 30972 | [NAME] - AK Shore Salaries - Plant | True | 95