tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 746832d1631057240-excel-to-return-lookup-value-besides-the-first-matching-value-data-table-tms
Sheet: Data (2)

KeyWord Deep Dive | Notes | [NAME]
Billing Explanation | breakdown of the charges |  | Total | %
Make payment |  | >>Disconnect<<
Transfer Services to Address |  | Can No Longer Afford |  |  |  |  |  |  | =IFERROR((D4-ROW()/[PHONE])/$C$2," ")
Return Shipping Label |  | Switch to Competitor
Can No Longer Afford | Offered a lower rate but decided to cancel still | Customer Care Issue
Phone Issues | Unable to connect call | Doesn't use enough
Transfer Services to Address |  | Port-Out |  |  |  |  |  |  | Transfer Services to Address | 3 | 0.1199999999924
Updating Payment |  | Promotion Ended |  |  |  |  |  |  | Updating Payment | 2 | 0.0799999999864
Renew Value Plan | VP expiring and requesting to renew | Technical Issues |  |  |  |  |  |  | Can No Longer Afford | 1 | 0.0399999999984
Billing Explanation |  | Customer Declined to say |  |  |  |  |  |  | Switch to Competitor | 1 | 0.039999999998
Transfer Services to Address |  | Deceased
Billing Explanation |  | Moving - Services Included |  |  |  |  |  |  | =IF($L7:$L11="","",XLOOKUP($L7:$L11,$E:$E,$C:$C))
Cable Issues |  | Moving - Secondary Address |  |  |  |  |  |  |  | =IF($L7:$L11="","",XLOOKUP($L7:$L11,$E:$E,$D:$D))
Credit(s) | Refund process | Partial Disconnect |  |  |  |  |  |  |  |  | =UNIQUE(TRANSPOSE(LARGE($E:$E,{1,2,3,4,5})))
[NAME] |  | >>Moving<<
Wifi Speed/Connection | Slow | Moving Outside Footprint
Update Account Information |  | Moving to [NAME]
Updating Payment | Scam email to provide credit card information | Transfer Services to Address
Moving - Services Included |  | >>Technical<<
Switch to Competitor |  | Wifi Speed/Connection
Pricing/Plan Inquiry | customer have legacy INT and CBL svc inquired about upgrading all | Cable Issues
[NAME] | Signed up new VP this morning and has some questions | Phone Issues
Billing Explanation |  | Appointments
Partial Disconnect | Inquiried about cancelling home phone | MyShaw/Email
Account Balance |  | Return Shipping Label
 |  | Equipment Swap
 |  | Additional Equipment
 |  | >>Billing/Account<<
 |  | Billing Explanation
 |  | Payment Arrangement
 |  | Report Payment
 |  | Make Payment
 |  | Updating Payment
 |  | Update Account Information
 |  | Account Balance
 |  | Credit(s)
 |  | CC Reversals
 |  | UEF / Return Equipment Procedures
 |  | >>Package Changes<<
 |  | Add Channel
 |  | [NAME]
 |  | Downgrade Internet
 |  | Downgrade TV
 |  | Upgrade Internet
 |  | Upgrade TV
 |  | Renew Value Plan
 |  | Sign New Value Plan
 |  | Pricing/Plan Inquiry
 |  | New RGU
 |  | Home Phone Add On
 |  | >>Value Plan & Promotions<<
 |  | Promotion/VP Ending
 |  | [NAME]
 |  | Competitor [NAME]
 |  | Seeking Offers/Promotions
 |  | Marketing Offer
 |  | >>Mobile<<
 |  | Pricing/Plan Inquiry
 |  | SIM Activation
 |  | >>Other<<
 |  | TCIS
 |  | Non Related
 |  | Direct
 |  | Business
Spreadsheet: 156421d1337282635-reformatting-data-rearangeexample
Sheet: Sheet2

CH28625 | HY24066
CH28625 | [NAME]
CH28625 | SA159
CH28625 | HP1526
CH28625 | SA207
HYM2478 | [NAME]
HYM2478 | HYM4071
HYM2478 | HYM3515
HYM2478 | MB-13418
HYM2478 | HYM3470
HYM2478 | HYM3514
HYM2478 | MB-17453
HYM2478 | HYM3471
HYM2478 | M430-4
HYM2478 | AD-11CDA140
HYM2478 | BT-58354
HYM2478 | MB-13477
HYM2478 | MB-149866
HYM2478 | MB-149691
HYM2478 | MB-13813
M430-4 | HYM2478
M430-4 | MB-13477
M430-4 | MB-31378
M430-4 | MB-13813
M430-4 | MB-33536
M430-4 | DE-1441
HYH4793 | HY10415
HYH4793 | MB-39893
HYH4793 | SA196
[NAME] | M314-3
[NAME] | MB-31378
[NAME] | HYM3515
[NAME] | MB-27166
[NAME] | MB-13418
[NAME] | DE-1441
Spreadsheet: 137948d1327440322-help-creating-a-custom-bar-graph-columns-erosenzweig
Sheet: Tabelle1

 |  | Y-Pos | X-Pos |  | [NAME] |  |  | Lower Line
Lines | [NAME] | 3400 | 0.8 |  | 0.8 | 3400 |  | 0.8 | 600
 | Lower Line | 600 | 5.2 |  | 5.2 | 3400 |  | 5.2 | 600
 |  | Period 1 | Period 2 | Period 3 | Period 4 | Period 5
Columns | Upper columns | 1200 | 800
 | White 2 | 600 | 1300 | 2800 | 2800 | 2800
 | Lower columns | 1000 | 700
 | White 1 | 600 | 600 | 600 | 600 | 600
 |  | 3400 | 3400 | 3400 | 3400 | 3400
Spreadsheet: 329186d1404223927-pivot-table-to-split-product-combinations-by-age-and-gender-testdata
Sheet: Results

PersonKey | [NAME] | Gender | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | [NAME] | Column9 | Column10 | Column11 | Column12 | Column13 | Starbar | Column14 | Galaxy | Lion Bar | Bounty | Age
1 | 45 to 54 | Female |  |  |  |  |  |  |  |  | No | Yes |  |  |  |  | No |  | Yes | Yes | No | 46
2 | 25 to 34 | Female |  |  |  |  |  |  |  |  | No | Yes |  |  |  |  | No |  | No | Yes | No | 29
3 | 25 to 34 | Female |  |  |  |  |  |  |  |  | No | No |  |  |  |  | No |  | No | Yes | No | 32
4 | 45 to 54 | Male |  |  |  |  |  |  |  |  | No | No |  |  |  |  | No |  | No | Yes | No | 50
5 | 35 to 44 | Male |  |  |  |  |  |  |  |  | No | Yes |  |  |  |  | No |  | Yes | Yes | No | 40
6 | 45 to 54 | Male |  |  |  |  |  |  |  |  | No | Yes |  |  |  |  | No |  | Yes | Yes | No | 47
7 | 45 to 54 | Female |  |  |  |  |  |  |  |  | No | Yes |  |  |  |  | No |  | Yes | Yes | No | 46
8 | 25 to 34 | Male |  |  |  |  |  |  |  |  | No | Yes |  |  |  |  | Yes |  | No | Yes | No | 32
9 | 35 to 44 | Male |  |  |  |  |  |  |  |  | No | Yes |  |  |  |  | No |  | No | No | No | 40
10 | 45 to 54 | Male |  |  |  |  |  |  |  |  | No | No |  |  |  |  | No |  | No | Yes | No | 50
In this example the output would tell me, for example, that there were:
2 women aged 45-54 who bought only a galaxy and a lion bar
2 men aged 45 - 54 who bought only a Lion bar
1 man aged 35 to 44 who bought nothing
And so on
Spreadsheet: 1baf99b2-21d6-400f-979b-783c0e322e3e
Sheet: Sheet1

Table 8--Wheat: U.S. exports and imports for last 6 months (1,000 bushels), 1/12/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Item |  | May | Jun | Jul | Aug | Sep | Oct
 |  | 2012 | 2012 | 2012 | 2012 | 2012 | 2012
Exports | All wheat grain | 102576.0726739014 | 89731.37261877392 | 70377.77155656241 | 97248.6689412 | 92915.3483382789 | 51750.87508381141
 | All wheat flour 1/ | 1527.901404826926 | 1263.825520116423 | 1883.098685740204 | 1615.886072095429 | 1790.48626972765 | 1236.396968887244
 | All wheat products 2/ | 975.2385292682455 | 617.8757592016249 | 1064.223300294469 | 630.5064939102352 | 545.6232307236927 | 644.7809153039525
 | Total all wheat | 105079.2126079966 | 91613.07389809197 | 73325.09354259708 | 99495.06150720567 | 95251.45783873025 | 53632.05296800261
Imports | All wheat grain | 4186.141397718001 | 4726.423628526601 | 3406.263346521001 | 10035.1178733687 | 8477.141599059001 | 9056.6771613213
 | All wheat flour 1/ | 867.4603488933402 | 793.2286682783292 | 737.0236550466669 | 841.0864013899777 | 793.5219590358631 | 881.3723790348241
 | All wheat products 2/ | 1677.292165589732 | 1397.121265980523 | 1580.670109451776 | 1521.875549865195 | 1278.41436829258 | 1614.102198101327
 | Total all wheat | 6730.893912201074 | 6916.773562785455 | 5723.957111019446 | 12398.07982462388 | 10549.07792638744 | 11552.15173845745
Totals may not add due to rounding. [NAME] in grain-equivalent bushels. Includes meal, groats, and durum. 2/ Expressed in grain-equivalent bushels. Includes bulgur, couscous, and selected categories of pasta. Source: U.S. Department of Commerce, U.S. Census Bureau, Foreign Trade Statistics; and ERS calculations using Census trade statistics.
Date run: 1/12/2013
Spreadsheet: e4f3c2ec-1c19-4cd3-b7f6-5d845e469d35
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42496455 | 2014-07-28 23:57:29 | ALLIES | 1 | 6 | 3 | 542819 | Didorapido | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
42496624 | 2014-07-29 00:16:57 | AXIS | 1 | 6 | 4 | 542819 | Didorapido | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
Spreadsheet: daren_farmer__6607__buydef
Sheet: Sheet1

BUYBACK & DEFICIENCY DEALS
 |  |  |  | Buyback | Type
Counterparty | Undertake | Sale | Swing | K # | of deal | Term | [NAME] | VM
AirProducts, Inc. | 122218 | 120265 | 122216 | 96023739 | Deficiency | 10/1/99-9/30/00 | 1418
Air Liquide America | 131605 | 131603 |  | 9600847 | Buyback | 12/1/99-1/31/00 | 8001
BASF Corporation | 133000 | 120266 | 122310 | 96022419 | Buyback | 11/1/99-10/31/01 | 1437
Bayer Corporation | 155328 | 155322 |  | 96018711 | Buyback | February | 1550/8056 | Fred
Bayer Corporation | 204763 | 204759 |  | 96018711 | Buyback | March | 1550/8056 | Fred
Beaumont Methanol Limited Partnership |  | 93199 |  | 96019675 | Deficiency | 1/1/00-6/30/00 | 1428 | [NAME]
[NAME] | 140200 | 123440 | 140197 | 96022409 | Buyback | 11/1/99-3/31/00 | 1505
[NAME] | 140200 | 123445 | 140197 | 96022409 | Buyback | 4/1/00-9/30/00 | 1505
Chevron Chemical Co | 138614 | 116494 | 119166 | 96022420 | Deficiency | 1/1/00-3/31/00 | 1024 | Fred
[NAME] | 139070 | 139066 | 139068 | 96018826 | Buyback | 1/1/00-12/31/00 | 8216 | Fred
Enron Methanol Co | 139058 | 139055 | 139057 | 96018827 | Buyback | 1/1/00-12/31/00 | 8291 | Fred
Equistar Chemicals LP | 92860 | 92864 |  | 96000240 | Buyback | 7/1/99 - 1/31/00 | 1373/1384/1552/1553 | [NAME]
Equistar Chemicals LP | 156342 | 156337 |  | 96000240 | Buyback | 2/1/00 - 1/31/01 | 1373/1384/1552/1553 | [NAME]
Formosa Hydrocarbons | 92881 | 92872 | 92876 | 96000517 | Buyback | 7/1/99-7/31/00 | 1000/1383 | [NAME]
Global Octanes Corp | 137991 | 92886 | 92887 | 96019673 | Deficiency | 1/1/00-8/31/00 | 1528 | Thu
Lyondell-Citgo | 147729 | 147092 |  | 96008792 | Buyback | 2/1/00-12/31/00 | 1063
Marathon-Ashland | 93371 | 119068 |  | 96019644 | Buyback | 12/1/99-9/30/00 | 1431
Petrofina Gas Pipeline | 131356 | 131348 |  | 96019331 | Buyback | 12/1/99-3/31/00 | 1484
Rohm & Haas | 156867 | 156826 |  | 96019546 | Buyback | February | 1506 | Thu
Rohm & Haas | 205358 | 205353 |  | 96019546 | Buyback | March | 1506 | Thu
Shell Oil Co. | 138086 | 130133 | 93180 | 96019720 | Buyback | 1/1/00-7/31/00 | 1060/1061/1095/1581 | [NAME]
Union Carbide | 63576 | 15765 | 34825 | 96019676 | Deficiency | 2/1/99-12/31/01 | 1308 | [NAME]
Union Carbide | 63573 |  | 34832 | 96019676 | Deficiency | 1/1/00-12/31/01 | 1332 | Fred
Valero Marketing & Supply | 127304 | 119065 |  |  | Buyback | 11/1/99-9/30/00 | 8018/1394/1233/591-353
Spreadsheet: 105696d1302971371-running-totals-example
Sheet: Sheet1

Balance Sheet March 2010
ASSETS |  | LIABILITIES |  | Name | Subs | RF | Clothing | Car | Col
Bank Account |  | Catering |  | A
 |  | Rent |  | B
 |  |  |  | C
 |  |  |  | D
 |  |  |  | E
 |  |  |  | F
 |  |  |  | G
 |  |  |  | H
 |  |  |  | I
 |  |  |  | J
 |  |  |  | K
 |  |  |  | L
 |  |  |  | M
 |  |  |  | N
 |  |  |  | O
 |  |  |  | P
 |  |  |  | Q
 |  |  |  | R
 |  |  |  | S
 |  |  |  | T
 |  |  |  | U
 |  |  |  | V
TOTAL ASSETS |  | TOTAL
Difference |  |  |  | Totals This Month
To Date |  |  |  | Totals To Date
Spreadsheet: 86577d1286525343-inventory-stock1
Sheet: LIST

 | OFFICE
 | TELEVISIONS
 | AMPLIFIERS & AV Receivers
 | UPSCALERS
 | DVD PLAYERS & BLUE RAY DISC
 | POWER CONDITIONERS
 | HOME THEATRE SYSTEM
 | [NAME]
 | POLYCOM
 | SPEAKERS
 | VOL.CONTROLLERS
 | STABILIZER
 | MIKES
 | CABLES
 | CORD BINDER
 | SWITCHERS & MULTIPLIERS
 | MIXERS
 | AMX
 | LIFE SIZE
 | SCREEN GOO PAINTS
 | SCREENS
 | SHEETS
 | PC TO TV
 | STANDS & WALL MOUNTS BRACKETS
 | LAMPS
 | LOCAL ITEMS
 | SUBWOOFERS
Spreadsheet: mary_fischer__25609__32C-2001
Sheet: E8.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032C
COMPANY NAME   Enron Building Services Inc. Hldg Co.
ANALYSIS OF OTHER DEFERRED CHARGES
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY: [NAME]
EXTENSION:[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  | [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: 676975d1589123411-combine-different-formula-in-one-working
Sheet: RAMS

 | step 1 | step 2 | step3 | step 4
Crucial 16GB DDR4-2400 SODIMM
Crucial 8GB DDR4-3200 SODIMM
Crucial 16GB DDR4-3200 SODIMM
Crucial 4GB DDR4-2400 SODIMM
Crucial 4GB DDR4-3200 SODIMM
Crucial 4GB DDR4-2666 SODIMM
Crucial 32[NAME] (2 x 16GB) DDR4-2666 SODIMM
[NAME] • CL=17 • Dual Ranked • x8 based • Unbuffered • NON-ECC • DDR4-2400 • 1.2V • 2048Meg x 64 •
Crucial 16GB DDR4-2400 SODIMM
Crucial 16[NAME] (2 x 8GB) DDR4-2666 SODIMM
Crucial 8GB DDR4-3200 SODIMM
Crucial 16[NAME] (2 x 8GB) DDR4-3200 SODIMM
step 1 | get value if Column A contains "Crucial" and "DDR" but exclude "KIT".
step 2 | get all the data of column B removing all blanks
step 3 | remove the duplicate of column C.
step 4 | get all the data of column D removing all blanks
Spreadsheet: 773743d1648032431-scenarios-how-can-i-list-a-number-of-results-exceeding-the-limit-of-32-cells-scenario_limits_example
Sheet: ENGINE 2

ENGINE 2
Nominal Power | 200
RPM | 3000
fuel consumption - full load | 200
fuel consumption - partial load | 100
fuel consumption - idle | 2
additive consumption - full load | 20
additive consumption - partial load | 10
additive consumption - idle | 2
emission 1 - full load | 4
emission 1 - partial load | 4
emission 1 - idle | 1
emission 2 - full load | 3
emission 2 - partial load | 2
emission 2 - idle | 1.2
emission 3 - full load | 6
emission 3 - partial load | 3
emission 3 - idle | 1.4
emission 4 - full load | 11
emission 4 - partial load | 11
emission 4 - idle | 1.3
emission 5 - full load | 10
emission 5 - partial load | 5
emission 5 - idle | 1.5
Spreadsheet: 168845d1342606864-counting-the-number-of-people-on-a-course-problem
Sheet: Sheet1

Name | Surname | Course title | start date | IF, AND [NAME] | Number of people on course (FORMULA) | Number of people on course (MANUAL)
[NAME] | Glencross | Excel Level 1 | 2012-06-26 00:00:00 |  |  | 3
[NAME] | Reddy | Excel Level 1 | 2012-06-26 00:00:00 |  |  | 3
Jon | [NAME] | Excel Level 1 | 2012-06-26 00:00:00 |  |  | 3
Mark | [NAME] | Excel Level 1 | 2012-02-07 00:00:00 |  |  | 2
Mark | Treadwell | Excel Level 1 | 2012-02-07 00:00:00 |  |  | 2
[NAME] | Edgar | Excel Level 2 | 2012-02-07 00:00:00 |  |  | 3
[NAME] | Davey | Excel Level 2 | 2012-02-07 00:00:00 |  |  | 3
Stephen | [NAME] | Excel Level 2 | 2012-02-07 00:00:00 |  |  | 3
Spreadsheet: 869429d1715993757-sum-tbdx
Sheet: Sheet1

PAYABLE TEXTBOOKS DISTRIBUTION OF CLASS X 2024-25
Medium | Name of Student | Arb | AT | BT | Eng | Hin | S I | S II | Phy | Che | Bio | Mat | ICT | PE | Amount | Paid | Balance
 |  | 27 | 15 | 16 | 22 | 27 | 25 | 19 | 17 | 19 | 16 | 29 | 19 | 13
[NAME] | Amal | N | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |  | 250
 |  | dears if I type y in the yellow cells I need to get the sum of the respective green cells in the red cell
Spreadsheet: 271015d1381784089-how-to-tackle-multiple-conditions-date-range-destinations-and-type-of-load-with-vlookup-tarrif-charges_arvind
Sheet: RR Data Oct 2013

THIS IS TO CERTIFY THAT THE FOLLOWING SERVICE TAX CHARGES WERE COLLECTED FOR THE MONTH OCT' 2013
S. No. | Rake No. | From Stn. | To Stn. | Inv. No. | RR No. | RR Date | No. of wgns | No. of [NAME] loaded | Actual Qty. Loaded | Charged Qty. | Basic Rate Charged | Rly Freight Paid | Service Tax | Edu. Cess | Higher Edu. Cess | Total Service Tax Paid | [NAME] PMT | Calc. Freight | Final Rate PMT | 0.15 | 0.05 | 2-Point surchg. 5% | 0.03708
1 | 1 | NDL | SGWF | 1 | 212000052 | 2013-10-01 00:00:00 | 10 | 13120 |  | 657 |  | 425946 | 14786 | 296 | 148
2 | 1 | NDL | SGWF | 2 | 212000053 | 2013-10-01 00:00:00 | 6 | 7848 |  | 393 |  | 256356 | 8899 | 178 | 89
3 | 1 | NDL | SGWF | 3 | 212000054 | 2013-10-01 00:00:00 | 4 | 5152 |  | 258 |  | 173533 | 6024 | 120 | 60
4 | 1 | NDL | SGWF | 4 | 212000055 | 2013-10-01 00:00:00 | 4 | 5272 |  | 264 |  | 169590 | 5887 | 118 | 59
5 | 1 | NDL | SGWF | 5 | 212000056 | 2013-10-01 00:00:00 | 4 | 5212 |  | 261 |  | 171562 | 5955 | 119 | 60
6 | 1 | NDL | SGWF | 6 | 212000057 | 2013-10-01 00:00:00 | 1 | 1318 |  | 66 |  | 173533 | 6024 | 120 | 60
7 | 1 | NDL | SGWF | 7 | 212000058 | 2013-10-01 00:00:00 | 4 | 5152 |  | 258 |  | 41412 | 1438 | 29 | 14
8 | 1 | NDL | SGWF | 8 | 212000059 | 2013-10-01 00:00:00 | 1 | 1318 |  | 66 |  | 43384 | 1506 | 30 | 15
9 | 1 | NDL | SGWF | 9 | 212000060 | 2013-10-01 00:00:00 | 4 | 5072 |  | 255 |  | 173533 | 6024 | 120 | 60
10 | 1 | NDL | SGWF | 10 | 212000061 | 2013-10-01 00:00:00 | 3 | 3954 |  | 198 |  | 130150 | 4518 | 90 | 45
11 | 2 | PNM | KUL | 1 | 212000560 | 2013-10-02 00:00:00 | 22 | 27936 |  | 1399 |  | 2143262 | 74399 | 1488 | 744
12 | 2 | PNM | TIR | 1 | 212000561 | 2013-10-02 00:00:00 | 20 | 25260 |  | 1265 |  | 1846587 | 64100 | 1282 | 641
13 | 3 | NDL | MYP | 1 | 212000062 | 2013-10-04 00:00:00 | 40 | 50460 |  | 2527 |  | 2830646 | 98260 | 1965 | 983
14 | 4 | PNM | NGSM | 1 | 212000562 | 2013-10-05 00:00:00 | 42 | 54636 |  | 2736 |  | 3827438 | 132861 | 2657 | 1329
15 | 5 | PNM | DD | 1 | 212000563 | 2013-10-06 00:00:00 | 42 | 54696 |  | 2739 |  | 2873627 | 99752 | 1995 | 998
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
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
Spreadsheet: 840781d1692978149-sum-up-columns-based-on-specific-dates-test
Sheet: Sheet1

Equipment Code | WO Number | WO Description | WO Priority | WO Status | Odometer | Start Date | Finish date | Total Downtime |  |  | Start Date | Finish Date
VL1 |  | SAFETY INSPECTION | P3 | Not Shown |  | 2022-04-11 00:00:00 | 2022-04-11 00:00:00 | 0 |  |  | 2023-08-01 00:00:00 | 2023-08-24 00:00:00
VL1 |  | SAFETY INSPECTION | P3 | Completed | 72294 | 2022-04-12 07:30:00 | 2022-04-12 08:30:00 | 0.9999999999417923
VL1 |  | HEADLIGHT (BULB) REPLACED | P1 | Completed | 72477 | 2022-04-18 07:20:00 | 2022-04-18 07:50:00 | 0.5000000000582077
VL1 |  | SAFETY INSPECTION | P3 | Completed | 72790 | 2022-04-26 07:45:00 | 2022-04-26 08:45:00 | 1.000000000116415 |  |  | Total downtime
VL1 |  | SAFETY INSPECTION | P3 | Completed | 73223 | 2022-05-09 08:01:00 | 2022-05-09 09:01:00 | 1.000000000116415
VL1 |  | SAFETY INSPECTION | P3 | Completed | 73641 | 2022-05-23 15:35:29 | 2022-05-23 16:35:54 | 1.006944444437977
VL1 |  | ACCIDENT DAMAGE | P1 | Waiting Parts |  | 2022-06-05 10:00:00 |  | 10708.77714444447
Spreadsheet: 124181d1318222038-index-match-book1-1-
Sheet: Sheet1

 |  |  |  |  | solution 1
43 | 55 | 17 | Blue | 63 | Green | Note: array formula is used and should be confirmed though Ctrl+Shift+Enter instead of Just Enter
52 | 63 | 61 | Green | 55 | Blue
22 | 87 | 12 | Orange | 17 | Blue
 |  |  |  |  | solution 2
 |  |  |  |  | Green
 |  |  |  |  | Blue
 |  |  |  |  | Blue
Spreadsheet: 652332d1575294105-help-using-indirect-findingmax
Sheet: data

Position | Name | 2019-01-11 00:00:00
SS | [NAME], [NAME] | 84 | 378 | 107 | 58 | 69 | 102 | 548 | 156 | 279 | 172 | 61 | 284
SS | Cowden,  Major | 115 | 358 | 403 | 522 | 581 | 453 | 561 | 568 | 245 | 41 | 366 | 332
FS | Delacaza, [NAME] | 220 | 518 | 474 | 330 | 508 | 189 | 349 | 120 | 384 | 36 | 413 | 557
C | [NAME], [NAME] | 428 | 336 | 378 | 556 | 35 | 108 | 452 | 585 | 16 | 272 | 228 | 400
LB | Kambeya, [NAME] | 147 | 293 | 524 | 109 | 151 | 14 | 217 | 128 | 352 | 380 | 256 | 434
WR | [NAME], [NAME] | 238 | 516 | 505 | 187 | 395 | 264 | 8 | 498 | 104 | 105 | 173 | 450
NT | London, [NAME] | 72 | 461 | 522 | 370 | 159 | 127 | 318 | 477 | 323 | 365 | 277 | 156
FS | [NAME], [NAME] | 2 | 248 | 146 | 72 | 544 | 491 | 437 | 263 | 264 | 568 | 468 | 154
LG | Puma, Che'Vincente' | 296 | 250 | 497 | 545 | 209 | 201 | 389 | 268 | 316 | 65 | 171 | 338
RT | Redic, Ayvan | 520 | 224 | 425 | 559 | 547 | 378 | 107 | 207 | 316 | 322 | 458 | 352
LT | Sutton, [NAME] | 237 | 343 | 260 | 439 | 255 | 550 | 9 | 427 | 255 | 554 | 467 | 402
FS | Vicente, Jasmine | 199 | 230 | 63 | 465 | 308 | 327 | 157 | 547 | 2 | 584 | 81 | 554
Spreadsheet: 889737d1740653185-alert-me-when-thursday-falls-in-week-5-on-any-given-month-digitalwavez-cf-365-aligw
Sheet: Sheet1

 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
First day of each month |  | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00
Week 1
Week 2
Week 3
Week 4
Week 5
Spreadsheet: 113396d1309312099-conditional-formatting-contact-calander_solved
Sheet: Sheet1

2011-06-29 00:00:00 | QUOTE | ORDER | Contact Tracker |  |  |  |  |  |  |  |  | DAYS |  | DAYS |  | DAYS | BDAY | DAYS
Date |  |  | Last Name | First Name | Address | City | Postal | [NAME] | Phone | Cell | Quote Card |  | [NAME] |  | 6 Mth |  | 12 Mth
2011-06-22 00:00:00 | Y |  |  |  |  |  |  |  |  |  | 2011-06-29 00:00:00 | 0 |  |  | 2011-12-19 00:00:00 | 173
Spreadsheet: 0644b985-4c55-4906-b596-28a3cbc5fad3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | CGDI IP Cost Sharing Funds Request Form | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Company Name Here
Labor Funding Request |  |  |  |  |  | Running Total
Function or Task | WBS Task | Assigned Personnel | [NAME] | Projected Labor Hours | Task Funding Request
Write GetView spec | WBS 4.2.1 Item 3 | Sr. Software Eng. | 50 | 100 | 5000
Modify brand x client to support with GetView | WBS 4.2.1 Item 4 | Assoc. Software Eng. | 30 | 150 | 4500
 |  | Expand form as needed
Total Labor |  |  |  |  | 9500 | 9500
Travel Funding Request
Function or Event | Duration | Aspects of Travel | Est. Trip Cost | # of Travelers | Trip Funding Request
OWS-4 Kickoff | 3 days | flight, lodging, per diem | 3000 | 1 | 3000
[NAME] | 3 days | flight, lodging, per diem | 3000 | 2 | 6000
Total Travel |  |  |  |  | 9000 | 18500
Other Expense Requests
Expense Type | Purpose or Use | Justification | Est. Cost | Amount (Units) | Expense Funding Request
Brand X Server CPU | Host WBS software | Required by submitter in order to have adequate infrastructure to show results | 5000 | 1 | 5000
[NAME] (Seat licenses) | Data storage and retrieval | Required by submitter in order to have adequate infrastructure to show results | 3000 | 20 | 60000
Total Other Expenses |  |  |  |  | 65000 | 83500
Grand Total Matching Funds Request |  |  |  |  | 83500