tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 117619d1312913332-looking-for-a-formula-for-a-template-to-pull-data-under-specific-criteria-example
Sheet: Sheet1

Number that needs to be pulled | Estimate Date | Actual Date | Difference in days
100 | 2011-05-01 00:00:00 | 2011-05-07 00:00:00
200 | 2011-06-21 00:00:00 | 2011-06-30 00:00:00
150 | 2011-06-30 00:00:00 | 2011-07-03 00:00:00
120 | 2011-07-01 00:00:00 | 2011-07-03 00:00:00
Spreadsheet: 163298d1340270285-re-allocation-of-percentage-allocation_percentage
Sheet: Sheet1

Product | Region | Units Today | Units Yesterday | Sum% | Flag | Current Allocation % | Preferred Allocation
Product A | LUXEMBOURG | 2000000 | 1500000 |  |  |  | 0.5405405405405406
Product A | NETHERLANDS | 1200000 | 1000000 |  |  |  | 0.3243243243243243
Product A | UNITED KINGDOM | 500000 | 450000 |  |  |  | 0.1351351351351351
Product A | SWITZERLAND | 200000 | 0 |  |  |  | 1
Product B | LUXEMBOURG | 1000000 | 1500000 |  |  |  | 0.08
Product B | NETHERLANDS | 9000000 | 1000000 |  |  |  | 0.72
Product B | UNITED KINGDOM | 2500000 | 450000 |  |  |  | 0.2
Product B | USD | 8000000 | 0 |  |  |  | 1
Spreadsheet: 837294d1690005579-filter-with-multiple-conditions-filter-multiple-table-conditions-hd-windknife
Sheet: data

PROD_CODE | PROD TYPE | SALES |  |  | PROD_CODE | SALES |  | Windknife |  |  |  | HD
AAA | [NAME] | 100 |  |  | BBB | 200 |  |  | SALES |  |  |  | SALES
BBB | Apple | 200 |  |  | CCC | 300 |  | AAA | 100 |  |  | BBB | 200
CCC | Apple | 300 |  |  | FFF | 600 |  | BBB | 200 |  |  | CCC | 300
DDD | Dairy | 400 |  |  | HHH | 800 |  | CCC | 300 |  |  | FFF | 600
EEE | Eggs | 500 |  |  | III | 900 |  | FFF | 600 |  |  | HHH | 800
FFF | Fruit | 600 |  |  | KKK | 1100 |  | HHH | 800 |  |  | III | 900
GGG | Apple | 700 |  |  | LLL | 1200 |  | III | 900 |  |  | KKK | 1100
HHH | [NAME] | 800 |  |  |  |  |  | KKK | 1100 |  |  | LLL | 1200
III | Carrot | 900 |  |  |  |  |  | LLL | 1200
JJJ | Dairy | 1000
KKK | Carrot | 1100
LLL | Fruit | 1200
Spreadsheet: 844113d1695905592-i-need-to-create-a-lookup-table-for-an-rdp-for-scuba-diving-logbook_test
Sheet: Logbook

Dive Nr. | Date (place) | Depth | Dive time | Time in | Time out | Temp | Air in | Air out | Tank size |  | Air cons. | PG in | PG out
251 | 2023-04-01 00:00:00 | 11.5 | 58 | 10:52:00 |  |  | 189 | 92 | 12 |  |  |  | F
252 | 2023-04-01 00:00:00 | 16 | 20 | 12:00:00 |  |  | 200 | 110 | 12
253 | 2023-04-01 00:00:00 | 12.4 | 34 | 13:00:00 |  |  | 189 | 80 | 12
254 | 2023-04-01 00:00:00 | 18.6 | 62 | 14:30:00
255 | 2023-04-02 00:00:00 | 20.4 | 63 | 13:07:00
256 | 2023-04-23 00:00:00 | 8.2 | 64 | 10:53:00
257 | 2023-04-23 00:00:00 | 7.7 | 47 | 12:39:00
258 | 2023-07-06 00:00:00 | 11.3 | 59 | 12:39:00
259 | 2023-07-06 00:00:00 | 9.45 | 62 | 18:58:00
260 | 2023-07-07 00:00:00 | 10.6 | 43 | 10:52:00
261 | 2023-07-07 00:00:00 | 9.2 | 47 | 12:53:00
Spreadsheet: 139608d1328330961-converting-weekly-rankings-into-monthly-rankings-excelq
Sheet: Sheet1

I have been struggling to convert an array of weekly data rankings into monthly rankings using the closest date to month end and cant seem to find a way. see below
these are a series of stock price performance rankings currently weekly. i want to take the weekly close ranking closest to the end of the month and convert them to a monthly format. ie the weekly numbers that are boxed would be inserted into the right hand column. so for example on the 28 october on the left hand table - that is the closest date to the end of october so take the data into the right hand side as the month end data ranks 1,3,2 aross the data. hope you can help with a formula. if too hard for the closest date to month end the first after month end would be ok . many thanks
 |  | spx index | spgsci Index | ief us equity |  |  | spx index | spgsci Index | ief us equity
 | 2012-01-24 00:00:00 | 1 | 2 | 4 |  | 2011-12-31 00:00:00 | 1 | 4 | 3
 | 2012-01-20 00:00:00 | 1 | 3 | 4 |  | 2011-11-30 00:00:00 | 1 | 3 | 2
 | 2012-01-13 00:00:00 | 1 | 3 | 4 |  | 2011-10-31 00:00:00 | 1 | 3 | 2
 | 2012-01-06 00:00:00 | 1 | 3 | 4
 | 2011-12-30 00:00:00 | 1 | 4 | 3
 | 2011-12-23 00:00:00 | 1 | 4 | 3
 | 2011-12-16 00:00:00 | 1 | 4 | 2
 | 2011-12-09 00:00:00 | 1 | 3 | 2 |  | how do I convert them to a monthly rank
 | 2011-12-02 00:00:00 | 1 | 3 | 2 |  | using the closest to month end date
 | 2011-11-25 00:00:00 | 1 | 3 | 2
 | 2011-11-18 00:00:00 | 1 | 3 | 2
 | 2011-11-11 00:00:00 | 1 | 3 | 2
 | 2011-11-04 00:00:00 | 1 | 3 | 2
 | 2011-10-28 00:00:00 | 1 | 3 | 2
 | 2011-10-21 00:00:00 | 1 | 3 | 2
Spreadsheet: 177262d1346245895-cell-data-dependant-on-inputted-info-table
Sheet: Sheet1

Technology Change
 | Technical Inventiveness | Technological Penetration | Answer in this column |  | KEY
 |  |  |  |  | Technical Inventiveness | H | 3 | 6 | 9
 |  |  |  |  |  | M | 2 | 4 | 6
 |  |  |  |  |  | L | 1 | 2 | 3
 |  |  |  |  |  |  | L | M | H
 |  |  |  |  |  |  | Technological Penetration
Spreadsheet: andrea_ring__46__BRLH Storage
Sheet: nov01

NOVEMBER '01 STORAGE ACTIVITY
 | ENA
Contract | 96034600
[NAME] | 85000
[NAME] | 150000
[NAME] | 2500000
Day | Injection | Withdrawal
2001-11-01 00:00:00 | 85000
2001-11-02 00:00:00 | 85000
2001-11-03 00:00:00 | 67197
2001-11-04 00:00:00 | 58825
2001-11-05 00:00:00 | 67197
2001-11-06 00:00:00 | 8290
2001-11-07 00:00:00
2001-11-08 00:00:00 |  | -28649
2001-11-09 00:00:00 | 28732
2001-11-10 00:00:00 | 85
2001-11-11 00:00:00 | 85
2001-11-12 00:00:00 | 85
2001-11-13 00:00:00
2001-11-14 00:00:00 |  | -15201
2001-11-15 00:00:00 | 15390
2001-11-16 00:00:00
2001-11-17 00:00:00 |  | -25886
2001-11-18 00:00:00 |  | -25886
2001-11-19 00:00:00 |  | -25886
2001-11-20 00:00:00 |  | -145307
2001-11-21 00:00:00 | 44791
2001-11-22 00:00:00 | 36085
2001-11-23 00:00:00 | 36085
2001-11-24 00:00:00 | 33085
2001-11-25 00:00:00 | 36282
2001-11-26 00:00:00 | 36282
2001-11-27 00:00:00 | 2607
2001-11-28 00:00:00 |  | -5956
2001-11-29 00:00:00 |  | -27184
2001-11-30 00:00:00 |  | -235261
Current Month
Fuel 1%
Current Month Activity
Previous Month Bal | 2132123
[NAME]
Available Capacity
Spreadsheet: 50094d1249488853-intersection-of-a-cell-sample-int
Sheet: Sheet1

 | Orange | Red | Blue | Yellow | Green |  | Name | Codes
AA |  |  |  | Jon |  |  | [NAME]
BB | [NAME] |  |  |  |  |  | Jon
CC | [NAME] | [NAME] |  |  | [NAME] |  | [NAME]
DD |  |  | [NAME] |  |  |  | [NAME]
EE | [NAME] |  |  |  |  |  | Sue
FF |  |  |  | Gert | [NAME] |  | Gert
GG | Sue |  |  |  |  |  | [NAME]
HH |  | [NAME] |  |  |  |  | [NAME]
II |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Press Alt-F8 and run the macro.
Spreadsheet: john_griffith__15558__Volume Schedule - EnerVest
Sheet: Sheet1

TOTAL MONTHLY VOLUMES
Gas | 2001
January | 129890
February | 117320
March | 129890
April | 125700
May | 129890
June | 125700
July | 129890
August | 129890
September | 125700
October | 129890
November | 125700
December | 129890
 | 2002
January | 128588
February | 116144
March | 128588
April | 124440
May | 128588
June | 124440
July | 128588
August | 128588
September | 124440
October | 128588
November | 124440
December | 128588
 | 2003
January | 111011
February | 100268
March | 111011
April | 107430
May | 111011
June | 107430
July | 111011
August | 111011
September | 107430
October | 111011
November | 107430
December | 111011
 | 2004
January | 96379
February | 90161
March | 96379
April | 93270
May | 96379
June | 93270
July | 96379
August | 96379
September | 93270
October | 96379
November | 93270
December | 96379
 | 2005
January | 84692
February | 76496
March | 84692
April | 81960
May | 84692
June | 81960
July | 84692
August | 84692
September | 81960
October | 84692
November | 81960
December | 84692
 | 2006
January | 74462
February | 67256
March | 74462
April | 72060
May | 74462
June | 72060
July | 74462
August | 74462
September | 72060
October | 74462
November | 72060
December | 74462
 | 2007
January | 65720
February | 59360
March | 65720
April | 63600
May | 65720
June | 63600
July | 65720
August | 65720
September | 63600
October | 65720
November | 63600
December | 65720
 | 2008
January | 58063
February | 54317
March | 58063
April | 56190
May | 58063
June | 56190
July | 58063
August | 58063
September | 56190
October | 58063
November | 56190
December | 58063
 | 2009
January | 51708
February | 46704
March | 51708
April | 50040
May | 51708
June | 50040
July | 51708
August | 51708
September | 50040
October | 51708
November | 50040
December | 51708
 | 2010
January | 46097
February | 41636
March | 46097
April | 44610
May | 46097
June | 44610
July | 46097
August | 46097
September | 44610
October | 46097
November | 44610
December | 46097
Spreadsheet: 2d1077de-fc10-470c-a55e-c0a5342745ec
Sheet: October

FEDERAL COLLEGE WORK-STUDY PROGRAM
 | MASTER SHEET FOR STUDENT WORK HOURS
NAME |  |  |  |  |  |  |  | ASU ID #
PAY PERIOD BEGINNING |  |  | 2012-10-01 00:00:00 |  |  |  |  | PAY PERIOD ENDING |  |  | 2012-10-31 00:00:00
HOURLY RATE |  |  | 7.25 |  | TOTAL Hours |  |  |  |  | DEPARTMENT
TIME
WORKED | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
IN
OUT
IN
OUT
IN
OUT
TOTAL
TIME
WORKED | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
IN
OUT
IN
OUT
IN
OUT
TOTAL
Student's Signature
[NAME]'s (Print Name) |  |  |  |  |  |  |  |  | [NAME]'s Signature
Department Head's  (Print Name) |  |  |  |  |  |  |  |  | Department Head's Signature
Note:  This Master [NAME] should reflect the time and hours the student actually worked.  The total hours per day should reflect in the total column.
Students are not authorized to work no more than 20 hours per week.  No EXCEPTIONS!!!
Spreadsheet: 10a8ecc9-ba36-471d-b5da-b63b05c46b1b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | SAMPLE IDENTIFICATION | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | IMPORTANT: SAVE THIS FILE FIRST, UNDER A NEW NAME, BEFORE MAKE ANY CHANGES | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  | Sample Name: |  |  |  |  |  |  |  |  |  | Yellow cells are essential for analysis. Fill out (with numbers) as asked.
 |  | Sample ID: |  |  |  |  |  |  |  |  |  | Fill out the green cells with 1 for Yes and 0 for No.
 |  | Date:
 |  | File ID: |  |  |  |  |  |  |  |  |  |  |  | 0
GRAIN SIZE ANALYSIS
PROCEDURE | Sieving |  |  |  | Laser
 |  |  |  |  |  |  |  |  |  |  | apagar
 |  |  |  |  |  |  |  |  |  |  | apagar
 | Finer sieve diameter ([NAME])? |  | 0.03125 | 0 | Comments:
 |  |  | 0.0625 | 1
 |  |  | 0.125 | 0
 |  |  | 0.25 | 0
 |  |  | 0.5 | 0
 |  |  | 1 | 0
 |  |  | 2 | 0
SAMPLE | Inicial Weight (g)
 | Weight of fractions (g):
 | finer than | 0.063 |  | 0.063
 | [NAME] | 0.063 |  | 0.063
 | Total Weight for analysys (g) |  | 0
 | Legend:
 |  | Fill out the yellow cells with numbers.
 |  | Fill out the green form with 1 for Yes and 0 for No.
 |  | * No separation of finer fractions was done in this analysis.
Spreadsheet: 870804d1717239728-need-formula-for-countif-within-cell-charaters-book1
Sheet: Sheet2

pp
333.555.8.9
333.555.8.9
333.555.8.9
333.555.255.9
333.555.9.9
333.555.17.9
333.555.16.9
333.555.39.21
333.555.31.34
333.555.27.21
333.555.31.9
333.555.29.24
333.555.26.9
333.555.41.21
333.555.14.21
333.555.13.41
333.555.23.37
333.555.11.9
333.555.8.22
333.555.6.9
333.555.40.22
333.555.35.22
333.555.19.20
333.555.44.21
333.555.7.20
333.555.45.21
333.555.18.23
333.555.3.9
10.35.65.99
10.35.65.33
Spreadsheet: 99770d1298346431-formula-copy-with-date-and-cell-selection-example
Sheet: Sheet2

 |  |  | JUN | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00
 |  | On Hand
 |  | Forecast
 |  | CusOrd
 |  | ShpgNt
 |  | Supply Firm
 |  | [NAME]
 |  | End Inv
 |  | MOI
Spreadsheet: 885935d1735857445-a-tiny-help-fixing-a-formula-book1
Sheet: 10A (1)

 |  | HW1 | HW2 | HW3 | IP Chapter 1 | VALORES | [NAME] | EXAMEN FINAL | NOTA FINAL |  | [NAME]
# | NOMBRE DEL ESTUDIANTE | 7 | 7 | 8 | 10 | 10 |  | 0.35 | 1
 |  | 7 | 6 | 0 | 0 | 0 |  | 14
 |  | 5 | 0 | 0 | 0 | 0 |  | 12
 |  | 7 | 6 | 0 | 0 | 0 |  | 35
 |  | 6 | 6 | 0 | 0 | 0 |  | 38
 |  | 5 | 5 | 5 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 92722d1292277321-sumif-sumif-example
Sheet: Sheet1

Week No | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4
DOW | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Values | 1 | 3 | 5 | 7 | 9 | 11 | 13 | 15 | 17 | 19 | 2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 3 | 5 | 7 | 9 | 11 | 13 | 15 | 17
Key | 1-ok | 1-ok | 1-ok | 1-ok | 1-ok | 1-X | 1-X | 2-ok | 2-ok | 2-ok | 2-ok | 2-ok | 2-X | 2-X | 3-ok | 3-ok | 3-ok | 3-ok | 3-ok | 3-X | 3-X | 4-ok | 4-ok | 4-ok | 4-ok | 4-ok | 4-X | 4-X
Week
1 | 25
2 | 57
3 | 70
4 | 45
Spreadsheet: 684926d1593617691-formula-that-sorts-type-of-data-and-outputs-most-recent-data-pq-example-a-aligw
Sheet: Sheet1

 | List of Data |  |  |  | Output Wanted
 | Date | Name | Type |  | 5 Most Recent Type A Dates and Names
 |  | 1 | A |  | Top 5 | Date | Name | Type
 |  |  | C |  | 1 | formula that sorts through data by type and grabs the most recent dates
 |  |  | C |  | 2
 |  |  | A |  | 3
 |  |  | C |  | 4
 |  |  | C |  | 5
 |  |  | D
 |  |  | A
 |  |  | B
 |  |  | C |  |  |  | Should look like the table below
 |  |  | B
 |  |  | D
 |  |  | D |  | 5 Most Recent Type A Dates and Names |  |  |  |  |  | Index | Date | Name | Type
 |  |  | B |  | Top 5 | Date | Name | Type |  |  | 1 | 2018-09-30 00:00:00 | 1 | A
 |  |  | C |  | 1 | 2018-09-30 00:00:00 | 1 | A |  |  | 2 | 2018-03-31 00:00:00 | 4 | A
 |  |  | A |  | 2 | 2018-03-31 00:00:00 | 4 | A |  |  | 3 | 2017-07-31 00:00:00 | 8 | A
 |  |  | A |  | 3 | 2017-07-31 00:00:00 | 8 | A |  |  | 4 | 2016-03-31 00:00:00 | 16 | A
 |  |  | A |  | 4 | 2016-03-31 00:00:00 | 16 | A |  |  | 5 | 2016-01-31 00:00:00 | 17 | A
 |  |  | A |  | 5 | 2016-01-31 00:00:00 | 17 | A
 |  |  | C
 |  |  | C
 |  |  | B
 | 2015-01-05 00:00:00 |  | B
Spreadsheet: f78220c4-659e-4a3e-9778-6268c7563e76
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
ROTATIONAL CAPACITY TESTS
 |  |  | TENSION | TORQUE | NOTES: | [NAME]. [NAME] and 504.52
LOT # | BOLT DIA. | LENGTH | READING | READING | RCT - test 2 bolt assemblies; TOTN - test 3 assemblies.
 | inches(mm) | inches | lbs. | ft-lbs. | BOLT DIAMETER =  _________ inches.
 |  |  |  |  | SNUG TIGHT TENSION =__________ lbs.
 |  |  |  |  |  |  | [=10%  of Installation Tension (Table 1)]
 |  |  |  |  | MAXIMUM TORQUE = __________ ft-lbs. |  |  |  | (<= 0.25PD)
 |  |  |  |  | P = Measured [NAME]; D = Nominal Bolt Diameter
 |  |  |  |  | STEPS:  RCT - use skidmore and torque wrench.
 |  |  |  |  | 1.  snug tight to :  __________ lbs.
 |  |  |  |  | 2.  [NAME], then bring T to __________lbs (Table 1).  Record T &
 |  |  |  |  | Torque.  Check maximum Torque. If exceeds, relubricate fasteners.
 |  |  |  |  | 3.  continue rotation to total of _______turn (Table 1A).
 |  |  |  |  | 4.  record tension (should be >= ________ lb. -- Table  1).
 |  |  |  |  | 5.  check bolts for failure.
 |  |  |  |  | STEPS:  TURN-OF-THE-NUT  - use skidmore and work wrench.
 |  |  |  |  | 1.  snug tight to _________ lbs.
 |  |  |  |  | 2.  mark socket.
 |  |  |  |  | 3.  ______ turn (Table 6)  >= __________ lbs.
 |  |  |  |  |  |  | (105% of the Installation Tension (Table 1))
 |  |  |  |  | TOTAL  ROTATION: |  | Up to 4 dia = 2/3 turn
 |  |  |  |  | (Table 1A) |  | 4 to 8 dia = 1 turn
 |  |  |  |  |  |  | over 8 dia = 1-1/3 turn
 |  |  |  |  | TOTN NUT ROTATION: |  | up to 4 dia. = 1/3 turn
 |  |  |  |  | (Table 6) |  | 4 to 8 dia. = 1/2 turn
 |  |  |  |  |  |  | 8 to 12 dia. = 2/3 turn
Spreadsheet: phillip_m_love__30144__200004_OA
Sheet: TX-HPLC-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  [NAME]
 |  |  | 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 | 41600744 | 118839192
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 2005770 | 5931185
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 43606514 | 124770377
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -51185833 | -144285396
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -3062241 | -8861482
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 6234 | 18409
 | Total Purchases: |  | -54241840 | -153128469
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 85015783 | 251774010
12 |  | Purchases | -83791898 | -248193272
 | Total Intra CTS Sales / Purchases |  | 1223885 | 3580738
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 0 | 0
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 7402404 | 21798946
18 |  | W/D (Purchase from Stg) | -3491666 | -10124514
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -3491666 | -10124514
 | Total Storage: |  | 3910738 | 11674432
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | 5500703 | 15576037.28197768
 |  |  | 0 | 0
23 | Fuel: |  | 0 | 0
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -1951063
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -1951063
 |  |  | 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 | 0
31 |  | Prior Month Book Balance | 0 | 0
 |  | Total MTM Income | 0 | 0
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 0
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | -98300
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 0
 |  | TOTAL INTRA-MTH
Spreadsheet: 702501d1604394363-check-and-replace-value-by-group-status-derivation
Sheet: Status Derivation

Source Data
Project | Users | Status Rank | Project Status | [NAME] | StatusConflictCheck | Sort Master
[NAME] | [NAME] |  |  | 9. Unknown | False | [NAME]. Unknown
[NAME] | [NAME] |  |  | 9. Unknown | False | [NAME]. Unknown
[NAME] | Saffron | 1 | Decommission | 1. Decommission | False | [NAME]. Decommission
[NAME] | Saffron | 1 | Confirmed | 1. Confirmed | False | [NAME]. Confirmed
[NAME] | Saffron |  |  | 9. Unknown | False | [NAME]. Unknown
[NAME] | Saffron |  |  | 9. Unknown | False | [NAME]. Unknown
[NAME] | Saffron |  |  | 9. Unknown | False | [NAME]. Unknown
[NAME] | Saffron |  |  | 9. Unknown | False | [NAME]. Unknown
[NAME] | Saffron |  |  | 9. Unknown | False | [NAME]. Unknown
[NAME] | Saffron |  |  | 9. Unknown | False | [NAME]. Unknown
[NAME] | Saffron |  |  | 9. Unknown | False | [NAME]. Unknown
[NAME] | Saffron |  |  | 9. Unknown | False | [NAME]. Unknown
[NAME] | Saffron |  |  | 9. Unknown | False | [NAME]. Unknown
[NAME] | [NAME] | 1 | Confirmed | 1. Confirmed | False | [NAME]. Confirmed
[NAME] | [NAME] | 4 | Referred | 4. Referred | False | [NAME]. Referred
NON RESTRICTED//FOLDER-FOUR//PHOTON | Tara | 9 | Unknown | 9. Unknown | False | [NAME]. Unknown
NON RESTRICTED//FOLDER-FOUR//PHOTON | Tara | 9 | Unknown | 9. Unknown | False | [NAME]. Unknown
NON RESTRICTED//FOLDER-FOUR//PHOTON | Tara | 9 | Unknown | 9. Unknown | False | [NAME]. Unknown
[NAME] | Tara | 1 | Decommission | 1. Decommission | False | [NAME]. Decommission
[NAME] | Tara |  |  | 9. Unknown | False | [NAME]. Unknown
Target Data
Project | Status
[NAME] | Unknown
[NAME] | Conflict
[NAME] | Confirmed
NON RESTRICTED//FOLDER-FOUR//PHOTON | Unknown
[NAME] | Decommission
Spreadsheet: 841721d1693900586-listing-staff-and-roles-according-to-table-staff-operations-excel-test
Sheet: Staff Site Allocate

 | BRAND PARTNER DEMO | CATALINA BAY | CATALINA BAY CU | CINTRA | IMPERIAL GARDENS | NATONAL MINI | QUEEN STREET | SPENCER | STARBUCKS | STUDIO ONE | SUMMIT | T BUILD | UNITEC | VICTORIA AVE | WESTWOOD
[NAME]
Leading Hand
[NAME]
# of Staff on this site
Spreadsheet: 00308d3f-06e1-4fb7-ac06-6afd21e49a9b
Sheet: Sheet1

New Basin (9-) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  |  |  | 42
Spreadsheet: 146735d1332334676-how-do-i-create-one-pivot-table-from-multiple-tables-of-data-book2test
Sheet: Good

Employee | Dept | Date | Status
Hull, [NAME] | Shipping | 2012-02-19 06:27:12 | Good
Hull, [NAME] | Shipping | 2012-02-09 17:14:42 | Good
[NAME], Curtis | Receiving | 2012-02-09 21:04:02 | Good
[NAME], Curtis | Receiving | 2012-01-30 08:44:55 | Good
Smith, Ozzie | Management | 2012-02-18 23:47:39 | Good
Smith, Ozzie | Management | 2012-02-19 02:16:38 | Good
Smith, Ozzie | Management | 2012-02-08 18:36:53 | Good
Spreadsheet: 864928d1712065310-sumifs-indirect-name-error-excel_issue-1-aligw
Sheet: Data

 | target |  |  |  |  |  | No. of Parts Delivered | No. of Parts Delivered | % OTD | Head Count | New Starters | Leavers | Leavers within Probation | 2023 Rolling Staff Turnover | Hours Lost Through Sickness | Sickness Absence % | Sick Days | Monday's Taken as Sickness
0.6 |  | 2023-01-01 00:00:00
0.625
Spreadsheet: 793332d1661418630-apply-formula-based-on-blank-and-non-blank-cells-excel-forum-25-august-ans
Sheet: Sheet1

Number | [NAME] | Discount Code | [NAME] to be displayed here | FORMULA
#28800 | [EMAIL] | michelsawma78 | 0
#28800 | [EMAIL] |  | 0
#28800 | [EMAIL] |  | 0
#28800 | [EMAIL] |  | 0
#28800 | [EMAIL] |  | 0
#28800 | [EMAIL] |  | 0
#28800 | [EMAIL] |  | 0
#29185 |  |  | 0
#29184 |  | MahmoudFree | 0
#29183 |  | souadmarket71 | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29181 | [EMAIL] |  | 1
#29181 | [EMAIL] |  | 1
#29181 | [EMAIL] |  | 1
#29181 | [EMAIL] |  | 1
#29181 | [EMAIL] |  | 1
#29181 | [EMAIL] |  | 1
#29181 | [EMAIL] |  | 1
#29180 |  |  | 0 |  |  | How this is 0
#29180 |  |  | 0
#29180 |  |  | 0
#29180 |  |  | 0
#29180 |  |  | 0
#29180 |  |  | 0
#29180 |  |  | 0
#29180 |  |  | 0
#29180 |  |  | 0
#29180 |  |  | 0
#29180 |  |  | 0
#29179 | [EMAIL] |  | 1
#29179 | [EMAIL] |  | 1
#29179 | [EMAIL] |  | 1
#29178 |  | harfouchtrading50 | 0
#29178 |  |  | 0
#29178 |  |  | 0
#28799 | [EMAIL] |  | 1
#28798 |  |  | 0
#28797 |  |  | 0
#28796 |  |  | 0
#28607 |  | Sponsor101 | 0
#28606 |  | WF30 | 0
#28605 |  | hadad71 | 0
Spreadsheet: 738584d1625135217-removing-spill-and-then-n-a-from-the-range-excel-help
Sheet: Sheet1

apple | 10 |  |  | apple
orange | 5 |  |  | orange | #N/A
plum | 20 |  |  | plum | #N/A
apple | 10 |  |  |  | 10
orange | 5 |  |  |  | #N/A
plum | 20 |  |  |  | #N/A
apple | 10 |  |  |  | 10
orange | 5 |  |  |  | #N/A
plum | 20 |  |  |  | #N/A