tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 703092d1604750092-how-to-count-the-quantity-per-piece-and-box-inventory-quantity
Sheet: Sheet1

 |  |  |  | warehouse |  | sales |  | answer
 | P name | Pieces/box | Purchase | box | pieces | box | pieces | box | pieces
 | P1 | 12 | 13 | 0 | 8 | 1 | 8 | 12 | 4
 | P2 | 4 | 5 | 2 | 2 | 0 | 1 | 7 | 1
 | P3 | 40 | 1 | 3 | 20 | 0 | 50 | 3 | 10
 | P4 | 32 | 2 | 6 | 0 | 1 | 16 | 3 | 16
Spreadsheet: 114734d1310470065-total-from-multiple-spreadsheets-music2011sales
Sheet: May

TC Reporting Month | # [NAME] | PayRate for one sold | Total Earned | Currency | Album Title | [NAME] | Name of store or service | Country Of Sale
2011-01-01 00:00:00 | 1 | 0.49 | 0.762341962956 | GBP | Touching The Winky | Shapes | Amazon MP3 | GB
2011-03-01 00:00:00 | 1 | 0.7 | 0.7 | USD | Touching The Winky | Touching Things Is Fun (the Winky Song) | iTunes U.S. | US
2011-03-01 00:00:00 | 1 | 0.7 | 0.7 | USD | The Triple Coiler | Robots | iTunes U.S. | US
2011-03-01 00:00:00 | 1 | 0.7 | 0.7 | USD | Touching The Winky | It's a Penis | iTunes U.S. | US
2011-03-01 00:00:00 | 1 | 0.7 | 0.7 | USD | Touching The Winky | Vegetables | iTunes U.S. | US
2011-03-01 00:00:00 | 4 | 0.99 | 3.94622510238 | AUD | Touching The Winky | Touching Things Is Fun (the Winky Song) | iTunes AU/NZ | AU
2011-03-01 00:00:00 | 155 | 0.92 | 205.7261689982 | EUR | [NAME] | [NAME] | iTunes UK/EU | GB
2011-03-01 00:00:00 | 9 | 0.71 | 9.21872524473 | EUR | Touching The Winky | Touching Things Is Fun (the Winky Song) | iTunes UK/EU | GB
Spreadsheet: 767443d1644479424-sumifs-different-array-size-test-sheet
Sheet: Master View

City | Date | Lead
Paris | 2022-01-01 00:00:00
Amsterdam | 2022-01-02 00:00:00
Tokyo | 2022-01-03 00:00:00
Paris | 2022-01-04 00:00:00
New York | 2022-01-05 00:00:00
Paris | 2022-01-06 00:00:00
Tokyo | 2022-01-07 00:00:00
Amsterdam | 2022-01-08 00:00:00
New York | 2022-01-09 00:00:00
Paris | 2022-01-10 00:00:00
Spreadsheet: 805687d1668835286-count-the-transaction-based-on-the-date-count-transaction-based-on-the-date
Sheet: Sheet1

DateTimeReceived |  |  | Date | Count | Output required
2022-11-01 10:25:06 |  |  |  |  | 2
2022-11-19 08:46:55 |  |  | 2022-11-03 00:00:00 |  | 1
2022-11-01 00:12:48 |  |  | 2022-11-10 00:00:00 |  | 1
2022-11-03 23:52:29 |  |  | 2022-11-17 00:00:00 |  | 1
2022-11-18 23:38:00 |  |  | 2022-11-18 00:00:00 |  | 3
2022-11-18 22:36:47 |  |  | 2022-11-19 00:00:00 |  | 1
2022-11-17 22:36:34 |  |  | Total
2022-11-18 21:40:06
2022-11-10 21:15:24
Spreadsheet: 220185d1363092382-pivot-table-grand-total-percentage-error-grand-total-
Sheet: Sheet1

Activities | Income | Expense | % | Type
A | 50 | 20 | 1.5 | Drama
B | 150 | 100 | 0.5 | Drama
C | 100 | 80 | 0.25 | Drama
X | 1000 | 900 | 0.1111111111111111 | Arts
Y | 900 | 800 | 0.125 | Arts
D | 90 | 180 | -0.5 | Music
E | 100 | 150 | -0.3333333333333333 | Tennis
Type | Drama
 | Data
Activities | Sum of Income | Sum of Expense | Sum of %
A | 50 | 20 | 1.5
B | 150 | 100 | 0.5
C | 100 | 80 | 0.25
Grand Total | 300 | 200 | 2.25
Spreadsheet: 236265d1368733680-autoflow-to-calender-test
Sheet: Sheet2

2013-05-01 00:00:00 |  |  | 2013-05-02 00:00:00 |  |  | 2013-05-03 00:00:00 |  |  | 2013-05-04 00:00:00 |  |  | 2013-05-05 00:00:00 |  |  | 2013-05-06 00:00:00 |  |  | 2013-05-07 00:00:00
2013-05-08 00:00:00 |  |  | 2013-05-09 00:00:00 |  |  | 2013-05-10 00:00:00 |  |  | 2013-05-11 00:00:00 |  |  | 2013-05-12 00:00:00 |  |  | 2013-05-13 00:00:00 |  |  | 2013-05-14 00:00:00
 |  |  | 11236 | Car | Tax |  |  |  | 11232 | Car | Wash |  |  |  |  |  |  | 11240 | Bike | Service
 |  |  |  |  |  |  |  |  | 11239 | Computer | Password
2013-05-15 00:00:00 |  |  | 2013-05-16 00:00:00 |  |  | 2013-05-17 00:00:00 |  |  | 2013-05-18 00:00:00 |  |  | 2013-05-19 00:00:00 |  |  | 2013-05-20 00:00:00 |  |  | 2013-05-21 00:00:00
11233 | Car | Tax |  |  |  |  |  |  |  |  |  |  |  |  | 11235 | Housekeeping | Clean
2013-05-22 00:00:00 |  |  | 2013-05-23 00:00:00 |  |  | 2013-05-24 00:00:00 |  |  | 2013-05-25 00:00:00 |  |  | 2013-05-26 00:00:00 |  |  | 2013-05-27 00:00:00 |  |  | 2013-05-28 00:00:00
11234 | Baggace | Check
11237 | Ticket | Booking
2013-05-29 00:00:00 |  |  | 2013-05-30 00:00:00 |  |  | 2013-05-31 00:00:00
 |  |  | 11238 | Computer | Service
Spreadsheet: 02e4b555-05a6-40f8-a00e-8401a50136eb
Sheet: 12d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated swap dollar volumes, week ending February 8, by product type and tenor (millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for tenor bucket 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: 219960d1363023130-minute-and-second-formula-issues-question-time
Sheet: Sheet1

Hour | Minutes | Second | Time
2 | 5 | 45 |  |  |  | Total Hours
5 | 45 | 23 |  |  |  | Total Minutes
4 | 14 | 12 |  |  |  | Total Second
 |  |  |  |  |  | Total Hours | try urself --- if you can't, reply to me
 |  |  |  |  |  |  | www.excelsenior.com
 |  |  |  |  |  |  | It include easy maths episode
 |  |  |  |  |  |  | Finance functions such as NPV, IRR, FV, PV, etc
 |  |  |  |  |  |  | Business Statistics episode
 |  |  |  |  |  |  | Mostly usable for finance staff or university or any other relative studies
Spreadsheet: c4e35d29-e99d-4a91-bbfc-db6484c1fdfa
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
FPHEN | Test | FPHEN | Benzene as Phenol, Occupational Exposure, [NAME] | Benzene as Phenol, Occ Exposure, U | Gas Chromatography/Flame Ionization Detection (GC-FID) Spectrophotometry (SPEC) | Plastic, urine tube: PlUrTb |  |  | 10 | mL | Collect 10 mL from a random or spot urine. Send specimen refrigerated. Note:  [NAME] should be filled to prevent loss of volatile  compound in headspace. | 1.2 mL Note: Submission of the m | Specimens other than	[NAME] Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Creatinine:  >50 mg/dL  Normal (unexposed population): 	less than 10 mg/L   Exposed: 	Biological Exposure Index (BEI): 50 mg/g creatinine 		(End of Shift)   Toxic: 	Not Established   Test Performed By:  Medtox Laboratories, Inc.                                         402 W. County Road D                                         St. Paul, MN  55112 | Monday through Sunday | 7 days | 9 - 11 days |  | Profile |  |  |  |  | Medtox Laboratories, Inc
FPHEN | [NAME] | URINE | [NAME] |  |  |  | Refrigerated
FPHEN | Result | Z1201 | Creatinine | Creatinine | Alphanumeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | In Process
FPHEN | Result | Z1063 | Phenol | Phenol | Alphanumeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | In Process
FPHEN | Result | Z1064 | Phenol | Phenol | Alphanumeric |  |  |  |  | mg/g creat |  |  |  |  |  |  |  |  |  | In Process
FPHEN | Billing Component | FPHEN |  | ASSAY OF URINE CREATININE |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 82570
FPHEN | Billing Component | FPHEN |  | Volatiles |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 84600
Spreadsheet: 882048d1730308859-unique-alternative-book1
Sheet: Sheet1

 | SOURCE |  |  | RESULTS
 | Cat
 | Dog
 | Cat
 | Rat
 | Rat
 | Dog
 | Cat
 | Dog
 | Rat
 | Cat
 | Fish
 | Fish
 | Fish
 | Cat
 | Dog
 | Rat
Spreadsheet: 669832d1585613940-multiple-if-conditions-to-determine-the-status-test99
Sheet: Sheet1

User name | Total | Recent | Status
User-1 | 13 | 2 | Good
User-2 | 1 | 1 | Good
User-3 | 5 | 0 | Average
User-4 | 1 | 0 | Average
User-5 | 0 | 0 | Bad
User-6 | 0 | 0 | Bad
Spreadsheet: 376732d1423689019-need-help-applying-conditional-formatting-to-a-whole-work-sheet-price-tape-help-ndm
Sheet: Sheet1

# | Part Number | Short Desc | LIST | TRADE | 50 | +20 | SUB DEALER COST | CORE
1 | ABB0002000 | TUBE | 47.06 | 39.51 |  |  | 21.692 | 0
2 | ABB0002150 | TUBE | 25.35 | 21.56 |  |  | 16.456 | 0
3 | ABF310 | BREATHER | 13.78 | 11.71 |  |  | 8.338000000000001 | 0
4 | ABF310F | BREATHER | 44.96 | 38.21 |  |  | 27.214 | 0
5 | ABF310S | STRAINER | 26.67 | 22.67 |  |  | 16.137 | 0
6 | AB00D31350 | TUBE | 46.67 | 39.76 |  |  | 30.47 | 0
7 | AB00D61350 | TUBE | 33.91 | 28.88 |  |  | 22.132 | 0
8 | AB00J12300 | TUBE | 21.49 | 18.31 |  |  | 14.025 | 0
9 | AB00V11600 | TUBE | 19.94 | 16.98 |  |  | 13.013 | 0
10 | AB00WA0400 | TUBE | 19.47 | 16.58 |  |  | 12.705 | 0
11 | AB00000750 | TUBE | 10.26 | 8.75 |  |  | 6.699000000000001 | 0
12 | AB00007850 | TUBE | 57.62 | 48.98 |  |  | 37.40000000000001 | 0
13 | ACC11755 | LINING | 924.38 | 862.74 |  |  | 691.625 | 0
14 | [NAME] | PLATE | 57.56 | 53.74 |  |  | 43.054 | 0
15 | ACC14493 | PLATE | 100.72 | 94 |  |  | 75.35000000000001 | 0
16 | ACC14510 | PLATE | 27.07 | 25.26 |  |  | 20.251 | 0
17 | ACC14512 | PLATE | 54.37 | 50.73 |  |  | 40.667 | 0
18 | ACC14562 | SET | 66.14 | 61.74 |  |  | 49.489 | 0
19 | ACC15100 | CAP | 79 | 73.74 |  |  | 58.443 | 0
20 | ACC15300 | KT WHL | 85.39 | 79.7 |  |  | 63.88800000000001 | 0
21 | ACC15600 | COVER | 117.17 | 109.38 |  |  | 87.681 | 0
22 | ACC15985 | COVER | 8.6 | 8.02 |  |  | 5.445 | 0
23 | ACC16112 | CAP | 18.49 | 17.27 |  |  | 13.838 | 0
24 | ACC16160 | CAP | 10.27 | 9.57 |  |  | 6.468 | 0
25 | [NAME] | CAP | 12.27 | 11.45 |  |  | 7.788000000000001 | 0
26 | ACC16180 | CAP | 5.5 | 5.13 |  |  | 4.653 | 0
27 | [NAME] | CAP | 12.97 | 12.1 |  |  | 9.702000000000002 | 0
28 | ACC16183 | CAP | 21.26 | 19.84 |  |  | 15.895 | 0
29 | ACC16243 | CAP | 29.86 | 27.88 |  |  | 22.352 | 0
30 | ACC16930 | CAP | 7.34 | 6.85 |  |  | 6.226000000000001 | 0
31 | ACC16932 | CAP | 13.22 | 12.35 |  |  | 9.9 | 0
32 | ACC16950 | CAP | 9.37 | 8.73 |  |  | 5.907000000000001 | 0
33 | ACC16952 | CAP | 14.04 | 13.1 |  |  | 10.494 | 0
 |  |  |  | 2 | 1
 |  |  |  | 2 | 3
 |  |  |  | 45 | 6
 |  |  |  | 70 | 8
Spreadsheet: 247996d1372953797-dynamic-correlation-table-correlations
Sheet: Sheet1

A | 1 | 2 | 3 | 4 | 5 | 6
B | 1 | 1 | 1 | 1 | 1 | 1
C | 1 | 2 | 4 | 8 | 16 | 32
D | 1 | 2 | 2 | 2 | 2 | 2
Correlation Table | A | B | C | D
A
B
C
D
Spreadsheet: 755880d1637161662-problem-with-ifand-function-example-list
Sheet: Drop Down List

SL |  |  | Y |  | 0
UK |  |  | N
[NAME]
-
On-site (Bridport)
Customer (UK)
Customer (International)
Spreadsheet: gerald_nemec__11329__Kern Pmt 2 Calcs
Sheet: Cannon

Cannon |  |  |  |  |  |  | Appendix A
 | July |  |  | August |  |  | Cannon Interests
Package 2 | 3700 |  |  | 3700 |  |  | July and August Payment Calculations
Total July
Actual Volume |  |  |  |  |  |  |  |  |  | JULY |  | AUGUST |  | TOTAL
 |  |  |  |  |  |  |  | ACTUAL VOLUME (1)
 |  |  | SoCal Basis
 |  |  | SoCal Index |  |  |  |  | MARKET PRICE (2)
Market Price |  |  | Total
 |  |  |  |  |  |  |  | SUPPLY PRICE (3)
 |  |  | Rockies Basis
 |  |  | Rockies Index |  |  |  |  | TARIFF RATE (4)
Supply Price |  |  | Total
 |  |  |  |  |  |  |  | PAYMENT RATIO
Spread |  |  | Spread
 |  |  |  |  |  |  |  | TOTAL PAYMENT
Total Spread Value
Tariff Rate |  |  | Tariff Rate |  |  |  |  | Payment as Calculated in Precedent Agreement:
Demand |  |  | Demand |  |  |  |  | Actual Volume * [(Market Price - Supply Price) - Tariff Rate] * Payment Ratio
Commodity |  |  | Commodity
Fuel Volume |  |  | Fuel | 0.097
Total Fuel Price |  |  | Total |  |  |  |  | (1) Actual volumes for July based on an 81.8% flow rate on 3,700 a day volume.
Total Tariff |  |  |  |  |  |  |  | August assumes 100% flows.
 |  |  |  |  |  |  |  | (2) August market price based on SoCal basis of $1.92 and index of ($1.42)
 |  |  | Net Income |  |  |  |  | (3) August supply price based on Rockies basis of ($[NAME]) and index of $.08
Net Income |  |  | Total Net Income |  |  |  |  | (4) Total estimated July tariffs of $104,114 versus total estimated August tariffs of $107,481.
 |  |  |  |  |  |  |  | Per unit total tariff is lower for July due to lower volume.
Payment Ratio | 0.25 |  | Payment
Total Payment |  |  | Total Payment
Spreadsheet: 140482d1328773573-pivot-table-calculation-test
Sheet: Foglio1

Customer | (Tutto)
Date | (Tutto)
 |  | Dati
Mesi | Rep | [NAME] | - helper2 | -helper3
gen | [NAME] | 62 | 62 | 3.647058823529414
 | [NAME] | 57 | 57 | 3.352941176470587
gen Totale |  | 119 | 59.60504201680672 | 3.50617894216511
feb | [NAME] | 34 | 34 | 2.42857142857143
 | [NAME] | 36 | 36 | 2.571428571428571
feb Totale |  | 70 | 35.02857142857143 | 2.502040816326534
Totale complessivo |  | 189 | 50.5026455026455 | 3.134275932595266
Spreadsheet: 219686d1362877984-counting-occurrences-count_occurances
Sheet: Jan05

Month | Day | paper | Cost | cumul | total Rs | weekly amt
Jan | Sat | xx | 0 | 0 | 0
2 | [NAME] | xx | 0 | 0 | 0
3 |  | xx | 0 | 0 | 0
4 |  | xx | 0 | 0 | 0
5 |  | xx | 0 | 0 | 0 | 0
6 |  | xx | 0 | 0 | 0
7 |  | xx | 0 | 0 | 0
8 |  | xx | 0 | 0 | 0
9 | [NAME] | xx | 0 | 0 | 0
10 |  | xx | 0 | 0 | 0
11 |  | xx | 0 | 0 | 0
12 |  | xx | 0 | 0 | 0 | 0
13 |  | xx | 0 | 0 | 0
14 |  | xx | 0 | 0 | 0
15 |  | xx | 0 | 0 | 0
16 | [NAME] | xx | 0 | 0 | 0
17 |  | xx | 0 | 0 | 0
18 |  | xx | 0 | 0 | 0
19 |  | xx | 0 | 0 | 0 | 0
20 |  | xx | 0 | 0 | 0
21 |  | xx | 0 | 0 | 0
22 |  | xx | 0 | 0 | 0
23 | [NAME] | xx | 0 | 0 | 0
24 |  | xx | 0 | 0 | 0
25 |  | xx | 0 | 0 | 0
26 |  | xx | 0 | 0 | 0 | 0
27 |  | xx | 0 | 0 | 0
28 |  | xx | 0 | 0 | 0
29 |  | xx | 0 | 0 | 0
30 | [NAME] | xx | 0 | 0 | 0
31 |  | xx | 0 | 0 | 0
Spreadsheet: 79828d1280064030-changing-from-sum-to-count-second-criteria_revised
Sheet: Planning Report

 |  |  |  |  |  |  |  | Company
 |  |  |  |  |  |  | Totals | Dunn | 2010-01-15 00:00:00
 |  |  |  |  |  | Active Overdue Customers to be Scheduled | 1630.5 | 0
 |  |  |  |  |  | Jobs with No Technician Assigned | 1200 | 0
 |  |  |  |  |  | Tentatively Scheduled Jobs Without Dates (waiting on technician) | 1456 | 0
 |  |  |  |  |  |  |  | Company
 |  |  |  |  |  |  | Count | Dunn | 2010-01-15 00:00:00
 |  |  |  |  |  | Active Overdue Customers to be ScheduledDunn | 3 | #N/A
 |  |  |  |  |  | Jobs with No Technician AssignedDunn | 0 | #N/A
 |  |  |  |  |  | Tentatively Scheduled Jobs Without Dates (waiting on technician)Dunn | 2 | #N/A
Spreadsheet: darron_c_giron__7977__midland_cogen
Sheet: May00

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
2000-05-01 00:00:00
IFGMR (TRKL/TX) |  |  | 2.99 |  |  | No. of Days: | 31
IFGMR (TRKL/LA) |  |  | 3.03
IFGMR (PEPL/TX/OK) |  |  | 2.94
IFGMR (ANR/LA) |  |  | 3.02
IFGMR (HENRY HUB) |  |  | 3.08
NX3 |  |  | 3.112
Sitara 10227
MIDLAND COGENERATION VENTURES
CONTRACT #16-60548-302 (Ultramar)
FIXED CONTRACT: | YEAR | PRICE | YEAR | PRICE
 | 1992 | 2.52 | 2001
 | 1993 | 2.4 | 2002
 | 1994 | 2.51 | 2003
 | 1995 | 2.61 | 2004
 | 1996 | 2.53 | 2005
 | 1997 | 2.65 | 2006
 | 1998 |  | 2007 | 6.37
 | 1999
 | 2000
TERM: Through year 2004 ([NAME])  with annual renewal thereafter.
MaxDQ: 8500 MMBtu/DAY
MinDQ: 60% OF MaxDQ F7,000 MMBtu/DAY | DQ for December, January, and February, 80% of MaxDQ for all other months.
Sitara 10226
MIDLAND COGENERATION VENTURES
CONTRACT #016-60548-305 (Union Pacific)
PEPL VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR(PEPL-TX/OK)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* |  | 2.5
DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
DESIGNATED QUANTITY -PEPL |  | 5000 | MMBTU/D
ANR VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR (ANR/LA)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* |  | 2.5
DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
[NAME] -ANR |  | 4000 | MMBTU/D
TRKL/ LA-TRKL/TX AVG  VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS AVG IFGMR (TRKL/LA)/IFGMR(TRKL/TX)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* (TX) |  | 2.5 |  | BASIS DIFFERENTIAL
TRIGGER* (LA) |  | 2.5 |  | IFGMR (HENRY HUB)
DIFFERENTIAL (TX) |  |  |  | LESS AVG IFGMR (TRKL/LA)
DIFFERENTIAL (LA) |  |  |  | BASIS DIFFERENTIAL
DESIGNATED TRKL TOTAL |  | 6000 | MMBTU/D | BASIS DIFFERENTIAL
 |  |  |  | IFGMR (HENRY HUB)
*Customer prefers rounding to nearest penny. |  |  |  | LESS AVG IFGMR(TRKL/TX)
 |  |  |  | BASIS DIFFERENTIAL
Spreadsheet: 850065d1700469052-help-with-merging-data-from-two-tabs-training-tracker
Sheet: AQWCH

 |  |  |  |  |  |  |  |  |  |  |  |  | KEY | TRAINING STATUS
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Not Trained
 | NAME | ENTITY | DEPARTMENT | SPECIALTY | SESSION 1 | SESSION 2 | SESSION 3 | PERCENT COMPLETE | ASSESSMENT SCORE | RESULT |  |  | 1 | In Progress
 | Abrar | AQGH | Training | NA | 2 | 2 | 2 |  |  |  |  |  | 2 | Training Complete
 |  |  |  |  | 0 | 0 | 0
Spreadsheet: 360c44ef-309c-4b51-bce4-a078fd6ac63a
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
 | 5671.0 Lending Finance, Australia
 | TABLE 18. COMMERCIAL FINANCE COMMITMENTS, Revolving Credit By Industry: Australia, Original ($000)
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
Agriculture, forestry and fishing ; |  |  | Original | A2414246T | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Mining ; |  |  | Original | A2414247V | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Manufacturing ; |  |  | Original | A2414248W | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Construction ; |  |  | Original | A2414249X | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Wholesale trade ; |  |  | Original | A2414250J | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Retail trade ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Transport and storage ; |  |  | Original | A2414252L | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Finance and insurance ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Property and business services ; |  |  | Original | A2414254T | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Cultural, recreational, personal and other services ; |  |  | Original | A2414255V | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Public administration ; |  |  | Original | A2414256W | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Health and community services ; |  |  | Original | A2414257X | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Other industries ; |  |  | Original | A2414258A | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
TOTAL REVOLVING CREDIT ; |  |  | Original | A2414259C | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 175236d1345469053-ligth-version-of-sumproduct-lightsumproductsolution
Sheet: Tabelle1

Input1:
 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4
[NAME] | 1 | 1 | 2 | 1 | 1 | 1 | 0 | 1 | 5 | 0 | 1 | 2 | 1 | 1 | 1 | 0 | 1 | 0
Ingrid | 0 | 1 | 1 | 0 | 0 | 2 | 5 | 2 | 0 | 1 | 1 | 1 | 0 | 0 | 2 | 5 | 2 | 5
[NAME] | 2 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 2 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 1
Ingrid | 2 | 1 | 1 | 1 | 2 | 5 | 1 | 6 | 0 | 1 | 1 | 1 | 1 | 2 | 5 | 1 | 6 | 1
[NAME] | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 12 | 2 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 12 | 0
Marcel | 3 | 1 | 1 | 2 | 3 | 5 | 4 | 1 | 1 | 0 | 1 | 1 | 2 | 3 | 5 | 4 | 1 | 4
[NAME] | 0 | 1 | 1 | 2 | 1 | 1 | 0 | 0 | 1 | 2 | 1 | 1 | 2 | 1 | 1 | 0 | 0 | 0
Input2:
Name | Job
[NAME] | [NAME]
Ingrid | [NAME]
Marcel | Driver
[NAME] | Driver
SUMPRODUCT() solution: How many instances in weeks 1, 2 or 3 done by carpenters or drivers (a week starts on the second day and ends on the sixth day of the same week number)
Job\Week | 1 | 2 | 3
[NAME] | 5 | 52 | 27
Driver | 2 | 17 | 20
Light solution?
Job\Week | 1 | 2 | 3
[NAME] | 0
Driver
Spreadsheet: 707729d1607433031-formulas-to-return-multi-different-net-prices-return-multiple-net-prices-for-same-part-code
Sheet: Sheet1

Order number | Part code | Net Price |  | Order Number | Part code | Net Price
12345 | AAAAA | 10 |  | 12345 | AAAAA
12345 | BBBBB | 20 |  |  | BBBBB
12345 | CCCCC | 10 |  |  | CCCCC
12345 | BBBBB | 30 |  |  | BBBBB
12345 | DDDDD | 5 |  |  | DDDDD
232323 | AAAAA | 5
232323 | DDDDD | 10 |  | Order Number | AAAAA
232323 | DDDDD | 20 |  | 232323 | DDDDD
232323 | CCCCC | 30 |  |  | DDDDD
232323 | BBBBB | 10 |  |  | CCCCC
821821 | AAAAA | 10 |  |  | BBBBB
821821 | BBBBB | 20
821821 | BBBBB | 30 |  | Order Number | AAAAA
821821 | CCCCC | 20 |  | 821821 | BBBBB
821821 | BBBBB | 50 |  |  | BBBBB
 |  |  |  |  | CCCCC
 |  |  |  |  | BBBBB
Spreadsheet: 697566d1601408421-need-help-with-sumif-and-subtotal-copy-of-grossmargin_quote-log_v2_2019
Sheet: Back Log

 | Enter Date Only | Results
 | 2020-01-01 00:00:00
 | 2020-08-31 00:00:00 | 6936905 |  | Avg. Billing per Month
 |  |  |  | Projected Year End Revenue
 | 2020-08-31 00:00:00 | 6988387.28
 | Months of Work Left:
 | 2019-06-30 00:00:00
 | Months of Work Left As Of  6/30/19
 | Shouldve freaked out at:
 |  |  | Months Ago
Spreadsheet: 230417d1366754009-splitting-out-information-across-rows-excel-prospect-help
Sheet: Sheet1

Boss 1 | Boss 2 | d# | J# | T# | Prospect First Name | Prospect Last Name | Company | Job Title | Business Street | Business City | Business State | Zip Code | X | XX | [NAME] | XXXX | XXXXX
 | [NAME], [NAME], [NAME], [NAME], [NAME] |  | 40 |  | Mark | [NAME] | Forrestry USA | President | 707 17th St., Suite 3600 | Denver | CO | 80202
[NAME], [NAME], [NAME], [NAME], [NAME] |  |  | 13 |  | [NAME] | Donahue | Rulers LTD | CFO | 1177 [NAME]. | Brighton | CO | 80601
[NAME], [NAME], [NAME], [NAME] | [NAME], Luann Board | 21 |  |  | [NAME] | King | KDI Mechanical | President | 3800 Xanthia Street | Denver | CO | 80238
[NAME], [NAME], [NAME], [NAME], [NAME] | [NAME], [NAME], [NAME] |  |  |  | [NAME] | Norris | PostIt Intnl | CFO | 6363 [NAME] Green Circle, Suite 1400 | Greenwood Village | CO | 80111
[NAME], [NAME], [NAME] | Job Goober, Lance From |  |  |  | [NAME] | Steuben | SunDay Cleaning | CFO | 9767 E. Easter Ave. | Centennial | CO | 80112
[NAME], [NAME], [NAME], [NAME], [NAME], [NAME] | [NAME] |  | 1 |  | Kimmy | [NAME] | KID Contracts | President | 1670 Broadway  Suite 3000 | Denver | CO | 80202