tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: john_zufferli__16803__marks
Sheet: Sheet1

 |  |  |  |  |  |  | Jan 2, 2002 | [NAME] | Zufferli | 12:00:00
 |  | *2001 actual published PP
 |  |  | flat | on | off |  | 2002 | BID | OFFER | MID
 |  | JAN* | 131.23 | 145.5 | 113.1 |  | JAN | 36 | 38
 |  | FEB* | 116.75 | 134.4 | 93.16 |  | FEB | 35.5 | 37
 |  | MAR* | 97.23 | 114.6 | 73.12 |  | MAR | 35.5 | 37
 |  | APR* | 114.82 | 138.4 | 85.25 |  | APR | 34 | 35
 |  | MAY* | 88.34 | 107.4 | 61.85 |  | MAY | 34 | 35
 |  | JUN* | 63.59 | 79.85 | 41.34 |  | JUN | 34 | 35
 |  | JUL* | 53.47 | 64.64 | 40.48 |  | JUL | 38 | 39
 |  | AUG* | 52.37 | 63.54 | 36.91 |  | AUG | 38 | 39
 |  | SEP* | 29.84 | 35.9 | 23.11 |  | SEP | 38 | 39
 |  | OCT* | 43.92 | 54.2 | 29.73 |  | OCT | 40.5 | 43
 |  | NOV* | 33.31 | 42.28 | 22.09 |  | NOV | 40.5 | 43
 |  | DEC BOM | xxx |  |  |  | DEC | 40.5 | 43
 |  |  |  |  |  |  | Cal 2002
Spreadsheet: 0c3fb641-5b17-41a8-9f80-6a1ddbda0d36
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
HLA57 | Test | HLA57 | HLA-B 5701 Genotype, Abacavir Hypersensitivity, Blood | HLA-B 5701 Genotype, [NAME], B | [NAME] (PCR)  (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | Lavender-top (EDTA) Tube: EDTA |  |  | 3 | mL | Multiple whole blood EDTA genotype tests can be performed on a single specimen. See Multiple Whole Blood EDTA Genotype Tests in Special Instructions for a list of tests that can be ordered together.   Container/Tube: Lavender top (EDTA) [NAME]: 3 mL Collection Instructions: Send specimen in original tube. Additional Information: Patients who had a heterologous blood transfusion within the preceding 45 days (6 weeks), or who have received an allogeneic bone marrow transplant, can have false genetic test results as human DNA present in the blood may be a mixture of patient and donor DNA. For these patients, a saliva specimen (rather than blood) should be submitted (HL57O/60347 HLA-B 5701 Genotype, Abacavir Hypersensitivity, [NAME]). Forms: New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | 0.3 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Tuesday, Friday | 1 day | 5 days | 1 | 81381 |  |  |  |  | Rochester
HLA57 | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient
HLA57 | Result | 89346 | HLA-B 5701 Result | HLA-B 5701 Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42358-2 | HLA-B5701:ACnc:Pt:[NAME]:[NAME]:
HLA57 | Result | 29315 | HLA-B 5701 Interpretation | HLA-B 5701 Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9 | Service comment 01:Imp:Pt:[NAME]:Nom:
HLA57 | Result | 29316 | HLA-B 5701 Reviewed by | HLA-B 5701 Reviewed by | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9 | Service comment 01:Imp:Pt:[NAME]:Nom:
Spreadsheet: 152856d1335553054-conditional-formatting-with-percentages-example-1a
Sheet: Sheet1

 |  |  |  |  |  |  |  | Actual OSD
 |  |  |  |  |  | % |  | Wk 1 | Wk2 | Wk3 | Wk4 | Wk5 | Wk 6
 |  |  |  |  |  | 68
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 40 |  | 75 | 75
 |  |  |  |  |  | 76 |  | 75
 |  |  |  |  |  | 80 |  | 50 | 84 | 85 | 86 | 222
 |  |  |  |  |  | 59
 |  |  |  |  |  | 0
 |  |  |  |  |  | 50 |  | 45 | 35 | 65 | 60 | 99
Spreadsheet: 768193d1644875842-trying-to-quickly-remove-numbers-from-addresses-sample-addresses
Sheet: Sheet1

 | streetaddress
 | 5358 W GRACE ST
 | 1400 N CICERO AVE
 | 3757 W HIRSCH ST
 | 2211 W 21ST ST
 | 49 E 101ST ST
 | 6300 S CHAMPLAIN AVE
 | 2137 N SPAULDING AVE
 | 7120 S MOZART ST
 | 6400 N NORDICA AVE
 | 459 E 74TH ST
 | 3401 W ARDMORE AVE
 | 230 W MONROE ST
 | 6200 W FOSTER AVE
 | 4035 N CAMPBELL AVE
 | 2301 E 81ST ST
 | 4035 N CAMPBELL AVE
 | 5313 S MARYLAND AVE
 | 1 E SUPERIOR ST
 | 5858 S COTTAGE GROVE AVE
 | 32 E 101ST ST
 | 4421 N MEADE AVE
 | 649 E 63RD ST
 | 260 W 24TH ST
 | 10031 S PAXTON AVE
 | 8332 S ANTHONY AVE
 | 6300 S CHAMPLAIN AVE
 | 9200 S EBERHART AVE
 | 5725 W 64TH ST
 | 1471 W ERIE ST
 | 5237 W PARKER AVE
 | 2200 N ORCHARD ST
 | 1514 N [NAME] AVE
 | 1400 W HOLLYWOOD AVE
 | 7300 W BALMORAL AVE
 | 7254 S SAWYER AVE
 | 6322 S LA CROSSE AVE
 | 3223 W BELLE PLAINE AVE
 | 6400 S LANGLEY AVE
 | 5100 S LEAMINGTON AVE
Spreadsheet: 99496d1298111693-formula-needed-to-work-out-the-balance-book1
Sheet: Sheet1

Name |  | Stake | Match | S | P | Results | Returns
[NAME] | 1 | 100 | Fulham - Chelsea 15/4 13/5 8/11 | 8 | 11 | 0-0
 | 2 | 100 | AC Milan - Tottenham 4/6 11/4 14/5 | 4 | 6 | 0-1
 | 3 | 100 | Arsenal - Barcelona 14/5 13/5 8/11 | 14 | 5 | 2-1
 | 4 | 100 | Roma - Shakhtar Donetsk 5/6 11/5 14/5 | 11 | 5 | 2-3
 | 5 | 100 | Sparta Prague - Liverpool 14/5 11/5 5/6 | 5 | 6 | 0-0 |  | Balance
Total Stake |  |  |  |  |  | Points Won
Spreadsheet: 549165d1511478781-how-to-use-vlookup-to-sum-multi-values-in-one-column-and-lso-get-the-max-value-q-1
Sheet: Sheet1

Table 1
Serial | date | Location | Data |  |  |  |  | Maximum:
43063Giza | 2017-11-24 00:00:00 | [NAME] | 85 |  |  | Table 2
43063Haram | 2017-11-24 00:00:00 | Haram | 20 |  |  | Serial | Date | Location | Sum Values Of Location
43063Mohandessin | 2017-11-24 00:00:00 | Mohandessin | 45 |  |  | 43063Giza |  | [NAME]
43063Mohandessin | 2017-11-24 00:00:00 | Mohandessin | 75 |  |  | 43063Haram |  | Haram
43063Mohandessin | 2017-11-24 00:00:00 | Mohandessin | 89 |  |  | 43063Mohandessin |  | Mohandessin
43063Giza | 2017-11-24 00:00:00 | [NAME] | 86 |  |  | 43063Masr Gideda |  | [NAME]
43063Masr Gideda | 2017-11-24 00:00:00 | [NAME] | 445 |  |  | 43063Sherouk |  | Sherouk
43063Madinit [NAME] | 2017-11-24 00:00:00 | [NAME] | 856 |  |  | 43063Obour |  | Obour
43063Sherouk | 2017-11-24 00:00:00 | Sherouk | 85
43063Obour | 2017-11-24 00:00:00 | Obour | 969
Spreadsheet: e8e480d2-e19e-4bf8-8def-c9b7833742c4
Sheet: Table 7.3

Monthly Statistical Bulletin
7.3 Overseas arrivals—visitors and settlers
Month | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
Visitors (a) (b) – '000
July | 446.5 | 492.5 | 493.3 | 497 | 530.3
August | 460.7 | 498.9 | 497.7 | 515.3 | 542.6
September | 473.3 | 501.9 | 474.1 | 517.9 | 547.8
October | 482.1 | 493.8 | 501.2 | 522.7
November | 466.3 | 497.1 | 499.8 | 525.9
December | 480.9 | 498.2 | 495 | 535.8
January | 477.8 | 500 | 496.5 | 524.8
February | 485.1 | 490 | 505.4 | 519.1
March | 487.7 | 475.2 | 506.3 | 531.2
April | 471.3 | 492.1 | 507.6 | 521.2
May | 480.5 | 494 | 502.9 | 525.2
June | 498.9 | 476.9 | 512.6 | 564.5
Annual | 5711.1 | 5910.599999999999 | 5992.400000000001 | 6300.599999999999
Settlers (c) – '000
July | 11.17 | 9.71 | 11.45 | 11.74 | 11.77
August | 13.26 | 11.57 | 12.88 | 13.22 | 13.49
September | 12.55 | 10.83 | 12.72 | 12.48 | 12.19
October | 11.6 | 9.37 | 12.35 | 11.94
November | 11.61 | 9.43 | 12.89 | 11.56
December | 11.94 | 10.02 | 13.9 | 12.94
January | 11.47 | 10.51 | 14.21 | 12.39
February | 12.32 | 10.52 | 14.44 | 12.68
March | 12.89 | 11.61 | 14.7 | 14.09
April | 10.78 | 11.21 | 13.33 | 12.64
May | 10.54 | 10.99 | 12.65 | 13.15
June | 10.48 | 11.7 | 13.46 | 13.58
Annual | 140.61 | 127.47 | 158.98 | 152.41
(a) Monthly figures are seasonally adjusted.
(b) Visitors are overseas visitors whose intended stay in Australia is less than 12 months.
(c) Settlers are travellers who hold migrant visas, New Zealand citizens who indicate an intention to settle, and those who are otherwise eligible to settle. |  |  |  |  |  |  |  | Update
Source: ABS, Overseas arrivals and departures, Cat. no. 3401.0 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=3401.0&viewtitle=Overseas%20Arrivals%20and%20Departures,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=3401.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=3401.0&viewtitle=Overseas%20Arrivals%20and%20Departures,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=3401.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=3401.0&viewtitle=Overseas%20Arrivals%20and%20Departures,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=3401.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=3401.0&viewtitle=Overseas%20Arrivals%20and%20Departures,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=3401.0&issue=Jan%202008&num=&view=& |  |  |  | 2013-12-05 00:00:00
Spreadsheet: 0f92affa-ea4c-4b88-9294-c33c78e5b60c
Sheet: race

Tract Number | Total Population | White(1) | Black(1) | Asian/Pacific Islander(1) | All Others(2) | Hispanic(3)
3521 | 3042 | 2201 | 130 | 416 | 295 | 223
3522 | 2021 | 1474 | 145 | 175 | 227 | 177
3523 | 2229 | 1706 | 95 | 221 | 207 | 211
3524 | 1942 | 709 | 724 | 162 | 347 | 359
3525 | 3312 | 1635 | 1030 | 231 | 416 | 453
3526 | 2652 | 1807 | 216 | 186 | 443 | 337
3527 | 2407 | 1446 | 412 | 126 | 423 | 301
3528 | 2385 | 1605 | 294 | 115 | 371 | 302
3529 | 2553 | 2163 | 108 | 172 | 110 | 55
3530 | 3706 | 2401 | 569 | 400 | 336 | 315
3531 | 8064 | 4000 | 792 | 2502 | 770 | 873
3532 | 3143 | 2136 | 466 | 272 | 269 | 258
3533 | 3636 | 2721 | 375 | 260 | 280 | 201
3534 | 2430 | 1022 | 816 | 288 | 304 | 227
3535 | 2599 | 1486 | 654 | 221 | 238 | 178
3536 | 4742 | 3762 | 217 | 541 | 222 | 305
3537 | 5246 | 3978 | 236 | 704 | 328 | 328
3538 | 4636 | 3602 | 186 | 633 | 215 | 219
3539 | 5923 | 3904 | 466 | 1155 | 398 | 456
3540 | 4649 | 3599 | 172 | 630 | 248 | 248
3541 | 2704 | 2337 | 93 | 195 | 79 | 104
3542 | 3063 | 2853 | 60 | 88 | 62 | 88
3543 | 3266 | 2494 | 349 | 209 | 214 | 164
3544 | 1714 | 1395 | 149 | 83 | 87 | 63
3545 | 2405 | 2015 | 56 | 249 | 85 | 71
3546 | 4409 | 2594 | 1180 | 395 | 240 | 192
3547 | 2481 | 2041 | 169 | 149 | 122 | 98
3548 | 2049 | 1703 | 121 | 144 | 81 | 44
3549 | 5235 | 2054 | 1602 | 980 | 599 | 523
3550 | 2712 | 2179 | 197 | 211 | 125 | 82
Citywide | 101355 | 69022 | 12079 | 12113 | 8141 | 7455
Spreadsheet: sally_beck__35801__Summary Report for EOL 2-29
Sheet: CONVERSION FACTORS

CONTINENTAL GAS |  |  | MMBTU | 1 |  | CONTINENTAL GAS-FINANCIAL=No | CONTINENTAL GAS FINANCIAL=No
UK GAS |  |  | MMBTU | 1 |  | CONTINENTAL GAS-PHYSICAL=Yes | CONTINENTAL GAS PHYSICAL=Yes
POWER |  |  | MWH | 10 |  | CONTINENTAL GAS-PHYSICAL=No | CONTINENTAL GAS PHYSICAL=No
CONTINENTAL POWER |  |  | MWH | 10 |  | CONTINENTAL POWER-FINANCIAL=Yes | CONTINENTAL POWER FINANCIAL=Yes
NORDIC POWER |  |  | MWH | 10 |  | CONTINENTAL POWER-FINANCIAL=No | CONTINENTAL POWER FINANCIAL=No
UK POWER |  |  | MWH | 10 |  | CONTINENTAL POWER-PHYSICAL=Yes | CONTINENTAL POWER PHYSICAL=Yes
EMISSIONS |  |  | CONTRACTS | 0 |  | CONTINENTAL POWER-PHYSICAL=No | CONTINENTAL POWER PHYSICAL=No
WEATHER |  |  | CONTRACTS | 0 |  | CRUDE & PRODUCTS-BASIS=Yes | CRUDE & PRODUCTS BASIS=Yes
 |  |  |  |  |  | CRUDE & PRODUCTS-BASIS=No | CRUDE & PRODUCTS BASIS=No
COMMODITY | TYPE | DATA LOCATION | UNIT TO |  |  | CRUDE & PRODUCTS-PHYSICAL=Yes | CRUDE & PRODUCTS PHYSICAL=Yes
COAL | PHYSICAL | ERMS | TONNE | 19.46666666666667 |  | CRUDE & PRODUCTS-PHYSICAL=No | CRUDE & PRODUCTS PHYSICAL=No
COAL | PRICE | ERMS | TONNE | 19.46666666666667 |  | CRUDE & PRODUCTS-PRICE=Yes | CRUDE & PRODUCTS PRICE=Yes
CRUDE & PRODUCTS | BASIS | ERMS | BBL | 5.826 |  | CRUDE & PRODUCTS-PRICE=No | CRUDE & PRODUCTS PRICE=No
CRUDE & PRODUCTS | PHYSICAL | ERMS | BBL | 5.826 |  | NORDIC POWER-FINANCIAL=Yes | NORDIC POWER FINANCIAL=Yes
CRUDE & PRODUCTS | PRICE | ERMS | BBL | 5.826 |  | NORDIC POWER-FINANCIAL=No | NORDIC POWER FINANCIAL=No
GAS | BASIS | ERMS | MMBTU | 1 |  | NORDIC POWER-PHYSICAL=No | NORDIC POWER PHYSICAL=No
GAS | GAS DAILY | ERMS | MMBTU | 1 |  | PETROCHEMICALS-PHYSICAL=Yes | [NAME]=Yes
GAS | PHYSICAL | CPR | MMBTU | 1 |  | PETROCHEMICALS-PHYSICAL=No | [NAME]=No
GAS | PRICE | ERMS | MMBTU | 1 |  | PETROCHEMICALS-PRICE=No | PETROCHEMICALS PRICE=No
LPG | BASIS | ERMS | BBL | 4.05 |  | UK GAS-FINANCIAL=Yes | UK GAS FINANCIAL=Yes
LPG | PHYSICAL | ERMS | BBL | 4.05 |  | UK GAS-FINANCIAL=No | UK GAS FINANCIAL=No
LPG | PRICE | ERMS | BBL | 4.05 |  | UK GAS-PHYSICAL=Yes | UK GAS PHYSICAL=Yes
LUMBER | PHYSICAL | ERMS | MBF | 0 |  | UK GAS-PHYSICAL=No | UK GAS PHYSICAL=No
LUMBER | PRICE | ERMS | MBF | 0 |  | UK POWER-FINANCIAL=Yes | UK POWER FINANCIAL=Yes
PAPER & PULP | BASIS | ERMS | TONNE | 0 |  | UK POWER-FINANCIAL=No | UK POWER FINANCIAL=No
PAPER & PULP | PHYSICAL | ERMS | TONNE | 0
PAPER & PULP | PRICE | ERMS | TONNE | 0
PETROCHEMICALS | BASIS | ERMS | BBL
PETROCHEMICALS | PHYSICAL | ERMS | BBL
PETROCHEMICALS | PRICE | ERMS | BBL
PLASTICS | PHYSICAL | ERMS | LB | 0
PLASTICS | PRICE | ERMS | LB | 0
Spreadsheet: 771670d1646784539-want-to-get-the-results-of-mavb-for-invoices-and-counts-and-sorted-smallest-to-largest-export-detail-ms-test-kisiji-
Sheet: PSW

1 | Bank Alfalah Ltd | PK30ALFH5515005000293928 | Export | Advanced Payment | BAF-EXP-004806-15022022 | Active | VAP-2
2 | Bank Alfalah Ltd | PK30ALFH5515005000293928 | Export | Advanced Payment | BAF-EXP-004581-14022022 | Active | 212
3 | Bank Alfalah Ltd | PK30ALFH5515005000293928 | Export | Advanced Payment | BAF-EXP-004259-11022022 | Active | [NAME]
4 | Bank Alfalah Ltd | PK30ALFH5515005000293928 | Export | Advanced Payment | BAF-EXP-002903-02022022 | Active | TA1
5 | Bank Alfalah Ltd | PK30ALFH5515005000293928 | Export | Advanced Payment | BAF-EXP-002290-31012022 | Active | BAI
6 | Bank Alfalah Ltd | PK30ALFH5515005000293928 | Export | Advanced Payment | BAF-EXP-002287-31012022 | Active | CCL
7 | Bank Alfalah Ltd | PK30ALFH5515005000293928 | Export | Advanced Payment | BAF-EXP-002274-31012022 | Active | VAP
8 | Bank Alfalah Ltd | PK30ALFH5515005000293928 | Export | Advanced Payment | BAF-EXP-002251-31012022 | Active | SEC
9 | Bank Alfalah Ltd | PK30ALFH5515005000293928 | Export | Advanced Payment | BAF-EXP-002249-31012022 | Active | TA6
10 | Bank Alfalah Ltd | PK30ALFH5515005000293928 | Export | Advanced Payment | BAF-EXP-002248-31012022 | Active | MLS
11 | Bank Alfalah Ltd | PK30ALFH5515005000293928 | Export | Advanced Payment | BAF-EXP-002247-31012022 | Active | WMS
X |  |  |  |  | WITH OUT FORM E | [NAME] | X | X | X |  | X | X | X | X
Spreadsheet: 389719d1429255436-an-if-formula-who-take-account-of-the-previous-and-next-line-of-the-first-column-test-on-v2
Sheet: Sheet1

Name | Options |  | By Name | By Option, 2 per class?
[NAME] | Chemistry |  |  |  |  | Available
[NAME] | geometry |  |  |  |  | Not available
[NAME] | Physics
[NAME] | Math
[NAME] | Math
[NAME] | Chemistry
[NAME] | Math
[NAME] | Geometry
[NAME] | Chemistry
[NAME] | History
[NAME] | German
Greg | Math
[NAME] | Physics
Remi | Math
Remi | geometry
[NAME] | Chemistry
[NAME] | History
[NAME] | German
[NAME] | Math
[NAME] | Chemistry
Spreadsheet: 148155d1333172029-excel-2007-referencing-particular-cells-book2-4-
Sheet: Sheet1

WEEK 5/1 | TOTAL | FUNDING ESTIMATE
DATE |  | FACTOR % | $
2012-02-27 00:00:00 | 1843307.55
2012-02-28 00:00:00 | 5441692.09
2012-02-29 00:00:00 | 9714099.439999996
2012-03-01 00:00:00 | 13168771.55
2012-03-02 00:00:00 | 3370765.63
WEEKLY TOTAL | 33538636.25999999 | 0.65 | 21800113.569
Week 2 | TOTAL | FUNDING ESTIMATE
DATE |  | FACTOR % | $
2012-03-05 00:00:00 | 2372236.84
2012-03-06 00:00:00 | 1610105.74
2012-03-07 00:00:00 | 2087084.79
2012-03-08 00:00:00 | 2897997.72
2012-03-09 00:00:00 | 7172714.7
WEEKLY TOTAL | 16140139.79 | 0.65 | 10491090.8635
Week 3 | TOTAL | FUNDING ESTIMATE
DATE |  | FACTOR % | $
2012-03-12 00:00:00 | 2690387.63
2012-03-13 00:00:00 | 786331.87
2012-03-14 00:00:00 | 1564544.39
2012-03-15 00:00:00 | 8235377.390000002
2012-03-16 00:00:00 | 8668242.399999999
WEEKLY TOTAL | 21944883.68 | 0.65 | 14264174.392
WEEK 4 | TOTAL | FUNDING ESTIMATE
DATE |  | FACTOR % | $
2012-03-19 00:00:00 | 1524720.93
2012-03-20 00:00:00 | 3338391.41
2012-03-21 00:00:00 | 1186970.62
2012-03-22 00:00:00 | 2385216.03
2012-03-23 00:00:00 | 6318728.56
WEEKLY TOTAL | 14754027.55 | 0.65 | 9590117.9075
WEEK 5 | TOTAL | FUNDING ESTIMATE
DATE |  | FACTOR % | $
2012-03-26 00:00:00 | 3047480.899999999
2012-03-27 00:00:00 | 1640845.54
2012-03-28 00:00:00 | 5017592.73
2012-03-29 00:00:00 | 8038728.710000001
2012-03-30 00:00:00 | 19560314.63
WEEKLY TOTAL | 37304962.51 | 0.65 | 24248225.6315
Spreadsheet: 7e9de63c-f438-4e6b-abc3-2908552a6003
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
8043 | 40954 | Faye | Mcclelland | GBR | 5483 | 00:00:00 | 00:00:00 | 00:05:00 | 00:00:47 | 00:19:50 | 1 | 00:25:38
8043 | 47881 | Lauren | Steadman | GBR | 5484 | 00:00:00 | 00:00:00 | 00:04:26 | [NAME] | [NAME] | 2 | [NAME]
8043 | 30601 | Clare | Cunningham | GBR | 5482 | 00:00:00 | 00:00:00 | 00:05:01 | 00:00:52 | 00:21:15 | 3 | 00:27:10
Spreadsheet: 777766d1650594259-auto-populate-cells-from-data-on-other-tabs-2022-trading-journal
Sheet: August

Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Weekly Totals
 |  | 2022-08-01 00:00:00 |  | 2022-08-02 00:00:00 |  | 2022-08-03 00:00:00 |  | 2022-08-04 00:00:00 |  | 2022-08-05 00:00:00 |  | 2022-08-06 00:00:00
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
2022-08-07 00:00:00 |  | 2022-08-08 00:00:00 |  | 2022-08-09 00:00:00 |  | 2022-08-10 00:00:00 |  | 2022-08-11 00:00:00 |  | 2022-08-12 00:00:00 |  | 2022-08-13 00:00:00
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
2022-08-14 00:00:00 |  | 2022-08-15 00:00:00 |  | 2022-08-16 00:00:00 |  | 2022-08-17 00:00:00 |  | 2022-08-18 00:00:00 |  | 2022-08-19 00:00:00 |  | 2022-08-20 00:00:00
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
2022-08-21 00:00:00 |  | 2022-08-22 00:00:00 |  | 2022-08-23 00:00:00 |  | 2022-08-24 00:00:00 |  | 2022-08-25 00:00:00 |  | 2022-08-26 00:00:00 |  | 2022-08-27 00:00:00
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
2022-08-28 00:00:00 |  | 2022-08-29 00:00:00 |  | 2022-08-30 00:00:00 |  | 2022-08-31 00:00:00
Spreadsheet: 132860d1323983999-sum-using-a-common-reference-in-different-cells-example-1-
Sheet: 8-15 to 8-31

 |  | Count of Name
 |  | Date | Name | Total
 |  | 08/15/2011 Total | -, - | 1 |  | [NAME]
 |  |  | Adam | 4 |  | Adam
 |  |  | [NAME] | 3 |  | [NAME]
 |  |  | [NAME] | 1 |  | [NAME]
 |  |  | Stacy | 3 |  | Stacy
 |  |  | [NAME] | 3 |  | [NAME]
 |  |  | [NAME] | 2 |  | [NAME]
 |  |  | [NAME] | 1 |  | [NAME]
 |  |  | [NAME] | 1 |  | [NAME]
 |  | 08/15/2011 Total |  | 4308
 |  | 08/16/2011 Total | Adam | 12
 |  |  | [NAME] | 3
 |  |  | [NAME] | 1
 |  |  | Stacy | 12
 |  |  | [NAME] | 3
 |  |  | [NAME] | 3
 |  |  | [NAME] | 8
 |  | 08/16/2011 Total |  | 4631
 |  | 08/17/2011 Total | -, - | 5
 |  |  | Adam | 6
 |  |  | Stacy | 10
 |  |  | [NAME] | 3
 |  |  | [NAME] | 3
 |  |  | [NAME] | 4
 |  |  | [NAME] | 6
 |  | 08/17/2011 Total |  | 4440
 |  | 08/18/2011 Total | Adam | 5
 |  |  | [NAME] | 1
 |  |  | Stacy | 10
 |  |  | [NAME] | 3
 |  |  | [NAME] | 4
 |  |  | [NAME] | 6
Spreadsheet: 137619d1327260906-excel-or-access-for-manufacturing-costing-dummy-file
Sheet: Dry Roasted Almonds

DRAL4 - Dry Roasted Almonds
KG | [NAME] CODE | INGREDIENT | PERCENT | [NAME] | $/KG | EXT
65 | ALCAR | Carmel Almonds
 |  | [NAME]
 |  | Percentage of loss: | 0.02 |  | SUB TOTAL:
 |  | GROSS kg per batch: | 105 |  | ADJUSTED:
 |  | NET kg per batch: |  |  | Total labour cost:
 |  | Min./batch : | 45 |  | TOTAL:
Spreadsheet: 872939d1719400290-calculate-total-for-a-group-mm82-test-calc-aligw
Sheet: Sheet1

GROUP BY | [NAME] | Yield | Sum
Test 1 | A | 0.33
Test 1 | B | 0.1 | 0.43
Test 2 | C | 0.49 | 0.55
Test 2 | D | 0.06 | 0.55
Test 3 | E | 0.34 | 0.5
Test 3 | F | 0.08 | 0.5
Test 3 | G | 0.08 | 0.5
Spreadsheet: 65201d1265907268-sumproduct-using-multiple-conditions-test-account
Sheet: Sheet1

 | 21st January | Cheque Deposit |  |  |  |  | 3206.97 | Yes
 | 21st January | Service Fee |  |  |  | 33 |  | Yes
 | 22nd January | [NAME]:Maestr-E (enter date) |  |  | 18th January |  | 606.58
 | 22nd January | [NAME]:Duality-E (enter date) |  |  | 19th January |  | 3425.51 |  | 3919.15
 | 25th January | [NAME]:Maestr-E (enter date) |  |  | 19th January |  | 493.64
 | 25th January | [NAME]:Duality-E (enter date) |  |  | 20th January |  | 5701.8
 | 25th January | Cheque Deposit |  |  |  |  | 4275.19 | Yes
 | 26th January | [NAME]:Duality-E (enter date) |  |  | 21st January |  | 2690.09
 | 26th January | [NAME]:Maestr-E (enter date) |  |  | 20th January |  | 158.48
 | 26th January | Transfer to Account 54132587 |  |  |  | 3000
 | 27th January | [NAME]:Maestr-E (enter date) |  |  | 21st January |  | 996.7
Spreadsheet: 767283d1644392298-allocate-amount-into-monthly-columns-formula-fails-for-specific-years-networkdays-issue-allocation1-ans2
Sheet: Weekdays

Weekdays
Click Consulting
Purpose | To update the allocation table to exclude weekend days.
Function | NETWORKDAYS - returns the number of workdays, excluding weekends, between two dates (inclusive)
Allocation
 | Amount | Alloc Start | Alloc End |  | WeekDays | DailyAmt |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Diff
 | 1000 | 2022-01-01 00:00:00 | 2022-12-31 00:00:00
 | 600 | 2022-01-01 00:00:00 | 2022-12-31 00:00:00
 | 900 | 2022-01-01 00:00:00 | 2022-12-31 00:00:00
 | -750 | 2022-01-01 00:00:00 | 2022-12-31 00:00:00
 | 800 | 2022-03-01 00:00:00 | 2022-08-31 00:00:00
 | 650 | 2022-01-01 00:00:00 | 2022-06-30 00:00:00
 | 850 | 2022-04-01 00:00:00 | 2022-12-25 00:00:00
 |  | Dates are changed for verification.
Spreadsheet: 691393d1597675992-i-need-a-formula-to-remove-specific-words-in-a-cell-major-sample
Sheet: Sheet1

original entry | Results after formula
Mechanical Engineering Major | Mechanical Engineering
Mechanical Engineering Major w/ Honors | Mechanical Engineering
Nuclear Engineering Major | Nuclear Engineering
Nuclear Engineering Major w/ Honors | Nuclear Engineering
Political Science Major: American Politics | Political Science: American Politics
Political Science Major: American Politics w/ Thesis | Political Science: American Politics
Political Science Major: American Politics w/ Thesis (Honors) | Political Science: American Politics
Psychology Major: Organizational Psychology & Leadership | Psychology: Organizational Psychology & Leadership
Regional Studies Minor - Europe | Regional Studies Minor - Europe
Sociology Major | Sociology