tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 13d210d5-2065-4e2b-85f0-66c2f48c8830
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
 | 6302.0 Average Weekly Earnings, Australia
 | TABLE 11E. Average Weekly Earnings, Western Australia (Dollars) - Trend
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
Earnings; [NAME]; Full Time; Adult; Ordinary time earnings ;  Western Australia ; |  |  | Trend | A2828746L | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; [NAME]; Full Time; Adult; Total earnings ;  Western Australia ; |  |  | Trend | [NAME] | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; [NAME]; Total earnings ;  Western Australia ; |  |  | Trend | A2828755R | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Females; Full Time; Adult; Ordinary time earnings ;  Western Australia ; |  |  | Trend | A2828747R | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Females; Full Time; Adult; Total earnings ;  Western Australia ; |  |  | Trend | A2828750C | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Females; Total earnings ;  Western Australia ; |  |  | Trend | A2828756T | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Persons; Full Time; Adult; Ordinary time earnings ;  Western Australia ; |  |  | Trend | A2828748T | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Persons; Full Time; Adult; Total earnings ;  Western Australia ; |  |  | Trend | A2828751F | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Persons; Total earnings ;  Western Australia ; |  |  | Trend | A2828757V | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
© Commonwealth of Australia  2013
Spreadsheet: 06e742fa-c933-4acb-8b82-34a80fe2b0cd
Sheet: Grade 4 Reading

2013 Minnesota Comprehensive Assessments-Series III (MCA-III)
[NAME]
Scale Score | Level | Percentile Rank
411 | D | 1
412 | D | 2
413 | D | 2
414 | D | 2
415 | D | 2
416 | D | 3
417 | D | 3
418 | D | 3
419 | D | 3
420 | D | 4
421 | D | 4
422 | D | 5
423 | D | 5
424 | D | 6
425 | D | 6
426 | D | 7
427 | D | 8
428 | D | 8
429 | D | 9
430 | D | 10
431 | D | 11
432 | D | 12
433 | D | 13
434 | D | 14
435 | D | 16
436 | D | 17
437 | D | 18
438 | D | 20
439 | D | 22
440 | P | 24
441 | P | 25
442 | P | 28
443 | P | 30
444 | P | 32
445 | P | 34
446 | P | 37
447 | P | 39
448 | P | 42
449 | P | 45
450 | M | 47
451 | M | 50
452 | M | 53
453 | M | 56
454 | M | 59
455 | M | 61
456 | M | 64
457 | M | 67
458 | M | 69
459 | M | 72
460 | M | 74
461 | M | 76
462 | M | 79
463 | M | 81
464 | M | 83
465 | M | 84
466 | E | 86
467 | E | 88
468 | E | 89
469 | E | 90
470 | E | 91
471 | E | 92
472 | E | 93
473 | E | 94
474 | E | 95
475 | E | 95
476 | E | 96
477 | E | 97
478 | E | 97
479 | E | 97
480 | E | 98
481 | E | 98
482 | E | 98
483 | E | 98
484 | E | 98
485 | E | 99
486 | E | 99
487 | E | 99
488 | E | 99
489 | E | 99
490 | E | 99
End of Worksheet
Spreadsheet: 58715d1258988159-weighted-average-weighted-average
Sheet: Input Sheet

Input Sheet
 |  |  |  |  | 2010/11 | 2011/12 | 2012/13 | 2013/14 | 2013/14 | Total
 | GR
 | Volume of calls |  |  |  | 1800 |  |  |  |  | 1800
 | Acquired (gross adds) |  |  |  | 120 |  |  |  |  | 120
 | Win rate |  |  |  | 0.06666666666666667 |  |  |  |  | 0.06666666666666667
 | GR
 | Volume of calls |  |  |  | 66000 |  |  |  |  | 66000
 | Acquired (gross adds) |  |  |  | 1440 |  |  |  |  | 1440
 | Win rate |  |  |  | 0.02181818181818182 |  |  |  |  | 0.02181818181818182
 | Overall average Win Rate |  |  |  | 0.02300884955752212
 | Grand average Win Rate |  |  |  | 0.04424242424242424
 | Weighted average - Win Rate: Inbound |  |  |  | 0.001769911504424779
 | Weighted average - Win Rate: Outbound |  |  |  | 0.02123893805309734
Spreadsheet: 81612d1281717438-inserting-a-row-book1_gmunson01
Sheet: Before

Type | Identifier | Invoice # | Invoice Date | Invoice Amount
1 | 1746587 | 488 | 2010-07-01 00:00:00 | 7861.94
2 | 1746587 | 982 | 2010-07-02 00:00:00 | 7861.94
3 | 1746587 | 195 | 2010-07-02 00:00:00 | 7861.94
1 | 1746699 | 809 | 2010-06-25 00:00:00 | 1593.75
2 | 1746699 | 708 | 2010-06-25 00:00:00 | 1593.75
3 | 1746699 | 238 | 2010-06-25 00:00:00 | 1593.75
1 | 1746818 | 733 | 2010-06-26 00:00:00 | 689
2 | 1746818 | 180 | 2010-06-28 00:00:00 | 689
3 | 1746818 | 376 | 2010-06-28 00:00:00 | 689
1 | 1746855 | 164 | 2010-06-29 00:00:00 | 742
2 | 1746855 | 637 | 2010-06-28 00:00:00 | 742
3 | 1746855 | 183 | 2010-06-28 00:00:00 | 742
1 | 1746863 | 147 | 2010-06-29 00:00:00 | 1250
2 | 1746863 | 286 | 2010-06-28 00:00:00 | 1250
3 | 1746863 | 189 | 2010-06-28 00:00:00 | 1250
1 | 1747062 | 189 | 2010-07-01 00:00:00 | 116.95
2 | 1747062 | 612 | 2010-07-01 00:00:00 | 116.95
3 | 1747062 | 462 | 2010-07-01 00:00:00 | 116.95
1 | 1752586 | 846 | 2010-06-29 00:00:00 | 1260
2 | 1752586 | 324 | 2010-06-29 00:00:00 | 1260
3 | 1752586 | 517 | 2010-06-29 00:00:00 | 1260
1 | 1752931 | 865 | 2010-06-30 00:00:00 | 311.64
2 | 1752931 | 439 | 2010-06-27 00:00:00 | 311.64
3 | 1752931 | 677 | 2010-06-27 00:00:00 | 311.64
1 | 1752934 | 615 | 2010-07-01 00:00:00 | 2550.78
2 | 1752934 | 332 | 2010-07-01 00:00:00 | 2550.78
3 | 1752934 | 904 | 2010-07-01 00:00:00 | 2550.78
1 | 1752935 | 541 | 2010-07-01 00:00:00 | 2550.78
2 | 1752935 | 356 | 2010-07-01 00:00:00 | 2550.78
3 | 1752935 | 916 | 2010-07-01 00:00:00 | 2550.78
Spreadsheet: phillip_m_love__30142__9912_OA
Sheet: BUG_FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
REGION: BUG
 |  |  | 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 | 18373411 | 30357927
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 41043766 | 118235966
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 10532765
 | Total Sales: |  | 59417177 | 159126658
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -7707344 | -15009940
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -42605098 | -118737179
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 772833 | 1907845
 | Total Purchases: |  | -49539609 | -131839274
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | -36 | -112
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | -569433 | -1549151
 | Total Imbalances: |  | -569469 | -1549263
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 350183 | 952497
18 |  | W/D (Purchase from Stg) | -9389688 | -9918192
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -9389688 | -9918192
 | Total Storage: |  | -9039505 | -8965695
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | -268594 | -585803.514
 |  |  | 0 | 0
23 | Fuel: |  | -772833 | -1907845
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -899235
25 |  | Demand | 0 | -10532765
 | Total Transport Expense: |  | 0 | -11432000
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 6350126.300000802
31 |  | Prior Month Book Balance | 0 | -6830063
 |  | Total MTM Income | 0 | -479936.6999991983
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | -846573
34 |  | Originations | 0 | 22818
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 9629
 |  | TOTAL INTRA-MTH
Spreadsheet: 809776d1671303765-how-to-change-all-data-in-new-page-when-copied-from-old-one-tst-hendrikbez-
Sheet: SOA 3Q

Statement of Activity
YTD End of 3rd Qtr
 | Cash Beginning of Period
 | Revenue:
 |  | Total Revenue:
 | Expenses:
 |  | Total Expenses:
 | Net : Income Gain / (Loss)
 | Cash End of Period
Spreadsheet: 489298d1479201932-create-a-r-square-matrix-on-simple-strings-of-values-sample-45-
Sheet: Folha2

title 1 | title 2 | title 3
1 | 2 | 3
2 | 3 | 4
3 | 2 | 5
4 | 1 | 3
Spreadsheet: ed9b1b68-4b39-4854-8fc3-cbf0f25e47aa
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
7999 | 46248 | Matej | [NAME] | SVK | 184 | 00:20:54 | 00:00:00 | 00:25:33 | 00:00:00 | 00:32:08 | 1 | [NAME]
7999 | 55591 | [NAME] | Gentry | GBR | 123 | 00:22:11 | 00:00:00 | 00:29:46 | 00:00:00 | 00:32:17 | 2 | 01:24:14
Spreadsheet: eric_saibi__9845__010801R
Sheet: Gavins Point Hydro 01

Owner Name |  | US Army Corps of Engineers
Station Name |  | Gavins Point Dam Hydro
Plant ID |  | 1501661
Unit Name |  | Hydro 01
Unit ID |  | 1007252
NERC Region |  | MAPP
State |  | SD
Fuel Type |  | Hydro
Capacity |  | 44 MW
Start Date |  | 2000-12-10 00:00:00
End Date |  | 2001-01-19 00:00:00
Prv. Start Date |  | 2000-12-10 00:00:00
Prv. End Date |  | 2001-01-08 00:00:00
Outage ID |  | 11999
Comments |  | Cavitation is scheduled to be complete on the 19th
SIC |  | 4911
Spreadsheet: 117207d1312498599-move-data-to-another-sheet-by-criteria-extract-dummy-file
Sheet: Sheet1

Date of QAM | Date of Call | Agent Name | Supervisor | Coaching compliance
2011-08-05 00:00:00 | 2011-08-05 00:00:00 | [NAME] | Nathan | 0
2011-08-05 00:00:00 | 2011-08-06 00:00:00 | [NAME] | Nathan | -2
2011-08-05 00:00:00 | 2011-08-17 00:00:00 | Ramly |  | -13
2011-08-05 00:00:00 | 2011-08-02 00:00:00 | [NAME] |  | 2
2011-08-05 00:00:00 | 2011-08-06 00:00:00 | [NAME] |  | -2
2011-08-05 00:00:00 | 2011-08-04 00:00:00 | [NAME] |  | 0
2011-08-05 00:00:00 | 2011-08-01 00:00:00 | [NAME] |  | 3
2011-08-05 00:00:00 | 2011-08-06 00:00:00 | [NAME] |  | -2
Spreadsheet: jeff_dasovich__14104__Data Book Item 7
Sheet: DA Demand by Market Seg (MDth)

Pacific Gas and Electric Company
Daily Demand By Sector
Electric Generation (EG), Noncore, Core and Storage Injection
 | Monthly Average from 3/98 to 8/00
(MDth per day)
 | Core | Noncore | EG | Storage Injection | Total
1998-03-01 00:00:00 | 1005 | 516.3397483870967 | 472.6602516129033 | 36.91854838709677
1998-04-01 00:00:00 | 870 | 505.6813166666667 | 478.3186833333333 | 189.6868333333333
1998-05-01 00:00:00 | 708 | 493.4831161290323 | 387.5168838709677 | 216.5028387096774
1998-06-01 00:00:00 | 516 | 506.3775833333333 | 487.6224166666667 | 191.2369333333334
1998-07-01 00:00:00 | 422 | 567.3061516129032 | 743.6938483870968 | 169.0474516129032
1998-08-01 00:00:00 | 392 | 745.3137741935484 | 1019.686225806452 | 151.6782580645161
1998-09-01 00:00:00 | 426 | 757.7075500000001 | 988.2924499999999 | 137.1452666666667
1998-10-01 00:00:00 | 576 | 639.4273193548387 | 906.5726806451613 | 103.5948709677419
1998-11-01 00:00:00 | 1028 | 623.0450733333333 | 883.9549266666667 | 20.0775
1998-12-01 00:00:00 | 1720 | 606.5430419354839 | 803.4569580645161 | 0.4413548387096775
1999-01-01 00:00:00 | 1623 | 547.9068741935484 | 685.0931258064516 | 7.844709677419355
1999-02-01 00:00:00 | 1410 | 531.9401607142858 | 609.0598392857142 | 13.12639285714286
1999-03-01 00:00:00 | 1182 | 524.8951870967742 | 603.1048129032258 | 34.8541935483871
1999-04-01 00:00:00 | 905 | 450.50341 | 617.49659 | 255.5984
1999-05-01 00:00:00 | 672 | 432.9185903225807 | 557.0814096774193 | 232.4138709677419
1999-06-01 00:00:00 | 497 | 453.8038066666667 | 618.1961933333333 | 155.0144666666667
1999-07-01 00:00:00 | 434 | 537.0453419354839 | 744.9546580645161 | 195.1444193548387
1999-08-01 00:00:00 | 446 | 679.1167677419355 | 790.8832322580645 | 175.9003870967742
1999-09-01 00:00:00 | 456 | 697.5788066666667 | 855.4211933333333 | 161.8688
1999-10-01 00:00:00 | 527 | 614.1086096774193 | 1073.891390322581 | 83.07119354838709
1999-11-01 00:00:00 | 924 | 486.07132 | 867.92868 | 51.3359
1999-12-01 00:00:00 | 1469 | 479.8756419354839 | 841.1243580645162 | 19.47206451612903
2000-01-01 00:00:00 | 1378 | 482.4341161290322 | 837.5658838709678 | 4.271612903225807
2000-02-01 00:00:00 | 1259 | 500.5768862068966 | 762.4231137931034 | 4.579689655172414
2000-03-01 00:00:00 | 1102 | 519.3044032258065 | 621.6955967741935 | 42.96222580645161
2000-04-01 00:00:00 | 693 | 466.23032 | 532.76968 | 123.0510666666667
2000-05-01 00:00:00 | 628 | 451.8610612903226 | 786.1389387096774 | 191.5614516129032
2000-06-01 00:00:00 | 464 | 474.6658433333333 | 1075.334156666667 | 184.8860666666667
2000-07-01 00:00:00 | 456 | 591.2131064516129 | 1036.786893548387 | 223.662064516129
2000-08-01 00:00:00 | 477 | 699 | 1304 | 194.5650322580645
Average
%
Note:
EG includes cogenerator, former PG&E power plant, and PG&E power plant demands
Spreadsheet: 152560d1335437702-vlook-ups-help-please-fte-20count-2-
Sheet: Sheet1

Names | Dates | FTE
fffdf | 2009-01-02 00:00:00 | 37.5
ddd | 2009-12-01 00:00:00 | 37.5 |  |  | FTE at this date
fffdf | 2011-07-25 00:00:00 | 37.5 | I would like to have | 2011-10-31 00:00:00
ddfd | 2011-10-03 00:00:00 | 22
 | 2011-10-03 00:00:00 | 37.5
 | 2011-10-03 00:00:00 | 37.5
 | 2011-10-03 00:00:00 | 37.5
 | 2011-10-03 00:00:00 | 37.5
 | 2011-10-03 00:00:00 | 37.5
 | 2011-10-17 00:00:00 | 37.5
 | 2011-10-17 00:00:00 | 37.5
 | 2011-10-17 00:00:00 | 37.5
 | 2011-10-17 00:00:00 | 37.5
 | 2011-10-31 00:00:00 | 30.5
 | 2011-10-31 00:00:00 | 37.5
 | 2011-10-31 00:00:00 | 37.5
 | 2011-11-28 00:00:00 | 25.25
 | 2011-11-28 00:00:00 | 25.25
 | 2011-11-28 00:00:00 | 37.5
 | 2011-11-28 00:00:00 | 37.5
 | 2011-11-28 00:00:00 | 37.5
 | 2011-11-28 00:00:00 | 37.5
 | 2011-11-28 00:00:00 | 37.5
 | 2012-01-09 00:00:00 | 37.5
 | 2012-01-09 00:00:00 | 37.5
 | 2012-01-09 00:00:00 | 37.5
 | 2012-01-09 00:00:00 | 37.5
 | 2012-01-09 00:00:00 | 37.5
Spreadsheet: 886887d1736981977-lookups-with-text-insertions-example
Sheet: Investible Universe

 | EQY_FUND_CRNCY | [NAME] | FA_ADJUSTED | 1000000
 | LCL
 | Total Investible Universe: Stocks $250m - $6 Billion
 | Ticker | Short Name | Market [NAME] | BICS L4 Sub Ind Nm | Theme | [NAME] | Revenue Inflecting | EBITDA $ (m) Inflecting | # Tamale Notes | Russell 2000
 | None (1989 securities)
1 | BACE NA Equity | BRIGADE-M3 EUR-A | 250 | Investment Companies | SPAC |  | From -9.9% to 5.1%
 | CYFL US Equity | CENTURY FIN CORP | 250.0393344 | Regional Bank | Interest Rate Beneficiary |  | From -8.3% to 12.1%
 | LFVN US Equity | LIFEVANTAGE CORP | 250.12882313 | Packaged Food | [NAME]
 | FDBC US Equity | FIDELITY D&D BAN | 250.8937335 | Community Bank | Interest Rate Beneficiary
 | SVII US Equity | SPRING VALLEY AC | 251.14791558 | Investment Companies | SPAC
 | BSEM US Equity | BIOSTEM TECHNOLO | 251.1609011 | Biotech (regenerative medicine) | Biotech/medical |  |  | From -117 to 82
 | ESBA US Equity | EMPIRE STATE -ES | 251.7369600412 | Office REIT | REIT |  |  | From -73 to 46
 | PCOK US Equity | PACIFIC OAK STRA | 251.81911217 | Multi Asset Class REIT | REIT |  |  |  |  | Yes
 | WTI US Equity | W&T OFFSHORE INC | 251.98147377 | Exploration & Production | Fossil fuel / Energy |  |  |  |  | Yes
 | RENE US Equity | [NAME]A | 252.5346386483 | Investment Companies | SPAC |  |  |  |  | Yes
 | SAMG US Equity | SILVERCREST AS-A | 253.1945416 | Wealth Management | Asset Management |  |  |  |  | Yes
Spreadsheet: 166263d1341510780-getting-a-cell-to-populate-when-it-sees-a-name-airframe-engine-log-sample-modified-by-tigeravatar-v2
Sheet: Tom

Today is:
 | Date | Hourly | Cost Calculator
 |  |  |  |  | RUNNING TOTAL
 |  |  |  |  |  | Expenses
 |  |  |  |  |  | Date | Cost | Description
 |  |  | Total
Spreadsheet: 865432d1712496289-cant-find-error-in-formula-error
Sheet: Sheet1

 | Multiple Credit Card Payoff Calculator - Snowball Method |  |  |  |  |  |  |  | Credit Card Payoff Calculator in Excel (Create & Use) - ExcelDemy
 |  |  |  | card 1 | card 2 | card 3
 | Balance |  |  | 4434.28 | 3251.89 | 6600
 | Minimum Payment |  |  | 158 | 105 | 158
 | APR |  |  | 0.2924 | 0.2605 | 0.2924
 | Extra Payments per Month |  |  | 0 | 0 | 0
 | Credit Limit |  |  | 5400 | 3500 | 5400
 | Amortization Schedule
 | Month Number | card 1 |  | card 2 |  | card 3
 |  | Payment | Balance | Payment | Balance | Payment |  | Balance
 | 0
Spreadsheet: 864102d1711422510-match-transactions-based-on-two-months-interval-vat-for-two-months
Sheet: TAX

VAT RETURN
 |  |  |  |  |  |  | I'm kindly requesting for excel formula that can  match the VAT transactions based on two months period as in the desired solution
 | TIN |  |  | Name of Registered Operator
 | 20019000 |  |  | X PVT LTD
 | VAT Registration Number |  |  | Trading as
 | 220000 |  |  | X General Dealers
 | Period | January and February |  |  |  |  |  |  |  |  | January and February
 |  |  |  |  |  |  |  |  |  |  | March and April
 | Output Tax: | 1130.73 |  |  |  |  |  |  |  |  | May and June
 | Less Input Tax: | 187.54 |  |  |  |  |  |  |  |  | July and August
 | VAT Payable |  |  |  |  |  |  |  |  |  | September and October
 |  |  |  |  |  |  |  |  |  |  | November and December
Desired solution |  | I'm kindly requesting for excel formula that can  match the VAT transactions based on two months period as in the desired solution, using information on data worksheet.
Output VAT
Date | Invoice | Customer | VAT Number | Amount | VAT | Description
2024-01-01 00:00:00 | 244 | OK | 200100 | 200 | 30 | SALES
2024-01-18 00:00:00 | 272 | TM |  | 200 | 30 | SALES
2024-01-20 00:00:00 | 271 | Tsholotsho |  | 500 | 75 | SALES
2024-01-31 00:00:00 | 273 | Brothers High School |  | 900 | 135 | SALES
2024-02-07 00:00:00 | 275 | Heyval Pvt Ltd | 10013382 | 43.48 | 6.52 | SALES
2023-02-10 00:00:00 | 276 | OK | 200100 | 200 | 30 | SALES
2024-02-15 00:00:00 | 274 | Fools Investments | 10068109 | 391.31 | 58.69 | SALES
2024-02-28 00:00:00 | 277 | Cash sales |  | 5103.48 | 765.52 | SALES
Total
Input VAT
Date | Invoice | Customer | VAT Number | Amount | VAT | Description
2024-01-02 00:00:00 | 100 | Choppies Aaro Mart | 10061810 | 3.74 | 0.56 | Fresh Rooibos
2024-01-04 00:00:00 | BINO8816 | Mainbeam Enterprises | 10052329 | 86.96 | 13.04 | Trading stock
2024-01-05 00:00:00 | 124343 | Codeco | 10000723 | 48.67 | 7.3 | Trading stock
2024-01-06 00:00:00 | [NAME] | Mainbeam Enterprises | 10052329 | 153.9 | 23.08 | Trading stock
2024-01-08 00:00:00 | IN200 | Choppies Aaro Mart | 10061810 | 3.74 | 0.56 | Bottled Water
2024-01-19 00:00:00 | 124925 | Codeco | 10000723 | 64.4 | 9.66 | Trading stock
2024-01-20 00:00:00 | INVBY74229 | Fuser Technologies | 220260831 | 13.04 | 1.96 | USB Mouse
2024-01-24 00:00:00 | INV10391 | Cosmo Baking Supplies | 10121666 | 114.79 | 17.21 | Trading stock
2024-01-25 00:00:00 | 250559784 | City of Bulawayo |  | 414.13 | 62.1 | Licence
2024-01-26 00:00:00 | CIN0046249 | Country Choice Foods | 220024195 | 83.55 | 7.81 | ICING Sugar
2024-02-02 00:00:00 | 10973 | Rawplast Investments | 234600 | 10 | 1.5 | [NAME]
2024-02-06 00:00:00 | 404265266 | Schweppes | 220050888 | 27.4 | 4.11 | Fresh Rooibos
2024-02-06 00:00:00 | 11 | Letty's Baking Shop |  | 296 | 23 | Toppers
2024-02-19 00:00:00 |  | Schweppes | 220050888 | 69.6 | 10.44 | water
2024-02-28 00:00:00 | CIN0046461 | Counntry Choice Foods | 220024195 | 81.95 | 5.21 | Icing Sugar
Total
Spreadsheet: 0548902f-9f18-4c5e-9136-434f89d8794d
Sheet: Biology-for reference

Biology Committee - for reference only
Evaluation | G | G | G |  | G |  |  | G | G | G | G
Synthesis | G | G | BS | G | G |  |  | BS | BS | BS | BS
Analysis | BS | BS | BS | G | BS | G | G | BS | BS | BS | BS
Application | BS | BS | BS | BS | CC | BS | BS | CC | CC | CC | CC
Comprehension | CC | CC | CC | CC | HS | CC | CC | CC | CC | HS | CC
Knowledge | HS | HS | HS | HS | HS | HS | HS | HS | HS | HS | HS
 | Evolution | Structure/Function | Information Flow | Transformations of | Systems Biology | Physical Sciences | Mathematics | Experimentation/ | Laboratory Skills | Communication | Science and Society
 |  |  |  | Energy and Matter |  |  |  | [NAME]
G | graduate-level competencies
BS | baccalaureate-level competencies
CC | associate-level competencies
HS | secondary education competencies
Spreadsheet: 811251d1672378592-vlookup-in-multiple-column-vlookup_multiplecolumns-ans
Sheet: Result

Center | Area | Location
0001 | 0001
0001 | 0088
0001 | 0100
2000 | 0003
2000 | 0004
2048 | 0003
2048 | 0004
2048 | 0005
2048 | 0006
2048 | 0008
2048 | 0009
2048 | 0010
2048 | 0011
2048 | 0015
2048 | 0016
Spreadsheet: 808330d1670419328-the-average-of-a-second-row-gemiddelde-waarden-rl-nederlandse-zomer
Sheet: Blad1

2018-05-01 00:00:00 | [NAME]  [°C] | Laagste RL [%] |  | Maand | Aantal | Gemiddelde
1 | 11.7 | 44 |  | 2018-05-01 00:00:00 | 3
2 | 14.7 | 47 |  | 2018-06-01 00:00:00
3 | 13.7 | 49 |  | 2018-07-01 00:00:00
4 | 16.6 | 47 |  | 2018-08-01 00:00:00
5 | 20.2 | 38 |  | 2018-09-01 00:00:00 |  | nvt
6 | 24.7 | 42 |  | 2019-05-01 00:00:00 |  | nvt
7 | 25.5 | 31 |  | 2019-06-01 00:00:00
8 | 26.1 | 35 |  | 2019-07-01 00:00:00
9 | 18.4 | 66 |  | 2019-08-01 00:00:00
10 | 14.6 | 64 |  | 2019-09-01 00:00:00 |  | nvt
11 | 18.5 | 47 |  | 2020-05-01 00:00:00
12 | 22 | 39 |  | 2020-06-01 00:00:00
13 | 13.9 | 81 |  | 2020-07-01 00:00:00
14 | 12.5 | 82 |  | 2020-08-01 00:00:00
15 | 23.4 | 36 |  | 2020-09-01 00:00:00
16 | 15.7 | 76 |  | 2021-05-01 00:00:00 |  | nvt
17 | 12.9 | 61 |  | 2021-06-01 00:00:00
18 | 12.4 | 60 |  | 2021-07-01 00:00:00 |  | nvt
19 | 11.6 | 74 |  | 2021-08-01 00:00:00 |  | nvt
20 | 19.4 | 57 |  | 2021-09-01 00:00:00 |  | nvt
21 | 24.5 | 42 |  | 2022-05-01 00:00:00 |  | nvt
22 | 22.8 | 54 |  | 2022-06-01 00:00:00
23 | 21.9 | 59 |  | 2022-07-01 00:00:00
24 | 22 | 60 |  | 2022-08-01 00:00:00
25 | 18.9 | 80 |  | 2022-09-01 00:00:00
26 | 27.1 | 46 |  | Totaal |  | Totaal
27 | 23.2 | 60
28 | 26.5 | 57
29 | 24.1 | 73
30 | 24.8 | 67
31 | 23 | 69
Spreadsheet: 42970d1241593362-sum-across-multiple-sheets-demo2
Sheet: 1

 | Estimated | No.Sold | Free | Remarks
Apple | 26 | 24 | 5 | BET
Green | 15 | 12 | 6 | Free
Kashmiur | 17 | 15 | 7 | Free | 26
Grape | 19 | 30 | 5 | Free
 |  |  | 4 | Free
 |  |  | 4 | Free
 |  |  | 4 | Free
[NAME] | 28 | 19 | 9
Pine Apple | 28 | 20 | 8
Kiwi | 30 | 17 | 13
 |  |  |  |  |  |  |  | 1 | BET
 |  |  |  |  |  |  |  | 2 | BET
 |  |  |  |  |  |  |  | 3 | BET