tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: chris_germany__2129__FebCohCHOICE-ENA
Sheet: Feb 19

 | CES/NPC COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2001-02-19 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | Upstream K# | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 947 |  | 1504 |  | 67694 |  |  |  |  |  |  | 34 | 1 | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 | 2 | 42
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 6638 |  | 3547 |  | 67694 |  |  |  |  |  |  | 36 | 3 | 41
 |  |  |  |  |  |  |  |  | 3000 |  | 3000 |  | 68918 | 103722 | 0 |  |  |  |  | 35 | 4 | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 | 5 | 44
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 1815 |  | 1077 |  | 67694 |  |  |  |  |  |  | 38 | 6 | 44
 |  |  |  |  |  |  |  |  | 2000 |  | 2000 |  | 68915 | 103722 | 0 |  |  |  |  | 35 | 7 | 41
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69148 |  | 0 |  |  |  |  | 39 | 8 | 39
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 |  | 0 |  |  |  |  | 37 | 9 | 42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42 | 15 | 29
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 14106 |  | 9705 |  | 67694 |  |  |  |  |  |  | 36 | 35 | 43
 |  |  |  |  |  |  |  |  | 25 |  | 25 |  | 68917 | 103722 | 0 |  |  |  |  | 35 | 39 | 40
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69149 |  | 0
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 |  | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 1371 |  | 889 |  | 67694 |  |  |  |  |  |  | %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Storage
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1217 |  | 834 |  | 67694 |  |  |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 68916 | 103722 | 0 |  |  |  |  | 1
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 9612 |  | 5972 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 1880 |  | 1248 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 2445 |  | 2445 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 3330 |  | 2627 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 772 |  | 238 |  | 67694
 |  |  |  |  |  |  |  |  | 257 |  | 257 |  | 69708 | 53858 | 0
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 53858 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 33 |  | 28 |  | 67694 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20146 | FOM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 86918 | 20596 | Pull from ENA Pool to NPC Pool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 682197d1591959386-find-a-high-low-avg-price-v2_sales-2020
Sheet: Pivot Table

Grade | Vessesl | Species | Sum of Boxes2 | Sum of Total Cost | [NAME] | [NAME]
1 | PD352 | COD | 1 | 130 | 3.25 | 3.25
 | BF505 | COD | 28 | 3360 | 3.636363636363636 | 3.636363636363636
1 Total |  |  | 29 | 3490 | 3.25 | 3.636363636363636
2 | PD352 | COD | 2 | 162.5 | 3.25 | 3.25
 | BF505 | COD | 31 | 3668 | 3.575757575757576 | 3.606060606060606
2 Total |  |  | 33 | 3830.5 | 3.25 | 3.606060606060606
3 | PD352 | COD | 4 | 464 | 2.9 | 2.9
 | BF505 | COD | 16 | 1712 | 3.151515151515151 | 3.333333333333333
3 Total |  |  | 20 | 2176 | 2.9 | 3.333333333333333
4 | PD352 | COD | 3 | 300 | 2.5 | 2.5
 | BF505 | COD | 1 | 95 | 2.878787878787879 | 2.878787878787879
4 Total |  |  | 4 | 395 | 2.5 | 2.878787878787879
5 | BF505 | COD | 1 | 94 | 2.848484848484849 | 2.848484848484849
5 Total |  |  | 1 | 94 | 2.848484848484849 | 2.848484848484849
Grand Total |  |  | 87 | 9985.5 | 2.5 | 3.636363636363636
Spreadsheet: 29971d1225246198-look-up-closest-match-closet-value-sglife
Sheet: sglife

Column1 | Column2 |  | Column1 | Column2
[NAME] | 3 |  | [NAME] | 65 | 70
King | 16 |  | King | 30 | 33
Twin | 5 |  | Twin | 22 | 24
[NAME] | 70
King | 33
Twin | 24
Spreadsheet: dan_hyvl__4715__Louis Dreyfus Natural Gas Master Physical 01092001
Sheet: AMASTPSA 

MASTER FIRM PURCHASE/SALE AGREEMENT INFORMATION SHEET
ENA Entity: | ENA | ATTORNEY:
DATE: | 2001-01-09 00:00:00 | ENA CONTACT: | [NAME]
COUNTERPARTY: | Louis Dreyfus Natural Gas Corp. | CONTACT: | Mr. [NAME]
ADDRESS: | 14000 Quail Springs Pkwy. | TITLE:
 | Suite 600 | PHONE:
 | Oklahoma City, OK 73134 | FAX:
INCORPORATION STATE: | Oklahoma | S&P RATING: | BBB
STRUCTURE | COUNTERPARTY | ENA ENTITY
COLLATERAL
THRESHOLD  in $ | Based on Credit Rating - see below | Based on Credit Rating - see below
COMMITTED VOLUMES
THRESHOLD in $[NAME] | N/A | N/A
COLLATERAL REQUIRED FOR:
ALL TRADES
OTHER | N/A | N/A
COLLATERAL TYPE
Letter of Credit | OK | OK
Cash | OK | OK
COLLATERAL  MULTIPLE | 250000 | 250000
GUARANTOR (RATING) | N/A | Enron Corp. (BBB+)
LIMIT in $[NAME] |  | 30000000
Incorporation State: |  | OR
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty | X
-Guarantor
Debt Ratings Change
-Below =
Financial Covenants | X
-Funded Debt/Net Worth | > 2:1
-Minimum Net worth
-EBITDA/Interest | < 3:1
-Current Ratio
Non-Specific
-Unilateral
Ownership Change
-Less than 51% owned by:
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty | 25000000
-Guarantor ($[NAME]) |  | 100000000
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | YES:    X | NO:
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | YES:    X | NO:
COLLATERAL THRESHOLDS
S&P Rating of BBB or above | 25000000 | 25000000
S&P Rating of BBB- | 20000000 | 20000000
S&P Rating of BB+ | 10000000 | 10000000
S&P Rating of BB or below | 0 | 0
CREDIT REVIEW  PREPARED BY: |  | [NAME] | Ext. 53923
Spreadsheet: 85904d1285900298-combine-two-rows-of-data-into-one-row-row_combine
Sheet: text to columns

 | 413 | 09/19/10 | 06:00:00 | PM | user1 | [423]
Emma | Smith | Corporate | Challenge | - | September | 10 | 10 | 1 | 5
 | 414 | 09/19/10 | 06:17:00 | PM | user2 | [424]
[NAME] | Jones | Corporate | Challenge | - | September | 10 | 10 | 1 | 5
 | 416 | 09/20/10 | 08:36:00 | AM | user3 | [118]
[NAME] | [NAME] | Corporate | Challenge | - | September | 10 | 10 | 1 | 5
 | 433 | 09/27/10 | 12:11:00 | PM | user4 | [438]
[NAME] | Walker | Corporate | Challenge | - | September | 10 | 10 | 1 | 5
Spreadsheet: 149206d1333744656-pulling-multiple-results-by-matching-one-variable-from-list-of-variables-example-file
Sheet: Calculation 

 |  |  | Input Cell:
 |  |  | 3
 | Import from Data Sheet |  | Item Code | Quantity | Type
Spreadsheet: 155590d1336983711-conditional-formatting-for-dates-and-highlighting-cells-cf-on-dates
Sheet: Sheet1

Date
Days Overdue |  |  |  |  |  |  |  | Date of decision | Decision |  |  | Date final report delivered
 |  |  |  |  |  |  |  | 2012-05-08 00:00:00 | Approved
 |  |  |  |  |  |  |  |  | (none)
 |  |  |  |  |  |  |  | 2012-03-14 00:00:00 | Approved |  |  | 2012-04-24 00:00:00
 |  |  |  |  |  |  |  | 2011-12-01 00:00:00 | Approved
 |  |  |  |  |  |  |  | 2011-01-01 00:00:00 | Approved
 |  |  |  |  |  |  |  | 2011-01-01 00:00:00 | Not Approved
I need column A to calculate the number of days between todays date (cell B 1) and the date of decision (eg 20 days).  Obviously todays date will keep changing.
I also need the cells in column A to change colour: turn green when the days overdue are 120 or less, yellow when they are between 121 and 150 days overdue and red when they are 150 or more days overdue.
Also I need the cell in column A to stay blank if there is either no date in the Date Final Report Delivered column (M) or the text in Decision column (J) is other than Approved.
Spreadsheet: 56646d1256778741-help-with-lookup-in-conjuction-with-concatenate-forum-example
Sheet: Source

CC | Standard Department | Department | Measure Category | Measure | Compare Group | Host Value - FYE 2Q 2009 | Percentile - 25th | Percentile - 35th | Percentile - 50th | Host Percent Rank | Sample Size | Compare Group Average | Standard Deviation
27044 | Ultrasound | 27044, RADIOLOGY/ULTRASOUND | Dept Operating Statistics | Labor Expense | All Hospitals and Systems | 222726.51 | 248502.9 | 321501.21 | 418974.49 | 0.1945 | 438 | 506966.01 | 374203.58
27044 | Ultrasound | 27044, RADIOLOGY/ULTRASOUND | Dept Operating Statistics | Labor Expense | Master Facility TVRH | 222726.51 | 193870.2 | 222992.92 | 268558.69 | 0.3443 | 62 | 304185.73 | 158168.34
27044 | Ultrasound | 27044, RADIOLOGY/ULTRASOUND | Dept Operating Statistics | Labor Expense | [NAME] ANNUAL | 222726.51 | 216425.92 | 240847.25 | 260474.95 | 0.2766 | 48 | 284896.65 | 121527.03
27044 | Ultrasound | 27044, RADIOLOGY/ULTRASOUND | Dept Operating Statistics | Labor Expense | VHA SouthEast | 222726.51 | 222726.51 | 354421.15 | 408856 | 0.25 | 9 | 474799.81 | 322130.58
27044 | Ultrasound | 27044, RADIOLOGY/ULTRASOUND | Dept Operating Statistics | Overtime [NAME] | All Hospitals and Systems | 24342.84 | 8629 | 13967.87 | 21528.11 | 0.5522 | 231 | 29826.31 | 29252.25
27044 | Ultrasound | 27044, RADIOLOGY/ULTRASOUND | Dept Operating Statistics | Overtime [NAME] | Master Facility TVRH | 24342.84 | 10052.93 | 14287.21 | 25401 | 0.4667 | 31 | 34680.2 | 30877.88
27044 | Ultrasound | 27044, RADIOLOGY/ULTRASOUND | Dept Operating Statistics | Overtime [NAME] | [NAME] ANNUAL | 24342.84 | 8517.76 | 12657.45 | 18267.7 | 0.5909 | 23 | 22627.91 | 18261.16
27044 | Ultrasound | 27044, RADIOLOGY/ULTRASOUND | Dept Operating Statistics | Overtime [NAME] | VHA SouthEast | 24342.84 | 9,204.97* | 10,545.18* | 18,029.70* | 83.33 %* | 7 | 15,953.56* | 7,928.50*
27044 | Ultrasound | 27044, RADIOLOGY/ULTRASOUND | Cost Ratios | Labor Expense per Procedure | All Hospitals and Systems | 44.63 | 34.6 | 37.89 | 42.78 | 0.5654 | 429 | 45.71 | 17.88
27044 | Ultrasound | 27044, RADIOLOGY/ULTRASOUND | Cost Ratios | Labor Expense per Procedure | Master Facility TVRH | 44.63 | 38.65 | 40.48 | 43.85 | 0.5254 | 60 | 47.8 | 16.33
27044 | Ultrasound | 27044, RADIOLOGY/ULTRASOUND | Cost Ratios | Labor Expense per Procedure | [NAME] ANNUAL | 44.63 | 41.28 | 43.49 | 47.13 | 0.4468 | 48 | 52.33 | 20.72
27044 | Ultrasound | 27044, RADIOLOGY/ULTRASOUND | Cost Ratios | Labor Expense per Procedure | VHA SouthEast | 44.63 | 32.33 | 33.33 | 37.19 | 0.875 | 9 | 37.06 | 8.62
Spreadsheet: mary_fischer__25632__31N
Sheet: E8.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031N
COMPANY NAME    EFS C&S
ANALYSIS OF OTHER DEFERRED CHARGES
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | 12-31-2000 Balance |  |  |  | Charged to |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Pd / (Rec'd) |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Work in Progress:
 |  | 0
Total  (Hyperion Line 0343)
Asset/Expense Accts:  DR/(CR)
Other Deferred Charges:
 |  | 0
Total (Hyperion line 360)
Asset/Expense Accts:  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 724987d1616488856-count-with-changes-in-multiple-criteria-count-formula-ans
Sheet: Sheet1

Invoice Number | Explanation-Remark- | Count Formula | Examples | Need a formula that will add a .1 to the invoice number for every change in the remark.
[PHONE] | 02/02-03/01 #050579760100001 G |  | [PHONE].1
[PHONE] | 02/02-03/01 #050579760100001 H |  | [PHONE].2
[PHONE] | 02/02-03/04 #AUGM1 E |  | [PHONE].1
[PHONE] | 01/01-02/01 #92564300 W |  | [PHONE].1 | B6<>B5
[PHONE] | 01/01-02/01 #92564300 W |  | [PHONE].1
[PHONE] | 01/07-02/05 #101542300 W |  | [PHONE].2
[PHONE] | 01/07-02/05 #101542300 W |  | [PHONE].2
[PHONE] | 01/07-02/05 #101566300 W |  | [PHONE].3
[PHONE] | 01/07-02/05 #101566300 W |  | [PHONE].3
[PHONE] | 01/07-02/05 #101573300 W |  | [PHONE].4
[PHONE] | 01/07-02/05 #101573300 W |  | [PHONE].4
[PHONE] | 01/07-02/05 #103191301 W |  | [PHONE].5
[PHONE] | 01/07-02/05 #103197300 W |  | [PHONE].6
[PHONE] | 01/07-02/05 #103197300 W |  | [PHONE].6
[PHONE] | 12/30-03/01 #[PHONE] S |  | [PHONE].1
[PHONE] | 12/30-03/01 #[PHONE] W |  | [PHONE].2
[PHONE] | 02/13-03/15 #[PHONE] E |  | [PHONE].3
[PHONE] | 02/13-03/15 #[PHONE] N |  | [PHONE].4
[PHONE] | 02/13-03/15 #[PHONE] E |  | [PHONE].5
[PHONE] | 02/13-03/15 #[PHONE] N |  | [PHONE].6
[PHONE] | 02/13-03/15 #[PHONE] E |  | [PHONE].7
Spreadsheet: 164003d1340605110-convert-text-to-numbers-for-formula-0aexample-difference-in-time-excel-forum
Sheet: Sheet5

Open Hour | Close Hour | Diff. Open & Cls Check
07:08A | 07:08A
07:40A | 07:41A
07:56A | 08:42A
[NAME] | 09:33A
09:03A | 09:17A
09:06A | 09:22A
09:15A | 09:17A
09:25A | 10:42A
Spreadsheet: kimberly_watson__20552__imbalsumm0108
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 |  | 381883
500232 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 | 348736 | 330579 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 |  | 488178
500293 | 159805 | 224741
500302 |  | 4136
500303 | 98079 | 122681
500305 | 378392 | 488453
500307 | 50825 | 55127
500313 |  | 1154
500314
500655
500657 | 53367 | 60449
INDEX
2001-07-31 00:00:00 |  |  | -131785.95
2001-08-11 00:00:00
CBS Volume
 |  |  | -81746
Spreadsheet: 00c52f7f-4265-4408-8ffa-f23b694cea73
Sheet: Sheet1

Please input the following information.  Results can be viewed on the attached sheets as indicated. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
MR [NAME]
Enrollment | 0
Serving Days | 0
 | Breakfast | Lunch
Meals Paid
Number | 0 | 0
Reimbursement Rate | 0.21 | 0.19
Meals Free
Number | 0 | 0
Reimbursement Rate | 1.12 | 2.02
Meals Reduced Price
Number | 0 | 0
Reimbursement Rate | 0.82 | 1.62
Student Pricing
Paid Charge | 0 | 0
Reduced Charge | 0 | 0
Total Ala Carte Revenue | 0 | Actual
'What if' Input
Enrollment | 0
Serving Days | 0
 | Breakfast | Lunch
Meals Paid
Number | 0 | 0 | Enter number to increase (+) or decrease (-)
Reimbursement Rate | 0.21 | 0.19
Meals Free
Number | 0 | 0 | Enter number to increase (+) or decrease (-)
Reimbursement Rate | 1.12 | 2.02
Meals Reduced Price
Number | 0 | 0 | Enter number to increase (+) or decrease (-)
Reimbursement Rate | 0.82 | 1.62
Student Pricing
Paid Charge | 0 | 0
Reduced Charge | 0 | 0
Ala Carte Revenue | 0 | Enter amount to increase (+) or decrease (-)
Spreadsheet: chris_stokley__3846__February 2001 tranny
Sheet: Sheet1

DATE | SRP (MW) | ENA (MW) | Difference (MW) | SRP Day total | ENA Day Total | Difference ($)
2001-02-02 00:00:00 | 85 | 60 |  | 12845.2 | 9067.2 | 3778
2001-02-03 00:00:00 | 60 | 60 |  | 7684.8
2001-02-04 00:00:00 | 60 | 60 |  | 7684.8
2001-02-05 00:00:00 | 220 | 220 |  | 28344.8
2001-02-06 00:00:00 | 60 | 60 |  | 7730.4
2001-02-07 00:00:00 | 60 | 60 |  | 7042.2
2001-02-08 00:00:00 | 60 | 60 |  | 6827.4
2001-02-09 00:00:00 | 60 | 60 |  | 6917.4
2001-02-10 00:00:00 | 60 | 60 |  | 6248.4
2001-02-11 00:00:00 | 60 | 60 |  | 6248.4
2001-02-12 00:00:00 | 220 | 220 |  | 31055.2
2001-02-13 00:00:00 | 60 | 60 |  | 8460
2001-02-14 00:00:00 | 60 | 60 |  | 7650
2001-02-15 00:00:00 | 60 | 60 |  | 9909.5
2001-02-16 00:00:00 | 60 | 60 |  | 15319.8
2001-02-17 00:00:00 | 60 | 60 |  | 15319.8
2001-02-18 00:00:00 | 60 | 60 |  | 14937
2001-02-19 00:00:00 | 60 | 60 |  | 9782.4
2001-02-20 00:00:00 | 60 | 60 |  | 9729
2001-02-21 00:00:00 | 170 | 190 |  | 23439.6 |  | 2757.6 | In SRP's Favor
2001-02-22 00:00:00 | 80 | 60 |  | 9232 |  | 2308
2001-02-23 00:00:00 | 170 | 190 |  | 17428.4 |  | 2050.4 | In SRP's Favor
2001-02-24 00:00:00 | 190 | 190 |  | 19478.8
2001-02-25 00:00:00 | 495 | 480 |  | 63439.2 |  | 1922.4
2001-02-26 00:00:00 | 160 | 160 |  | 20505.6
2001-02-27 00:00:00 | 125 | 120 |  | 12353.75 |  | 483.15
2001-02-28 00:00:00 | 120 | 120 |  | 12370.8
 |  |  | TOTALS: | 397984.75 | 394301.2 | 3683.55
 |  |  | SRP |  | ENA
 |  |  | 397984.75 |  | 394301.2
 |  |  | x 2.3% |  | x 2.3%
 |  |  |  |  | 9068.9276
Spreadsheet: 0292c416-a254-4f4f-ab54-2a6d09fb4d32
Sheet: Sheet1

Payout
Pro | 0.5
Adv | 0.33 |  | Sample:
Int | 0.1 |  |  | Division | # of Players | Money | # of Players Paid | Player's Packs
Nov | 0.25 |  |  | Pro Open | 10 |  | 5
 |  |  |  | Pro GM | 4 |  | 2
Entry Fees |  |  |  | Adv | 15 |  | 5
Pro | 45 |  |  | Adv Masters | 8 |  | 3
Adv | 35 |  |  | Int | 40 |  | 4 | 40 | 15
Int | 25 |  |  | Nov | 6 |  | 2 | 6 | 15
Nov | 20 |  |  |  |  |  |  |  |  |  | Total Prize/PP Money Spent:
 |  |  |  | Totals |  |  |  | 46 | $15 each |  | Left Over for Pro Divisions:
 |  |  |  |  |  |  |  |  |  |  | Total Pro Money Paid:
 |  |  | Sample Payout:
 |  |  | Pro | 1st | 400 | Adv | 1st | 75 | Int | 1st | 50 | Nov | 1st | 40
 |  |  | 850 | 2nd | 230 |  | 2nd | 55 |  | 2nd | 45 |  | 2nd | 25
 |  |  |  | 3rd | 100 |  | 3rd | 45 |  | 3rd | 40
 |  |  |  | 4th | 70 |  | 4th | 35 |  | 4th | 35
 |  |  |  | 5th | 50 |  | 5th | 25
 |  |  | Pro GM | 1st | 250 | Adv Masters | 1st | 75
 |  |  | 360 | 2nd | 110 |  | 2nd | 55
 |  |  |  |  |  |  | 3rd | 45
Spreadsheet: 471690d1469133908-help-drawing-in-information-based-on-filters-pipeline-tracker
Sheet: Key

Status | Probability | SE | SR | SA | Deal Reg Status | Product Category
Open | 0 | [NAME] | [NAME] | Gwen [NAME] | Approved | SONICWALL HARDWARE
Closed - Won | 0.25 | [NAME] | [NAME] | [NAME] | Denied | DELL STORAGE
Closed - Lost | 0.5 |  | [NAME] |  | In Collaboration | [NAME]
Partially Closed | 0.75 |  |  |  |  | WYSE THIN CLIENTS
 | 1
Spreadsheet: 131843d1323355721-nested-if-or-and-matched-indexed-statements-2012_eu22-jv-version-1
Sheet: Names List

All the vital info and tick list
 | Booking # | Tour Code | Names | Room type | Room # | Age | DOB | Nationality | Passport # | Phone # | Dietary | Medical | Next of Kin | Meeting where | Notes | [NAME]
1 |  | [NAME] | Driver | single |  | N/A | N/A | N/A
2 |  | [NAME] | Tour leader | single |  | N/A | N/A | N/A
3 |  | EA | mr s | twin | 1
4 |  | EA | Mrs s | twin | 1
5 |  | ew | miss t | triple | 1
6 |  | ew | miss r | triple | 1
7 |  | ew | miss e | triple | 1
8 |  | [NAME] | mr o | twin | 2
9 |  | [NAME] | mr p | twin | 2
10 |  | ew | Mrs j | twin | 3
11 |  | ew | mr j | twin | 3
12 |  | [NAME] | h | ms
13 |  | ew | k | ms
14 |  | [NAME] | b | fs
15 |  | ea | v | ms
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Spreadsheet: 60602d1261105263-payroll-taxes-missyreiber
Sheet: 11.3%

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
 | 2009-01-09 00:00:00 | 2009-02-09 00:00:00 | 2009-03-09 00:00:00 | 2009-04-09 00:00:00 | 2009-05-09 00:00:00 | 2009-06-09 00:00:00 | 2009-07-09 00:00:00 | 2009-08-09 00:00:00 | 2009-09-09 00:00:00 | 2009-10-09 00:00:00 | 2009-11-09 00:00:00 | 2009-12-09 00:00:00 | YTD TOTAL | 1017
SMITH | 1017 |  |  |  |  |  |  |  |  |  |  |  | 1017 | 0
Spreadsheet: 671267d1586335475-update-defining-exact-length-of-string-for-istext-within-aggregate-function-00-wages-template-for-tests
Sheet: 06 SATURDAY

DAY: |  | SATURDAY |  | DATE:
No. |  | NAME |  |  |  | FROM | TO | Wh | VL | SL | OT | F/L | Hr | F/L | Hr | F/L | Hr | F/L | Hr | JOBS | Hr | GR/WS | Hr | CHECK |  | JOBS BREAKDOWN
12 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | GROUPAGE
11 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DRIVERS |  |  | DRIVERS
14 | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PART TIMERS |  |  | PART TIMERS
33 | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WELDERS |  |  | WELDERS
37 | W
27 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS
53 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS | HR | WD | PT | DR
54 | W
50 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
30 | P
31 | P
32 | P
51 | P
52 | P
55 | P
15 | P
23 | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REPAIRS MT
26 | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS | HR | WD | PT | DR
6 | D
10 | D
47 | D
[NAME] |  |  |  |  | GROUPAGE |  |  | IDLE TIME |  |  |  |  | JOBS |  |  |  | REPAIRS MT |  |  |  | WORKSHOP WS
JOBS |  |  | HR |  | JOBS | HR |  | JOBS |  |  | HR |  | JOBS |  | HR |  | JOBS |  | HR |  | JOBS |  | HR
TOTAL |  |  |  |  | TOTAL |  |  | TOTAL |  |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL
 |  |  |  |  | Hours Calculator |  |  |  |  |  |  |  |  |  |  | TOTAL 2 |  |  |  |  | TOTAL 1
Spreadsheet: 793594d1661555462-group-by-year-and-quarter-from-dynamic-array-date-sequence-year-and-quarter-dynamic
Sheet: Sheet1

2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00 | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00
 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00 | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00
 |  |  | Desired Result
 |  |  |  |  |  |  |  |  |  |  |  | Dynamic Range
2022 |  | 2023 |  |  |  | 2024
Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3
Assume if in the future, data has dates that starts below
 | 2022-12-31 00:00:00 | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00
 |  |  | Desired Result
2022 | 2023 |  |  |  | 2024
Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2
Spreadsheet: 99624d1298239769-vlookup-over-multiple-tabs-sheets-fund-raising-1-
Sheet: Vlaams Brabant

algemeen nr | nr | organisatie | bedrag | betaling | etc | commentaar | blabla |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
1 | [NAME] | test1 | tes2 | test3 | test4 | test5
7 | brabant2 | imec | 10000 euro | [NAME] | blab | blob | [NAME]
8 | brabant3 | jsdkf | fgkls | sdhfg | ksgj