tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 887664d1737969805-find-and-sort-nearest-date-testing
Sheet: Loan_ID

Sr No. | Loan ID | Name | Loan Date | Interest  % | Loan Amount | Tenor
Spreadsheet: 710057d1608693246-how-do-i-use-sumif-when-looking-between-2-dates-testing-file
Sheet: Sheet1

Date | Person | Hrs
2020-12-01 00:00:00 | [NAME] | 2
2020-12-02 00:00:00 | [NAME] | 2
2020-12-02 00:00:00 | [NAME] | 3
2020-12-03 00:00:00 | [NAME] | 4
2020-12-04 00:00:00 | [NAME] | 5
2020-12-04 00:00:00 | [NAME] | 3 |  |  | Start Date: | 2020-12-02 00:00:00
2020-12-05 00:00:00 | [NAME] | 1 |  |  | End Date: | 2020-12-13 00:00:00
2020-12-06 00:00:00 | [NAME] | 5
2020-12-07 00:00:00 | [NAME] | 2 |  |  | Person | [NAME] |  | Desired Outcome
2020-12-07 00:00:00 | [NAME] | 8 |  |  | SUMIF > |  |  | Person | [NAME]
2020-12-08 00:00:00 | [NAME] | 4 |  |  |  |  |  |  | 28
2020-12-09 00:00:00 | [NAME] | 5
2020-12-09 00:00:00 | [NAME] | 3
2020-12-10 00:00:00 | [NAME] | 1
2020-12-11 00:00:00 | [NAME] | 1
2020-12-11 00:00:00 | [NAME] | 2
2020-12-12 00:00:00 | [NAME] | 4
2020-12-12 00:00:00 | [NAME] | 2
2020-12-13 00:00:00 | [NAME] | 5
2020-12-14 00:00:00 | [NAME] | 5
2020-12-15 00:00:00 | [NAME] | 1
Spreadsheet: 848165d1698937474-formula-to-adjust-daily-sales-target-required-sample2
Sheet: NOVEMBER 2023

 | BSL PROCESSED ORDER VALUE NOVEMBER 2023
 | DAY | VALUE | NO. OF ORDERS
 | 1 | 6877.52 | 44
 | 2 | 5000 | 38
 | 3
 | 4
 | 5
 | WK/TOTAL
 | Running Total
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | WK/TOTAL
 | Running Total
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | WK/TOTAL
 | Running Total
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | WK/TOTAL
 | Running Total
 | 27
 | 28
 | 29
 | 30
 | WK/TOTAL
 | Running Total
 | MONTH TOTAL
 | Grand Total
Spreadsheet: 207221d1358406263-commits-getting-info-from-another-page-twst
Sheet: Formulas

Body type |  |  |  |  |  |  |  | Harris Benedict Factors |  |  | Weight Training Schedule
Type | Carbs | Protein | Fat | Database | Muscle gain | Fat Loss |  | Level of Activity | factor |  | When | Meal #
[NAME] | 0.5 | 0.35 | 0.15 | Ecto | 0.2 | 0.1 |  | One Hour (Too Few) | 1.375 |  | Off day | 0
Ecto-Meso | 0.45 | 0.35 | 0.2 | EctoMeso | 0.175 | 0.125 |  | Two Hours (Too Few) | 1.4625 |  | After Meal 1 | 2
Meso-Ecto | 0.43 | 0.35 | 0.22 | Endo | 0.165 | 0.2 |  | Three Hours (Moderate) | 1.55 |  | After Meal 2 | 3
Meso-Endo | 0.4 | 0.4 | 0.2 | EndoMeso | 0.125 | 0.175 |  | Four Hours (Moderate) | 1.6375 |  | After Meal 3 | 4
[NAME] | 0.4 | 0.35 | 0.25 | [NAME] | 0.15 | 0.15 |  | Five Hours (Ideal) | 1.725 |  | After Meal 4 | 5
 |  |  |  |  |  |  |  | Six Hours (Ideal) | 1.8125
Workout Days |  |  |  | Off Days |  |  |  | Seven Hours (High) | 1.9
 | Carbs | Protein | Fat | Carbs | Protein | Fat |  | Eight Hours (High) | 1.9875
Meal 1 | 0.253 | 0.166 | 0.195 | 0.3 | 0.166 | 0.166 |  | Nine Hours (Too High, Counterproductive) | 2.075
Meal 2 |  | 0.166 | 0.195 | 0.083 | 0.166 | 0.166 |  | Ten Hours (Too High, Counterproductive) | 2.1625
Meal 3 |  | 0.166 | 0.195 | 0.25 | 0.166 | 0.166
Meal 4 |  | 0.166 | 0.195 | 0.083 | 0.166 | 0.166
Meal 5 |  | 0.166 | 0.195 | 0.2 | 0.166 | 0.166
Meal 6 | 0.124 | 0.166 | 0.195 | 0.083 | 0.166 | 0.166
Monday
Database:
Foodgroups | Database
Beverages | Beverages
Breads | Breads
Cereals | Cereals
Dairy | Dairy_Egg
Fats/oil/dressings | Fats_oil_dressings
Seafood | Fish_Seafood
Fruits | Fruit
Meat | Meat
Nuts/Seeds | Nuts_Seeds
Pasta | Pasta
Pork | Pork
Poultry | Poultry
Processed Meat | Processed_Meat
Snacks/sweets | Snacks_sweets
Meals | Meals
Soups/Sauces | Soups_Sauces
Vegetables | Vegetables
Spreadsheet: 888636d1739208762-pulldown-list-expenses
Sheet: 2023

 | Variable Cost 2023 |  |  |  | Hydro |  | Fixed Costs 2023 |  |  |  | Projection Fixed Costs 2024
 | # | Months | CIBC | RBC | [NAME] |  |  |  | Mortgage |  |  |  | Mortgage
 | 1 | December | 2588.26 | 250.42 | 73.42 |  |  |  | Taxes |  |  | 170.12 | Taxes
 |  | January | 2919.92 | 137.65 | 75.61 |  |  |  | [NAME]** |  |  | 679.06 | Condo Fees
 |  | February | 5100 | 135.71 | 71.21 |  |  | 169.02 | NLSC |  |  | 169.02 | NLSC
 |  | March | 5700 | 413.69 | 74.76 |  |  |  | Hydro (average) |  |  | 75 | Hydro (average)
 |  | April | 2936.67 | 203.73 | 76.6 |  | Monthly |  |  |  | Monthly
 |  | May | 5700 | 333.4 | 77.83 |  | Yearly |  |  |  | Yearly
 |  | June | 4900 | 84.16 | 67.25
 |  | July | 2400 | 95.55 | 89.85 |  |  | 2129.27 | Kids Education |  |  |  | Kids Education
 |  | August | 4900 | 158.42 | 93.4 |  |  | 275.88 | Shan Life Insurance |  |  | 275.88 | Shan Life Insurance
 |  | September | 7393.53 | 86.96 | 78.34 |  |  | 229.9 | Ayaan Life insurance |  |  | 229.9 | Ayaan Life insurance
 |  | October | 4820 | 49.25 | 79.07 |  | Yearly |  |  |  | Yearly
 |  | November | 2420 | 140.4 | 82.39
 | Variable Cost
 | Average
 |  |  |  |  |  |  | Total |  |  |  | Total
 |  |  |  | Fixed Costs | Cash Spending
 |  |  |  |  | 10000 |  |  | Condo and Car Insurance added to CIBC one time yearly payment. 2023 Total: $1,955.20 |  |  |  | Shan Emergency
 |  |  | 2022 Total Expenditure |  |  |  |  |  |  |  |  | 5000 | Zonelle
 |  |  | 2023 Total Expenditure |  |  |  |  |  |  |  |  | 25000 | [NAME]
 |  |  | Diffrence: |  |  |  |  |  |  |  |  |  | Electronics
 |  |  | 2023 Total Pay |  |  |  |  |  |  |  |  | 3702 | Door
 |  |  |  |  |  |  |  | Mortgage Payout |  |  |  | 6000 | Deeba Ticket
 |  |  | 2023 Montly Expenditure |  |  |  |  | 88493.78 |  |  |  |  | Total
 |  |  | 2023 Total Expenditure
Spreadsheet: 685032d1593685437-lookup-matchdata-from-another-different-format-table-book1
Sheet: Agent2

Full Name | 2020-06-01 00:00:00 |  |  |  | 2020-06-02 00:00:00 |  |  |  | 2020-06-03 00:00:00 |  |  |  | 2020-06-04 00:00:00 |  |  |  | 2020-06-05 00:00:00 |  |  |  | 2020-06-06 00:00:00 |  |  |  | 2020-06-07 00:00:00
 | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday |  |  |  | Sunday
 | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout
Agent 2
 | 2020-06-08 00:00:00 |  |  |  | 2020-06-09 00:00:00 |  |  |  |  |  |  |  | 2020-06-11 00:00:00 |  |  |  | 2020-06-12 00:00:00 |  |  |  | 2020-06-13 00:00:00 |  |  |  | 2020-06-14 00:00:00
 | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday |  |  |  | Sunday
 | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout
 | 2020-06-15 00:00:00 |  |  |  | 2020-06-16 00:00:00 |  |  |  | 2020-06-17 00:00:00 |  |  |  | 2020-06-18 00:00:00 |  |  |  | 2020-06-19 00:00:00 |  |  |  | 2020-06-20 00:00:00 |  |  |  | 2020-06-21 00:00:00
 | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday |  |  |  | Sunday
 | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout
 | 2020-06-22 00:00:00 |  |  |  | 2020-06-23 00:00:00 |  |  |  | 2020-06-24 00:00:00 |  |  |  | 2020-06-25 00:00:00 |  |  |  | 2020-06-26 00:00:00 |  |  |  | 2020-06-27 00:00:00 |  |  |  | 2020-06-28 00:00:00
 | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday |  |  |  | Sunday
 | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout
 | 2020-06-29 00:00:00 |  |  |  | 2020-06-30 00:00:00
 | Monday |  |  |  | Tuesday
 | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout
 | Total Days AM Shift
 | Total Days PM Shift
Spreadsheet: 167794d1342105043-excel-2007-vlookup-help-2012-bud-help
Sheet: Jan

Monthly [NAME]
 | [NAME] | Date Due | Date Paid | Amount Due | Amount Paid | Status | Comment
 | Mortgage
 | Tundra | 2012-01-31 00:00:00 | 2012-01-15 00:00:00 | 343.92 | 343.92
 | Sorento | 2012-01-31 00:00:00 | 2012-01-31 00:00:00
 | Verizon Wireless | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 | 200 | 219.26
 | RZMC | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 | 51 | 51
 | Capital One | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 | 25 | 25
 |  | 2012-01-31 00:00:00 | 2012-01-31 00:00:00
 | Household Bank
 | Insurance | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 | 79.8 | 79.8
 | RG&E | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 | 185.2 | 185.2
 | Time Warner | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 | 159.79 | 159.79
 | ACS | 2012-01-31 00:00:00
 | AES | 2012-01-31 00:00:00
 | Sallie Mae | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 | 213.47 | 213.47
 | 1st Financial | 2012-01-31 00:00:00
 | Waste Management | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 | 82.89
 | Water Authority
 | Wells Fargo - Furniture | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 | 30 | 40
 | [NAME]
Spreadsheet: 148132d1333145947-help-with-getting-unique-output-dependent-on-two-data-validation-lists-samplevlookupwithkey-1-
Sheet: Sample Data

 |  |  | Hole 1 | Hole 2 | Hole 3 | Hole 4 | Hole 5 | Hole 6 | Hole 7 | Hole 8 | Hole 9 | Hole 10 | Hole 11 | Hole 12 | Hole 13 | Hole 14 | Hole 15 | Hole 16 | Hole 17 | Hole 18
1 | a |  | 3 | 3 | 6 | 5 | 2 | 5 | 3 | 2 | 5 | 4 | 6 | 4 | 6 | 3 | 3 | 3 | 3 | 3
2 | a |  | 5 | 4 | 3 | 6 | 2 | 4 | 5 | 4 | 6 | 2 | 4 | 5 | 4 | 4 | 6 | 2 | 4 | 5
3 | a |  | 3 | 5 | 6 | 6 | 6 | 4 | 3 | 5 | 4 | 3 | 2 | 4 | 3 | 6 | 3 | 4 | 6 | 2
1 | b |  | 3 | 4 | 6 | 2 | 3 | 3 | 5 | 2 | 5 | 3 | 3 | 2 | 5 | 5 | 5 | 5 | 3 | 2
2 | b |  | 2 | 6 | 4 | 6 | 5 | 2 | 3 | 6 | 4 | 2 | 5 | 6 | 5 | 5 | 4 | 6 | 3 | 5
3 | b |  | 5 | 3 | 4 | 2 | 4 | 5 | 4 | 6 | 3 | 5 | 5 | 5 | 5 | 5 | 6 | 2 | 5 | 6
1 | c |  | 2 | 5 | 2 | 3 | 6 | 6 | 3 | 6 | 5 | 6 | 6 | 5 | 4 | 2 | 2 | 4 | 3 | 5
2 | c |  | 3 | 5 | 3 | 5 | 6 | 3 | 4 | 3 | 6 | 3 | 2 | 2 | 5 | 3 | 4 | 4 | 5 | 4
3 | c |  | 4 | 6 | 3 | 2 | 4 | 3 | 6 | 2 | 6 | 3 | 4 | 6 | 2 | 6 | 6 | 6 | 3 | 5
1 | d |  | 6 | 5 | 5 | 2 | 6 | 2 | 5 | 4 | 2 | 4 | 2 | 2 | 2 | 4 | 6 | 5 | 6 | 6
2 | d |  | 3 | 2 | 3 | 3 | 4 | 2 | 2 | 6 | 6 | 5 | 6 | 6 | 3 | 2 | 2 | 5 | 2 | 2
3 | d |  | 3 | 2 | 6 | 4 | 5 | 4 | 2 | 2 | 3 | 5 | 5 | 4 | 6 | 2 | 5 | 3 | 3 | 5
 |  |  |  |  | Players
 |  |  | Courses |  | ID's | Name
 |  |  | a |  | 1 | [NAME]
 |  |  | b |  | 2 | [NAME]
 |  |  | c |  | 3 | [NAME]
 |  |  | d
Spreadsheet: 140598d1328813118-removing-duplicates-in-one-column-and-summarizing-data-names
Sheet: Sheet3

NAME | Grade | Honour Roll | Effort | Term |  | NAME | Grade | Term 1 Honour Roll | Term 1 Effort | Term 2 Honour Roll | Term 2 Effort | Term 3 Honour Roll | Term 3 Effort
Aalhus, [NAME] | 9 | B |  | 2
Aalhus, [NAME] | 11 | B |  | 2
Aalhus, [NAME] | 11 | B |  | 3
Abbott, [NAME] | 8 | B | E | 1
Abrahamson, Chase | 8 | B | E | 1
Abrahamson, Chase | 8 | B | E | 2
Adams, Chloe | 8 | A | E | 1
Adams, Chloe | 8 | A | E | 2
Adams, Chloe | 8 | A | E | 3
Adlani, Amine | 10 | B |  | 1
Adlani, Amine | 10 | B |  | 3
Adrian, [NAME] | 10 | B |  | 1
Adrian, [NAME] | 9 | B |  | 1
Aichele-Jones, [NAME] | 9 | B |  | 2
[NAME], May | 10 | A | E | 1
[NAME], May | 10 | A | E | 2
[NAME], May | 10 | A | E | 3
Alain, Jeremy | 8 | B | E | 1
Alain, Jeremy | 8 | B | E | 2
Alain, Jeremy | 8 | B |  | 3
Alain, Jessica | 12 | A | E | 1
Alain, Jessica | 12 | A | E | 2
Alain, Jessica | 12 | A | E | 3
Spreadsheet: 134441d1325282519-sumproduct-question-user-enters-date-range-in-data-validation-cells-sumproduct-example
Sheet: data

Date | Code | Amt
2011-12-11 00:00:00 | 101 | 5
2011-12-11 00:00:00 | 102 | 8
2011-12-12 00:00:00 | 101 | 67
2011-12-12 00:00:00 | 102 | 89
2011-12-14 00:00:00 | 101 | 25
2011-12-14 00:00:00 | 102 | 78
2011-12-15 00:00:00 | 101 | 5
2011-12-15 00:00:00 | 102 | 8
2011-12-16 00:00:00 | 101 | 67
2011-12-16 00:00:00 | 102 | 89
2011-12-17 00:00:00 | 101 | 25
2011-12-17 00:00:00 | 102 | 78
Spreadsheet: darron_c_giron__8010__EMW0831a
Sheet: Prior P&L Without Sharing

 |  |  |  | NSS1 |  | NSS2 |  | MEH |  | TP-NSS |  | EMW Total
CURRENT BOOK VALUE
 | Physical
 |  | Physical |  | -1445832.3 |  | 0 |  | 74895.6 |  | 0 |  | -1370936.7
 |  | Other |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Prompt |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Reversal |  | 97102 |  | 0 |  | -1309 |  | 0 |  | 95793
 |  | TOTAL |  | -1348730.3 |  | 0 |  | 73586.6 |  | 0 |  | -1275143.7
 | Financial
 |  | Price Swaps |  | 1416421.679400001 |  | 0 |  | 14022.82459999993 |  | 3830.336299999966 |  | 1434274.840300001
 |  | Options |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Basis |  | 3350.516000000003 |  | 0 |  | 12017.44339999999 |  | 0.0002 |  | 15367.95959999999
 |  | Index |  | 238.6570000000002 |  | 0 |  | 16414.9479 |  | 0.0001 |  | 16653.605
 |  | Gas Daily |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Gas Daily Options |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Broker Fees |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | TOTAL |  | 1420010.852400001 |  | 0 |  | 42455.21589999992 |  | 3830.336599999966 |  | 1466296.404900001
 | Omicron
 |  | Physical |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Financial |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | TOTAL |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Transport - Accrued
 |  | Revenue (Gas Daily Spreads) |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Commodity Expense |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Fuel Expense |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | 3rd Party Demand Charges |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | 3rd Party Demand Reimbursements |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Transport Book Demand Charges |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Transport Book Demand Reimbursements |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | TOTAL |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Transport - MTM
 |  | Revenue (Gas Daily Spreads) |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Commodity Expense |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Fuel Expense |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | 3rd Party Demand Charges |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | 3rd Party Demand Reimbursements |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Transport Book Demand Charges |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Transport Book Demand Reimbursements |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | TOTAL |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Other
 |  | People's Share of P&L |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Origination |  | 0 |  | 0 |  | 3995 |  | 0 |  | 3995
 |  | Flash to Actual |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Weather |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | TOTAL |  | 0 |  | 0 |  | 3995 |  | 0 |  | 3995
NET CURRENT MONTH P&L |  |  |  | 71280.55240000063 |  | 0 |  | 120036.8158999999 |  | 3830.336599999966 |  | 195147.7049000007
Spreadsheet: 286470d1388297539-how-can-you-look-up-how-much-each-category-has-made-into-the-category-column-formula-mockup-1-
Sheet: Sheet1

 |  |  |  |  | •purchases
# | P. Date | Sell Date | Item Number | Item Name | Paid | Sold | Profit | category
1 | 2013-09-18 00:00:00 | 2013-10-15 00:00:00 | GW30BF0000001 | apple | 1 | 5
2 | 2013-09-18 00:00:00 | unsold | GW37VS0000002 | orange | 1
3 | 2013-09-20 00:00:00 | 2013-10-24 00:00:00 | GW14SO0000003 | pear | 1 | 7
4 | 2013-10-02 00:00:00 | 2013-11-17 00:00:00 | GW30BF0000004 | [NAME] | 1 | 8
5 | 2013-10-02 00:00:00 | 2013-11-02 00:00:00 | GW30BF0000005 | apple | 1 | 9
6 | 2013-10-02 00:00:00 | 2013-10-08 00:00:00 | GW30BF0000006 | orange | 1 | 10
7 | 2013-10-02 00:00:00 | 2013-10-14 00:00:00 | GW30BF0000007 | pear | 1 | 11
8 | 2013-10-02 00:00:00 | 2013-10-14 00:00:00 | GW37VS0000008 | [NAME] | 1 | 12
9 | 2013-10-02 00:00:00 | unsold | GW37VS0000009 | apple | 1
10 | 2013-10-16 00:00:00 | 2013-12-09 00:00:00 | GW37VS0000010 | orange | 1 | 14
11 | 2013-10-19 00:00:00 | unsold | GW67TZ0000011 | pear | 1
12 | 2013-10-21 00:00:00 | 2013-12-04 00:00:00 | GW67TZ0000012 | [NAME] | 1 | 16
13 | 2013-10-21 00:00:00 | 2013-12-24 00:00:00 | GW67TZ0000013 | apple | 1 | 17
14 | 2013-10-21 00:00:00 | unsold | GW67TZ0000014 | orange | 1
15 | 2013-10-21 00:00:00 | 2013-12-06 00:00:00 | GW67TZ0000015 | pear | 1 | 19
16 | 2013-10-21 00:00:00 | 2013-12-01 00:00:00 | GW67TZ0000016 | [NAME] | 1 | 20
17 | 2013-10-21 00:00:00 | 2013-11-05 00:00:00 | GW67TZ0000017 | apple | 1 | 21
18 | 2013-10-25 00:00:00 | 2013-11-03 00:00:00 | GW34PD0000018 | orange | 1 | 22
19 | 2013-10-25 00:00:00 | 2013-11-12 00:00:00 | GW34PD0000019 | pear | 1 | 23
20 | 2013-10-25 00:00:00 | 2013-11-12 00:00:00 | GW34PD0000020 | [NAME] | 1 | 24
 |  | Category | Total Purchases | Sold | Profit
 |  | GW30BF
 |  | GW37VS
 |  | GW14SO
 |  | GW67TZ
 |  | GW34PD
 |  | category | Paid | Sold | Profit
 |  | GW14SO | 1 | 7 | 8
 |  | GW30BF | 5 | 43 | 48
 |  | GW34PD | 3 | 69 | 72
 |  | GW37VS | 4 | 26 | 28
 |  | GW67TZ | 7 | 93 | 98
 |  | Eindtotaal | 20 | 238 | 254
Spreadsheet: 484485d1476286242-fill-the-form-in-sheet3-using-data-from-sheet1-school-reports-kk
Sheet: Sheet2

School Name | Large Bus |  | Small Bus |  | Total
 | Single Trip | Double Trips | Single Trip | Double Trips
[NAME]
Hilal
Shoae
Sosan
Taqwa
Yahar
Adal
AlJood
Beda
[NAME]
Maqaam
Remah
[NAME]
Shakboot
[NAME]
Tariq
Alya
Ghaith
Mabadi
[NAME]
[NAME]
Sariya
Shaikha
Talia
Spreadsheet: 456423d1460840287-for-excel-to-automatically-add-in-a-line-if-customer-places-bigger-order-johntopley7
Sheet: Sheet3

Cabinet | Model | Coffee | White | Honey |  |  |  | QUANTITY
Base | B09 | 2 | 1 | 6 |  |  |  | 0
Base | B12 | 4 | 2 | 9 |  |  |  | 1
Base | B15 | 6 | 3 | 12 |  |  |  | 2
Base | B18 | 8 | 4 | 15 |  |  |  | 3
Base | B24 | 10 | 5 | 18 |  |  |  | 4
Base | B30 | 12 | 7 | 21 |  |  |  | 5
Base | B33 | 14 | 8 | 26 |  |  |  | 6
Base | B36 | 16 | 9 | 29 |  |  |  | 7
Base Sink | SB30 | 5 | 4 | 6 |  |  |  | 8
Base Sink | SB33 | 10 | 8 | 15 |  |  |  | 10
Base Sink | SB36
Wall | W09 | 2 | 1 | 7
Wall | W12 | 4 | 2 | 14
Wall | W15 | 6 | 3 | 21
Wall | W18 | 8 | 4 | 28
Wall | W24 | 10 | 5 | 36
Wall | W30 | 12 | 6 | 41
Wall | W33 | 14 | 7 | 48
Wall | W36 | 16 | 8 | 54
[NAME] | LAZY1 | 4 | 7 | 15
[NAME] | LAZY2 | 8 | 14 | 30
Pantry | PC18 | 12 | 8 | 14
Pantry | PC24 | 20 | 16 | 28
Crowns | TOP | 6 | 9 | 10
Crowns | BOTTOM | 12 | 18 | 20
Spreadsheet: 223d8fca-4d8c-44f1-99b8-95abb3beb73e
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
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 37. Value of Building Approved - Australian Capital Territory
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  New ; |  |  | Original | A420494A | 1970-07-01 00:00:00 | 2009-09-01 00:00:00 | 471 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A420503T | 1973-07-01 00:00:00 | 2009-09-01 00:00:00 | 435 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  Total (Type of work) ; |  |  | Original | A420515A | 1973-07-01 00:00:00 | 2009-09-01 00:00:00 | 435 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total non-residential building ;  Total (Type of work) ; |  |  | Original | A421178T | 1970-07-01 00:00:00 | 2009-09-01 00:00:00 | 471 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total building ;  Total (Type of work) ; |  |  | Original | A422865L | 1973-07-01 00:00:00 | 2009-09-01 00:00:00 | 435 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 159301d1338573457-help-with-price-size-quantity-forumula-tigeravatar-example-for-jmbones
Sheet: Sheet1

 |  |  | Size | Qty | Total |  |  | Size | Price
 |  |  | 5X | 5 | 90 |  |  | S | 15
 |  |  | L | 3 | 45 |  |  | M | 15
 |  |  | 4X | 5 | 90 |  |  | L | 15
 |  |  | XL | 3 | 45 |  |  | XL | 15
 |  |  | XL | 4 | 60 |  |  | 2X | 17
 |  |  | S | 5 | 75 |  |  | 3X | 17
 |  |  | S | 5 | 75 |  |  | 4X | 18
 |  |  | 3X | 1 | 17 |  |  | 5X | 18
 |  |  | 5X | 4 | 72
 |  |  | 3X | 3 | 51
 |  |  | L | 1 | 15
 |  |  | 5X | 2 | 36
 |  |  | S | 4 | 60
 |  |  | 2X | 1 | 17
 |  |  | 4X | 3 | 54
 |  |  | 3X | 1 | 17
 |  |  | 4X | 1 | 18
 |  |  | L | 2 | 30
 |  |  | 5X | 5 | 90
 |  |  | 2X | 2 | 34
 |  |  | XL | 2 | 30
 |  |  | 5X | 3 | 54
 |  |  | M | 3 | 45
 |  |  | 2X | 4 | 68
 |  |  | S | 4 | 60
 |  |  | 3X | 5 | 85
 |  |  | 5X | 5 | 90
 |  |  | S | 5 | 75
 |  |  | 4X | 2 | 36
 |  |  | S | 4 | 60
 |  |  | XL | 4 | 60
 |  |  | 5X | 3 | 54
 |  |  | S | 3 | 45
 |  |  | XL | 1 | 15
 |  |  | 4X | 2 | 36
 |  |  | 3X | 1 | 17
 |  |  | 3X | 5 | 85
 |  |  | S | 5 | 75
 |  |  | 4X | 4 | 72
 |  |  | XL | 5 | 75
Spreadsheet: 874639d1721207847-problem-with-loop-in-excel-circular-references-that-creates-errors-ex_model
Sheet: Sheet2

size | 5 | MW
efficiency  system | 0.6
[NAME] | 33 | kwh/kg |  |  | system is dependent on tank inventory
[NAME] - load | 0.8 |  |  |  | tank - start with 100 just the 1h, I dont want tank to go under min, this is why i want to adjust electrolyzer up and down
min -load | 0.2
[NAME] tank | 350 | [NAME]
min-tank | 10 | [NAME]
start tank | 100 | [NAME]
energy (kwh) | system size to meet energy (kw) | system (kW) | biogas produced (kg) | biogas required (kg) | diff [NAME] | energy from system (kwh) | additional heat | [NAME] to tank | adding to tank | Tank inventory (kg)
4567
4568
4569
4570
Spreadsheet: tracy_geaccone__40332__Enron Goodwill Analysis-June 30 version tt
Sheet: debt to capital ratio

Enron Goodwill Analysis
Debt/Capital
 |  |  |  | Pro-Forma Write-off
 |  | December 2000 |  |  | 500 |  | 1000 |  | 1500 |  | 2000
 |  | 0.409 |  |  | 0.417 |  | 0.426 |  | 0.435 |  | 0.444
 |  | March 2001
 |  | 0.442 |  |  | 0.45 |  | 0.459 |  | 0.468 |  | 0.477
 |  | December 2001
 |  | 0.43 |  |  | 0.438 |  | 0.446 |  | 0.455 |  | 0.464
Spreadsheet: 851819d1701958127-how-can-i-use-if-formula-in-a-pivot-table-test
Sheet: PIVOT TABLE

Row Labels | Sum of QUANTITY | <14 |  |  | Result that I want |  |  |  | [NAME] that I used
T-shirt | 15 |  |  |  | False |  |  |  | IF(B4<14,True,False)
Shoes | 14 |  |  |  | False
Pants | 13 |  |  |  | True
Suit | 12 |  |  |  | True
Dress | 10 |  |  |  | True
Spreadsheet: 767088d1644286451-xlookup-when-both-the-lookup-value-and-lookup-array-are-separated-by-commas-journal-example-revised
Sheet: Sheet 1

Journal title | ISSN | Correct Value (Journal Type) | Using VLOOKUP Formula
Acta oto-[NAME] case reports | 2377-2484 | Specialist
Galen Medical Journal | Basically | Specialist
Resuscitation Plus | 2666-5204 | Not found
JCO precision oncology | 2473-4284 | Not found
Life science alliance | 2575-1077 | Not found
European Endodontic Journal | 2548-0839 | Journal
Emotions: History, Culture, Society | 2206-7485, 2208-522X | Specialist
STAR Protocols | 2666-1667 | Not found
Current Research in Biotechnology |  | Not found
[NAME] | 0719-3815 | Not found
[NAME] | 2469-1178 | Specialist
Sport, Exercise, and Performance Psychology | 2157-3905, 2157-3913 | Specialist
EClinicalMedicine | 2589-5370 | Not found
Anaesthesia, critical care & pain medicine | 2352-5568 | Not found
Microbiology Spectrum | 2165-0497 | Not found
Rheumatology and therapy | 2198-6576, 2198-6584 | Specialist
Australian journal of general practice | 2208-794X, 2208-7958 | Specialist
International Review of Environmental History | 2205-3204 | Not found
The Conversation | 2201-5639 | Not found