tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 713680d1610879094-subtraction-of-vlookup-in-two-sheets-but-across-a-number-of-columns-test-excel-forum_vlookup
Sheet: JAN 21

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 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
EE ID | Gender | Other 1 | Other 2 | Other 3 | Other 4 | Other 5 | Other 6 | Other 7 | Other 8 | Other 9 | Other 10 | Other 11 | Other 12 | Other 13 | Other 14 | Other 15 | Other 16 | Other 17 | Other 18 | Other 19 | Other 20 | Other 21 | Other 22 | Other 23 | Other 24 | Other 25 | Other 26 | Other 27 | Other 28 | Other 29 | Other 30 | Other 31 | Other 32 | Other 33 | Other 34 | Other 35 | Other 36 | Other 37 | Other 38 | Other 39 | Other 40 | Other 41
100 | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | 1000000 | 1 | 50 | 49 |  |  |  | 40 |  |  |  |  |  | 60
101 | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | 150 |  |  |  | 2
150 | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | 20 |  |  |  |  | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 50 | 12 | 13 | 14 | 15 | 16 | 90 | 18 | 19 | 20 | 21 | 22 | 23
175 | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | test | 900500 |  |  |  |  |  | 5 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eg
100
101
150
175
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | but how do I move this to populate from column T to AQ (col 20 - col 43)
Spreadsheet: 149433d1333965592-excel-2007-excel-survey-data-stats-prosjekt
Sheet: Ark4

What are you currently studying | do you consider exercising for fitness fun | Do you think physical activity counteracts the effects of time spent on the computer | Average hours weekly used for computer activities | Average weekly school/work related computer activites | Average weekly leisure computer activites | Average weekly leisure physical activites | Average weekly school related physical activites | Average weekly total physical activites | Areas with pain | Days disabled | Caused by physical activities | Caused by computer activites | Worsened by physical activites activites | Worsened by computer activites | Pain scale 0-10 | Interference 0-10
1 | 4 | 4 | 40 | 30 | 10 | 10 | 12 | 22 | 1,7,8 | 5 | 2 | 2 | 2 | 3 | 7 | 8
1 | 5 | 4 | 25 | 22 | 3 | 10 | 6 | 4 | 11 | 30 | 1 | 2 | 3 | 2 | 7 | 4
3 | 5 | 2 | 20 | 7 | 13 | 7 | 0 | 10 | 8,10,13 | 10 | 1 | 1 | 1 | 1 | 4 | 3
1 | 5 | 4 | 21 | 7 | 14 | 18 | 1 | 20 | 2,8,9,11,12 | 15 | 1 | 2 | 1 | 2 | 6 | 6
1 | 5 | 2 | 50 | 30 | 10 | 10 | 0 | 15 | 8.11 | 0 | 1 | 2 | 1 | 2 | 2 | 0
1 | 4 | 4 | 30 | 22 | 8 | 5 | 1 | 8 | 14 | 0 | 2 | 2 | 2 | 2 | 9 | 10
1 | 3 | 4 | 20 | 10 | 10 | 10 | 3 | 10 | 7,8,11 | 0 | 2 | 3 | 2 | 1 | 3 | 2
1 | 5 | 5 | 33 | 23 | 10 | 7 | 0 | 9 | 10 | 1 | 1 | 2 | 3 | 2 | 3 | 1
1 | 3 | 1 | 60 | 36 | 24 | 14 | 0 | 20 | 11.14 | 34 | 1 | 2 | 3 | 2 | 6 | 6
1 | 4 | 4 | 14 |  | 6 | 4 | 15 | 19 | 1,7,11 | 7 | 1 | 2 | 3 | 3 | 3 | 3
1 | 4 | 4 | 24 | 20 | 15 | 12 | 12 | 15 | 14
3 | 4 | 4 | 15 |  | 3 |  | 4 | 15 | 11 | 60 | 1 | 2 | 1 | 2 | 7 | 2
1 | 5 | 4 | 28 | 18 | 10 | 12 | 2 | 14 | 2,6,12 | 40 | 1 | 2 | 1 | 2 | 6 | 5
1 | 4 | 4 | 15 | 12 | 3 | 4 | 1 | 5 | 1 | 0 | 2 | 1 | 2 | 1 | 3 | 1
1 | 5 | 1 | 16 |  | 16 | 14 | 12 | 18 | 11 | 30
1 | 5 | 5 | 9 |  | 4 | 8 | 2 | 10 | 2 | 21 | 1 | 2 | 3 | 2 | 7 | 0
1 | 4 | 5 | 14 |  | 9 | 9 |  | 9 | 11 | 3 | 1 | 2 | 1 | 2 | 2 | 0
1 | 4 | 4 | 12 |  |  | 6 | 3 | 9 | 1,8,11 | 0 | 1 | 1 | 1 | 1 | 3 | 1
Spreadsheet: 219187d1362679444-automatically-updating-multiple-sheets-to-a-master-sheet-master-test
Sheet: 1.

Test |  |  |  |  |  |  | Target |  | Actual |  |  |  |  | 2011 |  |  |  |  |  |  |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014
Activity | Core | Stream | Task | Milestone | Accountable | External | Start | End | Actual | Actual End Date | Status | Funding | Notes/Location | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1 | Main Header 1.0
1.1 | Title Go Here | Title | Title Go Here
1.1
1.1
1.1
1.2 | Title | Title | Title Go Here
1.2
1.2
1.2
1.2
1.2
1.2
1.2
1.2
1.2
1.2
1.2
1.2
1.2
1.2
1.2
1.2
1.2
1.2
1.2
Spreadsheet: 219862d1362994469-please-help-with-a-couple-issues-with-adding-moving-columns-financial-accounting-columbia-cu-savings-final-uploaded
Sheet: Categories

[Categories]
***** ADDITIONS *****
AV Cash Deposits
AV ACH Qwest Pension
AV ACH Social Security
AV ACH US Treasury
AV Account Earned Interest
AV Check Deposits
[NAME]
***** ADDITIONS *****
AP Deposits
***** SUBTRACTIONS *****
***** AV EXPENSES *****
AV ACH Withdrawals
AV Check Withdrawals
AV Debit Withdrawals
AV Account Fees
***** AP EXPENSES *****
AP Cash Withdrawals
AP ACH Withdrawals
AP Check Withdrawals
AP Debit Withdrawals
AP Transfer Withdrawals
AP Overdraft Fees
Spreadsheet: 701936d1603992935-sumproduct-with-multiple-criteria-and-slicers-incident-tracker-test-
Sheet: Dashboard

MONTHLY INCIDENT REPORT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fiscal Year: | FY21 |  | Period: | OCT
 |  |  |  |  |  |  |  |  | OSHA Recordability
 |  |  | Head |  |  | Face |  |  | Factor:
 |  |  |  |  |  |  |  |  | Lost Work Days:
 |  |  | Neck |  |  | Eyes
 |  | Back |  |  |  |  |  |  | Restricted Duty
 |  |  |  |  |  | Shoulders
 |  | Arms |  |  |  |  |  |  | Medical Treatment
 |  |  |  |  |  | Elbows
 |  |  |  |  |  |  |  |  | First Aid
 |  |  |  |  | Trunk
 |  |  |  |  |  |  |  |  | Report Only
 |  |  |  |  |  | Wrists
 |  | Hands / Fingers
 |  |  |  |  |  | Knees
 |  | Illness / Other
 |  |  |  |  |  |  |  |  | FY20 ORI FINAL: |  |  | OSHA Recordable Incident Rate (ORI) Calculator
 |  |  |  |  |  |  |  |  |  |  |  |  | Incidents: |  |  | [NAME]: |  | Baseline:
 |  |  |  |  |  | Ankles |  |  |  | 5.01 |  |  |  |  |  |  |  |  | 200000
 |  | Feet / Toes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Incident Rate:
Spreadsheet: 99451d1298060357-if-statement-calendar-issue
Sheet: Suggestion

 |  | 2011-02-18 00:00:00 |  | 2011-02-01 00:00:00
 |  |  |  |  |  |  |  |  | 2011-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 2011-02-01 00:00:00
 |  |  |  |  |  |  |  |  | 2011-03-01 00:00:00
 |  |  |  |  |  |  |  |  | 2011-04-01 00:00:00
 |  |  |  |  |  |  |  |  | 2011-05-01 00:00:00
 |  |  |  |  |  |  |  |  | 2011-06-01 00:00:00
 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00
 |  |  |  | 2011-08-01 00:00:00 |  |  |  |  | 2011-08-01 00:00:00
 |  |  |  | 2011-07-01 00:00:00 |  |  |  |  | 2011-09-01 00:00:00
 |  |  |  | 2011-06-01 00:00:00 |  |  |  |  | 2011-10-01 00:00:00
 |  |  |  | 2011-05-01 00:00:00 |  |  |  |  | 2011-11-01 00:00:00
 |  |  |  | 2011-04-01 00:00:00 |  |  |  |  | 2011-12-01 00:00:00
 |  |  |  | 2011-03-01 00:00:00
 |  |  |  | 2011-02-01 00:00:00
 |  |  |  | 2011-01-01 00:00:00
 |  |  |  | 2010-12-01 00:00:00
 |  |  |  | 2010-11-01 00:00:00
 |  |  |  | 2010-10-01 00:00:00
 |  |  |  | 2010-09-01 00:00:00
 |  |  |  | 2010-08-01 00:00:00
 |  |  |  | 2010-07-01 00:00:00
 |  |  |  | 2010-06-01 00:00:00
 |  |  |  | 2010-05-01 00:00:00
 |  |  |  | 2010-04-01 00:00:00
 |  |  |  | 2010-03-01 00:00:00
 |  |  |  | 2010-02-01 00:00:00
Spreadsheet: 67223d1267805220-excel-2007-help-required-in-function-multiple-conditions-to-be-fulfilled-hiiii
Sheet: Sheet2

Silver
 | 3 Lac |  |  | 4 Lac |  |  | 5 Lac
Age Slab | 1 + 1 | 2 + 1 | 2 + 2 | 1 + 1 | 2 + 1 | 2 + 2 | 1 + 1 | 2 + 1 | 2 + 2
Up to 35 Yr | 4649 | 5291 | 6482 | 5793 | 7193 | 8103 | 6936 | 8616 | 9701
36 to 45 Yr | 5050 | 5739 | 7060 | 6288 | 7814 | 8813 | 7546 | 9368 | 10545
Standard
 | 3 Lac |  |  | 4 Lac |  |  | 5 Lac
Age Slab | 1 + 1 | 2 + 1 | 2 + 2 | 1 + 1 | 2 + 1 | 2 + 2 | 1 + 1 | 2 + 1 | 2 + 2
Up to 35 Yr | 4249 | 4884 | 6038 | 5316 | 6638 | 7548 | 6488 | 7948 | 9035
36 to 45 Yr | 4630 | 5291 | 6571 | 5774 | 7215 | 8192 | 7051 | 8636 | 9812
Spreadsheet: 729720d1619282376-how-many-ids-in-column-a-match-two-criteria-in-column-b-free-and-paid
Sheet: Sheet1

User ID | Account type
23 | Free
24 | Free
25 | Free
25 | Paid
23 | Free
24 | Free
25 | Paid
23 | Paid
24 | Free
Spreadsheet: 143443d1330425209-referecing-worksheets-and-returning-areas-eol_checker_new_angusdn
Sheet: caracal nw

Consistency check
GLO: HP Printer final assembly (DfX)
 | Inputs | Outputs | Outputs - Inputs
Technical quantities
Mass [kg] | 0,788 | 0,788 | 0
1 Steel and iron materials
Steel and iron materials (unspecified) [kg] | 0,0837 | 0,0837 | 0
5 Polymer materials
Plastics in packaging [kg] | 0,00364 | 0,00364 | 0
Polymer materials (unspecified) [kg] | 0,216 | 0,216 | 0
1.1 Steels / cast steel / sintered steel
Steels / cast steel / sintered steel (unspecified) [kg] | 0,269 | 0,269 | 0
2.1 Aluminium and aluminium alloys
Aluminium and aluminium alloys (unspecified) [kg] | 0,00189 | 0,00189 | 0
3.1 Copper
Copper (unspecified) [kg] | 0,00513 | 0,00513 | 0
3.4 Zinc alloys
Zinc alloys (unspecified) [kg] | 0,00483 | 0,00483 | 0
5.2 Thermoplastic elastomers
Thermoplastic elastomers (unspecified) [kg] | 7,52E-005 | 7,52E-005 | 0
5.3 Elastomers / elastomeric compounds
Elastomers / elastomeric compounds (unspecified) [kg] | 0,00154 | 0,00154 | 0
5.5 Polymeric compounds
[NAME] compounds (unspecified) [kg] | 0,000923 | 0,000923 | 0
5.1b Thermoplaste unfilled
Thermoplaste unfilled (unspecified) [kg] | 0,0403 | 0,0403 | 0
7.1 Modified organic natural materials
Modified organic natural materials (unspecified) [kg] | 0,0394 | 0,0394 | 0
7.2 Ceramic / glass
Ceramic / glass (unspecified) [kg] | 0,000831 | 0,000831 | 0
8.1 Electronics
Electronics (unspecified) [kg] | 0,00265 | 0,00265 | 0
Material declaration electronics
Aluminum (E) [kg] | 0,000148 | 0,000148 | 0
Aluminum oxide (Al2O3) (E) [kg] | 0,000105 | 0,000105 | 0
Antimony oxide ([NAME] trioxide) (Sb2O3) (E) [kg] | 5,23E-006 | 5,23E-006 | 0
Copper (E) [kg] | 0,00759 | 0,00759 | 0
Copper in alloy (E) [kg] | 0,00324 | 0,00324 | 0
Electrolyte (E) [kg] | 5,14E-005 | 5,14E-005 | 0
[NAME] resin (E) [kg] | 0,000415 | 0,000415 | 0
Ferrites (E) [kg] | 0,000102 | 0,000102 | 0
Glas (E) [kg] | 1,14E-007 | 1,14E-007 | 0
Gold (E) [kg] | 2,64E-005 | 2,64E-005 | 0
Inorganic flame retardants (E) [kg] | 1,27E-008 | 1,27E-008 | 0
Lead (E) [kg] | 2,5E-007 | 2,5E-007 | 0
Natural rubber (NR) (E) [kg] | 6,72E-005 | 6,72E-005 | 0
Nickel (E) [kg] | 4,93E-006 | 4,93E-006 | 0
Palladium in alloy (E) [kg] | 1,25E-005 | 1,25E-005 | 0
Paper (E) [kg] | 1,95E-005 | 1,95E-005 | 0
Phenol-Formaldehyde-Resin (PF) (E) [kg] | 9,03E-006 | 9,03E-006 | 0
Polyamide 6 (PA6) (E) [kg] | 7,8E-005 | 7,8E-005 | 0
Polybutylene terephthalate (PBT) (E) [kg] | 0,000451 | 0,000451 | 0
[NAME] sulfide (PPS) (E) [kg] | 3,08E-005 | 3,08E-005 | 0
Polyurethane (E) [kg] | 5,27E-005 | 5,27E-005 | 0
[NAME] chloride (PVC) (E) [kg] | 1,65E-006 | 1,65E-006 | 0
Silicon (E) [kg] | 1,47E-005 | 1,47E-005 | 0
Silicon dioxide (SiO2) (E) [kg] | 0,000525 | 0,000525 | 0
Silver (E) [kg] | 0,000167 | 0,000167 | 0
Silver in alloy (E) [kg] | 1,72E-005 | 1,72E-005 | 0
Tetrabromobisphenol A (TBBA) (E) [kg] | 4,83E-006 | 4,83E-006 | 0
Tin (E) [kg] | 3,11E-007 | 3,11E-007 | 0
Tin in alloy (E) [kg] | 8,79E-005 | 8,79E-005 | 0
Unalloyed steel (Fe-C) (E) [kg] | 1,11E-005 | 1,11E-005 | 0
Zinc (E) [kg] | 1,65E-008 | 1,65E-008 | 0
Spreadsheet: 143584d1330467424-look-up-a-value-with-multiple-criteria-theoretically-should-be-a-simple-index-match-excel-forum-example2-modified-by-tigeravatar-
Sheet: Sheet1

Employees' Work Schedule
 | [NAME] | Becky | [NAME] | [NAME]
2012-02-23 00:00:00 |  |  |  |  |  | 1. =INDEX(Sheet2!$B$2:$I$15,MATCH($A3,Sheet2!$A$2:$A$15,0),MATCH(B$2,Sheet2!$B$1:$I$1,0))
2012-02-26 00:00:00
2012-02-28 00:00:00
2012-03-02 00:00:00
2012-03-05 00:00:00
2012-03-06 00:00:00
NOTE: Data source is on "Sheet2"
Spreadsheet: 58721d1258990778-excel-marco-vs-excel-functions-sample
Sheet: B1

 | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Forecast | Forecast
 | 2009-01-01 00:00:00 | 2009-02-28 00:00:00 | 2009-03-31 00:00:00 | 2009-04-30 00:00:00 | 2009-05-31 00:00:00 | 2009-06-30 00:00:00 | 2009-07-31 00:00:00 | 2009-08-31 00:00:00 | 2009-09-30 00:00:00 | 2009-10-31 00:00:00 | 2009-11-30 00:00:00 | 2009-12-31 00:00:00 | Total
Housing Allowance | 0.5426184866228807 | 0.829207810549704 | 0.7214916873234449 | 0.1264368450309012 | 0.2769065287249699 | 0.117409986284005 | 0.7451408869877207 | 0.5585756424123343 | 0.7059350375280504 | 0.1789260974004216 | 0.4746197033131452 | 0.8420070063688396 | 6.119275718546417
Legal Fee | 0.4087435473815004 | 0.5507092127743218 | 0.8089853052202742 | 0.2955884709942957 | 0.4167181742613497 | 0.9216546014694522 | 0.4106699720417093 | 0.9006261625511818 | 0.8563349784548226 | 0.7253716466788225 | 0.1119601585856429 | 0.6561608627951303 | 7.063523093208504
MV Expenses | 0.1474567774557469 | 0.5809790608871079 | 0.5489823475910827 | 0.0535701781090232 | 0.2808102509151329 | 0.4336179167451641 | 0.3973645757628255 | 0.5863080613410911 | 0.9343693198527963 | 0.2782888955031666 | 0.489891258418431 | 0.03751835475675702 | 4.769156997338325
Professional Fee | 0.5158616622247605 | 0.7930526059858523 | 0.07753242461506193 | 0.08850735100374774 | 0.3570325320884979 | 0.6490441187158367 | 0.8305999830824542 | 0.3574366736382739 | 0.6822460213005546 | 0.2709020775949669 | 0.1227192819552969 | 0.9027891828243435 | 5.647723915029647
Repair & Maintenance | 0.9020476776468231 | 0.2203439934715794 | 0.1683631112779194 | 0.6543084881305605 | 0.9008770623686722 | 0.9746026189108064 | 0.08537541325496889 | 0.04250556708339781 | 0.6074826373122457 | 0.06011908687843004 | 0.05682615285589709 | 0.735455869640443 | 5.408307678831743
Salary | 0.6043749887604264 | 0.4113742603651105 | 0.335759930392276 | 0.8741849033830604 | 0.6370147086320543 | 0.6241570572952932 | 0.7431622727663858 | 0.921781838033918 | 0.2229839513578051 | 0.6064316271992851 | 0.8563214433427324 | 0.1073909500127872 | 6.944937931541135
Stationery | 0.3463485427251527 | 0.3184475179645803 | 0.5081849278903618 | 0.2925067139879447 | 0.09002200508419644 | 0.6999755136669732 | 0.8576389294897908 | 0.6363179291891861 | 0.6070425228607244 | 0.7798782429460243 | 0.1393904551849032 | 0.03079361812849779 | 5.306546919118335
Spreadsheet: 838991d1691585946-count-of-unique-customers-by-month-assignment_repeat-analysis_ba-role
Sheet: Repeats_Summary_Copy

Number of Repeat Customers
Month | #New Customers | M1 | M2 | M3 | M4 | Total Repeat Customers |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sep
Sep-22 |  | 567 | 687 | 757 | 800 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oct
Oct-22 |  | 349 | 687 | 757 | 800 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nov
Nov-22 |  | 349 | 567 | 757 | 800 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dec
Dec-22 |  | 349 | 567 | 687 | 800 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan
Jan-23 |  | 349 | 567 | 687 | 757
Total
Spreadsheet: 813404d1673723834-data-duplicate-help-sample
Sheet: Sheet1

Location # | Item # | WEEKLY MOVEMENT | ON HAND | DEMAND AVG | PO NUMBER | ON ORDER
32 | 37010146 | 215 | 202 | 259.4 | 909006 | 360
32 | 37010146 | 215 | 202 | 259.4 | 910405 | 360
29 | 37010146 | 207.5 | 40 | 273.3 | 533336 | 180
29 | 37010146 | 207.5 | 40 | 273.3 | 493198 | 180
29 | 37010146 | 207.5 | 40 | 273.3 | 495277 | 180
29 | 37010146 | 207.5 | 40 | 273.3 | 497905 | 180
17 | 37010146 | 190 | 283 | 130.5 | 655696 | 180
17 | 37010146 | 190 | 283 | 130.5 | 653575 | 180
20 | 37010146 | 172.7 | 449 | 182.2 | 246490 | 180
27 | 37010146 | 171.6 | 547 | 191 | 456989 | 360
27 | 37010146 | 171.6 | 547 | 191 | 448438 | 180
25 | 37010146 | 119 | 852 | 195.5
5 | 37010146 | 111.1 | 180 | 125.7 | 908392 | 180
5 | 37010146 | 111.1 | 180 | 125.7 | 911048 | 180
5 | 37010146 | 111.1 | 180 | 125.7 | 912558 | 180
30 | 37010146 | 86 | 204 | 72.7 | 818787 | 180
34 | 37010146 | 80 | 241 | 96 | 791234 | 180
34 | 37010146 | 80 | 241 | 96 | 793214 | 180
33 | 37010146 | 58.6 | 161 | 85.4 | 781248 | 180
27 | 37010146 | 55 | 82 | 56.7 | 446896 | 180
19 | 37010146 | 46.8 | 312 | 86
27 | 37010146 | 23.8 | 52 | 24.5 | 456994 | 40
27 | 37010146 | 23.8 | 52 | 24.5 | 452749 | 40
Spreadsheet: 769870d1645714220-automation-for-dso-countback-methods-copie-de-debtor-days-countback-method
Sheet: Sheet1

 |  | 2020-06-30 00:00:00 | 2020-07-31 00:00:00 | 2020-08-31 00:00:00 | 2020-09-30 00:00:00 | 2020-10-31 00:00:00 | 2020-11-30 00:00:00 | 2020-12-31 00:00:00 | 2021-01-31 00:00:00 | 2021-02-28 00:00:00 | 2021-03-31 00:00:00 | 2021-04-30 00:00:00 | 2021-05-31 00:00:00 | 2021-06-30 00:00:00
Consolidated End of month debtor figures |  | 4017106.819999999 | 5568591.020000003 | 4500863.300000002 | 3987836.84 | 5123407.559999999 | 4477310.779999997 | 3630932.5 | 4508182.110000001 | 3316858.13 | 0 | 0 | 0 | 0
Consolidated Monthly billed amounts |  | 1785212.019999999 | 3599806.620000002 | 1389666.899999999 | 1463391.529999999 | 3372573.970000001 | 1442446.29 | 1567970.35 | 3138848.049999999 | 1567080.98 | 0 | 0 | 0 | 0
Count Back DSO
 |  |  | turnover | oustanding amount | nbr days | dso | Calcul
 |  | June |  | 4017106.819999999 | 30 |  |  |  | 30
 |  | July |  | 5568591.020000003 | 31 |  |  |  | 31
 |  | August |  | 4500863.300000002 | 31 |  |  |  | 31
 |  | September |  | 3987836.84 | 30 |  |  |  | 30
 |  | October |  | 5123407.559999999 | 31 |  |  |  | 31
 |  | November |  | 4477310.779999997 | 30 |  |  |  | 30
 |  | December |  | 3630932.5 | 31 |  |  |  | 31
 |  | January |  | 4508182.110000001 | 31 |  |  |  | 31
 |  | February |  | 3316858.13 | 28
Spreadsheet: 718116d1612989596-formula-to-consolidate-data-from-multiple-sheets-get-data-from-multiple-sheets
Sheet: 30

 |  |  | Date | 2021-01-30 00:00:00
Machine | From | To | Total Time | Failure Code | Extention Code | Delay Code | Equip. Name | Stoppage Code | Stoppage Description | Stoppage Category
Machine1 | 08:00:00 | 09:00:00 |  |  |  |  |  | 1000 | Stoppage 1 | Category 1
Machine1 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine2 | 12:00:00 | 13:00:00 |  |  |  |  |  | 1001 | Stoppage 3 | Category 3
Machine2 | 15:00:00 | 16:00:00 |  |  |  |  |  | 1001 | Stoppage 3 | Category 3
Machine3 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 4 | Category 1
Machine4 | 13:00:00 | 14:00:00 |  |  |  |  |  | 1004 | Stoppage 3 | Category 4
Machine4 | 13:00:00 | 14:00:00 |  |  |  |  |  | 1004 | Stoppage 3 | Category 4
Machine5 | 20:00:00 | 23:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine6 | 20:00:00 | 1 day, 0:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Spreadsheet: darrell_schoolcraft__7776__imbalsumm0106
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 63620 | 62288
2 | 56372 | 62291 | -749
3 | 56757 | 62291
4 | 62916 | 62291
5 | 66527 | 69603
6 | 60881 | 59228
7 | 60973 | 59228 | -12
8 | 61228 | 59228
9 | 51852 | 53798 | -6833 | -29491
10 | 55568 | 53798 | -22643 | -29491
11 | 56114 | 54900 | -25075 | -29491
12 | 53935 | 52158 | -9539
13 | 51646 | 52228
14 | 53995 | 52228
15 | 38248 | 45095 | -14
16 | 46431 | 46669 | -3
17 | 47069 | 45335
18 | 48894 | 47151
19 | 30288 | 46579
20
21
22
23
24
25
26
27
28
29
30
31
2001-05-31 00:00:00
2001-06-19 00:00:00
Spreadsheet: 1f1b1ce4-f60b-448a-a481-66d9dff26d29
Sheet: WebofScience

Web of Science
2004-2005
Metric | 2004-07-01 00:00:00 | 2004-08-01 00:00:00 | 2004-09-01 00:00:00 | 2004-10-01 00:00:00 | 2004-11-01 00:00:00 | 2004-12-01 00:00:00 | 2005-01-01 00:00:00 | 2005-02-01 00:00:00 | 2005-03-01 00:00:00 | 2005-04-01 00:00:00 | 2005-05-01 00:00:00 | 2005-06-01 00:00:00 | Total | 2004-2005 Price | Price per search
Sessions | 362 | 197 | 384 | 491 | 562 | 407 | 355 | 390 | 564 | 694 | 355 | 482
Queries | 1478 | 701 | 1295 | 1609 | 1891 | 1552 | 971 | 1316 | 2080 | 2838 | 1460 | 1388 |  | 85082
Maximum Contractual Users | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Turnaways | 4 | 0 | 32 | 2 | 2 | 0 | 0 | 10 | 15 | 0 | 0 | 9
Spreadsheet: 698642d1602091638-nested-vlookup-with-indirect-function-sample
Sheet: 2015

Number | Name | Combo
23234 | apple
32323 | [NAME]
4535 | [NAME]
656564 | greg
565 | pop
64646 | look
Spreadsheet: 491014d1480260752-creating-a-pivot-table-participants-by-month-when-i-only-have-the-start-and-end-dates-copy-of-help_needed_example
Sheet: Sheet1

ID | Course start date | Course end date | Course Duration Months | Course outcome
1 | 2012-08-28 00:00:00 | 2012-10-02 00:00:00 |  | refused
2 | 2012-09-04 00:00:00 | 2012-10-02 00:00:00 |  | finished
3 | 2012-09-30 00:00:00 | 2012-10-02 00:00:00 |  | finished
4 | 2012-10-02 00:00:00 | 2012-10-02 00:00:00 |  | refused
5 | 2012-10-02 00:00:00 | 2012-10-02 00:00:00 |  | finished
6 | 2012-10-02 00:00:00 | 2012-10-02 00:00:00 |  | finsihed
7 | 2012-10-02 00:00:00 | 2012-10-02 00:00:00 |  | started but didn't finish
8 | 2012-08-21 00:00:00 | 2012-10-03 00:00:00 |  | finsihed
9 | 2012-08-26 00:00:00 | 2012-10-03 00:00:00 |  | finsihed
10 | 2012-09-04 00:00:00 | 2012-10-03 00:00:00 |  | started but didn't finish
11 | 2012-09-04 00:00:00 | 2012-10-03 00:00:00 |  | finished
12 | 2012-09-09 00:00:00 | 2012-10-03 00:00:00 |  | finished
13 | 2012-09-09 00:00:00 | 2012-10-03 00:00:00 |  | started but didn't finish
14 | 2013-01-13 00:00:00 | 2013-01-16 00:00:00 |  | refused
15 | 2013-01-13 00:00:00 | 2013-01-16 00:00:00 |  | refused
16 | 2013-01-13 00:00:00 | 2013-01-16 00:00:00 |  | finished
17 | 2012-06-27 00:00:00 | 2013-01-17 00:00:00 |  | started but didn't finish
18 | 2012-07-15 00:00:00 | 2013-01-17 00:00:00 |  | finished
19 | 2012-09-30 00:00:00 | 2013-01-17 00:00:00 |  | started but didn't finish
Years | Course start date | Course end date | ID | Course outcome | Sum of Course Duration Months
2012 | Jun | 2013-01-17 00:00:00 | 17 | started but didn't finish | 8
 | Jul | 2013-01-17 00:00:00 | 18 | finished | 8
 | Aug | 2012-10-02 00:00:00 | 1 | refused | 3
 |  | 2012-10-03 00:00:00 | 8 | finsihed | 3
 |  |  | 9 | finsihed | 3
 | Sep | 2012-10-02 00:00:00 | 2 | finished | 2
 |  |  | 3 | finished | 2
 |  | 2012-10-03 00:00:00 | 10 | started but didn't finish | 2
 |  |  | 11 | finished | 2
 |  |  | 12 | finished | 2
 |  |  | 13 | started but didn't finish | 2
 |  | 2013-01-17 00:00:00 | 19 | started but didn't finish | 5
 | Oct | 2012-10-02 00:00:00 | 4 | refused | 2
 |  |  | 5 | finished | 2
 |  |  | 6 | finsihed | 2
 |  |  | 7 | started but didn't finish | 2
2013 | Jan | 2013-01-16 00:00:00 | 14 | refused | 2
 |  |  | 15 | refused | 2
 |  |  | 16 | finished | 2
Grand Total |  |  |  |  | 56
Spreadsheet: 824937d1680967209-sum-by-item-and-year-from-another-sheet-book1
Sheet: Sheet2

Inv | Date | Decription | Debit | Credit | Debit
 | 2022-12-30 00:00:00 | rent dec | Co-Operative Bank | Equity | 24662
 | 2022-12-30 00:00:00 | rent dec | Saleem | Equity | 2630
 | 2022-12-30 00:00:00 | rent dec | PK Stores | Equity | 4830
 | 2022-12-30 00:00:00 | rent dec | Cable TV | Equity | 1130
 | 2022-12-30 00:00:00 | rent dec | Falcon Tailors | Equity | 2020
 | 2022-12-30 00:00:00 | rent dec | Shafeeq | Equity | 5000
 | 2022-12-30 00:00:00 | bf | Cash In Hand |  | 3172
 | 2022-12-30 00:00:00 | bf | Cash In Bank |  | 7076
 | 2022-12-30 00:00:00 | sec shafeeq | Security Deposit |  | 7500
 | 2022-12-30 00:00:00 | adj | Management Fees | Management Fees | 0.01
 | 2023-01-30 00:00:00 | rent dec | Cash In Bank | Co-Operative Bank | 24662
 | 2023-01-30 00:00:00 | rent dec | Cash In Hand | Saleem | 2630
 | 2023-01-30 00:00:00 | rent dec | Cash In Hand | Cable TV | 1130
 | 2023-01-30 00:00:00 | rent dec | Cash In Hand | Falcon Tailors | 2020
 | 2023-01-30 00:00:00 | rent dec | Cash In Hand | Shafeeq | 5000
 | 2023-01-30 00:00:00 | ELEC | Cash In Hand | Misc Income | 350
 | 2023-01-30 00:00:00 | WATER | Cash In Hand | Misc Income | 100
 | 2023-01-30 00:00:00 | main | Maintenanace | Cash In Hand | 360
Spreadsheet: 715057d1611525932-populate-calendar-in-excel-from-list-help-any-year-custom-calendar1
Sheet: 9

 |  |  |  | Notes
 |  |  |  |  |  |  |  |  |  | [NAME] by Vertex42
 |  |  |  |  |  |  |  |  |  | https://www.vertex42.com/calendars/