tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: c8e138ce-9d36-46a7-b5bb-cedb40236095
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40255761 | 2014-02-26 23:04:35 | AXIS | 1 | 10 | 8 | 867821 | b.kuntscher | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40339986 | 2014-03-03 21:49:46 | AXIS | 1 | 10 | 4 | 839961 |  | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40340694 | 2014-03-03 22:26:02 | ALLIES | 0 | 5 | 10 | 839961 |  | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40341399 | 2014-03-03 22:57:48 | ALLIES | 1 | 10 | 5 | 867821 | b.kuntscher | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40341896 | 2014-03-03 23:29:43 | AXIS | 0 | 7 | 10 | 867821 | b.kuntscher | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40356267 | 2014-03-04 21:57:48 | AXIS | 0 | 8 | 10 | 225841 | sacas | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40357533 | 2014-03-04 22:41:47 | AXIS | 0 | 5 | 10 | 509176 | arsenal94 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40357990 | 2014-03-04 23:17:50 | ALLIES | 1 | 10 | 7 | 509176 | arsenal94 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40364005 | 2014-03-05 07:53:22 | AXIS | 1 | 10 | 5 | 432719 | battlelore | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40373256 | 2014-03-05 22:35:18 | ALLIES | 1 | 10 | 6 | 291698 | [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40373782 | 2014-03-05 23:09:43 | AXIS | 1 | 10 | 6 | 291698 | [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40382507 | 2014-03-06 14:30:42 | ALLIES | 1 | 10 | 7 | 981983 | gi19 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40388202 | 2014-03-06 22:40:27 | AXIS | 1 | 10 | 5 | 760708 | borderbattles | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40389185 | 2014-03-06 23:17:03 | ALLIES | 1 | 10 | 7 | 760708 | borderbattles | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40415944 | 2014-03-08 17:32:12 | AXIS | 0 | 8 | 10 | 603439 | MickeyScott01 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40431506 | 2014-03-09 15:46:19 | ALLIES | 0 | 5 | 10 | 1210418 | [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 124045d1318017855-formatting-box-inventory
Sheet: KO61

 |  | KO61 [NAME]
Box # | Start Date | 50 Day | 70 Day | Box Location | Box Weight Empty | Material Weight | Delivered to Staging | Issues
8 | 2011-07-01 00:00:00 |  |  |  | 9180 | 1 |  | None
12 | 2011-09-01 00:00:00 |  |  | Baghouse | 8980 | 2 |  | None
13 | 2011-08-01 00:00:00 |  |  | Baghouse | 9440 | 3 |  | None
14 | 2011-08-01 00:00:00 |  |  | Baghouse | 9300 | 4 |  | None
17 | 2011-08-01 00:00:00 |  |  | Baghouse | 9260 | 5 |  | None
 | Baghouse
 | Transfer Tower
 | Dedust
 | Fans
Spreadsheet: 46579d1245423937-sumif-multiple-worksheets-add-all-cells-adjacent-to-cell-w-value-matching-query-kor-cart-quotas
Sheet: LGH - CS-SPD PACKS (#3)

K-BRO LINEN SYSTEMS - EDMONTON  PLANT
CS-SPD PACKS #3
FACILITY: | LEDUC GENERAL HOSPITAL
Date:
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | STATS
DELIVERY DAYS: |  |  | X |  |  |  |  | X
** If more/less linen required please fax in this order by 7:30 a.m. (FAX # (780) 451-5125)
[NAME] |  |  |  | PACK # |  | QUOTA | SHELF | REC | +/-/HOLD
20-HUCK TOWELS |  |  |  | BP0009 |  | 16
20-WRAPPER 24" |  |  |  | BP0003 |  | 2
20-WRAPPER 30" |  |  |  | BP0004 |  | 3
20-WRAPPER 36" |  |  |  | BP0005 |  | 3
20-WRAPPER 45" |  |  |  | BP0006 |  | 14
20-WRAPPER 54" |  |  |  | BP0007 |  | 1
20-MICRO WRAPS 45" |  |  |  | BP0008 |  | 3
10-TRAY-PILLOW COVERS |  |  |  | AP0014 |  | 2
10-BATH TOWEL |  |  |  | GL0004 |  | 6
5-GOWN-GORE XL |  |  |  | BP0023 |  | 10
10-MED FEN DRAPE |  |  |  | BP0025 |  | 2
10-INSTRUMENT POUCH |  |  |  | BP0056 |  | 3
5-UNDERPAD-LG |  |  |  | GL0032 |  | 1
UPDATED:
June 17th 2009
Spreadsheet: 120371d1315243153-latitude-and-longitude-to-eastings-and-northings-projectionandtransformationcalculations
Sheet: t-T correction from E,N

t-T correction from Eastings and Northings
Easting | 651409.903 |  |  |  |  | This is the input data
Northing | 313177.27
Easting 2 | 626238.249
Northing 2 | 302646.415
 | ° | ' | " | [NAME] | Radians
(t1 - T1) | 0 | 0 | 6.482942545756391 | 0.00180081737382122 | 3.143019240029782e-05 | This is the result of the calculation
(t2 - T2) | -0 | 0 | 6.259110732165552 | -0.001738641870045987 | -3.034502514533384e-05
Nm | 307911.8425 |  |  |  |  | These values are intermediate calculation steps
M | 407911.8424999879
j' | 52 | 40 | 6.855171343078837 | 52.66857088092863 | 0.9192399741922149 | The radians value of j' and the value of M are computed using user defined functions
n | 6388506.295432329 |  |  |  |  | To see the Visual Basic code of the functions -
r | 6372768.297073655 |  |  |  |  | Menu = Tools, Macro, Visual Basic Editor,
XXIII | 4.093749779608289e-15 |  |  |  |  | then view the code in "Module 1".
(t1 - T1) | 0 | 0 | 6.482942545756398 | 0.001800817373821222 |  | This is the result of the calculation using a user defined function.
(t2 - T2) | -0 | 0 | 6.259110732165558 | -0.001738641870045988 |  | To see the Visual Basic code of the function -
 |  |  |  |  |  | Menu = Tools, Macro, Visual Basic Editor,
 |  |  |  |  |  | then view the code in "Module 1".
Notes
t-T correction is the difference between true direction and projected direction due to the curving of straight lines on the projection
Spreadsheet: 98344d1297280686-consolidating-data-on-different-sheets-going-off-of-a-name-pay-roll-temp
Sheet: Feb.2011

[NAME]
February. 2011
[NAME] | Position | Daily Rate | Days On | Gross Pay | Cash Advance | Travel & Visa Reimb. | Medical | Net Pay | Wire and ADP Fees | Other
[NAME] | Master | 550
[NAME] | Master | 350
[NAME] | Chief Officer | 400
[NAME] | Chief Officer | 400
[NAME] | 2nd  Officer | 300
[NAME] | Ch Eng | 450
Spreadsheet: 1e0bf83e-dcb6-405b-9188-86dddb0fa750
Sheet: Sheet1

F/Y 2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Justice of the Peace Authorized Bail Bond Agencies
Bail Bond Agencies | Address | Telephone  Number | Counties | Registered Agents | Authorized Agents to Pick Up Refunds
1st Choice Bail Bonds | 4142 Ogletown-Stanton Road, Suite 146 | [PHONE] | All | [NAME] | [NAME]
 | Newark, DE  19713
2nd Chance Bail Bonds | 25675 Covert Street |  | Kent | [NAME] | [NAME]
 | Seaford, DE  19973 | [PHONE] | Sussex
A Bail Bond by Resto & Co. | 1200 Northeast Boulevard, Suite B | [PHONE] | All | [NAME], [NAME], [NAME],  Courtland Jones and [NAME] | [NAME], [NAME], [NAME], and Courtland Jones
 | [NAME], DE  19802
A-Z Bail Bonds | 94-A Quigley Boulevard | [PHONE] | All | Sandra Hale | Sandra Hale
 | New Castle, DE  19720
Above and Beyond Bail Bonds | 94A Quigley Boulevard
 | New Castle, DE  19720-4150 | [PHONE] | All | [NAME] | [NAME]
 |  |  |  | [NAME] (No Cash)
Absolute Bail Bonds | 104 [NAME] | [PHONE] | Kent | [NAME] | [NAME]
 | Milford, DE  19963 |  | Sussex
Ace Bail Bonds | 424 S. State Street | [PHONE] | Kent | [NAME] | [NAME]
 | Dover, DE 19901
All Star Bail Bonds, L.L.C. | 2915 Lancaster Avenue
 | [NAME], DE  19805 | [PHONE] | All* | [NAME] | [NAME]
 |  |  | *Cannot post in 7 or 20
American Funding Services Corp. | 2062 New Castle Ave, Suite A
CASH ONLY | New Castle, DE  19720 | [PHONE] | All | [NAME] | [NAME]
Bail Bond Agency, Inc. | 102 Larch Avenue, Suite 302 | [PHONE] | All | [NAME] | [NAME]
 | Newport, DE  19804 |  |  | Khyon Church
Bovell Bail Bond, Inc. | 1900 W. 4th Street | [PHONE] | New Castle | [NAME] | [NAME]
 | [NAME], DE  19805
Bruny's Bail Bonds | 1927 W. 4th Street | [PHONE] | All | Brunilda Mercado, [NAME] | Brunilda Mercado, [NAME]
 | [NAME], DE  19805
Dale's Bail Bonds LLC | 11 E. Market Street, Suite 1 | [PHONE] | Kent | R. [NAME] | R. [NAME]
 | Georgetown, DE  19947 | [PHONE] | Sussex | [NAME] | [NAME]
Enrico Lepore Jr Bail Bonds | 411 S. Queen Street, Apt 213
 | Dover, DE  19904 | [PHONE] | Kent | [NAME], Jr. | [NAME], Jr.
Fast Bail Bonds LLC | 1324 [NAME] | [PHONE] | All | [NAME] | [NAME]
 | [NAME], DE  19801
Gina's Bail Bonds | 307 S. State Street | [PHONE] | Kent
 | Dover, DE  19901 |  | Sussex | [NAME] | [NAME]
Lorenzo's Bail Bonds, Inc. | 5 E. Market Street | [PHONE] | Kent | [NAME] | [NAME]
 | Georgetown, DE  19947 |  | Sussex | [NAME]
No Bars Bail Bonds LLC | 34 Anna Avenue
 | Bear, DE  19701 | [PHONE] | All | [NAME] | [NAME]
[NAME]'s Bail Bonds, LLC | 424 S. State Street | [PHONE] | Kent | [NAME] | [NAME]
 | Dover, DE  19901 |  | Sussex
T&H Bail Bond, Inc. | 625 [NAME] | [PHONE] | New Castle | [NAME], [NAME], [NAME], [NAME], [NAME] | [NAME], [NAME], [NAME], [NAME], [NAME]
 | [NAME], DE  19801
Top Bail Surety, Inc. | 1115 Clayton Road | [PHONE] | All | [NAME], [NAME] | [NAME]
 | [NAME], DE  19805 |  | *Cannot post in JP 7 |  | [NAME]
Spreadsheet: 799730d1665239514-textjoin-and-filter-join-text-based-on-criteria-in-adjacent-column-being-met-textjoin-and-filter-xtinct2
Sheet: Sheet1

 | Year | Fruit |  | Desired Result | Orange, Watermelon, Kiwi | < 2017 fruit, sparated by comma & space
 | 2013-02-04 00:00:00 | Apple |  | [NAME]
 | 2017-04-16 00:00:00 | Orange
 | 2020-07-08 00:00:00 | Grape
 | 2017-09-09 00:00:00 | Watermelon
 | 2017-03-14 00:00:00 | Kiwi
 | 2020-01-19 00:00:00 | [NAME]
 | 2013-06-07 00:00:00 | Grappefruit
Spreadsheet: 297956d1392656229-selecting-a-table-based-on-two-dropdown-lists-selecting-a-table-ndm
Sheet: 34x8.5

34x8,5cm
Silk 4+4 | 0-499 | 500-4.999 | 5.000-10.000 | 10.000+
170gr. | 0.5 | 0.45 | 0.35 | Call
200gr. | 0.52 | 0.47 | 0.37 | Call
250gr. | 0.55 | 0.5 | 0.4 | Call
300gr. | 0.59 | 0.54 | 0.44 | Call
Gloss 4+4 | 0-499 | 500-4.999 | 5.000-10.000 | 10.000+
170gr. | 0.52 | 0.47 | 0.37 | Call
200gr. | 0.53 | 0.48 | 0.38 | Call
250gr. | 0.53 | 0.48 | 0.38 | Call
300gr. | 0.63 | 0.58 | 0.48 | Call
Silk 4+0 | 0-499 | 500-4.999 | 5.000-10.000 | 10.000+
170gr. | 0.45 | 0.4 | 0.3 | Call
200gr. | 0.47 | 0.42 | 0.32 | Call
250gr. | 0.5 | 0.45 | 0.35 | Call
300gr. | 0.54 | 0.49 | 0.39 | Call
Gloss 4+0 | 0-499 | 500-4.999 | 5.000-10.000 | 10.000+
170gr. | 0.47 | 0.42 | 0.32 | Call
200gr. | 0.48 | 0.43 | 0.33 | Call
250gr. | 0.48 | 0.43 | 0.33 | Call
300gr. | 0.58 | 0.53 | 0.43 | Call
Spreadsheet: 680967d1591280077-survey-help-to-interpret-data-csv-data-to-use-pl-attendance-figures-kevinmgl-
Sheet: PT Words

Column14 | Column19 | Count of Column19
Arsenal | 0 | 7
 | 11-15 | 1
 | 1-5 | 4
 | 16 or more | 2
 | 6-10 | 2
Burnley | 6-10 | 1
Chelsea | 0 | 10
 | 1-5 | 3
 | 16 or more | 1
 | 6-10 | 2
Crystal Palace | 11-15 | 1
Everton | 1-5 | 1
Leicester City | 0 | 1
Liverpool | 0 | 6
 | 1-5 | 2
 | 6-10 | 1
Manchester City | 0 | 3
 | 1-5 | 3
 | 16 or more | 1
 | 6-10 | 1
[NAME] | 0 | 17
 | 11-15 | 2
 | 1-5 | 18
 | 16 or more | 4
[NAME] | 1-5 | 1
 | 16 or more | 1
Grand Total |  | 96
Spreadsheet: chris_germany__2129__FebCohCHOICE-ENA
Sheet: Feb 6

 | CES/NPC COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2001-02-06 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | Upstream K# | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1118 |  | 1118 |  | 67694 |  |  |  |  |  |  | 32 | 1 | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 | 2 | 32
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 7278 |  | 7597 |  | 67694 |  |  |  |  |  |  | 33 | 3 | 32
 |  |  |  |  |  |  |  |  | 3000 |  | 3000 |  | 68918 | 103722 | 0 |  |  |  |  | 32 | 4 | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 | 5 | 33
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 2060 |  | 2183 |  | 67694 |  |  |  |  |  |  | 34 | 6 | 32
 |  |  |  |  |  |  |  |  | 2000 |  | 2000 |  | 68915 | 103722 | 0 |  |  |  |  | 33 | 7 | 32
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69148 |  | 0 |  |  |  |  | 35 | 8 | 34
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 |  | 0 |  |  |  |  | 34 | 9 | 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38 | 15 | 38
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 14968 |  | 14968 |  | 67694 |  |  |  |  |  |  | 34 | 35 | 34
 |  |  |  |  |  |  |  |  | 25 |  | 25 |  | 68917 | 103722 | 0 |  |  |  |  | 32 | 39 | 32
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69149 |  | 0
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 |  | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 1059 |  | 1155 |  | 67694 |  |  |  |  |  |  | %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Storage
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1647 |  | 1647 |  | 67694 |  |  |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 68916 | 103722 | 0 |  |  |  |  | 1
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 12494 |  | 13684 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 3301 |  | 3511 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 3400 |  | 3514 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 4351 |  | 4492 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 1074 |  | 1074 |  | 67694
 |  |  |  |  |  |  |  |  | 257 |  | 257 |  | 69708 | 53858 | 0
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 53858 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 36 |  | 36 |  | 67694 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20606 | FOM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20500 | Pull from ENA Pool to NPC Pool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 48363ef3-b128-4c2a-aef0-f4c1be74612d
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
CHAG | Test | CHAG | Trypanosoma cruzi Antibody, IgG, Serum | Trypanosoma cruzi Ab, IgG, S | Enzyme-Linked Immunosorbent Assay (ELISA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Collection Container/Tube:  Preferred: Red top Acceptable: Serum gel Submission Container/Tube: Plastic vial [NAME]: 0.5 mL | 0.2 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | Negative | Tuesday; 9 a.m. | Same day/1 day | 8 days | 1 | 86753 |  |  |  |  | Rochester
CHAG | [NAME] | SERUM | Serum |  |  |  | Frozen | 14 days
CHAG | Result | 86159 | Trypanosoma cruzi Ab, IgG, S | Trypanosoma cruzi Ab, IgG, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32725-4 | Trypanosoma cruzi Ab.[NAME]:ACnc:Pt:Ser:Ord:
Spreadsheet: 188369d1350850894-job-listing-action-list-17-10-12-example-jacc
Sheet: Jobs

REQUEST | DATE | REQUESTOR | HANDLED  BY | STATUS | NEXT STEP
ELEVATOR | 2012-09-01 00:00:00 | [NAME] | AVIV/GADI | WHITE GLASS  ON 2 SIDES.   TEAK FOR FLOOR (? FIRE PROOFING) | no fire-proofing required - see email to Aviv
GARAGE | 2012-09-01 00:00:00 | [NAME] | AVIV/GADI | BAR WITH HEIGHT MEASUREMENTS +  CHAINS | pending completion of garage
LANDSCAPING GAZEBO | 2012-09-01 00:00:00 | [NAME] | YAIR/ODEYA | BASE STONE 5 CM, PIZZA SHAPE, 0.8% SLOPE TO DECKING FOR RAINWATER | instructions issued - awaiting quote from Yair
LANDSCAPING STONEWORK | 2012-09-01 00:00:00 | [NAME] | YAIR/ODEYA | LARGE PIECES REMAINING FROM INDIAN SHIPMENT | outstanding - RL sorting out with Yair/Smadar
POOL HOUSE BED/BATHROOM GB1 | 2012-09-01 00:00:00 | [NAME] | AVIV/GADI/ SHELAGH | DOOR STOPS FOR GLASS DOORS | sort out on site with Shelagh/Gadi
POOL HOUSE BED/BATHROOM GB2 | 2012-09-01 00:00:00 | [NAME] | AVIV/GADI/ SHELAGH | TOILET + BIDET TO STAY.  CHECK PRICES OF SHOWER TRAYS.  DOOR STOPS FOR GLASS DOORS | shower trays now ordered
OUTDOOR WATER PRESSURE | 2012-09-01 00:00:00 | [NAME] | JACKIE | CHECK  GARDEN WATER PRESSURE WITH AVIV/GADI | outstanding - information required for window cleaning pole/brushes
PICTURES, BOATS | 2012-09-01 00:00:00 | [NAME] | JACKIE | BOAT PICTURES TO BE FRAMED  (THIN TEAK?).  DO SOME AS EXAMPLES THEN  RICHARD  WILL CHOOSE | will sort out during visit 22 - 26 October
Spreadsheet: 686967d1594893230-help-with-formula-to-calculate-the-basket-total-and-add-commission-excelforum_example
Sheet: Sheet1

[NAME] | Product Price | Commission
#1336 | 180
#1335 | 50 |  |  |  |  | Row Labels | Sum of Product Price | Commission 1.9% + 0.20
#1335 | 500 |  |  |  |  | #1333 | 6030.399999999999 | 114.7776
#1334 | 180 |  |  |  |  | #1334 | 260 | 5.14
#1334 | 80 |  |  |  |  | #1335 | 550 | 10.65
#1333 | 1603.5 |  |  |  |  | #1336 | 180 | 3.62
#1333 | 1335.25 |  |  |  |  | Grand Total | 7020.399999999999 | 133.5876
#1333 | 1389.7
#1333 | 1336.25
#1333 | 121.9
#1333 | 121.9
#1333 | 121.9
Spreadsheet: 168319d1342398267-a-complicated-look-up-table-with-multiple-conditions-complex-look-up
Sheet: Result

 |  |  |  | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | Mar | April | May | June
[NAME]
TM72006 | [NAME](Z9002) | Z9002 | In Brand Text column from LookUP Data tab | 60 | 60
TM72001 | [NAME]  (ZCT) | [NAME] | In Brand Text column from LookUP Data tab | 85 | 85
TM72004 | TMF ACRYLIC 1-P (ZMB00) | [NAME] | In Product Size column from LookUP Data tab | 53 | 56
TM72001 | TMF ACRYLIC 3-P (ZMA00) | ZMA00 | In Product Size column from LookUP Data tab | 63 | 75
TM72006 | Phaco Tips | Reusable Tips + Disposable Tips | In Brand Text column from LookUP Data tab, 2 combined look up vales | 0 | 0
TM72001 | PHACO ACC- FX [NAME] | Sovereign Accessories | In Brand Text column from LookUP Data tab | 34 | 34
TM72001 | Phaco Equipment / Signature $ | WhiteStar Signature | In Brand Text column from LookUP Data tab | 32 | 32
TM72001 | Fitzory | Kalmore | Not there in the Look UP Data | 0 | 0
Look UP Values |  | Look Up Values |  | to auto populate Net Sales Values values
from Terr Surg column of LookUP [NAME] |  | some of these values are found in "Brand Text" column and Some in "Product Size Column" |  | ( if value not there, should appear as blank, no #NA vales to be there)
Spreadsheet: 4445fe5f-61c7-494c-9168-08899020cdd9
Sheet: UVA Leadership Pilot

Grant: |  | Title 1A UVA Leadership Pilot
CFDA # |  | 84.010
GRANT NUMBER: |  | 5010
FISCAL YEAR: |  | 2011-12
[NAME]: |  | Not allowed on this grant
Question regarding payments: |  | [NAME]   [PHONE] or [EMAIL]
Questions regarding grant: |  | [NAME]6905 or [EMAIL]
LAST DAY TO SUBMIT REQUESTS FOR THIS GRANT  - November 15, 2013
Code | District Name | School Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | MARCH 2012 | APRIL 2012 | MAY 2012 | JUNE 2012 | JULY 2012 | AUGUST 2012 | SEPTEMBER 2012 | OCTOBER 2012 | NOVEMBER 2012
30 | Adams 14 | [NAME], [NAME], Adams City Middle School | 225000 |  |  |  |  |  |  |  | 64868 | 2991
123 | [NAME] | [NAME], Middle, and [NAME] | 211000 |  |  |  | 102800 |  |  |  |  |  |  | 8400
Spreadsheet: 877841d1724784887-multi-dependent-drop-down-lists-index
Sheet: Table

Category | Sub-Category | Type |  | Category | ProjectManagement | QualityTools | ProcessMapping
ProcessMapping |  |  |  | ProjectManagement | Initiating | Checklist | [NAME]
 |  |  |  | QualityTools | Planning | Diagram
 |  |  |  | ProcessMapping | Executing | Plot
 |  |  |  |  | Monitoring&Controlling | Chart
 |  |  |  |  | Closing | Analysis
 |  |  |  |  |  | DecisionMaking
 |  |  |  |  |  | Planning
 |  |  |  |  |  | Matrix
 |  |  |  |  |  | Other
Spreadsheet: 813861d1674034125-identifying-text-and-sorting-data-accordingly-text_finden_2-_neu
Sheet: Tabelle1

[NAME] |  |  |  | [NAME] |  |  |  | Anlieferung 3 |  |  |  | [NAME] |  |  |  | Anlieferung 5 |  |  |  | Anlieferung 6 |  |  |  |  |  | Freude | B | C | D | E | F
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | should 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | should 15
 |  |  | 10 |  |  |  | 15 |  |  |  | 23 |  |  |  | 41 |  |  |  | 7 |  |  |  | 19
The formula is not working when I expend the range.
It should count both "Freude", and each result in one cell (see "Should")
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
Spreadsheet: dana_davis__4473__CANADA - 28C
Sheet: E31.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 28C
COMPANY NAME ECT - CANADA ACCOUNTING ENTRY
RECONCILIATION OF STOCKHOLDERS' EQUITY AND INVESTMENT IN SUBS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
 |  |  |  | 12-31-99 Balance |  |  |  | EQUITY IN |  | DIVIDENDS DECLARED |  |  |  | OTHER ACTIVITY
 |  |  |  | DR  (CR) |  | RECLASS 99 NI |  | EARNINGS |  |  |  |  |  |  |  |  |  | DR  (CR)
 |  | Hyp line |  | BEG BALANCE |  | TO BEG RE |  | /LOSSES |  | COMMON |  | PREFERRED |  | DR (CR) |  | (Describe) |  | END BALANCE
Shareholders Equity by Parent |  | Reverse signs from Hyperion
Common Stock |  | 0901
Paid in Capital |  | 0910
Contribution Received from Parent |  | 0915
RE - Beg Bal |  | 0920 |  | -1234523 |  | 2819895
RE - Net Income |  | 0930 |  | 2819895 |  | -2819895 |  | 1364909
RE - Net Income (Fair Value Adjustment) |  | 0931
Dividends Decl - Preferred Stock |  | 0935
Dividends Decl - Common Stock |  | 0941
Invest in Subs Plug Account |  | 0942 |  | 1 |  |  |  | 1
Total Shareholders' Equity |  | TOT_SHARE_EQU
Net Income |  | NET_INCOME
PARENT'S CO # |  | 413
Investment in Consol Sub (on Parent Books) |  |  |  | Same signs as Hyperion
Investment in CS |  | 0215
Investment in PIC (contrib by parent) |  | 0216
Investment in Equity earnings of sub |  | 0217 |  | -1585372 |  |  |  | 0
Total Investment in Consol Sub
Equity in Consol Sub |  | 1505
Difference between SE (on sub) and Invest (on parent)
Reasons for Differences
Net Income, Rolled to Parent annually |  |  |  |  |  |  |  | 1364909
Invest in Subs Plug Account |  |  |  | 1 |  |  |  | 1
A schedule will need to be prepared for each subsidiary.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31