tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 86864d1286824606-graph-for-comparing-test
Sheet: ds

I1 | I2 | I3 | I4 | I5
1 | 0.49501704 | 0.14664732 | 0.03216803 | 0.00572549
1 | 0.96722397 | 0.50791114 | 0.18966311 | 0.05602513
1 | 0.51337907 | 0.15374029 | 0.03383534 | 0.00600912
1 | 0.49478702 | 0.14653349 | 0.03213432 | 0.0057181
1 | 0.48320944 | 0.13682072 | 0.02851421 | 0.00479802
1 | 0.24646282 | 0.03524291 | 0.00370264 | 0.00030885
1 | 0.2463478 | 0.03521458 | 0.00369859 | 0.00030842
1 | 0.24646282 | 0.03524291 | 0.00370264 | 0.00030885
1 | 0.19473349 | 0.34578156 | 0.06487782 | 0.00857982
1 | 0.24646282 | 0.03524291 | 0.00370264 | 0.00030885
1 | 0.24646282 | 0.03524291 | 0.00370264 | 0.00030885
1 | 0.46714118 | 0.13953221 | 0.03120644 | 0.00573476
1 | 0.23480611 | 0.0304415 | 0.0028399 | 0.00020745
1 | 0.26455158 | 0.36141889 | 0.08944916 | 0.01382186
1 | 0.2647816 | 0.36147976 | 0.0895323 | 0.01384244
1 | 0.48309442 | 0.13676516 | 0.02849848 | 0.00479474
1 | 0.19484851 | 0.34580396 | 0.06491759 | 0.00858728
1 | 0.29917666 | 0.69677709 | 0.19953925 | 0.13991827
1 | 0.29906165 | 0.69674269 | 0.19945911 | 0.13989533
1 | 0.52933318 | 0.79294704 | 0.37030857 | 0.20568031
1 | 0.29894663 | 0.69670831 | 0.19937898 | 0.13987239
Spreadsheet: 482de8e0-e366-461c-9349-c76d85798b7f
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
CRYPU | Test | CRYPU | [NAME], [NAME] | Cryptococcus Ag, [NAME] | Latex Agglutination | [NAME], round-bottom, plastic vial: ScwRBPl |  |  | 0.5 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 0.5 mL Collection Instructions:  1. Collect a random urine specimen. 2. No preservative. | 0.25 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | Negative | Monday through Sunday; Variable | 1 day | 2 days | 1 | 86403 |  |  |  |  | Rochester
CRYPU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
CRYPU | Result | 60319 | Cryptococcus Ag, [NAME] | Cryptococcus Ag, [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43228-6
Spreadsheet: 106879d1304019933-adding-and-subtracting-negative-and-positive-numbers-book1
Sheet: Sheet1

Cost Per Rep Breakdown
Sales Rep
[NAME] |  |  |  | [NAME] | Anne | [NAME] | Cassy | [NAME] | Kenny | [NAME] | [NAME] | [NAME] | [NAME] | Tiara | TJ
 |  | Totals:
Deals: |  |  |  | 8 | 21 | 9 | 6 | 2 | 14 | 4 | 5 |  | 2 | 4 | 18
 | Revenue: |  |  | 7324.22 | 19139.47 | 7968.81 | 4839.35 | 1834.13 | 12178.25 | 4159.27 | 6985.97 |  | 1883.03 | 3582.25 | 15231.08
Lead Cost: |  |  |  | 3796.9 | 3796.9 | 3796.9 | 3796.9 | 2700 | 3796.9 | 3796.9 | 3796.9 | 1096.9 | 1096.9 | 3796.9 | 3796.9
Employee Cost: |  |  |  | 1002.87 | 1555 | 1380 | 1535 | 1434.63 | 1375 | 935.38 | 1160 | 365 | 377.5 | 1545 | 1405
Employee Commish: |  |  |  | 175 | 775 | 425 | 150 | 175 | 425 | 400 | 300 | 0 | 125 | 275 | 450
Total Cost Per Rep:
Net Per Sales Rep:
Deals: |  |  |  |  |  |  | Weekly Change:
Revenue |  |  | Weeks:
Total Net B4 Bills: |  |  | 1
 |  |  | 2 | 2706.4 | 10422.09 | 1528.97 | 195 | -2384.87 | 6245.41 | 409.14 | 2221.34 | 0 | 0 | -487.75 | 7391.6
Rent/Phone/Ins. Etc. |  | 15000 | 3 | -356.95 | 2590.48 | 837.94 | -447.55 | -90.63 | 335.94 | -563.87 | -492.27 | -1461.9 | 283.63 | -2522.43 | 2187.58
Managers: |  | 13638 | 4
Total Net Profit: |  |  | 5
 |  |  | Months: |  |  |  | Monthly Change:
 |  |  | A |  |  |  |  |  |  |  |  |  |  | -2034.65
 |  |  | M
 |  |  | J
 |  |  | J
 |  |  | A
 |  |  | S
 |  |  | O
 |  |  | N
 |  |  | D
Spreadsheet: 08172964-84f9-4cec-8ed6-dd8dc6c970ca
Sheet: 4ED

4ED RANKING OUT OF 72
ANON# | RANK
3701 | 2
4043 | 15
6298 | 14
16688 | 13
16809 | 8
23106 | 18
23955 | 11
46156 | 7
46371 | 17
69366 | 5
69462 | 10
69492 | 6
69510 | 3
75896 | 1
76166 | 16
82432 | 12
82678 | 9
99589 | 4
Spreadsheet: 746125d1630515899-count-how-many-times-duplicate-occasions-appear-sample
Sheet: Sheet1

 | Weight
 | 11.920
 | 7.662 | 1 repeat
 | 7.662
 | 7.662
 | 12.050
 | 11.980
 | 11.940
 | 11.840 | 1 repeat
 | 11.840
 | 11.830
 | 11.710
 | 11.970
Spreadsheet: 71232d1271930246-copying-entries-between-worksheets-copy-of-account-ledger2
Sheet: Subaccount 2

 |  |  |  |  |  |  |  |  |  | YTD P&L Subtotal | -2700
 |  |  |  |  |  |  |  |  |  | Adjustments
 |  |  |  |  |  |  |  |  |  | YTD P&L Total | -2700
 | Date | Description | Bills | Supplies | IT | Transportation | Misc. Charges | Invoice Paid | Invoice Received | Notes | Balance
 | 2010-04-05 00:00:00 | Beginning Balance |  |  |  |  |  |  |  |  | 5000
 | 2010-04-06 00:00:00 | Purchase |  | -50 |  |  |  |  |  |  | 4950
 | 2010-04-07 00:00:00 | Purchase |  | -150 |  |  |  |  |  |  | 4800
 | 2010-04-08 00:00:00 | Purchase | -2500 |  |  |  |  |  |  |  | 2300
 |  |  | -2500 | -200 | 0 | 0 | 0 | 0 | 0
 | NOTES:
Spreadsheet: 731539d1620395754-highlight-date-range-on-calendar-data
Sheet: Hire

 |  |  |  |  |  |  |  |  | HIRE RECORD
Hire Start Date | M/C No. | Customer | Site | Machine Hours | Hire End Date | Machine Hours | Hire Period Weeks | Total Hire Hours | Comments
2020-02-17 00:00:00 | 3099 | Suez | [NAME] | 9712 | 2020-04-18 00:00:00 | 10102
2020-05-08 00:00:00 | 3099 | Suez | [NAME] | 10108 | 2020-05-28 00:00:00 | 10307
2020-05-01 00:00:00 | 3099 | Levenseat | Lanark
2020-06-10 00:00:00 | 3099 | Levenseat | Lanark | 10310 | 2020-06-17 00:00:00 | 10326
2020-07-06 00:00:00 | 3099 | Levenseat | Lanark |  | 2020-07-10 00:00:00
2020-07-13 00:00:00 | 3099 | Suez | Bredbury | 10331 | 2020-08-07 00:00:00 | 10614 |  |  | Flat battery
2020-09-21 00:00:00 | 3099 | H & H Waste | Aylesbury | 10620 | 2020-09-23 00:00:00
2020-09-30 00:00:00 | 3099 | Crapper & Sons | [NAME] | 10630 | 2020-11-17 00:00:00 | 10817 |  |  | FOC for transport - NOW CHARGEABLE  6mth hire
2020-10-22 00:00:00 | 3153 | LondonEnergy | LondonEnergy | 17 | 2020-11-17 00:00:00 | 81 |  |  | incs delivery hours from Metso (17) = 64
2020-11-17 00:00:00 | 3153 | Crapper & Sons | [NAME] | 81 |  |  |  |  | Del straight fr LE trial
2020-11-24 00:00:00 | 3099 | Recycling Lives | Preston | 10817 | 2020-11-24 00:00:00 | 10820 |  |  | Metso demo for 3 hrs, then hired
2020-11-24 00:00:00 | 3099 | Recycling Lives | Preston | 10820 | 2020-12-04 00:00:00 | 10854 |  |  | Metso demo then hired
2020-11-25 00:00:00 | 3103 | Dickinsons | [NAME] | 7625 | 2020-11-25 00:00:00 |  |  |  | Metso demo for 4 hrs, then hired
2020-11-25 00:00:00 | 3103 | Dickinsons | [NAME] | 7629 |  |  |  |  | Metso demo then hired
2020-12-08 00:00:00 | 3099 | Transwaste | Hull | 10854 | 2021-01-28 00:00:00 | 11085 |  |  | Hired
2021-03-22 00:00:00 | 3118 | Metso | Countrystyle | 5235 | 2021-03-24 00:00:00 |  |  |  | Demo for Metso - 24 hours
2021-03-25 00:00:00 | 3118 | Metso | LondonEnergy |  |  |  |  |  | Hired by Metso for new shredder del delay
2021-03-25 00:00:00 | 3099 | Transwaste | Hull
Spreadsheet: 858820d1707346668-converting-time-zones-timezone-2
Sheet: Sheet1

2023-12-07 21:29:13
2023-12-07 21:29:57
2023-12-07 21:33:22
2023-12-07 21:40:08
2023-12-07 21:40:33
2023-12-07 22:29:27
13/07/2023 00:11:09
13/07/2023 00:15:53
13/07/2023 00:16:04
13/07/2023 00:16:23
Spreadsheet: 185649d1349793706-array-formula-how-to-sumif-with-dates
Sheet: test

 |  | week start | week end | sum |  | week start | week end
 |  |  |  | 15 |  | 2013-01-06 00:00:00 |  |  | << Look at this formula.
 |  | 2013-01-06 00:00:00 | 2013-03-07 00:00:00 | 15
 |  |  |  | 10
 |  |  |  | 8
 |  |  |  | 5
Spreadsheet: 700469d1603201980-increasing-the-year-in-a-column-sheet-for-edit-gk
Sheet: Sheet 1

Table 1
Member No | Title | Forenames | Surname | D.O.B. | Address | Telephone | Mobile | E-Mail | Club Join Date | Club [NAME]
Count: 85
20604723 | Mr |  |  |  |  |  |  |  | 1998-02-22 00:00:00
823439 | Mr |  |  |  |  |  |  |  | 1998-12-01 00:00:00
Spreadsheet: 784984d1656061283-unique-sort-filter-validation-lists-and-arrays-picker
Sheet: Sheet2

Pick | Count | Output | Picker
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME],Ford |  | Pick | Parent
[NAME],[NAME] |  | [NAME] | Adair
[NAME],Adair
[NAME],Hernandez
[NAME],Jenkins
[NAME],[NAME]
[NAME],Rodriguez
[NAME],[NAME]
[NAME],Ledger
[NAME],[NAME]
[NAME] | Hernandez
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 43419d1242085155-summarizing-data-over-several-sheets-test-summary
Sheet: BoltsP2

 | BOLTS LIST | BOLTS LIST
CLIENT |  | 0 |  |  |  | JOB No. |  | 0
PLANT |  | 0 |  |  |  |  | LIST No.  2   of  2
 |  | ALL BOLTS GRADE 8.8 ZINC PLATED |  | BOLTS |  | NUTS |  | WASHERS
ITEM | GRIP | [NAME] OF JOINT | QTY | DIA | LGTH | NYLCK | HEX | FORM C | SPRING
20 |  |  |  |  | #N/A
21 |  |  |  |  | #N/A
22 |  |  |  |  | #N/A
23 |  |  |  |  | #N/A
24 |  |  |  |  | #N/A
25 |  |  |  |  | #N/A
26 |  |  |  |  | #N/A
27 |  |  |  |  | #N/A
28 |  |  |  |  | #N/A
29 |  |  |  |  | #N/A
30 |  |  |  |  | #N/A
31 |  |  |  |  | #N/A
32 |  |  |  |  | #N/A
33 |  |  |  |  | #N/A
34 |  |  |  |  | #N/A
35 |  |  |  |  | #N/A
36 |  |  |  |  | #N/A
37 |  |  |  |  | #N/A
38 |  |  |  |  | #N/A
Spreadsheet: 481584d1474541433-allocating-payment-across-a-series-of-invoices-payment-samplev2
Sheet: Remittance 

Payment to allocate | 5200
SUPPLIER STATEMENT |  |  |  | Payment to
Invoice Number | Invoice Date | Amount |  | Allocate
1001 | 2016-02-01 00:00:00 | 1000
1002 | 2016-02-15 00:00:00 | 500
1003 | 2016-03-18 00:00:00 | 2000
1004 | 2016-03-19 00:00:00 | 1500
1005 | 2016-06-04 00:00:00 | 400
1006 | 2016-06-05 00:00:00 | 3600
1007 | 2016-07-20 00:00:00 | -1200
1008 | 2016-07-29 00:00:00 | 800
1009 | 2016-08-03 00:00:00 | 900
1010 | 2016-08-16 00:00:00 | 1900
1011 | 2016-08-22 00:00:00 | 200
Spreadsheet: 772721d1647443962-data-pull-based-on-multiple-criteria-month-end-template
Sheet: Rates

Agency | T1/T2 | M1/M2 | M5 | M6 | Trainee | Op | IPV Op | [NAME] | IPV Foreman | TSCO | IPV  Dual Crew | 1 man & Van | 1 man & 3.5T | 2 men & 3.5T
Company A | 132 | 162 | 180 | 192 | 132 | 162 | 210 | 222 | 222 | 300 | 870 | 250 | 275 | 430
Company B | 116 | 135 | 135 | 150 | 138 | 162 | 216 | 204 | 222 | 275 | 895 | 240 | 270 | 440
Company C |  |  |  |  |  |  |  |  |  |  | 885 | 280 | 300 | 440
Company D |  |  |  |  |  |  |  |  |  | 395 | 1180 | 280 | 325 | 575
Spreadsheet: 715080d1611551583-return-value-with-multiple-conditions-copie-de-forum-excel-25-jan-2021
Sheet: Épargnes Inv.

1) | [NAME] for latest balance (cells D6 to D9) |  |  |  |  | Thanks again for taking the time:) !! I appreciate it!
2) | [NAME] to update CLOSING BALANCE after each deposit/withdrawal and ANNUAL REPORT (Column G)
3) | [NAME] to know profit loss on the "ANNUAL REPORT" (Column F)
 | Solde actuel des comptes: | RED | [NAME]??
 |  | BLUE
 |  | YELLOW
 |  | GREEN
DATE | Description | ACCOUNT | AMOUNT | BALANCE REPORT | PROFIT/ LOSS | CLOSING BALANCE
2020-01-10 00:00:00 | Deposit | AR | 200
2020-03-01 00:00:00 | Deposit | FT | 300
2020-03-05 00:00:00 | Withdrawal | AR | -30
2020-03-11 00:00:00 | Withdrawal | FT | -45
2020-03-13 00:00:00 | Withdrawal | AR | 20
2020-06-15 00:00:00 | Withdrawal | AR | -50
2020-06-15 00:00:00 | Withdrawal | FT | -60
2020-07-01 00:00:00 | Semestrial report (balance now at 200$) | AR | 0 | 200 | 60 |  | Expected result would be 200$ (cell G19 "140$" + cell F21 "60$")
2020-07-01 00:00:00 | Semestrial report (balance now at 280$) | FT | 0 | 320
2021-01-01 00:00:00 | Semestrial report (balance now at 270$) | AR |  | 270
2021-01-01 00:00:00 | Semestrial report (balance now at 350$) | FT |  | 350
Spreadsheet: 152703d1335473735-duplicating-spreadsheet-across-a-year-spread-sheet-backup
Sheet: Feb 12

2012-02-01 00:00:00
2012-02-02 00:00:00
2012-02-03 00:00:00
2012-02-04 00:00:00
2012-02-05 00:00:00
2012-02-06 00:00:00
2012-02-07 00:00:00
2012-02-08 00:00:00
2012-02-09 00:00:00
2012-02-10 00:00:00
2012-02-11 00:00:00
2012-02-12 00:00:00
2012-02-13 00:00:00
2012-02-14 00:00:00
2012-02-15 00:00:00
2012-02-16 00:00:00
2012-02-17 00:00:00
2012-02-18 00:00:00
2012-02-19 00:00:00
2012-02-20 00:00:00
2012-02-21 00:00:00
2012-02-22 00:00:00
2012-02-23 00:00:00
2012-02-24 00:00:00
2012-02-25 00:00:00
2012-02-26 00:00:00
2012-02-27 00:00:00
2012-02-28 00:00:00
2012-02-29 00:00:00
Spreadsheet: 30328d1225802208-count-on-filters-filtertots
Sheet: Sheet1

Orderdate | Customer | MonthCount | [NAME]
2008-01-01 00:00:00 | A | 0.25 | 200801
2008-01-05 00:00:00 | A | 0.25 | 200801
2008-01-09 00:00:00 | A | 0.25 | 200801
2008-01-13 00:00:00 | B | 0.25 | 200801
2008-01-17 00:00:00 | B | 0.25 | 200801
2008-01-21 00:00:00 | B | 0.25 | 200801
2008-01-25 00:00:00 | A | 0.25 | 200801
2008-01-29 00:00:00 | B | 0.25 | 200801
2008-02-02 00:00:00 | A | 1 | 200802
2008-02-06 00:00:00 | B | 1 | 200802
2008-02-10 00:00:00 | C | 0.5 | 200802
2008-02-14 00:00:00 | D | 0.5 | 200802
2008-02-18 00:00:00 | E | 1 | 200802
2008-02-22 00:00:00 | D | 0.5 | 200802
2008-02-26 00:00:00 | C | 0.5 | 200802
2008-03-01 00:00:00 | A | 0.5 | 200803
2008-03-05 00:00:00 | B | 0.5 | 200803
2008-03-09 00:00:00 | A | 0.5 | 200803
2008-03-13 00:00:00 | B | 0.5 | 200803
 | [NAME] month count: | 2
Spreadsheet: 218566d1362499982-using-lookup-function-to-retrieve-columns-of-info-vlookup-and-choose-example
Sheet: Sheet1

 |  | Day1 | Day2 | Day3
 | Jon | T1 | T3 | T2
 | [NAME] | T2 | T1 | T3
 | [NAME] | T3 | T2 | T1
 |  | Day1 | Day2 | Day3
 | T1
 | T2
 | T3
Spreadsheet: 779581d1651867629-auto-assignment-randomized-with-little-or-no-duplicates-activity-timeline-participant-planning-and-checklists
Sheet: Participant Checklist

Participant Name | Cycle | Region | Mentor | Judge 1 | Judge 2 | Judge 3
[NAME] | C1 | NA
Amanda | C1 | NA
[NAME] | C1 | NA
Heather | C1 | NA
[NAME] | C1 | NA
[NAME] | C1 | NA
Eliza | C1 | NA
[NAME] | C1 | NA
[NAME] | C1 | NA
[NAME] | C1 | NA
Min | C1 | APAC
Eddy | C1 | APAC
Calvin | C1 | APAC
Kazu | C1 | APAC
Sugi | C1 | APAC
Brent | C1 | APAC
Shailesh | C1 | APAC
Raj | C1 | APAC
Ruchir | C1 | APAC
Reshma | C1 | APAC
[NAME] | C2 | NA
[NAME] | C2 | NA
[NAME] | C2 | NA
Zya | C2 | NA
Ren | C2 | NA
[NAME] | C2 | NA
[NAME] | C2 | NA
[NAME] | C2 | NA
Sloan | C2 | NA
Tyler | C2 | NA
Nick | C2 | NA
[NAME] | C2 | NA
[NAME] | C2 | APAC
Naveen | C2 | APAC
[NAME] | C2 | APAC
[NAME] | C2 | APAC
[NAME] | C2 | APAC
Spreadsheet: eb76c2e2-fb3b-4720-9d72-c03a95ca4507
Sheet: 8

 | Jan 25 |  | Feb 1 |  | Feb 8 |  | Feb 15
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rate* | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs** | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly total, estimated swap dollar volumes by asset class and participant type (value of all trades in milliions of USD), all products and tenors, cleared and uncleared.
Estimates of weekly event volumes are derived from data published in the 2012 ISDA Operations Benchmarking Survey which defines an "event" as a new trade, confirmable amendment, partial or full termination, increase, decrease, or novation.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 716493d1612237147-return-a-sign-if-there-is-any-values-inside-the-month-if-not-a-sign-forum-excel-1-f-v-2021
Sheet: Projection

Note mensuelle: | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes
 |  |  | FORMULA?? |  |  |  |  |  |  |  |  |  |  |  | *
Sommaire estimé | Mois dernier | Ce mois-ci
Date début
Date fin
Solde de départ (peut modifier si nécessaire)
Revenu net
Dépenses
Avance Loyer/Int/Hydro/Trsf Inv. ($) |  |  | 100 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350
Paiement cartes de crédits($) |  |  | 200
Prêt Famille / Ami ($) |  |  | 0
Solde final (peut modifier si nécessaire)
Solde de fermeture
Tout +/- si besoin pour balancer
Revenus (défilé [NAME]) | Mois dernier | Ce mois-ci |  | février-2020 | mars-2020 | avril-2020 | mai-2020 | juin-2020 | juillet-2020 | août-2020 | septembre-2020 | octobre-2020 | novembre-2020 | décembre-2020 | janvier-2021 | février-2021 | mars-2021 | avril-2021 | mai-2021 | juin-2021 | juillet-2021 | août-2021 | septembre-2021 | octobre-2021 | novembre-2021 | décembre-2021 | janvier-2022 | [NAME] | mars-2022 | avril-2022 | mai-2022 | juin-2022 | juillet-2022 | août-2022 | septembre-2022 | octobre-2022 | novembre-2022 | décembre-2022
Autre
Crédit Solidarité Qc
Intérêt Banque
Paye travail
Paye vacance
Remb. Impot Canada
Remb. Impot Québec
[NAME]. prêt fam./ami
Remb. TPS
Retrait placement CÉLI
Retrait placement REER
Dépenses (défilé [NAME]) | Mois dernier | Ce mois-ci |  | février-2020 | mars-2020 | avril-2020 | mai-2020 | juin-2020 | juillet-2020 | août-2020 | septembre-2020 | octobre-2020 | novembre-2020 | décembre-2020 | janvier-2021 | février-2021 | mars-2021 | avril-2021 | mai-2021 | juin-2021 | juillet-2021 | août-2021 | septembre-2021 | octobre-2021 | novembre-2021 | décembre-2021 | janvier-2022 | [NAME] | mars-2022 | avril-2022 | mai-2022 | juin-2022 | juillet-2022 | août-2022 | septembre-2022 | octobre-2022 | novembre-2022 | décembre-2022
Assurance auto
Assurance habitation
Autre
Divertissement
[NAME]/chauffage
Épicerie
Essence
Facture médicament
Forfait cellulaire
Impôt retenu Canada
Impôt retenu Québec
Internet
Logement
Paiement avance
Permis conduire
Plaque immatriculation
Prêt famille/amis
[NAME]. Commerçant
Réparation / entretien auto
Restaurant
[NAME] (thérapeute divers)
Transfert cpt. Ép./Inv./Urg.
Vacance/voyage
 | Past | Actual | Past
Épargne et inv.  (défilé [NAME]) | Last month | This month | 2020-01-01 00:00:00
AR
FT
PL
UR
Spreadsheet: 80049d1280277614-populate-cell-value-automatically-between-different-tabs-populatecell
Sheet: Populated Table

 | [NAME]'s Ref # | Location | Year
1 |  |  | 2045
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
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
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
 |  |  | Totals
Spreadsheet: hunter_shively__12724__Fundamentals_Netco
Sheet: Cash Ops

 | Cash Operations
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Reporting, GL, Trading & Transaction Support |  |  |  |  | Cash Operations
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  | % of |  |  | Per HC | New HC | Adj Comp |  |  | Per HC | New HC | Adj Comp |  |  |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  | Total Exp |  |  |  |  |  |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  | 0 |  |  |  | Compensation | 0 |  |  |  | Compensation | 0
 | Analyst & Assoicate | 0 |  |  | 0
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  | 1.2
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  | Other |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services | 0 |  |  | 330000 |  |  |  | Total |  |  |  |  | Total
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  | [NAME] |  | 0 |  |  | [NAME] |  | 0
ENARENT | Rent |  |  |  |  |  |  |  | Admins |  | 3 |  |  | Admins |  | 2
ENATECH | Technology |  |  |  |  |  |  |  | Staff | 49200 | 1 |  |  | Staff | 49200 | 1
ENATRANS | Transportation |  |  |  |  |  |  |  | Analysts | 57600 | 3 |  |  | Analysts | 57600 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Specialist | 62400 | 12 |  |  | Specialist | 62400 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  | Sr Specialist | 74400 | 8 |  |  | Sr Specialist | 74400 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | Managers | 90000 | 10 |  |  | Managers | 90000 | 1
 |  |  |  |  |  |  |  |  | Directors | 120000 | 4 |  |  | Directors | 120000 | 1
 | Headcount |  |  | 99 |  |  |  |  | Sr Director | 174000 | 1 |  |  | Sr Director | 174000 | 1
 |  |  |  |  |  |  |  |  | Vice President | 216000 | 3 |  |  | Vice President | 216000 | 0
 | A&A Headcount |  |  | 4 | 0 |  |  |  | [NAME] | 312000 | 1 |  |  | [NAME] | 312000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2 |  | Benefits & Taxes |  |  | 0.2
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development |  |  |  |  |  |  |  | Other Expense Calculation
ENACORIT | Controllable Infrastructure |  |  |  |  |  |  |  | Reporting, GL, Trading & Transaction Support
ENACORRN | Corporate Rent |  |  |  |  |  |  |  | Total Misc Exp |  | Old HC | Exp/Old HC | New HC | Exp/New HC
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  |  |  |  |  |  |  |  | 46 |  | This was adjusted up 600,000
ENADEPR | Depreciation & Amortization |  |  |  |  |  |  |  |  |  |  |  |  |  | for Audit fees during the year.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | It was also adjusted 704,684
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | to get to a total of 7,000,000
 |  |  |  |  |  |  |  |  | Cash Operations |  |  |  |  |  | for the BA&R group.
 |  |  |  |  |  |  |  |  | Total Misc Exp |  | Old HC | Exp/Old HC | New HC | Exp/New HC
 |  |  |  |  |  |  |  |  |  |  | 103 |  | 7 |  | This was adjusted up 360,000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | for consulting fees during the year.
Spreadsheet: 90290d1290037295-lookup-with-multiple-criteria-exampleworkbook
Sheet: Sheet2

 | Mon | Mon | Mon | Mon | Mon | Mon | Mon | Mon | Tue | Tue | Tue | Tue | Tue | Tue | Tue | Tue | Wed | Wed | Wed | Wed | Wed | Wed | Wed | Wed | Thu | Thu | Thu | Thu | Thu | Thu | Thu | Thu | Fri | Fri | Fri | Fri | Fri | Fri | Fri | Fri
Room | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00
A007
A011
A014
A023
A025
[NAME]
Spreadsheet: 820535d1678152789-extracting-details-from-a-row-that-matches-criteria-and-inserting-into-another-sheet-sample-2023-03-03t212910-atombomb99-
Sheet: Sheet1

 | Staff member | Overdue Mandatory |  |  | (Dropdown slection box below in F5)
 |  |  |  |  | User, testing | Mandatory courses overdue | Was due By
 | TOTALS
 |  |  |  |  |  | None Renewable courses taken