tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 120744d1315494824-projected-component-change-outs-budget
Sheet: 5207

5207 |  |  |  | Current Hours |  | Year
 |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
 |  |  |  |  |  | 744 | 696 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 744 | 672 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 2160 | 2184 | 2208 | 2208 | 2160 | 2184 | 2208 | 2208 | 2184 | 2184 | 2208 | 2208
 |  |  |  |  | Projected 2011 End | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th
Projected Future Hours
Spreadsheet: 17a9a3f4-ef70-4d21-bdf5-bc4a7aefe7a9
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Prévention des inégalités d’accès au numérique | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
[NAME] se mobilise |  |  | L’informatique en libre accès dont vous avez besoin
 | Matériel disponible | Conditions d’usage | Accéder à son Espace Numérique de Travail. | Consulter ou télécharger mes cours en ligne. | Visionner ou télécharger un podcast. | Rechercher une information  sur Internet. | Consulter une encyclopédie en ligne. | Produire des documents électroniques. | Analyser des données statistiques. | Analyser des données textuelles. | Imprimer des documents. | S’exercer en langues. | Préparer le C2i. | Emprunter un micro ordinateur portable.
Bibliothèque Centrale | 30 | Libre accès | oui | oui | oui | oui | oui | oui | oui | oui | oui | non | oui | non
 | 50 | Libre accès mais usages limités | non | non | non | non | oui | non | non | non | non | non | oui | non
BU Géographie | 1 | Libre accès | oui | oui | non | oui | oui | non | non | non | non | non | oui | non
 | 1 | Accès limité | non | non | non | non | oui | non | non | non | non | non | oui | non
BU Histoire | 4 | Accès limité mais usage limité à la consultation du  catalogue | non | non | non | non | oui | non | non | non | non | non | oui | non
 | 5 | Libre accès | oui | oui | ? | oui | oui | oui | non | oui | non | non | oui | non
Centre de Ressources Informatique pour l'Enseignement | 74 | Libre accés de 9h00 à 16h00 | oui | oui | non | oui | oui | oui | oui | oui | oui (uniquement du poste du moniteur) | oui | oui | non
DIVE | 3 | Accès réservé aux personnes handicapés | oui | oui | ? | oui | oui | oui | oui | oui | oui | oui | oui | non
Atelier informatique MDR | 15 | Accès limité aux doctorants | oui | oui | oui | oui | oui | oui | oui | oui | oui | oui | oui | non
Pavillon de la recherche | 15 | Libre accès le lundi matin, [NAME] et [NAME] | oui | oui | oui | oui | oui | oui | oui | oui | oui | non | oui | [NAME] pour réunion
DPT Sociologie | 20 | Accès limité (information auprès [NAME]) | oui | oui | oui | oui | oui | oui | oui | oui | non | non | oui | non
UFR Psychologie | 20 | Libre accés | oui | oui | non | oui | oui | non (en projet) | non | non | non | non | oui | non
Département des sciences de l'éducation | 11 | Accès réservé au M1 et M2 | oui | oui | oui | oui | oui | oui | oui | oui | oui | oui | oui | non
Bâtiment des langues | 110 | Libre accès | oui | oui | oui | oui | oui | oui | oui | oui | oui | oui | oui | non
Tutorat informatique Histoire | 20 | Accès limité (information auprès [NAME]) | oui | oui | oui | oui | oui | oui | oui | oui | oui | ? | oui | ?
[NAME] | 87 | Accès limité en fonction des horaires (information auprès [NAME]) | oui | oui | oui | oui | oui | oui | oui | non | oui | non | oui | non
Sciences langage | 20 | Accès limité (information auprès [NAME]) | oui | oui | oui | oui | oui | oui | ? | oui | oui | oui | oui | non
Spreadsheet: 4bbe9bb1-ba83-492c-911f-0d7eba851716
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-06-09 09:36:03.760000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.75 | 102.625 | 102.5 | 102.125
4.5 | 102.403 | 102.278 | 102.153 | 101.778 |  | Note: | Refer To Price [NAME]
4.375 | 101.664 | 101.539 | 101.414 | 101.039 |  |  | For all Price Adjs
4.25 | 101.072 | 100.947 | 100.822 | 100.197
4.125 | 100.235 | 100.11 | 99.985 | 99.36
4 | 99.234 | 99.109 | 98.984 | 98.359
3.875 | 98.189 | 98.064 | 97.939 | 97.314
3.75 | 97.314 | 97.189 | 97.064 | 96.439
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 102.583 | 102.458 | 102.333 | 101.958
3.625 | 102.194 | 102.069 | 101.944 | 101.569
3.5 | 101.645 | 101.52 | 101.395 | 101.02
3.375 | 100.927 | 100.802 | 100.677 | 100.302
3.25 | 100.178 | 100.053 | 99.928 | 99.303
3.125 | 99.644 | 99.519 | 99.394 | 98.769
3 | 98.894 | 98.769 | 98.644 | 98.019 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-06-23 09:36:03.760000
30 DAY | 2014-07-08 09:36:03.760000
45 DAY | 2014-07-23 09:36:03.760000
60 DAY | 2014-08-07 09:36:03.760000
90 DAY | 2014-09-06 09:36:03.760000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 739560d1625773064-fuzzy-match-without-fuzzy-lookup-add-in-power-query-and-vba-search
Sheet: Sheet1

Sumsung |  |  | Microsoft | LG
LG
[NAME]
Sumsung Ltd
Sumsung Corp
Microsoft
The LG
Microsoft Inc
Spreadsheet: 65847d1266498460-summing-with-variables-book1
Sheet: Sheet1

2010-02-18 00:00:00 | 1 | HH | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  | 1 | 1 | SV | 1 | 1 | HH | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  | #N/A
Spreadsheet: kam_keiser__17776__Trader Request (NG70)
Sheet: Volume

Month | FIN/PHY | Volume | Total Deals
1/1/1999 | FIN | 2476499096.09 | 13854
1/1/1999 | PHY | 4068105.26 | 7915
2/1/1999 | FIN | 2256259251.66 | 13567
2/1/1999 | PHY | -2313800.43 | 7707
3/1/1999 | FIN | 2968951334.16 | 13942
3/1/1999 | PHY | -14585744.49 | 7869
4/1/1999 | FIN | 2231530339.09 | 11660
4/1/1999 | PHY | -80105002.16 | 7242
5/1/1999 | FIN | 2391110490.54 | 13015
5/1/1999 | PHY | -88437440.5 | 7394
6/1/1999 | FIN | 2468062120.83 | 13867
6/1/1999 | PHY | -103765617.62 | 7388
7/1/1999 | FIN | 2648734713.9 | 15693
7/1/1999 | PHY | -41355540.1 | 7791
8/1/1999 | FIN | 2540753453.65 | 16874
8/1/1999 | PHY | -43726938.06 | 7843
9/1/1999 | FIN | 3415065718.85 | 18055
9/1/1999 | PHY | -38404636.46 | 7850
10/1/1999 | FIN | 3343121892.29 | 19621
10/1/1999 | PHY | -27963318.52 | 8166
11/1/1999 | FIN | 3146052376 | 17282
11/1/1999 | PHY | -10362554.27 | 7543
12/1/1999 | FIN | 4022733575.92 | 20094
12/1/1999 | PHY | -85892981.72 | 7787
1/1/2000 | FIN | 4427657710.68 | 22356
1/1/2000 | PHY | -154983314.26 | 9325
2/1/2000 | FIN | 3423714019.22 | 26018
2/1/2000 | PHY | -69776017.07 | 8792
3/1/2000 | FIN | 4585305993.23 | 29078
3/1/2000 | PHY | -128370740.81 | 9016
4/1/2000 | FIN | 3328962835.1 | 28754
4/1/2000 | PHY | -96793859.2 | 8344
5/1/2000 | FIN | 3052948767.36 | 31088
5/1/2000 | PHY | -40294496.28 | 8333
6/1/2000 | FIN | 3164506498.45 | 44737
6/1/2000 | PHY | -9758391.88 | 9067
7/1/2000 | FIN | 4509292062.97 | 53908
7/1/2000 | PHY | 131386148.78 | 8943
8/1/2000 | FIN | 3188658038.11 | 55185
8/1/2000 | PHY | 74109940.36 | 9108
9/1/2000 | FIN | 3483026740.03 | 59249
9/1/2000 | PHY | 8633143.91 | 9493
10/1/2000 | FIN | 3714530932.46 | 63198
10/1/2000 | PHY | -32903697.08 | 10359
11/1/2000 | FIN | 4113915064.95 | 77145
11/1/2000 | PHY | 100774622.14 | 10496
12/1/2000 | FIN | 4637504614.47 | 90567
12/1/2000 | PHY | 57902265.564 | 11550
1/1/2001 | FIN | 5416625564.175 | 91032
1/1/2001 | PHY | -81577286.082 | 10984
2/1/2001 | FIN | 4224739837.711 | 96484
2/1/2001 | PHY | 20422589.458 | 10948
3/1/2001 | FIN | 5790022340.013 | 99791
3/1/2001 | PHY | 160814665.931 | 11169
4/1/2001 | FIN | 4158680577.257 | 73492
4/1/2001 | PHY | -28538799.577 | 9316
5/1/2001 | FIN | 4447778443.164 | 77803
5/1/2001 | PHY | -152033150.942 | 10075
6/1/2001 | FIN | 4964847303.757 | 85690
6/1/2001 | PHY | -184018826.77 | 11209
7/1/2001 | FIN | 5441096501.398 | 99611
7/1/2001 | PHY | -205103470.451 | 12804
8/1/2001 | FIN | 6334038589.321 | 103145
8/1/2001 | PHY | -215710377.202 | 14034
9/1/2001 | FIN | 6906455596.477 | 102312
9/1/2001 | PHY | -103553071.028 | 11882
Spreadsheet: 800011d1665434568-count-and-display-duplicates-in-an-array-display_duplicates
Sheet: display_duplicates

COUNT AND DISPLAY DUPLICATES OF A COLUMN |  |  |  | (case-sensitive)
array: | =A8:A30
formula:
expected result: | 2 A, 3 B, 2 b
grade
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
Spreadsheet: 146296d1332063878-countif-accross-multiple-ranges-and-1-criteria-count-with-criteria
Sheet: Sheet1

 |  |  |  |  | Month1 |  |  | Month2 |  |  | Month3 |  |  | Month4 |  |  | Month5
Name | Apple | Orange | [NAME] |  | Apple | Orange | [NAME] | Apple | Orange | [NAME] | Apple | Orange | [NAME] | Apple | Orange | [NAME] | Apple | Orange | [NAME]
Employee 1 |  |  |  |  | 10 | 5 | 2 |  |  | 3 | 10 | 2 |  | 3 | 4 | 5 | 1 | 6
Employee 2
Spreadsheet: 01278659-9ebc-4e16-8589-4d92504e77a4
Sheet: Sheet1

Ref # | Part # | Description | Notes
CNS | [PHONE] | CNS ASSEMBLY DELUXE | Includes upper board and overlay with Tele receiver
HPS | [PHONE] | CONTACT HRT ASSEMBLY | Need 2 per console
N01 | 090030 | TOP CONSOLE COVER
N02 | 090057 | BOTTOM CONSOLE COVER
N04 | 1000094781 | TOUCH PAD ASSEMBLY
N08 | 102788 | HRT CONNECT WIRE GRIP TO RECEIVER | Need 2 per console
N09 | 090041 | END CAP HANDLEBAR | 1 needed per HPS unit ordered
N15 | 093151 | SLEEVE GRIP HANDLEBAR
N65 | 100658 | CONTACT HRT RECEIVER ASSEMBLY
N66 | 098161 | HEART RATE TELEMETRIC
[NAME] | 090088 | REED SWITCH
P01 | 005070-Z | WASHER FT 6.5X14X1
R01 | 055204-A | [NAME]
R02 | 004366-00 | SCREW BH M5X8
R03 | 020196-A | [NAME] M3x6L TAPPED
R05 | 004464-00 | SCREW HEX [NAME]
[NAME] | 065640-A | SCREW BH M3X30 | 2 per HPS unit ordered
[NAME] | 004880-00 | NUT HEX M3x0.5x3 | 2 per HPS unit ordered
R10 | 004612-00 | SCREW BH 3x8L TAPPED GAP
R11 | 004374-Z | SCREW BH M5X0.8X10
V09 | 103238 | DECAL VF
NOT SHOWN | 003307-00 | STRAP CHEST ASSEMBLY
NOT SHOWN | 013860-B | SAFETY KEY ASSEMBLY
NOT SHOWN | 1000097533 | OWNERS MANUAL
NOT SHOWN | 090658 | DATA CABLE 1820L
Spreadsheet: 100678d1298974295-overtime-calculations-times-amodprop
Sheet: Foglio2

 |  |  |  |  |  |  |  | 37,5 hours contracts |  | 20 hours contracts
Trade | Name | ID | Overtime Reason | Overtime Date | Overtime Time | Contracted Hours | Authorised Overtime | Premium Rate | Unsocial OT | Other OT | Enhanced OT
Chargehands | [NAME] | 12345 | A/L cover | 2011-02-19 00:00:00 | 06:00 - 23:45 | 20 | 17:45:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 17:30:00 | 00:15:00
Chargehands | [NAME] | 12346 | Additional Works (Income Generating) | 2011-02-17 00:00:00 | 20:00 - 7:00 | 37.5 | 11:00:00 | 01:00:00 | 10:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Chargehands | [NAME] | 12346 | Additional Works (Income Generating) | 2011-03-01 00:00:00 | 21:00 - 7:00 | 37.5 | 10:00:00 | 01:00:00 | 09:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Chargehands | [NAME] | 12346 | Additional Works (Income Generating) | 2011-03-01 00:00:00 | 06:00 - 23:45 | 37.5 | 17:45:00 | 14:00:00 | 03:45:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Chargehands | [NAME] | 12345 | A/L cover | 2011-03-01 00:00:00 | 17:00 - 20:00 | 20 | 03:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 03:00:00 | 1900-01-01 00:00:00
Chargehands | [NAME] | 12346 | Additional Works (Income Generating) | 2011-03-01 00:00:00 | 20:30 - 21:00 | 37.5 | 00:30:00 | 1900-01-01 00:00:00 | 00:30:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Chargehands | [NAME] | 12346 | Additional Works (Income Generating) | 2011-02-27 00:00:00 | 21:00 - 7:00 | 37.5 | 10:00:00 | 1900-01-01 00:00:00 | 10:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Spreadsheet: bb5300e0-aa58-46bc-8ceb-2e182106ae3a
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
FHBSA | Test | FHBSA | Hepatitis B Virus Surface Antigen, Confirmation | Hepatitis B Surface Ag, Confirm | Chemiluminescent Immunoassay |  |  |  |  |  | Submit only 1 of the following specimens:  Serum Draw blood in a plain, red-top tube(s). (Serum-gel tube is acceptable.) Separate from cells within 2 hours of collection. Send 2.5 mL of serum refrigerate in a plastic vial.   [NAME] blood in a lavender-top (EDTA) or pink-top ([NAME]) tube(s). Separate from cells within 2 hours of collection. Send 2.5 mL of EDTA plasma refrigerate in a plastic vial. | 1.5 mL | Hemolysis:	Mild OK; Gross reject Thawing:	Warm reject; Cold OK Lipemia:	Mild reject; Gross reject Icterus:	NA Other:	Heparinized plasma; specimens containing particulate material or obvious microbial contamination. Heat inactivated | Reference Range: Non Confirmed  Interpretive Information: Hepatitis B Surface Ag Confirmation   This assay should not be used for blood donor screening, associated re-entry protocols, or for screening [NAME], [NAME] and Cellular and Tissue-Based Products (HCT/P).  Test Performed by:	ARUP Laboratories 			500 [NAME], UT 84108 | Sunday through Saturday | 1 - 3 days | 3 - 7 days | 1 | 87341 |  |  |  |  | ARUP Laboratories
FHBSA | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
FHBSA | Result | FHBSA | Hepatitis B Surface Ag, Confirm | Hepatitis B Surface Ag, Confirm | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 852793d1702740065-index-match-array-returning-duplicate-values-test-dreadpiraterai-
Sheet: Sheet1

 |  |  | Service Average Scores | Self Determination | Emotional Well-being | Physical Well-being | Material Well-being | Rights | Personal Development | Social Inclusion | Interpersonal Relationships
 |  |  |  | 3 | 4 | 5 | 4 | 4 | 3 | 2 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SMALL | LARGE
Spreadsheet: daren_farmer__5032__HPLN0331
Sheet: Sheet1

HPLN0331.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - March 31, 2001
 |  |  |  |  |  | **Saturday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-03-30 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | LS Oasis Turbine |  | Enron | 0 | 0
Enron (S) |  | LS HPL [NAME] |  | Enron | 0 | 0
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 861610d1709502326-populate-an-amount-into-the-correct-column-based-on-a-weekly-paycheck-test-budget-formulas-mohamedgadallah
Sheet: New

 |  |  | PayDay >>>> | 2024-03-08 00:00:00 | 2024-03-15 00:00:00 | 2024-03-22 00:00:00 | 2024-03-29 00:00:00 | 2024-04-05 00:00:00 | 2024-04-12 00:00:00 | 2024-04-19 00:00:00 | 2024-04-26 00:00:00 | 2024-05-03 00:00:00 | 2024-05-10 00:00:00 | 2024-05-17 00:00:00 | 2024-05-24 00:00:00 | 2024-05-31 00:00:00 | 2024-06-07 00:00:00 | 2024-06-14 00:00:00 | 2024-06-21 00:00:00 | 2024-06-28 00:00:00 | 2024-07-05 00:00:00 | 2024-07-12 00:00:00 | 2024-07-19 00:00:00 | 2024-07-26 00:00:00 | 2024-08-02 00:00:00 | 2024-08-09 00:00:00 | 2024-08-16 00:00:00 | 2024-08-23 00:00:00 | 2024-08-30 00:00:00 | 2024-09-06 00:00:00 | 2024-09-13 00:00:00 | 2024-09-20 00:00:00 | 2024-09-27 00:00:00 | 2024-10-04 00:00:00 | 2024-10-11 00:00:00 | 2024-10-18 00:00:00 | 2024-10-25 00:00:00 | 2024-11-01 00:00:00 | 2024-11-08 00:00:00 | 2024-11-15 00:00:00 | 2024-11-22 00:00:00 | 2024-11-29 00:00:00 | 2024-12-06 00:00:00 | 2024-12-13 00:00:00 | 2024-12-20 00:00:00 | 2024-12-27 00:00:00
 | expense | amount | due date
 | donation | 256.54 | 7
 | Best Egg | 428.11 | 8
 | IRS | 400 | 12
 | Mortgage | 4000 | 1
 | gas budget | 150 | 7
 | [NAME] | 60 | 1
 | Synchrony | 375 | 18
 | Kia lease | 311.9 | 5
 | Progressive | 437.77 | 5
 | Groceries | 350 | 7
 |  |  | Total
Spreadsheet: 55639d1255728373-pivot-tables-help-on-pivot-tables
Sheet: Sheet1

 | Décompte des demandes |  | Type | État de la tâche
 |  |  | INSTALL |  | INSTALL Total
 | Installation week planned | MSS | COMPLÉTÉ | OUVERT
 | Semaine du 21 Septembre 2009 | George | 35 | 11 | 46
 |  | [NAME] | 5 | 3 | 8
 | Semaine du 21 Septembre 2009 Total |  | 40 | 14 | 54
 | Semaine du 28 Septembre 2009 | George | 1 | 28 | 29
 | Semaine du 28 Septembre 2009 Total |  | 1 | 28 | 29
 | Semaine du 5 Octobre 2009 | George |  | 4 | 4
 | Semaine du 5 Octobre 2009 Total |  |  | 4 | 4
 | Grand Total |  | 41 | 46 | 87
Spreadsheet: 112835d1308828897-counting-the-number-of-instances-example
Sheet: Pivot

Count of Supplier | [NAME]
Supplier | On Time to 5 Days Early | 1 to 2 Days Late | 3 to 7 Days Late | Over 7 Days Late | Grand Total
AAL002 | 1 | 3 | 1 |  | 5
ALA001 |  |  | 1 |  | 1
ALD001 | 3 |  | 3 |  | 6
ALL001 | 1 | 1 | 1 |  | 3
ALN001 |  |  | 1 |  | 1
AMB002 |  |  |  | 1 | 1
AND002 | 8 | 15 |  | 10 | 33
APP002 | 1 |  |  |  | 1
ATL004 | 5 | 3 | 9 |  | 17
BEL002 | 29 | 1 | 67 | 2 | 99
CCP001 | 1 |  |  |  | 1
CEN001 | 1 |  |  |  | 1
[NAME] | 4 |  | 1 |  | 5
DIA001 | 1 |  | 1 |  | 2
ECW001 | 16 | 13 | 1 | 2 | 32
ELA001 | 3 |  |  | 1 | 4
FEC001 |  | 1 |  | 2 | 3
GDR001 | 1 |  |  |  | 1
HAR006 |  |  | 1 |  | 1
HAY003 | 3 |  |  |  | 3
HER001 | 8 |  | 9 |  | 17
HIL001 | 4 |  |  |  | 4
HIW001 | 1 |  |  |  | 1
MET002 | 15 | 12 | 10 |  | 37
MET004 | 5 | 4 | 11 |  | 20
MET005 | 1 |  | 1 |  | 2
MID004 |  | 1 |  |  | 1
MMG002 | 3 | 1 | 2 | 2 | 8
MOR002 | 1 |  | 1 |  | 2
PRE001 |  | 1 |  |  | 1
REL003 | 2 |  |  |  | 2
RIC001 |  | 1 | 1 | 3 | 5
RON001 | 1 | 1 | 1 |  | 3
RSC001 | 2 |  |  |  | 2
RYC001 | 2 |  | 2 |  | 4
SCH001 | 4 | 1 | 1 | 2 | 8
SHA002 |  | 1 |  |  | 1
SSS002 |  |  | 1 |  | 1
STE001 | 3 |  | 7 | 2 | 12
TPS001 | 1 |  |  |  | 1
TVH001 | 53 | 25 | 10 | 9 | 97
WHE001 | 16 |  |  |  | 16
Grand Total | 200 | 85 | 144 | 36 | 465
Spreadsheet: 330049d1404492014-using-countif-or-counting-values-if-another-column-has-an-entry-countingvalues
Sheet: Sheet1

100 | MS
500 | GS
200 | MS
600 | JT
 | MS
250 | JT
Spreadsheet: mary_fischer__25617__37D
Sheet: E14.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 037D
COMPANY NAME     Artemis Fair Value
ANALYSIS OF OTHER DEFERRED CREDITS
FOR THE PERIOD ENDING 6-30-2001
PREPARED BY: [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
EXTENSION: 52580
 |  | 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:
Idle Facility reserve |  | -103497
Outstanding claims reserve |  | -75235
Receivable reserve - Limbach |  | -100000
Construction reserve |  |  |  |  |  | 1166000
Total (Hyperion line 0860)
Asset/Expense Accts:  DR/(CR)
Reverse signs from Hyperion
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
Spreadsheet: 190050d1351513506-how-to-group-matching-values-on-a-spread-sheet-sample-grouping-cells-for-totals-1
Sheet: Sheet1

Full Code | Full Description | Colour ref | Product ref | Age ref | Qty | Value | Stock Value |  | Total Qty | Total Value
13003E | Red Shirt (1-3yr) | 1 | 3003 | E | 252 | 1
13003G | Red Shirt (4-5yr) | 1 | 3003 | G | 1297 | 2
13003K | Red Shirt (6-9yr) | 1 | 3003 | K | 176 | 3
13003M | Red Shirt (10-12yr) | 1 | 3003 | M | 325 | 4
13003P | Red Shirt (13+yr) | 1 | 3003 | P | 72 | 5
23003E | Blue Shirt (1-3yr) | 2 | 3003 | E | 922 | 1
23003G | Blue Shirt (4-5yr) | 2 | 3003 | G | 1300 | 2
23003K | Blue Shirt (6-9yr) | 2 | 3003 | K | 59 | 3
23003M | Blue Shirt (10-12yr) | 2 | 3003 | M | 72 | 4
23003P | Blue Shirt (13+yr) | 2 | 3003 | P | 2 | 5
73003G | Black Shirt (4-5yr) | 7 | 3003 | G | 39 | 2
73003M | Black Shirt (10-12yr) | 7 | 3003 | M | 18 | 4
73003P | Black Shirt (13+yr) | 7 | 3003 | P | 12 | 5 |  |  | 4546 | 9241
11002G | Red Scarf (4-5yr) | 1 | 1002 | G | 1297 | 1
11002M | Red Scarf (10-12yr) | 1 | 1002 | M | 325 | 2
11002P | Red Scarf (13+yr) | 1 | 1002 | P | 72 | 3
21002G | Blue Scarf (4-5yr) | 2 | 1002 | G | 1300 | 1
21002M | Blue Scarf (10-12yr) | 2 | 1002 | M | 72 | 2
21002P | Blue Scarf (13+yr) | 2 | 1002 | P | 2 | 3
71002M | Black Scarf (10-12yr) | 7 | 1002 | M | 18 | 2
71002P | Black Scarf (13+yr) | 7 | 1002 | P | 12 | 3 |  |  | 3098 | 3685
 | Data
Product ref | Sum of Stock Value | Sum of Qty
1002 | 3685 | 3098
3003 | 9241 | 4546
Grand Total | 12926 | 7644
Spreadsheet: 756441d1637565242-list-top-5-items-from-a-table-risk
Sheet: Sheet2

 |  | Risk ID | RISK | Value
 |  | 4 | Points of interaction | 530000 |  | Sno | Risk ID | Value | RISK
 |  | 9 | Architectual treatments do not meet stakeholder expectations | 967000 |  | 1 | 15 | 6020000 | Impact & interdependencies on existing infrastructure
 |  | 19 | Project handover is not finalised | 1020000 |  | 2 | 6 | 5660000 | TMP and staging plan non-compliance
 |  | 10 | Property Adjustment Plan does not meet stakeholder expectations | 1200000 |  | 3 | 71 | 5660000 | The IFT design for the delivery method proposed
 |  | 12 | Project Electrical design | 1239000 |  | 4 | 17 | 4880000 | G10 conditions vs EPL conditions
 |  | 11 | Property cannot be acquired | 1438000 |  | 5 | 8 | 4080000 | Cost of construction exceeds estimate of utility relocation works
 |  | 18 | FIAC do not approve increase in funding to secure the successful tenderer | 1500000
 |  | 21 | Unavoidable additional costs in earthworks (R44 Earthworks Lump Sum) | 1500000
 |  | 13 | Discovery &/or Breach of unknown &/or unidentified Telstra infrastructure | 1940000
 |  | 20 | Retrofitting of safety barrier | 2040000
 |  | 5 | Environmental / Planning approval is delayed, suspended or denied | 2240000
 |  | 7 | Project design does not meet scope | 2420000
 |  | 1 | Discovery of unknown or unidentified [NAME] | 2500000
 |  | 14 | Discovery &/or Breach of unknown &/or unidentified utility infrastructure | 2620000
 |  | 71 | The IFT design for the delivery method proposed | 5660000
 |  | 2 | Network traffic operations conflict with project construction works | 4000000
 |  | 8 | Cost of construction exceeds estimate of utility relocation works | 4080000
 |  | 17 | G10 conditions vs EPL conditions | 4880000
 |  | 6 | TMP and staging plan non-compliance | 5660000
 |  | 15 | Impact & interdependencies on existing infrastructure | 6020000