tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 64702d1265502312-complex-calculations-competition-partisipants-and-scores-09-10
Sheet: October

October Competition - Paws and Claws |  |  |  |  | 44 | Total Partisipants |  |  | 0.6437908496732025 | want to see edits
Beginners | Image | Score | Place | Edit | 17 | 0.7647058823529411
[NAME] | Polar Paws | 9 | 17 | X
[NAME] | Hands at Work | 9 | 16
[NAME] | 3-toed sloth | 10 | 15 | X
[NAME] | The Tool and Die Maker | 10 | 14 | X
[NAME] | Hands of the Potter | 10 | 13 | X
[NAME] | Peruvian Weaver | 10 | 12 | X
[NAME] | This page, papa | 10 | 11
[NAME] | Bear Claws | 11 | 10 | X
[NAME] | Waiting For [NAME] | 11 | 9 | X
[NAME] | Holding Each Other | 11 | 8 | X
[NAME] | Hands of Gold | 12 | 7 | X
[NAME] | Happy Toes | 12 | 6
[NAME] | Intimate Hands and Feet | 12 | 5
[NAME] | Two Pairs of Shoes | 13 | 4 | X
[NAME] | Caring Hands | 13 | 3 | X
[NAME] | Heart of Summer | 14 | 2 | X
Agnieszka Szczurowska | Tenderness | 15 | 1 | X
Advanced | Image | Score | Place | Edit | 15 | 0.6666666666666666
[NAME] | Keyboard hands | 9 | 15 | X
[NAME] | pouring hands | 9 | 14
[NAME] | [NAME] | 9 | 13 | X
[NAME] | Friendly Touch | 9 | 12 | X
[NAME] | Brave "Soles" | 10 | 11
[NAME] | [NAME] | 10 | 10
[NAME] | [NAME] | 10 | 9 | X
[NAME] | Gliding Alone | 11 | 8
[NAME] | Two Cow hands Having a Chat | 11 | 7 | X
[NAME] | Potter's Hands | 12 | 6 | X
[NAME] | Scottish Close Order | 12 | 5 | X
[NAME] | Like the Back of My Own Hand | 13 | 4
[NAME] | Pink Flower | 13 | 3 | X
[NAME] | Pigies in Paradise | 14 | 2 | X
[NAME] | The Reader | 15 | 1 | X
Masters | Image | Score | Place | Edit | 12 | 0.5
[NAME] | Post Time | 9 | 12 | X
[NAME] | Playing Spanish Instrument | 9 | 11 | X
[NAME] | Harpist | 10 | 10
[NAME] | A Rugby Player--Blisters and Ice | 10 | 9 | X
[NAME] | At the Potters Wheel | 11 | 8
[NAME] | [NAME] | 11 | 7 | X
Eleanore Avery | [NAME] that [NAME] | 11 | 6
[NAME] | Fingering the Tune | 12 | 5
[NAME] | Thumbscrew | 12 | 4 | X
[NAME] | Pumpkin Carving Hands | 13 | 3 | X
[NAME] | [NAME], So [NAME] | 14 | 2
[NAME] | Self Portrait - In Hand ! | 15 | 1
Spreadsheet: 885070d1734491587-create-table-data-summorising-with-drop-down-look-ups-test
Sheet: Summary

YTD |  |  |  |  | Current Month |  |  |  |  | Past Month
Counter Date | (All) |  |  |  | Counter Date | 2024-12-01 00:00:00 |  |  |  | Counter Date | 2024-11-01 00:00:00
Sum of Hours worked | Column Labels |  |  |  | Sum of Hours worked | Column Labels |  |  |  | Sum of Hours worked | Column Labels
Row Labels | Recoverable | Leave | Unrec |  | Row Labels | Recoverable | Leave | Unrec |  | Row Labels | Recoverable | Leave
Rotorua | 0.156089345860663 | 0.6027300124091473 | 0.2411806417301897 |  | Rotorua | 0.1028598328821937 | 0.6590561374602801 | 0.2380840296575262 |  | Wellington | 1 | 0
Hastings | 0.3116685419286518 | 0.6883314580713482 | 0 |  | Hastings | 0.2621968090011989 | 0.737803190998801 | 0 |  | [NAME] | 1 | 0
Wellington | 0.6168038603462958 | 0.3207493613397672 | 0.06244677831393698 |  | Wellington | 0.5608872793119059 | 0.3666817564508827 | 0.0724309642372114 |  | Invercargill | 0 | 1
[NAME] | 0.6317044100119189 | 0.1907032181168057 | 0.1775923718712753 |  | [NAME] | 0.4302282080059858 | 0.299289188178077 | 0.2704826038159371 |  | Grand Total | 0.6 | 0.4
Christchurch LV | 0.6457248640518337 | 0.2776813606386671 | 0.07659377530949901 |  | Christchurch LV | 0.6107005308629124 | 0.2914541480170709 | 0.09784532112001665
Greymouth | 0.2474613686534217 | 0.6622516556291391 | 0.0902869757174393 |  | Greymouth | 0.1458298088309931 | 0.7443748942649298 | 0.1097952969040771
Invercargill | 0.4415990894864135 | 0.2845354958031014 | 0.2738654147104851 |  | Invercargill | 0.4168610463178941 | 0.2665778073975342 | 0.3165611462845718
Grand Total | 0.4468935161672591 | 0.4339484227752383 | 0.1191580610575024 |  | Grand Total | 0.3741641918060404 | 0.487156775907883 | 0.1386790322860765
Spreadsheet: 586835d1534680799-combining-2-sets-of-tables-book3
Sheet: Sheet1

Item | COST | Colour |  |  | Colour | Year
Car | 13 | Blue |  |  | Green | 2008
Bike | 30 | Green |  |  | White | 2012
Table | 100 | White |  |  | Blue | 2017
Spreadsheet: 716352d1612183708-rent-spreadsheet-formulas-functions-assistance-please-rent-spread-sheet-help-1-again
Sheet: Summary

Rent Pay Records
Property | Rental period (d) | Amount payable per period | Rent LAST paid | Next Due Date | Last Amount Paid | Total paid to date | Rental payments made | ARREARS3 | ARREARS2
1 | 7 | 335 | 2020-02-02 00:00:00 |  | 335 |  | 1
2 | 7 | 335 | 2020-02-09 00:00:00 |  | 335 |  | 1
3 | 7 | 300
4 | 7 | 400
2020-02-01 00:00:00 | Pay $335
2 | 2020-02-08 00:00:00 |  | Pay $335
3 | 2020-02-15 00:00:00 |  | Pay $335
4 | 2020-02-22 00:00:00 |  | Pay $335
5 | 2020-02-29 00:00:00 |  | Pay $335
6 | 2020-03-07 00:00:00 |  | Pay $335
7 | 2020-03-14 00:00:00 |  | Pay $335
8 | 2020-03-21 00:00:00 |  | Pay $335
9 | 2020-03-28 00:00:00 |  | Pay $335
10 | 2020-04-04 00:00:00 |  | Pay $335
11 | 2020-04-10 00:00:00 |  | Pay $335
12 | 2020-04-17 00:00:00 |  | Pay $335
13 | 2020-04-24 00:00:00 |  | Pay $335
14 | 2020-05-01 00:00:00 |  | Pay $335
15 | 2020-05-08 00:00:00 |  | Pay $335
16 | 2020-05-15 00:00:00 |  | Pay $335
17 | 2020-05-22 00:00:00 |  | Pay $335
18 | 2020-05-29 00:00:00 |  | Pay $335
19 | 2020-06-05 00:00:00 |  | Pay $335
20 | 2020-06-12 00:00:00 |  | Pay $335
21 | 2020-06-19 00:00:00 |  | Pay $335
22 | 2020-06-26 00:00:00 |  | Pay $335
23 | 2020-07-03 00:00:00 |  | Pay $335
24 | 2020-07-10 00:00:00 |  | Pay $335
25 | 2020-07-17 00:00:00 |  | Pay $335
26 | 2020-07-24 00:00:00 |  | Pay $335
27 | 2020-07-31 00:00:00 |  | Pay $335
28 | 2020-08-07 00:00:00 |  | Pay $335
29 | 2020-08-14 00:00:00 |  | Pay $335
30 | 2020-08-21 00:00:00 |  | Pay $335
31 | 2020-08-28 00:00:00 |  | Pay $335
32 | 2020-09-04 00:00:00 |  | Pay $335
33 | 2020-09-11 00:00:00 |  | Pay $335
34 | 2020-09-18 00:00:00 |  | Pay $335
35 | 2020-09-25 00:00:00 |  | Pay $335
36 | 2020-10-02 00:00:00 |  | Pay $335
37 | 2020-10-10 00:00:00 |  | Pay $335
38 | 2020-10-17 00:00:00 |  | Pay $335
39 | 2020-10-24 00:00:00 |  | Pay $335
40 | 2020-10-31 00:00:00 |  | Pay $335
41 | 2020-11-07 00:00:00 |  | Pay $335
42 | 2020-11-14 00:00:00 |  | Pay $335
43 | 2020-11-21 00:00:00 |  | Pay $335
44 | 2020-11-28 00:00:00 |  | Pay $335
45 | 2020-12-05 00:00:00 |  | Pay $335
46 | 2020-12-12 00:00:00 |  | Pay $335
47 | 2020-12-19 00:00:00 |  | Pay $335
48 | 2020-12-26 00:00:00 |  | Pay $335
Spreadsheet: 39609d1237902463-logarithmic-trend-line-query-logarithmic-trend-query
Sheet: Sheet1 (2)

x Values | 0 | 50 | 100 | 150 | 200 | 250 | 300 | 350 | 400 | 450 | 500
y Values | 0 | 30 | 45 | 53 | 58
Formula on chart
y=36.496Ln(x)+2.2555
enter formula in excel: |  | 145.0286916061056 | 170.3257911078214
Spreadsheet: kate_symes__18647__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-02-14 00:00:00 |  | 275.24 | 1312 | 150.92 | 392
 | 2001-02-13 00:00:00 |  | 185 | 160 | 151.57 | 1400 | 194.42 | 1165 | 136.79 | 587
 | 2001-02-12 00:00:00 |  | 207.14 | 560 | 138.91 | 880 | 140.84 | 1676 | 158.45 | 785
 | 2001-02-11 00:00:00 |  | 150 | 160 | 140 | 600 | 141.19 | 3174 | 132.09 | 2803
 | 2001-02-10 00:00:00 |  | 153.75 | 320 | 115.46 | 1720 | 150.05 | 2068 | 161.43 | 828
 | 2001-02-09 00:00:00 |  | 153.75 | 320 | 116.25 | 1760 | 168.64 | 1070 | 117.98 | 945
 | 2001-02-08 00:00:00 |  | 176.25 | 960 | 148.1 | 2000 | 174.99 | 844 | 91.4 | 1905
 | 2001-02-07 00:00:00 |  | 169.28 | 4224 | 131.32 | 3628 | 190.46 | 1300 | 95.76 | 1283
 | 2001-02-06 00:00:00 |  | 149.44 | 720 | 146.14 | 1400 | 153.56 | 520 | 88.67 | 917
 | 2001-02-05 00:00:00 |  | 160.19 | 1864 | 143.63 | 1772 | 142.39 | 1579 | 82.26 | 1310
 | 2001-02-04 00:00:00 |  | 150 | 0 | 146.67 | 1200 | 94.46 | 2705 | 81.4 | 2734
 | 2001-02-03 00:00:00 |  | 165 | 0 | 152.1 | 2000 | 127.82 | 6039 | 83.63 | 2119
 | 2001-02-02 00:00:00 |  | 160 | 320 | 148.88 | 1600 | 145.26 | 2069 | 111.08 | 2227
 | 2001-02-01 00:00:00 |  | 231.82 | 176 | 161.58 | 696 | 171.56 | 2512 | 111.53 | 1611
 | 2001-01-31 00:00:00 |  | 250 | 64 | 145 | 32 | 196.22 | 2670 | 133.68 | 1348
 | 2001-01-30 00:00:00 |  | 200.83 | 384 | 142.84 | 592 | 205.28 | 1618 | 135.46 | 1365
 | 2001-01-29 00:00:00 |  | 232.86 | 224 | 197.1 | 1000 | 188.91 | 2740 | 130.63 | 1506
 | 2001-01-28 00:00:00 |  | 200 | 320 | 175 | 0 | 178.38 | 3068 | 130.84 | 1999
 | 2001-01-27 00:00:00 |  | 232.14 | 560 | 159 | 1000 | 196.47 | 1231 | 125.85 | 2421
 | 2001-01-26 00:00:00 |  | 241.67 | 720 | 159 | 1000 | 198.58 | 1670 | 142.36 | 652
 | 2001-01-25 00:00:00 |  | 239.29 | 560 | 151.67 | 600 | 144.13 | 2493 | 118.25 | 883
 | 2001-01-24 00:00:00 |  | 175 | 800 | 141.17 | 1200 | 131.25 | 2165 | 106.42 | 399
 | 2001-01-23 00:00:00 |  | 260 | 400 | 175.13 | 1600 | 153.02 | 1895 | 130.64 | 179
 | 2001-01-22 00:00:00 |  | 300 | 64 | 175 | 32 | 240.14 | 2002 | 135.3 | 335
 | 2001-01-21 00:00:00 |  | 175 | 0 | 130 | 0 | 156.73 | 1457 | 156.37 | 606
 | 2001-01-20 00:00:00 |  | 454 | 800 | 275.37 | 1080 | 176.21 | 3868 | 161.24 | 270
 | 2001-01-19 00:00:00 |  | 454 | 800 | 275.37 | 1080 | 206.29 | 1390 | 133.1 | 909
 | 2001-01-18 00:00:00 |  | 429.73 | 592 | 228.64 | 1704 | 275.21 | 3577 | 187.25 | 1153
 | 2001-01-17 00:00:00 |  | 235 | 160 | 150.91 | 880 | 284 | 1630 | 156.87 | 546
 | 2001-01-16 00:00:00 |  | 174.75 | 640 | 114.61 | 1264 | 198.32 | 1393 | 118.67 | 961
 | 2001-01-15 00:00:00 |  | 174.29 | 560 | 114.61 | 1264 | 163.34 | 2155 | 121.91 | 913
Spreadsheet: 16c0646d-9f7b-4557-b1f0-b5748af1739e
Sheet: 18

شركت ساختماني گسترش و نوسازي صنايع ايرانیان مانا ([NAME])
يادداشتهاي توضيحي صورتهاي مالي
دوره مالي شش ماهه منتهي به 31 خرداد ماه 1390
6-2-1- مانده بدهی این حساب به مبلغ 431605682 ریال مربوط به مازاد پرداختی های شرکت در ارتباط با تسویه حساب مالیاتی تا پایان سال 84 می باشد .
6-2-2- | [NAME] فوق  به  مبلغ 5،391،264،400 ريال عبارت [NAME] بابت فسخ موضوع خريد زمين دراراضی مراد آباد پونک
به طرفیت آقایان سید باقر حسینی ، حبیب ا... افروز ، سعدان ترابی ، نظرعلی تاجیک داودی وحسن دهقان می باشد که اقدامات  لازم به منظوروصول آن
ازطریق مراجع  قضايی بعمل [NAME]قرار گرفته [NAME] صدور دادنامه [NAME] .
جهت مبلغ فوق [NAME] در حسابها منظور شده است .
6-2-3- | مانده بدهی مذکور به مبلغ 101،351،250 ریال بابت بهای یکدستگاه وانت خريداری [NAME] صنعت [NAME] در
 | کارگاه سیمان حماء در سوریه می باشد .
7- | شرکتهای گروه به شرح ذیل می باشد :
 |  |  |  |  | 1390/03/31 |  | 1389/09/30
 |  |  |  |  | ریال |  | ریال
شرکت بازرگانی آفتاب درخشان |  |  |  |  | 154769310 |  | 0
شرکت توسعه ساخت و نصب قطعات بتونی و فلزی - مانا ساز |  |  |  |  | 25836150291 |  | 16613755085
شرکت فولاد سیرجان ایرانیان |  |  |  |  | 779625001 |  | 500100001
شرکت بابک مس ایرانیان |  |  |  |  | 205250000 |  | 193175000
شرکت فروسیلیس غرب |  |  |  |  | 50000000 |  | 0
8 -  موجودی موادوکالاوپيمان درجريان پيشرفت
موجودی موادوکالاوپيمان درجريان پيشرفت ازاقلام زيرتشکيل [NAME]:
 |  |  | 1390/03/31 |  |  |  | 1389/09/30
 |  | يادداشت | بهای تمام شده | ذخيره کاهش ارزش | خالص |  | خالص
 |  |  | ریال | ریال | ریال |  | ریال
پيمان درجريان پيشرفت |  |  | 0 |  |  |  | 47916847008
موجودی مواد وکالا |  | 8-1 |  |  |  |  | 3077582641
Spreadsheet: 102887d1300801868-eliminating-double-numbers-workbook12
Sheet: Sheet1

037 | 037
001
029 | 029
038 | 038
047 | 047
056 | 056
002
039 | 039
057 | 057
066
003
012 | 012
049 | 049
058 | 058
067 | 067
022
059 | 059
068 | 068
077
005
069 | 069
078 | 078
015 | 015
024 | 024
033
079 | 079
007
016 | 016
Spreadsheet: 803343d1667401737-formula-to-summary-countif-greater-than-book2-etaf
Sheet: Sheet1

Company Name | June | July | August | September | October
a |  | 2 |  | 4 | 1
b | 3 |  | 3 | 3 | 3 |  |  |  | June | 1
c | 1 |  | 1 |  | 1 |  |  |  | July | 6
d | 4 | 13 | 2 |  |  |  |  |  | August | 8
e |  |  |  | 19 | 2 |  |  |  | September | 11
f |  |  |  | 1 |  |  |  |  | October | 12
g |  |  | 1
h | 2 |  |  |  | 3
i |  | 22 | 91 | 32
j | 1
k |  | 2 | 1
l |  | 1 |  |  | 2
m | 1
n |  | 7 | 1
o |  |  | 10 | 5 | 4
p | 26 | 1
q |  |  | 6 | 6
r |  | 8 | 6 | 12
s |  |  |  | 1
t |  | 4 |  |  | 1
u |  | 1 | 3 | 10
v | 1
w | 3 | 4
x |  | 18
y |  |  | 13 | 5
z |  | 19 | 35
Spreadsheet: 616d16bf-4e1c-43fc-abc2-e1f4b7285081
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1
Aberdeen | Ademide Ademuyewo,[NAME], [NAME],
Abertay | [NAME],[NAME],damien [NAME]
[NAME] | Zachery Delaney
Dundee
Edinburgh College | [NAME]
Edinburgh | [NAME],[NAME],[NAME], [NAME],[NAME],[NAME],[NAME],[NAME]
 | [NAME], [NAME],[NAME],
[NAME] | [NAME],[NAME],[NAME], [NAME],[NAME], [NAME],[NAME]
 | [NAME]
Glasgow Caledonia
[NAME] | [NAME],
Kilmarnock | [NAME]
Napier | [NAME], [NAME],Holly Belch,Lauren Stoddart
Queen Margaret | [NAME],[NAME],[NAME],[NAME]
RGU | [NAME], [NAME], [NAME], [NAME]
Stirling | [NAME],[NAME],[NAME],[NAME], [NAME]
Strathclyde | [NAME],[NAME],[NAME], andrew Cunningham
[NAME] | [NAME],[NAME],
UHI | [NAME]
West Of Scotland | [NAME]
[NAME] | [NAME]
Spreadsheet: 31173d1226980095-calculate-cells-that-contain-a-formula-racing-team
Sheet: SM 

Category | Slip - 1 | Pts | [NAME] | Pts | Slip - 3 | Pts
Dial In | 12.41 |  | 12.41 |  | 12.41
ET | 12.42 |  | 12.63 |  | 12.55
Difference | 0.009999999999999787 |  | 0.2200000000000006 |  | 0.1400000000000006 |  | 0.01 | I am able to read the cells that do not contain a formula
RT
60FT
Attendance | 1 | 1 | 1 | 1 | 1 | 1
3/10 | 0 | 0 | 0 | 0 | 0 | 0 |  | each Column should only contain one line.
2/10 | 0 | 0 | 0 | 0 | 0 | 0 |  | but the calculation will not work on a cell that contains a formula
1/10 | 0 | 0 | 0 | 0 | 0 | 0
1/100 | 0 | 0 | 0 | 0 | 0 | 0 | 1
New ET Best 1 |  | 0 |  | 0 |  | 0
New ET Best 2 |  | 0 |  | 0 |  | 0
New ET Best 3 |  | 0 |  | 0 |  | 0
New 60ft Best 1 |  | 0 |  | 0 |  | 0
New 60ft Best 2 |  | 0 |  | 0 |  | 0
New 60ft Best 3 |  | 0 |  | 0 |  | 0
Light 1 |  | 0 |  | 0 |  | 0
Light 2 |  | 0 |  | 0 |  | 0
Light 3 |  | 0 |  | 0 |  | 0
Index |  | 0 |  | 0 |  | 0
Exact Dial | 0 | 0 |  | 0 |  | 0
Sub-Total |  | 1 |  | 1 |  | 1
Spreadsheet: 199408d1355210695-find-last-previous-non-blank-value-and-summarise-previous-6-months-forum-sample-moo
Sheet: Spend (1)

2011-12-25 00:00:00 | 2012-01-01 00:00:00 | 2012-01-08 00:00:00 | 2012-01-15 00:00:00 | 2012-01-22 00:00:00 | 2012-01-29 00:00:00 | 2012-02-05 00:00:00 | 2012-02-12 00:00:00 | 2012-02-19 00:00:00 | 2012-02-26 00:00:00 | 2012-03-04 00:00:00 | 2012-03-11 00:00:00 | 2012-03-18 00:00:00 | 2012-03-25 00:00:00 | 2012-04-01 00:00:00 | 2012-04-08 00:00:00 | 2012-04-15 00:00:00 | 2012-04-22 00:00:00 | 2012-04-29 00:00:00 | 2012-05-06 00:00:00 | 2012-05-13 00:00:00 | 2012-05-20 00:00:00 | 2012-05-27 00:00:00 | 2012-06-03 00:00:00 | 2012-06-10 00:00:00 | 2012-06-17 00:00:00 | 2012-06-24 00:00:00 | 2012-07-01 00:00:00 | 2012-07-08 00:00:00 | 2012-07-15 00:00:00 | 2012-07-22 00:00:00 | 2012-07-29 00:00:00 | 2012-08-05 00:00:00 | 2012-08-12 00:00:00 | 2012-08-19 00:00:00 | 2012-08-26 00:00:00 | 2012-09-02 00:00:00 | 2012-09-09 00:00:00 | 2012-09-16 00:00:00 | 2012-09-23 00:00:00 | 2012-09-30 00:00:00 | 2012-10-07 00:00:00 | 2012-10-14 00:00:00 | 2012-10-21 00:00:00 | 2012-10-28 00:00:00 | 2012-11-04 00:00:00 | 2012-11-11 00:00:00 | 2012-11-18 00:00:00 | 2012-11-25 00:00:00 | 2012-12-02 00:00:00 | 26-week sum (up to last value in row)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 750
 |  |  |  |  |  |  |  |  |  |  | 8000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2250
 |  |  |  |  |  |  |  |  |  |  |  | 1500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6500 | 4500 | 10000 | 5000 | 5000 | 5000
 |  |  |  |  |  |  |  |  |  |  |  |  | 17100.72 | 19656
 |  |  |  |  |  |  |  |  | 78973.44 | 31493.28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23138.53 |  |  |  |  |  | 11653.82 | 8037.12 | 6464.64 |  |  | 6464.64 | 18740.37 | 38675.84 | 26823.89 | 20911.36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14448 | 2653.36 | 14447.36 | 2653.36 |  | 8551 |  | 16551 | 8550.36 | 8550.36 |  |  | 9828 | 6464.64 | 21206.64 | 22058.4 |  |  | 8550.36 | 14250.6 | 5896.8 |  |  | 15654.6 | 9272.64
7847.66 | 7847.66 | 5661.36 | 11009.2 |  |  | 10736.45 | 16734.03 | 12653.36 | 11547.27 | 11144.12 |  | 13430.81 | 13430.81 | 2653.36 |  |  |  | 8083.09 | 8083.09 | 11210.94 | 10659.17 | 15655.08 | 9371.130000000001 | 11797.85 | 11630.39 | 8083.09
Spreadsheet: 143523d1330450516-unequal-summing-examplesum
Sheet: Sheet1

Origin | # times airport | Destination | # times airport
SAT | 1 | SAT | 4
AMS | 2 | JAN | 1
ANC | 1 | ABQ | 2
ATL | 84 | ABY | 1
BDL | 2 | ACC | 2
BHM | 1 | AMS | 1
BNA | 2 | ATH | 3
BOS | 5 | ATL | 50
BRU | 1 | AUS | 3
BTR | 1 | BDA | 1
BUF | 2 | BDL | 3
BUR | 1 | BGR | 1
CCS | 1 | BOG | 3
CDG | 1 | BOS | 2
CHS | 1 | BRU | 3
CUN | 1 | BTR | 1
CVG | 4 | BUF | 4
DAY | 1 | BWI | 1
DCA | 1 | BZN | 1
DEN | 4 | CCS | 1
DFW | 1 | CLE | 1
DTW | 26 | CLT | 1
EWR | 1 | CMH | 4
FAT | 1 | CVG | 2
Spreadsheet: 779216d1651652268-find-values-in-table-that-is-linked-throug-another-value-using-if-iferror-vlookup-sample
Sheet: Tabelle1

Name | Street | Code 1 | [NAME] | sdsds | assad | sdsd | sdsds | assadsd | Code 2
sdsd | sdsds | 1231 | sdsds | sdsd | asas | sdsds | [NAME] | sdsds
sdsd | sdsds | 7565 | sdsds | sdsd | asas | sdsds | [NAME] | sdsds
 |  | 8565
 |  | 9565
Spreadsheet: 774100d1648213830-find-next-available-day-find-next-available-day_for_sharepoint1
Sheet: Sheet1

Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Chosen | Results
01:00:00 | 05:00:00 | 03:00:00 | 04:00:00 | 08:00:00 |  |  | Sunday | Monday
02:00:00 | 02:00:00 | 08:00:00 | 09:00:00 | 05:00:00 |  |  | Monday | Monday
 |  | 09:00:00 | 06:00:00 |  |  |  | Saturday | Wednesday
07:00:00 | 08:00:00 |  |  | 07:00:00 |  |  | Tuesday | Tuesday
 |  |  |  | 02:00:00 |  |  | Wednesday | Friday
Spreadsheet: 37256d1235205515-moving-specific-dates-to-another-worksheet-sample-smallifarray
Sheet: January

DATE | ORDER# | PRODUCT | CONTACT |  | January Code: | 1 | Total Entries: | 14 |  | Required to keep sheet faster.
2009-01-23 00:00:00 | 4550039365 | Magnesium Sulfate | [NAME]
2009-01-16 00:00:00 | 4501227375 | Sodium Sulfate | [NAME]
2009-01-16 00:00:00 | 010609-22 | Sodium Acetate Trihydrate | [NAME]
2009-01-27 00:00:00 | 60399447 | Ammouniun Bicarbonate | [NAME] May
2009-01-16 00:00:00 | 95438-B | Calcium Chloride | [NAME]
2009-01-21 00:00:00 | 60398813 | Potassium Chloride | [NAME]
2009-01-27 00:00:00 | 1051703 | Zinc Sulfate | [NAME]
2009-01-05 00:00:00 | 7897954 | Calcium Dioxide | [NAME]
2009-01-27 00:00:00 | AU452254 | Citric Acid Granular | [NAME]
2009-01-29 00:00:00 | 95438-B2 | Calcium Chloride | [NAME]
2009-01-20 00:00:00 | 60398817 | [NAME] | [NAME]
2009-01-20 00:00:00 | 60398810 | [NAME] | [NAME]
2009-01-13 00:00:00 | 93140-B | Sodium Sulfate | [NAME]
2009-01-20 00:00:00 | 4550039427 | Sodium Carbonate | [NAME]
Spreadsheet: 101589d1299690591-lookup-quantity-of-part-by-warehouse-parts-lookup
Sheet: Inventory

Part | Description | Warehouse | Quantity
1452 | DECAL STAND CLEAR LONG | 2300 | 0
1453 | DECAL-CAUTION AUTOMATIC DOOR | 2300 | 6
1454 | DECAL-DO NOT ENTER/IN | 2300 | 4
1455 | DECAL-DO NO ENTER/OUT | 2300 | 0
1456 | DECAL-IN EMERGENCY PTO | 2300 | 0
1457 | DECAL-HANDICAP LOGO | 2300 | 0
1452 | DECAL STAND CLEAR LONG | 2301 | 0
1453 | DECAL-CAUTION AUTOMATIC DOOR | 2301 | 16
1454 | DECAL-DO NOT ENTER/IN | 2301 | 5
1455 | DECAL-DO NO ENTER/OUT | 2301 | 5
1456 | DECAL-IN EMERGENCY PTO | 2301 | 5
1457 | DECAL-HANDICAP LOGO | 2301 | 5
1452 | DECAL STAND CLEAR LONG | 2350 | 0
1453 | DECAL-CAUTION AUTOMATIC DOOR | 2350 | 3
1454 | DECAL-DO NOT ENTER/IN | 2350 | 2
1455 | DECAL-DO NO ENTER/OUT | 2350 | 0
1456 | DECAL-IN EMERGENCY PTO | 2350 | 0
1457 | DECAL-HANDICAP LOGO | 2350 | 0
1452 | DECAL STAND CLEAR LONG | 2351 | 0
1453 | DECAL-CAUTION AUTOMATIC DOOR | 2351 | 1
1454 | DECAL-DO NOT ENTER/IN | 2351 | 12
1455 | DECAL-DO NO ENTER/OUT | 2351 | 0
1456 | DECAL-IN EMERGENCY PTO | 2351 | 0
1457 | DECAL-HANDICAP LOGO | 2351 | 0
Spreadsheet: 773848d1648070386-updating-one-cell-based-on-the-value-of-another-salesmen
Sheet: Sheet1

 |  |  | Salesmen |  |  | Sales
 |  |  | [NAME] |  |  | 250
 |  |  | [NAME] |  |  | 100
 |  |  | [NAME] |  |  | 35
 |  |  | [NAME] |  |  | 598
 |  |  | Doug |  |  | 633
 |  |  | [NAME] |  |  | 250
 |  |  | [NAME] |  |  | 99
 |  |  | [NAME] |  |  | 75
 |  |  | [NAME] |  |  | 149
 |  |  | [NAME]
Spreadsheet: 750414d1633443988-automating-color-coding-and-trend-help-needed-jlausier-data-color-coding-request
Sheet: 9-8-2016

 | ServiceNow Data Accuracy
 | Computers
 |  | Assigned to | Asset Function | [NAME] | Model | Acquisition Method | Computers not reporting Inventory | Cost
 | Total Records | 48940 | 48940 | 48940 | 48940 | 48940 | 48940 | 48940
 | Missing Data Records | 1100 | 0 | 4500 | 485 | 1000 | 1351 | 720
 | Percentage of Missing Data
 | Server-(storage, Disk, Server)
 |  | Serial Number | State | [NAME] | Model | Acquisition Method | Cost
 | Total Records | 2401 | 2401 | 2401 | 2401 | 2401 | 2401
 | Missing Records | 221 | 0 | 1886 | 597 | 1150 | 2347
 | Percentage of Missing Data
 | Network Gear
 |  | Serial Number | State | [NAME] | Model | Acquisition Method | Cost
 | Total Records | 7287 | 7287 | 7287 | 7287 | 7287 | 7287
 | Missing Records | 188 | 677 | 7002 | 96 | 4746 | 7269
 | Percentage of Missing Data
 | US Cycle Count 6-17-2016
 | State | In transit available | In stock available | In stock used | Pending repair | Data Retention
 | Total Records | 325 | 145 | 868 | 13 | 89
 | Missing Records | 325 | 145 | 868 | 13 | 89
 | [NAME] |  | 1 | 1 | 1 | 1
 | Asset Reconciliation 2016 |  | Remediated Records
 | 30+ Day Audits/Site Asset Reconciliation |  | 7104
 | VMware |  | 3422
 | WebServer, AppServer, Disk, ETC |  | 5812
 | Total Infrastructure Asset Record Clean up
 | Duplicates based on Serial Number | 2016-06-22 00:00:00 | 2016-09-08 00:00:00
 | Comptuers | 187 | 0
 | Servers | 7225 | 454
 | Network Gear | 600 | 593
Spreadsheet: 451159d1458062217-understanding-a-calendar-excel-template-community-event-planner1
Sheet: PRINT VERSION

 |  | SUN |  |  | MON |  |  | TUE |  |  | WED |  |  | THU |  |  | FRI |  |  | SAT
Spreadsheet: 2118726d-8312-4d48-9662-cbb53cbc262a
Sheet: Sheet1

Unnamed: 0 | Center for Student Involvement | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Student Organization Check Report
Amount of Check: |  |  |  | Account Number:
Date: |  |  |  | Event Date:
Student Name: |  |  |  | Event Time:
Student Organization Name:
Nature of Expense/Comments:
Supplies: Line #1
Store | Description Of Items | Quantity |  | Expenses
 |  |  |  | 0
 |  |  |  | 0
Food/Drinks: Line #2
Store | Description Of Items | Quantity |  | Expenses
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
Other Itemized Expenses: Line #3
Store | Description Of Items | Quantity |  | Expenses
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
Amount of Check: |  |  |  |  | 0
Total Expense:(Total lines 1,2,& 3) |  |  |  |  | 0
[NAME] to SOLF: |  |  |  |  | 0
SIGNATURE OF PRESIDENT:
DATE OF REPORT:
COORDINATOR for STUDENT ORGANIZATIONS APPROVAL:
The Information you have supplied on this form is maintained by the Center for Student Involvement. You have the right to review and correct this
information by contacting The Center for Student Involvement.                                                                                   Revised 08/13/2012
Spreadsheet: 126261d1319597234-excel-2007-convert-a-letter-to-a-number-vlookuplettertovalue
Sheet: Sheet1

Letter | Number |  |  |  | Letter | Val
L |  |  |  |  | E | 10 | <<This is the Vlookup Table
H |  |  |  |  | H | 8
E |  |  |  |  | G | 6
L |  |  |  |  | L | 4