tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 93097d1292600486-report-on-data-example
Sheet: 30

First | Last | Number | Manager | Sent | Response
DON | WAGNER | 55463 | Rogers, [NAME] | 2010-01-14 00:00:00 | No Response
Jon | DOE | 23358 | Simmons, [NAME] | 2010-01-14 00:00:00 | No Response
[NAME] | [NAME] | 83744 | Simmons, [NAME] | 2010-01-14 00:00:00 | Approved
DON | WAGNER | 22912 | Cooper, [NAME] | 2010-02-01 00:00:00 | No Response
BOB | HIRSCH | 38301 | Rocker, [NAME] | 2010-02-01 00:00:00 | Terminated
[NAME] | Rogers | 21099 | Cooper, [NAME] | 2010-02-01 00:00:00 | Terminated
Spreadsheet: 752235d1634659752-vlookup-stops-working-after-several-rows-po-workbook
Sheet: Tab 2

Owner CO# | INVOICE DATE | PO# | VENDOR | INVOICE# | TAXABLE AMT | NON TAXABLE | INV AMOUNT | CONTRACTOR | Notes | [NAME]
 |  | 3413 |  | Org | 432784.6
 |  | 3413 |  | CO1 | 9337
 |  | 3506 |  | Org | 13647
 |  | 3507 |  | Org | 29055
 |  | 3547 |  | Org | 74873
 |  | 3531 |  | Org | 2600
 |  | 3532 |  | Org | 17109.41
Spreadsheet: 746204d1630575159-automatically-work-out-percentage-increase-to-balance-figure-handicap-suggestion
Sheet: Sheet2

36 |  | hcap |  | pts |  | Winners Cut | [NAME] | Total Cut | [NAME] | New Exact H'Cap | Play H'Cap |  |  |  | Percentage
[NAME] | 20.3 | 20 |  | 41 |  |  |  |  |  |  |  | Cat 1 | 0 to 9 | 0.1 | 1.55
[NAME] | 13.1 | 13 |  | 40 |  |  |  |  |  |  |  | Cat 2 | 10 to 19 | 0.2
[NAME] | 28.1 | 28 |  | 38 |  |  |  |  |  |  |  | Cat 3 | 20 to 29 | 0.3
[NAME] | 25.8 | 26 |  | 37 |  |  |  |  |  |  |  | Cat 4 | 30 & over | 0.4
[NAME] | 5.2 | 5 |  | 37
[NAME] | 17.7 | 18 |  | 36
[NAME] | 14.9 | 15 |  | 35
[NAME] | 9.8 | 10 |  | 35
[NAME] | 9.1 | 9 |  | 34
[NAME] | 30.9 | 31 |  | 33
[NAME] | 19 | 19 |  | 33
[NAME] | 10.6 | 11 |  | 33
[NAME] | 20 | 20 |  | 31
[NAME] | 29.4 | 29 |  | 31
[NAME] | 24.2 | 24 |  | 31
[NAME] | 16.1 | 16 |  | 30
[NAME] | 21.4 | 21 |  | 30
[NAME] | 16.6 | 17 |  | 30
[NAME] | 28 | 28 |  | 29
[NAME] | 7.2 | 7 |  | 29
[NAME] | 23 | 23 |  | 29
[NAME] | 14.1 | 14 |  | 29
[NAME] | 16.9 | 17 |  | 28
[NAME] | 12.3 | 12 |  | 27
[NAME] | 34.8 | 35 |  | 27
[NAME] | 11.6 | 12 |  | 27
[NAME] | 10.6 | 11 |  | 26
[NAME] | 19.6 | 20 |  | 25
[NAME] | 11.7 | 12 |  | 24
[NAME] | 10.6 | 11 |  | 24
[NAME] | 20.5 | 21 |  | 22
[NAME] | 16 | 16 |  | 21
Spreadsheet: 732138d1620793166-reorganizing-table-parsing-text-file-based-convert-column-data-to-row-data-aldowski-
Sheet: Sheet1

Original Data | Helper 1 | Helper 2 |  | Output
Row: First |  |  |  |  |  |  |  | [NAME]: One |  |  | [NAME]: One
[NAME]: One |  |  |  |  |  |  | Row: First | [NAME]: Two |  | Row: First | [NAME]: Two
[NAME]: Two |  |  |  |  |  |  | Row: First | [NAME]: Three |  | Row: First | [NAME]: Three
[NAME]: Three |  |  |  |  |  |  | Row: Second | [NAME]: One |  | Row: Second | [NAME]: One
Row: Second |  |  |  |  |  |  | Row: Second | [NAME]: Two |  | Row: Second | [NAME]: Two
[NAME]: One |  |  |  |  |  |  | Row: Third | [NAME]: One |  | Row: Third | [NAME]: One
[NAME]: Two |  |  |  |  |  |  | Row: Third | [NAME]: Two |  | Row: Third | [NAME]: Two
Row: Third |  |  |  |  |  |  | Row: Third | [NAME]: Three |  | Row: Third | [NAME]: Three
[NAME]: One |  |  |  |  |  |  | Row: Third | [NAME]: Four |  | Row: Third | [NAME]: Four
[NAME]: Two |  |  |  |  |  |  | Row: Fourth | [NAME]: One |  | Row: Fourth | [NAME]: One
[NAME]: Three |  |  |  |  |  |  | Row: Fifth | [NAME]: One |  | Row: Fifth | [NAME]: One
[NAME]: Four |  |  |  |  |  |  | Row: Fifth | [NAME]: Two |  | Row: Fifth | [NAME]: Two
Row: Fourth
[NAME]: One
Row: Fifth
[NAME]: One
[NAME]: Two
Spreadsheet: 54218d1254240871-solution-for-vlookup-on-different-data-sheets-solution
Sheet: B

[NAME] | RegionCode | Rates
-------------------------------------------------- | ---------------------------- | -----------
USA Alaska | 907 | 0.029
United Kingdom | 44 | 0.265
South Africa | 27 | 0.2448
Albania | 355 | 0.369
Algera | 213 | 0.7896
Spreadsheet: 730816d1619966200-expand-a-formula-to-other-cells-given-the-complexity-of-the-formula-a-bit-tricky-example-14-
Sheet: Sentences

 |  |  |  |  |  |  |  |  |  |  |  |  | 60
Novice (0-59) | [NAME] (60-69) | Medium LOWER (70-74) | Medium UPPER (75-79) | Competent LOWER (80-82) | Competent MIDDLE (83-86) | Competent UPPER (87-89) | Expert LOWER (90-94) | Expert [NAME] (95-99)
1 text | 1 example | 1 medium | 1 another | 1 again | 1 competent | 1 okay | 1 expert | 1 top |  | 0 | Novice | text
2 text | 2 example | 2 medium | 2 another | 2 again | 2 competent | 2 okay | 2 expert | 2 top |  | 60 | Beginner | example
3 text | 3 example | 3 medium | 3 another | 3 again | 3 competent | 3 okay | 3 expert | 3 top |  | 70 | Medium LOWER | medium
4 text | 4 example | 4 medium | 4 another | 4 again | 4 competent | 4 okay | 4 expert | 4 top |  | 75 | Medium UPPER | another
5 text | 5 example | 5 medium | 5 another | 5 again | 5 competent | 5 okay | 5 expert | 5 top |  | 80 | Competent | again
6 text | 6 example | 6 medium | 6 another | 6 again | 6 competent | 6 okay | 6 expert | 6 top |  | 83 | Competent | competent
7 text | 7 example | 7 medium | 7 another | 7 again | 7 competent | 7 okay | 7 expert | 7 top |  | 87 | Competent | okay
8 text | 8 example | 8 medium | 8 another | 8 again | 8 competent | 8 okay | 8 expert | 8 top |  | 90 | Expert LOWER | expert
9 text | 9 example | 9 medium | 9 another | 9 again | 9 competent | 9 okay | 9 expert | 9 top |  | 95 | Expert UPPER | top
10 text | 10 example | 10 medium | 10 another | 10 again | 10 competent | 10 okay | 10 expert | 10 top
11 text | 11 example | 11 medium | 11 another | 11 again | 11 competent | 11 okay | 11 expert | 11 top
12 text | 12 example | 12 medium | 12 another | 12 again | 12 competent | 12 okay | 12 expert | 12 top
13 text | 13 example | 13 medium | 13 another | 13 again | 13 competent | 13 okay | 13 expert | 13 top
14 text | 14 example | 14 medium | 14 another | 14 again | 14 competent | 14 okay | 14 expert | 14 top
15 text | 15 example | 15 medium | 15 another | 15 again | 15 competent | 15 okay | 15 expert | 15 top
16 text | 16 example | 16 medium | 16 another |  | 16 competent | 16 okay | 16 expert | 16 top
17 text | 17 example | 17 medium | 17 another |  | 17 competent | 17 okay |  | 17 top
 | 18 example |  | 18 another |  | 18 competent | 18 okay |  | 18 top
 | 19 example |  | 19 another |  | 19 competent | 19 okay |  | 19 top
 | 20 example |  | 20 another |  |  | 20 okay |  | 20 top
 | 21 example |  | 21 another |  |  | 21 okay |  | 21 top
 | 22 example |  | 22 another |  |  | 22 okay |  | 22 top
 | 23 example |  | 23 another |  |  | 23 okay
 | 24 example |  | 24 another |  |  | 24 okay
 |  |  | 25 another |  |  | 25 okay
 |  |  | 26 another |  |  | 26 okay
 |  |  | 27 another |  |  | 27 okay
 |  |  | 28 another |  |  | 28 okay
 |  |  | 29 another |  |  | 29 okay
 |  |  |  |  |  | 30 okay
 |  |  |  |  |  | 31 okay
 |  |  |  |  |  | 32 okay
 |  |  |  |  |  | 33 okay
 |  |  |  |  |  | 34 okay
Spreadsheet: 867607d1714437373-solver-function-and-spreadsheet-model-issue-book1
Sheet: Sheet1

Starting Balance | 20000 | rate/mth | 0.000375
 | 1. Jan | 2. Feb | 3. Mar | 4. Apr | 5. May | 6. Jun | 7. Jul | 8. Aug | 9. Sep | 10. Oct | 11. Nov | 12. Dec | rate
3m CD Investment (A) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0.006
6m CD Investment (B) | 0 | 0 | 0 | 0 | 0 | 0 | 3068.221780008844 |  |  |  |  |  | 0.0142
11m CD Investment (C) | 0 | 15349.46426902992 |  |  |  |  |  |  |  |  |  |  | 0.0308
Total Invested
Total Investable Amount
Expenses | 3360 | 2900 | 6600 | 2750 | 2800 | 6800 | 3200 | 3600 | 6550 | 2800 | 2900 | 6650
Income | 3400 | 3400 | 3400 | 9500 | 3400 | 5000 | 4600 | 3400 | 3400 | 3400 | 3400 | 5000
Return on​ 3m CD |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Return on​ 6m CD |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Return on​ 11m CD |  |  |  |  |  |  |  |  |  |  |  | 0
Savings interest | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Final Balance
Balance after Investments
Minimum Savings Balance | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000
Spreadsheet: 144603d1331054536-missing-any-function-in-this-formula-sheet-attached-help
Sheet: Cash Projection

[NAME] | 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 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | Total Amount
Hachette |  | What formula I should use to pich Hachette's payment and only pick January payment.
[NAME] and [NAME] |  | I have tried formula as you can see in CELL B7, please help me if you can....
 |  | I put data in this TAB "Cash Projection" too, and tried to use formula in cell B11.
 |  | The amount should be -1.75 for successfull formula
Hachette |  | 2011-10-11 00:00:00 | -2.63
Hachette |  | 2011-11-10 00:00:00 | 10
Hachette |  | 2012-01-04 00:00:00 | -1.75
Hachette |  | 2012-02-07 00:00:00 | 10.48
Hachette |  | 2012-04-06 00:00:00 | 174.13
Hachette |  | 2012-04-06 00:00:00 | 210
Hachette |  | 2012-04-07 00:00:00 | 12.23
Hachette |  | 2012-02-29 00:00:00 | 244.65
Hachette |  | 2012-02-29 00:00:00 | 136.34
Hachette |  | 2012-02-29 00:00:00 | 12.16
Spreadsheet: 67412d1268059606-skip-hidden-rows-with-offset-demonstration
Sheet: Sheet1

 | Red
 | Red
 | Blue
Filters | Blue
Fund A | Red
Fund A | Red
Fund B | Blue
Fund B | Blue
Fund B | Red
Fund B | Red
Fund B | Blue
Fund B | Blue
Fund A | Red
Fund A | Red
Fund A | Blue
Fund A | Blue
Fund B | Red
Fund B | Red
Fund A | Blue
Fund A | Blue
Fund B | Red
Fund B | Red
Spreadsheet: 151118d1334783753-scoring-based-on-a-grid-grid_check
Sheet: Sheet1

Grid 1
 |  | Defect Rate |  |  |  |  |  |  |  | Name | Volume Handled | Defect Rate | Score
 |  | <= 3.8% | 3.8% - 5.6% | 5.6% - 6.4% | 6.4% - 7.5% | 7.5% - 8.6% | 8.6% - 9.4% | > 9.4% |  | A | 100 | 0.03
Volume Handled | 150 - 376 | 100 | 85 | 75 | 65 | 50 | 40 | 25 |  | B | 200 | 0.04
 | 376 - 564 | 115 | 100 | 85 | 75 | 65 | 50 | 40 |  | C | 400 | 0.05
 | 564 - 639 | 125 | 115 | 100 | 85 | 75 | 65 | 50 |  | D | 800 | 0.06
 | 639 - 751 | 135 | 125 | 115 | 100 | 85 | 75 | 65 |  | E | 1000 | 0.08
 | 751 - 864 | 155 | 135 | 125 | 115 | 100 | 85 | 75
 | 864 - 939 | 175 | 155 | 135 | 125 | 115 | 100 | 85
 | > 939 | 200 | 175 | 155 | 135 | 125 | 115 | 100
Spreadsheet: 4ec44d6a-6137-4345-9cf0-c90b58e65dc9
Sheet: 19

 |  | Broker** |  | Non-Broker |  | TOTAL
Product |  | Cleared*** | Uncleared | Cleared | Uncleared | Cleared | Uncleared
Swap* | CFD
 | Dividend
 | Equity Swap
 | Portfolio
 | [NAME]
Option | Accumulator/Decumulator
 | Vanilla (put/call)
 | [NAME]
Forward | Vanilla
Exotic
Structured Products
TOTAL |  | N/A**** | N/A | N/A | N/A | N/A | N/A
Estimated swap transaction volumes, month ending September 30, by product, participant type, and cleared status (in number of transactions).
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for participant type descriptions.
***See Explanatory Notes for cleared and uncleared descriptions.
****N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 786663d1657349699-calculate-average-of-time-difference-based-on-non-duplicate-criteria-sample-17-ans
Sheet: Sheet1

Trades | Entry  Time (CT) | Exit Time (CT) |  |  | Right Answer |  | Incorrect Answer
1 | 07:33:00 | 07:45:00 |  |  |  |  |  |  |  | 07:33:00 | 07:45:00
2 | 08:15:00 | 08:17:00 |  |  |  | 00:02:00 |  | 2 | 2 | 08:15:00 | 08:17:00
2 | 08:15:00 | 08:17:00 |  |  |  | 00:02:00 |  | 3 | 3 | 08:30:00 | 08:58:00
3 | 08:30:00 | 08:58:00 |  |  |  | 00:28:00 |  | 4 | 4 | 08:31:00 | 08:32:00
3 | 08:30:00 | 08:58:00 |  |  |  | 00:28:00 |  | 5 | 5 | 08:32:00 | 08:33:00
4 | 08:31:00 | 08:32:00 |  |  |  | 00:01:00 |  | 6 | 6 | 09:09:00 | 09:09:00
4 | 08:31:00 | 08:32:00 |  |  |  | 00:01:00 |  | 7 | 7 | 09:11:00 | 09:11:00
5 | 08:32:00 | 08:33:00 |  |  |  | 00:01:00 |  | 8 | 8 | 09:11:00 | 09:12:00
5 | 08:32:00 | 08:33:00 |  |  |  | 00:01:00
6 | 09:09:00 | 09:09:00 |  |  |  | 00:00:00
6 | 09:09:00 | 09:09:00 |  |  |  | 00:00:00
6 | 09:09:00 | 09:09:00 |  |  |  | 00:00:00
7 | 09:11:00 | 09:11:00 |  |  |  | 00:00:00
7 | 09:11:00 | 09:11:00 |  |  |  | 00:00:00
8 | 09:11:00 | 09:12:00 |  |  |  | 00:01:00
Average Hold Time =
Spreadsheet: 852170d1702282987-calculate-the-working-hours-overtime-timesheet-hours-beamer
Sheet: ورقة1

Day & Date | Task1 | Progress | Task 2 | Progress | Task 3 | Progress | Completed (This Week/Next Week) | Solution | Check-in Time | Check-out Time | Total Working Hours | Overtime | O/time Rate
2023-10-01 00:00:00 | Onboarding | 0.55 |  |  |  |  | Completed |  | 09:00:00 | 17:30:00
 | Onboarding | 0.74 |  | 1 |  |  | Completed |  | 08:00:00 | 17:30:00
 | Onboarding | 1 |  | 1 |  |  | Completed |  | 09:00:00 | 16:30:00
 | Onboarding | 1 |  | 1 |  | 1 | Completed |  | 09:08:00 | 17:30:00
 | Monitoring | 1 |  | 1 |  |  | Completed |  | 07:50:00 | 18:50:00
 |  |  |  |  |  |  |  |  |  |  | Total Hours this Week | Overtime for this week
End Of Week 1 - October
 |  | 1 |  | 1 |  |  | Completed |  | 09:10:00 | 16:25:00
 |  | 1 |  | 1 |  |  | Completed |  | 09:17:00 | 16:05:00
 |  | 1 |  | 1 |  |  | Completed |  | 08:10:00 | 16:02:00
 |  | 1 |  |  |  |  | Completed |  | 09:03:00 | 16:10:00
 |  | 1 |  |  |  |  | Completed |  | 09:02:00 | 16:21:00
 |  |  |  |  |  |  |  |  |  |  | Total Hours this Week | Overtime for this week
Spreadsheet: 77989d1278450478-asset-matrix-example1
Sheet: House A

House A | 2010-08-08 00:00:00 | 2010-10-30 00:00:00
Required Tasks | Start date | End Date | Personnel | CODE
Framing | 2010-08-08 00:00:00 | 2010-08-15 00:00:00 | [NAME] | LTR
 | 2010-08-16 00:00:00 | 2010-08-25 00:00:00 | Doug | LTR
Concrete | 2010-08-16 00:00:00 | 2010-08-31 00:00:00 | [NAME] | [NAME]
 | 2010-09-01 00:00:00 | 2010-09-15 00:00:00 | Doug | [NAME]
Plumbing | 2010-09-01 00:00:00 | 2010-09-30 00:00:00 | [NAME] | PQW
 | 2010-10-04 00:00:00 | 2010-10-20 00:00:00 | Doug | PQW
Electrical | 2010-10-04 00:00:00 | 2010-10-08 00:00:00 | [NAME] | [NAME]
 | 2010-09-03 00:00:00 | 2010-09-10 00:00:00 | [NAME] | [NAME]
 | 2010-09-03 00:00:00 | 2010-09-10 00:00:00 | [NAME] | [NAME]
 | 2010-10-03 00:00:00 | 2010-10-29 00:00:00 | [NAME] | [NAME]
 | 2010-09-04 00:00:00 | 2010-09-12 00:00:00 | Lance | [NAME]
 | 2010-10-05 00:00:00 | 2010-10-25 00:00:00 | Lance | [NAME]
 | 2010-10-05 00:00:00 | 2010-10-25 00:00:00 | Will | [NAME]
 | 2010-10-15 00:00:00 | 2010-10-30 00:00:00 | [NAME] | [NAME]
Spreadsheet: 49983d1249401862-import-data-from-excel-missing-columns-and-rows-sample
Sheet: Rejects

1-CLT-1 | XXXXX | [NAME] | MM/DD/YYYY | XXXXX | LOTXXXXX-XXXXX | R100909#CLT-1
2-CLT-2 | XXXXX | [NAME] | MM/DD/YYYY | XXXXX | LOTXXXXX-XXXXX | [NAME]
3-CLT-3 | XXXXX | [NAME] | MM/DD/YYYY | XXXXX | LOTXXXXX-XXXXX | R100909#CLT-3
4-CLT-4 | XXXXX | [NAME] | MM/DD/YYYY | XXXXX | LOTXXXXX-XXXXX | R100909#CLT-4
BANNER | BANNER | BANNER | BANNER | BANNER | BANNER-BANNER | BANNER
BANNER | BANNER | BANNER | BANNER | BANNER | BANNER-BANNER | BANNER
Spreadsheet: 49048d1248324599-pivot-table-getting-duplicates-testbook
Sheet: TestData

Column A | Column B | Count
CCCCC | DDDDDDD | 1
CCCCC | [NAME] | 1
CCCCC | DDDDDDD | 1
XXXXX | YYYYYYY | 1
XXXXX | ZZZZZZZ | 1
XXXXX | YYYYYYY | 1
Spreadsheet: 44098d1242750253-performance-calc-performancegrid
Sheet: Sheet1

Type | x1 | x2 | [NAME] |  |  | Type | x1
month |  |  |  |  |  | Start | 2008-02-02 00:00:00
2007-09-30 00:00:00 | 3.5 | 4.51 | 21.9 |  |  | End | 2008-04-30 00:00:00
2007-10-31 00:00:00 | 3.9 | 4.91 | 18.9 |  |  |  |  |  |  |  |  | Named Ranges
2007-11-30 00:00:00 | 0.1 | -2.19 | 8.6 |  |  | [NAME] | 2.2 |  |  |  |  | Dates
2007-12-31 00:00:00 | 1.3 | -0.09 | 11.3 |  |  |  |  |  |  |  |  | X1column
2008-01-31 00:00:00 | 0.8 | -2.29 | 12.1 |  |  |  |  |  |  |  |  | X2column
2008-02-29 00:00:00 | 2.4 | 2.21 | 15.9 |  |  |  |  |  |  |  |  | X3column
2008-03-31 00:00:00 | 0.6 | -1.29 | 10.2
2008-04-30 00:00:00 | 1.6 | 0.01 | 12.4
2008-05-31 00:00:00 | 1.3 | 0.41 | 11.4
2008-06-30 00:00:00 | -0.7 | -2.49 | 6.9
Spreadsheet: 850941d1701247693-vlookup-only-returning-first-value-and-sumif-returning-the-sum-twice-book29
Sheet: Sheet1

 |  |  | Sheet 1 |  |  |  |  | Sheet 2
 |  |  | IDs | Amount | sumif |  |  | IDs | Amount | Sumif
 |  |  | 96162 |  |  |  |  | 96162 | 100
 |  |  | 81180 |  | 50 |  |  | 81180 | 50
 |  |  | B3FLWH9 |  | 10 |  |  | B3FLWH9 | 10
 |  |  | 182704 |  | 45 |  |  | 182704 | 20
 |  |  | 182704 |  | 45 |  |  | 182704 | 25
 |  |  |  | 1) | I would like F8 to return 45 and for F9 to be zero or for [NAME] and F9=25
 |  |  |  | 2) | cell E9 to return 25
Spreadsheet: 144519d1331019794-sales-sheet-transfer-to-invoice-sheet-sample-monthly-sales-and-invoices-update
Sheet: New invoice

 |  |  |  |  |  |  | Code
 |  |  |  |  |  |  | 1
 |  | Customer ID
 |  |  | Invoice No.
 |  | b2
 |  |  |  | Date:
 |  | Date | Vendor name | Cost | VAT
 | _
 |  |  |  | Total Cost of Classes
 |  |  |  | VAT
 |  |  |  | Invoice Total
Spreadsheet: 748746d1632322142-count-conditional-formatted-or-other-method-test_condtionalcount
Sheet: Sheet1

 | Count?
[NAME]
Par
[NAME]
Double
Triple or Higher
 |  |  | Hole | 1
 |  |  | Par | 5 | 4 | 4 | 3 | 4 | 4 | 4 | 3 | 5 | 5 | 4 | 3 | 4 | 4 | 5 | 3 | 4 | 4
 |  |  |  | 4 | 5 | 6 | 4 | 5 | 4 | 4 | 4 | 6 | 7 | 5 | 4 | 5 | 5 | 5 | 4 | 4 | 7
 |  |  |  | 6 | 4 | 6 | 3 | 4 | 5 | 3 | 4 | 5 | 7 | 4 | 4 | 5 | 7 | 6 | 4 | 4 | 6
 |  |  |  | 8 | 5 | 5 | 3 | 4 | 4 | 5 | 4 | 5 | 6 | 5 | 3 | 5 | 6 | 6 | 4 | 4 | 6
 |  |  |  | 6 | 4 | 5 | 3 | 4 | 7 | 4 | 5 | 5 | 5 | 5 | 4 | 4 | 6 | 6 | 5 | 4 | 5
 |  |  |  | 5 | 5 | 5 | 4 | 4 | 4 | 5 | 3 | 5 | 5 | 5 | 3 | 3 | 4 | 4 | 4 | 3 | 5
 |  |  |  | 6 | 4 | 4 | 3 | 4 | 4 | 4 | 3 | 5 | 5 | 5 | 3 | 4 | 5 | 6 | 3 | 5 | 7
 |  |  |  | 5 | 5 | 6 | 3 | 4 | 4 | 4 | 3 | 5 | 5 | 5 | 4 | 6 | 5 | 6 | 4 | 4 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 3 | 5 | 4 | 5 | 6 | 5 | 5
Spreadsheet: kevin_ruscitti__20337__Michigan_Flows
Sheet: Flows

 | Michigan
Capacity |  | MichCon: | Pipelines | 1999-10-01 00:00:00 | 1999-11-01 00:00:00 | 1999-12-01 00:00:00 | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00
300000 |  |  | Great Lakes | 198916 | 28137 | -26769 | -46625 | -10713 | -10713 | 23225 | 72167 | 112677 | 145842 | 280251
155000 |  |  | Panhandle | 118141 | 177200 | 76615 | 24137 | 15222 | 86468 | 138999 |  | 166418 | 144405 | 131774 | 162817 | 175675 | 64890 | 18000
435000 |  |  | ANR - Willow Run | 116759 | 394119 | 159599 | 111079 | 190487 | 233158 | 303736 | 200074 | 339301 | 202361 | 266964 | 409461 | 365476
250000 |  |  | Union - St. Clair |  | -133130 | -88012 | -92593 | -96004 | -115479 | -7460 | -4373 | -7177 | -2363 | 12970 | 12190 |  | -170996
300000 |  |  | ANR - Columbus |  | -46308 | -59451 | -50500 | -54411 | -60498 | -14999 | -8709 | -2554 | 0 | 0 | -742 | -14272 | -49997 | -35000
 |  |  | Transport Flows:
 |  |  | Production: |  |  |  |  |  |  | 337330.1 | 213913.0967741935 | 345773.9 | 325656.9166666667 | 302779.4516129032 | 324417.4666666667 | 329846.48 | 292543.2727272727
 |  |  | Basis to MichCon:
 |  |  | POINT | 1999-10-01 00:00:00 | 1999-11-01 00:00:00 | 1999-12-01 00:00:00 | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00
 |  |  | ANR-SE | -0.148 | -0.152 | -0.051 | 0.004 | -0.098 | -0.159 | -0.207 | -0.19 | -0.186 | -0.181 | -0.222
 |  |  | ANR-OK | -0.182 | -0.205 | -0.089 | -0.071 | -0.177 | -0.176 | -0.269 | -0.292 | -0.263 | -0.211 | -0.245 | -0.316 | -0.301 | -0.29
 |  |  | PEPL | -0.177 | -0.211 | -0.089 | -0.083 | -0.199 | -0.178 | -0.269 | -0.296 | -0.267 | -0.219 | -0.252 | -0.317 | -0.303 | -0.297
 |  |  | Dawn | 0.05300000000000001 | 0.043 | 0.081 | 0.086 | 0.087 | 0.075 | 0.007000000000000006 | -0.004000000000000004 | -0.013 | -0.03 | -0.04899999999999999 | 0.04899999999999996 | 0.035 | 0.132
 |  |  | ML7 | 0.03599999999999999 | 0.02799999999999998 | 0.093 | 0.141 | 0.06 | 0.019 | 0.01900000000000002 | 0.016 | 0.035 | 0.04100000000000001 | 0.01900000000000002 | -0.002000000000000002 | 0.009000000000000008 | 0.031
 |  |  | [NAME] | 2.683387096774194 | 2.312333333333333 | 2.354677419354838 | 2.398709677419354 | 2.656896551724139 | 2.781451612903225 | 3.02 | 3.574838709677419 | 4.301166666666666 | 4.039677419354838 | 4.384677419354839 | 5.016500000000002 | 5.032096774193549 | 4.6685
Spreadsheet: 860450d1708533752-need-help-to-develop-a-monthly-gantt-schedule-which-is-more-complex-in-nature-gantt-with-flags
Sheet: Gantt

HIGH LEVEL GANTT CHART & STATUS |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
UPDATED ON | LAST DAY OF MONTH
SCHEDULE START DATE | 2023-12-01 00:00:00
SCHEDULE TYPE | MONTHLY
PROJECTS | START DATE | END DATE |  | FLAG | FLAG MONTH | FLAG REMARKS
Project -G1 | 2023-12-01 00:00:00 | 2024-05-31 00:00:00 |  | Y | 2024-02-24 00:00:00
Project-H1 | 2024-03-01 00:00:00 | 2024-08-31 00:00:00 |  | N
Project-H2 | 2024-03-01 00:00:00 | 2024-08-31 00:00:00 |  | N
Project-H3 | 2023-12-01 00:00:00 | 2024-05-31 00:00:00 |  | N
Project-H4 | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  | N
Project-H5 | 2024-02-05 00:00:00 | 2024-08-04 00:00:00 |  | N
Requirement:
In the above table, I want each project row to be colored with some color (e.g. grey) for the entire duration of project. Additionally, I also need the [NAME] to color each project row with 'green' color for the duration from sart date to =TODAY() date.
So, essentially, whenever I open this [NAME], there would be 2 colors appearing on each project row. i.e. [NAME] color will automatically populate for the entire project duration & green color will be overlayed on this grey until today's date.
Further, if the end date of project has passed by today's date, then only green color should appear for the entire project duration & not further.
The idea is to represent how much duration has been passed when viewed on any given date….Green indicates this duration until =today()
Next, in column E, I have put column header as 'FLAG", which has 2 options in drop-down, Y or N, If it is Y, then column F, header as 'FLAG MONTH' will be updated manually by giving the actual month reference which has some flag (i.e. any issue/alarm/risk etc...)
Now, if this Column F is populated with any certain month, I need that specific month cell against that respective project row to be highlighted in LIGHT RED (our standard conditional formatting [NAME] color)
The column G, header as 'FLAG REMARKS' will also be updated manually to indicate what type of flag it is….(e.g., Utilization impact, Cost overrun, Resource risk, Delivery delay etc..)
Further, I was also looking to check if there is a way to archive the entire sheet for a specific month which has passed by. For e.g., Feb-24 last day is 29-Feb-24, so the sheet should be archived on a separate tab with name as Feb-24….so essentially, once a month is passed, all those months Gantts should sit in separate tabs as archived & locked for editing.
This way, we can see how was the progress/flags in each of the respective months.