tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 274187d1383046811-vlookup-inconstancy-pb-vlookup
Sheet: sorted

GROUP_020 | [NAME] | player2 | player3 | [NAME] | player5 | player6 | player7
GROUP_021 | [NAME] | player2 | player5 | player3 | [NAME] | player12 | player10
GROUP_022 | [NAME] | player5 | player2 | player13 | player14 | [NAME]
GROUP_023 | [NAME] | player2 | player3 | player5
GROUP_024 | [NAME] | player3 | player5 | player18 | player13 | player2
GROUP_025 | [NAME] | player5 | player3 | player2 | player14
GROUP_026 | player2 | [NAME] | player5 | player3 | player10 | player17
GROUP_027 | player17 | player18 | [NAME]
GROUP_028 | player18 | player17 | player13 | player19
Spreadsheet: kate_symes__18915__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-03-23 00:00:00 |  | 305.27 | 5840 | 202.5 | 400
 | 2001-03-22 00:00:00 |  | 373.61 | 7200 | 222.62 | 840 | 401.04 | 3938 | 388.28 | 1215
 | 2001-03-21 00:00:00 |  | 441.52 | 3680 | 243.61 | 720 | 491.64 | 1345 | 382.76 | 870
 | 2001-03-20 00:00:00 |  | 399.53 | 5120 | 308.69 | 560 | 483.98 | 1040 | 363.65 | 1000
 | 2001-03-19 00:00:00 |  | 458.18 | 14320 | 290 | 200 | 410.04 | 1220 | 293.22 | 885
 | 2001-03-18 00:00:00 |  |  |  |  |  |  |  | 256.06 | 3083 |  | 310 | 1200
 | 2001-03-17 00:00:00 |  | 244.64 | 5600 | 200.19 | 1040 | 357.5 | 360 | 276.3 | 270
 | 2001-03-16 00:00:00 |  | 244.64 | 5600 | 200.19 | 1040 | 394.78 | 335 | 330 | 360
 | 2001-03-15 00:00:00 |  | 216.79 | 7600 | 168.33 | 1200 | 254.45 | 627 | 261.36 | 550
 | 2001-03-14 00:00:00 |  | 213.33 | 7200 | 178.33 | 600 | 246.45 | 900 | 222.58 | 1035
 | 2001-03-13 00:00:00 |  | 217.05 | 8800 | 174.4 | 1000 | 234.06 | 1946 | 237.07 | 870
 | 2001-03-12 00:00:00 |  | 270 | 6800 | 205 | 200 | 237.03 | 3775 | 219.92 | 1945
 | 2001-03-11 00:00:00 |  |  |  |  |  |  |  | 239.18 | 2715 |  | 205 | 600
 | 2001-03-10 00:00:00 |  | 228.93 | 5600 | 165 | 600 | 294.74 | 950 | 265.54 | 925
 | 2001-03-09 00:00:00 |  | 228.93 | 5600 | 165 | 600 | 366.94 | 1070 | 296.17 | 1600
 | 2001-03-08 00:00:00 |  | 276.67 | 6000 | 200 | 200 | 346.11 | 3730 | 314.25 | 2395
 | 2001-03-07 00:00:00 |  | 340.26 | 7600 | 263.33 | 600 | 350.64 | 3925 | 325.92 | 1567
 | 2001-03-06 00:00:00 |  | 338.57 | 2800 | 269.58 | 960 | 357.4 | 2896 | 344.21 | 1295
 | 2001-03-05 00:00:00 |  | 327 | 2000 | 306.25 | 800 | 344.21 | 4538 | 365.1 | 1235
 | 2001-03-04 00:00:00 |  |  |  |  |  |  |  | 330 | 1125 |  | 306.25 | 2400
 | 2001-03-03 00:00:00 |  | 298.33 | 4800 | 223.97 | 584 | 350 | 75 | 350 | 600
 | 2001-03-02 00:00:00 |  | 298.33 | 4800 | 223.97 | 584 | 365 | 200 | 350 | 285
 | 2001-03-01 00:00:00 |  | 292.12 | 6800 | 280 | 200 | 429.4 | 1762 | 326.61 | 930
 | 2001-02-28 00:00:00 |  | 200.76 | 5152 | 183.49 | 1328 | 338.36 | 10459 | 285.21 | 1523
 | 2001-02-27 00:00:00 |  | 202.25 | 2912 | 135 | 200 | 275.53 | 4475 | 267.2 | 795
 | 2001-02-26 00:00:00 |  | 248.21 | 5600 | 195 | 240 | 258.41 | 5480 | 226.05 | 950
 | 2001-02-25 00:00:00 |  |  |  |  |  |  |  | 181.6 | 2500 |  | 200 | 360
 | 2001-02-24 00:00:00 |  | 196.43 | 2800 | 140 | 200 | 214.05 | 4252 | 232.89 | 760
 | 2001-02-23 00:00:00 |  | 196.43 | 2800 | 140 | 200 | 296.91 | 1345 | 300 | 400
 | 2001-02-22 00:00:00 |  | 261 | 4000 | 200 | 200 | 233.22 | 2500 | 222.69 | 1730
 | 2001-02-21 00:00:00 |  | 283.75 | 4800 | 240 | 200 | 425 | 1050 | 372 | 750
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 838449d1691014701-keep-a-group-family-rows-together-when-sorting-group-sort-key
Sheet: Sheet1

[NAME] | Account Number | Account Value | Fee Structure | HELPER_1 | Helper_2 |  | Expand all the Groups, so all the data is visible, then Ungroup the data from Rows (on Data tab)
[NAME] | KramerGroup | 15000000 | Standard Fee |  |  |  | Enter formulae in E2 and F2 and copy down to the bottom of your data
[NAME] | 6579 | IHIRA
[NAME] | 9194 | RH
Mark | 7368 | SEP
[NAME] | 1609 | CO
Jake | 2159 | IHIRA
[NAME] | 4187 | LT
Nick | 1817 | LT
[NAME] | DossGroup | 10000000 | 0.01
[NAME] | 2786 | JT
Scott | 6214 | RH
[NAME] | 2009 | RO
[NAME] | 9230 | RH
Sara | 5866 | CO
[NAME] | CorthGroup | 12000000 | Standard Fee
Kristy | 1259 | IN
[NAME] | 1681 | RO
[NAME] | StevensGroup | 20000000 | Standard Fee
[NAME] | 8921 | LT
[NAME] | 1984 | RO
[NAME] | MartinGroup | 5000000 | Standard Fee
[NAME] | 4449 | IN
Mark | 3834 | RH
[NAME] | 3767 | SEP
Cox Family | CoxGroup | 18000000 | GrandFathered
[NAME] | 3785 | IN
[NAME] | 8426 | CO
Mixon Family | MixonGroup | 7000000 | Standard Fee
[NAME] | 4516 | RO
[NAME] | 5400 | SEP
Samantha | 9247 | JT
Julie | 6012 | RO
Spreadsheet: 832008d1686058194-gantt-chart-gantt-chart-template-1-
Sheet: Workings

Budget v Actual Doughnut & Bar Chart |  |  |  | Tasks Bar Chart |  |  |  | Overall Progress - Days Completed v Duration Doughnut Chart |  |  |  |  |  |  | Scroll bar position
 | Actual | Budget |  | Not Started |  |  |  | Values |  |  | [NAME] | % | [NAME] |  | 0
Bar Chart |  |  |  | In Progress |  |  |  | Days completed |  |  | Days Completed
Dougnut Chart |  |  |  | Completed |  |  |  | Duration |  |  | Days Remaining
 |  |  |  | Remaining
 |  |  |  | Total Tasks
 |  |  |  |  |  | =AND(WEEKDAY(K$5,2)>5,$B6<>"")
 |  |  |  |  |  |  |  | Holidays
 |  |  |  |  |  |  |  | 2023-05-01 00:00:00
 |  |  |  |  |  |  |  | 2023-05-08 00:00:00
 |  |  |  |  |  |  |  | 2023-05-29 00:00:00
 |  |  |  |  |  |  |  | 2023-08-28 00:00:00
 |  |  |  |  |  |  |  | 2023-12-25 00:00:00
 |  |  |  |  |  |  |  | 2023-12-26 00:00:00
Spreadsheet: 705293d1605992468-is-if-formula-wrong-here-or-what-am-i-doing-wrong-handleliste
Sheet: Kjøttdeig og spaghetti

 |  | Slik gjør du det
Antall porsjoner | 4 |  |  | Handleliste |  |  | Ingredienser
 |  |  |  |  |  |  | 2 stk | hvitløksfedd
 | 1 | Skrell og finhakk hvitløk, gulrot og løk. Skjær bacon i biter. |  |  |  |  | 2 stk | [NAME]
 | 2 | Stek kjøttdeig eller karbonadedeig og baconbiter sammen i smør på middels sterk varme til det er gjennomstekt, i 5–8 minutter. Ha kjøttblandingen over i en gryte og tilsett hermetiske tomater. |  |  |  |  | 1 stk | [NAME]
 | 3 | Kok opp rikelig med [NAME] og kok spagetti etter anvisningen på pakken. Pass på å beregne riktig tid, slik at pastasausen blir ferdig omtrent samtidig som spagettien. |  |  |  |  | 150 gram | bacon
 | 4 | I den brukte stekepannen varmer du opp olje og steker gulrot, løk og hvitløk på [NAME] i 5–7 minutter. Ha det over i gryta med [NAME]. Kok opp og la det småkoke i minst 10 minutter. |  |  |  |  | 400 gram | kjøttdeig eller karbonadedeig
 | 5 | [NAME] blir bare bedre og bedre desto lenger du lar den koke – gjerne en time eller to. |  |  |  |  | 2 ss | Tine meierismør
 | 6 | [NAME] rikelig med parmesan over spagettien og kjøttdeigen ved servering. |  |  |  |  | 2 bokser | hermetiske tomater à 400 g
 |  |  |  |  |  |  | [NAME]  ts | salt
 |  |  |  |  |  |  | 400 Gram | spaghetti (ev. fullkorn)
 |  |  |  |  |  |  | 4 ss | revet parmesan
Spreadsheet: 75043977-14e7-49b0-b642-4e82472b6398
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
BCGR | Test | BCGR | [NAME], Blood | [NAME], B | Genomic DNA Extracted Followed by Polymerase Chain Reaction (PCR) (PCR is used pursuant to a license agreement with Roche Molecular Systems, Inc. and InVivoScribe Technologies) | EDTA (lavender-top) tube: EDTA |  |  | 4 | mL | [NAME] must arrive within 168 hours of draw.   Container/Tube: Preferred: Lavender top (EDTA) Acceptable: ACD [NAME]: 4 mL Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms:  1. Hematopathology Patient Information Sheet (Supply T676) in Special Instructions 2. If not ordering electronically, submit a Hematopathology/Molecular Oncology Request Form (Supply T241) with the specimen. | 1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Monday through Friday | 5 days | 7 days |  | Profile |  |  |  |  | Rochester
BCGR | [NAME] | BLOOD | Whole blood |  |  |  | Ambient | 7 days
BCGR | Result | 18229 | Final Diagnosis: | Final Diagnosis: | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34574-4
BCGR | Billing Component | BCGR |  | IGK REARRANGEABN CLONAL POP |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 81264
BCGR | Billing Component | BCGR |  | IGH GENE REARRANG DIR PROBE |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 81262
Spreadsheet: 786017d1656932535-how-to-transpose-a-complex-table-book1-excelletor-
Sheet: Sheet1

ID | Language | Term |  |  | ID | EN | FR
1 | EN | Term 1 |  |  | 1
1 | EN | Synonym to term 1
1 | FR | Term 1
2 | EN | Term 2
Spreadsheet: 727696d1618042705-finding-the-cell-containing-information-xl-pdftest
Sheet: Table 2

Pretty Good Mental Health Office 1234 Main St. Ste 510 Provo UT 56789 P: (800) 555-1212 • F: (800)-123-4567 Tax ID: 123456789 |  |  |  | STATEMENT Accurate as of 4/8/21 12:55:42 PM
 |  |  |  |  |  |  |  | JFED SOLTEST |  | (Patient)
Contact Address:
 |  |  |  |  |  |  |  | Gender |  | DOB |  |  |  | Contact
 |  |  |  |  |  |  |  | Male |  | 2081-01-01 00:00:00 |  |  |  | JFED SOLTEST (Patient)
 |  |  |  |  |  |  |  | Mobile |  | Phone |  |  |  | Mobile                    Phone
 |  |  |  |  |  |  |  | (907) 279-4266 |  | () - |  |  |  | (907) 279-4266       () -
 |  |  |  |  |  |  |  | Address |  |  |  |  |  | Address
 |  |  |  |  |  |  |  | , |  |  |  |  |  | ,
 |  |  |  |  |  |  |  | Balance Details
 |  |  |  |  |  |  |  | Patient Responsibility                                                                                                                     10.00 Paid to Date                                                                                                                                - Total Balance Due                                                                                                                          10.00
 |  |  |  |  |  |  |  | Available Account Credit                                                                                                              -
Visits & Items
Date |  | Claim # / Item |  |  | Items Total | Cancel No Show | Copay Visit Chg. |  | Co Ins. |  | Deductible |  | Other |  | Sent to Patient |  | Paid | Balance
2020-09-08 00:00:00 |  |  |  |  | - | - | VC 10.00 |  | - |  | - |  | - |  | - |  | - | 10
Total Balance Due                                                                                                                                                                                                                                                                                                                                   10.00
Payment History
Date | Method |  |  | Reference |  |  | Applied To |  |  |  | Paid | Used |  |  |  | Remaining
Total Available Account Credit                                                                                                                                                                                                                                                                                          -
Spreadsheet: 085a7120-568b-47d2-8b06-9fff4595b2b1
Sheet: Sheet1

Year | Dept | No | Contractor(s) | Services | Start Date | Expiration Date | Annual Value
12 | FS | 19 | Ovations Food Services, LP | Lease of Liquor License | 11/1/11 | 10/31/16 | $1.00
12 | AD | 20 | Ovations Food Services, LP | Food Vending Services at Municipal Events Center | 11/1/11 | 10/31/16 | Profit share
12 | PR | 23 | ICSS | Alarm System | 12/20/11 | 12/19/12 | $8,516
12 | PW | 24 | RMCI | Phase II - 18" Reuse Water Line, WWTP #6 - WWTP#2 | 12/7/11 | 6/30/12 | $1,541,617.89
12 | PW | 25 | Red Oak Consulting a division of [NAME], Inc. | Water Financial Plan and Rate Update | 1/23/12 | 1/22/13 | $26,400
12 | PD | 26 | Professional Document systems | Maintenance/Support Agreement | 11/1/11 | 10/31/12 | $1,582.13
12 | FS | 27 | Wells Fargo | Lease of Copy Machine at MVD | 11/29/11 | 11/28/15 | $1,896
12 | PR | 28 | Wells Fargo | Lease of Copy Machine at Senior Center | 11/29/11 | 11/28/15 | $5,098.20
12 | HR | 29 | The Mercer Group | Assistance in Employee Searches
12 | PW | 30 | Public Service Company of New Mexico (PNM) | Electrical Services Engineering for 2902 Westminster St. | 12/1/11 | 2012-12-01 00:00:00 | $4,560
12 | PW | 31 | Mid-Region Council of Governments (MRCOG) | Digital Orthophotography Services | 12/21/11 | 12/31/13 | $7,500
12 | PR | 32 | Heads Up Landscape Contractors, Inc. | Snow Removal Services | 12/15/11 | 4/15/12 | Based on Fee Schedule
Spreadsheet: 31065d1226784255-calculating-formula-not-working-properly-total-fats-etc-book-1
Sheet: recipe 1

RECIPE CALCULATOR
ingredient | servings in recipe | serving size as per label | cal / serving | total calories | fat | total fat | sat fat | total sat fat | carbs | total carbs | sugar | total sugar | fiber | total fiber | protein | total protein |  | sodium | total sodium | calcium | total calcium | chol | total cholesterol
[NAME] lean (raw)  grams | 100 | 100 | 176 | 176 | 10 | 5.681818181818183 | 4.058 | 405.8 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 2000 |  | 0 | 0 | 0 | 0 | 0 | 0
[NAME] lean (raw)  grams | 100 | 100 | 176 | 176 | 10 | 1000 | 4.058 | 405.8 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 2000 |  | 0 | 0 | 0 | 0 | 0 | 0
[NAME] lean (raw)  grams | 150 | 100 | 176 | 264 | 10 | 1500 | 4.058 | 608.6999999999999 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 3000 |  | 0 | 0 | 0 | 0 | 0 | 0
[NAME] lean (raw)  grams | 85 | 100 | 176 | 149.6 | 10 | 850 | 4.058 | 344.93 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 1700 |  | 0 | 0 | 0 | 0 | 0 | 0
broth, beef (college inn) 1 cup | 1 | 1 | 25 | 25 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 4 |  | 900 | 900 | 20 | 20 | 0 | 0
broth, beef (college inn) 8 oz | 8 | 8 | 25 | 25 | 1 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 32 |  | 900 | 7200 | 20 | 160 | 0 | 0
total calories per recipe ===> | 815.6
servings per recipe ===> |  |  |  | the totals for fats, etc are all wrong now. --- g4 should show 10 grams since the servings size per label is calculated as 100 grams = 10 grams fat but it shows 5.86 (with a diff formula)  and g5 is showing 1000 grams fat instead of 10 with the formula I did have there.  Row 8 is the only one showing the correct total fat
calories per serving ===>
fat per recipe === > | 3364.681818181818
fat per serving ===>
sat fat per recipe ===> | 1765.23
sat fat per serving ===>
carbs per recipe ===> | 0
carb per serving ===>
sugar | 0
sugar
fiber | 0
fiber
protein | 8736
protein
Spreadsheet: 767286d1644394792-merge-two-sheets-in-a-third-one-sheet1-sheet2
Sheet: A+B

title1 | title2 | title3 |  | what i need to have
 | 1 | blue
b | 2 | green
c | 3 | yellow
d | 4 | blue
e | 5 | white
f | 6 | black
g | 7 | yellow
h | 8 | red
Spreadsheet: 8539a1b8-172d-4846-beb9-74b6109d1741
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: |  |  | 2013-07-26 09:26:09.960000
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.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.625 | 101.809 | 101.684 | 101.559 | 101.184
4.5 | 101.002 | 100.877 | 100.752 | 100.377 |  | Note: | Refer To Price [NAME]
4.375 | 100.156 | 100.031 | 99.906 | 99.531 |  |  | For all Price Adjs
4.25 | 99.6 | 99.475 | 99.35 | 98.725
4.125 | 98.883 | 98.758 | 98.633 | 98.008
4 | 97.993 | 97.868 | 97.743 | 97.118
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.125 | 102 | 101.875 | 101.5
3.875 | 101.987 | 101.862 | 101.737 | 101.362
3.75 | 101.557 | 101.432 | 101.307 | 100.932
3.625 | 101.22 | 101.095 | 100.97 | 100.595
3.5 | 100.73 | 100.605 | 100.48 | 99.855
3.375 | 99.986 | 99.861 | 99.736 | 99.111
3.25 | 99.265 | 99.14 | 99.015 | 98.39 |  | Minimum loan amount:
3.125 | 98.368 | 98.243 | 98.118 | 97.493 |  | 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 | 2013-08-09 09:26:09.960000
30 DAY | 2013-08-24 09:26:09.960000
45 DAY | 2013-09-08 09:26:09.960000
60 DAY | 2013-09-23 09:26:09.960000
90 DAY | 2013-10-23 09:26:09.960000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 794390d1662029864-formula-to-show-results-of-evaluation-tie-match-sample-wb-1-1-
Sheet: Supplier 1

 |  |  |  | (The details are to be consistent with the criteria outlined in the forms)
 |  |  |  |  | Score
 | Weighting Ratio |  | Price
 |  |  | Non-Price
 | Quotation 1 - Supplier/Service Provider Name:
 | Table 1 - Compliance Assessment Criteria
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Consensus
 | 1 | aa |  |  |  |  |  |  |  | EXCEPTIONAL | EXCEPTIONAL | Please select from list | UNSATISFACTORY
 | 2 | fffg |  |  |  |  |  |  |  | SATISFACTORY | SATISFACTORY | SATISFACTORY | SATISFACTORY
 | 3 | fffg |  |  |  |  |  |  |  | SATISFACTORY | UNSATISFACTORY | EXCEPTIONAL | EXCEPTIONAL
Spreadsheet: 40088d1238425862-excel-2007-excel-2007-charting-issue-test4
Sheet: Sheet1

 | Produced Oil, MM bbls | Produced Water, MM barrels | [NAME], MM barrels | % Water Cut
1960 | 1 | 1 | 1
 | 1 | 1 | 1
 | 2 | 1 | 1
 | 2 | 1 | 1
 | 2 | 1 | 1
1965 | 3 | 1 | 1
 | 4 | 1 | 1
 | 5 | 1 | 1
 | 6 | 1 | 1
 | 7 | 2 | 1
1970 | 8 | 4 | 2
 | 8 | 5 | 2
 | 7 | 7 | 2
 | 7 | 8 | 3
 | 7 | 9 | 3
1975 | 6 | 9 | 3
 | 5 | 8 | 3
 | 12 | 8 | 3
 | 30 | 7 | 3 | 5
 | 40 | 6 | 3 | 6
1980 | 40 | 6 | 3 | 7
 | 42 | 6 | 3 | 7
 | 43 | 5 | 3 | 6
 | 44 | 5 | 2 | 7
 | 47 | 6 | 1 | 11
1985 | 50 | 15 | 2 | 12
 | 51 | 35 | 5 | 17
 | 52 | 54 | 7 | 20
 | 52 | 56 | 10 | 25
 | 45 | 58 | 18 | 30
1990 | 43 | 59 | 22 | 35
 | 40 | 61 | 25 | 40
 | 40 | 65 | 30 | 45
 | 38 | 71 | 35 | 50
 | 35 | 74 | 40 | 55
1995 | 30 | 72 | 45 | 55
 | 25 | 72 | 45 | 57
 | 25 | 71 | 47 | 60
 | 26 | 74 | 50 | 62
 | 26 | 73 | 50 | 65
2000 | 26 | 73 | 51 | 68
 | 24 | 67 | 53 | 70
 | 23 | 66 | 51 | 69
 | 20 | 72 | 51 | 69
 |  | 70 | 50 | 71
2005
2010
Spreadsheet: f238e796-cc5a-436a-a9d8-1a265fde1d38
Sheet: Sheet1

Name | Typical Urban Water Use for a Family of Four | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Purpose | The purpose of this spreadsheet is to create graphs of data from Table 1.6 in Environmental Hydrology by Ward and Trimble
Creator | [NAME]
Date | 2006-08-14 00:00:00 |  |  | [NAME] = | 4
 |  | Daily Family Use |  |  | Daily Per Capita Use
 | Type of Household Use | Gallons/day | % | Cumulative % | (gal/day)
 | Drinking and Water Used in Kitchen (8 gal.day) | 8 | 0.02309268827757411 | 0.02309268827757411 | 2
 | Dishwasher (loads per day) (15 gal/load) | 15 | 0.04329879052045146 | 0.06639147879802558 | 3.75
 | Toilet (16 flushes per day) | 96 | 0.2771122593308893 | 0.3435037381289149 | 24
 | Bathing (4 baths or showers per day @ 20 gal / bath | 80 | 0.2309268827757411 | 0.5744306209046561 | 20
 | Laundering (6 loads per week) | 34 | 0.09814392517968998 | 0.6725745460843461 | 8.5
 | Automobile washing (2 car washes per month) | 10 | 0.02886586034696764 | 0.7014404064313138 | 2.5
 | Lawn watering and swimming pools (180 h per year) | 100 | 0.2886586034696764 | 0.9900990099009902 | 25
 | Garbage disposal (1% of other uses) | 3.43 | 0.009900990099009901 | 1 | 0.8575
 | Total | 346.43 | 1 |  | 86.6075
Spreadsheet: 864642d1711728150-summing-time-into-hours-converting-time-aligw
Sheet: Sheet1

Summary by [NAME]
Billable Visits | Clergy | [NAME] | 14 | 05:10:00 | 00:22:00 | 0:00:00 | 00:00:00 | 03:20:00 | 00:14:00 | 91 | 6.5 | 132
 | Clergy | Revisit | 75 | 22:45:00 | 00:18:00 | 0:00:00 | 00:00:00 | 14:05:00 | 00:11:00 | 307 | 4.1 | 133
 | HCA | [NAME] | 1 | 01:10:00 | 01:10:00 | 0:00:00 | 00:00:00 | 00:05:00 | 00:05:00 | 0 | 0 | 134 |  | Total | Visits | Hours | inhome
 | HCA | Revisit | 970 | 41 days, 17:20:00 | 01:02:00 | 0:15:00 | 00:00:00 | 4 days, 14:38:00 | 00:07:00 | 1701 | 1.8 | 135
 | HCA | Supervision/HCA | 2 | 02:00:00 | 01:00:00 | 0:00:00 | 00:00:00 | 00:30:00 | 00:15:00 | 18 | 9 | 136
 | MSW | [NAME] | 26 | 17:37:00 | 00:41:00 | 9:30:00 | 00:22:00 | 05:56:00 | 00:14:00 | 81 | 3.1 | 137
 | MSW | MSW Phone Call | 3 | 01:03:00 | 00:21:00 | 0:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 0 | 0 | 138
 | MSW | Revisit | 61 | 1 day, 9:36:00 | 00:33:00 | 13:02:00 | 00:13:00 | 10:17:00 | 00:10:00 | 130 | 2.1 | 139
 | SN | [NAME] | 1 | 01:00:00 | 01:00:00 | 1:00:00 | 01:00:00 | 00:00:00 | 00:00:00 | 0 | 0 | 140
 | SN | Integrated Assessment | 23 | 1 day, 9:37:00 | 01:28:00 | 1 day, 2:25:00 | 01:09:00 | 05:27:00 | 00:14:00 | 190 | 8.3 | 141
 | SN | On Call | 23 | 22:52:00 | 0.04166666666666666 | 0:00:00 | 00:00:00 | 14:58:00 | 00:39:00 | 480 | 20.9 | 142
 | SN | Recert Visit | 30 | 1 day, 1:48:00 | 00:52:00 | 18:30:00 | 00:37:00 | 01:46:00 | 00:04:00 | 63 | 2.1 | 143
 | SN | Revisit | 762 | 26 days, 17:20:00 | 00:50:00 | 13 days, 3:52:00 | 00:25:00 | 2 days, 20:41:00 | 00:05:00 | 2328 | 3.1 | 144
 | SN | SN Pronouncement | 14 | 17:51:00 | 01:17:00 | 3:35:00 | 00:15:00 | 07:58:00 | 00:34:00 | 252 | 18 | 145
 |  | Sub Total | 2005 | 76 days, 3:09:00 | 00:55:00 | 16 days, 4:09:00 | 00:12:00 | 10 days, 3:41:00 | 00:07:00 | 5641 | 2.8 | 145
Spreadsheet: 190494d1351676355-top-3-based-on-3-categories-00_fot_fruit-example
Sheet: Summary

 | Top 3 Fruit |  |  | Top 3 Containers |  |  | Top 3 Locations
 | 1 | Apple
 | 2 | Orange |  | 1 |  |  | Bowl
 | 3 | [NAME] |  | 2 |  |  | 1 |  |  | [NAME] in each of the blank cells to calulate the top 3 locations for each variation of top three fruit and container.
 |  |  |  | 3 |  |  | 2
 | [NAME] in C3:C5 to calculate top three fruit |  |  |  |  |  | 3
 |  |  |  | 1 | Tub |  | Basket
 |  |  |  | 2 | Cup |  | 1
 |  |  |  | 3 | Bowl |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  | 1 | Bowl |  | Cup
 |  |  |  | 2 | Basket |  | 1
 |  |  |  | 3 | Cup |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  | [NAME] in F4:F6 | F8:F10 | F12:F14 to calculate top three containers for each of the top three fruit.
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3