tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 67539d1268143345-formulae-across-tabs-and-knowing-which-to-use-excel-mockup-for-forum
Sheet: The Teams

Goalies
Defenders | Harv
Midfielders
Strikers | No. | Code | Name | Club | Cost | Wk18-19 | Wk20 | Wk21 | Wk22 | Wk23 | Wk24 | Wk25 | Wk26 | Wk27 | Wk28 | Wk29 | Wk30 | Wk31 | Wk32 | Wk33
 | 1 | 024 | P Cech | Chelsea | £5.5m | 87 | 107 | 40 | 43 | 43 | 44 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2 | 109 | R [NAME] | Birmingham City | £1.0m | 26 | 28 | 11 | 11 | 11 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 3 | 170 | A Cole | Chelsea | £5.5m | 147 | 147 | 48 | 47 | 50 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 4 | 246 | W Brown | [NAME] | £3.5m | 73 | 76 | 34 | 42 | 42 | 48 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 5 | 104 | [NAME] | Arsenal | £5.0m | 148 | 148 | 65 | 68 | 68 | 68 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 6 | 564 | F Lampard | Chelsea | £8.5m | 189 | 189 | 2 | 2 | 5 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 7 | 622 | S Gerrard | Liverpool | £8.5m | 123 | 129 | 54 | 59 | 63 | 71 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 8 | 691 | J Milner | [NAME] | £4.5m | 29 | 35 | 11 | 11 | 11 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 9 | 534 | D Dunn | [NAME] | £2.0m | 41 | 46 | 5 | 7 | 9 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 10 | 952 | D Bent | Sunderland | £3.0m | 89 | 89 | 16 | 16 | 16 | 47 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 11 | 978 | [NAME] | Fulham | £2.5m | 84 | 97 | 85 | 89 | 89 | 92 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Total | 1036 | 1091 | 371 | 395 | 407 | 460 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sonia
 | No. | Code | Name | Club | Cost | Wk18-19 | Wk20 | Wk21 | Wk22 | Wk23 | Wk24 | Wk25 | Wk26 | Wk27 | Wk28 | Wk29 | Wk30 | Wk31 | Wk32 | Wk33
 | 1 | 065 | S Given | Manchester City | £4.5m | 85 | 91 | 85 | 89 | 89 | 92 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2 | 171 | B [NAME] | Chelsea | £3.0m | 102 | 112 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 3 | 168 | R Carvalho | Chelsea | £4.5m | 30 | 29 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 4 | 104 | [NAME] | Arsenal | £5.0m | 100 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 5 | 247 | J Evans | [NAME] | £4.0m | 52 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 6 | 691 | J Milner | [NAME] | £4.5m | 185 | 191 | 244 | 243 | 256 | 261 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 7 | 655 | R [NAME] | [NAME] | £4.0m | 50 | 50 | 13 | 13 | 13 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 8 | 527 | A Young | [NAME] | £5.5m | 122 | 138 | 30 | 30 | 30 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 9 | 900 | C [NAME] | Manchester City | £5.0m | 76 | 76 | 97 | 97 | 103 | 104 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 10 | 999 | K Doyle | [NAME] | £2.0m | 65 | 65 | 65 | 68 | 68 | 68 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 11 | 896 | W Rooney | [NAME] | £8.0m | 291 | 309 | 29 | 29 | 29 | 29 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Total | 1158 | 1216 | 563 | 569 | 588 | 597 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 478902d1473147037-change-cellvalue-with-another-cell-gradematris
Sheet: test 2

10
9 | Idea Value |  |  |  |  |  |  |  |  |  |  |  | Prio order
8
7 |  | Customer Value |  | Business Value |  | Strategic Fit |  | Technical complexity |  | IDEA VALUE | Return within 1 year |  | Idea Description | Idea Value | Idea nr | BC | Decision | Prio | Responsible
6 | Weight | 0.3 |  | 0.3 |  | 0.25 |  | 0.15 |  | TOTAL | Yes/No |  |  |  |  |  | GO/HOLD/STOP |  |  |  |  |  |  | GO | Yes
5 | Idé 1 | 5 |  | 2 |  | 5 |  | 5 |  |  |  |  |  |  |  | Atachment 1 |  |  | Name |  |  |  |  | HOLD | No
4 | Idé 2 | 5 |  | 2 |  | 5 |  | 5 |  |  |  |  |  |  |  | Atachment 2 |  |  | Name |  |  |  |  | STOP
3 | Idé 3 | 5 |  | 5 |  | 5 |  | 5 |  |  |  |  |  |  |  | Atachment 3 |  |  | Name
2 | Idé 4 | 5 |  | 5 |  | 1 |  | 5 |  |  |  |  |  |  |  | Atachment 4 |  |  | Name
1 | Idé 5 | 5 |  | 5 |  | 1 |  | 5 |  |  |  |  |  |  |  | Atachment 5 |  |  | Name
 | Idé 6 | 5 |  | 5 |  | 5 |  | 5 |  |  |  |  |  |  |  | Atachment 6 |  |  | Name
 | Idé 7 | 5 |  | 5 |  | 5 |  | 5 |  |  |  |  |  |  |  | Atachment 7 |  |  | Name
 | Idé 8 | 5 |  | 5 |  | 5 |  | 5 |  |  |  |  |  |  |  | Atachment 8 |  |  | Name
 | Idé 9 | 5 |  | 5 |  | 5 |  | 5 |  |  |  |  |  |  |  | Atachment 9 |  |  | Name
 | Idé 10 | 5 |  | 5 |  | 5 |  | 5 |  |  |  |  |  |  |  | Atachment 10 |  |  | Name
 | Number of ideas |  | 10
 | Cat 1 |  | 0
 | Cat 2 |  | 1
 | Cat 3 |  | 3
 | 1
 | 2
 | 3
 | 4
 | 5
Spreadsheet: 273661d1382827285-head-to-head-tiebreakers-in-champions-league-cltemp-13-14
Sheet: Groups

 | Group A |  |  |  |  |  |  |  |  |  |  |  | Group B
 | Team | P | W | D | L | F | A | [NAME] | AG | Pts |  |  | Team | P | W | D | L | F | A | [NAME] | AG | Pts
 | Group C |  |  |  |  |  |  |  |  |  |  |  | Group D
 | Team | P | W | D | L | F | A | [NAME] | AG | Pts |  |  | Team | P | W | D | L | F | A | [NAME] | AG | Pts
 | Group E |  |  |  |  |  |  |  |  |  |  |  | Group F
 | Team | P | W | D | L | F | A | [NAME] | AG | Pts |  |  | Team | P | W | D | L | F | A | [NAME] | AG | Pts
 | Group G |  |  |  |  |  |  |  |  |  |  |  | Group H
 | Team | P | W | D | L | F | A | [NAME] | AG | Pts |  |  | Team | P | W | D | L | F | A | [NAME] | AG | Pts
Spreadsheet: 267124d1379959107-vlookup-book1
Sheet: Sheet1

Jan | Feb | Mar | Apr
10 | 3 | 0 | 3
11000 | 22000 | 33000 | 44000
True | False | False | False
No | No | No | No
10 | 0 | 0 | 0
 | 11000 | 22000 | 33000
 | True | False | False
 | No | No | No
 | 3 | 0 | 0
 |  |  | 11000
 |  | False | True
 |  | No | No
 |  | 0 | 3
 |  |  | 11000
 |  |  | True
 |  |  | No
 |  |  | 3
10 | 3 | 0 | 3
Spreadsheet: 01d8bb0f-4c19-41fd-ad03-ec9799e1d47b
Sheet: FY 2005 Lease Turnover Analysis

FY 2005 Lease Turnover Analysis
Disposition Of Leases Expiring in FY 2005 | Sq Ft | % of Total Sq Ft | Count | % of Total Count
Leases Scheduled to Expire in FY 2005 | 23030208 | 1 | 1783 | 1
Extended in FY 2005 Beyond FY 2005 | 11063443 | 0.4803883230233961 | 1120 | 0.628154795288839
Renewed During FY 2005 | 2906933 | 0.126222611623829 | 72 | 0.04038137969713965
Replaced in Same Building with New Leases | 4101129 | 0.1780760729560063 | 257 | 0.1441390914189568
Subtotal | 18071505 | 0.7846870076032314 | 1449 | 0.8126752664049355
Leases Terminated | 3269887 | 0.1419825213910356 | 164 | 0.09197980931015143
Leases Moved to Another Leased Building | 1688816 | 0.07333047100573299 | 170 | 0.09534492428491306
Subtotal | 4958703 | 0.2153129923967686 | 334 | 0.1873247335950645
[Non-add: Leases Terminated - Move to Federal Bldg | 340842 | 0.01479977948961642 | 20 | 0.01121704991587213
[Non-add: Leases Terminated - Canceled Agency Req. 1/ | 1948623 | 0.0846116109763316 | 102 | 0.05720695457094784
Disposition of Leases Expiring After FY 2005
Leases Scheduled to Expire After FY 2005 | 134278390 | 1 | 6347 | 1
Lease Replaced In Same Leased Building After [NAME] | 205718 | 0.001532026113807293 | 13 | 0.002048211753584371
Lease Replaced In Same Leased Building Before Firm Term | 109050 | 0.0008121187631159414 | 3 | 0.0004726642508271625
Lease Replaced In Different Leased Building After [NAME] | 615309 | 0.004582338230299008 | 39 | 0.006144635260753112
Lease Replaced In Different Leased Building Before Firm Term | 29666 | 0.0002209290713122193 | 5 | 0.000787773751378604
Lease Terminate W/O Lease Replacement After [NAME] | 950421 | 0.007077989243094142 | 80 | 0.01260438002205766
Lease Terminate W/O Lease Replacement Before Firm Term | 326661 | 0.002432714601359162 | 20 | 0.003151095005514416
[Non-add: Leases Terminated - Move to Federal Bldg | 265044 | 0.001973839573143527 | 13 | 0.002048211753584371
[Non-add: Leases Terminated - Canceled Agency Req. 1/ | 659024 | 0.004907893220941955 | 59 | 0.009295730266267527
FY 2005 Lease Turnover
Total Leases At Start of FY 2005 | 157308598 | 1 | 8130 | 1
Same/Replacement Leases Continued Past FY 2005 | 150427838 | 0.95625947921804 | 7652 | 0.9412054120541206
Same Lease Space Dis-Continued Past FY 2005 (Turnover) | 6880760 | 0.04374052078196006 | 478 | 0.05879458794587946
[Non-add: Leases Terminated - Move to Federal Bldg | 605886 | 0.003851575868726514 | 33 | 0.004059040590405904
[Non-add: Leases Terminated - Canceled Agency Req. 1/ | 2607647 | 0.01657663365609552 | 161 | 0.01980319803198032
1/ Only counts actions where leases had to be terminated due to customer office closures, partial reductions in space not included.
Spreadsheet: 103653d1301397900-remove-duplicate-values-in-an-index-return-lc_reviewv2tester
Sheet: Compare

 |  |  |  |  | SMALL(IF($E$3:$E$13=$I$1,ROW($E$3:$E$13)),ROW(6:6))
 | Task Order | 1
 | Clin | 1 |  |  | IFERROR(INDEX(Sheet2!$A$1:$N$515,SMALL(IF(Sheet2!$A$1:$N$515=$A$1,ROW(Sheet2!$A$1:$N$515)),ROW(Sheet2!$A2:$N2)),2),"")
 | Subclin | 0
 |  |  | INDEX($A$2:$A$16,SMALL(IF(C$2:C$16=$F4,ROW($A$2:$A$16)-ROW($A$2)+1),COUNTIF($F$4:$F4,$F4))) |  | SMALL(IF('Cost Prop'!$B$3:$B$27=Compare!$C$6,ROW('Cost Prop'!$H$3:$H$27)),ROW(4:4))
 |  |  | LIST OF Labor Categories |  | INDEX($A$2:$A$16,SMALL(IF(C$2:C$16=$F4,ROW($A$2:$A$16)-ROW($A$2)+1),COUNTIF($F$4:$F4,$F4)))
 |  |  |  | Is there a way for the fomulat to no show this line since it’s the same as the above line?
 |  |  |  | Is there a way for the fomulat to no show this line since it’s the same as the above line?
Spreadsheet: 710331d1608847257-help-pulling-data-from-a-range-copy-of-attendance-template-w-formula
Sheet: Range Totals

 | Range Selection
Employee Name | Beginning | Ending | CI | T | NCNS | Points
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] | January | March | 0 | 6 | 0 | 3 | <=expected results for this example employee
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Obed Attamah
[NAME]
[NAME]
Keath Grimes
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 220924d1363303277-inventory-problem-calculator
Sheet: Help

 |  |  | How To Use The Magic Calculator
 |  | ● | Set the Promo Dates up if not already done (this calculates how many days you are on)
 |  | ● | Open Daily Warehouse Report
 |  | ● | Go to supplier and highlight each row from column A- L (Stock code to pick location)
 |  | ● | Copy the selected area (Ctrl+C or Right Click and choose [NAME])
 |  | ● | Go to the 'VLOOKUP DATA' tab below and select cell C3
 |  | ● | Right Click and choose 'Paste Special'
 |  | ● | Select the Values option and click OK
 |  | ● | Check the 'On [NAME]' column against VMR and enter correct values if needed
 |  | ● | Change the layers if needed (e.g. When you order a slow seller in 5's change to 5)
 |  | ● | Go to the Magic Calculator tab
 |  | ● | Fill in Cover and [NAME] boxes. Select Pallets or Layers depending on which one you want to calculate
 |  |  | the majority of the order in.
 |  | ● | Enter in forecast volumes for future promos (what it will do for WHOLE promo - the calculator will do the rest).
 |  |  | Leave blank any promos that you want to treat as continuing
 |  |  | Overrides
 |  | ● | Use the cases override column to input a set number of cases to order.
 |  |  | (e.g. Use for delisted lines, set value to 0)
 |  | ● | Use the P/L override column to calculate in Pallets/Layers
 |  |  | (e.g. Use when supplier is normally pallets but a slower seller is ordered in layers)
 |  |  | Limitations
 |  | ● | Will only do 150 lines at a time
 |  | ● | Will not figure out an order to exact loads (but you can change the cover and use the overrides to work it out)
Spreadsheet: 849690d1700100035-sumrange-with-criteria-using-sumproduct-sumrange-with-sumproduct
Sheet: Sheet1

Cage | Vol Est | Real |  |  |  |  | >90%
 |  |  |  |  |  | RESUME | SUMIF | SUMPRODUCT
 |  |  |  |  |  | GA
 |  |  |  |  |  | GB
GA-01 | 950.5 | 0.9468700683850605 |  |  |  | GC
GA-02 | 1028.5 | 0.8750607681088964 |  |  |  | [NAME]
GA-03 | 850.4 | 0.8819379115710254 |  |  |  | GE
[NAME] | 1435.1 | 0.9197965298585465 |  |  |  | TOTAL
GA-05 | 0
GA-06 | 879.5 | 1.023308698123934
GA-07 | 1847.8 | 0.730598549626583
GA-08 | 857.9 | 0.9091968760927848
GA-09 | 280 | 1.071428571428571
GA-10 | 414.3 | 1.158580738595221
GA-11 | 970.9 | 1.019672468843341
GA-12 | 380.5 | 0.8672798948751642
GB-01 | 666.9 | 0.9896536212325686
GB-02 | 413.2 | 0.5808325266214909
GB-03 | 425.1 | 0.7057163020465772
[NAME] | 205.9 | 0.4371053909664886
GB-05 | 1860 | 0.6451612903225806
GB-06 | 0
GB-07 | 630.7 | 1.664816870144284
GB-08 | 382.9 | 0.7834943849569078
GB-09 | 352.7 | 0.8505812305075134
GB-10 | 0
GB-11 | 1476.9 | 0.9140767824497257
GB-12 | 0
GC-01 | 1435.2 | 0.9615384615384615
GC-02 | 1364.7 | 0.8793141349747197
GC-03 | 1799 | 0.8671484157865481
GC-04 | 0
[NAME] | 1502.8 | 0.9981368112856003
GC-06 | 1303.8 | 1.035434882650713
GC-07 | 1037.1 | 1.01243853051779
GC-08 | 879.6 | 1.023192360163711
GC-09 | 1597 | 0.939261114589856
GC-10 | 1000.3 | 1.649505148455463
GC-11 | 1551.5 | 1.005478569126652
GC-12 | 332.1 | 1.084010840108401
GD-01 | 864.9 | 1.109954908081859
GD-02 | 952.3 | 1.19710175364906
GD-03 | 1012.4 | 1.185302252074279
[NAME] | 1085.7 | 1.105277701022382
GD-05 | 1668.3 | 1.078942636216508
GD-06 | 1639.6 | 1.006343010490363
GD-07 | 1030.5 | 0.8733624454148472
GD-08 | 1998.9 | 0.9605282905598078
GD-09 | 737.8 | 0.9758742206560044
GD-10 | 1358.9 | 0.5960703510192067
GD-11 | 639.1 | 1.032702237521515
GD-12 | 1124.2 | 0.8806262230919765
GE-01 | 677.7 | 0.9296148738379814
GE-02 | 764.7 | 0.902314633189486
GE-03 | 326.2 | 0.9196811771919068
[NAME] | 311.9 | 1.154216094902212
GE-05 | 0
GE-06 | 1289.9 | 0.9303046747809907
GE-07 | 1445.8 | 0.9337391063770923
GE-08 | 896.3 | 0.9037152739038269
GE-09 | 831.3 | 0.8661133164922411
GE-10 | 368.1 | 1.059494702526487
GE-11 | 600.4 | 0.999333777481679
GE-12 | 337.5 | 1.155555555555555
Spreadsheet: joe_parks__14991__BridgeDPR0522
Sheet: Bridgeline DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRIDGELINE GAS MARKETING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
BRIDGELINE GAS MARKETING
GAS TRADING |  |  | 15 Bcf |  |  |  |  |  |  | 2000
1 Month |  |  |  |  |  | 9 Bcf 1 Month
2-12 Months |  |  |  |  |  | 25 Bcf 2-12 Months
13-18 Months |  |  |  |  |  | 5 Bcf 13-18 Months
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTD | QTD | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA | 2456.826353900004 | 4459.826353900004 | 9750.826353900004
 |  |  |  |  |  |  |  |  |  |  |  |  | GAS TRADING | 2456.826353900004 | 4459.826353900004 | 9750.826353900004
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778
Spreadsheet: 850829d1701177434-inventory-list-is-not-subtracting-after-a-specific-date-inventory-chart-1-
Sheet: SPICES

Triton Foods LLC. |  |  | WEEKLY SPICES STOCK                                                                               NOVEMBER 2023
Code | Description | QTY as on Nov-15 | Current Qty | Qty on Order | 16-Nov | 17-Nov | 18-Nov | 19-Nov | 20-Nov | 21-Nov | 22-Nov | 23-Nov | 24-Nov | 25-Nov | 26-Nov | 27-Nov | 28-Nov | 29-Nov | 30-Nov
KF1308 | IN [NAME] Tikka Tandoori Marinade -730741 KG | 24.3 |  |  | 4.4 | 4.4 |  |  |  |  |  |  |  |  |  | 2
IN1571 | [NAME] 750138 | 100
IN1572 | TARI COMPLET CB 5 | 0
IN1673 | [NAME] | 19.6 |  |  | 0.55 | 0.55
IN1674 | [NAME] | 2.54 |  |  | 0.065 | 0.065
KF0684 | [NAME]
IN1675 | Sugar |  |  |  | 1.25 | 0.85
IN1688 | [NAME] complete brine 730831 | 564.3 |  |  | 37.5 | 25.3
IN1695 | PAPRIKA POWDER | 24 |  |  | 0.22 | 0.22
IN1792 | [NAME] |  |  |  | 1.76 | 1.76
IN1801 | Super Mittel 750142 | 267.6
IN1811 | Sodium Lactate 60% 25Kg Drum | 178
IN1818 | IN [NAME] Tikka Tandoori Marinade -730926 KG W/S | 98
IN1822 | [NAME] | 91.8 |  |  | 2.75
IN1823 | [NAME] and Pepper Seasoning - 730696 |  |  |  | 24
KF0378 | Salt | 448.5 |  |  | 0.45 | 0.725
KF1047 | [NAME]
[NAME] | Sodium Tri Poly Phosphate | 600.9 |  |  | 7.65 | 5.7
KF0380 | Mono Sodium Glutamate |  |  |  | 115
KF0447 | Shawarma Spice | 22.6
KF0485 | Tari Fresh 60 | 30 |  |  | 0.66 | 0.66
KF0493 | Unicell Wf 200 Wheat Fiber 140 | 10
KF0632 | Papprika Color 40000 | 20 |  |  | 0.22 | 0.22
KF0727 | [NAME] Powder | 0
 | [NAME] |  |  |  | 1.15 | 0.22
 | Corn Flour | 13.5 |  |  | 0.22
 | Black Pepper Crushed
 | [NAME] |  |  |  | 0.055
 | Lemon Juice | 118 |  |  | 2.6 | 1.54
 | Oil | 52 |  |  | 5.6 | 3.3
 | [NAME] 6682S25 | 25
Spreadsheet: b7f9a3ab-1fbc-495b-a35b-41d9b6eaeaf3
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
EBVE | Test | EBVE | [NAME] (EBV), IgG Antibody to Early Antigen, Serum | EBV EA [NAME], S | [NAME] | Plain, Red-Top Tube: Red OR Serum Gel Tube: SGT OR |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	Heat-activated specimen | Negative | Monday through Friday; 1st shift | Same day/1 day | 3 days | 1 | 86663 |  |  |  |  | New England
EBVE | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
EBVE | Result | EBVE | EBV EA [NAME], S | EBV EA [NAME], S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22295-0 | [NAME] virus early Ab.IgG:ACnc:Pt:Ser:Ord:
Spreadsheet: 0122eefc-293f-4ec9-b2d4-8c71fd17d628
Sheet: Sheet1

For Reporting Period as of: | Unnamed: 1 | Name of Sponsor: | Unnamed: 3 | Unnamed: 4
 | (Mo./Day/Year)
This form represents a sample statement which can be utilized as a guide for preparing your Balance Sheet.  Please provide
as much detail concerning your assets and liabilities for your most current 12-month reporting period.  If your business has been
open less than 12 months, complete for the number of months in operation.
 | ASSETS |  | LIABILITIES & OWNER'S EQUITY
Current Assets |  | 0 | Current Liabilities
Cash in Bank |  | 0 | Accounts Payables (rent, utilities, etc.) | 0
Accounts Receivable** |  | 0 | Short Term Loans | 0
Inventory |  | 0 | Other Liabilities due in 12 months | 0
 |  |  | Current portion of long-term loan* | 0
Total Current Assets |  | 0 | Total Current Liabilities | 0
Long-term Assets |  |  | Long-term Liabilities
Land |  | 0 | Long-term loans (due after 1 year) | 0
Buildings | 0 | 0 | Mortgage | 0
Less Depreciation | 0 |  | Total Long-term liabilities | 0
Net Buildings |  | 0
 |  |  | Total Liabilities | 0
Equipment | 0
Less Depreciation | 0 |  | OWNER'S EQUITY
Net Equipment |  | 0 | Share Capital | 0
 |  |  | Net Profit/Loss | 0
 |  |  | [NAME] | 0
Total Long-Term Assets |  | 0 | Total Owner's Equity | 0
 |  | 0
Total Assets (total current assets & total long-term assets) |  | 0 | Total Owner's Equity & Total Liabilities | 0
Prepared by:
Title: |  |  | Preparation Date:
*Current portion of long-term debt = monthly payment of loan times 12 months
**Should only include the amount you have earned but not yet received. |  |  |  | Rev. 2/2013
Spreadsheet: 76501d1277060089-data-query-question-1-
Sheet: Sheet1

Company | Product | Amount |  |  |  | Company A |  |  |  |  | Company B |  |  |  |  | Company C
A | A | 2 |  |  |  | Product |  | Amount |  |  | Product |  | Amount |  |  | Product |  | Amount
B | B | 5
B | C | 4
A | D | 2
A | E | 1
B | F | 7
C | G | 8
C | H | 9
C | I | 7
 |  |  |  |  |  | This is how I want it to look
 |  |  |  |  |  | Company A |  |  |  |  | Company B |  |  |  |  | Company C
 |  |  |  |  |  | Product |  | Amount |  |  | Product |  | Amount |  |  | Product |  | Amount
 |  |  |  |  |  | A |  | 2 |  |  | B |  | 5 |  |  | G |  | 8
 |  |  |  |  |  | D |  | 2 |  |  | C |  | 4 |  |  | H |  | 9
 |  |  |  |  |  | E |  | 1 |  |  | F |  | 7 |  |  | I |  | 7
Spreadsheet: 732607d1621043185-price-menu-dependent-drop-downs-with-lookup-function-based-on-multiple-selections-price-menu-xlookup
Sheet: Service Invoice

 |  | INVOICE
 | Company Name
 | street |  | DATE:
 | City, ST  ZIP Code |  | INVOICE # | 100
 |  |  | FOR: | Project or Service Description
 | BILL TO:
 | Name
 | Company Name |  | Make | Model
 | Street Address |  | FORD | Mustang
 | City, ST  ZIP Code
 | Phone
 | Category | Service | HOURS | AMOUNT
 | BRAKES | R&R FRONT BRAKE PADS -RESURFACE ROTORS
 | BRAKES | R&R FRONT BRAKE PADS -REPLACE ROTORS
 |  |  | TAX RATE | 0.0775
 |  |  | SALES TAX
 |  |  | OTHER
 |  |  | TOTAL
Spreadsheet: 95027d1294746296-excel-2007-get-dates-from-a-beginning-date-ending-date-and-a-schedule-livro1
Sheet: Folha1

Persons name | Treatments |  | Dia/Hora
 | Beginning | Ending | Monday / Time Entering | Time Quiting | Tuesday / Time Entering | Time Quiting | Wednesday / Time Entering | Time Quiting | Thursday / Time Entering | Time Quiting | Friday / Time Entering | Time Quiting
[NAME] | 2009-03-06 00:00:00 | 2009-03-16 00:00:00 | 10:45:00 | 12:00:00 | 10:45:00 | 12:00:00 | 10:45:00 | 12:00:00 |  |  | 10:45:00 | 12:00:00
 | Since this patient has gone for treatment all weak days with the exception of Thursday, the formula/procedure I am searching for, should retrieve all the dates between initial and final date with the exception of weekends and Thursdays
 | In this case:
 | 2009-03-06 00:00:00
 | 2009-03-09 00:00:00
 | 2009-03-10 00:00:00
 | 2009-03-11 00:00:00
 | 2009-03-13 00:00:00
 | 2009-03-16 00:00:00
Spreadsheet: 713314d1610643483-turning-a-list-of-users-into-a-matrix-test
Sheet: Users

User | Role | Performer | Reviwer | Approver
1 | Performer
1 | Reviewer
1 | Approver
2 | Performer | x | x
2 | Reviewer | x | x
3 | Performer
3 | Reviewer
3 | Verifier
3 | Approver
User | Performer | Reviewer | Approver
1
2
3
Spreadsheet: 856041d1705434615-formula-for-finding-a-specific-value-in-a-table-based-on-2-inputs-find-setting
Sheet: Sheet1

 | INDEX | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | Setting | MCP Continous Amp Rating |  |  |  |  |  |  |  |  | Setting
INDEX |  | 3 | 7 | 15 | 30 | 50 | 100 | 150 | 175 | 250 |  |  | MCP Rating | Setting | Setting in Amps
2 | A | 12 | 28 | 45 | 90 | 150 | 300 | 750 | 875 | 1250 | A |  | 15 | D |  |  | Objective:Return Trip Setting L4:L12  Search in array C4:[NAME], the explicit column is based on P7 Find the clostest value in the array that is <=O2 Return letter from Setting Column L4:L12
3 | B | 15 | 34 | 60 | 120 | 200 | 400 | 844 | 984 | 1406 | B
4 | C | 17 | 40 | 75 | 150 | 250 | 500 | 938 | 1094 | 1563 | C |  | Motor Size | [NAME] in Amps | MCP rating | Setting
5 | D | 20 | 46 | 90 | 180 | 300 | 600 | 1031 | 1203 | 1719 | D |  | 5 | 83.6 | 15
6 | E | 23 | 53 | 105 | 210 | 350 | 700 | 1125 | 1313 | 1875 | E
7 | F | 25 | 59 | 120 | 240 | 400 | 800 | 1219 | 1422 | 2031 | F
8 | G | 28 | 65 | 135 | 270 | 450 | 900 | 1313 | 1531 | 2188 | G
9 | H | 30 | 71 | 150 | 300 | 500 | 1000 | 1406 | 1641 | 2344 | H
10 | I | 33 | 77 | 165 | 330 | 550 | 1100 | 1500 | 1750 | 2500 | I