tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 170545d1343312793-need-formula-macro-to-assign-training-classes-to-variable-sized-groups-excel-forum-example
Sheet: Sheet1

Staff | Center | Training Class To Attend
Wanser | DC | A
Esther | DC | B
[NAME] | DC | C
Miesha | DC | D
Gloria | DC | A
[NAME] | DC | B
[NAME] | VA
[NAME] | VA
[NAME] | VA
Frewoini | VA
Collin | VA
Suzanne | VA
Christine | VA
Pierrein | VA
Tiffany | VA
Yakob | MD
[NAME] | MD
[NAME] | MD
Natalia | MD
[NAME] | CA
[NAME] | CA
[NAME] | CA
Sonya | CA
[NAME] | CA
[NAME] | CA
Wayne | CA
Robyn | NC
Kimetra | NC
Galina | NC
[NAME] | NC
Eboni | NC
[NAME] | NC
[NAME] | NC
[NAME] | MA
[NAME] | MA
[NAME] | MA
Chadderick | MA
Fatin | MA
[NAME] | MA
[NAME] | MA
Karida | NY
Beverley | NY
Mozone | NY
Megan | NY
[NAME] | NY
Jaime | NY
Derrick | IL
Massomeh | IL
[NAME] | IL
Tomia | IL
Dawn | IL
[NAME] | IL
[NAME] | IL
Tamia | IL
Melody | IL
[NAME] | IL
Gulalai | IL
[NAME] | IL
Garry | IL
Diedria | IL
Curtis | FL
[NAME] | FL
[NAME] | FL
Rebecca | FL
Sabian | FL
[NAME] | FL
Ayebea | FL
[NAME] | FL
[NAME] | FL
[NAME] | FL
Spreadsheet: 109762d1306524477-excel-2007-specific-date-compared-to-date-range-terrip
Sheet: Year 12

 | Case Number |  |  |  |  | Date Prepared
 | Non Custodial Parent |  |  |  |  |  | Reconciliation Date
 | CP/Caretaker
 | YEAR 12:
 |  | Amount Due |  |  |  |  |  | Charging
 |  |  |  |  |  |  |  | Order
Month |  | ORDER 1 | ORDER 2 | ORDER 3 | ORDER 4 | ORDER 5 |  | Amount
133 | January
134 | February
135 | March
136 | April
137 | May
138 | June
139 | July
140 | August
141 | September
142 | October
143 | November
144 | December
 | Support Due
 | Support Paid
 | [NAME]
 | Accrued Arrearage
 | Last Year Carryover
 | Lump/TANF
 | This Year
 | Total
 | Interest Rate
 | Arrears Interest
 | Fees Due
 | Fees Paid
 | Fees Owed
Spreadsheet: 36497d1234373371-copying-between-worksheets-weatherizeb
Sheet: Cost

Section | Treatment | Cost
Attic | Add 9" blown in cellulose | 630
First floor walls
Second floor walls |  |  |  | When you put an entry column C, it will copy the B & C entries
Basement | Insulate interior with R-5 wrap | 472 | Reported 2/11/2009 | to the report page in the next empty cell. It will also indicate here
Heating system |  |  |  | in D that the "report" occurred.
Water heater
Windows |  |  |  | Since this is happening in realtime via a WorkSheet_change event,
Doors | Weather strip the back door | 24 | Reported 2/11/2009 | Excel loses the ability to UNDO things. A side effect, but at least
 | Weather strip the back door | 24 | Reported 2/11/2009 | you know.
 | dog door | 25 | Reported 2/11/2009
 |  |  |  | If you edit the column C, it will "report" the event again. Something to consider.
Spreadsheet: 976da9de-6c1c-400a-9950-e52fe6a15bb9
Sheet: Entitlement Details

 | Estimated Entitlement Budget Overview, SY 14
 | Estimated Total Entitlement Budget (taken from SY 13)
 | DoD Budget, SY 14
 | NOI Request, SY 14
 | Entitlement Balance Remaining for 6 state orders
 | NOI Request Overview | Dollars
 | Cheese
 | Eggs
 | Chicken
 | Turkey
 | Beef
 | Pork
 | Fruit Juice
 | Tomato Paste
 | [NAME]
 | [NAME]
 | Corn
 | [NAME]
 | Pollock
 | Potatoes
 | Total NOI Request
Spreadsheet: 42481d1241036241-sumifs-hlookup-test
Sheet: Schedule

Total Available Work Hours per Week |  | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50
Name/Week Starting |  | 2009-08-02 00:00:00 | 2009-08-09 00:00:00 | 2009-08-16 00:00:00 | 2009-08-23 00:00:00 | 2009-08-30 00:00:00 | 2009-09-06 00:00:00 | 2009-09-13 00:00:00 | 2009-09-20 00:00:00 | 2009-09-27 00:00:00 | 2009-10-04 00:00:00 | 2009-10-11 00:00:00 | 2009-10-18 00:00:00 | 2009-10-25 00:00:00 | 2009-11-01 00:00:00 | 2009-11-08 00:00:00 | 2009-11-15 00:00:00 | 2009-11-22 00:00:00 | 2009-11-29 00:00:00 | 2009-12-06 00:00:00 | 2009-12-13 00:00:00 | 2009-12-20 00:00:00 |  | Over/Under
Old McDonald | Target
Budget Hours | Budget
Actual Hours Billed | Actual
Workload
Old McDonald | Target
Budget Hours | Budget
Actual Hours Billed | Actual
Workload
Old McDonald | Target
Budget Hours | Budget
Actual Hours Billed | Actual
Workload
 | Target
 | Budget
 | Actual
[NAME] | Target
Budget Hours | Budget
Actual Hours Billed | Actual
Workload
[NAME] | Target
Budget Hours | Budget
Actual Hours Billed | Actual
Workload
[NAME] | Target
Budget Hours | Budget
Actual Hours Billed | Actual
Workload
 | Target
 | Budget
 | Actual
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Target %
Spreadsheet: 673970d1587614706-formula-to-list-all-cells-that-has-a-certain-value-text-book1
Sheet: Sheet1

District | Reject
115 | 0.00765278898691643
340 | 0.007180660152148994 |  | Listing 0.00%
241 | 0.006886924359764845 |  | Needed Output→ | No recorded Reject in District 224 and 789.
860 | 0.005518031269431262 |  | Output Formula→?
400 | 0.004475454065771059
704 | 0.003627006519898013
242 | 0.003385750179933342 |  | Listing No data
110 | 0.0004715936412289138 |  | Needed Output→ | No data in District 980, 981, 444, 805, 820, 310, 325 and 330.
224 | 1.479399870959185e-06 |  | Output Formula→?
780 | 0
980 | No data
981 | No data |  | NOTE: Data source is changing from time to time. So the number of 0.00% and No data is not fix. It will be more or less from the sample data source.
444 | No data
805 | No data
820 | No data
310 | No data
324 | No data
330 | No data
Spreadsheet: 133545d1324474903-excel-2007-combine-multiple-files-to-one-table-sumproduct-211211-
Sheet: 2010-05-17

Account | Copies | Prints | Scans
0 | 0 | 0 | 0
842 | 0 | 0 | 0
1065 | 0 | 0 | 0
1066 | 23 | 0 | 0
1105 | 0 | 0 | 0
1163 | 0 | 0 | 0
1340 | 0 | 0 | 0
1646 | 0 | 0 | 0
1667 | 16 | 3 | 0
10493 | 0 | 0 | 0
10555 | 0 | 0 | 0
10571 | 0 | 0 | 0
10716 | 0 | 0 | 0
10952 | 0 | 0 | 0
Spreadsheet: daren_farmer__5644__HPLN1227
Sheet: Sheet1

HPLN1227.XLS |  | Fax # [PHONE] |  |  |  | Revision #1
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - December 27, 2000
 |  |  |  |  |  | **Wednesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-12-27 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL | 30 | 30 | *
 |  | Firm Summary
Enron (S) |  | Oasis Turbine |  | Enron | 10 | 10
Enron (S) |  | LS HPL [NAME] |  | Enron | 0 | 0
Enron (S) |  | Texoma |  | Enron | 0 | 30 | *
Enron (S) |  | Oasis Sealy |  | Enron | 0 | 20 | *
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 885140d1734556879-add-or-remove-rows-to-only-part-of-the-columns-of-a-table-add-or-embedd-a-row-into-columns-of-an-existing-table-original
Sheet: BooKRef Team M

Team A
Surname | First name | Number | [NAME] | Task A | Part of Task A completed | Next part of Task A | x1 | Task B | Part of Task B completed | Next part of Task B | x2 | Task C | Part of Task C completed | Next part of Task C | [NAME] | Task D | Part of Task D completed | Next part of Task D
 |  |  |  | M03
 |  |  |  | M03
 |  |  |  | M18 | X |  |  | M25 IME | X
 |  |  |  | M03 | BSC-SF |  |  | M04 | BSC-SF
 |  |  |  | M07 | ADV-TR2 |  |  | M22 | ADV
Spreadsheet: 102065d1300123025-matching-data-and-expanding-results-links
Sheet: subs

 | Revenue | Profit | Jobs |  |  |  |  | Revenue | Profit | Jobs
supplier 1 | 16011.86 | 5288.14 | 5
high street | 16011.86 | 5288.14 | 5 |  |  |  | supplier 2 | 10252.54 | 166.5 | 1
supplier 2 | 10252.54 | 166.5 | 1 |  |  |  | supplier 1 | 16011.86 | 5288.14 | 5
[NAME] | 10252.54 | 166.5 | 1 |  |  |  | supplier 4 | 7958.29 | 2397.66 | 9
Supplier 4 | 7958.29 | 2397.66 | 9 |  |  |  | supplier 3 | 372.72 | 135.91 | 3
King street | 7573.79 | 2059.25 | 7 |  |  |  | - oke street | 241.1 | 120 | 1
oke close | 192.47 | 186.41 | 1 |  |  |  | -mast street | 1000.24 | 560 | 1
radial street | 192.03 | 152 | 1 |  |  |  | -st marks road | 26898 | 19050 | 15
Supplier 3 | 372.72 | 135.91 | 3
[NAME] | 372.72 | 135.91 | 3
- oke street | 241.1 | 120 | 1
-mast street | 1000.24 | 560 | 1
-st marks road | 26898 | 19050 | 15
result
supplier 1 | 16011.86 | 5288.14 | 5
high street | 16011.86 | 5288.14 | 5
supplier 2 | 10252.54 | 166.5 | 1
[NAME] | 10252.54 | 166.5 | 1
-st marks road | 26898 | 19050 | 15
Supplier 4 | 7958.29 | 2397.66 | 9
King street | 7573.79 | 2059.25 | 7
oke close | 192.47 | 186.41 | 1
radial street | 192.03 | 152 | 1
-mast street | 1000.24 | 560 | 1
Supplier 3 | 372.72 | 135.91 | 3
[NAME] | 372.72 | 135.91 | 3
- oke street | 241.1 | 120 | 1
Spreadsheet: 273326d1382673448-vlookup-or-if-statement-test-quote-program-excelforum
Sheet: Quotation

QUOTATION NO: |  |  |  |  |  |  |  |  |  |  |  |  |  | 116 CARNARVON STREET
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SILVERWATER  NSW  2128
TO: |  |  |  |  |  |  |  |  |  |  | TEL: |  |  | 02 9748 2022
CONTACT: |  |  |  |  |  |  |  |  |  |  | FAX: |  |  | 02 9748 2099
EMAIL/FAX: |  |  |  | PUMPS, FILTERS, TANKS AND PRESSURE VESSELS |  |  |  |  |  |  | EMAIL: |  |  | [EMAIL]
SITE: |  |  |  |  | RE:  LONG-COUPLED PUMPSETS |  |  |  |  |  | DATE:
ITEM | FUNCTION | Q | FLOW | HEAD | RPM | SELECTION | MOTOR | PUMP | IMP | MAX | UNIT |  |  | TOTAL
 |  |  | (L/S) | (M) |  |  | KW | EFF (%) | DIAM | IMP | PRICE |  |  | PRICE
TOTAL PUMPSETS |  |  |  |  |  |  |  |  |  |  |  |  | DELIVERY
 |  |  |  |  |  |  |  |  |  |  |  |  | SUBTOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  | GST
DELIVERY within Sydney/Canberra/Wollongong/melbourne/Brisbane/Perth/Townsville Metropolitan Area between Monday - Friday. One delivery only. |  |  |  |  |  |  |  |  |  |  |  |  | GRAND TOTAL
PRICE INCLUDES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ,'Costing 2'!C7:C10
 |  |  |  |  |  |  |  |  |  | This is the active / test formula I am referring to my post
PRICE INCLUDES: CI:BR:SS construction [NAME] pumps which are Vertical [NAME], Back Pull Out, manufactured to DIN 24255/ISO2858 standard. Mechanical Seals; Cyclone separators & Flush lines; Spacer Couplings.  Electric motors are TEFC; Compliant with the MEPS 2 efficiency level; IP55 protection for indoor plantroom location / IP56 weatherproof protection for external location; 4 pole / 2 pole; Tropic Proofed; Thermistors fitted  > 11kw. Pumpsets are mounted on [NAME], with Spring mounts supplied loose which are 25mm / 50[NAME] deflection; [NAME]; Inertia bases; SS Drip Trays on Chilled Water Pumps; Industrial Enamel Painting.   ☺are Vertical Multistage pump/s mounted on baseplate with R.I.S. mounts supplied loose (due to small footprint, inertia base is not necessary/included).   Availability: # to # working days/weeks from receipt of a technically & commercially approved written purchase order – subject to confirmation at time of order. Terms & Conditions:  As per Schedule ‘A’ available on request. This quote and all related invoices from [NAME] are submitted under the Terms of the Building and Construction Industry Security of payment Act 1999. Validity of Quote: 2 months. Terms of Payment: Strictly nett 30 days. Please advise your shut off date for invoices.  Warranty: Limited to 12 months from date of installation or 18 months from date of invoice (which ever is earlier). Does not include labour.
COMMENTS/EXTRAS: * Onsite coupling alignment is applicable  - allow an estimate of $0.00 + GST (based on one site visit only) * Cyclone separators not included an dnot recommended by manufacturer on hot water pumps. Flush line only. * All the above selctions allow for at least one impeller change without changing the motor. * Vibration Eliminators (Rubber Bellows) are available ex-stock. Please call for pricing.
Kind Regards,
Spreadsheet: 774354d1648416603-need-help-in-creating-an-automated-table-from-a-column-ef1570_time_summary
Sheet: Sheet1

2022-02-28 23:54:26
2022-02-28 23:55:31 |  |  |  | Monday | Tuesday | Wednesday | Thursday | Friday
2022-02-28 23:57:26 |  |  | 23:00:00
2022-03-01 00:13:39
2022-03-01 00:15:35
2022-03-01 00:15:57
2022-03-01 00:20:50
Spreadsheet: 765816d1643624032-compare-2-columns-on-multiple-values-exdata2
Sheet: This Month

Product | Subscription key | Company | Usage | Total seats
Product1 | abc123 | Comp1 | 10 | 20
Product2 | def456 | Comp1 | 4 | 5
Product1 | ghi789 | Comp1 | 4 | 4
Product3 | jkl123 | Comp1 | 1 | 1
Product2 | mno456 | Comp1 | 19 | 19
Product1 | pqr789 | Comp1 | 1 | 1
Product2 | stu123 | Comp1 | 5 | 5
Product1 | vwx456 | comp2 | 25 | 25
Product3 | yza789 | comp3 | 5 | 5
Product2 | bcd123 | comp2 | 19 | 20
Product1 | efg456 | comp2 | 42 | 46
Product2 | hij789 | comp3 | 8 | 8
Product1 | klm123 | comp2 | 36 | 40
Product3 | nop456 | comp3 | 19 | 19
Product2 | qrs789 | comp2 | 2 | 2
Product1 | tuv123 | comp2 | 4 | 4
Product2 | wxy456 | comp3 | 2 | 2
Spreadsheet: 1c11df3c-2bb2-43e0-89c6-78e49c402be9
Sheet: Sheet1

* 2004 수출총괄표 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | (단위:US$)
구분 | 수출목표 | 2003 | 2004 | 목표대비 | 전년대비(%)
원료의약품 | 425000000 | 441591620 | 416894458 | 0.981 | 0.9441
완제의약품 | 350000000 | 296916844 | 356090119 | 1.0174 | 1.1993
(의약외품) |  | -46649124 | -63616292
한약재 | 5500000 | 5312575 | 5477603 | 0.996 | 1.0311
화장품 | 170000000 | 150646576 | 219009881 | 1.2883 | 1.4538
계 | 950500000 | 894467615 | 997472061 | 1.0495 | 1.1152
* 2005 의약품등 수출목표 |  |  |  |  | (단위:US$)
구분 | 2004목표 | 2005묙표 | 증감율 | 구성비
원료의약품 | 425000000 | 420000000 | -0.0118 | 0.4019
완제의약품 | 350000000 | 379000000 | 0.0829 | 0.3627
(의약외품)
한약재 | 5500000 | 6000000 | 0.0909 | 0.0057
화장품 | 170000000 | 240000000 | 0.4118 | 0.2297
계 | 950500000 | 1045000000 | 0.0995 | 1
Spreadsheet: 707828d1607490761-array-index-problems-need-assistance-or-any-advice-to-help-to-create-formula-to-enable-to-book1
Sheet: Sheet2

Information in Spreadsheet 2
Family ID | Student ID | Student Name
2022 | 1000 | Adam
2023 | 1001 | Aarron
2023 | 1002 | [NAME]
2841 | 1003 | Rachel
2841 | 1004 | Phoebe
2405 | 1005 | Mark
2026 | 1006 | Calum
2378 | 1007 | Aiden
2377 | 1008 | [NAME]
2378 | 1009 | Petra
2028 | 1010 | [NAME]
2691 | 1011 | [NAME]
2331 | 1012 | Kaden
Spreadsheet: 162784d1340060664-copy-of-managers-clients-info-from-master-list-database-example
Sheet: Breakdown

 |  | Security Deposit | Rent/Fee | Moving Costs | Utility Deposit | Utility/Fee | Emergency Supplies | Transportation | Monthly Total by Cat | YTD Total by Cat
Cat 1 | 2011-10-01 00:00:00
Cat 1 | 2011-11-01 00:00:00
Cat 1 | 2011-12-01 00:00:00
 | Q1  Cat 1Total
Cat 2 | 2001-10-01 00:00:00
Cat 2 | 2011-11-01 00:00:00
Cat 2 | 2011-12-01 00:00:00
 | Q1 Cat 2 Total
Cat 3 | 2011-10-01 00:00:00
Cat 3 | 2011-11-01 00:00:00
Cat 3 | 2011-12-01 00:00:00
 | Q1 Cat 3 Total
 | Q1 Cat 2 & 3 Total
 | Q1 Total
Cat 1 | 2012-01-01 00:00:00
Cat 1 | 2012-02-01 00:00:00
Cat 1 | 2012-03-01 00:00:00
 | Q2  Cat 1 Total
Cat 2 | 2012-01-01 00:00:00
Cat 2 | 2012-02-01 00:00:00
Cat 2 | 2012-03-01 00:00:00
 | Q2 Cat 2 Total
Cat 3 | 2012-01-01 00:00:00
Cat 3 | 2012-02-01 00:00:00
Cat 3 | 2012-03-01 00:00:00
 | Q2 Cat 3 Total
 | Q2 Cat 2 & 3 Total
 | Q2 Total
Cat 1 | 2012-04-01 00:00:00
Cat 1 | 2012-05-01 00:00:00
Cat 1 | 2012-06-01 00:00:00
 | [NAME]
Cat 2 | 2012-04-01 00:00:00
Cat 2 | 2012-05-01 00:00:00
Cat 2 | 2012-06-01 00:00:00
 | [NAME]
Cat 3 | 2012-04-01 00:00:00
Cat 3 | 2012-05-01 00:00:00
Cat 3 | 2012-06-01 00:00:00
 | [NAME] 3 Total
 | [NAME] 3 Total
 | Q3 Total
Cat 1 | 2012-07-01 00:00:00
Cat 1 | 2012-08-01 00:00:00
Cat 1 | 2012-09-01 00:00:00
 | [NAME]
Cat 2 | 2012-07-01 00:00:00
Cat 2 | 2012-08-01 00:00:00
Cat 2 | 2012-09-01 00:00:00
 | [NAME]
Cat 3 | 2012-07-01 00:00:00
Cat 3 | 2012-08-01 00:00:00
Cat 3 | 2012-09-01 00:00:00
 | [NAME] 3 Total
 | Q4 Cat 2 & 3 Total
 | Q4 Total
 | Total
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: Office of the Chair

 | 2002 Plan
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  |  |  |  | Per HC | New HC | Adj Comp |  | 2002
 |  | YTD Actual |  | Annualized | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  |  |  |  |  | Compensation | 0
 | Analyst & Assoicate | 0 |  |  | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services | 0 |  |  |  |  |  |  | Total
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions
ENARENT | Rent |  |  |  |  |  |  |  | [NAME] | 55000 | 3
ENATECH | Technology |  |  |  |  |  |  |  | COO | 250000 | 1
ENATRANS | Transportation |  |  |  |  |  |  |  | CEO | 250000 | 2
ENAOTHEX | Other Expenses
ENATAXES | Taxes Other than Income
ENATOTDR | Total Direct Expenses
 | Headcount |  |  | 5 | 6 |  |  | Other Expense Calculation
 | A&A Headcount |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses
ENADEPR | Depreciation & Amortization
ENAOUTSV | Outside Services | 24143776.43 |  | 32191701.90666667
 | Other Expenses | 243106037
Spreadsheet: 168098d1342213735-excel-2007-cumulative-projectied-cash-flow-income-flow
Sheet: CashFlow1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Total
Platinum Membership
Silver Membership
Bronze Membership
Personal Training
Nutrition Plan |  |  |  |  |  |  |  |  |  |  |  |  | 60000
Massage
Selling Merchandise
Total Sales
Equipment Network Furniture
License Fees
Office Supplies
Repair / Maintence
Insurance
Phone / Internet
security system
Accounting
Advertising
Rent
Wages
Loan Payment | 8333.34 | 8333.34 | 8333.34 | 8333.34 | 8333.34 | 8333.34 | 8333.34 | 8333.34 | 8333.34 | 8333.34 | 8333.34 | 8333.34
Interest | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250
Total Disbursements
Net
Cumulative Net
Spreadsheet: 68269d1268796692-show-billing-cycle-for-a-month-datamarch2010
Sheet: Data Entry

S.No | Transaction Date | Month | Amount | Billing  Cycle | Billed Date | Due Date | Remarks
1 | 2007-05-19 00:00:00 | [NAME] | 6767 | 21/04/07 - 20/05/07 | 21/05/2007 | Due date is 15 days post to Billed date |  | January | 1
2 | 2007-05-19 00:00:00 | [NAME] | 203.01 | 21/04/07 - 20/04/07 |  |  |  | February | 2
3 | 2007-05-24 00:00:00 | [NAME] | 25.09 | 21/04/07 - 20/04/07 |  |  |  | March | 3
4 | 2007-06-24 00:00:00 | [NAME] | 250 | 21/05/07 - 20/05/07 |  |  |  | April | 4
5 | 2007-06-24 00:00:00 | [NAME] | 2255.66 | 21/05/07 - 20/05/07 |  |  |  | May | 5
6 | 2007-07-24 00:00:00 | July'2007 | 2255.67 | 21/06/07 - 20/06/07 |  |  |  | June | 6
7 | 2007-08-24 00:00:00 | August'2007 | 2255.67 | 21/07/07 - 20/07/07 |  |  |  | July | 7
8 | 2007-09-23 00:00:00 | September'2007 | 11990 | 21/08/07 - 20/08/07 |  |  |  | August | 8
9 | 2007-10-13 00:00:00 | October'2007 | 760 | 21/09/07 - 20/09/07 |  |  |  | September | 9
10 | 2007-10-24 00:00:00 | October'2007 | 2132 | 21/09/07 - 20/09/07 |  |  |  | October | 10
11 | 2007-12-02 00:00:00 | December'2007 | 1373.28 | 21/11/07 - 20/11/07 |  |  |  | November | 11
12 | 2007-12-02 00:00:00 | December'2007 | 1263.34 | 21/11/07 - 20/11/07 |  |  |  | December | 12
13 | 2007-12-12 00:00:00 | December'2007 | 788 | 21/11/07 - 20/11/07
14 | 2007-12-18 00:00:00 | December'2007 | 1147 | 21/11/07 - 20/11/07
15 | 2008-04-05 00:00:00 | April'2008 | 1395 | 21/03/08 - 20/03/08
16 | 2008-04-21 00:00:00 | April'2008 | 141.68 | 21/03/08 - 20/03/08
17 | 2008-04-21 00:00:00 | April'2008 | 17.51 | 21/03/08 - 20/03/08
18 | 2008-05-05 00:00:00 | May'2008 | 895 | 21/04/08 - 20/04/08
19 | 2008-05-21 00:00:00 | May'2008 | 14.4 | 21/04/08 - 20/04/08
20 | 2008-08-13 00:00:00 | August'2008 | 3290 | 21/07/08 - 20/07/08
21 | 2008-09-24 00:00:00 | September'2008 | 414 | 21/08/08 - 20/08/08
22 | 2008-09-25 00:00:00 | September'2008 | 3290 | 21/08/08 - 20/08/08
23 | 2008-09-25 00:00:00 | September'2008 | 250 | 21/08/08 - 20/08/08
24 | 2008-11-16 00:00:00 | November'2008 | 1216.51 | 21/10/08 - 20/10/08
25 | 2008-11-16 00:00:00 | November'2008 | 1216.51 | 21/10/08 - 20/10/08
26 | 2008-11-16 00:00:00 | November'2008 | 208.69 | 21/10/08 - 20/10/08
27 | 2008-11-16 00:00:00 | November'2008 | 208.69 | 21/10/08 - 20/10/08
28 | 2008-11-16 00:00:00 | November'2008 | 1350.89 | 21/10/08 - 20/10/08
29 | 2008-11-16 00:00:00 | November'2008 | 1350.89 | 21/10/08 - 20/10/08
30 | 2008-11-16 00:00:00 | November'2008 | 683.08 | 21/10/08 - 20/10/08
31 | 2008-11-30 00:00:00 | November'2008 | 950 | 21/10/08 - 20/10/08
32 | 2008-11-30 00:00:00 | November'2008 | 2350 | 21/10/08 - 20/10/08
33 | 2008-11-26 00:00:00 | November'2008 | 402 | 21/10/08 - 20/10/08
34 | 2009-01-01 00:00:00 | January'2009 | 11526 | 21/00/09 - 20/00/09
Spreadsheet: 717379d1612623710-using-a-dynamic-range-with-large-function-dates-table
Sheet: Sheet1

 |  |  |  |  | 2021-07-05 00:00:00 |  |  |  | Date |  | Date
 |  |  |  | 1 |  |  |  |  | 2021-09-05 00:00:00 |  | 2021-08-10 00:00:00
 |  |  |  |  | 2021-08-10 00:00:00 |  |  |  | 2021-10-10 00:00:00 |  | 2021-09-09 00:00:00
 |  |  |  |  | 2021-08-31 00:00:00 |  |  |  | 2022-02-02 00:00:00 |  | 2022-07-15 00:00:00
 |  |  |  |  | 2021-09-05 00:00:00 |  |  |  | 2022-03-06 00:00:00
 |  |  |  |  | 2021-09-09 00:00:00
 |  |  |  |  | 2021-09-30 00:00:00
 |  |  |  |  | 2021-10-10 00:00:00
 |  |  |  |  | 2021-10-31 00:00:00
 |  |  |  |  | 2021-11-30 00:00:00
 |  |  |  |  | 2021-12-31 00:00:00
 |  |  |  |  | 2022-01-31 00:00:00
 |  |  |  |  | 2022-02-02 00:00:00
 |  |  |  |  | 2022-02-28 00:00:00
 |  |  |  |  | 2022-03-06 00:00:00
 |  |  |  |  | 2022-03-31 00:00:00
 |  |  |  |  | 2022-04-30 00:00:00
 |  |  |  |  | 2022-05-31 00:00:00
 |  |  |  |  | 2022-06-30 00:00:00
 |  |  |  |  | 2022-07-15 00:00:00
 |  |  |  |  | 2022-07-31 00:00:00
 |  |  |  |  | 2022-08-31 00:00:00
 |  |  |  |  | 2022-09-30 00:00:00
 |  |  |  |  | 2022-10-31 00:00:00
 |  |  |  |  | 2022-11-30 00:00:00
 |  |  |  |  | 2022-12-31 00:00:00
 |  |  |  |  | 2023-01-31 00:00:00
 |  |  |  |  | 2023-02-28 00:00:00
Spreadsheet: 791050d1660135404-how-to-count-comma-separated-numbers-from-entire-column-showing-result-in-another-column-example-1-2-
Sheet: Sheet1

100
200, 300
100, 200, 400
700, 900
500
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Two (comma separated) numbers in A2 should be numbered as 1, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Three (comma separated) numbers in [NAME] should be numbered as 1, 2, 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | and etc.
Spreadsheet: 271957d1382116694-need-help-with-a-formula-to-populate-a-summary-table-exceltables-v2
Sheet: Sheet1

 | (miscExpensesTable) |  |  |  |  |  | (miscExpensesSummary table output example - dates are 'week beginning on')
 | Code | Date | Amount |  |  |  | Code | 10/7/2013 | 10/14/2013 | 10/21/2013
 | b | 2013-10-08 00:00:00 | 6 |  |  |  | 3 | 4 | -2
 | a7 | 2013-10-21 00:00:00 | 2 |  |  |  | 14 | 11
 | 14 | 2013-10-12 00:00:00 | 3 |  |  |  | a7 | 9 |  |  |  |  |  | IGNORE THIS STUFF
 | 3 | 2013-10-17 00:00:00 | -7 |  |  |  | b | 6 |  |  |  |  |  | SEE TEXT BOX BELOW
 | gh | 2013-10-11 00:00:00 | 12 |  |  |  | gh | 12 |  | 4 |  |  |  | INSTEAD
 | a7 | 2013-10-08 00:00:00 | 9 |  |  |  | xx
 | gh | 2013-10-21 00:00:00 | 4
 | 14 | 2013-10-12 00:00:00 | 8
 | 3 | 2013-10-19 00:00:00 | 5
 | 3 | 2013-10-13 00:00:00 | 4
 | xx | 2013-10-16 00:00:00 | 0 |  | << xx entry appears in the Summary table above because $$=0, not blank (this is a place holder entry).
 | yy | 2013-10-21 00:00:00 |  |  | << yy  entry doesn't appear in the Summary table above because $$ is blank, not 0.
 | zz |  | 18 |  | << zz  entry doesn't appear in the Summary table because one (or more) of the entry cells is blank.