tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 889812d1740740678-running-balance-using-power-query-pq-customers-ledger
Sheet: Customers Ledger USD

 | I kindly ask for Power Query Solution to transform the "Transactions Tables" to the desired solution. Please note that the running balance depends on I.D Number.
 | If possible, provide comments on M formula.
 | Desired Solution
 | Name | I.D Number | Date | Bank | Invoice | Reference | Debit | Credit | Balance
 | [NAME] | CT 372 | 2025-01-01 00:00:00 |  |  | Balance B/D |  | 100
 | [NAME] | CT 372 | 2025-01-05 00:00:00 |  | First Term 003 |  | 11361.944
 | [NAME] | CT 372 | 2025-01-06 00:00:00 | Cash - US$ |  | 17432 |  | 2841.828
 | [NAME] | CT 372 | 2025-01-08 00:00:00 | Cash - US$ |  | 17437 |  | 8541.456
 | AMBER MEARES | CT 420 | 2025-01-01 00:00:00 |  |  | Balance B/D | 6167.525832670934
 | AMBER MEARES | CT 420 | 2025-01-05 00:00:00 |  | First Term 004 |  | 11361.944
 | AMBER MEARES | CT 420 | 2025-01-07 00:00:00 | Cash - US$ |  | 17433 |  | 8534.592
 | AMBER MEARES | CT 420 | 2025-01-08 00:00:00 | Cash - US$ |  | 17438 |  | 8541.456
 | BADAR DON | CT 408 | 2025-01-01 00:00:00 |  |  | Balance B/D | 14067.2364226691
 | BADAR DON | CT 408 | 2025-01-05 00:00:00 |  | First Term 001 |  | 11361.944
 | BADAR DON | CT 408 | 2025-01-06 00:00:00 | Cash - US$ |  | 17431 |  | 8525.484
 | BADAR DON | CT 408 | 2025-01-08 00:00:00 | Cash - US$ |  | 17436 |  | 5694.304
Spreadsheet: 30014d1225298151-help-with-formula-looking-at-date-ranges-excel-forum-example-2
Sheet: ALL

StartDate | [NAME] | Renewed between 01/04/06 to 31/03/07 | Renewed between 01/04/07 to 31/03/08
2005-05-01 00:00:00 | 2006-04-30 00:00:00 | NO | not in any range
2005-05-01 00:00:00 | 2007-04-30 00:00:00 | YES | NO
2005-05-01 00:00:00 | 2008-04-30 00:00:00 | YES | YES
2006-05-01 00:00:00 | 2007-04-30 00:00:00 | new sale | NO
2006-05-01 00:00:00 | 2008-04-30 00:00:00 | new sale | YES
2007-05-01 00:00:00 | 31/04/2009 | not in any range | new sale
Spreadsheet: stacey_white__39001__Power CPM 2002 Plan Capital
Sheet: Summary

E N R O N   N et Works
2 0 0 2   P L A N |  |  |  |  | Distributed Component Architecture
(In Dollars)
 | COST CENTER OWNER:
 | COST CENTER:
 | TOTAL HEADCOUNT - EMPLOYEES
 | TOTAL HEADCOUNT - CONTRACTORS
 | DIRECT EXPENSES |  | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 2002-06-01 00:00:00 | 2002-07-01 00:00:00 | 2002-08-01 00:00:00 | 2002-09-01 00:00:00 | 2002-10-01 00:00:00 | 2002-11-01 00:00:00 | 2002-12-01 00:00:00 | Total
 | Compensation
 | Benefits and Payroll Taxes
 | Employee Expenses
 | Communication Expense
 | Infrastructure Passthru
 | Outside Services - IT
 | Outside Services - Other
 | Office Supplies
 | Advertising Expense
 | Charitable Contributions
 | Rent (3rd Party)
 | Computer Expense
 | Transportation
 | EPSC Allocation
 | A & A / GTT Allocation
 | Other Expenses
 | Depreciation & Amortization
 | Taxes Other than Income
 | TOTAL DIRECT EXPENSES
 | TOTAL ALLOCATED EXPENSES (Financial Ops)
 | TOTAL EXPENSES
Spreadsheet: 7c5b6378-2ea5-4157-a658-a09e0195187d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-02-08 09:30:46.400000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.25 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.125 | 101.728 | 101.603 | 101.478 | 101.103
4 | 101.282 | 101.157 | 101.032 | 100.657 |  | Note: | Refer To Price [NAME]
3.875 | 100.459 | 100.334 | 100.209 | 99.834 |  |  | For all Price Adjs
3.75 | 99.482 | 99.357 | 99.232 | 98.607
3.625 | 99.028 | 98.903 | 98.778 | 98.153
3.5 | 98.523 | 98.398 | 98.273 | 97.648
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.625 | 101.901 | 101.776 | 101.651 | 101.276
3.5 | 101.561 | 101.436 | 101.311 | 100.936
3.375 | 101.03 | 100.905 | 100.78 | 100.405
3.25 | 100.4 | 100.275 | 100.15 | 99.775
3.125 | 99.634 | 99.509 | 99.384 | 98.759
3 | 99.291 | 99.166 | 99.041 | 98.416
2.875 | 98.731 | 98.606 | 98.481 | 97.856 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-02-22 09:30:46.400000
30 DAY | 2012-03-08 09:30:46.400000
45 DAY | 2012-03-23 09:30:46.400000
60 DAY | 2012-04-07 09:30:46.400000
90 DAY | 2012-05-07 09:30:46.400000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: andy_zipper__170__DYNEGY-ICE VOL Apr16
Sheet: Enron Activity - Dynegy Direct

DYNEGY DIRECT
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Note: Total Activity for Dynegy Direct is not available, therefore Enron's percentage can not be calculated
Enron North America - Dynegy Direct |  |  |  |  | Enron Power Marketing - Dynegy Direct |  |  |  |  | Enron Global Liquids - Dynegy Direct
 |  | Data |  |  |  |  | Data |  |  |  |  | Data
Major Commodity | Enron Trader | Transactions | Notional Volume |  | Major Commodity | Enron Trader | Transactions | Notional Volume |  | Major Commodity | Enron Trader | Transactions | Notional Volume
US Natural Gas | [NAME] | 3 | 15000 |  | Power | [NAME] | 1 | 24800 |  | (blank) | No Activity | 1 | 0
US Natural Gas Total |  | 3 | 15000 |  | Power Total |  | 1 | 24800 |  | (blank) Total |  | 1 | 0
Grand Total |  | 3 | 15000 |  | Grand Total |  | 1 | 24800 |  | Grand Total |  | 1 | 0
Spreadsheet: 92102d1291762853-missing-data-from-vlookup-formula-order-template-example
Sheet: Sheet2

Model | Wash | Cost |  |  | 30 | DYLAN | CARNIVAL
MARCEL | CARNIVAL | 26 |  |  | 32 | HOLLYWOOD | ARTEMIS
HOLLYWOOD | ARTEMIS | 26 |  |  | 34 | MARCEL | DAKOTA
HOLLYWOOD | DAKOTA | 26 |  |  | 36 | MIGUEL | VOLCANO
HOLLYWOOD | VOLCANO | 24 |  |  |  | PAUL | 2 YEARS
PAUL | 2 YEARS | 20 |  |  |  | RODEN | CLUE
PAUL | CLUE | 26 |  |  |  | TINMEN | POWDER AGED
PAUL | POWDER AGED | 22 |  |  |  |  | TARGET
PAUL | TARGET | 22 |  |  |  |  | FLASH BLUE
DYLAN | FLASH BLUE | 26 |  |  |  |  | ORIGAMI
DYLAN | ORIGAMI | 20 |  |  |  |  | VILLAGE
DYLAN | VILLAGE | 22 |  |  |  |  | HANDCRAFTED
RODEN | HANDCRAFTED | 22 |  |  |  |  | DIAZ
RODEN | DIAZ | 22 |  |  |  |  | BLUE STAR
RODEN | BLUE STAR | 22 |  |  |  |  | BARBADOS
MIGUEL | BARBADOS | 28 |  |  |  |  | 2 YEARS
TINMEN | 2 YEARS | 20 |  |  |  |  | DARK BLUE USED
TINMEN | DARK BLUE USED | 24 |  |  |  |  | POWDER AGED
TINMEN | POWDER AGED | 22
Spreadsheet: a532452b-e47d-41a8-bf46-2e45c563427d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | GST
 |  | Group | Accession Number |  | Organism | Percentage amino acid identity/ similarity
 |  | Mammal | P28801 | GSTP1 | [NAME] taurus | 27/43
 |  |  | Q9TTY8 | GSTP1 | Capra hircus | 27/42
 |  |  | P80031 | GSTP1 | Sus scrofa | 31/46
 |  |  | [NAME] | GSTA1 | [NAME] taurus | 29/45
 |  |  | P51781 | GSTA1 | Sus scrofa | 30/47
 |  |  | Q9N2J6 | MicGST | Ovis aries | 29/47
 |  |  | Q9XS30 | GST | Ovis aries | 28/46
 |  |  | Q9N0V4 | GSTM1 | [NAME] taurus | 27/42
 |  |  | Q000H8 | GSTM2 | Sus scrofa | 30/44
 |  |  | Q30B87 | GSTM3 | Ovis aries | 28/46
 |  |  | O35543 | PTGD2 | Rattus norvegicus | 28/47
 |  |  | Q9JHF7 | PTGD2 | Mus musculus | 29/48
 |  |  | O60760 | PTGD2 | Homo sapiens | 28/49
 |  | Trematode | P09792 | GST28 | Schistosoma mansoni | 45/62
 |  |  | P30113 | GST28 | Schistosoma bovis | 44/62
 |  |  | P30114 | GST28 | Schistosoma haematobium | 44/62
 |  |  | Q26513 | GST | Schistosoma japonicum | 42/63
 |  |  | A1BNE5 | GST | Clonorchis sinensis | 46/65
 |  |  | Q8ISK1 | GST | Opisthorchis viverrini | 47/66
 |  |  | Q26200 | GST | Paragonimus westermani | 38/58
Spreadsheet: f6705a4f-6d9f-46a3-b9ac-8714e2eb9844
Sheet: Sheet1

Human ChIP primers | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Gene/site | Forward | Reverse | Genomic loci from Hg18 (Primer pair design within this sequence)
HOXD11 | TGGTCTCTTTGCCTTGCAGTTG | TGGTATAGGGACAGCGCTTTTTC | chr2:176681482-176682453
TBX3 | GCAGTGCTGAACCCAGTGGAG | GGGTGCATGGTGAGTGGAGAC | chr12:113610579-113611181
[NAME] | ATGCATTGTGTAAGACGCGACC | CCAGAATGCTAGAACCCGGAAG | chr2:66515333-66516197
MEIS2 | AGTCAGCTCCTTCTGCCCAGG | CGCAAGATGAAATTTTACCGCC | chr15:35183876-35184615
PAX3 | ACACTGCACCCCAATAACACAG | TCCATTTGCCTCCATTACTTCC | chr2:222856545-222857150
DLX5 | [NAME] | CAGATACAGGGCGACTAGGACG | chr7:96490880-96491655
GATA3 | GACCGAGTTCTTTCTGTCCGTC | AGACTGGCTCTAACTCATTCCCC | chr10:8135175-8135975
Human mRNA primers
Gene/site | Forward | Reverse
HOXD11 | GTTCCTTTCCCAACCGTCGTC | CGGAGCCAGGTTGGAAGAGTAG
TBX3 | AGTCGGGAAGGCGAATGTTTC | TGGCTTTTTTATCCAGCCCAG
[NAME] | CAATTGGTTTATTAATGCCCGG | TCGGTTGGACTGGTCTATCATG
MEIS2
PAX3 | AAAAGAGAGAACCCGGGCATG | CCGCGTCCTTGAGTAATTTGTC
DLX5 | ACCAACCAGCCAGAGAAAGAAG | TTGGTTTGCCATTCACCATTC
GATA3 | GGACGAGAAAGAGTGCCTCAAG | CGACTCCAGCTTCATGCTGTC
GAD1 | CTGGACTTTCATCACCCACACC | AGAGCTCCAAGTTGAAGCCCTC
HES1 | TGAAGAAAGATAGCTCGCGGC | CACTGTCATTTCCAGAATGTCCG
REST | tggaaaatgcaactatttttcaga | gaacttgagtaaggacaaagttcaca
RNF2 | cggcagctgataccagagtc | tgcacagcctgagacattg
RCOR1 | CAAGACGCAGTCAAGAACGGG | TGACAGATTTTGATTGGGTGACC
CALB1 | gatgatggaaaaataggaattgtagag | tcttcatgaattcctcacaggac
BETA-ACTIN | cctttttgtcccccaacttga | tggctgcctccaccca
[NAME] primers
Gene/site | Forward | Reverse | Genomic loci from mm9 unless otherwise indicated (Primer pair design within this sequence)
Nudt9 | CGTTATTATCCAGACCGCGTG | AACCCCAAAGCCAAAACTTACAG | chr5:104474555-104476305
Calb1 | GCTCCGCGCACTCTCAAA | GAGATGACTGCAGGTGGGATTC | chr4:15808437-15808458, mm8
Stag3/Gpc2 | AAATAGGCAGCGTTCCAACCC | CGGACACGAGACAGAGCTAC | chr5:138720771-138722661
Gjb2 | [NAME] | ccttgaacccgaattctagatgc | chr14:57,722,774-57,724,333
Brunol6 | GGCATGAGCGGGCTGAAC | GGCACTCCTAATCCTTTCCTGG | chr9:59,426,047-59,426,788
Prrxl1 | GCATCCCAAATGACTTTCGAAG | GCCTCAGCTAGTGGCTTAGGG | chr14:33,409,601-33,411,530
Best2 | CTTCTCGGGTCATAAATCCTGG | GGTGCGAGTAACGTTGGATCAC | chr8:87,534,839-87,535,812
[NAME] primers
Gene/site | Forward | Reverse
Brunol6 | CTTACCCAGCAGCCTATCCCTC | GGCTGTTGGGAAAAAGCTGTG
Prrxl1 | GCCAGAGTGCAGGTTTGGTTC | TGTCTTCCTCCATTTGGCTCTTC
Best2 | TGGCTTCTACGTGACTCTGGTG | CAGAGGCATGCATAGGTACTGG
Beta-Actin | cgggacctgacagactacctc | ggtggtgaagctgtagccacg
Spreadsheet: 117627d1312916470-formatting-vertically-align-2nd-word-in-cell-spacing
Sheet: Sheet1

UTS-COVPG Cover Page | UTS-COVPG | [NAME] | UTS-COVPG           Cover Page | UTS-COVPG           Cover Page
UTS-SP-2 Forms & Endorsement Schedule | UTS-SP-2 | Forms & Endorsement Schedule | UTS-SP-2            Forms & Endorsement Schedule | UTS-SP-2            Forms & Endorsement Schedule
UTS-SP-3 Locations Schedule | UTS-SP-3 | Locations Schedule | UTS-SP-3            Locations Schedule | UTS-SP-3            Locations Schedule
NOTS0065TX TX- Important Notice | NOTS0065TX | TX- Important Notice | NOTS0065TX          TX- Important Notice | NOTS0065TX          TX- Important Notice
UTS-230G-TX Prompt Payment Of Claims | UTS-230G-TX | Prompt Payment Of Claims | UTS-230G-TX         Prompt Payment Of Claims | UTS-230G-TX         Prompt Payment Of Claims
NOTX0178CW Claim Reporting Information | NOTX0178CW | Claim Reporting Information | NOTX0178CW          Claim Reporting Information | NOTX0178CW          Claim Reporting Information
OPS-D-1 Common Policy Dec | OPS-D-1 | Common Policy Dec | OPS-D-1             Common Policy Dec | OPS-D-1             Common Policy Dec
 |  |  | courier | arial
Spreadsheet: 125292d1318955048-formula-for-increasing-cost-per-unit-world-war
Sheet: Extras

 |  | delta |  |  |  | [NAME]: | 250
-------------- | -------------- | 1 |  |  |  | [NAME] Units: | 1500
20400000 | [NAME] | 3 |  |  |  | Current Usable Units: | 1500
-------------- | -------------- | 6
-------------- | -------------- | 13
-------------- | -------------- | 30
-------------- | -------------- | 48
-------------- | -------------- | 120
-------------- | -------------- | 3
-------------- | -------------- | 3
-------------- | -------------- | 5
-------------- | -------------- | 7
762000000 | [NAME] | 11
-------------- | -------------- | 18
-------------- | -------------- | 22
-------------- | -------------- | 41
-------------- | -------------- | 86
 |  |  |  |  |  |  | [NAME] |  | landmine |  | automated |  | coastal
 |  |  | guard
 | [NAME] |  | [NAME] |  | Anti-Aircraft Launcher |  | [NAME] |  | Landmine Field |  | Automated Sentry Gun |  | Coastal Cannons
1 | 2406000 | 1595 | 2040000 | 671 | 2839000 | 492 | 4252500 | 315 | 5130000 | 162 | 5130000 | 103 | 1200000 | 1
2 | 2407500 | 1596 | 2043000 | 672 | 2844666.666666667 | 493 | 4265625 | 316 | 5160000 | 163 | 5424000 | 104 | 1320000 | 2
3 | 2409000 | 1597 | 2046000 | 673 | 2850333.333333333 | 494 | 4278750 | 317 | 5190000 | 164 | 5472000 | 105 | 1440000 | 3
4 | 2410500 | 1598 | 2049000 | 674 | 2856000 | 495 | 4291875 | 318 | 5220000 | 165 | 5520000 | 106 | 1560000 | 4
5 | 2412000 | 1599 | 2052000 | 675 | 2861666.666666667 | 496 | 4305000 | 319 | 5250000 | 166 | 5568000 | 107 | 1680000 | 5
6 | 2413500 | 1600 | 2055000 | 676 | 2867333.333333333 | 497 | 4318125 | 320 | 5280000 | 167 | 5616000 | 108 | 1800000 | 6
7 | 2415000 | 1601 | 2058000 | 677 | 2873000 | 498 | 4331250 | 321 | 5310000 | 168 | 5664000 | 109 | 1920000 | 7
8 | 2416500 | 1602 | 2061000 | 678 | 2878666.666666667 | 499 | 4344375 | 322 | 5340000 | 169 | 5712000 | 110 | 2040000 | 8
9 | 2418000 | 1603 | 2064000 | 679 | 2884333.333333333 | 500 | 4357500 | 323 | 5370000 | 170 | 5760000 | 111 | 2160000 | 9
10 | 2419500 | 1604 | 2067000 | 680 | 2890000 | 501 | 4370625 | 324 | 5400000 | 171 | 5808000 | 112 | 2280000 | 10
Spreadsheet: 457007d1461163457-lookup-from-multiple-possible-ranges-multiple-range-lookup-sample
Sheet: Sheet1

Year | 2016
CM0000 |  |  |  |  |  | CM0100
 | Total | Percent | Dollar |  |  |  | Total | Percent | Dollar
State | Dolalrs | Change | Change |  |  | State | Dolalrs | Change | Change
AZ | 10044 | 0.1323340043637503 | 352 |  |  | AL | 4939 | 0.3706561342730234 | 173
IL | 5335 | 0.3533787182173116 | 187 |  |  | AZ | 3601 | 0.3988601980183788 | 126
IN | 3694 | 0.2999647995439281 | 129 |  |  | IL | 50103 | 0.2720089528857079 | 1754
IA | 2970 | 0.320325458902794 | 104 |  |  | IN | 48985 | 0.2399224598351447 | 1714
MI | 16559 | 0.3669013717126197 | 580 |  |  | IA | 15265 | 0.195584727468009 | 534
NE | 6345 | 0.2205559659030976 | 222 |  |  | MI | 19585 | 0.1741115382487697 | 685
NC | -336 | 0.03457684076134013 | -12 |  |  | NE | 7834 | 0.03928585981432558 | 274
OH | 6447 | 0.3762637149568047 | 226 |  |  | OH | 26866 | 0.1415704341596802 | 940
TN | 7733 | 0.3134043918101743 | 271 |  |  | TN | 5157 | 0.3707815246866358 | 180
CM0200 |  |  |  |  |  | CM0300
 | Total | Percent | Dollar |  |  |  | Total | Percent | Dollar
State | Dolalrs | Change | Change |  |  | State | Dolalrs | Change | Change
AL | 8515 | 0.004282008717143571 | 298 |  |  | AL | 2957 | 0.3933428121565767 | 103
AZ | 2653 | 0.0938407639519952 | 93 |  |  | AZ | 27676 | 0.05590011304390115 | 969
GA | 3618 | 0.01561078831717433 | 127 |  |  | FL | 23697 | 0.3118972974536455 | 0
IA | 15026 | 0.3637506581156962 | 526 |  |  | GA | 23273 | 0.3642630430083042 | 815
MI | 47621 | 0.3514112199509638 | 1667 |  |  | IL | 50954 | 0.0663087630173318 | 1783
MO | 5922 | 0.1543272852239991 | 207 |  |  | IN | 48532 | 0.1817261463501912 | 1699
NE | 6865 | 0.002850129642607691 | 240 |  |  | IA | 36726 | 0.2442432209560692 | 1285
NC | 7843 | 0.2376213625579676 | 275 |  |  | MI | 57208 | 0.09712715223090909 | 2002
OH | 12122 | 0.2383436373887028 | 424 |  |  | MO | 1759 | 0.08266143345030184 | 62
 |  |  |  |  |  | NE | 2718 | 0.1788212880576973 | 95
 |  |  |  |  |  | NC | 24835 | 0.1727907918006753 | 869
 |  |  |  |  |  | OH | 56482 | 0.1455207246515382 | 1977
 |  |  |  |  |  | TN | 11956 | 0.3801042705318191 | 418
Spreadsheet: 02d0aba9-4e63-4a58-8fe0-010bf1615e85
Sheet: WebSpirs

WebSPIRS ([NAME])
2006-2007
 | 2006-07-01 00:00:00 | 2006-08-01 00:00:00 | 2006-09-01 00:00:00 | 2006-10-01 00:00:00 | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | Total | 2006-2007 Price | Price per unit
Biological Abstracts
Sessions | 43 | 58 | 148 | 269 | 259 | 85 | 81 | 252 | 282 | 251 | 89 | 28
Searches | 229 | 384 | 556 | 716 | 836 | 234 | 313 | 859 | 1033 | 742 | 383 | 192 |  | 23244
Turnaways | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
COUNTER-Compliant?: | Yes
Spreadsheet: 217745d1362166856-extract-numbers-from-a-alphanumeric-cell-extracting-numbers-from-cell
Sheet: Sheet1

 | Erf | Portion | Town
ERF 3544 OF BRYANSTON EXT.8 | 3544 |  | Bryanston
ERF 3547 OF BRYANSTON EXT.8
ERF 3576 OF BRYANSTON EXT.8
ERF 3583 OF BRYANSTON EXT.8
ERF 3588 OF BRYANSTON EXT.8
ERF 3592 OF BRYANSTON EXT.8
ERF 3593 OF BRYANSTON EXT.8
ERF 3594 OF BRYANSTON EXT.8
ERF 3595 OF BRYANSTON EXT.8
ERF 3598 OF BRYANSTON EXT.8
ERF 3627 OF BRYANSTON EXT.8
ERF 3634 OF BRYANSTON EXT.8
ERF 3640 OF BRYANSTON EXT.8
ERF 3648 OF BRYANSTON EXT.8
ERF 3666 OF BRYANSTON EXT.8
ERF 3675 OF BRYANSTON EXT.8
ERF 3681 OF BRYANSTON EXT.8
ERF 3691 OF BRYANSTON EXT.8
ERF 3733 OF BRYANSTON EXT.8
ERF 3739 OF BRYANSTON EXT.8
ERF 3757 OF BRYANSTON EXT.8
ERF 3758 OF BRYANSTON EXT.8
ERF 3770 OF BRYANSTON EXT.8
ERF 3779 OF BRYANSTON EXT.8
ERF 3780 OF BRYANSTON EXT.8
ERF 3782 OF BRYANSTON EXT.8
PORTION 1 OF ERF 3599 OF BRYANSTON EXT.8
PORTION 1 OF ERF 3748 OF BRYANSTON EXT.8
PORTION 12 OF ERF 4128 OF BRYANSTON EXT.8
PORTION 12 OF ERF 4309 OF BRYANSTON EXT.8
PORTION 13 OF ERF 4128 OF BRYANSTON EXT.8
PORTION 14 OF ERF 4128 OF BRYANSTON EXT.8
PORTION 2 OF ERF 3747 OF BRYANSTON EXT.8
PORTION 2 OF ERF 3752 OF BRYANSTON EXT.8
PORTION 2 OF ERF 4309 OF BRYANSTON EXT.8
PORTION 3 OF ERF 4309 OF BRYANSTON EXT.8
PORTION 9 OF ERF 4128 OF BRYANSTON EXT.8
REM OF ERF 3523 OF BRYANSTON EXT.8
REM OF ERF 3530 OF BRYANSTON EXT.8
REM OF ERF 3540 OF BRYANSTON EXT.8
REM OF ERF 3600 OF BRYANSTON EXT.8
REM OF ERF 3745 OF BRYANSTON EXT.8
REM OF ERF 3748 OF BRYANSTON EXT.8
REM OF ERF 4128 OF BRYANSTON EXT.8
REM OF PORTION 2 OF ERF 4127 OF BRYANSTON EXT.8
Spreadsheet: 703435d1605000258-vlookup-across-multiple-sheets-kupac-grupa-u-izradi
Sheet: jan

Skladište : 001            Naziv : VELEPRODAJNO SKLADIŠTE
code | group | Naziv |  |  | Artikli
4 |  | x |  |  | 27124.06
4 | 600 | TECEdrainline |  |  | 130.43
4 | 607 | TECEdrainpoint S |  |  | 1241.29
4 | 770 | TECEfloor |  |  | 11795.56
4 | 904 | TECEaktivacijske tipke |  |  | 7822.83
4 | 905 | TECEprofil-ispirna tehnika |  |  | 20.65
4 | 910 | TECEbase |  |  | 6113.3
8 |  | z |  |  | 31121.24
8 | 600 | TECEdrainline |  |  | 6373.79
8 | 607 | TECEdrainpoint S |  |  | 1261.94
8 | 700 | TECEflex |  |  | 8608.65
8 | 770 | TECEfloor |  |  | 4452
8 | 820 | TECElogo |  |  | 545.06
8 | 900 | TECEprofil |  |  | 2916.98
8 | 904 | TECEaktivacijske tipke |  |  | 2088.54
8 | 905 | TECEprofil-ispirna tehnika |  |  | 2284.28
8 | 910 | TECEbase |  |  | 2590
Spreadsheet: 781008d1652941718-formula-to-sort-lowest-value-of-doublets-sample
Sheet: Ark1

 |  | Customer | Returning | Price
 |  | 56615 |  | 68.5
 |  | 153454 |  | 456
 |  | 6351351 |  | 15
 |  | 6468 |  | 95 | This should return single in A5, because it's the lowest price of the 2 on that customer
 |  | 635418564 |  | 541
 |  | 153513 |  | 15
 |  | 6548645 |  | 2123
 |  | 51356 |  | 61
 |  | 115 |  | 15461
 |  | 54561516 |  | 5641
 |  | 541561 |  | 5000
 |  | 6468 |  | 750 | This should return single in A13, because it's 2 equal prices(750) and I only want 1 showing
 |  | 6468 |  | 750
 |  | 879 |  | 81
 |  | 7545451 |  | 351
 |  | 4664 |  | 651
 |  | 8944 |  | 651
 |  | 84968964 |  | 1561
 |  | 541561 |  | 3000 | This should return single in A20, because it's the lowest price of the 2 on that customer
Spreadsheet: 50477d1249928941-calculating-compounding-rent-increases-example
Sheet: Rent Roll

CURRENT RENT ROLL
 | TENANT | RSF | COMMENCE | TERM | EXPIRE | RENT | BUMPS
 |  |  |  | years |  | /YR
1 | 4001-C1 | 1000 | 2010-04-01 00:00:00 | 3 | 2013-03-01 00:00:00 | 12 | 0.03
2 | 4001-C2 | 1000 | 2010-02-01 00:00:00 | 2 | 2012-01-01 00:00:00 | 12 | 0.04
3 | 4001-D1 | 1000 | 2010-03-01 00:00:00 | 2 | 2012-02-01 00:00:00 | 12 | 0.03
4 | 4001-D2 | 1000 | 2010-04-01 00:00:00 | 1 | 2011-03-01 00:00:00 | 12 | 0.03
5 | 4001-B1 | 1000 | 2010-05-01 00:00:00 | 4 | 2014-04-01 00:00:00 | 12 | 0.02
Spreadsheet: 805857d1668962633-formula-to-count-blank-cells-from-column-where-the-rows-range-changes-sample
Sheet: Sheet1

Notes | Worker | Status
 | Name1
 | [NAME] | x
 | Name3 |  |  |  | Blank cell count from column c
 | Name4
 | Name5
 | Name6
 | Name7 | m
 | Name8
 | Name9
 | Name10
 | Name11 | d
 | Name12
 | Name13
 | Name14
 | Name15 | c
 | [NAME]
 | Name17
 | Name18
 | Name19
Spreadsheet: 835137d1688334143-i-want-to-automatically-copy-chart-from-sheets-sample
Sheet: Sheet1

deliveryLocations | PRICE
State(s) - KARNATAKA, TAMIL NADU, JAMMU & KASHMIR, DELHI, MAHARASHTRA, GUJARAT, ANDHRA PRADESH, UTTAR PRADESH, DADRA & NAGAR HAVELI, KERALA, WEST BENGAL, HARYANA, CHANDIGARH, PUNJAB, GOA, HIMACHAL PRADESH, BIHAR, MADHYA PRADESH, ASSAM, ARUNACHAL PRADESH, SIKKIM, ODISHA, RAJASTHAN, CHHATTISGARH, UTTARAKHAND, [NAME], MEGHALAYA, LAKSHADWEEP, DAMAN & DIU, MANIPUR, MIZORAM, TRIPURA, TELANGANA, PUDUCHERRY | Rs.4,320.00
State(s) - KARNATAKA, TAMIL NADU, JAMMU & KASHMIR, DELHI, MAHARASHTRA, GUJARAT, ANDHRA PRADESH, UTTAR PRADESH, KERALA, WEST BENGAL, HARYANA, CHANDIGARH, PUNJAB, GOA, HIMACHAL PRADESH, BIHAR, MADHYA PRADESH, SIKKIM, ODISHA, RAJASTHAN, CHHATTISGARH, UTTARAKHAND, [NAME] | Rs.1,514.00
All India | Rs.1,574.63
All India | Rs.1,693.36
All India | Rs.1,510.83
All India | Rs.3,999.01
State(s) - JAMMU & KASHMIR, DELHI, HARYANA, CHANDIGARH, PUNJAB, HIMACHAL PRADESH, RAJASTHAN | Rs.1,476.00
State(s) - KARNATAKA, TAMIL NADU, JAMMU & KASHMIR, DELHI, MAHARASHTRA, GUJARAT, ANDHRA PRADESH, UTTAR PRADESH, DADRA & NAGAR HAVELI, KERALA, WEST BENGAL, HARYANA, ANDAMAN & NICOBAR, CHANDIGARH, PUNJAB, GOA, HIMACHAL PRADESH, BIHAR, MADHYA PRADESH, SIKKIM, ODISHA, RAJASTHAN, CHHATTISGARH, UTTARAKHAND, [NAME], LAKSHADWEEP, DAMAN & DIU, TELANGANA, PUDUCHERRY | Rs.1,475.59
All India | Rs.4,320.00
 |  |  |  | Column1
Spreadsheet: 209612d1359144399-bowling-spreadsheet-rounddown-in-formula-question-700-club-pot-games_etaf
Sheet: Sheet1

Date |  |  |  |  |  |  |  |  |  |  |  | RANK(A1,$A$1:$A$5,0)+COUNTIF($A$1:A1,A1)-1
Shift
 |  |  |  |  |  | Scratch Scores |  |  | Handicap Scores |  |  |  | Scratch Rank |  |  | Handicap Rank |  |  |  | Scratch Player |  |  | Handicap Player
Name | Average | Handicap (90% of 225) | Scratch Pot Entry | HandicapPot Entry | Game 1 | Game 2 | Game 3 | Game 1 | Game 2 | Game 3 |  | Game 1 | Game 2 | Game 3 | Game 1 | Game 2 | Game 3 |  | Game 1 | Game 2 | Game 3 | Game 1 | Game 2 | Game 3
Name1 | 204 |  | x | x | 214 | 232 | 202
[NAME] | 189 |  | x |  | 189 | 151 | 209
Name3 | 210 |  |  | x | 258 | 179 | 199
Name4 | 221 |  | x |  | 190 | 171 | 246