tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 878445d1725528038-calculate-working-hours-working-hours-jac-2
Sheet: Original formula

 | Original formula |  |  |  |  |  |  |  |  |  |  | Original formula short |  |  |  |  |  |  |  |  |  |  |  | Original formula TRANSPOSED short
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(D3-C3>=0;D3-C3;$BM$1-C3+D3);0);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(F3-E3>=0;F3-E3;$BM$1-E3+F3);0);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(H3-G3>=0;H3-G3;$BM$1-G3+H3);0);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(J3-I3>=0;J3-I3;$BM$1-I3+J3);0);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(L3-K3>=0;L3-K3;$BM$1-K3+L3);0);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(N3-M3>=0;N3-M3;$BM$1-M3+N3);0);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(P3-O3>=0;P3-O3;$BM$1-O3+P3);0);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(R3-Q3>=0;R3-Q3;$BM$1-Q3+R3);0);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(T3-S3>=0;T3-S3;$BM$1-S3+T3);0);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(V3-U3>=0;V3-U3;$BM$1-U3+V3);0);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(X3-W3>=0;X3-W3;$BM$1-W3+X3);0);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(Z3-Y3>=0;Z3-Y3;$BM$1-Y3+Z3);0);
 |  |  |  |  |  |  |  |  |  |  | [NAME]);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(AD3-AC3>=0;AD3-AC3;$BM$1-AC3+AD3);0);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(AF3-AE3>=0;AF3-AE3;$BM$1-AE3+AF3);0);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(AH3-AG3>=0;AH3-AG3;$BM$1-AG3+AH3);0);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(AJ3-AI3>=0;AJ3-AI3;$BM$1-AI3+AJ3);0);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(AL3-AK3>=0;AL3-AK3;$BM$1-AK3+AL3);0);
 |  |  |  |  |  |  |  |  |  |  | [NAME]);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(AP3-AO3>=0;AP3-AO3;$BM$1-AO3+AP3);0);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(AR3-AQ3>=0;AR3-AQ3;$BM$1-AQ3+AR3);0);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(AT3-AS3>=0;AT3-AS3;$BM$1-AS3+AT3);0);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(AV3-AU3>=0;AV3-AU3;$BM$1-AU3+AV3);0);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(AX3-AW3>=0;AX3-AW3;$BM$1-AW3+AX3);0);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(AZ3-AY3>=0;AZ3-AY3;$BM$1-AY3+AZ3);0);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(BB3-BA3>=0;BB3-BA3;$BM$1-BA3+BB3);0);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(BD3-BC3>=0;BD3-BC3;$BM$1-BC3+BD3);0);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(BF3-BE3>=0;BF3-BE3;$BM$1-BE3+BF3);0);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(BH3-BG3>=0;BH3-BG3;$BM$1-BG3+BH3);0);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(BJ3-BI3>=0;BJ3-BI3;$BM$1-BI3+BJ3);0);
 |  |  |  |  |  |  |  |  |  |  | IFERROR(IF(BL3-BK3>=0;BL3-BK3;$BM$1-BK3+BL3);0)
Spreadsheet: 3ae167db-66db-41fc-8c1d-e8aede8f86be
Sheet: Sheet1

Development & Renewal | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Skillsmatch
Access to service - Composition of users of Skillsmatch (the Council's job brokerage service) - Source: Skillsmatch client files Jan 2012 - Dec 2012
Age | Under 51 | Over 50 | All
Number of service users | 1794 | 113 | 1907
Composition rates | 0.940744625065548 | 0.05925537493445202 | 1
Sex | Male | Female | All
Number of service users | 1127 | 780 | 1907
Composition rates | 0.5909805977975878 | 0.4090194022024122 | 1
Race | White | Non-White | All
Number of service users | 475 | 1432 | 1907
Composition rates | 0.2490823282642895 | 0.7509176717357106 | 1
Disability | Yes | No | All
Number of service users | 91 | 1816 | 1907
Composition rates | 0.04771893025694809 | 0.9522810697430519 | 1
Satisfaction - Composition of clients who answered very satisfied or satisfied to 'Overall, how satisfied or dissatisfied were you with the services you received from us?' - Source: Skillsmatch satisfaction survey conducted Jan 12 - Dec 12 (193 Surveys Conducted)
Age | 16-24 | 25-40 | 41-49 | 50+ | Declined | All
Number of respondents | 92 | 52 | 12 | <10 | 0 | 163
Composition rates | 0.56 | 0.32 | 0.07 | 0.04 | 0 | 1
Race | White | Black | Mixed/Dual Heritage | Asian | Other | Declined | All
Number of respondents | 33 | 18 | <10 | 108 | <10 | 0 | 163
Composition rates | 0.2 | 0.11 | 0.02 | 0.66 | 0.01 | 0 | 1
Disability | Yes | No | Declined | All
Number of respondents | 8 | 155 | 0 | 163
Composition rates | 0.05 | 0.95 | 0
Religion or Belief | Buddhist | Christian | Hindu | Jewish | Muslim | No Religion | Sikh | Declined | All
Number of respondents | 0 | 27 | 0 | 0 | 116 | 11 | 0 | <10 | 163
Composition rates | 0 | 0.17 | 0 | 0 | 0.71 | 0.07 | 0 | 0.05
Performance Information - Composition of clients placed into work through the Skillsmatch job brokerage services - Source: Skillsmatch client files Jan to Dec 2012
Age | 16-18 | 19-24 | 25-40 | 41-49 | 50+ | Not Known | All
Number of service users | 61 | 287 | 304 | 71 | 70 | 0 | 793
Composition rates | 0.07692307692307693 | 0.3619167717528373 | 0.3833543505674653 | 0.08953341740226986 | 0.08827238335435057 | 0 | 1
Race | White | Black | Mixed/Dual Heritage | Asian | Other | Not Known | All
Number of service users | 159 | 103 | 36 | 456 | 13 | 26 | 793
Composition rates | 0.2005044136191677 | 0.1298865069356873 | 0.04539722572509458 | 0.575031525851198 | 0.01639344262295082 | 0.03278688524590164 | 1
Sex | Male | Female | All
Number of service users | 478 | 315 | 793
Composition rates | 0.6027742749054225 | 0.3972257250945775 | 1
Disability | Yes | No | All
Number of service users | 70 | 723 | 793
Composition rates | 0.08827238335435057 | 0.9117276166456494 | 1
Tower Hamlets Homes
Tower Hamlets Homes, the organisation that manages the Council's housing stock, has also published a range of equalities information. These can be viewed here: http://www.towerhamletshomes.org.uk/top_level/about_us/diversity/all_about_you/equality_information.aspx
Spreadsheet: 731570d1620414795-help-formula-to-find-a-match-for-cell-and-return-value-of-the-title-of-that-column-league-2
Sheet: BCC

S.N. | Particulars | Bought Units | Unit or BCC Price | Bought/ Sold Price ($US) | Bought/ Sold Price (BTC) | Token Unit Price During Txn | Activity  Date | Received Date | Fee  ($US) | Fee (%) | Total Price ($US) | Estimated  Price ($US) | Status | Notes
1 | [NAME] 1 | 0.75855064 | 0.18599998 |  | -0.14144313 | 8180 | 2017-11-23 00:00:00 | 2017-11-23 00:00:00 |  |  |  |  | SOLD
2 | [NAME] 2 | 4.14976941 | 0.19227783 |  | -0.7999034 | 8160 | 2017-11-23 00:00:00 | 2017-11-23 00:00:00 |  |  |  |  | SOLD
3 | [NAME] | -2.45416002 | 0.08415 |  | 0.20600129 | 16845 | 2017-12-11 00:00:00
4 | [NAME] | -2.45416003 | 0.08418022 |  | 0.20607528 | 16845 | 2017-12-11 00:00:00
5 | [NAME] 3 | 0.67753771 | 0.11320009 |  | -0.07688907 | 18910 | 2017-12-19 00:00:00 | 2017-12-19 00:00:00 |  |  |  |  | SOLD
6 | [NAME] 4 | 4.19328507 | 0.24888799 |  | -1.04626747 | 16370 | 2017-12-20 00:00:00 | 2017-12-20 00:00:00
7 | [NAME] CoinBase - Purchase 1 | 0.54170746 | 3175.81 | -1720.36 |  |  | 2017-12-21 00:00:00 | 2017-12-21 00:00:00 | -68.64
8 | [NAME] CoinBase - Purchase 2 | 0.09500016 | 2834.31 | -269.26 |  |  | 2017-12-22 00:00:00 | 2017-12-22 00:00:00 | -10.74
9 | [NAME] 3 | -0.67753771 | 0.17501998 |  | 0.11828619 | 13333 | 2017-12-30 00:00:00
10 | Fees for transferring [NAME] from Bittrex to [NAME] | -0.001 |  |  |  |  | 2018-01-08 00:00:00
11 | Fees for transferring [NAME] from Cryptonomos to Ledger | -0.001 |  |  |  |  | 2018-01-09 00:00:00
12 | Fees for transferring BCH from CoinBase to Bittrex | -2.58e-06 |  |  |  |  | 2018-01-28 00:00:00
13 | [NAME] | -0.63670504 | 0.14714703 |  | 0.09345504 | 11372 | 2018-01-28 00:00:00
14 | Adjustment | 0.00024977 |  |  |  |  | 2018-02-17 00:00:00
15 | [NAME] | -1.1912 | 0.10878499 |  | 0.12926073 | 10000 | 2018-03-07 00:00:00
16 | [NAME] |  | 0.110319 |  |  | 10000 | 2018-03-07 00:00:00
17
18
19
20
21
22
23
24
25
26
 | Next Buy
 | [NAME] in CoinBase | 0
 | [NAME] in Ledger Nano S | 3.00008284
 | [NAME] in Bittrex | 0
 | [NAME] in BitStamp | 0
 | [NAME] in Cryptonomos | 0.000252
 | Total Investment Loss/Profit ($US)
 | Website: https://
 | Contract address:
 | Symbol:
 | Decimals:
 | About/Idea
 | Team Members (reputation, prior projects, LinkedIn, social presence)
 | Website Design
 | White Paper
 | ICO Rating
 | www.icoranker.com
 | www.icobench.com
 | www.tokenmarket.net
 | Marketing
 | Twitter
 | Instagram
 | Facebook
 | CEO Presence in the market
 | Roadmap & timeline
 | When are they hitting the exchanges?
Spreadsheet: 752410d1634744166-make-a-ranking-list-for-my-comic-book-collection-comic-book-ratings-copy
Sheet: Sheet1

My Comic Rating List
 |  |  |  |  |  |  |  |  |  |  | Search
Comic | Characters | Storyline | Impressive Splash page? Y/N | Art Style | Splash page points | AVG | Final Score |  |  |  | Black Cat Annual 2021
Winter Guard #1 | 8 | 5 | Y | 7
Iron man Annual 2021 | 7 | 6 | N | 6
Infinity War | 6 | 9 | Y | 5
[NAME] the Marvel Universe AGAIN | 10 | 4 | Y | 10
[NAME] the Marvel Universe | 9 | 7 | Y | 6
Black Cat Annual 2021 | 9 | 4 | Y | 6
Spreadsheet: 837881d1690474886-summarize-data-from-source-table-with-some-conditions-examples
Sheet: Sheet1

 |  |  | Source Data |  |  |  |  |  |  |  |  | Expected Result
 |  | NO | DATE | GAS TYPE | VHCL | ST.NUMBER | PRICE |  |  | NO | DATE | GAS TYPE | VHCL | ST.NUMBER | PRICE
 |  | 1 | 2023-06-02 00:00:00 | Bio Solar | TRUCK | 44.51308 | 130000 |  |  | 1 | 2023-06-02 00:00:00 | Bio Solar | TRUCK | 44.51308 | 390000
 |  | 2 | 2023-06-02 00:00:00 | Bio Solar | TRUCK | 44.51308 | 260000 |  |  | 2 | 2023-06-02 00:00:00 | Pertalite | PERSONAL | 44.51309 | 130000
 |  | 3 | 2023-06-02 00:00:00 | Pertalite | PERSONAL | 44.51309 | 130000 |  |  | 3 | 2023-06-03 00:00:00 | Bio Solar | TRUCK | 44.51301 | 130000
 |  | 4 | 2023-06-03 00:00:00 | Bio Solar | TRUCK | 44.51301 | 130000 |  |  | 4 | 2023-06-03 00:00:00 | Bio Solar | TRUCK | 44.51309 | 130000
 |  | 5 | 2023-06-03 00:00:00 | Bio Solar | TRUCK | 44.51309 | 130000 |  |  | 5 | 2023-06-05 00:00:00 | Bio Solar | TRUCK | 44.51308 | 130000
 |  | 6 | 2023-06-05 00:00:00 | Bio Solar | TRUCK | 44.51308 | 130000 |  |  | 6 | 2023-06-05 00:00:00 | Bio Solar | TRUCK | 44.51318 | 130000
 |  | 7 | 2023-06-05 00:00:00 | Bio Solar | TRUCK | 44.51318 | 130000 |  |  | 7 | 2023-06-06 00:00:00 | Bio Solar | TRUCK | 44.51303 | 130000
 |  | 8 | 2023-06-06 00:00:00 | Bio Solar | TRUCK | 44.51303 | 130000 |  |  | 8 | 2023-06-06 00:00:00 | Pertamax | TRUCK | 44.51308 | 130000
 |  | 9 | 2023-06-06 00:00:00 | Pertamax | TRUCK | 44.51308 | 130000 |  |  | 9 | 2023-06-06 00:00:00 | Pertamax | PERSONAL | 44.51301 | 250000
 |  | 10 | 2023-06-06 00:00:00 | Pertamax | PERSONAL | 44.51301 | 250000 |  |  | 10 | 2023-06-07 00:00:00 | Bio Solar | Truk | 44.51317 | 130000
 |  | 11 | 2023-06-07 00:00:00 | Bio Solar | Truk | 44.51317 | 130000
 |  |  |  |  |  |  |  |  |  | Index | DATE | GAS TYPE | VHCL | ST.NUMBER | Total
 |  |  |  |  |  |  |  |  |  | 1 | 2023-06-02 00:00:00 | Bio Solar | TRUCK | 44.51308 | 390000
 |  |  |  |  |  |  |  |  |  | 2 | 2023-06-02 00:00:00 | Pertalite | PERSONAL | 44.51309 | 130000
 |  |  |  |  |  |  |  |  |  | 3 | 2023-06-03 00:00:00 | Bio Solar | TRUCK | 44.51301 | 130000
 |  |  |  |  |  |  |  |  |  | 4 | 2023-06-03 00:00:00 | Bio Solar | TRUCK | 44.51309 | 130000
 |  |  |  |  |  |  |  |  |  | 5 | 2023-06-05 00:00:00 | Bio Solar | TRUCK | 44.51308 | 130000
 |  |  |  |  |  |  |  |  |  | 6 | 2023-06-05 00:00:00 | Bio Solar | TRUCK | 44.51318 | 130000
 |  |  |  |  |  |  |  |  |  | 7 | 2023-06-06 00:00:00 | Bio Solar | TRUCK | 44.51303 | 130000
 |  |  |  |  |  |  |  |  |  | 8 | 2023-06-06 00:00:00 | Pertamax | TRUCK | 44.51308 | 130000
 |  |  |  |  |  |  |  |  |  | 9 | 2023-06-06 00:00:00 | Pertamax | PERSONAL | 44.51301 | 250000
 |  |  |  |  |  |  |  |  |  | 10 | 2023-06-07 00:00:00 | Bio Solar | Truk | 44.51317 | 130000
Spreadsheet: 700424d1603192593-dynamic-table_array-value-for-vlookup-function-funding-rate-data-exemple
Sheet: ETHUSDT

Date | Predicted Funding Rate | Funding Rate
2020-10-18 18:00:00 | -0.00025 | -0.00025
2020-10-18 10:00:00 | -0.00005 | -0.00005
2020-10-18 02:00:00 | 0.00014 | 0.00014
2020-10-17 18:00:00 | -0.00015 | -0.00015
2020-10-17 10:00:00 | -0.00017 | -0.00017
2020-10-17 02:00:00 | -0.00044 | -0.00044
2020-10-16 18:00:00 | 0.00001 | 0.00001
2020-10-16 10:00:00 | 0.00012 | 0.00012
2020-10-16 02:00:00 | -0.00024 | -0.00024
2020-10-15 18:00:00 | 0.00019 | 0.00019
2020-10-15 10:00:00 | -0.00022 | -0.00022
2020-10-15 02:00:00 | 0.00008 | 0.00008
2020-10-14 18:00:00 | -0.00012 | -0.00012
2020-10-14 10:00:00 | -0.00009 | -0.00009
2020-10-14 02:00:00 | -0.00011 | -0.00011
2020-10-13 18:00:00 | -0.00001 | -0.00001
2020-10-13 10:00:00 | 0.00006 | 0.00006
2020-10-13 02:00:00 | -0.00013 | -0.00013
2020-10-12 18:00:00 | 0.00000 | 0.00000
2020-10-12 10:00:00 | 0.00001 | 0.00001
2020-10-12 02:00:00 | -0.00006 | -0.00006
2020-10-11 18:00:00 | 0.00005 | 0.00005
2020-10-11 10:00:00 | -0.00003 | -0.00003
2020-10-11 02:00:00 | 0.00020 | 0.00020
2020-10-10 18:00:00 | 0.00028 | 0.00028
2020-10-10 10:00:00 | 0.00007 | 0.00007
2020-10-10 02:00:00 | 0.00014 | 0.00014
2020-10-09 18:00:00 | 0.00006 | 0.00006
2020-10-09 10:00:00 | 0.00008 | 0.00008
2020-10-09 02:00:00 | 0.00008 | 0.00008
2020-10-08 18:00:00 | -0.00006 | -0.00006
2020-10-08 10:00:00 | 0.00028 | 0.00028
2020-10-08 02:00:00 | -0.00012 | -0.00012
2020-10-07 18:00:00 | -0.00015 | -0.00015
2020-10-07 10:00:00 | -0.00001 | -0.00001
2020-10-07 02:00:00 | -0.00009 | -0.00009
2020-10-06 18:00:00 | -0.00001 | -0.00001
2020-10-06 10:00:00 | -0.00012 | -0.00012
2020-10-06 02:00:00 | -0.00022 | -0.00022
2020-10-05 18:00:00 | 0.00002 | 0.00002
2020-10-05 10:00:00 | 0.00004 | 0.00004
2020-10-05 02:00:00 | -0.00012 | -0.00012
2020-10-04 18:00:00 | 0.00010 | 0.00010
Spreadsheet: 2710d8c6-ef9b-4557-b60d-94506987a1cb
Sheet: Carbon Footprint Analysis

Author: | [NAME] |  |  | NOTE:
Last Revision: | 2011-05-31 00:00:00
Static CO2 Emissions:
Material | CO2 ([NAME] material) | [NAME] | [NAME]
Total |  | [NAME]
Ongoing CO2 Cmissions:
 | 0 | kg(CO2)/year
Abated CO2 Emissions:
 |  | kg(CO2)/year
Total [NAME]:
 | [NAME])
 | kg(CO2)/year
Spreadsheet: a2299dc5-cc06-486a-ab69-bfdcf66c1cb4
Sheet: Sheet1

Repeat length | Start position | Match direction | Repeat length.1 | Start position.1 | E-value
1535 | 45070 | P | 1174 | 96196 | 0
236 | 50135 | F | 236 | 104843 | 8.53e-130
137 | 124339 | P | 137 | 175911 | 1.99e-70
128 | 13019 | F | 128 | 64008 | 4.87e-65
134 | 85318 | P | 134 | 120516 | 3.28e-64
129 | 82501 | P | 129 | 222228 | 2.36e-63
110 | 13037 | F | 110 | 64026 | 8.71e-57
104 | 82526 | P | 104 | 222228 | 3.57e-53
113 | 92268 | F | 113 | 199599 | 8.61e-52
89 | 107193 | F | 89 | 221998 | 1.18e-37
80 | 76738 | F | 80 | 221186 | 2.41e-36
79 | 92302 | F | 79 | 199633 | 1.11e-33
63 | 71140 | F | 63 | 88350 | 1.73e-28
62 | 25586 | P | 62 | 162923 | 6.9e-28
62 | 54713 | F | 62 | 214604 | 6.9e-28
62 | 119173 | P | 62 | 198625 | 6.9e-28
69 | 150140 | F | 69 | 191090 | 5.96e-26
57 | 34898 | F | 57 | 223562 | 7.07e-25
65 | 115922 | P | 65 | 219551 | 1.27e-23
63 | 39865 | F | 63 | 160103 | 1.85e-22
52 | 125889 | P | 52 | 173932 | 7.24e-22
53 | 81634 | P | 53 | 172361 | 2.88e-20
51 | 48719 | F | 51 | 80393 | 4.43e-19
54 | 107228 | F | 54 | 222033 | 5.83e-19
50 | 77888 | F | 50 | 120636 | 1.28e-16
50 | 106264 | F | 50 | 119017 | 1.28e-16
50 | 150160 | F | 50 | 191110 | 1.28e-16
50 | 124431 | P | 50 | 175906 | 6.13e-15
50 | 131626 | P | 50 | 163414 | 6.13e-15
Spreadsheet: 644876d1570792239-freight-cost-calculation-based-on-weight-and-distance-sample-freight-analysis-1-
Sheet: carrying cost

 |  | 0 | 56 | 103 | 206 | 601
 | [NAME] | 55 | 102 | 205 | 600 | 100000
0 | 100 | 1.97 | 1.56 | 1.37 | 1.22 | Call for rate
101 | 450 | 2.15 | 1.72 | 1.49 | 1.32 | Call for rate
451 | 950 | 2.75 | 2.38 | 2.18 | 2.09 | Call for rate
951 | 1500 | 3.29 | 2.87 | 2.58 | 2.49 | Call for rate
1501 | 2000 | 3.8 | 3.31 | 3.01 | 2.85 | Call for rate
2001 | 2550 | 3.95 | 3.35 | 3.05 | 3.01 | Call for rate
2551 | 1000000 | 4.36 | 3.8 | 3.45 | 3.35 | Call for rate
Spreadsheet: 684347d1593320454-change-values-in-other-set-of-cells-based-on-cell-value-in-principal-cell-fuwad98
Sheet: Sheet1

Friend | Date | Money lent
A | 2020-01-01 00:00:00 | 1
B | 2020-01-02 00:00:00 | 20
A | 2020-01-03 00:00:00 | 2
A | 2020-01-04 00:00:00 | 3
B | 2020-01-05 00:00:00 | 30
A | 2020-01-06 00:00:00 | 4
A | 2020-01-07 00:00:00 | 5
 | Balance
Spreadsheet: 97778d1296856947-conditional-adding-book1
Sheet: Sheet1

a | b | c |  |  | Values
apple | 0 | 1 |  | Row Labels | Sum of b | Sum of c
apple | 0 | 0 |  | apple | 0 | 1
apple | 0 | 0 |  | banana | 2 | 1
banana | 1 | 0 |  | carrot | 0 | 0
banana | 0 | 0 |  | Grand Total | 2 | 2
banana | 1 | 1
carrot | 0 | 0
carrot | 0 | 0
Spreadsheet: 802676d1666967203-copy-information-from-multiple-tables-to-a-sheet-bwp-invoices
Sheet: Table 13

 |  |  |  |  |  |  |  |  |  |  |  |  | Date |  |  |  | Invoice #
 |  |  |  |  |  |  |  |  |  |  |  |  | 2022-10-20 00:00:00 |  |  |  | 80027
 | [NAME] |  |  |  |  |  |  |  |  | Ship To
 | BW Papersystems Company P.O. Box 4717 [EMAIL] Timonium, MD 21094-4717 |  |  |  |  |  |  |  |  | BW Papersystems Co. 10615 Beaver Dam Road Hunt Valley, MD 21030-2204
P.O. Number |  |  | Terms |  | Rep |  | Ship |  | Via |  | F.O.B. |  |  | Project
PN45440 |  |  | 2%10NET45 |  | HOUSE |  | 2022-10-20 00:00:00 |  | UPS |  | Richmond, VA
Quantity |  | Item Code |  | Description |  |  |  |  |  |  |  | Price Each |  |  |  | Amount
1 1 |  | 331906 60MATERIAL |  | SPRT, GEAR BOX, A/R DRV 3/4 HP Material Surcharge |  |  |  |  |  |  |  | 329.00 60.00 |  |  |  | 329.00 60.00
 |  |  |  |  |  |  |  |  |  |  |  | Total                              $389.00
Payments/Credits                 $0.00 |  |  |  |  |  |  |  | Balance Due |  |  |  |  |  |  | 389
Spreadsheet: 754825d1636536151-problem-with-average-ifs-0-book3
Sheet: Sheet1

Year | week | num | name of cat | 1 | 2 | 3 | 4 | 5 | 6 | total | average per name of cat | wanted column(to ignore 0)
2020 | 28 | 10 | a | 2327.73174732249 | 934.9032496724038 | 0 | 694.7606981174207 | 0 | 0 | 3957.395695112315 |  |  | AVERAGEIFS(E:E,D:D,D2,E2:E1099,">0")-->not working
2020 | 28 | 11 | b | 0 | 8.931428571428572 | 0 | 115.6177777777778 | 248.4177746307729 | 0 | 372.9669809799792
2020 | 28 | 12 | a | 0 | 0 | 0 | 0 | 40.27782635320182 | 0 | 40.27782635320182
2020 | 28 | 13 | b | 76.42808883553997 | 380.953125 | 827.1147046132926 | 0 | 0 | 0 | 1284.495918448833
2020 | 28 | 14 | a | 365.1203430716193 | 72.75373606305266 | 0 | 101.4267155216239 | 21.37705038878296 | 24.27460648148148 | 584.9524515265604
2020 | 28 | 20 | b | 0 | 601.5403489364014 | 3.472222222222222 | 0 | 0 | 0 | 605.0125711586236
2020 | 28 | 21 | a | 0 | 124.3357350496254 | 1.25 | 0 | 0 | 0 | 125.5857350496254
2020 | 28 | 22 | b | 1.36 | 542.7661646767933 | 1533.240147420875 | 0 | 0 | 0 | 2077.366312097668
2020 | 28 | 23 | a | 0 | 212.586200535137 | 57.49633777477933 | 0 | 0 | 0 | 270.0825383099163
2020 | 28 | 24 | b | 0 | 0.03475639329805996 | 0 | 0 | 0 | 0 | 0.03475639329805996
Spreadsheet: 334e6e6a-8550-4ecf-a787-ff4180ffa762
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5022 | 30121 | Francois | Emslie | RSA | 0 | 00:22:53 | 00:00:00 | 01:08:35 | 00:00:00 | 00:36:00 | 1 | 02:07:29
5022 | 30839 | [NAME] | Kruger | RSA | 0 | 00:26:01 | 00:00:00 | 01:14:53 | 00:00:00 | 00:40:03 | 2 | 02:20:57
5022 | 30800 | Martin | Birtwhistle | RSA | 0 | 00:27:21 | 00:00:00 | 01:16:11 | 00:00:00 | 00:38:01 | 3 | 02:21:33
5022 | 30434 | [NAME] | Searle | RSA | 0 | 00:26:14 | 00:00:00 | 01:21:58 | 00:00:00 | 00:44:42 | 4 | 02:32:55
Spreadsheet: 90762d1290516745-staggering-benchmark-lines-in-a-graph-754256
Sheet: Sheet1

Fig 3. By Duration and NVQ Level (ordered by Low to High on 2009/10 SR)
By Duration | By Level | 2007/08 |  | 2008/09 |  | 2009/10 |  | 08/09 Nat. [NAME] | 08/09 25th Percentile | 08/09 50th Percentile | 08/09 75th Percentile
 |  | Number of Starts | Success Rates (%) | Number of Starts | Success Rates (%) | Number of Starts | Success Rates (%) | Success Rates (%) | Success Rates (%) | Success Rates (%) | Success Rates (%)
Long | Level 2 | 1688 | 0.6546208530805687 | 1859 | 0.7407208176438945 | 1640 | 0.7292682926829268 | 0.75 | 0.72 | 0.74 | 0.78
 | Level 3 | 862 | 0.6693735498839907 | 1098 | 0.7076502732240437 | 1374 | 0.7416302765647744 | 0.76 | 0.72 | 0.75 | 0.78
 | Level 1 | 3700 | 0.6940540540540541 | 4137 | 0.7590041092579164 | 2773 | 0.7417958889289578 | 0.778 | 0.74 | 0.78 | 0.8
 | Level H | 93 | 0.7311827956989247 | 46 | 0.9130434782608695 | 43 | 0.7906976744186046 | 0.627 | 0.54 | 0.65 | 0.76
 | Level X | 210 | 0.9523809523809523 | 196 | 0.9387755102040817 | 213 | 0.9577464788732394 | 0.888 | 0 | 0.87 | 0.95
 | 2007/08 | 2008/09 | 2009/10 | 08/09 Nat. [NAME] | 08/09 75th Percentile | 08/09 75th Percentile | 08/09 75th Percentile | 08/09 75th Percentile
Level 2 | 0.6546208530805687 | 0.7407208176438945 | 0.7292682926829268 | 0.75 | 0.78 | 0.78 | 0.78 | 0.78
Level 3 | 0.6693735498839907 | 0.7076502732240437 | 0.7416302765647744 | 0.76 | 0.78 | 0.78 | 0.78 | 0.78
Level 1 | 0.6940540540540541 | 0.7590041092579164 | 0.7417958889289578 | 0.778 | 0.8 | 0.8 | 0.8 | 0.8
Level H | 0.7311827956989247 | 0.9130434782608695 | 0.7906976744186046 | 0.627 | 0.76 | 0.76 | 0.76 | 0.76
Level X | 0.9523809523809523 | 0.9387755102040817 | 0.9577464788732394 | 0.888 | 0.95 | 0.95 | 0.95 | 0.95
Spreadsheet: 741096d1626812453-count-filled-name-schedule-job-count-look-up
Sheet: Count-Filled

Name | Schedule | Job Title | Open | Filled
Night | Sun-Thu, 9:30pm-6:00pm | Facility Maintenance
Weekend | Fri-Sun, 7am-7:30pm | Forklift Operator
Night | Sun-Thu, 9:30pm-6:00pm | Forklift Operator (SHP)
Day | Mon-Thu, 7am-5:30pm | Forklift Operator (WAR)
Night | Sun-Thu, 9:30pm-6:00pm | Forklift Operator (WAR)
Day-A | Mon-Fri, 7am-3:30pm | Inventory Control Cycle Counter
TBD | TBD | Inventory Control Cycle Counter
Day | Mon-Thu, 7am-5:30pm | [NAME]
Day-A | Mon-Fri, 7am-3:30pm | Line Coordinator
Night | Sun-Thu, 9:30pm-6:00pm | Materials Specialist
Weekend | Fri-Sun, 7am-7:30pm | Materials Specialist
Night | Sun-Thu, 9:30pm-6:00pm | Pack and Ship Associate
Weekend | Fri-Sun, 7am-7:30pm | Pack and Ship Associate | 6 | 1
Night | Sun-Thu, 9:30pm-6:00pm | [NAME]
Night | Sun-Thu, 9:30pm-6:00pm | Production [NAME] | 1 | 1
Night | Sun-Thu, 9:30pm-6:00pm | Production Scheduling
Weekend | Fri-Sun, 7am-7:30pm | Production Scheduling | 0 | 1
Day | Mon-Thu, 7am-5:30pm | QA Inspector (Prd)
Day-B | Mon-Fri, 11am-7:30pm | QA Inspector (Rec)
Night | Sun-Thu, 9:30pm-6:00pm | QA Inspector (VMI)
Weekend | Fri-Sun, 7am-7:30pm | QA Inspector (VMI)
Night | Sun-Thu, 9:30pm-6:00pm | Senior QA Team Leader
Day | Mon-Thu, 7am-5:30pm | Senior Team Leader
Weekend | Fri-Sun, 7am-7:30pm | Senior Team Leader
Mid | Mon-Fri, 2pm-10:30pm | Stocker
Night | Sun-Thu, 9:30pm-6:00pm | Stocker
Weekend | Fri-Sun, 7am-7:30pm | Stocker
Night | Sun-Thu, 9:30pm-6:00pm | Supervisor II
Weekend | Fri-Sun, 7am-7:30pm | Supervisor II
Mid | Mon-Fri, 2pm-10:30pm | Team Lead
Night | Sun-Thu, 9:30pm-6:00pm | Team Lead
Weekend | Fri-Sun, 7am-7:30pm | Team Lead | 1 | 1
Day | Mon-Thu, 7am-5:30pm | VMI Stocker II
Mid | Mon-Fri, 2pm-10:30pm | VMI Stocker II
Night | Sun-Thu, 9:30pm-6:00pm | [NAME]
Weekend | Fri-Sun, 7am-7:30pm | [NAME]
Spreadsheet: 45210d1243978732-multiple-if-or-functions-nested-mround
Sheet: Sheet1

Part number | Description | Price Category | Team | Group | Family | Product | Type | USD | CAD | EUR | GBP | CNY |  | Conversion Factors
123507 | Example part description | Parts |  |  |  |  |  | 135 |  |  | 90.55000000000001 |  |  |  | CAD |  | EUR |  | GBP |  | CNY
 |  | Parts |  |  |  |  |  | 15 |  |  | 10.05 |  |  | PARTS |  |  |  |  | 0.524 | 1.28
 |  | SYSTEMS |  |  |  |  |  | 125 |  |  | 0 |  |  | PART KITS |  |  |  |  | 0.524 | 1.28
 |  | PART KITS |  |  |  |  |  | 95 |  |  | 63.7 |  |  | SYSTEMS
 |  | PART KITS |  |  |  |  |  | 161 |  |  | 108 |  |  | SYSTEM KIT
 |  | PART KITS |  |  |  |  |  | 162 |  |  | 109
Spreadsheet: 742951d1628144644-how-many-pieces-in-a-bar-frames
Sheet: Sheet1

 |  | % Wastage
160 | 18 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
12 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | Wastage (inches)
160 | 18 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
12 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12