tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 491010d1480258429-creating-a-pivot-table-participants-by-month-when-i-only-have-the-start-and-end-dates-sample-01
Sheet: Sheet1

ID | Course start date | Course end date | Course outcome | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total Months
1 | 2012-08-28 00:00:00 | 2012-10-02 00:00:00 | refused
2 | 2012-09-04 00:00:00 | 2012-10-02 00:00:00 | finished
3 | 2012-09-30 00:00:00 | 2012-10-02 00:00:00 | finished
4 | 2012-10-02 00:00:00 | 2012-10-02 00:00:00 | refused
5 | 2012-10-02 00:00:00 | 2012-10-02 00:00:00 | finished
6 | 2012-10-02 00:00:00 | 2012-10-02 00:00:00 | finsihed
7 | 2012-10-02 00:00:00 | 2012-10-02 00:00:00 | started but didn't finish
8 | 2012-08-21 00:00:00 | 2012-10-03 00:00:00 | finsihed
9 | 2012-08-26 00:00:00 | 2012-10-03 00:00:00 | finsihed
10 | 2012-09-04 00:00:00 | 2012-10-03 00:00:00 | started but didn't finish
11 | 2012-09-04 00:00:00 | 2012-10-03 00:00:00 | finished
12 | 2012-09-09 00:00:00 | 2012-10-03 00:00:00 | finished
13 | 2012-09-09 00:00:00 | 2012-10-03 00:00:00 | started but didn't finish
14 | 2013-01-13 00:00:00 | 2013-01-16 00:00:00 | refused
15 | 2013-01-13 00:00:00 | 2013-01-16 00:00:00 | refused
16 | 2013-01-13 00:00:00 | 2013-01-16 00:00:00 | finished
17 | 2012-06-27 00:00:00 | 2013-01-17 00:00:00 | started but didn't finish
18 | 2012-07-15 00:00:00 | 2013-01-17 00:00:00 | finished
19 | 2012-09-30 00:00:00 | 2013-01-17 00:00:00 | started but didn't finish
Spreadsheet: 86587d1286532193-random-numbers-to-equal-a-total-teams
Sheet: Sheet1

players | star rating |  |  | 10 per group |  |  |  | 5 per group
player 1 | 5
player 2 | 2 |  |  | Team | Player | Star rating |  | Team | Player | Star rating
player 3 | 3
player 4 | 4
player 5 | 2
player 6 | 4
player 7 | 5
player 8 | 3
player 9 | 2
player 10 | 4 |  |  |  |  |  |  |  | players 5 | total rating
player 11 | 3 |  |  |  |  |  |  |  |  | 20
player 12 | 2
player 13 | 5
player 14 | 5 |  |  |  | players 10 | total rating
player 15 | 5 |  |  |  |  | 38
player 16 | 4
player 17 | 3
player 18 | 4
player 19 | 3
player 20 | 4
player 21 | 5
player 22 | 5
player 23 | 4
player 24 | 4
player 25 | 3
player 26 | 3
player 27 | 4
player 28 | 4
player 29 | 4
player 30 | 5
player 31 | 3
player 32 | 5
player 33 | 3
player 34 | 4
player 35 | 2
player 36 | 2
player 37 | 2
player 38 | 2
player 39 | 4
player 40 | 4
player 41 | 3
player 42 | 5
player 43 | 4
player 44 | 2
player 45 | 3
player 46 | 2
player 47 | 4
player 48 | 3
player 49 | 5
player 50 | 4
player 51 | 3
player 52 | 4
player 53 | 5
player 54 | 5
player 55 | 5
player 56 | 2
player 57 | 2
player 58 | 3
player 59 | 4
player 60 | 2
player 61 | 1
player 62 | 4
player 63 | 2
player 64 | 3
player 65 | 5
player 66 | 5
player 67 | 3
player 68 | 4
player 69 | 2
player 70 | 4
player 71 | 5
player 72 | 5
player 73 | 3
player 74 | 5
player 75 | 3
player 76 | 1
player 77 | 2
player 78 | 4
player 79 | 3
player 80 | 3
player 81 | 3
player 82 | 4
player 83 | 3
player 84 | 2
player 85 | 4
player 86 | 4
player 87 | 5
player 88 | 4
player 89 | 5
player 90 | 4
player 91 | 4
player 92 | 3
player 93 | 2
player 94 | 3
player 95 | 3
player 96 | 2
player 97 | 4
player 98 | 3
player 99 | 2
player 100 | 4
player 101 | 4
player 102 | 4
player 103 | 5
player 104 | 4
player 105 | 2
player 106 | 5
player 107 | 4
player 108 | 5
player 109 | 3
player 110 | 1
player 111 | 1
player 112 | 1
player 113 | 3
player 114 | 2
player 115 | 4
player 116 | 5
player 117 | 3
player 118 | 4
player 119 | 2
player 120 | 2
player 121 | 3
player 122 | 4
player 123 | 2
player 124 | 2
player 125 | 1
player 126 | 5
player 127 | 3
player 128 | 4
player 129 | 2
player 130 | 5
player 131 | 5
player 132 | 4
player 133 | 5
player 134 | 2
player 135 | 1
player 136 | 1
player 137 | 3
player 138 | 1
player 139 | 3
player 140 | 4
player 141 | 3
player 142 | 1
player 143 | 5
player 144 | 5
player 145 | 4
player 146 | 4
player 147 | 5
player 148 | 1
Spreadsheet: 06b567a9-2273-4e6b-aee5-2e64402013b2
Sheet: Sheet1

Serials Expenditures Summary | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | 1995/96 | 1996/97 | 1997/98 | 1998/99 | 1999/00 | 2000/01 | 2001/02 | 2002/03 | 2003/04 | 2004/05 | 2005/06
Total serials expenditures (Kingston only) | 1308829 | 1422136 | 1296426 | 1325766.56 | 1368680.63 | 1616304.74 | 1557733.22 | 1775296.63 | 1806542.7 | 2098057 | 2279503.76
Total serials purchased (includes online) |  | 9028 | 7601 | 5396 |  |  |  |  | 6872 |  | 7096
Total serials purchased (online-only) |  |  |  |  |  |  |  |  |  |  | 4796
Online-only as percentage of total |  |  |  |  |  |  |  |  |  |  | 0.6758737316798196
Total unique titles available online (includes aggregators) |  |  |  |  |  |  |  |  |  |  | 19474
Total serials budget (all libraries) | 1490512 | 1612120 | 1470633 | 1537964.4 | 1666000 | 1799917 | 1801694 | 1999567 | 1994861.8 | 2290000 | 2556000
Total materials budget (all libraries) | 1759394 | 2008986 | 1916799 | 1947539.08 | 2048225 | 2200277 | 2202054 | 2379852 | 2347634.9 | 2622697 | 2922697
Serials as % of total materials expenditures | 0.8471735154263343 | 0.8024545716097573 | 0.7672338101178058 | 0.7896962971341248 | 0.813387201113159 | 0.8180410920988584 | 0.8181879281797813 | 0.8402064498128455 | 0.8497325542400141 | 0.8731469933431121 | 0.8745347191309945
U.S. Periodical Price Index | 271.9 | 301.3 | 331.1 | 365.2 | 403.2 | 439.4 | 475.8 | 513.6 | 552.3 | 597.5 | 636.3
CPI-U, 1982/84=100 | 152.4 | 156.9 | 160.5 | 163 | 166.6 | 172.2 | 177.1 | 179.9 | 184 | 188.9 | 195.3
* Total materials budget is for all libraries (Kingston, [NAME], CCE). Equals sum of money spent on monographs + serials.
Sources:
The Bowker Annual Library and Book Trade Almanac, various years, for U.S. Periodical Price Index
Bureau of Labor Statistics, http://data.bls.gov/cgi-bin/surveymost
University of Rhode Island Library
Compiled:
[NAME]
2006-10-31 00:00:00
Spreadsheet: 771790d1646849033-excel-formula-to-remove-everything-in-a-column-followed-by-a-single-forward-slash-test1
Sheet: Sheet1

SOURCE LINKS | RESULT ([NAME]) | DESIRED RESULT ( DONE MANUALLY)
https://in.linkedin.com/in/a-r-sarkar-8939361b |  | https://in.linkedin.com/
https://in.linkedin.com/in/aakashsuri |  | https://in.linkedin.com/
[NAME] |  | https://in.linkedin.com/
https://in.linkedin.com/in/abhra-d-57444b202%3Ftrk%3Dpublic_profile_samename-profile |  | https://in.linkedin.com/
https://in.linkedin.com/in/addy-bisht |  | https://in.linkedin.com/
https://www.facebook.com/pages/category/Artist/Kinimo-108653264378096/ |  | https://www.facebook.com/
https://www.facebook.com/iMakeAnimations/ |  | https://www.facebook.com/
https://www.facebook.com/dcreationsofficial/ |  | https://www.facebook.com/
https://www.facebook.com/UofWA/reviews/ |  | https://www.facebook.com/
https://www.facebook.com/biz/internet-marketing-service/%3Fplace_id%3D108424279189115 |  | https://www.facebook.com/
https://twitter.com/rebeltaxi |  | https://twitter.com/
https://twitter.com/rjsuspect |  | https://twitter.com/
https://twitter.com/wizardofkitty/with_replies |  | https://twitter.com/
https://twitter.com/itsprobablymars |  | https://twitter.com/
https://twitter.com/nowwacorp |  | https://twitter.com/
https://twitter.com/stellateart |  | https://twitter.com/
https://www.instagram.com/kristiyan.v.petkov/ |  | https://www.instagram.com/
https://www.instagram.com/vfx_sahil/ |  | https://www.instagram.com/
https://www.instagram.com/robin_lights_edits/ |  | https://www.instagram.com/
https://www.instagram.com/sup3r.aep/ |  | https://www.instagram.com/
https://www.instagram.com/Sparta_edits/ |  | https://www.instagram.com/
https://www.instagram.com/hoodgamersworldtv/ |  | https://www.instagram.com/
https://www.instagram.com/kazzuhira_miller/ |  | https://www.instagram.com/
Spreadsheet: 693642d1599065794-nested-if-returns-false-book24-excel-forum-
Sheet: Sheet1

 | TASK NO. | TASK NAME | TASK INTERVAL | INTERDEPENDANCY | 750000
 | LDO | Task 1 (OH) | 750000 | LDR
 | LDR | Task 1a (Replace) | 1500000
Spreadsheet: 684160d1593179875-vlookup-addresses-invoice
Sheet: Invoice

 |  |  |  |  |  |  |  | CDF Services
 |  |  |  |  |  |  |  | 101 High Street
 |  |  |  |  |  |  |  | Crowland
 |  |  |  |  |  |  |  | [NAME]
 | INVOICE |  |  |  |  |  |  | Telephone: [PHONE]
 |  |  |  |  |  |  |  | Email: [EMAIL]
 | Invoice
 |  |  | [NAME] | UNIT COST | QTY/HR RATE |  | AMOUNT
 | INVOICE NUMBER |  | Your item name | 0 | 1
 | 12409 |  | Your item name | 0 | 1
 | DATE OF ISSUE |  | Your item name | 0 | 1
 |  |  | Your item name | 0 | 1
 |  |  | Your item name | 0 | 1
 |  |  | Your item name | 0 | 1
 |  |  | Your item name | 0 | 1
 |  |  | Your item name | 0 | 1
 |  |  |  |  | SUBTOTAL
 |  |  |  |  | DISCOUNT |  | 0
 |  |  |  |  | (VAT RATE) |  | 0
 |  |  |  |  | TAX
 |  |  |  |  | INVOICE TOTAL
 | PAYMENT TERMS
 | Payment should be received within 15 days of the date of the invoice
Bank details:
Bank name: First Bank plc
Account name: CDF Services
Account no: 40408788
Sort code: 29-67-37
Spreadsheet: 786030d1656940764-excel-function-use-to-extract-between-range-data-without-array-formula-04072022-sample-file-for-excel-forum
Sheet: Sheet1

Bth | Bthno | From no. | To No. |  |  | RESULT
GK | 1 | 1 | 1000 |  |  | Nos. | Bth | [NAME]
 | 2 |  |  |  |  | 15712 | JG | 3
 | 3 |  |  |  |  | 1 | GK | 1
 | 4 |  |  |  |  | 8901 | GK | 9
 | 5 |  |  |  |  | 7484 | GK | 8
 | 6 |  |  |  |  | 23948 | BH | 2
 | 7 |  |  |  |  | 21910 | BR | 1
 | 8 |  |  |  |  | 13213 | JG | 1
 | 9 |  |  |  |  | 13212 | GK | 13
 | 10
 | 11
 | 12
 | 13 |  | 13212
JG | 1 | 13213 | 14212
 | 2
 | 3
 | 4
 | 5
 | 6 |  | 19525
BY | 1 | 19526 | 20582
BR | 1 | 20583 | 21910
BH | 1 | 21911 | 22910
 | 2
 | 3
 | 4
 | 5 |  | 27472
GT | 1 | 27473 | 28472
 | 2 |  | 29487
TH | 1 | 29488 | 30487
 | 2 |  | 31445
VS | 1 | 31446 | 32445
 | 2
 | 3
 | 4
 | 5 |  | 36599
PNV | 1 | 36600 | 37305
PN | 1 | 37306 | 37617
PCN | 1 | 37618 | 38617
 | 2 |  | 39960
WA | 1 | 39961 | 41498
MD | 1 | 41499 | 42498
 | 2
 | 3 |  | 44425
ST | 1 | 44426 | 45337
SH | 1 | 45338 | 45592
KD | 1 | 45593 | 46676
Spreadsheet: 743188d1628276412-formulas-to-calculate-bank-loan-payments-with-early-settlement-loan-assessment
Sheet: Sheet1

 | Month | Opening Balance | Principle | Interest | Advance Payment | Closing Balance | Total Payment |  |  | Loan Amount | 300000
2021-09-01 00:00:00 | 1 |  |  |  | 18000 |  |  |  |  | Interest Rate (Annual) | 0.065
2021-10-01 00:00:00 |  |  |  |  | 18000 |  |  |  |  | Tenure (Years) | 1
2021-11-01 00:00:00 |  |  |  |  | 18000 |  |  |  |  | Number of Payments | 12
2021-12-01 00:00:00 |  |  |  |  | 18000 |  |  |  |  | Total Interest | 10667.10105701303
2022-01-01 00:00:00 |  |  |  |  | 78000 |  |  |  |  | Monthly Payment (A/P) | 25888.92508808442
2022-02-01 00:00:00 |  |  |  |  | 2430.71
2022-03-01 00:00:00
2022-04-01 00:00:00
2022-05-01 00:00:00
2022-06-01 00:00:00
2022-07-01 00:00:00
2022-08-01 00:00:00
Spreadsheet: 27e1dbf7-f1c1-411a-b889-7c91ea7ccb53
Sheet: 7c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Basis | 1647744 | 1200895 | 1794066 | 2459983 | 3222141 | 1529734 | 1038278 | 69453 | 12962294
Fixed-Float | 14403792 | 6831567 | 12883430 | 26733943 | 59706073 | 41703053 | 18780551 | 1898069 | 182940478
FRA | 26755579 | 12837377 | 12346082 | 3769197 | 262879 | - | - | - | 55971114
OIS | 11660882 | 6651531 | 6511135 | 6025021 | 1940423 | 293056 | 173101 | 13706 | 33268855
Swaption | 2955643 | 1614251 | 2318326 | 3073632 | 4058215 | 1970899 | 873016 | 12192 | 16876174
OTHER* | 2118375 | 1315200 | 1431458 | 2115530 | 4292318 | 3787579 | 2244195 | 161103 | 17465758
TOTAL
*OTHER variable includes the following products: Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: 87181f74-1c93-4853-8359-953b5b43fcd0
Sheet: Report

Unit | Unit Priority | Objective Name | Strategic Direction | Impact Type | Resource Id | Resource Name | Resource Type | Year 1 Cost | Year 1 Savings | Year 2 Cost | Year 2 Savings | Year 3 Cost | Year 3 Savings | Year 4 Cost | Year 4 Savings
Human Resources | 1 | Change Name to "Diversity and Human Resources" | None | -- Pick One -- | 1.1.r1 | Diversity and Human Resources | OneTime | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Human Resources | 1 | Hire a full-time Risk Manager | None | -- Pick One -- | 2.1.r1 | Risk Manager | OnGoing | 95000 | 0 | 99750 | 0 | 104737.5 | 0 | 0 | 0
Human Resources | 1 | Remodel Human Resources Office Space | None | -- Pick One -- | 3.1.r1 | Remodel HR Office Space | OneTime | 45000 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Human Resources | 1 | Efficient Recruitment and Hiring | None | -- Pick One -- | 4.1.r1 | Recruiment and Hiring Process | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Human Resources | 2 | Human Resources Standard Operating Procedures Manual | None | -- Pick One -- | 5.1.r1 | Procedures Manual and Employee Handbook | OnGoing | 5000 | 0 | 1500 | 3500 | 750 | 4250 | 0 | 0
Human Resources | 1 | Finalize the 2009-2010 District Staffing Plan | None | -- Pick One --
Spreadsheet: 593478d1539169419-extract-data-from-a-table-to-a-list-animals
Sheet: Folha1

 |  |  |  |  |  | Result
dog |  |  | cat |  |  | dog
 |  |  |  |  |  | Cat
 |  |  |  |  |  | rat
 |  |  |  |  |  | bird
 | rat |  |  |  |  | Cat
 |  | bird
 |  |  |  | cat
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 19 Feb 2012

Daily Morning Staff |  |  |  |  | Sunday
 | 07:30-14:30 |  | 2012-02-19 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Ralation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS
[NAME] | 4143 | Aircraft Team Leader | Annual | Annual | EFS | Annual
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME]
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS
[NAME] | 4440 | Attendant | 08:00:00 | 14:00:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: phillip_m_love__30161__9901_OA
Sheet: EAST-CON-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM) / LRC
REGION:  EAST
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 726166d1617091957-create-new-columns-based-on-description-with-corresponding-value-example-file
Sheet: Sheet1

Target | Country | Year | Value |  |  |  | Country | Year |  | 1.2 | 1.3 | 1.4
1.1 | Germany | 2000 | 20 |  |  |  |  | 2000
1.1 | Germany | 2001 | 35 |  |  |  | Germany | 2001
1.2 | Germany | 2000 | 15 |  |  |  | France | 2000
1.2 | Germany | 2001 | 44 |  |  |  | France | 2001
1.3 | Germany | 2000 | 22
1.3 | Germany | 2001 | 11
1.4 | Germany | 2000 | 44
1.4 | Germany | 2001 | 66
1.1 | France | 2000 | 16
1.1 | France | 2001 | 22
1.2 | France | 2000 | 12
1.2 | France | 2001 | 17
1.3 | France | 2000 | 19
1.3 | France | 2001 | 24
1.4 | France | 2000 | 27
1.4 | France | 2001 | 33
Spreadsheet: robin_rodrigue__33276__Kathy
Sheet: Summary

SUMMARY OF CANADA'S TRADING INCOME BY DESK - IN C$
 |  |  |  |  |  |  |  |  |  |  |  | To Dec 6
 |  |  |  |  |  |  |  |  |  |  |  | MTD |  |  |  |  |  |  | To date
 | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 |  | TOTAL |  | Q1 | Q2 | Q3 | Q4 |  | TOTAL
BY BOOK:
TERM: | (Note:  Q1 Orgination has been manually backed out)
[NAME]
BC Term
EOL - Term
Options
CASH
[NAME]
BC Cash
BC Pipe Cash
[NAME]
BC Term - GD
Options - GD
Power
PMA
TOTAL CANADA
BY RISK TYPE: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BY RISK TYPE:
Total Term
Check
Total Cash
Check
TOTAL CANADA
BY AREA/TRADER:
West Term - Lavorato
West Term - Mckay
West Term - Lambie
Options - Disturnal
[NAME]
BC Cash - Clark
Power - Greenizan
TOTAL CANADA
Check
Spreadsheet: 154702d1336519889-advanced-drop-down-lists-data-validation-wills-weights
Sheet: Weights sheet

 |  | Monday |  |  |  |  |  |  | Tuesday |  |  |  |  | Wednesday |  |  |  |  | Thursday |  |  |  |  | Friday |  |  |  |  | Saturday |  |  |  |  | Sunday
 |  | 2012-01-23 00:00:00 |  |  |  |  |  |  | 2012-01-24 00:00:00 |  |  |  |  | 2012-01-25 00:00:00 |  |  |  |  | 2012-01-26 00:00:00 |  |  |  |  | 2012-01-27 00:00:00 |  |  |  |  | 2012-01-28 00:00:00 |  |  |  |  | 2012-01-29 00:00:00
 |  | St | Kg | LB
Weight |  | 9.3.2 | 58.6 | 129.2
Measurements
Bicep |  | 27cm
Chest (nip)
Chest (underpit)
Shoulder (top of)
Shoulders
Forearm |  | 23.6cm
Thigh
Calf
BUTTOcks!
Stomach
BMI |  | 19.1
BMR |  | 1531
Body Fat |  | 9.7
Body water |  | 66.1
Muscle Mass |  | 48
Visceral Fat |  | 1
Food |  | Cals | Carbs | Sugar | Pro | Fat | sats | Fibre
1 | Heinz baked beans
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Total
Calories |  | 0
Carbs |  |  | 0
Sugar |  |  |  | 0
Pro |  |  |  |  | 0
FaT |  |  |  |  |  | 0
Saturated Fat |  |  |  |  |  |  | 0
Fibre |  |  |  |  |  |  |  | 0
Exercise |  | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME]
Chest
Spreadsheet: 684076d1593127424-calculating-hours-worked-over-three-sections-of-the-day-calculating-hours-worked-over-three-sections-of-the-day
Sheet: data entry

 |  |  |  |  |  |  |  |  |  | 06:00:00 | 18:00:00 | 23:59:00
Driver | Employee Number | shift pattern | day | Start Time | Finish Time | Total Hrs Worked | Hrs minus break | Normal Time Hrs | [NAME] | hrs 00:00-06:00 | hrs 06:00-18:00 | hrs 18:00-00:00
[NAME] | 10007274 | OT | Sunday
[NAME] | 10007274 | Days | Monday
[NAME] | 10007274 | Days | Tuesday
[NAME] | 10007274 | Days | Wednesday
[NAME] | 10007274 | Days | Thursday
[NAME] | 10007274 | Days | Friday
[NAME] | 10007274 | OT | Saturday
Spreadsheet: 768471d1644990821-incorrect-conditional-formatting-for-entire-row-condititonal_formatting_highlites_even_when_passed
Sheet: Sheet1

Value | Status
80
85
90
90
90
80
65
70
80
90
70
80
85
80
85
90
90
85
90
80
85
90
90
85
85
90
90
90
90
85
85
85
85
60
90
80
85
90
90
90
90
90
85
90
85
85
85
80
80
85
85
80
85
55
85
90
75
80
85
90
75
80
85
85
85
60
55
85
75
80
90
90
85
75
75
75
90
70
90
85
90
85
60
80
70
85
60
75
70
90
85
55
80
90
55
55
60
80
85
75
40
70
60
70
85
60
0
70
85
35
90
80
90
80
85
85
70
90
65
75
85
60
90
85
90
85
80
90
75
85
90
75
85
75
90
80
90
85
90
70
80
85
85
90
90
85
85
90
85
85
85
90
75
85
70
80
85
90
80
90
80
85
85
80
90
80
90
70
90
90
80
70
90
90
75
85
Spreadsheet: 537300d1504936302-combining-2-rows-into-1-final-invoice-1-
Sheet: page 14

Description of Goods |  |  |  |  | Quantity | Cost | Total
Item # | Color | UPC Code | Country Origin | HS Code
Floral Embellish: 24mm Embossed Handmade Paper x12 w/Buttons |  |  |  |  | 12 | 0.65 | 7.8
FE234D | D) Timeless | 775749197860 | INDIA | 4811.90.0090
Floral Embellish: 24mm Embossed Handmade Paper x12 w/Buttons |  |  |  |  | 12 | 0.65 | 7.8
FE234E | E) [NAME] | 775749197877 | INDIA | 4811.90.0090
Floral Embellish: 40mm Embossed Layered Handmade Paper x6 w/Gems |  |  |  |  | 12 | 0.65 | 7.8
FE236C | C) Paradise | 775749197891 | INDIA | 4811.90.0090
Floral Embellish: 40mm Embossed Layered Handmade Paper x6 w/Gems |  |  |  |  | 12 | 0.65 | 7.8
FE236D | D) Timeless | 775749197907 | INDIA | 4811.90.0090
Floral Embellish: 40mm Embossed Layered Handmade Paper x6 w/Gems |  |  |  |  | 12 | 0.65 | 7.8
FE236E | E) [NAME] | 775749197914 | INDIA | 4811.90.0090
A Brides Wish: Floral Foam Bouquet Holder- Wet 7.5" Straight |  |  |  |  | 18 | 0.82 | 14.76
FL001 | - | 775749075120 | CHINA | 3921.19.0090
A Brides Wish: Floral [NAME] Holder- Dry 7.5" Straight |  |  |  |  | 18 | 0.88 | 15.84
FL002 | - | 775749143096 | CHINA | 3921.19.0090
Floral Foam: Wet/Dry Asst Shrink-Wrap 7.9"x2.76"x3.94" |  |  |  |  | 96 | 0.72 | 69.12
FL009 | 24 Each Wet & Dry | 775749124613 | CHINA | 3921.19.0090
Floral Tape Stem Wrap: 1/2" x 20yds |  |  |  |  | 24 | 0.72 | 17.28
FL013A | A) Green | 775749004618 | TAIWAN | 4811.41.0090
Floral Tape Stem Wrap: 1/2" x 20yds |  |  |  |  | 24 | 0.72 | 17.28
FL013B | B) Brown | 775749004601 | TAIWAN | 4811.41.0090
Floral Tape Stem Wrap: 1/2" x 20yds |  |  |  |  | 24 | 0.72 | 17.28
FL013C | C) White | 775749004625 | TAIWAN | 4811.41.0090
Floral Tape Stem Wrap: 1/2" x 20yds |  |  |  |  | 24 | 0.72 | 17.28
FL013D | D) Leaf Green | 775749145854 | TAIWAN | 4811.41.0090
Floral Tape Stem Wrap: 1/2" x 20yds |  |  |  |  | 24 | 0.72 | 17.28
FL013E | E) Light Brown | 775749213867 | TAIWAN | 4811.41.0090
Floral Tape Stem Wrap: 1/2" x 20yds |  |  |  |  | 24 | 0.72 | 17.28
FL013F | F) Moss Green | 775749213874 | TAIWAN | 4811.41.0090
Floral Spool Wire: 26g Green 20m (0.45mm) |  |  |  |  | 24 | 0.65 | 15.6
[NAME] | - | 775749097924 | CHINA | 7217.10.0019
Floral Spool Wire: 30g Green 36m (0.30mm) |  |  |  |  | 24 | 0.65 | 15.6
FL032 | - | 775749097931 | CHINA | 7217.10.0019
Color Factory: Sponge Brush 5/pk 1"+2"+3" w/Wood Handle |  |  |  |  | 24 | 0.68 | 16.32
GB001 | - | 775749095302 | CHINA | 9603.40.9090
Color Factory: Sponge Brush 6/pk 1" w/Wood Handle |  |  |  |  | 24 | 0.68 | 16.32
[NAME] | - | 775749106701 | CHINA | 9603.40.9090
[NAME] Bottles: Mini Containers w/[NAME] |  |  |  |  | 24 | 0.78 | 18.72
GB800 | - | 775749106732 | CHINA | 7013.49.0090
[NAME] Bottles: Mini Containers w/Cork Lid x6 10ml |  |  |  |  | 24 | 0.75 | 18
GB804 | - | 775749195545 | CHINA | 7013.49.0090
[NAME]: 29.5ft Multi-Purpose Colored Craft String |  |  |  |  | 36 | 0.72 | 25.92
GC019A | A) Nature | 775749160772 | CHINA | 5207.10.0000
Spreadsheet: 187482d1350471908-link-group-2-cells-so-they-move-together-within-an-evolving-spreadsheet-is-this-possible-example
Sheet: Master

Stock Reference | Description | Supplier | PO Number | Qty | Currency | Cost |  | Manual input data
ACQUA-1196270 | ACQUA DI GIOIA EDP SPRAY 100ML A2OCT | UNIQUE COSMETICS | [NAME] | 144 |  | 27.77
ACQUA-1196270 | ACQUA DI GIOIA EDP SPRAY 100ML A2SEP | UNIQUE COSMETICS | [NAME] | 27.77 |  | 144 |  | 144
ACQUA-172587 | ACQUA DI GIOIA EDP SPRAY 50ML A2OCT | UNIQUE COSMETICS | [NAME] | 24 |  | 24
ACQUA-172587 | ACQUA DI GIOIA EDP SPRAY 50ML A2SEP | UNIQUE COSMETICS | [NAME] | 24 |  | 24.01 |  | 24
ACQUA-205886 | ACQUA GIO HOMME EDT SPRAY 50ML A2OCT | UNIQUE COSMETICS | [NAME] | 360 |  | 20.89