tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 55419d1255533451-if-name-name-then-count-adjacent-cells-example
Sheet: Tracker

 |  |  | Week 23 |  |  | Week 24 |  |  | Week 25 |  |  | Week 26
 |  |  | number | -0.85 | 0 | number | -0.85 | 0 | number | -0.85 | 0 | number | -0.85 | 0
 |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | 2 | 1 | 0 | 1 | 0 | 0 | 3 | 0 | 1 | 1 | 0 | 0
 |  | [NAME] | 2 | 1 | 0 | 2 | 1 | 0 | 3 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | 2 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 2 | 1 | 0
 |  | [NAME] | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 1 | 0 | 0 | 3 | 0 | 0 | 3 | 2 | 0
 |  | [NAME] | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0
 |  | [NAME] | 2 | 2 | 0 | 2 | 0 | 1 | 3 | 0 | 0 | 1 | 0 | 0
 |  | [NAME] | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
 |  | Mercu Polant | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: kevin_hyatt__19604__Base Model 111601
Sheet: Cons. BS

Consolidated Balance Sheet
 | 2000-07-01 00:00:00 | Elim. | Pro Forma
ASSETS
Current Assets
Accounts & Notes Receivable
Assoc Co | -1535 | 0
Other | 2763 | 0
Employee | 7 | 0
Inventories | 27020 | 0
Materials & Supplies | 9110 | 0
Prepayments - other | 0 | 0
[NAME]. Other Current Assets | 10850 | 0
SUBTOTAL
Investments and Other Assets
PP&E | 102263 | 0
Accum. Dep. - PP&E | -19169 | 0
SUBTOTAL
Deferred Charges | 4875 | 0
TOTAL Assets
LIABILITIES & CAPITAL
Current Liabilities
Accounts Payable - Assoc Cos. | 0 | 0
Accounts Payable - Other | 6773 | 0
Income Taxes Payable | 43 | 0
Accrued Taxes | 2191 | 0
Deferred Income Taxes - Current | -11832 | 0
Other Misc Liability - Current | 0 | 0
SUBTOTAL
Deferred Credits & Other Liab.
Deferred Credits - Other | 0
Deferred Income Taxes | -52378 | 0
SUBTOTAL
Capital
Payable to/(Rec. from) Co 535 | 0 | 0
Payable to/(Rec. from) Corp | 575987 | 0
Capitalization | -384600 | 0
SUBTOTAL
TOTAL LIAB. & EQ.
Spreadsheet: 781690d1653491260-better-way-count-text-entries-specific-columns-multiple-sheets-thanks-sample-data-copy
Sheet: Table1

Value | Tech Feature 1 Status | Tech Feature 2 Status | Tech Feature 3 Status | Tech Feature 4 Status | Tech Feature 5 Status
Blcoked | 186 | 207 | 183 | 196 | 219
In Development | 220 | 196 | 200 | 211 | 173
No Interest | 188 | 215 | 206 | 210 | 223
Reviewing | 203 | 179 | 220 | 204 | 184
[NAME] | 203 | 203 | 191 | 179 | 201
Spreadsheet: 68103d1268667067-multiple-ifs-if-problem1
Sheet: Sheet1

 |  |  | Balance | Limit
 | 0 | ABC | 5345 | 900000000 |  |  | If STU balance is greater than zero, then STU Limit becomes 300,000 AND
 | 2 | DEF | 34534 | 900000010 |  |  | If STU balance is greater than zero, then DEF Limit gets reduced by 100,000 i.e. 900,000,010 less 100,000, else remains the same.
 | 0 | GHI | 345 | 900000020
 | 0 | JKL | 34534 | 900000030
 | 0 | MNO | 34534 | 900000040
 | 0 | PQR | 676 | 900000050
 | 1 | STU | 368 | 900000060
 | 0 | VWX | 907 | 900000070
 | 0 | YZA | 3467 | 900000080
 | 0 | BCD | 78 | 900000090
Spreadsheet: louise_kitchen__22669__DRIFT_BUDGET_2002_092801_ENA
Sheet: ENA TOTAL

ENA BUDGET DRIFT ANALYSIS FOR 2002
 | ENA TOTAL FOR USD |  |  | ENA |  | PREPAY - ENA |  | ENA TOTAL FOR CAD
 | (All) | (excl Prepay) |  |  |  |  |  | (in CND$) | (in USD$)
 | USD | USD |  | USD |  | USD |  | CAD | CAD
 | ERMS/MANUAL CF | ERMS/MANUAL CF |  | ERMS/MANUAL CF |  | ERMS/MANUAL CF |  | ERMS/MANUAL CF | ERMS/MANUAL CF
MTM Balance as of 9/10/2001 |  |  |  | 1142319578.34 |  | -1829330867.62 |  | 1955974812.7 | 1246971237.86
MTM FOR MONTH (after liquidations)
2002-01-31 00:00:00 |  |  |  | 821113614.32 |  | -1417966256.76 |  | 1812843388.71 | 1158231677.54
2002-02-28 00:00:00 |  |  |  | 831677436.98 |  | -1385044255.7 |  | 1727917643.82 | 1103971566.83
2002-03-31 00:00:00 |  |  |  | 610454925.18 |  | -1348435720.16 |  | 1635370581.2 | 1044843234.59
2002-04-30 00:00:00 |  |  |  | 577428308.38 |  | -1314004541.44 |  | 1588151229.12 | 1014674065.98
2002-05-31 00:00:00 |  |  |  | 612828253.84 |  | -1278267336.68 |  | 1537517769.78 | 982323921.3
2002-06-30 00:00:00 |  |  |  | 569573949.21 |  | -1243533030.1 |  | 1488035334.02 | 950709512.51
2002-07-31 00:00:00 |  |  |  | 593835083.65 |  | -1213125432.8 |  | 1437315148.72 | 918305604.05
2002-08-31 00:00:00 |  |  |  | 574499811.93 |  | -1182576790.66 |  | 1386400719.81 | 885778101.44
2002-09-30 00:00:00 |  |  |  | 559999204.57 |  | -1152882142.9 |  | 1335695675.64 | 853383999.5
2002-10-31 00:00:00 |  |  |  | 624571688.55 |  | -1122060147.68 |  | 1285211363.25 | 821130444.45
2002-11-30 00:00:00 |  |  |  | 660319306.4 |  | -1091746524.58 |  | 1278304425.82 | 816718313.98
2002-12-31 00:00:00 |  |  |  | 658236478.33 |  | -1060285338.86 |  | 1271939417.12 | 812651451.09
 | Total |  |  |  |  |  |  |  | Total (in CND$)
 | Monthly Average |  |  |  |  |  |  |  | Monthly Average
 | Estimate for 2002 from Books PV
 | ENA | 168889000 |  |  |  |  |  | 48575000
 | Monthly Average - adjusted
 | Average Rate (see Note 1) | 0.027029 |  |  |  |  |  | 0.033 | Average Rate (Bank of Canada),( see Note 2)
 | Estimated Drift USD |  |  |  |  |  |  |  | Estimated Drift (in CND$)
 |  |  |  |  |  |  |  | 1.573 | FX Forward Conversion Rate
 | Canada (in USD) |  |  |  |  |  |  |  | Estimated Drift (in USD)
 | Estimated Drift All Currencies
 | Allocatable Drift
 | Hedge Book
 | 3 mo Rho
 | Broker Fee
 | [NAME]
 | TOTAL ESTIMATED DRIFT
 | 2002 Estimate | 50000000
 | 2002 Estimate per month | 4100000
 | 2002 Estimated Costs:
 | Directs 2002 Plan | 1923989.662850781
 | Indirect Estimated | 1497242.4329373
 | TOTAL ESTIMATED COSTS
Drift as of 8/31/2001 |  | 122.638 | (Note:  Include other Business Units and Drift vs Benchmark
Estimate  for 2001 |  |  | benefit in 1st QTR 2001.)
Note 1: |  |  |  |  |  |  |  | Note 2:
Average Rate Methodology: |  |  |  |  |  |  |  | Average Rate Methodology:
Avergae 1 mo libor future, CME, contract market yields for 2001 |  | 2.9229 |  |  |  |  |  | Average 3 [NAME] contract 2002 | 3.42
[NAME] yield to bid rate (reduce by 2 bp) |  | 2.9029 |  |  |  |  |  | Basis adjustment | 0.12
Subtract basis to Fed Funds (spread FF vs. Libor) |  | 0.2
 | Average rate for 2002
Spreadsheet: 842962d1694950939-value-error-sumproduct-kitap1
Sheet: Sayfa1

 |  |  |  |  |  |  |  |  | 0.4 | 0.1 |  | Score |  | [NAME] | YoY | [NAME] TTM | YoY TTM | [NAME] | YoY | [NAME] TTM | YoY TTM
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.02694455970283208 | -0.1416778560892137 | -0.04321322175124213 | 0.210383588714528 | 0.8932749585011096 | 0.5113412160849903 | 0.09637233215603855 | 1.404718749405738
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.05986314662693218 | -0.175793949784986 | -0.04648747167657264 | 0.630779432749068 | -0.2496477283411366 | 0.4392065165289656 | 0.09990550190884888 | 0.6455723331820432
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.2051435802777134 | 0.3109717265257388 | 0.05562037709261162 | 0.8245474361445592 | -0.04829397287707438 | 1.115458336697263 | 0.1625251377882687 | 1.203996689711348
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.6179551604391345 | -0.4373267714049447 | -0.2058512529735878 | -0.7018520493038887 | -0.06498760241578137 | 1.367458564198605 | 0.1675588185870172 | 2.197723576743469
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.2836929381737631 | 0.249999100597804 | 0.04661407060351027 | 0.6018240933180152 | 0.6412747688324777 | 2.146968824818696 | 0.3003076365606185 | 2.417747267453312
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.1690943059179466 | 1.196652960268801 | 0.1697374033221363 | 2.033492622923888
Spreadsheet: 222040d1363733641-reduce-1-minute-data-to-30-minute-data-in-excel-5-minutes-to-30-minutes
Sheet: Sheet1

 |  | What I Have |  |  |  |  |  |  |  |  |  |  | What I want to achieve
 | TIMESTAMP | WindSpeed | WindDirect | Air_temperature | RH | Pyranometer_Avg | Reference1_Avg | [NAME] | Month | Day |  |  | TIMESTAMP | WindSpeed | WindDirect | Air_temperature | RH | Pyranometer_Avg | Reference1_Avg | [NAME] | Month | Day
 | 2012-12-11 04:05:00 | 3.4 | 180.1 | 9.4 | 71.6 | 453 | 435 | 354 | 12 | 11 |  |  | 11/12/2012 4.30
 | 2012-12-11 04:10:00 | 4 | 177.4 | 9.5 | 70.4 | 450 | 345 | 345 | 12 | 11 |  |  | 11/12/2012 5.00
 | 2012-12-11 04:15:00 | 4.7 | 177.6 | 9.6 | 70.5 | 435 | 654 | 345 | 12 | 11
 | 2012-12-11 04:20:00 | 4.7 | 178.3 | 9.6 | 71.1 | 756 | 345 | 567 | 12 | 11
 | 2012-12-11 04:25:00 | 4.3 | 176.2 | 9.8 | 72.2 | 656 | 656 | 567 | 12 | 11
 | 2012-12-11 04:30:00 | 4.4 | 172.8 | 9.7 | 70.9 | 543 | 656 | 786 | 12 | 11
 | 2012-12-11 04:35:00 | 4.3 | 171.9 | 9.8 | 70.4 | 435 | 435 | 456 | 12 | 11
 | 2012-12-11 04:40:00 | 3.5 | 167.5 | 9.6 | 71.9 | 463 | 366 | 675 | 12 | 11
 | 2012-12-11 04:45:00 | 3 | 162.9 | 9.6 | 71.3 | 354 | 756 | 765 | 12 | 11
 | 2012-12-11 04:50:00 | 3.7 | 175.5 | 9.6 | 71.6 | 654 | 456 | 568 | 12 | 11
 | 2012-12-11 04:55:00 | 4.4 | 176.1 | 9.8 | 71.6 | 645 | 345 | 676 | 12 | 11
 | 2012-12-11 05:00:00 | 4.4 | 172.6 | 9.6 | 71.7 | 345 | 355 | 456 | 12 | 11
Spreadsheet: 377374d1423932116-function-formula-to-take-multiple-entries-from-a-table-and-combine-data-safety
Sheet: Sheet1

Name | Year | Response
[NAME] | 2013 | Medical |  | Name | Year | Response
George | 2013 | First aid |  | [NAME] | 2014 | Hospitalized
[NAME] | 2014 | Hospitalized |  | George | 2013 | First aid
[NAME] | 2014 | First aid |  | [NAME] | 2013 | Medical
 |  |  |  |  | 2014 | First aid
Spreadsheet: 7f4f71ab-4fec-4148-9937-9f21486049fa
Sheet: 11c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Cross-Currency Basis | 47 | 14 | 72 | 94 | 181 | 131 | 127 | 13 | 679
Cross-Currency Fixed-Fixed | 14 | 0 | 11 | 4 | 16 | 14 | 13 | 0 | 72
Cross-Currency Fixed-Float | 8 | 6 | 64 | 77 | 87 | 52 | 7 | 0 | 301
TOTAL | 69 | 20 | 147 | 175 | 284 | 197 | 147 | 13 | 1052
Spreadsheet: 801618d1666273901-get-another-result-directly-from-two-tables-without-auxiliary-columns-help10-20-3-
Sheet: Sheet2

 | TABLE A |  |  |  |  |  | TABLE B | nation | Asia | Americas | Europe | Japan | Korea
 | salesman |  | nation |  | Amount | Helper column |  | discount factor | 0.1 | 0.06 | 0.08 | 0.03 | 0.12
 | A |  | Asia |  | 100
 | B |  | Americas |  | 200
 | C |  | Japan |  | 300 |  |  | salesman | Amount after discount |  |  | Amount
 | D |  | Europe |  | 400 |  |  | A |  |  | A | 7789
 | E |  | Korea |  | 500 |  |  | B |  |  | B | 8162
 | F |  | Asia |  | 600 |  |  | C |  |  | C | 8800
 | G |  | Japan |  | 700 |  |  | D |  |  | D | 9180
 | H |  | Asia |  | 800 |  |  | E |  |  | E | 9735
 | A |  | Americas |  | 900 |  |  | F |  |  | F | 10384
 | B |  | Japan |  | 1000 |  |  | G |  |  | G | 10786
 | C |  | Europe |  | 1100 |  |  | H |  |  | H | 11016
 | D |  | Korea |  | 1200
 | E |  | Asia |  | 1300
 | F |  | Japan |  | 1400
 | G |  | Asia |  | 1500
 | H |  | Americas |  | 1600
 | A |  | Japan |  | 1700
 | B |  | Europe |  | 1800
 | C |  | Korea |  | 1900
 | D |  | Asia |  | 2000
 | E |  | Japan |  | 2100
 | F |  | Asia |  | 2200
 | G |  | Americas |  | 2300
 | H |  | Japan |  | 2400
 | A |  | Europe |  | 2500
 | B |  | Korea |  | 2600
 | C |  | Asia |  | 2700
 | D |  | Japan |  | 2800
 | E |  | Asia |  | 2900
 | F |  | Americas |  | 3000
 | G |  | Japan |  | 3100
 | H |  | Europe |  | 3200
 | A |  | Korea |  | 3300
 | B |  | Asia |  | 3400
 | C |  | Japan |  | 3500
 | D |  | Asia |  | 3600
 | E |  | Americas |  | 3700
 | F |  | Japan |  | 3800
 | G |  | Europe |  | 3900
 | H |  | Korea |  | 4000
Spreadsheet: 147108d1332526856-value-with-dget-figuring-out-dget
Sheet: Rate

Vendor | Classification | Vendor Classification | ST Rate | OT Rate
Vendor A | Assistant | Vendor A Assistant | 50 | 75
Vendor A | Safety | Vendor A Safety | 50 | 75
Vendor B | Roustabout | Vendor B Roustabout | 70 | 105
Vendor B | Electrician | Vendor B Electrician | 65 | 90
Vendor B | Apprentice | Vendor B Apprentice | 80 | 120
Vendor B | Supervisor | Vendor B Supervisor | 90 | 150
Spreadsheet: 85888d1285886886-excel-question-i-cant-word-xr_254
Sheet: Sheet10

Scores | Winner |  |  |  |  |  | Enter Scores Here
 |  |  |  |  |  |  | Saints | 5 | Colts | 10
 |  |  |  |  |  |  | Buccs | 0 | Steelers | 14
 |  |  |  |  |  |  | Bears | 17 | [NAME] | 17
 |  |  |  |  |  |  | [NAME] |  | Cowboys
Spreadsheet: 19f771e9-7a95-4dd9-b461-3b97d6d97c05
Sheet: 9c

Product | AUD** | CAD | CHF | DKK | KRW | NOK | NZD | SEK | ZAR | TOTAL
Basis* | 65284 | 54011 | 137190 | <1,000 |  |  |  |  |  | 256485
FRA |  |  | 359772 | 105562 |  | 259125 |  | 736000 |  | 1460459
IRS- [NAME] | 2072927 | 2088911 | 1296565 | 96299 |  | 245497 | 435171 | 821528 | 399399 | 7456297
OIS |  | 173635 | 73654 |  |  |  |  |  |  | 247289
VNS
Zero Coupon |  | <1,000 |  |  |  |  |  | <1,000 |  | <1,000
TOTAL | 2138211 | 2316557 | 1867181 | 201861 |  | 504622 | 435171 | 1557527 | 399399 | 9420529
Estimated gross notional amount outstanding, January 4 weekly snapshot, by product type and supermajor currency (millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
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 currency 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: 552482d1513607841-index-match-formula-not-returning-expected-result-example2
Sheet: Formulas

 | Time/ Day checking formulas |  |  |  |  | Temperature |  |  |  |  |  |  |  |  | Rainfall |  |  |  |  | Sunshine |  |  |  | Last year |  |  | LTA's |  |  |  |  | Weatherlink summary
Date | 09 Tx/R/Rd | 09 Tn/Fd | 0-24 |  | Date | 09 Day Mean | 09 Rolling Tx | 09 Rolling Tn | 09 Rolling T | 09 Rolling T vs LTA | 09 T vs LTA | Civil Integrated Temp vs LTA | Civil Integrated Rolling T vs LTA | Civil Integrated Rolling T | 09 Rolling Rain | 09 Rolling Rain vs LTA % | 09 Rolling Rain vs LTA Expected | Civil Rolling Rain | Civil Rolling Rain vs LTA % | Rolling Sun | Rolling Sun vs LTA % | Rolling Sun vs LTA Expected |  | Civil Rolling Integrated Temp | Civil Rolling Rain |  | T | R | S | Month length
1 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11.9 | 63.8 | (insert) | 31
2 |  |  |  |  | 2
3 |  |  |  |  | 3
4 |  |  |  |  | 4
5 |  |  |  |  | 5
6 |  |  |  |  | 6
7 |  |  |  |  | 7
8 |  |  |  |  | 8
9 |  |  |  |  | 9
10 |  |  |  |  | 10
11 |  |  |  |  | 11
12 |  |  |  |  | 12
13 |  |  |  |  | 13
14 |  |  |  |  | 14
15 |  |  |  |  | 15
16 |  |  |  |  | 16
17 |  |  |  |  | 17
18 |  |  |  |  | 18
19 |  |  |  |  | 19
20 |  |  |  |  | 20
21 |  |  |  |  | 21
22 |  |  |  |  | 22
23 |  |  |  |  | 23
24 |  |  |  |  | 24
25 |  |  |  |  | 25
26 |  |  |  |  | 26
27 |  |  |  |  | 27
28 |  |  |  |  | 28
29 |  |  |  |  | 29
30 |  |  |  |  | 30
31 |  |  |  |  | 31
Spreadsheet: 66923d1267605393-excel-2007-formulae-to-count-matching-adjacent-cells-example-with-amounts
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  |  |  |  |  | Letter | Number | Amount
A |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | 1 | 5
B |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | 2 | 2
C |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | 3 | 47
D |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | 4 | 85.85
E |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | 5 | 659
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | 3 | 0.32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | 1 | 0
Count of Number | Column Labels |  |  |  |  |  | Sum of Amount | Column Labels |  |  |  |  |  |  | B | 2 | 2
Row Labels | 1 | 2 | 3 | 4 | 5 | Grand Total | Row Labels | 1 | 2 | 3 | 4 | 5 | Grand Total |  | B | 4 | 55.3
A | 1 | 1 | 1 | 1 | 1 | 5 | A | 5 | 2 | 47 | 85.85 | 659 | 798.85 |  | C | 1 | 100
B |  |  | 1 |  |  | 1 | B | 0 | 2 | 55 | 55.3 |  | 112.3 |  | C | 1 | 85
C | 2 |  |  | 1 | 2 | 5 | C | 185 |  |  | 65 | 10847 | 11097 |  | C | 4 | 65
D |  | 2 | 2 | 1 |  | 5 | D |  | 1248 | 21 | 0 |  | 1269 |  | C | 5 | 1000
E | 1 | 1 |  | 1 | 1 | 4 | E | 68.2 | 510 |  | 0 | 9 | 587.2 |  | C | 5 | 9847
Grand Total | 4 | 4 | 4 | 4 | 4 | 20 | Grand Total | 258.2 | 1762 | 123 | 206.15 | 11515 | 13864.35 |  | D | 1 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 2 | 300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 2 | 52
Count of Number | Column Labels |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 2 | 948
Row Labels | 1 | 2 | 3 | 4 | 5 | Grand Total |  |  |  |  |  |  |  |  | D | 3 | 21
A | 1 | 1 | 1 | 1 | 1 | 5 |  |  |  |  |  |  |  |  | D | 4 | 9652
B |  |  | 1 |  |  | 1 |  |  |  |  |  |  |  |  | D | 4 | 0
B | 1 | 1 |  | 1 |  | 3 |  |  |  |  |  |  |  |  | E | 1 | 68.2
C | 2 |  |  | 1 | 2 | 5 |  |  |  |  |  |  |  |  | E | 2 | 510
D | 1 | 3 | 1 | 2 |  | 7
E | 1 | 1 |  |  |  | 2
Grand Total | 6 | 6 | 3 | 5 | 3 | 23
Spreadsheet: 794611d1662139688-excel-online-with-power-query-stop-prompt-fy23-4116-tracker-1-
Sheet: FY23 FCL Monitor Tracking

 | OH |  |  |  |  |  |  |  | Cost Allocation |  | Accounts Payable |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Duration
Tracking Number | [NAME] | Vendor ID | Amount | Description (Invoice for Translations) | Contract Number | Month of Service Received Date for Translations | Date to BA | Coded By | Date to AP | Comments or [NAME] to [NAME] | Voucher Number | COMPLETED DATE | STATUS | Dupe Checker |  |  |  |  |  |  |  |  |  |  |  |  |  | Public Catalyst | 1263119454
FY23FCM001 | Public Catalyst |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Texas Appleseed | 1742804268
FY23FCM002
FY23FCM003
FY23FCM004
FY23FCM005
FY23FCM006
FY23FCM007
FY23FCM008
FY23FCM009
[NAME]
FY23FCM011
FY23FCM012
FY23FCM013
FY23FCM014
FY23FCM015
FY23FCM016
FY23FCM017
FY23FCM018
FY23FCM019
FY23FCM020
FY23FCM021
FY23FCM022
FY23FCM023
FY23FCM024
FY23FCM025
FY23FCM026
FY23FCM027
FY23FCM028
FY23FCM029
[NAME]
FY23FCM031
FY23FCM032
FY23FCM033
FY23FCM034
FY23FCM035
FY23FCM036
FY23FCM037
FY23FCM038
FY23FCM039
FY23FCM040
FY23FCM041
FY23FCM042
FY23FCM043
FY23FCM044
FY23FCM045
FY23FCM046
FY23FCM047
FY23FCM048
Spreadsheet: 852593d1702572917-need-help-getting-this-formula-to-pull-date-from-c2-and-everything-before-scheduling-12132023
Sheet: TAURO 2

T2 |  | Total hours |  |  |  |  | 2023-11-30 00:00:00 |  | 11:59:19
Time to Print | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due_Date | Est. usage | PRESS | Notes
 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | 8 Pass | 2024-01-15 00:00:00 |  | T2 | For production quote- [NAME]
 | 819 | 67.1-R | SURL | 20 | 22 | 22 | PAP-SO-1354 - ULTRABOARD 3/16IN WHITE 48X96 | 2 | 4 Pass | 2023-12-01 00:00:00 |  | T2
 | 819 | 134.1-R | SURL | 7 | 52 | 10 | PAP-SO-1354 - ULTRABOARD 3/16IN WHITE 48X96 | 2 | 4 Pass | 2023-12-01 00:00:00 |  | T2
 | 242778 | 2 | Equestrian Sports Productions LLC | 6999 | 8 | 6 | PAP-444450 - 48X96 30PT STYRENE | 1 | 4 Pass | 2023-12-01 00:00:00 |  | T2
 | 242697 | 1 | Perfect Promotions | 10 | 36 | 24 | PAP-SO-0016 - 48X96 COROPLAST | 2 | 4 Pass | 2023-12-01 00:00:00 |  | T2
 | 242684 | 1 | Wompas Graphix | 18 | 22 | 16 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 1 | 4 Pass | 2023-12-01 00:00:00 |  | T2
Spreadsheet: 165791d1341340053-vlookup-wanting-2nd-3rd-occurrence-etc-occurrences
Sheet: .25

Availability Exceptions by Date | Dates affected:  1/1/2012 to 7/31/2012 | [NAME] |  | 2012-05-22 00:00:00 | Off (.25) from 12:30PM -  9:00PM; source: One-click (Sick or Other) |  | Report template modified: 6/12/2012 | 1 | 2012-06-12 00:00:00
Availability Exceptions by Date | Dates affected:  1/1/2012 to 7/31/2012 | [NAME] |  | 2012-06-04 00:00:00 | Off (.25) from  8:00AM -  4:30PM; source: One-click (Sick or Other) |  | Report template modified: 6/12/2012 | 1 | 2012-06-12 00:00:00
Availability Exceptions by Date | Dates affected:  1/1/2012 to 7/31/2012 | [NAME] |  | 2012-06-04 00:00:00 | Off (.25) from  8:00AM -  4:30PM; source: One-click (Sick or Other) |  | Report template modified: 6/12/2012 | 1 | 2012-06-12 00:00:00
Availability Exceptions by Date | Dates affected:  1/1/2012 to 7/31/2012 | [NAME] |  | 2012-06-05 00:00:00 | Off (.25) from  8:00AM -  4:30PM; source: One-click (Sick or Other) |  | Report template modified: 6/12/2012 | 1 | 2012-06-12 00:00:00
Availability Exceptions by Date | Dates affected:  1/1/2012 to 7/31/2012 | [NAME] |  | 2012-06-06 00:00:00 | Off (.25) from  8:00AM -  4:30PM; source: One-click (Sick or Other) |  | Report template modified: 6/12/2012 | 1 | 2012-06-12 00:00:00
Availability Exceptions by Date | Dates affected:  1/1/2012 to 7/31/2012 | [NAME] |  | 2012-06-11 00:00:00 | Off (.25) from  9:00AM -  9:30AM; source: One-click (Sick or Other) |  | Report template modified: 6/12/2012 | 1 | 2012-06-12 00:00:00
 |  | [NAME] |  | 2012-05-27 00:00:00
Spreadsheet: 109233d1306161192-indirect-help-example-1-
Sheet: Summary

March | Validation here |  | 2001-03-01 00:00:00 |  |  | 2001-02-01 00:00:00 |  |  | 2001-01-01 00:00:00
Account Number | Account Name | Country | Total Market Value | Cash  Value | % Cash | Total Market Value | Cash  Value | % Cash | Total Market Value | Cash  Value | % Cash
111 | Murphy | UK | 550 | 70 | 0.1272727272727273 | 110 | 70 | 0.6363636363636364 | 100 | 10 | 0.1
5555 | Jones | AUS | 600 | 250 | 0.4166666666666667 | 300 | 200 | 0.6666666666666666 | #N/A | #N/A | #N/A
333 | Smith | SCO | 750 | 200 | 0.2666666666666667 | 500 | 150 | 0.3 | 200 | 30 | 0.15
 |  |  |  |  |  |  |  |  |  |  | January
 |  |  |  |  |  |  |  |  |  |  | February
 |  |  |  |  |  |  |  |  |  |  | March
 |  |  |  |  |  |  |  |  |  |  | April
 |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  | June
 |  |  |  |  |  |  |  |  |  |  | July
 |  |  |  |  |  |  |  |  |  |  | August
 |  |  |  |  |  |  |  |  |  |  | September
 |  |  |  |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  |  | December
Spreadsheet: 63943d1264791933-employees-project-report-summary-explain-new
Sheet: Danny

Here where the description is the employees will be putting the name of the project that they are working on and every week they will be using a different spreadsheet (some examples are displayed below) They will be located between A13:A18 in all worksheets and workbooks. | in this column the employee will put the amount of hours that had to spent on Monday on the projects | in this column the employee will put the amount of hours that had to spent Tuesday on the projects | in this column the employee will put the amount of hours that had to spent On Wedn on the projects | in this column the employee will put the amount of hours that had to spent on thursday on the projects | in this column the employee will put the amount of hours that had to spent on Friday on the projects | In the final colom will be the total of the amount of hours that was spent for a project for a week. This sum will be located ONLY on G13:G18 in all the worksheets and workbooks
[NAME]
Description |  |  |  |  |  | Total Hours per project
 | Hours | Hours | Hours | Hours | Hours
 | Monday | Tuesday | Wednesday | Thursday | Friday
CR002 | 2 |  | 2 |  | 5 | 9 | this number in cell G13 tells us that [NAME] spent 9 hours in total on project CR002 for this week
CR001 | 3 | 3 | 4 | 2 | 2 | 14 | this number in cell G14 tells us that [NAME] spent 14 hours in total on project CR001 for this week
CR006 |  | 1 | 1 | 4 |  | 6 | this number in cell [NAME] tells us that Dany spent 6 hours in total on project CR006 for this week
CR010 | 3 | 2 |  | 3 | 1 | 9 | this number in cell G16 tells us that [NAME] spent 9 hours in total on project CR0010 for this week
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0