tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 775103d1648823075-skipping-rows-over-multiple-sheets-trivia-database
Sheet: all questions

Points | Question | Answer
1 | What is Bartender Betty's/Middle School Students Favorite Planet? | Uranus
2 | [NAME] was the winner of season 1 of what CBS reality show? | Survivor
3 | The discovery of what Egyptian Pharoah inspired [NAME] | King Tut
4 | How many NFL teams are not tied to a specific city or state? | 2
5 | [NAME] is now known by what name? | Exxon Mobil/Chevron
6 | What [NAME] nominated actor revealed his 15 year old daughter refuses to watch any movie he has been in? | [NAME]
7 | According to the movie Super Mario Brothers, what is the last name of video game characters [NAME] and [NAME]? | Mario
8 | What zodiac sign helped inspire the official name of the music festival known as [NAME]? | Aquarius
9 | [NAME] is a Broadway Musical based on music written by what singer? | [NAME]
10 | [NAME] was one of the first people to own a piece of what well known brand of sports equipment? | [NAME]
1 | The Book Series a song of Ice and Fire is the basis for what TV series? | Game of Thrones
2 | in spite of it's name Oktoberfest actually occurs in what month? | september
3 | Moe,[NAME], and Curly are the most well known members of what comedy group? | 3 stooges
4 | In what decade did [NAME] release the first pump shoe? | 80's
5 | Isla Nublar and [NAME] are fictional islands where what movie series takes place? | Jurassic World/Park
6 | What WWe [NAME] announced his return to the ring on Monday July 19th? | [NAME]
7 | What were the first names of Explorers Lewis and [NAME]? | [NAME] and [NAME]
8 | In her feature film debut, what movie earned [NAME] a Best Supporting actress nomination? | The Color Purple
9 | What two Ivy league schools claim to have each won 25 college football championships but none after 1950? | Yale and Princeton
10 | Since the introduction of the Best Rock Album [NAME] in 1995, which group has won the most times? | Foo Fighters
1 | How many varieties does Heinz claim to have? | 57
2 | What is [NAME] hat trick? | Goal, Assist, Fight
3 | [NAME] is featured on every bottle of what brand of [NAME]? | [NAME] is featured on every bottle of what [NAME]?
4 | What Track and Field star won four gold medals at the 1936 Berlin Olympics? | [NAME]
5 | To discourage athlets from having relations at the Tokyo Olympics, what were the [NAME] made out of? | Cardboard
6 | Adapted into a 2018 Netflix Documentary series "An innocent Man" was the first non-fiction book from what NYT best selling Author | [NAME]
7 | Released in 2000, what [NAME]'s title is based on a bar of the same name, that means waking up next to someone so ugly, you would rather chew your own arm off, than risk waking them? | Coyote Ugly
8 | Who was the first president limited to two terms by the 22nd amendment? | Eisenhower
9 | ANd miles to go before I sleep is repeated twice at the end of what [NAME]? | Stopping by woods on a snowy evening
10 | How many days between trivia nights at 4 corners? | 504
Spreadsheet: 76061d1276634533-sum-by-year-book2
Sheet: Sheet1

 | 2007-01-08 00:00:00 | 2007-02-08 00:00:00 | 2007-03-08 00:00:00 | 2007-04-08 00:00:00 | 2007-05-08 00:00:00 | 2007-06-08 00:00:00 | 2007-07-08 00:00:00 | 2007-08-08 00:00:00 | 2007-09-08 00:00:00 | 2007-10-08 00:00:00 | 2007-11-08 00:00:00 | 2007-12-08 00:00:00 | 2008-01-08 00:00:00 | 2008-02-08 00:00:00 | 2008-03-08 00:00:00 | 2008-04-08 00:00:00 | 2008-05-08 00:00:00 | 2008-06-08 00:00:00 | 2008-07-08 00:00:00 | 2008-08-08 00:00:00 | 2008-09-08 00:00:00 | 2008-10-08 00:00:00 | 2008-11-08 00:00:00 | 2008-12-08 00:00:00
product 1 | 100 | 120 | 140 | 160 | 180 | 200 | 220 | 240 | 260 | 280 | 300 | 320 | 340 | 360 | 380 | 400 | 420 | 440 | 460 | 480 | 500 | 520 | 540 | 560
product 2 | 110 | 125 | 140 | 155 | 170 | 185 | 200 | 215 | 230 | 245 | 260 | 275 | 290 | 305 | 320 | 335 | 350 | 365 | 380 | 395 | 410 | 425 | 440 | 455
product 3 | 115 | 125 | 135 | 145 | 155 | 165 | 175 | 185 | 195 | 205 | 215 | 225 | 235 | 245 | 255 | 265 | 275 | 285 | 295 | 305 | 315 | 325 | 335 | 345
Spreadsheet: 165dd13b-d037-4578-9423-0cf0b0c6586f
Sheet: Excel Instruction

EXCEL INSTRUCTIONS FOR FY 2012 AND FY 2013 BUDGET PUBLICATION
BY MINNESOTA SCHOOL DISTRICTS
 | The FY 2012 and FY 2013 Budget Publication Form ED-00110-36 is provided in an Excel format to include formulas for budget calculations.  The following steps reference cell entries and formulas for both manual and automatic budget section calculations.  FY 2012 BEGINNING FUND BALANCES MAY INCLUDE NEGATIVE NUMBERS.  POSITIVE NUMBERS MUST BE ENTERED IN ALL OTHER CELLS WITHOUT FORMULAS OR THE EXCEL ENTRIES WILL BE INCORRECT.  Cells with formulas have been highlighted in yellow:
 | FY 12 AND FY 13 ACTUAL/BUDGET COLUMNS AND APPLICABLE FUND CATEGORY ENTRIES
 | 1.  In cells C8-C18, enter FY 2012 Beginning Fund Balances.
 | 2.  In cells [NAME] and D16-D18, enter FY 2012 Actual Revenues and Transfers In.
 | 3.  In cells E8-E14 and E16-E18, enter FY 2012 Actual Expenditures and Transfers Out.
 | 4.  In cell F15, enter the Internal Service Fund June 30, 2012 Actual Fund Balance.
 | 5.  In cells G8-G14 and G16-G18, enter estimated FY 2013 Budgeted Revenues and Transfers In.
 | 6.  In cells H8-H14 and H16-H18, enter estimated FY 2013 Budgeted Expenditures and Transfers Out.
 | 7.  In cell [NAME], enter the Internal Service Fund June 30, 2013 Projected Fund Balance.
 | [NAME] have been provided in the following cells to automatically calculate entries in items 1 - 7 above:
 | 8.  June 30, 2012 Actual Fund Balances:  Cells F8-F14; F16-F18
 | 9.  June 30, 2013 Projected Fund Balances:  Cells I8-I14; I16-I18
 | 10.Total - All Funds:  Cells C19-I19
 | LONG-TERM DEBT ENTRIES
 | 1.  In cell C21, enter the Long-Term Debt Outstanding Beginning Balance as of July 1, 2011.
 | 2.  In cell C22, enter the New Issues added to the Long-Term Debt (positive amount).
 | 3.  In cell C23, enter the Redeemed Issues to the Long-Term Debt (positive amount).
 | 4.  A formula has been entered in cell C24 to automatically calculate item 1, plus item 2, minus item 3 to display the Outstanding June 30, 2012 Long-Term Debt balance.
 | SHORT-TERM DEBT ENTRIES
 | 1.  In cell C26, enter Short-Term Certificates of Indebtedness according to the General Instructions, Section C1.
 | 2.  In cell C27, enter Other Short-Term Indebtedness according to the General Instructions, Section C2.
 | CURRENT STATUTORY OPERATING DEBT PER MINNESOTA STATUTES, SECTION 123B.81
 | 1.  In cell H22, enter the amount of General Fund Deficit, if any, in excess of 2.5% for General Fund  expenditures 06/30/2012.
 | COST PER STUDENT - AVERAGE DAILY MEMBERSHIP (ADM) 06/30/12 ENTRIES
 | 1.  In cell H25, enter Total Operating Expenditures according to the General Instructions, Section E1.
 | 2.  In cell H26, enter [NAME] calculated according to the General Instructions, Section E2.
 | 3.  A formula has been entered in cell H27 to automatically calculate item 1, divided by item 2 to display the total FY 2012 Operating Cost Per ADM.
Spreadsheet: 160676d1339164680-star-sign-calculation-copy-of-star-sign
Sheet: Star Sign

Start Date | Sign
101 | Capricorn
120 | Aquarius
219 | Pisces
321 | Aries
420 | Taurus
521 | Gemini
621 | Cancer
723 | Leo
823 | Virgo
923 | Libra
1023 | Scorpio
1122 | Sagittarius
1222 | Capricorn
 | Read more: http://wiki.answers.com/Q/Star_sign_dates#ixzz1xCgbgTGO
Spreadsheet: 871337d1717719903-sum-value-by-both-month-and-category-from-respective-monthly-worksheet-sum-by-month-from-specific-worksheet
Sheet: Summary

 |  | Category | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00
 |  | Apples | 51 | 48 | 115
 |  | Pears | 75 | 70 | 75 |  | Sum Up the Apples by Category and month form the specific month.
 |  | Oranges | 111 | 134 | 65 |  | For example for [NAME] for January should be:
 |  | Peanuts | 12 | 8 | 11 |  | For example for Pears for February should be:
Spreadsheet: john_griffith__16033__2_5_02GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 58 | 475 | 550 | 43.9 | 50.9 | 1.73 | 2002-02-05 14:54:00
 | [NAME] | 65 | 810 | 910 | 43.3 | 48.7 | 1.88 | 2002-02-05 14:54:00
 | [NAME] | 66 | 1025 | 1125 | 42.2 | 46.4 | 1.84 | 2002-02-05 14:54:00
 | [NAME] | 66 | 1175 | 1275 | 40.8 | 44.3 | 1.77 | 2002-02-05 14:54:00
 | HU N2 | 64 | 1275 | 1375 | 41 | 44.3 | 1.72 | 2002-02-05 14:54:00
 | [NAME] | 64 | 1325 | 1425 | 38.7 | 41.7 | 1.62 | 2002-02-05 14:54:00
 | HU U2 | 62 | 1350 | 1475 | 37.6 | 41.1 | 1.53 | 2002-02-05 14:54:00
 | [NAME] | 60 | 1300 | 1450 | 35.1 | 39.2 | 1.4 | 2002-02-05 14:54:00
 | [NAME] | 59 | 1300 | 1450 | 33.5 | 37.4 | 1.31 | 2002-02-05 14:54:00
 | [NAME] | 59 | 1300 | 1450 | 32 | 35.7 | 1.26 | 2002-02-05 14:54:00
 | HU F3 | 59 | 1300 | 1450 | 30.6 | 34.2 | 1.2 | 2002-02-05 14:54:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | HU H3
 | [NAME]
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | HU M3
Spreadsheet: 791243d1660222602-conditional-formatting-of-table-cells-against-list-of-cells-tracker1
Sheet: Sheet1

ID | Start time | Completion time | Name | Date Training Completed | Acknowledged | Yes | No
1 | 2022-08-02 11:34:56 | 2022-08-02 11:35:09 | [NAME] | 2022-08-02 00:00:00 | Yes
2 | 2022-08-02 11:35:14 | 2022-08-02 11:35:30 | [NAME] | 2022-08-01 00:00:00 | Yes
3 | 2022-08-02 11:34:47 | 2022-08-02 11:35:37 | [NAME] | 2022-08-02 00:00:00 | Yes
4 | 2022-08-02 11:35:33 | 2022-08-02 11:35:38 | Mark | 2022-08-02 00:00:00 | Yes
5 | 2022-08-02 11:35:39 | 2022-08-02 11:35:51 | June | 2022-07-31 00:00:00 | Yes
6 | 2022-08-02 11:35:52 | 2022-08-02 11:36:05 | [NAME] | 2022-08-02 00:00:00 | Yes
7 | 2022-08-02 11:35:52 | 2022-08-02 11:36:05 | [NAME] | 2022-08-02 00:00:00 | Yes
Total
 |  | Assigned Training
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | Mark
 |  | June
 |  | [NAME]
 |  | [NAME]
 |  | Becky
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 | Total Assigned
Spreadsheet: 872544d1718903751-dashboard-without-pivot-tables-only-formula-and-functions-190624_example-data-sakram3ntum-
Sheet: dashboard

 |  | Fiscal Month |  |  | Staff Type
 | Select the fiscal month → | 2024P09 |  |  | OS Lvl 1 Phone
 |  | Fiscal Week |  |  | [NAME]
 | Select the fiscal week → | 2024P01W1 |  |  | OS Lvl 1 Phone
 |  | Supervisors |  |  | Agent Name
 | Select the Team Manager → | Elise Stevens |  |  | Aston Bran
 | Case Component
 | Case Details | Answered | SAT | Surveys | Pos. Survey | Neg. Survey | AHT
 |  |  |  |  |  |  |  |  | Quarter
 |  |  |  |  |  |  |  | Count |  |  | Average
 | Team | Answered | SAT | Surveys | Pos. Survey | Neg. Survey | AHT | Month to Date | Quarter to Date | Year to Date | Month to Date | Quarter to Date | Year to Date
 |  |  |  | ??? | ??? |  | ???
Spreadsheet: 73980d1274554887-trouble-with-laying-out-data-set-dataset_rev1
Sheet: Dataset

INDIRECT to reference the worksheet named with Dept |  |  | HLOOKUP & MATCH
Department | Forecast Month | Revenue Category | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
Dept1 |  | Complete
Dept1 |  | Live
Dept1 |  | Booked On
Dept1 |  | High Prob
Dept1 |  | Indentified
Dept1 |  | Blue Sky
Dept2 |  | Complete
Dept2 |  | Live
Dept2 |  | Booked On
Dept2 |  | High Prob
Dept2 |  | Indentified
Dept2 |  | Blue Sky
 |  | Will a flat dataset like this work or is there a better format to capture each departments forecast for the year
Spreadsheet: rick_buy__32932__TAB6_EPMI_ISDA
Sheet: Replacement Costs

Sum of Nominal Volume |  | Forward Date
Region_NM | LoadDefinition NM | 2001-12-01 00:00:00 | Grand Total
NE | East Peak | 16000 | 16000
NE Total |  | 16000 | 16000
WH | East OffPeak | 42400 | 42400
WH Total |  | 42400 | 42400
Grand Total |  | 58400 | 58400
Average of Bid/Offer |  | Forward Date
Region_NM | LoadDefinition NM | 2001-12-01 00:00:00 | Grand Total
NE | East Peak | 34.7 | 34.7
WH | East OffPeak | 17.5 | 17.5
Margin Calculation Detail:
NE | East Peak
WH | East OffPeak
Grand Total
Margin Requirement Per Month | 0.5
Cumulative Margin Required *
Monthly Cost of Capital - NPW | 0.25
PV of Monthly Cost of Credit at T-Bill Rate | 0.03
Total Cost of Credit to NPW
Spreadsheet: 53720d1253638824-formula-to-calculate-on-a-quarterly-basis-the-fee-due-based-on-the-threshold-its-c-test
Sheet: Sheet1

 | Month | Total Revenue | Basic Mgt Fee @2% | Monthly VAT | [NAME] | Quarterley Total
 | 2009-01-01 00:00:00 | 411487 | 8229.74 | 1234.46
 | 2009-02-01 00:00:00 | 367129 | 7342.58 | 1101.39
 | 2009-03-01 00:00:00 | 446514 | 8930.28 | 1339.54 | 3675.39 | 28177.99
 | 2009-04-01 00:00:00 | 365035 | 7300.7 | 1095.11
 | 2009-05-01 00:00:00 | 315820 | 6316.400000000001 | 947.46
 | 2009-06-01 00:00:00 | 356376 | 7127.52 | 1069.13 | 3111.7 | 23856.32
 | 2009-07-01 00:00:00 | 368997 | 7379.940000000001 | 1106.99
 | 2009-08-01 00:00:00 | 402401 | 8048.02 | 1207.2
 | 2009-09-01 00:00:00 | 405731 | 8114.62 | 1217.19 | 3531.38 | 27073.96
 | 2009-10-01 00:00:00 | 354100 | 7082 | 1062.3
 | 2009-11-01 00:00:00 | 302988 | 6059.76 | 908.96
 | 2009-12-01 00:00:00 | 298741 | 5974.82 | 896.22 | 2867.48 | 21984.06
 | Total - Actual | 4395319 | 87906.38 | 13185.95 | 13185.95 | 101092.33
Spreadsheet: 884777d1734039792-combining-yearly-array-data-into-a-rolling-sum-sample-2024
Sheet: 2024 Totals

 | PROVIDERS AND # of REFERRALS MADE |  |  | PROVIDERS # TIMES NAME SHOWS in sheets
 |  | 1 |  |  | 1
 | EC, DORE [597] | 2 |  | BR, MEW C [369] | 1
 | FR, KREX [325] | 2 |  | CAR, JEC [236] | 1
 | ML, DAN [212] | 1 |  | DU, RON [168] | 1
 | OS, AEM [286] | 2 |  | EC, DORE [597] | 2
 | RI, TREE [569] | 1 |  | FA, THOJ [132] | 1
 | SH, DIV [149] | 1 |  | FA, THOMAS J [132] | 2
 | SM, JACK [005] | 2 |  | FO, KAT[806] | 2
 | TA, CHRIS [284] | 1 |  | FR, KREX [325] | 4
 | WH, CAROLINE [358] | 1 |  | HA. ILEY [165] | 1
 |  |  |  | ML, DAN [212] | 1
 |  |  |  | OS, AEM [286] | 3
 |  |  |  | RA, KI [173] | 1
 |  |  |  | RI, MARIA [226] | 4
 |  |  |  | RI, TREE [569] | 1
 |  |  |  | SE, NIK [231] | 2
 |  |  |  | SH, DIV [149] | 2
 |  |  |  | SM, JACK [005] | 3
 |  |  |  | TA, CHRIS [284] | 3
 |  |  |  | WH, CAROLINE [358] | 1
Spreadsheet: 47138d1246040028-conditional-lookup-book1
Sheet: Sheet1

Date | Name | Title | Address | Type | Supervisor
2006-05-03 00:00:00 | Name1 | Title 1 | Address 1 | Type 1 | Sup 1
2006-05-07 00:00:00 | [NAME] | Title 4 | Address 2 | Type 2 | Sup 2
2006-05-08 00:00:00 | Name3 | Title 3 | Address 3 | Type 3 | Sup 3
2006-05-08 00:00:00 | Name4 | Title 2 | Address 4 | Type 4 | Sup 4
2006-05-13 00:00:00 | Name1 | Title 1 | Address 1 | Type 1 | Sup 1
2006-05-14 00:00:00 | [NAME] | Title 4 | Address 2 | Type 2 | Sup 2
2006-05-14 00:00:00 | Name3 | Title 3 | Address 3 | Type 3 | Sup 3
2006-05-16 00:00:00 | Name4 | Title 2 | Address 4 | Type 4 | Sup 4
2006-05-20 00:00:00 | Name1 | Title 1 | Address 1 | Type 1 | Sup 1
2006-05-25 00:00:00 | [NAME] | Title 4 | Address 2 | Type 2 | Sup 2
2006-05-26 00:00:00 | Name3 | Title 3 | Address 3 | Type 3 | Sup 3
2006-05-27 00:00:00 | Name4 | Title 2 | Address 4 | Type 4 | Sup 4
2006-06-04 00:00:00 | Bienville | Title 1 | Address 1 | Type 1 | Sup 1
2006-06-10 00:00:00 | Name1 | Title 4 | Address 2 | Type 2 | Sup 2
2006-06-12 00:00:00 | [NAME] | Title 3 | Address 3 | Type 3 | Sup 3
2006-06-13 00:00:00 | Name3 | Title 2 | Address 4 | Type 4 | Sup 4
2006-06-15 00:00:00 | Name4 | Title 1 | Address 1 | Type 1 | Sup 1
2006-06-16 00:00:00 | Name1 | Title 4 | Address 2 | Type 2 | Sup 2
2006-06-17 00:00:00 | [NAME] | Title 3 | Address 3 | Type 3 | Sup 3
2006-06-26 00:00:00 | Name3 | Title 2 | Address 4 | Type 4 | Sup 4
2006-06-26 00:00:00 | Name4 | Title 1 | Address 1 | Type 1 | Sup 1
2006-06-30 00:00:00 | Name1 | Title 4 | Address 2 | Type 2 | Sup 2
2006-07-06 00:00:00 | [NAME] | Title 3 | Address 3 | Type 3 | Sup 3
2006-07-09 00:00:00 | Name3 | Title 2 | Address 4 | Type 4 | Sup 4
2006-07-16 00:00:00 | Name4 | Title 1 | Address 1 | Type 1 | Sup 1
2006-07-19 00:00:00 | Name1 | Title 4 | Address 2 | Type 2 | Sup 2
2006-07-21 00:00:00 | [NAME] | Title 3 | Address 3 | Type 3 | Sup 3
2006-07-22 00:00:00 | Name3 | Title 2 | Address 4 | Type 4 | Sup 4
2006-07-23 00:00:00 | Name4 | Title 1 | Address 1 | Type 1 | Sup 1
2006-08-04 00:00:00 | Bienville | Title 4 | Address 2 | Type 2 | Sup 2
2006-08-06 00:00:00 | Name1 | Title 3 | Address 3 | Type 3 | Sup 3
2006-08-07 00:00:00 | [NAME] | Title 2 | Address 4 | Type 4 | Sup 4
2006-08-08 00:00:00 | Name3 | Title 1 | Address 1 | Type 1 | Sup 1
2006-08-08 00:00:00 | Name4 | Title 4 | Address 2 | Type 2 | Sup 2
2006-08-10 00:00:00 | Name1 | Title 3 | Address 3 | Type 3 | Sup 3
2006-08-12 00:00:00 | [NAME] | Title 2 | Address 4 | Type 4 | Sup 4
Spreadsheet: 858529d1707172713-sumif-falls-on-holidays-sample-wb
Sheet: Sheet1

 |  | 2024-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  | Week no. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday Leave Taken | Weekdays | Weekend | Holiday |  | List |  | Holiday
 |  |  | Day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | January 01, 2024
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 |  | February 05, 2024
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hol |  | April 01, 2024
 | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0.5 | 1 | 0.5 | 0.5 |  |  |  |  |  |  | SL |  | May 06, 2024
 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hol |  |  | 0.5 | 0.5 |  |  |  |  |  |  |  |  | June 03, 2024
 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August 05, 2024
 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SL |  |  |  |  |  |  |  |  |  |  |  | October 28, 2024
 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December 25, 2024
 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December 26, 20234
 | 7
 | 8
 | 9
 | 10
Spreadsheet: 456075d1460632494-summing-up-with-criterias-test_formula_2
Sheet: Sheet1

 | Date | Price |  | Sum of Price | Dates
 | 1 | 156 |  | I need the sum of price for the dates 01-Apr , 02-Apr, 03-Apr | 1,2,3
 | 2 | 144 |  | I need the sum of price for dates 01-Apr to 06-Apr | 1,2,3,4,5,6
 | 3 | 144 |  | I need the sum of price for 01-Apr, 02-Apr, 03-Apr, 08-Apr and 10-Apr | 1,2,3,8,10
 | 4 | 82 |  | I need the sum price of 02-Apr,04-Apr,09-Apr | 2,4,9,10
 | 5 | 144
 | 6 | 144
 | 7 | 159
 | 8 | 160
 | 9 | 211
 | 10 | 268
Spreadsheet: 0d826132-1998-4b6e-9cf2-4d2c819ba9e7
Sheet: Sheet1

Program | Last | First | Unnamed: 3 | Unnamed: 4
Anesthesiology | Knipper | Emily | [EMAIL]
Anesthesiology | Leach | [NAME] | [EMAIL]
Anesthesiology | Tashjian | Jessica | [EMAIL]
Cardiac Surgery | Tesche | [NAME] | [EMAIL]
[NAME] | Griffiths | [NAME] | [EMAIL]
[NAME] | [NAME] | [NAME] | [EMAIL]
[NAME] | [NAME] | [NAME] | [EMAIL]
Cardiothoracic | Kiankhooy | Armin | [EMAIL]
Cardiothoracic | Roeser | Mark | [EMAIL]
Cardiovascular Disease | [NAME] | Margarita | [EMAIL]
[NAME] | [NAME] | Nick | [EMAIL]
Dentistry | Beavers | [NAME] | [EMAIL] | Second (Jan- June)
Dentistry | Vega | [NAME] | [EMAIL] | First (July - Dec)
Dermatology | Kuppalli | Smitha | [EMAIL]
Dermatology | Marchetti | [NAME] | [EMAIL]
Emergency Medicine | [NAME] | [NAME] | [EMAIL]
Emergency Medicine | Hawkins | [NAME] | [EMAIL]
Emergency Medicine | Wiggins | [NAME] | [EMAIL]
Family Medicine | Ardon | [NAME] | [EMAIL]
Family Medicine | DeGeorge | Katharine | [EMAIL]
Gastroenterology | Intagliata | [NAME] | [EMAIL]
Hem/Onc
Internal Medicine | [NAME] | [NAME] | [EMAIL]
Internal Medicine | [NAME] | Erin | [EMAIL]
Internal Medicine | [NAME] | [NAME] | [EMAIL]
Internal Medicine | Millard | [NAME] | [EMAIL]
Nephrology | [NAME] | Jwalant | [EMAIL]
Nephrology | [NAME] | [NAME] | [EMAIL]
Neurology | Eckerle | [NAME] | [EMAIL]
Neurology | Kohler | Scott | [EMAIL]
Neurosurgery | Reames | [NAME] | [EMAIL]
Neurosurgery | Medel | Ricky | [EMAIL]
Obstetrics Gynecology | Holmberg | Sara | [EMAIL]
Obstetrics Gynecology | Kilfoil | Brooke | [EMAIL]
Obstetrics Gynecology | Pound | Stephen | [EMAIL]
Obstetrics Gynecology | Schutt | [NAME] | [EMAIL]
Opthalmology | Saleem | [NAME] | [EMAIL]
Opthalmology | Shiple | [NAME] | [EMAIL]
Opthalmology | [NAME] | Bina | [EMAIL]
Orthopaedics | Bagayoko | Namory | [EMAIL]
Orthopaedics | [NAME] | [NAME] | [EMAIL]
Orthopaedics | Gluck | [NAME] | [EMAIL]
Orthopaedics | Haro | [NAME] | [EMAIL]
Orthopaedics | Mason | [NAME] | [EMAIL]
Otolaryngology | Barker | [NAME] | [EMAIL]
Otolaryngology | Nguyen | [NAME] | [EMAIL]
Pathology | [NAME] | [NAME] | [EMAIL]
Pathology | Green | Tyler | [EMAIL]
Pediatrics | Matanock | Almea | [EMAIL]
Pediatrics | Horvath | Sherie | [EMAIL]
Pediatrics - Critical Care | Kicker | [NAME] | [EMAIL]
Pharmacy |  |  | named in July
Physical Medicine & Rehab | Mason | Annice | [EMAIL]
Physical Medicine & Rehab | Martin | Berkeley | [EMAIL]
Plastic Surgery | Black | [NAME] | [EMAIL]
Plastic Surgery | [NAME] | [NAME] | [EMAIL]
Psychiatry | Groth | Jena | [EMAIL]
Psychiatry | Putziger | [NAME] | [EMAIL]
Psychiatry | [NAME] | [NAME] | [EMAIL]
Psychiatry/Child Fellows | Khurana | Sid | [EMAIL]
Radiation Oncology | Reardon | [NAME] | [EMAIL]
Radiology | Ferdinand | [NAME] | [EMAIL]
Radiology | Mauro | [NAME] | [EMAIL]
Surgery | Flohr | Tanya | [EMAIL]
Surgery | Hennessy | Sara | [EMAIL]
Surgery | Hranjec | Tasha | [EMAIL]
Surgery | Nagji | Alykhan | [EMAIL]
Surgery | Parker | Anna | [EMAIL]
Urology | [NAME] | Jessica | [EMAIL]
Urology | Mason | [NAME] | [EMAIL]
[NAME] | Adams | [NAME] | [EMAIL]
Vascular Surgery | Jain | Amit | [EMAIL]
Spreadsheet: 840523d1692796866-need-function-to-determine-parent-or-child-in-a-hierarchy-plan-for-365-aligw
Sheet: Planilha1

COLUMN1 | COLUMN2 | COLUMN3 | COLUMN4 | FUNCTION
ITEM 1
 | ITEM 1.1
 |  | ITEM 1.1.1
 | ITEM 1.2
 |  | ITEM 1.2.1
ITEM 2
 | ITEM 2.1
ITEM 3
 | ITEM 3.1
 |  | ITEM 3.1.1
 |  |  | ITEM 3.1.1.1
ITEM 4
 | ITEM 4.1
Spreadsheet: 887970d1738284093-scan-function-not-behaving-as-expected-scan-to-count-sections
Sheet: Sheet1

 | Section 1 |  |  | Section 2 |  |  | Section 3 |  |  |  |  |  |  |  |  |  | Expected values
 | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 |  |  |  | Column1 |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | Column2 |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | Column3 |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | Section 2 | Column4 |  | #[NAME]! | 2 |  | 2 |  | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  | Column5 |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  | Column6 |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | Section 3 | Column7 |  | #[NAME]! | 3 |  | 3 |  | 3 | 3
 |  |  |  |  |  |  |  |  |  |  |  | Column8 |  |  | 3