tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 02f8ab3d-95e2-4cfa-b1fa-3fa2243dfe0b
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
 | 6427.0 Producer Price Indexes, Australia
 | Table 22. Output of the Information media and telecommunications industries, group and class index numbers
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Index Numbers ;  541 Newspaper, periodical, book and directory publishing ; |  |  | Original | A3343938V | 2001-09-01 00:00:00 | 2012-12-01 00:00:00 | 46 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  5411 Newspaper publishing ; |  |  | Original | [NAME] | 2001-09-01 00:00:00 | 2012-12-01 00:00:00 | 46 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  5412 Magazine and other periodical publishing ; |  |  | Original | A2306528T | 1983-03-01 00:00:00 | 2012-12-01 00:00:00 | 120 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  5413 Book publishing ; |  |  | Original | A2306531F | 1989-09-01 00:00:00 | 2012-12-01 00:00:00 | 94 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  592 Data processing, web hosting and electronic information storage services ; |  |  | Original | A3343942K | 2001-09-01 00:00:00 | 2012-12-01 00:00:00 | 46 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  5921 Data processing and web hosting services ; |  |  | Original | A3343944R | 2001-09-01 00:00:00 | 2012-12-01 00:00:00 | 46 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  5922 Electronic information storage services ; |  |  | Original | A2314211V | 1997-12-01 00:00:00 | 2012-12-01 00:00:00 | 61 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2013
Spreadsheet: 220006d1363032629-have-list-of-dates-need-how-many-of-those-dates-fall-between-two-other-dates-monthly-rpt-stats-help-2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date Referred | Install Date | Removal Date | Total # of Days Sentenced | Offender | Agency | Number of Days Served at time of report | Offence that put Offender on Program | Violations Yes/No | Violated from Program Yes/No | Was it a Misd. or Felony | What is Violation | Date of Report
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-07 00:00:00 | 2013-01-27 00:00:00 | 2013-05-12 00:00:00 | 105 | Doe, [NAME] | [NAME] | 42 | DUI |  | No |  |  | 2013-03-10 00:00:00
 |  |  | REPORT PREPARED FOR: |  |  |  |  |  |  |  |  |  | . |  | 2013-01-15 00:00:00 | 2013-02-15 00:00:00 | 2013-03-11 00:00:00 | 24 | Doe, [NAME] | [NAME] | 23 | DUI |  |  |  |  | 2013-03-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-01 00:00:00 | 2013-03-16 00:00:00 | Pre-Trial | PT | Doe, [NAME] | [NAME] | 0 | DUI |  |  |  |  | 2013-03-10 00:00:00
 |  |  | DATE OF REPORT: |  |  |  |  |  |  |  |  |  |  |  | 2013-02-21 00:00:00 | 2013-03-17 00:00:00 | 2013-04-01 00:00:00 | 15 | Doe, [NAME] | [NAME] | 0 | DUI |  |  |  |  | 2013-03-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-01 00:00:00 | 2013-03-28 00:00:00 | 2013-04-13 00:00:00 | 16 | Doe, [NAME] | [NAME] | 0 | DUI |  |  |  |  | 2013-03-10 00:00:00
 | Reporting Period |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-06 00:00:00 | 2013-04-10 00:00:00 | 2013-04-17 00:00:00 | 7 | Doe, [NAME] | [NAME] | 0 | DUI |  |  |  |  | 2013-03-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-10 00:00:00
 | From | To |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-10 00:00:00
 | 2013-03-01 00:00:00 | 2013-03-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-10 00:00:00
 | 2 | Total # of Participants Refered during reporting period |  |  |  |  |  | Done |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-10 00:00:00
 |  | Total # of Participants in Program during reporting period
 | #N/A | Total # of Participants Completing Program during reporting period |  |  |  |  |  |  | Done partially
 |  | Total # of Participants that were violated from Program during reporting period
 |  | Total # of Participants that have used alcohol and/or drugs while on program
 |  | and/or refused an alcohol or drug test during the reporting period
 |  | Number of DUI offenders that have used alcohol and/or drugs while on the
 |  | program and/or refused an alcohol or drug test during the reporting period
 |  | Number of program participants that committed a new misd. [NAME] while
 |  | on program during the reporting period (See Offender info for individual accounts)
Spreadsheet: 739397d1625672582-percentage-of-items-meeting-sla-target-sample-data
Sheet: Sheet1

Tag | Priority | Created Date | Closed Date
Operation | 3 | 2020-06-17 10:25:19 | 2021-06-18 16:50:54
Operation | 2 | 2021-03-30 10:06:33 | 2021-06-18 10:07:48
Operation | 2 | 2021-04-23 16:44:46 | 2021-06-29 10:57:16
Operation | 2 | 2021-04-30 10:07:20 | 2021-06-18 10:05:49
Operation | 3 | 2021-05-21 09:57:26 | 2021-06-18 10:04:51
Operation | 2 | 2021-06-09 11:03:24 | 2021-06-17 18:06:57
Operation | 2 | 2021-06-15 09:39:11 | 2021-06-18 10:03:08
Operation | 2 | 2021-06-15 09:39:34 | 2021-06-18 10:03:03
Operation | 2 | 2021-06-15 09:40:22 | 2021-06-18 10:02:59
Operation | 2 | 2021-06-17 09:55:31 | 2021-06-17 17:27:12
Operation | 2 | 2021-06-17 09:56:34 | 2021-06-18 14:47:17
Operation | 2 | 2021-06-17 17:26:10 | 2021-06-17 17:26:46
Operation | 2 | 2021-06-22 10:15:55 | 2021-06-24 15:23:56
Operation | 2 | 2021-06-22 10:16:17 | 2021-06-22 16:48:29
Operation | 3 | 2021-06-22 12:12:39 | 2021-06-22 12:12:50
Operation | 2 | 2021-06-22 14:01:16 | 2021-06-22 14:01:23
Operation | 2 | 2021-06-23 10:17:31 | 2021-06-23 14:41:09
Operation | 2 | 2021-06-23 10:17:56 | 2021-06-23 12:29:24
Operation | 3 | 2021-06-23 18:41:27 | 2021-06-24 10:45:59
Operation | 2 | 2021-06-24 10:48:34 | 2021-06-24 10:49:33
Operation | 2 | 2021-06-24 15:22:56 | 2021-06-25 11:51:11
Operation | 2 | 2021-06-25 10:19:24 | 2021-06-29 10:47:14
Operation | 2 | 2021-06-29 10:06:32 | 2021-06-30 11:07:13
Operation | 2 | 2021-06-29 10:06:52 | 2021-06-29 10:47:00
Operation | 2 | 2021-06-29 10:07:14 | 2021-06-30 10:18:26
Operation | 2 | 2021-06-29 10:07:39 | 2021-06-29 10:45:54
Operation | 2 | 2021-06-29 14:17:24 | 2021-06-30 12:45:59
Operation | 2 | 2021-06-29 14:17:52 | 2021-06-30 12:46:24
Spreadsheet: phillip_m_love__30161__9901_OA
Sheet: EAST-CON-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM) / LRC
REGION: EAST
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 535853d1504102197-need-a-formula-for-allocations-based-on-preferences-and-priorties-mansijain
Sheet: Sheet2

 | Input |  |  |  |  |  | Output |  | Note: There are only 5 positions at location A, 4 at location B and 3 at location C
 | Candidate Name | Candidate Rank | First Location Preference | Second Location Preference | Third Location Preference |  | Candidate | Rank | Locations | Comments
 | Cand1 | 1 | A | B | C |  |  | 1 |  | Candidate with Rank 1 will be given Location A as its first priority
 | Cand2 | 2 | B | A | C |  |  | 2 |  | Candidate with Rank 2 will be given Location B as its first priority
 | Cand3 | 3 | C | A | B |  |  | 3 |  | Candidate with Rank 3 will be given Location C as its first priority
 | Cand4 | 4 | C | A | B |  |  | 4 |  | Candidate with Rank 4 will be given Location C as its first priority
 | [NAME] | 5 | B | A | C |  |  | 5 |  | Candidate with Rank 5 will be given Location B as its first priority
 | Cand6 | 6 | A | B | C |  |  | 6 |  | Candidate with Rank 6 will be given Location A as its first priority
 | Cand7 | 7 | B | A | C |  |  | 7 |  | Candidate with Rank 7 will be given Location B as its first priority
 | Cand8 | 8 | A | B | C |  |  | 8 |  | Candidate with Rank 8 will be given Location A as its first priority
 | Cand9 | 9 | B | A | C |  |  | 9 |  | Since both Candidates with Rank 9 and 10 have their first preferred work location is B and since only 1 space left at location B, candidate with lower rank i.e., Rank 9 will be priortized and given this last vacant position at location B and Candidate with Rank 10 will be given its second preferred work location i.e., location A
 | Cand10 | 10 | B | A | C |  |  | 10 |  | Candidate with Rank 10 will be given Location A as its second priority since its first preferred location i.e., Location B given to candidate with Rank 9
 | Cand11 | 11 | C | A | B |  |  | 11 |  | Since both Candidates with Rank 11 and 12 have their first preferred work location is C and since only 1 space left at location C, candidate with lower rank i.e., Rank 11 will be priortized and given this last vacant position at location C and Candidate with Rank 12 will be given its second preferred work location i.e., location A
 | Cand12 | 12 | C | A | B |  |  | 12 |  | Candidate with Rank 12 will be given Location A as its second priority since its first preferred location i.e., Location C given to candidate with Rank 11
 | Location | [NAME]
 | A | 5
 | B | 4
 | C | 3
Spreadsheet: 70aff6fa-1bd8-4a33-9b58-a2569647600e
Sheet: BA 5

Būvdarbu apjomu saraksts Nr.5
Specializētie darbi - ārējie tīkli, sistēmas
Ārējie kanalizācijas tīkli. Attīrīšanas ietaises.
(darba veids vai konstruktīvā elementa nosaukums)
Būves nosaukums :
Objekta nosaukums : Automašīnu stāvlaukums ar kases māju jaunbūve
Objekta adrese :  ''Slodas'', [NAME] pagasts, Madonas novads
[NAME].
Nr.p.k. | Kods | Darba nosaukums | Mērvienība | Daudzums | Vienības izmaksas (Ls) | Summa (Ls)
5-1 |  | Ārējā kanalizācija K-1
5-1-1 |  | Caurules dn200 pvc t8 montāža | m | 128
5-1-2 |  | Caurules dn315/200 rupniski izoletas pvc t8 montāža | m | 6
5-1-3 |  | Gala uzmava dn315/200 | gb | 2
5-1-4 |  | Skataka dn200/400/r40 BSB h=1,5m | gb | 6
5-1-5 |  | Čuguna lūkas apbetonešana dn700  0,2m3  z.z | gb | 2
5-1-6 |  | Čuguna [NAME] dn400  0,15m3  z.z | gb | 2
5-1-7 |  | Dz/bet. grodu aka [NAME] aka | gb | 1
5-1-8 |  | Caurules dn63 PE montāža | m | 7
5-1-9 |  | Em līkums dn63-90* | gb | 3
5-1-10 |  | Atloku adapters dn63/50 | gb | 2
5-1-11 |  | Atloku aizbīdnis dn100 | gb | 1
5-1-12 |  | Vītņu stienis ar saskrūvi | [NAME] | 1
5-1-13 |  | [NAME] | gb | 1
5-1-14 |  | Dz/bet. grodu aka dn2000  h=3,03m | gb | 1
5-1-15 |  | Fekālais dozēšanas sūknis ar automātiku | gb | 1
5-1-16 |  | Bioloģiskā attīrīšanas iekārta Q=2,2m3/dnn ar kompresoru | [NAME] | 1
5-1-17 |  | [NAME] | gb | 10
5-1-18 |  | PP uzmavas [NAME] | gb | 4
5-1-19 |  | [NAME] | gb | 4
5-1-20 |  | Pāreja dn200/160 | gb | 1
5-1-21 |  | Pāreja dn160/110 | gb | 1
5-1-22 |  | CCTV | m | 128
5-1-23 |  | [NAME] trases [NAME] | m | 128
5-1-24 |  | [NAME] | gb | 3
5-1-25 |  | K1 izlaide grāvi | gb | 1
5-1-26 |  | Rakšanas darbi | m3 | 195
5-1-27 |  | [NAME] blietējot | m3 | 150
5-1-28 |  | Pabērums blietējot | m3 | 150
5-1-29 |  | Liekās zemes aizvešana | m3 | 150
5-1-30 |  | [NAME] ar pazemes komunikācijām | gb | 3
 |  | Kopā ārējie [NAME] tīkli :
 |  | Sastādija _____________________________________________________
 |  | (paraksts un tā atšifrējums,datums)
 |  | Pārbaudīja _______________________________________________________
 |  | (paraksts un tā atšifrējums,datums)
 |  | [NAME]._______________________
 |  | Piezīmes:
 | 1. | Būvdarbu tiešajās izmaksās ietver : būvmateriālu, būvkonstrukciju, palīgmateriālu, darba, mehānismu un transporta izmaksas.
 | 2. | Smilts, šķembu, melnzemes un liekās grunts un būvgružu apjomi doti blīvā veidā, neņemot vērā irdinājuma koeficientu.
 | 3. | [NAME] daudzums uzrādīts nepielāgojot patēriņa koeficientu.
Spreadsheet: john_griffith__15705__Hedge Ratio
Sheet: Sheet2

Curves
As of:
 |  |  |  | Total | SERC | Implied |  |  | SERC
Month | Libor-AA | NG-P | IF-FGT/Z3-D | Gas | Price | Heat Rate | Correlation | VO-P | Volatility
2002-04-01 00:00:00 |  |  |  |  | 60 |  | 0.75
Spreadsheet: 87721d1287586893-converting-currencies-using-exchange-rate-solution-cntr-freight-rates-3-_dl
Sheet: test

 | exchange rates |  |  |  |  |  |  |  |  |  |  | tonnage
 | IEURUSD |  | 1.3958 |  |  |  |  |  | Apple |  |  | 22.5
 | IGBPUSD |  | 1.3958 |  |  |  |  |  | Orange |  |  | 23
 |  |  |  |  |  |  |  |  | Mango |  |  | 25
Origin | Destination | CR | base rate/tc | Converted Amount | CR | BAF | Converted Amount | CR | THC +ISPS | Converted Amount | CR | ERS/EBS/SUEZ/ERC | Converted Amount | rate /mt
Apple | A | EUR | 860 | 1200.388 | GBP | 465 | 649.0469999999999 | GBP | 100 | 139.58 | EUR | 100 | 139.58 | #N/A
Mango | B |  | 860 |  |  | INCL |  |  | INCL |  |  | 100 |  | 0
Orange | C |  | 860 |  |  | INCL |  |  | INCL |  |  | 100 |  | 0
Apple | D |  | 2060 |  |  | INCL |  |  | 830 |  |  | 0 |  | 0
Mango | E |  | 1700 |  |  | INCL |  |  | 0 |  |  | 175 |  | 0
Spreadsheet: 56876d1257017583-more-than-multiple-lookups-conditional-multiple-lookups-multilook
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | test1
Data Table |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | test2
Tests | Criteria1 | Criteria2 | Lookup | [NAME] |  |  |  | Criteria1 | Criteria2 | Test1 | Test2 |  |  |  |  | test3
Test1 | A | C | 10 | 10 |  |  |  | A | C | 10 | 30 |  |  |  |  | test4
Test2 | B | D | 40 | 40 |  |  |  | B | D | 20 | 40 |  |  |  |  | test5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | test6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | test8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | test9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | test10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | test11
Tests | Criteria1 | Criteria2 | Criteria3 | Criteria4 |  |  |  | Criteria1 | Criteria2 | Criteria3 | Criteria4 | Test1 | Test2 | test3 | test4 | test12
Test1 | A | C | c | d | 10 |  |  | A | C | c | d | 10 | 30 | 100 | 200 | test13
Test2 | B | D | a | f | 40 |  |  | B | D | a | f | 20 | 40 | 80 | 500 | test14
Test3 | A | C | c | d | 100 |  |  |  |  |  |  |  |  |  |  | test15
Test4 | A | C | c | d | 200
Test4 | B | D | a | f | 500
Spreadsheet: 06b7426d-b82d-44fe-9135-8b2e7fb21ace
Sheet: Daily Example

 |  | Return to Index Page
 | Period | Minutes
 | 1 | 52
 | 2 | 53
 | 3 | 52
 | 4 | 54
 | 5 | 53
 | 6 | 52
 | 7 | 52
 | 8 | 52
 | OJT | 60
 | Seminar | 3
 | Course |  | Number | Period | Class
Approved Class Name | Code | Teacher | Period | Enrolled | Minutes | Total | Notes
Accounting I | 12345 |  | 4 | 26
Accounting II | 12346 |  | 5 | 12
Computer Applications I | 21431 |  | 1 | 15
Computer Applications I | 21431 |  | 2 | 14
Computer Applications I | 21431 |  | 3 | 16
Computer Applications I | 21431 |  | 6 | 16
Computer Applications II | 21432 |  | 7 | 15
Computer Applications II | 21432 |  | 8 | 15
Advanced Drafting | 31584 |  | 4 | 12
Cabinet Making III | 42151 |  | 3 | 4
Cabinet Making IV | 42152 |  | 4 | 3
Business OJT | 50014 |  | OJT | 3
Seminar Period |  |  | Seminar | 148
 |  |  |  |  | TOTAL MINUTES
 |  |  |  |  | TOTAL HOURS
 | Return to Top
Spreadsheet: 865108d1712169246-trouble-creating-a-formula-to-caluclate-a-higher-amount-after-a-threshold-incremental-sales-commissions
Sheet: Sheet1

Sale | ceiling | comm
 |  |  |  | Increment comm after N sales |  |  |  | 10
 |  |  |  | dollar value of comm increment |  |  |  | 5
Spreadsheet: 767853d1644677489-need-to-copy-data-from-one-excel-table-to-another-that-has-a-different-format-power-query-append-evolutionx93-
Sheet: Old

Deparment Name / Unit | Building | Location Of Workstation | Room Number, if appropriate | Map Reference | Computer Name | Workstation Type | Login Strategy | [NAME] | [NAME] | Primary Use | BCA PC | Document Scanner | [NAME] | Welcome - Kiosk / Tablet | Biometrics/Tap Badge | [NAME] | Credit Card Reader | e-Signature Pad | [NAME] | [NAME] | Has Power | Has Data | Other/Comments | Date Modified | New Epic Name | Column1
Patient Access | 1-AMBI | REGISTRATION STATION 1 | COVID CLINIC | PC1 | NBRCOVID11 | Desktop | Private | 27" |  | Clinical OP |  | FUJITSU FI-7160 |  |  |  | DEPLOYED | DEPLOYED | DEPLOYED |  |  |  |  |  | 2021-04-12 10:00:09 | NBRCOVID11
Patient Access | 1-AMBI | REGISTRATION STATION 2 |  | PC2 | [NAME] | Desktop | Private | 27" |  | Clinical OP |  | FUJITSU FI-7160 |  |  |  |  |  |  |  |  |  |  |  | 2021-04-12 10:01:22 | [NAME]
Patient Access | 1-AMBI | REGISTRATION STATION 3 |  | PC3 | NBRCOVID13 | Desktop | Private | 27" |  | Clinical OP |  | CANON DR-C225 |  |  |  | DEPLOYED | DEPLOYED | DEPLOYED |  |  |  |  |  | 2021-04-12 10:07:56 | NBRCOVID13
Patient Access | 1-AMBI | REGISTRATION STATION 4 |  | PC4 | [NAME] | Desktop | Private | 27" |  | Clinical OP |  | CANON DR-C225 |  |  |  |  |  |  |  |  |  |  |  | 2021-04-12 10:10:05 | [NAME]
Patient Access | 1-AMBI | REGISTRATION STATION 5 |  | PC5 | NBRCOVID16 | Desktop | Private | < 23" |  | Clinical OP |  | CANON DR-C225 |  |  |  |  |  |  |  |  |  |  |  | 2021-04-12 10:10:57
Patient Access | 1-AMBI | REGISTRATION STATION 6 |  | PC6 | NBRCOVID17 | Desktop | Private | < 23" |  | Clinical OP |  | CANON DR-C225 |  |  |  | DEPLOYED | DEPLOYED | DEPLOYED |  |  |  |  |  | 2021-04-12 10:12:53 | NBRCOVID17
Patient Access | 1-AMBI |  |  |  | NBRCOVID19 | Desktop | Private |  |  | Clinical OP |  | CANON DR-C225
Spreadsheet: 884782d1734041871-best-way-to-conditional-sum-across-sheets-conditional-sums-across-sheets
Sheet: Summary

Criteria 1 | [NAME] | Criteria 3 | Sales
Global | Client A | EU | Create a efficient condtional sum across sheets based on Criteria 1, 2 and 3
Global | Client A | NA | I am thinking if I can avoid something like "Sumif(Sheet A…) + Sumif(Sheet B…)"
Global | Client A | ROW
Global | Client B | EU
Global | Client B | NA
Global | Client B | ROW
Spreadsheet: 759751d1639701817-counting-number-of-occurances-between-two-dates-on-a-rolling-basis-captiancactus
Sheet: Blad1

project | start | end | agent
1 | 2021-01-01 00:00:00 | 2021-12-31 00:00:00 | [NAME] |  |  | 2021-01-15 00:00:00
2 | 2021-02-01 00:00:00 | 2021-12-31 00:00:00 | [NAME] |  | [NAME]
3 | 2021-03-01 00:00:00 | 2021-12-31 00:00:00 | Caroline |  | [NAME]
4 | 2021-04-01 00:00:00 | 2021-12-31 00:00:00 | [NAME] |  | Caroline
Spreadsheet: 138531d1327698202-looking-for-counts-from-an-array-countifpos
Sheet: Sheet2

REGION | ACD_VAL | SIGN | DROP | MIT | INFRINGE
NORTH | 1 | 1 |  | 1
NORTH | 4 | 4
NORTH |  | 4
NORTH |  |  | 4
NORTH |  |  |  |  | 1
SOUTH | 1
NORTH |  |  | 1
SOUTH | 4
SOUTH |  |  |  | 1
SOUTH | 1
SOUTH | 1
EN | 1 |  |  |  | 4
EN |  |  |  |  | 4
EN |  |  |  |  | 1
EN |  |  |  | 4
EN |  |  |  | 1
NORTH |  |  |  |  | 1
SOUTH |  |  | 4
SOUTH | 4 | 1 |  |  | 4
SOUTH | 4 | 1
EN |  | 1
NORTH |  | 1
NORTH |  | 1
NORTH |  | 1 |  | 1
North 4 =
North 1 =
Spreadsheet: 454259d1459757242-problem-with-formula-when-opening-stock-is-greater-than-first-order-for-product-book1example-5-
Sheet: Sales

 |  |  |  |  |  |  |  |  | Running Total
 |  |  |  |  |  |  |  |  | After Sales | Stock Bought
 | Sale orders |  |  |  |  | Opening Cost |  |  | Stock on Hand | Running Total
Order Number | [NAME] | Total Sold | Cost of Order |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | as it came from the forum
1 | 140 |  | =40 x £1.12 plus 160 x £1 |  |  |  |  |  |  |  |  | Cost | Total Qty | Running Total |  | 204.8 | different first formula in column |  |  | =IF(K6>K5,G5,0)*IF(E6=0,0,J5)+(INDEX($M$7:$M$11,MATCH(K6,$O$7:$O$11,0))*IFERROR(B6-F6,B6))
2 | 320 |  | =320 x £1 |  |  |  |  |  |  |  |  | 1.12 | 200 |  |  | 320
3 | 30 |  | =30 x £1 |  |  |  |  |  |  |  |  | 1 | 1000 |  |  | 30
4 | 400 |  | =400 x £1 |  |  |  |  |  |  |  |  | 2 | 1000 |  |  | 400
5 | 250 |  | =90 x £1 plus 160 x £2 |  |  |  |  |  |  |  |  | 2.2 | 1000 |  |  | 410
6 | 100 |  | =100 x £2 |  |  |  |  |  |  |  |  | 1 | 2000 |  |  | 200
7 | 400 |  | =400 x £2 |  |  |  |  |  |  |  |  |  |  |  |  | 800
8 | 240 |  | =240 x £2 |  |  |  |  |  |  |  |  |  |  |  |  | 480
9 | 240 |  | =100 x £2 plus 140 x £2.20 |  |  |  |  |  |  |  |  |  |  |  |  | 508
10 | 300 |  | =300 x £2.20 |  |  |  |  |  |  |  |  |  |  |  |  | 660
11 | 400 |  | =400 x £2.20 |  |  |  |  |  |  |  |  |  |  |  |  | 880.0000000000001
12 | 50 |  | =50 x £2.20 |  |  |  |  |  |  |  |  |  |  |  |  | 110
13 | 150 |  | =110 x £2.20 plus 40 x £1 |  |  |  |  |  |  |  |  |  |  |  |  | 282
 |  |  | replaces E7 >>>>>>>>>>
Spreadsheet: andy_zipper__250__Global_Prod 6-6-01 EM
Sheet: Not Available on 6-6-01

Global Products that were not made available on
but were available on
Global Product Short Desc.
[NAME] FOB              Oct01           USD/mt
FIN Wthr Swap    AVT HEL 20000/40K       Jan-Apr02       EUR/DC
FIN Wthr Swap    AVT HEL 20000/40K       Oct-Dec01       EUR/DC
For Curr Exch    Forward                 07Jun01         JPY/USD
For Curr Exch    Forward                 07Jun01         USD/EUR
For Curr Exch    Forward                 07Jun01         USD/GBP
For Curr LME     LME (Spot)              07Jun01         JPY/USD
For Curr LME     LME (Spot)              07Jun01         USD/EUR
For Curr LME     LME (Spot)              07Jun01         USD/GBP
Foreign Currency Reuters BOFC            05Jun01         CAD/USD
[NAME]                15Aug01v3Mth    USD/mt-L
[NAME]                18Jul01v15Aug01 USD/mt-L
[NAME]                18Jul01v3Mth    USD/mt-L
[NAME]                20Jun01v18Jul01 USD/mt-L
[NAME]                20Jun01v3Mth    USD/mt-L
[NAME]
[NAME]       USD/mt-L
SG GO-Dub Crk    Platts                  01-30Jul01      USD/bbl
SWE Wthr Swap    AVT STHM 20000/40K      Jan-Apr02       EUR/DC
SWE Wthr Swap    AVT STHM 20000/40K      Oct-Dec01       EUR/DC
UK E-W FO Diff   Platts                  Jul01           USD/mt/m
US Crude Fin Opt NYMEX WTI    EC30.5     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EC31.0     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EC31.5     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EP28.5     Jul01           USD/bl/m
US RGC3 Swap     CMAI                    Jul-Dec01       c/LB
US Styrene FOB   Hou/TX Cty              Jul01           c/[NAME]
US [NAME]CMAI Spot               Aug01           c/[NAME]
Spreadsheet: 143226d1330310796-days-in-each-month-in-date-range-forum_example_dates
Sheet: Sheet1

Upload Reference | UGL Supplier No | Supplier Invoice No | Invoice Date | Start Date | End Date
20110414 | 1005866 | 90495011 | 2011-03-31 00:00:00 | 2010-12-02 00:00:00 | 2011-03-03 00:00:00 |  | 30 | 31 | 28 | 3
20110718 | 1005866 | 90495011 | 2011-06-30 00:00:00 | 2011-03-04 00:00:00 | 2011-06-02 00:00:00
20111024 | 1005866 | 90495011 | 2011-09-04 00:00:00 | 2011-06-03 00:00:00 | 2011-09-01 00:00:00
20120109 | 1005866 | 90495011 | 2011-12-02 00:00:00 | 2011-09-02 00:00:00 | 2011-11-29 00:00:00