tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 61632d1262585162-excel-2007-whther-sumif-to-be-used-or-some-other-formula-may-work-sgn1
Sheet: Sheet1

CUSTID | CLOSDT | OSNPADT
D10369761 | 2009-01-20 00:00:00 | -410016 | 0
550217806 | 16-06-2009 | -494361 | 0
D10559482 | 30-11-2009 | -386493 | 0
APU000039 | 2007-12-02 00:00:00 | -58241 | 0
D10097040 | 2003-01-08 00:00:00 | -100 | 0
550217772 | 23-02-2008 | -27969 | 1
550217772 |  | -143182 | 1
550217772 |  | -300000 | 0
550144835 |  | -270824 | 0
D10559482 |  | -583652 | 0
550088198 |  | -355257.1 | 0
550087896 |  | -349779 | 0
550087030 | 27-07-2005 | -43561 | 0
550972051 | 2008-04-04 00:00:00 | -5788 | 0
551414929 | 2008-04-04 00:00:00 | -17198 | 0
551344092 | 2008-04-04 00:00:00 | -1429 | 0
551359310 | 2008-04-05 00:00:00 | -15356 | 0
551371692 | 2008-04-10 00:00:00 | -100 | 0
550900962 | 2008-04-10 00:00:00 | -825511 | 0
550896707 | 2008-04-10 00:00:00 | -19217 | 0
550972049 | 2008-04-11 00:00:00 | -6261 | 0
D10442532 | 2008-04-11 00:00:00 | -22627 | 0
551371817 | 2008-04-12 00:00:00 | -10467 | 0
551372208 | 2008-04-12 00:00:00 | -7608 | 0
551372069 | 2008-04-12 00:00:00 | -43391 | 0
551372260 | 2008-04-12 00:00:00 | -100 | 0
551372277 | 2008-04-12 00:00:00 | -100 | 0
551372295 | 2008-04-12 00:00:00 | -100 | 0 |  | I want to sum amount outstanding in Column C, corresponding to a customer id in column A
551372297 | 2008-04-12 00:00:00 | -100 | 0
551372429 | 2008-04-12 00:00:00 | -100 | 0
551372448 | 2008-04-12 00:00:00 | -100 | 0
551372224 | 2008-04-12 00:00:00 | -100 | 0
Spreadsheet: 97376d1296582469-dynamc-vlookup-country-code-lookup
Sheet: Sheet2

Country | Region
Albania | EMEA - South
[NAME] and [NAME] | MCC
Argentina | MCC
Armenia | EMEA - South
Aruba | MCC
Australia | Asia Pacific
Austria | EMEA - North
Bahrain | EMEA - South
Bangladesh | Asia Pacific
Belarus | EMEA - South
Belgium | EMEA - North
Belize | MCC
Benin | EMEA - South
Bolivia | South America
Bosnia and Herzegovina | EMEA - South
Brazil | South America
[NAME] | Asia Pacific
Bulgaria | EMEA - South
[NAME] | EMEA - South
Cambodia | Asia Pacific
Canada | North America
Cayman Islands | MCC
Chile | South America
China | Asia Pacific
Colombia | MCC
Cook Islands | Asia Pacific
Costa Rica | MCC
Croatia | EMEA - South
Cyprus | EMEA - South
Czech Republic | EMEA - South
Denmark | EMEA - North
Dominican Republic | MCC
Ecuador | MCC
Egypt | EMEA - South
El Salvador | MCC
Estonia | EMEA - South
Fiji | Asia Pacific
Finland | EMEA - North
France | EMEA - South
Germany | EMEA - North
Ghana | EMEA - South
Greece | EMEA - South
Guatemala | MCC
Haiti | MCC
Honduras | MCC
Hong Kong | Asia Pacific
Hungary | EMEA - South
India | Asia Pacific
Indonesia | Asia Pacific
Ireland | EMEA - South
Italy | EMEA - South
Jamaica | MCC
Jordan | EMEA - South
Kazakhstan | EMEA - South
Kenya | EMEA - South
Kuwait | EMEA - South
Latvia | EMEA - South
Lebanon | EMEA - South
Lithuania | EMEA - South
Luxembourg | EMEA - South
Macao | Asia Pacific
Macedonia, The Former Yugoslav Republic of | EMEA - South
[NAME] | EMEA - South
Malaysia | Asia Pacific
Maldives | Asia Pacific
[NAME] | EMEA - South
Mexico | MCC
Mongolia | Asia Pacific
Montenegro | EMEA - South
Morocco | EMEA - South
Mozambique | EMEA - South
Nepal | Asia Pacific
Netherlands | EMEA - North
Netherlands Antilles | MCC
New Zealand | Asia Pacific
Nicaragua | MCC
Niue | Asia Pacific
Oman | EMEA - South
Pakistan | Asia Pacific
Panama | MCC
[NAME] | Asia Pacific
Paraguay | South America
Peru | MCC
Philippines | Asia Pacific
Poland | EMEA - South
Portugal | EMEA - South
Puerto Rico | MCC
Qatar | EMEA - South
Reunion | EMEA - South
Romania | EMEA - South
Russian Federation | EMEA - South
Samoa | Asia Pacific
Saudi Arabia | EMEA - South
Senegal | EMEA - South
Serbia | EMEA - South
Singapore | Asia Pacific
Slovakia | EMEA - South
Slovenia | EMEA - South
Solomon Islands | Asia Pacific
South Africa | EMEA - South
Spain | EMEA - South
[NAME] | Asia Pacific
Suriname | MCC
Sweden | EMEA - North
Switzerland | EMEA - North
Tanzania, United Republic of | EMEA - South
Togo | EMEA - South
Tonga | Asia Pacific
Trinidad and Tobago | MCC
Tunisia | EMEA - South
Turkey | EMEA - South
Uganda | EMEA - South
Ukraine | EMEA - South
United Arab Emirates | EMEA - South
United Kingdom | EMEA - South
United States | North America
Uruguay | South America
[NAME] | Asia Pacific
Venezuela | MCC
Viet Nam | Asia Pacific
Virgin Islands, U.S. | MCC
Zimbabwe | EMEA - South
Spreadsheet: 3f190b49-f3c1-4ce6-a860-fed9c2e0a7bd
Sheet: 8d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Fixed-Float | 9743 | 4674 | 16485 | 2596
OTHER* | 2919 | 4359 | 147 | 1595
TOTAL | 12662 | 9033 | 16632 | 4191
*OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, FRA,  Inflation, OIS, and Swaption.
Spreadsheet: 163530d1340351915-excel-2007-match-and-colour-the-amounts-between-dr-and-cr-stimulation_xls
Sheet: Sheet1

Invoice# | DR | Invoice# | CR
a | 12 | a | 12
c | 10 | f | 40
b | 40 | d | 10
e | 25 | h | 15
d | 15 | e | 20
Spreadsheet: a3d85e89-4267-4bbf-a18a-d08665cae770
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
UPHB | Test | UPHB | pH, [NAME] | pH, BF | [NAME] | [NAME] tube: PolyTb |  |  | 5 | mL | Container/Tube: Metal-free container (Supply T173) [NAME]: 5 mL Additional Information: Indicate specimen source. | 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Chest fluid, pleural fluid, spinal fluid, or thoracic fluid | Varies with fluid type and location. | Monday through Sunday; Continuously | Same day/1 day | 1 day | 1 | 83986 |  |  |  |  | Rochester
UPHB | [NAME] | BODYFL | Body Fluid |  |  |  | Refrigerated | 7 days
UPHB | Order Question | SRC18 | Source |  | Answer List
UPHB | Option | SRC18-1 | Abdominal
UPHB | Option | SRC18-2 | Ascites
UPHB | Option | SRC18-3 | Gastric
UPHB | Option | SRC18-4 | Lavage
UPHB | Option | SRC18-5 | Paracentesis
UPHB | Option | SRC18-6 | Parenteral
UPHB | Option | SRC18-7 | Pericardial
UPHB | Option | SRC18-8 | Peritoneal
UPHB | Result | U_PHB | pH, BF | pH, BF | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2748-2
UPHB | Result | SRC18 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
Spreadsheet: jeff_dasovich__14064__Timewar_Jeff Calculations
Sheet: Deal Analysis

 |  |  | EXHIBIT 2
 |  | Deal and Share Price Analysis
 |  | 52-Week High | Low | 52-week Average | Day Prior to Time's Bid for Warner | Price on 6/6/89
Time 52 week trading range |  | 135.5 | 93 |  | 109.125 | 126
Warner 52 week trading range |  | 52.75 | 32.375 |  | 45.875 | 51.75
Shares outstanding (millions)
Time | 57
Warner | 178.3
Deal Value |  | High | Low | 52-week Average | Day Prior to Time's Bid for Warner | Price on 6/6/89
Shares of Time/Shares of Warner | 0.465
Total shares Time offered (millions)
Total Value of Time offer ($[NAME])
Per share value
DCF Value ($MM)--13% WAAC/9-12X multiple |  | 13188 | 11760
DCF per share Value |  | 71.86 | 64.08
Spreadsheet: 136503d1326702303-excel-2007-using-countif-to-calculate-values-for-a-4th-cell-tcas
Sheet: Sheet1

A/1 | B | C | D | E | F | G | H | I | J |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Location |  | MM |  | Clean
2 | Date | Location | MM | Unit 1 | Unit 2 | Unit 3 | Coaches | Clean | Rating |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GLD |  | WAH |  | Standard
3 | 13.01.12 | GLD | WAH | 150034 |  |  |  | Turn Around | 0.735 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BM |  | RO |  | Turn Around
4 | 13.01.12 | BM | ATB | 144202 | 150132 |  |  | Standard | 0.66 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FNH |  | ATB
5 | 13.01.12 | BM | ATB | 150008 | 150034 | 150323 |  | Standard | 0.568 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WOK |  | RB
6 | 13.01.12 | FNH | RO | 445708 | 445292 |  |  | Standard | 0.99
7 | 14.01.12 | WOK | RB | 144087 | 144034 |  |  | Turn Around | 0.55
8 | 14.01.12 | FNH | WAH | 150123 | 150067 |  |  | Standard | 0.556
9 | 14.01.12 | WOK | RB | 158008 | 158028 |  |  | Standard | 0.44
Spreadsheet: 871803d1718210322-how-to-count-and-determine-of-filtered-data-efrollingamount
Sheet: Sheet1

Path | Race | On | Off | Total | Box
1 | B4 | [NAME] | 740a |  | B
1 | [NAME] | [NAME] | 740a |  | G
1 | K2 | 715a | 740a |  | K
1 | F1 | 659a | 740a |  | F
1 | K1 | 704a | 740a |  | K
2 | A1 | 708a | 740a |  | A
2 | J1 | 718a | 740a |  | J
2 | B2 | [NAME] | 740a |  | B
2 | H1 | 300p | 332p |  | H
2 | E1 | 300p | 322p |  | E
1 | G3 | 255p | 331p |  | G
2 | G2 | 300p | 317p |  | G
1 | B1 | 255p | 336p |  | B
1 | D1 | 255p | 323p |  | D
1 | B3 | 255p | 323p |  | B
1 | C1 | 255p | [NAME] |  | C
 | 3
 |  |  |  | 17.6
Spreadsheet: 151433d1334918374-multiple-look-up-results-eta-look-up
Sheet: Data

1234 | PO Number | Lines | Sage Order Date | Part Number | Description | Qty Ordered | Qty Out | Web Date | Web Confirmation | Pi Received Date | Pi Number | Etd | Date Dispatached | Invoice Number | Eta
6993Z014780-H | 6993 | 4 | 40913 | Z014780-H | PULLEY | 50 | 22 |  |  |  |  |  | 2012-03-10 00:00:00 | 9000952840 | 2012-04-24 00:00:00
6994Z014780-H | 6994 | 91 | 40913 | Z014780-H | PULLEY | 5 | 5 |  |  |  |  |  | 2012-03-07 00:00:00 | 9000952830 | 2012-04-21 00:00:00
7548Z014780-H | 7548 | 3 | 40991 | Z014780-H | PULLEY | 5 | 5 |  |  |  |  |  | #N/A |  | #N/A
Spreadsheet: ec79ee45-36af-48ef-a549-bc9316c03f48
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: New Residential Construction
 |  | Housing Units Under Construction: United States
 |  | Not Seasonally Adjusted Single-family Units [Thousands of Units]
 |  | Period: 2008 to 2012
 |  | Data Extracted on: March 12, 2014 (3:58 pm)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2008 | 559.2 | 548.1 | 540.5 | 542.5 | 535.9 | 525.2 | 513.7 | 504.7 | 476.7 | 451.7 | 417.3 | 377.3
2009 | 360.4 | 346.3 | 331.4 | 323.6 | 320 | 323.7 | 330.4 | 327.3 | 327.9 | 315.7 | 300.8 | 283.1
2010 | 283.4 | 287 | 295.8 | 304.7 | 306 | 290.9 | 290.8 | 287.5 | 280.9 | 270.5 | 265 | 247.3
2011 | 245.3 | 238.4 | 243.6 | 246.7 | 249.7 | 253.4 | 253.9 | 250.6 | 248.2 | 241.6 | 234.9 | 221.6
2012 | 227.7 | 230.2 | 236.5 | 245 | 255.1 | 265.7 | 275.5 | 279.8 | 283.8 | 282.7 | 278.6 | 267.7
Spreadsheet: 255d1d53-7ccd-4a35-bf07-699b18e73cc7
Sheet: 14d

 | Swap Dealers/MSPs5 |  |  | Others
Product1 | HY6 | IG | Other | HY | IG | Other
Index Tranche | 4 | 0 | 1 | 2 | 0 | 1
Index | 1330 | 1726 | 3917 | 3217 | 2708 | 4064
OTHER* | 0 | 0 | 39 | 0 | 0 | 23
TOTAL | 1334 | 1726 | 3957 | 3219 | 2708 | 4088
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: mary_fischer__25627__1292
Sheet: E14.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  1292
COMPANY NAME    Marlin Fair Value Co.
ANALYSIS OF OTHER DEFERRED CREDITS
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
 |  | 12-31-2000 Balance |  |  |  | Charged to |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Pd / (Rec'd) |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(1)  PROVIDE DETAIL OF INDIVIDUAL ITEMS IN EXCESS OF $200,000
(2)  USE COMMENTS SECTION TO PROVIDE AN EXPLANATION OF WHY ANY REVENUE
ITEMS ARE DEFERRED AND WHAT EVENT WILL CAUSE REVENUE RECOGNITION
OTHER DEFERRED CREDITS:
 |  | 0
Total (Hyperion line 0860)
Asset/Expense Accts:  DR/(CR)
Reverse signs from Hyperion
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
Spreadsheet: 877916d1724851734-index-and-match-function-not-working-help-aop-per-tech
Sheet: Top

Tech | Level | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Average | Helper | [NAME] | Objective | Rate | Payout |  |  | AVG | A | B | C
[NAME], | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 2.5 | 2.25 | 2
THOAI LE, | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 2 | 1.75 | 1.75
[NAME], | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 1.5 | 1.5 | 1.5
DIEGO MERCADO, | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 1.25 | 1.25 | 1.25
MASON SHAWN, | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 1 | 1 | 1
[NAME], | B
[NAME], | B
TRAVIS GREGORY, | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Level | 10 | 11 | 12 | 13 | 14
TYLER MUNGER, | C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | 1 | 1.25 | 1.5 | 2 | 2.5
TYLER BIXLER, | C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | 1 | 1.25 | 1.5 | 1.75 | 2.25
RYAN GUAGENTI, | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | 1 | 1.25 | 1.5 | 1.75 | 2
ANZOR KHATAEV, | B
FLORES GUARDADO, | A
[NAME], | B
GUARDADO RODAS, | C
SHAWN GROOVER, | C
SHANE GILLESPIE, | B
SIMON NELSON, | B
[NAME], | C
[NAME], | A
[NAME], | B
DONOVAN OCONNOR, | C
COELLO VALLEJO, | B
[NAME], | C
GILBERTO GALENOCAMPOS, | C
[NAME], | C
[NAME], | C
[NAME], | C
JOSHUA MATUDAN, | C
Spreadsheet: 94982d1294711117-automatic-averaging-for-ties-golf_ranks
Sheet: Sheet1

Pos | Prize |  |  | [NAME] | Score | Rank | Payout
1 | 10000 |  |  | [NAME]
2 | 8000 |  |  | [NAME]
3 | 5000 |  |  | [NAME]
4 | 2000 |  |  | [NAME]
5 | 1000 |  |  | [NAME]
 |  |  |  | [NAME]
Spreadsheet: 684969d1593637656-problems-making-a-sheet-for-parent-sku-titles-left-of-special-characters-parts
Sheet: Sheet1

Variation Parent SKU | Attribute1Value | First words
198 | [NAME] 1000 Grease Tube, 4oz
198 | [NAME] 1000 [NAME], 16oz
208 | ProGold EPX Grease Tub: 16oz |  |  |  | Row Labels
208 | Progold EPX Grease Tube:3oz |  |  |  | Boeshield T9 Bike Chain Lube
227 | Boeshield T9 Bike Chain Lube - 1 fl oz, Drip |  |  |  | Finish Line DRY Bike Chain Lube
227 | Boeshield T9 Bike Chain Lube - 4 fl oz, [NAME] |  |  |  | Finish Line WAX Bike Chain Lube
227 | Boeshield T9 Bike Chain Lube - 12 fl oz, [NAME] |  |  |  | Finish Line WET Bike Chain Lube
227 | Boeshield T9 Bike Chain Lube - 4 fl oz, Drip |  |  |  | [NAME] 1000 Grease Tub
231 | Finish Line DRY Bike Chain Lube - 32 fl oz, [NAME] |  |  |  | [NAME] 1000 Grease Tube
231 | Finish Line DRY Bike Chain [NAME] fl oz, Drip, [NAME] of 30 |  |  |  | ProGold EPX Grease Tub
231 | Finish Line DRY Bike Chain [NAME] fl oz, Drip |  |  |  | Progold EPX Grease Tube
231 | Finish Line DRY Bike Chain Lube - 4 fl oz, Drip |  |  |  | Grand Total
231 | Finish Line DRY Bike Chain Lube - 17 fl oz, [NAME]
231 | Finish Line DRY Bike Chain [NAME] fl oz, [NAME]
231 | Finish Line DRY Bike Chain Lube - 1 Gallon, [NAME]
231 | Finish Line DRY Bike Chain [NAME] fl oz, Drip
232 | Finish Line WET Bike Chain Lube - 1 Gallon, [NAME]
232 | Finish Line WET Bike Chain Lube - 4 fl oz, Drip
232 | Finish Line WET Bike Chain Lube - 32 fl oz, [NAME]
232 | Finish Line WET Bike Chain Lube - 2 fl oz, Drip
232 | Finish Line WET Bike Chain Lube - 8 fl oz, [NAME]
232 | Finish Line WET Bike Chain Lube - 8 fl oz, Drip
233 | Finish Line WAX Bike Chain [NAME] fl oz, Drip
233 | Finish Line WAX Bike Chain Lube - 4 fl oz, Drip
233 | Finish Line WAX Bike Chain Lube - 32 fl oz, [NAME]
233 | Finish Line WAX Bike Chain [NAME] fl oz, Drip
Spreadsheet: 723262d1615579130-data-extraction-from-another-sheet-based-on-date-data-extract
Sheet: Summary

 | Enter Date Here | 2021-03-12 00:00:00
Spreadsheet: 190d0633-e9aa-4b4e-9965-29adb0bbf50d
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
42771991 | 2014-08-18 05:38:37 | AXIS | 1 | 6 | 4 | 1620635 | [NAME] | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42772486 | 2014-08-18 06:06:11 | ALLIES | 0 | 3 | 6 | 1620635 | [NAME] | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42785225 | 2014-08-19 03:55:33 | AXIS | 0 | 4 | 6 | 1602528 | player1602528 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42785509 | 2014-08-19 04:16:41 | ALLIES | 1 | 6 | 2 | 1602528 | player1602528 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42861556 | 2014-08-24 16:51:46 | AXIS | 0 | 5 | 6 | 1135243 | andrych | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42861932 | 2014-08-24 17:13:12 | ALLIES | 1 | 6 | 4 | 1135243 | andrych | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42881579 | 2014-08-25 23:43:27 | ALLIES | 1 | 6 | 5 | 1087185 | [NAME] | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42882075 | 2014-08-26 00:07:31 | AXIS | 1 | 6 | 4 | 1087185 | [NAME] | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42885948 | 2014-08-26 06:37:27 | AXIS | 0 | 5 | 6 | 1577626 | maniaku | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42886208 | 2014-08-26 06:51:23 | ALLIES | 1 | 6 | 1 | 1577626 | maniaku | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42891497 | 2014-08-26 18:03:14 | AXIS | 0 | 1 | 6 | 1294353 | gkhan | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42891669 | 2014-08-26 18:25:56 | ALLIES | 1 | 6 | 5 | 1294353 | gkhan | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
Spreadsheet: 114d9fbb-0eb6-4985-a81a-ebd7afca8354
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | SINGLE FAMILY VALUATION/
 | FIRE SPRINKLER WORKSHEET 2001.1
 | Job Address:
 | A | USE | SQ. FT. |  | VALUE |  |  |  | VALUATION*
 |  | EXISTING NON-SPRINKLED BUILDING
 |  | LIVABLE / CONDITIONED AREA |  | X | 107.08 |  |  | = | 0
 |  | BASEMENT - UNFINISHED |  | X | 40.62 |  |  | = | 0
 |  |  |  |  |  | TOTAL A |  | = | 0
 | B | GARAGE |  | X | 40.62 |  |  | = | 0
 |  | CARPORT |  | X | 40.62 |  |  | = | 0
 |  | COVERED PATIO |  | X | 40.62 |  |  | = | 0
 |  |  |  |  |  | TOTAL B |  | = | 0
 | C | TOTAL EXISTING VALUE, (A+B) |  |  |  | TOTAL C |  | = | 0
 | D | FACTORED EXISTING VALUE | 0 | X | 0.25 | TOTAL D |  | = | 0
 | E | NEW CONSTRUCTION/ADDITION
 |  | LIVABLE / CONDITIONED AREA |  | X | 107.08 |  |  | = | 0
 |  | BASEMENT - UNFINISHED |  | X | 40.62 |  |  | = | 0
 |  |  |  |  |  | TOTAL E |  | = | 0
 | F | GARAGE |  | X | 40.62 |  |  | = | 0
 |  | CARPORT |  | X | 40.62 |  |  | = | 0
 |  | COVERED PATIO |  | X | 40.62 |  |  | = | 0
 |  |  |  |  |  | TOTAL F |  | = | 0
 | G | REMODELED AREAS, includes work requiring permit per  IRC 105.2 amended.
 |  | LIVABLE / CONDITIONED AREA |  | X | 107.08 | X | 0.3 | = | 0
 |  | GARAGE |  | X | 40.62 | X | 0.3 | = | 0
 |  | CARPORT |  | X | 40.62 | X | 0.3 | = | 0
 |  | COVERED PATIO |  | X | 40.62 | X | 0.3 | = | 0
 |  | BASEMENT - UNFINISHED |  | X | 40.62 | X | 0.3 | = | 0
 |  |  |  |  |  | TOTAL G |  | = | 0
 | H | TOTAL NEW AND [NAME], (E+F+G) |  |  |  | TOTAL H |  | = | 0
 | IF H >D FIRE SPRINKLERS WILL BE REQUIRED
 | 0
 | * Values per http://www.iccsafe.org/cs/Pages/BVD.aspx, June, 2013. |  |  |  |  |  | revised 1/2/2014
 | The scope of work and related square footages provided are subject to field verification.  Where discrepancies are encountered by the inspector, work shall stop and a new worksheet shall be completed, inclusive of the entire known scope of work.  Sprinklers shall be installed if indicated on the revised worksheet.
Spreadsheet: 105286d1302696105-rearrange-data-based-on-name-and-date-copy-of-pleaseview
Sheet: Sheet1

Name | Value |  |  |  |  | sort as:
17/03/2011
aaa | 1
bbb | 3
[NAME] | 5
ddd | 7
18/03/2011
aaa | 34
bbb | 5
[NAME] | 7
ddd | 8
19/03/2011
aaa | 67
bbb | 8
[NAME] | 9
ddd | 0
Spreadsheet: 35445d1233052670-countifs-setting-multiple-criteria-exccelforumhelp2
Sheet: Sheet1

1-10 | 11-20 | 21-30 | 31-40 | 41-49 |  | 1-10 | 11-20 | 21-30 | 31-40 | 41-49 |  | Frequency
1 | 1 | 0 | 1 | 1 |  | 1 | 1 | 0 | 1 | 1 |  | 2 | coz row 2 &4
1 | 1 | 0 | 2 | 2 |  | 1 | 1 | 0 | 2 | 2 |  | 1 | coz row 3
1 | 1 | 0 | 1 | 1 |  | 6 | 0 | 0 | 0 | 0 |  | 0
1 | 2 | 2 | 0 | 1
3 | 2 | 1 | 1 | 0
3 | 2 | 0 | 2 | 2
2 | 2 | 0 | 0 | 2
0 | 2 | 1 | 1 | 2
1 | 1 | 2 | 0 | 2
2 | 1 | 3 | 0 | 0
2 | 1 | 1 | 1 | 1
1 | 2 | 2 | 1 | 0
Spreadsheet: 374476d1422883677-conditional-formatting-to-selected-cells-only-book1
Sheet: Sheet1

Location | Forecast
Mexcio | 2015-01-30 00:00:00
Turkey | 2015-02-05 00:00:00
China | 2015-02-06 00:00:00
India | 2015-02-07 00:00:00
USA | 2015-02-08 00:00:00
Argentina | 2015-02-09 00:00:00
Brazil | 2015-02-10 00:00:00
Canada | 2015-01-25 00:00:00
Japan | 2015-01-26 00:00:00
Indonesia | 2015-01-27 00:00:00
Australia | 2015-01-28 00:00:00
New Zealand | 2015-01-29 00:00:00
Pakistan | 2015-01-30 00:00:00
Spreadsheet: 670027d1585722856-automatic-invigilation-duty-list-in-excel-exam-duty-list
Sheet: Data

Name
Teacher 1 |  |  |  |  |  | Total No Students | 475
Teacher 2 |  |  |  |  |  | Students per Teacher | 30
Teacher 3 |  |  |  |  |  | Total Class rooms for exam |  | I want to round the value in H4 to nearest higher value. For example here 16
Teacher 4 |  |  |  |  |  |  |  | H4 value will change depends on the number of students for each semester. H2 will be changing for each exam
Teacher 5 |  |  |  |  |  |  |  | Number of room numbers should be according to total no students and students per teacher.
Teacher 6
Teacher 7
Teacher 8
Teacher 9
Teacher 10
Teacher 11
Teacher 12
Teacher 13
Teacher 14
Teacher 15
Teacher 16
Teacher 17
Teacher 18
Teacher 19
Teacher 20
Teacher 21
Teacher 22
Teacher 23
Teacher 24
Teacher 25
Teacher 26
Teacher 27
Teacher 28
Teacher 29
Teacher 30
Teacher 31
Teacher 32
Teacher 33
Teacher 34
Teacher 35
Teacher 36
Teacher 37
Teacher 38
Teacher 39
Teacher 40
Teacher 41
Teacher 42
Teacher 43
Teacher 44
Teacher 45
Teacher 46
Teacher 47
Teacher 48
Teacher 49
Teacher 50
Teacher 51
Teacher 52
Teacher 53
Teacher 54
Teacher 55
Spreadsheet: 165609d1341295597-formula-to-check-pre-defined-list-and-show-relevant-info-formula-sample
Sheet: Sheet1

Item | full tote qty | Code
702/0007 | 156 | 1958340
702/0014 | 70 | 1467714
702/0021 | 156 | 1958342
702/0038 | 132 | 1958341
702/0052 | 156 | 1937820
702/0069 | 156 | 1937824
702/0076 | 132 | 1937822 |  |  |  |  |  |  | User enters full qty
702/0090 | 156 | 1996163 |  |  |  |  |  |  |  |  |  |  | User enters Item
702/0100 | 78 | 2195443
702/0117 | 156 | 1996169
702/0131 | 156 | 1937840
702/0526 | 100 | 2275363
 |  |  |  |  |  |  | Contains | Qty | x | 201 | CAT | Number | 702/0526
 | [NAME] splits the qty into full totes |  |  |  |  |  | 2 | Tote | = |  | units | per | tote
 |  | [NAME] adds remainder of qty |  |  |  |  | 1 | Tote | = | 1 | units | per | tote
 |  |  |  |  |  |  |  |  | Total | of |  | Totes
 |  |  |  |  |  |  |  |  | [NAME] counts total number of totes
Spreadsheet: 808469d1670487548-combine-2-sheets-analysis3
Sheet: 5 BEST AND WEK FEMALE STUDENT

I. FIVE BEST FEMALE STUDENTS
NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D
1
2
3
4
5
J. FIVE WEAK FEMALE STUDENTS
NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D
1
2
3
4
5
Spreadsheet: 221538d1363606523-count-occurance-of-particular-name-or-text-in-column-match1
Sheet: Sheet1

Column A | Column B
Ram | 3
[NAME] | 2
[NAME] | 2
Bharat | 2
Ram | 3
Bharat | 2
[NAME] | 2
Ram | 3
[NAME] | 2
Mac | 1