tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 269584d1381221965-formula-to-return-values-from-all-rows-book14
Sheet: Summary (2)

Attributes
 |  |  |  |  |  |  |  |  |  |  |  | 12
Comparable Size
 | Ref | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
Store
Peer 1 | 12 | 4307 | 114075 | 102966 | 113295 | 111991 | 115612 | 112052 | 123056 | 116430
Peer 2 | 12 | 4960 | 255236 | 231143 | 252127 | 240393 | 235592 | 230471 | 245649 | 233394
Peer 3 | 12 | 4664 | 308778 | 272424 | 295205 | 271835 | 287938 | 287881 | 315255 | 310008
Peer 4
Peer 5
Peer 6
Peer 7
Peer 8
Peer 9
Peer 10
Peer 11
Peer 12
Spreadsheet: 108963d1305890524-use-excel-to-update-stock-levels-for-my-products-bruder-stock-update-test
Sheet: Sheet1

B10/1081 | CLAAS ATLES 935RZ TRACTOR W/CLAAS DISC MOWER | 2
B10/2001 | WHEELS FOR 2000 SERIES TRACTOR | 4
B10/2005 | FRONTLOADER FOR 2000 TRACTOR | 4
B10/20060 | ROADMAX SKID STEER LOADER | 4
B10/2010 | Tandem axle tipping trailer | 4
B10/20102 | [NAME] | 1
B10/20105 | Roadmax road loader w/ backhoe | 2
B10/20115 | ROADMAX TRACTOR W/TIPPING TRAILER | 0
B10/2017 | JOHN DEERE BIG BALEPRESS | 2
B10/2019 | TIPPING TRAILER | 3
B10/2026 | LEMKEN SOLITAIR SOWER | 1
B10/2028 | HORSE TRAILER W/HORSE | 3
B10/2029 | CATTLE TRAILER W/COW | 1
B10/2031 | CONVEYOR BELT | 2
Spreadsheet: 133615d1324500142-referencing-cells-in-other-worksheets-example
Sheet: WS2

Data | 1 | 2 | 3 | 4 | 5
1 | 100 | 100 | 100 | 100 | 100
 | 1000 | 1000 | 1000 | 1000 | 1000
 | 10000 | 10000 | 10000 | 10000 | 10000
2 | 102 | 102 | 102 | 102 | 102
 | 1020 | 1020 | 1020 | 1020 | 1020
 | 10200 | 10200 | 10200 | 10200 | 10200
3 | 104 | 104 | 104 | 104 | 104
 | 1040 | 1040 | 1040 | 1040 | 1040
 | 10400 | 10400 | 10400 | 10400 | 10400
Spreadsheet: 881696d1729842489-need-help-on-sum-function-sample1
Sheet: Sheet1

manufacturing rate
Selling price
selling price
30
40
Store price | Manufacturing price | selling price
10 | 5 | 15
20 | 6 | 26
30 | 7 | 37
40 | 8 | 48
50 | 10 | 60
60 | 20 | 80
70 | 30 | 100
80 | 50 | 130
90 | 9 | 99
100 | 20 | 120
110 | 10 | 100
Spreadsheet: 145600d1331660013-vlookup-vlookup2
Sheet: Sheet2

 |  | EBITDA
 |  | Current
 |  | TOT_PHYS
 |  | FY12
 |  | Actual
 |  | YearTotal
0001 | MP28 | 86.06 |  | #N/A
0002 | MP28 | -587.6099999999994
0003 | MP28 | 348.46
0004 | MP28 | 1358.07
0005 | MP28 | 252.09
0006 | MP28 | 3826.93
0009 | MP28 | 5612.91
0011 | MP9 | -1614.34
0012 | MP9 | 3145.98
Spreadsheet: 792725d1661103933-transposing-data-test
Sheet: Sheet1

110 | 6
732 | 300
516 | 642
171 | 910
198 | 598 |  | 642
26 | 941 |  | 516
821 | 286 |  | etc…
374 | 417
971 | 510
575 | 347
394 | 607
746 | 857
316 | 718
762 | 101
371 | 568
930 | 939
208 | 787
234 | 261
715 | 913
981 | 99
398 | 410
16 | 4
267 | 508
231 | 957
7 | 381
1 | 206
444 | 360
338 | 246
464 | 996
614 | 857
950 | 961
Spreadsheet: 0382bd32-c1f1-4ae3-b2aa-76305ebc391d
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
 | 5625.0 Private New Capital Expenditure and Expected Expenditure, Australia
 | TABLE 11A. Actual and Expected Capital Expenditure by Asset - Tasmania:Current Prices $m
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Actual Expenditure ;  Tasmania ;  Total (Industry) ;  [NAME] and [NAME] ;  Current Price ; |  |  | Original | A3516142C | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Actual Expenditure ;  Tasmania ;  Total (Industry) ;  Equipment, Plant and Machinery ;  Current Price ; |  |  | Original | A3516184A | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Actual Expenditure ;  Tasmania ;  Total (Industry) ;  Total (Type of Asset - Detailed Level) ;  Current Price ; |  |  | Original | A3511774K | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Long Term Expected Expenditure ;  Tasmania ;  Total (Industry) ;  [NAME] and [NAME] ;  Current Price ; |  |  | Original | A3516144J | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Long Term Expected Expenditure ;  Tasmania ;  Total (Industry) ;  Equipment, Plant and Machinery ;  Current Price ; |  |  | Original | A3516186F | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Long Term Expected Expenditure ;  Tasmania ;  Total (Industry) ;  Total (Type of Asset - Detailed Level) ;  Current Price ; |  |  | Original | A3511776R | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Short Term Expected Expenditure ;  Tasmania ;  Total (Industry) ;  [NAME] and [NAME] ;  Current Price ; |  |  | Original | A3516143F | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Short Term Expected Expenditure ;  Tasmania ;  Total (Industry) ;  Equipment, Plant and Machinery ;  Current Price ; |  |  | Original | A3516185C | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
Short Term Expected Expenditure ;  Tasmania ;  Total (Industry) ;  Total (Type of Asset - Detailed Level) ;  Current Price ; |  |  | Original | A3511775L | 1989-06-01 00:00:00 | 2012-06-01 00:00:00 | 93 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: 833015d1686733045-transform-discreet-data-set-into-multiple-columns-test-file
Sheet: Sheet1

1 | 1 | 3 | 6 | 9 | 10 | 13
2 | 2 | 4 | 7 |  | 11 | 14
0 |  | 5 | 8 |  | 12 | 15
3 |  |  |  |  |  | 16
4 |  |  |  |  |  | 17
5 |  |  |  |  |  | 18
0
0
6
7
8
0
9
0
0
0 |  |  |  |  |  | imported data that needs manipulation
10 |  |  |  |  |  | expected output
11
12
0
0
0
0
13
14
15
16
17
18
Spreadsheet: 374bbd9c-77e0-433b-b0ae-2a8f9a7c44e1
Sheet: 13a

Product1 | Cleared2 | Uncleared | TOTAL
Index Tranche | - | 958832 | 958832
Europe | - | 459124 | 459124
North America/Asia | - | 499708 | 499708
Other | - | - | -
Index | 2032736 | 5141861 | 7174597
Asia | - | 108648 | 108648
Europe | 864868 | 2402888 | 3267756
North America | 1149998 | 2381618 | 3531616
Other | 17870 | 248707 | 266577
Other | - | 446911 | 446911
Exotic | - | 54553 | 54553
Swaptions | - | 392133 | 392133
Total Return Swap | - | 225 | 225
TOTAL | 2032736 | 6547604 | 8580340
Spreadsheet: 687677d1595346334-sumproduct-formula-help-to-total-numbers-per-month-dashboardhelp
Sheet: Analysis

 |  | Select Month |  | Jul |  | Running Total
 |  | Buddy Requests |  |  |  | Awaiting Pairing
 |  | Buddy Paired |  |  |  | Contact Made
Done | 1 | Select month to be a drop down
Think done | 2 | Buddy requests, the number of requests per month from tab 2 column A
 | 3 | Buddy paired, the number of pairs per month that have buddied up to a requestor (second 2 tab column D)
Done | 4 | Running total, the total number of requests in tab 2
 | 5 | Awaiting pairing, the number of blanks per month in tab 2 column D
 | 6 | Contact Made, the number of Yes in tab 2 column F per month
Spreadsheet: 83716d1283762553-split-text-use-in-vlookup-and-concatenate-results-book1
Sheet: Data

 | Data ID | Data description
 | Data 1 | Desc 1
 | Data 2 | Desc 2
 | Data 3 | Desc 3
 | Data 4 | Desc 4
 | Data 5 | Desc 5
 | Data 6 | Desc 6
 | Data 7 | Desc 7
 | Data 8 | Desc 8
 | Data 9 | Desc 9
 | Data 10 | Desc 10
 | Data 11 | Desc 11
 | Data 12 | Desc 12
 | Data 13 | Desc 13
 | Data 14 | Desc 14
Spreadsheet: 679397d1590399195-count-index-match-double-criteria-book2
Sheet: Resume

Month: | Week | DK-Fleet | NTC-Fleet | VAN-Fleet |  | DK FLEET: |  | January | February | March | April | May | June | July | August | September | October | November | December |  | Total: |  |  | DK
 |  |  |  |  |  |  | Total Fleet Additions | 121 | 300 | 183 | 46 | 92 | 150 | 500 | 0 | 220 | 50 | 0 | 300 |  |  |  |  | NTC
January | Week 1 |  |  |  |  |  | Sourced |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VAN
 | Week 2 |  |  |  |  |  | Unsourced
 | Week 3
 | Week 4 |  |  |  |  | NTC FLEET: |  | January | February | March | April | May | June | July | August | September | Octboer | November | December
 | Week 5 |  |  |  |  |  | Total Fleet Additions | 0 | 147 | 158 | 0 | 0 | 0 | 100 | 100 | 0 | 0 | 100 | 300
February | Week 5 |  |  |  |  |  | Sourced
 | Week 6 |  |  |  |  |  | Unsourced
 | Week 7
 | Week 8 |  |  |  |  | [NAME]: |  | January | February | March | April | May | June | July | August | September | Octboer | November | December
 | Week 9 |  |  |  |  |  | Total Fleet Additions | 20 | 49 | 29 | 0 | 17 | 25 | 39 | 0 | 0 | 0 | 0 | 0
March | Week 9 |  |  |  |  |  | Sourced
 | Week 10 |  |  |  |  |  | Unsourced
 | Week 11
 | Week 12
 | Week 13
 | Week 14
April | Week 14
 | Week 15
 | Week 16
 | Week 17
 | Week 18
May | Week 18
 | Week 19
 | Week 20
 | Week 21
 | Week 22
June | Week 23
 | Week 24
 | Week 25
 | Week 26
 | Week 27
July | Week 27
 | Week 28
 | Week 29
 | Week 30
 | Week 31
August | Week 31
 | Week 32
 | Week 33
 | Week 34
 | Week 35
 | Week 36
September | Week 36
 | Week 37
 | Week 38
 | Week 39
 | Week 40
October | Week 40
 | Week 41
 | Week 42
 | Week 43
 | Week 44
November | Week 44
 | Week 45
 | Week 46
 | Week 47
 | Week 48
 | Week 49
December | Week 49
 | Week 50
 | Week 51
 | Week 52
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: R49

Ime artikla
Spreadsheet: 163589d1340374311-how-to-change-title-in-dynamic-chart-840254
Sheet: data

Titel is showing product code but I want it to show product code and description
 | Product Code | Description | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
1 | 1043182 | [NAME] | 10 | 3 | 24 | 30 | 45 | 23 | 37 | 34 | 12 | 24 | 56 | 30
2 | 1043183 | Apple | 24 | 49 | 9 | 0 | 7 | 6 | 4 | 8 | 88 | 95 | 8 | 89
3 | 1043184 | [NAME] | 14 | 27 | 11 | 23 | 56 | 4 | 8 | 34 | 887 | 23 | 29 | 7
Spreadsheet: 140128d1328629493-cumulative-sum-formula-book1_africa
Sheet: Sheet1

Number of transactions |  | Running Sum |  |  | Check Running Sum |  |  | Lookup Table
52 | 300 | 300 |  |  | 52 |  |  | 0 | 300
71 | 275 | 575 |  |  | 123 |  |  | 100 | 275
34 | 275 | 850 |  |  | 157 |  |  | 200 | 250
87 | 250 | 1100 |  |  | 244
96 | 250 | 1350 |  |  | 340
Spreadsheet: 37f96b2e-d831-49c3-a9be-ab2698d3f6cb
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
HL15O | Test | HL15O | HLA-B 1502 Genotype, Carbamazepine Hypersensitivity, Saliva | HLAB 1502 Genotype, Saliva | Allele-Specific Polymerase Chain Reaction (PCR) Amplification (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | [NAME] DNA Self-Collection Kit (Supply T651) |  |  | 4 | mL | Multiple saliva genotype tests can be performed on a single specimen after a single extraction. See Multiple Saliva Genotype Tests in Special Instructions for a list of tests that can be ordered together.  Container/Tube: [NAME] DNA Self-Collection Kit (Supply T651)  [NAME]: Full tube  Collection Instructions: 1. Fill tube to line. 2. Send specimen in original container per kit instructions. Forms: New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Tuesday, Friday | 1 day | 5 days | 1 | 81381 |  |  |  |  | Rochester
HL15O | [NAME] | SALIVA | Saliva |  |  |  | Ambient
HL15O | Result | 33052 | HLA-B 1502 Result | HLA-B 1502 Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
HL15O | Result | 33053 | HLA-B 1502 Reviewed by | HLA-B 1502 Reviewed by | Numeric
HL15O | Result | 33054 | HLA-B 1502 Interpretation | HLA-B 1502 Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9 | Service comment 01:Imp:Pt:[NAME]:Nom:
Spreadsheet: 213454d1360528312-return-a-1st-2nd-or-3rd-from-row-of-numbers-golf
Sheet: Sheet1

Score | Name
70 | [NAME]
80 | [NAME] |  |  |  | Place | Score | Name
100 | [NAME] |  |  |  | 1 |  |  |  |  | [NAME]
60 | Nick |  |  |  | 2
50 | [NAME] |  |  |  | 3
Spreadsheet: 798924d1664814835-extract-data-from-an-array-excel-sample
Sheet: Sheet1

 | Data Source: |  |  |  | Output:
 | Item | kW rating | Number |  | Item | kW rating | Number
 | Heating | 5 | 2 |  | Lighting | 0.05 | 10
 | Cooling | 50 | 1 |  | Lighting | 0.15 | 15
 | Cooling | 21 | 3 |  | Lighting | 0.06 | 10
 | Lighting | 0.05 | 10
 | Heating | 1.5 | 25
 | Other | 25 | 2
 | Lighting | 0.15 | 15
 | Heating | 20 | 5
 | Lighting | 0.06 | 10
 | Other | 54 | 1
Spreadsheet: 827273d1682586805-formula-that-add-score-to-the-existing-one-according-to-one-or-more-variables-formula-that-add-score-to-the-existing-one-based-on-one-ore-more-variables-2-aligw
Sheet: Sheet1

 |  |  | Country to select | Score |  | Special country list | Number to add to the tot score (E11 if one or all of these 3 countries are selected |  |  |  | Conditions
 |  |  | Norway | 3 |  | Spain | 20
 |  |  | Germany | 2 |  | Germany |  |  |  |  | If I select Spain from the special country list, the total in E11 must to be increased by 20
 |  |  | Italy | 4 |  | France |  |  |  |  | If I select Germany from the special country list, the total in E11 must to be increased by 20
 |  |  | UK | 1 |  |  |  |  |  |  | If I select France from the special country list, the total in E11 must to be increased by 20
 |  |  |  |  |  |  |  |  |  |  | If I select Spain and Germany from the special country list, the total in E11 must to be increased by 20
 |  |  | TOT |  |  |  |  |  |  |  | If I select Spain and France from the special country list, the total in E11 must to be increased by 20
 |  |  |  |  |  |  |  |  |  |  | If I select Germany and France from the special country list, the total in E11 must to be increased by 20
 |  |  |  |  |  |  |  |  |  |  | If I select Germany and Spain from the special country list, the total in E11 must to be increased by 20
 |  |  | If the country selected is Spain, Germany or France, the score at E11 should be added by 20. (e.g. if insteady of Norway I put Spain, the total score should be 27 (20+the current score of Germany Italy and UK) OTHERWISE the sum remain as it is (10) |  |  |  |  |  |  |  | If I select Germany AND Spain AND France from the special country list, the total in E11 must to be increased by 20
Spreadsheet: 133500d1324424418-excel-2007-menu-greyed-out-productdb
Sheet: 01 Flood Lights

EAD SKU # | Input Voltage | Power, Watts | [NAME] | Color Temp    WW,DW,WW | Beam Angle. Degrees | Items/cs | Weight, kg/Case | Cost Price, $ | Sell Price, Case | Image | Source
EA0901 | 100 - 240 AC | 20 | 1600-1900 | 2700 -7000 | 120 | 6 | 9 | 40 |  |  | 1
EA0902 | 100 - 240 AC | 50 | 4000-4500 | 2700 -7000 | 60-120 | 6 | 17 | 82 |  |  | 1
EA0903 | 100 - 240 AC | 70 | 5600-6300 | 2700 -7000 | 60-120 | 3 | 21 | 158 |  |  | 1
EA0904 | 100 - 240 AC | 90 | 7500-8100 | 2700 -7000 | 60-120 | 2 | 21 | 220 |  |  | 1
EA0905 | 100 - 295 AC | 120 | 9600-10500 | 2700 -7000 | 120 | 1 | 13 | 282 |  |  | 1
EA0906 | 100 - 295 AC | 80 | 6500-7000 | 2700 -7000 | 60 | 2 | 24 | 206 |  |  | 1
EA0907 | 100 - 295 AC | 200 | 15500-17500 | 2700 -7000 | 60-120 | 1 | 25 | 378 |  |  | 1
EA0908 | 100 - 240 AC | 10 | 700-800 | 2700 -7000 | 120 | 6 | 9 | 23 |  |  | 1
Spreadsheet: 135284d1325894777-match-values-in-2-columns-and-return-the-sum-im-data
Sheet: Productivity Table

 |  | YTD | [NAME] | SI Clarity Projects |  | EU Projects | VE Projects | Co-Leading & Scoping
CIS Billing & Clarity | Customer Satisfaction & Niku | FY12 TEAM TARGET  (All counted from From 1/10/11) | > 88.5% | SI Clarity Projects | >25 New Complex Projects | > 7 % Effort to be Noted | > 7 % Effort to be Noted | Ongoing | FY12
adam b | b, adam | adam b | #N/A | #N/A | #N/A | 2 | 0
 |  | Effort % |  |  |  |  |  |  | 8.5
[NAME] | s, [NAME] | [NAME] | #N/A | #N/A | #N/A | 2 | 2
 |  | Effort % |  |  |  |  |  |  | 2
[NAME] | M, [NAME] | [NAME] | #N/A | #N/A | #N/A | 1 | 2
 |  | Effort % |  |  |  |  |  |  | 0
Spreadsheet: 33083d1229366907-how-do-you-trigger-calculations-random
Sheet: Sheet3

0.5875268910298077 | 0.7984823483388386 | 0.01213051437986534 | 0.4619925362028159 | 0.7953549208150807 | 0.962208205576983 | 0.9142544216368793 | 0.02520029898617526 | 0.7634185896641816 | 0.7728144215021064
0.3313819814734775 | 0.6070142844126005 | 0.4449770970468201 | 0.1490130076800815 | 0.08188879445765451 | 0.816521754416482 | 0.03012133258341088 | 0.04078268646353544 | 0.8749275417779243 | 0.033397821875222
0.5386006085224546 | 0.2498725823778729 | 0.4798271427799572 | 0.8131290154897615 | 0.5873773727497182 | 0.2830672057452071 | 0.7514710736338521 | 0.8240823422316161 | 0.6257670234589252 | 0.6059136879367175
0.6544579920042877 | 0.8105478182174917 | 0.4497767092596705 | 0.7413986647696582 | 0.2277582268838652 | 0.9517689650304242 | 0.2748406585892118 | 0.4733330646330187 | 0.04183674847072893 | 0.559374025892815
0.4710346173083897 | 0.1012253784930257 | 0.6138712550019054 | 0.6464885381596703 | 0.4101636640491133 | 0.8729359639793266 | 0.5037947911190332 | 0.5911448207685415 | 0.8675953170093047 | 0.3041807738731643
0.6268937147685243 | 0.205582907806285 | 0.3741437653471849 | 0.8837388502880277 | 0.5983095803116205 | 0.3253110427833636 | 0.8908046675674242 | 0.705119156498927 | 0.05471730927944973 | 0.6952306268288293
0.5772245284826427 | 0.5034441989897234 | 0.03016995089304064 | 0.7234575298333068 | 0.2792160736413447 | 0.9508678060037878 | 0.5050556538838156 | 0.07059479828333304 | 0.4926392056186206 | 0.7655532886278342
0.9367782039645807 | 0.9281622823283509 | 0.5855081438408742 | 0.8788157530481371 | 0.7121699329267397 | 0.9644598983504693 | 0.5419903566858255 | 0.8912823516696309 | 0.09732306501623533 | 0.9416081077579446
0.03050043800582358 | 0.5404010943262858 | 0.741057089720387 | 0.4335763686139613 | 0.722966156523748 | 0.244198893570414 | 0.3799396055993918 | 0.5158196872247922 | 0.902321142399205 | 0.2265873284286695
0.8006202435812151 | 0.6331282482327136 | 0.04149991933766906 | 0.02312499814827529 | 0.3925667565706381 | 0.5499853550705545 | 0.5336500794390633 | 0.6329945279761713 | 0.0579490643655447 | 0.6652373800984313
0.6176170501038891 | 0.1846361852104332 | 0.1723653727617588 | 0.5886050654695332 | 0.5513243393197522 | 0.9045771850378546 | 0.3699668912227105 | 0.7688034121670304 | 0.7744394799405976 | 0.8958495663273958
Spreadsheet: 711382d1609667459-same-formula-two-different-cells-two-different-results-schedule-test
Sheet: Employees

 | Employee Name | Start Date | Term Date | Op# | Shift | Job
 | Alf | 2020-08-24 00:00:00 |  | 144 | [NAME] | Day Tech 1
 | [NAME] | 2017-11-22 00:00:00 |  | 124 | Swing | Swing Lead
 | [NAME] | 2010-07-05 00:00:00 |  | 106 | Day | Day Operator 1
 | [NAME] | 2020-10-01 00:00:00 |  | 145 | Swing | Swing Operator 3
 | [NAME] | 2020-08-24 00:00:00 |  | 143 | Swing | Swing Operator 2
 | Delores | 2015-07-28 00:00:00 |  | 133 | Grave | Grave Operator 1
 | Dennis | 2013-03-18 00:00:00 |  | 115 | Day | Day Supervisor
 | Kriss | 2016-11-22 00:00:00 |  | 139 | Grave | Grave Operator 2
 | Regina | 2006-03-27 00:00:00 |  | 86 | Swing | Swing Manager
 | Rita | 2018-10-11 00:00:00 |  | 95 | Swing | Swing Operator 1
 | [NAME] | 2005-04-12 00:00:00 |  | 121 | [NAME] | Day Tech Lead
 | Russ | 2018-01-03 00:00:00 |  | 126 | Grave | Grave Lead
 | Sonia | 2019-09-09 00:00:00 |  | 142 | Day | Day Operator 2
 | [NAME] | 005/15/18 |  | 135 | Grave | Grave Operator 3
 | TBA |  |  | N/A | [NAME] | Day Tech 2
 | [NAME] | 2016-04-05 00:00:00 |  | 91 | Grave | Grave Supervisor
 | [NAME] | 2016-04-11 00:00:00 |  | 117 | Day | Day Lead
Spreadsheet: 111636d1307985658-retrieve-data-from-other-sheets-using-dropdown-list-sample1
Sheet: Offer2

Actual #s | [NAME] | #1 offer | #2 offer
Sent | 4084 | 9788 | 14290
Open | 856 | 1802 | 2181
Clicks | 226 | 428 | 418
Orders | 0 | 3 | 8
Unsubscribe | 27 | 50 | 72
Spreadsheet: 22a05723-7e9d-4881-a78e-441f104c8015
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
FLIS | Test | FLIS | [NAME], CF (CSF) | [NAME], CSF | Complement Fixation (CF) | Plastic vial: PlV |  |  | 1 | mL | Submit 1 mL of spinal fluid (CSF). Refrigerate specimen after collection. | 0.5 mL | Specimens other than	CSF Anticoagulants other than	NA Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icteric	NA | Reference Range:  <1:1   Interpretive Criteria;           <1:1   Antibody Not Detected > or = 1:1 Antibody Detected   Diagnosis of infections of the central nervous system is accomplished by demonstrating the presence of intrathecally-produced specific antibody. Interpretation of results may be complicated by low antibody levels found in CSF, passive transfer of antibody from blood, and contaminaton via bloody taps. The interpretation of CSF results must consider CSF-serum antibody ratios to the infectious agent.   Test Performed by:  Focus Diagnostics, Inc.                                        5785 Corporate Avenue                                        Cypress, CA 90630-4750 | Monday through Friday | 2-5 days | 3-7 days | 1 | 86609 |  |  |  |  | Focus Diagnositics, Inc.
FLIS | [NAME] | CSF | CSF |  |  |  | Refrigerated | 14 days
FLIS | Result | Z0633 | [NAME], CF, CSF | [NAME], CF, CSF | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 856191d1705529404-trying-to-apply-a-function-to-a-dynamic-range-aroperhelp
Sheet: Sheet1

 |  |  |  |  | Last Sold Year | Current Year | Average Index from Last Sold Year to Current Year
 |  |  |  |  | 2018 | 2024
 |  |  |  |  | 2017 | 0.02295000000000002
 |  |  |  |  | 2018 | 0.0328
 |  |  |  |  | 2019 | 0.03322499999999998
 |  |  |  |  | 2020 | 0.04990000000000002
 |  |  |  |  | 2021 | 0.1469499999999999
 |  |  |  |  | 2022 | 0.1563250000000001
 |  |  |  |  | 2023 | 0.10595
 |  |  |  |  | 2024 | 0.1
Spreadsheet: 57001d1257183109-pivot-count-query-example-a-and-b-
Sheet: Copy of Master Sheet

Name | A or B | Hours
Giff | A | 2
Giff | A | 2
[NAME] | B | 2
[NAME] | B | 2
[NAME] | A | 2
[NAME] | A | 2
[NAME] | B | 2
[NAME] | B | 2
[NAME] | B | 2
[NAME] | A | 2
[NAME] | A | 2
Clem | A | 2
[NAME] | A | 2
Glock | A | 1
[NAME] | A | 1
Chock | A | 2
[NAME] | A | 1
TOTAL
11 |  | 21
Spreadsheet: 53592d1253547070-transferring-data-from-many-sheets-to-a-single-sheet-bank-sample
Sheet: Sheet2

DAILY BANK REPORT |  |  |  |  |  | 2009-06-30 00:00:00 | 39994 | >39994
A/c Details | Clear Balance As On | Cheques Issued for Today | Total Post Dated Cheques Issed | Expected Receipts | Shoftfall/Surplus for Next Day | Shortfall/Surplus Overall |  |  | Remarks
 | 2009-06-30 00:00:00 | 2009-07-01 00:00:00
Kotak | -30466.31 | 46000 | 46000 | 250000 | -76466.31 | 173533.69
DAILY TRANSACTIONS REPORT |  |  |  |  |  | 2009-06-30 00:00:00
Clearing Dt | Issue Dt | Dr/Cr | Particulars | Chq No | Deposits | Withdrawal | Balance | Remarks