tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 59805d1260362432-getting-averages-from-seperate-worksheets-2010
Sheet: My Overview

 | Month | January | February | March | April | May | June | July | August | September | October | November | December | Total
 | Target | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total Sales | - | - | - | - | - | - | - | - | - | - | - | - | -
 | % of Target Achieved | - | - | - | - | - | - | - | - | - | - | - | - | -
 | [NAME] | - | - | - | - | - | - | - | - | - | - | - | - | -
 | QA | 0.48 | 0.48 | 1 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | Quarter 1 Totals - Januray, February and March
 | Consultant | Sales | Leads | QA Score
 | Mpho | 0
 | [NAME] | 0
 | Glodean ([NAME]) | 0
 | [NAME] | 0
 | Lehlohonolo | 0
 | Matshidiso | 0
 | Rachel | 0
 | Naledi G | 0
 | Innocentia | 0
 | Glyndine | 0
Spreadsheet: 747528d1631554557-formula-to-automatically-calculate-the-current-pto-accrual-by-paycheck-date-pto-for-year-to-last-pay-date-chocolista-
Sheet: Emp Leave

Employee | Time Off  Start Date | Time Off End Date | Type of Time Off | Hours Taken | Comments
Jones, Greg | 2021-01-18 00:00:00 | 2021-01-18 00:00:00 | Sick
Jones, Greg | 2021-01-27 00:00:00 | 2021-01-27 00:00:00 | Vacation
[NAME], [NAME] | 2021-01-21 00:00:00 | 2021-01-21 00:00:00 | Vacation | 8
[NAME], [NAME] | 2021-01-27 00:00:00 | 2021-01-27 00:00:00 | Half Day | 4
Adams, [NAME] | 2021-02-04 00:00:00 | 2021-02-04 00:00:00 | Half Day | 4
Spreadsheet: 19f771e9-7a95-4dd9-b461-3b97d6d97c05
Sheet: 8

 | Dec 14 |  | Dec 21 |  | Dec 28 |  | Jan 4
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rates* | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs** | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Equities | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Commodities | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly total, estimated swap dollar volumes by asset class and participant type (value of all trades in milliions of USD), all products and tenors, cleared and uncleared.
Estimates of weekly event volumes are derived from data published in the 2012 ISDA Operations Benchmarking Survey which defines an "event" as a new trade, confirmable amendment, partial or full termination, increase, decrease, or novation.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 771021d1646389326-custom-time-breakdown-customtimebreackdown_example
Sheet: Φύλλο1

 | OFF TOTAL TIME | TOTAL SHIFTS OFF | REMAINING HOURS OFF
MACHINE 1 | 7:55:00 |  | I need the remaing 55 minutes here
MACHINE 2 | 1 day, 23:30:00 |  | 6*7=42 so I need the remaining 5 h and 30 minutes here
MACHINE 3 | 2 days, 1:00:00 |  | I need 0 h 00 minutes here
MACHINE 4 | 10:15:00 |  | I need 3 h and 15 minutes here
MACHINE 5 | 3:50:00 |  | I need 50 minutes here
Spreadsheet: 93886d1293655919-need-help-on-nested-if-statement-example
Sheet: Sheet1

 | Ship | Invoice | Prod | Inv | DOS
Week 21 |  |  | 129230 | 281061
Week 22 | 143179 | 119401 | 106629 | 244511
Week 23 | 114629 | 108588 | 117813 | 247695
Week 24 | 137433 | 128794 | 140111 | 250373
Week 25 | 135212 | 134335 | 159597 | 274758
Week 26 | 137889 | 108670 | 143902 | 280771
Week 27 | 133547 | 104278 | 95723 | 242947
Week 28 | 101955 | 125136 | 139340 | 280332
Week 29 | 135157 | 133540 | 173838 | 319013
Week 30 | 198935 | 123848 | 119226 | 239304
Week 31 | 260513 | 164958 | 172347 | 151138
Week 32 | 168814 | 299092 | 153292 | 135616
Spreadsheet: 744987d1629636985-count-frequency-if-this-or-that-for-events-sample1
Sheet: Example

 | 2021-08-22 00:00:00 | 2021-08-23 00:00:00 | 2021-08-24 00:00:00 | 2021-08-25 00:00:00 | 2021-08-26 00:00:00 | 2021-08-27 00:00:00 | 2021-08-28 00:00:00 | 2021-08-29 00:00:00 | 2021-08-30 00:00:00 |  | All Days | Events | Weekends | Working DAYS
Name 1 | S | S | S |  |  | S | S | S
Name 2 |  | S | S | X | S |  |  |  |  |  |  |  |  |  |  | The "Events" heading in column "M" is counting the frequency of "S", I would like this to count the frequency of "S" OR "X"  - the highlighted examples are "2 frequency events" that should be counted as "1 Frequency event"
Name 3 | S | S
Name 4
Name 5 |  | S | S | S |  |  | S | S | S
Name 6 |  |  | X | X
Name 7 |  | S | X | S
Name 8 | S | S | S | S | S | S | X | X
 | Manual adjustment example data - highlighted cells
 | 2021-08-22 00:00:00 | 2021-08-23 00:00:00 | 2021-08-24 00:00:00 | 2021-08-25 00:00:00 | 2021-08-26 00:00:00 | 2021-08-27 00:00:00 | 2021-08-28 00:00:00 | 2021-08-29 00:00:00 | 2021-08-30 00:00:00 |  | All Days | Events | Weekends | Working DAYS
Name 1 | S | S | S |  |  | S | S | S
Name 2 |  | S | S | X | S |  |  |  |  |  |  | 1 |  |  |  | The highlighted events and corresponding cells have been manually adjusted to reflect the intended "Count Frequency IF OR" formula result
Name 3 | S | S
Name 4
Name 5 |  | S | S | S |  |  | S | S | S
Name 6 |  |  | X | X
Name 7 |  | S | X | S |  |  |  |  |  |  |  | 1
Name 8 | S | S | S | S | S | S | X | X
Name 9 |  | S | X |  | S | X | S | S | S |  |  | 2
 | SUM(IF(FREQUENCY(IF(OR(B27:J27="S",B27:J27="-"),COLUMN(B27:J27)),IF(OR(B27:J27<>"S",B27:J27<>"-"),COLUMN(B27:J27)))>0,1)) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Failed IF OR attempt
 | SUM(IF(FREQUENCY(IF(A28:J28={"S","-"},COLUMN(A28:J28)),IF(A28:J28<>{"S","-"},COLUMN(A28:J28)))>0,1)) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Failed "Array" in an Array Formula attempt
Spreadsheet: 739537d1625760487-pulling-data-from-multiple-sheets-as-summary-kyber
Sheet: Tab 1

 |  |  |  |  |  |  |  |  |  |  |  | Sheets
 |  |  |  |  |  |  |  |  |  |  |  | Sheet1
Insurance | ID | Client Name | Meeting | # CNS | 60+ min? | Agent | CNS if [NAME] from Other Sess | Notes |  |  |  | Sheet2
Insurance 1 | 91966 | [NAME] | In Person | 1 |  | [NAME] |  |  |  |  |  | Sheet3
Insurance 2 | 88341 | Amber Riley
Insurance 3 | 33848 | [NAME]
Insurance 1 | 23739 | [NAME]
Insurance 2 | 43135 | [NAME]
Insurance 3 | 25826 | [NAME]
Insurance 1 | 80559 | [NAME]
Insurance 2 | 47064 | [NAME]
Insurance 3 | 84667 | [NAME]
Insurance 1 | 20382 | [NAME]
Insurance 2 | 50915 | [NAME]
Insurance 3 | 68065 | Cooper Manning
Insurance 1 | 67507 | [NAME]
Insurance 2 | 33733 | [NAME]
Insurance 3 | 39903 | [NAME]
Insurance 1 | 36003 | [NAME]
Insurance 2 | 99670 | [NAME]
Insurance 3 | 25465 | [NAME]
Insurance 1 | 53132 | [NAME]
Insurance 2 | 28902 | Eddie Izzard
Insurance 3 | 26732 | Eli Manning
Insurance 1 | 23030 | [NAME]
Insurance 2 | 75022 | [NAME]
Insurance 3 | 97961 | [NAME]
Insurance 1 | 64035 | [NAME]
Insurance 2 | 94388 | [NAME]
Insurance 3 | 31467 | [NAME]
Insurance 1 | 25339 | [NAME]
Insurance 2 | 36788 | [NAME]
Insurance 3 | 17279 | [NAME]
Insurance 1 | 50337 | [NAME]
Insurance 2 | 66334 | [NAME]
Insurance 3 | 62503 | [NAME]
Insurance 1 | 87608 | [NAME]
Insurance 2 | 64761 | [NAME]
Insurance 3 | 99567 | [NAME]
Insurance 1 | 80934 | [NAME]
Insurance 2 | 65131 | [NAME]
Insurance 3 | 24935 | [NAME]
Insurance 1 | 55156 | [NAME]
Insurance 2 | 40011 | [NAME]
Insurance 3 | 96790 | [NAME]
Insurance 1 | 71048 | [NAME]
Insurance 2 | 52278 | [NAME]
Insurance 3 | 46668 | [NAME]
Insurance 1 | 34486 | [NAME]
Insurance 2 | 84325 | [NAME]
Insurance 3 | 28777 | [NAME]
Insurance 1 | 72276 | [NAME]
Insurance 2 | 71450 | [NAME]
Insurance 3 | 86623 | [NAME]
Insurance 1 | 32805 | [NAME]
Insurance 2 | 64061 | Mitch Albom
Insurance 3 | 25334 | [NAME]
Insurance 1 | 33059 | Neve Campbell
Insurance 2 | 29584 | [NAME]
Insurance 3 | 65246 | [NAME]
Insurance 1 | 47991 | [NAME]
Insurance 2 | 20114 | [NAME]
Insurance 3 | 89474 | [NAME]
Insurance 1 | 94616 | [NAME]
Insurance 2 | 13337 | [NAME]
Insurance 3 | 33899 | [NAME]
Insurance 1 | 38877 | [NAME]
Insurance 2 | 54773 | [NAME]
Insurance 3 | 80147 | Sacha Baron [NAME]
Insurance 1 | 91024 | [NAME]
Insurance 2 | 49371 | [NAME]
Insurance 3 | 31930 | [NAME]
Insurance 1 | 93600 | [NAME]
Insurance 2 | 31883 | Smothers Brothers[B]
Insurance 3 | 53724 | [NAME]
Insurance 1 | 51599 | [NAME]
Insurance 2 | 95631 | [NAME]
Insurance 3 | 69745 | [NAME]
Insurance 1 | 89418 | [NAME]
Insurance 2 | 78101 | [NAME]
Spreadsheet: 717282d1612552894-help-in-calculation-and-filter-help-in-calculation-1-
Sheet: Sheet2

Site | (All)
Years | 2020
Row Labels | Sum of Totalbatches | Sum of TotalRejection
Jan | 96 | 15
Feb | 25 | 2
Mar | 34 | 0
Apr | 10 | 2
May | 38 | 4
Jun | 24 | 7
Jul | 9 | 0
Aug | 10 | 2
Sep | 15 | 9
Oct | 25 | 2
Nov | 9 | 0
Dec | 22 | 11
Grand Total | 317 | 54
Spreadsheet: 733499d1621601735-using-a-sum-array-to-grade-homework-with-multiple-correct-answers-best-practice-for-grading-multiple-correct-answers-with-sum
Sheet: Example Gradebook 102

Class | Seat Number | Name | Overall Grade | Assignment A /3 | Assignment X /4 | Assignment Y /2
102 | 1 | Zebra
102 | 2 | X
102 | 3 | Wilson
102 | 4 | Vader |  | not
102 | 5 | Umbrella |  |  | important for
102 | 6 | [NAME] |  |  |  | this example
102 | 7 | [NAME]
102 | 8 | [NAME]
102 | 9 | Quagmire
102 | 10 | Pony
Total
Spreadsheet: 829150d1683973917-large-data-set-into-pro-forma-format-book1-charity
Sheet: Sheet1

 | Category | Type Code | Type Name | Date | Location | Amount
 | Revenue | 100 | Donations | 2023-01-21 00:00:00 | London | 2000 |  | London | January | February | March |  | [NAME] | January | February | March
 | Revenue | 200 | Sales Income | 2023-01-31 00:00:00 | [NAME] | 500
 | Revenue | 200 | Sales Income | 2023-02-14 00:00:00 | London | 600 |  | Revenue |  |  |  |  | Revenue
 | Revenue | 200 | Sales Income | 2023-01-14 00:00:00 | London | 800 |  | Cost of Sales |  |  |  |  | Cost of Sales
 | Revenue | 100 | Donations | 2023-01-10 00:00:00 | London | 1500 |  | Overheads |  |  |  |  | Overheads
 | Revenue | 100 | Donations | 2023-03-21 00:00:00 | London | 1700 |  | Profit/Loss |  |  |  |  | Profit/Loss
 | Revenue | 100 | Donations | 2023-03-02 00:00:00 | London | 200
 | Revenue | 100 | Donations | 2023-02-22 00:00:00 | London | 600
 | Revenue | 200 | Sales Income | 2023-01-10 00:00:00 | [NAME] | 600
 | Revenue | 200 | Sales Income | 2023-03-30 00:00:00 | [NAME] | 1000
 | Cost of Sales | 500 | Volunteer expenses | 2023-01-31 00:00:00 | [NAME] | -200
 | Overheads | 800 | Advertising - print | 2023-01-05 00:00:00 | London | -250
 | Overheads | 805 | Advertising - online | 2023-03-27 00:00:00 | London | -300
 | Overheads | 600 | Admin salary | 2023-01-25 00:00:00 | London | -300
 | Cost of Sales | 500 | Volunteer expenses | 2023-02-28 00:00:00 | [NAME] | -150
 | Cost of Sales | 500 | Volunteer expenses | 2023-03-31 00:00:00 | [NAME] | -250
 | Overheads | 800 | Advertising - print | 2023-02-19 00:00:00 | London | -250
 | Overheads | 700 | Rent - shop | 2023-01-02 00:00:00 | [NAME] | -100
 | Overheads | 700 | Rent - shop | 2023-02-02 00:00:00 | [NAME] | -100
 | Overheads | 700 | Rent - shop | 2023-03-02 00:00:00 | [NAME] | -100
 | Overheads | 750 | Rent - HQ | 2023-01-14 00:00:00 | London | -600
 | Revenue | 200 | Sales Income | 2023-02-07 00:00:00 | London | 1200
 | Overheads | 600 | Admin salary | 2023-02-25 00:00:00 | London | -300
 | Overheads | 600 | Admin salary | 2023-02-25 00:00:00 | London | 0
 | Overheads | 850 | Legal | 2023-02-02 00:00:00 | London | -1000
Spreadsheet: sara_shackleton__36501__ENE MTM 0630 revised 2
Sheet: SBC Warburg

 | SBC Warburg
 | Forward
Settlement | Trade Date | Maturity Date | Common Stock | Shares | Intial Price | Notional Price | 1998-12-31 00:00:00
Physical | 1997-12-11 00:00:00 | 1999-12-13 00:00:00 | ENE | 1099773 | 44.075 |  | 57.0625
 | 1999-07-06 00:00:00 |  | ENE | 610325 | 79.8177
 | 1999-08-16 00:00:00
 |  |  |  | Forward Contract
 |  | Forward
 |  | New Forward
 | Note:  Note MTM actiivty, will take the gain/loss at unwind date.
Spreadsheet: 874857d1721368868-translating-table-for-importin-erp-paulkloos-excel-forum-question-aligw
Sheet: Blad1

 | Input
 | Customer | Pricelist 1 | Pricelist 2 | Pricelist 3 | Pricelist 4 | Pricelist 5
 | L10000 | 41 | 42 | 43 | 44 | 45
 | [NAME] | 61 | 62
 | [NAME] | 71 | 72 | 73
 | [NAME] | 81 | 82 | 83 | 84 | 85
 | L50000 | 91 | 93 | 95
 | Output
 |  | L10000
 | 42 | L10000
 | 43 | L10000
 | 44 | L10000
 | 45 | L10000
 | 61 | [NAME]
 | 62 | [NAME]
 | 71 | [NAME]
 | 72 | [NAME]
 | 73 | [NAME]
 | 81 | [NAME]
 | 82 | [NAME]
 | 83 | [NAME]
 | 84 | [NAME]
 | 85 | [NAME]
 | 91 | L50000
 | 93 | L50000
 | 95 | L50000
Spreadsheet: 101395d1299536177-extract-correct-denomination-of-bills-money-counter-remove-large-bills-remove-money-1-does-not-work
Sheet: Sheet2

Thursday
Chaya
2011-02-24 00:00:00
 | 1292.29 | 1142.29
Morning
Quantity | Denomination | Total |  |  |  | Qty | Denomination | Calc qty
0 | 0
3 | 100 | 3 |  |  |  | 6 | 100 | 0
3 | 100 | 3 |  |  |  | 0 |  | 0
0 | 50 | 0 |  |  |  | 31 | 20 | 0
31 | 20 | 27 |  |  |  | 3 | 10 | 0
3 | 10 | -8 |  |  |  | 7 | 5 | 0
7 | 5 | -22 |  |  |  | 0 | 2 | 0
2 | 1 | -143 |  |  |  | 2 | 1 | 0
16 | 0.25 | -579 |  |  |  | 0 | 0.5 | 0
1 | 0.1 | -1488 |  |  |  | 16 | 0.25 | 0
23 | 0.05 | -2977 |  |  |  | 1 | 0.1 | 0
4 | 0.01 | -14996 |  |  |  | 23 | 0.05 | 0
 | 10 |  |  |  |  | 4 | 0.01 | 0
 | 5 |  |  |  |  |  |  |  | 0
 | 2 |  |  |  |  |  |  | 0
 | 0.5
 |  |  |  |  |  |  | 1292.29
0 |  |  | 1316
Subject: Cash drawer bill extractor
Message Body:
I need to setup a template to remove the largest available (Qty and denomination)bills and leave exactly $150 back in the cash drawer in small bills, change and rolls of change.
In the atatched worksheet,for example, I need to remove exactly $ 1178.29 in large bills and leave the remaining $150 (from a total of $1329.29 in the register) in small bills and change.
Spreadsheet: 194060d1353024245-filtering-data-and-then-re-filtering-that-data-help-suggestions-please-membership-database-and-log-copy
Sheet: Payment Log

Payment Log
Notes: For other sheets to calculate properly the payment dates must be accending! If you sort to see all payment records for a member then re-sort by payment date.
Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9 | Column 10
Payment ID | Member ID | Last Name | First Name | Membership Type | Member Price | Payment Date | Payment Type | Payment Length | Payment Amount
 | mil7890 |  |  |  |  | 2012-10-08 00:00:00 | Cash | 1 Week | 60
 | mil7890 |  |  |  |  | 2012-10-01 00:00:00 | Cash | 2 Weeks | 120
 | mil8901 |  |  |  |  | 2012-10-10 00:00:00 | Check | 10 Sessions | 1
 | mil9012 |  |  |  |  | 2012-10-11 00:00:00 | Cash | 3 Months | 2
 | Smi0123 |  |  |  |  | 2012-10-12 00:00:00 | Cash | 1 Week | 3
 | Doe1234 |  |  |  |  | 2012-10-13 00:00:00 | Cash | 2 Weeks | 4
 | Doe2345 |  |  |  |  | 2012-10-14 00:00:00 | Credit Card | 1 Month | 5
 | mil7890 |  |  |  |  | 2012-10-10 00:00:00 | Cash | Other | 6
 | mil9012 |  |  |  |  | 2012-10-16 00:00:00 | Cash | Drop In | 7
 | Smi0123 |  |  |  |  | 2012-10-17 00:00:00 | Credit Card | 10 Sessions | 8
 | Smi0123 |  |  |  |  | 2012-10-18 00:00:00 | Cash | Other | 9
 | Doe1234 |  |  |  |  | 2012-10-19 00:00:00 | Cash | 1 Week | 10
 | Doe2345 |  |  |  |  | 2012-10-20 00:00:00 | Cash | 3 Months | 11
 | Smi0123 |  |  |  |  | 2012-10-21 00:00:00 | Check | 10 Sessions | 12
 | mil9012 |  |  |  |  | 2012-10-22 00:00:00 | Credit Card | 1 Month | 13
 | mil7890 |  |  |  |  | 2012-11-15 00:00:00 | Check | 10 Sessions | 14
 | mil7890 |  |  |  |  | 2012-11-16 00:00:00 | Check | Drop In | 15
Spreadsheet: 71830d1272539944-excel-2007-sales-and-stock-register-spreadsheet-projectv2-tw-
Sheet: Invoice

Date | 2010-04-29 00:00:00 |  |  |  |  | vat | 0.175
Barcode | product description | unit cost | quantity | total cost
101 | coke | 0.59 | 3 | 1.77
103 | crisps | 0.35 | 4 | 1.4
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  | Total |  | 3.17
 |  | VAT 17.5% |  | 0.55475
 |  | 5% Discount if over £100 |  | 0
 |  | Grand total |  | 3.72475
Spreadsheet: 844006d1695814315-data-getting-error-tet
Sheet: Sheet1

 |  |  | Costing | CPM | quality | Iteam | Add
 |  |  | 50
 |  |  | Costing | CPM | quality | Iteam | Add
 |  |  | 100 > 1000 | 0 | 0
 |  |  | 1001 > 3000 | 0 | 0
 |  |  | 3001 > 5000 | 0 | 0
 |  |  | 5000 > 10000 | 70 | 300*250
 |  |  | 10000 > 50000 | 50 | 343*600
 |  |  | 50000> 100000 | 50 | 343*600
Spreadsheet: andy_zipper__135__ICE - Mar07 Power & Gas VOL
Sheet: Financial Gas

 |  |  |  |  |  |  | FINANCIAL GAS VOLUME |  |  | TRANSACTIONS
'); } else { document.write(''); } } else { if (navigator.platform == "[NAME]") { document.write(''); } else { document.write(''); } }
Commodity Type:   Financial Gas Swaps/Forwards
Hub:  All
Trade Dates:  Mar-7-01 thru Mar-7-01
 | Description | Strip | Low Price | High Price | Weighted | Last Price | Last Price Date | Volume
 |  |  |  |  | Average Price
 | NG Fin BS, LD1 for GDM
 | NG Fin BS, LD1 for GDM - Mich - Apr01-Oct01 | Apr01-Oct01 | 0.24 | 0.24 | 0.24 | 0.24 | Mar-07-01 16:13 GMT | 1070000 | MMBtus
 | NG Fin BS, LD1 for IF
 | NG Fin BS, LD1 for IF - Panhandle - Apr01-Oct01 | Apr01-Oct01 | -0.07 | -0.07 | -0.07 | -0.07 | Mar-07-01 14:17 GMT | 2140000 | MMBtus
 | NG Fin BS, LD1 for IF - Transco Z6 (NY) - Apr01-Oct01 | Apr01-Oct01 | 0.5 | 0.5 | 0.5 | 0.5 | Mar-07-01 16:36 GMT | 1070000 | MMBtus
 | NG Fin BS, LD1 for NGI
 | NG Fin BS, LD1 for NGI - Chicago - Apr01-Oct01 | Apr01-Oct01 | 0.15 | 0.15 | 0.15 | 0.15 | Mar-07-01 20:26 GMT | 1070000 | MMBtus
 | NG Fin BS, LD1 for NGI - Socal - Nov01-Mar02 | Nov01-Mar02 | 2.09 | 2.09 | 2.09 | 2.09 | Mar-07-01 19:17 GMT | 755000 | MMBtus
 | NG Fin Sw Swap, FP for GDD
 | NG Fin Sw Swap, FP for GDD - Henry - Bal Month Gas | Bal Month Gas | 5.185 | 5.225 | 5.205 | 5.185 | Mar-07-01 19:16 GMT | 470000 | MMBtus
 | NG Fin Sw Swap, FP for GDD - PG&E-Citygate - Bal Month Gas | Bal Month Gas | 10.35 | 10.35 | 10.35 | 10.35 | Mar-07-01 16:05 GMT | 120000 | MMBtus
 | NG Fin, FP for LD1
 | NG Fin, FP for LD1 - Henry - Apr01 | Apr01 | 5.225 | 5.37 | 5.305 | 5.37 | Mar-07-01 21:31 GMT | 12450000 | MMBtus
 | NG Fin, FP for LD1 - Henry - May01 | May01 | 5.28 | 5.385 | 5.348 | 5.385 | Mar-07-01 20:07 GMT | 1240000 | MMBtus
 | NG Fin, FP for LD1 - Henry - Apr01-Oct01 | Apr01-Oct01 | 5.385 | 5.385 | 5.385 | 5.385 | Mar-07-01 19:24 GMT | 1070000 | MMBtus
 | NG Fin, FP for LD1 - Henry - Cal 02 | Cal 02 | 4.91 | 4.91 | 4.91 | 4.91 | Mar-07-01 15:49 GMT | 3650000 | MMBtus
Spreadsheet: 796639d1663411688-xlookup-with-multiple-criteria-options-example-workbook-5-aligw
Sheet: Results

Country | Guests | Head of State
Oman
Denmark
Japan
[NAME]
Bahrain
Andorra
Monaco
Bhutan
Netherlands
Spreadsheet: eric_saibi__9742__011402R
Sheet: San Juan 04

Owner Name |  | Public Service Co. of NM
Station Name |  | San Juan Generating Station
Unit Name |  | San Juan 04
NERC Region |  | WSCC
State |  | NM
Fuel Type |  | Coal
Capacity |  | 534 MW
Start Date |  | 2002-01-10 00:00:00
End Date |  | 2002-01-13 00:00:00
Prv. Start Date |  | 2002-01-10 00:00:00
Prv. End Date |  | 2002-01-14 00:00:00
Comments |  | Tube leak
SIC |  | 4911
Plant ID |  | 1016385
Unit ID |  | 1007773
Outage ID |  | 19445
Spreadsheet: 705176d1605901891-need-conditional-formatting-to-highlight-if-greater-than-a-cell-but-not-highlight-if-less-example-of-quotation-sheeta
Sheet: Quotation

 |  |  |  |  | Quotation
 |  |  |  |  | DATE OF QUOTE | Sept. 21st 2020
 |  |  |  |  | Customer #
 | Quotation For:
 | Name |  |  |  | Prepared by:
 | Company Name |  |  |  | SLOC #: | 2
 | Street Address
 | City, ST, Zip
 | Phone
 |  |  |  |  | T = Taxable or      Leave Blank
 | PART NUMBER | QTY | [NAME] | UNIT PRICE | TAXABLE? | AMOUNT |  |  |  | Current Inventory
 | Z0007-3196-700 | 100 |  |  |  |  |  |  |  | 58
 |  | 75
 |  | 88
 |  | 54
 |  | 21
 |  | 87
 |  | 87
 |  | 11
 |  | 99
 |  | 1
 |  |  |  |  | SUBTOTAL
 | [NAME] FOR 30 DAYS FROM DATE OF QUOTE |  |  |  | TAX RATE
 |  |  |  |  | SALES TAX
 |  |  |  |  | OTHER | 0
 |  |  |  |  | TOTAL
Spreadsheet: 764743d1642946463-how-to-auto-select-2-names-based-on-multiple-criteria-sample-sheet
Sheet: Sheet 1

Ps | Gender | B. # |  |  | P. | B. # | Cost
Vane | F | 0 |  |  | Vane
[NAME] | M | 0 |  |  | [NAME]
Loki | M | 1 |  |  |  | Total Cost
[NAME] | F | 1
Sith | F | 2 |  |  | 0 | 2000
Sia | F | 2 |  |  | 1 | 4000
Thor | M | 2 |  |  | 2 | 6000
[NAME] | M | 2 |  |  | 3 | 10000
Dew | F | 2 |  |  | 4 | 16000
Felk | M | 3 |  |  | 5 | 26000
Eras | F | 3 |  |  | 6 | 42000
Ades | M | 4 |  |  | 7
Adel | F | 5
Tuck | M | 6
Spreadsheet: 122845d1317202789-connecting-formulas-booms1
Sheet: Product Codes

Join "B" + "C" | Company | Product | Code | Country
BT-landline | BT | landline | BT-1 | UK
Talk Talk-landline | Talk Talk | landline | T1 | UK,CZ,ES
O2-monthly contract | O2 | monthly contract | O2-M | CZ,IT,CH
BT-Broadband | BT | Broadband | BT-B
Orange-phones | Orange | phones | O-P | FR,ES,DE
BT-landline | BT | landline | BT-L1 | UK
Orange-phones | Orange | phones | O-MB | FR,ES,DE
Spreadsheet: 46237d1245146999-vlookup-multiple-lines-monthly-qtys
Sheet: Sheet1

Date | Qty
2009-01-01 00:00:00 | 1
2009-01-02 00:00:00 | 1
2009-01-14 00:00:00 | 1
2009-02-02 00:00:00 | 1
2009-03-03 00:00:00 | 1
2009-03-05 00:00:00 | 1
2009-04-04 00:00:00 | 1
 |  |  |  | Total Per Month
 |  |  |  | January | 3
 |  |  |  | February | 1
 |  |  |  | March | 2
 |  |  |  | April | 1
 |  |  |  | May | 0
 |  |  |  | June | 0
 |  |  |  | July | 0
 |  |  |  | August | 0
 |  |  |  | September | 0
 |  |  |  | October | 0
 |  |  |  | November | 0
 |  |  |  | December | 0
Spreadsheet: 024cb822-2b80-42c6-b4d2-2186c5fa5a0f
Sheet: Sheet1

TROOP: |  |  | 2014 Camp Loud Thunder |  |  | LEADER'S NAME:
CAMP DATES: |  |  | MERIT BADGE PREFERENCES |  |  | E-MAIL:
Scout's Name/Age | 9:00am | 10:00am | 10:30am | 11:00am | 1:00/2:00 pm | 3:00pm | 3:30pm | 4:00pm
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Name:
2nd Choice
Spreadsheet: 214360d1360871372-building-complex-sales-projections-could-use-some-help-sales-projections-sample-solution
Sheet: Customer Information

Customer | Transaction Volume | Transaction Sell | Professional Services Fees | Support Fees | Start Date | Ramp in Months | [NAME] in Mths | PM Hours | Senior Tech Hours | [NAME]
Smith & Wesson | 3500 | 1.25 |  |  | 2013-02-01 00:00:00 | 3 | 36 | 30 | 30 | 30
ABC Company | 5000 | 1 | 6000 |  | 2013-03-01 00:00:00 | 6 | 36 | 30 | 30 | 30
 |  |  |  |  |  |  |  | 60 | 60 | 60