tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 679916d1590682794-get-subtotal-from-pivot-with-sumifs-with-out-repeat-all-demo
Sheet: Sheet1

 | Sl No | Name | Spend |  |  |  |  | Sum of Spend |  |  |  |  |  |  | Sum of Spend
 | 1 | A | 100 |  |  |  |  | Name | Sl No | Total | As of now | Output requested (SUBTOAL OF COLUMN I) |  |  | Name | Sl No | Total | As of now
 | 2 | B | 200 |  |  |  |  | A | 1 | 100 |  |  |  |  | A | 1 | 100
 | 3 | C | 300 |  |  |  |  |  | 7 | 700 |  |  |  |  | A | 7 | 700
 | 4 | D | 400 |  |  |  |  | B | 2 | 200 |  |  |  |  | B | 2 | 200
 | 5 | E | 500 |  |  |  |  |  | 8 | 800 |  |  |  |  | B | 8 | 800
 | 6 | F | 600 |  |  |  |  | C | 3 | 300 |  |  |  |  | C | 3 | 300
 | 7 | A | 700 |  |  |  |  |  | 9 | 900 |  |  |  |  | C | 9 | 900
 | 8 | B | 800 |  |  |  |  | D | 4 | 400 |  |  |  |  | D | 4 | 400
 | 9 | C | 900 |  |  |  |  |  | 10 | 1000 |  |  |  |  | D | 10 | 1000
 | 10 | D | 1000 |  |  |  |  | E | 5 | 500 |  |  |  |  | E | 5 | 500
 | 11 | E | 1100 |  |  |  |  |  | 11 | 1100 |  |  |  |  | E | 11 | 1100
 | 12 | F | 1200 |  |  |  |  | F | 6 | 600 |  |  |  |  | F | 6 | 600
 |  |  |  |  |  |  |  |  | 12 | 1200 |  |  |  |  | F | 12 | 1200
 |  |  |  |  |  |  |  | Grand Total |  | 7800 |  |  |  |  | Grand Total |  | 7800
Spreadsheet: 330397d1404738993-formula-using-multiple-if-criteria-2015-daily-room-credit-test
Sheet: EXAMPLE|TEST PAGE

DAILY ROOM CREDIT
NAME OF STAFF RESPONSIBLE |  |  |  |  |  | DATE:
OPENING |  |  | CLOSING |  |  | HOTEL:
 |  |  |  |  |  | RESORT:
ROOM | CREDIT |  |  | AMOUNT PAID |  | PREVIOUS SALES |  | FINAL CREDIT
# NBR | START | END | TODAY | CASH | CREDIT CARD | CASH | CREDIT CARD | TODAY
A | B | C | D (C-B) | E | F | G (E-D) | H (F-D) | I = D if E or F = 0
100
101
102 | 50 | 100
103 | 50 | 100 |  | 100
104 | 50 | 100 |  |  | 100
105 | 50 | 100 |  | 50 | 50
106 | 50 | 100 |  | 25 | 75
107 | 50 | 100 |  | 75 | 25
108 | 50 | 40
109 | 50 | 40 |  | 60
110/111
200
Example below of what it should/could look like
ROOM | CREDIT |  |  | AMOUNT PAID |  | PREVIOUS SALES |  | FINAL CREDIT
# NBR | START | END | TODAY | CASH | CREDIT CARD | CASH | CREDIT CARD | TODAY
A | B | C | D (C-B) | E | F | G (E-D) | H (F-D) | I = D if E or F = 0
100
101
102 | 50 | 100 | 50 |  |  |  |  | 50
103 | 50 | 100 | 50 | 100 |  | 50
104 | 50 | 100 | 50 |  | 100 |  | 50
105 | 50 | 100 | 50 | 50 | 50 | 50
106 | 50 | 100 | 50 | 25 | 75 |  | 50
107 | 50 | 100 | 50 | 75 | 25 | 25 | 25
108 | 50 | 40 | -10
109 | 50 | 40 | 40 | 60 |  | 50 |  | 40
110/111
200
Spreadsheet: c27a9428-58af-47df-9da8-2d6dd25dd8ff
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40452474 | 2014-03-10 21:03:00 | ALLIES | 1 | 6 | 5 | 1422784 | flarchi | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
Spreadsheet: 99119d1297865598-sort-data-into-different-coloums-data
Sheet: Sheet1

 |  |  |  |  |  |  |  | need coloums D,E,F,G to list as they are set her, listing only the numbers in order from top to bottom
Name | Score |  | [NAME] | Lindsey | Ian | [NAME]
Lindsey | 5 |  | 3 | 5 | 4 | 0
[NAME] | 3 |  | 4 | 2 | 4 | 3
[NAME] | 0 |  | 1 | 0 |  | 2
Ian | 4 |  | 5 |  |  | 4
Lindsey
[NAME] | 4
[NAME] | 3
Ian
Lindsey | 2
[NAME] | 1 |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | 2 |  |  |  |  |  |  |  |  |  | [NAME] | 1
Ian | 4 |  |  |  |  |  |  |  |  |  | Lindsey | 2
Lindsey | 0 |  |  |  |  |  |  |  |  |  | Ian | 3
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | 4
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 5
Ian |  |  |  |  |  |  |  |  |  |  |  | 6
[NAME] | 4 |  |  |  |  |  |  |  |  |  |  | 7
Ian |  |  |  |  |  |  |  |  |  |  |  | 8
Lindsey |  |  |  |  |  |  |  |  |  |  |  | 9
[NAME] | 5 |  |  |  |  |  |  |  |  |  |  | 10
Spreadsheet: darrell_schoolcraft__7827__imbalsumm0110
Sheet: PGETX

 |  |  |  |  | 12283
 | [NAME] |  | Pecos Del |  | Gunpoint #2
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -122197 | -31314 |  | -90498
2 | -70606 | -48264 |  | -22761 |  |  |  |  |  |  |  |  |  | Avg
3 | -63000 | -52395 |  | -11665 |  |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
4 | -61864 | -36331 |  | -26182
5 | -60984 | -47080 |  | -14935
6 | -39138 | -39080 |  | 65 |  |  |  |  |  | 2001-01-01 00:00:00 | -715680 | -705664 |  | 8.21
7 | -25113 | -24080 |  | 65 |  |  |  |  |  | 2001-02-01 00:00:00 | -661568 | -648307 |  | 5.62
8 |  |  |  |  |  |  |  |  |  | 2001-03-01 00:00:00 | -1831536 | -1828209 |  | 4.98
9 |  |  |  |  |  |  |  |  |  | 2001-04-01 00:00:00 |  | -3486797 |  | 4.87
10 |  |  |  |  |  |  |  |  |  | 2001-05-01 00:00:00 | -3735499 | -3753054 |  | 3.82
11 |  |  |  |  |  |  |  |  |  | 2001-06-01 00:00:00 |  | -5025875 |  | 3.2
12 |  |  |  |  |  |  |  |  |  | 2001-07-01 00:00:00 | -4565965 | -4525416 |  | 2.77
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  | 2001-09-30 00:00:00 |  |  | 446379
 |  |  |  | 2001-10-06 00:00:00
 | CBS Volume
 |  |  |  | 104042
 | 2001-10-07 00:00:00
Spreadsheet: daren_farmer__5715__Cost Center Quick Reference 020101
Sheet: Workorder Conversion

ENERGY OPERATIONS
CAPITAL PROJECT WORKORDERS
2001 QUICK REFERENCE
Description |  |  | Company | WBS Elements
Capital Workorders
Global Counterparty Next Generation
Enron Employee Salaries |  |  | 083E | c.005166.01.40.92
Contractor Costs |  |  | 083E | c.005166.01.40.93
Other Expenses |  |  | 083E | c.005166.01.40.94
Trade Warehouse
Enron Employee Salaries |  |  | 083E | c.005241.01.40.92
Contractor Costs |  |  | 083E | c.005241.01.40.93
Other Expenses |  |  | 083E | c.005241.01.40.94
Market Knowledge Management
Enron Employee Salaries |  |  | 083E | c.005242.01.40.92
Contractor Costs |  |  | 083E | [NAME]
Other Expenses |  |  | 083E | c.005242.01.40.94
Global Risk Operations Intranet
Enron Employee Salaries |  |  | 083E | c.005243.01.40.92
Contractor Costs |  |  | 083E | c.005243.01.40.93
Other Expenses |  |  | 083E | [NAME]
Houston Cost Analysis
Enron Employee Salaries |  |  | 083E | c.005244.01.40.92
Contractor Costs |  |  | 083E | c.005244.01.40.93
Other Expenses |  |  | 083E | c.005244.01.40.94
Global Contracts & Facilities
Enron Employee Salaries |  |  | 083E | c.005240.01.40.92
Contractor Costs |  |  | 083E | c.005240.01.40.93
Other Expenses |  |  | 083E | c.005240.01.40.94
Hardware Purchases
Hardware Costs |  |  | 083E | c.005171.01.40.90
Livelink
Enron Employee Salaries |  |  | 083E | c.005168.01.40.92
Contractor Costs |  |  | 083E | c.005168.01.40.93
Other Expenses |  |  | 083E | c.005168.01.40.94
[NAME]
Enron Employee Salaries |  |  | 083E | c.005169.01.40.92
Contractor Costs |  |  | 083E | c.005169.01.40.93
Other Expenses |  |  | 083E | c.005169.01.40.94
Hiway
Enron Employee Salaries |  |  | 083E | c.005245.01.40.92
Contractor Costs |  |  | 083E | [NAME]
Other Expenses |  |  | 083E | c.005245.01.40.94
Commodity Logic
Enron Employee Salaries |  |  | 083E | c.005170.01.40.92
Contractor Costs |  |  | 083E | c.005170.01.40.93
Other Expenses |  |  | 083E | c.005170.01.40.94
Spreadsheet: 268996d1380910052-is-there-any-way-to-autofill-hyperlinks-puppies_help
Sheet: Puppy Priority List

Priority | Puppy | row in Pivot Table sheet with this data | cell reference
1 | Corgi
2 | Lab
3 | German Shepard
4 | [NAME]
Spreadsheet: 1121bf43-164c-4549-aa68-d458f705d530
Sheet: Sheet1

Average Days in the Past Month for Which Mental Health Was Not Good,  Adults Ages 18 Years and [NAME], by Race and Ethnicity, Maine, 2006-2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Weighted Number | Mean | LCL Mean | UCL Mean
American Indian or Alaskan Native only, non-Hispanic | 261 | 7.144141 | 0.898588 | 8.90540445
Black only,  non-Hispanic | 104 | 4.130041 | 1.157083 | 6.3979631
Hispanic | 321 | 4.538507 | 0.693107 | 5.89702069
Multiracial,  non-Hispanic | 346 | 5.540873 | 0.600434 | 6.71774364
Other,  non-Hispanic | 188 | 3.284482 | 0.560147 | 4.38238939
White only,  non-Hispanic | 31896 | 3.392832 | 0.057849 | 3.50621835
Data Source: Behavioral Risk Factor Surveillance System
Mean:  mean number of days in the last 30 days for which the respondent's mental health was not good, based on the question: "How many days in the past 30 days whould you say that your physical health ws not good?"
LCL Mean = Lower 95% confidence level of mean, based on the weighted number.
UCL Mean = Upper 95% confidence level of mean, based on the weighted number.
All means are weighted to be more representative of the population of Maine and to adjust for non-response.
Spreadsheet: 218792d1362581380-using-concatenate-on-hundreds-of-cells-concatenate-test-file
Sheet: Sheet1

2400
2410
2411
2420
2421
2426
2429
2430
2431
2434
2435
2436
2439
2440
2441
2448
2449
2450
2451
2452
2490
2491
2492
2493
2499
2500
2510
2511
2512
2514
2515
2517
2519
2520
2521
2522
2530
2531
2540
2541
2542
2590
2591
2599
2600
2610
2611
2620
2621
2630
2631
2640
2641
2642
2643
2645
2646
2647
2648
2649
2650
2651
2652
2653
2654
2655
2656
2657
2660
2661
2670
2671
2672
2673
2674
2675
2676
2677
2678
2679
2700
2710
2711
2720
2721
2722
2730
2731
2732
2740
2741
2742
2750
2751
2752
2753
2754
2759
2760
2761
2770
2771
2780
2782
2789
2790
2791
2793
2794
2795
2796
2799
3000
3010
3011
3020
3021
3030
3031
3040
3041
3050
3052
3053
3060
3061
3069
3070
3079
3080
3081
3082
3083
3084
3085
3086
3087
3088
3089
3100
3110
3111
3130
3131
3140
3142
3143
3144
3149
3150
3151
3160
3161
3170
3171
3172
3190
3199
3200
3210
3211
3220
3221
3229
3230
3231
3240
3241
3250
3251
3253
3255
3259
3260
3261
3262
3263
3264
3269
3270
3271
3272
3273
3274
3275
3280
3281
3290
3291
3292
3293
3295
3296
3297
3299
3500
3510
3511
3519
3520
3523
3524
3530
3531
3532
3533
3534
3535
3536
3537
3540
3541
3542
3543
3544
3545
3546
3547
3548
3549
3550
3551
3552
3553
3554
3555
3556
3559
3560
3561
3562
3563
3564
3565
3566
3567
3568
3569
3570
3571
3572
3573
3574
3575
3576
3577
3578
3579
3580
3581
3582
3585
3586
3589
3590
3592
3593
3594
3596
3599
3800
3810
3812
3820
3821
3822
3823
3824
3825
3826
3827
3829
3830
3832
3840
3841
3842
3843
3844
3845
3850
3851
3860
3861
3870
3873
3900
3910
3911
3914
3915
3930
3931
3940
3942
3944
3949
3950
3951
3952
3953
3955
3960
3961
3962
3963
3964
3965
3990
3991
3993
3995
3996
3999
Spreadsheet: 102912d1300809726-moving-cells-without-changing-references-sample-seating-chart
Sheet: Seating Chart

# of Tables | 3
 |  |  | Guest A |  | Guest I |  | Guest Q
 |  |  | Guest B |  | Guest J |  | Guest R
 |  |  | Guest C |  | Guest K |  | Guest S
 |  |  | Guest D |  | Guest L |  | Guest T
 |  |  | Guest E |  | Guest M |  | [NAME]
 |  |  | Guest F |  | Guest N |  | Guest V
 |  |  | Guest G |  | Guest O |  | Guest W
 |  |  | Guest H |  | Guest P |  | Guest X
Spreadsheet: 160612d1339141675-excel-2007-moving-target-cell-euro-2012-spreadsheet-uefa-euro-2012-empresa
Sheet: Puntos

PUNTOS | 1ª Fase
 | PG | PE | Cuartos | Semis | Final | Campeon | TOTAL
Alemania
[NAME]
Dinamarca
España
Francia
[NAME]
Inglaterra
Italia
Países [NAME]
Polonia
Portugal
[NAME]
República de Irlanda
[NAME]
[NAME]
Ucrania
Spreadsheet: 808618d1670535662-need-to-exclude-weekends-from-total-countif-formula-2022-annual-leave-tracker-sample
Sheet: Summary

 |  | Start Date: | 2022-01-01 00:00:00 | End Date: | 2022-12-31 00:00:00
 | EMP ID | EMP Name | Total V | Total LWP | Total SL | Total HD | Total ML | Total WH | Total UA | Grand Total
 |  |  | Vacation | Leave without Pay | [NAME] | Half Day Leave | Maternity Leave | Work From Home | Unexplained Absence | Total
 | EMP ID | EMP Name | V | LWP | SL | HD | ML | WH | UA | Column1
 | 10001 | test Person
 | 10002
 | 10003
 | 10004
 | 10005
 | 10006
 | 10007
 | 10008
 | 10009
 | 10010
 | 10011
 | 10012
 | 10013
 | 10014
 | 10015
 | 10016
 | 10017
 | 10018
 | 10019
 | 10020
 | 10021
 | 10022
 | 10023
 | 10024
 | 10025
 | 10026
 | 10027
 | 10028
 | 10029
 | 10030
 | 10031
 | 10032
 | 10033
 | 10034
 | 10035
Spreadsheet: 271127d1381834981-complicated-sum-sample
Sheet: Sheet1

 |  |  |  |  |  |  | Type:
 |  |  |  |  |  |  | Value
 |  |  |  |  |  |  | Shops
 |  | Product | id | date | whatever | Tesco | Asda | Sainsburys | Total
 |  | Milk
Entry 1 |  | Bread
 |  | Eggs
 |  | Total
 |  |  |  |  |  |  | Type:
 |  |  |  |  |  |  | Normal
 |  |  |  |  |  |  | Shops
 |  | Product | id | date | whatever | Tesco | Asda | Sainsburys | Total
 |  | Milk
Entry 2 |  | Bread
 |  | Eggs
 |  | Total
 |  |  |  |  |  |  | Type:
 |  |  |  |  |  |  | Luxury
 |  |  |  |  |  |  | Shops
 |  | Product | id | date | whatever | Tesco | Asda | Sainsburys | Total
 |  | Milk
Entry 3 |  | Bread
 |  | Eggs
 |  | Total
Entry X
Spreadsheet: 51924d1251495976-drag-fill-skipping-a-lot-of-rows-updated-psp-outreach-report-template-08-25-09-fs
Sheet: February

 |  | Week of 2/01 - 2/07 | Week of 2/08 - 2/14 | Week of 2/15 - 2/21 | Week of 2/22 - 2/28
School:
Previous Units:
Previous GPA:
GPA Trend:
[NAME]. GPA:
Class Standing:
Previously Full-Time:
Currently Full-Time:
Outreach Frequency:
Independence Status:
Program Standing:
School:
Previous Units:
Previous GPA:
GPA Trend:
[NAME]. GPA:
Class Standing:
Previously Full-Time:
Currently Full-Time:
Outreach Frequency:
Independence Status:
Program Standing:
Spreadsheet: 177f7263-51dd-45c7-8385-9519e50a6978
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
6915 | 28254 | Pavel | Yakimov | RUS | 91 | 00:10:11 | 00:00:47 | [NAME] | 00:00:00 | [NAME] | 1 | 00:47:34
6915 | 46520 | Alexey | [NAME] | RUS | 97 | 00:10:09 | 00:00:41 | 00:19:50 | 00:00:00 | 00:17:21 | 2 | 00:48:02
6915 | 18894 | Jarno | [NAME] | FIN | 98 | 00:10:09 | 00:00:56 | [NAME] | 00:00:00 | 00:17:48 | 3 | 00:49:44
6915 | 39285 | Davide | [NAME] | ITA | 94 | 00:10:33 | [NAME] | 00:21:19 | 00:00:00 | 00:17:57 | 4 | 00:50:40
6915 | 46521 | Vasiliy | Vinogradov | RUS | 95 | 00:10:52 | [NAME] | 00:22:10 | 00:00:00 | 00:15:54 | 5 | 00:51:41
6915 | 28248 | Christian | Kloser | USA | 92 | [NAME] | 00:01:09 | 00:18:55 | 00:00:00 | 00:22:09 | 6 | 00:54:44
Spreadsheet: 63636d1264531488-vba-max-statement-for-a-range-where-from-is-a-variable-book1
Sheet: Sheet1

 |  | [NAME] | Min | Value
 |  | 5.295767800767488 | 4.840337417969492 | 5.06805260936849 |  | 1
 |  | 5.196151039255487 | 4.10202378277452 | 4.649087411015003 |  | 1
 |  | 5.774826499222217 | 4.12700800181401 | 4.950917250518113 |  | 1
 |  | 5.63243540466225 | 4.183148559125215 | 4.907791981893732 |  | 0
 |  | 5.866200617605486 | 4.587795428582501 | 5.226998023093993 |  | 0
 |  | 5.226904634159444 | 4.300954481413213 | 4.763929557786328 |  | 0
 |  | 5.236585471474637 | 4.839378334837009 | 5.037981903155822 |  | 0
 |  | 5.328464164673508 | 4.671447599032907 | 4.999955881853207 |  | 1
 |  | 5.650729971357635 | 4.523928344849608 | 5.087329158103621 |  | 1
 |  | 5.943555707906071 | 4.695472338641133 | 5.319514023273602 |  | 1
 |  | 5.146750461917105 | 4.486016293115728 | 4.816383377516416 |  | 0
 |  | Counter moves from Row 17 up to Row 7
 |  | When Column G changes to 1 (G16) then set Variable = value in cell E16 i.e. (5.319514)
 |  | When Column G changes to 0 (G13) then calculate the [NAME] from the row reference of Variable (Row 16) to row 14
 |  | in others words max(C16:C14)
 |  | I can do the counter upwards, as well as setting the variable correctly
 |  | What I'm struggling with is to calculate the [NAME] over that range
Spreadsheet: 878897d1726221233-randomly-assign-peers-sample-floor-plan
Sheet: Real Plan

Floor plan | Session 1 |  |  | Session 2 |  |  | Session 3 |  |  | stored formula for B3 in case you do copy and paste as values only in B#:J10 (hide the content of this cell or delete it):  =XLOOKUP(MasterPlan!B3,Attendees!$D$2:$D$25,Attendees!$B$2:$B$25,"Whoops - unexpected error!!!",0)
 | Presenter | Peer 1 | Peer 2 | Presenter | Peer 1 | Peer 2 | Presenter | Peer 1 | Peer 2
Table 1
Table 2
Table 3
Table 4
Table 5
Table 6
Table 7
Table 8
Spreadsheet: 162051d1339701008-formula-for-finding-last-delivery-date-and-time-delivery-times
Sheet: Example

Time of event | Time of shipment | Answer I need
2012-06-03 19:00:00 |  | 2012-06-03 16:00:00
2012-06-04 08:00:00 |  | 2012-06-03 16:00:00
2012-06-04 12:00:00 |  | 2012-06-03 16:00:00
2012-06-04 19:00:00 |  | 2012-06-03 16:00:00
2012-06-04 19:00:00 |  | 2012-06-03 16:00:00
2012-06-05 08:00:00 |  | 2012-06-03 16:00:00
2012-06-05 12:00:00 |  | 2012-06-03 16:00:00
2012-06-05 19:00:00 |  | 2012-06-03 16:00:00
2012-06-05 19:00:00 |  | 2012-06-03 16:00:00
2012-06-06 08:00:00 |  | 2012-06-03 16:00:00
2012-06-06 12:00:00 |  | 2012-06-03 16:00:00
2012-06-06 19:00:00 |  | 2012-06-06 16:00:00
2012-06-06 19:00:00 |  | 2012-06-06 16:00:00
2012-06-07 08:00:00 |  | 2012-06-06 16:00:00
2012-06-07 08:00:00 |  | 2012-06-06 16:00:00
2012-06-07 08:00:00 |  | 2012-06-06 16:00:00
2012-06-07 12:00:00 |  | 2012-06-06 16:00:00
2012-06-07 19:00:00 |  | 2012-06-06 16:00:00
2012-06-07 19:00:00 |  | 2012-06-06 16:00:00
2012-06-08 08:00:00 |  | 2012-06-06 16:00:00
2012-06-08 12:00:00 |  | 2012-06-06 16:00:00
2012-06-08 19:00:00 |  | 2012-06-06 16:00:00
2012-06-08 19:00:00 |  | 2012-06-06 16:00:00
2012-06-08 21:00:00 |  | 2012-06-06 16:00:00
2012-06-09 08:00:00 |  | 2012-06-06 16:00:00
2012-06-09 12:00:00 |  | 2012-06-06 16:00:00
2012-06-09 12:00:00 |  | 2012-06-06 16:00:00
2012-06-09 19:00:00 |  | 2012-06-09 16:00:00
2012-06-10 08:00:00 |  | 2012-06-09 16:00:00
2012-06-10 09:00:00 |  | 2012-06-09 16:00:00
2012-06-10 12:00:00 |  | 2012-06-09 16:00:00
2012-06-10 19:00:00 |  | 2012-06-09 16:00:00
2012-06-11 08:00:00 |  | 2012-06-09 16:00:00
2012-06-11 12:00:00 |  | 2012-06-09 16:00:00
2012-06-11 12:00:00 |  | 2012-06-09 16:00:00
2012-06-11 19:00:00 |  | 2012-06-09 16:00:00
2012-06-11 19:00:00 |  | 2012-06-09 16:00:00
2012-06-12 08:00:00 |  | 2012-06-09 16:00:00
2012-06-12 08:00:00 |  | 2012-06-09 16:00:00
2012-06-12 12:00:00 |  | 2012-06-09 16:00:00
2012-06-12 19:00:00 |  | 2012-06-09 16:00:00
2012-06-12 19:00:00 |  | 2012-06-09 16:00:00
2012-06-13 08:00:00 |  | 2012-06-09 16:00:00
2012-06-13 08:00:00 |  | 2012-06-09 16:00:00
2012-06-13 08:00:00 |  | 2012-06-09 16:00:00
2012-06-13 12:00:00 |  | 2012-06-09 16:00:00
2012-06-13 12:00:00 |  | 2012-06-09 16:00:00
Spreadsheet: 2c3c4e83-2892-41b5-98aa-36540673f02a
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
 | 5368.0 International Trade in Goods and Services, Australia
 | TABLE 2. GOODS AND SERVICES, Summary: Original, Current prices
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
Balance on goods and services ; |  |  | Original | A2717903C | 1971-07-01 00:00:00 | 2013-10-01 00:00:00 | 508 | $ Millions | FLOW | Month | 1
Credits, Total goods and services ; |  |  | Original | A2717883F | 1971-07-01 00:00:00 | 2013-10-01 00:00:00 | 508 | $ Millions | FLOW | Month | 1
Credits, Total goods ; |  |  | Original | A2717881A | 1971-07-01 00:00:00 | 2013-10-01 00:00:00 | 508 | $ Millions | FLOW | Month | 1
Credits, Rural goods ; |  |  | Original | A2717884J | 1971-07-01 00:00:00 | 2013-10-01 00:00:00 | 508 | $ Millions | FLOW | Month | 1
Credits, Non-rural goods ; |  |  | Original | A2717931L | 1971-07-01 00:00:00 | 2013-10-01 00:00:00 | 508 | $ Millions | FLOW | Month | 1
Credits, Net exports of goods under merchanting ; |  |  | Original | A2718034F | 1971-07-01 00:00:00 | 2013-10-01 00:00:00 | 508 | $ Millions | FLOW | Month | 1
Credits, Non-monetary gold ; |  |  | Original | A2718037L | 1971-07-01 00:00:00 | 2013-10-01 00:00:00 | 508 | $ Millions | FLOW | Month | 1
Credits, Total services ; |  |  | Original | A2718332C | 1971-07-01 00:00:00 | 2013-10-01 00:00:00 | 508 | $ Millions | FLOW | Month | 1
Debits, Total goods and services ; |  |  | Original | A2717891F | 1971-07-01 00:00:00 | 2013-10-01 00:00:00 | 508 | $ Millions | FLOW | Month | 1
Debits, Total goods ; |  |  | Original | A2718054R | 1971-07-01 00:00:00 | 2013-10-01 00:00:00 | 508 | $ Millions | FLOW | Month | 1
Debits, Consumption goods ; |  |  | Original | A2718056V | 1971-07-01 00:00:00 | 2013-10-01 00:00:00 | 508 | $ Millions | FLOW | Month | 1
Debits, Capital goods ; |  |  | Original | A2718126R | 1971-07-01 00:00:00 | 2013-10-01 00:00:00 | 508 | $ Millions | FLOW | Month | 1
Debits, Intermediate and other merchandise goods ; |  |  | Original | A2718182J | 1971-07-01 00:00:00 | 2013-10-01 00:00:00 | 508 | $ Millions | FLOW | Month | 1
Debits, Non-monetary gold ; |  |  | Original | A2718320V | 1971-07-01 00:00:00 | 2013-10-01 00:00:00 | 508 | $ Millions | FLOW | Month | 1
Debits, Total services ; |  |  | Original | A2718454A | 1971-07-01 00:00:00 | 2013-10-01 00:00:00 | 508 | $ Millions | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 784342d1655650463-total-days-per-month-help
Sheet: Sheet1

No | ID | Name | Date From | Date To | Days |  | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
1 | 112 | Mr [NAME] | 2022-01-09 00:00:00 | 2022-02-05 00:00:00 |  |  | 22 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | 548 | Mr Beta | 2022-03-15 00:00:00 | 2022-04-10 00:00:00 |  |  | 0 | 0 | 16 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 | 447 | Miss [NAME] | 2022-04-25 00:00:00 | 2022-05-15 00:00:00 |  |  | 0 | 0 | 0 | 5 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 | 548 | Miss Delta | 2022-06-29 00:00:00 | 2022-08-18 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 31 | 18 | 0 | 0 | 0 | 0
Spreadsheet: 122932d1317244243-automatically-getting-the-comment-box-to-appear-when-data-is-entered-temp
Sheet: July

Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
27 |  | 28 |  | 29 |  | 30 |  | 1 |  | 2 |  | 3
4 | Independence Day | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10
11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17
18 |  | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24
25 |  | 26 |  | 27 |  | 28 |  | 29 |  | 30 |  | 31